Рабочая книга содержит чистый лист «Шаблон» и заполненный лист «Пример». Данные примера условны и не описывают реальных контрагентов.

Как работать

  • Календарные дни включают обе граничные даты. Зависимости проверяются вручную.
  • Полоса показывает план на 28 дней с даты контроля; она не пересчитывает последовательность.
  • Готовность от 0% до 100%. Недопустимый период обозначается явно.
  • Скопируйте файл для своего объекта. Заполняйте желтые ячейки, сохраняя формулы в белых.
  • Числа вводите числами. Даты введите как даты Excel. Доли вводите процентами.
  • Пустая обязательная величина означает отсутствие данных; ноль означает установленное нулевое значение.
  • Проверяйте исходные документы и полномочия. Итог в таблице не заменяет решения ответственного лица.
  • В файле задано 40-я строка как конец расчетной области. При расширении добавьте строки, формулы, проверки и итоги.

Проверка на примере

На листе «Пример» E12 дает 8. Формулы пересчитываются при изменении входов. Денежные значения заданы в рублях, если в заголовке не указано иное.

Редакция 29.10.2026.

Содержимое рабочей книги

Ниже приведены исходные ячейки и формулы. Для пересчёта и заполнения скачайте файл XLSX. Пример содержит условные данные.

Лист «Шаблон»

СтрокаABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1OBYOM / Рабочий шаблон
2График работ
3Желтые ячейки — ввод. Белые — расчет. Инструкция в одноименном файле MD.
5Дата29.10.2026
6Просрочено этапов=IF(COUNTA(B11:B40)=0,"",COUNTIF(I11:I40,"Просрочен"))
10IDЭтапНачалоОкончаниеДнейГотовностьОтветственныйЗависимостьСтатус=$B$5+0=$B$5+1=$B$5+2=$B$5+3=$B$5+4=$B$5+5=$B$5+6=$B$5+7=$B$5+8=$B$5+9=$B$5+10=$B$5+11=$B$5+12=$B$5+13=$B$5+14=$B$5+15=$B$5+16=$B$5+17=$B$5+18=$B$5+19=$B$5+20=$B$5+21=$B$5+22=$B$5+23=$B$5+24=$B$5+25=$B$5+26=$B$5+27
111=IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11))),"Нет дат",IF(D11<C11,"Ошибка дат",D11-C11+1)))=IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11)),NOT(ISNUMBER(F11))),"Нет данных",IF(D11<C11,"Ошибка дат",IF(F11=1,"Завершен",IF(D11<$B$5,"Просрочен","В работе")))))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(J$10>=$C11,J$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(K$10>=$C11,K$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(L$10>=$C11,L$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(M$10>=$C11,M$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(N$10>=$C11,N$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(O$10>=$C11,O$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(P$10>=$C11,P$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Q$10>=$C11,Q$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(R$10>=$C11,R$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(S$10>=$C11,S$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(T$10>=$C11,T$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(U$10>=$C11,U$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(V$10>=$C11,V$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(W$10>=$C11,W$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(X$10>=$C11,X$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Y$10>=$C11,Y$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Z$10>=$C11,Z$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AA$10>=$C11,AA$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AB$10>=$C11,AB$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AC$10>=$C11,AC$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AD$10>=$C11,AD$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AE$10>=$C11,AE$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AF$10>=$C11,AF$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AG$10>=$C11,AG$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AH$10>=$C11,AH$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AI$10>=$C11,AI$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AJ$10>=$C11,AJ$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AK$10>=$C11,AK$10<=$D11),1,""))
122=IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12))),"Нет дат",IF(D12<C12,"Ошибка дат",D12-C12+1)))=IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12)),NOT(ISNUMBER(F12))),"Нет данных",IF(D12<C12,"Ошибка дат",IF(F12=1,"Завершен",IF(D12<$B$5,"Просрочен","В работе")))))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(J$10>=$C12,J$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(K$10>=$C12,K$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(L$10>=$C12,L$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(M$10>=$C12,M$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(N$10>=$C12,N$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(O$10>=$C12,O$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(P$10>=$C12,P$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Q$10>=$C12,Q$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(R$10>=$C12,R$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(S$10>=$C12,S$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(T$10>=$C12,T$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(U$10>=$C12,U$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(V$10>=$C12,V$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(W$10>=$C12,W$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(X$10>=$C12,X$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Y$10>=$C12,Y$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Z$10>=$C12,Z$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AA$10>=$C12,AA$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AB$10>=$C12,AB$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AC$10>=$C12,AC$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AD$10>=$C12,AD$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AE$10>=$C12,AE$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AF$10>=$C12,AF$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AG$10>=$C12,AG$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AH$10>=$C12,AH$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AI$10>=$C12,AI$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AJ$10>=$C12,AJ$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AK$10>=$C12,AK$10<=$D12),1,""))
133=IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13))),"Нет дат",IF(D13<C13,"Ошибка дат",D13-C13+1)))=IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13)),NOT(ISNUMBER(F13))),"Нет данных",IF(D13<C13,"Ошибка дат",IF(F13=1,"Завершен",IF(D13<$B$5,"Просрочен","В работе")))))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(J$10>=$C13,J$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(K$10>=$C13,K$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(L$10>=$C13,L$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(M$10>=$C13,M$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(N$10>=$C13,N$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(O$10>=$C13,O$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(P$10>=$C13,P$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Q$10>=$C13,Q$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(R$10>=$C13,R$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(S$10>=$C13,S$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(T$10>=$C13,T$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(U$10>=$C13,U$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(V$10>=$C13,V$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(W$10>=$C13,W$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(X$10>=$C13,X$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Y$10>=$C13,Y$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Z$10>=$C13,Z$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AA$10>=$C13,AA$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AB$10>=$C13,AB$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AC$10>=$C13,AC$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AD$10>=$C13,AD$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AE$10>=$C13,AE$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AF$10>=$C13,AF$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AG$10>=$C13,AG$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AH$10>=$C13,AH$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AI$10>=$C13,AI$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AJ$10>=$C13,AJ$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AK$10>=$C13,AK$10<=$D13),1,""))
144=IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14))),"Нет дат",IF(D14<C14,"Ошибка дат",D14-C14+1)))=IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14)),NOT(ISNUMBER(F14))),"Нет данных",IF(D14<C14,"Ошибка дат",IF(F14=1,"Завершен",IF(D14<$B$5,"Просрочен","В работе")))))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(J$10>=$C14,J$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(K$10>=$C14,K$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(L$10>=$C14,L$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(M$10>=$C14,M$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(N$10>=$C14,N$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(O$10>=$C14,O$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(P$10>=$C14,P$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Q$10>=$C14,Q$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(R$10>=$C14,R$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(S$10>=$C14,S$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(T$10>=$C14,T$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(U$10>=$C14,U$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(V$10>=$C14,V$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(W$10>=$C14,W$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(X$10>=$C14,X$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Y$10>=$C14,Y$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Z$10>=$C14,Z$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AA$10>=$C14,AA$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AB$10>=$C14,AB$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AC$10>=$C14,AC$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AD$10>=$C14,AD$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AE$10>=$C14,AE$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AF$10>=$C14,AF$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AG$10>=$C14,AG$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AH$10>=$C14,AH$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AI$10>=$C14,AI$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AJ$10>=$C14,AJ$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AK$10>=$C14,AK$10<=$D14),1,""))
155=IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15))),"Нет дат",IF(D15<C15,"Ошибка дат",D15-C15+1)))=IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15)),NOT(ISNUMBER(F15))),"Нет данных",IF(D15<C15,"Ошибка дат",IF(F15=1,"Завершен",IF(D15<$B$5,"Просрочен","В работе")))))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(J$10>=$C15,J$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(K$10>=$C15,K$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(L$10>=$C15,L$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(M$10>=$C15,M$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(N$10>=$C15,N$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(O$10>=$C15,O$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(P$10>=$C15,P$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Q$10>=$C15,Q$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(R$10>=$C15,R$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(S$10>=$C15,S$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(T$10>=$C15,T$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(U$10>=$C15,U$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(V$10>=$C15,V$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(W$10>=$C15,W$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(X$10>=$C15,X$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Y$10>=$C15,Y$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Z$10>=$C15,Z$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AA$10>=$C15,AA$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AB$10>=$C15,AB$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AC$10>=$C15,AC$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AD$10>=$C15,AD$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AE$10>=$C15,AE$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AF$10>=$C15,AF$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AG$10>=$C15,AG$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AH$10>=$C15,AH$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AI$10>=$C15,AI$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AJ$10>=$C15,AJ$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AK$10>=$C15,AK$10<=$D15),1,""))
166=IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16))),"Нет дат",IF(D16<C16,"Ошибка дат",D16-C16+1)))=IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16)),NOT(ISNUMBER(F16))),"Нет данных",IF(D16<C16,"Ошибка дат",IF(F16=1,"Завершен",IF(D16<$B$5,"Просрочен","В работе")))))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(J$10>=$C16,J$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(K$10>=$C16,K$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(L$10>=$C16,L$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(M$10>=$C16,M$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(N$10>=$C16,N$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(O$10>=$C16,O$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(P$10>=$C16,P$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Q$10>=$C16,Q$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(R$10>=$C16,R$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(S$10>=$C16,S$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(T$10>=$C16,T$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(U$10>=$C16,U$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(V$10>=$C16,V$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(W$10>=$C16,W$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(X$10>=$C16,X$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Y$10>=$C16,Y$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Z$10>=$C16,Z$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AA$10>=$C16,AA$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AB$10>=$C16,AB$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AC$10>=$C16,AC$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AD$10>=$C16,AD$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AE$10>=$C16,AE$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AF$10>=$C16,AF$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AG$10>=$C16,AG$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AH$10>=$C16,AH$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AI$10>=$C16,AI$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AJ$10>=$C16,AJ$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AK$10>=$C16,AK$10<=$D16),1,""))
177=IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17))),"Нет дат",IF(D17<C17,"Ошибка дат",D17-C17+1)))=IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17)),NOT(ISNUMBER(F17))),"Нет данных",IF(D17<C17,"Ошибка дат",IF(F17=1,"Завершен",IF(D17<$B$5,"Просрочен","В работе")))))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(J$10>=$C17,J$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(K$10>=$C17,K$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(L$10>=$C17,L$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(M$10>=$C17,M$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(N$10>=$C17,N$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(O$10>=$C17,O$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(P$10>=$C17,P$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Q$10>=$C17,Q$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(R$10>=$C17,R$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(S$10>=$C17,S$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(T$10>=$C17,T$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(U$10>=$C17,U$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(V$10>=$C17,V$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(W$10>=$C17,W$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(X$10>=$C17,X$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Y$10>=$C17,Y$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Z$10>=$C17,Z$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AA$10>=$C17,AA$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AB$10>=$C17,AB$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AC$10>=$C17,AC$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AD$10>=$C17,AD$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AE$10>=$C17,AE$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AF$10>=$C17,AF$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AG$10>=$C17,AG$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AH$10>=$C17,AH$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AI$10>=$C17,AI$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AJ$10>=$C17,AJ$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AK$10>=$C17,AK$10<=$D17),1,""))
188=IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18))),"Нет дат",IF(D18<C18,"Ошибка дат",D18-C18+1)))=IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18)),NOT(ISNUMBER(F18))),"Нет данных",IF(D18<C18,"Ошибка дат",IF(F18=1,"Завершен",IF(D18<$B$5,"Просрочен","В работе")))))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(J$10>=$C18,J$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(K$10>=$C18,K$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(L$10>=$C18,L$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(M$10>=$C18,M$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(N$10>=$C18,N$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(O$10>=$C18,O$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(P$10>=$C18,P$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Q$10>=$C18,Q$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(R$10>=$C18,R$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(S$10>=$C18,S$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(T$10>=$C18,T$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(U$10>=$C18,U$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(V$10>=$C18,V$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(W$10>=$C18,W$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(X$10>=$C18,X$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Y$10>=$C18,Y$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Z$10>=$C18,Z$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AA$10>=$C18,AA$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AB$10>=$C18,AB$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AC$10>=$C18,AC$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AD$10>=$C18,AD$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AE$10>=$C18,AE$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AF$10>=$C18,AF$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AG$10>=$C18,AG$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AH$10>=$C18,AH$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AI$10>=$C18,AI$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AJ$10>=$C18,AJ$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AK$10>=$C18,AK$10<=$D18),1,""))
199=IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19))),"Нет дат",IF(D19<C19,"Ошибка дат",D19-C19+1)))=IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19)),NOT(ISNUMBER(F19))),"Нет данных",IF(D19<C19,"Ошибка дат",IF(F19=1,"Завершен",IF(D19<$B$5,"Просрочен","В работе")))))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(J$10>=$C19,J$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(K$10>=$C19,K$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(L$10>=$C19,L$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(M$10>=$C19,M$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(N$10>=$C19,N$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(O$10>=$C19,O$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(P$10>=$C19,P$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Q$10>=$C19,Q$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(R$10>=$C19,R$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(S$10>=$C19,S$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(T$10>=$C19,T$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(U$10>=$C19,U$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(V$10>=$C19,V$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(W$10>=$C19,W$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(X$10>=$C19,X$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Y$10>=$C19,Y$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Z$10>=$C19,Z$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AA$10>=$C19,AA$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AB$10>=$C19,AB$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AC$10>=$C19,AC$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AD$10>=$C19,AD$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AE$10>=$C19,AE$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AF$10>=$C19,AF$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AG$10>=$C19,AG$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AH$10>=$C19,AH$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AI$10>=$C19,AI$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AJ$10>=$C19,AJ$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AK$10>=$C19,AK$10<=$D19),1,""))
2010=IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20))),"Нет дат",IF(D20<C20,"Ошибка дат",D20-C20+1)))=IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20)),NOT(ISNUMBER(F20))),"Нет данных",IF(D20<C20,"Ошибка дат",IF(F20=1,"Завершен",IF(D20<$B$5,"Просрочен","В работе")))))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(J$10>=$C20,J$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(K$10>=$C20,K$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(L$10>=$C20,L$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(M$10>=$C20,M$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(N$10>=$C20,N$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(O$10>=$C20,O$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(P$10>=$C20,P$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Q$10>=$C20,Q$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(R$10>=$C20,R$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(S$10>=$C20,S$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(T$10>=$C20,T$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(U$10>=$C20,U$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(V$10>=$C20,V$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(W$10>=$C20,W$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(X$10>=$C20,X$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Y$10>=$C20,Y$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Z$10>=$C20,Z$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AA$10>=$C20,AA$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AB$10>=$C20,AB$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AC$10>=$C20,AC$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AD$10>=$C20,AD$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AE$10>=$C20,AE$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AF$10>=$C20,AF$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AG$10>=$C20,AG$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AH$10>=$C20,AH$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AI$10>=$C20,AI$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AJ$10>=$C20,AJ$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AK$10>=$C20,AK$10<=$D20),1,""))
2111=IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21))),"Нет дат",IF(D21<C21,"Ошибка дат",D21-C21+1)))=IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21)),NOT(ISNUMBER(F21))),"Нет данных",IF(D21<C21,"Ошибка дат",IF(F21=1,"Завершен",IF(D21<$B$5,"Просрочен","В работе")))))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(J$10>=$C21,J$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(K$10>=$C21,K$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(L$10>=$C21,L$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(M$10>=$C21,M$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(N$10>=$C21,N$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(O$10>=$C21,O$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(P$10>=$C21,P$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Q$10>=$C21,Q$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(R$10>=$C21,R$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(S$10>=$C21,S$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(T$10>=$C21,T$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(U$10>=$C21,U$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(V$10>=$C21,V$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(W$10>=$C21,W$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(X$10>=$C21,X$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Y$10>=$C21,Y$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Z$10>=$C21,Z$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AA$10>=$C21,AA$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AB$10>=$C21,AB$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AC$10>=$C21,AC$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AD$10>=$C21,AD$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AE$10>=$C21,AE$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AF$10>=$C21,AF$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AG$10>=$C21,AG$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AH$10>=$C21,AH$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AI$10>=$C21,AI$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AJ$10>=$C21,AJ$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AK$10>=$C21,AK$10<=$D21),1,""))
2212=IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22))),"Нет дат",IF(D22<C22,"Ошибка дат",D22-C22+1)))=IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22)),NOT(ISNUMBER(F22))),"Нет данных",IF(D22<C22,"Ошибка дат",IF(F22=1,"Завершен",IF(D22<$B$5,"Просрочен","В работе")))))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(J$10>=$C22,J$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(K$10>=$C22,K$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(L$10>=$C22,L$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(M$10>=$C22,M$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(N$10>=$C22,N$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(O$10>=$C22,O$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(P$10>=$C22,P$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Q$10>=$C22,Q$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(R$10>=$C22,R$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(S$10>=$C22,S$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(T$10>=$C22,T$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(U$10>=$C22,U$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(V$10>=$C22,V$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(W$10>=$C22,W$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(X$10>=$C22,X$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Y$10>=$C22,Y$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Z$10>=$C22,Z$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AA$10>=$C22,AA$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AB$10>=$C22,AB$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AC$10>=$C22,AC$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AD$10>=$C22,AD$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AE$10>=$C22,AE$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AF$10>=$C22,AF$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AG$10>=$C22,AG$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AH$10>=$C22,AH$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AI$10>=$C22,AI$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AJ$10>=$C22,AJ$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AK$10>=$C22,AK$10<=$D22),1,""))
2313=IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23))),"Нет дат",IF(D23<C23,"Ошибка дат",D23-C23+1)))=IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23)),NOT(ISNUMBER(F23))),"Нет данных",IF(D23<C23,"Ошибка дат",IF(F23=1,"Завершен",IF(D23<$B$5,"Просрочен","В работе")))))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(J$10>=$C23,J$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(K$10>=$C23,K$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(L$10>=$C23,L$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(M$10>=$C23,M$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(N$10>=$C23,N$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(O$10>=$C23,O$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(P$10>=$C23,P$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Q$10>=$C23,Q$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(R$10>=$C23,R$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(S$10>=$C23,S$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(T$10>=$C23,T$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(U$10>=$C23,U$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(V$10>=$C23,V$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(W$10>=$C23,W$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(X$10>=$C23,X$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Y$10>=$C23,Y$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Z$10>=$C23,Z$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AA$10>=$C23,AA$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AB$10>=$C23,AB$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AC$10>=$C23,AC$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AD$10>=$C23,AD$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AE$10>=$C23,AE$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AF$10>=$C23,AF$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AG$10>=$C23,AG$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AH$10>=$C23,AH$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AI$10>=$C23,AI$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AJ$10>=$C23,AJ$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AK$10>=$C23,AK$10<=$D23),1,""))
2414=IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24))),"Нет дат",IF(D24<C24,"Ошибка дат",D24-C24+1)))=IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24)),NOT(ISNUMBER(F24))),"Нет данных",IF(D24<C24,"Ошибка дат",IF(F24=1,"Завершен",IF(D24<$B$5,"Просрочен","В работе")))))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(J$10>=$C24,J$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(K$10>=$C24,K$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(L$10>=$C24,L$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(M$10>=$C24,M$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(N$10>=$C24,N$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(O$10>=$C24,O$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(P$10>=$C24,P$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Q$10>=$C24,Q$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(R$10>=$C24,R$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(S$10>=$C24,S$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(T$10>=$C24,T$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(U$10>=$C24,U$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(V$10>=$C24,V$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(W$10>=$C24,W$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(X$10>=$C24,X$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Y$10>=$C24,Y$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Z$10>=$C24,Z$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AA$10>=$C24,AA$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AB$10>=$C24,AB$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AC$10>=$C24,AC$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AD$10>=$C24,AD$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AE$10>=$C24,AE$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AF$10>=$C24,AF$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AG$10>=$C24,AG$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AH$10>=$C24,AH$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AI$10>=$C24,AI$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AJ$10>=$C24,AJ$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AK$10>=$C24,AK$10<=$D24),1,""))
2515=IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25))),"Нет дат",IF(D25<C25,"Ошибка дат",D25-C25+1)))=IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25)),NOT(ISNUMBER(F25))),"Нет данных",IF(D25<C25,"Ошибка дат",IF(F25=1,"Завершен",IF(D25<$B$5,"Просрочен","В работе")))))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(J$10>=$C25,J$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(K$10>=$C25,K$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(L$10>=$C25,L$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(M$10>=$C25,M$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(N$10>=$C25,N$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(O$10>=$C25,O$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(P$10>=$C25,P$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Q$10>=$C25,Q$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(R$10>=$C25,R$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(S$10>=$C25,S$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(T$10>=$C25,T$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(U$10>=$C25,U$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(V$10>=$C25,V$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(W$10>=$C25,W$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(X$10>=$C25,X$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Y$10>=$C25,Y$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Z$10>=$C25,Z$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AA$10>=$C25,AA$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AB$10>=$C25,AB$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AC$10>=$C25,AC$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AD$10>=$C25,AD$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AE$10>=$C25,AE$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AF$10>=$C25,AF$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AG$10>=$C25,AG$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AH$10>=$C25,AH$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AI$10>=$C25,AI$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AJ$10>=$C25,AJ$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AK$10>=$C25,AK$10<=$D25),1,""))
2616=IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26))),"Нет дат",IF(D26<C26,"Ошибка дат",D26-C26+1)))=IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26)),NOT(ISNUMBER(F26))),"Нет данных",IF(D26<C26,"Ошибка дат",IF(F26=1,"Завершен",IF(D26<$B$5,"Просрочен","В работе")))))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(J$10>=$C26,J$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(K$10>=$C26,K$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(L$10>=$C26,L$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(M$10>=$C26,M$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(N$10>=$C26,N$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(O$10>=$C26,O$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(P$10>=$C26,P$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Q$10>=$C26,Q$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(R$10>=$C26,R$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(S$10>=$C26,S$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(T$10>=$C26,T$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(U$10>=$C26,U$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(V$10>=$C26,V$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(W$10>=$C26,W$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(X$10>=$C26,X$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Y$10>=$C26,Y$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Z$10>=$C26,Z$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AA$10>=$C26,AA$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AB$10>=$C26,AB$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AC$10>=$C26,AC$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AD$10>=$C26,AD$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AE$10>=$C26,AE$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AF$10>=$C26,AF$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AG$10>=$C26,AG$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AH$10>=$C26,AH$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AI$10>=$C26,AI$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AJ$10>=$C26,AJ$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AK$10>=$C26,AK$10<=$D26),1,""))
2717=IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27))),"Нет дат",IF(D27<C27,"Ошибка дат",D27-C27+1)))=IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27)),NOT(ISNUMBER(F27))),"Нет данных",IF(D27<C27,"Ошибка дат",IF(F27=1,"Завершен",IF(D27<$B$5,"Просрочен","В работе")))))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(J$10>=$C27,J$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(K$10>=$C27,K$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(L$10>=$C27,L$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(M$10>=$C27,M$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(N$10>=$C27,N$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(O$10>=$C27,O$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(P$10>=$C27,P$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Q$10>=$C27,Q$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(R$10>=$C27,R$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(S$10>=$C27,S$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(T$10>=$C27,T$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(U$10>=$C27,U$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(V$10>=$C27,V$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(W$10>=$C27,W$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(X$10>=$C27,X$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Y$10>=$C27,Y$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Z$10>=$C27,Z$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AA$10>=$C27,AA$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AB$10>=$C27,AB$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AC$10>=$C27,AC$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AD$10>=$C27,AD$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AE$10>=$C27,AE$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AF$10>=$C27,AF$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AG$10>=$C27,AG$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AH$10>=$C27,AH$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AI$10>=$C27,AI$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AJ$10>=$C27,AJ$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AK$10>=$C27,AK$10<=$D27),1,""))
2818=IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28))),"Нет дат",IF(D28<C28,"Ошибка дат",D28-C28+1)))=IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28)),NOT(ISNUMBER(F28))),"Нет данных",IF(D28<C28,"Ошибка дат",IF(F28=1,"Завершен",IF(D28<$B$5,"Просрочен","В работе")))))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(J$10>=$C28,J$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(K$10>=$C28,K$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(L$10>=$C28,L$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(M$10>=$C28,M$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(N$10>=$C28,N$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(O$10>=$C28,O$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(P$10>=$C28,P$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Q$10>=$C28,Q$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(R$10>=$C28,R$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(S$10>=$C28,S$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(T$10>=$C28,T$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(U$10>=$C28,U$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(V$10>=$C28,V$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(W$10>=$C28,W$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(X$10>=$C28,X$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Y$10>=$C28,Y$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Z$10>=$C28,Z$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AA$10>=$C28,AA$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AB$10>=$C28,AB$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AC$10>=$C28,AC$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AD$10>=$C28,AD$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AE$10>=$C28,AE$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AF$10>=$C28,AF$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AG$10>=$C28,AG$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AH$10>=$C28,AH$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AI$10>=$C28,AI$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AJ$10>=$C28,AJ$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AK$10>=$C28,AK$10<=$D28),1,""))
2919=IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29))),"Нет дат",IF(D29<C29,"Ошибка дат",D29-C29+1)))=IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29)),NOT(ISNUMBER(F29))),"Нет данных",IF(D29<C29,"Ошибка дат",IF(F29=1,"Завершен",IF(D29<$B$5,"Просрочен","В работе")))))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(J$10>=$C29,J$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(K$10>=$C29,K$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(L$10>=$C29,L$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(M$10>=$C29,M$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(N$10>=$C29,N$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(O$10>=$C29,O$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(P$10>=$C29,P$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Q$10>=$C29,Q$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(R$10>=$C29,R$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(S$10>=$C29,S$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(T$10>=$C29,T$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(U$10>=$C29,U$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(V$10>=$C29,V$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(W$10>=$C29,W$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(X$10>=$C29,X$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Y$10>=$C29,Y$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Z$10>=$C29,Z$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AA$10>=$C29,AA$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AB$10>=$C29,AB$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AC$10>=$C29,AC$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AD$10>=$C29,AD$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AE$10>=$C29,AE$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AF$10>=$C29,AF$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AG$10>=$C29,AG$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AH$10>=$C29,AH$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AI$10>=$C29,AI$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AJ$10>=$C29,AJ$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AK$10>=$C29,AK$10<=$D29),1,""))
3020=IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30))),"Нет дат",IF(D30<C30,"Ошибка дат",D30-C30+1)))=IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30)),NOT(ISNUMBER(F30))),"Нет данных",IF(D30<C30,"Ошибка дат",IF(F30=1,"Завершен",IF(D30<$B$5,"Просрочен","В работе")))))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(J$10>=$C30,J$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(K$10>=$C30,K$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(L$10>=$C30,L$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(M$10>=$C30,M$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(N$10>=$C30,N$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(O$10>=$C30,O$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(P$10>=$C30,P$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Q$10>=$C30,Q$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(R$10>=$C30,R$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(S$10>=$C30,S$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(T$10>=$C30,T$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(U$10>=$C30,U$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(V$10>=$C30,V$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(W$10>=$C30,W$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(X$10>=$C30,X$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Y$10>=$C30,Y$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Z$10>=$C30,Z$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AA$10>=$C30,AA$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AB$10>=$C30,AB$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AC$10>=$C30,AC$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AD$10>=$C30,AD$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AE$10>=$C30,AE$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AF$10>=$C30,AF$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AG$10>=$C30,AG$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AH$10>=$C30,AH$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AI$10>=$C30,AI$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AJ$10>=$C30,AJ$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AK$10>=$C30,AK$10<=$D30),1,""))
3121=IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31))),"Нет дат",IF(D31<C31,"Ошибка дат",D31-C31+1)))=IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31)),NOT(ISNUMBER(F31))),"Нет данных",IF(D31<C31,"Ошибка дат",IF(F31=1,"Завершен",IF(D31<$B$5,"Просрочен","В работе")))))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(J$10>=$C31,J$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(K$10>=$C31,K$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(L$10>=$C31,L$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(M$10>=$C31,M$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(N$10>=$C31,N$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(O$10>=$C31,O$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(P$10>=$C31,P$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Q$10>=$C31,Q$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(R$10>=$C31,R$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(S$10>=$C31,S$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(T$10>=$C31,T$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(U$10>=$C31,U$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(V$10>=$C31,V$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(W$10>=$C31,W$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(X$10>=$C31,X$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Y$10>=$C31,Y$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Z$10>=$C31,Z$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AA$10>=$C31,AA$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AB$10>=$C31,AB$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AC$10>=$C31,AC$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AD$10>=$C31,AD$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AE$10>=$C31,AE$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AF$10>=$C31,AF$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AG$10>=$C31,AG$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AH$10>=$C31,AH$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AI$10>=$C31,AI$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AJ$10>=$C31,AJ$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AK$10>=$C31,AK$10<=$D31),1,""))
3222=IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32))),"Нет дат",IF(D32<C32,"Ошибка дат",D32-C32+1)))=IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32)),NOT(ISNUMBER(F32))),"Нет данных",IF(D32<C32,"Ошибка дат",IF(F32=1,"Завершен",IF(D32<$B$5,"Просрочен","В работе")))))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(J$10>=$C32,J$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(K$10>=$C32,K$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(L$10>=$C32,L$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(M$10>=$C32,M$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(N$10>=$C32,N$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(O$10>=$C32,O$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(P$10>=$C32,P$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Q$10>=$C32,Q$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(R$10>=$C32,R$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(S$10>=$C32,S$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(T$10>=$C32,T$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(U$10>=$C32,U$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(V$10>=$C32,V$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(W$10>=$C32,W$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(X$10>=$C32,X$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Y$10>=$C32,Y$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Z$10>=$C32,Z$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AA$10>=$C32,AA$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AB$10>=$C32,AB$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AC$10>=$C32,AC$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AD$10>=$C32,AD$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AE$10>=$C32,AE$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AF$10>=$C32,AF$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AG$10>=$C32,AG$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AH$10>=$C32,AH$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AI$10>=$C32,AI$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AJ$10>=$C32,AJ$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AK$10>=$C32,AK$10<=$D32),1,""))
3323=IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33))),"Нет дат",IF(D33<C33,"Ошибка дат",D33-C33+1)))=IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33)),NOT(ISNUMBER(F33))),"Нет данных",IF(D33<C33,"Ошибка дат",IF(F33=1,"Завершен",IF(D33<$B$5,"Просрочен","В работе")))))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(J$10>=$C33,J$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(K$10>=$C33,K$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(L$10>=$C33,L$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(M$10>=$C33,M$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(N$10>=$C33,N$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(O$10>=$C33,O$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(P$10>=$C33,P$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Q$10>=$C33,Q$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(R$10>=$C33,R$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(S$10>=$C33,S$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(T$10>=$C33,T$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(U$10>=$C33,U$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(V$10>=$C33,V$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(W$10>=$C33,W$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(X$10>=$C33,X$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Y$10>=$C33,Y$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Z$10>=$C33,Z$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AA$10>=$C33,AA$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AB$10>=$C33,AB$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AC$10>=$C33,AC$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AD$10>=$C33,AD$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AE$10>=$C33,AE$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AF$10>=$C33,AF$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AG$10>=$C33,AG$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AH$10>=$C33,AH$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AI$10>=$C33,AI$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AJ$10>=$C33,AJ$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AK$10>=$C33,AK$10<=$D33),1,""))
3424=IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34))),"Нет дат",IF(D34<C34,"Ошибка дат",D34-C34+1)))=IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34)),NOT(ISNUMBER(F34))),"Нет данных",IF(D34<C34,"Ошибка дат",IF(F34=1,"Завершен",IF(D34<$B$5,"Просрочен","В работе")))))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(J$10>=$C34,J$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(K$10>=$C34,K$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(L$10>=$C34,L$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(M$10>=$C34,M$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(N$10>=$C34,N$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(O$10>=$C34,O$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(P$10>=$C34,P$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Q$10>=$C34,Q$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(R$10>=$C34,R$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(S$10>=$C34,S$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(T$10>=$C34,T$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(U$10>=$C34,U$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(V$10>=$C34,V$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(W$10>=$C34,W$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(X$10>=$C34,X$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Y$10>=$C34,Y$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Z$10>=$C34,Z$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AA$10>=$C34,AA$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AB$10>=$C34,AB$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AC$10>=$C34,AC$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AD$10>=$C34,AD$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AE$10>=$C34,AE$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AF$10>=$C34,AF$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AG$10>=$C34,AG$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AH$10>=$C34,AH$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AI$10>=$C34,AI$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AJ$10>=$C34,AJ$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AK$10>=$C34,AK$10<=$D34),1,""))
3525=IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35))),"Нет дат",IF(D35<C35,"Ошибка дат",D35-C35+1)))=IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35)),NOT(ISNUMBER(F35))),"Нет данных",IF(D35<C35,"Ошибка дат",IF(F35=1,"Завершен",IF(D35<$B$5,"Просрочен","В работе")))))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(J$10>=$C35,J$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(K$10>=$C35,K$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(L$10>=$C35,L$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(M$10>=$C35,M$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(N$10>=$C35,N$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(O$10>=$C35,O$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(P$10>=$C35,P$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Q$10>=$C35,Q$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(R$10>=$C35,R$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(S$10>=$C35,S$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(T$10>=$C35,T$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(U$10>=$C35,U$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(V$10>=$C35,V$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(W$10>=$C35,W$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(X$10>=$C35,X$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Y$10>=$C35,Y$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Z$10>=$C35,Z$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AA$10>=$C35,AA$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AB$10>=$C35,AB$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AC$10>=$C35,AC$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AD$10>=$C35,AD$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AE$10>=$C35,AE$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AF$10>=$C35,AF$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AG$10>=$C35,AG$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AH$10>=$C35,AH$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AI$10>=$C35,AI$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AJ$10>=$C35,AJ$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AK$10>=$C35,AK$10<=$D35),1,""))
3626=IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36))),"Нет дат",IF(D36<C36,"Ошибка дат",D36-C36+1)))=IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36)),NOT(ISNUMBER(F36))),"Нет данных",IF(D36<C36,"Ошибка дат",IF(F36=1,"Завершен",IF(D36<$B$5,"Просрочен","В работе")))))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(J$10>=$C36,J$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(K$10>=$C36,K$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(L$10>=$C36,L$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(M$10>=$C36,M$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(N$10>=$C36,N$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(O$10>=$C36,O$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(P$10>=$C36,P$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Q$10>=$C36,Q$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(R$10>=$C36,R$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(S$10>=$C36,S$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(T$10>=$C36,T$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(U$10>=$C36,U$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(V$10>=$C36,V$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(W$10>=$C36,W$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(X$10>=$C36,X$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Y$10>=$C36,Y$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Z$10>=$C36,Z$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AA$10>=$C36,AA$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AB$10>=$C36,AB$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AC$10>=$C36,AC$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AD$10>=$C36,AD$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AE$10>=$C36,AE$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AF$10>=$C36,AF$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AG$10>=$C36,AG$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AH$10>=$C36,AH$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AI$10>=$C36,AI$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AJ$10>=$C36,AJ$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AK$10>=$C36,AK$10<=$D36),1,""))
3727=IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37))),"Нет дат",IF(D37<C37,"Ошибка дат",D37-C37+1)))=IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37)),NOT(ISNUMBER(F37))),"Нет данных",IF(D37<C37,"Ошибка дат",IF(F37=1,"Завершен",IF(D37<$B$5,"Просрочен","В работе")))))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(J$10>=$C37,J$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(K$10>=$C37,K$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(L$10>=$C37,L$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(M$10>=$C37,M$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(N$10>=$C37,N$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(O$10>=$C37,O$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(P$10>=$C37,P$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Q$10>=$C37,Q$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(R$10>=$C37,R$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(S$10>=$C37,S$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(T$10>=$C37,T$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(U$10>=$C37,U$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(V$10>=$C37,V$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(W$10>=$C37,W$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(X$10>=$C37,X$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Y$10>=$C37,Y$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Z$10>=$C37,Z$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AA$10>=$C37,AA$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AB$10>=$C37,AB$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AC$10>=$C37,AC$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AD$10>=$C37,AD$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AE$10>=$C37,AE$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AF$10>=$C37,AF$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AG$10>=$C37,AG$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AH$10>=$C37,AH$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AI$10>=$C37,AI$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AJ$10>=$C37,AJ$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AK$10>=$C37,AK$10<=$D37),1,""))
3828=IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38))),"Нет дат",IF(D38<C38,"Ошибка дат",D38-C38+1)))=IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38)),NOT(ISNUMBER(F38))),"Нет данных",IF(D38<C38,"Ошибка дат",IF(F38=1,"Завершен",IF(D38<$B$5,"Просрочен","В работе")))))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(J$10>=$C38,J$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(K$10>=$C38,K$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(L$10>=$C38,L$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(M$10>=$C38,M$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(N$10>=$C38,N$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(O$10>=$C38,O$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(P$10>=$C38,P$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Q$10>=$C38,Q$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(R$10>=$C38,R$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(S$10>=$C38,S$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(T$10>=$C38,T$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(U$10>=$C38,U$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(V$10>=$C38,V$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(W$10>=$C38,W$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(X$10>=$C38,X$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Y$10>=$C38,Y$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Z$10>=$C38,Z$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AA$10>=$C38,AA$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AB$10>=$C38,AB$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AC$10>=$C38,AC$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AD$10>=$C38,AD$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AE$10>=$C38,AE$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AF$10>=$C38,AF$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AG$10>=$C38,AG$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AH$10>=$C38,AH$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AI$10>=$C38,AI$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AJ$10>=$C38,AJ$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AK$10>=$C38,AK$10<=$D38),1,""))
3929=IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39))),"Нет дат",IF(D39<C39,"Ошибка дат",D39-C39+1)))=IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39)),NOT(ISNUMBER(F39))),"Нет данных",IF(D39<C39,"Ошибка дат",IF(F39=1,"Завершен",IF(D39<$B$5,"Просрочен","В работе")))))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(J$10>=$C39,J$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(K$10>=$C39,K$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(L$10>=$C39,L$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(M$10>=$C39,M$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(N$10>=$C39,N$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(O$10>=$C39,O$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(P$10>=$C39,P$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Q$10>=$C39,Q$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(R$10>=$C39,R$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(S$10>=$C39,S$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(T$10>=$C39,T$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(U$10>=$C39,U$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(V$10>=$C39,V$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(W$10>=$C39,W$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(X$10>=$C39,X$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Y$10>=$C39,Y$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Z$10>=$C39,Z$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AA$10>=$C39,AA$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AB$10>=$C39,AB$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AC$10>=$C39,AC$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AD$10>=$C39,AD$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AE$10>=$C39,AE$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AF$10>=$C39,AF$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AG$10>=$C39,AG$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AH$10>=$C39,AH$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AI$10>=$C39,AI$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AJ$10>=$C39,AJ$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AK$10>=$C39,AK$10<=$D39),1,""))
4030=IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40))),"Нет дат",IF(D40<C40,"Ошибка дат",D40-C40+1)))=IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40)),NOT(ISNUMBER(F40))),"Нет данных",IF(D40<C40,"Ошибка дат",IF(F40=1,"Завершен",IF(D40<$B$5,"Просрочен","В работе")))))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(J$10>=$C40,J$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(K$10>=$C40,K$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(L$10>=$C40,L$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(M$10>=$C40,M$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(N$10>=$C40,N$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(O$10>=$C40,O$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(P$10>=$C40,P$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Q$10>=$C40,Q$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(R$10>=$C40,R$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(S$10>=$C40,S$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(T$10>=$C40,T$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(U$10>=$C40,U$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(V$10>=$C40,V$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(W$10>=$C40,W$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(X$10>=$C40,X$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Y$10>=$C40,Y$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Z$10>=$C40,Z$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AA$10>=$C40,AA$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AB$10>=$C40,AB$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AC$10>=$C40,AC$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AD$10>=$C40,AD$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AE$10>=$C40,AE$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AF$10>=$C40,AF$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AG$10>=$C40,AG$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AH$10>=$C40,AH$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AI$10>=$C40,AI$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AJ$10>=$C40,AJ$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AK$10>=$C40,AK$10<=$D40),1,""))

Лист «Пример»

СтрокаABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAK
1OBYOM / Учебный пример
2График работ
3Желтые ячейки — ввод. Белые — расчет. Инструкция в одноименном файле MD.
5Дата29.10.2026
6Просрочено этапов=IF(COUNTA(B11:B40)=0,"",COUNTIF(I11:I40,"Просрочен"))
10IDЭтапНачалоОкончаниеДнейГотовностьОтветственныйЗависимостьСтатус=$B$5+0=$B$5+1=$B$5+2=$B$5+3=$B$5+4=$B$5+5=$B$5+6=$B$5+7=$B$5+8=$B$5+9=$B$5+10=$B$5+11=$B$5+12=$B$5+13=$B$5+14=$B$5+15=$B$5+16=$B$5+17=$B$5+18=$B$5+19=$B$5+20=$B$5+21=$B$5+22=$B$5+23=$B$5+24=$B$5+25=$B$5+26=$B$5+27
111Передача фронта26.10.202626.10.2026=IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11))),"Нет дат",IF(D11<C11,"Ошибка дат",D11-C11+1)))100%Заказчик=IF(B11="","",IF(OR(NOT(ISNUMBER(C11)),NOT(ISNUMBER(D11)),NOT(ISNUMBER(F11))),"Нет данных",IF(D11<C11,"Ошибка дат",IF(F11=1,"Завершен",IF(D11<$B$5,"Просрочен","В работе")))))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(J$10>=$C11,J$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(K$10>=$C11,K$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(L$10>=$C11,L$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(M$10>=$C11,M$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(N$10>=$C11,N$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(O$10>=$C11,O$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(P$10>=$C11,P$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Q$10>=$C11,Q$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(R$10>=$C11,R$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(S$10>=$C11,S$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(T$10>=$C11,T$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(U$10>=$C11,U$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(V$10>=$C11,V$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(W$10>=$C11,W$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(X$10>=$C11,X$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Y$10>=$C11,Y$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(Z$10>=$C11,Z$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AA$10>=$C11,AA$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AB$10>=$C11,AB$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AC$10>=$C11,AC$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AD$10>=$C11,AD$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AE$10>=$C11,AE$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AF$10>=$C11,AF$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AG$10>=$C11,AG$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AH$10>=$C11,AH$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AI$10>=$C11,AI$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AJ$10>=$C11,AJ$10<=$D11),1,""))=IF(OR($B11="",$C11="",$D11=""),"",IF(AND(AK$10>=$C11,AK$10<=$D11),1,""))
122Монтаж трасс27.10.202603.11.2026=IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12))),"Нет дат",IF(D12<C12,"Ошибка дат",D12-C12+1)))25%ПодрядчикЭтап 1=IF(B12="","",IF(OR(NOT(ISNUMBER(C12)),NOT(ISNUMBER(D12)),NOT(ISNUMBER(F12))),"Нет данных",IF(D12<C12,"Ошибка дат",IF(F12=1,"Завершен",IF(D12<$B$5,"Просрочен","В работе")))))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(J$10>=$C12,J$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(K$10>=$C12,K$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(L$10>=$C12,L$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(M$10>=$C12,M$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(N$10>=$C12,N$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(O$10>=$C12,O$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(P$10>=$C12,P$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Q$10>=$C12,Q$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(R$10>=$C12,R$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(S$10>=$C12,S$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(T$10>=$C12,T$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(U$10>=$C12,U$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(V$10>=$C12,V$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(W$10>=$C12,W$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(X$10>=$C12,X$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Y$10>=$C12,Y$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(Z$10>=$C12,Z$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AA$10>=$C12,AA$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AB$10>=$C12,AB$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AC$10>=$C12,AC$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AD$10>=$C12,AD$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AE$10>=$C12,AE$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AF$10>=$C12,AF$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AG$10>=$C12,AG$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AH$10>=$C12,AH$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AI$10>=$C12,AI$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AJ$10>=$C12,AJ$10<=$D12),1,""))=IF(OR($B12="",$C12="",$D12=""),"",IF(AND(AK$10>=$C12,AK$10<=$D12),1,""))
133Испытания04.11.202606.11.2026=IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13))),"Нет дат",IF(D13<C13,"Ошибка дат",D13-C13+1)))0%НаладчикЭтап 2=IF(B13="","",IF(OR(NOT(ISNUMBER(C13)),NOT(ISNUMBER(D13)),NOT(ISNUMBER(F13))),"Нет данных",IF(D13<C13,"Ошибка дат",IF(F13=1,"Завершен",IF(D13<$B$5,"Просрочен","В работе")))))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(J$10>=$C13,J$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(K$10>=$C13,K$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(L$10>=$C13,L$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(M$10>=$C13,M$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(N$10>=$C13,N$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(O$10>=$C13,O$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(P$10>=$C13,P$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Q$10>=$C13,Q$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(R$10>=$C13,R$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(S$10>=$C13,S$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(T$10>=$C13,T$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(U$10>=$C13,U$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(V$10>=$C13,V$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(W$10>=$C13,W$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(X$10>=$C13,X$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Y$10>=$C13,Y$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(Z$10>=$C13,Z$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AA$10>=$C13,AA$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AB$10>=$C13,AB$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AC$10>=$C13,AC$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AD$10>=$C13,AD$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AE$10>=$C13,AE$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AF$10>=$C13,AF$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AG$10>=$C13,AG$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AH$10>=$C13,AH$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AI$10>=$C13,AI$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AJ$10>=$C13,AJ$10<=$D13),1,""))=IF(OR($B13="",$C13="",$D13=""),"",IF(AND(AK$10>=$C13,AK$10<=$D13),1,""))
144=IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14))),"Нет дат",IF(D14<C14,"Ошибка дат",D14-C14+1)))=IF(B14="","",IF(OR(NOT(ISNUMBER(C14)),NOT(ISNUMBER(D14)),NOT(ISNUMBER(F14))),"Нет данных",IF(D14<C14,"Ошибка дат",IF(F14=1,"Завершен",IF(D14<$B$5,"Просрочен","В работе")))))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(J$10>=$C14,J$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(K$10>=$C14,K$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(L$10>=$C14,L$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(M$10>=$C14,M$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(N$10>=$C14,N$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(O$10>=$C14,O$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(P$10>=$C14,P$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Q$10>=$C14,Q$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(R$10>=$C14,R$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(S$10>=$C14,S$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(T$10>=$C14,T$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(U$10>=$C14,U$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(V$10>=$C14,V$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(W$10>=$C14,W$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(X$10>=$C14,X$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Y$10>=$C14,Y$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(Z$10>=$C14,Z$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AA$10>=$C14,AA$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AB$10>=$C14,AB$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AC$10>=$C14,AC$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AD$10>=$C14,AD$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AE$10>=$C14,AE$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AF$10>=$C14,AF$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AG$10>=$C14,AG$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AH$10>=$C14,AH$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AI$10>=$C14,AI$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AJ$10>=$C14,AJ$10<=$D14),1,""))=IF(OR($B14="",$C14="",$D14=""),"",IF(AND(AK$10>=$C14,AK$10<=$D14),1,""))
155=IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15))),"Нет дат",IF(D15<C15,"Ошибка дат",D15-C15+1)))=IF(B15="","",IF(OR(NOT(ISNUMBER(C15)),NOT(ISNUMBER(D15)),NOT(ISNUMBER(F15))),"Нет данных",IF(D15<C15,"Ошибка дат",IF(F15=1,"Завершен",IF(D15<$B$5,"Просрочен","В работе")))))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(J$10>=$C15,J$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(K$10>=$C15,K$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(L$10>=$C15,L$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(M$10>=$C15,M$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(N$10>=$C15,N$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(O$10>=$C15,O$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(P$10>=$C15,P$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Q$10>=$C15,Q$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(R$10>=$C15,R$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(S$10>=$C15,S$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(T$10>=$C15,T$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(U$10>=$C15,U$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(V$10>=$C15,V$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(W$10>=$C15,W$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(X$10>=$C15,X$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Y$10>=$C15,Y$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(Z$10>=$C15,Z$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AA$10>=$C15,AA$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AB$10>=$C15,AB$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AC$10>=$C15,AC$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AD$10>=$C15,AD$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AE$10>=$C15,AE$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AF$10>=$C15,AF$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AG$10>=$C15,AG$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AH$10>=$C15,AH$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AI$10>=$C15,AI$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AJ$10>=$C15,AJ$10<=$D15),1,""))=IF(OR($B15="",$C15="",$D15=""),"",IF(AND(AK$10>=$C15,AK$10<=$D15),1,""))
166=IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16))),"Нет дат",IF(D16<C16,"Ошибка дат",D16-C16+1)))=IF(B16="","",IF(OR(NOT(ISNUMBER(C16)),NOT(ISNUMBER(D16)),NOT(ISNUMBER(F16))),"Нет данных",IF(D16<C16,"Ошибка дат",IF(F16=1,"Завершен",IF(D16<$B$5,"Просрочен","В работе")))))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(J$10>=$C16,J$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(K$10>=$C16,K$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(L$10>=$C16,L$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(M$10>=$C16,M$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(N$10>=$C16,N$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(O$10>=$C16,O$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(P$10>=$C16,P$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Q$10>=$C16,Q$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(R$10>=$C16,R$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(S$10>=$C16,S$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(T$10>=$C16,T$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(U$10>=$C16,U$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(V$10>=$C16,V$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(W$10>=$C16,W$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(X$10>=$C16,X$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Y$10>=$C16,Y$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(Z$10>=$C16,Z$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AA$10>=$C16,AA$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AB$10>=$C16,AB$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AC$10>=$C16,AC$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AD$10>=$C16,AD$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AE$10>=$C16,AE$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AF$10>=$C16,AF$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AG$10>=$C16,AG$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AH$10>=$C16,AH$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AI$10>=$C16,AI$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AJ$10>=$C16,AJ$10<=$D16),1,""))=IF(OR($B16="",$C16="",$D16=""),"",IF(AND(AK$10>=$C16,AK$10<=$D16),1,""))
177=IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17))),"Нет дат",IF(D17<C17,"Ошибка дат",D17-C17+1)))=IF(B17="","",IF(OR(NOT(ISNUMBER(C17)),NOT(ISNUMBER(D17)),NOT(ISNUMBER(F17))),"Нет данных",IF(D17<C17,"Ошибка дат",IF(F17=1,"Завершен",IF(D17<$B$5,"Просрочен","В работе")))))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(J$10>=$C17,J$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(K$10>=$C17,K$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(L$10>=$C17,L$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(M$10>=$C17,M$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(N$10>=$C17,N$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(O$10>=$C17,O$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(P$10>=$C17,P$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Q$10>=$C17,Q$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(R$10>=$C17,R$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(S$10>=$C17,S$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(T$10>=$C17,T$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(U$10>=$C17,U$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(V$10>=$C17,V$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(W$10>=$C17,W$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(X$10>=$C17,X$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Y$10>=$C17,Y$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(Z$10>=$C17,Z$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AA$10>=$C17,AA$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AB$10>=$C17,AB$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AC$10>=$C17,AC$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AD$10>=$C17,AD$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AE$10>=$C17,AE$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AF$10>=$C17,AF$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AG$10>=$C17,AG$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AH$10>=$C17,AH$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AI$10>=$C17,AI$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AJ$10>=$C17,AJ$10<=$D17),1,""))=IF(OR($B17="",$C17="",$D17=""),"",IF(AND(AK$10>=$C17,AK$10<=$D17),1,""))
188=IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18))),"Нет дат",IF(D18<C18,"Ошибка дат",D18-C18+1)))=IF(B18="","",IF(OR(NOT(ISNUMBER(C18)),NOT(ISNUMBER(D18)),NOT(ISNUMBER(F18))),"Нет данных",IF(D18<C18,"Ошибка дат",IF(F18=1,"Завершен",IF(D18<$B$5,"Просрочен","В работе")))))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(J$10>=$C18,J$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(K$10>=$C18,K$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(L$10>=$C18,L$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(M$10>=$C18,M$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(N$10>=$C18,N$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(O$10>=$C18,O$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(P$10>=$C18,P$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Q$10>=$C18,Q$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(R$10>=$C18,R$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(S$10>=$C18,S$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(T$10>=$C18,T$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(U$10>=$C18,U$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(V$10>=$C18,V$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(W$10>=$C18,W$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(X$10>=$C18,X$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Y$10>=$C18,Y$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(Z$10>=$C18,Z$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AA$10>=$C18,AA$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AB$10>=$C18,AB$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AC$10>=$C18,AC$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AD$10>=$C18,AD$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AE$10>=$C18,AE$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AF$10>=$C18,AF$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AG$10>=$C18,AG$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AH$10>=$C18,AH$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AI$10>=$C18,AI$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AJ$10>=$C18,AJ$10<=$D18),1,""))=IF(OR($B18="",$C18="",$D18=""),"",IF(AND(AK$10>=$C18,AK$10<=$D18),1,""))
199=IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19))),"Нет дат",IF(D19<C19,"Ошибка дат",D19-C19+1)))=IF(B19="","",IF(OR(NOT(ISNUMBER(C19)),NOT(ISNUMBER(D19)),NOT(ISNUMBER(F19))),"Нет данных",IF(D19<C19,"Ошибка дат",IF(F19=1,"Завершен",IF(D19<$B$5,"Просрочен","В работе")))))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(J$10>=$C19,J$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(K$10>=$C19,K$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(L$10>=$C19,L$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(M$10>=$C19,M$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(N$10>=$C19,N$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(O$10>=$C19,O$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(P$10>=$C19,P$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Q$10>=$C19,Q$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(R$10>=$C19,R$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(S$10>=$C19,S$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(T$10>=$C19,T$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(U$10>=$C19,U$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(V$10>=$C19,V$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(W$10>=$C19,W$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(X$10>=$C19,X$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Y$10>=$C19,Y$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(Z$10>=$C19,Z$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AA$10>=$C19,AA$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AB$10>=$C19,AB$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AC$10>=$C19,AC$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AD$10>=$C19,AD$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AE$10>=$C19,AE$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AF$10>=$C19,AF$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AG$10>=$C19,AG$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AH$10>=$C19,AH$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AI$10>=$C19,AI$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AJ$10>=$C19,AJ$10<=$D19),1,""))=IF(OR($B19="",$C19="",$D19=""),"",IF(AND(AK$10>=$C19,AK$10<=$D19),1,""))
2010=IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20))),"Нет дат",IF(D20<C20,"Ошибка дат",D20-C20+1)))=IF(B20="","",IF(OR(NOT(ISNUMBER(C20)),NOT(ISNUMBER(D20)),NOT(ISNUMBER(F20))),"Нет данных",IF(D20<C20,"Ошибка дат",IF(F20=1,"Завершен",IF(D20<$B$5,"Просрочен","В работе")))))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(J$10>=$C20,J$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(K$10>=$C20,K$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(L$10>=$C20,L$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(M$10>=$C20,M$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(N$10>=$C20,N$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(O$10>=$C20,O$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(P$10>=$C20,P$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Q$10>=$C20,Q$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(R$10>=$C20,R$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(S$10>=$C20,S$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(T$10>=$C20,T$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(U$10>=$C20,U$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(V$10>=$C20,V$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(W$10>=$C20,W$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(X$10>=$C20,X$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Y$10>=$C20,Y$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(Z$10>=$C20,Z$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AA$10>=$C20,AA$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AB$10>=$C20,AB$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AC$10>=$C20,AC$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AD$10>=$C20,AD$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AE$10>=$C20,AE$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AF$10>=$C20,AF$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AG$10>=$C20,AG$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AH$10>=$C20,AH$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AI$10>=$C20,AI$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AJ$10>=$C20,AJ$10<=$D20),1,""))=IF(OR($B20="",$C20="",$D20=""),"",IF(AND(AK$10>=$C20,AK$10<=$D20),1,""))
2111=IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21))),"Нет дат",IF(D21<C21,"Ошибка дат",D21-C21+1)))=IF(B21="","",IF(OR(NOT(ISNUMBER(C21)),NOT(ISNUMBER(D21)),NOT(ISNUMBER(F21))),"Нет данных",IF(D21<C21,"Ошибка дат",IF(F21=1,"Завершен",IF(D21<$B$5,"Просрочен","В работе")))))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(J$10>=$C21,J$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(K$10>=$C21,K$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(L$10>=$C21,L$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(M$10>=$C21,M$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(N$10>=$C21,N$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(O$10>=$C21,O$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(P$10>=$C21,P$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Q$10>=$C21,Q$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(R$10>=$C21,R$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(S$10>=$C21,S$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(T$10>=$C21,T$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(U$10>=$C21,U$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(V$10>=$C21,V$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(W$10>=$C21,W$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(X$10>=$C21,X$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Y$10>=$C21,Y$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(Z$10>=$C21,Z$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AA$10>=$C21,AA$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AB$10>=$C21,AB$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AC$10>=$C21,AC$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AD$10>=$C21,AD$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AE$10>=$C21,AE$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AF$10>=$C21,AF$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AG$10>=$C21,AG$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AH$10>=$C21,AH$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AI$10>=$C21,AI$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AJ$10>=$C21,AJ$10<=$D21),1,""))=IF(OR($B21="",$C21="",$D21=""),"",IF(AND(AK$10>=$C21,AK$10<=$D21),1,""))
2212=IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22))),"Нет дат",IF(D22<C22,"Ошибка дат",D22-C22+1)))=IF(B22="","",IF(OR(NOT(ISNUMBER(C22)),NOT(ISNUMBER(D22)),NOT(ISNUMBER(F22))),"Нет данных",IF(D22<C22,"Ошибка дат",IF(F22=1,"Завершен",IF(D22<$B$5,"Просрочен","В работе")))))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(J$10>=$C22,J$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(K$10>=$C22,K$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(L$10>=$C22,L$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(M$10>=$C22,M$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(N$10>=$C22,N$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(O$10>=$C22,O$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(P$10>=$C22,P$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Q$10>=$C22,Q$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(R$10>=$C22,R$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(S$10>=$C22,S$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(T$10>=$C22,T$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(U$10>=$C22,U$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(V$10>=$C22,V$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(W$10>=$C22,W$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(X$10>=$C22,X$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Y$10>=$C22,Y$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(Z$10>=$C22,Z$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AA$10>=$C22,AA$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AB$10>=$C22,AB$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AC$10>=$C22,AC$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AD$10>=$C22,AD$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AE$10>=$C22,AE$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AF$10>=$C22,AF$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AG$10>=$C22,AG$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AH$10>=$C22,AH$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AI$10>=$C22,AI$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AJ$10>=$C22,AJ$10<=$D22),1,""))=IF(OR($B22="",$C22="",$D22=""),"",IF(AND(AK$10>=$C22,AK$10<=$D22),1,""))
2313=IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23))),"Нет дат",IF(D23<C23,"Ошибка дат",D23-C23+1)))=IF(B23="","",IF(OR(NOT(ISNUMBER(C23)),NOT(ISNUMBER(D23)),NOT(ISNUMBER(F23))),"Нет данных",IF(D23<C23,"Ошибка дат",IF(F23=1,"Завершен",IF(D23<$B$5,"Просрочен","В работе")))))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(J$10>=$C23,J$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(K$10>=$C23,K$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(L$10>=$C23,L$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(M$10>=$C23,M$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(N$10>=$C23,N$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(O$10>=$C23,O$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(P$10>=$C23,P$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Q$10>=$C23,Q$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(R$10>=$C23,R$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(S$10>=$C23,S$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(T$10>=$C23,T$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(U$10>=$C23,U$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(V$10>=$C23,V$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(W$10>=$C23,W$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(X$10>=$C23,X$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Y$10>=$C23,Y$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(Z$10>=$C23,Z$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AA$10>=$C23,AA$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AB$10>=$C23,AB$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AC$10>=$C23,AC$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AD$10>=$C23,AD$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AE$10>=$C23,AE$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AF$10>=$C23,AF$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AG$10>=$C23,AG$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AH$10>=$C23,AH$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AI$10>=$C23,AI$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AJ$10>=$C23,AJ$10<=$D23),1,""))=IF(OR($B23="",$C23="",$D23=""),"",IF(AND(AK$10>=$C23,AK$10<=$D23),1,""))
2414=IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24))),"Нет дат",IF(D24<C24,"Ошибка дат",D24-C24+1)))=IF(B24="","",IF(OR(NOT(ISNUMBER(C24)),NOT(ISNUMBER(D24)),NOT(ISNUMBER(F24))),"Нет данных",IF(D24<C24,"Ошибка дат",IF(F24=1,"Завершен",IF(D24<$B$5,"Просрочен","В работе")))))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(J$10>=$C24,J$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(K$10>=$C24,K$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(L$10>=$C24,L$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(M$10>=$C24,M$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(N$10>=$C24,N$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(O$10>=$C24,O$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(P$10>=$C24,P$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Q$10>=$C24,Q$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(R$10>=$C24,R$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(S$10>=$C24,S$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(T$10>=$C24,T$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(U$10>=$C24,U$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(V$10>=$C24,V$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(W$10>=$C24,W$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(X$10>=$C24,X$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Y$10>=$C24,Y$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(Z$10>=$C24,Z$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AA$10>=$C24,AA$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AB$10>=$C24,AB$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AC$10>=$C24,AC$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AD$10>=$C24,AD$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AE$10>=$C24,AE$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AF$10>=$C24,AF$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AG$10>=$C24,AG$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AH$10>=$C24,AH$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AI$10>=$C24,AI$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AJ$10>=$C24,AJ$10<=$D24),1,""))=IF(OR($B24="",$C24="",$D24=""),"",IF(AND(AK$10>=$C24,AK$10<=$D24),1,""))
2515=IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25))),"Нет дат",IF(D25<C25,"Ошибка дат",D25-C25+1)))=IF(B25="","",IF(OR(NOT(ISNUMBER(C25)),NOT(ISNUMBER(D25)),NOT(ISNUMBER(F25))),"Нет данных",IF(D25<C25,"Ошибка дат",IF(F25=1,"Завершен",IF(D25<$B$5,"Просрочен","В работе")))))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(J$10>=$C25,J$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(K$10>=$C25,K$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(L$10>=$C25,L$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(M$10>=$C25,M$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(N$10>=$C25,N$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(O$10>=$C25,O$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(P$10>=$C25,P$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Q$10>=$C25,Q$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(R$10>=$C25,R$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(S$10>=$C25,S$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(T$10>=$C25,T$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(U$10>=$C25,U$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(V$10>=$C25,V$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(W$10>=$C25,W$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(X$10>=$C25,X$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Y$10>=$C25,Y$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(Z$10>=$C25,Z$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AA$10>=$C25,AA$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AB$10>=$C25,AB$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AC$10>=$C25,AC$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AD$10>=$C25,AD$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AE$10>=$C25,AE$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AF$10>=$C25,AF$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AG$10>=$C25,AG$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AH$10>=$C25,AH$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AI$10>=$C25,AI$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AJ$10>=$C25,AJ$10<=$D25),1,""))=IF(OR($B25="",$C25="",$D25=""),"",IF(AND(AK$10>=$C25,AK$10<=$D25),1,""))
2616=IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26))),"Нет дат",IF(D26<C26,"Ошибка дат",D26-C26+1)))=IF(B26="","",IF(OR(NOT(ISNUMBER(C26)),NOT(ISNUMBER(D26)),NOT(ISNUMBER(F26))),"Нет данных",IF(D26<C26,"Ошибка дат",IF(F26=1,"Завершен",IF(D26<$B$5,"Просрочен","В работе")))))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(J$10>=$C26,J$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(K$10>=$C26,K$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(L$10>=$C26,L$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(M$10>=$C26,M$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(N$10>=$C26,N$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(O$10>=$C26,O$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(P$10>=$C26,P$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Q$10>=$C26,Q$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(R$10>=$C26,R$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(S$10>=$C26,S$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(T$10>=$C26,T$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(U$10>=$C26,U$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(V$10>=$C26,V$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(W$10>=$C26,W$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(X$10>=$C26,X$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Y$10>=$C26,Y$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(Z$10>=$C26,Z$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AA$10>=$C26,AA$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AB$10>=$C26,AB$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AC$10>=$C26,AC$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AD$10>=$C26,AD$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AE$10>=$C26,AE$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AF$10>=$C26,AF$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AG$10>=$C26,AG$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AH$10>=$C26,AH$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AI$10>=$C26,AI$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AJ$10>=$C26,AJ$10<=$D26),1,""))=IF(OR($B26="",$C26="",$D26=""),"",IF(AND(AK$10>=$C26,AK$10<=$D26),1,""))
2717=IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27))),"Нет дат",IF(D27<C27,"Ошибка дат",D27-C27+1)))=IF(B27="","",IF(OR(NOT(ISNUMBER(C27)),NOT(ISNUMBER(D27)),NOT(ISNUMBER(F27))),"Нет данных",IF(D27<C27,"Ошибка дат",IF(F27=1,"Завершен",IF(D27<$B$5,"Просрочен","В работе")))))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(J$10>=$C27,J$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(K$10>=$C27,K$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(L$10>=$C27,L$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(M$10>=$C27,M$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(N$10>=$C27,N$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(O$10>=$C27,O$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(P$10>=$C27,P$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Q$10>=$C27,Q$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(R$10>=$C27,R$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(S$10>=$C27,S$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(T$10>=$C27,T$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(U$10>=$C27,U$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(V$10>=$C27,V$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(W$10>=$C27,W$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(X$10>=$C27,X$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Y$10>=$C27,Y$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(Z$10>=$C27,Z$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AA$10>=$C27,AA$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AB$10>=$C27,AB$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AC$10>=$C27,AC$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AD$10>=$C27,AD$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AE$10>=$C27,AE$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AF$10>=$C27,AF$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AG$10>=$C27,AG$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AH$10>=$C27,AH$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AI$10>=$C27,AI$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AJ$10>=$C27,AJ$10<=$D27),1,""))=IF(OR($B27="",$C27="",$D27=""),"",IF(AND(AK$10>=$C27,AK$10<=$D27),1,""))
2818=IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28))),"Нет дат",IF(D28<C28,"Ошибка дат",D28-C28+1)))=IF(B28="","",IF(OR(NOT(ISNUMBER(C28)),NOT(ISNUMBER(D28)),NOT(ISNUMBER(F28))),"Нет данных",IF(D28<C28,"Ошибка дат",IF(F28=1,"Завершен",IF(D28<$B$5,"Просрочен","В работе")))))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(J$10>=$C28,J$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(K$10>=$C28,K$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(L$10>=$C28,L$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(M$10>=$C28,M$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(N$10>=$C28,N$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(O$10>=$C28,O$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(P$10>=$C28,P$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Q$10>=$C28,Q$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(R$10>=$C28,R$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(S$10>=$C28,S$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(T$10>=$C28,T$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(U$10>=$C28,U$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(V$10>=$C28,V$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(W$10>=$C28,W$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(X$10>=$C28,X$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Y$10>=$C28,Y$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(Z$10>=$C28,Z$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AA$10>=$C28,AA$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AB$10>=$C28,AB$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AC$10>=$C28,AC$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AD$10>=$C28,AD$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AE$10>=$C28,AE$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AF$10>=$C28,AF$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AG$10>=$C28,AG$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AH$10>=$C28,AH$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AI$10>=$C28,AI$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AJ$10>=$C28,AJ$10<=$D28),1,""))=IF(OR($B28="",$C28="",$D28=""),"",IF(AND(AK$10>=$C28,AK$10<=$D28),1,""))
2919=IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29))),"Нет дат",IF(D29<C29,"Ошибка дат",D29-C29+1)))=IF(B29="","",IF(OR(NOT(ISNUMBER(C29)),NOT(ISNUMBER(D29)),NOT(ISNUMBER(F29))),"Нет данных",IF(D29<C29,"Ошибка дат",IF(F29=1,"Завершен",IF(D29<$B$5,"Просрочен","В работе")))))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(J$10>=$C29,J$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(K$10>=$C29,K$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(L$10>=$C29,L$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(M$10>=$C29,M$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(N$10>=$C29,N$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(O$10>=$C29,O$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(P$10>=$C29,P$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Q$10>=$C29,Q$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(R$10>=$C29,R$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(S$10>=$C29,S$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(T$10>=$C29,T$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(U$10>=$C29,U$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(V$10>=$C29,V$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(W$10>=$C29,W$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(X$10>=$C29,X$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Y$10>=$C29,Y$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(Z$10>=$C29,Z$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AA$10>=$C29,AA$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AB$10>=$C29,AB$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AC$10>=$C29,AC$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AD$10>=$C29,AD$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AE$10>=$C29,AE$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AF$10>=$C29,AF$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AG$10>=$C29,AG$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AH$10>=$C29,AH$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AI$10>=$C29,AI$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AJ$10>=$C29,AJ$10<=$D29),1,""))=IF(OR($B29="",$C29="",$D29=""),"",IF(AND(AK$10>=$C29,AK$10<=$D29),1,""))
3020=IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30))),"Нет дат",IF(D30<C30,"Ошибка дат",D30-C30+1)))=IF(B30="","",IF(OR(NOT(ISNUMBER(C30)),NOT(ISNUMBER(D30)),NOT(ISNUMBER(F30))),"Нет данных",IF(D30<C30,"Ошибка дат",IF(F30=1,"Завершен",IF(D30<$B$5,"Просрочен","В работе")))))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(J$10>=$C30,J$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(K$10>=$C30,K$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(L$10>=$C30,L$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(M$10>=$C30,M$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(N$10>=$C30,N$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(O$10>=$C30,O$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(P$10>=$C30,P$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Q$10>=$C30,Q$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(R$10>=$C30,R$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(S$10>=$C30,S$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(T$10>=$C30,T$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(U$10>=$C30,U$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(V$10>=$C30,V$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(W$10>=$C30,W$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(X$10>=$C30,X$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Y$10>=$C30,Y$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(Z$10>=$C30,Z$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AA$10>=$C30,AA$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AB$10>=$C30,AB$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AC$10>=$C30,AC$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AD$10>=$C30,AD$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AE$10>=$C30,AE$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AF$10>=$C30,AF$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AG$10>=$C30,AG$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AH$10>=$C30,AH$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AI$10>=$C30,AI$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AJ$10>=$C30,AJ$10<=$D30),1,""))=IF(OR($B30="",$C30="",$D30=""),"",IF(AND(AK$10>=$C30,AK$10<=$D30),1,""))
3121=IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31))),"Нет дат",IF(D31<C31,"Ошибка дат",D31-C31+1)))=IF(B31="","",IF(OR(NOT(ISNUMBER(C31)),NOT(ISNUMBER(D31)),NOT(ISNUMBER(F31))),"Нет данных",IF(D31<C31,"Ошибка дат",IF(F31=1,"Завершен",IF(D31<$B$5,"Просрочен","В работе")))))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(J$10>=$C31,J$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(K$10>=$C31,K$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(L$10>=$C31,L$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(M$10>=$C31,M$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(N$10>=$C31,N$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(O$10>=$C31,O$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(P$10>=$C31,P$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Q$10>=$C31,Q$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(R$10>=$C31,R$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(S$10>=$C31,S$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(T$10>=$C31,T$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(U$10>=$C31,U$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(V$10>=$C31,V$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(W$10>=$C31,W$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(X$10>=$C31,X$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Y$10>=$C31,Y$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(Z$10>=$C31,Z$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AA$10>=$C31,AA$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AB$10>=$C31,AB$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AC$10>=$C31,AC$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AD$10>=$C31,AD$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AE$10>=$C31,AE$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AF$10>=$C31,AF$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AG$10>=$C31,AG$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AH$10>=$C31,AH$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AI$10>=$C31,AI$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AJ$10>=$C31,AJ$10<=$D31),1,""))=IF(OR($B31="",$C31="",$D31=""),"",IF(AND(AK$10>=$C31,AK$10<=$D31),1,""))
3222=IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32))),"Нет дат",IF(D32<C32,"Ошибка дат",D32-C32+1)))=IF(B32="","",IF(OR(NOT(ISNUMBER(C32)),NOT(ISNUMBER(D32)),NOT(ISNUMBER(F32))),"Нет данных",IF(D32<C32,"Ошибка дат",IF(F32=1,"Завершен",IF(D32<$B$5,"Просрочен","В работе")))))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(J$10>=$C32,J$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(K$10>=$C32,K$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(L$10>=$C32,L$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(M$10>=$C32,M$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(N$10>=$C32,N$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(O$10>=$C32,O$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(P$10>=$C32,P$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Q$10>=$C32,Q$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(R$10>=$C32,R$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(S$10>=$C32,S$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(T$10>=$C32,T$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(U$10>=$C32,U$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(V$10>=$C32,V$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(W$10>=$C32,W$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(X$10>=$C32,X$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Y$10>=$C32,Y$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(Z$10>=$C32,Z$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AA$10>=$C32,AA$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AB$10>=$C32,AB$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AC$10>=$C32,AC$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AD$10>=$C32,AD$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AE$10>=$C32,AE$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AF$10>=$C32,AF$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AG$10>=$C32,AG$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AH$10>=$C32,AH$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AI$10>=$C32,AI$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AJ$10>=$C32,AJ$10<=$D32),1,""))=IF(OR($B32="",$C32="",$D32=""),"",IF(AND(AK$10>=$C32,AK$10<=$D32),1,""))
3323=IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33))),"Нет дат",IF(D33<C33,"Ошибка дат",D33-C33+1)))=IF(B33="","",IF(OR(NOT(ISNUMBER(C33)),NOT(ISNUMBER(D33)),NOT(ISNUMBER(F33))),"Нет данных",IF(D33<C33,"Ошибка дат",IF(F33=1,"Завершен",IF(D33<$B$5,"Просрочен","В работе")))))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(J$10>=$C33,J$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(K$10>=$C33,K$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(L$10>=$C33,L$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(M$10>=$C33,M$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(N$10>=$C33,N$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(O$10>=$C33,O$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(P$10>=$C33,P$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Q$10>=$C33,Q$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(R$10>=$C33,R$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(S$10>=$C33,S$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(T$10>=$C33,T$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(U$10>=$C33,U$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(V$10>=$C33,V$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(W$10>=$C33,W$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(X$10>=$C33,X$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Y$10>=$C33,Y$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(Z$10>=$C33,Z$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AA$10>=$C33,AA$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AB$10>=$C33,AB$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AC$10>=$C33,AC$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AD$10>=$C33,AD$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AE$10>=$C33,AE$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AF$10>=$C33,AF$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AG$10>=$C33,AG$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AH$10>=$C33,AH$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AI$10>=$C33,AI$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AJ$10>=$C33,AJ$10<=$D33),1,""))=IF(OR($B33="",$C33="",$D33=""),"",IF(AND(AK$10>=$C33,AK$10<=$D33),1,""))
3424=IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34))),"Нет дат",IF(D34<C34,"Ошибка дат",D34-C34+1)))=IF(B34="","",IF(OR(NOT(ISNUMBER(C34)),NOT(ISNUMBER(D34)),NOT(ISNUMBER(F34))),"Нет данных",IF(D34<C34,"Ошибка дат",IF(F34=1,"Завершен",IF(D34<$B$5,"Просрочен","В работе")))))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(J$10>=$C34,J$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(K$10>=$C34,K$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(L$10>=$C34,L$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(M$10>=$C34,M$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(N$10>=$C34,N$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(O$10>=$C34,O$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(P$10>=$C34,P$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Q$10>=$C34,Q$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(R$10>=$C34,R$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(S$10>=$C34,S$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(T$10>=$C34,T$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(U$10>=$C34,U$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(V$10>=$C34,V$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(W$10>=$C34,W$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(X$10>=$C34,X$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Y$10>=$C34,Y$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(Z$10>=$C34,Z$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AA$10>=$C34,AA$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AB$10>=$C34,AB$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AC$10>=$C34,AC$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AD$10>=$C34,AD$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AE$10>=$C34,AE$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AF$10>=$C34,AF$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AG$10>=$C34,AG$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AH$10>=$C34,AH$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AI$10>=$C34,AI$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AJ$10>=$C34,AJ$10<=$D34),1,""))=IF(OR($B34="",$C34="",$D34=""),"",IF(AND(AK$10>=$C34,AK$10<=$D34),1,""))
3525=IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35))),"Нет дат",IF(D35<C35,"Ошибка дат",D35-C35+1)))=IF(B35="","",IF(OR(NOT(ISNUMBER(C35)),NOT(ISNUMBER(D35)),NOT(ISNUMBER(F35))),"Нет данных",IF(D35<C35,"Ошибка дат",IF(F35=1,"Завершен",IF(D35<$B$5,"Просрочен","В работе")))))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(J$10>=$C35,J$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(K$10>=$C35,K$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(L$10>=$C35,L$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(M$10>=$C35,M$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(N$10>=$C35,N$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(O$10>=$C35,O$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(P$10>=$C35,P$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Q$10>=$C35,Q$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(R$10>=$C35,R$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(S$10>=$C35,S$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(T$10>=$C35,T$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(U$10>=$C35,U$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(V$10>=$C35,V$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(W$10>=$C35,W$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(X$10>=$C35,X$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Y$10>=$C35,Y$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(Z$10>=$C35,Z$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AA$10>=$C35,AA$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AB$10>=$C35,AB$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AC$10>=$C35,AC$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AD$10>=$C35,AD$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AE$10>=$C35,AE$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AF$10>=$C35,AF$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AG$10>=$C35,AG$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AH$10>=$C35,AH$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AI$10>=$C35,AI$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AJ$10>=$C35,AJ$10<=$D35),1,""))=IF(OR($B35="",$C35="",$D35=""),"",IF(AND(AK$10>=$C35,AK$10<=$D35),1,""))
3626=IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36))),"Нет дат",IF(D36<C36,"Ошибка дат",D36-C36+1)))=IF(B36="","",IF(OR(NOT(ISNUMBER(C36)),NOT(ISNUMBER(D36)),NOT(ISNUMBER(F36))),"Нет данных",IF(D36<C36,"Ошибка дат",IF(F36=1,"Завершен",IF(D36<$B$5,"Просрочен","В работе")))))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(J$10>=$C36,J$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(K$10>=$C36,K$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(L$10>=$C36,L$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(M$10>=$C36,M$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(N$10>=$C36,N$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(O$10>=$C36,O$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(P$10>=$C36,P$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Q$10>=$C36,Q$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(R$10>=$C36,R$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(S$10>=$C36,S$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(T$10>=$C36,T$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(U$10>=$C36,U$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(V$10>=$C36,V$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(W$10>=$C36,W$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(X$10>=$C36,X$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Y$10>=$C36,Y$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(Z$10>=$C36,Z$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AA$10>=$C36,AA$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AB$10>=$C36,AB$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AC$10>=$C36,AC$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AD$10>=$C36,AD$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AE$10>=$C36,AE$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AF$10>=$C36,AF$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AG$10>=$C36,AG$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AH$10>=$C36,AH$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AI$10>=$C36,AI$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AJ$10>=$C36,AJ$10<=$D36),1,""))=IF(OR($B36="",$C36="",$D36=""),"",IF(AND(AK$10>=$C36,AK$10<=$D36),1,""))
3727=IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37))),"Нет дат",IF(D37<C37,"Ошибка дат",D37-C37+1)))=IF(B37="","",IF(OR(NOT(ISNUMBER(C37)),NOT(ISNUMBER(D37)),NOT(ISNUMBER(F37))),"Нет данных",IF(D37<C37,"Ошибка дат",IF(F37=1,"Завершен",IF(D37<$B$5,"Просрочен","В работе")))))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(J$10>=$C37,J$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(K$10>=$C37,K$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(L$10>=$C37,L$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(M$10>=$C37,M$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(N$10>=$C37,N$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(O$10>=$C37,O$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(P$10>=$C37,P$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Q$10>=$C37,Q$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(R$10>=$C37,R$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(S$10>=$C37,S$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(T$10>=$C37,T$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(U$10>=$C37,U$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(V$10>=$C37,V$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(W$10>=$C37,W$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(X$10>=$C37,X$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Y$10>=$C37,Y$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(Z$10>=$C37,Z$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AA$10>=$C37,AA$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AB$10>=$C37,AB$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AC$10>=$C37,AC$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AD$10>=$C37,AD$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AE$10>=$C37,AE$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AF$10>=$C37,AF$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AG$10>=$C37,AG$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AH$10>=$C37,AH$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AI$10>=$C37,AI$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AJ$10>=$C37,AJ$10<=$D37),1,""))=IF(OR($B37="",$C37="",$D37=""),"",IF(AND(AK$10>=$C37,AK$10<=$D37),1,""))
3828=IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38))),"Нет дат",IF(D38<C38,"Ошибка дат",D38-C38+1)))=IF(B38="","",IF(OR(NOT(ISNUMBER(C38)),NOT(ISNUMBER(D38)),NOT(ISNUMBER(F38))),"Нет данных",IF(D38<C38,"Ошибка дат",IF(F38=1,"Завершен",IF(D38<$B$5,"Просрочен","В работе")))))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(J$10>=$C38,J$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(K$10>=$C38,K$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(L$10>=$C38,L$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(M$10>=$C38,M$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(N$10>=$C38,N$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(O$10>=$C38,O$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(P$10>=$C38,P$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Q$10>=$C38,Q$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(R$10>=$C38,R$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(S$10>=$C38,S$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(T$10>=$C38,T$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(U$10>=$C38,U$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(V$10>=$C38,V$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(W$10>=$C38,W$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(X$10>=$C38,X$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Y$10>=$C38,Y$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(Z$10>=$C38,Z$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AA$10>=$C38,AA$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AB$10>=$C38,AB$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AC$10>=$C38,AC$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AD$10>=$C38,AD$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AE$10>=$C38,AE$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AF$10>=$C38,AF$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AG$10>=$C38,AG$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AH$10>=$C38,AH$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AI$10>=$C38,AI$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AJ$10>=$C38,AJ$10<=$D38),1,""))=IF(OR($B38="",$C38="",$D38=""),"",IF(AND(AK$10>=$C38,AK$10<=$D38),1,""))
3929=IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39))),"Нет дат",IF(D39<C39,"Ошибка дат",D39-C39+1)))=IF(B39="","",IF(OR(NOT(ISNUMBER(C39)),NOT(ISNUMBER(D39)),NOT(ISNUMBER(F39))),"Нет данных",IF(D39<C39,"Ошибка дат",IF(F39=1,"Завершен",IF(D39<$B$5,"Просрочен","В работе")))))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(J$10>=$C39,J$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(K$10>=$C39,K$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(L$10>=$C39,L$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(M$10>=$C39,M$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(N$10>=$C39,N$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(O$10>=$C39,O$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(P$10>=$C39,P$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Q$10>=$C39,Q$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(R$10>=$C39,R$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(S$10>=$C39,S$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(T$10>=$C39,T$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(U$10>=$C39,U$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(V$10>=$C39,V$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(W$10>=$C39,W$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(X$10>=$C39,X$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Y$10>=$C39,Y$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(Z$10>=$C39,Z$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AA$10>=$C39,AA$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AB$10>=$C39,AB$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AC$10>=$C39,AC$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AD$10>=$C39,AD$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AE$10>=$C39,AE$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AF$10>=$C39,AF$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AG$10>=$C39,AG$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AH$10>=$C39,AH$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AI$10>=$C39,AI$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AJ$10>=$C39,AJ$10<=$D39),1,""))=IF(OR($B39="",$C39="",$D39=""),"",IF(AND(AK$10>=$C39,AK$10<=$D39),1,""))
4030=IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40))),"Нет дат",IF(D40<C40,"Ошибка дат",D40-C40+1)))=IF(B40="","",IF(OR(NOT(ISNUMBER(C40)),NOT(ISNUMBER(D40)),NOT(ISNUMBER(F40))),"Нет данных",IF(D40<C40,"Ошибка дат",IF(F40=1,"Завершен",IF(D40<$B$5,"Просрочен","В работе")))))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(J$10>=$C40,J$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(K$10>=$C40,K$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(L$10>=$C40,L$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(M$10>=$C40,M$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(N$10>=$C40,N$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(O$10>=$C40,O$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(P$10>=$C40,P$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Q$10>=$C40,Q$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(R$10>=$C40,R$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(S$10>=$C40,S$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(T$10>=$C40,T$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(U$10>=$C40,U$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(V$10>=$C40,V$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(W$10>=$C40,W$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(X$10>=$C40,X$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Y$10>=$C40,Y$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(Z$10>=$C40,Z$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AA$10>=$C40,AA$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AB$10>=$C40,AB$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AC$10>=$C40,AC$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AD$10>=$C40,AD$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AE$10>=$C40,AE$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AF$10>=$C40,AF$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AG$10>=$C40,AG$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AH$10>=$C40,AH$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AI$10>=$C40,AI$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AJ$10>=$C40,AJ$10<=$D40),1,""))=IF(OR($B40="",$C40="",$D40=""),"",IF(AND(AK$10>=$C40,AK$10<=$D40),1,""))