You can only setup items with one of these methods. Why cant another column be inserted that does the inverse for your? 0.008 WH/SF vs 125 SF/WH or 5 WH/TON vs 0.2 TON/WH. We need the ability to display and edit both columns.

It is simply doing the inverse of the calculation, so in the first example grab your calculator and take 1/0.008 = 125

Comments

  • And the ability to change it on the fly (unit/hr to hr/unit and vice versa) on the spread sheet versus just under item details.