| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forecasting
I have some data that I'd like to provide forecasting for, but it's in 2
levels when broken out into a pivot table, example: DATE - BUSINESS - SALES 12/1/05 - BUSINESS1 - $5000 12/1/05 - BUSINESS2 - $6000 12/2/05 - BUSINESS1 - $3000 12/2/05 - BUSINESS2 - $8000 Unfortunately, my detail data comes to me in much the same form, by date, by business, all in those 3 columns. Is there a way that I can still provide forecasting on this data in this kind of setup? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Forecasting
Try forecasting based on the sum of the businesses. If you produce linear
forecasts for each business separately, in the end you will have to add them anyway. -- Gary's Student "BlockNinja" wrote: I have some data that I'd like to provide forecasting for, but it's in 2 levels when broken out into a pivot table, example: DATE - BUSINESS - SALES 12/1/05 - BUSINESS1 - $5000 12/1/05 - BUSINESS2 - $6000 12/2/05 - BUSINESS1 - $3000 12/2/05 - BUSINESS2 - $8000 Unfortunately, my detail data comes to me in much the same form, by date, by business, all in those 3 columns. Is there a way that I can still provide forecasting on this data in this kind of setup? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Forecasting
Sounds like a plan, except that what if the business wants these forecasts
out in detail? (i.e. they want to know the specific forecast of their "Major" businesses, etc etc) "Gary''s Student" wrote: Try forecasting based on the sum of the businesses. If you produce linear forecasts for each business separately, in the end you will have to add them anyway. -- Gary's Student "BlockNinja" wrote: I have some data that I'd like to provide forecasting for, but it's in 2 levels when broken out into a pivot table, example: DATE - BUSINESS - SALES 12/1/05 - BUSINESS1 - $5000 12/1/05 - BUSINESS2 - $6000 12/2/05 - BUSINESS1 - $3000 12/2/05 - BUSINESS2 - $8000 Unfortunately, my detail data comes to me in much the same form, by date, by business, all in those 3 columns. Is there a way that I can still provide forecasting on this data in this kind of setup? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forecasting using arrays | Excel Worksheet Functions | |||
| Forecasting weekday occupancy between two years | Excel Worksheet Functions | |||
| Forecasting By Date | Excel Discussion (Misc queries) | |||
| FAO Conrad Calberg (Excel Sales Forecasting...) | Excel Discussion (Misc queries) | |||
| Excel Solver background in forecasting modeling | Excel Worksheet Functions | |||
Linear Mode
