{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overgangsordning","Datavalidering"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"Overgangsordning","index":0,"n_rows":86,"n_cols":17,"rows_kept":86,"cut":false,"hidden":false,"merged":[[37,10,38,10],[37,9,38,9],[37,8,38,8],[29,9,29,10],[29,18,29,22],[34,8,34,10],[34,18,34,22],[29,12,29,16],[34,12,34,16],[36,12,36,16],[36,8,36,10]]}
[null,"Ikke rør ->",null,null,null,null,null,null,null,null,null,"Ikke rør ->"]
[null,"Antall måneder overgangsperiode",{"$f":"J20*12","v":60},null,null,null,null,null,null,null,null,"Første år (1 hvis ja)",{"$f":"IF(M$39=$C$8,1,0)","v":1},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Siste år (1 hvis ja)",{"$f":"IF(M$39=$C$9,1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Etter siste år (1 hvis ja)",{"$f":"IF(M$39>$C$9,1,0)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Antall måneder tilskudd (aktuelt år)",{"$f":"IF(M$2=1,$C$11,IF(M$3=1,$C$12,IF(M$4=1,$C$14,$C$13)))","v":6},12,12,12,12]
[null,"Start semester (Høst = 1, Vår = 0)",{"$f":"IF(J22=\"Høst\",1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"Antall måneder tidligere benyttet",0,{"$f":"M8","v":6},{"$f":"N8","v":18},{"$f":"O8","v":30},{"$f":"P8","v":42}]
[null,"Første år overgangsordning",{"$f":"J21","v":2024},null,null,null,null,null,null,null,null,"Antall måneder benyttet (inkl inneværende)",{"$f":"M5+M7","v":6},18,30,42,54]
[null,"Siste år overgangsordning",{"$f":"IF(C6=1,J21+J20,J21+J20-1)","v":2029},null,null,null,null,null,null,null,null,"Justering for oppstart høst",{"$f":"IF(AND($C$6=1,M$2=1),50%,100%)","v":0.5},1,1,1,1]
[]
[null,"Måneder tilskudd første år",{"$f":"IF(C6=1,6,12)","v":6}]
[null,"Måneder tilskudd siste år",{"$f":"IF(C6=1,6,12)","v":6}]
[null,"Måneder tilskudd fullt år",12]
[null,"Måneder tilskudd etter siste år",0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Input - Overgangsperiode"]
[null,null,null,null,null,null,null,null,"Overgangsperiode - år",5]
[null,null,null,null,null,null,null,null,"Årstall - Oppstart",2024]
[null,null,null,null,null,null,null,null,"Semester - Oppstart overgansperiode","Høst"]
[]
[null,null,null,null,null,null,null,null,"Terskelverider for tilskudd"]
[null,null,null,null,null,null,null,null,"Terskelverdi","Ingen terskel","Nedtrekksmeny"]
[null,null,null,null,null,null,null,null,"Absolutt verdi (NOK)",null,"Merk: Beregnes med på bakgrunn av absoluttverdi, hvilket innebærer at fortegn i terskelverdi er uvesentlig. Endringer, både positive og negative, innenfor terskelverdien omfattes ikke av overgangsordningen. "]
[null,null,null,null,null,null,null,null,"Prosentvis (%)",null,"Må angis i prosent. Merk: Beregnes med på bakgrunn av absoluttverdi, hvilket innebærer at fortegn i terskelverdi er uvesentlig."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Tabell 1: Beregnet tilskudd gammel modell og ny modell",null,null,null,"Tabell 2: Kompensasjon/reduksjon i tilskudd per år i overgangsperioden"]
[null,"Endring mellom ny og gammel modell (NOK)","Endring mellom ny og gammel modell (%)","Hvis over terskel = 1","Hvis over terskel = 1","Angir terskelverdi som benyttes iht. nedtrekksmeny",null,null,"Skole","Tilskudd 2024 beregnet med gammel modell","Tilskudd 2024 beregnet med ny modell",null,"År 1","År 2","År 3","År 4","År 5"]
[null,"Endring i tilskudd (NOK)","Endring i tilskudd (%)","Terskelverdi (NOK)","Terskelverdi (%)","Terskelverdi ",null,null,null,null,null,null,{"$f":"$J$21","v":2024},{"$f":"M39+1","v":2025},{"$f":"N39+1","v":2026},{"$f":"O39+1","v":2027},{"$f":"P39+1","v":2028}]
[null,{"$f":"K40-J40","v":0},{"$f":"IFERROR(B40/J40,0)","v":0},{"$f":"IF(ABS(B40)>ABS($J$26),1,0)","v":0},{"$f":"IF(ABS(C40)>ABS($J$27),1,0)","v":0},{"$f":"IF($J$25=\"Ingen terskel\",1,IF($J$25=\"NOK terskel\",D40,IF($J$25=\"Prosentvis terskel\",E40)))","v":1},null,null,null,null,null,null,{"$f":"IF($F40=1,-$B40*M$9+(M$8/$C$2*$B40),0)","v":0},0,0,0,0]
[null,{"$f":"K41-J41","v":0},{"$f":"IFERROR(B41/J41,0)","v":0},{"$f":"IF(ABS(B41)>ABS($J$26),1,0)","v":0},{"$f":"IF(ABS(C41)>ABS($J$27),1,0)","v":0},{"$f":"IF($J$25=\"Ingen terskel\",1,IF($J$25=\"NOK terskel\",D41,IF($J$25=\"Prosentvis terskel\",E41)))","v":1},null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,{"$f":"IF($F50=1,-$B50*M$9+(M$8/$C$2*$B50),0)","v":0},0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,0,0,0,0,1,null,null,null,null,null,null,0,0,0,0,0]
[null,{"$f":"K56-J56","v":0},{"$f":"IFERROR(B56/J56,0)","v":0},{"$f":"IF(ABS(B56)>ABS($J$26),1,0)","v":0},{"$f":"IF(ABS(C56)>ABS($J$27),1,0)","v":0},{"$f":"IF($J$25=\"Ingen terskel\",1,IF($J$25=\"NOK terskel\",D56,IF($J$25=\"Prosentvis terskel\",E56)))","v":1}]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,{"$f":"#REF!-J62","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},0,1]
[null,{"$f":"K62-J63","v":0},0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,{"$f":"K66-J66","v":0},{"$f":"IFERROR(B66/J66,0)","v":0},0,0,{"$f":"IF($J$25=\"Ingen terskel\",1,IF($J$25=\"NOK terskel\",D66,IF($J$25=\"Prosentvis terskel\",E66)))","v":1}]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,{"$f":"IF(ABS(B79)>ABS($J$26),1,0)","v":0},{"$f":"IF(ABS(C79)>ABS($J$27),1,0)","v":0},1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]
[null,0,0,0,0,1]

{"sheet":"Datavalidering","index":1,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Antall år",null,"Årstall for oppstart",null,"Semester",null,"Terskel type"]
[null,null,1,null,2023,null,"Høst",null,"Ingen terskel"]
[null,null,2,null,2024,null,"Vår",null,"NOK terskel"]
[null,null,3,null,2025,null,null,null,"Prosentvis terskel"]
[null,null,4,null,2026]
[null,null,5,null,2027]