{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["z","l","db","in","out","tot","zav","!!!"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"comments":4,"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":"z","index":0,"n_rows":101,"n_cols":6,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":"#N/A","v":{"$error":"#N/A"}},null,{"$f":"SUM(D2:D101)","v":0},{"$f":"COUNTIF(A2:A101,\"><\"\"\")","v":0},{"$f":"E1<>B1","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]
[{"$f":"#N/A","v":{"$error":"#N/A"}}]

{"sheet":"l","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["NN","Категория","Наимeнование","ед изм","дата посл поставки","цена посл поставки","Столбец2","Действ цена","с даты","01.07.17","02.08.17","15.02.17","03.08.17","Столбец1"]
[{"$f":"ROW()-ROW($A$2)","v":1},"кат1","имя1",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-10"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,{"$f":"LOOKUP(99^99,$J3:$BK3)","v":5},{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J3:$BP3,$J$2:$BP$2)","v":"2017-08-03"},1,4,null,5]
[{"$f":"ROW()-ROW($A$2)","v":2},"кат1","имя2",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-11"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,{"$f":"LOOKUP(99^99,$J4:$BK4)","v":2},{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J4:$BP4,$J$2:$BP$2)","v":"2017-07-01"},2]
[3,"кат1","имя3",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-12"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,3,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J5:$BP5,$J$2:$BP$2)","v":"2017-07-01"},3]
[4,"кат2","имя4",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-13"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,4,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J6:$BP6,$J$2:$BP$2)","v":"2017-07-01"},4]
[5,"кат2","имя5",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-14"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,5,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J7:$BP7,$J$2:$BP$2)","v":"2017-07-01"},5]
[6,"кат2","имя6",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-15"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,8,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J8:$BP8,$J$2:$BP$2)","v":"2017-02-15"},6,null,8]
[7,"кат3","имя7",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-16"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,7,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J9:$BP9,$J$2:$BP$2)","v":"2017-07-01"},7]
[8,"кат3","имя8",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-17"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,8,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J10:$BP10,$J$2:$BP$2)","v":"2017-07-01"},8]
[{"$f":"ROW()-ROW($A$2)","v":9},"кат3","имя9",null,{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]))","v":"2017-11-18"},{"$f":"LOOKUP(tot!$A$1,_db[дата]/(_db[приход]>0)/(_pr[[#This Row],[Наимeнование]]=_db[наименование]),_db[цена с НДС])","v":11},null,9,{"$f":"--LOOKUP(_pr[[#This Row],[Действ цена]],$J11:$BP11,$J$2:$BP$2)","v":"2017-07-01"},9]

{"sheet":"db","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["2019-05-05",null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,_db[приход])","v":40},{"$f":"_xlfn.AGGREGATE(9,5,_db[расход])","v":6},null,null,null,{"$f":"MATCH(\"дата/время формирования накладной\",2:2,)","v":13}]
["категория","наименование","дата","ед изм","приход","расход","От кого","Кому","основание/назначение","ном вх накладной","дата накл","цена с НДС","дата/время формирования накладной","прим"]
["кат1","имя1","2017-09-01",null,2,null,null,null,null,null,null,11]
["кат2","имя4","2017-10-01",null,2,null,null,null,null,null,null,11]
["кат1","имя1","2017-11-01",null,1,null,null,null,null,null,null,13]
["кат1","имя3","2017-11-01",null,1,3,"rhhe","врврве","ui7io7",null,null,10,"2018-07-02T18:09:02"]
["кат2","имя5","2017-11-01",null,1,null,"rhhe","врврве",null,null,null,10]
["кат2","имя6","2017-11-01",null,2,3,"rhhe","врврве",null,null,null,11,"2018-07-02T18:09:02"]
["кат3","имя7","2017-11-01",null,1,null,"555e",null,null,null,null,10]
["кат3","имя8","2017-11-03",null,4,null,null,null,null,null,null,8]
["кат3","имя9","2017-11-05",null,3,null,null,null,null,null,null,9]
["кат3","имя9","2017-11-07",null,1,null,null,null,null,null,null,10]
["кат3","имя8","2017-11-09",null,2,null,null,null,null,null,null,11]
[null,"имя1","2017-11-10",null,2,null,null,null,null,null,null,11]
[null,"имя2","2017-11-11",null,2,null,null,null,null,null,null,11]
[null,"имя3","2017-11-12",null,2,null,null,null,null,null,null,11]
[null,"имя4","2017-11-13",null,2,null,null,null,null,null,null,11]
[null,"имя5","2017-11-14",null,2,null,null,null,null,null,null,11]
[null,"имя6","2017-11-15",null,2,null,null,null,null,null,null,11]
[null,"имя7","2017-11-16",null,2,null,null,null,null,null,null,11]
[null,"имя8","2017-11-17",null,2,null,null,null,null,null,null,11]
[null,"имя9","2017-11-18",null,2,null,null,null,null,null,null,11]
[null,"имя9","2017-11-18",null,2,null,null,null,null,null,null,11]

{"sheet":"in","index":3,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,1,4,3]]}
["НАКЛАДНАЯ НА ПРИЕМ ТМЦ НА СКЛАД",null,null,null,null,"служебный столбец и правее, не влезать, не менять ничего",{"$f":"MATCH(\"Наименование\",B1:B18,)+1","v":7},"первый ряд таблицы",{"$f":"MATCH(\"сдал\",A1:A64,)-G1","v":50},"кол-во рядов таблицы"]
["Дата/время",{"$f":"INDEX(_db[дата],in!F7-F2)","v":"2017-11-01"},null,null,null,{"$f":"MATCH(\"дата\",db!C1:C6,)","v":2}]
["От кого",{"$f":"B57","v":"rhhe"}]
["Кому","СКЛАД"]
["Основание/\nназначение",null,null,null,null,null,{"$f":"OR(H5<>F57,I5<>F57)","v":false},{"$f":"COUNTIF(H7:H56,B2)","v":2},{"$f":"COUNTIF(I7:I56,B57)","v":2}]
["ном","Наименование","ед изм","кол-во"]
[1,{"$f":"IF($F7=0,\"\",INDEX(_db[наименование],$F7-$F$2))","v":"имя3"},{"$f":"IF($F7=0,\"\",INDEX(_db[ед изм],$F7-$F$2))","v":0},{"$f":"IF(F7=0,\"\",INDEX(_db[расход],$F7-$F$2))","v":3},null,6,null,{"$f":"IF($F7=0,\"\",INDEX(_db[дата],$F7-$F$2))","v":"2017-11-01"},{"$f":"IF($F7=0,\"\",INDEX(_db[От кого],$F7-$F$2))","v":"rhhe"}]
[2,{"$f":"IF($F8=0,\"\",INDEX(_db[наименование],$F8-$F$2))","v":"имя6"},{"$f":"IF($F8=0,\"\",INDEX(_db[ед изм],$F8-$F$2))","v":0},{"$f":"IF(F8=0,\"\",INDEX(_db[расход],$F8-$F$2))","v":3},null,8,null,{"$f":"IF($F8=0,\"\",INDEX(_db[дата],$F8-$F$2))","v":"2017-11-01"},{"$f":"IF($F8=0,\"\",INDEX(_db[От кого],$F8-$F$2))","v":"rhhe"}]
[3,{"$f":"IF($F9=0,\"\",INDEX(_db[наименование],$F9-$F$2))","v":""},{"$f":"IF($F9=0,\"\",INDEX(_db[ед изм],$F9-$F$2))","v":""},{"$f":"IF(F9=0,\"\",INDEX(_db[расход],$F9-$F$2))","v":""},null,null,null,{"$f":"IF($F9=0,\"\",INDEX(_db[дата],$F9-$F$2))","v":""},{"$f":"IF($F9=0,\"\",INDEX(_db[От кого],$F9-$F$2))","v":""}]
[4,{"$f":"IF($F10=0,\"\",INDEX(_db[наименование],$F10-$F$2))","v":""},{"$f":"IF($F10=0,\"\",INDEX(_db[ед изм],$F10-$F$2))","v":""},{"$f":"IF(F10=0,\"\",INDEX(_db[расход],$F10-$F$2))","v":""},null,null,null,{"$f":"IF($F10=0,\"\",INDEX(_db[дата],$F10-$F$2))","v":""},{"$f":"IF($F10=0,\"\",INDEX(_db[От кого],$F10-$F$2))","v":""}]
[5,{"$f":"IF($F11=0,\"\",INDEX(_db[наименование],$F11-$F$2))","v":""},{"$f":"IF($F11=0,\"\",INDEX(_db[ед изм],$F11-$F$2))","v":""},{"$f":"IF(F11=0,\"\",INDEX(_db[расход],$F11-$F$2))","v":""},null,null,null,{"$f":"IF($F11=0,\"\",INDEX(_db[дата],$F11-$F$2))","v":""},{"$f":"IF($F11=0,\"\",INDEX(_db[От кого],$F11-$F$2))","v":""}]
[6,{"$f":"IF($F12=0,\"\",INDEX(_db[наименование],$F12-$F$2))","v":""},{"$f":"IF($F12=0,\"\",INDEX(_db[ед изм],$F12-$F$2))","v":""},{"$f":"IF(F12=0,\"\",INDEX(_db[расход],$F12-$F$2))","v":""},null,null,null,{"$f":"IF($F12=0,\"\",INDEX(_db[дата],$F12-$F$2))","v":""},{"$f":"IF($F12=0,\"\",INDEX(_db[От кого],$F12-$F$2))","v":""}]
[7,{"$f":"IF($F13=0,\"\",INDEX(_db[наименование],$F13-$F$2))","v":""},{"$f":"IF($F13=0,\"\",INDEX(_db[ед изм],$F13-$F$2))","v":""},{"$f":"IF(F13=0,\"\",INDEX(_db[расход],$F13-$F$2))","v":""},null,null,null,{"$f":"IF($F13=0,\"\",INDEX(_db[дата],$F13-$F$2))","v":""},{"$f":"IF($F13=0,\"\",INDEX(_db[От кого],$F13-$F$2))","v":""}]
[8,{"$f":"IF($F14=0,\"\",INDEX(_db[наименование],$F14-$F$2))","v":""},{"$f":"IF($F14=0,\"\",INDEX(_db[ед изм],$F14-$F$2))","v":""},{"$f":"IF(F14=0,\"\",INDEX(_db[расход],$F14-$F$2))","v":""},null,null,null,{"$f":"IF($F14=0,\"\",INDEX(_db[дата],$F14-$F$2))","v":""},{"$f":"IF($F14=0,\"\",INDEX(_db[От кого],$F14-$F$2))","v":""}]
[9,{"$f":"IF($F15=0,\"\",INDEX(_db[наименование],$F15-$F$2))","v":""},{"$f":"IF($F15=0,\"\",INDEX(_db[ед изм],$F15-$F$2))","v":""},{"$f":"IF(F15=0,\"\",INDEX(_db[расход],$F15-$F$2))","v":""},null,null,null,{"$f":"IF($F15=0,\"\",INDEX(_db[дата],$F15-$F$2))","v":""},{"$f":"IF($F15=0,\"\",INDEX(_db[От кого],$F15-$F$2))","v":""}]
[10,{"$f":"IF($F16=0,\"\",INDEX(_db[наименование],$F16-$F$2))","v":""},{"$f":"IF($F16=0,\"\",INDEX(_db[ед изм],$F16-$F$2))","v":""},{"$f":"IF(F16=0,\"\",INDEX(_db[расход],$F16-$F$2))","v":""},null,null,null,{"$f":"IF($F16=0,\"\",INDEX(_db[дата],$F16-$F$2))","v":""},{"$f":"IF($F16=0,\"\",INDEX(_db[От кого],$F16-$F$2))","v":""}]
[11,{"$f":"IF($F17=0,\"\",INDEX(_db[наименование],$F17-$F$2))","v":""},{"$f":"IF($F17=0,\"\",INDEX(_db[ед изм],$F17-$F$2))","v":""},{"$f":"IF(F17=0,\"\",INDEX(_db[расход],$F17-$F$2))","v":""},null,null,null,{"$f":"IF($F17=0,\"\",INDEX(_db[дата],$F17-$F$2))","v":""},{"$f":"IF($F17=0,\"\",INDEX(_db[От кого],$F17-$F$2))","v":""}]
[12,{"$f":"IF($F18=0,\"\",INDEX(_db[наименование],$F18-$F$2))","v":""},{"$f":"IF($F18=0,\"\",INDEX(_db[ед изм],$F18-$F$2))","v":""},{"$f":"IF(F18=0,\"\",INDEX(_db[расход],$F18-$F$2))","v":""},null,null,null,{"$f":"IF($F18=0,\"\",INDEX(_db[дата],$F18-$F$2))","v":""},{"$f":"IF($F18=0,\"\",INDEX(_db[От кого],$F18-$F$2))","v":""}]
[13,{"$f":"IF($F19=0,\"\",INDEX(_db[наименование],$F19-$F$2))","v":""},{"$f":"IF($F19=0,\"\",INDEX(_db[ед изм],$F19-$F$2))","v":""},{"$f":"IF(F19=0,\"\",INDEX(_db[расход],$F19-$F$2))","v":""},null,null,null,{"$f":"IF($F19=0,\"\",INDEX(_db[дата],$F19-$F$2))","v":""},{"$f":"IF($F19=0,\"\",INDEX(_db[От кого],$F19-$F$2))","v":""}]
[14,{"$f":"IF($F20=0,\"\",INDEX(_db[наименование],$F20-$F$2))","v":""},{"$f":"IF($F20=0,\"\",INDEX(_db[ед изм],$F20-$F$2))","v":""},{"$f":"IF(F20=0,\"\",INDEX(_db[расход],$F20-$F$2))","v":""},null,null,null,{"$f":"IF($F20=0,\"\",INDEX(_db[дата],$F20-$F$2))","v":""},{"$f":"IF($F20=0,\"\",INDEX(_db[От кого],$F20-$F$2))","v":""}]
[15,{"$f":"IF($F21=0,\"\",INDEX(_db[наименование],$F21-$F$2))","v":""},{"$f":"IF($F21=0,\"\",INDEX(_db[ед изм],$F21-$F$2))","v":""},{"$f":"IF(F21=0,\"\",INDEX(_db[расход],$F21-$F$2))","v":""},null,null,null,{"$f":"IF($F21=0,\"\",INDEX(_db[дата],$F21-$F$2))","v":""},{"$f":"IF($F21=0,\"\",INDEX(_db[От кого],$F21-$F$2))","v":""}]
[16,{"$f":"IF($F22=0,\"\",INDEX(_db[наименование],$F22-$F$2))","v":""},{"$f":"IF($F22=0,\"\",INDEX(_db[ед изм],$F22-$F$2))","v":""},{"$f":"IF(F22=0,\"\",INDEX(_db[расход],$F22-$F$2))","v":""},null,null,null,{"$f":"IF($F22=0,\"\",INDEX(_db[дата],$F22-$F$2))","v":""},{"$f":"IF($F22=0,\"\",INDEX(_db[От кого],$F22-$F$2))","v":""}]
[17,{"$f":"IF($F23=0,\"\",INDEX(_db[наименование],$F23-$F$2))","v":""},{"$f":"IF($F23=0,\"\",INDEX(_db[ед изм],$F23-$F$2))","v":""},{"$f":"IF(F23=0,\"\",INDEX(_db[расход],$F23-$F$2))","v":""},null,null,null,{"$f":"IF($F23=0,\"\",INDEX(_db[дата],$F23-$F$2))","v":""},{"$f":"IF($F23=0,\"\",INDEX(_db[От кого],$F23-$F$2))","v":""}]
[18,{"$f":"IF($F24=0,\"\",INDEX(_db[наименование],$F24-$F$2))","v":""},{"$f":"IF($F24=0,\"\",INDEX(_db[ед изм],$F24-$F$2))","v":""},{"$f":"IF(F24=0,\"\",INDEX(_db[расход],$F24-$F$2))","v":""},null,null,null,{"$f":"IF($F24=0,\"\",INDEX(_db[дата],$F24-$F$2))","v":""},{"$f":"IF($F24=0,\"\",INDEX(_db[От кого],$F24-$F$2))","v":""}]
[19,{"$f":"IF($F25=0,\"\",INDEX(_db[наименование],$F25-$F$2))","v":""},{"$f":"IF($F25=0,\"\",INDEX(_db[ед изм],$F25-$F$2))","v":""},{"$f":"IF(F25=0,\"\",INDEX(_db[расход],$F25-$F$2))","v":""},null,null,null,{"$f":"IF($F25=0,\"\",INDEX(_db[дата],$F25-$F$2))","v":""},{"$f":"IF($F25=0,\"\",INDEX(_db[От кого],$F25-$F$2))","v":""}]
[20,{"$f":"IF($F26=0,\"\",INDEX(_db[наименование],$F26-$F$2))","v":""},{"$f":"IF($F26=0,\"\",INDEX(_db[ед изм],$F26-$F$2))","v":""},{"$f":"IF(F26=0,\"\",INDEX(_db[расход],$F26-$F$2))","v":""},null,null,null,{"$f":"IF($F26=0,\"\",INDEX(_db[дата],$F26-$F$2))","v":""},{"$f":"IF($F26=0,\"\",INDEX(_db[От кого],$F26-$F$2))","v":""}]
[21,{"$f":"IF($F27=0,\"\",INDEX(_db[наименование],$F27-$F$2))","v":""},{"$f":"IF($F27=0,\"\",INDEX(_db[ед изм],$F27-$F$2))","v":""},{"$f":"IF(F27=0,\"\",INDEX(_db[расход],$F27-$F$2))","v":""},null,null,null,{"$f":"IF($F27=0,\"\",INDEX(_db[дата],$F27-$F$2))","v":""},{"$f":"IF($F27=0,\"\",INDEX(_db[От кого],$F27-$F$2))","v":""}]
[22,{"$f":"IF($F28=0,\"\",INDEX(_db[наименование],$F28-$F$2))","v":""},{"$f":"IF($F28=0,\"\",INDEX(_db[ед изм],$F28-$F$2))","v":""},{"$f":"IF(F28=0,\"\",INDEX(_db[расход],$F28-$F$2))","v":""},null,null,null,{"$f":"IF($F28=0,\"\",INDEX(_db[дата],$F28-$F$2))","v":""},{"$f":"IF($F28=0,\"\",INDEX(_db[От кого],$F28-$F$2))","v":""}]
[23,{"$f":"IF($F29=0,\"\",INDEX(_db[наименование],$F29-$F$2))","v":""},{"$f":"IF($F29=0,\"\",INDEX(_db[ед изм],$F29-$F$2))","v":""},{"$f":"IF(F29=0,\"\",INDEX(_db[расход],$F29-$F$2))","v":""},null,null,null,{"$f":"IF($F29=0,\"\",INDEX(_db[дата],$F29-$F$2))","v":""},{"$f":"IF($F29=0,\"\",INDEX(_db[От кого],$F29-$F$2))","v":""}]
[24,{"$f":"IF($F30=0,\"\",INDEX(_db[наименование],$F30-$F$2))","v":""},{"$f":"IF($F30=0,\"\",INDEX(_db[ед изм],$F30-$F$2))","v":""},{"$f":"IF(F30=0,\"\",INDEX(_db[расход],$F30-$F$2))","v":""},null,null,null,{"$f":"IF($F30=0,\"\",INDEX(_db[дата],$F30-$F$2))","v":""},{"$f":"IF($F30=0,\"\",INDEX(_db[От кого],$F30-$F$2))","v":""}]
[25,{"$f":"IF($F31=0,\"\",INDEX(_db[наименование],$F31-$F$2))","v":""},{"$f":"IF($F31=0,\"\",INDEX(_db[ед изм],$F31-$F$2))","v":""},{"$f":"IF(F31=0,\"\",INDEX(_db[расход],$F31-$F$2))","v":""},null,null,null,{"$f":"IF($F31=0,\"\",INDEX(_db[дата],$F31-$F$2))","v":""},{"$f":"IF($F31=0,\"\",INDEX(_db[От кого],$F31-$F$2))","v":""}]
[26,{"$f":"IF($F32=0,\"\",INDEX(_db[наименование],$F32-$F$2))","v":""},{"$f":"IF($F32=0,\"\",INDEX(_db[ед изм],$F32-$F$2))","v":""},{"$f":"IF(F32=0,\"\",INDEX(_db[расход],$F32-$F$2))","v":""},null,null,null,{"$f":"IF($F32=0,\"\",INDEX(_db[дата],$F32-$F$2))","v":""},{"$f":"IF($F32=0,\"\",INDEX(_db[От кого],$F32-$F$2))","v":""}]
[27,{"$f":"IF($F33=0,\"\",INDEX(_db[наименование],$F33-$F$2))","v":""},{"$f":"IF($F33=0,\"\",INDEX(_db[ед изм],$F33-$F$2))","v":""},{"$f":"IF(F33=0,\"\",INDEX(_db[расход],$F33-$F$2))","v":""},null,null,null,{"$f":"IF($F33=0,\"\",INDEX(_db[дата],$F33-$F$2))","v":""},{"$f":"IF($F33=0,\"\",INDEX(_db[От кого],$F33-$F$2))","v":""}]
[28,{"$f":"IF($F34=0,\"\",INDEX(_db[наименование],$F34-$F$2))","v":""},{"$f":"IF($F34=0,\"\",INDEX(_db[ед изм],$F34-$F$2))","v":""},{"$f":"IF(F34=0,\"\",INDEX(_db[расход],$F34-$F$2))","v":""},null,null,null,{"$f":"IF($F34=0,\"\",INDEX(_db[дата],$F34-$F$2))","v":""},{"$f":"IF($F34=0,\"\",INDEX(_db[От кого],$F34-$F$2))","v":""}]
[29,{"$f":"IF($F35=0,\"\",INDEX(_db[наименование],$F35-$F$2))","v":""},{"$f":"IF($F35=0,\"\",INDEX(_db[ед изм],$F35-$F$2))","v":""},{"$f":"IF(F35=0,\"\",INDEX(_db[расход],$F35-$F$2))","v":""},null,null,null,{"$f":"IF($F35=0,\"\",INDEX(_db[дата],$F35-$F$2))","v":""},{"$f":"IF($F35=0,\"\",INDEX(_db[От кого],$F35-$F$2))","v":""}]
[30,{"$f":"IF($F36=0,\"\",INDEX(_db[наименование],$F36-$F$2))","v":""},{"$f":"IF($F36=0,\"\",INDEX(_db[ед изм],$F36-$F$2))","v":""},{"$f":"IF(F36=0,\"\",INDEX(_db[расход],$F36-$F$2))","v":""},null,null,null,{"$f":"IF($F36=0,\"\",INDEX(_db[дата],$F36-$F$2))","v":""},{"$f":"IF($F36=0,\"\",INDEX(_db[От кого],$F36-$F$2))","v":""}]
[31,{"$f":"IF($F37=0,\"\",INDEX(_db[наименование],$F37-$F$2))","v":""},{"$f":"IF($F37=0,\"\",INDEX(_db[ед изм],$F37-$F$2))","v":""},{"$f":"IF(F37=0,\"\",INDEX(_db[расход],$F37-$F$2))","v":""},null,null,null,{"$f":"IF($F37=0,\"\",INDEX(_db[дата],$F37-$F$2))","v":""},{"$f":"IF($F37=0,\"\",INDEX(_db[От кого],$F37-$F$2))","v":""}]
[32,{"$f":"IF($F38=0,\"\",INDEX(_db[наименование],$F38-$F$2))","v":""},{"$f":"IF($F38=0,\"\",INDEX(_db[ед изм],$F38-$F$2))","v":""},{"$f":"IF(F38=0,\"\",INDEX(_db[расход],$F38-$F$2))","v":""},null,null,null,{"$f":"IF($F38=0,\"\",INDEX(_db[дата],$F38-$F$2))","v":""},{"$f":"IF($F38=0,\"\",INDEX(_db[От кого],$F38-$F$2))","v":""}]
[33,{"$f":"IF($F39=0,\"\",INDEX(_db[наименование],$F39-$F$2))","v":""},{"$f":"IF($F39=0,\"\",INDEX(_db[ед изм],$F39-$F$2))","v":""},{"$f":"IF(F39=0,\"\",INDEX(_db[расход],$F39-$F$2))","v":""},null,null,null,{"$f":"IF($F39=0,\"\",INDEX(_db[дата],$F39-$F$2))","v":""},{"$f":"IF($F39=0,\"\",INDEX(_db[От кого],$F39-$F$2))","v":""}]
[34,{"$f":"IF($F40=0,\"\",INDEX(_db[наименование],$F40-$F$2))","v":""},{"$f":"IF($F40=0,\"\",INDEX(_db[ед изм],$F40-$F$2))","v":""},{"$f":"IF(F40=0,\"\",INDEX(_db[расход],$F40-$F$2))","v":""},null,null,null,{"$f":"IF($F40=0,\"\",INDEX(_db[дата],$F40-$F$2))","v":""},{"$f":"IF($F40=0,\"\",INDEX(_db[От кого],$F40-$F$2))","v":""}]
[35,{"$f":"IF($F41=0,\"\",INDEX(_db[наименование],$F41-$F$2))","v":""},{"$f":"IF($F41=0,\"\",INDEX(_db[ед изм],$F41-$F$2))","v":""},{"$f":"IF(F41=0,\"\",INDEX(_db[расход],$F41-$F$2))","v":""},null,null,null,{"$f":"IF($F41=0,\"\",INDEX(_db[дата],$F41-$F$2))","v":""},{"$f":"IF($F41=0,\"\",INDEX(_db[От кого],$F41-$F$2))","v":""}]
[36,{"$f":"IF($F42=0,\"\",INDEX(_db[наименование],$F42-$F$2))","v":""},{"$f":"IF($F42=0,\"\",INDEX(_db[ед изм],$F42-$F$2))","v":""},{"$f":"IF(F42=0,\"\",INDEX(_db[расход],$F42-$F$2))","v":""},null,null,null,{"$f":"IF($F42=0,\"\",INDEX(_db[дата],$F42-$F$2))","v":""},{"$f":"IF($F42=0,\"\",INDEX(_db[От кого],$F42-$F$2))","v":""}]
[37,{"$f":"IF($F43=0,\"\",INDEX(_db[наименование],$F43-$F$2))","v":""},{"$f":"IF($F43=0,\"\",INDEX(_db[ед изм],$F43-$F$2))","v":""},{"$f":"IF(F43=0,\"\",INDEX(_db[расход],$F43-$F$2))","v":""},null,null,null,{"$f":"IF($F43=0,\"\",INDEX(_db[дата],$F43-$F$2))","v":""},{"$f":"IF($F43=0,\"\",INDEX(_db[От кого],$F43-$F$2))","v":""}]
[38,{"$f":"IF($F44=0,\"\",INDEX(_db[наименование],$F44-$F$2))","v":""},{"$f":"IF($F44=0,\"\",INDEX(_db[ед изм],$F44-$F$2))","v":""},{"$f":"IF(F44=0,\"\",INDEX(_db[расход],$F44-$F$2))","v":""},null,null,null,{"$f":"IF($F44=0,\"\",INDEX(_db[дата],$F44-$F$2))","v":""},{"$f":"IF($F44=0,\"\",INDEX(_db[От кого],$F44-$F$2))","v":""}]
[39,{"$f":"IF($F45=0,\"\",INDEX(_db[наименование],$F45-$F$2))","v":""},{"$f":"IF($F45=0,\"\",INDEX(_db[ед изм],$F45-$F$2))","v":""},{"$f":"IF(F45=0,\"\",INDEX(_db[расход],$F45-$F$2))","v":""},null,null,null,{"$f":"IF($F45=0,\"\",INDEX(_db[дата],$F45-$F$2))","v":""},{"$f":"IF($F45=0,\"\",INDEX(_db[От кого],$F45-$F$2))","v":""}]
[40,{"$f":"IF($F46=0,\"\",INDEX(_db[наименование],$F46-$F$2))","v":""},{"$f":"IF($F46=0,\"\",INDEX(_db[ед изм],$F46-$F$2))","v":""},{"$f":"IF(F46=0,\"\",INDEX(_db[расход],$F46-$F$2))","v":""},null,null,null,{"$f":"IF($F46=0,\"\",INDEX(_db[дата],$F46-$F$2))","v":""},{"$f":"IF($F46=0,\"\",INDEX(_db[От кого],$F46-$F$2))","v":""}]
[41,{"$f":"IF($F47=0,\"\",INDEX(_db[наименование],$F47-$F$2))","v":""},{"$f":"IF($F47=0,\"\",INDEX(_db[ед изм],$F47-$F$2))","v":""},{"$f":"IF(F47=0,\"\",INDEX(_db[расход],$F47-$F$2))","v":""},null,null,null,{"$f":"IF($F47=0,\"\",INDEX(_db[дата],$F47-$F$2))","v":""},{"$f":"IF($F47=0,\"\",INDEX(_db[От кого],$F47-$F$2))","v":""}]
[42,{"$f":"IF($F48=0,\"\",INDEX(_db[наименование],$F48-$F$2))","v":""},{"$f":"IF($F48=0,\"\",INDEX(_db[ед изм],$F48-$F$2))","v":""},{"$f":"IF(F48=0,\"\",INDEX(_db[расход],$F48-$F$2))","v":""},null,null,null,{"$f":"IF($F48=0,\"\",INDEX(_db[дата],$F48-$F$2))","v":""},{"$f":"IF($F48=0,\"\",INDEX(_db[От кого],$F48-$F$2))","v":""}]
[43,{"$f":"IF($F49=0,\"\",INDEX(_db[наименование],$F49-$F$2))","v":""},{"$f":"IF($F49=0,\"\",INDEX(_db[ед изм],$F49-$F$2))","v":""},{"$f":"IF(F49=0,\"\",INDEX(_db[расход],$F49-$F$2))","v":""},null,null,null,{"$f":"IF($F49=0,\"\",INDEX(_db[дата],$F49-$F$2))","v":""},{"$f":"IF($F49=0,\"\",INDEX(_db[От кого],$F49-$F$2))","v":""}]
[44,{"$f":"IF($F50=0,\"\",INDEX(_db[наименование],$F50-$F$2))","v":""},{"$f":"IF($F50=0,\"\",INDEX(_db[ед изм],$F50-$F$2))","v":""},{"$f":"IF(F50=0,\"\",INDEX(_db[расход],$F50-$F$2))","v":""},null,null,null,{"$f":"IF($F50=0,\"\",INDEX(_db[дата],$F50-$F$2))","v":""},{"$f":"IF($F50=0,\"\",INDEX(_db[От кого],$F50-$F$2))","v":""}]
[45,{"$f":"IF($F51=0,\"\",INDEX(_db[наименование],$F51-$F$2))","v":""},{"$f":"IF($F51=0,\"\",INDEX(_db[ед изм],$F51-$F$2))","v":""},{"$f":"IF(F51=0,\"\",INDEX(_db[расход],$F51-$F$2))","v":""},null,null,null,{"$f":"IF($F51=0,\"\",INDEX(_db[дата],$F51-$F$2))","v":""},{"$f":"IF($F51=0,\"\",INDEX(_db[От кого],$F51-$F$2))","v":""}]
[46,{"$f":"IF($F52=0,\"\",INDEX(_db[наименование],$F52-$F$2))","v":""},{"$f":"IF($F52=0,\"\",INDEX(_db[ед изм],$F52-$F$2))","v":""},{"$f":"IF(F52=0,\"\",INDEX(_db[расход],$F52-$F$2))","v":""},null,null,null,{"$f":"IF($F52=0,\"\",INDEX(_db[дата],$F52-$F$2))","v":""},{"$f":"IF($F52=0,\"\",INDEX(_db[От кого],$F52-$F$2))","v":""}]
[47,{"$f":"IF($F53=0,\"\",INDEX(_db[наименование],$F53-$F$2))","v":""},{"$f":"IF($F53=0,\"\",INDEX(_db[ед изм],$F53-$F$2))","v":""},{"$f":"IF(F53=0,\"\",INDEX(_db[расход],$F53-$F$2))","v":""},null,null,null,{"$f":"IF($F53=0,\"\",INDEX(_db[дата],$F53-$F$2))","v":""},{"$f":"IF($F53=0,\"\",INDEX(_db[От кого],$F53-$F$2))","v":""}]
[48,{"$f":"IF($F54=0,\"\",INDEX(_db[наименование],$F54-$F$2))","v":""},{"$f":"IF($F54=0,\"\",INDEX(_db[ед изм],$F54-$F$2))","v":""},{"$f":"IF(F54=0,\"\",INDEX(_db[расход],$F54-$F$2))","v":""},null,null,null,{"$f":"IF($F54=0,\"\",INDEX(_db[дата],$F54-$F$2))","v":""},{"$f":"IF($F54=0,\"\",INDEX(_db[От кого],$F54-$F$2))","v":""}]
[49,{"$f":"IF($F55=0,\"\",INDEX(_db[наименование],$F55-$F$2))","v":""},{"$f":"IF($F55=0,\"\",INDEX(_db[ед изм],$F55-$F$2))","v":""},{"$f":"IF(F55=0,\"\",INDEX(_db[расход],$F55-$F$2))","v":""},null,null,null,{"$f":"IF($F55=0,\"\",INDEX(_db[дата],$F55-$F$2))","v":""},{"$f":"IF($F55=0,\"\",INDEX(_db[От кого],$F55-$F$2))","v":""}]
[50,{"$f":"IF($F56=0,\"\",INDEX(_db[наименование],$F56-$F$2))","v":""},{"$f":"IF($F56=0,\"\",INDEX(_db[ед изм],$F56-$F$2))","v":""},{"$f":"IF(F56=0,\"\",INDEX(_db[расход],$F56-$F$2))","v":""},null,null,null,{"$f":"IF($F56=0,\"\",INDEX(_db[дата],$F56-$F$2))","v":""},{"$f":"IF($F56=0,\"\",INDEX(_db[От кого],$F56-$F$2))","v":""}]
["Сдал",{"$f":"INDEX(_db[От кого],out!F7-F2)","v":"rhhe"},null,null,null,2]
["Принял",{"$f":"VLOOKUP(B2,zav!A1:B34,2)","v":"пупкин"}]

{"sheet":"out","index":4,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,1,4,3]]}
["НАКЛАДНАЯ НА ОТПУСК ТМЦ СО СКЛАДА",null,null,null,null,"служебный столбец и строка, не влезать, не менять ничего",{"$f":"MATCH(\"Наименование\",B1:B18,)+1","v":7},"первый ряд таблицы",{"$f":"MATCH(\"сдал\",A1:A64,)-G1","v":50},"кол-во рядов таблицы"]
["Дата/время",{"$f":"INDEX(_db[дата],out!F7-F2)","v":"2017-11-01"},null,null,null,{"$f":"MATCH(\"дата\",db!C1:C6,)","v":2}]
["От кого","СКЛАД"]
["Кому",{"$f":"INDEX(_db[Кому],out!F7-F2)","v":"врврве"}]
["Основание/\nназначение",{"$f":"INDEX(db!I3:I23,out!F7-F2)","v":"ui7io7"},null,null,null,null,{"$f":"OR(H5<>F57,I5<>F57)","v":false},{"$f":"COUNTIF(H7:H56,B2)","v":2},{"$f":"COUNTIF(I7:I56,B4)","v":2}]
["ном","Наименование","Ед изм","кол-во"]
[1,{"$f":"IF($F7=0,\"\",INDEX(_db[наименование],$F7-$F$2))","v":"имя3"},{"$f":"IF($F7=0,\"\",INDEX(_db[ед изм],$F7-$F$2))","v":0},{"$f":"IF(F7=0,\"\",INDEX(_db[расход],$F7-$F$2))","v":3},null,{"$f":"in!F7","v":6},null,{"$f":"IF($F7=0,\"\",INDEX(_db[дата],$F7-$F$2))","v":"2017-11-01"},{"$f":"IF($F7=0,\"\",INDEX(_db[Кому],$F7-$F$2))","v":"врврве"}]
[2,{"$f":"IF($F8=0,\"\",INDEX(_db[наименование],$F8-$F$2))","v":"имя6"},{"$f":"IF($F8=0,\"\",INDEX(_db[ед изм],$F8-$F$2))","v":0},{"$f":"IF(F8=0,\"\",INDEX(_db[расход],$F8-$F$2))","v":3},null,{"$f":"in!F8","v":8},null,{"$f":"IF($F8=0,\"\",INDEX(_db[дата],$F8-$F$2))","v":"2017-11-01"},{"$f":"IF($F8=0,\"\",INDEX(_db[Кому],$F8-$F$2))","v":"врврве"}]
[3,{"$f":"IF($F9=0,\"\",INDEX(_db[наименование],$F9-$F$2))","v":""},{"$f":"IF($F9=0,\"\",INDEX(_db[ед изм],$F9-$F$2))","v":""},{"$f":"IF(F9=0,\"\",INDEX(_db[расход],$F9-$F$2))","v":""},null,{"$f":"in!F9","v":0},null,{"$f":"IF($F9=0,\"\",INDEX(_db[дата],$F9-$F$2))","v":""},{"$f":"IF($F9=0,\"\",INDEX(_db[Кому],$F9-$F$2))","v":""}]
[4,{"$f":"IF($F10=0,\"\",INDEX(_db[наименование],$F10-$F$2))","v":""},{"$f":"IF($F10=0,\"\",INDEX(_db[ед изм],$F10-$F$2))","v":""},{"$f":"IF(F10=0,\"\",INDEX(_db[расход],$F10-$F$2))","v":""},null,{"$f":"in!F10","v":0},null,{"$f":"IF($F10=0,\"\",INDEX(_db[дата],$F10-$F$2))","v":""},{"$f":"IF($F10=0,\"\",INDEX(_db[Кому],$F10-$F$2))","v":""}]
[5,{"$f":"IF($F11=0,\"\",INDEX(_db[наименование],$F11-$F$2))","v":""},{"$f":"IF($F11=0,\"\",INDEX(_db[ед изм],$F11-$F$2))","v":""},{"$f":"IF(F11=0,\"\",INDEX(_db[расход],$F11-$F$2))","v":""},null,{"$f":"in!F11","v":0},null,{"$f":"IF($F11=0,\"\",INDEX(_db[дата],$F11-$F$2))","v":""},{"$f":"IF($F11=0,\"\",INDEX(_db[Кому],$F11-$F$2))","v":""}]
[6,{"$f":"IF($F12=0,\"\",INDEX(_db[наименование],$F12-$F$2))","v":""},{"$f":"IF($F12=0,\"\",INDEX(_db[ед изм],$F12-$F$2))","v":""},{"$f":"IF(F12=0,\"\",INDEX(_db[расход],$F12-$F$2))","v":""},null,{"$f":"in!F12","v":0},null,{"$f":"IF($F12=0,\"\",INDEX(_db[дата],$F12-$F$2))","v":""},{"$f":"IF($F12=0,\"\",INDEX(_db[Кому],$F12-$F$2))","v":""}]
[7,{"$f":"IF($F13=0,\"\",INDEX(_db[наименование],$F13-$F$2))","v":""},{"$f":"IF($F13=0,\"\",INDEX(_db[ед изм],$F13-$F$2))","v":""},{"$f":"IF(F13=0,\"\",INDEX(_db[расход],$F13-$F$2))","v":""},null,{"$f":"in!F13","v":0},null,{"$f":"IF($F13=0,\"\",INDEX(_db[дата],$F13-$F$2))","v":""},{"$f":"IF($F13=0,\"\",INDEX(_db[Кому],$F13-$F$2))","v":""}]
[8,{"$f":"IF($F14=0,\"\",INDEX(_db[наименование],$F14-$F$2))","v":""},{"$f":"IF($F14=0,\"\",INDEX(_db[ед изм],$F14-$F$2))","v":""},{"$f":"IF(F14=0,\"\",INDEX(_db[расход],$F14-$F$2))","v":""},null,{"$f":"in!F14","v":0},null,{"$f":"IF($F14=0,\"\",INDEX(_db[дата],$F14-$F$2))","v":""},{"$f":"IF($F14=0,\"\",INDEX(_db[Кому],$F14-$F$2))","v":""}]
[9,{"$f":"IF($F15=0,\"\",INDEX(_db[наименование],$F15-$F$2))","v":""},{"$f":"IF($F15=0,\"\",INDEX(_db[ед изм],$F15-$F$2))","v":""},{"$f":"IF(F15=0,\"\",INDEX(_db[расход],$F15-$F$2))","v":""},null,{"$f":"in!F15","v":0},null,{"$f":"IF($F15=0,\"\",INDEX(_db[дата],$F15-$F$2))","v":""},{"$f":"IF($F15=0,\"\",INDEX(_db[Кому],$F15-$F$2))","v":""}]
[10,{"$f":"IF($F16=0,\"\",INDEX(_db[наименование],$F16-$F$2))","v":""},{"$f":"IF($F16=0,\"\",INDEX(_db[ед изм],$F16-$F$2))","v":""},{"$f":"IF(F16=0,\"\",INDEX(_db[расход],$F16-$F$2))","v":""},null,{"$f":"in!F16","v":0},null,{"$f":"IF($F16=0,\"\",INDEX(_db[дата],$F16-$F$2))","v":""},{"$f":"IF($F16=0,\"\",INDEX(_db[Кому],$F16-$F$2))","v":""}]
[11,{"$f":"IF($F17=0,\"\",INDEX(_db[наименование],$F17-$F$2))","v":""},{"$f":"IF($F17=0,\"\",INDEX(_db[ед изм],$F17-$F$2))","v":""},{"$f":"IF(F17=0,\"\",INDEX(_db[расход],$F17-$F$2))","v":""},null,{"$f":"in!F17","v":0},null,{"$f":"IF($F17=0,\"\",INDEX(_db[дата],$F17-$F$2))","v":""},{"$f":"IF($F17=0,\"\",INDEX(_db[Кому],$F17-$F$2))","v":""}]
[12,{"$f":"IF($F18=0,\"\",INDEX(_db[наименование],$F18-$F$2))","v":""},{"$f":"IF($F18=0,\"\",INDEX(_db[ед изм],$F18-$F$2))","v":""},{"$f":"IF(F18=0,\"\",INDEX(_db[расход],$F18-$F$2))","v":""},null,{"$f":"in!F18","v":0},null,{"$f":"IF($F18=0,\"\",INDEX(_db[дата],$F18-$F$2))","v":""},{"$f":"IF($F18=0,\"\",INDEX(_db[Кому],$F18-$F$2))","v":""}]
[13,{"$f":"IF($F19=0,\"\",INDEX(_db[наименование],$F19-$F$2))","v":""},{"$f":"IF($F19=0,\"\",INDEX(_db[ед изм],$F19-$F$2))","v":""},{"$f":"IF(F19=0,\"\",INDEX(_db[расход],$F19-$F$2))","v":""},null,{"$f":"in!F19","v":0},null,{"$f":"IF($F19=0,\"\",INDEX(_db[дата],$F19-$F$2))","v":""},{"$f":"IF($F19=0,\"\",INDEX(_db[Кому],$F19-$F$2))","v":""}]
[14,{"$f":"IF($F20=0,\"\",INDEX(_db[наименование],$F20-$F$2))","v":""},{"$f":"IF($F20=0,\"\",INDEX(_db[ед изм],$F20-$F$2))","v":""},{"$f":"IF(F20=0,\"\",INDEX(_db[расход],$F20-$F$2))","v":""},null,{"$f":"in!F20","v":0},null,{"$f":"IF($F20=0,\"\",INDEX(_db[дата],$F20-$F$2))","v":""},{"$f":"IF($F20=0,\"\",INDEX(_db[Кому],$F20-$F$2))","v":""}]
[15,{"$f":"IF($F21=0,\"\",INDEX(_db[наименование],$F21-$F$2))","v":""},{"$f":"IF($F21=0,\"\",INDEX(_db[ед изм],$F21-$F$2))","v":""},{"$f":"IF(F21=0,\"\",INDEX(_db[расход],$F21-$F$2))","v":""},null,{"$f":"in!F21","v":0},null,{"$f":"IF($F21=0,\"\",INDEX(_db[дата],$F21-$F$2))","v":""},{"$f":"IF($F21=0,\"\",INDEX(_db[Кому],$F21-$F$2))","v":""}]
[16,{"$f":"IF($F22=0,\"\",INDEX(_db[наименование],$F22-$F$2))","v":""},{"$f":"IF($F22=0,\"\",INDEX(_db[ед изм],$F22-$F$2))","v":""},{"$f":"IF(F22=0,\"\",INDEX(_db[расход],$F22-$F$2))","v":""},null,{"$f":"in!F22","v":0},null,{"$f":"IF($F22=0,\"\",INDEX(_db[дата],$F22-$F$2))","v":""},{"$f":"IF($F22=0,\"\",INDEX(_db[Кому],$F22-$F$2))","v":""}]
[17,{"$f":"IF($F23=0,\"\",INDEX(_db[наименование],$F23-$F$2))","v":""},{"$f":"IF($F23=0,\"\",INDEX(_db[ед изм],$F23-$F$2))","v":""},{"$f":"IF(F23=0,\"\",INDEX(_db[расход],$F23-$F$2))","v":""},null,{"$f":"in!F23","v":0},null,{"$f":"IF($F23=0,\"\",INDEX(_db[дата],$F23-$F$2))","v":""},{"$f":"IF($F23=0,\"\",INDEX(_db[Кому],$F23-$F$2))","v":""}]
[18,{"$f":"IF($F24=0,\"\",INDEX(_db[наименование],$F24-$F$2))","v":""},{"$f":"IF($F24=0,\"\",INDEX(_db[ед изм],$F24-$F$2))","v":""},{"$f":"IF(F24=0,\"\",INDEX(_db[расход],$F24-$F$2))","v":""},null,{"$f":"in!F24","v":0},null,{"$f":"IF($F24=0,\"\",INDEX(_db[дата],$F24-$F$2))","v":""},{"$f":"IF($F24=0,\"\",INDEX(_db[Кому],$F24-$F$2))","v":""}]
[19,{"$f":"IF($F25=0,\"\",INDEX(_db[наименование],$F25-$F$2))","v":""},{"$f":"IF($F25=0,\"\",INDEX(_db[ед изм],$F25-$F$2))","v":""},{"$f":"IF(F25=0,\"\",INDEX(_db[расход],$F25-$F$2))","v":""},null,{"$f":"in!F25","v":0},null,{"$f":"IF($F25=0,\"\",INDEX(_db[дата],$F25-$F$2))","v":""},{"$f":"IF($F25=0,\"\",INDEX(_db[Кому],$F25-$F$2))","v":""}]
[20,{"$f":"IF($F26=0,\"\",INDEX(_db[наименование],$F26-$F$2))","v":""},{"$f":"IF($F26=0,\"\",INDEX(_db[ед изм],$F26-$F$2))","v":""},{"$f":"IF(F26=0,\"\",INDEX(_db[расход],$F26-$F$2))","v":""},null,{"$f":"in!F26","v":0},null,{"$f":"IF($F26=0,\"\",INDEX(_db[дата],$F26-$F$2))","v":""},{"$f":"IF($F26=0,\"\",INDEX(_db[Кому],$F26-$F$2))","v":""}]
[21,{"$f":"IF($F27=0,\"\",INDEX(_db[наименование],$F27-$F$2))","v":""},{"$f":"IF($F27=0,\"\",INDEX(_db[ед изм],$F27-$F$2))","v":""},{"$f":"IF(F27=0,\"\",INDEX(_db[расход],$F27-$F$2))","v":""},null,{"$f":"in!F27","v":0},null,{"$f":"IF($F27=0,\"\",INDEX(_db[дата],$F27-$F$2))","v":""},{"$f":"IF($F27=0,\"\",INDEX(_db[Кому],$F27-$F$2))","v":""}]
[22,{"$f":"IF($F28=0,\"\",INDEX(_db[наименование],$F28-$F$2))","v":""},{"$f":"IF($F28=0,\"\",INDEX(_db[ед изм],$F28-$F$2))","v":""},{"$f":"IF(F28=0,\"\",INDEX(_db[расход],$F28-$F$2))","v":""},null,{"$f":"in!F28","v":0},null,{"$f":"IF($F28=0,\"\",INDEX(_db[дата],$F28-$F$2))","v":""},{"$f":"IF($F28=0,\"\",INDEX(_db[Кому],$F28-$F$2))","v":""}]
[23,{"$f":"IF($F29=0,\"\",INDEX(_db[наименование],$F29-$F$2))","v":""},{"$f":"IF($F29=0,\"\",INDEX(_db[ед изм],$F29-$F$2))","v":""},{"$f":"IF(F29=0,\"\",INDEX(_db[расход],$F29-$F$2))","v":""},null,{"$f":"in!F29","v":0},null,{"$f":"IF($F29=0,\"\",INDEX(_db[дата],$F29-$F$2))","v":""},{"$f":"IF($F29=0,\"\",INDEX(_db[Кому],$F29-$F$2))","v":""}]
[24,{"$f":"IF($F30=0,\"\",INDEX(_db[наименование],$F30-$F$2))","v":""},{"$f":"IF($F30=0,\"\",INDEX(_db[ед изм],$F30-$F$2))","v":""},{"$f":"IF(F30=0,\"\",INDEX(_db[расход],$F30-$F$2))","v":""},null,{"$f":"in!F30","v":0},null,{"$f":"IF($F30=0,\"\",INDEX(_db[дата],$F30-$F$2))","v":""},{"$f":"IF($F30=0,\"\",INDEX(_db[Кому],$F30-$F$2))","v":""}]
[25,{"$f":"IF($F31=0,\"\",INDEX(_db[наименование],$F31-$F$2))","v":""},{"$f":"IF($F31=0,\"\",INDEX(_db[ед изм],$F31-$F$2))","v":""},{"$f":"IF(F31=0,\"\",INDEX(_db[расход],$F31-$F$2))","v":""},null,{"$f":"in!F31","v":0},null,{"$f":"IF($F31=0,\"\",INDEX(_db[дата],$F31-$F$2))","v":""},{"$f":"IF($F31=0,\"\",INDEX(_db[Кому],$F31-$F$2))","v":""}]
[26,{"$f":"IF($F32=0,\"\",INDEX(_db[наименование],$F32-$F$2))","v":""},{"$f":"IF($F32=0,\"\",INDEX(_db[ед изм],$F32-$F$2))","v":""},{"$f":"IF(F32=0,\"\",INDEX(_db[расход],$F32-$F$2))","v":""},null,{"$f":"in!F32","v":0},null,{"$f":"IF($F32=0,\"\",INDEX(_db[дата],$F32-$F$2))","v":""},{"$f":"IF($F32=0,\"\",INDEX(_db[Кому],$F32-$F$2))","v":""}]
[27,{"$f":"IF($F33=0,\"\",INDEX(_db[наименование],$F33-$F$2))","v":""},{"$f":"IF($F33=0,\"\",INDEX(_db[ед изм],$F33-$F$2))","v":""},{"$f":"IF(F33=0,\"\",INDEX(_db[расход],$F33-$F$2))","v":""},null,{"$f":"in!F33","v":0},null,{"$f":"IF($F33=0,\"\",INDEX(_db[дата],$F33-$F$2))","v":""},{"$f":"IF($F33=0,\"\",INDEX(_db[Кому],$F33-$F$2))","v":""}]
[28,{"$f":"IF($F34=0,\"\",INDEX(_db[наименование],$F34-$F$2))","v":""},{"$f":"IF($F34=0,\"\",INDEX(_db[ед изм],$F34-$F$2))","v":""},{"$f":"IF(F34=0,\"\",INDEX(_db[расход],$F34-$F$2))","v":""},null,{"$f":"in!F34","v":0},null,{"$f":"IF($F34=0,\"\",INDEX(_db[дата],$F34-$F$2))","v":""},{"$f":"IF($F34=0,\"\",INDEX(_db[Кому],$F34-$F$2))","v":""}]
[29,{"$f":"IF($F35=0,\"\",INDEX(_db[наименование],$F35-$F$2))","v":""},{"$f":"IF($F35=0,\"\",INDEX(_db[ед изм],$F35-$F$2))","v":""},{"$f":"IF(F35=0,\"\",INDEX(_db[расход],$F35-$F$2))","v":""},null,{"$f":"in!F35","v":0},null,{"$f":"IF($F35=0,\"\",INDEX(_db[дата],$F35-$F$2))","v":""},{"$f":"IF($F35=0,\"\",INDEX(_db[Кому],$F35-$F$2))","v":""}]
[30,{"$f":"IF($F36=0,\"\",INDEX(_db[наименование],$F36-$F$2))","v":""},{"$f":"IF($F36=0,\"\",INDEX(_db[ед изм],$F36-$F$2))","v":""},{"$f":"IF(F36=0,\"\",INDEX(_db[расход],$F36-$F$2))","v":""},null,{"$f":"in!F36","v":0},null,{"$f":"IF($F36=0,\"\",INDEX(_db[дата],$F36-$F$2))","v":""},{"$f":"IF($F36=0,\"\",INDEX(_db[Кому],$F36-$F$2))","v":""}]
[31,{"$f":"IF($F37=0,\"\",INDEX(_db[наименование],$F37-$F$2))","v":""},{"$f":"IF($F37=0,\"\",INDEX(_db[ед изм],$F37-$F$2))","v":""},{"$f":"IF(F37=0,\"\",INDEX(_db[расход],$F37-$F$2))","v":""},null,{"$f":"in!F37","v":0},null,{"$f":"IF($F37=0,\"\",INDEX(_db[дата],$F37-$F$2))","v":""},{"$f":"IF($F37=0,\"\",INDEX(_db[Кому],$F37-$F$2))","v":""}]
[32,{"$f":"IF($F38=0,\"\",INDEX(_db[наименование],$F38-$F$2))","v":""},{"$f":"IF($F38=0,\"\",INDEX(_db[ед изм],$F38-$F$2))","v":""},{"$f":"IF(F38=0,\"\",INDEX(_db[расход],$F38-$F$2))","v":""},null,{"$f":"in!F38","v":0},null,{"$f":"IF($F38=0,\"\",INDEX(_db[дата],$F38-$F$2))","v":""},{"$f":"IF($F38=0,\"\",INDEX(_db[Кому],$F38-$F$2))","v":""}]
[33,{"$f":"IF($F39=0,\"\",INDEX(_db[наименование],$F39-$F$2))","v":""},{"$f":"IF($F39=0,\"\",INDEX(_db[ед изм],$F39-$F$2))","v":""},{"$f":"IF(F39=0,\"\",INDEX(_db[расход],$F39-$F$2))","v":""},null,{"$f":"in!F39","v":0},null,{"$f":"IF($F39=0,\"\",INDEX(_db[дата],$F39-$F$2))","v":""},{"$f":"IF($F39=0,\"\",INDEX(_db[Кому],$F39-$F$2))","v":""}]
[34,{"$f":"IF($F40=0,\"\",INDEX(_db[наименование],$F40-$F$2))","v":""},{"$f":"IF($F40=0,\"\",INDEX(_db[ед изм],$F40-$F$2))","v":""},{"$f":"IF(F40=0,\"\",INDEX(_db[расход],$F40-$F$2))","v":""},null,{"$f":"in!F40","v":0},null,{"$f":"IF($F40=0,\"\",INDEX(_db[дата],$F40-$F$2))","v":""},{"$f":"IF($F40=0,\"\",INDEX(_db[Кому],$F40-$F$2))","v":""}]
[35,{"$f":"IF($F41=0,\"\",INDEX(_db[наименование],$F41-$F$2))","v":""},{"$f":"IF($F41=0,\"\",INDEX(_db[ед изм],$F41-$F$2))","v":""},{"$f":"IF(F41=0,\"\",INDEX(_db[расход],$F41-$F$2))","v":""},null,{"$f":"in!F41","v":0},null,{"$f":"IF($F41=0,\"\",INDEX(_db[дата],$F41-$F$2))","v":""},{"$f":"IF($F41=0,\"\",INDEX(_db[Кому],$F41-$F$2))","v":""}]
[36,{"$f":"IF($F42=0,\"\",INDEX(_db[наименование],$F42-$F$2))","v":""},{"$f":"IF($F42=0,\"\",INDEX(_db[ед изм],$F42-$F$2))","v":""},{"$f":"IF(F42=0,\"\",INDEX(_db[расход],$F42-$F$2))","v":""},null,{"$f":"in!F42","v":0},null,{"$f":"IF($F42=0,\"\",INDEX(_db[дата],$F42-$F$2))","v":""},{"$f":"IF($F42=0,\"\",INDEX(_db[Кому],$F42-$F$2))","v":""}]
[37,{"$f":"IF($F43=0,\"\",INDEX(_db[наименование],$F43-$F$2))","v":""},{"$f":"IF($F43=0,\"\",INDEX(_db[ед изм],$F43-$F$2))","v":""},{"$f":"IF(F43=0,\"\",INDEX(_db[расход],$F43-$F$2))","v":""},null,{"$f":"in!F43","v":0},null,{"$f":"IF($F43=0,\"\",INDEX(_db[дата],$F43-$F$2))","v":""},{"$f":"IF($F43=0,\"\",INDEX(_db[Кому],$F43-$F$2))","v":""}]
[38,{"$f":"IF($F44=0,\"\",INDEX(_db[наименование],$F44-$F$2))","v":""},{"$f":"IF($F44=0,\"\",INDEX(_db[ед изм],$F44-$F$2))","v":""},{"$f":"IF(F44=0,\"\",INDEX(_db[расход],$F44-$F$2))","v":""},null,{"$f":"in!F44","v":0},null,{"$f":"IF($F44=0,\"\",INDEX(_db[дата],$F44-$F$2))","v":""},{"$f":"IF($F44=0,\"\",INDEX(_db[Кому],$F44-$F$2))","v":""}]
[39,{"$f":"IF($F45=0,\"\",INDEX(_db[наименование],$F45-$F$2))","v":""},{"$f":"IF($F45=0,\"\",INDEX(_db[ед изм],$F45-$F$2))","v":""},{"$f":"IF(F45=0,\"\",INDEX(_db[расход],$F45-$F$2))","v":""},null,{"$f":"in!F45","v":0},null,{"$f":"IF($F45=0,\"\",INDEX(_db[дата],$F45-$F$2))","v":""},{"$f":"IF($F45=0,\"\",INDEX(_db[Кому],$F45-$F$2))","v":""}]
[40,{"$f":"IF($F46=0,\"\",INDEX(_db[наименование],$F46-$F$2))","v":""},{"$f":"IF($F46=0,\"\",INDEX(_db[ед изм],$F46-$F$2))","v":""},{"$f":"IF(F46=0,\"\",INDEX(_db[расход],$F46-$F$2))","v":""},null,{"$f":"in!F46","v":0},null,{"$f":"IF($F46=0,\"\",INDEX(_db[дата],$F46-$F$2))","v":""},{"$f":"IF($F46=0,\"\",INDEX(_db[Кому],$F46-$F$2))","v":""}]
[41,{"$f":"IF($F47=0,\"\",INDEX(_db[наименование],$F47-$F$2))","v":""},{"$f":"IF($F47=0,\"\",INDEX(_db[ед изм],$F47-$F$2))","v":""},{"$f":"IF(F47=0,\"\",INDEX(_db[расход],$F47-$F$2))","v":""},null,{"$f":"in!F47","v":0},null,{"$f":"IF($F47=0,\"\",INDEX(_db[дата],$F47-$F$2))","v":""},{"$f":"IF($F47=0,\"\",INDEX(_db[Кому],$F47-$F$2))","v":""}]
[42,{"$f":"IF($F48=0,\"\",INDEX(_db[наименование],$F48-$F$2))","v":""},{"$f":"IF($F48=0,\"\",INDEX(_db[ед изм],$F48-$F$2))","v":""},{"$f":"IF(F48=0,\"\",INDEX(_db[расход],$F48-$F$2))","v":""},null,{"$f":"in!F48","v":0},null,{"$f":"IF($F48=0,\"\",INDEX(_db[дата],$F48-$F$2))","v":""},{"$f":"IF($F48=0,\"\",INDEX(_db[Кому],$F48-$F$2))","v":""}]
[43,{"$f":"IF($F49=0,\"\",INDEX(_db[наименование],$F49-$F$2))","v":""},{"$f":"IF($F49=0,\"\",INDEX(_db[ед изм],$F49-$F$2))","v":""},{"$f":"IF(F49=0,\"\",INDEX(_db[расход],$F49-$F$2))","v":""},null,{"$f":"in!F49","v":0},null,{"$f":"IF($F49=0,\"\",INDEX(_db[дата],$F49-$F$2))","v":""},{"$f":"IF($F49=0,\"\",INDEX(_db[Кому],$F49-$F$2))","v":""}]
[44,{"$f":"IF($F50=0,\"\",INDEX(_db[наименование],$F50-$F$2))","v":""},{"$f":"IF($F50=0,\"\",INDEX(_db[ед изм],$F50-$F$2))","v":""},{"$f":"IF(F50=0,\"\",INDEX(_db[расход],$F50-$F$2))","v":""},null,{"$f":"in!F50","v":0},null,{"$f":"IF($F50=0,\"\",INDEX(_db[дата],$F50-$F$2))","v":""},{"$f":"IF($F50=0,\"\",INDEX(_db[Кому],$F50-$F$2))","v":""}]
[45,{"$f":"IF($F51=0,\"\",INDEX(_db[наименование],$F51-$F$2))","v":""},{"$f":"IF($F51=0,\"\",INDEX(_db[ед изм],$F51-$F$2))","v":""},{"$f":"IF(F51=0,\"\",INDEX(_db[расход],$F51-$F$2))","v":""},null,{"$f":"in!F51","v":0},null,{"$f":"IF($F51=0,\"\",INDEX(_db[дата],$F51-$F$2))","v":""},{"$f":"IF($F51=0,\"\",INDEX(_db[Кому],$F51-$F$2))","v":""}]
[46,{"$f":"IF($F52=0,\"\",INDEX(_db[наименование],$F52-$F$2))","v":""},{"$f":"IF($F52=0,\"\",INDEX(_db[ед изм],$F52-$F$2))","v":""},{"$f":"IF(F52=0,\"\",INDEX(_db[расход],$F52-$F$2))","v":""},null,{"$f":"in!F52","v":0},null,{"$f":"IF($F52=0,\"\",INDEX(_db[дата],$F52-$F$2))","v":""},{"$f":"IF($F52=0,\"\",INDEX(_db[Кому],$F52-$F$2))","v":""}]
[47,{"$f":"IF($F53=0,\"\",INDEX(_db[наименование],$F53-$F$2))","v":""},{"$f":"IF($F53=0,\"\",INDEX(_db[ед изм],$F53-$F$2))","v":""},{"$f":"IF(F53=0,\"\",INDEX(_db[расход],$F53-$F$2))","v":""},null,{"$f":"in!F53","v":0},null,{"$f":"IF($F53=0,\"\",INDEX(_db[дата],$F53-$F$2))","v":""},{"$f":"IF($F53=0,\"\",INDEX(_db[Кому],$F53-$F$2))","v":""}]
[48,{"$f":"IF($F54=0,\"\",INDEX(_db[наименование],$F54-$F$2))","v":""},{"$f":"IF($F54=0,\"\",INDEX(_db[ед изм],$F54-$F$2))","v":""},{"$f":"IF(F54=0,\"\",INDEX(_db[расход],$F54-$F$2))","v":""},null,{"$f":"in!F54","v":0},null,{"$f":"IF($F54=0,\"\",INDEX(_db[дата],$F54-$F$2))","v":""},{"$f":"IF($F54=0,\"\",INDEX(_db[Кому],$F54-$F$2))","v":""}]
[49,{"$f":"IF($F55=0,\"\",INDEX(_db[наименование],$F55-$F$2))","v":""},{"$f":"IF($F55=0,\"\",INDEX(_db[ед изм],$F55-$F$2))","v":""},{"$f":"IF(F55=0,\"\",INDEX(_db[расход],$F55-$F$2))","v":""},null,{"$f":"in!F55","v":0},null,{"$f":"IF($F55=0,\"\",INDEX(_db[дата],$F55-$F$2))","v":""},{"$f":"IF($F55=0,\"\",INDEX(_db[Кому],$F55-$F$2))","v":""}]
[50,{"$f":"IF($F56=0,\"\",INDEX(_db[наименование],$F56-$F$2))","v":""},{"$f":"IF($F56=0,\"\",INDEX(_db[ед изм],$F56-$F$2))","v":""},{"$f":"IF(F56=0,\"\",INDEX(_db[расход],$F56-$F$2))","v":""},null,{"$f":"in!F56","v":0},null,{"$f":"IF($F56=0,\"\",INDEX(_db[дата],$F56-$F$2))","v":""},{"$f":"IF($F56=0,\"\",INDEX(_db[Кому],$F56-$F$2))","v":""}]
["Сдал",{"$f":"VLOOKUP(B2,zav!A1:B34,2)","v":"пупкин"},null,null,null,{"$f":"in!F57","v":2}]
["Принял",{"$f":"B4","v":"врврве"}]

