Help Using COUNTIFS Function

GRECOR · Oct 26, 2016

I have the following table that contains all the data.

<colgroup><col style="mso-width-source:userset;mso-width-alt:2588;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:11264;width:238pt" width="317"> <col style="mso-width-source:userset;mso-width-alt:2360;width:50pt" width="66"> <col style="mso-width-source:userset;mso-width-alt:4807;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:3612;width:76pt" width="102"> <col style="mso-width-source:userset;mso-width-alt:2588;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:1592;width:34pt" width="45"> <col style="mso-width-source:userset;mso-width-alt:6001;width:127pt" width="169"> </colgroup><tbody>
[TD="class: xl65, width: 73"]Network[/TD]
[TD="class: xl65, width: 317"]Network Header Description[/TD]
[TD="class: xl65, width: 66"]Activity[/TD]
[TD="class: xl65, width: 135"]Header User Status[/TD]
[TD="class: xl65, width: 102"]Earliest Finish[/TD]
[TD="class: xl65, width: 73"]Work ctr[/TD]
[TD="class: xl65, width: 45"]Plnt[/TD]
[TD="class: xl76, width: 169"]Dstr_Notes[/TD]

[TD="class: xl66"]2597530[/TD]
[TD="class: xl66"]K01:MRWN:RDMV:TEMP:2014895:F-10N F-CARGI[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/07/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans
[/TD]

[TD="class: xl66"]2600279[/TD]
[TD="class: xl66"]L01:MYTP:RDMV:TEMP:2016206:C54-5 54-6 HW[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2602129[/TD]
[TD="class: xl66"]K01:HRTY:RDMV:TEMP:2016185:C11-8 C11-12[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2602217[/TD]
[TD="class: xl66"]M01:LEGL:RDMV:DTP:HWY651 & TWP 580[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans.[/TD]

[TD="class: xl66"]2604269[/TD]
[TD="class: xl66"]K01:DYLD:RDMV:TEMP:2016187:C-1 C3-1 RGE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2604888[/TD]
[TD="class: xl66"]K01:LCRT:RDMV:TEMP:2016204:94 AVE 100ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/02/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2606660[/TD]
[TD="class: xl66"]K01:PLDN:RDMV:TEMP:ZNOC:2016224:A8-13 A1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS READ[/TD]
[TD="class: xl67"]09/12/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2607329[/TD]
[TD="class: xl66"]K01:DXVL:RDMV:TEMP:2016207:RTE E-7,E-8 H[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/07/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2607357[/TD]
[TD="class: xl66"]K01:PCRV:RDMV:TEMP:2016219:A4-8 A4-7 RGE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/07/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2607962[/TD]
[TD="class: xl66"]K01:HILV:RDMV:DTP:HWY35[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]14/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans
[/TD]

[TD="class: xl66"]2608148[/TD]
[TD="class: xl66"]K01:HRHL:RDMV:TEMP:2016191:C 19 C 22 NEW[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2608249[/TD]
[TD="class: xl66"]K01:MNNG:RDMV:TEMP:2016220:B75 B78 HWY 7[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]22/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2608297[/TD]
[TD="class: xl66"]M01:MLWD:RDMV:DTP:DICW TEMP:2611018 89 S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/08/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2608790[/TD]
[TD="class: xl66"]K01:PCRV:ZNOC:RDMV:TEMP:2016240:H18-6 H3[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]18/10/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2608976[/TD]
[TD="class: xl66"]M01:SPGV:ZNOR:DTP:Grove Drive/Harvest Ri[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2609637[/TD]
[TD="class: xl66"]M01:DRVY:RDMV:TEMP:2016329:A-29 A-44 A26[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/06/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2609818[/TD]
[TD="class: xl66"]M01:SPGV:RDMV:TEMP:2016238:B2-P3 B2-P4 S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/07/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2610191[/TD]
[TD="class: xl66"]K01:SPRV:RDMV:TEMP:2016196:A31-61 A31-61[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/02/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2610576[/TD]
[TD="class: xl66"]M01:WTKW:RDMV:TEMP:2016260:28-16 D44-1 R[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2610786[/TD]
[TD="class: xl66"]K01:NMPA:ZNOC:RDMV:TEMP:2016241:A9-1 A9-[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/04/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2611027[/TD]
[TD="class: xl66"]K01:WLOC:RDMV:DTP:HWY 44/TR 602 & TR 611[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/04/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2611179[/TD]
[TD="class: xl66"]K01:ATBC:ZNOC:RDMR:TEMP:2016257:C43-1 C4[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2611306[/TD]
[TD="class: xl66"]K01:HIPR:RDMV:TEMP:2016222:B48-3 HWY 2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]25/07/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans
[/TD]

[TD="class: xl66"]2612023[/TD]
[TD="class: xl66"]K01:GDPR:RDMV:TEMP:2016225:E3 E4 132 AVE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/08/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2612240[/TD]
[TD="class: xl66"]K01:FXCK:RDMV:TEMP:2016265:D-17A BIG STO[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2612247[/TD]
[TD="class: xl66"]M01:HITN:RDMV:TEMP:2016226:R-SW36 R-NW35[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]18/08/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2612284[/TD]
[TD="class: xl66"]M01:DRVY:RDMV:TEMP:2016242:D-52 D18-9 RG[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]20/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2612972[/TD]
[TD="class: xl66"]M01:ROBB:RDMV:TEMP:2016237:A9-18 A9-2 HW[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/08/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2612984[/TD]
[TD="class: xl66"]K01:SLVY:RDMV:TEMP:2016258:B-1 B-2 HWY 6[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/04/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2613363[/TD]
[TD="class: xl66"]M01:BOYL:RDMV:TEMP:2016245:B26-10A B26-1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]28/07/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2613542[/TD]
[TD="class: xl66"]L01:JRVE:RDMV:DTP:Intersection Hwy 44 &[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2613581[/TD]
[TD="class: xl66"]L01:WLOC:RDMV:DTP:HWY 44/TR 612 & HWY 66[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]17/08/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2613688[/TD]
[TD="class: xl66"]K01:LDGP:DTP:HWY 753/620 Intersection[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2613747[/TD]
[TD="class: xl66"]K01:VRML:RDMV:TEMP:2016261:B48-4 B48-8 T[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2613791[/TD]
[TD="class: xl66"]K01:WOKG:RDMV_PERM:290248:RTE B6&B7 RR52[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2614867[/TD]
[TD="class: xl66"]K01:DXVL:RDMV:TEMP:2016264:E7 E8 FIBRE C[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]18/10/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2614978[/TD]
[TD="class: xl66"]L01:STPL:RDMV:TEMP:2016262:D13 24 D20 2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2615363[/TD]
[TD="class: xl66"]L01:GLND:RDMV:TEMP:2016263:C10 C11 B15 t[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2615401[/TD]
[TD="class: xl66"]K01:LBCH:RDMV:DTP:LAKEVIEW ESTATES[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/04/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2615738[/TD]
[TD="class: xl66"]M01:DRVY:RDMV:TEMP:2016268:A14-10 A30-2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2615992[/TD]
[TD="class: xl66"]K01:NMPA:ZNOC:RDMV:TEMP:2016272:A5-2 A5-[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS READ[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2616454[/TD]
[TD="class: xl66"]K01:HYTH:RDMV:DTP:INTERSECTION OF HWY723[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/05/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2616528[/TD]
[TD="class: xl66"]K01:ADSN:RDMV:TEMP:2016299:EC2-7A EC2-9[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]31/10/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2616560[/TD]
[TD="class: xl66"]L01:BRHD:ZNOC:RDMV:TEMP:2016303:C1-1 C1-[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS READ[/TD]
[TD="class: xl66"]28/10/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2616804[/TD]
[TD="class: xl66"]L01:BRTN:RDMV:TEMP:2016289:C15-6 C16-2 T[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]31/10/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2619193[/TD]
[TD="class: xl66"]M01:EVBG:ZNOC:RDMV:TEMP:2016300:A5-18 A5[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]11/04/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2618378[/TD]
[TD="class: xl66"]K01:DXVL:RDMV_PERM:2614867:2607329:RTE E[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]21/11/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2618479[/TD]
[TD="class: xl66"]K01:HILV:RDMV:DTP:HWY 35 N of BOYER TOWE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS CANC[/TD]
[TD="class: xl66"]21/11/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2619289[/TD]
[TD="class: xl66"]KO1:LBCH:ZNOC:RDMV:TEMP:2016306:A2-6 A29[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]24/10/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2619682[/TD]
[TD="class: xl66"]K01:VYVW:RDMV:DTP:B14-7 TO B14-8 HWY 747[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]11/02/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2619936[/TD]
[TD="class: xl66"]K01:BRLG:RDMV:TEMP:2016320 C4-4 C68-2 RG[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]25/11/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2619988[/TD]
[TD="class: xl66"]K01:NNRY:RDMV:DTP:Sec Hwy 611 C15-11 to[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]25/11/2016[/TD]
[TD="class: xl66"]708246DS[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Spatial Net Trans[/TD]

[TD="class: xl66"]2505248[/TD]
[TD="class: xl66"]T_H:ESGT:CPRD:1737998:BURNCO[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]18/07/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2508380[/TD]
[TD="class: xl66"]M01:MLWD:ACPM-1989-Batch-10:SSO/SFIB:Wal[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]19/09/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2510442[/TD]
[TD="class: xl66"]M01:SWPK:ACPM-2019-Batch-10:SSO/SFIB:319[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]20/09/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2521790[/TD]
[TD="class: xl66"]K09:CZAR:RDMV:PERM:#290013:B-P35-B-P42[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]14/10/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2577386[/TD]
[TD="class: xl66"]NCD:ATBC:BLD_ENT:ZNOR_B:BOSTON_PIZZA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl67"]07/04/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2578197[/TD]
[TD="class: xl66"]BSB:CMRS:ZNOR:BLD_ENT:WINMAR[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]30/05/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2583129[/TD]
[TD="class: xl66"]PSP:BLD_ENT:FTSK:ZNOR:TRIMAC[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl67"]04/01/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2526074[/TD]
[TD="class: xl66"]DXH:SOKE:FTTS:ACPM0547-B:HARBOURVIEW DEV[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS READ[/TD]
[TD="class: xl67"]06/03/2016[/TD]
[TD="class: xl66"]DSOPENG[/TD]
[TD="class: xl66"]9516[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2541054[/TD]
[TD="class: xl66"]K01:BNNZ;RDMV:PERM: #290249:RTES B92,B17[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]08/11/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2545976[/TD]
[TD="class: xl66"]SKU:FTMM:CPRD:2599512:FOTS_ACC:135MACKAY[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]18/07/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]DESIGN STATE TRANSLATE[/TD]

[TD="class: xl66"]2558917[/TD]
[TD="class: xl66"]KTA:FTMM:ENT:ZNOR:B:METIS FTMCKAY[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl67"]07/04/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2568176[/TD]
[TD="class: xl66"]RRM:DBLT:ENT:ZNOC:B:Fire Hall[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/08/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2569126[/TD]
[TD="class: xl66"]RRM:RDER:ENT:ZNOC:B:loonRvr P277 2524455[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl67"]07/06/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2571855[/TD]
[TD="class: xl66"]PWH:WGTN:P277:CABLE RELIEF JEEVANS RD[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/02/2016[/TD]
[TD="class: xl66"]DSOPENG[/TD]
[TD="class: xl66"]9516[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2575697[/TD]
[TD="class: xl66"]O09:LCMB:ENT:ZNOR:B:RCMP 3906 53 Av[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9523[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2577113[/TD]
[TD="class: xl66"]SKU:FTMM:OP:RDMV PERM HWY63 HILL SLIDE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]08/04/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2583455[/TD]
[TD="class: xl66"]BSB:SDWK:ZONR:ENT:ARNETT&BURGESS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2585369[/TD]
[TD="class: xl66"]JLJ:CDLK:CPRD::2384016:ATCO[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]15/04/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]DESIGN STATE TRANSLATE IMAGE[/TD]

[TD="class: xl66"]2585856[/TD]
[TD="class: xl66"]R_P:MLWD:CPRD:2610075:Lincolnberg[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2587838[/TD]
[TD="class: xl66"]M_W:LEDC:B:ENT:ZNOR:B:102 SouthforkDr[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl66"]20/04/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2588876[/TD]
[TD="class: xl66"]BSB:CMRS:ZNOR:BLD_ENT:ROSEALTALODGE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]06/03/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2589180[/TD]
[TD="class: xl66"]R_P:NSKU:CPRD:2631617:DaveyTree[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]15/04/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2589874[/TD]
[TD="class: xl66"]ASJ:SPGV:ZNOR:B:VICWEST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl67"]04/06/2016[/TD]
[TD="class: xl66"]DSOPGES[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans[/TD]

[TD="class: xl66"]2596424[/TD]
[TD="class: xl66"]JLJ:GDCT:ZNOC:HWY 28 WIDENING[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]10/05/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]DESIGN STATE TRANSLATE IMAGE[/TD]

[TD="class: xl66"]2603574[/TD]
[TD="class: xl66"]NCD:LBCH:BLD_ENT:ZNOR_B:MacArthur[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2607808[/TD]
[TD="class: xl66"]PSP:GRLD:DS1:CPRD2824141:Arrow_Transport[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]22/09/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2592037[/TD]
[TD="class: xl66"]KTA:FTMM:DTP:ZNOC:RBLD: HWY 63-69[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP BILL[/TD]
[TD="class: xl67"]10/12/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2614779[/TD]
[TD="class: xl66"]NJP:FTSK:DS3_CUST:CPRD2747959:FRONTEIR[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]28/09/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2616442[/TD]
[TD="class: xl66"]BSB:EGTN:ZNOR:BLD_ENT:VILLAGEOFEDGERTON[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]19/08/2016[/TD]
[TD="class: xl66"]DSOPGEE[/TD]
[TD="class: xl66"]9522[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2603370[/TD]
[TD="class: xl66"]C_B:VYVW:ZNOR:B:MINHAS CRU[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2604876[/TD]
[TD="class: xl66"]H01:MSSN:ACPM1780:33815 CherryAve 10/07[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPENG[/TD]
[TD="class: xl66"]9517[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2606438[/TD]
[TD="class: xl66"]KTA:FTMM:ZNOR:B:360&370 FALCONERCRESCENT[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]29/09/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2609040[/TD]
[TD="class: xl66"]NJT:GDPR:FOTS:CPRD:2631616:IPAC[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2611091[/TD]
[TD="class: xl66"]H01:SRDS:GPON:ACPM3434: Lindys Apt 09/23[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]13/10/2016[/TD]
[TD="class: xl66"]DSOPENG[/TD]
[TD="class: xl66"]9517[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2612574[/TD]
[TD="class: xl66"]C_B:GDCH:CPRD:2820510:GCNET JAIL[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]21/10/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2613530[/TD]
[TD="class: xl66"]C_B:GDPR:CPRD:2812690:BELL-AQUATERA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]13/10/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2613555[/TD]
[TD="class: xl66"]RRM:HIPR:BLD_ENT:ZNOR:B:Peavy Mart[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]18/10/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2614053[/TD]
[TD="class: xl66"]B13:TRRC:ACPM2423-B:SUBD:TRRC HTGS 11/10[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]14/10/2016[/TD]
[TD="class: xl66"]DSOPENG[/TD]
[TD="class: xl66"]9502[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2614822[/TD]
[TD="class: xl66"]BRW:FTMM:RBLD:Material only network[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS HOLD[/TD]
[TD="class: xl66"]13/10/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design state translate[/TD]

[TD="class: xl66"]2614907[/TD]
[TD="class: xl66"]BRW:FTMM:RBLD:FIRE:Extend drop conduits[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2615600[/TD]
[TD="class: xl66"]C_B:GDPR:CPRD:2819963:PETROWEST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]21/10/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9520[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2616881[/TD]
[TD="class: xl66"]AVT:NWMR:BLD_ENT:ZNOR:B:415 BOYNE 9/30[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/07/2016[/TD]
[TD="class: xl66"]DSOPENG[/TD]
[TD="class: xl66"]9517[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2617042[/TD]
[TD="class: xl66"]SKU:FTMM:LINE_RBLD:WATERWAYS LEGION RECO[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/11/2016[/TD]
[TD="class: xl66"]DSOPGEN[/TD]
[TD="class: xl66"]9521[/TD]
[TD="class: xl77, width: 169"]DESIGN STATE TRANSLATE[/TD]

[TD="class: xl66"]2535020[/TD]
[TD="class: xl66"]RGB:RTLD:COND REPAIR:1241 IRENE CRT[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]12/07/2016[/TD]
[TD="class: xl66"]DSDRAFTR[/TD]
[TD="class: xl66"]9535[/TD]
[TD="class: xl77, width: 169"]Design State Translation (Image)[/TD]

[TD="class: xl66"]2617130[/TD]
[TD="class: xl66"]SKI:RTLD:RELOC:KELOWNA AIRPORT10/24[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]28/11/2016[/TD]
[TD="class: xl66"]DSDRAFTR[/TD]
[TD="class: xl66"]9535[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2572130[/TD]
[TD="class: xl66"]P01:SBLD:RDMV:PERM:280156:A1-15 to A1-17[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/12/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2578283[/TD]
[TD="class: xl66"]GAB:MDHT:CPRD:2595973:CPI CAN INC[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/04/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2585495[/TD]
[TD="class: xl66"]RDT:PCBT:JUSU:ZNOR:ACPM 2724:SUNSET (27)[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2590472[/TD]
[TD="class: xl66"]Q01:LTBR:SSO:ACPM 3507:GARRY STN W PH4[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/04/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2491533[/TD]
[TD="class: xl66"]DRR:MDHT:PON DUCT FOR DSA 205-1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RACK[/TD]
[TD="class: xl66"]19/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2505217[/TD]
[TD="class: xl66"]P01:MDHT:RDMV TEMP:F-4 to F-19,F8-1,F18-[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]13/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2509349[/TD]
[TD="class: xl66"]GAB:BRKS:BBB:ALU 7330 TO DSA 104-1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]15/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2511345[/TD]
[TD="class: xl66"]GAB:RLTN:MOBILITY:AB0461[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]19/08/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2515231[/TD]
[TD="class: xl66"]GAB:BRKS:SSO/SFIB:PON:2AVE 19 LOTS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]19/09/2016[/TD]
[TD="class: xl66"]DSOPENM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2517191[/TD]
[TD="class: xl66"]GAB:RLTN:ZNOR:BLD_ENT:NATURAL ENERGY[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2525052[/TD]
[TD="class: xl66"]GAB:BRKS:BBB:ALU 7330 TO DSA 202-3[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/12/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2529829[/TD]
[TD="class: xl66"]DRR:MDHT:RBLD:MAPLE AV BRIDGE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]15/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2531471[/TD]
[TD="class: xl66"]DRR:MDHT:ZNOR:STHLND RESUBDVSN 13 LOTS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS BILL[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2531696[/TD]
[TD="class: xl66"]GAB:ACVY:BLD_ENT:SKAPPAKS FARMS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl67"]09/01/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2542038[/TD]
[TD="class: xl66"]GAB:DELI:CPRD:1876375:NAV CANADA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2543440[/TD]
[TD="class: xl66"]GAB:BRKS:CPRD:2093035/2093015:NAV CANADA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]25/07/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2543584[/TD]
[TD="class: xl66"]KEN:MDHT:SUBD:ZNOR:WEST RDG EST:12 LTS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2549129[/TD]
[TD="class: xl66"]DRR:MDHT:ENT:CRPD:2164755:MED HAT CO-OP[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]19/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2551193[/TD]
[TD="class: xl66"]DRR:MDHT:FIB:FIBRES INTO MED HAT LODGE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]21/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2552748[/TD]
[TD="class: xl66"]DRR:MDHT:ENT:ZNOR:370 KIPLING ST SE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]15/08/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2555131[/TD]
[TD="class: xl66"]GAB:BRKS:CPRD:2330744:Big Country Energ[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]21/09/2016[/TD]
[TD="class: xl66"]DSOPENM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2557375[/TD]
[TD="class: xl66"]DRR:MDHT:MFU:ZNOR:29 DIVISION AV S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2559769[/TD]
[TD="class: xl66"]GAB:BRKS:CPRD:2378399:Fortis Alberta[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2561516[/TD]
[TD="class: xl66"]GAB:HANN:ZNOR:BLD_ENT:TIM HORTONS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2564588[/TD]
[TD="class: xl66"]GAB:OYEN:CPRD:1172204:GOA OYEN TOWER SIT[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2566840[/TD]
[TD="class: xl66"]Q01:EKWR:CPRD:2372335:T1 TO TOWER SITE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2574549[/TD]
[TD="class: xl66"]DRR:MDHT:ENT:ZNOR: STATE & MAIN REST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2576477[/TD]
[TD="class: xl66"]P01:DCHS:RDMV:PERM:A9-6 A9-8[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]08/04/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2580846[/TD]
[TD="class: xl66"]DRR:MDHT:RBLD:ZNOR: 620-2 ST SE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]29/08/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2581725[/TD]
[TD="class: xl66"]GAB:BRKS:CPRD:2585228 :AT&T GLOBAL SERVI[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]28/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans[/TD]

[TD="class: xl66"]2585932[/TD]
[TD="class: xl66"]GAB:BRKS:CPRD:2425276 :VERIZON / BS USA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]28/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans[/TD]

[TD="class: xl66"]2590738[/TD]
[TD="class: xl66"]P01:BRKS:RDMV TEMP: C7-32, Drop[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2591968[/TD]
[TD="class: xl66"]P01:BRKS:RDMV TEMP: A18-2 -A18-3, Drop[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2592647[/TD]
[TD="class: xl66"]Q01:RLTN:CPRD:2660075:GCNET[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]08/03/2016[/TD]
[TD="class: xl66"]DSOPENM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State translate[/TD]

[TD="class: xl66"]2594482[/TD]
[TD="class: xl66"]Q01:MDHT:ZNOR:BLD_ENT: McDonald's Restau[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State translate[/TD]

[TD="class: xl66"]2594483[/TD]
[TD="class: xl66"]GAB:BRKS:ZNOR:BLD_ENT:1601 2 Ave E[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPENM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State teranslate[/TD]

[TD="class: xl66"]2595985[/TD]
[TD="class: xl66"]GAB:MDHT:FOTS:2807155:MOBLTY:CANALTA CEN[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/05/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State translate[/TD]

[TD="class: xl66"]2596718[/TD]
[TD="class: xl66"]Q01:MDHTABU0008:DLC:OP:TS64 to UMC Retro[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]13/10/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2596719[/TD]
[TD="class: xl66"]Q01:MDHT:FZGDAB02:DLC:OP:TS64 to UMC Ret[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/12/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2600541[/TD]
[TD="class: xl66"]GAB:HANN:ZNOR:BLD_ENT: 202 2ND AVE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State translate[/TD]

[TD="class: xl66"]2602901[/TD]
[TD="class: xl66"]Q01:MDHT:CPRD:2326273:FIB:CGI ISMC INC[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]08/02/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2603496[/TD]
[TD="class: xl66"]GAB:RDCL:FOTS:CPRD:2751676:Shaw/Global[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]08/03/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2603571[/TD]
[TD="class: xl66"]Q01:RDCL:FOTS:CPRD:2606059:FIB:FORTIS AB[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]18/08/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2603581[/TD]
[TD="class: xl66"]GAB:MDHT:ZNOR:MH_RBLD:Stober Bay[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPENM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State teranslate[/TD]

[TD="class: xl66"]2612293[/TD]
[TD="class: xl66"]Q01:BRKS:ZNOR:BLD_ENT:501 MEADOWBROOK DR[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2618234[/TD]
[TD="class: xl66"]GAB:MDHT:FZGDAB02:DLC:OP:TS64 to UMC Ret[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]13/10/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State teranslate[/TD]

[TD="class: xl66"]2618988[/TD]
[TD="class: xl66"]GAB:MDHT:LINE_RBLD:102 1ST ST. SW.[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]28/09/2016[/TD]
[TD="class: xl66"]DSOPGEM[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2513013[/TD]
[TD="class: xl66"]KEN:LTBR:OPON:DSA 2114A 174 lots PH2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RACK[/TD]
[TD="class: xl67"]10/05/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2521366[/TD]
[TD="class: xl66"]SMN:CLMN:CPRD:1318217:GOA AFRRCS 1.5 meg[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]15/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2529879[/TD]
[TD="class: xl66"]RDT:CODL:ENT:ZNOR:B:P277:2023895:1316-11[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2530115[/TD]
[TD="class: xl66"]RDT:ENCH:RBLD:ZNOR:B:ENCHANT SEED CLEAN[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]15/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2531096[/TD]
[TD="class: xl66"]Q01:GYLK:ZNOR:B:SUBD:ACPM 2661-B: LTS(30[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2531309[/TD]
[TD="class: xl66"]RDT:CODL:ENT:ZNOR:B:P277:2078975:909-13[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2531405[/TD]
[TD="class: xl66"]SMN:FTML:ZNORB:B:RBLD:510 20ST W.A. DAY[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]09/01/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2532249[/TD]
[TD="class: xl66"]RDT:VXHL:RBLD:ZNOR:B:BOW RIVER A19-1 & 2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS BILL[/TD]
[TD="class: xl66"]26/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2534337[/TD]
[TD="class: xl66"]RDT:LTBR:RBLD:ZNOR:B:421-6 AVE S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2536890[/TD]
[TD="class: xl66"]RDT:CODL:ENT:ZNOR:B:1210 8 ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]15/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2537403[/TD]
[TD="class: xl66"]RDT:CODL:ENT:ZNOR:B:NE 8-9-20 W4 F3 ROUT[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]19/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2540209[/TD]
[TD="class: xl66"]RDT:CODL:CPRD:FOTS:2104875 :1210-8 ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]28/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2545434[/TD]
[TD="class: xl66"]RDT:CODL:ENT:1013-13 AVE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]28/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2546364[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:1075 MM DR S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]08/11/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2546521[/TD]
[TD="class: xl66"]SMN:NBFD:ENT:141 13 ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]16/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2553600[/TD]
[TD="class: xl66"]Q01:NBFD:JUSU:ZNOR:PHASE5:ACPM1437-B[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]28/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2554549[/TD]
[TD="class: xl66"]Q01:LTBR:GPON:SSO:ACPM2714:BLACKWOLF4B ([/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2557129[/TD]
[TD="class: xl66"]Q01:LTBR:GPON:SSO:BLACKWOLF5:ACPM715 (48[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]15/11/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2559143[/TD]
[TD="class: xl66"]KBW:LTBR:MDU:211 Let Perry Blvd 3339- B[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2559144[/TD]
[TD="class: xl66"]KBW:LTBR:MDU:215 Lettice Perry ACPM 3342[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPENL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2559445[/TD]
[TD="class: xl66"]SMN:PNCK:ZNOR:B:RBLD:864 CHRISTIE AVE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]29/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2561582[/TD]
[TD="class: xl66"]Q01:CODL:SSO/SFIB:COTTONWOOD 9-10 LOT48[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RACK[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2561590[/TD]
[TD="class: xl66"]SMN:LTBR:ZNOC:RBLD: CofL HIGHLANDS BLVD[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP BILL[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2561666[/TD]
[TD="class: xl66"]RDT:TABR:CPRD:1285295:DS1:AFRRC 34-9-16[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2562363[/TD]
[TD="class: xl66"]Q01:LTBR:CPRD:2346059:DUPONT 3-DS1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]25/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2562559[/TD]
[TD="class: xl66"]Q01:LTBR:CPRD:2396275:FOTS:1139 MM DR S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]25/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2562571[/TD]
[TD="class: xl66"]SMN:LTBR:CPRD:2353463:131 22 ST N:DS1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]25/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2563078[/TD]
[TD="class: xl66"]Q01:BLRM:CPRD:2395859:12713 20 AVE 5 meg[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]29/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2563407[/TD]
[TD="class: xl66"]Q01:TABR:CPRD:2401437:FOTS:4818 53 ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2565442[/TD]
[TD="class: xl66"]RDT:LTBR:ZNOR:RDMV_TEMP:43 ST S DOMINICO[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS BILL[/TD]
[TD="class: xl67"]08/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2566544[/TD]
[TD="class: xl66"]Q01:GYLK:ZNOR:B:ACPM2661A:Feeder: to new[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2567245[/TD]
[TD="class: xl66"]RDT:CODL:ENT:ZNOR:B:1235-11 ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2570550[/TD]
[TD="class: xl66"]SMN:PNCK:ZNOR:B:ENT:1359 HUNTER ST[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2571457[/TD]
[TD="class: xl66"]KBW:RYMN:CPRD:2467976:AHS 150N 400E 100M[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2572517[/TD]
[TD="class: xl66"]KBW:LTBR:CPRD:2525536:PENSKE TRUCK 10M[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2572842[/TD]
[TD="class: xl66"]Q01:PNCK:CPRD:2457476:ATB FINANCIAL:10 M[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2573321[/TD]
[TD="class: xl66"]SMN:PNCK:ZNOR:B:ENT:1121 TABLE MOUNTAIN[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2573323[/TD]
[TD="class: xl66"]SMN:LTBR:SSO/SFIB:CPPWD 19:ACPM 1678-B[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]24/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2573422[/TD]
[TD="class: xl66"]SMN:LTBR:ZNOR:B:ENT:4 BROXBURN WAY[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2574761[/TD]
[TD="class: xl66"]Q01:LTBR:CPRD:2575835:FOTS:4000-18 Ave N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2575420[/TD]
[TD="class: xl66"]RDT:CODL:2584331:FOTS:1507-20 Ave:Mobili[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2576113[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:NE 33 7 20 W4 H10-1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl66"]15/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2576495[/TD]
[TD="class: xl66"]Q01:CSTN:CPRD:2555255:RBC 204 MainSt 10M[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2576865[/TD]
[TD="class: xl66"]RDT:LTBR:MF:ID1947:FAIRMONT LNDING (20)[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS HOLD[/TD]
[TD="class: xl66"]28/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2578031[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:473 41 ST S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2580241[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:3862-14 Ave N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2580739[/TD]
[TD="class: xl66"]SMN:LTBR:RBLD:BRITTANNIA TO 30 ST W[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans[/TD]

[TD="class: xl66"]2582074[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:2851-26 AVE N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]08/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2585707[/TD]
[TD="class: xl66"]RDT:LTBR:MDU:SFIB:ACPM 872:B:SKYE BLDG's[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2585893[/TD]
[TD="class: xl66"]KBW:TABR:DS3_CUST:P277:2600429:InphaseEl[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2587399[/TD]
[TD="class: xl66"]Q01:BRKS:RDMV TEMP: A13-4 to A14-1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2589406[/TD]
[TD="class: xl66"]Q01:LTBR:FOTS:CPRD:2467715:CLEAN HARBOUR[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]18/10/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2589757[/TD]
[TD="class: xl66"]Q01:BRKS:RDMV TEMP:A2-37 to A19-2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]10/03/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2591548[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:104 Broxburn Blvd[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]30/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2593928[/TD]
[TD="class: xl66"]RDT:LTBR:MFU:ACPM3414:637-12A ST N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2594254[/TD]
[TD="class: xl66"]RDT:LTBR:MFU:SSO:ACPM3517:256 COULEE (18[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]23/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2594267[/TD]
[TD="class: xl66"]SMN:CODL:RBLD:719 19A AVE TRESPASS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/01/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2596411[/TD]
[TD="class: xl66"]Q01:LTBR:FOTS:CPRD:2654301:ATT/COCA COLA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]22/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2596444[/TD]
[TD="class: xl66"]SMN:LTBR:ZNOR:B:ENT:CROSSINGS MARKET PH2[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2596783[/TD]
[TD="class: xl66"]SMN:BRCK:ZNOR:B:ENT:PIIKANI HOUSING[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2596899[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:3656 & 3790 -32 ST N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]21/10/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2597953[/TD]
[TD="class: xl66"]SMN:LTBR:MDU:SFIB:ACPM1563:CROSSINGS MDU[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]16/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2598293[/TD]
[TD="class: xl66"]Q01:LTBR:SSO:ACPM 3963:COPPERWOOD PH 23[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl66"]23/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2598511[/TD]
[TD="class: xl66"]Q01:LTBR:SSO:ACPM 3962:COPPERWOOD PH 24[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]11/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2598778[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:4038-4 AVE S[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2599412[/TD]
[TD="class: xl66"]KBW:CSTN:ZNOR:B:KAINAWA TREATMENT CENTRE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]27/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2599824[/TD]
[TD="class: xl66"]Q01:LTBR:CAT 162:BBB:Alcatel DSA 419-1[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]29/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2599851[/TD]
[TD="class: xl66"]RDT:LTBR:ENT:ZNOR:B:3539-32 ST N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2600722[/TD]
[TD="class: xl66"]Q01:LTBR:FOTS:2803016:MOB:AB8416:CASA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RACK[/TD]
[TD="class: xl66"]16/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2601090[/TD]
[TD="class: xl66"]Q01:LTBR:FOTS:CPRD:1165210:PWGSC/CFIA[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]19/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2602619[/TD]
[TD="class: xl66"]RDT:LTBR:ND:CAT172:Sherring Industrial[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]26/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2606785[/TD]
[TD="class: xl66"]Q01:LTBR:CPRD:2808453:405 HIGHLANDS BLVD[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/06/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2608302[/TD]
[TD="class: xl66"]Q01:PNCK:FOTS:CPRD:2606062:FORTIS[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS RAPP[/TD]
[TD="class: xl67"]10/07/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2609984[/TD]
[TD="class: xl66"]RDT:LTBR:MFU:ACPM3731:37 Cougar Cove N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]15/08/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2610974[/TD]
[TD="class: xl66"]SMN:LTBR:RBLD:87 GREYWOLF RD N[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/01/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2615067[/TD]
[TD="class: xl66"]SMN:LTBR:FOTS:2832005:MOB:AB8495:CRS ICE[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl66"]15/09/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl66"]2616624[/TD]
[TD="class: xl66"]SMN:LTBR:FOTS:CPRD:2818852:PRECON[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS[/TD]
[TD="class: xl67"]09/12/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Translate[/TD]

[TD="class: xl66"]2622131[/TD]
[TD="class: xl66"]KBW:TABR:ZNOR:B:REINLAND CHRCH 4809 64AV[/TD]
[TD="class: xl66"]DSTR[/TD]
[TD="class: xl66"]RFS PAID[/TD]
[TD="class: xl67"]12/05/2016[/TD]
[TD="class: xl66"]DSOPGEL[/TD]
[TD="class: xl66"]9524[/TD]
[TD="class: xl77, width: 169"]Design State Trans (Image)[/TD]

[TD="class: xl68"]2616778[/TD]
[TD="class: xl68"]M01:MRVL:DTP:107 ST & 100 AVE[/TD]
[TD="class: xl68"]DSTR[/TD]
[TD="class: xl68"]RFS[/TD]
[TD="class: xl69"]10/03/2016[/TD]
[TD="class: xl68"]708246DS[/TD]
[TD="class: xl68"]9522[/TD]
[TD="class: xl78, width: 169"]Spatial Net Trans
2016.08.24 No SPNet required; released for invoicing <KS>[/TD]

[TD="class: xl70"]2621498[/TD]
[TD="class: xl70"]K01:DBLT:RDMV:TEMP:2016316:D-1 D-2 TWP R[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl70"]15/12/2016[/TD]
[TD="class: xl70"]708246DS[/TD]
[TD="class: xl70"]9522[/TD]
[TD="class: xl79, width: 169"]Spatial Net Trans
Built as designed
t872586 2016/10/20[/TD]

[TD="class: xl70"]2624612[/TD]
[TD="class: xl70"]K01:RYCF:RDMV:TEMP:2016332:B-29 B-30 HWY[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl71"]12/06/2016[/TD]
[TD="class: xl70"]708246DS[/TD]
[TD="class: xl70"]9522[/TD]
[TD="class: xl79, width: 169"]Spatial Net Trans
Built as designed
t872586 2016-10-21[/TD]

[TD="class: xl70"]2593929[/TD]
[TD="class: xl70"]NCD:TWHL:ROAD_PERM:Hwy_36[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl70"]29/11/2016[/TD]
[TD="class: xl70"]DSOPGEE[/TD]
[TD="class: xl70"]9522[/TD]
[TD="class: xl79, width: 169"]Design State translate

Built as designed.

T883642 2016/10/14[/TD]

[TD="class: xl72"]2614014[/TD]
[TD="class: xl72"]BSB:WNWR:P277:NAPCAPACITYADD[/TD]
[TD="class: xl72"]DSTR[/TD]
[TD="class: xl72"]RFS[/TD]
[TD="class: xl73"]09/09/2016[/TD]
[TD="class: xl72"]DSOPGEE[/TD]
[TD="class: xl72"]9522[/TD]
[TD="class: xl80, width: 169"]Design State Translate

Not built as designed.

T883642 2016/10/14[/TD]

[TD="class: xl70"]2539457[/TD]
[TD="class: xl70"]L03:STON:FIB:CPRD:2586281:Western Drug[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl71"]10/12/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Trans (Image)

Built as designed.

T883642 2016/10/06[/TD]

[TD="class: xl70"]2540941[/TD]
[TD="class: xl70"]GAF:SPVW:RDMV PERM:RT C15 P 1-3:[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl71"]10/12/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Trans (Image)

Built as designed
T866966 2016/10/07[/TD]

[TD="class: xl70"]2570292[/TD]
[TD="class: xl70"]SKU:CNKL:CPRD:2190776:NAVCANADA[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS RAPP[/TD]
[TD="class: xl70"]13/10/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Trans (Image)

Built as designed
T872586 2016/10/04[/TD]

[TD="class: xl74"]2607524[/TD]
[TD="class: xl74"]K01:HIPR:RDMV:DTP:SW10 74 14 W5 HWY 2[/TD]
[TD="class: xl74"]DSTR[/TD]
[TD="class: xl74"]RFS[/TD]
[TD="class: xl75"]10/12/2016[/TD]
[TD="class: xl74"]DSDRAFTR[/TD]
[TD="class: xl74"]9535[/TD]
[TD="class: xl81, width: 169"]Spatial Net Trans
Field updates only
t872586 2016/10/07[/TD]

[TD="class: xl70"]2612949[/TD]
[TD="class: xl70"]D25:RTLD:CPRD:1660 INNOVATION DR10/28[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl71"]12/02/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Translate

Built as designed
T893421 2016/10/20[/TD]

[TD="class: xl70"]2615811[/TD]
[TD="class: xl70"]CAB:ROPR:CPRD:2810718:FORT MCKAY GROUP O[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl70"]13/10/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Trans (Image)

Built as designed

T883642 2016/10/06[/TD]

[TD="class: xl70"]2620319[/TD]
[TD="class: xl70"]CTB:BLMT:POLE_RBLD:METCHOSIN RD/PAINTER[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl70"]22/11/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Translate

BUILT AS DESIGNED
T042956 2016/10/17[/TD]

[TD="class: xl70"]2622041[/TD]
[TD="class: xl70"]I01:NNIM:CPRD:T1 TO 101 COMMERCIAL 11/16[/TD]
[TD="class: xl70"]DSTR[/TD]
[TD="class: xl70"]RFS[/TD]
[TD="class: xl71"]12/06/2016[/TD]
[TD="class: xl70"]DSDRAFTR[/TD]
[TD="class: xl70"]9535[/TD]
[TD="class: xl79, width: 169"]Design State Translate

Built as designed
t042956 2016/10/12[/TD]

[TD="class: xl74"]2571771[/TD]
[TD="class: xl74"]Q01:FTML:FOTS:CPRD:2468558:SHAW/AHS[/TD]
[TD="class: xl74"]DSTR[/TD]
[TD="class: xl74"]RFS RAPP[/TD]
[TD="class: xl74"]18/11/2016[/TD]
[TD="class: xl74"]DSOPGEL[/TD]
[TD="class: xl74"]9524[/TD]
[TD="class: xl81, width: 169"]Design State Translation (Image)

Field updates only
t851192 2016/10/13
[/TD]

[TD="class: xl68"]2574399[/TD]
[TD="class: xl68"]P01:CREL:RDMV TEMP: A-28 to A20-1[/TD]
[TD="class: xl68"]DSTR[/TD]
[TD="class: xl68"]RFS CANC[/TD]
[TD="class: xl68"]19/12/2016[/TD]
[TD="class: xl68"]DSOPGEM[/TD]
[TD="class: xl68"]9524[/TD]
[TD="class: xl78, width: 169"]Design State Translation (Temporary Cabl[/TD]

[TD="class: xl68"]2610851[/TD]
[TD="class: xl68"]Q01:BSSN:FOTS:CPRD:2808603:CELERO SOLUTI[/TD]
[TD="class: xl68"]DSTR[/TD]
[TD="class: xl68"]RFS RAPP[/TD]
[TD="class: xl68"]21/10/2016[/TD]
[TD="class: xl68"]DSOPENM[/TD]
[TD="class: xl68"]9524[/TD]
[TD="class: xl78, width: 169"]Design State translate

Build as designed
t851192 2016/10/20
[/TD]

[TD="class: xl68"]2583484[/TD]
[TD="class: xl68"]Q01:LTBR:OC3:CPRD:1159415:PWGSC/CDN FOOD[/TD]
[TD="class: xl68"]DSTR[/TD]
[TD="class: xl68"]RFS RAPP[/TD]
[TD="class: xl69"]12/02/2016[/TD]
[TD="class: xl68"]DSOPGEL[/TD]
[TD="class: xl68"]9524[/TD]
[TD="class: xl78, width: 169"]Design State Translation (Image)

Build as designed
t851192 2016/10/12

[/TD]

[TD="class: xl68"]2595079[/TD]
[TD="class: xl68"]Q01:LTBR:MOBILITY:2803019:LABOR CLUB[/TD]
[TD="class: xl68"]DSTR[/TD]
[TD="class: xl68"]RFS RAPP[/TD]
[TD="class: xl68"]20/09/2016[/TD]
[TD="class: xl68"]DSOPGEL[/TD]
[TD="class: xl68"]9524[/TD]
[TD="class: xl78, width: 169"]Design State Trans (Image)

Not build as designed
t851192 2016/10/20
[/TD]

[TD="class: xl66"]Total[/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl66"] [/TD]
[TD="class: xl77, width: 169, align: right"]240
I
[/TD]

</tbody>

I need to look throught his table and Idenfify by the Field PLNT each Plant in the table then also look at the color to count how many of each color I have. The below sheet contains what I am refering to.

-- removed inline image ---

Using the COUNTIFS function i can get the total number for each plnt .. but can not get the number matching the colors. Any help would be appreciated.

Mick Peters · Oct 26, 2016

I was some time ago give this code so not sure what versions it will work on

Code:

Function SumColor(rColor As Range, rSumRange As Range)
 
''''''''''''''''''''''''''''''''''''''
'Written by Ozgrid Business Applications
'www.ozgrid.com
 
'Sums cells based on a specified fill color.
'''''''''''''''''''''''''''''''''''''''
    Dim rCell As Range
    Dim iCol As Integer
    Dim vResult
 
    iCol = rColor.Interior.ColorIndex
 
        For Each rCell In rSumRange
            If rCell.Interior.ColorIndex = iCol Then
                vResult = WorksheetFunction.Sum(rCell) + vResult
            End If
        Next rCell
 
    SumColor = vResult
End Function

Once you add this to the spread sheet VBA you can then use the function =Sumcolor(H1,E320:E40) and it will sum all the cells in the range that match it's own background colour.

I hope this helps,
Mick

GRECOR · Oct 26, 2016

Thanks Mick.
I have the same code that you sent me and work great to get the background colours.... but it does it for the whole spreadsheet (table). What I need is the same thing once i have specified a specific plnt i would like the data from. Any idea's?

Mick Peters · Oct 27, 2016

Sorry Grecor, Not quite understanding what you are after . Once this code is in place you can use the function to select the range it is working on. But this is a sum so you may need another column which contains a 1. then do a conditional format so if Plnt = 9524 then red if plnt = 9535 then Blue. You then have a table with each plant and the cell is =the correct colour in the cell next to each plnt enter in your sum cell =sumcolour(Cell,Range ) and you should get the correct count returned. Not at home at the min but if I get a min later I will see if I can make it work on an example.
Mick.

Mick Peters · Oct 28, 2016

Hi Grecor, I have done a bit of testing and it would appear that the sumcolour dose not work with conditional formation. If you set the cells to change colour on a condition then the cell is not counted but if you change the cell to the same colour by formatting it then it is counted. So sorry but I do not currently know the answer to this one.
Mick.

Help Using COUNTIFS Function

GRECOR

New Member

Excel Facts

Mick Peters

Board Regular

GRECOR

New Member

Mick Peters

Board Regular

Mick Peters

Board Regular

Similar threads

Forum statistics

Share this page

Help Using COUNTIFS Function

GRECOR

New Member

Excel Facts

Mick Peters

Board Regular

GRECOR

New Member

Mick Peters

Board Regular

Mick Peters

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock