Survey Completion Dashboard
A one-page management dashboard that tracks property survey progress against yearly and monthly targets. Weekly exports from the survey platform are imported with one click and every KPI, chart and area summary refreshes automatically.
- Industry
- Housing & Property Surveys
- Deliverable
- Survey Dashboard.xlsm
- Built with
- Excel VBA, Dynamic arrays, Charts
Before
Weekly survey exports were copied into separate sheets by hand and progress against targets was worked out manually.
After
One click imports the weekly export and every KPI, chart and area summary updates against yearly and monthly targets.
More like this
Related projects
Payroll & Billing Hours Automation
Healthcare (Home & Community Services)
Automates the bi-weekly payroll check for a home and community services provider. Staff and billing reports are downloaded from the EHR, billed hours are summarised by…
View project
Product Analysis Report Generator
FMCG / Retail Analytics
An automated sales analysis tool for a beverage brand. Raw point-of-sale data is imported, a pivot master is built and the macro produces Pareto, NIS and…
View project
Bill of Materials Cost Comparison
Manufacturing
Compares part costs across product models from a grouped bill of materials. Raw data is imported and a results matrix shows quantity, cost and platform for…
View project