{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Sheet1","April","Vnd1","Vnd2","Vnd3","Vnd4","Vnd5","Vnd6","Vnd7","Vnd8"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":"Sheet1","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Paid"]
[null,"Under Procress"]
[null,"Pending"]

{"sheet":"April","index":1,"n_rows":71,"n_cols":16,"rows_kept":71,"cut":false,"hidden":false,"merged":[[14,0,14,2],[14,3,14,4],[9,10,10,10],[9,11,10,11],[0,0,1,11],[5,0,5,2],[5,3,5,4],[6,0,7,11],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,6,10,6],[9,8,10,8],[9,9,10,9],[40,0,41,11],[15,0,16,11],[22,0,22,2],[22,3,22,4],[23,0,24,11],[30,0,30,2],[30,3,30,4],[31,0,32,11],[39,0,39,2],[39,3,39,4],[65,1,66,1],[65,2,66,2],[65,6,66,6],[65,8,66,8],[51,0,51,2],[51,3,51,4],[52,0,53,11],[43,11,44,11],[43,0,44,0],[65,3,66,3],[65,4,66,4],[65,5,66,5],[43,1,44,1],[43,2,44,2],[43,6,44,6],[43,8,44,8],[43,9,44,9],[43,10,44,10],[65,11,66,11],[61,0,61,2],[61,3,61,4],[62,0,63,11],[65,0,66,0]]}
["Vendors Payment April 2024"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"المطلوب كود لاستدعاء كل الفواتير  ( under process ) لكل مورد من كل الشيتات"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"وعمل جدول لكل مورد مثل هذا التقرير"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"علما بان كل مورد له شيت مستقل وحركة مستقلة"]
["Payment Terms",null,null,"60 days from the date of delivery"]
["Vnd1"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[1,"2024-01-10","WH/IN/418","JERRY CAN 20 LTR BLUE-PRINTED SBR BO.1 (WITH CAPS)",7015,91,{"$f":"B10+60","v":"2024-03-10"},72.8,"KWD",null,1750090795,202912]
[null,null,null,"JERRY CAN 20 LTR BLUE-PRINTED SBR. NO.2 (WITH CAPS)",7049,200,null,160]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H10:H12)","v":232.8}]
[]
[]
["Payment Terms",null,null,"90 days from date of Delivery"]
["Vnd3"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[null,"2022-06-06",205498,"SNF LIQUID",1002,25000,{"$f":"B19+60","v":"2022-08-05"},12625,"USD",null,4170007013,202675,{"$f":"SUM(H19)","v":12625}]
[]
[]
[]
["Payment Terms",null,null,"60  days from date of Delivery"]
["Vnd4"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[null,"2023-12-27","WH/IN/484","SODIUM GLUCONATE ",1012,48000,{"$f":"B27+75","v":"2024-03-11"},30480,"USD",null,5794,202910,{"$f":"SUM(H27)","v":30480}]
[]
[]
[]
["Payment Terms",null,null,"60  days from date of Delivery"]
["Vnd5"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[1,"2024-01-03","WH/IN/00400","PREVENTOL D 6",1013,800,{"$f":"B35+90","v":"2024-04-02"},680,"KWD",null,"SLS-104197",202681]
[2,"2024-01-03","WH/IN/399","VINNAPAS 5010 N ",2069,1950,"2024-04-02",2242.5,"KWD",null,"SLS-104198",202854,{"$f":"SUM(H36)","v":2242.5}]
[]
[]
[]
["Payment Terms",null,null,"60  days from date of Delivery"]
["Vnd6"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[1,"2024-02-15","WH/IN/483","BYK-1615",2027,740,{"$f":"B44+60","v":"2024-04-15"},647.5,"KWD",null,"SINV-007991",202914]
[null,null,null,"PROXEL 106",2057,100,null,75]
[2,"2024-02-21","WH/IN/499","BYK-1615",2027,370,{"$f":"B46+60","v":"2024-04-21"},323.75,"KWD",null,"SINV-008012",202914]
[3,"2024-02-21","WH/IN/501","HECELLOSE H 100 K",2020,140,{"$f":"B47+60","v":"2024-04-21"},343,"KWD",null,"SINV-008011",202871]
[4,"2024-02-22","WH/IN/502","BERmocoll 230 X",2035,330,{"$f":"B48+60","v":"2024-04-22"},726,"KWD",null,"SINV-008021",202905,{"$f":"SUM(H44:H48)","v":2115.25}]
[]
[]
[]
["Payment Terms",null,null,"45 DAYS "]
["Vnd7"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[null,"2024-01-11","WH/IN/00421","Revacryl AE 2091 JA",2029,5000,{"$f":"B56+60","v":"2024-03-11"},2765.0000000000005,"KWD",null,"SINV-032676",202897]
[null,"2024-01-22","WH/IN/0444","CALCIUM STEARATE",2018,1520,"2024-03-22",1208.4000000000001,"KWD",null,"SINV-032835",202818]
[null,"2024-02-01","WH/IN/493","WHITE SPIRIT ",2061,640,{"$f":"B58+60","v":"2024-04-01"},194,"KWD",null,"SINV-031451",202886,{"$f":"SUM(H56:H58)","v":4167.4000000000005}]
[]
[]
[]
["Payment Terms",null,null,"30 DAYS FROM DELIVERY "]
["Vnd8"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O."]
[null,"2021-11-06",204979,"OPC CEMENT",2001,39660,{"$f":"B66+60","v":"2022-01-05"},880.452,"KWD",null,7900014571,202509]
[null,null,null,null,null,null,null,-218.13,null,null,7900014603]
[null,"2021-11-08",204991,"OPC CEMENT",2001,20000,{"$f":"B68+60","v":"2022-01-07"},376,"KWD",null,7900014572,202306,{"$f":"SUM(H66:H68)","v":1038.3220000000001}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TOTAL PAYMENT ",{"$f":"+M68+M58+M48+M36+M27+M19+M12","v":52901.272000000004}]

{"sheet":"Vnd1","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,11,8,11],[3,0,4,12],[2,0,2,1],[2,2,2,4],[5,13,5,14],[7,0,8,0],[7,9,8,9],[7,1,8,1],[7,2,8,2],[7,6,8,6],[7,8,8,8],[7,10,8,10]]}
[]
[]
["Payment Terms",null,"60 Days from Date of Delivery"]
["Vnd1"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues"]
[5,"2024-01-06","WH/IN/452","PROD1",7025,3950,{"$f":"B7+60","v":"2024-03-06"},131.94999999999999,"KWD",null,1750090999,202921,"Paid"]
[null,"2024-01-10","WH/IN/418","PROD2",7015,91,{"$f":"B8+60","v":"2024-03-10"},72.8,"KWD",null,1750090795,202912,"Under Procress"]
[null,null,null,"PROD3",7049,200,null,160,null,null,null,null,"Under Procress"]
[null,null,null,"PROD4",7003,400,{"$f":"B10+60","v":60},320,"KWD",null,null,202945,"Pending"]

{"sheet":"Vnd2","index":3,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,5,12],[1,2,1,4]]}
[]
["Payment Terms",null,"60 Days from Date of Delivery"]
[]
[]
["Vnd2"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues"]
[2,"2019-11-28",203461,"PROD1",1001,22000,"2020-01-28",15620,"USD",null,"SE/439",202007,"Paid"]

{"sheet":"Vnd3","index":4,"n_rows":8,"n_cols":13,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,13,5,14],[3,0,4,12],[2,0,2,1],[2,2,2,4]]}
[]
[]
["Payment Terms",null,"60 Days from Date of Delivery"]
["Vnd3"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues"]
[3,"2022-06-01",205494,"PROD1",1002,25000,{"$f":"B7+60","v":"2022-07-31"},12625,"USD",null,4170007147,202675,"Paid"]
[null,"2022-06-06",205498,"PROD2",1002,25000,"2022-08-05",12625,"USD",null,4170007013,202675,"Under Procress"]

{"sheet":"Vnd4","index":5,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,3,2,4],[5,13,5,14],[3,0,4,12]]}
[]
[]
["Payment Terms",null,null,"90 Days From Date of PL"]
["Vnd4"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues","DUE AS ON 21/04/2019"]
[2,"2023-12-18","WH/IN/465","PROD1",1012,72000,{"$f":"B7+75","v":"2024-03-02"},45720,"USD",null,5793,202910,"Paid"]
[null,"2023-12-27","WH/IN/484","PROD2",1012,48000,{"$f":"B8+75","v":"2024-03-11"},30480,"USD",null,5794,202910,"Under Procress"]
[null,"2024-02-13","WH/IN/510","PROD3",2037,18000,{"$f":"B9+90","v":"2024-05-13"},21150,"USD",null,5870,202936,"Pending"]

{"sheet":"Vnd5","index":6,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,3,2,4],[5,13,5,14],[3,0,4,12]]}
[]
[]
["Payment Terms",null,null,"90 Days From Date of Delivery"]
["Vnd5"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues","DUE AS ON 21/04/2019"]
[2,"2023-11-16","WH/IN/0334","PROD1",2069,1950,{"$f":"B7+90","v":"2024-02-14"},2242.5,"KWD",null,"SLS-104153",202854,"Paid"]
[null,"2024-01-03","WH/IN/00400","PROD2",1013,800,"2024-04-02",680,"KWD",null,"SLS-104197",202681,"Under Procress"]
[null,"2024-01-03","WH/IN/399","PROD3",2069,1950,"2024-04-02",2242.5,"KWD",null,"SLS-104198",202854,"Under Procress"]
[null,"2024-03-11","WH/IN/530","PROD4",2070,1625,{"$f":"B10+90","v":"2024-06-09"},2925,"KWD",null,"SLS-104283",202927,"Pending"]

{"sheet":"Vnd6","index":7,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,13,5,14],[2,0,2,2],[2,3,2,4],[3,0,4,12],[7,1,8,1],[7,2,8,2],[7,6,8,6],[7,8,8,8],[7,10,8,10],[7,11,8,11],[7,9,8,9]]}
[]
[]
["Payment Terms",null,null,"60  Days From Date of Delivery"]
["Vnd6"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues","DUE AS ON 21/04/2019"]
[null,"2024-02-15","WH/IN/482","PROD1",3073,18,{"$f":"B7+60","v":"2024-04-15"},30.96,"KWD",null,"SINV-007994",202759,"Paid"]
[null,"2024-02-15","WH/IN/483","PROD2",2027,740,{"$f":"B8+60","v":"2024-04-15"},647.5,"KWD",null,"SINV-007991",202914,"Under Procress"]
[null,null,null,"PROD3",2057,100,null,75,null,null,null,null,"Under Procress"]
[null,"2024-02-21","WH/IN/499","PROD4",2027,370,{"$f":"B10+60","v":"2024-04-21"},323.75,"KWD",null,"SINV-008012",202914,"Under Procress"]
[null,"2024-02-21","WH/IN/501","PROD5",2020,140,{"$f":"B11+60","v":"2024-04-21"},343,"KWD",null,"SINV-008011",202871,"Under Procress"]
[null,"2024-02-22","WH/IN/502","PROD6",2035,330,{"$f":"B12+60","v":"2024-04-22"},726,"KWD",null,"SINV-008021",202905,"Under Procress"]
[null,"2024-03-20","WH/IN/538","PROD7",2035,105,{"$f":"B13+60","v":"2024-05-19"},231,"KWD",null,"SINV-008127",202947,"Pending"]

{"sheet":"Vnd7","index":8,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,13,5,14],[2,0,2,2],[2,3,2,4],[3,0,4,12]]}
[]
[]
["Payment Terms",null,null,"60  Days From Date of Delivery"]
["Vnd7"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues","DUE AS ON 21/04/2019"]
[3,"2023-12-20","WH/IN/380","PROD1",2018,1000,{"$f":"B7+60","v":"2024-02-18"},795,"KWD",null,"SINV-032258",202818,"Paid"]
[null,"2024-01-11","WH/IN/00421","PROD2",2029,5000,"2024-03-11",2765.0000000000005,"KWD",null,"SINV-032676",202897,"Under Procress"]
[null,"2024-01-22","WH/IN/0444","PROD3",2018,1520,{"$f":"B9+60","v":"2024-03-22"},1208.4000000000001,"KWD",null,"SINV-032835",202818,"Under Procress"]
[null,"2024-02-01","WH/IN/493","PROD4",2061,640,{"$f":"B10+60","v":"2024-04-01"},194,"KWD",null,"SINV-031451",202886,"Under Procress"]
[null,"2024-03-02","WH/IN/520","PROD5",2018,1000,{"$f":"B11+60","v":"2024-05-01"},795,"KWD",null,"SINV-033734",202934,"Pending"]

{"sheet":"Vnd8","index":9,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,0,2,2],[2,3,2,4],[3,0,4,12],[11,0,12,0],[11,1,12,1],[11,6,12,6],[11,5,12,5],[11,8,12,8],[11,11,12,11],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,6,7,6],[8,8,9,8],[8,11,9,11],[8,0,9,0],[6,11,7,11],[5,13,5,14],[6,8,7,8],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6]]}
[]
[]
["Payment Terms",null,null,"60  Days From Date of Delivery"]
["Vnd8"]
[]
["Sr.No.","Date","SRV No.","Material Name","RM No.","Quantity Received (Kg/No.s)","Payment Due Date","Amount Due/Paid","Currency","Due Age For RM (Days)","INVOICE No.","P.O.","Statues","DUE AS ON 21/04/2019"]
[2,"2021-10-28","204922  204963","PROD1",2001,{"$f":"38700+42890","v":81590},{"$f":"B7+60","v":"2021-12-27"},1811.298,"KWD",null,7900014507,202509,"Paid"]
[null,null,null,null,null,null,null,-448.745,null,null,7900014539,null,"Paid"]
[null,"2021-11-06",204979,"PROD2",2001,39660,{"$f":"B9+60","v":"2022-01-05"},880.452,"KWD",null,7900014571,202509,"Under Procress"]
[null,null,null,null,null,null,null,-218.13,null,null,7900014603,null,"Under Procress"]
[null,"2021-11-08",204991,"PROD3",2001,20000,{"$f":"B11+60","v":"2022-01-07"},376,"KWD",null,7900014572,202306,"Under Procress"]
[null,"2021-11-30",205037,"PROD4",2001,{"$f":"44960+47110","v":92070},{"$f":"B12+60","v":"2022-01-29"},2043.954,"KWD",null,7900014641,202509,"Pending"]
[null,null,205064,"PROD5",2001,null,null,-506.38499999999999,null,null,7900014672,null,"Pending"]