Spreadsheet: 72496d1273173733-sum-multiple-columns-sumiferror
Sheet: Sheet1

 | DAILY DISPATCH WORKSHEET FOR: |  |  |  |  |  |  | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract |  | Gallons | 2010-04-15 00:00:00
 |  |  |  | Hi-Noon surcharge | 0.21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gas | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diesel | 42552
 |  |  |  |  |  |  | HLD | ---------------------------Gasoline----------------------------- |  |  |  |  |  | -----------------------------Diesel-------------------------------
load % |  |  |  | DESTINATION | LOAD # | Truck | BY | NL | E10 | SNL | E10 | PNL | E10 | DS2 | [NAME] |  | DS1 | DSR1 |  | TERM | SUPLR | S/C | DSPH |  |  |  |  | [NAME] | mileage | Freight (gas) | freght (die) | income | Load P/L | Net P/L
0.8338095238095238 | 0.8338095238095238 | Zip Trip #32 - Msla | 2010-04-15 00:00:00 | crossroads | 1 | T1 | M | 1 | 1 |  |  |  |  | 10504 |  |  |  |  |  | MSO | T&C | 0 | X | off Contract - pull #'s 51481/54834 |  |  |  | 11 | 11 | 0.018055 | 0.0207 | 217.46891 | 145.52891 | 145.52891
0.3412698412698413 |  | Zip Trip #31 - Msla | 2010-04-15 00:00:00 | [NAME] | 2 | T1 | M |  | 4300 |  |  |  |  |  |  |  |  |  |  | MSO | Sinc | 0.21 | X |  |  |  |  | 10 | 10 | 0.018055 | 0.0207 | 93.940165 | 28.54016499999999
0.4365873015873016 | 0.7778571428571428 | zip trip # 41 | 2010-04-15 00:00:00 | Southgate Market | 2 | T1 | M |  | 5501 |  |  |  |  |  |  |  |  |  |  | MSO | Sinc | 0.21 | X |  |  |  |  | 4 | 0 | 0.018055 | 0.0207 | 120.17787155 | 120.17787155 | 148.71803655
0.9365873015873016 | 0.9365873015873016 | Zip Trip # 40 | 2010-04-15 00:00:00 | PBG | 3 | T1 | M |  | 10301 |  |  |  |  | 1500 |  |  |  |  |  | MSO | Sinc | 0.21 | X |  |  |  |  | 67 | 67 | 0.03541999999999999 | 0.04025 | 514.5360681999999 | 76.35606819999992 | 76.35606819999992
#[NAME]! | N/A | zip trip # 39 | 2010-04-15 00:00:00 | dale's fueling - cc | 4 | DX | cc | 4000 |  |  |  | 300 |  | 1850 | 850 |  |  |  |  | BZN | Sinc | 0.21 | X | 8000 gal min / Dale ok'd |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
#[NAME]! |  | Wheat MT | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | Watkins shepard MSLA | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | Watkins shepard HLNA | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | Van oil | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | [NAME] | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | TP Kalispell #2 | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | Town station | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | [NAME]'s market | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | sunshine stn. | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | sunken treasure | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | sun prairie | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | State Line Plant - Busch | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | southgate market | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | St, Mary's | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | smiths foods - klsp | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | Sanders Co. | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | [NAME] | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | [NAME] lewis | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | RHJ #1 | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | Points north | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | PBG | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | N.W. Energy | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | MT DOT - Msla | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | MT D.O.T. - Kalispell | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
#[NAME]! |  | MMM | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | 0
 |  | milltown market | 2010-04-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Total |  |  |  |  |  |  | 92
 | 0.8494179894179895 | Melrose bar |  | Totals |  |  |  | 4001 | 20103 | 0 | 0 | 300 | 0 | 13854 | 850 |  | 0 | 0 |  |  | 39108 |  |  |  |  |  |  |  | Total
 |  | Lochsa lodge
