{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"1","index":0,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["дата получения"," сырье","количество","сумма",null,"сред. цена","наименование сырье","осталось ",null,"Home Pak","City Baf","Home Pak","City Baf","City Baf"]
["2013-11-09","C 0.5 mm",120,300,null,{"$f":"SUMIFS($D$2:$D$22,$B$2:$B$22,G2)/SUMIFS($C$2:$C$22,$B$2:$B$22,G2)","v":2.3181818181818183},"RT 120 c",{"$f":"SUMIFS($C$2:$C$22,$B$2:$B$22,G2)-SUMPRODUCT($J$12:$O$12,J2:O2)","v":7},null,2,null,0.5,null,0.5]
["2013-11-11","A 0.5 mm",100,125,null,{"$f":"SUMIFS($D$2:$D$22,$B$2:$B$22,G3)/SUMIFS($C$2:$C$22,$B$2:$B$22,G3)","v":0.82926829268292679},"Rt 120 a",190,null,1,2,1,2,1]
["2013-11-12","Lc 350 ge",50,55,null,2.5,"C 0.5 mm",320]
["2013-11-13","BTK 150 ge",25,70,null,1.2777777777777777,"A 0.5 mm",177,null,0.2,null,0.2,1,0.2]
["2013-11-14","Lc 350 ru",50,60,null,0.55000000000000004,"BTK 150",5,null,3,null,3,null,3]
["2013-11-15","A 0.5 mm",25,37,null,1.25,"Lc 350 ge",96.5,null,0.5,null,0.5,0.5,0.5]
["2013-11-16","Ac 500 ",100,350,null,1.2,"Lc 350 ru",20,null,6,null,6,null,6]
["2013-11-17","C 0.5 mm",200,500,null,3.5,"Ac 500 ",55,null,7,null,7,5,7]
["2013-11-18","Lc 350 ge",50,70,null,2.8,"BTK 150 ge",10,null,3,null,3,null,3]
["2013-11-19","Rt 120 a",55,50,null,null,null,{"$f":"SUMPRODUCT($F$2:$F$10,H2:H10)","v":1567.8299150036955},null,{"$f":"SUMPRODUCT($F$2:$F$10,J2:J10)*J12","v":48.096187484602119},4.975609756097561,44.618914757329385,42.12262872628726,133.85674427198816,0]
["2013-11-20","Rt 120 a",150,120,null,null,null,null,null,1,3,1,2,3,6,"производство штук"]
["2013-11-20","BTK 150",20,11,null,null,null,null,null,"2013-11-08","2013-11-09","2013-11-10","2013-11-11","2013-11-12","2013-11-13","производство  дата"]
["2013-11-21","A 0.5 mm",55,68,null,"себестоимость","наименование продукция","производство штук"]
["2013-11-21","RT 120 c",11,25.5,null,{"$f":"IF(H15=0,\" \",SUMIFS($J$11:$O$11,$J$1:$O$1,G15)/SUMIFS($J$12:$O$12,$J$1:$O$1,G15))","v":46.357551120965752},"Home Pak",{"$f":"SUMIFS($J$12:$O$12,$J$1:$O$1,G15)","v":2}]
[null,null,null,null,null,{"$f":"IF(H16=0,\" \",SUMIFS($J$11:$O$11,$J$1:$O$1,G16)/SUMIFS($J$12:$O$12,$J$1:$O$1,G16))","v":22.619372844296624},"City Baf",{"$f":"SUMIFS($J$12:$O$12,$J$1:$O$1,G16)","v":8}]
[null,null,null,null,null,null,null,{"$f":"SUMPRODUCT($F$15:$F$16,H15:H16)","v":273.67008499630447}]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"SUM(D2:D22)","v":1841.5}]