Chev, can you send me the list in post 19 as an excel file so I can have a play with it as a pivot chart. I think this would be what you are trying to achieve.
For my own preference I like having the excel workbook as separate worksheets so that they (along with the pdf with the model illustration pictures) can serve both as a parts list for various attachments and being able to view both the illustration and the list of parts at the same time by resizing each file on the screen so they are side by side. In this format the workbook can also be searched using the "Control F" command, selecting the "search workbook" option and "find all" to tell me if a part number was used on more than one attachment. If it was then it will show up in various cells in each of the work sheets and a message will state how many cells the part number is in. Then using the "find next" option will advance me through the various sheets stopping each time the part number is found and looking at the bottom tab I can determine at a glance the model that each work sheet pertains to (the worksheet can also be rolled so the top of the worksheet is displayed to also see the model number and a more detailed description of the attachment and also see what series of tractor it was used on). As I have stated once the attachment part numbers are entered into the worksheet format people can manipulate it by easily copying and pasting them to create their own layout preference. What I am trying to achieve is to get the information from the parts pages into this format which is the time consuming and sometimes challenging part depending on the quality / condition of the pdf document. Add to this the documents that have the space in the part numbers that were used at times and also the addition of the dotted lines rather than the grid format that was used in some of the documents in the 80's and it can become a very slow process as they don't copy well so there is a lot of manually correcting / editing of the information that is copied using the text recognition software that I have. My guess would be that this is why LPBolens stopped after he got the tube frame and large frame tractors done and why nobody else has taken on the challenge of adding the attachment parts numbers (could be wrong). This will not be an easy or quick task as there are a lot of Bolens attachments that were used and at some point I may get discouraged and give up but I am stubborn (or stupid) and like a challenge so we will see how it goes. As I have stated the Bolens family has a lot of attachments and the part numbers used are a vast quantity but each journey begins with a first step and since LPBolens started the first step a few years ago I view this as the "grunt" work that will further the journey and the more part numbers that are added the more knowledge we, as a Bolens community, will have about them as some of the early descriptions were not as detailed as the later ones for the same part number.
From what I have learned about pivot tables they might be good for creating a list of part numbers that are used on various attachments and seeing the various models but in that format they would be of little use if someone wanted to view all the part numbers used on a certain model of attachment the way one does when we look at an illustrated parts list - however I could be wrong.
As per your request attached is the file that I used to create the pdf in post 19 - please note it has not been updated with the attachment part numbers that I have added since Feb 10 2020.
Edited by 29 Chev, February 16, 2020 - 08:46 AM.