Lotus Fastner Decoder Spreadsheet

PostPost by: mbell » Sat Feb 06, 2021 11:01 pm

I've made a spreadsheet that can decode the Lotus part number for various fasteners, as described by:
https://lotuselan.net/wiki/Intro_-_Stan ... ber_Coding

This can be accessed at:
https://docs.google.com/spreadsheets/d/ ... sp=sharing

This should load the spread sheet in your browser, if you enter the part code in the green box it should decode it and give you a human readable description.

You can also probably save a copy for yourself to your computer. I've locked everything in the spreadsheet apart from the input box to prevent it getting corrupt. But you should be able to see how it works it you want to look around the spread sheet.

I've tried it with a few random things from the part manual but there probably some bugs in it. If you find any or have other comments let me know here.
'73 +2 130/5 RHD, now on the road and very slowly rolling though a "restoration"
mbell
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 2691
Joined: 07 Jun 2013

PostPost by: gherlt » Sun Feb 07, 2021 6:41 am

Hello,
I would like to take a look at the formulas, so I downloaded it as Excel (and ODS) and loaded into Excel (2016 I think). Now, Excel says it is corrupt (of course, it comes from Google) and deletes "something" (won't tell)
and then it does not work anymore.
If you created it in Google, where do I have to look for the formulas ?
And if you created it in Excel, could you post the original file in Google Drive ?
Thanks
1964 S1 (at paint shop)
1967 S3 DHC
1969 S4 FHC (at BB's home)

https://theelanman.com for details on Brian Bucklands book.
https://shop.lotus-books.com for more Lotus related books.
We ship worldwide. PM/Email me.
gherlt
Fourth Gear
Fourth Gear
 
Posts: 635
Joined: 20 Jul 2006

PostPost by: pharriso » Sun Feb 07, 2021 12:45 pm

Mark, very nice!! Thank you.

I had the same issue with Google/Excel corrupting the file when it is downloaded & saved locally.
Phil Harrison
1972 Elan Sprint 0260K
User avatar
pharriso
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 3596
Joined: 15 Sep 2010

PostPost by: pharriso » Sun Feb 07, 2021 12:52 pm

gherlt wrote:If you created it in Google, where do I have to look for the formulas ?
And if you created it in Excel, could you post the original file in Google Drive ?
Thanks


Do you see the 2nd & 3rd worksheets "Working" & "Data"?....

Yes, Mark if you could post the original Excel that would be useful as well, again Good Job !! :D
Phil Harrison
1972 Elan Sprint 0260K
User avatar
pharriso
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 3596
Joined: 15 Sep 2010

PostPost by: gherlt » Sun Feb 07, 2021 5:51 pm

pharriso wrote:Do you see the 2nd & 3rd worksheets "Working" & "Data"?....

:oops: No ....
1964 S1 (at paint shop)
1967 S3 DHC
1969 S4 FHC (at BB's home)

https://theelanman.com for details on Brian Bucklands book.
https://shop.lotus-books.com for more Lotus related books.
We ship worldwide. PM/Email me.
gherlt
Fourth Gear
Fourth Gear
 
Posts: 635
Joined: 20 Jul 2006

PostPost by: mbell » Sun Feb 07, 2021 6:46 pm

pharriso wrote:Yes, Mark if you could post the original Excel that would be useful as well, again Good Job !!


Afraid the Google sheet is the original/only version I have.

I suspect that exporting it to excel likely converts some of the formulas to values or excel doesn't support the formulas used. I don't have excel on any of my personal computer but will see if I can make an excel version that I could upload.
'73 +2 130/5 RHD, now on the road and very slowly rolling though a "restoration"
mbell
Coveted Fifth Gear
Coveted Fifth Gear
 
Posts: 2691
Joined: 07 Jun 2013

Total Online:

Users browsing this forum: snowyelan and 19 guests