{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["ARCDE","BL1","BL2","BL3","BL4","Fact1","Fact2","Avoir","Enreg_lien_PDF","Article","Baseclient"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"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":"ARCDE","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"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,"TARTAnPION",null,null,null,null,"Accusé de réception de commande"]
[null,null,null,"2 rue de la balme",null,null,null,"N°","20240203-23"]
[null,null,null,"38000 ESSAI",null,null,null,"Le","2024-03-02"]
[null,null,null,"Tél : 0652565856",null,null,"Société1"]
[null,null,null,"essai@gmail.com",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,"V/Réf de Commande : ",null,"gagre"]
[]
[]
[null,"Ligne","Référence","Désignation","Qté","Prix U.\nHT","Montant\nHT","Délai"]
[null,null,null,null,null,null,null,"demandé","Confirmé"]
[]
[null,{"$f":"IF(C17<>\"\",ROW(A1),\"\")","v":1},12540344,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,Tableau2[],2,FALSE))","v":"Polissage maillonHM"},56,{"$f":"IF(C17=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C17,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C17,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":2.6},{"$f":"IF(E17=\"\",\"\",E17*F17)","v":145.6},"2024-02-12","2024-02-12"]
[null,{"$f":"IF(C18<>\"\",ROW(A2),\"\")","v":2},477000217,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,Tableau2[],2,FALSE))","v":"Avivage cadran LV"},32,{"$f":"IF(C18=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C18,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C18,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":4.8899999999999997},{"$f":"IF(E18=\"\",\"\",E18*F18)","v":156.47999999999999},"2024-02-22","2024-02-22"]
[null,3,12540344,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,Tableau2[],2,FALSE))","v":"Polissage maillonHM"},null,{"$f":"IF(C19=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C19,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C19,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":2.6},""]
[null,"",null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C20=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C20,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C20,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},{"$f":"IF(E20=\"\",\"\",E20*F20)","v":""}]
[null,"",null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C21=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C21,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C21,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},{"$f":"IF(E21=\"\",\"\",E21*F21)","v":""}]
[null,"",null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C22=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C22,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C22,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C23=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C23,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C23,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C24=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C24,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C24,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C25=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C25,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C25,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C26=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C26,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C26,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C27=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C27,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C27,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C28=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C28,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C28,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C29=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C29,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C29,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C30=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C30,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C30,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C31=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C31,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C31,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C32=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C32,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C32,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[null,"",null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,Tableau2[],2,FALSE))","v":""},null,{"$f":"IF(C33=\"\",\"\",INDEX(OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C33,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),,MATCH(9^9,OFFSET(Tableau2[[#Headers],[Soumission]],MATCH(C33,Tableau2[Ref client],0),,,COUNTA(Tableau2[#Headers])-2),1)))","v":""},""]
[]
[null,null,null,"Base TVA","Taux","TVA",null,"NET A PAYER TTC"]
[null,null,null,{"$f":"SUM(G17:G33)","v":302.08},0.2,{"$f":"D36*E36","v":60.415999999999997},null,{"$f":"D36+F36","v":362.49599999999998}]
[]
[null,"Conditions de règlement :",null,"VIREMENT BANCAIRE 30 jours FIN DE MOIS"]

