Turned 52 messy rows into a clean Master Data Room for 46 freezer models, 277 units, ₦120,547,500 valuation.
4 brands: Skyrun, 【entity-LG¦canonical_name=LG】, Hisense, Haier Thermocool.
What I built:
7-tab Master Sheet - clean, standardized, no duplicates
Valuation Dashboard - total value by brand, by model, by status
Traffic Lights - stock status at a glance
Reorder alerts - know what to restock before you run out
Warranty Tracker - track warranty end dates
Apps Script that refreshes everything in 0.249 sec
Result: From messy spreadsheet to investor-ready data room the client can use daily, with full handover and Transfer of Ownership.
0 likes · 0 views · Nov 11, 2026
Cleaned 52 messy rows into 46 models, 277 units, ₦120M valuation with 7-tab Master Sheet, Valuation Dashboard, Reorder alerts & Warranty Tracker.
