The Elsmar Cove Wiki More Free Files The Elsmar Cove Forums Discussion Thread Index Post Attachments Listing Failure Modes Services and Solutions to Problems Elsmar cove Forums Main Page Elsmar Cove Home Page
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools
Forum Username


Search the Elsmar Cove
Custom Search
Monitor the Elsmar Forum
Follow Marc & Elsmar
Elsmar Cove Forum RSS Feed  Marc Smith's Google+ Page  Marc Smith's Linked In Page   Marc Smith's Elsmar Cove YouTube Page  Marc Smith's Facebook Page  Elsmar Cove Twitter Feed
Elsmar Cove Groups
Elsmar Cove Google+ Group  Elsmar Cove LinkedIn Group  Elsmar Cove Facebook Group
Sponsor Links





Donate and $ Contributor Forum Access

Click the graphic above.
Courtesy Quick Links

Links that Elsmar Cove visitors will find useful in your quest for knowledge:

Howard's
International Quality Services
Marcelo Antunes'
SQR Consulting
Bob Doering's
Correct SPC - Precision Machining

NIST's Engineering Statistics Handbook
IRCA - International Register of Certified Auditors
SAE - Society of Automotive Engineers
Quality Digest Portal
IEST - Institute of Environmental Sciences and Technology
ASQ - American Society for Quality

Related Topic Tags
font, free, gd&t (geometric dimensioning & tolerancing), microsoft word .doc file, microsoft excel .xls .xlsx spreadsheet
Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 4 votes, 5.00 average. Display Modes
  #41  
Old 8th January 2010, 06:12 PM
mikih mikih is offline
Inactive Registered Visitor

 
Registration Date: Jan 2007
Location: NA
 
Posts: 2
Thanks Given to Others: 1
Thanked 4 Times in 2 Posts
Karma Power: 31
Karma: 30
mikih has less than 100 Karma points so far.
Re: Free GD&T font for Word and Excel

Hi

Give FreeGDT a try.

Its a font I've created along with a tool to create the tolerance calls. It also includes some drawing symbols. You can create tolerance calls either with or without control frames. Even better it free.

The forum will not let me post a link directly but go to ***DEAD LINK REMOVED***

Thanks
Mick

Last edited by Marc; 26th October 2013 at 06:07 PM. Reason: Dead link removed
Thank You to mikih for your informative Post and/or Attachment!

Sponsored Links
  #42  
Old 8th January 2010, 07:08 PM
JaneB's Avatar
JaneB JaneB is offline
Consultant / Auditor

 
Registration Date: Feb 2006
Location: Melbourne, Australia
 
Posts: 3,513
Thanks Given to Others: 1,399
Thanked 1,773 Times in 1,155 Posts
Karma Power: 409
Karma: 11872
JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.
JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.JaneB is appreciated, and has over 1700 Karma points.
Re: Free GD&T font for Word and Excel

Quote:
In Reply to Parent Post by mikih View Post

The forum will not let me post a link directly
There are restrictions on posting links for new users only - once you have posted 5 times, it will.
The restrictoins is to stop spammers and unscrupulous people from appearing once, and only to flog their own products/self-promotion.

__________________

For most of history, Anonymous was a woman. - Virginia Woolf
Thanks to JaneB for your informative Post and/or Attachment!
Sponsored Links

  #43  
Old 12th January 2010, 03:04 PM
ClaudS ClaudS is offline
Inactive Registered Visitor

 
Registration Date: Jan 2010
Location: USA
 
Posts: 1
Thanks Given to Others: 1
Thanked 0 Times in 0 Posts
Karma Power: 19
Karma: 10
ClaudS has less than 100 Karma points so far.
Please Help! Re: Free GD&T font for Word and Excel

I am creating a Dimensional Inspection Report using Excel.
I have downloaded the file to my Document folder.
I need to create a Tool Bar in Excel so that I can use the symbols in my report.
Can someone give step by step instructions on how to do this.
Thanks
  #44  
