Bushing/Tube database What do U use it for? - International Association of Penturners
     International Association of Penturners
Pens for Service Members
 
Support The IAP

Go Back   International Association of Penturners > Community Forums > Casual Conversation
  Forgot Password
Register FAQ Members List Search Today's Posts Mark Forums Read
Casual Conversation Off-topic, general chat.


Logged on members can hide ads!

Welcome to penturners.org!

You've found the home of The International Association of Penturners. You are currently viewing our site as a guest, which gives you limited access to view discussions, photos, and library articles.

Consider joining our community today. You'll have full access to all of our content, be able to enter our contests, find local chapters near you, and post your questions and share your experience with our members all over the world.

Membership is completely free!!

If you have any problems with the registration process or your account login, please contact us.

Reply
 
LinkBack Thread Tools Display Modes
Old 11-12-2017, 11:54 AM   #1 (permalink)
 
Join Date: Aug 2013
Location: Rochester, Mass
Posts: 258
Photos: 8

Default Bushing/Tube database What do U use it for?

I have converted the bushing and tube pdf into an Excel file in the hopes of being able to do something that can be accessed by non-apple users.
I would like to know what most users of this data use it for?
Do you try to cross reference bushings you currently have for new pen kits you have purchased?
Do you lookup the pen kit to see what the dimensions of the bushings are and then cross reference to your current inventory?

Need this info to be able to build useful search functions.
Mortalis is offline   Reply With Quote Top
Old 11-12-2017, 12:02 PM   #2 (permalink)
 
MRDucks2's Avatar
 
Join Date: Jul 2017
Location: Franklin, IN
Posts: 283
Photos: 0

Default

I use it see which bushing are for which kit, see dimensions for a pen.
I would like to use it to see which kits use the same bushings but havenít.


Sent from my iPhone using Penturners.org mobile app
__________________
Think deeply, Speak gently
Love much, Laugh alot
Work hard, Give freely
Be kind &
Leave The Rest to God
MRDucks2 is offline   Reply With Quote Top
Old 11-12-2017, 12:13 PM   #3 (permalink)
 
TurtleTom's Avatar
 
Join Date: Jul 2015
Location: Checotah, Oklahoma 74426
Posts: 657
Photos: 0

Default

Sometimes I acquire pen kits in a trade they I never intend to buy again. I may not have or want to buy bushings for the kit so I use 7 mm bushings or turn between centers and turn the blanks to size using a micrometer or caliper. It's hard to do if you don't know the dimensions of the finished pen. The really good ones print the dimensions in the online instructions, but don't expect it.
Another reason is if your bushings get separated from the container you keep it in it's nice to have a database to look up the O.D.'s and find it quickly.
There seems to be an agreement between pen manufacturers to never design a pen that will use their competition's bushings; or heck, even their own.
__________________
Common sense is a most uncommon thing. Twain

Last edited by TurtleTom; 11-12-2017 at 12:20 PM.
TurtleTom is offline   Reply With Quote Top
Advertisement
Old 11-12-2017, 12:35 PM   #4 (permalink)
 
magpens's Avatar
 
Join Date: Feb 2011
Location: Coquitlam, BC, Canada
Photos: 41

Default

I use it mainly to check and compare tube diameters and lengths.
__________________
Mal



Likes: (1)
magpens is online now   Reply With Quote Top
Old 11-12-2017, 02:29 PM   #5 (permalink)
 
Join Date: Aug 2013
Location: Rochester, Mass
Posts: 258
Photos: 8

Default Searchable Tube and bushing matrix

I have a working searchable Excel sheet. This is something that you can choose from a list of dropdowns in filters. This is not the final version but is usable. Does require Excel for the time being.
Attached Files
File Type: xlsx 20_bush_tubeV1.xlsx (1.09 MB, 22 views)
Mortalis is offline   Reply With Quote Top
Old 11-12-2017, 03:08 PM   #6 (permalink)
 
TurtleTom's Avatar
 
Join Date: Jul 2015
Location: Checotah, Oklahoma 74426
Posts: 657
Photos: 0

Default

Quote:
Originally Posted by Mortalis View Post
I have a working searchable Excel sheet. This is something that you can choose from a list of dropdowns in filters. This is not the final version but is usable. Does require Excel for the time being.
I just opened it with the free Open Office Calc program. Retract that, Calc can't get the data.
__________________
Common sense is a most uncommon thing. Twain

Last edited by TurtleTom; 11-12-2017 at 03:10 PM.
TurtleTom is offline   Reply With Quote Top
Old 11-12-2017, 03:16 PM   #7 (permalink)
 
Join Date: Aug 2013
Location: Rochester, Mass
Posts: 258
Photos: 8

Default

I will download the open office and see what is going on.

Probably has something to do with how Open Office interprets pivot tables. I will look into it.

Last edited by Mortalis; 11-12-2017 at 03:24 PM.
Mortalis is offline   Reply With Quote Top
Old 11-12-2017, 07:04 PM   #8 (permalink)
 
Join Date: Aug 2013
Location: Rochester, Mass
Posts: 258
Photos: 8

Default

Looked into it a bit and Open Office doesnt do Pivot table the same way as Excel. I've tried many different avenues but cannot get OO to gather the data correctly.

I will need to keep working at the database to get it into a common language
Mortalis is offline   Reply With Quote Top
Old 11-14-2017, 07:31 PM   #9 (permalink)
 
Join Date: May 2017
Location: Cross Plains, Texas
Posts: 31
Photos: 0

Default

I just tried to open the file. When I clicked on your attachment it downloaded as 20_bush_tubeV1.
xlsx.html. When I tried to open the download it was just garbage. I opened Excel and tried to open the file, never happened.

Last edited by Oldfolks; 11-14-2017 at 07:33 PM. Reason: correct _ to .
Oldfolks is offline   Reply With Quote Top
Old 11-14-2017, 07:36 PM   #10 (permalink)
 
Join Date: May 2017
Location: Cross Plains, Texas
Posts: 31
Photos: 0

Default

Just went into the documents folder and edited the file name by dropping the HTML. The file will now open in Excel.
Oldfolks is offline   Reply With Quote Top
Related Content
Logged on members can hide ads
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On


All times are GMT -5. The time now is 08:29 PM.

Powered by vBulletin® Version 3.7.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.6.0

Content Copyright © 2003-2016 by Penturners.org, LLC; All Rights Reserved
Terms Of Service   Acceptable Use Policy