AI Programs for Architects: Room Data Sheets From a Client Brief

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI Programs for Architects: Room Data Sheets From a Client Brief.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for AI Programs for Architects: Room Data Sheets From a Client Brief.

Yes, as a first draft. Given a text brief, an assistant can list the rooms and propose areas, adjacencies, finishes and services for each. It usually misses requirements buried in narrative, contradictions between sections, rooms the client assumed, and anything your regulations demand, and it fills gaps with plausible numbers. Check every row against the brief before issue.

A room data sheet (sometimes a room schedule or space data sheet) is the page per room that tells the design team and consultants what each space must hold and do. The chat programs (Claude, ChatGPT, Gemini and similar) are good at the clerical job of pulling a brief into that format. They are poor at judging what a client means by "easy to clean" or "good ventilation", and poor at noticing that a late email overturned a table.

Follow me on Instagram@sagnikteaches

The worked example is invented: a small veterinary clinic's brief with an email appended after the last section. It contains the traps real briefs carry without meaning to. Areas are in square metres, and every room, figure and requirement is illustrative.

Connect on LinkedInSagnik Bhattacharya

Three rules run through everything below. The assistant may use only facts from the brief. Every line says where its content came from. And a person checks the sheets against the brief before anything is issued. Where AI fails on layouts is a separate question, covered in the floor plan generation tutorial; a schedule is a different and safer job.

Subscribe on YouTube@sagnikteaches

The brief we will use, with its traps

Here is the brief as a busy practice manager might send it: narrative mixed with numbers, and a late email. Read it as the project architect would and note what you would query. The review pass further down finds the rest.

Brief: [Client] veterinary clinic, version 3

1. Overview. We are a small-animal practice moving out of rented rooms into a new single-storey building. We want a calm, easy-to-clean place of about 260 m² in total. Our patients are dogs, cats and the odd rabbit.

2. Public side. A reception counter with a small retail shelf. Dogs and cats must not wait in the same room or see each other from their seats. Level access from the car park, wide enough for wheelchairs and for people carrying cat baskets. One accessible WC and one staff WC.

3. Clinical side. Three consulting rooms of about 14 m² each. A prep room (16 m²) that serves the theatre (20 m²). An X-ray room (12 m²) next to the theatre. A dispensary of 10 m², lockable and not visible from the waiting areas. A lab of 8 m². Kennels for six dogs (18 m²) and four cats in a separate room (10 m²), plus an isolation room (8 m²) that needs its own route in and a hand-wash.

4. Back of house and public rooms. Staff room with kitchenette (20 m²), store (10 m²), laundry (8 m²) and office (12 m²). Reception 18 m², dog waiting 16 m², cat waiting 10 m², accessible WC 5 m², staff WC 3 m².

5. Finishes. Easy to clean throughout, with the kennel area hosed down. Warm and non-institutional in public areas.

6. Services. Plenty of sockets in the consulting rooms. Hot water to the kennels and a hand-wash in every clinical room. Good ventilation. Barking must not be heard in the consulting rooms.

Email, added later: "We have dropped the lab and will use an outside one. We would like a second spot for large dogs near the entrance. The dog kennels are now eight."

Nothing in it is unusual. The areas sum to something other than the headline, one sentence holds two requirements, a negative requirement sits at the end of a list, and the email overrules the room list in three places.

What a room data sheet holds, and where each field comes from

The fields are familiar, but the third column is the one that makes a drafted sheet checkable.

FieldWhat goes inWhere it can come from
Room number and nameYour numbering schemeThe practice
Function and occupancyWhat happens in the room and how many people use itThe brief; ask the client if it is absent
Net areaTarget area in m²The brief or a space standard; the total goes in a schedule
AdjacenciesEssential, desirable and keep-apart relationshipsThe brief and the design team
FinishesFloor, walls, ceiling and skirting, as codes from your legendPractice standard, confirmed by the client
EnvironmentHeating, ventilation, lighting and acoustic targetsConsultants; the brief gives intent only
ServicesPower, data, water, drainage and special servicesThe brief for intent; consultants for quantities
EquipmentFixed and loose items, and who supplies themThe client
Source and statusWhere each line came from and whether it is confirmedYou, on every line

