{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["baseclient","ARCDE","Archive","article","ARCDE (copie)"],"not_rendered":{"charts":0,"images":2,"macros":1,"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":"baseclient","index":0,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,"Base CLIENT"]
[]
[]
[null,null,"Code Client","Societe2","Site","Civilité","Nom","Prenom","Service","Adresse","Code postal","Ville","Téléphone","Mode de règlement","Colonne9","CP VILLE"]
[null,null,"C100001","Société1","Site1","Mr","Nom1","Prenom1","Service soumission","adresse1",25500,"MORTEAU",101010101,"VIREMENT BANCAIRE 30 jours FIN DE MOIS",null,{"$f":"baseclient[[#This Row],[Code postal]]&\" \"&baseclient[[#This Row],[Ville]]","v":"25500 MORTEAU"}]
[null,null,"C100002","Société2","Site1","Mme","Nom2","Prenom2","Service soumission","adresse225",25000,"BESANCON",202020202,"VIREMENT BANCAIRE 30 jours FIN DE MOIS",null,{"$f":"baseclient[[#This Row],[Code postal]]&\" \"&baseclient[[#This Row],[Ville]]","v":"25000 BESANCON"}]
[null,null,"C100002","Société2","Site2","Mme","Nom4","Prenom4","Service Achat","adresse225",25000,"BESANCON",202020202,"VIREMENT BANCAIRE 30 jours FIN DE MOIS",null,{"$f":"baseclient[[#This Row],[Code postal]]&\" \"&baseclient[[#This Row],[Ville]]","v":"25000 BESANCON"}]
[null,null,"C100002","Société2","Site2","Mr","Nom3","Prenom3","Service comptabilité","adresse3",25000,"BESANCON",303030303,"VIREMENT BANCAIRE 30 jours FIN DE MOIS",null,{"$f":"baseclient[[#This Row],[Code postal]]&\" \"&baseclient[[#This Row],[Ville]]","v":"25000 BESANCON"}]
[null,null,"C100002","Société2","Site3","Mr","Nom3","Prenom4","Service achat","adresse4",75000,"PARIS",404040404,"VIREMENT BANCAIRE 30 jours FIN DE MOIS",null,{"$f":"baseclient[[#This Row],[Code postal]]&\" \"&baseclient[[#This Row],[Ville]]","v":"75000 PARIS"}]
[null,null,"C100002","Société2","Site4","Mr","Nom2","Prenom2","Service achat","adresse2",25000,"BESANCON",505050505,"VIREMENT BANCAIRE 30 jours FIN DE MOIS",null,{"$f":"baseclient[[#This Row],[Code postal]]&\" \"&baseclient[[#This Row],[Ville]]","v":"25000 BESANCON"}]

{"sheet":"ARCDE","index":1,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[13,6,14,6],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5]]}
[null,null,null,null,null,null,null,null,"Accusé de réception de commande"]
[null,null,null,null,null,null,null,"N°","AR44032"]
[]
[null,null,null,null,null,null,"Société1"]
[null,null,null,null,null,null,"Service soumission"]
[]
[null,null,null,null,null,null,"adresse1"]
[null,null,null,null,null,null,"25500, MORTEAU"]
[null,null,null,null,null,null,"Tél : ",101010101]
[null,"Code client :",null,"C100001"]
[null,"Votre réf Commande/Achat : "]
[]
[]
[null,"Ligne","Référence","Désignation","Qté","Prix U.HT","Montant HT","Délai"]
[null,null,null,null,null,null,null,"demandé","Confirmé"]
[]
[null,1,25364,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Tableau2[],3,FALSE))","v":"Polissage fermoir 325"},320,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Tableau2[],4,FALSE))","v":3.593},{"$f":"IF(E17=\"\",\"\",E17*F17)","v":1149.76},"2024-12-25","2024-12-25"]
[null,2,2152365,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Tableau2[],3,FALSE))","v":"Avivage fermoir HB"},125,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Tableau2[],4,FALSE))","v":3.99},{"$f":"IF(E18=\"\",\"\",E18*F18)","v":498.75},"2024-12-25","2024-12-25"]
[null,3,1244242,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Tableau2[],3,FALSE))","v":"Polissage cadran 125"},210,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Tableau2[],4,FALSE))","v":5.56},1167.5999999999999,"2024-12-25","2024-12-26"]
[null,4,1254035,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Tableau2[],3,FALSE))","v":"Polissage bague HM"},50,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Tableau2[],4,FALSE))","v":3.56},178,"2024-12-28","2024-12-28"]
[null,5,12540344,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Tableau2[],3,FALSE))","v":"Polissage maillonHM"},40,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Tableau2[],4,FALSE))","v":2.6},104,"2024-12-28","2024-12-29"]
[null,6,477000217,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Tableau2[],3,FALSE))","v":"Avivage cadran LV"},99,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Tableau2[],4,FALSE))","v":4.8899999999999997},484.10999999999996,"2024-12-28","2024-12-29"]
[null,7,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Tableau2[],4,FALSE))","v":""},""]
[null,8,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Tableau2[],4,FALSE))","v":""},""]
[null,9,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Tableau2[],4,FALSE))","v":""},""]
[null,10,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Tableau2[],4,FALSE))","v":""},""]
[null,11,null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Tableau2[],4,FALSE))","v":""},""]
[null,12,null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Tableau2[],4,FALSE))","v":""},""]
[null,13,null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Tableau2[],4,FALSE))","v":""},""]
[null,14,null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Tableau2[],4,FALSE))","v":""},""]
[null,15,null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Tableau2[],4,FALSE))","v":""},""]
[null,16,null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Tableau2[],4,FALSE))","v":""},""]
[null,17,null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Tableau2[],4,FALSE))","v":""},""]
[]
[null,null,null,"Base TVA","Taux","TVA",null,"NET A PAYER TTC"]
[null,null,null,{"$f":"SUM(G17:G33)","v":3582.22},0.2,{"$f":"D36*E36","v":716.44399999999996},null,{"$f":"D36+F36","v":4298.6639999999998}]
[]
[null,"Mode de règlement :",null,"VIREMENT BANCAIRE 30 jours FIN DE MOIS"]
[]
[null,"Commentaires :"]
[null,"Manque 10 pièces ref 25364"]
[null,"Lavage nin inclus prestations"]
[null,"Demande phototèque de qualité"]

{"sheet":"Archive","index":2,"n_rows":3,"n_cols":118,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4]]}
["N° ARC","Code client","Société","Service","Taux","Référence","Désignation","Qté","Prix U.HT","Montant HT","Délai",null,2,null,null,null,null,null,null,3,null,null,null,null,null,null,4,null,null,null,null,null,null,5,null,null,null,null,null,null,6,null,null,null,null,null,null,7,null,null,null,null,null,null,8,null,null,null,null,null,null,9,null,null,null,null,null,null,10,null,null,null,null,null,null,11,null,null,null,null,null,null,12,null,null,null,null,null,null,13,null,null,null,null,null,null,14,null,null,null,null,null,null,15,null,null,null,null,null,null,16,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,"demandé","Confirmé"]
["AR44testjpp","C100002","Société2","Service Achat",0.2,25364,"Polissage fermoir 325",320,3.593,1149.76,"2024-12-25","2024-12-25",2152365,"Avivage fermoir HB",125,3.99,498.75,"2024-12-25","2024-12-25",1244242,"Polissage cadran 125",210,5.56,1167.5999999999999,"2024-12-25","2024-12-26",1254035,"Polissage bague HM",50,3.56,178,"2024-12-28","2024-12-28",12540344,"Polissage maillonHM",40,2.6,104,"2024-12-28","2024-12-29",477000217,"Avivage cadran LV",99,4.8899999999999997,484.10999999999996,"2024-12-28","2024-12-29"]

{"sheet":"article","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Code article"]
[]
[]
[null,"Ref client","Ref interne","Designation","Prix HT","Pour 1000"]
[null,25364,10000,"Polissage fermoir 325",3.593,{"$f":"Tableau2[[#This Row],[Prix HT]]*1000","v":3593}]
[null,2152365,{"$f":"C5+1","v":10001},"Avivage fermoir HB",3.99,{"$f":"Tableau2[[#This Row],[Prix HT]]*1000","v":3990}]
[null,1244242,{"$f":"C6+1","v":10002},"Polissage cadran 125",5.56,{"$f":"Tableau2[[#This Row],[Prix HT]]*1000","v":5560}]
[null,1254035,10003,"Polissage bague HM",3.56,{"$f":"Tableau2[[#This Row],[Prix HT]]*1000","v":3560}]
[null,12540344,10004,"Polissage maillonHM",2.6,{"$f":"Tableau2[[#This Row],[Prix HT]]*1000","v":2600}]
[null,477000217,10005,"Avivage cadran LV",4.8899999999999997,{"$f":"Tableau2[[#This Row],[Prix HT]]*1000","v":4890}]

