Forum Discussion
innovative way to display data
You wrote:
My question is
Is there any way to present the above date to be clear or understandable for anyone?
I hope you got my point.
And yes, you made your point. But the thing I don't understand is why you--the specialist in this field--need to ask "is there a way to present the above data to be clear for anyone." You would be expected to lay out the data in a way that's clear, not just pointing to the pieces of data. I can tell you how to use excel to take data elements from your spreadsheet and array it in a manner that's clear, but I need YOU to tell me how that data could be arrayed so as to be clear and understandable to anyone. Not just point to the data and ask if it can be done.
So my question back to you: is there any way for YOU to create a dummy display demonstrating how the data could be arrayed so as to be clear and understandable. I'm NOT asking you to come up with the Excel instructions, that the job of the Excel experts. But I am asking you to create a clear and understandable display of the relevant data, doing it manually....I assume you want this to be for your clients, or for a customer service rep or the like. What would be helpful to them, how would it be arranged. I think the Excel part is going to be fairly easy.....but you need to be the one to come up with at least an initial creative and clear display of the information you want to show.
i put some reports in the attached file
- Sheet (Dues) i need to add formulas to sum the total collected (F) from sheet collection details and settle the first dues based on earliest dues till consume the total collection, also i need to calculate the culumns from (H:L) based on the due dates and the monthly closing date lets say 31-03-2022
- Sheet aging for ar balances, i need to calculate the Ar balances (sheet dues Culumn G) and the critira range will be project culumn (A) and the due date (E)
- Sheet Delayed AR balances to calculate the delayed dues (AR balance in sheet dues_G) based on the due date in sheet dues
- sheet unit reprt i need to filter by unit to show all details related to the unit.
I know I'm bothering you, but I need help, even with an idea
Thanks You
hussein_elsayed Let me know if this set of results makes sense, if the numbers are what you'd expect.
I am using the new FILTER function which requires the most recent version of Excel.
My guess is that you'd be well served in the other reports as well with the FILTER function. Here's a YouTube Video that explains it. https://www.youtube.com/watch?v=9I9DtFOVPIg
- Is there any way to consume the dues amount based on total collection from the collection details sheet to be consumed from earliest due date till consuming the total collection in the collection details sheet
I'm sorry: I don't understand the question. I realize English may not be your first language, but I'm not really able to figure what you mean by "consume" and its variations.
May I ask if the work I did send you made any sense. Or is it there that you're looking for total dollars owed in the various categories of delayed payment?
