Worksheet Tab
  • 17 Sep 2024
  • 3 Minutes to read
  • Dark
    Light
  • PDF

Worksheet Tab

  • Dark
    Light
  • PDF

Article summary

The Worksheet collates Measurements for a Project and displays them by Stages. Also in this article is how to quantify additional Parts and Labour, 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.

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 indepth information about Grouping can be found in the Measurement Parts and Labour Article.

measurement-parts-labour-example.png

  1. Click Measurement name

worksheet-adding-part-labour.png

  1. Click +Part and select Part OR +Labour

worksheet-adding-parts-labour-to-existing.png

  1. Complete the required details for the Part and/or Labour including any Formula required
  2. Click Save

worksheet-adding-parts-labour-2.png

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 1/2hr for each light counted. See our article on Using Formulas 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
  1. Click +Additional Item and select Part OR click +Additional Labour

worksheet-adding-additional-item-or-labour.png

  1. Complete the required details for Part and/or Labour including any Formula required
  2. Click Create

worksheet-additional-labour-item-examples.png

worksheet-additional-items-worksheet.png

Show Build Totals

Build Totals shows all Parts and Labour with associated quantities connected to each Measurement.

  1. Click Options
  2. Click Show Build Totals

worksheet-show-build-totals.png

Show Totals by Plan

Stage Measurements are listed along with the associated Plan names and Quantities where they are recorded.

  1. Click Options
  2. Click Show Totals by Plan
    Clicking the Plan name will navigate to the Plan

worksheet-show-totals-by-plan.png

Video Tutorial

The Worksheet and Quantities Superuser Webinar explains using the Worksheet in detail.


Frequently Asked Questions

Can you create a Take-off Template from the Worksheet tab?

Yes. Click the Stage Actions then click Copy to new Template.

worksheet-faq-create-takeoff-template.png


Can you download the Worksheet Tab into a CSV file?

No.


Is there any way to print the Worksheet as a PDF instead?

Yes.

  1. Press CTRL or ⌘ + P on your keyboard

Everything showing on the screen will be printed as well. If you enable Show Totals by Plan or Show Build Totals will also reflect in the saved PDF file

  1. Set the Destination to Save as PDF
  2. Click Save

worksheet-faq-save-to-pdf.png


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.

worksheet-faq-quantities-on-plan.png


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 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?

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.

worksheet-faq-stages-per-page.png


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.

  1. Click Stage Actions and select Edit

worksheet-set-multiplier-per-plan.png

  1. Tick Set multiplier on each Plan
  2. Enter the appropriate Multiplier for each Plan
  3. Click Save

worksheet-set-multiplier-per-plan2.png

An asterisk next to multiplying number ( eg. x3*) indicates that Plans linked to that Stage have different multipliers.
worksheet-faq-multilpier.png


What should I do if some of the images on my Worksheet are not showing?

  1. Check your Browser is the current version, if it isn't, update the Browser and if required, refresh your page.

  2. If it is still not working... please clear your browser cache.
    Here's a guide for how to clear cache for each popular browser:
    Google Chrome, Mozilla Firefox, Safari (macOS), Edge (Microsoft).

  3. 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.






Was this article helpful?

What's Next