Spreadsheet for maxflex power and runtime

[netprince]

Hey Everyone,

I thought it would be interesting to have a better understanding of the runtime associated with each of the 5 drive levels provided by the maxflex driver.

I've been tinkering with this off and on for a few days. So far I am trying to understand and solve two problems:

1) Set the best medium and low voltage warnings for eneloop cells.
2) Calculate power usage and runtime for different input and output values

My wife and I came up with this spreadsheet to help. The first sheet contains my best attempts at setting the voltage warnings. The second sheet contains the formulas for determining power and runtime for various input and output values.

http://www.psyc.vt.edu/lenslight/maxflex_voltages.xlsx

Suggestions for improvement?