Toggle User Mode ⇄ Dev Mode Instantly
Book Butler packs and unpacks complex Excel models for you. Users reliably and only see the clean sheets meant for them, while your background sheets stay hidden and protected.
What is Book Butler?
It's a hyper-organized Excel add-in for model builders and workbook engineers. Configure once which sheets, rows, and columns belong in User Mode vs Developer Mode. Then click Pack or Unpack to switch contexts instantly.
No more forgetting to re-hide calc sheets or helper columns for end users.
Why it matters
Serious financial models and forecasting workbooks evolve into ecosystems: input hubs, staging tables, lookup matrices, schedule builders, audit trails, scenario drivers, and reporting surfaces.
Maintaining trustworthy separation between clean user surfaces and backend mechanics is fragile and manual. Book Butler eliminates the tedium and risk.
Hide & protect backend sheets automatically.
Reveal only curated input & output surfaces.
Store row / column visibility states.
One-click Pack (User) / Unpack (Dev).
Core Workflow
- Open the Butler panel and mark sheets as Backend or User-Facing.
- Optionally flag sensitive calc rows / columns to auto-hide in User Mode.
- Click Pack to enter User Mode: backend sheets hidden or locked; flagged rows/columns hidden.
- Click Unpack to re-enter Developer Mode: all your engineering context is restored.
The Butler remembers your configuration per workbook so you never repeat setup.
Frequently Asked Questions
Financial modelers, project controls & cost engineers, FP&A analysts, power spreadsheet builders, and anyone curating complex multi-sheet solutions.
Eliminates manual hide/unhide routines, prevents leaking backend logic to stakeholders, reduces distribution mistakes, and accelerates iteration by restoring full dev context instantly.
No. It only toggles visibility / protection flags you configure. Your workbook structure and data remain local and unchanged.
Public release is targeted for Winter 2025. Early access invitations will roll out sooner—stay tuned.
© 2025 Sumer Inc. All rights reserved. Privacy Policy.License Agreement. Custom website