What data has been uploaded

##The following files are currently uploaded into the logic checker:

0-SpG

* Enumeration Table *
[1] "EnumerationTable09-13-49_2021-06-29.csv"
* Recruitment Interview *
[1] "RECRUIT_SPG_30Jun21_V2.sav"
* Orange Form *
[1] "SPG_CVS_Orange_INTERIM_26Mar21.sav"
* Green & Purple Form *
[1] "CVS_Green And Purple_SPG_INTERIM_18May21 QDE1 all_V2.sav"
* Blue Form *
[1] "SPG_CVS_Blue_INTERIM_26Mar21_Stacked.sav"

1-C

* Enumeration Table *
[1] "EnumerationTable09-06-16_2021-03-14.csv"
* Recruitment Interview *
[1] "RECRUIT_INTERIM_14Mar21.sav"
* Orange Form *
[1] "CVS_C_Orange_INTERIM_3May21.sav"
* Green & Purple Form *
[1] "CVS_Green And Purple_C_INTERIM_6May21 QDE1 all.sav"
* Blue Form *
[1] "CVS_C_Blue_INTERIM_3May21_Stacked.sav"

2-C

* Enumeration Table *
[1] "EnumerationTable17-03-43_2021-05-06.csv"
* Recruitment Interview *
[1] "RECRUIT_C_12May21.sav"
* Orange Form *
[1] ""
* Green & Purple Form *
[1] ""
* Blue Form *
[1] ""

3-I

* Enumeration Table *
[1] "EnumerationTable18-06-20_2021-04-01.csv"
* Recruitment Interview *
[1] "RECRUIT_INTERIM_02Apr21.sav"
* Orange Form *
[1] ""
* Green & Purple Form *
[1] "CVS_Green And Purple_I_INTERIM_27May21 QDE1 all_V4.sav"
* Blue Form *
[1] ""

4-I

* Enumeration Table *
[1] "EnumerationTable16-55-20_2021-06-04.csv"
* Recruitment Interview *
[1] "RECRUIT_I2_08Jun21_V2.sav"
* Orange Form *
[1] ""
* Green & Purple Form *
[1] ""
* Blue Form *
[1] ""

5-P

* Enumeration Table *
[1] "EnumerationTable17-27-04_2021-04-30.csv"
* Recruitment Interview *
[1] "RECRUIT_P_03May21.sav"
* Orange Form *
[1] ""
* Green & Purple Form *
[1] ""
* Blue Form *
[1] ""

6-R

* Enumeration Table *
[1] "EnumerationTable17-11-23_2021-04-30.csv"
* Recruitment Interview *
[1] "RECRUIT_R_03May21.sav"
* Orange Form *
[1] ""
* Green & Purple Form *
[1] ""
* Blue Form *
[1] ""

ET Mismatch to RI

Summary Table of cases where Disposition in datafile is mismatched
ESTID Disposition Enum Table Disposition Data File N

ET Missing from the RI

Completed Survey Tables

Disposition Summary Table

Summary Table of all dispositions by Q2
Disposition -2 -1 1 2
2001 27 NA NA NA
2002 43 6 NA NA
2003 689 85 NA NA
2004 48 5 NA NA
2005 421 33 NA NA
2006 430 40 NA NA
2007 17 1 NA NA
2096 133 18 NA NA
4211 NA NA 18 NA
5101 NA NA NA 4051
5221 NA NA 1185 NA
5222 NA NA 18 NA
5223 NA NA 966 NA
9999 NA NA 1 NA

Q2

Need to check that this is correct before moving on, if the Q2 and Disposation relationship works then we can be confident that when using Disposition in the future it matches the Q2 relationships too
Q2. Business has any utes/vans/rigid or articulated trucks
Disposition Q2 N
5221 1 609
5223 1 455
5222 1 18
5101 2 650

Q2_1 to Q2_4

These are the tables for Q2_1 and Q2_3 Q2_3_A
Q2_3_A
Q2_1 -2 0 1 2 3 4 5 6 7 8 9 10 12 13 15 19 20 40 42 48 100 9997
1 NA 11 20 12 9 3 2 1 2 2 1 2 2 1 1 1 2 2 1 1 1 2
2 1652 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
97 1 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
Q2_3_B
Q2_3_B
Q2_1 -2 0 1 2 3 4 5 6 8 10 14 19 26 9997
1 NA 54 9 2 2 1 1 2 2 1 1 1 1 2
2 1652 NA NA NA NA NA NA NA NA NA NA NA NA NA
97 1 NA NA NA NA NA NA NA NA NA NA NA NA NA
Q2_3_C
Q2_3_C
Q2_1 -2 0 1 2 3 4 54 9997
1 NA 64 7 2 2 1 1 2
2 1652 NA NA NA NA NA NA NA
97 1 NA NA NA NA NA NA NA

Check to see if Q2_1=1 but Q2_3 sums to 0

    ESTID N
1: NEDQG2 1
2: DT7296 1
3: RYCKCN 1
4: F8K7X7 1
These are the tables for Q2_2 and Q2_4 Q2_4_A
Q2_4_A
Q2_2 -2 0 1 2 3 4 5 6 7 9 10 15 19 20 21 23 40 9997
1 NA 36 58 16 7 4 3 3 2 1 1 1 1 1 1 1 1 1
2 1594 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
Q2_4_B
Q2_4_B
Q2_2 -2 0 1 2 3 4 5 6 7 8 14 15 20 22 40 43 149 9997
1 NA 92 17 9 3 2 1 2 2 2 1 1 1 1 1 1 1 1
2 1594 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
Q2_4_C
Q2_4_C
Q2_2 -2 0 1 2 3 4 8 15 30 47 9997
1 1 123 3 3 1 2 1 1 1 1 1
2 1594 NA NA NA NA NA NA NA NA NA NA

Check to see if Q2_2=1 but Q2_4 sums to 0

    ESTID N
1: WVEXWM 1
2: VGKYVX 1
3: JMGSGB 1
4: CQXE77 1
5: 5JQCB8 1
6: 5EU8CH 1
NEED TO REVIEW THIS CHECK Check if Q2_4A/B/C have no negative numbers or “others” 
      ESTID Q2_4_A Q2_4_B Q2_4_C
  1: QCFN5O      0      4      0
  2: NEVQS6      0      1      0
  3: HDD7WZ      1      0      0
  4: C3TC7W      3      0      0
  5: YED29Y      0      1      0
 ---                            
109: DJXUP2      2      0      0
110: 6JEKST      1      0      0
111: 9FW8JM     20      0      0
112: 8GBHF8      0      1      0
113: W7J52R      5      0      0

Manages Vehicles on Site

Manage_LCV
Manage_LCV
Disposition -2 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 25 29 34 35 36 40 41 45 48 50 56 69 70 75 130 400
5101 650 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
5221 NA 44 204 134 58 54 35 18 12 7 4 11 2 6 2 2 4 NA 1 NA NA 1 NA 1 NA NA NA NA 1 1 1 1 NA 1 1 1 1 1 NA NA
5222 NA 1 3 3 1 3 2 NA 1 NA 1 NA NA 1 NA NA NA NA NA NA 1 NA NA NA NA NA NA 1 NA NA NA NA NA NA NA NA NA NA NA NA
5223 NA 28 183 98 46 28 17 9 10 9 1 6 2 2 NA NA 4 1 NA 1 NA 1 1 NA 2 1 1 NA 1 NA NA NA 1 NA NA NA NA NA 1 1
List the ESTIDs which are Disposition = 5101 but EST have vehicles listed or EST is >=5221 but has -1,-2 as a response 
[1] "No results"
[1] "No results"
Manage_RIGID
Manage_RIGID
Disposition -2 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 17 20 23 25 28 34 35 54 57 64
5101 650 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
5221 NA 375 121 47 17 14 11 2 2 3 2 2 1 3 1 1 1 NA 2 1 NA NA 1 1 NA NA 1
5222 NA 10 2 3 1 NA NA NA NA NA NA 1 NA NA 1 NA NA NA NA NA NA NA NA NA NA NA NA
5223 NA 308 88 24 7 11 3 1 3 1 NA 2 NA 1 1 NA NA 1 NA NA 1 1 NA NA 1 1 NA
List the ESTIDs which are Disposition = 5101 but EST have vehicles listed or EST is >=5221 but has -1,-2 as a response 
[1] "No results"
[1] "No results"
Manage_ART
Manage_ART
Disposition -2 0 1 2 3 4 5 6 7 8 9 10 12 14 15 17 25 28 30 61
5101 650 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA
5221 NA 555 19 4 6 5 5 4 2 NA 1 NA 1 2 1 1 1 1 NA 1
5222 NA 15 NA 1 NA NA NA 1 NA NA NA 1 NA NA NA NA NA NA NA NA
5223 NA 432 6 5 1 2 1 NA 1 1 1 3 NA NA 1 NA NA NA 1 NA
List the ESTIDs which are Disposition = 5101 but EST have vehicles listed or EST is >=5221 but has -1,-2 as a response 
[1] "No results"
[1] "No results"

