{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Facture","Feuil1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":"Facture","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["DATE RECEPTION FACTURE","FOURNISSEURS"," MONTANT TOTAL","DERNIER DELAI DE PAIEMENT","PAIEMENT","Jours avant échéance","DATE OF PAYMENT COMMENTS","Délai"]
["2017-12-01","WWW",400,"2017-12-31",null,{"$f":"+IF(D2=\"\",\"\",D2-TODAY())","v":-12},{"$f":"IF(AND(AND(C2<>0,E2<>0),C2=E2),\"Payment Done\",IF(F2=\"\",\"\",IF(F2<0,\"Payment Date Expired \"&-F2&\" Days Ago\",IF(F2=0,\"Must Be Paid Today\",IF(F2<=7,\"Urgent Must Be Paid before \"&F2&\" Days\",F2&\" Days Before Payment Deadline\")))))","v":"Payment Date Expired 12 Days Ago"},{"$f":"D2-TODAY()","v":-12}]
["2017-12-01","XXX",320,"2018-06-30",null,{"$f":"+IF(D3=\"\",\"\",D3-TODAY())","v":169},{"$f":"IF(AND(AND(C3<>0,E3<>0),C3=E3),\"Payment Done\",IF(F3=\"\",\"\",IF(F3<0,\"Payment Date Expired \"&-F3&\" Days Ago\",IF(F3=0,\"Must Be Paid Today\",IF(F3<=7,\"Urgent Must Be Paid before \"&F3&\" Days\",F3&\" Days Before Payment Deadline\")))))","v":"169 Days Before Payment Deadline"},{"$f":"D3-TODAY()","v":169}]
["2017-12-05","WWW",250,"2018-01-07",null,{"$f":"+IF(D4=\"\",\"\",D4-TODAY())","v":-5},{"$f":"IF(AND(AND(C4<>0,E4<>0),C4=E4),\"Payment Done\",IF(F4=\"\",\"\",IF(F4<0,\"Payment Date Expired \"&-F4&\" Days Ago\",IF(F4=0,\"Must Be Paid Today\",IF(F4<=7,\"Urgent Must Be Paid before \"&F4&\" Days\",F4&\" Days Before Payment Deadline\")))))","v":"Payment Date Expired 5 Days Ago"},{"$f":"D4-TODAY()","v":-5}]
["2017-12-07","FFF",100,"2018-02-25",null,{"$f":"+IF(D5=\"\",\"\",D5-TODAY())","v":44},{"$f":"IF(AND(AND(C5<>0,E5<>0),C5=E5),\"Payment Done\",IF(F5=\"\",\"\",IF(F5<0,\"Payment Date Expired \"&-F5&\" Days Ago\",IF(F5=0,\"Must Be Paid Today\",IF(F5<=7,\"Urgent Must Be Paid before \"&F5&\" Days\",F5&\" Days Before Payment Deadline\")))))","v":"44 Days Before Payment Deadline"},{"$f":"D5-TODAY()","v":44}]
["2017-12-12","TTT",125,"2018-02-12",null,{"$f":"+IF(D6=\"\",\"\",D6-TODAY())","v":31},{"$f":"IF(AND(AND(C6<>0,E6<>0),C6=E6),\"Payment Done\",IF(F6=\"\",\"\",IF(F6<0,\"Payment Date Expired \"&-F6&\" Days Ago\",IF(F6=0,\"Must Be Paid Today\",IF(F6<=7,\"Urgent Must Be Paid before \"&F6&\" Days\",F6&\" Days Before Payment Deadline\")))))","v":"31 Days Before Payment Deadline"},{"$f":"D6-TODAY()","v":31}]
["2017-12-15","KKK",135,"2018-02-25",null,{"$f":"+IF(D7=\"\",\"\",D7-TODAY())","v":44},{"$f":"IF(AND(AND(C7<>0,E7<>0),C7=E7),\"Payment Done\",IF(F7=\"\",\"\",IF(F7<0,\"Payment Date Expired \"&-F7&\" Days Ago\",IF(F7=0,\"Must Be Paid Today\",IF(F7<=7,\"Urgent Must Be Paid before \"&F7&\" Days\",F7&\" Days Before Payment Deadline\")))))","v":"44 Days Before Payment Deadline"},{"$f":"D7-TODAY()","v":44}]
["2017-12-22","TTT",330,"2018-08-31",null,{"$f":"+IF(D8=\"\",\"\",D8-TODAY())","v":231},{"$f":"IF(AND(AND(C8<>0,E8<>0),C8=E8),\"Payment Done\",IF(F8=\"\",\"\",IF(F8<0,\"Payment Date Expired \"&-F8&\" Days Ago\",IF(F8=0,\"Must Be Paid Today\",IF(F8<=7,\"Urgent Must Be Paid before \"&F8&\" Days\",F8&\" Days Before Payment Deadline\")))))","v":"231 Days Before Payment Deadline"},{"$f":"D8-TODAY()","v":231}]
["2018-01-01","AAA",750,"2018-01-20",null,{"$f":"+IF(D9=\"\",\"\",D9-TODAY())","v":8},{"$f":"IF(AND(AND(C9<>0,E9<>0),C9=E9),\"Payment Done\",IF(F9=\"\",\"\",IF(F9<0,\"Payment Date Expired \"&-F9&\" Days Ago\",IF(F9=0,\"Must Be Paid Today\",IF(F9<=7,\"Urgent Must Be Paid before \"&F9&\" Days\",F9&\" Days Before Payment Deadline\")))))","v":"8 Days Before Payment Deadline"},{"$f":"D9-TODAY()","v":8}]
["2018-01-01","HHH",450,"2018-01-25",450,{"$f":"+IF(D10=\"\",\"\",D10-TODAY())","v":13},{"$f":"IF(AND(AND(C10<>0,E10<>0),C10=E10),\"Payment Done\",IF(F10=\"\",\"\",IF(F10<0,\"Payment Date Expired \"&-F10&\" Days Ago\",IF(F10=0,\"Must Be Paid Today\",IF(F10<=7,\"Urgent Must Be Paid before \"&F10&\" Days\",F10&\" Days Before Payment Deadline\")))))","v":"Payment Done"},{"$f":"D10-TODAY()","v":13}]
["2018-01-01","CCC",350,"2018-03-21",null,{"$f":"+IF(D11=\"\",\"\",D11-TODAY())","v":68},{"$f":"IF(AND(AND(C11<>0,E11<>0),C11=E11),\"Payment Done\",IF(F11=\"\",\"\",IF(F11<0,\"Payment Date Expired \"&-F11&\" Days Ago\",IF(F11=0,\"Must Be Paid Today\",IF(F11<=7,\"Urgent Must Be Paid before \"&F11&\" Days\",F11&\" Days Before Payment Deadline\")))))","v":"68 Days Before Payment Deadline"},{"$f":"D11-TODAY()","v":68}]
["2018-01-05","BBB",200,"2018-02-07",null,{"$f":"+IF(D12=\"\",\"\",D12-TODAY())","v":26},{"$f":"IF(AND(AND(C12<>0,E12<>0),C12=E12),\"Payment Done\",IF(F12=\"\",\"\",IF(F12<0,\"Payment Date Expired \"&-F12&\" Days Ago\",IF(F12=0,\"Must Be Paid Today\",IF(F12<=7,\"Urgent Must Be Paid before \"&F12&\" Days\",F12&\" Days Before Payment Deadline\")))))","v":"26 Days Before Payment Deadline"},{"$f":"D12-TODAY()","v":26}]
["2018-01-07","DDD",150,"2018-01-31",null,{"$f":"+IF(D13=\"\",\"\",D13-TODAY())","v":19},{"$f":"IF(AND(AND(C13<>0,E13<>0),C13=E13),\"Payment Done\",IF(F13=\"\",\"\",IF(F13<0,\"Payment Date Expired \"&-F13&\" Days Ago\",IF(F13=0,\"Must Be Paid Today\",IF(F13<=7,\"Urgent Must Be Paid before \"&F13&\" Days\",F13&\" Days Before Payment Deadline\")))))","v":"19 Days Before Payment Deadline"},{"$f":"D13-TODAY()","v":19}]
["2018-01-12","MMM",120,"2018-02-12",null,{"$f":"+IF(D14=\"\",\"\",D14-TODAY())","v":31},{"$f":"IF(AND(AND(C14<>0,E14<>0),C14=E14),\"Payment Done\",IF(F14=\"\",\"\",IF(F14<0,\"Payment Date Expired \"&-F14&\" Days Ago\",IF(F14=0,\"Must Be Paid Today\",IF(F14<=7,\"Urgent Must Be Paid before \"&F14&\" Days\",F14&\" Days Before Payment Deadline\")))))","v":"31 Days Before Payment Deadline"},{"$f":"D14-TODAY()","v":31}]
["2018-01-12","BBB",230,"2018-08-31",null,{"$f":"+IF(D15=\"\",\"\",D15-TODAY())","v":231},{"$f":"IF(AND(AND(C15<>0,E15<>0),C15=E15),\"Payment Done\",IF(F15=\"\",\"\",IF(F15<0,\"Payment Date Expired \"&-F15&\" Days Ago\",IF(F15=0,\"Must Be Paid Today\",IF(F15<=7,\"Urgent Must Be Paid before \"&F15&\" Days\",F15&\" Days Before Payment Deadline\")))))","v":"231 Days Before Payment Deadline"},{"$f":"D15-TODAY()","v":231}]

{"sheet":"Feuil1","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Étiquettes de lignes"]
["2017"]
["déc"]
["Total général"]