{"sheet":"BL1","index":1,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[[16,5,17,5],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,6,17,6],[16,4,17,4]]}
[null,null,null,null,"Bon de livraison N°",{"$f":"ARCDE!I2&\"-1BL\"","v":"20240203-23-1BL"}]
[null,null,null,null,"Date :",{"$f":"TODAY()","v":"2024-02-04"}]
[]
[null,null,null,"               Adresse de livraison"]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,{"$f":"ARCDE!D1","v":"TARTAnPION"},null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
[null,{"$f":"ARCDE!D2","v":"2 rue de la balme"},null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
[null,{"$f":"ARCDE!D3","v":"38000 ESSAI"},null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
[null,{"$f":"ARCDE!D4","v":"Tél : 0652565856"},null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
[null,{"$f":"ARCDE!D5","v":"essai@gmail.com"},null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[]
[null,"Code client :",null,{"$f":"ARCDE!D10","v":"C100001"}]
[null,"Réf Commande/Achat client : ",null,{"$f":"ARCDE!D11","v":"gagre"}]
[]
[]
[null,"Ligne","Référence","Désignation","Soldé","Qté CDE","Qté Livré"]
[]
[]
[null,1,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,2,FALSE))","v":12540344},{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,3,FALSE))","v":"Polissage maillonHM"},"Oui",{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,4,FALSE))","v":56},56]
[null,2,477000217,"Avivage cadran LV","Oui",32,32]
[null,3,12540344,"Polissage maillonHM",null,0]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[]
[null,"Commentaires :"]
[null,"1 Pièce rebutée"]
[null,"Mauvaise qualité de finition"]
[null,"Manque 1 pièce à reception"]

{"sheet":"BL2","index":2,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,6,17,6],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5]]}
[null,null,null,null,"Bon de livraison N°",{"$f":"ARCDE!I2&\"-2BL\"","v":"20240203-23-2BL"},null,"G1 : Saisir manuellement selon c'est le combientième de BL concernant cette commande"]
[null,null,null,null,"Date :",{"$f":"TODAY()","v":"2024-02-04"}]
[]
[null,null,null,"               Adresse de livraison"]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,{"$f":"ARCDE!D1","v":"TARTAnPION"},null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
[null,{"$f":"ARCDE!D2","v":"2 rue de la balme"},null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
[null,{"$f":"ARCDE!D3","v":"38000 ESSAI"},null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
[null,{"$f":"ARCDE!D4","v":"Tél : 0652565856"},null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
[null,{"$f":"ARCDE!D5","v":"essai@gmail.com"},null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[]
[null,"Code client :",null,{"$f":"ARCDE!D10","v":"C100001"}]
[null,"Réf Commande/Achat client : ",null,{"$f":"ARCDE!D11","v":"gagre"}]
[]
[]
[null,"Ligne","Référence","Désignation","Soldé","Qté CDE","Qté Livré"]
[]
[]
[null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,2,FALSE))","v":""},{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,3,FALSE))","v":""},null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,4,FALSE))","v":""}]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[]
[null,"Commentaires :"]

{"sheet":"BL3","index":3,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,6,17,6],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5]]}
[null,null,null,null,"Bon de livraison N°",{"$f":"ARCDE!I2&\"-3BL\"","v":"20240203-23-3BL"}]
[null,null,null,"Date :",{"$f":"TODAY()","v":"2024-02-04"}]
[]
[null,null,null,"               Adresse de livraison"]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,{"$f":"ARCDE!D1","v":"TARTAnPION"},null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
[null,{"$f":"ARCDE!D2","v":"2 rue de la balme"},null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
[null,{"$f":"ARCDE!D3","v":"38000 ESSAI"},null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
[null,{"$f":"ARCDE!D4","v":"Tél : 0652565856"},null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
[null,{"$f":"ARCDE!D5","v":"essai@gmail.com"},null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[]
[null,"Code client :",null,{"$f":"ARCDE!D10","v":"C100001"}]
[null,"Réf Commande/Achat client : ",null,{"$f":"ARCDE!D11","v":"gagre"}]
[]
[]
[null,"Ligne","Référence","Désignation","Soldé","Qté CDE","Qté Livré"]
[]
[]
[null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,2,FALSE))","v":""},{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,3,FALSE))","v":""},null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,4,FALSE))","v":""}]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[]
[null,"Commentaires :"]

