Spreadsheet: 63739d1264612985-sumif-formula-multiple-criteria-febuary-2010-dispatch
Sheet: 1

 | DAILY DISPATCH WORKSHEET FOR:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cost per mile ---> |  | 2.89
 |  |  |  | HLD | ---------------------------Gasoline----------------------------- |  |  |  |  |  | -----------------------------Diesel-------------------------------
load % |  | DESTINATION | LOAD # | BY | NL | E10 | SNL | E10 | PNL | E10 | DS2 | [NAME] |  | DS1 | DSR1 |  | TERM | SUPLR | DSPH |  | [NAME] | mileage | Freight (gas) | freght (die) | income | Net P/L
 |  | Emigrant | 1 | T18 | 5500 |  |  |  | 2500 |  |  |  |  |  |  |  | BZN | Sinc | X
 |  | Town Station | 1 | T18 | 2500 |  |  |  | 1000 |  | 2000 |  |  |  |  |  | BZN | Sinc | X
 |  | Friendly's | 2 | T7 | 8400 |  |  |  | 2000 |  | 2000 |  |  |  |  |  | HLN | Sinc | X
 |  | [NAME]'s Valley | 3 | T7 | 11000 |  |  |  |  |  | 1500 |  |  |  |  |  | HLN | Sinc | X
 |  | Wheat MT | 4 | T18 |  | 8200 |  |  |  | 1000 | 3000 |  |  |  |  |  | LGN | T&C | X
 |  | MT DOT - Msla | 5 | T19 |  | 5500 |  |  |  |  |  | 4500 |  |  |  |  | MSO | NWP | X
 |  | Crossroads | 6 | T19 |  | 8000 |  |  |  |  |  |  |  |  |  |  | MSO | Sinc | X
 |  | Crossroads | 7 | T21 |  |  |  |  |  |  | 10500 |  |  |  |  |  | GRF | MRC | X
 |  | 25001 | 8 | T21 | 4000 |  |  |  |  |  | 4000 |  |  |  |  |  | GRF | Sinc | X
 |  | RHJ #1 | 9 | T21 | 4200 |  | 1500 |  |  |  |  |  |  |  |  |  | GRF | Fkl | X
 |  | H&R #4 | 9 | T21 | 3000 |  |  |  |  |  |  |  |  |  |  |  | GRF | Fkl | X
 |  | H&R #1 | 10 | T21 | 4000 |  |  |  | 1000 |  |  |  |  |  |  |  | GRF | Sinc | X
 |  | H&R #2 | 10 | T21 | 3000 |  |  |  |  |  |  |  |  |  |  |  | GRF | Sinc | X
 |  | By Way service | 11 | T21 | 6500 |  |  |  |  |  | 1000 |  |  |  |  |  | GRF | Sinc | X
 |  | H&R #3 | 12 | T21 | 6500 |  |  |  | 1000 |  | 1000 |  |  |  |  |  | GRF | Sinc | X
 |  | Lakeside | 13 | T7 | 2000 |  |  |  |  |  |  |  |  |  |  |  | HLN | Sinc | X
 |  | Jay's Mart | 14 | T19 |  | 3000 |  |  |  | 1000 |  |  |  |  |  |  | MSO | Sinc | X
 |  | Jay's Mart | 14 | T19 |  | 1000 |  |  |  |  |  |  |  |  |  |  | MSO | Sinc | X
 |  | 457 | 14 | T19 |  | 5000 |  |  |  |  |  |  |  |  |  |  | MSO | Sinc | X
 |  | Happy Endings | 15 | T18 |  | 5000 |  |  |  | 1000 | 1000 |  |  |  |  |  | MSO | Sinc | X
 |  | 426 | 16 | T19 |  | 6800 |  |  |  | 1000 | 2000 |  |  |  |  |  | MSO | Sinc | X
 |  | State Line Plant - Busch | 17 | T15 |  | 10500 |  |  |  |  |  |  |  |  |  |  | MSO | Sinc | X
 |  | dale's fueling - cc | 18 | Dx | 5000 |  |  |  | 800 |  | 1700 | 500 |  |  |  |  | BZN | Sinc | X
 |  | 426 - cc |  |  | 666
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total
 |  | Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Totals by truck |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | day | month
 |  | 12600 | T1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | with surcharge
 |  | 12600 | T7
 |  | 10500 | T15
 |  | 10500 | T17
 |  | 11500 | T18
 |  | 12100 | T19
 |  |  | MW
 |  |  | ANK
 |  |  | DX
 |  |  | KLR
 |  |  | OTTS
 |  |  | other
 |  |  | other
 |  |  | other
 |  | Totals by location
 |  | 426 | 426 - cc
 |  | 457
 |  | 470
 |  | sunshine stn.
 |  | Happy endings
 |  | 433
 |  | 444
 |  | Allard's
 |  | PBG
 |  | crossroads
 |  | [NAME]
 |  | GCM
 |  | Friendly's
 |  | [NAME]'s Valley
 |  | Big Sky
 |  | H&R #1
 |  | RHJ #1
 |  | 25001
 |  | Wheat MT
 |  | Big Hole