Cellwise Start free

Excel for your field

Excel for trucking owner-operators and small fleets

For owner-operators, small fleet owners and dispatchers who want to know whether a load is worth taking before they say yes. Excel works out your real cost per mile from fixed and running costs, shows what a load pays per mile once the deadhead is counted, puts a profit on every load, and gives you the minimum rate to quote. Every formula below runs on a month of loads for a one-truck operation you can edit.

General spreadsheet help, not tax, legal or compliance advice. Your costs, fuel prices and rates go in the input cells; check rules for your operation with a professional.

Sample data

Every result on this page comes from this sheet, calculated by the same engine the Cellwise app uses. Change a number and watch the formulas react.

RowABCDEFGH
1DateBrokerLoaded miDeadhead miPayTollsSettings
2Nov 2, 2026Ridgeway6124816500Diesel price per gallon3.85
3Nov 3, 2026Blue Lake43895112022Truck MPG6.5
4Nov 5, 2026Harbor8053022100Fixed costs per month6200
5Nov 6, 2026Ridgeway29014078014Maintenance and tires per mile0.21
6Nov 9, 2026Blue Lake104060265038Planned miles per month10000
7Nov 11, 2026Harbor5202514800Target profit per mile0.4
8Nov 12, 2026Ridgeway3751109000
9Nov 16, 2026Blue Lake69040189026
10Nov 18, 2026Harbor45518010500
11Nov 20, 2026Ridgeway93055242031

What Excel does for trucking

Know your cost per mile

Every rate decision starts here. Your cost per mile has three parts: fixed costs (truck payment, insurance, permits, software) spread over the miles you run in a month, fuel (price per gallon divided by MPG), and the per-mile running costs like maintenance and tires.

Keep each input in its own cell. When diesel moves or your insurance renews, you change one number and every quote on the sheet updates.

=H4/H6+H5+H2/H3

Result: 1.4223076923 shows as $1.42 with Currency format

$1.42 a mile: $0.62 of fixed cost ($6,200 over 10,000 miles), $0.21 for maintenance and tires, and $0.59 of fuel ($3.85 a gallon at 6.5 MPG).

Compare rate per loaded mile with rate per total mile

Brokers and load boards quote per loaded mile, but you also drive the deadhead to pick up, and those miles burn the same fuel. Divide the pay by loaded plus deadhead miles to see what the load really pays for every mile the truck moves.

The gap matters most on short loads with a long drive to the shipper. A load that looks like the best rate on the board can be one of the worst once the empty miles are in.

=E5/(C5+D5)

Result: 1.8139534884 shows as $1.81 with Currency format

$1.81 per total mile for the Nov 6 load. At $2.69 per loaded mile it looks as good as the Nov 2 load ($2.70), but its 140 deadhead miles drop it to $1.81 per total mile, against $2.50 for the Nov 2 load.

Put a profit on every load

Profit per load is the pay, minus tolls, minus every mile (loaded and empty) times your cost per mile. Using the full cost per mile, fixed costs included, tells you whether the load pays its share of the truck, not just its fuel.

Write it once and fill it down a load log, and sorting by profit shows which lanes and brokers are carrying the month.

=E2-F2-(C2+D2)*(H4/H6+H5+H2/H3)

Result: 711.27692308 shows as $711.28 with Currency format

$711.28 profit on the Nov 2 Ridgeway load: $1,650 of pay, no tolls, less 660 miles at $1.42.

Track your deadhead share

Empty miles are the quiet cost in trucking. Total deadhead divided by all miles (loaded plus deadhead) is the share of the truck's miles nobody paid for directly.

Watch it by month and by broker. A rising share usually means you are taking loads that end far from the next freight, which is a reason to plan the reload before you book.

=SUM(D2:D11)/SUM(C2:D11)

Result: 0.11285673105 shows as 11.3% with Percent format

11.3% of the month's 6,938 miles were deadhead: 783 empty miles.

Work out the pay you need before you accept a load

Before you counter a broker, work out what the load must pay to hit your target: all its miles (loaded plus deadhead) times your cost per mile plus your target profit per mile, plus tolls. ROUNDUP to the next whole dollar gives a number you can say on the phone.

If the offer is under it, you know exactly how far to push, or that the load is one to pass on.

=ROUNDUP((C5+D5)*(H4/H6+H5+H2/H3+H7)+F5,0)

Result: 798 shows as $798 with Currency format

$798 for the Nov 6 load: 430 miles at $1.42 cost plus $0.40 profit, plus $14 of tolls. It paid $780, so it missed the target by $18 even though $2.69 a loaded mile sounded good.

Find the load that paid least per mile

