Hospitality - Automation of room inventory, produce, purchase order, invoice, cleaning & maintenance tracking. Easy entry forms for capture and reporting.
Job Management Database
Commercial Flooring - Custom Excel system linked to an SQL Database. Client liked the look & feel of Excel with the ability to share data with multiple users at the same time.
Excel Modelling
Concrete Production - Our client reported this Excel solution paid for itself within 3 months of use, as it ensured waste kept to a minimum & less job delays due to products forecast for sales were always in stock when required by clients.
Job Schudule
Kitchen Design - Automated the time slot lookup for new jobs. Added job activity calculations & an easy to read shared calendar for staff to work from.
Rate Calculator
Used built-in Excel functions to automate the sets of rates for different transport options based on distance & vehicle types
Timesheet Template
Construction Industry - Custom timesheet to capture start & finish times, allowing for lunch breaks & including loading for hours worked.
Risk Register
Government restructure - Included a Heat Map that provided a quick & easy focus on the greatest risks to the change program.
Financial Spreadsheet
Mortgage Broker commission check - Excel workbook to import bank statement raw data then calculate to check commissions paid matched the brokers arrangement.
Job Booking
Concrete Construction - Excel Job Booking and Job Control workbook solution to organise booking activities for a large number of jobs the client had underway at any time.
Manufacturing Cost Estimation
Steel Fabrication - custom cost estimate tool to assist in the complex nature of quoting steel fabrication for the clients bid process for projects.
Excel Workbook Solution
Personal Trainer Tracker - A user friendly visual personal fitness card for the personal trainers clients to track their fitness & health objectives & progress
Contact a consultant to get started.
We reply same day.
Testimonials
“XLAutomation are the go to consultants for customising Excel to work exponentially better for your business. We have achieved cost savings and time efficiencies from using their Excel Consulting Service.”
