Crane Rental KPI Dashboard in Excel

The Crane Rental KPI Dashboard in Excel puts 15 crane-hire KPIs from 6 groups on one monthly scorecard. For each KPI it shows MTD and YTD actual, target, achievement percentage, a traffic-light status and a prior-year comparison. With the September 2025 sample selected, the summary cards read 6 KPIs On Target, 6 At Risk and 3 Missed for the year to date, with average achievement of 98.5% MTD and 99.1% YTD.

Crane hire firms usually track utilisation in one file, breakdowns in a maintenance log, and safety numbers in an HSE report, so a monthly review means stitching three sources together. This Excel KPI Dashboard template puts fleet, commercial, maintenance, operations, workforce and safety KPIs in one workbook, driven by a single month dropdown. It is the KPI Dashboard family from NextGenTemplates: a month picker, traffic lights, a KPI Trend page and a KPI Analysis page. It is not an analytical data dashboard or a KPI Scorecard.

Crane Rental KPI Dashboard in Excel - KPI Dashboard page

Key Features of the Crane Rental KPI Dashboard in Excel

15 ready-made KPIs for crane rental. Fleet Utilisation Rate, Crane Availability / Uptime, Idle Fleet Days, Average Day Rate, Revenue per Available Crane, Customer Satisfaction (CSAT), Unplanned Downtime Hours, Maintenance Cost per Operating Hour, Preventive Maintenance Completion, On-Time Mobilisation, Lift Completion Count, Operator Utilisation, LTIFR, Near-Miss Reports and LOLER Inspection Compliance.
One month picker. Cell D6 on the KPI Dashboard lists the twelve months of the reporting year. Changing it recalculates the scorecard, the seven summary cards and the KPI Analysis page.
Direction-aware achievement. Achievement is Actual divided by Target for Upper The Better KPIs and Target divided by Actual for Lower The Better KPIs. The sample has 11 UTB and 4 LTB KPIs, so cutting downtime below target scores above 100%.
Consistent status rules. On Target from 100%, At Risk from 95% to 99%, Missed below 95%, used on every page.
Built to grow. The sheets are wired for 22 KPIs. Adding a row on KPI Definition feeds all three input sheets, the scorecard, the trend page and the analysis page.
Formula-only. No macros, Power Query, Power Pivot or add-ins. It runs in Excel 2013 and later, and in Excel for the web.

Dashboard Pages Explanation

The workbook has 11 sheets. Ten are shown below. The eleventh, Support, holds helper calculations and needs no editing.

Home

The landing page links to the three dashboard pages (KPI Dashboard, KPI Trend, KPI Analysis), the three input sheets, and the reference sheets (KPI Definition, Read Me, Get More Templates). It also summarises the five things the template does.

KPI Dashboard

Seven cards sit across the top: Total KPIs Tracked (15), On Target YTD (6), At Risk YTD (6), Missed YTD (3), Improving vs PY MTD (11 of 15), Avg Achievement MTD (98.5%) and Avg Achievement YTD (99.1%). Below them, one row per KPI shows group, name, unit and type, then a Month To Date block and a Year To Date block. Each block has actual, target, achievement %, status, prior year and vs PY, with arrows whose colour reflects whether the movement is good for that KPI.

KPI Trend

Choose a KPI in cell B4 and the page shows its group, unit, type, owner, priority, frequency, formula and definition. A twelve-month table lists MTD and YTD actual, target, prior year, achievement and status. Two charts follow: MTD Trend by Month and YTD Trend by Month, each with actual and prior-year columns and a target line. The screenshot shows Fleet Utilisation Rate, owned by the Fleet Operations Manager.

KPI Analysis

This page follows the month picked on the KPI Dashboard. Performance by KPI Group shows each group’s KPI count, On Target, At Risk and Missed counts, and average MTD and YTD achievement. In the sample, Operations leads at 101.2% YTD and Workforce trails at 94.6%. The Average YTD Achievement by KPI Group chart shows the same comparison as bars. Top 5 and Bottom 5 Performing KPIs (YTD) rank the list: Near-Miss Reports tops it at 107.0%, and LTIFR sits at the bottom at 93.5%.

