Many processes run on a spreadsheet and an email thread: a request in a workbook, a chain of replies, a final version typed into the ERP.
| Element | What it holds |
|---|---|
| Master workbooks | one per process, with tabs per site or month |
| Extracts | ERP downloads pasted in weekly |
| Formulas and macros | the logic, often with links to other workbooks |
| Email threads | the approvals and the escalations |
| Shared drives and attachments | the versions |
| Re-keying | the final entry into the ERP by hand |
| In spreadsheet-and-email processes | In SmartApps |
|---|---|
| An extract pasted into a tab | A data handler on the ERP object, read in place |
| A tab of calculations | A query handler or expressions on a screen |
| The grid people edit | A grid component with inline edit and validation |
| An email asking for approval | A level in an approval flow, with a clock and an alternate |
| A reply with a decision | A logged step with the values shown and entered |
| Typing the result into the ERP | A write-back through the released interface, acknowledged |
| Version 14 of the workbook | Versions of the app, and one instance per case |
Spreadsheets stay for analysis; the move is for the processes that need an owner, a clock and a record.
A consumer-goods company ran its excess stock review on a 40-tab workbook refreshed on Mondays and 200 emails a month. The excess and obsolete inventory review app read the stock positions and the last movements live, opened one instance per position above 12 months of cover, and gave planners a grid they recognised. The Monday refresh disappeared, the reserve calculation ran from the same rows, and the controller's sign-off was one screen.
It becomes a registered function the app's actions call by name, with its inputs and outputs logged.
The process owner, with the configurator role; the application team keeps the gates and the write-back switches.
The inventory is fixed-scope; the first ten apps carry a fixed price written before the work; the platform is priced by capacity with apps included.
We list the applications, the forms and the workflows you run today, group them by the app type they become, and write a fixed price for the first ten before any work begins.