MIN on pay divided by total miles finds the lowest rate in the month; MATCH finds its row and INDEX returns the broker. The division runs for every load at once inside the formula, so you need no helper column.

Change INDEX(B2:B11 to INDEX(A2:A11 to get the date instead.

=INDEX(B2:B11,MATCH(MIN(E2:E11/(C2:C11+D2:D11)),E2:E11/(C2:C11+D2:D11),0))

Result: Harbor

Harbor: the Nov 18 load paid $1,050 for 635 miles (455 loaded, 180 deadhead), $1.65 per total mile, the lowest of the month, even though Harbor's other loads paid well.

See which broker pays best per mile

Average the rate per mile by broker the right way: total pay divided by total miles for that broker, using SUMIF on each column. Averaging the per-load rates instead lets one short load count as much as a 1,000-mile run.

Do the same for each broker in a small table to compare them side by side.

=SUMIF(B2:B11,"Blue Lake",E2:E11)/(SUMIF(B2:B11,"Blue Lake",C2:C11)+SUMIF(B2:B11,"Blue Lake",D2:D11))

Result: 2.3952602624 shows as $2.40 with Currency format

$2.40 per total mile from Blue Lake ($5,660 over 2,363 miles), ahead of Harbor at $2.35 and Ridgeway at $2.25.

Practice: 8 exercises

Use the sample data above. Type a formula and press Check: it is graded by a real spreadsheet engine, the way Cellwise grades lessons.

  1. 1How many loaded miles did the truck run this month?

    Show answer

    =SUM(C2:C11) = 6155. 6,155 loaded miles across the ten loads.

  2. 2How much did Ridgeway loads pay in total?

    Show answer

    =SUMIF(B2:B11,"Ridgeway",E2:E11) = 5750. Four Ridgeway loads paid $5,750.

  3. 3How many loads had more than 100 deadhead miles?

    Show answer

    =COUNTIF(D2:D11,">100") = 3. Three loads: Nov 6, Nov 12 and Nov 18.

  4. 4What did the Nov 5 Harbor load (row 4) pay per loaded mile?

    Show answer

    =E4/C4 = 2.7453416149. $2,210 over 805 miles is about $2.75 a loaded mile.

  5. 5How many gallons of diesel did the Nov 9 load (row 6) burn, counting deadhead? Use the MPG in H3.

    Show answer

    =(C6+D6)/H3 = 169.23076923. 1,100 miles at 6.5 MPG is about 169 gallons.

  6. 6What did the whole month pay per total mile?

    Show answer

    =SUM(E2:E11)/SUM(C2:D11) = 2.3277601614. $16,150 over 6,938 miles is about $2.33 a mile.

  7. 7How much did loads delivered before Nov 16 pay?

    Show answer

    =SUMIFS(E2:E11,A2:A11,"<"&DATE(2026,11,16)) = 10790. The first seven loads paid $10,790.

  8. 8What was the profit on the Nov 18 load (row 10) after tolls and all miles at the full cost per mile (H4/H6+H5+H2/H3)?

    Show answer

    =E10-F10-(C10+D10)*(H4/H6+H5+H2/H3) = 146.83461538. $1,050 minus 635 miles at $1.42 is about $146.83: it covers its costs, but at $0.23 a mile it is well under the $0.40 target.

Free templates for trucking

Guided project: Owner-operator cost per mile

Turn a truck's monthly bills, fuel and miles into a cost per mile and the minimum rate per loaded mile worth taking.

5 steps in the Cellwise app. Each step checks your formula in a real grid, with hints when you get stuck. Part of Cellwise Plus.

Open Projects

Guides for these formulas

FAQ

How do I calculate my trucking cost per mile in Excel?

Put your monthly fixed costs, miles per month, diesel price, MPG and per-mile running costs in cells. Then =fixed/miles + price/MPG + running_costs gives the cost of every mile the truck moves. The free trucking cost per mile calculator does this and checks any load offer against it.

Should I include deadhead miles when I work out rate per mile?

Yes, when you compare a load with your costs. The truck burns fuel and wears tires on empty miles too. Divide the pay by loaded plus deadhead miles, and compare that with your cost per mile.

What is a good rate per mile for an owner-operator?

It depends on your own costs, lanes and equipment, so start from your numbers rather than someone else's: your cost per mile plus the profit you want, divided by your loaded share of miles, is your minimum rate per loaded mile.

How do I track truck maintenance in Excel?

List each service with its interval in miles and the odometer when it was last done, look up each truck's current odometer, and subtract to get miles until due. The free fleet maintenance tracker flags what is overdue or due soon by miles and by date.

Excel for other fields

Updated