Spreadsheet: 76375d1276876637-sumproduct-across-multiple-sheets-not-working-service-dispatch-w-tabs
Sheet: ALL WORK IN SHOP

Status | A Customer | S.A. | RO | Model | Promised | A-Tech | Hours | Dispatched At | Completed At | NEEDS DYNO | Job Description |  |  |  |  | Reason for Hold
ASSIGNED | BADINGER | AW | 66971 | 05 FLSTC | 2010-06-18 00:00:00 | RA | 1.8 | 6/18/20109:43 AM |  |  | R&R REAR TIRE, OIL AND FILTER |  |  |  |  |  | #N/A
ASSIGNED | BATTLES | AW | 66960 | 03 XB9R | 2010-06-17 00:00:00 | DH | 0.5 | 6/17/201010:37 AM |  |  | C.S. BIKE WONT START
ASSIGNED | BREUER | KT | 66453 | 09 1125R | ASAP | DH |  |  |  |  | REPLACE MOTOR
ASSIGNED | BRISCKI | PK | 66962 | 02 FLHTCUI | 2010-06-17 00:00:00 | BF | 1 | 6/17/201011:26 AM
ASSIGNED | BRUNKE | AW | 66958 | 09 FXDF | 2010-06-17 00:00:00 | JZ | 2.7 | 6/17/201010:15 AM |  |  | FACTORY 5K SERVICE
ASSIGNED | BURKE | KT | 62423 | 00 FLHTCUI | WAITER |  | 1.5 | 6/9/201011:10 AM |  |  | R+R REAR WHEEL TO REPLACE WHEEL AND BEARINGS
ASSIGNED | CULBERTSON | KT | 66829 | 09 FLHTCUTG | WAITER | DH | 2.9 | 6/16/20108:07 AM |  |  | DELUXE 5K, 08-LATER TOURING (REDLINE), FRONT LEFT TURN SIGNAL NOT FLASHING, TRUNK DOOR SEAL NOT SEALING
ASSIGNED | DEAN | AW | 66965 | 03 XB9R | WAITER | DH | 0.5 | 6/17/20101:26 PM
ASSIGNED | DECKER | KT | 66433 | 07 XB12S | 2010-05-24 00:00:00 | DH | 0 | 5/24/20107:59 AM |  |  | BIKE SPUTTERS
ASSIGNED | DEGRAFFENREID | AW | 66543 | 05 FLHRC | WAITER | RA | 0.5 | 6/16/20109:46 AM |  |  | INSTALL LOAD EQUALIZER
ASSIGNED | DRONSO | AW | 66312 | 01 FLHTCUI | 2010-06-11 00:00:00 | BS | WARR | 6/11/20103:22 PM |  |  | DIAGNOSE HARD SHIFTING CONCERN
ASSIGNED | FREDLUND | 11705 | 66446 | 10 FLHX | 2010-06-17 00:00:00 | JZ | 10.25 | 6/16/20108:57 AM |  | YES | INSTALL ACCESSORIES
ASSIGNED | FROST | PK | 66713 | 09 XL1200L | 2010-06-08 00:00:00 | BF | 1 | 6/8/20109:15 AM |  |  | OIL LEAK ON RIGHT SIDE OF ENGINE
ASSIGNED | GALL | AW | 66954 | 00 FLHTCI | WAITER | DB | 1 | 6/18/20108:08 AM |  |  | SET UP REAR SUSPENSION
ASSIGNED | GRAEVEN | AW | 66646 | 02 FLHTC | 2010-06-02 00:00:00 | RG | 1 |  |  |  | DIAGNOSE OIL LEAKING FROM TRANSMISSION AREA
ASSIGNED | HENTGES | AW | 66533 | 94 FXDL | 2010-06-01 00:00:00 | BF | 1 | 5/29/201012:51 PM |  |  | BIKE WON'T START
ASSIGNED | HONKAMP | KT | 66955 | 03 FLHTC | 2010-06-17 00:00:00 | JZ | 2.05 | 6/17/20101:49 PM |  |  | SPRING TUNE UP, REPLACE BATTERY
ASSIGNED | [NAME] | KT | 66732 | 10 FLSTC | 2010-06-05 00:00:00 | DB | WARR | 6/7/201011:34 AM |  |  | WHEEL ALIGNMENT OFF, CHECK RIGHT SADDLEBAG SHAPE, ADJUST REAR SHOCKS TWO SETTINGS HIGHER,
ASSIGNED | KLATT | AW | 66893 | 06 FLHTC | 2010-06-18 00:00:00 | RG | 1 | 6/18/20109:43 AM |  |  | DIAGNOSE/REPAIR EXCESSIVE ENGINE VIBRATION
ASSIGNED | LALONDE | PK | 66988 | 10 FLHTCUI | WAITER | BS | 1 | 6/18/201010:03 AM |  |  | ADJUST CLUTCH, ADJUST HANDLE BARS UP, PUT LOWER BOLTS IN FARING
ASSIGNED | LINDQUIST | AW | 66203 | 07 TMCC | 2010-05-28 00:00:00 | RG | 14+ | 5/14/201010:18 AM |  |  | INST PERFORMANCE UPGRADES,REP DAMAGE,REMOVE FRONT PULLY COVER…..
ASSIGNED | MEINEN | KT | 66720 | 99 XL1200 | 2010-06-11 00:00:00 | RA | 5.5 | 6/11/20109:20 AM |  |  | REPLACE FRONT/REAR ROCKER BOX GASKETS, CHANGE IGNITION AND REPAIR INDICATOR LIGHTS,
ASSIGNED | MORITZ | KT | 66426 | 09 FLTRSE3 | 2010-05-26 00:00:00 | TP | 6.4 | 5/29/20107:51 AM |  |  | RECALL 0141,DELUXE 5K SERVICE,RECALL FOR BLADE WHEELS,ENGINE NOISE,INSTALL LIGHTING
ASSIGNED | MURRAY | AW | 66933 | 07 FLHRC | 2010-06-17 00:00:00 | BF | 3.65 | 6/16/20104:00 PM |  |  | DELUXE 5K (SYN3/CHROME), INSTALL PASSENGER FOOTBOARD COVERS
ASSIGNED | MUTH | PK | 66883 | 08 FLHTCUI | WAITER | HB | 4 | 6/12/201010:12 AM |  |  | INSPECT ENGINE KNOCKING NOISE
ASSIGNED | NELSON | PK | 66910 | 09 1125R | 2010-06-16 00:00:00 | DH | 1.5 | 6/15/20109:58 AM |  |  | CHARGING HARNESS RECALL, FACOTRY 620 MILE SERVICE, 08-LATER 1125, RACE WIRE THE OIL PLUG AND POS FILTER, REPLACE ANTIFREEZE WITH WATERWETTER
ASSIGNED | OTTO | AW | 66688 | 07 FLTR/SDCAR | 2010-06-07 00:00:00 | DB | 3 | 6/7/20101:49 PM |  |  | REPLACE FRONT & REAR TIRES/ CHANGE OIL/ REPLACE Y-PIPE
ASSIGNED | PAULUS | PK | 66905 | 02 FLHRI | 2010-06-17 00:00:00 | JZ | 2.1 | 6/17/20108:18 AM |  |  | TIMING COVER STRIPPED OUT
ASSIGNED | RETTIE | KT | 66767 | 08 FLSTN | 2010-06-09 00:00:00 | RG | RS |  |  |  | LOW FUEL LIGHT COMES ON WHEN FILLING TO 3/4
ASSIGNED | SADZEWSKI | PK | 66979 | 96 XL883C | 2010-06-18 00:00:00 | RA | 3 | 6/18/20109:43 AM |  |  | DELUXE 5K, 00-LATER XL
ASSIGNED | SCHLIDT | AW | 66627 | 96 FLHTCUI | 2010-06-02 00:00:00 | RA | 2 | 6/2/20103:57 PM |  |  | SPEEDOMETER INOP - ADVISE, ORDER SET OF KEYS, LISTEN FOR EXCESSIVE WHINE IN ENGINE, DIAGNOSE CAM NOISE
ASSIGNED | SUMINSKI | AW | 66938 | 08 VRSCDX | 2010-06-22 00:00:00 | TF | 1.9 | 6/16/20104:34 PM |  |  | FACTORY FK, VRSC
ASSIGNED | TS CUSTOMS | KT | 66932 | 03 FLHT | 2010-06-16 00:00:00 | BS | 6.5 | 6/16/201010:11 AM |  |  | MOUNT REW REAR WHEEL AND PULLEY, SWAP BELT, SET FRONT WHEEL SPACING AND REPLCE MISSING BOLTS ON ROTORS,
ASSIGNED | VARNEY | AW | 66940 | 04 FLHTCSE | CWF | RG | 13.5 | 6/17/20102:41 PM |  | YES | INSTALL 120 UPGRADE KIT
ASSIGNED | WAITE | AW | 66948 | 05 FLHTCSEI | WAITER | RA | RS | 6/16/20104:10 PM |  |  | HOWL ON DECEL
ASSIGNED | WALCZAK | AW | 66888 | 06 VRSCSE | 2010-06-15 00:00:00 | RA | RS | 6/15/20108:58 AM |  |  | [NAME] AT STEADY SPEEDS, NOISE FROM REAR OF BIKE
ASSIGNED | WARRANTY | PK | 66911 | 00 FLHTCUI | 2010-06-15 00:00:00 | RG | 1 | 6/15/20108:12 AM |  |  | RADIO DOES NOT WORK
ASSIGNED | WEGNER | KT | 66968 | 99 FLHR | EXP | JZ | 0.5 | 6/17/20101:49 PM |  |  | OIL AND FILTER CHANGE
ASSIGNED | WOOD | KT | 66721 | 99 FLHTCI | 2010-06-09 00:00:00 | DB | 1.5 | 6/9/20109:45 AM |  |  | MISSED BILING FORM THE PREVIOUS REPAIR ORDER, HIGH SPEED WOBBLE, OIL [NAME] AT OIL COOLER, CHECK TUNING OF CARB FOR SETUP
ASSIGNED | WURGLER | AW | 66810 | 03 FLHTCUI | 2010-06-15 00:00:00 | RG | 1 | 6/15/20108:33 AM |  |  | DIAG ELETRICAL PROBLEMS
ASSIGNED | WURGLER | AW | 66811 | 05 FLHTCUI | 2010-06-15 00:00:00 | AC | WARR | 6/15/201010:17 AM |  |  | DIAG/ ADVISE REAR BRAKE PROBLEMS
ASSIGNED | ZIEN | KT | 66926 | 09 FLTR | WAITER | JZ | 0.8 | 6/15/20103:58 PM |  |  | OIL/FILTER (CUSTOMER SUPPLIED OIL), CHANGE TRANS FLUID
[NAME] | PRIOR | AW | 66986 | 09 XB12X | WAITER | DB | 1 |  | 6/18/201010:34 AM |  | REPLACE REAR TIRE
[NAME] | SAFFRAN | PK | 66961 | 03 FLHTC | 2010-06-17 00:00:00 | BS | 3.1 |  | 6/18/201010:00 AM |  | MOUNT/BALANCE FRONT/REAR TIRES, LUBE/ADJUST CLUTCH CABLE/THROTTLE CABLE
HOLD - BIKE NOT HERE, RADIO CAME IN 6/7, CALL CUST TO BRING BIKE BACK | WARRANTY / HEIM | AW | 65939 | 07 FLHX | 2010-06-08 00:00:00 |  | 1.5 |  |  |  | BIKE RUNS POORLY, INSTALL RADIO
HOLD - CONTACT CUST - GET APPROVAL FOR NEW RADIO AND LABOR | KRIEDERMAN | KT | 66717 | 06 FLHXI | WAITER |  | 1 |  |  |  | DISPLAY ON RADIO NOT WORKING
HOLD - CONTACT CUST - KIT IS FOR DIFFERENT YEAR. NEED NEW KIT IF HE WANTS IT INSTALLED | KUTZ | AW | 66947 | 04 XL883 | 2010-06-17 00:00:00 | RA | 3 | 6/16/20104:06 PM |  |  | INSTALL FORWARD CONTROLS (CUST SUPPLIED)
HOLD - DB NEEDS TO DIAGNOSE, POSSIBLY CALL CUST | [NAME] | PK | 66757 | 01 FLHTC | 2010-06-08 00:00:00 | TF | RS |  |  | YES | RECHECK DYNO IS POPPING AND DIES
HOLD - HAS LEAKING SHOCK. ON WILL CALL FOR THU 6/17 | ZORN | AW | 66914 | 10 FLHX | 2010-06-16 00:00:00 | TF | WARR | 6/16/20101:54 PM |  |  | OIL DRIPPING FROM RIGHT REAR OF BIKE, RIGHT FRONT CALIPER DISCOLORED
HOLD - ROBBIE TEST RODE AND HAS DIAGNOSED PROBLEM, SHOULD BE FIXED BY 6/8 | MOURADIAN | AW | 66649 | 08 BIG DOG | 2010-06-04 00:00:00 | ROB | 2.5 |  |  |  | DIAGNOSE/CHECK REAR BRAKE FUNCTION, CHECK FOR RUNABILITY CONCERNS, ADVISE ON CHAIN TENSION, ADJUST AS NECESSARY
HOLD - STILL DIAGNOSING | ROSGA | AW | 66549 | 04 FLTRI | 2010-06-01 00:00:00 | TF | WARR |  |  | YES | C.S. BIKE RUNS POORLY, HARD TO START, ADVISE ON ENGINE NOISE
HOLD - WAITING ON PARTS | HENCSIK | KT | 66630 | 98 XL1200S | 2010-06-02 00:00:00 | DH | 1 | 6/2/20102:50 PM |  |  | DIAGNOSE AND ADVISE RUNABILITY ISSUE
NEEDS DYNO | FLEISNER | PK | 66742 | 08 FLHX | 2010-06-12 00:00:00 | TF | 9 | 6/12/20101:59 PM |  | YES | CHECK OIL LEAK/ DYNO TUNE
NEEDS DYNO | RUDITIS | PK | 66738 | 03 FLHTCUI | 2010-06-11 00:00:00 | TP | 9 | 6/15/20107:58 AM |  | YES | HYDRAULIC [NAME], INSTALL NEW GRIPS, DYNO TUNE
PARTS ORDERED - FENDER MOUNT & CUSTOM WHEEL | RETTIE | KT | 66604 | 05 FLHTCUI | ASAP |  | 4.5 |  |  |  | INSTALL NEW FRONT FENDER, NEW FRONT WHEEL/TIRE, NEW REAR TIRE, PARTS PAINTED BY TS CUSTOMS,
PARTS ORDERED - WAITING ON CRUISE CONTROL | DRUML | PK | 66451 | 01 FLHR |  |  |  |  |  |  | SOUND SYSTEM UPGRADE, INSTALL RIDER SEAT BACK, RUBBER BOOT ON RS SWITCH, INSTALL CRUISE CONTROL, REINSTALL PASSENGER BACKREST ON TOUR PACK
WASHED | PULKKILA | AW | 66974 | 04 FLHRS | 2010-06-22 00:00:00 | RG | 10 | 6/17/20103:56 PM | 6/18/20109:54 AM |  | KNOCKING NOISE FROM THE ENGINE
 | AMUNDSEN | AW | 66972 | 05 FLHTCUI | 2010-06-19 00:00:00 |  | 1 |  |  |  | HESITATION ON ACCELERATION,ENGINE NOISE,FULL DETAIL, ROCKER BOLT COVER
 | BREUER | KT | 66453 | 09 1125R | ASAP |  |  |  |  |  | REPLACE MOTOR
 | BROWN | KT | 66109 | 07 CUSTOM | ASAP |  |  |  |  |  | REPAIR STARTING ISSUE
 | BRUNNER | AW | 66978 | 03 FLSTF | 2010-06-18 00:00:00 |  | 2.5 |  |  |  | FACTORY 5K (SYN3/CHROME)
