FAQ - Viewing Results

Viewing Results

Q: The numbers on the Summary report do not add up to the Input sheet? 
A: If the numbers on the two sheets do not correlate, do the following:

• Make sure you check the summary sheet against the ’Total Escalated Cost/Revenue’ column not ’Total Current Cost/Revenue’ column.
• Make sure the data has been updated by pressing F9.

Q: Can I hide any of the outputs on the Summary or Cash Flow reports?
A: Any row on the ’Summary’ sheet can be hidden if not required by deselecting the appropriate tick box and using the ’Hide Rows’ function. The hidden rows can be reset by using the ’Show Rows’ function. A 'View Options' function is available on the Cash Flow reports to hide/show cash flow detail for each section.
 
Q: When I view the reports, numbers have been replaced with '####' in the cells?
A: The size of your monitor, its current resolution settings or the Excel page zoom may cause '######' to appear instead of numbers. Run a Print Preview to check to see if the numbers appear when printed. If they do, change the Excel page zoom until you can view the data. If they don't appear, check your inputs to make sure you have not accidentally entered incorrect data or contact Estate Master for assistance.