Contents x
    Using Sparky Products on Plans
    • 13 Nov 2023
    • 4 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Contents

    Using Sparky Products on Plans

    • Updated on 13 Nov 2023
    • 4 Minutes to read
    • Print
    • Dark
      Light
    • PDF
    Article Summary

    Once Integrated, begin using Sparky Products to Count, Measure Lengths and/or Areas on Plans.

    Measurement Choices

    Once-off Item: Use this option if the item doesn't exist in Sparky Products (appears in Other Items Section)
    Sparky Product: Choose individual Products from Sparky's online Catalogue
    Sparky Pre-Build: Select groups of Products, known as Pre-Builds in Sparky

    1. Within a Stage, click +Count, +Length or +Area

    Stages when Pushing to a Quote

    • The Stage Name appears at end of Product Name when "all Stages are pushed to one Task"
    • Stages appear as Tasks when "One Stage per Task" is selected
    1. Select a Measurement Part Type

    sparky-measurement-choices.png

    1. Complete the remaining fields
    Groundplan Once-Off ItemSparky ProductSparky Pre-Build
    GroupN/AOptional to selectOptional to select
    Sparky Product SearchN/AType full item nameType full item name
    Search ResultsN/AClick to Select resultClick to Select result
    Part NoOptionalN/AN/A
    DescriptionRequiredN/AN/A
    Unit of MeasureRequiredN/AN/A
    Unit CostOptionalN/AN/A
    Markup %OptionalN/AN/A
    Unit PriceOptionalN/AN/A
    Style OptionsOptionalOptionalOptional
    1. Click Create
      If additional Parts and Labour are required, click Create & Add More Parts


    More information on Measurement Types can be found in the following articles:

    Adding Parts and Labour to a Measurement

    When a Count, Length or Area is created on a Plan, additional Parts and Labour can be quantified at the same time. Parts can be added when the Measurement is created or after.

    Supporting References

    Support References relate directly to elements on the Plan and can be used in conjunction with Excel-type Formula to calculate Parts and Labour for Once-off Items, Sparky Products and Pre-Builds. Each Formula must contain a Supported Reference/s to be accepted.

    Formula follows the PMDAS Rule: Parentheses (brackets) first followed by multiplication, division, addition, then subtraction. Calculations are prioritised within the brackets.

    For example:

    How Length Support References correspond to a Plan:
    formula-length-supported-reference.png

    More detailed information about Formulas with examples are provided in our article Using Formulas in Groundplan here.

    Adding Parts while Creating a Measurement

    1. Create Measurement and click Create & Add More Parts

    sparky-parts-on-creation.png

    1. Click +Part, select Measurement Part Type and complete Formula if required
    2. (If required) Click Edit and rename Measurement
      Renaming the Measurement remains in Groundplan only
      sparky-parts-on-creation-2.png

    Adding Labour on Creation

    Labour added within Groundplan will be sent to Sparky and appear in the Labour Section. Labour costs within Sparky will not be picked up. Further information about converting Minutes to Decimals for Labour can be found here.

    sparky-labour-in-quote.png

    1. Create Measurement and click Create & Add More Parts

    sparky-parts-on-creation.png

    1. Click +Labour
    2. Complete Description
      (Optional fields - Unit of Measure, Unit Cost, Markup %, Unit Price, Formula and Labour conversions.)
    3. Click Save
      This example shows for every Floodlight installed, an hour and 30 minutes is calculated (count*1.5)

    sparky-labour-on-creation.png


    Additional Items and Labour

    On the Worksheet tab, Additional Items and Labour can be added to individual Stages. These are usually items not populated on the Plan but needed within the Quote. Examples include but are not limited to sundries, travel or equipment hire, and extra contractor hire.

    Additional Items
    Choose from Groundplan Once-off Items (appears in "Other Items"), Sparky Products (appears in "Products") or Pre-Builds (appears in both the Pre-Builds and Products if there are separate Products within the Pre-Build).

    sparky-additional-items-labour.png

    Frequently Asked Questions

    I have used the same Sparky Product under multiple Groundplan Measurements in the same Stage. Why can I only see it once in my Sparky Quote?

    They have Grouped together. The same Sparky Product appearing under multiple Measurements in the same Stage will Group together on the Sparky tab and combine totals when pushing to a Quote.

    For example: Allowing for a surface socket under two different Measurements in the same Stage will Group together:

    sparky-adding-parts-grouping.png


    If I update my pricing in Sparky, will this show immediately?

    No, not automatically.

    You will need to de-configure and reconfigure the integration again to update the pricing when pushed to a Quote in Sparky.

    Please note: Items on existing Groundplan Projects will still show the original price. When pushed to a Sparky Quote, the correct price will show.


    When I add my Pre-Build, why does it display the Sparky description instead of the Sparky name on the Stage?

    The Pre-Build name appears as the Part number, and the Pre-Build description appears as the Measurement and Part Name.

    faq-description-name.png

    The Pre-Build name shows correctly once inside the Sparky Quote.

    faq-description2.png

    Please note: When a Pre-Build does not have a description, the Pre-Build name shows as the Part Name in Grounplan.


    If I rename a Sparky product with, say, D1 - then the type of downlight, will that appear in my Sparky Quote?

    No.

    Renaming measurements on Groundplan will not send the updated name to Sparky.

    These names will only appear in Groundplan on the Stage, Worksheet, Quantities, Take-off Templates and on the Legend.


    If I need to use Groundplan Once-Off Item, where will it appear in my Quote?

    Groundplan Once-Off Items appear within the Other Items section of the Sparky Quote.

    sparky-once-off-item-faq.png


    Can I create Sparky Prebuilds within Groundplan?

    No.

    Having multiple Sparky Products as Parts will not create a Prebuild within Sparky. Any additional Parts and Labour added to a Measurement are sent to Sparky as individual lines.

    Prebuilds must be built in Sparky.


    💡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 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
    Using Formulas in Groundplan.pdf
    2 MB
    Labour Conversion Chart 2023.pdf
    439.38 KB
    Was this article helpful?
    What's Next