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

Using Sparky Products on Plans

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



Was this article helpful?