Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
projections
We recieve income from 50+ vendors. Most of our $$ comes from the top 10
vendors. Generally speaking we get around the say amount of money around the same time of month from each vendor. I'm looking for a way to setup a chart or table to show a projected amount of $$ we should be expecting for a given week. I'm somewhat at a loss as where to start and was hoping someone could at least head me in the right direction. I dont know if this is something I would need to build from scratch or if there is an Excel tool that already does this type of thing. Any help will be appreciated. Jordan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
projections
In B1 enter the income received from Oct 1 thru Oct 7
In B2 enter the income received from Oct 8 thru Oct 14 In B3 enter the income received from Oct 15 thru Oct 21 In B4 enter the income received from Oct 22 thru end of Oct In C1 thru C4 do the same for Sept. Continue going backwards in time until column K is filled. Finally in A1 enter: =AVERAGE(B1:K1) and copy down thru A4. If data is missing in cols B thru K, leave the cell blank rather than enter a zero. -- Gary''s Student - gsnu200908 "Jordan" wrote: We recieve income from 50+ vendors. Most of our $$ comes from the top 10 vendors. Generally speaking we get around the say amount of money around the same time of month from each vendor. I'm looking for a way to setup a chart or table to show a projected amount of $$ we should be expecting for a given week. I'm somewhat at a loss as where to start and was hoping someone could at least head me in the right direction. I dont know if this is something I would need to build from scratch or if there is an Excel tool that already does this type of thing. Any help will be appreciated. Jordan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need benefit budget projections template | Excel Worksheet Functions | |||
Dotted lines for projections in graph | Excel Worksheet Functions | |||
Projections Formula | Excel Worksheet Functions | |||
Projections | Charts and Charting in Excel | |||
Trendlines, best fit and projections | Charts and Charting in Excel |