Contents x
    Quantities Tab
    • 29 Oct 2023
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Quantities Tab

    • Updated on 29 Oct 2023
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    The Quantities Tab displays your bill of materials for a Project after a Formula has been applied. Export Options to extract all Project Quantities from Groundplan are discussed in this article.

    The Options shown in the drop down menu is for on-screen display only. Unchecking Quantity Options will not reflect in the columns Exported on the CSV. They will all be produced within the Export. See our FAQ's about removing columns.

    quantities-showing options.png

    Options for Exporting Quantities to CSV

    1. Click Export
    2. Click Export as CSV

    quantities-exporting-csv.png

    1. Select an Export format

    Unit Cost, Unit Markup, Unit Price, Total Cost, Total Margin and Total Price values are shown on all Export options

    Grouped byColumn Length & Area Breakdowns are shown inColumn Stage Multipliers are shown in
    Grouped by StageStage > Part / LabourNotesNotes on Length & Area Breakdowns
    Grouped by Plan then StagePlan > Stage > Part / LabourNotes and Adjusted Values if presentMultiplier
    Grouped by MeasurementStage > Measurement > Part / LabourDescriptionDescription on Length & Area Breakdowns
    Formatted (original)Visually similar to Quantites TabNotesNotes on Length & Area Breakdowns

    quantities-exporting-csv2.png

    1. Click Download Export

    Viewing Parts / Labour and Length / Area Breakdowns

    Parts and Labour Totals are grouped by Stage/s. Formulas are included in these figures.

    To show individual Length and/or Areas and Grouped Parts / Labour breakdowns, lock the breakdown to display on Export.

    1. Click + on the Part / Labour line with the breakdown
    2. Click + next to Measurement name and click the Padlock

    quantities-viewing-breakdown.png

    1. Click Export and select Export as CSV
    2. Choose the Export format
      View the breakdown in the Notes Column or for Group by Measurement, the breakdown will appear in the Description Column
    3. Click Download Export then open

    quantities-viewing-breakdown-csv.png


    Video Tutorial

    Watch our Super User Series, Worksheets and Quantities for a deep dive into the Worksheet and Quantities.


    Frequently Asked Questions

    When I Export, I don't want the Margin or Unit Price columns to show. How can I change this?

    Unit Cost, Unit Markup, Unit Price, Total Cost, Total Margin and Total Price values are shown on all Export options. To combat this, remove columns from your Export in the program of your choice.

    Open the document in the program it downloads into e.g Excel or Numbers (for some Macs):

    1. Highlight the columns to remove
    2. Tap DELETE on your keyboard


    Can you select certain Stages to be exported to CSV rather than the whole project?

    No. You would need to edit the CSV file once exported from Groundplan.


    Why are the numbers different on the Quantities and Worksheet tabs?

    The Worksheet shows all Measurement and the measured Totals from Plans.

    The Quantities tab shows all Parts and Labour Totals after any Formula has been applied.


    I have added additional Parts and Labour into Measurements, but they are not grouped together on the Quantities tab. How can I fix this?

    Ensure when a Part is created, they must have identical Part Numbers, Descriptions, Unit of Measure, including capitals, spelling, spacing and blank boxes to the Part you want it Grouped with.

    worksheet-grouping-items-requirements.png

    The example below shows a space between the 5mm in one image and not in the other. This causes the items to not Group on the Quantities tab. When creating a new Once-Off item, the fields must be identical, or the items won't Group.
    quantities-grouping error.png

    To fix a non-Grouped item:

    1. Enter the Measurement
    2. Create a new Part or Labour ensuring all sections above are identical and matching from the other Measurement
    3. Delete the original part that did not Group
    4. Check the items have Grouped on the Quantities tab

    For further information, please refer to our specific section on How to fix Parts/Labour Groupings.


    I downloaded the .CSV file; however, all the data is in one column rather than being formatted as in the preview.

    This is due to settings within Excel.
    To make the document appear correctly, please follow these steps:

    1. In Excel, go to the Data tab
    2. Click Text to Columns once the file is open in Excel

    quantities-faq-text-columns.png



    Was this article helpful?
    What's Next