Spreadsheet: 139057d1328049987-formula-to-identify-streaks-from-a-data-set-of-results-del-11_12-prediction
Sheet: RANKINGS COMPARISON

After 30th December 2011 Games |  |  |  |  | After 6th January 2012 Games |  |  |  |  | After 13th January 2012 Games |  |  |  |  | After 27th January 2012 Games
TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME]
[NAME] | 0.9569389212021691 | 0.593909359343009 | -0.36302956185916 |  | [NAME] | 0.9980010163408508 | 0.6578170487729845 | -0.3401839675678663 |  | [NAME] | 0.8593250816175393 | 0.2954271007752143 | -0.563897980842325 |  | [NAME] | 0.8356565152706321 | 0.3955710773242232 | -0.440085437946409
Adler Mannheim | 0.7013949584518884 | 0.6252988749325403 | -0.07609608351934799 |  | [NAME] | 0.6877593697632138 | 0.1754779147100556 | -0.5122814550531583 |  | [NAME] | 0.8324496665266745 | 0.5836631087248293 | -0.2487865578018452 |  | [NAME] | 0.6571905986518952 | 0.4819862971624563 | -0.1752043014894389
[NAME] | 0.6312298547589767 | 0.1399549052860479 | -0.4912749494729288 |  | Adler Mannheim | 0.5980898604231234 | 0.6053429641312995 | 0.007253103708176136 |  | Adler Mannheim | 0.472204005809985 | 0.5157070997082503 | 0.04350309389826541 |  | Adler Mannheim | 0.4774426580109447 | 0.5363866175074983 | 0.05894395949655355
ERC Ingolstadt | 0.5764951480706191 | 0.44049473260934 | -0.1360004154612791 |  | ERC Ingolstadt | 0.4977472249864375 | 0.3624217776469066 | -0.1353254473395309 |  | ERC Ingolstadt | 0.38339220616356 | 0.3356138034925325 | -0.04777840267102747 |  | ERC Ingolstadt | 0.4281228748420129 | 0.3731945671833169 | -0.05492830765869599
[NAME] | 0.2543126136345848 | 0.2396005641666038 | -0.01471204946798099 |  | Straubing Tigers | 0.2327403958174825 | 0.3073579157063581 | 0.07461751988887567 |  | [NAME] | 0.2660003634993355 | 0.1892412937342899 | -0.07675906976504561 |  | Straubing Tigers | 0.3570855801085058 | 0.4051728030662404 | 0.04808722295773465
EHC München | 0.1320110996290145 | -0.2891494031889706 | -0.4211605028179851 |  | [NAME] | 0.231061962898218 | 0.1623454853518759 | -0.06871647754634201 |  | Straubing Tigers | 0.2541269448042035 | 0.3551793638234298 | 0.1010524190192263 |  | EHC München | -0.009650131349056401 | -0.4456597180826465 | -0.4360095867335901
Straubing Tigers | 0.04073210917797623 | 0.2142857044731427 | 0.1735535952951665 |  | EHC München | -0.0008537618918019185 | -0.4161841572628235 | -0.4153303953710216 |  | Augsburger [NAME] | -0.05542455653396633 | -0.3931980891665859 | -0.3377735326326196 |  | Augsburger [NAME] | -0.06677259944495983 | -0.3504703478966589 | -0.283697748451699
Kölner Haie | -0.138363407179662 | -0.2354749930010126 | -0.09711158582135059 |  | [NAME] | -0.148899646174381 | 0.3787269318014427 | 0.5276265779758237 |  | EHC München | -0.1412100559784712 | -0.486094606806819 | -0.3448845508283477 |  | [NAME] | -0.07882554276789447 | -0.08276975805034509 | -0.003944215282450618
Augsburger [NAME] | -0.1944073542919122 | -0.5361898881943865 | -0.3417825339024743 |  | Augsburger [NAME] | -0.1880180576784122 | -0.4992086960703869 | -0.3111906383919747 |  | Kölner Haie | -0.1895203977469545 | -0.2637698697790061 | -0.07424947203205155 |  | [NAME] | -0.1686832903465011 | -0.08807799728286078 | 0.08060529306364037
[NAME] | -0.2195230707476407 | 0.3316845159049568 | 0.5512075866525975 |  | Kölner Haie | -0.2968743465084765 | -0.2883196444240531 | 0.008554702084423464 |  | [NAME] | -0.3136482486890617 | 0.2840710320443777 | 0.5977192807334394 |  | [NAME] | -0.192344267213011 | 0.3059657879161781 | 0.4983100551291891
[NAME] | -0.4471251457168564 | -0.2522046814982196 | 0.1949204642186368 |  | [NAME] | -0.4440689160472126 | -0.1291847523428317 | 0.3148841637043809 |  | [NAME] | -0.3684367864488228 | -0.1559884423050927 | 0.2124483441437301 |  | Kölner Haie | -0.2196879847174348 | -0.1877469740227438 | 0.03194101069469104
[NAME] | -0.4890004874465341 | -0.1268314864590552 | 0.3621690009874789 |  | [NAME] | -0.6191239242106661 | -0.3381429398333958 | 0.2809809843772703 |  | [NAME] | -0.5736243196750156 | -0.355966558531326 | 0.2176577611436895 |  | [NAME] | -0.471304504509828 | -0.3513295956874186 | 0.1199749088224094
Hannover Scorpions | -0.701458751152559 | -0.5038330861848546 | 0.1976256649677044 |  | Hannover Scorpions | -0.6915790009687954 | -0.4636919660316046 | 0.2278870349371908 |  | [NAME] | -0.701982897930236 | -0.3801787511874386 | 0.3218041467427974 |  | [NAME] | -0.7424523886853825 | -0.4421790262468798 | 0.3002733624385028
[NAME] | -1.103236488390064 | -0.6415451181897667 | 0.461691370200297 |  | [NAME] | -0.8559821767495795 | -0.5147578821564527 | 0.3412242945931269 |  | Hannover Scorpions | -0.7236510054187686 | -0.5237064845272804 | 0.1999445208914881 |  | Hannover Scorpions | -0.8057775178499222 | -0.5500437328909856 | 0.2557337849589366
TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME]
Adler Mannheim | 0.7013949584518884 | 0.6252988749325403 | -0.07609608351934799 |  | [NAME] | 0.9980010163408508 | 0.6578170487729845 | -0.3401839675678663 |  | [NAME] | 0.8324496665266745 | 0.5836631087248293 | -0.2487865578018452 |  | Adler Mannheim | 0.4774426580109447 | 0.5363866175074983 | 0.05894395949655355
[NAME] | 0.9569389212021691 | 0.593909359343009 | -0.36302956185916 |  | Adler Mannheim | 0.5980898604231234 | 0.6053429641312995 | 0.007253103708176136 |  | Adler Mannheim | 0.472204005809985 | 0.5157070997082503 | 0.04350309389826541 |  | [NAME] | 0.6571905986518952 | 0.4819862971624563 | -0.1752043014894389
ERC Ingolstadt | 0.5764951480706191 | 0.44049473260934 | -0.1360004154612791 |  | [NAME] | -0.148899646174381 | 0.3787269318014427 | 0.5276265779758237 |  | Straubing Tigers | 0.2541269448042035 | 0.3551793638234298 | 0.1010524190192263 |  | Straubing Tigers | 0.3570855801085058 | 0.4051728030662404 | 0.04808722295773465
[NAME] | -0.2195230707476407 | 0.3316845159049568 | 0.5512075866525975 |  | ERC Ingolstadt | 0.4977472249864375 | 0.3624217776469066 | -0.1353254473395309 |  | ERC Ingolstadt | 0.38339220616356 | 0.3356138034925325 | -0.04777840267102747 |  | [NAME] | 0.8356565152706321 | 0.3955710773242232 | -0.440085437946409
[NAME] | 0.2543126136345848 | 0.2396005641666038 | -0.01471204946798099 |  | Straubing Tigers | 0.2327403958174825 | 0.3073579157063581 | 0.07461751988887567 |  | [NAME] | 0.8593250816175393 | 0.2954271007752143 | -0.563897980842325 |  | ERC Ingolstadt | 0.4281228748420129 | 0.3731945671833169 | -0.05492830765869599
Straubing Tigers | 0.04073210917797623 | 0.2142857044731427 | 0.1735535952951665 |  | [NAME] | 0.6877593697632138 | 0.1754779147100556 | -0.5122814550531583 |  | [NAME] | -0.3136482486890617 | 0.2840710320443777 | 0.5977192807334394 |  | [NAME] | -0.192344267213011 | 0.3059657879161781 | 0.4983100551291891
[NAME] | 0.6312298547589767 | 0.1399549052860479 | -0.4912749494729288 |  | [NAME] | 0.231061962898218 | 0.1623454853518759 | -0.06871647754634201 |  | [NAME] | 0.2660003634993355 | 0.1892412937342899 | -0.07675906976504561 |  | [NAME] | -0.07882554276789447 | -0.08276975805034509 | -0.003944215282450618
[NAME] | -0.4890004874465341 | -0.1268314864590552 | 0.3621690009874789 |  | [NAME] | -0.4440689160472126 | -0.1291847523428317 | 0.3148841637043809 |  | [NAME] | -0.3684367864488228 | -0.1559884423050927 | 0.2124483441437301 |  | [NAME] | -0.1686832903465011 | -0.08807799728286078 | 0.08060529306364037
Kölner Haie | -0.138363407179662 | -0.2354749930010126 | -0.09711158582135059 |  | Kölner Haie | -0.2968743465084765 | -0.2883196444240531 | 0.008554702084423464 |  | Kölner Haie | -0.1895203977469545 | -0.2637698697790061 | -0.07424947203205155 |  | Kölner Haie | -0.2196879847174348 | -0.1877469740227438 | 0.03194101069469104
[NAME] | -0.4471251457168564 | -0.2522046814982196 | 0.1949204642186368 |  | [NAME] | -0.6191239242106661 | -0.3381429398333958 | 0.2809809843772703 |  | [NAME] | -0.5736243196750156 | -0.355966558531326 | 0.2176577611436895 |  | Augsburger [NAME] | -0.06677259944495983 | -0.3504703478966589 | -0.283697748451699
EHC München | 0.1320110996290145 | -0.2891494031889706 | -0.4211605028179851 |  | EHC München | -0.0008537618918019185 | -0.4161841572628235 | -0.4153303953710216 |  | [NAME] | -0.701982897930236 | -0.3801787511874386 | 0.3218041467427974 |  | [NAME] | -0.471304504509828 | -0.3513295956874186 | 0.1199749088224094
Hannover Scorpions | -0.701458751152559 | -0.5038330861848546 | 0.1976256649677044 |  | Hannover Scorpions | -0.6915790009687954 | -0.4636919660316046 | 0.2278870349371908 |  | Augsburger [NAME] | -0.05542455653396633 | -0.3931980891665859 | -0.3377735326326196 |  | [NAME] | -0.7424523886853825 | -0.4421790262468798 | 0.3002733624385028
Augsburger [NAME] | -0.1944073542919122 | -0.5361898881943865 | -0.3417825339024743 |  | Augsburger [NAME] | -0.1880180576784122 | -0.4992086960703869 | -0.3111906383919747 |  | EHC München | -0.1412100559784712 | -0.486094606806819 | -0.3448845508283477 |  | EHC München | -0.009650131349056401 | -0.4456597180826465 | -0.4360095867335901
[NAME] | -1.103236488390064 | -0.6415451181897667 | 0.461691370200297 |  | [NAME] | -0.8559821767495795 | -0.5147578821564527 | 0.3412242945931269 |  | Hannover Scorpions | -0.7236510054187686 | -0.5237064845272804 | 0.1999445208914881 |  | Hannover Scorpions | -0.8057775178499222 | -0.5500437328909856 | 0.2557337849589366
TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME] |  | TEAM | RATING | OFFENCE | [NAME]
[NAME] | 0.6312298547589767 | 0.1399549052860479 | -0.4912749494729288 |  | [NAME] | 0.6877593697632138 | 0.1754779147100556 | -0.5122814550531583 |  | [NAME] | 0.8593250816175393 | 0.2954271007752143 | -0.563897980842325 |  | [NAME] | 0.8356565152706321 | 0.3955710773242232 | -0.440085437946409
EHC München | 0.1320110996290145 | -0.2891494031889706 | -0.4211605028179851 |  | EHC München | -0.0008537618918019185 | -0.4161841572628235 | -0.4153303953710216 |  | EHC München | -0.1412100559784712 | -0.486094606806819 | -0.3448845508283477 |  | EHC München | -0.009650131349056401 | -0.4456597180826465 | -0.4360095867335901
[NAME] | 0.9569389212021691 | 0.593909359343009 | -0.36302956185916 |  | [NAME] | 0.9980010163408508 | 0.6578170487729845 | -0.3401839675678663 |  | Augsburger [NAME] | -0.05542455653396633 | -0.3931980891665859 | -0.3377735326326196 |  | Augsburger [NAME] | -0.06677259944495983 | -0.3504703478966589 | -0.283697748451699
Augsburger [NAME] | -0.1944073542919122 | -0.5361898881943865 | -0.3417825339024743 |  | Augsburger [NAME] | -0.1880180576784122 | -0.4992086960703869 | -0.3111906383919747 |  | [NAME] | 0.8324496665266745 | 0.5836631087248293 | -0.2487865578018452 |  | [NAME] | 0.6571905986518952 | 0.4819862971624563 | -0.1752043014894389
ERC Ingolstadt | 0.5764951480706191 | 0.44049473260934 | -0.1360004154612791 |  | ERC Ingolstadt | 0.4977472249864375 | 0.3624217776469066 | -0.1353254473395309 |  | [NAME] | 0.2660003634993355 | 0.1892412937342899 | -0.07675906976504561 |  | ERC Ingolstadt | 0.4281228748420129 | 0.3731945671833169 | -0.05492830765869599
Kölner Haie | -0.138363407179662 | -0.2354749930010126 | -0.09711158582135059 |  | [NAME] | 0.231061962898218 | 0.1623454853518759 | -0.06871647754634201 |  | Kölner Haie | -0.1895203977469545 | -0.2637698697790061 | -0.07424947203205155 |  | [NAME] | -0.07882554276789447 | -0.08276975805034509 | -0.003944215282450618
Adler Mannheim | 0.7013949584518884 | 0.6252988749325403 | -0.07609608351934799 |  | Adler Mannheim | 0.5980898604231234 | 0.6053429641312995 | 0.007253103708176136 |  | ERC Ingolstadt | 0.38339220616356 | 0.3356138034925325 | -0.04777840267102747 |  | Kölner Haie | -0.2196879847174348 | -0.1877469740227438 | 0.03194101069469104
[NAME] | 0.2543126136345848 | 0.2396005641666038 | -0.01471204946798099 |  | Kölner Haie | -0.2968743465084765 | -0.2883196444240531 | 0.008554702084423464 |  | Adler Mannheim | 0.472204005809985 | 0.5157070997082503 | 0.04350309389826541 |  | Straubing Tigers | 0.3570855801085058 | 0.4051728030662404 | 0.04808722295773465
Straubing Tigers | 0.04073210917797623 | 0.2142857044731427 | 0.1735535952951665 |  | Straubing Tigers | 0.2327403958174825 | 0.3073579157063581 | 0.07461751988887567 |  | Straubing Tigers | 0.2541269448042035 | 0.3551793638234298 | 0.1010524190192263 |  | Adler Mannheim | 0.4774426580109447 | 0.5363866175074983 | 0.05894395949655355
[NAME] | -0.4471251457168564 | -0.2522046814982196 | 0.1949204642186368 |  | Hannover Scorpions | -0.6915790009687954 | -0.4636919660316046 | 0.2278870349371908 |  | Hannover Scorpions | -0.7236510054187686 | -0.5237064845272804 | 0.1999445208914881 |  | [NAME] | -0.1686832903465011 | -0.08807799728286078 | 0.08060529306364037
Hannover Scorpions | -0.701458751152559 | -0.5038330861848546 | 0.1976256649677044 |  | [NAME] | -0.6191239242106661 | -0.3381429398333958 | 0.2809809843772703 |  | [NAME] | -0.3684367864488228 | -0.1559884423050927 | 0.2124483441437301 |  | [NAME] | -0.471304504509828 | -0.3513295956874186 | 0.1199749088224094
[NAME] | -0.4890004874465341 | -0.1268314864590552 | 0.3621690009874789 |  | [NAME] | -0.4440689160472126 | -0.1291847523428317 | 0.3148841637043809 |  | [NAME] | -0.5736243196750156 | -0.355966558531326 | 0.2176577611436895 |  | Hannover Scorpions | -0.8057775178499222 | -0.5500437328909856 | 0.2557337849589366
[NAME] | -1.103236488390064 | -0.6415451181897667 | 0.461691370200297 |  | [NAME] | -0.8559821767495795 | -0.5147578821564527 | 0.3412242945931269 |  | [NAME] | -0.701982897930236 | -0.3801787511874386 | 0.3218041467427974 |  | [NAME] | -0.7424523886853825 | -0.4421790262468798 | 0.3002733624385028
[NAME] | -0.2195230707476407 | 0.3316845159049568 | 0.5512075866525975 |  | [NAME] | -0.148899646174381 | 0.3787269318014427 | 0.5276265779758237 |  | [NAME] | -0.3136482486890617 | 0.2840710320443777 | 0.5977192807334394 |  | [NAME] | -0.192344267213011 | 0.3059657879161781 | 0.4983100551291891