Spreadsheet: 91221d1290980293-simplify-formula-sample
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: |  |  |  |  |  |  | 1
p
p |  | To:
p | C152 dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 69.69230769230762 | 69.69230769230762 | 69.69230769230768 | 87.11538461538467 | 69.6923076923077 | 69.6923076923077 | 435.576923076923 | C152
p | C152 solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 24.92307692307691 | 24.92307692307691 | 24.92307692307691 | 31.15384615384615 | 24.92307692307693 | 24.92307692307692 | 155.7692307692307 | C152
p | C172N dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 149.6769230769232 | 149.6769230769232 | 149.6769230769232 | 187.0961538461538 | 149.676923076923 | 149.6769230769231 | 935.4807692307695 | C172N
p | [NAME] solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 15.3692307692308 | 15.3692307692308 | 15.36923076923077 | 19.21153846153846 | 15.36923076923077 | 15.36923076923077 | 96.05769230769236 | C172N
p | C172R dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 22.89230769230768 | 22.89230769230767 | 22.89230769230767 | 28.61538461538461 | 22.89230769230769 | 22.89230769230769 | 143.076923076923 | C172R
p | C172R solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 12.36000000000001 | 12.36000000000001 | 12.36000000000001 | 15.45000000000001 | 12.36 | 12.36 | 77.25000000000004 | C172R
p | C172RG dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 45.76153846153849 | 45.76153846153852 | 45.76153846153852 | 57.20192307692311 | 45.76153846153847 | 45.76153846153847 | 286.0096153846156 | C172RG
p | C172RG solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 8.83846153846153 | 8.83846153846153 | 8.83846153846153 | 11.04807692307691 | 8.838461538461537 | 8.838461538461537 | 55.24038461538458 | C172RG
 | C172SP dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C172SP
 | C172SP solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C172SP
p | C206 dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 3.807692307692307 | 3.807692307692307 | 3.807692307692308 | 4.759615384615384 | 3.807692307692307 | 3.807692307692307 | 23.79807692307692 | C206
p | C206 solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 4.730769230769226 | 4.730769230769226 | 4.730769230769226 | 5.913461538461542 | 4.730769230769231 | 4.730769230769231 | 29.56730769230768 | C206
p | BE76 dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 23.81538461538459 | 23.81538461538463 | 23.81538461538463 | 29.76923076923079 | 23.81538461538462 | 23.81538461538462 | 148.8461538461539 | BE76
p | BE76 solo |  | 0 | 0 | 0 | 0 | 0 | 0 | 2.07692307692308 | 2.07692307692308 | 2.076923076923078 | 2.596153846153846 | 2.076923076923077 | 2.076923076923077 | 12.98076923076924 | BE76
p | Citabria dual |  | 0 | 0 | 0 | 0 | 0 | 0 | 3.115384615384613 | 3.115384615384613 | 3.115384615384613 | 3.894230769230768 | 3.115384615384616 | 3.115384615384615 | 19.47115384615384 | Citabria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
P | Total flight hours |  | 0 | 0 | 0 | 0 | 0 | 0 | 387.0600000000001 | 387.0600000000002 | 387.0600000000002 | 483.8249999999999 | 387.0600000000001 | 387.0600000000001 | 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.0600000000001 | 387.0600000000002 | 387.0600000000002 | 483.8249999999999 | 387.0600000000001 | 387.0600000000001 | 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.0600000000001 | 387.0600000000002 | 387.0600000000002 | 483.8249999999999 | 387.0600000000001 | 387.0600000000001 | 2419.125
 | Aircraft - solo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | solo
 | Aircraft - dual |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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