3 Replies Latest reply on Apr 13, 2018 6:16 PM by rschmitz

    Can I use defined names from Excel in a performance equation?

    GDKennedy

      I am wondering if I can use defined names from excel in a performance equation.  I have been searching the boards but have not found anything that references this.  I have several integer values that I use in performance equations in a spreadsheet and I was thinking it may be easier to maintain these if I had them as a defined name, using the name manager in excel or if I could do a cell reference.  I did see the syntax for a cell reference but I could not get that to work, I am using calculated data in the datalink.    The thing that may complicate that is the references are on another page of the work book, my syntax looked like this '"&'Behind the Scenes'!F58&"'   or '"&Ref_Temp&'"

      The entire equation looks like this:   (('FIC-311.PVI'*1000)*(172+(('TIC-448.PVI'*0.4363)-(0.5332*'TI-313.PVI')))/1000000)+(('FIC-327.PVI'*(172+(0.4363*'TIC-448.PVI')-('TI-330.PVI'*0.5332)))/1000000)  I was hoping to use the defined name or the cell reference to replace the number values.

       

       

      Thank you for the help.

       

      dan