Contents x
    Electrical Formulas
    • 04 Apr 2025
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Electrical Formulas

    • Updated on 04 Apr 2025
    • 3 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article summary

    Before reading this article, ensure you have read Measurement - Parts & Labour and Using Formula within Groundplan articles to aid in understanding the following Formula examples.

    📝 The Formula values provided in this article are for example purposes only.

    TermExplained
    counttotal counts
    lentotal metres measured
    areatotal square metres measured
    count, len or area / xtotal count/length/area divided by an amount
    count, len or area * xtotal count/length/area multiplied by an amount
    ceil(x)rounding up a decimal value to the next whole number

    Double GPO

    Example Parts for a double GPO Count Measurement:

    electrical-double-gpo.png

    PartExplanationFormulaUMO
    Double GPODouble GPOs countedcounteach
    Wall bracketAllowing for a wall bracket for each double GPOcounteach
    2.5mm twin and earthHow many metres are required when 12m are allowed with each double GPOcount*12m
    2.5mm twin and earth (100m cable drum)How many metres are required when 12m are allowed with each double GPO divided by a 100m drumcount*12/100drum
    2.5 cable clipsHow many clips are needed when 5 are required for each double GPO divided by a jar of 500count*5/500jar
    LABOUR
    LabourAllowing for 30 minutes of Labour for every double GPO counted as per the Labour Conversion Chartcount*0.5hours


    Mains Cable Run

    Example Parts for a mains cable run Length Measurement:

    electrical-mains-cable.png

    PartExplanationFormulaUMO
    Mains cable runsHow many metres are requiredlenm
    50mm HD conduit (orange rigid 4m)How many 4m lengths of conduit required for the length measuredceil(len/4)lengths
    16mm XLPE Four CoreHow many total metres required and allowing for an additional 4m per run measured to the switchboardlen+count*4m
    16mm SDI red cable (S/D insulated)How many total metres measured multipled by 3 lengths of cable required and allowing for an additional 4m per run (making 12 in total for the 3 lengths) measuredlen*3+count*12m
    16mm SDI black cable (S/D insulated)How many total metres required and allowing for an additional 4m per runlen+count*4m
    Warning tape underground orange (100m)How many 100m rolls of tape required for the length measuredlen/100rolls
    50mm sweeping bend (90° heavy duty orange)Number sweeping bends required multiplied by 2count*2each
    LABOUR
    LabourAllowing for 10 minutes of Labour for every metre measured as per the Labour Conversion Chartcount*0.17hours


    Airconditioning

    Example Parts for a 2.7m height ceiling airconditioning Area Measurement:

    electrical-airconditioning.png

    PartExplanationFormulaUMO
    Room areasHow many metres squared for each room measuredaream2
    KW ratingArea measured multiplied by 150 wattage per m2 and to convert to a KW rating, divided by 1000area*150/1000KW
    Volume of airThe area measured multiplied by 2.7m ceiling heightarea*2.7m3


    Learn more about how to view individual KW ratings quantities when exporting by clicking here.

    To show individual Area KW Ratings, lock the breakdown to display on Export. It is recommended to rename the areas within the stage to display the location.

    electrical-renaming.png


    1. From the Quantities Tab, click + on the Part / Labour line with the breakdown
    2. Click + next to KW Rating and click the Padlock

    electrical-airconditiong-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



    For Formula assistance, please reach out to Support. Go to: Help > Send us a Message.

    Download a PDF copy of Using Formulas within Groundplan here.


    💡Accessed your Company's free 1 hour Training Session?

    Organise your session today! Click Help > Send us a Message and ask to book in for free training.

    Trainers can assist with:

    • Workflow solutions
    • Time-saving tips
    • Making sure you're getting the most out of your subscription

    If you've accessed your free training and need further Support, reach out to book a 1 or 2 hour paid session.

    Attachments
    Labour Conversion Chart 2023.pdf
    439.38 KB
    Using Formulas in Groundplan(1).pdf
    4.01 MB
    Was this article helpful?
    What's Next