{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["условия","решение изменяя XYZ","решение уравнения"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":29,"n_cols":15,"rows_kept":29,"cut":false,"hidden":false,"merged":[[24,1,24,3],[4,10,4,15],[4,1,4,3],[4,5,4,7],[14,1,14,3],[14,5,14,7]]}
[]
[]
[null,"И","Λ","&",null,"ИЛИ","V"]
[]
[null,"Коньюкция",null,null,null,"Дезьюкция",null,null,null,null,"Логические функции"]
[null,"А","Б","С",null,"А","Б","С"]
[null,0,0,0,null,0,0,0,null,null,"Наименование","формула","обозначение","Значение","АНГЛ  значение"]
[null,0,1,0,null,0,1,1,null,null,{"$f":"B5","v":"Коньюкция"},1,{"$f":"C3","v":"Λ"},"и","«AND»"]
[null,1,0,0,null,1,0,1,null,null,{"$f":"F5","v":"Дезьюкция"},2,{"$f":"G3","v":"V"},"или","«OR»"]
[null,1,1,1,null,1,1,1,null,null,{"$f":"B15","v":"Эквивалентность"},3,{"$f":"B13","v":"Ξ"},null,"«EQ»"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F15","v":"Импликация"},4,{"$f":"G13","v":"→"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B25","v":"Инверсия"},5,{"$f":"C23","v":"¬"},"не","«NOT»"]
[null,"Ξ",null,"<=>",null,null,"→"]
[]
[null,"Эквивалентность",null,null,null,"Импликация"]
[null,"А","Б","С",null,"А","Б","С"]
[null,0,0,1,null,0,0,1]
[null,0,1,0,null,0,1,1]
[null,1,0,0,null,1,0,0]
[null,1,1,1,null,1,1,1]
[]
[]
[null,"НЕ","¬"]
[]
[null,"Инверсия"]
[]
[null,"А","Ᾱ"]
[null,0,1]
[null,1,0]

{"sheet":"решение изменяя XYZ","index":1,"n_rows":30,"n_cols":34,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,0,26,4],[29,0,35,4],[1,2,1,4],[25,0,25,4],[1,0,3,1],[7,16,7,19],[7,20,7,24],[24,0,24,4]]}
[]
["условие",null,{"$f":"CONCATENATE(AA5,\"  \",AB5,\"  \",AC5,\"  \",AD5,\"  \",AE5,\" \",AF5,\"  \",AG5,\"  \",AH5)","v":"y  Λ  z  V  ¬ z  Λ  x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"исходное","X","Λ","Y","V","¬","Y","Λ","Z"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","Λ","z","V","¬","z","Λ","x"]
[]
[null,{"$f":"AA5","v":"y"},{"$f":"AC5","v":"z"},{"$f":"AH5","v":"x"},null,null,{"$f":"E8","v":"¬ z"},null,null,null,{"$f":"H8","v":"y Λ z"},null,null,null,null,{"$f":"L8","v":"¬ z Λ x"},null,null,null,null,null,null,null,null,null,{"$f":"C2","v":"y  Λ  z  V  ¬ z  Λ  x"}]
[null,null,null,null,{"$f":"CONCATENATE(AE5,\" \",AF5)","v":"¬ z"},{"$f":"CutWords(E8)","v":"¬ z"},null,{"$f":"CONCATENATE(AA5,\" \",AB5,\" \",AC5)","v":"y Λ z"},{"$f":"CutWords(H8)","v":"y Λ z"},null,null,{"$f":"CONCATENATE(AE5,\" \",AF5,\" \",AG5,\" \",AH5)","v":"¬ z Λ x"},{"$f":"CutWords(L8)","v":"¬ z Λ x"},null,null,null,{"$f":"TRIM(Z7)","v":"y Λ z V ¬ z Λ x"},null,null,null,{"$f":"CutWords(Q8)","v":"y Λ z V ¬ z Λ x"}]
[null,null,null,null,1,2,null,1,2,3,null,1,2,3,4,null,1,2,3,4,5,6,7,8,9]
[null,null,null,null,{"$f":"SUBSTRING($F$8,\" \",E$9)","v":"¬"},{"$f":"SUBSTRING($F$8,\" \",F$9)","v":"z"},null,{"$f":"SUBSTRING($I$8,\" \",H$9)","v":"y"},{"$f":"SUBSTRING($I$8,\" \",I$9)","v":"Λ"},{"$f":"SUBSTRING($I$8,\" \",J$9)","v":"z"},null,{"$f":"SUBSTRING($M$8,\" \",L$9)","v":"¬"},{"$f":"SUBSTRING($M$8,\" \",M$9)","v":"z"},{"$f":"SUBSTRING($M$8,\" \",N$9)","v":"Λ"},{"$f":"SUBSTRING($M$8,\" \",O$9)","v":"x"},null,{"$f":"SUBSTRING($U$8,\" \",Q$9)","v":"y"},"Λ","z","V","¬","z","Λ","x",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(L10,\" \",M10)","v":"¬ z"},null,null,null,null,{"$f":"CONCATENATE(Q10,\" \",R10,\" \",S10)","v":"y Λ z"},null,null,null,{"$f":"CONCATENATE(U10,\" \",V10,\" \",W10,\" \",X10)","v":"¬ z Λ x"}]
[null,null,null,null,{"$f":"MATCH(F10,B7:G7,0)","v":2},null,null,{"$f":"MATCH(H10,$B$7:$G$7,0)","v":1},null,{"$f":"MATCH(J10,$B$7:$G$7,0)","v":2},null,{"$f":"MATCH(L11,$B$7:$G$7,0)","v":6},null,null,{"$f":"MATCH(O10,$B$7:$G$7,0)","v":3},null,{"$f":"MATCH(Q11,$B$7:$P$7,0)","v":10},null,null,null,{"$f":"MATCH(U11,$B$7:$P$7,0)","v":15}]
[null,null,null,null,{"$f":"MATCH(E10,Таблица1[обозначение],0)","v":5},null,null,null,{"$f":"MATCH(I10,Таблица1[обозначение],0)","v":1},null,null,null,null,{"$f":"MATCH(N10,Таблица1[обозначение],0)","v":1},null,null,null,null,null,{"$f":"MATCH(T10,Таблица1[обозначение],0)","v":2}]
[1,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",0,IF($B$7=\"Z\",0)))","v":0},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",0,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",0,IF($D$7=\"Z\",0)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B14:D14,$E$12)))","v":true},null,{"$f":"IF(E14=TRUE,1,0)","v":1},null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B14:D14,$H$12)=1,VLOOKUP($A$14,B14:D14,$J$12)=1),1,0))","v":0},null,{"$f":"I14","v":0},null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B14:K14,$L$12)=1,VLOOKUP($A$14,B14:K14,$O$12)=1),1,0))","v":0},null,{"$f":"N14","v":0},null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B14:P14,$Q$12)=1,VLOOKUP($A$14,B14:P14,$U$12)=1),1,0))","v":0},null,null,null,null,null,{"$f":"T14","v":0}]
[2,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",0,IF($B$7=\"Z\",1)))","v":0},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",0,IF($C$7=\"Z\",1)))","v":1},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",0,IF($D$7=\"Z\",1)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B15:D15,$E$12)))","v":false},null,{"$f":"IF(E15=TRUE,1,0)","v":0},null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B15:D15,$H$12)=1,VLOOKUP($A$14,B15:D15,$J$12)=1),1,0))","v":0},null,{"$f":"I15","v":0},null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B15:K15,$L$12)=1,VLOOKUP($A$14,B15:K15,$O$12)=1),1,0))","v":0},null,{"$f":"N15","v":0},null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B15:P15,$Q$12)=1,VLOOKUP($A$14,B15:P15,$U$12)=1),1,0))","v":0},null,null,null,null,null,0]
[3,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",1,IF($B$7=\"Z\",0)))","v":1},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",1,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",1,IF($D$7=\"Z\",0)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B16:D16,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B16:D16,$H$12)=1,VLOOKUP($A$14,B16:D16,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B16:K16,$L$12)=1,VLOOKUP($A$14,B16:K16,$O$12)=1),1,0))","v":0},null,0,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B16:P16,$Q$12)=1,VLOOKUP($A$14,B16:P16,$U$12)=1),1,0))","v":0},null,null,null,null,null,0,null,null,null,5,4,3,2,1]
[4,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",1,IF($B$7=\"Z\",1)))","v":1},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",1,IF($C$7=\"Z\",1)))","v":1},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",1,IF($D$7=\"Z\",1)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B17:D17,$E$12)))","v":false},null,0,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B17:D17,$H$12)=1,VLOOKUP($A$14,B17:D17,$J$12)=1),1,0))","v":1},null,1,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B17:K17,$L$12)=1,VLOOKUP($A$14,B17:K17,$O$12)=1),1,0))","v":0},null,0,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B17:P17,$Q$12)=1,VLOOKUP($A$14,B17:P17,$U$12)=1),1,0))","v":1},null,null,null,null,null,1,null,null,null,{"$f":"условия!C23","v":"¬"},{"$f":"условия!G13","v":"→"},{"$f":"условия!B13","v":"Ξ"},{"$f":"условия!G3","v":"V"},{"$f":"условия!C3","v":"Λ"}]
[5,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",0,IF($B$7=\"Z\",0)))","v":0},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",0,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",0,IF($D$7=\"Z\",0)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B18:D18,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B18:D18,$H$12)=1,VLOOKUP($A$14,B18:D18,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B18:K18,$L$12)=1,VLOOKUP($A$14,B18:K18,$O$12)=1),1,0))","v":1},null,1,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B18:P18,$Q$12)=1,VLOOKUP($A$14,B18:P18,$U$12)=1),1,0))","v":1},null,null,null,null,null,1,null,null,null,{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP(A14,B14:D14,$E$12)))","v":true},null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B14:P14,$Q$12)=1,VLOOKUP($A$14,B14:P14,$U$12)=1),1,0))","v":0},{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP(A14,B14:D14,$H$12)=1,VLOOKUP(A14,B14:D14,$J$12)=1),1,0))","v":0}]
[6,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",0,IF($B$7=\"Z\",1)))","v":0},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",0,IF($C$7=\"Z\",1)))","v":1},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",0,IF($D$7=\"Z\",1)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B19:D19,$E$12)))","v":false},null,0,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B19:D19,$H$12)=1,VLOOKUP($A$14,B19:D19,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B19:K19,$L$12)=1,VLOOKUP($A$14,B19:K19,$O$12)=1),1,0))","v":0},null,0,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B19:P19,$Q$12)=1,VLOOKUP($A$14,B19:P19,$U$12)=1),1,0))","v":0},null,null,null,null,null,0]
[7,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",1,IF($B$7=\"Z\",0)))","v":1},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",1,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",1,IF($D$7=\"Z\",0)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B20:D20,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B20:D20,$H$12)=1,VLOOKUP($A$14,B20:D20,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B20:K20,$L$12)=1,VLOOKUP($A$14,B20:K20,$O$12)=1),1,0))","v":1},null,1,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B20:P20,$Q$12)=1,VLOOKUP($A$14,B20:P20,$U$12)=1),1,0))","v":1},null,null,null,null,null,1]
[8,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",1,IF($B$7=\"Z\",)))","v":1},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",1,IF($C$7=\"Z\",)))","v":0},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",1,IF($D$7=\"Z\",)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B21:D21,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B21:D21,$H$12)=1,VLOOKUP($A$14,B21:D21,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B21:K21,$L$12)=1,VLOOKUP($A$14,B21:K21,$O$12)=1),1,0))","v":1},null,1,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B21:P21,$Q$12)=1,VLOOKUP($A$14,B21:P21,$U$12)=1),1,0))","v":1},null,null,null,null,null,1]
[]
[]
["Примечание:"]
["1. Желтые ячейки по умолчанию (согласно условию)"]
["2. Условие редактируется значения XYZ (голубые ячейки)"]
["3. Оранжевая ячейка - действие"]
[]
[]
["При составлении таблицы истинности используются следующие формулы:\n\nИнверсия: =ЕСЛИ(A2=1;0;1);\nДизъюнкция: =ЕСЛИ(ИЛИ(A2=1;B2=1);1;0);\nКонъюнкция: =ЕСЛИ(И(A2=1;B2=1);1;0);\nИмпликация: =ЕСЛИ(И(A2=1;B2=0);0;1);\nЭквивалентность: =ЕСЛИ(A2=B2;1;0)."]

