{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["7x7","9x9","11x11","使い方","使用例"],"not_rendered":{"charts":0,"images":1,"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":"7x7","index":0,"n_rows":78,"n_cols":35,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック2EX かんたん作成支援ツール",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024年8月16日版",null,null,null,null,null,null,null,"ここより右は計算用(URL作成用）"]
[null,null,null,"7x7 問題作成用ワークシート",null,null,null,null,null,null,null,null,null,null,null,"問題名称（オプション）",null,null,null,null,"問題のURL",null,{"$f":"HYPERLINK(AF4,AF4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全体のURL",null,{"$f":"HYPERLINK(AF5,AF5)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑をクリックすると直接問題を表示できます。",null,null,null,null,null,null,null,"問題のURL",{"$f":"AF27&AF28&AF29","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑右上が「#VALUE!」エラー表示のときはこちらをクリック。マクロが使えないときは、AF4やAF5の値をコピーして使ってください",null,null,null,null,null,null,null,null,null,null,null,"全体のURL",{"$f":"AF27&AF28&AF29&AF30","v":{"$error":"#N/A"}}]
[null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,1,2,3,4,5,6,7,null,null,null,null,null,"コマンドブロック数",null,null,null,null,"（あらかじめ並べておくコマンドブロック、解答例）"]
[null,null,1,"X","X","X","X","X","X","X",null,null,null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ",null,"参考"]
[null,null,2,"X",null,null,null,null,null,"X",null,null,null,null,null,"前進",null,4,null,1,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,null,null,"アルゴロジック2EX かんたん作成支援ツール"]
[null,null,3,"X",null,null,null,null,null,"X",null,null,null,null,null,"回転",null,4,null,2,null,null,null,"前進","1,2,3,4",null,null,null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,"X",null,null,null,null,null,"X",null,null,null,null,null,"LOOP",null,2,null,3,null,null,null,"回転","0,1,2,3",null,null,null,null,null,"識別子１","?"]
[null,null,5,"X",null,null,null,null,null,"X",null,null,null,null,null,"IF",null,2,null,4,null,null,null,"LOOP","0,1,2,3,4",null,null,null,null,null,"バージョン","algo=20"]
[null,null,6,"X",null,null,null,null,null,"X",null,null,null,null,null,"ELSE",{"$f":"Q12","v":0},{"$f":"Q13","v":0},null,5,null,null,null,"IF",0,null,null,null,null,null,"識別子2","&stage="]
[null,null,7,"X","X","X","X","X","X","X",null,null,null,null,null,"END",{"$f":"Q11+Q12","v":0},{"$f":"Q14","v":0},null,6,null,null,null,"ELSE",0,null,null,null,null,null,"ステージサイズ","0707",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,"END",0,null,null,null,null,null,"コマンドブロック数",{"$f":"Q43&Q44&Q45&Q46","v":"0000"},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",{"$f":"AF31","v":{"$error":"#N/A"}},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",null,"16以下",null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q17))&Q17","v":"00"},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,"コピー用（ステージ）",null,null,null,null,null,null,null,null,null,null,null,"コピー用（ロボットの向き）"]
[null,null,null,null,"P","旗",null,null,null,null,null,null,null,null,null,null,"上",null,null,null,"コピー用（コマンドブロック）",null,null,null,null,null,null,null,null,null,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右",null,null,null,"前進","IF",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/2/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"下",null,null,null,"回転","ELSE",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF52","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",null,null,null,"LOOP","END",null,null,null,null,null,null,null,null,"名前部",{"$f":"IF(P3<>\"\",\"&name=\"&_xlfn.ENCODEURL(P3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"解答部",{"$f":"\"&cb=\"&AF59","v":"&cb="}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの位置の向き",{"$f":"VLOOKUP(Q19,$P$73:$Q$76,2, FALSE())","v":{"$error":"#N/A"}}]
[null,null,"エラーチェック情報"]
[null,null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック",{"$f":"IF(S54>0,\"エラー有\",\"エラー無\")","v":"エラー有"},{"$f":"S54","v":1},"個",null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E76=1,\"エラー無\",\"エラー有\")","v":"エラー有"},null,null,{"$f":"E76","v":0},"個",null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,{"$f":"IF(X42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X42","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E75>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E75","v":0},"箇所",null,null,null,"最短手数エラー有無",{"$f":"IF(Q67=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー有"},null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AB62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AB62","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"カウンタ",null,{"$f":"IF(Z42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"Z42","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S78=1, \"エラー無\",\"エラー有\")","v":"エラー有"},null,null,null,"隙間あり",null,{"$f":"IF(X62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X62","v":0},"個"]
[]
[]
[null,"ここより下は計算用（主にエラーチェック用）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,"コマンドブロックのカウンタ"]
[null,null,null,{"$f":"IF(OR(EXACT(D8,\"A\"),EXACT(D8,\"Ａ\"),EXACT(D8,\"a\"),EXACT(D8,\"ａ\")),3,IF(OR(EXACT(D8,\"P\"),EXACT(D8,\"Ｐ\"),EXACT(D8,\"p\"),EXACT(D8,\"ｐ\")),2, IF(OR(EXACT(D8,\"X\"),EXACT(D8,\"Ｘ\"),EXACT(D8,\"x\"),EXACT(D8,\"ｘ\")),1,0)))","v":1},1,1,1,1,1,1,null,null,null,null,null,"コマンドブロック",null,null,null,null,null,null,null,"エラー有無",null,"エラー有無",null,null,null,null,"１段目",{"$f":"D41&E41&F41&G41&H41&I41&J41&AK41&AG41","v":"1111111,"},","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,{"$f":"SUM(X43:X58)","v":0},null,{"$f":"SUM(Z43:Z58)","v":0},null,null,null,null,"次",{"$f":"D42&E42&F42&G42&H42&I42&J42&AK42&AG42","v":"1000001,"},","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"前進",{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, 0)","v":0},{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, -1)","v":0},{"$f":"IF(R43<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$63:$V$68,2,FALSE()),\"\")","v":""},{"$f":"IF(U43<>\"\", V9, \"\")","v":""},{"$f":"IF(U43<>\"\", \",\", \"\")","v":""},{"$f":"IF(AND(U43=\"\",U9<>\"\"),1,0)","v":0},null,{"$f":"IF(OR(U43=\"\", AND(OR(U43=4,U43=5,U43=6), OR(V43=0,V43=\"\")),AND(U43=1,OR(V43=1,V43=2,V43=3,V43=4)), AND(U43=2,OR(V43=0,V43=1,V43=2,V43=3)),AND(U43=3,OR(V43=0,V43=1,V43=2,V43=3,V43=4))),0, 1)","v":0},"エラー検出ロジック",null,null,null,"次","1000001,",","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"回転",{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, 0)","v":0},{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, -1)","v":0},{"$f":"IF(R44<0, 1, 0)","v":0},2,"","","",0,null,0,"コマンドブロックが4か5か6 でカウンタ0か空白なら0、それ以外なら1",null,null,null,"次","1000001,",","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"LOOP",{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, 0)","v":0},{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, -1)","v":0},{"$f":"IF(R45<0, 1, 0)","v":0},3,"","","",0,null,0,"1で1,2,3,4 なら0、それ以外なら1",null,null,null,"次","1000001,",","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"IF",{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, 0)","v":0},{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, -1)","v":0},{"$f":"IF(R46<0, 1, 0)","v":0},4,"","","",0,null,0,"2で0,1,2,3 なら0、それ以外なら1",null,null,null,"次","1000001,",","]
[null,null,null,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,5,"","","",0,null,0,"3で0,1,2,3,4なら0、それ以外なら１",null,null,null,"次","1111111,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"個数が数値かどうか",null,{"$f":"AND(Q49:Q52)","v":false},{"$f":"IF(R48,0,1)","v":1},6,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"前進",{"$f":"ISNUMBER(Q9)","v":false},null,null,7,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q10)","v":false},null,null,8,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOP",{"$f":"ISNUMBER(Q11)","v":false},null,null,9,"","","",0,null,0,null,null,null,null,null,{"$f":"AJ41&AK41&AJ42&AK42&AJ43&AK43&AJ44&AK44&AJ45&AK45&AJ46&AK46&AJ47&AK47&AJ48&AK48&AJ49&AK49","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF",{"$f":"ISNUMBER(Q12)","v":false},null,null,10,"","","",0,null,0,null,null,null,null,"ステージ内容",{"$f":"AF41&AF42&AF43&AF44&AF45&AF46&AF47","v":"1111111,1000001,1000001,1000001,1000001,1000001,1111111,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S43:S48)","v":1},12,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","","",0,null,0]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","","",0,null,0,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック内容",{"$f":"AF60&AF61&AF62&AF63&AF64&AF65&AF66&AF67&AF68&AF69&AF70&AF71&AF72&AF73&AF74&AF75","v":""}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D60)*1))","v":0},null,"旗",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）",null,null,null,null,null,null,null,{"$f":"IF(AG60<>\"\",AG60&AH60&AI60,\"\")","v":""},{"$f":"U43","v":""},"",{"$f":"IF(AG60<>\"\", \",\", \"\")","v":""}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D61)*1))","v":24},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"隙間チェック",null,null,"コマンドブロックの数",null,null,null,null,{"$f":"IF(AF60<>\"\",IF(AG61<>\"\",AG61&AH61&AI61,\"\"),\"\")","v":""},"","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D62)*1))","v":0},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X64:X78)","v":0},null,null,"エラー数",{"$f":"SUM(AB64:AB69)","v":0},null,null,null,"","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D63)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,1,null,null,null,"利用数","エラー有無",null,null,null,"","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D64)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q17)","v":false},null,null,null,"回転",2,2,{"$f":"IF(AND(U44<>\"\",U43=\"\"),1,0)","v":0},null,1,{"$f":"COUNTIF($U$43:$U$58,Z64)","v":0},{"$f":"IF(AA64<=Q9,0,1)","v":0},null,null,null,"","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D65)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q64=TRUE(),Q17=INT(Q17)),0,1)","v":1},"0ならエラー無",null,null,"LOOP",3,3,0,null,2,0,0,null,null,null,"","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D66)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上16以下か",{"$f":"IF(AND(Q64=TRUE(),Q17>=1,Q17<=16),0,1)","v":1},"0ならエラー無",null,null,"IF",4,4,0,null,3,0,0,null,null,null,"","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D67)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q65,Q66)","v":true},"FALSEならエラー無",null,null,"ELSE",5,5,0,null,4,0,0,null,null,null,"","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D68)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END",6,6,0,null,5,0,0,null,null,null,"","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D69)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,6,0,0,null,null,null,"","","",""]
[null,null,null,"ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D70)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D71)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,10,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,\"\")*1))","v":25},null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$19,P73)","v":0},null,null,null,11,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"合計",{"$f":"SUM(E60:E73)","v":49},null,null,null,null,null,null,null,null,null,null,"右",1,null,{"$f":"COUNTIF($Q$19,P74)","v":0},null,null,null,12,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"不整合な文字列の個数",{"$f":"7*7 - E74","v":0},null,null,null,null,null,null,null,null,null,null,"下",2,null,{"$f":"COUNTIF($Q$19,P75)","v":0},null,null,null,13,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,{"$f":"E62+E65+E68+E71","v":0},"ロボットの数",null,null,null,null,null,null,null,null,null,"左",3,null,{"$f":"COUNTIF($Q$19,P76)","v":0},null,null,null,14,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S73:S76)","v":0},null,null,null,16,0]

