The Cost Calculator is flexible tool calculating a numerical field, such as Estimated Loss.
It allows an administrator to upload an excel spreadsheet and nominate the cell from which a numerical figure is to be extracted. The end user can then use a systemised version of the spreadsheet (i.e. without needing excel) to work through a set process for calculating Estimated Loss (for example).
To upload a template, click on Content > Cost Calculator
Form this page you can add, edit or delete a template.
Adding or Editing a template presents you with this page:
Add in you calculator name and in the description, what it should be used for. In the Record Types dropdown, select which record type this calculator is appropriate for - such as Action or Incident. Use the Template Selection area to upload your document by clicking on the Select File button .
Once your excel file has been uploaded, then it is converted and shown within the Template Preview section. Once converted, select the cell that you would like to extract for use within Arctick.
Then click on Create or Save.