Spreadsheet: 65623d1266336666-index-and-match-formulas-sample
Sheet: Weight Compare

 | Weight
 | 060987 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 68 | 136 | 206 | 274 | 342 | 512 | 684 | 1026 | 1368 | 1710 | 2052 | 2394 | 2736 | 3078 | 3418 | 4102 | 4786 | 5470 | 6154 | 6838 | 8548 | 10256 | 11966 | 13676 | 15386 | 17094
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 540 | 605 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 1.063157894736842 | 1.747368421052632 | 1.368627450980392 | 1.713725490196078 |  | 1.714705882352941 |  | 1.747619047619048 |  | 2.276190476190476 |  |  | 2.031404958677686 |  | 1.083333333333333
 | 060955 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 38 | 76 | 116 | 154 | 192 | 288 | 384 | 576 | 768 | 960 | 1152 | 1344 | 1563 | 1728 | 1920 | 2304 | 2686 | 3070 | 3454 | 3838 | 4798 | 5758 | 6718 | 7678 | 8636 | 9596
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 190 | 190 | 255 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 540 | 605 | 1200 | 1200 | 1200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 2.266666666666667 | 3.35 | 2.178947368421053 | 2.642105263157895 |  | 3.857894736842105 |  | 3.525490196078431 |  | 3.047058823529412 |  |  | 3.366666666666667 |  | 3.62962962962963
 | 060900 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 76 | 152 | 228 | 304 | 382 | 572 | 762 | 1144 | 1524 | 1906 | 2286 | 2668 | 3048 | 3430 | 3810 | 4572 | 5334 | 6096 | 6858 | 7620 | 9526 | 11430 | 13336 | 15240 | 17146 | 19052
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 540 | 1200 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 1.063157894736842 | 1.747368421052632 | 1.368627450980392 | 1.713725490196078 |  | 1.714705882352941 |  | 1.747619047619048 |  | 1.927659574468085 |  |  | 0.5283333333333333 |  | 0.1363636363636364
 | 060996 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 120 | 240 | 360 | 480 | 600 | 900 | 1200 | 1798 | 2398 | 2998 | 3598 | 4196 | 4796 | 5396 | 5996 | 7194 | 8394 | 9594 | 10792 | 11992 | 14990 | 17986 | 20984 | 23982 | 26980 | 29978
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 255 | 340 | 420 | 420 | 420 | 470 | 540 | 605 | 1200 | 1200 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 0.5789473684210527 | 0.8 | 0.5372549019607843 | 1.047058823529412 | 0.7764705882352941 | 0.6476190476190476 |  | 1.197619047619048 |  | 1.137037037037037 |  | 0.1466666666666667 |  |  | 0.5283333333333333 |  | 0.1363636363636364
 | 061151 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 22 | 44 | 68 | 90 | 112 | 168 | 224 | 338 | 450 | 562 | 674 | 788 | 900 | 1012 | 1124 | 1350 | 1574 | 1800 | 2024 | 2248 | 2812 | 3374 | 3936 | 4498 | 5060 | 5622
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 190 | 190 | 190 | 255 | 255 | 255 | 340 | 420 | 420 | 420 | 470 | 540 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 2.266666666666667 | 3.35 | 4.033333333333333 | 4.766666666666667 |  | 3.857894736842105 |  | 5.073684210526316 |  | 6.242105263157895 |  |  | 6.192156862745098 |  | 4.952380952380953
 | 060995 .016 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 86 | 170 | 256 | 340 | 426 | 638 | 850 | 1276 | 1702 | 2128 | 2552 | 2978 | 3404 | 3830 | 4254 | 5106 | 5956 | 6808 | 7658 | 8510 | 10636 | 12764 | 14892 | 17020 | 19146 | 21274
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 540 | 605 | 1200 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 0.8 | 1.063157894736842 | 1.047058823529412 | 1.368627450980392 | 1.035294117647059 |  | 1.197619047619048 |  | 1.747619047619048 |  | 1.548148148148148 |  |  | 0.5283333333333333 |  | 0.1363636363636364
 | 060995 .020 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 102 | 204 | 306 | 408 | 510 | 764 | 1020 | 1528 | 2038 | 2548 | 3180 | 3568 | 4076 | 4586 | 5096 | 6116 | 7134 | 8154 | 9172 | 10192 | 12740 | 15288 | 17836 | 20384 | 22932 | 25480
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 540 | 605 | 1200 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 0.8 | 1.063157894736842 | 1.047058823529412 | 0.7764705882352941 | 1.035294117647059 |  | 1.197619047619048 |  | 1.45531914893617 |  | 1.274380165289256 |  |  | 0.5283333333333333 |  | 0.1363636363636364
 | 070913 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 52 | 106 | 158 | 212 | 264 | 398 | 530 | 794 | 1060 | 1324 | 1588 | 1854 | 2118 | 2384 | 2648 | 3178 | 3706 | 4236 | 4766 | 5296 | 6620 | 7944 | 9268 | 10592 | 11916 | 13238
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 190 | 255 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 605 | 1200 | 1200 | 1200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 2.266666666666667 | 1.747368421052632 | 2.178947368421053 | 2.642105263157895 |  | 2.619607843137255 |  | 2.394117647058823 |  | 2.276190476190476 |  |  | 2.902127659574468 |  | 1.083333333333333
 | 081275 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 64 | 128 | 194 | 258 | 322 | 482 | 644 | 966 | 1288 | 1608 | 1930 | 2252 | 2574 | 2896 | 3218 | 3862 | 4504 | 5148 | 5792 | 6436 | 8044 | 9652 | 11262 | 12870 | 14480 | 16088
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 540 | 605 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 1.063157894736842 | 1.747368421052632 | 1.368627450980392 | 1.713725490196078 |  | 1.714705882352941 |  | 1.747619047619048 |  | 2.276190476190476 |  |  | 2.031404958677686 |  | 1.083333333333333
 | 080757 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 90 | 180 | 272 | 362 | 452 | 678 | 904 | 1358 | 1810 | 2262 | 2714 | 3166 | 3620 | 4072 | 4524 | 5430 | 6334 | 7238 | 8144 | 9048 | 11310 | 13572 | 15834 | 18096 | 20358 | 22622
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 255 | 255 | 340 | 340 | 420 | 420 | 420 | 470 | 540 | 1200 | 1200 | 1200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 0.8 | 1.063157894736842 | 1.047058823529412 | 1.368627450980392 | 1.035294117647059 |  | 1.197619047619048 |  | 1.747619047619048 |  | 1.548148148148148 |  |  | 0.5283333333333333 |  | 0.1363636363636364
 | 090060 | 1000 | 2000 | 3000 | 4000 | 5000 | 7500 | 10000 | 15000 | 20000 | 25000 | 30000 | 35000 | 40000 | 45000 | 50000 | 60000 | 70000 | 80000 | 90000 | 100000 | 125000 | 150000 | 175000 | 200000 | 225000 | 250000 | 275000
 | Pounds | 22 | 44 | 66 | 88 | 110 | 164 | 218 | 328 | 438 | 546 | 656 | 766 | 876 | 984 | 1094 | 1312 | 1532 | 1750 | 1970 | 2188 | 2734 | 3282 | 3828 | 4376 | 4922 | 5470
 | Old Freight $ |  |  |  |  | 300 | 300 | 342 | 392 | 522 | 604 | 692 |  | 923 |  | 1154 |  | 1376 |  |  | 1834 |  | 2500
 | New Freight $ | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 120 | 190 | 190 | 190 | 190 | 190 | 255 | 255 | 255 | 340 | 420 | 420 | 420 | 470 | 470 | See Estimating
 | % Difference |  |  |  |  | 1.5 | 1.5 | 1.85 | 2.266666666666667 | 3.35 | 4.033333333333333 | 4.766666666666667 |  | 3.857894736842105 |  | 5.073684210526316 |  | 6.242105263157895 |  |  | 6.192156862745098 |  | 4.952380952380953