Q8 - No. Departures

Now we look at Q8 and the if there are departures from the site.

First, filter down to just those with LCV and an answer to Q8A of 9997,-1, or -2
Q8A = DK, missing, NA
Disposition Q2 9997
5223 1 2
Check that if LCV<0 then Q8A must equal -2
Q8A - no veh, no departure
Disposition Q2 -2
5101 2 650
ESTID of errors: 
    ESTID Q2  Q8A N
1: 5GQJ9E  1 9997 1
2: UJBSPV  1 9997 1
[1] "No results"
filter down to just those with Rigid and the answer to Q8B is 9997,-1, or -2
Q8B = DK, missing, NA
Disposition Q2 -2
5223 1 1
Check that if Rigid<0 then Q8B must equal -2
Q8B - no veh, no departure
Disposition Q2 -2
5101 2 650
ESTID of errors: 
    ESTID Q2 Q8B N
1: XXEM6T  1  -2 1
[1] "No results"
filter down to just those with Articulated and the answer to Q8C is 9997,-1, or -2 
[1] "No results"
Check that if Articulated<0 then Q8C must equal -2
Q8C - no veh, no departure
Disposition Q2 -2
5101 2 650
ESTID of errors: 
[1] "No results"
[1] "No results"

Q9 - Departure time proportion

Firstly, lets check that all who should have answered have
Sum Q9 together should add to 100%
Q9_Sum N
100 1082
Now, we check if the Q2=2 people have answered this (they shouldn’t have)
Q9_Sum should add up to 5 * -2
Q9_Sum N
-10 650

Q10 - Business operation

Check if any businesses are not open any days
How many days of the week is the business open
daycheck N
7 94
5 791
6 185
4 6
2 2
3 4

check if any responses are not 0 (closed) or 1(open)

Monday 
[1] "No results"
Tuesday 
[1] "No results"
Wednesday 
[1] "No results"
Thursday 
[1] "No results"
Friday 
[1] "No results"
Saturday 
[1] "No results"
Sunday 
[1] "No results"

Check if cases that are 5101 are correctly marked as -2

   Q10a_1 Q10a_2 Q10a_3 Q10a_4 Q10a_5 Q10a_6 Q10a_7   N
1:     -2     -2     -2     -2     -2     -2     -2 650

ESTID With an error:

Monday (Q10a_1) 
[1] "No results"
Tuesday (Q10a_2) 
[1] "No results"
Wednesday (Q10a_3) 
[1] "No results"
Thursday (Q10a_4) 
[1] "No results"
Friday (Q10a_5) 
[1] "No results"
Saturday (Q10a_6) 
[1] "No results"
Sunday (Q10a_7) 
[1] "No results"

Q11 - Average day distribution

Check that each day the business is open there is a valid answer for distribution

Monday - Has vehicles and is open
Q11_NEW_1 N
3 981
4 52
5 15
1 4
2 19
ESTID with Error: 
[1] "No results"
Monday - Has vehicles and is closed
Q11_NEW_1 N
-2 11
ESTID with Error: 
[1] "No results"
Tuesday - Has vehicles and is open
Q11_NEW_2 N
3 1022
4 30
2 14
1 5
5 4
ESTID with Error: 
[1] "No results"
Tuesday - Has vehicles and is closed
Q11_NEW_2 N
-2 7
ESTID with Error: 
[1] "No results"
Wednesday - Has vehicles and is open
Q11_NEW_3 N
3 1029
5 5
2 13
4 30
1 4
ESTID with Error: 
[1] "No results"
Wednesday - Has vehicles and is closed
Q11_NEW_3 N
-2 1
ESTID with Error: 
[1] "No results"
Thursday - Has vehicles and is open
Q11_NEW_4 N
3 1027
5 6
4 27
2 14
1 5
ESTID with Error: 
[1] "No results"
Thursday - Has vehicles and is closed
Q11_NEW_4 N
-2 3
ESTID with Error: 
[1] "No results"
Friday - Has vehicles and is open
Q11_NEW_5 N
3 960
4 61
2 22
5 19
1 13
ESTID with Error: 
[1] "No results"
Friday - Has vehicles and is closed
Q11_NEW_5 N
-2 7
ESTID with Error: 
[1] "No results"
Saturday - Has vehicles and is open
Q11_NEW_6 N
3 135
2 64
1 75
4 4
5 5
ESTID with Error: 
[1] "No results"
Saturday - Has vehicles and is closed
Q11_NEW_6 N
-2 798
3 1
ESTID with Error: 
    ESTID Q11_NEW_6 N
1: CBEFTC         3 1
Sunday - Has vehicles and is open
Q11_NEW_7 N
3 46
1 37
4 2
2 12
5 2
ESTID with Error: 
[1] "No results"
Sunday - Has vehicles and is closed
Q11_NEW_7 N
-2 983
ESTID with Error: 
[1] "No results"

Q12 - Average Month distribution

Check that each month has a valid answer for average month distribution

January - Has vehicles
Q12_NEW_1 N
3 866
2 92
1 25
4 82
5 17
ESTID with Error: 
[1] "No Results"
January - No vehicles
Q12_NEW_1 N
-2 650
ESTID with Error: 
[1] "No Results"
February - Has vehicles
Q12_NEW_2 N
3 970
2 21
4 64
5 21
1 6
ESTID with Error: 
[1] "No Results"
February - No vehicles
Q12_NEW_2 N
-2 650
ESTID with Error: 
[1] "No Results"
March - Has vehicles
Q12_NEW_3 N
3 987
4 51
5 16
1 11
2 17
ESTID with Error: 
[1] "No Results"
March - No vehicles
Q12_NEW_3 N
-2 650
ESTID with Error: 
[1] "No Results"
April - Has vehicles
Q12_NEW_4 N
3 985
4 50
2 22
5 9
1 16
ESTID with Error: 
[1] "No Results"
April - No vehicles
Q12_NEW_4 N
-2 650
ESTID with Error: 
[1] "No Results"
May - Has vehicles
Q12_NEW_5 N
3 1002
4 30
2 29
5 7
1 14
ESTID with Error: 
[1] "No Results"
May - No vehicles
Q12_NEW_5 N
-2 650
ESTID with Error: 
[1] "No Results"
June - Has vehicles
Q12_NEW_6 N
3 951
5 9
2 58
4 52
1 12
ESTID with Error: 
[1] "No Results"
June - No vehicles
Q12_NEW_6 N
-2 650
ESTID with Error: 
[1] "No Results"
July - Has vehicles
Q12_NEW_7 N
3 957
2 64
5 8
4 44
1 9
ESTID with Error: 
[1] "No Results"
July - No vehicles
Q12_NEW_7 N
-2 650
ESTID with Error: 
[1] "No Results"
August - Has vehicles
Q12_NEW_8 N
3 981
2 56
5 9
4 30
1 6
ESTID with Error: 
[1] "No Results"
August - No vehicles
Q12_NEW_8 N
-2 650
ESTID with Error: 
[1] "No Results"
September - Has vehicles
Q12_NEW_9 N
3 1011
2 27
5 10
4 33
1 1
ESTID with Error: 
[1] "No Results"
September - No vehicles
Q12_NEW_9 N
-2 650
ESTID with Error: 
[1] "No Results"
October - Has vehicles
Q12_NEW_10 N
3 985
4 64
2 17
5 15
1 1
ESTID with Error: 
[1] "No Results"
October - No vehicles
Q12_NEW_10 N
-2 650
ESTID with Error: 
[1] "No Results"
November - Has vehicles
Q12_NEW_11 N
3 934
2 15
4 106
5 24
1 3
ESTID with Error: 
[1] "No Results"
November - No vehicles
Q12_NEW_11 N
-2 650
ESTID with Error: 
[1] "No Results"
December - Has vehicles
Q12_NEW_12 N
3 766
1 27
2 100
5 43
4 146
ESTID with Error: 
[1] "No Results"
December - No vehicles
Q12_NEW_12 N
-2 650
ESTID with Error: 
[1] "No Results"

