{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["メイン","データ","練習問題"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[7,9,8,10],[7,11,8,12],[7,13,8,14],[7,15,8,16],[7,6,8,6],[7,7,8,7],[6,3,6,5],[2,1,5,7],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[9,9,10,10],[9,11,10,12],[9,13,10,14],[9,15,10,16],[3,11,4,12],[3,13,4,14],[3,15,4,16],[5,9,6,10],[5,11,6,12],[5,13,6,14],[5,15,6,16],[3,9,4,10]]}
[]
[null,"プログラミング学習Ⅲ（漸次実行）"]
[null,"　\n　右の４×４のマスについて１～６までの線しか引くことができません 。  スタートからケーキまで最短で行くには問題の？のところに何番目の線を引くとよいでしょう。"]
[null,null,null,null,null,null,null,null,null,"スタート",null,{"$f":"IF(C10=\"Ａ\",VLOOKUP($B$7,データ!$B$5:$Q$24,7),データ!$B$3)","v":" "},null,{"$f":"IF(D10=\"Ｂ\",VLOOKUP($B$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},null,{"$f":"IF(E10=\"Ｃ\",VLOOKUP($B$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C10=\"Ｄ\",VLOOKUP($B$7,データ!$B$5:$Q$24,7),データ!$B$3)","v":"└"},null,{"$f":"IF(D10=\"Ｅ\",VLOOKUP($B$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":"┐"},null,{"$f":"IF(E10=\"Ｆ\",VLOOKUP($B$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},null,{"$f":"IF(F10=\"Ｇ\",VLOOKUP($B$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "}]
[null,16,1,"問題"]
[null,"スタート",{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,2)","v":5},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,3)","v":3},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,4)","v":2},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,5)","v":5},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,6)","v":1},"🍰",null,{"$f":"IF(D10=\"Ｈ\",VLOOKUP($B$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},null,{"$f":"IF(E10=\"Ｉ\",VLOOKUP($B$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":"│"},null,{"$f":"IF(F10=\"Ｊ\",VLOOKUP($B$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},null,{"$f":"IF(G10=\"Ｋ\",VLOOKUP($B$7,データ!$B$5:$Q$24,11),データ!$B$3)","v":" "}]
[]
[null,null,{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,12)","v":"Ｄ"},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,13)","v":"Ｅ"},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,14)","v":"Ｉ"},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,15)","v":"Ｍ"},{"$f":"VLOOKUP($B$7,データ!$B$5:$Q$24,16)","v":"Ｎ"},null,null,{"$f":"IF(E10=\"Ｌ\",VLOOKUP($B$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},null,{"$f":"IF(F10=\"Ｍ\",VLOOKUP($B$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":"└"},null,{"$f":"IF(G10=\"Ｎ\",VLOOKUP($B$7,データ!$B$5:$Q$24,11),データ!$B$3)","v":"─"},null,"🍰"]

