Spreadsheet: 542027d1507677175-help-filtering-data-help
Sheet: Sheet1

ID | Account_Name | Start Date | End Date | Hours | Zone | NMI Class | PREM_CTC | Retail Tariff | Energy Consumption | kW | Network Consumption | Retail Tariff Revenue | Demand | LGA_NAME | REGION | DISTRICT | ANZSIC_DIV_Code_F | ANZSIC_DIV_Desc_F | ANZSIC_CODE_F | ANZSIC_DESC_F
[PHONE] | [NAME] | 2017-04-04 00:00:00 | 2017-05-02 00:00:00 |  | E | SMALL | Low | 21 | 1000 |  | 0 | 20.04 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Car
[PHONE] | [NAME] | 2017-05-03 00:00:00 | 2017-06-01 00:00:00 |  | E | SMALL | Low | 21 | 2000 |  | 0 | 20.73 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Car
[PHONE] | [NAME] | 2017-01-04 00:00:00 | 2017-02-01 00:00:00 |  | E | SMALL | Low | 21 | 3000 |  | 0 | 20.04 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Car
[PHONE] | [NAME] | 2017-02-02 00:00:00 | 2017-03-02 00:00:00 |  | E | SMALL | Low | 21 | 5000 |  | 0 | 20.04 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Car
[PHONE] | [NAME] | 2017-03-03 00:00:00 | 2017-04-03 00:00:00 |  | E | SMALL | Low | 21 | 8000 |  |  | 22.11 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Car
[PHONE] | [NAME] | 2017-04-04 00:00:00 | 2017-05-02 00:00:00 |  | E | SMALL | Low | 21 | 3000 |  | 0 | 20.04 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Boat
[PHONE] | [NAME] | 2017-03-03 00:00:00 | 2017-04-03 00:00:00 |  | E | SMALL | Low | 21 | 6000 |  | 0 | 22.11 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Boat
[PHONE] | [NAME] | 2017-01-04 00:00:00 | 2017-02-01 00:00:00 |  | E | SMALL | Low | 21 | 7000 |  | 0 | 20.04 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Boat
[PHONE] | [NAME] | 2017-02-02 00:00:00 | 2017-03-02 00:00:00 |  | E | SMALL | Low | 21 | 4000 |  | 0 | 20.04 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Boat
[PHONE] | [NAME] | 2017-05-03 00:00:00 | 2017-06-01 00:00:00 |  | E | SMALL | Low | 21 | 3500 |  | 0 | 20.73 |  | [NAME] | NR | FN | O | Public Administration and Safety | 7720 | Boat
[PHONE] | [NAME] | 2016-06-02 00:00:00 | 2016-06-30 00:00:00 |  | E | LARGE | High | 20L | 17162.2 |  | 0 | 5315.58 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2017-01-04 00:00:00 | 2017-02-01 00:00:00 |  | E | LARGE | High | 20L | 26525 |  | 0 | 9288.55 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-09-02 00:00:00 | 2016-10-04 00:00:00 |  | E | LARGE | High | 20L | 21461 |  | 0 | 7522.04 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-12-02 00:00:00 | 2017-01-03 00:00:00 |  | E | LARGE | High | 20L | 27283 |  | 0 | 9556.25 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-11-02 00:00:00 | 2016-12-01 00:00:00 |  | E | LARGE | High | 20L | 25515 |  | 0 | 8936.37 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2017-05-03 00:00:00 | 2017-06-01 00:00:00 |  | E | LARGE | High | 20L | 19067 |  | 0 | 6683.44 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2017-04-04 00:00:00 | 2017-05-02 00:00:00 |  | E | LARGE | High | 20L | 19845 |  | 0 | 6954.55 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-05-04 00:00:00 | 2016-06-01 00:00:00 |  | E | LARGE | High | 20L | 20223 |  | 0 | 6260.33 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 |  | E | LARGE | High | 20L | 591.8 |  | 0 | 207.48 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-10-05 00:00:00 | 2016-11-01 00:00:00 |  | E | LARGE | High | 20L | 20551 |  | 0 | 7200.52 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2017-02-02 00:00:00 | 2017-03-02 00:00:00 |  | E | LARGE | High | 20L | 26586 |  | 0 | 9309.86 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-08-02 00:00:00 | 2016-09-01 00:00:00 |  | E | LARGE | High | 20L | 16608 |  | 0 | 5824.98 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2017-03-03 00:00:00 | 2017-04-03 00:00:00 |  | E | LARGE | High | 20L | 29621 |  | 0 | 10372.44 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
[PHONE] | [NAME] | 2016-07-02 00:00:00 | 2016-08-01 00:00:00 |  | E | LARGE | High | 20L | 16460 |  | 0 | 5773.26 |  | [NAME] | NR | FN | N | Administrative and Support Services | 7220 | Bike
 |  |  |  |  |  |  | Rows I need to pull out