1. Topics
  2. Entering Card Lists in Spreadsheets

locked Entering Card Lists in Spreadsheets

George Eichelberger
 

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
George Eichelberger
 

One other thing…..

Having some form of lookup process will help is a big way.

A single Card List can include different car series (note the three pairs of columns). Those series may/may not be from the same Specification. One CL can refer to multiple car series/specs but one Specification may have been used for different orders of basically the same car…those could point to different Card Lists.

Confusing, I realize, but there is not rigid car series-Card List-Specification relationship.

We can inventory the drawings but only by going through the drawings listed in the CLs will we discover drawing numbers we do not have.

Ike


On Oct 3, 2021, at 1:54 PM, George Eichelberger <geichelberger@...> wrote:

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>
Dave Queener
 

Ike,

I would be happy to help with the F cards. Just assign the lower numbered ones to me, principally the wood cars, since that is what I have been working on already.

Dave

On 10/3/2021 1:54 PM, George Eichelberger wrote:
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



Avast logo

This email has been checked for viruses by Avast antivirus software.
www.avast.com


Charles Harris
 

Hi  Interesting project.

Is it possible to add a photo of the complete page 1 form, including the first column and also the full from for page 2.  What format is this in a the moment ?    jpg?

The spreadsheet that would be used is    Excel ?

An example of expected completed spreadsheet layout would be great with the expected result.

Thanks

Charles Harris
_._,_._,_
Hal Pridgen
 

I just thought I would point out that groups.io has a built in database feature that can be directly accessed from the groups.io web page.  So if you read these posts on your email, you would never see this feature. 

It’s very basic, and not particularly user friendly until you get familiar with it. The data can be exported to excel or other spreadsheet format. It’s also searchable, but I don’t think that is one of it's strong points either. 
Evan Whatley
 

Ike-
I'm interesting in joining this effort as well. Might be worthwhile to use Google Drive to host the sheets?
--
-Evan Whatley
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>
George Eichelberger
 

Dave:

Ignore the Hayes posting! It will have no effect on what we are doing.

Ike

On Oct 8, 2021, at 4:43 PM, A&Y Dave in MD <dbott@...> wrote:

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>
1 - 8 of 8