Disposition Summary Table

Summary Table of all dispositions by Q2

Disposition	-2	1	2
2001	29	NA	NA
2002	60	NA	NA
2003	808	NA	NA
2004	61	NA	NA
2005	577	NA	NA
2006	504	NA	NA
2007	48	NA	NA
2096	156	NA	NA
4211	NA	21	NA
5101	NA	NA	4352
5221	NA	1446	NA
5223	NA	1188	NA

ESTID duplicate check (RI)

Empty data.table (0 rows and 2 cols): ESTID,count

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
5223	1	1188
5221	1	1446
5101	2	4352

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	11	12	13	15	19	20	21	23	25	30	40	42	48	55	57	61	100	190	200	9997
1	NA	25	42	25	16	12	6	2	4	4	1	2	1	2	1	2	1	1	1	1	1	1	4	1	1	1	1	1	1	1	1	9
2	6804	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
97	10	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

Q2_3_B

Q2_3_B

Q2_1	-2	0	1	2	3	4	5	6	8	10	14	19	20	23	26	32	45	50	73	9997
1	NA	102	21	10	3	6	3	2	2	3	1	1	2	1	1	1	2	1	1	9
2	6804	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
97	10	NA	NA	NA	NA	NA	NA	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	5	8	10	54	9997
1	NA	139	7	5	3	1	2	4	1	1	9
2	6804	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
97	10	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA

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	0	1	2	3	4	5	6	7	8	9	10	11	12	15	17	19	20	21	23	40	46	9997
1	NA	58	231	60	26	16	8	7	5	1	1	2	1	1	2	1	1	1	1	2	1	1	5
2	6550	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
97	4	NA	NA	NA	NA	NA	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	9	10	11	14	15	20	22	25	40	43	149	9997
1	NA	320	42	19	6	7	6	5	4	2	1	3	1	2	1	2	1	1	1	1	1	6
2	6550	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
97	4	NA	NA	NA	NA	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	405	6	6	2	2	1	1	1	1	6
2	6550	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
97	4	NA	NA	NA	NA	NA	NA	NA	NA	NA	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: U5NQKN      4      3      0
  2: W8K2TC      1      2      0
  3: TBWSP2      3      0      0
  4: 35U2V3      2      0      0
  5: QZYQZH      1      0      0
 ---                            
327: 6CX76X      2      0      0
328: XRMP6K      4      0      0
329: H9XBXH      1      0      0
330: ZERFNY      0      6      0
331: F3KFJQ      4      1      0

Manages Vehicles on Site

Manage_LCV

Manage_LCV

Disposition	NA	-2	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	27	28	29	30	31	34	35	36	38	40	41	45	48	49	50	55	56	58	59	62	65	69	70	75	86	100	110	121	150
5101	1	4351	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	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA
5221	NA	NA	102	521	295	153	110	68	39	29	16	12	23	5	17	4	4	10	1	5	1	NA	7	NA	2	1	1	NA	1	1	NA	3	1	NA	1	NA	NA	1	2	1	NA	1	1	NA	1	NA	1	NA	NA	1	1	1	NA	NA	NA	1	1
5223	NA	NA	78	496	232	121	69	47	30	19	20	6	15	2	4	3	4	7	1	1	2	2	3	1	NA	1	NA	1	NA	1	1	NA	NA	1	3	1	1	NA	NA	2	1	NA	2	1	1	1	NA	1	1	NA	NA	NA	2	1	1	NA	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	NA	-2	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	19	20	21	22	23	25	28	30	32	34	35	37	40	44	50	54	57	64	79	96	180
5101	1	4351	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	NA	891	273	103	46	36	20	9	8	10	6	9	3	6	3	1	2	2	NA	1	3	NA	NA	1	4	NA	1	NA	1	2	NA	1	NA	1	NA	NA	1	NA	1	1
5223	NA	NA	786	216	69	25	28	11	10	6	5	1	5	1	2	2	2	3	1	1	NA	NA	2	2	1	NA	1	NA	1	NA	2	1	NA	1	NA	1	1	NA	1	NA	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	11	12	13	14	15	16	17	18	19	20	21	22	23	25	26	27	28	30	34	40	44	45	61	65	121	130	150	164	9997
5101	4352	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	NA
5221	NA	1311	34	13	18	11	9	8	7	6	1	2	2	2	NA	4	2	1	2	1	1	1	NA	1	1	1	NA	1	1	NA	NA	NA	1	NA	1	NA	1	NA	1	1	NA
5223	NA	1104	26	15	5	5	2	3	2	1	1	4	NA	1	1	1	1	NA	1	NA	1	2	1	NA	NA	2	1	NA	NA	1	1	2	NA	1	NA	1	NA	1	NA	NA	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"

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	-1	9997
5221	1	2	1
5223	1	NA	3

Check that if LCV<0 then Q8A must equal -2

Q8A - no veh, no departure

Disposition	Q2	-2
5101	2	4351

ESTID of errors:

    ESTID Q2  Q8A N
1: FZ3RSG  1   -1 1
2: CESNX7  1   -1 1
3: YZCYWS  1 9997 1
4: 5GQJ9E  1 9997 1
5: UJBSPV  1 9997 1
6: D6D9UE  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	-1
5223	1	1

Check that if Rigid<0 then Q8B must equal -2

Q8B - no veh, no departure

Disposition	Q2	-2
5101	2	4351

ESTID of errors:

    ESTID Q2 Q8B N
1: XXEM6T  1  -1 1

[1] "No results"

filter down to just those with Articulated and the answer to Q8C is 9997,-1, or -2

Q8C = DK, missing, NA

Disposition	Q2	9997
5221	1	1
5223	1	1

Check that if Articulated<0 then Q8C must equal -2

Q8C - no veh, no departure

Disposition	Q2	-2
5101	2	4352

ESTID of errors:

    ESTID Q2  Q8C N
1: 9H8CVG  1 9997 1
2: REP058  1 9997 1

