From the estimating menu select Spreadsheet validation checker.

This opens new window start by selecting the Open tab this opens local files to locate the spreadsheet for validating;

Other tabs used in this process are as follows

Save –

Validate Date –

Validate Doorsets

Process -

Choose from the local files the customers spreadsheet for validation.

The spreadsheet is now imported select the Validate data tab.

Example here shows the validate data tab has gone RED this means there are errors within the data that need to be corrected before proceeding.

Check the whole spreadsheet for RED highlighted errors.

Select the Validate Doorset tab when this is RED it is due to errors within the doorset

Select the comments in the highlighted cell this will reveal the error and what needs to be checked continue to check the whole sheet for these comments and fix before proceeding.

If process is selected at this time this pop up message appears, as the errors have NOT be corrected do not proceed with importing as it will not be easy to identify the 26 ( example here) that still need to be imported later, select NO fix the errors then re-run the validation tabs.