{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Движ ТМЦ-ЕСТЬ","НАДО","Свод"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":20,"n_cols":94,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Нименование","2016-09-01","приход","расход",{"$f":"B1+1","v":"2016-09-02"},"приход","расход",{"$f":"E1+1","v":"2016-09-03"},"приход","расход",{"$f":"H1+1","v":"2016-09-04"},"приход","расход",{"$f":"K1+1","v":"2016-09-05"},"приход","расход",{"$f":"N1+1","v":"2016-09-06"},"приход","расход",{"$f":"Q1+1","v":"2016-09-07"},"приход","расход",{"$f":"T1+1","v":"2016-09-08"},"приход","расход",{"$f":"W1+1","v":"2016-09-09"},"приход","расход",{"$f":"Z1+1","v":"2016-09-10"},"приход","расход",{"$f":"AC1+1","v":"2016-09-11"},"приход","расход",{"$f":"AF1+1","v":"2016-09-12"},"приход","расход",{"$f":"AI1+1","v":"2016-09-13"},"приход","расход",{"$f":"AL1+1","v":"2016-09-14"},"приход","расход",{"$f":"AO1+1","v":"2016-09-15"},"приход","расход",{"$f":"AR1+1","v":"2016-09-16"},"приход","расход",{"$f":"AU1+1","v":"2016-09-17"},"приход","расход",{"$f":"AX1+1","v":"2016-09-18"},"приход","расход",{"$f":"BA1+1","v":"2016-09-19"},"приход","расход",{"$f":"BD1+1","v":"2016-09-20"},"приход","расход",{"$f":"BG1+1","v":"2016-09-21"},"приход","расход",{"$f":"BJ1+1","v":"2016-09-22"},"приход","расход",{"$f":"BM1+1","v":"2016-09-23"},"приход","расход",{"$f":"BP1+1","v":"2016-09-24"},"приход","расход",{"$f":"BS1+1","v":"2016-09-25"},"приход","расход",{"$f":"BV1+1","v":"2016-09-26"},"приход","расход",{"$f":"BY1+1","v":"2016-09-27"},"приход","расход",{"$f":"CB1+1","v":"2016-09-28"},"приход","расход",{"$f":"CE1+1","v":"2016-09-29"},"приход","расход",{"$f":"CH1+1","v":"2016-09-30"},"приход","расход",{"$f":"CK1+1","v":"2016-10-01"},"приход","расход"]
["ПЭНД 2НТ76-17 (1820)",475,null,null,{"$f":"B2+C2-D2","v":475},null,null,{"$f":"E2+F2-G2","v":475},null,null,{"$f":"H2+I2-J2","v":475},null,null,{"$f":"K2+L2-M2","v":475},null,null,{"$f":"N2+O2-P2","v":475},null,150,{"$f":"Q2+R2-S2","v":325},null,null,{"$f":"T2+U2-V2","v":325},null,150,{"$f":"W2+X2-Y2","v":175},null,175,{"$f":"Z2+AA2-AB2","v":0},null,null,{"$f":"AC2+AD2-AE2","v":0},null,null,{"$f":"AF2+AG2-AH2","v":0},null,null,{"$f":"AI2+AJ2-AK2","v":0},{"$f":"1250+1250","v":2500},null,{"$f":"AL2+AM2-AN2","v":2500},null,150,{"$f":"AO2+AP2-AQ2","v":2350},null,100,{"$f":"AR2+AS2-AT2","v":2250},null,null,{"$f":"AU2+AV2-AW2","v":2250},null,null,{"$f":"AX2+AY2-AZ2","v":2250},null,null,{"$f":"BA2+BB2-BC2","v":2250},null,150,{"$f":"BD2+BE2-BF2","v":2100},null,250,{"$f":"BG2+BH2-BI2","v":1850},null,null,{"$f":"BJ2+BK2-BL2","v":1850},null,null,{"$f":"BM2+BN2-BO2","v":1850},null,250,{"$f":"BP2+BQ2-BR2","v":1600},null,null,{"$f":"BS2+BT2-BU2","v":1600},null,null,{"$f":"BV2+BW2-BX2","v":1600},null,null,{"$f":"BY2+BZ2-CA2","v":1600},null,100,{"$f":"CB2+CC2-CD2","v":1500},null,null,{"$f":"CE2+CF2-CG2","v":1500},null,100,{"$f":"CH2+CI2-CJ2","v":1400},null,150,{"$f":"CK2+CL2-CM2","v":1250},{"$f":"SUMIF(B$1:CN$1,\"приход\",B2:CN2)","v":2500},{"$f":"SUMIF(B$1:CN$1,\"расход\",B2:CN2)","v":1725}]
["ПЭНД 2НТ76-17 (желтый)сырье",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,20,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,{"$f":"SUMIF(B$1:CN$1,\"приход\",B3:CN3)","v":20},{"$f":"SUMIF(B$1:CN$1,\"расход\",B3:CN3)","v":0}]
["ПЭНД 273-83 (2094)",2500,null,null,2500,null,200,2300,null,null,2300,null,null,2300,null,{"$f":"200+200","v":400},1900,null,null,1900,null,650,1250,null,300,950,null,950,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUMIF(B$1:CN$1,\"приход\",B4:CN4)","v":0},{"$f":"SUMIF(B$1:CN$1,\"расход\",B4:CN4)","v":2500}]
["ПЭНД 273-83 (3348)",0,20000,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,1250,18750,null,null,18750,null,1250,17500,null,null,17500,null,null,17500,null,null,17500,null,null,17500,null,null,17500,null,1250,16250,null,null,16250,null,null,16250,null,null,16250,null,null,16250,null,1250,15000,null,null,15000,null,null,15000,null,1250,13750,null,null,13750,{"$f":"SUMIF(B$1:CN$1,\"приход\",B5:CN5)","v":20000},{"$f":"SUMIF(B$1:CN$1,\"расход\",B5:CN5)","v":6250}]
["ПЭНД 273-83 (3433)",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,18750,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,null,null,18750,{"$f":"SUMIF(B$1:CN$1,\"приход\",B6:CN6)","v":18750},{"$f":"SUMIF(B$1:CN$1,\"расход\",B6:CN6)","v":0}]
["ПЭНД 273-83 (3489)",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,20000,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,null,null,20000,{"$f":"SUMIF(B$1:CN$1,\"приход\",B7:CN7)","v":20000},{"$f":"SUMIF(B$1:CN$1,\"расход\",B7:CN7)","v":0}]
["Баско черный ПФ1901/07 ПЭ",75,null,null,75,null,null,75,null,null,75,null,null,75,null,25,50,null,null,50,null,null,50,42,17,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,25,50,null,null,50,null,null,50,null,null,50,null,null,50,null,null,50,null,null,50,null,null,50,null,null,50,{"$f":"SUMIF(B$1:CN$1,\"приход\",B8:CN8)","v":42},{"$f":"SUMIF(B$1:CN$1,\"расход\",B8:CN8)","v":67}]
["Баско ярко-красный П1105/02 ПЭ",25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,{"$f":"SUMIF(B$1:CN$1,\"приход\",B9:CN9)","v":0},{"$f":"SUMIF(B$1:CN$1,\"расход\",B9:CN9)","v":0}]
["Баско желтный ПФ 1305/01 ПЭ (1281 - 16/июль)",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,20,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,null,20,null,20,0,null,null,0,16,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,null,null,16,{"$f":"SUMIF(B$1:CN$1,\"приход\",B10:CN10)","v":36},{"$f":"SUMIF(B$1:CN$1,\"расход\",B10:CN10)","v":20}]
["Краситель МЕ 96412 TOSAF",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,1.8149999999999999,null,1.8149999999999999,null,null,1.8149999999999999,null,null,1.8149999999999999,null,null,1.8149999999999999,null,null,1.8149999999999999,{"$f":"SUMIF(B$1:CN$1,\"приход\",B11:CN11)","v":1.8149999999999999},{"$f":"SUMIF(B$1:CN$1,\"расход\",B11:CN11)","v":0}]
["Краситель МЕ 95510 TOSAF",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,1.651,null,1.651,null,null,1.651,null,null,1.651,null,null,1.651,null,null,1.651,{"$f":"SUMIF(B$1:CN$1,\"приход\",B12:CN12)","v":1.651},{"$f":"SUMIF(B$1:CN$1,\"расход\",B12:CN12)","v":0}]
["Краситель МЕ 31514 TOSAF",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,2.4300000000000002,null,2.4300000000000002,null,null,2.4300000000000002,null,null,2.4300000000000002,null,null,2.4300000000000002,null,null,2.4300000000000002,{"$f":"SUMIF(B$1:CN$1,\"приход\",B13:CN13)","v":2.4300000000000002},{"$f":"SUMIF(B$1:CN$1,\"расход\",B13:CN13)","v":0}]
["Краситель МЕ 32161 TOSAF",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,1.5649999999999999,null,1.5649999999999999,null,null,1.5649999999999999,null,null,1.5649999999999999,null,null,1.5649999999999999,null,null,1.5649999999999999,{"$f":"SUMIF(B$1:CN$1,\"приход\",B14:CN14)","v":1.5649999999999999},{"$f":"SUMIF(B$1:CN$1,\"расход\",B14:CN14)","v":0}]
["Суперконцентрат ST2067 (ANTISTATIC MB)",75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,null,null,75,{"$f":"SUMIF(B$1:CN$1,\"приход\",B15:CN15)","v":0},{"$f":"SUMIF(B$1:CN$1,\"расход\",B15:CN15)","v":0}]
["Суперконцентрат МЕ 41862(красный)",125,null,null,125,null,null,125,null,null,125,null,null,125,null,null,125,null,null,125,null,null,125,null,25,100,null,null,100,null,null,100,null,null,100,null,null,100,null,25,75,null,null,75,21,null,96,23,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,null,null,119,{"$f":"SUMIF(B$1:CN$1,\"приход\",B16:CN16)","v":44},{"$f":"SUMIF(B$1:CN$1,\"расход\",B16:CN16)","v":50}]
["Суперконцентрат МЕ 44444А(красный)",145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,null,145,null,13,132,null,25,107,null,null,107,null,25,82,null,null,82,{"$f":"SUMIF(B$1:CN$1,\"приход\",B17:CN17)","v":0},{"$f":"SUMIF(B$1:CN$1,\"расход\",B17:CN17)","v":63}]
["Суперконцентрат МЕ 52420(зеленый)",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,50,null,50,null,null,50,null,null,50,null,null,50,null,null,50,null,25,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,null,null,25,8,null,33,null,8,25,null,null,25,null,null,25,null,null,25,null,null,25,4,null,29,null,null,29,null,null,29,{"$f":"SUMIF(B$1:CN$1,\"приход\",B18:CN18)","v":62},{"$f":"SUMIF(B$1:CN$1,\"расход\",B18:CN18)","v":33}]
["Суперконцентрат EI9251А (черный)",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,72,8,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,null,null,64,{"$f":"SUMIF(B$1:CN$1,\"приход\",B19:CN19)","v":72},{"$f":"SUMIF(B$1:CN$1,\"расход\",B19:CN19)","v":8}]
["Суперконцентрат  МЕ95510 (серебро)",0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,25,null,25,null,null,25,null,null,25,null,null,25,{"$f":"SUMIF(B$1:CN$1,\"приход\",B20:CN20)","v":25},{"$f":"SUMIF(B$1:CN$1,\"расход\",B20:CN20)","v":0}]

{"sheet":"НАДО","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Наименование ТМЦ","Операция","Дата","Количество"]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-06",150]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-08",150]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-09",175]
["ПЭНД 2НТ76-17 (1820)","Приход","2016-09-13",2500]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-14",150]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-15",100]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-19",150]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-20",250]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-23",250]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-27",100]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-29",100]
["ПЭНД 2НТ76-17 (1820)","Расход","2016-09-30",150]
["ПЭНД 2НТ76-17 (желтый)сырье","Приход","2016-09-07",20]
["ПЭНД 273-83 (2094)","Расход","2016-09-02",200]
["ПЭНД 273-83 (2094)","Расход","2016-09-05",400]
["ПЭНД 273-83 (2094)","Расход","2016-09-07",650]
["ПЭНД 273-83 (2094)","Расход","2016-09-08",300]
["ПЭНД 273-83 (2094)","Расход","2016-09-09",950]

{"sheet":"Свод","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Названия строк","Сумма по полю Количество"]
["ПЭНД 273-83 (2094)",2500]
["Расход",2500]
["ПЭНД 2НТ76-17 (1820)",4225]
["Приход",2500]
["Расход",1725]
["ПЭНД 2НТ76-17 (желтый)сырье",20]
["Приход",20]
["Общий итог",6745]