The spreadsheet tab enables you to make up any worksheet in your external spreadsheet application (such as Microsoft Excel) and store the workings to support any aspect of your job within.
This feature is ideal to store measurement take-offs, rate build up and valuation calculations, side cast calculations and so on.
The advantage of using spreadsheets to store these calculations is that there is no fixed format to any of your workings. For example, if you are measuring from drawings, you can choose to record your dimensions horizontally or vertically; generate your own column headings; and make your own macros in the spreadsheet package to suit your needs.
Additionally, one spreadsheet file or worksheet can contain the workings for any number of items in your job. You can copy selected cells from the spreadsheet application and paste them in your spreadsheet tab.
This section shows you how to open a typical spreadsheet application, make up simple calculations and paste the results into Valesco. Once the data has been copied to Valesco you can use basic functions to add, subtract, multiply and divide values in the spreadsheet tab.
The example shown here demonstrates the use of the spreadsheet to record measurements, but exactly the same processes apply to using the spreadsheet for pricing, too.