How to manage a racket collection

Discussion in 'Classic Racquet Talk' started by frinton, Aug 15, 2013.

  1. frinton

    frinton Semi-Pro

    Joined:
    Dec 12, 2011
    Messages:
    579
    Location:
    Switzerland, Z├╝rich Area
    Hi guys,
    as my collection is growing, I was wondering if anybody knew of a good too/sw that allows managing a racket collection.
    I would like to be able to define my own information fields and store pics as well. My preference would be an online tool, that allows sharing as well. Freeware would be preferred, but I am happy to pay a reasonable fee for something that works well.

    Any input will be more than welcome. Thanks.
     
    #1
  2. bert96

    bert96 Rookie

    Joined:
    Jun 27, 2011
    Messages:
    206
    Location:
    On the clay courts of Austria
    what about a webpage, where you can upload your pics? :)
     
    #2
  3. Tamiya

    Tamiya Semi-Pro

    Joined:
    Jan 27, 2013
    Messages:
    798
    Location:
    AU, SG, MY
    I just chucked it all onto an excel spreadsheet

    Yeah would be sweet to have some kind of database,
    maybe even something on a smartphone would be better.
     
    #3
  4. ctromano

    ctromano Rookie

    Joined:
    Mar 28, 2006
    Messages:
    191
    easy

    i would use facebook:)
     
    #4
  5. retrowagen

    retrowagen Hall of Fame

    Joined:
    Dec 4, 2006
    Messages:
    1,909
    I have a (well, rather long) Excel spreadsheet that has fields for the details I care about, covering every racquet I've owned since my first in 1982. 307 racquets, as of today. Eeek.
     
    Last edited: Aug 15, 2013
    #5
  6. Tennis Man

    Tennis Man Hall of Fame

    Joined:
    Aug 30, 2006
    Messages:
    2,635
    Location:
    Sunshine State
    1. excel
    2. word
    2. google docs
     
    #6
  7. Chotobaka

    Chotobaka Hall of Fame

    Joined:
    May 19, 2012
    Messages:
    2,494
    In my experience, hiding the true number of racquets from my wife is the real key to effective racquet management.
     
    #7
  8. BorgCash

    BorgCash New User

    Joined:
    Jan 9, 2013
    Messages:
    99
    It's the most important thing!
     
    #8
  9. NickJ

    NickJ Rookie

    Joined:
    Feb 2, 2007
    Messages:
    316
    Location:
    UK
    This.

    Her - "Is that a new racquet?"
    Me - "No dear, Dave borrowed it/it was being restrung/I found it in an old bag/it's a demo
     
    #9
  10. Sanglier

    Sanglier Rookie

    Joined:
    Nov 28, 2011
    Messages:
    209
    Most men give female names to their toys, be they cars, boats, guns, or sports equipment. The adjectives they use to describe their favorite inanimate objects are exactly the same as the ones they lavish on their human love interest. In extreme cases, they have been known to literally sleep with (or in) these things.

    It is quite obvious that collecting 'useless junk' pacifies the male brain; which reduces the natural male urge to do certain things that invariably get them into trouble (e.g., Weiner & Spitzer).

    Smart spouses recognize the above. They not only ENCOURAGE their husbands to indulge in these relatively harmless activities (to a degree), but may actively take part in them a well. After all, couples who play together stay together.

    Mine has no time or interest to be a 'hoarder' herself, but as long as I don't allow my toys to invade unspoiled parts of the house, I don't need to sneak anything by her. She even pretends to be interested when I tell her the fascinating stories behind every new 'find'. :)

    Regarding OP's question, I also use Excel. On one worksheet, I keep records on brand, model, grip size, serial number, cover, vintage, condition, value (based on the average realized price on the auction site), photo reference, online reference (e.g., links to threads on this forum), date acquired, price paid, seller, date sold, sale price, sold to, and misc notes (such as playability impression, anecdotal stories, etc.). On a separate worksheet, I record the measured specs for all the frames as they come to me. For swing weight, I used to rely on the online calculator from 'TW University', but after finding the formula in "The Physics and Technology of Tennis", I just plugged the formula into the spreadsheet and used the 'fill down' function to complete the column (the book formula uses 10.16 cm [i.e., 4"] from the bottom of the grip as the measurement point for SW. After comparing the results, I came to the conclusion that TW University rounded that off to a simple '10' for their online calculator; which is quite sensible).

    A spreadsheet is not as neat and handy for analysis as a proper database, but I can get all the information I need from it with some manual work. For instance, I was able to look at my overall "thrifting" success over the past (almost) two years by sorting my acquisitions based on sellers and dates:

    [​IMG]

    The results are not all that surprising. People tend to drop off their junk on weekends, so early in the week is the best time to fish for these things. There are also surges in donations right after the New Year and in early Fall, when people try to make room in their closet for new stuff. I myself have now run out of room in my spousal-designated hoarding zone, so this thriftological research is likely coming to an end in the very near future. :?

    ---
     
    #10
  11. Tamiya

    Tamiya Semi-Pro

    Joined:
    Jan 27, 2013
    Messages:
    798
    Location:
    AU, SG, MY
    ^^^ you sir are my hero...! :)
     
    #11
  12. pshulam

    pshulam Hall of Fame

    Joined:
    Jan 21, 2009
    Messages:
    2,398
    Location:
    Minneapolis
    Excel - easy to use
    Access
     
    #12
  13. Steve_j_theo

    Steve_j_theo Rookie

    Joined:
    Sep 16, 2011
    Messages:
    108
    I have my collection in albums on my facebook page, with the specs too :)
     
    #13
  14. NickJ

    NickJ Rookie

    Joined:
    Feb 2, 2007
    Messages:
    316
    Location:
    UK
    He does, I've seen it. It's awesome!
     
    #14
  15. Stein

    Stein New User

    Joined:
    Apr 17, 2012
    Messages:
    61
    Location:
    Bergeijk, Netherlands
    How i manage my collection?
    Just keep on buying and don't tell your wife what you bought only what you've sold on occasion :)

    I'm over 300 frames now and just bought 6 more today...
     
    #15
  16. NickJ

    NickJ Rookie

    Joined:
    Feb 2, 2007
    Messages:
    316
    Location:
    UK
    Just tell her you sold 10 - 15 to pay for the 6 new ones. As long as you can justify and account for the spend she'll be none the wiser! Does she know each & every one of the 300 frames? No. Buy her some flowers, tell her she's pretty and enjoy the new sticks!
     
    #16
  17. Stein

    Stein New User

    Joined:
    Apr 17, 2012
    Messages:
    61
    Location:
    Bergeijk, Netherlands
    Best advice ever. Thanks mate :) only the flowers will make her suspicious :? so i will leave that part out.
     
    #17
  18. luishcorreia

    luishcorreia Professional

    Joined:
    Jun 9, 2006
    Messages:
    1,381
    Location:
    Lisbon - Portugal
    Wise words :)
     
    #18
  19. andreh

    andreh Professional

    Joined:
    Feb 19, 2004
    Messages:
    1,089
    The key to convincing lying lies in the details. (Also, made pun)
     
    #19

Share This Page