• Thank you for visiting HeavyEquipmentForums.com! Our objective is to provide industry professionals a place to gather to exchange questions, answers and ideas. We welcome you to register using the "Register" icon at the top of the page. We'd appreciate any help you can offer in spreading the word of our new site. The more members that join, the bigger resource for all to enjoy. Thank you!

Pin-on Bucket Mounting Specs

webdude

New Member
Joined
May 29, 2013
Messages
4
Location
Australia
Hi StumpyWally,
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
 

StumpyWally

Senior Member
Joined
Oct 21, 2011
Messages
516
Location
Liv'in the Dream ---------------> in Ballston, NY
Occupation
PE Civil Eng'r, Computer Sys. Mgr., Retired
Hi StumpyWally,
Been over a year since I last got your spreadsheet, any updates since the 2018-07-03 release?

My latest version is contained in post #76. Rest assured that any updates I do I always post in this thread.

Your macro work sounds very interesting....but I'll have to wait 'til this Winter before I download it & fiddle with it. I'm just too busy now....gotta work now while the weather is good.

Stumpy
 

kevward11

New Member
Joined
Oct 9, 2019
Messages
2
Location
60646
Thank you for this spread sheet. I bought a beat up yanmar B 22 and have been looking in vain for this info, and here it is. Got to love the internet, I'd buy a round for the house if we were sitting at a bar. Thanks again.
 

SchreiberEX

Member
Joined
Mar 14, 2016
Messages
5
Location
Ontario, NY
I have a b50-22and it's pretty dilapidated but we bought a 12 inch bucket for it when we were using it. It is available and in good shape in rochester, ny area
 

cps

Senior Member
Joined
Jul 13, 2008
Messages
811
Location
Ireland
Occupation
plant mechanic
Hi Guys, Is there any updates on the pin dimensions
 

mx727

Well-Known Member
Joined
May 5, 2012
Messages
68
Location
Memphis
Yanmar ViO80 image attached. I believe that is the same for the SV100, but will verify.

ViO80 Pin Dimensions.png
 

mx727

Well-Known Member
Joined
May 5, 2012
Messages
68
Location
Memphis
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.

Easy solution is a multi-level sort of the Excel data. I'd sort on Pin Diameter, then Pin Centers, then Bucket Width.
 

StumpyWally

Senior Member
Joined
Oct 21, 2011
Messages
516
Location
Liv'in the Dream ---------------> in Ballston, NY
Occupation
PE Civil Eng'r, Computer Sys. Mgr., Retired
Here is my latest update of 12/01/2020 - & a new version - of the Excavator Bucket Mounting Dimensions:
Let me know, good or bad, if this new version works for you.

Keep reading for an explanation of what’s new & different…

The master list is now a Google Sheet in my Google Drive. Via the link above, anyone can have view-only access to the link. You can bookmark the sheet in your own browser. Be aware that the Google “sheet” is actually a spreadsheet workbook, that consists of 3 tabbed sheets: Dimensions, Diagram, & Revision History.

If you are not familiar with Google Sheets, it is essentially a cloud-based web app that mimics Excel. There is nothing to install on your computer (except a web browser) in order to be able to view, print, or download the workbook (the list of dimensions).

I have eliminated all color coding for revision identification, thereby freeing up color coding to highlight the “same” or “close” row matches that are found using the scheme that WebDude introduced in his post #84.

To highlight the “finds”, you must first download the spreadsheet by doing the following:
1. Be sure the Google Sheets pull-down menu is un-hidden, by clicking on the “down-arrow” in the upper right corner of the sheet.
Menu On.png

2. Be sure that you have Excel (or equivalent spreadsheet software, like the free Libre Office Calc) installed on your computer.
3. Then from the Google Sheet pull-down menu, select “File>Download” & pick the format for your installed software (either Excel format, or OpenDocument format for Libre Office Calc).
Download.png
4. Open your downloaded document & do as the instruction at the upper left of the sheet explains (shaded in red).
Find Instruction.png

Please note the following when doing “finds”:
1. The 9 find fields are all based on metric (mm). There is an auto-calculating field in inches to the right of each.
2. You can only find based on 3 dimensions: the pin diameter at the stick (= the front pin, or Pin F on the diagram), the bucket width at the stick (= the between-the-ears-value, or B-B F on the diagram), & the pin centers (C-C on the diagram). The logic behind this is well explained by WebDude in his post #84.​

(Since HEF limits each post to 4 uploads, this is continued in my next post.)
 

StumpyWally

