{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["使い方","歩数管理表","database"],"not_rendered":{"charts":3,"images":5,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"使い方","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"merged":[[2,1,2,6],[2,8,2,13],[2,15,2,20],[12,22,12,25],[13,22,14,24],[13,25,14,25],[16,22,16,25],[17,22,18,24],[17,25,18,25],[20,22,20,25],[21,22,22,24],[21,25,22,25],[24,22,24,25],[25,22,26,24],[25,25,26,25],[28,22,28,25],[29,22,30,24],[29,25,30,25],[32,22,32,25],[33,22,34,22],[33,23,34,24],[33,25,34,25],[39,1,39,8],[39,9,39,25]]}

{"sheet":"歩数管理表","index":1,"n_rows":140,"n_cols":26,"rows_kept":140,"merged":[[2,20,6,25],[8,22,8,25],[9,22,10,24],[9,25,10,25],[12,22,12,25],[13,22,14,24],[13,25,14,25],[16,22,16,25],[17,22,18,24],[17,25,18,25],[20,22,20,25],[21,22,22,24],[21,25,22,25],[24,3,31,5],[24,10,31,12],[24,17,31,19],[24,22,24,25],[25,22,26,24],[25,25,26,25],[28,22,28,25],[29,22,30,22],[29,23,30,24],[29,25,30,25],[37,1,37,6],[60,23,69,25],[72,1,72,6],[95,23,104,25],[107,1,107,6],[130,23,139,25]]}
[null,"ウォーキング歩数管理表 - 東海道 552.6km の旅 -"]
[]
[{"$nulls":20},{"$f":"database!D2","v":"新横浜駅に向かっています。"}]
[]
[]
[]
[]
[]
[{"$nulls":22},"ウォーキングを始める前の体重"]
[{"$nulls":22},50,null,null,"kg"]
[]
[]
[{"$nulls":22},"目標体重"]
[{"$nulls":22},45,null,null,"kg"]
[]
[]
[{"$nulls":22},"記録日数"]
[{"$nulls":22},{"$f":"COUNT(D40:D70,D75:D105,D110:D140)","v":4},null,null,"日"]
[]
[]
[{"$nulls":22},"今までの歩数合計"]
[{"$nulls":22},{"$f":"SUM(D40:D70,D75:D105,D110:D140)","v":{"v":23000,"d":"23,000"}},null,null,"歩"]
[]
[]
[{"$nulls":3},"6月をみる",{"$nulls":6},"7月をみる",{"$nulls":6},"8月をみる",{"$nulls":4},"1日の平均歩数"]
[{"$nulls":22},{"$f":"IFERROR(AVERAGE(D40:D70,D75:D105,D110:D140),\"\")","v":{"v":5750,"d":"5,750"}},null,null,"歩"]
[]
[]
[{"$nulls":22},"今までの消費カロリー"]
[{"$nulls":22},"約",{"$f":"SUM(G40:G70,G75:G105,G110:G140)","v":{"v":748,"d":"748.0"}},null,"kcal"]
[]
[{"$nulls":22},"※「消費カロリー」はウォーキング6000歩=1時間、METS係数４としてMETS法で計算されます。"]
[]
[]
[]
[]
[]
[null,"6月"]
[null,"日付","曜日","歩数（歩）","体重（kg）","増減","消費カロリー"]
[null,1,"水",3000,50,null,{"$f":"IF(D40=\"\",\"\",E40*4*(D40/6000))","v":{"v":100,"d":"100.0"}}]
[null,2,"木",2000,50,{"$f":"IF(E41=\"\",\"\",E41-E40)","v":0},{"$f":"IF(D41=\"\",\"\",E41*4*(D41/6000))","v":{"v":66.66666666666666,"d":"66.7"}}]
[null,3,"金",8000,49,{"$f":"IF(E42=\"\",\"\",E42-E41)","v":-1},{"v":261.3333333333333,"d":"261.3"}]
[null,4,"土",10000,48,{"$f":"IF(E43=\"\",\"\",E43-E42)","v":-1},{"v":320,"d":"320.0"}]
[null,5,"日",null,null,{"$f":"IF(E44=\"\",\"\",E44-E43)","v":""},""]
[null,6,"月",null,null,"",""]
[null,7,"火",null,null,"",""]
[null,8,"水",null,null,"",""]
[null,9,"木",null,null,"",""]
[null,10,"金",null,null,"",""]
[null,11,"土",null,null,"",""]
[null,12,"日",null,null,"",""]
[null,13,"月",null,null,"",""]
[null,14,"火",null,null,"",""]
[null,15,"水",null,null,"",""]
[null,16,"木",null,null,"",""]
[null,17,"金",null,null,"",""]
[null,18,"土",null,null,"",""]
[null,19,"日",null,null,"",""]
[null,20,"月",null,null,"",""]
[null,21,"火",null,null,"",""]
[null,22,"水",null,null,"","",{"$nulls":16},"路線図をみる"]
[null,23,"木",null,null,"",""]
[null,24,"金",null,null,"",""]
[null,25,"土",null,null,"",""]
[null,26,"日",null,null,"",""]
[null,27,"月",null,null,"",""]
[null,28,"火",null,null,"",""]
[null,29,"水",null,null,"",""]
[null,30,"木",null,null,"",""]
[null,31,{"$f":"IF(E70=\"\",\"\",E70-E69)","v":""},{"$nulls":3},""]
[]
[]
[null,"7月"]
[null,"日付","曜日","歩数（歩）","体重（kg）","増減","消費カロリー"]
[null,1,"金",null,null,{"$f":"IF(E75=\"\",\"\",E75-E69)","v":""},{"$f":"IF(D75=\"\",\"\",E75*4*(D75/6000))","v":""}]
[null,2,"土",null,null,{"$f":"IF(E76=\"\",\"\",E76-E75)","v":""},{"$f":"IF(D76=\"\",\"\",E76*4*(D76/6000))","v":""}]
[null,3,"日",null,null,{"$f":"IF(E77=\"\",\"\",E77-E76)","v":""},""]
[null,4,"月",null,null,"",""]
[null,5,"火",null,null,"",""]
[null,6,"水",null,null,"",""]
[null,7,"木",null,null,"",""]
[null,8,"金",null,null,"",""]
[null,9,"土",null,null,"",""]
[null,10,"日",null,null,"",""]
[null,11,"月",null,null,"",""]
[null,12,"火",null,null,"",""]
[null,13,"水",null,null,"",""]
[null,14,"木",null,null,"",""]
[null,15,"金",null,null,"",""]
[null,16,"土",null,null,"",""]
[null,17,"日",null,null,"",""]
[null,18,"月",null,null,"",""]
[null,19,"火",null,null,"",""]
[null,20,"水",null,null,"",""]
[null,21,"木",null,null,"",""]
[null,22,"金",null,null,"","",{"$nulls":16},"路線図を見る"]
[null,23,"土",null,null,"",""]
[null,24,"日",null,null,"",""]
[null,25,"月",null,null,"",""]
[null,26,"火",null,null,"",""]
[null,27,"水",null,null,"",""]
[null,28,"木",null,null,"",""]
[null,29,"金",null,null,"",""]
[null,30,"土",null,null,"",""]
[null,31,"日",null,null,"",""]
[]
[]
[null,"8月"]
[null,"日付","曜日","歩数（歩）","体重（kg）","増減","消費カロリー"]
[null,1,"月",null,null,{"$f":"IF(E110=\"\",\"\",E110-E105)","v":""},{"$f":"IF(D110=\"\",\"\",E110*4*(D110/6000))","v":""}]
[null,2,"火",null,null,{"$f":"IF(E111=\"\",\"\",E111-E110)","v":""},{"$f":"IF(D111=\"\",\"\",E111*4*(D111/6000))","v":""}]
[null,3,"水",null,null,{"$f":"IF(E112=\"\",\"\",E112-E111)","v":""},""]
[null,4,"木",null,null,"",""]
[null,5,"金",null,null,"",""]
[null,6,"土",null,null,"",""]
[null,7,"日",null,null,"",""]
[null,8,"月",null,null,"",""]
[null,9,"火",null,null,"",""]
[null,10,"水",null,null,"",""]
[null,11,"木",null,null,"",""]
[null,12,"金",null,null,"",""]
[null,13,"土",null,null,"",""]
[null,14,"日",null,null,"",""]
[null,15,"月",null,null,"",""]
[null,16,"火",null,null,"",""]
[null,17,"水",null,null,"",""]
[null,18,"木",null,null,"",""]
[null,19,"金",null,null,"",""]
[null,20,"土",null,null,"",""]
[null,21,"日",null,null,"",""]
[null,22,"月",null,null,"","",{"$nulls":16},"路線図をみる"]
[null,23,"火",null,null,"",""]
[null,24,"水",null,null,"",""]
[null,25,"木",null,null,"",""]
[null,26,"金",null,null,"",""]
[null,27,"土",null,null,"",""]
[null,28,"日",null,null,"",""]
[null,29,"月",null,null,"",""]
[null,30,"火",null,null,"",""]
[null,31,"水",null,null,"",""]

{"sheet":"database","index":2,"n_rows":124,"n_cols":4,"rows_kept":124}
[]
[null,{"$f":"歩数管理表!W22","v":23000},"現在地→",{"$f":"VLOOKUP(B2,B4:D119,3,1)","v":"新横浜駅に向かっています。"}]
[]
[null,0,"東京駅","歩数を入力したらスタートです！"]
[null,1,null,"東京駅を出発しました。次は品川駅です。"]
[null,10300,null,"品川駅まで、あと少しです。"]
[null,11300,"品川駅","品川駅に到着しました！"]
[null,11400,null,"品川駅を出発しました。次は新横浜駅です。"]
[null,20000,null,"新横浜駅に向かっています。"]
[null,30000,null,"新横浜駅まで半分をすぎました。"]
[null,47000,null,"新横浜駅まで、あと少しです。"]
[null,48000,"新横浜駅","新横浜駅に到着しました！"]
[null,48100,null,"新横浜駅を出発しました。次は小田原駅です。"]
[null,50000,null,"小田原駅に向かっています。"]
[null,60000,null,"小田原駅に向かっています。"]
[null,70000,null,"小田原駅はまだまだ先・・・"]
[null,80000,null,"小田原駅はまだまだ先・・・"]
[null,90000,null,"小田原駅まで半分をすぎました。"]
[null,100000,null,"小田原駅まで半分をすぎました。"]
[null,110000,null,"小田原駅まで半分をすぎました。"]
[null,120000,null,"小田原駅まで、あと少しです。"]
[null,130000,null,"小田原駅まで、あと少しです。"]
[null,140000,"小田原駅","小田原駅に到着しました！"]
[null,141000,null,"小田原駅を出発しました。次は熱海駅です。"]
[null,150000,null,"熱海駅に向かっています。"]
[null,160000,null,"熱海駅まで半分をすぎました。"]
[null,170000,null,"熱海駅まで、あと少しです。"]
[null,174000,"熱海駅","熱海駅に到着しました！"]
[null,175000,null,"熱海駅を出発しました。次は三島駅です。"]
[null,180000,null,"三島駅に向かっています。"]
[null,190000,null,"三島駅まで半分をすぎました。"]
[null,200000,null,"三島駅まで、あと少しです。"]
[null,201200,"三島駅","三島駅に到着しました！"]
[null,202000,null,"三島駅を出発しました。次は新富士駅です。"]
[null,210000,null,"新富士駅に向かっています。"]
[null,220000,null,"新富士駅に向かっています。"]
[null,230000,null,"新富士駅まで半分をすぎました。"]
[null,240000,null,"新富士駅まで、あと少しです。"]
[null,244000,"新富士駅","新富士駅に到着しました！"]
[null,245000,null,"新富士駅を出発しました。次は静岡駅です。"]
[null,250000,null,"静岡駅に向かっています。"]
[null,260000,null,"静岡駅に向かっています。"]
[null,270000,null,"静岡駅はまだまだ先・・・"]
[null,280000,null,"静岡駅まで半分をすぎました。"]
[null,290000,null,"静岡駅まで、あと少しです。"]
[null,300000,null,"静岡駅まで、あと少しです。"]
[null,300400,"静岡駅","静岡駅に到着しました！"]
[null,301000,null,"静岡駅を出発しました。次は掛川駅です。"]
[null,310000,null,"静岡駅を出発しました。次は掛川駅です。"]
[null,320000,null,"掛川駅に向かっています。"]
[null,330000,null,"掛川駅に向かっています。"]
[null,340000,null,"掛川駅はまだまだ先・・・"]
[null,350000,null,"掛川駅まで半分をすぎました。"]
[null,360000,null,"掛川駅まで半分をすぎました。"]
[null,370000,null,"掛川駅まで、あと少しです。"]
[null,380000,null,"掛川駅まで、あと少しです。"]
[null,382200,"掛川駅","掛川駅に到着しました！"]
[null,390000,null,"掛川駅を出発しました。次は浜松駅です。"]
[null,400000,null,"浜松駅に向かっています。"]
[null,410000,null,"浜松駅まで半分をすぎました。"]
[null,420000,null,"浜松駅まで、あと少しです。"]
[null,428500,"浜松駅","浜松駅に到着しました！"]
[null,429000,null,"浜松駅を出発しました。次は豊橋駅です。"]
[null,430000,null,"浜松駅を出発しました。次は豊橋駅です。"]
[null,440000,null,"豊橋駅に向かっています。"]
[null,450000,null,"豊橋駅はまだまだ先・・・"]
[null,460000,null,"豊橋駅まで半分をすぎました。"]
[null,470000,null,"豊橋駅まで半分をすぎました。"]
[null,480000,null,"豊橋駅まで、あと少しです。"]
[null,489300,"豊橋駅","豊橋駅に到着しました！"]
[null,490000,null,"豊橋駅を出発しました。次は三河安城駅です。"]
[null,500000,null,"豊橋駅を出発しました。次は三河安城駅です。"]
[null,510000,null,"三河安城駅に向かっています。"]
[null,520000,null,"三河安城駅はまだまだ先・・・"]
[null,530000,null,"三河安城駅まで半分をすぎました。"]
[null,540000,null,"三河安城駅まで半分をすぎました。"]
[null,550000,null,"三河安城駅まで、あと少しです。"]
[null,560000,null,"三河安城駅まで、あと少しです。"]
[null,560500,"三河安城駅","三河安城駅に到着しました！"]
[null,561000,null,"三河安城駅を出発しました。次は名古屋駅です。"]
[null,570000,null,"名古屋駅に向かっています。"]
[null,580000,null,"名古屋駅に向かっています。"]
[null,590000,null,"名古屋駅まで半分をすぎました。"]
[null,600000,null,"名古屋駅まであと少しです。"]
[null,610000,"名古屋駅","名古屋駅に到着しました！"]
[null,611000,null,"名古屋駅を出発しました。次は岐阜羽島駅です。"]
[null,620000,null,"岐阜羽島駅に向かっています。"]
[null,630000,null,"岐阜羽島駅に向かっています。"]
[null,640000,null,"岐阜羽島駅まで半分をすぎました。"]
[null,650000,null,"岐阜羽島駅まで、あと少しです。"]
[null,660000,null,"岐阜羽島駅まで、あと少しです。"]
[null,660500,"岐阜羽島駅","岐阜羽島駅に到着しました！"]
[null,661000,null,"岐阜羽島駅を出発しました。次は米原駅です。"]
[null,670000,null,"岐阜羽島駅を出発しました。次は米原駅です。"]
[null,680000,null,"米原駅に向かっています。"]
[null,690000,null,"米原駅に向かっています。"]
[null,700000,null,"米原駅はまだまだ先・・・"]
[null,710000,null,"米原駅まで半分をすぎました。"]
[null,720000,null,"米原駅まで半分をすぎました。"]
[null,730000,null,"米原駅まで、あと少しです。"]
[null,740000,null,"米原駅まで、あと少しです。"]
[null,743200,"米原駅","米原駅に到着しました！"]
[null,744000,null,"米原駅を出発しました。次は京都駅です。"]
[null,750000,null,"米原駅を出発しました。次は京都駅です。"]
[null,760000,null,"京都駅に向かっています。"]
[null,770000,null,"京都駅に向かっています。"]
[null,780000,null,"京都駅はまだまだ先・・・"]
[null,790000,null,"京都駅はまだまだ先・・・"]
[null,800000,null,"京都駅はまだまだ先・・・"]
[null,810000,null,"京都駅まで半分をすぎました。"]
[null,820000,null,"京都駅まで半分をすぎました。"]
[null,830000,null,"京都駅まで、あと少しです。"]
[null,840000,null,"京都駅まで、あと少しです。"]
[null,850000,null,"京都駅まで、あと少しです。"]
[null,856000,"京都駅","京都駅に到着しました！"]
[null,857000,null,"京都駅を出発しました。次は新大阪駅です。"]
[null,860000,null,"京都駅を出発しました。次は新大阪駅です。"]
[null,870000,null,"新大阪駅に向かっています。"]
[null,880000,null,"新大阪駅はまだまだ先・・・"]
[null,890000,null,"新大阪駅まで半分をすぎました。"]
[null,900000,null,"新大阪駅まで半分をすぎました。"]
[null,910000,null,"新大阪駅まで、あと少しです。"]
[null,920000,null,"新大阪駅まで、あと少しです。"]
[null,921000,"新大阪駅","おめでとうございます！新大阪駅に到着しました！！"]