Added columns

• Transfer rate to/from host (Sustained)
• Load/Unload cycle maximum
  
• Workload TB per year
• MTBF
• Non-recoverable read errors per bits read

I have started to add data into this new columns, but it will take a while...

Updated various prices and added a couple more new disk drives

• Updated WD power usage values from new spec sheets per suggestions from JoeS.
  
• Add WD Blue 2.5" drives (1TB, 2TB)
• Updated some prices
• Made use of more labels rather the cell references.

• Added more disk drives
• Updated prices
• Updated Incremental$Warr/Yr to 11% - Seems more realistic value when looking around interet
  
• Changed the color from yellowish for columns "$ TB" and "$ TB/year" to green to make it easier to read.
• Various misc updates

Changes to this version:

• Went through some formulas and corrected incorrect calculations.
• Used more labels to make it more readable by others, if they chose to modify it.
• Made the calculations based upon days/months more accurate by getting rid of some slop. This affected the energy calculations by a small amount.
  
• Added some comment fields so you can now hover over them and get an idea of what the purpose is. Mainly on user modifiable cells. The cells that would make sense to change are price per KWH and active duty cycle (default 20%). There are a couple others - play with it to your hearts content.

Most recent update