Add valuation schedules to a project - online guide
Add valuation schedules to a project - text guide
Select 'Projects' from the navigation menu on the left.
Find the Project you wish to add a valuation schedule to, either from the list or by filtering/searching from the top and select it
You'll be taken to the Details page of the Project, select the Valuation Schedules tab.
Input your start and end dates. You can also input your target date which is the date the project is due to finish. This can be helpful if your end date changes as you will need to return to this page and change it to recalculate dates, but you will have a record of your original intended finish date
Check that you have the correct Bank holiday region selected, then click 'Add Schedule'.
Within the table that has appeared, input the Schedule name. We recommend you name it something in reference to the valuation period e.g. Monthly, fortnightly etc
Next choose the Valuation Period, either Months or weeks and then the number of periods in the month or number of weeks in each valuation period. If you wanted a monthly valuation schedule you'd select 'Months' and '1' in Periods in the month, or if you wanted fortnightly, you'd select 'Weeks' and then '2' in Number of weeks
Next, you'll input the valuation day if you have selected months, or it will be pre-filled with the start date if selecting weeks. If you have selected multiple periods in the month, you will have the option to set when each of these periods ends. If you input 31 for example, this will always fall on the last day of the month
The Submission days before/after the Valuation Date refers to the date subcontractors will need to have submitted their applications by e.g.
'0' would set it on the same day as the Valuation date. '-2' would set the Submission date two days prior to the Valuation date '2' would give the Subcontractor two days after the Valuation day to submit.
You'll see three checkboxes that will determine whether Weekends and Bank holidays are included in the date calculations, as well as if you want dates to move forward or backwards when there are clashes.
Move Date Forward on Clash
The Move Date Forward on Clash option controls whether the calculated Submission Date moves backwards or forwards when the calculated Submission Date falls on a weekend and the Include Weekend Dates option has NOT been selected, or when the calculated Submission Date falls on a Bank Holiday and the Include Bank Holidays option has NOT been selected.
When the Move Date Forward on Clash option is NOT selected, the calculated Submission Date will automatically move the date backwards, unless the Include Weekend Dates option, or the Include Bank Holidays have been selected.
Advice and Guidance
When the calculated Submission Date falls on a weekend, and the Include Weekend Dates option has been selected, the calculated Submission Date will remain on the weekend date, or when the calculated Submission Date falls on a Bank Holiday, and the Include Bank Holidays option has been selected, the calculated Submission Date will remain on the Bank Holiday date.
Include Weekend Dates
Weekend Dates are defined as those Saturday and Sunday non-working weekend days for the duration of the project.
When the Include Weekend Days option is ticked, this means that these weekend days WILL BE INCLUDED in the calculation of the Submission Date.
When the Include Weekend Days option is NOT ticked, this means that these weekend days WILL BE EXCLUDED in the calculation of the Submission Date.
Include Bank Holidays
Bank Holidays are defined in the selected Bank Holiday Region for the duration of the project.
When the Include Bank Holidays is ticked, this means that these non-working days WILL BE INCLUDED in the calculation of the Submission Date.
When the Include Bank Holidays is NOT ticked, this means that these non-working days WILL BE EXCLUDED in the calculation of the Submission Date.
Once you've inputted the details, click 'Calculate Dates'. You'll need to click this each time after making any changes to the fields.
The table will be populated with dates based on your selections. You can edit individual dates, if necessary, simply by clicking on the date within the box, choosing the new date and selecting 'Confirm'. This is possible throughout the lifetime of the Project as long as the date has not already passed. You will see a key at the bottom of each schedule.
Once you are happy with your schedule, go to the top right of the page and select 'Save'. Any time you make changes on this page, you will need to perform a save for them to take effect.
You can now navigate back to this Valuation schedule page to change the default Schedule. This will be selectable from the drop-down box.
If you would like to see some examples of Valuation Schedules, please follow the online tutorial above.