{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["MAJIC","tmp","NBAT10","NBAT21","NBAT30","NBAT36","BATI00","BATI10","BATI21","BATI30","BATI36","BATI40","BATI50","BATI60","PROP","Exemples"],"not_rendered":{"images":1,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"MAJIC","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"merged":[[2,1,2,2]]}
[]
["Avant d'importer, adaptez le contenu de la cellule à fond vert"]
["chemin des fichiers MAJIC :","C:\\Users\\CHRISTIAN\\desktop",null," "]
["Le nom du fichier bati contient cette occurrence :","BATI"]
["Le nom du fichier non-bati contient cette occurrence :","NBAT"]
["Le nom du fichier propriétaires contient cette occurrence :","PROP"]

{"sheet":"tmp","index":1,"n_rows":6,"n_cols":3,"rows_kept":6,"merged":[[2,2,2,3]]}
[]
[null,"Avant de procéder, adaptez le contenu des cellules à fond vert","PARAMETRES A ADAPTER"]
[null,"chemin du dossier contenant le fichier SQLITE:","C:\\Users\\Christian\\mairie\\cadastre\\2010\\"]
[null,"Le nom  du fichier SQLITE :","parcelles_2010.sqlite"]
[null,"le nom du pilote ODBC :","SQLite3 ODBC Driver"]
[null,"le nom du fichier Excel contenant les données EDIGEO :","matrice_2011.xls"]

{"sheet":"NBAT10","index":2,"n_rows":43,"n_cols":6,"rows_kept":43,"merged":[[1,1,1,5],[1,25,1,29],[1,37,1,41]]}
[]
[null,"NBATI art 10"]
[{"$nulls":4},"ccocom"]
[null,"debut","fin","nb caractères","titre","description"]
[null,1,2,2,"ccodep","code département"]
[null,3,3,1,"ccodir","code de direction"]
[null,4,6,3,"ccocom","Code INSEE de la commune"]
[null,7,9,3,"ccopre","prefixe de section ou quartier pour communes associées"]
[null,10,11,2,"ccosec","Section cadastrale"]
[null,12,15,4,"dnupla","N° de la parcelle sur le plan"]
[null,16,19,4,"filler1"]
[null,20,21,2,"cenr","code d'enregistrement"]
[null,22,30,9,"dcntpa","Contenance en M²"]
[null,32,37,6,"dnupro","Code identifiant le propriétaire"]
[null,38,45,8,"jdatat","date de l'acte notarié"]
[null,46,50,5,"dreflt","réf au livre foncier Alsace-Moselle"]
[null,51,51,1,"gpdl","indicateur d'appartenanc à pdl"]
[null,52,54,3,"cprsecr","préfixe de la parcelle de référence"]
[null,55,56,2,"ccosecr","section de la parcelle de référence"]
[null,57,60,4,"dnuplar","N° de plan de la parcelle de référence"]
[null,61,63,3,"dnupdl","n° d'ordre de pdl"]
[null,64,64,1,"gurbpa","caractère urbain parcelle entièrement bâtie"]
[null,65,68,4,"dparpi","Numéro de parcelle primitive "]
[null,69,69,1,"ccoarp","indicateur d'arpentage"]
[null,70,70,1,"gparnf","indicateur de parcelle ne figurant pas au plan"]
[null,71,71,1,"gparbat","Indicateur référençant un bâtiment"]
[null,72,83,12,"parrev","info de la révision"]
[null,84,84,1,"gpardp","Parcelle n'appartenant pas au domaine public"]
[null,85,85,1,"fviti","parcelle au casier viticole"]
[null,86,89,4,"dnvoiri","n° de voirie"]
[null,90,90,1,"dindic","indice de répétition"]
[null,91,95,5,"ccodvoi","code majic de la voie"]
[null,96,99,4,"ccoriv","code Rivoli de la voie"]
[null,100,103,4,"ccocif","code du cdif (topad)"]
[null,104,135,32,"filler2"]
[null,136,139,4,"cconvo","Code nature de la voie"]
[null,140,165,26,"dvoilib","Libellé de voie"]
[null,166,168,3,"ccocom2","Code INSEE de la commune de la parcelle mère"]
[null,169,171,3,"ccoprem","Code du préfixe de section de la parcelle mère"]
[null,172,173,2,"ccosecm","Code section de la parcelle mère"]
[null,174,177,4,"dbuplam","Numéro de plan de la parcelle mère"]
[null,178,178,1,"type","type de filiation"]
[null,179,200,22,"filler3"]

{"sheet":"NBAT21","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"merged":[[1,1,1,7]]}
[]
[null,"NBATI art 21"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"ccodep   ","Code département        "]
[null,3,3,1,"ccodir   ","Code direction"]
[null,4,6,3,"ccocom   ","Code  commune INSEE ou DGI d’arrondissement"]
[null,7,9,3,"ccopre   ","Préfixe de section ou quartier servi pour les communes associées, &des1."]
[null,10,11,2,"ccosec   ","Section cadastrale"]
[null,12,15,4,"dnupla   ","Numéro de plan"]
[null,16,17,2,"ccosub   ","Lettres indicatives de suf"]
[null,18,19,2,"filler1   ","                             "]
[null,20,21,2,"cenr     ","Code enregistrement"]
[null,22,30,9,"dcntsf   ","Contenance de la suf"]
[null,31,36,6,"dnupro   ","Compte communal du propriétaire de la suf"]
[null,37,38,2,"gnexps   ","Code exonération permanente"]
[null,39,48,10,"drcsub   ","Revenu  cadastral  en valeur actualise référence  1980"]
[null,49,58,10,"drcsuba  ","Revenu cadastral  revalorisé en valeur du 01/01 de l’année"]
[null,59,59,1,"ccostn   ","Série-tarif"]
[null,60,61,2,"cgrnum   ","Groupe de nature de culture"]
[null,62,63,2,"dsgrpf   ","Sous-groupe alphabétique"]
[null,64,65,2,"dclssf   ","Classe  dans le groupe et la série-tarif"]
[null,66,70,5,"cnatsp   ","code nature de culture spéciale"]
[null,71,71,1,"drgpos   ","Top terrain constructible"]
[null,72,74,3,"ccoprel  ","Préfixe de la parcelle identifiant le lot"]
[null,75,76,2,"ccosecl  ","Section de la parcelle identifiant le lot"]
[null,77,80,4,"dnuplal  ","N° de plan de la parcelle de référence"]
[null,81,83,3,"dnupdl   ","Numéro d ordre de la pdl"]
[null,84,90,7,"dnulot   ","Numéro du lot - Le lot de BND se présente sous la forme 00Axxxx"]
[null,91,136,46,"rclsi    ","Données classement révisé"]
[null,137,137,1,"gnidom   ","Indicateur de suf non imposable"]
[null,138,138,1,"topja    ","Indicateur jeune agriculteur"]
[null,139,146,8,"datja    ","Date d’installation jeune agriculteur"]
[null,147,147,1,"postel   ","Indicateur de bien appartenant à la Poste"]
[null,148,200,53,"filler2 ","                             "]

{"sheet":"NBAT30","index":4,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[1,1,1,5]]}
[]
[null,"NBATI art30"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"ccodep   ","Code département"]
[null,3,3,1,"ccodir   ","Code direction"]
[null,4,6,3,"ccocom   ","Code commune INSEE ou DGI d’arrondissement"]
[null,7,9,3,"ccopre   ","Préfixe de section ou quartier servi pour les communes associées, &des1."]
[null,10,11,2,"ccosec   ","Section cadastrale"]
[null,12,15,4,"dnupla   ","Numéro de plan"]
[null,16,17,2,"ccosub   ","Lettres indicatives de suf"]
[null,18,19,2,"rnuexn   ","Numéro d ordre d’exonération temporaire"]
[null,20,21,2,"cenr     ","Code enregistrement"]
[null,22,31,10,"vecexn   ","Montant de VL sur lequel porte l’exonération"]
[null,32,33,2,"ccolloc  ","Collectivité accordant l’exonération"]
[null,34,38,5,"pexn     ","Pourcentage d’exonération"]
[null,39,40,2,"gnexts   ","Code d’exonération temporaire"]
[null,41,44,4,"jandeb   ","Année de début d’exonération"]
[null,45,48,4,"jfinex   ","Année de retour à imposition"]
[null,49,78,30,"filler1 "]
[null,79,88,10,"rcexnba","revenu cadastral exonéré, en valeur de l'année"]
[null,89,200,112,"filler2"]

{"sheet":"NBAT36","index":5,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,1,1,5]]}
[]
[null,"NBATI art36"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"ccodep   ","Code département      "]
[null,3,3,1,"ccodir   ","Code direction"]
[null,4,6,3,"ccocom   ","Code commune INSEE ou DGI d’arrondissement"]
[null,7,9,3,"ccopre   ","Préfixe de section ou quartier servi pour les communes associées, &des1"]
[null,10,11,2,"ccosec   ","Section cadastrale"]
[null,12,15,4,"dnupla   ","Numéro de plan"]
[null,16,17,2,"ccosub   ","Lettres indicatives de suf"]
[null,18,19,2,"filler1","                             "]
[null,20,21,2,"cenr     ","Code enregistrement"]
[null,22,109,88,"4occurences","Occurrences (4 collectivités)"]
[null,110,118,9,"cntmajtc","nouvelle contenance suf pour calcul majoration TC"]
[null,119,200,82,"filler2"]

