Spreadsheet: 155678d1337007529-question-on-how-to-do-this-in-excel-weekly-maintenance-analysis-blank-
Sheet: WEEKLY MAINTENANCE ANALYSIS

Cincinnati  Tool  Steel  Co.
Title: | Weekly Maintenance Analysis |  |  | Document ID: |  | D4.514 |  |  | Page: |  | 1 of 1
Author: | [NAME] |  |  | Approved By: |  | [NAME] |  |  | Approval Date: |  | 2002-07-01 00:00:00
Rev # : | Original |  |  | Rev. [NAME]: |  | July 1, 2002 |  |  | Effective Date: |  | 2002-07-01 00:00:00
WEEKLY [NAME]
 |  |  |  |  | WEEK ENDING:
BUILDING | % | TOTAL # OF REPORT | ACCIDENTAL DAMAGE | ELECTRICAL | MECHANICAL | BEARING FATIGUE | BELT/CHAIN [NAME] | P.M. | OTHER | COMMENTS
1 | #N/A | 0
Bandsaw #1 (Amada HA 400W  --  Serial #4585012) |  | 0
Bandsaw #2 ([NAME]  --  Serial #PA22-106EPC) |  | 0
Bandsaw #3 (Marvel  Sparten 300 Model PA13-3 -- Serial #[NAME]) WAS #2 |  | 0
Bandsaw #4 (Amada HFA 400W  --  Serial #40760070) WAS #5 |  | 0
Bandsaw #5 (Amada HFA 400W  --  Serial #40760067) WAS #6 |  | 0
Bandsaw #6 (Amada HA 400  --  Serial #45600024) WAS #7 |  | 0
Bandsaw #7 (Amada HFA 400W  --  Serial #40760029) WAS #8 |  | 0
Bandsaw #8 (Amada HFA 700 C II  --  Serial #70940042) WAS #9 |  | 0
Bandsaw #9 (Amada HA 250W --  Serial #25350490) WAS #10 |  | 0
Bandsaw #10 (Amada HFA 400W  --  Serial #40760066) WAS #3 |  | 0
Bandsaw #11 (AMADA HA-400  --  SERIAL #40601248) |  | 0
Bandsaw #12 (Amada HFA 700 C II  --  Serial #70940032) |  | 0
Cleaning Station #1 @ BandsawS |  | 0
Cleaning Station #2 @ BandsawS |  | 0
Cleaning Station #3 @ Amada & Mill |  | 0
Cleaning Station #4 @ NC'S |  | 0
Misc. Items |  | 0
NC #1 (Amada HFA 400W  --  Serial #40760015) |  | 0
NC #2 (Amada HFA 250W  --  Serial #2016001) |  | 0
NC #3 (Amada CTB 400  --  Serial #40850047) |  | 0
NC #4 (Amada HFA 400W  --  Serial #40760027) |  | 0
[NAME] |  | 0
Scales |  | 0
U.P.S. Area |  | 0
 |  | 0
