Spreadsheets & Small Tools

Walk through a normal project and count the spreadsheets. The area statement that reconciles carpet, built-up and super built-up areas against the brief. The order-of-magnitude cost check before the client meeting. The FF&E schedule with quantities, unit rates and lead times. The finishes take-off, the fee breakdown, the daylight or occupancy tally. Each is a small tool, and each is exactly the kind of structured, repetitive numerical work Claude handles well - both writing the formulas and, just as usefully, explaining and fixing the ones you already have but no longer trust.

What holds most designers back is not the idea but the syntax: knowing that a lookup or a conditional total is possible, but not the incantation. This is precisely where Claude shines, because spreadsheet formulas are a small, well-documented language it knows thoroughly. You describe your columns - "A has the room name, B the length in metres, C the width" - and the answer you want - "I need each room's area, and a grand total" - and Claude gives you the formula and tells you where to put it. The figure opposite shows a small area and cost sheet of exactly this kind: rooms down the side, dimensions and rates across, areas and costs computed, totals at the foot.

Because the results are visible and instant, the spreadsheet is also the best training ground for this whole module's discipline. When Claude hands you a formula, you paste it into one cell, check that single result against a quick mental or calculator estimate, and only then fill it down the column. That one-cell check before you fill down is the spreadsheet version of "run it on a sample" - cheap, fast, and the thing that catches a wrong-column reference before it silently poisons a hundred rows and a total you present to a client.

The quality of the formula you get back depends almost entirely on how clearly you describe your sheet. Name the columns and what they hold, with units; state exactly what you want computed and where; and mention any rule - rounding, a rate that varies by room type, ignoring blank rows. Vague in, vague out. Precise in, and Claude writes a formula you can drop straight in. Here is the core of an area and cost sheet described plainly and answered in formulas:

Columns:  A Room | B Length(m) | C Width(m) | D Area | E Rate | F Cost

Area of each room   D2:  =B2*C2
Cost of each room   F2:  =D2*E2
Total area          =SUM(D2:D20)
Total cost          =SUM(F2:F20)

That is the whole backbone of a costed area statement in four formulas. When the job gets a little harder, the same clear-description habit gets you the harder function. Two you will use constantly are a lookup - pulling a rate from a separate rate table instead of typing it per row - and a clean round:

Rate from a lookup table (rates on a sheet named 'Rates', cols A:B):
F2:  =D2 * VLOOKUP(A2, Rates!$A$2:$B$50, 2, FALSE)

Round a cost to whole rupees (no paise):
=ROUND(D2*E2, 0)

Each room's share of the total area, as a percentage:
=D2/SUM($D$2:$D$20)

Always ask Claude to explain the parts, because a formula you understand is a formula you can check. In the VLOOKUP above, for instance, that final FALSE demands an exact match on the room type - a detail that, if it were TRUE, could silently return the wrong rate. You do not need to memorise this; you need Claude to tell you it is there so you know what to verify.

Let us build the sheet in the figure end to end, the way you actually would. You start with what you have: a list of rooms and their dimensions. You tell Claude the columns and ask for the area column; it gives you =B2*C2 for D2 and tells you to fill it down. You paste it into D2 only, glance at it - Living at 5.0 by 4.0 should read 20.0 - and because it does, you fill the column. You add rates in column E, ask for cost, get =D2*E2 in F2, check one row on a calculator, and fill down. Finally you ask for the totals and get =SUM(D2:D20) and =SUM(F2:F20) at the foot. In five minutes you have a costed area statement, and you have verified it as you built it.

The dollar's-worth of extra value comes from the small refinements Claude adds when you ask. "Round the costs to whole rupees" gives you the ROUND wrapper. "Add a column showing each room's percentage of total area" gives you the share formula with the clever absolute reference ($D$2:$D$20) that keeps the denominator fixed as you fill down - a detail that trips up most self-taught spreadsheet users and that Claude gets right and explains. "Pull the rate from my rate table instead of typing it" upgrades you to the VLOOKUP. Each request is plain English; each answer is a formula plus an explanation.

If you live in Google Sheets, one more trick is worth knowing because Claude will offer it: filling a whole column with a single formula rather than dragging one down every row.

Fill the entire Area column at once (Google Sheets):
D2:  =ARRAYFORMULA(IF(B2:B20="", "", B2:B20*C2:C20))

That one cell computes every area and cleanly leaves blank rows blank. It is exactly the kind of thing you would never look up but will happily use once Claude writes and explains it - and, as always, you verify one row before trusting the column.

Everything in this lesson has a single non-negotiable at the end: the number you present is yours, whatever wrote the formula. Claude can reference the wrong column, sum a range that stops one row short, round in a way that shifts a total, or apply a lookup that silently misses. None of these throws an error; the sheet just shows a wrong, confident number. So verification is not optional politeness - it is the professional act that makes the tool safe to use in front of a client or on a tender.

The checks are quick and concrete. Check one representative cell by hand before filling a formula down a column - the one-cell check is your fastest catch. Sanity-check the totals against a rough expectation: if you know the flat is around forty square metres, a total area of four hundred or four is telling you something is wrong. Watch the edges of your ranges - a SUM(D2:D19) that should have been D2:D20 is the classic silent error, dropping the last room. And when a lookup or conditional is involved, test it against a case whose answer you already know: give it a room type whose rate you can see in the table and confirm the formula returns that exact rate.

Build these into the making, not a separate audit at the end. The beauty of the spreadsheet is that verification costs seconds and is visible - which is why it is the perfect place to cement the habit that runs through all of Module 8: describe clearly, let Claude write the formula, understand what it does, and check the number before you trust it. Do that here, on low-stakes sheets, until it is reflex, and you will carry the same reflex into the higher-stakes automation of Rhino, Revit and the mini-apps in the next lesson. The formula is Claude's; the total, and the responsibility for it, are yours.

A closing word on ambition, because it is easy to under-use this. Once you are comfortable, spreadsheets with Claude reach a surprising distance: a fee proposal that recalculates as you change the scope, a comparison sheet that scores three finishes on cost, lead time and durability, a running tally that flags when an FF&E budget tips over its limit. None of these needs a course in Excel; each needs a clear description of the columns and the rule, and the same one-cell, one-total verification. The ceiling is not your formula knowledge any more - Claude supplies that. The ceiling is how clearly you can say what you want, and how faithfully you check what comes back.