Spreadsheet wizardry
An extensive Google Spreadsheet project including 40+ individual sheets of mostly related data. The project features several templates for automatic invoice creation, multiple API connections, custom plugins using HTML and CSS dialogs, dashboards with data visualizations, KPIs and prepared data exports.
The biggest challenges working with Spreadsheets are maintainability, scalability, and making sure your users don’t break it.
The tool has been in use for several years now, enabling a relatively small financial department to deal with the growing complexity and sheer volume of data. In an effort to take the analytical possibilities to the next level, and unify more workflows involving many departments, the Spreadsheet project will be incrementally replaced by a new CRM tool based on React, GraphQL, and NestJS.
The Spreadsheet makes use of a wide spectrum of Google Sheets features
- Advanced Cell Formulas
- Google App Scripts
- Named Ranges
- Macros
- Dialogs
- Time-based triggers
- DB connectors
- Data Validation
- Conditional Formatting
- Dependent Dropdowns
- etc.