{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Отчеты","Отчет№1","Отчет№2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":62,"n_cols":87,"rows_kept":62,"cut":false,"hidden":false,"merged":[[0,0,0,86],[35,0,35,18],[38,7,39,7],[38,8,39,8],[38,9,39,9],[38,10,39,10],[1,0,1,3],[1,4,1,44],[36,17,36,18],[37,17,39,17],[37,18,39,18],[36,0,37,1],[36,2,37,2],[36,3,37,12],[38,5,39,5],[38,6,39,6],[38,11,39,11],[38,12,39,12],[1,45,1,86],[38,0,39,0],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[36,15,39,15],[36,13,39,13],[36,14,39,14],[36,16,39,16]]}
["Списание сырья на готовую продукцию "]
[null,null,null,null,"нормы",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Списоно на готовую продукцию"]
["№","Наименование изделия","артикул/рисунок изделия","выраб.гот.прод.за текущ м-ц","Раматура","Названия сырья >",null,null,null,"Цемент",null,null,null,null,null,null,null,null,null,null,null,null,"Песок",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Раматура","Названия сырья >",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1.8E-3,null,null,null,null,null,null,null,null,null,null,null,null,1.6000000000000001E-3,1.5E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,{"$f":"D4*X4","v":0},{"$f":"D4*W4","v":0},{"$f":"D4*X4","v":0},0,0,null,0,0,null,0,null,0,null,0,null,null,null,null,null,null,null,{"$f":"D4*J4","v":0}]
[2,null,null,null,null,null,1.9E-3,null,null,1.9E-3,null,null,null,null,null,null,null,null,null,null,1.4E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[3,null,null,null,null,null,null,null,null,2.3999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,1.6000000000000001E-3,1.8E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6*W6","v":0},{"$f":"D6*X6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D6*J6","v":0}]
[4,null,null,null,null,null,null,null,null,2.3999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000001E-3,2.0999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D7*AE7","v":0},{"$f":"D7*AF7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,3.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000001E-3,2.5999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D8*W6","v":0},{"$f":"D8*X6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[6,null,null,null,null,null,2.8E-3,null,null,3.3E-3,null,null,null,null,null,null,null,null,null,null,2.3E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9*G9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D9*U9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[7,"Бетонный пасынок",null,20,3.5000000000000001E-3,null,null,null,null,4.1999999999999997E-3,null,null,null,null,null,null,null,null,null,null,null,null,3.0999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10*E10","v":7.0000000000000007E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D10*W10","v":6.2E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3999999999999991E-2]
[8,null,null,null,null,null,3.5000000000000001E-3,null,null,4.1999999999999997E-3,null,null,null,null,null,null,null,null,null,null,3.2000000000000002E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D11*G11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D11*U11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,1.04E-2,null,null,4.1000000000000003E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D12*G12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,3.5000000000000001E-3,null,4.1999999999999997E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2000000000000002E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D13*H13","v":0},null,{"$f":"AE13*D13","v":0},{"$f":"D13*AF13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,4.4999999999999997E-3,null,null,null,null,5.3E-3,null,null,null,null,null,null,null,null,null,null,null,null,3.3999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14*E14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14*W14","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,4.4999999999999997E-3,null,null,5.3E-3,null,null,null,null,null,null,null,null,null,null,3.3999999999999998E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15*G15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15*U15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,1.17E-2,null,null,4.7999999999999996E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D16*G16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,4.4999999999999997E-3,null,5.3E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.1999999999999997E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D17*H17","v":0},null,{"$f":"AE17*D17","v":0},{"$f":"D17*AF17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BU17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,5.3E-3,null,null,null,null,6.4999999999999997E-3,null,null,null,null,null,null,null,null,null,null,null,null,4.3E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18*E18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D18*W18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,5.5999999999999999E-3,null,null,null,null,null,null,null,null,null,null,4.5999999999999999E-3,null,null,null,null,null,8.5000000000000006E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D19*AA19","v":0},null,null,null,null,{"$f":"D19*U19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,5.5999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.5000000000000006E-3,null,null,4.5999999999999999E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AE20*D20","v":0},null,null,null,null,null,null,null,null,null,{"$f":"D20*AB20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D4:D20)","v":20},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AT4:AT20)","v":7.0000000000000007E-2},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BE4:BE20)","v":0},{"$f":"SUM(BF4:BF20)","v":0},0,0,0,0,0,0,0,0,6.2E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,8.3999999999999991E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Отчет о движении сырья "]
[null,null,null,"Приход на склад ",null,null,null,null,null,null,null,null,null,"Всего поступило Сырья за м-ц","Итого","остаток сырья на складе на конец м-ца","Списание сырья","остаток"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сырья в цеху на конец м-ца","итоговое к-во сырья на конец м-ца"]
["№","Наименование сырья","на складе на начало м-ца","2015-04-21","2015-04-22","2015-04-25"]
[]
[1,"Цемент",1000,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D41:M41)","v":0},{"$f":"C41+N41","v":1000},null,{"$f":"CI21","v":8.3999999999999991E-2},{"$f":"O41-P41-Q41","v":999.91600000000005},{"$f":"P41+R41","v":999.91600000000005}]
[2,"Песок",500,300,null,null,null,null,null,null,null,null,null,300,800,null,{"$f":"BO21","v":6.2E-2},799.93799999999999,799.93799999999999]
[3,"М.крошка",8800,null,null,800,null,null,null,null,null,null,null,800,9600,null,null,9600,9600]
[4,"Галька",546,null,null,null,null,null,null,null,null,null,null,0,546,null,null,546,546]
[5,"Бутов камень",321,null,null,null,null,null,null,null,null,null,null,0,321,null,null,321,321]
[6,"Раматура",8446,null,null,null,null,null,null,null,null,null,null,0,8446,null,{"$f":"AT21","v":7.0000000000000007E-2},8445.93,8445.93]
[7,"Шлак",null,null,250,null,null,null,null,null,null,null,null,250,250,null,null,250,250]
[8,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D56:M56)","v":0},0,null,null,0,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:M57)","v":0},0,null,null,0,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[21,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0]
[null,null,{"$f":"SUM(C41:C61)","v":19613},{"$f":"SUM(D41:D61)","v":300},{"$f":"SUM(E41:E61)","v":250},{"$f":"SUM(F41:F61)","v":800},{"$f":"SUM(G41:G61)","v":0},{"$f":"SUM(H41:H61)","v":0},{"$f":"SUM(I41:I61)","v":0},{"$f":"SUM(J41:J61)","v":0},{"$f":"SUM(K41:K61)","v":0},{"$f":"SUM(L41:L61)","v":0},{"$f":"SUM(M41:M61)","v":0},{"$f":"SUM(N41:N61)","v":1350},20963,0,0.216,20962.784,20962.784]

{"sheet":"Отчет№1","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,3],[1,4,1,6],[1,7,1,9]]}
["Списание сырья на готовую продукцию "]
[null,null,null,null,"нормы",null,null,"Списоно на готовую продукцию"]
["№","Наименование изделия","артикул/рисунок изделия","выраб.гот.прод.за текущ м-ц","Раматура","Цемент","Песок","Раматура","Песок","Цемент"]
[1,null,null,null,null,1.8E-3,1.6000000000000001E-3,null,{"$f":"D4*G4","v":0},{"$f":"D4*F4","v":0}]
[2,null,null,null,null,1.9E-3,null,null,null,0]
[3,null,null,null,null,2.3999999999999998E-3,1.6000000000000001E-3,null,{"$f":"D6*G6","v":0},{"$f":"D6*F6","v":0}]
[4,null,null,null,null,2.3999999999999998E-3,null,null,null,0]
[5,null,null,null,null,3.0000000000000001E-3,2.2000000000000001E-3,null,{"$f":"D8*G6","v":0},0]
[6,null,null,null,null,3.3E-3,null,null,null,0]
[7,"Бетонный пасынок",null,20,3.5000000000000001E-3,4.1999999999999997E-3,3.0999999999999999E-3,{"$f":"D10*E10","v":7.0000000000000007E-2},{"$f":"D10*G10","v":6.2E-2},8.3999999999999991E-2]
[8,null,null,null,null,4.1999999999999997E-3,null,null,null,0]
[9,null,null,null,null,4.1000000000000003E-3,null,null,null,0]
[10,null,null,null,null,4.1999999999999997E-3,null,null,null,0]
[11,null,null,null,4.4999999999999997E-3,5.3E-3,3.3999999999999998E-3,{"$f":"D14*E14","v":0},{"$f":"D14*G14","v":0},0]
[12,null,null,null,null,5.3E-3,null,null,null,0]
[13,null,null,null,null,4.7999999999999996E-3,null,null,null,0]
[14,null,null,null,null,5.3E-3,null,null,null,0]
[15,null,null,null,5.3E-3,6.4999999999999997E-3,4.3E-3,{"$f":"D18*E18","v":0},{"$f":"D18*G18","v":0},0]
[16,null,null,null,null,5.5999999999999999E-3,null,null,null,0]
[17,null,null,null,null,5.5999999999999999E-3,null,null,null,0]
[null,null,null,{"$f":"SUM(D4:D20)","v":20},null,null,null,{"$f":"SUM(H4:H20)","v":7.0000000000000007E-2},{"$f":"SUM(I4:I20)","v":6.2E-2},{"$f":"SUM(J4:J20)","v":8.3999999999999991E-2}]

{"sheet":"Отчет№2","index":2,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,10,1,11],[2,10,4,10],[2,11,4,11],[0,0,0,11],[1,0,2,1],[1,2,2,2],[1,3,2,5],[1,6,4,6],[1,7,4,7],[3,5,4,5],[3,4,4,4],[1,9,4,9],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[1,8,4,8]]}
["Отчет о движении сырья "]
[null,null,null,"Приход на склад ",null,null,"Всего поступило Сырья за м-ц","Итого","остаток сырья на складе на конец м-ца","Списание сырья","остаток"]
[null,null,null,null,null,null,null,null,null,null,"сырья в цеху на конец м-ца","итоговое к-во сырья на конец м-ца"]
["№","Наименование сырья","на складе на начало м-ца","2015-04-21","2015-04-22","2015-04-25"]
[]
[1,"Цемент",1000,null,null,null,{"$f":"SUM(D6:F6)","v":0},{"$f":"C6+G6","v":1000},null,{"$f":"Отчет№1!J21","v":8.3999999999999991E-2},{"$f":"H6-I6-J6","v":999.91600000000005},{"$f":"I6+K6","v":999.91600000000005}]
[2,"Песок",500,300,null,null,300,800,null,{"$f":"Отчет№1!I21","v":6.2E-2},799.93799999999999,799.93799999999999]
[3,"М.крошка",8800,null,null,800,800,9600,null,null,9600,9600]
[4,"Галька",546,null,null,null,0,546,null,null,546,546]
[5,"Бутов камень",321,null,null,null,0,321,null,null,321,321]
[6,"Раматура",8446,null,null,null,0,8446,null,{"$f":"Отчет№1!H21","v":7.0000000000000007E-2},8445.93,8445.93]
[7,"Шлак",null,null,250,null,250,250,null,null,250,250]
[8,null,null,null,null,null,0,0,null,null,0,0]
[9,null,null,null,null,null,0,0,null,null,0,0]
[10,null,null,null,null,null,0,0,null,null,0,0]
[11,null,null,null,null,null,0,0,null,null,0,0]
[12,null,null,null,null,null,0,0,null,null,0,0]
[13,null,null,null,null,null,0,0,null,null,0,0]
[14,null,null,null,null,null,0,0,null,null,0,0]
[15,null,null,null,null,null,0,0,null,null,0,0]
[16,null,null,null,null,null,{"$f":"SUM(D21:F21)","v":0},0,null,null,0,0]
[17,null,null,null,null,null,0,0,null,null,0,0]
[18,null,null,null,null,null,0,0,null,null,0,0]
[19,null,null,null,null,null,0,0,null,null,0,0]
[20,null,null,null,null,null,0,0,null,null,0,0]
[21,null,null,null,null,null,0,0,null,null,0,0]
[null,null,{"$f":"SUM(C6:C26)","v":19613},{"$f":"SUM(D6:D26)","v":300},{"$f":"SUM(E6:E26)","v":250},{"$f":"SUM(F6:F26)","v":800},{"$f":"SUM(G6:G26)","v":1350},20963,{"$f":"SUM(I6:I26)","v":0},0.216,20962.784,20962.784]