{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Liste des factures","Générateur saisie de CA","BDD comptes auxiliaires"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Liste des factures","index":0,"n_rows":181,"n_cols":12,"rows_kept":181,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Liste des factures Neuilly",null,null,null,"Année 2017"]
[]
["N°Facture","Document","Client","Période","Date","Montant ","Statut","Mode de paiement","Moyen"]
["1701NE01","- Facture -","CLIENT 1","T1 2017","2017-01-10",1,"Payée","virement"]
["1701NE02","- Facture -","CLIENT 2","2017-01-01","2017-01-01",2,"Payée","Prélèvement"]
["1701NE03","- Facture -","CLIENT 3","2017-01-01","2017-01-01",3,"Payée","Prélèvement"]
["1701NE04","- Facture -","CLIENT 4","T1 2017","T1 2017",4,"Payée","virement"]
["1701NE05","- Facture -","CLIENT 5","T1 2017","T1 2017",5,"Payée","Prélèvement"]
["1701NE06","- Facture -","CLIENT 6","2017-01-01","2017-01-01",6,"Payée","Prélèvement"]
["1701NE07","- Facture -","CLIENT 7","2017-01-01","2017-01-01",7,"Payée","Prélèvement"]
["1701NE08","- Facture -","CLIENT 8","T1 2017","T1 2017",8,"Payée","virement"]
["1701NE09","- Facture -","CLIENT 9","T1 2017","T1 2017",9,"Payée","Prélèvement"]
["1701NE10","- Facture -","CLIENT 10","Année 2017","Année 2017",10,"Payée","chèque"]
["1701NE11","- Facture -","CLIENT 11","2017-01-01","2017-01-01",11,"Payée","Prélèvement"]
["1701NE12","- Facture -","CLIENT 12","2017-03-01","2017-03-01",12,"Payée","Prélèvement"]
["1702NE01","- Facture -","CLIENT 13","2017-02-01","2017-02-10",13,"Payée","Prélèvement"]
["1702NE02","- Facture -","CLIENT 14","2017-02-01","2017-02-10",14,"Payée","Prélèvement"]
["1702NE03","- Facture -","CLIENT 15","2017-02-01","2017-02-10",15,"Payée","Prélèvement"]
["1702NE04","- Facture -","CLIENT 16","2017-02-01","2017-02-10",16,"Payée","Prélèvement"]
["1702NE05","- Facture -","CLIENT 17","2017-02-01","2017-02-10",17,"Payée","Prélèvement"]
["1703NE01","- Facture -","CLIENT 18","2017-03-01","2017-03-10",18,"Payée","Prélèvement"]
["1703NE02","- Facture -","CLIENT 19","2017-03-01","2017-03-10",19,"Payée","Prélèvement"]
["1703NE03","- Facture -","CLIENT 20","2017-03-01","2017-03-10",20,"Payée","Prélèvement"]
["1703NE04","- Facture -","CLIENT 21","2017-03-01","2017-03-10",21,"Payée","Prélèvement"]
["1703NE05","- Facture -","CLIENT 22","2017-03-01","2017-03-10",22,"Payée","Prélèvement"]
["1703NE06","- Facture -","CLIENT 23","2017-03-01","2017-03-10",23,"Payée","Prélèvement"]
["1704NE01","- Facture -","CLIENT 24","T2 2017","2017-04-10",24,"Payée","virement"]
["1704NE02","- Facture -","CLIENT 25","T2 2017","2017-04-10",25,"Payée","virement"]
["1704NE03","- Facture -","CLIENT 26","2017-04-01","2017-04-10",26,"Payée","Prélèvement"]
["1704NE04","- Facture -","CLIENT 27","T2 2017","2017-04-10",27,"Payée","virement"]
["1704NE05","- Facture -","CLIENT 28","2017-04-01","2017-04-10",28,"Payée","Prélèvement"]
["1704NE06","- Facture -","CLIENT 29","T2 2017","2017-04-10",29,"Payée","Prélèvement"]
["1704NE07","- Facture -","CLIENT 30","2017-04-01","2017-04-10",30,"Payée","Prélèvement"]
["1704NE08","- Facture -","CLIENT 31","2017-04-01","2017-04-10",31,"Payée","Prélèvement"]
["1704NE09","- Facture -","CLIENT 32","T2 2017","2017-04-10",32,"Payée","Prélèvement"]
["1704NE10","- Facture -","CLIENT 33","2017-04-01","2017-04-10",33,"Payée","Prélèvement"]
["1704NE11","- Facture -","CLIENT 34","2017-04-01","2017-04-10",34,"Payée","Prélèvement"]
["1704NE12","- Facture -","CLIENT 35","2017-04-01","2017-04-10",35,"Payée","Prélèvement"]
["1705NE01","- Facture -","CLIENT 36","2017-05-01","2017-05-10",36,"Payée","Prélèvement"]
["1705NE02","- Facture -","CLIENT 37","2017-05-01","2017-05-10",37,"Payée",{"$f":"VLOOKUP(C40,$C$4:$H39,6,FALSE)","v":{"$error":"#N/A"}}]
["1705NE03","- Facture -","CLIENT 38","2017-05-01","2017-05-10",38,"Payée",{"$f":"VLOOKUP(C41,$C$4:$H40,6,FALSE)","v":{"$error":"#N/A"}}]
["1705NE04","- Facture -","CLIENT 39","2017-05-01","2017-05-10",39,"Payée",{"$f":"VLOOKUP(C42,$C$4:$H41,6,FALSE)","v":{"$error":"#N/A"}}]
["1705NE05","- Facture -","CLIENT 40","2017-09-01","2017-05-10",40,"Payée","Prélèvement"]
["1705NE06","- Facture -","CLIENT 41","2017-05-01","2017-05-10",41,"Payée",{"$f":"VLOOKUP(C44,$C$4:$H43,6,FALSE)","v":{"$error":"#N/A"}}]
["1705NE07","- Facture -","CLIENT 42","2017-05-01","2017-05-10",42,"Payée",{"$f":"VLOOKUP(C45,$C$4:$H44,6,FALSE)","v":{"$error":"#N/A"}}]
["1705NE08","- Facture -","CLIENT 43","2017-05-01","2017-05-10",43,"Payée",{"$f":"VLOOKUP(C46,$C$4:$H45,6,FALSE)","v":{"$error":"#N/A"}}]
["1705NE09","- Facture -","CLIENT 44","2017-05-01","2017-05-10",44,"Payée",{"$f":"VLOOKUP(C47,$C$4:$H46,6,FALSE)","v":{"$error":"#N/A"}}]
["1706NE01","- Facture -","CLIENT 45","T1 et T2 2017","2017-06-13",45,"envoyée","virement"]
["1706NE02","- Facture -","CLIENT 46","2017-06-01","2017-06-10",46,"Payée",{"$f":"VLOOKUP(C49,$C$4:$H48,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1706NE03","- Facture -","CLIENT 47","2017-06-01","2017-06-10",47,"Payée",{"$f":"VLOOKUP(C50,$C$4:$H49,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1706NE04","- Facture -","CLIENT 48","2017-06-01","2017-06-10",48,"Payée",{"$f":"VLOOKUP(C51,$C$4:$H50,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1706NE05","- Facture -","CLIENT 49","2017-06-01","2017-06-10",49,"Payée",{"$f":"VLOOKUP(C52,$C$4:$H51,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17",null,"total a fin avril",{"$f":"SUM(F4:F38)","v":630}]
["1706NE06","- Facture -","CLIENT 50","2017-06-01","2017-06-10",50,"Payée",{"$f":"VLOOKUP(C53,$C$4:$H52,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1706NE07","- Facture -","CLIENT 51","2017-06-01","2017-06-10",51,"Payée",{"$f":"VLOOKUP(C54,$C$4:$H53,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1706NE08","- Facture -","CLIENT 52","2017-06-01","2017-06-10",52,"Payée",{"$f":"VLOOKUP(C55,$C$4:$H54,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1706NE09","- Facture -","CLIENT 53","ACOMPTE 09/17","2017-06-10",53,"Payée","virement","viré le 01/8/17"]
["1706NE10","- Facture -","CLIENT 54","ACOMPTE 09/17","2017-06-10",54,"Payée","Prélèvement","PRLVT LE 27/6/17"]
["1706NE11","- Facture -","CLIENT 55","2017-06-01","2017-06-10",55,"Payée",{"$f":"VLOOKUP(C58,$C$4:$H57,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 27/6/17"]
["1707NE01","- Facture -","CLIENT 56","T3 2017","2017-07-10",56,"Payée",{"$f":"VLOOKUP(C59,$C$4:$H58,6,FALSE)","v":{"$error":"#N/A"}},"viré 3000€ le 31/8/17"]
["1707NE02","- Facture -","CLIENT 57","Acompte Septembre - Octobre 2017","2017-07-10",57,"Payée","chèque","Chèque déposé le 15/7/17"]
["1707NE03","- Facture -","CLIENT 58","T3 2017","2017-07-10",58,"Payée",{"$f":"VLOOKUP(C61,$C$4:$H60,6,FALSE)","v":{"$error":"#N/A"}},"VIRE LE 12/9/17"]
["1707NE04","- Facture -","CLIENT 59","2017-07-01","2017-07-10",59,"Payée",{"$f":"VLOOKUP(C62,$C$4:$H61,6,FALSE)","v":{"$error":"#N/A"}},"PRLVE LE 28/7/17"]
["1707NE05","- Facture -","CLIENT 60","2017-07-01","2017-07-10",60,"Payée",{"$f":"VLOOKUP(C63,$C$4:$H62,6,FALSE)","v":{"$error":"#N/A"}},"PRLVE LE 28/7/17"]
["1707NE06","- Facture -","CLIENT 61","Acompte Août - Septembre 2017","2017-07-10",61,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE07","- Facture -","CLIENT 62","T3 2017","2017-07-10",62,"Payée",{"$f":"VLOOKUP(C65,$C$4:$H64,6,FALSE)","v":{"$error":"#N/A"}},"viré le 31/8/17"]
["1707NE08","- Facture -","CLIENT 63","Acompte Février 2018","2017-07-10",63,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE09","- Facture -","CLIENT 64","2017-07-01","2017-07-10",64,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE10","- Facture -","CLIENT 65","T3 2017","2017-07-10",65,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE11","- Facture -","CLIENT 66","2017-07-01","2017-07-10",66,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE12","- Facture -","CLIENT 67","2017-07-01","2017-07-10",67,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE13","- Facture -","CLIENT 68","2017-07-01","2017-07-10",68,"envoyée",{"$f":"VLOOKUP(C71,$C$4:$H70,6,FALSE)","v":{"$error":"#N/A"}},"rejeté le 28/7-reprélevé le 15/9-rerejeté le 18/9"]
["1707NE14","- Facture -","CLIENT 69","2017-07-01","2017-07-10",69,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE15","- Facture -","CLIENT 70","T3 2017","2017-07-10",70,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE16","- Facture -","CLIENT 71","Acompte Octobre - Novembre 2017","2017-07-10",71,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE17","- Facture -","CLIENT 72","Mai à Juillet 2017","2017-07-10",72,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE18","- Facture -","CLIENT 73","Mai à Septembre 2017","2017-07-10",73,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE19","- Facture -","CLIENT 74","Acompte Août - Septembre 2017","2017-07-10",74,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE20","- Facture -","CLIENT 75","2017-07-01","2017-07-10",75,"Payée","Prélèvement","PRLVE LE 28/7/17"]
["1707NE21","- Facture -","CLIENT 76","Acompte Octobre 2017","2017-07-10",76,"Payée",{"$f":"VLOOKUP(C79,$C$4:$H78,6,FALSE)","v":{"$error":"#N/A"}},"PRLVE LE 28/7/17"]
["1707NE22","- Avoir -","CLIENT 77","Avoir sur 1707NE01 pour annuler SEPT","2017-07-10",77,"Payée",{"$f":"VLOOKUP(C80,$C$4:$H79,6,FALSE)","v":{"$error":"#N/A"}},"viré 3000€ le 31/8/17"]
["1708NE01","- Facture -","CLIENT 78","T3 2017","2017-08-10",78,"Payée","virement","viré le 03/11/17 - 42251,66€"]
["1708NE02","- Facture -","CLIENT 79","T3 2017","2017-08-10",79,"Payée","virement","Viré le 19/10/17"]
["1708NE03","- Facture -","CLIENT 80","T3 2017","2017-08-10",80,"Payée","virement","viré le 6/11/17 sur LPC1 Ce avec la facture aeroville : 5582,67€"]
["1708NE04","- Facture -","CLIENT 81","T3 2017","2017-08-10",81,"Payée","virement","VIRE LE 5/10/17 SUR lpc1 ce"]
["1708NE05","- Facture -","CLIENT 82","2017-08-01","2017-08-10",82,"Payée",{"$f":"VLOOKUP(C85,$C$4:$H84,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE06","- Facture -","CLIENT 83","2017-08-01","2017-08-10",83,"Payée",{"$f":"VLOOKUP(C86,$C$4:$H85,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE07","- Facture -","CLIENT 84","2017-08-01","2017-08-10",84,"Payée",{"$f":"VLOOKUP(C87,$C$4:$H86,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE08","- Facture -","CLIENT 85","2017-08-01","2017-08-10",85,"Payée",{"$f":"VLOOKUP(C88,$C$4:$H87,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE09","- Facture -","CLIENT 86","2017-08-01","2017-08-10",86,"Payée",{"$f":"VLOOKUP(C89,$C$4:$H88,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE10","- Facture -","CLIENT 87","2017-08-01","2017-08-10",87,"envoyée",{"$f":"VLOOKUP(C90,$C$4:$H89,6,FALSE)","v":{"$error":"#N/A"}},"rejeté le 18/9"]
["1708NE11","- Facture -","CLIENT 88","2017-08-01","2017-08-10",88,"Payée",{"$f":"VLOOKUP(C91,$C$4:$H90,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE12","- Facture -","CLIENT 89","2017-08-01","2017-08-10",89,"Payée",{"$f":"VLOOKUP(C92,$C$4:$H91,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE13","- Facture -","CLIENT 90","2017-08-01","2017-08-10",90,"Payée",{"$f":"VLOOKUP(C93,$C$4:$H92,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 18/09/2017"]
["1708NE14","- Facture -","CLIENT 91","S2 2017","2017-08-10",91,"Payée","virement","viré le 10/10/17"]
["1709NE01","- Facture -","CLIENT 92","2017-09-01","2017-09-10",92,"Payée","Prélèvement","PRLVT LE 10/10/2017"]
["1709NE02","- Facture -","CLIENT 93","2017-09-01","2017-09-10",93,"Payée",{"$f":"VLOOKUP(C96,$C$4:$H95,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 10/10/2017"]
["1709NE03","- Facture -","CLIENT 94","2017-09-01","2017-09-10",94,"Payée",{"$f":"VLOOKUP(C97,$C$4:$H96,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 10/10/2017"]
["1709NE04","- Facture -","CLIENT 95","2017-09-01","2017-09-10",95,"Payée",{"$f":"VLOOKUP(C98,$C$4:$H97,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 10/10/2017"]
["1709NE05","- Facture -","CLIENT 96","2017-09-01","2017-09-10",96,"Payée",{"$f":"VLOOKUP(C99,$C$4:$H98,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 10/10/2017"]
["1709NE06","- Facture -","CLIENT 97","2017-09-01","2017-09-10",97,"Payée",{"$f":"VLOOKUP(C100,$C$4:$H99,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 10/10/2017"]
["1709NE07","- Facture -","CLIENT 98","2017-09-01","2017-09-10",98,"Payée",{"$f":"VLOOKUP(C101,$C$4:$H100,6,FALSE)","v":{"$error":"#N/A"}},"PRLVT LE 10/10/2017"]
["1709NE08","- Avoir -","CLIENT 99","Avoir sur T3 2017","2017-09-10",99,"Payée","virement","viré le 03/11/17 - 42251,66€"]
["1710NE01","- Avoir -","CLIENT 100","Avoir Acompte FEV 2018","2017-10-10",100,"Payée","virement","viré le 26/10/17"]
["1710NE02","- Avoir -","CLIENT 101","Acompte Septembre - Octobre 2017","2017-10-10",101,"Payée",{"$f":"VLOOKUP(C104,$C$4:$H103,6,FALSE)","v":{"$error":"#N/A"}},"remboursé le 10/11/17 par virement"]
["1710NE03","- Facture -","CLIENT 102","2017-10-01","2017-10-10",102,"Payée",{"$f":"VLOOKUP(C105,$C$4:$H104,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE04","- Facture -","CLIENT 103","T4 2017","2017-10-10",103,"Payée",{"$f":"VLOOKUP(C106,$C$4:$H105,6,FALSE)","v":{"$error":"#N/A"}},"viré le 1/12/17"]
["1710NE05","- Facture -","CLIENT 104","T4 2017","2017-10-10",104,"envoyée",{"$f":"VLOOKUP(C107,$C$4:$H106,6,FALSE)","v":{"$error":"#N/A"}}]
["1710NE06","- Facture -","CLIENT 105","2017-10-01","2017-10-10",105,"Payée",{"$f":"VLOOKUP(C108,$C$4:$H107,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17",null,{"$f":"SUM(K106:K107)","v":0}]
["1710NE07","- Facture -","CLIENT 106","2017-10-01","2017-10-10",106,"Payée",{"$f":"VLOOKUP(C109,$C$4:$H108,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE08","- Facture -","CLIENT 107","Acompte janvier/Février 2018","2017-10-10",107,"Payée","Prélèvement","prlvé le 03/11/17",null,331289.92]
["1710NE09","- Facture -","CLIENT 108","Septembre Octobre 2017","2017-10-10",108,"Payée",{"$f":"VLOOKUP(C111,$C$4:$H110,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17",null,{"$f":"+K110-K108","v":331289.92}]
["1710NE10","- Facture -","CLIENT 109","T4 2017","2017-10-10",109,"Payée",{"$f":"VLOOKUP(C112,$C$4:$H111,6,FALSE)","v":{"$error":"#N/A"}},"Viré le 11/12/2017"]
["1710NE11","- Facture -","CLIENT 110","T4 2017","2017-10-10",110,"envoyée",{"$f":"VLOOKUP(C113,$C$4:$H112,6,FALSE)","v":{"$error":"#N/A"}}]
["1710NE12","- Facture -","CLIENT 111","2017-10-01","2017-10-10",111,"Payée",{"$f":"VLOOKUP(C114,$C$4:$H113,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE13","- Facture -","CLIENT 112","T4 2017","2017-10-10",112,"Payée",{"$f":"VLOOKUP(C115,$C$4:$H114,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE14","- Facture -","CLIENT 113","T4 2017","2017-10-10",113,"envoyée",{"$f":"VLOOKUP(C116,$C$4:$H115,6,FALSE)","v":{"$error":"#N/A"}}]
["1710NE15","- Facture -","CLIENT 114","2017-10-01","2017-10-10",114,"Payée",{"$f":"VLOOKUP(C117,$C$4:$H116,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE16","- Facture -","CLIENT 115","T4 2017","2017-10-10",115,"Payée",{"$f":"VLOOKUP(C118,$C$4:$H117,6,FALSE)","v":{"$error":"#N/A"}},"viré le 14/11/17"]
["1710NE17","- Facture -","CLIENT 116","2017-10-01","2017-10-10",116,"Payée",{"$f":"VLOOKUP(C119,$C$4:$H118,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE18","- Facture -","CLIENT 117","2017-10-01","2017-10-10",117,"Payée",{"$f":"VLOOKUP(C120,$C$4:$H119,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE19","- Facture -","CLIENT 118","T4 2017","2017-10-10",118,"Payée",{"$f":"VLOOKUP(C121,$C$4:$H120,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE20","- Facture -","CLIENT 119","2017-10-01","2017-10-10",119,"Payée",{"$f":"VLOOKUP(C122,$C$4:$H121,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE21","- Facture -","CLIENT 120","Septembre Octobre 2017","2017-10-10",120,"Payée",{"$f":"VLOOKUP(C123,$C$4:$H122,6,FALSE)","v":{"$error":"#N/A"}},"prlvé le 03/11/17"]
["1710NE22","- Facture -","CLIENT 121","T4 2017","2017-10-10",121,"Payée",{"$f":"VLOOKUP(C124,$C$4:$H123,6,FALSE)","v":{"$error":"#N/A"}},"payé le 6/12/17"]
["1711NE01","- Facture -","CLIENT 122","S1 2018","2017-11-10",122,"envoyée","virement"]
["1711NE02","- Facture -","CLIENT 123","2017-11-01","2017-11-10",123,"envoyée",{"$f":"VLOOKUP(C126,$C$4:$H125,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE03","- Facture -","CLIENT 124","2017-11-01","2017-11-10",124,"envoyée",{"$f":"VLOOKUP(C127,$C$4:$H126,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE04","- Facture -","CLIENT 125","2017-11-01","2017-11-10",125,"envoyée",{"$f":"VLOOKUP(C128,$C$4:$H127,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE05","- Facture -","CLIENT 126","2017-11-01","2017-11-10",126,"envoyée",{"$f":"VLOOKUP(C129,$C$4:$H128,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE06","- Facture -","CLIENT 127","2017-11-01","2017-11-10",127,"envoyée",{"$f":"VLOOKUP(C130,$C$4:$H129,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE07","- Facture -","CLIENT 128","2017-11-01","2017-11-10",128,"envoyée",{"$f":"VLOOKUP(C131,$C$4:$H130,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE08","- Facture -","CLIENT 129","2017-11-01","2017-11-10",129,"envoyée",{"$f":"VLOOKUP(C132,$C$4:$H131,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE09","- Facture -","CLIENT 130","2017-11-01","2017-11-10",130,"envoyée",{"$f":"VLOOKUP(C133,$C$4:$H132,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE10","- Facture -","CLIENT 131","2017-11-01","2017-11-10",131,"envoyée",{"$f":"VLOOKUP(C134,$C$4:$H133,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE11","- Facture -","CLIENT 132","2017-11-01","2017-11-10",132,"envoyée",{"$f":"VLOOKUP(C135,$C$4:$H134,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE12","- Facture -","CLIENT 133","2017-11-01","2017-11-10",133,"envoyée",{"$f":"VLOOKUP(C136,$C$4:$H135,6,FALSE)","v":{"$error":"#N/A"}}]
["1711NE13","- Facture -","CLIENT 134","Avoir Acompte Octobre 2017","2017-12-05",134,null,{"$f":"VLOOKUP(C137,$C$4:$H136,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE01","- Facture -","CLIENT 135","2017-12-01","2017-12-10",135,"envoyée",{"$f":"VLOOKUP(C138,$C$4:$H137,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE02","- Facture -","CLIENT 136","2017-12-01","2017-12-10",136,"envoyée",{"$f":"VLOOKUP(C139,$C$4:$H138,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE03","- Facture -","CLIENT 137","2017-12-01","2017-12-10",137,"envoyée",{"$f":"VLOOKUP(C140,$C$4:$H139,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE04","- Facture -","CLIENT 138","2017-12-01","2017-12-10",138,"envoyée",{"$f":"VLOOKUP(C141,$C$4:$H140,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE05","- Facture -","CLIENT 139","2017-12-01","2017-12-10",139,"envoyée",{"$f":"VLOOKUP(C142,$C$4:$H141,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE06","- Facture -","CLIENT 140","2017-12-01","2017-12-10",140,"envoyée",{"$f":"VLOOKUP(C143,$C$4:$H142,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE07","- Facture -","CLIENT 141","2017-12-01","2017-12-10",141,"envoyée",{"$f":"VLOOKUP(C144,$C$4:$H143,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE08","- Facture -","CLIENT 142","2017-12-01","2017-12-10",142,"envoyée",{"$f":"VLOOKUP(C145,$C$4:$H144,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE09","- Facture -","CLIENT 143","2017-12-01","2017-12-10",143,"envoyée",{"$f":"VLOOKUP(C146,$C$4:$H145,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE10","- Facture -","CLIENT 144","2017-12-01","2017-12-10",144,"envoyée",{"$f":"VLOOKUP(C147,$C$4:$H146,6,FALSE)","v":{"$error":"#N/A"}}]
["1712NE11","- Facture -","CLIENT 145","2017-12-01","2017-12-10",145,"envoyée",{"$f":"VLOOKUP(C148,$C$4:$H147,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C149,$C$4:$H148,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C150,$C$4:$H149,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C151,$C$4:$H150,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C152,$C$4:$H151,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C153,$C$4:$H152,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C154,$C$4:$H153,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C155,$C$4:$H154,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C156,$C$4:$H155,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C157,$C$4:$H156,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C158,$C$4:$H157,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C159,$C$4:$H158,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C160,$C$4:$H159,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C161,$C$4:$H160,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C162,$C$4:$H161,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C163,$C$4:$H162,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C164,$C$4:$H163,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C165,$C$4:$H164,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C166,$C$4:$H165,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C167,$C$4:$H166,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C168,$C$4:$H167,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C169,$C$4:$H168,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C170,$C$4:$H169,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C171,$C$4:$H170,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C172,$C$4:$H171,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C173,$C$4:$H172,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C174,$C$4:$H173,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C175,$C$4:$H174,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C176,$C$4:$H175,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C177,$C$4:$H176,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C178,$C$4:$H177,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C179,$C$4:$H178,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C180,$C$4:$H179,6,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C181,$C$4:$H180,6,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"Générateur saisie de CA","index":1,"n_rows":177,"n_cols":17,"rows_kept":177,"cut":false,"hidden":false,"merged":[]}
["Contrepartie auto","Jounal","Compte Général","Compte Auxiliaire","Référence","Libellé","Débit","Crédit","CONCATENER","N°Facture","Document","Client","Période","Date","Montant ","Statut","Mode de paiement"]
[null,"VEN",411000,{"$f":"VLOOKUP(L2,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"CONCATENATE(M2,I2,J2)","v":" - "},{"$f":"L2","v":0},{"$f":"O2","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",{"$f":"L3","v":0},null,{"$f":"O3","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L4,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O4","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O5","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L6,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O6","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O7","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L8,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O8","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O9","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L10,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O10","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O11","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L12,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O12","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O13","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L14,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O14","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O15","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L16,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O16","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O17","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L18,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O18","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O19","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L20,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O20","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O21","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L22,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O22","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O23","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L24,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O24","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O25","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L26,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O26","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O27","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L28,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O28","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O29","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L30,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O30","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O31","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L32,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O32","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O33","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L34,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O34","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O35","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L36,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O36","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O37","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L38,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O38","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O39","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L40,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O40","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O41","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L42,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O42","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O43","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L44,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O44","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O45","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L46,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O46","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O47","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L48,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O48","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O49","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L50,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O50","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O51","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L52,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O52","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O53","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L54,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O54","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O55","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L56,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O56","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O57","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L58,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O58","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O59","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L60,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O60","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O61","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L62,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O62","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O63","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L64,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O64","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O65","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L66,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"CONCATENATE(M66,I66,J66)","v":" - "},0,{"$f":"O66","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",{"$f":"L67","v":0},null,{"$f":"O67","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L68,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O68","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O69","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L70,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O70","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O71","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L72,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O72","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O73","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L74,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O74","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O75","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L76,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O76","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O77","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L78,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O78","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O79","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L80,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O80","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O81","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L82,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O82","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O83","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L84,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O84","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O85","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L86,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O86","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O87","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L88,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O88","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O89","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L90,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O90","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O91","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L92,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O92","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O93","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L94,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O94","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O95","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L96,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O96","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O97","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L98,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O98","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O99","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L100,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O100","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O101","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L102,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O102","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O103","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L104,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O104","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O105","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L106,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O106","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O107","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L108,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O108","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O109","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L110,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O110","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O111","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L112,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O112","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O113","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L114,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O114","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O115","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L116,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O116","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O117","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L118,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O118","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O119","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L120,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O120","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O121","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L122,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O122","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O123","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L124,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O124","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O125","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L126,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O126","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O127","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L128,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O128","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O129","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L130,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"CONCATENATE(M130,I130,J130)","v":" - "},0,{"$f":"O130","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",{"$f":"L131","v":0},null,{"$f":"O131","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L132,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O132","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O133","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L134,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O134","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O135","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L136,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O136","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O137","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L138,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O138","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O139","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L140,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O140","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O141","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L142,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O142","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O143","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L144,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O144","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O145","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L146,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O146","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O147","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L148,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O148","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O149","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L150,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O150","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O151","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L152,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O152","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O153","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L154,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O154","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O155","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L156,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O156","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O157","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L158,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O158","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O159","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L160,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O160","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O161","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L162,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O162","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O163","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L164,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O164","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O165","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L166,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O166","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O167","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L168,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O168","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O169","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L170,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O170","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O171","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L172,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O172","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O173","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L174,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O174","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",0,null,{"$f":"O175","v":0}," - "]
[null,"VEN",411000,{"$f":"VLOOKUP(L176,'[1]BDD comptes auxiliaires'!$A$1:$B$171,2,FALSE)","v":{"$error":"#N/A"}}," - ",0,{"$f":"O176","v":0},null," - "]
["CONTREPARTIE","VEN",706001,null," - ",{"$f":"L177","v":0},null,{"$f":"O177","v":0}," - "]

{"sheet":"BDD comptes auxiliaires","index":2,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Nom","Auxiliaire","Code EAN","Postal","Ville","Nature"]
["ADD UP CONSULTING","CADD00","","","","CLI"]
["AMET","CAMET0","","","","CLI"]
["AQUARELLE","CAQUA0","","","","CLI"]
["Client attente","CATTEN","","","","CLI"]
["Prof Liberal Dr BARON","CBARON","","","","CLI"]
["BEES CONSEIL","CBEES0","","","","CLI"]
["SELARL BIACABE Bernard","CBIAC0","","","","CLI"]
["BJ TEX","CBJT00","","","","CLI"]
["BUSINESS EQUITIES","CBUSI0","","","","CLI"]
["CRECHES DE FRANCE","CCDF00","","","","CLI"]
["CITY ACCESS","CCIT00","","","","CLI"]
["COMPTOIR EUROPEEN ELECTRICITE","CCOMP0","","","","CLI"]
["SAS DDB ARCHITECTURE","CDDBA0","","","","CLI"]
["FHP VILEDA","CFHPVI","","","","CLI"]
["FINDIS SAS","CFIND0","","","","CLI"]
["FISCUIR","CFIS00","","","","CLI"]
["IFM ELECTRONIC","CIFM00","","","","CLI"]
["SARL JONATHAN AMAR","CJONAT","","","","CLI"]
["KALLPA GROUP","CKALL0","","","","CLI"]
["SARL LONGCHAMP","CLONG0","","","","CLI"]
["LES PETITES CANAILLES VINCENNES","CLPC10","","","","CLI"]
["LPCR","CLPCR0","","","","CLI"]
["LA MAISON DE LA CHINE","CMAISO","","","","CLI"]
["MINEFI","CMEF00","","","","CLI"]
["METAP","CMETA0","","","","CLI"]
["SAS MIKA","CMIKA0","","","","CLI"]
["MILLE ET UNE CRECHES","CMIL00","","","","CLI"]
["SARAH MORDOFF","CMOR00","","","","CLI"]
["MOURLAAS JULIEN","CMOU00","","","","CLI"]
["MA PLACE EN CRECHE AMANCE","CMPC00","","","","CLI"]
["NATIXIS ASSET MANAGEMENT","CNATIX","","","","CLI"]
["OMADIS","COMA00","","","","CLI"]
["CLIENTS PARENTS","CPAR00","","","","CLI"]
["Monsieur PASTORE","CPAST0","","","","CLI"]
["ROLAND BERGER","CROLAN","","","","CLI"]
["SALOME","CSALOM","","","","CLI"]
["LPC SAS","CSAS00","","","","CLI"]
["SGH SOLANET","CSGH00","","","","CLI"]
["SI MARKET","CSIM00","","","","CLI"]
["SOFIP","CSOF00","","","","CLI"]
["SPGEC","CSPGEC","","","","CLI"]
["SPVA","CSPVA0","","","","CLI"]
["SQUARE'S GROUP","CSQU00","","","","CLI"]