Pro/Engineer and MS Excel...

[ksboo79]

i'm thinking of controlling my proe model using ms excel... i remembered that i've seen it tutorial or demo somewhere but i don't know where to find it... searched the knowledge base, but to no avail...


is there any one know how to do it? or does it only work with pro/layout? (as this is the most relevatnt topic i can search out in knowledge base)...


any input will be greatly appreciated...


rgds... ksboo

 

[jbuckl]

Nitro-cell does this, (tail, dog& wag comes to mind)but its better to get Pro-E to drive excel (output graphs etc)


Jbuckl

 

[parin_shah]

I am facing the same problem for link with Excel. I need to control design parameters that should be link with Excel. i have seen Nitro-cell. You can view it from www.simplyfiedlogic.com.


Do anyone have other source?





parin

 

[csusie]

Here is a way to do it. I dont think its the best way but one none the less.


Output your input variables from excel to a text file in a format like:


Param1 value
Param2 value
Param3 value


Then write a pro-program for your part or assembly and include those parameters in your input statement. Then use relations to drive the geometry.


There is not direct link to the excel data but it uses it none the less. Everytime you want it updated just save out your param text file then read in inputs using that text file

 

[conrat]

TO make this easier, you will want to add inputs to your main assembly,
then use execute to push the params down to the parts and sub-assy that
need those parameters. You will need to add inputs to any of
these parts that need to access these parameters.



Note, you may also link values from one part to another by referencing
the session id of the main assembly. For instance, if the param
MY_PARAM exists in your main assy, you can write a relation in the part
or sub-assy such as MY_PARAM = MY_PARAM:1, the :! being the session ID
of the main assy. This will allow you to propogate values to
parts without all of the INPUT section maintenance.



Be sure to look in the user guide under the Pro/Program and
Pro/Relation sections. This will provide a much more in depth
look at how to do this.



Jim

 

[TTCorona]

Does any one know a cost per seat for Nitro Cell... there seems to be no avaliable information on the price of the software..


I'd like to know how much it would cost so i know whether to bother evaluating it or not...


i.e is it $500 or $10000... makes a big difference

 

[conrat]

It appears to be a very nice program. I used a demo, but my
company did not purchase the software. The ironic thing is I am
now working on a spreadsheet to control the input parameters, but am
manually copying and pasting the data into a text file instead of
"pushing" it into the software with Nitro-Cell.



I can't remember the exact cost, but I think it was somewhere around 4
grand or so with a 10% maintenance fee per year. Note, you don't
actually buy it. You kind of subscribe to it as a service.



Very nice people and very eager to help. Give 'em a call. They are great guys.



Jim

 

[jannolesen]

For contolling parts and assemblies with excel ckeck out http://www.profilesmagazine.com/p22/tips_muirhead.html


Works nicely for simple parts and asms

 

[prohammy]

For contolling parts and assemblies with excel ckeck out http://www.profilesmagazine.com/p22/tips_muirhead.html


Works nicely for simple parts and asms

Nice one jannolesen, can see many uses for that technique

Kev

 

[mediumsliced]

Sorry for bumping an old thread. Was just looking for a solution to a query asked by a friend. First place I went to was here, and I found my answer! Nice!

Pity I can't say the same for PTC tech support.

Edited by: mediumsliced

 

[Asho Pulsar]

hi all,


http://www.profilesmagazine.com/p22/tips_muirhead.html


Using above link i tried once. But while applying the Pro-program in ProE i am getting something shown belowafter that i cant proceed further.





After this question nothing is proceeding further.
Edited by: Asho Pulsar

 

[msiva1981]

[No message]

 

[anand_m_s]

What is this Siva? "Emperor's new post" ?

Edited by: anand_m_s