{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Указатель","11-(0.5)","11-(1)","11-(2)","11-(3)","11-(4)","11-(5)","11-(6)","11-(7)","11-(7.2)","11-(7.4)","11-(8)","11-(9)","11-(10)","11-(11)","11-(13)","11-(15)","11-(16)","11-(17)","11-(18)","11-(19)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":0,"pivot_tables":1},"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":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Указатель листов"]
["11-(0.5)"]
["11-(1)"]
["11-(2)"]
["11-(3)"]
["11-(4)"]
["11-(5)"]
["11-(6)"]
["11-(7)"]
["11-(7.2)"]
["11-(7.4)"]
["11-(8)"]
["11-(9)"]
["11-(10)"]
["11-(11)"]
["11-(13)"]
["11-(15)"]
["11-(16)"]
["11-(17)"]
["11-(18)"]
["11-(19)"]

{"sheet":"11-(0.5)","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,4],[6,0,6,4],[12,0,12,6],[22,0,22,6]]}
["Назад к указателю"]
[true,true,null,{"$f":"A2&\"*\"&B2&\" = \"&--A2&\"*\"&--B2&\" = \"&A2*B2&\" = \"&AND(A2*B2)","v":"ИСТИНА*ИСТИНА = 1*1 = 1 = ИСТИНА"}]
[false,true,null,{"$f":"A3&\"*\"&B3&\" = \"&--A3&\"*\"&--B3&\" = \"&A3*B3&\" = \"&AND(A3*B3)","v":"ЛОЖЬ*ИСТИНА = 0*1 = 0 = ЛОЖЬ"}]
[true,false,null,{"$f":"A4&\"*\"&B4&\" = \"&--A4&\"*\"&--B4&\" = \"&A4*B4&\" = \"&AND(A4*B4)","v":"ИСТИНА*ЛОЖЬ = 1*0 = 0 = ЛОЖЬ"}]
[false,false,null,{"$f":"A5&\"*\"&B5&\" = \"&--A5&\"*\"&--B5&\" = \"&A5*B5&\" = \"&AND(A5*B5)","v":"ЛОЖЬ*ЛОЖЬ = 0*0 = 0 = ЛОЖЬ"}]
[]
["ИЛИ критерий = по крайней мере одна логическая переменная принимает значение ИСТИНА = сложение"]
[true,true,null,{"$f":"A8&\"+\"&B8&\" = \"&--A8&\"+\"&--B8&\" = \"&A8+B8&\" = \"&OR(A8+B8)","v":"ИСТИНА+ИСТИНА = 1+1 = 2 = ИСТИНА"}]
[false,true,null,{"$f":"A9&\"+\"&B9&\" = \"&--A9&\"+\"&--B9&\" = \"&A9+B9&\" = \"&OR(A9+B9)","v":"ЛОЖЬ+ИСТИНА = 0+1 = 1 = ИСТИНА"}]
[true,false,null,{"$f":"A10&\"+\"&B10&\" = \"&--A10&\"+\"&--B10&\" = \"&A10+B10&\" = \"&OR(A10+B10)","v":"ИСТИНА+ЛОЖЬ = 1+0 = 1 = ИСТИНА"}]
[false,false,null,{"$f":"A11&\"+\"&B11&\" = \"&--A11&\"+\"&--B11&\" = \"&A11+B11&\" = \"&OR(A11+B11)","v":"ЛОЖЬ+ЛОЖЬ = 0+0 = 0 = ЛОЖЬ"}]
[]
["И критерий = все логические переменные принимают значение ИСТИНА = умножение"]
[true,true,true,null,{"$f":"A14&\"*\"&B14&\"*\"&C14&\" = \"&--A14&\"*\"&--B14&\"*\"&--C14&\" = \"&A14*B14*C14&\" = \"&AND(A14*B14*C14)","v":"ИСТИНА*ИСТИНА*ИСТИНА = 1*1*1 = 1 = ИСТИНА"}]
[false,true,true,null,"ЛОЖЬ*ИСТИНА*ИСТИНА = 0*1*1 = 0 = ЛОЖЬ"]
[true,false,true,null,"ИСТИНА*ЛОЖЬ*ИСТИНА = 1*0*1 = 0 = ЛОЖЬ"]
[true,true,false,null,"ИСТИНА*ИСТИНА*ЛОЖЬ = 1*1*0 = 0 = ЛОЖЬ"]
[true,false,false,null,"ИСТИНА*ЛОЖЬ*ЛОЖЬ = 1*0*0 = 0 = ЛОЖЬ"]
[false,true,false,null,"ЛОЖЬ*ИСТИНА*ЛОЖЬ = 0*1*0 = 0 = ЛОЖЬ"]
[false,false,true,null,"ЛОЖЬ*ЛОЖЬ*ИСТИНА = 0*0*1 = 0 = ЛОЖЬ"]
[false,false,false,null,"ЛОЖЬ*ЛОЖЬ*ЛОЖЬ = 0*0*0 = 0 = ЛОЖЬ"]
[]
["ИЛИ критерий = по крайней мере одна логическая переменная принимает значение ИСТИНА = сложение"]
[true,true,true,null,{"$f":"A24&\"+\"&B24&\"+\"&C24&\" = \"&--A24&\"+\"&--B24&\"+\"&--C24&\" = \"&A24+B24+C24&\" = \"&OR(A24+B24+C24)","v":"ИСТИНА+ИСТИНА+ИСТИНА = 1+1+1 = 3 = ИСТИНА"}]
[false,true,true,null,{"$f":"A25&\"+\"&B25&\"+\"&C25&\" = \"&--A25&\"+\"&--B25&\"+\"&--C25&\" = \"&A25+B25+C25&\" = \"&OR(A25+B25+C25)","v":"ЛОЖЬ+ИСТИНА+ИСТИНА = 0+1+1 = 2 = ИСТИНА"}]
[true,false,true,null,"ИСТИНА+ЛОЖЬ+ИСТИНА = 1+0+1 = 2 = ИСТИНА"]
[true,true,false,null,"ИСТИНА+ИСТИНА+ЛОЖЬ = 1+1+0 = 2 = ИСТИНА"]
[true,false,false,null,"ИСТИНА+ЛОЖЬ+ЛОЖЬ = 1+0+0 = 1 = ИСТИНА"]
[false,true,false,null,"ЛОЖЬ+ИСТИНА+ЛОЖЬ = 0+1+0 = 1 = ИСТИНА"]
[false,false,true,null,"ЛОЖЬ+ЛОЖЬ+ИСТИНА = 0+0+1 = 1 = ИСТИНА"]
[false,false,false,null,"ЛОЖЬ+ЛОЖЬ+ЛОЖЬ = 0+0+0 = 0 = ЛОЖЬ"]

{"sheet":"11-(1)","index":2,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[7,0,7,3],[7,5,7,8],[17,3,17,8]]}
["Назад к указателю","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1290]
["2013-03-06","Kia","Chin",955]
["2013-03-05","Toyota","Tom",2051]
["2013-03-05","Toyota","Tom",489]
["2013-03-06","Toyota","Meg",219]
[]
["Критерии:",null,null,null,null,"Критерии для функций базы данных"]
["Дата","Авто","Механик","Цена",null,"Дата","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1000,null,"2013-03-05","Toyota","Tom",">1000"]
[]
["Количество",{"$f":"COUNTIFS(A2:A6,A10,B2:B6,B10,C2:C6,C10,D2:D6,\">\"&D10)","v":2},"[1]","=СЧЁТЕСЛИМН(A2:A6;A10;B2:B6;B10;C2:C6;C10;D2:D6;\">\"&D10)"]
["Сумма",{"$f":"SUMIFS(D2:D6,A2:A6,A10,B2:B6,B10,C2:C6,C10,D2:D6,\">\"&D10)","v":3341},"[2]","=СУММЕСЛИМН(D2:D6;A2:A6;A10;B2:B6;B10;C2:C6;C10;D2:D6;\">\"&D10)"]
["Среднее",{"$f":"AVERAGEIFS(D2:D6,A2:A6,A10,B2:B6,B10,C2:C6,C10,D2:D6,\">\"&D10)","v":1670.5},"[3]","=СРЗНАЧЕСЛИМН(D2:D6;A2:A6;A10;B2:B6;B10;C2:C6;C10;D2:D6;\">\"&D10)"]
["Максимум",{"$f":"DMAX(A1:D6,D1,F9:I10)","v":2051},"[4]","=ДМАКС(A1:D6;D1;F9:I10)"]
["Количество",{"$f":"SUMPRODUCT(--(A2:A6=A10),--(B2:B6=B10),--(C2:C6=C10),--(D2:D6>D10))","v":2},"[5]","=СУММПРОИЗВ(--(A2:A6=A10);--(B2:B6=B10);--(C2:C6=C10);--(D2:D6>D10))"]
["Минимум",{"$f":"_xlfn.AGGREGATE(15,6,D2:D6/((A2:A6=A10)*(B2:B6=B10)*(C2:C6=C10)*(D2:D6>D10)),1)","v":1290},"[6]","=АГРЕГАТ(15;6;D2:D6/((A2:A6=A10)*(B2:B6=B10)*(C2:C6=C10)*(D2:D6>D10));1)"]
["Стандартное отклонение",{"$f":"_xlfn.STDEV.S(IF(A2:A6=A10,IF(B2:B6=B10,IF(C2:C6=C10,IF(D2:D6>D10,D2:D6)))))","v":538.10826048296269},"[7]","{=СТАНДОТКЛОН.В(ЕСЛИ(A2:A6=A10;ЕСЛИ(B2:B6=B10;\nЕСЛИ(C2:C6=C10;ЕСЛИ(D2:D6>D10;D2:D6)))))}"]

{"sheet":"11-(2)","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1290,null,"Дата","2013-03-05"]
["2013-03-06","Kia","Chin",955,null,"Механик","Tom"]
["2013-03-05","Toyota","Tom",2051,null,"Авто","Toyota"]
["2013-03-05","Toyota","Tom",489]
["2013-03-06","Toyota","Meg",219,null,"Цена","Сумма"]
[null,null,null,null,null,1290,1290]
[null,null,null,null,null,2051,2051]
[null,null,null,null,null,"Общий итог",3341]

{"sheet":"11-(3)","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1290]
["2013-03-06","Kia","Chin",955]
["2013-03-05","Toyota","Tom",2051]
["2013-03-05","Toyota","Tom",489]
["2013-03-06","Toyota","Meg",219]
["Итог",null,null,{"$f":"SUBTOTAL(101,Таблица2[Цена])","v":1670.5}]

{"sheet":"11-(4)","index":5,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1290]
["2013-03-06","Kia","Chin",955]
["2013-03-05","Toyota","Tom",2051]
["2013-03-05","Toyota","Tom",489]
["2013-03-06","Toyota","Meg",219]

{"sheet":"11-(5)","index":6,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю"]
["Дата","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",">1000"]
[]
["Дата","Авто","Механик","Цена",null,"Выборка:"]
["2013-03-05","Toyota","Tom",1290,null,"Дата","Авто","Механик","Цена"]
["2013-03-06","Kia","Chin",955,null,"2013-03-05","Toyota","Tom",1290]
["2013-03-05","Toyota","Tom",2051,null,"2013-03-05","Toyota","Tom",2051]
["2013-03-05","Toyota","Tom",489]
["2013-03-06","Toyota","Meg",219]

{"sheet":"11-(6)","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Авто","Механик","Цена","Вспомогательная"]
["2013-03-05","Toyota","Tom",1290,{"$f":"AND(A2=$A$10,B2=$B$10,C2=$C$10,D2>=$D$10)","v":true},"=И(A2=$A$10;B2=$B$10;C2=$C$10;D2>=$D$10)"]
["2013-03-06","Kia","Chin",955,{"$f":"AND(A3=$A$10,B3=$B$10,C3=$C$10,D3>=$D$10)","v":false},"=И(A3=$A$10;B3=$B$10;C3=$C$10;D3>=$D$10)"]
["2013-03-05","Toyota","Tom",2051,{"$f":"AND(A4=$A$10,B4=$B$10,C4=$C$10,D4>=$D$10)","v":true},"=И(A4=$A$10;B4=$B$10;C4=$C$10;D4>=$D$10)"]
["2013-03-05","Toyota","Tom",489,{"$f":"AND(A5=$A$10,B5=$B$10,C5=$C$10,D5>=$D$10)","v":false},"=И(A5=$A$10;B5=$B$10;C5=$C$10;D5>=$D$10)"]
["2013-03-06","Toyota","Meg",219,{"$f":"AND(A6=$A$10,B6=$B$10,C6=$C$10,D6>=$D$10)","v":false},"=И(A6=$A$10;B6=$B$10;C6=$C$10;D6>=$D$10)"]
[]
["Критерии:"]
["Дата","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1000]
[]
["Счет",{"$f":"COUNTIF(E2:E6,TRUE)","v":2},"=СЧЁТЕСЛИ(E2:E6;ИСТИНА)"]

{"sheet":"11-(7)","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Авто","Механик","Цена","Вспомогательная"]
["2013-03-05","Toyota","Tom",1290,{"$f":"(A2=$A$10)*(B2=$B$10)*(C2=$C$10)*(D2>=$D$10)","v":1},"=(A2=$A$10)*(B2=$B$10)*(C2=$C$10)*(D2>=$D$10)"]
["2013-03-06","Kia","Chin",955,{"$f":"(A3=$A$10)*(B3=$B$10)*(C3=$C$10)*(D3>=$D$10)","v":0},"=(A3=$A$10)*(B3=$B$10)*(C3=$C$10)*(D3>=$D$10)"]
["2013-03-05","Toyota","Tom",2051,{"$f":"(A4=$A$10)*(B4=$B$10)*(C4=$C$10)*(D4>=$D$10)","v":1},"=(A4=$A$10)*(B4=$B$10)*(C4=$C$10)*(D4>=$D$10)"]
["2013-03-05","Toyota","Tom",489,{"$f":"(A5=$A$10)*(B5=$B$10)*(C5=$C$10)*(D5>=$D$10)","v":0},"=(A5=$A$10)*(B5=$B$10)*(C5=$C$10)*(D5>=$D$10)"]
["2013-03-06","Toyota","Meg",219,{"$f":"(A6=$A$10)*(B6=$B$10)*(C6=$C$10)*(D6>=$D$10)","v":0},"=(A6=$A$10)*(B6=$B$10)*(C6=$C$10)*(D6>=$D$10)"]
[]
["Критерии:"]
["Дата","Авто","Механик","Цена"]
["2013-03-05","Toyota","Tom",1000]
[]
["Счет",{"$f":"SUM(E2:E6)","v":2},"=СУММ(E2:E6)"]

{"sheet":"11-(7.2)","index":9,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю"]
[null,"Цель формулы"]
[null,"Подсчет записей в наборе данных, которые удовлетворяют всем четырем критериям"]
[null,"Шаги расчета:"]
[null,"1. =СУММПРОИЗВ(--(A2:A6=A10);--(B2:B6=B10);--(C2:C6=C10);--(D2:D6>D10))"]
[null,"Круглые скобки требуют первоочередного расчета операторов сравнения"]
[null,"2. =СУММПРОИЗВ(--({ИСТИНА:ЛОЖЬ:ИСТИНА:ИСТИНА:ЛОЖЬ});\n--({ИСТИНА:ЛОЖЬ:ИСТИНА:ИСТИНА:ИСТИНА});\n--({ИСТИНА:ЛОЖЬ:ИСТИНА:ИСТИНА:ЛОЖЬ});\n--({ИСТИНА:ЛОЖЬ:ИСТИНА:ЛОЖЬ:ЛОЖЬ}))"]
[null,"Так как функция СУММПРОИЗВ не может \"увидеть\" значения ИСТИНА и ЛОЖЬ, вы должны использовать математические операции, например, двойное отрицание для преобразования логических значений в числа"]
[null,"3. =СУММПРОИЗВ({1:0:1:1:0};{1:0:1:1:1};{1:0:1:1:0};{1:0:1:0:0})"]
[null,"4. =SUM({1;0;1;1;0}*{1;0;1;1;1}*{1;0;1;1;0}*{1;0;1;0;0})"]
[null,"Последовательно перемножаются сначала первые элементы каждого массива, затем вторые и т.д."]
[null,"1 * 1 * 1 * 1 = 1"]
[null,"0 * 0 * 0 * 0 = 0"]
[null,"1 * 1 * 1 * 1 = 1"]
[null,"1 * 1 * 1 * 0 = 0"]
[null,"0 * 1 * 0 * 0 = 0"]
[null,"5. =SUM({1;0;1;0;0})"]
[null,"Только когда все четыре соответствующих элемента массива равны единице: 1 * 1 * 1 * 1 = 1, вы получаете 1 в результате"]
[null,"6. Формула возвращает одно значение - 2"]
[null,"Основная концепция:"]
[null,"Результирующий массив {1;0;1;0;0} состоит из нулей и единиц. Поскольку вы просто подсчитываете количество, нули не влияют на результат. Нулевые значения используются для фильтрации (отбора) значений. Вы используете СУММПРОИЗВ вместо СУММ, чтобы не нажимать Ctrl+Shift+Enter"]

{"sheet":"11-(7.4)","index":10,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю"]
[null,"Цель формулы"]
[null,"Найти минимальное значение на основании четырех критериев"]
[null,"Шаги расчета:"]
[null,"1. =АГРЕГАТ(15;6;D2:D6/((A2:A6=A10)*(B2:B6=B10)*(C2:C6=C10)*(D2:D6>D10));1)"]
[null,"Значение 15 в аргументе номер_функции соответствует функции НАИМЕНЬШИЙ. Значение 6 в аргументе параметры указывает пропускать значения ошибок. Значение 1 в k-параметре сообщает функции НАИМЕНЬШИЙ искать минимальное значение в массиве. Круглые скобки требуют первоочередного расчета операторов сравнения"]
[null,"2. =АГРЕГАТ(15;6;D2:D6/(({ИСТИНА:ЛОЖЬ:ИСТИНА:ИСТИНА:ЛОЖЬ})*\n({ИСТИНА:ЛОЖЬ:ИСТИНА:ИСТИНА:ИСТИНА})*\n({ИСТИНА:ЛОЖЬ:ИСТИНА:ИСТИНА:ЛОЖЬ})*\n({ИСТИНА:ЛОЖЬ:ИСТИНА:ЛОЖЬ:ЛОЖЬ}));1)"]
[null,"В знаменателе выполняется умножение четыре логических массивов. Операция умножения будет преобразовывать логические значения в единицы и нули:"]
[null,"ИСТИНА * ИСТИНА * ИСТИНА * ИСТИНА = 1"]
[null,"ЛОЖЬ * ЛОЖЬ * ЛОЖЬ * ЛОЖЬ = 0"]
[null,"ИСТИНА * ИСТИНА * ИСТИНА * ИСТИНА = 1"]
[null,"ИСТИНА * ИСТИНА * ИСТИНА * ЛОЖЬ = 0"]
[null,"ЛОЖЬ * ИСТИНА * ЛОЖЬ * ЛОЖЬ = 0"]
[null,"3. =АГРЕГАТ(15;6;D2:D6/{1:0:1:0:0};1)"]
[null,"Только когда все четыре соответствующих элемента массива равны единице: ИСТИНА * ИСТИНА * ИСТИНА * ИСТИНА = 1, вы получаете 1 в результате"]
[null,"4. =АГРЕГАТ(15;6;{1290:955:2051:489:219}/{1:0:1:0:0};1)"]
[null,"На этой стадии обработки И критерия вы не используете умножение, потому что если вы это сделаете, минимальная стоимость будет равна нулю, что приведет к неверному ответу. В качестве логического математического оператора используется деление, так что деление на ноль приведет к ошибке #ДЕЛ/0!. А опция 6 функции АГРЕГАТ позволит проигнорировать эти ошибки. Итак, если вы используете произведение, вы получите:"]
[null,"{1290:955:2051:489:219}*{1:0:1:0:0}={1290:0:2051:0:0} и минимальное значение 0"]
[null,"Если вы используете деление, вы получите:"]
[null,"{1290:955:2051:489:219}/{1:0:1:0:0}={1290:#ДЕЛ/0!:2051:#ДЕЛ/0!:#ДЕЛ/0!}"]
[null,"Это - ключ к расчету: использование деления приводит к ошибке в результирующем массиве, и с помощью опции 6 в аргументе функции АГРЕГАТ эти значения фильтруются и не идут в расчет минимального значения"]
[null,"5. =АГРЕГАТ(15;6;{1290:#ДЕЛ/0!:2051:#ДЕЛ/0!:#ДЕЛ/0!};1)"]
[null,"Вы отобрали (отфильтровали) \"правильные\" значения благодаря логическому умножению и делению."]
[null,"6. Формула возвращает одно значение: 1290"]
[null,"Основная концепция:"]
[null,"Результирующий массив {1290:#ДЕЛ/0!:2051:#ДЕЛ/0!:#ДЕЛ/0!} заполняется числами и значениями ошибок. Ошибки служат фильтром, позволяющим добавить в расчет только нужные числа. Вы используете функцию АГРЕГАТ вместо МИН с четырьмя ЕСЛИ, чтобы не нажимать Ctrl+Shift+Enter."]

{"sheet":"11-(8)","index":11,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю",{"$f":"$E$2&\" or \"&$E$3&\"?\"","v":"Gidget or Rodger?"},null,null,"Менеджер"]
["Gidget",{"$f":"(A2=$E$2)+(A2=$E$3)","v":1},"=(A2=$E$2)+(A2=$E$3)=ИСТИНА+ЛОЖЬ=ИСТИНА=1",null,"Gidget"]
["Rodger",{"$f":"(A3=$E$2)+(A3=$E$3)","v":1},"=(A3=$E$2)+(A3=$E$3)=ЛОЖЬ+ИСТИНА=ИСТИНА=1",null,"Rodger"]
["Davis",{"$f":"(A4=$E$2)+(A4=$E$3)","v":0},"=(A4=$E$2)+(A4=$E$3)=ЛОЖЬ+ЛОЖЬ=ЛОЖЬ=0"]
["Rodger",{"$f":"(A5=$E$2)+(A5=$E$3)","v":1},"=(A5=$E$2)+(A5=$E$3)=ЛОЖЬ+ИСТИНА=ИСТИНА=1"]
["Bernardina",{"$f":"(A6=$E$2)+(A6=$E$3)","v":0},"=(A6=$E$2)+(A6=$E$3)=ЛОЖЬ+ЛОЖЬ=ЛОЖЬ=0"]

{"sheet":"11-(9)","index":12,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Чистые активы","Кредитный рейтинг","Предоставить кредит?",null,null,"ИЛИ критерии:"]
["J.K. LLC",85024,4,{"$f":"(B2>$G$3)+(C2>=$G$5)","v":1},"=(B2>$G$3)+(C2>=$G$5)=ЛОЖЬ+ИСТИНА=ИСТИНА=1",null,"Чистые активы"]
["Fruits Inc.",111104,3.5,{"$f":"(B3>$G$3)+(C3>=$G$5)","v":2},"=(B3>$G$3)+(C3>=$G$5)=ИСТИНА+ИСТИНА=ИСТИНА=2",null,100000]
["SW",89236,2.4,{"$f":"(B4>$G$3)+(C4>=$G$5)","v":0},"=(B4>$G$3)+(C4>=$G$5)=ЛОЖЬ+ЛОЖЬ=ЛОЖЬ=0",null,"Кредитный рейтинг"]
["PCC",113212,3,{"$f":"(B5>$G$3)+(C5>=$G$5)","v":1},"=(B5>$G$3)+(C5>=$G$5)=ИСТИНА+ЛОЖЬ=ИСТИНА=1",null,3.5]
["Gigi's Inc.",100000,1.4,{"$f":"(B6>$G$3)+(C6>=$G$5)","v":0},"=(B6>$G$3)+(C6>=$G$5)=ЛОЖЬ+ЛОЖЬ=ЛОЖЬ=0"]

{"sheet":"11-(10)","index":13,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю",null,"Менеджер"]
["Gidget",null,"Gidget"]
["Rodger",null,"Rodger"]
["Davis"]
["Rodger"]
["Bernardina"]
[]
["Счет",{"$f":"COUNTIF(A2:A6,C2)+COUNTIF(A2:A6,C3)","v":3}," < Формула [1] =СЧЁТЕСЛИ(A2:A6;C2)+СЧЁТЕСЛИ(A2:A6;C3)"]
["Счет",{"$f":"DCOUNTA(A1:A6,A1,C1:C3)","v":0}," < Формула [2] =БСЧЁТА(A1:A6;A1;C1:C3)"]
["Счет",{"$f":"SUMPRODUCT((A2:A6=C2)+(A2:A6=C3))","v":3}," < Формула [3] =СУММПРОИЗВ((A2:A6=C2)+(A2:A6=C3))"]
["Счет",{"$f":"SUM(IF((A2:A6=C2)+(A2:A6=C3),1))","v":3}," < Формула [4] {=СУММ(ЕСЛИ((A2:A6=C2)+(A2:A6=C3);1))}"]
["Счет",{"$f":"SUMPRODUCT(--ISNUMBER(MATCH(A2:A6,C2:C3,0)))","v":3}," < Формула [5] =СУММПРОИЗВ(--ЕЧИСЛО(ПОИСКПОЗ(A2:A6;C2:C3;0)))"]
[]
[null,null,"Менеджер","Менеджер"]
[null,null,"Gidget","Rodger"]

{"sheet":"11-(11)","index":14,"n_rows":518,"n_cols":4,"rows_kept":518,"cut":false,"hidden":false,"merged":[[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4]]}
["Назад к указателю"]
["Счет",{"$f":"COUNTIF(B9:B518,D11)+COUNTIF(B9:B518,D12)+COUNTIF(B9:B518,D13)+COUNTIF(B9:B518,D14)+COUNTIF(B9:B518,D15)+COUNTIF(B9:B518,D16)","v":68},"[1]_=СЧЁТЕСЛИ(B9:B518;D11)+СЧЁТЕСЛИ(B9:B518;D12)+СЧЁТЕСЛИ(B9:B518;D13)+СЧЁТЕСЛИ(B9:B518;D14)+СЧЁТЕСЛИ(B9:B518;D15)+СЧЁТЕСЛИ(B9:B518;D16)"]
["Счет",{"$f":"DCOUNTA(B8:B518,B8,D10:D16)","v":68},"[2]_=БСЧЁТА(B8:B518;B8;D10:D16)"]
["Счет",{"$f":"SUMPRODUCT((B9:B518=D11)+(B9:B518=D12)+(B9:B518=D13)+(B9:B518=D14)+(B9:B518=D15)+(B9:B518=D16))","v":68},"[3]_=СУММПРОИЗВ((B9:B518=D11)+(B9:B518=D12)+(B9:B518=D13)+(B9:B518=D14)+(B9:B518=D15)+(B9:B518=D16))"]
["Счет",{"$f":"SUM(IF((B9:B518=D11)+(B9:B518=D12)+(B9:B518=D13)+(B9:B518=D14)+(B9:B518=D15)+(B9:B518=D16),1))","v":68},"[4]_{=СУММ(ЕСЛИ((B9:B518=D11)+(B9:B518=D12)+(B9:B518=D13)+(B9:B518=D14)+(B9:B518=D15)+(B9:B518=D16);1))}"]
["Счет",{"$f":"SUMPRODUCT(--ISNUMBER(MATCH(B9:B518,D11:D16,0)))","v":68},"[5]_=СУММПРОИЗВ(--ЕЧИСЛО(ПОИСКПОЗ(B9:B518;D11:D16;0)))"]
[]
["Дата звонков","Менеджеры",null,"Критерии ИЛИ"]
["2013-10-18","Davis Wolford",null,"Группа 1"]
["2013-10-06","Bernardina Free",null,"Менеджеры"]
["2013-10-19","Bernardina Free",null,"Gidget Marlow"]
["2013-10-20","Celesta Granger",null,"Rodger Riddle"]
["2013-10-13","Nana Hathaway",null,"Kym Handy"]
["2013-10-18","Nana Hathaway",null,"Zulma Farrell"]
["2013-11-20","Yulanda Casillas",null,"Edgardo Dalton"]
["2013-10-26","Gema Tapia",null,"Jama Monk"]
["2013-10-18","Maricela Hostetler"]
["2013-10-09","Angelic Mcnair"]
["2013-11-22","Zulma Farrell"]
["2013-11-03","Annamae Varney"]
["2013-10-10","Gema Tapia"]
["2013-11-18","Lizzie Stinson"]
["2013-10-18","Normand Mcghee"]
["2013-10-19","Mammie Ogle"]
["2013-11-02","Rodger Riddle"]
["2013-10-14","Davis Wolford"]
["2013-11-01","Malena Caudle"]
["2013-11-13","Davis Wolford"]
["2013-10-24","Inge Seiler"]
["2013-10-27","Yulanda Casillas"]
["2013-11-13","Dusty Pointer"]
["2013-10-13","Leo Sigler"]
["2013-11-11","Rhea Furr"]
["2013-10-18","Lizzie Stinson"]
["2013-10-07","Lizzie Stinson"]
["2013-11-20","Emory Stubblefield"]
["2013-10-29","Lucienne Chatman"]
["2013-10-31","Henriette Shell"]
["2013-10-17","Emory Stubblefield"]
["2013-11-03","Elfriede Maupin"]
["2013-10-20","Shantel Fennell"]
["2013-10-10","Celesta Granger"]
["2013-10-08","Floretta Dozier"]
["2013-11-09","Jack Koontz"]
["2013-11-05","Emory Stubblefield"]
["2013-11-18","Wynona Folse"]
["2013-11-15","Rhea Furr"]
["2013-11-20","Wynona Folse"]
["2013-10-14","Henriette Shell"]
["2013-11-11","Adena Villa"]
["2013-11-18","Zulma Farrell"]
["2013-10-05","Corrinne Greathouse"]
["2013-10-27","Colene Garland"]
["2013-11-07","Angelic Mcnair"]
["2013-11-22","Lucienne Chatman"]
["2013-11-02","Zulma Farrell"]
["2013-11-08","Yulanda Casillas"]
["2013-10-18","Gema Tapia"]
["2013-11-04","Lucienne Chatman"]
["2013-10-14","Inge Seiler"]
["2013-10-24","Davis Wolford"]
["2013-11-11","Colene Garland"]
["2013-11-06","Maryrose Clawson"]
["2013-11-12","Annamae Varney"]
["2013-11-01","Monte Maloney"]
["2013-11-20","Edgardo Dalton"]
["2013-11-01","Bernardina Free"]
["2013-10-16","Fidelia Clifton"]
["2013-10-12","Eleonora Redmond"]
["2013-10-11","Annamae Varney"]
["2013-10-28","Jack Koontz"]
["2013-10-21","Edgardo Dalton"]
["2013-11-14","Floretta Dozier"]
["2013-11-16","Laurine Bullard"]
["2013-10-31","Rodger Riddle"]
["2013-11-06","Normand Mcghee"]
["2013-10-18","Maricela Hostetler"]
["2013-10-28","Deloris Musgrove"]
["2013-11-12","Gidget Marlow"]
["2013-10-22","Nana Hathaway"]
["2013-10-16","Emory Stubblefield"]
["2013-11-16","Yulanda Casillas"]
["2013-11-09","Adena Villa"]
["2013-10-21","Inge Seiler"]
["2013-11-05","Kym Handy"]
["2013-10-20","Monte Maloney"]
["2013-10-17","Lura Maes"]
["2013-11-01","Ethelene Contreras"]
["2013-10-23","Gidget Marlow"]
["2013-10-18","Lizzie Stinson"]
["2013-10-20","Maryrose Clawson"]
["2013-10-17","Bernardina Free"]
["2013-11-10","Wynona Folse"]
["2013-11-18","Malena Caudle"]
["2013-10-29","Emory Stubblefield"]
["2013-10-23","Dusty Pointer"]
["2013-10-25","Laurine Bullard"]
["2013-10-04","Shantel Fennell"]
["2013-10-04","Colene Garland"]
["2013-11-04","Silas Barksdale"]
["2013-10-05","Susy Olivo"]
["2013-11-03","Shantel Fennell"]
["2013-10-10","Dusty Pointer"]
["2013-10-11","Laurine Bullard"]
["2013-10-13","Henriette Shell"]
["2013-10-06","Maryrose Clawson"]
["2013-10-16","Jama Monk"]
["2013-11-14","Lavonne Raines"]
["2013-10-24","Nana Hathaway"]
["2013-10-26","Yulanda Casillas"]
["2013-10-28","Henriette Shell"]
["2013-11-14","Fidelia Clifton"]
["2013-10-08","Henriette Shell"]
["2013-10-10","Deloris Musgrove"]
["2013-10-22","Angelic Mcnair"]
["2013-10-22","Nana Hathaway"]
["2013-10-29","Annamae Varney"]
["2013-11-22","Bernardina Free"]
["2013-11-20","Maryrose Clawson"]
["2013-10-16","Deloris Musgrove"]
["2013-11-03","Davis Wolford"]
["2013-10-10","Laurine Bullard"]
["2013-11-02","Jama Monk"]
["2013-10-26","Inge Seiler"]
["2013-10-10","Eleonora Redmond"]
["2013-11-20","Floretta Dozier"]
["2013-10-21","Dudley Gunderson"]
["2013-10-31","Inge Seiler"]
["2013-10-16","Rhea Furr"]
["2013-10-21","Ardell Song"]
["2013-11-21","Monte Maloney"]
["2013-10-10","Fidelia Clifton"]
["2013-10-23","Eleonora Redmond"]
["2013-11-10","Inge Seiler"]
["2013-10-16","Edgardo Dalton"]
["2013-10-14","Mammie Ogle"]
["2013-11-01","Celesta Granger"]
["2013-10-19","Henriette Shell"]
["2013-10-15","Gema Tapia"]
["2013-10-08","Wynona Folse"]
["2013-10-12","Gidget Marlow"]
["2013-11-16","Silas Barksdale"]
["2013-11-12","Elfriede Maupin"]
["2013-11-07","Lizzie Stinson"]
["2013-10-14","Shantel Fennell"]
["2013-10-17","Kym Handy"]
["2013-10-14","Jama Monk"]
["2013-10-11","Shantel Fennell"]
["2013-11-09","Lucienne Chatman"]
["2013-10-23","Leo Sigler"]
["2013-11-12","Lucienne Chatman"]
["2013-11-22","Lizzie Stinson"]
["2013-11-18","Rodger Riddle"]
["2013-11-10","Gidget Marlow"]
["2013-10-05","Elfriede Maupin"]
["2013-11-22","Inge Seiler"]
["2013-10-17","Monte Maloney"]
["2013-10-19","Ardelle Covey"]
["2013-10-23","Fidelia Clifton"]
["2013-10-28","Henriette Shell"]
["2013-11-15","Gidget Marlow"]
["2013-10-20","Leo Sigler"]
["2013-11-01","Jack Koontz"]
["2013-10-03","Laurine Bullard"]
["2013-11-07","Rodger Riddle"]
["2013-10-14","Maricela Hostetler"]
["2013-10-07","Rodger Riddle"]
["2013-11-09","Mammie Ogle"]
["2013-11-01","Colene Garland"]
["2013-10-16","Leo Sigler"]
["2013-10-29","Ardell Song"]
["2013-11-08","Lucienne Chatman"]
["2013-10-07","Malena Caudle"]
["2013-10-27","Lizzie Stinson"]
["2013-11-14","Malena Caudle"]
["2013-11-07","Lavonne Raines"]
["2013-10-30","Eleonora Redmond"]
["2013-11-11","Malena Caudle"]
["2013-11-04","Elfriede Maupin"]
["2013-10-28","Jack Koontz"]
["2013-11-21","Elfriede Maupin"]
["2013-10-05","Adena Villa"]
["2013-10-20","Davis Wolford"]
["2013-10-08","Kym Handy"]
["2013-10-26","Ardelle Covey"]
["2013-11-21","Lura Maes"]
["2013-11-18","Kym Handy"]
["2013-10-21","Eleonora Redmond"]
["2013-10-05","Elfriede Maupin"]
["2013-10-18","Edgardo Dalton"]
["2013-11-15","Yulanda Casillas"]
["2013-11-10","Jama Monk"]
["2013-10-28","Lavonne Raines"]
["2013-10-10","Kym Handy"]
["2013-10-06","Edgardo Dalton"]
["2013-11-05","Shantel Fennell"]
["2013-11-16","Laurine Bullard"]
["2013-10-26","Henriette Shell"]
["2013-10-19","Zulma Farrell"]
["2013-10-26","Ardelle Covey"]
["2013-11-15","Venetta Noland"]
["2013-11-19","Ethelene Contreras"]
["2013-11-08","Leo Sigler"]
["2013-10-14","Henriette Shell"]
["2013-10-31","Lavonne Raines"]
["2013-10-29","Henriette Shell"]
["2013-11-10","Ardell Song"]
["2013-10-21","Jack Koontz"]
["2013-10-20","Dudley Gunderson"]
["2013-11-05","Rodger Riddle"]
["2013-10-10","Eleonora Redmond"]
["2013-10-29","Maricela Hostetler"]
["2013-11-07","Nana Hathaway"]
["2013-10-18","Colene Garland"]
["2013-11-15","Corrinne Greathouse"]
["2013-10-20","Rodger Riddle"]
["2013-10-23","Colene Garland"]
["2013-11-05","Emory Stubblefield"]
["2013-11-22","Adena Villa"]
["2013-10-04","Laurine Bullard"]
["2013-10-21","Leo Sigler"]
["2013-11-07","Annamae Varney"]
["2013-11-21","Obdulia Rickman"]
["2013-11-06","Inge Seiler"]
["2013-10-17","Corrinne Greathouse"]
["2013-10-23","Davis Wolford"]
["2013-11-11","Annamae Varney"]
["2013-11-03","Jack Koontz"]
["2013-11-02","Floretta Dozier"]
["2013-11-16","Dusty Pointer"]
["2013-11-05","Silas Barksdale"]
["2013-10-25","Jack Koontz"]
["2013-10-12","Gidget Marlow"]
["2013-10-09","Jack Koontz"]
["2013-11-18","Rodger Riddle"]
["2013-11-10","Lavonne Raines"]
["2013-10-19","Yulanda Casillas"]
["2013-11-10","Monte Maloney"]
["2013-11-07","Rhea Furr"]
["2013-10-12","Celesta Granger"]
["2013-10-11","Ardelle Covey"]
["2013-10-08","Ardell Song"]
["2013-10-21","Mammie Ogle"]
["2013-11-18","Lucienne Chatman"]
["2013-10-26","Yulanda Casillas"]
["2013-11-11","Shantel Fennell"]
["2013-10-03","Edgardo Dalton"]
["2013-11-17","Lizzie Stinson"]
["2013-10-24","Nana Hathaway"]
["2013-10-15","Jama Monk"]
["2013-10-04","Henriette Shell"]
["2013-10-29","Leo Sigler"]
["2013-10-30","Malena Caudle"]
["2013-11-15","Davis Wolford"]
["2013-10-07","Shantel Fennell"]
["2013-10-22","Emory Stubblefield"]
["2013-11-16","Eleonora Redmond"]
["2013-10-11","Lizzie Stinson"]
["2013-10-17","Floretta Dozier"]
["2013-11-16","Wynona Folse"]
["2013-11-09","Maricela Hostetler"]
["2013-11-10","Corrinne Greathouse"]
["2013-10-13","Deloris Musgrove"]
["2013-10-08","Mammie Ogle"]
["2013-10-14","Lavonne Raines"]
["2013-10-05","Jack Koontz"]
["2013-11-17","Zulma Farrell"]
["2013-10-04","Rodger Riddle"]
["2013-10-24","Ardell Song"]
["2013-11-21","Eleonora Redmond"]
["2013-10-03","Dusty Pointer"]
["2013-10-31","Lucienne Chatman"]
["2013-11-21","Deloris Musgrove"]
["2013-10-13","Gema Tapia"]
["2013-11-03","Emory Stubblefield"]
["2013-11-20","Malena Caudle"]
["2013-11-12","Venetta Noland"]
["2013-10-12","Kym Handy"]
["2013-10-26","Lavonne Raines"]
["2013-10-03","Laurine Bullard"]
["2013-10-18","Susy Olivo"]
["2013-10-14","Silas Barksdale"]
["2013-10-12","Lizzie Stinson"]
["2013-10-18","Laurine Bullard"]
["2013-11-13","Rhea Furr"]
["2013-11-05","Wynona Folse"]
["2013-10-07","Fidelia Clifton"]
["2013-10-28","Emory Stubblefield"]
["2013-11-01","Yulanda Casillas"]
["2013-10-09","Jack Koontz"]
["2013-11-16","Celesta Granger"]
["2013-11-12","Venetta Noland"]
["2013-10-18","Venetta Noland"]
["2013-11-01","Maricela Hostetler"]
["2013-10-12","Adena Villa"]
["2013-11-18","Fidelia Clifton"]
["2013-11-09","Venetta Noland"]
["2013-10-16","Leo Sigler"]
["2013-10-10","Floretta Dozier"]
["2013-11-05","Ardell Song"]
["2013-10-19","Obdulia Rickman"]
["2013-10-06","Celesta Granger"]
["2013-10-19","Obdulia Rickman"]
["2013-11-06","Angelic Mcnair"]
["2013-11-13","Venetta Noland"]
["2013-11-16","Kym Handy"]
["2013-11-14","Yulanda Casillas"]
["2013-10-28","Zulma Farrell"]
["2013-11-18","Ardell Song"]
["2013-11-11","Dudley Gunderson"]
["2013-10-19","Wynona Folse"]
["2013-10-08","Kym Handy"]
["2013-11-02","Henriette Shell"]
["2013-10-31","Obdulia Rickman"]
["2013-10-09","Fidelia Clifton"]
["2013-11-14","Lizzie Stinson"]
["2013-10-05","Normand Mcghee"]
["2013-10-17","Kym Handy"]
["2013-10-31","Dudley Gunderson"]
["2013-10-29","Lizzie Stinson"]
["2013-10-07","Venetta Noland"]
["2013-10-19","Maricela Hostetler"]
["2013-11-03","Ethelene Contreras"]
["2013-11-09","Elfriede Maupin"]
["2013-11-19","Rodger Riddle"]
["2013-10-26","Celesta Granger"]
["2013-10-14","Celesta Granger"]
["2013-10-18","Davis Wolford"]
["2013-10-23","Ethelene Contreras"]
["2013-10-20","Laurine Bullard"]
["2013-11-08","Shantel Fennell"]
["2013-11-12","Jama Monk"]
["2013-10-25","Susy Olivo"]
["2013-10-10","Mammie Ogle"]
["2013-11-18","Ardell Song"]
["2013-10-10","Jama Monk"]
["2013-11-12","Annamae Varney"]
["2013-10-17","Rodger Riddle"]
["2013-10-19","Shantel Fennell"]
["2013-11-16","Yulanda Casillas"]
["2013-11-12","Fidelia Clifton"]
["2013-10-31","Colene Garland"]
["2013-11-03","Jack Koontz"]
["2013-10-31","Leo Sigler"]
["2013-10-29","Malena Caudle"]
["2013-10-11","Emory Stubblefield"]
["2013-10-05","Lura Maes"]
["2013-10-21","Eleonora Redmond"]
["2013-10-06","Monte Maloney"]
["2013-10-30","Wynona Folse"]
["2013-11-19","Dusty Pointer"]
["2013-10-24","Laurine Bullard"]
["2013-11-22","Angelic Mcnair"]
["2013-11-06","Eleonora Redmond"]
["2013-11-17","Lizzie Stinson"]
["2013-11-22","Leo Sigler"]
["2013-10-27","Colene Garland"]
["2013-10-24","Ethelene Contreras"]
["2013-10-07","Ardell Song"]
["2013-10-08","Lizzie Stinson"]
["2013-10-28","Deloris Musgrove"]
["2013-10-21","Angelic Mcnair"]
["2013-10-10","Leo Sigler"]
["2013-10-26","Adena Villa"]
["2013-11-10","Shantel Fennell"]
["2013-10-10","Henriette Shell"]
["2013-11-03","Shantel Fennell"]
["2013-11-07","Davis Wolford"]
["2013-11-22","Lizzie Stinson"]
["2013-11-02","Eleonora Redmond"]
["2013-10-26","Henriette Shell"]
["2013-11-10","Eleonora Redmond"]
["2013-10-29","Obdulia Rickman"]
["2013-10-27","Floretta Dozier"]
["2013-10-20","Kym Handy"]
["2013-10-20","Rodger Riddle"]
["2013-11-16","Celesta Granger"]
["2013-11-16","Silas Barksdale"]
["2013-11-05","Venetta Noland"]
["2013-10-16","Ardell Song"]
["2013-10-23","Monte Maloney"]
["2013-11-21","Lizzie Stinson"]
["2013-10-16","Fidelia Clifton"]
["2013-10-18","Fidelia Clifton"]
["2013-10-08","Gidget Marlow"]
["2013-10-31","Bernardina Free"]
["2013-10-14","Gidget Marlow"]
["2013-10-29","Rhea Furr"]
["2013-10-23","Henriette Shell"]
["2013-11-04","Laurine Bullard"]
["2013-10-27","Gema Tapia"]
["2013-10-13","Malena Caudle"]
["2013-10-29","Yulanda Casillas"]
["2013-10-09","Angelic Mcnair"]
["2013-10-14","Maricela Hostetler"]
["2013-10-13","Eleonora Redmond"]
["2013-11-01","Venetta Noland"]
["2013-10-29","Emory Stubblefield"]
["2013-10-09","Maricela Hostetler"]
["2013-11-09","Edgardo Dalton"]
["2013-10-21","Henriette Shell"]
["2013-10-04","Shantel Fennell"]
["2013-11-05","Floretta Dozier"]
["2013-11-13","Kym Handy"]
["2013-11-08","Jama Monk"]
["2013-10-22","Henriette Shell"]
["2013-11-16","Corrinne Greathouse"]
["2013-11-08","Silas Barksdale"]
["2013-11-07","Zulma Farrell"]
["2013-10-14","Leo Sigler"]
["2013-11-19","Inge Seiler"]
["2013-10-26","Jack Koontz"]
["2013-11-05","Silas Barksdale"]
["2013-10-07","Davis Wolford"]
["2013-11-22","Venetta Noland"]
["2013-11-20","Rhea Furr"]
["2013-11-16","Malena Caudle"]
["2013-11-03","Lavonne Raines"]
["2013-10-23","Obdulia Rickman"]
["2013-11-02","Ethelene Contreras"]
["2013-10-11","Corrinne Greathouse"]
["2013-10-03","Susy Olivo"]
["2013-11-01","Zulma Farrell"]
["2013-10-21","Annamae Varney"]
["2013-10-03","Annamae Varney"]
["2013-11-08","Wynona Folse"]
["2013-10-10","Ethelene Contreras"]
["2013-11-09","Zulma Farrell"]
["2013-10-10","Kym Handy"]
["2013-11-09","Rodger Riddle"]
["2013-11-03","Monte Maloney"]
["2013-10-17","Jack Koontz"]
["2013-11-04","Corrinne Greathouse"]
["2013-10-04","Silas Barksdale"]
["2013-11-20","Monte Maloney"]
["2013-10-14","Susy Olivo"]
["2013-10-25","Mammie Ogle"]
["2013-10-07","Leo Sigler"]
["2013-11-04","Angelic Mcnair"]
["2013-10-11","Silas Barksdale"]
["2013-10-16","Ardell Song"]
["2013-10-23","Inge Seiler"]
["2013-11-12","Malena Caudle"]
["2013-10-13","Davis Wolford"]
["2013-10-29","Deloris Musgrove"]
["2013-10-30","Deloris Musgrove"]
["2013-11-06","Emory Stubblefield"]
["2013-10-14","Yulanda Casillas"]
["2013-11-10","Rodger Riddle"]
["2013-10-12","Deloris Musgrove"]
["2013-11-03","Davis Wolford"]
["2013-11-17","Angelic Mcnair"]
["2013-11-21","Edgardo Dalton"]
["2013-10-04","Gema Tapia"]
["2013-10-30","Rhea Furr"]
["2013-11-01","Henriette Shell"]
["2013-11-21","Shantel Fennell"]
["2013-11-17","Shantel Fennell"]
["2013-11-09","Colene Garland"]
["2013-10-25","Rodger Riddle"]
["2013-11-18","Colene Garland"]
["2013-11-13","Annamae Varney"]
["2013-10-04","Dudley Gunderson"]
["2013-10-24","Edgardo Dalton"]
["2013-11-05","Angelic Mcnair"]
["2013-10-04","Dusty Pointer"]
["2013-10-22","Rodger Riddle"]
["2013-11-16","Fidelia Clifton"]
["2013-10-05","Maryrose Clawson"]
["2013-11-13","Nana Hathaway"]
["2013-10-26","Lavonne Raines"]
["2013-10-22","Rhea Furr"]
["2013-11-13","Bernardina Free"]
["2013-11-03","Lavonne Raines"]
["2013-10-06","Gema Tapia"]
["2013-10-20","Rodger Riddle"]
["2013-10-13","Corrinne Greathouse"]
["2013-11-16","Deloris Musgrove"]
["2013-10-27","Monte Maloney"]
["2013-11-20","Gidget Marlow"]
["2013-11-15","Edgardo Dalton"]
["2013-10-29","Mammie Ogle"]
["2013-11-12","Venetta Noland"]
["2013-10-06","Shantel Fennell"]
["2013-11-03","Deloris Musgrove"]
["2013-11-13","Normand Mcghee"]
["2013-10-12","Zulma Farrell"]
["2013-11-04","Colene Garland"]
["2013-10-17","Lavonne Raines"]
["2013-10-29","Annamae Varney"]
["2013-10-22","Lizzie Stinson"]
["2013-10-03","Normand Mcghee"]
["2013-11-13","Lavonne Raines"]
["2013-11-16","Henriette Shell"]
["2013-10-03","Venetta Noland"]
["2013-11-03","Dusty Pointer"]
["2013-10-27","Laurine Bullard"]
["2013-10-30","Bernardina Free"]
["2013-10-13","Monte Maloney"]
["2013-10-26","Annamae Varney"]
["2013-10-09","Shantel Fennell"]
["2013-10-09","Davis Wolford"]
["2013-10-20","Henriette Shell"]
["2013-10-22","Gema Tapia"]
["2013-10-13","Gema Tapia"]
["2013-11-16","Fidelia Clifton"]
["2013-10-07","Maryrose Clawson"]
["2013-11-10","Laurine Bullard"]
["2013-11-14","Zulma Farrell"]
["2013-11-22","Obdulia Rickman"]
["2013-11-21","Lizzie Stinson"]
["2013-11-21","Wynona Folse"]
["2013-10-08","Ardelle Covey"]
["2013-10-11","Venetta Noland"]
["2013-10-27","Corrinne Greathouse"]
["2013-11-15","Obdulia Rickman"]
["2013-11-18","Edgardo Dalton"]
["2013-10-27","Deloris Musgrove"]

{"sheet":"11-(13)","index":15,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Назад к указателю","Чистые активы","Кредитный рейтинг",null,"Критерии ИЛИ:",null,"Критерии ИЛИ для функции БСЧЁТ:"]
["J.K. LLC",85024,4,null,"Чистые активы",null,"Чистые активы","Кредитный рейтинг"]
["Fruits Inc.",111104,3.5,null,100000,null,">100000"]
["SW",89236,2.4,null,"Кредитный рейтинг",null,null,">=3,5"]
["PCC",113212,3,null,3.5]
["Gigi's Inc.",100000,1.4]
[]
["Счет",{"$f":"SUM(IF((B2:B6>E3)+(C2:C6>=E5),1))","v":3}," < Формула [1] {=СУММ(ЕСЛИ((B2:B6>E3)+(C2:C6>=E5);1))}"]
["Счет",{"$f":"DCOUNT(B1:C6,,G2:H4)","v":3}," < Формула [2] =БСЧЁТ(B1:C6;;G2:H4)"]
["Счет",{"$f":"SUMPRODUCT(--((B2:B6>E3)+(C2:C6>=E5)>0))","v":3}," < Формула [3] =СУММПРОИЗВ(--((B2:B6>E3)+(C2:C6>=E5)>0))"]
["Счет",{"$f":"COUNTIF(B2:B6,\">\"&E3)+COUNTIF(C2:C6,\">=\"&E5)","v":4}," < Некорректная формула [4] =СЧЁТЕСЛИ(B2:B6;\">\"&E3)+СЧЁТЕСЛИ(C2:C6;\">=\"&E5)"]
["Счет",{"$f":"SUMPRODUCT((B2:B6>E3)+(C2:C6>=E5))","v":4}," < Некорректная формула  [5] =СУММПРОИЗВ((B2:B6>E3)+(C2:C6>=E5))"]

{"sheet":"11-(15)","index":16,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,0,8,6]]}
["Назад к указателю","Объем продаж","Клиент",null,"Критерии ИЛИ:"]
["West",186343,"SWQ",null,"Регион"]
["East",293630,"IGG",null,"West"]
["West",77970,"IGG",null,"MidWest"]
["South",27643,"SWQ"]
["MidWest",34097,"IGG"]
["MidWest",159800,"SWQ"]
[]
["Критерий ИЛИ по данным одного столбца\n(логическая проверка не может привести к двум значениям ИСТИНА)"]
["Сумма",{"$f":"SUMIF(A2:A7,E3,B2:B7)+SUMIF(A2:A7,E4,B2:B7)","v":458210},"=СУММЕСЛИ(A2:A7;E3;B2:B7)+СУММЕСЛИ(A2:A7;E4;B2:B7)"]
["Среднее",{"$f":"AVERAGE(IF((A2:A7=E3)+(A2:A7=E4),B2:B7))","v":114552.5},"{=СРЗНАЧ(ЕСЛИ((A2:A7=E3)+(A2:A7=E4);B2:B7))}"]

{"sheet":"11-(16)","index":17,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,0,8,6]]}
["Назад к указателю","Объем продаж","Клиент",null,"Критерии ИЛИ:"]
["West",186343,"SWQ",null,"Регион"]
["East",293630,"IGG",null,"West"]
["West",77970,"IGG",null,"Клиент"]
["South",27643,"SWQ",null,"IGG"]
["MidWest",34097,"IGG"]
["MidWest",159800,"SWQ"]
[]
["Критерий ИЛИ по данным двух столбцов\n(логическая проверка может привести к двум значениям ИСТИНА)"]
["Сумма",{"$f":"SUM(IF((A2:A7=E3)+(C2:C7=E5),B2:B7))","v":592040},"[1]","{=СУММ(ЕСЛИ((A2:A7=E3)+(C2:C7=E5);B2:B7))}"]
["Среднее",{"$f":"AVERAGE(IF((A2:A7=E3)+(C2:C7=E5),B2:B7))","v":148010},"[2]","{=СРЗНАЧ(ЕСЛИ((A2:A7=E3)+(C2:C7=E5);B2:B7))}"]
["Сумма",{"$f":"SUMPRODUCT(--((A2:A7=E3)+(C2:C7=E5)>0),B2:B7)","v":592040},"[3]","=СУММПРОИЗВ(--((A2:A7=E3)+(C2:C7=E5)>0);B2:B7)"]
["Сумма",{"$f":"SUMIF(A2:A7,E3,B2:B7)+SUMIF(C2:C7,E5,B2:B7)","v":670010},"[4]","=СУММЕСЛИ(A2:A7;E3;B2:B7)+СУММЕСЛИ(C2:C7;E5;B2:B7)"]

{"sheet":"11-(17)","index":18,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,0,8,6]]}
["Назад к указателю","Объем продаж","Клиент",null,"Критерии ИЛИ:"]
["West",186343,"SWQ",null,"Регион"]
["East",293630,"IGG",null,"West"]
["West",77970,"IGG",null,"Клиент"]
["South",27643,"SWQ",null,"IGG"]
["MidWest",34097,"IGG"]
["MidWest",159800,"SWQ"]
[]
["Критерий ИЛИ по данным двух столбцов\n(логическая проверка может привести к двум значениям ИСТИНА)"]
["МИН",{"$f":"MIN(IF((A2:A7=E3)+(C2:C7=E5),B2:B7))","v":34097},"[1] {=МИН(ЕСЛИ((A2:A7=E3)+(C2:C7=E5);B2:B7))}"]
["МИН",{"$f":"_xlfn.AGGREGATE(15,6,B2:B7/((A2:A7=E3)+(C2:C7=E5)>0),1)","v":34097},"[2] =АГРЕГАТ(15;6;B2:B7/((A2:A7=E3)+(C2:C7=E5)>0);1)"]
["МАКС",{"$f":"MAX(IF((A2:A7=E3)+(C2:C7=E5),B2:B7))","v":293630},"[3] {=МАКС(ЕСЛИ((A2:A7=E3)+(C2:C7=E5);B2:B7))}"]
["МАКС",{"$f":"_xlfn.AGGREGATE(14,6,B2:B7*((A2:A7=E3)+(C2:C7=E5)>0),1)","v":293630},"[4] =АГРЕГАТ(14;6;B2:B7*((A2:A7=E3)+(C2:C7=E5)>0);1)"]

{"sheet":"11-(18)","index":19,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,2,17,7],[18,2,18,7],[8,0,9,7],[10,0,10,7],[11,2,11,7],[12,2,12,7],[13,2,13,7],[14,2,14,7],[15,2,15,7],[16,2,16,7]]}
["Назад к указателю","Регион","Продажи",null,"Критерии:"]
["2013-03-11","West",340936,null,"Дата","Дата","Регион"]
["2013-02-15","East",226110,null,"2013-03-18","2013-05-12","West"]
["2013-04-16","Midwest",295977,null,null,null,"Midwest"]
["2013-05-22","East",433524]
["2013-03-22","West",374854]
["2013-02-25","Midwest",251871]
[]
["Критерий ИЛИ указывает на 1 столбец (логический тест ИЛИ не может вернуть более одного значения ИСТИНА)"]
[]
[{"$f":"\"Критерии: между \"&TEXT(E3,\"Д/ММ\")&\" и \"&TEXT(F3,\"Д/ММ\")&\" для регионов \"&G3&\" или \"&G4","v":"Критерии: между 18/03 и 12/05 для регионов West или Midwest"}]
["Счет",{"$f":"COUNTIFS(A2:A7,\">=\"&E3,A2:A7,\"<=\"&F3,B2:B7,G3)+COUNTIFS(A2:A7,\">=\"&E3,A2:A7,\"<=\"&F3,B2:B7,G4)","v":2}," [1] =СЧЁТЕСЛИМН(A2:A7;\">=\"&E3;A2:A7;\"<=\"&F3;B2:B7;G3)+ СЧЁТЕСЛИМН(A2:A7;\">=\"&E3;A2:A7;\"<=\"&F3;B2:B7;G4)"]
["Счет",{"$f":"SUMPRODUCT(--(A2:A7>=E3),--(A2:A7<=F3),--((B2:B7=G3)+(B2:B7=G4)))","v":2}," [2] =СУММПРОИЗВ(--(A2:A7>=E3);--(A2:A7<=F3);--((B2:B7=G3)+(B2:B7=G4)))"]
["Счет",{"$f":"SUM(IF((A2:A7>=E3)*(A2:A7<=F3)*((B2:B7=G3)+(B2:B7=G4)),1))","v":2}," [3] {=СУММ(ЕСЛИ((A2:A7>=E3)*(A2:A7<=F3)*((B2:B7=G3)+(B2:B7=G4));1))}"]
["Счет",{"$f":"SUMPRODUCT(--(A2:A7>=E3),--(A2:A7<=F3),--ISNUMBER(MATCH(B2:B7,G3:G4,0)))","v":2}," [4] =СУММПРОИЗВ(--(A2:A7>=E3);--(A2:A7<=F3);--ЕЧИСЛО(ПОИСКПОЗ\n(B2:B7;G3:G4;0)))"]
["Сумма",{"$f":"SUMIFS(C2:C7,A2:A7,\">=\"&E3,A2:A7,\"<=\"&F3,B2:B7,G3)+SUMIFS(C2:C7,A2:A7,\">=\"&E3,A2:A7,\"<=\"&F3,B2:B7,G4)","v":670831}," [5] =СУММЕСЛИМН(C2:C7;A2:A7;\">=\"&E3;A2:A7;\"<=\"&F3;B2:B7;G3)+ СУММЕСЛИМН(C2:C7;A2:A7;\">=\"&E3;A2:A7;\"<=\"&F3;B2:B7;G4)"]
["Сумма",{"$f":"SUMPRODUCT(--(A2:A7>=E3),--(A2:A7<=F3),--ISNUMBER(MATCH(B2:B7,G3:G4,0)),C2:C7)","v":670831}," [6] =СУММПРОИЗВ(--(A2:A7>=E3);--(A2:A7<=F3);--ЕЧИСЛО(ПОИСКПОЗ\n(B2:B7;G3:G4;0));C2:C7)"]
["МИН",{"$f":"_xlfn.AGGREGATE(15,6,C2:C7/((A2:A7>=E3)*(A2:A7<=F3)*((B2:B7=G3)+(B2:B7=G4))),1)","v":295977}," [7] =АГРЕГАТ(15;6;C2:C7/((A2:A7>=E3)*(A2:A7<=F3)*((B2:B7=G3)+ (B2:B7=G4)));1)"]
["Среднее",{"$f":"AVERAGE(IF((A2:A7>=E3)*(A2:A7<=F3)*((B2:B7=G3)+(B2:B7=G4)),C2:C7))","v":335415.5}," [8] {=СРЗНАЧ(ЕСЛИ((A2:A7>=E3)*(A2:A7<=F3)*((B2:B7=G3)+ (B2:B7=G4));C2:C7))}"]

{"sheet":"11-(19)","index":20,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,0,13,6]]}
["Назад к указателю","Чистые активы","Рейтинг1","Рейтинг2","Чистая прибыль","Вспомогательная"]
["J.K. LLC",85024,4,6,31267,{"$f":"AND(B2>$B$10,E2>$D$10,OR(C2>=$C$10,D2>=$C$12))","v":false},"=И(B2>$B$10;E2>$D$10;ИЛИ(C2>=$C$10;D2>=$C$12))"]
["Fruits Inc.",111104,3.5,9,73346,true,"=И(B3>$B$10;E3>$D$10;ИЛИ(C3>=$C$10;D3>=$C$12))"]
["SW",89236,2.4,7,65334,false,"=И(B4>$B$10;E4>$D$10;ИЛИ(C4>=$C$10;D4>=$C$12))"]
["PCC",113212,3,5,45609,false,"=И(B5>$B$10;E5>$D$10;ИЛИ(C5>=$C$10;D5>=$C$12))"]
["Gigi's Inc.",100000,1.4,1,34550,false,"=И(B6>$B$10;E6>$D$10;ИЛИ(C6>=$C$10;D6>=$C$12))"]
["Fabulous Figs",159800,4.3,6,43500,true,"=И(B7>$B$10;E7>$D$10;ИЛИ(C7>=$C$10;D7>=$C$12))"]
[]
["Критерии:","Чистые активы","Рейтинг1","Чистая прибыль"]
[null,100000,3.5,37500]
[null,null,"Рейтинг2"]
[null,null,6]
[]
["Критерий ИЛИ указывает на 2 столбца (логический тест ИЛИ может вернуть более одного значения ИСТИНА)"]
["Счет",{"$f":"COUNTIF(F2:F7,TRUE)","v":2}," [1] =СЧЁТЕСЛИ(F2:F7;ИСТИНА)"]
["Счет",{"$f":"SUM(IF(B2:B7>B10,IF(E2:E7>D10,IF((C2:C7>=C10)+(D2:D7>=C12),1))))","v":2}," [2] {=СУММ(ЕСЛИ(B2:B7>B10;ЕСЛИ(E2:E7>D10;ЕСЛИ((C2:C7>=C10)+(D2:D7>=C12);1))))}"]
["Счет",{"$f":"SUMPRODUCT(--(B2:B7>B10),--(E2:E7>D10),--((C2:C7>=C10)+(D2:D7>=C12)>0))","v":2}," [3] =СУММПРОИЗВ(--(B2:B7>B10);--(E2:E7>D10);--((C2:C7>=C10)+(D2:D7>=C12)>0))"]
["Счет",{"$f":"SUM(IF((B2:B7>B10)*(E2:E7>D10)*((C2:C7>=C10)+(D2:D7>=C12)),1))","v":2}," [4] {=СУММ(ЕСЛИ((B2:B7>B10)*(E2:E7>D10)*((C2:C7>=C10)+(D2:D7>=C12));1))}"]
["МАКС чистые активы",{"$f":"MAX(IF((B2:B7>B10)*(E2:E7>D10)*((C2:C7>=C10)+(D2:D7>=C12)),B2:B7))","v":159800}," [5] {=МАКС(ЕСЛИ((B2:B7>B10)*(E2:E7>D10)*((C2:C7>=C10)+(D2:D7>=C12));B2:B7))}"]
["Среднее чистые активы",{"$f":"AVERAGE(IF((B2:B7>B10)*(E2:E7>D10)*((C2:C7>=C10)+(D2:D7>=C12)),B2:B7))","v":135452}," [6] {=СРЗНАЧ(ЕСЛИ((B2:B7>B10)*(E2:E7>D10)*((C2:C7>=C10)+(D2:D7>=C12));B2:B7))}"]
[]
["Счет",{"$f":"DCOUNT(B1:E7,,A25:D28)","v":2}," [7] =БСЧЁТ(B1:E7;;A25:D28)"]
[]
["Критерии функции базы данных:"]
["Чистые активы","Рейтинг1","Рейтинг2","Чистая прибыль"]
[">100000",">=3.5",">=6",">37500"]
[">100000",">=3.5",null,">37500"]
[">100000",null,">=6",">37500"]