oba eol pre run in june06a
TRANSCRIPT
Pre Run In / Run In Final Test - FAILS
Pre Run In / Run In & Final Test - FAILS June 2006
Date Model Dispatch ID Test Comments
Morpheus
Tested Root cause Solution
05/06/06 M1 D8297094 Pre Run In Sensor test n sensor unreported
05/06/06 Q16C D8238602 Pre Run In Batt not charge y MLB- Dc-in Misdiag
06/06/06 M1 D8061958 Pre Run In Gigabit ethernet test N FoF MLB Replace MLB
06/06/06 Q16C D8318993 Pre Run In Harddrive Y
Not charging - now HDD
unreported fault
07/06/06 Q16 D8203289 Pre Run In sleep not functional Y Magnet not in correct place Training
07/06/06 M1 R8296433 Pre Run In Firewire fail N
Mlb replaced noise and heat
issue FOF MLB
07/06/06 M6 D8308250 Pre Run In Keyboard not responding N K/B not working replaced FOF K/B
07/06/06 M1 R8275261 Pre Run In Bluetooth fail N
unit came in for HDD
replacement unreported
08/06/2006 M1 D8345727 Final No boot from Battery N Battery replaced unreported
08/06/2006 P99 R8357421 Pre Run In Bluetooth fail Y unit sys freeze mlb unreported
08/06/2006 P72D D8259211 Pre Run In Firewire fail N MLb rea FOF MLB
08/06/2006 Q72A D8309161 Pre Run In Freeze Y Dimm vid mlb replaced FOF MLB
08/06/2006 Q72B D8155804 Pre Run In Freeze y
ODD not reading replaced now
APX unreported
OBA EOL PRE RUN In JUNE06a.xls Page 1 of 151 23/06/2015
APPLE 'Pre RUN IN' QUALITY STATISTICS
PRE RUN IN DATA
MONTH June 2006 RUN IN FINAL TEST
(All items in chart)
DATE QTY Pass FAIL % Pass QTY PASS FAIL QTY PASS FAIL
05/06/06 75 73 2 97.33% 75 75 0 75 75 0
06/06/06 44 42 2 95.45% 44 44 0 44 44 0
07/06/06 58 54 4 93.10% 58 58 0 58 58 0
08/06/06 43 39 4 90.70% 43 43 0 43 42 1
09/06/06 #DIV/0!
12/06/06 #DIV/0!
13/06/06 #DIV/0!
14/06/06 #DIV/0!
15/06/06 #DIV/0!
16/06/06 #DIV/0!
19/06/06 #DIV/0!
20/06/06 #DIV/0!
21/06/06 #DIV/0!
22/06/06 #DIV/0!
23/06/06 #DIV/0!
26/06/06 #DIV/0!
27/06/06 #DIV/0!
28/06/06 #DIV/0!
29/06/06 #DIV/0!
30/06/06 #DIV/0!
03/07/06 #DIV/0!
04/07/06 #DIV/0!
05/07/06 #DIV/0!
06/07/06 #DIV/0!
07/07/06 #DIV/0!
Information Sources:
1) Quantities tested: Travellers (exclude units 'Sent unrepaired').
2) Failure details: Pre Run In, Run In & Final Test daily failure reports
NB. To change the dates, 'un-hide' all the cells, and put a new date in cell A5.
All the other cells will update automatically.
APPLE 'PRE RUN IN TEST' STATISTICS - JUNE 2006
0
10
20
30
40
50
60
70
80
90
100
05/0
6/06
06/0
6/06
07/0
6/06
08/0
6/06
09/0
6/06
12/0
6/06
13/0
6/06
14/0
6/06
15/0
6/06
16/0
6/06
19/0
6/06
20/0
6/06
21/0
6/06
22/0
6/06
23/0
6/06
26/0
6/06
27/0
6/06
28/0
6/06
29/0
6/06
30/0
6/06
Date
QT
Y
0.00%
20.00%
40.00%
60.00%
80.00%
100.00%
PreRunIn FAIL Run In Final % Pass QTY
OBA EOL PRE RUN In JUNE06a.xls Page 3 of 151 23/06/2015
Apple - Daily End Of Line Inspection Results
Rolling EOL For June 2006Don't put a '1' for Out of Warrenty (OOW) Loopers
1
Date Dispatch ID Diag Tech Repair Tech Pass/Fail
Lo
op
er
Lo
op
er
days
NT
F
Lo
oer
CS
Co
de
G3 U
nre
p'd
Mo
rph
eu
s
PH
OE
NIX
PH
OX
. U
SB
ASD Reasons Model
03/06/06
DATA SOURCES
OBA EOL PRE RUN In JUNE06a.xls Page 4 of 151 23/06/2015
Apple - Daily End Of Line Inspection Results
TOT Call Cnr D Apple R Fails LOOPER NTF CS UnR Ms Pho P_U ASD
231 170 61 4 24 5 1 0 31 17 1 8
SUMMARY (fed to Summary page which is printable)
OBA EOL PRE RUN In JUNE06a.xls Page 101 of 151 23/06/2015
APPLE 'END OF LINE' QUALITY STATISTICS
End of Line Data
MONTH June 2006
DATE QTY Pass FAIL % Pass
05/06/06 77 74 3 96.10%
06/06/06 48 47 1 97.92%
07/06/06 60 60 0 100.00%
08/06/06 #DIV/0!
09/06/06 #DIV/0!
12/06/06 #DIV/0!
13/06/06 #DIV/0!
14/06/06 #DIV/0!
15/06/06 #DIV/0!
16/06/06 #DIV/0!
19/06/06 #DIV/0!
20/06/06 #DIV/0!
21/06/06 #DIV/0!
22/06/06 #DIV/0!
23/06/06 #DIV/0!
26/06/06 #DIV/0!
27/06/06 #DIV/0!
28/06/06 #DIV/0!
29/06/06 #DIV/0!
30/06/06 #DIV/0!
03/07/06 #DIV/0!
04/07/06 #DIV/0!
05/07/06 #DIV/0!
06/07/06 #DIV/0!
07/07/06 #DIV/0!
OBA EOL PRE RUN In JUNE06a.xls Page 102 of 151 23/06/2015
APPLE 'END OF LINE' QUALITY STATISTICS
APPLE 'END OF LINE' STATISTICS - June 2006
0
10
20
30
40
50
60
70
80
90
05/0
6/06
06/0
6/06
07/0
6/06
08/0
6/06
09/0
6/06
12/0
6/06
13/0
6/06
14/0
6/06
15/0
6/06
16/0
6/06
19/0
6/06
20/0
6/06
21/0
6/06
22/0
6/06
23/0
6/06
26/0
6/06
27/0
6/06
28/0
6/06
29/0
6/06
30/0
6/06
Date
QT
Y
0%
20%
40%
60%
80%
100%
Pass FAIL % Pass QTY
OBA EOL PRE RUN In JUNE06a.xls Page 103 of 151 23/06/2015
MONTHLY 'OUT OF BOX AUDIT' REPORT
Serial No (Unique
Identifier) Total
Cosmetic
Check
1=Pass
0=Fail
Box
Content
Check
1=Pass
0=Fail
Functional
Test
1=Pass
0=Fail Comments Mo
rph
eu
s
Model Date
37 37 37 37 11
W86150L8VJ0 1 1 1 M1 05/06/06
UV2500WNN4Q 1 1 1 P72B 05/06/06
W86102FSVJ0 1 1 1 M1 05/06/06
W85241G0RG3 1 1 1 Q16B 05/06/06
W850607ARG4 1 1 1 Q16B 05/06/06
UV34830FPHK 1 1 1 Q54 05/06/06
w86124v2vj0 1 1 1 M1 05/06/06
w86092axvj0 1 1 1 M1 05/06/06
w86117m8vj1 1 1 1 M1 05/06/06
4h5316ldse9 1 1 1 Q73B 05/06/06
4h51687frcq 1 1 1 Q72A 05/06/06
W8613KXZVJ0 1 1 1 M1 06/06/06
V73211G7MVZ 1 1 1 1 P84 06/06/06
UV2206WBLQ2 1 1 1 P72 06/06/06
V73192JJMVZ 1 1 1 P84 06/06/06
4H55307JRJ7 1 1 1 1 Q54B 06/06/06
W8511259RJ3 1 1 1 1 Q41B 06/06/06
4H5221Z8RJ7 1 1 1 1 Q54B 06/06/06
UV3190UPPBM 1 1 1 P72C 06/06/06
W8612EVMVJ0 1 1 1 M1 06/06/06
W86141QRVJ3 1 1 1 M1 07/06/06
UV315019PBN 1 1 1 P73C 07/06/06
W861002SSX0 1 1 1 1 Q41C 07/06/06
W8543P8XSWZ 1 1 1 1 Q16C 07/06/06
W8545ARHSX2 1 1 1 Q16C 07/06/06
W860830DVJ2 1 1 1 M1 07/06/06
4H5221G5RJ6 1 1 1 Q54B 07/06/06
UV42909ZPLW 1 1 1 1 Q54A 07/06/06
W86100B8VJ2 1 1 1 M1 07/06/06
W860802AVJ3 1 1 1 M1 08/06/06
4H442GKWPLW 1 1 1 1 Q54A 08/06/06
4H5084LMRCT 1 1 1 1 Q73A 08/06/06
W86192Q3TJ1 1 1 1 M9 08/06/06
V73469BQNRW 1 1 1 1 Q16 08/06/06
W86094KWVJ1 1 1 1 M1 08/06/06
UV441B9WQHV 1 1 1 1 Q73 08/06/06
RM4100F5NRZ 1 1 1 Q16 08/06/06
MONTHLY OBA REPORT June 2006 (Data Source: Out of Box Audit - G:\Apple Quality\Reports\Data\.....)
OBA EOL PRE RUN In JUNE06a.xls Page 104 of 151 23/06/2015
APPLE 'OUT OF BOX' QUALITY STATISTICS
OUT OF BOX DATA
MONTH June 2006
DATE QTY PASS FAILS %Pass
05/06/06 11 11 0 100.00%
06/06/06 9 9 0 100.00%
07/06/06 9 9 0 100.00%
08/06/06 8 8 0 100.00%
09/06/06 #DIV/0!
12/06/06 #DIV/0!
13/06/06 #DIV/0!
14/06/06 #DIV/0!
15/06/06 #DIV/0!
16/06/06 #DIV/0!
19/06/06 #DIV/0!
20/06/06 #DIV/0!
21/06/06 #DIV/0!
22/06/06 #DIV/0!
23/06/06 #DIV/0!
26/06/06 #DIV/0!
27/06/06 #DIV/0!
28/06/06 #DIV/0!
29/06/06 #DIV/0!
30/06/06 #DIV/0!
03/07/06 #DIV/0!
04/07/06 #DIV/0!
05/07/06 #DIV/0!
06/07/06 #DIV/0!
07/07/06 #DIV/0!
OBA EOL PRE RUN In JUNE06a.xls Page 132 of 151 23/06/2015
APPLE 'OUT OF BOX' QUALITY STATISTICS
APPLE 'OUT OF BOX AUDIT' (OBA) STATISTICS - June 2006
0
2
4
6
8
10
12
05/0
6/06
06/0
6/06
07/0
6/06
08/0
6/06
09/0
6/06
12/0
6/06
13/0
6/06
14/0
6/06
15/0
6/06
16/0
6/06
19/0
6/06
20/0
6/06
21/0
6/06
22/0
6/06
23/0
6/06
26/0
6/06
27/0
6/06
28/0
6/06
29/0
6/06
30/0
6/06
DATE
QU
AN
TIT
Y
0%
20%
40%
60%
80%
100%
120%
Perc
en
tag
e P
assed
PASS FAILS %Pass QTY
OBA EOL PRE RUN In JUNE06a.xls Page 133 of 151 23/06/2015
Apple Quality - Report Summary
Daily / Monthly Statistical Summary for Apple LOOPER Report - June 2006
Date Pre
-Ru
n-I
n
QT
Y
Pre
-Ru
n-I
n
Pass
Pre
-Ru
n-I
n
Fail
Ru
n-I
n P
ass
Ru
n-I
n F
ail
Fin
al
test
passed
Fin
al
test
fail
ed
En
d o
f L
ine
QT
Y
En
d o
f L
ine
Pass
En
d o
f L
ine
Fail
s
OB
A p
assed
OB
A F
ail
ed
Gro
ss
Lo
op
ers
Sh
ipp
ed
Net
Lo
op
ers
Sh
ipp
ed
NT
F S
hip
ped
Lo
op
ers
wit
h
CS
Co
de
Call
Cen
ter
Ap
ple
Sto
re
To
tal
Receiv
ed
(Lin
e I
nfe
ed
)
To
tal
Sh
ipp
ed
(Dis
patc
h)
05/06/06 75 73 2 75 0 75 0 77 74 3 11 0 8 3 2 1 55 22 42 74
06/06/06 44 42 2 44 0 44 0 48 47 1 9 0 7 4 0 0 31 17 44 42
07/06/06 58 54 4 58 0 58 0 60 60 0 9 0 4 2 3 0 46 14 33 63
08/06/06 43 39 4 43 0 42 1 46 0 0 8 0 5 2 0 0 38 8 48 43
09/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
12/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
14/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
23/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
26/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
27/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
28/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
29/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
30/06/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
03/07/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
04/07/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
05/07/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
06/07/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
07/07/06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Subtotals For CLS Looper report (These column formulas need to be updated each month so the weeks are calculated correctly)
Wk.1 220 208 12 220 0 219 1 231 181 4 37 0 24 11 5 1 170 61 167 222
Wk.2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wk.3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wk.4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Wk.5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Totals
(Month) 220 208 12 220 0 219 1 231 181 4 37 0 24 11 5 1 170 61 167 222
NB. THIS REPORT IS STRUCTURED FOR WEEKLY REPORTING WITH A TOTAL ABOVE FOR THE MONTH FOR EACH HEADING.
OBA EOL PRE RUN In JUNE06a.xls Page 134 of 151 23/06/2015
Apple Quality - Report Summary
INFORMATION SOURCES:
STATISTICS SOURCE
Pre Run In Data Pre Run In - Line Record sheet
Pre Run In statistics Travellers
End Of Line (EOL) Data End Of Line (EOL) Log Sheet
End Of Line (EOL) StatisticsEnd Of Line (EOL) Log Sheet
Out Of Box Audit (OBA) StatisticsOBA Record Sheet
Other Reports:
OBA Weekly Statistics OBA Record Sheet
CLS Looper Report (Weekly)All of the above reports
Morpheus Testing as a % for June 2006
0
5
10
15
20
25
30
35
40
45
50
55
60
65
70
75
80
85
90
95
100
05/0
6/06
06/0
6/06
07/0
6/06
08/0
6/06
09/0
6/06
12/0
6/06
13/0
6/06
14/0
6/06
15/0
6/06
16/0
6/06
19/0
6/06
20/0
6/06
21/0
6/06
22/0
6/06
23/0
6/06
26/0
6/06
27/0
6/06
28/0
6/06
29/0
6/06
30/0
6/06
03/0
7/06
04/0
7/06
05/0
7/06
DATE
QT
Y
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
110%
Perc
en
tag
e T
este
d w
ith
Mo
rph
eu
s
Shipped Morpheus Cashmere Infeed % Morph.
OBA EOL PRE RUN In JUNE06a.xls Page 135 of 151 23/06/2015
Apple Quality - Report Summary
Breakdown of testing June 2006 Breakdown of units not tested on Morpheus THIS TABLE IS FILLED IN AUTOMATICALLY - NO MANUAL I/P THIS TABLE IS FILLED IN AUTOMATICALLY - NO MANUAL I/P
Date To
tal
Un
its
teste
d
Un
rep
air
ed
/
Un
teste
d
G3's
Cash
mere
testa
ble
G3's
Cash
mere
Un
rep
air
ed
G3's
Cash
mere
teste
d
Testa
ble
M1,
M9,
M42
Un
rep
air
ed
M1,
M9,
M42
Ph
on
ix
% P
ho
en
ix
Teste
d
Ph
oen
ix U
SB
AS
D
Un
its
Testa
ble
by
Mo
rph
eu
s
Mo
rph
eu
s
Testa
ble
bu
t
Un
rep
air
ed
Mo
rph
eu
s
Teste
d
% M
orp
heu
s
Teste
d
Rem
ain
ing
un
its A
MT
teste
d
Late
Deli
very
Test
4p
m
AM
T
<2G
B
>1 P
art
itio
n
Wil
l n
ot
Defr
ag
Invali
d
Part
itio
n
No
Do
wn
/
Lo
ad
Mo
rph
.
Mo
rph
eu
s
Lo
ad
ing
Fail
ure
To
tal
05/06/06 77 2 9 0 9 15 0 13 87% 0 2 52 2 43 86% 7 6 0 1 7
06/06/06 48 4 4 0 4 8 0 6 75% 0 2 36 4 28 88% 4 3 0 1 4
07/06/06 60 2 2 0 2 20 0 17 85% 1 2 38 2 30 83% 6 1 3 2 6
08/06/06 46 3 2 0 2 7 0 5 71% 0 2 36 3 31 94% 2 0 1 1 2
09/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
12/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
13/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
14/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
15/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
16/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
19/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
20/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
21/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
22/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
23/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
26/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
27/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
28/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
29/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
30/06/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
03/07/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
04/07/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
05/07/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
06/07/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
07/07/06 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0
Subtotals for each week
Wk.1 231 11 17 0 17 50 0 41 82% 1 8 162 11 132 81% 19 0 10 0 4 5 0 19
Wk.2 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0
Wk.3 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0
Wk.4 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0
Wk.5 0 0 0 0 0 0 0 0 #DIV/0! 0 0 0 0 0 #DIV/0! 0 0 0 0 0 0 0 0
Totals
(Month) 231 11 17 0 17 50 0 41 82% 1 8 162 11 132 81% 19 0 10 0 4 5 0 19
OBA EOL PRE RUN In JUNE06a.xls Page 136 of 151 23/06/2015
Apple Quality - Report Summary
Distribution of Test software / Percentage Morpheus Vs Testable by Morpheus - June 2006
74
62
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9
42
2
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
43
2830
31
0 0 0 0 0 0 0 0 0 0 0 0 0 0 00 0%0%0%0%0%0%0%0%0%
0%0%0%0%0% 0%0%
94%83%
88%
86%
0
5
10
15
20
25
30
35
40
45
50
55
60
65
70
75
80
05/06/06 06/06/06 07/06/06 08/06/06 09/06/06 12/06/06 13/06/06 14/06/06 15/06/06 16/06/06 19/06/06 20/06/06 21/06/06 22/06/06 23/06/06 26/06/06 27/06/06 28/06/06 29/06/06 30/06/06
Date of Testing
Quantity
of Lapto
p's
Teste
d
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
110%
Tota
l m
inus C
ashm
ere
giv
ing the %
of M
orp
heus
teste
d
AMT Cashmere Morpheus PhoenixPhoenix USB ASD %Morpheus
OBA EOL PRE RUN In JUNE06a.xls Page 137 of 151 23/06/2015
Celestica Apple Test Yield for Week 1
05/06/06 06/06/06 07/06/06 08/06/06 09/06/06 10/06/06 11/06/06
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week to
Date
Pre Test Passed 73 42 54 39 0 0 0 208
Pre Test Failed 2 2 4 4 0 0 0 12
Yield 97% 95% 93% 91% #DIV/0! #DIV/0! #DIV/0! 95%
Run In Passed 75 44 58 43 0 0 0 220
Run In Failed 0 0 0 0 0 0 0 0
Yield 100% 100% 100% 100% #DIV/0! #DIV/0! #DIV/0! 100%
Final Test Passed 75 44 58 42 0 0 0 219
Final Test Failed 0 0 0 1 0 0 0 1
Yield 100% 100% 100% 98% #DIV/0! #DIV/0! #DIV/0! 100%
EOL Passsed 74 47 60 0 0 0 0 181
Eol Failed 3 1 0 0 0 0 0 4
Yield 96% 98% 100% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 98%
Cumulative
Process
Yield 93.54% 93.47% 93.10% #DIV/0! #DIV/0! #DIV/0! #DIV/0! 92.08%
OBA
Passed 11 9 9 8 0 0 0 37
Failed 0 0 0 0 0 0 0 0
Yield 100% 100% 100% 100% #DIV/0! #DIV/0! #DIV/0! 100%
NTF Data
Total shipped 74 42 63 43 0 0 0 222
No. of NTF 2 0 3 0 0 0 0 5
Yield 2.70% 0.00% 4.76% 0.00% #DIV/0! #DIV/0! #DIV/0! 2%
Loopers Data
Total received 42 44 33 48 0 0 0 167
No. of Net loopers 3 4 2 2 0 0 0 11
Yield 7.14% 9.09% 6.06% 4.17% #DIV/0! #DIV/0! #DIV/0! 6.6%
Looper Data Percentage
Total Net loopers 3 4 2 2 0 0 0 11 0%
Workmanship 0 0%
Same Symptom 0 0%
Diff symptom 0 0%
NTF 0 0%
Looper Root Cause
Same Module
Different Module
OBA EOL PRE RUN In JUNE06a.xls 23/06/2015
Celestica Apple Test Yield for Week 2
12/06/06 13/06/06 14/06/06 15/06/06 16/06/06 17/06/06 18/06/06
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week to
Date
Pre Test Passed 0 0 0 0 0 0 0 0
Pre Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Run In Passed 0 0 0 0 0 0 0 0
Run In Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Final Test Passed 0 0 0 0 0 0 0 0
Final Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
EOL Passsed 0 43 0 0 0 0 0 43
Eol Failed 0 1 0 0 0 0 0 1
Yield #DIV/0! 98% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 98%
Cumulative
Process
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
OBA
Passed 0 0 0 0 0 0 0 0
Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
NTF Data
Total shipped 0 0 0 0 0 0 0 0
No. of NTF 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Loopers Data
Total received 0 0 0 0 0 0 0 0
No. of Net loopers 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Looper Data Percentage
Total Net loopers 0 0 0 0 0 0 0 0 #DIV/0!
Workmanship 0 #DIV/0!
Same Symptom 0 #DIV/0!
Diff symptom 0 #DIV/0!
NTF 0 #DIV/0!
Looper Root Cause
Same Module
Different Module
OBA EOL PRE RUN In JUNE06a.xls 23/06/2015
Celestica Apple Test Yield for Week 3
19/06/06 20/06/06 21/06/06 22/06/06 23/06/06 24/06/06 25/06/06
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week to
Date
Pre Test Passed 0 0 0 0 0 0 0 0
Pre Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Run In Passed 0 0 0 0 0 0 0 0
Run In Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Final Test Passed 0 0 0 0 0 0 0 0
Final Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
EOL Passsed 0 0 0 0 0 0 0 0
Eol Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Cumulative
Process
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
OBA
Passed 0 0 0 0 0 0 0 0
Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
NTF Data
Total shipped 0 0 0 0 0 0 0 0
No. of NTF 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Loopers Data
Total received 0 0 0 0 0 0 0 0
No. of Net loopers 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Looper Data Percentage
Total Net loopers 0 0 0 0 0 0 0 0 #DIV/0!
Workmanship 0 #DIV/0!
Same Symptom 0 #DIV/0!
Diff symptom 0 #DIV/0!
NTF 0 #DIV/0!
Looper Root Cause
Same Module
Different Module
OBA EOL PRE RUN In JUNE06a.xls 23/06/2015
Celestica Apple Test Yield for Week 4
26/06/06 27/06/06 28/06/06 29/06/06 30/06/06 01/07/06 02/07/06
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week to
Date
Pre Test Passed 0 0 0 0 0 0 0 0
Pre Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Run In Passed 0 0 0 0 0 0 0 0
Run In Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Final Test Passed 0 0 0 0 0 0 0 0
Final Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
EOL Passsed 0 0 0 0 0 0 0 0
Eol Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Cumulative
Process
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
OBA
Passed 2 0 0 0 0 0 0 2
Failed 0 0 0 0 0 0 0 0
Yield 100% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 100%
NTF Data
Total shipped 0 0 0 0 0 0 0 0
No. of NTF 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
links to be updated
Loopers Data
Total received 0 0 0 0 0 0 0 0
No. of Net loopers 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Looper Data Percentage
Total Net loopers 0 0 0 0 0 0 0 0 #DIV/0!
Workmanship 0 #DIV/0!
Same Symptom 0 #DIV/0!
Diff symptom 0 #DIV/0!
NTF 0 #DIV/0!
Looper Root Cause
Same Module
Different Module
OBA EOL PRE RUN In JUNE06a.xls 23/06/2015
Celestica Apple Test Yield for Week 5
03/07/06 04/07/06 05/07/06 06/07/06 07/07/06 08/07/06 09/07/06
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week to
Date
Pre Test Passed 0 0 0 0 0 0 0 0
Pre Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Run In Passed 0 0 0 0 0 0 0 0
Run In Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Final Test Passed 0 0 0 0 0 0 0 0
Final Test Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
EOL Passsed 0 0 0 0 0 0 0 0
Eol Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Cumulative
Process
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
OBA
Passed 0 0 0 0 0 0 0 0
Failed 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
NTF Data
Total shipped 0 0 0 0 0 0 0 0
No. of NTF 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
links to be updated
Loopers Data
Total received 0 0 0 0 0 0 0 0
No. of Net loopers 0 0 0 0 0 0 0 0
Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Looper Data Percentage
Total Net loopers 0 0 0 0 0 0 0 0 #DIV/0!
Workmanship 0 #DIV/0!
Same Symptom 0 #DIV/0!
Diff symptom 0 #DIV/0!
NTF 0 0 0 0 0 0 0 0 #DIV/0!
Looper Root Cause
Same Module
Different Module
OBA EOL PRE RUN In JUNE06a.xls 23/06/2015
Celesica Apple Monthly Looper NTF Data
WK1 WK2 WK3 WK4 WK5
NTF Data Yield Yield Yield Yield Yield
Total shipped 222 0 0 0 0
No. of NTF 5 2.25% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
4 Week Rolling 2.25% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Loopers Data Yield Yield Yield Yield
Total received 167 0 0 0 0
No. of Net loopers 11 6.59% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
4 Week Rolling 6.59% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Looper Data (See Individual WK sheet)
Total Net loopers 11 0% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
Workmanship 0% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Same Symptom 0% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Diff symptom 0% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
NTF 0% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
Monthly Cumulative Looper Data
Total Net loopers 11 0%
Workmanship 0 0%
Same Symptom 0 0%
Diff symptom 0 0%
NTF 0 0%
Looper Root Cause
Same Module
Different Module
OBA EOL PRE RUN In JUNE06a.xls Page 143 of 151 23/06/2015
Weekly Looper / NTF Charts: Week 1 Week 2 Week 3 Week 4 Week 5 Month Chart (5 Weeks)
Week 1 Loopers
Date
No of
Loopers Shipped
%Loopers
Shipped Target
05/06/06 3 74 4.05% 5%
06/06/06 4 42 9.52% 5%
07/06/06 2 63 3.17% 5%
08/06/06 2 43 4.65% 5%
09/06/06 0 0 #DIV/0! 5%
Week 1 NTF's
Date
No of
NTF's Shipped
% NTF
Shipped Target
05/06/06 2 74 2.70% 2%
06/06/06 0 42 0.00% 2%
07/06/06 3 63 4.76% 2%
08/06/06 0 43 0.00% 2%
09/06/06 0 0 #DIV/0! 2%
Week 2 Loopers
Date
No of
Loopers Shipped
%Loopers
Shipped Target
12/06/06 0 0 #DIV/0! 5%
13/06/06 0 0 #DIV/0! 5%
14/06/06 0 0 #DIV/0! 5%
15/06/06 0 0 #DIV/0! 5%
16/06/06 0 0 #DIV/0! 5%
Week 2 NTF's
Date
No of
NTF's Shipped
% NTF
Shipped Target
12/06/06 0 0 #DIV/0! 2%
13/06/06 0 0 #DIV/0! 2%
14/06/06 0 0 #DIV/0! 2%
15/06/06 0 0 #DIV/0! 2%
16/06/06 0 0 #DIV/0! 2%
Apple Line - Percentage Loopers for Week 1
0.00%
2.00%
4.00%
6.00%
8.00%
10.00%
12.00%
14.00%
05/06/2006 06/06/2006 07/06/2006 08/06/2006 09/06/2006
% Loopers Shipped Target
Apple Line - Percentage NTF's for Week 1
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
05/06/2006 06/06/2006 07/06/2006 08/06/2006 09/06/2006
Series1 Series2
Apple Line - Percentage Loopers for Week 2
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
12/06/2006 13/06/2006 14/06/2006 15/06/2006 16/06/2006
Series1 Series2
Apple Line - Percentage NTF's for Week 2
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
12/06/2006 13/06/2006 14/06/2006 15/06/2006 16/06/2006
Series1 Series2
Week 3 Loopers
Date
No of
Loopers Shipped
%Loopers
Shipped Target
19/06/06 0 0 #DIV/0! 5%
20/06/06 0 0 #DIV/0! 5%
21/06/06 0 0 #DIV/0! 5%
22/06/06 0 0 #DIV/0! 5%
23/06/06 0 0 #DIV/0! 5%
Week 3 NTF's
Date
No of
NTF's Shipped
% NTF
Shipped Target
19/06/06 0 0 #DIV/0! 2%
20/06/06 0 0 #DIV/0! 2%
21/06/06 0 0 #DIV/0! 2%
22/06/06 0 0 #DIV/0! 2%
23/06/06 0 0 #DIV/0! 2%
Week 4 Loopers
Date
No of
Loopers Shipped
%Loopers
Shipped Target
26/06/06 0 0 #DIV/0! 5%
27/06/06 0 0 #DIV/0! 5%
28/06/06 0 0 #DIV/0! 5%
29/06/06 0 0 #DIV/0! 5%
30/06/06 0 0 #DIV/0! 5%
Week 4 NTF's
Date
No of
NTF's Shipped
% NTF
Shipped Target
26/06/06 0 0 #DIV/0! 2%
27/06/06 0 0 #DIV/0! 2%
28/06/06 0 0 #DIV/0! 2%
29/06/06 0 0 #DIV/0! 2%
30/06/06 0 0 #DIV/0! 2%
Week 5 Loopers
Date
No of
Loopers Shipped
%Loopers
Shipped Target
03/07/06 0 0 #DIV/0! 5%
04/07/06 0 0 #DIV/0! 5%
05/07/06 0 0 #DIV/0! 5%
06/07/06 0 0 #DIV/0! 5%
07/07/06 0 0 #DIV/0! 5%
Week 5 NTF's
Date
No of
NTF's Shipped
% NTF
Shipped Target
03/07/06 0 0 #DIV/0! 2%
04/07/06 0 0 #DIV/0! 2%
05/07/06 0 0 #DIV/0! 2%
06/07/06 0 0 #DIV/0! 2%
07/07/06 0 0 #DIV/0! 2%
Apple Line - Percentage Loopers for Week 3
0.00%
2.00%
4.00%
6.00%
8.00%
10.00%
12.00%
14.00%
19/06/2006 20/06/2006 21/06/2006 22/06/2006 23/06/2006
Series1 Series2
Apple Line - Percentage NTF's for Week 3
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
19/06/2006 20/06/2006 21/06/2006 22/06/2006 23/06/2006
Series1 Series2
Apple Line - Percentage Loopers for Week 4
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
26/06/2006 27/06/2006 28/06/2006 29/06/2006 30/06/2006
Series1 Series2
Apple Line - Percentage NTF's for Week 4
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
26/06/2006 27/06/2006 28/06/2006 29/06/2006 30/06/2006
Series1 Series2
Apple Line - Percentage Loopers for Week 5
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
03/07/2006 04/07/2006 05/07/2006 06/07/2006 07/07/2006
Series1 Series2
Apple Line - Percentage NTF's for Week 5
0.00%
0.50%
1.00%
1.50%
2.00%
2.50%
03/07/2006 04/07/2006 05/07/2006 06/07/2006 07/07/2006
Series1 Series2
Looper Monthly Summary NTF Monthly Summary
Date Looper % Target NTF % Target
05/06/06 4.05% 5% 2.70% 2%
06/06/06 9.52% 5% 0.00% 2%
1 07/06/06 3.17% 5% 4.76% 2%
08/06/06 4.65% 5% 0.00% 2%
09/06/06 #DIV/0! 5% #DIV/0! 2%
12/06/06 #DIV/0! 5% #DIV/0! 2%
13/06/06 #DIV/0! 5% #DIV/0! 2%
2 14/06/06 #DIV/0! 5% #DIV/0! 2%
15/06/06 #DIV/0! 5% #DIV/0! 2%
16/06/06 #DIV/0! 5% #DIV/0! 2%
19/06/06 #DIV/0! 5% #DIV/0! 2%
20/06/06 #DIV/0! 5% #DIV/0! 2%
3 21/06/06 #DIV/0! 5% #DIV/0! 2%
22/06/06 #DIV/0! 5% #DIV/0! 2%
23/06/06 #DIV/0! 5% #DIV/0! 2%
26/06/06 #DIV/0! 5% #DIV/0! 2%
27/06/06 #DIV/0! 5% #DIV/0! 2%
4 28/06/06 #DIV/0! 5% #DIV/0! 2%
29/06/06 #DIV/0! 5% #DIV/0! 2%
30/06/06 #DIV/0! 5% #DIV/0! 2%
03/07/06 #DIV/0! 5% #DIV/0! 2%
04/07/06 #DIV/0! 5% #DIV/0! 2%
5 05/07/06 #DIV/0! 5% #DIV/0! 2%
06/07/06 #DIV/0! 5% #DIV/0! 2%
07/07/06 #DIV/0! 5% #DIV/0! 2%
Looper / NTF Monthly Comparison - May 2006
0.00%
1.00%
2.00%
3.00%
4.00%
5.00%
6.00%
7.00%
8.00%
9.00%
10.00%
05/0
6/06
07/0
6/06
09/0
6/06
11/0
6/06
13/0
6/06
15/0
6/06
17/0
6/06
19/0
6/06
21/0
6/06
23/0
6/06
25/0
6/06
27/0
6/06
29/0
6/06
01/0
7/06
03/0
7/06
05/0
7/06
07/0
7/06
Date
Pe
rce
nta
ge
Looper % Target NTF % Target
Celestica Apple Monthly Test Yield
Tims Report. Yield Yield Yield Yield Yield
Pre test passed 208 0 0 0 0
Pre test Failed 12 95% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
Run in passed 220 0 0 0 0
Run in failed 0 100% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
Final test passed 219 0 0 0 0
Final test failed 1 100% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
End of Line Pass 181 0 0 0 0
End of Line Fail 4 98% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
Cumulative 92.08% #DIV/0! #DIV/0! #DIV/0! #DIV/0!
OBA Yield Yield Yield Yield Yield
Passed 37 0 0 0 0
Failed 0 100% 0 #DIV/0! 0 #DIV/0! 0 #DIV/0! 0 #DIV/0!
Week 5Week 1 Week 2 Week 3 Week 4
OBA EOL PRE RUN In JUNE06a.xls Page 151 of 151 23/06/2015