Spreadsheets that work for you
Excel and Google Sheets as working systems: data collection, analytics, dashboards, automation and a Telegram link.
WSH LAB turns ordinary spreadsheets into managed tools: formulas calculate, VBA macros and Google Apps Script scripts handle the routine, and data is collected and updated without manual copying.
A good fit when a business needs a fast, clear result on familiar tools, without a heavy CRM and a long implementation.
A finished project: controlling sites and contracts in Excel
The “Capital Repairs. Control” workbook: data on site works, contractors, contracts and deadlines is collected in one book, and the dashboard shows the state of all works and recalculates when you pick filters.
The video is a demonstration: names, addresses, contract numbers and system notifications are hidden.
What the workbook does
- shows the overall picture: number of works, contract amounts, advance, amount due for acceptance, and works whose deadlines need checking
- drop-down filters: city, system, subcontractor, contract and deadline assessment date
- charts by system, physical readiness and city
- a table of works with a readiness bar, deadline and action status
- summaries by system, city and subcontractor for the selected filters
- entry control: the workbook itself hints where to check the price or the stages
How it is built
One row on the “Sites” sheet is an address and a system. Yellow fields are filled in manually, white ones are calculated by formulas, so it is harder to make a mistake and calculations do not break.
What the manager gets
No need to assemble reports by hand: just choose a contractor or a city to see the amounts, work readiness and a list of sites where deadlines are in question.
What stays with the team
The workbook has a “How to use” sheet with instructions, so several employees can maintain it without constant help from the author.
What we do
Records and CRM in spreadsheets
Requests, clients, payments and statuses in one structured table: with input validation, drop-down lists and highlighting.
Calculations and calculators
Estimates, price lists, cost and deadline calculations: formulas that recalculate on their own and do not break after manual edits.
VBA macros for Excel
Buttons and procedures for routine operations: summary reports, document generation, PDF export, processing large files.
Apps Script for Google Sheets
Scheduled and event-based runs, form handling, notifications, autofill and web interfaces on top of a spreadsheet.
Telegram and service integrations
Notifications and commands from a spreadsheet to Telegram, data exchange between Sheets, Excel, email and external APIs.
Reporting and dashboards
Pivot tables, charts and totals by status, owner and period: they update together with the data.
What else is in this section
We build on what we have already done: spreadsheets with Apps Script, Telegram bots and content automation.
Data collection
Google Forms and a Telegram bot collect data from staff straight into the spreadsheet. Excel and CSV files are imported by template, and reference lists prevent invalid entries.
Data quality control
Row hints (“check the price”, “check the stages”), required fields, duplicate checks and a change log, so the numbers can be trusted.
Summaries and analytics
Summaries by system, city, contractor and deadline, deadline assessment for a chosen date, rankings and plan vs actual comparison. Formulas work in both Excel and Google Sheets.
Dashboards with filters
Indicators, charts and tables with color scales. Filters are drop-down lists, so the dashboard is easy to use without training.
Automation
VBA macros for Excel and Apps Script triggers for Google Sheets: recalculation, PDF reports, mailings and scheduled checks.
Telegram integration
Overdue notifications, a daily summary for the manager, bot replies to a report request by command, and data intake from staff through the bot.
Templates for your task
Request tracking, control of sites and contracts, HR analytics (staffing and turnover), stock and inventory, content plans. We take a template as a basis and adapt it to your process.
Handover and support
Instructions inside the workbook, protection of formulas from accidental edits, staff training and refinement after launch.
Moving to another format
If a spreadsheet outgrows Excel or Google Sheets, the data is moved to a web app or a Telegram Mini App. An example of such a path: WSH LeadFlow.
Where it applies
We use the same approach in our own projects: for example, in AI News Publisher the content plan, statuses and publications run on Google Sheets and Apps Script.
Have a spreadsheet that eats too much of your time?
Tell us how you work now, and we will suggest what to automate first.