{"action":"opened","issue":{"url":"https://api.github.com/repos/quintel/etmodel/issues/1927","labels_url":"https://api.github.com/repos/quintel/etmodel/issues/1927/labels{/name}","comments_url":"https://api.github.com/repos/quintel/etmodel/issues/1927/comments","events_url":"https://api.github.com/repos/quintel/etmodel/issues/1927/events","html_url":"https://github.com/quintel/etmodel/issues/1927","id":109072461,"number":1927,"title":"Improve investments table 2: decide on method to prevent double counting and implement ","user":{"login":"AlexanderWirtz","id":308563,"avatar_url":"https://avatars.githubusercontent.com/u/308563?v=3","gravatar_id":"","url":"https://api.github.com/users/AlexanderWirtz","html_url":"https://github.com/AlexanderWirtz","followers_url":"https://api.github.com/users/AlexanderWirtz/followers","following_url":"https://api.github.com/users/AlexanderWirtz/following{/other_user}","gists_url":"https://api.github.com/users/AlexanderWirtz/gists{/gist_id}","starred_url":"https://api.github.com/users/AlexanderWirtz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlexanderWirtz/subscriptions","organizations_url":"https://api.github.com/users/AlexanderWirtz/orgs","repos_url":"https://api.github.com/users/AlexanderWirtz/repos","events_url":"https://api.github.com/users/AlexanderWirtz/events{/privacy}","received_events_url":"https://api.github.com/users/AlexanderWirtz/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-09-30T11:59:19Z","updated_at":"2015-09-30T11:59:19Z","closed_at":null,"body":"As @ChaelKruip and I agreed the improvements to the 'Investments for heat and electricity production' table have been split into two issues. This one deals with the double counting of heaters and water heaters (and cooling).\r\n\r\n## Intro\r\nThe table is confusing, because the total costs listed at the bottom do not add up to the same number as the row items listed. Some technologies can be used for space heating and making hot water, and others even for cooling as well. Since these are separate converters, they are listed separately in the investments table, but that leads to an overestimation of actual investment costs. \r\n\r\n## Solution\r\nJohn @ChaelKruip and I agreed for now to use the following method:\r\n\r\n1. List each combi or heat pump technology only once, instead of two to three times\r\n2. Use the investment costs number which is highest. As follows:\r\n    1. Households: assume the investments in heat pumps (other than AC) for cooling are 0, IFF the corresponding heating / hot water heat pumps have investments > 0.\r\n    1. Households: use the highest of the investments for space heating and hot water for each technology\r\n    1. Buildings: use the highest of the investments for space heating and cooling for each technology\r\n3. For total costs, just add up all costs of the line items in the table.\r\n\r\nAlso see #1926 \r\n\r\nThis issue is also relevant for the `Total cost` item in the dashboard, which currently calculates *average* costs for heat pumps. The impact of the suggested cost calculation method should be checked on these costs. "}}