数独 初級 攻略 プログラム 番外 2
ことばに出すことと 現実に形にするということの大きな違いを実感する今日このごろです。
テーマとして少し的外れかもしれない話題ですが 番外としてひとつ。
以前
数独 初級 攻略 プログラム のエピソードで お伝えしたことの続編です。
「Excel では IF文が錯綜し 頭が混乱しました」と言っていましたが
今回 それをシンプルにすることができました。
「なんだそんなことか」と思われるようなことも言葉や文章で表すのは苦手です。
形にできたものとして お伝えします。
表現のロジックとしては シンプルです。
数字を決定する場所は 横３マス縦３マスの９マスの枠組みを横３個 縦３個
一つのマスの数字はそのマスを含む 縦列９個 横列９個 枠内の９個内の
他と異なる数だということです。詳しくは アマタある関連書等々を参照してください。
エクセルの A１に全範囲をペイストしてください。
画像を整える必要がありますが 下画像を参考にしてください。
A１から I９の範囲のマスが入力するところです。説明は不要でしょう。
="" =4 ="" =1 ="" =9 ="" =5 ="" ="" =IF(A1="",0,A1) =IF(B1="",0,B1) =IF(C1="",0,C1) =IF(D1="",0,D1) =IF(E1="",0,E1) =IF(F1="",0,F1) =IF(G1="",0,G1) =IF(H1="",0,H1) =IF(I1="",0,I1) =INT((10^K1+10^L1+10^M1+10^N1+10^O1+10^P1+10^Q1+10^R1+10^S1)/10) ="" =INT((10^K1+10^L1+10^M1+10^K2+10^L2+10^M2+10^K3+10^L3+10^M3)/10) =INT((10^N1+10^O1+10^P1+10^N2+10^O2+10^P2+10^N3+10^O3+10^P3)/10) =INT((10^Q1+10^R1+10^S1+10^Q2+10^R2+10^S2+10^Q3+10^R3+10^S3)/10) =2 ="" ="" =5 ="" =3 =8 ="" =4 ="" =IF(A2="",0,A2) =IF(B2="",0,B2) =IF(C2="",0,C2) =IF(D2="",0,D2) =IF(E2="",0,E2) =IF(F2="",0,F2) =IF(G2="",0,G2) =IF(H2="",0,H2) =IF(I2="",0,I2) =INT((10^K2+10^L2+10^M2+10^N2+10^O2+10^P2+10^Q2+10^R2+10^S2)/10) ="" ="" ="" ="" ="" =3 ="" =6 =2 =4 ="" =9 ="" ="" =IF(A3="",0,A3) =IF(B3="",0,B3) =IF(C3="",0,C3) =IF(D3="",0,D3) =IF(E3="",0,E3) =IF(F3="",0,F3) =IF(G3="",0,G3) =IF(H3="",0,H3) =IF(I3="",0,I3) =INT((10^K3+10^L3+10^M3+10^N3+10^O3+10^P3+10^Q3+10^R3+10^S3)/10) ="" ="" ="" ="" =4 ="" =6 =9 =3 =7 =5 ="" =1 ="" =IF(A4="",0,A4) =IF(B4="",0,B4) =IF(C4="",0,C4) =IF(D4="",0,D4) =IF(E4="",0,E4) =IF(F4="",0,F4) =IF(G4="",0,G4) =IF(H4="",0,H4) =IF(I4="",0,I4) =INT((10^K4+10^L4+10^M4+10^N4+10^O4+10^P4+10^Q4+10^R4+10^S4)/10) ="" =INT((10^K4+10^L4+10^M4+10^K5+10^L5+10^M5+10^K6+10^L6+10^M6)/10) =INT((10^N4+10^O4+10^P4+10^N5+10^O5+10^P5+10^N6+10^O6+10^P6)/10) =INT((10^Q4+10^R4+10^S4+10^Q5+10^R5+10^S5+10^Q6+10^R6+10^S6)/10) =5 =7 ="" ="" =6 ="" ="" =8 =3 ="" =IF(A5="",0,A5) =IF(B5="",0,B5) =IF(C5="",0,C5) =IF(D5="",0,D5) =IF(E5="",0,E5) =IF(F5="",0,F5) =IF(G5="",0,G5) =IF(H5="",0,H5) =IF(I5="",0,I5) =INT((10^K5+10^L5+10^M5+10^N5+10^O5+10^P5+10^Q5+10^R5+10^S5)/10) ="" ="" ="" ="" ="" =1 =9 ="" ="" ="" =7 =4 ="" ="" =IF(A6="",0,A6) =IF(B6="",0,B6) =IF(C6="",0,C6) =IF(D6="",0,D6) =IF(E6="",0,E6) =IF(F6="",0,F6) =IF(G6="",0,G6) =IF(H6="",0,H6) =IF(I6="",0,I6) =INT((10^K6+10^L6+10^M6+10^N6+10^O6+10^P6+10^Q6+10^R6+10^S6)/10) ="" ="" ="" ="" =9 =2 ="" =7 ="" =8 ="" =3 =5 ="" =IF(A7="",0,A7) =IF(B7="",0,B7) =IF(C7="",0,C7) =IF(D7="",0,D7) =IF(E7="",0,E7) =IF(F7="",0,F7) =IF(G7="",0,G7) =IF(H7="",0,H7) =IF(I7="",0,I7) =INT((10^K7+10^L7+10^M7+10^N7+10^O7+10^P7+10^Q7+10^R7+10^S7)/10) ="" =INT((10^K7+10^L7+10^M7+10^K8+10^L8+10^M8+10^K9+10^L9+10^M9)/10) =INT((10^N7+10^O7+10^P7+10^N8+10^O8+10^P8+10^N9+10^O9+10^P9)/10) =INT((10^Q7+10^R7+10^S7+10^Q8+10^R8+10^S8+10^Q9+10^R9+10^S9)/10) =1 ="" =3 =2 ="" =5 =4 ="" =8 ="" =IF(A8="",0,A8) =IF(B8="",0,B8) =IF(C8="",0,C8) =IF(D8="",0,D8) =IF(E8="",0,E8) =IF(F8="",0,F8) =IF(G8="",0,G8) =IF(H8="",0,H8) =IF(I8="",0,I8) =INT((10^K8+10^L8+10^M8+10^N8+10^O8+10^P8+10^Q8+10^R8+10^S8)/10) ="" ="" ="" ="" =7 ="" =8 =3 ="" =6 =2 ="" =9 ="" =IF(A9="",0,A9) =IF(B9="",0,B9) =IF(C9="",0,C9) =IF(D9="",0,D9) =IF(E9="",0,E9) =IF(F9="",0,F9) =IF(G9="",0,G9) =IF(H9="",0,H9) =IF(I9="",0,I9) =INT((10^K9+10^L9+10^M9+10^N9+10^O9+10^P9+10^Q9+10^R9+10^S9)/10) ="" ="" =987654321 ="" ="" ="" ="" ="" ="" ="" ="" ="" ="" ="" =INT((10^K1+10^K2+10^K3+10^K4+10^K5+10^K6+10^K7+10^K8+10^K9)/10) =INT((10^L1+10^L2+10^L3+10^L4+10^L5+10^L6+10^L7+10^L8+10^L9)/10) =INT((10^M1+10^M2+10^M3+10^M4+10^M5+10^M6+10^M7+10^M8+10^M9)/10) =INT((10^N1+10^N2+10^N3+10^N4+10^N5+10^N6+10^N7+10^N8+10^N9)/10) =INT((10^O1+10^O2+10^O3+10^O4+10^O5+10^O6+10^O7+10^O8+10^O9)/10) =INT((10^P1+10^P2+10^P3+10^P4+10^P5+10^P6+10^P7+10^P8+10^P9)/10) =INT((10^Q1+10^Q2+10^Q3+10^Q4+10^Q5+10^Q6+10^Q7+10^Q8+10^Q9)/10) =INT((10^R1+10^R2+10^R3+10^R4+10^R5+10^R6+10^R7+10^R8+10^R9)/10) =INT((10^S1+10^S2+10^S3+10^S4+10^S5+10^S6+10^S7+10^S8+10^S9)/10) ="" ="" ="" =V1+W1+X1+V4+W4+X4+V7+W7+X7 ="" =IF(A1="",(IF(MID(K11,1,1)="0",9,"")&IF(MID(K11,2,1)="0",8,"")&IF(MID(K11,3,1)="0",7,"")&IF(MID(K11,4,1)="0",6,"")&IF(MID(K11,5,1)="0",5,"")&IF(MID(K11,6,1)="0",4,"")&IF(MID(K11,7,1)="0",3,"")&IF(MID(K11,8,1)="0",2,"")&IF(MID(K11,9,1)="0",1,"")),("("&A1&")")) =IF(B1="",(IF(MID(L11,1,1)="0",9,"")&IF(MID(L11,2,1)="0",8,"")&IF(MID(L11,3,1)="0",7,"")&IF(MID(L11,4,1)="0",6,"")&IF(MID(L11,5,1)="0",5,"")&IF(MID(L11,6,1)="0",4,"")&IF(MID(L11,7,1)="0",3,"")&IF(MID(L11,8,1)="0",2,"")&IF(MID(L11,9,1)="0",1,"")),("("&B1&")")) =IF(C1="",(IF(MID(M11,1,1)="0",9,"")&IF(MID(M11,2,1)="0",8,"")&IF(MID(M11,3,1)="0",7,"")&IF(MID(M11,4,1)="0",6,"")&IF(MID(M11,5,1)="0",5,"")&IF(MID(M11,6,1)="0",4,"")&IF(MID(M11,7,1)="0",3,"")&IF(MID(M11,8,1)="0",2,"")&IF(MID(M11,9,1)="0",1,"")),("("&C1&")")) =IF(D1="",(IF(MID(N11,1,1)="0",9,"")&IF(MID(N11,2,1)="0",8,"")&IF(MID(N11,3,1)="0",7,"")&IF(MID(N11,4,1)="0",6,"")&IF(MID(N11,5,1)="0",5,"")&IF(MID(N11,6,1)="0",4,"")&IF(MID(N11,7,1)="0",3,"")&IF(MID(N11,8,1)="0",2,"")&IF(MID(N11,9,1)="0",1,"")),("("&D1&")")) =IF(E1="",(IF(MID(O11,1,1)="0",9,"")&IF(MID(O11,2,1)="0",8,"")&IF(MID(O11,3,1)="0",7,"")&IF(MID(O11,4,1)="0",6,"")&IF(MID(O11,5,1)="0",5,"")&IF(MID(O11,6,1)="0",4,"")&IF(MID(O11,7,1)="0",3,"")&IF(MID(O11,8,1)="0",2,"")&IF(MID(O11,9,1)="0",1,"")),("("&E1&")")) =IF(F1="",(IF(MID(P11,1,1)="0",9,"")&IF(MID(P11,2,1)="0",8,"")&IF(MID(P11,3,1)="0",7,"")&IF(MID(P11,4,1)="0",6,"")&IF(MID(P11,5,1)="0",5,"")&IF(MID(P11,6,1)="0",4,"")&IF(MID(P11,7,1)="0",3,"")&IF(MID(P11,8,1)="0",2,"")&IF(MID(P11,9,1)="0",1,"")),("("&F1&")")) =IF(G1="",(IF(MID(Q11,1,1)="0",9,"")&IF(MID(Q11,2,1)="0",8,"")&IF(MID(Q11,3,1)="0",7,"")&IF(MID(Q11,4,1)="0",6,"")&IF(MID(Q11,5,1)="0",5,"")&IF(MID(Q11,6,1)="0",4,"")&IF(MID(Q11,7,1)="0",3,"")&IF(MID(Q11,8,1)="0",2,"")&IF(MID(Q11,9,1)="0",1,"")),("("&G1&")")) =IF(H1="",(IF(MID(R11,1,1)="0",9,"")&IF(MID(R11,2,1)="0",8,"")&IF(MID(R11,3,1)="0",7,"")&IF(MID(R11,4,1)="0",6,"")&IF(MID(R11,5,1)="0",5,"")&IF(MID(R11,6,1)="0",4,"")&IF(MID(R11,7,1)="0",3,"")&IF(MID(R11,8,1)="0",2,"")&IF(MID(R11,9,1)="0",1,"")),("("&H1&")")) =IF(I1="",(IF(MID(S11,1,1)="0",9,"")&IF(MID(S11,2,1)="0",8,"")&IF(MID(S11,3,1)="0",7,"")&IF(MID(S11,4,1)="0",6,"")&IF(MID(S11,5,1)="0",5,"")&IF(MID(S11,6,1)="0",4,"")&IF(MID(S11,7,1)="0",3,"")&IF(MID(S11,8,1)="0",2,"")&IF(MID(S11,9,1)="0",1,"")),("("&I1&")")) ="" =MID(K$10+$T1+$V$1+10^9,2,9) =MID(L$10+$T1+$V$1+10^9,2,9) =MID(M$10+$T1+$V$1+10^9,2,9) =MID(N$10+$T1+$W$1+10^9,2,9) =MID(O$10+$T1+$W$1+10^9,2,9) =MID(P$10+$T1+$W$1+10^9,2,9) =MID(Q$10+$T1+$X$1+10^9,2,9) =MID(R$10+$T1+$X$1+10^9,2,9) =MID(S$10+$T1+$X$1+10^9,2,9) ="" ="" ="" ="" ="" =IF(A2="",(IF(MID(K12,1,1)="0",9,"")&IF(MID(K12,2,1)="0",8,"")&IF(MID(K12,3,1)="0",7,"")&IF(MID(K12,4,1)="0",6,"")&IF(MID(K12,5,1)="0",5,"")&IF(MID(K12,6,1)="0",4,"")&IF(MID(K12,7,1)="0",3,"")&IF(MID(K12,8,1)="0",2,"")&IF(MID(K12,9,1)="0",1,"")),("("&A2&")")) =IF(B2="",(IF(MID(L12,1,1)="0",9,"")&IF(MID(L12,2,1)="0",8,"")&IF(MID(L12,3,1)="0",7,"")&IF(MID(L12,4,1)="0",6,"")&IF(MID(L12,5,1)="0",5,"")&IF(MID(L12,6,1)="0",4,"")&IF(MID(L12,7,1)="0",3,"")&IF(MID(L12,8,1)="0",2,"")&IF(MID(L12,9,1)="0",1,"")),("("&B2&")")) =IF(C2="",(IF(MID(M12,1,1)="0",9,"")&IF(MID(M12,2,1)="0",8,"")&IF(MID(M12,3,1)="0",7,"")&IF(MID(M12,4,1)="0",6,"")&IF(MID(M12,5,1)="0",5,"")&IF(MID(M12,6,1)="0",4,"")&IF(MID(M12,7,1)="0",3,"")&IF(MID(M12,8,1)="0",2,"")&IF(MID(M12,9,1)="0",1,"")),("("&C2&")")) =IF(D2="",(IF(MID(N12,1,1)="0",9,"")&IF(MID(N12,2,1)="0",8,"")&IF(MID(N12,3,1)="0",7,"")&IF(MID(N12,4,1)="0",6,"")&IF(MID(N12,5,1)="0",5,"")&IF(MID(N12,6,1)="0",4,"")&IF(MID(N12,7,1)="0",3,"")&IF(MID(N12,8,1)="0",2,"")&IF(MID(N12,9,1)="0",1,"")),("("&D2&")")) =IF(E2="",(IF(MID(O12,1,1)="0",9,"")&IF(MID(O12,2,1)="0",8,"")&IF(MID(O12,3,1)="0",7,"")&IF(MID(O12,4,1)="0",6,"")&IF(MID(O12,5,1)="0",5,"")&IF(MID(O12,6,1)="0",4,"")&IF(MID(O12,7,1)="0",3,"")&IF(MID(O12,8,1)="0",2,"")&IF(MID(O12,9,1)="0",1,"")),("("&E2&")")) =IF(F2="",(IF(MID(P12,1,1)="0",9,"")&IF(MID(P12,2,1)="0",8,"")&IF(MID(P12,3,1)="0",7,"")&IF(MID(P12,4,1)="0",6,"")&IF(MID(P12,5,1)="0",5,"")&IF(MID(P12,6,1)="0",4,"")&IF(MID(P12,7,1)="0",3,"")&IF(MID(P12,8,1)="0",2,"")&IF(MID(P12,9,1)="0",1,"")),("("&F2&")")) =IF(G2="",(IF(MID(Q12,1,1)="0",9,"")&IF(MID(Q12,2,1)="0",8,"")&IF(MID(Q12,3,1)="0",7,"")&IF(MID(Q12,4,1)="0",6,"")&IF(MID(Q12,5,1)="0",5,"")&IF(MID(Q12,6,1)="0",4,"")&IF(MID(Q12,7,1)="0",3,"")&IF(MID(Q12,8,1)="0",2,"")&IF(MID(Q12,9,1)="0",1,"")),("("&G2&")")) =IF(H2="",(IF(MID(R12,1,1)="0",9,"")&IF(MID(R12,2,1)="0",8,"")&IF(MID(R12,3,1)="0",7,"")&IF(MID(R12,4,1)="0",6,"")&IF(MID(R12,5,1)="0",5,"")&IF(MID(R12,6,1)="0",4,"")&IF(MID(R12,7,1)="0",3,"")&IF(MID(R12,8,1)="0",2,"")&IF(MID(R12,9,1)="0",1,"")),("("&H2&")")) =IF(I2="",(IF(MID(S12,1,1)="0",9,"")&IF(MID(S12,2,1)="0",8,"")&IF(MID(S12,3,1)="0",7,"")&IF(MID(S12,4,1)="0",6,"")&IF(MID(S12,5,1)="0",5,"")&IF(MID(S12,6,1)="0",4,"")&IF(MID(S12,7,1)="0",3,"")&IF(MID(S12,8,1)="0",2,"")&IF(MID(S12,9,1)="0",1,"")),("("&I2&")")) ="" =MID(K$10+$T2+$V$1+10^9,2,9) =MID(L$10+$T2+$V$1+10^9,2,9) =MID(M$10+$T2+$V$1+10^9,2,9) =MID(N$10+$T2+$W$1+10^9,2,9) =MID(O$10+$T2+$W$1+10^9,2,9) =MID(P$10+$T2+$W$1+10^9,2,9) =MID(Q$10+$T2+$X$1+10^9,2,9) =MID(R$10+$T2+$X$1+10^9,2,9) =MID(S$10+$T2+$X$1+10^9,2,9) ="" ="" ="" ="" ="" =IF(A3="",(IF(MID(K13,1,1)="0",9,"")&IF(MID(K13,2,1)="0",8,"")&IF(MID(K13,3,1)="0",7,"")&IF(MID(K13,4,1)="0",6,"")&IF(MID(K13,5,1)="0",5,"")&IF(MID(K13,6,1)="0",4,"")&IF(MID(K13,7,1)="0",3,"")&IF(MID(K13,8,1)="0",2,"")&IF(MID(K13,9,1)="0",1,"")),("("&A3&")")) =IF(B3="",(IF(MID(L13,1,1)="0",9,"")&IF(MID(L13,2,1)="0",8,"")&IF(MID(L13,3,1)="0",7,"")&IF(MID(L13,4,1)="0",6,"")&IF(MID(L13,5,1)="0",5,"")&IF(MID(L13,6,1)="0",4,"")&IF(MID(L13,7,1)="0",3,"")&IF(MID(L13,8,1)="0",2,"")&IF(MID(L13,9,1)="0",1,"")),("("&B3&")")) =IF(C3="",(IF(MID(M13,1,1)="0",9,"")&IF(MID(M13,2,1)="0",8,"")&IF(MID(M13,3,1)="0",7,"")&IF(MID(M13,4,1)="0",6,"")&IF(MID(M13,5,1)="0",5,"")&IF(MID(M13,6,1)="0",4,"")&IF(MID(M13,7,1)="0",3,"")&IF(MID(M13,8,1)="0",2,"")&IF(MID(M13,9,1)="0",1,"")),("("&C3&")")) =IF(D3="",(IF(MID(N13,1,1)="0",9,"")&IF(MID(N13,2,1)="0",8,"")&IF(MID(N13,3,1)="0",7,"")&IF(MID(N13,4,1)="0",6,"")&IF(MID(N13,5,1)="0",5,"")&IF(MID(N13,6,1)="0",4,"")&IF(MID(N13,7,1)="0",3,"")&IF(MID(N13,8,1)="0",2,"")&IF(MID(N13,9,1)="0",1,"")),("("&D3&")")) =IF(E3="",(IF(MID(O13,1,1)="0",9,"")&IF(MID(O13,2,1)="0",8,"")&IF(MID(O13,3,1)="0",7,"")&IF(MID(O13,4,1)="0",6,"")&IF(MID(O13,5,1)="0",5,"")&IF(MID(O13,6,1)="0",4,"")&IF(MID(O13,7,1)="0",3,"")&IF(MID(O13,8,1)="0",2,"")&IF(MID(O13,9,1)="0",1,"")),("("&E3&")")) =IF(F3="",(IF(MID(P13,1,1)="0",9,"")&IF(MID(P13,2,1)="0",8,"")&IF(MID(P13,3,1)="0",7,"")&IF(MID(P13,4,1)="0",6,"")&IF(MID(P13,5,1)="0",5,"")&IF(MID(P13,6,1)="0",4,"")&IF(MID(P13,7,1)="0",3,"")&IF(MID(P13,8,1)="0",2,"")&IF(MID(P13,9,1)="0",1,"")),("("&F3&")")) =IF(G3="",(IF(MID(Q13,1,1)="0",9,"")&IF(MID(Q13,2,1)="0",8,"")&IF(MID(Q13,3,1)="0",7,"")&IF(MID(Q13,4,1)="0",6,"")&IF(MID(Q13,5,1)="0",5,"")&IF(MID(Q13,6,1)="0",4,"")&IF(MID(Q13,7,1)="0",3,"")&IF(MID(Q13,8,1)="0",2,"")&IF(MID(Q13,9,1)="0",1,"")),("("&G3&")")) =IF(H3="",(IF(MID(R13,1,1)="0",9,"")&IF(MID(R13,2,1)="0",8,"")&IF(MID(R13,3,1)="0",7,"")&IF(MID(R13,4,1)="0",6,"")&IF(MID(R13,5,1)="0",5,"")&IF(MID(R13,6,1)="0",4,"")&IF(MID(R13,7,1)="0",3,"")&IF(MID(R13,8,1)="0",2,"")&IF(MID(R13,9,1)="0",1,"")),("("&H3&")")) =IF(I3="",(IF(MID(S13,1,1)="0",9,"")&IF(MID(S13,2,1)="0",8,"")&IF(MID(S13,3,1)="0",7,"")&IF(MID(S13,4,1)="0",6,"")&IF(MID(S13,5,1)="0",5,"")&IF(MID(S13,6,1)="0",4,"")&IF(MID(S13,7,1)="0",3,"")&IF(MID(S13,8,1)="0",2,"")&IF(MID(S13,9,1)="0",1,"")),("("&I3&")")) ="" =MID(K$10+$T3+$V$1+10^9,2,9) =MID(L$10+$T3+$V$1+10^9,2,9) =MID(M$10+$T3+$V$1+10^9,2,9) =MID(N$10+$T3+$W$1+10^9,2,9) =MID(O$10+$T3+$W$1+10^9,2,9) =MID(P$10+$T3+$W$1+10^9,2,9) =MID(Q$10+$T3+$X$1+10^9,2,9) =MID(R$10+$T3+$X$1+10^9,2,9) =MID(S$10+$T3+$X$1+10^9,2,9) ="" ="" ="" ="" ="" =IF(A4="",(IF(MID(K14,1,1)="0",9,"")&IF(MID(K14,2,1)="0",8,"")&IF(MID(K14,3,1)="0",7,"")&IF(MID(K14,4,1)="0",6,"")&IF(MID(K14,5,1)="0",5,"")&IF(MID(K14,6,1)="0",4,"")&IF(MID(K14,7,1)="0",3,"")&IF(MID(K14,8,1)="0",2,"")&IF(MID(K14,9,1)="0",1,"")),("("&A4&")")) =IF(B4="",(IF(MID(L14,1,1)="0",9,"")&IF(MID(L14,2,1)="0",8,"")&IF(MID(L14,3,1)="0",7,"")&IF(MID(L14,4,1)="0",6,"")&IF(MID(L14,5,1)="0",5,"")&IF(MID(L14,6,1)="0",4,"")&IF(MID(L14,7,1)="0",3,"")&IF(MID(L14,8,1)="0",2,"")&IF(MID(L14,9,1)="0",1,"")),("("&B4&")")) =IF(C4="",(IF(MID(M14,1,1)="0",9,"")&IF(MID(M14,2,1)="0",8,"")&IF(MID(M14,3,1)="0",7,"")&IF(MID(M14,4,1)="0",6,"")&IF(MID(M14,5,1)="0",5,"")&IF(MID(M14,6,1)="0",4,"")&IF(MID(M14,7,1)="0",3,"")&IF(MID(M14,8,1)="0",2,"")&IF(MID(M14,9,1)="0",1,"")),("("&C4&")")) =IF(D4="",(IF(MID(N14,1,1)="0",9,"")&IF(MID(N14,2,1)="0",8,"")&IF(MID(N14,3,1)="0",7,"")&IF(MID(N14,4,1)="0",6,"")&IF(MID(N14,5,1)="0",5,"")&IF(MID(N14,6,1)="0",4,"")&IF(MID(N14,7,1)="0",3,"")&IF(MID(N14,8,1)="0",2,"")&IF(MID(N14,9,1)="0",1,"")),("("&D4&")")) =IF(E4="",(IF(MID(O14,1,1)="0",9,"")&IF(MID(O14,2,1)="0",8,"")&IF(MID(O14,3,1)="0",7,"")&IF(MID(O14,4,1)="0",6,"")&IF(MID(O14,5,1)="0",5,"")&IF(MID(O14,6,1)="0",4,"")&IF(MID(O14,7,1)="0",3,"")&IF(MID(O14,8,1)="0",2,"")&IF(MID(O14,9,1)="0",1,"")),("("&E4&")")) =IF(F4="",(IF(MID(P14,1,1)="0",9,"")&IF(MID(P14,2,1)="0",8,"")&IF(MID(P14,3,1)="0",7,"")&IF(MID(P14,4,1)="0",6,"")&IF(MID(P14,5,1)="0",5,"")&IF(MID(P14,6,1)="0",4,"")&IF(MID(P14,7,1)="0",3,"")&IF(MID(P14,8,1)="0",2,"")&IF(MID(P14,9,1)="0",1,"")),("("&F4&")")) =IF(G4="",(IF(MID(Q14,1,1)="0",9,"")&IF(MID(Q14,2,1)="0",8,"")&IF(MID(Q14,3,1)="0",7,"")&IF(MID(Q14,4,1)="0",6,"")&IF(MID(Q14,5,1)="0",5,"")&IF(MID(Q14,6,1)="0",4,"")&IF(MID(Q14,7,1)="0",3,"")&IF(MID(Q14,8,1)="0",2,"")&IF(MID(Q14,9,1)="0",1,"")),("("&G4&")")) =IF(H4="",(IF(MID(R14,1,1)="0",9,"")&IF(MID(R14,2,1)="0",8,"")&IF(MID(R14,3,1)="0",7,"")&IF(MID(R14,4,1)="0",6,"")&IF(MID(R14,5,1)="0",5,"")&IF(MID(R14,6,1)="0",4,"")&IF(MID(R14,7,1)="0",3,"")&IF(MID(R14,8,1)="0",2,"")&IF(MID(R14,9,1)="0",1,"")),("("&H4&")")) =IF(I4="",(IF(MID(S14,1,1)="0",9,"")&IF(MID(S14,2,1)="0",8,"")&IF(MID(S14,3,1)="0",7,"")&IF(MID(S14,4,1)="0",6,"")&IF(MID(S14,5,1)="0",5,"")&IF(MID(S14,6,1)="0",4,"")&IF(MID(S14,7,1)="0",3,"")&IF(MID(S14,8,1)="0",2,"")&IF(MID(S14,9,1)="0",1,"")),("("&I4&")")) ="" =MID(K$10+$T4+$V$4+10^9,2,9) =MID(L$10+$T4+$V$4+10^9,2,9) =MID(M$10+$T4+$V$4+10^9,2,9) =MID(N$10+$T4+$W$4+10^9,2,9) =MID(O$10+$T4+$W$4+10^9,2,9) =MID(P$10+$T4+$W$4+10^9,2,9) =MID(Q$10+$T4+$X$4+10^9,2,9) =MID(R$10+$T4+$X$4+10^9,2,9) =MID(S$10+$T4+$X$4+10^9,2,9) ="" ="" ="" ="" ="" =IF(A5="",(IF(MID(K15,1,1)="0",9,"")&IF(MID(K15,2,1)="0",8,"")&IF(MID(K15,3,1)="0",7,"")&IF(MID(K15,4,1)="0",6,"")&IF(MID(K15,5,1)="0",5,"")&IF(MID(K15,6,1)="0",4,"")&IF(MID(K15,7,1)="0",3,"")&IF(MID(K15,8,1)="0",2,"")&IF(MID(K15,9,1)="0",1,"")),("("&A5&")")) =IF(B5="",(IF(MID(L15,1,1)="0",9,"")&IF(MID(L15,2,1)="0",8,"")&IF(MID(L15,3,1)="0",7,"")&IF(MID(L15,4,1)="0",6,"")&IF(MID(L15,5,1)="0",5,"")&IF(MID(L15,6,1)="0",4,"")&IF(MID(L15,7,1)="0",3,"")&IF(MID(L15,8,1)="0",2,"")&IF(MID(L15,9,1)="0",1,"")),("("&B5&")")) =IF(C5="",(IF(MID(M15,1,1)="0",9,"")&IF(MID(M15,2,1)="0",8,"")&IF(MID(M15,3,1)="0",7,"")&IF(MID(M15,4,1)="0",6,"")&IF(MID(M15,5,1)="0",5,"")&IF(MID(M15,6,1)="0",4,"")&IF(MID(M15,7,1)="0",3,"")&IF(MID(M15,8,1)="0",2,"")&IF(MID(M15,9,1)="0",1,"")),("("&C5&")")) =IF(D5="",(IF(MID(N15,1,1)="0",9,"")&IF(MID(N15,2,1)="0",8,"")&IF(MID(N15,3,1)="0",7,"")&IF(MID(N15,4,1)="0",6,"")&IF(MID(N15,5,1)="0",5,"")&IF(MID(N15,6,1)="0",4,"")&IF(MID(N15,7,1)="0",3,"")&IF(MID(N15,8,1)="0",2,"")&IF(MID(N15,9,1)="0",1,"")),("("&D5&")")) =IF(E5="",(IF(MID(O15,1,1)="0",9,"")&IF(MID(O15,2,1)="0",8,"")&IF(MID(O15,3,1)="0",7,"")&IF(MID(O15,4,1)="0",6,"")&IF(MID(O15,5,1)="0",5,"")&IF(MID(O15,6,1)="0",4,"")&IF(MID(O15,7,1)="0",3,"")&IF(MID(O15,8,1)="0",2,"")&IF(MID(O15,9,1)="0",1,"")),("("&E5&")")) =IF(F5="",(IF(MID(P15,1,1)="0",9,"")&IF(MID(P15,2,1)="0",8,"")&IF(MID(P15,3,1)="0",7,"")&IF(MID(P15,4,1)="0",6,"")&IF(MID(P15,5,1)="0",5,"")&IF(MID(P15,6,1)="0",4,"")&IF(MID(P15,7,1)="0",3,"")&IF(MID(P15,8,1)="0",2,"")&IF(MID(P15,9,1)="0",1,"")),("("&F5&")")) =IF(G5="",(IF(MID(Q15,1,1)="0",9,"")&IF(MID(Q15,2,1)="0",8,"")&IF(MID(Q15,3,1)="0",7,"")&IF(MID(Q15,4,1)="0",6,"")&IF(MID(Q15,5,1)="0",5,"")&IF(MID(Q15,6,1)="0",4,"")&IF(MID(Q15,7,1)="0",3,"")&IF(MID(Q15,8,1)="0",2,"")&IF(MID(Q15,9,1)="0",1,"")),("("&G5&")")) =IF(H5="",(IF(MID(R15,1,1)="0",9,"")&IF(MID(R15,2,1)="0",8,"")&IF(MID(R15,3,1)="0",7,"")&IF(MID(R15,4,1)="0",6,"")&IF(MID(R15,5,1)="0",5,"")&IF(MID(R15,6,1)="0",4,"")&IF(MID(R15,7,1)="0",3,"")&IF(MID(R15,8,1)="0",2,"")&IF(MID(R15,9,1)="0",1,"")),("("&H5&")")) =IF(I5="",(IF(MID(S15,1,1)="0",9,"")&IF(MID(S15,2,1)="0",8,"")&IF(MID(S15,3,1)="0",7,"")&IF(MID(S15,4,1)="0",6,"")&IF(MID(S15,5,1)="0",5,"")&IF(MID(S15,6,1)="0",4,"")&IF(MID(S15,7,1)="0",3,"")&IF(MID(S15,8,1)="0",2,"")&IF(MID(S15,9,1)="0",1,"")),("("&I5&")")) ="" =MID(K$10+$T5+$V$4+10^9,2,9) =MID(L$10+$T5+$V$4+10^9,2,9) =MID(M$10+$T5+$V$4+10^9,2,9) =MID(N$10+$T5+$W$4+10^9,2,9) =MID(O$10+$T5+$W$4+10^9,2,9) =MID(P$10+$T5+$W$4+10^9,2,9) =MID(Q$10+$T5+$X$4+10^9,2,9) =MID(R$10+$T5+$X$4+10^9,2,9) =MID(S$10+$T5+$X$4+10^9,2,9) ="" ="" ="" ="" ="" =IF(A6="",(IF(MID(K16,1,1)="0",9,"")&IF(MID(K16,2,1)="0",8,"")&IF(MID(K16,3,1)="0",7,"")&IF(MID(K16,4,1)="0",6,"")&IF(MID(K16,5,1)="0",5,"")&IF(MID(K16,6,1)="0",4,"")&IF(MID(K16,7,1)="0",3,"")&IF(MID(K16,8,1)="0",2,"")&IF(MID(K16,9,1)="0",1,"")),("("&A6&")")) =IF(B6="",(IF(MID(L16,1,1)="0",9,"")&IF(MID(L16,2,1)="0",8,"")&IF(MID(L16,3,1)="0",7,"")&IF(MID(L16,4,1)="0",6,"")&IF(MID(L16,5,1)="0",5,"")&IF(MID(L16,6,1)="0",4,"")&IF(MID(L16,7,1)="0",3,"")&IF(MID(L16,8,1)="0",2,"")&IF(MID(L16,9,1)="0",1,"")),("("&B6&")")) =IF(C6="",(IF(MID(M16,1,1)="0",9,"")&IF(MID(M16,2,1)="0",8,"")&IF(MID(M16,3,1)="0",7,"")&IF(MID(M16,4,1)="0",6,"")&IF(MID(M16,5,1)="0",5,"")&IF(MID(M16,6,1)="0",4,"")&IF(MID(M16,7,1)="0",3,"")&IF(MID(M16,8,1)="0",2,"")&IF(MID(M16,9,1)="0",1,"")),("("&C6&")")) =IF(D6="",(IF(MID(N16,1,1)="0",9,"")&IF(MID(N16,2,1)="0",8,"")&IF(MID(N16,3,1)="0",7,"")&IF(MID(N16,4,1)="0",6,"")&IF(MID(N16,5,1)="0",5,"")&IF(MID(N16,6,1)="0",4,"")&IF(MID(N16,7,1)="0",3,"")&IF(MID(N16,8,1)="0",2,"")&IF(MID(N16,9,1)="0",1,"")),("("&D6&")")) =IF(E6="",(IF(MID(O16,1,1)="0",9,"")&IF(MID(O16,2,1)="0",8,"")&IF(MID(O16,3,1)="0",7,"")&IF(MID(O16,4,1)="0",6,"")&IF(MID(O16,5,1)="0",5,"")&IF(MID(O16,6,1)="0",4,"")&IF(MID(O16,7,1)="0",3,"")&IF(MID(O16,8,1)="0",2,"")&IF(MID(O16,9,1)="0",1,"")),("("&E6&")")) =IF(F6="",(IF(MID(P16,1,1)="0",9,"")&IF(MID(P16,2,1)="0",8,"")&IF(MID(P16,3,1)="0",7,"")&IF(MID(P16,4,1)="0",6,"")&IF(MID(P16,5,1)="0",5,"")&IF(MID(P16,6,1)="0",4,"")&IF(MID(P16,7,1)="0",3,"")&IF(MID(P16,8,1)="0",2,"")&IF(MID(P16,9,1)="0",1,"")),("("&F6&")")) =IF(G6="",(IF(MID(Q16,1,1)="0",9,"")&IF(MID(Q16,2,1)="0",8,"")&IF(MID(Q16,3,1)="0",7,"")&IF(MID(Q16,4,1)="0",6,"")&IF(MID(Q16,5,1)="0",5,"")&IF(MID(Q16,6,1)="0",4,"")&IF(MID(Q16,7,1)="0",3,"")&IF(MID(Q16,8,1)="0",2,"")&IF(MID(Q16,9,1)="0",1,"")),("("&G6&")")) =IF(H6="",(IF(MID(R16,1,1)="0",9,"")&IF(MID(R16,2,1)="0",8,"")&IF(MID(R16,3,1)="0",7,"")&IF(MID(R16,4,1)="0",6,"")&IF(MID(R16,5,1)="0",5,"")&IF(MID(R16,6,1)="0",4,"")&IF(MID(R16,7,1)="0",3,"")&IF(MID(R16,8,1)="0",2,"")&IF(MID(R16,9,1)="0",1,"")),("("&H6&")")) =IF(I6="",(IF(MID(S16,1,1)="0",9,"")&IF(MID(S16,2,1)="0",8,"")&IF(MID(S16,3,1)="0",7,"")&IF(MID(S16,4,1)="0",6,"")&IF(MID(S16,5,1)="0",5,"")&IF(MID(S16,6,1)="0",4,"")&IF(MID(S16,7,1)="0",3,"")&IF(MID(S16,8,1)="0",2,"")&IF(MID(S16,9,1)="0",1,"")),("("&I6&")")) ="" =MID(K$10+$T6+$V$4+10^9,2,9) =MID(L$10+$T6+$V$4+10^9,2,9) =MID(M$10+$T6+$V$4+10^9,2,9) =MID(N$10+$T6+$W$4+10^9,2,9) =MID(O$10+$T6+$W$4+10^9,2,9) =MID(P$10+$T6+$W$4+10^9,2,9) =MID(Q$10+$T6+$X$4+10^9,2,9) =MID(R$10+$T6+$X$4+10^9,2,9) =MID(S$10+$T6+$X$4+10^9,2,9) ="" ="" ="" ="" ="" =IF(A7="",(IF(MID(K17,1,1)="0",9,"")&IF(MID(K17,2,1)="0",8,"")&IF(MID(K17,3,1)="0",7,"")&IF(MID(K17,4,1)="0",6,"")&IF(MID(K17,5,1)="0",5,"")&IF(MID(K17,6,1)="0",4,"")&IF(MID(K17,7,1)="0",3,"")&IF(MID(K17,8,1)="0",2,"")&IF(MID(K17,9,1)="0",1,"")),("("&A7&")")) =IF(B7="",(IF(MID(L17,1,1)="0",9,"")&IF(MID(L17,2,1)="0",8,"")&IF(MID(L17,3,1)="0",7,"")&IF(MID(L17,4,1)="0",6,"")&IF(MID(L17,5,1)="0",5,"")&IF(MID(L17,6,1)="0",4,"")&IF(MID(L17,7,1)="0",3,"")&IF(MID(L17,8,1)="0",2,"")&IF(MID(L17,9,1)="0",1,"")),("("&B7&")")) =IF(C7="",(IF(MID(M17,1,1)="0",9,"")&IF(MID(M17,2,1)="0",8,"")&IF(MID(M17,3,1)="0",7,"")&IF(MID(M17,4,1)="0",6,"")&IF(MID(M17,5,1)="0",5,"")&IF(MID(M17,6,1)="0",4,"")&IF(MID(M17,7,1)="0",3,"")&IF(MID(M17,8,1)="0",2,"")&IF(MID(M17,9,1)="0",1,"")),("("&C7&")")) =IF(D7="",(IF(MID(N17,1,1)="0",9,"")&IF(MID(N17,2,1)="0",8,"")&IF(MID(N17,3,1)="0",7,"")&IF(MID(N17,4,1)="0",6,"")&IF(MID(N17,5,1)="0",5,"")&IF(MID(N17,6,1)="0",4,"")&IF(MID(N17,7,1)="0",3,"")&IF(MID(N17,8,1)="0",2,"")&IF(MID(N17,9,1)="0",1,"")),("("&D7&")")) =IF(E7="",(IF(MID(O17,1,1)="0",9,"")&IF(MID(O17,2,1)="0",8,"")&IF(MID(O17,3,1)="0",7,"")&IF(MID(O17,4,1)="0",6,"")&IF(MID(O17,5,1)="0",5,"")&IF(MID(O17,6,1)="0",4,"")&IF(MID(O17,7,1)="0",3,"")&IF(MID(O17,8,1)="0",2,"")&IF(MID(O17,9,1)="0",1,"")),("("&E7&")")) =IF(F7="",(IF(MID(P17,1,1)="0",9,"")&IF(MID(P17,2,1)="0",8,"")&IF(MID(P17,3,1)="0",7,"")&IF(MID(P17,4,1)="0",6,"")&IF(MID(P17,5,1)="0",5,"")&IF(MID(P17,6,1)="0",4,"")&IF(MID(P17,7,1)="0",3,"")&IF(MID(P17,8,1)="0",2,"")&IF(MID(P17,9,1)="0",1,"")),("("&F7&")")) =IF(G7="",(IF(MID(Q17,1,1)="0",9,"")&IF(MID(Q17,2,1)="0",8,"")&IF(MID(Q17,3,1)="0",7,"")&IF(MID(Q17,4,1)="0",6,"")&IF(MID(Q17,5,1)="0",5,"")&IF(MID(Q17,6,1)="0",4,"")&IF(MID(Q17,7,1)="0",3,"")&IF(MID(Q17,8,1)="0",2,"")&IF(MID(Q17,9,1)="0",1,"")),("("&G7&")")) =IF(H7="",(IF(MID(R17,1,1)="0",9,"")&IF(MID(R17,2,1)="0",8,"")&IF(MID(R17,3,1)="0",7,"")&IF(MID(R17,4,1)="0",6,"")&IF(MID(R17,5,1)="0",5,"")&IF(MID(R17,6,1)="0",4,"")&IF(MID(R17,7,1)="0",3,"")&IF(MID(R17,8,1)="0",2,"")&IF(MID(R17,9,1)="0",1,"")),("("&H7&")")) =IF(I7="",(IF(MID(S17,1,1)="0",9,"")&IF(MID(S17,2,1)="0",8,"")&IF(MID(S17,3,1)="0",7,"")&IF(MID(S17,4,1)="0",6,"")&IF(MID(S17,5,1)="0",5,"")&IF(MID(S17,6,1)="0",4,"")&IF(MID(S17,7,1)="0",3,"")&IF(MID(S17,8,1)="0",2,"")&IF(MID(S17,9,1)="0",1,"")),("("&I7&")")) ="" =MID(K$10+$T7+$V$7+10^9,2,9) =MID(L$10+$T7+$V$7+10^9,2,9) =MID(M$10+$T7+$V$7+10^9,2,9) =MID(N$10+$T7+$W$7+10^9,2,9) =MID(O$10+$T7+$W$7+10^9,2,9) =MID(P$10+$T7+$W$7+10^9,2,9) =MID(Q$10+$T7+$X$7+10^9,2,9) =MID(R$10+$T7+$X$7+10^9,2,9) =MID(S$10+$T7+$X$7+10^9,2,9) ="" ="" ="" ="" ="" =IF(A8="",(IF(MID(K18,1,1)="0",9,"")&IF(MID(K18,2,1)="0",8,"")&IF(MID(K18,3,1)="0",7,"")&IF(MID(K18,4,1)="0",6,"")&IF(MID(K18,5,1)="0",5,"")&IF(MID(K18,6,1)="0",4,"")&IF(MID(K18,7,1)="0",3,"")&IF(MID(K18,8,1)="0",2,"")&IF(MID(K18,9,1)="0",1,"")),("("&A8&")")) =IF(B8="",(IF(MID(L18,1,1)="0",9,"")&IF(MID(L18,2,1)="0",8,"")&IF(MID(L18,3,1)="0",7,"")&IF(MID(L18,4,1)="0",6,"")&IF(MID(L18,5,1)="0",5,"")&IF(MID(L18,6,1)="0",4,"")&IF(MID(L18,7,1)="0",3,"")&IF(MID(L18,8,1)="0",2,"")&IF(MID(L18,9,1)="0",1,"")),("("&B8&")")) =IF(C8="",(IF(MID(M18,1,1)="0",9,"")&IF(MID(M18,2,1)="0",8,"")&IF(MID(M18,3,1)="0",7,"")&IF(MID(M18,4,1)="0",6,"")&IF(MID(M18,5,1)="0",5,"")&IF(MID(M18,6,1)="0",4,"")&IF(MID(M18,7,1)="0",3,"")&IF(MID(M18,8,1)="0",2,"")&IF(MID(M18,9,1)="0",1,"")),("("&C8&")")) =IF(D8="",(IF(MID(N18,1,1)="0",9,"")&IF(MID(N18,2,1)="0",8,"")&IF(MID(N18,3,1)="0",7,"")&IF(MID(N18,4,1)="0",6,"")&IF(MID(N18,5,1)="0",5,"")&IF(MID(N18,6,1)="0",4,"")&IF(MID(N18,7,1)="0",3,"")&IF(MID(N18,8,1)="0",2,"")&IF(MID(N18,9,1)="0",1,"")),("("&D8&")")) =IF(E8="",(IF(MID(O18,1,1)="0",9,"")&IF(MID(O18,2,1)="0",8,"")&IF(MID(O18,3,1)="0",7,"")&IF(MID(O18,4,1)="0",6,"")&IF(MID(O18,5,1)="0",5,"")&IF(MID(O18,6,1)="0",4,"")&IF(MID(O18,7,1)="0",3,"")&IF(MID(O18,8,1)="0",2,"")&IF(MID(O18,9,1)="0",1,"")),("("&E8&")")) =IF(F8="",(IF(MID(P18,1,1)="0",9,"")&IF(MID(P18,2,1)="0",8,"")&IF(MID(P18,3,1)="0",7,"")&IF(MID(P18,4,1)="0",6,"")&IF(MID(P18,5,1)="0",5,"")&IF(MID(P18,6,1)="0",4,"")&IF(MID(P18,7,1)="0",3,"")&IF(MID(P18,8,1)="0",2,"")&IF(MID(P18,9,1)="0",1,"")),("("&F8&")")) =IF(G8="",(IF(MID(Q18,1,1)="0",9,"")&IF(MID(Q18,2,1)="0",8,"")&IF(MID(Q18,3,1)="0",7,"")&IF(MID(Q18,4,1)="0",6,"")&IF(MID(Q18,5,1)="0",5,"")&IF(MID(Q18,6,1)="0",4,"")&IF(MID(Q18,7,1)="0",3,"")&IF(MID(Q18,8,1)="0",2,"")&IF(MID(Q18,9,1)="0",1,"")),("("&G8&")")) =IF(H8="",(IF(MID(R18,1,1)="0",9,"")&IF(MID(R18,2,1)="0",8,"")&IF(MID(R18,3,1)="0",7,"")&IF(MID(R18,4,1)="0",6,"")&IF(MID(R18,5,1)="0",5,"")&IF(MID(R18,6,1)="0",4,"")&IF(MID(R18,7,1)="0",3,"")&IF(MID(R18,8,1)="0",2,"")&IF(MID(R18,9,1)="0",1,"")),("("&H8&")")) =IF(I8="",(IF(MID(S18,1,1)="0",9,"")&IF(MID(S18,2,1)="0",8,"")&IF(MID(S18,3,1)="0",7,"")&IF(MID(S18,4,1)="0",6,"")&IF(MID(S18,5,1)="0",5,"")&IF(MID(S18,6,1)="0",4,"")&IF(MID(S18,7,1)="0",3,"")&IF(MID(S18,8,1)="0",2,"")&IF(MID(S18,9,1)="0",1,"")),("("&I8&")")) ="" =MID(K$10+$T8+$V$7+10^9,2,9) =MID(L$10+$T8+$V$7+10^9,2,9) =MID(M$10+$T8+$V$7+10^9,2,9) =MID(N$10+$T8+$W$7+10^9,2,9) =MID(O$10+$T8+$W$7+10^9,2,9) =MID(P$10+$T8+$W$7+10^9,2,9) =MID(Q$10+$T8+$X$7+10^9,2,9) =MID(R$10+$T8+$X$7+10^9,2,9) =MID(S$10+$T8+$X$7+10^9,2,9) ="" ="" ="" ="" ="" =IF(A9="",(IF(MID(K19,1,1)="0",9,"")&IF(MID(K19,2,1)="0",8,"")&IF(MID(K19,3,1)="0",7,"")&IF(MID(K19,4,1)="0",6,"")&IF(MID(K19,5,1)="0",5,"")&IF(MID(K19,6,1)="0",4,"")&IF(MID(K19,7,1)="0",3,"")&IF(MID(K19,8,1)="0",2,"")&IF(MID(K19,9,1)="0",1,"")),("("&A9&")")) =IF(B9="",(IF(MID(L19,1,1)="0",9,"")&IF(MID(L19,2,1)="0",8,"")&IF(MID(L19,3,1)="0",7,"")&IF(MID(L19,4,1)="0",6,"")&IF(MID(L19,5,1)="0",5,"")&IF(MID(L19,6,1)="0",4,"")&IF(MID(L19,7,1)="0",3,"")&IF(MID(L19,8,1)="0",2,"")&IF(MID(L19,9,1)="0",1,"")),("("&B9&")")) =IF(C9="",(IF(MID(M19,1,1)="0",9,"")&IF(MID(M19,2,1)="0",8,"")&IF(MID(M19,3,1)="0",7,"")&IF(MID(M19,4,1)="0",6,"")&IF(MID(M19,5,1)="0",5,"")&IF(MID(M19,6,1)="0",4,"")&IF(MID(M19,7,1)="0",3,"")&IF(MID(M19,8,1)="0",2,"")&IF(MID(M19,9,1)="0",1,"")),("("&C9&")")) =IF(D9="",(IF(MID(N19,1,1)="0",9,"")&IF(MID(N19,2,1)="0",8,"")&IF(MID(N19,3,1)="0",7,"")&IF(MID(N19,4,1)="0",6,"")&IF(MID(N19,5,1)="0",5,"")&IF(MID(N19,6,1)="0",4,"")&IF(MID(N19,7,1)="0",3,"")&IF(MID(N19,8,1)="0",2,"")&IF(MID(N19,9,1)="0",1,"")),("("&D9&")")) =IF(E9="",(IF(MID(O19,1,1)="0",9,"")&IF(MID(O19,2,1)="0",8,"")&IF(MID(O19,3,1)="0",7,"")&IF(MID(O19,4,1)="0",6,"")&IF(MID(O19,5,1)="0",5,"")&IF(MID(O19,6,1)="0",4,"")&IF(MID(O19,7,1)="0",3,"")&IF(MID(O19,8,1)="0",2,"")&IF(MID(O19,9,1)="0",1,"")),("("&E9&")")) =IF(F9="",(IF(MID(P19,1,1)="0",9,"")&IF(MID(P19,2,1)="0",8,"")&IF(MID(P19,3,1)="0",7,"")&IF(MID(P19,4,1)="0",6,"")&IF(MID(P19,5,1)="0",5,"")&IF(MID(P19,6,1)="0",4,"")&IF(MID(P19,7,1)="0",3,"")&IF(MID(P19,8,1)="0",2,"")&IF(MID(P19,9,1)="0",1,"")),("("&F9&")")) =IF(G9="",(IF(MID(Q19,1,1)="0",9,"")&IF(MID(Q19,2,1)="0",8,"")&IF(MID(Q19,3,1)="0",7,"")&IF(MID(Q19,4,1)="0",6,"")&IF(MID(Q19,5,1)="0",5,"")&IF(MID(Q19,6,1)="0",4,"")&IF(MID(Q19,7,1)="0",3,"")&IF(MID(Q19,8,1)="0",2,"")&IF(MID(Q19,9,1)="0",1,"")),("("&G9&")")) =IF(H9="",(IF(MID(R19,1,1)="0",9,"")&IF(MID(R19,2,1)="0",8,"")&IF(MID(R19,3,1)="0",7,"")&IF(MID(R19,4,1)="0",6,"")&IF(MID(R19,5,1)="0",5,"")&IF(MID(R19,6,1)="0",4,"")&IF(MID(R19,7,1)="0",3,"")&IF(MID(R19,8,1)="0",2,"")&IF(MID(R19,9,1)="0",1,"")),("("&H9&")")) =IF(I9="",(IF(MID(S19,1,1)="0",9,"")&IF(MID(S19,2,1)="0",8,"")&IF(MID(S19,3,1)="0",7,"")&IF(MID(S19,4,1)="0",6,"")&IF(MID(S19,5,1)="0",5,"")&IF(MID(S19,6,1)="0",4,"")&IF(MID(S19,7,1)="0",3,"")&IF(MID(S19,8,1)="0",2,"")&IF(MID(S19,9,1)="0",1,"")),("("&I9&")")) ="" =MID(K$10+$T9+$V$7+10^9,2,9) =MID(L$10+$T9+$V$7+10^9,2,9) =MID(M$10+$T9+$V$7+10^9,2,9) =MID(N$10+$T9+$W$7+10^9,2,9) =MID(O$10+$T9+$W$7+10^9,2,9) =MID(P$10+$T9+$W$7+10^9,2,9) =MID(Q$10+$T9+$X$7+10^9,2,9) =MID(R$10+$T9+$X$7+10^9,2,9) =MID(S$10+$T9+$X$7+10^9,2,9) ="" ="" ="" ="" =""
2022年2月1日