{"sheet":"ARCDE (copie)","index":4,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[13,6,14,6],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5]]}
[null,null,null,null,null,null,null,null,"Accusé de réception de commande"]
[null,null,null,null,null,null,null,"N°","AR426303"]
[]
[null,null,null,null,null,null,"Société2"]
[null,null,null,null,null,null,"Service comptabilité"]
[]
[null,null,null,null,null,null,"adresse3"]
[null,null,null,null,null,null,"25000, BESANCON"]
[null,null,null,null,null,null,"Tél : ",303030303]
[null,"Code client :",null,"C100002"]
[null,"Votre réf Commande/Achat : "]
[]
[]
[null,"Ligne","Référence","Désignation","Qté","Prix U.HT","Montant HT","Délai"]
[null,null,null,null,null,null,null,"demandé","Confirmé"]
[]
[null,1,25364,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Tableau2[],3,FALSE))","v":"Polissage fermoir 325"},320,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Tableau2[],4,FALSE))","v":3.593},{"$f":"IF(E17=\"\",\"\",E17*F17)","v":1149.76},"2024-12-25","2024-12-25"]
[null,2,2152365,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Tableau2[],3,FALSE))","v":"Avivage fermoir HB"},125,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Tableau2[],4,FALSE))","v":3.99},{"$f":"IF(E18=\"\",\"\",E18*F18)","v":498.75},"2024-12-25","2024-12-25"]
[null,3,1244242,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Tableau2[],3,FALSE))","v":"Polissage cadran 125"},210,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Tableau2[],4,FALSE))","v":5.56},1167.5999999999999,"2024-12-25","2024-12-26"]
[null,4,1254035,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Tableau2[],3,FALSE))","v":"Polissage bague HM"},50,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Tableau2[],4,FALSE))","v":3.56},178,"2024-12-28","2024-12-28"]
[null,5,12540344,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Tableau2[],3,FALSE))","v":"Polissage maillonHM"},40,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Tableau2[],4,FALSE))","v":2.6},104,"2024-12-28","2024-12-29"]
[null,6,477000217,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Tableau2[],3,FALSE))","v":"Avivage cadran LV"},99,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Tableau2[],4,FALSE))","v":4.8899999999999997},484.10999999999996,"2024-12-28","2024-12-29"]
[null,7,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Tableau2[],4,FALSE))","v":""},""]
[null,8,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Tableau2[],4,FALSE))","v":""},""]
[null,9,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Tableau2[],4,FALSE))","v":""},""]
[null,10,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Tableau2[],4,FALSE))","v":""},""]
[null,11,null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Tableau2[],4,FALSE))","v":""},""]
[null,12,null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Tableau2[],4,FALSE))","v":""},""]
[null,13,null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Tableau2[],4,FALSE))","v":""},""]
[null,14,null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Tableau2[],4,FALSE))","v":""},""]
[null,15,null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Tableau2[],4,FALSE))","v":""},""]
[null,16,null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Tableau2[],4,FALSE))","v":""},""]
[null,17,null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Tableau2[],3,FALSE))","v":""},null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Tableau2[],4,FALSE))","v":""},""]
[]
[null,null,null,"Base TVA","Taux","TVA",null,"NET A PAYER TTC"]
[null,null,null,{"$f":"SUM(G17:G33)","v":3582.22},0.2,{"$f":"D36*E36","v":716.44399999999996},null,{"$f":"D36+F36","v":4298.6639999999998}]
[]
[null,"Mode de règlement :",null,"VIREMENT BANCAIRE 30 jours FIN DE MOIS"]
[]
[null,"Commentaires :"]
[null,"Manque 10 pièces ref 25364"]
[null,"Lavage nin inclus prestations"]
[null,"Demande phototèque de qualité"]