{"sheet":"BATI00","index":6,"n_rows":28,"n_cols":6,"rows_kept":28,"merged":[[2,0,2,5]]}
[]
[]
["BATI article 00 identifiant du local"]
[null,"debut","fin","nb caractères","titre","description"]
[null,1,2,2,"ccodep","code département             "]
[null,3,3,1,"ccodir","code direction       "]
[null,4,6,3,"ccocom","code commune INSEE       "]
[null,7,16,10,"invar","numéro invariant        "]
[null,17,30,14,"filler1","                             "]
[null,31,32,2,"cenr","code enregistrement"]
[null,33,35,3,"filler2","                             "]
[null,36,38,3,"ccopre","préfixe de section ou quartier servi pour les communes associées,"]
[null,39,40,2,"ccosec","lettres de section           "]
[null,41,44,4,"dnupla","numéro de plan               "]
[null,45,45,1,"filler3","                             "]
[null,46,47,2,"dnubat","lettre de bâtiment           "]
[null,48,49,2,"desc","numéro d’entrée            "]
[null,50,51,2,"dniv","niveau étage                 "]
[null,52,56,5,"dpor","numéro de local"]
[null,57,60,4,"ccoriv","Code Rivoli de la voie   "]
[null,61,61,1,"filler4","                             "]
[null,62,66,5,"ccovoi","Code Majic2 de la voie  "]
[null,67,70,4,"dnvoiri","Numéro de voirie         "]
[null,71,71,1,"dindic","indice de répétition    "]
[null,72,75,4,"ccocif","code du cdi/cdif (code topad)"]
[null,76,105,30,"dvoilib","libelle de la voie  "]
[null,106,106,1,"cleinvar","clé alpha no invariant"]
[null,107,200,94,"filler5"]