{"sheet":"9x9","index":1,"n_rows":78,"n_cols":35,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック2EX かんたん作成支援ツール",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024年8月16日版",null,null,null,null,null,null,null,"ここより右は計算用(URL作成用）"]
[null,null,null,"9x9 問題作成用ワークシート",null,null,null,null,null,null,null,null,null,null,null,"問題名称（オプション）",null,null,null,null,"問題のURL",null,{"$f":"HYPERLINK(AF4,AF4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全体のURL",null,{"$f":"HYPERLINK(AF5,AF5)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑をクリックすると直接問題を表示できます。",null,null,null,null,null,null,null,"問題のURL",{"$f":"AF27&AF28&AF29","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑右上が「#VALUE!」エラー表示のときはこちらをクリック。マクロが使えないときは、AF4やAF5の値をコピーして使ってください",null,null,null,null,null,null,null,null,null,null,null,"全体のURL",{"$f":"AF27&AF28&AF29&AF30","v":{"$error":"#N/A"}}]
[null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,1,2,3,4,5,6,7,8,9,null,null,null,"コマンドブロック数",null,null,null,null,"（あらかじめ並べておくコマンドブロック、解答例）"]
[null,null,1,"X","X","X","X","X","X","X","X","X",null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ",null,"参考"]
[null,null,2,"X",null,null,null,null,null,null,null,"X",null,null,null,"前進",null,4,null,1,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,null,null,"アルゴロジック2EX かんたん作成支援ツール"]
[null,null,3,"X",null,null,null,null,null,null,null,"X",null,null,null,"回転",null,4,null,2,null,null,null,"前進","1,2,3,4",null,null,null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,"X",null,null,null,null,null,null,null,"X",null,null,null,"LOOP",null,2,null,3,null,null,null,"回転","0,1,2,3",null,null,null,null,null,"識別子１","?"]
[null,null,5,"X",null,null,null,null,null,null,null,"X",null,null,null,"IF",null,2,null,4,null,null,null,"LOOP","0,1,2,3,4",null,null,null,null,null,"バージョン","algo=20"]
[null,null,6,"X",null,null,null,null,null,null,null,"X",null,null,null,"ELSE",{"$f":"Q12","v":0},{"$f":"Q13","v":0},null,5,null,null,null,"IF",0,null,null,null,null,null,"識別子2","&stage="]
[null,null,7,"X",null,null,null,null,null,null,null,"X",null,null,null,"END",{"$f":"Q11+Q12","v":0},{"$f":"Q14","v":0},null,6,null,null,null,"ELSE",0,null,null,null,null,null,"ステージサイズ","0909",","]
[null,null,8,"X",null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,7,null,null,null,"END",0,null,null,null,null,null,"コマンドブロック数",{"$f":"Q43&Q44&Q45&Q46","v":"0000"},","]
[null,null,9,"X","X","X","X","X","X","X","X","X",null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",{"$f":"AF31","v":{"$error":"#N/A"}},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",null,"16以下",null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q17))&Q17","v":"00"},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,"コピー用（ステージ）",null,null,null,null,null,null,null,null,null,null,null,"コピー用（ロボットの向き）"]
[null,null,null,null,"P","旗",null,null,null,null,null,null,null,null,null,null,"上",null,null,null,"コピー用（コマンドブロック）",null,null,null,null,null,null,null,null,null,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右",null,null,null,"前進","IF",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/2/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"下",null,null,null,"回転","ELSE",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF52","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",null,null,null,"LOOP","END",null,null,null,null,null,null,null,null,"名前部",{"$f":"IF(P3<>\"\",\"&name=\"&_xlfn.ENCODEURL(P3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"解答部",{"$f":"\"&cb=\"&AF59","v":"&cb="}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの位置の向き",{"$f":"VLOOKUP(Q19,$P$73:$Q$76,2, FALSE())","v":{"$error":"#N/A"}}]
[null,null,"エラーチェック情報"]
[null,null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック",{"$f":"IF(S54>0,\"エラー有\",\"エラー無\")","v":"エラー有"},{"$f":"S54","v":1},"個",null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E76=1,\"エラー無\",\"エラー有\")","v":"エラー有"},null,null,{"$f":"E76","v":0},"個",null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,{"$f":"IF(X42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X42","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E75>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E75","v":0},"箇所",null,null,null,"最短手数エラー有無",{"$f":"IF(Q67=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー有"},null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AB62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AB62","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"カウンタ",null,{"$f":"IF(Z42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"Z42","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S78=1, \"エラー無\",\"エラー有\")","v":"エラー有"},null,null,null,"隙間あり",null,{"$f":"IF(X62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X62","v":0},"個"]
[]
[]
[null,"ここより下は計算用（主にエラーチェック用）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,"コマンドブロックのカウンタ"]
[null,null,null,{"$f":"IF(OR(EXACT(D8,\"A\"),EXACT(D8,\"Ａ\"),EXACT(D8,\"a\"),EXACT(D8,\"ａ\")),3,IF(OR(EXACT(D8,\"P\"),EXACT(D8,\"Ｐ\"),EXACT(D8,\"p\"),EXACT(D8,\"ｐ\")),2, IF(OR(EXACT(D8,\"X\"),EXACT(D8,\"Ｘ\"),EXACT(D8,\"x\"),EXACT(D8,\"ｘ\")),1,0)))","v":1},{"$f":"IF(OR(EXACT(E8,\"A\"),EXACT(E8,\"Ａ\"),EXACT(E8,\"a\"),EXACT(E8,\"ａ\")),3,IF(OR(EXACT(E8,\"P\"),EXACT(E8,\"Ｐ\"),EXACT(E8,\"p\"),EXACT(E8,\"ｐ\")),2, IF(OR(EXACT(E8,\"X\"),EXACT(E8,\"Ｘ\"),EXACT(E8,\"x\"),EXACT(E8,\"ｘ\")),1,0)))","v":1},1,1,1,1,1,1,1,null,null,null,"コマンドブロック",null,null,null,null,null,null,null,"エラー有無",null,"エラー有無",null,null,null,null,"１段目",{"$f":"D41&E41&F41&G41&H41&I41&J41&K41&L41&AK41&AG41","v":"111111111,"},","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,{"$f":"SUM(X43:X58)","v":0},null,{"$f":"SUM(Z43:Z58)","v":0},null,null,null,null,"次","100000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,"前進",{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, 0)","v":0},{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, -1)","v":0},{"$f":"IF(R43<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$63:$V$68,2,FALSE()),\"\")","v":""},{"$f":"IF(U43<>\"\", V9, \"\")","v":""},{"$f":"IF(U43<>\"\", \",\", \"\")","v":""},{"$f":"IF(AND(U43=\"\",U9<>\"\"),1,0)","v":0},null,{"$f":"IF(OR(U43=\"\", AND(OR(U43=4,U43=5,U43=6), OR(V43=0,V43=\"\")),AND(U43=1,OR(V43=1,V43=2,V43=3,V43=4)), AND(U43=2,OR(V43=0,V43=1,V43=2,V43=3)),AND(U43=3,OR(V43=0,V43=1,V43=2,V43=3,V43=4))),0, 1)","v":0},"エラー検出ロジック",null,null,null,"次","100000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,"回転",{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, 0)","v":0},{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, -1)","v":0},{"$f":"IF(R44<0, 1, 0)","v":0},2,"","","",0,null,0,"コマンドブロックが4か5か6 でカウンタ0か空白なら0、それ以外なら1",null,null,null,"次","100000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,"LOOP",{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, 0)","v":0},{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, -1)","v":0},{"$f":"IF(R45<0, 1, 0)","v":0},3,"","","",0,null,0,"1で1,2,3,4 なら0、それ以外なら1",null,null,null,"次","100000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,"IF",{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, 0)","v":0},{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, -1)","v":0},{"$f":"IF(R46<0, 1, 0)","v":0},4,"","","",0,null,0,"2で0,1,2,3 なら0、それ以外なら1",null,null,null,"次","100000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,null,null,null,null,5,"","","",0,null,0,"3で0,1,2,3,4なら0、それ以外なら１",null,null,null,"次","100000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,1,null,null,null,"個数が数値かどうか",null,{"$f":"AND(Q49:Q52)","v":false},{"$f":"IF(R48,0,1)","v":1},6,"","","",0,null,0,null,null,null,null,"次","100000001,",","]
[null,null,null,1,1,1,1,1,1,1,1,1,null,null,null,"前進",{"$f":"ISNUMBER(Q9)","v":false},null,null,7,"","","",0,null,0,null,null,null,null,"次","111111111,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q10)","v":false},null,null,8,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOP",{"$f":"ISNUMBER(Q11)","v":false},null,null,9,"","","",0,null,0,null,null,null,null,null,{"$f":"AJ41&AK41&AJ42&AK42&AJ43&AK43&AJ44&AK44&AJ45&AK45&AJ46&AK46&AJ47&AK47&AJ48&AK48&AJ49&AK49","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF",{"$f":"ISNUMBER(Q12)","v":false},null,null,10,"","","",0,null,0,null,null,null,null,"ステージ内容",{"$f":"AF41&AF42&AF43&AF44&AF45&AF46&AF47&AF48&AF49","v":"111111111,100000001,100000001,100000001,100000001,100000001,100000001,100000001,111111111,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S43:S48)","v":1},12,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","","",0,null,0]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","","",0,null,0,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック内容",{"$f":"AF60&AF61&AF62&AF63&AF64&AF65&AF66&AF67&AF68&AF69&AF70&AF71&AF72&AF73&AF74&AF75","v":""}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D60)*1))","v":0},null,"旗",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）",null,null,null,null,null,null,null,{"$f":"IF(AG60<>\"\",AG60&AH60&AI60,\"\")","v":""},{"$f":"U43","v":""},{"$f":"V43","v":""},{"$f":"IF(AG60<>\"\", \",\", \"\")","v":""}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D61)*1))","v":32},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"隙間チェック",null,null,"コマンドブロックの数",null,null,null,null,{"$f":"IF(AF60<>\"\",IF(AG61<>\"\",AG61&AH61&AI61,\"\"),\"\")","v":""},"","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D62)*1))","v":0},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X64:X78)","v":0},null,null,"エラー数",{"$f":"SUM(AB64:AB69)","v":0},null,null,null,"","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D63)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,1,null,null,null,"利用数","エラー有無",null,null,null,"","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D64)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q17)","v":false},null,null,null,"回転",2,2,{"$f":"IF(AND(U44<>\"\",U43=\"\"),1,0)","v":0},null,1,{"$f":"COUNTIF($U$43:$U$58,Z64)","v":0},{"$f":"IF(AA64<=Q9,0,1)","v":0},null,null,null,"","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D65)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q64=TRUE(),Q17=INT(Q17)),0,1)","v":1},"0ならエラー無",null,null,"LOOP",3,3,0,null,2,0,0,null,null,null,"","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D66)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上16以下か",{"$f":"IF(AND(Q64=TRUE(),Q17>=1,Q17<=16),0,1)","v":1},"0ならエラー無",null,null,"IF",4,4,0,null,3,0,0,null,null,null,"","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D67)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q65,Q66)","v":true},"FALSEならエラー無",null,null,"ELSE",5,5,0,null,4,0,0,null,null,null,"","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D68)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END",6,6,0,null,5,0,0,null,null,null,"","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D69)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,6,0,0,null,null,null,"","","",""]
[null,null,null,"ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D70)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D71)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,10,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,\"\")*1))","v":49},null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$19,P73)","v":0},null,null,null,11,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"合計",{"$f":"SUM(E60:E73)","v":81},null,null,null,null,null,null,null,null,null,null,"右",1,null,{"$f":"COUNTIF($Q$19,P74)","v":0},null,null,null,12,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"不整合な文字列の個数",{"$f":"9*9 - E74","v":0},null,null,null,null,null,null,null,null,null,null,"下",2,null,{"$f":"COUNTIF($Q$19,P75)","v":0},null,null,null,13,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,{"$f":"E62+E65+E68+E71","v":0},"ロボットの数",null,null,null,null,null,null,null,null,null,"左",3,null,{"$f":"COUNTIF($Q$19,P76)","v":0},null,null,null,14,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S73:S76)","v":0},null,null,null,16,0]

