How to add a thread to the chart

[Karol-Or]

I need to make a thread of 8 D.P.I on a diameter of 104.8 mm.

It's not a standard thread size.

Where is the excel file with the ANSI threads?

[blair · Accepted solution]

If you installed to the default location, it should be as show:

C:\Users\Public\Documents\Autodesk\Inventor 2014\Design Data\XLS\en-US

You may need to change the "Inventor" directory to your version of software.

Always make a backup copy of the Thread.xls file before modifying.

[Paul-Mason · Accepted solution]

That a 4 inch thread

Some of us have added threads to our spreadsheet it my be that you need to add ANSI UNIFIED THREAD the size and TPI is on row 710, I've checked.

I have attached the xls file so all you need to do is to copy the file to the location of you default tread.xls file.

One question why are you working in metric with imperial threads

Your giving your self a lot of extra work and a major headache when it comes to dimensioning you end drawing/s

[Karol-Or]

You didn't attach

[Paul-Mason]

Um look like it got stripped off so I putt it here https://skydrive.live.com/embed?cid=30A7361EF9C3AE77&resid=30A7361EF9C3AE77%21522&authkey=AEM2lE5SOE...

[JDMather]

---

@Paul-Mason wrote:

That a 4 inch thread

 ...

---

4 1/8

[Karol-Or]

I added the last line, no' 719, in the ANSI unified, but Inventor says it's wrong.

True, our plant only writes the outer diameter for the thread, and the innner and outer diameters of the nut, and only one tolerance-for the inner diameter of the nut, so, i deduced from the other threads and approximated the rest of the diameters and tolerances.

Also, i don't know what the designations, for example, 4-16 UN, mean, i mean what is the UN suffix for, so, i added this to my line.

Are these the reasons?

[JDMather]

---

@Karol-Or wrote:
 i don't know what the designations, for example, 4-16 UN, mean, i mean what is the UN suffix for, so, i added this to my line.

Are these the reasons?

---

UN stands for Unified National (standard)
UNC Unified National Coarse

UNF Unified National Fine

UNS Unified National Special

None of these are really needed as the diameter and pitch are given 4-16 means Ø4 with 16 threads per inch.

Be careful in that you metric diameter was actually 4 1/8, not 4. 

Check your Machinery's Handbook or online thread specifications for inch thread designations.

[Karol-Or]

Thanks, i didn't intend to ask that, i wanted to edit the post but forgot.
Why isn't the thread good for Inventor?
Is it because of the wrong numbers that i have written in the chart?
If so, i have to know, exactly, how to derive all dimensions, but before i do that, which takes time, i have to know what is the reason

[JDMather]

Is it giving you an error because of line 719, or is it giving you an error because of line 683?

[Karol-Or]

719, line 683 i started to try in another place.
Line 719 was the first, from last week

[JDMather]

I don't think you can have any mistakes.

I haven't experimented - but I think it stops as soon as a mistake (or open cell) is encountered.

Post screen shot of the error you are getting.