« previous next »
Pages: [1] 2 3   Go Down

Author Topic: Rolling stock spreadsheet/database  (Read 5921 times)

0 Members and 1 Guest are viewing this topic.

Ed Kapuscinski

  • Global Moderator
  • Crew
  • *
  • Posts: 26028
  • Head Kino
  • Respect: +11449
    • Conrail 1285
Rolling stock spreadsheet/database
« on: September 07, 2009, 10:17:48 PM »
0
I'm starting to inventory all my freight cars (to determine what I have/need for the future layout).

Here's the data I'm capturing, and some examples:
OwnerReporting MarksPaint Scheme NotesRoad NumberCTDLengthGeneral Car TypeSpecific Car TypeService ManufacturerItemWeightWheelsCouplersWeatheredAcquisition DatePrice Paid
Milwaukee RdMILW416060Box CarDD Auto Parts CarAtlas36911Atlas Plastic LPAccumateNo
Penn CentralPC22100560Box CarDPD Auto Parts CarMTL102 00 090FVM Metal LPMTLNo
Missouri PacificMP26511560Box CarSD Auot Parts CarAtlas37352Atlas Plastic LPAccumateNo
ConrailCRBig Wheel293357XP86Box Car4DR Auto Parts CarX60GBluford Shops86091Atlas Plastic LPAccumateNo
Penn CentralPC593057GB60GondolaMill GonG26Eastern Seaboard Models22031MTL Plastic LPMTLNo9/6/09
ConrailCR593105GB60GondolaMill GonG26Eastern Seaboard Models220401MTL Plastic LPMTLNo9/6/09

Anything you see I'm missing?
« Last Edit: September 07, 2009, 10:34:57 PM by Ed Kapuscinski »
Logged

Ed Kapuscinski

  • Global Moderator
  • Crew
  • *
  • Posts: 26028
  • Head Kino
  • Respect: +11449
    • Conrail 1285
Re: Rolling stock spreadsheet/database
« Reply #1 on: September 07, 2009, 10:32:07 PM »
0
Oh yeah. Oops.

It is an excel sheet.
Logged

TiVoPrince

  • Crew
  • *
  • Posts: 5156
  • Respect: +4
    • http://www.technologywrangler.com
Re: Rolling stock spreadsheet/database
« Reply #2 on: September 07, 2009, 10:32:21 PM »
0
Couple
of suggestions
Factory air Y/N
Origial box Y/N
Disposable Y/N
Location Storage/Layout/Club
Probably more, but its a holiday...
Logged
Support fine modeling

asciibaron

  • Guest
Re: Rolling stock spreadsheet/database
« Reply #3 on: September 07, 2009, 11:01:51 PM »
0
where on the layout they can be found?
Logged

MrKLUKE

  • Crew
  • *
  • Posts: 847
  • Respect: +5
.
« Reply #4 on: September 07, 2009, 11:10:09 PM »
0
.
« Last Edit: August 05, 2016, 10:33:21 PM by MrKLUKE »
Logged

Chulvis

  • The Pitt
  • Crew
  • *
  • Posts: 3437
  • Gender: Male
  • Respect: +10
Re: Rolling stock spreadsheet/database
« Reply #5 on: September 07, 2009, 11:54:46 PM »
0
No WP equipment listed. Loser.
Logged

Ian MacMillan

  • Global Moderator
  • Crew
  • *
  • Posts: 12034
  • Gender: Male
  • Learn to use the god damn search feature!
  • Respect: +167
    • Conrail's Amoskeag Northern Division
Re: Rolling stock spreadsheet/database
« Reply #6 on: September 08, 2009, 12:50:44 AM »
0
I also have on mine (Mysql database with GUI) The last 6 are because I also use the database for layout operations so the dispatcher knows what is where in live time.   I also have the non layout fields Road Name, Road Number, Type, etc on another query so that while I am at shows or stores I can access it via my Blackberry to make sure I'm not buying repeat numbers...etc...

MSRP:
Purchase Price:
Purchased From:
Car Destination:
Industry Location:
Industry Spotting:
Town:
Train Number:
Load:

Logged
I WANNA SEE THE BOAT MOVIE!

Yes... I'm in N... Also HO and 1:1

Chris333

  • Crew
  • *
  • Posts: 19502
  • Respect: +6785
