michele81
Guest
sw always reads the first sheet on the left (or at least in 2009 it was so). You could create two files connected to each other and stacked so that sw read them correctly, but it seems a bit complicated solution. . .
narx
Guest
thank you, you are right, but I have to manage everything with macros (control buttons on a third sheet) I would further conceal things...at least for my programming level
. .
. .geppetto
Guest
I didn't try, but giving unique names to share/values and together, you should be able to create a single sheet that manages both the side file and the axieme. I am also of the opinion that it is appropriate to create a file for each part and/or together. I don't know your needs but... it would seem slightly messed up as a solution. if you have so pushed needs maybe the driveworks product could do to your case.
narx
Guest
Is driveworks? ...fuck I did a couple of times the wizard configuration and I didn't understand a bat!...I explain my problem.I have to distribute along an axis of objects (type spiral scale), the axis will have coincidental relationship and the movements should insert them through data table
-configuration of part inserted(indicated with the arrow)
1st distance from origin to point1 (ground distance to first "grade")
2nd angle of rotation from origin to point1 (angularity compared to axis 0)
Do you recommend anything "practical"?
I hope I've been clear. thank you very much
-configuration of part inserted(indicated with the arrow)
1st distance from origin to point1 (ground distance to first "grade")
2nd angle of rotation from origin to point1 (angularity compared to axis 0)
Do you recommend anything "practical"?
I hope I've been clear. thank you very much
Attachments
reggio
Guest
hi, maybe I didn't understand how you structured the links between your tables and excel files, in the past I had created a file for each part, then each table "refer" and "weigh" all the data to/from the "assieme" file that in practice allowed me to keep all the parameters and values in a single sheet and let it perform the specific calculations to the sheets of each part. . .thank you, you are right, but I have to manage everything with macros (control buttons on a third sheet) I would further conceal things...at least for my programming level
Then everything got stuck when I put everything on the net... swx is unable to manage files on mapped disks (see http://www.cad3d.it/forum1/showthread.php?t=13943 and spr "software performance report" code: 516396)
. and it is from July 2009 that I wait that dassalt puts us a piece
but for now nothing... 
So also verify the network's speech because I assure you that there is nothing more frustrating than preparing a nice castle of ideas and then seeing them collapse. . If you find the same network problem, can you report it to your var? (to me they report that dassalt so far has not looked at it because it has few demands in this sense... )
It would really help me.
marcof
Guest
unfortunately you cannot with a single table pilot the odds of the internal features to the parts, and it would be really convenient.
I have not understood how much your data table will have to be processed, but to pilot together those plates, if only it is to define number, step, angle of revolution etc., I would insert in the axieme a part to use as a layout (to be kept hidden and excluded from the distinct materials etc.) constituted by a cylinder on which to create the helicoid with the parameters that serve. I would then make a reference feature consisting of simple hole or extrusion and make a repetition with the repetition function along the curve thus obtaining references for the placement of your platelets.
from the axieme I would pair the first plate on the first reference feature (hole, extrusion or whatever) and then I would insert all the others by repeating the feature-driven component, or guided by the reference feature on the cylinder.
In this way you can with a single data table, inside the layout part, drive all parameters of the repetition of the plaques while from the main axieme you can pilot the cavities configurations of the plaques.
Hi.
reggio
Guest
.... I meant something similar to the annex:
open all excel files
change values only together
close and save everything
open the assist and update if required
open all excel files
change values only together
close and save everything
open the assist and update if required
reggio
Guest
I had lost the annexnarx
Guest
we are almost:smile:
I hope the image and files are exhaustive:
practically:
with "master.xlsx"
I amount the configuration data "cutting.xlsx" and
I read to "disposition00.xls" the data inserted on "master.xlsx"
will be na insert 50o100 parts that I will suspend or reactivate
Now setting up some rules and cleaning it a little bit should work.
interesting would be to have buttons pressing them don't make you "spark"
the master.xls (this must have open the files to modify them) and that sdw rebuild the various components.
I hope the image and files are exhaustive:
practically:
with "master.xlsx"
I amount the configuration data "cutting.xlsx" and
I read to "disposition00.xls" the data inserted on "master.xlsx"
will be na insert 50o100 parts that I will suspend or reactivate
Now setting up some rules and cleaning it a little bit should work.
interesting would be to have buttons pressing them don't make you "spark"
the master.xls (this must have open the files to modify them) and that sdw rebuild the various components.
Attachments
narx
Guest
reggio
Guest
hi narx, beyond the proof you will make to see if you can "do not make it work" (interesting because both my var and swx have found so much that they opened a juice .... :frown, I am especially interested in understanding how you make it work on the net, that is how you can put my example on the net r:\prove\prove links excel\... and use, edit and save excel files from your client swx station without excel files error and rename. . .
Can you give me confirmation and explain how do you use/set? ? ? ?
narx
Guest
I apologize to experts but we neophytes have problems in doing this too.
I carry how to make a drop-down list, from which to select a entry in an external sheet and return it to the active one.
development> in design mode!
insert combo box(controlloactivex), go to the sheet and draw it
dx button on the newly created box,
property. (the list of properties appears)
on "listfillrange" inserted:
'[file dove sono i dati], sheet, data list (file must be opened)
es:
'[File.xls]sheet1!a1:a10
and on "linkedcell" insert the target cell
e.
$b$3
deactivate design mode.
end
I repeat: I hope experts do not scan me
I carry how to make a drop-down list, from which to select a entry in an external sheet and return it to the active one.
development> in design mode!
insert combo box(controlloactivex), go to the sheet and draw it
dx button on the newly created box,
property. (the list of properties appears)
on "listfillrange" inserted:
'[file dove sono i dati], sheet, data list (file must be opened)
es:
'[File.xls]sheet1!a1:a10
and on "linkedcell" insert the target cell
e.
$b$3
deactivate design mode.
end
I repeat: I hope experts do not scan me
Attachments
narx
Guest
geppetto
Guest
I read only now the evolutions on the approach method to the problem. I looked at the 3 .xls files and the swx loop. I continue to be of the initial opinion. . .
using tab_builder and you can select drop-down lists within swx itself. Each selected item represents a property that returns a fixed or variable value or text, these properties may be linked equations within swx itself (check that suffice those supported). equations can be activated or suppressed depending on the configurations where you want this to happen. if we use equations and tab_builder both in part and together using as a tab_builder property generator file the same source file we should not have problems.
In this way we would avoid moving from exel (if necessary we know that we can).
the things that should be understood and at this point are:
what kind of data should I return and with what frequency;
and how I have to manage historians and various configurations.
I am not sure I have explained well, but I believe more to an internal approach to the program than to an external management based on the loading of various external files with the risks of unsuccessful updates and macro improbable.
using tab_builder and you can select drop-down lists within swx itself. Each selected item represents a property that returns a fixed or variable value or text, these properties may be linked equations within swx itself (check that suffice those supported). equations can be activated or suppressed depending on the configurations where you want this to happen. if we use equations and tab_builder both in part and together using as a tab_builder property generator file the same source file we should not have problems.
In this way we would avoid moving from exel (if necessary we know that we can).
the things that should be understood and at this point are:
what kind of data should I return and with what frequency;
and how I have to manage historians and various configurations.
I am not sure I have explained well, but I believe more to an internal approach to the program than to an external management based on the loading of various external files with the risks of unsuccessful updates and macro improbable.
re_solidworks
Guest
hi geppeto, I wanted to ask you if you ever used this method in practice. is extremely stable and functional in other cads, like the "different" that uses your brother, but in swx? I have often used the equations a little heavily repented and had to put a piece on it later. ...
geppetto
Guest
hi king, I try to use a little all the tools I have available. I have found very useful the recent introductions of tab_builder and the distinct in the assemblies, which combined with the functions already present, allow me to extrapolate and work a large number of relative data to the various projects that are submitted to me. In fact, sw equations have an order problem with which they are formulated. I press that to narx I had initially proposed to use driveworks that I got to try and it seems to me to work well. Of course we must devote ourselves a little time, but from the sky I see fall only intemperies and never packages gift.:tongue:
In this case, if you want to do without, you should see how many equations govern your set/part, but from what I see it seems to me that with a dozen (in right order) you should succeed. I with equations, perhaps I have lower needs than yours, I have never had great problems, but if I do not think I can priori the order of equations I prefer the data tables. in relation to the fact that other cads seem to work better from this point of view is all to be demonstrated. I with sw a solution to the problems I have always found it and I found the problem of the order of the equations also in the fantastic program used by my brother. in the wf3 parts where the equations depend on regeneration of the model, need a double regeneration precisely. the perfect software will never invent it, the important and that the same is valid and always gives you the chance to develop what you need. in this case narx has the possibility to choose which way to go, but in order to do so in the best way it has to compare the needs with knowledge more or less in depth of sw. a neophyte (as defined him) often undertakes winding paths that however, also are returning the hoped result, they serve to understand the logic that governs the application used.
Am I worn out? Sorry. .
In this case, if you want to do without, you should see how many equations govern your set/part, but from what I see it seems to me that with a dozen (in right order) you should succeed. I with equations, perhaps I have lower needs than yours, I have never had great problems, but if I do not think I can priori the order of equations I prefer the data tables. in relation to the fact that other cads seem to work better from this point of view is all to be demonstrated. I with sw a solution to the problems I have always found it and I found the problem of the order of the equations also in the fantastic program used by my brother. in the wf3 parts where the equations depend on regeneration of the model, need a double regeneration precisely. the perfect software will never invent it, the important and that the same is valid and always gives you the chance to develop what you need. in this case narx has the possibility to choose which way to go, but in order to do so in the best way it has to compare the needs with knowledge more or less in depth of sw. a neophyte (as defined him) often undertakes winding paths that however, also are returning the hoped result, they serve to understand the logic that governs the application used.
Am I worn out? Sorry. .
narx
Guest
Meanwhile thank you. you are perfectly right in saying you use the tools available, but you will know better than me than having to produce, at times "acchrocchi" on something that for the moment allows you to do the job, for example with a little code vb and 3 sheets excel you can do things that if you do not engineer it to step you do a small case without going to understand where to put your hands, I am for simple things go, step.
As soon as I can take driveworks and see what jumps out.
Hi.
geppetto
Guest
the more you will gain experience with the cad, the better the results in time. It is only a matter of understanding limits, qualities and defects.
However as before mentioned re-solidworks the "program" used by my brother who has internal data tables, is very stable, records all possible and imaginable macros without messing up there. only that is not called sw but pro/e. However sw if you have no particular needs it works well.
good work:smile:
However as before mentioned re-solidworks the "program" used by my brother who has internal data tables, is very stable, records all possible and imaginable macros without messing up there. only that is not called sw but pro/e. However sw if you have no particular needs it works well.
good work:smile:
re_solidworks
Guest
Hi, I have to give you a reason and so I always did. I find the solution in skeletons, as it is simpler and immediate to see a modifcation on a skeleton rather than on a tab of numbers.
if you do not design products always similar to each other it is necessary (at least for me) to have under hand a two-dimensional study to see how the elements that make up our structure can be made.
instead of doing this studio by hand or with autocad I got used to doing it sketch in swx and then reuse these references in modeling.
in this way you open several loopholes to various problems and everything can be in topdown with centralized control.
I repeat the beautiful is to see the changes on sketches with the due proportions and not on tabulates.
with swx I am quite angry in this last period for various reasons. First of all, it seems to me that the level of attention of the mother's house towards the users is quite lowered, just see that an open press for months is still there, one mine reported with the 2008 sp 0.0 and stressed + times has been solved (or better + or - solved) with the 2010 sp 0.0.
And in the meantime? great user caxxi....
says long the investment of their time in the interface, direct modeling and touch screen.
solidworks has no serious functions and dedicated to the great assemblies and comes out of modeling technique after myriads of errors, I have made + times precise requests and in my opinion, these are things that can make the qualitative leap to the product.
not to mention stability, from what I took out 2007 I no longer found satisfaction.
in the office we have 4 fixed workstations + 2 furniture, all certified also in the power cord, with xp - xpx64 and 7x64 and different hardware.
stability is poor on all and I do not say that it is fault of the machines, they are dedicated and installations of junk to the minimum.
in this your brother's cad is different. ptc does not leave users to arrange in workarounds and techniques that require blood (if you have the right intuition to get to the bottom) but tracks the main road for users and the new user knows that doing in a certain way it gets to the bottom.
swx is a great cad, but lacks some basic functions for those who make big assemblies and lacks too much reliability: This is the criticism I have brought to my var for a long time....