Spreadsheet: 216757d1361881942-conditional-formatting-to-show-biggest-reductions-in-test-data
Sheet: Sheet1

 | 2012-12-07 00:00:00 | 2012-12-14 00:00:00 | 2012-12-21 00:00:00 | 2012-12-28 00:00:00 | 2013-01-04 00:00:00 | 2013-01-11 00:00:00 | 2013-01-18 00:00:00 | 2013-01-25 00:00:00 | 2013-02-01 00:00:00
Company 1 | 0.1685332709886403 | 0.1685019130469814 | 0.1671496084491238 | 0.1671919847250681 | 0.1629297500338253 | 0.160959863500893 | 0.1702598140303745 | 0.1714150609356437 | 0.172027302574973
Company 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 3 | 0 | 0.1423876238545626 | 0.1409933236749845 | 0.1410342638825786 | 0 | 0 | 0.1442041762880968 | 0.1454008775932957 | 0.1460344450677999
Company 4 | 0.1315923667616223 | 0.1266819798851981 | 0.1290563534982877 | 0.1237755103779056 | 0 | 0 | 0 | 0 | 0
Company 5 | 0.110251850068379 | 0.1111205059742603 | 0.1085857855913777 | 0.1086777579511092 | 0.1051614225043543 | 0.1021256854849383 | 0.1121421505256146 | 0.1134402049715961 | 0.1134572950140712
Company 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 7 | 0.1268148125518089 | 0.125594700062085 | 0.1241482854490321 | 0.1380405289683687 | 0.13689540168057 | 0.1346905196127998 | 0.144233597504704 | 0.1454848623266174 | 0.1435268743455963
Company 8 | 0 | 0 | 0 | 0.1830576959674357 | 0.1790992039477833 | 0.1782856797715163 | 0.1739122901279356 | 0 | 0.1995619961559415
Company 9 | 0 | 0.1873101768907522 | 0.1859889114824852 | 0 | 0 | 0.1800070180959011 | 0.189031576577768 | 0.1901655935288849 | 0.1907659741356771
Company 10 | 0.1960306630228442 | 0.1986555944094353 | 0.2010010916555072 | 0.2020183652956044 | 0.2003359400473701 | 0.1883281978227026 | 0.7077639631950192 | 0.1731034457561047 | 0.1753585026752575
Company 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 20 | 0.1675541436988605 | 0.1674992286004092 | 0.1661678376958885 | 0 | 0 | 0 | 0.1692845913265884 | 0.1703965862156772 | 0.1710461745413422
Company 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 23 | 0.1518788768784242 | 0.1518453900246634 | 0.1504664662149185 | 0.1505069549330973 | 0.1462401456548879 | 0.1458272727480646 | 0.1536419094821935 | 0.154825413541836 | 0.1554519940217569
Company 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 25 | 0 | 0.2217933693851115 | 0.2227604754252862 | 0 | 0.2165762411918785 | 0 | 0.223441728466623 | 0 | 0
Company 26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 27 | 0.1171783715214165 | 0 | 0.1157081726924483 | 0.1157503179888489 | 0 | 0.1085109991763313 | 0.1190135378342092 | 0.1202454644455866 | 0.1208976811922
Company 28 | 0.12130451228296 | 0.1232887053858661 | 0.1218548353192316 | 0.1219176162655363 | 0.1174031457776614 | 0.1158024234702962 | 0.1251377305451846 | 0.1263612562634638 | 0.1270211965468507
Company 29 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 30 | 0.07760606299026929 | -0.1456328984346465 | -0.1371773763280088 | 0.08721637429206548 | -0.1475824303633738 | -0.2148755108414411 | -0.08286571669553328 | -0.0650076218287776 | 0.09661429106800498
Company 31 | 0.09416878805130534 | 0.09413126618223254 | 0.09265851115517328 | 0.09270604306068532 | 0 | 0 | 0 | 0 | 0
Company 32 | 0.09075093891010358 | 0.08304229458164447 | 0.08738394828027657 | 0.081528784185951 | 0.07627934710475287 | 0.07839596688139557 | 0.08660345699120447 | 0.09201985250523569 | 0.09430633826232038
Company 33 | 0.0653944657764828 | 0.06620945522701488 | 0.06477824841497998 | 0.06180078905176617 | 0.0561749878515408 | 0.03850154846600483 | 0.06868566682588835 | 0.06613797911357769 | 0.07568445766004539
Company 34 | 0.08856338321424219 | 0.08442741145852445 | 0.02994066376887349 | -0.4341529119627625 | 0.047872499829945 | 0.05739262077862369 | 0.02529369841834954 | 0.0976724547940517 | 0.09736170025564612
Company 35 | 0.09483654811033591 | 0.09480080902152324 | 0.09332914253251101 | 0.09337235441217089 | 0 | 0 | 0 | 0 | 0
Company 36 | 0.09205115196058622 | 0.06416673920509915 | 0.09368265122539647 | 0.05720299851165789 | 0.0664958563031542 | 0.05298684441009646 | 0.08859980874011597 | 0.0905852029736405 | 0.09796476085843989
Company 37 | 0.09603151257351907 | 0.09599352449096722 | 0.0945261557623393 | 0.09457131261633679 | 0.08994481730509814 | 0.08875196642157027 | 0.09790118620455465 | 0 | 0
Company 38 | 0.07593634707751297 | 0.09197604279132714 | 0.08694271821177209 | 0.08622727957926343 | 0.07518501538610856 | 0.06943491660143797 | 0.09145408476332441 | 0.0938796829479104 | 0.0947494348522468
Company 39 | 0.0953003597933766 | 0.09537543895645566 | 0.0841470107394484 | 0.08830682212552173 | 0.08920438083090161 | 0.08733387728336778 | 0.09736330550727276 | 0.09867228363203469 | 0.09931153274929333
Company 40 | 0.09483654811033602 | 0.0948159862320625 | 0.09332914253251101 | 0.09339816073249377 | 0 | 0 | 0 | 0 | 0
Company 41 | 0.0955905835984396 | 0.09555487428164362 | 0.09408443374663675 | 0.09412760962916174 | 0.08949143819797892 | 0.08606647021871684 | 0.09747062554622557 | 0.09873267666924299 | 0.09940084218325351
Company 42 | 0.09526740608080957 | 0.09517217792576202 | 0.0936999439834473 | 0.09375765910486944 | 0.03147254631824705 | 0.01104115248869217 | 0.09679256731179713 | 0.09826400577798498 | 0.08695033442089778
Company 43 | 0.0947928766875437 | 0.0947558147150184 | 0.0932839385143049 | 0.09333370742995915 | 0.08870043714658112 | 0.0865274541291124 | 0.09667172931438021 | 0.09793828745743458 | 0.09860329470946655
Company 44 | 0.08867462782521388 | 0.08893607287513976 | 0.08961672754680539 | 0.0909037205905663 | -0.002859720617516602 | 0.07944018686187099 | 0.09357858000831676 | 0.07098660440005422 | 0.0877576481881519
Company 45 | 0.14007109693341 | 0.1347463701035205 | 0.138655294807279 | 0.1321170104961423 | 0.1320571356810596 | 0.1309803019890055 | 0.141882249634615 | 0 | 0
Company 46 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 47 | 0.09175543343931775 | 0.104140696548501 | 0.09024289675568953 | 0.1115082816390132 | 0 | 0.09937969297781006 | 0.1401956792533896 | 0.1363127878954859 | 0.1514918692827626
Company 48 | 0.1064128172088363 | 0.107007873788181 | 0.1092025591965877 | 0.1049673493001703 | 0.09717440145463034 | 0.0933628314535293 | 0.1077612199137578 | 0.1082746957036299 | 0.1113822417755535
Company 49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 50 | 0.1431709653721859 | 0.1431321493491282 | 0.1417630544705387 | 0.141761574097004 | 0.1372466635170778 | 0.1355109438443294 | 0.1449792722217045 | 0.1461517454589614 | 0.1467270351734798
Company 51 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 52 | 0.1555765054787004 | 0.1555431646205346 | 0.1541702526267645 | 0.1542105648227012 | 0.1498690571554309 | 0.1483777898901751 | 0 | 0.1585101958658653 | 0.1591340445875032
Company 53 | 0.1577810477397983 | 0.1579975503639631 | 0.1570726101939471 | 0.1572266929483836 | 0.1520153521681934 | 0.1501693919631994 | 0.1593679241295919 | 0.1605784920839532 | 0.1613435415343966
Company 54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 55 | 0.1427166218076222 | 0.1343845308302782 | 0.137942669899335 | 0.1412717527414047 | 0.1163953250751319 | 0.108740497190457 | 0.1347562816206613 | 0.1396200435520696 | 0.1397467719266114
Company 56 | 0.129004811285105 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1664730863029963 | 0.1216120393042149
Company 57 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 58 | 0.1218709163607892 | 0.135882238862332 | 0.1369894393360128 | 0.1320217964735655 | 0.1321442473026845 | 0.1158681399203441 | 0.1321073194072535 | 0.1328908621207265 | 0.1358917124071305
Company 59 | 0.1158522182293395 | 0.1204099056838936 | 0.1105021953932416 | 0.1125903950329694 | 0.09437563986638797 | 0.1022227877796241 | 0.1028343647949031 | 0.1193613229621599 | 0.119783321348919
Company 60 | 0.1331476910434301 | 0.132908815870515 | 0.1331008366142695 | 0.135227006213801 | 0.127388931271427 | 0.1250266241335694 | 0.1378812422427101 | 0.1398442055867885 | 0.1378703551689924
Company 61 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 62 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 63 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 64 | 0.1122127417321635 | 0.1118804808819253 | 0.110436785017806 | 0.110481143200382 | 0.1059315430771775 | 0.1039467489790904 | 0.113763702255438 | 0.1150012818126313 | 0.1156556560976369
Company 65 | 0.1119247156151682 | 0.1119820115582481 | 0.1104631038336306 | 0.1105225743565133 | 0.1059454025640703 | 0.103963137905834 | 0.1137831297066318 | 0.1150211302295775 | 0.115676374075829
Company 66 | 0.1284044623381634 | 0.1283700486306014 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 67 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 68 | 0.1457622033094608 | 0.1443387183639398 | 0.1428342601737267 | 0.1435387670896383 | 0.1354409545510407 | 0.1364781185194365 | 0.1464182188062921 | 0.1507193606156574 | 0.1453473438394228
Company 69 | 0.09053179350826104 | 0.09070637178863822 | 0.08931335274771822 | 0.09046960365216192 | 0.08570000641124226 | 0.08371772565334058 | 0.09006556010505568 | 0.09133796945546299 | 0.09201199131833605
Company 70 | 0.08813882676782672 | 0.0880968649479096 | 0.08662393835043025 | 0.0866463894347604 | 0.08220098556990879 | 0.0794478642283772 | 0.09006455260026221 | 0.09133834392563007 | 0.0919921502285507
Company 71 | 0 | 0 | 0.1269529587756454 | 0 | 0 | 0 | 0 | 0 | 0
Company 72 | 0.1252942466964272 | 0.1250937459190426 | 0.1243905896726454 | 0.1241498698187038 | 0 | 0.1168538039542379 | 0.1272344664061438 | 0.1285140777404469 | 0.1294232881454923
Company 73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 74 | 0.09863074609918362 | 0.09379022574783116 | 0.09435446888445428 | 0.09504276896360099 | 0.08574876020383841 | 0.08764826568558708 | 0.1020929068982727 | 0.1032303245061693 | 0.1032052149918506
Company 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 76 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 77 | 0.0542519146213337 | 0.0542102027654295 | 0.05267692179971614 | 0.05272075676383735 | 0.04787644937268759 | 0.04535392466875382 | 0.05621507657452397 | 0.0575342595787444 | 0.05823000769490617
Company 78 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 81 | 0.14330537269013 | 0.1423663515283498 | 0.140008660028362 | 0.1386494959561627 | 0.1352401259340358 | 0.1322106772182494 | 0.1399800781079512 | 0.1418844504329486 | 0.1392338882004042
Company 82 | 0.1396639582889578 | 0.137365064185759 | 0.1327764152959406 | 0.1289488818730226 | 0.1234925478827012 | 0.1261159903747596 | 0.1345602403022444 | 0.1319176230073373 | 0.1322733857246803
Company 83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1435796520641518
Company 84 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 85 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 86 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 87 | 0.1969740258930237 | 0.1969423195569497 | 0 | 0 | 0 | 0 | 0 | 0 | 0.03143362223897621
Company 88 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 89 | 0.1454339049156895 | 0.1454001635913965 | 0.1440107611777703 | 0.1440515575744709 | 0 | 0 | 0.1472103350111507 | 0.1484028326570561 | 0.1490341745955886
Company 90 | 0.1427304778550769 | 0.1460598454649847 | 0.1440561299365 | 0.142797907793535 | 0.1427799876280501 | 0.1369933974544552 | 0.151389933245288 | 0.1493903780077147 | 0.1502919313139286
Company 91 | 0.1463602129616259 | 0.1413586927162301 | 0.1623332209114295 | 0.1537771972855974 | 0.1482185293088784 | 0.1428883191493913 | 0.1566963957805799 | 0.3489938495056411 | 0.1569648232440279
Company 92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 93 | 0.1347026987650072 | 0.1332345219367895 | 0.134049133469156 | 0.1344873682655686 | 0.1194180711178392 | 0.1248613699378987 | 0.1372211671978364 | 0.138686973139816 | 0.1393383654093832
Company 94 | 0.1005702093377077 | 0.10063976749772 | 0.0978085688342088 | 0.1003926441047521 | 0 | 0.09217870184174091 | 0.1012091242334174 | 0.1008567703824228 | 0.09839369240533365
Company 95 | 0.1016715764706027 | 0.1039851468231036 | 0.1018303967595836 | 0.1041672480250742 | 0 | 0.09708728417914705 | 0.1058221282018499 | 0.1079046935922259 | 0.1091959321011853
Company 96 | 0.1150937265247898 | 0.1146601258845624 | 0.1137257604574086 | 0.1168922103753796 | 0.14406656222798 | 0.1087958688843111 | 0.1230400400814995 | 0.1224228278564544 | 0.1228440745869205
Company 97 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 98 | 0.1231876820189573 | 0.1176091939146982 | 0.1223155701345312 | 0 | 0.1175845766053444 | 0.1155795469668295 | 0.1256596980892459 | 0 | 0
Company 99 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1270658335639152 | 0
Company 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 101 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 102 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 104 | 0.1233518498163954 | 0.1410855071832667 | 0.1396890900315468 | 0.1397300923988396 | 0 | 0.1350745000765537 | 0.1352964259016567 | 0.1307371136427337 | 0.1223086543132452
Company 105 | 0 | 0 | 0 | 0 | 0 | 0.1626820971824789 | 0.1718581276111795 | 0.1730161590389084 | 0.1736292535879619
Company 106 | 0.2610176607119603 | 0.260988483047529 | 0.2597870033120936 | 0.2598222818199139 | 0 | 0.2547020449190732 | 0.2625538209634339 | 0.2635850281515447 | 0.2641309783657074
Company 107 | 0.111916288333361 | 0.1118803003205467 | 0.1104373811682148 | 0.1104777191017061 | 0.1059265412387297 | 0.1039761524313391 | 0.113760844164089 | 0.1150006084472122 | 0.1156578819546832
Company 108 | 0.112621977736782 | 0.1127434325022117 | 0.1113422062087787 | 0.1110531088345822 | 0.1069521396037081 | 0.1048358193609777 | 0.1145337534833891 | 0.1158340822817295 | 0.1166146444794423
Company 109 | 0.1294846343859526 | 0.1294441288057074 | 0.1280282347844489 | 0 | 0 | 0.1221194205673888 | 0.1312953467409448 | 0.1325017961507156 | 0.13314492651645
Company 110 | 0.1488835477005758 | 0.1512123373392822 | 0.1506736082353302 | 0 | 0.1426893355103941 | 0.1434428103520063 | 0.1517757102306096 | 0.1538298695734342 | 0.158259387509665
Company 111 | 0 | 0 | 0.1982326493495608 | 0 | 0 | 0 | 0 | 0 | 0
Company 112 | 0.3061584291322522 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 113 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 114 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 115 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1441284296299396 | 0
Company 116 | 0.1555794159674676 | 0.1555434228652412 | 0.154173120181877 | 0.1542093080767354 | 0.1498847063930468 | 0.147986152761155 | 0.1573326809365242 | 0.1585107663471279 | 0.1591338065225295
Company 117 | 0.1028592059600177 | 0.1028236395688125 | 0.10137225534787 | 0.1014107702311918 | 0 | 0 | 0.1047125439868239 | 0 | 0.1058317633363952
Company 118 | 0.1397195984366957 | 0.1396856314911555 | 0.1382869384313642 | 0.1383280076251197 | 0 | 0.1328896700712919 | 0.1291349123663182 | 0.1427083787829405 | 0.1433439423742518
Company 119 | 0.1294818363031346 | 0.1294474651341483 | 0.128032126935379 | 0.1280736848728463 | 0 | 0 | 0 | 0 | 0.1331493117255597
Company 120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 121 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 122 | 0.113311037160457 | 0.1132430815065461 | 0.1118435142818387 | 0.1118241390246933 | 0.1079510275569524 | 0.1055258335549316 | 0.1152587312293858 | 0.1167999514456942 | 0.1172322499420939
Company 123 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 124 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Company 125 | 0.1187966470329784 | 0.1139666794840917 | 0.1180168266431934 | 0.1169234265147298 | 0.1122116678155218 | 0.1118889007138213 | 0.1216865096960028 | 0.1108298908446839 | 0.1202214233138543
Company 126 | 0.1119177278824666 | 0.1118792425623848 | 0.1104370078172367 | 0.1104802258044693 | 0.1059219558861011 | 0.07642186699277773 | 0.1137593323801243 | 0.1150025284652381 | 0.1156573993500532
Company 127 | 0.1011238996529436 | 0.09788496344380787 | 0.09688861662401209 | 0.09999229935932062 | 0.1039565715388299 | 0.1023648967391911 | 0.1121155183660206 | 0.115272016118432 | 0.1157775444245616
Company 128 | 0.1123896828327254 | 0.1128068122879058 | 0.1107859313801702 | 0.1109413536315281 | 0.1233684798467629 | 0.07775196162900941 | 0.1112955335686906 | 0.1145706331101932 | 0.1164705872270205
Company 129 | 0 | 0.04561754828121027 | 0.04406689858444345 | 0.04412626190220365 | 0.03921926309980076 | 0.1030154733911276 | 0.1130770035100217 | 0.1143165060479172 | 0.1149459243756876
Company 130 | 0.115992234025823 | 0.1136621500611895 | 0.1122148504305633 | 0.11383744543777 | 0.109564792986437 | 0.1073131988391614 | 0.1163388239818052 | 0.1187221802951838 | 0.1190731432188911
Company 131 | 0.1172758051223712 | 0.1172655858127172 | 0.115833949174123 | 0.1160178906356337 | 0.1113372910493735 | 0.1092633467103707 | 0.11913972411411 | 0.1203666137161024 | 0.1228300425323212
Company 132 | 0.1119188433396362 | 0.1118784815284753 | 0.1104373096897588 | 0.1104800436040822 | 0.1059265561668888 | 0.1040797226155442 | 0.1137572810960359 | 0.114999840692501 | 0.1156570780554141
Company 133 | 0.1162134338393602 | 0.1113124554546306 | 0.1104385698448785 | 0.1104743237117382 | 0.105924817087409 | 0.1039673093930508 | 0.1137619200501066 | 0.1150001470851751 | 0.1156617971002487