If you read my piece on p21 of the April News then you'll know what this is about. MickT of this parish has kindly let me have his CD indexes and I'm using those as a starting point. The spreadsheet referenced below is very raw. I haven't even started to tidy it up, remove duplicates or think about the next few steps. My intention is to have the fourth and other columns given over to references to where more information can be found. Probably. Possibly? If anyone wants to have a look by all means do so and let me have a little feedback: your thoughts on how it should look or what it should contain. It is not going to have pictures or lots of words, they will be elsewhere. But what is the minimum/maximum that it should contain to be useful?
https://www.dropbox.com/s/dov2cvdzwmhswl9/Brian%27s%20Index.xls?dl=0 (https://www.dropbox.com/s/dov2cvdzwmhswl9/Brian%27s%20Index.xls?dl=0)
Brian
Very interesting - and very much reminiscent of my day job...
I would recommend some data cleaning straight off. I've made this copy: https://www.dropbox.com/scl/fi/49okucbmmlwr0qhym0mq6/Brian-s-Index-20200404.xls?dl=0&rlkey=4zax94seii2xuq9a1uuuigc6c
I've done the following:
- Identified approximately 35 cases of probable variants of the same layout, such as "Vale of Talynog" / "Vale of Tal-y-Nog". They are highlighted in yellow in a 'layouts' tab. I suggest we standardize these.
- Identified all the scale/gauge permutations - in a 'scales' tab. There are 130 distinct permutations within the 872 records! I wonder if there could be some standardization here too.
What if we move this to somewhere we can work on it collaboratively? (I'm not sure if Dropbox could allow it. Or we could move it to Google Sheets but that requires collaborators to be in the Google world.)
Keen to help more once we know more about what we want....
Quote from: Tom Haythornthwaite on April 04, 2020, 09:06
Identified all the scale/gauge permutations - in a 'scales' tab. There are 130 distinct permutations within the 872 records! I wonder if there could be some standardization here too.
I know it goes against the grain but maybe change it to separate columns for scale and gauge, mind you that doesn't help where it refers to more than on :-(