{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Giris","REDDEDİLEN ÜRÜNLER-10","OzetTablo","Sheet5","Sheet2","Sheet1","Sheet3"],"not_rendered":{"charts":5,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":3},"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":"Giris","index":0,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,16,0,17]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GENEL GÖSTERGELER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOPLAM UOM SAYISI",60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOPLAM MİKTAR (KG)",65886]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AY","MİKTAR (KG)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OCAK",4386]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ŞUBAT",14599]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MART",24004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NİSAN",4823]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAYIS",8102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAZİRAN",6776]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEMMUZ",1391]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AĞUSTOS",1805]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EYLÜL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EKİM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KASIM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ARALIK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOPLAM",65886]

{"sheet":"REDDEDİLEN ÜRÜNLER-10","index":1,"n_rows":61,"n_cols":14,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["UOM No","ÜRÜNÜN KODU","PARTİ NUMARASI","MİKTARI (KG)","AY","İŞLEM TARİHİ","REDDEDİLME SEBEBİ","SEKTÖR","HATA KAYNAĞI","DURUM GÜNCEL","MİKTAR ","DEĞERLENDİRİLEN-İMHA OLAN MİKTAR","STOK DURUMU","sorumlu"]
[1,"520-3358",7917377,475,"OCAK ","2012-01-09","YAPIŞMA","SANAYİ","BELİRSİZ ","STOK",475,0,{"$f":"D2-L2","v":475},"AÖ-AS"]
["2","661-2659",7913668,1500,"OCAK ","2012-01-13","RENK","MOBİLYA","ARGE","STOK",1500,1500,0,"FK"]
["3","368-7206",7916655,1200,"OCAK ","2012-01-17","YÜZME","SANAYİ","ARGE","DEĞERLENDİRİLDİ ",1200,1050,150,"OZ"]
["4","200-9212",7916833,340,"OCAK ","2012-01-19","RENK","SANAYİ","ÜRETİM","DEĞERLENDİRİLDİ ",340,340,0,"FÇ"]
["5","155-1206",7917286,305,"OCAK ","2012-01-20","RENK","SANAYİ","HAMMADDE KAYNAKLI","DEĞERLENDİRİLDİ ",305,305,0,"AK"]
["6","602-1073",7916015,{"$f":"ROUND(200 +300*RAND(),0)","v":269},"OCAK ","2012-01-24","RENK","MOBİLYA","ÜRETİM","STOK",260,260,9,"EÇ"]
["7","141-7615",7921968,{"$f":"ROUND(200 +300*RAND(),0)","v":383},"OCAK ","2012-01-30","RENK","OTB","KALİTE","STOK",306,0,383,"İS"]
["8","661-2659",7920716,357,"ŞUBAT","2012-02-06","RENK","MOBİLYA","ÜRETİM","DEĞERLENDİRİLDİ ",2900,2900,-2543,"EÇ"]
["9","537-7977",7917291,344,"ŞUBAT","2012-02-07","RENK","DENİZ","ARGE","STOK",900,900,-556,"OZ"]
["10","841-0602",7919742,290,"ŞUBAT","2012-02-13","RENK","SANAYİ","BELİRSİZ ","DEĞERLENDİRİLDİ ",1020,328,-38,"AS"]
["11","671-1487",7925156,403,"ŞUBAT","2012-02-13","VİSKOZİTE","MOBİLYA","ÜRETİM","STOK",1450,0,403,"EÇ"]
["12","036-8226",7918534,309,"ŞUBAT","2012-02-14","KURUMA","SENTETİK","BELİRSİZ ","STOK",2750,2750,-2441,"ES"]
["13","118-5264",7928453,299,"ŞUBAT","2012-02-23","FORMÜL","OTB","RENK MİX ARGE ","STOK",309,309,-10,"DD"]
["14","110-1203",7930480,371,"ŞUBAT","2012-02-23","RENK","SANAYİ","SANAYİ ARGE ","STOK",430,430,-59,"OZ"]
["15","125-7489",7930540,428,"MART","2012-03-02","YÜZEY PROBLEMİ","SANAYİ","BELİRSİZ ","STOK",260,0,428,"AS"]
["16","431-5038",7937129,304,"MART","2012-03-12","RENK","SANAYİ","RENK MİX ARGE ","DEĞERLENDİRİLDİ ",930,930,-626,"DD"]
["17","431-5038",7932960,494,"MART","2012-03-02","RENK","SANAYİ","BELİRSİZ ","DEĞERLENDİRİLDİ ",340,340,154,"DD"]
["18","599-9521",7926718,334,"ŞUBAT","2012-02-27","VİSKOZİTE","SANAYİ","ARGE","STOK",1040,0,334,"ÖCŞ"]
["19","599-9521",7927657,457,"ŞUBAT","2012-02-27","VİSKOZİTE","SANAYİ","ARGE","DEĞERLENDİRİLDİ ",770,100,357,"ÖCŞ"]
["20","574-1821",7932575,473,"MART","2012-03-01","VİSKOZİTE","SANAYİ","YARIÜRÜN","DEĞERLENDİRİLDİ ",393,393,80,"ÖCŞ"]
["21","129-6793",7937546,202,"MART","2012-03-09","RENK","MOBİLYA","ARGE","DEĞERLENDİRİLDİ ",780,780,-578,"FK"]
["22","321-7396",7930608,344,"MART","2012-03-12","RENK","SANAYİ","ÜRETİM","DEĞERLENDİRİLDİ ",2620,2620,-2276,"AS"]
["23","701-1280",7930257,328,"MART","2012-03-15","RENK","MOBİLYA","ÜRETİM","DEĞERLENDİRİLDİ ",3060,3060,-2732,"EÇ"]
["24","458-7402",7939095,443,"MART","2012-03-20","HATALI HAMMADDE ETİKETLEME ","COIL","LOJİSTİK","İMHA",5038,5038,-4595,"ÖA"]
["25","321-2736",7940449,319,"MART","2012-03-20","HATALI HAMMADDE ETİKETLEME ","SANAYİ","LOJİSTİK","İMHA",124,134,185,"ÖA"]
["26","318-4813",7940916,489,"MART","2012-03-20","HATALI HAMMADDE ETİKETLEME ","SANAYİ","LOJİSTİK","İMHA",515,5,484,"ÖA"]
["27","431-4143",7939251,415,"MART","2012-03-19","EFEKT ","SANAYİ","RENK MİX ARGE ","DEĞERLENDİRİLDİ ",965,965,-550,"DD"]
["28","152-7227",7934480,421,"MART","2012-04-24","YÜZEY PROBLEMİ","SANAYİ","ÜRETİM","STOK",313,313,108,"AS"]
["29","110-7199",7935225,303,"MART","2012-03-29","PARLAKLIK","SANAYİ","SANAYİ ARGE ","DEĞERLENDİRİLDİ ",582,302,1,"DD"]
["30","321-7900",7932537,371,"ŞUBAT","2012-02-23","FORMÜL","SANAYİ","SANAYİ ARGE ","DEĞERLENDİRİLDİ ",3030,3030,-2659,"ÖC"]
["31","010-6870",7937989,459,"MART","2012-03-30","RENK","SANAYİ","KALİTE","DEĞERLENDİRİLDİ ",7360,7360,-6901,"İS"]
["32","311-6368",7948832,260,"NİSAN","2012-04-17","RENK","MOBİLYA","ARGE","DEĞERLENDİRİLDİ ",1750,1750,-1490,"FK"]
["33","545-1010",7950537,304,"NİSAN","2012-04-20","RENK","SANAYİ","BELİRSİZ ","DEĞERLENDİRİLDİ ",920,920,{"$f":"D34-L34","v":-616},"EÇ"]
["34","594-0020",7941305,223,"NİSAN","2012-04-27","FORMÜL","SANAYİ","ARGE","STOK",515,0,223,"DY"]
["35","051-1872",7957421,357,"MAYIS","2012-05-16","RENK","SANAYİ","ARGE","DEĞERLENDİRİLDİ ",440,440,-83,"DD"]
["36","601-1051",7958004,453,"MAYIS","2012-05-17","RENK","MOBİLYA","ARGE","DEĞERLENDİRİLDİ ",560,560,-107,"ÖK"]
["37","317-7285",7960142,457,"MAYIS","2012-05-18","ATIL DEĞERLENDİRME","SANAYİ","ÜRETİM","DEĞERLENDİRİLDİ ",308,308,149,"AS"]
["38","621-1385",7955881,240,"MAYIS","2012-05-18","RENK","MOBİLYA","ÜRETİM","DEĞERLENDİRİLDİ ",816,441,-201,"EÇ"]
["39","341-6087",7958415,395,"MAYIS","2012-05-21","RENK","MOBİLYA","BELİRSİZ ","DEĞERLENDİRİLDİ ",310,310,85,"FK"]
["40","341-6147",7959033,220,"MAYIS","2012-05-21","RENK","MOBİLYA","BELİRSİZ ","DEĞERLENDİRİLDİ ",280,280,-60,"FK"]
["41","602-1148",7959774,455,"MAYIS","2012-05-28","RENK","MOBİLYA","ÜRETİM","DEĞERLENDİRİLDİ ",1000,1000,-545,"EÇ"]
["42","251-7487",7958534,247,"MAYIS","2012-05-30","YÜZEY PROBLEMİ","SANAYİ","BELİRSİZ ","STOK",690,0,247,"AS"]
["43","458-2541",7957047,309,"MAYIS","2012-05-31","HAMMADDE","COIL","BELİRSİZ ","İMHA",3750,0,309,"AS"]
["44","701-1380",7945898,315,"NİSAN","2012-04-20","RENK","MOBİLYA","BELİRSİZ ","DEĞERLENDİRİLDİ ",410,410,-95,"EÇ"]
["45","621-1385",7965912,407,"HAZİRAN","2012-06-05","RENK","MOBİLYA","ÜRETİM","STOK",1000,0,407,"EÇ"]
["46","701-1210",7963188,422,"HAZİRAN","2012-06-05","YÜZEY PROBLEMİ","MOBİLYA","ÜRETİM","STOK",710,0,422,"EÇ"]
["47","671-1290",7941179,288,"MART","2012-03-29","RENK","MOBİLYA","BELİRSİZ ","STOK",725,0,288,"NÜ"]
["48","621-1100",7941406,364,"NİSAN","2012-04-12","VİSKOZİTE","MOBİLYA","BELİRSİZ ","DEĞERLENDİRİLDİ ",300,300,64,"NÜ"]
["49","591-7665",7931140,475,"NİSAN","2012-04-12","RENK","SANAYİ","ARGE","DEĞERLENDİRİLDİ ",468,468,7,"ÖŞ"]
["50","251-1703",7943042,258,"NİSAN","2012-04-09","RENK","SANAYİ","BELİRSİZ ","DEĞERLENDİRİLDİ ",120,120,138,"AÖ"]
["51","119-7416",7966815,403,"HAZİRAN","2012-06-15","FORMÜL","SANAYİ","ARGE","DEĞERLENDİRİLDİ ",356,356,47,"DD"]
["52","520-8747",7942466,277,"NİSAN","2012-04-03","JELLEŞME","SANAYİ","ÜRETİM","STOK",340,0,277,"AS"]
["53","317-2298",7965005,498,"HAZİRAN","2012-06-11","YAPIŞMA","SANAYİ","ARGE","DEĞERLENDİRİLDİ ",null,710,-212,"AÖ"]
["54","323-0282",7973232,428,"HAZİRAN","2012-06-18","VİSKOZİTE","MOBİLYA","ÜRETİM","STOK",null,0,428,"EÇ"]
["55","593-9420",7973307,260,"TEMMUZ","2012-07-20","VİSKOZİTE","SANAYİ","ARGE","STOK",null,0,260,"ÖŞ"]
["56","114-7676",7970539,298,"TEMMUZ","2012-07-20","YÜZME","SANAYİ","BELİRSİZ ","STOK",null,0,298,"OZ"]
["57","507-9249",7972414,375,"TEMMUZ","2012-07-23","YÜZEY PROBLEMİ","SANAYİ","ÜRETİM","DEĞERLENDİRİLDİ ",null,324,51,"AS"]
["58","311-1436",7989446,322,"AĞUSTOS","2012-08-17","YÜZEY PROBLEMİ","MOBİLYA","ÜRETİM","DEĞERLENDİRİLDİ ",null,920,580,"EÇ"]
["59","M31-1001",7986998,336,"AĞUSTOS","2012-08-22","KURUMA","MOBİLYA","BELİRSİZ ","STOK",null,0,305,"NÜ"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L2:L60)","v":46059}]

{"sheet":"OzetTablo","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["AY","(All)"]
[]
["Sum of MİKTARI (KG)","SEKTÖR"]
["REDDEDİLME SEBEBİ","COIL","DENİZ","MOBİLYA","OTB","SANAYİ","SENTETİK","Grand Total"]
["ATIL DEĞERLENDİRME",null,null,null,null,308,null,308]
["EFEKT ",null,null,null,null,965,null,965]
["FORMÜL",null,null,null,309,3901,null,4210]
["HAMMADDE",3750,null,null,null,null,null,3750]
["HATALI HAMMADDE ETİKETLEME ",5038,null,null,null,638,null,5676]
["JELLEŞME",null,null,null,null,340,null,340]
["KURUMA",null,null,305,null,null,2750,3055]
["PARLAKLIK",null,null,null,null,582,null,582]
["RENK",null,900,15351,306,15293,null,31850]
["VİSKOZİTE",null,null,5750,null,2623,null,8373]
["YAPIŞMA",null,null,null,null,1185,null,1185]
["YÜZEY PROBLEMİ",null,null,2210,null,1535,null,3745]
["YÜZME",null,null,null,null,1847,null,1847]
["Grand Total",8788,900,23616,615,29217,2750,65886]

{"sheet":"Sheet5","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of DEĞERLENDİRİLEN-İMHA OLAN MİKTAR"]
["DEĞERLENDİRİLDİ ",34420]
["İMHA",5177]
["STOK",6462]
["Grand Total",46059]

{"sheet":"Sheet2","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Sum of MİKTARI (KG)"]
["ARGE",11409]
["BELİRSİZ ",13250]
["HAMMADDE KAYNAKLI",305]
["KALİTE",7666]
["LOJİSTİK",5676]
["RENK MİX ARGE ",2204]
["SANAYİ ARGE ",4042]
["ÜRETİM",20941]
["YARIÜRÜN",393]
["Grand Total",65886]

{"sheet":"Sheet1","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Ürünler","Miktarlar","Tutar"]
["Lily",982120,12300000,{"$f":"C2/B2","v":12.523927829593125}]
["Senso",650123,9123456,{"$f":"C3/B3","v":14.033430596979342}]
["Primera",580650,8650000,14.897098079738225]
["Select",55140,2456000,44.541167936162495]

{"sheet":"Sheet3","index":6,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["QC Parametre","Ocak","Şubat","Mart"]
["Beyazlık",83.15,84.02,82.08]
["Sarılık",3.3,3.6,2.9]
["Mukavemet",1700,1200,752]
["Yaş Mukavemet",450,505,484]