KPI Input – Actual

Enter the actual MTD and YTD result for every KPI, month by month. Cell E3 is the first month of the reporting year. Change it and the month headers, the dropdown and every sheet title re-base.

Crane Rental KPI Dashboard - Actual values input

KPI Input – Target

The same grid for targets. Its month headers follow the Actual sheet, so you never retype them.

Crane Rental KPI Dashboard - Target values input

KPI Input – PY

Last year’s results. The headers are the Actual sheet’s months shifted back twelve months, which feeds the Prior Yr and vs PY columns.

Crane Rental KPI Dashboard - Prior year values input

KPI Definition

The master list with number, group, name, unit, formula, definition, UTB/LTB type, owner, priority and frequency. For example, Revenue per Available Crane is defined as Total Hire Revenue divided by the Number of Available Cranes in Fleet.

Read Me and Get More Templates

Read Me covers the five-minute setup, the MTD/YTD rules, UTB and LTB, achievement, status, arrows, and how to add, rename or remove KPIs. Get More Templates links to other NGT products.

Crane Rental KPI Dashboard - Get More Templates

Crane Rental KPI Dashboard in Excel vs. Google Sheets Equivalent vs. Paid Rental Software: Feature Comparison

Feature	Crane Rental KPI Dashboard in Excel	Google Sheets KPI template	Paid rental / fleet software
Cost	One-time purchase	One-time template price	Recurring subscription, usually per user or per asset
Platform	Excel 2013+, Excel for the web	Google Sheets	Vendor web app
Setup time	Type monthly figures on three sheets	Similar	Onboarding and data migration
Real-time team collaboration	Co-authoring via OneDrive or SharePoint	Native	Native
Mobile access	Excel mobile app	Google Sheets app	Vendor app
Customisable KPIs	Up to 22, no formula edits	Depends on template	Limited to vendor reports
MTD / YTD traffic lights with UTB and LTB	Built in	Depends on template	Varies
Telematics, dispatch, job costing	No	No	Yes
Year-1 cost at 5 users	No per-user fee	No per-user fee	Five subscription seats

For crane hire firms that want a disciplined monthly KPI review without another subscription, this workbook sits in the sweet spot.

Who Should Use This Template

Perfect for:

Owners and general managers of mobile, crawler or tower crane hire businesses
Fleet, maintenance and workshop managers reporting utilisation, uptime and downtime
Commercial directors watching day rate, revenue per crane and customer satisfaction
HSE managers who present injury-rate and near-miss trends alongside operational KPIs

Not a fit if:

You need live telematics, dispatch, lift planning or job-level costing
You need a system of record for thorough examinations, inspections or certificates
You want numbers pulled from an ERP automatically rather than typed monthly

Real-World Use Cases

A fleet director at a regional mobile crane hire company fills in the three input sheets on the first working day of the month. Fleet Utilisation Rate, Idle Fleet Days and Crane Availability / Uptime then show where cranes are earning and where they are idle in the yard, before the monthly board pack is due.

An HSE manager selects LTIFR on the KPI Trend page to show the twelve-month MTD and YTD pattern against target. The Safety & Compliance group row on KPI Analysis gives the combined picture for LTIFR, Near-Miss Reports and inspection compliance.

A commercial director compares Average Day Rate and Revenue per Available Crane with the prior year, then takes the Bottom 5 table into the pricing review. In the sample those are LTIFR, Operator Utilisation, Idle Fleet Days, Maintenance Cost per Operating Hour and CSAT.

Advantages of the Crane Rental KPI Dashboard

One review, one file. Fleet, commercial, maintenance, operations, workforce and safety KPIs share the same month, the same thresholds and the same layout.
Fair scoring for cost and downtime KPIs. Lower-the-better KPIs are inverted automatically, so a good month for downtime looks like a good month.
Prior-year context everywhere. Every KPI carries last year’s value and a vs PY percentage, for both MTD and YTD.
Easy to audit. Plain formulas you can trace, with no hidden model, query or macro.
One-time cost. No subscription and no per-user fee.

Opportunities for Improvement

