Inventory log or spreadsheet
03-17-12, 07:34 AM
#1
Senior Member
Thread Starter
Inventory log or spreadsheet
Does anyone know of an available spreadsheet or log for keeping track of acquired bicycles? I have searched BF and google but haven't been able to find anything. I am getting to the point where I don't remember what bicycles I have.I guess I could just keep track in a notebook but a computerized spreadsheet with information and possible pictures would be much easier.
Thanks
James
Thanks
James
03-17-12, 07:54 AM
#3
Hopelessly addicted...
Join Date: Aug 2009
Location: Central Maryland
Posts: 4,955
Bikes: 1949 Hercules Kestrel, 1950 Norman Rapide, 1970 Schwinn Collegiate, 1972 Peugeot UE-8, 1976 Raleigh Sports, 1977 Raleigh Sports, 1977 Jack Taylor Tandem, 1984 Davidson Tandem, 2010 Bilenky "BQ" 650B Constructeur Tandem, 2011 Linus Mixte
Mentioned: 13 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 10 Times
in
9 Posts
One of the members here on the forums, Ciufalon, passed me a couple spreadsheets a while back. One is an invewntory sheet and another is a build sheet. They are pretty comprehensive and in spite of my best intentions I have yet to use them. If you PM me your email address I'll share them with you.
03-17-12, 08:55 AM
#4
Spin Forest! Spin!
Join Date: Sep 2007
Location: Arrid Zone-a
Posts: 5,956
Bikes: I used to have many. And I Will again.
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 7 Post(s)
Likes: 0
Liked 11 Times
in
10 Posts
I use an Excel spreadsheet. Easy enough to set up yourself, lot's of options, link to photos in a folder or online.
You can also try Google Apps, and keep a spreadsheet online for anywhere, anytime access.
You can also try Google Apps, and keep a spreadsheet online for anywhere, anytime access.
03-17-12, 10:50 AM
#5
Senior Member
Thread Starter
Photogravity, thanks for the offer, but I can't pm you (not enough posts)
James
James
03-17-12, 10:59 AM
#6
Hopelessly addicted...
Join Date: Aug 2009
Location: Central Maryland
Posts: 4,955
Bikes: 1949 Hercules Kestrel, 1950 Norman Rapide, 1970 Schwinn Collegiate, 1972 Peugeot UE-8, 1976 Raleigh Sports, 1977 Raleigh Sports, 1977 Jack Taylor Tandem, 1984 Davidson Tandem, 2010 Bilenky "BQ" 650B Constructeur Tandem, 2011 Linus Mixte
Mentioned: 13 Post(s)
Tagged: 0 Thread(s)
Quoted: 3 Post(s)
Likes: 0
Liked 10 Times
in
9 Posts
03-17-12, 03:21 PM
#7
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 couple of different methods; I have a spread sheet from someone here on BF, don't recall who. I also use a word doc that I print and keep in a book in the shop. I use that one to jot notes on and when I think about it I update the electronic version. I also keep pictures of the bikes, equipment and serial numbers on a couple of flash drives. One stays in the my safety deposit box, the other is in a friend's possession halfway across the country. I periodically send them an updated one. I also have pictures on a couple of cloud locations. None of the methods are fool proof or even complete but between them I have a pretty good record of what I have.
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
03-17-12, 03:39 PM
#8
Thrifty Bill
Join Date: Jan 2008
Location: Mountains of Western NC
Posts: 23,525
Bikes: 86 Katakura Silk, 87 Prologue X2, 88 Cimarron LE, 1975 Sekai 4000 Professional, 73 Paramount, plus more
Mentioned: 96 Post(s)
Tagged: 0 Thread(s)
Quoted: 1236 Post(s)
Liked 964 Times
in
628 Posts
I use two flickr accounts for bikes. One has completed bikes, one has as found or projects. Two reasons I do this. First, to keep flickr "free", you are limited to 200 viewable pictures. Secondly, I was having some issues around buyers looking at the before pics and it hurt sales. As a minimum, the before pics confused newbs.
+1 on the spreadsheet. I also now put a tag on completed bikes with basic, but pertinent, information, such as new parts, size, etc. Picked up a pile of nice plastic tag sleeves at Salvation Army. Should be enough to last me years.
+1 on the spreadsheet. I also now put a tag on completed bikes with basic, but pertinent, information, such as new parts, size, etc. Picked up a pile of nice plastic tag sleeves at Salvation Army. Should be enough to last me years.
03-17-12, 03:54 PM
#9
Senior Member
Join Date: Aug 2010
Location: Liberty, Missouri
Posts: 3,120
Bikes: 1966 Paramount | 1971 Raleigh International | ca. 1970 Bernard Carre | 1989 Waterford Paramount | 2012 Boulder Brevet | 2019 Specialized Diverge
Mentioned: 23 Post(s)
Tagged: 0 Thread(s)
Quoted: 129 Post(s)
Liked 77 Times
in
40 Posts
OK, so it only works periodically, but the Bicycle ap on Facebook is a pretty decent online inventory tool.
https://apps.facebook.com/mycycle/?r...s&fb_bmpos=3_0
https://apps.facebook.com/mycycle/?r...s&fb_bmpos=3_0
03-17-12, 06:47 PM
#10
Senior Member
Join Date: Dec 2005
Location: Ashland, VA
Posts: 4,420
Bikes: The keepers: 1958 Raleigh Lenton Grand Prix, 1968 Ranger, 1969 Magneet Sprint, 1971 Gitane Tour de France, 1973 Raleigh Tourist, 3 - 1986 Rossins, and a '77 PX-10 frame in process.
Mentioned: 8 Post(s)
Tagged: 0 Thread(s)
Quoted: 221 Post(s)
Liked 237 Times
in
129 Posts
Quick Books 2007. I run the entire mess as a business, and actually can figure out whether or not I'm losing money on what I ride at the end of the year. I figure if I have enough walk-in clients showing up on top of my Craigslist sales, someday the county is going to notice me, so I might as well have my books in order.
__________________
Syke
“No one in this world, so far as I know — and I have searched the records for years, and employed agents to help me — has ever lost money by underestimating the intelligence of the great masses of the plain people. Nor has anyone ever lost public office thereby.”
H.L. Mencken, (1926)
Syke
“No one in this world, so far as I know — and I have searched the records for years, and employed agents to help me — has ever lost money by underestimating the intelligence of the great masses of the plain people. Nor has anyone ever lost public office thereby.”
H.L. Mencken, (1926)
03-17-12, 07:08 PM
#11
Senior Member
Join Date: Apr 2009
Location: Detroit
Posts: 10,303
Mentioned: 6 Post(s)
Tagged: 0 Thread(s)
Quoted: 17 Post(s)
Likes: 0
Liked 42 Times
in
33 Posts
I use Excel, but I have used some Open Office .org applications too and they're pretty decent. They have a full suite of applications (for free).
https://www.openoffice.org/why/why_great.html
You can even build yourself a relational database for all your bikes and components.
https://www.openoffice.org/why/why_great.html
You can even build yourself a relational database for all your bikes and components.
__________________
- Auchen
- Auchen
Thread
Thread Starter
Forum
Replies
Last Post
Regulatori
Singlespeed & Fixed Gear
4
10-13-15 12:00 PM
KS_rider
Classic & Vintage
8
03-12-13 11:36 AM
X-LinkedRider
General Cycling Discussion
11
11-17-10 05:45 PM
