Challenge
Challenge
Opening a form triggered several workbook reads. Downloading and parsing the whole file made the experience slower and harder to trust.
Inventory / Production Ops
Raw material stock optimization for production
After production forms were live, the next bottleneck was stock-read speed and confidence in the remaining quantity. OPERCEL moved reads to Excel Tables, added TTL-based cache, and invalidated stock after writes.
60sstock TTL
10mlookup TTL
52nodes after cleanup
Approach
Approach
- Read Excel Tables directly instead of downloading the workbook.
- Separate lookup cache from stock cache because they change at different speeds.
- Remove public debug routes after the main workflow was verified.
Expected result
Expected result
- Warm form loads are faster.
- Stock is refreshed after submit instead of serving stale inventory.
- The workflow is easier to maintain and expand.