A generic template leaves out the last row, and it is the one that lets a reviewer tell what the client said from what somebody supposed.

Stage one: ask for a requirements register, not a sheet

The mistake is asking for sheets straight away. Generating sheets invites the assistant to design, and designing means filling gaps. Extracting is a different task, and a safer one, so do that first and keep the output as the thing you later check against.

You are helping an architect. Read the client brief below and the email appended to it.
Do not design anything and do not write room sheets yet.
Produce a requirements register as a table with these columns:
ID | Requirement (one fact only) | Where in the brief (section number or "email") | Clear, Conflict or Unknown
Rules:
- Split every sentence into single requirements. "Needs its own route in and a hand-wash" is two.
- Use only what the brief says. Do not add rooms or values.
- Where the email contradicts the brief, list both and mark Conflict.
- Add a second table of questions for the client: anything vague ("good", "plenty", "easy to clean"),
  anything missing, and any totals that do not add up.
[paste the brief and the email]

Practicalities matter here, and they differ by program. Give the assistant text; a searchable PDF or a Word file is fine. Claude reads the text of PDFs of up to 1,000 pages, but its help page puts a 100-page limit on reading visual content, so plans embedded in a long brief may be skipped. Gemini takes up to 10 files per prompt, each up to 100 MB. Ask for a CSV rather than a finished spreadsheet file, because a CSV pastes into Excel or Sheets every time, whereas producing a spreadsheet file depends on which file-creation features your plan and settings have switched on. If the brief contains personal or confidential details, it belongs in the practice's approved business-plan tool, as the AI policy tutorial sets out.

An illustrative excerpt of what comes back for the clinic:

IDRequirementWhereStatus
R01Total area about 260 m²1Unknown: net or gross?
R02Dogs and cats do not wait in the same room2Clear
R03Dogs and cats cannot see each other from their seats2Clear
R09Dispensary lockable3Clear
R10Dispensary not visible from waiting areas3Clear
R11Lab 8 m²3, emailConflict: email drops the lab
R12Dog kennels: six (section 3), eight (email)3, emailConflict
R14Isolation room has its own route in3Clear
R15Isolation room has a hand-wash3Clear
R18Barking not heard in consulting rooms6Clear

The rule that does the most work is "one fact per row". It puts the isolation room's route in and its hand-wash on separate lines, so neither can quietly vanish. The second table of questions collects the vague words, and those become your email to the client.

Stage two: build the sheets, with a source on every line

Only now ask for sheets, from the register rather than the original brief. Give it your finishes legend so it chooses codes instead of inventing materials, and tell it what to do when a fact is absent.

Using only the requirements register below and our finishes legend, write a room data sheet for
each room as a table with columns: Field | Entry | Source.
Source must be a register ID or one of: SUGGESTED (chosen from our legend), QUESTION, CONSULTANT.
Rules:
- If the brief does not state a value, write NOT STATED. Do not estimate areas, occupancy,
  lighting levels, air change rates, temperatures or noise targets.
- Choose finishes only from the legend below. Mark every choice SUGGESTED.
- Include keep-apart adjacencies as well as essential and desirable ones.
- Any room you think is missing goes in a separate list headed ASSUMED ADDITIONS, with no area.
Finishes legend: F-04 sheet vinyl, coved to walls; W-02 washable paint; C-01 wipeable ceiling tile.
[paste the register]

Here is the sheet for one consulting room as it might come back after a first edit. The invented legend codes are the practice's own.

