{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ENTETE","DEC   PAPIER ","DEC   RECAP","HELP"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":10,"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":"ENTETE","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,0,10,1]]}
[]
["NOM DE LA SOCIETE"]
["ADRESS"]
["IDENTITE  FISCAL"]
["CNSS",null,"CLE CNSS"]
["CODE D'EXPLOITATION"]
["TRIMESTRE ","4"]
["ANNEE","2018"]
["chemin du fichier generer:","D:\\"]
[]
["TAUX CNSS"]
[]
["CHARGE SALARIALE ",0.16569999999999999]
["CHARGE PATRONALE",9.1800000000000007E-2]
["ACCIDENT DE TRAVAIL",5.0000000000000001E-3]

{"sheet":"DEC   PAPIER ","index":1,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,4,4,9],[5,4,5,9],[7,4,7,9],[6,4,6,9],[0,0,0,9]]}
["                                DECLARATION TRIMESTRIELLE DES SALAIRES ET DES SALARIES"]
[]
[]
[]
["N° EMPLOYEUR: ",null,{"$f":"+CONCATENATE(ENTETE!B5,\" - \",ENTETE!D5)","v":" - "},null,"Nom et adresse de l'employeur"]
["TRIMESTRE:",null,{"$f":"+ENTETE!B7","v":"4"},null,{"$f":"+ENTETE!B2","v":0}]
["ANNEE:",null,{"$f":"+ENTETE!B8","v":"2018"},null,{"$f":"+ENTETE!B3","v":0}]
[null,null,null,null,{"$f":"+CONCATENATE(\"MF \",ENTETE!B4)","v":"MF "}]
[]
["N° ordre","MATRICULE CNSS","IDENTITE DU SALARIE","N° interne","N° CIN",null,"1ER MOIS","2EME MOIS","3EME MOIS","TOTAL"]
[]
[1,null,null,null,null,null,null,null,null,{"$f":"+ROUND(SUM(G12:I12),3)","v":0}]
[2,null,null,null,null,null,null,null,null,{"$f":"+ROUND(SUM(G13:I13),3)","v":0}]
[3,null,null,null,null,null,null,null,null,{"$f":"+ROUND(SUM(G14:I14),3)","v":0}]
[4,null,null,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,null,null,{"$f":"+ROUND(SUM(G17:I17),3)","v":0}]
[7,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,"TOTAL",null,null,null,{"$f":"+SUM(G12:G25)","v":0},{"$f":"+SUM(H12:H25)","v":0},{"$f":"+SUM(I12:I25)","v":0},{"$f":"+SUM(J12:J25)","v":0}]
[]
["Certifié sincère et conforme à nos documents comptables et arreté à la somme de "]
[{"$f":"+CONCATENATE(ConvNumberLetter(ROUNDDOWN(J28,0),1,0,3,0),ROUND(J28-ROUNDDOWN(J28,0),3)*1000,\" millimes\")","v":{"$error":"#NAME?"}}]

{"sheet":"DEC   RECAP","index":2,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,0,7,14],[10,0,10,1],[10,2,10,6],[10,9,10,14],[11,0,11,1],[11,2,11,6],[13,0,14,1],[13,2,13,3],[13,4,13,5],[13,6,13,7],[14,2,14,3],[14,4,14,5],[14,6,14,7],[20,12,20,13],[22,12,22,13],[24,12,24,13],[28,13,28,14],[16,1,16,7],[16,9,16,10],[16,11,16,13],[17,9,18,10],[17,11,17,12],[18,11,18,12]]}
[]
[]
[]
[]
[]
[]
[]
["Etat recapitulatif des salaires déclarés"]
[]
[]
["Trimestre et année",null,"Numéro Employeur",null,null,null,null,"BR",null,"Nom et adresse de l'employeur"]
[{"$f":"+CONCATENATE(ENTETE!B7,\" / \",ENTETE!B8)","v":"4 / 2018"},null,{"$f":"+CONCATENATE(ENTETE!B5,\"-\",ENTETE!D5)","v":"-"},null,null,null,null,null,null,{"$f":"+ENTETE!B2","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+ENTETE!B3","v":0}]
["Nombre de \nsalariés",null,"Permanents ",null," Occasionnels",null,"Total",null,null,{"$f":"+CONCATENATE(\"MF \",ENTETE!B4)","v":"MF "}]
[]
[]
[null,"Réservé aux services de la CNSS",null,null,null,null,null,null,null,"Salaires déclarés",null,"Taux de cotisation",null,null,"Montant à payer"]
["Montant payé :                                              le",null,null,null,null,null,null,null,null,{"$f":"+'DEC   PAPIER '!J28","v":0},null,"Sécurété sociale",null,{"$f":"+ENTETE!B13+ENTETE!B14","v":0.25750000000000001},{"$f":"+J18*N18","v":0}]
["□","Espèces",null,null,null,null,null,null,null,null,null,"Accident de travail",null,{"$f":"+ENTETE!B15","v":5.0000000000000001E-3},{"$f":"+J18*N19","v":0}]
["□","Chèque n°                                 sur"]
["□","Virement sur",null,null,null,null,null,null,null,null,null,null,"Cotisations",null,{"$f":"SUM(O18:O20)","v":0}]
[]
["□","Mandat n°",null,null,null,null,null,null,null,null,null,null,"Pénalités"]
[]
["□",null,null,null,null,null,null,null,null,null,null,null,"Total à payer",null,{"$f":"SUM(O21:O23)","v":0}]
[]
["La présente déclaration de salaires certifiée sincere et conforme à nos document comptables est arretée à la somme de :"]
["Zéro  Dinar0 millimes"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+CONCATENATE(\"Fait à Tunis le \",)","v":"Fait à Tunis le "},null,{"$f":"+TODAY()","v":"2018-07-17"}]
[null,null,null,null,null,null,null,null,null,null,null,"signature et cachet de l'employeur "]

{"sheet":"HELP","index":3,"n_rows":108,"n_cols":2,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,0,3,11]]}
["COMMENT UTILISER CE FICHIER"]
[]
[]
[]
["NB: ne pas modifier les noms des feuilles ; ce fichier est compatible avec Excel 2003, 2007, 2010 et 2013"]
["ETAPE 1: REMPLIR LES ZONE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["ETAPE 2: REMPLIR DEC PAPIER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NB 1: matricule cnss doit etre numerique"]
[null,"exmple si matricule est 2013336-06 il doit etre ecrite de cette facon 201333606 sans depasse 10 caractere"]
[null,"NB 2: numero cin doit etre numerique "]
[]
["ETAPE 3: cliquer sur  traitement cnss dans la feuille entete"]
[]
[]
[]
[]
["ETAPE 4: cliquer sur  traitement cnss dans la feuille entete"]
[]
["si le produit non encore activer une icone s'affiche"]
[null,"1-cliquer sur afficher"]
[null,"2-contacter le fournissuer pour l'activer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["si le produit est activer "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["tu choisi le traitement que vous souhaiter"]