{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blad1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Blad1","index":0,"n_rows":343,"n_cols":13,"rows_kept":343,"cut":false,"hidden":false,"merged":[[282,0,283,0],[168,0,168,3],[172,0,172,7],[173,0,173,6],[175,0,175,7],[176,0,176,7],[255,0,255,2],[256,0,256,2],[257,0,257,2],[258,0,258,2],[259,0,259,2],[261,6,261,7],[261,0,261,2],[260,0,260,5],[240,6,240,7],[241,0,241,5],[242,0,242,5],[244,0,244,5],[44,0,44,5],[99,1,99,3],[100,1,100,3],[243,0,243,1],[198,1,198,3],[94,1,94,3],[95,1,95,3],[96,1,96,3],[268,0,270,0],[229,0,229,3],[221,6,221,7],[192,4,192,5],[127,5,127,7],[127,2,127,4],[126,0,126,7],[179,4,179,5],[180,4,180,5],[179,0,179,3],[180,0,180,3],[178,0,178,7],[225,0,225,3],[226,0,226,3],[227,0,227,3],[202,6,202,7],[204,0,204,3],[271,1,271,4],[249,0,249,6],[250,0,250,6],[246,0,246,7],[268,1,268,4],[201,0,201,7],[210,0,210,7],[215,0,215,3],[216,0,216,3],[214,0,214,3],[213,0,213,3],[212,0,212,3],[218,0,218,3],[202,0,202,3],[203,0,203,3],[202,4,202,5],[237,0,237,5],[239,0,239,5],[240,0,240,5],[233,0,233,5],[243,2,243,5],[234,0,234,5],[252,0,252,7],[253,4,253,5],[235,0,235,5],[236,0,236,5],[272,1,272,4],[269,1,269,4],[282,1,282,5],[205,0,205,3],[220,0,220,7],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[163,0,163,3],[164,0,164,3],[167,0,167,3],[169,0,169,3],[54,0,54,1],[63,4,63,5],[63,0,63,1],[53,0,53,1],[53,2,53,3],[53,6,53,7],[64,0,64,1],[64,4,64,5],[197,0,197,3],[247,0,247,6],[248,0,248,6],[2,0,2,7],[7,3,7,4],[7,5,7,6],[6,0,6,4],[6,5,6,6],[14,0,14,6],[15,1,15,6],[30,0,30,7],[28,0,28,7],[29,0,29,5],[25,0,25,7],[26,0,26,7],[3,5,3,6],[4,1,4,7],[11,0,11,2],[11,3,11,7],[9,0,9,2],[9,3,9,7],[12,3,12,7],[46,0,46,7],[47,0,47,7],[43,0,43,7],[19,0,19,5],[20,0,20,5],[87,6,87,7],[88,0,88,3],[38,0,38,7],[39,0,39,1],[40,0,40,1],[41,0,41,1],[39,4,39,5],[40,4,40,5],[41,4,41,5],[68,0,68,3],[65,0,65,3],[60,2,60,7],[60,0,60,1],[84,0,84,7],[85,4,85,5],[32,0,32,1],[33,0,33,1],[34,0,34,1],[77,0,77,3],[81,0,81,7],[31,2,31,3],[31,6,31,7],[101,1,101,3],[103,1,103,3],[104,1,104,3],[105,1,105,3],[183,0,183,3],[184,0,184,3],[111,1,111,3],[112,1,112,3],[108,1,108,3],[109,1,109,3],[162,0,162,3],[117,1,117,3],[102,1,102,3],[118,1,118,3],[97,1,97,3],[87,0,87,3],[82,0,82,1],[82,2,82,7],[85,0,85,1],[86,0,86,1],[86,4,86,5],[79,0,79,3],[78,0,78,3],[0,0,0,7],[161,0,161,7],[89,0,89,3],[90,0,90,3],[10,0,10,1],[61,0,61,7],[83,0,83,7],[10,3,10,7],[98,1,98,3],[35,0,35,1],[31,0,31,1],[50,0,50,7],[120,1,120,3],[121,1,121,3],[122,1,122,3],[123,1,123,3],[56,0,56,7],[62,0,62,7],[66,0,66,3],[67,0,67,3],[115,1,115,3],[116,1,116,3],[119,1,119,3],[110,1,110,3],[50,10,50,11],[50,12,50,13],[65,4,65,5],[65,6,65,7],[93,4,93,5],[51,0,51,7],[52,0,52,7],[93,1,93,3],[74,4,74,5],[72,0,72,7],[71,0,71,1],[71,2,71,7],[70,0,70,7],[92,0,92,7],[93,6,93,7],[87,4,87,5],[76,0,76,3],[76,4,76,5],[76,6,76,7],[75,0,75,1],[75,4,75,5],[74,0,74,1],[57,0,57,7],[59,0,59,7],[276,1,276,5],[274,0,274,7],[211,0,211,3],[217,1,217,3],[228,1,228,3],[106,1,106,3],[107,1,107,3],[283,1,283,5],[53,4,53,5],[54,4,54,5],[280,0,281,0],[276,0,278,0],[211,4,211,5],[211,6,211,7],[279,1,279,5],[277,1,277,5],[278,1,278,5],[280,1,280,5],[281,1,281,5],[124,1,124,3],[182,0,182,7],[185,0,185,3],[183,4,183,7],[184,4,184,7],[270,1,270,4],[266,0,266,7],[185,4,185,7],[114,1,114,3],[113,1,113,3],[199,0,199,3],[207,0,207,3],[170,0,170,3],[192,0,192,3],[192,6,192,7],[195,0,195,3],[196,0,196,3],[162,4,162,5],[162,6,162,7],[233,6,233,7],[223,0,223,3],[224,0,224,3],[191,0,191,7],[193,0,193,3],[194,0,194,3],[238,0,238,5],[221,4,221,5],[206,1,206,3],[253,6,253,7]]}
["Energi- och inneklimatberäkning"]
[]
["Projektinformation"]
["Projektnamn:",null,"Projektnummer:",null,null,"Fastighetsbeteckning:"]
["Verksamhet:"]
[]
["Utförare av energiberäkning:",null,null,null,null,"Beräkning utförd i projektskede:",null,"Datum:"]
["Namn:",null,"Företag:",null,null,"< välj >",null,"202x-xx-xx"]
[]
["Bifogade bilagor",null,null,"Filnamn"]
["Indatarapport från energisimuleringsprogram"]
["Köpt energi-rapport från energisimuleringsprogram"]
["Systemenergirapport "]
[]
["Energiberäkning godkänd av stadsfastighetsförvaltningens energisakkunnige:",null,null,null,null,null,null,"Datum:"]
["Namn:",null,null,null,null,null,null,"202x-xx-xx"]
[]
[]
["1. Instruktioner för beräkning och resultatpresentation"]
["Energiberäkning ska utföras och presenteras som två parallella fall:\n\nFall 1 utförs helt enligt BBR och BEN och presenteras som primärenergital (EPpet).\n\nFall 2 ska syfta till att erhålla ett så verklighetsnära utfall som möjligt- och baseras i största möjliga mån på projektspecifik indata. Resultat redovisas som specifik energianvändning.\n\nGula fält ska ifyllas! Förifyllda gula fält får ändras vid behov."]
["Fullständig instruktion återfinns i TKA-dokument \"RA-1843 -Anvisning och indata för energiberäkning\"."]
[]
[]
["2. Indata och förutsättningar"]
[]
["2.1 Kortfattad projektbeskrivning  "]
["…"]
[]
["2.2 U-värden"]
["Byggnadens genomsnittliga värmegenomgångskoefficient (Um)",null,null,null,null,null,null,"W/m², K"]
[]
["Byggnadsdel",null,"U-värde",null,"Byggnadsdel",null,"U-värde"]
["Platta på mark",null,null,"W/m2, K","Fönster",null,null,"W/m2, K"]
["Yttervägg",null,null,"W/m2, K","Dörrar",null,null,"W/m2, K"]
["Yttertak",null,null,"W/m2, K","Portar",null,null,"W/m2, K"]
["Vindsbjälklag",null,null,"W/m2, K","Metallpartier",null,null,"W/m2, K"]
[null,null,null,"W/m2, K",null,null,null,"W/m2, K"]
[]
["2.3 Ytor"]
["Atemp i beräkningsmodell",null,null,"m2","Andel fönsteryta (Afönster / Atemp)",null,{"$f":"C42/C40*100","v":{"$error":"#DIV/0!"}},"%"]
["Omslutande byggnadsarea (Aomsl)",null,null,"m2","Formfaktor (Aomsl / Atemp)",null,{"$f":"C41/C40","v":{"$error":"#DIV/0!"}}]
["Total fönsterarea (Afönster)",null,null,"m2","Yteffektivitet (formfaktor*Um)",null,{"$f":"G41*G30","v":{"$error":"#DIV/0!"}}]
[]
["2.4 Luftläckage"]
["Klimatskalets luftläckage vid 50 Pa tryckskillnad",null,null,null,null,null,null,"l/s, m2"]
[]
["2.5 Köldbryggor"]
["Metod för beräkning/antagande av köldbryggor:"]
["Procentpåslag på UA-värde vid användande av schablon",null,null,null,null,null,null,"%"]
[]
["2.6 Värmeproduktion, värmesystem och tappvarmvatten"]
["Kortfattad systembeskrivning:"]
[]
["Energibärare, värme",null,"< välj energibärare >",null,"Energibärare, tappvarmvatten",null,"< välj energibärare >"]
["Verkningsgrad, värme",null,null,"< välj enhet >","Verkningsgrad, tappvarmvatten",null,null,"< välj enhet >"]
[]
["2.7 Luftbehandlingssystem"]
["Antal luftbehandlingssystem i byggnaden"]
[]
["Luftbehandlingssystem 1"]
["Aggregatets betjäningsområde:"]
["Kortfattad systembeskrivning:"]
[]
["Kanaltryckfall tilluft",null,null,"Pa","Kanaltryckfall frånluft",null,null,"Pa"]
["Lägsta tillåtna avlufttemperatur",null,null,"°C"]
[" ",null,null,null,"SFP-tal",null,"Årsenergiverkningsgrad VVX"]
["Vid 65 % av maxflöde i VAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
["Vid maxflöde i VAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
["Vid maxflöde i CAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
[]
["Luftbehandlingssystem 2"]
["Aggregatets betjäningsområde:"]
["Kortfattad systembeskrivning:"]
[]
["Kanaltryckfall tilluft",null,null,"Pa","Kanaltryckfall frånluft",null,null,"Pa"]
["Lägsta tillåtna avlufttemperatur",null,null,"°C"]
[" ",null,null,null,"SFP-tal",null,"Årsenergiverkningsgrad VVX"]
["Vid 65 % av maxflöde i VAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
["Vid maxflöde i VAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
["Vid maxflöde i CAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
[]
["Luftbehandlingssystem 3"]
["Aggregatets betjäningsområde:"]
["Kortfattad systembeskrivning:"]
[]
["Kanaltryckfall tilluft",null,null,"Pa","Kanaltryckfall frånluft",null,null,"Pa"]
["Lägsta tillåtna avlufttemperatur",null,null,"°C"]
[" ",null,null,null,"SFP-tal",null,"Årsenergiverkningsgrad VVX"]
["Vid 65 % av maxflöde i VAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
["Vid maxflöde i VAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
["Vid maxflöde i CAV-system",null,null,null,null,"kW/(m3/s)",null,"%"]
[]
["2.8 Inomhustemperatur"]
["Verksamhetstyp","Rumstyp",null,null,"Fall 1",null,"Fall 2"]
["Skola","Undervisningslokaler",null,null,null,"°C",20,"°C"]
["Skola","Uppehållsrum",null,null,null,"°C",20,"°C"]
["Skola","Korridor och kapprum",null,null,null,"°C",17,"°C"]
["Skola","Matsal",null,null,null,"°C",20,"°C"]
["Skola","Gymnastiksal",null,null,null,"°C",17,"°C"]
["Förskola","Avdelningar",null,null,null,"°C",20,"°C"]
["Förskola","Kapprum utanför avdelning",null,null,null,"°C",17,"°C"]
["Bostad med särskild service","Lägenheter och vistelseutrymmen för boende",null,null,null,"°C",22,"°C"]
["Bostad med särskild service","WC/D/Badrum",null,null,null,"°C",22,"°C"]
["Bostad med särskild service","Avskild korridor",null,null,null,"°C",18,"°C"]
["Bostad med särskild service","Lägenhetsförråd i egen byggnad",null,null,null,"°C",5,"°C"]
["Vård och omsorgs-boende för äldre","Lägenheter",null,null,null,"°C",22,"°C"]
["Vård och omsorgs-boende för äldre","WC/D/Badrum",null,null,null,"°C",22,"°C"]
["Vård och omsorgs-boende för äldre","Gemensamhetsutrymmen för boende",null,null,null,"°C",22,"°C"]
["Vård och omsorgs-boende för äldre","Korridor som ej ingår i avdelning",null,null,null,"°C",null,"°C"]
["Samtliga","Daglig verksamhet (dagcentral)",null,null,null,"°C",22,"°C"]
["Samtliga","Storkök",null,null,null,"°C",20,"°C"]
["Samtliga","Kontor",null,null,null,"°C",21,"°C"]
["Samtliga","Personalutrymmen",null,null,null,"°C",20,"°C"]
["Samtliga","WC i skola och förskola",null,null,null,"°C",20,"°C"]
["Samtliga","Bibliotek",null,null,null,"°C",20,"°C"]
["Samtliga","Samlingslokaler",null,null,null,"°C",20,"°C"]
["Samtliga","Omklädningsrum, duschrum",null,null,null,"°C",20,"°C"]
["Samtliga","Trapphus, öppet",null,null,null,"°C",17,"°C"]
["Samtliga","Trapphus, slutet",null,null,null,"°C",15,"°C"]
["Samtliga","Trivselbad",null,null,null,"°C",23,"°C"]
["Samtliga","Vindfång utanför klimatskal",null,null,null,"°C","Ouppvärmt"]
["Samtliga","Avfallsutrymme",null,null,null,"°C","Ouppvärmt"]
["Samtliga","Teknikutrymme (Fläktrum, UC mm)",null,null,null,"°C",15,"°C"]
["Samtliga","Förråd invändigt",null,null,null,"°C",18,"°C"]
["Samtliga","Förråd utvändigt",null,null,null,"°C","Ouppvärmt"]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
["2.9 Internlaster"]
["Verksamhetstyp","Rumstyp","Fall 1",null,null,"Fall 2"]
[null,null,"Belysning","Persontäthet","Utrustning","Belysning","Persontäthet","Utrustning"]
[null,null,"[W/m2 Atemp]","[m2 Atemp/pers]","[W/m2 Atemp]","[W/m2 Atemp]","[m2 Atemp/pers]","[W/m2 Atemp]"]
["Skola","Undervisningslokaler"]
["Skola","Uppehållsrum"]
["Skola","Korridor och kapprum"]
["Skola","Matsal"]
["Skola","Gymnastiksal"]
["Förskola","Avdelningar"]
["Förskola","Kapprum utanför avdelning"]
["Bostad med särskild service","Lägenhet"]
["Bostad med särskild service","WC/D/Badrum"]
["Bostad med särskild service","Korridor utanför lägenhet och vistelseutrymmen för boende"]
["Vård och omsorgs-boende för äldre","Lägenheter"]
["Vård och omsorgs-boende för äldre","WC/D/Badrum"]
["Vård och omsorgs-boende för äldre","Gemensamhetsutrymmen för boende"]
["Vård och omsorgs-boende för äldre","Korridor som ej ingår i avdelning"]
["Samtliga","Daglig verksamhet (dagcentral)"]
["Samtliga","Storkök"]
["Samtliga","Kontor"]
["Samtliga","Personalutrymmen"]
["Samtliga","WC i skola och förskola"]
["Samtliga","Bibliotek"]
["Samtliga","Samlingslokaler"]
["Samtliga","Omklädningsrum, duschrum"]
["Samtliga","Trapphus, öppet"]
["Samtliga","Trapphus, slutet"]
["Samtliga","Trivselbad"]
["Samtliga","Vindfång"]
["Samtliga","Avfallsutrymme"]
["Samtliga","Teknikutrymme (Fläktrum, UC mm)"]
["Samtliga","Förråd invändigt"]
["Samtliga","Förråd utvändigt"]
[]
["2.10 Nyttjande- och drifttider"]
[null,null,null,null,"Fall 1",null,"Fall 2"]
["Värme",null,null,null,null,"h/år",null,"h/år"]
["Luftbehandling",null,null,null,null,"h/år",null,"h/år"]
["Interiör belysning",null,null,null,null,"h/år",null,"h/år"]
["Exteriör belysning",null,null,null,null,"h/år",null,"h/år"]
["IT-utrustning",null,null,null,null,"h/år",null,"h/år"]
["Storkök",null,null,null,null,"h/år",null,"h/år"]
["Tvättutrustning",null,null,null,null,"h/år",null,"h/år"]
[null,null,null,null,null,"h/år",null,"h/år"]
[]
["2.11 Storkök"]
["Antal portioner/dag som köket är dimensionerat för"]
[]
["2.12 Varukyla"]
[]
[]
["2.13 Beräkningsprogram"]
["Dynamisk energiberäkning har utförts med programvara:",null,null,null,"< välj >",null,"Version:","< välj >"]
["Köldbryggor har beräknats med programvara:",null,null,null,"…",null,"Version:","…"]
[]
["2.14 Klimatdata i beräkningsmodell"]
["Klimatort:",null,null,null,"< välj >"]
["Väderfil:",null,null,null,"< välj >"]
["Vindprofil:",null,null,null,"< välj >"]
[]
[]
["3. Beräknad energianvändning"]
[]
["3.1 Uppvärmning"]
["3.1.1 Energi till uppvärmning"]
["Objekt",null,null,null,"Fall 1",null,"Fall 2"]
[null,null,null,null,"kWh/år","kWh/m2, år","kWh/år","kWh/m2, år"]
["Transmission och luftläckage",null,null,null,null,{"$f":"E195/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G195/C40","v":{"$error":"#DIV/0!"}}]
["Luftbehandling",null,null,null,null,{"$f":"E196/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G196/C40","v":{"$error":"#DIV/0!"}}]
["Överföringsförluster i luft- och värmesystem",null,null,null,null,{"$f":"E197/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G197/C40","v":{"$error":"#DIV/0!"}}]
["Vädringspåslag",null,null,null,{"$f":"F198*C40","v":0},4,null,{"$f":"G198/C40","v":{"$error":"#DIV/0!"}}]
["Övrigt:",null,null,null,null,{"$f":"E199/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G199/C40","v":{"$error":"#DIV/0!"}}]
["Summa energi för uppvärmning",null,null,null,{"$f":"SUM(E195:E199)","v":0},{"$f":"SUM(F195:F199)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G195:G199)","v":0},{"$f":"SUM(H195:H199)","v":{"$error":"#DIV/0!"}}]
[]
["3.1.2 Energi till varmvatten"]
["Objekt",null,null,null,"Fall 1",null,"Fall 2"]
[null,null,null,null,"kWh/år","kWh/m2, år","kWh/år","kWh/m2, år"]
["Tappvarmvatten (exkl. VVC-förlust)",null,null,null,null,{"$f":"E205/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G205/C40","v":{"$error":"#DIV/0!"}}]
["Beräknad VVC-förlust (schablonvärde kan användas i tidigt skede)",null,null,null,null,{"$f":"E206/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G206/C40","v":{"$error":"#DIV/0!"}}]
["Övrigt:",null,null,null,null,{"$f":"E207/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G207/C40","v":{"$error":"#DIV/0!"}}]
["Summa energibehov varmvatten",null,null,null,{"$f":"SUM(E205:E207)","v":0},{"$f":"SUM(F205:F207)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G205:G207)","v":0},{"$f":"SUM(H205:H207)","v":{"$error":"#DIV/0!"}}]
[]
["3.2 Elanvändning"]
["3.2.1 Fastighetsel"]
["Objekt",null,null,null,"Fall 1",null,"Fall 2"]
[null,null,null,null,"kWh/år","kWh/m2, år","kWh/år","kWh/m2, år"]
["Fläktar",null,null,null,null,{"$f":"E214/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G214/C40","v":{"$error":"#DIV/0!"}}]
["Pumpar",null,null,null,null,{"$f":"E215/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G215/C40","v":{"$error":"#DIV/0!"}}]
["Interiör belysning (fastighetsel)",null,null,null,null,{"$f":"E216/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G216/C40","v":{"$error":"#DIV/0!"}}]
["Exteriör belysning (fastighetsel)",null,null,null,null,{"$f":"E217/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G217/C40","v":{"$error":"#DIV/0!"}}]
["Övrigt:",null,null,null,null,{"$f":"E218/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G218/C40","v":{"$error":"#DIV/0!"}}]
["Summa fastighetsel",null,null,null,{"$f":"SUM(E214:E218)","v":0},{"$f":"SUM(F214:F218)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G214:G218)","v":0},{"$f":"SUM(H214:H218)","v":{"$error":"#DIV/0!"}}]
[]
["3.2.2 Användning av verksamhets- och hushållsel"]
["Objekt",null,null,null,"Fall 1",null,"Fall 2"]
[null,null,null,null,"kWh/år","kWh/m2, år","kWh/år","kWh/m2, år"]
["Interiör belysning (verksamhets- och hushållsel)",null,null,null,null,{"$f":"E224/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G224/C40","v":{"$error":"#DIV/0!"}}]
["Exteriör belysning (verksamhetsel)",null,null,null,null,{"$f":"E225/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G225/C40","v":{"$error":"#DIV/0!"}}]
["Storköksutrustning",null,null,null,null,{"$f":"E226/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G226/C40","v":{"$error":"#DIV/0!"}}]
["Varukyla",null,null,null,null,{"$f":"E227/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G227/C40","v":{"$error":"#DIV/0!"}}]
["Tvättutrustning",null,null,null,null,{"$f":"E228/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G228/C40","v":{"$error":"#DIV/0!"}}]
["Övrigt:",null,null,null,null,{"$f":"E229/C40","v":{"$error":"#DIV/0!"}},null,{"$f":"G229/C40","v":{"$error":"#DIV/0!"}}]
["Summa verksamhets- och hushållsel",null,null,null,{"$f":"SUM(E224:E229)","v":0},{"$f":"SUM(F224:F229)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(G224:G229)","v":0},{"$f":"SUM(H224:H229)","v":{"$error":"#DIV/0!"}}]
[]
[]
["3.3 Egenproduktion och återvinning"]
["3.3.1 Solceller",null,null,null,null,null,"Årsproduktion"]
["Solel använd som fastighetsenergi",null,null,null,null,null,null,"kWh/år"]
["Solel använd som verksamhetsenergi",null,null,null,null,null,null,"kWh/år"]
["Såld solel",null,null,null,null,null,null,"kWh/år"]
["Total solelproduktion",null,null,null,null,null,{"$f":"SUM(G235:G237)","v":0},"kWh/år"]
[null,null,null,null,null,null,{"$f":"G238/C40","v":{"$error":"#DIV/0!"}},"kWh/m2, år"]
[]
["3.3.2 Värme",null,null,null,null,null,"Årlig energi"]
["Solvärme (solfångare)",null,null,null,null,null,null,"kWh/år"]
["Värmeåtervinning från kylmaskin",null,null,null,null,null,null,"kWh/år"]
["Övrig värmeåtervinning:",null,null,null,null,null,null,"kWh/år"]
[null,null,null,null,null,null,{"$f":"SUM(G242:G244)","v":0},"kWh/år"]
[]
["3.4 Justerings- och viktningsfaktorer för beräkning av primärenergital"]
["Geografisk justeringsfaktor (Fgeo)",null,null,null,null,null,null,0.90]
["Viktningsfaktor El (VFel)",null,null,null,null,null,null,1.80]
["Viktningsfaktor Fjärrvärme (VFfjv)",null,null,null,null,null,null,0.70]
["Viktningsfaktor för fasta, flytande och gasformiga biobränslen (VFbio)",null,null,null,null,null,null,0.60]
[]
["3.5 Summering av byggnadens energianvändning"]
["Energipost",null,null,"Viktningsfaktor","Fall 1",null,"Fall 2"]
[null,null,null,"VFi","kWh/år","kWh/m2, år","kWh/år","kWh/m2, år"]
["Energi för värmning av lokaler och ventilationsluft",null,null,0.70,{"$f":"E200","v":0},{"$f":"E256/C40","v":{"$error":"#DIV/0!"}},{"$f":"G200","v":0},{"$f":"G256/C40","v":{"$error":"#DIV/0!"}}]
["Energi för tappvarmvattenframställning",null,null,0.70,{"$f":"E208","v":0},{"$f":"E257/C40","v":{"$error":"#DIV/0!"}},{"$f":"G208","v":0},{"$f":"G257/C40","v":{"$error":"#DIV/0!"}}]
["Återvunnen/egenproducerad värme nyttjad som fastighetsenergi",null,null,0.70,{"$f":"-G245","v":0},{"$f":"E258/C40","v":{"$error":"#DIV/0!"}},{"$f":"-G245","v":0},{"$f":"G258/C40","v":{"$error":"#DIV/0!"}}]
["Fastighetsel",null,null,1.80,{"$f":"E219","v":0},{"$f":"E259/C40","v":{"$error":"#DIV/0!"}},{"$f":"G219","v":0},{"$f":"G259/C40","v":{"$error":"#DIV/0!"}}]
["Producerad el nyttjad som fastighetsenergi",null,null,1.80,{"$f":"-G235","v":0},{"$f":"E260/C40","v":{"$error":"#DIV/0!"}},{"$f":"-G235","v":0},{"$f":"G260/C40","v":{"$error":"#DIV/0!"}}]
["Summa årlig fastighetsenergianvändning",null,null,null,null,null,{"$f":"SUM(G256:G260)","v":0},{"$f":"SUM(H256:H260)","v":{"$error":"#DIV/0!"}}]
["Primärenergital (EPpet)",null,null,null,null,{"$f":"(F256/H248*D256+F257*D257+F258*D258+F259*D259+F260*D260)","v":{"$error":"#DIV/0!"}}]
[]
[]
["4. Resultatredovisning"]
[]
["4.1 Resultatsammanställning för beräkningsfall 1"]
[null,null,null,null,null,"Kravnivå, BBR","Kravnivå, TKA","Beräknat värde"]
["Energi","Byggnadens primärenergital (EPpet) beräknat enligt BBR och BEN [kWh/m2 Atemp, år]",null,null,null,70,"< välj >",{"$f":"F262","v":{"$error":"#DIV/0!"}}]
[null,"Gröna Obligationer: Energi till uppvärmning (EPpet) [kWh/m2 Atemp, år]",null,null,null,null,null,{"$f":"F256/H248*D256+F257*D257+F258*D258","v":{"$error":"#DIV/0!"}}]
[null,"Gröna Obligationer: Elenergi till fastighet (EPpet) [kWh/m2 Atemp, år]",null,null,null,null,null,{"$f":"(F259+F260)*H249","v":{"$error":"#DIV/0!"}}]
["P","Installerad eleffekt för uppvärmning [kW]"]
["U","Genomsnittlig värmegenomgångskoefficient (Um) [W/m2, K]",null,null,null,0.50,null,{"$f":"G30","v":0}]
[]
["4.2 Resultatsammanställning för beräkningsfall 2"]
[null,null,null,null,null,null,"Kravnivå, TKA","Beräknat värde"]
["Energi","Byggnadens beräknade specifika energianvändning baserat på projektspecifik indata [kWh/m2, år]",null,null,null,null,null,{"$f":"H261","v":{"$error":"#DIV/0!"}}]
[null,"Köpt energi för uppvärmning [kWh/m2, år]",null,null,null,null,null,{"$f":"H256+H257+H258","v":{"$error":"#DIV/0!"}}]
[null,"Köpt fastighetsel [kWh/m2, år]",null,null,null,null,null,{"$f":"H259+H260","v":{"$error":"#DIV/0!"}}]
["P","Tillförd effekt för uppvärmning vid dimensionerande utetemperatur [W/m2]",null,null,null,null,15]
["q","Genomsnittligt specifikt uteluftsflöde under uppvärmningssäsong (qmedel) [l/s m2]"]
[null,"Maximalt specifikt uteluftsflöde vid DVUT (qmax) [l/s m2]"]
["Termisk komfort","Termiskt klimat, sommar [PPD]",null,null,null,null,"≤10"]
[null,"Antal timmar per år som lufttemperaturen överstiger 26°C i den värsta zonen [h]"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"< välj >"]
[null,"Förstudie"]
[null,"Huvudhandling/systemhandling"]
[null,"Förfrågningsunderlag"]
[null,"Bygghandling"]
[null,"Relationshandling"]
[null,"< välj >"]
[null,"IDA ICE"]
[null,"Annan - ange vilken"]
[]
[null,"1.11"]
[null,"< välj >"]
[null,"4.8"]
[null,"5.0"]
[null,"5.1"]
[null,"Annan - ange vilken"]
[]
[null,"1.12"]
[null,"< välj >"]
[null,"Göteborg - Säve"]
[null,"Annan - ange vilken"]
[]
[null,"< välj >"]
[null,"SWE_GOTEBORG-SAVE_025120(IW2)"]
[null,"Annan - ange vilken"]
[]
[null,"< välj energibärare >"]
[null,"Fjärrvärme"]
[null,"El"]
[null,"Biobränsle"]
[]
[null,"< välj enhet >"]
[null,"%"]
[null,"COP"]
[]
[null,"< välj >"]
[null,"Stadskärna (ASHRAE 1993)"]
[null,"Tätort (ASHRAE 1993)"]
[null,"Landsbygd (ASHRAE 1993)"]
[null,"Slätt (ASHRAE 1993)"]
[null,"Havsnära (ASHRAE 1993)"]
[null,"Annan - ange vilken"]
[]
[null,0.60]
[null,0.70]
[null,1.80]
[]
[null,"< välj >"]
[null,25]
[null,35]
[null,45]