You can - ideally you would start with a file that has dates out into the future, all in one column. Your start date could be a parameter. It kind of depends what the format of the data is that you are starting with.
Thanks Alex : The data comes in four columns: a start date, an end date (that usually covers 36 to 60 months), the first annual amount & the escalation rate.
I currently do this in Excel, using a VBA script to split this into multiple columns with dates going along the header row, & then summing up the fiscal years..
1 of 1 people found this helpful
You'll need a different approach - ideally feeding a row per date you need
I'm continuing to use my VBA skills to shape the data into a row per date - until such time that IT support create a report for me (and I'm not holding my breath on that).
While messing around with the forecasting (I've been listening to the TDT forecasting video, which was awesome), I tried my hand at this.
1. What I notice is that the grand totals feature for columns works fine as long as the fiscal year start is set to Jan. If I change that to April, the totals don't make sense.
2. When I add another dimension to the forecast (Item), no forecast is computed. I can't understand why..
Do you have any ideas?
Rhetorical question: Is there anything @joemako can't do?
I reached out to Joe yesterday with the original question, & he took 2 hours out of his evening to build a forecast model given:
1. An identifier
2. A start date
3. An end date
4. Base rent
5. Escalation rate
There's no way I can describe the techniques Joe employed to create this visualization (magic?), but I've shared here the workbook he created with the certainty that someone will have use for it. (How many analysts have to perform some form of forecasts?)
Thanks again, Joe Mako - maybe you'll demonstrate the techniques in your next TDT?
The specified item was not found. Tracy Rodgers
forecast jm edit.twbx.zip 54.8 KB