Spreadsheet: 91224d1290981897-simplify-formula-sumovertime
Sheet: Sheet1

p | Dates |  | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00 | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | Total | Equipment
p |  | From: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 1 | 6 | 10 | 14 | 19 | 23
p |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 27 | 32 | 36 | 40 | 45 | 49
p |  | To: | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 5 | 9 | 13 | 18 | 22 | 26
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 31 | 35 | 39 | 44 | 48 | 52
p | C152 dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 69.69230769230762 | 69.69230769230762 | 87 | 87.11538461538467 | 69.6923076923077 | 69.6923076923077 | 435.576923076923 | C152 | dual | C152 | 190
p | C152 solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 24.92307692307691 | 1000 | 24.92307692307691 | 31.15384615384615 | 24.92307692307693 | 24.92307692307692 | 155.7692307692307 | C152 | solo | C152 | 190
p | C172N dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 149.6769230769232 | 149.6769230769232 | 149.6769230769232 | 187.0961538461538 | 149.676923076923 | 149.6769230769231 | 935.4807692307695 | C172N | dual | C172N | 209
p | [NAME] solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 15.3692307692308 | 15.3692307692308 | 15.36923076923077 | 19.21153846153846 | 15.36923076923077 | 15.36923076923077 | 96.05769230769236 | C172N | solo | C172N | 209
p | C172R dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 22.89230769230768 | 22.89230769230767 | 22.89230769230767 | 28.61538461538461 | 22.89230769230769 | 22.89230769230769 | 143.076923076923 | C172R | dual | C172R | 239
p | C172R solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 12.36 | 12.36 | 12.36 | 15.45 | 12.36 | 12.36 | 77.25 | C172R | solo | C172R | 239
p | C172RG dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 45.76153846153849 | 45.76153846153852 | 45.76153846153852 | 57.20192307692311 | 45.76153846153847 | 45.76153846153847 | 286.0096153846156 | C172RG | dual | C172RG | 245
p | C172RG solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 8.83846153846153 | 8.83846153846153 | 8.83846153846153 | 11.04807692307691 | 8.838461538461537 | 8.838461538461537 | 55.24038461538458 | C172RG | solo | C172RG | 245
 | C172SP dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C172SP | dual | C172SP | 289
 | C172SP solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C172SP | solo | C172SP | 289
p | C206 dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 3.807692307692307 | 3.807692307692307 | 3.807692307692308 | 4.759615384615384 | 3.807692307692307 | 3.807692307692307 | 23.79807692307692 | C206 | dual | C206 | 170
p | C206 solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 4.730769230769226 | 4.730769230769226 | 4.730769230769226 | 5.913461538461542 | 4.730769230769231 | 4.730769230769231 | 29.56730769230768 | C206 | solo | C206 | 170
p | BE76 dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 23.81538461538459 | 23.81538461538463 | 23.81538461538463 | 29.76923076923079 | 23.81538461538462 | 23.81538461538462 | 148.8461538461539 | BE76 | dual | BE76 | 389
p | BE76 solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 2.07692307692308 | 2.07692307692308 | 2.076923076923078 | 2.596153846153846 | 2.076923076923077 | 2.076923076923077 | 12.98076923076924 | BE76 | solo | BE76 | 389
p | Citabria dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 3.115384615384613 | 3.115384615384613 | 3.115384615384613 | 3.894230769230768 | 3.115384615384616 | 3.115384615384615 | 19.47115384615384 | Citabria | dual | Citabria | 167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
P | Total flight hours |  | 0 | 0 | 0 | 0 | 0 | 0 | 387.06 | 387.06 | 387.06 | 483.825 | 387.06 | 387.06 | 2419.125
P | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | [NAME]
P |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P | Total simulators |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P | Total Flight Related |  | 0 | 0 | 0 | 0 | 0 | 0 | 387.06 | 387.06 | 387.06 | 483.825 | 387.06 | 387.06 | 2419.125
P | Ground School |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P | Total Ground School |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
P | Total Course |  | 0 | 0 | 0 | 0 | 0 | 0 | 387.06 | 387.06 | 387.06 | 483.825 | 387.06 | 387.06 | 2419.125
 | Aircraft - solo |  |  |  |  |  |  |  | 14679.17076923077 | 199943.7861538462 | 14679.17076923076 | 18348.96346153846 | 14679.17076923077 | 14679.17076923077 | 91744.8173076923 |  | solo
 | Aircraft - dual |  |  |  |  |  |  |  | 71638.6153846154 | 71638.61538461543 | 74927.07692307698 | 89548.26923076922 | 71638.61538461538 | 71638.61538461539 | 447741.3461538462 |  | dual
 | Instructors
 | Ground School
 |  |  |  |  |  |  |  |  | $/HR |  | Problem: | a simpler formula for [NAME] which will allow for additions to aircraft over time
 | C152 |  |  |  |  |  |  |  | 190
 | C172N |  |  |  |  |  |  |  | 209
 | C172RG |  |  |  |  |  |  |  | 245
 | C172R |  |  |  |  |  |  |  | 239
 | BE76 |  |  |  |  |  |  |  | 389
 | C172SP |  |  |  |  |  |  |  | 289
 | C206 |  |  |  |  |  |  |  | 170
 | Citabria |  |  |  |  |  |  |  | 167