Rental natural gas compressor callout log for the Permian Basin

Free Download · Compressor Callout Log Template

Log every outage.
Price every hour.
Free, in Excel.

A ready-to-use callout log that turns your outage times into down hours, runtime, the credit your guarantee owes and the production your downtime deferred, unit by unit and month by month.

.xlsx
Excel, Google Sheets, LibreOffice · 124 KB
500
Callouts, 200 units, ready to fill
No email
Just download it

What’s inside

Four tabs. Yellow cells are yours; everything else calculates itself.

Start Here

How to use it, the color legend, and how credits and month boundaries are handled.

Units

Every compressor on rent: vendor, route, monthly rental, production it moves and its runtime guarantee.

Callout Log

Unit, reason, went down, vendor called, arrived, back online. Response, repair, down hours, rental cost and deferred BOE calculate per row.

Monthly Summary

Pick a month. Each unit’s down hours, runtime, allowance, credit owed and deferred production value, with fleet totals. Outages that cross a month end are split between the months.

The Callout Log, column by column

The example row that ships in the template.

UnitReasonWent downArrivedBack onlineResponseDownRental costDeferred BOE
U-101Low suction pressure shutdown10/2 6:1010/2 8:4010/2 13:252.50 h7.25 h$4652.9

How the numbers are calculated

Every formula is visible in the workbook, so anyone can check it.

Down hours

down = (back online − went down) × 24

Response and repair hours are split the same way.

Rental cost of an outage

down hours × monthly rental ÷ (days in that month × 24)

Real calendar hours, never a 730-hour average. An outage across a month end prices each month’s hours at that month’s rate.

Deferred production

down hours × unit BOE/d ÷ 24

Value = deferred BOE × your price on the Monthly Summary.

Credit owed per unit

max(0, down hours in the month − (1 − guarantee) × hours in month) × hourly rental

Only the hours inside the month you choose count; a unit still down counts up to now.

Frequently asked questions

A running record of every time a compressor goes down: which unit, why, when it went down, when the vendor was called and arrived, and when it was back online. It is the evidence behind every runtime credit and every vendor conversation.

For each callout: response time, repair time, down hours, the rental cost of the downtime and the production deferred. For each unit and month: down hours, runtime, the guarantee’s allowance, the credit owed and deferred production value.

Yes. Upload it to Google Drive and open it with Google Sheets; the formulas carry over. It also works in Excel and LibreOffice.

A spreadsheet only knows what someone remembers to type in later. Vendor Callout logs the callout from the truck at the moment it happens, emails the vendor, timestamps their response and prints the monthly report, so nothing is missed and nothing can be argued.

More free tools

See all free tools

Downtime is costing you MILLIONS!

Stop estimating. Start documenting.

Vendor Callout logs each outage from the truck, prices every down-hour and every deferred barrel as it happens, and prints the vendor report that recovers the credit.