Old 13th January 2010, 11:09 AM
Jim Wynne's Avatar
Jim Wynne Jim Wynne is offline
Cross Forum Moderator

 
Registration Date: Jan 2005
Location: Southeast Wisconsin
 
Posts: 14,068
Thanks Given to Others: 2,050
Thanked 5,977 Times in 3,811 Posts
Blog Entries: 2
Karma Power: 1529
Karma: 42422
Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.
Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.Jim Wynne is appreciated, and has over 1700 Karma points.
Re: Free GD&T font for Word and Excel

Welcome to the Cove.

I'm not sure which of several files in this thread you downloaded, but since they're all fonts it probably doesn't matter. Before you do anything, you have to install the font. These instructions are based on Windows XP; I think it's probably the same in whatever version you're using, though:
  1. Navigate to C:\Windows\Fonts. If your system drive is something other than C:, change the "C" accordingly.
  2. Click on "File" at the top of the page, and then "Install New Font..."
  3. In the dialog box, find the font file. You said you saved it in My Documents, so it would be C:\Documents and Settings\username\My Documents, where username is your Windows user name.
  4. Click "OK" and the font will be installed. You might need to reboot in order for your programs to be able to "see" the new font.
As far as using some form of toolbar in Excel, I don't think it's possible. Using any symbol font is a bit clumsy. I don't have access to Excel at the moment, but if I recall correctly there is no Insert>>Symbol facility as there is in Word. You might be stuck with using Windows Character Map, which is accessed by: Start>>All Programs>>Accessories>>System Tools>>Character Map. When you open Character Map, look for he GD&T font in the list, and you'll see something like:



From there, it's a rather tedious process of copying and pasting the desired characters into your document. Select the character you want, click "Select" and then "Copy." The character will be copied to the clipboard from whence it may be pasted into the document. Repeat until you've built the feature control frame you want. The attachment shows what a completed feature control frame looks like.

If anyone here knows of a simpler method, by all means chime in.
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: pdf GDT.pdf (9.7 KB, 260 views)

__________________

It is difficult to get a man to understand something, when his salary depends upon his not understanding it. --Upton Sinclair
Thanks to Jim Wynne for your informative Post and/or Attachment!
  #45  
Old 14th January 2010, 06:31 PM
mikih mikih is offline
Inactive Registered Visitor

 
Registration Date: Jan 2007
Location: NA
 
Posts: 2
Thanks Given to Others: 1
Thanked 4 Times in 2 Posts
Karma Power: 31
Karma: 30
mikih has less than 100 Karma points so far.
Re: Free GD&T font for Word and Excel

Quote:
In Reply to Parent Post by ClaudS View Post

I am creating a Dimensional Inspection Report using Excel.
I have downloaded the file to my Document folder.
I need to create a Tool Bar in Excel so that I can use the symbols in my report.
Can someone give step by step instructions on how to do this.
Thanks
Hi thankyou for the thanks on my post . There is a Getting started document available from the website.

I've attached a copy of it here along with the font (if it lets me upload them)

FREE_GDT_EN.zip
Getting Started.pdf
Thank You to mikih for your informative Post and/or Attachment!
  #46  
Old 20th January 2010, 04:28 PM
Micronus Micronus is offline
Involved in Discussions

 
Registration Date: Mar 2005
Location: Ontario Canada
 
Posts: 16
Thanks Given to Others: 0
Thanked 16 Times in 8 Posts
Karma Power: 40
Karma: 72
Micronus has less than 100 Karma points so far.
Re: Free GD&T font for Word and Excel

Quote:
In Reply to Parent Post by JaxQC View Post

Thanks Sorin, the Y14 font is the that Ive ended up using for now. The problem is that most of the ones out there appear to have been made with a specific customer in mind. This one is lacking a couple items that my commodity uses.




Lacking symbols for
  • Surface finish / texture (elongated square root symbol)
  • Co-sink (v)
  • Depth (horizontal line with down arrow) This one had it but others I looked at do not.
  • Machined surface (closed checkmark)
  • Between designation (double end arrow)
  • CenterLine / symmetrical @ cntr line (capital C overlaid on capital L)
  • JIS type texture callouts (upside down triangles, 1 thru 4)
  • The ability to properly show Stacked GD&T criteria
