{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["増減表","xyz算"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"増減表","index":0,"n_rows":31,"n_cols":20,"rows_kept":31,"cut":false,"hidden":false,"merged":[[18,1,19,5],[20,1,23,1],[24,1,27,1],[20,2,21,2],[22,2,23,2],[24,2,25,2],[26,2,27,2],[20,3,21,5],[22,3,23,5],[24,3,25,5],[26,3,27,5],[6,2,8,5],[3,1,5,5],[6,1,8,1],[9,1,11,1],[9,2,11,5],[15,1,16,1],[15,2,16,4],[15,5,16,5],[12,1,14,1],[12,2,14,4],[12,5,14,5],[20,6,20,7],[24,6,24,7],[30,1,31,1],[30,2,31,4],[30,5,31,5],[28,1,29,1],[28,2,29,4],[28,5,29,5],[28,6,29,7],[30,6,31,7],[27,6,27,7],[25,6,26,7],[21,6,22,7],[20,8,20,10],[21,8,22,8],[21,9,22,9],[21,10,22,10],[24,8,24,10],[25,8,26,8],[25,9,26,9],[25,10,26,10],[22,11,22,13],[23,11,24,13],[25,11,26,13],[3,11,5,15],[6,11,7,11],[8,11,9,11],[10,11,11,11],[12,11,13,11],[6,13,6,15],[7,13,7,15],[8,13,8,15],[9,13,9,15],[10,12,11,14],[10,15,11,15],[12,12,13,14],[12,15,13,15],[6,16,7,17],[8,16,9,17],[5,16,5,17],[6,18,7,19],[5,18,5,19],[8,18,9,19]]}
[]
[]
[]
[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,null,null,null,"古い年","金額",null,null,null,{"$f":"IFERROR(N7/N8,\"\")","v":""},null,{"$f":"IFERROR(N8/N7,\"\")","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,{"$f":"IFERROR(N9/N10,\"\")","v":""},null,{"$f":"IFERROR(N10/N9,\"\")","v":""}]
[null,"対象年",null,null,null,null,null,null,null,null,null,null,"人数"]
[null,null,null,null,null,null,null,null,null,null,null,"結果",{"$f":"IFERROR(ABS(((N9/N10)-(N7/N8))/(N7/N8)),\"\")","v":""},null,null,{"$f":"IFERROR(IF((N9/N10)>(N7/N8),\"増加\",IF((N9/N10)=(N7/N8),\"\",\"減少\")),\"\")","v":""},{"$f":"IFERROR(ABS(Q9-Q7),\"\")","v":""},{"$f":"IFERROR(IF(Q9>Q7,\"増加\",IF(Q9=Q7,\"\",\"減少\")),\"\")","v":""},{"$f":"IFERROR(ABS(S9-S7),\"\")","v":""},{"$f":"IFERROR(IF(S9>S7,\"増加\",IF(S9=S7,\"\",\"減少\")),\"\")","v":""}]
[]
[null,"結果",{"$f":"IFERROR(ABS((C10-C7)/C7),\"\")","v":""},null,null,{"$f":"IF(C10>C7,\"増加\",IF(C10=C7,\"\",\"減少\"))","v":""},null,null,null,null,null,"逆",{"$f":"IFERROR(ABS(((N7/N8)-(N9/N10))/(N9/N10)),\"\")","v":""},null,null,{"$f":"IFERROR(IF((N7/N8)>(N9/N10),\"増加\",IF((N9/N10)=(N7/N8),\"\",\"減少\")),\"\")","v":""}]
[]
[]
[null,"逆",{"$f":"IFERROR(ABS((C7-C10)/C10),\"\")","v":""},null,null,{"$f":"IF(C7>C10,\"増加\",IF(C10=C7,\"\",\"減少\"))","v":""}]
[]
[]
[null,"割合型出荷台数問題"]
[]
[null,"古い年","台数",null,null,null,"計算結果",null,"古い年全体との比率"]
[null,null,null,null,null,null,{"$f":"D21*D23","v":0},null,100,":",{"$f":"IFERROR(D21/G22*100,\"\")","v":""}]
[null,null,"割合"]
[]
[null,"対象年","台数",null,null,null,"計算結果",null,"対象年との比較"]
[null,null,null,null,null,null,{"$f":"D25*D27","v":0},null,100,":",{"$f":"IFERROR(D25/G26*100,\"\")","v":""}]
[null,null,"割合"]
[null,null,null,null,null,null,"倍率"]
[null,"結果",{"$f":"IFERROR(ABS(((D25*D27)-(D21*D23))/(D21*D23)),\"\")","v":""},null,null,{"$f":"IF(D25*D27>D21*D23,\"増加\",IF(D25*D27=D21*D23,\"\",\"減少\"))","v":""},{"$f":"IFERROR((D25*D27)/(D21*D23),\"\")","v":""}]
[]
[null,"逆",{"$f":"IFERROR(ABS(((D25*D27)-(D21*D23))/(D25*D27)),\"\")","v":""},null,null,{"$f":"IF(D21*D23>D25*D27,\"増加\",IF(D25*D27=D21*D23,\"\",\"減少\"))","v":""},{"$f":"IFERROR((D21*D23)/(D25*D27),\"\")","v":""}]

{"sheet":"xyz算","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,7,5,13]]}
[]
[]
[null,"a","b","c","計","デバッグ",null,"りんご3個みかん4個パイナップル2つ買うと120円\nりんご2個みかん3個パイナップル4つ買うと180円\nさてりんご1個の値段は？的な問題は?"]
["ケース1",null,null,null,136,{"$f":"B4*$B$12+C4*$C$12+D4*$D$12","v":0}]
["ケース2",null,null,null,112,{"$f":"B5*$B$12+C5*$C$12+D5*$D$12","v":0}]
["ケース3",null,null,null,216,{"$f":"B6*$B$12+C6*$C$12+D6*$D$12","v":0}]
["bcのみ",null,{"$f":"B5*C4-C5*B4","v":0},{"$f":"B5*D4-D5*B4","v":0},{"$f":"B5*E4-E5*B4","v":0},{"$f":"B5*F4-F5*B4","v":0}]
["bcのみ2",null,{"$f":"B6*C5-C6*B5","v":0},{"$f":"B6*D5-D6*B5","v":0},{"$f":"B6*E5-E6*B5","v":0},{"$f":"B6*F5-F6*B5","v":0}]
["c",null,null,{"$f":"C8/C7*D7-D8","v":{"$error":"#DIV/0!"}},{"$f":"C8/C7*E7-E8","v":{"$error":"#DIV/0!"}},{"$f":"C8/C7*F7-F8","v":{"$error":"#DIV/0!"}}]
[null,"a","b","c"]
["答え",{"$f":"(E4-(D11*D4+C11*C4))/B4","v":{"$error":"#DIV/0!"}},{"$f":"(E7-(D11*D7))/C7","v":{"$error":"#DIV/0!"}},{"$f":"E9/D9","v":{"$error":"#DIV/0!"}}]
["デバッグ",40,2,4]