Date   

Re: Computerized Freightcar Inventory Database Programs

Bob Webber <zephyr1@...>
 

You can easily put drop down menus with valid values in Excel. And, given the formats you can export and import to/from Excel it's easy to put data into and out of other products that use acknowledged standards for such things.

At 10:04 PM 3/7/2005, you wrote:

One advantage of a database program (at least the ones that I have used)
over Excel is that you can set up drop-down lists for each field. For
example, using Steve's field of Category, you can set the data base up with
pre-determined inputs for that field such as Pass, Frt, NonRev, MOW. You can
also set it up to allow for additions in case you missed something. This not
only keeps the information in each field consistent which allows for more
accurate searches, but also minimizes the typing required. Possibly this
could be done in Excel but I haven't played with it.

Jack Burgess
www.yosemitevalleyrr.com


Re: RI 50' Boxcar

vgnry <vgnry212@...>
 

--- In STMFC@..., Ed Hawkins <hawk0621@s...> wrote:

Bill,
These cars aren't listed in the 1/59 ORER but are listed in 7/62. I
don't have immediate access to any ORERs between these dates to find
out when the cars were renumbered. The RI Color Guide shows a photo
of > 110012 but this is a 1967 photo. The book states the cars were
leased
GAEX reporting marks) before RI took ownership. That being the case,
the prototype cars built by General American in the early 1950s had
Duryea underframes and straight side sills. Perhaps Steve Hile can
shed some more information about these cars, however, it's probably
going to be post-1960 data and outside the scope of this forum.
Railmodel Journal published a couple of articles on cars of this type
in 1990-91.
Regards,
Ed Hawkins

Ed, Many thanks.

Bill McClure


Russell Snow Plow Company - Again

bierglaesser <lgreen@...>
 

Can anyone tell me the new Penn Central or CONRAIL number for any of
these Pennsylvania Railroad Russell snow plows? Number 497798
eventually became AMTRK 16026 and was retired in June 1981 but what
was it in between while owned by PC or CR?

PRR 497758 Wood
PRR 499631 Wood
PRR 499632 Wood
PRR 994481 Wood
PRR 407788 1-1938 Steel
PRR 497709 Steel
PRR 497723 Steel
PRR 497759 Steel
PRR 497780 11-1946 Steel
PRR 497781 11-1946 Steel
PRR 497782 11-1946 Steel
PRR 497783 10-1946 Steel
PRR 497784 11-1946 Steel
PRR 497785 11-1946 Steel
PRR 497786 12-1946 Steel
PRR 497787 1-1947 Steel
PRR 497788 1-1947 Steel
PRR 497794 10-1947 Steel
PRR 497795 9-1947 Steel
PRR 497796 10-1947 Steel
PRR 497797 11-1947 Steel
PRR 497798 2-1948 Steel
PRR 497799 2-1948 Steel
PRR 497800 10-1947 Steel
PRR 497801 9-1947 Steel
PRR 497802 10-1947 Steel

Gene Green


Re: IMWX/Des Plaines boxcars with Viking roofs

Bill Darnaby
 

I don't trust web sites as the final answer. I suggest calling 847.297.2118. You might be surprised.

Bill Darnaby

Actually, their web site shows the Erie with the Large herald, which
is wrong for my late 30's time frame. They also show the Soo car
with the "50's style early block lettering". Nope, that won't do
either! The Erie (small herald), NKP or C&O are what I am looking
for. I don't think they are making any more, since the web site
hasn't changed in... a long time. Perhaps it doesn't reflect what is
available? No CE&I is listed (despite the rumor to the contrary on
this list...)
Dean Payne


Re: was "universal", now old car usage

Tim Gilbert <tgilbert@...>
 

Gatwood, Elden wrote:

All still interested;

Thanks for all the additional insights.

I just wanted to add one more interesting thing onto this discussion and
that is the use of different age cars in different services.

If the RRs were giving their newest and best cars to the customers that
most demanded them, who was getting the dregs?

I remember that the worst cars I ever saw were those in scrap service.
Others have pointed out that the worst boxcars they ever saw were in
grain, hide, or animal remains service.

