topic Betreff: Setup sheets: add calculations in PowerMill Forum

Setup sheets: add calculations

Daniel.Reister — Tue, 27 Feb 2024 16:47:25 GMT

Hi I work commonly with Powermill macros, but not as much with the setup sheet side of things in powermill. I was wondering if there is a way that I could take two parameters that can be used in setup sheets and do some math with them and display the results of that math in the setup sheet. Does anyone know if there is a way to do that? To help explain what I am wanting to do here is an example of two values I want to displayed after they are added together.

I want this value...

${Block.Limits.ZLength}

Added to this value...

${height_above_model}

I then want the result of that displayed on the setup sheet.

Thanks,

Daniel

Betreff: Setup sheets: add calculations

icse — Wed, 28 Feb 2024 07:10:25 GMT

try to write it like this:

${Block.Limits.ZLength + height_above_model}

Re: Setup sheets: add calculations

Daniel.Reister — Wed, 28 Feb 2024 14:47:35 GMT

I tried it out this morning, and it does not work. Not sure if HTML is capable of doing math. It is like it just adds the two strings together so it takes the value of the first part of the expression and puts it next to the value from the second part of the expression.

So if...

${Block.Limits.ZLength} = 2.1

and

${height_above_model} = .03

It displays

2.10.03

If it is not possible to do the math in the HTML for the setup sheet is it possible to do the math somewhere else and pass it into the setup sheet?

Re: Setup sheets: add calculations

icse — Wed, 28 Feb 2024 16:46:16 GMT

did you tryed to pot it in the same {}?

like this:

${Block.Limits.ZLength + height_above_model}

NOT this:

${Block.Limits.ZLength} + {height_above_model}

Re: Setup sheets: add calculations

Daniel.Reister — Wed, 28 Feb 2024 15:46:21 GMT

I have attempted these different approaches and few others and everything returns simply as different combinations of the string but never with the values calculated together.

Re: Setup sheets: add calculations

icse — Wed, 28 Feb 2024 15:53:16 GMT

thats odd... for me it seems to work just fine

Re: Setup sheets: add calculations

Daniel.Reister — Wed, 28 Feb 2024 16:31:12 GMT

Could you send me a snapshot of what it produces on your setup sheet?

Re: Setup sheets: add calculations

icse — Wed, 28 Feb 2024 16:55:09 GMT

Youre right... for testing i used an int value that seems to work fine

anyway i have another solution attempt for you:

<table> <tr id="result">${height_above_model}|${Block.Limits.ZLength}</tr> <script> var element = document.getElementById("result"); var nums = element.innerText.split('|'); element.innerText = parseFloat(nums[0].replace(',','.')) + parseFloat(nums[1].replace(',','.')) </script> </table>

Here i write both values splited by '|', then i use JavaSkript to split and parse them,

and finially i write em back.

Ugly but it seems to work.

Re: Setup sheets: add calculations

Daniel.Reister — Wed, 28 Feb 2024 16:56:00 GMT

That does it. Thanks for your help. I was wondering if it would require some javaskript. I have not done any work with Java so this is a helpful start.

Betreff: Setup sheets: add calculations

a_bako — Thu, 29 Feb 2024 09:32:55 GMT

Try this on setupsheet page:

${real(Block.Limits.ZLength) + real(height_above_model)}

Betreff: Setup sheets: add calculations

Daniel.Reister — Thu, 29 Feb 2024 15:49:24 GMT

This solution also works and is simple to implement. Thanks for the help.