Lotus Fastner Decoder Spreadsheet

[mbell]

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.

[gherlt]

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

[pharriso]

Mark, very nice!! Thank you.

I had the same issue with Google/Excel corrupting the file when it is downloaded & saved locally.

[pharriso]

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 !!

[gherlt]

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

No ....

[mbell]

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.