{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","summare ","KU","Ahli United Bank","B online","pic"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["no","date","contract no ","owner","descraption ","amount ","type of payment ","start day ","endday"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]

{"sheet":"summare ","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,3,1,13]]}
[]
[null,null,null,"السلام عليكم محتاج المبالغ دة تنزل بالجدول  بناء على عدد الشيتات "]
[]
[]
[]
["no","custemar","contract no","2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01"]
[1,"KU",111,666.04,null,666.04,666.04,1332.08,666.04,666.04,666.04,666.04,666.04,666.04,666.04]
[2,"Ahli United Bank",1234,null,null,null,1012.5,null,1012.5,null,null,1012.5,null,null,1012.5]
[3,"B online",1345,null,null,null,950,null,950,null,null,950,null,null,950]
[4,"pic",6676,null,null,null,600,null,600,null,null,600,null,null,600]

{"sheet":"KU","index":2,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"START DAY","2022-01-01"]
[null,"END DAY","2023-12-31"]
[null,"Type Payment","m"]
[null,"count of payment",{"$f":"ROUND(IF(C5=\"m\",(C4-C3)/364*12,(C4-C3)/91),0)","v":24}]
[null,"amount",{"$f":"666.04*24","v":15984.96}]
[null,"contract no",111]
[]
[]
["NO","DATE","invo no ",null,"%","amount "]
[{"$f":"IF(B12<>\"\",1,0)","v":1},{"$f":"IF(C5=\"m\",C3+30,C3+90)","v":"2022-01-31"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":4.1666666666666664E-2},{"$f":"$C$7*E12","v":666.04}]
[{"$f":"IF(B13<>\"\",A12+1,0)","v":2},{"$f":"IF($C$5=\"m\",B12+30,B12+90)","v":"2022-03-02"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":4.1666666666666664E-2},{"$f":"$C$7*E13","v":666.04}]
[{"$f":"IF(B14<>\"\",A13+1,0)","v":3},{"$f":"IF($C$5=\"m\",B13+30,B13+90)","v":"2022-04-01"},null,null,4.1666666666666664E-2,666.04]
[4,"2022-05-01",null,null,4.1666666666666664E-2,666.04]
[5,"2022-05-31",null,null,4.1666666666666664E-2,666.04]
[6,"2022-06-30",null,null,4.1666666666666664E-2,666.04]
[7,"2022-07-30",null,null,4.1666666666666664E-2,666.04]
[8,"2022-08-29",null,null,4.1666666666666664E-2,666.04]
[9,"2022-09-28",null,null,4.1666666666666664E-2,666.04]
[10,"2022-10-28",null,null,4.1666666666666664E-2,666.04]
[11,"2022-11-27",null,null,4.1666666666666664E-2,666.04]
[12,"2022-12-27",null,null,4.1666666666666664E-2,666.04]
[13,"2023-01-26",null,null,4.1666666666666664E-2,666.04]
[14,"2023-02-25",null,null,4.1666666666666664E-2,666.04]
[15,"2023-03-27",null,null,4.1666666666666664E-2,666.04]
[16,"2023-04-26",null,null,4.1666666666666664E-2,666.04]
[17,"2023-05-26",null,null,4.1666666666666664E-2,666.04]
[18,"2023-06-25",null,null,4.1666666666666664E-2,666.04]
[19,"2023-07-25",null,null,4.1666666666666664E-2,666.04]
[20,"2023-08-24",null,null,4.1666666666666664E-2,666.04]
[21,"2023-09-23",null,null,4.1666666666666664E-2,666.04]
[22,"2023-10-23",null,null,4.1666666666666664E-2,666.04]
[23,"2023-11-22",null,null,4.1666666666666664E-2,666.04]
[24,"2023-12-22",null,null,4.1666666666666664E-2,666.04]

{"sheet":"Ahli United Bank","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"START DAY","2022-01-01"]
[null,"END DAY","2022-12-31"]
[null,"Type Payment","Q"]
[null,"count of payment",{"$f":"ROUND(IF(C5=\"m\",(C4-C3)/364*12,(C4-C3)/91),0)","v":4}]
[null,"amount",{"$f":"1012.5*4","v":4050}]
[null,"contract no",1234]
[]
[null,{"$f":"COUNT(B12:B15)","v":4}]
["NO","DATE","invo no ",null,"%","amount "]
[1,{"$f":"IF(C5=\"m\",C3+30,C3+90)","v":"2022-04-01"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":0.25},{"$f":"$C$7*E12","v":1012.5}]
[2,{"$f":"IF($C$5=\"m\",B12+30,B12+90)","v":"2022-06-30"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":0.25},{"$f":"$C$7*E13","v":1012.5}]
[3,{"$f":"IF($C$5=\"m\",B13+30,B13+90)","v":"2022-09-28"},null,null,0.25,1012.5]
[4,"2022-12-27",null,null,0.25,1012.5]

{"sheet":"B online","index":4,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"START DAY","2022-01-01"]
[null,"END DAY","2022-12-31"]
[null,"Type Payment","Q"]
[null,"count of payment",{"$f":"ROUND(IF(C5=\"m\",(C4-C3)/364*12,(C4-C3)/91),0)","v":4}]
[null,"amount",3800]
[null,"contract no",1345]
[]
[null,{"$f":"COUNT(B12:B15)","v":4}]
["NO","DATE","invo no ",null,"%","amount "]
[1,{"$f":"IF(C5=\"m\",C3+30,C3+90)","v":"2022-04-01"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":0.25},{"$f":"$C$7*E12","v":950}]
[2,{"$f":"IF($C$5=\"m\",B12+30,B12+90)","v":"2022-06-30"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":0.25},{"$f":"$C$7*E13","v":950}]
[3,{"$f":"IF($C$5=\"m\",B13+30,B13+90)","v":"2022-09-28"},null,null,0.25,950]
[4,"2022-12-27",null,null,0.25,950]

{"sheet":"pic","index":5,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"START DAY","2022-01-01"]
[null,"END DAY","2022-12-31"]
[null,"Type Payment","Q"]
[null,"count of payment",{"$f":"ROUND(IF(C5=\"m\",(C4-C3)/364*12,(C4-C3)/91),0)","v":4}]
[null,"amount",{"$f":"600*4","v":2400}]
[null,"contract no",6676]
[]
[null,{"$f":"COUNT(B12:B35)","v":24}]
["NO","DATE","invo no ",null,"%","amount "]
[1,{"$f":"IF(C5=\"m\",C3+30,C3+90)","v":"2022-04-01"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":0.25},{"$f":"$C$7*E12","v":600}]
[2,{"$f":"IF($C$5=\"m\",B12+30,B12+90)","v":"2022-06-30"},null,null,{"$f":"($C$7/$C$6)/$C$7","v":0.25},{"$f":"$C$7*E13","v":600}]
[3,{"$f":"IF($C$5=\"m\",B13+30,B13+90)","v":"2022-09-28"},null,null,0.25,600]
[4,"2022-12-27",null,null,0.25,600]
[5,"2023-03-27"]
[6,"2023-06-25"]
[7,"2023-09-23"]
[8,"2023-12-22"]
[9,"2024-03-21"]
[10,"2024-06-19"]
[11,"2024-09-17"]
[12,"2024-12-16"]
[13,"2025-03-16"]
[14,"2025-06-14"]
[15,"2025-09-12"]
[16,"2025-12-11"]
[17,"2026-03-11"]
[18,"2026-06-09"]
[19,"2026-09-07"]
[20,"2026-12-06"]
[21,"2027-03-06"]
[22,"2027-06-04"]
[23,"2027-09-02"]
[24,"2027-12-01"]