{"id":464,"date":"2024-02-09T14:37:31","date_gmt":"2024-02-09T13:37:31","guid":{"rendered":"https:\/\/daik.nl\/?p=464"},"modified":"2024-04-09T13:27:26","modified_gmt":"2024-04-09T12:27:26","slug":"read-energy-consumption-balance-with-domoticz","status":"publish","type":"post","link":"https:\/\/daik.nl\/?p=464","title":{"rendered":"Read energy consumption balance with Domoticz"},"content":{"rendered":"\n

Manual for setting up a meter for netting with Domoticz.<\/p>\n\n\n\n

Netting and Domoticz<\/h2>\n\n\n\n

Domoticz is an ideal tool to read your energy meter. If you have solar panels, it is very useful if you can read your balance of consumption and return. This balance determines whether you still have to pay extra or get something back. You want to offset the electricity generated in the summer with the consumption in the winter. With this balance you can see whether you are still in the right position and whether you are not using too much.<\/p>\n\n\n\n

By default you do not have a meter for netting with Domoticz. In this article I will show you how to create this.<\/p>\n\n\n\n

The condition is that you have already connected a P1 kabel<\/a>\u00a0 to your Raspberry and have Domoticz running on it. You can read how to do this in https:\/\/daik.nl\/index.php\/nl\/2024\/01\/22\/zelf-meterstanden-uitlezen-met-raspberry\/<\/a><\/p>\n\n\n\n

Create Hardware<\/h3>\n\n\n\n

To start, you need to create a new Dummy hardware under Setup\/Hardware, I have called it “Smartmeter”:<\/p>\n\n\n\n

\"Create<\/figure>\n\n\n\n

If you have clicked on Add, you can now add a device under the hardware overview:<\/p>\n\n\n\n

\"Create<\/figure>\n\n\n\n

Name this: Balance and usage Sensor Type: Managed counter<\/p>\n\n\n\n

Use this name, it is necessary for the script<\/p>\n\n\n\n

\"saldo<\/figure>\n\n\n\n

Create script<\/h3>\n\n\n\n

Go to Setup \/ More Options \/ Events:<\/p>\n\n\n\n

Click the + , to create a new script, Select dzVents\/Timer:<\/p>\n\n\n\n

\"create<\/figure>\n\n\n\n

copy the script below over the existing text, or first remove all text from the old script, so that only this new script remains:<\/p>\n\n\n\n

local startUsageLow = 3475000      \r\nlocal startUsageHigh = 5716000    \r\nlocal startReturnLow = 30000     \r\nlocal startReturnHigh = 78000    \r\n\r\nlocal fetchIntervalMins = 1    --   1 = every minute, 10 = every 10 minutes, etc.)\r\n\r\nreturn {\r\n    on =      {\r\n                        timer = { 'every ' .. fetchIntervalMins .. ' minutes' }\r\n              },\r\n             \r\n    logging = {\r\n                         level = domoticz.LOG_DEBUG, domoticz.LOG_INFO,  \r\n                         marker = 'Separate meter readings '\r\n              },\r\n\r\n    execute = function(dz, item)\r\n\r\n        local P1  = dz.devices('Power') -- Electra, P1 Smart Meter device (idx or \"name\") (required)\r\n        local sumSaldoHigh = (P1.return2 - startReturnHigh) - (P1.usage2 - startUsageHigh)\r\n        local sumSaldoLow = (P1.return1 - startReturnLow) - (P1.usage1 - startUsageLow)\r\n        local sumSaldo = sumSaldoHigh + sumSaldoLow\r\n\r\n        dz.log('Saldo Hoog      : ' ..sumSaldoHigh, dz.LOG_INFO)\r\n        dz.log('Saldo Laag       : ' ..sumSaldoLow, dz.LOG_INFO)\r\n        dz.log('Saldo Totaal    : ' ..sumSaldo, dz.LOG_INFO)\r\n        \r\n        dz.devices('Saldo').updateCounter(sumSaldo)\r\n\r\n     end\r\n}\r\n\r\n-- einde Script<\/code><\/pre>\n\n\n\n
Within the script, the following must be replaced with the values that apply to you:<\/p>\n\n\n\n
local startUsageLow = 3475000<\/p>\n\n\n\n
local startUsageHigh = 5716000<\/p>\n\n\n\n
local startReturnLow = 30000<\/p>\n\n\n\n
local startReturnHigh = 78000<\/p>\n\n\n\n
You enter the meter readings there from the moment you want to settle, which will probably be the last measurement at the last settlement. You should be able to find those meter readings on your bill. You must enter the readings in Watt hours, so if your bill shows 3475 kWh, enter 3475000.<\/p>\n\n\n\n
This script takes the high and low rates into account (so-called weekend rates). If you do not use that, you can enter 0 for startUsageHigh and startReturnHigh. These will have no further influence on the calculation.<\/p>\n\n\n\n
Furthermore, it says “local fetchIntervalMins = 1”. This is useful for running the script for the first time, because then you can see every minute whether it is going well. If the script is running I would change that to 30, then the balance is changed every half hour, that seems sufficient to me.<\/p>\n\n\n\n
Check the operation of the netting script<\/h3>\n\n\n\n
Save the script and go to the log to see if your script works properly. A properly functioning script results in this logging:<\/p>\n\n\n\n
2024-02-07 21:04:00.295 Status: dzVents: Info: Separate meter readings : Saldo Hoog : 247671
2024-02-07 21:04:00.295 Status: dzVents: Info: Separate meter readings : Saldo Laag : 57073
2024-02-07 21:04:00.295 Status: dzVents: Info: Separate meter readings : Saldo Totaal : 304744
2024-02-07 21:04:00.296 Status: dzVents: Debug: Separate meter readings : Processing device-adapter for Saldo: Counter device adapter
2024-02-07 21:04:00.296 Status: dzVents: Info: Separate meter readings : ------ Finished SaldoPower<\/code><\/p>\n\n\n\n
Naturally, the values will differ from what you encounter.<\/p>\n\n\n\n
You will now also see a new card in Utility, which looks like this:<\/p>\n\n\n\n
\"Netting<\/figure>\n\n\n\n
This will now be neatly maintained. If you put it on your dashboard (turn the asterisk yellow) you will no longer be able to miss it.<\/p>\n\n\n\n
After the settlement, you simply enter the new values in the script and you can continue for another year.<\/p>\n\n\n\n
If you find any errors in this article, or just want to leave some comments, please create a comment below.<\/p>\n","protected":false},"excerpt":{"rendered":"
Manual for setting up a meter for netting with Domoticz. Netting and Domoticz Domoticz is an ideal tool to read your energy meter. If you have solar panels, it is very useful if you can read your balance of consumption and return. This balance determines whether you still have to pay extra or get something […]<\/p>\n","protected":false},"author":1,"featured_media":442,"comment_status":"open","ping_status":"open","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"footnotes":""},"categories":[5,4],"tags":[11,9,24],"class_list":["post-464","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-domoticz","category-raspberry","tag-domoticz","tag-raspberry","tag-snelle-handleiding"],"yoast_head":"\nRead energy consumption balance with Domoticz - DAIK<\/title>\n<meta name=\"description\" content=\"Read energie consumption balance with Domoticz. This manual will help you create an extra counter to read off netting with Domoticz\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/daik.nl\/?p=464\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Read energy consumption balance with Domoticz - DAIK\" \/>\n<meta property=\"og:description\" content=\"Read energie consumption balance with Domoticz. This manual will help you create an extra counter to read off netting with Domoticz\" \/>\n<meta property=\"og:url\" content=\"https:\/\/daik.nl\/?p=464\" \/>\n<meta property=\"og:site_name\" content=\"DAIK\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-09T13:37:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-09T12:27:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png\" \/>\n\t<meta property=\"og:image:width\" content=\"592\" \/>\n\t<meta property=\"og:image:height\" content=\"236\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"daik01\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"daik01\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/daik.nl\/?p=464#article\",\"isPartOf\":{\"@id\":\"https:\/\/daik.nl\/?p=464\"},\"author\":{\"name\":\"daik01\",\"@id\":\"https:\/\/daik.nl\/#\/schema\/person\/519bc4684d9c8c0cec1a6caa9b65412a\"},\"headline\":\"Read energy consumption balance with Domoticz\",\"datePublished\":\"2024-02-09T13:37:31+00:00\",\"dateModified\":\"2024-04-09T12:27:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/daik.nl\/?p=464\"},\"wordCount\":532,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/daik.nl\/#organization\"},\"image\":{\"@id\":\"https:\/\/daik.nl\/?p=464#primaryimage\"},\"thumbnailUrl\":\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png\",\"keywords\":[\"domoticz\",\"raspberry\",\"snelle handleiding\"],\"articleSection\":[\"Domoticz\",\"Raspberry\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/daik.nl\/?p=464#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/daik.nl\/?p=464\",\"url\":\"https:\/\/daik.nl\/?p=464\",\"name\":\"Read energy consumption balance with Domoticz - DAIK\",\"isPartOf\":{\"@id\":\"https:\/\/daik.nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/daik.nl\/?p=464#primaryimage\"},\"image\":{\"@id\":\"https:\/\/daik.nl\/?p=464#primaryimage\"},\"thumbnailUrl\":\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png\",\"datePublished\":\"2024-02-09T13:37:31+00:00\",\"dateModified\":\"2024-04-09T12:27:26+00:00\",\"description\":\"Read energie consumption balance with Domoticz. This manual will help you create an extra counter to read off netting with Domoticz\",\"breadcrumb\":{\"@id\":\"https:\/\/daik.nl\/?p=464#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/daik.nl\/?p=464\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/daik.nl\/?p=464#primaryimage\",\"url\":\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png\",\"contentUrl\":\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png\",\"width\":592,\"height\":236,\"caption\":\"saldo saldering domoticz\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/daik.nl\/?p=464#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/daik.nl\/?lang=nl\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Read energy consumption balance with Domoticz\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/daik.nl\/#website\",\"url\":\"https:\/\/daik.nl\/\",\"name\":\"DAIK\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/daik.nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/daik.nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/daik.nl\/#organization\",\"name\":\"DAIK\",\"url\":\"https:\/\/daik.nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/daik.nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/01\/logo.png\",\"contentUrl\":\"https:\/\/daik.nl\/wp-content\/uploads\/2024\/01\/logo.png\",\"width\":576,\"height\":600,\"caption\":\"DAIK\"},\"image\":{\"@id\":\"https:\/\/daik.nl\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/daik.nl\/#\/schema\/person\/519bc4684d9c8c0cec1a6caa9b65412a\",\"name\":\"daik01\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/daik.nl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1d92ef146a58720c38ca892f2c6e166e850669a89d08af16f01ec96c118e7000?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1d92ef146a58720c38ca892f2c6e166e850669a89d08af16f01ec96c118e7000?s=96&d=identicon&r=g\",\"caption\":\"daik01\"},\"sameAs\":[\"http:\/\/daik.nl\"],\"url\":\"https:\/\/daik.nl\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Read energy consumption balance with Domoticz - DAIK","description":"Read energie consumption balance with Domoticz. This manual will help you create an extra counter to read off netting with Domoticz","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/daik.nl\/?p=464","og_locale":"en_US","og_type":"article","og_title":"Read energy consumption balance with Domoticz - DAIK","og_description":"Read energie consumption balance with Domoticz. This manual will help you create an extra counter to read off netting with Domoticz","og_url":"https:\/\/daik.nl\/?p=464","og_site_name":"DAIK","article_published_time":"2024-02-09T13:37:31+00:00","article_modified_time":"2024-04-09T12:27:26+00:00","og_image":[{"width":592,"height":236,"url":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png","type":"image\/png"}],"author":"daik01","twitter_card":"summary_large_image","twitter_misc":{"Written by":"daik01","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/daik.nl\/?p=464#article","isPartOf":{"@id":"https:\/\/daik.nl\/?p=464"},"author":{"name":"daik01","@id":"https:\/\/daik.nl\/#\/schema\/person\/519bc4684d9c8c0cec1a6caa9b65412a"},"headline":"Read energy consumption balance with Domoticz","datePublished":"2024-02-09T13:37:31+00:00","dateModified":"2024-04-09T12:27:26+00:00","mainEntityOfPage":{"@id":"https:\/\/daik.nl\/?p=464"},"wordCount":532,"commentCount":0,"publisher":{"@id":"https:\/\/daik.nl\/#organization"},"image":{"@id":"https:\/\/daik.nl\/?p=464#primaryimage"},"thumbnailUrl":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png","keywords":["domoticz","raspberry","snelle handleiding"],"articleSection":["Domoticz","Raspberry"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/daik.nl\/?p=464#respond"]}]},{"@type":"WebPage","@id":"https:\/\/daik.nl\/?p=464","url":"https:\/\/daik.nl\/?p=464","name":"Read energy consumption balance with Domoticz - DAIK","isPartOf":{"@id":"https:\/\/daik.nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/daik.nl\/?p=464#primaryimage"},"image":{"@id":"https:\/\/daik.nl\/?p=464#primaryimage"},"thumbnailUrl":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png","datePublished":"2024-02-09T13:37:31+00:00","dateModified":"2024-04-09T12:27:26+00:00","description":"Read energie consumption balance with Domoticz. This manual will help you create an extra counter to read off netting with Domoticz","breadcrumb":{"@id":"https:\/\/daik.nl\/?p=464#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/daik.nl\/?p=464"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/daik.nl\/?p=464#primaryimage","url":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png","contentUrl":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/02\/2024-02-08_08-15-53.png","width":592,"height":236,"caption":"saldo saldering domoticz"},{"@type":"BreadcrumbList","@id":"https:\/\/daik.nl\/?p=464#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/daik.nl\/?lang=nl"},{"@type":"ListItem","position":2,"name":"Read energy consumption balance with Domoticz"}]},{"@type":"WebSite","@id":"https:\/\/daik.nl\/#website","url":"https:\/\/daik.nl\/","name":"DAIK","description":"","publisher":{"@id":"https:\/\/daik.nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/daik.nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/daik.nl\/#organization","name":"DAIK","url":"https:\/\/daik.nl\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/daik.nl\/#\/schema\/logo\/image\/","url":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/01\/logo.png","contentUrl":"https:\/\/daik.nl\/wp-content\/uploads\/2024\/01\/logo.png","width":576,"height":600,"caption":"DAIK"},"image":{"@id":"https:\/\/daik.nl\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/daik.nl\/#\/schema\/person\/519bc4684d9c8c0cec1a6caa9b65412a","name":"daik01","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/daik.nl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1d92ef146a58720c38ca892f2c6e166e850669a89d08af16f01ec96c118e7000?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1d92ef146a58720c38ca892f2c6e166e850669a89d08af16f01ec96c118e7000?s=96&d=identicon&r=g","caption":"daik01"},"sameAs":["http:\/\/daik.nl"],"url":"https:\/\/daik.nl\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/posts\/464","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/daik.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=464"}],"version-history":[{"count":1,"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/posts\/464\/revisions"}],"predecessor-version":[{"id":467,"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/posts\/464\/revisions\/467"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/daik.nl\/index.php?rest_route=\/wp\/v2\/media\/442"}],"wp:attachment":[{"href":"https:\/\/daik.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=464"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/daik.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=464"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/daik.nl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=464"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}