Inventory Management System for Drilling Operations
Oil & Gas
A complete materials and inventory workbook for a drilling services company. It links every well design to the chemicals and cement it consumes, tracks monthly usage…
View projectCategory
Management Systems
Inventory, HR, hotel, CRM and order management systems built entirely in Excel with forms and databases.
Luggage Transport Booking System
Travel & Tourism
Built for a hiking tour operator. Each booking is entered once with its stretches, dates and luggage count, and the system distributes it to every supplier…
View project
Trade Opportunity Finder & Profitability Analysis
International Trade
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading…
View project
Invoice Generator with Customer & Product Database
Wholesale Distribution
An invoicing system for a skincare wholesaler. Invoices are created from customer and product databases, saved, searched, reloaded and printed, and a best-selling report is updated…
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
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project
Staff Leave & Attendance Manager
Human Resources
Tracks staff attendance and seventeen leave types with yearly allowances. Monthly attendance grids, period and yearly reports and PDF and CSV exports are all generated by…
View project
Sales & Purchase Inventory Data Model
Trading
A relational data model in Excel with customers, suppliers, products and countries. Sales and purchase orders are entered through forms, stock levels update automatically and customs…
View project
Account Reporting Tracker
Food & Beverage Brokerage
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file…
View project
Property Management Rent Ledger
Property Management
A rent and landlord statement system. Each property has its own ledger of rent, fees, VAT and landlord payments, statements are imported, and the dashboard totals…
View project
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project