{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Informasjon","Oppsummering","Investering","Drift","Grunnlag finans","Grunnlag måltall"],"not_rendered":{"charts":5,"images":8,"macros":1,"external_links":0,"defined_names":5,"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":"Informasjon","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,3,6],[5,3,5,6],[5,1,5,2]]}
[]
[null,"HØP 2021-2024                                                                                                                                                         Simuleringsmodell for utarbeidelse av drifts- og investeringsbudsjett"]
[]
[]
[]
[null,"Fyll ut navn til politisk parti:"]

{"sheet":"Oppsummering","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,1,25,4],[4,1,4,5],[16,1,16,4],[1,1,1,3],[2,3,2,5],[6,4,6,5]]}
[]
[null,"Oppsummering av partiets budsjettforslag 2021-2024"]
[null,{"$f":"+Informasjon!D6","v":0}]
[]
[null,{"$f":"IF(SUM(C15:F15)<>0,\"NB! forslaget til driftsbudsjettet er i ubalanse. Vennligst returner til driftsbudsjettet og utfør nødvendige endringer inntil driftsbalansen viser NULL i alle 4 år.\",\"\")","v":""}]
[]
[null,null,null,null,"Beløp i hele tusen kroner"]
[null,"Drift",2021,{"$f":"C8+1","v":2022},{"$f":"D8+1","v":2023},2024]
[null,"Brutto driftsramme iht kommunedirektørens forslag",{"$f":"+Drift!D304","v":12281971},{"$f":"+Drift!E304","v":12216468},{"$f":"+Drift!F304","v":12288554},{"$f":"+Drift!G304","v":12357135}]
[null,"Netto driftsresultat iht. kommunedirektørens forslag",1.9981275709968542E-2,2.8147006230771793E-2,2.9994268148833381E-2,2.7587408474751718E-2]
[]
[null,"Brutto driftsramme iht. partiets forslag (omtrentlig)",{"$f":"+Drift!D305","v":12281971},{"$f":"+Drift!E305","v":12216468},{"$f":"+Drift!F305","v":12288554},{"$f":"+Drift!G305","v":12357135}]
[null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!C59","v":1.9981275709968542E-2},{"$f":"+'Grunnlag måltall'!D59","v":2.8116461714488842E-2},{"$f":"+'Grunnlag måltall'!E59","v":3.0362587182727916E-2},{"$f":"+'Grunnlag måltall'!F59","v":2.7953845201415313E-2}]
[]
[null,{"$f":"+Drift!C15","v":"Sum driftsbalanse (skal være null)"},{"$f":"+Drift!D15","v":0},{"$f":"+Drift!E15","v":0},{"$f":"+Drift!F15","v":0},{"$f":"+Drift!G15","v":0}]
[]
[null,{"$f":"IF(SUM(C22:F22)<>0,\"Foreslåtte endringer i investeringsbudsjettet øker investeringsnivået samlet de neste 4 årene med:\",\"\")","v":""},null,null,null,{"$f":"+SUM(C22:F22)","v":0}]
[]
[null,"Investeringer",2021,{"$f":"C19+1","v":2022},{"$f":"D19+1","v":2023},2024]
[null,"Brutto investeringer iht. kommunedirektørens forslag",{"$f":"+Investering!D9","v":1344850},{"$f":"+Investering!E9","v":1401250},{"$f":"+Investering!F9","v":1262050},{"$f":"+Investering!G9","v":1025825}]
[null,"Brutto investeringer iht. partiets forslag",{"$f":"+Investering!D11","v":1344850},{"$f":"+Investering!E11","v":1401250},{"$f":"+Investering!F11","v":1262050},{"$f":"+Investering!G11","v":1025825}]
[null,"Endring sammenlignet med kommunedirektørens forslag",{"$f":"+C21-C20","v":0},{"$f":"+D21-D20","v":0},0,0]
[]
[null,"Udekket",{"$f":"+Investering!D23","v":0},{"$f":"+Investering!E23","v":0},{"$f":"+Investering!F23","v":0},{"$f":"+Investering!G23","v":0}]
[]
[null,{"$f":"IF(AND(SUM(C32:F32)<>0, F26>0),\"Endringer i låneopptak medfører en økning i kommunens kapitalkostnader sammenlagt for neste 4 år på:\",\"\")","v":""},null,null,null,{"$f":"SUM(C32:F32)","v":0}]
[]
[null,"Låneopptak og finanskostnader ",2021,{"$f":"C28+1","v":2022},{"$f":"D28+1","v":2023},2024]
[null,"Låneopptak iht. kommunedirektørens forslag",{"$f":"+Investering!D13","v":651036.5},{"$f":"+Investering!E13","v":627742.5},{"$f":"+Investering!F13","v":583221.5},{"$f":"+Investering!G13","v":387123}]
[null,"Låneopptak iht. partiets forslag",{"$f":"+Investering!D15","v":651036.5},{"$f":"+Investering!E15","v":627742.5},{"$f":"+Investering!F15","v":583221.5},{"$f":"+Investering!G15","v":387123}]
[null,"Endring sammenlignet med kommunedirektørens forslag",{"$f":"+Investering!D14","v":0},{"$f":"+Investering!E14","v":0},{"$f":"+Investering!F14","v":0},{"$f":"+Investering!G14","v":0}]
[null,"Endring i kapitalkostnader som følge av endring i låneopptak",{"$f":"+'Grunnlag finans'!C41","v":0},{"$f":"+'Grunnlag finans'!D41","v":0},{"$f":"+'Grunnlag finans'!E41","v":0},{"$f":"+'Grunnlag finans'!F41","v":0}]

{"sheet":"Investering","index":2,"n_rows":264,"n_cols":9,"rows_kept":264,"cut":false,"hidden":false,"merged":[[5,6,5,7],[1,2,2,2]]}
[]
[null,null,"Handlings- og økonomiplan 2021-2024                                                                                                                                                               INVESTERINGER"]
[]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[]
[null,null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,"1. Oppsummering",2021,{"$f":"D7+1","v":2022},{"$f":"E7+1","v":2023},2024,"2021-2024"]
[]
[null,null,"Kommunedirektørens forslag til investeringsbudsjett",{"$f":"+D252","v":1344850},{"$f":"+E252","v":1401250},1262050,1025825,{"$f":"+D9+E9+F9+G9","v":5033975}]
[null,null,"Partiets endringer- totale endringer",{"$f":"+D253","v":0},{"$f":"+E253","v":0},{"$f":"+F253","v":0},{"$f":"+G253","v":0},{"$f":"+D10+E10+F10+G10","v":0}]
[null,null,"Nytt forslag til investeringsbudsjett justert for partiets endringer",{"$f":"+D9+D10","v":1344850},{"$f":"+E9+E10","v":1401250},{"$f":"+F9+F10","v":1262050},{"$f":"+G9+G10","v":1025825},{"$f":"+D11+E11+F11+G11","v":5033975}]
[]
[null,null,"Låneopptak iht kommunedirektørens forslag",{"$f":"+D257","v":651036.5},{"$f":"+E257","v":627742.5},583221.5,387123,{"$f":"+G13+F13+E13+D13","v":2249123.5}]
[null,null,"Låneopptak iht. partiet endringer",{"$f":"+D263","v":0},{"$f":"+E263","v":0},{"$f":"+F263","v":0},{"$f":"+G263","v":0},{"$f":"+D14+E14+F14+G14","v":0}]
[null,null,"Nytt nivå på låneopptak justert for partiet endringer",{"$f":"+D13+D14","v":651036.5},{"$f":"+E13+E14","v":627742.5},{"$f":"+F13+F14","v":583221.5},{"$f":"+G13+G14","v":387123},{"$f":"+H13+H14","v":2249123.5}]
[]
[null,null,"Overføring fra drift iht kommunedirektørens forslag",224672,302595,328916,326719,{"$f":"+G17+F17+E17+D17","v":1182902}]
[null,null,"Overføring fra drift iht. partiets endringer",{"$f":"+D260","v":0},{"$f":"+E260","v":0},0,0,{"$f":"+G18+F18+E18+D18","v":0}]
[null,null,"Nytt nivå på overføring fra drift justert for partiets endringer",{"$f":"+D17+D18","v":224672},{"$f":"+E17+E18","v":302595},{"$f":"+F17+F18","v":328916},{"$f":"+G17+G18","v":326719},{"$f":"+H17+H18","v":1182902}]
[]
[null,null,"Udekket iht. kommunedirektørens forslag",{"$f":"+(D257+D258)-D252","v":0},{"$f":"+(E257+E258)-E252","v":0},{"$f":"+(F257+F258)-F252","v":0},{"$f":"+(G257+G258)-G252","v":0},{"$f":"+D21+E21+F21+G21","v":0}]
[]
[null,null,"Udekket iht. partiets forslag",{"$f":"+D264","v":0},{"$f":"+E264","v":0},{"$f":"+F264","v":0},{"$f":"+G264","v":0},{"$f":"+D23+E23+F23+G23","v":0}]
[]
[]
[null,null,"2. HØP 2021-2024- Investeringstabell"]
[null,null,"Diverse bygg og felles investeringer"]
[null,null,"Kommunedirektørens forslag- sum diverse bygg, anlegg og felles investeringer",316425,359925,281925,282100,{"$f":"+G28+F28+E28+D28","v":1240375}]
[null,null,null,null,null,null,null,{"$f":"SUM(D29:G29)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D30:G30)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- diverse bygg og anlegg",{"$f":"SUM(D29:D46)","v":0},{"$f":"SUM(E29:E46)","v":0},0,0,{"$f":"SUM(H29:H46)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- diverse bygg og anlegg",{"$f":"+D28+D47","v":316425},{"$f":"+E28+E47","v":359925},{"$f":"+F28+F47","v":281925},{"$f":"+G28+G47","v":282100},{"$f":"+H28+H47","v":1240375}]
[]
[null,null,"Skole"]
[null,null,"Kommunedirektørens forslag- sum skole",201000,191000,295000,282000,{"$f":"+G51+F51+E51+D51","v":969000}]
[null,null,null,null,null,null,null,{"$f":"SUM(D52:G52)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D53:G53)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- skole",{"$f":"SUM(D52:D70)","v":0},{"$f":"SUM(E52:E70)","v":0},0,0,{"$f":"SUM(H52:H70)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- skole",{"$f":"+D51+D71","v":201000},{"$f":"+E51+E71","v":191000},{"$f":"+F51+F71","v":295000},{"$f":"+G51+G71","v":282000},{"$f":"+H51+H71","v":969000}]
[]
[null,null,"Barnehage "]
[null,null,"Kommunedirektørens forslag- sum barnehage",109000,131500,69000,8000,{"$f":"+G75+F75+E75+D75","v":317500}]
[null,null,null,null,null,null,null,{"$f":"SUM(D76:G76)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D77:G77)","v":0}]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- barnehage",{"$f":"SUM(D76:D94)","v":0},{"$f":"SUM(E76:E94)","v":0},0,0,{"$f":"SUM(H76:H94)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- barnehage",{"$f":"+D75+D95","v":109000},{"$f":"+E75+E95","v":131500},{"$f":"+F75+F95","v":69000},{"$f":"+G75+G95","v":8000},{"$f":"+H75+H95","v":317500}]
[]
[null,null,"Helse og velferd (eks. bolig bygg KF)"]
[null,null,"Kommunedirektørens forslag- sum helse og velferd",118700,161500,91500,27200,{"$f":"+G99+F99+E99+D99","v":398900}]
[null,null,null,null,null,null,null,{"$f":"SUM(D100:G100)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D101:G101)","v":0}]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- levekår",{"$f":"SUM(D100:D117)","v":0},{"$f":"SUM(E100:E117)","v":0},0,0,{"$f":"SUM(H100:H117)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- levekår",{"$f":"+D99+D118","v":118700},{"$f":"+E99+E118","v":161500},91500,{"$f":"+G99+G118","v":27200},{"$f":"+H99+H118","v":398900},18350]
[]
[null,null,"Idrett"]
[null,null,"Kommunedirektørens forslag-  sum idrettsbygg",48000,38750,25500,32500,{"$f":"+G122+F122+E122+D122","v":144750}]
[null,null,null,null,null,null,null,{"$f":"SUM(D123:G123)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D124:G124)","v":0}]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- idrettsbygg",{"$f":"SUM(D123:D141)","v":0},{"$f":"SUM(E123:E141)","v":0},0,0,{"$f":"SUM(H123:H141)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- idrettsbygg",{"$f":"+D122+D142","v":48000},{"$f":"+E122+E142","v":38750},{"$f":"+F122+F142","v":25500},{"$f":"+G122+G142","v":32500},{"$f":"+H122+H142","v":144750}]
[]
[null,null," Vann, avløp og renovasjon"]
[null,null,"Kommunedirektørens forslag-  sum vann, avløp og renovasjon",174900,191800,171100,162900,{"$f":"+G146+F146+E146+D146","v":700700}]
[null,null,null,null,null,null,null,{"$f":"SUM(D147:G147)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D148:G148)","v":0}]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,{"$f":"+D160+E160+F160+G160","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- vann, avløp og renovasjon",{"$f":"SUM(D147:D166)","v":0},{"$f":"SUM(E147:E166)","v":0},0,{"$f":"SUM(G147:G166)","v":0},{"$f":"+H160+H161+H162+H163+H164+H165+H166","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- Vann, avløp og renovasjon",{"$f":"+D146+D167","v":174900},{"$f":"+E146+E167","v":191800},{"$f":"+F146+F167","v":171100},{"$f":"+G146+G167","v":162900},{"$f":"+H146+H167","v":700700}]
[]
[null,null,"Park og vei"]
[null,null,"Kommunedirektørens forslag-  sum park og vei",214525,215075,240525,163525,{"$f":"+G171+F171+E171+D171","v":833650}]
[null,null,null,null,null,null,null,{"$f":"SUM(D172:G172)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D173:G173)","v":0}]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- park og vei",{"$f":"SUM(D172:D191)","v":0},{"$f":"SUM(E172:E191)","v":0},0,0,{"$f":"SUM(H172:H191)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- park og vei",{"$f":"+D171+D192","v":214525},{"$f":"+E171+E192","v":215075},{"$f":"+F171+F192","v":240525},{"$f":"+G171+G192","v":163525},{"$f":"+H171+H192","v":833650}]
[]
[null,null,"Kirkelig fellesråd"]
[null,null,"Kommunedirektørens forslag-  sum kirkelig fellesråd",119100,57200,23000,26600,{"$f":"+G196+F196+E196+D196","v":225900}]
[null,null,null,null,null,null,null,{"$f":"SUM(D197:G197)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D198:G198)","v":0}]
[null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- kirkelig fellesråd",{"$f":"SUM(D197:D213)","v":0},{"$f":"SUM(E197:E213)","v":0},0,0,{"$f":"SUM(H197:H213)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- kirkelig fellesråd",{"$f":"+D196+D214","v":119100},{"$f":"+E196+E214","v":57200},{"$f":"+F196+F214","v":23000},{"$f":"+G196+G214","v":26600},{"$f":"+H196+H214","v":225900}]
[]
[null,null,"Miljø"]
[null,null,"Kommunedirektørens forslag-  sum miljø",2000,23000,23000,0,{"$f":"+G218+F218+E218+D218","v":48000}]
[null,null,null,null,null,null,null,{"$f":"SUM(D219:G219)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(D224:G224)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- miljø",{"$f":"SUM(D219:D229)","v":0},{"$f":"SUM(E219:E229)","v":0},0,0,{"$f":"SUM(H219:H229)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- miljø",{"$f":"+D218+D230","v":2000},{"$f":"+E218+E230","v":23000},{"$f":"+F218+F230","v":23000},{"$f":"+G218+G230","v":0},{"$f":"+H218+H230","v":48000}]
[]
[null,null,"Forvaltning"]
[null,null,"Kommunedirektørens forslag- sum forvaltning",41200,31500,41500,41000,{"$f":"+D234+E234+F234+G234","v":155200}]
[null,null,null,null,null,null,null,{"$f":"SUM(D235:G235)","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(D240:G240)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- miljø",{"$f":"SUM(D235:D245)","v":0},{"$f":"SUM(E235:E245)","v":0},{"$f":"SUM(F235:F245)","v":0},{"$f":"SUM(G235:G245)","v":0},{"$f":"SUM(H235:H245)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- miljø",{"$f":"+D234+D246","v":41200},{"$f":"+E234+E246","v":31500},{"$f":"+F234+F246","v":41500},{"$f":"+G234+G246","v":41000},{"$f":"+H234+H246","v":155200}]
[]
[]
[]
[null,null,"Totale brutto investeringer "]
[null,null,"Kommunedirektørens forslag - totale brutto investeringer",{"$f":"+D234+D218+D196+D171+D146+D122+D99+D75+D51+D28","v":1344850},{"$f":"+E234+E218+E196+E171+E146+E122+E99+E75+E51+E28","v":1401250},1262050,1025825,{"$f":"+D252+E252+F252+G252","v":5033975}]
[null,null,"Partiets endringer- totale endringer ift. kommunedirektørens forslag",{"$f":"+D246+D230+D214+D192+D167+D142+D118+D95+D71+D47","v":0},{"$f":"+E246+E230+E214+E192+E167+E142+E118+E95+E71+E47","v":0},0,0,{"$f":"+D253+E253+F253+G253","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer totalt",{"$f":"+D252+D253","v":1344850},{"$f":"+E252+E253","v":1401250},{"$f":"+F252+F253","v":1262050},{"$f":"+G252+G253","v":1025825},{"$f":"+H252+H253","v":5033975}]
[]
[null,null,"Finansiering "]
[null,null,"Kommunedirektørens forslag låneopptak",651036.5,627742.5,583221.5,387123,{"$f":"+G257+F257+E257+D257","v":2249123.5}]
[null,null,"Kommunedirektørens forslag egenfinansiering",{"$f":"+D252-D257","v":693813.5},{"$f":"+E252-E257","v":773507.5},{"$f":"+F252-F257","v":678828.5},{"$f":"+G252-G257","v":638702},{"$f":"+D258+E258+F258+G258","v":2784851.5}]
[null,null,"Partiets endringer i egenfinansiering føres under:"]
[null,null,"Overføringer fra drift til investering (beregnes i driftsbudsjettet)",{"$f":"+Drift!D291","v":0},{"$f":"+Drift!E291","v":0},{"$f":"+Drift!F291","v":0},{"$f":"+Drift!G291","v":0},{"$f":"+D260+E260+F260+G260","v":0}]
[null,null,"Salgsinntekter",null,null,null,null,{"$f":"+D261+E261+F261+G261","v":0}]
[null,null,"Andre tilskudd",null,null,null,null,{"$f":"+D262+E262+F262+G262","v":0}]
[null,null,"Partiets endring i låneopptak (beregnes automatisk)",{"$f":"D253-(+D260+D261+D262)","v":0},{"$f":"E253-(+E260+E261+E262)","v":0},{"$f":"F253-(+F260+F261+F262)","v":0},{"$f":"G253-(+G260+G261+G262)","v":0},{"$f":"+D263+E263+F263+G263","v":0}]
[null,null,"Udekket iht. partiets endringer",{"$f":"+D254-(D257+D258+D260+D261+D262+D263)","v":0},{"$f":"+E254-(E257+E258+E260+E261+E262+E263)","v":0},{"$f":"+F254-(F257+F258+F260+F261+F262+F263)","v":0},{"$f":"+G254-(G257+G258+G260+G261+G262+G263)","v":0}]

{"sheet":"Drift","index":3,"n_rows":371,"n_cols":8,"rows_kept":371,"cut":false,"hidden":false,"merged":[[182,2,183,6],[306,5,306,6],[1,2,1,7],[6,5,6,6],[20,2,21,6],[242,2,243,6],[55,2,56,6],[93,2,94,6],[123,2,124,6],[153,2,154,6],[212,2,213,6],[296,2,296,6],[272,2,273,6],[3,5,3,6]]}
[]
[null,null,"Handlings- og økonomiplan 2021-2024                                                                                                                                                                                           DRIFT"]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,null,2021,{"$f":"D5+1","v":2022},{"$f":"E5+1","v":2023},{"$f":"F5+1","v":2024}]
[]
[]
[null,null,"1. Oppsummering"]
[]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",{"$f":"+D304","v":12281971},{"$f":"+E304","v":12216468},12288554,12357135]
[null,null,"Netto driftsresultat iht. kommunedirektørens forslag",1.9981275709968542E-2,2.8147006230771793E-2,2.9994268148833381E-2,2.7587408474751718E-2]
[null,null,"Brutto budsjettramme iht. partiets forslag",{"$f":"+D305","v":12281971},{"$f":"+E305","v":12216468},12288554,12357135]
[null,null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!C59","v":1.9981275709968542E-2},{"$f":"+'Grunnlag måltall'!D59","v":2.8116461714488842E-2},{"$f":"+'Grunnlag måltall'!E59","v":3.0362587182727916E-2},{"$f":"+'Grunnlag måltall'!F59","v":2.7953845201415313E-2}]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"D308","v":0},{"$f":"E308","v":0},{"$f":"F308","v":0},{"$f":"G308","v":0}]
[]
[]
[null,null,"2. HØP 2021-2024- driftsrammetabell"]
[]
[]
[null,null,"Oppvekst og utdanning"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",-6442,-78742,-103942,-118942]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",4142481,4070181,4044981,4029981]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D27:D49)","v":0},{"$f":"SUM(E27:E49)","v":0},{"$f":"SUM(F27:F49)","v":0},{"$f":"SUM(G27:G49)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D25+D50","v":4142481},{"$f":"+E25+E50","v":4070181},{"$f":"+F25+F50","v":4044981},{"$f":"+G25+G50","v":4029981}]
[]
[]
[]
[]
[null,null,"Helse og velferd"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",47338,-6932,-22432,6868]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",3792170,3737900,3722400,3751700]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D62:D87)","v":0},{"$f":"SUM(E62:E87)","v":0},{"$f":"SUM(F62:F87)","v":0},{"$f":"SUM(G62:G87)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D60+D88","v":3792170},{"$f":"+E60+E88","v":3737900},{"$f":"+F60+F88","v":3722400},{"$f":"+G60+G88","v":3751700}]
[]
[]
[]
[]
[null,null,"By- og samfunnsplanlegging"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",-2871,-4171,-4571,-4571]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",114126,112826,112426,112426]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D100:D117)","v":0},{"$f":"SUM(E100:E117)","v":0},{"$f":"SUM(F100:F117)","v":0},{"$f":"SUM(G100:G117)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D98+D118","v":114126},{"$f":"+E98+E118","v":112826},{"$f":"+F98+F118","v":112426},{"$f":"+G98+G118","v":112426}]
[]
[]
[]
[]
[null,null,"Bymiljø og utbygging"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",19056,40956,60823,93262]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",1712167,1734067,1753934,1786373]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D130:D147)","v":0},{"$f":"SUM(E130:E147)","v":0},{"$f":"SUM(F130:F147)","v":0},{"$f":"SUM(G130:G147)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D128+D148","v":1712167},{"$f":"+E128+E148","v":1734067},{"$f":"+F128+F148","v":1753934},{"$f":"+G128+G148","v":1786373}]
[]
[]
[]
[]
[null,null,"Innbygger- og samfunnskontakt"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",2170,2370,970,-930]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",296041,296241,294841,292941]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D160:D176)","v":0},{"$f":"SUM(E160:E176)","v":0},{"$f":"SUM(F160:F176)","v":0},{"$f":"SUM(G160:G176)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D158+D177","v":296041},{"$f":"+E158+E177","v":296241},{"$f":"+F158+F177","v":294841},{"$f":"+G158+G177","v":292941}]
[]
[]
[]
[]
[null,null,"Innovasjon og støttetjenester"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",4795,{"$f":"(E187-D187)+D186","v":6795},{"$f":"(F187-E187)+E186","v":4775},4775]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",341696,343696,341676,341676]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D189:D206)","v":0},{"$f":"SUM(E189:E206)","v":0},{"$f":"SUM(F189:F206)","v":0},{"$f":"SUM(G189:G206)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D187+D207","v":341696},{"$f":"+E187+E207","v":343696},{"$f":"+F187+F207","v":341676},{"$f":"+G187+G207","v":341676}]
[]
[]
[]
[]
[null,null,"Økonomi og organisasjon"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",-300,{"$f":"(E217-D217)+D216","v":-1300},{"$f":"(F217-E217)+E216","v":-1300},-1300]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",87482,86482,86482,86482]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D219:D236)","v":0},{"$f":"SUM(E219:E236)","v":0},{"$f":"SUM(F219:F236)","v":0},{"$f":"SUM(G219:G236)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D217+D237","v":87482},{"$f":"+E217+E237","v":86482},{"$f":"+F217+F237","v":86482},{"$f":"+G217+G237","v":86482}]
[]
[]
[]
[]
[null,null,"Felles utgifter "]
[]
[]
[null,null,"Sum endring iht. kommunedirektørens forslag",-57017,-17750,78989,102731]
[null,null,"Budsjettramme iht. kommunedirektørens forslag",1795808,1835075,1931814,1955556]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"+SUM(D249:D267)+D298+D299","v":0},{"$f":"+SUM(E249:E267)+E298+E299","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D247+D268","v":1795808},{"$f":"+E247+E268","v":1835075},1931814,1955556]
[]
[]
[]
[null,null,"Felles inntekter "]
[]
[]
[]
[null,null,"Legg inn dine endringer under:"]
[null,null,"Skatt fra inntekt og formue"]
[null,null,"Rammetilskudd"]
[null,null,"Eiendomsskatt"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Legg inn dine endringer i disposisjonsfond under:"]
[null,null,"Disposisjonsfond "]
[]
[null,null,"Endring i overføring fra drift til investering (klikk på knappen under)",0,0,0,0]
[]
[]
[null,null,"Sum endringer i felles inntekter og utgifter iht. partiets forslag",{"$f":"ROUND(+D279+D280+D285+D268+D278+D286+D287+D289+D291+D281+D282+D283+D284,-1)","v":0},{"$f":"ROUND(+E279+E280+E285+E268+E278+E286+E287+E289+E291+E281+E282+E283+E284,-1)","v":0},0,0]
[]
[]
[null,null,"Endringer i låneopptak i investeringsbudsjettet samt endringer i overføringer fra drift har medført følgende endringer i renter og avdrag:"]
[null,null,"Renter, endret låneopptak (beregnes av modellen)",{"$f":"+'Grunnlag finans'!C36","v":0},{"$f":"+'Grunnlag finans'!D36","v":0},{"$f":"+'Grunnlag finans'!E36","v":0},{"$f":"+'Grunnlag finans'!F36","v":0}]
[null,null,"Endring avdragsbetalinger (beregnes av modellen)",{"$f":"+'Grunnlag finans'!C37","v":0},{"$f":"+'Grunnlag finans'!D37","v":0},{"$f":"+'Grunnlag finans'!E37","v":0},{"$f":"+'Grunnlag finans'!F37","v":0}]
[]
[]
[]
[]
[null,null,"Brutto driftsramme iht. kommunedirektørens forslag",{"$f":"+D247+D217+D187+D158+D128+D98+D60+D25","v":12281971},{"$f":"+E247+E217+E187+E158+E128+E98+E60+E25","v":12216468},12288554,12357135]
[null,null,"Ny brutto driftsramme iht. partiets forslag",{"$f":"+D238+D208+D247+D178+D149+D119+D89+D51+D294","v":12281971},{"$f":"+E238+E208+E247+E178+E149+E119+E89+E51+E294","v":12216468},12288554,12357135]
[]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"ROUND(+D50+D88+D118+D148+D177+D207+D237+D294,-1)","v":0},{"$f":"ROUND(+E50+E88+E118+E148+E177+E207+E237+E294,-1)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"*"]

{"sheet":"Grunnlag finans","index":4,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":true,"merged":[[29,1,29,5],[9,1,9,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Låneopptak "]
[]
[]
[]
[null,"Rådmannens forslag:",2021,{"$f":"C14+1","v":2022},{"$f":"D14+1","v":2023},{"$f":"E14+1","v":2024}]
[null,"Ordinært låneopptak til investeringer",{"$f":"+Investering!D257","v":651036.5},{"$f":"+Investering!E257","v":627742.5},{"$f":"+Investering!F257","v":583221.5},{"$f":"+Investering!G257","v":387123}]
[null,"Startlån"]
[null,"Låneopptak til videre utlån (ikke startlån)"]
[null,"Sum låneopptak rådmannens forslag",{"$f":"+C15+C16+C17","v":651036.5},{"$f":"+D15+D16+D17","v":627742.5},583221.5,387123]
[]
[null,"Partiets forslag til endringer i låneopptak:",2021,{"$f":"C20+1","v":2022},{"$f":"D20+1","v":2023},{"$f":"E20+1","v":2024}]
[null,"Iht. budsjettforslag fra partiet",{"$f":"+Investering!D263","v":0},{"$f":"+Investering!E263","v":0},{"$f":"+Investering!F263","v":0},{"$f":"+Investering!G263","v":0}]
[null,"Startlån"]
[null,"Låneopptak til videre utlån (ikke startlån)"]
[null,"Sum endringer i låneopptak per år iht. partiets forslag",{"$f":"+C21+C22+C23","v":0},{"$f":"+D21+D22+D23","v":0},{"$f":"+E21+E22+E23","v":0},0]
[]
[null,"Nytt låneopptak per år",{"$f":"+C24+C18","v":651036.5},{"$f":"+D24+D18","v":627742.5},583221.5,387123]
[]
[]
[]
[null,"Endring i finanskostnader "]
[]
[null,"Endring i finanskostnader",2021,{"$f":"C32+1","v":2022},{"$f":"D32+1","v":2023},2024]
[null,"Rentesats",1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[null,"Nedbetalingstid (år)",30,30,30,30]
[null,"Nytt lån",{"$f":"+Investering!D263","v":0},{"$f":"+Investering!E263","v":0},{"$f":"+Investering!F263","v":0},{"$f":"+Investering!G263","v":0}]
[null,"Renter",{"$f":"+C35*C33","v":0},{"$f":"+(C39+D35)*D33","v":0},{"$f":"+(D39+E35)*E33","v":0},{"$f":"+(E39+F35)*F33","v":0}]
[null,"Avdrag",{"$f":"+C35/C34","v":0},{"$f":"+(C35+D35)/D34","v":0},{"$f":"+(C35+D35+E35)/E34","v":0},{"$f":"+(C35+D35+E35+F35)/F34","v":0}]
[null,"Sum lån 1.januar",{"$f":"+C35","v":0},{"$f":"+C39+D35","v":0},{"$f":"+D39+E35","v":0},{"$f":"+E39+F35","v":0}]
[null,"Sum lån 31.desember",{"$f":"+C38-C37","v":0},{"$f":"+D38-D37","v":0},{"$f":"+E38-E37","v":0},{"$f":"+F38-F37","v":0}]
[]
[null,"Sum endring finanskostnader",{"$f":"+C36+C37","v":0},{"$f":"+D36+D37","v":0},{"$f":"+E36+E37","v":0},{"$f":"+F36+F37","v":0}]

{"sheet":"Grunnlag måltall","index":5,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Investeringer",2021,{"$f":"C2+1","v":2022},{"$f":"D2+1","v":2023},2024]
[null,"Diverse bygg og felles investeringer",{"$f":"+Investering!D48","v":316425},{"$f":"+Investering!E48","v":359925},{"$f":"+Investering!F48","v":281925},{"$f":"+Investering!G48","v":282100}]
[null,{"$f":"+Investering!C50","v":"Skole"},{"$f":"+Investering!D72","v":201000},{"$f":"+Investering!E72","v":191000},{"$f":"+Investering!F72","v":295000},{"$f":"+Investering!G72","v":282000}]
[null,{"$f":"+Investering!C74","v":"Barnehage "},{"$f":"+Investering!D96","v":109000},{"$f":"+Investering!E96","v":131500},{"$f":"+Investering!F96","v":69000},{"$f":"+Investering!G96","v":8000}]
[null,"Helse og velferd (eks. Bolig bygg KF)",{"$f":"+Investering!D119","v":118700},{"$f":"+Investering!E119","v":161500},{"$f":"+Investering!F119","v":91500},{"$f":"+Investering!G119","v":27200}]
[null,"Idrett",{"$f":"+Investering!D143","v":48000},{"$f":"+Investering!E143","v":38750},{"$f":"+Investering!F143","v":25500},{"$f":"+Investering!G143","v":32500}]
[null,"VAR",{"$f":"+Investering!D168","v":174900},{"$f":"+Investering!E168","v":191800},{"$f":"+Investering!F168","v":171100},{"$f":"+Investering!G168","v":162900}]
[null,"Park og vei",{"$f":"+Investering!D193","v":214525},{"$f":"+Investering!E193","v":215075},{"$f":"+Investering!F193","v":240525},{"$f":"+Investering!G193","v":163525}]
[null,"Kirkebygg",{"$f":"+Investering!D196","v":119100},{"$f":"+Investering!E196","v":57200},{"$f":"+Investering!F196","v":23000},{"$f":"+Investering!G196","v":26600}]
[null,"Miljø",{"$f":"+Investering!D218","v":2000},{"$f":"+Investering!E218","v":23000},{"$f":"+Investering!F218","v":23000},{"$f":"+Investering!G218","v":0}]
[null,"Forvaltning",{"$f":"+Investering!D234","v":41200},{"$f":"+Investering!E234","v":31500},{"$f":"+Investering!F234","v":41500},{"$f":"+Investering!G234","v":41000}]
[]
[null,"Drift",2021,{"$f":"C14+1","v":2022},{"$f":"D14+1","v":2023},2024]
[null,{"$f":"+Drift!C21","v":"Oppvekst og utdanning"},{"$f":"+Drift!D51","v":4142481},{"$f":"+Drift!E51","v":4070181},{"$f":"+Drift!F51","v":4044981},{"$f":"+Drift!G51","v":4029981}]
[null,{"$f":"+Drift!C56","v":"Helse og velferd"},{"$f":"+Drift!D89","v":3792170},{"$f":"+Drift!E89","v":3737900},{"$f":"+Drift!F89","v":3722400},{"$f":"+Drift!G89","v":3751700}]
[null,{"$f":"+Drift!C94","v":"By- og samfunnsplanlegging"},{"$f":"+Drift!D119","v":114126},{"$f":"+Drift!E119","v":112826},{"$f":"+Drift!F119","v":112426},{"$f":"+Drift!G119","v":112426}]
[null,{"$f":"+Drift!C124","v":"Bymiljø og utbygging"},{"$f":"+Drift!D128","v":1712167},{"$f":"+Drift!E128","v":1734067},{"$f":"+Drift!F128","v":1753934},{"$f":"+Drift!G128","v":1786373}]
[null,{"$f":"+Drift!C154","v":"Innbygger- og samfunnskontakt"},{"$f":"+Drift!D158","v":296041},{"$f":"+Drift!E158","v":296241},{"$f":"+Drift!F158","v":294841},{"$f":"+Drift!G158","v":292941}]
[null,{"$f":"Drift!C183","v":"Innovasjon og støttetjenester"},{"$f":"+Drift!D187","v":341696},{"$f":"+Drift!E187","v":343696},{"$f":"+Drift!F187","v":341676},{"$f":"+Drift!G187","v":341676}]
[null,{"$f":"Drift!C213","v":"Økonomi og organisasjon"},{"$f":"+Drift!D217","v":87482},{"$f":"+Drift!E217","v":86482},{"$f":"+Drift!F217","v":86482},{"$f":"+Drift!G217","v":86482}]
[null,{"$f":"Drift!C243","v":"Felles utgifter "},{"$f":"+Drift!D247","v":1795808},{"$f":"+Drift!E247","v":1835075},{"$f":"+Drift!F247","v":1931814},{"$f":"+Drift!G247","v":1955556}]
[null,null,{"$f":"SUM(C15:C22)","v":12281971},{"$f":"SUM(D15:D22)","v":12216468},{"$f":"SUM(E15:E22)","v":12288554},{"$f":"SUM(F15:F22)","v":12357135}]
[]
[null,"Indikator",2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[null,"Egenfinansiering",0.42,0.47,0.45,0.52,0.63,0.56999999999999995,0.37,0.63,{"$f":"1-('Grunnlag finans'!C26/Investering!D254)","v":0.51590400416403315},{"$f":"1-('Grunnlag finans'!D26/Investering!E254)","v":0.5520124888492417},{"$f":"1-('Grunnlag finans'!E26/Investering!F254)","v":0.53787765936373355},{"$f":"1-('Grunnlag finans'!F26/Investering!G254)","v":0.62262276704116193}]
[null,"Måltall > 50 %",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"Netto driftsresultat",1.8524319252252109E-2,-1.2075126972115879E-2,3.2652142332346125E-2,4.9565579636232926E-2,4.4004597237566064E-2,-2.4532503952339312E-3,1.0999999999999999E-2,5.0000000000000001E-3,{"$f":"C46","v":1.9981275709968542E-2},{"$f":"D59","v":2.8116461714488842E-2},3.0362587182727916E-2,2.7953845201415313E-2]
[null,"Måltall > 3 %",0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,"Gjeldsgrad",0.55800000000000005,0.60499999999999998,0.60799999999999998,0.60731135385195023,0.6182518888286751,0.62422977247219669,0.71399999999999997,0.69,{"$f":"C36","v":0.71392122219637788},{"$f":"D36","v":0.77193810333144486},0.81577729032429425,0.83582085340272672]
[null,"Måltall < 60 %",0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[]
[null,"Gjeldsgrad",2021,{"$f":"C33+1","v":2022},{"$f":"D33+1","v":2023},2024]
[null,"Driftsinntekter",{"$f":"+C53","v":11341418},{"$f":"+D53","v":11252625},11294525,11339406]
[null,"Gjeldsnivå for bykassen ekskl. startlån",{"$f":"8096879+'Grunnlag finans'!C39","v":8096879},{"$f":"8686330+'Grunnlag finans'!D39","v":8686330},{"$f":"9213817+'Grunnlag finans'!E39","v":9213817},{"$f":"9477712+'Grunnlag finans'!F39","v":9477712}]
[null,"Gjeldsgrad (oppdateres automatisk)",{"$f":"+C35/C34","v":0.71392122219637788},{"$f":"+D35/D34","v":0.77193810333144486},{"$f":"+E35/E34","v":0.81577729032429425},{"$f":"+F35/F34","v":0.83582085340272672}]
[]
[null,"Netto driftsresultat"]
[null,"Rådmannensforslag",2021,{"$f":"C39+1","v":2022},{"$f":"D39+1","v":2023},2024]
[null,"Driftsinntekter rådmannens forslag",11341418,11252625,11294525,11339406]
[null,"Driftsutgifter rådmannens forslag",11262526,11068783,11075513,11155293]
[null,"Brutto driftsresultat",{"$f":"+C40-C41","v":78892},{"$f":"+D40-D41","v":183842},219012,184113]
[null,"Resultat eksterne finanstransaksjoner",-188423,-206371,-217172,-210141]
[null,"Motpost avskrivninger",336147,338913,341091,343008]
[null,"Nettodriftsresultat",{"$f":"SUM(C42:C44)","v":226616},{"$f":"SUM(D42:D44)","v":316384},342931,316980]
[null,"Nettodriftsresultat i %",{"$f":"+C45/C40","v":1.9981275709968542E-2},{"$f":"+D45/D40","v":2.8116461714488842E-2},3.0362587182727916E-2,2.7953845201415313E-2]
[]
[]
[null,"Endringer",2021,{"$f":"1+C49","v":2022},{"$f":"1+D49","v":2023},2024]
[null,"Politiske endringer i utgifter ift. rådmannens forslag",{"$f":"+Drift!D50+Drift!D88+Drift!D118+Drift!D148+Drift!D177+Drift!D237+Drift!D268","v":0},{"$f":"+Drift!E50+Drift!E88+Drift!E118+Drift!E148+Drift!E177+Drift!E237+Drift!E268","v":0},{"$f":"+Drift!F50+Drift!F88+Drift!F118+Drift!F148+Drift!F177+Drift!F237+Drift!F268","v":0},{"$f":"+Drift!G50+Drift!G88+Drift!G118+Drift!G148+Drift!G177+Drift!G237+Drift!G268","v":0}]
[null,"Politiske endringer i inntekter iht. rådmannens forslag",{"$f":"SUM(Drift!D278:D287)","v":0},{"$f":"SUM(Drift!E278:E287)","v":0},{"$f":"SUM(Drift!F278:F287)","v":0},{"$f":"SUM(Drift!G278:G287)","v":0}]
[]
[null,"Driftsinntekter etter politiske endringer",{"$f":"C40-C51","v":11341418},{"$f":"D40-D51","v":11252625},11294525,11339406]
[null,"Driftutgifter etter politiske endringer",{"$f":"+C41+C50","v":11262526},{"$f":"+D41+D50","v":11068783},11075513,11155293]
[null,"Brutto driftsresultat etter politiske endringer",{"$f":"+C53-C54","v":78892},{"$f":"+D53-D54","v":183842},219012,184113]
[null,"Resultat eksterne finanstransaksjoner",{"$f":"C43","v":-188423},{"$f":"D43","v":-206371},-217172,-210141]
[null,"Motpost avskrivninger",{"$f":"C44","v":336147},{"$f":"D44","v":338913},341091,343008]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C55+C56+C57","v":226616},{"$f":"+D55+D56+D57","v":316384},342931,316980]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C58/C53","v":1.9981275709968542E-2},{"$f":"+D58/D53","v":2.8116461714488842E-2},3.0362587182727916E-2,2.7953845201415313E-2]