| name | schedule-creator |
| version | 0.2.0 |
| description | Creates a professional interior design schedule as an Excel (.xlsx) workbook — for a single room or an entire multi-room project at once. Use this skill whenever a user wants a room schedule, FF&E schedule, product schedule, kitchen schedule, bathroom schedule, project schedule, or any design schedule in spreadsheet form — even if they just say "make the schedule", "create the Excel for the kitchen and baths", or "build the full project schedule." Always produces three sheets: (1) a main schedule sheet with all rooms on one workbook, each separated by a blue section header — handles any number of rooms in a single pass, (2) a "Materials & Finishes" sheet that automatically pulls out paint, tile, hardwood, wallcovering, stone/countertop, moulding, and metal items from every room and organizes them by material type, and (3) a "Room Finish Schedule" sheet in plain CAD/Revit-compatible formatting showing which finishes are applied to each surface (floor, base, N/E/S/W walls, ceiling) per room — suitable for importing into AutoCAD and Revit technical drawings. Trigger when the user mentions: schedule, room schedule, FF&E schedule, product schedule, design schedule, material schedule, spec schedule, room finish schedule, finish schedule, project schedule, or when they have a list of design products and want an organized Excel file with codes, images, dimensions, and links. The schedule uses Master Abbreviation List codes (AP, PF, ST, CAB, FURN, AC, HW, etc.) and groups items by category with embedded product images. Do NOT use for mood board PDFs or product spec PDFs — use the moodboard-pdf skill for those.
|
Schedule Creator Skill
You create a professional interior design schedule as an Excel (.xlsx) workbook —
for a single room or an entire multi-room project at once, matching the style of
the Kitchen Schedule reference format.
Output: A landscape Excel workbook with three sheets:
[Project] Schedule — all rooms on one sheet, each room separated by a blue section header, then light-blue category sub-headers, then product rowsMaterials & Finishes — all material/finish items pulled from every room, organized by type (PAINT, MOULDING, HARDWOOD, TILE, WALLCOVERING, STONE, METAL)Room Finish Schedule — plain CAD/Revit-compatible table listing which finish codes apply to each surface (floor, base, N, E, S, W walls, ceiling) for every room
Workflow
Step 1 — Gather product data
For each room you need:
- Products — title, model number, manufacturer, dimensions, notes/specs, quantity, source URL, and an image (URL or local file path)
- Room name(s) — e.g. "Kitchen", "Powder Room", "Primary Bath"
- Project name — e.g. "Intersecting Stories"
- Studio / semester — for the page header/footer
Products most commonly come from:
- Markdown product clippings in a folder (same format as the moodboard-pdf skill)
- A list the user provides directly
- A previously generated mood board PDF
Step 2 — Assign abbreviation codes
Use the Master Abbreviation List to assign a code prefix to each product. Standard categories:
| Code | Category | Sheet | Examples |
|---|
| AP | Appliance | Schedule | Range, refrigerator, dishwasher, microwave, hood, beverage cooler |
| PF | Plumbing Fixtures | Schedule | Sink, faucet, toilet, shower valve, drain |
| CAB | Cabinetry | Schedule | Cabinet fronts, door styles |
| FURN | Furniture | Schedule | Chairs, stools, sofas, tables, vanities |
| AC | Accessories | Schedule | Pulls, hardware, mirrors, grab bars, décor |
| LF | Light Fixtures | Schedule | Pendants, recessed, sconces, flush mounts |
| TXT | Textiles | Schedule | Upholstery fabric, drapery (tied to a specific furniture item) |
| MISC | Miscellaneous | Schedule | Anything that doesn't fit above |
| PT | Paint | Mat & Fin | Paint colors |
| BB | Moulding / Baseboard | Mat & Fin | Base moulding, crown, trim |
| HW | Hardwood | Mat & Fin | Wood flooring |
| FT | Floor / Wall Tile | Mat & Fin | Porcelain, stone, mosaic tile |
| WT | Wall Tile | Mat & Fin | Backsplash, large-format wall tile |
| WC | Wall Coverings | Mat & Fin | Wallpaper, wall panels |
| ST | Stone | Mat & Fin | Countertop slabs — granite, quartz, marble (replaces legacy CT code) |
| MT | Metal | Mat & Fin | Metal trim, metal accents |
Stone / Countertop: Always use ST (not CT) for countertop slabs. If source data uses CT codes, the build script auto-renames them to ST on the Materials & Finishes sheet.
Number items sequentially per code prefix, globally across all rooms: AP-1, AP-2, ST-1, ST-2, etc.
If a Master Abbreviation List PDF is available in the project folder, read it first and use those codes — they override the defaults above.
Step 3 — Download and cache images
For each product with a URL image, download it to _image_cache/ before building the Excel:
headers_to_try = [
{'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 Chrome/120.0.0.0'},
{'User-Agent': 'curl/7.68.0'},
{},
]
Resize to thumbnail (max 110×78px) before embedding. If an image can't be downloaded, leave the cell empty — don't crash.
Step 4 — Assign surfaces for Room Finish Schedule (interactive)
Before building the Excel, Claude must interactively ask the user to map finish codes to room surfaces. This step populates Sheet 3.
For each room:
- Collect the finish codes present in that room (all PT, BB, HW, FT, WT, WC, ST, MT items).
- Present the available codes to the user and ask which apply to each surface:
- FLOOR
- BASE (baseboard)
- NORTH wall
- EAST wall
- SOUTH wall
- WEST wall
- CEILING (material / finish)
- Multiple codes can apply to one surface — e.g.
HW-1 / FT-2 for a floor with hardwood and tile.
- For ceiling height: ask the user to provide the height (e.g.
9'-0") or offer the option to leave it blank and fill in later.
- Any surface left unassigned should remain blank in the sheet — don't guess.
Example prompt to user:
For the Kitchen (Room 101), the available finish codes are:
HW-1 — Hardwood flooring
FT-1 — Floor tile (entry zone)
ST-1 — Granite countertop
PT-1 — Wall paint
BB-1 — Base moulding
Which codes apply to each surface?
FLOOR →
BASE →
NORTH →
EAST →
SOUTH →
WEST →
What is the ceiling height? (or leave blank)
What is the ceiling material / finish? (or leave blank)
Any notes for this room?
Store the user's answers in the surfaces, ceiling_height, ceiling_finish, and rfs_notes fields of the room JSON (see format below).
Step 5 — Build the Excel file
Use the build script at scripts/build_schedule.py:
python3 scripts/build_schedule.py \
--output "/path/to/Project Schedule.xlsx" \
--project "Intersecting Stories" \
--studio "ARCH X482.2 — Design Studio II" \
--semester "SPRING 2026" \
--data "/path/to/products.json"
Or call build_schedule() directly from Python — see the script for the data format.
Output filename convention:
- Single room:
[Room Name] Schedule.xlsx
- Multiple rooms:
[Project Name] Schedule.xlsx
Step 6 — Deliver
Save to the workspace folder. Share a direct link.
Three-Sheet Output
Sheet 1 — Main Schedule
All rooms appear on one sheet in the order provided. Each room gets a blue section header (merged A:H), followed by light-blue category sub-headers and product rows.
Row 1: CODE | IMAGE | MODEL | MANUFACTURER | DIMENSIONS | NOTES | QUANTITY | LINK (gray header)
Row 2: KITCHEN (blue section header, merged A:H)
Row 3: APPLIANCES (light-blue category header)
Row 4: AP-1 ...
Row 5: AP-2 ...
Row 6: PLUMBING FIXTURES
Row 7: PF-1 ...
Row N: POWDER ROOM (blue section header for next room)
...
Materials/finish items (PT, BB, HW, FT, WT, WC, ST, MT) are not written to this sheet — they go to Sheet 2 only.
Sheet 2 — Materials & Finishes
All material/finish items from all rooms, organized by type:
Row 1: CODE | IMAGE | ... | LINK (gray header)
Row 2: MATERIALS & FINISHES (blue section header)
Row 3: PAINT
Row 4: PT-1 ...
Row 5: MOULDING
Row 6: BB-1 ...
Row 7: HARDWOOD
...
TILE
WALLCOVERING
STONE
METAL
CT-x codes from the input data are automatically renamed to ST-x on this sheet.
Sheet 3 — Room Finish Schedule
Plain CAD/Revit-compatible table. No fill colors (except a subtle #F2F2F2 on the header row), no special formatting — just clean black borders and Arial font.
Row 1: ROOM NO. | ROOM NAME | FLOOR | BASE | NORTH | EAST | SOUTH | WEST | HEIGHT | CEILING MATERIAL / FINISH | NOTES
Row 2: 101 Kitchen HW-1 BB-1 PT-1 PT-1 PT-1 PT-1 9'-0" PT-2
Row 3: 102 Powder Rm FT-1 BB-1 WC-1 PT-1 WC-1 PT-1 8'-0" PT-1
...
Rooms are auto-numbered starting at 101 in the order they appear in the data. If a room has a room_no override field, that value is used instead.
Multiple finishes on one surface are joined with /: e.g. HW-1 / FT-2.
Excel Format Spec
Column widths
A (CODE): 10 chars
B (IMAGE): 17 chars
C (MODEL): 28 chars
D (MANUFACTURER): 20 chars
E (DIMENSIONS): 30 chars
F (NOTES): 40 chars
G (QUANTITY): 10 chars
H (LINK): 30 chars
Row heights
- Column header row: 22pt
- Room section header rows: 22pt
- Category header rows: 18pt
- Product rows: 90pt (tall enough for thumbnail images)
Colors
- Column header fill:
#E0E0E0 (light gray)
- Room section header fill:
#2C5F8A (dark blue), white text, Arial 10pt bold
- Category header fill:
#D6E4F0 (light blue), Arial 9pt bold
- Alternating product rows:
#FFFFFF / #F4F4F4 — global across the entire sheet (does not reset between categories or rooms)
- Link text: Arial 11pt, no color change (plain text with hyperlink)
Font
Arial throughout. Bold for codes (col A) and headers; regular 8pt for all other data cells.
Borders
- Header rows (column header, section, category): medium border all sides
- Product rows: medium border on left (col A) and right (col H), thin on all other sides
Image embedding
Use openpyxl's XLImage with OneCellAnchor for proper cell anchoring:
from openpyxl.drawing.spreadsheet_drawing import AnchorMarker, OneCellAnchor
from openpyxl.drawing.xdr import XDRPositiveSize2D
from openpyxl.utils.units import pixels_to_EMU
col_px = 128
row_px = 120
x_off = max(0, (col_px - img_w) // 2)
y_off = max(0, (row_px - img_h) // 2)
marker = AnchorMarker(col=1, colOff=pixels_to_EMU(x_off), row=cur_row - 1, rowOff=pixels_to_EMU(y_off))
size = XDRPositiveSize2D(pixels_to_EMU(img_w), pixels_to_EMU(img_h))
xl_img.anchor = OneCellAnchor(_from=marker, ext=size)
ws.add_image(xl_img)
Always save thumbnails to temp files first — BytesIO buffers are unreliable for image anchoring.
Page setup
ws.page_setup.orientation = 'landscape'
ws.page_setup.fitToPage = True
ws.page_setup.fitToWidth = 1
ws.print_title_rows = '1:1'
Room Finish Schedule Format Spec
Columns (A–K)
A (ROOM NO.): 9 chars
B (ROOM NAME): 22 chars
C (FLOOR): 14 chars
D (BASE): 12 chars
E (NORTH): 14 chars
F (EAST): 14 chars
G (SOUTH): 14 chars
H (WEST): 14 chars
I (HEIGHT): 10 chars
J (CEILING MATERIAL / FINISH): 26 chars
K (NOTES): 28 chars
Row heights
- Header row: 30pt
- Data rows: 18pt
Styling (CAD-compatible — no decorative colors)
- Header row fill:
#F2F2F2 (subtle gray only), all other rows no fill
- All text: Arial 9pt, black
- Header row: bold; data rows: regular weight
- Borders: medium black (
000000) on outer edges; thin black on interior borders
- All cells: horizontal center, vertical center alignment
- No hyperlinks, no images on this sheet
Page setup
ws.page_setup.orientation = 'landscape'
ws.page_setup.fitToPage = True
ws.page_setup.fitToWidth = 1
ws.print_title_rows = '1:1'
Product Data JSON Format
Multi-room (preferred)
{
"project": "Intersecting Stories",
"studio": "ARCH X482.2 — Design Studio II",
"semester": "SPRING 2026",
"rooms": [
{
"name": "Kitchen",
"room_no": "101",
"surfaces": {
"floor": ["HW-1"],
"base": ["BB-1"],
"north": ["PT-1"],
"east": ["PT-1"],
"south": ["PT-1"],
"west": ["PT-1"]
},
"ceiling_height": "9'-0\"",
"ceiling_finish": "PT-2",
"rfs_notes": "",
"categories": [
{
"label": "APPLIANCES",
"items": [
{
"code": "AP-1",
"img": "/path/to/cached/image.jpg",
"model": "OR30SCI6X1",
"mfr": "FISHER & PAYKEL",
"dims": "30\"W × 25-1/4\"D × 35-3/4\"H",
"notes": "FREE-STANDING INDUCTION RANGE\n3.5 CU. FT. | ENERGY STAR",
"qty": "1",
"link": "https://..."
}
]
}
]
},
{
"name": "Powder Room",
"room_no": "102",
"surfaces": {
"floor": ["FT-1"],
"base": ["BB-1"],
"north": ["WC-1"],
"east": ["PT-1"],
"south": ["WC-1"],
"west": ["PT-1"]
},
"ceiling_height": "8'-0\"",
"ceiling_finish": "PT-1",
"rfs_notes": "",
"categories": []
}
]
}
Room Finish Schedule fields (per room)
| Field | Type | Description |
|---|
room_no | string | Room number override (e.g. "101"). Auto-assigned if omitted. |
surfaces | object | Keys: floor, base, north, east, south, west. Values: list of finish codes. Multiple codes joined with /. |
ceiling_height | string | e.g. "9'-0\"". Leave "" if not yet known. |
ceiling_finish | string | Finish code(s) for ceiling. Leave "" if not yet known. |
rfs_notes | string | Notes shown in the NOTES column on Sheet 3. |
All five fields are optional — omit or leave blank for rooms where surface data hasn't been gathered yet.
Single-room (legacy, still supported)
{
"room": "Kitchen",
"project": "Intersecting Stories",
"studio": "ARCH X482.2 — Design Studio II",
"semester": "SPRING 2026",
"categories": [
{
"label": "APPLIANCES",
"items": [...]
}
]
}
Notes column content
The NOTES column should contain the most useful spec details for a contractor or purchasing agent:
- Product type / description in ALL CAPS on the first line
- Key specs (capacity, CFM, GPM, dBA, finish, color) on subsequent lines
- Certifications (ENERGY STAR, ADA, ANSI, UPC, etc.)
- Important caveats (PANEL READY, CONTACT DEALER, etc.)
Keep each note line short — it wraps within the cell.
Materials & Finishes routing reference
| Prefix | Routes to M&F as |
|---|
| PT | PAINT |
| BB | MOULDING |
| HW | HARDWOOD |
| FT | TILE |
| WT | TILE |
| WC | WALLCOVERING |
| CT | STONE (renamed ST-x) |
| ST | STONE |
| MT | METAL |
All other prefixes (AP, PF, CAB, FURN, AC, LF, TXT, MISC, etc.) stay on the main schedule sheet.
