total amount of components used in a set (not as distinct)

[reggio]

Good morning...

I already recall the idea of the sarcastic answers of the "Veterans" of the forum, but I need to get a list exportable on excel with the total (not the partial) of each component, then I continue with an example:

the axieme is composed of n°2 axiemi b+n°2 axiemi c+n°2 axiemi d+n°2 axiemi and (a=2*b+2*c+2*d+2*e).
b=n°2 sheet metal
c=n°3 sheet at l+n°3 dado m8
d=n°2 z+n°3 dado m8
e=n°3 sheet z+n°5 dado m8

now, opening the axieme to me I want to get the total list of every single part (if you could have the "rice" with a single line with name part and total quantity part would be the maximum), that is,

I would like a list like this:
♪
dado m8 n°26
sheet n°10
sheet n°10
I want to know in all the dice I have to buy in hardware store and how many plates I have to order the thiefist without having to multiply the number of parts for subassienas and assemblies.. .

I do not want what I can now get from swx, that is, a distinct one that tells me
a is composed of 2*b+2*c+2*d+2*e
each b is composed of n°2 sheet to l+n°2 dado m8
each c is composed of n°3 sheet to l+n°3 dado m8
....
but they do not answer the question of the "ferramenta and the lamierista". .

... well, I mean, would you tell me how to get the total?

 

[MassiVonWeizen]

in the distinct materials, can't you set the "type of distinct materials" option "only parts"?
or am I not to understand what you're asking?

 

[Mike1967]

Good morning...

I already see the idea of the sarcastic answers of the "Veterans" of the forum, but ...

Okay, but at least the dice you could have put them in.... :biggrin:

 

[Mike1967]

Look if it's okay with you... :biggrin:
Attached video files.

(video yt available in a few minutes)[youtube]7 from Nanjfiyh4[/youtube]

 

[marcof]

in the distinct materials, you can not set as "type of distinct materials" option "solo party"?
or am I not to understand what you're asking?

quietly, you have understood perfectly, only that often the questions of reggio are spying because in the face of the papyri who writes to describe the problem, to solve them it is typically enough to put a flag in the right box:smile:

@reggio:
but do you ever take a quick look at the property managers of the functions you use to discover the various options? (for example those of the distinct materials...)
ah, already that you are, right click on the separate materials and quart the icon at the bottom

 

[reggio]

in the distinct materials, can't you set the "type of distinct materials" option "only parts"?
or am I not to understand what you're asking?

Yeah, you're right. you are right:redface:

I actually scanned the example... But now at least I know what I didn't understand... (and I sprinkle the head of ashes. . )
So I reform and re-enjoy (so you also find the dice that had remained in the library) and see if the question remains a banality and if you still have patience.. .

My problem is that in my real set, I put in parts (aluminum profiles) made with structural members and I expected to obtain in distinct the total of individual members with its length and weight... instead, even selecting the option "only parts" inserts me (justly) only the part "whole" that at me now does not interest.. .
to solve, should I draw piece by piece the aluminum profiles and then assemble them individually or, even in this case you know a more correct and fast road?thanks and "that strength be with you" :tongue:

 

[Ivan1990]

Yeah, you're right. you are right:redface:

I actually scanned the example... But now at least I know what I didn't understand... (and I sprinkle the head of ashes. . )
So I reform and re-enjoy (so you also find the dice that had remained in the library) and see if the question remains a banality and if you still have patience.. .

My problem is that in my real set, I put in parts (aluminum profiles) made with structural members and I expected to obtain in distinct the total of individual members with its length and weight... instead, even selecting the option "only parts" inserts me (justly) only the part "whole" that at me now does not interest.. .
to solve, should I draw piece by piece the aluminum profiles and then assemble them individually or, even in this case you know a more correct and fast road?thanks and "that strength be with you" :tongue:

Sorry but I think the quickest thing could be doing a single table for profiles and a table with the rest.... would definitely be faster.
option 2-if you just need a unique table you can take the structure you have done, go where it marks the bodies, "cutting distinction" you save bodies with name, also save together (it saves all bodies as parts and also creates you together), so you should be able to see what you need in the distinct... try and let me know

 

[Mike1967]

Sorry but I think the quickest thing could be doing a single table for profiles and a table with the rest.... would definitely be faster.
option 2-if you just need a unique table you can take the structure you have done, go where it marks the bodies, "cutting distinction" you save bodies with name, also save together (it saves all bodies as parts and also creates you together), so you should be able to see what you need in the distinct... try and let me know

I mean, so much a single object table, I think you have to do it anyway. .
In fact even putting at the table of the object in the table taken from the assembly and posing "detail detail" keeps you all the separate pos. and if you have various bolts will not be added.
However, it is true that sometimes I added a column to the table and with an equation you calculate how many vines and frogs are present in that same table... easier to get than to get lost.

 

[reggio]

take the structure that you have done, go where it marks the bodies, "cutting distinct" saves bodies by name, saves together (it saves all the bodies as parts and creates you also together), so you should be able to see what you need in the separate... try and let me know

I'm sorry, but I didn't understand anything about how to do it. . .

Where does the bodies of the part?
??? should appear with the dx key or how?
saves bodies by name: from the part that contains aluminum profiles? with the open axeme?
also saves together: the assist to?
saves all the bodies as parts and creates you together?? ? ? ?

Do you try to explain it to me? :redface:

In fact even putting at the table of the object in the table taken from the assembly and posing "detail detail" keeps you all the separate pos. and if you have various bolts will not be added.

...so, this would still be bearable (not understandable)

a table of the object. . .
It's still true that sometimes I've added a column to the table and an equation...table... easier to get than to get lost.

Capito zero...

think that the final purpose was to prepare an offer to a customer, I thought (I, the usual ill-use) that doing it with swx, then I would have got the real distinction and it would have been enough to put alongside a price multiplied by the amount... But I know that even if I am, I will send a swx, and I will do it in my hand.

 

[Ivan1990]

I'm sorry, but I didn't understand anything about how to do it. . .

Where does the bodies of the part?
??? should appear with the dx key or how?
saves bodies by name: from the part that contains aluminum profiles? with the open axeme?
also saves together: the assist to?
saves all the bodies as parts and creates you together?? ? ? ?

Do you try to explain it to me? :redface:


...so, this would still be bearable (not understandable)

zero...

think that the final purpose was to prepare an offer to a customer, I thought (I, the usual ill-use) that doing it with swx, then I would have got the real distinction and it would have been enough to put alongside a price multiplied by the amount... But I know that even if I am, I will send a swx, and I will do it in my hand.

look in the function tree, where you have made the structure of profiles, it will see that there is a distinct cut, if you click on the right button there is a "Save Body" option you save it together, and it creates a set where the bodies become parts. so you should succeed in your intent.

other method was to set the propitiancies for each body always in the cutting distinct >>> option updated > > go on various bodies divided by equalities- right clicks propitize and insert the ones you need (many there are already)- then put on the table and make the separate cut and hold this table as addition to the other.

 

[Mike1967]

I would like a list like this:a=given m8 n°26lamiera a l n°10lamiera a z n°10I want to know in all the dice I have to buy in hardware store and how many plates I have to order the thiefist without having to multiply the number of parts for subassienas and assemblies.. .

But the video I posted doesn't reflect what you were looking for?

 

[re_solidworks]

You have iron, coal and pressure machine... for totals click the item in the general list and go to list re-epilogated, in ready.
for premium r2w profiles makes you nesting on the rod, automatically and also on welded. What are you looking for?