Excel Project

profilegdeaquino
mowercsv.zip
Home>Information Systems homework help>Excel Project

Apr.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 41 42 39
No Start 2 2 6
Stripped Head Bolt 3 11 2
Spark Plug Wire Short 1 3 1
Wrong Wheel 1 4 4
Blade Missing 3 5 5
Warning Label Missing 5 8 4
Pull Cord Frayed 4 7 8
Spark Plug Missing 30 29 26
No Oil 1 4 2
Wheel Washer Missing 1 5 4
Motor Locked Up 8 14 19
Throttle Cable Stuck 5 2 8
Air Filter Missing 4 5 5
Wrong Air Filter 6 4 4
Wrong Label 1 1 1
Wrong Cutting Blade 7 3 6
Loose Blade 2 5 2
Pull Cord Missing 7 4 1
Dented Deck 3 5 5
Missing Paint 9 4 5
Paint Defect 3 1 4
Muffler Missing 5 2 7
Wrong Muffler 4 3 6
Miscellaneous 2 1 4

Aug.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 25 24 29
No Start 4 0 12
Stripped Head Bolt 6 2 3
Spark Plug Wire Short 4 3 3
Wrong Wheel 4 4 6
Blade Missing 6 1 3
Warning Label Missing 100 85 123
Pull Cord Frayed 4 2 4
Spark Plug Missing 31 27 34
No Oil 6 2 2
Wheel Washer Missing 1 5 3
Motor Locked Up 10 12 19
Throttle Cable Stuck 3 2 5
Air Filter Missing 6 1 2
Wrong Air Filter 5 2 1
Wrong Label 4 1 2
Wrong Cutting Blade 1 2 3
Loose Blade 1 3 5
Pull Cord Missing 1 5 4
Dented Deck 2 1 5
Missing Paint 1 2 1
Paint Defect 2 1 2
Muffler Missing 3 2 5
Wrong Muffler 4 5 4
Miscellaneous 0 0 0

Dec.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 15 19 24
No Start 6 4 15
Stripped Head Bolt 5 5 4
Spark Plug Wire Short 4 8 5
Wrong Wheel 5 7 6
Blade Missing 2 5 3
Warning Label Missing 1 1 2
Pull Cord Frayed 3 1 4
Spark Plug Missing 19 18 45
No Oil 1 2 3
Wheel Washer Missing 2 3 4
Motor Locked Up 7 12 21
Throttle Cable Stuck 5 2 3
Air Filter Missing 4 1 2
Wrong Air Filter 5 3 3
Wrong Label 6 2 3
Wrong Cutting Blade 2 2 2
Loose Blade 1 2 3
Pull Cord Missing 2 1 7
Dented Deck 1 2 6
Missing Paint 2 2 2
Paint Defect 4 1 1
Muffler Missing 5 3 3
Wrong Muffler 1 1 6
Miscellaneous 2 3 7

Feb.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 20 19 29
No Start 2 2 2
Stripped Head Bolt 4 10 3
Spark Plug Wire Short 2 3 4
Wrong Wheel 1 5 5
Blade Missing 2 1 6
Warning Label Missing 2 1 8
Pull Cord Frayed 3 6 2
Spark Plug Missing 32 19 45
No Oil 2 3 2
Wheel Washer Missing 3 1 5
Motor Locked Up 12 10 19
Throttle Cable Stuck 1 4 4
Air Filter Missing 1 4 2
Wrong Air Filter 2 6 5
Wrong Label 1 2 8
Wrong Cutting Blade 3 1 6
Loose Blade 1 2 3
Pull Cord Missing 2 2 7
Dented Deck 2 3 0
Missing Paint 20 31 42
Paint Defect 3 5 3
Muffler Missing 2 3 4
Wrong Muffler 1 4 5
Miscellaneous 2 2 2

goals.csv