{"sheet":"BATI10","index":7,"n_rows":80,"n_cols":6,"rows_kept":80,"merged":[[1,0,1,5]]}
[]
["BATI article 10 descriptif du local"]
[]
[null,"DEB","FIN","LGR","titre","DESCRIPTION"]
[null,1,2,2,"ccodep","code département             "]
[null,3,3,1,"ccodir","code direction "]
[null,4,6,3,"ccocom","code commune INSEE           "]
[null,7,16,10,"invar","numéro invariant"]
[null,17,30,14,"filler1","                             "]
[null,31,32,2,"cenr","code enregistrement          "]
[null,33,35,3,"filler2","                             "]
[null,36,36,1,"gpdl","indicateur  d’appartenance à un lot de pdl"]
[null,37,37,1,"dsrpar","lettre de série rôle         "]
[null,38,43,6,"dnupro","compte communal de propriétaire"]
[null,44,51,8,"jdatat","date d’acte de mutation"]
[null,52,57,6,"dnufnl","compte communal de fonctionnaire logé"]
[null,58,58,1,"ccoeva","code évaluation              "]
[null,59,59,1,"CCITLV","local imposable à la taxe sur les locaux vacants                      "]
[null,60,60,1,"dteloc","type de local"]
[null,61,62,2,"gtauom","zone  de ramassage des ordures ménagères"]
[null,63,65,3,"dcomrd","Pourcentage de réduction sur tom"]
[null,66,66,1,"ccoplc","Code de construction particulière"]
[null,67,68,2,"cconlc","Code nature de local"]
[null,69,77,9,"dvltrt","Valeur locative totale retenue pour le local"]
[null,78,81,4,"filler3"]
[null,82,83,2,"cc48lc","Catégorie de loi de 48       "]
[null,84,92,9,"dloy48a","Loyer de 48 en valeur de l’année"]
[null,93,93,1,"top48a","top taxation indiquant si la pev est impose au loyer ou a la vl"]
[null,94,94,1,"dnatlc","Nature d occupation"]
[null,95,102,8,"dnupas","no passerelle TH/TP"]
[null,103,104,2,"gnexcf","code nature exo ecf"]
[null,105,107,3,"dtaucf","taux exo ecf"]
[null,108,108,1,"CCHPR","Top indiquant  une mutation propriétaire"]
[null,109,112,4,"JANNAT","Année de construction"]
[null,113,114,2,"DNBNIV","Nombre de niveaux de la construction"]
[null,115,115,1,"HLMSEM","Local appartenant à hlm ou sem"]
[null,116,116,1,"POSTEL","Local de Poste ou France Telecom"]
[null,117,118,2,"DNATCG","Code  nature du changement évaluation"]
[null,119,126,8,"JDATCGL","date constatation changement"]
[null,127,132,6,"DNUTBX","no gestionnaire déclarant taxe bureaux"]
[null,133,141,9,"DVLTLA","VL totale du local actualisée"]
[null,142,145,4,"JANLOC","Année de création du local"]
[null,146,147,2,"CCSLOC","Code cause création du local"]
[null,148,148,1,"FBURX","Indicateur présence bureaux"]
[null,149,149,1,"GIMTOM","Indicateur imposition OM exploitable à partir de 2002"]
[null,150,151,2,"CBTABT","Code exonération HLM zone sensible"]
[null,152,155,4,"JDTABT","Année début d’exonération ZS"]
[null,156,159,4,"JRTABT","Année fin d’exonération ZS"]
[null,160,163,4,"JACLOC","Année d’achèvement du local"]
[null,164,168,5,"FILLER4"]
[null,169,173,5,"CCONAC","Code NACE pour les locaux professionnels"]
[null,174,200,27,"FILLER5","                             "]
[null,78,81,4,"FILLER6"]
[null,82,83,2,"cc48lc_2","Catégorie de loi de 48       "]
[null,84,92,9,"dloy48a_2","Loyer de 48 en valeur de l’année"]
[null,93,93,1,"top48a_2","top taxation indiquant si la pev est impose au loyer ou a la vl"]
[null,94,94,1,"dnatlc_2","Nature d occupation"]
[null,95,102,8,"dnupas_2","no passerelle TH/TP"]
[null,103,104,2,"gnexcf_2","code nature exo ecf"]
[null,105,107,3,"dtaucf_2","taux exo ecf"]
[null,108,108,1,"CCHPR_2","Top indiquant  une mutation propriétaire"]
[null,109,112,4,"JANNAT_2","Année de construction"]
[null,113,114,2,"DNBNIV_2","Nombre de niveaux de la construction"]
[null,115,115,1,"HLMSEM_2","Local appartenant à hlm ou sem"]
[null,116,116,1,"POSTEL_2","Local de Poste ou France Telecom"]
[null,117,118,2,"DNATCG_2","Code  nature du changement évaluation"]
[null,119,126,8,"JDATCGL_2","date constatation changement"]
[null,127,132,6,"DNUTBX_2","no gestionnaire déclarant taxe bureaux"]
[null,133,141,9,"DVLTLA_2","VL totale du local actualisée"]
[null,142,145,4,"JANLOC_2","Année de création du local"]
[null,146,147,2,"CCSLOC_2","Code cause création du local"]
[null,148,148,1,"FBURX_2","Indicateur présence bureaux"]
[null,149,149,1,"GIMTOM_2","Indicateur imposition OM exploitable à partir de 2002"]
[null,150,151,2,"CBTABT_2","Code exonération HLM zone sensible"]
[null,152,155,4,"JDTABT_2","Année début d’exonération ZS"]
[null,156,159,4,"JRTABT_2","Année fin d’exonération ZS"]
[null,160,163,4,"JACLOC_2","Année d’achèvement du local"]
[null,164,168,5,"FILLER7"]
[null,169,173,5,"CCONAC_2","Code NACE pour les locaux professionnels"]
[null,174,200,27,"FILLER8","                             "]

