Mass Summation in Repeat Region

[hbharrison]

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

[WendyK]

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"

[hbharrison]

Thanks!  I'll give it a try.

[hbharrison]

The materials won't combine as masses, but if I just have material name it will.

[WendyK]

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)

[hbharrison]

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:

[WendyK]

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.

[hbharrison]

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.

[MartinHanak · Accepted 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:

• create the table in the picture on the left using repeat region + summation
• export the table into CSV file
• import CSV file into Excel
• use Excel functionality to get the table in the picture on the right
• export new table from Excel to CSV file
• import CSV file into Creo drawing

[hbharrison]

Thanks, it will probably be the third non-parametric option.