{"sheet":"решение уравнения","index":2,"n_rows":30,"n_cols":34,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,20,7,24],[24,0,24,4],[25,0,25,4],[26,0,26,4],[29,0,35,4],[1,0,3,1],[1,2,1,4],[7,16,7,19]]}
[]
["условие",null,{"$f":"CONCATENATE(AA5,\"  \",AB5,\"  \",AC5,\"  \",AD5,\"  \",AE5,\" \",AF5,\"  \",AG5,\"  \",AH5)","v":"y  Λ  z  V  ¬ z  Λ  x"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"исходное","X","Λ","Y","V","¬","Y","Λ","Z"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","Λ","z","V","¬","z","Λ","x"]
[]
[null,{"$f":"AA5","v":"y"},{"$f":"AC5","v":"z"},{"$f":"AH5","v":"x"},null,null,{"$f":"E8","v":"¬ z"},null,null,null,{"$f":"H8","v":"y Λ z"},null,null,null,null,{"$f":"L8","v":"¬ z Λ x"},null,null,null,null,null,null,null,null,null,{"$f":"C2","v":"y  Λ  z  V  ¬ z  Λ  x"}]
[null,null,null,null,{"$f":"CONCATENATE(AE5,\" \",AF5)","v":"¬ z"},{"$f":"CutWords(E8)","v":"¬ z"},null,{"$f":"CONCATENATE(AA5,\" \",AB5,\" \",AC5)","v":"y Λ z"},{"$f":"CutWords(H8)","v":"y Λ z"},null,null,{"$f":"CONCATENATE(AE5,\" \",AF5,\" \",AG5,\" \",AH5)","v":"¬ z Λ x"},{"$f":"CutWords(L8)","v":"¬ z Λ x"},null,null,null,{"$f":"TRIM(Z7)","v":"y Λ z V ¬ z Λ x"},null,null,null,{"$f":"CutWords(Q8)","v":"y Λ z V ¬ z Λ x"}]
[null,null,null,null,1,2,null,1,2,3,null,1,2,3,4,null,1,2,3,4,5,6,7,8,9]
[null,null,null,null,{"$f":"SUBSTRING($F$8,\" \",E$9)","v":"¬"},{"$f":"SUBSTRING($F$8,\" \",F$9)","v":"z"},null,{"$f":"SUBSTRING($I$8,\" \",H$9)","v":"y"},{"$f":"SUBSTRING($I$8,\" \",I$9)","v":"Λ"},{"$f":"SUBSTRING($I$8,\" \",J$9)","v":"z"},null,{"$f":"SUBSTRING($M$8,\" \",L$9)","v":"¬"},{"$f":"SUBSTRING($M$8,\" \",M$9)","v":"z"},{"$f":"SUBSTRING($M$8,\" \",N$9)","v":"Λ"},{"$f":"SUBSTRING($M$8,\" \",O$9)","v":"x"},null,{"$f":"SUBSTRING($U$8,\" \",Q$9)","v":"y"},"Λ","z","V","¬","z","Λ","x",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(L10,\" \",M10)","v":"¬ z"},null,null,null,null,{"$f":"CONCATENATE(Q10,\" \",R10,\" \",S10)","v":"y Λ z"},null,null,null,{"$f":"CONCATENATE(U10,\" \",V10,\" \",W10,\" \",X10)","v":"¬ z Λ x"}]
[null,null,null,null,{"$f":"MATCH(F10,B7:G7,0)","v":2},null,null,{"$f":"MATCH(H10,$B$7:$G$7,0)","v":1},null,{"$f":"MATCH(J10,$B$7:$G$7,0)","v":2},null,{"$f":"MATCH(L11,$B$7:$G$7,0)","v":6},null,null,{"$f":"MATCH(O10,$B$7:$G$7,0)","v":3},null,{"$f":"MATCH(Q11,$B$7:$P$7,0)","v":10},null,null,null,{"$f":"MATCH(U11,$B$7:$P$7,0)","v":15}]
[null,null,null,null,{"$f":"MATCH(E10,Таблица1[обозначение],0)","v":5},null,null,null,{"$f":"MATCH(I10,Таблица1[обозначение],0)","v":1},null,null,null,null,{"$f":"MATCH(N10,Таблица1[обозначение],0)","v":1},null,null,null,null,null,{"$f":"MATCH(T10,Таблица1[обозначение],0)","v":2}]
[1,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",0,IF($B$7=\"Z\",0)))","v":0},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",0,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",0,IF($D$7=\"Z\",0)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B14:D14,$E$12)))","v":true},null,{"$f":"IF(E14=TRUE,1,0)","v":1},null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B14:D14,$H$12)=1,VLOOKUP($A$14,B14:D14,$J$12)=1),1,0))","v":0},null,{"$f":"I14","v":0},null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B14:K14,$L$12)=1,VLOOKUP($A$14,B14:K14,$O$12)=1),1,0))","v":0},null,{"$f":"N14","v":0},null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B14:P14,$Q$12)=1,VLOOKUP($A$14,B14:P14,$U$12)=1),1,0))","v":0},null,null,null,null,null,{"$f":"T14","v":0}]
[2,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",0,IF($B$7=\"Z\",1)))","v":0},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",0,IF($C$7=\"Z\",1)))","v":1},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",0,IF($D$7=\"Z\",1)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B15:D15,$E$12)))","v":false},null,{"$f":"IF(E15=TRUE,1,0)","v":0},null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B15:D15,$H$12)=1,VLOOKUP($A$14,B15:D15,$J$12)=1),1,0))","v":0},null,{"$f":"I15","v":0},null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B15:K15,$L$12)=1,VLOOKUP($A$14,B15:K15,$O$12)=1),1,0))","v":0},null,{"$f":"N15","v":0},null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B15:P15,$Q$12)=1,VLOOKUP($A$14,B15:P15,$U$12)=1),1,0))","v":0},null,null,null,null,null,0]
[3,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",1,IF($B$7=\"Z\",0)))","v":1},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",1,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",1,IF($D$7=\"Z\",0)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B16:D16,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B16:D16,$H$12)=1,VLOOKUP($A$14,B16:D16,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B16:K16,$L$12)=1,VLOOKUP($A$14,B16:K16,$O$12)=1),1,0))","v":0},null,0,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B16:P16,$Q$12)=1,VLOOKUP($A$14,B16:P16,$U$12)=1),1,0))","v":0},null,null,null,null,null,0,null,null,null,5,4,3,2,1]
[4,{"$f":"IF($B$7=\"X\",0,IF($B$7=\"Y\",1,IF($B$7=\"Z\",1)))","v":1},{"$f":"IF($C$7=\"X\",0,IF($C$7=\"Y\",1,IF($C$7=\"Z\",1)))","v":1},{"$f":"IF($D$7=\"X\",0,IF($D$7=\"Y\",1,IF($D$7=\"Z\",1)))","v":0},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B17:D17,$E$12)))","v":false},null,0,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B17:D17,$H$12)=1,VLOOKUP($A$14,B17:D17,$J$12)=1),1,0))","v":1},null,1,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B17:K17,$L$12)=1,VLOOKUP($A$14,B17:K17,$O$12)=1),1,0))","v":0},null,0,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B17:P17,$Q$12)=1,VLOOKUP($A$14,B17:P17,$U$12)=1),1,0))","v":1},null,null,null,null,null,1,null,null,null,{"$f":"условия!C23","v":"¬"},{"$f":"условия!G13","v":"→"},{"$f":"условия!B13","v":"Ξ"},{"$f":"условия!G3","v":"V"},{"$f":"условия!C3","v":"Λ"}]
[5,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",0,IF($B$7=\"Z\",0)))","v":0},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",0,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",0,IF($D$7=\"Z\",0)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B18:D18,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B18:D18,$H$12)=1,VLOOKUP($A$14,B18:D18,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B18:K18,$L$12)=1,VLOOKUP($A$14,B18:K18,$O$12)=1),1,0))","v":1},null,1,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B18:P18,$Q$12)=1,VLOOKUP($A$14,B18:P18,$U$12)=1),1,0))","v":1},null,null,null,null,null,1,null,null,null,{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP(A14,B14:D14,$E$12)))","v":true},null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B14:P14,$Q$12)=1,VLOOKUP($A$14,B14:P14,$U$12)=1),1,0))","v":0},{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP(A14,B14:D14,$H$12)=1,VLOOKUP(A14,B14:D14,$J$12)=1),1,0))","v":0}]
[6,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",0,IF($B$7=\"Z\",1)))","v":0},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",0,IF($C$7=\"Z\",1)))","v":1},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",0,IF($D$7=\"Z\",1)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B19:D19,$E$12)))","v":false},null,0,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B19:D19,$H$12)=1,VLOOKUP($A$14,B19:D19,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B19:K19,$L$12)=1,VLOOKUP($A$14,B19:K19,$O$12)=1),1,0))","v":0},null,0,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B19:P19,$Q$12)=1,VLOOKUP($A$14,B19:P19,$U$12)=1),1,0))","v":0},null,null,null,null,null,0]
[7,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",1,IF($B$7=\"Z\",0)))","v":1},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",1,IF($C$7=\"Z\",0)))","v":0},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",1,IF($D$7=\"Z\",0)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B20:D20,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B20:D20,$H$12)=1,VLOOKUP($A$14,B20:D20,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B20:K20,$L$12)=1,VLOOKUP($A$14,B20:K20,$O$12)=1),1,0))","v":1},null,1,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B20:P20,$Q$12)=1,VLOOKUP($A$14,B20:P20,$U$12)=1),1,0))","v":1},null,null,null,null,null,1]
[8,{"$f":"IF($B$7=\"X\",1,IF($B$7=\"Y\",1,IF($B$7=\"Z\",)))","v":1},{"$f":"IF($C$7=\"X\",1,IF($C$7=\"Y\",1,IF($C$7=\"Z\",)))","v":0},{"$f":"IF($D$7=\"X\",1,IF($D$7=\"Y\",1,IF($D$7=\"Z\",)))","v":1},{"$f":"IF($E$13=(MATCH($E$13,Таблица1[формула],0)),NOT(VLOOKUP($A$14,B21:D21,$E$12)))","v":true},null,1,null,{"$f":"IF($I$13=(MATCH($I$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B21:D21,$H$12)=1,VLOOKUP($A$14,B21:D21,$J$12)=1),1,0))","v":0},null,0,null,null,{"$f":"IF($N$13=(MATCH($N$13,Таблица1[формула],0)),IF(AND(VLOOKUP($A$14,B21:K21,$L$12)=1,VLOOKUP($A$14,B21:K21,$O$12)=1),1,0))","v":1},null,1,null,null,null,{"$f":"IF($T$13=(MATCH($T$13,Таблица1[формула],0)),IF(OR(VLOOKUP($A$14,B21:P21,$Q$12)=1,VLOOKUP($A$14,B21:P21,$U$12)=1),1,0))","v":1},null,null,null,null,null,1]
[]
[]
["Примечание:"]
["1. Желтые ячейки по умолчанию (согласно условию)"]
["2. Условие редактируется значения XYZ (голубые ячейки)"]
["3. Оранжевая ячейка - действие"]
[]
[]
["При составлении таблицы истинности используются следующие формулы:\n\nИнверсия: =ЕСЛИ(A2=1;0;1);\nДизъюнкция: =ЕСЛИ(ИЛИ(A2=1;B2=1);1;0);\nКонъюнкция: =ЕСЛИ(И(A2=1;B2=1);1;0);\nИмпликация: =ЕСЛИ(И(A2=1;B2=0);0;1);\nЭквивалентность: =ЕСЛИ(A2=B2;1;0)."]