Spreadsheet: 808678d1670585839-top-ten-percentile-s666-pq_amjad-sample-period_end_p11_2022-test
Sheet: Expected Answer

Lane_State | SERVICE_CD | CORP_WK_NUM | CORP_PD_NUM | TOTAL_TOTAL |  | Lane_State | SERVICE_CD | CORP_WK_NUM | CORP_PD_NUM | [NAME]
CA--->ON | NOF_CAD | 41 | 11 | 20257.7 |  | AZ--->AB | NOF_USD | 41 | 11 | 6560.19
CA--->ON | NOF_USD | 41 | 11 | 16770.2 |  | AZ--->AB | NOF_USD | 42 | 11 | 11191.16
CA--->ON | NOF_USD | 41 | 11 | 16770.2 |  | AZ--->AB | NOF_USD | 43 | 11 | 6866.35
CA--->ON | NOF_USD | 41 | 11 | 16070.2 |  | AZ--->BC | NOF_USD | 41 | 11 | 5598.06
CA--->ON | NOF_USD | 41 | 11 | 15320.2 |  | AZ--->BC | NOF_USD | 42 | 11 | 5703.35
CA--->ON | NOF_CAD | 41 | 11 | 14981.05 |  | AZ--->BC | NOF_USD | 43 | 11 | 5735.62
CA--->ON | NOF_CAD | 41 | 11 | 10248.48 |  | AZ--->ON | NOF_CAD | 43 | 11 | 10391.12
CA--->ON | NOF_CAD | 41 | 11 | 10003.85 |  | AZ--->ON | NOF_USD | 41 | 11 | 7112.97
CA--->ON | NOF_CAD | 41 | 11 | 10003.85 |  | AZ--->ON | NOF_USD | 42 | 11 | 8461.99
CA--->ON | NOF_USD | 42 | 11 | 17073.06 |  | AZ--->ON | NOF_USD | 43 | 11 | 8518.18
CA--->ON | NOF_USD | 42 | 11 | 16073.06 |  | AZ--->ON | NOF_USD | 44 | 11 | 0
CA--->ON | NOF_USD | 42 | 11 | 15673.06 |  | AZ--->QC | NOF_USD | 42 | 11 | 8601.71
CA--->ON | NOF_USD | 42 | 11 | 15623.06 |  | AZ--->QC | NOF_USD | 43 | 11 | 9487.5
CA--->ON | NOF_CAD | 42 | 11 | 10315.03 |  | AZ--->SK | NOF_USD | 41 | 11 | 6760.83
CA--->ON | NOF_CAD | 42 | 11 | 10190.03 |  | AZ--->SK | NOF_USD | 42 | 11 | 5000
CA--->ON | NOF_CAD | 42 | 11 | 10190.03 |  | AZ--->SK | NOF_USD | 43 | 11 | 7406.63
CA--->ON | NOF_CAD | 42 | 11 | 10190.03 |  | CA--->AB | NOF_CAD | 41 | 11 | 12986.06
CA--->ON | NOF_USD | 43 | 11 | 17115.88 |  | CA--->AB | NOF_CAD | 42 | 11 | 10036.33
CA--->ON | NOF_USD | 43 | 11 | 17115.88 |  | CA--->AB | NOF_CAD | 43 | 11 | 11157.61
CA--->ON | NOF_USD | 43 | 11 | 17115.88 |  | CA--->AB | NOF_USD | 41 | 11 | 6547.43
CA--->ON | NOF_CAD | 43 | 11 | 10535.93 |  | CA--->AB | NOF_USD | 42 | 11 | 6639.41
CA--->ON | NOF_CAD | 43 | 11 | 10535.93 |  | CA--->AB | NOF_USD | 43 | 11 | 11761.2
CA--->ON | NOF_CAD | 43 | 11 | 10535.93 |  | CA--->AB | NOF_USD | 44 | 11 | 3483.27
CA--->ON | NOF_CAD | 43 | 11 | 10535.93 |  | CA--->AB | SPOT | 41 | 11 | 3483.27
CA--->ON | NOF_CAD | 43 | 11 | 10535.93 |  | CA--->AB | TT | 41 | 11 | 4767.29
CA--->ON | NOF_CAD | 43 | 11 | 10485.93 |  | CA--->AB | TT | 42 | 11 | 5189.22
CA--->ON | NOF_CAD | 43 | 11 | 10485.93 |  | CA--->AB | TT | 43 | 11 | 5189.22
CA--->ON | LTLW | 44 | 11 | 1095.21 |  | CA--->AB | TT | 44 | 11 | 5241.42
 |  |  |  |  |  | CA--->BC | NOF_USD | 41 | 11 | 8497.16
 |  |  |  |  |  | CA--->BC | NOF_USD | 42 | 11 | 9925.06
 |  |  |  |  |  | CA--->BC | NOF_USD | 43 | 11 | 10085.55
 |  |  |  |  |  | CA--->BC | NOF_USD | 44 | 11 | 0
 |  |  |  |  |  | CA--->NB | NOF_USD | 41 | 11 | 11334.86
 |  |  |  |  |  | CA--->NB | NOF_USD | 42 | 11 | 11334.86
 |  |  |  |  |  | CA--->NB | NOF_USD | 43 | 11 | 22746.8
 |  |  |  |  |  | CA--->ON | LTLW | 41 | 11 | 1635.34
 |  |  |  |  |  | CA--->ON | LTLW | 42 | 11 | 2063.63
 |  |  |  |  |  | CA--->ON | LTLW | 43 | 11 | 1401.85
 |  |  |  |  |  | CA--->ON | LTLW | 44 | 11 | 1401.85
 |  |  |  |  |  | CA--->ON | NOF_CAD | 41 | 11 | 20257.7
 |  |  |  |  |  | CA--->ON | NOF_CAD | 42 | 11 | 10315.03
 |  |  |  |  |  | CA--->ON | NOF_CAD | 43 | 11 | 10535.93
 |  |  |  |  |  | CA--->ON | NOF_USD | 41 | 11 | 16770.2
 |  |  |  |  |  | CA--->ON | NOF_USD | 42 | 11 | 17073.06
 |  |  |  |  |  | CA--->ON | NOF_USD | 43 | 11 | 17115.88
 |  |  |  |  |  | CA--->ON | NOF_USD | 44 | 11 | 0
 |  |  |  |  |  | CA--->QC | NOF_CAD | 41 | 11 | 9953.85
 |  |  |  |  |  | CA--->QC | NOF_CAD | 42 | 11 | 10140.03
 |  |  |  |  |  | CA--->QC | NOF_USD | 41 | 11 | 19007.06
 |  |  |  |  |  | CA--->QC | NOF_USD | 42 | 11 | 19007.06
 |  |  |  |  |  | CA--->QC | NOF_USD | 43 | 11 | 9606.46
 |  |  |  |  |  | CA--->SK | NOF_CAD | 41 | 11 | 13171.51
 |  |  |  |  |  | CA--->SK | NOF_CAD | 42 | 11 | 8031.35
 |  |  |  |  |  | CA--->SK | NOF_CAD | 43 | 11 | 13795.78
 |  |  |  |  |  | CA--->SK | NOF_USD | 41 | 11 | 6494.81
 |  |  |  |  |  | CA--->SK | NOF_USD | 42 | 11 | 14373.78
 |  |  |  |  |  | CA--->SK | NOF_USD | 43 | 11 | 13006.36
 |  |  |  |  |  | CO--->ON | LTLW | 41 | 11 | 0
 |  |  |  |  |  | CO--->ON | SPOT | 43 | 11 | 1370.06
 |  |  |  |  |  | CT--->ON | LTLW | 44 | 11 | 434.94
 |  |  |  |  |  | DE--->ON | NOF_CAD | 41 | 11 | 5149.8
 |  |  |  |  |  | DE--->ON | NOF_CAD | 42 | 11 | 5224.04
 |  |  |  |  |  | DE--->ON | NOF_CAD | 43 | 11 | 2680.99
 |  |  |  |  |  | DE--->ON | NOF_CAD | 44 | 11 | 0
 |  |  |  |  |  | DE--->QC | NOF_CAD | 42 | 11 | 2050.9
 |  |  |  |  |  | DE--->QC | NOF_CAD | 43 | 11 | 2050.9
 |  |  |  |  |  | DE--->QC | NOF_CAD | 44 | 11 | 2050.9
 |  |  |  |  |  | FL--->ON | NOF_USD | 41 | 11 | 2750
 |  |  |  |  |  | FL--->ON | NOF_USD | 42 | 11 | 2825
 |  |  |  |  |  | FL--->ON | NOF_USD | 43 | 11 | 0
 |  |  |  |  |  | FL--->ON | TT | 41 | 11 | 3752.33
 |  |  |  |  |  | FL--->ON | TT | 42 | 11 | 3861.34
 |  |  |  |  |  | FL--->ON | TT | 44 | 11 | 4411.58
 |  |  |  |  |  | FL--->QC | NOF_USD | 43 | 11 | 0
 |  |  |  |  |  | GA--->ON | NOF_USD | 41 | 11 | 2700
 |  |  |  |  |  | GA--->ON | NOF_USD | 42 | 11 | 2525
 |  |  |  |  |  | GA--->ON | NOF_USD | 43 | 11 | 2200
 |  |  |  |  |  | IA--->AB | IMDD | 41 | 11 | 6687.73
 |  |  |  |  |  | IA--->AB | IMDD | 43 | 11 | 6687.73
 |  |  |  |  |  | IA--->IL | LTLW | 43 | 11 | 6687.73
 |  |  |  |  |  | IA--->IL | TT | 43 | 11 | 6687.73
 |  |  |  |  |  | IA--->IL | TT | 44 | 11 | 6687.73
 |  |  |  |  |  | IA--->ON | TT | 41 | 11 | 4141.03
 |  |  |  |  |  | IA--->ON | TT | 42 | 11 | 4345.71
 |  |  |  |  |  | IA--->ON | TT | 43 | 11 | 4345.71
 |  |  |  |  |  | IA--->ON | TT | 44 | 11 | 4345.71
 |  |  |  |  |  | IL--->AB | IMDD | 41 | 11 | 4350.56
 |  |  |  |  |  | IL--->AB | IMDD | 42 | 11 | 4321.69
 |  |  |  |  |  | IL--->AB | IMDD | 43 | 11 | 4378.43
 |  |  |  |  |  | IL--->AB | IMDD | 44 | 11 | 6374.02
 |  |  |  |  |  | IL--->AB | TT | 41 | 11 | 6374.02
 |  |  |  |  |  | IL--->AB | TT | 42 | 11 | 6374.02
 |  |  |  |  |  | IL--->AB | TT | 43 | 11 | 6374.02
 |  |  |  |  |  | IL--->AB | TTF | 43 | 11 | 6374.02
 |  |  |  |  |  | IL--->BC | IMDD | 41 | 11 | 6374.02
 |  |  |  |  |  | IL--->BC | TTF | 43 | 11 | 6374.02
 |  |  |  |  |  | IL--->IL | LTLW | 43 | 11 | 6374.02
 |  |  |  |  |  | IL--->IL | TT | 43 | 11 | 528.17
 |  |  |  |  |  | IL--->MB | TTF | 41 | 11 | 2300
 |  |  |  |  |  | IL--->MB | TTF | 43 | 11 | 3555.1
 |  |  |  |  |  | IL--->ON | LTLW | 41 | 11 | 3555.1 | ... | ... | ... | ... | ... | ...
 |  |  |  |  |  | IL--->ON | LTLW | 42 | 11 | 3555.1
 |  |  |  |  |  | IL--->ON | LTLW | 43 | 11 | 3555.1
 |  |  |  |  |  | IL--->ON | LTLW | 44 | 11 | 1104.02
 |  |  |  |  |  | IL--->ON | TT | 41 | 11 | 2393.11
 |  |  |  |  |  | IL--->ON | TT | 42 | 11 | 2393.11
 |  |  |  |  |  | IL--->ON | TT | 43 | 11 | 2607.42
 |  |  |  |  |  | IL--->ON | TT | 44 | 11 | 2607.42
 |  |  |  |  |  | IN--->AB | TT | 44 | 11 | 9632.56
 |  |  |  |  |  | IN--->IL | LTLW | 41 | 11 | 559.62
 |  |  |  |  |  | IN--->IL | LTLW | 44 | 11 | 1597.41
 |  |  |  |  |  | IN--->ON | LTLW | 42 | 11 | 1597.41
 |  |  |  |  |  | IN--->ON | LTLW | 44 | 11 | 1626.68
 |  |  |  |  |  | IN--->ON | NOF_CAD | 43 | 11 | 2611.86
 |  |  |  |  |  | IN--->ON | TT | 41 | 11 | 2611.86
 |  |  |  |  |  | IN--->ON | TT | 43 | 11 | 2611.86
 |  |  |  |  |  | IN--->ON | TT | 44 | 11 | 2132.75
 |  |  |  |  |  | LA--->AB | TT | 44 | 11 | 8516.58
 |  |  |  |  |  | LA--->IL | SPOT_US | 41 | 11 | 8516.58
 |  |  |  |  |  | LA--->ON | TT | 42 | 11 | 8516.58
 |  |  |  |  |  | LA--->ON | TT | 44 | 11 | 8516.58
 |  |  |  |  |  | MA--->IL | LTLW | 41 | 11 | 8516.58
 |  |  |  |  |  | MA--->IL | LTLW | 43 | 11 | 8516.58
 |  |  |  |  |  | MA--->ON | LTLW | 43 | 11 | 8516.58
 |  |  |  |  |  | NC--->IL | LTLW | 43 | 11 | 8516.58
 |  |  |  |  |  | NC--->IL | LTLW | 44 | 11 | 8516.58
 |  |  |  |  |  | NC--->ON | NOF_USD | 42 | 11 | 8516.58
 |  |  |  |  |  | NC--->ON | NOF_USD | 43 | 11 | 8516.58
 |  |  |  |  |  | NC--->ON | TT | 42 | 11 | 8516.58
 |  |  |  |  |  | NC--->ON | TT | 43 | 11 | 8516.58
 |  |  |  |  |  | NC--->ON | TT | 44 | 11 | 8516.58
 |  |  |  |  |  | NJ--->NB | NOF_CAD | 41 | 11 | 3404.23
 |  |  |  |  |  | NJ--->NB | NOF_CAD | 42 | 11 | 3464.47
 |  |  |  |  |  | NJ--->NB | NOF_CAD | 43 | 11 | 3576.4
 |  |  |  |  |  | NJ--->NB | NOF_CAD | 44 | 11 | 3359.12
 |  |  |  |  |  | [NAME] | NOF_CAD | 41 | 11 | 10020.11
 |  |  |  |  |  | [NAME] | NOF_CAD | 42 | 11 | 10020.11
 |  |  |  |  |  | [NAME] | NOF_CAD | 43 | 11 | 10020.11
 |  |  |  |  |  | NJ--->ON | NOF_CAD | 41 | 11 | 2258.44
 |  |  |  |  |  | NJ--->ON | NOF_CAD | 42 | 11 | 2258.44
 |  |  |  |  |  | NJ--->ON | NOF_CAD | 43 | 11 | 4551.08
 |  |  |  |  |  | NJ--->ON | NOF_CAD | 44 | 11 | 2345.16
 |  |  |  |  |  | NJ--->QC | NOF_CAD | 41 | 11 | 3908.92
 |  |  |  |  |  | NJ--->QC | NOF_CAD | 42 | 11 | 5964.6
 |  |  |  |  |  | NJ--->QC | NOF_CAD | 43 | 11 | 5964.6
 |  |  |  |  |  | NJ--->QC | NOF_CAD | 44 | 11 | 2069.23
 |  |  |  |  |  | NV--->ON | LTLW | 41 | 11 | 1958.3
 |  |  |  |  |  | NV--->ON | LTLW | 42 | 11 | 652.41
 |  |  |  |  |  | NV--->ON | LTLW | 43 | 11 | 3543.28
 |  |  |  |  |  | NV--->ON | LTLW | 44 | 11 | 1860.7
 |  |  |  |  |  | NV--->ON | NOF_USD | 41 | 11 | 8485.1
 |  |  |  |  |  | NV--->ON | NOF_USD | 42 | 11 | 8485.1
 |  |  |  |  |  | NV--->ON | NOF_USD | 43 | 11 | 8557.94
 |  |  |  |  |  | NY--->NS | TT | 41 | 11 | 3331.51
 |  |  |  |  |  | NY--->NS | TT | 43 | 11 | 3845.4
 |  |  |  |  |  | NY--->NS | TT | 44 | 11 | 3845.4
 |  |  |  |  |  | NY--->ON | LTLW | 43 | 11 | 3845.4
 |  |  |  |  |  | NY--->ON | LTLW | 44 | 11 | 3845.4
 |  |  |  |  |  | NY--->ON | TT | 41 | 11 | 864.96
 |  |  |  |  |  | NY--->ON | TT | 42 | 11 | 954.55
 |  |  |  |  |  | NY--->ON | TT | 43 | 11 | 1103.03
 |  |  |  |  |  | NY--->ON | TT | 44 | 11 | 1135.99
 |  |  |  |  |  | OH--->AB | NOF_CAD | 43 | 11 | 288.51
 |  |  |  |  |  | OH--->IL | LTLW | 42 | 11 | 288.51
 |  |  |  |  |  | OH--->IL | LTLW | 43 | 11 | 195.72
 |  |  |  |  |  | OH--->IL | LTLW | 44 | 11 | 1159.84
 |  |  |  |  |  | OH--->NB | NOF_CAD | 41 | 11 | 1159.84
 |  |  |  |  |  | OH--->ON | LTLW | 42 | 11 | 1159.84
 |  |  |  |  |  | OH--->ON | LTLW | 43 | 11 | 1159.84
 |  |  |  |  |  | OH--->ON | NOF_CAD | 41 | 11 | 4238.1
 |  |  |  |  |  | OH--->ON | NOF_CAD | 42 | 11 | 4238.1
 |  |  |  |  |  | OH--->ON | NOF_CAD | 43 | 11 | 2212.67
 |  |  |  |  |  | OH--->ON | NOF_CAD | 44 | 11 | 2212.67
 |  |  |  |  |  | OH--->ON | TT | 41 | 11 | 1987.65
 |  |  |  |  |  | OH--->ON | TT | 44 | 11 | 1987.65
 |  |  |  |  |  | OR--->AB | TT | 41 | 11 | 2879.08
 |  |  |  |  |  | OR--->AB | TT | 42 | 11 | 4393.69
 |  |  |  |  |  | OR--->AB | TT | 43 | 11 | 4393.69
 |  |  |  |  |  | OR--->AB | TT | 44 | 11 | 3133.57
 |  |  |  |  |  | OR--->ON | LTLW | 41 | 11 | 1733.15
 |  |  |  |  |  | OR--->ON | LTLW | 43 | 11 | 1580.09
 |  |  |  |  |  | OR--->ON | SPOT | 44 | 11 | 1580.09
 |  |  |  |  |  | OR--->ON | TT | 41 | 11 | 6558.84
 |  |  |  |  |  | OR--->ON | TT | 42 | 11 | 6748.62
 |  |  |  |  |  | PA--->ON | LTLW | 41 | 11 | 532.37
 |  |  |  |  |  | PA--->ON | LTLW | 42 | 11 | 532.37
 |  |  |  |  |  | PA--->ON | LTLW | 43 | 11 | 532.37
 |  |  |  |  |  | PA--->ON | LTLW | 44 | 11 | 532.37
 |  |  |  |  |  | PA--->ON | NOF_CAD | 41 | 11 | 4344.64
 |  |  |  |  |  | PA--->ON | NOF_CAD | 42 | 11 | 4396.88
 |  |  |  |  |  | PA--->ON | NOF_CAD | 43 | 11 | 2525.54
 |  |  |  |  |  | PA--->ON | NOF_CAD | 44 | 11 | 2345.16
 |  |  |  |  |  | PA--->ON | SPOT | 43 | 11 | 1849
 |  |  |  |  |  | PA--->ON | TT | 41 | 11 | 1436.06
 |  |  |  |  |  | PA--->ON | TT | 42 | 11 | 1468.98
 |  |  |  |  |  | PA--->ON | TT | 43 | 11 | 2030.04
 |  |  |  |  |  | PA--->ON | TT | 44 | 11 | 1649.4
 |  |  |  |  |  | PA--->QC | NOF_CAD | 41 | 11 | 2150.9
 |  |  |  |  |  | PA--->QC | NOF_CAD | 42 | 11 | 2150.9
 |  |  |  |  |  | PA--->QC | NOF_CAD | 43 | 11 | 2150.9
 |  |  |  |  |  | TX--->AB | NOF_USD | 41 | 11 | 10800
 |  |  |  |  |  | TX--->AB | NOF_USD | 42 | 11 | 6135.07
 |  |  |  |  |  | TX--->AB | NOF_USD | 43 | 11 | 6420.45
 |  |  |  |  |  | TX--->BC | NOF_USD | 42 | 11 | 6545
 |  |  |  |  |  | TX--->IL | SPOT_US | 42 | 11 | 6545
 |  |  |  |  |  | TX--->ON | LTLW | 42 | 11 | 6545
 |  |  |  |  |  | TX--->ON | LTLW | 44 | 11 | 6545
 |  |  |  |  |  | TX--->ON | NOF_USD | 41 | 11 | 5585.73
 |  |  |  |  |  | TX--->ON | NOF_USD | 42 | 11 | 5585.73
 |  |  |  |  |  | TX--->ON | NOF_USD | 43 | 11 | 5679.49
 |  |  |  |  |  | TX--->ON | SPOT | 43 | 11 | 6401.96
 |  |  |  |  |  | TX--->QC | NOF_USD | 41 | 11 | 6401.96
 |  |  |  |  |  | TX--->QC | NOF_USD | 42 | 11 | 6401.96
 |  |  |  |  |  | TX--->QC | NOF_USD | 43 | 11 | 6424.94
 |  |  |  |  |  | TX--->SK | NOF_USD | 41 | 11 | 12771.12
 |  |  |  |  |  | TX--->SK | NOF_USD | 42 | 11 | 6496.58
 |  |  |  |  |  | TX--->SK | NOF_USD | 43 | 11 | 6530.61
 |  |  |  |  |  | WA--->AB | NOF_USD | 41 | 11 | 3100.66
 |  |  |  |  |  | WA--->AB | NOF_USD | 42 | 11 | 3640.68
 |  |  |  |  |  | WA--->AB | NOF_USD | 43 | 11 | 3651.73
 |  |  |  |  |  | WA--->AB | NOF_USD | 44 | 11 | 0
 |  |  |  |  |  | WA--->BC | NOF_USD | 41 | 11 | 1658.84
 |  |  |  |  |  | WA--->BC | NOF_USD | 42 | 11 | 1658.84
 |  |  |  |  |  | WA--->BC | NOF_USD | 43 | 11 | 1663.83
 |  |  |  |  |  | WA--->ON | NOF_USD | 41 | 11 | 6770.29
 |  |  |  |  |  | WA--->ON | NOF_USD | 42 | 11 | 13779.44
 |  |  |  |  |  | WA--->ON | NOF_USD | 43 | 11 | 13867.96
 |  |  |  |  |  | WA--->SK | NOF_USD | 41 | 11 | 3541.77
 |  |  |  |  |  | WA--->SK | NOF_USD | 43 | 11 | 2950
 |  |  |  |  |  | WI--->IL | ? | 44 | 11 | 426.45
 |  |  |  |  |  | WI--->IL | LTLW | 42 | 11 | 426.45
 |  |  |  |  |  | WI--->IL | LTLW | 44 | 11 | 426.45
 |  |  |  |  |  | WI--->IL | TT | 41 | 11 | 426.45
 |  |  |  |  |  | WI--->IL | TT | 42 | 11 | 426.45
 |  |  |  |  |  | WI--->IL | TT | 43 | 11 | 774.23
 |  |  |  |  |  | WI--->IL | TT | 44 | 11 | 1937.96
 |  |  |  |  |  | WI--->ON | ? | 44 | 11 | 1937.96
 |  |  |  |  |  | WI--->ON | LTLW | 41 | 11 | 1937.96
 |  |  |  |  |  | WI--->ON | LTLW | 42 | 11 | 1330.92
 |  |  |  |  |  | WI--->ON | LTLW | 44 | 11 | 1330.92
 |  |  |  |  |  | WI--->ON | SPOT | 42 | 11 | 1962.7
 |  |  |  |  |  | WI--->ON | TT | 41 | 11 | 3982.56
 |  |  |  |  |  | WI--->ON | TT | 42 | 11 | 4043.38
 |  |  |  |  |  | WI--->ON | TT | 43 | 11 | 4156.38
 |  |  |  |  |  | WI--->ON | TT | 44 | 11 | 4189.42