FieldEntrySource
Room1.07 Consulting room 1Our numbering
FunctionExamination of dogs, cats and small mammals with owner presentSection 3 (inferred)
Net area14 m²Section 3
OccupancyNOT STATEDQUESTION: how many people at once?
Keep apart fromKennels and isolation room (barking must not be heard)R18
NearReception and waiting areas by a short route; dispensarySUGGESTED
FloorF-04SUGGESTED, from "easy to clean" (section 5)
Walls and ceilingW-02 and C-01SUGGESTED
Hand-washBasin with hot and cold waterSection 6
Power"Plenty of sockets": quantity NOT STATEDQUESTION
Ventilation"Good": rate NOT STATEDCONSULTANT
AcousticTarget to be set by the acoustic adviserCONSULTANT
Lighting, data, heatingNOT STATEDCONSULTANT

This sheet is mostly questions and flags, and that is its value. A first-draft sheet that looks complete when the brief is not complete is the dangerous kind.

Where assistants invent values, and the rule that stops it

Left to its own judgement, an assistant fills every cell. The values it picks are not absurd, which is the problem: they read like engineering and nothing in the brief supports them. This is an illustrative first draft for the prep room, set against what the brief says.

FieldFirst draftWhat the brief saysCorrected entry
Lighting500 luxNothingCONSULTANT to set
Ventilation10 air changes an hour"Good ventilation" in generalCONSULTANT to set
Temperature20 to 22 °CNothingCONSULTANT to set
FloorAnti-slip vinyl, welded joints"Easy to clean throughout"F-04, SUGGESTED
WallsEpoxy paintNothing specificW-02, SUGGESTED
Special servicesAnaesthetic gas extractionNothingQUESTION: does the client want it?

I am not saying those first-draft figures are wrong for a prep room. I am saying they came from nowhere in the brief, so they cannot go on an issued sheet as if they had. The NOT STATED rule, together with the CONSULTANT status, keeps each field visible for the engineer to fill rather than deleting it or letting a guess stand in for it.

The area schedule: do the sums in the spreadsheet

Ask the assistant for the room list as a CSV, then total it with the spreadsheet's own formulas. Chat assistants can state a long total with confidence and be wrong, and a total is the number everybody repeats. The groups below are the clinic's, with the brief's areas, an illustrative first draft and the corrected figures.

GroupRooms in the briefBrief (m²)First draft (m²)Corrected (m²)
Public sideReception 18, dog waiting 16, cat waiting 10, accessible WC 5, staff WC 3525252
Large-dog spot (email)No area stated06 (invented)TBC
Consulting rooms3 x 14424242
Theatre suitePrep 16, theatre 20, X-ray 12484848
Dispensary10101010
Lab (dropped by email)8800
Kennels and isolationDogs 18 (for six), cats 10, isolation 83642 (dog room enlarged to 24, invented)36 plus TBC for eight kennels
Back of houseStaff room 20, store 10, laundry 8, office 12505050
Total246250238 plus two TBC

Check the sums. The brief's own areas come to 246 m² (52 + 42 + 48 + 10 + 8 + 36 + 50), and 238 once the lab goes. The first draft's 250 looks tidy against the client's "about 260", but it gets there by inventing a 6 m² spot for large dogs and a 6 m² enlargement of the dog kennel room, and it says nothing about either. In a spreadsheet with a status column, a formula such as the one below totals only what the client stated (here column F holds the status and column D the area).

=SUMIF(F2:F22,"Brief",D2:D22)

The sum raises a question the assistant should have put to the client. If the 260 m² means the total of room areas, the corrected 238 leaves about 22 m² for the two new items, which is plausible. If it means the whole building, walls and corridors included, the maths changes. With an assumed net-to-gross ratio of 75% (a placeholder; use your own), 260 m² gross allows 260 x 0.75 = 195 m² of room area, which is 43 m² less than the 238 requested. Conversely, 238 m² of rooms implies a building near 238 / 0.75, about 317 m². Those are two very different buildings, and only the client can say which one they meant.