Arrivals

Now we look at the arrivals and the if there are valid answers for those with and without Vehicles.

We can look at all cases with a dispostion of 5101,5221,5222,5223 together as all were asked. search for response code of: 9997,-1, or -2

LCV Arrivals

ARRIVALS_LCV = DK, missing, NA
Disposition 9997
5101 4
5223 1
ESTID of errors: 
    ESTID Disposition ARRIVALS_LCV N
1: R9RN3U        5101         9997 1
2: 5GQJ9E        5223         9997 1
3: TXYRG7        5101         9997 1
4: C7C9W9        5101         9997 1
5: 69V6YT        5101         9997 1

RIGID Arrivals

ARRIVALS_RIGID = DK, missing, NA
Disposition 9997
5101 3
5223 2
ESTID of errors: 
    ESTID Disposition ARRIVALS_RIGID N
1: R9RN3U        5101           9997 1
2: DT93FY        5223           9997 1
3: 5GQJ9E        5223           9997 1
4: TXYRG7        5101           9997 1
5: C7C9W9        5101           9997 1

LCV Articulated

ARRIVALS_ART = DK, missing, NA
Disposition 9997
5101 3
5223 1
ESTID of errors: 
    ESTID Disposition ARRIVALS_ART N
1: R9RN3U        5101         9997 1
2: 5GQJ9E        5223         9997 1
3: TXYRG7        5101         9997 1
4: C7C9W9        5101         9997 1

Outsource %

Now we look at the outsource % and the if there are valid answers for those with and without Vehicles.

We can look at all cases with a dispostion of 5101,5221,5222,5223 together as all were asked. search for response code of: 9997,-1

LCV Outsourcing %

OUTSOURCE_LCV = DK / missing
Disposition 9997
5101 4
5223 1
ESTID of errors: 
    ESTID Disposition OUTSOURCE_LCV N
1: R9RN3U        5101          9997 1
2: 5GQJ9E        5223          9997 1
3: TXYRG7        5101          9997 1
4: C7C9W9        5101          9997 1
5: 69V6YT        5101          9997 1

RIGID Outsourcing %

OUTSOURCE_RIGID = DK / missing
Disposition 9997
5101 3
5223 2
ESTID of errors: 
    ESTID Disposition OUTSOURCE_RIGID N
1: R9RN3U        5101            9997 1
2: DT93FY        5223            9997 1
3: 5GQJ9E        5223            9997 1
4: TXYRG7        5101            9997 1
5: C7C9W9        5101            9997 1

Articulated Outsourcing %

OUTSOURCE_ART = DK / missing
Disposition 9997
5101 3
5223 1
ESTID of errors: 
    ESTID Disposition OUTSOURCE_ART N
1: R9RN3U        5101          9997 1
2: 5GQJ9E        5223          9997 1
3: TXYRG7        5101          9997 1
4: C7C9W9        5101          9997 1

Now look to see how the arrivals and outsource interact. if arrivals equal to 0 or -1 then outsource should be -2

LCV 
[1] "No results"
RIGID 
[1] "No results"
ART 
[1] "No results"

Independent Contractor %

Now we look at the Independent Contractor % and the if there are valid answers for those with and without Vehicles.

We can look at all cases with a dispostion of 5101,5221,5222,5223 together as all were asked. search for response code of: 9997,-1

LCV Independent Contractor %

INDCON_LCV = DK / missing
Disposition 9997
5101 4
5223 1
ESTID of errors: 
    ESTID Disposition INDCON_LCV N
1: R9RN3U        5101       9997 1
2: 5GQJ9E        5223       9997 1
3: TXYRG7        5101       9997 1
4: C7C9W9        5101       9997 1
5: 69V6YT        5101       9997 1

RIGID Independent Contractor %

INDCON_RIGID = DK / missing
Disposition 9997
5101 3
5223 2
ESTID of errors: 
    ESTID Disposition INDCON_RIGID N
1: R9RN3U        5101         9997 1
2: DT93FY        5223         9997 1
3: 5GQJ9E        5223         9997 1
4: TXYRG7        5101         9997 1
5: C7C9W9        5101         9997 1

Articulated Independent Contractor %

INDCON_ART = DK / missing
Disposition 9997
5101 3
5223 1
ESTID of errors: 
    ESTID Disposition INDCON_ART N
1: R9RN3U        5101       9997 1
2: 5GQJ9E        5223       9997 1
3: TXYRG7        5101       9997 1
4: C7C9W9        5101       9997 1

Now check if INDCON is correctly answered when Outsource is less than or equal to 0 ESTID of errors:

LCV 
[1] "No results"
RIGID 
[1] "No results"
ART 
[1] "No results"

Q16

check the arrival proportions throughout the day

