Hey Folks,
**This project has been in collaboration with Sunil at ABEC357; they've been an excellent partner and have contributed efforts on this project, and beyond (I ask a lot of questions, but always receive the support needed) - I highly recommend these folks (although I understand everyone has their preferences) :fish .
ABEC357 Homepage (https://www.abec357.com/default.asp)
been working on a side project i wanted to share and ideally hand off to continue as a community project (alternatively, i can collect feedback, requests for additions and continue to release updated iterations of the tool.
i ran into some file size issues that i'm still working through but in the interim i wanted to share at least the running list of bearings (with corresponding bearing SKU #; dimensions; corresponding reel part # & corresponding reel model).
Ultimately, this list will be linked to a tool that will allow you to select a reel in question from a dropdown list that will then return a list of all bearings within that reel, along with the corresponding part number, bearing dimension and bearing sku #
bearingtool1.png
example of a reel plugged in:
bt2.png
i've also started compiling reel schematics and corresponding parts lists into a central location for ease of access, and to add some better organization to more easily navigate to specific reel models.
here is an example of the schematics (bearings within the schematics will also be highlighted as a further identifier aid:
schma1.png
*you can either click the tab for the desired reel, or navigate by selecting the reel from the dropdown list in the upper left
here is a snapshot of the full reel schematic array (gives insight into all integrated schematics thus far):
schma2.png
this is still a work in progress but the goal is to tie a few things together in a centralized location for the fellow reel techs out there.
Is this something you're willing to share on Google Drive, whose spreadsheet can be converted to sheets to make it easier to collaborate?
BTW, This looks great! I can tell you put a lot of effort and thought into its creation. Great work.
Quote from: jtwill98 on June 26, 2025, 04:31:32 PMIs this something you're willing to share on Google Drive, whose spreadsheet can be converted to sheets to make it easier to collaborate?
BTW, This looks great! I can tell you put a lot of effort and thought into its creation. Great work.
It is in due time.. (and time is really what I need). For some additional insight however, i started tinkering on this project on a company laptop so i'm running up against restrictions so i'll need to get the file off the work computer firstly and then i'll be able to get it to google. the other hurdle is that i've made some progress and now the excel file is just too large for emails regardless so i'm floating around a few different ideas on how to go about that. Most obviously (and will be last resort) - i'll just chop the file up and reconstruct it but while we're here i might as well explore if there there are other areas of clean up i can perform.
and thank you! i had been thinking on this for a while and am not sure if it's just a business thing to make things harder for folks, or if it's truly just something that has never been a priority, been needed. We have so many reel manufacturers these days and i'd also imagine theres been an increase in reel techs as a result as well. it's due that we have some things centralized, with some tools to help navigate.
Quote from: Mpyeti on June 27, 2025, 01:50:04 PMthe other hurdle is that i've made some progress and now the excel file is just too large for emails
I'm not sure if its possible, but never forget "old technology" USB pen/thumb drives.
One other note for now - the final file will have a hidden worksheet that has a ABEC bearing dimension/size chart ( is probably a tad redundant as Alan Tani has a stickied post with the same thing). Again, goal is to have everything in one spot still).
bearing_size_chart.png
lastly, the bulk of the bearing tool is attached here (has the list of bearings by part #; dimension; reference to reel model #). so it could be used for the interim, just would be a little more manual/might require some additional scrolling/filtering/sorting to drill down on what you're looking for relative to the final product. what is to come is the schematics all housed together, and organized; the other component is the UI for the bearing search tool.
Bearing List.png
the columns with the blue header/top row will list compatible bearing SKUs by grade (if available) from abec5 to abec7
Quote from: jtwill98 on June 26, 2025, 04:31:32 PMIs this something you're willing to share on Google Drive, whose spreadsheet can be converted to sheets to make it easier to collaborate?
BTW, This looks great! I can tell you put a lot of effort and thought into its creation. Great work.
just also wanted to ensure you saw that there was an .xlxs attachment at the bottom of the first post
Good idea on the google drive,
I have an AT google account
Op email
Email
The final file pls.
I will make sure it attaches fine on the board.
Thanks for the work involved.
Would be great if we could access it.
Quote from: Cor on June 28, 2025, 07:35:09 AMThanks for the work involved.
Would be great if we could access it.
The excel file in the first posts is the smaller version, and works fine.
I am working on the google drive, I will give op access so he can upload it to google drive directly and share with us.
Heading to detroit in a few hours, once I get back tonight, I will get the google drive ready.
i am back from vacation myself as of today - will get the file emailed over to Gobi later today.
Thank you looks like an awesome tool!
Hello All,
Apologies for the delay.. work has been busy and have also been trying to fish here and there. I do however have some good news - I was able to review the excel workbook structure and identify data points within the file and their corresponding memory; in short, (I presumed this to be the case) embedded images were the culprit.
Attached is the full Database minus some images of reel schematics removed unfortunately. However, the connections and functionality of the tool are fully operational. I am planning on going back in at some point and re-capturing the removed images and adding them back in with smaller file sizes.
good things take time and at this point i have a lot more data to plug in and we're continually refining the framework.
Thank you all, let me know if you have questions.
Quote from: Gobi King on June 29, 2025, 12:31:47 PMQuote from: Cor on June 28, 2025, 07:35:09 AMThanks for the work involved.
Would be great if we could access it.
The excel file in the first posts is the smaller version, and works fine.
I am working on the google drive, I will give op access so he can upload it to google drive directly and share with us.
Heading to detroit in a few hours, once I get back tonight, I will get the google drive ready.
file is good to go for Google Drive! *i'll call it a work in progress still but wanted to get this in the people's hands for the interim. the images that are still intact within the database only take about 1kb memory where as i had some higher resolution snapshots that were taking almost 1mb - will go back and replace those when i have a chance.
Nice! Where can we access this? Also, let me know if you need help Im pretty good with this type of stuff and image editing as well.
Quote from: SoCal-Reels on July 25, 2025, 02:02:36 AMNice! Where can we access this? Also, let me know if you need help Im pretty good with this type of stuff and image editing as well.
file is linked two posts above yours! :d
Quote from: Mpyeti on July 29, 2025, 03:19:56 PMQuote from: SoCal-Reels on July 25, 2025, 02:02:36 AMNice! Where can we access this? Also, let me know if you need help Im pretty good with this type of stuff and image editing as well.
file is linked two posts above yours! :d
Oh yes I thought there was a google drive file that we can get access to lol. I didnt clarify my fault.
Quote from: SoCal-Reels on July 29, 2025, 03:50:22 PMQuote from: Mpyeti on July 29, 2025, 03:19:56 PMQuote from: SoCal-Reels on July 25, 2025, 02:02:36 AMNice! Where can we access this? Also, let me know if you need help Im pretty good with this type of stuff and image editing as well.
file is linked two posts above yours! :d
Oh yes I thought there was a google drive file that we can get access to lol. I didnt clarify my fault.
I will defer to Gobi on that - he offered first, but i'm sure anyone realistically could handle that step to get it stated. I unfortunately still don't have a true personal computer (only have a company computer currently), so i'm up against some compliance roadblocks that won't ultimately allow me to get it up there. Unless it's possible to host via the phone..
I haven't explored it much as i am a little jaded towards the google apps - recently i accidently synced my photos to the google app and the app clogged my email, i then used the clean space feature and subsequently deleted photos from my phone in the process.
*i was attempting to take advantage of more free cloud storage but it wasn't worth the hassle, and as a head's up for other folks you can turn the sync off to keep the interactions within the google app separate from your iphone
yes, sorry, been bit distracted by bot attacks,
op, I will send you an email with a link.