Spreadsheet: 223730d1364305927-determine-carriage-codes-via-macro-formula-or-extract-from-table-carriage-formulas
Sheet: Sheet1

 | Dimension1 | Dimension2 | Dimension3 |  |  |  | format | StockCode | Weight | packaging weight | packed weight | carriage code | carriage cost | CODE | COST
 | 480 | 30 | 40 | 480 | 30 | 40 |  | FAISDS25410 | 0.8 | 0.29 |  | 600 | 4.57
 | 245 | 50 | 100 | 245 | 50 | 100 |  | WER073240 | 0.182 | 0.12 |  | 400 | 1.92
 | 200 | 35 | 90 | 200 | 35 | 90 |  | VIT102825 | 0.101 | 0.12 |  | 350 | 1.92
 | 150 | 78 | 120 | 150 | 78 | 120 |  | SMJE61MTB | 0.148 | 0.12 |  | 400 | 1.92
 | 54 | 205 | 84 | 54 | 205 | 84 |  | KPX0202200 | 0.355 | 0.2 |  | 450 | 1.92
 | 400 | 25 | 150 | 400 | 25 | 150 |  | BAH225PLUS | 0.686 | 0.25 |  | 500 | 2.54
 | 200 | 100 | 30 | 200 | 100 | 30 |  | [NAME] | 0.84 | 0.29 |  | 600 | 4.57
 | 100 | 825 | 610 | 100 | 825 | 610 |  | FAITRESTLESP | 2.04 | 0.35 |  | 800 | 5.02
 | 0 | 0 | 0 | 0 | 0 | 0 |  | FORCB840 | 4.923 | 0.35 |  | 800 | 5.02
 | 213 | 30 | 145 | 213 | 30 | 145 |  | [NAME] | 0.074 | 0.075 |  | 350 | 1.92
 | 40 | 280 | 140 | 40 | 280 | 140 |  | UNNY2201SC25 | 0.6 | 0.25 |  | 500 | 2.54
 | 273 | 250 | 50 | 273 | 250 | 50 |  | RYBRAK19HSS | 0.578 | 0.25 |  | 500 | 2.54
 | 273 | 250 | 50 | 273 | 250 | 50 |  | RYBRAK30MIX | 0.654 | 0.25 |  | 500 | 2.54
 | 7 | 530 | 320 | 7 | 530 | 320 |  | RYBUTB4G | 2.151 | 0.35 |  | 800 | 5.02
 | 320 | 60 | 60 | 320 | 60 | 60 |  | MGLS3D035 | 0.494 | 0.2 |  | 450 | 1.92
 | 320 | 60 | 60 | 320 | 60 | 60 |  | MGLS3D115 | 0.495 | 0.2 |  | 450 | 1.92
 | 380 | 60 | 125 | 380 | 60 | 125 |  | MGLS3D116 | 0.5 | 0.25 |  | 450 | 1.92
 | 273 | 250 | 50 | 273 | 250 | 50 |  | RYBRAK20JB | 0.5 | 0.25 |  | 450 | 1.92
 | 320 | 60 | 60 | 320 | 60 | 60 |  | MGLS3D015 | 0.504 | 0.25 |  | 500 | 2.54
 | 380 | 60 | 125 | 380 | 60 | 125 |  | MGLS3D106 | 0.508 | 0.25 |  | 500 | 2.54
 | 380 | 60 | 125 | 380 | 60 | 125 |  | MGLS3D016 | 0.511 | 0.25 |  | 500 | 2.54
 | 380 | 60 | 125 | 380 | 60 | 125 |  | MGLS3D036 | 0.512 | 0.25 |  | 500 | 2.54
 | 170 | 80 | 80 | 170 | 80 | 80 |  | PRI94035 | 0.989 | 0.29 |  | 350 | 1.92
 | 250 | 760 | 35 | 250 | 760 | 35 |  | [NAME] | 1.15 | 0.29 |  | 700 | 5.02
 | 325 | 325 | 55 | 325 | 325 | 55 |  | MON756 | 0.39 | 0.2 |  | 450 | 1.92
 | 340 | 340 | 60 | 340 | 340 | 60 |  | MON751 | 0.4 | 0.2 |  | 450 | 1.92
 | 220 | 60 | 120 | 220 | 60 | 120 |  | FAICHUCKRA | 0.5 | 0.25 |  | 450 | 1.92
 | 0 | 0 | 0 | 0 | 0 | 0 |  | WELCT2E7 | 0.097 | 0.075 |  | 150 | 0.76
 | 230 | 120 | 240 | 230 | 120 | 240 |  | SCAPPERESPA1 | 0.377 | 0.2 |  | 450 | 1.92
 | 115 | 182 | 182 | 115 | 182 | 182 |  | FAIAR115120Y | 1.833 | 0.29 |  | 800 | 5.02
 | 21 | 170 | 74 | 21 | 170 | 74 |  | BAH2430G140 | 0.136 | 0.12 |  | 200 | 1.01
 | 14 | 280 | 280 | 14 | 280 | 280 |  | FAIZ23540 | 0.709 | 0.25 |  | 500 | 2.54
 | 330 | 230 | 220 | 330 | 230 | 220 |  | IRW10505371 | 1.327 | 0.29 |  | 700 | 5.02
 | 17 | 180 | 17 | 17 | 180 | 17 |  | IRW10502900 | 0.079 | 0.075 |  | 150 | 0.76
 | 15 | 180 | 15 | 15 | 180 | 15 |  | IRW10502692 | 0.08 | 0.075 |  | 150 | 0.76
 | 36 | 140 | 87 | 36 | 140 | 87 |  | B/DA6155 | 0.176 | 0.12 |  | 400 | 1.92
 | 30 | 175 | 130 | 30 | 175 | 130 |  | UNNJ2201SC30 | 0.58 | 0.25 |  | 500 | 2.54
 | 250 | 182 | 182 | 250 | 182 | 182 |  | IRW10503830 | 0.99 | 0.29 |  | 700 | 5.02
 | 25 | 405 | 25 | 25 | 405 | 25 |  | IRW10502038 | 0.307 | 0.2 |  | 450 | 1.92
 | 673 | 28 | 165 | 673 | 28 | 165 |  | BAHHUS10650 | 1.355 | 0.29 |  | 700 | 5.02
 | 0 | 0 | 0 | 0 | 0 | 0 |  | HLLXCM20 | 0.08 | 0.075 |  | 350 | 1.92
 | 69 | 67 | 90 | 69 | 67 | 90 |  | [NAME] | 0.637 | 0.25 |  | 500 | 2.54
 | 65 | 420 | 90 | 65 | 420 | 90 |  | L/HEHAWK2D | 0.919 | 0.29 |  | 600 | 4.57
 | 60 | 15 | 35 | 60 | 15 | 35 |  | WER059534003 | 0.061 | 0.075 |  | 150 | 0.76
 | 15 | 58 | 34 | 15 | 58 | 34 |  | [NAME] | 0.011 | 0.05 |  | 100 | 0.53
 | 1026 | 100 | 265 | 1026 | 100 | 265 |  | BUL5TM2T | 2.4 | 0.35 |  | 800 | 5.02
 | 260 | 115 | 260 | 260 | 115 | 260 |  | FLV94133 | 2.58 | 0.35 |  | 800 | 5.02
 | 365 | 10 | 310 | 365 | 10 | 310 |  | IRW10506815 | 0.546 | 0.25 |  | 500 | 2.54
 | 1026 | 100 | 265 | 1026 | 100 | 265 |  | BUL5TM2MYD | 2.6 | 0.35 |  | 800 | 5.02
 | 14 | 125 | 38 | 14 | 125 | 38 |  | KPX8701125 | 0.09 | 0.075 |  | 200 | 1.01
 | 0 | 0 | 0 | 0 | 0 | 0 |  | WELCT2E8 | 0.092 | 0.075 |  | 150 | 0.76
 | 302 | 35 | 44 | 302 | 35 | 44 |  | BAH952630 | 0.429 | 0.2 |  | 450 | 1.92
 | 600 | 22 | 35 | 600 | 22 | 35 |  | FAIMAX16540 | 0.558 | 0.25 |  | 500 | 2.54
 | 178 | 127 | 76 | 178 | 127 | 76 |  | KUNKP309 | 0.618 | 0.25 |  | 500 | 2.54
 | 300 | 18 | 75 | 300 | 18 | 75 |  | FAIRYOSC75 | 0.8 | 0.29 |  | 600 | 4.57
 | 40 | 360 | 65 | 40 | 360 | 65 |  | IRW10507160 | 1.08 | 0.29 |  | 700 | 5.02
 | 90 | 40 | 280 | 90 | 40 | 280 |  | [NAME] | 0.88 | 0.29 |  | 600 | 4.57
 | 26 | 305 | 153 | 26 | 305 | 153 |  | CHH10200 | 0.89 | 0.29 |  | 600 | 4.57
 | 160 | 38 | 115 | 160 | 38 | 115 |  | FAISDSET3 | 0.51 | 0.25 |  | 600 | 4.57
 | 25 | 170 | 25 | 25 | 170 | 25 |  | ROH14991 | 0.61 | 0.25 |  | 500 | 2.54
 | 120 | 50 | 200 | 120 | 50 | 200 |  | FAIBCJ24N | 0.8 | 0.29 |  | 600 | 4.57
 | 45 | 365 | 260 | 45 | 365 | 260 |  | STA564977 | 0.886 | 0.29 |  | 600 | 4.57
 | 78 | 25 | 305 | 78 | 25 | 305 |  | EVBDRYGUN | 0.461 | 0.2 |  | 250 | 1.43
 | 305 | 60 | 120 | 305 | 60 | 120 |  | THO214 | 1.6 | 0.29 |  | 700 | 5.02
 | 0 | 0 | 0 | 0 | 0 | 0 |  | FORWA8140 | 2.344 | 0.35 |  | 800 | 5.02
 | 0 | 0 | 0 | 0 | 0 | 0 |  | FORWA10100 | 2.456 | 0.35 |  | 800 | 5.02
 | 0 | 0 | 0 | 0 | 0 | 0 |  | FORCB1050 | 5.252 | 0.35 |  | 800 | 5.02
 | 18 | 230 | 84 | 18 | 230 | 84 |  | KPX3811200 | 0.205 | 0.12 |  | 200 | 1.01
 | 250 | 25 | 85 | 250 | 25 | 85 |  | KPX7002180 | 0.267 | 0.2 |  | 200 | 1.01
 | 45 | 273 | 160 | 45 | 273 | 160 |  | RAPDTM118 | 0.08 | 0.075 |  | 350 | 1.92
 | 590 | 31 | 90 | 590 | 31 | 90 |  | BAH3845T | 0.322 | 0.2 |  | 450 | 1.92
 | 590 | 31 | 90 | 590 | 31 | 90 |  | BAH3846T | 0.322 | 0.2 |  | 450 | 1.92
 | 14 | 260 | 260 | 14 | 260 | 260 |  | FAIZ21648TCG | 0.614 | 0.25 |  | 500 | 2.54
 | 14 | 260 | 260 | 14 | 260 | 260 |  | FAIZ21648Z | 0.614 | 0.25 |  | 500 | 2.54
 | 420 | 35 | 105 | 420 | 35 | 105 |  | [NAME] | 1.046 | 0.29 |  | 700 | 5.02
 | 40 | 750 | 50 | 40 | 750 | 50 |  | RPTCH601 | 0.395 | 0.2 |  | 800 | 5.02
 | 40 | 85 | 40 | 40 | 85 | 40 |  | ABUK60N3045 | 0.2 | 0.12 |  | 450 | 1.92
 | 14 | 560 | 27 | 14 | 560 | 27 |  | IRW10507152 | 0.215 | 0.12 |  | 400 | 1.92
 | 435 | 136 | 194 | 435 | 136 | 194 |  | STA020108 | 1.124 | 0.29 |  | 700 | 5.02
 | 700 | 40 | 180 | 700 | 40 | 180 |  | [NAME] | 2.55 | 0.35 |  | 800 | 5.02
 | 0 | 0 | 0 | 0 | 0 | 0 |  | FORCB1275 | 4.99 | 0.35 |  | 800 | 5.02
 | 260 | 1 | 22 | 260 | 1 | 22 |  | IRW10506803 | 0.23 | 0.12 |  | 200 | 1.01
 | 245 | 45 | 235 | 245 | 45 | 235 |  | IRW10503991 | 0.44 | 0.2 |  | 450 | 1.92
 | 175 | 50 | 218 | 175 | 50 | 218 |  | HIT710000 | 0.847 | 0.29 |  | 600 | 4.57
 | 50 | 355 | 170 | 50 | 355 | 170 |  | STA487052 | 1.022 | 0.29 |  | 700 | 5.02