{"sheet":"BATI21","index":8,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[1,0,1,5]]}
[]
["BATI article 21 descriptif de pev"]
[]
[null,"DEB","FIN","LGR","titre","DESCRIPTION"]
[null,1,2,2,"CCODEP","Code département        "]
[null,3,3,1,"CCODIR","Code direction   "]
[null,4,6,3,"CCOCOM","Code commune INSEE"]
[null,7,16,10,"INVAR","Numéro invariant"]
[null,17,27,11,"FILLER1","                             "]
[null,28,30,3,"DNUPEV","Numéro de pev  "]
[null,31,32,2,"CENR","Code enregistrement"]
[null,33,35,3,"FILLER2","                             "]
[null,36,36,1,"CCOAFF","Affectation de la pev"]
[null,37,37,1,"CCOSTB","lettre  de série tarif bâtie ou secteur locatif"]
[null,38,39,2,"DCAPEC","Catégorie                    "]
[null,40,42,3,"DCETLC","Coefficient d entretien"]
[null,43,45,3,"FILLER3"]
[null,46,51,6,"DSUPOT","Surface pondérée"]
[null,52,60,9,"DVLPER","Valeur  locative  de la pev, en valeur de référence (1970) sauf pour les établissements de code évaluation A"]
[null,61,69,9,"DVLPERA","Valeur  locative  de la pev, en valeur de l’année"]
[null,70,71,2,"GNEXPL","Nature d’exonération permanente"]
[null,72,101,30,"FILLER4"]
[null,102,102,1,"CCTHP","Code occupation à la Th ou à la TP"]
[null,103,103,1,"RETIMP","Top : retour partiel ou total à imposition"]
[null,104,106,3,"DNUREF","Numéro de local type"]
[null,107,138,32,"FILLER5"]
[null,139,139,1,"GNIDOM","Top : pev non imposable (Dom)"]
[null,140,152,13,"FILLER6"]
[null,153,161,9,"DVLTPE","VL totale de la PEV MAJIC"]
[null,162,165,4,"FILLER7"]
[null,166,166,1,"TOPCN","Top construction nouvelle"]
[null,167,167,1,"TPEVTIEOM","Top Local passible de la TEOM"]
[null,168,172,5,"DCSPLC_A","Coefficient de situation particulière"]
[null,173,177,5,"DCSGLC_A","Coefficient de situation générale"]
[null,178,182,5,"DCRALC_A","correctif d’ascenseur"]
[null,183,200,18,"FILLER8"]

