Examples
Examples
Try the starting example
- Devices JSON [[installation day,manufacturer interval days,battery type integer],...]
- [[0,3650,1],[100,3650,2],[200,3000,1]]
- Today (days from your chosen epoch)
- 3200
- Device, replacement due day, days remaining table
- [[1,3650,450],[2,3750,550],[3,3200,0]]
- Due/overdue device count
- 1
- Due/overdue quantities by battery type
- [[1,1]]
Try another scenario
- Devices JSON [[installation day,manufacturer interval days,battery type integer],...]
- [[1,3650,1],[100,3650,2],[200,3000,1]]
- Today (days from your chosen epoch)
- 3200
- Device, replacement due day, days remaining table
- [[1,3651,451],[2,3750,550],[3,3200,0]]
- Due/overdue device count
- 1
- Due/overdue quantities by battery type
- [[1,1]]
Calculation method
Calculation method
Device, replacement due day, days remaining table
Replacement due=installation day+supplied manufacturer lifetime; classify against entered today.
Due/overdue device count
Replacement due=installation day+supplied manufacturer lifetime; classify against entered today.
Due/overdue quantities by battery type
Replacement due=installation day+supplied manufacturer lifetime; classify against entered today.
Symbols and units
- a
- Devices JSON [[installation day,manufacturer interval days,battery type integer],...]
- b
- Today (days from your chosen epoch)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- Calendar worksheet uses user epoch and manufacturer intervals; no inferred legal replacement standard. Supported limits: All required fields must be finite values of the exact declared type and within displayed bounds. Lists contain1–1000 finite numbers. JSON tables are numeric rectangular rows, at most100 rows and30 columns; individual tools have stricter shape/domain constraints. Calendar worksheet uses user epoch and manufacturer intervals; no inferred legal replacement standard.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.