Spreadsheet: 233081d1367606924-complicated-data-lookups-ranks-example
Sheet: Sheet1

Zip Codes |  | Zones |  |  |  | Proposed Rates |  |  |  |  | Avg Cost |  | Total Carriers with Rates |  | 2012 Loads Per Lane |  |  |  | Proposed Savings Per Lane |  |  |  |  | Zip Codes |  | Zones |  |  |  | Proposed Rates |  |  |  | 2012 Prepaid Loads | Proposed Savings Per Lane
Start Range | End Range | State | Region | Primary Location(s) | [NAME] (FE) | Per Mile | Min. | Over [NAME]. (p/m) | Over [NAME]. (min.) | Rank | P/M | Min. | P/M rates          ([NAME]: 16)        Incl. Proposed | Min. rates          ([NAME]: 16)        Incl. Proposed | Prepaid Loads | IM Loads | CPU Loads | Total Loads | Yearly Savings over Avg (25% of volume) | Avg Savings per load | Per [NAME] |  |  | Start Range | End Range | State | Region | Primary Location(s) | [NAME] (FE) | Per Mile | Min. | Over [NAME]. (p/m) | Over [NAME]. (min.) |  | Yearly Savings over Avg (25% of volume) | Avg Savings per load | Per [NAME]
500 | 504 | IA | East |  |  | 0.9 | 0 | -0.02384615384615385 |  |  | 3.24 | 622.2222222222222 | 7 | 9 |  |  |  | 0 |  |  |  |  | 1
505 | 505 | IA | West |  |  | 0.9 | 0 | -0.05833333333333335 |  |  | 3.05125 | 657.2222222222222 | 8 | 9 |  |  |  | 0 |  |  |  |  | 2
506 | 507 | IA | East | [NAME] | 1067 | 0.9 | 0 | -0.05461538461538473 |  | 2 | 2.91625 | 658.3333333333334 | 8 | 9 | 311 | 80 |  | 391 | 4530.851346153856 | 58.27461538461551 | 0.05461538461538473 |  | 3
508 | 508 | IA | West |  |  | 0.9 | 0 | -0.0641666666666667 |  |  | 2.78375 | 656.6666666666666 | 8 | 9 |  |  |  | 0 |  |  |  |  | 4
509 | 509 | IA | East |  |  | 0.9 | 0 | -0.03615384615384598 |  |  | 2.635555555555556 | 650.9090909090909 | 9 | 11 |  |  |  | 0 |  |  |  |  | 5
510 | 519 | IA | West |  |  | 0.9 | 0 | -0.1054545454545454 |  |  | 2.792222222222222 | 716 | 9 | 10 |  |  |  | 0 |  |  |  |  | 6
520 | 528 | IA | East | Maquoketa | 992 | 0.9 | 0 | -0.0007692307692308553 |  | 5 | 2.7025 | 676 | 8 | 10 | 93 | 24 |  | 117 | 17.74153846154045 | 0.7630769230770085 | 0.0007692307692308553
530 | 532 | WI | South | Oconomowoc | 892 | 0.82 | 0 | 0.002307692307692011 |  | 6 | 2.59 | 701.6663636363636 | 10 | 11 | 446 | 111 |  | 557
534 | 535 | WI | South | [NAME] | 887 | 0.82 | 0 | -0.01692307692307704 |  |  | 2.364444444444445 | 715.4545454545455 | 9 | 11 | 4 |  |  | 4 | 15.01076923076933 | 15.01076923076933 | 0.01692307692307704
537 | 539 | WI | South | [NAME] | 928 | 0.82 | 0 | -0.02230769230769258 |  | 4 | 2.23 | 799.375 | 8 | 8 | 7 |  |  | 7 | 36.22769230769276 | 20.70153846153872 | 0.02230769230769258
540 | 545 | WI | North | [NAME] | 1021 | 0.85 | 0 | -0.05153846153846176 |  |  | 2.375714285714285 | 730.5555555555555 | 7 | 9 | 23 |  |  | 23 | 302.5694230769244 | 52.62076923076945 | 0.05153846153846176
546 | 546 | WI | South | Tomah | 1015 | 0.82 | 0 | -0.06916666666666682 |  | 3 | 2.23 | 840.625 | 8 | 8 | 47 |  |  | 47 | 824.8989583333351 | 70.20416666666682 | 0.06916666666666682
547 | 549 | WI | North |  |  | 0.85 | 0 | -0.08923076923076922 |  |  | 2.25125 | 890.7142857142857 | 8 | 7 |  |  |  | 0
550 | 555 | MN | South | [NAME] | 1229 | 0.95 | 0 | 0.01538461538461522 |  | 1 | 2.3375 | 743.3333333333334 | 8 | 9 | 358 | 2 |  | 360