{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Modell","Blad1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Modell","index":0,"n_rows":68,"n_cols":24,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,3,0,9],[25,3,25,8],[25,10,25,12],[7,6,7,9]]}
[null,null,null,"MODELL FÖR BERÄKNING AV ÖVERKOMPENSATION, version 1.0"]
[]
[null,null,null,"Sökande",null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,"För tester","Anders Carlsson"]
[null,null,null,"Fastighetsbeteckning",null,{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,null,"Bromåla 1:14"]
[null,null,null,"Diarienummer",null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,123]
[null,null,null,"Bofincs ärendenummer",null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,null,null,null,4567]
[]
[null,null,null,"Total faktisk hyra 1:a året",null,null,"RESULTATSAMMANSTÄLLNING",null,null,null,null,null,null,null,null,null,null,"Antal","kvm BOA","Totalt"]
[null,null,null,"Årlig hyresutveckling (%)",null,null,"Kostnader",null,null,null,null,null,null,null,null,null,"1 rok",6,24,144]
[null,null,null,"År 2",0.01,null,"Produktionskostnad",{"$f":"E16","v":0},null,null,null,null,null,null,null,null,"2 rok",8,35,280]
[null,null,null,"År 3",1.2999999999999999E-2,null,"Drift och underhåll",{"$f":"I28","v":0},null,null,null,null,null,null,null,null,"3 rok",4,77,308]
[null,null,null,"År 4",1.7000000000000001E-2,null,"Totalt",{"$f":"H10+H11","v":0},null,null,null,null,null,null,null,null,"4 rok",0,0,0]
[null,null,null,"År 5 och framåt",0.02,null,"Intäkter",null,"Beslut:","Stödbelopp",null,null,null,null,null,null,"5 rok",2,100,200]
[null,null,null,null,null,null,"Hyra",{"$f":"M28","v":0},{"$f":"IF(H18<=0,\"Fullt stöd\",IF(AND(0<H18,H18<H15),\"Reducerat stöd\",\"Inget stöd\"))","v":"Fullt stöd"},{"$f":"IF(I14=\"fullt stöd\",H15,IF(I14=\"Reducerat stöd\",H15-H18,0))","v":0},null,null,null,null,null,null,"6 rok",0,0,0]
[null,null,null,"Total area m2 (BOA)",null,null,"Stöd",{"$f":"E17","v":0},null,null,null,null,null,null,null,null,null,null,"Totalt",932]
[null,null,null,"Produktionskostnad (kr)",null,null,"Totalt",{"$f":"H14+H15","v":0}]
[null,null,null,"Stödbelopp (kr)"]
[null,null,null,"Drift- och underhåll (DoU) (kr/kvm och år)",null,null,"Vinst/förlust",{"$f":"H16-H12","v":0}]
[null,null,null,"Årlig utveckling, DoU (%)",0.02]
[]
[null,null,null,"Kalkylränta (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAKRO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Första",{"$f":"\"\"","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Andra",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tredje",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fjärde",0]
[null,null,null,"KOSTNADER",null,null,null,null,null,null,"INTÄKTER"]
[null,"Diskont.  faktor","År","Produktionskostnad (kr)",null,"DoU (kr/kvm och år)","Årlig DoU (kr)","DoU        Nuvärde (kr)","DoU                     S:a nuvärden (kr)",null,"Årlig hyra (kr)","Hyra                 Nuvärde (kr)","Hyra                   S:a nuvärden (kr)",null,null,null,null,null,null,null,null,null,null,"Summa nuvärde"]
[null,{"$f":"1/(1+$E$21)^C28","v":1},0,{"$f":"E16","v":0},null,null,null,null,{"$f":"SUM(H29:H68)","v":0},null,null,null,{"$f":"SUM(L29:L68)","v":0},null,null,"Koll årlig DoH","Koll årlig hyra",null,null,null,"Driftnetto",null,"Nuvärde",{"$f":"SUM(W29:W68)","v":0}]
[null,1,1,null,null,{"$f":"E18","v":0},{"$f":"F29*$E$15","v":0},{"$f":"B29*G29","v":0},null,null,{"$f":"$E$8","v":0},{"$f":"K29*B29","v":0},null,null,null,null,null,null,null,null,{"$f":"K29-G29","v":0},null,{"$f":"U29*B29","v":0},"KOLL"]
[null,1,2,null,null,{"$f":"F29*(1+$E$19)","v":0},{"$f":"F30*$E$15","v":0},{"$f":"B30*G30","v":0},null,null,{"$f":"K29*(1+$E$10)","v":0},{"$f":"K30*B30","v":0},null,null,null,{"$f":"G30/G29-1","v":{"$error":"#DIV/0!"}},{"$f":"K30/K29-1","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"K30-G30","v":0},{"$f":"U30/U29-1","v":{"$error":"#DIV/0!"}},{"$f":"U30*B30","v":0},{"$f":"H14-H11","v":0}]
[null,1,3,null,null,{"$f":"F30*(1+$E$19)","v":0},0,0,null,null,{"$f":"K30*(1+$E$11)","v":0},0,null,null,null,{"$f":"G31/G30-1","v":{"$error":"#DIV/0!"}},{"$f":"K31/K30-1","v":{"$error":"#DIV/0!"}},null,null,null,0,{"$f":"U31/U30-1","v":{"$error":"#DIV/0!"}},0]
[null,1,4,null,null,{"$f":"F31*(1+$E$19)","v":0},0,0,null,null,{"$f":"K31*(1+$E$12)","v":0},0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0,{"$f":"X28-X30","v":0}]
[null,1,5,null,null,0,0,0,null,null,{"$f":"K32*(1+$E$13)","v":0},0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,6,null,null,0,0,0,null,null,{"$f":"K33*(1+$E$13)","v":0},0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,7,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,8,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,9,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,10,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,11,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,12,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,13,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,14,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,15,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,16,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,17,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,18,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,19,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,20,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,21,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,22,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,23,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,24,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,25,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,26,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,27,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,28,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,29,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,30,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,31,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,32,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,33,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,34,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,35,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,36,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,37,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,38,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,39,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]
[null,1,40,null,null,0,0,0,null,null,0,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,0,{"$error":"#DIV/0!"},0]

{"sheet":"Blad1","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"e"]