Uber Drivers Forum banner

1 - 5 of 5 Posts

·
Registered
Joined
·
47 Posts
Discussion Starter · #1 ·
I've been working on a spreadsheet for keeping track of trips fares and pay. It has four individual worksheets. The datasheet itself that includes the fare, SRF, Ubers fee and your cut. A pivot table to read and filter the data and two different charts.

If you find it's helpful or have any suggestions let me know. I'm also expanding on the sheet to add non-pax and pax mileage as well and adding a Google web form to enter the data online.

Uber Final:
https://docs.google.com/spreadsheets/d/1YMIeXUbBfWtXVAEKY2EphV9lQFXs8m7ZwWtuIxSMSbE/edit?usp=sharing
 

·
Registered
Joined
·
579 Posts
I've been working on a spreadsheet for keeping track of trips fares and pay. It has four individual worksheets. The datasheet itself that includes the fare, SRF, Ubers fee and your cut. A pivot table to read and filter the data and two different charts.

If you find it's helpful or have any suggestions let me know. I'm also expanding on the sheet to add non-pax and pax mileage as well and adding a Google web form to enter the data online.

Uber Final:
https://docs.google.com/spreadsheets/d/1YMIeXUbBfWtXVAEKY2EphV9lQFXs8m7ZwWtuIxSMSbE/edit?usp=sharing
This is excellent, can you tell me how I can save this in Excel format.. great job.. :)
 

·
Registered
Joined
·
47 Posts
Discussion Starter · #3 ·
Thanks Nagodesi....As a guest you can download the sheet as an excel format. Just click File...Download As...Excel
 

·
Registered
Joined
·
606 Posts
Other drivers that see my spreadsheet and my notes about pickup times, mileage and fares etc always go, "why do you do that?". I'm always like "seriously?!?"
 

·
Registered
Joined
·
47 Posts
Discussion Starter · #5 ·
Jam, :)... I feel for ya.
I try to keep it simple as possible but have as much data displayed by charts. I didn't bother with calculations of mileage, pickup times,
or minutes of the trips themselves as Uber already does that. For me what was important was the difference of cost between non rider mileage/gas and rider miles/gas.
 
1 - 5 of 5 Posts
Top