{"sheet":"データ","index":1,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,0,1,2,3,4,5,6]
[null," ","─","│","┐","┘","└","┌"]
[]
[null,1,1,1,3,2,2,{"$f":"HLOOKUP(C5,$B$2:$H$3,2)","v":"─"},{"$f":"HLOOKUP(D5,$B$2:$H$3,2)","v":"─"},{"$f":"HLOOKUP(E5,$B$2:$H$3,2)","v":"┐"},{"$f":"HLOOKUP(F5,$B$2:$H$3,2)","v":"│"},{"$f":"HLOOKUP(G5,$B$2:$H$3,2)","v":"│"},"Ａ","Ｂ","Ｃ","Ｇ","Ｋ"]
[null,2,1,3,5,3,2,"─","┐","└","┐","│","Ａ","Ｂ","Ｆ","Ｇ","Ｋ"]
[null,3,1,3,2,5,3,"─","┐","│","└","┐","Ａ","Ｂ","Ｆ","Ｊ","Ｋ"]
[null,4,1,3,2,2,5,"─","┐","│","│","└","Ａ","Ｂ","Ｆ","Ｊ","Ｎ"]
[null,5,3,5,1,3,2,"┐","└","─","┐","│","Ａ","Ｅ","Ｆ","Ｇ","Ｋ"]
[null,6,3,5,3,5,3,"┐","└","┐","└","┐","Ａ","Ｅ","Ｆ","Ｊ","Ｋ"]
[null,7,3,5,3,2,5,"┐","└","┐","│","└","Ａ","Ｅ","Ｆ","Ｊ","Ｎ"]
[null,8,3,2,5,1,3,"┐","│","└","─","┐","Ａ","Ｅ","Ｉ","Ｊ","Ｋ"]
[null,9,3,2,5,3,5,"┐","│","└","┐","└","Ａ","Ｅ","Ｉ","Ｊ","Ｎ"]
[null,10,3,2,2,5,1,"┐","│","│","└","─","Ａ","Ｅ","Ｉ","Ｍ","Ｎ"]
[null,11,5,1,1,3,2,"└","─","─","┐","│","Ｄ","Ｅ","Ｆ","Ｇ","Ｋ"]
[null,12,5,1,3,5,3,"└","─","┐","└","┐","Ｄ","Ｅ","Ｆ","Ｊ","Ｋ"]
[null,13,5,1,3,2,5,"└","─","┐","│","└","Ｄ","Ｅ","Ｆ","Ｊ","Ｎ"]
[null,14,5,3,5,1,3,"└","┐","└","─","┐","Ｄ","Ｅ","Ｉ","Ｊ","Ｋ"]
[null,15,5,3,5,3,5,"└","┐","└","┐","└","Ｄ","Ｅ","Ｉ","Ｊ","Ｎ"]
[null,16,5,3,2,5,1,"└","┐","│","└","─","Ｄ","Ｅ","Ｉ","Ｍ","Ｎ"]
[null,17,2,5,1,1,3,"│","└","─","─","┐","Ｄ","Ｈ","Ｉ","Ｊ","Ｋ"]
[null,18,2,5,1,3,5,"│","└","─","┐","└","Ｄ","Ｈ","Ｉ","Ｊ","Ｎ"]
[null,19,2,5,3,5,1,"│","└","┐","└","─","Ｄ","Ｈ","Ｉ","Ｍ","Ｎ"]
[null,20,2,2,5,1,1,"│","│","└","─","─","Ｄ","Ｈ","Ｌ","Ｍ","Ｎ"]

