AutoCAD Inventor :: Using Excel Spreadsheet In Design Accelerator?
Nov 15, 2012
I am working on a gearbox design that requires multiple iterations on the shaft dimensins and other parts, so linking the dimiensinos to a spreadsheet would make this easier. However, I'm using the design accelerator for the shaft and other components and I cannot find any information on how to connect the dimensions I enter in that design accelerator to a speadsheet.
I know how to link to a spreadsheet for a regular component, but haven't used that much.
View 3 Replies
ADVERTISEMENT
Oct 23, 2013
I am using version 2014 and all the tabs under "Design" are greyed out. I am trying to use the "Insert Frame" function.
Note: Windows 64bit. Recently upgrade from 2013.
Similar problem Here: [URL]....
View 7 Replies
View Related
Aug 19, 2013
I am having a problem with the design accelerator in 2014. The tab is there, but I cannot click any of the buttons to actually insert a frame or design some gears. They are all grayed out. The design Accelerator appears to be loaded in the add-ins screen. I am running Win 7 64 bit.
View 4 Replies
View Related
Sep 14, 2013
Design accelerator does not generate sprockets for chain? I would like to know why.
View 7 Replies
View Related
Jan 17, 2013
Roller Chain accelerator give fault value? For example, I have a basic chain setup with 180SP40 and 180SP15 (both are existing sprockets). After choosing the correct chain style from the table and start choosing the existing sprockets (OD of the tooth), tt gave me a fault output and recognize the 180SP40 as a 42 tooth sprocket and 180SP15 as a 17 tooth sprocket
View 1 Replies
View Related
Jul 4, 2013
I'm customizing templates inventor.I need to know how to customize the template using DA for the design of the shafts.
View 1 Replies
View Related
Jun 7, 2013
Is there a way I can add hpt belts to the design accelerator? I'm using inventor 2013 and I want to use 8m belts without having to find the models of each pulley and individually add them.
View 1 Replies
View Related
Nov 8, 2013
I am having a problem while making 2 straight spur gears. The purpose is to connect the crankshaft with the camshaft. Center distance is fixed: 85,5mm. I would like a ratio of 0,5 with 22 and 44 teeth. My gears seem to hit each other. Please find the attached pictures below for a detail and my inputs.
View 3 Replies
View Related
Feb 3, 2013
When I import an Inventor model to Showcase, bolted connections are missing the bolt. I get the washers and nuts but the bolt is gone. I can overcome this by saving the bolt part in a project folder but this is time consuming.
Are there some settings I am missing or is it just another item to add to the fixit list?
View 1 Replies
View Related
Nov 29, 2011
If there is a way to create multiple instances of bolted connections using design accelerator instead of having to add one by one which takes forever ? All the bolted connections are of the same specification.
View 2 Replies
View Related
Sep 28, 2006
Everytime I try to place a #8 machine screw type II screw from the content center I get a Design Accelerator Doctor error saying: "Modeling: Failed to insert a part into assembly!".
But if I place a Type I machine screw it works fine. Also if I replace the Type I screw with the Type II (the one I have a problem with) it replaces it no problem. So basically if I want to place a #8 Type II screw I have to place a Type I and then replace it with the Type II..
View 8 Replies
View Related
Apr 28, 2013
I've got a strange situation regarding the bolted connection generator. For some background, I made another post a while back about editing the hole sizes for Flat Head Cap Screws so that the heads were below flush. That thread is here:
[URL]
Basically, I increased the countersink diameters Clearance.xls and then found that the Design Accelerator doesn't use that spreadsheet for its data source. More research led me to this file:
C:UsersPublicDocumentsAutodeskInventor 2013Design DataDesign AcceleratorTablesHolesAnsi Unified Screw Threads.xml
So I edited the diameters in this file and tested the design accelerator and everything was great. [I kept a backup of the original...]
Since then, another thing that has bothered me was counterbore numbers for socket head cap screws. The Cbore diameters don't match the tools that we have and the depths are always right on size. i.e. for a 1/4" SHCS, the bore is 7/16" diam x 0.250" deep. In reality our cbore tools are about 0.406 and we cut them about 0.265 deep to make sure the head is below flush.
I went in to these two XML files and edited them (and kept backups): Ansi Metric M Profile.xml Ansi Unified Screw Threads.xml
Everything seems to be cool, except for one scenario. When I create a counterbored joint for a metric SHCS, the cbore diameter is always 16.00 mm diameter and too deep, regardless of its size. I searched the XML file and what it's doing *does not* match the data in the XML file. I monkeyed around a little more and could not get the counterbores to come out right.
So at that point, I renamed all the files to restore my original backups to the "factory" ones. I assumed that I screwed up the formatting or something in the data table and I'd just try it again. However, even after I restored my backups and removed my edited files, the metric counterbores are messed up.
What I don't understand is that changing the file "Ansi Unified Screw Threads.xml" *did* update the holes for English screw joints. But does the DA pull data for metric joints from somewhere OTHER than "Ansi Metric M Profile.xml"? And if it does use this XML file, why isn't it working? The original data has been restored, but the behavior is not behaving correctly.
Inventor 2014 64-bit SP1
Win 7 Pro 64-bit SP1
View 4 Replies
View Related
Aug 22, 2013
I have a problem were when , i take a design accelator shaft to .idw and section it the the hatch lines do not appear as they would if it was a shft drawn from scratch.
View 3 Replies
View Related
Sep 17, 2013
is it possible to produce something like in the attached image using the design accelerator? Instead of making a cylinder and sketching the spline patterns and extruding? To me there must be a way besides sketching and use the library's of standard splines patterns and sizes.
Inventor Professional 2014-Update 2 - AutoCAD Electrical 2014
Win7-x64 | ASUS P8Z77-V | i7 3770 -3.4 GHz | 32GB RAM |
240GB SSD | nVidia GTX 670 4GB - 320.49
View 2 Replies
View Related
Jun 7, 2012
Is there a way of using design accelerator to rivet fix as you would with bolted connection ? I know that by initiating the bolted connection command there is no option to use rivet to complete the connection as is done with bolts. It would be great if rivets from the content centre could be somehow imported into the bolted connection component generator (or readily available) to add like bolted connection or if there are any 'workaround's' to produced similar results ?
View 1 Replies
View Related
May 14, 2013
I've got a strange situation regarding the bolted connection generator. For some background, I made another post a while back about editing the hole sizes for Flat Head Cap Screws so that the heads were below flush. That thread is here:
[URL]......
Basically, I increased the countersink diameters Clearance.xls and then found that the Design Accelerator doesn't use that spreadsheet for its data source. More research led me to this file:
C:UsersPublicDocumentsAutodeskInventor 2013Design DataDesign AcceleratorTablesHolesAnsi Unified Screw Threads.xml
So I edited the diameters in this file and tested the design accelerator and everything was great. [I kept a backup of the original...]
Since then, another thing that has bothered me was counter bore numbers for socket head cap screws. The Cbore diameters don't match the tools that we have and the depths are always right on size. i.e. for a 1/4" SHCS, the bore is 7/16" diam x 0.250" deep. In reality our cbore tools are about 0.406 and we cut them about 0.265 deep to make sure the head is below flush.
No big deal, right? I went in to these two XML files and edited them (and kept backups):
Ansi Metric M Profile.xml
Ansi Unified Screw Threads.xml
The problem ==========>
Everything seems to be cool, except for one scenario. When I create a counter bored joint for a metric SHCS, the cbore diameter is always 16.00 mm diameter and too deep, regardless of its size. I searched the XML file and what it's doing *does not* match the data in the XML file. I monkeyed around a little more and could not get the counterbores to come out right.
So at that point, I renamed all the files to restore my original backups to the "factory" ones. I assumed that I screwed up the formatting or something in the data table and I'd just try it again. However, even after I restored my backups and removed my edited files, the metric counterbores are messed up.
What I don't understand is that changing the file "Ansi Unified Screw Threads.xml" *did* update the holes for English screw joints. But does the DA pull data for metric joints from somewhere OTHER than "Ansi Metric M Profile.xml"? And if it does use this XML file, why isn't it working? The original data has been restored, but the behavior is not behaving correctly.
View 9 Replies
View Related
Nov 13, 2011
I am creating a couple of spur gears using the "Center Distance" design guide. I have fixed each gear to a cylindrical face, but when I click on the "Calculate" button, there is an error saying that the center distance is incorrect.
I went back and edited my sketches so the center distance matched the one displayed in the design accelerator and attempted to calculate again, but the error persists. What am I not getting here?
View 9 Replies
View Related
Feb 15, 2012
Trying to figure out the best method to insert an IDW into an Excel spreadsheet without sacrificing quality. I have tried several methods to go straight from Inventor(2012) to Excel(2010) using print PDF at press quality, export JPEG, and even the snipping tool as a last ditch effort all of which inevitably loose all line quality when inserted to Excel.
I have only had success bringing a PDF from Inventor into Adobe InDesign where I am able to mimic the design of my Excel spreadsheet and create an additional PDF to include with the Excel document. It seems like there would be an easier way for Inventor and Excel to work together without sacrificing quality or adding additional steps.
View 1 Replies
View Related
Nov 21, 2012
I am trying to export some data from my BOM. I require the part names, quantities and lengths. I have followed a previous topic in these discussions which is now closed. it seems simple to follow but requires me to click on the export BOM icon in the top left of the browser. In my instance this is greyed out. D
View 4 Replies
View Related
Apr 17, 2013
Im struggeling with creating a code that opens a certain Excel spreadsheet and retrieves / inserts info.
the spreadsheet is a list containing part numbers for purchased components, therefore the list must be filled with information from iproperty. But it has to be where the next available number is. i had this working in iLogic, but have to move it to VBA for better use. the code that worked in iLogic is this one.:
[URL]
If possible it would be nice if the code at the same time retrieves the new partnumber and saves the active part as this part numeber...
View 4 Replies
View Related
Sep 13, 2013
Is there a way of inserting points from an excel spreadsheet that come into the part file already fixed, instead of manually selecting the points and selecting the fix constraint?
View 2 Replies
View Related
Jul 26, 2012
My "parameter names" and "value" columns fill in under the Inventor Parameter chart, but for some reason I can't get the comment section to fill in.
Inventor 2011
07 Excel
Inventor 2011
Intel Core 2 Duo 2.93GHz
8GB RAM
Windows 7 Pro
View 1 Replies
View Related
May 12, 2012
I created a spreadsheet of about 40 rows to be used to create different parts. I then created a part "we'll call it Board_A". I linked to the spreadsheet and used 3 of the fields for my dimensions. Lets say I named the length (which was the extrusion number) as "Len_1". I saved it and all is well!! I then created other parts and used the spreadsheet for the dims. I then went back and opened "Board_A" and saved a copy as "Board_B". I closed Board_A and opened Board_B. I then rt clicked on "Extrusion" so I could change the length from "Len_1" to "Len_1_A" which is another row (field) on that same spreadsheet which is still linked. When I tried I received a message that said I couldn't do that (I forgot the actual message!) I clicked the Parameter icon and the only fields showing on the popup spreadsheet box were the ones I had previously used for those parts that I made from scratch. I thought I figured this out once but if I did I forgot. I deleted the spreadsheet link and then re-added it but nothing I have tried has worked. Is there a way to get these fields to be usable with a Copy of an existing part or do I just have to start from scratch and make the similar part?
View 1 Replies
View Related
Sep 20, 2013
For Creating my own templates i want to use iLogic and embedded Excel-Spreadsheets. The embedded Sheet has its own data, but i want to create a rule to refresh the data from an external Excelsheet.
For now i use the following rule:
For I = 65 To 90 '65=A 90=ZBuchstabe = Chr(I) GoExcel.CellValues("3rd Party:Embedding 1", "Platte", Buchstabe & "1", Buchstabe & "999") = GoExcel.CellValues("G:KonstruktionVorlagenMaterialgrunddaten.xlsx", "Platte", Buchstabe & "1", Buchstabe & "A999")Next I
it works well, but wont insert a new single-sheet or refresh formats, i have to add the same code for each sheet. And its REALLY slow.
Is there a possibility to refresh or replace the whole embedded file via a simple iLogic-rule?
View 1 Replies
View Related
Apr 30, 2013
I have some code (below) that will open my embedded excel spread sheet and it works great. Now I need the code to save and close the excel file after it’s been open.The embedded excel spreadsheet pushes some stuff the model and does a couple other thing. So all I really need is for the excel file to open, save, and close when the rule is run.Imports Inventor.
OLEDocumentTypeEnumExcelApp = CreateObject("Excel.Application")Dim ExcelFile As ReferencedOLEFileDescriptorExcelFile
=hisDoc.Document.ReferencedOLEFileDescriptors.Item(1)ExcelFile.Activate(kEditOpenOLEVerb, ExcelApp)
View 4 Replies
View Related
Aug 7, 2013
I have a problem with using the excel spreadsheet to hold my parameters and then making them auto update in the model.
I have the excel 2003 spreadsheet saved in the same folder in the projects directory as the model. When I create the spreadsheet and enter the parameters and values etc I save and close the file.
When I am in inventor 2013 64 bit with SP1 installed, I open the model and can link the spreadsheet to the model and the model reflects the values in the spreadsheet. I also click update on the parameters dialog box.
I then open the spreadsheet and make some changes to the values, save the file and even go to the extreme of closing the file. When I go back into Inventor it recognises there has been some changes in the underlying spreadsheet. The update button is active in the tool bar. However trying to update the models by what ever means does not update the model parameters to those in the spreadsheet. Even closing the model and reopening it does not make a difference.
The only way I can get this to work is disconnecting the file and then reconnecting the file through the links option in the parameters dialog box. Then the model reflects the correct values and updates the model accordingly.
My concern is there is quite a bit of stuff on the net about 2013 not working with 2014 inventor anyway.
View 3 Replies
View Related
Apr 9, 2012
I have a set of sheet metal parts modeled in inventor that are produced in a wide range of sizes and several different sheet metal types.
The dimensions (length, width, flange size, etc) are driven from a spreadsheet. I would like to be able to have the user update the K Factor from the same spreadsheet by selecting a sheet metal type.
The sheet metal type and K factor are not listed in the parameters list with the other model dimensional data, so I'm not sure how to proceed.
View 1 Replies
View Related
Feb 25, 2013
I am trying to link an excel spreadsheet to my acad but I can't see it once i've linked to it?
View 2 Replies
View Related
Jul 24, 2012
Got a new computer, put AutoCAD LT 2010 on the machine, justlike the rest of the office, but also installed excel 2010, when the rest ofthe office has 2007. when insertinglinked spreadsheets from the new computer, and we update the links on our oldcomputers, Acad fatal errors out. Thisis because of the difference in the excel versions correct?
View 1 Replies
View Related
Dec 3, 2013
How do i create a spreadsheet for title blocks. i want to be able to fill in a spreadsheet and automatically fill in the title block....
View 1 Replies
View Related
Apr 3, 2013
I'm trying to link a text from Autocad to an excel spreadsheet so that when changed in Excel, be changed in autocad.
After searching on some forums, I started doing database through ODBC.
I made a table in excel selecting and naming fields, added the file in windows OBDC manager, able to make the connection through dbConnect autocad, created label ...
Now I need to put the information in the database autocad text entity and already there I'm not getting more done
View 1 Replies
View Related
