The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
I designed and developed this Microsoft Excel manufacturing operations system as a self-initiated Nomika Studio project.
The workbook brings several operational areas into one structured system, including inventory, bill of materials (BOM), production planning, purchases, sales and dashboard reporting.
Key features include a Production Flow Board, production planning with material-readiness and BOM coverage checks, purchase and vendor tracking, structured input tables, dropdowns, data validation, automated formulas, KPI cards, charts and clear workbook navigation.
The main challenge was connecting multiple operational workflows while keeping the workbook practical and understandable for everyday use.
This project demonstrates my ability to build larger Excel business systems, not just individual dashboards or simple trackers.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
BEFORE: Client had messy Excel inventory with 500 rows, duplicates (A12 / a12), blanks, wrong prices like "$ 2.5" and "N/A", and different warehouse names (KER / ker / Kericho).
AFTER: I did:
Removed 12 duplicate SKUs
Standardized item names to Title Case
Fixed QTY and Prices to 2 decimals
Unified Warehouse to Kericho
Made sheet ready for pivot dashboard
Result: Clean, ready-to-use inventory in 2 days using Excel.
Tools: Excel, Remove Duplicates, Text to Columns, TRIM, PROPER
I designed and engineered this interactive astronomical almanac for Ephemeris.
Blending nineteenth century celestial cartography with responsive data visualization required coordinating intricate astronomical calculations with period print typography. Programming a rotatable calendar dial that recalculates the night sky in real time, projecting accurate planetary alignments and lunar phases alongside a cataloged archive spanning 174 historical editions, turned complex ephemeris tables into an engaging visual experience.😊 👍
Cleaned and formatted a raw dataset in Excel by removing duplicates, fixing formatting issues, handling missing values, and organizing the data into a structured format for analysis.
