Spreadsheet: 542443d1507856470-extracting-rows-based-on-user-input-example
Sheet: Model Inputs

Network Constrained Areas |  |  |  |  |  |  |  | Tariffs |  |  |  |  |  |  | [NAME] |  |  | Suburb
Suburb | Area | Suburb | Postcode | Total Demand Reduction | Cashback Incentive |  |  | Tariff Code | Tariff Description
Cannonvale | Cannonvale | Cannonvale | 4802 | 300 | 350 |  |  |  |  |  |  |  |  |  | >2000 |  |  | 4122
Cannonvale | Foxdale | Foxdale | 4800 | 300 | 350 |  |  |  |  |  |  |  |  |  | 500-2000 |  |  | 4105
Cannonvale | Paluma Road | Cannonvale | 4802 | 300 | 350 |  |  |  |  |  |  |  |  |  | 200-500 |  |  | 4077
Cannonvale | Strathdickie | Strathdickie | 4800 | 300 | 350 |  |  |  |  |  |  |  |  |  | 100-200 |  |  | 4178
Cannonvale | [NAME] | Cannonvale | 4802 | 300 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4060
[NAME] | Clifton Beach | Clifton Beach | 4879 | 1260 | 290 |  |  |  |  |  |  |  |  |  |  |  |  | 4694
[NAME] | Kewarra Beach | Kewarra Beach | 4879 | 1260 | 290 |  |  |  |  |  |  |  |  |  |  |  |  | 4131
[NAME] | [NAME] | Kuranda | 4881 | 1260 | 290 |  |  |  |  |  |  |  |  |  |  |  |  | 4113
[NAME] | Smithfield | Smithfield | 4878 | 1260 | 290 |  |  |  |  |  |  |  |  |  |  |  |  | 4050
Cairns South | Deeral | Deeral | 4871 | 580 | 272 |  |  |  |  |  |  |  |  |  |  |  |  | 4811
Cairns South | Hambledon | Edmonton | 4869 | 580 | 272 |  |  |  |  |  |  |  |  |  |  |  |  | 4743
Cairns South | Gordonvale | Gordonvale | 4865 | 580 | 272 |  |  |  |  |  |  |  |  |  |  |  |  | 4671
Cairns South | Gordonvale | Edmonton | 4869 | 580 | 272 |  |  |  |  |  |  |  |  |  |  |  |  | 4009
Cairns South | Riverstone Rd | Gordonvale | 4865 | 580 | 272 |  |  |  |  |  |  |  |  |  |  |  |  | 4172
Chinchilla N | North St | [NAME] | 4413 | 200 | 70 |  |  |  |  |  |  |  |  |  |  |  |  | 4702
[NAME] | Sourth Rd | [NAME] | 4413 | 200 | 70 |  |  |  |  |  |  |  |  |  |  |  |  | 4006
Chincholla | Cooper Street | [NAME] | 4413 | 200 | 70 |  |  |  |  |  |  |  |  |  |  |  |  | 4306
Emerald | [NAME] | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4352
Emerald | North | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4183
Emerald | Foleys Rd | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4718
Emerald | [NAME] | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4008
Emerald | Hospital Rd | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4709
Emerald | Rolleston | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4215
Emerald | Springsure | Emerald | 4720 | 500 | 225 |  |  |  |  |  |  |  |  |  |  |  |  | 4101
Townsville | [NAME] | Mount Louisa | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4741
Townsville | [NAME] | Hervey Range | 4817 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4816
Townsville | [NAME] | Townsville | 4817 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4805
Townsville | Garbutt | Garbutt | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4301
Townsville | Garbutt | Currajong | 4812 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4102
Townsville | [NAME] | Garbutt | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4031
Townsville | [NAME] | Kirwan | 4817 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4804
Townsville | [NAME] | Garbutt | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4615
Townsville | [NAME] | Garbutt | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4218
Townsville | [NAME] | Kirwan | 4817 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4110
Townsville | Bohle 05 | Mount Louisa | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4207
Townsville | Bohle 07 | Mount Louisa | 4814 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4213
Townsville | Bohle 10 | Shaw | 4818 | 680 | 350 |  |  |  |  |  |  |  |  |  |  |  |  | 4001
Mackay Northern Beaches |  | Rural View | 4740 | 550 | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 4226
Mackay Northern Beaches |  | Bucasia | 4750 | 550 | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 4000
Mackay Northern Beaches |  | Beaconsfield | 4740 | 550 | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 4305
Mackay Northern Beaches |  | Eimeo | 4740 | 550 | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 4701
Mackay Northern Beaches |  | Blacks Beach | 4740 | 550 | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 4304
Mackay Northern Beaches |  | Andergrove | 4740 | 550 | 200 |  |  |  |  |  |  |  |  |  |  |  |  | 4225
Mackay Northern Beaches |  | Paget | 4740 | 1480 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 4170
Mackay Northern Beaches |  | Ooralea | 4740 | 1480 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 4064
Mackay Northern Beaches |  | Paget | 4740 | 1480 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 4650
Mackay Northern Beaches |  | Ooralea | 4740 | 1480 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 4217
Mackay Northern Beaches |  | Paget | 4740 | 1480 | 300 |  |  |  |  |  |  |  |  |  |  |  |  | 4032
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4111
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4066
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4814
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4717
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4012
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4347
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4013
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4157
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4510
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4115
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4109
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4870
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4570
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4802
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4210
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4216
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4036
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4350
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4560
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4224
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4108
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4014
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4300
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4506
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4556
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4174
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4610
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4558
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4719
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4370
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4670
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4132
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4059
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4114
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4285
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4715
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4034
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4075
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4076
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4209
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4680
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4053
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4163
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4575
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4030
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4564
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4514
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4029
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4128
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4212
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4509
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4121
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4655
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4343
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4341
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4503
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4695
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4880
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4127
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4877
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4211
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4165
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4519
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4161
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4810
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4116
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4220
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4581
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4159
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4208
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4151
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4223
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4054
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4073
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4309
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4169
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4812
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4230
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4501
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4551
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4129
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4740
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4152
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4504
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4703
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4017
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4173
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4074
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4566
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4699
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4868
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4557
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4507
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4815
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4035
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4659
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4107
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4133
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4745
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4069
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4280
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4124
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4356
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4179
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4621
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4385
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4078
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4818
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4221
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4817
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4737
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4508
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4051
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4871
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4505
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4873
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4573
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4019
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4405
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4037
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4869
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4854
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4561
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4214
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4567
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4511
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4750
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4103
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4311
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4119
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4807
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4850
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4878
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4061
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4565
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4070
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4563
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4357
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4553
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4018
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4205
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4515
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4068
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4751
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4219
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4310
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4574
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4390
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4171
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4380
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4605