{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Калькулятор 2","Калькулятор1","Задолженность","Приходник","Договор, акт"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Калькулятор 2","index":0,"n_rows":21,"n_cols":111,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,0,15,9],[15,10,15,13],[15,14,15,17],[15,18,15,30],[13,0,13,9],[13,10,13,13],[13,14,13,17],[13,18,13,30],[14,0,14,9],[14,10,14,13],[14,14,14,17],[14,18,14,30],[11,0,11,9],[11,10,11,13],[11,14,11,17],[11,18,11,30],[12,0,12,9],[12,10,12,13],[12,14,12,17],[12,18,12,30],[9,0,9,9],[9,10,9,13],[9,14,9,17],[9,18,9,30],[10,0,10,9],[10,10,10,13],[10,14,10,17],[10,18,10,30],[8,0,8,9],[8,10,8,13],[8,14,8,17],[8,18,8,30],[7,0,7,6],[7,7,7,9],[7,10,7,12],[7,13,7,15],[7,16,7,18],[7,19,7,21],[6,19,6,21],[6,22,6,24],[6,25,6,27],[6,28,6,30],[7,22,7,24],[7,25,7,27],[7,28,7,30],[6,0,6,6],[6,7,6,9],[6,10,6,12],[6,13,6,15],[6,16,6,18],[4,25,4,27],[4,28,4,30],[5,0,5,6],[5,7,5,9],[5,10,5,12],[5,13,5,15],[5,16,5,18],[5,19,5,21],[5,22,5,24],[5,25,5,27],[5,28,5,30],[4,0,4,6],[4,7,4,9],[4,10,4,12],[4,13,4,15],[4,16,4,18],[3,16,3,18],[3,19,3,21],[3,22,3,24],[3,25,3,27],[3,28,3,30],[4,19,4,21],[4,22,4,24],[0,102,0,104],[0,0,0,9],[0,10,0,15],[0,16,0,20],[0,23,0,27],[0,28,0,30],[1,0,1,9],[1,10,1,13],[2,0,2,9],[2,10,2,30],[3,0,3,6],[3,7,3,9],[3,10,3,12],[3,13,3,15]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"АКЦИЯ 7-7-7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K1)","v":""},{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",\"А\",IF(Q1=\"АКЦИЯ 0-0-12\",\"А\",\"\"))","v":""},{"$f":"RIGHT(K1,CS1-CR1)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"CONCATENATE(K1,CG1,\"/П-\",CH2,CI2,CK2,AC1)","v":"/П-0618"},null,null,null,null,null,{"$f":"SEARCH(\"к\",K1)","v":{"$error":"#VALUE!"}},{"$f":"LEN(K1)","v":0},null,null,null,null,null,"AMKf1server",null,null,null,null,"ОБЫЧНАЯ","АКЦИЯ 0-0-6","АКЦИЯ 7-7-7","АКЦИЯ 0-0-12"]
["Дата заключения ",null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CG2,\".\",CH2,CI2,\".\",CJ2,\"г.\")","v":"25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-06-25T17:09:16.230"},{"$f":"CONCATENATE(K2)","v":"25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DAY(AF2)","v":25},null,{"$f":"DAY(AF2)","v":25},{"$f":"IF(CI2<10,0,\"\")","v":0},{"$f":"MONTH(AF2)","v":6},{"$f":"YEAR(AF2)","v":2018},{"$f":"RIGHT(CJ2,2)","v":"18"},{"$f":"CONCATENATE(K1,CG1,\"/КП-\",CH2,CI2,CK2,AC1)","v":"/КП-0618"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K2)","v":"25.06.2018г."}]
["Наименование Товара ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AG1,\"  от  \",AG2)","v":"  от  25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CH3,AC1)","v":"А7"},{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",\"А6\",IF(Q1=\"АКЦИЯ 7-7-7\",\"А7\",IF(Q1=\"АКЦИЯ 0-0-12\",\"А12\",\"\")))","v":"А7"},null,null,null,{"$f":"CONCATENATE(L3)","v":""}]
["Виды Товаров ",null,null,null,null,null,null,"Спальный гарнитур",null,null,"Кухонная мебель",null,null,"Мягкая мебель",null,null,"Бытовая техника",null,null,"Телевизоры",null,null,"Телефоны",null,null,"Шкаф-купе",null,null,"Иное",null,null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Спальный гарнитур","Кухонная мебель","Мягкая мебель","Бытовая техника","Телевизоры","Телефоны","Шкаф-купе","Иное"]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,null,null,null,null,null,{"$f":"K12/4","v":25000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CL5:CS5)","v":100000},{"$f":"SUM(H5:J8)","v":0},{"$f":"SUM(K5:M8)","v":0},{"$f":"SUM(N5:P8)","v":0},{"$f":"SUM(Q5:S8)","v":0},{"$f":"SUM(T5:V8)","v":0},{"$f":"SUM(W5:Y8)","v":0},{"$f":"SUM(Z5:AB8)","v":100000},{"$f":"SUM(AC5:AE8)","v":0}]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CL5-(K10/CK5)*CL5,2)","v":0},{"$f":"ROUND(CM5-(K10/CK5)*CM5,2)","v":0},{"$f":"ROUND(CN5-(K10/CK5)*CN5,2)","v":0},{"$f":"ROUND(CO5-(K10/CK5)*CO5,2)","v":0},{"$f":"ROUND(CP5-(K10/CK5)*CP5,2)","v":0},{"$f":"ROUND(CQ5-(K10/CK5)*CQ5,2)","v":0},{"$f":"ROUND(CR5-(K10/CK5)*CR5,2)","v":93000},{"$f":"ROUND(CS5-(K10/CK5)*CS5,2)","v":0}]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12*30/100","v":30000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CL6>0,1,0)","v":0},{"$f":"IF(CM6>0,1,0)","v":0},0,0,0,0,1,0]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKDAY(AF2)","v":2}]
["Срок ( в мес)",null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12*7/100","v":7000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ"]
["Обеспечительный взнос ",null,null,null,null,null,null,null,null,null,7000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Скидка Киргу",null,"Общая наценка",null,null,null,{"$f":"IF(CI8=1,1,0)","v":0},{"$f":"IF(CI8=2,1,0)","v":1},{"$f":"IF(CI8=3,1,0)","v":0},{"$f":"IF(CI8=4,1,0)","v":0},{"$f":"IF(CI8=5,1,0)","v":0},{"$f":"IF(CI8=6,1,0)","v":0},{"$f":"IF(CI8=7,1,0)","v":0}]
["Количество Поручителей ",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12/2","v":50000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",11,IF(Q1=\"АКЦИЯ 7-7-7\",10,IF(Q1=\"АКЦИЯ 0-0-12\",22,0)))","v":10},{"$f":"ROUND((K12*CE11)/100,2)","v":10000},null,{"$f":"ROUND(CF11+K15,0)","v":17000}]
["Стоимость Товара",null,null,null,null,null,null,null,null,null,{"$f":"SUM(CL5:CS5)","v":100000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S12)","v":""}]
["Сумма ежемесячного платежа",null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K14-K10)/K9,0)","v":14286},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S13)","v":""}]
["Полная стоимость Товара",null,null,null,null,null,null,null,null,null,{"$f":"K12+K15","v":107000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"По Обычной сделке",null,null,null,null,null,{"$f":"CONCATENATE(S14)","v":""}]
["Наша наценка ",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q1=\"АКЦИЯ 7-7-7\",K9<=7),ROUND(K12*CP17/100,0),ROUND((K12-K10)*CP17/12*K9/100,0))","v":7000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K16*CP20*K9)/(12*100),0)","v":0},null,{"$f":"IF((CN18+CO18)=0,0,IF(CF15-CF11>=0,CF15-CF11,0))","v":0},null,null,null,{"$f":"CONCATENATE(S15)","v":""},null,null,null,null,null,null,null,null,{"$f":"AND(CM19=1,N5*30/100<K10)","v":false}]
["Сумма финансирования *",null,null,null,null,null,null,null,null,null,{"$f":"K12-K10","v":93000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((CN19+CO19)=0,0,IF(CF15-CF11>=0,CF15-CF11,0))","v":0},null,null,null,{"$f":"CONCATENATE(S16)","v":""}]
[null,null,"*","Если сумма финансирования  менее 200 000р.срок рассмотрения 30 мин. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Минимальная годовая % надбавка",22,null,{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",CS18+CT18,IF(Q1=\"АКЦИЯ 7-7-7\",CS21+CT21,IF(Q1=\"АКЦИЯ 0-0-12\",CS19+CT19,CT20+CS20)))","v":7},{"$f":"CO17","v":7},null,null,"Наценка по сроку "]
[null,null,null,"Если сумма финансирования  более 200 000р. срок рассмотрения 2-3 дня . ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Увеличение без поручителей ",6,null,null,null,"АКЦИЯ 0-0-6",null,{"$f":"IF(K9<=6,0,IF(K9<=12,11,22))","v":11},{"$f":"IF(AND(CM19=1,K12*30/100<=K10),0,IF(AND(CM19=0,K12*50/100<=K10),0,IF(CM19=2,0,IF(CM19=1,6,16))))","v":16}]
[null,null,null,"Если сумма финансирования  менее 80 000р. допускается без поручителей  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K11>=2,2,IF(K11=1,1,0))","v":0},null,null,null,"АКЦИЯ 0-0-12",null,{"$f":"IF(K9<=12,0,11)","v":0},{"$f":"IF(AND(CM19=1,K12*30/100<=K10),0,IF(AND(CM19=0,K12*50/100<=K10),0,IF(CM19=2,0,IF(CM19=1,6,16))))","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Обычная ",null,22,{"$f":"IF(CM19=2,0,IF(CM19=1,6,16))","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"АКЦИЯ 7-7-7 ",null,{"$f":"IF(AND(K9<=7,K10>=AF9),7,IF(K9<=12,28,33))","v":7},{"$f":"IF(AND(CM19=0,K9>7),0,IF(AND(CM19=1,K9>7),-10,IF(AND(CM19=2,K9>7),-16,0)))","v":0}]

{"sheet":"Калькулятор1","index":1,"n_rows":21,"n_cols":111,"rows_kept":21,"cut":false,"hidden":false,"merged":[[15,0,15,9],[15,10,15,13],[15,14,15,17],[15,18,15,30],[13,0,13,9],[13,10,13,13],[13,14,13,17],[13,18,13,30],[14,0,14,9],[14,10,14,13],[14,14,14,17],[14,18,14,30],[11,0,11,9],[11,10,11,13],[11,14,11,17],[11,18,11,30],[12,0,12,9],[12,10,12,13],[12,14,12,17],[12,18,12,30],[8,10,8,13],[8,14,8,17],[8,18,8,30],[10,0,10,9],[10,10,10,13],[10,14,10,17],[10,18,10,30],[9,0,9,9],[9,10,9,13],[9,14,9,17],[9,18,9,30],[8,0,8,9],[6,28,6,30],[7,0,7,6],[7,7,7,9],[7,10,7,12],[7,13,7,15],[7,16,7,18],[7,19,7,21],[7,22,7,24],[7,25,7,27],[7,28,7,30],[6,19,6,21],[6,22,6,24],[6,0,6,6],[6,7,6,9],[6,10,6,12],[6,13,6,15],[5,0,5,6],[5,7,5,9],[5,10,5,12],[5,13,5,15],[5,16,5,18],[6,16,6,18],[4,19,4,21],[4,22,4,24],[4,25,4,27],[6,25,6,27],[4,28,4,30],[5,22,5,24],[5,25,5,27],[5,28,5,30],[5,19,5,21],[4,0,4,6],[4,7,4,9],[4,10,4,12],[4,13,4,15],[4,16,4,18],[2,0,2,9],[2,10,2,30],[3,0,3,6],[3,7,3,9],[3,10,3,12],[3,13,3,15],[3,16,3,18],[3,19,3,21],[3,22,3,24],[3,25,3,27],[3,28,3,30],[1,0,1,9],[1,10,1,13],[0,102,0,104],[0,0,0,9],[0,10,0,15],[0,16,0,20],[0,23,0,27],[0,28,0,30]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"АКЦИЯ 7-7-7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K1)","v":""},{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",\"А\",IF(Q1=\"АКЦИЯ 0-0-12\",\"А\",\"\"))","v":""},{"$f":"RIGHT(K1,CS1-CR1)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"CONCATENATE(K1,CG1,\"/П-\",CH2,CI2,CK2,AC1)","v":"/П-0618"},null,null,null,null,null,{"$f":"SEARCH(\"к\",K1)","v":{"$error":"#VALUE!"}},{"$f":"LEN(K1)","v":0},null,null,null,null,null,"AMKf1server",null,null,null,null,"ОБЫЧНАЯ","АКЦИЯ 0-0-6","АКЦИЯ 7-7-7","АКЦИЯ 0-0-12"]
["Дата заключения ",null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CG2,\".\",CH2,CI2,\".\",CJ2,\"г.\")","v":"25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-06-25T17:09:16.230"},{"$f":"CONCATENATE(K2)","v":"25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DAY(AF2)","v":25},null,{"$f":"DAY(AF2)","v":25},{"$f":"IF(CI2<10,0,\"\")","v":0},{"$f":"MONTH(AF2)","v":6},{"$f":"YEAR(AF2)","v":2018},{"$f":"RIGHT(CJ2,2)","v":"18"},{"$f":"CONCATENATE(K1,CG1,\"/КП-\",CH2,CI2,CK2,AC1)","v":"/КП-0618"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K2)","v":"25.06.2018г."}]
["Наименование Товара ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AG1,\"  от  \",AG2)","v":"  от  25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CH3,AC1)","v":"А7"},{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",\"А6\",IF(Q1=\"АКЦИЯ 7-7-7\",\"А7\",IF(Q1=\"АКЦИЯ 0-0-12\",\"А12\",\"\")))","v":"А7"},null,null,null,{"$f":"CONCATENATE(L3)","v":""}]
["Виды Товаров ",null,null,null,null,null,null,"Спальный гарнитур",null,null,"Кухонная мебель",null,null,"Мягкая мебель",null,null,"Бытовая техника",null,null,"Телевизоры",null,null,"Телефоны",null,null,"Шкаф-купе",null,null,"Иное",null,null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Спальный гарнитур","Кухонная мебель","Мягкая мебель","Бытовая техника","Телевизоры","Телефоны","Шкаф-купе","Иное"]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000,null,null,null,null,null,{"$f":"K12/4","v":25000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CL5:CS5)","v":100000},{"$f":"SUM(H5:J8)","v":0},{"$f":"SUM(K5:M8)","v":0},{"$f":"SUM(N5:P8)","v":0},{"$f":"SUM(Q5:S8)","v":0},{"$f":"SUM(T5:V8)","v":0},{"$f":"SUM(W5:Y8)","v":0},{"$f":"SUM(Z5:AB8)","v":100000},{"$f":"SUM(AC5:AE8)","v":0}]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CL5-(K10/CK5)*CL5,2)","v":0},{"$f":"ROUND(CM5-(K10/CK5)*CM5,2)","v":0},{"$f":"ROUND(CN5-(K10/CK5)*CN5,2)","v":0},{"$f":"ROUND(CO5-(K10/CK5)*CO5,2)","v":0},{"$f":"ROUND(CP5-(K10/CK5)*CP5,2)","v":0},{"$f":"ROUND(CQ5-(K10/CK5)*CQ5,2)","v":0},{"$f":"ROUND(CR5-(K10/CK5)*CR5,2)","v":93000},{"$f":"ROUND(CS5-(K10/CK5)*CS5,2)","v":0}]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12*30/100","v":30000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CL6>0,1,0)","v":0},{"$f":"IF(CM6>0,1,0)","v":0},0,0,0,0,1,0]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKDAY(AF2)","v":2}]
["Срок ( в мес)",null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12*7/100","v":7000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ"]
["Обеспечительный взнос ",null,null,null,null,null,null,null,null,null,7000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Скидка Киргу",null,"Общая наценка",null,null,null,{"$f":"IF(CI8=1,1,0)","v":0},{"$f":"IF(CI8=2,1,0)","v":1},{"$f":"IF(CI8=3,1,0)","v":0},{"$f":"IF(CI8=4,1,0)","v":0},{"$f":"IF(CI8=5,1,0)","v":0},{"$f":"IF(CI8=6,1,0)","v":0},{"$f":"IF(CI8=7,1,0)","v":0}]
["Количество Поручителей ",null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12/2","v":50000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",11,IF(Q1=\"АКЦИЯ 7-7-7\",10,IF(Q1=\"АКЦИЯ 0-0-12\",22,0)))","v":10},{"$f":"ROUND((K12*CE11)/100,2)","v":10000},null,{"$f":"ROUND(CF11+K15,0)","v":17000}]
["Стоимость Товара",null,null,null,null,null,null,null,null,null,{"$f":"SUM(CL5:CS5)","v":100000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S12)","v":""}]
["Сумма ежемесячного платежа",null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K14-K10)/K9,0)","v":14286},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S13)","v":""}]
["Полная стоимость Товара",null,null,null,null,null,null,null,null,null,{"$f":"K12+K15","v":107000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"По Обычной сделке",null,null,null,null,null,{"$f":"CONCATENATE(S14)","v":""}]
["Наша наценка ",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q1=\"АКЦИЯ 7-7-7\",K9<=7),ROUND(K12*CP17/100,0),ROUND((K12-K10)*CP17/12*K9/100,0))","v":7000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K16*CP20*K9)/(12*100),0)","v":0},null,{"$f":"IF((CN18+CO18)=0,0,IF(CF15-CF11>=0,CF15-CF11,0))","v":0},null,null,null,{"$f":"CONCATENATE(S15)","v":""},null,null,null,null,null,null,null,null,{"$f":"AND(CM19=1,N5*30/100<K10)","v":false}]
["Сумма финансирования *",null,null,null,null,null,null,null,null,null,{"$f":"K12-K10","v":93000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((CN19+CO19)=0,0,IF(CF15-CF11>=0,CF15-CF11,0))","v":0},null,null,null,{"$f":"CONCATENATE(S16)","v":""}]
[null,null,"*","Если сумма финансирования  менее 200 000р.срок рассмотрения 30 мин. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Минимальная годовая % надбавка",22,null,{"$f":"IF(Q1=\"АКЦИЯ 0-0-6\",CS18+CT18,IF(Q1=\"АКЦИЯ 7-7-7\",CS21+CT21,IF(Q1=\"АКЦИЯ 0-0-12\",CS19+CT19,CT20+CS20)))","v":7},{"$f":"CO17","v":7},null,null,"Наценка по сроку "]
[null,null,null,"Если сумма финансирования  более 200 000р. срок рассмотрения 2-3 дня . ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Увеличение без поручителей ",6,null,null,null,"АКЦИЯ 0-0-6",null,{"$f":"IF(K9<=6,0,IF(K9<=12,11,22))","v":11},{"$f":"IF(AND(CM19=1,K12*30/100<=K10),0,IF(AND(CM19=0,K12*50/100<=K10),0,IF(CM19=2,0,IF(CM19=1,6,16))))","v":16}]
[null,null,null,"Если сумма финансирования  менее 80 000р. допускается без поручителей  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K11>=2,2,IF(K11=1,1,0))","v":0},null,null,null,"АКЦИЯ 0-0-12",null,{"$f":"IF(K9<=12,0,11)","v":0},{"$f":"IF(AND(CM19=1,K12*30/100<=K10),0,IF(AND(CM19=0,K12*50/100<=K10),0,IF(CM19=2,0,IF(CM19=1,6,16))))","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Обычная ",null,22,{"$f":"IF(CM19=2,0,IF(CM19=1,6,16))","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"АКЦИЯ 7-7-7 ",null,{"$f":"IF(AND(K9<=7,K10>=AF9),7,IF(K9<=12,28,33))","v":7},{"$f":"IF(AND(CM19=0,K9>7),0,IF(AND(CM19=1,K9>7),-10,IF(AND(CM19=2,K9>7),-16,0)))","v":0}]

{"sheet":"Задолженность","index":2,"n_rows":10,"n_cols":96,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,17,3,17],[1,1,3,1],[1,2,1,16],[2,6,2,8],[2,9,3,9],[2,10,3,10],[2,11,3,11],[2,2,3,2],[2,3,3,3],[2,16,3,16],[2,5,3,5],[2,4,3,4]]}
[null,null,null,null,null,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81]
[null,"Номер","Данные должника",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Спальный гарнитур","Кухонная мебель","Мягкая мебель","Бытовая техника","Телевизоры","Телефоны","Шкаф-купе","Иное","Спальный гарнитур","Кухонная мебель","Мягкая мебель","Бытовая техника","Телевизоры","Телефоны","Шкаф-купе","Иное","Спальный гарнитур","Кухонная мебель","Мягкая мебель","Бытовая техника","Телевизоры","Телефоны","Шкаф-купе","Иное",null,null,null,"ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ"]
[null,null,"договор №","дата","ФИО","количество Поручителей","стоимость товара",null,null,"ежемесячный платеж","задолженность","первоначальный взнос",null,null,null,null,"Начисление","Эффективная ставка",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV$8:AV$1048576)","v":0},{"$f":"SUM(AW$8:AW$1048576)","v":0},{"$f":"SUM(AX$8:AX$1048576)","v":0},{"$f":"SUM(AY$8:AY$1048576)","v":0},{"$f":"SUM(AZ$8:AZ$1048576)","v":0},{"$f":"SUM(BA$8:BA$1048576)","v":0},{"$f":"SUM(BB$8:BB$1048576)","v":0},{"$f":"SUM(BC$8:BC$1048576)","v":0},{"$f":"SUM(BD$8:BD$1048576)","v":0},{"$f":"SUM(BE$8:BE$1048576)","v":0},{"$f":"SUM(BF$8:BF$1048576)","v":0},{"$f":"SUM(BG$8:BG$1048576)","v":1},{"$f":"SUM(BH$8:BH$1048576)","v":0},{"$f":"SUM(BI$8:BI$1048576)","v":0},{"$f":"SUM(BJ$8:BJ$1048576)","v":1},{"$f":"SUM(BK$8:BK$1048576)","v":0},{"$f":"SUM(BL$8:BL$1048576)","v":0},{"$f":"SUM(BM$8:BM$1048576)","v":0},{"$f":"SUM(BN$8:BN$1048576)","v":0},{"$f":"SUM(BO$8:BO$1048576)","v":8292.61},{"$f":"SUM(BP$8:BP$1048576)","v":0},{"$f":"SUM(BQ$8:BQ$1048576)","v":0},{"$f":"SUM(BR$8:BR$1048576)","v":515020.39},{"$f":"SUM(BS$8:BS$1048576)","v":0},null,null,null,{"$f":"SUM(BW$8:BW$1048576)","v":0},{"$f":"SUM(BX$8:BX$1048576)","v":1},{"$f":"SUM(BY$8:BY$1048576)","v":0},{"$f":"SUM(BZ$8:BZ$1048576)","v":0},{"$f":"SUM(CA$8:CA$1048576)","v":0},{"$f":"SUM(CB$8:CB$1048576)","v":0},{"$f":"SUM(CC$8:CC$1048576)","v":0},null,{"$f":"SUM(CE$8:CE$1048576)","v":0},{"$f":"SUM(CF$8:CF$1048576)","v":0}]
[null,null,null,null,null,null,"Полная","тело ","наценка ТНВ",null,null,null,"Срок","Долг",-2,"Кол-во",null,null,"Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ","Погашения ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Погашено всего","Погашено наценки"]
[]
[{"$f":"DAY(D6)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"G6-L6-SUM(S6:AQ6)","v":0},null,null,{"$f":"IF(G6>0,Q6-K6,0)","v":0},{"$f":"IF((N6/J6)>=0,0,IF((N6/J6)>-0.5,-0.1,IF((N6/J6)>-2,-1,-2)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D6=\"\",0,DATEDIF(D6,NOW(),\"m\"))","v":0},{"$f":"IF(G6>0,IF(G6-L6-(J6)*P6<0,0,G6-L6-(J6)*P6),0)","v":0},0.43804206252098088,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G6-L6-K6","v":0},{"$f":"IF(CE6=0,0,ROUND(CE6*I6/(H6-L6+I6),2))","v":0},null,null,null,null,null,null,{"$f":"IF(МояФункция(H6-L6,I6,M6,P6,CN6,T6:AQ6)>0,МояФункция(H6-L6,I6,M6,P6,CN6,T6:AQ6),0)","v":{"$error":"#NAME?"}},{"$f":"IF(D6>CO6,0,DATEDIF(D6,CO6,\"m\"))","v":1413},"2017-10-01",{"$f":"CF6-CM6","v":{"$error":"#NAME?"}},{"$f":"B6","v":0},{"$f":"CQ6*CE6/(H6-L6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"А6МТВ"]
[]
[{"$f":"DAY(D9)","v":25},55331.3,"108/КП-0618ММ","2018-06-25T15:14:36","Юсуповадибирова  Патиматхамиз  Магомедрасуловнаовна",1,647509,553313,94196,51459,{"$f":"G9-L9-SUM(S9:AQ9)","v":617509},30000,12,{"$f":"IF(G9>0,Q9-K9,0)","v":0},{"$f":"IF((N9/J9)>=0,0,IF((N9/J9)>-0.5,-0.1,IF((N9/J9)>-2,-1,-2)))","v":0},{"$f":"IF(D9=\"\",0,DATEDIF(D9,NOW(),\"m\"))","v":0},{"$f":"IF(G9>0,IF(G9-L9-(J9)*P9<0,0,G9-L9-(J9)*P9),0)","v":617509},0.60530987381935109,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8928 569 92 66","ИП Лаварсанова Нурият Лаварсановна",null,null,null,null,null,null,null,null,0,0,0,1,0,0,1,0,0,0,0,8292.61,0,0,515020.39,0,null,"А7ММ",null,0,1,0,0,0,0,0,null,{"$f":"G9-L9-K9","v":0},{"$f":"IF(CE9=0,0,ROUND(CE9*I9/(H9-L9+I9),2))","v":0},null,null,null,null,null,null,{"$f":"IF(МояФункция(H9-L9,I9,M9,P9,CN9,T9:AQ9)>0,МояФункция(H9-L9,I9,M9,P9,CN9,T9:AQ9),0)","v":{"$error":"#NAME?"}},{"$f":"IF(D9>CO9,0,DATEDIF(D9,CO9,\"m\"))","v":0},"2017-10-01",{"$f":"CF9-CM9","v":{"$error":"#NAME?"}},{"$f":"B9","v":55331.3},{"$f":"CQ9*CE9/(H9-L9)","v":0}]
[null,null,"108/КП-0618ММ","Алимагомедова Зуруд Гаджикурбановна ","Курамагомедова Маржанат Шарипгаджиевна",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"А7ММ"]

{"sheet":"Приходник","index":3,"n_rows":36,"n_cols":97,"rows_kept":36,"cut":false,"hidden":false,"merged":[[74,13,74,22],[74,25,74,36],[74,73,74,82],[74,85,74,96],[71,13,71,22],[71,25,71,36],[71,80,71,87],[71,89,71,98],[73,13,73,22],[73,25,73,36],[73,73,73,82],[73,85,73,96],[67,8,67,62],[68,8,68,62],[70,13,70,22],[70,25,70,36],[70,80,70,87],[70,89,70,98],[65,5,65,62],[66,0,66,42],[66,46,66,59],[66,69,66,70],[66,72,66,81],[66,83,66,86],[62,8,62,62],[62,68,62,98],[63,0,63,62],[63,68,63,86],[63,90,63,95],[64,5,64,62],[64,76,64,98],[58,48,58,56],[58,57,58,62],[58,73,58,86],[58,90,58,95],[59,73,59,86],[60,0,61,7],[60,8,61,62],[60,68,60,98],[61,68,61,98],[58,0,58,5],[58,6,58,10],[58,11,58,19],[58,20,58,28],[58,29,58,37],[58,38,58,47],[56,57,56,62],[56,68,56,98],[57,0,57,5],[57,6,57,10],[57,11,57,19],[57,20,57,28],[57,29,57,37],[57,38,57,47],[57,48,57,56],[57,57,57,62],[56,0,56,5],[56,6,56,10],[56,11,56,19],[56,20,56,28],[56,29,56,37],[56,38,56,47],[55,0,55,5],[55,6,55,10],[55,11,55,19],[55,20,55,28],[55,29,55,37],[55,38,55,47],[54,0,54,5],[54,6,54,37],[54,38,54,47],[50,53,50,62],[45,0,45,42],[45,51,45,62],[46,0,46,42],[46,51,47,62],[47,0,47,49],[54,48,54,56],[54,57,54,62],[54,68,54,98],[51,7,53,41],[51,43,51,52],[51,53,51,62],[51,76,51,98],[52,43,52,52],[52,53,52,62],[52,68,52,98],[53,75,53,98],[34,13,34,22],[34,25,34,36],[34,80,34,87],[34,89,34,98],[35,13,35,22],[35,25,35,36],[35,80,35,87],[35,89,35,98],[47,90,47,98],[38,64,74,65],[40,68,40,98],[41,68,41,98],[43,51,43,62],[43,68,44,98],[44,51,44,62],[55,48,55,56],[55,57,55,62],[55,68,55,98],[56,48,56,56],[48,0,48,49],[49,71,49,72],[49,74,49,83],[49,85,49,88],[50,43,50,52],[23,73,23,86],[24,68,26,98],[29,5,29,62],[30,0,30,42],[30,46,30,59],[30,69,30,86],[31,8,31,62],[32,8,32,62],[26,8,26,62],[27,0,27,62],[27,68,27,86],[27,90,27,95],[28,5,28,62],[28,76,28,98],[24,0,25,7],[24,8,25,62],[22,29,22,37],[22,38,22,47],[22,48,22,56],[22,57,22,62],[21,0,21,5],[21,6,21,10],[21,11,21,19],[21,20,21,28],[21,29,21,37],[21,38,21,47],[19,68,19,98],[19,0,19,5],[19,6,19,10],[19,11,19,19],[19,20,19,28],[19,29,19,37],[19,38,19,47],[22,73,22,86],[22,90,22,95],[20,0,20,5],[20,6,20,10],[20,11,20,19],[20,20,20,28],[20,29,20,37],[20,38,20,47],[20,48,20,56],[20,57,20,62],[20,68,20,98],[21,48,21,56],[21,57,21,62],[22,0,22,5],[22,6,22,10],[22,11,22,19],[22,20,22,28],[12,0,12,49],[12,71,12,85],[14,43,14,49],[14,50,14,62],[14,68,14,75],[14,76,16,98],[15,7,17,41],[15,43,15,49],[15,50,15,62],[16,43,16,49],[34,0,34,12],[34,68,34,79],[9,0,9,42],[9,51,9,62],[10,0,10,42],[10,51,11,62],[10,90,10,98],[11,0,11,49],[2,64,36,65],[4,68,4,98],[5,68,5,98],[7,51,7,62],[7,68,8,98],[8,51,8,62],[16,50,16,62],[17,75,17,98],[19,48,19,56],[19,57,19,62],[18,0,18,5],[18,6,18,37],[18,38,18,47],[18,48,18,56],[18,57,18,62],[18,68,18,98]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Унифицированная форма № КО-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Л и н и я  о т р е з а"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Утверждена постановлением Госкомстата"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"России от 18.08.98 г. № 88",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Договор, акт'!AG1)","v":"ОРИОН"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"организация"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Код",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"КВИТАНЦИЯ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Форма по ОКУД",null,"0310001"]
[{"$f":"CONCATENATE(BQ5)","v":"ОРИОН"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"по ОКПО"]
["организация",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"к приходному кассовому ордеру №",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Договор, акт'!CF5","v":"108"}]
[]
["структурное подразделение",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"от",null,null,{"$f":"NOW()","v":"2018-06-25T17:09:16.230"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Номер",null,null,null,null,null,null,"Дата",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Принято от",null,null,null,null,null,null,null,{"$f":"CONCATENATE('Договор, акт'!CE2)","v":"Юсуповадибирова Патиматхамиз Магомедрасуловнаовна"}]
[null,null,null,null,null,null,null,"ПРИХОДНЫЙ КАССОВЫЙ ОРДЕР",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"документа",null,null,null,null,null,null,"составления"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CM11)","v":"108"},null,null,null,null,null,null,{"$f":"BT13","v":"2018-06-25T17:09:16.230"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Основание:",null,null,null,null,null,null,"Договор купли продажи "]
["Дебет",null,null,null,null,null,"Кредит",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Сумма,",null,null,null,null,null,null,null,null,null,"Код",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE('Договор, акт'!CL6,\"  от \")","v":"108А/КП-0618ММ  от "}]
[null,null,null,null,null,null,null,null,null,null,null,"код",null,null,null,null,null,null,null,null,"корреспон-",null,null,null,null,null,null,null,null,"код",null,null,null,null,null,null,null,null,"руб. коп.",null,null,null,null,null,null,null,null,null,"целевого",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Договор, акт'!AG6","v":"25.06.2018г."}]
[null,null,null,null,null,null,null,null,null,null,null,"структурного",null,null,null,null,null,null,null,null,"дирующий",null,null,null,null,null,null,null,null,"аналитичес-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"назначения"]
[null,null,null,null,null,null,null,null,null,null,null,"подразделения",null,null,null,null,null,null,null,null,"счет, субсчет",null,null,null,null,null,null,null,null,"кого учета"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Сумма",null,null,null,null,{"$f":"SUM('Договор, акт'!K14:N14)","v":30000},null,null,null,null,null,null,null,null,null,null,null,null,null,"руб.",null,null,"00",null,null,null,null,null,"коп."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"цифрами"]
["Принято от",null,null,null,null,null,null,null,{"$f":"CONCATENATE(BY15,\" \",BQ17)","v":"Юсуповадибирова Патиматхамиз Магомедрасуловнаовна "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ЧислоПропись(BV23)","v":"Тридцать тысяч "}]
[]
["Основание:",null,null,null,null,null,null,null,{"$f":"CONCATENATE(BX18,\" \",BQ19,BQ20)","v":"Договор купли продажи  108А/КП-0618ММ  от 25.06.2018г."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"руб.",null,null,null,null,null,null,null,null,"коп."]
["Сумма",null,null,null,null,{"$f":"CONCATENATE(BQ25,\" \",BQ27)","v":"Тридцать тысяч  "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"В том числе"]
[null,null,null,null,null,"прописью"]
[{"$f":"CONCATENATE(BV23)","v":"30000"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"руб.",null,null,{"$f":"CONCATENATE(CM23)","v":"00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"коп.",null,null,null,null,null,null,null,null,{"$f":"BT13","v":"2018-06-25T17:09:16.230"}]
["В том числе",null,null,null,null,null,null,null,{"$f":"CONCATENATE(BY29)","v":""}]
["Приложение",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"М. П. (штампа)"]
[]
["Принято",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Принято "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(подпись)",null,null,null,null,null,null,null,null,null,null,null,"(расшифровка подписи)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(подпись)",null,null,null,null,null,null,null,null,"(расшифровка подписи)"]

{"sheet":"Договор, акт","index":4,"n_rows":25,"n_cols":125,"rows_kept":25,"cut":false,"hidden":false,"merged":[[7,28,7,30],[7,0,7,6],[7,7,7,9],[7,10,7,12],[7,13,7,15],[7,16,7,18],[7,19,7,21],[7,22,7,24],[7,25,7,27],[18,0,18,9],[18,10,18,13],[18,14,18,17],[18,18,18,30],[19,0,19,9],[19,10,19,13],[19,14,19,17],[19,18,19,30],[16,0,16,9],[16,10,16,13],[16,14,16,17],[16,18,16,30],[17,0,17,9],[17,10,17,13],[17,14,17,17],[17,18,17,30],[27,0,27,3],[27,18,27,20],[29,0,29,20],[20,3,20,20],[21,3,21,20],[22,3,22,20],[24,0,24,20],[25,0,25,20],[26,0,26,20],[2,0,2,9],[2,10,2,22],[2,24,2,28],[3,0,3,9],[3,10,3,22],[3,24,3,28],[15,0,15,9],[15,10,15,13],[15,14,15,17],[15,18,15,30],[12,0,12,9],[12,10,12,13],[12,14,12,17],[12,18,12,30],[13,0,13,9],[13,10,13,13],[13,14,13,17],[13,18,13,30],[10,25,10,27],[10,28,10,30],[10,0,10,6],[11,0,11,6],[10,7,10,9],[11,7,11,9],[14,0,14,9],[14,10,14,13],[10,10,10,12],[10,13,10,15],[10,16,10,18],[11,10,11,12],[11,13,11,15],[11,16,11,18],[14,14,14,17],[14,18,14,30],[11,19,11,21],[11,22,11,24],[11,25,11,27],[11,28,11,30],[10,19,10,21],[10,22,10,24],[8,25,8,27],[8,28,8,30],[9,0,9,6],[9,7,9,9],[9,10,9,12],[9,13,9,15],[9,16,9,18],[9,19,9,21],[9,22,9,24],[9,25,9,27],[9,28,9,30],[5,0,5,9],[5,10,5,13],[6,0,6,9],[6,10,6,30],[8,0,8,6],[0,0,0,3],[0,4,0,8],[0,9,0,16],[0,17,0,21],[0,22,0,28],[1,0,1,9],[1,10,1,22],[1,24,1,28],[4,0,4,9],[4,10,4,15],[4,16,4,20],[4,23,4,27],[4,28,4,30],[8,7,8,9],[8,10,8,12],[8,13,8,15],[8,16,8,18],[8,19,8,21],[8,22,8,24]]}
["Место продажи ",null,null,null," ",null,null,null,null,"ООО \"ОРИОН\"",null,null,null,null,null,null,null,"Наименование организации ",null,null,null,null,"ОРИОН",null,null,null,null,null,null,null,null,"4545454545454",{"$f":"CONCATENATE(W1)","v":"ОРИОН"},null,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,{"$f":"XIRR(CW1:DU1,CW2:DU2)","v":0.60530990958213804},{"$f":"CM21+(2-CM23)*CM22","v":28},{"$f":"K13","v":12},{"$f":"K20","v":604544},{"$f":"CU1+CU1*CS1/12*CT1/100","v":773816.32000000007},{"$f":"-CU1","v":-604544},{"$f":"ROUND(CV1/CT1,2)","v":64484.69},{"$f":"ROUND(CV1/CT1,2)","v":64484.69},{"$f":"ROUND(CV1/CT1,2)","v":64484.69},{"$f":"IF(CT1<4,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<5,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<6,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<7,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<8,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<9,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<10,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<11,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<12,0,ROUND(CV1/CT1,2))","v":64484.69},{"$f":"IF(CT1<13,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<14,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<15,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<16,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<17,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<18,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<19,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<20,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<21,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<22,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<23,0,ROUND(CV1/CT1,2))","v":0},{"$f":"IF(CT1<24,0,ROUND(CV1/CT1,2))","v":0}]
["Фамилия , имя , отчество Клиента",null,null,null,null,null,null,null,null,null,"Юсуповадибирова  Патиматхамиз  Магомедрасуловнаовна",null,null,null,null,null,null,null,null,null,null,null,null,"тел","8928 569 92 77",null,null,null,null,null,null,"056215620","ОГРНИП","ИНН",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(K2)","v":"Юсуповадибирова Патиматхамиз Магомедрасуловнаовна"},{"$f":"TRIM(Y2)","v":"8928 569 92 77"},null,null,null,null,null,{"$f":"CONCATENATE(K2)","v":"Юсуповадибирова  Патиматхамиз  Магомедрасуловнаовна"},null,null,null,null,null,null,null,null,null,null,"2017-12-01",{"$f":"EDATE(CW2,1)","v":"2018-01-01"},{"$f":"EDATE(CX2,1)","v":"2018-02-01"},"2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01",{"$f":"EDATE(DI2,1)","v":"2019-01-01"},"2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01"]
["Фамилия , имя , отчество Поручителя",null,null,null,null,null,null,null,null,null,"iuyuiyiyi",null,null,null,null,null,null,null,null,null,null,null,null,"тел",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(K3)","v":"iuyuiyiyi"},{"$f":"TRIM(Y3)","v":""},{"$f":"TRIM(#REF!)","v":{"$error":"#REF!"}},{"$f":"TRIM(CK3)","v":""},"",{"$f":"TRIM(CE3)","v":"iuyuiyiyi"},"","","","","","",""]
["Фамилия , имя , отчество Поручителя",null,null,null,null,null,null,null,null,null,"Курамагомедова Маржанат Шарипгаджиевна",null,null,null,null,null,null,null,null,null,null,null,null,"тел",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRIM(K4)","v":"Курамагомедова Маржанат Шарипгаджиевна"},{"$f":"TRIM(Y4)","v":""},{"$f":"TRIM(#REF!)","v":{"$error":"#REF!"}},"","",{"$f":"TRIM(CE4)","v":"Курамагомедова Маржанат Шарипгаджиевна"},"","","","","","",""]
["№ договора ",null,null,null,null,null,null,null,null,null,108,null,null,null,null,null,"АКЦИЯ 0-0-6",null,null,null,null,null,null,"Торговая точка ",null,null,null,null,"ММ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K5)","v":"108"},{"$f":"IF(Q5=\"АКЦИЯ 0-0-6\",\"А\",IF(Q5=\"АКЦИЯ 0-0-12\",\"А\",\"\"))","v":"А"},{"$f":"RIGHT(K5,CS5-CR5)","v":{"$error":"#VALUE!"}},null,null,null,{"$f":"CONCATENATE(K5,CG5,\"/П-\",CH6,CI6,CK6,AC5)","v":"108А/П-0618ММ"},null,null,null,null,null,{"$f":"SEARCH(\"к\",K5)","v":{"$error":"#VALUE!"}},{"$f":"LEN(K5)","v":3},null,null,null,null,null,{"$f":"CONCATENATE(K5)","v":"108"},null,null,null,null,"ОБЫЧНАЯ","АКЦИЯ 0-0-6","АКЦИЯ 7-7-7","АКЦИЯ 0-0-12"]
["Дата заключения ",null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CG6,\".\",CH6,CI6,\".\",CJ6,\"г.\")","v":"25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2018-06-25T17:09:16.230"},{"$f":"CONCATENATE(K6)","v":"25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DAY(AF6)","v":25},null,{"$f":"DAY(AF6)","v":25},{"$f":"IF(CI6<10,0,\"\")","v":0},{"$f":"MONTH(AF6)","v":6},{"$f":"YEAR(AF6)","v":2018},{"$f":"RIGHT(CJ6,2)","v":"18"},{"$f":"CONCATENATE(K5,CG5,\"/КП-\",CH6,CI6,CK6,AC5)","v":"108А/КП-0618ММ"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(K6)","v":"25.06.2018г."}]
["Наименование Товара ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AG5,\"  от  \",AG6)","v":"  от  25.06.2018г."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(CH7,AC5)","v":"А6ММ"},{"$f":"IF(Q5=\"АКЦИЯ 0-0-6\",\"А6\",IF(Q5=\"АКЦИЯ 7-7-7\",\"А7\",IF(Q5=\"АКЦИЯ 0-0-12\",\"А12\",\"\")))","v":"А6"},null,null,null,{"$f":"CONCATENATE(L7)","v":""}]
["Виды Товаров ",null,null,null,null,null,null,"Спальный гарнитур",null,null,"Кухонная мебель",null,null,"Мягкая мебель",null,null,"Бытовая техника",null,null,"Телевизоры",null,null,"Телефоны",null,null,"Шкаф-купе",null,null,"Иное",null,null,0.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Спальный гарнитур","Кухонная мебель","Мягкая мебель","Бытовая техника","Телевизоры","Телефоны","Шкаф-купе","Иное"]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,544545,null,null,null,null,null,{"$f":"K16/4","v":158636},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(CL9:CS9)","v":634544},{"$f":"SUM(H9:J12)","v":0},{"$f":"SUM(K9:M12)","v":0},{"$f":"SUM(N9:P12)","v":0},{"$f":"SUM(Q9:S12)","v":89999},{"$f":"SUM(T9:V12)","v":0},{"$f":"SUM(W9:Y12)","v":0},{"$f":"SUM(Z9:AB12)","v":544545},{"$f":"SUM(AC9:AE12)","v":0}]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(CL9-(K14/CK9)*CL9,2)","v":0},{"$f":"ROUND(CM9-(K14/CK9)*CM9,2)","v":0},{"$f":"ROUND(CN9-(K14/CK9)*CN9,2)","v":0},{"$f":"ROUND(CO9-(K14/CK9)*CO9,2)","v":85744.02},{"$f":"ROUND(CP9-(K14/CK9)*CP9,2)","v":0},{"$f":"ROUND(CQ9-(K14/CK9)*CQ9,2)","v":0},{"$f":"ROUND(CR9-(K14/CK9)*CR9,2)","v":518799.98},{"$f":"ROUND(CS9-(K14/CK9)*CS9,2)","v":0}]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K16*30/100","v":190363.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CL10>0,1,0)","v":0},{"$f":"IF(CM10>0,1,0)","v":0},0,1,0,0,1,0]
["Чеки на сумму ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKDAY(AF6)","v":2}]
["Срок ( в мес)",null,null,null,null,null,null,null,null,null,12,null,null,null,"прописью",null,null,null,{"$f":"ЧислоПропись(K13)","v":"Двенадцать "},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K16*7/100","v":44418.080000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ВС","ПН","ВТ","СР","ЧТ","ПТ","СБ"]
["Обеспечительный взнос ",null,null,null,null,null,null,null,null,null,30000,null,null,null,"Сумма прописью",null,null,null,"Тридцать тысяч ",null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Скидка Киргу",null,"Общая наценка",null,null,null,{"$f":"IF(CI12=1,1,0)","v":0},{"$f":"IF(CI12=2,1,0)","v":1},{"$f":"IF(CI12=3,1,0)","v":0},{"$f":"IF(CI12=4,1,0)","v":0},{"$f":"IF(CI12=5,1,0)","v":0},{"$f":"IF(CI12=6,1,0)","v":0},{"$f":"IF(CI12=7,1,0)","v":0}]
["Количество Поручителей ",null,null,null,null,null,null,null,null,null,1,null,null,null,"прописью",null,null,null,"Один ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K16/2","v":317272},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q5=\"АКЦИЯ 0-0-6\",11,IF(Q5=\"АКЦИЯ 7-7-7\",10,IF(Q5=\"АКЦИЯ 0-0-12\",22,0)))","v":11},{"$f":"ROUND((K16*CE15)/100,2)","v":69799.839999999997},null,{"$f":"ROUND(CF15+K19,0)","v":172572}]
["Стоимость Товара",null,null,null,null,null,null,null,null,null,{"$f":"SUM(CL9:CS9)","v":634544},null,null,null,"Сумма прописью",null,null,null,"Шестьсот тридцать четыре тысячи пятьсот сорок четыре ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S16)","v":"Шестьсот тридцать четыре тысячи пятьсот сорок четыре "}]
["Сумма ежемесячного платежа",null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K18-K14)/K13,0)","v":58943},null,null,null,"Сумма прописью",null,null,null,"Пятьдесят восемь тысяч девятьсот сорок три ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(S17)","v":"Пятьдесят восемь тысяч девятьсот сорок три "}]
["Полная стоимость Товара",null,null,null,null,null,null,null,null,null,{"$f":"K16+K19","v":737316},null,null,null,"Сумма прописью",null,null,null,"Семьсот тридцать семь тысяч триста шестнадцать ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"По Обычной сделке",null,null,null,null,null,{"$f":"CONCATENATE(S18)","v":"Семьсот тридцать семь тысяч триста шестнадцать "}]
["Наша наценка ",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q5=\"АКЦИЯ 7-7-7\",K13<=7),ROUND(K16*CP21/100,0),ROUND((K16-K14)*CP21/12*K13/100,0))","v":102772},null,null,null,"Сумма прописью",null,null,null,"Сто две тысячи семьсот семьдесят два ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((K20*CP24*K13)/(12*100),0)","v":0},null,{"$f":"IF((CN22+CO22)=0,0,IF(CF19-CF15>=0,CF19-CF15,0))","v":0},null,null,null,{"$f":"CONCATENATE(S19)","v":"Сто две тысячи семьсот семьдесят два "},null,null,null,null,null,null,null,null,{"$f":"AND(CM23=1,N9*30/100<K14)","v":true}]
["Сумма финансирования *",null,null,null,null,null,null,null,null,null,{"$f":"K16-K14","v":604544},null,null,null,"Сумма прописью",null,null,null,"Шестьсот четыре тысячи пятьсот сорок четыре ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((CN23+CO23)=0,0,IF(CF19-CF15>=0,CF19-CF15,0))","v":0},null,null,null,{"$f":"CONCATENATE(S20)","v":"Шестьсот четыре тысячи пятьсот сорок четыре "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Минимальная годовая % надбавка",22,null,{"$f":"IF(Q5=\"АКЦИЯ 0-0-6\",CS22+CT22,IF(Q5=\"АКЦИЯ 7-7-7\",CS25+CT25,IF(Q5=\"АКЦИЯ 0-0-12\",CS23+CT23,CT24+CS24)))","v":17},{"$f":"CO21","v":17},null,null,"Наценка по сроку "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Увеличение без поручителей ",6,null,null,null,"АКЦИЯ 0-0-6",null,{"$f":"IF(K13<=6,0,IF(K13<=12,11,22))","v":11},{"$f":"IF(AND(CM23=1,K16*30/100<=K14),0,IF(AND(CM23=0,K16*50/100<=K14),0,IF(CM23=2,0,IF(CM23=1,6,16))))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K15>=2,2,IF(K15=1,1,0))","v":1},null,null,null,"АКЦИЯ 0-0-12",null,{"$f":"IF(K13<=12,0,11)","v":0},{"$f":"IF(AND(CM23=1,K16*30/100<=K14),0,IF(AND(CM23=0,K16*50/100<=K14),0,IF(CM23=2,0,IF(CM23=1,6,16))))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Обычная ",null,22,{"$f":"IF(CM23=2,0,IF(CM23=1,6,16))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"АКЦИЯ 7-7-7 ",null,{"$f":"IF(AND(K13<=7,K14>=AF13),7,IF(K13<=12,28,33))","v":28},{"$f":"IF(AND(CM23=0,K13>7),0,IF(AND(CM23=1,K13>7),-10,IF(AND(CM23=2,K13>7),-16,0)))","v":-10}]