I had earlier pointed out that I remember gons and flats with little
flooring remaining, still being used around Pittsburgh. I also remember
an older guy on the RR pointing out to me that the PRR hid gons all over
the area because of a gon shortage. While the mills may have demanded
really nice cars for coil service or shipping large structural shapes,
the left-overs must've been shunted into scrap service. Scrap dealers
commonly cut holes in the sides to fasten banding to cars that didn't
have tie-downs, which I am sure irritated the owner. I also remember
watching magnet operators purposely bashing the ends and sides out of
gons as idle amusement. Would you send your nice new gons to these guys
after they came back bashed to death? Similarly, would you send good
gons into hot coil service after they came back burned out? This mighty
have been the direct reason the PRR kept small numbers of really old
cars in active service.

Just a thought for us "nasty cars" modelers.
Elden,

Rule 18 of the Code of Car Service Rules effective 1/1/1960 had the following language:

A) Box Cars suitable for grain loading or better & Reefers must not be loaded with any of the contaminating commodities listed below:

1) Animal Products
1a) Hides, Pelts or Skins
1b) Glue Stock
1c) Manure or Fertilizing Compounds with Contaminating Odor,
1d) Meat Refuse, Offal, Tankage or Waste of slaughtered animals,
1e) Bones or Horns with Contaminating Odor,
1f) Dried Blood
1g) Tallow

2) Copra
3) Fish Scrap or Fish Meal
4) Shell Fish in Bulk
5) Shells in raw state with contaminating odor,
6) Asphalt Natural or Compounds. by product or petroleum,
7) Creosote or Creosote Materials
8) Lamp Black, Carbon Black, Graphite or Plumbago,
9) Poisonous Containers or Compounds in containers or bulk.

If such cars were loaded with these commodities, and it is necessary to renew floors, lining or sheathing in order to restore car to its condition prior to loading, that cost would be borne by the originating road, and not the car owner.

B) The following commodities must not be loaded in foreign boxcars classed as suitable for grain loading are better or reefers, except that such cars participating in the haul may be used when authorized by the car owner:

1) Used, Burned Out or Scrap Battery Parts,
2) Charcoal in Bulk or Bags,
3) Coal, Coke, Lignit & Briquettes,
4) Empty Containers when previous use of those containers were for acids, asphalt, chemicals, creosote, grease, oils, tar, tankage, and similar contaminating commodities unless thoroughly cleaned inside and outside to prevent contamination.
5) Cotton or Other Seeds, Hulls, Fibre or Shavings when oily or dyed, in bulk or in containers which would result in contamination.
6) Crushed, ground & powdered Glass in Containers or in Bulk.
7) Graphite in Containers which would result in Contamination,.
8) Greasy or Oily Products in bulk or in containers which would result in contamination including:
8a) Metal Borings & Turnings,
8b) Bearings,
8c) Chains,
8d) Electrical Apparatus,
8e) Iron or Steel Bars, Plates or Shapes,
8f) Machine Parts,
8g) Machinery,
8h) Pipe and Pipe Fittings,
8i) Scrap,
8j) Tin Plate (oiled),
8k) Vehicle Parts including implements and tractors.
9) Insecticides, Fungicides, Insect Repellents, Vermin Exterminators, Poisonous, in Containers or Bulk,
10) Peat or Peat Moss in Bulk,
11) Tar and Tar Products in barrels and tar refuse,
12) Acids,
13) Grease,
14) Molasses,
15) Oils,
16) Petroleum or Petroleum Products including compounded oils and greases having a contaminated base.

************************************

These Rules may have been in effect before 1960, but were never published as part of the Car Service Rules in the ORER's. I do know that boxcars were classified in yards after WW II as type A, B, C or D (sometimes X), but this is the first thing I have seen in elaborating what Class D and, perhaps, C were.

For other car types, there may have been some formal or informal restrictions between car owners and users, but I have not anything in writing.

Tim Gilbert


Car Classifications for Commodities

Guy Wilber
 

In a message dated 3/8/05 4:53:58 AM Pacific Standard Time,
tgilbert@... writes:

<< These Rules may have been in effect before 1960, but were never
published as part of the Car Service Rules in the ORER's. I do know that
boxcars were classified in yards after WW II as type A, B, C or D
(sometimes X), but this is the first thing I have seen in elaborating
what Class D and, perhaps, C were. >>

