Insulation Quote Template: Material, Thickness and Area Lines With AI

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Insulation Quote Template: Material, Thickness and Area Lines With AI.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for Insulation Quote Template: Material, Thickness and Area Lines With AI.

A clear insulation quote has one line per part of the house, showing the location, the material and product, the installed thickness, the area measured and the price, followed by a list of exclusions. Paste your survey notes into an AI with a fixed line format, make it flag missing measurements instead of guessing, then check every number before sending.

Thickness and area are the two numbers customers dispute after the work, so they are the two the AI must never invent. Models fill gaps smoothly: a note reading "~270" becomes "270 mm", and an unmeasured section becomes a full-depth line with a price. The remedy is a quote format with a TBC marker, exclusions written before the work starts, and no promise about what the customer will save.

Follow me on Instagram@sagnikteaches

The five columns every insulation line needs

Every line answers the same five questions. Put them in columns, in this order, and a customer can read across a row and know what is being done, with what, how thick, over how much, and for how much.

Connect on LinkedInSagnik Bhattacharya
ColumnWhat goes in itThe slip it prevents
LocationThe exact part of the house: "Loft floor, main roof space" or "External cavity walls, ground and first floor""Loft" on a house with two roof spaces
Work and productThe action and the product name as on the datasheet: "Add mineral wool rolls, [product name]""Insulation" with no product, so nothing can be checked on site
ThicknessWhat you add and what remains, with units: "200 mm added over about 100 mm existing". For loose-fill, installed and settled thicknessA bare "300 mm" that might mean the total or the new layer
Area or quantitySquare metres (or square feet) measured on the survey, or a count for items such as baffles"Approx 50 sq m" that nobody can verify
PriceRate times area, shown, then the line totalLump sums that hide what changes if the area changes

Here is a vague line as many quotes carry it, then the same job written with all five columns.

Subscribe on YouTube@sagnikteaches

Vague: Loft insulation, supply and fit, $589.

Complete: Loft floor, main roof space. Add mineral wool rolls, [product name], two layers totalling 200 mm over the existing layer of about 100 mm. 62 m² measured on survey at $9.50 per m². Line total $589.00.

The second version is longer by a few words and answers every question the customer would otherwise raise on the day. It also gives you something to point at if the loft turns out smaller, since the area and the rate are both on the page.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

One house, quoted line by line

The main example is a 1990s detached house with a 62 m² loft floor and cavity walls. All figures are illustrative. Two features of this quote matter more than the prices: lines 5 and 6 are conditional on something the survey could not settle, and the totals are split so the customer sees the firm price and the conditional price separately.

LineLocation and workThicknessArea or quantityRateTotal
1Loft floor: add mineral wool rolls, [product name]200 mm added over about 100 mm existing62 m²$9.50 per m²$589.00
2Loft eaves: ventilation bafflesNot applicable24$3.25 each$78.00
3Loft hatch: insulated cover with sealing stripNot applicable1$95.00$95.00
4Loft pipework: lagging to exposed pipesNot applicable14 m$2.40 per m$33.60
5Ceiling downlights: covers, fitted only where the fitting's own documentation allowsNot applicable8$14.00 each$112.00 (conditional)
6External cavity walls: cavity fill, [product name], subject to pre-install inspectionFull cavity width, to be confirmed on inspection94 m² net of openings$7.20 per m²$676.80 (conditional)

Firm lines 1 to 4 come to $795.60. Conditional lines 5 and 6 come to $788.80. If everything proceeds the total is $1,584.40, and the quote says in plain words which lines can fall away: line 5 if the fittings cannot take covers, line 6 if the inspection finds the cavity unsuitable. Customers read a split total as honesty, and it saves an awkward call after the inspection.

A quick sum for the materials order shows why the area must be a measured number. With packs labelled as covering 2.9 m² at 100 mm, two layers over 62 m² need 62 ÷ 2.9 = 21.4 packs per layer, so 22 packs a layer and 44 in all, before any allowance for cutting that you and your supplier agree. If the area were wrong by 10 per cent, that is four or five packs. Leave the product labels from every pack with the customer at handover: they record what was used and how many packs went in.

Turning van notes into lines: before and after

Surveys are rarely typed neatly. This is what one set of notes can look like at the end of a day, and it is the realistic input for the AI.

62sqm loft, old wool ~100mm (flat by hatch)
hatch 600x600 no seal
8 downlights prob not rated??
eaves tight N side, vents both sides
bathroom fan duct ends in loft!!
tank + 14m pipe exposed
cavity walls ~94sqm net, cavity width not checked yet
E gable render cracked
cust wants loft boarded for boxes ~6sqm

The prompt turns that into lines without letting the AI tidy away the uncertainty.

Turn these survey notes into quote lines with exactly these columns: location, work and product, installed thickness, area or quantity.
Rules:
1. Copy numbers exactly as written. Keep every "~" or "?" as TBC and state the open question.
2. Never add a thickness, area, rate or product that is not in the notes.
3. Put anything that is not a priced line (damage, duct problems, access issues) under "Observations for the customer".
4. At the end, list every measurement that is missing.