{"sheet":"BL4","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[16,6,17,6],[16,1,17,1],[16,2,17,2],[16,3,17,3],[16,4,17,4],[16,5,17,5]]}
[null,null,null,null,"Bon de livraison N°",{"$f":"ARCDE!I2&\"-4BL\"","v":"20240203-23-4BL"},null,"G1 : Saisir manuellement selon c'est le combientième de BL concernant cette commande"]
[null,null,null,null,"Date :",{"$f":"TODAY()","v":"2024-02-04"}]
[]
[null,null,null,"               Adresse de livraison"]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,{"$f":"ARCDE!D1","v":"TARTAnPION"},null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
[null,{"$f":"ARCDE!D2","v":"2 rue de la balme"},null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
[null,{"$f":"ARCDE!D3","v":"38000 ESSAI"},null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
[null,{"$f":"ARCDE!D4","v":"Tél : 0652565856"},null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
[null,{"$f":"ARCDE!D5","v":"essai@gmail.com"},null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[]
[null,"Code client :",null,{"$f":"ARCDE!D10","v":"C100001"}]
[null,"Réf Commande/Achat client : ",null,{"$f":"ARCDE!D11","v":"gagre"}]
[]
[]
[null,"Ligne","Référence","Désignation","Soldé","Qté CDE","Qté Livré"]
[]
[]
[null,null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,2,FALSE))","v":""},{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,3,FALSE))","v":""},null,{"$f":"IF(B20=\"\",\"\",VLOOKUP(B20,Arcde,4,FALSE))","v":""}]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[null,null,"","",null,""]
[]
[null,"Commentaires :"]

{"sheet":"Fact1","index":5,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,5,16,5],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4]]}
[null,null,null,null,null,"FACTURE"]
[]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,null,null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
["2 rue de la balme",null,null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
["38000 ESSAI",null,null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
["Tél : 0652565856",null,null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
["essai@gmail.com",null,null,null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[null,"RENSEIGNEMENT A JOINDRE A VOTRE REGLEMENT"]
[null,"FACTURE N°","Date",null,"N° Client","V/Ref Cde"]
[null,{"$f":"ARCDE!I2&\"-1\"&\"FAC\"","v":"20240203-23-1FAC"},{"$f":"TODAY()","v":"2024-02-04"},null,{"$f":"ARCDE!D10","v":"C100001"},{"$f":"ARCDE!D11","v":"gagre"}]
[null,"Conditions de règlement :",{"$f":"IF(E12=\"\",\"\",VLOOKUP(E12,baseclient[],12,FALSE))","v":"VIREMENT BANCAIRE 30 jours FIN DE MOIS"}]
[]
[]
["Ligne","Référence","Désignation","Qté","Prix U.HT\nNette","Montant\nHT"]
[]
[]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,2,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,3,FALSE))","v":""},null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,5,FALSE))","v":""},{"$f":"IF(D19=\"\",\"\",D19*E19)","v":""}]
[null,"","",null,"",{"$f":"IF(D20=\"\",\"\",D20*E20)","v":""}]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[]
[]
["MONTANT HT NET",null,"TVA","NET A PAYER TTC",null,"TAUX %"]
[null,{"$f":"SUM(F19:F35)","v":0},{"$f":"B39*F39/100","v":0},{"$f":"C39+B39","v":0},null,20]

{"sheet":"Fact2","index":6,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,5,16,5],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4]]}
[null,null,null,null,null,"FACTURE"]
[]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,null,null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
["2 rue de la balme",null,null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
["38000 ESSAI",null,null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
["Tél : 0652565856",null,null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
["essai@gmail.com",null,null,null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[null,"RENSEIGNEMENT A JOINDRE A VOTRE REGLEMENT"]
[null,"FACTURE N°","Date",null,"N° Client","V/Ref Cde"]
[null,{"$f":"ARCDE!I2&\"-2\"&\"FAC\"","v":"20240203-23-2FAC"},{"$f":"TODAY()","v":"2024-02-04"},null,{"$f":"ARCDE!D10","v":"C100001"},{"$f":"ARCDE!D11","v":"gagre"}]
[null,"Conditions de règlement :",{"$f":"IF(E12=\"\",\"\",VLOOKUP(E12,baseclient[],12,FALSE))","v":"VIREMENT BANCAIRE 30 jours FIN DE MOIS"}]
[]
[]
["Ligne","Référence","Désignation","Qté","Prix U.HT\nNette","Montant\nHT"]
[]
[]
[null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,2,FALSE))","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,3,FALSE))","v":""},null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,5,FALSE))","v":""},{"$f":"IF(D19=\"\",\"\",D19*E19)","v":""}]
[null,"","",null,"",{"$f":"IF(D20=\"\",\"\",D20*E20)","v":""}]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[]
[]
["MONTANT HT NET",null,"TVA","NET A PAYER TTC",null,"TAUX %"]
[null,{"$f":"SUM(F19:F35)","v":0},{"$f":"B39*F39/100","v":0},{"$f":"C39+B39","v":0},null,20]

