Spreadsheet: 92998d1292508955-pivot-table-problem-year-end-2010_spc
Sheet: Sheet1

lab_id | ZBW | ZWI | Round | BW | WI |  |  |  | BW
3nm52 | -3.0931073671611 | 3.04039679908333 | 5 | 1 | 1
3wstt | N/A | N/A | 5 | N/A | N/A |  |  | lab_id | Round 5 | Round 6
3wwa5 | 0.670974784351972 | 0 | 5 | 0 | 0 |  |  | 3nm52 | 1 | 0
4er66 | 3.03370333512031 | -6.53886009334231 | 5 | 1 | 1 |  |  | 3wstt | N/A
4gcyi | 0.206298573634012 | -0.396942189503631 | 5 | 0 | 0 |  |  | 3wwa5 | 0 | 0
4zabt | 1.50450399480789 | 3.49846329425899 | 5 | 0 | 1 |  |  | 4er66 | 1 | O/L
5d3hh | -1.01328853381888 | 2.93118406605434 | 5 | 0 | 0 |  |  | 4gcyi | 0 | 0
5d3wt | -0.487812278120246 | -0.305293941444469 | 5 | 0 | 0 |  |  | 4zabt | 0 | 0
5ycya | 0.964550390595496 | 0.248032844968442 | 5 | 0 | 0 |  |  | 5d3hh | 0 | 0
6n44r | -0.256983543200278 | -0.264573643815268 | 5 | 0 | 0 |  |  | 5d3wt |  | 0
6vv3s | 0 | 1.12635455855027 | 5 | 0 | 0
7ss2w | 1.0598409367573 | 0.70103602469252 | 5 | 0 | 0
8hk2e | N/A | N/A | 5 | N/A | N/A
9rtsw | 3.16149748496751 | 0.0952328629392431 | 5 | 1 | 0
a22g5 | 1.5565261466668 | -1.71226268131909 | 5 | 0 | 0
a2dd4 | 0.376242781287955 | 1.24824128124011 | 5 | 0 | 0
a3gg5 | -3.83169596138785 | 2.41329870601161 | 5 | 1 | 0
a3jj7 | -0.119635961733691 | -2.41329870601161 | 5 | 0 | 0
a4jk7 | N/A | N/A | 5 | N/A | N/A
a6ku3 | -0.662394487740072 | -0.340202704003882 | 5 | 0 | 0
agk4m | 3.03370333512031 | -1.71226268131909 | 5 | 1 | 0
b3dds | 0.292121972978392 | -5.45369550509494 | 5 | 0 | 1
b3ser | -0.086730838395187 | 0 | 5 | 0 | 0
b5dd3 | N/A | N/A | 5 | N/A | N/A
b6r33 | 0.776591895568165 | 1.39045852969184 | 5 | 0 | 0
c025e | 0.233625379988403 | 0.195162630289668 | 5 | 0 | 0
c2et5 | -0.500641147115592 | 1.53458002528024 | 5 | 0 | 0
c2et7 | -0.234984341086002 | -1.56157293755145 | 5 | 0 | 0
c3asm | -2.06059323675819 | 2.41329870601161 | 5 | 0 | 0
[NAME] | N/A | N/A | 5 | N/A | N/A
ch2q1 | -0.378852811373579 | -3.92378182811674 | 5 | 0 | 1
cl3nw | N/A | N/A | 5 | N/A | N/A
cl6d3 | 0.841926848872501 | -0.401405577005179 | 5 | 0 | 0
co3f5 | N/A | N/A | 5 | N/A | N/A
cs9w1 | 3.07210956753093 | 0.43611078877186 | 5 | 1 | 0
csw87 | 0.93496348408812 | -5.37380266857081 | 5 | 0 | 1
cw7vw | -0.0246953455045226 | 0.458066495175654 | 5 | 0 | 0
d2r6w | 0.670974784351973 | 8.2511227746614 | 5 | 0 | 1
d33er | 2.76329097790956 | 3.40759241535842 | 5 | 0 | 1
d33ww | -1.00518732404852 | 4.1255613873307 | 5 | 0 | 1
d53sw | 2.72283485239942 | -2.07309600200773 | 5 | 0 | 0
dml25 | N/A | N/A | 5 | N/A | N/A
e33ws | 0.064519512074274 | 0.649946209246192 | 5 | 0 | 0
er288 | 3.19116581047957 | -0.186986905165694 | 5 | 1 | 0
f3b6s | N/A | N/A | 5 | N/A | N/A
[NAME] | N/A | N/A | 5 | N/A | N/A
f3s5t | 0.997805443866638 | -2.41329870601161 | 5 | 0 | 0
f44ee | N/A | N/A | 5 | N/A | N/A
fea21 | -0.58700653792583 | -1.61852961099315 | 5 | 0 | 0
fg69z | 4.34634762665958 | 0 | 5 | 1 | 0
g2a44 | -0.153941717200755 | 0.496281245744329 | 5 | 0 | 0
g2tz3 | 0.747800849779034 | 0.567279228204643 | 5 | 0 | 0
g44d2 | 0.0362336769486095 | -0.44108523699655 | 5 | 0 | 0
gsdmi | -0.0246953455045226 | 0.458066495175654 | 5 | 0 | 0
gsdml | N/A | N/A | 5 | N/A | N/A
h2o28 | -0.446466621248358 | 0 | 5 | 0 | 0
h2o42 | -0.446466621248358 | 0 | 5 | 0 | 0
h2ow8 | 3.2655933784058 | 0 | 5 | 1 | 0
h7ss2 | N/A | N/A | 5 | N/A | N/A
hrp23 | -0.616321171643193 | 0 | 5 | 0 | 0
i8s4b | 1.17767333529322 | 1.08516458824737 | 5 | 0 | 0
ky3sn | -0.119635961733691 | -0.242969529516866 | 5 | 0 | 0
m24ws | N/A | N/A | 5 | N/A | N/A
m3sgg | 0.618952632493059 | -3.04039679908333 | 5 | 0 | 1
mi367 | -0.292814490394233 | 0 | 5 | 0 | 0
mi54d | -0.410986212693183 | 0.872573169649109 | 5 | 0 | 0
mrt32 | 0.710302759101086 | -0.290395493228914 | 5 | 0 | 0
n3aa4 | -0.375155265499228 | 1.13714681346438 | 5 | 0 | 0
n4d8j | 0.207194697780974 | 0 | 5 | 0 | 0
n4eew | -0.173810487600925 | -3.94787873129185 | 5 | 0 | 1
pc36y | -0.35152600501919 | 4.1255613873307 | 5 | 0 | 1
pg93w | N/A | N/A | 5 | N/A | N/A
pr23t | -3.83169596138785 | 2.41329870601161 | 5 | 1 | 0
pr5m2 | N/A | N/A | 5 | N/A | N/A
q3ff6 | -1.10822915004805 | -2.23014804136182 | 5 | 0 | 0
r3h77 | 0.15158205630092 | -0.410640531463606 | 5 | 0 | 0
r5cd3 | N/A | N/A | 5 | N/A | N/A
r5gg7 | 0.360106301631091 | 0.360833320688634 | 5 | 0 | 0
rceg3 | -0.531393896445776 | -0.62709809307172 | 5 | 0 | 0
rt588 | -0.384431128357694 | -3.11433473070413 | 5 | 0 | 1
s3ey6 | 7.32582830537992 | -0.203811974106306 | 5 | 1 | 0
s3f5d | 3.3125618235088 | 0.346812284865671 | 5 | 1 | 0
ss3f3 | N/A | N/A | 5 | N/A | N/A
stt4d | 0.670974784351972 | 0 | 5 | 0 | 0
sw4xc | 3.2655933784058 | 0 | 5 | 1 | 0
t55ek | -0.294481633878227 | 0.541457378790997 | 5 | 0 | 0
t55fh | N/A | N/A | 5 | N/A | N/A
t5ee2 | -0.294481633878227 | -0.541457378790997 | 5 | 0 | 0
t9455 | -0.454567831018713 | 1.19437732127636 | 5 | 0 | 0
[NAME] | N/A | N/A | 5 | N/A | N/A
[NAME] | N/A | N/A | 5 | N/A | N/A
ta4ww | 1.57248832346059 | -0.340202704003882 | 5 | 0 | 0
tatc4 | -1.57200923661904 | 1.19437732127636 | 5 | 0 | 0
tc5ac | -0.256983543200278 | -0.264573643815268 | 5 | 0 | 0
u3dd5 | -0.367810671750131 | 0 | 5 | 0 | 0
u6d33 | -0.858224555960441 | 3.04039679908333 | 5 | 0 | 1
v33s8 | -4.39041666418802 | 6.53886009334231 | 5 | 1 | 1
v3s8f | 0.0918463184286642 | -0.851725768460155 | 5 | 0 | 0
v44h6 | -0.375155265499228 | -1.13714681346438 | 5 | 0 | 0
w4ff6 | 2.14815197280547 | 0 | 5 | 0 | 0
wa5hh | N/A | N/A | 5 | N/A | N/A
y55rr | 1.02941983260241 | -0.476408349304082 | 5 | 0 | 0
zpy7c | -0.0576004688430279 | -0.70103602469252 | 5 | 0 | 0
3nm52 | -0.429251477702003 | -1.25830655594466 | 6 | 0 | 0
3wwa5 | 1.37724612355617 | 3.03179003856532 | 6 | 0 | 1
4er66 | O/L | O/L | 6 | O/L | O/L
4gcyi | -0.819093925508855 | -0.976018391213818 | 6 | 0 | 0
4zabt | 1.37724612355617 | -3.03179003856532 | 6 | 0 | 1
5d3hh | 0.0971836414586697 | -0.53625623713024 | 6 | 0 | 0
5d3wt | -0.769840611094795 | 1.25830655594466 | 6 | 0 | 0
5sd9z | 5.24922999819281 | 0.0611751014578535 | 6 | 1 | 0
5ycya | -0.810661115981634 | 0.324144450205261 | 6 | 0 | 0
6n44r | N/A | N/A | 6 | N/A | N/A
6vv3s | -0.553279667249882 | -0.547457135578242 | 6 | 0 | 0
7ss2w | -0.333731786139425 | -0.710849420366419 | 6 | 0 | 0
8hk2e | -0.521049248135106 | -1.33572359382893 | 6 | 0 | 0
9rtsw | 2.52510008148298 | 0 | 6 | 0 | 0
a22g5 | 1.54754069025257 | 2.05577164735151 | 6 | 0 | 0
a3gg5 | O/L | O/L | 6 | O/L | O/L
a3jj7 | 1.94686352701968 | 0.797465091406846 | 6 | 0 | 0
a4jk7 | -1.43796464338642 | 0.976018391213818 | 6 | 0 | 0
a6ku3 | N/A | N/A | 6 | N/A | N/A
agk4m | 1.89421082392423 | -1.0992363549604 | 6 | 0 | 0
b3dds | 0.401497091929379 | -0.8777232781105 | 6 | 0 | 0
b3ser | 0.00217425516226902 | -0.380583277834161 | 6 | 0 | 0
b5dd3 | N/A | N/A | 6 | N/A | N/A
b6r33 | 0.0685779878932274 | 0 | 6 | 0 | 0
c025e | -0.705094844467015 | -2.39055399932335 | 6 | 0 | 0
c2et2 | 1.92507381479799 | 0.108004214656352 | 6 | 0 | 0
c2et5 | -0.738686836640786 | -3.03179003856532 | 6 | 0 | 1
c3asm | -1.43796464338642 | -0.976018391213818 | 6 | 0 | 0
[NAME] | N/A | N/A | 6 | N/A | N/A
ch2q1 | -1.28308800505259 | -3.03179003856532 | 6 | 0 | 1
cl3nw | N/A | N/A | 6 | N/A | N/A
cl6d3 | 0.788765636800158 | 0.340999763755986 | 6 | 0 | 0
co3f5 | -0.329255752797273 | 0.236487238868532 | 6 | 0 | 0
cs9w1 | 2.51743005212634 | -0.8777232781105 | 6 | 0 | 0
csw87 | -0.553279667249882 | 0.547457135578242 | 6 | 0 | 0
cw7vw | -0.00217425516226958 | -0.76261272809137 | 6 | 0 | 0
d2r6w | N/A | N/A | 6 | N/A | N/A
d33ww | 0.0632597677849372 | 0.730685955289166 | 6 | 0 | 0
d53sw | -0.209703596591546 | 0 | 6 | 0 | 0
dml25 | O/L | O/L | 6 | O/L | O/L
e33ws | 1.93248320792251 | -1.07215299626943 | 6 | 0 | 0
er288 | N/A | N/A | 6 | N/A | N/A
f3b6s | N/A | N/A | 6 | N/A | N/A
[NAME] | -0.0705628043491592 | 0.797465091406843 | 6 | 0 | 0
f3s5t | 3.91298193360955 | -1.53375508135584 | 6 | 1 | 0
f44ee | -0.209703596591546 | 0 | 6 | 0 | 0
fea21 | -2.4959311234849 | -0.976018391213818 | 6 | 0 | 0
fg69z | 5.76130707068644 | 0 | 6 | 1 | 0
g2a44 | -0.0658078886735055 | 0.397905868609161 | 6 | 0 | 0
g2tz3 | -1.26767007669003 | 0 | 6 | 0 | 0
g44d2 | -0.928302979582584 | 0.350102677455003 | 6 | 0 | 0
gkw5t | 1.00313952184076 | 0.887652790782715 | 6 | 0 | 0
gsdmi | -0.550292729984338 | 0 | 6 | 0 | 0
gsdml | N/A | N/A | 6 | N/A | N/A
h2o42 | 0.319279643457694 | -3.03179003856532 | 6 | 0 | 1
h2ow8 | 1.68668148249496 | -1.25830655594466 | 6 | 0 | 0
h7ss2 | 0.14659646292674 | 1.20831802951964 | 6 | 0 | 0
hrp23 | -1.60825921008282 | 0 | 6 | 0 | 0
i8s4b | 0.628715002396477 | -1.25830655594466 | 6 | 0 | 0
kmrt3 | 0.0685779878932274 | 0 | 6 | 0 | 0
ky3sn | -0.329255752797273 | 0.236487238868532 | 6 | 0 | 0
m24ws | N/A | N/A | 6 | N/A | N/A
m3sgg | 0.00217425516226902 | 0.380583277834161 | 6 | 0 | 0
m4wc7 | 0.172468821858665 | -1.35660166904798 | 6 | 0 | 0
mi367 | 0.799009569092873 | 2.23432494715848 | 6 | 0 | 0
mi54d | 0.0997317623472375 | 7.83706355975131 | 6 | 0 | 1
mrt32 | N/A | N/A | 6 | N/A | N/A
n3aa4 | -0.248848663929203 | -0.224354225669286 | 6 | 0 | 0
n3ab2 | -0.0658078886735055 | 0.397905868609161 | 6 | 0 | 0
n4d8j | -0.0394090298951502 | -7.03959846834447 | 6 | 0 | 1
pc36y | 0.434191051562321 | -0.143420994832234 | 6 | 0 | 0
pg93w | N/A | N/A | 6 | N/A | N/A
pr23t | 2.43521260365465 | 3.03179003856532 | 6 | 0 | 1
pr5m2 | N/A | N/A | 6 | N/A | N/A
q3ff6 | -3.10532145240221 | 0 | 6 | 1 | 0
r3h77 | -0.099731762347238 | -0.203476150450233 | 6 | 0 | 0
r5gg7 | -0.0333280296162797 | 0.584059428284395 | 6 | 0 | 0
rceg3 | 1.18885201689973 | 0 | 6 | 0 | 0
s3ey6 | 2.31955555650964 | -0.416881813572682 | 6 | 0 | 0
s3f5d | O/L | O/L | 6 | O/L | O/L
s5a22 | O/L | O/L | 6 | O/L | O/L
ss3f3 | -1.82780709119328 | -1.25830655594466 | 6 | 0 | 0
stt4d | -2.35679033124252 | -1.77348348262066 | 6 | 0 | 0
t55ek | 1.44060306087048 | 0.296652540378775 | 6 | 0 | 0
t55fh | N/A | N/A | 6 | N/A | N/A
t5ee2 | 0.786700245831442 | -0.568845679194168 | 6 | 0 | 0
t9455 | -1.25255747399552 | 4.55526556535738 | 6 | 0 | 1
[NAME] | N/A | N/A | 6 | N/A | N/A
[NAME] | N/A | N/A | 6 | N/A | N/A
ta4ww | 0.495655210432961 | -1.0992363549604 | 6 | 0 | 0
tatc4 | 0.129663500515896 | 0.350102677455005 | 6 | 0 | 0
tpg5z | 0.748534218393462 | -0.350102677455003 | 6 | 0 | 0
u3dd5 | -0.099731762347238 | -0.203476150450233 | 6 | 0 | 0
u6d33 | -0.521049248135106 | 1.33572359382893 | 6 | 0 | 0
v33s8 | -0.738686836640786 | -3.03179003856532 | 6 | 0 | 1
v3s8f | N/A | N/A | 6 | N/A | N/A
v44h6 | -0.46839654503966 | -1.03395233027537 | 6 | 0 | 0
w66s2 | N/A | N/A | 6 | N/A | N/A
w89fq | 2.57851556474901 | 1.2278259555655 | 6 | 0 | 0
wa5hh | N/A | N/A | 6 | N/A | N/A
wql15 | N/A | N/A | 6 | N/A | N/A
y55rr | 0.247305364116847 | 0.324144450205261 | 6 | 0 | 0