Spreadsheet: 77477d1277932355-excel-2003-deleting-rows-shortens-references-from-other-worksheets-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 | BAUER | AW | 67201 | 01 FXDWG | ASAP | BS | RS | 6/30/20108:31 AM |  |  | OIL LEAKING NEAR TRANSMISSION
ASSIGNED | BLACKBURN | AW | 67204 | 08 FLHTCU | 2010-06-30 00:00:00 | BF | 2.9 | 6/30/20102:58 PM |  |  | DELUXE 5K (SYN3/CHROME)
ASSIGNED | BLEARORN | AW | 67202 | 08 FLHTC | 2010-06-30 00:00:00 | RG | 2.9 | 6/30/20102:43 PM |  |  | DELUXE 5K (SYN3/CHROME)
ASSIGNED | BREUER | KT | 66453 | 09 1125R | ASAP | DH |  |  |  |  | REPLACE MOTOR
ASSIGNED | CAREY | PK | 67171 | 04 FLHTCUI | 2010-06-30 00:00:00 | JZ | 9.2 | 6/30/20108:11 AM |  |  | FACTORY 50K SERVICE
ASSIGNED | COPLIN | AW | 67170 | 09 FLHTCU | 2010-06-29 00:00:00 | TF | WARR | 6/29/201010:56 AM |  |  | CS IDLE IS ERRATIC/ STALLS/ HOWEL, CHECK OIL PRESSURE
ASSIGNED | CULBERTSON | KT | 67177 | 09 FLHTCUITG | 2010-07-01 00:00:00 | MH | WARR | 6/29/201010:08 AM |  |  | REPAIR PAINT CHIPS ON BIKE, CHIP IS ON TOP RIGHT SIDE OF TANK, CHIP IS ON RIGHT F NEAR FOOTBOARD, PAINT IS IN TOUR PACK
ASSIGNED | DECKER | KT | 66433 | 07 XB12S | 2010-05-24 00:00:00 | DH | 0 | 5/24/20107:59 AM |  |  | BIKE SPUTTERS
HOLD - WAITING ON PARTS | DEIBL | AW | 67140 | 87 FXSTC | 2010-06-30 00:00:00 | HB | 2 | 6/30/20101:46 PM |  |  | BIKE WILL NOT START, SPEEDO DRIVE BROKEN @ FOOT WHEEL, CLUTCH [NAME] (ADVISE)
ASSIGNED | DEY | KT | 66740 | 09 FLTR | 2010-06-30 00:00:00 | TF | 4.75 | 6/30/20108:31 AM |  | YES | INSTALL STAGE 1, HEADLIGHTS OUT OF AIM
ASSIGNED | DVORAK | KT | 67124 | 08 FLHTCU | 2010-06-29 00:00:00 | RA | 3.1 | 6/28/20103:45 PM |  |  | INSTALL EXHAUST, DELUXE 5K, 08-LATER TOURING (REDLINE OILS),
ASSIGNED | DVORAK | KT | 67125 | 08 FLHTCU | 2010-06-29 00:00:00 | TF | 4 | 6/29/201011:02 AM |  | YES | DYNO TUNE FOR EXHAUST CHANGE
ASSIGNED | FEHERMANN | PK | 67153 | 02 FLSTC | 2010-06-30 00:00:00 | TF | 3.2 | 6/30/20103:49 PM |  |  | SELUXE 5K, 00-06 SOFTAIL, CHECK HANDLEBARS OUT OF ALIGNMENT
ASSIGNED | FLEISNER | AW | 67090 | 08 FLHX | 2010-06-25 00:00:00 | TF | 1 | 6/25/201010:22 AM |  |  | DIAGNOSE RUNABILITY PROBLEMS
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 | GROSSKREUTZ | AW | 67155 | 08 FLHTCU | 2010-06-29 00:00:00 | RA | 2.9 | 6/29/201010:39 AM |  |  | FACTORY 5K (SYN3/CHROME), REPLACE FRONT BRAKE PADS
ASSIGNED | HARTY | PK | 67160 | 96 FLSTF | 2010-06-29 00:00:00 | TF | 1 | 6/29/20108:42 AM |  |  | CHECK NO START
ASSIGNED | HICKLING | PK | 67167 | 01 FLHTC | 2010-06-30 00:00:00 | BF | 7.1 | 6/30/201010:50 AM |  |  | DELUXE 20K SERVICE
ASSIGNED | INTERNAL | 11966 | 67150 | 99 FLHTCU | 2010-07-01 00:00:00 | TP | 5 | 6/28/20104:59 PM |  |  | INSTALL ACCESSORIES
ASSIGNED | KITZMAN | KT | 67208 | 10 FLSTFB | 2010-06-30 00:00:00 | RA | 2.8 | 6/30/201010:21 AM |  |  | DELUXE 5K, 07-LATER (SYN3/BLACK)
HOLD - WAITING ON PARTS | LYMAN | PK | 67197 | 02 FLSTS | 2010-06-30 00:00:00 | HB | 1.3 | 6/30/20101:46 PM |  |  | CHECK ENGINE LIGHT, THROTTLE VERY LOOSE
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 | OBRADOVIC | KT | 66756 | 09 SPITFIRE | 2010-06-07 00:00:00 | AC |  | 6/25/20102:02 PM |  |  | FRAME CRACKED IN THREE PLACES
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 | ROWINSKI | AW | 67127 | 00 X1 | 2010-06-29 00:00:00 | DB | 1 |  |  |  | DIAGNOSE/ADVISE POOR RUNABILITY
ASSIGNED | SENFT | KT | 67026 | 10 FLHTK | 2010-07-09 00:00:00 | BS | 21.2 | 6/28/201010:09 AM |  |  | INSTALL ACCESSORIES, DELUXE 1K, 08-LATER FLH,
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 | THOMAS | AW | 67219 | 07 FLHRC | ASAP | TP | RS | 6/30/20101:20 PM |  |  | INSPECT REAR WHEEL, CUSTOMER FOUND 6 BROKEN SPOKES
ASSIGNED | UNKE | PK | 67073 | 99 ULTRA | 2010-06-24 00:00:00 | RG | 1 | 6/24/20102:24 PM |  |  | SPEAKER DOESN'T WORK
ASSIGNED | WANDSNEIDER | AW | 67147 | 99 FLHTCUI | 2010-06-28 00:00:00 | BS | 2 |  |  |  | KNOCKING NOISE COMING FROM ENGINE
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
[NAME] | BODENBERGER | AW | 67193 | 02 FLHTCUI | 2010-06-30 00:00:00 | MH | 1.3 | 6/30/20101:38 PM | 6/30/20103:35 PM |  | REPLACE REAR TIRE
[NAME] | FECTEAU | AW | 67223 | LOOSE WHEEL | WAITER | MH | 0.5 | 6/30/20102:40 PM | 6/30/20103:10 PM |  | MOUNT/BALANCE TIRE ON LOOSE WHEEL (CUST SUPPLIED)
[NAME] | INTERNAL / EISNER | 11915A1 | 66898 | 04 FXDX | 2010-06-30 00:00:00 | TP | 10.5 | 6/29/20102:10 PM | 6/30/20102:46 PM | YES | INSTALL ACCESSORIES
[NAME] | JONES | AW | 67057 | 05 FLHR | 2010-06-24 00:00:00 | RG | 1 | 6/23/20104:50 PM | 6/30/201011:35 AM |  | EXCESSIVE NOISE FROM PRIMARY AREA
[NAME] | MILLARD | KT | 66445 | 08 FLHTCU | WAITER | RG | WARR | 6/30/20108:11 AM | 6/30/20108:21 AM |  | INSTALL LEFT SADDLE BAG LOCK
[NAME] | SLOTKE | KT | 66734 | 97 FLHRI | 2010-06-25 00:00:00 | BF | 19 | 6/23/20108:18 AM | 6/30/20103:33 PM | YES | INSTALL STAGE 1, INSTALL UPGRADED SUSPENSION, FACTORY 30K, 99-EARLIER BIG TWIN, REPLACE REAR TIRE, INSTALL AUTO PRIMARY CHAIN TENSIONER
[NAME] | SMITHY | AW | 67210 | 04 FXDL | WAITER | JZ | 0.5 | 6/30/201010:04 AM | 6/30/201010:24 AM |  | CHANGE OIL/FILTER (STD/CHROME)
[NAME] | TRIBBEY | KT | 67211 | 10 FLHT | WAITER | BF | 0.5 | 6/30/201010:50 AM | 6/30/201011:22 AM |  | CHANGE OIL/FILTER (STD/CHROME)
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 - SHIFT LEVER, 0838 RECALL | 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
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 - ROB CONTACTING S&S TO SEE IF IS UNDER WARRANTY, ENGINE LOOKS OLDER THAN '08 | [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
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 - TALK TO CUST ABOUT PARTS | INTERNAL / WOODS | 11956 | 66619 | 10 FLHTK | 2010-07-01 00:00:00 | BF | 14.85 |  |  | YES | INSTALL ACCESSORIES
HOLD - WAITING ON CUST | SANDBLOM |  | 67149 | 02 FLHP | 2010-06-28 00:00:00 | RA | 0.8 | 6/28/201011:03 AM |  |  | REPLACE FRONT TIRE - BLACKWALL
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
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 | BALDWIN | KT | 67106 | 09 1125CR | 2010-06-25 00:00:00 | DH | 0.5 | 6/25/20108:48 AM | 6/30/20102:35 PM |  | [NAME] IS MAKING NOISE FROM LHS, RE-ROUTE EVAP TUBE
WASHED | BUTLER | AW | 65557 | 08 XB12X | 2010-07-02 00:00:00 | DH | 2.8 |  | 6/30/201010:53 AM |  | INSTALL RIDER COMFORT KIT, CHANGE ENGINE OIL/FILTER (SYN3/CHROME), INSTALL STOCK WINDSHIELD, ADJUST NECK BEARINGS
WASHED | COPLIN | AW | 67170 | 09 FLHTCU | 2010-06-30 00:00:00 | BF | WARR | 6/30/20109:49 AM | 6/30/20109:50 AM |  | HOWL WHEN TURNING LEFT, CHECK OIL PRESSURE - NEVER EXCEEDS 32 REGARDLESS OF RPM
WASHED | ODBERT | AW | 67209 | 06 FXDWGI | WAITER | RS | 0.5 | 6/30/20109:36 AM | 6/30/201010:13 AM |  | CHANGE OIL/FILTER (STD/CHROME)
WASHED | ROLFSON | KT | 67215 | 07 FLHX | WAITER | RG | 2.9 |  | 6/30/20103:14 PM |  | DELUXE 5K, 07 TOURING (SYN3/CHROME)
WASHED | SKELTON | AW | 67207 | 08 FLHTCU | 2010-06-30 00:00:00 | MK | 0.5 | 6/30/20101:38 PM | 6/30/20102:19 PM |  | CHANGE OIL/FILTER (SYN3/CHROME)
WASHED | STRICKLER | KT | 67206 | 04 XL1200C | WAITER | RA | 2.4 | 6/30/20108:18 AM | 6/30/201010:20 AM |  | REPLACE FRONT/REAR TIRES, CHANGE PRIMARY/TRANS FLUID,
 | BAYER | AW | 67162 | 08 FLHTCUSE3 | 2010-07-06 00:00:00 |  | WARR |  |  |  | LIZARD LIGHTS DAMAGED, BIKE HARD STARTING WHEN COLD, S-BAG LED LIGHTS WON'T TURN ON, OIL COMING OUT OF AIR CLEANER
 | BESCHTA | AW | 67200 | 10 FLHTK | 2010-07-07 00:00:00 |  | 4 |  |  |  | DELUXE 1K, 08-LATER FLH
 | BROWN | KT | 66109 | 07 CUSTOM | ASAP |  |  |  |  |  | REPAIR STARTING ISSUE
 | DAEDA | KT | 67129 | 07 FLHTC | 2010-07-05 00:00:00 |  | 1 |  |  |  | INSTALL RIDER BACKREST
 | FLEISNER | AW | 67216 | 06 FLHX | 2010-07-01 00:00:00 |  | 1 |  |  |  | CHANGE OIL/FILTER (SYN3/CHROME), REPAIR LOOSE LICENSE PLATE MOUNT
 | FOSTICZ | KT | 67224 | 08 1125R | 2010-07-07 00:00:00 | DH |  |  |  |  | DIAGNOSE/REPAIR PROBLEMS, TIGHTEN MIRRORS
 | FRANSISCO | AW | 67221 | 09 1125R | 2010-07-06 00:00:00 | DH | 1.5 |  |  |  | FACTORY 620, 08-LATER 1125, PERFORM CAMPAIGN 0507
 | GAGLIANO | AW | 67054 | 99 FXDWG | 2010-06-30 00:00:00 |  | 6 |  |  |  | DISASSEMBLE/INSPECT/REASSEMBLE WITH NEW GASKETS
 | HEIN | AW | 67205 | 09 FLHTCU | 2010-07-01 00:00:00 |  | 5.3 |  |  |  | DELUXE 10 (SYN3/CHROME), PERFORM RECALL 0141 (FUEL TANK MOUNTS), REPLACE FRONT TIRE (WARR)
 | KLUMB | AW | 67203 | 91 FXR | 2010-07-01 00:00:00 |  | WARR |  |  |  | OIL LEAKING FROM ENGINE
 | MARTIN | PK | 67199 | 91 FLHTC | 2010-07-01 00:00:00 |  | 1 |  |  |  | CHANGE OIL/FILTER (SYN3/CHROME), 30-PT INSPECTION
 | MEISINGER | AW | 67196 | 92 FXSTC | 2010-07-02 00:00:00 |  | 4 |  |  |  | FRONT BRAKE SWITCH INOP, REPLACE LEAKING FORK SEALS
 | SANTNER | AW | 67023 | 08 FLHTCUSE3 | 2010-07-02 00:00:00 |  | 14.5 |  |  | YES | PERFORM CAMPAIGN 0905 - CYLINDER HEADS/GASKETS (WARR), INSTALL PISTONS, CAMS, MUFFLERS, TUNE FOR CHANGES, PERFORM RECALL 0135 (FUEL FILTER SHELL)(WARR), CHROME ON WHEELS PITTING (WARR), LOCK CATCH IN TOUR PACK BROKEN (WARR), DASH IS PEELING (WARR)
 | SHERIDAN | AW | 67117 | 07 FLHTC | 2010-06-29 00:00:00 |  | 2 |  |  |  | EXCESSIVE ENGINE NOISE, BIKE LOSES ALL ELECTRICAL POWER WHEN DRIVING
 | SIVAK | AW | 67164 | 08 FLHTCU | 2010-07-05 00:00:00 |  | WARR |  |  |  | KNOCKING NOISE AT IDLE, INSTALL SADDLE SHIELDS (CUST SUPPLIED)
 | SMITH/ INTERNAL | 11936/ AW | 66606/67168 | 10 FLHTK | 2010-07-01 00:00:00 |  | 5.85 |  |  |  | INST ACCYS/ DELUXE 1K SERICE WARR ISSUES
 | THEYS | AW | 67184 | 02 FLHTC | 2010-07-01 00:00:00 |  | 1.8 |  |  |  | DIAGNOSE/ADVISE ELECTRICAL PROBLEMS, CHANGE OIL/FILTER (STD/CHROME), REPLACE CRACKED HEADLAMP, REMOVE SECURITY SYSTEM