{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["共通テスト","問題","完成"],"not_rendered":{"charts":2,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"問題","index":1,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,"表１　１万円札と千円札の枚数"]
["番号","乱数","持参する金額","一万円札の増減","一万円札の枚数","千円札の増減","千円札の枚数",null,"不足枚数","回数",null,"試行回数",10000]
["初期値",null,null,null,0,null,0,null,0,null,null,"現在の回数",10000]
[1,null,null,null,null,null,null,null,-2]
[2,null,null,null,null,null,null,null,-4]
[3,null,null,null,null,null,null,null,-6]
[4,null,null,null,null,null,null,null,-8]
[5,null,null,null,null,null,null,null,-10]
[6,null,null,null,null,null,null,null,-12]
[7,null,null,null,null,null,null,null,-14]
[8,null,null,null,null,null,null,null,-16]
[9,null,null,null,null,null,null,null,-18]
[10,null,null,null,null,null,null,null,-20]
[null,null,null,null,null,null,null,null,-22]
[null,null,null,"回収金額",null,"不足枚数",null,null,-24]
[null,null,null,null,null,null,null,null,-26]
[null,null,null,null,null,null,null,null,-28]
[null,null,null,null,null,null,null,null,-30]
[null,null,null,null,null,null,null,null,-32]
[null,null,null,null,null,null,null,null,-34]
[null,null,null,null,null,null,null,null,-36]
[null,null,null,null,null,null,null,null,-38]
[null,null,null,null,null,null,null,null,-40]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J3:J23)","v":0}]

{"sheet":"完成","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,"表１　１万円札と千円札の枚数"]
["番号","乱数","持参する金額","一万円札の増減","一万円札の枚数","千円札の増減","千円札の枚数",null,"不足枚数","回数",null,"試行回数",10000]
["初期値",null,null,null,0,null,0,null,0,827,null,"現在の回数",10000]
[1,{"$f":"RANDBETWEEN(1,10)","v":1},{"$f":"IF(B4>=4,\"10000円\",\"6000円\")","v":"6000円"},{"$f":"IF(C4=\"10000円\",1,0)","v":0},{"$f":"D4+E3","v":0},{"$f":"IF(C4=\"10000円\",-4,6)","v":6},{"$f":"F4+G3","v":6},null,-2,228]
[2,{"$f":"RANDBETWEEN(1,10)","v":4},{"$f":"IF(B5>=4,\"10000円\",\"6000円\")","v":"10000円"},{"$f":"IF(C5=\"10000円\",1,0)","v":1},{"$f":"D5+E4","v":1},{"$f":"IF(C5=\"10000円\",-4,6)","v":-4},{"$f":"G4+F5","v":2},null,-4,651]
[3,7,"10000円",1,2,{"$f":"IF(C6=\"10000円\",-4,6)","v":-4},{"$f":"G5+F6","v":-2},null,-6,449]
[4,6,"10000円",1,3,-4,-6,null,-8,549]
[5,1,"6000円",0,3,6,0,null,-10,1084]
[6,1,"6000円",0,3,6,6,null,-12,750]
[7,1,"6000円",0,3,6,12,null,-14,299]
[8,1,"6000円",0,3,6,18,null,-16,639]
[9,6,"10000円",1,4,-4,14,null,-18,275]
[10,3,"6000円",0,4,6,20,null,-20,1599]
[null,null,null,null,null,null,null,null,-22,460]
[null,null,null,"回収金額",{"$f":"E13*10000+G13*1000","v":60000},"不足枚数",{"$f":"IF(MIN(G3:G13)<0,MIN(G3:G13),0)","v":-6},null,-24,211]
[null,null,null,null,null,null,null,null,-26,345]
[null,null,null,null,null,null,null,null,-28,144]
[null,null,null,null,null,null,null,null,-30,957]
[null,null,null,null,null,null,null,null,-32,143]
[null,null,null,null,null,null,null,null,-34]
[null,null,null,null,null,null,null,null,-36,118]
[null,null,null,null,null,null,null,null,-38]
[null,null,null,null,null,null,null,null,-40,272]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J3:J23)","v":10000}]