{"sheet":"tot","index":5,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"db!A1","v":"2019-05-05"},null,null,"начало периода",null,{"$f":"IF(E1=0,DATE(YEAR(A1),MONTH(A1),1),E1)","v":"2019-05-01"}]
[null,null,null,"окончание периода",null,{"$f":"IF(E2=0,DATE(YEAR(A1),1+MONTH(A1),),E2)","v":"2019-05-31"}]
[null,null,null,{"$f":"_xlfn.AGGREGATE(9,5,_tot[Кол-во на начало])","v":34},{"$f":"_xlfn.AGGREGATE(9,5,_tot[Кол-во на окончание])","v":34},{"$f":"_xlfn.AGGREGATE(9,5,_tot[Сумма на начало])","v":374},{"$f":"_xlfn.AGGREGATE(9,5,_tot[Сумма на окончание])","v":374},null,null,{"$f":"_xlfn.AGGREGATE(9,5,_tot[Кол-во приход])","v":0},{"$f":"_xlfn.AGGREGATE(9,5,_tot[Кол-во расход])","v":0},{"$f":"_xlfn.AGGREGATE(9,5,_tot[Кол-во оборот])","v":0},{"$f":"_xlfn.AGGREGATE(9,5,_tot[сумма приход])","v":0},{"$f":"_xlfn.AGGREGATE(9,5,_tot[сумма расход])","v":0},{"$f":"_xlfn.AGGREGATE(9,5,_tot[сумма оборот])","v":0}]
["NN","Категория","Нaименование","Кол-во на начало","Кол-во на окончание","Сумма на начало","Сумма на окончание","Столбец1","цена на окончание","Кол-во приход","Кол-во расход","Кол-во оборот","сумма приход","сумма расход","сумма оборот","Примечание"]
[{"$f":"ROW()-ROW($A$4)","v":1},null,"имя1",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":5},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":5},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":55},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":55},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[{"$f":"ROW()-ROW($A$4)","v":2},null,"имя2",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":2},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":2},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":22},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":22},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[3,null,"имя3",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":0},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":0},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[4,null,"имя4",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":4},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":4},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":44},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":44},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[5,null,"имя5",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":3},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":3},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":33},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":33},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[6,null,"имя6",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":1},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":1},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":11},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":11},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[7,null,"имя7",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":3},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":3},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":33},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":33},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[8,null,"имя8",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":8},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":8},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":88},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":88},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]
[{"$f":"ROW()-ROW($A$4)","v":9},null,"имя9",{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$1)","v":8},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)-SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\"<\"&$F$2)","v":8},{"$f":"_tot[[#This Row],[Кол-во на начало]]*_tot[[#This Row],[цена на окончание]]","v":88},{"$f":"_tot[[#This Row],[Кол-во на окончание]]*_tot[[#This Row],[цена на окончание]]","v":88},null,{"$f":"LOOKUP($F$2,_db[дата]/(_db[наименование]=_tot[[#This Row],[Нaименование]])/(_db[приход]>0),_db[цена с НДС])","v":11},{"$f":"SUMIFS(_db[приход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"SUMIFS(_db[расход],_db[наименование],_tot[[#This Row],[Нaименование]],_db[дата],\">=\"&$F$1,_db[дата],\"<=\"&$F$2)","v":0},{"$f":"_tot[[#This Row],[Кол-во на начало]]+_tot[[#This Row],[Кол-во приход]]-_tot[[#This Row],[Кол-во на окончание]]","v":0},{"$f":"_tot[[#This Row],[цена на окончание]]*_tot[[#This Row],[Кол-во приход]]","v":0},{"$f":"_tot[[#This Row],[Кол-во расход]]*_tot[[#This Row],[цена на окончание]]","v":0},{"$f":"_tot[[#This Row],[Кол-во оборот]]*_tot[[#This Row],[цена на окончание]]","v":0}]

{"sheet":"zav","index":6,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["2017-01-01","пупкин"]

{"sheet":"!!!","index":7,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"ROW()","v":1},"для формирования накладных выделить нужные строки на листе db целиком (кликать в области номера строки листа) (если не подряд, то с нажатым Ctrl)"]
[{"$f":"ROW()","v":2},"если даты, фио в каких либо выделенных строках не равны самой верхней выделенной, то область таблицы накладных заливается цветом"]
[{"$f":"ROW()","v":3},"отправлять каждый месяц строки переданных прорабам ТМЦ для подготовки ими служебок на их списание"]
[{"$f":"ROW()","v":4},"сиотрите примечания к ячейкам"]
[{"$f":"ROW()","v":5},"для работы файла макросы д/б разрешены"]
[{"$f":"ROW()","v":6}]
[{"$f":"ROW()","v":7}]
[{"$f":"ROW()","v":8}]
[{"$f":"ROW()","v":9}]
[{"$f":"ROW()","v":10}]
[{"$f":"ROW()","v":11}]
[{"$f":"ROW()","v":12}]
[{"$f":"ROW()","v":13}]