ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Long-distance Carpooling Cost-Split Calculator for Drivers and Passengers.
Updated for NPYM Annual Session 2025 in Missoula Mt.
3
This calculator may help your long-distance carpool group decide how to split costs fairly while compensating the vehicle's owner plus helping to fairly compensate alternate drivers for their service.
Test it and experiment with hypothetical inputs to determine if it meets your needs and your group's sense of fairness.
Contact Lew Scholl at Lewscholl@gmail.com with any questions.
4
Please download this and use it as you wish. Note that you will only be able to change the pink INPUT cells and the notes box blow.
5
Enter your notes here ===>
6
Assumption: Vehicle owner initially pays for all gas and vehicle expenses. They are then compensated fairly per the calculator output
7
Enter Data Below for vehicle & driver compensationEnter all Names and Estimated Driving Hours BelowOUTPUT
8
Hint :
Hover over boxes in the Units column for parameter suggestions
Main
INPUT		UnitsINPUT
Driver Name:		INPUT
Hours Driven		Pay (+) or Payment (-) owed for Drive TimeVehicle Owner ReceivesAmount passengers pay after including Driving Comp
9
EstimatedFuel Economy =28MPG
Vehicle Owner
Joe9.50$95$230.18Note that adding passenger driving time appears to pay more than the per hour rate chosen.
This is because the time a person spends driving is taken away from the time they need to compensate someone else for driving
10
Fuel Price =$4.50$/gallon
passenger
Harry-$32$76.73
11
Additional Vehicle Compensation (Insurance, maintenance ...) =
$0.17$/mi
passenger
Matilda-$32$76.73
12
Desired Driving Compensation Rate $/hour =
$10$/hr
passenger
Ralph-$32$76.73
13
Expected Miles to be Driven =
545miles
14
Estimated Driving Time - excluding break time =
9.50hours
15
16
Intermediate Output
17
Calculated
Mileage Rate including fuel		Total Cost for Vehicle + Gas4-way split of all vehicle costs# of Travelers including owner
18
$0.33$180.24$45.064
Driver time total =
9.50$230.18
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101