Here is the output, trimmed to its lines, as it comes back when the rules are followed.

LocationWork and productInstalled thicknessArea or quantity
Loft floorAdd mineral wool rolls, [product name]TBC: target depth to be set; existing about 100 mm62 m²
Loft hatchInsulated cover with sealing stripNot applicable1
Ceiling downlightsCovers, only where the fitting's documentation allowsNot applicable8; TBC: ratings unknown
Loft pipework and tankLagging to exposed pipes; tank jacketNot applicable14 m of pipe; tank size TBC
External cavity wallsCavity fill, [product name]TBC: cavity width not yet checked94 m² net; TBC: approximate in notes
Boarding platformRaised platform for stored boxesNot applicableAbout 6 m²; TBC

Observations for the customer: the bathroom fan duct ends in the loft; the east gable render is cracked. Missing measurements: target loft depth, cavity width, tank size, downlight ratings, confirmed wall and boarding areas.

Four things I changed or noticed. First, an earlier run without rule 2 wrote "270 mm" into the loft line though no target depth was in the notes; the rule turned it into TBC. Second, that same earlier run dropped the bathroom fan duct altogether because it was not a priced line, which is why the observations rule exists: a duct that discharges into the roof space carries moist air where it should not go, and ducts should discharge outside. Third, the AI had turned the cracked render into a repair line, which this firm does not offer, so it became an observation backed by an exclusion. Fourth, the baffle count of 24 in the main example is mine, not the AI's: one per rafter bay along both eaves is arithmetic from measurements the notes did not contain. Quantities that need working out belong to the person who measured.

Exclusions that stop disputes, with wording to paste

Exclusions work best in three groups, because they do different jobs. What is not included is a list of work. Conditions say what must be true for a line to go ahead. Assumptions record what you measured, so a change on site has a reference point. Wording below is a starting point for your own paperwork, and a qualified adviser should look over anything contractual before you adopt it.

Work that is not included

  • "Removal and disposal of existing insulation is not included unless a line says so."
  • "Clearing the loft of stored items is the customer's responsibility before work starts, unless a clearing line is added."
  • "Roof, structural, damp and leak repairs are not included. If we find any, work in the affected area stops until it is resolved, and we tell you in writing."
  • "Moving cables or replacing light fittings is not included."
  • "Decorating, plaster repair and making good beyond [agreed clean-up] are not included."

Conditions that must be true

  • "Cavity wall fill goes ahead only if the pre-install inspection finds the cavity suitable. If it does not, line 6 is removed and not charged."
  • "Downlight covers are fitted only where the fitting's own documentation allows it. Otherwise insulation is kept back from the fitting and line 5 is credited."
  • "If we find a material we cannot identify, such as one that might contain asbestos, we stop work in that area. Testing and any removal must be arranged through a qualified specialist."

Assumptions we measured against

  • "Areas are measured on the survey date. A difference of more than [x] per cent found on site is re-priced in writing before work continues."
  • "Extractor fan ducts that end in the loft are noted but not re-routed unless a line says so."
  • "External work may be delayed for unsuitable weather without penalty to either side."

Choose the [x] figure yourself and keep it the same on every quote, so a customer who compares two jobs sees the same rule. The asbestos wording is deliberately plain: it does not diagnose anything, it only says what you will do. If a hidden problem turns up mid-job, roofing change orders for rotten decking: a worked example shows how another trade words the written variation.

Access, ventilation and moisture notes the AI should carry across

Some of what a surveyor sees is not a priced line but still belongs on the quote, because it changes how the job is done or what the customer should look into. Tell the AI to carry these across as short notes that describe what was seen, not what it means. "Staining on the underside of the roof felt near the chimney" is a note. "You have a leak" is a diagnosis you may not be qualified to make, and the customer is better served by a recommendation that a roofer takes a look.

Notes from the survey: The loft hatch is 600 × 600 mm with no seal; the cover is priced in line 3. Ventilation openings are present at the eaves on both sides and are kept clear by the baffles in line 2. The bathroom extractor duct ends in the loft and has not been re-routed. Eight downlights are fitted in the ceiling below and their ratings were not recorded.

Each note earns its place. Insulation that gets wet does not work well, so moisture sources are worth recording. Air leaks around hatches and light fittings are easier to seal before insulation covers them, so the hatch line is not an afterthought. And ventilation openings at the eaves must stay clear, which is why baffles appear as a line and not as a hope.

Loose-fill lines need two thicknesses

Rolls keep their thickness. Loose-fill settles, so a bare "250 mm" tells the customer the starting depth and not the finished one. Ask the AI to write loose-fill lines in this shape, and to leave the settled figure as TBC when the datasheet does not give one: "Loft floor: blown loose-fill, [product name]; 250 mm installed, minimum settled thickness [datasheet figure]; 54 m²; [number] bags." Where an insulation labelling rule applies, the installer's receipt for loose-fill has to show the coverage area, the initial installed thickness, the minimum settled thickness, the rating and the number of bags, so a quote line in this shape becomes the receipt line with almost no rework.

