
Re: DATA Card input formula for mathematical calculations
Jenny Johnson Jun 29, 2016 7:58 PM (in response to Brian Long)If you used a named range in the spreadsheet you can tie that to a variable in PDM.
In Excel  choose a cell and then in the upper corner name it
Once you have named the cells go to the File Tab  then choose the Drop down under Properties
Go to the Custom Tab  type in your property name  choose link to content  choose the field name.
Now just make sure you map that exact property name to the variable that you want on the card and in the variable setup
Good luck!
Jenny

Re: DATA Card input formula for mathematical calculations
Brian Long Jul 1, 2016 7:38 AM (in response to Jenny Johnson)The only thing is, I don't want to drive this on the spreadsheet side. I want to calculate this on the data card itself. Thank you for the reply.


Re: DATA Card input formula for mathematical calculations
Greg Johnson Jun 30, 2016 1:46 PM (in response to Brian Long)
Re: DATA Card input formula for mathematical calculations
Brian Long Jul 1, 2016 7:50 AM (in response to Greg Johnson)This gets me closer to what I am needing to do, although, I think that I need to be able to calculate higher math functions. When looking at the functions available in the input formula area, I only see basic operations. So, I guess my search will continue. Without the higher math functions, I may have to resort to Jenny's suggestion of using a spreadsheet that gets created by dispatch when the file is created.

Re: DATA Card input formula for mathematical calculations
Charley Saint Jul 1, 2016 1:16 PM (in response to Brian Long)Hey Brian,
The power function doesn't exist anywhere in PDM as far as I can remember, pretty sure you'll have to create an addin to handle that one if you don't want the spreadsheet.

Re: DATA Card input formula for mathematical calculations
Brian Long Aug 8, 2016 1:20 PM (in response to Charley Saint)I have ended up using equations inside the part file to complete the calculations.


