{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["進数変換","２進数計算","浮動小数点数"],"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":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,13,14,17],[14,7,14,11],[14,1,14,5],[15,1,15,5],[15,7,15,11],[15,13,15,17],[10,16,10,17],[11,16,11,17],[5,7,5,8],[5,10,5,11],[10,10,10,11],[10,7,10,8],[10,13,10,14],[5,16,5,17],[5,9,6,9],[10,9,11,9],[5,15,6,15],[10,15,11,15],[11,4,11,5],[5,13,5,14],[6,13,6,14],[5,1,5,2],[10,1,10,2],[5,4,5,5],[10,4,10,5],[6,1,6,2],[5,3,6,3],[10,3,11,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F9で更新"]
[null,"２進数、１０進数、１６進数の変換"]
[]
[null,"①１０進数から２進数",null,null,null,null,null,"③２進数から１６進数",null,null,null,null,null,"⑤１０進数から１６進数"]
[]
[null,"10進数",null,"⇒","２進数",null,null,"２進数",null,"⇒","１６進数",null,null,"10進数",null,"⇒","１６進数"]
[null,{"$f":"RANDBETWEEN(1,255)","v":222},null,null,{"$f":"DEC2BIN(B7,8)","v":"11011110"},"(2)",null,{"$f":"DEC2BIN(RANDBETWEEN(1,255),8)","v":"01011001"},"(2)",null,{"$f":"BIN2HEX(H7)","v":"59"},"(16)",null,{"$f":"RANDBETWEEN(1,255)","v":168},null,null,{"$f":"DEC2HEX(N7)","v":"A8"},"(16)"]
[]
[null,"②２進数から１０進数",null,null,null,null,null,"④１６進数から２進数",null,null,null,null,null,"⑥１６進数から１０進数"]
[]
[null,"２進数",null,"⇒","10進数",null,null,"１６進数",null,"⇒","２進数",null,null,"１６進数",null,"⇒","10進数"]
[null,{"$f":"DEC2BIN(E12,8)","v":"10000000"},"(2)",null,{"$f":"RANDBETWEEN(1,255)","v":128},null,null,{"$f":"BIN2HEX(K12)","v":"21"},"(16)",null,{"$f":"DEC2BIN(RANDBETWEEN(1,255),8)","v":"00100001"},"(2)",null,{"$f":"DEC2HEX(Q12)","v":"E3"},"(16)",null,{"$f":"RANDBETWEEN(1,255)","v":227}]
[]
[null,"【ヒント】"]
[null,"①２で割って、あまりを下から拾う",null,null,null,null,null,"③下から４桁ずつ区切って、②の計算をする",null,null,null,null,null,"⑤16で割って、余りを下から拾う"]
[null,"②上に位を書いて、１のところを足す",null,null,null,null,null,"④16進数１桁を４桁にする\n（8,4,2,1）を上に書いてどこに１が入るか考える",null,null,null,null,null,"⑥上に位を書いて、その位の個数を掛けて、すべての値を足す"]

{"sheet":"２進数計算","index":1,"n_rows":21,"n_cols":28,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"F9で更新"]
[null,"２進数の計算"]
[null,null,{"$f":"RANDBETWEEN(1,15)","v":7},null,{"$f":"RANDBETWEEN(1,15)","v":10},null,{"$f":"C3+E3","v":17},null,null,{"$f":"RANDBETWEEN(1,15)","v":6},null,{"$f":"RANDBETWEEN(1,15)","v":8},null,{"$f":"J3+L3","v":14},null,null,{"$f":"IF(SUM(R3:R5)>=2,1,\"\")","v":1},1,1,{"$f":"IF(SUM(U3:U5)>=2,1,\"\")","v":""},null,null,null,{"$f":"IF(SUM(Y3:Y5)>=2,1,\"\")","v":""},"","",{"$f":"IF(SUM(AB3:AB5)>=2,1,\"\")","v":""}]
[null,"①",{"$f":"DEC2BIN(C3,4)","v":"0111"},"＋",{"$f":"DEC2BIN(E3,4)","v":"1010"},"＝",{"$f":"IF(G3>=16,DEC2BIN(G3,5),DEC2BIN(G3,4))","v":"10001"},null,"②",{"$f":"DEC2BIN(J3,4)","v":"0110"},"＋",{"$f":"DEC2BIN(L3,4)","v":"1000"},"＝",{"$f":"IF(N3>=16,DEC2BIN(N3,5),DEC2BIN(N3,4))","v":"1110"},null,"①",null,{"$f":"VALUE(MID($C$4,1,1))","v":0},{"$f":"VALUE(MID($C$4,2,1))","v":1},{"$f":"VALUE(MID($C$4,3,1))","v":1},{"$f":"VALUE(MID($C$4,4,1))","v":1},null,"②",null,{"$f":"VALUE(MID($J$4,1,1))","v":0},{"$f":"VALUE(MID($J$4,2,1))","v":1},{"$f":"VALUE(MID($J$4,3,1))","v":1},{"$f":"VALUE(MID($J$4,4,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＋",{"$f":"VALUE(MID($E$4,1,1))","v":1},{"$f":"VALUE(MID($E$4,2,1))","v":0},{"$f":"VALUE(MID($E$4,3,1))","v":1},{"$f":"VALUE(MID($E$4,4,1))","v":0},null,null,"＋",{"$f":"VALUE(MID($L$4,1,1))","v":1},{"$f":"VALUE(MID($L$4,2,1))","v":0},{"$f":"VALUE(MID($L$4,3,1))","v":0},{"$f":"VALUE(MID($L$4,4,1))","v":0}]
[null,null,{"$f":"RANDBETWEEN(8,15)","v":14},null,{"$f":"RANDBETWEEN(1,7)","v":4},null,{"$f":"C6-E6","v":10},null,null,{"$f":"RANDBETWEEN(8,15)","v":10},null,{"$f":"RANDBETWEEN(1,7)","v":2},null,{"$f":"J6-L6","v":8},null,null,{"$f":"IF(Q3=1,1,\"\")","v":1},{"$f":"_xlfn.IFS(SUM(R3:R5)=0,0,SUM(R3:R5)=1,1,SUM(R3:R5)=2,0,SUM(R3:R5)=3,1)","v":0},0,0,{"$f":"_xlfn.IFS(SUM(U3:U5)=0,0,SUM(U3:U5)=1,1,SUM(U3:U5)=2,0,SUM(U3:U5)=3,1)","v":1},null,null,{"$f":"IF(X3=1,1,\"\")","v":""},{"$f":"_xlfn.IFS(SUM(Y3:Y5)=0,0,SUM(Y3:Y5)=1,1,SUM(Y3:Y5)=2,0,SUM(Y3:Y5)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(Z3:Z5)=0,0,SUM(Z3:Z5)=1,1,SUM(Z3:Z5)=2,0,SUM(Z3:Z5)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(AA3:AA5)=0,0,SUM(AA3:AA5)=1,1,SUM(AA3:AA5)=2,0,SUM(AA3:AA5)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(AB3:AB5)=0,0,SUM(AB3:AB5)=1,1,SUM(AB3:AB5)=2,0,SUM(AB3:AB5)=3,1)","v":0}]
[null,"③",{"$f":"DEC2BIN(C6,4)","v":"1110"},"-",{"$f":"DEC2BIN(E6,4)","v":"0100"},"＝",{"$f":"IF(G6>=16,DEC2BIN(G6,5),DEC2BIN(G6,4))","v":"1010"},null,"④",{"$f":"DEC2BIN(J6,4)","v":"1010"},"-",{"$f":"DEC2BIN(L6,4)","v":"0010"},"＝",{"$f":"IF(N6>=16,DEC2BIN(N6,5),DEC2BIN(N6,4))","v":"1000"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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":"VALUE(MID($E$7,1,1))","v":0},{"$f":"VALUE(MID($E$7,2,1))","v":1},{"$f":"VALUE(MID($E$7,3,1))","v":0},{"$f":"VALUE(MID($E$7,4,1))","v":0},null,null,null,{"$f":"VALUE(MID($L$7,1,1))","v":0},{"$f":"VALUE(MID($L$7,2,1))","v":0},{"$f":"VALUE(MID($L$7,3,1))","v":1},{"$f":"VALUE(MID($L$7,4,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"反転",null,{"$f":"IF(R9=0,1,0)","v":1},{"$f":"IF(S9=0,1,0)","v":0},1,1,null,"反転",null,{"$f":"IF(Y9=0,1,0)","v":1},{"$f":"IF(Z9=0,1,0)","v":1},{"$f":"IF(AA9=0,1,0)","v":0},{"$f":"IF(AB9=0,1,0)","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R12:R14)>=2,1,\"\")","v":""},"",1,{"$f":"IF(SUM(U12:U14)>=2,1,\"\")","v":1},null,null,null,{"$f":"IF(SUM(Y12:Y14)>=2,1,\"\")","v":""},"","",{"$f":"IF(SUM(AB12:AB14)>=2,1,\"\")","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R10","v":1},0,1,{"$f":"U10","v":1},null,null,null,{"$f":"Y10","v":1},1,0,{"$f":"AB10","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＋1","＋",null,null,null,1,null,"＋1","＋",null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q12=1,1,\"\")","v":""},{"$f":"_xlfn.IFS(SUM(R12:R14)=0,0,SUM(R12:R14)=1,1,SUM(R12:R14)=2,0,SUM(R12:R14)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(S12:S14)=0,0,SUM(S12:S14)=1,1,SUM(S12:S14)=2,0,SUM(S12:S14)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(T12:T14)=0,0,SUM(T12:T14)=1,1,SUM(T12:T14)=2,0,SUM(T12:T14)=3,1)","v":0},{"$f":"_xlfn.IFS(SUM(U12:U14)=0,0,SUM(U12:U14)=1,1,SUM(U12:U14)=2,0,SUM(U12:U14)=3,1)","v":0},null,null,{"$f":"IF(X12=1,1,\"\")","v":""},{"$f":"_xlfn.IFS(SUM(Y12:Y14)=0,0,SUM(Y12:Y14)=1,1,SUM(Y12:Y14)=2,0,SUM(Y12:Y14)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(Z12:Z14)=0,0,SUM(Z12:Z14)=1,1,SUM(Z12:Z14)=2,0,SUM(Z12:Z14)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(AA12:AA14)=0,0,SUM(AA12:AA14)=1,1,SUM(AA12:AA14)=2,0,SUM(AA12:AA14)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(AB12:AB14)=0,0,SUM(AB12:AB14)=1,1,SUM(AB12:AB14)=2,0,SUM(AB12:AB14)=3,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(R18:R20)>=2,1,\"\")","v":1},1,"",{"$f":"IF(SUM(U18:U20)>=2,1,\"\")","v":""},null,null,null,{"$f":"IF(SUM(Y18:Y20)>=2,1,\"\")","v":1},1,1,{"$f":"IF(SUM(AB18:AB20)>=2,1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VALUE(MID($C$7,1,1))","v":1},{"$f":"VALUE(MID($C$7,2,1))","v":1},{"$f":"VALUE(MID($C$7,3,1))","v":1},{"$f":"VALUE(MID($C$7,4,1))","v":0},null,null,null,{"$f":"VALUE(MID($J$7,1,1))","v":1},{"$f":"VALUE(MID($J$7,2,1))","v":0},{"$f":"VALUE(MID($J$7,3,1))","v":1},{"$f":"VALUE(MID($J$7,4,1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"＋",{"$f":"R15","v":1},1,0,{"$f":"U15","v":0},null,null,"＋",{"$f":"Y15","v":1},1,1,{"$f":"AB15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q18=1,1,\"\")","v":1},{"$f":"_xlfn.IFS(SUM(R18:R20)=0,0,SUM(R18:R20)=1,1,SUM(R18:R20)=2,0,SUM(R18:R20)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(S18:S20)=0,0,SUM(S18:S20)=1,1,SUM(S18:S20)=2,0,SUM(S18:S20)=3,1)","v":0},{"$f":"_xlfn.IFS(SUM(T18:T20)=0,0,SUM(T18:T20)=1,1,SUM(T18:T20)=2,0,SUM(T18:T20)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(U18:U20)=0,0,SUM(U18:U20)=1,1,SUM(U18:U20)=2,0,SUM(U18:U20)=3,1)","v":0},null,null,{"$f":"IF(X18=1,1,\"\")","v":1},{"$f":"_xlfn.IFS(SUM(Y18:Y20)=0,0,SUM(Y18:Y20)=1,1,SUM(Y18:Y20)=2,0,SUM(Y18:Y20)=3,1)","v":1},{"$f":"_xlfn.IFS(SUM(Z18:Z20)=0,0,SUM(Z18:Z20)=1,1,SUM(Z18:Z20)=2,0,SUM(Z18:Z20)=3,1)","v":0},{"$f":"_xlfn.IFS(SUM(AA18:AA20)=0,0,SUM(AA18:AA20)=1,1,SUM(AA18:AA20)=2,0,SUM(AA18:AA20)=3,1)","v":0},{"$f":"_xlfn.IFS(SUM(AB18:AB20)=0,0,SUM(AB18:AB20)=1,1,SUM(AB18:AB20)=2,0,SUM(AB18:AB20)=3,1)","v":0}]

{"sheet":"浮動小数点数","index":2,"n_rows":11,"n_cols":28,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,13,5,17],[5,18,5,27],[8,1,8,2],[10,13,10,17],[5,1,5,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F9で更新"]
[null,"浮動小数点数変換（16ビット）"]
[]
[null,"①１０進数から浮動小数点数"]
[]
[null,"10進数",null,null,null,4,2,1,0.5,0.25,0.125,null,"符号部","指数部",null,null,null,null,"仮数部"]
[null,{"$f":"E7","v":"-"},{"$f":"F6*F7+G6*G7+H6*H7+I6*I7+J6*J7+K6*K7","v":7.5},null,{"$f":"IF(RANDBETWEEN(0,1)=0,\"\",\"-\")","v":"-"},{"$f":"RANDBETWEEN(0,1)","v":1},{"$f":"RANDBETWEEN(0,1)","v":1},1,1,0,0,null,{"$f":"IF(E7=\"-\",1,0)","v":1},{"$f":"VALUE(MID($N$11,1,1))","v":1},{"$f":"VALUE(MID($N$11,2,1))","v":0},{"$f":"VALUE(MID($N$11,3,1))","v":0},{"$f":"VALUE(MID($N$11,4,1))","v":0},{"$f":"VALUE(MID($N$11,5,1))","v":1},{"$f":"IF(F7=1,G7,IF(G7=1,H7,IF(H7=1,I7,IF(I7=1,J7,IF(J7=1,K7,IF(K7=1,0,0))))))","v":1},{"$f":"IF(F7=1,H7,IF(G7=1,I7,IF(H7=1,J7,IF(I7=1,K7,IF(J7=1,0,IF(K7=1,0,0))))))","v":1},{"$f":"IF(F7=1,I7,IF(G7=1,J7,IF(H7=1,K7,IF(I7=1,0,IF(J7=1,0,IF(K7=1,0,0))))))","v":1},{"$f":"IF(F7=1,J7,IF(G7=1,K7,IF(H7=1,0,IF(I7=1,0,IF(J7=1,0,IF(K7=1,0,0))))))","v":0},{"$f":"IF(F7=1,K7,IF(G7=1,0,IF(H7=1,0,IF(I7=1,0,IF(J7=1,0,IF(K7=1,0,0))))))","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F7=1,2,IF(G7=1,1,IF(H7=1,0,IF(I7=1,-1,IF(J7=1,-2,IF(K7=1,-3,0))))))","v":2},"+",15,"=",{"$f":"N9+P9","v":17}]
[null,null,null,null,null,null,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":"DEC2BIN(R9,5)","v":"10001"}]