CONFIGURING YOUR TEMPLATE

​​F1. CIRCULAR REFERENCES:

Firstly lets fix the circular references issue as follows:

PC: Excel-> Options -> Formulas -> Enable iterative calculation.  Set the maximum iterations to 50 and the Maximum Change to 1.

MAC: Excel Application -> Excel -> Preferences-> Calculation -> Enable iterative calculation.  Set maximum iterations to 50 and Maximum Change to 1.


F2. SAVE TEMPLATE FILE:

You don't want to have to add the store 'Add-In' and then the license every time you start a new appraisal.  This proces saves you time:

  • Go to the File menu in Excel and select 'Save As'

  • Click 'Browse' and you will see a pop up window.


  • Change the 'Save as type' box to 'Excel Template (*.xltx)'.

  • Go to the folder where your template is saved and save over the original template file. 
    If you are on Windows, not Mac and have installed the template using the setup program above, then this file will be:
    DOCUMENTS -> V8DEVELOPER -> EXCEL_TEMPLATE -> V8-developer-master.xltx

  • Find this file, click on it and then click 'Save'. Say yes to replace the original. Do NOT just save it anywhere or you will get confused as to which is the latest master template.   (If you have installed manually or are on a Mac, you just need to find where you put the V8-developer-master.xltx file.)

  • IMPORTANT: Now quit Excel completely!!!



F3. STARTING A NEW PROJECT

Windows:  Double click on the V8Developer desk top icon short cut. 

MAC: Open the template file from where you saved it.

Next Step >