{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ورقة1","ورقة2","ورقة3"],"not_rendered":{"charts":0,"images":0,"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":"ورقة1","index":0,"n_rows":51,"n_cols":22,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,8,1,9],[2,13,2,21]]}
[0,"القيمة الايجارية ",null,"2023-09-09",{"$f":"18/100","v":0.18},null,null,null,{"$f":"SUM(K5:K50)","v":129600},{"$f":"SUM(H5:H50)","v":120000},{"$f":"I1-J1","v":9600},-1,null,"التاريخ","التاريخ",null,"ب","2023-01-01"]
[null,12000,null,null,null,null,null,null,{"$f":"(K1)","v":9600},null,{"$f":"IF(K1<=0,\"دائن\",\"مدين\")","v":"مدين"},null,null,{"$f":"\">=\"&R1","v":">=44927"},{"$f":"\"<=\"&R2","v":"<=45017"},null,"ن","2023-04-01"]
[null,null,null,null,12]
["التاريخ","التاريخ",null,"القيمة الايجارية ","غرامة \nتأخير","ضريبة \n قيمة مضافة ","المبلغ المستحق ","المبلغ المسدد","تاريخ السداد ","رقم الايصال ","الرصيد ",null,null,"التاريخ",null,"القيمة الايجارية ","غرامة \nتأخير","ضريبة \n قيمة مضافة ","المبلغ المستحق ","المبلغ المسدد","تاريخ السداد ","رقم الايصال "]
["2023-01-01","2023-01-01",{"$f":"(DATEDIF(A5,$D$1,\"m\"))","v":8},{"$f":"IFERROR(IF(C5>=$A$1,$B$2),\"0\")","v":12000},{"$f":"C5/$E$3*$E$1*D5","v":1440},{"$f":"D5*14%","v":1680.0000000000002},{"$f":"SUM(D5:F5)","v":15120},null,null,null,{"$f":"IFERROR(G5,\"0\")","v":15120},null,null,"2023-01-01",null,12000,1440,1680.0000000000002,15120]
["2023-02-01","2023-02-01",{"$f":"(DATEDIF(A6,$D$1,\"m\"))","v":7},{"$f":"IFERROR(IF(C6>=$A$1,$B$2),\"0\")","v":12000},1260,{"$f":"D6*14%","v":1680.0000000000002},{"$f":"F6+E6+D6","v":14940},null,null,null,{"$f":"IFERROR(G6,\"0\")","v":14940},null,null,"2023-02-01",null,12000,1260,1680.0000000000002,14940]
["2023-03-01","2023-03-01",6,12000,1080,{"$f":"D7*14%","v":1680.0000000000002},{"$f":"F7+E7+D7","v":14760},null,null,null,14760,null,null,"2023-03-01",null,12000,1080,1680.0000000000002,14760]
["2023-04-01","2023-04-01",5,12000,900,{"$f":"D8*14%","v":1680.0000000000002},{"$f":"F8+E8+D8","v":14580},100000,null,null,14580,null,null,"2023-04-01",null,12000,900,1680.0000000000002,14580,100000]
["2023-05-01","2023-05-01",4,12000,720,{"$f":"D9*14%","v":1680.0000000000002},{"$f":"F9+E9+D9","v":14400},null,null,null,14400]
["2023-06-01","2023-06-01",3,12000,540,{"$f":"D10*14%","v":1680.0000000000002},{"$f":"F10+E10+D10","v":14220},null,null,null,14220]
["2023-07-01","2023-07-01",2,12000,360,{"$f":"D11*14%","v":1680.0000000000002},{"$f":"F11+E11+D11","v":14040},20000,null,null,14040]
["2023-08-01","2023-08-01",1,12000,180,{"$f":"D12*14%","v":1680.0000000000002},{"$f":"F12+E12+D12","v":13860},null,null,null,13860]
["2023-09-01","2023-09-01",0,12000,0,{"$f":"D13*14%","v":1680.0000000000002},{"$f":"F13+E13+D13","v":13680},null,null,null,13680]
["2023-10-01","2023-10-01",{"$error":"#NUM!"},"0",{"$error":"#NUM!"},{"$f":"D14*14%","v":0},{"$f":"F14+E14+D14","v":{"$error":"#NUM!"}},null,null,null,"0"]
["2023-11-01","2023-11-01",{"$error":"#NUM!"},"0",null,{"$f":"D15*14%","v":0},{"$f":"F15+E15+D15","v":0},null,null,null,0]
["2023-12-01","2023-12-01",{"$error":"#NUM!"},"0",null,{"$f":"D16*14%","v":0},{"$f":"F16+E16+D16","v":0},null,null,null,0]
["2024-01-01","2024-01-01",{"$error":"#NUM!"},"0",null,{"$f":"D17*14%","v":0},{"$f":"F17+E17+D17","v":0},null,null,null,0]
[null,null,null,null,null,{"$f":"D18*14%","v":0},{"$f":"F18+E18+D18","v":0},null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"ورقة2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ورقة3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}