Yes, AI can turn a fence run length into a materials list and a price, but only as fast arithmetic you check. Give it the run, post spacing, panel size and your prices, make it show every step, then verify post and panel counts against a sketch. It gets the maths right more often than the conditions.
Where it goes wrong is predictable. It forgets the extra post at the end of a run, ignores post width when working out spacing, and knows nothing about sloping ground, hard digging or a neighbour's tree root. The fix is to settle the counting rules yourself once, then hand the tool those rules with your own prices and make it show every step, so a skipped post or a rounding slip shows up in seconds rather than hiding in a total.
The inputs the maths needs, before any AI
A materials list is arithmetic on a handful of facts. Collect them on site, and the chatbot has nothing to guess.
- Run length in metres, measured along the line of the fence, with corners and gates marked.
- Fence height and style: closeboard, lap panel, picket, or horizontal slat.
- Panel width and post width from your supplier's actual sizes, not the nominal ones.
- Ground: level or sloping, soft, clay, rock, roots, services nearby.
- Gates: number, widths, hardware.
- Old fence: removal and disposal, or fresh ground.
- Access: how far the materials have to be carried, and whether a digger or hand tools will be used.
If a customer sends a photograph and a rough measurement, your first message back asks for the missing ones. A chatbot can draft that message from a checklist; the tutorial on following up fence enquiries shows how.
A main example: 20 metres of lap-panel fence, line by line
Here is an illustrative job: a straight 20-metre run of 1.8 m high lap-panel fencing on level ground, existing fence already removed, wooden posts set in concrete, one gravel board under each panel. All prices are illustrative; replace them with your own supplier's. Panels are 1.8 m wide, posts are 0.1 m wide.
Step 1: count the bays and the posts
Post centres are panel width plus post width: 1.8 + 0.1 = 1.9 m. The run divided by spacing is 20 / 1.9 = 10.53, which rounds up to 11 bays. Posts are bays plus one: 12 posts. Panels: 11, with the last one cut to fit. Gravel boards: 11.
The classic wrong answer is 20 / 1.8 = 11.1, round up to 12 panels, 13 posts. That overbuys a panel, a post and a board, roughly $75 of stock sitting in the van. It happens because the sum ignores post width.
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 nowStep 2: price the materials
| Item | Quantity | Unit price | Cost |
|---|---|---|---|
| Lap panels, 1.8 m | 11 | $38.00 | $418.00 |
| Posts | 12 | $22.00 | $264.00 |
| Gravel boards | 11 | $14.00 | $154.00 |
| Postmix concrete bags (2 per post) | 24 | $7.00 | $168.00 |
| Post caps | 12 | $2.50 | $30.00 |
| Fixings, clips, nails | 1 lot | $25.00 | $25.00 |
| Materials subtotal | $1,059.00 | ||
| Waste allowance, 5% | $52.95 | ||
| Materials with waste | $1,111.95 |
Step 3: add labour and delivery
Say two people take a day and a half: three person-days at a cost of $240 a day, which is $720. Delivery is $60. Cost to you: $1,111.95 + $720 + $60 = $1,891.95, call it $1,892.
Step 4: add your markup
A 25 percent markup on cost is $473, giving a price of $2,365. That is a 20 percent margin on the price (473 / 2,365). The two numbers are different and people confuse them. A 20 percent markup gives a 16.7 percent margin; if you want a 20 percent margin you need a 25 percent markup. Per metre, the price is $118.25.
That is the whole job. The harder part is getting a chatbot to do steps 1 to 4 without silently getting one wrong.
The prompt that makes the tool show its working
I am a fencing contractor pricing a straight run of lap-panel fencing.
Inputs: run length 20 m; panel width 1.8 m; post width 0.1 m; level ground;
one gravel board per panel; 2 bags of postmix per post.
Prices: panel $38, post $22, gravel board $14, postmix bag $7, post cap $2.50,
fixings $25 per job. Labour: 3 person-days at $240. Delivery $60.
Waste allowance 5% on materials. Markup 25% on cost.
Work step by step and show every calculation:
1. post spacing = panel width + post width
2. bays = run / spacing, rounded UP
3. posts = bays + 1
4. materials list and cost
5. total cost, price with markup, margin on price, price per metre.
Flag any assumption you made that I did not give you.A good reply follows your five steps and ends with the figures above. A weaker one skips step 3 or rounds 10.53 to 10 instead of 11. If it shows the working, you spot that in seconds. If it simply says "you need 12 panels and 13 posts", ask it to show step 1. Never accept a bare answer.
Five checks that catch a wrong list
- Posts equal panels plus one. On a straight run with no gate or corner, this must hold. If the list has the same number of both, something is missing.
- Run divided by spacing, rounded up. Check the rounding direction. Rounding down leaves a gap in the fence.
- Sketch it. Draw 11 bays on a line. Counting posts on a sketch takes 30 seconds and finds the missing end post every time.
- Per-metre sense check. $118 a metre for this style should look sensible against your last five jobs. If the tool says $64 or $190, find the line that moved.
- Totals in a spreadsheet. Re-add the table. Chatbots sometimes add a long list and drop a line, and the error is invisible without a sum.
Adding gates, corners and slopes
Straight level runs are the easy case. Real jobs bring complications, and each one changes the list in a way a chatbot will miss unless you say so.
Gates
A gate replaces one bay. A 0.9 m pedestrian gate needs a gatepost on each side, usually heavier than line posts, plus hinges, a latch and a drop bolt. Tell the tool: "replace one bay with a 0.9 m gate; gateposts at $45 each; hardware set $48." Check that the panel count drops by one and the post count does not.
Corners and ends
Each corner or end needs a post, and it counts once even though two runs meet there. If you give the tool two runs of 12 m and 8 m at right angles, it will often count the corner post twice. Count the posts on a sketch.
Slopes
On a slope, panels step or rake, and a gravel board under a stepped panel leaves a triangular gap. You may need taller posts or bespoke panels. This is a judgement a tool cannot make from a run length. Add a labour factor from experience and note the assumption in the quote.
Hard ground and roots
Rock, clay or roots slow digging dramatically. If two person-days become four on one job, the labour line doubles. Put a line in the quote: "price assumes digging by hand to 600 mm without obstructions; hard ground or services charged as extra at $240 per person-day." That wording protects you, and it can be drafted by a chatbot from your rules.
Two more worked examples
A 12-metre closeboard run with one gate
Illustrative: closeboard needs rails, pales and gravel boards instead of panels, but the principle is the same. Say spacing is 2.0 m on centres, so 12 / 2.0 = 6 bays. One bay is the gate. Posts: 7 line posts, with two heavier gateposts replacing two of them. Rails: 3 per bay on 5 bays = 15. A chatbot asked for "posts for 12 m at 2 m spacing" gives 7, correct. Asked about the gate, it often adds two extra posts instead of upgrading two of the seven. The sketch check catches it: draw 6 bays, circle the gate bay and see that its two posts are already counted.
A 30-metre horizontal-slat boundary
Slat fences are sold by the board, not the panel. With a 1.8 m bay and 6 boards per metre of height, a 1.8 m high fence needs about 11 boards per bay (10.8 rounded up), a number worth confirming with your own design. With 0.1 m posts the centres are 1.9 m, so 30 / 1.9 = 15.8 rounds up to 16 bays: 176 boards and 17 posts plus fixings. A tool that divides 30 by 1.8 gets 17 bays and 187 boards, the same post-width slip as before. Here a chatbot is most useful for turning the board spacing and run length into a cut list, and for generating a spreadsheet formula to total boards when the run changes. Ask it for the formula and test it on two runs you can count by hand.
What a wrong answer looks like, and how you would fix it
Here is an illustrative reply from a chatbot given the 20-metre job but not told to show its working. It says: "For 20 m you need 12 panels, 13 posts, 12 gravel boards and 26 bags of postmix. Materials come to about $1,225. With labour and a 25 percent markup, quote around $2,550." Every number is plausible and several are wrong: one panel, one post, one board and two bags too many, so the list alone is about $90 too high, and the markup is then applied on top of that overcount.
The fix is not to argue with it but to rerun with the five-step prompt. When it shows 20 / 1.9 = 10.53, rounds up to 11 and counts 12 posts, the figures fall into place. Notice that the wrong answer was only 8 percent above the right one. That is why fencers get caught: a small overcount is not obvious, and the quote still looks sensible. On a tight job in a competitive area, it may be the difference between winning and losing the work, so an overcount costs you either way.
Estimating labour from your own records
Labour is the line AI knows least about, because it depends on your crew, your ground and your tools. Use your job history. Take your last ten fence jobs and write down metres fitted and person-days taken. Divide metres by person-days to get your rate: if you fitted 140 metres in 21 person-days, you average 6.7 metres per person-day on typical ground. For a 20-metre job that is three person-days, matching the example.
Then adjust by condition, using multipliers you set from experience. Illustrative: slope 1.3, hard ground 1.5, difficult access 1.2, old fence removal add 0.5 person-day per 10 metres. A 20-metre job on a slope with hard ground would be 3 x 1.3 x 1.5 = 5.85 person-days, nearly double. Give the multipliers to the chatbot as rules and ask it to apply them with the arithmetic shown. It will do it faster than you can, and you can check each step. A chatbot cannot produce those multipliers from nowhere; if it offers some, treat them as a guess and replace them.
Tracking your own rate also protects you when a client pushes back. "We average under 7 metres a person-day on this kind of ground" is a better answer than a shrug.
A before and after: the enquiry reply
Before, typed at the end of a long day: "Fence 20m, around 2500, can do next month." After, a short prompt with the facts and your rules produces: "Hi [first name], thanks for your enquiry. For a 20 m run of 1.8 m lap-panel fencing on level ground, with the old fence already removed, I would expect the price to be in the region of $2,300 to $2,500, depending on ground conditions. To give a firm quote I need to see the site, mainly to check for slope, hard ground and any gates. Could you suggest a time this week? [your name]". The range is honest, the conditions are named, and the next step is a visit. The chatbot did the wording, and you did the pricing: the range comes from your per-metre rate and a margin for conditions.
Waste, offcuts and the last bay
Waste is not one number. Fixings, caps and concrete bags get lost or broken in small amounts, so a percentage works. Panels and boards waste in whole units, such as the last panel cut to size, with the offcut sometimes reusable on the next job. If the last bay is 1.2 m of a 1.8 m panel, the offcut is 0.6 m; if you are on a long run with a similar short bay later, you may use it.
To set your own figure, take the last five finished jobs. For each, compare what you ordered with what was fitted and what came back. If the average leftover on small items is 6 percent, use 6. A tool cannot know that figure; it can only apply the one you give it. Whether to waste 5 percent or 10 percent on a job is a trade-off between margin and a second trip to the supplier. With a supplier who delivers next day, 5 percent is usually enough; on a job two days from the nearest stockist, 10 percent buys peace of mind.
Markup, margin and the number that decides if you make money
Many fencers say "I add 25 percent" without saying whether it is markup or margin. Pick one and keep it. Markup is profit divided by cost; margin is profit divided by price. At a 25 percent markup, margin is 20 percent. To hit a margin target m, markup = m / (1 - m): for a 30 percent margin you need a 42.9 percent markup. Put the formula in your prompt: "price = cost / (1 - target margin)". A chatbot applies it well when given it, and badly when left to infer.
Remember that margin pays for the business, not just you: vehicle, insurance, tools, admin time and the jobs that run over. Ask what your overheads are per job day and check that your margin covers them. If your tool shows 20 percent and your overhead per job is 12 percent of price, you keep 8 percent.
Turning the list into a quote the customer understands
The priced list is for you. The customer needs a clear scope: length, height, style, gates, what is included and excluded, price, and how long the quote is valid. A chatbot can draft the customer-facing text from your list: "Write a clear quote from this scope, no prices per item, one total, list inclusions and exclusions, and add the line about hard ground." For the full layout see the fence proposal template, and for permit and boundary wording the fence contract template. Set an expiry date and a price-rise line using the quote validity tutorial, since timber prices can change within weeks. If you also price joinery items, the carpentry cut lists and quotes tutorial has related checks.
Test your tool on three finished jobs first
Before you rely on any chatbot or calculator for live quotes, test it on jobs you have already completed. Pick three: one straight and easy, one with a gate, one with a corner and a slope. For each, give the tool only what you had before the job started. Compare its list with what you actually used. Record the gap per item and the gap in the final price.
An illustrative result: on the easy job the tool matches exactly. On the gate job it adds two extra posts, costing $90 too much. On the slope job it misses two stepped panels and the extra labour, and is $310 too low. That tells you which jobs to hand to the tool and which to price by eye, and it takes an hour. Repeat once a quarter or when the supplier changes the panel size.
For a wider view of where AI sits in a trade business, the AI hub collects the related tutorials. The lesson from the maths is the same one throughout: the tool is quick at counting and weak at conditions, so you supply the conditions and check the count.
Fence pricing questions, answered
How many posts do I need for a fence run?
Divide the run length by the post spacing, round up to whole bays, then add one for the final post. Spacing equals panel width plus post width. A chatbot often forgets the extra post or ignores post width, so do this sum yourself or have it show its working.
How much waste should I allow on a fence job?
Many fencers allow roughly 5 to 10 percent on small items such as fixings, with cut panels and boards counted separately by bay. Your own history is the best guide: compare what you ordered with what went in over the last five jobs and set the figure from that.
Should I price per metre or per item?
Use per item to build the price, then convert to a per-metre figure as a check against your market. A per-metre rate alone hides gates, corners, slopes and difficult digging, which are where jobs lose money.
Is a chatbot accurate enough to price a fence?
It is accurate at arithmetic only when it shows each step, and it often misses the final post, the corner posts or the effect of sloping ground. Use it to draft the list and the sums, then check counts against a sketch and prices against your own supplier sheet.
Further reads
- Markup vs Margin in Construction: A Pricing Sheet Built With AI — A pricing sheet that keeps markup and margin straight.
- Construction Estimating With AI: Turn Supplier Quotes Into a Rate Sheet — Turn supplier quotes into a rate sheet the tool can use.
- Gutter Quote Template: Run Lengths and Downpipes Priced With AI — Another run-length job priced with AI and checked by hand.
- Groundworks Quote Template: Dig, Drain and Base Lines Written With AI — Quote wording for digging and hard-ground extras.
- Quote vs Estimate for Trades: Which to Send and What It Commits You To — Whether to send a quote or an estimate after a site visit.
- Fence Company Marketing: Local Pages, Photos and Posts With AI — Photos, posts and pages to attract fence enquiries.
- Handyman Material Markup: Build a Cost-Plus Calculator With AI — A worked cost-plus calculator for handymen: a sliding markup rule, shopping-time charge and small-item allowance, built with ChatGPT or Copilot in Excel.
- Typeform AI Form Builder: A Quote Request Form for a Fencing Firm — A step-by-step fencing quote request form built with Typeform AI: the prompt, branching questions, photo uploads, estimator alerts and what each plan allows.
- AI Tools and AI Development: The Complete 2026 Guide — the AI hub, including every tutorial in the AI-for-business series.
Sources: worked example uses illustrative supplier prices, panel sizes and labour rates the reader should replace with their own; no vendor pricing is quoted.