{"sheet":"11x11","index":2,"n_rows":78,"n_cols":35,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック2EX かんたん作成支援ツール",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024年8月16日版",null,null,null,null,null,null,null,"ここより右は計算用(URL作成用）"]
[null,null,null,"11x11 問題作成用ワークシート",null,null,null,null,null,null,null,null,null,null,null,"問題名称（オプション）",null,null,null,null,"問題のURL",null,{"$f":"HYPERLINK(AF4,AF4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全体のURL",null,{"$f":"HYPERLINK(AF5,AF5)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑をクリックすると直接問題を表示できます。",null,null,null,null,null,null,null,"問題のURL",{"$f":"AF27&AF28&AF29","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑右上が「#VALUE!」エラー表示のときはこちらをクリック。マクロが使えないときは、AF4やAF5の値をコピーして使ってください",null,null,null,null,null,null,null,null,null,null,null,"解答部も含んだURL",{"$f":"AF27&AF28&AF29&AF30","v":{"$error":"#N/A"}}]
[null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,1,2,3,4,5,6,7,8,9,10,11,null,"コマンドブロック数",null,null,null,null,"（あらかじめ並べておくコマンドブロック、解答例）"]
[null,null,1,"X","X","X","X","X","X","X","X","X","X","X",null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ",null,"参考"]
[null,null,2,"X",null,null,null,null,null,null,null,null,null,"X",null,"前進",null,4,null,1,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,null,null,"アルゴロジック2EX かんたん作成支援ツール"]
[null,null,3,"X",null,null,null,null,null,null,null,null,null,"X",null,"回転",null,4,null,2,null,null,null,"前進","1,2,3,4",null,null,null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,"X",null,null,null,null,null,null,null,null,null,"X",null,"LOOP",null,2,null,3,null,null,null,"回転","0,1,2,3",null,null,null,null,null,"識別子１","?"]
[null,null,5,"X",null,null,null,null,null,null,null,null,null,"X",null,"IF",null,2,null,4,null,null,null,"LOOP","0,1,2,3,4",null,null,null,null,null,"バージョン","algo=20"]
[null,null,6,"X",null,null,null,null,null,null,null,null,null,"X",null,"ELSE",{"$f":"Q12","v":0},{"$f":"Q13","v":0},null,5,null,null,null,"IF",0,null,null,null,null,null,"識別子2","&stage="]
[null,null,7,"X",null,null,null,null,null,null,null,null,null,"X",null,"END",{"$f":"Q11+Q12","v":0},{"$f":"Q14","v":0},null,6,null,null,null,"ELSE",0,null,null,null,null,null,"ステージサイズ","1111",","]
[null,null,8,"X",null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,7,null,null,null,"END",0,null,null,null,null,null,"コマンドブロック数",{"$f":"Q43&Q44&Q45&Q46","v":"0000"},","]
[null,null,9,"X",null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",{"$f":"AF31","v":{"$error":"#N/A"}},","]
[null,null,10,"X",null,null,null,null,null,null,null,null,null,"X",null,"最短手数",null,"16以下",null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q17))&Q17","v":"00"},","]
[null,null,11,"X","X","X","X","X","X","X","X","X","X","X",null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,"コピー用（ステージ）",null,null,null,null,null,null,null,null,null,null,null,"コピー用（ロボットの向き）"]
[null,null,null,null,"P","旗",null,null,null,null,null,null,null,null,null,null,"上",null,null,null,"コピー用（コマンドブロック）",null,null,null,null,null,null,null,null,null,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右",null,null,null,"前進","IF",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/2/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"下",null,null,null,"回転","ELSE",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF52","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"小文字、全角文字は設定できません",null,null,null,null,null,null,null,null,null,null,"左",null,null,null,"LOOP","END",null,null,null,null,null,null,null,null,"名前部",{"$f":"IF(P3<>\"\",\"&name=\"&_xlfn.ENCODEURL(P3),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"解答部",{"$f":"\"&cb=\"&AF59","v":"&cb="}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの位置の向き",{"$f":"VLOOKUP(Q19,$P$73:$Q$76,2, FALSE())","v":{"$error":"#N/A"}}]
[null,null,"エラーチェック情報"]
[null,null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック",{"$f":"IF(S54>0,\"エラー有\",\"エラー無\")","v":"エラー有"},{"$f":"S54","v":1},"個",null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E76=1,\"エラー無\",\"エラー有\")","v":"エラー有"},null,null,{"$f":"E76","v":0},"個",null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,{"$f":"IF(X42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X42","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E75>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E75","v":0},"箇所",null,null,null,"最短手数エラー有無",{"$f":"IF(Q67=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー有"},null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AB62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AB62","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"カウンタ",null,{"$f":"IF(Z42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"Z42","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S78=1, \"エラー無\",\"エラー有\")","v":"エラー有"},null,null,null,"隙間あり",null,{"$f":"IF(X62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X62","v":0},"個"]
[]
[]
[null,"ここより下は計算用（主にエラーチェック用）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,"コマンドブロックのカウンタ"]
[null,null,null,{"$f":"IF(OR(EXACT(D8,\"A\"),EXACT(D8,\"Ａ\"),EXACT(D8,\"a\"),EXACT(D8,\"ａ\")),3,IF(OR(EXACT(D8,\"P\"),EXACT(D8,\"Ｐ\"),EXACT(D8,\"p\"),EXACT(D8,\"ｐ\")),2, IF(OR(EXACT(D8,\"X\"),EXACT(D8,\"Ｘ\"),EXACT(D8,\"x\"),EXACT(D8,\"ｘ\")),1,0)))","v":1},{"$f":"IF(OR(EXACT(E8,\"A\"),EXACT(E8,\"Ａ\"),EXACT(E8,\"a\"),EXACT(E8,\"ａ\")),3,IF(OR(EXACT(E8,\"P\"),EXACT(E8,\"Ｐ\"),EXACT(E8,\"p\"),EXACT(E8,\"ｐ\")),2, IF(OR(EXACT(E8,\"X\"),EXACT(E8,\"Ｘ\"),EXACT(E8,\"x\"),EXACT(E8,\"ｘ\")),1,0)))","v":1},1,1,1,1,1,1,1,1,1,null,"コマンドブロック",null,null,null,null,null,null,null,"エラー有無",null,"エラー有無",null,null,null,null,"１段目",{"$f":"D41&E41&F41&G41&H41&I41&J41&K41&L41&M41&N41&AG41","v":"11111111111,"},","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,{"$f":"SUM(X43:X58)","v":0},null,{"$f":"SUM(Z43:Z58)","v":0},null,null,null,null,"次",{"$f":"D42&E42&F42&G42&H42&I42&J42&K42&L42&M42&N42&AG42","v":"10000000001,"},","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"前進",{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, 0)","v":0},{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, -1)","v":0},{"$f":"IF(R43<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$63:$V$68,2,FALSE()),\"\")","v":""},{"$f":"IF(U43<>\"\", V9, \"\")","v":""},{"$f":"IF(U43<>\"\", \",\", \"\")","v":""},{"$f":"IF(AND(U43=\"\",U9<>\"\"),1,0)","v":0},null,{"$f":"IF(OR(U43=\"\", AND(OR(U43=4,U43=5,U43=6), OR(V43=0,V43=\"\")),AND(U43=1,OR(V43=1,V43=2,V43=3,V43=4)), AND(U43=2,OR(V43=0,V43=1,V43=2,V43=3)),AND(U43=3,OR(V43=0,V43=1,V43=2,V43=3,V43=4))),0, 1)","v":0},"エラー検出ロジック",null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"回転",{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, 0)","v":0},{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, -1)","v":0},{"$f":"IF(R44<0, 1, 0)","v":0},2,"","","",0,null,0,"コマンドブロックが4か5か6 でカウンタ0か空白なら0、それ以外なら1",null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"LOOP",{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, 0)","v":0},{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, -1)","v":0},{"$f":"IF(R45<0, 1, 0)","v":0},3,"","","",0,null,0,"1で1,2,3,4 なら0、それ以外なら1",null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"IF",{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, 0)","v":0},{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, -1)","v":0},{"$f":"IF(R46<0, 1, 0)","v":0},4,"","","",0,null,0,"2で0,1,2,3 なら0、それ以外なら1",null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,null,null,null,null,5,"","","",0,null,0,"3で0,1,2,3,4なら0、それ以外なら１",null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"個数が数値かどうか",null,{"$f":"AND(Q49:Q52)","v":false},{"$f":"IF(R48,0,1)","v":1},6,"","","",0,null,0,null,null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"前進",{"$f":"ISNUMBER(Q9)","v":false},null,null,7,"","","",0,null,0,null,null,null,null,"次","10000000001,",","]
[null,null,null,1,0,0,0,0,0,0,0,0,0,1,null,"回転",{"$f":"ISNUMBER(Q10)","v":false},null,null,8,"","","",0,null,0,null,null,null,null,"次","10000000001,",","]
[null,null,null,1,1,1,1,1,1,1,1,1,1,1,null,"LOOP",{"$f":"ISNUMBER(Q11)","v":false},null,null,9,"","","",0,null,0,null,null,null,null,"次","11111111111,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF",{"$f":"ISNUMBER(Q12)","v":false},null,null,10,"","","",0,null,0,null,null,null,null,"ステージ内容",{"$f":"AF41&AF42&AF43&AF44&AF45&AF46&AF47&AF48&AF49&AF50&AF51","v":"11111111111,10000000001,10000000001,10000000001,10000000001,10000000001,10000000001,10000000001,10000000001,10000000001,11111111111,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S43:S48)","v":1},12,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","","",0,null,0]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","","",0,null,0,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック内容",{"$f":"AF60&AF61&AF62&AF63&AF64&AF65&AF66&AF67&AF68&AF69&AF70&AF71&AF72&AF73&AF74&AF75","v":""}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D60)*1))","v":0},null,"旗",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）",null,null,null,null,null,null,null,{"$f":"IF(AG60<>\"\",AG60&AH60&AI60,\"\")","v":""},{"$f":"U43","v":""},"",{"$f":"IF(AG60<>\"\", \",\", \"\")","v":""}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D61)*1))","v":40},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"隙間チェック",null,null,"コマンドブロックの数",null,null,null,null,{"$f":"IF(AF60<>\"\",IF(AG61<>\"\",AG61&AH61&AI61,\"\"),\"\")","v":""},"","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D62)*1))","v":0},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X64:X78)","v":0},null,null,"エラー数",{"$f":"SUM(AB64:AB69)","v":0},null,null,null,"","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D63)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,1,null,null,null,"利用数","エラー有無",null,null,null,"","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D64)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q17)","v":false},null,null,null,"回転",2,2,{"$f":"IF(AND(U44<>\"\",U43=\"\"),1,0)","v":0},null,1,{"$f":"COUNTIF($U$43:$U$58,Z64)","v":0},{"$f":"IF(AA64<=Q9,0,1)","v":0},null,null,null,"","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D65)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q64=TRUE(),Q17=INT(Q17)),0,1)","v":1},"0ならエラー無",null,null,"LOOP",3,3,0,null,2,0,0,null,null,null,"","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D66)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上16以下か",{"$f":"IF(AND(Q64=TRUE(),Q17>=1,Q17<=16),0,1)","v":1},"0ならエラー無",null,null,"IF",4,4,0,null,3,0,0,null,null,null,"","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D67)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q65,Q66)","v":true},"FALSEならエラー無",null,null,"ELSE",5,5,0,null,4,0,0,null,null,null,"","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D68)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END",6,6,0,null,5,0,0,null,null,null,"","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D69)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,6,0,0,null,null,null,"","","",""]
[null,null,null,"ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D70)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D71)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,10,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,\"\")*1))","v":81},null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$19,P73)","v":0},null,null,null,11,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"合計",{"$f":"SUM(E60:E73)","v":121},null,null,null,null,null,null,null,null,null,null,"右",1,null,{"$f":"COUNTIF($Q$19,P74)","v":0},null,null,null,12,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"不整合な文字列の個数",{"$f":"11*11 - E74","v":0},null,null,null,null,null,null,null,null,null,null,"下",2,null,{"$f":"COUNTIF($Q$19,P75)","v":0},null,null,null,13,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,{"$f":"E62+E65+E68+E71","v":0},"ロボットの数",null,null,null,null,null,null,null,null,null,"左",3,null,{"$f":"COUNTIF($Q$19,P76)","v":0},null,null,null,14,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S73:S76)","v":0},null,null,null,16,0]

