Model Railroad Data Base

Scott Crowell Jun 26, 2024

  1. Scott Crowell

    Scott Crowell New Member

    8
    26
    1
    I am brand new to model railroading (N Gauge) and as I start buying rolling stock and locomotives, I know I am going to need to keep track of it as well, especially wish lists and values for insurance. As I live in a tiny apartment, I will only be running on my train club's layout as I don't have space for one.
    I did find find this one The Software for Model Railroaders: Stecotec Model Railroad Collector Pro (modelrailroad-software.com) but I am very leary about buying software through Ebay Marketplace, even if it say new.
    Any suggestions on data bases you use?
     
    Hardcoaler and BNSF FAN like this.
  2. Ike the BN Freak

    Ike the BN Freak TrainBoard Member

    1,371
    135
    30
    I use google sheets, I can update it via the desktop or the mobile app. You can set up as many sheets as you want for different things, and set up the columns as you see fit. And best of all, its free
     
    BNSF FAN likes this.
  3. Scott Crowell

    Scott Crowell New Member

    8
    26
    1
    I am not that tech savvy to use Excel like that or google sheets.
     
    BNSF FAN likes this.
  4. Hardcoaler

    Hardcoaler TrainBoard Member

    10,909
    47,164
    142
    Trovestar [ https://www.trovestar.com/generic/group.php?Collection=4 ] has a database function, though I've not used it. It's a great site to bookmark, as it contains what is likely the largest listing of N Scale items on the planet.
     
    BNSF FAN likes this.
  5. BNSF FAN

    BNSF FAN TrainBoard Supporter

    10,220
    31,999
    153
    Trovestar also offers a free database for creating inventories to members or at least used to
     
    Hardcoaler likes this.
  6. BNSF FAN

    BNSF FAN TrainBoard Supporter

    10,220
    31,999
    153
    I got distracted while typing and Hardcoaler beat me to it. One of those great minds things :)
     
    Hardcoaler likes this.
  7. BoxcabE50

    BoxcabE50 HOn30 & N Scales Staff Member TrainBoard Supporter

    67,273
    23,511
    653
    I just use an Excel spreadsheet. Very simple and easy.
     
    Metro Red Line likes this.
  8. Hardcoaler

    Hardcoaler TrainBoard Member

    10,909
    47,164
    142
    That's what I use for the reasons you state. Easy peasy.
     
  9. BnOEngrRick

    BnOEngrRick TrainBoard Member

    724
    263
    28
    I had mine in Excel, but the collate feature didn't always work. I have mine in Word, using the tables, sorted by manufacturer and stock numbers. Can make it hard to find specific road name and number sometimes, but I rarely buy things without original box. New entries just insert a new line in proper place and enter. I also keep a print copy that I take to shows, so I only need to print new pages from the new entry on back.
     
    Hardcoaler likes this.
  10. Hardcoaler

    Hardcoaler TrainBoard Member

    10,909
    47,164
    142
    I should have added that my only problem using Excel is that it's on my PC. I'm not technically savvy enough to know how to get it onto my cell phone for access at train shows.
     
    BNSF FAN likes this.
  11. Ike the BN Freak

    Ike the BN Freak TrainBoard Member

    1,371
    135
    30
    You don't need to be, I'm not either, so I don't use the spread sheets to their full extent, for mine, on my freight car tab, I have one column for reporting marks, one road number, car type, manufacturer, manufacturer ID number, then additional columns for whether they have metal or plastic wheels, body or truck mounted couplers.

    I moved my file to google sheets, and can access it via an app. Took 2 seconds to copy it to google, just uploaded the excel sheet over.
     
    Hardcoaler and BNSF FAN like this.
  12. Hardcoaler

    Hardcoaler TrainBoard Member

    10,909
    47,164
    142
    Thanks for the suggestion; I think I can do that.
     
    BNSF FAN likes this.
  13. Scott Crowell

    Scott Crowell New Member

    8
    26
    1
    But what I am looking for is a fill in the blank idiot friendly data base that also tracks current values so IF I decide to sell anything, I have and idea of what it SHOULD be worth. Values are not exactly 100% unfortunately, but it does help with insurance.
     
    BNSF FAN likes this.
  14. BigJake

    BigJake TrainBoard Member

    3,509
    7,029
    75
    Tracking current values won't be free. Maintaining bots to periodically pull data, even as vendors change their websites, gets expensive, let alone developing the bots in the first place.
     
  15. Hardcoaler

    Hardcoaler TrainBoard Member

    10,909
    47,164
    142
    Trovestar (as mentioned in above posts) provides a Market Price on its listings when it can find records of sales. It's the third column from the right in this example.

    upload_2024-7-9_18-21-10.png
     
  16. BigJake

    BigJake TrainBoard Member

    3,509
    7,029
    75
    Well, I'll be... corrected.

    Thanks!
     
    Hardcoaler likes this.
  17. Scott Crowell

    Scott Crowell New Member

    8
    26
    1
    The problem with trying to sort in Excell are numbers. All numbers have to have the same number of digits otherwise things get wonky For example, if I have 100 items, I have to start numbering with 001 until I get to 099 and finally 100 so it sorts properly.
     
    BNSF FAN likes this.
  18. Mike VE2TRV

    Mike VE2TRV TrainBoard Member

    5,155
    13,813
    98
    Also use Excel. Super easy and super powerful once you get the hang of it.

    Not bad for someone who's a Luddite with personal tech but work in a high-tech job...:ROFLMAO:
     
    Hardcoaler likes this.

Share This Page