Spreadsheet: 769355d1645495400-auto-populate-table-based-on-quantities-in-another-example-ryan1609-
Sheet: Sheet1

 | Aircraft # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. Service Charge / Month
2022-2023 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
April | 0 | 0
May | 0 | 0 | 0
June | 0 | 0 | 0 | 0 | 0
July | 0 | 0 | 0 | 0 | 0
August | 0 | 0 | 0 | 0 | 0 | 0.1
September | 0 | 0 | 0 | 0 | 0 | 0.1
October | 0.05 | 0.05 | 0 | 0 | 0 | 0.1 | 0.1
November | 0.05 | 0.05 | 0.05 | 0 | 0 | 0.1 | 0.1
December | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1
January | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1
February | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1
March | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1
Year Average
 | Aircraft # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. Service Charge / Month
2023/24 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
April | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
May | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
June | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
July | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
August | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
September | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
October | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
November | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
December | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
January | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
February | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
March | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
Year Average
 | Aircraft # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. Service Charge / Month
2022-2023 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
Year Average
 | Number of Aircraft
 |  | 2022/23 |  | 2023/24 |  |  |  |  |  |  |  | Aircraft # | Date Added | 0% End Date | 5% Eligible
 |  | Added | Total | Added | Total |  |  |  |  |  |  |  | 2022-04-01 00:00:00
 | April | 2 |  | 1 |  |  |  |  | Aircraft 1-5 | Aircraft 6+ |  |  | 2022-04-01 00:00:00
 | May | 1 |  | 1 |  |  |  | First 6 Months | 0 | 0.1 |  |  | 2022-05-01 00:00:00
 | June | 2 |  | 1 |  |  |  | Lifetime | 0.05 | 0.1 |  |  | 2022-06-01 00:00:00
 | July | 0 |  | 1 |  |  |  |  |  |  |  |  | 2022-06-01 00:00:00
 | August | 1 |  | 1 |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00
 | September | 0 |  | 1 |  |  |  |  |  |  |  |  | 2022-10-01 00:00:00
 | October | 1 |  | 1 |  |  |  |  |  |  |  |  | 2022-12-01 00:00:00
 | November | 0 |  | 1 |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 | December | 1 |  | 1 |  |  |  |  |  |  |  |  | 2023-04-01 00:00:00
 | January | 0 |  | 1 |  |  |  |  |  |  |  |  | 2023-05-01 00:00:00
 | February | 1 |  | 1 |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00
 | March | 0 |  | 1 |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 2024-03-01 00:00:00