{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Form","Full_Report","Main","1","2","3","4","5"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":"Form","index":0,"n_rows":213,"n_cols":32,"rows_kept":213,"cut":false,"hidden":true,"merged":[[11,15,11,17],[0,29,0,31],[18,1,18,6],[1,12,2,14],[2,16,3,16],[14,14,15,15],[9,11,9,12],[10,11,10,12],[11,11,11,12],[12,11,12,12],[122,16,122,17],[127,9,128,10],[111,12,112,14],[112,16,113,16],[119,11,119,12],[120,9,120,11],[120,16,120,17],[73,15,73,16],[15,9,15,10],[64,15,64,17],[182,9,183,10],[166,12,167,14],[167,16,168,16],[64,11,64,12],[66,11,66,12],[66,15,66,17],[67,11,67,12],[69,14,70,15],[106,10,106,11],[51,10,51,11],[121,11,121,12],[121,15,121,17],[122,11,122,12],[71,9,71,10],[70,11,70,12],[71,11,71,12],[69,9,69,10],[17,10,17,13],[18,10,18,13],[61,9,61,12],[62,9,62,12],[56,12,57,14],[69,16,69,17],[70,16,70,17],[14,9,14,10],[15,11,15,12],[70,9,70,10],[17,15,17,16],[18,15,18,16],[57,16,58,16],[106,14,106,15],[5,9,5,12],[6,9,6,12],[7,9,7,12],[60,9,60,12],[9,15,9,17],[10,15,10,17],[12,15,12,17],[14,16,14,17],[15,16,15,17],[74,15,74,16],[74,10,74,13],[73,10,73,13],[65,11,65,12],[67,15,67,17],[65,15,65,17]]}
[null,null,null,"Commercial Invoice",null,null,"[ORIGINAL]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Draft/Bill Of Exchange",null,null,null,null,null,"ملا حظات يجب مراعاتها عند مراجعة فاتورة الاعتماد البنكي"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Commercial Invoice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"قيمة الفاتورة الصافيه هي التي سيتم تحويلها من البنك الى حساب المستفيد"]
[null,"Bank:","SABB","Invoice No:",1651,"Invoice Date:",43466,null,null,null,null,null,null,null,null,null,"Original",null,null,null,null,"Drawn Under",null,null,null,null,null,null,null,2,"اي يتم خصم الدفعات المقدمة وحجز الاختبارات من فاتورة الاعتماد البنكي قبل التوقيع عليها"]
[null,"LC#",12345678910,"LC Dated:",43466,"LC Expiry Date:",43466,null,null,"Bill to / Applicant",null,null,null,null,null,null,null,null,null,null,null,"DC NO:",{"$f":"C4","v":12345678910},null,null,null,null,null,null,3,"مراجعة رقم الاعتماد البنكي","Documentary Credit Number"]
["To"," Al Arrab Contracting Co. Ltd.",null,null,null,"Delivery Note No:",{"$f":"E48","v":11651},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dated",{"$f":"E49","v":43466},null,null,null,null,null,null,4,"مراجعة تاريخ انتهاء صلاحية الاعتماد البنكي","Expiry Date"]
[null,"Riyadh 11633, P.O. Box 91313, KSA.",null,null,"Payment Terms:","60 Days from the Date Of \" Invoice \"",null,null,null,"M/S : Al Arrab Contracting Co. Ltd.",null,null,null,null,null,null,"Invoice #",1,null,null,null,"Issued By",null,null,null,null,null,null,null,5,"مراجعة اسم مقدم طلب فتح الاعتماد البنكي","Applicant"]
[null,"Tel:+966112109480  Fax:+966112107939",null,null,null,null,null,null,null,"P.O.Box 91313, Riyadh 11633,KSA.",null,null,null,null,null,null,"Invoice date","2020-03-03",null,null,null,null,null,null,null,null,null,null,null,6,"مراجعة اسم المستفيد","Beneficiary"]
[null,null,null,null,null,null,null,null,null,"Tel: 011-210-9480 / Fax: 011-210-7939",null,null,null,null,null,null,null,null,null,null,null,"Our Bank Account No:",null,null,null,null,null,null,null,7,"مراجعة قيمة الاعتماد البنكي المفتوح"]
[null,"Sr.","Description Of Goods And/or Services","Unit","Unit Price","Quantity","Amount (SAR)",null,null,null,null,null,null,null,null,"Beneficiary Advising bank's reference.",null,null,null,null,null,"IBAN:",null,null,null,null,null,null,null,8,"مراجعة موعد استحقاق الفاتورة","30 Days After Shipment Date"]
[null,1,null,null,5,5,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":25},null,null,"Drawn Under LC #",null,"DIBWPM299370",null,null,"Bank/Branch","Bank Al-Jazira",null,null,null,null,null,"Exchange of amount",{"$f":"TableForm[[#Totals],[Amount (SAR)]]","v":607.5},null,null,null,null,null,null,9,"مراجعة طريقة الشحن","Partial Shipments Are Allowed /Or Not"]
[null,2,null,null,null,null,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":0},null,null,"LC issuing bank's Name:",null,"SABB",null,null,"A/C#"," 012-8950-0826-3001",null,null,null,null,null,"Riyadh",null,null,null,null,null,null,null,10,"مراجعة مكان التسليم للبضاعة","Project Site"]
[null,3,null,null,5,115,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":575},null,null,"LC issuing date:",null,"2020-02-20",null,null,"IBAN#","SA32-6010-0012-8950-0826-3001",null,null,null,null,null,"Date:",{"$f":"G3","v":43466},"Pay This Sole Bill Of Exchange",null,null,null,null,null,11,"مراجعة وصف البضاعة","Description Of Goods / Cables"]
[null,4,null,null,null,null,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":0},null,null,"LC expiry date:",null,"2020-08-19",null,null,"SWIFT CODE#","BJAZSAJE",null,null,null,null,null,null,null,null,null,null,null,null,null,12,"مراجعة المستندات التي يجب ان توقع (عدد الفواتير + عدد سندات الاستلام )","Documents Required Signed"]
[null,5,null,null,null,null,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At Sight",null,null,null,null,null,null,null,13,"مراجعة اسماء الذين يحق لهم التوقيع على الفواتير والاستلامات","Applicant's Authorized"]
[null,6,null,null,null,null,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":0},null,null,"Drafts at:",null,"30 Days from Invoice date",null,null,"Payment Terms:",null,"Payment after 30 days",null,null,null,null,null,null,null,null,null,null,null,null,14,"مراجعة تحميل مصروفات فتح الاعتماد"]
[null,7,null,null,5,1.5,{"$f":"TableForm[[#This Row],[Unit Price]]*TableForm[[#This Row],[Quantity]]","v":7.5},null,null,"Delivery Date:",null,"2020-03-03",null,null,null,null,"from the Invoice Date",null,null,null,null,"To Order Of"]
[null,"Total",null,null,null,null,{"$f":"SUBTOTAL(109,TableForm[Amount (SAR)])","v":607.5}]
[null,"Amount In Words",null,null,null,null,null,null,null,"Ser. #","Description of Goods and/or Services",null,null,null,"Qty","Unit",null,"Total Amount\nSAR",null,null,null,"Ourselves"]
[null,null,null,null,null,null,null,null,null,1,"Subcontract Works",null,null,null,1,"Lump sum",null,232873.36]
[null,null,null,null,null,null,null,null,null,"Two Hundred Thirty Two Thousand Eight Hundred Seventy Three Riyals and Thirty Six Halalas",null,null,null,null,null,null,null,{"$f":"R19","v":232873.36},null,null,null,"The Sum Of SAR",{"$f":"B19","v":0}]
[null,"CPT Applicant's Project Site, KSA,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value Received Against "]
[null,"Supply And Installation Of MEP Works",null,null,null,null,null,null,null,"The Undersigned certify",null,null,null,"Confirming that subcontracting works have been"]
[null,null,null,null,null,null,null,null,null,"The invoice true & correct",null,null,null,"Completed Successfully."]
[null,"We Hereby Certify The Contents To Be True And Correct.",null,null,null,null,null,null,null,"Beneficiary authorized Signatory",null,null,null,"Countersigned by applicant's Representatives for"]
[null,"Dispatch From Beneficiary Warehouse.",null,null,null,null,null,null,null,null,null,null,null,"Al Arrab Contracting Co. Ltd."]
[]
[null,"Beneficiary:",null,null,"Applicant:",null,null,null,null,null,null,null,null,"Group  \"A\""]
[null,null,null,null,{"$f":"B5","v":" Al Arrab Contracting Co. Ltd."},null,null,null,null,null,null,null,null,"Mr. Marc Cordahi"]
[null,null,null,null,{"$f":"B6","v":"Riyadh 11633, P.O. Box 91313, KSA."},null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,{"$f":"B7","v":"Tel:+966112109480  Fax:+966112107939"},null,null,null,null,null,null,null,null,"Mr. Mohammed Sami Alkandelgy "]
[]
[null,"Authorized Signatory",null,null,"Authorized Signatory",null,null,null,null,null,null,null,null,"Group  \"B\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Aqeel Ahmed "]
[null,"Mr.",null,null,"Mr.",null,null,null,null,null,null,null,null,"Or"]
[null,"Date:",null,null,"Date:",null,null,null,null,null,null,null,null,"Mr. Ahmed Elhamy"]
[]
[null,null,null,null,"Mr.",null,null,null,null,null,null,null,null,"Group  \"C\""]
[null,null,null,null,"Date:",null,null,null,null,null,null,null,null,"Mr. Syed Nadeemuddin Ahmed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,"Stamp",null,null,"Stamp",null,null,null,null,null,null,null,null,"Mr. Aneesh Paul"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Prashant Purushothaman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Ahmed Hussain Abou Shebeka"]
[]
[null,null,null,"Delivery Note",null,null,{"$f":"G1","v":"[ORIGINAL]"}]
[]
[null,"Bank:",{"$f":"C3","v":"SABB"},"Delivery Note No:",11651,"Delivery Note Date:",{"$f":"G3","v":43466},null,null,"Stamp",null,null,null,"Stamp"]
[null,"LC#",{"$f":"C4","v":12345678910},"LC Dated:",{"$f":"E4","v":43466},"LC Expiry Date:",{"$f":"G4","v":43466}]
[null,{"$f":"B5","v":" Al Arrab Contracting Co. Ltd."},null,null,null,"Invoice No:",{"$f":"E3","v":1651}]
[null,{"$f":"B6","v":"Riyadh 11633, P.O. Box 91313, KSA."},null,null,"Payment Terms:",{"$f":"F6","v":"60 Days from the Date Of \" Invoice \""}]
[null,{"$f":"B7","v":"Tel:+966112109480  Fax:+966112107939"},null,null,null,null,null,null,null,"Date:",null,null,null,"Date:"]
[]
[null,"Sr.","Description Of Goods And/or Services","Unit","Quantity"]
[null,{"$f":"$B10","v":1},{"$f":"$C10","v":0},{"$f":"$D10","v":0},{"$f":"$F10","v":5}]
[null,2,0,0,0]
[null,3,0,0,115,null,null,null,null,null,null,null,"Work Completion"]
[null,4,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q3","v":"Original"}]
[null,5,0,0,0,null,null,null,null,"Bill to / Applicant"]
[null,6,0,0,0]
[null,7,0,0,1.5,null,null,null,null,"M/S : Al Arrab Contracting Co. Ltd.",null,null,null,null,null,"Work Completion #",null,1]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Table46[Quantity])","v":121.5},null,null,null,null,"P.O.Box 91313, Riyadh 11633,KSA.",null,null,null,null,null,"Work Completion Date",null,"2020-03-03"]
[null,null,null,null,null,null,null,null,null,"Tel: 011-210-9480 / Fax: 011-210-7939"]
[null,{"$f":"B21","v":"CPT Applicant's Project Site, KSA,"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Beneficiary Advising bank's reference."]
[null,{"$f":"B22","v":"Supply And Installation Of MEP Works"},null,null,null,null,null,null,null,"Drawn Under LC #",null,"DIBWPM299370",null,null,"Bank/Branch","Bank Al-Jazira"]
[null,null,null,null,null,null,null,null,null,"LC issuing bank's Name:",null,"SABB",null,null,"A/C#"," 012-8950-0826-3001"]
[null,null,null,null,null,null,null,null,null,"LC issuing date:",null,"2020-02-20",null,null,"IBAN#","SA32-6010-0012-8950-0826-3001"]
[null,"We Hereby Certify The Contents To Be True And Correct.",null,null,"Evidencing Of Delivery On:",null,{"$f":"G3","v":43466},null,null,"LC expiry date:",null,"2020-08-19",null,null,"SWIFT CODE#","BJAZSAJE"]
[null,{"$f":"B25","v":"Dispatch From Beneficiary Warehouse."},null,null,"At Applicant's Site In Good Order And Condition."]
[null,null,null,null,null,null,null,null,null,"Drafts at:",null,"30 Days from Invoice date",null,null,"Payment Terms:",null,"Payment after 30 days"]
[null,null,null,null,null,null,null,null,null,"Invoice #",null,1,null,null,null,null,"from the Invoice Date"]
[null,"Beneficiary:",null,null,"Applicant:",null,null,null,null,"Invoice date",null,"2020-03-03"]
[null,{"$f":"B28","v":0},null,null,{"$f":"B5","v":" Al Arrab Contracting Co. Ltd."}]
[null,{"$f":"B29","v":0},null,null,{"$f":"B6","v":"Riyadh 11633, P.O. Box 91313, KSA."},null,null,null,null,"Ser. #","Description of Goods and/or Services",null,null,null,"Qty","Unit"]
[null,{"$f":"B30","v":0},null,null,{"$f":"B7","v":"Tel:+966112109480  Fax:+966112107939"},null,null,null,null,1,"Subcontract Works",null,null,null,1,"Lump sum"]
[]
[null,"Authorized Signatory",null,null,"Authorized Signatory",null,null,null,null,"The Undersigned certify",null,null,null,"Confirming that subcontracting works have been"]
[null,null,null,null,null,null,null,null,null,"The invoice true & correct",null,null,null,"Completed Successfully."]
[null,"Mr.",{"$f":"C34","v":0},null,"Mr.",null,null,null,null,"Beneficiary authorized Signatory",null,null,null,"Countersigned by applicant's Representatives for"]
[null,"Date:",{"$f":"C35","v":0},null,"Date:",null,null,null,null,null,null,null,null,"Al Arrab Contracting Co. Ltd."]
[]
[null,null,null,null,"Mr.",null,null,null,null,null,null,null,null,"Group  \"A\""]
[null,null,null,null,"Date:",null,null,null,null,null,null,null,null,"Mr. Marc Cordahi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,"Stamp",null,null,"Stamp",null,null,null,null,null,null,null,null,"Mr. Mohammed Sami Alkandelgy "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Group  \"B\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Aqeel Ahmed "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Ahmed Elhamy"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Group  \"C\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Syed Nadeemuddin Ahmed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Aneesh Paul"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Prashant Purushothaman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Or"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. Ahmed Hussain Abou Shebeka"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Stamp",null,null,null,"Stamp"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Date:",null,null,null,"Date:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Commercial Invoice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original"]
[null,null,null,null,null,null,null,null,null,"Bill to / Applicant"]
[]
[null,null,null,null,null,null,null,null,null,"M/S : Al -Arrab Contracting Co. Ltd.",null,null,null,null,null,null,"Invoice #",1]
[null,null,null,null,null,null,null,null,null,"P.O.Box 91313, Riyadh 11633,KSA.",null,null,null,null,null,null,"Invoice date","2020-03-03"]
[null,null,null,null,null,null,null,null,null,"Tel:+966-11-2109480 - Fax:+966-11-2107939"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beneficiary Advising bank's reference."]
[null,null,null,null,null,null,null,null,null,"Drawn Under LC #",null,"DIBWPM299370",null,null,"Bank/Branch","Bank Al-Jazira/Khaled Ibn El Waleed,Jeddah"]
[null,null,null,null,null,null,null,null,null,"LC issuing bank's Name:",null,null,"SABB",null,"A/C#",null," 012-8950-0826-3001"]
[null,null,null,null,null,null,null,null,null,"LC issuing date:",null,"2020-02-20",null,null,"IBAN#","SA32-6010-0012-8950-0826-3001"]
[null,null,null,null,null,null,null,null,null,"LC expiry date:",null,"2020-08-19",null,null,"SWIFT CODE#",null,"BJAZSAJE"]
[]
[null,null,null,null,null,null,null,null,null,"Delivery to:",null,"Dispatch from:",null,null,null,"Description of goods and/or services"]
[null,null,null,null,null,null,null,null,null,"Drafts at:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery terms: applicant's \"CPT\""]
[null,null,null,null,null,null,null,null,null,"Payment Terms:",null,"Payment after 30 days",null,null,null,"warehouse in          or site in         "]
[null,null,null,null,null,null,null,null,null,null,null,"from the Invoice Date",null,null,null,"PO#",null,"date:   /    /"]
[]
[null,null,null,null,null,null,null,null,null,"Ser. #","Description of Goods and/or Services",null,null,null,"Qty","Unit","Unit price\nSAR","Total Amount\nSAR"]
[null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"O132*Q132","v":0}]
[null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"O133*Q133","v":0}]
[null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,"-----------Nothing follows-----------",null,null,null,{"$f":"SUM(O132:O143)","v":0},null,null,{"$f":"SUM(R132:R143)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Less Advance",null,{"$f":"R144*-O145","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,"Add VAT",null,{"$f":"(R144+R145)*O146","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"Less Retention",null,{"$f":"R144*-O147","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R144:R147)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"The Undersigned certify",null,null,null,"Confirming Receipt of goods in good order and condition"]
[null,null,null,null,null,null,null,null,null,"The invoice true & correct",null,null,null,"Countersigned by applicant's Representatives for"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Al -Arrab Contracting Co. Ltd."]
[null,null,null,null,null,null,null,null,null,"Beneficiary authorized Signatory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. "]
[]
[null,null,null,null,null,null,null,null,null,"Stamp",null,null,null,"and / or",null,"Stamp"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Work Completion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q113","v":"Original"}]
[null,null,null,null,null,null,null,null,null,"Bill to / Applicant"]
[]
[null,null,null,null,null,null,null,null,null,"M/S : Al -Arrab Contracting Co. Ltd.",null,null,null,null,null,null,"Delivery Note #"]
[null,null,null,null,null,null,null,null,null,"P.O.Box 91313, Riyadh 11633,KSA.",null,null,null,null,null,null,"Delivery Note date"]
[null,null,null,null,null,null,null,null,null,"Tel:0112109525/0112107556-Fax:0112109531"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beneficiary Advising bank's reference."]
[null,null,null,null,null,null,null,null,null,"Drawn Under LC #",null,null,null,null,null,"Bank/Branch"]
[null,null,null,null,null,null,null,null,null,"LC issuing bank's Name:",null,null,null,null,null,"A/C#"]
[null,null,null,null,null,null,null,null,null,"LC issuing date:",null,null,null,null,null,"IBAN#"]
[null,null,null,null,null,null,null,null,null,"LC expiry date:",null,null,null,null,null,"SWIFT CODE#"]
[]
[null,null,null,null,null,null,null,null,null,"Delivery to:",null,"Dispatch from:",null,null,null,"Description of goods and/or services"]
[null,null,null,null,null,null,null,null,null,"Drafts at:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivery terms: applicant's \"CPT\""]
[null,null,null,null,null,null,null,null,null,"Payment Terms:",null,null,null,null,null,"warehouse in          or site in         "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PO#",null,"date:   /    /"]
[]
[null,null,null,null,null,null,null,null,null,"ser. #","Description of Goods and/or Services",null,null,null,"Qty","Unit"]
[null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,"-----------Nothing follows-----------",null,null,null,{"$f":"SUM(O187:O198)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"The Undersigned certify",null,null,null,"Confirming Receipt of goods in good order and condition"]
[null,null,null,null,null,null,null,null,null,"The invoice true & correct",null,null,null,"Countersigned by applicant's Representatives"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Al -Arrab Contracting Co. Ltd."]
[null,null,null,null,null,null,null,null,null,"Beneficiary authorized Signatory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. "]
[]
[null,null,null,null,null,null,null,null,null,"Stamp",null,null,null,"and / or",null,"Stamp"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr. "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Date:",null,null,null,null,null,null,"Date:"]

{"sheet":"Full_Report","index":1,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"AL Salam Contracting Co. ltd.",null,"SCC - Amaer Project","SABB","Bank","Project code","HART","P.O. Box",12345,"  CR#سجل تجاري",1234567890,"C.C.# رقم العضويـة","Tel:","011-1234567","010-1234569"]
[null,"شركة السلام للمقاولات المحدودة",null," مشروع العمائر","12345678912345678912345","I Ban","Cost code",1234,"Postal Code",67890,"VAT#ض. قيمة مضافة","123456789101112",12345,"Fax:","011-1234568","010-1234570"]
[null,"Sr","Vendor","System","المورد","Vendor Type","LC invoices Value","LC invoices Date","LC Value","LC Balance","Date OF Issue","LC Expiry Date","DC NO:","Bank","Status","Facility from"]
[null,1,"Abs Factory","165646"," مصنع ابس","Supplier",875941.46,"2019-07-27",1905502.52,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":1029561.06},"2019-02-28","2019-08-28","LC5481349721","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"CLOSED"},"A/C No.900"]
[null,1,"Abs Factory","165646"," مصنع ابس","Supplier",716625.64,"2020-05-08",1434615.84,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":717990.20000000007},"2019-12-08","2020-06-08","LC5481349721","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"OPEN"},"A/C No.900"]
[null,2,"International Services","154783","شركة للخدمات العالمية","Subcontractor",0,"2018-07-21",4000000,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":4000000},"2018-06-24","2018-08-21",{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M5)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M5)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC1452479645"},"BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"CLOSED"},"A/C No.900"]
[null,2,"International Services","154783","شركة للخدمات العالمية","Subcontractor",4391605.1370000001,"2018-05-10",5000000,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":608394.8629999999},"2017-12-17","2018-06-10",{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M6)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M6)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC4578542136"},"BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"CLOSED"},"A/C No.900"]
[null,3,"Electromechanical","945873","الكتروميكال","Subcontractor",33386651.949999999,"2019-09-08",53267805.950000003,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":19881154.000000004},"2018-10-08","2019-10-08","LC1452479645","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"CLOSED"},"A/C No.900"]
[null,3,"Electromechanical","945873","الكتروميكال","Subcontractor",9707670.5099999998,"2020-04-26",21000000,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":11292329.49},"2019-11-28","2020-05-26","LC1452479645","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"OPEN"},"A/C No.900"]
[null,4,"Technical Works Co","854693","شركة الفني  للصناعات","Supplier",532619.37,"2018-10-01",1185796.1299999999,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":653176.75999999989},"2018-05-01","2018-11-01","LC4578542136","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"CLOSED"},"A/C No.900"]
[null,4,"Technical Works Co","854693","شركة الفني  للصناعات","Supplier",596264.09,"2020-04-06",629573.35,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":33309.260000000009},"2020-02-11","2020-05-06","LC4578542136","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"OPEN"},"A/C No.900"]
[null,5,"P&L Co.","458216","شركة بي & ال","Subcontractor",1716731.4,"2019-08-02",2865900,{"$f":"TableFull_Report[[#This Row],[LC Value]]-TableFull_Report[[#This Row],[LC invoices Value]]","v":1149168.6000000001},"2018-09-25","2019-09-02","LC1234567890","BBC",{"$f":"IF(TableFull_Report[[#This Row],[LC Expiry Date]]<TODAY(),\"CLOSED\",\"OPEN\")","v":"CLOSED"},"A/C No.900"]
[null,"Total","SCC -Analysis Report for LC Facilities (Balance Detailed)",{"$f":"IF(COUNTBLANK(TableFull_Report[System])>0,SUMPRODUCT(1/COUNTIF(TableFull_Report[System],TableFull_Report[System]&\"\"))-1,SUMPRODUCT(1/COUNTIF(TableFull_Report[System],TableFull_Report[System]&\"\")))","v":5},null,null,{"$f":"SUBTOTAL(109,TableFull_Report[LC invoices Value])","v":51924109.556999996},null,{"$f":"SUBTOTAL(109,TableFull_Report[LC Value])","v":91289193.789999992},{"$f":"SUBTOTAL(109,TableFull_Report[LC Balance])","v":39365084.233000003},null,null,{"$f":"IF(COUNTBLANK(TableFull_Report[DC NO:])>0,SUMPRODUCT(1/COUNTIF(TableFull_Report[DC NO:],TableFull_Report[DC NO:]&\"\"))-1,SUMPRODUCT(1/COUNTIF(TableFull_Report[DC NO:],TableFull_Report[DC NO:]&\"\")))","v":4}]
[]
[null,null,null,"FIND"]
[null,"Sr","Vendor","System","المورد"]
[null,{"$f":"HYPERLINK(CONCATENATE(\"#\",DGET(TableFull_Report[#All],B16,D16:D17),\"!A1\"),DGET(TableFull_Report[#All],B16,D16:D17))","v":{"$error":"#VALUE!"}},{"$f":"DGET(TableFull_Report[#All],C16,D16:D17)","v":{"$error":"#VALUE!"}},104259,{"$f":"DGET(TableFull_Report[#All],E16,D16:D17)","v":{"$error":"#VALUE!"}}]

{"sheet":"Main","index":2,"n_rows":16,"n_cols":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"AL Salam Contracting Co. ltd.",null,"SCC - Amaer Project","SABB","Bank","Project code","HART","P.O. Box",12345,"  CR#سجل تجاري",1234567890,"C.C.# رقم العضويـة","Tel:","011-1234567","010-1234569"]
[null,"شركة السلام للمقاولات المحدودة",null," مشروع العمائر","12345678912345678912345","I Ban","Cost code",1234,"Postal Code",67890,"VAT#ض. قيمة مضافة","123456789101112",12345,"Fax:","011-1234568","010-1234570"]
[null,"Sr","Vendor","System","المورد","Vendor Type","LC invoices Value","LC invoices Date","LC Value","LC Balance","Date OF Issue","LC Expiry Date","DC NO:","Bank","Sign\nBy","Facility from","empty"]
[null,{"$f":"HYPERLINK(CONCATENATE(\"#\",ROW(B3)-3+1,\"!A1\"),ROW(B3)-3+1)","v":1},{"$f":"IFERROR(PROPER(INDIRECT(CONCATENATE(\"'\",ROW($C3)-3+1,\"'!\",\"D3\"))),\"\")","v":"Abs Factory"},{"$f":"IFERROR(PROPER(INDIRECT(CONCATENATE(\"'\",ROW($D3)-3+1,\"'!\",\"D2\"))),\"\")","v":"165646"},{"$f":"IFERROR(PROPER(INDIRECT(CONCATENATE(\"'\",ROW($E3)-3+1,\"'!\",\"D4\"))),\"\")","v":" مصنع ابس"},{"$f":"IFERROR(PROPER(INDIRECT(CONCATENATE(\"'\",ROW($F3)-3+1,\"'!\",\"D6\"))),\"\")","v":"Supplier"},{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(G3)-3+1+10000,\"[LC Invoices Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(G3)-3+1+10000,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":716625.64},{"$f":"IFERROR(MAX(INDIRECT(CONCATENATE(\"Table\",ROW(H3)-3+1+10000,\"[LC invoices Date]\"))),\"\")","v":"2020-02-08"},{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(I3)-3+1,\"[LC Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(I3)-3+1,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":1434615.84},{"$f":"+TableMain[[#This Row],[LC Value]]-TableMain[[#This Row],[LC invoices Value]]","v":717990.20000000007},{"$f":"IFERROR(MAX(INDIRECT(CONCATENATE(\"Table\",ROW(K3)-3+1,\"[Date OF Issue]\"))),\"\")","v":"2020-03-09"},{"$f":"IFERROR(MAX(INDIRECT(CONCATENATE(\"Table\",ROW(L3)-3+1,\"[LC Expiry Date]\"))),\"\")","v":"2020-06-08"},{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M3)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M3)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC5481349721"},{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(N3)-3+1,\"[Bank]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(N3)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"BBC"},"Project",{"$f":"IFERROR(PROPER(INDIRECT(CONCATENATE(\"'\",ROW($F3)-3+1,\"'!\",\"G21\"))),\"\")","v":"A/C No.900"}]
[null,2,"International Services","154783","شركة للخدمات العالمية","Subcontractor",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(G4)-3+1+10000,\"[LC Invoices Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(G4)-3+1+10000,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":0},"2018-02-12",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(I4)-3+1,\"[LC Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(I4)-3+1,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":4000000},{"$f":"+TableMain[[#This Row],[LC Value]]-TableMain[[#This Row],[LC invoices Value]]","v":4000000},"2018-06-24","2018-08-21",{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M4)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M4)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC9543157824"},{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(N4)-3+1,\"[Bank]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(N4)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"BBC"},"HO","A/C No.900"]
[null,3,"Electromechanical","945873","الكتروميكال","Subcontractor",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(G5)-3+1+10000,\"[LC Invoices Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(G5)-3+1+10000,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":9707670.5099999998},"2020-02-17",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(I5)-3+1,\"[LC Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(I5)-3+1,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":21000000},{"$f":"+TableMain[[#This Row],[LC Value]]-TableMain[[#This Row],[LC invoices Value]]","v":11292329.49},"2019-11-28","2020-05-26",{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M5)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M5)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC1452479645"},{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(N5)-3+1,\"[Bank]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(N5)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"BBC"},"Project","A/C No.900"]
[null,4,"Technical Works Co","854693","شركة الفني  للصناعات","Supplier",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(G6)-3+1+10000,\"[LC Invoices Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(G6)-3+1+10000,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":596264.09},"2020-02-16",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(I6)-3+1,\"[LC Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(I6)-3+1,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":629573.35},{"$f":"+TableMain[[#This Row],[LC Value]]-TableMain[[#This Row],[LC invoices Value]]","v":33309.260000000009},"2020-02-11","2020-05-06",{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M6)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M6)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC4578542136"},{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(N6)-3+1,\"[Bank]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(N6)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"BBC"},"HO","A/C No.900"]
[null,5,"P&L Co.","458216","شركة بي & ال","Subcontractor",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(G7)-3+1+10000,\"[LC Invoices Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(G7)-3+1+10000,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":1716731.4000000001},"2019-07-22",{"$f":"SUMIFS(INDIRECT(CONCATENATE(\"Table\",ROW(I7)-3+1,\"[LC Value]\")),INDIRECT(CONCATENATE(\"Table\",ROW(I7)-3+1,\"[DC NO:]\")),TableMain[[#This Row],[DC NO:]])","v":2865900},{"$f":"+TableMain[[#This Row],[LC Value]]-TableMain[[#This Row],[LC invoices Value]]","v":1149168.5999999999},"2019-06-03","2019-09-02",{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(M7)-3+1,\"[DC NO:]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(M7)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"LC1234567890"},{"$f":"IFERROR(INDEX(INDIRECT(CONCATENATE(\"Table\",ROW(N7)-3+1,\"[Bank]\")),MATCH(TableMain[[#This Row],[LC Expiry Date]],INDIRECT(CONCATENATE(\"Table\",ROW(N7)-3+1,\"[LC Expiry Date]\")),0),1),\"\")","v":"BBC"},"HO","A/C No.900"]
[null,"Total","SCC-LC-Balance Analysis Report ","Total","LC - Vendors",{"$f":"IF(COUNTBLANK(TableMain[المورد])>0,SUMPRODUCT(1/COUNTIF(TableMain[المورد],TableMain[المورد]&\"\"))-1,SUMPRODUCT(1/COUNTIF(TableMain[المورد],TableMain[المورد]&\"\")))","v":5},{"$f":"SUBTOTAL(109,TableMain[LC invoices Value])","v":12737291.640000001},null,{"$f":"SUBTOTAL(109,TableMain[LC Value])","v":29930089.190000001},{"$f":"SUBTOTAL(109,TableMain[LC Balance])","v":17192797.550000001}]
[]
[null,null,null,"FIND"]
[null,"Sr","Vendor","System","المورد"]
[null,{"$f":"HYPERLINK(CONCATENATE(\"#\",DGET(TableMain[#All],B12,D12:D13),\"!A1\"),DGET(TableMain[#All],B12,D12:D13))","v":5},{"$f":"DGET(TableMain[#All],C12,D12:D13)","v":"P&L Co."},458216,{"$f":"DGET(TableMain[#All],E12,D12:D13)","v":"شركة بي & ال"}]
[]
[]
[null,null,null," "]

{"sheet":"1","index":3,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,null,null,"H",{"$f":"I2","v":"2020-03-31"}]
[null,"Beneficiary Number:",null,165646,null,null,null,"G",{"$f":"TODAY()","v":"2020-03-31"}]
[null,"Beneficiary Name:",null,"Abs Factory"]
[null,"اسم المستفيد",null," مصنع ابس"]
[null,"Scope",null,"Supply Metals"]
[null,"Vendor Type",null,"Supplier"]
[null,"IBAN",null,"EG123457154896315478216985",null,null,"Swift Code #"]
[null,"Available with/by:",null,"ALARABY"]
[null,"Bank Address"]
["Ser.","Status#","Date OF Issue","LC Expiry Date","DC NO:","Bank","LC Value","Goods","Validity of Credit","Drafts at:","Present Date","Documents Presented Date","Documents Required","EVIDENCING"]
[{"$f":"+ROW()-10","v":1},"Open#1",43524,43613,"LC1245871236","BBC",1205502.52,"CPT/Applicant's Project Site,",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[2,"Extend Date&Value#1",43614,43705,"LC1245871236","BBC",700000,"CPT/Applicant's Project Site,",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[3,"Open#2",43807,43898,"LC5481349721","BBC",1060290.8400000001,"CPT/Applicant's Project Site,",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[4,"Extend Date&Value#2/1",43899,43990,"LC5481349721","BBC",374325,"CPT/Applicant's Project Site,",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[5]
[6]
[7]
[{"$f":"+ROW()-10","v":8}]
[{"$f":"+ROW()-10","v":9}]
[{"$f":"SUBTOTAL(103,Table1[Ser.])","v":9},"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table1[LC Value])","v":3340118.3600000003}]
[null,null,null,null,null,null,"A/C No.900"]
[null,"from","to"]
[null,"Presented with","Validity of Credit","LC Expiry Date after"]
[null,{"$f":"INDEX(Table1[Present Date],MATCH(LOOKUP(2,1/(Table1[Present Date]<>\"\"),Table1[Present Date]),Table1[Present Date],0),1)","v":21},{"$f":"INDEX(Table1[Validity of Credit],MATCH(LOOKUP(2,1/(Table1[Validity of Credit]<>\"\"),Table1[Validity of Credit]),Table1[Validity of Credit],0),1)","v":60},{"$f":"INDEX(Table1[LC Expiry Date],MATCH(LOOKUP(2,1/(Table1[LC Expiry Date]<>\"\"),Table1[LC Expiry Date]),Table1[LC Expiry Date],0),1)-TODAY()","v":69}]
[null,{"$f":"C25-B24","v":"2020-03-18"},{"$f":"INDEX(Table10001[LC invoices Date],MATCH(LOOKUP(2,1/(Table10001[LC invoices Date]<>\"\"),Table10001[LC invoices Date]),Table10001[LC invoices Date],0),1)+C24","v":"2020-04-08"},{"$f":"INDEX(Table1[LC Expiry Date],MATCH(LOOKUP(2,1/(Table1[LC Expiry Date]<>\"\"),Table1[LC Expiry Date]),Table1[LC Expiry Date],0),1)","v":"2020-06-08"}]
["Inv.#","LC invoices Value","LC invoices Date","LC Balance","DC NO:","Available Limit","JARP/Received Date","LC Status","Sent/H.O. ","Received/H.O","Returned/H.O.","Beneficiary/Received","Remarks"]
["ASL-1825",513935.82,43582,{"$f":"IF(E27=0,D26,IF(ISTEXT(D26),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B27,IF(_xlfn.IFNA(MATCH(E27,E26,0)=1,0),D26-B27,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B27)))","v":1391566.7},"LC1245871236",{"$f":"IFERROR(D27/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":0.73028856450948165},"-","Vendor Received","2019-05-13","2019-05-13",null,"2019-05-26"]
["ASL-1842",362005.64,43671,{"$f":"IF(E28=0,D27,IF(ISTEXT(D27),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B28,IF(_xlfn.IFNA(MATCH(E28,E27,0)=1,0),D27-B28,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B28)))","v":1029561.0599999999},"LC1245871236",{"$f":"IFERROR(D28/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":0.54030947175026556},"-","Vendor Received"]
["ASL-1868",120891.14,43816,{"$f":"IF(E29=0,D28,IF(ISTEXT(D28),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B29,IF(_xlfn.IFNA(MATCH(E29,E28,0)=1,0),D28-B29,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B29)))","v":1313724.7000000002},"LC5481349721",{"$f":"IFERROR(D29/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":0.91573274417491457},"2019-12-25","Vendor Received","2019-12-25",null,null,"2019-12-29"]
["ASL-1883",394747.5,43869,{"$f":"IF(E30=0,D29,IF(ISTEXT(D29),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B30,IF(_xlfn.IFNA(MATCH(E30,E29,0)=1,0),D29-B30,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B30)))","v":918977.20000000019},"LC5481349721",{"$f":"IFERROR(D30/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":0.64057371623611803},"2020-02-26","Vendor Received","2020-02-27",null,null,"2020-03-01"]
["ASL-1884",200987,43869,{"$f":"IF(E31=0,D30,IF(ISTEXT(D30),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B31,IF(_xlfn.IFNA(MATCH(E31,E30,0)=1,0),D30-B31,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B31)))","v":717990.20000000019},"LC5481349721",{"$f":"IFERROR(D31/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":0.50047558376324641},"2020-02-26","Vendor Received","2020-03-03",null,null,"2020-03-04"]
[null,null,null,{"$f":"IF(E32=0,D31,IF(ISTEXT(D31),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B32,IF(_xlfn.IFNA(MATCH(E32,E31,0)=1,0),D31-B32,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B32)))","v":717990.20000000019},null,{"$f":"IFERROR(D32/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E33=0,D32,IF(ISTEXT(D32),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B33,IF(_xlfn.IFNA(MATCH(E33,E32,0)=1,0),D32-B33,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B33)))","v":717990.20000000019},null,{"$f":"IFERROR(D33/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E34=0,D33,IF(ISTEXT(D33),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B34,IF(_xlfn.IFNA(MATCH(E34,E33,0)=1,0),D33-B34,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B34)))","v":717990.20000000019},null,{"$f":"IFERROR(D34/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E35=0,D34,IF(ISTEXT(D34),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B35,IF(_xlfn.IFNA(MATCH(E35,E34,0)=1,0),D34-B35,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B35)))","v":717990.20000000019},null,{"$f":"IFERROR(D35/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E36=0,D35,IF(ISTEXT(D35),SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B36,IF(_xlfn.IFNA(MATCH(E36,E35,0)=1,0),D35-B36,SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]]))-B36)))","v":717990.20000000019},null,{"$f":"IFERROR(D36/SUMPRODUCT(Table1[LC Value]*(Table1[DC NO:]=Table10001[[#This Row],[DC NO:]])),\"\")","v":""}]
[{"$f":"SUBTOTAL(103,Table10001[Inv.'#])","v":5},{"$f":"SUBTOTAL(109,Table10001[LC invoices Value])","v":1592567.1},"Total",{"$f":"Table1[[#Totals],[LC Value]]-Table10001[[#Totals],[LC invoices Value]]","v":1747551.2600000002},null,{"$f":"INDEX(Table10001[Available Limit],MATCH(LOOKUP(2,1/(Table10001[Available Limit]<>\"\"),Table10001[Available Limit]),Table10001[Available Limit],0),1)","v":0.50047558376324641}]
[null,{"$f":"+SUMPRODUCT(Table10001[LC invoices Value]*(Table10001[DC NO:]=INDEX(Table10001[DC NO:],MATCH(LOOKUP(2,1/(Table10001[DC NO:]<>\"\"),Table10001[DC NO:]),Table10001[DC NO:],0),1)))","v":716625.64}]

{"sheet":"2","index":4,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[2,null,null,null,null,null,null,"H",{"$f":"I2","v":"2020-03-31"}]
[null,"Beneficiary Number:",null,154783,null,null,null,"G",{"$f":"TODAY()","v":"2020-03-31"}]
[null,"Beneficiary Name:",null,"INTERNATIONAL SERVICES"]
[null,"اسم المستفيد",null,"شركة للخدمات العالمية"]
[null,"Scope",null,"Supply Equipment's"]
[null,"Vendor Type",null,"Subcontractor"]
[null,"IBAN",null,"EG12347854692134567964214",null,null,"Swift Code #"]
[null,"Available with/by:",null,"MONACO BANK"]
[null,"Bank Address"]
["Ser.","Status#","Date OF Issue","LC Expiry Date","DC NO:","Bank","LC Value","Goods","Validity of Credit","Drafts at:","Present Date","Documents Presented Date","Documents Required","EVIDENCING"]
[{"$f":"+ROW()-10","v":1},"Open#1",43275,43333,"LC9543157824","BBC",4000000,"CPT/Applicant's Project Site, ",30,"30 Days from Commercial Invoice",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[2,"Open#1",43086,43169,"LC5478613479","BBC",5000000,"CPT/Applicant's Project Site, ",30,"30 Days from Commercial Invoice",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[3]
[4]
[5]
[6]
[7]
[{"$f":"+ROW()-10","v":8}]
[{"$f":"+ROW()-10","v":9}]
[{"$f":"SUBTOTAL(103,Table2[Ser.])","v":9},"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table2[LC Value])","v":9000000}]
[null,null,null,null,null,null,"A/C No.900"]
[null,"from","to"]
[null,"Presented with","Validity of Credit","LC Expiry Date after"]
[null,{"$f":"INDEX(Table2[Present Date],MATCH(LOOKUP(2,1/(Table2[Present Date]<>\"\"),Table2[Present Date]),Table2[Present Date],0),1)","v":21},{"$f":"INDEX(Table2[Validity of Credit],MATCH(LOOKUP(2,1/(Table2[Validity of Credit]<>\"\"),Table2[Validity of Credit]),Table2[Validity of Credit],0),1)","v":30},{"$f":"INDEX(Table2[LC Expiry Date],MATCH(LOOKUP(2,1/(Table2[LC Expiry Date]<>\"\"),Table2[LC Expiry Date]),Table2[LC Expiry Date],0),1)-TODAY()","v":-752}]
[null,{"$f":"C25-B24","v":"2018-02-21"},{"$f":"INDEX(Table10002[LC invoices Date],MATCH(LOOKUP(2,1/(Table10002[LC invoices Date]<>\"\"),Table10002[LC invoices Date]),Table10002[LC invoices Date],0),1)+C24","v":"2018-03-14"},{"$f":"INDEX(Table2[LC Expiry Date],MATCH(LOOKUP(2,1/(Table2[LC Expiry Date]<>\"\"),Table2[LC Expiry Date]),Table2[LC Expiry Date],0),1)","v":"2018-03-10"}]
["Inv.#","LC invoices Value","LC invoices Date","LC Balance","DC NO:","Available Limit","JARP/ Received Date","LC Status","Sent/H.O. ","Received/H.O","Returned/H.O.","Beneficiary/Received","Remarks"]
[{"$f":"+ROW()-26","v":1},2085472.5,43086,{"$f":"IF(E27=0,D26,IF(ISTEXT(D26),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B27,IF(_xlfn.IFNA(MATCH(E27,E26,0)=1,0),D26-B27,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B27)))","v":2914527.5},"LC5478613479",{"$f":"IFERROR(D27/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":0.58290549999999997},null,"Vendor Received",null,null,null,"2018-01-18"]
[{"$f":"+ROW()-26","v":2},544686.72360000003,43100,{"$f":"IF(E28=0,D27,IF(ISTEXT(D27),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B28,IF(_xlfn.IFNA(MATCH(E28,E27,0)=1,0),D27-B28,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B28)))","v":2369840.7763999999},"LC5478613479",{"$f":"IFERROR(D28/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":0.47396815527999997},null,"Vendor Received",null,null,null,"2018-03-07"]
[3,539392.91340000008,43105,{"$f":"IF(E29=0,D28,IF(ISTEXT(D28),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B29,IF(_xlfn.IFNA(MATCH(E29,E28,0)=1,0),D28-B29,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B29)))","v":1830447.8629999999},"LC5478613479",{"$f":"IFERROR(D29/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":0.36608957259999997},null,"Vendor Received",null,null,null,"2018-04-18"]
[4,222053,43129,{"$f":"IF(E30=0,D29,IF(ISTEXT(D29),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B30,IF(_xlfn.IFNA(MATCH(E30,E29,0)=1,0),D29-B30,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B30)))","v":1608394.8629999999},"LC5478613479",{"$f":"IFERROR(D30/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":0.3216789726},null,"Vendor Received",null,null,null,"2018-04-15"]
[5,1000000,43143,{"$f":"IF(E31=0,D30,IF(ISTEXT(D30),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B31,IF(_xlfn.IFNA(MATCH(E31,E30,0)=1,0),D30-B31,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B31)))","v":608394.8629999999},"LC5478613479",{"$f":"IFERROR(D31/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":0.12167897259999998},null,"Vendor Received",null,null,null,"2018-05-19"]
[null,null,null,{"$f":"IF(E32=0,D31,IF(ISTEXT(D31),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B32,IF(_xlfn.IFNA(MATCH(E32,E31,0)=1,0),D31-B32,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B32)))","v":608394.8629999999},null,{"$f":"IFERROR(D32/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E33=0,D32,IF(ISTEXT(D32),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B33,IF(_xlfn.IFNA(MATCH(E33,E32,0)=1,0),D32-B33,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B33)))","v":608394.8629999999},null,{"$f":"IFERROR(D33/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E34=0,D33,IF(ISTEXT(D33),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B34,IF(_xlfn.IFNA(MATCH(E34,E33,0)=1,0),D33-B34,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B34)))","v":608394.8629999999},null,{"$f":"IFERROR(D34/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E35=0,D34,IF(ISTEXT(D34),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B35,IF(_xlfn.IFNA(MATCH(E35,E34,0)=1,0),D34-B35,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B35)))","v":608394.8629999999},null,{"$f":"IFERROR(D35/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E36=0,D35,IF(ISTEXT(D35),SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B36,IF(_xlfn.IFNA(MATCH(E36,E35,0)=1,0),D35-B36,SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]]))-B36)))","v":608394.8629999999},null,{"$f":"IFERROR(D36/SUMPRODUCT(Table2[LC Value]*(Table2[DC NO:]=Table10002[[#This Row],[DC NO:]])),\"\")","v":""}]
[{"$f":"SUBTOTAL(103,Table10002[Inv.'#])","v":5},{"$f":"SUBTOTAL(109,Table10002[LC invoices Value])","v":4391605.1370000001},"Total",{"$f":"Table2[[#Totals],[LC Value]]-Table10002[[#Totals],[LC invoices Value]]","v":4608394.8629999999},null,{"$f":"INDEX(Table10002[Available Limit],MATCH(LOOKUP(2,1/(Table10002[Available Limit]<>\"\"),Table10002[Available Limit]),Table10002[Available Limit],0),1)","v":0.12167897259999998}]
[null,{"$f":"+SUMPRODUCT(Table10002[LC invoices Value]*(Table10002[DC NO:]=INDEX(Table10002[DC NO:],MATCH(LOOKUP(2,1/(Table10002[DC NO:]<>\"\"),Table10002[DC NO:]),Table10002[DC NO:],0),1)))","v":4391605.1370000001}]

{"sheet":"3","index":5,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[3,null,null,null,null,null,null,"H",{"$f":"I2","v":"2020-03-31"}]
[null,"Beneficiary Number:",null,945873,null,null,null,"G",{"$f":"TODAY()","v":"2020-03-31"}]
[null,"Beneficiary Name:",null,"ELECTROMECHANICAL"]
[null,"اسم المستفيد",null,"الكتروميكال"]
[null,"Scope",null,"MEP Works"]
[null,"Vendor Type",null,"Subcontractor"]
[null,"IBAN",null,"EG6478512345679645210063145",null,null,"Swift Code #"]
[null,"Available with/by:",null,"OUDAH"]
[null,"Bank Address"]
["Ser.","Status#","Date OF Issue","LC Expiry Date","DC NO:","Bank","LC Value","Goods","Validity of Credit","Drafts at:","Present Date","Documents Presented Date","Documents Required","EVIDENCING"]
[{"$f":"+ROW()-10","v":1},"Open#1",43381,43556,"LC6478124567","BBC",30000000,"CPT/Applicant's Project Site, ",60,"60 Days from Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[2,"Extend Date&Value#1/1",43556,43647,"LC6478124567","BBC",2267805.9500000002,"CPT/Applicant's Project Site, ",60,"60 Days from Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[3,"Extend Date&Value#2/1",43647,43746,"LC6478124567","BBC",21000000,"CPT/Applicant's Project Site, ",60,"60 Days from Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[4,"Open#2",43797,43977,"LC1452479645","BBC",21000000,"CPT/Applicant's Project Site, ",60,"60 Days from Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[5]
[6]
[7]
[{"$f":"+ROW()-10","v":8}]
[{"$f":"+ROW()-10","v":9}]
[{"$f":"SUBTOTAL(103,Table3[Ser.])","v":9},"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table3[LC Value])","v":74267805.950000003}]
[null,null,null,null,null,null,"A/C No.900"]
[null,"from","to"]
[null,"Presented with","Validity of Credit","LC Expiry Date after"]
[null,{"$f":"INDEX(Table3[Present Date],MATCH(LOOKUP(2,1/(Table3[Present Date]<>\"\"),Table3[Present Date]),Table3[Present Date],0),1)","v":21},{"$f":"INDEX(Table3[Validity of Credit],MATCH(LOOKUP(2,1/(Table3[Validity of Credit]<>\"\"),Table3[Validity of Credit]),Table3[Validity of Credit],0),1)","v":60},{"$f":"INDEX(Table3[LC Expiry Date],MATCH(LOOKUP(2,1/(Table3[LC Expiry Date]<>\"\"),Table3[LC Expiry Date]),Table3[LC Expiry Date],0),1)-TODAY()","v":56}]
[null,{"$f":"C25-B24","v":"2020-03-27"},{"$f":"INDEX(Table10003[LC invoices Date],MATCH(LOOKUP(2,1/(Table10003[LC invoices Date]<>\"\"),Table10003[LC invoices Date]),Table10003[LC invoices Date],0),1)+C24","v":"2020-04-17"},{"$f":"INDEX(Table3[LC Expiry Date],MATCH(LOOKUP(2,1/(Table3[LC Expiry Date]<>\"\"),Table3[LC Expiry Date]),Table3[LC Expiry Date],0),1)","v":"2020-05-26"}]
["Inv.#","LC invoices Value","LC invoices Date","LC Balance","DC NO:","Available Limit","JARP/ Received Date","LC Status","Sent/H.O. ","Received/H.O","Returned/H.O.","Beneficiary/Received","Remarks"]
[0,26040000,43383,{"$f":"IF(E27=0,D26,IF(ISTEXT(D26),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B27,IF(_xlfn.IFNA(MATCH(E27,E26,0)=1,0),D26-B27,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B27)))","v":27227805.950000003},"LC6478124567",{"$f":"IFERROR(D27/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.51114937933725801},null,"Vendor Received",null,null,null,null,"10% Advance Payment/Delivered to vendor from H.O"]
["AQR/002/2018-19",121683.31,43489,{"$f":"IF(E28=0,D27,IF(ISTEXT(D27),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B28,IF(_xlfn.IFNA(MATCH(E28,E27,0)=1,0),D27-B28,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B28)))","v":27106122.640000004},"LC6478124567",{"$f":"IFERROR(D28/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.50886501061153622},null,"Vendor Received",null,null,null,"2019-03-03"]
[0,106122.64,43486,{"$f":"IF(E29=0,D28,IF(ISTEXT(D28),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B29,IF(_xlfn.IFNA(MATCH(E29,E28,0)=1,0),D28-B29,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B29)))","v":27000000.000000004},"LC6478124567",{"$f":"IFERROR(D29/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.50687276335998599},null,"Vendor Received",null,null,null,"2019-01-20","Delivered to vendor from H.O"]
["AQR/003/2018-19",141216.95999999999,43512,{"$f":"IF(E30=0,D29,IF(ISTEXT(D29),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B30,IF(_xlfn.IFNA(MATCH(E30,E29,0)=1,0),D29-B30,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B30)))","v":26858783.040000003},"LC6478124567",{"$f":"IFERROR(D30/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.50422168814707868},null,"Vendor Received",null,null,null,"2019-03-28"]
["AQR/004/2018-19",926579.18990000011,43545,{"$f":"IF(E31=0,D30,IF(ISTEXT(D30),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B31,IF(_xlfn.IFNA(MATCH(E31,E30,0)=1,0),D30-B31,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B31)))","v":25932203.850100003},"LC6478124567",{"$f":"IFERROR(D31/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.48682695650054275},"2019-04-29","Vendor Received",null,null,null,"2019-05-18"]
["AQR/005/2018-19",302950.55,43613,{"$f":"IF(E32=0,D31,IF(ISTEXT(D31),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B32,IF(_xlfn.IFNA(MATCH(E32,E31,0)=1,0),D31-B32,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B32)))","v":25629253.300100002},"LC6478124567",{"$f":"IFERROR(D32/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.48113964603980469},"2019-06-20","Vendor Received","2019-06-20",null,null,"2019-07-08"]
["AQR/006/2018-19",299544.06,43647,{"$f":"IF(E33=0,D32,IF(ISTEXT(D32),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B33,IF(_xlfn.IFNA(MATCH(E33,E32,0)=1,0),D32-B33,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B33)))","v":25329709.240100004},"LC6478124567",{"$f":"IFERROR(D33/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.47551628583831324},"2019-07-23","Vendor Received","2019-07-24"]
["AQR/007/2018-19",2186434.5299999998,43678,{"$f":"IF(E34=0,D33,IF(ISTEXT(D33),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B34,IF(_xlfn.IFNA(MATCH(E34,E33,0)=1,0),D33-B34,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B34)))","v":23143274.710100003},"LC6478124567",{"$f":"IFERROR(D34/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.43447020761139499},"2019-08-03","Vendor Received","2019-08-03",null,null,"2019-08-19"]
["AQR/009/2018-19",2946835.52,43710,{"$f":"IF(E35=0,D34,IF(ISTEXT(D34),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B35,IF(_xlfn.IFNA(MATCH(E35,E34,0)=1,0),D34-B35,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B35)))","v":20196439.190100003},"LC6478124567",{"$f":"IFERROR(D35/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.37914907193770014},null,"Vendor Received",null,null,null,"2019-09-24"]
["AQR/010/2018-19",315285.19,43751,{"$f":"IF(E36=0,D35,IF(ISTEXT(D35),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B36,IF(_xlfn.IFNA(MATCH(E36,E35,0)=1,0),D35-B36,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B36)))","v":19881154.000100002},"LC6478124567",{"$f":"IFERROR(D36/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.37323020247467131},"2019-10-15","Vendor Received",null,null,null,"2019-10-22"]
["AQR/011/2018-19",2096760.99,43800,{"$f":"IF(E37=0,D36,IF(ISTEXT(D36),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B37,IF(_xlfn.IFNA(MATCH(E37,E36,0)=1,0),D36-B37,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B37)))","v":18903239.010000002},"LC1452479645",{"$f":"IFERROR(D37/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.90015423857142862},null,"Vendor Received",null,null,null,"2019-12-03"]
["AQR/012/2018-19",894474.63,43803,{"$f":"IF(E38=0,D37,IF(ISTEXT(D37),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B38,IF(_xlfn.IFNA(MATCH(E38,E37,0)=1,0),D37-B38,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B38)))","v":18008764.380000003},"LC1452479645",{"$f":"IFERROR(D38/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.85756020857142867},null,"Vendor Received",null,null,null,"2019-12-05"]
["AQR/013/2018-19",2602205.4500000002,43800,{"$f":"IF(E39=0,D38,IF(ISTEXT(D38),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B39,IF(_xlfn.IFNA(MATCH(E39,E38,0)=1,0),D38-B39,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B39)))","v":15406558.930000003},"LC1452479645",{"$f":"IFERROR(D39/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.73364566333333348},"2019-12-15","Vendor Received","2019-12-25",null,null,"2019-12-25"]
["AQR/014/2018-19",635136.51,"2020-01-05",{"$f":"IF(E40=0,D39,IF(ISTEXT(D39),SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B40,IF(_xlfn.IFNA(MATCH(E40,E39,0)=1,0),D39-B40,SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]]))-B40)))","v":14771422.420000004},"LC1452479645",{"$f":"IFERROR(D40/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.70340106761904775},"2020-01-25","Vendor Received",null,null,null,"2020-01-26"]
["AQR/015/2018-19",3479092.93,"2020-02-17",{"$f":"IF(E41=0,D40,IF(ISTEXT(D40),SUMPRODUCT(#REF!*(#REF!=#REF!))-B41,IF(_xlfn.IFNA(MATCH(E41,E40,0)=1,0),D40-B41,SUMPRODUCT(#REF!*(#REF!=#REF!))-B41)))","v":11292329.490000004},"LC1452479645",{"$f":"IFERROR(D41/SUMPRODUCT(Table3[LC Value]*(Table3[DC NO:]=Table10003[[#This Row],[DC NO:]])),\"\")","v":0.53772997571428593},"2020-02-18","Vendor Received",null,null,null,"2020-02-20"]
[{"$f":"SUBTOTAL(103,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUBTOTAL(109,Table10003[LC invoices Value])","v":43094322.459900007},"Total",{"$f":"Table3[[#Totals],[LC Value]]-Table10003[[#Totals],[LC invoices Value]]","v":31173483.490099996},null,{"$f":"INDEX(Table10003[Available Limit],MATCH(LOOKUP(2,1/(Table10003[Available Limit]<>\"\"),Table10003[Available Limit]),Table10003[Available Limit],0),1)","v":0.53772997571428593}]
[null,{"$f":"+SUMPRODUCT(Table10003[LC invoices Value]*(Table10003[DC NO:]=INDEX(Table10003[DC NO:],MATCH(LOOKUP(2,1/(Table10003[DC NO:]<>\"\"),Table10003[DC NO:]),Table10003[DC NO:],0),1)))","v":9707670.5099999998}]

{"sheet":"4","index":6,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[4,null,null,null,null,null,null,"H",{"$f":"I2","v":"2020-03-31"}]
[null,"Beneficiary Number:",null,854693,null,null,null,"G",{"$f":"TODAY()","v":"2020-03-31"}]
[null,"Beneficiary Name:",null,"TECHNICAL WORKS CO"]
[null,"اسم المستفيد",null,"شركة الفني  للصناعات"]
[null,"Scope",null,"Bars"]
[null,"Vendor Type",null,"Supplier"]
[null,"IBAN",null,"EG455212564643123213",null,null,"Swift Code #"]
[null,"Available with/by:",null,"CAIRO BANK"]
[null,"Bank Address"]
["Ser.","Status#","Date OF Issue","LC Expiry Date","DC NO:","Bank","LC Value","Goods","Validity of Credit","Drafts at:","Present Date","Documents Presented Date","Documents Required","EVIDENCING"]
[{"$f":"+ROW()-10","v":1},"Open#1",43221,43313,"LC3154789652","BBC",1185796.1299999999,"CPT/Applicant's Project Site, ",60,"60 Days from Commercial Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[2,"Extend Date#1/1",43313,43405,"LC3154789652","BBC",0,"CPT/Applicant's Project Site, ",60,"60 Days from Commercial Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[3,"Open#2",43872,43957,"LC4578542136","BBC",629573.35,"CPT/Applicant's Project Site, ",60,"60 Days from Commercial Invoice Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[4]
[5]
[6]
[7]
[{"$f":"+ROW()-10","v":8}]
[{"$f":"+ROW()-10","v":9}]
[{"$f":"SUBTOTAL(103,Table4[Ser.])","v":9},"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table4[LC Value])","v":1815369.48}]
[null,null,null,null,null,null,"A/C No.900"]
[null,"from","to"]
[null,"Presented with","Validity of Credit","LC Expiry Date after"]
[null,{"$f":"INDEX(Table4[Present Date],MATCH(LOOKUP(2,1/(Table4[Present Date]<>\"\"),Table4[Present Date]),Table4[Present Date],0),1)","v":21},{"$f":"INDEX(Table4[Validity of Credit],MATCH(LOOKUP(2,1/(Table4[Validity of Credit]<>\"\"),Table4[Validity of Credit]),Table4[Validity of Credit],0),1)","v":60},{"$f":"INDEX(Table4[LC Expiry Date],MATCH(LOOKUP(2,1/(Table4[LC Expiry Date]<>\"\"),Table4[LC Expiry Date]),Table4[LC Expiry Date],0),1)-TODAY()","v":36}]
[null,{"$f":"C25-B24","v":"2020-03-26"},{"$f":"INDEX(Table10004[LC invoices Date],MATCH(LOOKUP(2,1/(Table10004[LC invoices Date]<>\"\"),Table10004[LC invoices Date]),Table10004[LC invoices Date],0),1)+C24","v":"2020-04-16"},{"$f":"INDEX(Table4[LC Expiry Date],MATCH(LOOKUP(2,1/(Table4[LC Expiry Date]<>\"\"),Table4[LC Expiry Date]),Table4[LC Expiry Date],0),1)","v":"2020-05-06"}]
["Inv.#","LC invoices Value","LC invoices Date","LC Balance","DC NO:","Available Limit","JARP/ Received Date","LC Status","Sent/H.O. ","Received/H.O","Returned/H.O.","Beneficiary/Received","Remarks"]
["22062018-01",532619.37,43273,{"$f":"IF(E27=0,D26,IF(ISTEXT(D26),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B27,IF(_xlfn.IFNA(MATCH(E27,E26,0)=1,0),D26-B27,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B27)))","v":653176.75999999989},"LC3154789652",{"$f":"IFERROR(D27/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":0.55083394478610748},null,"Vendor Received",null,null,null,"2018-10-03"]
["16022020-01",596264.09,43877,{"$f":"IF(E28=0,D27,IF(ISTEXT(D27),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B28,IF(_xlfn.IFNA(MATCH(E28,E27,0)=1,0),D27-B28,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B28)))","v":33309.260000000009},"LC4578542136",{"$f":"IFERROR(D28/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":5.290767152072115E-2},"2020-02-19","Vendor Received",null,null,null,"2020-02-19"]
[null,null,null,{"$f":"IF(E29=0,D28,IF(ISTEXT(D28),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B29,IF(_xlfn.IFNA(MATCH(E29,E28,0)=1,0),D28-B29,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B29)))","v":33309.260000000009},null,{"$f":"IFERROR(D29/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E30=0,D29,IF(ISTEXT(D29),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B30,IF(_xlfn.IFNA(MATCH(E30,E29,0)=1,0),D29-B30,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B30)))","v":33309.260000000009},null,{"$f":"IFERROR(D30/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E31=0,D30,IF(ISTEXT(D30),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B31,IF(_xlfn.IFNA(MATCH(E31,E30,0)=1,0),D30-B31,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B31)))","v":33309.260000000009},null,{"$f":"IFERROR(D31/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E32=0,D31,IF(ISTEXT(D31),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B32,IF(_xlfn.IFNA(MATCH(E32,E31,0)=1,0),D31-B32,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B32)))","v":33309.260000000009},null,{"$f":"IFERROR(D32/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E33=0,D32,IF(ISTEXT(D32),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B33,IF(_xlfn.IFNA(MATCH(E33,E32,0)=1,0),D32-B33,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B33)))","v":33309.260000000009},null,{"$f":"IFERROR(D33/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E34=0,D33,IF(ISTEXT(D33),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B34,IF(_xlfn.IFNA(MATCH(E34,E33,0)=1,0),D33-B34,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B34)))","v":33309.260000000009},null,{"$f":"IFERROR(D34/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E35=0,D34,IF(ISTEXT(D34),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B35,IF(_xlfn.IFNA(MATCH(E35,E34,0)=1,0),D34-B35,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B35)))","v":33309.260000000009},null,{"$f":"IFERROR(D35/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E36=0,D35,IF(ISTEXT(D35),SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B36,IF(_xlfn.IFNA(MATCH(E36,E35,0)=1,0),D35-B36,SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]]))-B36)))","v":33309.260000000009},null,{"$f":"IFERROR(D36/SUMPRODUCT(Table4[LC Value]*(Table4[DC NO:]=Table10004[[#This Row],[DC NO:]])),\"\")","v":""}]
[{"$f":"SUBTOTAL(103,Table10004[Inv.'#])","v":2},{"$f":"SUBTOTAL(109,Table10004[LC invoices Value])","v":1128883.46},"Total",{"$f":"Table4[[#Totals],[LC Value]]-Table10004[[#Totals],[LC invoices Value]]","v":686486.02},null,{"$f":"INDEX(Table10004[Available Limit],MATCH(LOOKUP(2,1/(Table10004[Available Limit]<>\"\"),Table10004[Available Limit]),Table10004[Available Limit],0),1)","v":5.290767152072115E-2}]
[null,{"$f":"+SUMPRODUCT(Table10004[LC invoices Value]*(Table10004[DC NO:]=INDEX(Table10004[DC NO:],MATCH(LOOKUP(2,1/(Table10004[DC NO:]<>\"\"),Table10004[DC NO:]),Table10004[DC NO:],0),1)))","v":596264.09}]

{"sheet":"5","index":7,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[5,null,null,null,null,null,null,"H",{"$f":"I2","v":"2020-03-31"}]
[null,"Beneficiary Number:",null,458216,null,null,null,"G",{"$f":"TODAY()","v":"2020-03-31"}]
[null,"Beneficiary Name:",null,"P&L CO."]
[null,"اسم المستفيد",null,"شركة بي & ال"]
[null,"Scope",null,"Diff. Materials. "]
[null,"Vendor Type",null,"Subcontractor"]
[null,"IBAN",null,"EG84695123456799613",null,null,"Swift Code #"]
[null,"Available with/by:",null,"AFRIQY BANK"]
[null,"Bank Address"]
["Ser.","Status#","Date OF Issue","LC Expiry Date","DC NO:","Bank","LC Value","Goods","Validity of Credit","Drafts at:","Present Date","Documents Presented Date","Documents Required","EVIDENCING"]
[{"$f":"+ROW()-10","v":1},"Open#1",43368,43526,"LC1234567890","BBC",4365900,"CPT/Applicant's Project Site, ",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[2,"Extend Date#1/1",43515,43618,"LC1234567890","BBC",0,"CPT/Applicant's Project Site, ",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[3,"Extend Date#2/1",43619,43710,"LC1234567890","BBC",-1500000,"CPT/Applicant's Project Site, ",60,"60 Days from delivery Date",21,"Within 21 Days from Applicant Authorized Sign.","1 Orig.Comm.Inv.+1 Copy\n1 Orig. Deli. + 1 Copy","Receipt of Goods In Good Order And Condition and Stating The Exact Delivery Date."]
[4]
[5]
[6]
[7]
[{"$f":"+ROW()-10","v":8}]
[{"$f":"+ROW()-10","v":9}]
[{"$f":"SUBTOTAL(103,Table5[Ser.])","v":9},"Total",null,null,null,null,{"$f":"SUBTOTAL(109,Table5[LC Value])","v":2865900}]
[null,null,null,null,null,null,"A/C No.900"]
[null,"from","to"]
[null,"Presented with","Validity of Credit","LC Expiry Date after"]
[null,{"$f":"INDEX(Table5[Present Date],MATCH(LOOKUP(2,1/(Table5[Present Date]<>\"\"),Table5[Present Date]),Table5[Present Date],0),1)","v":21},{"$f":"INDEX(Table5[Validity of Credit],MATCH(LOOKUP(2,1/(Table5[Validity of Credit]<>\"\"),Table5[Validity of Credit]),Table5[Validity of Credit],0),1)","v":60},{"$f":"INDEX(Table5[LC Expiry Date],MATCH(LOOKUP(2,1/(Table5[LC Expiry Date]<>\"\"),Table5[LC Expiry Date]),Table5[LC Expiry Date],0),1)-TODAY()","v":-211}]
[null,{"$f":"C25-B24","v":"2019-08-30"},{"$f":"INDEX(Table10005[LC invoices Date],MATCH(LOOKUP(2,1/(Table10005[LC invoices Date]<>\"\"),Table10005[LC invoices Date]),Table10005[LC invoices Date],0),1)+C24","v":"2019-09-20"},{"$f":"INDEX(Table5[LC Expiry Date],MATCH(LOOKUP(2,1/(Table5[LC Expiry Date]<>\"\"),Table5[LC Expiry Date]),Table5[LC Expiry Date],0),1)","v":"2019-09-02"}]
["Inv.#","LC invoices Value","LC invoices Date","LC Balance","DC NO:","Available Limit","JARP/ Received Date","LC Status","Sent/H.O. ","Received/H.O","Returned/H.O.","Beneficiary/Received","Remarks"]
[0,1052655.49,43391,{"$f":"IF(E27=0,D26,IF(ISTEXT(D26),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B27,IF(_xlfn.IFNA(MATCH(E27,E26,0)=1,0),D26-B27,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B27)))","v":1813244.51},"LC1234567890",{"$f":"IFERROR(D27/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.63269636414389896},null,"Vendor Received",null,null,null,"2018-11-21"]
[201800011,108868.86,43464,{"$f":"IF(E28=0,D27,IF(ISTEXT(D27),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B28,IF(_xlfn.IFNA(MATCH(E28,E27,0)=1,0),D27-B28,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B28)))","v":1704375.65},"LC1234567890",{"$f":"IFERROR(D28/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.59470869534875603},null,"Vendor Received",null,null,null,"2019-02-10"]
[201800095,80987.06,43538,{"$f":"IF(E29=0,D28,IF(ISTEXT(D28),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B29,IF(_xlfn.IFNA(MATCH(E29,E28,0)=1,0),D28-B29,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B29)))","v":1623388.5899999999},"LC1234567890",{"$f":"IFERROR(D29/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.56644983774730451},null,"Vendor Received",null,null,null,"2019-04-02"]
[201900009,73113.320000000007,43563,{"$f":"IF(E30=0,D29,IF(ISTEXT(D29),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B30,IF(_xlfn.IFNA(MATCH(E30,E29,0)=1,0),D29-B30,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B30)))","v":1550275.2699999998},"LC1234567890",{"$f":"IFERROR(D30/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.5409383684008513},"2019-04-09","Vendor Received","2019-04-09",null,"2019-04-29","2019-05-02"]
[201900014,92688.31,43586,{"$f":"IF(E31=0,D30,IF(ISTEXT(D30),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B31,IF(_xlfn.IFNA(MATCH(E31,E30,0)=1,0),D30-B31,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B31)))","v":1457586.9599999997},"LC1234567890",{"$f":"IFERROR(D31/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.5085965874594367},"2019-05-19","Vendor Received","2019-05-20",null,null,"2019-06-18"]
[201900019,124394.44,43626,{"$f":"IF(E32=0,D31,IF(ISTEXT(D31),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B32,IF(_xlfn.IFNA(MATCH(E32,E31,0)=1,0),D31-B32,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B32)))","v":1333192.5199999998},"LC1234567890",{"$f":"IFERROR(D32/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.46519156983844512},"2019-06-18","Vendor Received","2019-06-18",null,"2019-07-01","2019-07-02"]
[201900030,42436.25,43648,{"$f":"IF(E33=0,D32,IF(ISTEXT(D32),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B33,IF(_xlfn.IFNA(MATCH(E33,E32,0)=1,0),D32-B33,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B33)))","v":1290756.2699999998},"LC1234567890",{"$f":"IFERROR(D33/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.45038426672249549},"2019-07-09","Vendor Received",null,null,null,"2019-08-05"]
[201900031,141587.67000000001,43668,{"$f":"IF(E34=0,D33,IF(ISTEXT(D33),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B34,IF(_xlfn.IFNA(MATCH(E34,E33,0)=1,0),D33-B34,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B34)))","v":1149168.5999999999},"LC1234567890",{"$f":"IFERROR(D34/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":0.40098000628074948},"2019-08-05","Vendor Received","2019-08-06",null,null,"2019-09-07"]
[null,null,null,{"$f":"IF(E35=0,D34,IF(ISTEXT(D34),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B35,IF(_xlfn.IFNA(MATCH(E35,E34,0)=1,0),D34-B35,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B35)))","v":1149168.5999999999},null,{"$f":"IFERROR(D35/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":""}]
[null,null,null,{"$f":"IF(E36=0,D35,IF(ISTEXT(D35),SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B36,IF(_xlfn.IFNA(MATCH(E36,E35,0)=1,0),D35-B36,SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]]))-B36)))","v":1149168.5999999999},null,{"$f":"IFERROR(D36/SUMPRODUCT(Table5[LC Value]*(Table5[DC NO:]=Table10005[[#This Row],[DC NO:]])),\"\")","v":""}]
[{"$f":"SUBTOTAL(103,Table10005[Inv.'#])","v":8},{"$f":"SUBTOTAL(109,Table10005[LC invoices Value])","v":1716731.4000000001},"Total",{"$f":"Table5[[#Totals],[LC Value]]-Table10005[[#Totals],[LC invoices Value]]","v":1149168.5999999999},null,{"$f":"INDEX(Table10005[Available Limit],MATCH(LOOKUP(2,1/(Table10005[Available Limit]<>\"\"),Table10005[Available Limit]),Table10005[Available Limit],0),1)","v":0.40098000628074948}]
[null,{"$f":"+SUMPRODUCT(Table10005[LC invoices Value]*(Table10005[DC NO:]=INDEX(Table10005[DC NO:],MATCH(LOOKUP(2,1/(Table10005[DC NO:]<>\"\"),Table10005[DC NO:]),Table10005[DC NO:],0),1)))","v":1716731.4000000001}]