{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["数字をあてる","コード"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"数字をあてる","index":0,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[25,3,25,4]]}
[]
[null,null,null,null,null,"正解数"]
[null,null,null,null,null,0]
[]
[null,null,{"$f":"\"1から\"&コード!C3&\"までの数字でいくつか当てよう\"","v":"1から10までの数字でいくつか当てよう"}]
[null,null,null,null,null,"予想","結果"]

{"sheet":"コード","index":1,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[[9,2,10,3],[48,2,49,3],[5,5,10,6]]}
[]
[null,"行目","手順（プログラム）"]
[null,1,10,{"$f":"\"１～\"&C3&\"までの数字を一つ選ぶ\"","v":"１～10までの数字を一つ選ぶ"}]
[null,2]
[null,3]
[null,4,null,null,null,"上のボタンを押すと順の数字のリストが消えることがあるのでその時は数字を入力してください"]
[null,5]
[null,6]
[]
[null,null,"２行目以下プログラムを上の赤枠内に並べ替えて\n数当てゲームを作ろう（6行全て必要）"]
[]
[]
[]
[]
[null,"順","手順（プログラム）"]
[null,null,null,"予想した数字が選んだ数字より大きければ　「それより大きいよ。」と表示。"]
[null,null,null,"「正解」と表示。正解数をふやし1行目にもどる。"]
[null,null,null,"予想した数字が選んだ数字より小さければ　「それより小さいよ。」と表示。"]
[null,null,null,"予想する数字をきく"]
[null,null,null,"予想した数字が選んだ数字になるまで　繰り返す"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"行目","手順（プログラム）"]
[null,1,10,{"$f":"\"１～\"&C42&\"までの数字を一つ選ぶ\"","v":"１～10までの数字を一つ選ぶ"}]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[]
[null,null,"２行目以下プログラムを上の赤枠内に並べ替えて\n数当てゲームを作ろう（6行全て必要）"]
[]
[]
[]
[]
[null,"順","手順（プログラム）"]
[null,null,null,"予想した数字が選んだ数字より大きければ　「それより大きいよ。」と表示。"]
[null,null,null,"「正解」と表示。正解数をふやし1行目にもどる。"]
[null,null,null,"予想した数字が選んだ数字より小さければ　「それより小さいよ。」と表示。"]
[null,null,null,"予想する数字をきく"]
[null,null,null,"予想した数字が選んだ数字になるまで　繰り返す"]
[]
[null,{"$f":"IF(COUNTIF($B$16:B16,B16)>1,\"重複\",\"\")","v":""}]
[null,{"$f":"IF(COUNTIF($B$16:B17,B17)>1,\"重複\",\"\")","v":""}]
[null,{"$f":"IF(COUNTIF($B$16:B18,B18)>1,\"重複\",\"\")","v":""}]
[null,{"$f":"IF(COUNTIF($B$16:B19,B19)>1,\"重複\",\"\")","v":""}]
[null,{"$f":"IF(COUNTIF($B$16:B20,B20)>1,\"重複\",\"\")","v":""}]
[]
[]
["重複セル",{"$f":"COUNTIF(B61:B65,\"重複\")","v":0}]
["入力セル",{"$f":"COUNT($B$16:$B$20)","v":0}]
["プログラム入力セル",{"$f":"COUNTA(C3:D8)","v":2}]