2 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 FT. Amada  (Amada VM 1200  --  Serial #12000240) |  | 0
8 FT. Amada  (Amada VM 2500  --  Serial #25000048) |  | 0
[NAME]  (Sundstrand Rigid Mill#36  --  Serial #000284) |  | 0
[NAME]. |  | 0
Platesaw #1  (12 FT. [NAME] (Model 879)  --  Serial #202978) |  | 0
Platesaw #2  (12 FT. [NAME] (Model 849)  --  Serial #202643) |  | 0
Platesaw #3  (12 FT. [NAME] (Model 879)  --  Serial #205468) |  | 0
Platesaw #4   (6 FT.  [NAME] (Model 889)  --  Serial #203954) |  | 0
Scale |  | 0
 |  | 0
3 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | #N/A | 0
#1 Mattison Large Surface Grinder (Serial #13679) |  | 0
#2 Blanchard Rotary Surface Grinder (Serial #9666) |  | 0
#3 Mattison Large Surface Grinder (Serial #19056) |  | 0
#4 Mattison Large Surface Grinder (Serial #17580) |  | 0
#5 Mattison Rotary Grinder (Serial #48-631) |  | 0
#6 Mattison Surface Grinder (Serial #14856) |  | 0
#7 Warner-Swasey Turret Lathe  (Serial #1698384) |  | 0
#8 Warner-Swasey 3A Turret Lathe (Serial #920412) |  | 0
#9 Warner-Swasey 4A [NAME] (Serial #2712123) |  | 0
#10 ACME Hill Rotary Surface Grinder (Serial #316) |  | 0
#11 Okamoto Surface Grinder (Serial #1936) |  | 0
#13 Mattison Large Surface Grinder (Serial #228-41) |  | 0
#14 Thompson Surface Grinder (Serial #7C - 697792) #14 |  | 0
#15 [NAME] (Serial #21648-1) |  | 0
#16 Mattison Surface Grinder (Serial #12119) |  | 0
#17 Mattison Large Surface Grinder (Serial #17581) |  | 0
#18 Blanchard Rotary Surface Grinder (Serial #2382) |  | 0
#19 [NAME] 55 Ton Romco Hydraulic Press (Serial #15149) |  | 0
Crane & Magnet |  | 0
Gisholt Model 5L [NAME] (Serial #996-10) |  | 0
Misc. Items |  | 0
PA Grinder |  | 0
[NAME] |  | 0
 |  | 0
5 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 FT Kearney Trecker  Mill (Serial #86146) |  | 0
8 FT Amada VM 2500  ( Vertical  --  Serial #25000043) |  | 0
12 FT Amada VM 3800  ( Vertical  --  Serial #38000067) |  | 0
Amada HA 250W (Bandsaw  --  Serial # 25350004) |  | 0
Kasto Platesaw (Serial #[PHONE]) |  | 0
[NAME] (Serial #750285) |  | 0
Misc. Items |  | 0
 |  | 0
6 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E.G. | #N/A | 0
Elk-G Forklift  #13 (Caterpiller GC30 - 6EMO2069) |  | 0
Forklift #2  (Caterpiller GC25 - 4EMO4964 ) - FLOATER |  | 0
Forklift #4  (Caterpiller GC25 - 4EMO2694) - FLOATER |  | 0
Forklift #6  (Caterpiller GC25 - 4EM90348) - HUB-TEK |  | 0
Forklift #7  ( Caterpiller T125 - 5MBO2500) - FLOATER (BIG CAT) |  | 0
Forklift #9  (Caterpiller GC30 - AT83C-00498) - CARPENTER |  | 0
Forklift #10  (Caterpiller T60B - 88WO1107) - CLEANING STATION #3 |  | 0
Forklift #21  (Caterpiller GC30 - 6EMO1844) - Bandsaw |  | 0
Forklift #22  (Caterpiller GC55K - AT8800210) - BUILDING #5 LARGE FORK Truck |  | 0
Forklift #23  (Caterpiller GC30) 427 SMALL FORK TURCK |  | 0
Forklift #24 (Caterpillar GC40KS - AT87A00559) - PLATESAW |  | 0
Forklift #25  (Caterpillar C6000 - AT83F02037) - RECEIVING |  | 0
Forklift #26 ([NAME]3557) BUILDING #6 - GREEN |  | 0
Forklift #27 (Caterpillar C6000LP - AT83F20245) - BUILDING #5 |  | 0
Forklift #28 (Caterpillar C6000LP - AT83F20246) - JEFF OEKLER'S TEAM (PLATESAW Forklift) |  | 0
Forklift #29 (Caterpillar GC40K - AT87A00268) - BUILDING #6 |  | 0
Forklift #30 (Caterpillar C6000 - AT83F00222) - BUILDING #2 |  | 0
Forklift #31 (Caterpillar C6000 - AT83F00165) - SHIPPING |  | 0
Forklift #32 (BUILDING #5 IS USING RIGHT NOW) |  | 0
Forklift Boom |  | 0
Magnet |  | 0
[NAME]. |  | 0
Truck #2 (GMC - W-7 - 1995) SOLD |  | 0
Truck #3 (Kenworth - T300 - 2004) |  | 0
Truck #4 (Kenworth - T300 - 2008) |  | 0
Truck #5 (Kenworth - T300 - 2005) |  | 0
Truck #6 (Kenworth - T300 - 2006) |  | 0
Truck #8 (GMC - W-7 - 1996) SOLD |  | 0
Truck #9 ( Freightliner - FL-80 - 1997) SOLD |  | 0
Truck #10 ( International - SERIES 1800 - 1998) |  | 0
Truck #11 |  | 0
Truck #13 ( Freightliner - FL-80 1998)SHUTTLE Truck - SOLD |  | 0
Truck #14 ( Freightliner - FL-80 2000) |  | 0
Truck #15 ( Dodge - B3500 - 2001) |  | 0
Truck #16 (Ford - F350 FLATBED - 1997) WAS #6 |  | 0
Truck #17 (Dodge PICK UP - SERIES 1500 - 1999) WHITE |  | 0
Truck #18 (Chevy PICK UP - SERIES 250 - 1997) RED |  | 0
 |  | 0
 |  | 0
 |  | 0
FORK & COMPANY TruckS | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals: |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Percentages: |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A