Skip to main content

Painting formula examples: walls, exterior cladding and door/window removals

Dive into some example painting formula.

Updated this week

Before reading this article, ensure you have read Adding parts and labour and Using formula within Groundplan articles to aid in understanding the following formula examples.

📝Note:

  • Doubled-sided and single-sided walls would need separate measurements as the parts and labour are different.

  • If there is more than one ceiling height on the project, each height must be a separate measurement with the correct formula, parts and/or labour applied.

Term

Explained

count

total counts

len

total metres measured

area

total square metres measured

count, len or area / x

total count/length/area divided by an amount

count, len or area * x

total count/length/area multiplied by an amount

ceil(x)

rounding up a decimal value to the next whole number

Internal walls

Example parts for painting a single-sided wall with a 2.4 high ceiling length measurement:

📝Note: This example uses the height section of the measurement unit.

Part

Explanation

Formula

UoM

Undercoat

How many litres are required when the ceiling is 2.4m high automatically applied for the length drawn divided by an averaged 1 litre based on covering 6m2

ceil(area/6)

Litres

Undercoat (20L bucket)

How many 20L buckets are required when the ceiling is 2.4m high automatically applied for the length drawn divided by an averaged 1 litre based on covering 6m2 divided by a 20L bucket

len*2.4/6/20

Buckets

Top coat

How many litres are required when the ceiling is 2.4m high automatically applied for the length drawn divided by an averaged 1 litre based on covering 6m2 multiplied by 2 coats required

ceil(len*2.4/6*2)

Litres

Top coat (20L bucket)

How many 20L buckets are required when the ceiling is 2.4m high automatically applied for the length drawn divided by an averaged 1 litre based on covering 6m2 multiplied by 2 coats required divided by a 20L bucket

len*2.4/6/*2/20

Buckets

Cornice

How many total metres measured

len

m

Skirting

How many total metres measured

len

m

Total wall area

Total length measured multiplied by the 2.4m high automatically applied for the length drawn for the total m²

area

Exterior Cladding

Example parts for painting exterior cladding using an area measurement:

Part

Explanation

Formula

UoM

Undercoat

How many litres are required for the area measured divided by an averaged 1 litre based on covering 6m2

ceil(area/6)

Litres

Undercoat (20L bucket)

How many 20L buckets are required for the area measured divided by an averaged 1 litre based on covering 6m2 divided by a 20L bucket

area/6/20

Buckets

Top coat

How many litres are required for the area measured divided by an averaged 1 litre based on covering 6m2 multiplied by 2 coats required

ceil(area/6*2)

Litres

Top coat (20L bucket)

How many 20L buckets are required for the area measured divided by an averaged 1 litre based on covering 6m2 multiplied by 2 coats required divided by a 20L bucket

area/6/*2/20

Buckets

Total exterior wall

Total exterior area measured after door / windows were removed

area

Removals

There are different ways to calculate window and door removals using parts with negative formula applied. All involve grouping of parts.

Alternatively, if usage permits, use the area cut-out tool to remove windows from elevations plans as well.

Sliding door removal

Example parts for the removal of a 2400mm x 2200mm sliding door using a count measurement:

Part

Explanation

Formula

UoM

Total wall area

Calculating negative m2 of the total area covered by a sliding door 2400mm x 2200mm = 5.28m2 to be removed from the Total wall area Grouped Part

-count*5.28

Window Removal

Example parts for the removal of any length window with a height of 1.2m using a length measurement:

📝Note: This example uses the height section of the measurement unit.

Part

Explanation

Formula

UoM

Total wall area

Calculating a negative m2 of the total area covered by a window with a height of 1.2m automatically applied for the length drawn to be removed from the Total wall area Grouped Part

- area

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


💻Accessed free Training?

Arrange your free training by clicking Help > Send us a Message. Our trainers are ready to help with:

  • Streamlining workflows

  • Time-saving strategies

  • Maximising your subscription

Alternatively, visit the Groundplan Academy here for self-directed courses.

Did this answer your question?