Spreadsheet: 47982d1247157634-heat-map-heat-map2
Sheet: Sheet 1

 |  | Window | 0.6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentile
 |  | 1 | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  | MAX |  |  | Data points Above/Below | 2
 |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]!
 |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  |  |  |  | Percentile
 |  |  | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! | #[NAME]! |  |  |  |  | Window
 |  |  | -30.84595882324098 | -30.84595882324098 | -30.84595882324098 | -30.84595882324098 | -30.84595882324098 | -30.84595882324098 | -30.84595882324098 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -2.964049941484676 | -11.87511401091308 | -11.87511401091308
 |  |  | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -14.29431560955742 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984 | -3.563931050942984
 |  |  | -13.29802829389798 | -13.29802829389798 | -13.29802829389798 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -18.72682784943769 | -4.292436918531669 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334 | -19.8360260292334
 |  |  | -24.70359298289738 | -24.70359298289738 | -24.70359298289738 | -24.70359298289738 | -24.70359298289738 | -24.70359298289738 | -24.70359298289738 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -25.34397906709264 | -42.20227298084964 | -42.20227298084964 | -42.20227298084964 | -42.20227298084964 | -42.20227298084964 | -42.20227298084964 | -42.20227298084964 | -42.20227298084964
 |  |  | 7.916261820591971 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 0.03073919881887067 | 15.30722782620013 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 17.79946573537445 | 8.225789062750271 | -4.197996333967911 | -4.197996333967911 | -4.197996333967911 | -4.197996333967911 | -4.197996333967911
 |  |  | -27.86563426842128 | -27.86563426842128 | -27.86563426842128 | -27.86563426842128 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -11.03752197935977 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -4.544867318855699 | -20.17336409746403 | -20.17336409746403 | -20.17336409746403 | -20.17336409746403
 |  |  | -5.253331493955633 | -5.253331493955633 | -5.253331493955633 | -5.253331493955633 | -5.253331493955633 | -5.253331493955633 | -5.253331493955633 | 12.81651755524749 | 12.81651755524749 | 12.81651755524749 | 12.81651755524749 | 12.81651755524749 | 12.81651755524749 | 12.81651755524749 | 12.81651755524749 | 6.017471844733162 | 3.320179002195939 | 3.320179002195939 | 3.320179002195939 | 3.320179002195939 | 3.320179002195939 | 3.320179002195939 | 3.320179002195939 | 3.320179002195939 | 13.85117083282483 | 13.85117083282483
 |  |  | 23.99916237705339 | 23.99916237705339 | -3.709968282482567 | -3.709968282482567 | -3.709968282482567 | -3.709968282482567 | -3.709968282482567 | -3.709968282482567 | -3.709968282482567 | -3.709968282482567 | -8.348085615457036 | -8.348085615457036 | -8.348085615457036 | -8.348085615457036 | -8.348085615457036 | -8.348085615457036 | -8.348085615457036 | -21.53570778175554 | -21.53570778175554 | -21.53570778175554 | -21.53570778175554 | -21.53570778175554 | -21.53570778175554 | -21.53570778175554 | -21.53570778175554 | -33.95718262165596
 |  |  | 6.846146455142939 | 6.846146455142939 | 6.846146455142939 | 6.846146455142939 | 6.846146455142939 | -8.689249456022669 | -8.689249456022669 | -8.689249456022669 | -8.689249456022669 | -8.689249456022669 | -8.689249456022669 | -8.689249456022669 | -16.8533865706266 | -16.8533865706266 | -16.8533865706266 | -16.8533865706266 | -16.8533865706266 | -16.8533865706266 | -16.8533865706266 | -31.73507565417552 | -31.73507565417552 | -31.73507565417552 | -31.73507565417552 | -31.73507565417552 | -31.73507565417552 | -31.73507565417552
 |  |  | -0.7640075391212773 | -3.218059210342862 | -3.218059210342862 | -3.218059210342862 | -3.218059210342862 | -3.218059210342862 | -3.218059210342862 | -0.896474324464035 | -0.896474324464035 | -0.896474324464035 | -0.896474324464035 | -0.896474324464035 | -0.896474324464035 | -0.896474324464035 | 8.406120988309468 | 8.406120988309468 | 8.406120988309468 | 8.406120988309468 | 8.406120988309468 | 8.406120988309468 | 4.088338828042547 | -3.107399788775506 | -3.107399788775506 | -3.107399788775506 | -3.107399788775506 | -3.107399788775506
 |  |  | -21.84469641031915 | -21.84469641031915 | -21.84469641031915 | -16.75811025792689 | -16.75811025792689 | -16.75811025792689 | -16.75811025792689 | -16.75811025792689 | -16.75811025792689 | -30.43767369510283 | -30.43767369510283 | -30.43767369510283 | -30.43767369510283 | -30.43767369510283 | -30.43767369510283 | -17.37528015962518 | -12.12378463855729 | -12.12378463855729 | -12.12378463855729 | -12.12378463855729 | -12.12378463855729 | -12.12378463855729 | -25.44544691828378 | -25.44544691828378 | -25.44544691828378 | -25.44544691828378
 |  |  | 12.64510734570831 | 12.64510734570831 | 12.64510734570831 | 12.64510734570831 | 12.64510734570831 | -2.792742283527123 | -2.792742283527123 | -2.792742283527123 | -2.792742283527123 | -2.792742283527123 | -2.792742283527123 | 13.23315594968931 | 13.23315594968931 | 13.23315594968931 | 13.23315594968931 | 13.23315594968931 | 13.23315594968931 | 0.197240312122568 | 0.197240312122568 | 0.197240312122568 | 0.197240312122568 | 0.197240312122568 | 0.197240312122568 | 1.845082146102455 | 1.845082146102455 | 1.845082146102455
 |  |  | -7.955891064823973 | -7.955891064823973 | 0.3113757748596179 | 0.3113757748596179 | 0.3113757748596179 | 0.3113757748596179 | 0.3113757748596179 | 0.4175115413043878 | 0.4175115413043878 | 0.4175115413043878 | 0.4175115413043878 | 0.4175115413043878 | 0.4175115413043878 | -11.58303493605436 | -11.58303493605436 | -11.58303493605436 | -11.58303493605436 | -11.58303493605436 | -4.664433701348044 | -4.664433701348044 | -4.664433701348044 | -4.664433701348044 | -4.664433701348044 | -4.664433701348044 | -27.21113969366292 | -27.21113969366292
 |  |  | -2.776162020681986 | -2.776162020681986 | -2.776162020681986 | -2.776162020681986 | 14.7862853252253 | 14.7862853252253 | 14.7862853252253 | 14.7862853252253 | 14.7862853252253 | 15.86350294333328 | 15.86350294333328 | 15.86350294333328 | 15.86350294333328 | 15.86350294333328 | 6.342723841316916 | 6.342723841316916 | 6.342723841316916 | 6.342723841316916 | 6.342723841316916 | 9.586593787872074 | 9.586593787872074 | 9.586593787872074 | 9.586593787872074 | 9.586593787872074 | 9.586593787872074 | 10.26530655695974
 |  |  | 6.054750166435841 | -2.925891658831617 | -2.925891658831617 | -2.925891658831617 | -2.925891658831617 | 1.454985601042307 | -5.415820657396049 | -5.415820657396049 | -5.415820657396049 | -5.415820657396049 | 2.898638317922876 | -1.589006229735691 | -1.589006229735691 | -1.589006229735691 | -1.589006229735691 | 3.287670732492667 | 16.3575481223806 | 16.3575481223806 | 16.3575481223806 | 16.3575481223806 | 2.680878160225969 | 3.254541547931169 | 3.254541547931169 | 3.254541547931169 | 3.254541547931169 | -5.295365935261783
 |  |  | -4.537849676831873 | -4.537849676831873 | -13.4358103428421 | -13.4358103428421 | -13.4358103428421 | -13.4358103428421 | -13.4358103428421 | -6.147659742134749 | -6.147659742134749 | -6.147659742134749 | -6.147659742134749 | -6.147659742134749 | -17.92733499919561 | -17.92733499919561 | -17.92733499919561 | -17.92733499919561 | -17.92733499919561 | -6.093343734567313 | -6.093343734567313 | -6.093343734567313 | -6.093343734567313 | 1.786123491434459 | 1.786123491434459 | 1.786123491434459 | 1.786123491434459 | 1.786123491434459
 |  |  | 7.869143093175987 | 7.869143093175987 | 7.869143093175987 | 7.869143093175987 | 2.57824865290731 | 2.57824865290731 | 2.57824865290731 | 2.57824865290731 | 2.57824865290731 | 19.51271183266058 | 19.51271183266058 | 19.51271183266058 | 19.51271183266058 | 28.22833659608311 | 28.22833659608311 | 28.22833659608311 | 28.22833659608311 | 28.22833659608311 | 26.42573909309677 | 26.42573909309677 | 26.42573909309677 | 26.42573909309677 | 14.11540409728973 | 14.11540409728973 | 14.11540409728973 | 14.11540409728973
 |  |  | -17.55136618548319 | -10.740101399627 | -10.740101399627 | -10.740101399627 | -10.740101399627 | -10.740101399627 | -12.32810281997192 | -12.32810281997192 | -12.32810281997192 | -12.32810281997192 | -1.719062832930963 | -1.719062832930963 | -1.719062832930963 | -1.719062832930963 | -6.174402791084601 | -6.174402791084601 | -6.174402791084601 | -6.174402791084601 | -6.174402791084601 | -3.648371818686663 | -3.648371818686663 | -3.648371818686663 | -3.648371818686663 | -5.542093319288668 | -5.542093319288668 | -5.542093319288668
 |  |  | -2.066081113170905 | -2.066081113170905 | -2.066081113170905 | 3.899910022870997 | 3.899910022870997 | 3.899910022870997 | 3.899910022870997 | 11.97003750919141 | 11.97003750919141 | 11.97003750919141 | 11.97003750919141 | 17.89041267587466 | 17.89041267587466 | 17.89041267587466 | 17.89041267587466 | 14.97334552678556 | 13.09620231316026 | 13.09620231316026 | 13.09620231316026 | 13.09620231316026 | 0.3678695252784499 | 0.3678695252784499 | 0.3678695252784499 | 0.3678695252784499 | 9.360270898443957 | 9.360270898443957
 |  |  | 28.56085485791954 | 19.98082326917962 | 19.98082326917962 | 19.98082326917962 | 2.227004864579204 | -3.60791895290495 | -3.60791895290495 | -3.60791895290495 | 4.839468261562579 | 2.944989511520089 | 2.944989511520089 | 2.944989511520089 | -4.942056020440024 | 0.5887184189122984 | 0.5887184189122984 | 0.5887184189122984 | 0.3422707802942946 | 10.31354273727159 | 10.31354273727159 | 10.31354273727159 | 3.71731407329101 | 10.11908379146004 | 10.11908379146004 | 10.11908379146004 | 17.35475150111528 | 8.618753924905926
 |  |  | 5.444894021833592 | 5.444894021833592 | 9.015460550893634 | 9.015460550893634 | 9.015460550893634 | 9.015460550893634 | 9.576739842315453 | 9.576739842315453 | 9.576739842315453 | 9.576739842315453 | 12.42931802804309 | 12.42931802804309 | 12.42931802804309 | 12.42931802804309 | 9.446324792118764 | 9.446324792118764 | 9.446324792118764 | 16.37007580087292 | 16.37007580087292 | 16.37007580087292 | 16.37007580087292 | 14.01080702085694 | 14.01080702085694 | 14.01080702085694 | 14.01080702085694 | 4.789691072081213
 |  |  | 11.00760762457787 | 11.00760762457787 | 11.00760762457787 | 7.139607819430359 | 7.139607819430359 | 7.139607819430359 | 7.139607819430359 | 16.60623553212504 | 16.60623553212504 | 16.60623553212504 | 16.60623553212504 | 19.97853217896348 | 19.97853217896348 | 19.97853217896348 | 19.97853217896348 | 19.28776842321149 | 19.28776842321149 | 19.28776842321149 | 15.55362531689726 | 15.55362531689726 | 15.55362531689726 | 15.55362531689726 | 6.602714804428911 | 6.602714804428911 | 6.602714804428911 | 6.602714804428911
 |  |  | 26.00590081339317 | 35.30025826744391 | 35.30025826744391 | 35.30025826744391 | 35.30025826744391 | 25.53226056439013 | 25.53226056439013 | 25.53226056439013 | 23.03502210727361 | 23.03502210727361 | 23.03502210727361 | 23.03502210727361 | 23.05785205178624 | 23.05785205178624 | 23.05785205178624 | 27.92886838014719 | 23.89506941371549 | 23.89506941371549 | 23.89506941371549 | 20.43992196960243 | 20.43992196960243 | 20.43992196960243 | 20.43992196960243 | 18.00317597505304 | 18.00317597505304 | 18.00317597505304
 |  |  | 0.914269708972724 | 0.914269708972724 | 0.914269708972724 | 4.261347638449902 | 4.261347638449902 | 4.261347638449902 | 3.020377924521995 | 3.020377924521995 | 3.020377924521995 | 5.243694237212189 | 5.243694237212189 | 5.243694237212189 | 5.243694237212189 | 1.750126862096027 | 1.750126862096027 | 1.750126862096027 | 3.435726624431687 | 3.435726624431687 | 3.435726624431687 | 3.435726624431687 | 13.10372793067924 | 13.10372793067924 | 13.10372793067924 | 12.88134989094013 | 12.88134989094013 | 12.88134989094013
 |  |  | 18.97169009638049 | 18.18624359747782 | 18.18624359747782 | 18.18624359747782 | 16.67442180973054 | 16.67442180973054 | 16.67442180973054 | 23.51312054215019 | 23.51312054215019 | 23.51312054215019 | 7.659387601339098 | 11.69587491301756 | 11.69587491301756 | 11.69587491301756 | 16.47258355318447 | 16.47258355318447 | 16.47258355318447 | 16.39243275979142 | 16.39243275979142 | 16.39243275979142 | 2.829878346674912 | 6.565024919718565 | 6.565024919718565 | 6.565024919718565 | -2.006340153505736 | -2.006340153505736
 |  |  | Example |  |  |  |  |  |  |  | Return
 |  |  | Data pointsAbove/Below | sum | sum | sum | sum |  | [NAME] |  | Percentile | Window
 |  |  | 2 |  |  |  |  |  |  |  | 0.62 | 28
 |  |  | 3 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 4 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 5 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 6 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 7 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 8 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 9 |  |  |  |  |  |  |  | 0.63 | 28
 |  |  | 10 |  |  |  |  |  |  |  | 0.63 | 28