ASSIGNED | DAHLGREN | KT | 66982 | 10 FXDWG | 2010-06-18 00:00:00 | TP | 2.8 | 6/18/201010:42 AM |  |  | DELUXE 1K, 06-LATER SYNA (STD/BLACK)
 | DEBUHR | PK | 66966 | 03 VRSCA | 2010-06-19 00:00:00 |  | 1 |  |  |  | SHIFTER WILL NOT RETURN BACK
 | ELLIOTT | PK | 66987 | 93 FLHTC | 2010-06-19 00:00:00 |  | 1.6 |  |  |  | MOUNT/BALANCE 2 LOOSE TIRES
 | FROHLING | AW | 66916 | 06 REPLICA | 2010-06-23 00:00:00 |  | 1.5 |  |  |  | DIAGNOSE/ADVISE TRANSMISSINO OIL LEAKS, REPLACE BOOT FOR TRIP RESET SWITCH, REPLACE DIMMER SWITCH NUT, CHECK ALL CRITICAL FASTENERS
 | HAYES | KT | 66737 | 03 FLHRSE | 2010-06-18 00:00:00 |  | 2 |  |  |  | INSTALL/ASSEMBLE DETACHABLE TOUR PACK
 | [NAME] | KT | 66980 | 97 FLHTCUI | ASAP |  |  |  |  |  | DIAGNOSE ELECTRICAL ISSUES
 | LETO | PK | 66976 | 05 FXSTD | 2010-06-18 00:00:00 |  | 1.3 |  |  |  | DELUXE 2500/7500, 00-06 SOFTAIL
 | LOBOTZKE | PK | 66977 | 08 FLHTCU | 2010-06-18 00:00:00 |  | 8.2 |  |  |  | DELUXE 20K, 08-LATER TOURING, OIL LEAK ON RIGHT SIDE OF ENGINE, WIND DEFLECTOR MISSING ON RIGHT SIDE, TOUR PACK LOOSE
 | MILLER | AW | 66990 | 04 BLAST | WAITER |  | 1 |  |  |  | DIAGNOSE/ADVISE NO START
 | MONTGOMERY | PK | 66886 | 00 FXDWG | 2010-06-16 00:00:00 |  | 1 |  |  |  | ENGINE LIGHT ON
 | NEAFIE | PK | 66981 | 05 FLSTC | 2010-06-18 00:00:00 |  | 2.8 |  |  |  | DELUXE 1K, 00-06 SOFTAIL
 | OTT | KT | 66927 | 08 XB12XT | 2010-06-22 00:00:00 |  | WARR |  |  |  | BIKE DIES
 | PETROWSKI | AW | 66537 | 02 FLHTCU | 2010-05-28 00:00:00 |  | 0 |  |  |  | FRONT SPEAKERS CUT OUT, HARD TO FIND NUTRAL, FUEL DOOR FLIPS OPEN
