2022 mileage spreadsheet

673 views
Skip to first unread message

Bruce A. Johnson

unread,
Dec 26, 2021, 12:23:55 PM12/26/21
to Potomac Pedalers Discussion List
I'm sorry to say that the recent passing of Mark Pankin was my
inspiration to update the Google Docs spreadsheet that I'll be offering
to the club shortly. I'll appreciate feedback from any of you who are
willing to make a copy and kick it around a little.

https://docs.google.com/spreadsheets/d/13PkiSVT2pjLsk9cmcOzalBniwOSaIBJ0kGKPcX63P28/edit?usp=sharing
<https://docs.google.com/spreadsheets/d/13PkiSVT2pjLsk9cmcOzalBniwOSaIBJ0kGKPcX63P28/edit?usp=sharing>

Thanks!

--
Bruce A. Johnson
Herndon, Virginia

Warren Farb

unread,
Dec 26, 2021, 4:00:53 PM12/26/21
to Bruce A. Johnson, Potomac Pedalers Discussion List
I don’t think there will be a lot of interest in keeping track of millage in a separate spreadsheet, when there are so many automatic alternatives available, eg. STRAVA, Garmin, RidewithGPS. 

Warren



--
--
You received this message because you are subscribed to "Pedalers".
To post a message, send email to: peda...@googlegroups.com
To unsubscribe, send email to: pedalers-u...@googlegroups.com
To post a message to the group owner, see: http://groups.google.com/group/pedalers/post?sendowner=1&hl=en
For more options, see:
http://groups.google.com/group/pedalers?hl=en
--- You received this message because you are subscribed to the Google Groups "Pedalers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pedalers+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pedalers/452c56b5-3bf3-ec81-8c62-0c6c73fff63e%40gmail.com.

Eli Allen

unread,
Dec 26, 2021, 4:59:59 PM12/26/21
to Bruce A. Johnson, Potomac Pedalers Discussion List
Thought I'd add:

Though not sure why you'd want to do that...

Bruce Johnson

unread,
Dec 26, 2021, 5:08:54 PM12/26/21
to Warren Farb, Potomac Pedalers Discussion List
Some people complained when the Pedalers didn't provide a mileage log a couple of years ago. There are still people who don't use Strava or RideWithGPS. Being someone who eschews carbon fiber and brifters, I am sympathetic.


Bruce A. Johnson
Herndon, Virginia

Steve Palincsar

unread,
Dec 26, 2021, 6:00:09 PM12/26/21
to peda...@googlegroups.com

There are still riders who do not use GPS devices and so on.  Some of those riders also like to keep track of mileage.  Those who don't want the spreadsheet don't have to use it.

On 12/26/21 4:00 PM, Warren Farb wrote:
I don’t think there will be a lot of interest in keeping track of millage in a separate spreadsheet, when there are so many automatic alternatives available, eg. STRAVA, Garmin, RidewithGPS. 

Warren


On Dec 26, 2021, at 12:23 PM, Bruce A. Johnson <waterfo...@gmail.com> wrote:

I'm sorry to say that the recent passing of Mark Pankin was my inspiration to update the Google Docs spreadsheet that I'll be offering to the club shortly. I'll appreciate feedback from any of you who are willing to make a copy and kick it around a little.

Al Robertson

unread,
Dec 26, 2021, 6:16:03 PM12/26/21
to Steve Palincsar, peda...@googlegroups.com
I still use that spreadsheet.  I think he had already done the 2022 one before he died, because it was on his web site.

--
--
You received this message because you are subscribed to "Pedalers".
To post a message, send email to: peda...@googlegroups.com
To unsubscribe, send email to: pedalers-u...@googlegroups.com
To post a message to the group owner, see:
http://groups.google.com/group/pedalers/post?sendowner=1&hl=en
For more options, see:
http://groups.google.com/group/pedalers?hl=en
---
You received this message because you are subscribed to the Google Groups "Pedalers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pedalers+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pedalers/72354c91-8e9d-1741-24a1-f969f9e69d56%40his.com.

pptc....@gmail.com

unread,
Dec 26, 2021, 7:02:29 PM12/26/21
to Al Robertson, Steve Palincsar, peda...@googlegroups.com
I appreciate the spreadsheet and will use it. I also use ride with ride with GPS 

Tom

Sent from my iPhone

On Dec 26, 2021, at 6:16 PM, 'Al Robertson' via Pedalers <peda...@googlegroups.com> wrote:



Leslie Tierstein

unread,
Dec 27, 2021, 7:54:14 AM12/27/21
to pptc....@gmail.com, Al Robertson, Steve Palincsar, peda...@googlegroups.com

I track my mileage with a Wahoo. The rides automatically get logged (assuming I remember to charge the Wahoo). Wahoo would also automatically upload the rides to Strava and/or RwGPS if I set up the connections. However, I would still have to edit the ride post hoc to note which bicycle I was riding.  (Sorry; might not be a problem for some people.) I would also have to edit to include any notes. And so far I haven't discovered a good way to get an overview of multiple rides, over varied time spans, in any of those tools (short of using one of the APIs available which are very powerful but not usable without a lot of work.)

Therefore, I've been using a revised version of Mark Pankin's spreadsheet.  I have attached my revision for 2022. (Haven't filled in the past totals yet; and feel free to change the color coding for bicycles; and it's upgraded to the current version of Excel.) A while back, Mark even gave me some Excel advice on how I might summarize the rides by bike; still working on that, however. The Excel formulas in this sheet are a wonder to behold - I would thank Mark every year for his work.  I may add one more sheet to track maintenance and repair; however, that would have to span multiple years to be truly meaningful.  And a New Year's resolution is to improve my Excel enough so that I can produce a 2023 version.

mileage2022.xlsx

Eli Allen

unread,
Dec 27, 2021, 11:27:18 AM12/27/21
to Leslie Tierstein, Tom Moore, Al Robertson, Steve Palincsar, Potomac Pedalers Discussion List
For viewing ride data over time, something like this?
--
--
You received this message because you are subscribed to "Pedalers".
To post a message, send email to: peda...@googlegroups.com
To unsubscribe, send email to: pedalers-u...@googlegroups.com
To post a message to the group owner, see:
http://groups.google.com/group/pedalers/post?sendowner=1&hl=en
For more options, see:
http://groups.google.com/group/pedalers?hl=en
---
You received this message because you are subscribed to the Google Groups "Pedalers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pedalers+u...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages