
UM-B-041
SmartBond Production Line Tool
User Manual
Revision 4.8
02-Nov-2022
CFR0012
133 of 170
© 2022 Renesas Electronics
#
Step
Description
17 Get all values to a
new excel sheet.
Create a new excel sheet. Copy all values created at step 16 from the 10 CSV files to
this new excel sheet. An example of all DUT average values from all 10 CSV files is
given below. Only 2 decimal digits are shown.
DUT PCBA
1
PCBA
2
PCBA
3
PCBA
4
PCBA
5
PCBA
6
PCBA
7
PCBA
8
PCBA
9
PCBA
10
1
-28.50 -28.30 -28.51 -27.56
-29.48 -28.59 -30.09 -29.33 -30.50 -30.13
2
-26.61 -26.07 -27.09 -26.56
-27.99 -27.38 -28.31 -27.64 -28.36 -28.11
3
-26.87 -26.71 -27.65 -26.71
-28.64 -27.84 -29.14 -28.43 -29.54 -29.14
4
-28.41 -27.98 -28.82 -27.87
-29.49 -29.24 -30.10 -29.61 -30.22 -29.36
5
-26.35 -25.69 -26.72 -26.58
-26.74 -26.02 -27.37 -26.75 -27.42 -27.20
6
-22.55 -21.60 -22.68 -21.81
-23.32 -22.33 -23.82 -23.77 -24.45 -24.19
7
-28.98 -28.59 -29.31 -28.49
-29.42 -28.63 -29.84 -28.95 -29.98 -29.73
8
-39.28 -39.06 -39.50 -38.95
-39.53 -39.38 -40.32 -40.11 -40.39 -39.90
9
-27.08 -26.64 -27.68 -27.07
-27.76 -27.28 -28.40 -27.51 -28.89 -28.75
10
-36.61 -35.74 -36.85 -36.05
-37.07 -37.04 -37.96 -37.59 -38.84 -38.03
11
-34.19 -33.57 -35.15 -34.94
-36.09 -35.10 -36.11 -35.23 -36.21 -35.97
12
-26.77 -26.51 -26.90 -26.65
-27.33 -27.11 -27.40 -26.67 -28.03 -27.26
13
-32.01 -31.14 -32.47 -31.73
-33.29 -32.96 -34.01 -33.61 -34.85 -34.17
14
-23.78 -23.31 -24.50 -23.56
-24.51 -24.46 -24.55 -23.60 -25.03 -24.67
15
-24.71 -23.89 -25.39 -24.82
-25.46 -25.37 -26.24 -25.42 -27.09 -26.94
16
-29.17 -28.37 -30.09 -30.07
-30.78 -29.83 -31.27 -30.51 -31.31 -30.56
18 Get the average of
each DUT for all
PCBAs
Average each DUTs results.
DUT
=AVERAGE(B1:K1)
DUT 1
-29.10
DUT 2
-27.41
DUT 3
-28.07
DUT 4
-29.11
DUT 5
-26.68
DUT 6
-23.05
DUT 7
-29.19
DUT 8
-39.64
DUT 9
-27.71
DUT 10
-37.18
DUT 11
-35.26
DUT 12
-27.06
DUT 13
-33.02
DUT 14
-24.20
DUT 15
-25.53
DUT 16
-30.20