The Transportation Division of the AAR issued Circular T-25 in 1937 which
addressed the contamination of Auto and Box cars. This circular was the basis
for subsequent revisions; T-56 dated May 1, 1939 was eventually replaced by
T-213 which was the basis for Car Service Rule 18 adopted on January 1, 1950.
Rule 18 was the first to allow penalties and reimbursements for contamination of
car by owning roads. Many AAR circulars were printed within the ORER when
first issued. Searches of issues might yield the full wording of said circulars.


The above classifications supplied by Tim were essentially the same
throughout the period (1937-1960) though a few contaminating commodities were
revised/added and listed within different classifications. The 1955 list was submitted
within the first year of the STMFC list.

Regards,

Guy Wilber
Earthquake Faults, Nevada


Re: RI 50' Boxcar

Ed Hawkins
 

On Monday, March 7, 2005, at 05:17 PM, vgnry wrote:

Folks, in my decal bin I discovered an Oddballs Set #187-450 for a
green "RI 50' Boxcar (3-51), Series 110012-110024, Proto 2000 Kit".
I'm a sucker for neat decals, so I am sure I bought it without much
thought to the car. But now that I have rediscovered this set can
someone please help steer me to the correct car to match the decal?
Time to use them. And what commercial paint might match or come close
to the "dark green" suggeted by the set?
Bill,
These cars aren't listed in the 1/59 ORER but are listed in 7/62. I
don't have immediate access to any ORERs between these dates to find
out when the cars were renumbered. The RI Color Guide shows a photo of
110012 but this is a 1967 photo. The book states the cars were leased
(GAEX reporting marks) before RI took ownership. That being the case,
the prototype cars built by General American in the early 1950s had
Duryea underframes and straight side sills. Perhaps Steve Hile can shed
some more information about these cars, however, it's probably going to
be post-1960 data and outside the scope of this forum. Railmodel
Journal published a couple of articles on cars of this type in 1990-91.
Regards,
Ed Hawkins


Re: Computerized Freightcar Inventory Database Programs

dehusman <dehusman@...>
 

--- In STMFC@..., "Jack Burgess" <jack@y...> wrote:
One advantage of a database program (at least the ones that I have
used)
over Excel is that you can set up drop-down lists for each field.
=============================
You can make Excel function almost like a database by writing VBA
macros behind the spreadsheet.

Having said that, it is way easier to just use a database and do it
right from the beginning than try and force a spreadsheet to look
like a database. Even some of the $25 el-cheapo bargain bin
databases can do a pretty good job of organizing a roster. The major
limitation I have seen with some of them is how many columns you can
sort by, how sophisticated your forms can be.

I wrote an Access 97 database for creating car cards which can be
used for inventory purposes also. Its available on the Car Cards
Yahoo group files section, in the MS Office Applications folder (I
think). You have to have Access 97 (or newer) to run it. Its free
shareware.

Dave H.


PC based databases for inventory - my custom database

Jeff Lodge <cvfanbratt@...>
 

As a database programmer, I happen to like databases for this job. Excel is a great tool for someone who just needs to get a list developed and do some simple sorting/grouping/summing. However, the calculations I am doing make a spreadsheet rather underpowered for the task. I have written my tool in MS Access 97.

It includes not only my inventory, desired models and all kinds of other stuff (structures, vehicles, control equipment) but it is where I am performing my car list analysis. So far I have close to 5000 actual cars from the month of September 1955 going North on all CV Freights out of White River Junction, VT. (For anyone who received a copy of that list, I have since double checked it and corrected the unbelievable amount or errors in it...)

