16
Ace, Aceca & Greyhound Forum / Re: Aceca registrar
« on: February 09, 2019, 22:27:43 »On the topic of technical data and after making a few personal observations I was brought to compile the registers for cars originally using Bristol engines and came up with something that looks like this.
I started from the Ace Bristol register which gave the basic format but added a few columns.
The "Latest Update" column in particular mentions the date when the last bit of information on a given chassis number was entered, which I feel is somewhat important.
(The powers of Excel allowed me to highlight that 16 Bristol engines were each fitted at the factory in 2 different chassis numbers - I know the Bristol engine has many qualities but being ubiquitous is a bit much surely?)
This is a possible way to reformat all the registers. I am happy to volunteer if I am provided with all the current registers in an Excel format. I have no ambition as a registrar but happy to bring a more user-friendly and relevant formatting if it might be of any use.
I have been converting the pdf version of the various Ace Registers to Excel format for my personal use. If you have a copy of Acrobat Pro, simply save the file as an Excel file and you are good to go with just minor cleanup. If the pdf version has some missing lines in the tables (some do) then you have to manually draw the lines in the pdf copy of the file before you convert it to Excel. If you don't add the missing lines, then Acrobat doesn't know how to convert the tables and you end up with long data strings.
You correctly point out the fact the Registers do not have common formats or naming terminology so combining them is a pain.
Good luck,
Bert
ACOC 4117