[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	2634

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	4352

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	367
6	459
5	1785
3	8
2	3
4	11
1	1

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 4352

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	2331
1	27
2	54
5	35
4	157

ESTID with Error:

[1] "No results"

Monday - Has vehicles and is closed

Q11_NEW_1	N
-2	30

ESTID with Error:

[1] "No results"

Tuesday - Has vehicles and is open

Q11_NEW_2	N
3	2428
1	30
2	38
4	106
5	15

ESTID with Error:

[1] "No results"

Tuesday - Has vehicles and is closed

Q11_NEW_2	N
-2	17

ESTID with Error:

[1] "No results"

Wednesday - Has vehicles and is open

Q11_NEW_3	N
3	2452
1	24
4	89
2	43
5	19

ESTID with Error:

[1] "No results"

Wednesday - Has vehicles and is closed

Q11_NEW_3	N
-2	7

ESTID with Error:

[1] "No results"

Thursday - Has vehicles and is open

Q11_NEW_4	N
3	2444
1	26
5	21
2	34
4	101

ESTID with Error:

[1] "No results"

Thursday - Has vehicles and is closed

Q11_NEW_4	N
-2	8

ESTID with Error:

[1] "No results"

Friday - Has vehicles and is open

Q11_NEW_5	N
3	2321
4	166
2	57
5	39
1	36

ESTID with Error:

[1] "No results"

Friday - Has vehicles and is closed

Q11_NEW_5	N
-2	15

ESTID with Error:

[1] "No results"

Saturday - Has vehicles and is open

Q11_NEW_6	N
3	392
1	238
4	27
2	163
5	12

ESTID with Error:

[1] "No results"

Saturday - Has vehicles and is closed

Q11_NEW_6	N
-2	1802

ESTID with Error:

[1] "No results"

Sunday - Has vehicles and is open

Q11_NEW_7	N
3	176
4	14
1	139
2	63
5	6

ESTID with Error:

[1] "No results"

Sunday - Has vehicles and is closed

Q11_NEW_7	N
-2	2236

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	2092
4	205
1	56
2	231
5	50

ESTID with Error:

[1] "No Results"

January - No vehicles

Q12_NEW_1	N
-2	4352

ESTID with Error:

[1] "No Results"

February - Has vehicles

Q12_NEW_2	N
3	2348
4	163
2	59
1	12
5	52

ESTID with Error:

[1] "No Results"

February - No vehicles

Q12_NEW_2	N
-2	4352

ESTID with Error:

[1] "No Results"

March - Has vehicles

Q12_NEW_3	N
3	2383
4	131
2	58
1	24
5	38

ESTID with Error:

[1] "No Results"

March - No vehicles

Q12_NEW_3	N
-2	4352

ESTID with Error:

[1] "No Results"

April - Has vehicles

Q12_NEW_4	N
3	2380
5	28
1	44
4	124
2	58

ESTID with Error:

[1] "No Results"

April - No vehicles

Q12_NEW_4	N
-2	4352

ESTID with Error:

[1] "No Results"

May - Has vehicles

Q12_NEW_5	N
3	2451
4	74
1	30
2	69
5	10

ESTID with Error:

[1] "No Results"

May - No vehicles

Q12_NEW_5	N
-2	4352

ESTID with Error:

[1] "No Results"

June - Has vehicles

Q12_NEW_6	N
3	2343
2	142
4	111
1	22
5	16

ESTID with Error:

[1] "No Results"

June - No vehicles

Q12_NEW_6	N
-2	4352

ESTID with Error:

[1] "No Results"

July - Has vehicles

Q12_NEW_7	N
3	2346
2	155
1	23
4	97
5	13

ESTID with Error:

[1] "No Results"

July - No vehicles

Q12_NEW_7	N
-2	4352

ESTID with Error:

[1] "No Results"

August - Has vehicles

Q12_NEW_8	N
3	2410
2	127
1	16
4	63
5	18

ESTID with Error:

[1] "No Results"

August - No vehicles

Q12_NEW_8	N
-2	4352

ESTID with Error:

[1] "No Results"

September - Has vehicles

Q12_NEW_9	N
3	2435
1	4
4	103
2	64
5	28

ESTID with Error:

[1] "No Results"

September - No vehicles

Q12_NEW_9	N
-2	4352

ESTID with Error:

[1] "No Results"

October - Has vehicles

Q12_NEW_10	N
3	2360
4	190
1	4
5	44
2	36

ESTID with Error:

[1] "No Results"

October - No vehicles

Q12_NEW_10	N
-2	4352

ESTID with Error:

[1] "No Results"

November - Has vehicles

Q12_NEW_11	N
3	2225
4	284
5	84
2	34
1	7

ESTID with Error:

[1] "No Results"

November - No vehicles

Q12_NEW_11	N
-2	4352

ESTID with Error:

[1] "No Results"

December - Has vehicles

Q12_NEW_12	N
3	1796
4	381
5	138
2	263
1	56

ESTID with Error:

[1] "No Results"

December - No vehicles

Q12_NEW_12	N
-2	4352

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	29
5221	3
5223	5

ESTID of errors:

     ESTID Disposition ARRIVALS_LCV N
 1: XQQKF6        5101         9997 1
 2: RQWUHU        5101         9997 1
 3: QEJMEP        5101         9997 1
 4: HUXYWY        5101         9997 1
 5: 8G38BS        5101         9997 1
 6: JB2WPP        5101         9997 1
 7: 2VEPT6        5101         9997 1
 8: T89Q6X        5101         9997 1
 9: GURZ98        5101         9997 1
10: 7Y5NME        5101         9997 1
11: YCY5W7        5101         9997 1
12: F5VN9N        5101         9997 1
13: KNJQ77        5101         9997 1
14: BTDEWQ        5101         9997 1
15: GNXDS7        5101         9997 1
16: T5QXCQ        5101         9997 1
17: FEWD2W        5101         9997 1
18: 87JX57        5101         9997 1
19: 787G5H        5223         9997 1
20: DQSFSG        5101         9997 1
21: 8JMGTP        5223         9997 1
22: WDN28U        5221         9997 1
23: R9RN3U        5101         9997 1
24: 5GQJ9E        5223         9997 1
25: TXYRG7        5101         9997 1
26: C7C9W9        5101         9997 1
27: 69V6YT        5101         9997 1
28: SP27R6        5101         9997 1
29: Y2PV5S        5101         9997 1
30: 2PCVGJ        5101         9997 1
31: 2NDJ3F        5221         9997 1
32: MZ8Q9J        5221         9997 1
33: B35CYP        5101         9997 1
34: U588SU        5223         9997 1
35: N3PXZ7        5101         9997 1
36: UWSWNP        5223         9997 1
37: 28CKYF        5101         9997 1
     ESTID Disposition ARRIVALS_LCV N

RIGID Arrivals

ARRIVALS_RIGID = DK, missing, NA

Disposition	9997
5101	32
5221	3
5223	7

ESTID of errors:

     ESTID Disposition ARRIVALS_RIGID N
 1: NSUYR6        5101           9997 1
 2: 0AUM5M        5101           9997 1
 3: XQQKF6        5101           9997 1
 4: QEJMEP        5101           9997 1
 5: 8G38BS        5101           9997 1
 6: 2VEPT6        5101           9997 1
 7: T89Q6X        5101           9997 1
 8: T92MMC        5101           9997 1
 9: GURZ98        5101           9997 1
10: VCZNXE        5101           9997 1
11: 7Y5NME        5101           9997 1
12: YCY5W7        5101           9997 1
13: NT2VYU        5101           9997 1
14: F5VN9N        5101           9997 1
15: QMKN5Z        5223           9997 1
16: BTDEWQ        5101           9997 1
17: HE32DC        5101           9997 1
18: HPBXS9        5101           9997 1
19: GNXDS7        5101           9997 1
20: T5QXCQ        5101           9997 1
21: ENFFYY        5101           9997 1
22: FEWD2W        5101           9997 1
23: 87JX57        5101           9997 1
24: D9UPGX        5101           9997 1
25: 787G5H        5223           9997 1
26: DQSFSG        5101           9997 1
27: RCKVB8        5223           9997 1
28: WDN28U        5221           9997 1
29: R9RN3U        5101           9997 1
30: DT93FY        5223           9997 1
31: 5GQJ9E        5223           9997 1
32: TXYRG7        5101           9997 1
33: C7C9W9        5101           9997 1
34: Y2PV5S        5101           9997 1
35: 2PCVGJ        5101           9997 1
36: 2NDJ3F        5221           9997 1
37: MZ8Q9J        5221           9997 1
38: B35CYP        5101           9997 1
39: U588SU        5223           9997 1
40: N3PXZ7        5101           9997 1
41: UWSWNP        5223           9997 1
42: 28CKYF        5101           9997 1
     ESTID Disposition ARRIVALS_RIGID N

LCV Articulated

ARRIVALS_ART = DK, missing, NA

Disposition	9997
5101	26
5221	3
5223	5

ESTID of errors:

     ESTID Disposition ARRIVALS_ART N
 1: NSUYR6        5101         9997 1
 2: 6EHWPD        5101         9997 1
 3: XQQKF6        5101         9997 1
 4: RQWUHU        5101         9997 1
 5: QEJMEP        5101         9997 1
 6: 8G38BS        5101         9997 1
 7: 2VEPT6        5101         9997 1
 8: T89Q6X        5101         9997 1
 9: GURZ98        5101         9997 1
10: 7Y5NME        5101         9997 1
11: YCY5W7        5101         9997 1
12: F5VN9N        5101         9997 1
13: QMKN5Z        5223         9997 1
14: BTDEWQ        5101         9997 1
15: HPBXS9        5101         9997 1
16: GNXDS7        5101         9997 1
17: T5QXCQ        5101         9997 1
18: FEWD2W        5101         9997 1
19: 87JX57        5101         9997 1
20: 787G5H        5223         9997 1
21: DQSFSG        5101         9997 1
22: WDN28U        5221         9997 1
23: R9RN3U        5101         9997 1
24: 5GQJ9E        5223         9997 1
25: TXYRG7        5101         9997 1
26: C7C9W9        5101         9997 1
27: Y2PV5S        5101         9997 1
28: 2PCVGJ        5101         9997 1
29: 2NDJ3F        5221         9997 1
30: MZ8Q9J        5221         9997 1
31: B35CYP        5101         9997 1
32: U588SU        5223         9997 1
33: N3PXZ7        5101         9997 1
34: UWSWNP        5223         9997 1
     ESTID Disposition ARRIVALS_ART N

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	-1	9997
5101	7	29
5221	4	3
5223	NA	5

ESTID of errors:

     ESTID Disposition OUTSOURCE_LCV N
 1: W39M52        5101            -1 1
 2: BV9YNN        5101            -1 1
 3: XQQKF6        5101          9997 1
 4: RQWUHU        5101          9997 1
 5: QEJMEP        5101          9997 1
 6: HUXYWY        5101          9997 1
 7: Q3PKZ8        5101            -1 1
 8: DBQ5ZB        5101            -1 1
 9: 8G38BS        5101          9997 1
10: JB2WPP        5101          9997 1
11: 2VEPT6        5101          9997 1
12: T89Q6X        5101          9997 1
13: GURZ98        5101          9997 1
14: 7Y5NME        5101          9997 1
15: YCY5W7        5101          9997 1
16: F5VN9N        5101          9997 1
17: KNJQ77        5101          9997 1
18: GU2ZR3        5101            -1 1
19: CMM3ZK        5101            -1 1
20: BTDEWQ        5101          9997 1
21: GNXDS7        5101          9997 1
22: T5QXCQ        5101          9997 1
23: FEWD2W        5101          9997 1
24: 87JX57        5101          9997 1
25: 787G5H        5223          9997 1
26: DQSFSG        5101          9997 1
27: 8JMGTP        5223          9997 1
28: MU33MP        5221            -1 1
29: WDN28U        5221          9997 1
30: R9RN3U        5101          9997 1
31: 5GQJ9E        5223          9997 1
32: BW6BQF        5221            -1 1
33: TXYRG7        5101          9997 1
34: JGGQVW        5101            -1 1
35: C7C9W9        5101          9997 1
36: 5B7TX9        5221            -1 1
37: Q6K7DG        5221            -1 1
38: 69V6YT        5101          9997 1
39: SP27R6        5101          9997 1
40: Y2PV5S        5101          9997 1
41: 2PCVGJ        5101          9997 1
42: 2NDJ3F        5221          9997 1
43: MZ8Q9J        5221          9997 1
44: B35CYP        5101          9997 1
45: U588SU        5223          9997 1
46: N3PXZ7        5101          9997 1
47: UWSWNP        5223          9997 1
48: 28CKYF        5101          9997 1
     ESTID Disposition OUTSOURCE_LCV N

If Arrivals >0 then Outsource = -2 makes Charlotte sad:

[1] "No results"

RIGID Outsourcing %

OUTSOURCE_RIGID = DK / missing

Disposition	-1	9997
5101	8	32
5221	3	3
5223	3	7

ESTID of errors:

     ESTID Disposition OUTSOURCE_RIGID N
 1: NSUYR6        5101            9997 1
 2: BSEQHT        5101              -1 1
 3: 0AUM5M        5101            9997 1
 4: C6JPQO        5101              -1 1
 5: W39M52        5101              -1 1
 6: BV9YNN        5101              -1 1
 7: A07O8K        5101              -1 1
 8: XQQKF6        5101            9997 1
 9: 5TDECP        5101              -1 1
10: QEJMEP        5101            9997 1
11: 8HRBPK        5221              -1 1
12: 8G38BS        5101            9997 1
13: 2VEPT6        5101            9997 1
14: T89Q6X        5101            9997 1
15: T92MMC        5101            9997 1
16: GURZ98        5101            9997 1
17: VCZNXE        5101            9997 1
18: 7Y5NME        5101            9997 1
19: YCY5W7        5101            9997 1
20: NT2VYU        5101            9997 1
21: F5VN9N        5101            9997 1
22: QMKN5Z        5223            9997 1
23: BTDEWQ        5101            9997 1
24: HE32DC        5101            9997 1
25: HPBXS9        5101            9997 1
26: GNXDS7        5101            9997 1
27: 7MMVZ6        5101              -1 1
28: T5QXCQ        5101            9997 1
29: ENFFYY        5101            9997 1
30: FEWD2W        5101            9997 1
31: 87JX57        5101            9997 1
32: D9UPGX        5101            9997 1
33: NRHGPB        5223              -1 1
34: 787G5H        5223            9997 1
35: DQSFSG        5101            9997 1
36: RCKVB8        5223            9997 1
37: WDN28U        5221            9997 1
38: R9RN3U        5101            9997 1
39: DT93FY        5223            9997 1
40: 5GQJ9E        5223            9997 1
41: BW6BQF        5221              -1 1
42: TXYRG7        5101            9997 1
43: SXQW7D        5221              -1 1
44: C7C9W9        5101            9997 1
45: YFEZHP        5101              -1 1
46: RNCS2W        5223              -1 1
47: WMN9DH        5223              -1 1
48: Y2PV5S        5101            9997 1
49: 2PCVGJ        5101            9997 1
50: 2NDJ3F        5221            9997 1
51: MZ8Q9J        5221            9997 1
52: B35CYP        5101            9997 1
53: U588SU        5223            9997 1
54: N3PXZ7        5101            9997 1
55: UWSWNP        5223            9997 1
56: 28CKYF        5101            9997 1
     ESTID Disposition OUTSOURCE_RIGID N

If Arrivals >0 then Outsource = -2 makes Charlotte sad:

[1] "No results"

Articulated Outsourcing %

OUTSOURCE_ART = DK / missing

Disposition	-1	9997
5101	4	26
5221	3	3
5223	3	5

ESTID of errors:

     ESTID Disposition OUTSOURCE_ART N
 1: NSUYR6        5101          9997 1
 2: 6EHWPD        5101          9997 1
 3: XQQKF6        5101          9997 1
 4: 5TDECP        5101            -1 1
 5: RQWUHU        5101          9997 1
 6: QEJMEP        5101          9997 1
 7: 68CE8M        5101            -1 1
 8: 8G38BS        5101          9997 1
 9: 2VEPT6        5101          9997 1
10: T89Q6X        5101          9997 1
11: WPXM3Q        5223            -1 1
12: GURZ98        5101          9997 1
13: 7Y5NME        5101          9997 1
14: YCY5W7        5101          9997 1
15: F5VN9N        5101          9997 1
16: QMKN5Z        5223          9997 1
17: BTDEWQ        5101          9997 1
18: HPBXS9        5101          9997 1
19: GNXDS7        5101          9997 1
20: T5QXCQ        5101          9997 1
21: FEWD2W        5101          9997 1
22: 87JX57        5101          9997 1
23: 787G5H        5223          9997 1
24: 98G9P5        5101            -1 1
25: DQSFSG        5101          9997 1
26: HRBRB9        5101            -1 1
27: MU33MP        5221            -1 1
28: WDN28U        5221          9997 1
29: R9RN3U        5101          9997 1
30: 5GQJ9E        5223          9997 1
31: TXYRG7        5101          9997 1
32: C7C9W9        5101          9997 1
33: YT3N6C        5223            -1 1
34: Y2PV5S        5101          9997 1
35: 9V68MU        5223            -1 1
36: 2PCVGJ        5101          9997 1
37: XJDEQ2        5221            -1 1
38: JH5PXH        5221            -1 1
39: 2NDJ3F        5221          9997 1
40: MZ8Q9J        5221          9997 1
41: B35CYP        5101          9997 1
42: U588SU        5223          9997 1
43: N3PXZ7        5101          9997 1
44: UWSWNP        5223          9997 1
     ESTID Disposition OUTSOURCE_ART N

If Arrivals >0 then Outsource = -2 makes Charlotte sad:

[1] "No results"

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	-1	9997
5101	7	29
5221	5	3
5223	2	5

ESTID of errors:

     ESTID Disposition INDCON_LCV N
 1: W39M52        5101         -1 1
 2: BV9YNN        5101         -1 1
 3: XQQKF6        5101       9997 1
 4: RQWUHU        5101       9997 1
 5: QEJMEP        5101       9997 1
 6: HUXYWY        5101       9997 1
 7: DWCE67        5223         -1 1
 8: Q3PKZ8        5101         -1 1
 9: DBQ5ZB        5101         -1 1
10: 8G38BS        5101       9997 1
11: JB2WPP        5101       9997 1
12: 2VEPT6        5101       9997 1
13: T89Q6X        5101       9997 1
14: GURZ98        5101       9997 1
15: 7Y5NME        5101       9997 1
16: YCY5W7        5101       9997 1
17: F5VN9N        5101       9997 1
18: KNJQ77        5101       9997 1
19: GU2ZR3        5101         -1 1
20: CMM3ZK        5101         -1 1
21: BTDEWQ        5101       9997 1
22: GNXDS7        5101       9997 1
23: T5QXCQ        5101       9997 1
24: FEWD2W        5101       9997 1
25: 87JX57        5101       9997 1
26: 787G5H        5223       9997 1
27: DQSFSG        5101       9997 1
28: 8JMGTP        5223       9997 1
29: R8ZWEQ        5223         -1 1
30: MU33MP        5221         -1 1
31: WDN28U        5221       9997 1
32: R9RN3U        5101       9997 1
33: 5GQJ9E        5223       9997 1
34: BW6BQF        5221         -1 1
35: TXYRG7        5101       9997 1
36: JGGQVW        5101         -1 1
37: C7C9W9        5101       9997 1
38: 5B7TX9        5221         -1 1
39: Q6K7DG        5221         -1 1
40: 69V6YT        5101       9997 1
41: PXY6TG        5221         -1 1
42: SP27R6        5101       9997 1
43: Y2PV5S        5101       9997 1
44: 2PCVGJ        5101       9997 1
45: 2NDJ3F        5221       9997 1
46: MZ8Q9J        5221       9997 1
47: B35CYP        5101       9997 1
48: U588SU        5223       9997 1
49: N3PXZ7        5101       9997 1
50: UWSWNP        5223       9997 1
51: 28CKYF        5101       9997 1
     ESTID Disposition INDCON_LCV N

RIGID Independent Contractor %

INDCON_RIGID = DK / missing

Disposition	-1	9997
5101	8	32
5221	6	3
5223	3	7

ESTID of errors:

     ESTID Disposition INDCON_RIGID N
 1: NSUYR6        5101         9997 1
 2: BSEQHT        5101           -1 1
 3: 0AUM5M        5101         9997 1
 4: C6JPQO        5101           -1 1
 5: W39M52        5101           -1 1
 6: BV9YNN        5101           -1 1
 7: A07O8K        5101           -1 1
 8: XQQKF6        5101         9997 1
 9: 5TDECP        5101           -1 1
10: QEJMEP        5101         9997 1
11: 8HRBPK        5221           -1 1
12: 8G38BS        5101         9997 1
13: 2VEPT6        5101         9997 1
14: T89Q6X        5101         9997 1
15: T92MMC        5101         9997 1
16: GURZ98        5101         9997 1
17: VCZNXE        5101         9997 1
18: 7Y5NME        5101         9997 1
19: YCY5W7        5101         9997 1
20: NT2VYU        5101         9997 1
21: F5VN9N        5101         9997 1
22: QMKN5Z        5223         9997 1
23: BTDEWQ        5101         9997 1
24: HE32DC        5101         9997 1
25: HPBXS9        5101         9997 1
26: GNXDS7        5101         9997 1
27: 7MMVZ6        5101           -1 1
28: T5QXCQ        5101         9997 1
29: ENFFYY        5101         9997 1
30: FEWD2W        5101         9997 1
31: 87JX57        5101         9997 1
32: D9UPGX        5101         9997 1
33: NRHGPB        5223           -1 1
34: 787G5H        5223         9997 1
35: DQSFSG        5101         9997 1
36: RCKVB8        5223         9997 1
37: WDN28U        5221         9997 1
38: R9RN3U        5101         9997 1
39: DT93FY        5223         9997 1
40: 5GQJ9E        5223         9997 1
41: BW6BQF        5221           -1 1
42: TXYRG7        5101         9997 1
43: SXQW7D        5221           -1 1
44: C7C9W9        5101         9997 1
45: YFEZHP        5101           -1 1
46: RNCS2W        5223           -1 1
47: WMN9DH        5223           -1 1
48: DJFJFY        5221           -1 1
49: PXY6TG        5221           -1 1
50: Y2PV5S        5101         9997 1
51: X3BZZE        5221           -1 1
52: 2PCVGJ        5101         9997 1
53: 2NDJ3F        5221         9997 1
54: MZ8Q9J        5221         9997 1
55: B35CYP        5101         9997 1
56: U588SU        5223         9997 1
57: N3PXZ7        5101         9997 1
58: UWSWNP        5223         9997 1
59: 28CKYF        5101         9997 1
     ESTID Disposition INDCON_RIGID N

Articulated Independent Contractor %

INDCON_ART = DK / missing

Disposition	-1	9997
5101	4	26
5221	3	3
5223	3	5

ESTID of errors:

     ESTID Disposition INDCON_ART N
 1: NSUYR6        5101       9997 1
 2: 6EHWPD        5101       9997 1
 3: XQQKF6        5101       9997 1
 4: 5TDECP        5101         -1 1
 5: RQWUHU        5101       9997 1
 6: QEJMEP        5101       9997 1
 7: 68CE8M        5101         -1 1
 8: 8G38BS        5101       9997 1
 9: 2VEPT6        5101       9997 1
10: T89Q6X        5101       9997 1
11: WPXM3Q        5223         -1 1
12: GURZ98        5101       9997 1
13: 7Y5NME        5101       9997 1
14: YCY5W7        5101       9997 1
15: F5VN9N        5101       9997 1
16: QMKN5Z        5223       9997 1
17: BTDEWQ        5101       9997 1
18: HPBXS9        5101       9997 1
19: GNXDS7        5101       9997 1
20: T5QXCQ        5101       9997 1
21: FEWD2W        5101       9997 1
22: 87JX57        5101       9997 1
23: 787G5H        5223       9997 1
24: 98G9P5        5101         -1 1
25: DQSFSG        5101       9997 1
26: HRBRB9        5101         -1 1
27: MU33MP        5221         -1 1
28: WDN28U        5221       9997 1
29: R9RN3U        5101       9997 1
30: 5GQJ9E        5223       9997 1
31: TXYRG7        5101       9997 1
32: C7C9W9        5101       9997 1
33: YT3N6C        5223         -1 1
34: Y2PV5S        5101       9997 1
35: 9V68MU        5223         -1 1
36: 2PCVGJ        5101       9997 1
37: XJDEQ2        5221         -1 1
38: JH5PXH        5221         -1 1
39: 2NDJ3F        5221       9997 1
40: MZ8Q9J        5221       9997 1
41: B35CYP        5101       9997 1
42: U588SU        5223       9997 1
43: N3PXZ7        5101       9997 1
44: UWSWNP        5223       9997 1
     ESTID Disposition INDCON_ART N

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

LCV

     ESTID OUTSOURCE_LCV INDCON_LCV N
 1: W39M52            -1         -1 1
 2: BV9YNN            -1         -1 1
 3: Q3PKZ8            -1         -1 1
 4: DBQ5ZB            -1         -1 1
 5: GU2ZR3            -1         -1 1
 6: CMM3ZK            -1         -1 1
 7: MU33MP            -1         -1 1
 8: BW6BQF            -1         -1 1
 9: JGGQVW            -1         -1 1
10: 5B7TX9            -1         -1 1
11: Q6K7DG            -1         -1 1

RIGID

     ESTID OUTSOURCE_RIGID INDCON_RIGID N
 1: BSEQHT              -1           -1 1
 2: C6JPQO              -1           -1 1
 3: W39M52              -1           -1 1
 4: BV9YNN              -1           -1 1
 5: A07O8K              -1           -1 1
 6: 5TDECP              -1           -1 1
 7: 8HRBPK              -1           -1 1
 8: 7MMVZ6              -1           -1 1
 9: NRHGPB              -1           -1 1
10: BW6BQF              -1           -1 1
11: SXQW7D              -1           -1 1
12: YFEZHP              -1           -1 1
13: RNCS2W              -1           -1 1
14: WMN9DH              -1           -1 1

ART

     ESTID OUTSOURCE_ART INDCON_ART N
 1: 5TDECP            -1         -1 1
 2: 68CE8M            -1         -1 1
 3: WPXM3Q            -1         -1 1
 4: 98G9P5            -1         -1 1
 5: HRBRB9            -1         -1 1
 6: MU33MP            -1         -1 1
 7: YT3N6C            -1         -1 1
 8: 9V68MU            -1         -1 1
 9: XJDEQ2            -1         -1 1
10: JH5PXH            -1         -1 1

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	1446
5223	1188

ESTID of errors:

[1] "No results"

If Q2=2 then check it adds to -10

Q16 = -10 when Q2=2

Disposition	-10
5101	4352

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	4352	NA	NA	NA	NA	NA
0	30	NA	NA	NA	NA	NA
1	NA	56	48	2328	147	25

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	4352	NA	NA	NA	NA	NA
0	17	NA	NA	NA	NA	NA
1	NA	52	33	2379	131	22

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	4352	NA	NA	NA	NA	NA
0	7	NA	NA	NA	NA	NA
1	NA	54	45	2422	92	14

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	4352	NA	NA	NA	NA	NA
0	8	NA	NA	NA	NA	NA
1	NA	59	40	2395	115	17

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	4352	NA	NA	NA	NA	NA
0	15	NA	NA	NA	NA	NA
1	NA	70	62	2329	137	21

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	4352	NA	NA	NA	NA	NA
0	1802	NA	NA	NA	NA	NA
1	NA	431	83	305	8	5

ESTID of errors: Q2=1

[1] "No results"

Q2=2

[1] "No results"

Sunday

Sunday - Q17

Q10a_7	-2	1	2	3	4
-2	4352	NA	NA	NA	NA
0	2236	NA	NA	NA	NA
1	NA	219	38	138	3

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	4352
1	296	NA
2	1895	NA
3	443	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	4352
0	270	NA
1	1397	NA
2	386	NA
3	193	NA
4	254	NA
5	72	NA
6	40	NA
7	9	NA
97	12	NA
98	1	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	1	2	3	4
5101	4206	134	11	1
5221	1320	110	14	2
5223	1117	60	8	3

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

ANZSIC_1

ANZSIC_1 codes

ANZIC_1	N
112	2
122	1
123	1
139	1
193	1
419	1
529	7
700	4
801	4
804	4
805	2
809	1
911	1
919	2
1012	10
1090	57
1111	6
1112	1
1113	5
1120	1
1131	1
1133	1
1140	2
1150	1
1161	1
1162	1
1171	6
1172	6
1174	32
1182	4
1192	3
1199	41
1211	3
1212	2
1213	1
1214	8
1312	1
1313	1
1320	1
1331	4
1333	11
1334	3
1351	15
1352	1
1491	3
1492	39
1494	3
1499	13
1510	4
1521	4
1523	1
1529	1
1611	27
1612	7
1701	1
1709	1
1812	3
1821	8
1829	4
1831	5
1841	2
1851	1
1852	2
1899	5
1911	2
1912	8
1913	4
1914	1
1915	1
1916	6
1919	9
1920	1
2010	10
2029	4
2031	1
2032	3
2033	4
2034	10
2090	10
2110	16
2121	1
2122	9
2132	6
2139	5
2141	2
2142	2
2149	3
2210	5
2221	69
2222	7
2223	24
2224	1
2229	27
2231	2
2239	2
2240	15
2291	2
2292	2
2293	17
2299	35
2311	4
2312	29
2313	1
2319	12
2391	5
2392	14
2393	8
2394	4
2399	4
2411	3
2412	9
2419	3
2422	3
2429	7
2431	2
2432	5
2439	10
2449	1
2451	11
2452	13
2461	2
2462	17
2463	19
2469	9
2491	10
2499	17
2511	20
2512	2
2513	3
2519	10
2591	4
2592	6
2599	17
2619	3
2620	1
2630	2
2640	1
2700	3
2811	4
2812	1
2911	13
2919	7
2921	9
2922	20
3011	18
3019	31
3020	28
3101	18
3109	38
3211	4
3212	5
3221	15
3222	2
3223	4
3224	1
3231	33
3232	71
3233	19
3234	19
3239	18
3241	7
3242	21
3243	11
3244	12
3245	10
3291	20
3292	5
3299	35
3311	1
3312	1
3319	19
3321	5
3322	19
3323	3
3331	4
3332	14
3339	60
3411	11
3419	41
3491	7
3492	1
3493	4
3494	53
3499	25
3501	8
3502	5
3503	3
3504	32
3505	14
3601	7
3602	3
3603	5
3604	3
3605	3
3606	10
3609	32
3711	9
3712	11
3720	15
3731	10
3732	2
3733	4
3734	6
3736	10
3739	26
3800	5
3911	36
3912	5
3913	7
3921	58
3922	33
4000	53
4110	65
4121	25
4122	10
4123	34
4129	26
4211	55
4212	32
4213	13
4214	5
4221	29
4222	9
4229	15
4231	72
4232	15
4241	42
4242	4
4243	10
4244	32
4245	13
4251	118
4252	10
4253	22
4259	16
4260	11
4271	60
4272	5
4273	30
4274	13
4279	131
4310	12
4320	1
4400	27
4511	292
4512	208
4513	12
4520	37
4530	13
4610	132
4622	5
4623	6
4710	3
4810	4
4900	22
5010	2
5029	4
5101	25
5102	17
5212	2
5219	3
5220	16
5291	2
5292	38
5299	9
5301	1
5309	122
5411	1
5412	1
5420	8
5511	3
5513	3
5522	2
5621	1
5801	5
5802	2
5809	8
5910	1
5921	4
5922	4
6010	6
6020	1
6221	19
6230	4
6240	14
6310	1
6322	10
6411	12
6419	29
6420	1
6611	34
6619	13
6631	24
6639	34
6711	1
6712	12
6720	59
6910	4
6921	22
6922	8
6923	75
6924	38
6925	31
6931	53
6932	87
6940	17
6950	1
6961	36
6962	23
6970	18
6991	13
6999	5
7000	43
7211	41
7212	5
7220	13
7291	58
7294	2
7299	16
7311	19
7312	3
7313	6
7320	9
7510	5
7520	18
7530	12
7540	3
7552	1
7600	2
7711	4
7712	9
7713	12
7714	2
7719	11
7720	5
8010	9
8021	55
8022	15
8023	11
8024	5
8101	47
8102	2
8211	40
8212	20
8219	18
8220	6
8401	4
8511	49
8512	60
8520	21
8531	54
8532	20
8533	34
8534	15
8539	102
8591	1
8599	6
8601	23
8609	4
8710	34
8790	33
8910	4
8922	3
9001	6
9002	8
9003	1
9111	86
9112	16
9113	22
9114	1
9131	7
9139	10
9202	6
9209	3
9411	12
9412	127
9419	268
9421	10
9422	23
9429	89
9491	11
9499	12
9511	226
9520	9
9531	16
9533	8
9534	7
9539	23
9540	53
9551	8
9552	1
9559	40

ESTID with Errors:

[1] "No results"

[1] "No results"

ANZSIC_2

ANZSIC_2 codes

ANZIC_2	N
-2	6643
804	1
806	2
919	1
1090	1
1111	1
1182	1
1211	2
1213	1
1611	1
1620	1
1709	1
1913	1
2033	1
2110	1
2121	1
2221	3
2229	2
2293	2
2299	3
2312	2
2392	1
2421	1
2449	1
2452	1
2462	2
2591	1
2599	1
2922	1
3011	1
3101	2
3109	1
3212	1
3221	2
3223	1
3232	1
3234	2
3239	2
3242	1
3291	1
3299	1
3311	1
3319	1
3321	1
3322	2
3339	2
3411	1
3419	1
3492	1
3494	2
3502	1
3503	1
3504	2
3601	1
3606	1
3609	1
3734	1
3739	1
3911	1
3913	1
3921	5
4110	3
4121	1
4123	3
4129	1
4211	1
4221	1
4222	1
4229	1
4231	1
4232	2
4244	2
4251	3
4259	1
4272	1
4273	1
4274	2
4279	10
4310	2
4400	5
4511	19
4512	6
4513	6
4520	7
4530	3
4610	8
4623	1
5029	1
5101	2
5102	3
5220	1
5291	1
5292	2
5299	2
5309	12
5802	1
6010	1
6020	1
6230	1
6611	1
6619	4
6639	1
6711	1
6712	1
6720	1
6923	2
6924	2
6931	2
6940	2
6961	11
6962	1
6970	3
7220	1
7291	15
7311	1
7320	1
7713	1
7720	1
8021	1
8022	1
8101	6
8211	2
8212	1
8219	5
8220	2
8511	1
8512	3
8520	2
8533	2
8539	3
8710	4
8790	3
9003	2
9111	3
9129	1
9209	2
9411	3
9412	3
9419	18
9421	1
9429	11
9499	1
9511	2
9531	2
9539	2
9540	1
9559	1

ESTID with Errors:

[1] "No results"

[1] "No results"

ANZSIC_3

ANZSIC_3 codes

ANZIC_3	N
-2	6947
1199	1
2511	1
2922	1
3231	1
3245	2
3339	1
3419	1
3499	1
3502	2
3504	1
4123	1
4221	1
4232	1
4279	1
4511	3
4512	1
4530	1
5220	1
5299	1
6923	2
6961	2
7212	1
7291	3
7311	1
7712	1
8022	1
8520	1
8790	1
9003	1
9429	2

ESTID with Errors:

[1] "No results"

[1] "No results"

ANZSIC_4

ANZSIC_4 codes

ANZIC_4	N
-2	6980
2221	1
4310	1
6619	1
8710	1
9201	1
9419	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

[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: CNDFQJ           0 1
  2: XQQKF6           0 1
  3: HTXX5J           0 1
  4: 7CXPWF           0 1
  5: 9PNKQZ           0 1
 ---                     
131: SYED5R           0 1
132: PYCFY9           0 1
133: 8SNHJD           0 1
134: REP059           0 1
135: M2KYB2           0 1

Check if Employees for activity 2 is greater than 0 (where activity 2 exists)

     ESTID TOTAL_EMP_2 N
 1: P97SBK           0 1
 2: CCPGE5           0 1
 3: NQUPYT           0 1
 4: T6XHGX           0 1
 5: H7J7MB           0 1
 6: RQWUHU           0 1
 7: X93JGU           0 1
 8: D5Z9XQ           0 1
 9: Z3UHET           0 1
10: 5GQPVH           0 1
11: BNJ7JM           0 1
12: YPVE2G           0 1
13: FK6FY5           0 1
14: MNR375           0 1
15: H58FTQ           0 1
16: GE2W6J           0 1
17: DNNJCK           0 1
18: Q8HEGW           0 1
19: BPHTVR           0 1
20: 873G5N        1600 1
21: WRJUXY           0 1
22: TFGDG9           0 1
23: WRS957           0 1
24: 7UQ2FE           0 1
25: P3PFJV           0 1
26: 7HMPPZ           0 1
27: 3BBBV2           0 1
28: 8VTN2K           0 1
29: DWFUG7           0 1
     ESTID TOTAL_EMP_2 N

Check if Employees for activity 3 is greater than 0 (where activity 3 exists)

    ESTID TOTAL_EMP_3 N
1: MS3ECR           0 1
2: ZB2HEF           0 1
3: 78BVCH           0 1

Check if Employees for activity 4 is greater than 0 (where activity 4 exists)

    ESTID TOTAL_EMP_4 N
1: 873G5N        2300 1

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

    ESTID P2_10C_1
1: REP058       -1

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

    ESTID P2_10C_2
1: REP058       -1

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

    ESTID P2_10C_3
1: REP058       -1

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

    ESTID P2_10C_1 P2_10C_2 P2_10C_3
1: REP058       -1       -1       -1

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)

   P2_10A_1 P2_10A_2 P2_10A_3 P2_10A_4    N
1:       -2       -2       -2       -2 4352

   P2_10B_1 P2_10B_2 P2_10B_3 P2_10B_4    N
1:       -2       -2       -2       -2 4352

   P2_10C_1 P2_10C_2 P2_10C_3 P2_10C_4    N
1:       -2       -2       -2       -2 4352

P2.10 Charlotte Check

For ANZIC (Incorrect spelling) 2 check that if -2 then P2_10 is -2 aswell

[1] "No results"

For ANZIC (Incorrect spelling) 3 check that if -2 then P2_10 is -2 aswell

[1] "No results"

For ANZIC (Incorrect spelling) 4 check that if -2 then P2_10 is -2 aswell

[1] "No results"

P2.7

Check that P2.7 and the dispositions are correct

P2.7 check table

Q2	P2_7	5101	5221	5223
1	1	NA	1445	NA
1	2	NA	NA	2
1	98	NA	1	1186
2	-2	4352	NA	NA

Final Survey Status

Check that Final status makes sense

Final Status

FinalStatus	Disposition	N
5	5101	4350
0	5101	2
1	5221	1443
0	5221	3
1	5223	1185
0	5223	3

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	21

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	18
97	1
98	2

Q2_3_B

Q2_3_B

Q2_1	-2
2	18
97	1
98	2

Q2_3_C

Q2_3_C

Q2_1	-2
2	18
97	1
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	2	1
2	15	NA	NA
97	1	NA	NA
98	2	NA	NA

Q2_4_B

Q2_4_B

Q2_2	-2	0
1	NA	3
2	15	NA
97	1	NA
98	2	NA

Q2_4_C

Q2_4_C

Q2_2	-2	0
1	NA	3
2	15	NA
97	1	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
3: MCPBKK      1      0      0

Manages Vehicles on Site

Manage_LCV

Manage_LCV

Disposition	0	1	2	4	5	8	9997
4211	4	8	2	2	2	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	0	1	2	9997
4211	14	4	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	0	9997
4211	19	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	9997
4211	7

ESTID of errors:

    ESTID Disposition ARRIVALS_LCV N
1: 9RQ5DW        4211         9997 1
2: 5X2RK7        4211         9997 1
3: R5X3V8        4211         9997 1
4: F958DQ        4211         9997 1
5: GY6HGM        4211         9997 1
6: W7XQUG        4211         9997 1
7: D682V5        4211         9997 1

RIGID Arrivals

ARRIVALS_RIGID = DK, missing, NA

Disposition	9997
4211	7

ESTID of errors:

    ESTID Disposition ARRIVALS_RIGID N
1: 9RQ5DW        4211           9997 1
2: 5X2RK7        4211           9997 1
3: R5X3V8        4211           9997 1
4: F958DQ        4211           9997 1
5: GY6HGM        4211           9997 1
6: W7XQUG        4211           9997 1
7: D682V5        4211           9997 1

LCV Articulated

ARRIVALS_ART = DK, missing, NA

Disposition	9997
4211	6

ESTID of errors:

    ESTID Disposition ARRIVALS_ART N
1: 9RQ5DW        4211         9997 1
2: 5X2RK7        4211         9997 1
3: R5X3V8        4211         9997 1
4: GY6HGM        4211         9997 1
5: W7XQUG        4211         9997 1
6: D682V5        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 %

OUTSOURCE_LCV = DK / missing

Disposition	9997
4211	7

ESTID of errors:

    ESTID Disposition OUTSOURCE_LCV N
1: 9RQ5DW        4211          9997 1
2: 5X2RK7        4211          9997 1
3: R5X3V8        4211          9997 1
4: F958DQ        4211          9997 1
5: GY6HGM        4211          9997 1
6: W7XQUG        4211          9997 1
7: D682V5        4211          9997 1

RIGID Outsourcing %

OUTSOURCE_RIGID = DK / missing

Disposition	9997
4211	7

ESTID of errors:

    ESTID Disposition OUTSOURCE_RIGID N
1: 9RQ5DW        4211            9997 1
2: 5X2RK7        4211            9997 1
3: R5X3V8        4211            9997 1
4: F958DQ        4211            9997 1
5: GY6HGM        4211            9997 1
6: W7XQUG        4211            9997 1
7: D682V5        4211            9997 1

Articulated Outsourcing %

OUTSOURCE_ART = DK / missing

Disposition	9997
4211	6

ESTID of errors:

    ESTID Disposition OUTSOURCE_ART N
1: 9RQ5DW        4211          9997 1
2: 5X2RK7        4211          9997 1
3: R5X3V8        4211          9997 1
4: GY6HGM        4211          9997 1
5: W7XQUG        4211          9997 1
6: D682V5        4211          9997 1

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	19	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
1090	1
1214	1
2121	1
2122	1
2229	1
2312	1
2392	1
3011	1
3239	1
3245	1
3291	1
3332	1
3494	1
4229	1
6923	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	19
3101	1
4511	1

ESTID with Errors:

[1] "No results"

[1] "No results"

ANZSIC_3

ANZSIC_3 codes

ANZIC_3	N
-2	21

ESTID with Errors:

[1] "No results"

[1] "No results"

ANZSIC_4

ANZSIC_4 codes

ANZIC_4	N
-2	21

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	21

Final Survey Status

Check that Final status makes sense

Final Status

FinalStatus	Disposition	N
4	4211	21

Simple Logics

Checking ESTID of GF… (this is before we add to the “Master”)

Empty data.table (0 rows and 2 cols): ESTID,count

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: 3HPTXR      2     12     -1              5
 2: 3U9TV2     -1     -2     -2              5
 3: 8FK529      5     -1     -2              5
 4: 8K5UE2     -1     -1     -1              5
 5: BK7HZV     -1     -2     -2              5
 6: CQ3DWZ     -2     -1     -2              5
 7: DCTENH     -2     -1     -2              5
 8: DDQEFY     -1     -2     -2              5
 9: DZDUK6     -1     -1     -2              5
10: ERR7YK     -2     -1     -2              5
11: FKUMYU     -1     -1      1              5
12: JEVXGQ     -1     -2     -2              5
13: PS2HGY     -1     -1     -2              5
14: PTTVRM     -1     -2     -2              5
15: QCFN5O     10     -1     -2              5
16: REP038     -1     -2     15              5
17: URZGPD     -1      4     -2              5
18: VJ57VF      1     -1     -2              5
19: RUXP5Y     50     -1     -2              5
20: YSTE3C     -1     -2     -2              5
21: TRBRVJ     -1     20      7              5
22: 5EU8CH     45     -1     -2              5
23: VFDN5T     -1     -2     -2              5
24: YZT9UB      3     -1     -2              5
25: KR6EUD      8     10     -1              5
26: JF6RFC      1     -1     -1              5
27: WM3X5P     -1     -1     -2              5
28: C7FF8D     -1     -2     -2              5
29: S3YQJM      3      4     -1              5
30: Q6QBVS     -1     -2     -2              5
31: R2Q7SC     -2     -1     -2              5
32: 5GQJ9E     -1     -2     -2              5
33: DZ3WN6     12     10     -1              5
34: 8EP8PZ     -1     -1     -2              5
35: 5B7TX9      6     -1     -2              5
36: R72EEG     -1    125     -2              5
37: 8KCP3R      2     -1      1              5
38: UQGPKG     -1     -2     -2              5
39: WREHGD     -1     -1     -2              5
40: HUC69W     -1     -2     -2              5
41: 8EU8SZ     22     -2     -1              5
42: 39C5UK     -1     -1     -1              5
43: 85WYZQ     -2     -1     -2              5
44: F7RYQQ     -2     -1     -2              5
45: 5D6U2Q      1     -1     -2              5
46: Q7CU2M      2     -1     -2              5
47: M93GVF      3      1     -1              5
48: UHF6PF     -1     -2     -2              5
49: F3EV5X     -1     -2     -2              5
50: U5UUZ9     -1     -1     -1              5
51: YBW55V     -1     -1     -1              5
52: 7Y388T     -1     -1     -2              5
53: EP2PEG     -1     -2     -2              5
54: XKWM7B     -1     -2     -2              5
55: 9BHNSU      2     -2     -1              5
56: H833ZJ     -1     -2     -2              5
57: ZJGKZJ      1     -1      3              5
58: UEN6BT     -2     -1     -2              5
59: 3Y7TZ7     -1     -2     -1              5
60: 9PPGK6     -1     -2     -2              5
61: XMWU77      4     -1     -2              5
62: JRB58E     -1      6     -2              5
63: VGVBCQ     -1      1     -2              5
64: U9WNXR      6     -1     -2              5
65: MM2R2H     -1     -2     -2              5
66: VFP9QD     -1      3     -2              5
67: K6CJBT     30     -1     -2              5
68: C3M255     10     -1     -1              5
69: NUHVS3     -1     -1     -2              5
70: TUTHD6      2     -1     -2              5
71: BJYK7T      2     -1     -2              5
72: EHVDMW      2     -1     -2              5
73: KQUH77      4     -1     -2              5
74: 7YP7YS     -2     -1     -1              5
75: BJYNXK     -1     -1     -2              5
76: THUJFQ      6     -1     -2              5
77: F88J8W      3     -1     -2              5
78: 2QXVBR      2     -1      4              5
79: JC7SHU      1     -1     -2              5
80: FQ5HXE     11     -2     -1              5
81: YED29Y     -2     -1     -2              5
82: X9TT69     -1     -2     -2              5
83: QYFFQ6     -1     -2     -2              5
84: VR5QYM     -2     -1     -2              5
85: VTYYK7     24     -1     -2              5
86: 372U95     -1      1     -2              5
     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
3U9TV2	-1	-2	-2	5
562TXT	-2	-1	-2	5
5EDEGY	-2	-1	-2	5
8K5UE2	-1	-1	-1	5
95BFEF	-1	-2	-2	5
9C7BF8	-2	-1	-2	5
BPYXN9	-1	-1	-2	5
CQ3DWZ	-2	-1	-2	5
DCTENH	-2	-1	-2	5
DFD6GX	-1	-2	-2	5
DZDUK6	-1	-1	-2	5
ERR7YK	-2	-1	-2	5
JEVXGQ	-1	-2	-2	5
NSN7S9	360000	-1	-2	5
URZGPD	-1	40000	-2	5
VGKYVX	-1	-1	-2	5
VJ57VF	100000	-1	-2	5
ZK8167	-1	-1	-2	5
JXWQFP	-1	-1	-2	5
2NDJ3F	-2	1200000	-1	5
K2S5V9	-1	-2	-2	5
RUKGEN	-1	-2	-2	5
QNVWHC	-1	-1	-1	5
8J6YCB	-2	-1	-2	5
YSTE3C	-1	-2	-2	5
NKVMB7	-1	-2	-2	5
NKVMB7	-1	-2	-2	5
ZB7ZPQ	-1	-2	-2	5
H8VBBF	-1	-2	-2	5
U8J5G3	-1	-2	-2	5
WM3X5P	-1	-1	-2	5
5EKY37	-1	-2	-2	5
X7HR5W	-1	-2	-2	5
5GM2TU	50000	50000	-1	5
F6GN79	-1	-2	-2	5
JPBV97	-1	-2	-2	5
JPBV97	-1	-2	-2	5
VP367U	-1	-2	-2	5
S3YQJM	-1	-1	-1	5
YUTP3G	-1	-1	-2	5
9T8ND3	-1	-1	-2	5
E8VYM3	-1	-2	-2	5
P32CTC	-1	-2	-2	5
Q6QBVS	-1	-2	-2	5
R2Q7SC	-2	-1	-2	5
5GQJ9E	-1	-2	-2	5
5VKREN	-1	-1	-2	5
ZN5HT7	-1	-2	-2	5
2TFEGG	-1	-1	-2	5
K9MSX3	-2	-1	-2	5
DZ3WN6	-1	-1	-1	5
HGSPCJ	-1	-2	-2	5
8EP8PZ	-1	-1	-2	5
EYG7JT	-1	-1	-2	5
EYG7JT	-1	-1	-2	5
R72EEG	-1	400000	-2	5
5J7FNB	-1	-1	-2	5
BQVB3U	-1	-1	-1	5
WREHGD	-1	-1	-2	5
GCUBVW	-1	-2	-2	5
HUC69W	-1	-2	-2	5
8EU8SZ	100000	-2	-1	5
39C5UK	-1	-1	-1	5
QBE2RX	-1	-2	90000	5
85WYZQ	-2	-1	-2	5
F7RYQQ	-2	-1	-2	5
M93GVF	110000	60000	-1	5
YBW55V	-1	-1	-1	5
7Y388T	-1	-1	-2	5
QD5ZH2	-1	-1	-2	5
XKWM7B	-1	-2	-2	5
RYCKCN	-1	-1	-1	5
EYGHKG	-1	-1	-2	5
9BHNSU	120000	-2	-1	5
H833ZJ	-1	-2	-2	5
FZMGZJ	-1	-2	-2	5
PRFKF6	-1	-1	-2	5
FEEVZZ	-1	-1	-1	5
C6S26R	-1	12000	-2	5
3Y7TZ7	-1	-2	-1	5
BMJT9V	-1	-1	-1	5
VGVBCQ	-1	3600	-2	5
U9WNXR	120000	-1	-2	5
C3M255	-1	-1	-1	5
TUTHD6	10000	-1	-2	5
BJYK7T	10000	-1	-2	5
KQUH77	15000	-1	-2	5
7YP7YS	-2	-1	-1	5
27DNMZ	-1	-2	-2	5
8RCZPM	-2	-1	-2	5
F88J8W	100000	-1	-2	5
ZRPHVG	-1	-1	-2	5
X9TT69	-1	-2	-2	5
VR5QYM	-2	-1	-2	5
YPDVS8	-1	10000	-2	5
Q5RRZD	-1	-2	-2	5
372U95	-1	-1	-2	5
DT7296	-1	35000	-2	5

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

Q11

Ok, now to check Q11…

Q12 Departures

Q12 checking the departures, all aboard! Monday (12A)

Q12(Monday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_1	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1

Tuesday (12A)

Q12(Tuesday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_2	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1

Wednesday (12A)

Q12(Wednesday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_3	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1

Thursday (12A)

Q12(Thursday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_4	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1

Friday (12A)

Q12(Friday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_5	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1

Saturday (12A)

Q12(Saturday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_6	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1

Sunday (12A)

Q12(Sunday) Departures have a -1 response

ESTID	Stratum_Master	GF_Q12A_7	GF_Q9
2CTPSQ	5	-1	1
2VJJJT	5	-1	1
2YQYVD	5	-1	1
3HPTXR	5	-1	1
5WZ5CP	5	-1	1
6YV8SV	5	-1	1
DDQEFY	5	-1	1
GZ7CK8	5	-1	1
J7TC3D	5	-1	1
JH5PXH	5	-1	1
KGE65C	5	-1	1
NSN7S9	5	-1	1
PJ22SS	5	-1	1
QGYXE6	5	-1	1
RB6ZFQ	5	-1	1
RDUDHW	5	-1	1
REP063	5	-1	1
SPYCC2	5	-1	1
SX3KW7	5	-1	1
SXVMVC	5	-1	1
TF7G2R	5	-1	1
UC8QU5	5	-1	1
VJ62S8	5	-1	1
ZRQM77	5	-1	1
DJXUP2	5	-1	1
7WFM7N	5	-1	1
2NDJ3F	5	-1	1
GH29Y9	5	-1	1
PBHYEC	5	-1	1
K2S5V9	5	-1	1
3G6QJC	5	-1	1
CKWVX9	5	-1	1
GESKV5	5	-1	1
HCK2ZV	5	-1	1
RJF5YM	5	-1	1
MMX7VS	5	-1	1
ZBGFKD	5	-1	1
5KVU9Q	5	-1	1
6RNU2Z	5	-1	1
TRBRVJ	5	-1	1
8T55D5	5	-1	1
SSSGQS	5	-1	1
M69V8C	5	-1	1
MGJDVM	5	-1	1
KR6EUD	5	-1	1
JF6RFC	5	-1	1
EMBZQV	5	-1	1
Y5BG6C	5	-1	1
WPTC2N	5	-1	1
8SEV8Z	5	-1	1
RTUTKS	5	-1	1
92T9RQ	5	-1	1
VBVD6T	5	-1	1
FD6VXK	5	-1	1
52H2VB	5	-1	1
7Y952R	5	-1	1
VP367U	5	-1	1
YW357W	5	-1	1
NTSK86	5	-1	1
Y82FHR	5	-1	1
TPUTGM	5	-1	1
VV7U3N	5	-1	1
5SWFXJ	5	-1	1
6WP3GF	5	-1	1
9SUD9G	5	-1	1
YJJZY3	5	-1	1
RGHK7H	5	-1	1
U39RZ7	5	-1	1
39C5UK	5	-1	1
FBWHMN	5	-1	1
D8KNE6	5	-1	1
33ES5B	5	-1	1
QYT3XB	5	-1	1
P2K6G7	5	-1	1
8BJG5G	5	-1	1
ZN8G8G	5	-1	1
U5UUZ9	5	-1	1
YBW55V	5	-1	1
RSD6XH	5	-1	1
MJGR5E	5	-1	1
BZJDPG	5	-1	1
VPSMGG	5	-1	1
QFYFD3	5	-1	1
D5MPG3	5	-1	1
BJNQF5	5	-1	1
K6CJBT	5	-1	1
SSZ5TB	5	-1	1
Y5859C	5	-1	1
J37V5B	5	-1	1
NWJDGF	5	-1	1
EXFJM7	5	-1	1
6JEKST	5	-1	1
GPHV9V	5	-1	1
2M55JR	5	-1	1
D2QT8C	5	-1	1
NYT2TF	5	-1	1
JPMKXN	5	-1	1
HRFGUX	5	-1	1
K7EP6K	5	-1	1