Hi StumpyWally,
Been over a year since I last got your spreadsheet, any updates since the 2018-07-03 release?
Hi xr4ticlone,
I too have many times wanted to be able to find which machines have same or similar dimensions so I can find more attachments to fit my machine. Yesterday I merged the 2 spreadsheets and started writing some formulas to highlight rows that showed machines with exact or close dimensions.
You can download it from here...
Libre Office (.ODS) file...
http://www.mancave.space/Industrial...ng_Dimensions_(AllListWithWebdudesSearch).ods
http://www.mancave.space/Industrial...ng_Dimensions_(AllListWithWebdudesSearch).xls
Microsoft Office (.XLS) file...
http://www.mancave.space/Industrial...ng_Dimensions_(AllListWithWebdudesSearch).xls
I did the work in Libre Office Calc (free and very awesome equivalent of Microsoft Excel) and saved it as a .ODS (Open Document Format) file.
I then also exported it as a .XLS file so that you Microsoft victims can open it (though Libre Office is available for Windoze too! www.libreoffice.org ).
Sometimes some formatting tweaks get lost or skewed when converting between formats and you get truncated data columns etc. I don't own or use a copy of Microsoft Office so I haven't tested the .XLS version yet. Let me know if it doesn't work or looks a mess.
Currently It just allows searching on 3 parameters: 'Nominal Stick Pin Diameter' (Pin F), 'Bucket Width at Stick' (B-B-F), and 'Pin Centers' (C-C).
But as well as the 'Exact' value you are looking for (rows highlighted green), you also set a 'Min' and 'Max' value for each to find machines with a 'Close' match (rows highlighted yellow).
eg.
--------| Pin | BTE | CtoC |
| Min | 43 | 1 | 225 |
| Exact | 45 | 161 | 230 | <--Exact Dimensions
| Max | 47 | 171 | 235 |
----------------------------
For a small Pin size I allow to find Pin sizes 2mm smaller and larger (eg, 43mm-47mm), which is not ideal but should be ok or could be easily modified if needed (eg. a larger pin could be shaved / ground down to match).
For the BTE (Between The Ears), I just set the Min to 1. If a dipper arm is narrower it will still fit in the bucket and could have spacers / shims added to reduce any sloppiness.
I allow 10mm more on the Max value, often even if the Stick Width is just a little too big you can shave a little off the inside bosses of the attachment to make it fit.
The CtoC (Center to Center / Pin Centers) is a little less forgiving. Having to cut out one pin from both the Ear plates and re-weld it so the pins are closer together or further apart is doable, but is a big job. However, I have sometimes shaved a little off a pin to give just enough room to fit in a hitch that was too tight, so I allow a few mm either way in my search. Also if you have a variable Pin Center distance on your hitch (nice), you have the ability to accept attachments with a much greater CtoC range so this Min & Max feature will help you find many other compatible machines.
If you only want exact values, just set the Min & Max to the same as the Exact value.
eg.
--------| Pin | BTE | CtoC |
| Min | 45 | 161 | 230 | <--Min Value same as Exact
| Exact | 45 | 161 | 230 | <--Exact Dimensions
| Max | 45 | 161 | 230 | <--Max Value same as Exact
----------------------------
ONLY the 9 fields at the top in the light coloured yellow and green are to be modified.
Please be careful where you click. I suggest you save a copy as (ORIGINAL) and another for daily use, if you bump something you shouldn't and accidentally save it, then delete it and take another copy from the ORIGINAL file.
I am in Australia and we use Metric, so sorry only millimeter (mm) values can be entered.
But I did add the auto-calculating inches column next to each field so you can see what the metric value is in imperial inches.
This tweak to StumpyWally's awesome work does give you some idea of the other machines with 'exact' matching dimensions and 'close' matching dimensions.
However, don't assume this is accurate, it only works for about 90% of the rows, as some machines have data values missing or non numeric values entered like: 485/512 etc.
eg.
if you do a search with the following broad parameters to catch everything...
--------| Pin | BTE | CtoC |
| Min | 1 | 1 | 1 |
| Exact | 100 | 100 | 100 |
| Max | 999 | 999 | 999 |
----------------------------
...you will see the un-highlighted rows that it doesn't match.
So, you still have to scroll down the list of 1600+ rows of data to find the highlighted rows, but it does save comparing values one row at a time, trying to manually find matching machines (an hours work maybe?).
I have used it already to find machines with similar dimensions to my hitch setup which should make finding buckets to fit much easier now I know which other machine's are compatible.
@ StumpyWally...
Your work has saved me a great deal of time researching to find dimensions for many machines, I wanted to give something back.
I hope you find the feature useful. and if you think it is cool, I am happy to add the extra features (and maybe improve them a little each time) to your spreadsheets as you release new versions.
Enjoy Responsibly!!!
Webdude
Been over a year since I last got your spreadsheet, any updates since the 2018-07-03 release?
Crazy question here...but how hard would it be to make a (I guess macro) that would allow you to put in your machine's info and see what other machines have a workable bucket?
I ask because I have customers with buckets that I have the measurements but it'd be cool if you could put that in and it would bring up all the machines that would fit.
Hi xr4ticlone,
I too have many times wanted to be able to find which machines have same or similar dimensions so I can find more attachments to fit my machine. Yesterday I merged the 2 spreadsheets and started writing some formulas to highlight rows that showed machines with exact or close dimensions.
You can download it from here...
Libre Office (.ODS) file...
http://www.mancave.space/Industrial...ng_Dimensions_(AllListWithWebdudesSearch).ods
http://www.mancave.space/Industrial...ng_Dimensions_(AllListWithWebdudesSearch).xls
Microsoft Office (.XLS) file...
http://www.mancave.space/Industrial...ng_Dimensions_(AllListWithWebdudesSearch).xls
I did the work in Libre Office Calc (free and very awesome equivalent of Microsoft Excel) and saved it as a .ODS (Open Document Format) file.
I then also exported it as a .XLS file so that you Microsoft victims can open it (though Libre Office is available for Windoze too! www.libreoffice.org ).
Sometimes some formatting tweaks get lost or skewed when converting between formats and you get truncated data columns etc. I don't own or use a copy of Microsoft Office so I haven't tested the .XLS version yet. Let me know if it doesn't work or looks a mess.
Currently It just allows searching on 3 parameters: 'Nominal Stick Pin Diameter' (Pin F), 'Bucket Width at Stick' (B-B-F), and 'Pin Centers' (C-C).
But as well as the 'Exact' value you are looking for (rows highlighted green), you also set a 'Min' and 'Max' value for each to find machines with a 'Close' match (rows highlighted yellow).
eg.
--------| Pin | BTE | CtoC |
| Min | 43 | 1 | 225 |
| Exact | 45 | 161 | 230 | <--Exact Dimensions
| Max | 47 | 171 | 235 |
----------------------------
For a small Pin size I allow to find Pin sizes 2mm smaller and larger (eg, 43mm-47mm), which is not ideal but should be ok or could be easily modified if needed (eg. a larger pin could be shaved / ground down to match).
For the BTE (Between The Ears), I just set the Min to 1. If a dipper arm is narrower it will still fit in the bucket and could have spacers / shims added to reduce any sloppiness.
I allow 10mm more on the Max value, often even if the Stick Width is just a little too big you can shave a little off the inside bosses of the attachment to make it fit.
The CtoC (Center to Center / Pin Centers) is a little less forgiving. Having to cut out one pin from both the Ear plates and re-weld it so the pins are closer together or further apart is doable, but is a big job. However, I have sometimes shaved a little off a pin to give just enough room to fit in a hitch that was too tight, so I allow a few mm either way in my search. Also if you have a variable Pin Center distance on your hitch (nice), you have the ability to accept attachments with a much greater CtoC range so this Min & Max feature will help you find many other compatible machines.
If you only want exact values, just set the Min & Max to the same as the Exact value.
eg.
--------| Pin | BTE | CtoC |
| Min | 45 | 161 | 230 | <--Min Value same as Exact
| Exact | 45 | 161 | 230 | <--Exact Dimensions
| Max | 45 | 161 | 230 | <--Max Value same as Exact
----------------------------
ONLY the 9 fields at the top in the light coloured yellow and green are to be modified.
Please be careful where you click. I suggest you save a copy as (ORIGINAL) and another for daily use, if you bump something you shouldn't and accidentally save it, then delete it and take another copy from the ORIGINAL file.
I am in Australia and we use Metric, so sorry only millimeter (mm) values can be entered.
But I did add the auto-calculating inches column next to each field so you can see what the metric value is in imperial inches.
This tweak to StumpyWally's awesome work does give you some idea of the other machines with 'exact' matching dimensions and 'close' matching dimensions.
However, don't assume this is accurate, it only works for about 90% of the rows, as some machines have data values missing or non numeric values entered like: 485/512 etc.
eg.
if you do a search with the following broad parameters to catch everything...
--------| Pin | BTE | CtoC |
| Min | 1 | 1 | 1 |
| Exact | 100 | 100 | 100 |
| Max | 999 | 999 | 999 |
----------------------------
...you will see the un-highlighted rows that it doesn't match.
So, you still have to scroll down the list of 1600+ rows of data to find the highlighted rows, but it does save comparing values one row at a time, trying to manually find matching machines (an hours work maybe?).
I have used it already to find machines with similar dimensions to my hitch setup which should make finding buckets to fit much easier now I know which other machine's are compatible.
@ StumpyWally...
Your work has saved me a great deal of time researching to find dimensions for many machines, I wanted to give something back.
I hope you find the feature useful. and if you think it is cool, I am happy to add the extra features (and maybe improve them a little each time) to your spreadsheets as you release new versions.
Enjoy Responsibly!!!
Webdude