After watching your video on the Construction Draw tab, On the most current version, I was not able to find where you can use a drop down menu to account for a manual or s-curve feature. In addition, not able to change the steepness of the s-curve as well… I’m I missing something..
Not sure why you’re unable to see it but here are the step by step directions:
1) Turn on the development module by entering a value greater than 0 in cell M13 of the Summary tab
2) Go to the Budget tab
3) Open the budget rows by either clicking the ‘Plus’ signs to the left of the Row labels or clicking the box labeled ‘2’ immediately to the left of the ‘A’ column label
4) Once inside the detailed budget rows, change the forecast method in column D of the Budget tab; change the steepness of the S-Curve by changing the S-Curve Rate in column G of the Budget tab
There is a drop-down in cell C8 (see attached screenshot). I think the issue may be because of how columns A-C are setup. Columns A-C on the budget tab are frozen in place and so if your cursor has moved the unfrozen columns out to the right, the drop-down menu won’t appear. Just make sure column D appears immediately to the right of column C on your screen and the drop-down menu should appear.
Here is a video of my screen… Can it be a setting on the Excel file? See attached video… Sorry to bother you on this, just trying to grasp the complexity of your work…thanks!
Hmmm. That’s really odd! Perhaps a compatibility issue? What version of Excel and what operating system are you using? Another thing to try: mouse into C8, then while holding down the ALT key, press the down arrow. Does the menu appear then?
My guess is that Excel 2007 is the issue. I built the model in a more recent version (Excel 2013 and 2016) and Microsoft has added quite a few new functions since 2007.Perhaps drop-down menus linked to named ranges (like in C8) aren’t compatible with 2007 either.
