Okay, here goes. Your note on the cell said 44 Ah - but maybe that's from previous spreadsheet user.
EV-calculations
Therefore, the Wh/m usage = Voltage x ( Current / Speed ) = X Wh/m
K21 in your sheet is wrong. It should be A34 * (J19/I14).
I34 is wrong, too. Your total amp-hours is the same as amp-hours of single battery. I32:I34 should be deleted.
*IF* you can really get it to work out at 94 Wh/mile, you still get ~48 miles at cruise on 100Ah at 65% DoD. After losses and Peukert; you'd probably get 85% of that 48; giving ~40 miles total range.
94.39 Wh/mile seems really, REALLY efficient! I'm not sure that you can get that low.
If it's only 0.8 mles, why not an e-bicycle?
I've made some changes to your sheet (as described) and have attached a new copy.
*EDIT*
I messaged Ben Nelson on Twitter and asked him to weigh in.
