Designing Clarity from Heartbreak · Pre-Order Now
ARC/02 // IDLE
Available for Hire
Case Study

From Incomplete Planning Artifacts to Reviewable Interface Structure

I designed SheetFlow as a designer-controlled translation system for a recurring product-design problem: structured interfaces often begin as incomplete spreadsheets and planning matrices that were never designed to describe UI. It interprets those inputs, surfaces ambiguity early, maps intent to reusable components, and compiles reviewable wireframes with optical QA.

ROLE
Product designDesign systemsSemantic architectureAI workflowBuilder
OUTCOMES
  • Semantic translation layer separating intent from components
  • Preflight ambiguity review surfacing missing assets and overflow
  • Optical QA verification for spatial baseline and token consistency
View the system model
SheetFlow Translation Pipeline Preflight Interface (Synthetic Demonstration)

The Spreadsheet Was Never the Interface Specification

Planning spreadsheets can be fast and familiar for cross-functional partners while still containing shorthand, missing hierarchy, incomplete intent, inconsistent labels, ambiguous component expectations, and an order that describes content inventory rather than interface structure.

Designers spend countless hours manually parsing shorthand cells, checking undocumented widget names against design libraries, manually re-typing titles, and catching layout overflow errors late in the cycle. The friction is not drawing rectangles—it is interpreting raw intent into valid, extensible system components.

01 / SHORTHAND AMBIGUITY
Inconsistent Vocabulary
Planning rows use author shorthand, informal widget names, or unvalidated component tokens that do not cleanly map to design systems.
02 / SILENT FAILURE
Overflow & Missing Assets
A cell specifies 9 tiles for a component that holds 8, or references unbuilt image assets without warning until downstream assembly.
03 / MECHANICAL TOLL
Repetitive Transcription
Designers burn high-value creative judgment on mechanical copy-pasting, manually binding text properties, and verifying basic padding.
“The expensive step is not drawing rectangles. It is translating intent into a system that can be reviewed, built, and extended.”

Meaning Before Implementation

SheetFlow establishes a rigorous linear compilation pipeline: raw planning inputs are parsed into a normalized intermediate schema, evaluated for semantic ambiguity, compiled into ordered wireframe structures, and verified for optical quality before human approval.

STAGE 01

Planning Input

Spreadsheets & content matrices with author shorthand.

STAGE 02

Parse & Normalize

Extract raw cell values, clean labels, and strip formatting noise.

STAGE 03

Semantic Interpretation

Map intent to normalized component families and variant properties.

STAGE 04

Ambiguity Review

Surface open questions, missing assets, and overflow before build.

STAGE 05

Component Mapping

Bind validated slots to published design system component sets.

STAGE 06

Wireframe Compilation

Assemble ordered vertical frame hierarchy with auto-layout.

STAGE 07

Annotation & Optical QA

Verify alignment guides, padding bounds, and implementation notes.

STAGE 08

Designer Approval

Human designer retains ultimate authority to approve or refine.

The Hard Part Was Never Drawing the Wireframe

SheetFlow cleanly separates meaning from implementation. It translates informal planning rows into an unambiguous semantic interpretation before binding them to specific UI components.

RAW PLANNING ROW INPUTROW 12 · ZONE 01
Feature / Autumn Field Notes / image pending / primary action

A typical planning cell contains mixed signals: content category, copy title, pending asset states, and suggested interaction goals.

Semantic FieldPublic-Safe Interpretation
Section roleEditorial feature
Primary contentImage-led story
TitleAutumn Field Notes
ActionPrimary action button
Unresolved itemImage asset pending delivery
Review stateNeeds designer decision

Once the semantic meaning is extracted, SheetFlow maps the row to a neutral component family such as Editorial Feature (with properties: Grid style: Standard, Image: Inline, CTA: Primary). The designer no longer has to reconcile basic property mismatches row by row.

The System Does Not Get to Pretend It Knows

Most automated tools fail by guessing silently when inputs are incomplete. SheetFlow enforces a preflight surface where uncertainty is made legible and reviewable before any wireframe is generated. Interact with the controls below to resolve or defer flags in real time.

● BLOCKERROW 33
No widget specified for slot: "Seasonal Creator Spotlight"
Content is present but component type is blank — nothing to place.
▲ APPROXIMATIONROW 14
More tiles than component holds: 13 items specified
Standard component max is 8. Auto-split strategy generated: 8 primary + 5 overflow.
● BLOCKERROW 60
Unresolved copy state: "Explore more options (TBD)"
Contains open question mark / TBD token — requires human editorial signoff.

Approved Meaning Becomes Ordered Interface Structure

Once ambiguity is resolved, SheetFlow compiles the structured intermediate into an ordered, responsive wireframe equipped with an explicit presentation annotation rail.

COMPILED WIREFRAME CANVAS375px · VERTICAL AUTO-LAYOUT
SLOT 01 · EDITORIAL LEAD
Autumn Field Notes
Inline image · 3 editorial badges · Primary action button
SLOT 02 · NAVIGATION RAIL
Category Exploration Rail
4 visual tile nodes · Stripped author parentheticals
SLOT 03 · PRODUCT SHOWCASE
Curated Essentials (Split Row 1)
8 standard cards · 16px spatial padding
Source Intent
Interpreted from Row 12 editorial theme. Prioritized as top-of-page discovery anchor per campaign brief.
Mapping Choice
Mapped to Editorial Feature with inline imagery to preserve high visual contrast.
Exception & Override
Resolved 13-item overflow into dual 8+5 row container with preserved zone grouping.
Implementation Note
Binds to published production component tokens; preserves a connected, reusable component structure rather than introducing disconnected one-off layers by default.

Correct Components Can Still Produce a Bad Page

Even when every component is mechanically valid, spatial rhythm, padding inconsistencies, and misaligned baselines can degrade the user experience. SheetFlow adds an assisted optical quality layer.

Without Optical Validation

• Irregular vertical rhythm (8px / 24px / 12px jumps)
• Unaligned card baselines across adjacent zones

Calibrated Spatial Rhythm

✓ Governed 16px continuous vertical baseline
✓ Validated auto-layout padding bounds on all 6 zones

Automation Stops Where Judgment Begins

SheetFlow does not attempt to automate creative taste. It moves designer attention away from repetitive transcription and toward the decisions that actually require design judgment.

SheetFlow Assists With

  • Parsing raw spreadsheet cells and normalizing formatting
  • Cleaning author shorthand and stripping unrenderable labels
  • Semantic translation suggestions from intent to component families
  • Repeatable component mapping and auto-layout assembly
  • Surfacing ambiguity flags and overflow calculations
  • Optical QA signals and alignment checks

Designer Owns

  • Visual hierarchy and storytelling pacing
  • High-level intent and narrative framing
  • Content judgment and nuance validation
  • Final component selection and layout overrides
  • Exception resolution for complex bespoke slots
  • Final pre-publish design approval
“Move designer attention away from repetitive translation and toward the decisions that actually require design judgment.”

Transferable Systems Proofs

STRUCTURED COMPILATION
Transformed unstructured, shorthand planning inputs into validated, extensible component hierarchies.
AMBIGUITY REVIEW
Surfaced edge cases, missing assets, and unresolved intent early rather than silently guessing.
DESIGN-SYSTEM FIDELITY
Bound semantic intent directly to published design system components without introducing drift.
OPTICAL QA
Automated spatial rhythm, alignment checks, and padding validation before human review.
DESIGNER CONTROL
Preserved human editorial authority at every critical decision gate in the pipeline.

“Automation becomes valuable in design not when it makes more decisions, but when it makes the structure around those decisions more explicit.”