{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Данные","1","2","3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["РАХУНОК ","Маршрут","Дата","Ціна, грн."]
["ПР-001","м. Суми - м. Суми","2014-02-04",250,null,null,null,null,"ПР-001"]
["ПР-002","м. Суми - м. Суми","2014-02-11",111,null,null,null,null,"ПР-002"]
["ПР-003","м. Суми - м. Суми","2014-03-21",333,null,null,null,null,"ПР-003"]
["ПР-003","м. Суми - м. Суми","2014-03-22",555]
["ПР-003","ппппп","2014-03-21",444]
["ПР-002","ууууу","2014-02-11",222]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(D:D)","v":1915}]

{"sheet":"1","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[45,0,45,2],[45,7,45,10],[46,0,46,2],[46,7,46,10],[48,6,48,10],[43,0,43,10],[34,1,34,8],[34,9,34,10],[35,1,35,8],[35,9,35,10],[36,1,36,8],[36,9,36,10],[37,9,37,10],[39,1,39,8],[39,9,39,10],[40,1,40,8],[40,9,40,10],[29,1,29,5],[29,6,29,10],[10,1,10,4],[10,7,10,8],[10,9,10,10],[11,7,11,8],[11,9,11,10],[12,1,12,4],[12,7,12,8],[12,9,12,10],[13,1,13,6],[13,7,13,8],[13,9,13,10],[19,0,19,10],[20,9,20,10],[9,1,9,4],[9,7,9,8],[9,9,9,10],[1,2,1,4],[2,2,2,4],[8,1,8,4],[8,7,8,8],[8,9,8,10]]}
[null,null,null,"РАХУНОК ",{"$f":"Данные!A2","v":"ПР-001"}]
[null,null,{"$f":"Данные!C2","v":"2014-02-04"}]
[null,null,"дата виписки"]
["Постачальник: "]
[]
[]
[]
["Платник за рахунком:  "]
["№ з/п ","Назва",null,null,null,"Од.","К-ть","Ціна, грн.",null,"Сума, грн."]
[1,"Автопослуги за маршрутом:"]
[null,{"$f":"Данные!B2","v":"м. Суми - м. Суми"},null,null,null,"послуга",1,{"$f":"Данные!D2","v":250},null,{"$f":"H11","v":250}]
[]
[]
[null,"Всього",null,null,null,null,null,{"$f":"H11+H12","v":250},null,{"$f":"H14","v":250}]
["РАЗОМ: "]

{"sheet":"2","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[45,0,45,2],[45,7,45,10],[46,0,46,2],[46,7,46,10],[48,6,48,10],[43,0,43,10],[34,1,34,8],[34,9,34,10],[35,1,35,8],[35,9,35,10],[36,1,36,8],[36,9,36,10],[37,9,37,10],[39,1,39,8],[39,9,39,10],[40,1,40,8],[40,9,40,10],[29,1,29,5],[29,6,29,10],[10,1,10,4],[10,7,10,8],[10,9,10,10],[11,7,11,8],[11,9,11,10],[12,1,12,4],[12,7,12,8],[12,9,12,10],[13,1,13,6],[13,7,13,8],[13,9,13,10],[19,0,19,10],[20,9,20,10],[9,1,9,4],[9,7,9,8],[9,9,9,10],[1,2,1,4],[2,2,2,4],[8,1,8,4],[8,7,8,8],[8,9,8,10]]}
[null,null,null,"РАХУНОК ",{"$f":"Данные!A3","v":"ПР-002"}]
[null,null,{"$f":"Данные!C3","v":"2014-02-11"}]
[null,null,"дата виписки"]
["Постачальник: "]
[]
[]
[]
["Платник за рахунком:  "]
["№ з/п ","Назва",null,null,null,"Од.","К-ть","Ціна, грн.",null,"Сума, грн."]
[1,"Автопослуги за маршрутом:"]
[null,{"$f":"Данные!B3","v":"м. Суми - м. Суми"},null,null,null,"послуга",1,{"$f":"Данные!D3","v":111},null,{"$f":"H11","v":111}]
[]
[]
[null,"Всього",null,null,null,null,null,{"$f":"H11+H12","v":111},null,{"$f":"H14","v":111}]
["РАЗОМ: "]

{"sheet":"3","index":3,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[45,0,45,2],[45,7,45,10],[46,0,46,2],[46,7,46,10],[48,6,48,10],[43,0,43,10],[34,1,34,8],[34,9,34,10],[35,1,35,8],[35,9,35,10],[36,1,36,8],[36,9,36,10],[37,9,37,10],[39,1,39,8],[39,9,39,10],[40,1,40,8],[40,9,40,10],[29,1,29,5],[29,6,29,10],[10,9,10,10],[11,9,11,10],[12,1,12,4],[12,7,12,8],[12,9,12,10],[13,1,13,6],[13,7,13,8],[13,9,13,10],[19,0,19,10],[20,9,20,10],[9,1,9,4],[9,7,9,8],[9,9,9,10],[1,2,1,4],[2,2,2,4],[8,1,8,4],[8,7,8,8],[8,9,8,10]]}
[null,null,null,"РАХУНОК ","ПР-002","вып. список"]
[null,null,"2014-02-11",null,null,"дату вводим вручную (если делать списком, то он может быть большой - не очень удобно будет)"]
[null,null,"дата виписки"]
["Постачальник: "]
[]
[]
[]
["Платник за рахунком:  "]
["№ з/п ","Назва",null,null,null,"Од.","К-ть","Ціна, грн.",null,"Сума, грн."]
[1,"Автопослуги за маршрутом:"]
[null,{"$f":"IFERROR(INDEX(INDEX(табл,,2),SMALL(IF((INDEX(табл,,1)=$E$1)*(INDEX(табл,,3)=$C$2),ROW(табл)-1),ROW(A1))),\"\")","v":"м. Суми - м. Суми"},null,null,null,"послуга",1,{"$f":"IFERROR(INDEX(INDEX(табл,,4),SMALL(IF((INDEX(табл,,1)=$E$1)*(INDEX(табл,,3)=$C$2),ROW(табл)-1),ROW(A1))),\"\")","v":111},null,{"$f":"H11","v":111}]
[null,{"$f":"IFERROR(INDEX(INDEX(табл,,2),SMALL(IF((INDEX(табл,,1)=$E$1)*(INDEX(табл,,3)=$C$2),ROW(табл)-1),ROW(A2))),\"\")","v":"ууууу"},null,null,null,"послуга",1,{"$f":"IFERROR(INDEX(INDEX(табл,,4),SMALL(IF((INDEX(табл,,1)=$E$1)*(INDEX(табл,,3)=$C$2),ROW(табл)-1),ROW(A2))),\"\")","v":222},null,{"$f":"H12","v":222}]
[]
[null,"Всього",null,null,null,null,null,{"$f":"SUM(H11:H12)","v":333},null,{"$f":"H14","v":333}]
["РАЗОМ: "]