{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["FACTURES","SAV","Contentieux"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"FACTURES","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["N° facture","Date facture","Relance 1","Relance 2","Montant","Année facture"]
["2018-099","2018-12-01",{"$f":"DATE(YEAR(B2),MONTH(B2)+3,DAY(B2))","v":"2019-03-01"},{"$f":"DATE(YEAR(C2),MONTH(C2)+6,DAY(C2))","v":"2019-09-01"},276.92423812323506,{"$f":"YEAR(B2)","v":2018}]
["2019-007","2019-01-01",{"$f":"DATE(YEAR(B3),MONTH(B3)+3,DAY(B3))","v":"2019-04-01"},{"$f":"DATE(YEAR(C3),MONTH(C3)+6,DAY(C3))","v":"2019-10-01"},820.12993334906218,2019]
["2019-071","2019-08-01","2019-11-01","2020-05-01",981.02419649510205,2019]
["2019-093","2019-11-01","2020-02-01","2020-08-01",571.70580736704051,2019]
["2019-022","2019-03-01","2019-06-01","2019-12-01",707.40242113933277,2019]
["2019-065","2019-08-01","2019-11-01","2020-05-01",610.50500938768914,2019]
["2018-009","2018-02-01","2018-05-01","2018-11-01",413.77101280455707,2018]
["2018-093","2018-11-01","2019-02-01","2019-08-01",0,2018]
["2017-095","2017-11-01","2018-02-01","2018-08-01",710.70341436823537,2017]
["2018-076","2018-09-01","2018-12-01","2019-06-01",29.559510439513659,{"$f":"YEAR(B11)","v":2018}]
["2019-023","2019-03-01","2019-06-01","2019-12-01",849.96077839758129,2019]
["2019-048","2019-06-01","2019-09-01","2020-03-01",676.13164264623288,2019]
["2018-007","2018-01-01","2018-04-01","2018-10-01",884.26960829170139,2018]
["2018-009","2018-02-01","2018-05-01","2018-11-01",0,2018]
["2018-094","2018-11-01","2019-02-01","2019-08-01",345.4306645841765,2018]
["2019-052","2019-06-01","2019-09-01","2020-03-01",934.06115170439557,2019]
["2018-015","2018-02-01","2018-05-01","2018-11-01",67.62977426239236,2018]
["2018-061","2018-07-01","2018-10-01","2019-04-01",0,2018]
["2018-096","2018-11-01","2019-02-01","2019-08-01",685.883881197243,2018]
["2019-074","2019-09-01","2019-12-01","2020-06-01",625.89788886840483,2019]
["2019-043","2019-05-01","2019-08-01","2020-02-01",500.18942865363681,2019]
["2017-031","2017-04-01","2017-07-01","2018-01-01",154.4935766035982,2017]
["2017-074","2017-09-01","2017-12-01","2018-06-01",438.60089363754895,2017]
["2017-047","2017-06-01","2017-09-01","2018-03-01",492.74282393785131,2017]
["2018-005","2018-01-01","2018-04-01","2018-10-01",0,2018]
["2018-022","2018-03-01","2018-06-01","2018-12-01",167.79912585090796,2018]

{"sheet":"SAV","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["N° facture","Date facture","Date relance R1","Date relance R2","Solde au 31/12/2009","Année facture"]
["2008-099","2008-12-01",{"$f":"DATE(YEAR(B2),MONTH(B2),DAY(B2)+15)","v":"2008-12-16"},"2008-12-31",276.92423812323506,{"$f":"YEAR(B2)","v":2008}]
["2009-007","2009-01-01","2009-01-16","2009-01-31",820.12993334906218,2009]
["2009-071","2009-08-01","2009-08-16","2009-08-31",981.02419649510205,2009]
["2009-093","2009-11-01","2009-11-16","2009-12-01",571.70580736704051,2009]
["2009-022","2009-03-01","2009-03-16","2009-03-31",707.40242113933277,2009]
["2009-065","2009-08-01","2009-08-16","2009-08-31",610.50500938768914,2009]
["2008-009","2008-02-01","2008-02-16","2008-03-02",413.77101280455707,2008]
["2008-093","2008-11-01","2008-11-16","2008-12-01",0,2008]
["2007-095","2007-11-01","2007-11-16","2007-12-01",710.70341436823537,2007]
["2008-076","2008-09-01",{"$f":"DATE(YEAR(B11),MONTH(B11),DAY(B11)+15)","v":"2008-09-16"},{"$f":"DATE(YEAR(C11),MONTH(C11),DAY(C11)+15)","v":"2008-10-01"},29.559510439513659,{"$f":"YEAR(B11)","v":2008}]
["2009-023","2009-03-01",{"$f":"DATE(YEAR(B12),MONTH(B12),DAY(B12)+15)","v":"2009-03-16"},"2009-03-31",849.96077839758129,2009]
["2009-048","2009-06-01","2009-06-16","2009-07-01",676.13164264623288,2009]
["2008-007","2008-01-01","2008-01-16","2008-01-31",884.26960829170139,2008]
["2008-009","2008-02-01","2008-02-16","2008-03-02",0,2008]
["2008-094","2008-11-01","2008-11-16","2008-12-01",345.4306645841765,2008]
["2009-052","2009-06-01","2009-06-16","2009-07-01",934.06115170439557,2009]
["2008-015","2008-02-01","2008-02-16","2008-03-02",67.62977426239236,2008]
["2008-061","2008-07-01","2008-07-16","2008-07-31",0,2008]
["2008-096","2008-11-01","2008-11-16","2008-12-01",685.883881197243,2008]
["2009-074","2009-09-01","2009-09-16","2009-10-01",625.89788886840483,2009]
["2009-043","2009-05-01","2009-05-16","2009-05-31",500.18942865363681,2009]
["2007-031","2007-04-01","2007-04-16","2007-05-01",154.4935766035982,2007]
["2007-074","2007-09-01","2007-09-16","2007-10-01",438.60089363754895,2007]
["2007-047","2007-06-01","2007-06-16","2007-07-01",492.74282393785131,2007]
["2008-005","2008-01-01","2008-01-16","2008-01-31",0,2008]
["2008-022","2008-03-01","2008-03-16","2008-03-31",167.79912585090796,2008]

{"sheet":"Contentieux","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["N° facture","Date facture","Relance 1","Relance 2","Montant","Année facture"]
["2018-099","2018-12-01","2019-03-01","2019-09-01",276.92423812323506,2018]
["2018-009","2018-02-01","2018-05-01","2018-11-01",413.77101280455707,2018]
["2018-093","2018-11-01","2019-02-01","2019-08-01",0,2018]
["2017-095","2017-11-01","2018-02-01","2018-08-01",710.70341436823537,2017]
["2018-076","2018-09-01","2018-12-01","2019-06-01",29.559510439513659,2018]
["2018-007","2018-01-01","2018-04-01","2018-10-01",884.26960829170139,2018]
["2018-009","2018-02-01","2018-05-01","2018-11-01",0,2018]
["2018-094","2018-11-01","2019-02-01","2019-08-01",345.4306645841765,2018]
["2018-015","2018-02-01","2018-05-01","2018-11-01",67.62977426239236,2018]
["2018-061","2018-07-01","2018-10-01","2019-04-01",0,2018]
["2018-096","2018-11-01","2019-02-01","2019-08-01",685.883881197243,2018]
["2017-031","2017-04-01","2017-07-01","2018-01-01",154.4935766035982,2017]
["2017-074","2017-09-01","2017-12-01","2018-06-01",438.60089363754895,2017]
["2017-047","2017-06-01","2017-09-01","2018-03-01",492.74282393785131,2017]
["2018-005","2018-01-01","2018-04-01","2018-10-01",0,2018]
["2018-022","2018-03-01","2018-06-01","2018-12-01",167.79912585090796,2018]