{"sheet":"BATI30","index":9,"n_rows":29,"n_cols":6,"rows_kept":29,"merged":[[1,0,1,5]]}
[]
["BATI article 30 exonération de pev"]
[]
[null,"DEB","FIN","LGR","titre","DESCRIPTION"]
[null,1,2,2,"CCODEP","Code département   "]
[null,3,3,1,"CCODIR","Code direction"]
[null,4,6,3,"CCOCOM","Code commune INSEE  "]
[null,7,16,10,"INVAR","Numéro invariant"]
[null,17,23,7,"FILLER1","                             "]
[null,24,27,4,"JANBIL","Année d’immobilisation"]
[null,28,30,3,"DNUPEV","Numéro de pev"]
[null,31,32,2,"CENR","Code enregistrement"]
[null,33,35,3,"DNUEXB","Numéro d’ordre de l’article"]
[null,36,37,2,"CCOLLOC","Code de collectivité locale accordant l’exonération"]
[null,38,42,5,"PEXB","Taux d’exonération accordée"]
[null,43,44,2,"GNEXTL","Nature d’exonération temporaire (et permanente pour ets. Industriels)"]
[null,45,48,4,"JANDEB","année de début d’exonération"]
[null,49,52,4,"JANIMP","année de retour à imposition"]
[null,53,102,50,"FILLER2"]
[null,103,111,9,"DVLDIF2","montant de la VL exonérée (valeur 70)"]
[null,112,112,1,"FILLER3"]
[null,113,121,9,"DVLDIF2A","Montant de la VL exonérée (valeur de l'année)"]
[null,122,122,1,"FILLER4"]
[null,123,131,9,"FCEXB2","Fraction de la VL exonérée (valeur 70)"]
[null,132,132,1,"FILLER5"]
[null,133,141,9,"FCEXBA2","Fraction de la VL exonérée (valeur de l'année)"]
[null,142,142,1,"FILLER6"]
[null,143,151,9,"RCEXBA2","revenu cadastral exonéré (valeur de l'année)"]
[null,152,200,49,"FILLER7"]

