Vinnerliste

Siden du har MR16 og 12V, er det ikke noe krav om to-polt brudd, men noen bruker det fordet. Jeg hadde tilsvarende der vi bodde før, og brukte da kvalitets-pærer fra Philips med innebygget kjøling som er dimbare, sammen med Elko Zigbee-dimmer med ratt (denne har faktisk to-polt brudd). Jeg har faktisk både dimmer og de pærene enda, si ifra hvis du er interessert så skal du få de billig av meg

Etter ønske om å få rask oversikt i Home Assistant over nye korona-smittede i vår kommune fikk jeg satt opp en flyt i Node-RED som henter og bruker data fra https://www.covid19data.no/ / https://github.com/thohan88/covid19-nor-data (Credits til nevnte). Kode for flyt om noen er interessert: [{"id":"7dd6bce.af8c844","type":"group","z":"bb6e8086.6c545","name":"Covidsensor ","style":{"stroke":"#ff0000","fill":"#ff0000","fill-opacity":"0.15","label":true},"nodes":["90eed3d2.3e261","b0fff39.6d0931","ea569ee3.85a95","b802a2b2.ff655","6a4e5870.ca4be8","c7c59bd.5518268","ef5ccb12.ee96b8","b081c8a7.91d578","386b5ad0.348216","cb51e487.ab1338","ab0d46b0.c3f558","810385c3.3d2c58","b0f32536.4af398","5f09b0de.93084"],"x":74,"y":1639,"w":1752,"h":202},{"id":"90eed3d2.3e261","type":"csv","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"mult","ret":"\\n","temp":"date,date_time,kommune_bydel_no,kommune_bydel_name,bydel_no,bydel_name,kommune_no,kommune_name,fylke_no,fylke_name,population,cases","skip":"0","strings":true,"include_empty_strings":false,"include_null_values":false,"x":550,"y":1680,"wires":[["cb51e487.ab1338"]]},{"id":"b0fff39.6d0931","type":"http request","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Datainnhenting","method":"GET","ret":"txt","paytoqs":"ignore","url":"https://raw.githubusercontent.com/thohan88/covid19-nor-data/master/data/01_infected/msis/municipality_and_district.csv","tls":"","persist":false,"proxy":"","authType":"","x":380,"y":1680,"wires":[["90eed3d2.3e261"]]},{"id":"ea569ee3.85a95","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Caseoutput","func":"let cases = msg.payload.pop().cases;\nmsg.payload = cases;\nmsg.topic = \"Dag0\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1110,"y":1680,"wires":[["ab0d46b0.c3f558","810385c3.3d2c58"]]},{"id":"b802a2b2.ff655","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Datofilter -1","func":"\nvar yesterday = new Date((new Date()).valueOf() - 1000*60*60*24).toISOString();\nu = yesterday.substr(0,10);\nmsg.payload = msg.payload.filter(e => e.date == u);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":910,"y":1740,"wires":[["ef5ccb12.ee96b8"]]},{"id":"6a4e5870.ca4be8","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Datofilter -2","func":"\nvar yesterday = new Date((new Date()).valueOf() - 1000*60*60*48).toISOString();\nu = yesterday.substr(0,10);\nmsg.payload = msg.payload.filter(e => e.date == u);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":910,"y":1800,"wires":[["b081c8a7.91d578"]]},{"id":"c7c59bd.5518268","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Datofilter idag","func":"var t=(new Date()).toISOString();\n//var yyyy=(new Date()).getUTCFullYear();\n//var mm=(new Date()).getUTCMonth();\n//var dd=(new Date()).getUTCDate();\nvar u = t.substr(0,10);\nmsg.payload = msg.payload.filter(e => e.date == u);\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":920,"y":1680,"wires":[["ea569ee3.85a95"]]},{"id":"ef5ccb12.ee96b8","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Caseoutput","func":"let cases = msg.payload.pop().cases;\nmsg.payload = cases;\nmsg.topic = \"Dag1\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1110,"y":1740,"wires":[["ab0d46b0.c3f558","810385c3.3d2c58"]]},{"id":"b081c8a7.91d578","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Caseoutput","func":"let cases = msg.payload.pop().cases;\nmsg.payload = cases;\nmsg.topic = \"Dag2\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1110,"y":1800,"wires":[["ab0d46b0.c3f558"]]},{"id":"386b5ad0.348216","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Økning siste døgn","func":"var a = (msg.payload.Dag0);\nvar b = (msg.payload.Dag1);\nvar siste = a - b;\nmsg.payload = siste;\nmsg.topic = \"Diff\";\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":1530,"y":1680,"wires":[["ab0d46b0.c3f558"]]},{"id":"cb51e487.ab1338","type":"function","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"Kommunefilter","func":"msg.payload = msg.payload.filter(e => e.kommune_name == \"Trondheim\");\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":720,"y":1680,"wires":[["c7c59bd.5518268","b802a2b2.ff655","6a4e5870.ca4be8"]]},{"id":"ab0d46b0.c3f558","type":"join","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"4","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":1550,"y":1800,"wires":[["b0f32536.4af398"]]},{"id":"810385c3.3d2c58","type":"join","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"","mode":"custom","build":"object","property":"payload","propertyType":"msg","key":"topic","joiner":"\\n","joinerType":"str","accumulate":false,"timeout":"","count":"2","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"","reduceFixup":"","x":1330,"y":1680,"wires":[["386b5ad0.348216"]]},{"id":"b0f32536.4af398","type":"ha-entity","z":"bb6e8086.6c545","d":true,"g":"7dd6bce.af8c844","name":"Covidsensor","server":"6ba97421.43379c","version":1,"debugenabled":false,"outputs":1,"entityType":"sensor","config":[{"property":"name","value":"smitte_sted"},{"property":"device_class","value":""},{"property":"icon","value":"mdi:hospital-building"},{"property":"unit_of_measurement","value":"nye smittede"}],"state":"payload.Diff","stateType":"msg","attributes":[{"property":"Dagens smittetall","value":"payload.Dag0","valueType":"msg"},{"property":"Smittetall dag 1","value":"payload.Dag1","valueType":"msg"},{"property":"Smittetall dag 2","value":"payload.Dag2","valueType":"msg"},{"property":"Datakilde","value":"https://raw.githubusercontent.com/thohan88/covid19-nor-data/master/data/01_infected/msis/municipality_and_district.csv","valueType":"str"}],"resend":true,"outputLocation":"","outputLocationType":"none","inputOverride":"allow","outputOnStateChange":false,"outputPayload":"$entity().state ? \"on\": \"off\"","outputPayloadType":"jsonata","x":1730,"y":1800,"wires":[[]]},{"id":"5f09b0de.93084","type":"inject","z":"bb6e8086.6c545","g":"7dd6bce.af8c844","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"45 05 * * *","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":190,"y":1680,"wires":[["b0fff39.6d0931"]]},{"id":"6ba97421.43379c","type":"server","name":"Home Assistant","version":1,"legacy":false,"addon":true,"rejectUnauthorizedCerts":true,"ha_boolean":"y|yes|true|on|home|open","connectionDelay":true,"cacheJson":true}] OBS! Funksjon i funksjonsnode "kommunefilter" må endres med navn på kommune det ønskes data fra i kode, og sensor til HA må etableres etter ønske. Oppsettet over etablerer en sensor i HA som viser nye smittede siste døgn samt det akkumulerte antallet smittede som er registrert de siste 3 dagene. Flyten kunne helt sikkert vært bedre, men til å være en bygg-mann er jeg fornøyd med resultatet

Husk at du også kan få 15000kr i støtte til balansert ventilasjonsanlegg: https://www.enova.no/privat/alle-energitiltak/oppgradere-huset/balansert-ventilasjon/