{"sheet":"Avoir","index":7,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,5,16,5],[15,0,16,0],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4]]}
[null,null,null,null,null,"AVOIR"]
[]
[null,null,null,{"$f":"IF(ARCDE!G4=\"\",\"\",ARCDE!G4)","v":"Société1"}]
[null,null,null,{"$f":"IF(ARCDE!G5=\"\",\"\",ARCDE!G5)","v":"Service soumission"}]
["2 rue de la balme",null,null,{"$f":"IF(ARCDE!G6=\"\",\"\",ARCDE!G6)","v":""}]
["38000 ESSAI",null,null,{"$f":"IF(ARCDE!G7=\"\",\"\",ARCDE!G7)","v":"adresse1"}]
["Tél : 0652565856",null,null,{"$f":"IF(ARCDE!G8=\"\",\"\",ARCDE!G8)","v":"25500  MORTEAU"}]
["essai@gmail.com",null,null,null,"Tél :",{"$f":"ARCDE!H9","v":101010101}]
[]
[]
[null,"AVOIR N°","Date",null,"N° Client","V/Ref Cde"]
[null,{"$f":"ARCDE!I2&\"-1\"&\"AV\"","v":"20240203-23-1AV"},{"$f":"TODAY()","v":"2024-02-04"},null,{"$f":"ARCDE!D10","v":"C100001"},{"$f":"ARCDE!D11","v":"gagre"}]
[]
[]
[]
["Ligne","Référence","Désignation","Qté","Prix U.HT\nNette","Montant\nHT"]
[]
[]
[2,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,2,FALSE))","v":477000217},{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,3,FALSE))","v":"Avivage cadran LV"},5,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,Arcde,5,FALSE))","v":4.8899999999999997},{"$f":"IF(D19=\"\",\"\",D19*E19)","v":24.45}]
[null,"","",null,"",{"$f":"IF(D20=\"\",\"\",D20*E20)","v":""}]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[null,"","",null,"",""]
[]
[]
["MONTANT HT NET",null,"TVA","NET A PAYER TTC",null,"TAUX %"]
[null,{"$f":"SUM(F19:F35)","v":24.45},{"$f":"B39*F39/100","v":4.8899999999999997},{"$f":"C39+B39","v":29.34},null,20]

{"sheet":"Enreg_lien_PDF","index":8,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Document PDF",null,null,null,null,null,"Classeur Excel extension xlsx sans macro"]
["Noms","N° cité","Lien vers sauvegarde","DatInv","num",null,"Noms","N° cité","Lien vers sauvegarde"]
["Société2","20240203-2-1AV","D:\\Bureau\\gturkmen\\20240203-2-1AV",20240203,1,null,"Société2","20240203-2-1AV","D:\\Bureau\\gturkmen\\20240203-2-1AV"]
[null,null,null,null,null,null,"soc","num","D:\\Bureau\\gturkmen\\20240203-23.xlsx"]
[null,null,null,null,null,null,"soc","num","D:\\Bureau\\gturkmen\\20240203-23.xlsx"]

{"sheet":"Article","index":9,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Article"]
[]
[]
[null,"Ref client","Designation","Soumission","Prix HT 2024-1","Prix HT 2024-2","Prix HT20243"]
[null,25364,"Polissage fermoir 325",10.55,11.02]
[null,2152365,"Avivage fermoir HB",3.99,4.03,4.08,4.8499999999999996]
[null,1244242,"Polissage cadran 125",5.56]
[null,1254035,"Polissage bague HM",3.56]
[null,12540344,"Polissage maillonHM",2.6]
[null,477000217,"Avivage cadran LV",4.8899999999999997]

{"sheet":"Baseclient","index":10,"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"}]