Re: Rolling stock spreadsheet/database
« Reply #7 on: September 08, 2009, 04:27:00 AM »
0
I spread my jewel boxes out on a shelf. When I want a car it is right there with the label facing out.  :-*
Logged

tom mann

  • Administrator
  • Crew
  • *****
  • Posts: 10917
  • Representing The Railwire on The Railwire
  • Respect: +1014
    • http://www.chicagoswitching.com
Re: Rolling stock spreadsheet/database
« Reply #8 on: September 08, 2009, 06:47:55 AM »
0
1.  Ranted about on forum.
2.  Ranted about on TTAT.
Logged

SirTainly

  • Crew
  • *
  • Posts: 1785
  • Gender: Male
  • Respect: +93
Re: Rolling stock spreadsheet/database
« Reply #9 on: September 08, 2009, 06:57:55 AM »
0
Started something similar a while back using a MySQL DB, much better than ExHell.
Logged

wm3798

  • Crew
  • *
  • Posts: 16551
  • Gender: Male
  • I like models. She likes antiques. Perfect!
  • Respect: +7432
    • Western Maryland Railway Western Lines
Re: Rolling stock spreadsheet/database
« Reply #10 on: September 08, 2009, 07:32:07 AM »
0
I've got an XL sheet that lists:
Date In, Road Name, Class (Car Type), Road Number, Rtn Empty To, Interchange, Lading, Mfr (model), Coupler, Update Date, Owner, Source (where I got it from), approx. value.
When I was at John's yesterday, he showed me the program he's using, a free download from somewhere, which I'm hoping he remembers to send me the link, like I asked! :D

Lee
Logged
Rockin' It Old School

Lee Weldon www.wmrywesternlines.net

Packer

  • Crew
  • *
  • Posts: 742
  • Gender: Male
  • Respect: +1
Re: Rolling stock spreadsheet/database
« Reply #11 on: September 08, 2009, 07:46:16 AM »
0
Quote from: Chulvis on September 07, 2009, 11:54:46 PM
No WP equipment listed. Loser.

Seconded, Also no BN, SP, or DRG&W...

I actually did mine on pencil and paper (from memory, so it wasn't complete) while I was sitting through some of my classes. I've used Dallas Model Work's free one since it looks nicer than an exhell sheet.

BTW, Here's Mine:
http://www.dallasmodelworks.com/myrailroad.asp?ID=351
Logged
Vincent

If N scale had good SD40-2s, C30-7s, U30Cs, SD45s, SD40s, and SW10s; I'd be in N scale.

wm3798

  • Crew
  • *
  • Posts: 16551
  • Gender: Male
  • I like models. She likes antiques. Perfect!
  • Respect: +7432
    • Western Maryland Railway Western Lines
Re: Rolling stock spreadsheet/database
« Reply #12 on: September 08, 2009, 08:08:51 AM »
0
Packer, you're doing it wrong.  You're supposed to doodle track plans during class.

Lee
Logged
Rockin' It Old School

Lee Weldon www.wmrywesternlines.net

keystonecrossings

  • Crew
  • *
  • Posts: 590
  • Gender: Male
  • Respect: 0
    • Middle Division Musings
Re: Rolling stock spreadsheet/database
« Reply #13 on: September 08, 2009, 08:14:42 AM »
0
Ed:

Manufacturer Part Number
Pending Repairs
Notes (decoder make/model for locos)
Decoder ID (only if locos in same database)
Logged
Jerry Britton, PRRT&HS #6111
PRR Middle Division in HO Scale - http://jbritton.pennsyrr.com
Keystone Crossings - http://pennsyrr.com

DKS

  • The Pitt
  • Crew
  • *
  • Posts: 13424
  • Respect: +7027
Re: Rolling stock spreadsheet/database
« Reply #14 on: September 08, 2009, 09:06:10 AM »
0
Quote from: Chris333 on September 08, 2009, 04:27:00 AM
I spread my jewel boxes out on a shelf. When I want a car it is right there with the label facing out.  :-*

I don't even bother with the boxes. My cars are placed in the "cells" of foam-lined drawer "workbooks." When I open a drawer, the cars are arranged in road name order, with all pertinent information displayed, and no need for typing anything.
Logged
Pages: [1] 2 3   Go Up
« previous next »