Num Sum
Log In
|
Create a FREE Account
|
Everyone's Spreadsheets
|
Tags
The comma separated values (CSV) data for spreadsheet:
CABGas Mileage Spreadsheet
Just copy and paste it to where-ever you need it...
Notes,Date,Odometer,Gallons,Paid,Miles\, This Fill,Miles/Gal\, This Fill,$/Gal\, This Fill,$/Mile\, This Fill,Miles\, Total,Gallons\, Total,Miles/gal\, Total,$ Total,,,,, Holiday 332,12/10/06,224196,10.023,21.74,,,=E2/D2,,,,,=SUM(E2..E11),,,,, Holiday 0139,12/15/06,224448,9.276,20.21,=C3-C2,=FIXED(F3/D3,2),=E3/D3,=E3/F3,,,,=SUM(M2:M2),,,,, Holiday 0139,12/19/06,224690,9.031,20.76,=C4-C3,=FIXED(F4/D4,2),=E4/D4,=E4/F4,=SUM(F3:F4),=SUM(D3:D4),=FIXED(J4/K4,2),,,,,, Holiday 0139,12/24/06,224905,7.943,17.63,=C5-C4,=FIXED(F5/D5,2),=E5/D5,=E5/F5,=SUM(F3:F5),=SUM(D3:D5),=FIXED(J5/K5,2),,,,,, ,,,,,=C6-C5,=FIXED(F6/D6,2),=E6/D6,=E6/F6,=SUM(F3:F6),=SUM(D3:D6),=FIXED(J6/K6,2),,,,,, ,,,,,,=FIXED(F7/D7,2),=E7/D7,=E7/F7,=SUM(F3:F7),=SUM(D3:D7),=FIXED(J7/K7,2),,,,,, ,,,,,,=FIXED(F8/D8,2),=E8/D8,=E8/F8,=SUM(F3:F8),=SUM(D3:D8),=FIXED(J8/K8,2),,,,,, ,,,,,=C9-C8,=FIXED(F9/D9,2),=E9/D9,=E9/F9,=SUM(F3:F9),=SUM(D3:D9),=FIXED(J9/K9,2),,,,,, ,,,,,=C10-C9,=FIXED(F10/D10,2),=E10/D10,=E10/F10,=SUM(F3:F10),=SUM(D3:D10),=FIXED(J10/K10,2),,,,,, ,,,,,=C11-C10,=FIXED(F11/D11,2),=E11/D11,=E11/F11,=SUM(F3:F11),=SUM(D3:D11),=FIXED(J11/K11,2),,,,,, ,,,,,=C12-C11,=FIXED(F12/D12,2),=E12/D12,=E12/F12,=SUM(F3:F12),=SUM(D3:D12),=FIXED(J12/K12,2),,,,,,
You can also
export the spreadsheet's formulas
instead of its calculated data.
Go back to spreadsheet:
CABGas Mileage Spreadsheet
.
[ default color ]
recent: