Spreadsheet: 77122d1277587321-does-this-require-vlookup-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 | BALDWIN | KT | 67106 | 09 1125CR | 2010-06-25 00:00:00 | DH | 0.5 | 6/25/20108:48 AM |  |  | [NAME] IS MAKING NOISE FROM LHS, RE-ROUTE EVAP TUBE
ASSIGNED | BREUER | KT | 66453 | 09 1125R | ASAP | DH |  |  |  |  | REPLACE MOTOR
ASSIGNED | DECKER | KT | 66433 | 07 XB12S | 2010-05-24 00:00:00 | DH | 0 | 5/24/20107:59 AM |  |  | BIKE SPUTTERS
ASSIGNED | FLEISNER | AW | 67090 | 08 FLHX | 2010-06-25 00:00:00 | TF | 1 | 6/25/201010:22 AM |  |  | DIAGNOSE RUNABILITY PROBLEMS
ASSIGNED | FROHLING | AW | 66916 | 06 REPLICA | 2010-06-23 00:00:00 | RA | 1.5 | 6/22/201010:45 AM |  |  | DIAGNOSE/ADVISE TRANSMISSINO OIL LEAKS, REPLACE BOOT FOR TRIP RESET SWITCH, REPLACE DIMMER SWITCH NUT, CHECK ALL CRITICAL FASTENERS
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 | GRAEVEN | AW | 66646 | 02 FLHTC | 2010-06-02 00:00:00 | RG | 1 |  |  |  | DIAGNOSE OIL LEAKING FROM TRANSMISSION AREA
ASSIGNED | [NAME] | AW | 67016 | 97 FLHTCI | 2010-06-29 00:00:00 | ROB | 0.6 | 6/25/20102:43 PM |  |  | REPAIR ENGINE LEAKS, OIL CHANGE, AIR FILTER
ASSIGNED | JONES | AW | 67057 | 05 FLHR | 2010-06-24 00:00:00 | RG | 1 | 6/23/20104:50 PM |  |  | EXCESSIVE NOISE FROM PRIMARY AREA
[NAME] | KUKLINSKI | AW | 67107 | 99 FLHTCUI | 2010-06-26 00:00:00 | TP | 14.5 | 6/25/20101:24 PM | 6/26/20102:40 PM |  | FACOTRY 10K (SYN3)
ASSIGNED | MARTINO | KT | 67087 | 10 FLHTCUSE5 | 2010-06-28 00:00:00 | RA | 4 | 6/25/201012:17 PM |  |  | DELUXE 1K, 08-LATER (SYN3/CHROME), [NAME] LEAKING (WARR), UPPER TOUR PACK LINER SAGGING (WARR), SECURITY CODE NOT ABLE TO BE USED (WARR, 2,2,2,2,2), SET REAR AIR SHOCK PRESSURE TO 35PSI
ASSIGNED | MARTY | AW | 67017 | 03 FLHTI | 2010-06-25 00:00:00 | TF | 2 |  |  |  | REPAIR QUICK SHIFTER, INVESTIGATE OIL VENT LINE REPAIR
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 | MORRISSEY | AW | 67118 | 07 FLHRCI | 2010-06-28 00:00:00 | JZ | 2.1 |  |  |  | FACTORY 20K
ASSIGNED | OBRADOVIC | KT | 66756 | 09 SPITFIRE | 2010-06-07 00:00:00 | AC |  | 6/25/20102:02 PM |  |  | FRAME CRACKED IN THREE PLACES
ASSIGNED | REID | AW | 67113 | 09 FLHTCU | WAITER | JZ | WARR | 6/25/20109:26 AM |  |  | CHECK ENGINE LIGHT ON, CRUISE FLASHING
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 | [NAME] | AW | 67112 | 02 FLHTCUI | 2010-06-25 00:00:00 | TF | 4 | 6/25/20109:35 AM |  | YES | REMAP RACE TUNER FOR EXHAUST CHANGE
ASSIGNED | SUYCOTT | AW | 67068 | 09 FLHTCU | 2010-06-24 00:00:00 | JZ | 1 | 6/23/20102:27 PM |  |  | AUX PORT ON RADIO LOSES RIGHT CHANNEL WHEN MP3 PLAYER IS PLUGGED INTO.  ONLY HAPPENS WHEN RIDING DOWN THE ROAD, WILL NOT HAPPEN WHEN BIKE IS PARKED AND NOT RUNNING
ASSIGNED | UNKE | PK | 67073 | 99 ULTRA | 2010-06-24 00:00:00 | RG | 1 | 6/24/20102:24 PM |  |  | SPEAKER DOESN'T WORK
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
AT SPEED SHOP | 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…..
AT SPEED SHOP | VARNEY | AW | 66940 | 04 FLHTCSE | CWF | RG | 13.5 | 6/17/20102:41 PM |  | YES | INSTALL 120 UPGRADE KIT
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 - 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 - PARTS | SHILTS - WARRANTY | KT | 67008 | 08 XB12XT | 2010-06-22 00:00:00 | DH | 2 |  |  |  | FRONT BRAKE PULSATES, BOLT AND SPACER TO MOUNT ECM MISSING, REAR WHEEL BEARING BAD,
HOLD - PARTS - WAITING ON RADIO AND AMP | WURGLER | AW | 66810 | 03 FLHTCUI | 2010-06-15 00:00:00 | RG | 1 | 6/15/20108:33 AM |  |  | DIAG ELETRICAL PROBLEMS
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 | SLOTKE | KT | 66734 | 97 FLHRI | 2010-06-25 00:00:00 | BF | 19 | 6/23/20108:18 AM |  | YES | INSTALL STAGE 1, INSTALL UPGRADED SUSPENSION, FACTORY 30K, 99-EARLIER BIG TWIN, REPLACE REAR TIRE, INSTALL AUTO PRIMARY CHAIN TENSIONER
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
 | BROWN | KT | 66109 | 07 CUSTOM | ASAP |  |  |  |  |  | REPAIR STARTING ISSUE
 | GAGLIANO | AW | 67054 | 99 FXDWG | 2010-06-30 00:00:00 |  | 6 |  |  |  | DISASSEMBLE/INSPECT/REASSEMBLE WITH NEW GASKETS
 | LOSTETTER | KT | 67120 |  | 2010-06-19 00:00:00 |  | 1 |  |  |  | DIAGNOSE/ADVISE ELECTRICAL ISSUE
 | SHERIDAN | AW | 67117 | 07 FLHTC | 2010-06-29 00:00:00 |  | 2 |  |  |  | EXCESSIVE ENGINE NOISE, BIKE LOSES ALL ELECTRICAL POWER WHEN DRIVING
ASSIGNED | ARENSON | AW | 67126 | 08 1125R | 2010-06-29 00:00:00 | DH | 2.2 |  |  |  | FACTORY 6200 MILE SERVICE, 08-LATER 1125, DIAGNOSE/ADVISE REAR BRAKE INOP
ASSIGNED | ROWINSKI | AW | 67127 | 00 X1 | 2010-06-29 00:00:00 | DH | 1 |  |  |  | DIAGNOSE/ADVISE POOR RUNABILITY
WASHED | OLSON | PK | 67131 | 09 FLHTCUI | WAITER | TP | 1.3 | 6/26/20108:03 AM | 6/26/20109:14 AM |  | MOUNT/BALANCE REAR TIRE, EXCESSIVE ENGINE NOISE,
WASHED | REITER | AW | 67111 | 07 FXSTC | WAITER | RA | 0.8 | 6/26/20108:56 AM | 6/26/20108:57 AM |  | REPLACE FRONT TIRE
 | [NAME] | AW | 67133 | 01 FXD | 2010-06-28 00:00:00 |  | 1 |  |  |  | BATTERY NOT HOLDING A CHARGE
[NAME] | CAMPNELL | PK | 67132 | 97 FLSTC | WAITER | BS | 1 | 6/26/20108:18 AM | 6/26/20109:54 AM |  | RUNS ABOUT 5 MILS THEN DIES, LETS SIT FOR 5 MINUTES RESTARTS
[NAME] | SMITH | PK | 67130 | 07 FLHT | 2010-06-26 00:00:00 | RA | 1.3 | 6/26/20108:59 AM | 6/26/20102:04 PM |  | MOUNT/BALANCE REAR TIRE
[NAME] | SPANNBAUER | AW | 67135 | 01 FLHTCUI | WAITER | RA |  | 6/26/20109:18 AM | 6/26/201010:18 AM |  | FRONT BRAKE PULSATES, BIKE DOES NOT IDLE PROPERLY
ASSIGNED | RADES | PK | 67136 | 03 FXDL | 2010-06-26 00:00:00 | BS | 2.5 | 6/26/201011:50 AM |  |  | FACTORY 1K
[NAME] | HONKAMP | AW | 67138 | 03 FLHTCI | WAITER | BS | 1 |  | 6/26/201011:15 AM |  | ABNORMAL NOISE AT IDLE
[NAME] | MICHALS | PK | 67137 | 05 XL883L | WAITER | BS | 0.5 | 6/26/201011:16 AM | 6/26/201011:49 AM |  | CHANGE OIL/FILTER (SYN3/CHROME)
[NAME] | WILM | AW | 67139 | LOOSE WHEEL | WAITER | RA | 0.5 | 6/26/201011:16 AM | 6/26/201011:32 AM |  | REPLACE TUBE AND RIM STRIP
ASSIGNED | SALES | PK | 67141 | 97 FLSTC | WAITER | BS | 0.5 | 6/26/201011:50 AM |  |  | RAN OUT OF GAS
 | DEIBL | AW | 67140 | 87 FXSTC | 2010-06-30 00:00:00 |  | 2 |  |  |  | BIKE WILL NOT START, SPEEDO DRIVE BROKEN @ FOOT WHEEL, CLUTCH [NAME] (ADVISE)
ASSIGNED | REBUILDERS | AW | 67143 | 02 FLSTC | WAITER | RA | 1 | 6/26/20102:15 PM |  |  | REAR TIRE LOSING AIR, REPLACE TUBE IF NECESSARY