The bag count is another quick sum. A datasheet coverage of 1.75 m² per bag at 250 mm gives 54 ÷ 1.75 = 30.9, so 31 bags, and the number goes on the quote. The empty bag labels go to the customer at handover, which shows the same count was used.

Rates and wording come from your files, not from the model

A quote holds two kinds of numbers: measurements from the survey and rates from your price list. The AI should see the first in the notes and the second in a rate card kept in the same project. Keep the card short, with one row per work item showing its unit, your current rate and the date you last reviewed it. Then add the rule "use only rates from the rate card; if an item has no rate, write TBC". Without that rule a model will supply a plausible rate from its general knowledge, and a plausible rate is the wrong number often enough to hurt. Line 1 of the main example is two 100 mm layers at $4.75 per square metre each, which is how it reaches $9.50.

RATE CARD (reviewed 1 November, illustrative)
Mineral wool rolls, 100 mm layer: $4.75 per m2 per layer
Ventilation baffle: $3.25 each
Hatch cover with sealing strip: $95.00 each
Pipe lagging: $2.40 per m
Downlight cover: $14.00 each
Cavity wall fill: $7.20 per m2
Raised boarding platform: $42.00 per m2

The same project can hold the cover note that sits above the lines. It carries the date, a validity period you choose, how to accept, who did the survey and one standing sentence that keeps savings promises out of the document.

Quote date: [date]. Valid for [x] days. Survey carried out on [date] by [name]. To accept, reply to this message or sign below. This quote describes the work, materials and measurements. It does not estimate savings, which depend on the home and on how it is heated and used.

Attach three survey photos to the quote and name them in the notes: the hatch, the eaves and the existing depth with a tape measure in frame. Photos taken on the day anchor the "existing" figures in your thickness column, and they settle most arguments about what was there before you started.

Ten minutes of checks before the quote goes out

Do the arithmetic outside the AI. Models write convincing totals that are sometimes wrong, so put the lines in a spreadsheet and let formulas add them up. For the example above, with line numbers in column A, area or quantity in D and rate in E:

F2 to F7:  =ROUND(D2*E2,2)     line total, area times rate
F8:        =SUM(F2:F7)         all lines
F9:        =SUM(F2:F5)         firm lines only
F10:       =F8-F9              conditional lines

If a blank spreadsheet is a barrier, the ChatGPT Excel guide shows how to have a sheet like this built for you. Then work down this list.

  1. Compare the sheet's total with the AI's. Where they differ, the sheet is right.
  2. Multiply two or three areas by their rates by hand.
  3. Check units are consistent throughout: millimetres or inches, square metres or square feet.
  4. Confirm every area against the survey sheet or the floor plan you measured from.
  5. Resolve every TBC, or turn it into an explicit conditional line.
  6. Make sure each observation has a matching note or exclusion.
  7. Match product names to the datasheets in your folder.
  8. Remove any outcome phrase in a line description, such as "to help reduce heating costs". The quote describes work and materials; it does not promise results.
  9. Read it as a customer who has never seen the loft: could they say what they are buying?

If you use a quoting app such as Jobber, Tradify or ServiceM8, the five columns map onto line items: the item name carries location and work, the description carries product and thickness, the quantity is the area and the unit price is the rate. Where an app drafts quotes itself, run its output through the same checks. For measuring from plans rather than on site, see insulation takeoff from plans: can AI do it, and what to verify.

A realistic slip: a standard depth on a bungalow

Here is an illustrative case. A firm kept a template line reading "300 mm total depth" and let the AI reuse it. On a bungalow, the roof pitch left only about 150 mm of working height at the north eaves, so the fitters could not honour the line at the edges. The customer, who had read "300 mm" literally, queried the invoice, and the firm spent an evening on the phone.

The fix had three parts. The survey sheet gained a field for working height at the eaves. The AI rule became "state the depth in the main area and the depth the roof allows at the eaves, and write TBC if the second is not recorded". And the line now reads: "Loft floor: rolls to about 300 mm total in the main area, reducing to the depth the roof allows at the eaves (about 150 mm on the north side); 54 m²." It is less tidy and it prevents the phone call.

A quote tells the customer what they are buying. The conversation about which option to choose belongs in the proposal, and insulation proposals: explain options with AI without promising savings covers it. If the job comes with provisional items, loft conversion quote template: stages and provisional sums with AI shows how another trade lays out sums that are not yet fixed.

Further reads

Sources: a public home-insulation fact sheet (compression, moisture and air sealing) and the text of an insulation labelling and advertising rule (installer receipts and loose-fill disclosures), read in November 2026.

Want your quote lines drafted and checked properly?

On a 1:1 call we'll walk through your survey and quoting steps, decide which lines AI can draft safely, and set up the checks so nothing unmeasured reaches a customer.

Book a 1:1 call with me