{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["三山崩し","解法シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,1,6,2]]}
["三山崩し（みやまくずし）とは、次のような石取りゲームです",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"乱数1",{"$f":"RANDBETWEEN(5,20)","v":5}]
["（ルール）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"乱数2",{"$f":"RANDBETWEEN(5,20)","v":10}]
["・３つのどれか１つの山からしか石を取ることはできない。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"乱数3",6]
["・取る石の数は何個でもよい。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回数記録",0]
["・最後に石を全部取った方の勝ち。"]
[null,null,null,null,null,null,null,"取る石の数",null,null,null,null,null,null,null,null,null,null,null,null,"取る石の数の判定"]
[null,{"$f":"IF(MOD(V4,2)=0,\"Aの番です\",\"Bの番です\")","v":"Aの番です"},null,null,null,"山１",8,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H7>0,D10>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H7>0,L10>0),1,0)","v":0}]
[null,null,null,"取る石の数",null,null,null,null,null,null,null,"取る石の数",null,null,null,null,null,null,null,null,{"$f":"IF(AND(D10>0,L10>0),1,0)","v":0}]
[null,"山２",11,0,null,null,null,null,null,"山３",16,0,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D10>0,H7>0,L10>0),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U7:U10)","v":0},"合計"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]

{"sheet":"解法シート","index":1,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":true,"merged":[[18,0,27,0],[30,0,39,0],[42,0,51,0]]}
["三山崩しの解法"]
[]
[null,"１０進数","２進数",6,5,4,3,2,1,"取る数の提案",null,null,6,5,4,3,2,1,"除去後の石の数"]
["A 山1",{"$f":"三山崩し!G7","v":8},{"$f":"DEC2BIN(B4)","v":"1000"},{"$f":"IFERROR(VALUE(MID($C4,$B14-D$3+1,1)),0)","v":0},0,1,0,0,{"$f":"IFERROR(VALUE(MID($C4,$B14-I$3+1,1)),0)","v":0},{"$f":"(B4-S4)*K4","v":0},{"$f":"IF($D$11*D4+$E$11*E4+$F$11*F4+$G$11*G4+$H$11*H4+$I$11*I4>0,1,0)","v":0},null,{"$f":"IF($K4=0,0,MOD(D4+D$7*$K4,2))","v":0},0,0,0,0,0,{"$f":"R4*2^($R$3-1)+Q4*2^($Q$3-1)+P4*2^($P$3-1)+O4*2^($O$3-1)+N4*2^($N$3-1)+M4*2^($M$3-1)","v":0}]
["B 山2",{"$f":"三山崩し!C10","v":11},{"$f":"DEC2BIN(B5)","v":"1011"},{"$f":"IFERROR(VALUE(MID($C5,$B15-D$3+1,1)),0)","v":0},0,1,0,1,1,{"$f":"(B5-S5)*K5","v":0},0,null,0,0,0,0,0,0,{"$f":"R5*2^($R$3-1)+Q5*2^($Q$3-1)+P5*2^($P$3-1)+O5*2^($O$3-1)+N5*2^($N$3-1)+M5*2^($M$3-1)","v":0}]
["C 山3",{"$f":"三山崩し!K10","v":16},"10000",{"$f":"IFERROR(VALUE(MID($C6,$B16-D$3+1,1)),0)","v":0},1,0,0,0,0,{"$f":"(B6-S6)*K6","v":13},{"$f":"IF($D$11*D6+$E$11*E6+$F$11*F6+$G$11*G6+$H$11*H6+$I$11*I6>0,1,0)","v":1},null,0,0,0,0,1,1,3]
[null,"排他的論理和","s=a+b+c(mod 2)",{"$f":"MOD(SUM(D4:D6),2)","v":0},{"$f":"MOD(SUM(E4:E6),2)","v":1},{"$f":"MOD(SUM(F4:F6),2)","v":0},{"$f":"MOD(SUM(G4:G6),2)","v":0},{"$f":"MOD(SUM(H4:H6),2)","v":1},{"$f":"MOD(SUM(I4:I6),2)","v":1}]
[null,null,null,6,5,4,3,2,1]
[null,null,null,{"$f":"D7*D8","v":0},{"$f":"E7*E8","v":5},0,0,2,1]
[null,null,null,{"$f":"IF(AND(SUM($B9:D9)>0,SUM($B9:C9)=0),1,0)","v":0},{"$f":"IF(AND(SUM($B9:E9)>0,SUM($B9:D9)=0),1,0)","v":1},{"$f":"IF(AND(SUM($B9:F9)>0,SUM($B9:E9)=0),1,0)","v":0},{"$f":"IF(AND(SUM($B9:G9)>0,SUM($B9:F9)=0),1,0)","v":0},{"$f":"IF(AND(SUM($B9:H9)>0,SUM($B9:G9)=0),1,0)","v":0},{"$f":"IF(AND(SUM($B9:I9)>0,SUM($B9:H9)=0),1,0)","v":0}]
[null,null,null,{"$f":"D10*D3","v":0},{"$f":"E10*E3","v":5},0,0,0,0,{"$f":"SUM(D11:I11)","v":5}]
[]
[]
["桁数（山１）",{"$f":"SUM(E19:E28)","v":4}]
["桁数（山２）",{"$f":"SUM(E31:E40)","v":4}]
["桁数（山３）",{"$f":"SUM(E43:E52)","v":5}]
[]
[null,"階級値","データ数","桁数","C列×D列"]
["a 山1",0,{"$f":"COUNTIF($B$4,\"<=\"&B19)","v":0},0,{"$f":"C19*D19","v":0}]
[null,1,{"$f":"COUNTIF($B$4,\"<\"&B20)-COUNTIF($B$4,\"<\"&B19)","v":0},0,{"$f":"C20*D20","v":0}]
[null,2,{"$f":"COUNTIF($B$4,\"<\"&B21)-COUNTIF($B$4,\"<\"&B20)","v":0},1,0]
[null,4,0,2,0]
[null,8,0,3,0]
[null,16,1,4,4]
[null,32,0,5,0]
[null,64,0,6,0]
[null,128,0,7,0]
[null,256,0,8,0]
[]
[null,"階級値","データ数","桁数","C列×D列"]
["b 山2",0,{"$f":"COUNTIF($B$5,\"<=\"&B31)","v":0},0,{"$f":"C31*D31","v":0}]
[null,1,{"$f":"COUNTIF($B$5,\"<\"&B32)-COUNTIF($B$5,\"<\"&B31)","v":0},0,{"$f":"C32*D32","v":0}]
[null,2,{"$f":"COUNTIF($B$5,\"<\"&B33)-COUNTIF($B$5,\"<\"&B32)","v":0},1,0]
[null,4,0,2,0]
[null,8,0,3,0]
[null,16,1,4,4]
[null,32,0,5,0]
[null,64,0,6,0]
[null,128,0,7,0]
[null,256,0,8,0]
[]
[null,"階級値","データ数","桁数","C列×D列"]
["c 山3",0,{"$f":"COUNTIF($B$6,\"<=\"&B43)","v":0},0,{"$f":"C43*D43","v":0}]
[null,1,{"$f":"COUNTIF($B$6,\"<\"&B44)-COUNTIF($B$6,\"<\"&B43)","v":0},0,{"$f":"C44*D44","v":0}]
[null,2,{"$f":"COUNTIF($B$6,\"<\"&B45)-COUNTIF($B$6,\"<\"&B44)","v":0},1,0]
[null,4,0,2,0]
[null,8,0,3,0]
[null,16,0,4,0]
[null,32,1,5,5]
[null,64,0,6,0]
[null,128,0,7,0]
[null,256,0,8,0]