Stale KPI count in the text. The Home page (“every one of the 14 KPIs”) and the Read Me (“14 are filled in”) still say 14, but the workbook ships with 15. The calculations are correct. Only the wording is out of date.
Leftover example in the Read Me. The Cumulative or average YTD note uses “aircraft deliveries, non-conformance reports” as examples, carried over from another industry’s template. Edit that cell to crane examples such as lift completions and near-miss reports.
Manual data entry. MTD and YTD values are typed on the input sheets, and nothing connects to telematics, a rental system or an ERP.
YTD is not derived. You store YTD yourself, which gives control over sums versus averages but means both columns need filling.
Single-level view. KPIs are fleet-wide, with no per-crane, per-depot or per-customer breakdown.
No compliance function. LOLER Inspection Compliance is a percentage you enter. The workbook does not record, verify or certify examinations, and is not evidence of LOLER, OSHA or ASME compliance.

Best Practices

Agree each KPI’s formula and owner on KPI Definition before entering data, so the monthly numbers mean the same thing every time.
Decide per KPI whether YTD is a running sum (lift counts, downtime hours) or a running average (rates and percentages), and keep it consistent.
Set realistic targets. With a 95% At Risk floor, stretch targets turn much of the board amber.
Enter prior-year data for all twelve months so the vs PY arrows stay meaningful.
Review the Bottom 5 table first each month, then use KPI Trend to check whether a miss is a one-off or a trend.
Learn how the month list is built with Microsoft’s guide to the EDATE function and to creating a drop-down list.

Explore Relevant Templates

Construction Equipment KPI Dashboard in Excel: KPI tracking for a broader construction plant fleet.
Heavy Machinery KPI Dashboard in Excel: machinery performance KPIs.
Rental Equipment Management System Web App: bookings and returns for the operational side.
Equipment Maintenance Management System Web App: work orders behind your maintenance KPIs.

Frequently Asked Questions

What KPIs are in the Crane Rental KPI Dashboard in Excel?

It ships with 15 KPIs in six groups: Fleet & Assets (3), Commercial (3), Maintenance (3), Operations (2), Workforce (1) and Safety & Compliance (3). They include Fleet Utilisation Rate, Average Day Rate, Unplanned Downtime Hours, On-Time Mobilisation, Operator Utilisation and LTIFR. You can edit them or add more, up to 22.

How do I track crane rental KPIs in Excel with this template?

Type monthly MTD and YTD actuals, targets and prior-year values on the three input sheets, then pick a month in cell D6 on the KPI Dashboard. The scorecard, traffic lights, summary cards and group analysis all recalculate from that one choice.

Does it need macros or Power Query?

No. It is a plain .xlsx built from worksheet formulas such as VLOOKUP, INDEX, MATCH and COUNTIF. There are no macros, Power Query, Power Pivot or add-ins, and it opens in Excel 2013 and later and in Excel for the web.

How long does setup take?

If your monthly figures already exist, setup is mostly typing them into the Actual, Target and PY sheets and setting the first month in cell E3. The dashboard pages need no configuration, because they read the KPI list and month headers automatically.

Is this a LOLER or OSHA compliance tool?

No. The LOLER Inspection Compliance KPI is a percentage calculated from numbers you enter. The workbook does not store examination reports, verify certificates, check operator competence or plan lifts, and it is not evidence of LOLER, OSHA or ASME compliance.

How does it compare with paid rental software?

Rental and fleet platforms run bookings, dispatch and telematics on a subscription. This Excel KPI Dashboard template does one job, the monthly KPI review with targets, prior year and traffic lights, for a one-time price with no per-user fees.

About the Author

Built by PK, a Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience and the founder of NextGenTemplates, whose YouTube channels reach 300K+ subscribers. Every template is hand-built and tested before release.

Conclusion

The Crane Rental KPI Dashboard in Excel gives a crane hire business one monthly view of fleet utilisation, day rate, downtime, mobilisation, workforce and safety KPIs. MTD, YTD and prior-year comparisons, plus trend and group analysis, all run from a single month dropdown. It is honest about its limits: data is typed in, KPIs are fleet-wide, and it is not a compliance record.