The assistant may suggest rooms that the brief implies but does not list: a clinical waste store, a cleaners' store, a data cupboard, plant space. Treat them as ASSUMED ADDITIONS with no area and keep them out of every total until the client agrees.

Adjacencies: ask for the keep-apart pairs as well

Ask an assistant for adjacencies and the natural answer is a list of rooms that should be near each other. The brief's more important rules are often about keeping rooms apart, so ask for those by name and give each pair its source.

PairRelationshipSource
Dog waiting and cat waitingKeep apart, no sightlineSection 2
Prep room and theatreEssential: the prep room serves the theatreSection 3
X-ray room and theatreEssential: next to each otherSection 3
Dispensary and waiting areasOut of viewSection 3
Isolation room and other animal areasSeparate route inSection 3
Kennels and consulting roomsAcoustic separationSection 6
Consulting rooms and dispensaryDesirable: short routeSUGGESTED
Reception and waiting areasEssential: shared line of sight to the counterSUGGESTED

A suggestion marked SUGGESTED is useful. The same line with no source is how a designer ends up defending a requirement the client never gave.

The review pass: trace the brief to the sheets and back

Review is the stage that cannot be shortened, and it works in two directions. Forward: take each row of the register and find the sheet line that carries it. Backward: take each sheet line and find the register row or status that justifies it. A requirement with no sheet line was dropped; a sheet line with neither source nor status was invented.

Before you trust an assistant on a live brief, test it on one you wrote. Plant five facts in a copy: one in the middle of a paragraph, one in an email that contradicts a table, one keep-apart rule, one total that does not add up and one vague phrase. Then see which come back. The result is your tool's own miss profile, and it is more useful than any general claim, including mine. In an illustrative run on a planted copy of the clinic brief, the assistant caught the email contradiction, the bad total and the vague phrase, and dropped the mid-paragraph fact and the keep-apart rule. Those two misses tell you where the reverse trace has to look hardest. Repeat the test when the assistant's model changes, because the miss profile can change with it.

The clinic review produces this issues log, which becomes the client email and the agenda for the next design meeting.

No.Issue foundAction
1"About 260 m² in total": net or gross?Ask the client
2Room areas total 246 m², 238 after the email; two areas unstatedAsk for areas; keep TBC in the schedule
3Dog kennels six in the brief, eight in the emailSheet updated to eight; kennel room area to be confirmed
4Isolation room sheet had the hand-wash but not the separate route inRoute added to the sheet and the adjacency list
5Barking requirement missing from the kennel and consulting sheetsAdded to both
6Dispensary "not visible from waiting areas" missingAdded as an out-of-view adjacency
7Large-dog spot given an invented 6 m²Replaced with TBC
8Lighting, ventilation and temperature values with no sourceReplaced with CONSULTANT
9Implied rooms not in the brief (waste, cleaners, data, plant)Listed as assumed additions, no area
10"Easy to clean throughout" is vagueFinishes marked SUGGESTED for client confirmation

One miss in detail: the second half of a sentence

Item 4 is the kind of miss that is hardest to see. The brief's sentence is "plus an isolation room (8 m²) that needs its own route in and a hand-wash". The first-draft sheet for that room carried the area and the hand-wash. The route in, the harder requirement because it affects the plan, was gone. Nothing in the sheet looked wrong, because the sheet was plausible without it.

A reader skimming sheets would never have found it. The reverse trace did, because when the sentence was split into single requirements there were four items (area, route in, hand-wash and the isolation function) and the sheet accounted for three. If you run only one check from this tutorial, make it that one: split each sentence into atoms and tick every atom against a sheet line.

Turning the issues log into questions the client can answer

The issues log becomes an email, and this is a job the assistant does well, because it is polite structure around a list you have already checked. Ask for one question per open issue, each answerable in a line, with the brief's own words quoted so the client sees exactly what you read. The clinic's email after one edit reads like this (illustrative).

