{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Accueil","Param","Devis","Suivi Devis","Clients","Fact","Suivi Fact"],"not_rendered":{"images":1,"macros":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Accueil","index":0,"n_rows":1,"n_cols":4,"rows_kept":1}
["MàJ : ","2025-03-01",null,"Fichier simplifié pour forum"]

{"sheet":"Param","index":1,"n_rows":10,"n_cols":23,"rows_kept":10}
["2025-02-28",{"$nulls":4},"Année pour numérotation Devis & Factures",2025,"A renseigner chaque année",null,null,"Non",{"$nulls":10},"Adresse de ce fichier : ",{"$f":"CELL(\"nomfichier\",A1)","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\[Dev Fact V2.xlsm]Param"}]
[{"$nulls":10},"Oui",{"$nulls":10},"Nom de ce Fichier : ",{"$f":"RIGHT(LEFT(CELL(\"nomfichier\",A1),FIND(\"]\",CELL(\"nomfichier\",A1),1)-1),FIND(\"]\",CELL(\"nomfichier\",A1),1)-FIND(\"[\",CELL(\"nomfichier\",A1),1)-1)","v":"Dev Fact V2.xlsm"}]
[{"$nulls":3},"Assujettissement à la TVA ","Oui","TVA",{"$nulls":15},"Chemin Dossier de ce Fichier : ",{"$f":"RIGHT(LEFT(CELL(\"nomfichier\",A1),FIND(\"[\",CELL(\"nomfichier\",A1),1)-1),FIND(\"[\",CELL(\"nomfichier\",A1),1)-1)","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\"}]
[{"$nulls":5},{"v":0.055,"d":"5.50%"},{"$nulls":15},"Chemin de ce Fichier : ",{"$f":"+W3&W2","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\Dev Fact V2.xlsm"}]
[{"$nulls":5},{"v":0.1,"d":"10.00%"}]
[{"$nulls":5},{"v":0.2,"d":"20.00%"}]
[]
[]
[{"$nulls":21},"Chemin Export Fichier Devis : ","C:\\Users\\Philippe\\Documents\\ASEEP\\Devis"]
[{"$nulls":21},"Chemin Export Fichier Factures : ","C:\\Users\\Philippe\\Documents\\ASEEP\\Factures"]

{"sheet":"Devis","index":2,"n_rows":43,"n_cols":15,"rows_kept":43,"merged":[[18,1,18,4]]}
[{"$nulls":10},"MàJ : ","2025-03-01","NE PAS SUPPRIMER",null,{"$f":"+Param!F3","v":"TVA"}]
[null,"LOGO",{"$nulls":12},{"$f":"+Param!F4","v":{"v":0.055,"d":"5.50%"}}]
[{"$nulls":14},{"$f":"+Param!F5","v":{"v":0.1,"d":"10.00%"}}]
[{"$nulls":14},{"$f":"+Param!F6","v":{"v":0.2,"d":"20.00%"}}]
[]
[]
[]
[]
[null,"Adresse"]
[null,"Adresse"]
[{"$nulls":5},"Test 1","(<= Liste déroulante)"]
[null,"SIREN : ",{"$nulls":3},{"$f":"IFERROR(IF(VLOOKUP($F$11,Base_Clients[[Nom]:[Adresse_1]],2,FALSE)=0,\"\",VLOOKUP($F$11,Base_Clients[[Nom]:[Adresse_1]],2,FALSE)),\"\")","v":"TVA OUI"}]
[null,"07 89 ",{"$nulls":3},{"$f":"IFERROR(IF(VLOOKUP($F$11,Base_Clients[[Nom]:[Adresse_2]],3,FALSE)=0,\"\",VLOOKUP($F$11,Base_Clients[[Nom]:[Adresse_2]],3,FALSE)),\"\")","v":"fhjxfhj"}]
[null,"xxxx@gmail.com",{"$nulls":3},{"$f":"IFERROR(IF(VLOOKUP($F$11,Base_Clients[[Nom]:[Adresse_3]],4,FALSE)=0,\"\",VLOOKUP($F$11,Base_Clients[[Nom]:[Adresse_3]],4,FALSE)),\"\")","v":"wfgwgf"}]
[]
[null,"Devis n° : ",{"$f":"+\"D\"&RIGHT(Année_Dev_Fact,2)&TEXT(MAX(Tab_Devis[N°]),\"000\")","v":"D25002"},null,null,"Pauillac le : ",{"$f":"+'Suivi Devis'!D1","v":"2025-03-01"}]
[]
[]
[null,"Désignation",{"$nulls":3},"Quantités","Taux horaire","Montant"]
[null,"bla bla",{"$nulls":3},10,{"v":20,"d":"20.00 €"},{"$f":"IF(B20>0,F20*G20,\"\")","v":{"v":200,"d":"200.00 €"}}]
[null,"bbllaa",{"$nulls":5},{"v":0,"d":"0.00 €"}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":6},{"$f":"+IF($H$33<>\"\",\"Montant HT du devis\",\"Montant du devis\")","v":"Montant du devis"},{"$f":"SUM(H20:H31)","v":{"v":200,"d":"200.00 €"}}]
[{"$nulls":5},{"$f":"+IF(G33=\"TVA\",\"\",\"TVA\")","v":""},"TVA",{"$f":"IFERROR(H32*G33,\"\")","v":""}]
[{"$nulls":6},{"$f":"+IF($H$33<>\"\",\"Montant TTC du devis\",\"Montant du devis\")","v":"Montant du devis"},{"$f":"SUM(H32:H33)","v":{"v":200,"d":"200.00 €"}}]
[]
[{"$nulls":7},"TVA non applicable, Art. 293 B du CGI"]
[]
[]
[]
[null,null,"Chef d'entreprise",null,null,"Le client, pour acceptation"]
[]
[null,null,"Signature",null,null,"Date :"]
[{"$nulls":5},"Signature :"]

{"sheet":"Suivi Devis","index":3,"n_rows":6,"n_cols":16,"rows_kept":6}
[null,"MàJ :","2025-03-01","2025-03-01","NE PAS SUPPRIMER",null,{"$f":"+Devis!C16","v":"D25002"},"NE PAS SUPPRIMER",{"$nulls":5},"Devis à facturer","D25001","NE PAS SUPPRIMER"]
["Suivi des devis alimenté lors de la création d'un devis",{"$nulls":5},"Permet de créer la facture en fonction du devis choisi dans la liste par double clic "]
[null,"Alimenté par macro"]
[null,"Date","N°","Client","Montant","Nom Fichiers","N° Devis","Adresse_Fich_Devis","Fichier_Dev_pour_Fact","Accepté","A Facturer","Facturé"]
[null,"2025-03-01",1,"Test 2",{"v":120,"d":"120.00 €"},{"$f":"+Tab_Devis[[#This Row],[N° Devis]]&\" \"&Tab_Devis[[#This Row],[Client]]","v":"D25001 Test 2"},"D25001",{"$f":"Param!$W$9&\"\\\"&Tab_Devis[[#This Row],[Nom Fichiers]]","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\Devis\\D25001 Test 2"},{"$f":"Tab_Devis[[#This Row],[Adresse_Fich_Devis]]&\".xslx\"","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\Devis\\D25001 Test 2.xslx"}]
[null,"2025-03-01",2,"Test 1",{"v":200,"d":"200.00 €"},{"$f":"+Tab_Devis[[#This Row],[N° Devis]]&\" \"&Tab_Devis[[#This Row],[Client]]","v":"D25002 Test 1"},"D25002",{"$f":"Param!$W$9&\"\\\"&Tab_Devis[[#This Row],[Nom Fichiers]]","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\Devis\\D25002 Test 1"},{"$f":"Tab_Devis[[#This Row],[Adresse_Fich_Devis]]&\".xslx\"","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\Devis\\D25002 Test 1.xslx"}]

{"sheet":"Clients","index":4,"n_rows":12,"n_cols":12,"rows_kept":12}
[]
[]
[null,"Date","ID","Nom","Adresse_1","Adresse_2","Adresse_3","N° Tél","Mail","Contact","Type","Notes"]
[null,"2024-01-23","C24001","Alphonse","Ici","Là",33000,{"v":123456789,"d":"01 23 45 67 89"}]
[null,"2024-02-27",2,"Truc","sfhsfj","fhtj",null,{"v":123456789,"d":"01 23 45 67 89"},null,null,"Entreprise"]
[null,"2025-02-08",3,"moi","azert","33250 ICI",{"$nulls":4},"Particulier"]
[null,null,4,"Test 1","TVA OUI","fhjxfhj","wfgwgf"]
[null,null,5,"Test 2","TVA Oui","dghj",",jkduk"]
[null,null,6,"Test 3","TVA NON","duykyiyl",767]
[null,null,7,"Test 4","TVA Non","yilifl","huuyfo"]
[null,null,8,"Test 5","gukdtui","dtuitdi","dutitudit"]
[null,"2025-03-01",9,"fff","ffff",{"$nulls":4},"fff","Particulier","ffff"]

{"sheet":"Fact","index":5,"n_rows":40,"n_cols":16,"rows_kept":40,"merged":[[18,1,18,4]]}
[{"$nulls":5},"Ok",{"$nulls":4},"MàJ : ","2025-02-16","NE PAS SUPPRIMER"]
[{"$nulls":11},{"$f":"+_xlfn.XLOOKUP(C17,Tab_Devis[N° Devis],Tab_Devis[Nom Fichiers])&\".xlsx\"","v":"D25001 Test 2.xlsx"},"Nom Fichier à partir du n° Devis",null,"NE PAS SUPPRIMER"]
[{"$nulls":5},"Copie / colle Devis",{"$nulls":5},{"$f":"+Param!W9&\"\\\"&Fact!L2","v":"C:\\Users\\Philippe\\Documents\\ASEEP\\Devis\\D25001 Test 2.xlsx"},{"$nulls":3},"NE PAS SUPPRIMER"]
[]
[]
[]
[]
[]
[null,"Adresse"]
[null,"Adresse"]
[]
[null,"SIREN : "]
[null,"07 89 "]
[null,"xxxx@gmail.com"]
[]
[null,"Facture n° : ",{"$f":"+\"F\"&RIGHT(Année_Dev_Fact,2)&TEXT(MAX(Tab_Fact[N°]),\"000\")","v":"F25001"},null,null,"Pauillac le : ",{"$f":"+'Suivi Fact'!D1","v":"2025-02-19"}]
[null,"Devis n° : ","D25001","Alimenté lors du double clic"]
[]
[null,"Désignation",{"$nulls":3},"Quantités","Taux horaire","Montant"]
[{"$nulls":5},45,{"v":20,"d":"20.00 €"},{"$f":"IF(B20>0,F20*G20,\"\")","v":""}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":6},{"$f":"+IF($H$33<>\"\",\"Montant HT de la facture\",\"Montant de la facture\")","v":"Montant de la facture"},{"$f":"SUM(H20:H31)","v":{"v":0,"d":"0.00 €"}}]
[{"$nulls":5},{"$f":"+IF(G33=\"TVA\",\"\",\"TVA\")","v":""},"TVA",{"$f":"IFERROR(H32*G33,\"\")","v":""}]
[{"$nulls":6},{"$f":"+IF($H$33<>\"\",\"Montant TTC de la facture\",\"Montant de la facture\")","v":"Montant de la facture"},{"$f":"SUM(H32:H33)","v":{"v":0,"d":"0.00 €"}}]
[]
[{"$nulls":7},"TVA non applicable, Art. 293 B du CGI"]
[]
[null,"Règlement par chèque ou virement."]
[null,"Merci"]
[{"$nulls":6},"Philippe Abadie"]

{"sheet":"Suivi Fact","index":6,"n_rows":6,"n_cols":11,"rows_kept":6}
[null,"MàJ","2025-02-19","2025-02-19","NE PAS SUPPRIMER"]
[]
[]
[]
[null,"Date","N°","N° Fact","N° Devis","Client Facturé","Montant","Nom Fichier","Envoyée","Payée","CA Encaissé"]
[null,"2024-01-17",1,null,null,"gffnfgn",{"v":2000,"d":"2,000.00 €"},null,"2024-01-17","2024-01-17",{"$f":"+Tab_Fact[[#This Row],[Nom Fichier]]","v":{"v":0,"d":"0.00 €"}}]