|
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.
Ike
|
|
|
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
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.
Ike
<F-70 Pg1.jpeg>
|
|
|
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.
Ike
|
This email has been checked for viruses by Avast antivirus software.
www.avast.com
|
|
|
|
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
_._,_._,_
|
|
|
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.
Ike
<F-70 Pg1.jpeg>
|
|
|
Dave:
Ignore the Hayes posting! It will have no effect on what we are doing.
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 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.
Ike
<F-70 Pg1.jpeg>
|
|
|
