TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

[hugo.pereiraR8323]

Hello!

@Sebastian_Eiche 

Now i need to and more values to the previous  formula (ILength*IQuantity)

The formula (ILength*IQuantity)) is apply to the green boxes.

The formula of the grey boxes is ((../MUnitAmount-1)*5)

Its possible to join the 2 formulas?

The final result of the lenght, should be  for ex:

1000

2010

2110

2015

Is this possible?

I try to join the 2 formulas but it gives "invalid syntax"

Thank's

[Sebastian_Eiche]

how dou you try to join them?

[hugo.pereiraR8323]

I try to add "IFormula1+IFormula2"

😟

[Sebastian_Eiche]

Why don't you try a new combined formula?:

(ILength*IQuantity)+((../MUnitAmount-1)*5)

[hugo.pereiraR8323]

don't work

[hugo.pereiraR8323]

@Sebastian_Eiche 

Formula in the pink boxes

why is adding !?

[Sebastian_Eiche]

because it's summarize the formula3 of the field before.

[hugo.pereiraR8323]

Sorry @Sebastian_Eiche , but i don't understand ☹️

Can you please take a look.

[Sebastian_Eiche]

What should be the result of the pink boxes? could you create an excel or pic, what explain what you want to do?

I'm a litle bit lost in this thread, sorry

[hugo.pereiraR8323]

See if this can help you, to help me...

[hugo.pereiraR8323]

@Sebastian_Eiche , almost there...

(ILength*(IQuantity-1))+(5+ILength)+((IQuantity*5)-5)

[Sebastian_Eiche]

ok good to see, until now I had no time to have a look

[hugo.pereiraR8323]

Hello.
I'm back to this problem.

In the model i have some profiles.

My supplier only have this profile with 1800mm minimum lenght.

So one solution that i have is to weld the small parts in to oneassembly part that have more them 1800mm.

But, for each 2 profiles we have to add 5mm for the saw waste, ex:

1000 + 5 + 1000 = 2005mm final profile lenght.

The formula that we use is adding 5mm in the sinlge parts (F1 and F2)

And in the assemblys parts are 5mm less  (F3 and F4)

The correct lenght should be:

F1 - 4un - 4095mm

F2 - 6un - 7055mm

F3 - 1un - 4655mm

F4 - 4un - 3005mm

See the attach files.

Any ideias how to solve?

Is there a place to see how the template editor works?

Thank you.

[hugo.pereiraR8323]

@Sebastian_Eiche , any idea?

[Sebastian_Eiche]

I don't have time this week to have a look for this, but seems to be a problem which is easier to solve in an excel file