Senior Member
Joined
Oct 21, 2011
Messages
516
Location
Liv'in the Dream ---------------> in Ballston, NY
Occupation
PE Civil Eng'r, Computer Sys. Mgr., Retired
To Illustrate, here are some sample finds:
1. To find nothing, fill all 9 fields with 0. This will highlight only the “Manufacturer” name rows. This is the “starting state” for the master spreadsheet.
Find Start.png
2. To find more normally, using WebDude’s logic in post #84:
Find Normal.png
3. To find only the same or exact values, set the MIN & MAX fields the same as the SAME field:
Find Same.png
4. To find “all” rows, set the MIN fields to 1, the MAX fields to 999, & the SAME field to virtually any number, say 100. As you scroll down thur all 1,600+ rows, notice 2 things:
a. Not all rows are highlighted. Ones with missing values, either blank or listed as ??, are not included.
find all 1.png
(Since HEF limits each post to 4 uploads, this is continued in my next post.)
 

StumpyWally

Senior Member
Joined
Oct 21, 2011
Messages
516
Location
Liv'in the Dream ---------------> in Ballston, NY
Occupation
PE Civil Eng'r, Computer Sys. Mgr., Retired
b. Some rows are listed twice, usually because one of the parameters can have 2 values. Notice below that the Cat 320 / B Link can have 2 pin centers: 445 or 485. In previous versions of this list such occurrences were usually listed such as “445/485” and took up only one row. I made this listing change to the current version to allow the finds to be more inclusive & work better.
Find all 2.png

As an alternative to doing the “finds” in your downloaded workbook, you could also narrow your search by doing a multi-column sort of the data as suggested by MX727 in his post #92. I suppose you could also filter the data in various columns. Whatever floats your boat & your comfortable with given your spreadsheet skills…

BUT, be aware that the workbook you have downloaded & are doing your finds in is NOT protected in any way from you entering something in the wrong cell, or otherwise screwing it up. In such cases, just do NOT save your file. If you do accidentally save it, just download another copy of the master.

Finally, you can always download the master directly in PDF format for viewing, searching or printing. Be aware when downloading in PDF format (or printing directly from the master), you should always select “Workbook” as the item to download or print. When downloading to spreadsheet format to do your “finds”, the entire workbook is downloading automatically.
Print Workbook.png
 

StumpyWally

Senior Member
Joined
Oct 21, 2011
Messages
516
Location
Liv'in the Dream ---------------> in Ballston, NY
Occupation
PE Civil Eng'r, Computer Sys. Mgr., Retired
After checking over what I did, I made several more format corrections, so here is the newest & latest version of 12/05/2020:
After analyzing the list, I have determined that there are 77 "Unknowns", i.e., rows (machines/buckets) that have no dimensions or otherwise not explicit dimensions. Here is a link to that list of "Unknowns":

So, check your Owners' Manuals and Maintenance Manuals for any of these dimensions for these "Unknowns". If you have or know where any of these "Unknowns" exist, please consider actually measuring them for these dimensions. Please report all results back to me & I will update the master list.

Thanks, stay free of Covid & have a happy Christmas & New Years!
 

673moto

Senior Member
Joined
Dec 5, 2019
Messages
319
Location
NorCal
Occupation
Slacker
Thanks stumpywally for the stellar work compiling this data!
I’m looking thru and don’t see Deere 27,35 d/g ?
Should I assume the hitachi ex35 measurements would work?
I have an oddball gray market machine and looking for a quick coupler...
 

StumpyWally

Senior Member
Joined
Oct 21, 2011
Messages
516
Location
Liv'in the Dream ---------------> in Ballston, NY
Occupation
PE Civil Eng'r, Computer Sys. Mgr., Retired
Thanks stumpywally for the stellar work compiling this data!
I’m looking thru and don’t see Deere 27,35 d/g ?
Should I assume the hitachi ex35 measurements would work?

While I compiled the list, I'm certainly no authority on the dimensions. Although, from what I've learned on this forum, most Deere machines are Hitachi clones, so your approach might not be too bad.

But if I were you I would visit a Deere dealer & actually measure the dimensions on a Deere 27 & 35 before I committed to an order for a coupler.
 

ebaikie

Member
Joined
Jan 27, 2017
Messages
23
Location
BC, Canada
Occupation
Mechanical Engineer
If you want to add another Hanix to the list.
My Hanix S&B300 has the following dimensions:
Pin Diameter 35mm (from service manual)
Width Between Ears 135mm (from service manual)
Pin-to-Pin 165mm (measured)
 

cps

Senior Member
Joined
Jul 13, 2008
Messages
811
Location
Ireland
Occupation
plant mechanic
Thanks stumpywally for the stellar work compiling this data!
I’m looking thru and don’t see Deere 27,35 d/g ?
Should I assume the hitachi ex35 measurements would work?
I have an oddball gray market machine and looking for a quick coupler...
The Hitachi Ex35 data would be a common Hitachi fitment, I.E covers a few machines.
What I would say is that, the ZX26 and ZX33 Hitachi are different, the 26 is 35mm pins, so i would double check both Deere models.
 

673moto

Senior Member
Joined
Dec 5, 2019
Messages
319
Location
NorCal
Occupation
Slacker
Thanks, so far I’ve found the Deere 35d has 40mm pins
 
Top