{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,6,1,10]]}
["PAYé",1429,null,null,null,null,"انتيجة المتوقعة لو ادخلنا مبلغ في الخلية B1 وكانت خلايا العمود C فارغة او اصغر من خلايا العمود B مثلا ادخلنا مبلغ 1429 في B1  والنتيجة في الملون بالاحمر"]
[]
[]
["periode","montant","payé","reste","date",null,"periode","montant","payé","reste","date"]
["2019-01-01",123,{"$f":"IF(SUM($B$5:$B5)<=$B$1,$B5,IF($B$1=SUM($C$4:$C4),\"\",$B$1-SUM($C$4:$C4)))","v":123},{"$f":"B5-SUM(C5)","v":0},null,null,"2019-01-01",123,123,{"$f":"H5-I5","v":0},"2019-10-24"]
["2019-02-01",522,{"$f":"IF(SUM($B$5:$B6)<=$B$1,$B6,IF($B$1=SUM($C$4:$C5),\"\",$B$1-SUM($C$4:$C5)))","v":522},{"$f":"B6-SUM(C6)","v":0},null,null,"2019-02-01",522,522,{"$f":"H6-I6","v":0},"2019-10-24"]
["2019-03-01",333,{"$f":"IF(SUM($B$5:$B7)<=$B$1,$B7,IF($B$1=SUM($C$4:$C6),\"\",$B$1-SUM($C$4:$C6)))","v":333},0,null,null,"2019-03-01",333,333,0,"2019-10-24"]
["2019-04-01",451,{"$f":"IF(SUM($B$5:$B8)<=$B$1,$B8,IF($B$1=SUM($C$4:$C7),\"\",$B$1-SUM($C$4:$C7)))","v":451},0,null,null,"2019-04-01",451,451,0,"2019-10-24"]
["2019-05-01",620,{"$f":"IF(SUM($B$5:$B9)<=$B$1,$B9,IF($B$1=SUM($C$4:$C8),\"\",$B$1-SUM($C$4:$C8)))","v":""},620,null,null,"2019-05-01",620,null,620]
["2019-06-01",700,{"$f":"IF(SUM($B$5:$B10)<=$B$1,$B10,IF($B$1=SUM($C$4:$C9),\"\",$B$1-SUM($C$4:$C9)))","v":""},700,null,null,"2019-06-01",700,null,700]
["2019-07-01",640,{"$f":"IF(SUM($B$5:$B11)<=$B$1,$B11,IF($B$1=SUM($C$4:$C10),\"\",$B$1-SUM($C$4:$C10)))","v":""},640,null,null,"2019-07-01",640,null,640]
["2019-08-01",211,{"$f":"IF(SUM($B$5:$B12)<=$B$1,$B12,IF($B$1=SUM($C$4:$C11),\"\",$B$1-SUM($C$4:$C11)))","v":""},211,null,null,"2019-08-01",211,null,211]
["2019-09-01",147,{"$f":"IF(SUM($B$5:$B13)<=$B$1,$B13,IF($B$1=SUM($C$4:$C12),\"\",$B$1-SUM($C$4:$C12)))","v":""},147,null,null,"2019-09-01",147,null,147]
["2019-10-01",854,{"$f":"IF(SUM($B$5:$B14)<=$B$1,$B14,IF($B$1=SUM($C$4:$C13),\"\",$B$1-SUM($C$4:$C13)))","v":""},854,null,null,"2019-10-01",854,null,854]
["2019-11-01",852,{"$f":"IF(SUM($B$5:$B15)<=$B$1,$B15,IF($B$1=SUM($C$4:$C14),\"\",$B$1-SUM($C$4:$C14)))","v":""},852,null,null,"2019-11-01",852,null,852]
["2019-12-01",222,{"$f":"IF(SUM($B$5:$B16)<=$B$1,$B16,IF($B$1=SUM($C$4:$C15),\"\",$B$1-SUM($C$4:$C15)))","v":""},222,null,null,"2019-12-01",222,null,222]
["2020-01-01",125,{"$f":"IF(SUM($B$5:$B17)<=$B$1,$B17,IF($B$1=SUM($C$4:$C16),\"\",$B$1-SUM($C$4:$C16)))","v":""},125,null,null,"2020-01-01",125,null,125]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}