valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 2058499
Questions & Answers
Q: I need to modify the valuation spreadsheet to better reflect our current situation - specifically with labelling / comments etc, but I am unable to. It says I have to unprotect the sheet but its password protected?
A: All of the blue shaded cell contents can be changed. This includes the labels on the Input sheet and all blue shaded cells elsewhere which are then carried through to all other sheets. As some of these include hyperlinks it is usually easier to tab into the cell than clicking it (as clicking takes you to the hyperlink). This allows you to refine descriptions to suit. If you want to completely modify to a specific layout / format you can create your own input workbook (ie new workbook) and build your own input interface sheet and simply link your inputs from this workbook to the corresponding input in the valuation workbook ie goto the valuation input cell and type = and then click the required cell in your own workbook input sheet. The same approach (in reverse) can be used to customise the outputs if needed.
Question and Answer Item 2058499 - Browse All Question and Answer Items