Spreadsheet: 695731d1600364634-find-and-keep-running-total-of-max-value-in-very-large-spreadsheet-sample-data-1-
Sheet: Sheet1

A | 2012-01-01 00:00:00 | 2012-01-08 00:00:00 | 2012-01-15 00:00:00 | 2012-01-22 00:00:00 | 2012-01-29 00:00:00 | 2012-02-05 00:00:00 | 2012-02-12 00:00:00 | 2012-02-19 00:00:00 | 2012-02-26 00:00:00 | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | 2012-04-01 00:00:00 | 2012-04-08 00:00:00 | 2012-04-15 00:00:00 | 2012-04-22 00:00:00 | 2012-04-29 00:00:00 | 2012-05-06 00:00:00 | 2012-05-13 00:00:00 | 2012-05-20 00:00:00 | 2012-05-27 00:00:00 | 2012-06-03 00:00:00 | 2012-06-10 00:00:00 | 2012-06-17 00:00:00 | 2012-06-24 00:00:00 | 2012-07-01 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | 2012-07-29 00:00:00 | 2012-08-05 00:00:00 | 2012-08-12 00:00:00 | 2012-08-19 00:00:00 | 2012-08-26 00:00:00 | 2012-09-02 00:00:00 | 2012-09-09 00:00:00 | 2012-09-16 00:00:00 | 2012-09-23 00:00:00 | 2012-09-30 00:00:00 | 2012-10-07 00:00:00 | 2012-10-14 00:00:00 | 2012-10-21 00:00:00 | 2012-10-28 00:00:00 | 2012-11-04 00:00:00 | 2012-11-11 00:00:00 | 2012-11-18 00:00:00 | 2012-11-25 00:00:00 | 2012-12-02 00:00:00 | 2012-12-09 00:00:00 | 2012-12-16 00:00:00 | 2012-12-23 00:00:00 | 2012-12-30 00:00:00 | 2013-01-06 00:00:00
B | 201.2197730993134 | 265.6560089449756 | 274.9766776247656 | 285.0952689164475 | 292.8289877039755 | 251.7294027320962 | 333.1757093594063 | 370.8017296737738 | 311.417513012852 | 316.9075412568127 | 318.2866810981282 | 278.5496980934606 | 246.7658879098818 | 257.085450065197 | 300.9941952408017 | 261.7801703206878 | 295.1527153380257 | 245.7041845099933 | 299.9148097097787 | 322.6531042362259 | 315.6928645294726 | 377.4996974464481 | 360.1503407473976 | 266.2996887505558 | 251.6630620924754 | 289.1953064506522 | 150.0650361127797 | 106.096490915187 | 313.4980062249535 | 372.7301752854908 | 399.3965351761206 | 387.2153754275477 | 399.0134684885122 | 399.4235475975783 | 342.5506951208713 | 368.9334036197505 | 392.0797682857808 | 281.1466653801887 | 319.4137175955358 | 328.1077322794306 | 281.9629295996468 | 273.9819493874983 | 351.4290194524912 | 291.904460589612 | 295.6565365002131 | 314.6417018306022 | 374.8856701921307 | 330.7049119185365 | 334.8610845760138 | 369.0359363515366 | 367.4542383868712 | 355.8926687763713 | 371.6947728888028 | 422.6568578209788
C | 46.71842491507135 | 47.80360238195703 | 46.22757103429176 | 48.30440609632105 | 47.56750322963693 | 46.0237046756347 | 43.84936856820543 | 50.13819837554856 | 41.79166665873741 | 35.7837538243366 | 35.36301593277699 | 34.37784215113852 | 34.47162985207355 | 37.36596308938469 | 37.28285440353138 | 34.5786475623586 | 33.04933909197752 | 37.72123425687427 | 40.86621470740625 | 38.0382443277519 | 41.92186035356895 | 43.70944019729441 | 49.19043586876686 | 43.51286524204099 | 46.6340086133989 | 48.99571612166214 | 47.058488345067 | 43.1611122571842 | 43.99249018037126 | 42.96398244566205 | 45.32085105091663 | 45.0630254728474 | 49.82911687803311 | 51.43486443419525 | 50.98808829479237 | 48.73278206635965 | 41.62646207809215 | 45.87178741993579 | 47.70607220347866 | 46.68984206060274 | 47.24697688587406 | 41.39764667020797 | 36.12359776092148 | 40.54039483456229 | 42.12023625882055 | 44.42813418435816 | 50.21197003571508 | 54.90065370521154 | 54.82652234162155 | 51.40375208381887 | 50.33468115814163 | 52.36878132585794 | 54.44552020880543 | 55.96847058725151
D | 38.01715413650085 | 38.8789729241081 | 37.91223405941062 | 39.18874016134613 | 39.28804649535891 | 38.32830947088295 | 36.58880177382635 | 39.80989992665934 | 35.04979199393175 | 30.3266522633012 | 29.84058417829988 | 28.17946743044623 | 29.16279074185026 | 31.68084973068343 | 31.74811776446843 | 29.26645208828309 | 28.5835106739062 | 31.91506031454112 | 33.8171585234032 | 32.27294947765382 | 34.90338267182738 | 37.96463122281779 | 40.49241354522349 | 35.90378984902759 | 38.83093864231745 | 40.52446524174699 | 34.81605488454963 | 28.82873958131639 | 28.71467918905495 | 28.92019895418827 | 31.57444087092793 | 31.75879370407459 | 34.77105208093483 | 34.2443984391396 | 35.28928309722654 | 34.30641622591938 | 31.40096540510838 | 30.1217754817149 | 30.61756998073337 | 29.25857643436872 | 31.17059711173622 | 26.36014154965607 | 25.45957804183422 | 29.11417416130477 | 29.63460535521691 | 30.4128443002807 | 31.95154168321119 | 39.93211951611182 | 38.93041834024734 | 33.49837791003107 | 31.05799383505432 | 35.1017370875124 | 39.47996530330318 | 40.24156346621253
E | 7182 | 9052 | 9741 | 8679 | 8055 | 8293 | 8400 | 9598 | 9760 | 7969 | 8232 | 8344 | 7245 | 7438 | 6578 | 7224 | 6877 | 6333 | 7958 | 6882 | 7109 | 5264 | 6702 | 7073 | 7653 | 8523 | 6477 | 7806 | 8433 | 8573 | 8086 | 8616 | 8720 | 8581 | 9044 | 7857 | 7895 | 9471 | 9537 | 12552 | 10743 | 10069 | 8251 | 8969 | 9676 | 11118 | 10595 | 8897 | 7455 | 11079 | 9244 | 5956 | 5967 | 7110
F | 225014 | 294918 | 301434 | 310540 | 295972 | 268461 | 363739 | 454881 | 373483 | 369361 | 362189 | 334826 | 265335 | 301874 | 300337 | 280973 | 333921 | 263530 | 313327 | 290875 | 341908 | 311928 | 384727 | 299454 | 313016 | 339871 | 317269 | 297450 | 315263 | 350221 | 332905 | 356606 | 367655 | 372087 | 309474 | 314940 | 353307 | 407941 | 452194 | 537972 | 472646 | 418017 | 425816 | 382894 | 430198 | 504808 | 529556 | 381273 | 333016 | 557307 | 430796 | 269909 | 287636 | 429170
G | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4287882 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
H | 55780 | 54322 | 57096 | 55684 | 58165 | 62896 | 60179 | 79436 | 61399 | 57292 | 52815 | 49473 | 50736 | 52860 | 54136 | 46190 | 58218 | 48942 | 52726 | 44337 | 50449 | 52230 | 51741 | 51582 | 58603 | 55778 | 54182 | 52517 | 53921 | 56670 | 59227 | 58728 | 59312 | 63742 | 59353 | 65873 | 63911 | 64303 | 65124 | 65882 | 67138 | 61271 | 61340 | 68485 | 65271 | 65213 | 57727 | 84739 | 63124 | 60033 | 49019 | 46535 | 74551 | 66614
I | 55179 | 56612 | 55695 | 55034 | 58054 | 63890 | 60859 | 75224 | 63978 | 58500 | 53986 | 46254 | 50786 | 56642 | 52718 | 45749 | 57891 | 50283 | 51412 | 44559 | 50544 | 52635 | 52602 | 53652 | 61634 | 53824 | 52950 | 54761 | 54302 | 55854 | 59549 | 58965 | 61570 | 62482 | 61551 | 65668 | 64284 | 63938 | 64807 | 67025 | 69240 | 61821 | 60950 | 68423 | 64753 | 66302 | 52996 | 82502 | 71169 | 61154 | 49229 | 40988 | 60056 | 82999
J | 56653 | 58302 | 57503 | 56849 | 59897 | 66128 | 62949 | 78931 | 67617 | 61403 | 55999 | 47998 | 52597 | 58621 | 54465 | 47650 | 59772 | 52564 | 53273 | 46313 | 52853 | 56597 | 55765 | 57021 | 67384 | 59615 | 55618 | 57655 | 57092 | 58932 | 63168 | 62408 | 65491 | 65725 | 64865 | 68932 | 67452 | 67680 | 68011 | 69843 | 73310 | 64780 | 63992 | 72518 | 67990 | 69873 | 55596 | 87931 | 73308 | 64292 | 51387 | 44596 | 63127 | 86438
K | 306974 | 282702 | 306171 | 296758 | 302211 | 319093 | 307042 | 425965 | 316192 | 293227 | 270083 | 260464 | 263863 | 282627 | 287439 | 256075 | 304728 | 270896 | 289822 | 249181 | 291892 | 302732 | 310171 | 306651 | 353492 | 341780 | 324910 | 308181 | 314506 | 342777 | 358152 | 371374 | 379669 | 403840 | 367925 | 403890 | 391564 | 404072 | 413578 | 421764 | 443605 | 369308 | 369529 | 436502 | 397181 | 418532 | 374993 | 588156 | 378605 | 399663 | 304503 | 297533 | 507762 | 414611
L | 301291 | 297336 | 296885 | 291220 | 305752 | 321754 | 311378 | 390137 | 331387 | 301827 | 276659 | 234293 | 265412 | 305321 | 275117 | 261146 | 293737 | 280844 | 280001 | 249548 | 286673 | 303427 | 315444 | 307307 | 358415 | 343117 | 313826 | 320110 | 317972 | 330900 | 358434 | 360287 | 397156 | 385081 | 388156 | 399044 | 389729 | 400913 | 404121 | 426430 | 463739 | 370961 | 368935 | 436151 | 392644 | 423421 | 320265 | 591330 | 419390 | 403631 | 302371 | 273121 | 417822 | 535447
 | 1
C | 1
D | 1
E | 1
F | 1
G | 1
H | 1
I | 1
J | 1
K | 1
L | 1