Now I am entering data from ORERs and other information to set the parameters for a road's car number series like:
Road: CN
Car type: Box
High number:485199
Low number:484100
Descript: 40' SS, 6' Young dr, 9' 4" IH, Dreaded-Dreadnot-Whatnot ends, Carmel Coated Cut levers, blah, blah
Kit: Westerfield 1001
.....
(OK guys, I just made all that data up, so don't start sending the flames my way just yet!..)

By doing the above, the program can now automatically assign the car list items to a specific car type so I know what kits I need. In other words, if a box from CN shows up with the number 484305 on the list, it will be assigned to the above mentioned car type - all without me having to do any thinking - which I only do as a last resort in any situation.

I can get percentages of cars by train number, by day of week, from month-to-month, north vs. south. All kinds of stuff that would be hard to crunch in Excel. As I enter more car list information and more ORER information, I don't have to change anything to perform the same calculations.

My database is not a commercial product and is not offered for sale. If you are interested, just contact me off list. If others are willing to work with me, we just might be able to get it to be a very powerful tool. Some long-range goals:
A web page where you enter the date, road name and car number. It would return the type of car, the data source (the closest ORER before the date for example), if there are any kits available....
A large collection of car lists from different roads and dates. In some cases, you could actually see a car moving around the country. Even within my small one month set of data, I can see the same cars moving back and forth between Canada and the Northeast. (And not just milk cars.) You could start to get a good feel for what was a real mix of cars for a particular route at a particular time.

Jeff Lodge
Brattleboro, VT

"Beckert, Shawn" <shawn.beckert@...> wrote:
List,

At the Sunshine Models meet at Buena Park this weekend,
Ted Culotta did a presentation on "Computers in Modeling".
One of the subjects he touched on was using a computer
database program to make an inventory of the freightcars
in our collections, showing a variety of useful information.

The poor guy was harassed unmercifully when it became obvious
how many cars in his fleet were still in unbuilt condition,
though nobody else dared say their closet looked any different!

A question for the listmembers: Ted is solidly a Macintosh user;
are there any PC-based inventory programs out there that could
be used to construct a database of our freightcar fleets? I'd
like to know about the more "user-friendly" programs; I'm not
that concerned about cost at the moment.

Thanks,

Shawn Beckert

Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/STMFC/

To unsubscribe from this group, send an email to:
STMFC-unsubscribe@...

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com


Re: Computerized Freightcar Inventory Database Programs

Jack Burgess <jack@...>
 

One advantage of a database program (at least the ones that I have used)
over Excel is that you can set up drop-down lists for each field. For
example, using Steve's field of Category, you can set the data base up with
pre-determined inputs for that field such as Pass, Frt, NonRev, MOW. You can
also set it up to allow for additions in case you missed something. This not
only keeps the information in each field consistent which allows for more
accurate searches, but also minimizes the typing required. Possibly this
could be done in Excel but I haven't played with it.

Jack Burgess
www.yosemitevalleyrr.com


Re: Computerized Freightcar Inventory Database Programs

Steve Sandifer <jssand@...>
 

You can use nearly any computer program these days to do this. I started mine in the MSWorks database years ago. However you could do the same thing in Excel or even in Word using the tables, but that is less flexible. Before you start, you need to decide the fields you want to include. When actually listing them, you don't want to have to look at every car several times. My fields include:

a.. Cat(egory): Pass, Frt, NonRev, MOW, (whatever you want)
b.. Grade: A-F. Grade A is a contest model. Grade C may be a car that is in non-prototype paint or a club car or an old Athearn. Grade F is on my RIP track but I want to keep up with it. As I get more Grade A and B cars, the grade C, D, & F cars should fear for their ebay lives.
c.. State: RTR, Kit, RIP
d.. Notes: resin car, wrong number, Rework as NC&StL prototype, replace brake staff, save for kitbash, etc.
e.. Mfg: Athearn, Roundhouse, P2K, etc.
f.. Mfg #: Mfg model # not the car #
g.. Type: Gondola
h.. Sub-type: War Emergency Mill gon
i.. Class: GA-61
j.. Blt: built year stenciled on car
k.. Rebld: Last date stenciled on car
l.. ID: reporting marks
m.. #: car number
n.. Length:
o.. Doors: 6', 8', Dbl, end
p.. Billboard: Chief, Super Chief, etc.
q.. Paint: color scheme
r.. Return to: For my layout, where the empty car needs to go empty for interchange
Of course you can add as many as you want. A database allows you to determine what fields to print and in what order. If you have a lot of cars, it is nice to take your latest printout ot the train show to see if you already have that car and that number. If it has a value listed, it could assist your heirs in determining the value of your collection (might cause a divorce in absentia!). If you keep up with your repairs, like wheel replacement, tracking problems, detection resister installed, kadee or McHenry couplers, or even weight of the car, you can have fields for that sort of information.

If you print your own car cards, you can use this data with merge mail to print them.

One note: if you plan on using a program like RailOp for your operations, start with it as your database. It will not import from other databases and you will end up having to enter everything twice - a job begging for mistakes.

______________
J. Stephen (Steve) Sandifer
mailto:steve.sandifer@...
Home: 12027 Mulholland Drive, Meadows Place, TX 77477, 281-568-9918
Office: Southwest Central Church of Christ, 4011 W. Bellfort, Houston, TX 77025, 713-667-9417

----- Original Message -----
From: Beckert, Shawn
To: STMFC@...
Sent: Monday, March 07, 2005 1:56 PM
Subject: [STMFC] Computerized Freightcar Inventory Database Programs


List,

At the Sunshine Models meet at Buena Park this weekend,
Ted Culotta did a presentation on "Computers in Modeling".
One of the subjects he touched on was using a computer
database program to make an inventory of the freightcars
in our collections, showing a variety of useful information.

The poor guy was harassed unmercifully when it became obvious
how many cars in his fleet were still in unbuilt condition,
though nobody else dared say their closet looked any different!

A question for the listmembers: Ted is solidly a Macintosh user;
are there any PC-based inventory programs out there that could
be used to construct a database of our freightcar fleets? I'd
like to know about the more "user-friendly" programs; I'm not
that concerned about cost at the moment.

Thanks,

Shawn Beckert

Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/STMFC/

b.. To unsubscribe from this group, send an email to:
STMFC-unsubscribe@...

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


Re: Computerized Freightcar Inventory Database Programs

vgnry <vgnry212@...>
 

--- In STMFC@..., "Beckert, Shawn" <shawn.beckert@d...> wrote:

Ted's out-of-state at the moment, but hopefully he'll be at
Winterail next
weekend and I can pick his brains a bit more on the software he's using.
Shawn, I have used RailBase from Albion Software for a number of years
to maintain a database of my freight car fleet. If you don't want to
build your own database with Access or Excel, take a look at it. It is
for model railroads or collectors. It runs on a PC platform, is
stable, and has good customer support. While it doesn't have every
single thing one might want, it has more data fields than I use. And
it has separate data files for cars, locos and cabooses.

Bill McClure
Richmond


Re: IMWX/Des Plaines boxcars with Viking roofs

Dean Payne <deanpayne@...>
 

Actually, their web site shows the Erie with the Large herald, which
is wrong for my late 30's time frame. They also show the Soo car
with the "50's style early block lettering". Nope, that won't do
either! The Erie (small herald), NKP or C&O are what I am looking
for. I don't think they are making any more, since the web site
hasn't changed in... a long time. Perhaps it doesn't reflect what is
available? No CE&I is listed (despite the rumor to the contrary on
this list...)
Dean Payne

--- In STMFC@..., "william darnaby" <WDarnaby@w...> wrote:
You're kidding?? When I was last there a couple of months ago
there were
still a bunch on the shelf. I will admit, I didn't look very
carefully at the road names as I got the ones I wanted long ago.

Bill Darnaby




The IMWX/Des Plaines Hobbies boxcars with Viking roofs are scarce,
and getting pricey. Is it possible to make these cars myself out
of
an Intermountain undec kit (while it is still available) along
with
the Des Plaines Viking roof and the appropriate decals?


RI 50' Boxcar

vgnry <vgnry212@...>
 

Folks, in my decal bin I discovered an Oddballs Set #187-450 for a
green "RI 50' Boxcar (3-51), Series 110012-110024, Proto 2000 Kit".
I'm a sucker for neat decals, so I am sure I bought it without much
thought to the car. But now that I have rediscovered this set can
someone please help steer me to the correct car to match the decal?
Time to use them. And what commercial paint might match or come close
to the "dark green" suggeted by the set?

Bill McClure
Richmond


Re: IMWX/Des Plaines boxcars with Viking roofs

Clyde Williams <billdgoat@...>
 

--- In STMFC@..., Mike Aufderheide <mononinmonon@y...>
wrote:
Dean,

I was at Des Plaines last week and they have the Erie
car in stock with the large herald for 18 bucks. They
also have one for CEI. Is this car correct?

Mike Aufderheide

I bought the C&EI car some time ago for the "Buy War Bonds"
lettering, as I model 1943.
I will leave to those more learned about the accuracy of the car
itself but a while ago I noticed in a WWII issue of Railroad magazine
about the C&EI coming out (before the 9-'43 time I model)with the war
bonds message on a number of their cars. The first in the series was
#64150. I checked my car and it was #64150. Kudos to Des Plaines
Hobbies for doing their research, at least on the lettering part.
Bill Williams


Re: Computerized Freightcar Inventory Database Programs

Brian Paul Ehni <behni@...>
 

Sounding more and more like FileMaker; it's really a great product, and IS
cross-platform.

Or maybe you should just get a Mac! 8^)
--

Brian Ehni

From: "Beckert, Shawn" <shawn.beckert@...>
Reply-To: <STMFC@...>
Date: Mon, 7 Mar 2005 14:57:27 -0800
To: <STMFC@...>
Subject: [STMFC] Re: Computerized Freightcar Inventory Database Programs


Andy Miller wrote:

I can add my name to the growing list of people who use Excel for their
rolling stock data base. I maintain three Excel spreadsheets; one for
freight cars, one for passenger cars and one for motive power.
I don't remember the name of the software Ted was using to construct his
data base (once he said it was Mac-based, I kind of zoned out), but I
do know that it wasn't Excel. It was much cleaner looking, and he had
quite a bit of information in it. One thing he was able to do was organize
cars by AAR designation (XM, XAP, etc.) and assign them accordingly to trains
and even industries. Now *that* is a feature I can put to good use.

Ted's out-of-state at the moment, but hopefully he'll be at Winterail next
weekend and I can pick his brains a bit more on the software he's using.

Shawn Beckert




Yahoo! Groups Links







Re: signs

dehusman <dehusman@...>
 

--- In STMFC@..., "Clark Propst" <cepropst@n...> wrote:
Can anyone suggest a way to get these specific signs?? Or at
least where I can get alphabets in different fonts?
============================
While waiting for my wife to finish pouring over all the junk, err
antiques at a local antique mall, I found a rack of guides to antique
collecting. One was about enamel signs. It had a hundred pages or
so of pictures of enamel advertising signs pictured in color, 4-6
signs per page. Every thing from clothes to coal to gum to electric
companies.

The signs could be photocopied or scanned and printed on photoquality
paper to make appropriate signage on your home layout.

Also Woodland Scenics and Microscale sell dry transfers and decals
(respectively) for signs. If you are doing a large building with a
Purina checkerboard, model aircraft hobby shops sell decal paper with
a red or white or rewand white checkerboard pattern.

Dave H.


Re: signs

Shawn Beckert
 

Clark Propst asked:

I have been busy building structures for my freight cars to be spotted at (content). I need some signs for these business'. The problem is, I only need one sign for each building. I need 4 or 5 signs. One is for Purina, I would think something like that would be available?


Clark, here's the Purina Web Page:

http://www.purina.ca/

If you can make a color print of this and cut out the logo, you
could paste/glue/fasten it to your industry.

Shawn Beckert


Re: Computerized Freightcar Inventory Database Programs

Jim and Lisa Hayes <jimandlisa97225@...>
 

Some years ago I wrote my own inventory system in MS Access. It includes car
inventory, parts inventory, what detail parts were used on each car, and a
some other things. I also use it to keep track of purchases (what I bought
where and when) and what's in my reference library. It does require some
knowledge of Access to use though.

Jim Hayes
Portland Oregon


signs

Clark Propst <cepropst@...>
 

I have been busy building structures for my freight cars to be spotted at (content). I need some signs for these business'. The problem is, I only need one sign for each building. I need 4 or 5 signs. One is for Purina, I would think something like that would be available?
Can anyone suggest a way to get these specific signs?? Or at least where I can get alphabets in different fonts?
Thanks,
Clark Propst

157781 - 157800 of 197060