{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calcul EHm"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calcul EHm","index":0,"n_rows":174,"n_cols":8,"rows_kept":174,"cut":false,"hidden":false,"merged":[[154,4,154,6],[145,4,145,6],[146,4,146,6],[138,1,139,1],[125,1,125,2],[126,1,126,2],[27,4,27,6],[27,1,27,2],[106,5,106,6],[105,1,105,6],[109,1,109,6],[110,3,110,6],[112,1,112,6],[113,3,113,6],[113,1,113,2],[114,1,114,2],[115,1,115,2],[116,1,116,2],[117,1,117,2],[118,1,118,2],[119,1,119,2],[120,1,120,2],[121,1,121,2],[122,1,122,2],[167,1,167,2],[167,4,167,6],[148,1,149,1],[150,1,151,1],[152,1,153,1],[154,1,155,1],[127,1,127,2],[128,1,128,2],[129,1,131,1],[132,1,134,1],[142,1,143,1],[144,1,145,1],[155,4,155,6],[150,4,150,6],[151,4,151,6],[152,4,152,6],[153,4,153,6],[137,1,137,2],[148,4,148,6],[149,4,149,6],[140,4,140,6],[141,4,141,6],[142,4,142,6],[143,4,143,6],[124,1,124,2],[135,1,135,6],[123,1,123,6],[124,3,124,6],[136,3,136,6],[173,2,173,6],[164,1,164,6],[168,1,168,6],[156,1,156,2],[157,1,157,2],[158,1,158,2],[159,1,159,2],[165,1,165,6],[166,2,166,6],[169,1,169,6],[170,2,170,6],[160,1,160,6],[162,1,162,6],[156,4,156,6],[157,4,157,6],[158,4,158,6],[159,4,159,6],[171,2,172,6],[147,4,147,6],[144,4,144,6],[137,4,137,6],[138,4,138,6],[139,4,139,6],[130,4,130,6],[131,4,131,6],[132,4,132,6],[133,4,133,6],[134,4,134,6],[125,4,125,6],[126,4,126,6],[127,4,127,6],[128,4,128,6],[129,4,129,6],[118,4,118,6],[119,4,119,6],[120,4,120,6],[121,4,121,6],[122,4,122,6],[111,4,111,6],[114,4,114,6],[115,4,115,6],[116,4,116,6],[117,4,117,6],[97,1,97,4],[94,1,94,6],[95,1,95,4],[96,4,96,6],[99,1,99,4],[101,1,101,4],[103,1,103,4],[98,5,98,6],[100,5,100,6],[102,5,102,6],[104,5,104,6],[22,2,22,6],[28,1,28,5],[26,1,26,2],[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,3,26,5],[40,1,40,5],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[38,1,38,2],[39,4,39,5],[28,6,29,6],[29,4,29,5],[37,4,37,5],[7,1,7,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[16,1,16,6],[17,1,18,6],[19,2,19,6],[20,2,20,6],[21,1,21,6],[9,2,9,5],[10,2,10,5],[9,1,10,1],[91,1,91,4],[91,5,91,6],[80,4,80,5],[82,4,82,5],[83,4,83,5],[84,4,84,5],[82,1,82,2],[83,1,83,2],[84,1,84,2],[85,1,85,2],[53,1,53,5],[41,1,41,2],[54,1,54,2],[43,1,43,2],[44,1,44,2],[46,1,46,2],[47,1,49,1],[50,1,52,1],[87,1,87,6],[42,4,42,5],[45,4,45,5],[41,4,41,5],[44,4,44,5],[47,4,47,5],[48,4,48,5],[50,4,50,5],[51,4,51,5],[92,1,92,4],[92,5,92,6],[55,1,56,1],[57,1,57,6],[58,1,58,6],[76,1,76,6],[79,1,79,6],[61,1,61,6],[64,1,64,6],[67,1,67,6],[70,1,70,6],[73,1,73,6],[89,4,89,5],[89,1,89,2],[90,1,90,2],[90,4,90,5],[55,4,55,5],[59,4,59,5],[62,4,62,5],[77,4,77,5],[74,4,74,5],[71,4,71,5],[68,4,68,5],[65,4,65,5]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Détermination de la valeur EHm"]
[]
[null,null,"Commune de Bertrange"]
[null,null,"b.p. 28  L-8005 Bertrange"]
[]
[null,"Formulaire électronique disponible sous www.bertrange.lu, rubrique « Pacte Climat »"]
[null,"En cas de questions, prière de contacter M. Gilles BESTGEN Tél: 26312-358  - Courriel: gilles.bestgen@bertrange.lu"]
[]
[]
[null,"Nom de la société / de l’organisme / de l’institution :"]
[]
[]
[null,"N° Client"]
[null,"Nom du responsable (contact)"]
[null,"Adresse de correspondance"]
[null,"N° et Rue"]
[null,"Code postal / Localité"]
[null,"EMail"]
[null,"Téléphone"]
[null,"EHm à appliquer (selon les calculs ci-après)",null,{"$f":"G87","v":0},null,null,"EHm"]
[null,"En cas de saisie électronique:",null,null,"à cocher par le caractère \"x\" (minuscule) du clavier"]
[null,"II: Activités publiques et collectives",null,null,null,null,"Calcul EHm"]
[null,null,null,null,"capacité autorisée"]
[null,"Hôpital, clinique, maison de soins",null,"q",null,"lits",{"$f":"E31*H31","v":0},2.5]
[null,"Centres intégrés pour personnes âgées",null,"q",null,"lits",{"$f":"E32*H32","v":0},2]
[null,"Crèche, école",null,"q",null,"enfants",0,0.1]
[null,"Internat",null,"q",null,"enfants",0,0.6]
[null,"Cantine scolaire, maison relais",null,"q",null,"chaises",0,0.2]
[null,"Piscine couverte (avec ou sans sauna)",null,"q",null,"visiteurs",0,0.3]
[null,"Piscine à l’air libre",null,"q",null,"visiteurs",0,0.1]
[null,null,null,null,"m2 de surface bâtie"]
[null,"Centre polyvalent, salle de spectacle, centre sportif",null,"q",null,"m2",{"$f":"(ROUNDUP((E39/100),0)*H39)","v":0},3]
[null,"Lieu de culte",null,"q",{"$f":"IF(D40=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D40=\"x\",H40,0)","v":0},2]
[null,"III: Hôtellerie, restauration et tourisme",null,null,null,null,"Calcul EHm"]
[null,"Résidence secondaire",null,"q",{"$f":"IF(D42=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D42=\"x\",H42,0)","v":0},2.5]
[null,null,null,null,"capacité autorisée"]
[null,"Hôtel et auberge\n(sans l’activité gastronomique)",null,"q",null,"lits",{"$f":"E44*H44","v":0},0.6]
[null,"Gîte rural",null,"q",{"$f":"IF(D45=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D45=\"x\",H45,0)","v":0},4]
[null,null,null,null,"capacité autorisée"]
[null,"Camping\n(sans l’activité gastronomique, sans piscine)",null,"q",null,"emplacements",{"$f":"E47*0.5","v":0},0.5]
[null,"Restaurant","< 25 chaises","q",{"$f":"IF(D48=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D48=\"x\",H48,0)","v":0},5]
[null,null,"< 50 chaises","q",{"$f":"IF(D49=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D49=\"x\",H49,0)","v":0},10]
[null,null,"≥ 50 chaises","q",null,"chaises",{"$f":"E50*H50","v":0},0.3]
[null,"Café, salon de consommation","< 25 chaises","q",{"$f":"IF(D51=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D51=\"x\",H51,0)","v":0},4]
[null,null,"< 50 chaises","q",{"$f":"IF(D52=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D52=\"x\",H52,0)","v":0},7]
[null,null,"≥ 50 chaises","q",null,"chaises",{"$f":"E53*H53","v":0},0.2]
[null,"IV: Activités artisanales et commerciales",null,null,null,null,"Calcul EHm"]
[null,"Administration, bureau, guichet, assurance, banque, cabinet médical, cabinet de notaire ou autre service",null,"q",null,"m2 de surface",{"$f":"(ROUNDUP((E55/150),0)*H55)","v":0},1]
[null,"ou :","≤ 10 salariés *","q",{"$f":"IF(D56=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D56=\"x\",H56,0)","v":0},1]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D57=\"x\",H56+(ROUNDUP(((E57-10)/5),0)*H57),0)","v":0},0.5]
[null,"Commerce (sans production) :"]
[null,"Grande surface, épicerie, point de vente alimentaire, magasin, boutique"]
[null,null,"≤ 10 salariés *","q",null,null,{"$f":"IF(D60=\"x\",H60,0)","v":0},2.5]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D61=\"x\",H60+(ROUNDUP(((E61-10)/5),0)*H61),0)","v":0},1.5]
[null,"Boucherie, poissonnerie, boulangerie, pâtisserie (site de production avec vente)"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D63=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D63=\"x\",H63,0)","v":0},10]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D64=\"x\",H63+(ROUNDUP(((E64-10)/5),0)*H64),0)","v":0},6.5]
[null,"Salon de coiffure"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D66=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D66=\"x\",H66,0)","v":0},6]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D67=\"x\",H66+(ROUNDUP(((E67-10)/5),0)*H67),0)","v":0},4]
[null,"Nettoyage à sec"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D69=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D69=\"x\",H69,0)","v":0},30]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D70=\"x\",H69+(ROUNDUP(((E70-10)/5),0)*H70),0)","v":0},20]
[null,"Entreprise de transport de marchandises et de construction (avec dépôt)"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D72=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D72=\"x\",H72,0)","v":0},3.5]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D73=\"x\",H72+(ROUNDUP(((E73-10)/5),0)*H73),0)","v":0},2.5]
[null,"Garage, atelier de réparation de véhicules automoteurs"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D75=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D75=\"x\",H75,0)","v":0},15]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D76=\"x\",H75+(ROUNDUP(((E76-10)/5),0)*H76),0)","v":0},10]
[null,"Atelier mécanique, vente de pneus"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D78=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D78=\"x\",H78,0)","v":0},5.5]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D79=\"x\",H78+(ROUNDUP(((E79-10)/5),0)*H79),0)","v":0},3.5]
[null,"Artisanat, menuisier, électricien, carreleur, peintre, plombier, installateur sanitaire, charpentier\n(avec dépôt)"]
[null,null,"≤ 10 salariés *","q",{"$f":"IF(D81=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D81=\"x\",H81,0)","v":0},3.5]
[null,null,"> 10 salariés *","q",null,"pers. occupées",{"$f":"IF(D82=\"x\",H81+(ROUNDUP(((E82-10)/5),0)*H82),0)","v":0},2.5]
[null,"Mazout et combustibles",null,"q",{"$f":"IF(D83=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D83=\"x\",H83,0)","v":0},10]
[null,"Station-service (avec shop)",null,"q",{"$f":"IF(D84=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D84=\"x\",H84,0)","v":0},3.5]
[null,"Installation de lavage de voitures",null,"q",{"$f":"IF(D85=\"x\",\"è\",\"\")","v":""},null,{"$f":"IF(D85=\"x\",H85,0)","v":0},15]
[null,"Distilleries d’alcool, vinaigrerie",null,"q",null,"litres d’alcool /vinaigre pur produits par an",{"$f":"(ROUNDUP((E86/1000),0)*H86)","v":0},0.5]
[null,null,null,null,null,null,{"$f":"SUM(G30:G86)","v":0}]
[null,"Il est certifié que les informations renseignées ci-dessus sont exactes :"]
[]
[null,null,null,", le "]
[null,"Localité",null,null,"Date"]
[null,"Nom du signataire / Cachet de la société",null,null,null,"Signature"]
[]
[]
[null,"Exemples de calcul :"]
[null,"Crèche avec une capacité autorisée de 20 enfants :"]
[null,"Crèche, école","x","20 enfants","(0,1 x 20 =) 2 EHm"]
[null,"Restaurant 20 chaises (autorisées) :"]
[null,"Restaurant","< 25 chaises","x",null,"5 EHm"]
[null,"Restaurant 40 chaises (autorisées) :"]
[null,"Restaurant","< 50 chaises","x",null,"10 EHm"]
[null,"Restaurant 100 chaises (autorisées) :"]
[null,"Restaurant","≥ 50 chaises","x","100 chaises","(100 x 0,3=) 30 EHm"]
[null,"Epicerie avec 10 salariés :"]
[null,null,"≤ 10 salariés *","x",null,"2,5 EHm"]
[null,"Epicerie avec 25 salariés :"]
[null,null,"> 10 salariés *","x","25 pers occupées","(2,5 + 1,5 + 1,5 + 1,5=) 7 EHm"]
[]
[null,"Tableau des EH moyens annuels"]
[null,"I : Population résidente"]
[null,"Groupe ou activité",null,"Charge polluante moyenne annuelle (EHm)"]
[null,"Population résidente",null,2.5,"EHm / unité d’habitation (maison unifam. ou appartement)"]
[null,"II : Activités publiques et collectives"]
[null,"Groupe ou activité",null,"Charge polluante moyenne annuelle (EHm)"]
[null,"Hôpital, clinique, maison de soins",null,2.5,"EHm / lit selon capacité autorisée"]
[null,"Centres intégrés pour personnes âgées",null,2,"EHm / lit selon capacité autorisée"]
[null,"Crèche, école",null,0.1,"EHm / enfant selon capacité autorisée"]
[null,"Internat",null,0.6,"EHm / enfant selon capacité autorisée"]
[null,"Cantine scolaire, maison relais",null,0.2,"EHm / chaise selon capacité autorisée"]
[null,"Piscine couverte (avec ou sans sauna)",null,0.3,"EHm / visiteurs selon capacité autorisée"]
[null,"Piscine à l’air libre",null,0.1,"EHm / visiteurs selon capacité autorisée"]
[null,"Centre polyvalent, salle de spectacle, centre sportif",null,3,"EHm / tranche entamée de 100 m2 de surface bâtie"]
[null,"Lieu de culte",null,2,"EHm / lieu de culte"]
[null,"III : Hôtellerie, restauration et tourisme"]
[null,"Groupe ou activité",null,"Charge polluante moyenne annuelle (EHm)"]
[null,"Résidence secondaire",null,2.5,"EHm / unité"]
[null,"Hôtel et auberge (sans l’activité gastronomique)",null,0.6,"EHm / lit selon capacité autorisée"]
[null,"Gîte rural",null,4,"EHm / gîte"]
[null,"Camping (sans l’activité gastronomique, sans piscine)",null,0.5,"EHm / emplacement selon capacité autorisée"]
[null,"Restaurant","< 25 chaises",5,"EHm / établissement"]
[null,null,"< 50 chaises",10,"EHm / établissement"]
[null,null,"≥ 50 chaises",0.3,"EHm / chaise selon capacité autorisée"]
[null,"Café, salon de consommation","< 25 chaises",4,"EHm / établissement"]
[null,null,"< 50 chaises",7,"EHm / établissement"]
[null,null,"≥ 50 chaises",0.2,"EHm / chaise selon capacité autorisée"]
[null,"IV : Activités artisanales et commerciales"]
[null,"Groupe ou activité",null,"Charge polluante moyenne annuelle (EHm)"]
[null,"Administration, bureau, guichet, assurance, banque, cabinet médical, cabinet de notaire ou autre service",null,1,"EHm / tranche entamée de 150 m2 de surface"]
[null,"ou :","≤ 10 salariés *",1,"EHm / commerce"]
[null,null,"> 10 salariés *",0.5,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Commerce (sans production) :","≤ 10 salariés *",2.5,"EHm / commerce"]
[null,"Grande surface, épicerie, point de vente alimentaire, magasin, boutique","> 10 salariés *",1.5,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Boucherie, poissonnerie, boulangerie, pâtisserie (site de production avec vente)","≤ 10 salariés *",10,"EHm / commerce"]
[null,null,"> 10 salariés *",6.5,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Salon de coiffure","≤ 10 salariés *",6,"EHm / salon"]
[null,null,"> 10 salariés *",4,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Nettoyage à sec","≤ 10 salariés *",30,"EHm / entreprise"]
[null,null,"> 10 salariés *",20,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Entreprise de transport de marchandises et de construction (avec dépôt)","≤ 10 salariés *",3.5,"EHm / entreprise"]
[null,null,"> 10 salariés *",2.5,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Garage, atelier de réparation de véhicules automoteurs","≤ 10 salariés *",15,"EHm / entreprise"]
[null,null,"> 10 salariés *",10,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Atelier mécanique, vente de pneus","≤ 10 salariés *",5.5,"EHm / entreprise"]
[null,null,"> 10 salariés *",3.5,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Artisanat, menuisier, électricien, carreleur, peintre, plombier, installateur sanitaire, charpentier (avec dépôt)","≤ 10 salariés *",3.5,"EHm / entreprise"]
[null,null,"> 10 salariés *",2.5,"EHm / tranche entamée de 5 personnes occupées"]
[null,"Mazout et combustibles",null,10,"EHm / entreprise"]
[null,"Station service (avec shop)",null,3.5,"EHm / station"]
[null,"Installation de lavage de voitures",null,15,"EHm / installation"]
[null,"Distilleries d’alcool, vinaigrerie",null,0.5,"EHm / tranche entamée de 1000 l d’alcool ou de vinaigre pur produits par an"]
[null,"* Sont pris en compte le salariat et le patronat au 1er janvier de l’année courante."]
[]
[null,"En cas de non occupation des lieux, le consommateur sera taxé d'une charge polluante moyenne annuelle de 2,0 EHm."]
[]
[null,"Le secteur agricole"]
[null,"V : Activités agricoles"]
[null,"Groupe ou activité","Charge polluante moyenne annuelle (EHm)"]
[null,"Laiterie",null,20,"EHm / laiterie"]
[null,"Le secteur industriel"]
[null,"VI : Activités industrielles (« Starkverschmutzer »)"]
[null,"Groupe ou activité","Charge polluante moyenne annuelle (EHm)"]
[null,"Industrie agroalimentaire d'envergure (EHm ≥ 300) :","suivant convention ou mesures"]
[null,"Boucherie, boulangerie, brasserie artisanale, production de boissons, transformation du lait"]
[null,"Autres entreprises et établissements industriels produisant des eaux usées très polluées (EHm ≥ 300)","suivant convention ou mesures"]