{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["教科書"],"not_rendered":{"charts":1,"images":0,"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":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"表１　千円札と五百円硬貨の枚数"]
["番号","乱数","持参する金額","千円の増減","千円の枚数","五百円硬貨の増減","五百円硬貨の枚数",null,"不足枚数","回数",null,"試行回数",10000]
["初期値",null,null,null,0,null,0,null,0,null,null,"現在の回数"]
[1,{"$f":"RAND()","v":0.95079479069803341},{"$f":"IF(B4>=0.5,\"1000円\",\"500円\")","v":"1000円"},{"$f":"IF(C4=\"1000円\",1,0)","v":1},{"$f":"D4+E3","v":1},{"$f":"IF(C4=\"1000円\",-1,1)","v":-1},{"$f":"F4+G3","v":-1},null,-1]
[2,{"$f":"RAND()","v":0.13770253440595204},{"$f":"IF(B5>=0.5,\"1000円\",\"500円\")","v":"500円"},{"$f":"IF(C5=\"1000円\",1,0)","v":0},{"$f":"D5+E4","v":1},{"$f":"IF(C5=\"1000円\",-1,1)","v":1},{"$f":"F5+G4","v":0},null,-2]
[3,0.1453324657318662,"500円",0,1,1,1,null,-3]
[4,0.19480001053759044,"500円",0,1,1,2,null,-4]
[5,0.18001829472248077,"500円",0,1,1,3,null,-5]
[6,0.61836058019510287,"1000円",1,2,-1,2,null,-6]
[7,6.4472312406024801E-2,"500円",0,2,1,3,null,-7]
[8,3.7919833866832509E-2,"500円",0,2,1,4,null,-8]
[9,0.13623816231782404,"500円",0,2,1,5,null,-9]
[10,0.98801400373539905,"1000円",1,3,-1,4,null,-10]
[11,0.55740341872276,"1000円",1,4,-1,3,null,-11]
[12,0.99119003147277651,"1000円",1,5,-1,2,null,-12]
[13,0.49751451289243176,"500円",0,5,1,3,null,-13]
[14,0.32041466061264723,"500円",0,5,1,4,null,-14]
[15,5.7242518901522099E-2,"500円",0,5,1,5,null,-15]
[16,0.83180587702752073,"1000円",1,6,-1,4,null,-16]
[17,0.57887070169237875,"1000円",1,7,-1,3,null,-17]
[18,0.48302559444460669,"500円",0,7,1,4,null,-18]
[19,0.77788545872454706,"1000円",1,8,-1,3,null,-19]
[20,0.88585592215291997,"1000円",1,9,-1,2,null,-20]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J3:J23)","v":0}]
[null,null,null,"回収金額",{"$f":"E23*1000+G23*500","v":10000},"不足枚数",{"$f":"IF(MIN(G3:G23)<0,MIN(G3:G23),0)","v":-1}]