{"id":197742,"date":"2023-10-09T08:01:13","date_gmt":"2023-10-09T07:01:13","guid":{"rendered":"https:\/\/learnesy.com\/?p=197742"},"modified":"2023-10-09T11:13:13","modified_gmt":"2023-10-09T10:13:13","slug":"fa-koll-pa-vinterns-elpriser-med-excel","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/fa-koll-pa-vinterns-elpriser-med-excel\/","title":{"rendered":"F\u00e5 koll p\u00e5 vinterns elpriser med Excel!"},"content":{"rendered":"

H\u00e4r laddar du ned filen<\/h2><\/span>\n

\u2192 Tryck h\u00e4r f\u00f6r att h\u00e4mta filen \u2190<\/a><\/p>\n

\n

Ta kontroll \u00f6ver din elanv\u00e4ndning i vinter genom att anv\u00e4nda det vi p\u00e5 Learnesy gillar mest \u2013 Excel! Vill du spara pengar eller bara minska din elkonsumtion, oavsett sk\u00e4l kommer v\u00e5r nedladdningsbara Excel-fil vara till stor hj\u00e4lp!<\/em><\/p>\n

\"\"<\/p>\n

 <\/p>\n

\n

H\u00e4r nedan ses en instruktion f\u00f6r hur man avblockerar filen f\u00f6r att kunna nyttja den.\u00a0<\/em><\/p>\n

\"\"<\/p>\n

\n

Excel-filen i fr\u00e5ga \u00e4r en makroaktiverad<\/em> .xlsm-fil. D\u00e4rf\u00f6r m\u00e5ste man g\u00f6ra som i instruktionen ovan, eller \u00f6ppna filen och l\u00e4sa instruktionen som finns p\u00e5 kalkylbladet ”S\u00e5h\u00e4r avblockerar du filen”.\u00a0<\/em><\/p>\n

Vad \u00e4r ett makro?<\/h2><\/span>\n

Ett makro kan skapas i Excel f\u00f6r att automatisera uppgifter. Man kan spela in ett makro genom att anv\u00e4nda sig av tangenter och musklickningar, eller s\u00e5 kan man skriva koden f\u00f6r makrot med ett programmeringsspr\u00e5k som heter VBA<\/em>.<\/p>\n

Hur g\u00f6r man?<\/h2><\/span>\n

Det som sker i filen i fr\u00e5ga \u00e4r att elpriserna importeras i Excel och sammanfattas i ett diagram. F\u00f6r att importera ny data f\u00f6r den aktuella dagen, tryck p\u00e5 knappen ’Uppdatera eller v\u00e4lj nytt elomr\u00e5de’.\u00a0<\/em>D\u00e4refter v\u00e4ljer du land, omr\u00e5de och valuta.<\/p>\n

\"Bilden<\/p>\n

Vill man se de underliggande siffrorna, kan man skrolla ned n\u00e5got i filen bara. D\u00e4r finns \u00e4ven lite deskriptiv statistik eller m\u00e5tt f\u00f6r den intresserade.<\/p>\n

Valutakurserna h\u00e4mtas fr\u00e5n ECB<\/em>\u00a0och elpriserna fr\u00e5n Nordpool. <\/em>Detta inneb\u00e4r att \u00e4ven valutakurserna uppdateras st\u00e4ndigt i filen.<\/p>\n

Avslutande ord<\/h2><\/span>\n

Vill man l\u00e4ra sig att skapa makron, b\u00f6r man g\u00e5 Learnesys kurs i makron och VBA<\/a>. Eller, om man snarare tror att man beh\u00f6ver mer grundl\u00e4ggande kunskaper inom Excel, finns kursen Excelkurs Bas<\/a>.<\/p>\n

\n

Har man n\u00e5gra tankar kring filen, kan man diskutera dessa i v\u00e5rt forum<\/a>.\u00a0<\/em><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Med Learnesy kan man spara pengar i vinter genom att ladda ned v\u00e5r makroaktiverade Excel-fil inneh\u00e5llande elpriser. <\/p>\n","protected":false},"author":54291,"featured_media":267797,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[],"class_list":["post-197742","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/197742","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=197742"}],"version-history":[{"count":10,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/197742\/revisions"}],"predecessor-version":[{"id":198823,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/197742\/revisions\/198823"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/267797"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=197742"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=197742"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=197742"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}