I am attempting to create a repeat region that sums the mass of different material types in an assembly. The issue is I have different common names using the same material in the table. I know I can do this through filter, but I am being asked to provide a different solution. Oh yeah - I don't know how to write relations!
Appreciate any guidance,
Helena
Solved! Go to Solution.
@hbharrison wrote:
I would like all the PP (or like materials) to consolidate in the same row along with the mass. So, as you saw in the one table where PP material is a quantity of 5, there would be another column for mass and all 5 of the masses would be summed on the same line.
Thanks for your thoughts
As is in Excel:
Hi,
I think that your request cannot be easily met in Creo.
1.]
YES, you can create the table in the picture on the left using repeat region + summation. Unfortunatelly you cannot "collapse" rows with the same material into one row with mass summed up (in this table).
... perhaps if you moved all the parts to 1 subassembly, then you would reach the goal ...
2.]
To get mass of all parts with the same material, you have to create separate repeat region for every single material and apply filter to display part with specific material, only. Then you can add summation cell.
3.]
If you accept non-parametric solution, then:
Hi Helena
here is part of the solution- but you will need to have just ONE parameter for the mass off the parts.
{set configuration setting "mass_property_calculate"= automatic, and regenerate your assembly, make sure every part has its material set. If you want, in an assembly window in the model tree you can show columns for material and mass:
modelparams->ptc_material_name
Mass properties params->pro_mp_mass }
Now back to your drawing repeat region.
Include in your table these columns "rpt.qty" "asm.mbr.pro_mp_mass" "rpt.rel.qtymass" and {optional "asm.mbr.ptc_material.PTC_MATERIAL_NAME" }
(add some blank columns, set switch symbols to see the symbols, double click in second row cells and build up the names of the columns, switch symbols to see the result)
Add a relation QTYMASS=rpt_qty*asm_mbr_pro_mp_mass
(Repeat Region->relations->select table-> type the relation (can also right click on the parameters in the list and add to the relation.)
Update table and regen and you should have a column of masses.
Add sum: Add a row to the table to place sums in, Then:
Table-> switch symbols (to show symbols)
TABLE –> REPEAT REGION->SUMMATION select the region
(TBL Sum) ADD -> ByText –select the parameter to sum(in row 2), "rpt.rel.qtymass" ->enter a name for it "sumqtymass" ->pick a cell to put it in (note it does not necessarily have to be the cell below the column being summed, but that is where I would put it)
I hope this helps.
you may also need to set the repeat region attributes "No Duplicates" & "Flat"
Thanks! I'll give it a try.
The materials won't combine as masses, but if I just have material name it will.
I don't understand what you are asking.
Mass of part-i = density of material of a part-i * volume of part-i
mass of parts-i= qty of part-i * mass of part-i
mass of assembly = sum(mass of parts-n)
I would like all the PP (or like materials) to consolidate in the same row along with the mass. So, as you saw in the one table where PP material is a quantity of 5, there would be another column for mass and all 5 of the masses would be summed on the same line.
Thanks for your thoughts
As is in Excel:
Hi Helena,
Each row is a part or an assembly. try making a subassembly for your parts made out of pp and moving all your pp parts into it. then you can show the assembly on a line. (Is this to know how much plastic to buy?)
fyi-attached is the part of the table I was working on, and its relations.
Our customers sometimes ask how much (%) of each material is contained within a product. There are project managers who need a quick way to assess this throughout an entire product line.
@hbharrison wrote:
I would like all the PP (or like materials) to consolidate in the same row along with the mass. So, as you saw in the one table where PP material is a quantity of 5, there would be another column for mass and all 5 of the masses would be summed on the same line.
Thanks for your thoughts
As is in Excel:
Hi,
I think that your request cannot be easily met in Creo.
1.]
YES, you can create the table in the picture on the left using repeat region + summation. Unfortunatelly you cannot "collapse" rows with the same material into one row with mass summed up (in this table).
... perhaps if you moved all the parts to 1 subassembly, then you would reach the goal ...
2.]
To get mass of all parts with the same material, you have to create separate repeat region for every single material and apply filter to display part with specific material, only. Then you can add summation cell.
3.]
If you accept non-parametric solution, then:
Thanks, it will probably be the third non-parametric option.