{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["учет","реестр","АКТ_пер","АКТ_возв"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"учет","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"TODAY()","v":"2016-02-16"},null,null,null,null,null,null,null,null,null,"=СУММПРОИЗВ(ЕСЛИ(ЕТЕКСТ(ПОИСК(\"*\"&E$5&\"*\";реестр!C$3:C$100;реестр!C$3));реестр!E$3:E$100))"]
[null,null,null,null,null,null,null,null,null,null,"=ЕСЛИ(И(H5>0;J5>3);ВПР(C5;$O$5:$R$372;4;0);ЕСЛИ(H5>0;ВПР(\"*\"&E5&\"*\";$O$5:$R$372;4;0);\"~\"))"]
[null,null,null,null,null,null,null,null,null,null,"=ЕСЛИ(ИЛИ(ЕТЕКСТ(ПОИСК(\"*\"&E5&\"*\";реестр!$C$3:$C$100;реестр!$C$3)));реестр!$E$3:$E$100;\"\")"]
["Дата отправки","Клиент","Серийный номер","Счетчик при поставке","Ручной ввод КМТ","КМТ","Контроль дней","Дата возврата","Счетчик при возврате","Итого дней","Стоимость","ИТОГО РУБ","Примечание"]
["2016-02-10","ООО 123","QUV0717435",11000,null,{"$f":"IFERROR(IF(C5>0,VLOOKUP(C5,реестр!$B$3:$F$101,2,0),\"~\"),\"нет КМТ в реестре\")","v":"Kyocera FS-1028MFP ч/б"},{"$f":"IF(A5>0,IF(H5=0,NETWORKDAYS(A5,$A$1),\"\"),\"~\")","v":""},"2016-02-15",11345,{"$f":"IFERROR(IF(H5>0,CONCATENATE(NETWORKDAYS(A5,H5),\"дн / \",TEXT(I5-D5,\"#'###\"),\"стр\"),\"~\"),\"~\")","v":"4дн / '345стр"},{"$f":"IF(AND(F5>0,E5=0),VLOOKUP(C5,реестр!B$3:F$101,4,0),IF(H5>0,VLOOKUP(\"*\"&E5&\"*\",реестр!C$3:E$101,3,0)))","v":0.6},{"$f":"IFERROR(IF(J5>3,(I5-D5)*K5,0),\"~\")","v":207},"картридж"]
["2016-02-10","dssdfsf","CNBF037347",12500,"3020",{"$f":"IFERROR(IF(C6>0,VLOOKUP(C6,реестр!$B$3:$F$101,2,0),\"~\"),\"нет КМТ в реестре\")","v":"нет КМТ в реестре"},{"$f":"IF(A6>0,IF(H6=0,NETWORKDAYS(A6,$A$1),\"\"),\"~\")","v":""},"2016-02-15",12700,{"$f":"IFERROR(IF(H6>0,CONCATENATE(NETWORKDAYS(A6,H6),\"дн / \",TEXT(I6-D6,\"#'###\"),\"стр\"),\"~\"),\"~\")","v":"4дн / '200стр"},{"$f":"IF(AND(F6>0,E6=0),VLOOKUP(C6,реестр!B$3:F$101,4,0),IF(H6>0,VLOOKUP(\"*\"&E6&\"*\",реестр!C$3:E$101,3,0)))","v":0.3},{"$f":"IFERROR(IF(J6>3,(I6-D6)*K6,0),\"~\")","v":60}]

{"sheet":"реестр","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Подменные аппараты",null,null,null,"2016-02-10","2016-02-15","расширение таблицы вправо по необходимости вручную. Может как-то иначе? "]
["№","Серийный номер","Модель аппарата","Счетчик","Стоимость1","Стоимость2"]
[1,"CNCW77H57K","HP Color LJ 2605","нет желтого картриджа",7,7]
[2,"CNHW591HJ7","HP LJ 1320 ч/б",80006,0.2,0.2]
[3,"CNBF037348","HP LJ 3020 ч/б",129395,0.3,0.3]
[4,"CNSK662430","HP LJ 3055 ч/б",245617,0.4,0.4]
[5,"CNBW78Q3FV","HP LJ P2015 ч/б",23334,0.5,0.5]
[6,"QUV0717435","Kyocera FS-1028MFP ч/б",228647,0.6,0.6]
[7,"QUV1231775","Kyocera FS-1028MFP ч/б",139951,0.7,0.7]
[8,"QUV0717740","Kyocera FS-1028MFP ч/б",129787,0.7,0.7]
[9,"NWD3506621","Kyocera FS-1125MFP ч/б",73480,0.8,0.8]
[10,"NR72114939","Kyocera FS-1135MFP ч/б",145983,0.9,0.9]
[11,"NNL2302297","Kyocera FS-3040MFP+ ч/б",907512,1,1]
[12,"NUD3606928","Kyocera FS-4300DN ч/б",666111,1.1000000000000001,1.1000000000000001]
[13,"NUD3606994","Kyocera FS-4300DN ч/б",444196,1.2,1.2]
[14,"XAA2108573","Kyocera FS-6970DN ч/б",286430,1.3,1.3]
[15,"LDC4315407","KM 1025",34560,1.4,1.4]
[16,"AGK3128900","KM 1650",163828,1.5,1.5]
[17,"NWD2Y02475","KM 1125",61947,1.6,1.6]
[18,"NUD3606852","KM 4300",827971,1.7,1.7]
[19,"LW45225343","KM 6021",2742,1.8,1.8]

{"sheet":"АКТ_пер","index":2,"n_rows":52,"n_cols":29,"rows_kept":52,"cut":false,"hidden":false,"merged":[[13,1,13,16],[13,17,13,23],[13,24,13,28],[6,1,6,16],[6,17,6,23],[6,24,6,28],[7,11,7,28],[12,1,12,16],[12,17,12,23],[12,24,12,28],[0,23,0,28],[1,11,1,16],[2,9,2,18],[5,1,5,16],[5,17,5,23],[5,24,5,28]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-02-16"}]
[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,"счетчик стр"]
[1,"= от руки",null,null,null,null,null,null,null,null,null,null,null,null,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,"счетчик стр"]
[1,"=учет!F5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=учет!C5",null,null,null,null,null,null,"=учет!D5"]
["Обе Стороны подверждают полную исправность, целостность и работоспособность, передава-"]
["емого в п.2, оборудования."]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12,null,null,null,null,null,null,null,null,null,null,"Ctrl + P - вручную"]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]

{"sheet":"АКТ_возв","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}