{"sheet":"BATI36","index":10,"n_rows":25,"n_cols":6,"rows_kept":25,"merged":[[1,0,1,5]]}
[]
["BATI article 36 taxation de pev"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"CCODEP","Code département"]
[null,3,3,1,"CCODIR","Code direction"]
[null,4,6,3,"CCOCOM","Code commune INSEE"]
[null,7,16,10,"INVAR","Numéro invariant"]
[null,17,23,11,"FILLER1","                             "]
[null,24,27,4,"JANBIL","Année d’immobilisation"]
[null,28,30,3,"DNUPEV","Numéro de pev"]
[null,31,32,2,"CENR","Code enregistrement          "]
[null,33,35,3,"FILLER","                             "]
[null,36,44,9,"VLBAI","Part de VL imposée (valeur 70)"]
[null,45,45,1,"FILLER2"]
[null,46,54,9,"VLBAIA","Part de VL imposée (valeur de l'année)"]
[null,55,55,1,"FILLER3"]
[null,56,64,9,"BIPEVLA","Base d'imposition de la PEV (valeur de l'année)"]
[null,65,65,1,"FILLER4"]
[null,156,164,9,"BATEOM","Base ordures ménagères"]
[null,165,165,1,"FILLER5","                             "]
[null,166,174,9,"BAOMEC","BASE ORDURES MENAGERES ECRETEE"]
[null,175,180,6,"MVLTIEOMX","Montant TIEOM"]
[null,181,196,16,"PVLTIEOM","Ratio VL n-1 de la PEV / VL n-1 collectivité"]
[null,197,200,4,"FILLER6","collectivité"]

{"sheet":"BATI40","index":11,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[1,0,1,5]]}
[]
["BATI article 40 descriptif partie principale habitation"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"CCODEP","Code département"]
[null,3,3,1,"CCODIR","Code direction"]
[null,4,6,3,"CCOCOM","Code commune INSEE"]
[null,7,16,10,"INVAR","Numéro invariant"]
[null,17,27,11,"FILLER1","                             "]
[null,28,30,3,"DNUPEV","Numéro de pev"]
[null,31,32,2,"CENR","Code enregistrement"]
[null,33,35,3,"DNUDES","Numéro d’ordre de descriptif"]
[null,36,75,40,"occurences","4 occurrences positionnelles d’éléments incorporés"]
[null,76,76,1,"GEAULC","Présence d’eau               "]
[null,77,77,1,"GELELC","Présence d’électricité"]
[null,78,78,1,"GESCLC","Présence d’escalier de ser- vice (appartement)"]
[null,79,79,1,"GGAZLC","Présence du gaz"]
[null,80,80,1,"GASCLC","Présence d’ascenseur (appartement)"]
[null,81,81,1,"GCHCLC","Présence du chauffage central"]
[null,82,82,1,"GVORLC","Présence de vide-ordures (appartement)"]
[null,83,83,1,"GTEGLC","Présence du tout à l’égout"]
[null,84,85,2,"DNBBAI","Nombre de baignoires"]
[null,86,87,2,"DNBDOU","Nombre de douches"]
[null,88,89,2,"DNBLAV","Nombre de lavabos"]
[null,90,91,2,"DNBWC","Nombre de WC"]
[null,92,94,3,"DEQDHA","Equivalence superficielle des éléments de confort"]
[null,95,96,2,"DNBPPR","Nombre de pièces principales"]
[null,97,98,2,"DNBSAM","Nombre de salles à manger"]
[null,99,100,2,"DNBCHA","Nombre de chambres"]
[null,101,102,2,"DNBCU8","Nombre de cuisines de moins de 9 m2"]
[null,103,104,2,"DNBCU9","Nombre  de  cuisines  d’au moins 9 m2"]
[null,105,106,2,"DNBSEA","Nombre de salles d’eau"]
[null,107,108,2,"DNBANN","Nombre de pièces annexes"]
[null,109,110,2,"DNBPDC","Nombre de pièces"]
[null,111,116,6,"DSUPDC","Superficie des pièces"]
[null,117,118,2,"DMATGM","Matériaux des gros murs      "]
[null,119,120,2,"DMATTO","Matériaux des toitures"]
[null,121,124,4,"JANNAT","Année d’achèvement"]
[null,125,125,1,"DETENT","état d’entretien"]
[null,126,127,2,"DNBNIV","Nombre de niveaux"]
[null,128,200,73,"FILLER2","                             "]

