STR LEDGER
Node scripts that generate a ledger-first short-term-rental workbook with formula-driven category rollups, plus a rate-limited keyword research tracker.
nodeexceljsautomationresearch
// problem
Spreadsheets built by hand drift. Formulas break and categories go out of sync.
// constraints
- Output must open in plain Excel.
- Research must respect rate limits.
// approach
- ExcelJS builds the whole workbook from code: bookings, expenses, monthly rollups.
- A verification script recalculates formulas to catch errors before the file ships.
- Keyword research runs on a strict daily cap and never estimates a missing value.
// outcome
A rebuildable workbook: change the code, regenerate, verify.