{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Отгрузка продукции","Лист2","База данных","Отчет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,3,1,3],[0,7,0,8],[0,4,1,4],[0,6,1,6],[0,1,1,1],[0,2,1,2]]}
["№ п/п","Марка","Дата","Остаток на начало периода, тн","Движение",null,"Остаток на конец периода, тн","Движение"]
[null,null,null,null,null,"количество, тн",null,"Тип отгрузки","Заказчик"]
[null,"товар 2","2013-04-18",200,"приход",100,{"$f":"D3+(E3=\"приход\")*F3-(E3=\"расход\")*F3","v":300},"ЖД ","покупатель2"]
[null,"товар 3","2013-04-18",300,"расход",100,{"$f":"D4+(E4=\"приход\")*F4-(E4=\"расход\")*F4","v":200},"ЖД ","покупатель5"]
[]
[]
[null,null,null,null,null,null,null,"автоматом плюсуется к D"]
[null,null,null,null,null,null,"автоматом минусуется из D"]
[]
[null,null,null,null,null,"вставляем количество, тонны"]
[null,null,"автоматически пронумероввывать"]
[]
[]
[null,null,null,"САМОЕ ИНТЕРЕСНОЕ - КАК ЭТО ОРГАНИЗОВАТЬ В ОТЧЕТ, чтобы видить все движение"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,11,"2013-04-17"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"База данных","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["товар 1",null,"приход",null,"ЖД ",null,"покупатель1"]
["товар 2",null,"расход",null,"Самовывоз",null,"покупатель2"]
["товар 3",null,null,null,null,null,"покупатель3"]
["товар 4",null,null,null,null,null,"покупатель4"]
["товар 5",null,null,null,null,null,"покупатель5"]
["товар 6",null,null,null,null,null,"покупатель6"]
["товар 7",null,null,null,null,null,"покупатель7"]
["товар 8",null,null,null,null,null,"покупатель8"]
["товар 9",null,null,null,null,null,"покупатель9"]
["товар 10",null,null,null,null,null,"покупатель10"]
[null,null,null,null,null,null,"покупатель11"]
[null,null,null,null,null,null,"покупатель12"]
[null,null,null,null,null,null,"покупатель13"]
[null,null,null,null,null,null,"покупатель14"]
[null,null,null,null,null,null,"покупатель15"]
[null,null,null,null,null,null,"покупатель16"]
[null,null,null,null,null,null,"покупатель17"]
[null,null,null,null,null,null,"покупатель18"]
[null,null,null,null,null,null,"покупатель19"]
[null,null,null,null,null,null,"покупатель20"]
[null,null,null,null,null,null,"покупатель21"]
[null,null,null,null,null,null,"покупатель22"]
[null,null,null,null,null,null,"покупатель23"]
[null,null,null,null,null,null,"покупатель24"]

{"sheet":"Отчет","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,5,1,8]]}
[null,null,null,"Отчет за ","___________апрель"]
["Наименование","Движение","Остаток","Дата","кол-во, т","Примечание"]
["Товар 1","приход",null,"2013-04-14",5]
[null,"приход",null,"2013-04-15",7]
[null,"приход",null,"2013-04-16",10]
[null,"приход",null,"2013-04-17",5]
[null,"приход",null,"2013-04-18",7]
[null,"приход",null,"2013-04-19",10]
[null,"приход",null,"2013-04-20",5]
[null,"приход",null,"2013-04-21",7]
[null,"приход",null,"2013-04-22",10]
[null,"приход",null,"2013-04-23",5]
[null,"приход",null,"2013-04-24",7]
[null,"приход",null,"2013-04-25",10]
[]
[null,"расход",null,"2013-04-15",18,"получатель","тип отгрузки"]
[null,"расход",null,"2013-04-16",22]
[null,"расход",null,"2013-04-17",85]
[null,"расход",null,"2013-04-18",148]
[null,"расход",null,"2013-04-19",211]
[null,"расход",null,"2013-04-20",274]
[null,"расход",null,"2013-04-21",337]
[null,"расход",null,"2013-04-22",400]
[null,"расход",null,"2013-04-23",463]
[null,"расход",null,"2013-04-24",526]
[null,"расход",null,"2013-04-25",589]