Spreadsheet: 800029d1665451090-sum-the-total-of-3-separate-if-statements-excel-query-rev1
Sheet: CES

 | 2022-09-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Base Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HRs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | based on 10 hr day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Days | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weeks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Months | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Construction Equipment Cost (AUD$)
 | FORMULA | UPDATE | FORMULA | UPDATE | FORMULA | FORMULA | UPDATE | UPDATE | UPDATE | UPDATE | UPDATE | UPDATE | FORMULA | FORMULA | FORMULA | UPDATE | FORMULA | UPDATE | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA |  | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA |  | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA | FORMULA
 |  |  |  | SABR-Plant List & Fuel Consumption |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shutdown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shutdown
X | Status | P&E ID | Plant No | Equipment | Vendor | Type | Pricing Schedule | Pricing Schedule (Equip No.) | Plan / Forecast | Hire/ Owned/ Purchased | Rate / ST&C | Site Location | Total number of equipment | Mob Date | Demob Date | UOM Days, Weeks, months | Duration | # Mob/ Demob | Mob | Demob | Total Mob/Demob Cost | Unit Price | Total Unit Price | Total Price | X | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | Total Unit Qty | X | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | Total | check | X
1 |  | PE-H-001 |  |  |  |  | B.08-3 | 19 | Forecast | Hired | Rate |  |  |  |  | Days |  | 1
1 |  | PE-H-025 |  |  |  |  | B.08-3 | 19 | Forecast | Hired | Rate |  |  |  |  | Days |  | 1
1 |  | PE-H-146 |  |  |  |  | B.08-3 | 19 | Forecast | Hired | Rate |  |  |  |  | Weeks |  | 1
1 |  | PE-H-147 |  |  |  |  | B.08-3 | 19 | Forecast | Hired | Rate |  |  |  |  | Weeks |  | 1