-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Time series forecasting in Access
- Thread starter SKV
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
I've done a bit of it. Is the forecasting flat (eg take annual figure and spread 1/12 to each month) or are there increments (eg correct for CPI every 3 months)?
Generally, you need a form where you set up the items, total value, amount to spread (could be less than total is you already have actual data), start month, end month.
Then loop through that table, spreading across the interval from start month to end month and writing values out to a forecast table.
By having categories for the items you can then create a grouped report showing detail and summary by category, by month.
Denis
Generally, you need a form where you set up the items, total value, amount to spread (could be less than total is you already have actual data), start month, end month.
Then loop through that table, spreading across the interval from start month to end month and writing values out to a forecast table.
By having categories for the items you can then create a grouped report showing detail and summary by category, by month.
Denis
Upvote
0
Similar threads
- Solved
- Solved
