{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["التحميل","مستودع","شهر3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["رقم المستند","اسم السائق","رقم السياره","العائديه","رقم المستند","جهة التحميل","نوع المنتوج","تاريخ التحميل","تاريخ التفريغ","طبيعي","قياسي مجهز","قياسي مفرغ","نقص","الشركه"]
[1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[385476,"زهير",559099,"اربيل",385476,"كرخ","نفط","2021-03-06","2021-03-07",36000,35749,null,null,"جوهرة"]
[427733,"زهير",559099,"اربيل",427733,"كرخ","بنزين","2021-03-03","2021-03-04",36000,35582,35587,5,"جوهرة"]
[427739,"سلام",17391,"انبار",427739,"كرخ","نفط","2021-03-03","2021-03-04",36000,35604,null,null,"ابداع"]
[436330,"مصطفى",555878,"اربيل",436330,"كرخ","نفط","2021-03-04","2021-03-05",36000,35820,null,null,"ابداع"]
[436411,"طيف",15249,"بغداد ف",436411,"كرخ","نفط","2021-03-04","2021-03-05",36000,35861,null,null,"ابداع"]
[519786,"احمد",558808,"اربيل",519786,"بيجي","كاز","2021-03-05","2021-03-07",36000,35651,null,null,"جوهرة"]
[519856,"محمد",21304,"انبار",519856,"بيجي","كاز","2021-03-06","2021-03-08",42000,41664,null,null,"جوهرة"]
[519875,"احمد",558808,"اربيل",519875,"بيجي","كاز","2021-03-07","2021-03-08",36000,35460,null,null,"جوهرة"]
[1757501,"حسان",31300,"انبار  أ",1757501,"كرخ","بنزين","2021-03-05","2021-03-06",42000,41734,41744,10,"ابداع"]

{"sheet":"مستودع","index":1,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["رقم المستند","اسم السائق","رقم السيارة","المحطة","المنتوج","التاريخ"]
[1746403,"حامد",51383,"الجديدة","بنزين","2021-03-07"]
[1746411,"سليمان",19188,"القديمة","بنزين","2021-03-08"]
[1746307,"سليمان",19188,"الحديثة","بنزين","2021-03-04"]

{"sheet":"شهر3","index":2,"n_rows":11,"n_cols":28,"rows_kept":11,"cut":false,"hidden":false,"merged":[[8,27,12,27]]}
["رقم المستند","عام/خاص",null,"المحور","المنتوج","تاريخ التحميل","رقم السيارة",null,null,null,null,null,null,null,null,null,null,null,null,null,"الحالة","الحالة1","الحالة2","الحالة3"]
[427739,{"$f":"IF($G2=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G2,#REF!,0)),\"عام\"))","v":"عام"},null,"كرخ","نفط","2021-03-03",17391,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F2&\"*\"&G2&\"*\"&D2&\"*\"&E2),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"سلام"}]
[519786,{"$f":"IF($G3=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G3,#REF!,0)),\"عام\"))","v":"عام"},null,"بيجي","كاز","2021-03-05",558808,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F3&\"*\"&G3&\"*\"&D3&\"*\"&E3),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"احمد"}]
[519856,{"$f":"IF($G4=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G4,#REF!,0)),\"عام\"))","v":"عام"},null,"بيجي","كاز","2021-03-06",21304,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F4&\"*\"&G4&\"*\"&D4&\"*\"&E4),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"محمد"}]
[427733,{"$f":"IF($G5=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G5,#REF!,0)),\"عام\"))","v":"عام"},null,"كرخ","بنزين","2021-03-03",559099,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F5&\"*\"&G5&\"*\"&D5&\"*\"&E5),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"زهير"},null,null,null,null,null,null,"عندي معادلة بأربع شروط"]
[436330,{"$f":"IF($G6=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G6,#REF!,0)),\"عام\"))","v":"عام"},null,"كرخ","نفط","2021-03-04",555878,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F6&\"*\"&G6&\"*\"&D6&\"*\"&E6),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"مصطفى"}]
[436411,{"$f":"IF($G7=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G7,#REF!,0)),\"عام\"))","v":"عام"},null,"كرخ","نفط","2021-03-04",15249,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F7&\"*\"&G7&\"*\"&D7&\"*\"&E7),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"طيف"}]
[1757501,{"$f":"IF($G8=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G8,#REF!,0)),\"عام\"))","v":"عام"},null,"كرخ","بنزين","2021-03-05",31300,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F8&\"*\"&G8&\"*\"&D8&\"*\"&E8),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":"حسان"}]
[1746403,{"$f":"IF($G9=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G9,#REF!,0)),\"عام\"))","v":"عام"},null,"مستودع","بنزين","2021-03-07",51383,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F9&\"*\"&G9&\"*\"&D9&\"*\"&E9),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,"محتاج معادلة تبحث في شيتين في حالة عدم وجود الطلب في شيت التحميل يذهب ويبحث في شيت مستودع ويظهر الاسم"]
[1746411,{"$f":"IF($G10=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G10,#REF!,0)),\"عام\"))","v":"عام"},null,"مستودع","بنزين","2021-03-08",19188,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F10&\"*\"&G10&\"*\"&D10&\"*\"&E10),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":{"$error":"#N/A"}}]
[1746307,{"$f":"IF($G11=\"\",\"\",IFERROR(INDEX(#REF!,MATCH($G11,#REF!,0)),\"عام\"))","v":"عام"},null,"مستودع","بنزين","2021-03-04",19188,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(التحميل!$B$2:$B$9224,MATCH((F11&\"*\"&G11&\"*\"&D11&\"*\"&E11),التحميل!$H$2:$H$9224&\"*\"&التحميل!$C$2:$C$9224&\"*\"&التحميل!$F$2:$F$9224&\"*\"&التحميل!$G$2:$G$9224,0))","v":{"$error":"#N/A"}}]