How do I create a VERY complicated spreadsheet?

K

Kerri

We recently changed from Movex system to Dynamics system and the managers
want to see a report exactly how they saw in the old system. I need to create
a sheet that breaks down by each Business Area showing number of open order
lines, value of the open order lines, past due lines, past due dollar value,
% of lines past due and % of $ past due. They also want to see the projected
dollar value 5 days out, by the request date (of the order), lines requested,
and total net price.

Finally, on this same sheet, they want the break down "Per Day - Each
Business" (# of lines, and $ value) for 10 days, including today and the
totals of all the days.

Can anybody give me some guidance? I just don't know where to start.

Thanks so much in advance!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using a formula to create an ordered purchase order 5
How to retrieve data from a table 1
how do i set up a horizontal spreadsheet? 2
how do i get a cell in a spreadsheet to enter in a different cell 1
How do I create a task from conditional formatting? 1
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Excel Home made rota system- creating a time sheet in relation to demand 0
Complicated lookup 2

Top