{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["活动跟踪器","活动清单"],"not_rendered":{"charts":1,"defined_names":15},"read":"whole","date_system":"1900"}

{"sheet":"活动跟踪器","index":0,"n_rows":23,"n_cols":11,"rows_kept":23,"merged":[[0,0,0,2],[0,3,3,10],[1,0,1,2],[2,0,5,0],[2,1,3,1],[4,1,5,1],[6,0,9,0],[6,1,7,1],[8,1,9,1],[10,0,13,0],[10,1,11,1],[12,1,13,1],[14,0,17,0],[14,1,15,1],[16,1,17,1],[18,0,21,0],[18,1,19,1],[20,1,21,1],[22,0,23,0],[22,1,23,1],[22,2,23,2]]}
["活动跟踪器"]
["跟踪你的前 5 项活动！使用最擅长的活动更换以下活动信息。然后将它们的条目添加到活动记录中，从而跟踪进度。"]
["骑自行车",{"$f":"SUMIF(列表[活动],类别1,列表[总计])","v":{"v":19.46,"d":"19.5"}}]
[null,null,"英里"]
[null,{"$f":"SUMIF(列表[活动],类别1,列表[卡路里])","v":847},"卡路里","日期","活动","开始时间","时长","总计","单位","卡路里","备注"]
[{"$nulls":3},"日期","骑自行车","16:00:00","00:23:00",3.66,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"英里"},173,"天气炎热且潮湿"]
["游泳",{"$f":"SUMIF(列表[活动],类别2,列表[总计])","v":{"v":1700,"d":"1700.0"}},null,"日期","骑自行车","14:30:00","00:45:00",7.8,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"英里"},330,"凉爽的下午"]
[null,null,"米","日期","游泳","10:00:00","00:30:00",1700,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"米"},237,"昨晚睡眠质量好"]
[null,{"$f":"SUMIF(列表[活动],类别2,列表[卡路里])","v":237},"卡路里","日期","活动 3","13:30:00","00:35:00",3227,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"步数"},150]
[{"$nulls":3},"日期","活动 4","05:30:00","00:30:00",30,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"次数"},115]
["活动 3",{"$f":"SUMIF(列表[活动],类别3,列表[总计])","v":{"v":3227,"d":"3227.0"}},null,"日期","活动 5","06:00:00","00:45:00",5,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"英里"},345]
[null,null,"步数","日期","骑自行车","10:00:00","00:40:00",8,{"$f":"IFERROR(VLOOKUP(列表[[#This Row],[活动]],活动查找,2,FALSE),\"\")","v":"英里"},344]
[null,{"$f":"SUMIF(列表[活动],类别3,列表[卡路里])","v":150},"卡路里"]
[]
["活动 4",{"$f":"SUMIF(列表[活动],类别4,列表[总计])","v":{"v":30,"d":"30.0"}}]
[null,null,"次数"]
[null,{"$f":"SUMIF(列表[活动],类别4,列表[卡路里])","v":115},"卡路里"]
[]
["活动 5",{"$f":"SUMIF(列表[活动],类别5,列表[总计])","v":{"v":5,"d":"5.0"}}]
[null,null,"英里"]
[null,{"$f":"SUMIF(列表[活动],类别5,列表[卡路里])","v":345},"卡路里"]
[]
["汇总",{"$f":"SUM(B21,B17,B13,B9,B5)","v":1694},"卡路里"]

{"sheet":"活动清单","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"hidden":true,"merged":[[0,1,0,2],[1,1,1,2]]}
[null,"活动清单"]
[null,"下表绑定到自定义活动并填充活动记录上的下拉列表。此工作表应继续保持隐藏状态。"]
[null,"活动","单位"]
[null,{"$f":"TRIM(类别1)","v":"骑自行车"},{"$f":"类别1单位","v":"英里"}]
[null,{"$f":"TRIM(类别2)","v":"游泳"},{"$f":"类别2单位","v":"米"}]
[null,{"$f":"TRIM(类别3)","v":"活动 3"},{"$f":"类别3单位","v":"步数"}]
[null,{"$f":"TRIM(类别4)","v":"活动 4"},{"$f":"类别4单位","v":"次数"}]
[null,{"$f":"TRIM(类别5)","v":"活动 5"},{"$f":"类别5单位","v":"英里"}]