Spreadsheet: 882814d1731298691-powerpivot-and-formula-powerpivot-and-formula-mytran-
Sheet: Pivot Table

 | PO Number | Site Number | Manifest ID | Sum of Correct Weight | Sum of Corrected Billing Invoice Net Value | Sum of Corrected Billing Minimum Fee | Sum of Corrected Billing Houston Franchise Fee | Sum of Corrected Billing Total_Amount | Sum of Net Weight | Average Unit Rate
 | 3001628555 | 3000885042 | HS0000233367 | 3398.15 | 1111.2 | 0 | 44.45 | 1155.65 | 3398.15 | 0.327
 |  |  | HS0000233372 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0000233378 | 92916 | 30383.29999999997 | 0 | 1215.100000000001 | 31598.39999999997 | 3204 | 0.3270000000000005
 |  |  | HS0000233381 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0000312803 | 6796.3 | 1413.63 | 0 | 56.55 | 1470.18 | 6796.3 | 0.208
 |  |  | HS0000313368 | 3398.15 | 1111.2 | 0 | 44.45 | 1155.65 | 3398.15 | 0.327
 |  |  | HS0000359103 | 6796.3 | 1413.63 | 0 | 56.55 | 1470.18 | 6796.3 | 0.208
 |  |  | HS0000479837 | 927300 | 303228.2 | 0 | 12128.6 | 315356.8 | 4215 | 0.327
 |  |  | HS0000498422 | 3398.15 | 1111.2 | 0 | 44.45 | 1155.65 | 3398.15 | 0.327
 |  |  | HS0000659323 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0000752927 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0000752928 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0000752929 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0000752930 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0001171207 | 6796.3 | 2222.39 | 0 | 88.9 | 2311.29 | 6796.3 | 0.327
 |  |  | HS0001171208 | 3398.15 | 1111.2 | 0 | 44.45 | 1155.65 | 3398.15 | 0.327
 |  | 3000885043 | HS0000058834 | 112 | 36.62 | 57.28 | 3.76 | 97.66 | 112 | 0.327
 |  |  | HS0000059371 | 1808 | 376.08 | 0 | 15.04 | 391.1199999999999 | 226 | 0.208
 |  |  | HS0000084873 | 412.5 | 85.80000000000001 | 55.05 | 5.64 | 146.49 | 137.5 | 0.208
 |  |  | HS0000110470 | 2112 | 439.2799999999999 | 0 | 17.6 | 456.8800000000001 | 264 | 0.208
 |  |  | HS0000110760 | 3540 | 1157.6 | 0 | 46.3 | 1203.9 | 354 | 0.327
 |  |  | HS0000110785 | 1377 | 286.44 | 0 | 11.46 | 297.9 | 229.5 | 0.208
 |  |  | HS0000148574 | 375 | 78 | 62.84999999999999 | 5.64 | 146.49 | 125 | 0.208
 |  |  | HS0000149393 | 867.5 | 180.45 | 54.3 | 9.399999999999999 | 244.15 | 173.5 | 0.208
 |  |  | HS0000185627 | 7095 | 1475.7 | 0 | 59.09999999999999 | 1534.799999999999 | 473 | 0.2080000000000001
 |  |  | HS0000186159 | 356 | 74.04 | 113.76 | 7.52 | 195.32 | 89 | 0.208
 |  |  | HS0000186235 | 1224 | 254.58 | 27.12 | 11.28 | 292.98 | 204 | 0.208
 |  |  | HS0000244714 | 867.5 | 180.45 | 54.3 | 9.399999999999999 | 244.15 | 173.5 | 0.208
 |  |  | HS0000245359 | 153 | 31.83 | 109.02 | 5.64 | 146.49 | 51 | 0.208
 |  |  | HS0000284067 | 1788 | 371.92 | 3.68 | 15.04 | 390.6399999999999 | 223.5 | 0.208
 |  |  | HS0000284887 | 5655 | 1176.3 | 0 | 47.1 | 1223.4 | 377.0000000000001 | 0.2080000000000001
 |  |  | HS0000285289 | 512 | 106.48 | 81.32 | 7.52 | 195.32 | 128 | 0.208
 |  |  | HS0000331538 | 1215 | 252.72 | 28.98 | 11.28 | 292.98 | 202.5 | 0.208
 |  |  | HS0000331566 | 538 | 111.92 | 75.88 | 7.52 | 195.32 | 134.5 | 0.208
 |  | 3000885047 | HS0000219918 | 143243.0999999999 | 46840.5 | 0 | 1873.62 | 48714.11999999999 | 4547.4 | 0.3269999999999998
 |  |  | HS0000219935 | 3150 | 1030.08 | 0 | 41.16 | 1071.24 | 262.5 | 0.327
 |  |  | HS0000220240 | 62754.29999999993 | 20520.71000000002 | 0 | 820.750000000001 | 21341.46 | 3842.100000000001 | 0.3269999999999998
 |  |  | HS0000220246 | 154447.2 | 50504.28000000001 | 0 | 2020.080000000001 | 52524.36 | 4064.4 | 0.3269999999999999
 |  |  | HS0000220251 | 95580 | 31254.59999999999 | 0 | 1250.4 | 32505 | 3186 | 0.3269999999999998
 |  |  | HS0000220259 | 80274 | 26249.69999999995 | 0 | 1050.090000000001 | 27299.78999999995 | 3148 | 0.3270000000000005
 |  |  | HS0000262580 | 94412.5 | 30362.14999999998 | 0 | 1214.849999999997 | 31576.99999999992 | 4357.5 | 0.3215076923076916
 |  |  | HS0000309729 | 84682.70000000006 | 27603.14999999991 | 0 | 1103.889999999995 | 28707.04000000004 | 4305.900000000001 | 0.3249830508474569
 |  |  | HS0000310155 | 84000 | 18206.99999999997 | 0 | 728.3999999999996 | 18935.39999999996 | 4153.5 | 0.2179166666666659
 |  |  | HS0000356750 | 109305 | 33883.29000000011 | 0 | 1355.129999999998 | 35238.42 | 3470 | 0.3099999999999999
 |  |  | HS0000461353 | 97560 | 31902.00000000003 | 0 | 1276.199999999999 | 33178.20000000003 | 1626 | 0.3270000000000003
 |  | 3000885048 | HS0000074952 | 135 | 28.08 | 112.77 | 5.64 | 146.49 | 45 | 0.208
 |  |  | HS0000161255 | 186.8 | 38.84 | 148.96 | 7.52 | 195.32 | 46.7 | 0.208
 |  |  | HS0000258506 | 576 | 119.82 | 161.88 | 11.28 | 292.98 | 96 | 0.208
 |  |  | HS0000351215 | 20 | 4.16 | 89.74 | 3.76 | 97.66 | 10 | 0.208
 |  | 3000885049 | HS0000148593 | 29 | 6.03 | 40.92 | 1.88 | 48.83 | 29 | 0.208
 |  |  | HS0000331556 | 30.5 | 9.97 | 36.98 | 1.88 | 48.83 | 61 | 0.327
 |  | 3000885050 | HS0000074938 | 346 | 71.96 | 115.84 | 7.52 | 195.32 | 86.5 | 0.208
 |  |  | HS0000129179 | 270 | 56.16 | 84.69 | 5.64 | 146.49 | 90 | 0.208
 |  |  | HS0000214415 | 73 | 15.18 | 78.72 | 3.76 | 97.66 | 36.5 | 0.208
 |  |  | HS0000305664 | 150 | 31.2 | 62.7 | 3.76 | 97.66 | 75 | 0.208
 |  | 3000885051 | HS0000078068 | 98904 | 32341.43999999998 | 0 | 1293.600000000001 | 33635.03999999999 | 2060.5 | 0.327
 |  |  | HS0000078107 | 9360 | 3060.8 | 0 | 122.4 | 3183.199999999999 | 468 | 0.327
 |  |  | HS0000094020 | 89408 | 29236.23999999997 | 0 | 1169.52 | 30405.76000000003 | 2032 | 0.327
 |  |  | HS0000131521 | 81572.70000000001 | 26674.28999999994 | 1688.339999999998 | 1134.300000000002 | 29496.93000000002 | 4293.299999999999 | 0.3269999999999993
 |  |  | HS0000131992 | 19544 | 6391 | 0 | 255.6399999999999 | 6646.640000000002 | 698 | 0.327
 |  |  | HS0000132494 | 6992 | 2286.400000000001 | 0 | 91.52 | 2377.919999999999 | 437 | 0.327
 |  |  | HS0000163299 | 20146 | 6587.839999999999 | 0 | 263.48 | 6851.319999999996 | 719.5 | 0.327
 |  |  | HS0000163952 | 41600 | 13603.2 | 0 | 544.0000000000003 | 14147.20000000001 | 1040 | 0.327
 |  |  | HS0000218684 | 40700 | 13308.79999999999 | 0 | 532.4 | 13841.20000000001 | 1017.5 | 0.327
 |  |  | HS0000219365 | 43108 | 14096.16 | 0 | 563.6799999999996 | 14659.84 | 829 | 0.3270000000000001
 |  |  | HS0000219940 | 18720 | 6121.439999999997 | 0 | 244.9199999999998 | 6366.359999999999 | 720 | 0.327
 |  |  | HS0000260936 | 18004 | 5887.280000000003 | 0 | 235.4799999999999 | 6122.760000000001 | 643 | 0.327
 |  |  | HS0000261477 | 6344 | 2074.56 | 0 | 83.03999999999999 | 2157.599999999999 | 396.5 | 0.327
 |  |  | HS0000309477 | 10150 | 3318.999999999999 | 0 | 132.8 | 3451.800000000001 | 507.5 | 0.327
 |  |  | HS0000311282 | 107657.5999999999 | 35204.27999999996 | 0 | 1408.280000000001 | 36612.55999999994 | 1583.2 | 0.3270000000000001
 |  |  | HS0000311888 | 33934 | 11096.38000000001 | 0 | 443.8400000000002 | 11540.22 | 893 | 0.327
 |  |  | HS0000355539 | 25544 | 8352.949999999997 | 0 | 334.1799999999998 | 8687.129999999994 | 824 | 0.327
 |  |  | HS0000355608 | 46116 | 15080.09999999999 | 1367.519999999999 | 657.7199999999985 | 17105.34000000002 | 2196 | 0.3270000000000007
 |  | 3000885053 | HS0000076138 | 1997.6 | 653.24 | 0 | 0 | 653.24 | 734.5999999999999 | 0.327
 |  |  | HS0000130463 | 895.5 | 292.83 | 0 | 0 | 292.83 | 597 | 0.327
 |  |  | HS0000216463 | 856.5 | 280.08 | 0 | 0 | 280.08 | 856.5 | 0.327
 |  |  | HS0000307631 | 2186 | 714.8000000000001 | 0 | 0 | 714.8000000000001 | 437.2 | 0.327
 |  | 3000885054 | HS0000059033 | 38192 | 12488.64000000001 | 0 | 499.5200000000003 | 12988.15999999999 | 1193.5 | 0.327
 |  |  | HS0000085118 | 5922 | 1936.44 | 0 | 77.40000000000002 | 2013.839999999999 | 493.5 | 0.327
 |  |  | HS0000110907 | 27648 | 9040.959999999997 | 0 | 361.6000000000002 | 9402.56 | 864 | 0.327
 |  |  | HS0000149458 | 6912 | 2260.16 | 0 | 90.40000000000002 | 2350.56 | 432 | 0.327
 |  |  | HS0000187795 | 33264 | 10877.39999999999 | 0 | 435.2399999999997 | 11312.63999999999 | 924 | 0.327
 |  |  | HS0000245940 | 20930 | 6844.040000000003 | 0 | 273.84 | 7117.88 | 747.5 | 0.327
 |  |  | HS0000284999 | 41881.5 | 13695.23000000001 | 0 | 547.7600000000003 | 14242.98999999999 | 1021.5 | 0.327
 |  |  | HS0000332917 | 15252 | 4987.440000000001 | 0 | 199.44 | 5186.879999999998 | 635.5 | 0.327
 |  | 3000885055 | HS0000077628 | 6075 | 1986.600000000001 | 0 | 79.49999999999999 | 2066.1 | 405 | 0.327
 |  |  | HS0000131811 | 2465.1 | 806.1299999999999 | 0 | 32.21999999999999 | 838.3499999999999 | 273.9 | 0.327
 |  |  | HS0000163338 | 1421 | 464.66 | 0 | 18.62 | 483.2800000000001 | 203 | 0.327
 |  |  | HS0000219088 | 1074 | 351.1799999999999 | 0 | 14.04 | 365.22 | 179 | 0.327
 |  |  | HS0000261183 | 1697.5 | 555.1 | 0 | 22.19 | 577.2900000000001 | 242.5 | 0.327
 |  |  | HS0000308673 | 795 | 259.98 | 21.72 | 11.22 | 292.92 | 265 | 0.327
 |  |  | HS0000354715 | 9099 | 2975.400000000001 | 709.7399999999998 | 147.4200000000002 | 3832.560000000004 | 1516.5 | 0.3270000000000002
 |  | 3000885056 | HS0000214940 | 993 | 324.72 | 0 | 12.96 | 337.6799999999999 | 165.5 | 0.327
 |  | 3000885057 | HS0000078045 | 76524 | 25023.59999999998 | 0 | 1000.72 | 26024.32000000001 | 1366.5 | 0.327
 |  |  | HS0000131827 | 55137.59999999995 | 18029.76000000001 | 0 | 720.9599999999996 | 18750.71999999999 | 1148.7 | 0.327
 |  |  | HS0000132434 | 25008 | 8177.600000000004 | 0 | 327.0400000000002 | 8504.640000000007 | 781.5 | 0.327
 |  |  | HS0000163370 | 46486 | 15201.11999999999 | 0 | 608.0800000000002 | 15809.19999999999 | 1056.5 | 0.327
 |  |  | HS0000219098 | 22384 | 7319.679999999995 | 0 | 292.8 | 7612.480000000003 | 699.5 | 0.327
 |  |  | HS0000219674 | 63112 | 20637.68 | 0 | 825.4400000000004 | 21463.12000000002 | 1127 | 0.327
 |  |  | HS0000261214 | 44304 | 14487.35999999999 | 0 | 579.36 | 15066.71999999999 | 923 | 0.327
 |  |  | HS0000308676 | 12466 | 4076.29 | 0 | 163.0700000000001 | 4239.360000000001 | 542 | 0.327
 |  |  | HS0000308701 | 24416 | 7984 | 0 | 319.36 | 8303.359999999993 | 763 | 0.327
 |  |  | HS0000354726 | 5005 | 1636.6 | 419.2999999999999 | 82.32000000000004 | 2138.220000000001 | 715 | 0.327
 |  | 3000885058 | HS0000078055 | 1221.5 | 399.42 | 0 | 15.96 | 415.3800000000001 | 174.5 | 0.327
 |  |  | HS0000132952 | 1962 | 641.61 | 0 | 25.65000000000001 | 667.26 | 218 | 0.327
 |  |  | HS0000163392 | 1536 | 502.2399999999999 | 0 | 20.08 | 522.32 | 192 | 0.327
 |  |  | HS0000219680 | 2700 | 882.9600000000002 | 0 | 35.28 | 918.2399999999999 | 225 | 0.327
 |  |  | HS0000261235 | 1424 | 465.6799999999999 | 0 | 18.64 | 484.3200000000001 | 178 | 0.327
 |  |  | HS0000308706 | 10018.7 | 3276.169999999999 | 0 | 131.1000000000001 | 3407.269999999999 | 527.3 | 0.327
 |  | 3000885059 | HS0000078076 | 28816.80000000001 | 9422.880000000001 | 0 | 376.8000000000003 | 9799.679999999997 | 2401.4 | 0.327
 |  |  | HS0000078109 | 13764 | 4500.720000000001 | 0 | 180 | 4680.720000000001 | 573.5 | 0.327
 |  |  | HS0000094028 | 30940 | 10117.38 | 0 | 404.6000000000005 | 10521.98 | 1820 | 0.3270000000000003
 |  |  | HS0000131531 | 40150.8 | 13129.20000000001 | 0 | 525.2399999999996 | 13654.44000000001 | 1115.3 | 0.327
 |  |  | HS0000132014 | 8422.5 | 2754.149999999999 | 0 | 110.2500000000001 | 2864.399999999998 | 1123 | 0.327
 |  |  | HS0000132510 | 1291.5 | 422.3099999999999 | 0 | 16.87 | 439.18 | 184.5 | 0.327
 |  |  | HS0000163315 | 78598 | 25701.51999999997 | 0 | 1028.04 | 26729.55999999998 | 1511.5 | 0.3270000000000001
 |  |  | HS0000163958 | 60301 | 19718.37999999999 | 0 | 789.1299999999997 | 20507.51000000005 | 2566 | 0.3270000000000001
 |  |  | HS0000218718 | 99000 | 32372.99999999997 | 0 | 1294.8 | 33667.80000000002 | 1650 | 0.3270000000000003
 |  |  | HS0000219380 | 6783 | 2218.059999999999 | 0 | 88.73000000000002 | 2306.79 | 357 | 0.327
 |  |  | HS0000219969 | 6167 | 2016.56 | 0 | 80.64 | 2097.2 | 440.5 | 0.327
 |  |  | HS0000261446 | 72228 | 23618.40000000002 | 0 | 944.8399999999993 | 24563.23999999999 | 1389 | 0.327
 |  |  | HS0000261484 | 24087 | 7876.479999999999 | 0 | 314.9600000000001 | 8191.439999999995 | 777 | 0.327
 |  |  | HS0000310056 | 147193.2000000002 | 48132.7000000001 | 0 | 1925 | 50057.70000000002 | 3823.199999999999 | 0.3269999999999996
 |  |  | HS0000311299 | 24822 | 8116.5 | 0 | 324.6599999999995 | 8441.159999999994 | 1182 | 0.3270000000000007
 |  |  | HS0000311913 | 21825 | 7136.700000000003 | 0 | 285.6 | 7422.299999999997 | 727.5 | 0.327
 |  |  | HS0000355558 | 14553 | 4758.820000000001 | 0 | 190.3000000000001 | 4949.12 | 661.5 | 0.327
 |  |  | HS0000356260 | 17316 | 5662.28 | 940.1599999999994 | 264.1599999999999 | 6866.599999999989 | 1998 | 0.3270000000000006
 |  | 3000885060 | HS0000059671 | 53 | 17.34 | 75.58 | 3.72 | 96.63999999999999 | 53 | 0.327
 |  |  | HS0000149123 | 56 | 18.32 | 75.58 | 3.76 | 97.66 | 56 | 0.327
 |  |  | HS0000245308 | 52 | 17 | 76.9 | 3.76 | 97.66 | 52 | 0.327
 |  |  | HS0000332186 | 13.5 | 4.41 | 42.54 | 1.88 | 48.83 | 27 | 0.327
 |  | 3000885062 | HS0000074955 | 745 | 243.6 | 0 | 9.75 | 253.35 | 149 | 0.327
 |  |  | HS0000128717 | 1764 | 576.8000000000001 | 0 | 23.04 | 599.84 | 220.5 | 0.327
 |  |  | HS0000161266 | 3168 | 1035.96 | 0 | 41.40000000000001 | 1077.36 | 264 | 0.327
 |  |  | HS0000214356 | 3222 | 1053.6 | 0 | 42.11999999999998 | 1095.72 | 268.5 | 0.327
 |  |  | HS0000305121 | 897 | 293.34 | 0 | 11.76 | 305.1 | 149.5 | 0.327
 |  |  | HS0000351233 | 990 | 323.76 | 0 | 12.96 | 336.72 | 165 | 0.327
 |  | 3000885063 | HS0000074957 | 235.5 | 77.01 | 63.84 | 5.64 | 146.49 | 78.5 | 0.327
 |  |  | HS0000128730 | 9557 | 3125.12 | 0 | 125.02 | 3250.139999999999 | 503 | 0.327
 |  |  | HS0000161286 | 1664 | 544.16 | 0 | 21.76 | 565.92 | 208 | 0.327
 |  |  | HS0000214376 | 277.5 | 90.75 | 50.09999999999999 | 5.64 | 146.49 | 92.5 | 0.327
 |  |  | HS0000258530 | 2925 | 956.4999999999999 | 0 | 38.29999999999999 | 994.8000000000001 | 292.5 | 0.327
 |  |  | HS0000305125 | 1528.8 | 499.92 | 0 | 20 | 519.92 | 191.1 | 0.327
 |  |  | HS0000351960 | 412 | 134.72 | 53.08 | 7.52 | 195.32 | 103 | 0.327
 |  | 3000892472 | NS0000149261 | 12060 | 3943.679999999999 | 0 | 157.8 | 4101.48 | 1005 | 0.327
 |  |  | NS0000245303 | 36230.39999999998 | 11847.36000000001 | 0 | 473.7600000000001 | 12321.12000000001 | 3019.2 | 0.327
 |  |  | NS0000332379 | 4155 | 1358.7 | 0 | 54.3 | 1413 | 415.5 | 0.327
 |  | 3000894262 | HS0000188016 |  |  |  |  |  | 135 | 0.208
 |  |  | HS0000245334 |  |  |  |  |  | 60.34 | 0.208
 |  |  | HS0000284718 |  |  |  |  |  | 135 | 0.208
 |  |  | HS0000332394 | 0 | 0 | 0 | 0 | 0 | 219.1 | 0.208
 |  | 3000894263 | HS0000132973 |  |  |  |  |  | 357.1 | 0.208
 |  |  | HS0000163791 |  |  |  |  |  | 175.26 | 0.208
 |  |  | HS0000219107 |  |  |  |  |  | 154.1 | 0.208
 |  |  | HS0000219716 | 0 | 0 | 0 | 0 | 0 | 249.1 | 0.208
 |  |  | HS0000261687 |  |  |  |  |  | 73 | 0.208
 |  |  | HS0000308685 |  |  |  |  |  | 88.104 | 0.208
 |  |  | HS0000309340 | 0 | 0 | 0 | 0 | 0 | 73.2 | 0.208
 |  |  | HS0000355287 | 242.1 | 165.4 | 0 | 6.62 | 172.02 | 242.1 | 0.208
 |  | 3000897305 | HS0000187943 | 1216 | 397.6 | 0 | 15.92 | 413.52 | 152 | 0.327
 | Grand Total |  |  | 4251792.600000011 | 1373737.800000007 | 7241.140000000007 | 55160.33000000007 | 1436139.270000008 | 208100.9040000001 | 0.31831330749354