{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"data","index":0,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["2019-08-01","1900-01-31","activity","goal 1","goal 2","goal 3","jogging","weight","bedtime",null,{"$f":"DATE( YEAR(day_1), MONTH(day_1)+1, 1)","v":"2019-09-01"},{"$f":"MAX( MIN(TODAY(), K32) - K$1 + 1, 0 )","v":"1900-01-14"},{"$f":"C1","v":"activity"},"goal 1","goal 2","goal 3","jogging","weight","bedtime",null,{"$f":"DATE( YEAR(day_1), MONTH(day_1)+2, 1)","v":"2019-10-01"},{"$f":"MAX( MIN(TODAY(), U32) - U$1 + 1, 0 )","v":"00:00:00"},{"$f":"C1","v":"activity"},"goal 1","goal 2","goal 3","jogging","weight","bedtime"]
[{"$f":"day_1+ROW()-2","v":"2019-08-01"},null,null,"II","✓","✓",null,67.215711599785706,"22:56:24.578",null,{"$f":"K$1+ROW()-2","v":"2019-09-01"},"W","Soccer",null,null,null,null,null,null,null,{"$f":"U$1+ROW()-2","v":"2019-10-01"},null,"Spanish"]
["2019-08-02",null,null,"I","✓","✓",null,67.389371184032072,"22:11:11.461",null,"2019-09-02",null,null,null,null,null,null,null,null,null,"2019-10-02"]
["2019-08-03","W","Shopping","II","✓",null,"✔",66.013610544797984,"21:43:05.436",null,"2019-09-03",null,"Spanish",null,null,null,null,null,null,null,"2019-10-03"]
["2019-08-04","W","Soccer","II","✓","✓",null,67.068960467756682,"21:39:20.614",null,"2019-09-04",null,null,null,null,null,null,null,null,null,"2019-10-04"]
["2019-08-05",null,null,"II","✓","✓",null,66.222014426749439,"22:29:51.181",null,"2019-09-05",null,null,null,null,null,null,null,null,null,"2019-10-05","W","Shopping"]
["2019-08-06",null,"Spanish","III",null,"✓",null,66.00592476135202,"22:10:22.143",null,"2019-09-06",null,null,null,null,null,null,null,null,null,"2019-10-06","W","Soccer"]
["2019-08-07",null,null,"I",null,null,"✓",66.695167940358715,"22:57:15.179",null,"2019-09-07","W","Shopping",null,null,null,null,null,null,null,"2019-10-07"]
["2019-08-08",null,"Festival","II",null,"✓",null,66.327484735062541,"21:14:50.736",null,"2019-09-08","W","Soccer",null,null,null,null,null,null,null,"2019-10-08",null,"Spanish"]
["2019-08-09",null,null,"I","✓","✓","✔",66.082011994135868,"21:48:07.774",null,"2019-09-09",null,null,null,null,null,null,null,null,null,"2019-10-09"]
["2019-08-10","W","Shopping","II",null,"✓",null,67.472128881125286,"22:13:32.415",null,"2019-09-10",null,"Spanish",null,null,null,null,null,null,null,"2019-10-10"]
["2019-08-11","W","Soccer","III",null,null,"✓",66.694944879533637,"22:24:46.755",null,"2019-09-11",null,null,null,null,null,null,null,null,null,"2019-10-11"]
["2019-08-12","H",null,"II","✓","✓",null,67.104601030980049,"22:54:20.076",null,"2019-09-12",null,null,null,null,null,null,null,null,null,"2019-10-12","W","Shopping"]
["2019-08-13","H","Spanish","II",null,null,"✓",66.196160768328596,"22:34:11.496",null,"2019-09-13",null,null,null,null,null,null,null,null,null,"2019-10-13","W","Soccer"]
["2019-08-14","H",null,"I","✓","✓","✔",67.199003381619178,"21:58:06.784",null,"2019-09-14","W","Shopping",null,null,null,null,null,null,null,"2019-10-14"]
["2019-08-15","H","Festival","III",null,"✓",null,67.185364952834774,"22:39:46.460",null,"2019-09-15","W","Soccer",null,null,null,null,null,null,null,"2019-10-15",null,"Spanish"]
["2019-08-16","H",null,"I",null,null,null,66.307329584367864,"21:17:13.780",null,"2019-09-16",null,null,null,null,null,null,null,null,null,"2019-10-16"]
["2019-08-17","W","Shopping","II","✓","✓","✔",66.609170310998735,"21:56:40.052",null,"2019-09-17",null,"Spanish",null,null,null,null,null,null,null,"2019-10-17"]
["2019-08-18","W","Soccer",null,null,null,null,null,null,null,"2019-09-18",null,null,null,null,null,null,null,null,null,"2019-10-18"]
["2019-08-19",null,null,null,null,null,null,null,null,null,"2019-09-19",null,null,null,null,null,null,null,null,null,"2019-10-19","W","Shopping"]
["2019-08-20",null,"Spanish",null,null,null,null,null,null,null,"2019-09-20",null,null,null,null,null,null,null,null,null,"2019-10-20","W","Soccer"]
["2019-08-21",null,null,null,null,null,null,null,null,null,"2019-09-21","W","Shopping",null,null,null,null,null,null,null,"2019-10-21","H"]
["2019-08-22",null,null,null,null,null,null,null,null,null,"2019-09-22","W","Soccer",null,null,null,null,null,null,null,"2019-10-22","H","Spanish"]
["2019-08-23",null,"Movies",null,null,null,null,null,null,null,"2019-09-23",null,null,null,null,null,null,null,null,null,"2019-10-23","H"]
["2019-08-24","W","Shopping",null,null,null,null,null,null,null,"2019-09-24",null,"Spanish",null,null,null,null,null,null,null,"2019-10-24","H"]
["2019-08-25","W","Soccer",null,null,null,null,null,null,null,"2019-09-25",null,null,null,null,null,null,null,null,null,"2019-10-25","H"]
["2019-08-26",null,null,null,null,null,null,null,null,null,"2019-09-26",null,null,null,null,null,null,null,null,null,"2019-10-26","W","Shopping"]
["2019-08-27",null,"Spanish",null,null,null,null,null,null,null,"2019-09-27",null,null,null,null,null,null,null,null,null,"2019-10-27","W","Soccer"]
["2019-08-28",null,null,null,null,null,null,null,null,null,"2019-09-28","W","Shopping",null,null,null,null,null,null,null,"2019-10-28"]
["2019-08-29",null,null,null,null,null,null,null,null,null,"2019-09-29","W","Soccer",null,null,null,null,null,null,null,"2019-10-29",null,"Spanish"]
["2019-08-30",null,null,null,null,null,null,null,null,null,"2019-09-30",null,null,null,null,null,null,null,null,null,"2019-10-30"]
["2019-08-31","W","Shopping",null,null,null,null,null,null,null,"2019-10-01",null,null,null,null,null,null,null,null,null,"2019-10-31"]
["Average",null,null,{"$f":"IFERROR( REPT( \"I\", ROUND( SUM( LEN( D2:D32 )) / B$1, 0 )), \"\" )","v":"I"},{"$f":"IFERROR( REPT( \"✓\", ROUND( SUM( LEN( E2:E32 )) / B$1, 0 )), \"\" )","v":""},{"$f":"IFERROR( REPT( \"✓\", ROUND( SUM( LEN( F2:F32 )) / B$1, 0 )), \"\" )","v":""},null,{"$f":"IFERROR( _xlfn.AGGREGATE( 1, 6, H2:H32 ), 0)","v":66.693468320224653},{"$f":"IFERROR( SUM( IF( I2:I32 = \"\", 0, I2:I32 + IF( I2:I32 < 8/32, 1, 0 ))) / COUNTIF( I2:I32, \"<>\"), 0)","v":"22:11:07.466"},null,null,null,null,{"$f":"IFERROR( REPT( \"I\", ROUND( SUM( LEN( N2:N32 )) / L$1, 0 )), \"\" )","v":""},{"$f":"IFERROR( REPT( \"✓\", ROUND( SUM( LEN( O2:O32 )) / L$1, 0 )), \"\" )","v":""},{"$f":"IFERROR( REPT( \"✓\", ROUND( SUM( LEN( P2:P32 )) / L$1, 0 )), \"\" )","v":""},null,{"$f":"IFERROR( _xlfn.AGGREGATE( 1, 6, R2:R32 ), 0)","v":0},{"$f":"IFERROR( SUM( IF( S2:S32 = \"\", 0, S2:S32 + IF( S2:S32 < 8/32, 1, 0 ))) / COUNTIF( S2:S32, \"<>\"), 0)","v":"00:00:00"},null,null,null,null,{"$f":"IFERROR( REPT( \"I\", ROUND( SUM( LEN( X2:X32 )) / V$1, 0 )), \"\" )","v":""},{"$f":"IFERROR( REPT( \"✓\", ROUND( SUM( LEN( Y2:Y32 )) / V$1, 0 )), \"\" )","v":""},{"$f":"IFERROR( REPT( \"✓\", ROUND( SUM( LEN( Z2:Z32 )) / V$1, 0 )), \"\" )","v":""},null,{"$f":"IFERROR( _xlfn.AGGREGATE( 1, 6, AB2:AB32 ), 0)","v":0},{"$f":"IFERROR( SUM( IF( AC2:AC32 = \"\", 0, AC2:AC32 + IF( AC2:AC32 < 8/32, 1, 0 ))) / COUNTIF( AC2:AC32, \"<>\"), 0)","v":"00:00:00"}]
["Weekly tasks",null,null,null,"Legend",null,null,null,null,null,null,"Target goals",null,null,null,null,"Input methods"]
["- task 1",null,null,null,"W is \"Weekend\", H is \"Holiday\" (green bands)",null,null,null,null,null,null,"goal 1: II",null,null,null,null,"change the start date in cell A1"]
["- task 2",null,null,null,"goal 1: I is \"1x a day\", II is \"2x a day\"",null,null,null,null,null,null,"goals 2, 3: ✓",null,null,null,null,"apply W and H",null,null,null,null,null,{"$f":"C1","v":"activity"},{"$f":"D1","v":"goal 1"},{"$f":"E1","v":"goal 2"},{"$f":"F1","v":"goal 3"},null,{"$f":"H1","v":"weight"},{"$f":"I1","v":"bedtime"}]
["- task 3",null,null,null,"goals 2, 3: ✓ is \"yes\"",null,null,null,null,null,null,"jogging: each day, alternating ✔ en ✓",null,null,null,null,"activity, weight, bedtime: data input",null,null,null,null,null,{"$f":"REPT( \"I\", ROUND( SUM( LEN( D2:D32 ), LEN( N2:N32 ), LEN( X2:X32 )) / SUM(B$1, L$1, V$1 ), 0 ))","v":"I"},{"$f":"REPT( \"✓\", ROUND( SUM( LEN( D2:D32 ), LEN( N2:N32 ), LEN( X2:X32 )) / SUM( $B$1, $L$1, $V$1 ), 0 ))","v":"✓"},{"$f":"REPT( \"✓\", ROUND( SUM( LEN( E2:E32 ), LEN( O2:O32 ), LEN( Y2:Y32 )) / SUM( $B$1, $L$1, $V$1 ), 0 ))","v":""},{"$f":"REPT( \"✓\", ROUND( SUM( LEN( F2:F32 ), LEN( P2:P32 ), LEN( Z2:Z32 )) / SUM( $B$1, $L$1, $V$1 ), 0 ))","v":""},null,{"$f":"IFERROR( _xlfn.AGGREGATE( 1, 6, H2:H32, R2:R32, AB2:AB32 ), 0)","v":66.693468320224653},{"$f":"IFERROR( ( SUM( IF( I2:I32= \"\", 0, I2:I32 + IF( I2:I32 < 8/32, 1, 0 ))) +SUM( IF( S2:S32= \"\", 0, S2:S32 + IF( S2:S32 < 8/32, 1, 0 ))) +SUM( IF( AC2:AC32= \"\", 0, AC2:AC32 + IF( AC2:AC32 < 8/32, 1, 0 ))) ) / ( COUNTIF( I2:I32, \"<>\") + COUNTIF( S2:S32, \"<>\") + COUNTIF( AC2:AC32, \"<>\") ), 0)","v":"22:11:07.466"}]
["- task 4",null,null,null,"jogging: ✔ is \"jogging\", ✓ is \"walking\"",null,null,null,null,null,null,"weight: ... kg",null,null,null,null,"other input: double click the cell"]
["- task 5",null,null,null,"weight: in kg, bedtime in hours",null,null,null,null,null,null,"bedtime: … PM",null,null,null,null,"add (sports) activities"]