Totals by truck |  | Little ott's |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck | day | month |  | Driver freight percentage |  |  |  |  | 176 |  |  | 946.1230147499998 | 370.6030147499998
 |  | LHC construction |  | 12600 | T1 |  |  | 1 | 20103 | 0 | 0 | 0 | 0 | 12004 | 0 |  | 0 | 0 |  | 0.2254978276530351 | 32108 |  | 505213 |  | Daily | This Month
 |  | Lakeside |  | 12600 | T7 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.1795973458713803 | 0 |  | 402376 | B | 0 | 0.1326119992756311 |  |  | Daily per truck miles |  |  | Daily per truck profitability
 |  | [NAME] |  | 10500 | T15 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.04733948868835235 | 0 |  | 106061 | S | 0 | 0.1316736826629088 |  |  | T1 | 176 |  | T1 | 370.6030147499998
 |  | Joyco #1 -stn |  | 10500 | T17 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | D | 0 | 0.2420962738330756 |  |  | T7 | 0 |  | T7 | 0
 |  | [NAME] (bulk) |  | 11500 | T18 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.2287775493498135 | 0 |  | 512561 | L | 0 | 0.263043107384543 |  |  | T15 | 0 |  | T15 | 0
 |  | [NAME]'s mart |  | 12100 | T19 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.2149302322674982 | 0 |  | 481537 | M | 1 | 0.2207973118435186 |  |  | T17 | 0 |  | T17 | 0
 |  | [NAME]'s foods |  |  | MW |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.03415900669245334 | 0 |  | 76531 | K | 0 | 0 |  |  | T18 | 0 |  | T18 | 0
 |  | happy endings |  |  | ANK |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  |  |  |  |  | T19 | 0 |  | T19 | 0
 |  | happy days - B |  |  | DX |  |  | 4000 | 0 | 0 | 0 | 300 | 0 | 1850 | 850 |  | 0 | 0 |  | 0.04691189296359544 | 7000 |  | 105103 |  | 1 | 0.990222374999677
 |  | H&R #4 |  |  | KLR |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.009462452364140162 | 0 |  | 21200
 |  | H&R #3 |  |  | OTTS |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0.0133242041497317 | 0 |  | 29852 |  |  |  |  |  | Daily freight income |  |  | Truck load percentage
 |  | H&R #2 |  |  | other |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  |  |  |  |  | T1 | 946.1230147499998 |  | T1 | 0.8494179894179895
 |  | H&R #1 |  |  | other |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | T1 | M |  |  | T7 | 0 |  | T7 | 0
 |  | GCM |  |  | other |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | T7 | S |  |  | T15 | 0 |  | T15 | 0
 |  | Friendly's |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T18 | D |  |  | T17 | 0 |  | T17 | 0
 |  | Fleming Farms |  | Totals by location |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T19 | L |  |  | T18 | 0 |  | T18 | 0
 |  | Emigrant |  | 426 | 426 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | T15 | B |  |  | T19 | 0 |  | T19 | 0
 |  | Demarois |  | 457 | 457 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | MW
 |  | dale's fueling |  | 470 | 470 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | ANK |  |  |  |  | 946.1230147499998 |  |  | 0.8494179894179895
 |  | crossroads - GF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | DX
 |  | crossroads |  | sunshine stn. | sunshine stn. - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | KLR
 |  | By-way service |  | Happy endings | happy endings - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | OTTS |  |  |  | T&C | Daily Contract Gallons
 |  | [NAME]'s Valley |  | 433 | 433 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  | Gas
 |  | [NAME]'s general |  | 444 | 444 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  |  |  |  |  | Diesel
 |  | big sky |  | Allard's | allard's - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Big hole |  | PBG | PBG - cc |  |  | 0 | 10301 | 0 | 0 | 0 | 0 | 1500 | 0 | 0 | 0 | 0 |  | 11801 |  |  |  |  |  |  |  |  |  | 1
 |  | arend's |  | crossroads | crossroads - cc |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 10504 | 0 | 0 | 0 | 0 |  | 10506 |  |  |  |  |  |  |  |  |  | 1
 |  | allard's |  | [NAME] | [NAME] |  |  | 0 | 4300 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 4300
 |  | 1 stop seeley |  | GCM | GCM - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 25001 |  | Friendly's | Friendly's - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 470 |  | [NAME]'s Valley | [NAME]'s Valley - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 457 |  | Big Sky | big sky - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 444 |  | H&R #1 | H&R #1 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 433 |  | RHJ #1 | RHJ #1 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 426 |  | 25001 | 25001 - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  |  |  | Wheat MT | Wheat MT - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | crossroads - cc |  | Big Hole | Big hole - cc |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 1 stop seeley - cc
 |  | 25001 - cc
 |  | 426 - cc
 |  | 433 - cc
 |  | 444 - cc
 |  | 457 - cc
 |  | 470 - cc
 |  | allard's - cc
 |  | arend's - cc
 |  | Big hole - cc
 |  | big sky - cc
 |  | [NAME]'s general - cc
 |  | [NAME]'s Valley - cc
 |  | By-way service - cc
 |  | Circle Sinclair - cc
 |  | dale's fueling - cc
 |  | Demarois - cc
 |  | Dyno mart - cc
 |  | Emigrant - cc
 |  | Friendly's - cc
 |  | GCM - cc
 |  | H&R #1 - cc
 |  | H&R #2 - cc
 |  | H&R #3 - cc
 |  | H&R #4 - cc
 |  | happy days - R - cc
 |  | happy endings - cc
 |  | [NAME]'s foods - cc
 |  | [NAME]'s mart - cc
 |  | [NAME] (bulk) - cc
 |  | Joyco #1 -stn - cc
 |  | Lakeside - cc
 |  | Little ott's - cc
 |  | Lochsa lodge - cc
 |  | Melrose bar - cc
 |  | milltown market - cc
 |  | MMM - cc
 |  | PBG - cc
 |  | Points north - cc
 |  | RHJ #1 - cc
 |  | [NAME]
 |  | [NAME]
 |  | southgate market - cc
 |  | [NAME] prairie - cc
 |  | sunken treasure - cc
 |  | sunshine stn. - cc
 |  | [NAME]'s market - cc
 |  | Town station - cc
 |  | TP Tfalls
 |  | Van oil - cc
 |  | Watkins shepard [NAME]
 |  | Watkins shepard MSLA - cc
 |  | Wheat MT - cc