Network Device Lifecycle Analysis
A lifecycle report for more than ten thousand routers and switches. Each device is matched to its end of software maintenance date and replacement model, and a refreshable pivot report totals the replacement cost.
- Industry
- IT Infrastructure
- Deliverable
- Switch Lifecycle Analysis.xlsm
- Built with
- Excel VBA, Power Pivot style reporting, Lookups
Before
More than ten thousand devices had to be checked one by one against end-of-maintenance dates.
After
Every device is matched to its end date and replacement model automatically, and the replacement cost is totalled in a refreshable report.
More like this
Related projects
Counselor Service Hours Report
Healthcare (Behavioral Health)
A counselor selector report that shows, for any week, how many minutes of individual, group, treatment coordination and peer support each assigned client received, with alerts…
View project
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
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