{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["0000","db"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"0000","index":0,"n_rows":189,"n_cols":17,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["ДАТА заключения договора",{"$f":"\"отм \"& \"(\"&COUNTIF(B2:B753,\"a\") &\")\"","v":"отм (0)"},{"$f":"\"ФИО Заемщика \" &  \"(\"&(_xlfn.AGGREGATE(3,5,$C$2:$C$754)) &\")\"","v":"ФИО Заемщика (12)"},{"$f":"\"ПТС \"& \"(\"&COUNTIF(ПТС,\"ПТС\") &\")\"","v":"ПТС (1)"},"период","день",{"$f":"\"ПФ \"& \"(\"&COUNTIF(ПФ,\"ПФ\") &\")\" & \" ПрПф \"& \"(\"&COUNTIF(ПрПф,\"ПрПф\") &\")\"","v":"ПФ (0) ПрПф (1)"},{"$f":"\"Обещали ПЕРЕОФ. \"\n& \"Cегодня \" & \"(\"& COUNTIF(J2:M376,TODAY()) & \") \"\n& \"Завтра \" & \"(\"& COUNTIF(J2:M376,TODAY()+1) & \")\"","v":"Обещали ПЕРЕОФ. Cегодня (0) Завтра (0)"},{"$f":" \"Дата  \nПЕРЕЗАКЛ-НИЯ \" & \" Закрытых \"& \"(\"&COUNTIF(Закрыт,\"Закрыт\") &\")\" & \" Выбыли \"& \"(\"&COUNTIF(Закрыт,\"ВЫБЫЛ\") &\")\"","v":"Дата  \nПЕРЕЗАКЛ-НИЯ  Закрытых (1) Выбыли (1)"},"n1","n2","n3","день/ месяц/ год",{"$f":"\"Дата оплаты по ГРАФИКУ \"&\" Сегодня \"&\"(\"&COUNTIF(N2:N436,TODAY())&\")\"&\" Завтра \"&\"(\"&COUNTIF(N2:N436,TODAY()+1)&\")\"","v":"Дата оплаты по ГРАФИКУ  Сегодня (3) Завтра (0)"},{"$f":"\"Дата оплаты по ЗАЯВЛЕНИЮ \" & \"(\"&COUNT(O2:O395) &\")\" & \" На сегодня \" &\"(\"& COUNTIF(O2:O395,TODAY()) &\")\" &\" Завтра \"&\"(\"&COUNTIF(O2:O395,TODAY()+1)&\")\"","v":"Дата оплаты по ЗАЯВЛЕНИЮ (2) На сегодня (2) Завтра (0)"},"прозвон","заявл-ие"]
["2018-06-07",null,"Акимова А.В",null,{"$f":"IF(OR(I2=\"ЗАКРЫТ\",I2=\"ВЫБЫЛ\"),\" \",F2/14)","v":1.3571428571428572},{"$f":"IF(OR(I2=\"ЗАКРЫТ\",I2=\"ВЫБЫЛ\"),\"\",(TODAY()-A2))","v":19},{"$f":"IF(I2=\"ЗАКРЫТ\", \"\", IF(OR(AND(D2=\"ПТС\", F2 = 180), AND(D2=\"\",F2 = 69)), \"ПФ\", IF(OR(AND(D2=\"ПТС\", F2>180), AND(D2=\"\", F2>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I2=\"ЗАКРЫТ\",I2=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I2:L2))","v":1},{"$f":"IF(D2=\"Ч\",\"ВЫБЫЛ\",IF(A2=\"\",\"ЗАКРЫТ\",A2+70))","v":"2018-08-16"},null,null,null,{"$f":"SUM(B4:B15)&TEXT(SUM(B4:B15)/30,\" (0,0)\")&TEXT(INT(SUM(B4:B15)/30)/12,\" (0,0)\")","v":"629 (21,0) (1,7)"},"2018-07-05"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I3=\"ЗАКРЫТ\", \"\", IF(OR(AND(D3=\"ПТС\", F3 = 180), AND(D3=\"\",F3 = 69)), \"ПФ\", IF(OR(AND(D3=\"ПТС\", F3>180), AND(D3=\"\", F3>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I3=\"ЗАКРЫТ\",I3=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I3:L3))","v":0}]
["2015-04-29",{"$f":"DATEDIF(A4,C4,\"d\")","v":14},"2015-05-13",1,null,null,{"$f":"IF(I4=\"ЗАКРЫТ\", \"\", IF(OR(AND(D4=\"ПТС\", F4 = 180), AND(D4=\"\",F4 = 69)), \"ПФ\", IF(OR(AND(D4=\"ПТС\", F4>180), AND(D4=\"\", F4>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I4=\"ЗАКРЫТ\",I4=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I4:L4))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$4:$B$17),\"\")&\" )\"","v":"1%  ( 395 )"}]
["2015-10-28",140,"2016-03-16",1,null,null,{"$f":"IF(I5=\"ЗАКРЫТ\", \"\", IF(OR(AND(D5=\"ПТС\", F5 = 180), AND(D5=\"\",F5 = 69)), \"ПФ\", IF(OR(AND(D5=\"ПТС\", F5>180), AND(D5=\"\", F5>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I5=\"ЗАКРЫТ\",I5=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I5:L5))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$4:$B$17),\"\")&\" )\"","v":"0,99%  ( 55 )"}]
["2016-03-16",42,"2016-04-27",1,null,null,{"$f":"IF(I6=\"ЗАКРЫТ\", \"\", IF(OR(AND(D6=\"ПТС\", F6 = 180), AND(D6=\"\",F6 = 69)), \"ПФ\", IF(OR(AND(D6=\"ПТС\", F6>180), AND(D6=\"\", F6>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I6=\"ЗАКРЫТ\",I6=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I6:L6))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$4:$B$17),\"\")&\" )\"","v":"0,97%  ( 198 )"}]
["2016-07-29",17,"2016-08-15",1,null,null,{"$f":"IF(I7=\"ЗАКРЫТ\", \"\", IF(OR(AND(D7=\"ПТС\", F7 = 180), AND(D7=\"\",F7 = 69)), \"ПФ\", IF(OR(AND(D7=\"ПТС\", F7>180), AND(D7=\"\", F7>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I7=\"ЗАКРЫТ\",I7=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I7:L7))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2016-09-28",84,"2016-12-21",1,null,null,{"$f":"IF(I8=\"ЗАКРЫТ\", \"\", IF(OR(AND(D8=\"ПТС\", F8 = 180), AND(D8=\"\",F8 = 69)), \"ПФ\", IF(OR(AND(D8=\"ПТС\", F8>180), AND(D8=\"\", F8>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I8=\"ЗАКРЫТ\",I8=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I8:L8))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2016-12-21",98,"2017-03-29",1,null,null,{"$f":"IF(I9=\"ЗАКРЫТ\", \"\", IF(OR(AND(D9=\"ПТС\", F9 = 180), AND(D9=\"\",F9 = 69)), \"ПФ\", IF(OR(AND(D9=\"ПТС\", F9>180), AND(D9=\"\", F9>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I9=\"ЗАКРЫТ\",I9=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I9:L9))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2017-07-05",55,"2017-08-29",0.99,null,null,{"$f":"IF(I10=\"ЗАКРЫТ\", \"\", IF(OR(AND(D10=\"ПТС\", F10 = 180), AND(D10=\"\",F10 = 69)), \"ПФ\", IF(OR(AND(D10=\"ПТС\", F10>180), AND(D10=\"\", F10>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I10=\"ЗАКРЫТ\",I10=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I10:L10))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2017-09-11",2,"2017-09-13",0.97,null,null,{"$f":"IF(I11=\"ЗАКРЫТ\", \"\", IF(OR(AND(D11=\"ПТС\", F11 = 180), AND(D11=\"\",F11 = 69)), \"ПФ\", IF(OR(AND(D11=\"ПТС\", F11>180), AND(D11=\"\", F11>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I11=\"ЗАКРЫТ\",I11=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I11:L11))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2017-10-03",9,"2017-10-12",0.97,null,null,{"$f":"IF(I12=\"ЗАКРЫТ\", \"\", IF(OR(AND(D12=\"ПТС\", F12 = 180), AND(D12=\"\",F12 = 69)), \"ПФ\", IF(OR(AND(D12=\"ПТС\", F12>180), AND(D12=\"\", F12>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I12=\"ЗАКРЫТ\",I12=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I12:L12))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2017-11-01",47,"2017-12-18",0.97,null,null,{"$f":"IF(I13=\"ЗАКРЫТ\", \"\", IF(OR(AND(D13=\"ПТС\", F13 = 180), AND(D13=\"\",F13 = 69)), \"ПФ\", IF(OR(AND(D13=\"ПТС\", F13>180), AND(D13=\"\", F13>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I13=\"ЗАКРЫТ\",I13=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I13:L13))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2017-12-28",70,"2018-03-08",0.97,null,null,{"$f":"IF(I14=\"ЗАКРЫТ\", \"\", IF(OR(AND(D14=\"ПТС\", F14 = 180), AND(D14=\"\",F14 = 69)), \"ПФ\", IF(OR(AND(D14=\"ПТС\", F14>180), AND(D14=\"\", F14>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I14=\"ЗАКРЫТ\",I14=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I14:L14))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2018-03-08",51,"2018-04-28",0.97,null,null,{"$f":"IF(I15=\"ЗАКРЫТ\", \"\", IF(OR(AND(D15=\"ПТС\", F15 = 180), AND(D15=\"\",F15 = 69)), \"ПФ\", IF(OR(AND(D15=\"ПТС\", F15>180), AND(D15=\"\", F15>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I15=\"ЗАКРЫТ\",I15=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I15:L15))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$4:$D$17,LARGE(IF(COUNTIF($D$4:$D$17,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$4:$B$17),\"\")&\" )\"","v":" )"}]
["2018-06-07",{"$f":"DATEDIF(A16,C16,\"d\")","v":19},{"$f":"TODAY()","v":"2018-06-26"},0.97,null,null,{"$f":"IF(I16=\"ЗАКРЫТ\", \"\", IF(OR(AND(D16=\"ПТС\", F16 = 180), AND(D16=\"\",F16 = 69)), \"ПФ\", IF(OR(AND(D16=\"ПТС\", F16>180), AND(D16=\"\", F16>69)), \"ПрПф\", \"\")))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(I17=\"ЗАКРЫТ\", \"\", IF(OR(AND(D17=\"ПТС\", F17 = 180), AND(D17=\"\",F17 = 69)), \"ПФ\", IF(OR(AND(D17=\"ПТС\", F17>180), AND(D17=\"\", F17>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I17=\"ЗАКРЫТ\",I17=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I17:L17))","v":0}]
["2018-05-29",null,"Ананьева Т.М.",null,{"$f":"IF(OR(I18=\"ЗАКРЫТ\",I18=\"ВЫБЫЛ\"),\" \",F18/14)","v":2},{"$f":"IF(OR(I18=\"ЗАКРЫТ\",I18=\"ВЫБЫЛ\"),\"\",(TODAY()-A18))","v":28},{"$f":"IF(I18=\"ЗАКРЫТ\", \"\", IF(OR(AND(D18=\"ПТС\", F18 = 180), AND(D18=\"\",F18 = 69)), \"ПФ\", IF(OR(AND(D18=\"ПТС\", F18>180), AND(D18=\"\", F18>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I18=\"ЗАКРЫТ\",I18=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I18:L18))","v":1},"2018-08-07",null,null,null,{"$f":"SUM(B21:B22)&TEXT(SUM(B21:B22)/30,\" (0,0)\")&TEXT(INT(SUM(B21:B22)/30)/12,\" (0,0)\")","v":"28 (0,9) (0,0)"},"2018-07-10","2018-06-26",null,"З"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I19=\"ЗАКРЫТ\", \"\", IF(OR(AND(D19=\"ПТС\", F19 = 180), AND(D19=\"\",F19 = 69)), \"ПФ\", IF(OR(AND(D19=\"ПТС\", F19>180), AND(D19=\"\", F19>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I19=\"ЗАКРЫТ\",I19=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I19:L19))","v":0}]
["2018-01-08",{"$f":"DATEDIF(A20,C20,\"d\")","v":141},"2018-05-29",1,null,null,{"$f":"IF(I20=\"ЗАКРЫТ\", \"\", IF(OR(AND(D20=\"ПТС\", F20 = 180), AND(D20=\"\",F20 = 69)), \"ПФ\", IF(OR(AND(D20=\"ПТС\", F20>180), AND(D20=\"\", F20>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I20=\"ЗАКРЫТ\",I20=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I20:L20))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$20:$D$22,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF(D20:D22,LARGE(IF(COUNTIF(D20:D22,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$20:$B$22),\"\")&\" )\"","v":"1%  ( 169 )"}]
["2018-05-29",{"$f":"DATEDIF(A21,C21,\"d\")","v":28},{"$f":"TODAY()","v":"2018-06-26"},1,null,null,{"$f":"IF(I21=\"ЗАКРЫТ\", \"\", IF(OR(AND(D21=\"ПТС\", F21 = 180), AND(D21=\"\",F21 = 69)), \"ПФ\", IF(OR(AND(D21=\"ПТС\", F21>180), AND(D21=\"\", F21>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I21=\"ЗАКРЫТ\",I21=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I21:L21))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$20:$D$21,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(#REF!))&\"% \"&\" ( \"&SUMIF($D$20:$D$21,LARGE(IF(COUNTIF($D$20:$D$21,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(#REF!)),B21:B22),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I22=\"ЗАКРЫТ\", \"\", IF(OR(AND(D22=\"ПТС\", F22 = 180), AND(D22=\"\",F22 = 69)), \"ПФ\", IF(OR(AND(D22=\"ПТС\", F22>180), AND(D22=\"\", F22>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I22=\"ЗАКРЫТ\",I22=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I22:L22))","v":0}]
["2018-05-23",null,"Архипова С.В",null,{"$f":"IF(OR(I23=\"ЗАКРЫТ\",I23=\"ВЫБЫЛ\"),\" \",F23/14)","v":2.4285714285714284},{"$f":"IF(OR(I23=\"ЗАКРЫТ\",I23=\"ВЫБЫЛ\"),\"\",(TODAY()-A23))","v":34},{"$f":"IF(I23=\"ЗАКРЫТ\", \"\", IF(OR(AND(D23=\"ПТС\", F23 = 180), AND(D23=\"\",F23 = 69)), \"ПФ\", IF(OR(AND(D23=\"ПТС\", F23>180), AND(D23=\"\", F23>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I23=\"ЗАКРЫТ\",I23=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I23:L23))","v":1},"2018-08-01",null,null,null,{"$f":"SUM(B25:B34)&TEXT(SUM(B25:B34)/30,\" (0,0)\")&TEXT(INT(SUM(B25:B34)/30)/12,\" (0,0)\")","v":"1092 (36,4) (3,0)"},"2018-06-26"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I24=\"ЗАКРЫТ\", \"\", IF(OR(AND(D24=\"ПТС\", F24 = 180), AND(D24=\"\",F24 = 69)), \"ПФ\", IF(OR(AND(D24=\"ПТС\", F24>180), AND(D24=\"\", F24>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I24=\"ЗАКРЫТ\",I24=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I24:L24))","v":0}]
["2013-01-29",{"$f":"DATEDIF(A25,C25,\"d\")","v":111},"2013-05-20",1,null,null,{"$f":"IF(I25=\"ЗАКРЫТ\", \"\", IF(OR(AND(D25=\"ПТС\", F25 = 180), AND(D25=\"\",F25 = 69)), \"ПФ\", IF(OR(AND(D25=\"ПТС\", F25>180), AND(D25=\"\", F25>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I25=\"ЗАКРЫТ\",I25=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I25:L25))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$25:$B$33),\"\")&\" )\"","v":"1%  ( 876 )"}]
["2014-07-09",434,"2015-09-16",1,null,null,{"$f":"IF(I26=\"ЗАКРЫТ\", \"\", IF(OR(AND(D26=\"ПТС\", F26 = 180), AND(D26=\"\",F26 = 69)), \"ПФ\", IF(OR(AND(D26=\"ПТС\", F26>180), AND(D26=\"\", F26>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I26=\"ЗАКРЫТ\",I26=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I26:L26))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$25:$B$33),\"\")&\" )\"","v":"0,86%  ( 216 )"}]
["2015-09-16",196,"2016-03-30",1,null,null,{"$f":"IF(I27=\"ЗАКРЫТ\", \"\", IF(OR(AND(D27=\"ПТС\", F27 = 180), AND(D27=\"\",F27 = 69)), \"ПФ\", IF(OR(AND(D27=\"ПТС\", F27>180), AND(D27=\"\", F27>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I27=\"ЗАКРЫТ\",I27=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I27:L27))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
["2016-03-30",126,"2016-08-03",1,null,null,{"$f":"IF(I28=\"ЗАКРЫТ\", \"\", IF(OR(AND(D28=\"ПТС\", F28 = 180), AND(D28=\"\",F28 = 69)), \"ПФ\", IF(OR(AND(D28=\"ПТС\", F28>180), AND(D28=\"\", F28>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I28=\"ЗАКРЫТ\",I28=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I28:L28))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
["2016-08-03",9,"2016-08-12",1,null,null,{"$f":"IF(I29=\"ЗАКРЫТ\", \"\", IF(OR(AND(D29=\"ПТС\", F29 = 180), AND(D29=\"\",F29 = 69)), \"ПФ\", IF(OR(AND(D29=\"ПТС\", F29>180), AND(D29=\"\", F29>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I29=\"ЗАКРЫТ\",I29=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I29:L29))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
["2017-02-01",84,"2017-04-26",0.86,null,null,{"$f":"IF(I30=\"ЗАКРЫТ\", \"\", IF(OR(AND(D30=\"ПТС\", F30 = 180), AND(D30=\"\",F30 = 69)), \"ПФ\", IF(OR(AND(D30=\"ПТС\", F30>180), AND(D30=\"\", F30>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I30=\"ЗАКРЫТ\",I30=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I30:L30))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
["2017-04-26",14,"2017-05-10",0.86,null,null,{"$f":"IF(I31=\"ЗАКРЫТ\", \"\", IF(OR(AND(D31=\"ПТС\", F31 = 180), AND(D31=\"\",F31 = 69)), \"ПФ\", IF(OR(AND(D31=\"ПТС\", F31>180), AND(D31=\"\", F31>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I31=\"ЗАКРЫТ\",I31=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I31:L31))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
["2018-02-28",{"$f":"DATEDIF(A32,C32,\"d\")","v":84},"2018-05-23",0.86,null,null,{"$f":"IF(I32=\"ЗАКРЫТ\", \"\", IF(OR(AND(D32=\"ПТС\", F32 = 180), AND(D32=\"\",F32 = 69)), \"ПФ\", IF(OR(AND(D32=\"ПТС\", F32>180), AND(D32=\"\", F32>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I32=\"ЗАКРЫТ\",I32=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I32:L32))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
["2018-05-23",{"$f":"DATEDIF(A33,C33,\"d\")","v":34},{"$f":"TODAY()","v":"2018-06-26"},0.86,null,null,{"$f":"IF(I33=\"ЗАКРЫТ\", \"\", IF(OR(AND(D33=\"ПТС\", F33 = 180), AND(D33=\"\",F33 = 69)), \"ПФ\", IF(OR(AND(D33=\"ПТС\", F33>180), AND(D33=\"\", F33>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I33=\"ЗАКРЫТ\",I33=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I33:L33))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$25:$D$33,LARGE(IF(COUNTIF($D$25:$D$33,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$25:$B$33),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I34=\"ЗАКРЫТ\", \"\", IF(OR(AND(D34=\"ПТС\", F34 = 180), AND(D34=\"\",F34 = 69)), \"ПФ\", IF(OR(AND(D34=\"ПТС\", F34>180), AND(D34=\"\", F34>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I34=\"ЗАКРЫТ\",I34=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I34:L34))","v":0}]
[null,null,"Авдеев С.А",null,null,null,{"$f":"IF(I35=\"ЗАКРЫТ\", \"\", IF(OR(AND(D35=\"ПТС\", F35 = 180), AND(D35=\"\",F35 = 69)), \"ПФ\", IF(OR(AND(D35=\"ПТС\", F35>180), AND(D35=\"\", F35>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I35=\"ЗАКРЫТ\",I35=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I35:L35))","v":""},"ЗАКРЫТ",null,null,null,{"$f":"SUM(B37:B38)&TEXT(SUM(B37:B38)/30,\" (0,0)\")&TEXT(INT(SUM(B37:B38)/30)/12,\" (0,0)\")","v":"14 (0,5) (0,0)"}]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I36=\"ЗАКРЫТ\", \"\", IF(OR(AND(D36=\"ПТС\", F36 = 180), AND(D36=\"\",F36 = 69)), \"ПФ\", IF(OR(AND(D36=\"ПТС\", F36>180), AND(D36=\"\", F36>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I36=\"ЗАКРЫТ\",I36=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I36:L36))","v":0}]
["2018-03-05",{"$f":"DATEDIF(A37,C37,\"d\")","v":14},"2018-03-19",0.5,null,null,{"$f":"IF(I37=\"ЗАКРЫТ\", \"\", IF(OR(AND(D37=\"ПТС\", F37 = 180), AND(D37=\"\",F37 = 69)), \"ПФ\", IF(OR(AND(D37=\"ПТС\", F37>180), AND(D37=\"\", F37>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I37=\"ЗАКРЫТ\",I37=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I37:L37))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$37:$D$38,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$37:$D$38,LARGE(IF(COUNTIF($D$37:$D$38,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$37:$B$38),\"\")&\" )\"","v":"0,5%  ( 14 )"}]
[null,null,null,null,null,null,{"$f":"IF(I38=\"ЗАКРЫТ\", \"\", IF(OR(AND(D38=\"ПТС\", F38 = 180), AND(D38=\"\",F38 = 69)), \"ПФ\", IF(OR(AND(D38=\"ПТС\", F38>180), AND(D38=\"\", F38>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I38=\"ЗАКРЫТ\",I38=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I38:L38))","v":0}]
[null,null,"Базаева Е.Е","Ч",null,null,{"$f":"IF(I39=\"ЗАКРЫТ\", \"\", IF(OR(AND(D39=\"ПТС\", F39 = 180), AND(D39=\"\",F39 = 69)), \"ПФ\", IF(OR(AND(D39=\"ПТС\", F39>180), AND(D39=\"\", F39>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I39=\"ЗАКРЫТ\",I39=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I39:L39))","v":""},"ВЫБЫЛ",null,null,null,{"$f":"SUM(B41:B52)&TEXT(SUM(B41:B52)/30,\" (0,0)\")&TEXT(INT(SUM(B41:B52)/30)/12,\" (0,0)\")","v":"1243 (41,4) (3,4)"}]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I40=\"ЗАКРЫТ\", \"\", IF(OR(AND(D40=\"ПТС\", F40 = 180), AND(D40=\"\",F40 = 69)), \"ПФ\", IF(OR(AND(D40=\"ПТС\", F40>180), AND(D40=\"\", F40>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I40=\"ЗАКРЫТ\",I40=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I40:L40))","v":0}]
["2013-01-10",{"$f":"DATEDIF(A41,C41,\"d\")","v":14},"2013-01-24",0.9,null,null,{"$f":"IF(I41=\"ЗАКРЫТ\", \"\", IF(OR(AND(D41=\"ПТС\", F41 = 180), AND(D41=\"\",F41 = 69)), \"ПФ\", IF(OR(AND(D41=\"ПТС\", F41>180), AND(D41=\"\", F41>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I41=\"ЗАКРЫТ\",I41=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I41:L41))","v":0}]
["2014-10-02",154,"2015-03-05",0.9,null,null,{"$f":"IF(I42=\"ЗАКРЫТ\", \"\", IF(OR(AND(D42=\"ПТС\", F42 = 180), AND(D42=\"\",F42 = 69)), \"ПФ\", IF(OR(AND(D42=\"ПТС\", F42>180), AND(D42=\"\", F42>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I42=\"ЗАКРЫТ\",I42=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I42:L42))","v":0}]
["2015-03-05",378,"2016-03-17",0.9,null,null,{"$f":"IF(I43=\"ЗАКРЫТ\", \"\", IF(OR(AND(D43=\"ПТС\", F43 = 180), AND(D43=\"\",F43 = 69)), \"ПФ\", IF(OR(AND(D43=\"ПТС\", F43>180), AND(D43=\"\", F43>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I43=\"ЗАКРЫТ\",I43=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I43:L43))","v":0}]
["2016-03-17",168,"2016-09-01",0.9,null,null,{"$f":"IF(I44=\"ЗАКРЫТ\", \"\", IF(OR(AND(D44=\"ПТС\", F44 = 180), AND(D44=\"\",F44 = 69)), \"ПФ\", IF(OR(AND(D44=\"ПТС\", F44>180), AND(D44=\"\", F44>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I44=\"ЗАКРЫТ\",I44=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I44:L44))","v":0}]
["2016-09-01",168,"2017-02-16",0.9,null,null,{"$f":"IF(I45=\"ЗАКРЫТ\", \"\", IF(OR(AND(D45=\"ПТС\", F45 = 180), AND(D45=\"\",F45 = 69)), \"ПФ\", IF(OR(AND(D45=\"ПТС\", F45>180), AND(D45=\"\", F45>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I45=\"ЗАКРЫТ\",I45=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I45:L45))","v":0}]
["2017-02-16",39,"2017-03-27",0.9,null,null,{"$f":"IF(I46=\"ЗАКРЫТ\", \"\", IF(OR(AND(D46=\"ПТС\", F46 = 180), AND(D46=\"\",F46 = 69)), \"ПФ\", IF(OR(AND(D46=\"ПТС\", F46>180), AND(D46=\"\", F46>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I46=\"ЗАКРЫТ\",I46=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I46:L46))","v":0}]
["2017-03-27",74,"2017-06-09",0.9,null,null,{"$f":"IF(I47=\"ЗАКРЫТ\", \"\", IF(OR(AND(D47=\"ПТС\", F47 = 180), AND(D47=\"\",F47 = 69)), \"ПФ\", IF(OR(AND(D47=\"ПТС\", F47>180), AND(D47=\"\", F47>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I47=\"ЗАКРЫТ\",I47=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I47:L47))","v":0}]
["2017-06-09",27,"2017-07-06",0.9,null,null,{"$f":"IF(I48=\"ЗАКРЫТ\", \"\", IF(OR(AND(D48=\"ПТС\", F48 = 180), AND(D48=\"\",F48 = 69)), \"ПФ\", IF(OR(AND(D48=\"ПТС\", F48>180), AND(D48=\"\", F48>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I48=\"ЗАКРЫТ\",I48=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I48:L48))","v":0}]
["2017-07-06",112,"2017-10-26",0.9,null,null,{"$f":"IF(I49=\"ЗАКРЫТ\", \"\", IF(OR(AND(D49=\"ПТС\", F49 = 180), AND(D49=\"\",F49 = 69)), \"ПФ\", IF(OR(AND(D49=\"ПТС\", F49>180), AND(D49=\"\", F49>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I49=\"ЗАКРЫТ\",I49=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I49:L49))","v":0}]
["2017-10-26",95,"2018-01-29",0.9,null,null,{"$f":"IF(I50=\"ЗАКРЫТ\", \"\", IF(OR(AND(D50=\"ПТС\", F50 = 180), AND(D50=\"\",F50 = 69)), \"ПФ\", IF(OR(AND(D50=\"ПТС\", F50>180), AND(D50=\"\", F50>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I50=\"ЗАКРЫТ\",I50=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I50:L50))","v":0}]
["2018-01-18",14,"2018-02-01",0.9,null,null,{"$f":"IF(I51=\"ЗАКРЫТ\", \"\", IF(OR(AND(D51=\"ПТС\", F51 = 180), AND(D51=\"\",F51 = 69)), \"ПФ\", IF(OR(AND(D51=\"ПТС\", F51>180), AND(D51=\"\", F51>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I51=\"ЗАКРЫТ\",I51=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I51:L51))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(I52=\"ЗАКРЫТ\", \"\", IF(OR(AND(D52=\"ПТС\", F52 = 180), AND(D52=\"\",F52 = 69)), \"ПФ\", IF(OR(AND(D52=\"ПТС\", F52>180), AND(D52=\"\", F52>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I52=\"ЗАКРЫТ\",I52=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I52:L52))","v":0}]
["2018-05-08",null,"Болотова М.В",null,{"$f":"IF(OR(I53=\"ЗАКРЫТ\",I53=\"ВЫБЫЛ\"),\" \",F53/14)","v":3.5},{"$f":"IF(OR(I53=\"ЗАКРЫТ\",I53=\"ВЫБЫЛ\"),\"\",(TODAY()-A53))","v":49},{"$f":"IF(I53=\"ЗАКРЫТ\", \"\", IF(OR(AND(D53=\"ПТС\", F53 = 180), AND(D53=\"\",F53 = 69)), \"ПФ\", IF(OR(AND(D53=\"ПТС\", F53>180), AND(D53=\"\", F53>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I53=\"ЗАКРЫТ\",I53=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I53:L53))","v":1},"2018-07-17",null,null,null,{"$f":"SUM(B55:B68)&TEXT(SUM(B55:B68)/30,\" (0,0)\")&TEXT(INT(SUM(B55:B68)/30)/12,\" (0,0)\")","v":"1263 (42,1) (3,5)"},"2018-07-03"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I54=\"ЗАКРЫТ\", \"\", IF(OR(AND(D54=\"ПТС\", F54 = 180), AND(D54=\"\",F54 = 69)), \"ПФ\", IF(OR(AND(D54=\"ПТС\", F54>180), AND(D54=\"\", F54>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I54=\"ЗАКРЫТ\",I54=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I54:L54))","v":0}]
["2013-10-10",{"$f":"DATEDIF(A55,C55,\"d\")","v":237},"2014-06-04",1,null,null,{"$f":"IF(I55=\"ЗАКРЫТ\", \"\", IF(OR(AND(D55=\"ПТС\", F55 = 180), AND(D55=\"\",F55 = 69)), \"ПФ\", IF(OR(AND(D55=\"ПТС\", F55>180), AND(D55=\"\", F55>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I55=\"ЗАКРЫТ\",I55=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I55:L55))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$55:$B$67),\"\")&\" )\"","v":"1%  ( 934 )"}]
["2014-05-22",{"$f":"DATEDIF(A56,C56,\"d\")","v":13},"2014-06-04",1,null,null,{"$f":"IF(I56=\"ЗАКРЫТ\", \"\", IF(OR(AND(D56=\"ПТС\", F56 = 180), AND(D56=\"\",F56 = 69)), \"ПФ\", IF(OR(AND(D56=\"ПТС\", F56>180), AND(D56=\"\", F56>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I56=\"ЗАКРЫТ\",I56=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I56:L56))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$55:$B$67),\"\")&\" )\"","v":"0,98%  ( 329 )"}]
["2014-06-10",154,"2014-11-11",1,null,null,{"$f":"IF(I57=\"ЗАКРЫТ\", \"\", IF(OR(AND(D57=\"ПТС\", F57 = 180), AND(D57=\"\",F57 = 69)), \"ПФ\", IF(OR(AND(D57=\"ПТС\", F57>180), AND(D57=\"\", F57>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I57=\"ЗАКРЫТ\",I57=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I57:L57))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2014-11-11",211,"2015-06-10",1,null,null,{"$f":"IF(I58=\"ЗАКРЫТ\", \"\", IF(OR(AND(D58=\"ПТС\", F58 = 180), AND(D58=\"\",F58 = 69)), \"ПФ\", IF(OR(AND(D58=\"ПТС\", F58>180), AND(D58=\"\", F58>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I58=\"ЗАКРЫТ\",I58=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I58:L58))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2015-06-10",138,"2015-10-26",1,null,null,{"$f":"IF(I59=\"ЗАКРЫТ\", \"\", IF(OR(AND(D59=\"ПТС\", F59 = 180), AND(D59=\"\",F59 = 69)), \"ПФ\", IF(OR(AND(D59=\"ПТС\", F59>180), AND(D59=\"\", F59>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I59=\"ЗАКРЫТ\",I59=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I59:L59))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2015-10-28",154,"2016-03-30",1,null,null,{"$f":"IF(I60=\"ЗАКРЫТ\", \"\", IF(OR(AND(D60=\"ПТС\", F60 = 180), AND(D60=\"\",F60 = 69)), \"ПФ\", IF(OR(AND(D60=\"ПТС\", F60>180), AND(D60=\"\", F60>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I60=\"ЗАКРЫТ\",I60=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I60:L60))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2016-03-30",27,"2016-04-26",1,null,null,{"$f":"IF(I61=\"ЗАКРЫТ\", \"\", IF(OR(AND(D61=\"ПТС\", F61 = 180), AND(D61=\"\",F61 = 69)), \"ПФ\", IF(OR(AND(D61=\"ПТС\", F61>180), AND(D61=\"\", F61>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I61=\"ЗАКРЫТ\",I61=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I61:L61))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2017-07-05",14,"2017-07-19",0.98,null,null,{"$f":"IF(I62=\"ЗАКРЫТ\", \"\", IF(OR(AND(D62=\"ПТС\", F62 = 180), AND(D62=\"\",F62 = 69)), \"ПФ\", IF(OR(AND(D62=\"ПТС\", F62>180), AND(D62=\"\", F62>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I62=\"ЗАКРЫТ\",I62=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I62:L62))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2017-08-15",28,"2017-09-12",0.98,null,null,{"$f":"IF(I63=\"ЗАКРЫТ\", \"\", IF(OR(AND(D63=\"ПТС\", F63 = 180), AND(D63=\"\",F63 = 69)), \"ПФ\", IF(OR(AND(D63=\"ПТС\", F63>180), AND(D63=\"\", F63>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I63=\"ЗАКРЫТ\",I63=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I63:L63))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2017-09-12",84,"2017-12-05",0.98,null,null,{"$f":"IF(I64=\"ЗАКРЫТ\", \"\", IF(OR(AND(D64=\"ПТС\", F64 = 180), AND(D64=\"\",F64 = 69)), \"ПФ\", IF(OR(AND(D64=\"ПТС\", F64>180), AND(D64=\"\", F64>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I64=\"ЗАКРЫТ\",I64=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I64:L64))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2017-12-05",84,"2018-02-27",0.98,null,null,{"$f":"IF(I65=\"ЗАКРЫТ\", \"\", IF(OR(AND(D65=\"ПТС\", F65 = 180), AND(D65=\"\",F65 = 69)), \"ПФ\", IF(OR(AND(D65=\"ПТС\", F65>180), AND(D65=\"\", F65>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I65=\"ЗАКРЫТ\",I65=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I65:L65))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2018-02-27",{"$f":"DATEDIF(A66,C66,\"d\")","v":70},"2018-05-08",0.98,null,null,{"$f":"IF(I66=\"ЗАКРЫТ\", \"\", IF(OR(AND(D66=\"ПТС\", F66 = 180), AND(D66=\"\",F66 = 69)), \"ПФ\", IF(OR(AND(D66=\"ПТС\", F66>180), AND(D66=\"\", F66>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I66=\"ЗАКРЫТ\",I66=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I66:L66))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
["2018-05-08",49,{"$f":"TODAY()","v":"2018-06-26"},0.98,null,null,{"$f":"IF(I67=\"ЗАКРЫТ\", \"\", IF(OR(AND(D67=\"ПТС\", F67 = 180), AND(D67=\"\",F67 = 69)), \"ПФ\", IF(OR(AND(D67=\"ПТС\", F67>180), AND(D67=\"\", F67>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I67=\"ЗАКРЫТ\",I67=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I67:L67))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$55:$D$67,LARGE(IF(COUNTIF($D$55:$D$67,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$55:$B$67),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I68=\"ЗАКРЫТ\", \"\", IF(OR(AND(D68=\"ПТС\", F68 = 180), AND(D68=\"\",F68 = 69)), \"ПФ\", IF(OR(AND(D68=\"ПТС\", F68>180), AND(D68=\"\", F68>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I68=\"ЗАКРЫТ\",I68=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I68:L68))","v":0}]
["2018-06-20",null,"Борисова Г.Ф",null,{"$f":"IF(OR(I69=\"ЗАКРЫТ\",I69=\"ВЫБЫЛ\"),\" \",F69/14)","v":0.42857142857142855},{"$f":"IF(OR(I69=\"ЗАКРЫТ\",I69=\"ВЫБЫЛ\"),\"\",(TODAY()-A69))","v":6},{"$f":"IF(I69=\"ЗАКРЫТ\", \"\", IF(OR(AND(D69=\"ПТС\", F69 = 180), AND(D69=\"\",F69 = 69)), \"ПФ\", IF(OR(AND(D69=\"ПТС\", F69>180), AND(D69=\"\", F69>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I69=\"ЗАКРЫТ\",I69=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I69:L69))","v":1},{"$f":"IF(D69=\"Ч\",\"ВЫБЫЛ\",IF(A69=\"\",\"ЗАКРЫТ\",A69+70))","v":"2018-08-29"},null,null,null,{"$f":"SUM(B71:B86)&TEXT(SUM(B71:B86)/30,\" (0,0)\")&TEXT(INT(SUM(B71:B86)/30)/12,\" (0,0)\")","v":"2376 (79,2) (6,6)"},"2018-07-04"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I70=\"ЗАКРЫТ\", \"\", IF(OR(AND(D70=\"ПТС\", F70 = 180), AND(D70=\"\",F70 = 69)), \"ПФ\", IF(OR(AND(D70=\"ПТС\", F70>180), AND(D70=\"\", F70>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I70=\"ЗАКРЫТ\",I70=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I70:L70))","v":0}]
["2011-07-01",{"$f":"DATEDIF(A71,C71,\"d\")","v":935},"2014-01-21",0.72,null,null,{"$f":"IF(I71=\"ЗАКРЫТ\", \"\", IF(OR(AND(D71=\"ПТС\", F71 = 180), AND(D71=\"\",F71 = 69)), \"ПФ\", IF(OR(AND(D71=\"ПТС\", F71>180), AND(D71=\"\", F71>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I71=\"ЗАКРЫТ\",I71=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I71:L71))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$71:$B$85),\"\")&\" )\"","v":"0,72%  ( 2376 )"}]
["2014-05-09",{"$f":"DATEDIF(A72,C72,\"d\")","v":28},"2014-06-06",0.72,null,null,{"$f":"IF(I72=\"ЗАКРЫТ\", \"\", IF(OR(AND(D72=\"ПТС\", F72 = 180), AND(D72=\"\",F72 = 69)), \"ПФ\", IF(OR(AND(D72=\"ПТС\", F72>180), AND(D72=\"\", F72>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I72=\"ЗАКРЫТ\",I72=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I72:L72))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2014-06-06",616,"2016-02-12",0.72,null,null,{"$f":"IF(I73=\"ЗАКРЫТ\", \"\", IF(OR(AND(D73=\"ПТС\", F73 = 180), AND(D73=\"\",F73 = 69)), \"ПФ\", IF(OR(AND(D73=\"ПТС\", F73>180), AND(D73=\"\", F73>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I73=\"ЗАКРЫТ\",I73=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I73:L73))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2016-02-12",56,"2016-04-08",0.72,null,null,{"$f":"IF(I74=\"ЗАКРЫТ\", \"\", IF(OR(AND(D74=\"ПТС\", F74 = 180), AND(D74=\"\",F74 = 69)), \"ПФ\", IF(OR(AND(D74=\"ПТС\", F74>180), AND(D74=\"\", F74>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I74=\"ЗАКРЫТ\",I74=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I74:L74))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2016-04-08",83,"2016-06-30",0.72,null,null,{"$f":"IF(I75=\"ЗАКРЫТ\", \"\", IF(OR(AND(D75=\"ПТС\", F75 = 180), AND(D75=\"\",F75 = 69)), \"ПФ\", IF(OR(AND(D75=\"ПТС\", F75>180), AND(D75=\"\", F75>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I75=\"ЗАКРЫТ\",I75=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I75:L75))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2016-06-30",14,"2016-07-14",0.72,null,null,{"$f":"IF(I76=\"ЗАКРЫТ\", \"\", IF(OR(AND(D76=\"ПТС\", F76 = 180), AND(D76=\"\",F76 = 69)), \"ПФ\", IF(OR(AND(D76=\"ПТС\", F76>180), AND(D76=\"\", F76>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I76=\"ЗАКРЫТ\",I76=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I76:L76))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2016-07-14",182,"2017-01-12",0.72,null,null,{"$f":"IF(I77=\"ЗАКРЫТ\", \"\", IF(OR(AND(D77=\"ПТС\", F77 = 180), AND(D77=\"\",F77 = 69)), \"ПФ\", IF(OR(AND(D77=\"ПТС\", F77>180), AND(D77=\"\", F77>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I77=\"ЗАКРЫТ\",I77=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I77:L77))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2017-01-12",44,"2017-02-25",0.72,null,null,{"$f":"IF(I78=\"ЗАКРЫТ\", \"\", IF(OR(AND(D78=\"ПТС\", F78 = 180), AND(D78=\"\",F78 = 69)), \"ПФ\", IF(OR(AND(D78=\"ПТС\", F78>180), AND(D78=\"\", F78>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I78=\"ЗАКРЫТ\",I78=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I78:L78))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2017-05-04",25,"2017-05-29",0.72,null,null,{"$f":"IF(I79=\"ЗАКРЫТ\", \"\", IF(OR(AND(D79=\"ПТС\", F79 = 180), AND(D79=\"\",F79 = 69)), \"ПФ\", IF(OR(AND(D79=\"ПТС\", F79>180), AND(D79=\"\", F79>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I79=\"ЗАКРЫТ\",I79=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I79:L79))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2017-05-29",112,"2017-09-18",0.72,null,null,{"$f":"IF(I80=\"ЗАКРЫТ\", \"\", IF(OR(AND(D80=\"ПТС\", F80 = 180), AND(D80=\"\",F80 = 69)), \"ПФ\", IF(OR(AND(D80=\"ПТС\", F80>180), AND(D80=\"\", F80>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I80=\"ЗАКРЫТ\",I80=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I80:L80))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2017-09-18",14,"2017-10-02",0.72,null,null,{"$f":"IF(I81=\"ЗАКРЫТ\", \"\", IF(OR(AND(D81=\"ПТС\", F81 = 180), AND(D81=\"\",F81 = 69)), \"ПФ\", IF(OR(AND(D81=\"ПТС\", F81>180), AND(D81=\"\", F81>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I81=\"ЗАКРЫТ\",I81=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I81:L81))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2017-10-02",112,"2018-01-22",0.72,null,null,{"$f":"IF(I82=\"ЗАКРЫТ\", \"\", IF(OR(AND(D82=\"ПТС\", F82 = 180), AND(D82=\"\",F82 = 69)), \"ПФ\", IF(OR(AND(D82=\"ПТС\", F82>180), AND(D82=\"\", F82>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I82=\"ЗАКРЫТ\",I82=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I82:L82))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2018-01-22",79,"2018-04-11",0.72,null,null,{"$f":"IF(I83=\"ЗАКРЫТ\", \"\", IF(OR(AND(D83=\"ПТС\", F83 = 180), AND(D83=\"\",F83 = 69)), \"ПФ\", IF(OR(AND(D83=\"ПТС\", F83>180), AND(D83=\"\", F83>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I83=\"ЗАКРЫТ\",I83=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I83:L83))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2018-04-11",70,"2018-06-20",0.72,null,null,{"$f":"IF(I84=\"ЗАКРЫТ\", \"\", IF(OR(AND(D84=\"ПТС\", F84 = 180), AND(D84=\"\",F84 = 69)), \"ПФ\", IF(OR(AND(D84=\"ПТС\", F84>180), AND(D84=\"\", F84>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I84=\"ЗАКРЫТ\",I84=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I84:L84))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
["2018-06-20",{"$f":"DATEDIF(A85,C85,\"d\")","v":6},{"$f":"TODAY()","v":"2018-06-26"},0.72,null,null,{"$f":"IF(I85=\"ЗАКРЫТ\", \"\", IF(OR(AND(D85=\"ПТС\", F85 = 180), AND(D85=\"\",F85 = 69)), \"ПФ\", IF(OR(AND(D85=\"ПТС\", F85>180), AND(D85=\"\", F85>69)), \"ПрПф\", \"\")))","v":""},null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15))&\"% \"&\" ( \"&SUMIF($D$71:$D$85,LARGE(IF(COUNTIF($D$71:$D$85,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15)),$B$71:$B$85),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I86=\"ЗАКРЫТ\", \"\", IF(OR(AND(D86=\"ПТС\", F86 = 180), AND(D86=\"\",F86 = 69)), \"ПФ\", IF(OR(AND(D86=\"ПТС\", F86>180), AND(D86=\"\", F86>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I86=\"ЗАКРЫТ\",I86=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I86:L86))","v":0}]
["2018-04-21",null,"Бородулина Г.Ф",null,{"$f":"IF(OR(I87=\"ЗАКРЫТ\",I87=\"ВЫБЫЛ\"),\" \",F87/14)","v":4.7142857142857144},{"$f":"IF(OR(I87=\"ЗАКРЫТ\",I87=\"ВЫБЫЛ\"),\"\",(TODAY()-A87))","v":66},{"$f":"IF(I87=\"ЗАКРЫТ\", \"\", IF(OR(AND(D87=\"ПТС\", F87 = 180), AND(D87=\"\",F87 = 69)), \"ПФ\", IF(OR(AND(D87=\"ПТС\", F87>180), AND(D87=\"\", F87>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I87=\"ЗАКРЫТ\",I87=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I87:L87))","v":1},"2018-06-30",null,null,null,{"$f":"SUM(B89:B91)&TEXT(SUM(B89:B91)/30,\" (0,0)\")&TEXT(INT(SUM(B89:B91)/30)/12,\" (0,0)\")","v":"728 (24,3) (2,0)"},"2018-06-16","2018-06-26",null,"З"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I88=\"ЗАКРЫТ\", \"\", IF(OR(AND(D88=\"ПТС\", F88 = 180), AND(D88=\"\",F88 = 69)), \"ПФ\", IF(OR(AND(D88=\"ПТС\", F88>180), AND(D88=\"\", F88>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I88=\"ЗАКРЫТ\",I88=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I88:L88))","v":0}]
["2011-08-29",{"$f":"DATEDIF(A89,C89,\"d\")","v":28},"2011-09-26",1,null,null,{"$f":"IF(I89=\"ЗАКРЫТ\", \"\", IF(OR(AND(D89=\"ПТС\", F89 = 180), AND(D89=\"\",F89 = 69)), \"ПФ\", IF(OR(AND(D89=\"ПТС\", F89>180), AND(D89=\"\", F89>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I89=\"ЗАКРЫТ\",I89=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I89:L89))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$89:$B$108),\"\")&\" )\"","v":"1%  ( 1756 )"}]
["2011-10-17",{"$f":"DATEDIF(A90,C90,\"d\")","v":364},"2012-10-15",1,null,null,{"$f":"IF(I90=\"ЗАКРЫТ\", \"\", IF(OR(AND(D90=\"ПТС\", F90 = 180), AND(D90=\"\",F90 = 69)), \"ПФ\", IF(OR(AND(D90=\"ПТС\", F90>180), AND(D90=\"\", F90>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I90=\"ЗАКРЫТ\",I90=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I90:L90))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$89:$B$108),\"\")&\" )\"","v":"0,88%  ( 525 )"}]
["2013-03-28",336,"2014-02-27",1,null,null,{"$f":"IF(I91=\"ЗАКРЫТ\", \"\", IF(OR(AND(D91=\"ПТС\", F91 = 180), AND(D91=\"\",F91 = 69)), \"ПФ\", IF(OR(AND(D91=\"ПТС\", F91>180), AND(D91=\"\", F91>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I91=\"ЗАКРЫТ\",I91=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I91:L91))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2014-04-10",42,"2014-05-22",1,null,null,{"$f":"IF(I92=\"ЗАКРЫТ\", \"\", IF(OR(AND(D92=\"ПТС\", F92 = 180), AND(D92=\"\",F92 = 69)), \"ПФ\", IF(OR(AND(D92=\"ПТС\", F92>180), AND(D92=\"\", F92>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I92=\"ЗАКРЫТ\",I92=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I92:L92))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2014-05-22",196,"2014-12-04",1,null,null,{"$f":"IF(I93=\"ЗАКРЫТ\", \"\", IF(OR(AND(D93=\"ПТС\", F93 = 180), AND(D93=\"\",F93 = 69)), \"ПФ\", IF(OR(AND(D93=\"ПТС\", F93>180), AND(D93=\"\", F93>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I93=\"ЗАКРЫТ\",I93=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I93:L93))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2014-12-04",126,"2015-04-09",1,null,null,{"$f":"IF(I94=\"ЗАКРЫТ\", \"\", IF(OR(AND(D94=\"ПТС\", F94 = 180), AND(D94=\"\",F94 = 69)), \"ПФ\", IF(OR(AND(D94=\"ПТС\", F94>180), AND(D94=\"\", F94>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I94=\"ЗАКРЫТ\",I94=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I94:L94))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2015-04-09",127,"2015-08-14",1,null,null,{"$f":"IF(I95=\"ЗАКРЫТ\", \"\", IF(OR(AND(D95=\"ПТС\", F95 = 180), AND(D95=\"\",F95 = 69)), \"ПФ\", IF(OR(AND(D95=\"ПТС\", F95>180), AND(D95=\"\", F95>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I95=\"ЗАКРЫТ\",I95=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I95:L95))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2015-08-14",113,"2015-12-05",1,null,null,{"$f":"IF(I96=\"ЗАКРЫТ\", \"\", IF(OR(AND(D96=\"ПТС\", F96 = 180), AND(D96=\"\",F96 = 69)), \"ПФ\", IF(OR(AND(D96=\"ПТС\", F96>180), AND(D96=\"\", F96>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I96=\"ЗАКРЫТ\",I96=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I96:L96))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2015-12-05",112,"2016-03-26",1,null,null,{"$f":"IF(I97=\"ЗАКРЫТ\", \"\", IF(OR(AND(D97=\"ПТС\", F97 = 180), AND(D97=\"\",F97 = 69)), \"ПФ\", IF(OR(AND(D97=\"ПТС\", F97>180), AND(D97=\"\", F97>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I97=\"ЗАКРЫТ\",I97=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I97:L97))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2016-03-26",87,"2016-06-21",1,null,null,{"$f":"IF(I98=\"ЗАКРЫТ\", \"\", IF(OR(AND(D98=\"ПТС\", F98 = 180), AND(D98=\"\",F98 = 69)), \"ПФ\", IF(OR(AND(D98=\"ПТС\", F98>180), AND(D98=\"\", F98>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I98=\"ЗАКРЫТ\",I98=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I98:L98))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2016-06-21",70,"2016-08-30",1,null,null,{"$f":"IF(I99=\"ЗАКРЫТ\", \"\", IF(OR(AND(D99=\"ПТС\", F99 = 180), AND(D99=\"\",F99 = 69)), \"ПФ\", IF(OR(AND(D99=\"ПТС\", F99>180), AND(D99=\"\", F99>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I99=\"ЗАКРЫТ\",I99=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I99:L99))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2016-08-30",98,"2016-12-06",1,null,null,{"$f":"IF(I100=\"ЗАКРЫТ\", \"\", IF(OR(AND(D100=\"ПТС\", F100 = 180), AND(D100=\"\",F100 = 69)), \"ПФ\", IF(OR(AND(D100=\"ПТС\", F100>180), AND(D100=\"\", F100>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I100=\"ЗАКРЫТ\",I100=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I100:L100))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2016-12-06",57,"2017-02-01",1,null,null,{"$f":"IF(I101=\"ЗАКРЫТ\", \"\", IF(OR(AND(D101=\"ПТС\", F101 = 180), AND(D101=\"\",F101 = 69)), \"ПФ\", IF(OR(AND(D101=\"ПТС\", F101>180), AND(D101=\"\", F101>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I101=\"ЗАКРЫТ\",I101=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I101:L101))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2017-02-03",98,"2017-05-12",0.88,null,null,{"$f":"IF(I102=\"ЗАКРЫТ\", \"\", IF(OR(AND(D102=\"ПТС\", F102 = 180), AND(D102=\"\",F102 = 69)), \"ПФ\", IF(OR(AND(D102=\"ПТС\", F102>180), AND(D102=\"\", F102>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I102=\"ЗАКРЫТ\",I102=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I102:L102))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2017-05-12",70,"2017-07-21",0.88,null,null,{"$f":"IF(I103=\"ЗАКРЫТ\", \"\", IF(OR(AND(D103=\"ПТС\", F103 = 180), AND(D103=\"\",F103 = 69)), \"ПФ\", IF(OR(AND(D103=\"ПТС\", F103>180), AND(D103=\"\", F103>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I103=\"ЗАКРЫТ\",I103=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I103:L103))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2017-07-21",74,"2017-10-03",0.88,null,null,{"$f":"IF(I104=\"ЗАКРЫТ\", \"\", IF(OR(AND(D104=\"ПТС\", F104 = 180), AND(D104=\"\",F104 = 69)), \"ПФ\", IF(OR(AND(D104=\"ПТС\", F104>180), AND(D104=\"\", F104>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I104=\"ЗАКРЫТ\",I104=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I104:L104))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A16))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A16)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2017-09-29",77,"2017-12-15",0.88,null,null,{"$f":"IF(I105=\"ЗАКРЫТ\", \"\", IF(OR(AND(D105=\"ПТС\", F105 = 180), AND(D105=\"\",F105 = 69)), \"ПФ\", IF(OR(AND(D105=\"ПТС\", F105>180), AND(D105=\"\", F105>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I105=\"ЗАКРЫТ\",I105=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I105:L105))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A17))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A17)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2017-12-08",62,"2018-02-08",0.88,null,null,{"$f":"IF(I106=\"ЗАКРЫТ\", \"\", IF(OR(AND(D106=\"ПТС\", F106 = 180), AND(D106=\"\",F106 = 69)), \"ПФ\", IF(OR(AND(D106=\"ПТС\", F106>180), AND(D106=\"\", F106>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I106=\"ЗАКРЫТ\",I106=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I106:L106))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A18))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A18)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2018-02-02",78,"2018-04-21",0.88,null,null,{"$f":"IF(I107=\"ЗАКРЫТ\", \"\", IF(OR(AND(D107=\"ПТС\", F107 = 180), AND(D107=\"\",F107 = 69)), \"ПФ\", IF(OR(AND(D107=\"ПТС\", F107>180), AND(D107=\"\", F107>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I107=\"ЗАКРЫТ\",I107=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I107:L107))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A19))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A19)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
["2018-04-21",66,{"$f":"TODAY()","v":"2018-06-26"},0.88,null,null,{"$f":"IF(I108=\"ЗАКРЫТ\", \"\", IF(OR(AND(D108=\"ПТС\", F108 = 180), AND(D108=\"\",F108 = 69)), \"ПФ\", IF(OR(AND(D108=\"ПТС\", F108>180), AND(D108=\"\", F108>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I108=\"ЗАКРЫТ\",I108=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I108:L108))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A20))&\"% \"&\" ( \"&SUMIF($D$89:$D$108,LARGE(IF(COUNTIF($D$89:$D$108,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A20)),$B$89:$B$108),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I109=\"ЗАКРЫТ\", \"\", IF(OR(AND(D109=\"ПТС\", F109 = 180), AND(D109=\"\",F109 = 69)), \"ПФ\", IF(OR(AND(D109=\"ПТС\", F109>180), AND(D109=\"\", F109>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I109=\"ЗАКРЫТ\",I109=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I109:L109))","v":0}]
["2018-06-14",null,"Брянкин А.С",null,{"$f":"IF(OR(I110=\"ЗАКРЫТ\",I110=\"ВЫБЫЛ\"),\" \",F110/14)","v":0.8571428571428571},{"$f":"IF(OR(I110=\"ЗАКРЫТ\",I110=\"ВЫБЫЛ\"),\"\",(TODAY()-A110))","v":12},{"$f":"IF(I110=\"ЗАКРЫТ\", \"\", IF(OR(AND(D110=\"ПТС\", F110 = 180), AND(D110=\"\",F110 = 69)), \"ПФ\", IF(OR(AND(D110=\"ПТС\", F110>180), AND(D110=\"\", F110>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I110=\"ЗАКРЫТ\",I110=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I110:L110))","v":1},{"$f":"IF(OR($D$110=\"Ч\",$D$110=\"Р\"),\"ВЫБЫЛ\",IF($A$110=\"\",\"ЗАКРЫТ\",$A$110+70))","v":"2018-08-23"},null,null,null,{"$f":"SUM(B112:B127)&TEXT(SUM(B112:B127)/30,\" (0,0)\")&TEXT(INT(SUM(B112:B127)/30)/12,\" (0,0)\")","v":"2033 (67,8) (5,6)"},"2018-06-26"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I111=\"ЗАКРЫТ\", \"\", IF(OR(AND(D111=\"ПТС\", F111 = 180), AND(D111=\"\",F111 = 69)), \"ПФ\", IF(OR(AND(D111=\"ПТС\", F111>180), AND(D111=\"\", F111>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I111=\"ЗАКРЫТ\",I111=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I111:L111))","v":0}]
["2012-06-20",{"$f":"DATEDIF(A112,C112,\"d\")","v":558},"2013-12-30",1,null,null,{"$f":"IF(I112=\"ЗАКРЫТ\", \"\", IF(OR(AND(D112=\"ПТС\", F112 = 180), AND(D112=\"\",F112 = 69)), \"ПФ\", IF(OR(AND(D112=\"ПТС\", F112>180), AND(D112=\"\", F112>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I112=\"ЗАКРЫТ\",I112=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I112:L112))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$112:$B$126),\"\")&\" )\"","v":"1%  ( 824 )"}]
["2014-04-24",{"$f":"DATEDIF(A113,C113,\"d\")","v":266},"2015-01-15",1,null,null,{"$f":"IF(I113=\"ЗАКРЫТ\", \"\", IF(OR(AND(D113=\"ПТС\", F113 = 180), AND(D113=\"\",F113 = 69)), \"ПФ\", IF(OR(AND(D113=\"ПТС\", F113>180), AND(D113=\"\", F113>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I113=\"ЗАКРЫТ\",I113=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I113:L113))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$112:$B$126),\"\")&\" )\"","v":"0,97%  ( 1197 )"}]
["2015-01-15",98,"2015-04-23",0.97,null,null,{"$f":"IF(I114=\"ЗАКРЫТ\", \"\", IF(OR(AND(D114=\"ПТС\", F114 = 180), AND(D114=\"\",F114 = 69)), \"ПФ\", IF(OR(AND(D114=\"ПТС\", F114>180), AND(D114=\"\", F114>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I114=\"ЗАКРЫТ\",I114=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I114:L114))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$112:$B$126),\"\")&\" )\"","v":"0,88%  ( 12 )"}]
["2015-05-12",42,"2015-06-23",0.97,null,null,{"$f":"IF(I115=\"ЗАКРЫТ\", \"\", IF(OR(AND(D115=\"ПТС\", F115 = 180), AND(D115=\"\",F115 = 69)), \"ПФ\", IF(OR(AND(D115=\"ПТС\", F115>180), AND(D115=\"\", F115>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I115=\"ЗАКРЫТ\",I115=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I115:L115))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2015-06-23",140,"2015-11-10",0.97,null,null,{"$f":"IF(I116=\"ЗАКРЫТ\", \"\", IF(OR(AND(D116=\"ПТС\", F116 = 180), AND(D116=\"\",F116 = 69)), \"ПФ\", IF(OR(AND(D116=\"ПТС\", F116>180), AND(D116=\"\", F116>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I116=\"ЗАКРЫТ\",I116=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I116:L116))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2015-11-10",42,"2015-12-22",0.97,null,null,{"$f":"IF(I117=\"ЗАКРЫТ\", \"\", IF(OR(AND(D117=\"ПТС\", F117 = 180), AND(D117=\"\",F117 = 69)), \"ПФ\", IF(OR(AND(D117=\"ПТС\", F117>180), AND(D117=\"\", F117>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I117=\"ЗАКРЫТ\",I117=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I117:L117))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2015-12-22",98,"2016-03-29",0.97,null,null,{"$f":"IF(I118=\"ЗАКРЫТ\", \"\", IF(OR(AND(D118=\"ПТС\", F118 = 180), AND(D118=\"\",F118 = 69)), \"ПФ\", IF(OR(AND(D118=\"ПТС\", F118>180), AND(D118=\"\", F118>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I118=\"ЗАКРЫТ\",I118=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I118:L118))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2016-03-29",112,"2016-07-19",0.97,null,null,{"$f":"IF(I119=\"ЗАКРЫТ\", \"\", IF(OR(AND(D119=\"ПТС\", F119 = 180), AND(D119=\"\",F119 = 69)), \"ПФ\", IF(OR(AND(D119=\"ПТС\", F119>180), AND(D119=\"\", F119>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I119=\"ЗАКРЫТ\",I119=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I119:L119))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2016-07-19",168,"2017-01-03",0.97,null,null,{"$f":"IF(I120=\"ЗАКРЫТ\", \"\", IF(OR(AND(D120=\"ПТС\", F120 = 180), AND(D120=\"\",F120 = 69)), \"ПФ\", IF(OR(AND(D120=\"ПТС\", F120>180), AND(D120=\"\", F120>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I120=\"ЗАКРЫТ\",I120=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I120:L120))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2017-01-03",182,"2017-07-04",0.97,null,null,{"$f":"IF(I121=\"ЗАКРЫТ\", \"\", IF(OR(AND(D121=\"ПТС\", F121 = 180), AND(D121=\"\",F121 = 69)), \"ПФ\", IF(OR(AND(D121=\"ПТС\", F121>180), AND(D121=\"\", F121>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I121=\"ЗАКРЫТ\",I121=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I121:L121))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2017-07-04",154,"2017-12-05",0.97,null,null,{"$f":"IF(I122=\"ЗАКРЫТ\", \"\", IF(OR(AND(D122=\"ПТС\", F122 = 180), AND(D122=\"\",F122 = 69)), \"ПФ\", IF(OR(AND(D122=\"ПТС\", F122>180), AND(D122=\"\", F122>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I122=\"ЗАКРЫТ\",I122=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I122:L122))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2017-12-05",70,"2018-02-13",0.97,null,null,{"$f":"IF(I123=\"ЗАКРЫТ\", \"\", IF(OR(AND(D123=\"ПТС\", F123 = 180), AND(D123=\"\",F123 = 69)), \"ПФ\", IF(OR(AND(D123=\"ПТС\", F123>180), AND(D123=\"\", F123>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I123=\"ЗАКРЫТ\",I123=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I123:L123))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2018-02-13",70,"2018-04-24",0.97,null,null,{"$f":"IF(I124=\"ЗАКРЫТ\", \"\", IF(OR(AND(D124=\"ПТС\", F124 = 180), AND(D124=\"\",F124 = 69)), \"ПФ\", IF(OR(AND(D124=\"ПТС\", F124>180), AND(D124=\"\", F124>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I124=\"ЗАКРЫТ\",I124=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I124:L124))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2018-04-24",21,"2018-05-15",0.97,null,null,{"$f":"IF(I125=\"ЗАКРЫТ\", \"\", IF(OR(AND(D125=\"ПТС\", F125 = 180), AND(D125=\"\",F125 = 69)), \"ПФ\", IF(OR(AND(D125=\"ПТС\", F125>180), AND(D125=\"\", F125>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I125=\"ЗАКРЫТ\",I125=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I125:L125))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
["2018-06-14",12,{"$f":"TODAY()","v":"2018-06-26"},0.88,null,null,{"$f":"IF(I126=\"ЗАКРЫТ\", \"\", IF(OR(AND(D126=\"ПТС\", F126 = 180), AND(D126=\"\",F126 = 69)), \"ПФ\", IF(OR(AND(D126=\"ПТС\", F126>180), AND(D126=\"\", F126>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I126=\"ЗАКРЫТ\",I126=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I126:L126))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15))&\"% \"&\" ( \"&SUMIF($D$112:$D$126,LARGE(IF(COUNTIF($D$112:$D$126,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15)),$B$112:$B$126),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I127=\"ЗАКРЫТ\", \"\", IF(OR(AND(D127=\"ПТС\", F127 = 180), AND(D127=\"\",F127 = 69)), \"ПФ\", IF(OR(AND(D127=\"ПТС\", F127>180), AND(D127=\"\", F127>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I127=\"ЗАКРЫТ\",I127=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I127:L127))","v":0}]
["2018-04-09",null,"Вихляева Н.С",null,{"$f":"IF(OR(I128=\"ЗАКРЫТ\",I128=\"ВЫБЫЛ\"),\" \",F128/14)","v":5.5714285714285712},{"$f":"IF(OR(I128=\"ЗАКРЫТ\",I128=\"ВЫБЫЛ\"),\"\",(TODAY()-A128))","v":78},{"$f":"IF(I128=\"ЗАКРЫТ\", \"\", IF(OR(AND(D128=\"ПТС\", F128 = 180), AND(D128=\"\",F128 = 69)), \"ПФ\", IF(OR(AND(D128=\"ПТС\", F128>180), AND(D128=\"\", F128>69)), \"ПрПф\", \"\")))","v":"ПрПф"},{"$f":"IF(OR(I128=\"ЗАКРЫТ\",I128=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I128:L128))","v":1},"2018-06-18",null,null,null,{"$f":"SUM(B130:B145)&TEXT(SUM(B130:B145)/30,\" (0,0)\")&TEXT(INT(SUM(B130:B145)/30)/12,\" (0,0)\")","v":"2468 (82,3) (6,8)"},"2018-07-02"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I129=\"ЗАКРЫТ\", \"\", IF(OR(AND(D129=\"ПТС\", F129 = 180), AND(D129=\"\",F129 = 69)), \"ПФ\", IF(OR(AND(D129=\"ПТС\", F129>180), AND(D129=\"\", F129>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I129=\"ЗАКРЫТ\",I129=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I129:L129))","v":0}]
["2010-05-07",{"$f":"DATEDIF(A130,C130,\"d\")","v":168},"2010-10-22",1,null,null,{"$f":"IF(I130=\"ЗАКРЫТ\", \"\", IF(OR(AND(D130=\"ПТС\", F130 = 180), AND(D130=\"\",F130 = 69)), \"ПФ\", IF(OR(AND(D130=\"ПТС\", F130>180), AND(D130=\"\", F130>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I130=\"ЗАКРЫТ\",I130=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I130:L130))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$130:$B$145),\"\")&\" )\"","v":"1%  ( 1712 )"}]
["2010-11-03",{"$f":"DATEDIF(A131,C131,\"d\")","v":321},"2011-09-20",1,null,null,{"$f":"IF(I131=\"ЗАКРЫТ\", \"\", IF(OR(AND(D131=\"ПТС\", F131 = 180), AND(D131=\"\",F131 = 69)), \"ПФ\", IF(OR(AND(D131=\"ПТС\", F131>180), AND(D131=\"\", F131>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I131=\"ЗАКРЫТ\",I131=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I131:L131))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$130:$B$145),\"\")&\" )\"","v":"0,9%  ( 552 )"}]
["2011-10-18",605,"2013-06-14",1,null,null,{"$f":"IF(I132=\"ЗАКРЫТ\", \"\", IF(OR(AND(D132=\"ПТС\", F132 = 180), AND(D132=\"\",F132 = 69)), \"ПФ\", IF(OR(AND(D132=\"ПТС\", F132>180), AND(D132=\"\", F132>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I132=\"ЗАКРЫТ\",I132=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I132:L132))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$130:$B$145),\"\")&\" )\"","v":"0,8%  ( 204 )"}]
["2014-03-31",129,"2014-08-07",1,null,null,{"$f":"IF(I133=\"ЗАКРЫТ\", \"\", IF(OR(AND(D133=\"ПТС\", F133 = 180), AND(D133=\"\",F133 = 69)), \"ПФ\", IF(OR(AND(D133=\"ПТС\", F133>180), AND(D133=\"\", F133>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I133=\"ЗАКРЫТ\",I133=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I133:L133))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2014-08-07",209,"2015-03-04",1,null,null,{"$f":"IF(I134=\"ЗАКРЫТ\", \"\", IF(OR(AND(D134=\"ПТС\", F134 = 180), AND(D134=\"\",F134 = 69)), \"ПФ\", IF(OR(AND(D134=\"ПТС\", F134>180), AND(D134=\"\", F134>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I134=\"ЗАКРЫТ\",I134=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I134:L134))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2015-03-05",168,"2015-08-20",1,null,null,{"$f":"IF(I135=\"ЗАКРЫТ\", \"\", IF(OR(AND(D135=\"ПТС\", F135 = 180), AND(D135=\"\",F135 = 69)), \"ПФ\", IF(OR(AND(D135=\"ПТС\", F135>180), AND(D135=\"\", F135>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I135=\"ЗАКРЫТ\",I135=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I135:L135))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2015-08-20",112,"2015-12-10",1,null,null,{"$f":"IF(I136=\"ЗАКРЫТ\", \"\", IF(OR(AND(D136=\"ПТС\", F136 = 180), AND(D136=\"\",F136 = 69)), \"ПФ\", IF(OR(AND(D136=\"ПТС\", F136>180), AND(D136=\"\", F136>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I136=\"ЗАКРЫТ\",I136=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I136:L136))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2016-04-06",126,"2016-08-10",0.9,null,null,{"$f":"IF(I137=\"ЗАКРЫТ\", \"\", IF(OR(AND(D137=\"ПТС\", F137 = 180), AND(D137=\"\",F137 = 69)), \"ПФ\", IF(OR(AND(D137=\"ПТС\", F137>180), AND(D137=\"\", F137>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I137=\"ЗАКРЫТ\",I137=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I137:L137))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2016-08-10",98,"2016-11-16",0.9,null,null,{"$f":"IF(I138=\"ЗАКРЫТ\", \"\", IF(OR(AND(D138=\"ПТС\", F138 = 180), AND(D138=\"\",F138 = 69)), \"ПФ\", IF(OR(AND(D138=\"ПТС\", F138>180), AND(D138=\"\", F138>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I138=\"ЗАКРЫТ\",I138=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I138:L138))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2016-11-16",27,"2016-12-13",0.9,null,null,{"$f":"IF(I139=\"ЗАКРЫТ\", \"\", IF(OR(AND(D139=\"ПТС\", F139 = 180), AND(D139=\"\",F139 = 69)), \"ПФ\", IF(OR(AND(D139=\"ПТС\", F139>180), AND(D139=\"\", F139>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I139=\"ЗАКРЫТ\",I139=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I139:L139))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2017-01-27",98,"2017-05-05",0.9,null,null,{"$f":"IF(I140=\"ЗАКРЫТ\", \"\", IF(OR(AND(D140=\"ПТС\", F140 = 180), AND(D140=\"\",F140 = 69)), \"ПФ\", IF(OR(AND(D140=\"ПТС\", F140>180), AND(D140=\"\", F140>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I140=\"ЗАКРЫТ\",I140=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I140:L140))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2017-05-05",84,"2017-07-28",0.9,null,null,{"$f":"IF(I141=\"ЗАКРЫТ\", \"\", IF(OR(AND(D141=\"ПТС\", F141 = 180), AND(D141=\"\",F141 = 69)), \"ПФ\", IF(OR(AND(D141=\"ПТС\", F141>180), AND(D141=\"\", F141>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I141=\"ЗАКРЫТ\",I141=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I141:L141))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2017-07-28",119,"2017-11-24",0.9,null,null,{"$f":"IF(I142=\"ЗАКРЫТ\", \"\", IF(OR(AND(D142=\"ПТС\", F142 = 180), AND(D142=\"\",F142 = 69)), \"ПФ\", IF(OR(AND(D142=\"ПТС\", F142>180), AND(D142=\"\", F142>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I142=\"ЗАКРЫТ\",I142=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I142:L142))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2017-12-04",70,"2018-02-12",0.8,null,null,{"$f":"IF(I143=\"ЗАКРЫТ\", \"\", IF(OR(AND(D143=\"ПТС\", F143 = 180), AND(D143=\"\",F143 = 69)), \"ПФ\", IF(OR(AND(D143=\"ПТС\", F143>180), AND(D143=\"\", F143>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I143=\"ЗАКРЫТ\",I143=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I143:L143))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2018-02-12",56,"2018-04-09",0.8,null,null,{"$f":"IF(I144=\"ЗАКРЫТ\", \"\", IF(OR(AND(D144=\"ПТС\", F144 = 180), AND(D144=\"\",F144 = 69)), \"ПФ\", IF(OR(AND(D144=\"ПТС\", F144>180), AND(D144=\"\", F144>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I144=\"ЗАКРЫТ\",I144=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I144:L144))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
["2018-04-09",78,{"$f":"TODAY()","v":"2018-06-26"},0.8,null,null,{"$f":"IF(I145=\"ЗАКРЫТ\", \"\", IF(OR(AND(D145=\"ПТС\", F145 = 180), AND(D145=\"\",F145 = 69)), \"ПФ\", IF(OR(AND(D145=\"ПТС\", F145>180), AND(D145=\"\", F145>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I145=\"ЗАКРЫТ\",I145=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I145:L145))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A16))&\"% \"&\" ( \"&SUMIF($D$130:$D$145,LARGE(IF(COUNTIF($D$130:$D$145,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A16)),$B$130:$B$145),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I146=\"ЗАКРЫТ\", \"\", IF(OR(AND(D146=\"ПТС\", F146 = 180), AND(D146=\"\",F146 = 69)), \"ПФ\", IF(OR(AND(D146=\"ПТС\", F146>180), AND(D146=\"\", F146>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I146=\"ЗАКРЫТ\",I146=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I146:L146))","v":0}]
["2018-06-18",null,"Выжанов Н.А.",null,{"$f":"IF(OR(I147=\"ЗАКРЫТ\",I147=\"ВЫБЫЛ\"),\" \",F147/14)","v":0.5714285714285714},{"$f":"IF(OR(I147=\"ЗАКРЫТ\",I147=\"ВЫБЫЛ\"),\"\",(TODAY()-A147))","v":8},{"$f":"IF(I147=\"ЗАКРЫТ\", \"\", IF(OR(AND(D147=\"ПТС\", F147 = 180), AND(D147=\"\",F147 = 69)), \"ПФ\", IF(OR(AND(D147=\"ПТС\", F147>180), AND(D147=\"\", F147>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I147=\"ЗАКРЫТ\",I147=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I147:L147))","v":1},{"$f":"IF(D147=\"Ч\",\"ВЫБЫЛ\",IF(A147=\"\",\"ЗАКРЫТ\",A147+70))","v":"2018-08-27"},null,null,null,{"$f":"SUM(B149:B167)&TEXT(SUM(B149:B167)/30,\" (0,0)\")&TEXT(INT(SUM(B149:B167)/30)/12,\" (0,0)\")","v":"743 (24,8) (2,0)"},"2018-07-02"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I148=\"ЗАКРЫТ\", \"\", IF(OR(AND(D148=\"ПТС\", F148 = 180), AND(D148=\"\",F148 = 69)), \"ПФ\", IF(OR(AND(D148=\"ПТС\", F148>180), AND(D148=\"\", F148>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I148=\"ЗАКРЫТ\",I148=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I148:L148))","v":0}]
["2015-01-15",{"$f":"DATEDIF(A149,C149,\"d\")","v":54},"2015-03-10",1,null,null,{"$f":"IF(I149=\"ЗАКРЫТ\", \"\", IF(OR(AND(D149=\"ПТС\", F149 = 180), AND(D149=\"\",F149 = 69)), \"ПФ\", IF(OR(AND(D149=\"ПТС\", F149>180), AND(D149=\"\", F149>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I149=\"ЗАКРЫТ\",I149=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I149:L149))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$149:$B$167),\"\")&\" )\"","v":"1%  ( 209 )"}]
["2015-03-23",{"$f":"DATEDIF(A150,C150,\"d\")","v":47},"2015-05-09",1,null,null,{"$f":"IF(I150=\"ЗАКРЫТ\", \"\", IF(OR(AND(D150=\"ПТС\", F150 = 180), AND(D150=\"\",F150 = 69)), \"ПФ\", IF(OR(AND(D150=\"ПТС\", F150>180), AND(D150=\"\", F150>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I150=\"ЗАКРЫТ\",I150=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I150:L150))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$149:$B$167),\"\")&\" )\"","v":"0,99%  ( 8 )"}]
["2015-05-11",7,"2015-05-18",1,null,null,{"$f":"IF(I151=\"ЗАКРЫТ\", \"\", IF(OR(AND(D151=\"ПТС\", F151 = 180), AND(D151=\"\",F151 = 69)), \"ПФ\", IF(OR(AND(D151=\"ПТС\", F151>180), AND(D151=\"\", F151>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I151=\"ЗАКРЫТ\",I151=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I151:L151))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$149:$B$167),\"\")&\" )\"","v":"0,9%  ( 526 )"}]
["2015-05-25",46,"2015-07-10",1,null,null,{"$f":"IF(I152=\"ЗАКРЫТ\", \"\", IF(OR(AND(D152=\"ПТС\", F152 = 180), AND(D152=\"\",F152 = 69)), \"ПФ\", IF(OR(AND(D152=\"ПТС\", F152>180), AND(D152=\"\", F152>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I152=\"ЗАКРЫТ\",I152=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I152:L152))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-08-20",13,"2015-09-02",1,null,null,{"$f":"IF(I153=\"ЗАКРЫТ\", \"\", IF(OR(AND(D153=\"ПТС\", F153 = 180), AND(D153=\"\",F153 = 69)), \"ПФ\", IF(OR(AND(D153=\"ПТС\", F153>180), AND(D153=\"\", F153>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I153=\"ЗАКРЫТ\",I153=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I153:L153))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-09-29",6,"2015-10-05",1,null,null,{"$f":"IF(I154=\"ЗАКРЫТ\", \"\", IF(OR(AND(D154=\"ПТС\", F154 = 180), AND(D154=\"\",F154 = 69)), \"ПФ\", IF(OR(AND(D154=\"ПТС\", F154>180), AND(D154=\"\", F154>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I154=\"ЗАКРЫТ\",I154=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I154:L154))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-10-06",11,"2015-10-17",1,null,null,{"$f":"IF(I155=\"ЗАКРЫТ\", \"\", IF(OR(AND(D155=\"ПТС\", F155 = 180), AND(D155=\"\",F155 = 69)), \"ПФ\", IF(OR(AND(D155=\"ПТС\", F155>180), AND(D155=\"\", F155>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I155=\"ЗАКРЫТ\",I155=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I155:L155))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-10-20",6,"2015-10-26",1,null,null,{"$f":"IF(I156=\"ЗАКРЫТ\", \"\", IF(OR(AND(D156=\"ПТС\", F156 = 180), AND(D156=\"\",F156 = 69)), \"ПФ\", IF(OR(AND(D156=\"ПТС\", F156>180), AND(D156=\"\", F156>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I156=\"ЗАКРЫТ\",I156=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I156:L156))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-10-28",19,"2015-11-16",1,null,null,{"$f":"IF(I157=\"ЗАКРЫТ\", \"\", IF(OR(AND(D157=\"ПТС\", F157 = 180), AND(D157=\"\",F157 = 69)), \"ПФ\", IF(OR(AND(D157=\"ПТС\", F157>180), AND(D157=\"\", F157>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I157=\"ЗАКРЫТ\",I157=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I157:L157))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-11-19",8,"2015-11-27",0.99,null,null,{"$f":"IF(I158=\"ЗАКРЫТ\", \"\", IF(OR(AND(D158=\"ПТС\", F158 = 180), AND(D158=\"\",F158 = 69)), \"ПФ\", IF(OR(AND(D158=\"ПТС\", F158>180), AND(D158=\"\", F158>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I158=\"ЗАКРЫТ\",I158=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I158:L158))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2015-12-01",112,"2016-03-22",0.9,null,null,{"$f":"IF(I159=\"ЗАКРЫТ\", \"\", IF(OR(AND(D159=\"ПТС\", F159 = 180), AND(D159=\"\",F159 = 69)), \"ПФ\", IF(OR(AND(D159=\"ПТС\", F159>180), AND(D159=\"\", F159>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I159=\"ЗАКРЫТ\",I159=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I159:L159))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2016-03-22",98,"2016-06-28",0.9,null,null,{"$f":"IF(I160=\"ЗАКРЫТ\", \"\", IF(OR(AND(D160=\"ПТС\", F160 = 180), AND(D160=\"\",F160 = 69)), \"ПФ\", IF(OR(AND(D160=\"ПТС\", F160>180), AND(D160=\"\", F160>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I160=\"ЗАКРЫТ\",I160=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I160:L160))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2016-06-28",6,"2016-07-04",0.9,null,null,{"$f":"IF(I161=\"ЗАКРЫТ\", \"\", IF(OR(AND(D161=\"ПТС\", F161 = 180), AND(D161=\"\",F161 = 69)), \"ПФ\", IF(OR(AND(D161=\"ПТС\", F161>180), AND(D161=\"\", F161>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I161=\"ЗАКРЫТ\",I161=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I161:L161))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2017-01-06",112,"2017-04-28",0.9,null,null,{"$f":"IF(I162=\"ЗАКРЫТ\", \"\", IF(OR(AND(D162=\"ПТС\", F162 = 180), AND(D162=\"\",F162 = 69)), \"ПФ\", IF(OR(AND(D162=\"ПТС\", F162>180), AND(D162=\"\", F162>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I162=\"ЗАКРЫТ\",I162=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I162:L162))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A14)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2017-04-28",12,"2017-05-10",0.9,null,null,{"$f":"IF(I163=\"ЗАКРЫТ\", \"\", IF(OR(AND(D163=\"ПТС\", F163 = 180), AND(D163=\"\",F163 = 69)), \"ПФ\", IF(OR(AND(D163=\"ПТС\", F163>180), AND(D163=\"\", F163>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I163=\"ЗАКРЫТ\",I163=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I163:L163))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A15)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2017-06-02",1,"2017-06-03",0.9,null,null,{"$f":"IF(I164=\"ЗАКРЫТ\", \"\", IF(OR(AND(D164=\"ПТС\", F164 = 180), AND(D164=\"\",F164 = 69)), \"ПФ\", IF(OR(AND(D164=\"ПТС\", F164>180), AND(D164=\"\", F164>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I164=\"ЗАКРЫТ\",I164=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I164:L164))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A16))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A16)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2017-06-26",70,"2017-09-04",0.9,null,null,{"$f":"IF(I165=\"ЗАКРЫТ\", \"\", IF(OR(AND(D165=\"ПТС\", F165 = 180), AND(D165=\"\",F165 = 69)), \"ПФ\", IF(OR(AND(D165=\"ПТС\", F165>180), AND(D165=\"\", F165>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I165=\"ЗАКРЫТ\",I165=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I165:L165))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A17))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A17)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2017-09-04",33,"2017-10-07",0.9,null,null,{"$f":"IF(I166=\"ЗАКРЫТ\", \"\", IF(OR(AND(D166=\"ПТС\", F166 = 180), AND(D166=\"\",F166 = 69)), \"ПФ\", IF(OR(AND(D166=\"ПТС\", F166>180), AND(D166=\"\", F166>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I166=\"ЗАКРЫТ\",I166=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I166:L166))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A18))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A18)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2018-03-10",82,"2018-05-31",0.9,null,null,{"$f":"IF(I167=\"ЗАКРЫТ\", \"\", IF(OR(AND(D167=\"ПТС\", F167 = 180), AND(D167=\"\",F167 = 69)), \"ПФ\", IF(OR(AND(D167=\"ПТС\", F167>180), AND(D167=\"\", F167>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I167=\"ЗАКРЫТ\",I167=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I167:L167))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A19))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A19)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
["2018-06-18",8,{"$f":"TODAY()","v":"2018-06-26"},0.9,null,null,{"$f":"IF(I168=\"ЗАКРЫТ\", \"\", IF(OR(AND(D168=\"ПТС\", F168 = 180), AND(D168=\"\",F168 = 69)), \"ПФ\", IF(OR(AND(D168=\"ПТС\", F168>180), AND(D168=\"\", F168>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I168=\"ЗАКРЫТ\",I168=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I168:L168))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A20))&\"% \"&\" ( \"&SUMIF($D$149:$D$167,LARGE(IF(COUNTIF($D$149:$D$167,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A20)),$B$149:$B$167),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I169=\"ЗАКРЫТ\", \"\", IF(OR(AND(D169=\"ПТС\", F169 = 180), AND(D169=\"\",F169 = 69)), \"ПФ\", IF(OR(AND(D169=\"ПТС\", F169>180), AND(D169=\"\", F169>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I169=\"ЗАКРЫТ\",I169=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I169:L169))","v":0}]
["2018-02-06",null,"Волков В.В.","ПТС",{"$f":"IF(OR(I170=\"ЗАКРЫТ\",I170=\"ВЫБЫЛ\"),\" \",F170/14)","v":10},{"$f":"IF(OR(I170=\"ЗАКРЫТ\",I170=\"ВЫБЫЛ\"),\"\",(TODAY()-A170))","v":140},{"$f":"IF(I170=\"ЗАКРЫТ\", \"\", IF(OR(AND(D170=\"ПТС\", F170 = 180), AND(D170=\"\",F170 = 69)), \"ПФ\", IF(OR(AND(D170=\"ПТС\", F170>180), AND(D170=\"\", F170>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I170=\"ЗАКРЫТ\",I170=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I170:L170))","v":1},"2018-04-17",null,null,null,{"$f":"SUM(B172:B175)&TEXT(SUM(B172:B175)/30,\" (0,0)\")&TEXT(INT(SUM(B172:B175)/30)/12,\" (0,0)\")","v":"155 (5,2) (0,4)"},"2018-06-26"]
["открыт",null,"закрыт",null,null,null,{"$f":"IF(I171=\"ЗАКРЫТ\", \"\", IF(OR(AND(D171=\"ПТС\", F171 = 180), AND(D171=\"\",F171 = 69)), \"ПФ\", IF(OR(AND(D171=\"ПТС\", F171>180), AND(D171=\"\", F171>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I171=\"ЗАКРЫТ\",I171=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I171:L171))","v":0}]
["2018-01-19",{"$f":"DATEDIF(A172,C172,\"d\")","v":17},"2018-02-05",0.5,null,null,{"$f":"IF(I172=\"ЗАКРЫТ\", \"\", IF(OR(AND(D172=\"ПТС\", F172 = 180), AND(D172=\"\",F172 = 69)), \"ПФ\", IF(OR(AND(D172=\"ПТС\", F172>180), AND(D172=\"\", F172>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I172=\"ЗАКРЫТ\",I172=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I172:L172))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$172:$D$175,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$172:$D$175,LARGE(IF(COUNTIF($D$172:$D$175,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$172:$B$175),\"\")&\" )\"","v":"0,5%  ( 155 )"}]
["2018-02-08",{"$f":"DATEDIF(A173,C173,\"d\")","v":43},"2018-03-23",0.5,null,null,{"$f":"IF(I173=\"ЗАКРЫТ\", \"\", IF(OR(AND(D173=\"ПТС\", F173 = 180), AND(D173=\"\",F173 = 69)), \"ПФ\", IF(OR(AND(D173=\"ПТС\", F173>180), AND(D173=\"\", F173>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I173=\"ЗАКРЫТ\",I173=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I173:L173))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$172:$D$175,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$172:$D$175,LARGE(IF(COUNTIF($D$172:$D$175,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$172:$B$175),\"\")&\" )\"","v":" )"}]
["2018-03-23",{"$f":"DATEDIF(A174,C174,\"d\")","v":95},{"$f":"TODAY()","v":"2018-06-26"},0.5,null,null,{"$f":"IF(I174=\"ЗАКРЫТ\", \"\", IF(OR(AND(D174=\"ПТС\", F174 = 180), AND(D174=\"\",F174 = 69)), \"ПФ\", IF(OR(AND(D174=\"ПТС\", F174>180), AND(D174=\"\", F174>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I174=\"ЗАКРЫТ\",I174=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I174:L174))","v":0},null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$172:$D$175,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$172:$D$175,LARGE(IF(COUNTIF($D$172:$D$175,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$172:$B$175),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,{"$f":"IF(I175=\"ЗАКРЫТ\", \"\", IF(OR(AND(D175=\"ПТС\", F175 = 180), AND(D175=\"\",F175 = 69)), \"ПФ\", IF(OR(AND(D175=\"ПТС\", F175>180), AND(D175=\"\", F175>69)), \"ПрПф\", \"\")))","v":""},{"$f":"IF(OR(I175=\"ЗАКРЫТ\",I175=\"ВЫБЫЛ\"),\"\",_xlfn.AGGREGATE(3,5,I175:L175))","v":0}]
["открыт",null,"закрыт"]
["2014-12-03",{"$f":"DATEDIF(A177,C177,\"d\")","v":210},"2015-07-01",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A1)),$B$177:$B$189),\"\")&\" )\"","v":"0,9%  ( 946 )"}]
["2015-07-01",154,"2015-12-02",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A2)),$B$177:$B$189),\"\")&\" )\"","v":"0,86%  ( 204 )"}]
["2015-12-02",112,"2016-03-23",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A3)),$B$177:$B$189),\"\")&\" )\"","v":"0,69%  ( 3 )"}]
["2016-03-23",98,"2016-06-29",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A4)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2016-06-29",126,"2016-11-02",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A5)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2016-11-02",84,"2017-01-25",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A6)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2017-01-25",98,"2017-05-03",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A7)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2017-05-03",64,"2017-07-06",0.9,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A8)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2017-07-08",70,"2017-09-16",0.86,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A9)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2017-09-16",68,"2017-11-23",0.86,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A10)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2017-11-25",66,"2018-01-30",0.86,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A11)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
["2018-06-23",3,{"$f":"TODAY()","v":"2018-06-26"},0.69,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A12)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13))&\"% \"&\" ( \"&SUMIF($D$177:$D$189,LARGE(IF(COUNTIF($D$177:$D$189,db!$C$1:$C$24)>0,db!$C$1:$C$24),ROW(A13)),$B$177:$B$189),\"\")&\" )\"","v":" )"}]

{"sheet":"db","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Р","ПТС",1]
["Ч","ПФ",0.9]
["ПТС","ПрПф",0.99]
["З",null,0.98]
[null,null,0.97]
[null,null,0.96]
[null,null,0.89]
[null,null,0.88]
[null,null,0.86]
[null,null,0.8]
[null,null,0.72]
[null,null,0.78]
[null,null,0.69]
[null,null,0.5]
[null,null,0.39]
[null,null,0.3]
[null,null,0.25]