Normalizes FF&E product schedules in Google Sheets, CSVs, TSVs, XLSX, or pasted tables: standardizes casing, splits/parses dimensions with units, maps categories, and cleans materials/formatting.
npx claudepluginhub alpacalabsllc/skills-for-architects --plugin 06-materials-researchThis skill is limited to using the following tools:
Takes a messy FF&E schedule and normalizes everything: casing, dimensions, units, language, materials vocabulary, currency formatting, and duplicates. Outputs a clean, consistent, spec-ready schedule.
Generates formatted FF&E specification schedules from raw product data like notes, CSVs, or pasted lists. Parses, enriches with known specs, assigns item numbers, calculates prices, outputs to markdown/CSV/Google Sheets using 33-column schema.
Cleans messy spreadsheet data: trims whitespace, fixes casing, converts numbers-as-text, standardizes dates, removes duplicates, flags mixed types. For prep before analysis in Excel or .xlsx files.
Builds standardized financial data packs from CIMs, SEC filings, web search into Excel workbooks with currency formatting, formulas, and accuracy checks for M&A due diligence and PE analysis.
Share bugs, ideas, or general feedback.
Takes a messy FF&E schedule and normalizes everything: casing, dimensions, units, language, materials vocabulary, currency formatting, and duplicates. Outputs a clean, consistent, spec-ready schedule.
Operates on the master Google Sheet — the same 33-column schema used by all product skills. Also works on standalone CSV files and pasted tables.
The user provides a schedule in one of these ways:
.csv, .tsv, .xlsx export, or .md fileIf the input format is unclear, ask.
| Field | Rule | Example |
|---|---|---|
| Product Name | Title Case | eames lounge chair → Eames Lounge Chair |
| Brand | Title Case, preserve known abbreviations | HERMAN MILLER → Herman Miller, HAY → HAY |
| Collection | Title Case | cosm → Cosm |
| Category | Title Case, singular | chairs → Chair, TABLES → Table |
| Materials | Sentence case, lowercase after first word | MOLDED PLYWOOD, FULL GRAIN LEATHER → Molded plywood, full grain leather |
| Colors/Finishes | Title Case per item | walnut/black leather → Walnut / Black Leather |
Known brand abbreviations to preserve: HAY, USM, B&B, DWR, CB2, HBF, OFS, SitOnIt, 3form, ICF
Map free-text categories to the canonical vocabulary and alias table defined in ../../schema/product-schema.md. Read that file for the full mapping of variations (English, Spanish, legacy terms) to canonical category names.
If a category is ambiguous, keep the closest match and add a [?] flag for the user to review.
Splitting combined dimensions:
| Input | → W | → D | → H | → Unit |
|---|---|---|---|---|
32 x 24 x 30 in | 32 | 24 | 30 | in |
80 × 60 × 75 cm | 80 | 60 | 75 | cm |
W32 D24 H30 | 32 | 24 | 30 | (infer) |
32"W x 24"D x 30"H | 32 | 24 | 30 | in |
Ancho: 80, Prof: 60, Alto: 75 cm | 80 | 60 | 75 | cm |
Dimension rules:
" as inches, ' as feet (convert to inches: 2'6" → 30)×, x, X, by, por as separatorsin. If values suggest cm (> 100 or explicit), use cm. If truly ambiguous, flag with [?].Do NOT convert units. Keep the original unit. Designers need the manufacturer's spec for ordering.
Detect the language of each field value and normalize to English unless the user specifies otherwise.
| Spanish (common in UY sources) | → English |
|---|---|
| Silla | Chair (category) |
| Mesa | Table (category) |
| Escritorio | Desk (category) |
| Madera | Wood (material) |
| Cuero | Leather (material) |
| Acero | Steel (material) |
| Vidrio | Glass (material) |
| Tela | Fabric (material) |
| Mármol | Marble (material) |
| Roble | Oak (material) |
| Nogal | Walnut (material) |
| Blanco | White (color) |
| Negro | Black (color) |
| Natural | Natural (keep as-is) |
| Cromado | Chrome (finish) |
Rule: Translate category, material, and color/finish fields. Leave Product Name and Brand as-is (proper nouns).
If the user says "keep in Spanish" or specifies a target language, respect that.
Standardize common material terms:
| Variations | → Standard |
|---|---|
| SS, Stainless, S/S | Stainless steel |
| Ply, Plywood, Mold ply | Molded plywood |
| MDF, Medium density | MDF |
| HPL, High pressure laminate | HPL |
| Lam, Laminate | Laminate |
| Fab, Textile | Fabric |
| COM, C.O.M. | COM (Customer's Own Material) |
| COL, C.O.L. | COL (Customer's Own Leather) |
| Powder coat, PC, Pwdr | Powder-coated |
| Chrm, Chrome plated | Chrome |
| Anodized alum, Anod. | Anodized aluminum |
| Ven, Veneer | Veneer |
| Sol. wood, Solid | Solid wood |
$, €, £, ¥) — store symbol as currency code in separate column. and , — detect locale: 1.234,56 is EU format, 1,234.56 is US)5695.00$ alone defaults to USD unless context suggests otherwise (UY site → UYU, EU site → EUR)wood / metal / glass → Wood, Metal, Glass (comma-separated)Read the input. Report: "Loaded N rows with M columns." Map input columns to the canonical schema. If column mapping is ambiguous (e.g., a column called "Size" could be combined dimensions), ask the user.
Scan all rows and produce a summary:
## Cleanup Preview
- **Casing**: X product names need Title Case
- **Categories**: Y rows have non-standard categories (mapping: "chairs" → Seating, etc.)
- **Dimensions**: Z rows have combined dimensions to split
- **Language**: W rows have Spanish-language fields to translate
- **Materials**: V rows have non-standard material terms
- **Prices**: U rows need currency formatting cleanup
- **Duplicates**: T potential duplicate rows found
- **Empty fields**: S rows missing dimensions, R rows missing price
Ask: "Apply all fixes, or select which ones?"
If the user wants to be selective, let them pick from the list. Otherwise, apply all.
Process every row through the active cleanup rules. Track every change made.
Show a before/after diff for a sample of changed rows (up to 5 examples). Then show the full cleaned table.
Report:
## Cleanup Complete
- Rows processed: N
- Changes made: X
- Flagged for review: Y (marked with [?])
Ask: "Save where?" Options:
-clean to filename)