{"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":76,"n_cols":38,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック1EX かんたん作成支援ツール",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":"AF22&AF23&AF24","v":{"$error":"#N/A"}}]
[null,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,"全体のURL",{"$f":"AF22&AF23&AF24&AF25","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,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ","コマンドブロック2","カウンタ2",null,"参考"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,"前進",null,4,null,1,null,null,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,"アルゴロジック1EX かんたん作成支援ツール"]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,"右進",null,4,null,2,null,null,null,null,null,"前進","1,2,3,4,8",null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,"左進",null,4,null,3,null,null,null,null,null,"右進","1,2,3,4,8",null,null,null,"識別子１","?"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,"回転",null,4,null,4,null,null,null,null,null,"左進","1,2,3,4,8",null,null,null,"バージョン","algo=10"]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",null,3,null,5,null,null,null,null,null,"回転","0,1,2,3,4,5,6,7",null,null,null,"識別子2","&stage="]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,"繰返し始め","1,2,3,4,8",null,null,null,"ステージサイズ","0707",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",null,"11以下",null,7,null,null,null,null,null,"繰返し終り","(なし)",null,null,null,"コマンドブロック数",{"$f":"Q38&Q39&Q40&Q41&Q42","v":"00000"},","]
[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":"AF26","v":{"$error":"#N/A"}},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",null,null,null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q15))&Q15","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,null,11]
[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,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右上","左下",null,null,"前進","回転",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/1/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"右","左",null,null,"右進","繰返し始め",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF47","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,"名前部",{"$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=\"&AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","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(Q17,$P$62:$Q$69,2, FALSE())","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,null,null,null,null,"コマンドブロック数",{"$f":"IF(S49>0,\"エラー有\",\"エラー無\")","v":"エラー有"},{"$f":"S49","v":1},"個",null,"コマンドブロックの種類",null,{"$f":"IF(AA37>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA37","v":0},"個"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E66=1,\"エラー無\",\"エラー有\")","v":"エラー有"},null,null,{"$f":"E66","v":0},"個",null,null,null,null,null,null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AA66>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA66","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E65","v":0},"個",null,null,null,"最短手数エラー有無",{"$f":"IF(Q57=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー有"},null,null,null,"繰り返しの位置",null,{"$f":"IF(X51>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X51","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(AA52>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA52","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S70=1, \"エラー無\",\"エラー有\")","v":"エラー有"},null,null,null,"隙間あり（左列）",null,{"$f":"IF(X65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X65","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,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":0},{"$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":0},0,0,0,0,0,null,null,null,null,null,"コマンドブロック数",null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,null,null,null,"１段目",{"$f":"D36&E36&F36&G36&H36&I36&J36&AG36","v":"0000000,"},","]
[null,null,null,{"$f":"IF(OR(EXACT(D9,\"A\"),EXACT(D9,\"Ａ\"),EXACT(D9,\"a\"),EXACT(D9,\"ａ\")),3,IF(OR(EXACT(D9,\"P\"),EXACT(D9,\"Ｐ\"),EXACT(D9,\"p\"),EXACT(D9,\"ｐ\")),2, IF(OR(EXACT(D9,\"X\"),EXACT(D9,\"Ｘ\"),EXACT(D9,\"x\"),EXACT(D9,\"ｘ\")),1,0)))","v":0},0,0,0,0,0,0,null,null,null,null,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,null,null,"エラー有無",{"$f":"SUM(Z38:AA48)","v":0},null,null,null,"次",{"$f":"D37&E37&F37&G37&H37&I37&J37&AG37","v":"0000000,"},","]
[null,null,null,0,0,0,0,0,0,0,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(R38<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U38<>\"\", V9, \"\")","v":""},{"$f":"IFERROR(VLOOKUP(W9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(W38<>\"\", X9, \"\")","v":""},{"$f":"IF(U38<>\"\", \",\", \"\")","v":""},{"$f":"IF(AND(U38=\"\",U9<>\"\"),1,0)","v":0},{"$f":"IF(AND(W38=\"\",W9<>\"\"),1,0)","v":0},null,null,null,"次","0000000,",","]
[null,null,null,0,0,0,0,0,0,0,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(R39<0, 1, 0)","v":0},2,"","","","","",0,0,null,null,null,"次","0000000,",","]
[null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,"左進",{"$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(R40<0, 1, 0)","v":0},3,"","","","","",0,0,null,null,null,"次","0000000,",","]
[null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,"回転",{"$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(R41<0, 1, 0)","v":0},4,"","","","","",0,0,null,null,null,"次","0000000,",","]
[null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,"繰返し",{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, 0)","v":0},{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, -1)","v":0},{"$f":"IF(R42<0, 1, 0)","v":0},5,"","","","","",0,0,null,null,null,"次","0000000,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"個数が数値かどうか",null,{"$f":"AND(Q44:Q48)","v":false},{"$f":"IF(R43,0,1)","v":1},6,"","","","","",0,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,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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左進",{"$f":"ISNUMBER(Q11)","v":false},null,null,9,"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q12)","v":false},null,null,10,"","","","","",0,0,null,null,null,"ステージ内容",{"$f":"AF36&AF37&AF38&AF39&AF40&AF41&AF42&AF43&AF44","v":"0000000,0000000,0000000,0000000,0000000,0000000,0000000,"}]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",{"$f":"ISNUMBER(Q13)","v":false},null,null,11,"","","","","",0,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S38:S43)","v":1},null,{"$f":"IFERROR(VLOOKUP(U19,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U49<>\"\", V19, \"\")","v":""},"コマンドブロック配置エリア（オプション）",null,"",null,null,null,null,null,"コマンドブロック内容",{"$f":"AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","v":""}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D50)*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,{"$f":"IF(AG50<>\"\",IF(AJ50<>\"\",AG50&AH50&AI50&AJ50&AK50&AL50,AG50&AH50&AL50),\"\")","v":""},{"$f":"U38","v":""},"",{"$f":"IF(AJ50<>\"\", \"-\", \"\")","v":""},{"$f":"W38","v":""},"",{"$f":"IF(AG50<>\"\", \",\", \"\")","v":""}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D51)*1))","v":0},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"エラー有無",{"$f":"SUM(W53:X63)","v":0},null,"コマンドブロックのカウンタ",null,null,null,null,null,{"$f":"IF(AF50<>\"\", IF(AG51<>\"\",IF(AJ51<>\"\",AG51&AH51&AI51&AJ51&AK51&AL51,AG51&AH51&AL51),\"\"),\"\")","v":""},"","","","","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D52)*1))","v":0},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返しに右がある","右にある",null,"エラー有無",{"$f":"SUM(Z53:AA63)","v":0},null,null,null,null,"","","","","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D53)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,{"$f":"IF(AND(OR(U38=5,U38=6),ISNUMBER(W38)),1,0)","v":0},{"$f":"IF(OR(W38=5,W38=6),1,0)","v":0},1,{"$f":"IF(OR(U38=\"\",AND(U38=6,V38=0),AND(U38=4,V38=5),AND(U38=4,V38=6),AND(U38=4,V38=7),AND(OR(U38=1,U38=2,U38=3,U38=5),V38=8),AND(OR(U38=1,U38=2,U38=3,U38=4,U38=5),OR(V38=1,V38=2,V38=3,V38=4))), 0, 1)","v":0},{"$f":"IF(OR(W38=\"\",AND(W38=6,X38=0),AND(W38=4,X38=5),AND(W38=4,X38=6),AND(W38=4,X38=7),AND(OR(W38=1,W38=2,W38=3,W38=5),X38=8),AND(OR(W38=1,W38=2,W38=3,W38=4,W38=5),OR(X38=1,X38=2,X38=3,X38=4))), 0, 1)","v":0},"空白なら0、それ以外なら1",null,null,null,"","","","","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D54)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q15)","v":false},null,null,null,"右進",2,0,0,2,0,0,"6で空白なら0",null,null,null,"","","","","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D55)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q54=TRUE(),Q15=INT(Q15)),0,1)","v":1},"0ならエラー無",null,null,"左進",3,0,0,3,0,0,"4で5,7なら0",null,null,null,"","","","","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D56)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上11以下か",{"$f":"IF(AND(Q54=TRUE(),Q15>=1,Q15<=11),0,1)","v":1},"0ならエラー無",null,null,"回転",4,0,0,4,0,0,"1,2,3,5で8なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D57)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q55,Q56)","v":true},"FALSEならエラー無",null,null,"繰返し始め",5,0,0,5,0,0,"1,2,3,4,5で1,2,3,4なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D58)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し終り",6,0,0,6,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D59)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,7,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｘ",{"$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,0,0,8,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D61)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,0,0,9,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$17,P62)","v":0},null,null,null,0,0,10,0,0]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,\"\")*1))","v":49},null,null,null,null,null,null,null,null,null,null,"右上",1,null,0,null,null,null,0,0,11,0,0]
[null,null,null,"合計",{"$f":"SUM(E50:E63)","v":49},null,null,null,null,null,null,null,null,null,null,"右",2,null,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"不整合な文字列の個数",{"$f":"7*7 - E64","v":0},null,null,null,null,null,null,null,null,null,null,"右下",3,null,0,null,null,null,"隙間チェック",{"$f":"SUM(W67:W76)","v":0},null,"コマンドブロック数の範囲内か"]
[null,null,null,null,{"$f":"E52+E55+E58+E61","v":0},"ロボットの数",null,null,null,null,null,null,null,null,null,"下",4,null,0,null,null,1,null,null,null,"エラー数",{"$f":"SUM(AA68:AA72)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左下",5,null,0,null,null,2,{"$f":"IF(AND(U39<>\"\",U38=\"\"),1,0)","v":0},null,null,"利用数","エラー有無"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",6,null,0,null,null,3,0,null,1,{"$f":"COUNTIF($U$38:$U$49,Y68)+COUNTIF($W$38:$W$48,Y68)","v":0},{"$f":"IF(Z68<=Q9,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左上",7,null,0,null,null,4,0,null,2,{"$f":"COUNTIF($U$38:$U$49,Y69)+COUNTIF($W$38:$W$48,Y69)","v":0},{"$f":"IF(Z69<=Q10,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S62:S69)","v":0},null,null,5,0,null,3,{"$f":"COUNTIF($U$38:$U$49,Y70)+COUNTIF($W$38:$W$48,Y70)","v":0},{"$f":"IF(Z70<=Q11,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,null,4,{"$f":"COUNTIF($U$38:$U$49,Y71)+COUNTIF($W$38:$W$48,Y71)","v":0},{"$f":"IF(Z71<=Q12,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,5,{"$f":"COUNTIF($U$38:$U$49,Y72)+COUNTIF($W$38:$W$48,Y72)","v":0},{"$f":"IF(Z72<=Q13,0,1)","v":0}]
[null,null,null,null,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,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,10,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0]

{"sheet":"9x9","index":1,"n_rows":76,"n_cols":38,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック1EX かんたん作成支援ツール",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":"AF22&AF23&AF24","v":{"$error":"#N/A"}}]
[null,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,"全体のURL",{"$f":"AF22&AF23&AF24&AF25","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,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ","コマンドブロック2","カウンタ2",null,"参考"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,"前進",null,4,null,1,null,null,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,"アルゴロジック1EX かんたん作成支援ツール"]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,"右進",null,4,null,2,null,null,null,null,null,"前進","1,2,3,4,8",null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,"左進",null,4,null,3,null,null,null,null,null,"右進","1,2,3,4,8",null,null,null,"識別子１","?"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,"回転",null,4,null,4,null,null,null,null,null,"左進","1,2,3,4,8",null,null,null,"バージョン","algo=10"]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",null,3,null,5,null,null,null,null,null,"回転","0,1,2,3,4,5,6,7",null,null,null,"識別子2","&stage="]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,"繰返し始め","1,2,3,4,8",null,null,null,"ステージサイズ","0909",","]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",null,"11以下",null,7,null,null,null,null,null,"繰返し終り","(なし)",null,null,null,"コマンドブロック数",{"$f":"Q38&Q39&Q40&Q41&Q42","v":"00000"},","]
[null,null,9,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":"AF26","v":{"$error":"#N/A"}},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",null,null,null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q15))&Q15","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,null,11]
[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,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右上","左下",null,null,"前進","回転",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/1/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"右","左",null,null,"右進","繰返し始め",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF47","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,"名前部",{"$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=\"&AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","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(Q17,$P$62:$Q$69,2, FALSE())","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,null,null,null,null,"コマンドブロック数",{"$f":"IF(S49>0,\"エラー有\",\"エラー無\")","v":"エラー有"},{"$f":"S49","v":1},"個",null,"コマンドブロックの種類",null,{"$f":"IF(AA37>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA37","v":0},"個"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E66=1,\"エラー無\",\"エラー有\")","v":"エラー有"},null,null,{"$f":"E66","v":0},"個",null,null,null,null,null,null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AA66>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA66","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E65","v":0},"個",null,null,null,"最短手数エラー有無",{"$f":"IF(Q57=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー有"},null,null,null,"繰り返しの位置",null,{"$f":"IF(X51>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X51","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(AA52>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA52","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S70=1, \"エラー無\",\"エラー有\")","v":"エラー有"},null,null,null,"隙間あり（左列）",null,{"$f":"IF(X65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X65","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,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":0},{"$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":0},0,0,0,0,0,0,0,null,null,null,"コマンドブロック数",null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,null,null,null,"１段目",{"$f":"D36&E36&F36&G36&H36&I36&J36&K36&L36&AG36","v":"000000000,"},","]
[null,null,null,{"$f":"IF(OR(EXACT(D9,\"A\"),EXACT(D9,\"Ａ\"),EXACT(D9,\"a\"),EXACT(D9,\"ａ\")),3,IF(OR(EXACT(D9,\"P\"),EXACT(D9,\"Ｐ\"),EXACT(D9,\"p\"),EXACT(D9,\"ｐ\")),2, IF(OR(EXACT(D9,\"X\"),EXACT(D9,\"Ｘ\"),EXACT(D9,\"x\"),EXACT(D9,\"ｘ\")),1,0)))","v":0},0,0,0,0,0,0,0,0,null,null,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,null,null,"エラー有無",{"$f":"SUM(Z38:AA48)","v":0},null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,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(R38<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U38<>\"\", V9, \"\")","v":""},{"$f":"IFERROR(VLOOKUP(W9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(W38<>\"\", X9, \"\")","v":""},{"$f":"IF(U38<>\"\", \",\", \"\")","v":""},{"$f":"IF(AND(U38=\"\",U9<>\"\"),1,0)","v":0},{"$f":"IF(AND(W38=\"\",W9<>\"\"),1,0)","v":0},null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,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(R39<0, 1, 0)","v":0},2,"","","","","",0,0,null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,"左進",{"$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(R40<0, 1, 0)","v":0},3,"","","","","",0,0,null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,"回転",{"$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(R41<0, 1, 0)","v":0},4,"","","","","",0,0,null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,"繰返し",{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, 0)","v":0},{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, -1)","v":0},{"$f":"IF(R42<0, 1, 0)","v":0},5,"","","","","",0,0,null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,"個数が数値かどうか",null,{"$f":"AND(Q44:Q48)","v":false},{"$f":"IF(R43,0,1)","v":1},6,"","","","","",0,0,null,null,null,"次","000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,"前進",{"$f":"ISNUMBER(Q9)","v":false},null,null,7,"","","","","",0,0,null,null,null,"次","000000000,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"右進",{"$f":"ISNUMBER(Q10)","v":false},null,null,8,"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左進",{"$f":"ISNUMBER(Q11)","v":false},null,null,9,"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q12)","v":false},null,null,10,"","","","","",0,0,null,null,null,"ステージ内容",{"$f":"AF36&AF37&AF38&AF39&AF40&AF41&AF42&AF43&AF44","v":"000000000,000000000,000000000,000000000,000000000,000000000,000000000,000000000,000000000,"}]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",{"$f":"ISNUMBER(Q13)","v":false},null,null,11,"","","","","",0,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S38:S43)","v":1},null,{"$f":"IFERROR(VLOOKUP(U19,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U49<>\"\", V19, \"\")","v":""},"コマンドブロック配置エリア（オプション）",null,"",null,null,null,null,null,"コマンドブロック内容",{"$f":"AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","v":""}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D50)*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,{"$f":"IF(AG50<>\"\",IF(AJ50<>\"\",AG50&AH50&AI50&AJ50&AK50&AL50,AG50&AH50&AL50),\"\")","v":""},{"$f":"U38","v":""},"",{"$f":"IF(AJ50<>\"\", \"-\", \"\")","v":""},{"$f":"W38","v":""},"",{"$f":"IF(AG50<>\"\", \",\", \"\")","v":""}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D51)*1))","v":0},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"エラー有無",{"$f":"SUM(W53:X63)","v":0},null,"コマンドブロックのカウンタ",null,null,null,null,null,{"$f":"IF(AF50<>\"\", IF(AG51<>\"\",IF(AJ51<>\"\",AG51&AH51&AI51&AJ51&AK51&AL51,AG51&AH51&AL51),\"\"),\"\")","v":""},"","","","","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D52)*1))","v":0},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返しに右がある","右にある",null,"エラー有無",{"$f":"SUM(Z53:AA63)","v":0},null,null,null,null,"","","","","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D53)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,{"$f":"IF(AND(OR(U38=5,U38=6),ISNUMBER(W38)),1,0)","v":0},{"$f":"IF(OR(W38=5,W38=6),1,0)","v":0},1,{"$f":"IF(OR(U38=\"\",AND(U38=6,V38=0),AND(U38=4,V38=5),AND(U38=4,V38=6),AND(U38=4,V38=7),AND(OR(U38=1,U38=2,U38=3,U38=5),V38=8),AND(OR(U38=1,U38=2,U38=3,U38=4,U38=5),OR(V38=1,V38=2,V38=3,V38=4))), 0, 1)","v":0},{"$f":"IF(OR(W38=\"\",AND(W38=6,X38=0),AND(W38=4,X38=5),AND(W38=4,X38=6),AND(W38=4,X38=7),AND(OR(W38=1,W38=2,W38=3,W38=5),X38=8),AND(OR(W38=1,W38=2,W38=3,W38=4,W38=5),OR(X38=1,X38=2,X38=3,X38=4))), 0, 1)","v":0},"空白なら0、それ以外なら1",null,null,null,"","","","","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D54)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q15)","v":false},null,null,null,"右進",2,0,0,2,0,0,"6で空白なら0",null,null,null,"","","","","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D55)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q54=TRUE(),Q15=INT(Q15)),0,1)","v":1},"0ならエラー無",null,null,"左進",3,0,0,3,0,0,"4で5,7なら0",null,null,null,"","","","","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D56)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上11以下か",{"$f":"IF(AND(Q54=TRUE(),Q15>=1,Q15<=11),0,1)","v":1},"0ならエラー無",null,null,"回転",4,0,0,4,0,0,"1,2,3,5で8なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D57)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q55,Q56)","v":true},"FALSEならエラー無",null,null,"繰返し始め",5,0,0,5,0,0,"1,2,3,4,5で1,2,3,4なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D58)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し終り",6,0,0,6,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D59)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,7,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｘ",{"$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,0,0,8,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,D61)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,0,0,9,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$17,P62)","v":0},null,null,null,0,0,10,0,0]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$L$16,\"\")*1))","v":81},null,null,null,null,null,null,null,null,null,null,"右上",1,null,0,null,null,null,0,0,11,0,0]
[null,null,null,"合計",{"$f":"SUM(E50:E63)","v":81},null,null,null,null,null,null,null,null,null,null,"右",2,null,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"不整合な文字列の個数",{"$f":"9*9 - E64","v":0},null,null,null,null,null,null,null,null,null,null,"右下",3,null,0,null,null,null,"隙間チェック",{"$f":"SUM(W67:W76)","v":0},null,"コマンドブロック数の範囲内か"]
[null,null,null,null,{"$f":"E52+E55+E58+E61","v":0},"ロボットの数",null,null,null,null,null,null,null,null,null,"下",4,null,0,null,null,1,null,null,null,"エラー数",{"$f":"SUM(AA68:AA72)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左下",5,null,0,null,null,2,{"$f":"IF(AND(U39<>\"\",U38=\"\"),1,0)","v":0},null,null,"利用数","エラー有無"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",6,null,0,null,null,3,0,null,1,{"$f":"COUNTIF($U$38:$U$49,Y68)+COUNTIF($W$38:$W$48,Y68)","v":0},{"$f":"IF(Z68<=Q9,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左上",7,null,0,null,null,4,0,null,2,{"$f":"COUNTIF($U$38:$U$49,Y69)+COUNTIF($W$38:$W$48,Y69)","v":0},{"$f":"IF(Z69<=Q10,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S62:S69)","v":0},null,null,5,0,null,3,{"$f":"COUNTIF($U$38:$U$49,Y70)+COUNTIF($W$38:$W$48,Y70)","v":0},{"$f":"IF(Z70<=Q11,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,null,4,{"$f":"COUNTIF($U$38:$U$49,Y71)+COUNTIF($W$38:$W$48,Y71)","v":0},{"$f":"IF(Z71<=Q12,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,5,{"$f":"COUNTIF($U$38:$U$49,Y72)+COUNTIF($W$38:$W$48,Y72)","v":0},{"$f":"IF(Z72<=Q13,0,1)","v":0}]
[null,null,null,null,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,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,10,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0]

{"sheet":"11x11","index":2,"n_rows":76,"n_cols":38,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック1EX かんたん作成支援ツール",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":"AF22&AF23&AF24","v":{"$error":"#N/A"}}]
[null,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,"全体のURL",{"$f":"AF22&AF23&AF24&AF25","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,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ","コマンドブロック2","カウンタ2",null,"参考"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,"前進",null,4,null,1,null,null,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,"アルゴロジック1EX かんたん作成支援ツール"]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,"右進",null,4,null,2,null,null,null,null,null,"前進","1,2,3,4,8",null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,"左進",null,4,null,3,null,null,null,null,null,"右進","1,2,3,4,8",null,null,null,"識別子１","?"]
[null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,"回転",null,4,null,4,null,null,null,null,null,"左進","1,2,3,4,8",null,null,null,"バージョン","algo=10"]
[null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",null,3,null,5,null,null,null,null,null,"回転","0,1,2,3,4,5,6,7",null,null,null,"識別子2","&stage="]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,"繰返し始め","1,2,3,4,8",null,null,null,"ステージサイズ","1111",","]
[null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",null,"11以下",null,7,null,null,null,null,null,"繰返し終り","(なし)",null,null,null,"コマンドブロック数",{"$f":"Q38&Q39&Q40&Q41&Q42","v":"00000"},","]
[null,null,9,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":"AF26","v":{"$error":"#N/A"}},","]
[null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き",null,null,null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q15))&Q15","v":"00"},","]
[null,null,11,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,null,11]
[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,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右上","左下",null,null,"前進","回転",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/1/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"右","左",null,null,"右進","繰返し始め",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF47","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,"名前部",{"$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=\"&AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","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(Q17,$P$62:$Q$69,2, FALSE())","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,null,null,null,null,"コマンドブロック数",{"$f":"IF(S49>0,\"エラー有\",\"エラー無\")","v":"エラー有"},{"$f":"S49","v":1},"個",null,"コマンドブロックの種類",null,{"$f":"IF(AA37>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA37","v":0},"個"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E66=1,\"エラー無\",\"エラー有\")","v":"エラー有"},null,null,{"$f":"E66","v":0},"個",null,null,null,null,null,null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AA66>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA66","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E65","v":0},"個",null,null,null,"最短手数エラー有無",{"$f":"IF(Q57=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー有"},null,null,null,"繰り返しの位置",null,{"$f":"IF(X51>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X51","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(AA52>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA52","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S70=1, \"エラー無\",\"エラー有\")","v":"エラー有"},null,null,null,"隙間あり（左列）",null,{"$f":"IF(X65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X65","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,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":0},{"$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":0},0,0,0,0,0,0,0,0,0,null,"コマンドブロック数",null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,null,null,null,"１段目",{"$f":"D36&E36&F36&G36&H36&I36&J36&K36&L36&M36&N36&AG36","v":"00000000000,"},","]
[null,null,null,{"$f":"IF(OR(EXACT(D9,\"A\"),EXACT(D9,\"Ａ\"),EXACT(D9,\"a\"),EXACT(D9,\"ａ\")),3,IF(OR(EXACT(D9,\"P\"),EXACT(D9,\"Ｐ\"),EXACT(D9,\"p\"),EXACT(D9,\"ｐ\")),2, IF(OR(EXACT(D9,\"X\"),EXACT(D9,\"Ｘ\"),EXACT(D9,\"x\"),EXACT(D9,\"ｘ\")),1,0)))","v":0},0,0,0,0,0,0,0,0,0,0,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,null,null,"エラー有無",{"$f":"SUM(Z38:AA48)","v":0},null,null,null,"次",{"$f":"D37&E37&F37&G37&H37&I37&J37&K37&L37&M37&N37&AG37","v":"00000000000,"},","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,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(R38<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U38<>\"\", V9, \"\")","v":""},{"$f":"IFERROR(VLOOKUP(W9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(W38<>\"\", X9, \"\")","v":""},{"$f":"IF(U38<>\"\", \",\", \"\")","v":""},{"$f":"IF(AND(U38=\"\",U9<>\"\"),1,0)","v":0},{"$f":"IF(AND(W38=\"\",W9<>\"\"),1,0)","v":0},null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,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(R39<0, 1, 0)","v":0},2,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"左進",{"$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(R40<0, 1, 0)","v":0},3,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"回転",{"$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(R41<0, 1, 0)","v":0},4,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"繰返し",{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, 0)","v":0},{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, -1)","v":0},{"$f":"IF(R42<0, 1, 0)","v":0},5,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"個数が数値かどうか",null,{"$f":"AND(Q44:Q48)","v":false},{"$f":"IF(R43,0,1)","v":1},6,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"前進",{"$f":"ISNUMBER(Q9)","v":false},null,null,7,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"右進",{"$f":"ISNUMBER(Q10)","v":false},null,null,8,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,0,0,0,0,0,0,0,0,0,0,0,null,"左進",{"$f":"ISNUMBER(Q11)","v":false},null,null,9,"","","","","",0,0,null,null,null,"次","00000000000,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q12)","v":false},null,null,10,"","","","","",0,0,null,null,null,"ステージ内容",{"$f":"AF36&AF37&AF38&AF39&AF40&AF41&AF42&AF43&AF44&AF45&AF46","v":"00000000000,00000000000,00000000000,00000000000,00000000000,00000000000,00000000000,00000000000,00000000000,00000000000,00000000000,"}]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",{"$f":"ISNUMBER(Q13)","v":false},null,null,11,"","","","","",0,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S38:S43)","v":1},null,{"$f":"IFERROR(VLOOKUP(U19,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U49<>\"\", V19, \"\")","v":""},"コマンドブロック配置エリア（オプション）",null,"",null,null,null,null,null,"コマンドブロック内容",{"$f":"AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","v":""}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D50)*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,{"$f":"IF(AG50<>\"\",IF(AJ50<>\"\",AG50&AH50&AI50&AJ50&AK50&AL50,AG50&AH50&AL50),\"\")","v":""},{"$f":"U38","v":""},"",{"$f":"IF(AJ50<>\"\", \"-\", \"\")","v":""},{"$f":"W38","v":""},"",{"$f":"IF(AG50<>\"\", \",\", \"\")","v":""}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D51)*1))","v":0},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"エラー有無",{"$f":"SUM(W53:X63)","v":0},null,"コマンドブロックのカウンタ",null,null,null,null,null,{"$f":"IF(AF50<>\"\", IF(AG51<>\"\",IF(AJ51<>\"\",AG51&AH51&AI51&AJ51&AK51&AL51,AG51&AH51&AL51),\"\"),\"\")","v":""},"","","","","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D52)*1))","v":0},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返しに右がある","右にある",null,"エラー有無",{"$f":"SUM(Z53:AA63)","v":0},null,null,null,null,"","","","","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D53)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,{"$f":"IF(AND(OR(U38=5,U38=6),ISNUMBER(W38)),1,0)","v":0},{"$f":"IF(OR(W38=5,W38=6),1,0)","v":0},1,{"$f":"IF(OR(U38=\"\",AND(U38=6,V38=0),AND(U38=4,V38=5),AND(U38=4,V38=6),AND(U38=4,V38=7),AND(OR(U38=1,U38=2,U38=3,U38=5),V38=8),AND(OR(U38=1,U38=2,U38=3,U38=4,U38=5),OR(V38=1,V38=2,V38=3,V38=4))), 0, 1)","v":0},{"$f":"IF(OR(W38=\"\",AND(W38=6,X38=0),AND(W38=4,X38=5),AND(W38=4,X38=6),AND(W38=4,X38=7),AND(OR(W38=1,W38=2,W38=3,W38=5),X38=8),AND(OR(W38=1,W38=2,W38=3,W38=4,W38=5),OR(X38=1,X38=2,X38=3,X38=4))), 0, 1)","v":0},"空白なら0、それ以外なら1",null,null,null,"","","","","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D54)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q15)","v":false},null,null,null,"右進",2,0,0,2,0,0,"6で空白なら0",null,null,null,"","","","","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D55)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q54=TRUE(),Q15=INT(Q15)),0,1)","v":1},"0ならエラー無",null,null,"左進",3,0,0,3,0,0,"4で5,7なら0",null,null,null,"","","","","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D56)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上11以下か",{"$f":"IF(AND(Q54=TRUE(),Q15>=1,Q15<=11),0,1)","v":1},"0ならエラー無",null,null,"回転",4,0,0,4,0,0,"1,2,3,5で8なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D57)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q55,Q56)","v":true},"FALSEならエラー無",null,null,"繰返し始め",5,0,0,5,0,0,"1,2,3,4,5で1,2,3,4なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D58)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し終り",6,0,0,6,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D59)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,7,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｘ",{"$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,0,0,8,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,D61)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,0,0,9,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$17,P62)","v":0},null,null,null,0,0,10,0,0]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$N$18,\"\")*1))","v":121},null,null,null,null,null,null,null,null,null,null,"右上",1,null,0,null,null,null,0,0,11,0,0]
[null,null,null,"合計",{"$f":"SUM(E50:E63)","v":121},null,null,null,null,null,null,null,null,null,null,"右",2,null,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"不整合な文字列の個数",{"$f":"11*11 - E64","v":0},null,null,null,null,null,null,null,null,null,null,"右下",3,null,0,null,null,null,"隙間チェック",{"$f":"SUM(W67:W76)","v":0},null,"コマンドブロック数の範囲内か"]
[null,null,null,null,{"$f":"E52+E55+E58+E61","v":0},"ロボットの数",null,null,null,null,null,null,null,null,null,"下",4,null,0,null,null,1,null,null,null,"エラー数",{"$f":"SUM(AA68:AA72)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左下",5,null,0,null,null,2,{"$f":"IF(AND(U39<>\"\",U38=\"\"),1,0)","v":0},null,null,"利用数","エラー有無"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",6,null,0,null,null,3,0,null,1,{"$f":"COUNTIF($U$38:$U$49,Y68)+COUNTIF($W$38:$W$48,Y68)","v":0},{"$f":"IF(Z68<=Q9,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左上",7,null,0,null,null,4,0,null,2,{"$f":"COUNTIF($U$38:$U$49,Y69)+COUNTIF($W$38:$W$48,Y69)","v":0},{"$f":"IF(Z69<=Q10,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S62:S69)","v":0},null,null,5,0,null,3,{"$f":"COUNTIF($U$38:$U$49,Y70)+COUNTIF($W$38:$W$48,Y70)","v":0},{"$f":"IF(Z70<=Q11,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,null,4,{"$f":"COUNTIF($U$38:$U$49,Y71)+COUNTIF($W$38:$W$48,Y71)","v":0},{"$f":"IF(Z71<=Q12,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,5,{"$f":"COUNTIF($U$38:$U$49,Y72)+COUNTIF($W$38:$W$48,Y72)","v":0},{"$f":"IF(Z72<=Q13,0,1)","v":0}]
[null,null,null,null,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,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,10,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0]

{"sheet":"使い方","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"アルゴロジック1EX かんたん作成支援ツール 使い方"]
[]
[null,null,null,null,null,null,null,null,"アルゴロジック1EX かんたん作成支援ツール"]
[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,"「アルゴロジック1EXエラー」というエラーが表示されるときは、エラーの内容を読んで、「エラーチェック情報」のヒントも見て、問題を修正する"]
[null,"6. 問題を配布するときは、セルAF4の「値をコピー」して使う"]
[]
[null,"7. さらに活用する場合"]
[null,null,"問題に名前をつけたいときは、問題名称に書く"]
[null,null,"問題の解答やその一部もあらかじめ置きたいときは、コマンドブロック配置エリアに書き、"]
[null,null,"「全体のURL」あるいは「全体表示」で、問題の解答やその一部も表示できる"]
[]
[null,"このワークシートを改変したいとき"]
[null,null,"このワークシートは、クリエイティブ・コモンズ・ライセンス　CC BY 4.0　に従います。"]
[null,null,"アルゴロジック1EX かんたん作成支援ツール © 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":76,"n_cols":38,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"アルゴロジック1EX かんたん作成支援ツール",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/1/?algo=10&stage=0707,42243,0,06,0000000,0200020,0011100,0011100,0011100,0203020,0000000,&name=%E5%9B%9B%E8%A7%92"}]
[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/1/?algo=10&stage=0707,42243,0,06,0000000,0200020,0011100,0011100,0011100,0203020,0000000,&name=%E5%9B%9B%E8%A7%92&cb=22,"}]
[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":"AF22&AF23&AF24","v":"https://algo.jeita.or.jp/ex/1/?algo=10&stage=0707,42243,0,06,0000000,0200020,0011100,0011100,0011100,0203020,0000000,&name=%E5%9B%9B%E8%A7%92"}]
[null,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,"全体のURL",{"$f":"AF22&AF23&AF24&AF25","v":"https://algo.jeita.or.jp/ex/1/?algo=10&stage=0707,42243,0,06,0000000,0200020,0011100,0011100,0011100,0203020,0000000,&name=%E5%9B%9B%E8%A7%92&cb=22,"}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,"コマンドブロック","個数","最大数",null,null,"コマンドブロック","カウンタ","コマンドブロック2","カウンタ2",null,"参考"]
[null,null,2,null,"P",null,null,null,"P",null,null,null,null,null,null,"前進",4,4,null,1,"右進",2,null,null,null,"コマンドブロック","カウンタの値",null,null,null,null,null,"アルゴロジック1EX かんたん作成支援ツール"]
[null,null,3,null,null,"X","X","X",null,null,null,null,null,null,null,"右進",2,4,null,2,null,null,null,null,null,"前進","1,2,3,4,8",null,null,null,null,null,"© 2024 JEITA"]
[null,null,4,null,null,"X","X","X",null,null,null,null,null,null,null,"左進",2,4,null,3,null,null,null,null,null,"右進","1,2,3,4,8",null,null,null,"識別子１","?"]
[null,null,5,null,null,"X","X","X",null,null,null,null,null,null,null,"回転",4,4,null,4,null,null,null,null,null,"左進","1,2,3,4,8",null,null,null,"バージョン","algo=10"]
[null,null,6,null,"P",null,"A",null,"P",null,null,null,null,null,null,"繰返し",3,3,null,5,null,null,null,null,null,"回転","0,1,2,3,4,5,6,7",null,null,null,"識別子2","&stage="]
[null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,"繰返し始め","1,2,3,4,8",null,null,null,"ステージサイズ","0707",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"最短手数",6,"11以下",null,7,null,null,null,null,null,"繰返し終り","(なし)",null,null,null,"コマンドブロック数",{"$f":"Q38&Q39&Q40&Q41&Q42","v":"42243"},","]
[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":"AF26","v":0},","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向き","上",null,null,9,null,null,null,null,null,null,null,null,null,null,"最短手順",{"$f":"REPT(\"0\",2-LEN(Q15))&Q15","v":"06"},","]
[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,null,11]
[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,"URL"]
[null,null,null,null,"X","壁（移動できない）",null,null,null,null,null,null,null,null,null,null,"右上","左下",null,null,"前進","回転",null,null,null,null,null,null,null,null,"ベース部","https://algo.jeita.or.jp/ex/1/"]
[null,null,null,null,"A","ロボット",null,null,null,null,null,null,null,null,null,null,"右","左",null,null,"右進","繰返し始め",null,null,null,null,null,null,null,null,"問題部",{"$f":"AF11&AF12&AF13&AF14&AG14&AF15&AG15&AF16&AG16&AF17&AG17&AF47","v":"?algo=10&stage=0707,42243,0,06,0000000,0200020,0011100,0011100,0011100,0203020,0000000,"}]
[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(P3<>\"\",\"&name=\"&_xlfn.ENCODEURL(P3),\"\")","v":"&name=%E5%9B%9B%E8%A7%92"}]
[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=\"&AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","v":"&cb=22,"}]
[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(Q17,$P$62:$Q$69,2, FALSE())","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,null,null,null,null,null,null,null,"コマンドブロック数",{"$f":"IF(S49>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"S49","v":0},"個",null,"コマンドブロックの種類",null,{"$f":"IF(AA37>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA37","v":0},"個"]
[null,null,null,"ロボットの数",null,null,null,{"$f":"IF(E66=1,\"エラー無\",\"エラー有\")","v":"エラー無"},null,null,{"$f":"E66","v":1},"個",null,null,null,null,null,null,null,null,"使えるコマンドブロックの数",null,{"$f":"IF(AA66>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA66","v":0},"個"]
[null,null,null,"扱えない文字数",null,null,null,{"$f":"IF(E65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,{"$f":"E65","v":0},"個",null,null,null,"最短手数エラー有無",{"$f":"IF(Q57=TRUE(),\"エラー有\",\"エラー無\")","v":"エラー無"},null,null,null,"繰り返しの位置",null,{"$f":"IF(X51>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X51","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(AA52>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"AA52","v":0},"個"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ロボットの向きエラー有無",{"$f":"IF(S70=1, \"エラー無\",\"エラー有\")","v":"エラー無"},null,null,null,"隙間あり（左列）",null,{"$f":"IF(X65>0,\"エラー有\",\"エラー無\")","v":"エラー無"},{"$f":"X65","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,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":0},{"$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":0},0,0,0,0,0,null,null,null,null,null,"コマンドブロック数",null,null,null,null,null,null,null,null,null,"コマンドブロックの種類",null,null,null,null,"１段目",{"$f":"D36&E36&F36&G36&H36&I36&J36&AG36","v":"0000000,"},","]
[null,null,null,{"$f":"IF(OR(EXACT(D9,\"A\"),EXACT(D9,\"Ａ\"),EXACT(D9,\"a\"),EXACT(D9,\"ａ\")),3,IF(OR(EXACT(D9,\"P\"),EXACT(D9,\"Ｐ\"),EXACT(D9,\"p\"),EXACT(D9,\"ｐ\")),2, IF(OR(EXACT(D9,\"X\"),EXACT(D9,\"Ｘ\"),EXACT(D9,\"x\"),EXACT(D9,\"ｘ\")),1,0)))","v":0},2,0,0,0,2,0,null,null,null,null,null,"数が範囲内か",null,null,"エラー有無",null,"コマンドブロック配置エリア（オプション）",null,null,null,null,"エラー有無",{"$f":"SUM(Z38:AA48)","v":0},null,null,null,"次",{"$f":"D37&E37&F37&G37&H37&I37&J37&AG37","v":"0200020,"},","]
[null,null,null,0,0,1,1,1,0,0,null,null,null,null,null,"前進",{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, 0)","v":4},{"$f":"IF(AND(Q9>=0,Q9<=R9,Q9=INT(Q9)),Q9, -1)","v":4},{"$f":"IF(R38<0, 1, 0)","v":0},1,{"$f":"IFERROR(VLOOKUP(U9,$U$53:$V$58,2,FALSE()),\"\")","v":2},{"$f":"IF(U38<>\"\", V9, \"\")","v":2},{"$f":"IFERROR(VLOOKUP(W9,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(W38<>\"\", X9, \"\")","v":""},{"$f":"IF(U38<>\"\", \",\", \"\")","v":","},{"$f":"IF(AND(U38=\"\",U9<>\"\"),1,0)","v":0},{"$f":"IF(AND(W38=\"\",W9<>\"\"),1,0)","v":0},null,null,null,"次","0011100,",","]
[null,null,null,0,0,1,1,1,0,0,null,null,null,null,null,"右進",{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, 0)","v":2},{"$f":"IF(AND(Q10>=0,Q10<=R10,Q10=INT(Q10)),Q10, -1)","v":2},{"$f":"IF(R39<0, 1, 0)","v":0},2,"","","","","",0,0,null,null,null,"次","0011100,",","]
[null,null,null,0,0,1,1,1,0,0,null,null,null,null,null,"左進",{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, 0)","v":2},{"$f":"IF(AND(Q11>=0,Q11<=R11,Q11=INT(Q11)),Q11, -1)","v":2},{"$f":"IF(R40<0, 1, 0)","v":0},3,"","","","","",0,0,null,null,null,"次","0011100,",","]
[null,null,null,0,2,0,3,0,2,0,null,null,null,null,null,"回転",{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, 0)","v":4},{"$f":"IF(AND(Q12>=0,Q12<=R12,Q12=INT(Q12)),Q12, -1)","v":4},{"$f":"IF(R41<0, 1, 0)","v":0},4,"","","","","",0,0,null,null,null,"次","0203020,",","]
[null,null,null,0,0,0,0,0,0,0,null,null,null,null,null,"繰返し",{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, 0)","v":3},{"$f":"IF(AND(Q13>=0,Q13<=R13,Q13=INT(Q13)),Q13, -1)","v":3},{"$f":"IF(R42<0, 1, 0)","v":0},5,"","","","","",0,0,null,null,null,"次","0000000,",","]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"個数が数値かどうか",null,{"$f":"AND(Q44:Q48)","v":true},{"$f":"IF(R43,0,1)","v":0},6,"","","","","",0,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,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,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左進",{"$f":"ISNUMBER(Q11)","v":true},null,null,9,"","","","","",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"回転",{"$f":"ISNUMBER(Q12)","v":true},null,null,10,"","","","","",0,0,null,null,null,"ステージ内容",{"$f":"AF36&AF37&AF38&AF39&AF40&AF41&AF42&AF43&AF44","v":"0000000,0200020,0011100,0011100,0011100,0203020,0000000,"}]
[null,null,"配置されたものの個数",null,null,null,null,null,null,null,null,null,null,null,null,"繰返し",{"$f":"ISNUMBER(Q13)","v":true},null,null,11,"","","","","",0,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"総合判断",null,{"$f":"SUM(S38:S43)","v":0},null,{"$f":"IFERROR(VLOOKUP(U19,$U$53:$V$58,2,FALSE()),\"\")","v":""},{"$f":"IF(U49<>\"\", V19, \"\")","v":""},"コマンドブロック配置エリア（オプション）",null,"",null,null,null,null,null,"コマンドブロック内容",{"$f":"AF50&AF51&AF52&AF53&AF54&AF55&AF56&AF57&AF58&AF59&AF60","v":"22,"}]
[null,null,null,"P",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D50)*1))","v":4},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(AG50<>\"\",IF(AJ50<>\"\",AG50&AH50&AI50&AJ50&AK50&AL50,AG50&AH50&AL50),\"\")","v":"22,"},{"$f":"U38","v":2},2,{"$f":"IF(AJ50<>\"\", \"-\", \"\")","v":""},{"$f":"W38","v":""},"",{"$f":"IF(AG50<>\"\", \",\", \"\")","v":","}]
[null,null,null,"X",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D51)*1))","v":9},null,"壁",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"エラー有無",{"$f":"SUM(W53:X63)","v":0},null,"コマンドブロックのカウンタ",null,null,null,null,null,{"$f":"IF(AF50<>\"\", IF(AG51<>\"\",IF(AJ51<>\"\",AG51&AH51&AI51&AJ51&AK51&AL51,AG51&AH51&AL51),\"\"),\"\")","v":""},"","","","","",""]
[null,null,null,"A",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D52)*1))","v":1},null,"ロボット",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返しに右がある","右にある",null,"エラー有無",{"$f":"SUM(Z53:AA63)","v":0},null,null,null,null,"","","","","","",""]
[null,null,"小文字","p",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D53)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"最短手数",null,null,null,null,"前進",1,{"$f":"IF(AND(OR(U38=5,U38=6),ISNUMBER(W38)),1,0)","v":0},{"$f":"IF(OR(W38=5,W38=6),1,0)","v":0},1,{"$f":"IF(OR(U38=\"\",AND(U38=6,V38=0),AND(U38=4,V38=5),AND(U38=4,V38=6),AND(U38=4,V38=7),AND(OR(U38=1,U38=2,U38=3,U38=5),V38=8),AND(OR(U38=1,U38=2,U38=3,U38=4,U38=5),OR(V38=1,V38=2,V38=3,V38=4))), 0, 1)","v":0},{"$f":"IF(OR(W38=\"\",AND(W38=6,X38=0),AND(W38=4,X38=5),AND(W38=4,X38=6),AND(W38=4,X38=7),AND(OR(W38=1,W38=2,W38=3,W38=5),X38=8),AND(OR(W38=1,W38=2,W38=3,W38=4,W38=5),OR(X38=1,X38=2,X38=3,X38=4))), 0, 1)","v":0},"空白なら0、それ以外なら1",null,null,null,"","","","","","",""]
[null,null,null,"x",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D54)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"整数値か",{"$f":"ISNUMBER(Q15)","v":true},null,null,null,"右進",2,0,0,2,0,0,"6で空白なら0",null,null,null,"","","","","","",""]
[null,null,null,"a",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D55)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"数値か",{"$f":"IF(AND(Q54=TRUE(),Q15=INT(Q15)),0,1)","v":0},"0ならエラー無",null,null,"左進",3,0,0,3,0,0,"4で5,7なら0",null,null,null,"","","","","","",""]
[null,null,"全角","Ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D56)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"1以上11以下か",{"$f":"IF(AND(Q54=TRUE(),Q15>=1,Q15<=11),0,1)","v":0},"0ならエラー無",null,null,"回転",4,0,0,4,0,0,"1,2,3,5で8なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ｘ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D57)*1))","v":0},null,null,null,null,null,null,null,null,null,null,"総合判断",{"$f":"OR(Q55,Q56)","v":false},"FALSEならエラー無",null,null,"繰返し始め",5,0,0,5,0,0,"1,2,3,4,5で1,2,3,4なら0",null,null,null,"","","","","","",""]
[null,null,null,"Ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D58)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"繰返し終り",6,0,0,6,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｐ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D59)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,7,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ｘ",{"$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,0,0,8,0,0,null,null,null,null,"","","","","","",""]
[null,null,null,"ａ",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,D61)*1))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"一致すれば1",null,null,null,0,0,9,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"上",0,null,{"$f":"COUNTIF($Q$17,P62)","v":1},null,null,null,0,0,10,0,0]
[null,null,null,"空白",{"$f":"SUMPRODUCT((EXACT($D$8:$J$14,\"\")*1))","v":35},null,null,null,null,null,null,null,null,null,null,"右上",1,null,0,null,null,null,0,0,11,0,0]
[null,null,null,"合計",{"$f":"SUM(E50:E63)","v":49},null,null,null,null,null,null,null,null,null,null,"右",2,null,0,null,null,null,"コマンドブロック配置エリア（オプション）"]
[null,null,null,"不整合な文字列の個数",{"$f":"7*7 - E64","v":0},null,null,null,null,null,null,null,null,null,null,"右下",3,null,0,null,null,null,"隙間チェック",{"$f":"SUM(W67:W76)","v":0},null,"コマンドブロック数の範囲内か"]
[null,null,null,null,{"$f":"E52+E55+E58+E61","v":1},"ロボットの数",null,null,null,null,null,null,null,null,null,"下",4,null,0,null,null,1,null,null,null,"エラー数",{"$f":"SUM(AA68:AA72)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左下",5,null,0,null,null,2,{"$f":"IF(AND(U39<>\"\",U38=\"\"),1,0)","v":0},null,null,"利用数","エラー有無"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",6,null,0,null,null,3,0,null,1,{"$f":"COUNTIF($U$38:$U$49,Y68)+COUNTIF($W$38:$W$48,Y68)","v":0},{"$f":"IF(Z68<=Q9,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左上",7,null,0,null,null,4,0,null,2,{"$f":"COUNTIF($U$38:$U$49,Y69)+COUNTIF($W$38:$W$48,Y69)","v":1},{"$f":"IF(Z69<=Q10,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"合計",{"$f":"SUM(S62:S69)","v":1},null,null,5,0,null,3,{"$f":"COUNTIF($U$38:$U$49,Y70)+COUNTIF($W$38:$W$48,Y70)","v":0},{"$f":"IF(Z70<=Q11,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,null,4,{"$f":"COUNTIF($U$38:$U$49,Y71)+COUNTIF($W$38:$W$48,Y71)","v":0},{"$f":"IF(Z71<=Q12,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,null,5,{"$f":"COUNTIF($U$38:$U$49,Y72)+COUNTIF($W$38:$W$48,Y72)","v":0},{"$f":"IF(Z72<=Q13,0,1)","v":0}]
[null,null,null,null,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,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,10,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0]