{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["DETAIL_AUTRES_OPERATION_TAXABL","TradXML","Referentiel"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":3,"defined_names":158,"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":"DETAIL_AUTRES_OPERATION_TAXABL","index":0,"n_rows":79,"n_cols":245,"rows_kept":79,"cut":false,"hidden":false,"merged":[[72,9,72,15],[72,16,72,20],[72,21,72,25],[70,0,70,1],[70,2,70,4],[70,5,70,8],[70,9,70,15],[70,16,70,20],[70,21,70,25],[71,0,71,1],[71,2,71,4],[71,5,71,8],[71,9,71,15],[71,16,71,20],[71,21,71,25],[68,9,68,15],[68,16,68,20],[68,21,68,25],[69,0,69,1],[69,2,69,4],[69,5,69,8],[69,9,69,15],[69,16,69,20],[69,21,69,25],[37,21,37,25],[38,21,38,25],[39,21,39,25],[40,21,40,25],[41,21,41,25],[42,21,42,25],[43,21,43,25],[44,21,44,25],[45,21,45,25],[46,21,46,25],[47,21,47,25],[48,21,48,25],[49,21,49,25],[50,21,50,25],[51,21,51,25],[52,21,52,25],[53,21,53,25],[54,21,54,25],[55,21,55,25],[56,21,56,25],[57,21,57,25],[58,21,58,25],[59,21,59,25],[60,21,60,25],[61,21,61,25],[62,21,62,25],[73,21,73,25],[63,21,63,25],[64,21,64,25],[65,21,65,25],[66,21,66,25],[67,21,67,25],[74,21,74,25],[75,21,75,25],[76,21,76,25],[77,21,77,25],[77,16,77,20],[77,0,77,15],[37,9,37,15],[38,9,38,15],[39,9,39,15],[40,9,40,15],[41,9,41,15],[42,9,42,15],[43,9,43,15],[44,9,44,15],[45,9,45,15],[46,9,46,15],[47,9,47,15],[48,9,48,15],[49,9,49,15],[50,9,50,15],[51,9,51,15],[52,9,52,15],[53,9,53,15],[54,9,54,15],[56,16,56,20],[57,16,57,20],[58,16,58,20],[59,16,59,20],[60,16,60,20],[61,16,61,20],[56,9,56,15],[57,9,57,15],[58,9,58,15],[59,9,59,15],[60,9,60,15],[40,16,40,20],[41,16,41,20],[42,16,42,20],[43,16,43,20],[44,16,44,20],[45,16,45,20],[46,16,46,20],[47,16,47,20],[55,9,55,15],[48,16,48,20],[49,16,49,20],[50,16,50,20],[51,16,51,20],[52,16,52,20],[53,16,53,20],[54,16,54,20],[55,16,55,20],[74,16,74,20],[75,16,75,20],[76,16,76,20],[62,0,62,1],[62,2,62,4],[62,5,62,8],[74,9,74,15],[75,9,75,15],[76,9,76,15],[62,9,62,15],[73,9,73,15],[65,16,65,20],[66,0,66,1],[66,2,66,4],[66,5,66,8],[66,9,66,15],[66,16,66,20],[67,0,67,1],[67,2,67,4],[67,5,67,8],[67,9,67,15],[67,16,67,20],[68,0,68,1],[68,2,68,4],[25,5,25,8],[76,0,76,1],[76,2,76,4],[76,5,76,8],[74,0,74,1],[74,2,74,4],[74,5,74,8],[75,0,75,1],[75,2,75,4],[75,5,75,8],[68,5,68,8],[72,0,72,1],[72,2,72,4],[72,5,72,8],[54,0,54,1],[54,2,54,4],[54,5,54,8],[55,0,55,1],[55,2,55,4],[55,5,55,8],[52,0,52,1],[52,2,52,4],[52,5,52,8],[53,0,53,1],[73,16,73,20],[56,0,56,1],[56,2,56,4],[56,5,56,8],[57,0,57,1],[57,2,57,4],[57,5,57,8],[65,0,65,1],[65,2,65,4],[65,5,65,8],[65,9,65,15],[58,0,58,1],[58,2,58,4],[58,5,58,8],[59,0,59,1],[59,2,59,4],[59,5,59,8],[73,0,73,1],[73,2,73,4],[73,5,73,8],[60,0,60,1],[60,2,60,4],[60,5,60,8],[61,0,61,1],[63,16,63,20],[64,0,64,1],[64,2,64,4],[64,5,64,8],[64,9,64,15],[64,16,64,20],[63,9,63,15],[62,16,62,20],[61,2,61,4],[61,5,61,8],[63,0,63,1],[63,2,63,4],[63,5,63,8],[61,9,61,15],[53,2,53,4],[53,5,53,8],[38,0,38,1],[38,2,38,4],[38,5,38,8],[50,0,50,1],[50,2,50,4],[50,5,50,8],[51,0,51,1],[51,2,51,4],[51,5,51,8],[48,0,48,1],[48,2,48,4],[48,5,48,8],[49,0,49,1],[49,2,49,4],[49,5,49,8],[46,0,46,1],[46,2,46,4],[46,5,46,8],[47,0,47,1],[47,2,47,4],[47,5,47,8],[45,0,45,1],[45,2,45,4],[45,5,45,8],[42,0,42,1],[42,2,42,4],[42,5,42,8],[43,0,43,1],[43,2,43,4],[43,5,43,8],[44,0,44,1],[44,2,44,4],[44,5,44,8],[40,0,40,1],[40,2,40,4],[40,5,40,8],[41,0,41,1],[41,2,41,4],[41,5,41,8],[3,29,5,30],[9,8,9,25],[6,29,8,30],[15,5,15,6],[17,5,17,6],[19,5,19,6],[13,5,13,17],[3,0,5,2],[26,0,26,1],[27,0,27,1],[30,5,30,8],[30,0,30,1],[30,2,30,4],[31,2,31,4],[32,2,32,4],[36,0,36,1],[30,9,30,15],[25,2,25,4],[31,9,31,15],[32,9,32,15],[33,9,33,15],[34,9,34,15],[35,9,35,15],[36,9,36,15],[27,21,27,25],[28,21,28,25],[29,21,29,25],[30,21,30,25],[31,21,31,25],[32,21,32,25],[33,21,33,25],[34,21,34,25],[35,21,35,25],[27,16,27,20],[28,16,28,20],[29,16,29,20],[30,16,30,20],[31,16,31,20],[32,16,32,20],[33,16,33,20],[34,16,34,20],[36,21,36,25],[34,0,34,1],[33,0,33,1],[32,0,32,1],[31,0,31,1],[31,5,31,8],[32,5,32,8],[35,5,35,8],[33,5,33,8],[33,2,33,4],[34,2,34,4],[34,5,34,8],[36,5,36,8],[35,16,35,20],[36,16,36,20],[39,0,39,1],[39,2,39,4],[39,5,39,8],[37,0,37,1],[37,2,37,4],[37,5,37,8],[35,0,35,1],[35,2,35,4],[37,16,37,20],[38,16,38,20],[39,16,39,20],[0,0,2,2],[0,5,0,26],[1,5,1,26],[2,5,2,26],[3,5,3,26],[5,5,5,26],[6,5,6,26],[11,5,11,6],[11,7,11,26],[78,0,78,30],[28,0,28,1],[29,0,29,1],[29,5,29,8],[4,5,4,22],[29,2,29,4],[16,3,16,4],[18,3,18,4],[26,5,26,8],[26,2,26,4],[27,2,27,4],[28,2,28,4],[28,5,28,8],[27,5,27,8],[26,9,26,15],[26,16,26,20],[26,21,26,25],[27,9,27,15],[28,9,28,15],[29,9,29,15],[25,9,25,15],[25,16,25,20],[25,21,25,25],[36,2,36,4]]}
[null,null,null,null,null,"REPUBLIQUE DE COTE D'IVOIRE"]
[null,null,null,null,null,"Union-Discipline –Travail"]
[null,null,null,null,null,"--------------------"]
[null,null,null,null,null,{"$f":"[2]DECLARATION!M5","v":"MINISTERE DU BUDGET ET DU PORTEFEUILLE DE L'ETAT"}]
[]
[null,null,null,null,null,"-----------------------"]
[null,null,null,null,null,"DIRECTION GENERALE DES IMPOTS"]
[]
[]
[null,null,null,null,null,null,null,null,"Formulaire de génération de fichier XML du détail des opérations non taxables"]
[]
[null,null,null,"Code impôts :",null,"TVA",null,"veillez à sélectionner le bon code correspondant à celui de votre déclaration sur e-impots.gouv.ci"]
[]
[null,null,null,"Libellé impôt :",null,{"$f":"VLOOKUP(F12,Referentiel!H2:I5,2,FALSE)","v":"Taxe sur la valeur ajoutée (hors CME/DGE)"}]
[]
[null,null,null,"NCC           :",null,"1528920S"]
[]
[null,null,null,"Année d'imposition",null,2024]
[]
[null,null,null,"Mois d'imposition  :",null,"Juillet",null,"sélectionnez le mois de janvier pour les déclarations annuelles (régularisations)"]
[null,null,{"$f":"IF(AC22=0,\"\",\"Champs obligatoires : Veuillez vous assurer que les champs NCC client, la raison sociale, la nature des opérations, le montant ht et le montant de la tva sont correctement renseignés\")","v":"Champs obligatoires : Veuillez vous assurer que les champs NCC client, la raison sociale, la nature des opérations, le montant ht et le montant de la tva sont correctement renseignés"},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,{"$f":"IFERROR(IF(LEN(NCC)=8,0,IF(LEN(NCC)=0,1,1)),1)","v":0},{"$f":"IF(SUM(AD28:AD77)=0,0,1)","v":{"$error":"#NAME?"}}]
[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,{"$f":"IF(SUM(AA28:AA77)=0,0,1)","v":1}]
[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,{"$f":"SUM(AC28:AC77)","v":24}]
[]
[]
[null,null,"ncc_client",null,null,"raison_sociale_client",null,null,null,"nature_operation",null,null,null,null,null,null,"montant_ht",null,null,null,null,"montant_tva"]
["N°",null,"NCC DU CLIENT",null,null,"RAISON SOCIALE DU CLIENT",null,null,null,"NATURE DE L'OPERATION",null,null,null,null,null,null,"MONTANT HT",null,null,null,null,"MONTANT DE LA TVA",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,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,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,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,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,"NCC DU  FOURNISSEUR"]
[1,null,"2184093E",null,null,"SOCIETE DES MINES LAFIGUE",null,null,null,"ECROU HEX ACIER8.8 ZINGUE D10",null,null,null,null,null,null,69700,null,null,null,null,12546,null,null,null,null,{"$f":"IF(AND(C28=\"\",AC28=1),1,IF(AND(F28=\"\",AC28=1),1,  IF(AND(J28=\"\",AC28=1),1,IF(AND(Q28=\"\",AC28=1),1,IF(AND(V28=\"\",AC28=1),1,0)))))","v":0},{"$f":"IF(AA28=\"\",0,IF(Q28=\"\",1,0))","v":0},{"$f":"IF(COUNTA(C28:V28)>0,1,0)","v":1},{"$f":"IF(C28=\"\",0,IF(isNccValid(C28),0,1))","v":{"$error":"#NAME?"}}]
[2,null,"0100763T",null,null,"CARENA",null,null,null,"VIS HEX PART FILETEE ACEIR 8.8 BRUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(C29=\"\",AC29=1),1,IF(AND(F29=\"\",AC29=1),1,  IF(AND(J29=\"\",AC29=1),1,IF(AND(Q29=\"\",AC29=1),1,IF(AND(V29=\"\",AC29=1),1,0)))))","v":1},{"$f":"IF(AA29=\"\",0,IF(Q29=\"\",1,0))","v":1},{"$f":"IF(COUNTA(C29:V29)>0,1,0)","v":1},{"$f":"IF(C29=\"\",0,IF(isNccValid(C29),0,1))","v":{"$error":"#NAME?"}}]
[3,null,"1652571C",null,null,"JOHN COCKERILL COTE D'IVOIRE ",null,null,null,"TIGE FILETEE ACIER 8.8 ZINGUE",null,null,null,null,null,null,1510968,null,null,null,null,271974,null,null,null,null,0,0,1,{"$f":"IF(C30=\"\",0,IF(isNccValid(C30),0,1))","v":{"$error":"#NAME?"}}]
[4,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"VIS HEX PART FILETEE ACEIR 8.8 GALVA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,{"$f":"IF(C31=\"\",0,IF(isNccValid(C31),0,1))","v":{"$error":"#NAME?"}}]
[5,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"VIS TH EN ACIER 8.8 ZINGUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,{"$f":"IF(C32=\"\",0,IF(isNccValid(C32),0,1))","v":{"$error":"#NAME?"}}]
[6,null,"8500064P",null,null,"SOCIETE DES MINES ITY",null,null,null,"VIS TH F/T ACIER 8.8 BRUT",null,null,null,null,null,null,111797,null,null,null,null,20123,null,null,null,null,0,0,1,{"$f":"IF(C33=\"\",0,IF(isNccValid(C33),0,1))","v":{"$error":"#NAME?"}}]
[7,null,"1832539R",null,null,"SRWCI",null,null,null,"VIS HEX ENT.FILETEE INOX",null,null,null,null,null,null,31875,null,null,null,null,5738,null,null,null,null,0,0,1,{"$f":"IF(C34=\"\",0,IF(isNccValid(C34),0,1))","v":{"$error":"#NAME?"}}]
[8,null,"2305559G",null,null,"CIMAS CI",null,null,null,"TIGE FILETEE ACIER 8.8 ZINGUE",null,null,null,null,null,null,6100,null,null,null,null,null,null,null,null,null,1,0,1,{"$f":"IF(C35=\"\",0,IF(isNccValid(C35),0,1))","v":{"$error":"#NAME?"}}]
[9,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"ECROU HEX ACIER8.8 ZINGUE D20",null,null,null,null,null,null,44200,null,null,null,null,7956,null,null,null,null,0,0,1,{"$f":"IF(C36=\"\",0,IF(isNccValid(C36),0,1))","v":{"$error":"#NAME?"}}]
[10,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"ECROU FREIN HEX ACIER ZINGUE D20",null,null,null,null,null,null,7514,null,null,null,null,1353,null,null,null,null,0,0,1,{"$f":"IF(C37=\"\",0,IF(isNccValid(C37),0,1))","v":{"$error":"#NAME?"}}]
[11,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"ECROU FREIN HEX ACIER ZINGUE D16",null,null,null,null,null,null,13600,null,null,null,null,2448,null,null,null,null,0,0,1,{"$f":"IF(C38=\"\",0,IF(isNccValid(C38),0,1))","v":{"$error":"#NAME?"}}]
[12,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"RONDELLE PLATE MYENNE ACIER D24",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,{"$f":"IF(C39=\"\",0,IF(isNccValid(C39),0,1))","v":{"$error":"#NAME?"}}]
[13,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"ECROU FREIN HEX ACIER ZINGUE D16",null,null,null,null,null,null,41650,null,null,null,null,7497,null,null,null,null,0,0,1,{"$f":"IF(C40=\"\",0,IF(isNccValid(C40),0,1))","v":{"$error":"#NAME?"}}]
[14,null,"9608139Y",null,null,"IRES",null,null,null,"VIS HEX PART FILETEE ACIER 8.8 BRUT",null,null,null,null,null,null,153001,null,null,null,null,27540,null,null,null,null,0,0,1,{"$f":"IF(C41=\"\",0,IF(isNccValid(C41),0,1))","v":{"$error":"#NAME?"}}]
[15,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"VIS TH F/T ACIER 8.8 BRUT",null,null,null,null,null,null,212458,null,null,null,null,38242,null,null,null,null,0,0,1,{"$f":"IF(C42=\"\",0,IF(isNccValid(C42),0,1))","v":{"$error":"#NAME?"}}]
[16,null,"9608139Y",null,null,"IRES",null,null,null,"VIS SIX PANS CREUX ACIER 12.9 BRUT",null,null,null,null,null,null,12538,null,null,null,null,2257,null,null,null,null,0,0,1,{"$f":"IF(C43=\"\",0,IF(isNccValid(C43),0,1))","v":{"$error":"#NAME?"}}]
[17,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"VIS HEX PART FILETEE ACIER 8.8 BRUT",null,null,null,null,null,null,207825,null,null,null,null,37409,null,null,null,null,0,0,1,{"$f":"IF(C44=\"\",0,IF(isNccValid(C44),0,1))","v":{"$error":"#NAME?"}}]
[18,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,0,1,0,{"$f":"IF(C45=\"\",0,IF(isNccValid(C45),0,1))","v":0}]
[19,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"VIS TH EN ACIER 8.8 ZINGUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,1,{"$f":"IF(C46=\"\",0,IF(isNccValid(C46),0,1))","v":{"$error":"#NAME?"}}]
[20,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"RONDELLE PLATE MYENNE ACIER D24",null,null,null,null,null,null,72484,null,null,null,null,13047,null,null,null,null,0,0,1,{"$f":"IF(C47=\"\",0,IF(isNccValid(C47),0,1))","v":{"$error":"#NAME?"}}]
[21,null,"0100763T",null,null,"CARENA",null,null,null,"VIS HEX ENT.FILETEE  ACIER 8.8  BRUT",null,null,null,null,null,null,416908,null,null,null,null,75043,null,null,null,null,0,0,1,{"$f":"IF(C48=\"\",0,IF(isNccValid(C48),0,1))","v":{"$error":"#NAME?"}}]
[22,null,"0100763T",null,null,"CARENA",null,null,null,"VIS HEX FILETEE ACIER 8.8 BRUT",null,null,null,null,null,null,7192,null,null,null,null,1295,null,null,null,null,0,0,1,{"$f":"IF(C49=\"\",0,IF(isNccValid(C49),0,1))","v":{"$error":"#NAME?"}}]
[23,null,"0100763T",null,null,"CARENA",null,null,null,"ECROU FREIN HEXAGONAL INOX D10",null,null,null,null,null,null,29750,null,null,null,null,5355,null,null,null,null,0,0,1,{"$f":"IF(C50=\"\",0,IF(isNccValid(C50),0,1))","v":{"$error":"#NAME?"}}]
[24,null,"1335316W",null,null,"PERSEUS MINING COTE D'IVOIRE",null,null,null,"ECROU FREIN HEX ACIER ZINGUE D20",null,null,null,null,null,null,73372,null,null,null,null,13207,null,null,null,null,0,0,1,{"$f":"IF(C51=\"\",0,IF(isNccValid(C51),0,1))","v":{"$error":"#NAME?"}}]
[25,null,"0100763T",null,null,"CARENA",null,null,null,"VIS A BOIS TF CRUCI-ZINGUE ",null,null,null,null,null,null,24863,null,null,null,null,4475,null,null,null,null,0,0,1,{"$f":"IF(C52=\"\",0,IF(isNccValid(C52),0,1))","v":{"$error":"#NAME?"}}]
[26,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,0,1,0,{"$f":"IF(C53=\"\",0,IF(isNccValid(C53),0,1))","v":0}]
[27,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,0,1,0,{"$f":"IF(C54=\"\",0,IF(isNccValid(C54),0,1))","v":0}]
[28,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,0,1,0,{"$f":"IF(C55=\"\",0,IF(isNccValid(C55),0,1))","v":0}]
[29,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,0,1,0,{"$f":"IF(C56=\"\",0,IF(isNccValid(C56),0,1))","v":0}]
[30,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,0,1,0,{"$f":"IF(C57=\"\",0,IF(isNccValid(C57),0,1))","v":0}]
[31,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,0,1,0,{"$f":"IF(C58=\"\",0,IF(isNccValid(C58),0,1))","v":0}]
[32,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,0,1,0,{"$f":"IF(C59=\"\",0,IF(isNccValid(C59),0,1))","v":0}]
[33,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,0,1,0,{"$f":"IF(C60=\"\",0,IF(isNccValid(C60),0,1))","v":0}]
[34,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,0,1,0,{"$f":"IF(C61=\"\",0,IF(isNccValid(C61),0,1))","v":0}]
[35,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,0,1,0,{"$f":"IF(C62=\"\",0,IF(isNccValid(C62),0,1))","v":0}]
[36,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,0,1,0,{"$f":"IF(C63=\"\",0,IF(isNccValid(C63),0,1))","v":0}]
[37,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,0,1,0,{"$f":"IF(C64=\"\",0,IF(isNccValid(C64),0,1))","v":0}]
[38,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,0,1,0,{"$f":"IF(C65=\"\",0,IF(isNccValid(C65),0,1))","v":0}]
[39,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,0,1,0,{"$f":"IF(C66=\"\",0,IF(isNccValid(C66),0,1))","v":0}]
[40,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,0,1,0,{"$f":"IF(C67=\"\",0,IF(isNccValid(C67),0,1))","v":0}]
[41,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,0,1,0,{"$f":"IF(C68=\"\",0,IF(isNccValid(C68),0,1))","v":0}]
[42,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,0,1,0,{"$f":"IF(C69=\"\",0,IF(isNccValid(C69),0,1))","v":0}]
[43,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,0,1,0,{"$f":"IF(C70=\"\",0,IF(isNccValid(C70),0,1))","v":0}]
[44,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,0,1,0,{"$f":"IF(C71=\"\",0,IF(isNccValid(C71),0,1))","v":0}]
[45,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,0,1,0,{"$f":"IF(C72=\"\",0,IF(isNccValid(C72),0,1))","v":0}]
[46,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,0,1,0,{"$f":"IF(C73=\"\",0,IF(isNccValid(C73),0,1))","v":0}]
[47,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,0,1,0,{"$f":"IF(C74=\"\",0,IF(isNccValid(C74),0,1))","v":0}]
[48,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,0,1,0,{"$f":"IF(C75=\"\",0,IF(isNccValid(C75),0,1))","v":0}]
[49,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,0,1,0,{"$f":"IF(C76=\"\",0,IF(isNccValid(C76),0,1))","v":0}]
[50,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,0,1,0,{"$f":"IF(C77=\"\",0,IF(isNccValid(C77),0,1))","v":0}]
["TOTAL  --",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q28:U77)","v":3047795},null,null,null,null,{"$f":"SUM(V28:Z77)","v":547505}]
["Fin du fichier : veuillez contacter la DGI si vous souhaitez saisir de nouvelles données sur les détails des opérations non taxables"]

{"sheet":"TradXML","index":1,"n_rows":5002,"n_cols":7,"rows_kept":5002,"cut":false,"hidden":true,"merged":[]}
[1,{"$f":"\"<?xml version=\"\"1.0\"\" encoding=\"\"UTF-8\"\"?><EDI><informations><type>\"&type&\"</type><ncc>\"&NCC&\"</ncc><codeTaxe>\"&codeTaxe&\"</codeTaxe><mois>\"&mois&\"</mois><exercice>\"&exercice&\"</exercice></informations><tableaux><tableau><donnees>\"","v":"<?xml version=\"1.0\" encoding=\"UTF-8\"?><EDI><informations><type>TVA_DAOPTAX</type><ncc>1528920S</ncc><codeTaxe>TVA</codeTaxe><mois>7</mois><exercice>2024</exercice></informations><tableaux><tableau><donnees>"},"ncc_client","raison_sociale_client","nature_operation","montant_ht","montant_tva"]
[{"$f":"IF(B2=\"\",\"\",MAX(A1:A$1)+1)","v":2},{"$f":"IF(OR(ISBLANK(DETAIL_AUTRES_OPERATION_TAXABL!C28),ISBLANK(DETAIL_AUTRES_OPERATION_TAXABL!F28),ISBLANK(DETAIL_AUTRES_OPERATION_TAXABL!Q28)),\"\",\"<ligne>\"&C2&D2&E2&F2&G2&\"</ligne>\")","v":"<ligne><champ><code>ncc_client</code><valeur>2184093E</valeur></champ><champ><code>raison_sociale_client</code><valeur>SOCIETE DES MINES LAFIGUE</valeur></champ><champ><code>nature_operation</code><valeur>ECROU HEX ACIER8.8 ZINGUE D10</valeur></champ><champ><code>montant_ht</code><valeur>69700</valeur></champ><champ><code>montant_tva</code><valeur>12546</valeur></champ></ligne>"},{"$f":"\"<champ><code>\"&ncc_client&\"</code><valeur>\"&DETAIL_AUTRES_OPERATION_TAXABL!C28&\"</valeur></champ>\"","v":"<champ><code>ncc_client</code><valeur>2184093E</valeur></champ>"},{"$f":"\"<champ><code>\"&raison_sociale_client&\"</code><valeur>\"&DETAIL_AUTRES_OPERATION_TAXABL!F28&\"</valeur></champ>\"","v":"<champ><code>raison_sociale_client</code><valeur>SOCIETE DES MINES LAFIGUE</valeur></champ>"},{"$f":"\"<champ><code>\"&nature_operation&\"</code><valeur>\"&DETAIL_AUTRES_OPERATION_TAXABL!J28&\"</valeur></champ>\"","v":"<champ><code>nature_operation</code><valeur>ECROU HEX ACIER8.8 ZINGUE D10</valeur></champ>"},{"$f":"\"<champ><code>\"&montant_ht&\"</code><valeur>\"&DETAIL_AUTRES_OPERATION_TAXABL!Q28&\"</valeur></champ>\"","v":"<champ><code>montant_ht</code><valeur>69700</valeur></champ>"},{"$f":"\"<champ><code>\"&montant_tva&\"</code><valeur>\"&DETAIL_AUTRES_OPERATION_TAXABL!V28&\"</valeur></champ>\"","v":"<champ><code>montant_tva</code><valeur>12546</valeur></champ>"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(B5001=\"\",\"\",MAX(A$1:A5000)+1)","v":3},{"$f":"\"</donnees></tableau></tableaux></EDI>\"","v":"</donnees></tableau></tableaux></EDI>"}]
[{"$f":"IF(B5002=\"\",\"\",MAX(A$1:A5001)+1)","v":""}]

{"sheet":"Referentiel","index":2,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Exercice","Mois","Valeur","Mois","Nombre d'erreurs","Type","Version (X.X)","Taxe","Libelle taxe","Erreur NCC client"]
[{"$f":"YEAR(TODAY())+1","v":2025},"Janvier",1,{"$f":"VLOOKUP(moisLettre,Referentiel!$B$2:$C$18,2,FALSE)","v":7},{"$f":"SUM(erreurMonNcc,champObligatoire)","v":1},"TVA_DAOPTAX","1.0","TVA","Taxe sur la valeur ajoutée (hors CME/DGE)",{"$f":"verifNcClient","v":{"$error":"#NAME?"}}]
[{"$f":"A2-1","v":2024},"Février",2,null,null,null,null,"TVA_S","Taxe sur la valeur ajoutée (CME/DGE)"]
[{"$f":"A3-1","v":2023},"Mars",3,null,null,null,null,"TVA_REGUL","Taxe sur la valeur ajoutée (hors CME/DGE) REGUL"]
[{"$f":"A4-1","v":2022},"Avril",4,null,null,null,null,"TVA_SREGUL","Taxe sur la valeur ajoutée (CME/DGE) REGUL"]
[2021,"Mai",5]
[2020,"Juin",6]
[2019,"Juillet",7]
[2018,"Août",8]
[2017,"Septembre",9]
[null,"Octobre",10]
[null,"Novembre",11]
[null,"Décembre",12]
[null,"Trimestre 1",1]
[null,"Trimestre 2",2]
[null,"Trimestre 3",3]
[null,"Trimestre 4",4]
[null,"Annuel",1]