ValuePRO Excel templates allows the ability to update the value of a field on the jobs card based on a calculated cell in the Excel template. This allows complex calculation to occur on Excel and save the output direct into ValuePRO. This is controlled using the Comments feature in MS Excel. The format of the comments needs to be “VPRightBack.TableName.FieldName” where “VPRightBack.” is the trigger to know that the value of the cell needs to update a field in ValuePRO and the “TableNames.FieldName” this the field in ValuePRO.
Step 1
In ValuePRO identify the field that needs to be updated from the excel template/model. You can use the Field card to identify the “TableNames” and “FieldName” of the respective field.
Step 2
In the MS Excel template select the cell you want to write back from and then go to Review -> Add Comment OR right click on the cell and click Add Comment. In the comment box, type “VPRightBack.Valuations.TotalPropertyAreas” (based on the above example). Once done upload the excel template into the system.
Step 3
Upload the Excel Template into the system. Make sure you tick the 'Always Run VPRightBack Automatically' setting in the report template settings panel to enable the RightBack function.
Step 4
Go to your job card and select the Excel template as the chosen report. Press the 'Calculate' or 'Generate Model' button on the job card.
When the Excel template is generated either via the “Generate Report”, “Generate Model” or "Calculate" button on the job card, the mapped cell will update the respective field with the calculated value.