locked Re: Entering Card Lists in Spreadsheets


A&Y Dave in MD
 

What does this mean for next steps?

I completed a version of flats 1-27. But was not hearing how to coordinate. 

What next?

Dave 

Sent from Dave Bott's iPhone

On Oct 8, 2021, at 2:54 PM, sou1952 hayes via groups.io <Sou1952@...> wrote:


Ike

This work has already been started, I have been copying "F" CARD RECORDS and "P" CARD RECORDS into spread sheets for each car series. I have also created a Car Series Index by car number and railroad. One of the problem's I have run into is that most of the "F" Card RECORDS were scanned on a 8.5x11" scanner and sometimes some information was cut off, and they need to be scanned on a 11x17" scanner so that the entire page gets scanned. I have a larger scanner at home and plan to bring it to the next work session that I will attend. This will probably be in November since I am in Arizona for a family funeral and will be here for the October work session.

I am also doing the same project for passenger cars, since I scanned the "P" CARD RECORDS on my larger scanner some time ago. I also have some "L" CARD RECORDS that I have scanned from SERM that I would like to use to make drawing list for steam locomotives.

If you can wait until November work session I can show how much work has already been accomplished on this project.

Chris Hayes



-----Original Message-----
From: GEORGE EICHELBERGER <geichelberger@...>
To: main@southernrailway.groups.io <main@SouthernRailway.groups.io>
Cc: Hayes, Chris <SOU1952@...>; Kyle Shannon <kyle_shannon@...>; Rick Bell <Rwbrv4@...>
Sent: Sun, Oct 3, 2021 1:55 pm
Subject: Entering Card Lists in Spreadsheets

Would any SRHA members be interested in helping to catalog SRHA’s drawings by entering the pages on the different card lists into a spreadsheet? When that is done, we will link the pages from the Card List (F-Cards) to the drawing inventories Chris Hayes has been working on.

Starting from the card list for a particular car, my example below is from Card List F-70 showing the drawings for 500 40’ auto boxes. Page 1 of F-70 is attached. The columns of the spreadsheet would be the same as Pg 1. That gives us the car-to-drawings list. A spreadsheet ”search” could locate any drawing number that had been entered, then the Cover of that F-Card would give us car information. Many drawings do NOT show which cars they were used on so we need a “reverse” lookup technique if we want to go farther than searching the drawing number, finding the F-Card, going to the F-Card’s Cover.

The cover also may include the Specifications those cars were built under (those are in the archives as well).

To make the work somewhat easier, the F-Cards used a standard form for any car type. As F-70 is for a box car, the entry for “cattle bar” (and others) at the bottom of the page is simply left blank. 

The first column of each of the F-Card’s seven or so pages will be different but a “cut and paste” could be done to avoid typing that after the first F-Card. The form did change periodically, think wood and steel cars would have very different drawings, but there are not that many different forms for the 237 or so F-Cards that have been scanned.

Before anyone volunteers, the Card Lists file includes 4,170 scans, including covers. While I was nutty enough to do those scans, it took a very, very long time! This project calls for splitting the CLs among multiple volunteers.

Because the CLs are scanned, they can be emailed and folks can work on them wherever they are. We just need to coordinate the work.

Contact me at archives@... if you are interested.

Ike

<F-70 Pg1.jpeg>
<F-70 Pg1.jpeg>

Join main@SouthernRailway.groups.io to automatically receive all group messages.