Spreadsheet: 137711d1327331320-conditional-formatting-help-copy-of-excel-help1-1
Sheet: CONTACTS

Ref No. | STATUS | TYPE OF SYSTEM | NAME | ADDRESS 1 | ADDRESS 2 | POSTCODE | SURVEY DATE | PHONE N0 1 | PHONE NO 2 | MOBILE | [NAME] | ORENTATION | PITCH | PVGIS SCORE | NO. PANELS | PRICE | WHERE DID U FIND US? | INSTALL DATE | SALES MAN | Column1 | Column20 | Column21 | Column22 | Column23 | Column24
01/001 |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FREE SOLAR PV | REFFERED BY FRIEND | COLIN B | SOUTH | HORIZONTAL | 4
01/002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOLAR PV | GOOGLE ADS | DAN B | SE | 30 DEG | 5
01/003 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOLAR HW THERMAL | ROBYN SALES | COLIN P | EAST | 45 DEG | 6
01/004 |  |  |  |  |  |  |  |  |  |  |  |  |  | 944 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOLAR PV & HW | ADY SALES | ADRIAN | EW | VERTICAL | 7
01/005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PV FREE OR PAID | FACEBOOK |  | WEST |  | 8
01/006 |  |  |  |  |  |  |  |  |  |  |  |  |  | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FACEBOOK ADS |  | SW |  | 9
01/007 |  |  |  |  |  |  |  |  |  |  |  |  |  | 878 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COL SALES |  | NORTH |  | 10
01/008 |  |  |  |  |  |  |  |  |  |  |  |  |  | 937 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAN SALES |  | NW |  | 11
01/009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LEAD OPTIONS |  | NE |  | 12
01/010 |  |  |  |  |  |  |  |  |  |  |  |  |  | 851 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
01/011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
01/012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
01/013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
01/014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
01/015 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
01/016 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
01/017 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
01/018
01/019
01/020 |  |  |  |  |  |  |  |  |  |  |  |  |  | 936
01/021 |  |  |  |  |  |  |  |  |  |  |  |  |  | 822
01/022
01/023 |  |  |  |  |  |  |  |  |  |  |  |  |  | 936 | 16
01/024
01/025 |  |  |  |  |  |  |  |  |  |  |  |  |  | 732
01/026 |  |  |  |  |  |  |  |  |  |  |  |  |  | 877 | 10
01/027
01/028 |  |  |  |  |  |  |  |  |  |  |  |  |  | 934
01/029
01/030
01/031
01/032 |  |  |  |  |  |  |  |  |  |  |  |  |  | 886
01/033
01/034
01/035 |  |  |  |  |  |  |  |  |  |  |  |  |  | 821
01/036
01/037 |  |  |  |  |  |  |  |  |  |  |  |  |  | 853
01/038
01/039 |  |  |  |  |  |  |  |  |  |  |  |  |  | 936 | 10
01/040
01/041
01/042
01/043
[NAME]
01/045
01/046
01/047
01/048
01/049
01/050
01/051
01/052
01/053
01/054
01/055
01/056
01/057
01/058
01/059
01/060
01/061
01/062
[NAME]
01/064
01/065
01/066
01/067
01/068
01/069
01/070
01/071
01/072
01/073
01/074
01/075
01/076
01/077
01/078
01/079
01/080
01/081
01/082
01/083
01/084
01/085
01/086
01/087
01/088
01/089
01/090
01/091
01/092
01/093
01/094
01/095
01/096
01/097
01/098
01/099
01/100
01/101
01/102
01/103
01/104
01/105
01/106
01/107
01/108
01/109
01/110
01/111
01/112
01/113
01/114
01/115
01/116
01/117
01/118
01/119
01/120
01/121
01/122
01/123
01/124
01/125
01/126
01/127
01/128
01/129
01/130
01/131
01/132
01/133
01/134
01/135
01/136
01/137
[NAME]
01/139
01/140
01/141
01/142
01/143
01/144
01/145
01/146
01/147
01/148
01/149
01/150
01/151
01/152
01/153
01/154
01/155
01/156
01/157
01/158
01/159
01/160
01/161
01/162
01/163
01/164
01/165
01/166
01/167
01/168
01/169
01/170
01/171
01/172
01/173
01/174
01/175
01/176
01/177
01/178
01/179
01/180
01/181
01/182
01/183
01/184
01/185
01/186
01/187
01/188
01/189
01/190
01/191
01/192
01/193
01/194
01/195
01/196
01/197
01/198
01/199
01/200
01/201
01/202
01/203
01/204
01/205
01/206
01/207
01/208
01/209
01/210
01/211
01/212
01/213
01/214
01/215
01/216
01/217
01/218
01/219
01/220
01/221
01/222
01/223
01/224
01/225
01/226
[NAME]
01/228
01/229
01/230
01/231
01/232
01/233
01/234
01/235
01/236
01/237
01/238
01/239
01/240
01/241
01/242
01/243
01/244
01/245
01/246
01/247
01/248
01/249
01/250
01/251
01/252
01/253
01/254
01/255
01/256
01/257
01/258
01/259
01/260
01/261
01/262
01/263
01/264
01/265
01/266
01/267
01/268
01/269
01/270
01/271
01/272
[NAME]
01/274
01/275
01/276
01/277
01/278
01/279
01/280
01/281
01/282
01/283
01/284
01/285
01/286
01/287
01/288
01/289
01/290
01/291
01/292
01/293
01/294
01/295
01/296
01/297
01/298
01/299
01/300
01/301
01/302
01/303
01/304
01/305
01/306
01/307
01/308
01/309
01/310
01/311
01/312
01/313
01/314
01/315
01/316
01/317
01/318
01/319
01/320
01/321
01/322
01/323
01/324
01/325
01/326
[NAME]
01/328
01/329
01/330
01/331
01/332
01/333
01/334
01/335
01/336
01/337
01/338
01/339
01/340
01/341
01/342
01/343
01/344
01/345
01/346
01/347
01/348
01/349
[NAME]
01/351
01/352
01/353
01/354
01/355
01/356
01/357
01/358
01/359
01/360
01/361
01/362
01/363
01/364
01/365
01/366
01/367
01/368
01/369
01/370
01/371
01/372
01/373
01/374
01/375
01/376
01/377
01/378
01/379
01/380
01/381
01/382
01/383
01/384