{"id":7144,"date":"2024-05-16T01:00:24","date_gmt":"2024-05-15T22:00:24","guid":{"rendered":"https:\/\/e-circular.org\/?page_id=7144"},"modified":"2024-06-01T15:17:31","modified_gmt":"2024-06-01T12:17:31","slug":"excel-plgd-si-tarife","status":"publish","type":"page","link":"https:\/\/e-circular.org\/en\/excel-plgd-si-tarife\/","title":{"rendered":"Excel PLGD and rates"},"content":{"rendered":"<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/e-circular.org\/wp-content\/uploads\/2024\/03\/prima-pagina.png\" alt=\"\" class=\"wp-image-1480\"\/><\/figure>\n\n\n\n<p class=\"has-text-align-left\">The EXCEL module for the development of local waste management programs and tariff calculation for public waste management services is developed by the E-Circular Training and Consulting Center within <a href=\"https:\/\/e-circular.org\/en\/proiect\/imbunatatirea-competentelor-digitale\/\">project <strong>&quot;Improving LPA&#039;s digital and green skills for better waste planning and management<\/strong>&quot;<\/a> implemented with the financial support of <strong>to the Austrian Development Agency (ADA), from the funds of the Austrian Development Cooperation (ADC).<\/strong><\/p>\n\n\n\n<p>The online module facilitates the calculation of sanitation tariffs and the development of local waste management programs, offering digital support for mayors, deputy mayors, municipal sanitation operator employees, accountants, other people involved in waste management planning activities.<\/p>\n\n\n<style>.wp-block-kadence-spacer.kt-block-spacer-7144_0f7483-e3 .kt-block-spacer{height:20px;}.wp-block-kadence-spacer.kt-block-spacer-7144_0f7483-e3 .kt-divider{border-top-width:1px;height:1px;border-top-color:#eee;width:80%;border-top-style:solid;}<\/style>\n<div class=\"wp-block-kadence-spacer aligncenter kt-block-spacer-7144_0f7483-e3\"><div class=\"kt-block-spacer kt-block-spacer-halign-center\"><\/div><\/div>\n\n\n<style>.kt-accordion-id8867_3262b0-dd .kt-accordion-inner-wrap{column-gap:var(--global-kb-gap-md, 2rem);row-gap:0px;}.kt-accordion-id8867_3262b0-dd .kt-accordion-panel-inner{border-top:0px solid transparent;border-right:0px solid transparent;border-bottom:0px solid transparent;border-left:0px solid transparent;padding-top:0px;padding-right:var(--global-kb-spacing-sm, 1.5rem);padding-bottom:var(--global-kb-spacing-sm, 1.5rem);padding-left:0px;}.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;border-top-left-radius:0px;border-top-right-radius:0px;border-bottom-right-radius:0px;border-bottom-left-radius:0px;background:rgba(231,231,231,0);font-size:19px;line-height:1.5;font-family:-apple-system,BlinkMacSystemFont,\"Segoe UI\",Roboto,Oxygen-Sans,Ubuntu,Cantarell,\"Helvetica Neue\",sans-serif, \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\";color:#1a1b1c;padding-top:18px;padding-right:0px;padding-bottom:18px;padding-left:0px;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle )  > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap .kt-blocks-accordion-icon-trigger:after, .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle )  > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap .kt-blocks-accordion-icon-trigger:before{background:#1a1b1c;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basic ):not( .kt-accodion-icon-style-xclose ):not( .kt-accodion-icon-style-arrow ) .kt-blocks-accordion-icon-trigger{background:#1a1b1c;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basic ):not( .kt-accodion-icon-style-xclose ):not( .kt-accodion-icon-style-arrow ) .kt-blocks-accordion-icon-trigger:after, .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basic ):not( .kt-accodion-icon-style-xclose ):not( .kt-accodion-icon-style-arrow ) .kt-blocks-accordion-icon-trigger:before{background:rgba(231,231,231,0);}.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header:hover, \n\t\t\t\tbody:not(.hide-focus-outline) .kt-accordion-id8867_3262b0-dd .kt-blocks-accordion-header:focus-visible{color:#000000;border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle ) .kt-accordion-header-wrap .kt-blocks-accordion-header:hover .kt-blocks-accordion-icon-trigger:after, .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle ) .kt-accordion-header-wrap .kt-blocks-accordion-header:hover .kt-blocks-accordion-icon-trigger:before, body:not(.hide-focus-outline) .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle ) .kt-blocks-accordion--visible .kt-blocks-accordion-icon-trigger:after, body:not(.hide-focus-outline) .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle ) .kt-blocks-accordion-header:focus-visible .kt-blocks-accordion-icon-trigger:before{background:#000000;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basic ):not( .kt-accodion-icon-style-xclose ):not( .kt-accodion-icon-style-arrow ) .kt-accordion-header-wrap .kt-blocks-accordion-header:hover .kt-blocks-accordion-icon-trigger, body:not(.hide-focus-outline) .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basic ):not( .kt-accodion-icon-style-xclose ):not( .kt-accodion-icon-style-arrow ) .kt-accordion-header-wrap .kt-blocks-accordion-header:focus-visible .kt-blocks-accordion-icon-trigger{background:#000000;}.kt-accordion-id8867_3262b0-dd .kt-accordion-header-wrap .kt-blocks-accordion-header:focus-visible,\n\t\t\t\t.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header.kt-accordion-panel-active{color:#000000;border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle )  > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header.kt-accordion-panel-active .kt-blocks-accordion-icon-trigger:after, .kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basiccircle ):not( .kt-accodion-icon-style-xclosecircle ):not( .kt-accodion-icon-style-arrowcircle )  > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header.kt-accordion-panel-active .kt-blocks-accordion-icon-trigger:before{background:#000000;}.kt-accordion-id8867_3262b0-dd:not( .kt-accodion-icon-style-basic ):not( .kt-accodion-icon-style-xclose ):not( .kt-accodion-icon-style-arrow ) .kt-blocks-accordion-header.kt-accordion-panel-active .kt-blocks-accordion-icon-trigger{background:#000000;}@media all and (max-width: 1024px){.kt-accordion-id8867_3262b0-dd .kt-accordion-panel-inner{border-top:0px solid transparent;border-right:0px solid transparent;border-bottom:0px solid transparent;border-left:0px solid transparent;}}@media all and (max-width: 1024px){.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;font-size:18px;}}@media all and (max-width: 1024px){.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header:hover, \n\t\t\t\tbody:not(.hide-focus-outline) .kt-accordion-id8867_3262b0-dd .kt-blocks-accordion-header:focus-visible{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}}@media all and (max-width: 1024px){.kt-accordion-id8867_3262b0-dd .kt-accordion-header-wrap .kt-blocks-accordion-header:focus-visible,\n\t\t\t\t.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header.kt-accordion-panel-active{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}}@media all and (max-width: 767px){.kt-accordion-id8867_3262b0-dd .kt-accordion-inner-wrap{display:block;}.kt-accordion-id8867_3262b0-dd .kt-accordion-inner-wrap .kt-accordion-pane:not(:first-child){margin-top:0px;}.kt-accordion-id8867_3262b0-dd .kt-accordion-panel-inner{border-top:0px solid transparent;border-right:0px solid transparent;border-bottom:0px solid transparent;border-left:0px solid transparent;}.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header:hover, \n\t\t\t\tbody:not(.hide-focus-outline) .kt-accordion-id8867_3262b0-dd .kt-blocks-accordion-header:focus-visible{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}.kt-accordion-id8867_3262b0-dd .kt-accordion-header-wrap .kt-blocks-accordion-header:focus-visible,\n\t\t\t\t.kt-accordion-id8867_3262b0-dd > .kt-accordion-inner-wrap > .wp-block-kadence-pane > .kt-accordion-header-wrap > .kt-blocks-accordion-header.kt-accordion-panel-active{border-top:1px solid #adb2b3;border-right:0px solid #adb2b3;border-bottom:0px solid #adb2b3;border-left:0px solid #adb2b3;}}<\/style>\n<div class=\"wp-block-kadence-accordion alignnone\"><div class=\"kt-accordion-wrap kt-accordion-id8867_3262b0-dd kt-accordion-has-13-panes kt-active-pane-0 kt-accordion-block kt-pane-header-alignment-left kt-accodion-icon-style-arrow kt-accodion-icon-side-right\" style=\"max-width:none\"><div class=\"kt-accordion-inner-wrap\" data-allow-multiple-open=\"false\" data-start-open=\"0\">\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-2 kt-pane8867_677352-65\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\"><strong>The Excel tool<\/strong><\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p><strong>The &quot;Excel module for the development of local waste management programs and tariff calculation for public waste management services&quot; allows the user to<\/strong>:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Collect and organize data on the types of waste generated in a community, the quantities generated, the frequency of collection and other relevant information.<\/li>\n\n\n\n<li>Calculate the costs involved in waste management using Excel formulas and functions.<\/li>\n\n\n\n<li>Establish rates for public waste management services.<\/li>\n\n\n\n<li>Develops Local Waste Management Programs, i.e. uses EXCEL spreadsheets to set goals, deadlines and responsibilities for various aspects of waste management in the community.<\/li>\n\n\n\n<li>Analyze data, including charts and graphs, and visualize trends in waste generation and associated costs, which can help make informed decisions about waste management.<\/li>\n\n\n\n<li>Create reports and documents that present important information related to waste management in the community.<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/e-circular.org\/wp-content\/uploads\/2023\/10\/PLGD-calcul-tarife.xlsx\" data-type=\"link\" data-id=\"https:\/\/old.e-circular.org\/wp-content\/uploads\/2023\/10\/PLGD-calcul-tarife.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">Downloads<\/a> EXCEL MODULE - Calculation of sanitation tariffs and PLGD elaboration, or access <a href=\"https:\/\/managementuldeseurilor-my.sharepoint.com\/:x:\/g\/personal\/roman_e-circular_org\/Eek4enqdcwZPtSvGDM9lXj4BaeMnSsDE2u1ftEzAzBxHvw?rtime=YkAMjf7K20g\" data-type=\"link\" data-id=\"https:\/\/managementuldeseurilor-my.sharepoint.com\/:x:\/g\/personal\/roman_e-circular_org\/Eek4enqdcwZPtSvGDM9lXj4BaeMnSsDE2u1ftEzAzBxHvw?rtime=YkAMjf7K20g\" target=\"_blank\" rel=\"noopener\">online version<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/e-circular.org\/wp-content\/uploads\/2023\/10\/GHID-utilizare-modul-Excel.pdf\" data-type=\"link\" data-id=\"https:\/\/old.e-circular.org\/wp-content\/uploads\/2023\/10\/GHID-utilizare-modul-Excel.pdf\">Downloads<\/a> Excel mode usage guide<\/li>\n<\/ul>\n<\/div><\/div><\/div>\n\n\n\n<div class=\"wp-block-kadence-pane kt-accordion-pane kt-accordion-pane-1 kt-pane8867_7b13f8-28\"><div class=\"kt-accordion-header-wrap\"><button class=\"kt-blocks-accordion-header kt-acccordion-button-label-show\"><span class=\"kt-blocks-accordion-title-wrap\"><span class=\"kt-blocks-accordion-title\"><strong>Legal aspects<\/strong><\/span><\/span><span class=\"kt-blocks-accordion-icon-trigger\"><\/span><\/button><\/div><div class=\"kt-accordion-panel kt-accordion-panel-hidden\"><div class=\"kt-accordion-panel-inner\">\n<p>The EXCEL module is a useful tool for LPAs, development agencies, municipal\/regional waste management operators, NGOs, contractors and any public or private organizations interested in understanding waste flows within municipal solid waste management systems and to ensure compliance with at least the following provisions\/normative acts:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.legis.md\/cautare\/getResults?doc_id=135007&amp;lang=ro\" target=\"_blank\" rel=\"noopener\">HGnr.881\/2022 for the approval of the Methodology regarding the calculation of tariffs for some public municipal waste management services<\/a><\/li>\n\n\n\n<li>art. 35. para. (2) of Law 209\/2016 on waste<em> &quot;Based on the National Waste Management Program, local public administration authorities develop local waste management programs in accordance with this law.&quot;<\/em><\/li>\n\n\n\n<li>Methodological guide for the development of Local Waste Management Programs (in the approval process) <a href=\"https:\/\/particip.gov.md\/ro\/document\/stages\/anuntprivind-organizarea-consultarii-publice-asupra-proiectului-de-ordin-pentru-aprobarea-ghidului-metodologic-de-elaborare-a-programelor-locale-de-gestionare-a-deseurilor-ghid-plgd\/10834\" target=\"_blank\" rel=\"noopener\">NOTICE regarding the organization of the public consultation on the draft Order for the approval of the Methodological Guide for the development of local waste management programs (PLGD Guide) | Particip.gov.md<\/a><\/li>\n<\/ul>\n<\/div><\/div><\/div>\n<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Modulul EXCEL pentru elaborarea Programelor locale de gestionare de\u0219euri \u0219i calcul tarife pentru serviciile publice de gestionare a de\u0219eurilor este elaborat de A.O. Centrul de instruire \u0219i consultan\u021b\u0103 E-Circular \u00een cadrul Proiectului \u201e\u00cembun\u0103t\u0103\u021birea competen\u021belor digitale \u0219i ecologice ale APL pentru o mai bun\u0103 planificare \u0219i gestionare a de\u0219eurilor\u201d implementat cu suportul financiar al Agen\u021biei Austriece [&hellip;]<\/p>","protected":false},"author":1,"featured_media":7145,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","footnotes":""},"class_list":["post-7144","page","type-page","status-publish","has-post-thumbnail","hentry"],"acf":[],"taxonomy_info":[],"featured_image_src_large":["https:\/\/e-circular.org\/wp-content\/uploads\/2024\/05\/Excel-PLGD-si-tarife.png",800,439,false],"author_info":{"display_name":"e-circular","author_link":"https:\/\/e-circular.org\/en\/author\/e-circular\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/pages\/7144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/comments?post=7144"}],"version-history":[{"count":0,"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/pages\/7144\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/media\/7145"}],"wp:attachment":[{"href":"https:\/\/e-circular.org\/en\/wp-json\/wp\/v2\/media?parent=7144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}