Spreadsheet: 155303d1336756443-if-statement-for-largest-number-in-series-error-2-
Sheet: Error

Route |  | 4 | cust_code | cust_name | stop_no | ship_city | ship_zip | Weight | Use of Semis if over 18000lbs | [NAME] | [NAME]/gl | [NAME]/gl | Reefer 7hrs/day * consumption | Total Fuel Cost | Zones | Lead Zone
1 |  |  | V1 | VALLARTA SUPERMARKET   #1 | 1 | [NAME] | 91606 | 18.3 | 0 | 19.5 |  |  |  |  | 2
1 |  |  | V9 | VALLARTA SUPERMARKET   #9 | 2 | [NAME] | 91606 | 617.25 | 0 | 2.5 |  |  |  |  | 2
1 |  |  | 1267 | LOS BURRITOS INC.      #7 | 3 | [NAME] | 91601 | 203.44 | 0 | 5 |  |  |  |  | 2
1 |  |  | 8871 | SALSA & BEER 2 INC. | 4 | [NAME] | 91605 | 210.7 | 0 | 5 |  |  |  |  | 2
1 |  |  | 6288 | SUPERMERCADOS EL PUEBLO H | 5 | [NAME] | 91601 | 390.5 | 0 | 4.7 |  |  |  |  | 2
1 |  |  | 6805 | SWEET 1 BAKERY | 6 | VAN NUYS | 91401 | 453.85 | 0 | 3.1 |  |  |  |  | 2
1 |  |  | 9843 | ZARAGOZA MEAT MARKET INC. | 7 | VAN NUYS | 91405 | 526.87 | 0 | 2.7 |  |  |  |  | 2
1 |  |  | 8872 | SALSA & BEER, INC. | 8 | VAN NUYS | 91406 | 218.8 | 0 | 10 |  |  |  |  | 3
1 |  |  | V12 | VALLARTA SUPERMARKET  #12 | 9 | CANOGA PARK | 91304 | 12.12 | 0 | 4.5 |  |  |  |  | 3
1 |  |  | 2159 | CARNICERIA RODRIGUEZ C.P. | 10 | CANOGA PARK | 91303 | 251.8 | 0 | 4.5 |  |  |  |  | 3
1 |  |  | 8173 | SUPERMERCADOS EL PUEBLO C | 11 | CANOGA PARK | 91303 | 587.13 | 0 | 1.8 |  |  |  |  | 3
1 |  |  | V24 | VALLARTA SUPERMARKET  #24 | 12 | WINNETKA | 91306 | 1858.38 | 0 | 4.3 |  |  |  |  | 3
1 |  |  | 6523 | INDIA'S TANDOORI     Tar. | 13 | TARZANA | 91356 | 200 | 0 | 2.9 |  |  |  |  | 3
1 |  |  | 4711 | VALLEY GREEN MARKET  [NAME]. | 14 | RESEDA | 91335 | 452.55 | 0 | 27.7 |  |  |  |  | 3
1 Total |  |  |  |  |  |  |  | 6001.690000000001 | 0 | 98.20000000000002 | 15.10769230769231 |  | 3.5 | 0 |  | 3
2 |  |  | SG111 | SUPERIOR GROCERS     #111 | 1 | PACOIMA | 91331 | 4000 | 0 | 24.8 |  |  |  |  | 3
2 |  |  | 2519 | CORTESIA MARKET | 2 | PACOIMA | 91331 | 1161.8 | 0 | 3.1 |  |  |  |  | 3
2 |  |  | TS1 | TRESIERRAS MARKETS #1 | 3 | PACOIMA | 91331 | 952.9 | 0 | 3.1 |  |  |  |  | 3
2 |  |  | V18 | VALLARTA SUPERMARKET  #18 | 4 | PACOIMA | 91331 | 168 | 0 | 1.2 |  |  |  |  | 3
2 |  |  | 8141 | SUPERMERCADOS EL PUEBLO P | 5 | PANORAMA CITY | 91402 | 333.6 | 0 | 3.3 |  |  |  |  | 3
2 |  |  | TS4 | TRESIERRAS MARKETS #4 | 6 | NEWHALL | 91321 | 631.2 | 0 | 15.3 |  |  |  |  | 4
2 |  |  | 7618 | LAKEVIEW FARM MARKET,INC. | 7 | LAKEVIEW TERRACE | 91342 | 366.9 | 0 | 17.4 |  |  |  |  | 3
2 |  |  | V7 | VALLARTA SUPERMARKET   #7 | 8 | SYLMAR | 91342 | 987.6 | 0 | 30.2 |  |  |  |  | 3
2 Total |  |  |  |  |  |  |  | 8602 | 0 | 98.39999999999999 | 15.13846153846154 |  | 3.5 | 0 |  | 4
3 |  |  | V10 | VALLARTA SUPERMARKET  #10 | 1 | FRESNO | 93727 | 2908.62 | 0 | 228 |  |  |  |  | 9
3 |  |  | V29 | VALLARTA SUPERMARKET  #29 | 2 | FRESNO | 93726 | 3778.16 | 0 | 5.9 |  |  |  |  | 9
3 |  |  | 2308 | [NAME] | 3 | FRESNO | 93702 | 1240.08 | 0 | 19.4 |  |  |  |  | 9
3 |  |  | 7388 | LA FIESTA MEAT MARKET Ker | 4 | KERMAN | 93630 | 1033.29 | 0 | 31.7 |  |  |  |  | 9
3 |  |  | 8796 | UNITED SUPERMARKET    Sel | 5 | SELMA | 93662 | 1686 | 0 | 208 |  |  |  |  | 9
3 Total |  |  |  |  |  |  |  | 10646.15 | 0 | 493 | 75.84615384615384 |  | 3.5 | 0 |  | 9
4 |  |  | 3245 | HB POULTRY INC. | 1 | [NAME] | 91733 | 7791.37 | 0 | 13.5 |  |  |  |  | 2
4 |  |  | SK4 | SUPER KING MARKET      #4 | 2 | CLAREMONT | 91711 | 7646.29 | 0 | 68.2 |  |  |  |  | 3
4 |  |  | V22 | VALLARTA SUPERMARKET  #22 | 3 | [NAME] | 92392 | 3754.8 | 0 | 0 |  |  |  |  | 4
4 |  |  | 4139 | CAJON MEAT MARKET | 4 | SAN BERNARDINO | 92407 | 859.61 | 0 | 1.9 |  |  |  |  | 4
4 |  |  | 8311 | MIDWAY MARKET | 5 | SAN BERNARDINO | 92410 | 493.68 | 0 | 2.7 |  |  |  |  | 4
4 |  |  | 8940 | SANTA FE MARKET | 6 | SAN BERNARDINO | 92411 | 508 | 0 | 2.7 |  |  |  |  | 4
4 |  |  | 5012 | FARMERS MARKET       S.B. | 7 | SAN BERNARDINO | 92405 | 573.5 | 0 | 5.8 |  |  |  |  | 4
4 |  |  | 1938 | EL RICO POLLO | 8 | SAN BERNARDINO | 92408 | 245.1 | 0 | 61.8 |  |  |  |  | 4
4 Total |  |  |  |  |  |  |  | 21872.35 | 21872.35 | 156.6 |  | 28.47272727272728 | 7 | 0 |  | 9