Lotus Elan

Elan Parts List - Excel file

PostPost by: gherlt » Fri Feb 05, 2021 9:25 am

There are a lot of online sources for the parts list, but there is nothing like have it also off-line on the computer.
I scanned all the pages and OCR'd them. Then I put them into an Excel and corrected the errors (mostly text/data misplaced on the page).
I re-arranged some data on the page into new columns and prepared them for inserting the data into a database (more on that later).
There is some more work to do, but I think it is quite nice already.
So, here it is, the first part (of 3).
Please feel free to make comments, corrections, suggestions.

Do not expect part 2 for tomorrow ... less so, if there are good suggestions for a better version of it :wink:
Attachments
Lotus Elan Parts list (1971) part 1 of 3 - AA-BN.xls
(1.06 MiB) Downloaded 109 times
Last edited by gherlt on Sun Feb 07, 2021 5:41 pm, edited 1 time in total.
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)

PostPost by: trw99 » Fri Feb 05, 2021 12:40 pm

Well done and thank you for your efforts.

Tim
User avatar
trw99
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 2908
Joined: 31 Dec 2003
Location: Essex/Herts border, UK

PostPost by: fattogatto » Fri Feb 05, 2021 3:40 pm

Impressive. Thank you. Take the rest of the day Off.
Charlie Warner
Fatto Gatto Racing
User avatar
fattogatto
Third Gear
Third Gear
 
Posts: 259
Joined: 23 Sep 2015
Location: Memphis, TN

PostPost by: TrevorJones » Fri Feb 05, 2021 8:40 pm

Wow that takes some doing, Brill job.

Someone on here was talking about using a list like this to crate a definitive bolting list! they will get a real leg up once you have finished the second half.

Thanks
TrevorJones
First Gear
First Gear
 
Posts: 23
Joined: 21 Jan 2016
Location: Bristol, England

PostPost by: Unibrain » Sat Feb 06, 2021 12:44 am

TrevorJones wrote:Wow that takes some doing, Brill job.

Someone on here was talking about using a list like this to crate a definitive bolting list! they will get a real leg up once you have finished the second half.

Thanks


And if we really want we can do this - https://test.elanregistry.org/app/list_parts.php

I imported the sheet into a DB which you can search. I also based together a count of things called BOLTS. We could even convert the PN to a description.

And yes, I had nothing to do this afternoon :)
User avatar
Unibrain
Third Gear
Third Gear
 
Posts: 372
Joined: 11 Sep 2003
Location: Portland, OR

PostPost by: mbell » Sat Feb 06, 2021 3:32 am

That pages does a good job of locking up the browser on my phone. I suspect that's down to the page size and probably works on on a desktop.

Unibrain wrote:We could even convert the PN to a description.


I am just (hopefully) finishing up a spreadsheet that can decode the bolt/screw/nuts/washer part codes. Which I was going to upload here.

Not sure if that's what you're referring to but having something like that in a web page would be useful. Probably more useful that a spread sheet :roll:
'73 +2 130/5 RHD, now on the road and very slowly rolling though a "restoration"
mbell
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 1882
Joined: 07 Jun 2013
Location: Austin, TX (UK Ex-pat)

PostPost by: gherlt » Sat Feb 06, 2021 4:49 am

mbell wrote:.

Not sure if that's what you're referring to but having something like that in a web page would be useful. Probably more useful that a spread sheet :roll:

The spreadsheet is the preparation for a database import.
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)

PostPost by: mbell » Sat Feb 06, 2021 5:00 am

I get that. I am talking about being able to decode the part numbers for bolts etc in to a human readable text form.

I am not sure if that is included in the page or not ( as my phone can't cope with the pages).
'73 +2 130/5 RHD, now on the road and very slowly rolling though a "restoration"
mbell
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 1882
Joined: 07 Jun 2013
Location: Austin, TX (UK Ex-pat)

PostPost by: Unibrain » Sat Feb 06, 2021 5:17 am

mbell wrote:I get that. I am talking about being able to decode the part numbers for bolts etc in to a human readable text form.

I am not sure if that is included in the page or not ( as my phone can't cope with the pages).


It was just a quick example of what is possible. I didn’t do the translation

FYI, https://lotuselan.net/wiki/Intro_-_Stan ... ber_Coding
User avatar
Unibrain
Third Gear
Third Gear
 
Posts: 372
Joined: 11 Sep 2003
Location: Portland, OR

PostPost by: gherlt » Sat Feb 06, 2021 7:25 am

Please find attached newest version
I made a few error corrections, changes (thanks for the tips) and three new columns:

- moved text out of "change point information" to comments, when NOT related to "change point"
e.g. "Coupe only", "Failsafe"
- Added Columns Chassis from/upto: numerical values of change point text
"ChassisFrom" the number after any "From" indication,
"ChassisUpto" the number after any "Upto" indication,
some text lines changed to simplify the extraction function
- Added column "HandedPart", displays "LHD" or "RHD", if the "+" is present in the Steering LH / RH columns

Let more suggestions come in !
Attachments
Lotus Elan Parts list (1971) part 1 of 3 - AA-BN.xls
(1.15 MiB) Downloaded 49 times
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)

PostPost by: gherlt » Mon Feb 08, 2021 6:02 pm

Hello,
I finished with part II & III, and a few corrections more on part I.

I will unite the three spreadsheets into one signle file tomorrow, if Excel holds up ...

I would like to ask for volunteers to review the files, as I go over and over I always find some small errors.

I need to correct the columns "Chassis from"/"Chassis from" as there are also engine change points.

I would also like to add a "car" column, as this is for the two seater but is expandable to the +2 (and should be done). If we get this right, other Lotus cars parts lists could be added.

Any other suggestions ?

Later this evening I will try to write down my vision for the parts database ...
Attachments
Lotus Elan Parts list (1971) part 3 of 3 - FB-TA.xls
(948 KiB) Downloaded 38 times
Lotus Elan Parts list (1971) part 2 of 3 - BO-FA.xls
(1.03 MiB) Downloaded 34 times
Lotus Elan Parts list (1971) part 1 of 3 - AA-BN.xls
(1.06 MiB) Downloaded 36 times
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)

PostPost by: gherlt » Tue Feb 09, 2021 12:26 pm

Please find attached the unified Excel-file.
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)

PostPost by: pharriso » Tue Feb 09, 2021 1:23 pm

gherlt wrote:Please find attached the unified Excel-file.


There is no attachment... maybe over the 2MB file size limit?
Phil Harrison
1972 Elan Sprint 0260K
User avatar
pharriso
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 3106
Joined: 15 Sep 2010
Location: Long Island NY, USA

PostPost by: gherlt » Tue Feb 09, 2021 4:02 pm

Yes, indeed.
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)

PostPost by: gherlt » Tue Feb 09, 2021 4:10 pm

XLS is too big (3MB), newer file formats XLSX and ODS are not allowed. ZIP neither.
So .... github:

https://github.com/gherlt/Lotus-Elan-Pa ... st%20(1971)%20AA-TA%20.xls

There is a download button on the right.
1964 S1 (engine ready, awainting body paint)
1967 S3 DHC (trying to recreate Alex Black's window cable clamp bolt)
1969 S4 FHC (engine worn ... )

Brian Bucklands 2nd edition available ! Look here: https://theelanman.com
gherlt
Fourth Gear
Fourth Gear
 
Posts: 565
Joined: 20 Jul 2006
Location: Weiden (DE) & Tarragona (ES)
Next

Total Online:

Users browsing this forum: No registered users and 2 guests