{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Innehåll","Contents","Vägledning","Guide","Anvisningar","Data","Diagram 1","Graph 1","Diagram 2","Graph 2"],"not_rendered":{"charts":4,"images":11,"macros":1,"external_links":0,"defined_names":33,"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":"Innehåll","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Innehållsförteckning"]
[]
[null,"Anvisningar","Anvisningar för att producera diagram till webben"]
[]
[null,"Vägledning","Definitioner och förklaringar"]
[]
[null,"Data","Tidsserier som ligger till grund för diagrammen"]
[]
[null,"Diagram 1","Fastighetsprisindex, Index 1981=100"]
[]
[null,"Diagram 2","Fastighetsprisindex, Årlig förändring i procent"]

{"sheet":"Contents","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Contents"]
[]
[null,"Guide","Definitions and explanations"]
[]
[null,"Data","Time series"]
[]
[null,"Graph 1","Real estate price index, Index 1981=100"]
[]
[null,"Graph 2","Real estate price index,  Percent change from previous year"]

{"sheet":"Vägledning","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Vägledning"]
[]
[null,"Utskriftstips","Utskriftsformatet i samtliga flikar med diagram är förinställt på att utskriften förstoras till 120% och innehållet centreras vertikalt och horisontellt."]
[null,null,"Om utskriften av diagrammen inte blir tillfredställande så ändra inställningarna under utskriftsformat till vad som passar just din skrivare."]
[]
[]
[null,"Definitioner & förklaringar"]
[]
[null,null,"Statistiken visar hur prisutvecklingen har varit för småhus, fritidshus och hyreshus. Prisnivån uttrycks som ett index med 1981=100. Serien för småhus och fritidshus är SCB:s officiella fastighetprisindex. Index för hyreshus bygger på SCB:s prisstatistik för hyreshus inom typkoderna 320, 321 och 325. Indexserien för hyreshus har beräknats med köpeskillingskoefficienter (K/T-tal). K/T är köpeskillingen (priset) i förhållande till taxeringsvärdet. För att skapa en tidsserie med K/T-tal som spänner över två eller flera allmän/förenklad fastighetstaxering har hänsyn tagits till de taxeringsvärdeförändringar som skett mellan taxeringarna. Utvecklingen av konsumentprisindex har tagits med för att enklare belysa storleken av prisförändringarna för fastigheter."]

{"sheet":"Guide","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Guide"]
[]
[null,"Utskriftstips","Utskriftsformatet i samtliga flikar med diagram är förinställt på att utskriften förstoras till 120% och innehållet centreras vertikalt och horisontellt."]
[null,null,"Om utskriften av diagrammen inte blir tillfredställande så ändra inställningarna under utskriftsformat till vad som passar just din skrivare."]
[]
[]
[null,"Definitions","The statistics illustrates the price trends for one- and two-dwelling houses for permanent living, buildings for seasonal and secondary use and multi-dwelling and commercial buildings. The price level is expressed as an index with base year 1981=100. The series for one- and two-dwelling houses for permanent living and buildings for seasonal and secondary use are the official real estate price indices. The index for multi-dwelling and commercial buildings is based on the purchase-price-coefficient with type codes in 320, 321 and 325. The consumer price index has been included to illustrate the proportion of the price changes of properties."]

{"sheet":"Anvisningar","index":4,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":false,"merged":[[57,10,57,14],[44,8,44,11]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Diagramuppgifter",null,{"$f":"IF(yy=\"\",\"\",\"Data t.o.m \" & yy)","v":"Data t.o.m 2023"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(yy=\"\",\"\",\"Data up to and including \" & yy)","v":"Data up to and including 2023"}]
[]
[null,null,null,null,null,null,null,"pong  (YYYYXnn)"]
[]
[null,null,null,null,null,null,null,"produktkod"]
[]
[null,null,null,null,null,null,null,"aktuell period för data:  år",null,2023]
[]
[]
[null,null,null,null,null,null,null,"skapa alltid Excelfil",null,null,"beskrivning *)",null,null,"filnamn i klartext"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"sv",{"$f":"IF(I55=FALSE,\"\",IF(TRIM(I51)=\"\",\"\",I51&\"DI_01_SV\"&IF(TRIM(I53)<>\"\",\"_\"&TRIM(I53),\"\")))","v":"BO0501_2022A01_DI_01_SV_Fastighindex_ar"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eng",{"$f":"IF(I55=FALSE,\"\",IF(TRIM(I51)=\"\",\"\",I51&\"DI_01_EN\"&IF(TRIM(I53)<>\"\",\"_\"&TRIM(I53),\"\")))","v":"BO0501_2022A01_DI_01_EN_Fastighindex_ar"}]
[]
[null,null,null,null,null,null,null,"ange diagram-nummer och beskrivning för diagram på följande flikar:"]
[]
[null,null,null,null,null,null,null,"flik-namn",null,"nr (nn)","beskrivning (15 tkn) *)",null,null,"diagram-namn i klartext"]
[]
[null,null,null,null,null,null,null,"Diagram 1/ Graph 1",null,null,null,null,null,"sv",{"$f":"IF(TRIM(L47)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L47))<2,\"0\"&TRIM(L47),TRIM(L47))&\"_SV\" & IF(TRIM(L48)<>\"\",\"_\"&TRIM(L48),\"\"))","v":"DI_07_SV_Index_Ar"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eng",{"$f":"IF(TRIM(L47)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L47))<2,\"0\"&TRIM(L47),TRIM(L47))&\"_EN\" & IF(TRIM(L48)<>\"\",\"_\"&TRIM(L48),\"\"))","v":"DI_07_EN_Index_Ar"}]
[]
[null,null,null,null,null,null,null,"Diagram 2 / Graph 2",null,null,null,null,null,"sv",{"$f":"IF(TRIM(L49)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L49))<2,\"0\"&TRIM(L49),TRIM(L49))&\"_SV\" & IF(TRIM(L50)<>\"\",\"_\"&TRIM(L50),\"\"))","v":"DI_08_SV_Arsforandring"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eng",{"$f":"IF(TRIM(L49)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L49))<2,\"0\"&TRIM(L49),TRIM(L49))&\"_EN\" & IF(TRIM(L50)<>\"\",\"_\"&TRIM(L50),\"\"))","v":"DI_08_EN_Arsforandring"}]
[]
[null,null,null,null,null,null,null,"Diagram 3 / Graph 3",null,null,null,null,null,"sv",{"$f":"IF(TRIM(L51)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L51))<2,\"0\"&TRIM(L51),TRIM(L51))&\"_SV\" & IF(TRIM(L52)<>\"\",\"_\"&TRIM(L52),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eng",{"$f":"IF(TRIM(L51)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L51))<2,\"0\"&TRIM(L51),TRIM(L51))&\"_EN\" & IF(TRIM(L52)<>\"\",\"_\"&TRIM(L52),\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"Diagram 4 / Graph 4",null,null,null,null,null,"sv",{"$f":"IF(TRIM(L53)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L53))<2,\"0\"&TRIM(L53),TRIM(L53))&\"_SV\" & IF(TRIM(L54)<>\"\",\"_\"&TRIM(L54),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eng",{"$f":"IF(TRIM(L53)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L53))<2,\"0\"&TRIM(L53),TRIM(L53))&\"_EN\" & IF(TRIM(L54)<>\"\",\"_\"&TRIM(L54),\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"Diagram 5 / Graph 5",null,null,null,null,null,"sv",{"$f":"IF(TRIM(L55)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L55))<2,\"0\"&TRIM(L55),TRIM(L55))&\"_SV\" & IF(TRIM(L56)<>\"\",\"_\"&TRIM(L56),\"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"eng",{"$f":"IF(TRIM(L55)=\"\",\"\",\"DI_\"&IF(LEN(TRIM(L55))<2,\"0\"&TRIM(L55),TRIM(L55))&\"_EN\" & IF(TRIM(L56)<>\"\",\"_\"&TRIM(L56),\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,"filerna sparas här:",null,"\\\\wp\\xmlDump"]
[]
[null,null,null,null,null,null,null,"*) frivillig uppgift"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Mellanlagring av värden"]
[null,null,null,null,null,null,null,null,"pong",null,"diagramidentitet"]
[null,null,null,null,null,null,null,null,"2022A01",null,"nr:","7"]
[null,null,null,null,null,null,null,null,"produktkod",null,"beskrivning:","Index_Ar"]
[null,null,null,null,null,null,null,null,"BO0501",null,"nr:","8"]
[null,null,null,null,null,null,null,null,"Pong+prodkod",null,"beskrivning:","Arsforandring"]
[null,null,null,null,null,null,null,null,{"$f":"IF(OR(TRIM(I47)=\"\",TRIM(I49)=\"\"),\"\",I49&\"_\"&I47&\"_\")","v":"BO0501_2022A01_"},null,"nr:",""]
[null,null,null,null,null,null,null,null,"Beskrivn Excelfil",null,"beskrivning:",""]
[null,null,null,null,null,null,null,null,"Fastighindex_ar",null,"nr:",""]
[null,null,null,null,null,null,null,null,"Skapa Excelfil",null,"beskrivning:",""]
[null,null,null,null,null,null,null,null,true,null,"nr:",""]
[null,null,null,null,null,null,null,null,null,null,"beskrivning:",""]
[]
[null,null,null,null,null,null,null,null,null,null,"Hjälplista"]
[null,null,null,null,null,null,null,null,null,null,1,"januari","January","första","First"]
[null,null,null,null,null,null,null,null,null,null,2,"februari","February","andra","Second"]
[null,null,null,null,null,null,null,null,null,null,3,"mars","March","tredje","Third"]
[null,null,null,null,null,null,null,null,null,null,4,"april","April","fjärde","Fourth"]
[null,null,null,null,null,null,null,null,null,null,5,"maj","May"]
[null,null,null,null,null,null,null,null,null,null,6,"juni","June"]
[null,null,null,null,null,null,null,null,null,null,7,"juli","July"]
[null,null,null,null,null,null,null,null,null,null,8,"augusti","August"]
[null,null,null,null,null,null,null,null,null,null,9,"september","September"]
[null,null,null,null,null,null,null,null,null,null,10,"oktober","October"]
[null,null,null,null,null,null,null,null,null,null,11,"november","November"]
[null,null,null,null,null,null,null,null,null,null,12,"december","December"]

{"sheet":"Data","index":5,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[7,12,7,13],[2,1,2,4],[2,5,2,8],[3,10,3,11],[3,12,3,13],[6,1,6,4],[6,5,6,8],[6,10,6,11]]}
["Real estate price index"]
[null,null,null,null,null,null,null,null,null,{"$f":"timeperiodEng","v":"Data up to and including 2023"}]
[null,"Index 1981=100",null,null,null,"Per cent change from previous year"]
["Year","One- or two-dwelling buildings","Buildings for seasonal and secondary use","Multi-dwelling and commercial buildings","Consumer prices","One- or two-dwelling buildings","Buildings for seasonal and secondary use","Multi-dwelling and commercial buildings","Consumer prices"]
["Fastighetsprisindex"]
[null,null,null,null,null,null,null,null,null,{"$f":"timeperiodSv","v":"Data t.o.m 2023"}]
[null,"Index 1981=100",null,null,null,"Årlig förändring, procent"]
["År","Småhus för permanentboende","Fritidshus","Hyreshus","Konsumentpriser","Småhus för permanentboende","Fritidshus","Hyreshus","Konsumentpriser"]
[1981,100,100,100,100]
[1982,101,104,103.16455696202532,108.56378233719894,{"$f":"((B10/B9)-1)*100","v":1.0000000000000009},{"$f":"((C10/C9)-1)*100","v":4.0000000000000036},{"$f":"((D10/D9)-1)*100","v":3.1645569620253111},8.5637823371989441]
[1983,101,107,109.49367088607593,118.28724353256021,0,2.8846153846153744,6.134969325153361,8.9564502875924212]
[1984,105,112,118.98734177215189,127.74308652988402,3.9603960396039639,4.6728971962616717,8.6705202312138852,7.9939668174962231]
[1985,109,117,132.27848101265823,137.19892952720787,3.8095238095238182,4.4642857142857206,11.170212765957466,7.4022346368715297]
[1986,115,123,146.83544303797467,142.99732381801965,5.504587155963292,5.1282051282051322,11.004784688995194,4.2262678803641096]
[1987,130,139,171.51898734177215,148.9741302408564,13.043478260869556,13.008130081300816,16.81034482758621,4.1796631316281863]
[1988,154,166,216.34177215189871,157.62711864406779,18.461538461538463,19.424460431654666,26.132841328413271,5.8083832335329211]
[1989,181,191,263.50632911392398,167.79661016949152,17.532467532467532,15.060240963855431,21.800947867298561,6.4516129032258007]
[1990,203,216,313.74683544303798,185.37020517395183,12.154696132596676,13.089005235602102,19.066147859922221,10.473152578415746]
[1991,217,253,318.87341772151899,202.67618198037468,6.8965517241379226,17.129629629629626,1.6339869281045694,9.3358999037536083]
[1992,197,225,276.8354430379747,207.31489741302411,-9.2165898617511566,-11.067193675889332,-13.183279742765276,2.2887323943661997]
[1993,175,205,237.87341772151899,216.94915254237287,-11.167512690355331,-8.8888888888888911,-14.074074074074073,4.6471600688468007]
[1994,183,215,265.403164556962,221.67707404103481,4.5714285714285818,4.8780487804878092,11.573275862068954,2.1792763157894912]
[1995,184,215,261.9786075949367,227.29705619982158,0.5464480874316946,0,-1.2903225806451535,2.5352112676056304]
[1996,185,219,272.2522784810127,228.36752899197145,0.54347826086955653,1.8604651162790642,3.9215686274509887,0.47095761381474865]
[1997,198,228,291.08734177215189,229.52720785013386,{"$f":"((B25/B24)-1)*100","v":7.0270270270270219},4.1095890410958846,6.9182389937106681,0.50781250000002665]
[1998,217,248,313.34696202531643,229.25958965209637,9.5959595959596022,8.7719298245614077,7.6470588235294068,-0.11659541391373374]
[1999,237,268,340.74341772151899,230.24085637823376,9.2165898617511566,8.0645161290322509,8.7431693989071135,0.42801556420233311]
[2000,263,306,356.58199367088599,232.56021409455846,10.970464135021096,14.179104477611947,4.6482412060301348,1.0073614877954329]
[2001,284,335,372.88288481012654,238.26940231935777,7.9847908745247054,9.4771241830065467,4.5714285714285818,2.4549290372075205]
[2002,302,358,393.25899873417723,243.3541480820696,6.3380281690140761,6.8656716417910379,5.464480874316946,2.1340321976787591]
[2003,322,383,407.52227848101262,248.08206958073154,6.6225165562913801,6.9832402234636826,3.6269430051813378,1.9428152492668715]
[2004,353,424,456.42495189873415,249.06333630686888,9.6273291925465863,10.704960835509137,12.000000000000011,0.39554117224018803]
[2005,387,470,479.89823513924046,250.13380909901875,9.6317280453257723,10.849056603773576,5.1428571428571379,0.42979942693410766]
[2006,431,527,516.41223129113916,253.54148082069585,11.369509043927639,12.127659574468087,7.6086956521739024,1.3623395149786166]
[2007,477,588,602.24620367392401,259.15254237288138,10.672853828306273,11.574952561669827,16.621212121212125,2.2130743790021778]
[2008,491,603,622.43322726075996,268.16235504014276,2.9350104821803003,2.5510204081632626,3.351955307262644,3.4766445217032205]
[2009,501,633,642.62025084759534,267.31489741302414,{"$f":"((B37/B36)-1)*100","v":2.0366598778004175},4.9751243781094523,3.2432432432432323,-0.31602408436178786]
[2010,538,679,676.63538559141307,270.70472792149866,7.385229540918159,{"$f":"((C38/C37)-1)*100","v":7.2669826224328604},5.2931937172774779,1.2681038510311549]
[2011,542,677,692.65042430363599,277.81445138269402,0.74349442379182396,-0.29455081001472649,2.3668639053254559,2.6263757991168424]
[2012,535,664,696.65418398169152,280.28545941123997,-1.291512915129156,-1.9202363367799125,0.57803468208090791,0.88944546125935275]
[2013,554,682,750.62486444188255,280.16057091882249,3.5514018691588767,{"$f":"((C41/C40)-1)*100","v":2.7108433734939652},{"$f":"((D41/D40)-1)*100","v":7.7471264367816373},{"$f":"((E41/E40)-1)*100","v":-4.4557606619988199E-2}]
[2014,592,710,772.44535468728611,279.65209634255132,6.8592057761732939,{"$f":"((C42/C41)-1)*100","v":4.1055718475073277},{"$f":"((D42/D41)-1)*100","v":2.9069767441860517},{"$f":"((E42/E41)-1)*100","v":-0.18149398204164724}]
[2015,656,785,842.27092347257735,279.52720785013383,{"$f":"((B43/B42)-1)*100","v":10.810810810810811},{"$f":"((C43/C42)-1)*100","v":10.563380281690149},{"$f":"((D43/D42)-1)*100","v":9.0395480225988543},{"$f":"((E43/E42)-1)*100","v":-4.4658521802931617E-2}]
[2016,711,826,946.83471272855127,282.27475468331852,{"$f":"((B44/B43)-1)*100","v":8.3841463414634063},{"$f":"((C44/C43)-1)*100","v":5.2229299363057313},{"$f":"((D44/D43)-1)*100","v":12.414507772020734},{"$f":"((E44/E43)-1)*100","v":0.98292644008297625}]
[2017,770,902,986.28615909224095,287.34165923282785,{"$f":"((B45/B44)-1)*100","v":8.298171589310833},{"$f":"((C45/C44)-1)*100","v":9.2009685230024285},{"$f":"((D45/D44)-1)*100","v":4.1666666666666741},{"$f":"((E45/E44)-1)*100","v":1.795025756091384}]
[2018,770,892,1065.1890518196203,292.95272078501335,{"$f":"((B46/B45)-1)*100","v":0},{"$f":"((C46/C45)-1)*100","v":-1.1086474501108667},{"$f":"((D46/D45)-1)*100","v":8.0000000000000071},{"$f":"((E46/E45)-1)*100","v":1.9527490608798104}]
[2019,791,923,1124.6621072128823,298.18019625334523,{"$f":"((B47/B46)-1)*100","v":2.7272727272727337},{"$f":"((C47/C46)-1)*100","v":3.4753363228699596},{"$f":"((D47/D46)-1)*100","v":5.5833333333333179},{"$f":"((E47/E46)-1)*100","v":1.7844092570036718}]
[2020,843,1014,1199.6395810270744,299.66101694915255,{"$f":"((B48/B47)-1)*100","v":6.5739570164348837},{"$f":"((C48/C47)-1)*100","v":9.8591549295774747},{"$f":"((D48/D47)-1)*100","v":6.6666666666666652},{"$f":"((E48/E47)-1)*100","v":0.4966193980733502}]
[2021,985,1186,1230.8801951163211,306.1462979482605,{"$f":"((B49/B48)-1)*100","v":16.844602609727154},{"$f":"((C49/C48)-1)*100","v":16.962524654832343},{"$f":"((D49/D48)-1)*100","v":2.6041666666666741},{"$f":"((E49/E48)-1)*100","v":2.1642057632769607}]
[2022,1029,1200,1408.3768681257854,331.76628010704735,4.4670050761421276,1.180438448566612,14.42030456852792,8.3685422069407878]
[2023,926,1101,1276,360.12488849241748,{"$f":"((B51/B50)-1)*100","v":-10.009718172983483},{"$f":"((C51/C50)-1)*100","v":-8.2500000000000018},{"$f":"((D51/D50)-1)*100","v":-9.3992503797614582},{"$f":"((E51/E50)-1)*100","v":8.5477669328600783}]
[2024,930,1103,1298,370.33898305084745,{"$f":"((B52/B51)-1)*100","v":0.43196544276458138},{"$f":"((C52/C51)-1)*100","v":0.18165304268846771},{"$f":"((D52/D51)-1)*100","v":1.7241379310344751},{"$f":"((E52/E51)-1)*100","v":2.8362645528858144}]
[2025,948,1111,1299,372.86351471900093,{"$f":"((B53/B52)-1)*100","v":1.9354838709677358},{"$f":"((C53/C52)-1)*100","v":0.72529465095194645},{"$f":"((D53/D52)-1)*100","v":7.7041602465333092E-2},{"$f":"((E53/E52)-1)*100","v":0.68168132000483439}]

{"sheet":"Diagram 1","index":6,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Fastighetsprisindex"]
[null,"Index 1981=100"]
[null,"Som jämförelse visas också konsumentprisutvecklingen"]

{"sheet":"Graph 1","index":7,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Real estate price index"]
[null,"Index 1981=100"]
[null,"As a comparison the consumer price development is also shown"]

{"sheet":"Diagram 2","index":8,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Fastighetsprisindex"]
[null,"Årlig förändring i procent"]
[null,"Som jämförelse visas också konsumentprisernas förändring"]

{"sheet":"Graph 2","index":9,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Real estate price index"]
[null," Percent change from previous year"]
[null,"As a comparison the consumer price development is also shown"]