MassiVonWeizen
Guest
Here, perhaps with the attachment is easier
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
MassiVonWeizen
Guest
tanticapelli
Guest
Forgive me but I do not see repetitions in this together3d test file.
problem that is found with the data table is the update of the repetition that happens only after the opening of the table. I need to think about it. .
MassiVonWeizen
Guest
because I do the dicks to others for information, but then I do it badly and forget the trivial things how to save before doing the pack&go... I'm a beastForgive me but I do not see repetitions in this together
Attachments
tanticapelli
Guest
you will be following 10 different discussions with one bitch behind the other.. .because I do the dicks to others for information, but then I do it badly and forget the trivial things how to save before doing the pack&go... I'm a beast
tanticapelli
Guest
MassiVonWeizen
Guest
mine was an example.
from your set or part create repetition and place random values, enter a quota that manages the distance (I put it as a annotation, but you can do it in other ways) and then create the data table. at that point within the table and change as an example
from your set or part create repetition and place random values, enter a quota that manages the distance (I put it as a annotation, but you can do it in other ways) and then create the data table. at that point within the table and change as an example
tanticapelli
Guest
you have given me great help and we have beaten those of the (of!) care centers over time.
Let's say that my set is not very practical because of the too many components I have inserted, however the stratigraphy in the detail of the design appears correctly.
compared to my colleagues who do with autocad and you must also do the calculator to distribute the accessories, I am later, at least on this I mean.
I did a test in generating new configurations and new drawing sheets to understand how practical this kind of step could.
had a little attention to recreating configurations in all elements and attributing them to the correct configuration of Father together, however the couplings do not need to be configured and everything goes quite fluid, considering that I am not working on a workstation at this time.
I am very happy with what you taught me, I understood how to interface excel with sldwrks.
question: according to the result we have achieved would have been possible even without relying on excel?
I'll send you what we did.
thanks and good night
so many hairs
Let's say that my set is not very practical because of the too many components I have inserted, however the stratigraphy in the detail of the design appears correctly.
compared to my colleagues who do with autocad and you must also do the calculator to distribute the accessories, I am later, at least on this I mean.
I did a test in generating new configurations and new drawing sheets to understand how practical this kind of step could.
had a little attention to recreating configurations in all elements and attributing them to the correct configuration of Father together, however the couplings do not need to be configured and everything goes quite fluid, considering that I am not working on a workstation at this time.
I am very happy with what you taught me, I understood how to interface excel with sldwrks.
question: according to the result we have achieved would have been possible even without relying on excel?
I'll send you what we did.
thanks and good night
so many hairs
Attachments
tanticapelli
Guest
ah yes I forgot that I had to make sure that the linear repeats controlled by excel were first level because otherwise I saw that, as you had already done in your example, when you try to generate the excel sheet the parameters that are not first level are not considered.
MassiVonWeizen
Guest
Have you ever used data tables to manage and create configurations?I am very happy with what you taught me, I understood how to interface excel with sldwrks.
however well that this roman has also been resolved; to do so without excel I think you should use the equations as mentioned earlier because there is the bond of the minimum distance to be respected, but as I wrote mine would be a go to attempts without being sure that it is possible, maybe one day I put myself... Maybe
with collaborative people and who have actually issues is a pleasure to collaborate looking for the best solution. thanks also to you
tanticapelli
Guest
no, sincerely I never used it, a little because I didn't know how to do it, a little because the configurations I created were never complex (not that this was complex for charity....) and I managed to manage them very trivially with the solidworks interface.Have you ever used data tables to manage and create configurations?
a question arises: since the excel we used in this place seemed to detect and operate only within the first-level functions of the assieme father, if I wanted to configure for example the values of the c009-20-faced type part I should have generated another excel sheet?
and then I should have kept that excel tied to the part (visible in the feature manager above the configurations) or could have destroyed it after editing the data comfortably and written inside the file to avoid annoying updates within the part to each rescue?
instead the above excel could not be "snapped" by the axieme because of the calculation of the values by rounding. excess, right? because if I eliminated it I would lose all the formulas that I wrote and once generated by solid it would only give me dry values without mathematical relationships of any kind, is it correct?
I apologize if I'm pedant. . .
MassiVonWeizen
Guest
each set must have its data table; with the data table you can also manage configurations (activated/unactivated) so if you have a part with multiple configurations you can manage through the data table which configuration of that part to use.
example:
the axieme has three configurations
-001-
00-2
003
inside the axieme there is a part with 2 configurations
- outdoor
- Closed
with the data table you can specify that in the configuration 001 the part is open and in the configurations 002 and 003 is closed.
a data table, both internal and external, should work as a method of writing and not reading, that is, the data table is born to speed up the creation of configurations (typical example the creation of a screw in which you have to vary length and description with the data table you put a few minutes to create even 100 configurations); In fact, the changes that you add to your current set, extend the x or y value) are updated the repeats after opening the data table (me confirm it?). in this case the data table was an escamotage to manage the situation, but it is, should be, an exception.
delete the data table therefore does not affect the operation of the model, but prevents the update in case of changes.
to understand, if after doing the 100 screw configurations I delete the data table the model works correctly and I can switch from one configuration to another seeing the length of my screw update
I wrote too much stuff and I might have been unclear because it's all logical in the head, but then putting it in writing is likely to give for granted some passages or to make periods arzigogolati
example:
the axieme has three configurations
-001-
00-2
003
inside the axieme there is a part with 2 configurations
- outdoor
- Closed
with the data table you can specify that in the configuration 001 the part is open and in the configurations 002 and 003 is closed.
a data table, both internal and external, should work as a method of writing and not reading, that is, the data table is born to speed up the creation of configurations (typical example the creation of a screw in which you have to vary length and description with the data table you put a few minutes to create even 100 configurations); In fact, the changes that you add to your current set, extend the x or y value) are updated the repeats after opening the data table (me confirm it?). in this case the data table was an escamotage to manage the situation, but it is, should be, an exception.
delete the data table therefore does not affect the operation of the model, but prevents the update in case of changes.
to understand, if after doing the 100 screw configurations I delete the data table the model works correctly and I can switch from one configuration to another seeing the length of my screw update
with the creation of a data table the values linked to it cannot be changed from the inside of solid, in fact if you double-click on a repetition value will exit a message that warns that it is a size managed by the data table; in this case you can act from solid to the table (which is not the correct method of work) because the x value is not used directly from the table, but is used indirect way through the annotation quotation that is a guided quota and therefore already of its unchangeable.instead the above excel could not be "snapped" by the axieme because of the calculation of the values by rounding. excess, right? because if I eliminated it I would lose all the formulas that I wrote and once generated by solid it would only give me dry values without mathematical relationships of any kind, is it correct?
I wrote too much stuff and I might have been unclear because it's all logical in the head, but then putting it in writing is likely to give for granted some passages or to make periods arzigogolati
Absolutely not, don't worry. wanting to understand things deeply makes you honorI apologize if I'm pedant. . .
tanticapelli
Guest
It gives me the idea that sldwrks go to search in excel if there are values to spread me and if yes they go to overwrite even wrong.in fact the changes that you attach to your current set, extend the x or y value) are updated the repetitions after opening the data table (me confirm it? )
It seems to me that read and write a little as the property tab builder does.
This happened to me with rd1@annotations and rd2@annotations that as you wrote are two reading quotas that depend only on a correct update of the sketches and do not depend in this case on the formulas present in excel, however the two quotas mentioned are the source of calculation of everything else...
It happened that this morning just reopened the assieme father one of the two quotas (it seems rd2) was not properly updated because of a incorrect update of the sketch to which it was attached.
As a result, excel absorbed the wrong value and calculated the others incorrectly by writing them to me accordingly in its repetition.
this happened for the last configuration I added on purpose, to see how practical it could be available.
Let’s say that reflecting on what you wrote this excel sheet generates a kind of somewhat dangerous loop.
Entering the sheet merit please some information about the options in the curtains.
in the column $state@functionincontext3 (which I do not understand what it refers to in particular) I can insert s= suspended, r= reactivated, 1= suspended, 0= reactivated.
the same options are present in the column $fix@c009-20 fixed camera glass<1> (which seems clear to me what it refers to).
What is the difference between s= suspended and 1= suspended?
you have written so much stuff (and I follow you by wheel) but for me it is very useful since I am a little naif user.
tanticapelli
Guest
other question:
but always talking about the axieme object of this post, if I wanted to add new configurations "to the quick" using excel, I noticed that when I am in a set or an excel subaxieme allows me to associate to a new axieme configuration (from which I generated the excel) a configuration of existing part or subaxieme, but it does not allow me to generate a new configuration even in subcomponents.
So should I generate an excel for each component? So where is he saving time for this case?
but always talking about the axieme object of this post, if I wanted to add new configurations "to the quick" using excel, I noticed that when I am in a set or an excel subaxieme allows me to associate to a new axieme configuration (from which I generated the excel) a configuration of existing part or subaxieme, but it does not allow me to generate a new configuration even in subcomponents.
So should I generate an excel for each component? So where is he saving time for this case?
MassiVonWeizen
Guest
I would like to thank the rapporteur for his work. guide indicates them indifferently bothWhat is the difference between s= suspended and 1= suspended?
These variables manage if a function/part is active or suspended.
I try to better explain the concept of data tables.It gives me the idea that sldwrks go to search in excel if there are values to spread me and if yes they go to overwrite even wrong.
the data table is a system that from excel enters solidworks so you enter the values in excel and when you close the solidworks table updates the changed parameters. and this is the correct system of working with data tables.
when working on the reverse, i.e. by reading the data table the values inserted or modified in solidworks the data table is always updated, that the value has been modified or not (of course if the value has not been modified there is no change), this means that if you have made a change in the model and you have not updated it by opening the table the not updated calculation value (in our case the annotation value is guided requires a model update). Then it happens that the data table once closed automatically updates the model and if it has a wrong value (because it is obtained from an unupdated model) it remains such and it enacts all those variables attached to it.
I also explain the logic of the annotation quota, even if you are already clear.
linear repetition, in 2014 that I used for the test, asks how input data n° instances and spacing, but as what can be defined is the spacing serves a way to calculate it; from here the need for the other dimension that serves to define a product and that is the total.
I have not used existing quotas that define the total size (x or y) because as I mentioned in a previous post a variable managed by the data table can not be changed from within the model, but only from within the table; this would have meant that in order to vary the x or y value you should have opened the data table with all the problems and nuisances that this entailed.
in this case for how it is used yes.Let’s say that reflecting on what you wrote this excel sheet generates a kind of somewhat dangerous loop.
the data table applies only to the model in which it is inserted; in a set consider subaxis and parts as if they were functions that you can manage their existing data, but you cannot create new ones.other question:
uff... I got my breath... again so much
MassiVonWeizen
Guest
I found the way to do it without data table.
it is necessary to insert global variables to obtain data; in fact these variables do nothing but use excel formulas
I'll train you
the advantage of this solution is clearly that you have a much faster control of changes.
it is necessary to insert global variables to obtain data; in fact these variables do nothing but use excel formulas
I'll train you
the advantage of this solution is clearly that you have a much faster control of changes.
Attachments
tanticapelli
Guest
Killer!I found the way to do it without data table.
it is necessary to insert global variables to obtain data; in fact these variables do nothing but use excel formulas
I'll train you
the advantage of this solution is clearly that you have a much faster control of changes.
as simplicity and cleanliness there is no comparison at first!
so in such cases you must always try to hurry with the functions listed in http://help.solidworks.com/2019/ita...ors_functions_and_constants.htm?verredirect=1 if these should not be enough then you have to resort to the calculation by excel. Is that correct?
tanticapelli
Guest
I can no longer attach the aid because the package is 8.646 k
MassiVonWeizen
Guest
those listed in the guide are not all available in fact if (although it is not properly a function) and rounds (founded in This is what ina)
In my opinion when you find an obstacle you first look for the solution with the means at your disposal, then if the result does not satisfy or you see a margin of improvement you seek out from your own cognitive schemes, which can be excel, equations, macro or other. Perhaps, beware that it is a hypothesis without foundation and to be considered purely esemplicative, this problem could be solved with a macro of 4 lines but I do not know how to do and therefore I looked for other ways. this to say that for me there is no binary reasoning for which if it is not inside then and out.
I consider it a simplistic definition.if these should not be enough then you have to resort to the calculation by excel. Is that correct?
In my opinion when you find an obstacle you first look for the solution with the means at your disposal, then if the result does not satisfy or you see a margin of improvement you seek out from your own cognitive schemes, which can be excel, equations, macro or other. Perhaps, beware that it is a hypothesis without foundation and to be considered purely esemplicative, this problem could be solved with a macro of 4 lines but I do not know how to do and therefore I looked for other ways. this to say that for me there is no binary reasoning for which if it is not inside then and out.
MassiVonWeizen
Guest
bhé so much I can not open it and who follows the discussion has other attachments on which to study and analyzeI can no longer attach the aid because the package is 8.646 k