{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["DONNES","PAGE-GARDE","REV-PROF","REV-AGR","REV-SAL","REV-FONC","REV-FONC-AGR","REV-CAPMOB","REV-ETRANGER","REV-TAXABLE","CALCUL IR","VERSEMENT IR","CHIFFRE EN LETTERE","RECU"],"not_rendered":{"charts":0,"images":8,"macros":0,"external_links":3,"defined_names":185,"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":"DONNES","index":0,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,1,1,2],[2,1,2,2],[3,2,4,2],[3,1,4,1]]}
["DECLARATION IR  2015"]
[null,"ANNEE",null,null,"IMPUTATIONS ET REDUCTIONS"]
[null,"01-01-2015 AU 31-12-2015"]
[null,"NOM ET PRENOM","ABDO TEST"," ","COTISATION MINIMALE ACQUITTEE","R.PROFESSIONNEL","R.AGRICOLE"]
[null,null,null,null,"-Cotisation Minimale versée",214145,2745]
[null,"IDENTIFIANT FISCAL",80422222,null,"-Date de Versement","2016-01-31","2016-01-31"]
[null,"TAXE PROFESSIONNELLE",50422222,null,"-N° Quittance ",12121212,21212121]
[null,"CIN N° :","K6333333"]
[null,"ACTIVITE","TRAVAUX COMPTABLES",null,"IMPOT RETENU A LA SOURCE","MONTANT"]
[null,"ADRESSE ","AVE MOHAMED V N° 05",null,"-IR retenu sur salaire",65464]
[null,"VILLE","CASABLANCA",null,"-Au titre des produits de placement à revenu fixe soumis au taux de 20% :",10520]
[null,"TSCE :",809333333,null,"-Montant de l'impôt étranger acquitté",15625]
[null,"TSCE :",809333333,null,"-Montant de l'impôt étranger théorique en cas d'exonération :",6250]
[null,"ADRESSE PRECEDENTE :",{"$f":"+C10","v":"AVE MOHAMED V N° 05"}]
[null,"Ville :",{"$f":"+C11","v":"CASABLANCA"},null,"REDUCTION D'IMPOT","MONTANT"]
[null,"Subdivision ",{"$f":"C11&\"- ville\"","v":"CASABLANCA- ville"},null,"- NOMBRE DE DEDUCTION C.F",4]
[null,"Perception :",{"$f":"+C11","v":"CASABLANCA"},null,"- Pour charge de famille :",{"$f":"+F16*12*30","v":1440}]
[null,"TELEPHONE","06-61-61-61",null,"- Au titre des retraites de source étrangère :",5752]
[null,"EMAIL","abdo@gmail.com"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Célibataire"]
[null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,"Marié"]
[null,null,null,null,null,null,null,null,null,true,{"$f":"IF(J23=TRUE,1,2)","v":1},null,null,null,null,null,"Divorcé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veuf"]
[null,null,null,null,null,null,null,null,null,true,{"$f":"IF(J25=TRUE,1,2)","v":1}]
[null,null,null,null,null,null,null,null,null,true,1,null,null,null,null,null,"oui"]
[null,null,null,null,null,null,null,null,null,true,1,null,null,null,null,null,"non"]
[null,null,null,null,null,null,null,null,null,false,2]
[null,null,null,null,null,null,null,null,null,true,1]
[null,null,null,null,null,null,null,null,null,true,{"$f":"IF(J30=TRUE,1,2)","v":1}]
[null,null,null,null,null,null,null,null,null,true,{"$f":"IF(J31=TRUE,1,2)","v":1}]
[null,null,null,null,null,null,null,null,null,false,{"$f":"IF(J32=TRUE,1,2)","v":2}]
[null,null,"Situation de famille:","Veuf"]
[null,null,"Revenus"]
[null,null,"Revenus Professionnels ","non"]
[null,null,"Revenus agricoles ","oui"]
[null,null,"Revenus salariaux","oui"]
[null,null,"Revenus fonciers","oui"]
[null,null,"Revenus fonciers agricoles","oui"]
[null,null,"Revenus de Capitaux mobiles","oui"]
[null,null,"revenus de source étrangère","oui"]

{"sheet":"PAGE-GARDE","index":1,"n_rows":118,"n_cols":36,"rows_kept":118,"cut":false,"hidden":false,"merged":[[21,3,21,18],[21,34,21,41],[23,7,23,31],[25,3,25,18],[27,10,27,41],[89,17,89,25],[89,31,89,40],[7,11,7,30],[8,11,8,30],[12,11,12,31],[29,5,29,41],[31,4,31,16],[31,21,31,41],[10,15,10,21],[10,24,10,30],[25,34,25,41],[55,33,56,42],[18,1,19,31],[14,6,14,30],[14,34,14,41],[17,34,17,41],[74,9,74,40],[76,6,76,40],[78,1,78,8],[78,16,78,24],[78,31,78,40],[105,17,105,25],[105,31,105,40],[109,17,109,25],[109,31,109,40],[89,0,89,14],[93,0,93,14],[97,0,97,14],[101,0,101,14],[105,0,105,14],[109,0,109,14],[93,17,93,25],[93,31,93,40],[97,17,97,25],[97,31,97,40],[101,17,101,25],[101,31,101,40]]}
[null,"ROYAUME DU MAROC ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modèle n°ADP010F-14E"]
[]
[]
[]
[]
[]
[]
["DR/DIP/DP de :",null,null,null,null,null,null,null,null,null,null,"IMPOT SUR LE REVENU"]
["………...……………………….",null,null,null,null,null,null,null,null,null,null,"DECLARATION DU REVENU GLOBAL"]
["Subdivision:"]
["…………………………………",null,null,null,null,null,null,null,null,null,null,null,null,"Du ",null,"2015-01-01",null,null,null,null,null,null,"Au",null,"2015-12-31"]
["Secteur :",null,null,"…………..………"]
[null,null,null,null,null,null,null,null,null,null,null,"IDENTIFICATION  DU  CONTRIBUABLE"]
[]
["Nom et Prénom(s)",null,null,null,null,null,{"$f":"+DONNES!C4","v":"ABDO TEST"},null,null,null,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":"+DONNES!C6","v":80422222}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° D'identification fiscale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Adresse actuelle du domicile fiscal ou du principal établissement ",null,null,null,null,null,null,null,null,null,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":"+DONNES!C8","v":"K6333333"}]
[null,{"$f":"+DONNES!C10","v":"AVE MOHAMED V N° 05"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° carte nationale d'identité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","ou carte de séjour"]
[]
["Ville : ",null,null,{"$f":"+DONNES!C11","v":"CASABLANCA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° d'identification à la T.S.C(1)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C12","v":809333333}]
[]
["Adresse précédente :",null,null,null,null,null,null,{"$f":"+DONNES!C14","v":"AVE MOHAMED V N° 05"}]
[]
["Ville : ",null,null,{"$f":"+DONNES!C15","v":"CASABLANCA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° d'identification à la T.S.C(1)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C13","v":809333333}]
[]
["Profession /activité principale :",null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C9","v":"TRAVAUX COMPTABLES"}]
[]
["Nationalité:",null,null,null,null,"MAROCAINE "]
[]
["Téléphone :",null,null,null,{"$f":"+DONNES!C18","v":"06-61-61-61"},null,null,null,null,null,null,null,null,null,null,null,null,null,"e-mail :",null,null,{"$f":"+DONNES!C19","v":"abdo@gmail.com"}]
[]
["Situaion de famille :",null,null,null,null,null,null,null,null,null,"Célibataire ",null,null,null,{"$f":"IF(SitF=\"Célibataire\",\"X\",\"\")","v":""},null,null,null,"Marié(e )",null,null,{"$f":"IF(SitF=\"Marié\",\"X\",\"\")","v":""},null,null,"Veuf (ve)",null,null,{"$f":"IF(SitF=\"Veuf\",\"X\",\"\")","v":"X"},null,null,"Divorcé (e )",null,null,null,{"$f":"IF(SitF=\"Divorcé\",\"X\",\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NATURE DES REVENUS "]
["Mettre une croix dans la (ou les) case(s) appropriée (s) et joindre l'état ou les états corresponrants à"]
["vos revenus dûment servi(s)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oui",null,null,null,"Non"]
["Revenus professionnels ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DONNES!J23=TRUE,\"X\",\"  \")","v":"X"},null,null,{"$f":"IF(DONNES!J23=FALSE,\"X\",\"  \")","v":"  "},null,"(Etat n° ADP011F-14E)"]
[]
["Revenus agricoles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DONNES!J25=TRUE,\"X\",\"  \")","v":"X"},null,null,{"$f":"IF(DONNES!J25=FALSE,\"X\",\"  \")","v":"  "},null,"(Etat n° ADP012F-14E)"]
[]
["Revenus salariaux et assimilés",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DONNES!J26=TRUE,\"X\",\"  \")","v":"X"},null,null,{"$f":"IF(DONNES!J26=FALSE,\"X\",\"  \")","v":"  "},null,"(Etat n° ADP013F-14E)"]
[]
["Revenus fonciers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DONNES!J27=TRUE,\"X\",\"  \")","v":"X"},null,null,{"$f":"IF(DONNES!J27=FALSE,\"X\",\"  \")","v":"  "},null,"(Etat n° ADP014F-14E et/ou ADP015F-14E)"]
[]
["Revenus de capitaux mobiliers ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DONNES!J28=TRUE,\"X\",\"  \")","v":"  "},null,null,{"$f":"IF(DONNES!J28=FALSE,\"X\",\"  \")","v":"X"},null,"(Etat n° ADP016F-14E)"]
[]
["Revenus et profits de source étrangère",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(DONNES!J29=TRUE,\"X\",\"  \")","v":"X"},null,null,{"$f":"IF(DONNES!J29=FALSE,\"X\",\"  \")","v":"  "},null,"(Etat n° ADP017F-14E)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"CADRE RESERVE A L'ADMINISTRATION "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cachet"]
["Déclaration reçue le :",null,null,null,null,null,null,null,"……………………………..",null,null,null,null,null,null,null,null,"Enregistrée sous N°",null,null,null,null,null,null,null,"……………...……….."]
[]
["Nombre d'états :",null,null,null,null,null,"……………………………………",null,null,null,null,null,null,null,null,null,null,"Nombre d'annexes:",null,null,null,null,null,null,"…………………………….."]
[]
["Nombre de pièces justificatives :",null,null,null,null,null,null,null,null,null,"……………………."]
[]
[]
[]
[" (1) T.S.C : Taxe de services communaux."]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PERSONNES  A  CHARGE"]
[]
[null,"I- CONJOINT "]
[]
[null,"Nom et prénom (s)"]
[]
[null,"Profession  "]
[]
[]
[null,null,"N° C.N.I",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° Carte de séjour ",null,null,null,null,null,null,null,null,null,null,null,null,null,"N° d'identification fiscale"]
[]
[]
[null,"II - ENFANTS   (en commençant par le plus jeune) (1)"]
[]
[]
[null,null,null,null,"Nom et Prénom ",null,null,null,null,null,null,null,null,null,null,null,null,"Date de naissance ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° de la C.N.I"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"(1)","-","A condition qu'ils soient âgés de moins de 27 ans et qu'ils ne disposent pas de revenu annuel supérieur"]
[null,null,null,"au seuil exonéré d'imposition. Cette condition d'âge n'est pas applicable aux enfants atteints d'infirmité. "]
[null,null,"-","Joindre les extraits d'actes  de naissance,"]

{"sheet":"REV-PROF","index":2,"n_rows":116,"n_cols":24,"rows_kept":116,"cut":false,"hidden":false,"merged":[[80,23,80,26],[84,23,84,26],[88,23,88,26],[94,23,94,26],[98,23,98,26],[102,23,102,26],[90,2,90,10],[92,0,93,10],[94,4,94,10],[95,3,95,10],[96,2,96,10],[85,3,85,10],[86,2,86,10],[88,4,88,10],[89,3,89,10],[81,23,81,26],[82,2,82,10],[84,11,84,14],[88,11,88,14],[84,19,84,22],[84,15,84,18],[88,15,88,18],[82,15,82,18],[88,19,88,22],[104,2,104,10],[106,19,106,26],[106,11,106,18],[98,4,98,10],[99,3,99,10],[100,2,100,10],[102,4,102,10],[103,3,103,10],[94,11,94,14],[98,11,98,14],[102,11,102,14],[94,15,94,18],[98,15,98,18],[102,15,102,18],[94,19,94,22],[98,19,98,22],[102,19,102,22],[78,4,78,10],[80,4,80,10],[81,3,81,10],[81,11,81,14],[81,15,81,18],[81,19,81,22],[80,11,80,14],[80,19,80,22],[84,4,84,10],[80,15,80,18],[75,2,75,10],[77,2,77,10],[73,11,73,14],[73,19,73,22],[73,15,73,18],[74,4,74,10],[76,4,76,10],[73,23,73,26],[75,11,75,14],[75,15,75,18],[75,19,75,22],[75,23,75,26],[77,11,77,14],[77,15,77,18],[77,19,77,22],[77,23,77,26],[67,11,67,18],[65,19,66,26],[67,19,67,26],[68,11,71,14],[68,15,71,18],[68,19,71,22],[68,23,71,26],[65,0,71,10],[73,2,73,10],[59,0,59,24],[47,14,47,15],[48,14,48,15],[46,5,46,7],[47,5,47,7],[47,0,47,2],[48,0,48,2],[60,0,60,26],[65,11,66,18],[46,0,46,2],[48,5,48,7],[48,11,48,13],[46,8,46,10],[47,8,47,10],[48,8,48,10],[47,11,47,13],[46,23,46,26],[47,23,47,26],[48,23,48,26],[46,16,46,18],[47,16,47,18],[48,16,48,18],[47,21,47,22],[48,21,48,22],[47,19,47,20],[48,19,48,20],[44,16,44,18],[45,16,45,18],[33,11,33,14],[33,15,33,18],[33,19,33,22],[46,21,46,22],[46,19,46,20],[46,14,46,15],[46,11,46,13],[39,0,43,7],[39,8,43,15],[39,16,43,26],[44,19,44,22],[44,23,45,25],[45,11,45,13],[44,3,44,4],[44,5,45,7],[45,19,45,20],[45,21,45,22],[44,0,44,2],[45,0,45,2],[44,8,44,10],[45,8,45,10],[44,11,44,15],[16,19,16,22],[16,23,16,26],[20,3,20,10],[23,4,23,10],[24,3,24,10],[15,4,15,10],[17,4,17,10],[30,2,30,10],[28,4,28,10],[21,2,21,10],[34,2,34,10],[14,2,14,10],[16,2,16,10],[16,11,16,14],[16,15,16,18],[19,4,19,10],[25,2,25,10],[29,11,29,14],[29,15,29,18],[32,4,32,10],[29,3,29,10],[33,3,33,10],[1,0,1,24],[3,0,3,26],[14,11,14,14],[14,15,14,18],[14,19,14,22],[14,23,14,26],[6,23,6,25],[12,11,12,14],[12,15,12,18],[9,11,9,14],[8,0,12,10],[8,11,8,26],[11,15,11,18],[10,11,10,14],[11,19,11,22],[7,3,7,25],[12,19,12,22],[9,23,12,26],[9,15,10,22],[6,4,6,16],[36,23,36,26],[20,11,20,14],[36,11,36,14],[20,15,20,18],[20,19,20,22],[36,15,36,18],[20,23,20,26],[36,19,36,22],[29,23,29,26],[24,23,24,26],[24,11,24,14],[24,15,24,18],[24,19,24,22],[29,19,29,22],[33,23,33,26]]}
[]
["Etat n° ADP011F-14E"]
[]
["Revenus professionnels"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Annexe n° "]
[]
["Nom & prénom (s) : ",null,null,null,{"$f":"DONNES!C4","v":"ABDO TEST"},null,null,null,null,null,null,null,null,null,null,null,null,"N° identification fiscale :",null,null,null,null,null,{"$f":"DONNES!C6","v":80422222}]
[null,null,null,"I - :Régime du bénéfice forfaitaire  (1)"]
["Activités exercées  (2)",null,null,null,null,null,null,null,null,null,null,"Montant  du chiffre d'affaires (C.A) en DH "]
[null,null,null,null,null,null,null,null,null,null,null,"C.A imposable ",null,null,null,"C.A des activités bénéficiant ",null,null,null,null,null,null,null,"Total C.A"]
[null,null,null,null,null,null,null,null,null,null,null,"totalité "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"du taux réduit  ",null,null,null,"de l'exonération "]
[null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,"de 20%",null,null,null,"de 100%"]
["A titre individuel"]
["Activité ",null,{"$f":"+DONNES!C9","v":"TRAVAUX COMPTABLES"},null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,{"$f":"L15","v":0}]
["Identifiant TP (3)",null,null,null,{"$f":"+DONNES!C7","v":50422222}]
["Activité ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,{"$f":"L17+P17+T17","v":0}]
["Identifiant TP (3)"]
["En qualité d'associé principal"]
["Identifiant TP (3)"]
["Dénomination:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L21+P21+T21","v":0}]
["Adresse:"]
["Ville :"]
["Identifiant TP (3)"]
["Dénomination:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L25+P25+T25","v":0}]
["Adresse:"]
["Ville :"]
["Quote-part dans l'indivision (4)"]
["Identifiant TP (3)"]
["Dénomination:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L30+P30+T30","v":0}]
["Adresse:"]
["Ville :"]
["Identifiant TP (3)"]
["Dénomination:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L34+P34+T34","v":0}]
["Adresse:"]
["Ville :"]
["TOTAUX ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L15:O36)","v":0},null,null,null,{"$f":"P15+P17+P21+P25+P30+P34","v":0},null,null,null,{"$f":"T15+T17+T21+T25+T30+T34","v":0},null,null,null,{"$f":"SUM(X15:AA36)","v":0}]
[]
["PLUS VALUES ET INDEMNITES"]
["Indemnité recues en contrpartie de  la cessation de l'exercice de la    profession ou du transfert de la clientèle (5)",null,null,null,null,null,null,null,"Montant des subventions et dons reçus de l'Etat, des ciollectivités locales ou des tiers.",null,null,null,null,null,null,null,"Montant global des plus-values nettes réalisés à l'occasion du retrait ou de la cession des biens corporels et incorporels affectés à l'exercice de la profession(5)                                                                          (Terrains et constructions exclus)"]
[]
[]
[]
[]
["Idenitifiant  ",null,null,"Nature",null,"Montant",null,null,"Idenitifiant  ",null,null,"Montant",null,null,null,null,"Idenitifiant  ",null,null,"Nature",null,null,null,"Montant"]
["TP (3)",null,null,"total","partie",null,null,null,"TP (3)",null,null,"Dons",null,null,"Subvention",null,"TP (3)",null,null,"Retrait",null,"Cession"]
[]
[]
[]
[]
["(1) - Sous réserve des dispositions de l'article 41 du CGI relatif aux conditions d'application du régime forfaitaire."]
["     - les contribuables imposés d'après le régime du forfait qui adhérent aux centres de gestion de comptabilité agrées, bénéficient d'un"]
["abattement de la base imposable de 15%. Joindre pièces justificatives d'adhésion,"]
["(2) -Joindre un état annexe si le nombre d'activité exercées à titre individuel, en qualité d'associé principal, ou dans l'indivision, dépasse"]
["deux."]
["(3) T.P : Taxe Professionnelle."]
["(4) Joindre un acte authentique faisant ressortir la part de chacun des co-indivisaires ou associés."]
["(5) Joindre les pièces justificatives d'acquisition, de cession ou de retrait."]
[]
["Etat n° ADP011F-14E"]
["Revenus professionnels"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Annexe n° : "]
[]
[]
["II - Résultat net professionnelle ( RNS ET RNR )"]
["Activités exercées (1)",null,null,null,null,null,null,null,null,null,null,"Régime du résultat net simplifié",null,null,null,null,null,null,null,"Régime du résultat net réel  "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"(RNS) (2)",null,null,null,null,null,null,null,"(RNR)"]
[null,null,null,null,null,null,null,null,null,null,null,"Bénéfice net fiscal",null,null,null,"Déficit fiscal",null,null,null,"Bénéfice net fiscal",null,null,null,"Déficit fiscal"]
[]
[]
[]
["A titre individuel"]
["Activité :    ",null,{"$f":"DONNES!C9","v":"TRAVAUX COMPTABLES"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,315140,null,null,null,0]
["Identifiant TP (3)",null,null,null,{"$f":"+DONNES!C7","v":50422222}]
["Activité :    "]
["Identifiant TP (3)"]
["Activité :    "]
["Identifiant TP (3)"]
["En qualité d'associé principal"]
["Identifiant TP (3)"]
["Dénomination:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L82+P82+T82","v":0}]
["Adresse:"]
["Ville :"]
["Identifiant TP (3)"]
["Dénomination:"]
["Adresse:"]
["Ville :"]
["Identifiant TP (3)"]
["Dénomination:"]
["Adresse:"]
["Ville :"]
["Quote-part dans l'indivision ou la société en  participation (4)"]
[]
["Identifiant TP (3)"]
["Dénomination:"]
["Adresse:"]
["Ville :"]
["Identifiant TP (3)"]
["Dénomination:"]
["Adresse:"]
["Ville :"]
["Identifiant TP (3)"]
["Dénomination:"]
["Adresse:"]
["Ville :"]
[null,null,null,null,null,"TOTAUX",null,null,null,null,null,{"$f":"SUM(L73:S106)","v":0},null,null,null,null,null,null,null,{"$f":"SUM(T73:AA106)","v":315140}]
["(1) Joindre un état annexe si le nombre d'activités exércées à titre individuel,en qaulité d'associé principal, ou dans "]
[" l'indivision ou dans la société en participation, dépassen trois,"]
["(2) -Sous réserve des dispositions de l'article 39 du CGI relatif aux conditions d'application du régime du résultat net"]
["simplifié,"]
["    - Les contribuables imposés d'après le régime du résultat net simplifié, qui adhérent aux centres de gestion de  "]
["comptabilité agrées, bénéficient d'un abattement de la base imposable de 15%. Joindre pièces justificatives d'adhésion,"]
["(3) T.P : Taxe Professionnelle."]
["(4) - Le bénéfice des sociétés en participationest détérminé obligatoirement selon le régime du résultat net réel,"]
["      - Joindre un acte authentique faisant ressortir la part de chacun des co-indivisaires ou associés."]

{"sheet":"REV-AGR","index":3,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[37,16,37,17],[38,16,38,17],[37,14,37,15],[38,14,38,15],[37,12,37,13],[38,12,38,13],[2,12,3,17],[4,15,5,17],[35,12,35,14],[6,0,6,7],[2,8,3,11],[15,12,15,14],[24,12,24,14],[31,12,31,14],[4,12,5,14],[9,15,9,17],[15,15,15,17],[9,12,9,14],[24,15,24,17],[31,15,31,17],[35,15,35,17],[1,7,1,10],[2,0,5,7],[20,0,21,7],[38,7,38,8],[9,8,9,11],[15,8,15,11],[37,0,38,2],[37,3,37,6],[38,3,38,4],[38,5,38,6],[37,7,37,8],[24,8,24,11],[31,8,31,11],[35,8,35,11],[4,8,5,11],[37,9,38,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP012F-14E"]
[null,null,null,null,null,null,null,"Revenus agricoles"]
["Liste des exploitations (2)",null,null,null,null,null,null,null,"Régime du bénefice frfaitaire(3)",null,null,null,"Régime du résultat                       net réel (RNR)"]
[]
[null,null,null,null,null,null,null,null,"Chiffre d'affaires ",null,null,null,"Bénéfice net fiscale",null,null,"Déficit fiscal"]
[]
["A titre individuel (4)"]
["Désignation de l'exploitation"]
["Qualité de l'exploitant P.L.U (5)"]
["superficie ",null,null,null,null,null,null,null,null,null,null,null,0,null,null,-125000]
["Lieu de situation"]
["TF ou régime foncier"]
["Plantation ou culture (6)"]
["Désignation de l'exploitation",null,null,null,null,null,null,null,null,null," "," "]
["Qualité de l'exploitant P.L.U (5)"]
["superficie "]
["Lieu de situation"]
["TF ou régime foncier"]
["Plantation ou culture (6)"]
[]
["Quate-part dans l'indivision (4) ou la société en participation "]
[]
["Désignation de l'exploitation"]
["Qualité de l'exploitant P.L.U (5)"]
["superficie "]
["Lieu de situation"]
["TF ou régime foncier"]
["Plantation ou culture (6)"]
[]
["Désignation de l'exploitation"]
["Qualité de l'exploitant P.L.U (5)"]
["superficie "]
["Lieu de situation"]
["TF ou régime foncier"]
["Plantation ou culture (6)"]
[null,null,"TOTAUX",null,null,null,null,null,{"$f":"SUM(I10:L35)","v":0},null,null,null,{"$f":"SUM(M10:O35)","v":0},null,null,{"$f":"SUM(P10:R35)","v":-125000}]
[null,"Plus values de cessions (terres, plantations et autres éléments de l'actif) (7)"]
["Nature du bien   cédé",null,null,"Cession",null,null,null,"Date ",null,"coût de revient",null,null,"date de",null,"Prix de",null,"Montant de la "]
[null,null,null,"totale",null,"partielle ",null,"d'acquisition",null,null,null,null,"cession",null,"cession",null,"plus value"]
[]
[]
[]
[]
[]
[]
[]
["(1) Revenus exonérés jusqu'au 31 décembre 2013,"]
["(2) joindre un état annexe si le nombre des exploitations dépasse deux,"]
["(3) Le revenu imposable provenant des exploitations agricoles est détérminé d'après un bébéfice forfaitaire tel que défini à l'article 49 en tenant"]
["compte  des dispositions de l'article 51. (Dispositions de l'artice 48 du C.G.I)"]
["(4) Dispense de déclaration  pour les contribuables disposant uniquement de revenus agricoles provenant d'une seule exploitation losqu'ils relèvent "]
["du régime forfaitaire.( Dispositions de l'article 86 du C.G.I)"]
["(5)   - P= propriétaire                       L= location                            U= usifruitier "]
["       - En cas de location, joindre copie du contrat de location ou indiquer le nom et l'identité du propriétaire."]
["(6) joindre un état annexe donnant le détail des :"]
["   -Terres de culture irriguées ou non irriguées "]
["   -Plantation régulières et irrigulières (nature des plantations, année de plantation et le revenu correspondant);"]
["   -Animaux (nombre de têtes par espéce ),"]
["(7) Tableau réservé aux contribuables imposés d'après le régime du forfait,"]

{"sheet":"REV-SAL","index":4,"n_rows":135,"n_cols":59,"rows_kept":135,"cut":false,"hidden":false,"merged":[[125,19,125,44],[125,46,125,53],[115,46,115,53],[117,46,117,53],[118,46,118,53],[120,46,120,53],[123,1,123,41],[123,43,123,44],[123,46,123,53],[112,21,112,34],[112,41,112,43],[112,46,112,53],[113,46,113,53],[114,46,114,53],[107,46,107,53],[108,21,108,34],[108,41,108,43],[108,46,108,53],[110,1,110,44],[110,46,110,53],[104,32,104,44],[104,46,104,53],[105,1,105,44],[106,21,106,34],[106,41,106,43],[106,46,106,53],[96,46,96,53],[98,46,98,53],[100,43,100,44],[100,46,100,53],[102,46,102,53],[89,1,89,30],[89,31,89,54],[90,1,90,30],[90,31,90,54],[94,43,94,44],[94,46,94,53],[85,14,85,24],[87,1,87,30],[87,31,87,54],[88,1,88,30],[88,31,88,54],[76,46,76,54],[78,0,78,53],[80,0,80,53],[83,12,83,31],[83,44,83,51],[0,45,0,55],[1,0,1,55],[2,0,2,55],[4,10,4,31],[4,32,4,46],[4,47,4,55],[6,1,6,11],[6,12,6,20],[6,32,6,46],[6,47,6,55],[8,1,8,30],[8,31,8,55],[9,1,9,30],[9,31,9,55],[10,1,10,30],[10,31,10,55],[11,1,11,30],[11,31,11,55],[31,2,31,41],[13,41,13,44],[14,41,14,44],[15,40,15,41],[15,46,15,54],[18,46,18,54],[20,46,20,54],[22,46,22,54],[24,40,24,41],[24,46,24,54],[26,37,26,41],[26,46,26,54],[32,22,32,32],[32,38,32,40],[32,46,32,54],[34,21,34,32],[34,40,34,43],[34,46,34,54],[32,12,32,21],[48,46,48,54],[36,21,36,32],[36,40,36,43],[36,46,36,54],[38,46,38,54],[40,46,40,54],[42,21,42,32],[42,40,42,43],[42,46,42,54],[44,21,44,32],[44,40,44,43],[44,46,44,54],[46,1,46,41],[46,46,46,54],[62,46,62,54],[50,46,50,54],[53,46,53,54],[57,18,57,28],[57,33,57,35],[57,46,57,54],[58,46,58,54],[59,1,59,38],[59,40,59,41],[59,46,59,54],[61,21,61,41],[61,46,61,54]]}
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP013F-16E"]
["REVENUS SALARIAUX ET ASSIMILES (1)"]
["(SALAIRES)"]
[]
[null,"Nom et Prénom (s) :",null,null,null,null,null,null,null,null,{"$f":"+DONNES!C4","v":"ABDO TEST"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  N° d'immatriculation à la PPR"]
[]
[null,"N° d'Identifiant fiscale   :",null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C6","v":80422222},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N° d'immatriculation à la CNSS"]
[]
[null,"Nom et prénom (s) ou raison sociale de l'employeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adresse de l'employeur"]
[" "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"A - ELEMENTS DES REVENUS SALARIAUX ET ASSIMILES :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," Traitements, salaires, indemnités et émoluments y compris les avantages en argent ou en nature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,178500]
[null,"B - ELEMENTS EXONERES :"]
[]
[null,"1. Indemnités destinées à couvrir les frais inhérents à la fonction ou à l'emploi, exonérées conformement"]
[null,null,"à l'article 57-1° du CGI."]
[null,"2. Allocations familiales ou d'assistance à la famille.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[null,"3.- Autres exonérations (2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,null,null,null,null,{"$f":"SUM(AU19:BD23)","v":0}]
[]
[null,"C - REVENU BRUT IMPOSABLE : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C = A-B",null,null,null,null,null,null,null,null,{"$f":"+AU16-AU25","v":178500}]
[]
[null,"D - ",null,"DEDUCTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"D1 Déductions sur salaires"]
[null,"1 - Déductions pour frais inhérents à la fonction ou à l'emploi dans la limite de 30.000 dh (3)"]
[null,null,"(les avantages en argents ou en nature ne doivent pas être compris dans la base de calcul des frais professionnels) :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"a) - CAS GENERAL          : ",null,null,null,null,null,null,null,null,null,null,"  - Revenu Brut imposable :",null,null,null,null,null,null,null,null,null,{"$f":"AU27","v":178500},null,null,null,null,null,null,null,null,null,null,null,"DH",null,"x",null,0.2,null,null,null,null,null,null,null,{"$f":"IF((W33*AM33)>30000,30000,W33*AM33)","v":30000},null,null,null,null,null,null,null,null,null,null,{"$f":"W33*AM33","v":35700}]
[null,"b) - CAS PARTICULIER  :  - Les professions pour lesquelles le taux de déduction est supérieur 20%"]
[null,null,null,null,null,"- Montant global de rémunérations : (4)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU27","v":178500},null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux",null,null,null,null,null,null,null,null,{"$f":"V35*AO35","v":0}]
[null,"2-a) - Retenue effectuée par l'employeur pour la constitution de pension de retraite :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,"- Base de calcul de la Retenue :",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"AU27","v":178500},null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux",null,null,null,null,null,null,null,null,{"$f":"V37*AO37","v":0}]
[]
[null,null,"b) - Primes ou cotisations d'assurance retraite (5)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[null,null,"c) - Montant du rachat précompté par l'employeur",null,null,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":"V43*AO43","v":3225.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"3 - Cotisation aux organisme de prévoyance et de sécurité sociale : "]
[null,null,null,null,null,null,null,null,null," Montant Brut Imposable :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(AU27,6000*12)","v":72000},null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux",null,null,4.48E-2,null,null,null,null,null,{"$f":"V43*AO43","v":3225.6},null,null,null,null,null,null,null,null,null,null,4.48E-2,4.48E-2]
[]
[null,"4 - AMO : ",null,null,null,null,null,null,null," Montant Brut Imposable :",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU27","v":178500},null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux",null,null,0.02,null,null,null,null,null,{"$f":"V45*AO45","v":3570},null,null,null,null,null,null,null,null,null,null,2.2599999999999999E-2,0.02]
[]
[null,"5 - Part salariale des primes d'assurance-groupe maladie, maternité, invalidité et décè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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"6 - Remboursement en principal et intérêts des prêts contractés ou du coût d'acquisition et de la rémunération",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"convenue d'avance dans le cadre d'un contrat \"Mourabaha\", pour l'acquisition d'un logement social :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[null,"- Revenu Net Imposable avant déduction des intérêts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null," - Montant des intérêts des prêts, ou montant de la rémunération convenue d'avance dans le cadre",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"d'un contrat \"Mourabaha\", obtenus pour l'acquisition ou la construction de logement à usage "]
[null,"d'habitation principale dans la limite de 10% du Revenu Net Imposable (6)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,null,"D2 Abattement forfaitaire"]
[null,"Abattement forfaitaire de 40% applicable au montant brut imposable des salaires perçus par les sportifs "]
[null,"professionnels (cet abattement n'est cumulable avec aucune autre déduction) :"]
[null,null,null,null,null,"- Montant Brut Imposable :",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x",0.4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S58*AH58","v":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," ","D",null,null,null,null,null,{"$f":"SUM(AU33:BD58)","v":36795.599999999999}]
[]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SALAIRE NET IMPOSABLE (C-D)",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":"AU27-AU60","v":141704.4}]
[]
["(1)","Joindre attestation annuelle détaillée de salaire délivrée par l'employeur."]
["(2)","Cf. article 57 du Code Général des Impôts (CGI)."]
["(3)","- Pour les revenus salariaux acquis à compter de 1er janvier 2010."]
[" ","- Le plafond de 30.000 ne s'applique par pour le personnel navigant de la marine marchande et de la pêche maritime."]
["(4)","Ycompris les indemnités versées à titre de frais d'emploi, de service, de route, et autre allocations similaires (exclusion faite des avantages en argent ou en nature)"]
["(5)","Cette déduction n'est pas cumulables avec celle prévu pour les autres régimes de retraite en vigueur."]
[null,"a - joindre à la présente déclaration une copie certifiée conforme du contrat d'assurance ainsi que l'attestation de paiement des primes ou des cotisations délivrée par"]
[null,"la société d'assurances."]
[null,"b - En cas de revenus multiples (salariaux et autres), le contribuable a la possibilité de déduire la prime d'assurance retraite en totalité soit au niveau de son salaire net "]
[null,"soit au niveau de son revenu net, soit dans la limite de 6% de son revenu global imposable."]
["(6)","Cette ligne n'est à servir que si l'employeur a déjà déduit ces intérêts lors du calcul du prélèvement de l'IR à la source, les intérêts y afférents ne sont pas cumulatifs "]
[null,"avec la déduction prévue au 6 du D1."]
[]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP013F-16E"]
[]
["REVENUS SALARIAUX ET ASSIMILES (1)"]
[]
["(PENSIONS OU RENTES VIAGERES)"]
[]
[]
[null,"Nom et Prénom (s) :",null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C81","v":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,"  N° de la pension :"]
[]
[null,"N° d’identification fiscale :",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C83","v":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,"N° d'immatriculation à la CNSS :"]
[]
[null,"Nom et prénom (s) ou raison sociale du débirentier",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"adresse du débirentier"]
[" "]
[]
[]
[]
[null,"A - ELEMENTS DE LA PENSION OU RENTE VIAGERE :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"- Pensions ou rentes viagères.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,75860]
[null,"B - ELEMENTS EXONERES :"]
[null,"1. Allocations familiales ou d'assistance à la famille."]
[]
[null,"2.- Autres exonérations (2)"]
[]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",null,null,{"$f":"SUM(AU97:BB99)","v":0}]
[]
[null,"C - REVENU BRUT IMPOSABLE : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C = A-B",null,{"$f":"+AU95-AU101","v":75860}]
[]
[null,"D - ",null,"DEDUCTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Abattement de 55% ou de 40% applicable au montant brut imposable des pensions et rentes viagères (3) :"]
[null,null,null,null,null,"- Montant Brut Imposable :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU103","v":75860},null,null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux",null,null,{"$f":"IF(V107<168000,55%,40%)","v":0.55000000000000004},null,null,null,null,{"$f":"V107*AP107","v":41723}]
[null,"1 - Cotisation aux organisme de prévoyance et de sécurité sociale : "]
[null,null,null,null,null,"- Montant Brut Imposable :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AU103","v":75860},null,null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux"]
[]
[null,"2 - Part salariale des Primes d'assurances-groupe maladie, maternité, invalidité et décè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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"3 - AMO :  Montant Brut Imposable :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"+AU103","v":75860},null,null,null,null,null,null,null,null,null,null,null,null,null,"DH ",null,"x","Taux"]
[]
[null,"4- Remboursement en principal et intérêts des prêts contractés ou du coût d’acquisition et de la"]
[null,"rémunération convenue d’avance dans le cadre d’un contrat \"Mourabaha\", pour l’acquisition",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,"d’un logement social."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"- Revenu Net Imposable avant déduction des intérêts.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"5- Montant des intérêts des prêts, ou montant de la rémunération convenue d’avance dans le",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"cadre d’un contrat\"Mourabaha\", obtenus pour l’acquisition ou la construction de logement à",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,"usage d’habitation principale dans la limite de 10% du Revenu Net Imposable (4)"]
[]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ","D",null,null,{"$f":"SUM(AU106:BB123)","v":41723}]
[]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PENSION NETTE IMPOSABLE (C-D)",null,null,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":"AU103-AU124","v":34137}]
[]
[]
[null,"(1) Joindre attestation annuelle détaillée de pension, délivrée par le débirentier."]
[null,"(2) Cf. article 57 du Code Général des Impôts (CGI)."]
[null,"(3) L’abattement de 55% s’applique sur le montant brut annuel inférieur ou égal à 168 000 dirhams ;"]
[null,null,"L’abattement de 40 % s’applique pour le surplus."]
[null,null,"Ces abattements sont appliqués aux pensions de retraite et rentes viagères acquises à compter du 1er janvier 2015."]
[null,"(4) Cette ligne n’est à servir que si l’employeur a déjà déduit ces intérêts lors du calcul du prélèvement de l’IR à la source, les intérêts y"]
[null,null,"afférents ne sont pas cumulatifs avec la déduction prévue au 4 du D."]

{"sheet":"REV-FONC","index":5,"n_rows":105,"n_cols":78,"rows_kept":105,"cut":false,"hidden":false,"merged":[[2,0,2,78],[4,42,4,44],[5,10,5,31],[5,32,5,44],[7,1,7,11],[7,12,7,20],[7,32,7,44],[52,6,52,14],[52,19,52,26],[9,0,11,46],[13,19,13,45],[15,13,15,45],[24,6,24,14],[24,19,24,26],[34,19,34,45],[36,13,36,45],[9,47,9,61],[9,62,9,78],[10,47,11,49],[10,50,11,52],[10,53,11,55],[10,56,10,61],[10,62,11,70],[10,71,11,78],[11,56,11,58],[11,59,11,61],[24,39,24,45],[27,19,27,45],[29,13,29,45],[29,63,29,69],[31,6,31,14],[31,19,31,26],[31,39,31,45],[15,63,15,69],[17,6,17,14],[17,19,17,26],[17,39,17,45],[20,19,20,45],[22,13,22,45],[22,63,22,69],[45,6,45,14],[45,19,45,26],[45,39,45,45],[48,19,48,45],[50,13,50,45],[50,63,50,69],[36,63,36,69],[38,6,38,14],[38,19,38,26],[38,39,38,45],[41,19,41,45],[43,13,43,45],[43,63,43,69],[57,62,59,70],[57,71,59,78],[58,56,59,58],[58,59,59,61],[61,19,61,45],[63,13,63,45],[63,63,63,69],[52,39,52,45],[53,62,53,70],[53,71,53,78],[56,0,59,46],[56,47,56,61],[56,62,56,78],[57,47,59,49],[57,50,59,52],[57,53,59,55],[57,56,57,61],[72,6,72,14],[72,19,72,26],[72,39,72,45],[75,19,75,45],[77,13,77,45],[77,63,77,69],[65,6,65,14],[65,19,65,26],[65,39,65,45],[66,62,66,70],[68,19,68,45],[70,13,70,45],[70,63,70,69],[81,71,81,78],[82,0,84,61],[83,63,83,72],[85,0,87,61],[86,63,86,72],[88,0,90,61],[89,63,89,72],[79,6,79,14],[79,19,79,26],[79,39,79,45],[81,0,81,46],[81,47,81,61],[81,62,81,70],[96,36,96,45],[96,58,96,62],[96,65,96,70],[96,73,96,77],[91,0,92,78],[93,0,94,22],[93,23,93,46],[93,47,94,56],[93,57,94,63],[93,64,94,71],[93,72,94,78],[94,23,94,34],[94,35,94,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP014F-16E"]
[]
["REVENUS FONCIERS DES PROPRIETES NON AGRICOLES (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,null,null,null,null,null,null,null,null,"Annexe n°"]
[null,"Nom et Prénom (s) :",null,null,null,null,null,null,null,null,{"$f":"+DONNES!C4","v":"ABDO TEST"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"N° d'Identifiant fiscale   :",null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C6","v":80422222},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Désignation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affectation (2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant des loyers (4) des immeubles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,"V",null,null,"OP",null,null,"OTG (3)",null,null,null,null,null,"possédé à titre individuel",null,null,null,null,null,null,null,null,"Part dans l'indivision ou la société en participation (5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAD",null,null,"OT"]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,156200]
[]
[" Consistance :",null,null,null,null,null,"Garage",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null,null,null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,75670]
[]
[" Consistance :",null,null,null,null,null,"Maison",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null,null,null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :"]
[]
[" Consistance :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null,null,null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" (1) Joindre un état annexe selon ce modèle si le nombre des propriétés dépasse neuf."]
[]
["Désignation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affectation (2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant des loyers (4) des immeubles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L",null,null,"V",null,null,"OP",null,null,"OTG (3)",null,null,null,null,null,"possédé à titre individuel",null,null,null,null,null,null,null,null,"Part dans l'indivision ou la société en participation (5)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OAD",null,null,"OT"]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[" Nom - Prénoms ou raison sociale de l'occupant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :",null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL78+BL71+BL64+BL51+BL44+BL37+BL30+BL23+BL16","v":231870},null,null,null,null,null,null,null,null,{"$f":"SUM(BT14:CA54)+SUM(BT62:CA80)","v":0}]
[" Montant brut imposable total (6)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BK82+BT82","v":231870}]
[]
[" Abattement de 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL84*40/100","v":92748}]
[]
[" Total net imposable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BL84-BL87","v":139122}]
[]
["INDEMNITE D'EVICTION (7)"]
[]
["Lieu de situation de l'immeuble",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identification de la partie versante",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date de perception de l'indemnité",null,null,null,null,null,null,null,null,null,"Montant de l'indemnité",null,null,null,null,null,null,"Abattement de 40%",null,null,null,null,null,null,null,"Montant net"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom-prénom ou raison sociale",null,null,null,null,null,null,null,null,null,null,null,"CNI ou n° d'identification fiscale"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,{"$f":"BG97*40/100","v":0},null,null,null,null,null,null,null,{"$f":"BG97-BN97","v":0}]
[]
[]
[" (2) Mettre une croix (x) dans la case appropriée L : Loué ; V : Vacant ; OP : Occupé par le Propriétaire ; OTG : Occupé à Titre Gratuit ; OAD : Occupé par les Ascendant et les Descendant ; OT : Occupé par des Tiers."]
[" (3) Joindre les justifications motivant l'occupation a titre gratuit."]
[" (4) Des loyers bruts imposables sont déduites, le cas échéant, les charges supportées par le propriétaire pour le compte des locataires. Parmis ces charges figure notament la TSC lorsque son montant est distingué dans le contrat de location."]
[" (5) Joindre un acte authentique faisant ressortir la part de chacun des co-indivisaires ou société et/ou un contrat de bail en cas de l'affectation de l'immeuble."]
[" (6) Montant brut imposable total de la page (ou de l'endsemble des pages annexes si le nombre de propriétés dépasse neuf)."]
[" (7) Joindre les pièces justificatives."]

{"sheet":"REV-FONC-AGR","index":6,"n_rows":107,"n_cols":85,"rows_kept":107,"cut":false,"hidden":false,"merged":[[98,0,100,50],[98,73,100,82],[99,52,99,61],[99,64,99,71],[92,19,92,49],[94,13,94,49],[94,52,94,61],[94,64,94,71],[94,74,94,81],[96,6,96,15],[96,20,96,27],[96,40,96,49],[85,19,85,49],[87,13,87,49],[87,52,87,61],[87,64,87,71],[87,74,87,81],[89,6,89,15],[89,20,89,27],[89,40,89,49],[78,19,78,49],[80,13,80,49],[80,52,80,61],[80,64,80,71],[80,74,80,81],[82,6,82,15],[82,20,82,27],[82,40,82,49],[71,19,71,49],[73,13,73,49],[73,52,73,61],[73,64,73,71],[73,74,73,81],[75,6,75,15],[75,20,75,27],[75,40,75,49],[64,19,64,49],[66,13,66,49],[66,52,66,61],[66,64,66,71],[66,74,66,81],[68,6,68,15],[68,20,68,27],[68,40,68,49],[57,0,62,50],[57,51,58,82],[59,51,62,62],[59,63,60,82],[61,63,62,72],[61,73,62,82],[46,19,46,49],[48,13,48,49],[48,52,48,61],[48,64,48,71],[48,74,48,81],[50,6,50,15],[50,20,50,27],[50,40,50,49],[39,19,39,49],[41,13,41,49],[41,52,41,61],[41,64,41,71],[41,74,41,81],[43,6,43,15],[43,20,43,27],[43,40,43,49],[32,19,32,49],[34,13,34,49],[34,52,34,61],[34,64,34,71],[34,74,34,81],[36,6,36,15],[36,20,36,27],[36,40,36,49],[25,19,25,49],[27,13,27,49],[27,52,27,61],[27,64,27,71],[27,74,27,81],[29,6,29,15],[29,20,29,27],[29,40,29,49],[18,19,18,49],[20,13,20,49],[20,52,20,61],[20,64,20,71],[20,74,20,81],[22,6,22,15],[22,20,22,27],[22,40,22,49],[11,0,16,50],[11,51,12,82],[13,51,16,62],[13,63,14,82],[15,63,16,72],[15,73,16,82],[0,73,0,82],[3,0,3,82],[5,42,5,44],[7,10,7,31],[7,32,7,44],[9,1,9,11],[9,12,9,20],[9,32,9,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP015F-16E"]
[]
[]
["REVENUS FONCIERS DES PROPRIETES AGRICOLES (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,null,null,null,null,null,null,null,null,"Annexe n°"]
[]
[null,"Nom et Prénom (s) :",null,null,null,null,null,null,null,null,{"$f":"+DONNES!$C$4","v":"ABDO TEST"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"N° d’identification fiscale   :",null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!$C$6","v":80422222},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["Désignation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 annuel du loyer du fermage ou son équivalent en DH. (2)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"à titre induviduel",null,null,null,null,null,null,null,null,null,null,null,"possédé dans l'indivision ou la société en participation (3)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 brut",null,null,null,null,null,null,null,null,null,"Quote part en %"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,274500,null,null,null,null,null,null,null,null,null,null,null,15200,null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" (1) Joindre un état annexe selon ce modèle si le nombre des propriétés dépasse dix."]
[]
[]
[]
["Désignation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 annuel du loyer du fermage ou son équivalent en DH. (2)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"à titre induviduel",null,null,null,null,null,null,null,null,null,null,null,"possédé dans l'indivision ou la société en participation (3)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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 brut",null,null,null,null,null,null,null,null,null,"Quote part en %"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
[]
[" Nom - Prénoms ou raison sociale de l’exploitant :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,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]
[]
[" Lieu de situation de l'immeuble :",null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[]
[" Consistance :",null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,"Art. TSC :",null,null,null," ",null,null,null,null,null,null,null,"Titre foncier ou régime foncier :"]
[]
["Revenu net imposable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"BA95+BA88+BA81+BA74+BA67+BA49+BA42+BA35+BA28+BA21","v":274500},null,null,null,null,null,null,null,null,null,null,null,{"$f":"BM95+BM88+BM81+BM74+BM67+BM49+BM42+BM35+BM28+BM21","v":15200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+BM100+BA100","v":289700},{"$f":"+CF100+SUM('REV-FONC'!BL90:BU90)","v":428822}]
[]
[]
[" (2) Le revenu net imposable des proprétés agricoles données en location, construction et matériel y attachés, est déterminé coome suit :"]
[null,"a) 1er cas : Rémunération en argent (revenu net imposable = montant du loyer stipulé dans le contrat) ;"]
[null,"b) 2ème cas : Rémunération en nature (revenu net imposable = prix moyen de la culture pratiquée x la quantité) ;"]
[null,"c) 3ème cas : Location à par de fruit (revenu net imposable = fraction du revenu agricole forfaitaire)."]
[" (3) Joindre un acte authentique faisant ressortir la part de chacun des co-indivisaires ou associés."]

{"sheet":"REV-CAPMOB","index":7,"n_rows":66,"n_cols":49,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,38,0,46],[3,0,3,46],[5,10,5,31],[5,32,5,44],[7,1,7,11],[7,12,7,20],[7,32,7,44],[10,0,11,16],[10,17,10,34],[10,35,10,46],[11,17,11,22],[11,23,11,28],[11,29,11,34],[11,35,11,40],[11,41,11,46],[16,18,16,21],[16,24,16,27],[16,30,16,33],[16,36,16,39],[16,42,16,45],[13,18,13,21],[13,24,13,27],[13,30,13,33],[13,36,13,39],[13,42,13,45],[22,18,22,21],[22,24,22,27],[22,30,22,33],[22,36,22,39],[22,42,22,45],[19,18,19,21],[19,24,19,27],[19,30,19,33],[19,36,19,39],[19,42,19,45],[28,18,28,21],[28,24,28,27],[28,30,28,33],[28,36,28,39],[28,42,28,45],[25,18,25,21],[25,24,25,27],[25,30,25,33],[25,36,25,39],[25,42,25,45],[34,18,34,21],[34,24,34,27],[34,30,34,33],[34,36,34,39],[34,42,34,45],[31,18,31,21],[31,24,31,27],[31,30,31,33],[31,36,31,39],[31,42,31,45],[40,18,40,21],[40,24,40,27],[40,30,40,33],[40,36,40,39],[40,42,40,45],[37,18,37,21],[37,24,37,27],[37,30,37,33],[37,36,37,39],[37,42,37,45],[46,18,46,21],[46,24,46,27],[46,30,46,33],[46,36,46,39],[46,42,46,45],[43,18,43,21],[43,24,43,27],[43,30,43,33],[43,36,43,39],[43,42,43,45],[52,18,52,21],[52,24,52,27],[52,30,52,33],[52,36,52,39],[52,42,52,45],[49,18,49,21],[49,24,49,27],[49,30,49,33],[49,36,49,39],[49,42,49,45],[58,18,58,21],[58,24,58,27],[58,30,58,33],[58,36,58,39],[58,42,58,45],[55,18,55,21],[55,24,55,27],[55,30,55,33],[55,36,55,39],[55,42,55,45],[61,0,63,16],[62,18,62,21],[62,24,62,27],[62,30,62,33],[62,42,62,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,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP016F-16E"]
[]
[]
["REVENUS DE CAPITAUX MOBILIERS"]
[]
[null,"Nom et Prénom (s) :",null,null,null,null,null,null,null,null,{"$f":"+DONNES!C4","v":"ABDO TEST"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"N° d'Identifiant fiscale   :",null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C6","v":80422222},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
["Désignation de la société ou de l'organisme bancaire distributeur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Produits de placement à revenu fixe en DH (1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retenue à la source en DH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Montant brut",null,null,null,null,null,"Frais",null,null,null,null,null,"Montant net",null,null,null,null,null,"Taux",null,null,null,null,null,"Montant"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52600,null,null,null,null,null,0,null,null,null,null,null,{"$f":"+S14-Y14","v":52600},null,null,null,null," ",0.2,null,null,null,null,null,{"$f":"+AK14*AE14","v":10520}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null," ",null,null,null,null,null,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,{"$f":"+S20-Y20","v":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,{"$f":"+S23-Y23","v":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,{"$f":"+S26-Y26","v":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,{"$f":"+S29-Y29","v":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,{"$f":"+S32-Y32","v":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,{"$f":"+S35-Y35","v":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,{"$f":"+S38-Y38","v":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,{"$f":"+S41-Y41","v":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,{"$f":"+S44-Y44","v":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,{"$f":"+S47-Y47","v":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,{"$f":"+S50-Y50","v":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,{"$f":"+S53-Y53","v":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,{"$f":"+S56-Y56","v":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,{"$f":"+S59-Y59","v":0},null,null,null,null," "]
[]
[]
["TOTAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R14:W59)","v":52600},null,null,null,null,null,{"$f":"SUM(X14:AC59)","v":0},null,null,null,null,null,{"$f":"SUM(AD14:AI59)","v":52600},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AP14:AU59)","v":10520},null,null,null,null,{"$f":"+DONNES!F11","v":10520},{"$f":"+AQ63-AV63","v":0}]
[]
[]
["(1) Joindre attestation de la société ou de l'organisme distributeur."]

{"sheet":"REV-ETRANGER","index":8,"n_rows":42,"n_cols":14,"rows_kept":42,"cut":false,"hidden":false,"merged":[[24,5,24,7],[25,11,25,12],[25,13,25,15],[24,8,24,10],[24,11,24,12],[24,13,24,15],[8,5,8,7],[9,5,9,7],[10,5,10,7],[11,5,11,7],[2,0,2,15],[3,0,3,15],[4,0,7,4],[4,5,7,7],[4,8,7,10],[4,11,5,15],[6,11,7,12],[6,13,7,15],[12,5,12,7],[20,5,20,7],[21,5,21,7],[22,5,22,7],[9,11,9,12],[12,11,12,12],[15,11,15,12],[18,11,18,12],[21,11,21,12],[14,5,14,7],[15,5,15,7],[16,5,16,7],[17,5,17,7],[18,5,18,7],[19,5,19,7],[13,5,13,7],[21,8,21,10],[9,13,9,15],[12,13,12,15],[15,13,15,15],[18,13,18,15],[21,13,21,15],[18,8,18,10],[15,8,15,10],[12,8,12,10],[9,8,9,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Etat n° ADP017F- 14E"]
[]
["REVENUS   ET PROFITS DE SOURCE ETRANGERE IMPOSABLES OU"]
["EXONERES DANS LE PAYS D'ORIGINE (2)"]
["Nature des revenus",null,null,null,null,"Paye d'origine",null,null,"Montant des revenus bruts imposés dans le pays d'origine convertis en DH",null,null,"Montant converi en DH"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"de l'impôt acquitté",null,"de l'impôt théorique (en cas d'exonération) (2)"]
[]
[]
[" Professionnels",null,null,null,null,null,null,null,65840,null,null,{"$f":"9876+5749","v":15625}]
[]
[]
["Agricoles",null,null,null,null,null,null,null,12500,null,null,null,null,{"$f":"3265+2985","v":6250}]
[]
[]
["Fonciers"]
[]
[]
["Salariaux et assimiliés (3)"]
[]
[]
["Capitaux mobiliers ",null,null,null,null,null,null,null,0,null,null,0,null,0]
[]
[]
[null,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(I9:K22)","v":78340},null,null,{"$f":"SUM(L9:M23)","v":15625},null,{"$f":"SUM(N9:P23)","v":6250}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!F12-L25","v":0},null,{"$f":"+DONNES!F13-N25","v":0}]
[]
[]
["(1) Joindre attestation de la société ou l'organisme distributeur."]
["(2) Joindre les pièces justificatives."]
["   Sous réserve des conventions fiscales, les revenus de source étrangère sont compris  dans le revenu global imposable  pour leur montant brut,à l'exclusion"]
["des revenus et profits de capitaux mobilièrs de source étrangère visés à l'article 25 du CGI."]
["Lorsque ces revenus sont soumis à un impôt sur le revenu dans le pays de la source avec lequel le Maroc a conclu une convention tendant à éviter la double"]
["imposition, l'impôt étrangèr est déductible de l'impôt sur le revenu dans la limite de la fraction de cet impôt correspondant aux revenus étrangèrs.Toutefois, lorsque"]
["ces revenus ont bénéficié d'une exonération dans le pays de la source, celle-ci vaut paiement. La déduction de cet impôt est subordonnée à la production"]
["d'attestation de l'administartion fiscale du pays d'origine."]
[]
["(3) - Les pensions de retraite de source étrangère bénéficient d'une réduction de 80% d'impôt dû au titre de leur pension et correspondant aux sommes transférées à titre"]
["définitif en dirhams non convertibles,"]
[" -  Joindre attestation de versement des pensions établie par le débirentier ou tout AUTRE document en tenant lieu"]
[" -  Joindre attestation de l'établissement de crédit ou tout autre  organisme intervenant dans le paiement des pensions, justifiant le transfert en dirhams non"]
["convertible "]

{"sheet":"REV-TAXABLE","index":9,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[23,3,23,6],[42,3,42,4],[44,4,44,5],[46,8,46,9],[29,3,29,4],[37,7,37,9],[43,7,43,9],[38,7,38,9],[36,7,36,9],[29,6,29,7],[31,6,31,7],[33,6,33,7],[28,6,28,7],[10,7,10,9],[31,3,31,4],[33,3,33,4],[0,0,0,9],[5,7,5,9],[6,7,6,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[12,7,13,9],[23,7,23,9],[15,7,15,9],[17,7,17,9],[19,7,19,9],[21,4,22,6],[28,3,28,4]]}
["        A- DETERMINATION DU REVENU NET TAXABLE"]
[]
["   A-CALCUL DU REVENU NET IMPOSABLE"]
[" ",null,"NATURE DES REVENUS",null,null,null,null,null,"MONTANTS en DH"]
["I- REVENU GLOBAL IMPOSABLE"]
["Revenus professionnels (1)",null,null,null,null,null,null,{"$f":"MAX(+'REV-PROF'!L107+'REV-PROF'!T107,0)","v":315140}]
["Revenus agricoles  ",null,null,null,null,null,null,{"$f":"MAX(+'REV-AGR'!I36+'REV-AGR'!M36+'REV-AGR'!P36,0)","v":0}]
["Revenus fonciers",null,null,null,null,null,null,{"$f":"+'REV-FONC'!BL90+SUM('REV-FONC-AGR'!BA100:BM100)","v":428822}]
["Revenus salariaux et assimilés (2)",null,null,null,null,null,null,{"$f":"+'REV-SAL'!AU62+SUM('REV-SAL'!AU126:BB126)","v":175841.4}]
["Revenus de capitaux mobiliers (revenus de placement à revenu fixe)",null,null,null,null,null,null,{"$f":"SUM('REV-CAPMOB'!AE63:AH63)","v":52600}]
["Revenus de source étrangère",null,null,null,null,null,null,{"$f":"+SUM('REV-ETRANGER'!I25:K25)","v":78340}]
[]
[null,null,null," I - Revenu global imposable (I)",null,null,null,{"$f":"SUM(H6:J12)","v":1050743.3999999999}]
[null,null,null,null,"(R.G.I)"]
["II - DEDUCTION SUR REVENU GLOBAL IMPOSABLE :"]
["♦Montant des Dons en argent ou en nature prévus à l'article 28-I et octroyés aux",null,null,null,null,null,null," "]
["  organismes visés à l'article 10-I-B-2° du CGI",null,null,null,null,null,null," "]
["♦Montant des Intérêt des prêts, ou montant de la rémunération convenue dans le cadre"]
["     d'un contrat \"Mourabaha\", pour l'acquisition ou la construction de logement à usage  "]
["     d'habitation principale. (Dans la limite de 10%  du R.G.I) (4)",null,null,null,null,null,null,0]
["♦Montant des Primes ou cotisation d'assurance retraite dans la limite de 6% du R.G.I (5)"]
[null,null,null,null," II - Total des déductions  (II)"]
[]
[null,null,null,"Revenu net global taxable (I-II)",null,null,null,{"$f":"+H13","v":1050743.3999999999}]
[null,null,null,null,"(R.N.I)"]
[]
["B - IMPUTATIONS SUR IMPOT"]
[" I- COTISATION MINIMAL AQUITTEE (5)"]
[null,null,null,"PROFESSIONNEL",null,null,"AGRICOLE"]
[null,"♦ Montant ",null,{"$f":"+DONNES!F5","v":214145},null,null,{"$f":"+DONNES!G5","v":2745}]
[]
[null,"♦Date de versement ",null,{"$f":"+DONNES!F6","v":"2016-01-31"},null,null,{"$f":"+DONNES!G6","v":"2016-01-31"}]
[]
[null,"♦Quittance n°",null,{"$f":"+DONNES!F7","v":12121212},null,null,{"$f":"+DONNES!G7","v":21212121}]
[]
["II - IMPOT RETENU A LA SOURCE (6)"]
["       a - Au titre de revenus salariaux et assimilés  :",null,null,null,null,null,null,{"$f":"+DONNES!F10","v":65464}]
["       b- Au titre des produits de placement à revenu fixe soumis au taux de 20%",null,null,null,null,null,null,{"$f":"+DONNES!F11","v":10520}]
["     c- Montant de l'impôt étranger acquitté (ou théoriique en cas d'exonération) : ",null,null,null,null,null,null,{"$f":"+DONNES!F12+DONNES!F13","v":21875}]
[]
["C - REDUCTIONS D'IMPÖT"]
[]
["      a - Pour charge de famille :",null,null,{"$f":"+DONNES!F17","v":1440}]
[]
["     b - Au titre des retraites de source étrangère :",null,null,null,{"$f":"+DONNES!F18","v":5752}]
[null,null,null," "]
[null,null,null,null,null,"A","Tanger","Le:",{"$f":"TODAY()","v":"2016-04-29"}]
[null,null,null,null,null,null,null,null,"Cachet et Signature"]
["(1) A servir uniquement par les contribuables dont le revenu professionnel est"]
[" détérminé d'après les régimes du résultat net simplifié ou du résultat net réel en cas de"]
["     réalisation d'un bénéfice,"]
["(2) Il s'agit du total du montant net imposable du salaire et/ou de la pension, le cas"]
["échéant,"]
["(3)  Cette déduction n'est pas cumulable avec celle prévue au titre des revenus"]
["salariaux et assimiliés visée à l'article 59-V du CGI "]
["(4) Cf. renvoi 5 de l'annexe ADP013F relative aux revenus salariaux."]
["(6) Joindre a titre de pièce justificatife le volet du bordereau, Avis de versement  "]
["  dûment servi par la perception ou la recette   concernée."]
["(6) Pour justifier les retenus à la source, Joindre les pièces justificatives suivantes : "]
["             ♦Attestation de salaire et/ou attestation de versement des pensions établie "]
["               par l'employeur et/ou le débirentier;"]
["             ♦Attestation de la société ou de l'organisme bancaire distributeur;"]
["             ♦Attestation de l'administration fiscale étrangére ,"]

{"sheet":"CALCUL IR","index":10,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[33,3,33,5],[34,3,34,5],[35,3,35,5],[31,3,31,6],[0,0,0,1],[0,4,0,6],[9,4,9,6]]}
["Calcul de l'IR",null,null,null,"BAREME IR"]
["REVENUS PROFESSIONNELS",{"$f":"IF('REV-PROF'!L107+'REV-PROF'!T107<0,0,'REV-PROF'!T74)","v":315140},null,null,"Revenu annuel","Taux","Somme\nà déduire",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B2:B8)","v":1050743.3999999999}]
["REVENUS AGRICOLES",{"$f":"IF('REV-TAXABLE'!H7<0,0,'REV-AGR'!M10)","v":0},null,null,0,0,0]
["REVENUS FONCIERS",{"$f":"'REV-TAXABLE'!H8","v":428822},null,null,30001,0.1,3000]
["REVENUS SALARIAUX",{"$f":"'REV-TAXABLE'!H9","v":175841.4},null,null,50001,0.2,8000]
["REVENUS CAPITAUX MOBILIERS",{"$f":"+'REV-TAXABLE'!H10","v":52600},null,null,60001,0.3,14000]
["REVENUS DE SOURCE ETRANGERE",{"$f":"+'REV-TAXABLE'!H11","v":78340},null,null,80001,0.34,17200]
[null,null,null,null,180001,0.38,24400]
["Revenue Net Global Imposable",{"$f":"ROUNDUP(SUM(B2:B7),-1)","v":1050750},null,null,999999999]
["Taux selon barème",{"$f":"+VLOOKUP(B9,$E$3:$G$9,2)","v":0.38},null,null,"TAUX SPECIFIQUE DE TANGER"]
["Abattement",{"$f":"+VLOOKUP(B9,$E$3:$G$9,3)","v":24400},null,null,"ANNEE","TAUX EN %","PLAFOND"]
[null,null,null,null,"EX 2010",0.2,122857]
["IR THEORIQUE SELON BAREME",{"$f":"ROUNDUP((B9*B10-B11-B12),0)","v":374885},null,null,"EX 2011",{"$f":"+F12+2%","v":0.22},143334]
["PRORATA IR / REVENUS PROFESSIONNELS",{"$f":"IF(DONNES!C11=\"TANGER\",IF(B2<G17,B2*B13/TOTR,B2*F17),B2/TOTR*B13)","v":112435.88006358167},null,null,"EX 2012",{"$f":"+F13+2%","v":0.24},172000]
["PRORATA IR /  REVENUS AGRICOLES (taux réduit 20%)",{"$f":"B3*0.2","v":0},null,null,"EX 2013",{"$f":"+F14+2%","v":0.26},203333]
["PRORATA IR / REVENUS FONCIERS",{"$f":"+B13*B4/TOTR","v":152995.42730413534},null,null,"EX 2014",{"$f":"+F15+2%","v":0.28000000000000003},244000]
["PRORATA IR / REVENUS SALARIAUX",{"$f":"+B13*B5/TOTR","v":62736.823508955662},null,null,"EX 2015",0.3,305000]
["PRORATA IR / REVENUS CAPITAUX MOBILIERS",{"$f":"+B6*B13/TOTR","v":18766.666533427669}]
["PRORATA IR / REVENUS DE SOURCE ETRANGERE",{"$f":"+B13*B7/TOTR","v":27950.202589899687}]
["TOTAL IR",{"$f":"ROUNDUP(SUM(B14:B19),0)","v":374885}]
[]
["I - COTISATION MINIMALE ACQUITTEE"]
["Cotisation Minimale versée / REV PROF",{"$f":"+DONNES!F5","v":214145}]
["Cotisation Minimale versée / REV AGRICOLE",{"$f":"+DONNES!G5","v":2745}]
[null,{"$f":"+B23+B24","v":216890}]
["II - IMPOT RETENU A LA SOURCE"]
["IR retenu sur salaire",{"$f":"DONNES!F10","v":65464}]
["Au titre des produits de placement à revenu fixe soumis au taux de 20% :",{"$f":"SUM('REV-CAPMOB'!AQ63:AT63)","v":10520}]
["Montant de l'impôt étranger acquitté (ou théorique en cas d'exonération) :",{"$f":"SUM('REV-ETRANGER'!L22:P22)","v":0}]
[null,{"$f":"SUM(B27:B29)","v":75984}]
["C - REDUCTION D'IMPOT"]
["a - Pour charge de famille :",{"$f":"DONNES!F17","v":1440},null,"Remarques sur la différence entre l'IR barème et l'IR définitif"]
["b - Au titre des retraites de source étrangère :",{"$f":"DONNES!F18","v":5752}]
[null,{"$f":"SUM(B32:B33)","v":7192},null,"Total IR dû / Exercice 2015 ===>",null,null,{"$f":"+B36+B34+B30+B25","v":479340},"détails :"]
[null,null,null,{"$f":"IF(G34>B20,\" Cet écart provient de la Cotisation minimale payée sur le BNR ou BNS=>\",\"Aucun écart sur la CM \")","v":" Cet écart provient de la Cotisation minimale payée sur le BNR ou BNS=>"},null,null,{"$f":"+G34-B20","v":104455},{"$f":"ROUNDUP(IF(B23>B14,B23-B14,0)+IF(B24>B15,B24-B15,0),0)","v":104455}]
["Montant restant à verser ",{"$f":"ROUNDUP(SUM(B16:B19)+MAX(B14,B23)+MAX(B15,B24)-B25-B30-B34,0)","v":179274},null,{"$f":"IF(B13>B20,\" Cet écart provient de la différence de taux prévu pour le BNR ou BNS=>\",\"Aucun écart sur L'IR \")","v":"Aucun écart sur L'IR "},null,null,{"$f":"+B13-B20","v":0},{"$f":"+ROUNDUP((B13/Q2*B3)-B15+(B13/Q2*B2)-B14,0)","v":0}]

{"sheet":"VERSEMENT IR","index":11,"n_rows":36,"n_cols":57,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,4,6,17],[0,43,1,55],[1,2,1,16],[3,44,3,55],[4,1,4,55],[5,1,5,55],[27,17,28,30],[27,31,28,43],[27,44,28,55],[7,4,7,17],[8,4,8,17],[10,1,10,55],[11,30,11,35],[15,2,15,55],[17,17,17,27],[17,42,17,52],[13,23,13,29],[13,32,13,38],[32,4,32,53],[34,47,34,54],[35,40,35,50],[19,13,19,54],[23,42,23,54],[29,1,30,16],[29,17,30,30],[29,31,30,43],[29,44,30,55],[31,2,31,10],[31,11,31,54],[22,4,22,54],[24,4,24,40],[24,45,24,54],[26,1,26,55],[27,1,28,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNEE :",null,null,null,null,null,null,null,2015]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Du ",null,"2015-01-01",null,null,null,null,null,null,"Au",null,"2015-12-31"]
[]
[null,null,"IDENTITE DE LA PARTIE VERSANTE"]
[]
[null,null,null,null,"N° C.I.N ou carte de séjour : ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DONNES!C8","v":"K6333333"},null,null,null,null,null,null,null,null,null,null,null,"N° d'identification fiscale : ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C6","v":80422222}]
[]
[null,null,null,null,"Nom, prénom :",null,null,null,null,null,null,null,null,{"$f":"+DONNES!C4","v":"ABDO TEST"}]
[]
[null,null,null,null,"Adresse du domicile fiscal ou du principal établissement :"]
[null,null,null,null,{"$f":"+DONNES!C10","v":"AVE MOHAMED V N° 05"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VILLE :",null,null,null,{"$f":"+DONNES!C11","v":"CASABLANCA"}]
[]
[]
[null,"CADRE A SERVIR PAR LA PARTIE VERSANTE"]
[null,"Montant des droits\nen principal (2)\nA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pénalité de \n5% ou 10% (3)\nB",null,null,null,null,null,null,null,null,null,null,null,null,null,"Majoration de retard de  \n 5% et 0,5% (3)\nC",null,null,null,null,null,null,null,null,null,null,null,null,"Total \n(arrondi au dirham supérieur)\nA+B+C"]
[]
[null,{"$f":"+'CALCUL IR'!B36","v":179274},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUNDUP(B30+R30+AF30,0)","v":179274},null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS30","v":179274}]
[]
[null,null,"Total en lettres :",null,null,null,null,null,null,null,null,{"$f":"'CHIFFRE EN LETTERE'!B2","v":"cent soixante-dix-neuf mille deux cent soixante-quatorze DH"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,{"$f":"+DONNES!C11","v":"CASABLANCA"},null,null,null,null,null,null,null,"le",{"$f":"TODAY()","v":"2016-04-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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cachet et signature"]

{"sheet":"CHIFFRE EN LETTERE","index":12,"n_rows":101,"n_cols":97,"rows_kept":101,"cut":false,"hidden":true,"merged":[[0,1,0,99]]}
["MONTANT","EN LETTRE"]
[{"$f":"+'VERSEMENT IR'!AS30","v":179274},{"$f":"(X2&Y2&Z2&AA2&AB2&AC2&AD2&AE2&AF2&AG2&AH2&AI2&AJ2&AK2&AL2&AM2&AN2&AO2&AP2)","v":"cent soixante-dix-neuf mille deux cent soixante-quatorze DH"},{"$f":"UPPER(MID(B2,1,1))&MID(B2,2,168)","v":"Cent soixante-dix-neuf mille deux cent soixante-quatorze DH"},{"$f":"INT(A2/1000000)","v":0},{"$f":"INT((A2-D2*1000000)/1000)","v":179},{"$f":"INT(A2-D2*1000000-E2*1000)","v":274},{"$f":"ROUND(A2-D2*1000000-E2*1000-F2,2)*100","v":0},{"$f":"D2-M2*100","v":0},null,{"$f":"E2-P2*100","v":79},{"$f":"ROUND(F2-S2*100,0)","v":74},{"$f":"G2","v":0},{"$f":"INT(D2/100)","v":0},{"$f":"INT((D2-M2*100)/10)","v":0},{"$f":"D2-M2*100-N2*10","v":0},{"$f":"INT(E2/100)","v":1},{"$f":"INT((E2-P2*100)/10)","v":7},{"$f":"E2-P2*100-Q2*10","v":9},{"$f":"INT(F2/100)","v":2},{"$f":"INT((F2-S2*100)/10)","v":7},{"$f":"F2-S2*100-T2*10","v":4},{"$f":"INT(G2/10)","v":0},{"$f":"ROUND(G2-V2*10,0)","v":0},{"$f":"IF(M2=0,\"\",IF(M2=1,\"\",IF(M2=2,\"deux \",IF(M2=3,\"trois \",IF(M2=4,\"quatre \",IF(M2=5,\"cinq \",AQ2))))))","v":""},{"$f":"IF(M2=0,\"\",IF(M2<2,\"cent \",AR2))","v":""},{"$f":"IF(N2=1,AS2,IF(N2=7,BM2,IF(N2=9,CC2,CL2)))","v":""},{"$f":"IF(H2=11,\"\",IF(H2=12,\"\",IF(H2=13,\"\",IF(H2=14,\"\",IF(H2=15,\"\",IF(H2=16,\"\",AT2))))))","v":""},{"$f":"IF(D2=0,\"\",IF(D2<2,\"million \",\"millions \"))","v":""},{"$f":"IF(I2=1,\"\",IF(P2=0,\"\",IF(P2=1,\"\",IF(P2=2,\"deux \",IF(P2=3,\"trois \",IF(P2=4,\"quatre \",IF(P2=5,\"cinq \",AU2)))))))","v":""},{"$f":"IF(P2=0,\"\",IF(P2<2,\"cent \",AV2))","v":"cent "},{"$f":"IF(Q2=1,AW2,IF(Q2=7,BO2,IF(Q2=9,CD2,CM2)))","v":"soixante-dix-neuf "},{"$f":"IF(E2=1,\"\",AX2)","v":""},{"$f":"IF(E2>0,\"mille \",\"\")","v":"mille "},{"$f":"IF(INT(A2)=0,\"zéro \",IF(S2=0,\"\",IF(S2=1,\"\",IF(S2=2,\"deux \",IF(S2=3,\"trois \",IF(S2=4,\"quatre \",IF(S2=5,\"cinq \",AY2)))))))","v":"deux "},{"$f":"IF(S2=0,\"\",IF(S2<2,\"cent \",AZ2))","v":"cent "},{"$f":"IF(T2=1,BA2,IF(T2=7,BQ2,IF(T2=9,CF2,CN2)))","v":"soixante-quatorze "},{"$f":"IF(K2=11,\"\",IF(K2=12,\"\",IF(K2=13,\"\",IF(K2=14,\"\",IF(K2=15,\"\",IF(K2=16,\"\",BB2))))))","v":""},{"$f":"IF(INT(A2<2),\"DH \",\"DH\")","v":"DH"},{"$f":"IF(G2>0,\" et \",\"\")","v":""},{"$f":"IF(V2=1,BC2,IF(V2=7,BS2,IF(V2=9,CG2,CO2)))","v":""},{"$f":"IF(L2=11,\"\",IF(L2=12,\"\",IF(L2=13,\"\",IF(L2=14,\"\",IF(L2=15,\"\",IF(L2=16,\"\",BD2))))))","v":""},{"$f":"IF(G2=0,\"\",IF(G2<2,\"centime\",\"centimes\"))","v":""},{"$f":"IF(D2=0,\" \",IF(M2=6,\"six \",IF(M2=7,\"sept \",IF(M2=8,\"huit \",IF(M2=9,\"neuf \",)))))","v":" "},{"$f":"IF(H2>0,\"cent \", \"cents \")","v":"cents "},{"$f":"IF(H2=10,\"dix \",IF(H2=11,\"onze \",IF(H2=12,\"douze \",IF(H2=13,\"treize \",IF(H2=14,\"quatorze \",IF(H2=15,\"quinze \",BE2))))))","v":""},{"$f":"IF(H2=17,\"\",IF(H2=18,\"\",IF(H2=19,\"\",BF2)))","v":""},{"$f":"IF(P2=6,\"six \",IF(P2=7,\"sept \",IF(P2=8,\"huit \",IF(P2=9,\"neuf \",))))","v":0},{"$f":"IF(J2>0,\"cent \", \"cents \")","v":"cent "},{"$f":"IF(J2=10,\"dix \",IF(J2=11,\"onze \",IF(J2=12,\"douze \",IF(J2=13,\"treize \",IF(J2=14,\"quatorze \",IF(J2=15,\"quinze \",BG2))))))","v":"soixante-dix-neuf "},{"$f":"IF(J2=11,\"\",IF(J2=12,\"\",IF(J2=13,\"\",IF(J2=14,\"\",IF(J2=15,\"\",IF(J2=16,\"\",BH2))))))","v":""},{"$f":"IF(S2=6,\"six \",IF(S2=7,\"sept \",IF(S2=8,\"huit \",IF(S2=9,\"neuf \",))))","v":0},{"$f":"IF(K2>0,\"cent \", \"cents \")","v":"cent "},{"$f":"IF(K2=10,\"dix \",IF(K2=11,\"onze \",IF(K2=12,\"douze \",IF(K2=13,\"treize \",IF(K2=14,\"quatorze \",IF(K2=15,\"quinze \",BI2))))))","v":"soixante-quatorze "},{"$f":"IF(K2=17,\"\",IF(K2=18,\"\",IF(K2=19,\"\",BJ2)))","v":""},{"$f":"IF(L2=10,\"dix \",IF(L2=11,\"onze \",IF(L2=12,\"douze \",IF(L2=13,\"treize \",IF(L2=14,\"quatorze \",IF(L2=15,\"quinze \",BK2))))))","v":""},{"$f":"IF(L2=17,\"\",IF(L2=18,\"\",IF(L2=19,\"\",BL2)))","v":""},{"$f":"IF(H2=16,\"seize \",IF(H2=17,\"dix-sept \",IF(H2=18,\"dix-huit \",IF(H2=19,\"dix-neuf \",BM2))))","v":""},{"$f":"IF(H2=21,\"et un \",IF(H2=31,\"et un \",IF(H2=41,\"et un \",IF(H2=51,\"et un \",IF(H2=61,\"et un \",BN2)))))","v":""},{"$f":"IF(J2=16,\"seize \",IF(J2=17,\"dix-sept \",IF(J2=18,\"dix-huit \",IF(J2=19,\"dix-neuf \",BO2))))","v":"soixante-dix-neuf "},{"$f":"IF(J2=17,\"\",IF(J2=18,\"\",IF(J2=19,\"\",BP2)))","v":""},{"$f":"IF(K2=16,\"seize \",IF(K2=17,\"dix-sept \",IF(K2=18,\"dix-huit \",IF(K2=19,\"dix-neuf \",BQ2))))","v":"soixante-quatorze "},{"$f":"IF(K2=21,\"et un \",IF(K2=31,\"et un \",IF(K2=41,\"et un \",IF(K2=51,\"et un \",IF(K2=61,\"et un \",BR2)))))","v":""},{"$f":"IF(L2=16,\"seize \",IF(L2=17,\"dix-sept \",IF(L2=18,\"dix-huit \",IF(L2=19,\"dix-neuf \",BS2))))","v":""},{"$f":"IF(L2=21,\"et un \",IF(L2=31,\"et un \",IF(L2=41,\"et un \",IF(L2=51,\"et un \",IF(L2=61,\"et un \",BT2)))))","v":""},{"$f":"IF(H2=70,\"soixante-dix \",IF(H2=71,\"soixante et onze \",IF(H2=72,\"soixante-douze \",IF(H2=73,\"soixante-treize \",IF(H2=74,\"soixante-quatorze \",IF(H2=75,\"soixante-quinze \",BU2))))))","v":""},{"$f":"IF(N2=9,\"\",IF(N2=7,\"\",IF(O2=0,\"\",IF(O2=1,\"un \",IF(O2=2,\"deux \",IF(O2=3,\"trois \",IF(O2=4,\"quatre \",IF(O2=5,\"cinq \",BV2))))))))","v":""},{"$f":"IF(J2=70,\"soixante-dix \",IF(J2=71,\"soixante et onze \",IF(J2=72,\"soixante-douze \",IF(J2=73,\"soixante-treize \",IF(J2=74,\"soixante-quatorze \",IF(J2=75,\"soixante-quinze \",BW2))))))","v":"soixante-dix-neuf "},{"$f":"IF(J2=21,\"et un \",IF(J2=31,\"et un \",IF(J2=41,\"et un \",IF(J2=51,\"et un \",IF(J2=61,\"et un \",BX2)))))","v":""},{"$f":"IF(K2=70,\"soixante-dix \",IF(K2=71,\"soixante et onze \",IF(K2=72,\"soixante-douze \",IF(K2=73,\"soixante-treize \",IF(K2=74,\"soixante-quatorze \",IF(K2=75,\"soixante-quinze \",BY2))))))","v":"soixante-quatorze "},{"$f":"IF(T2=9,\"\",IF(T2=7,\"\",IF(U2=0,\"\",IF(U2=1,\"un \",IF(U2=2,\"deux \",IF(U2=3,\"trois \",IF(U2=4,\"quatre \",IF(U2=5,\"cinq \",BZ2))))))))","v":""},{"$f":"IF(L2=70,\"soixante-dix \",IF(L2=71,\"soixante et onze \",IF(L2=72,\"soixante-douze \",IF(L2=73,\"soixante-treize \",IF(L2=74,\"soixante-quatorze \",IF(L2=75,\"soixante-quinze \",CA2))))))","v":""},{"$f":"IF(V2=9,\"\",IF(V2=7,\"\",IF(W2=0,\"\",IF(W2=1,\"un \",IF(W2=2,\"deux \",IF(W2=3,\"trois \",IF(W2=4,\"quatre \",IF(W2=5,\"cinq \",CB2))))))))","v":""},{"$f":"IF(H2=76,\"soixante-seize \",IF(H2=77,\"soixante-dix-sept \",IF(H2=78,\"soixante-dix-huit \",IF(H2=79,\"soixante-dix-neuf \",CC2))))","v":""},{"$f":"IF(N2=9,\"\",IF(O2=6,\"six \",IF(O2=7,\"sept \",IF(O2=8,\"huit \",IF(O2=9,\"neuf \",)))))","v":0},{"$f":"IF(J2=76,\"soixante-seize \",IF(J2=77,\"soixante-dix-sept \",IF(J2=78,\"soixante-dix-huit \",IF(J2=79,\"soixante-dix-neuf \",CD2))))","v":"soixante-dix-neuf "},{"$f":"IF(Q2=9,\"\",IF(Q2=7,\"\",IF(R2=0,\"\",IF(R2=1,\"un \",IF(R2=2,\"deux \",IF(R2=3,\"trois \",IF(R2=4,\"quatre \",IF(R2=5,\"cinq \",CE2))))))))","v":""},{"$f":"IF(K2=76,\"soixante-seize \",IF(K2=77,\"soixante-dix-sept \",IF(K2=78,\"soixante-dix-huit \",IF(K2=79,\"soixante-dix-neuf \",CF2))))","v":""},{"$f":"IF(T2=9,\"\",IF(U2=6,\"six \",IF(U2=7,\"sept \",IF(U2=8,\"huit \",IF(U2=9,\"neuf \",)))))","v":0},{"$f":"IF(L2=76,\"soixante-seize \",IF(L2=77,\"soixante-dix-sept \",IF(L2=78,\"soixante-dix-huit \",IF(L2=79,\"soixante-dix-neuf \",CG2))))","v":""},{"$f":"IF(V2=9,\"\",IF(W2=6,\"six \",IF(W2=7,\"sept \",IF(W2=8,\"huit \",IF(W2=9,\"neuf \",)))))","v":0},{"$f":"IF(H2=90,\"quatre-vingt-dix \",IF(H2=91,\"quatre-vingt-onze \",IF(H2=92,\"quatre-vingt-douze \",IF(H2=93,\"quatre-vingt-treize \",IF(H2=94,\"quatre-vingt-quatorze \",IF(H2=95,\"quatre-vingt-quinze \",CH2))))))","v":""},{"$f":"IF(J2=90,\"quatre-vingt-dix \",IF(J2=91,\"quatre-vingt-onze \",IF(J2=92,\"quatre-vingt-douze \",IF(J2=93,\"quatre-vingt-treize \",IF(J2=94,\"quatre-vingt-quatorze \",IF(J2=95,\"quatre-vingt-quinze \",CI2))))))","v":""},{"$f":"IF(Q2=9,\"\",IF(R2=6,\"six \",IF(R2=7,\"sept \",IF(R2=8,\"huit \",IF(R2=9,\"neuf \",)))))","v":"neuf "},{"$f":"IF(K2=90,\"quatre-vingt-dix \",IF(K2=91,\"quatre-vingt-onze \",IF(K2=92,\"quatre-vingt-douze \",IF(K2=93,\"quatre-vingt-treize \",IF(K2=94,\"quatre-vingt-quatorze \",IF(K2=95,\"quatre-vingt-quinze \",CJ2))))))","v":""},"",{"$f":"IF(H2=96,\"quatre-vingt-seize \",IF(H2=97,\"quatre-vingt-dix-sept \",IF(H2=98,\"quatre-vingt-dix-huit \",IF(H2=99,\"quatre-vingt-dix-neuf \",CL2))))","v":""},{"$f":"IF(J2=96,\"quatre-vingt-seize \",IF(J2=97,\"quatre-vingt-dix-sept \",IF(J2=98,\"quatre-vingt-dix-huit \",IF(J2=99,\"quatre-vingt-dix-neuf \",CM2))))","v":""},"","",{"$f":"IF(N2=2,\"vingt \",IF(N2=3,\"trente \",IF(N2=4,\"quarante \",IF(N2=5,\"cinquante \",CP2))))","v":""},{"$f":"IF(Q2=2,\"vingt \",IF(Q2=3,\"trente \",IF(Q2=4,\"quarante \",IF(Q2=5,\"cinquante \",CQ2))))","v":""},{"$f":"IF(T2=2,\"vingt \",IF(T2=3,\"trente \",IF(T2=4,\"quarante \",IF(T2=5,\"cinquante \",CR2))))","v":""},{"$f":"IF(V2=2,\"vingt \",IF(V2=3,\"trente \",IF(V2=4,\"quarante \",IF(V2=5,\"cinquante \",CS2))))","v":""},{"$f":"IF(N2=6,\"soixante \",IF(H2=80,\"quatre-vingts \",IF(N2=8,\"quatre-vingt-\",\"\")))","v":""},{"$f":"IF(Q2=6,\"soixante \",IF(J2=80,\"quatre-vingts \",IF(Q2=8,\"quatre-vingt-\",\"\")))","v":""},{"$f":"IF(T2=6,\"soixante \",IF(K2=80,\"quatre-vingts \",IF(T2=8,\"quatre-vingt-\",\"\")))","v":""},{"$f":"IF(V2=6,\"soixante \",IF(L2=80,\"quatre-vingts \",IF(V2=8,\"quatre-vingt-\",\"\")))","v":""}]
[null,{"$f":"(X3&Y3&Z3&AA3&AB3&AC3&AD3&AE3&AF3&AG3&AH3&AI3&AJ3&AK3&AL3&AM3&AN3&AO3&AP3)","v":"zéro DH "},"Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,{"$f":"(X8&Y8&Z8&AA8&AB8&AC8&AD8&AE8&AF8&AG8&AH8&AI8&AJ8&AK8&AL8&AM8&AN8&AO8&AP8)","v":"zéro DH "},"Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,{"$f":"IF(K34=90,\"quatre-vingt-dix \",IF(K34=91,\"quatre-vingt-onze \",IF(K34=92,\"quatre-vingt-douze \",IF(K34=93,\"quatre-vingt-treize \",IF(K34=94,\"quatre-vingt-quatorze \",IF(K34=95,\"quatre-vingt-quinze \",CJ34))))))","v":""},"","",{"$f":"IF(J34=96,\"quatre-vingt-seize \",IF(J34=97,\"quatre-vingt-dix-sept \",IF(J34=98,\"quatre-vingt-dix-huit \",IF(J34=99,\"quatre-vingt-dix-neuf \",CM34))))","v":""},"","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ",{"$f":"UPPER(MID(B66,1,1))&MID(B66,2,168)","v":"Zéro DH "},{"$f":"INT(A66/1000000)","v":0},{"$f":"INT((A66-D66*1000000)/1000)","v":0},{"$f":"INT(A66-D66*1000000-E66*1000)","v":0},{"$f":"ROUND(A66-D66*1000000-E66*1000-F66,2)*100","v":0},{"$f":"D66-M66*100","v":0},null,{"$f":"E66-P66*100","v":0},{"$f":"ROUND(F66-S66*100,0)","v":0},{"$f":"G66","v":0},{"$f":"INT(D66/100)","v":0},{"$f":"INT((D66-M66*100)/10)","v":0},{"$f":"D66-M66*100-N66*10","v":0},{"$f":"INT(E66/100)","v":0},{"$f":"INT((E66-P66*100)/10)","v":0},{"$f":"E66-P66*100-Q66*10","v":0},{"$f":"INT(F66/100)","v":0},{"$f":"INT((F66-S66*100)/10)","v":0},{"$f":"F66-S66*100-T66*10","v":0},{"$f":"INT(G66/10)","v":0},{"$f":"ROUND(G66-V66*10,0)","v":0},{"$f":"IF(M66=0,\"\",IF(M66=1,\"\",IF(M66=2,\"deux \",IF(M66=3,\"trois \",IF(M66=4,\"quatre \",IF(M66=5,\"cinq \",AQ66))))))","v":""},{"$f":"IF(M66=0,\"\",IF(M66<2,\"cent \",AR66))","v":""},{"$f":"IF(N66=1,AS66,IF(N66=7,BM66,IF(N66=9,CC66,CL66)))","v":""},{"$f":"IF(H66=11,\"\",IF(H66=12,\"\",IF(H66=13,\"\",IF(H66=14,\"\",IF(H66=15,\"\",IF(H66=16,\"\",AT66))))))","v":""},{"$f":"IF(D66=0,\"\",IF(D66<2,\"million \",\"millions \"))","v":""},{"$f":"IF(I66=1,\"\",IF(P66=0,\"\",IF(P66=1,\"\",IF(P66=2,\"deux \",IF(P66=3,\"trois \",IF(P66=4,\"quatre \",IF(P66=5,\"cinq \",AU66)))))))","v":""},{"$f":"IF(P66=0,\"\",IF(P66<2,\"cent \",AV66))","v":""},{"$f":"IF(Q66=1,AW66,IF(Q66=7,BO66,IF(Q66=9,CD66,CM66)))","v":""},{"$f":"IF(E66=1,\"\",AX66)","v":""},{"$f":"IF(E66>0,\"mille \",\"\")","v":""},{"$f":"IF(INT(A66)=0,\"zéro \",IF(S66=0,\"\",IF(S66=1,\"\",IF(S66=2,\"deux \",IF(S66=3,\"trois \",IF(S66=4,\"quatre \",IF(S66=5,\"cinq \",AY66)))))))","v":"zéro "},{"$f":"IF(S66=0,\"\",IF(S66<2,\"cent \",AZ66))","v":""},{"$f":"IF(T66=1,BA66,IF(T66=7,BQ66,IF(T66=9,CF66,CN66)))","v":""},{"$f":"IF(K66=11,\"\",IF(K66=12,\"\",IF(K66=13,\"\",IF(K66=14,\"\",IF(K66=15,\"\",IF(K66=16,\"\",BB66))))))","v":""},{"$f":"IF(INT(A66<2),\"DH \",\"DH\")","v":"DH "},{"$f":"IF(G66>0,\" et \",\"\")","v":""},{"$f":"IF(V66=1,BC66,IF(V66=7,BS66,IF(V66=9,CG66,CO66)))","v":""},{"$f":"IF(L66=11,\"\",IF(L66=12,\"\",IF(L66=13,\"\",IF(L66=14,\"\",IF(L66=15,\"\",IF(L66=16,\"\",BD66))))))","v":""},{"$f":"IF(G66=0,\"\",IF(G66<2,\"centime\",\"centimes\"))","v":""},{"$f":"IF(D66=0,\" \",IF(M66=6,\"six \",IF(M66=7,\"sept \",IF(M66=8,\"huit \",IF(M66=9,\"neuf \",)))))","v":" "},{"$f":"IF(H66>0,\"cent \", \"cents \")","v":"cents "},{"$f":"IF(H66=10,\"dix \",IF(H66=11,\"onze \",IF(H66=12,\"douze \",IF(H66=13,\"treize \",IF(H66=14,\"quatorze \",IF(H66=15,\"quinze \",BE66))))))","v":""},{"$f":"IF(H66=17,\"\",IF(H66=18,\"\",IF(H66=19,\"\",BF66)))","v":""},{"$f":"IF(P66=6,\"six \",IF(P66=7,\"sept \",IF(P66=8,\"huit \",IF(P66=9,\"neuf \",))))","v":0},{"$f":"IF(J66>0,\"cent \", \"cents \")","v":"cents "},{"$f":"IF(J66=10,\"dix \",IF(J66=11,\"onze \",IF(J66=12,\"douze \",IF(J66=13,\"treize \",IF(J66=14,\"quatorze \",IF(J66=15,\"quinze \",BG66))))))","v":""},{"$f":"IF(J66=11,\"\",IF(J66=12,\"\",IF(J66=13,\"\",IF(J66=14,\"\",IF(J66=15,\"\",IF(J66=16,\"\",BH66))))))","v":""},{"$f":"IF(S66=6,\"six \",IF(S66=7,\"sept \",IF(S66=8,\"huit \",IF(S66=9,\"neuf \",))))","v":0},{"$f":"IF(K66>0,\"cent \", \"cents \")","v":"cents "},{"$f":"IF(K66=10,\"dix \",IF(K66=11,\"onze \",IF(K66=12,\"douze \",IF(K66=13,\"treize \",IF(K66=14,\"quatorze \",IF(K66=15,\"quinze \",BI66))))))","v":""},{"$f":"IF(K66=17,\"\",IF(K66=18,\"\",IF(K66=19,\"\",BJ66)))","v":""},{"$f":"IF(L66=10,\"dix \",IF(L66=11,\"onze \",IF(L66=12,\"douze \",IF(L66=13,\"treize \",IF(L66=14,\"quatorze \",IF(L66=15,\"quinze \",BK66))))))","v":""},{"$f":"IF(L66=17,\"\",IF(L66=18,\"\",IF(L66=19,\"\",BL66)))","v":""},{"$f":"IF(H66=16,\"seize \",IF(H66=17,\"dix-sept \",IF(H66=18,\"dix-huit \",IF(H66=19,\"dix-neuf \",BM66))))","v":""},{"$f":"IF(H66=21,\"et un \",IF(H66=31,\"et un \",IF(H66=41,\"et un \",IF(H66=51,\"et un \",IF(H66=61,\"et un \",BN66)))))","v":""},{"$f":"IF(J66=16,\"seize \",IF(J66=17,\"dix-sept \",IF(J66=18,\"dix-huit \",IF(J66=19,\"dix-neuf \",BO66))))","v":""},{"$f":"IF(J66=17,\"\",IF(J66=18,\"\",IF(J66=19,\"\",BP66)))","v":""},{"$f":"IF(K66=16,\"seize \",IF(K66=17,\"dix-sept \",IF(K66=18,\"dix-huit \",IF(K66=19,\"dix-neuf \",BQ66))))","v":""},{"$f":"IF(K66=21,\"et un \",IF(K66=31,\"et un \",IF(K66=41,\"et un \",IF(K66=51,\"et un \",IF(K66=61,\"et un \",BR66)))))","v":""},{"$f":"IF(L66=16,\"seize \",IF(L66=17,\"dix-sept \",IF(L66=18,\"dix-huit \",IF(L66=19,\"dix-neuf \",BS66))))","v":""},{"$f":"IF(L66=21,\"et un \",IF(L66=31,\"et un \",IF(L66=41,\"et un \",IF(L66=51,\"et un \",IF(L66=61,\"et un \",BT66)))))","v":""},{"$f":"IF(H66=70,\"soixante-dix \",IF(H66=71,\"soixante et onze \",IF(H66=72,\"soixante-douze \",IF(H66=73,\"soixante-treize \",IF(H66=74,\"soixante-quatorze \",IF(H66=75,\"soixante-quinze \",BU66))))))","v":""},{"$f":"IF(N66=9,\"\",IF(N66=7,\"\",IF(O66=0,\"\",IF(O66=1,\"un \",IF(O66=2,\"deux \",IF(O66=3,\"trois \",IF(O66=4,\"quatre \",IF(O66=5,\"cinq \",BV66))))))))","v":""},{"$f":"IF(J66=70,\"soixante-dix \",IF(J66=71,\"soixante et onze \",IF(J66=72,\"soixante-douze \",IF(J66=73,\"soixante-treize \",IF(J66=74,\"soixante-quatorze \",IF(J66=75,\"soixante-quinze \",BW66))))))","v":""},{"$f":"IF(J66=21,\"et un \",IF(J66=31,\"et un \",IF(J66=41,\"et un \",IF(J66=51,\"et un \",IF(J66=61,\"et un \",BX66)))))","v":""},{"$f":"IF(K66=70,\"soixante-dix \",IF(K66=71,\"soixante et onze \",IF(K66=72,\"soixante-douze \",IF(K66=73,\"soixante-treize \",IF(K66=74,\"soixante-quatorze \",IF(K66=75,\"soixante-quinze \",BY66))))))","v":""},{"$f":"IF(T66=9,\"\",IF(T66=7,\"\",IF(U66=0,\"\",IF(U66=1,\"un \",IF(U66=2,\"deux \",IF(U66=3,\"trois \",IF(U66=4,\"quatre \",IF(U66=5,\"cinq \",BZ66))))))))","v":""},{"$f":"IF(L66=70,\"soixante-dix \",IF(L66=71,\"soixante et onze \",IF(L66=72,\"soixante-douze \",IF(L66=73,\"soixante-treize \",IF(L66=74,\"soixante-quatorze \",IF(L66=75,\"soixante-quinze \",CA66))))))","v":""},{"$f":"IF(V66=9,\"\",IF(V66=7,\"\",IF(W66=0,\"\",IF(W66=1,\"un \",IF(W66=2,\"deux \",IF(W66=3,\"trois \",IF(W66=4,\"quatre \",IF(W66=5,\"cinq \",CB66))))))))","v":""},{"$f":"IF(H66=76,\"soixante-seize \",IF(H66=77,\"soixante-dix-sept \",IF(H66=78,\"soixante-dix-huit \",IF(H66=79,\"soixante-dix-neuf \",CC66))))","v":""},{"$f":"IF(N66=9,\"\",IF(O66=6,\"six \",IF(O66=7,\"sept \",IF(O66=8,\"huit \",IF(O66=9,\"neuf \",)))))","v":0},{"$f":"IF(J66=76,\"soixante-seize \",IF(J66=77,\"soixante-dix-sept \",IF(J66=78,\"soixante-dix-huit \",IF(J66=79,\"soixante-dix-neuf \",CD66))))","v":""},{"$f":"IF(Q66=9,\"\",IF(Q66=7,\"\",IF(R66=0,\"\",IF(R66=1,\"un \",IF(R66=2,\"deux \",IF(R66=3,\"trois \",IF(R66=4,\"quatre \",IF(R66=5,\"cinq \",CE66))))))))","v":""},{"$f":"IF(K66=76,\"soixante-seize \",IF(K66=77,\"soixante-dix-sept \",IF(K66=78,\"soixante-dix-huit \",IF(K66=79,\"soixante-dix-neuf \",CF66))))","v":""},{"$f":"IF(T66=9,\"\",IF(U66=6,\"six \",IF(U66=7,\"sept \",IF(U66=8,\"huit \",IF(U66=9,\"neuf \",)))))","v":0},{"$f":"IF(L66=76,\"soixante-seize \",IF(L66=77,\"soixante-dix-sept \",IF(L66=78,\"soixante-dix-huit \",IF(L66=79,\"soixante-dix-neuf \",CG66))))","v":""},{"$f":"IF(V66=9,\"\",IF(W66=6,\"six \",IF(W66=7,\"sept \",IF(W66=8,\"huit \",IF(W66=9,\"neuf \",)))))","v":0},{"$f":"IF(H66=90,\"quatre-vingt-dix \",IF(H66=91,\"quatre-vingt-onze \",IF(H66=92,\"quatre-vingt-douze \",IF(H66=93,\"quatre-vingt-treize \",IF(H66=94,\"quatre-vingt-quatorze \",IF(H66=95,\"quatre-vingt-quinze \",CH66))))))","v":""},{"$f":"IF(J66=90,\"quatre-vingt-dix \",IF(J66=91,\"quatre-vingt-onze \",IF(J66=92,\"quatre-vingt-douze \",IF(J66=93,\"quatre-vingt-treize \",IF(J66=94,\"quatre-vingt-quatorze \",IF(J66=95,\"quatre-vingt-quinze \",CI66))))))","v":""},{"$f":"IF(Q66=9,\"\",IF(R66=6,\"six \",IF(R66=7,\"sept \",IF(R66=8,\"huit \",IF(R66=9,\"neuf \",)))))","v":0},{"$f":"IF(K66=90,\"quatre-vingt-dix \",IF(K66=91,\"quatre-vingt-onze \",IF(K66=92,\"quatre-vingt-douze \",IF(K66=93,\"quatre-vingt-treize \",IF(K66=94,\"quatre-vingt-quatorze \",IF(K66=95,\"quatre-vingt-quinze \",CJ66))))))","v":""},"",{"$f":"IF(H66=96,\"quatre-vingt-seize \",IF(H66=97,\"quatre-vingt-dix-sept \",IF(H66=98,\"quatre-vingt-dix-huit \",IF(H66=99,\"quatre-vingt-dix-neuf \",CL66))))","v":""},{"$f":"IF(J66=96,\"quatre-vingt-seize \",IF(J66=97,\"quatre-vingt-dix-sept \",IF(J66=98,\"quatre-vingt-dix-huit \",IF(J66=99,\"quatre-vingt-dix-neuf \",CM66))))","v":""},"","",{"$f":"IF(N66=2,\"vingt \",IF(N66=3,\"trente \",IF(N66=4,\"quarante \",IF(N66=5,\"cinquante \",CP66))))","v":""},{"$f":"IF(Q66=2,\"vingt \",IF(Q66=3,\"trente \",IF(Q66=4,\"quarante \",IF(Q66=5,\"cinquante \",CQ66))))","v":""},{"$f":"IF(T66=2,\"vingt \",IF(T66=3,\"trente \",IF(T66=4,\"quarante \",IF(T66=5,\"cinquante \",CR66))))","v":""},{"$f":"IF(V66=2,\"vingt \",IF(V66=3,\"trente \",IF(V66=4,\"quarante \",IF(V66=5,\"cinquante \",CS66))))","v":""},{"$f":"IF(N66=6,\"soixante \",IF(H66=80,\"quatre-vingts \",IF(N66=8,\"quatre-vingt-\",\"\")))","v":""},{"$f":"IF(Q66=6,\"soixante \",IF(J66=80,\"quatre-vingts \",IF(Q66=8,\"quatre-vingt-\",\"\")))","v":""},{"$f":"IF(T66=6,\"soixante \",IF(K66=80,\"quatre-vingts \",IF(T66=8,\"quatre-vingt-\",\"\")))","v":""},{"$f":"IF(V66=6,\"soixante \",IF(L66=80,\"quatre-vingts \",IF(V66=8,\"quatre-vingt-\",\"\")))","v":""}]
[null,{"$f":"(X67&Y67&Z67&AA67&AB67&AC67&AD67&AE67&AF67&AG67&AH67&AI67&AJ67&AK67&AL67&AM67&AN67&AO67&AP67)","v":"zéro DH "},"Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ","Zéro DH ",0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ",{"$f":"UPPER(MID(B98,1,1))&MID(B98,2,168)","v":"Zéro DH "},0,{"$f":"INT((A98-D98*1000000)/1000)","v":0},{"$f":"INT(A98-D98*1000000-E98*1000)","v":0},{"$f":"ROUND(A98-D98*1000000-E98*1000-F98,2)*100","v":0},0,null,0,0,0,0,{"$f":"INT((D98-M98*100)/10)","v":0},{"$f":"D98-M98*100-N98*10","v":0},0,{"$f":"INT((E98-P98*100)/10)","v":0},{"$f":"E98-P98*100-Q98*10","v":0},0,{"$f":"INT((F98-S98*100)/10)","v":0},{"$f":"F98-S98*100-T98*10","v":0},0,{"$f":"ROUND(G98-V98*10,0)","v":0},"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ",{"$f":"UPPER(MID(B99,1,1))&MID(B99,2,168)","v":"Zéro DH "},0,{"$f":"INT((A99-D99*1000000)/1000)","v":0},{"$f":"INT(A99-D99*1000000-E99*1000)","v":0},{"$f":"ROUND(A99-D99*1000000-E99*1000-F99,2)*100","v":0},0,null,0,0,0,0,{"$f":"INT((D99-M99*100)/10)","v":0},{"$f":"D99-M99*100-N99*10","v":0},0,{"$f":"INT((E99-P99*100)/10)","v":0},{"$f":"E99-P99*100-Q99*10","v":0},0,{"$f":"INT((F99-S99*100)/10)","v":0},{"$f":"F99-S99*100-T99*10","v":0},0,{"$f":"ROUND(G99-V99*10,0)","v":0},"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ",{"$f":"UPPER(MID(B100,1,1))&MID(B100,2,168)","v":"Zéro DH "},0,{"$f":"INT((A100-D100*1000000)/1000)","v":0},{"$f":"INT(A100-D100*1000000-E100*1000)","v":0},{"$f":"ROUND(A100-D100*1000000-E100*1000-F100,2)*100","v":0},0,null,0,0,0,0,{"$f":"INT((D100-M100*100)/10)","v":0},{"$f":"D100-M100*100-N100*10","v":0},0,{"$f":"INT((E100-P100*100)/10)","v":0},{"$f":"E100-P100*100-Q100*10","v":0},0,{"$f":"INT((F100-S100*100)/10)","v":0},{"$f":"F100-S100*100-T100*10","v":0},0,{"$f":"ROUND(G100-V100*10,0)","v":0},"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]
[null,"zéro DH ",{"$f":"UPPER(MID(B101,1,1))&MID(B101,2,168)","v":"Zéro DH "},0,{"$f":"INT((A101-D101*1000000)/1000)","v":0},{"$f":"INT(A101-D101*1000000-E101*1000)","v":0},{"$f":"ROUND(A101-D101*1000000-E101*1000-F101,2)*100","v":0},0,null,0,0,0,0,{"$f":"INT((D101-M101*100)/10)","v":0},{"$f":"D101-M101*100-N101*10","v":0},0,{"$f":"INT((E101-P101*100)/10)","v":0},{"$f":"E101-P101*100-Q101*10","v":0},0,{"$f":"INT((F101-S101*100)/10)","v":0},{"$f":"F101-S101*100-T101*10","v":0},0,{"$f":"ROUND(G101-V101*10,0)","v":0},"","","","","","","","","","","zéro ","","","","DH ","","","",""," ","cents ","","",0,"cents ","","",0,"cents ","","","","","","","","","","","","","","","","","","","","","",0,"","","",0,"",0,"","",0,"","","","","","","","","","","","","",""]

{"sheet":"RECU","index":13,"n_rows":50,"n_cols":39,"rows_kept":50,"cut":false,"hidden":false,"merged":[[38,3,38,39],[33,21,33,28],[35,18,35,39],[17,0,17,39],[19,0,19,39],[21,3,21,39],[24,3,24,39],[29,21,29,28]]}
[]
["Modèle n° 9000 / F / R"]
[]
[" "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Modèle n° ADP018F-16E"]
[]
[null,null,null,"Direction Régionale ou (inter) Préfectorale de : ………………………...…."]
[null,null,null,"Subdivision de : ………………………………………………………………."]
[null,null,null,"Secteur : ………………………………………………………………………"]
[]
[]
["RECEPISSE DE DEPOT"]
[]
["de la Déclaration Modèle ADP010F-16E"]
[]
[null,null,null,"IMPOT SUR LE REVENU"]
[]
[]
[null,null,null,"DECLARATION DU REVENU GLOBAL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Du",null,null,"0",1,null,"0",1,null,"1","5","Au",null,3,1,null,1,2,null,"1","5"," "]
[]
[]
[null,null,null,null,"N° d'identification Fiscale :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C6","v":80422222}]
[]
[null,null,null,null,"Identifiant Commun de l’Entreprise « ICE » : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"/__/__/__/__/__/__/ /__/__/__/__/ /__/__/"]
[]
[null,null,null,null,"N° CNI ou carte de séjour :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+DONNES!C8","v":"K6333333"}]
[]
[null,null,null,null,"Nom et prénom (s)",null,null,null,null,null,null,null,null,null,null,null,":"," ",{"$f":"+DONNES!C4","v":"ABDO TEST"}]
[]
[]
[null,null,null,"Cadre réservé à l'administration"]
[]
[]
[null,null,null,null,"Numéro d'enregistrement :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"/__/__/__/__/__/__/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Cachet de l'administration)"]
[null,null,null,null,"Date de dépôt :",null,null,null,null,null,null,null,null,null,null,null,"/__/__/ /__/__/ /__/__/"]
[]
[null,null,null,null,"Nombre d'états :",null,null,null,null,null,null,null,null,null,null,null,"/__/__/"]
[]
[null,null,null,null,"Nombre d'annexes :",null,null,null,null,null,null,null,null,null,null,null,null,null,"/__/__/"]
[]
[null,null,null,null,"Nombre de pièces justificatives : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"/__/__/"]