{"sheet":"使い方","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"アルゴロジック2EX かんたん作成支援ツール 使い方"]
[]
[null,null,null,null,null,null,null,null,"アルゴロジック2EX かんたん作成支援ツール"]
[null,null,null,null,null,null,null,null,"© 2024 JEITA"]
[null,null,null,null,null,null,null,null,"一般社団法人 電子情報技術産業協会 IT人材育成WG"]
[null,"1. 旗、壁、ロボットをステージに置く。"]
[null,null,"旗は「P」、壁は「X」、ロボットは「A」"]
[null,"2. 使えるコマンドブロックの数を、コマンドブロック数の表の個数に、それぞれ書く"]
[null,"3. さいしょのロボットの向きを、８つから選んで書く。（上、下、左、右、右上、右下、左上、左下）"]
[null,"4. クリアするのに必要最小な、コマンドの段数を、最短手数に書く"]
[null,"5. 右上の「問題のURL」の右にURLが表示されたら、クリックして問題を見る"]
[null,null,"LibreOfficeの場合は、Ctrl+クリックする"]
[]
[null,null,"URLが「#VALUE!」エラーとなっている場合"]
[null,null,"マクロを使えるときは、「問題表示」をマウスでクリックする"]
[null,null,"マクロを使えないときは、セルAF4の「値をコピー」して、ブラウザのURL欄にペーストして使う"]
[]
[null,null,"「アルゴロジック2EXエラー」というエラーが表示されるときは、エラーの内容を読んで、「エラーチェック情報」のヒントも見て、問題を修正する"]
[null,"6. 問題を配布するときは、セルAF4の「値をコピー」して使う"]
[]
[null,"7. さらに活用する場合"]
[null,null,"問題に名前をつけたいときは、問題名称に書く"]
[null,null,"問題の解答やその一部もあらかじめ置きたいときは、コマンドブロック配置エリアに書き、"]
[null,null,"「全体のURL」あるいは「全体表示」で、問題の解答やその一部も表示できる"]
[]
[null,"このワークシートを改変したいとき"]
[null,null,"このワークシートは、クリエイティブ・コモンズ・ライセンス　CC BY 4.0　に従います。"]
[null,null,"アルゴロジック2EX かんたん作成支援ツール © 2024 by JEITA is licensed under CC BY 4.0. To view a copy of this license, visit https://creativecommons.org/licenses/by/4.0/"]

{"sheet":"使用例","index":4,"n_rows":78,"n_cols":35,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック2EX かんたん作成支援ツール",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024年8月16日版",null,null,null,null,null,null,null,"ここより右は計算用(URL作成用）"]
[null,null,null,"7x7 問題作成用ワークシート",null,null,null,null,null,null,null,null,null,null,null,"問題名称（オプション）",null,null,null,null,"問題のURL",null,{"$f":"HYPERLINK(AF4,AF4)","v":"https://algo.jeita.or.jp/ex/2/?algo=20&stage=0707,1000,0,01,1111111,1002001,1000001,1000001,1003001,1000001,1111111,&name=%E7%A7%BB%E5%8B%95"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"移動",null,null,null,null,"全体のURL",null,{"$f":"HYPERLINK(AF5,AF5)","v":"https://algo.jeita.or.jp/ex/2/?algo=20&stage=0707,1000,0,01,1111111,1002001,1000001,1000001,1003001,1000001,1111111,&name=%E7%A7%BB%E5%8B%95&cb=11,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑をクリックすると直接問題を表示できます。",null,null,null,null,null,null,null,"問題のURL",{"$f":"AF27&AF28&AF29","v":"https://algo.jeita.or.jp/ex/2/?algo=20&stage=0707,1000,0,01,1111111,1002001,1000001,1000001,1003001,1000001,1111111,&name=%E7%A7%BB%E5%8B%95"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"↑右上が「#VALUE!」エラー表示のときはこちらをクリック。マクロが使えないときは、AF4やAF5の値をコピーして使ってください",null,null,null,null,null,null,null,null,null,null,null,"全体のURL",{"$f":"AF27&AF28&AF29&AF30","v":"https://algo.jeita.or.jp/ex/2/?algo=20&stage=0707,1000,0,01,1111111,1002001,1000001,1000001,1003001,1000001,1111111,&name=%E7%A7%BB%E5%8B%95&cb=11,"}]
[null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,1,2,3,4,5,6,7,null,null,null,null,null,"コマンドブロック数",null,null,null,null,"（あらかじめ並べておくコマンドブロック、解答例）"]
[null,null,1,"X","X","X","X","X","X","X",null,null,null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ",null,"参考"]
[null,null,2,"X",null,null,"P",null,null,"X",null,null,null,null,null,"前進",1,4,null,1,"前進",1,null,"コマンドブロック","カウンタの値",null,null,null,null,null,null,null,"アルゴロジック2EX かんたん作成支援ツール"]
[null,null,3,"X",null,null,null,null,null,"X",null,null,null,null,null,"回転",0,4,null,2,null,null,null,"前進","1,2,3,4",null,null,null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,"X",null,null,null,null,null,"X",null,null,null,null,null,"LOOP",0,2,null,3,null,null,null,"回転","0,1,2,3",null,null,null,null,null,"識別子１","?"]
[null,null,5,"X",null,null,"A",null,null,"X",null,null,null,null,null,"IF",0,2,null,4,null,null,null,"LOOP","0,1,2,3,4",null,null,null,null,null,"バージョン","algo=20"]
[null,null,6,"X",null,null,null,null,null,"X",null,null,null,null,null,"ELSE",{"$f":"Q12","v":0},{"$f":"Q13","v":0},null,5,null,null,null,"IF",0,null,null,null,null,null,"識別子2","&stage="]
[null,null,7,"X","X","X","X","X","X","X",null,null,null,null,null,"END",{"$f":"Q11+Q12","v":0},{"$f":"Q14","v":0},null,6,null,null,null,"ELSE",0,null,null,null,null,null,"ステージサイズ","0707",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,"END",0,null,null,null,null,null,"コマンドブロック数",{"$f":"Q43&Q44&Q45&Q46","v":"1000"},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",{"$f":"AF31","v":0},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",1,"16以下",null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q17))&Q17","v":"01"},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き","上",null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,"コピー用（ステージ）",null,null,null,null,null,null,null,null,null,null,null,"コピー用（ロボットの向き）"]
[null,null,null,null,"P","旗",null,null,null,null,null,null,null,null,null,null,"上",null,null,null,"コピー用（コマンドブロック）",null,null,null,null,null,null,null,null,null,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右",null,null,null,"前進","IF",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/2/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"下",null,null,null,"回転","ELSE",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF52","v":"?algo=20&stage=0707,1000,0,01,1111111,1002001,1000001,1000001,1003001,1000001,1111111,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",null,null,null,"LOOP","END",null,null,null,null,null,null,null,null,"名前部",{"$f":"IF(P3<>\"\",\"&name=\"&_xlfn.ENCODEURL(P3),\"\")","v":"&name=%E7%A7%BB%E5%8B%95"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"解答部",{"$f":"\"&cb=\"&AF59","v":"&cb=11,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの位置の向き",{"$f":"VLOOKUP(Q19,$P$73:$Q$76,2, FALSE())","v":0}]
[null,null,"エラーチェック情報"]
[null,null,null,"ステージ",null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック",{"$f":"IF(S54>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"S54","v":0},"個",null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E76=1,\"エラー無\",\"エラー有\")","v":"エラー無"},null,null,{"$f":"E76","v":1},"個",null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,{"$f":"IF(X42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X42","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E75>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E75","v":0},"箇所",null,null,null,"最短手数エラー有無",{"$f":"IF(Q67=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AB62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AB62","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"カウンタ",null,{"$f":"IF(Z42>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"Z42","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S78=1, \"エラー無\",\"エラー有\")","v":"エラー無"},null,null,null,"隙間あり",null,{"$f":"IF(X62>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X62","v":0},"個"]
[]
[]
[null,"ここより下は計算用（主にエラーチェック用）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,"コマンドブロックのカウンタ"]
[null,null,null,{"$f":"IF(OR(EXACT(D8,\"A\"),EXACT(D8,\"Ａ\"),EXACT(D8,\"a\"),EXACT(D8,\"ａ\")),3,IF(OR(EXACT(D8,\"P\"),EXACT(D8,\"Ｐ\"),EXACT(D8,\"p\"),EXACT(D8,\"ｐ\")),2, IF(OR(EXACT(D8,\"X\"),EXACT(D8,\"Ｘ\"),EXACT(D8,\"x\"),EXACT(D8,\"ｘ\")),1,0)))","v":1},1,1,1,1,1,1,null,null,null,null,null,"コマンドブロック",null,null,null,null,null,null,null,"エラー有無",null,"エラー有無",null,null,null,null,"１段目",{"$f":"D41&E41&F41&G41&H41&I41&J41&AK41&AG41","v":"1111111,"},","]
[null,null,null,1,0,0,2,0,0,1,null,null,null,null,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,{"$f":"SUM(X43:X58)","v":0},null,{"$f":"SUM(Z43:Z58)","v":0},null,null,null,null,"次",{"$f":"D42&E42&F42&G42&H42&I42&J42&AK42&AG42","v":"1002001,"},","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"前進",{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, 0)","v":1},{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, -1)","v":1},{"$f":"IF(R43<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$63:$V$68,2,FALSE()),\"\")","v":1},{"$f":"IF(U43<>\"\", V9, \"\")","v":1},{"$f":"IF(U43<>\"\", \",\", \"\")","v":","},{"$f":"IF(AND(U43=\"\",U9<>\"\"),1,0)","v":0},null,{"$f":"IF(OR(U43=\"\", AND(OR(U43=4,U43=5,U43=6), OR(V43=0,V43=\"\")),AND(U43=1,OR(V43=1,V43=2,V43=3,V43=4)), AND(U43=2,OR(V43=0,V43=1,V43=2,V43=3)),AND(U43=3,OR(V43=0,V43=1,V43=2,V43=3,V43=4))),0, 1)","v":0},"エラー検出ロジック",null,null,null,"次","1000001,",","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"回転",{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, 0)","v":0},{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, -1)","v":0},{"$f":"IF(R44<0, 1, 0)","v":0},2,"","","",0,null,0,"コマンドブロックが4か5か6 でカウンタ0か空白なら0、それ以外なら1",null,null,null,"次","1000001,",","]
[null,null,null,1,0,0,3,0,0,1,null,null,null,null,null,"LOOP",{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, 0)","v":0},{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, -1)","v":0},{"$f":"IF(R45<0, 1, 0)","v":0},3,"","","",0,null,0,"1で1,2,3,4 なら0、それ以外なら1",null,null,null,"次","1003001,",","]
[null,null,null,1,0,0,0,0,0,1,null,null,null,null,null,"IF",{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, 0)","v":0},{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, -1)","v":0},{"$f":"IF(R46<0, 1, 0)","v":0},4,"","","",0,null,0,"2で0,1,2,3 なら0、それ以外なら1",null,null,null,"次","1000001,",","]
[null,null,null,1,1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,5,"","","",0,null,0,"3で0,1,2,3,4なら0、それ以外なら１",null,null,null,"次","1111111,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"個数が数値かどうか",null,{"$f":"AND(Q49:Q52)","v":true},{"$f":"IF(R48,0,1)","v":0},6,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"前進",{"$f":"ISNUMBER(Q9)","v":true},null,null,7,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q10)","v":true},null,null,8,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LOOP",{"$f":"ISNUMBER(Q11)","v":true},null,null,9,"","","",0,null,0,null,null,null,null,null,{"$f":"AJ41&AK41&AJ42&AK42&AJ43&AK43&AJ44&AK44&AJ45&AK45&AJ46&AK46&AJ47&AK47&AJ48&AK48&AJ49&AK49","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF",{"$f":"ISNUMBER(Q12)","v":true},null,null,10,"","","",0,null,0,null,null,null,null,"ステージ内容",{"$f":"AF41&AF42&AF43&AF44&AF45&AF46&AF47","v":"1111111,1002001,1000001,1000001,1003001,1000001,1111111,"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S43:S48)","v":0},12,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"","","",0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"","","",0,null,0]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"","","",0,null,0,null,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック内容",{"$f":"AF60&AF61&AF62&AF63&AF64&AF65&AF66&AF67&AF68&AF69&AF70&AF71&AF72&AF73&AF74&AF75","v":"11,"}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D60)*1))","v":1},null,"旗",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック配置エリア（オプション）",null,null,null,null,null,null,null,{"$f":"IF(AG60<>\"\",AG60&AH60&AI60,\"\")","v":"11,"},{"$f":"U43","v":1},1,{"$f":"IF(AG60<>\"\", \",\", \"\")","v":","}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D61)*1))","v":24},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"隙間チェック",null,null,"コマンドブロックの数",null,null,null,null,{"$f":"IF(AF60<>\"\",IF(AG61<>\"\",AG61&AH61&AI61,\"\"),\"\")","v":""},"","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D62)*1))","v":1},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X64:X78)","v":0},null,null,"エラー数",{"$f":"SUM(AB64:AB69)","v":0},null,null,null,"","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D63)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,1,null,null,null,"利用数","エラー有無",null,null,null,"","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D64)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q17)","v":true},null,null,null,"回転",2,2,{"$f":"IF(AND(U44<>\"\",U43=\"\"),1,0)","v":0},null,1,{"$f":"COUNTIF($U$43:$U$58,Z64)","v":1},{"$f":"IF(AA64<=Q9,0,1)","v":0},null,null,null,"","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D65)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q64=TRUE(),Q17=INT(Q17)),0,1)","v":0},"0ならエラー無",null,null,"LOOP",3,3,0,null,2,0,0,null,null,null,"","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D66)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上16以下か",{"$f":"IF(AND(Q64=TRUE(),Q17>=1,Q17<=16),0,1)","v":0},"0ならエラー無",null,null,"IF",4,4,0,null,3,0,0,null,null,null,"","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D67)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q65,Q66)","v":false},"FALSEならエラー無",null,null,"ELSE",5,5,0,null,4,0,0,null,null,null,"","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D68)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"END",6,6,0,null,5,0,0,null,null,null,"","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D69)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,6,0,0,null,null,null,"","","",""]
[null,null,null,"ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D70)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D71)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,10,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,\"\")*1))","v":23},null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$19,P73)","v":1},null,null,null,11,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"合計",{"$f":"SUM(E60:E73)","v":49},null,null,null,null,null,null,null,null,null,null,"右",1,null,{"$f":"COUNTIF($Q$19,P74)","v":0},null,null,null,12,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,"不整合な文字列の個数",{"$f":"7*7 - E74","v":0},null,null,null,null,null,null,null,null,null,null,"下",2,null,{"$f":"COUNTIF($Q$19,P75)","v":0},null,null,null,13,0,null,null,null,null,null,null,null,"","","",""]
[null,null,null,null,{"$f":"E62+E65+E68+E71","v":1},"ロボットの数",null,null,null,null,null,null,null,null,null,"左",3,null,{"$f":"COUNTIF($Q$19,P76)","v":0},null,null,null,14,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S73:S76)","v":1},null,null,null,16,0]