Defect Goal
Noisy 50
No Start 65
Stripped Head Bolt 70
Spark Plug Wire Short 25
Wrong Wheel 100
Blade Missing 45
Warning Label Missing 20
Pull Cord Frayed 65
Spark Plug Missing 180
No Oil 55
Wheel Washer Missing 65
Motor Locked Up 85
Throttle Cable Stuck 75
Air Filter Missing 100
Wrong Air Filter 50
Wrong Label 70
Wrong Cutting Blade 100
Loose Blade 90
Pull Cord Missing 90
Dented Deck 30
Missing Paint 100
Paint Defect 85
Muffler Missing 65
Wrong Muffler 50
Miscellaneous 160

Jan.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 25 24 28
No Start 1 1 5
Stripped Head Bolt 5 12 5
Spark Plug Wire Short 2 2 2
Wrong Wheel 2 2 2
Blade Missing 2 2 2
Warning Label Missing 2 2 2
Pull Cord Frayed 5 5 5
Spark Plug Missing 30 35 36
No Oil 1 2 2
Wheel Washer Missing 4 4 4
Motor Locked Up 10 15 16
Throttle Cable Stuck 5.5 5 5
Air Filter Missing 5 5 5
Wrong Air Filter 5 5 5
Wrong Label 5 5 5
Wrong Cutting Blade 8 8 8
Loose Blade 8 8 6
Pull Cord Missing 8 8 8
Dented Deck 1 0 4
Missing Paint 15 25 31
Paint Defect 1 1 3
Muffler Missing 1 1 2
Wrong Muffler 1 1 3
Miscellaneous 1 1 4

Jul.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 29 22 35
No Start 3 3 5
Stripped Head Bolt 2 8 4
Spark Plug Wire Short 4 4 1
Wrong Wheel 1 4 4
Blade Missing 2 1 5
Warning Label Missing 60 69 79
Pull Cord Frayed 1 6 6
Spark Plug Missing 28 21 34
No Oil 3 5 3
Wheel Washer Missing 1 4 4
Motor Locked Up 6 15 20
Throttle Cable Stuck 3 3 9
Air Filter Missing 1 6 5
Wrong Air Filter 4 1 4
Wrong Label 2 2 1
Wrong Cutting Blade 5 2 6
Loose Blade 2 2 2
Pull Cord Missing 1 1 1
Dented Deck 3 2 4
Missing Paint 5 3 5
Paint Defect 5 4 4
Muffler Missing 1 2 2
Wrong Muffler 4 1 6
Miscellaneous 1 1 4

Jun.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 19 23 29
No Start 0 2 2
Stripped Head Bolt 3 6 1
Spark Plug Wire Short 1 3 5
Wrong Wheel 3 3 3
Blade Missing 1 5 2
Warning Label Missing 0 3 4
Pull Cord Frayed 3 6 4
Spark Plug Missing 31 30 29
No Oil 0 5 3
Wheel Washer Missing 2 8 5
Motor Locked Up 15 6 20
Throttle Cable Stuck 1 9 6
Air Filter Missing 1 1 1
Wrong Air Filter 3 1 2
Wrong Label 2 1 3
Wrong Cutting Blade 1 2 2
Loose Blade 2 3 6
Pull Cord Missing 1 5 2
Dented Deck 0 4 2
Missing Paint 2 2 3
Paint Defect 1 2 1
Muffler Missing 1 2 2
Wrong Muffler 2 3 1
Miscellaneous 3 5 2

Mar.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 19 25 30
No Start 0 2 2
Stripped Head Bolt 3 6 5
Spark Plug Wire Short 1 3 5
Wrong Wheel 3 3 3
Blade Missing 1 5 2
Warning Label Missing 0 3 4
Pull Cord Frayed 3 6 4
Spark Plug Missing 29 28 40
No Oil 0 5 3
Wheel Washer Missing 2 3 5
Motor Locked Up 13 12 15
Throttle Cable Stuck 1 9 6
Air Filter Missing 1 1 1
Wrong Air Filter 3 1 2
Wrong Label 2 1 3
Wrong Cutting Blade 1 2 2
Loose Blade 2 3 6
Pull Cord Missing 1 5 2
Dented Deck 0 4 2
Missing Paint 29 24 35
Paint Defect 1 2 4
Muffler Missing 1 2 2
Wrong Muffler 2 3 4
Miscellaneous 3 5 2

