I work at a company which owns 2 factories, 1 storage facility, 1 retail facility, administration building. All these locations are on-site and maintained by the same team but have different equipment. I need a single-workbook solution in Excel that lets me stay on top of their upkeep. The file must be driven by VBA and user-friendly forms so anyone in the team can add a new asset, log a repair, or update status without touching raw sheets. Core workflow - One form called for e.g. "enter repair or maintenance" lets user select date, location (factory 1, 2, etc.), equipment category, equipment. Choosing the locations filters the appropriate equipment category which filters the appropriate equipment (e.g. Factory 1 -> BOILERS -> CHANGING ROOM BOILER #2). Then the users selects repair or maintenance; then they can enter notes on the repair; select who did the repair; select a price if applicable; select who accepted/ validated the repair; enter additional notes; all these are separate entries on the form; then the form has a button to save the entry or cancel/empty the fields; there has to be an option if we have a new electritian for e.g., to enter his name in the list of personnel so he can be selectable in the WHO DID THE REPAIR field; • Another form to Enter new equipment details (model, serial, location, purchase date, maintenance interval, retire date). There has to be some way to retire equipment from the enter maintenace form but keep it on dossier. • Record every repair or preventive service with date, technician, parts, cost and notes, so I have a searchable history. • Produce performance reports on demand—downtime, total spend per device, service frequency and any other metrics you suggest that can help us spot problem units. Reminders Pop-up alerts inside Excel are preferred, but I’m fine if the system works off a printable maintenance calendar instead; just make the reminder mechanism easy to toggle on or off. If this is too complicated I can work with manually making a schedule by category for e.g. and then manually tracking maintenance. Deliverables 1. A macro-enabled workbook (.xlsm) with protected formulas and clearly commented VBA. 2. User forms for equipment entry and service log updates. 3. Buttons or ribbon shortcuts that trigger: – “Upcoming Services” printable schedule (PDF or ready-to-print sheet) – On-screen reminder pop-ups (if activated) – “Generate Report” that compiles the KPIs described above. 4. A short read-me or inline help sheet so new staff can pick it up straight away.The forms have to be of familiar windows UI and easy to use by personnel who are not great with computers. I’ll test by entering sample assets and verifying that reminders line up with their intervals, histories are searchable, and the summary report populates correctly.