ASSIGNED | PFISTER | AW | 66939 | 01 FLHR | 2010-06-18 00:00:00 | TP | 1 | 6/18/201010:43 AM |  |  | DIAGNOSE BATTERY PROBLEMS
 | PRUCHA | PK | 66963 | 01 FLSTFI | 2010-06-19 00:00:00 |  | 1 |  |  |  | AFTER BATTERY CHANGE CANNOT START BIKE
 | VOGEL | AW | 66950 | 06 FLHTCUI | 2010-06-21 00:00:00 |  | 1.85 |  |  |  | OIL CHANGE, DIAG NETURAL LIGHT,ROUGH RIDE, SEAT STRAP
 | WATSON | KT | 66659 | 09 FXDL | 2010-06-03 00:00:00 |  | 0.1 |  |  |  | BIKE DIFFICULT TO GET INTO NEUTRAL, NOISE WHILE MOVING, RUNNING LIGHTS ON REAR TURN SIGNALS BRIGHT, REPLACE SHIFTER PEG TO MATCH FLOORBOARDS
 | WESOLOWSKI | PK | 66984 | 97 FLHR | 2010-06-18 00:00:00 |  | 1.8 |  |  |  | CHANGE OIL/FILTER (SYN3/CHROME), MOUNT/BALANCE REAR TIRE,
 |  |  |  | 13.9