May.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 30 29 31
No Start 4 1 2
Stripped Head Bolt 5 7 3
Spark Plug Wire Short 3 4 4
Wrong Wheel 5 5 5
Blade Missing 4 1 6
Warning Label Missing 2 2 5
Pull Cord Frayed 6 5 2
Spark Plug Missing 31 32 36
No Oil 3 2 2
Wheel Washer Missing 4 6 1
Motor Locked Up 6 15 19
Throttle Cable Stuck 2 2 4
Air Filter Missing 7 1 2
Wrong Air Filter 1 2 5
Wrong Label 1 5 8
Wrong Cutting Blade 1 1 6
Loose Blade 2 4 4
Pull Cord Missing 1 7 7
Dented Deck 1 2 3
Missing Paint 2 1 2
Paint Defect 1 1 3
Muffler Missing 2 4 4
Wrong Muffler 1 2 5
Miscellaneous 1 1 3

Nov.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 18 17 22
No Start 5 9 10
Stripped Head Bolt 5 0 4
Spark Plug Wire Short 3 1 5
Wrong Wheel 3 5 6
Blade Missing 4 6 4
Warning Label Missing 5 4 5
Pull Cord Frayed 2 3 6
Spark Plug Missing 34 31 39
No Oil 1 1 8
Wheel Washer Missing 3 0 1
Motor Locked Up 15 9 16
Throttle Cable Stuck 1 3 8
Air Filter Missing 2 1 9
Wrong Air Filter 3 4 7
Wrong Label 4 1 5
Wrong Cutting Blade 2 2 5
Loose Blade 1 3 5
Pull Cord Missing 0 2 1
Dented Deck 0 1 2
Missing Paint 3 2 3
Paint Defect 0 3 7
Muffler Missing 0 5 8
Wrong Muffler 4 4 4
Miscellaneous 2 1 2

Oct.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 18 22 18
No Start 5 6 6
Stripped Head Bolt 1 7 5
Spark Plug Wire Short 5 5 4
Wrong Wheel 2 5 2
Blade Missing 3 1 2
Warning Label Missing 6 3 2
Pull Cord Frayed 4 4 4
Spark Plug Missing 31 34 39
No Oil 6 1 4
Wheel Washer Missing 2 2 5
Motor Locked Up 10 12 17
Throttle Cable Stuck 1 4 8
Air Filter Missing 1 6 7
Wrong Air Filter 1 4 7
Wrong Label 2 5 5
Wrong Cutting Blade 3 2 3
Loose Blade 4 3 4
Pull Cord Missing 2 1 6
Dented Deck 1 7 1
Missing Paint 1 8 2
Paint Defect 3 9 6
Muffler Missing 2 8 6
Wrong Muffler 1 7 7
Miscellaneous 1 6 3

Production.csv

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 Shift 160,000 155,652 161,248 159,412 156,879 160,587 159,999 160,148 160,547 161,112 161,248 159,597
2 Shift 165,298 166,482 164,248 163,547 165,147 161,254 162,145 162,587 162,352 160,134 158,526 161,001
3 Shift 161,487 162,987 163,478 160,547 159,875 160,748 160,247 160,254 161,587 160,247 159,999 158,997

Sep.csv

Defect 1st Shift 2nd Shift 3rd Shift
Noisy 22 24 25
No Start 4 4 9
Stripped Head Bolt 2 2 3
Spark Plug Wire Short 3 3 4
Wrong Wheel 2 5 5
Blade Missing 2 4 2
Warning Label Missing 86 84 101
Pull Cord Frayed 1 2 5
Spark Plug Missing 31 24 34
No Oil 1 5 1
Wheel Washer Missing 5 6 5
Motor Locked Up 14 8 19
Throttle Cable Stuck 2 2 2
Air Filter Missing 1 4 0
Wrong Air Filter 5 2 2
Wrong Label 1 1 3
Wrong Cutting Blade 2 5 5
Loose Blade 3 2 4
Pull Cord Missing 1 1 6
Dented Deck 2 6 5
Missing Paint 3 2 4
Paint Defect 4 2 5
Muffler Missing 2 1 6
Wrong Muffler 3 5 7
Miscellaneous 0 2 8