6 Replies Latest reply on Aug 8, 2016 1:20 PM by Brian Long

    DATA Card input formula for mathematical calculations

    Brian Long

      I work with pet food extrusion and we have a spreadsheet that will calculate the resistance or "K" factor of an extrusion plate. All of the values that the spreadsheet uses is manually entered in our data cards during the initial save into our vault. What I would like to know, is there a way to add an input formula that completes the calculations? This would be a huge time savings for my if this was possible. I am not where to start, but here is some info that I can initially give:

      Custom properties used:

      • Land Length (F6)
      • Cavities (F7)
      • Wetted Perimeter (F5)
      • Shape area (F4)
      • Shape K Factor (F9)

      I have a macro that calculates the total open area and places it in the custom properties, everything else is inputted as the file is being created.

      Here is the spreadsheet formula for calculating a single shapes "K" factor:

      • =((F4^2)/(8*3.1416*F6))*(1/(((((F5/(2*SQRT(3.1416*F4)))-1)^1.591)*4.253)+1))

      Then you calculate the total plate "K" factor using this formula:

      • =F9*F7

      This should give you an idea about how my spread sheet is set up.

       

      I am not sure how this would look as an input formula in a data card.

      I hope that I have explained this well enough for someone to help me.