{"sheet":"BATI50","index":12,"n_rows":15,"n_cols":6,"rows_kept":15,"merged":[[1,0,1,5]]}
[]
["BATI article 50 descriptif professionnel"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"CCODEP","Code département"]
[null,3,3,1,"CCODIR","Code direction"]
[null,4,6,3,"CCOCOM","Code commune INSEE"]
[null,7,16,10,"INVAR","Numéro invariant"]
[null,17,27,11,"FILLER1","                             "]
[null,28,30,3,"DNUPEV","Numéro de pev"]
[null,31,32,2,"CENR","Code enregistrement"]
[null,33,35,3,"DNUDES","Numéro d’ordre de descriptif"]
[null,36,71,36,"FILLER2"]
[null,72,80,9,"VSURZT","Surface réelle totale"]
[null,81,200,120,"FILLER3"]

{"sheet":"BATI60","index":13,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[1,0,1,5]]}
[]
["BATI article 60 descriptif de dépendance"]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"CCODEP ","Code département"]
[null,3,3,1,"CCODIR ","Code direction"]
[null,4,6,3,"CCOCOM ","Code commune INSEE"]
[null,7,16,10,"INVAR","Numéro invariant"]
[null,17,27,11,"FILLER1","                             "]
[null,28,30,3,"DNUPEV ","Numéro de pev"]
[null,31,32,2,"CENR ","Code enregistrement"]
[null,33,35,3,"DNUDES ","Numéro d’ordre de descriptif"]
[null,36,41,6,"DSUDEP ","Surface réelle de la dépendance"]
[null,42,43,2,"CCONAD ","Nature de dépendance"]
[null,44,49,6,"ASITET ","Localisation (bat, esc, niv)"]
[null,50,51,2,"DMATGM ","Matériaux des gros murs"]
[null,52,53,2,"DMATTO ","Matériaux des toitures"]
[null,54,54,1,"DETENT ","état d'entretien"]
[null,55,55,1,"GEAULC ","Présence d'eau"]
[null,56,56,1,"GELELC ","Présence d’électricité"]
[null,57,57,1,"GCHCLC ","Présence du chauffage central"]
[null,58,59,2,"DNBBAI ","Nombre de baignoires"]
[null,60,61,2,"DNBDOU ","Nombre de douches"]
[null,62,63,2,"DNBLAV ","Nombre de lavabos"]
[null,64,65,2,"DNBWC","Nombre de WC"]
[null,66,68,3,"DEQTLC ","Equivalence superficielle des éléments de confort"]
[null,69,70,2,"DCIMLC ","Coefficient de pondération"]
[null,71,73,3,"DCETDE ","Coefficient d entretien"]
[null,74,76,3,"FILLER2"]
[null,77,82,6,"DCSPDE_A","Coefficient de situation particulière"]
[null,83,200,118,"FILLER3"]

