Spreadsheet: 587454d1535035038-index-match-issues-copy-of-excelforum-coachk88-
Sheet: Visualizations

Week | (All)
Position | Forward
Row Labels | Average of Physical Prep Load | Average of Individual Load | Average of EWMA A:C
2018-07-02 00:00:00 | 600 | 0 | 1
2018-07-03 00:00:00 | 300 | 251.25 | 0.9862622658340767
2018-07-04 00:00:00 | 0 | 0 | 0.7670928734265041
2018-07-05 00:00:00 | 731.25 | 360 | 1.051013250091723
2018-07-06 00:00:00 | 280 | 0 | 0.9313090992983494
2018-07-07 00:00:00 | 0 | 0 | 0.7243515216764939
2018-07-08 00:00:00 | 0 | 0 | 0.5633845168594952
2018-07-09 00:00:00 | 300 | 360 | 0.7881033519114575
2018-07-10 00:00:00 | 206.5 | 300 | 0.8641699061869059
2018-07-11 00:00:00 | 388.5 | 0 | 0.8657747970102327
2018-07-12 00:00:00 | 0 | 0 | 0.6733803976746254
2018-07-13 00:00:00 | 397.5 | 0 | 0.7551461214339381
2018-07-14 00:00:00 | 0 | 0 | 0.5873358722263962
2018-07-15 00:00:00 | 0 | 0 | 0.4568167895094193
2018-07-16 00:00:00 | 603.25 | 300 | 0.9582918636549773
2018-07-17 00:00:00 | 400 | 330 | 1.134236865052709
2018-07-18 00:00:00 | 720 | 0 | 1.215568812351213
2018-07-19 00:00:00 | 0 | 0 | 0.945442409606499
2018-07-20 00:00:00 | 676.5 | 0 | 1.08060734351417
2018-07-21 00:00:00 | 0 | 0 | 0.8404723782887985
2018-07-22 00:00:00 | 0 | 0 | 0.6537007386690654
2018-07-23 00:00:00 | 297.5 | 300 | 0.9004163314909375
2018-07-24 00:00:00 | 0 | 300 | 0.8866309557291678
2018-07-25 00:00:00 | 532 | 0 | 0.9819306980151725
2018-07-26 00:00:00 | 0 | 0 | 0.763723876234023
2018-07-27 00:00:00 | 631.75 | 0 | 0.9419611016880407
Grand Total | 271.7211538461539 | 96.20192307692308 | 0.858350928362862
Athlete | (All)
Week | (All)
Row Labels | Average of Physical Prep Load | Average of Individual Load | Average of TSB
2018-07-02 00:00:00 | 510 | 0
2018-07-03 00:00:00 | 287.5 | 353.75 | -31.5
2018-07-04 00:00:00 | 0 | 0 | 86.25000000000004
2018-07-05 00:00:00 | 692.25 | 345 | -52.9124999999999
2018-07-06 00:00:00 | 293.3333333333333 | 0 | 9.78583333333343
2018-07-07 00:00:00 | 0 | 0 | 107.6588750000001
2018-07-08 00:00:00 | 0 | 0 | 166.0891250000001
2018-07-09 00:00:00 | 500 | 360 | 25.9175087500001
2018-07-10 00:00:00 | 288.8333333333333 | 315 | -11.93480141666656
2018-07-11 00:00:00 | 462.5 | 0 | -7.157046112499899
2018-07-12 00:00:00 | 0 | 0 | 88.56765111250012
2018-07-13 00:00:00 | 432.8333333333333 | 0 | 59.65051416420845
2018-07-14 00:00:00 | 0 | 0 | 126.2098691285251
2018-07-15 00:00:00 | 0 | 0 | 164.3559666821889
2018-07-16 00:00:00 | 666.75 | 305 | -10.89267085946862
2018-07-17 00:00:00 | 384 | 325 | -68.42253238492877
2018-07-18 00:00:00 | 670 | 0 | -94.81366917442081
2018-07-19 00:00:00 | 0 | 0 | 25.40432472343184
2018-07-20 00:00:00 | 615 | 0 | -22.62046886262396
2018-07-21 00:00:00 | 0 | 0 | 70.80252524403961
2018-07-22 00:00:00 | 0 | 0 | 127.5349357739165
2018-07-23 00:00:00 | 297.5 | 320 | 35.95030633452143
2018-07-24 00:00:00 | 0 | 300 | 40.6734805976669
2018-07-25 00:00:00 | 631.75 | 0 | -23.92112403448143
2018-07-26 00:00:00 | 0 | 0 | 62.45190876829954
2018-07-27 00:00:00 | 698.25 | 0 | -24.65663782899741
Grand Total | 285.7884615384615 | 100.9134615384615 | 34.37804190356555
Row Labels | Average of Physical Prep Load | Average of Practice Load | Average of Individual Load | Average of Game Load | Average of Monotony | Average of Strain | Average of 28 Day RA | Average of RA A:C | Average of 7 Day RA
Week 1 | 254.7261904761905 | 0 | 99.82142857142857 | 0 | 1.265387639859354 | 2249.585815592933 | 468.7218820861678 | 1 | 468.7218820861678
2018-07-02 00:00:00 | 510 | 0 | 0 | 0 | 1.376824340813755 | 839.0529512253238 | 510 | 1 | 510
2018-07-03 00:00:00 | 287.5 | 0 | 353.75 | 0 | 1.553989237609643 | 1868.305073796518 | 575.625 | 1 | 575.625
2018-07-04 00:00:00 | 0 | 0 | 0 | 0 | 1.035992825073095 | 1245.536715864346 | 383.75 | 1 | 383.75
2018-07-05 00:00:00 | 692.25 | 0 | 345 | 0 | 1.477049053858286 | 3264.433301765153 | 547.125 | 1 | 547.125
2018-07-06 00:00:00 | 293.3333333333333 | 0 | 0 | 0 | 1.340019036539714 | 3348.13506535482 | 496.3666666666667 | 1 | 496.3666666666667
2018-07-07 00:00:00 | 0 | 0 | 0 | 0 | 1.116682530449762 | 2790.11255446235 | 413.6388888888889 | 1 | 413.6388888888889
2018-07-08 00:00:00 | 0 | 0 | 0 | 0 | 0.9571564546712246 | 2391.525046682014 | 354.5476190476191 | 1 | 354.5476190476191
Week 2 | 240.5952380952381 | 0 | 96.42857142857143 | 0 | 1.001645676568268 | 2722.50334299397 | 402.7546659028801 | 0.9144889601361468 | 371.0272108843536
2018-07-09 00:00:00 | 500 | 0 | 360 | 0 | 1.092139233182377 | 3121.511912870327 | 417.7291666666667 | 0.9708835465259401 | 404.5476190476191
2018-07-10 00:00:00 | 288.8333333333333 | 0 | 315 | 0 | 1.077708931384399 | 3065.775755991449 | 438.4074074074074 | 0.9096577041940844 | 399.202380952381
2018-07-11 00:00:00 | 462.5 | 0 | 0 | 0 | 1.25607903155985 | 4169.472857445086 | 440.8166666666667 | 1.053256508446838 | 465.2738095238096
2018-07-12 00:00:00 | 0 | 0 | 0 | 0 | 0.8560479258150134 | 1982.79494363727 | 400.7424242424242 | 0.7831023222506186 | 317.0952380952381
2018-07-13 00:00:00 | 432.8333333333333 | 0 | 0 | 0 | 0.9098482046787444 | 2239.322643671222 | 403.4166666666667 | 0.8260069660109374 | 337.0238095238095
2018-07-14 00:00:00 | 0 | 0 | 0 | 0 | 0.9098482046787444 | 2239.322643671222 | 372.3846153846154 | 0.894840879845182 | 337.0238095238095
2018-07-15 00:00:00 | 0 | 0 | 0 | 0 | 0.9098482046787444 | 2239.322643671222 | 345.7857142857143 | 0.9636747936794269 | 337.0238095238095
Week 3 | 333.6785714285714 | 0 | 90 | 0 | 1.074981728308357 | 3065.252197278362 | 398.668700703966 | 1.000068388134117 | 398.1921768707482
2018-07-16 00:00:00 | 666.75 | 0 | 305 | 0 | 0.9529462775319479 | 2434.447288396829 | 387.5166666666667 | 0.9043198415231298 | 352.9880952380952
2018-07-17 00:00:00 | 384 | 0 | 325 | 0 | 0.9935053885988706 | 2587.073473054633 | 407.609375 | 0.9038771219817726 | 368.0119047619048
2018-07-18 00:00:00 | 670 | 0 | 0 | 0 | 1.073530893001911 | 3028.782247157655 | 423.0441176470588 | 0.9406040444424915 | 397.6547619047619
2018-07-19 00:00:00 | 0 | 0 | 0 | 0 | 1.073530893001911 | 3028.782247157655 | 399.5416666666667 | 0.9959336941155791 | 397.6547619047619
2018-07-20 00:00:00 | 615 | 0 | 0 | 0 | 1.143786215341287 | 3459.226708393921 | 410.8815789473684 | 1.030985604710685 | 423.6785714285714
2018-07-21 00:00:00 | 0 | 0 | 0 | 0 | 1.143786215341287 | 3459.226708393921 | 390.3374999999999 | 1.085248004958616 | 423.6785714285714
2018-07-22 00:00:00 | 0 | 0 | 0 | 0 | 1.143786215341287 | 3459.226708393921 | 371.7500000000001 | 1.139510405206547 | 423.6785714285714
Week 4 | 325.5 | 0 | 124 | 0 | 0.8785450555668728 | 2094.928518743698 | 382.6021856694032 | 0.8453480211110488 | 325.4285714285714
2018-07-23 00:00:00 | 297.5 | 0 | 320 | 0 | 1.007164360233928 | 2697.799042798412 | 382.9204545454546 | 0.9743217155703241 | 373.0714285714285
2018-07-24 00:00:00 | 0 | 0 | 300 | 0 | 0.8494273419166095 | 1925.38773209918 | 379.3152173913044 | 0.8276807542380881 | 314.6428571428572
2018-07-25 00:00:00 | 631.75 | 0 | 0 | 0 | 0.8346756525507476 | 1887.828163342073 | 389.8333333333333 | 0.7874346728525164 | 309.1785714285714
2018-07-26 00:00:00 | 0 | 0 | 0 | 0 | 0.8346756525507476 | 1887.828163342073 | 374.2400000000001 | 0.8202444508880378 | 309.1785714285714
2018-07-27 00:00:00 | 698.25 | 0 | 0 | 0 | 0.8667822705823292 | 2075.799492136752 | 386.7019230769231 | 0.817058512006278 | 321.0714285714286
Grand Total | 285.7884615384615 | 0 | 100.9134615384615 | 0 | 1.06872425349947 | 2566.770464799053 | 415.5395257383889 | 0.9470858473355784 | 395.874297924298