Subject: Your clinic brief (version 3): eight questions before we draw

Hi [first name], thank you for the brief and the later email. Before we start drawing, could you answer the questions below? A line on each is plenty.

  1. "About 260 m² in total": is that the rooms only, or the whole building including walls and corridors?
  2. The second spot for large dogs near the entrance: roughly how big, and is it inside or under cover outside?
  3. Eight dog kennels: what size of dog should the largest kennel take?
  4. "Plenty of sockets" in the consulting rooms: how many pieces of equipment are plugged in at once?
  5. "Hosed down" in the kennel area: which rooms are washed down with a hose, and how often?
  6. Should the prep room have anaesthetic gas extraction?
  7. With the lab gone, do samples still need a fridge or a bench somewhere?
  8. How many people are usually in a consulting room at once?

Separately, do you need any of these, which the brief does not mention: a clinical waste store, a cleaners' store, a data cupboard, space for plant? Yes or no is enough for now. We will send the room data sheets marked "draft for client review" once we have your answers. [your name]

Two habits in the assistant's first version needed fixing. It bundled questions ("Could you confirm the total area and the kennel numbers?"), which invites half an answer, so each was split. And it pre-answered one ("We have assumed the 260 m² is the gross building area"), which steers the client towards the very assumption the register was careful not to make, so that sentence was deleted. The assumed additions are asked as yes-or-no questions with no areas attached, so the client confirms rooms first and sizes them later, rather than adopting a figure the assistant suggested.

From spreadsheet to issue

When the sheets are checked, give them a status the reader can see: draft for client review first, for coordination only after the client has answered the open questions. Put the issues log in front of the client with the sheets, so the document shows how you read the brief and invites correction. Keep the room numbers as the key if the sheets later link to the model, and keep the register and the issues log in the project folder with the version of the brief they were built from.

Every AI-touched schedule also belongs in the practice's AI log with a named checker who did not write the prompt, as the policy tutorial describes. For drawings and schedules together, the drawing review tutorial covers the checks before anything leaves the building. Once the sheets are agreed, the schematics tutorial picks up from the same brief, and if names and addresses need removing before you paste, the anonymising tutorial shows how.

As a planning allowance for a 20-room brief, budget about 30 minutes for the register, 40 for the sheets, 30 for the sums and adjacencies, two hours for the review pass and 30 minutes for the client questions and issue, a little over four hours in all. Time your next brief both ways once and keep the figures. The saving is in typing, and the review pass is the part that does not shrink.

Questions architects ask about brief-to-sheet drafting

Can the assistant read a scanned PDF brief?

Not reliably. A scan is a stack of page images, how well each assistant reads them varies, and Claude's help page limits visual reading of a PDF to 100 pages. Convert a scan to searchable text first with the text-recognition option most PDF software has, or retype the key sections. Then spot-check three passages by asking the assistant to quote them word for word.

How should I handle repeated rooms such as classrooms or bedrooms?

Write one sheet for the room type and list the instances against it with their room numbers and areas. Asking the assistant to generate twenty similar sheets invites small unrequested variations between them. Check that each instance's area matches the brief and that the total of the instances matches the schedule.

What if the client changes the brief halfway through?

Version the brief and the sheets together. Re-run the register against the new version, ask for a list of differences, and treat each change as a question for the client to confirm. Then update only the affected sheets. Regenerating everything is how quietly corrected values come back.

Further reads

Sources: Claude's help page on file uploads (updated July 2026); Gemini Apps Help on uploading and analysing files; OpenAI's file upload documentation as summarised in October 2026. The brief, rooms and figures in the example are invented.

Want your brief-to-sheet routine tested on a real project?

On a 1:1 call we'll run your current brief template through the register-and-sheet method, see what an assistant drops, and decide where the human review should sit.

Book a 1:1 call with me