Itll do for the time being and if nothing else to show the IT guys that this kind of stuff is indeed already out there rather than having to re-invent the wheel.
I am currently creating the new ASME Y14.5-2009 version of this font. Along with the 2009 updates, it will include upper / lower case with the addition of surface finish (JIS and US), some welding and some other metrology related symbols plus composite and stacked feature control frames. Again it will be free public domain for both commercial and personal use. Unfortunately, it will not be backwards compatible with the Y14.4M font.

Please post requests for any other symbols that you would like included and I will endeavor to add them before releasing the completed font

Once the font is complete, I will post it here and on http://www.fontspace.com with instructions. The Y14.5M-1994 version of the font is here for anyone who wants it: http://www.fontspace.com/micronus/y145m

Micronus
-OO-
Thanks to Micronus for your informative Post and/or Attachment!
  #47  
Old 15th February 2010, 09:47 PM
Micronus Micronus is offline
Involved in Discussions

 
Registration Date: Mar 2005
Location: Ontario Canada
 
Posts: 16
Thanks Given to Others: 0
Thanked 16 Times in 8 Posts
Karma Power: 40
Karma: 72
Micronus has less than 100 Karma points so far.
Re: Free GD&T font for Word and Excel

The font and a control program for creating composite and stacked feature control frames:

is attached in this post as well.

As usual the attached fonts and control program are Public Domain and copying and redistribution is encouraged.

-OO-
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
File Type: pdf FontTable.pdf (83.6 KB, 222 views)
File Type: zip Y14.5M-2009-Font.zip (427.2 KB, 300 views)

Last edited by Marc; 26th October 2013 at 06:44 PM. Reason: Dead link removed.
Thank You to Micronus for your informative Post and/or Attachment!
  #48  
Old 7th May 2010, 12:55 AM
paliach paliach is offline
Shy Poster (1 to 5 Posts)

 
Registration Date: Mar 2010
 
Posts: 1
Thanks Given to Others: 0
Thanked 0 Times in 0 Posts
Karma Power: 18
Karma: 10
paliach has less than 100 Karma points so far.
Re: Free GD&T font for Word and Excel

just a heads up, i know this is an old thread, but the "FCF Generator" does not spit out the diametric symbols correctly if you click the check box in the Feature Control Frames tab.... anyone have a newer version that fixes this glitch? thanks!


Diameter symbol does not show up
Reply

Lower Navigation Bar
Go Back   The Elsmar Cove Forum > Common Quality Assurance Processes and Tools > Quality Tools, Improvement and Analysis > Quality Assurance and Compliance Software Tools / Solutions > Excel .xls Spreadsheet Templates and Tools

Do you find this discussion thread helpful and informational?


Bookmarks


Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Forum Search
Display Modes Rate Thread Content
Rate Thread Content:

Forum Posting Settings
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 Off


Similar Discussion Threads
Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote
Can the same form number be in Word and Excel for ISIR's and such? Mark Paul Documentation Control Systems, Procedures, Forms and Templates 9 8th August 2011 03:43 PM
AS9016 - Notice of Change template in either Word or Excel rickpaul01 AS9100, Nadcap and related Aerospace Standards and Requirements 2 1st April 2010 10:58 PM
What the heck is Universal 57 font? MS Word asks for the font Universal 57 fortyfour73 Computer, Cell Phone and Internet News and Discussions 7 26th July 2006 05:23 PM
Hyperlinks in Microsoft Excel and Word - Linking Documents dbulak Excel .xls Spreadsheet Templates and Tools 12 18th May 2004 05:51 AM



The time now is 08:22 PM. All times are GMT -4.
Your time zone can be changed in your UserCP --> Options.


   


Marc Timothy Smith - Elsmar.com
8466 LeSourdsville-West Chester Road, Olde West Chester, Ohio 45069-1929
513 341-6272