{"sheet":"PROP","index":14,"n_rows":57,"n_cols":6,"rows_kept":57}
[]
[]
[]
[null,"DEB","FIN","LGR","NOM","DESCRIPTION"]
[null,1,2,2,"ccodep","code département             "]
[null,3,3,1,"ccodir","code direction               "]
[null,4,6,3,"ccocom","code commune INSEE           "]
[null,7,12,6,"dnupro","compte communal              "]
[null,13,14,2,"dnulp","numéro de libellé partiel    "]
[null,15,18,4,"ccocif","code cdif                    "]
[null,19,24,6,"dnuper","numéro de personne dans le cdif"]
[null,25,25,1,"ccodro","code du droit réel ou parti- culier"]
[null,26,26,1,"ccodem","code du démembrement/indivi-sion"]
[null,27,27,1,"gdesip","indicateur du destinataire de l’avis d’imposition"]
[null,28,28,1,"gtoper","indicateur de personne physi-que ou morale"]
[null,29,29,1,"ccoqua","Code qualité de personne phy-sique"]
[null,30,31,2,"gnexcf","code exo ecf                 "]
[null,32,34,3,"dtaucf","taux exo ecf                 "]
[null,35,37,3,"dnatpr","Code nature de personne phy-sique ou morale"]
[null,38,39,2,"ccogrm","Code groupe de personne mora-le"]
[null,40,49,10,"dsglpm","sigle de personne morale     "]
[null,50,56,7,"dforme","forme juridique abrégée majic2"]
[null,57,116,60,"ddenom","Dénomination de personne phy-sique ou morale"]
[null,117,117,1,"gtyp3","type de la 3eme ligne d’a-dresse"]
[null,118,118,1,"gtyp4","Type de la 4eme ligne d’a-dresse"]
[null,119,119,1,"gtyp5","type de la 5eme ligne d’a-dresse"]
[null,120,120,1,"gtyp6","type de la 6eme ligne d’a-dresse"]
[null,121,150,30,"dlign3","3eme ligne d’adresse         "]
[null,151,186,36,"dlign4","4eme ligne d’adresse         "]
[null,187,216,30,"dlign5","5eme ligne d’adresse         "]
[null,217,248,32,"dlign6","6eme ligne d’adresse         "]
[null,249,251,3,"ccopay","code de pays étranger et TOM"]
[null,252,253,2,"ccodep1a2","Code département de l’adresse"]
[null,254,254,1,"ccodira","Code direction de l’adresse  "]
[null,255,257,3,"ccocom_adr","Code commune de l’adresse    "]
[null,258,262,5,"ccovoi","Code majic2 de la voie       "]
[null,263,266,4,"ccoriv","Code rivoli de la voie       "]
[null,267,270,4,"dnvoiri","numéro de voirie             "]
[null,271,271,1,"dindic","indice de répétition de voi- rie"]
[null,272,276,5,"ccopos","Code postal                  "]
[null,277,286,10,"dnirpp","zone à blanc                 "]
[null,287,289,3,"dqualp","Qualité abrégée              "]
[null,290,319,30,"dnomlp","Nom d’usage                  "]
[null,320,334,15,"dprnlp","Prénoms associés au nom d’usage"]
[null,335,344,10,"jdatnss","date de naissance            "]
[null,345,402,58,"dldnss","lieu de naissance            "]
[null,403,405,3,"epxnee","mention du complément        "]
[null,406,435,30,"dnomcp","Nom complément               "]
[null,436,450,15,"dprncp","Prénoms associés au complé-ment"]
[null,451,466,16,"filler1"]
[null,467,475,9,"dsiren","numéro siren                 "]
[null,476,477,2,"filler2"]
[null,478,478,1,"topja","indic jeune agriculteur      "]
[null,479,486,8,"datja","date installation jeune agriculteur       "]
[null,487,533,47,"filler3"]
[null,534,537,4,"DFORMJUR","Forme juridique"]
[null,538,550,{"$f":"C57-B57+1","v":13},"filler4"]

{"sheet":"Exemples","index":15,"n_rows":11,"n_cols":3,"rows_kept":11}
[null,null,"compter les logements :"]
[null,null,"il faut compter les occurrences \"MA\" et \"AP\" dans la colonne \"CCONLC\" de l'article BATI_10"]
[null,null,"ex: =NB.SI(A2:A1000;\"AP\")+NB.SI(A2:A1000;\"MA\")"]
[]
[null,null,"Compter les logements vacants :"]
[null,null,"il faut compter les occurrences \"V\" dans la colonne \"DNATLC\" de l'article BATI_10"]
[null,null,"ex: =NB.SI(A2:A1000);\"V\")"]
[]
[null,null,"Compter les éxonérations TH \"économiquement faibles\" :"]
[null,null,"Il faut compter les occurrences commençant par \"E\" dans la colonne \"GNEXTL\" de l'article BATI_30"]
[null,null,"ex: =NB.SI(A2:A1000;\"E*\")"]