{"sheet":"練習問題","index":2,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,0,1,14],[3,0,3,7],[5,0,5,1],[5,8,5,9],[14,0,14,1],[14,8,14,9]]}
[]
["プログラミング学習Ⅲ（漸次実行）　練習問題"]
[]
["スタートからケーキまで、１ ～ ６ の線を使って最短で行くには問題の空白のところ\nに何番目の線を引くとよいでしょうか。"]
[]
["問　①",null,null,null,null,null,null,null,"問　②"]
[18,5,null,null,null,null,null,null,17,2]
[null,null,"スタート",{"$f":"IF(B14=\"Ａ\",VLOOKUP($A$7,データ!$B$5:$Q$24,7),データ!$B$3)","v":" "},{"$f":"IF(C14=\"Ｂ\",VLOOKUP($A$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(D14=\"Ｃ\",VLOOKUP($A$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},null,null,null,null,"スタート",{"$f":"IF(J14=\"Ａ\",VLOOKUP($I$7,データ!$B$5:$Q$24,7),データ!$B$3)","v":" "},{"$f":"IF(K14=\"Ｂ\",VLOOKUP($I$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(L14=\"Ｃ\",VLOOKUP($I$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "}]
[null,null,{"$f":"IF(B14=\"Ｄ\",VLOOKUP($A$7,データ!$B$5:$Q$24,7),データ!$B$3)","v":"│"},{"$f":"IF(C14=\"Ｅ\",VLOOKUP($A$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(D14=\"Ｆ\",VLOOKUP($A$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(E14=\"Ｇ\",VLOOKUP($A$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},null,null,null,null,{"$f":"IF(J14=\"Ｄ\",VLOOKUP($I$7,データ!$B$5:$Q$24,7),データ!$B$3)","v":"│"},{"$f":"IF(K14=\"Ｅ\",VLOOKUP($I$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(L14=\"Ｆ\",VLOOKUP($I$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(M14=\"Ｇ\",VLOOKUP($I$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "}]
[null,null,{"$f":"IF(C14=\"Ｈ\",VLOOKUP($A$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":"└"},{"$f":"IF(D14=\"Ｉ\",VLOOKUP($A$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":"─"},{"$f":"IF(E14=\"Ｊ\",VLOOKUP($A$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":"┐"},{"$f":"IF(F14=\"Ｋ\",VLOOKUP($A$7,データ!$B$5:$Q$24,11),データ!$B$3)","v":" "},null,null,null,null,{"$f":"IF(K14=\"Ｈ\",VLOOKUP($I$7,データ!$B$5:$Q$24,8),データ!$B$3)","v":"└"},{"$f":"IF(L14=\"Ｉ\",VLOOKUP($I$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":"─"},{"$f":"IF(M14=\"Ｊ\",VLOOKUP($I$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":"─"},{"$f":"IF(N14=\"Ｋ\",VLOOKUP($I$7,データ!$B$5:$Q$24,11),データ!$B$3)","v":"┐"}]
[null,null,{"$f":"IF(D14=\"Ｌ\",VLOOKUP($A$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(E14=\"Ｍ\",VLOOKUP($A$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},{"$f":"IF(F14=\"Ｎ\",VLOOKUP($A$7,データ!$B$5:$Q$24,11),データ!$B$3)","v":"└"},"🍰",null,null,null,null,{"$f":"IF(L14=\"Ｌ\",VLOOKUP($I$7,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(M14=\"Ｍ\",VLOOKUP($I$7,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},{"$f":"IF(N14=\"Ｎ\",VLOOKUP($I$7,データ!$B$5:$Q$24,11),データ!$B$3)","v":" "},"🍰"]
[]
["スタート",{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,2)","v":2},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,3)","v":5},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,4)","v":1},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,5)","v":3},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,6)","v":5},"🍰",null,"スタート",{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,2)","v":2},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,3)","v":5},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,4)","v":1},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,5)","v":1},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,6)","v":3},"🍰"]
[null,{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,12)","v":"Ｄ"},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,13)","v":"Ｈ"},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,14)","v":"Ｉ"},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,15)","v":"Ｊ"},{"$f":"VLOOKUP($A$7,データ!$B$5:$Q$24,16)","v":"Ｎ"},null,null,null,{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,12)","v":"Ｄ"},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,13)","v":"Ｈ"},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,14)","v":"Ｉ"},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,15)","v":"Ｊ"},{"$f":"VLOOKUP($I$7,データ!$B$5:$Q$24,16)","v":"Ｋ"}]
["問　③",null,null,null,null,null,null,null,"問　④"]
[4,3,null,null,null,null,null,null,19,3]
[null,null,"スタート",{"$f":"IF(B23=\"Ａ\",VLOOKUP($A$16,データ!$B$5:$Q$24,7),データ!$B$3)","v":"─"},{"$f":"IF(C23=\"Ｂ\",VLOOKUP($A$16,データ!$B$5:$Q$24,8),データ!$B$3)","v":"┐"},{"$f":"IF(D23=\"Ｃ\",VLOOKUP($A$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},null,null,null,null,"スタート",{"$f":"IF(J23=\"Ａ\",VLOOKUP($I$16,データ!$B$5:$Q$24,7),データ!$B$3)","v":" "},{"$f":"IF(K23=\"Ｂ\",VLOOKUP($I$16,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(L23=\"Ｃ\",VLOOKUP($I$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "}]
[null,null,{"$f":"IF(B23=\"Ｄ\",VLOOKUP($A$16,データ!$B$5:$Q$24,7),データ!$B$3)","v":" "},{"$f":"IF(C23=\"Ｅ\",VLOOKUP($A$16,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(D23=\"Ｆ\",VLOOKUP($A$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":"│"},{"$f":"IF(E23=\"Ｇ\",VLOOKUP($A$16,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},null,null,null,null,{"$f":"IF(J23=\"Ｄ\",VLOOKUP($I$16,データ!$B$5:$Q$24,7),データ!$B$3)","v":"│"},{"$f":"IF(K23=\"Ｅ\",VLOOKUP($I$16,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(L23=\"Ｆ\",VLOOKUP($I$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(M23=\"Ｇ\",VLOOKUP($I$16,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "}]
[null,null,{"$f":"IF(C23=\"Ｈ\",VLOOKUP($A$16,データ!$B$5:$Q$24,8),データ!$B$3)","v":" "},{"$f":"IF(D23=\"Ｉ\",VLOOKUP($A$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(E23=\"Ｊ\",VLOOKUP($A$16,データ!$B$5:$Q$24,10),データ!$B$3)","v":"│"},{"$f":"IF(F23=\"Ｋ\",VLOOKUP($A$16,データ!$B$5:$Q$24,11),データ!$B$3)","v":" "},null,null,null,null,{"$f":"IF(K23=\"Ｈ\",VLOOKUP($I$16,データ!$B$5:$Q$24,8),データ!$B$3)","v":"└"},{"$f":"IF(L23=\"Ｉ\",VLOOKUP($I$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":"┐"},{"$f":"IF(M23=\"Ｊ\",VLOOKUP($I$16,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},{"$f":"IF(N23=\"Ｋ\",VLOOKUP($I$16,データ!$B$5:$Q$24,11),データ!$B$3)","v":" "}]
[null,null,{"$f":"IF(D23=\"Ｌ\",VLOOKUP($A$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(E23=\"Ｍ\",VLOOKUP($A$16,データ!$B$5:$Q$24,10),データ!$B$3)","v":" "},{"$f":"IF(F23=\"Ｎ\",VLOOKUP($A$16,データ!$B$5:$Q$24,11),データ!$B$3)","v":"└"},"🍰",null,null,null,null,{"$f":"IF(L23=\"Ｌ\",VLOOKUP($I$16,データ!$B$5:$Q$24,9),データ!$B$3)","v":" "},{"$f":"IF(M23=\"Ｍ\",VLOOKUP($I$16,データ!$B$5:$Q$24,10),データ!$B$3)","v":"└"},{"$f":"IF(N23=\"Ｎ\",VLOOKUP($I$16,データ!$B$5:$Q$24,11),データ!$B$3)","v":"─"},"🍰"]
[]
["スタート",{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,2)","v":1},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,3)","v":3},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,4)","v":2},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,5)","v":2},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,6)","v":5},"🍰",null,"スタート",{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,2)","v":2},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,3)","v":5},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,4)","v":3},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,5)","v":5},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,6)","v":1},"🍰"]
[null,{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,12)","v":"Ａ"},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,13)","v":"Ｂ"},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,14)","v":"Ｆ"},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,15)","v":"Ｊ"},{"$f":"VLOOKUP($A$16,データ!$B$5:$Q$24,16)","v":"Ｎ"},null,null,null,{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,12)","v":"Ｄ"},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,13)","v":"Ｈ"},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,14)","v":"Ｉ"},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,15)","v":"Ｍ"},{"$f":"VLOOKUP($I$16,データ!$B$5:$Q$24,16)","v":"Ｎ"}]