Can I open an older (Excel-based) version of EstateMaster DF and DM after installing the latest version?
Yes. For EstateMaster DF and DM, there is a function called 'Import from Previous Version' available to assist users with this. It allows you to transfer all current data into the latest version.
I have a 'circular reference' in the model. What does that mean?
When a formula refers back to its own cell, either directly or indirectly, it is called a ’circular reference’. Excel cannot automatically calculate all open workbooks when one of them contains a circular reference. For example, a formula which calculates mortgage stamp duty as a % of the maximum loan amount would create a circular reference as the mortgage stamp duty would be funded by the loan and thus increasing the maximum loan amount and the mortgage stamp duty. If you have created a circular reference, it is recommended that you undo your last actions until the reference error is removed.
Can I insert or hide cost or revenue input rows?
Yes. The user can expand or contract the size of the model by setting the number of Time Periods or the number of input rows for various cost and revenue sections. Refer to the Operations Manual for the specific product for more more information.
Can I insert blank worksheets in the model?
Yes. Blank worksheets can be inserted, named and deleted by using the ’Custom Worksheet’ function in the EstateMaster menu.
Can I link external information from another Excel workbook into EstateMaster?
Yes, using the 'Office Links - Excel' Integration Module. Having external links however is not recommended for beginner intermediate users. Usually it is more efficient to copy and paste the data into a blank worksheet within the EstateMaster file itself to avoid any possible linking problems.
Can I rename the heading of the Input sections?
Only headings that are coloured blue can be renamed.
Do the Land Tax and Stamp Duty tables get automatically updated?
These rates are only updated when a new version of the software is released. Between releases, it is the users responsibility to check and update these rates on a frequent basis.