{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["журнал ","накладная"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":6,"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":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Оплата","Дата","поставщик","получатель","станция","№ накл","артикул","кол-во",null,null,null,"Цена без НДС","Сумма с НДС"]
[null,"2013-01-19","ТБ","киев","ст13",1,7878,1659,null,null,null,115.95,{"$f":"L2*H2*1.2","v":230833.26}]
[null,"2013-01-25","ТБ","львов","ст15",2,7878,485,null,null,null,115.95,{"$f":"L3*H3*1.2","v":67482.899999999994}]
[null,"2013-01-25","ТД","киев","ст13",3,7878,823.2,null,null,null,115.95,{"$f":"L4*H4*1.2","v":114540.04800000001}]
[null,"2013-01-25","ТД","киев","ст13",3,7878,820.3,null,null,null,115.95,114136.542]
[null,"2013-01-31","ТБ","львов","ст15",4,7878,484,null,null,null,115.95,67343.759999999995]
[null,"2013-01-31","ТД","киев","ст13",5,7878,546.20000000000005,null,null,null,115.95,75998.268000000011]
[null,"2013-01-31","ТД","львов","ст15",6,7878,477.1,null,null,null,115.95,66383.694000000003]
[null,"2013-02-01","УС","киев","ст13",7,7878,555.79999999999995,null,null,null,115.95,77334.011999999988]
[null,"2013-02-01","УС","львов","ст15",8,7878,345.3,null,null,null,115.95,48045.042000000001]
[null,"2013-02-04","УС","львов","ст15",9,7878,139.69999999999999,null,null,null,115.95,19437.857999999997]
[null,"2013-02-08","ТБ","львов","ст15",10,7878,485,null,null,null,115.95,67482.899999999994]
[null,"2013-02-09","ТБ","киев","ст13",11,7878,552,null,null,null,115.95,76805.279999999999]
[null,"2013-02-11","ТБ","львов","ст15",12,7878,486,null,null,null,115.95,67622.040000000008]
[null,"2013-02-15","ТБ","киев","ст13",13,7878,556,null,null,null,115.95,77361.84]
[null,"2013-02-15","ГС","львов","ст15",14,7878,276,null,null,null,115.95,38402.639999999999]
[null,"2013-02-16","ТБ","киев","ст13",15,"3232",278,null,null,null,115.95,38680.92]
[null,"2013-02-16","ТБ","львов","ст15",16,7878,485,null,null,null,115.95,67482.899999999994]
[null,"2013-02-18","ГС","львов","ст15",17,7878,415,null,null,null,115.95,57743.1]
[null,"2013-02-18","ГС","львов","ст15",18,7878,277,null,null,null,115.95,38541.78]
[null,"2013-03-05","ТН","днепр","ст12",19,"5656",345,null,null,null,62.5,25875]
[null,"2013-03-07","ТБ","киев","ст13",20,7878,554,null,null,null,115.95,77083.56]
[null,"2013-03-07","ТБ","львов","ст15",21,7878,483,null,null,null,115.95,67204.62]

{"sheet":"накладная","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,1,18,3],[17,1,17,3],[29,0,29,1],[29,2,29,3],[12,0,12,5],[28,0,28,1],[20,1,20,3],[19,1,19,3],[4,0,4,1],[4,2,4,7],[5,0,5,1],[6,0,6,1],[6,2,6,7],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[16,1,16,3],[3,0,3,1],[0,0,0,1],[0,2,0,7],[1,0,1,1],[2,0,2,1],[2,2,2,7]]}
["Поставщик",null,"ПП\"ПП\""]
[null,null,"ххххххххххххххххххххххххххххххх"]
[null,null,"хххххххххххххххххххххххххххххххххххххх"]
[null,null,"хххххххххххххххххххххххххххххххххххххх"]
[null,null,"хххххххххххххххххххххххххххххххххххххх"]
[null,null,"хххххххххххххххххххххххххххххх"]
["Получатель",null,"??????"]
[null,null,"тел."]
["Плательщик",null,"тот же"]
["Заказ",null,"Договор №"]
["Условие "]
[]
["Расходная накладная №",null,null,null,null,null,3]
["от  (дата)????????????"]
[]
["№","Товар",null,null,"Ед","Кол-во","Цена без НДС","Сумма без НДС"]
[1,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A17,2)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A17,2))","v":7878},null,null,null,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A17,3)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A17,3))","v":823.2},{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A17,7)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A17,7))","v":115.95},{"$f":"IFERROR(F17*G17,\"\")","v":95450.040000000008}]
[2,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A18,2)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A18,2))","v":7878},null,null,null,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A18,3)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A18,3))","v":820.3},{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A18,7)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A18,7))","v":115.95},{"$f":"IFERROR(F18*G18,\"\")","v":95113.785000000003}]
[3,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A19,2)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A19,2))","v":""},null,null,null,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A19,3)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A19,3))","v":""},{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A19,7)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A19,7))","v":""},""]
[4,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A20,2)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A20,2))","v":""},null,null,null,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A20,3)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A20,3))","v":""},{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A20,7)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A20,7))","v":""},""]
[5,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A21,2)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A21,2))","v":""},null,null,null,{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A21,3)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A21,3))","v":""},{"$f":"IF(ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A21,7)=0,\"\",ВПР_3('журнал '!$F$1:$M$5000,1,$G$13,$A21,7))","v":""},""]
[null,null,null,null,null,null,"НДС: ",{"$f":"SUM(H17:H21)*0.2","v":38112.765000000007}]
[null,null,null,null,null,null,"Всего с НДС: ",{"$f":"SUM(H17:H21)*1.2","v":228676.59}]
[]
[null,"Всего на сумму:"]
[]
[null,"ПДВ:     ",{"$f":"H22","v":38112.765000000007}]