Keeping Track: Spreadsheets?
#1
The Drive Side is Within
Thread Starter
Keeping Track: Spreadsheets?
Anyone else keep a spreadsheet of their bikes and components?
So far, I've only got frames and columns for everything from crankset to computer, and am using google docs.
I'm Interested to hear any tricks or essential things I should keep track of outside of components and basic maintenance records. I haven't yet thought about keeping track of costs/investment, but then I don't flip bikes for money-- only sell to make room and (inefficiently) fund more of my hobby.
So far, I've only got frames and columns for everything from crankset to computer, and am using google docs.
I'm Interested to hear any tricks or essential things I should keep track of outside of components and basic maintenance records. I haven't yet thought about keeping track of costs/investment, but then I don't flip bikes for money-- only sell to make room and (inefficiently) fund more of my hobby.
__________________
The bicycle, the bicycle surely, should always be the vehicle of novelists and poets. Christopher Morley
The bicycle, the bicycle surely, should always be the vehicle of novelists and poets. Christopher Morley
#2
Membership Not Required
Join Date: Jan 2005
Location: On the road-USA
Posts: 16,855
Bikes: Giant Excursion, Raleigh Sports, Raleigh R.S.W. Compact, Motobecane? and about 20 more! OMG
Mentioned: 5 Post(s)
Tagged: 0 Thread(s)
Quoted: 70 Post(s)
Likes: 0
Liked 15 Times
in
14 Posts
I use a variety of methods. I do have a spread sheet that I got from someone here in C&V. I also use a word template with pictures. I do track prices on stuff in case something should get stolen I can prove it was worth more than the original purchase price. I also take lots of pictures including the serial numbers and any identifying marks.
Aaron
Aaron
__________________
Webshots is bailing out, if you find any of my posts with corrupt picture files and want to see them corrected please let me know. :(
ISO: A late 1980's Giant Iguana MTB frameset (or complete bike) 23" Red with yellow graphics.
"Cycling should be a way of life, not a hobby.
RIDE, YOU FOOL, RIDE!"_Nicodemus
"Steel: nearly a thousand years of metallurgical development
Aluminum: barely a hundred
Which one would you rather have under your butt at 30mph?"_krazygluon
Webshots is bailing out, if you find any of my posts with corrupt picture files and want to see them corrected please let me know. :(
ISO: A late 1980's Giant Iguana MTB frameset (or complete bike) 23" Red with yellow graphics.
"Cycling should be a way of life, not a hobby.
RIDE, YOU FOOL, RIDE!"_Nicodemus
"Steel: nearly a thousand years of metallurgical development
Aluminum: barely a hundred
Which one would you rather have under your butt at 30mph?"_krazygluon
#3
Senior Member
Join Date: Aug 2003
Location: Tampa, Florida
Posts: 13,954
Mentioned: 40 Post(s)
Tagged: 0 Thread(s)
Quoted: 413 Post(s)
Likes: 0
Liked 109 Times
in
78 Posts
There're a million ways of doing this from a simple notebook to professional software.
I use an Excel spreadsheet to keep track of my by bikes but it mostly from a buy/sell perspective.
There's a column for each bike and then rows for:
Bike name:
Where acquired:
Date Acquired:
Cost of bike:
Gas used:
Misc. expenses: (parts or whatever to get bike fully operationable
Data row
Data row
Data row
Data rows are cells with formulas with the last data row being my +/- minus for the bike.
I use an Excel spreadsheet to keep track of my by bikes but it mostly from a buy/sell perspective.
There's a column for each bike and then rows for:
Bike name:
Where acquired:
Date Acquired:
Cost of bike:
Gas used:
Misc. expenses: (parts or whatever to get bike fully operationable
Data row
Data row
Data row
Data rows are cells with formulas with the last data row being my +/- minus for the bike.
#4
Senior Member
Join Date: Aug 2013
Location: Vermont
Posts: 1,200
Bikes: Pinarello Montello, Merckx MX Leader, Merckx Corsa Extra, Pinarello Prologo, Tredici Magia Nera, Tredici Cross
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)
Quoted: 0 Post(s)
Likes: 0
Liked 4 Times
in
3 Posts
Google Docs is great, for the price! I've used excel a lot, in the past. Docs, very similar. Some of tracking is personal preference. Layout is what works best for you. If things get complicated I like to link all important data to one page. Leave details elsewhere
#5
Senior Member
Join Date: Sep 2005
Location: Hervey Bay, Qld, Australia.
Posts: 2,928
Bikes: Colnago (82, 85, 89, 90, 91, 96, 03), 85 Cinelli, 90 Rossin, 83 Alan, 82 Bianchi, 78 Fountain, 2 x Pinarello, Malvern Star (37), Hillman (70's), 80's Beretto Lo-Pro Track, 80's Kenevans Lo-Pro, Columbus Max (95), DeGrandi (80's) Track.
Mentioned: 12 Post(s)
Tagged: 0 Thread(s)
Quoted: 179 Post(s)
Liked 198 Times
in
124 Posts
I've got mine listed on an Excel spreadsheet - all their vital statistics.
#7
Keener splendor
I use a spreadsheet for my bikes and for my purchases/sales.
It's a work in progress because I only started last month.
It's a work in progress because I only started last month.
#9
Fat Guy on a Little Bike
Join Date: Jun 2008
Location: Philadelphia, PA
Posts: 15,944
Bikes: Two wheeled ones
Mentioned: 42 Post(s)
Tagged: 0 Thread(s)
Quoted: 1254 Post(s)
Liked 345 Times
in
174 Posts
i like having a parts inventory because I found myself buying things I already had and forgot about.
#10
Keener splendor
I've found myself digging around in my boxes, and been like "Wow! I forgot I had this!" So, your second reason is really the operational reason to keep a list.
#11
Senior Member
Join Date: Jan 2012
Location: Forksbent, MN
Posts: 3,190
Bikes: Yes
Mentioned: 29 Post(s)
Tagged: 0 Thread(s)
Quoted: 301 Post(s)
Likes: 0
Liked 15 Times
in
15 Posts
Your system is surely better than mine (if you can call it a system), for long run purposes
I recently made a deal where my bike stuff all goes to my brother who knows a fair bit about values and understands what to sell on CL vs Ebay vs keeper.
The Mrs views whatever parts I have as clutter despite "conversations" where I've randomly pulled parts from bins and looked up on Ebay to show her values... At least we have reached an agreement where there is a "two week" bin in the garage where whatever she places in it is subject to my review and return to the parts bins. It's a halfway decent compromise, since I do have a lot of old reflectors, chains, etc that can go. I'm a bit of a hoarder given my father grew up during the depression.
I'd like to keep a list so I don't "re-buy", as you mentioned. I think the biggest benefit would be to measure stems (etc) just once and have the consolidated record of it without having to find the part itself to see what I marked on it.
I recently made a deal where my bike stuff all goes to my brother who knows a fair bit about values and understands what to sell on CL vs Ebay vs keeper.
The Mrs views whatever parts I have as clutter despite "conversations" where I've randomly pulled parts from bins and looked up on Ebay to show her values... At least we have reached an agreement where there is a "two week" bin in the garage where whatever she places in it is subject to my review and return to the parts bins. It's a halfway decent compromise, since I do have a lot of old reflectors, chains, etc that can go. I'm a bit of a hoarder given my father grew up during the depression.
I'd like to keep a list so I don't "re-buy", as you mentioned. I think the biggest benefit would be to measure stems (etc) just once and have the consolidated record of it without having to find the part itself to see what I marked on it.
#12
Senior Member
Join Date: Jul 2006
Location: STP
Posts: 14,491
Mentioned: 74 Post(s)
Tagged: 0 Thread(s)
Quoted: 821 Post(s)
Liked 255 Times
in
142 Posts
I have Aaron's email and phone number right on the top of the contact list.
Never know when the bus is gonna get you!
#13
Keener splendor
#14
Fat Guy on a Little Bike
Join Date: Jun 2008
Location: Philadelphia, PA
Posts: 15,944
Bikes: Two wheeled ones
Mentioned: 42 Post(s)
Tagged: 0 Thread(s)
Quoted: 1254 Post(s)
Liked 345 Times
in
174 Posts
I don't know what your financial situation is, but presumably the bulk of your finances are in other vehicles (pun intended), with bikes being <10% and hopefully less than 1%. That said, if something happens the difference between some charlatan ripping off your wife for $2k when you have $20k in bikes can make a big difference in terms of making ends meet in the short term.
I've found myself digging around in my boxes, and been like "Wow! I forgot I had this!" So, your second reason is really the operational reason to keep a list.
I've found myself digging around in my boxes, and been like "Wow! I forgot I had this!" So, your second reason is really the operational reason to keep a list.
I dig what you're saying, and your overall point, but 20k is still 20k (using your number and I'd rather not use mine) and your spouse should know about it. If you have a 20k IRA that amounts to 5% of your holdings, you still don't want it to disappear and you want her to know about it, right?
Last edited by KonAaron Snake; 09-15-13 at 07:03 AM.
#17
Senior Member
The artist in me halts any need for speadsheets and documentation of just about everything in the tedium of modern life.
#18
Senior Member
Join Date: Jun 2006
Location: NW Burbs, Chicago
Posts: 12,054
Mentioned: 201 Post(s)
Tagged: 0 Thread(s)
Quoted: 3015 Post(s)
Liked 3,804 Times
in
1,408 Posts
#19
Senior Member
Join Date: Nov 2004
Posts: 23,223
Mentioned: 654 Post(s)
Tagged: 1 Thread(s)
Quoted: 4722 Post(s)
Likes: 0
Liked 3,036 Times
in
1,874 Posts
I have a database for keeping track of all the C&V forum members' bicycles. I track just about every piece of information that I can gleen, provided I can get the serial number. It's proven very valuable in decrypting the serial numbers for numerous brands including, Bianchi, Bridgestone, Centurion, CCM, Fuji, Miyata, Nishiki and Panasonic, to name only a handful.
(18)
(18)
#20
Senior Member
I keep Excel sheets for my builds, not for financial or transaction tracking, but to describe the builds in my personal collection. I like to spiff them up, often color matching them to the bikes' color schemes. Excessive, I know.
Last edited by southpawboston; 09-15-13 at 10:26 AM.
#21
Senior Member
Join Date: May 2013
Location: Pacific Northwest
Posts: 1,990
Bikes: ‘87 Marinoni SLX Sports Tourer, ‘79 Miyata 912 by Gugificazione
Mentioned: 166 Post(s)
Tagged: 0 Thread(s)
Quoted: 502 Post(s)
Liked 466 Times
in
256 Posts
I love my spreadsheets for everything: gas mileage records, comparison shopping, game score keeping, bike gearing and setups. But southpawboston has set a new standard for color coding!
i use Numbers on my iPad, but to get all the cool features to plot data on spreads, I typically make the spreadsheet in Excel on a "real" computer, then import it into Numbers for ready access and new data entries.
i use Numbers on my iPad, but to get all the cool features to plot data on spreads, I typically make the spreadsheet in Excel on a "real" computer, then import it into Numbers for ready access and new data entries.
#23
The Drive Side is Within
Thread Starter
Great ideas. Interesting that value for estate planning purposes came up. I still think I'm 22, and don't consider that stuff.
Southpaw -- those are great. The gearing tables are a fine idea.
Southpaw -- those are great. The gearing tables are a fine idea.
__________________
The bicycle, the bicycle surely, should always be the vehicle of novelists and poets. Christopher Morley
The bicycle, the bicycle surely, should always be the vehicle of novelists and poets. Christopher Morley
#25
Trek 500 Kid
Join Date: Feb 2013
Location: Spokane WA
Posts: 2,562
Bikes: '83 Trek 970 road --- '86 Trek 500 road
Mentioned: 12 Post(s)
Tagged: 0 Thread(s)
Quoted: 2904 Post(s)
Liked 382 Times
in
307 Posts
Oh yeah.
I just made my own Wordpad gearing sheet for about eight different chainring/cluster setups for only two different bikes.....one which I haven't even built yet.
Price sheets ? No way !!! Then I'd have to consider bank overdraft charges for stuff I got a bargain on.
I just made my own Wordpad gearing sheet for about eight different chainring/cluster setups for only two different bikes.....one which I haven't even built yet.
Price sheets ? No way !!! Then I'd have to consider bank overdraft charges for stuff I got a bargain on.