Spreadsheet: 79853d1280098803-calculating-value-for-maximum-consecutive-value-sb_example
Sheet: Sheet1

dscode | sb92 | sb93 | sb94 | sb95 | sb96 | sb97 | sb98 | sb99 | sb00 | sb01 | sb02 | sb03 | sb04 | sb05 | sb06 | sb07 | dscode | sb92 | sb93 | sb94 | sb95 | sb96 | sb97 | sb98 | sb99 | sb00 | sb01 | sb02 | sb03 | sb04 | sb05 | sb06 | sb07 | No of Year | AVR | AVR | COUNTMAX | AvrMx
319336 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 319336 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
319608 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.002066733944954128 | 0.004003550600343053 | 0.01582700421940928 | 0.01895331730769231 | 0.01694038647342995 | 0.03215975935828877 | 0.03232345703125 | 0.05566184538653367 | 0.0667843729903537 | 319608 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02719115859025054 | 9
319719 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 319719 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
319731 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 319731 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
319802 | 0 | 0.09759908930973818 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2476730683340777 | 0 | 0 | 0 | 0 | 0 | 319802 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.172636078821908 | 1
506163 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.054625306639234 | 0.007202723939235202 | 0.07743962888834852 | 0.001835054789493001 | 0 | 0 | 0 | 506163 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03527567856407768 | 4
506343 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00113550708085884 | 0.0005412338153348612 | 506343 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0008383704480968504 | 2
507169 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 507169 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
507414 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 507414 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
507465 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 507465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
507488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 507488 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
507515 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 507515 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
507526 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 507526 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
728803 | 0 | 0 | 0 | 0 | 0.031474444233327 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 728803 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.031474444233327 | 1
757281 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 757281 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
776294 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 776294 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
871622 | 0 | 0 | 0 | 0 | 0 | 0 | 0.02816994763703851 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 871622 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02816994763703851 | 1
900224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900224 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900232 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.003940251459684064 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900232 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.003940251459684064 | 1
900233 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900233 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900246 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900246 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900248 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900248 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.003288977813103836 | 0.03556571207866299 | 900250 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01942734494588341 | 2
900251 | 0 | 0 | 0 | 0 | 0 | 0.007677165354330709 | 0 | 0.07123529411764706 | 0.002109375 | 0.004075471698113208 | 0.07675925925925926 | 0.03672413793103448 | 0.01366071428571429 | 0.02921810699588477 | 0.05290441176470588 | 0.05107142857142857 | 900251 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03454353649781182 | 9
900257 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900257 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900258 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900258 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900261 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00445297203140655 | 0 | 0.000661024351664955 | 0 | 0 | 0 | 0 | 0 | 900261 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002556998191535752 | 1
900268 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900268 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900274 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1633480722111133 | 0.01072702405535144 | 0 | 0 | 0.1184749048610612 | 0.01228803145736053 | 0.0103407269531048 | 0 | 0.01624880411838848 | 0.2176173233427742 | 900274 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.078434983857022 | 3
900275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900275 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900279 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900279 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900283 | 0 | 0 | 0 | 0 | 0 | 0.006119573831117373 | 0 | 0.003072625698324022 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900283 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.004596099764720698 | 1
900294 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900294 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900295 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900295 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900297 | 0 | 0 | 0 | 0 | 0.00860883694769077 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900297 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.00860883694769077 | 1
900307 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900307 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900308 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900308 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900320 | 0 | 0.0004952088543343156 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900320 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0004952088543343156 | 1
900323 | 0.01616651510558755 | 0.2574738950078673 | 0.001839249586168843 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900323 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09182655323320787 | 3
900327 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01200153080750096 | 0 | 0 | 0 | 0.005360333531864205 | 900327 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.008680932169682581 | 1
900336 | 0 | 0 | 0 | 0 | 0 | 0 | 0.04728058833037013 | 0.124988416988417 | 0 | 0 | 0.08313501225446666 | 0.0304703865930299 | 0.01907422829970717 | 0 | 0 | 0 | 900336 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06098972649319818 | 3
900339 | 0 | 0 | 0 | 0 | 0 | 0 | 0.04391251937317031 | 0 | 0.1824988301357043 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900339 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1132056747544373 | 1
900345 | 0 | 0 | 0.08422526306281895 | 0.007645132875733351 | 0 | 0 | 0 | 0.0577574877222107 | 0 | 0.05048781467057454 | 0 | 0 | 0.05047573379097998 | 0 | 0.005904761904761905 | 0.3844449537779815 | 900345 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09156302111500869 | 2
900346 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.005813728150071702 | 0 | 0 | 0 | 0 | 0 | 900346 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.005813728150071702 | 1
900350 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900350 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900352 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900352 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900358 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.04791262191037388 | 0.06356394587516369 | 0.0001781594348782726 | 0 | 0 | 0 | 0.0006490222749853294 | 0 | 0 | 900358 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02807593737385029 | 3
900365 | 0 | 0 | 0 | 0 | 0 | 0 | 0.007945635128071093 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900365 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.007945635128071093 | 1
900369 | 0 | 0 | 0.001029336078229542 | 0 | 0 | 0 | 0.1065147386673272 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900369 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05377203737277838 | 1
900393 | 0 | 0 | 0 | 0 | 0 | 0 | 0.02914766748509295 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900393 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02914766748509295 | 1
900394 | 0.001242544731610338 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900394 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.001242544731610338 | 1
900396 | 0.174100292927884 | 0.03318866479448557 | 0 | 0 | 0 | 0 | 0.01370500964673009 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900396 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07366465578969987 | 2
900433 | 0.001639828146010298 | 0.1258169934640523 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900433 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06372841080503129 | 2
900437 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900437 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900440 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900440 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900452 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900452 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900453 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900453 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900461 | 0 | 0 | 0 | 0 | 0.002492601866605964 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900461 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002492601866605964 | 1
900465 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900465 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900476 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.009899389874338357 | 0.04562128745135281 | 0.02478271895244023 | 0.002753461904707273 | 900476 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.02076421454570967 | 4
900483 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900483 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900493 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.06277435689993557 | 0.1363215791096947 | 900493 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.09954796800481512 | 2
900494 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900494 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900509 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01774891774891775 | 0.009799554565701559 | 900509 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.01377423615730965 | 2
900511 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900511 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900512 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900515 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.003006012024048096 | 0 | 0.001037303012168362 | 0.003562696472231925 | 900515 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.002535337169482794 | 2
900541 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900541 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
900552 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3130847235852143 | 0.01924895688456189 | 0 | 0 | 0 | 0 | 0 | 900552 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1661668402348881 | 2
900557 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 900557 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0