RI_Completed[,.N,c(Q16_1]

Now check that the proportions add up to 100% or -10 (5 time points of -2
If Q2=1 then check it adds to 100
Q16 = 100% when Q2=1
Disposition 100
5221 609
5222 18
5223 455
ESTID of errors: 
[1] "No results"
If Q2=2 then check it adds to -10
Q16 = -10 when Q2=2
Disposition -10
5101 650
ESTID of errors: 
[1] "No results"

Q17

Check that when a business is open on day X there is a correspondenting answer to Q17_NEW. If Q2=2 then check for Q17_NEW=-2

Monday
Monday - Q17
Q10a_1 -2 1 2 3 4 5
-2 650 NA NA NA NA NA
0 11 NA NA NA NA NA
1 NA 14 18 979 52 8
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"
Tuesday
Tuesday - Q17
Q10a_2 -2 1 2 3 4 5
-2 650 NA NA NA NA NA
0 7 NA NA NA NA NA
1 NA 10 14 1001 45 5
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"
Wednesday
Wednesday - Q17
Q10a_3 -2 1 2 3 4 5
-2 650 NA NA NA NA NA
0 1 NA NA NA NA NA
1 NA 12 21 1015 29 4
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"
Thursday
Thursday - Q17
Q10a_4 -2 1 2 3 4 5
-2 650 NA NA NA NA NA
0 3 NA NA NA NA NA
1 NA 12 16 1009 36 6
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"
Friday
Friday - Q17
Q10a_5 -2 1 2 3 4 5
-2 650 NA NA NA NA NA
0 7 NA NA NA NA NA
1 NA 22 29 966 47 11
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"
Saturday
Saturday - Q17
Q10a_6 -2 1 2 3 4 5
-2 650 NA NA NA NA NA
0 799 NA NA NA NA NA
1 NA 167 21 89 5 1
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"
Sunday
Sunday - Q17
Q10a_7 -2 1 2 3 4
-2 650 NA NA NA NA
0 983 NA NA NA NA
1 NA 61 6 31 1
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"

Q18

Check that the monthly average question has been asked for everyone who is Q2=1 and not asked (-2) of Q2=2 respondents
Month Normally
Q18 1 2
-2 NA 650
1 92 NA
2 798 NA
3 192 NA
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"

Q19

Check that the monthly average question has been asked for everyone who is Q2=1 and not asked (-2) of Q2=2 respondents
Average number of visitors / customers
Q19 1 2
-2 NA 650
0 119 NA
1 643 NA
2 167 NA
3 68 NA
4 63 NA
5 13 NA
6 5 NA
7 1 NA
97 3 NA
ESTID of errors: Q2=1 
[1] "No results"
Q2=2 
[1] "No results"

ANZSIC

Check that ANZSIC is behaving and that it all logically makes sense Check How many valid activities are listed (this means not -1,-2, 9998 or 9997) … If the count of 0 exists that = sad face
count of valid activities by disposition
Disposition 0 1 2 3 4
5101 NA 630 19 1 NA
5221 4 560 39 4 2
5222 NA 18 NA NA NA
5223 3 420 27 4 1

look for codes which we shouldn’t have such as -1, 0, 9999 or 9998

ANZSIC_1
ANZSIC_1 codes
ANZIC_1 N
193 1
419 1
529 4
700 2
801 1
809 1
1012 1
1090 26
1111 3
1113 4
1131 1
1140 1
1150 1
1161 1
1171 2
1172 3
1174 2
1182 3
1192 3
1199 17
1211 1
1213 1
1214 1
1320 1
1333 2
1334 2
1351 3
1352 1
1491 1
1492 21
1494 3
1499 6
1510 2
1521 2
1523 1
1611 12
1612 2
1812 2
1821 3
1829 2
1831 2
1851 1
1852 2
1899 2
1912 6
1913 3
1916 5
1919 6
1920 1
2010 3
2031 1
2033 2
2034 6
2090 4
2110 5
2122 6
2132 1
2139 2
2149 2
2210 1
2221 44
2222 3
2223 8
2229 11
2239 2
2240 9
2293 8
2299 20
2311 1
2312 14
2313 1
2319 8
2391 4
2392 10
2393 1
2411 2
2412 3
2422 1
2429 2
2432 2
2439 5
2451 6
2452 3
2461 2
2462 7
2463 14
2469 3
2491 6
2499 8
2511 9
2512 1
2513 1
2519 2
2592 2
2599 11
2619 3
2811 2
2812 1
2911 7
2919 4
2921 4
2922 11
3011 5
3019 6
3020 8
3101 9
3109 19
3211 1
3212 2
3221 7
3223 1
3231 12
3232 35
3233 8
3234 6
3239 4
3241 4
3242 13
3243 2
3244 6
3245 4
3291 6
3292 2
3299 18
3311 1
3319 3
3322 13
3323 2
3331 2
3332 5
3339 37
3411 6
3419 19
3491 3
3493 2
3494 27
3499 13
3501 3
3502 3
3503 3
3504 16
3505 4
3601 3
3603 1
3604 2
3606 7
3609 14
3711 7
3712 5
3720 5
3731 5
3733 1
3734 2
3736 4
3739 9
3911 9
3912 1
3913 2
3921 20
3922 10
4000 11
4110 2
4121 1
4122 1
4123 1
4129 4
4211 8
4212 6
4213 1
4221 8
4222 1
4229 1
4231 23
4232 3
4241 6
4243 1
4244 1
4245 6
4251 2
4259 2
4273 6
4279 14
4310 3
4400 2
4511 12
4512 22
4513 3
4610 39
4622 2
4623 2
4810 2
5029 3
5101 3
5102 6
5212 1
5219 1
5291 2
5292 13
5299 1
5309 42
5420 3
5801 1
5809 1
5921 2
6240 1
6322 1
6411 3
6419 1
6611 5
6619 4
6631 12
6639 14
6712 1
6720 3
6910 1
6921 1
6922 3
6923 24
6924 9
6925 18
6932 6
6940 4
6961 8
6962 3
6970 2
6991 1
6999 2
7000 5
7211 5
7212 1
7220 1
7291 19
7299 4
7311 13
7312 1
7313 1
7320 3
7510 2
7520 1
7530 3
7540 1
7600 1
7712 1
7713 2
7719 2
8010 1
8101 13
8211 7
8212 7
8219 2
8511 2
8512 1
8520 1
8531 1
8533 1
8534 1
8539 3
8609 1
8790 5
8910 1
9001 1
9002 1
9111 15
9112 1
9139 2
9411 8
9412 56
9419 128
9421 3
9422 5
9429 42
9491 1
9499 3
9511 5
9531 3
9533 2
9534 1
9539 3
9540 7
9559 2
9998 7
ESTID with Errors: 
    ESTID ANZIC_1 N
1: F7BNTY    9998 1
2: C3TC7W    9998 1
3: E8VYM3    9998 1
4: ZK8167    9998 1
5: GVI9BI    9998 1
6: X7HR5W    9998 1
7: 995DJE    9998 1
[1] "No results"
ANZSIC_2
ANZSIC_2 codes
ANZIC_2 N
-2 1635
919 1
1090 1
1192 1
1611 1
2033 1
2090 1
2110 1
2221 1
2293 1
2299 2
2312 1
2392 1
2393 1
2452 1
2463 1
2599 2
3011 1
3109 1
3221 2
3239 1
3299 1
3311 1
3322 1
3339 1
3492 1
3503 1
3504 2
3601 1
3609 1
3911 1
3913 1
4110 2
4251 1
4279 2
4310 1
4511 1
4512 1
4520 1
4610 5
5029 1
5101 1
5292 1
5299 1
5309 4
5802 1
6619 3
6923 3
6924 1
6961 4
6962 1
6970 1
7220 1
7291 3
7311 1
7510 1
9111 2
9412 1
9419 5
9421 1
9429 6
9511 1
9531 3
9539 1
ESTID with Errors: 
[1] "No results"
[1] "No results"
ANZSIC_3
ANZSIC_3 codes
ANZIC_3 N
-2 1721
3231 1
3239 1
3339 1
3502 1
4279 1
6923 1
6961 1
7291 3
9429 1
ESTID with Errors: 
[1] "No results"
[1] "No results"
ANZSIC_4
ANZSIC_4 codes
ANZIC_4 N
-2 1728
131 1
4310 1
6961 1
7291 1
ESTID with Errors: 
[1] "No results"
[1] "No results"

Final check, do each of the activities that exist follow on logically meaning that there are not duplicates within business and that if activity three exists, then activity two must be valid.

Duplicated ANZSIC codes within the same establishment 
     ESTID ANZIC_1 ANZIC_2 ANZIC_3 ANZIC_4 N
 1: SUSGMQ    1192    1192      -2      -2 1
 2: KKQJ9X    3299    3299      -2      -2 1
 3: YZT9UB    2599    2599      -2      -2 1
 4: HSN6NX    7510    7510      -2      -2 1
 5: YG9BSJ    2312    6961    6961    6961 1
 6: GMNW9Y    9531    9531      -2      -2 1
 7: 8Q56DN    2393    2393      -2      -2 1
 8: RX7WG2    2090    2090    3239    7291 1
 9: WBCWF5    6923    6923      -2      -2 1
10: JCGW2Y    2463    2463      -2      -2 1
Logically placed codes where if activity two exists then activity one must exist etc. 
    ESTID act1 act2 act3 act4 N
1: 8EU8SZ    1    1    0    1 1
    ESTID ANZIC_1 ANZIC_2 ANZIC_3 ANZIC_4 N
1: 8EU8SZ    3921    9419      -2     131 1

Employees

Check that the number of employees variables match to the activities

Check if Employees for activity 1 is greater than 0 (where activity 1 exists) 
     ESTID TOTAL_EMP_1 N
 1: N8TK7J           0 1
 2: PRHFTY        9998 1
 3: T7D9E8           0 1
 4: UKDHKX           0 1
 5: WTRGYV           0 1
 6: QDMQUD           0 1
 7: 96XHSZ           0 1
 8: E8XH93           0 1
 9: TS7SJT           0 1
10: RGHUJ6           0 1
11: ZHPV2M           0 1
12: 9WGSY9           0 1
13: QNTEZY           0 1
14: D9XTRY           0 1
15: C7C9W9           0 1
16: D2UMK9           0 1
17: YX2EVW           0 1
18: X5GQ3W           0 1
19: 3VCNG7           0 1
20: 3BBBV2           0 1
21: WMPFYX           0 1
22: B6JB8J           0 1
23: 5C5V7M           0 1
24: J2FN3B           0 1
25: Q5RRZD           0 1
26: Y2B8HE           0 1
27: GUZ7MW           0 1
28: WP8S3N           0 1
29: D3ZQ6F           0 1
30: BV86GF           0 1
31: YQBEYY           0 1
     ESTID TOTAL_EMP_1 N
Check if Employees for activity 2 is greater than 0 (where activity 2 exists) 
    ESTID TOTAL_EMP_2 N
1: SUSGMQ           0 1
2: WRS957           0 1
3: 7UQ2FE           0 1
4: P3PFJV           0 1
5: 7HMPPZ           0 1
6: 3BBBV2           0 1
7: 8VTN2K           0 1
Check if Employees for activity 3 is greater than 0 (where activity 3 exists) 
[1] "No results"
Check if Employees for activity 4 is greater than 0 (where activity 4 exists) 
[1] "No results"

P2.10

Check that all of the P2.10 sections work with their predefined rules

First Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 1 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has only 1 Activity but P2.10A is not 100% 
    ESTID P2_10A_1
1: 8CUXDY        0
2: GPHV9V        0
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 1 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has only 1 Activity but P2.10B is not 100% 
    ESTID P2_10B_1
1: 8CUXDY        0
2: GPHV9V        0
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 1 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has only 1 Activity but P2.10C is not 100% 
    ESTID P2_10C_1
1: 8CUXDY        0
Next Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 2 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has 2 Activities but P2.10A is not 100% when summed across both 
    ESTID P2_10A_1 P2_10A_2
1: V655UD       70       15
2: FPFWFG       20       40
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 2 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has 2 Activities but P2.10B is not 100% when summed across both 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 2 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has 2 Activities but P2.10C is not 100% when summed across both 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 3 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has 3 Activities but P2.10A is not 100% when summed across all 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 3 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has 3 Activities but P2.10B is not 100% when summed across all 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 3 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has 3 Activities but P2.10C is not 100% when summed across all 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 4 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has 4 Activities but P2.10A is not 100% when summed across all 
    ESTID P2_10A_1 P2_10A_2 P2_10A_3 P2_10A_4
1: JC7SHU       30       30       40       40
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 4 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has 4 Activities but P2.10B is not 100% when summed across all 
    ESTID P2_10B_1 P2_10B_2 P2_10B_3 P2_10B_4
1: JC7SHU       30       30       40       40
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 4 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has 4 Activities but P2.10C is not 100% when summed across all 
[1] "No results"
Finally check if all the people with no vehicles have -2 all the way through (look for anything not -2) 
   P2_10A_1 P2_10A_2 P2_10A_3 P2_10A_4   N
1:       -2       -2       -2       -2 650
   P2_10B_1 P2_10B_2 P2_10B_3 P2_10B_4   N
1:       -2       -2       -2       -2 650
   P2_10C_1 P2_10C_2 P2_10C_3 P2_10C_4   N
1:       -2       -2       -2       -2 650

P2.7

Check that P2.7 and the dispositions are correct
P2.7 check table
Q2 P2_7 5101 5221 5222 5223
1 1 NA 609 NA NA
1 2 NA NA 18 NA
1 98 NA NA NA 455
2 -2 650 NA NA NA

Final Survey Status

Check that Final status makes sense
Final Status
FinalStatus Disposition N
5 5101 650
1 5221 609
1 5222 18
1 5223 455

Refusal Survey Tables

Disposition Summary Table

Q2

Need to check that this is correct before moving on, if the Q2 and Disposation relationship works then we can be confident that when using Disposition in the future it matches the Q2 relationships too
Q2. Business has any utes/vans/rigid or articulated trucks
Disposition Q2 N
4211 1 18

Q2_1 to Q2_4

These are the tables for Q2_1 and Q2_3 Q2_3_A
Q2_3_A
Q2_1 -2
2 16
98 2
Q2_3_B
Q2_3_B
Q2_1 -2
2 16
98 2
Q2_3_C
Q2_3_C
Q2_1 -2
2 16
98 2

Check to see if Q2_1=1 but Q2_3 sums to 0

[1] "No results"
These are the tables for Q2_2 and Q2_4 Q2_4_A
Q2_4_A
Q2_2 -2 1 5
1 NA 1 1
2 14 NA NA
98 2 NA NA
Q2_4_B
Q2_4_B
Q2_2 -2 0
1 NA 2
2 14 NA
98 2 NA
Q2_4_C
Q2_4_C
Q2_2 -2 0
1 NA 2
2 14 NA
98 2 NA

Check to see if Q2_2=1 but Q2_4 sums to 0

[1] "No results"
NEED TO REVIEW THIS CHECK Check if Q2_4A/B/C have no negative numbers or “others” 
    ESTID Q2_4_A Q2_4_B Q2_4_C
1: 5X2RK7      5      0      0
2: R5X3V8      1      0      0

Manages Vehicles on Site

Manage_LCV
Manage_LCV
Disposition -1 0 1 2 4 5 8 9997
4211 1 2 8 2 1 1 1 2
List the ESTIDs which are Disposition = 5101 but EST have vehicles listed or EST is >=5221 but has -1,-2 as a response 
[1] "No results"
[1] "No results"
Manage_RIGID
Manage_RIGID
Disposition -1 0 1 2 9997
4211 1 11 3 1 2
List the ESTIDs which are Disposition = 5101 but EST have vehicles listed or EST is >=5221 but has -1,-2 as a response 
[1] "No results"
[1] "No results"
Manage_ART
Manage_ART
Disposition -1 0 9997
4211 1 15 2
List the ESTIDs which are Disposition = 5101 but EST have vehicles listed or EST is >=5221 but has -1,-2 as a response 
[1] "No results"
[1] "No results"

Arrivals

Now we look at the arrivals and the if there are valid answers for those with and without Vehicles.

LCV Arrivals

ARRIVALS_LCV = DK, missing, NA
Disposition -2 -1 9997
4211 1 1 3
ESTID of errors: 
    ESTID Disposition ARRIVALS_LCV N
1: GY6HGM        4211         9997 1
2: W7XQUG        4211           -1 1
3: 3WE7YS        4211           -2 1
4: 9RQ5DW        4211         9997 1
5: 5X2RK7        4211         9997 1

RIGID Arrivals

ARRIVALS_RIGID = DK, missing, NA
Disposition -2 9997
4211 2 3
ESTID of errors: 
    ESTID Disposition ARRIVALS_RIGID N
1: FBZ3HH        4211             -2 1
2: GY6HGM        4211           9997 1
3: W7XQUG        4211             -2 1
4: 9RQ5DW        4211           9997 1
5: 5X2RK7        4211           9997 1

LCV Articulated

ARRIVALS_ART = DK, missing, NA
Disposition -2 9997
4211 4 3
ESTID of errors: 
    ESTID Disposition ARRIVALS_ART N
1: FBZ3HH        4211           -2 1
2: GY6HGM        4211         9997 1
3: X2NV3R        4211           -2 1
4: W7XQUG        4211           -2 1
5: 3WE7YS        4211           -2 1
6: 9RQ5DW        4211         9997 1
7: 5X2RK7        4211         9997 1

Outsource %

Now we look at the outsource % and the if there are valid answers for those with and without Vehicles.

LCV Outsourcing %

[1] "No results"
ESTID of errors: 
[1] "No results"

RIGID Outsourcing %

[1] "No results"
ESTID of errors: 
[1] "No results"

Articulated Outsourcing %

[1] "No results"
ESTID of errors: 
[1] "No results"

ANZSIC

Check that ANZSIC is behaving and that it all logically makes sense Check How many valid activities are listed (this means not -1,-2, 9998 or 9997) … If the count of 0 exists that = sad face
count of valid activities by disposition
Disposition 1 2
4211 16 2

look for codes which we shouldn’t have such as -1, 0, 9999 or 9998

ANZSIC_1
ANZSIC_1 codes
ANZIC_1 N
112 1
1214 1
2121 1
2122 1
2229 1
2312 1
2392 1
3011 1
3239 1
3245 1
3291 1
3332 1
4229 1
7530 1
9002 1
9139 1
9419 1
9429 1
ESTID with Errors: 
[1] "No results"
[1] "No results"
ANZSIC_2
ANZSIC_2 codes
ANZIC_2 N
-2 16
3101 1
4511 1
ESTID with Errors: 
[1] "No results"
[1] "No results"
ANZSIC_3
ANZSIC_3 codes
ANZIC_3 N
-2 18
ESTID with Errors: 
[1] "No results"
[1] "No results"
ANZSIC_4
ANZSIC_4 codes
ANZIC_4 N
-2 18
ESTID with Errors: 
[1] "No results"
[1] "No results"

Final check, do each of the activities that exist follow on logically meaning that there are not duplicates within business and that if activity three exists, then activity two must be valid.

Duplicated ANZSIC codes within the same establishment 
[1] "No results"
Logically placed codes where if activity two exists then activity one must exist etc. 
[1] "No results"
[1] "No results"

Employees

Check that the number of employees variables match to the activities

Check if Employees for activity 1 is greater than 0 (where activity 1 exists) 
    ESTID TOTAL_EMP_1 N
1: VPXSKP           0 1
2: SMJTQ6           0 1
Check if Employees for activity 2 is greater than 0 (where activity 2 exists) 
[1] "No results"
Check if Employees for activity 3 is greater than 0 (where activity 3 exists) 
[1] "No results"
Check if Employees for activity 4 is greater than 0 (where activity 4 exists) 
[1] "No results"

P2.10

Check that all of the P2.10 sections work with their predefined rules

First Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 1 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has only 1 Activity but P2.10A is not 100% 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 1 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has only 1 Activity but P2.10B is not 100% 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 1 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has only 1 Activity but P2.10C is not 100% 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 2 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has 2 Activities but P2.10A is not 100% when summed across both 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 2 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has 2 Activities but P2.10B is not 100% when summed across both 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 2 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has 2 Activities but P2.10C is not 100% when summed across both 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 3 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has 3 Activities but P2.10A is not 100% when summed across all 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 3 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has 3 Activities but P2.10B is not 100% when summed across all 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 3 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has 3 Activities but P2.10C is not 100% when summed across all 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has an Activity 4 but P2.10A is -1,-2 
[1] "No results"
Next Check if the EST has LCV vehicles, has departures of those LCV, has 4 Activities but P2.10A is not 100% when summed across all 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has an Activity 4 but P2.10B is -1,-2 
[1] "No results"
Next Check if the EST has RIGID vehicles, has departures of those RIGID, has 4 Activities but P2.10B is not 100% when summed across all 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has an Activity 4 but P2.10C is -1,-2 
[1] "No results"
Next Check if the EST has ART vehicles, has departures of those ART, has 4 Activities but P2.10C is not 100% when summed across all 
[1] "No results"
Finally check if all the people with no vehicles have -2 all the way through (look for anything not -2) 
Empty data.table (0 rows and 5 cols): P2_10A_1,P2_10A_2,P2_10A_3,P2_10A_4,N
Empty data.table (0 rows and 5 cols): P2_10B_1,P2_10B_2,P2_10B_3,P2_10B_4,N
Empty data.table (0 rows and 5 cols): P2_10C_1,P2_10C_2,P2_10C_3,P2_10C_4,N

P2.7

Check that P2.7 and the dispositions are correct
P2.7 check table
Q2 P2_7 4211
1 -2 18

Final Survey Status

Check that Final status makes sense
Final Status
FinalStatus Disposition N
4 4211 18

Incompleted Survey Tables

                                        Displabel    N
 1:                                 Ok For Phase2 1185
 2:                          Complete: No Vehicle 4051
 3:                                Refused Phase2  966
 4: Frame Correction - Cannot Find In Land Parcel  470
 5:             Sample Loss - Vacant / Unoccupied  774
 6:  Frame Correction - Duplicate / Same As Other  454
 7:                 Sample Loss - No Such Address   27
 8:                           Sample Loss - Other  151
 9:                  Sample Loss - Not Commercial   53
10: Sample Loss - Vacant Land / Underconstruction   49
11:                              Maybe For Phase2   18
12:              RI Refused: Vehicles - Completed   18
13:   RI Started - Not Finished: Vehicles Unknown    1
14:                  Sample Loss - Covid19 Closed   18
RI Started - Not Finished: Vehicles Unknown 
    ESTID N
1: ZFQUUJ 1
Call Back - Primary 
[1] "No Cases"
Call Back - Secondary 
[1] "No Cases"
Appointment 
[1] "No Cases"
RI Refused: No Vehicles 
[1] "No Cases"
RI Refused: Vehicles - Not Completed 
[1] "No Cases"
RI Refused: Vehices Unknown 
[1] "No Cases"
RI Started - Not Finished: Vehicles 
[1] "No Cases"
UATC Unable to reach right person 
[1] "No Cases"
UATC No answer 
[1] "No Cases"
SAMPLE LOSS TABLE
Sample Loss Table
Displabel N
Frame Correction - Cannot Find In Land Parcel 470
Sample Loss - Vacant / Unoccupied 774
Frame Correction - Duplicate / Same As Other 454
Sample Loss - No Such Address 27
Sample Loss - Other 151
Sample Loss - Not Commercial 53
Sample Loss - Vacant Land / Underconstruction 49
Sample Loss - Covid19 Closed 18

Summary Vehicles Counts

C
Vecicles by C
bitkey N LCV RIG ART LCVmean RIGmean ARTmean
000 3635 -1 -1 -1 -0.0002751 -0.0002751 -2.751e-04
110 36 71 62 0 1.9722222 1.7222222 0.000e+00
NANANA 584 NA NA NA NA NA NA
100 286 568 0 0 1.9860140 0.0000000 0.000e+00
111 2 10001 9999 9998 5000.5000000 4999.5000000 4.999e+03
010 15 0 25 0 0.0000000 1.6666667 0.000e+00
101 2 7 0 7 3.5000000 0.0000000 3.500e+00
NANA0 1 NA NA NA NA NA NA
I
Vecicles by I
bitkey N LCV RIG ART LCVmean RIGmean ARTmean
110 192 678 442 0 3.531250 2.302083 0.0000
100 458 1305 0 0 2.849345 0.000000 0.0000
000 1033 NA NA NA NA NA NA
NANANA 395 NA NA NA NA NA NA
101 7 30 0 21 4.285714 0.000000 3.0000
010 43 0 76 0 0.000000 1.767442 0.0000
011 4 0 35 24 0.000000 8.750000 6.0000
111 16 203 352 91 12.687500 22.000000 5.6875
001 1 0 0 2 0.000000 0.000000 2.0000
P
Vecicles by P
bitkey N LCV RIG ART LCVmean RIGmean ARTmean
000 213 NA NA NA NA NA NA
NANANA 91 NA NA NA NA NA NA
100 16 23 0 0 1.4375 0 0.0
110 6 27 30 0 4.5000 5 0.0
111 2 18 26 3 9.0000 13 1.5
R
Vecicles by R
bitkey N LCV RIG ART LCVmean RIGmean ARTmean
000 85 NA NA NA NA NA NA
100 11 23 0 0 2.090909 0 0
NANANA 13 NA NA NA NA NA NA
110 1 27 30 0 27.000000 30 0
SpG
Vecicles by SpG
bitkey N LCV RIG ART LCV_a RIG_a ART_a LCV_Ret RIG_Ret ART_Ret LCVmean RIGmean ARTmean
110 272 1272 689 0 851 409 0 6 49 0 4.676471 2.533088 0.000000
000 1083 NA NA NA NA NA NA NA NA NA NA NA NA
NANANA 505 NA NA NA NA NA NA NA NA NA NA NA NA
100 671 2503 0 0 1063 0 0 NA NA NA 3.730253 0.000000 0.000000
010 63 0 157 0 0 93 0 0 14 0 0.000000 2.492063 0.000000
111 53 10353 10398 10336 212 237 231 3 14 19 195.339623 196.188679 195.018868
101 17 55 0 74 49 0 58 0 0 4 3.235294 0.000000 4.352941
001 7 0 0 47 0 0 25 NA NA NA 0.000000 0.000000 6.714286
011 4 0 16 12 0 9 9 0 1 7 0.000000 4.000000 3.000000

Green Form

Q5SUM or Q6SUM <>100% and <> -2 (basically every cases where data =-1 or where the answers do not add up to 100%)
Should we check Q1 = -1? 
[1] "Sorry the check you have asked for provides a 0 sum result.... this is the reality of life, sometimes you looks for an answer but get nothing..."
Should we check Q2 = -1? 
[1] "What do you get when you ask for any of these questions being equal to -1... nothing that is what you get, like the void in the Fremantle Dockers trophy cabinet"
Should we check Q3 = -1? 
     ESTID GF_Q3A GF_Q3B GF_Q3C Stratum_Master
 1: 8K5UE2     -1     -1     -1             SG
 2: BK7HZV     -1     -2     -2             SG
 3: ERR7YK     -2     -1     -2             SG
 4: JEVXGQ     -1     -2     -2             SG
 5: PS2HGY     -1     -1     -2             SG
 6: QCFN5O     10     -1     -2             SG
 7: URZGPD     -1      4     -2             SG
 8: VJ57VF      1     -1     -2             SG
 9: 3B6UZ8     -1     -1     -2              C
10: 7EGWUK     -1     -2     -2              C
11: CVGSKE     -1     -1     -2              C
12: H5YRJE     -1     -2     -2              C
13: PTTS6H     -1     -2     -2              C
14: W8K2TC     -1      2     -2              C
15: Y7VKGC     -1     -2     -2              C
16: 2REPS9      4     -2     -1              I
17: FRCC88      5     -1     -2              I
18: GJZRF5     -1     -1     -2              I
19: S5VWEN     -2      5     -1              I
20: TBNGWD     -2     -1     -2              I
21: YJ9JUU      4     -1     -1              I
22: 7H995J     -1     -2     -1              I
23: DQ2VRQ      2     -1     -2              I
24: EQV9WB     -1     -2     -2              C
25: ETFBWU     -1     -2     -2              C
26: 295GZH     -1     -2     -2              I
27: F7ZBXR     -1     -2     -2              I
28: YZT9UB      3     -1     -2             SG
29: MGXCCT     -1     -2     -2              C
30: KR6EUD      8     10     -1             SG
31: SURN2D     -1     -2     -2              I
32: S2D95J     -1     -2     -2              I
33: WM3X5P     -1     -1     -2             SG
34: SFHJW6      2     -1     -2              C
35: 6CB6MP     -1     -2     -2              C
36: VYYW97     -1     -2     -2              I
37: PZMZYH     -1     -2     -2              C
38: TXU5T8     -2     -1     -2              I
39: Q6QBVS     -1     -2     -2             SG
40: 5GQJ9E     -1     -2     -2             SG
41: 99JQ62      6     -2     -1              I
42: KX5SQF     -2     -1     -2              I
43: PNXRWB     -1     -2     -2              I
44: BRN5QY      1     -1     -2              C
45: FEDZST     -1     -1     -2              C
46: UWQKEM     -1     -1     -2              C
47: 8EU8SZ     22     -2     -1             SG
48: 85WYZQ     -2     -1     -2             SG
49: Q7CU2M      2     -1     -2             SG
50: 2G5JFB     -1     -2     -2              I
51: UHF6PF     -1     -2     -2             SG
52: F3EV5X     -1     -2     -2             SG
53: YBW55V     -1     -1     -1             SG
54: 7Y388T     -1     -1     -2             SG
55: EP2PEG     -1     -2     -2             SG
56: XKWM7B     -1     -2     -2             SG
57: 9BHNSU      2     -2     -1             SG
58: H78Y56     -2     -1     -2              I
59: V7CSR7     -2     -1     -2              C
60: UEN6BT     -2     -1     -2             SG
61: 9PPGK6     -1     -2     -2             SG
62: JRB58E     -1      6     -2             SG
63: VGVBCQ     -1      1     -2             SG
64: CRQBQS     -1     -2     -2              C
65: K6CJBT     30     -1     -2             SG
66: C3M255     10     -1     -1             SG
67: NUHVS3     -1     -1     -2             SG
68: X2QME5     -1     -2     -2              C
69: TUTHD6      2     -1     -2             SG
70: BJYK7T      2     -1     -2             SG
71: EHVDMW      2     -1     -2             SG
72: KQUH77      4     -1     -2             SG
73: 7YP7YS     -2     -1     -1             SG
74: 7WYS7G     -2     -1     -2              C
75: FGHRTT     -1     -2     -2              I
76: F88J8W      3     -1     -2             SG
77: T6XHGX     -1     -2     -2              C
78: 2HZW7W     -1     10     -2              C
79: JC7SHU      1     -1     -2             SG
80: PPP7DQ     -1     -2     -2              I
81: YED29Y     -2     -1     -2             SG
82: SPK76G     -1     -2     -2              C
83: X9TT69     -1     -2     -2             SG
84: G62UXJ     -1     -1     -2              I
85: 372U95     -1      1     -2             SG
86: DMRPQR      6     -1     -2              I
     ESTID GF_Q3A GF_Q3B GF_Q3C Stratum_Master
Should we check Q4 = -1?
because the table was too big
ESTID GF_Q4A GF_Q4B GF_Q4C Stratum_Master
8K5UE2 -1 -1 -1 SG
9C7BF8 -2 -1 -2 SG
ERR7YK -2 -1 -2 SG
JEVXGQ -1 -2 -2 SG
URZGPD -1 40000 -2 SG
VGKYVX -1 -1 -2 SG
VJ57VF 100000 -1 -2 SG
ZK8167 -1 -1 -2 SG
3B6UZ8 -1 -1 -2 C
79KCJV -1 -2 -2 C
7EGWUK -1 -2 -2 C
H5YRJE -1 -2 -2 C
PTTS6H -1 -2 -2 C
W8K2TC -1 11000 -2 C
Y7VKGC -1 -2 -2 C
2REPS9 120000 -2 -1 I
6RGRD5 -1 -2 -2 I
86DV8D -1 -2 -2 I
GJZRF5 -1 -1 -2 I
PWSUP5 -2 -1 -2 I
S5VWEN -2 1120000 -1 I
TBNGWD -2 -1 -2 I
7H995J -1 -2 -1 I
JXWQFP -1 -1 -2 SG
EQV9WB -1 -2 -2 C
RUKGEN -1 -2 -2 SG
ETFBWU -1 -2 -2 C
ZB7ZPQ -1 -2 -2 SG
F7ZBXR -1 -2 -2 I
MGXCCT -1 -2 -2 C
7WXUST -1 -2 -2 I
SURN2D -1 -2 -2 I
S2D95J -1 -2 -2 I
KUJEU2 -1 -2 -2 I
WM3X5P -1 -1 -2 SG
5EKY37 -1 -2 -2 SG
SFHJW6 40000 -1 -2 C
X7HR5W -1 -2 -2 SG
5GM2TU 50000 50000 -1 SG
6CB6MP -1 -2 -2 C
VYYW97 -1 -2 -2 I
PZMZYH -1 -2 -2 C
TXU5T8 -2 -1 -2 I
E8VYM3 -1 -2 -2 SG
Q6QBVS -1 -2 -2 SG
5GQJ9E -1 -2 -2 SG
Y9B7PH -1 20000 -2 I
K9MSX3 -2 -1 -2 SG
99JQ62 -1 -2 -1 I
KX5SQF -2 -1 -2 I
PEYEXR -2 -1 -2 I
FEDZST -1 -1 -2 C
S2W7YC -1 -1 -2 I
3XHJJJ -2 -1 -2 I
GCUBVW -1 -2 -2 SG
8EU8SZ 100000 -2 -1 SG
85WYZQ -2 -1 -2 SG
WY87SQ -1 -2 -2 I
GDF9KZ 187500 -1 2400000 I
2G5JFB -1 -2 -2 I
YBW55V -1 -1 -1 SG
7Y388T -1 -1 -2 SG
QD5ZH2 -1 -1 -2 SG
XKWM7B -1 -2 -2 SG
RYCKCN -1 -1 -1 SG
EYGHKG -1 -1 -2 SG
9BHNSU 120000 -2 -1 SG
FZMGZJ -1 -2 -2 SG
PRFKF6 -1 -1 -2 SG
ZBJY6B -1 -2 -2 I
H78Y56 -2 -1 -2 I
H5JY55 -1 -2 -2 C
V7CSR7 -2 -1 -2 C
7SR2HX -1 -2 -2 I
C6S26R -1 12000 -2 SG
BMJT9V -1 -1 -1 SG
VGVBCQ -1 3600 -2 SG
CRQBQS -1 -2 -2 C
C3M255 -1 -1 -1 SG
TUTHD6 10000 -1 -2 SG
BJYK7T 10000 -1 -2 SG
KQUH77 15000 -1 -2 SG
7YP7YS -2 -1 -1 SG
7WYS7G -2 -1 -2 C
27DNMZ -1 -2 -2 SG
8RCZPM -2 -1 -2 SG
9FE8SV -1 -2 -2 C
XHNDMD 20000 -1 -2 I
F88J8W 100000 -1 -2 SG
ZRPHVG -1 -1 -2 SG
T6XHGX -1 -2 -2 C
2HZW7W -1 60000 -2 C
EFSWBE -1 -1 -2 I
SPK76G -1 -2 -2 C
X9TT69 -1 -2 -2 SG
YPDVS8 -1 10000 -2 SG
G62UXJ -1 -1 -2 I
9VVE22 -1 -2 -2 I
372U95 -1 -1 -2 SG
DT7296 -1 35000 -2 SG
DMRPQR -1 -1 -2 I
This is the check for LCV (Q5A)
This is the check for RIGID (Q5B)
This is the check for ART (Q5C)
This is the check for LCV (Q6A)
This is the check for RIGID (Q6B)
This is the check for ART (Q6C)
Lets look at Q9 - shouldnt be any -1 responses
Q9 on the green form is -1…
ESTID GF_Q9
3B6UZ8 -1
7EGWUK -1
H5YRJE -1
Y7VKGC -1
EQV9WB -1
FEDZST -1
CRQBQS -1
7WYS7G -1
T6XHGX -1

Ok, now to check Q11…

Q12 checking the departures, all aboard!

Q12 Departures have a -1 response
ESTID Stratum_Master GF_Q12A_1 GF_Q12A_2 GF_Q12A_3 GF_Q12A_4 GF_Q12A_5 GF_Q12A_6 GF_Q12A_7 GF_Q9
2VJJJT SG -1 -1 -1 -1 -1 -1 -1 1
5WZ5CP SG -1 -1 -1 -1 -1 -1 -1 1
GZ7CK8 SG -1 -1 -1 -1 -1 -1 -1 1
J7TC3D SG -1 -1 -1 -1 -1 -1 -1 1
KGE65C SG -1 -1 -1 -1 -1 -1 -1 1
PJ22SS SG -1 -1 -1 -1 -1 -1 -1 1
RDUDHW SG -1 -1 -1 -1 -1 -1 -1 1
SXVMVC SG -1 -1 -1 -1 -1 -1 -1 1
ZB2HEF C -1 -1 -1 -1 -1 -1 -1 1
JQENM3 I -1 -1 -1 -1 -1 -1 -1 1
KR6EUD SG -1 -1 -1 -1 -1 -1 -1 1
RCK6CG I -1 -1 -1 -1 -1 -1 -1 1
9E57Q3 I -1 -1 -1 -1 -1 -1 -1 1
H7TN6F C -1 -1 -1 -1 -1 -1 -1 1
SDPQXU I -1 -1 -1 -1 -1 -1 -1 1
RJ2SGZ I -1 -1 -1 -1 -1 -1 -1 1
YBW55V SG -1 -1 -1 -1 -1 -1 -1 1
HQRNRX I -1 -1 -1 -1 -1 -1 -1 1
MJGR5E SG -1 -1 -1 -1 -1 -1 -1 1
T5C8MV I -1 -1 -1 -1 -1 -1 -1 1
PDU9W6 I -1 -1 -1 -1 -1 -1 -1 1
X8FY7J I -1 -1 -1 -1 -1 -1 -1 1
HZMQD5 I -1 -1 -1 -1 -1 -1 -1 1
K6CJBT SG -1 -1 -1 -1 -1 -1 -1 1
NWJDGF SG -1 -1 -1 -1 -1 -1 -1 1
EKRKRK I -1 -1 -1 -1 -1 -1 -1 1
WNB98X C -1 -1 -1 -1 -1 -1 -1 1
6XRCZE C -1 -1 -1 -1 -1 -1 -1 1
JPMKXN SG -1 -1 -1 -1 -1 -1 -1 1
HRFGUX SG -1 -1 -1 -1 -1 -1 -1 1

Q12 checking the arrivals, the next station is…!

Q12 Arrivals have a -1 response
ESTID Stratum_Master GF_Q12B_1 GF_Q12B_2 GF_Q12B_3 GF_Q12B_4 GF_Q12B_5 GF_Q12B_6 GF_Q12B_7 GF_Q9
2VJJJT SG -1 -1 -1 -1 -1 -1 -1 1
5WZ5CP SG -1 -1 -1 -1 -1 -1 -1 1
GZ7CK8 SG -1 -1 -1 -1 -1 -1 -1 1
J7TC3D SG -1 -1 -1 -1 -1 -1 -1 1
KGE65C SG -1 -1 -1 -1 -1 -1 -1 1
PJ22SS SG -1 -1 -1 -1 -1 -1 -1 1
RDUDHW SG -1 -1 -1 -1 -1 -1 -1 1
SXVMVC SG -1 -1 -1 -1 -1 -1 -1 1
ZB2HEF C -1 -1 -1 -1 -1 -1 -1 1
JQENM3 I -1 -1 -1 -1 -1 -1 -1 1
KR6EUD SG -1 -1 -1 -1 -1 -1 -1 1
RCK6CG I -1 -1 -1 -1 -1 -1 -1 1
9E57Q3 I -1 -1 -1 -1 -1 -1 -1 1
H7TN6F C -1 -1 -1 -1 -1 -1 -1 1
SDPQXU I -1 -1 -1 -1 -1 -1 -1 1
RJ2SGZ I -1 -1 -1 -1 -1 -1 -1 1
YBW55V SG -1 -1 -1 -1 -1 -1 -1 1
HQRNRX I -1 -1 -1 -1 -1 -1 -1 1
MJGR5E SG -1 -1 -1 -1 -1 -1 -1 1
ZE9JUX I -1 -1 -1 -1 -1 -1 -1 1
T5C8MV I -1 -1 -1 -1 -1 -1 -1 1
PDU9W6 I -1 -1 -1 -1 -1 -1 -1 1
X8FY7J I -1 -1 -1 -1 -1 -1 -1 1
HZMQD5 I -1 -1 -1 -1 -1 -1 -1 1
K6CJBT SG -1 -1 -1 -1 -1 -1 -1 1
NWJDGF SG -1 -1 -1 -1 -1 -1 -1 1
EKRKRK I -1 -1 -1 -1 -1 -1 -1 1
WNB98X C -1 -1 -1 -1 -1 -1 -1 1
6XRCZE C -1 -1 -1 -1 -1 -1 -1 1
JPMKXN SG -1 -1 -1 -1 -1 -1 -1 1
5V58SP SG -1 -1 -1 -1 -1 -1 -1 1
HRFGUX SG -1 -1 -1 -1 -1 -1 -1 1
Q13 last check YAY
Q13 has a -1 response
ESTID Stratum_Master GF_Q13
V8FTHK I -1
KR6EUD SG -1
QFJ6XC SG -1
5GZKWQ I -1
H7TN6F C -1
SDPQXU I -1
KMGY56 SG -1
MJGR5E SG -1
XPEUTE SG -1
NWJDGF SG -1
WNB98X C -1
6XRCZE C -1

Check that the Q2A-Q2C codes match what is in the RI Q8 data.

Blue Form

Orange Form

          PSU.x  N
 1:        <NA> 36
 2:        3001  6
 3:        8505 42
 4:        8658 56
 5:        8653 47
 6: 50503110010  3
 7:        8639 28
 8:        8645 29
 9: 50503110360  2
10: 50501108116  2
11: 50604113415  1
12:        8538  1
13: 50502108905  1
14: 50501107823  2
15:        8647 20
16: 50604113709  2
17: 50302103927  1
18: 50501108008  2
19: 50501107417  1
20: 50501107006  1
21: 50503109813  1
22: 50604113621  1
23: 50604113628  4
24:        8624  1
25: 50502109013  3
26: 50604113624  1
27:        3262  2
28:        8618  1
29:        8620  1
30: 50604113419  1
31: 50604113346  1
32: 50503110117  1
33: 50604113208  2
34: 50502109025  1
35: 50604113505  2
36: 50501107209  2
37: 50502108628  1
38: 50503110029  1
39: 50501108310  2
40:         648  2
41:         718  1
42:         838  1
43:        8633  2
44:        8558  2
45:        8529  1
46:        8616  1
47:        3264  2
48: 50503109918  1
49: 50604113712  1
50: 50502108924  1
51: 50604113410  1
          PSU.x  N