topic Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II) in Advance Steel Forum

TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Wed, 16 Mar 2022 13:57:27 GMT

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

Sebastian_Eiche — Wed, 16 Mar 2022 14:10:40 GMT

how dou you try to join them?

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Wed, 16 Mar 2022 14:30:55 GMT

I try to add "IFormula1+IFormula2"

😟

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

Sebastian_Eiche — Wed, 16 Mar 2022 14:48:38 GMT

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

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Thu, 17 Mar 2022 13:43:36 GMT

don't work

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Tue, 22 Mar 2022 13:59:52 GMT

@Sebastian_Eiche

Formula in the pink boxes

why is adding !?

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

Sebastian_Eiche — Tue, 22 Mar 2022 14:38:29 GMT

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Tue, 29 Mar 2022 13:15:52 GMT

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

Can you please take a look.

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

Sebastian_Eiche — Tue, 29 Mar 2022 13:20:31 GMT

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Tue, 29 Mar 2022 13:44:04 GMT

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Wed, 30 Mar 2022 13:50:27 GMT

@Sebastian_Eiche , almost there...

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

Sebastian_Eiche — Wed, 30 Mar 2022 13:58:36 GMT

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

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Tue, 19 Mar 2024 16:18:02 GMT

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.

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

hugo.pereiraR8323 — Thu, 21 Mar 2024 11:22:08 GMT

@Sebastian_Eiche , any idea?

Re: TEMPLATE EDITOR SUM OF LENGHT PARTS (part II)

Sebastian_Eiche — Thu, 21 Mar 2024 11:31:56 GMT

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