{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["CNSS-012023FEUIL1 ","CNSS-012023FEUIL2","CNSS ACHRAF SF1694 012023","RECAP_SALAIRE T1","CdC"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":2,"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":"CNSS-012023FEUIL1 ","index":0,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[32,3,32,5],[32,12,32,13],[33,11,33,13],[34,11,34,13],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[28,0,28,9],[29,0,29,10],[31,3,31,5],[32,0,32,2],[8,3,8,4],[10,0,12,0],[10,1,11,1],[13,3,13,7],[19,3,19,7],[10,10,11,12],[10,3,12,7],[31,0,31,2],[11,13,12,13],[6,0,6,2],[7,1,7,2],[7,3,7,4],[8,1,8,2],[6,10,7,13],[6,3,6,4],[26,0,26,9],[14,3,14,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[3,0,3,5],[4,0,4,5],[0,0,0,6],[1,0,1,6],[2,7,2,13],[1,7,1,13],[2,0,2,6],[5,10,5,13],[7,7,8,8],[8,10,8,13],[0,22,0,38],[1,22,1,39],[2,22,2,39],[6,7,6,8]]}
["République Tunisienne"]
["Minisrère des Affaires Sociales de la Solidarité",null,null,null,null,null,null,"DECLARARTION TRIMESTRIELLE DES SALARIES ET DES SALAIRES"]
["et des Tunisiens à l'etranager",null,null,null,null,null,null,"doit être remise à la Caisse sous peine de pénalités dans les 15 premiers jours qui suivent le trimestre"]
["CAISSE NATIONALE DE SECURITE SOCIALE"]
["Bureau Régionale Sfax Centre"]
[null,null,null,null,null,null,null,null,null,null,"NOM ET ADRESSE DE L'EMPLOYEUR"]
["N° Employeur :",null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W21","v":242758},null,{"$f":"'CNSS ACHRAF SF1694 012023'!Y21","v":64},null,"Code d'exploitation",null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W6","v":0}]
["BR",null,null,"Trimestre",null,{"$f":"'CNSS ACHRAF SF1694 012023'!Z21","v":1},null,"00"]
["Page N°",1,null,"Année ",null,{"$f":"'CNSS ACHRAF SF1694 012023'!AA21","v":2023},null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W9","v":0}]
[]
["N° Ordre","MATRICULE",null,"IDENTITE DU SALARIE (1)",null,null,null,null,"N°","Catég","REMUNERATION MENSUELLE",null,null,"Reports des Montants"]
[null,null,null,null,null,null,null,null,"chez","Profession",null,null,null,0]
[null,null,"Clé",null,null,null,null,null,"l'EMP","nelle","Janvier","Février","Mars"]
["1",{"$f":"'CNSS ACHRAF SF1694 012023'!I5","v":99999999},{"$f":"'CNSS ACHRAF SF1694 012023'!J5","v":1},{"$f":"'CNSS ACHRAF SF1694 012023'!K5","v":"AAAAAAAAAAAAAAAAA"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q5","v":2000000},{"$f":"'CNSS ACHRAF SF1694 012023'!R5","v":2100000},{"$f":"'CNSS ACHRAF SF1694 012023'!S5","v":1950000},{"$f":"SUM(K14:M14)","v":6050000}]
["2",{"$f":"'CNSS ACHRAF SF1694 012023'!I6","v":88888888},{"$f":"'CNSS ACHRAF SF1694 012023'!J6","v":2},{"$f":"'CNSS ACHRAF SF1694 012023'!K6","v":"BBBBBBBBBBBBBBBBBB"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q6","v":1975000},{"$f":"'CNSS ACHRAF SF1694 012023'!R6","v":2075000},{"$f":"'CNSS ACHRAF SF1694 012023'!S6","v":1925000},{"$f":"SUM(K15:M15)","v":5975000}]
["3",{"$f":"'CNSS ACHRAF SF1694 012023'!I7","v":77777777},{"$f":"'CNSS ACHRAF SF1694 012023'!J7","v":3},{"$f":"'CNSS ACHRAF SF1694 012023'!K7","v":"CCCCCCCCCCCCCCCCCC"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q7","v":1950000},{"$f":"'CNSS ACHRAF SF1694 012023'!R7","v":2050000},{"$f":"'CNSS ACHRAF SF1694 012023'!S7","v":1900000},5900000]
["4",{"$f":"'CNSS ACHRAF SF1694 012023'!I8","v":66666666},{"$f":"'CNSS ACHRAF SF1694 012023'!J8","v":4},{"$f":"'CNSS ACHRAF SF1694 012023'!K8","v":"DDDDDDDDDDDDDDDD"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q8","v":1925000},{"$f":"'CNSS ACHRAF SF1694 012023'!R8","v":2025000},{"$f":"'CNSS ACHRAF SF1694 012023'!S8","v":1875000},5825000]
["5",{"$f":"'CNSS ACHRAF SF1694 012023'!I9","v":55555555},{"$f":"'CNSS ACHRAF SF1694 012023'!J9","v":5},{"$f":"'CNSS ACHRAF SF1694 012023'!K9","v":"EEEEEEEEEEEEEEEEEEEE"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q9","v":1900000},{"$f":"'CNSS ACHRAF SF1694 012023'!R9","v":2000000},{"$f":"'CNSS ACHRAF SF1694 012023'!S9","v":1850000},5750000]
["6",{"$f":"'CNSS ACHRAF SF1694 012023'!I10","v":44444444},{"$f":"'CNSS ACHRAF SF1694 012023'!J10","v":6},{"$f":"'CNSS ACHRAF SF1694 012023'!K10","v":"FFFFFFFFFFFFFFFFFFFFF"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q10","v":1875000},{"$f":"'CNSS ACHRAF SF1694 012023'!R10","v":1975000},{"$f":"'CNSS ACHRAF SF1694 012023'!S10","v":1825000},5675000]
["7",{"$f":"'CNSS ACHRAF SF1694 012023'!I11","v":33333333},{"$f":"'CNSS ACHRAF SF1694 012023'!J11","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K11","v":"GGGGGGGGGGGGGGGGG"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q11","v":1850000},{"$f":"'CNSS ACHRAF SF1694 012023'!R11","v":1950000},{"$f":"'CNSS ACHRAF SF1694 012023'!S11","v":1800000},5600000]
["8",{"$f":"'CNSS ACHRAF SF1694 012023'!I12","v":22222222},{"$f":"'CNSS ACHRAF SF1694 012023'!J12","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K12","v":"HHHHHHHHHHHHHHHHH"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q12","v":1825000},{"$f":"'CNSS ACHRAF SF1694 012023'!R12","v":1925000},{"$f":"'CNSS ACHRAF SF1694 012023'!S12","v":1775000},5525000]
["9",{"$f":"'CNSS ACHRAF SF1694 012023'!I13","v":11111111},{"$f":"'CNSS ACHRAF SF1694 012023'!J13","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K13","v":"IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q13","v":1800000},{"$f":"'CNSS ACHRAF SF1694 012023'!R13","v":1900000},{"$f":"'CNSS ACHRAF SF1694 012023'!S13","v":1750000},5450000]
["10",{"$f":"'CNSS ACHRAF SF1694 012023'!I14","v":17777777},{"$f":"'CNSS ACHRAF SF1694 012023'!J14","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K14","v":"JJJJJJJJJJJJJJJJJJJJJJJJJJJJJJ"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q14","v":1775000},{"$f":"'CNSS ACHRAF SF1694 012023'!R14","v":1875000},{"$f":"'CNSS ACHRAF SF1694 012023'!S14","v":1725000},5375000]
["11",{"$f":"'CNSS ACHRAF SF1694 012023'!I15","v":18888887},{"$f":"'CNSS ACHRAF SF1694 012023'!J15","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K15","v":"KKKKKKKKKKKKKKKKKKKK"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q15","v":1750000},{"$f":"'CNSS ACHRAF SF1694 012023'!R15","v":1850000},{"$f":"'CNSS ACHRAF SF1694 012023'!S15","v":1700000},5300000]
["12",{"$f":"'CNSS ACHRAF SF1694 012023'!I16","v":19999998},{"$f":"'CNSS ACHRAF SF1694 012023'!J16","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K16","v":"LLLLLLLLLLLLLLLLLLLLLLLLLLL"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q16","v":1725000},{"$f":"'CNSS ACHRAF SF1694 012023'!R16","v":1825000},{"$f":"'CNSS ACHRAF SF1694 012023'!S16","v":1675000},5225000]
[]
["Certifié Sincère et conforme à nos documents comptables et arrêté à la somme de :",null,null,null,null,null,null,null,null,null,null,null,"Total à Reporter",{"$f":"SUM(N12:N25)","v":67650000}]
[]
["(1) l'identité doit être conforme à la carte d'assuré ou à l'extrait de naissance",null,null,null,null,null,null,null,null,null,null,null,"TOTAL GENERAL",{"$f":"N27","v":67650000}]
["(2)L'arrêté doit correspondre au total des salaires déclarés pendant le trimestre (à indiquer sur la dernière page)."]
[]
["Nom Opérateur",null,null,"DERGAA ACHRAF"]
["N° de Tél",null,null,21415415,null,null,null,null,null,null,null,"Fait à    Sfax le ",{"$f":" TODAY()","v":"2023-01-27"}]
[null,null,null,null,null,null,null,null,null,null,null,"Cachet et Signature de l'Employeur"]
[null,null,null,null,null,null,null,null,null,null,null,"( sur toutes les pages )"]

{"sheet":"CNSS-012023FEUIL2","index":1,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,22,0,38],[1,0,1,6],[1,7,1,13],[1,22,1,39],[2,0,2,6],[2,7,2,13],[2,22,2,39],[3,0,3,5],[4,0,4,5],[5,10,5,13],[6,7,6,8],[6,10,7,13],[7,7,8,8],[8,10,8,13],[6,0,6,2],[7,1,7,2],[6,3,6,4],[10,0,12,0],[10,1,11,1],[10,3,12,7],[7,3,7,4],[8,3,8,4],[8,1,8,2],[10,10,11,12],[11,13,12,13],[13,3,13,7],[26,0,26,9],[14,3,14,7],[15,3,15,7],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[24,3,24,7],[34,11,34,13],[28,0,28,9],[29,0,29,10],[31,3,31,5],[32,3,32,5],[31,0,31,2],[32,0,32,2],[32,12,32,13],[33,11,33,13]]}
["République Tunisienne"]
["Minisrère des Affaires Sociales de la Solidarité",null,null,null,null,null,null,"DECLARARTION TRIMESTRIELLE DES SALARIES ET DES SALAIRES"]
["et des Tunisiens à l'etranager",null,null,null,null,null,null,"doit être remise à la Caisse sous peine de pénalités dans les 15 premiers jours qui suivent le trimestre"]
["CAISSE NATIONALE DE SECURITE SOCIALE"]
["Bureau Régionale Sfax Centre"]
[null,null,null,null,null,null,null,null,null,null,"NOM ET ADRESSE DE L'EMPLOYEUR"]
["N° Employeur :",null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W21","v":242758},null,{"$f":"'CNSS ACHRAF SF1694 012023'!Y21","v":64},null,"Code d'exploitation",null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W6","v":0}]
["BR",null,null,"Trimestre",null,{"$f":"'CNSS ACHRAF SF1694 012023'!Z21","v":1},null,"00"]
["Page N°",2,null,"Année ",null,{"$f":"'CNSS ACHRAF SF1694 012023'!AA21","v":2023},null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W9","v":0}]
[]
["N° Ordre","MATRICULE",null,"IDENTITE DU SALARIE (1)",null,null,null,null,"N°","Catég","REMUNERATION MENSUELLE",null,null,"Reports des Montants"]
[null,null,null,null,null,null,null,null,"chez","Profession",null,null,null,{"$f":"'CNSS-012023FEUIL1 '!N27","v":67650000}]
[null,null,"Clé",null,null,null,null,null,"l'EMP","nelle","Janvier","Février","Mars"]
["13",{"$f":"'CNSS ACHRAF SF1694 012023'!I17","v":21111119},{"$f":"'CNSS ACHRAF SF1694 012023'!J17","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K17","v":"MMMMMMMMMMMM"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q17","v":1700000},{"$f":"'CNSS ACHRAF SF1694 012023'!R17","v":1800000},{"$f":"'CNSS ACHRAF SF1694 012023'!S17","v":1650000},{"$f":"SUM(K14:M14)","v":5150000}]
["14",{"$f":"'CNSS ACHRAF SF1694 012023'!I18","v":22222220},{"$f":"'CNSS ACHRAF SF1694 012023'!J18","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K18","v":"NNNNNNNNNNNNNNNN"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q18","v":1675000},{"$f":"'CNSS ACHRAF SF1694 012023'!R18","v":1775000},{"$f":"'CNSS ACHRAF SF1694 012023'!S18","v":1625000},{"$f":"SUM(K15:M15)","v":5075000}]
["15",{"$f":"'CNSS ACHRAF SF1694 012023'!I19","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!J19","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!K19","v":0},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q19","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!R19","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!S19","v":0},0]
["16",{"$f":"'CNSS ACHRAF SF1694 012023'!I20","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!J20","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!K20","v":0},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q20","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!R20","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!S20","v":0},0]
["17",{"$f":"'CNSS ACHRAF SF1694 012023'!I21","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!J21","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!K21","v":0},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q21","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!R21","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!S21","v":0},0]
["18",{"$f":"'CNSS ACHRAF SF1694 012023'!I22","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!J22","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!K22","v":0},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q22","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!R22","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!S22","v":0},0]
["19",{"$f":"'CNSS ACHRAF SF1694 012023'!I23","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!J23","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!K23","v":0},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q23","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!R23","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!S23","v":0},0]
["20",{"$f":"'CNSS ACHRAF SF1694 012023'!I24","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!J24","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!K24","v":0},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q24","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!R24","v":0},{"$f":"'CNSS ACHRAF SF1694 012023'!S24","v":0},0]
["21",{"$f":"'CNSS ACHRAF SF1694 012023'!I25","v":2999999},{"$f":"'CNSS ACHRAF SF1694 012023'!J25","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K25","v":"OOOOOOOOOOOOOOO"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q25","v":500000},{"$f":"'CNSS ACHRAF SF1694 012023'!R25","v":500000},{"$f":"'CNSS ACHRAF SF1694 012023'!S25","v":500000},1500000]
["22",{"$f":"'CNSS ACHRAF SF1694 012023'!I26","v":31111108},{"$f":"'CNSS ACHRAF SF1694 012023'!J26","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K26","v":"PPPPPPPPPPPPPPPPPP"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q26","v":600000},{"$f":"'CNSS ACHRAF SF1694 012023'!R26","v":600000},{"$f":"'CNSS ACHRAF SF1694 012023'!S26","v":600000},1800000]
["23",{"$f":"'CNSS ACHRAF SF1694 012023'!I27","v":3222219},{"$f":"'CNSS ACHRAF SF1694 012023'!J27","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K27","v":"QQQQQQQQQQQQQQ"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q27","v":600000},{"$f":"'CNSS ACHRAF SF1694 012023'!R27","v":600000},{"$f":"'CNSS ACHRAF SF1694 012023'!S27","v":600000},1800000]
["24",{"$f":"'CNSS ACHRAF SF1694 012023'!I28","v":333330},{"$f":"'CNSS ACHRAF SF1694 012023'!J28","v":7},{"$f":"'CNSS ACHRAF SF1694 012023'!K28","v":"RRRRRRRRRRRRRRRRRR"},null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q28","v":1000000},{"$f":"'CNSS ACHRAF SF1694 012023'!R28","v":1000000},{"$f":"'CNSS ACHRAF SF1694 012023'!S28","v":1000000},3000000]
[]
["Certifié Sincère et conforme à nos documents comptables et arrêté à la somme de :",null,null,null,null,null,null,null,null,null,null,null,"Total à Reporter",{"$f":"SUM(N12:N25)","v":85975000}]
[]
["(1) l'identité doit être conforme à la carte d'assuré ou à l'extrait de naissance",null,null,null,null,null,null,null,null,null,null,null,"TOTAL GENERAL",{"$f":"N27","v":85975000}]
["(2)L'arrêté doit correspondre au total des salaires déclarés pendant le trimestre (à indiquer sur la dernière page)."]
[]
["Nom Opérateur",null,null,"DERGAA ACHRAF"]
["N° de Tél",null,null,21415415,null,null,null,null,null,null,null,"Fait à    Sfax le ",{"$f":" TODAY()","v":"2023-01-27"}]
[null,null,null,null,null,null,null,null,null,null,null,"Cachet et Signature de l'Employeur"]
[null,null,null,null,null,null,null,null,null,null,null,"( sur toutes les pages )"]

{"sheet":"CNSS ACHRAF SF1694 012023","index":2,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,22,14,27],[18,25,19,25],[29,16,29,18],[4,22,4,27],[18,26,19,27],[22,26,22,27],[23,25,23,27],[5,22,6,27],[8,22,9,27],[19,22,19,23],[20,22,20,23],[20,26,20,27],[21,26,21,27],[7,22,7,27],[10,22,10,23],[11,22,11,27],[12,22,12,27],[13,22,13,27],[2,15,3,15],[2,1,2,2],[2,3,3,3],[2,4,2,5],[2,6,3,6],[2,7,3,7],[2,8,2,9],[2,0,3,0],[2,10,3,10],[2,11,3,11],[28,19,29,19],[23,22,23,24],[21,22,21,24],[22,22,22,24],[2,12,3,12],[2,13,3,13],[2,14,3,14],[2,16,3,16],[2,17,3,17],[18,22,18,24],[2,18,3,18],[2,19,3,19],[2,20,3,20]]}
["CHALUTIER ACHRAF SF 1694 ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1ER TRIMESTRE 2023"]
[null,"8c","2c","4c","1c","4c","3c","2c","8c","2c","60c","8c",null,null,null,null,null,null,null,"10c","10c"]
[null,"N° Employeur",null,"Code d'Exploitation","Période",null,"N° Page","N° Ligne","N° Assuré Social",null,"Identité Assuré","CIN","Date de Naissance","Situation Familiale","Nombre Enfants","Poste","Janvier","Février","Mars","Salaire a déclarer","Zone vierge"]
[null,"Matricule","Clé",null,"Trimestre","Année",null,null,"Matricule","Clé"]
[1,{"$f":"$W$21","v":242758},{"$f":"$Y$21","v":64},"0000","1","2023","001","01",99999999,1,"AAAAAAAAAAAAAAAAA",11111111,"1952-10-01","M",1,"PATRON",2000000,2100000,1950000,{"$f":"SUM(Q5:S5)","v":6050000},"0000000000",null,"NOM DE L'EMPLOYEUR"]
[2,242758,64,"0000","1","2023","001","02",88888888,2,"BBBBBBBBBBBBBBBBBB",22222222,"1960-12-01","M",2,"AIDE PATRON",1975000,2075000,1925000,{"$f":"SUM(Q6:S6)","v":5975000},"0000000000"]
[3,242758,64,"0000","1","2023","001","03",77777777,3,"CCCCCCCCCCCCCCCCCC",33333333,"1960-12-02","M",0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I6","v":"MECANICIEN"},1950000,2050000,1900000,5900000,"0000000000"]
[4,242758,64,"0000","1","2023","001","04",66666666,4,"DDDDDDDDDDDDDDDD",44444444,"1960-12-03","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H7","v":0},"CUISINIER",1925000,2025000,1875000,5825000,"0000000000",null,"ADRESSE DE L'EMPLOYEUR"]
[5,242758,64,"0000","1","2023","001","05",55555555,5,"EEEEEEEEEEEEEEEEEEEE",55555555,"1960-12-04","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H8","v":0},"MARIN",1900000,2000000,1850000,5750000,"0000000000"]
[6,242758,64,"0000","1","2023","001","06",44444444,6,"FFFFFFFFFFFFFFFFFFFFF",66666666,"1960-12-05","M",1,"MARIN",1875000,1975000,1825000,5675000,"0000000000"]
[7,242758,64,"0000","1","2023","001","07",33333333,7,"GGGGGGGGGGGGGGGGG",77777777,"1960-12-06","M",2,"MARIN",1850000,1950000,1800000,5600000,"0000000000"]
[8,242758,64,"0000","1","2023","001","08",22222222,7,"HHHHHHHHHHHHHHHHH",88888888,"1960-12-07","M",3,"MARIN",1825000,1925000,1775000,5525000,"0000000000",null,"NOM DE L'OPERATEUR"]
[9,242758,64,"0000","1","2023","001","09",11111111,7,"IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII",99999999,"1960-12-08","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H12","v":0},"MARIN",1800000,1900000,1750000,5450000,"0000000000"]
[10,242758,64,"0000","1","2023","001","10",17777777,7,"JJJJJJJJJJJJJJJJJJJJJJJJJJJJJJ",1000000,"1960-12-09","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H13","v":0},"MARIN",1775000,1875000,1725000,5375000,"0000000000",null,"NUMERO DE TELEPHONE DE L'OPERATEUR"]
[11,242758,64,"0000","1","2023","001","11",18888887,7,"KKKKKKKKKKKKKKKKKKKK",1000001,"1960-12-10","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H14","v":0},"MARIN",1750000,1850000,1700000,5300000,"0000000000"]
[12,242758,64,"0000","1","2023","001","12",19999998,7,"LLLLLLLLLLLLLLLLLLLLLLLLLLL",1000002,"1960-12-11","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H15","v":0},"MARIN",1725000,1825000,1675000,5225000,"0000000000"]
[13,242758,64,"0000","1","2023","002","01",21111119,7,"MMMMMMMMMMMM",1000003,"1960-12-12","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H16","v":0},"MARIN",1700000,1800000,1650000,5150000,"0000000000"]
[14,242758,64,"0000","1","2023","002","02",22222220,7,"NNNNNNNNNNNNNNNN",1000004,"1960-12-13","C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H17","v":0},"MARIN",1675000,1775000,1625000,5075000,"0000000000"]
[15,242758,64,"0000","1","2023","002","03",0,0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!B18","v":0},0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D18","v":"00:00:00"},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!G18","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H18","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I18","v":0},0,0,0,0,"0000000000",null,"N° EMPLOYEUR",null,null,"TRIMESTRE","ANNEE"]
[16,242758,64,"0000","1","2023","002","04",0,0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!B19","v":0},0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D19","v":"00:00:00"},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!G19","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H19","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I19","v":0},0,0,0,0,"0000000000",null,"Matricule",null,"Clé"]
[17,242758,64,"0000","1","2023","002","05",0,0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!B20","v":0},0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D20","v":"00:00:00"},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!G20","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H20","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I20","v":0},0,0,0,0,"0000000000",null,242758,null,64,1,2023]
[18,242758,64,"0000","1","2023","002","06",0,0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!B21","v":0},0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D21","v":"00:00:00"},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!G21","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H21","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I21","v":0},0,0,0,0,"0000000000",null,"Sécurité Sociale",null,null,0.25750000000000001,{"$f":"Q30*Z22","v":22138562.5}]
[19,242758,64,"0000","1","2023","002","07",0,0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!B22","v":0},0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D22","v":"00:00:00"},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!G22","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H22","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I22","v":0},0,0,0,0,"0000000000",null,"Accident Travail",null,null,6.0000000000000001E-3,{"$f":"Q30*Z23","v":515850}]
[20,242758,64,"0000","1","2023","002","08",0,0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!B23","v":0},0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D23","v":"00:00:00"},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!G23","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H23","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I23","v":0},0,0,0,0,"0000000000",null,"Montant a payer",null,null,{"$f":"SUM(AA22:AB23)","v":22654412.5}]
[21,242758,64,"0000","1","2023","002","09",2999999,7,"OOOOOOOOOOOOOOO",1000011,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D24","v":"00:00:00"},"M",1,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I24","v":"GARDIEN"},500000,500000,500000,1500000,"0000000000"]
[22,242758,64,"0000","1","2023","002","10",31111108,7,"PPPPPPPPPPPPPPPPPP",1000012,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D25","v":"00:00:00"},"M",1,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I25","v":"PORTEFAIX"},600000,600000,600000,1800000,"0000000000"]
[23,242758,64,"0000","1","2023","002","11",3222219,7,"QQQQQQQQQQQQQQ",1000013,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D26","v":"00:00:00"},"M",0,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I26","v":"CHEF D'ARMEMENT"},600000,600000,600000,1800000,"0000000000"]
[24,242758,64,"0000","1","2023","002","12",333330,7,"RRRRRRRRRRRRRRRRRR",1000014,{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!D27","v":"00:00:00"},"C",{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!H27","v":0},{"$f":"'[1]CHALUTIER ACHRAF SF1694 01-2023'!I27","v":"COMPTABLE"},1000000,1000000,1000000,3000000,"0000000000"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q5:Q28)","v":28425000},{"$f":"SUM(R5:R28)","v":29825000},{"$f":"SUM(S5:S28)","v":27725000},{"$f":"SUM(T5:T28)","v":85975000}]
[null,"On commence  a enregistrer ligne par ligne sauf si le salaire à declarer <> 0 et chaque 12 lignes on change le numero de page ( 1 puis 2 ….)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q29:S29)","v":85975000}]
[null,"Structure du fichier comme suit sans espace sauf pour l'identité d Assuré qui doit etre sur 6 caracteres (espace compris ) :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Le fichier doit etre entregistrer sur ce repertoire : C:\\DECLARATION_CNSS avec comme nom : MatriculeEmployeur-Clé_Code d'exploitation_trimestreAnnee",null,null,null,null,null,null,null,null,null,null,null,"00242758-64_0000_12023"]

{"sheet":"RECAP_SALAIRE T1","index":3,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,8,22,10],[9,0,9,1],[9,2,9,3],[9,4,9,5],[10,0,10,1],[10,2,10,3],[10,4,10,5],[10,7,10,10],[15,0,15,2],[15,3,15,5],[15,8,15,9],[16,0,16,2],[16,3,16,5],[21,8,21,9],[8,2,8,4],[12,1,14,1],[12,3,14,4],[12,8,12,9],[13,7,14,7],[8,7,9,10],[7,2,7,4],[7,7,7,10],[0,0,0,10],[1,0,1,4],[1,8,1,10],[2,0,2,4],[2,8,2,10],[3,0,3,4],[3,8,3,10],[4,0,4,4],[4,8,4,10],[5,0,5,4],[5,8,5,10],[6,7,6,10]]}
["ETAT RECAPITULATIF DES SALAIRES ET APPOINTEMENTS"]
["République Tunisienne",null,null,null,null,null,null,null,"الجمهورية التونسية"]
["Ministère des Affaires Sociales de la Solidarité",null,null,null,null,null,null,null,"وزارة الشؤون الاجتماعية و التضامن"]
["et des Tunisiens à l'étranger",null,null,null,null,null,null,null,"و التونسيين بالخارج"]
["Caisse Nationale de sécurité sociale",null,null,null,null,null,null,null,"       الصندوق الوطني للضمان الاجتماعي"]
["Bureau régionale Sfax Medina",null,null,null,null,null,null,null,"      المكتب الجهوي صفاقس المدينة"]
[]
["TR","Année","Numéro Employeur",null,null,"BR",null,"Nom et adresse de l'employeur"]
[{"$f":"'CNSS ACHRAF SF1694 012023'!Z21","v":1},{"$f":"'CNSS ACHRAF SF1694 012023'!AA21","v":2023},{"$f":"'CNSS ACHRAF SF1694 012023'!W21","v":242758},null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Y21","v":64},null,{"$f":"'CNSS ACHRAF SF1694 012023'!W6","v":0}]
["Permanent",null,"Occasionnels",null,"Nbre Tot. salariés"]
[null,null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W9","v":0}]
[]
[null,"CODE",null,"00",null,null,null,"Salaires Déclarés","Taux De Cotisation",null,"Montant à Payer"]
[null,null,null,null,null,null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!Q30","v":85975000},"Sécurité Sociale",0.25750000000000001,{"$f":"H14*J14","v":22138562.5}]
[null,null,null,null,null,null,null,null,"Accident Du Travail",6.0000000000000001E-3,{"$f":"H14*J15","v":515850}]
["Nom Opérateur",null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W13","v":0},null,null,null,null,"Total à Payer",null,{"$f":"K14+K15","v":22654412.5}]
["N° de Tél",null,null,{"$f":"'CNSS ACHRAF SF1694 012023'!W15","v":0}]
["La présente déclaration de salaires certifiée sincère et conforme à nos documents comptables est arrêtée à la somme de :"]
[]
[]
["Mode de paiement :"]
["Chéque N°",null,"Banque",null,null,null,null,null,"Fait à , Sfax le :",null,{"$f":"TODAY()","v":"2023-01-27"}]
["Virement bancaire sur :",null,null,null,null,null,null,null,"Signature et cachet de l'employeur"]

{"sheet":"CdC","index":4,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Générer un fichier Txt à partir un fichier Excel"]
[]
[null,null,null,"KARROUMAYAGHALI - 26 janv. 2023 à 12:01"]
[null,null,null," KARROUMAYAGHALI - 27 janv. 2023 à 15:01"]
[null,null,null,"Bonjour ALL,"]
[]
[null,null,null,"je suis vraiment nouveau dans la programmation, je suis à la recherche d'une procédure, qui va me permettre de mettre en place un macro à l'aide d'un bouton dans un fichier Excel pour générer un fichier texte (txt) ( sachant que le fichier doit être générer a partir de la 3éme feuille du mon fichier Excel . "]
[null,null,null,"la 3 ème feuille son nom est CNSS comporte"]
[null,null,null,"- une entête sur  4 lignes"]
[null,null,null,"- les valeurs a enregistrer dans le fichier commencent  à partir de la 5 ème ligne 2 ème colonne ( B5 ) comportant :"]
[null,null,null,"       * matricule1:8 caractères ;  clé1 : 2 caractères ;  codeExp: 4 chiffre ; trimestre : 1 c ; Année : 4 c ; Num page : 3 c; Num ligne 2 c ; matricule2 : 8 c; clé2 : 2c ;Identité : 60c ; num carte : 8c; salaire: 10 c; zone : 10 c"]
[null,null,null,"il ya maximum 100 lignes"]
[null,null,null,"( L'enregistrement sans espaces ou caractères ) "]
[null,null,null,"0024275864000012023001010000000000aaaaaaaaaaaaaaaaaaaaaaaaaaa                                              0000000000090000000000000000"]
[null,null,null,"nom du fichier à générer  : matricule1cle1codeExp.TrimstreAnnée"]
[null,null,null,"Répertoire : au choix"]
[null,null,null,"le nom "]
[null,null,null,"Achraf"]