The worksheet collates measurements for a project and displays them by stages. Add parts, edit formula and Labour as well as quantify additional Items and labour within a stage.
Add parts and labour to existing measurements
Parts and labour can be added to existing measurements, allowing them to be quantified at the same time. Groundplan allows the grouping of parts and labour on the quantities tab.
📝Note: Grouping parts / labour
To group, upon creation they must have identical part numbers, descriptions and unit of measure, including capitals, spelling, spacing and blank boxes. More in-depth information about grouping can be found in the Adding parts and labour to measurements article.
Click measurement name
Click +part and select part OR +labour
Complete the required details for the part and/or labour, including any formula required
Click save
📝Note: Excel-style formula can be used in combination with the part to build product amounts.
E.g., count*5 is calculating 5m of cable for each light counted (unit of measure = m), labour - install count*0.75 is calculating 45 minutes for each light counted. See our article on How Formulas work in Groundplan for further information.
Additional items and labour
Additional items and labour can be added at stage level. Commonly, they are items not recorded on plans or already accounted for in existing measurement/parts.
Example:
Items - escavator hire, tarps, sundries, design fees
Labour - contractor labour, specialist labour
Click +additional item and select part OR click +additional labour
Complete the required details for part and/or labour, including any formula required
Click create
Show build totals
Show build totals is a display view that shows all parts and labour with associated quantities connected to each measurement. Use this view when reviewing parts and labour and add / edit / remove if required.
Click options
Click show build totals
Show totals by plan
Totals by plan is a display view that shows stage measurements along with the associated plan names and quantities where they are recorded.
Click options
Click show totals by plan, clicking the plan name will navigate to the plan
Video
Frequently Asked Questions
Can you create a take-off template from the worksheet tab?
Can you create a take-off template from the worksheet tab?
Yes.
Click the stage actions then click copy to new template.
Can you download the worksheet tab into a CSV file?
Can you download the worksheet tab into a CSV file?
No, unfortunately not.
Is there any way to save the worksheet as a PDF instead?
Is there any way to save the worksheet as a PDF instead?
Yes.
Press CTRL or ⌘ + P on your keyboard, everything showing on the screen will be saved as well. If you enable show totals by pan or show build totals will also reflect in the saved PDF file
Set the destination to save as PDF
Click save
When reviewing the worksheet tab, can I open the relevant plan where a measurement is counted rather than sifting through the plans?
When reviewing the worksheet tab, can I open the relevant plan where a measurement is counted rather than sifting through the plans?
Yes.
When you select show totals by plan in the worksheet options, view the total per plan and click the plan name to navigate to the plan.
I have a lot of stages. How can I find a stage without having to click the next or previous button and scroll to search?
I have a lot of stages. How can I find a stage without having to click the next or previous button and scroll to search?
Use jump to stage at the top of the page to immediately move to the required stage.
Is it possible to view all my stages without having to scroll or use the previous and next buttons?
Is it possible to view all my stages without having to scroll or use the previous and next buttons?
Yes.
The default number of stages displayed per page is set to 5. depending on the number of stages you have, you can increase the number of stages that can be shown on the page. Click per page and select from 1 - 20.
The stages are linked together in all plans, however, I want to add a multiplier to the quantities on a particular plan. Is this possible?
The stages are linked together in all plans, however, I want to add a multiplier to the quantities on a particular plan. Is this possible?
Yes.
You can set a multiplier on specific plans from the worksheet tab.
Click stage actions and select edit
Tick set multiplier on each plan
Enter the appropriate multiplier for each plan
Click save
📝Note: An asterisk next to multiplying number ( eg. x3*) indicates that plans linked to that stage have different multipliers.
What should I do if some of the images on my worksheet are not showing?
What should I do if some of the images on my worksheet are not showing?
Check your browser is the current version, if it isn't, update the browser and if required, refresh your page
If it is still not working, please clear your browser cache.
Here's a guide for how to clear cache for each popular browser:
If it is still not working, please contact us via Help > Send us Message with the project name, stage and measurement/s where the symbol is not showing and we can investigate further for you.