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

{"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 2022-2025"]
[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",2022,{"$f":"C8+1","v":2023},{"$f":"D8+1","v":2024},2025]
[null,"Brutto driftsramme iht kommunedirektørens forslag",{"$f":"+Drift!D332","v":13693539},{"$f":"+Drift!E332","v":13816915},{"$f":"+Drift!F332","v":13878376},{"$f":"+Drift!G332","v":13964788}]
[null,"Netto driftsresultat iht. kommunedirektørens forslag",{"$f":"Drift!D11","v":1.6E-2},{"$f":"Drift!E11","v":2.1999999999999999E-2},{"$f":"Drift!F11","v":1.7999999999999999E-2},{"$f":"Drift!G11","v":1.2999999999999999E-2}]
[]
[null,"Brutto driftsramme iht. partiets forslag (omtrentlig)",{"$f":"+Drift!D333","v":13693539},{"$f":"+Drift!E333","v":13816915},{"$f":"+Drift!F333","v":13878376},{"$f":"+Drift!G333","v":13964788}]
[null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!C61","v":1.6251667440946822E-2},{"$f":"+'Grunnlag måltall'!D61","v":2.1602716609027073E-2},{"$f":"+'Grunnlag måltall'!E61","v":1.8220663128695604E-2},{"$f":"+'Grunnlag måltall'!F61","v":1.2735629890386437E-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",{"$f":"C8","v":2022},{"$f":"C19+1","v":2023},{"$f":"D19+1","v":2024},2025]
[null,"Brutto investeringer iht. kommunedirektørens forslag",{"$f":"+Investering!D9","v":1793400},{"$f":"+Investering!E9","v":1815000},{"$f":"+Investering!F9","v":1774950},{"$f":"+Investering!G9","v":1128160}]
[null,"Brutto investeringer iht. partiets forslag",{"$f":"+Investering!D11","v":1793400},{"$f":"+Investering!E11","v":1815000},{"$f":"+Investering!F11","v":1774950},{"$f":"+Investering!G11","v":1128160}]
[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 ",{"$f":"C8","v":2022},{"$f":"C28+1","v":2023},{"$f":"D28+1","v":2024},2025]
[null,"Låneopptak iht. kommunedirektørens forslag",{"$f":"+Investering!D13","v":976486},{"$f":"+Investering!E13","v":1060856},{"$f":"+Investering!F13","v":943998},{"$f":"+Investering!G13","v":323568}]
[null,"Låneopptak iht. partiets forslag",{"$f":"+Investering!D15","v":976486},{"$f":"+Investering!E15","v":1060856},{"$f":"+Investering!F15","v":943998},{"$f":"+Investering!G15","v":323568}]
[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":302,"n_cols":10,"rows_kept":302,"cut":false,"hidden":false,"merged":[[5,6,5,7],[1,2,2,2]]}
[]
[null,null,"Handlings- og økonomiplan 2022-2025                                                                                                                       INVESTERINGER"]
[]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[]
[null,null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,"1. Oppsummering",{"$f":"Oppsummering!C8","v":2022},{"$f":"D7+1","v":2023},{"$f":"E7+1","v":2024},2025,"2022-2025"]
[]
[null,null,"Kommunedirektørens forslag til investeringsbudsjett",{"$f":"+D290","v":1793400},{"$f":"+E290","v":1815000},1774950,1128160,{"$f":"+D9+E9+F9+G9","v":6511510}]
[null,null,"Partiets endringer- totale endringer",{"$f":"+D291","v":0},{"$f":"+E291","v":0},{"$f":"+F291","v":0},{"$f":"+G291","v":0},{"$f":"+D10+E10+F10+G10","v":0}]
[null,null,"Nytt forslag til investeringsbudsjett justert for partiets endringer",{"$f":"+D9+D10","v":1793400},{"$f":"+E9+E10","v":1815000},{"$f":"+F9+F10","v":1774950},{"$f":"+G9+G10","v":1128160},{"$f":"+D11+E11+F11+G11","v":6511510}]
[]
[null,null,"Låneopptak iht kommunedirektørens forslag",{"$f":"+D295","v":976486},{"$f":"+E295","v":1060856},943998,323568,{"$f":"+G13+F13+E13+D13","v":3304908}]
[null,null,"Låneopptak iht. partiet endringer",{"$f":"+D301","v":0},{"$f":"+E301","v":0},{"$f":"+F301","v":0},{"$f":"+G301","v":0},{"$f":"+D14+E14+F14+G14","v":0}]
[null,null,"Nytt nivå på låneopptak justert for partiet endringer",{"$f":"+D13+D14","v":976486},{"$f":"+E13+E14","v":1060856},{"$f":"+F13+F14","v":943998},{"$f":"+G13+G14","v":323568},{"$f":"+H13+H14","v":3304908}]
[]
[null,null,"Overføring fra drift iht kommunedirektørens forslag",233636,286411,228036,148074,{"$f":"+G17+F17+E17+D17","v":896157}]
[null,null,"Overføring fra drift iht. partiets endringer",{"$f":"+D298","v":0},{"$f":"+E298","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":233636},{"$f":"+E17+E18","v":286411},{"$f":"+F17+F18","v":228036},{"$f":"+G17+G18","v":148074},{"$f":"+H17+H18","v":896157}]
[]
[null,null,"Udekket iht. kommunedirektørens forslag",{"$f":"+(D295+D296)-D290","v":0},{"$f":"+(E295+E296)-E290","v":0},{"$f":"+(F295+F296)-F290","v":0},{"$f":"+(G295+G296)-G290","v":0},{"$f":"+D21+E21+F21+G21","v":0}]
[]
[null,null,"Udekket iht. partiets forslag",{"$f":"+D302","v":0},{"$f":"+E302","v":0},{"$f":"+F302","v":0},{"$f":"+G302","v":0},{"$f":"+D23+E23+F23+G23","v":0}]
[]
[]
[null,null,"2. HØP 2022-2025 - Investeringstabell"]
[null,null,"Diverse bygg og felles investeringer"]
[null,null,"Kommunedirektørens forslag- sum diverse bygg, anlegg og felles investeringer",506700,448900,309950,52100,{"$f":"+G28+F28+E28+D28","v":1317650}]
[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,{"$f":"SUM(D37:G37)","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- diverse bygg og anlegg",{"$f":"SUM(D29:D48)","v":0},{"$f":"SUM(E29:E48)","v":0},{"$f":"SUM(F29:F48)","v":0},{"$f":"SUM(G29:G48)","v":0},{"$f":"SUM(H29:H48)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- diverse bygg og anlegg",{"$f":"+D28+D49","v":506700},{"$f":"+E28+E49","v":448900},{"$f":"+F28+F49","v":309950},{"$f":"+G28+G49","v":52100},{"$f":"+H28+H49","v":1317650}]
[]
[null,null,"Skole"]
[null,null,"Kommunedirektørens forslag- sum skole",206500,312900,351600,297000,{"$f":"+G53+F53+E53+D53","v":1168000}]
[null,null,null,null,null,null,null,{"$f":"SUM(D54:G54)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D55:G55)","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,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(D54:D72)","v":0},{"$f":"SUM(E54:E72)","v":0},0,0,{"$f":"SUM(H54:H72)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- skole",{"$f":"+D53+D73","v":206500},{"$f":"+E53+E73","v":312900},{"$f":"+F53+F73","v":351600},{"$f":"+G53+G73","v":297000},{"$f":"+H53+H73","v":1168000}]
[]
[null,null,"Barnehage "]
[null,null,"Kommunedirektørens forslag- sum barnehage",132100,81100,37100,3000,{"$f":"+G77+F77+E77+D77","v":253300}]
[null,null,null,null,null,null,null,{"$f":"SUM(D78:G78)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D79:G79)","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,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(D78:D96)","v":0},{"$f":"SUM(E78:E96)","v":0},0,0,{"$f":"SUM(H78:H96)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- barnehage",{"$f":"+D77+D97","v":132100},{"$f":"+E77+E97","v":81100},{"$f":"+F77+F97","v":37100},{"$f":"+G77+G97","v":3000},{"$f":"+H77+H97","v":253300}]
[]
[null,null,"Helse og velferd"]
[null,null,"Kommunedirektørens forslag- sum helse og velferd",242650,312500,293900,145000,{"$f":"+G101+F101+E101+D101","v":994050}]
[null,null,null,null,null,null,null,{"$f":"SUM(D102:G102)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D103:G103)","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,{"$f":"SUM(D108:G108)","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,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- helse og velferd",{"$f":"SUM(D102:D123)","v":0},{"$f":"SUM(E102:E123)","v":0},0,0,{"$f":"SUM(H102:H123)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- helse og velferd",{"$f":"+D101+D124","v":242650},{"$f":"+E101+E124","v":312500},{"$f":"+F101+F124","v":293900},{"$f":"+G101+G124","v":145000},{"$f":"+H101+H124","v":994050},18350]
[]
[null,null,"Idrett og utemiljø"]
[null,null,"Kommunedirektørens forslag- sum idrett og utemiljø",296250,295300,269850,171500,{"$f":"+G128+F128+E128+D128","v":1032900}]
[null,null,null,null,null,null,null,{"$f":"SUM(D129:G129)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D130:G130)","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,{"$f":"SUM(D133:G133)","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,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,null,null,null,null,null,0]
[null,null,"Sum partiets endringer- idrett og utemiljø",{"$f":"SUM(D129:D158)","v":0},{"$f":"SUM(E129:E158)","v":0},0,0,{"$f":"SUM(H129:H158)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- idrett og utemiljø",{"$f":"+D128+D159","v":296250},{"$f":"+E128+E159","v":295300},{"$f":"+F128+F159","v":269850},{"$f":"+G128+G159","v":171500},{"$f":"+H128+H159","v":1032900}]
[]
[null,null," Vann, avløp, slam og renovasjon"]
[null,null,"Kommunedirektørens forslag- sum vann, avløp, slam og renovasjon",191000,176800,169200,175100,{"$f":"+G163+F163+E163+D163","v":712100}]
[null,null,null,null,null,null,null,{"$f":"SUM(D164:G164)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D165:G165)","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,{"$f":"+D177+E177+F177+G177","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, slam og renovasjon",{"$f":"SUM(D164:D183)","v":0},{"$f":"SUM(E164:E183)","v":0},0,{"$f":"SUM(G164:G183)","v":0},{"$f":"SUM(H164:H183)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- vann, avløp, slam og renovasjon",{"$f":"+D163+D184","v":191000},{"$f":"+E163+E184","v":176800},{"$f":"+F163+F184","v":169200},{"$f":"+G163+G184","v":175100},{"$f":"+H163+H184","v":712100}]
[]
[null,null,"Bolig"]
[null,null,"Kommunedirektørens forslag- sum bolig",110500,122500,96000,60500,{"$f":"+G188+F188+E188+D188","v":389500}]
[null,null,null,null,null,null,null,{"$f":"SUM(D189:G189)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D190:G190)","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,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- bolig",{"$f":"SUM(D189:D208)","v":0},{"$f":"SUM(E189:E208)","v":0},0,0,{"$f":"SUM(H189:H208)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- bolig",{"$f":"+D188+D209","v":110500},{"$f":"+E188+E209","v":122500},{"$f":"+F188+F209","v":96000},{"$f":"+G188+G209","v":60500},{"$f":"+H188+H209","v":389500}]
[]
[null,null,"Kirker"]
[null,null,"Kommunedirektørens forslag- sum kirker",66400,29200,56750,30300,{"$f":"+G213+F213+E213+D213","v":182650}]
[null,null,null,null,null,null,null,{"$f":"SUM(D214:G214)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D215:G215)","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,{"$f":"SUM(D227:G227)","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- kirker",{"$f":"SUM(D214:D233)","v":0},{"$f":"SUM(E214:E233)","v":0},0,0,{"$f":"SUM(H214:H233)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- kirker",{"$f":"+D213+D234","v":66400},{"$f":"+E213+E234","v":29200},{"$f":"+F213+F234","v":56750},{"$f":"+G213+G234","v":30300},{"$f":"+H213+H234","v":182650}]
[]
[null,null,"Klima og miljø"]
[null,null,"Kommunedirektørens forslag- sum klima og miljø",16000,8000,160000,160000,{"$f":"+G238+F238+E238+D238","v":344000}]
[null,null,null,null,null,null,null,{"$f":"SUM(D239:G239)","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,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,{"$f":"SUM(D252:G252)","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,"Sum partiets endringer- klima og miljø",{"$f":"SUM(D239:D256)","v":0},{"$f":"SUM(E239:E256)","v":0},0,0,{"$f":"SUM(H239:H256)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- klima og miljø",{"$f":"+D238+D257","v":16000},{"$f":"+E238+E257","v":8000},{"$f":"+F238+F257","v":160000},{"$f":"+G238+G257","v":160000},{"$f":"+H238+H257","v":344000}]
[]
[null,null,"Investeringer i aksjer og andeler i selskaper"]
[null,null,"Kommunedirektørens forslag- sum investeringer i aksjer og andeler i selskaper",{"$f":"25300","v":25300},27800,30600,33660,{"$f":"+D261+E261+F261+G261","v":117360}]
[null,null,null,null,null,null,null,{"$f":"SUM(D262:G262)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D263:G263)","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,{"$f":"SUM(D274:G274)","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,"Sum partiets endringer- investeringer i aksjer og andeler i selskaper",{"$f":"SUM(D262:D283)","v":0},{"$f":"SUM(E262:E283)","v":0},{"$f":"SUM(F262:F283)","v":0},{"$f":"SUM(G262:G283)","v":0},{"$f":"SUM(H262:H283)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- investeringer i aksjer og andeler i selskaper",{"$f":"+D261+D284","v":25300},{"$f":"+E261+E284","v":27800},{"$f":"+F261+F284","v":30600},{"$f":"+G261+G284","v":33660},{"$f":"+H261+H284","v":117360}]
[]
[]
[]
[null,null,"Totale brutto investeringer "]
[null,null,"Kommunedirektørens forslag- totale brutto investeringer",{"$f":"+D261+D238+D213+D188+D163+D128+D101+D77+D53+D28","v":1793400},{"$f":"+E261+E238+E213+E188+E163+E128+E101+E77+E53+E28","v":1815000},{"$f":"+F261+F238+F213+F188+F163+F128+F101+F77+F53+F28","v":1774950},{"$f":"+G261+G238+G213+G188+G163+G128+G101+G77+G53+G28","v":1128160},{"$f":"+D290+E290+F290+G290","v":6511510}]
[null,null,"Partiets endringer- totale endringer ift. kommunedirektørens forslag",{"$f":"+D284+D257+D234+D209+D184+D159+D124+D97+D73+D49","v":0},{"$f":"+E284+E257+E234+E209+E184+E159+E124+E97+E73+E49","v":0},{"$f":"+F284+F257+F234+F209+F184+F159+F124+F97+F73+F49","v":0},{"$f":"+G284+G257+G234+G209+G184+G159+G124+G97+G73+G49","v":0},{"$f":"+D291+E291+F291+G291","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer totalt",{"$f":"+D290+D291","v":1793400},{"$f":"+E290+E291","v":1815000},{"$f":"+F290+F291","v":1774950},{"$f":"+G290+G291","v":1128160},{"$f":"+H290+H291","v":6511510}]
[]
[null,null,"Finansiering "]
[null,null,"Kommunedirektørens forslag til låneopptak",{"$f":"992316-15000-830","v":976486},1060856,943998,323568,{"$f":"+G295+F295+E295+D295","v":3304908}]
[null,null,"Kommunedirektørens forslag til egenfinansiering",{"$f":"+D290-D295","v":816914},{"$f":"+E290-E295","v":754144},{"$f":"+F290-F295","v":830952},{"$f":"+G290-G295","v":804592},{"$f":"+D296+E296+F296+G296","v":3206602}]
[null,null,"Partiets endringer i egenfinansiering føres under:"]
[null,null,"Overføringer fra drift til investering (beregnes i driftsbudsjettet)",{"$f":"+Drift!D319","v":0},{"$f":"+Drift!E319","v":0},{"$f":"+Drift!F319","v":0},{"$f":"+Drift!G319","v":0},{"$f":"+D298+E298+F298+G298","v":0}]
[null,null,"Salgsinntekter",null,null,null,null,{"$f":"+D299+E299+F299+G299","v":0},null,"Positivt tall gir økt inntekt"]
[null,null,"Andre tilskudd",null,null,null,null,{"$f":"+D300+E300+F300+G300","v":0},null,"Positivt tall gir økt inntekt"]
[null,null,"Partiets endring i låneopptak (beregnes automatisk)",{"$f":"D291-(+D298+D299+D300)","v":0},{"$f":"E291-(+E298+E299+E300)","v":0},{"$f":"F291-(+F298+F299+F300)","v":0},{"$f":"G291-(+G298+G299+G300)","v":0},{"$f":"+D301+E301+F301+G301","v":0}]
[null,null,"Udekket iht. partiets endringer",{"$f":"+D292-(D295+D296+D298+D299+D300+D301)","v":0},{"$f":"+E292-(E295+E296+E298+E299+E300+E301)","v":0},{"$f":"+F292-(F295+F296+F298+F299+F300+F301)","v":0},{"$f":"+G292-(G295+G296+G298+G299+G300+G301)","v":0},{"$f":"SUM(D302:G302)","v":0}]

{"sheet":"Drift","index":3,"n_rows":399,"n_cols":9,"rows_kept":399,"cut":false,"hidden":false,"merged":[[182,2,183,6],[334,5,334,6],[1,2,1,7],[6,5,6,6],[20,2,21,6],[270,2,271,6],[55,2,56,6],[93,2,94,6],[123,2,124,6],[153,2,154,6],[236,2,237,6],[324,2,324,6],[300,2,301,6],[3,5,3,6],[211,2,212,6]]}
[]
[null,null,"Handlings- og økonomiplan 2022-2025\nDRIFT"]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,null,{"$f":"Oppsummering!C8","v":2022},{"$f":"D5+1","v":2023},{"$f":"E5+1","v":2024},{"$f":"F5+1","v":2025}]
[]
[]
[null,null,"1. Oppsummering"]
[]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",{"$f":"+D332","v":13693539},{"$f":"+E332","v":13816915},13878376,13964788]
[null,null,"Netto driftsresultat iht. kommunedirektørens forslag",1.6E-2,2.1999999999999999E-2,1.7999999999999999E-2,1.2999999999999999E-2]
[null,null,"Brutto budsjettramme iht. partiets forslag",{"$f":"+D333","v":13693539},{"$f":"+E333","v":13816915},13878376,13964788]
[null,null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!C61","v":1.6251667440946822E-2},{"$f":"+'Grunnlag måltall'!D61","v":2.1602716609027073E-2},{"$f":"+'Grunnlag måltall'!E61","v":1.8220663128695604E-2},{"$f":"+'Grunnlag måltall'!F61","v":1.2735629890386437E-2}]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"D336","v":0},{"$f":"E336","v":0},{"$f":"F336","v":0},{"$f":"G336","v":0}]
[]
[]
[null,null,"2. HØP 2022-2025 - Drift - Kommunedirektørens forslag til endringer."]
[]
[]
[null,null,"Oppvekst og utdanning"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",38933,5133,-15517,-21817]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",4236486,4202686,4182036,4175736]
[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":4236486},{"$f":"+E25+E50","v":4202686},{"$f":"+F25+F50","v":4182036},{"$f":"+G25+G50","v":4175736}]
[]
[]
[]
[]
[null,null,"Helse og velferd"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",30549,32575,63725,103875]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",3855150,3857176,3888326,3928476]
[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":3855150},{"$f":"+E60+E88","v":3857176},{"$f":"+F60+F88","v":3888326},{"$f":"+G60+G88","v":3928476}]
[]
[]
[]
[]
[null,null,"By- og samfunnsplanlegging"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",10775,7723,4423,4323]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",124516,121464,118164,118064]
[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":124516},{"$f":"+E98+E118","v":121464},{"$f":"+F98+F118","v":118164},{"$f":"+G98+G118","v":118064}]
[]
[]
[]
[]
[null,null,"Bymiljø og utbygging"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",115396,143380,177801,235362]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",2776521,2804505,2838926,2896487]
[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":2776521},{"$f":"+E128+E148","v":2804505},{"$f":"+F128+F148","v":2838926},{"$f":"+G128+G148","v":2896487}]
[]
[]
[]
[]
[null,null,"Innbygger- og samfunnskontakt"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",17867,17387,19787,28617]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",342959,342479,344879,353709]
[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":342959},{"$f":"+E158+E177","v":342479},{"$f":"+F158+F177","v":344879},{"$f":"+G158+G177","v":353709}]
[]
[]
[]
[]
[null,null,"Innovasjon og støttetjenester"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",17682,16862,19662,19662]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",360500,359680,362480,362480]
[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":360500},{"$f":"+E187+E207","v":359680},{"$f":"+F187+F207","v":362480},{"$f":"+G187+G207","v":362480}]
[]
[]
[]
[null,null,"Kommunedirektør og kommuneadvokat"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",1196,1196,1196,1196]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",21414,21414,21414,21414]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D218:D231)","v":0},{"$f":"SUM(E218:E231)","v":0},{"$f":"SUM(F218:F231)","v":0},{"$f":"SUM(G218:G231)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D216+D232","v":21414},{"$f":"+E216+E232","v":21414},{"$f":"+F216+F232","v":21414},{"$f":"+G216+G232","v":21414}]
[]
[]
[]
[null,null,"Økonomi og organisasjon"]
[]
[]
[null,null,"Sum brutto endringer iht. kommunedirektørens forslag",5535,5335,3919,2919]
[null,null,"Brutto budsjettramme iht. kommunedirektørens forslag",99387,99187,97771,96771]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D243:D264)","v":0},{"$f":"SUM(E243:E264)","v":0},{"$f":"SUM(F243:F264)","v":0},{"$f":"SUM(G243:G264)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D241+D265","v":99387},{"$f":"+E241+E265","v":99187},{"$f":"+F241+F265","v":97771},{"$f":"+G241+G265","v":96771}]
[]
[]
[]
[]
[null,null,"Felles utgifter "]
[]
[]
[null,null,"Sum endring iht. kommunedirektørens forslag",125065,256783,272839,260110]
[null,null,"Budsjettramme iht. kommunedirektørens forslag",1876606,2008324,2024380,2011651]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"+SUM(D277:D295)+D326+D327","v":0},{"$f":"+SUM(E277:E295)+E326+E327","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D275+D296","v":1876606},{"$f":"+E275+E296","v":2008324},2024380,2011651]
[]
[]
[]
[null,null,"Felles inntekter "]
[]
[]
[]
[null,null,"Legg inn dine endringer under:","Økt inntekt legges inn som negativt tall (-)"]
[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,null,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(+D307+D308+D313+D296+D306+D314+D315+D317+D319+D309+D310+D311+D312,-1)","v":0},{"$f":"ROUND(+E307+E308+E313+E296+E306+E314+E315+E317+E319+E309+E310+E311+E312,-1)","v":0},0,{"$f":"ROUND(+G307+G308+G313+G296+G306+G314+G315+G317+G319+G309+G310+G311+G312,-1)","v":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":"+D275+D241+D216+D187+D158+D128+D98+D60+D25","v":13693539},{"$f":"+E275+E241+E216+E187+E158+E128+E98+E60+E25","v":13816915},{"$f":"+F275+F241+F216+F187+F158+F128+F98+F60+F25","v":13878376},{"$f":"+G275+G241+G216+G187+G158+G128+G98+G60+G25","v":13964788}]
[null,null,"Ny brutto driftsramme iht. partiets forslag",{"$f":"+D266+D233+D208+D275+D178+D149+D119+D89+D51+D322","v":13693539},{"$f":"+E266+E233+E208+E275+E178+E149+E119+E89+E51+E322","v":13816915},{"$f":"+F266+F233+F208+F275+F178+F149+F119+F89+F51+F322","v":13878376},{"$f":"+G266+G233+G208+G275+G178+G149+G119+G89+G51+G322","v":13964788}]
[]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"ROUND(+D50+D88+D118+D148+D177+D207+D232+D265+D322,-1)","v":0},{"$f":"ROUND(+E50+E88+E118+E148+E177+E207+E232+E265+E322,-1)","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"*"]

{"sheet":"Grunnlag finans","index":4,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":true,"merged":[[29,1,29,5],[9,1,9,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Låneopptak "]
[]
[]
[]
[null,"Rådmannens forslag:",{"$f":"Oppsummering!C8","v":2022},{"$f":"C14+1","v":2023},{"$f":"D14+1","v":2024},{"$f":"E14+1","v":2025}]
[null,"Ordinært låneopptak til investeringer",{"$f":"+Investering!D295","v":976486},{"$f":"+Investering!E295","v":1060856},{"$f":"+Investering!F295","v":943998},{"$f":"+Investering!G295","v":323568}]
[null,"Startlån",null,null,null,null,"Tar ikke med startlån, da dette ikke er med i gjeldsgradberegningen"]
[null,"Låneopptak til videre utlån (ikke startlån)",null,null,null,null,"Tar ikke med videreutlån, da dette ikke er med i gjeldsgradberegningen"]
[null,"Sum låneopptak rådmannens forslag",{"$f":"+C15+C16+C17","v":976486},{"$f":"+D15+D16+D17","v":1060856},943998,323568]
[]
[null,"Partiets forslag til endringer i låneopptak:",{"$f":"Oppsummering!C8","v":2022},{"$f":"C20+1","v":2023},{"$f":"D20+1","v":2024},{"$f":"E20+1","v":2025}]
[null,"Iht. budsjettforslag fra partiet",{"$f":"+Investering!D301","v":0},{"$f":"+Investering!E301","v":0},{"$f":"+Investering!F301","v":0},{"$f":"+Investering!G301","v":0}]
[null,"Startlån",null,null,null,null,"Ikke behov for denne - er ikke med i forslaget i investeringsfanen"]
[null,"Låneopptak til videre utlån (ikke startlån)",null,null,null,null,"Ikke behov for denne - er ikke med i forslaget i investeringsfanen"]
[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":976486},{"$f":"+D24+D18","v":1060856},943998,323568]
[]
[]
[]
[null,"Endring i finanskostnader "]
[]
[null,"Endring i finanskostnader",{"$f":"Oppsummering!C8","v":2022},{"$f":"C32+1","v":2023},{"$f":"D32+1","v":2024},2025]
[null,"Rentesats",1.7999999999999999E-2,2.35E-2,2.5999999999999999E-2,2.6499999999999999E-2]
[null,"Nedbetalingstid (år)",30,30,30,30]
[null,"Nytt lån",{"$f":"+Investering!D301","v":0},{"$f":"+Investering!E301","v":0},{"$f":"+Investering!F301","v":0},{"$f":"+Investering!G301","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":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Investeringer",{"$f":"Oppsummering!C8","v":2022},{"$f":"C2+1","v":2023},{"$f":"D2+1","v":2024},2025]
[null,"Diverse bygg og felles investeringer",{"$f":"+Investering!D50","v":506700},{"$f":"+Investering!E50","v":448900},{"$f":"+Investering!F50","v":309950},{"$f":"+Investering!G50","v":52100}]
[null,{"$f":"+Investering!C52","v":"Skole"},{"$f":"+Investering!D74","v":206500},{"$f":"+Investering!E74","v":312900},{"$f":"+Investering!F74","v":351600},{"$f":"+Investering!G74","v":297000}]
[null,{"$f":"+Investering!C76","v":"Barnehage "},{"$f":"+Investering!D98","v":132100},{"$f":"+Investering!E98","v":81100},{"$f":"+Investering!F98","v":37100},{"$f":"+Investering!G98","v":3000}]
[null,"Helse og velferd (eks. Bolig bygg KF)",{"$f":"+Investering!D125","v":242650},{"$f":"+Investering!E125","v":312500},{"$f":"+Investering!F125","v":293900},{"$f":"+Investering!G125","v":145000}]
[null,"Idrett og utemiljø",{"$f":"+Investering!D160","v":296250},{"$f":"+Investering!E160","v":295300},{"$f":"+Investering!F160","v":269850},{"$f":"+Investering!G160","v":171500}]
[null,"VAR",{"$f":"+Investering!D185","v":191000},{"$f":"+Investering!E185","v":176800},{"$f":"+Investering!F185","v":169200},{"$f":"+Investering!G185","v":175100}]
[null,"Bolig",{"$f":"+Investering!D210","v":110500},{"$f":"+Investering!E210","v":122500},{"$f":"+Investering!F210","v":96000},{"$f":"+Investering!G210","v":60500}]
[null,"Kirker",{"$f":"+Investering!D235","v":66400},{"$f":"+Investering!E235","v":29200},{"$f":"+Investering!F235","v":56750},{"$f":"+Investering!G235","v":30300}]
[null,"Klima og miljø",{"$f":"+Investering!D258","v":16000},{"$f":"+Investering!E258","v":8000},{"$f":"+Investering!F258","v":160000},{"$f":"+Investering!G258","v":160000}]
[null,"Forvaltning",{"$f":"+Investering!D285","v":25300},{"$f":"+Investering!E285","v":27800},{"$f":"+Investering!F285","v":30600},{"$f":"+Investering!G285","v":33660}]
[null,"Totalt",{"$f":"SUM(C3:C12)","v":1793400},{"$f":"SUM(D3:D12)","v":1815000},1774950,1128160]
[]
[null,"Drift",{"$f":"Oppsummering!C8","v":2022},{"$f":"C15+1","v":2023},{"$f":"D15+1","v":2024},2025]
[null,{"$f":"+Drift!C21","v":"Oppvekst og utdanning"},{"$f":"+Drift!D51","v":4236486},{"$f":"+Drift!E51","v":4202686},{"$f":"+Drift!F51","v":4182036},{"$f":"+Drift!G51","v":4175736}]
[null,{"$f":"+Drift!C56","v":"Helse og velferd"},{"$f":"+Drift!D89","v":3855150},{"$f":"+Drift!E89","v":3857176},{"$f":"+Drift!F89","v":3888326},{"$f":"+Drift!G89","v":3928476}]
[null,{"$f":"+Drift!C94","v":"By- og samfunnsplanlegging"},{"$f":"+Drift!D119","v":124516},{"$f":"+Drift!E119","v":121464},{"$f":"+Drift!F119","v":118164},{"$f":"+Drift!G119","v":118064}]
[null,{"$f":"+Drift!C124","v":"Bymiljø og utbygging"},{"$f":"+Drift!D149","v":2776521},{"$f":"+Drift!E149","v":2804505},{"$f":"+Drift!F149","v":2838926},{"$f":"+Drift!G149","v":2896487}]
[null,{"$f":"+Drift!C154","v":"Innbygger- og samfunnskontakt"},{"$f":"+Drift!D178","v":342959},{"$f":"+Drift!E178","v":342479},{"$f":"+Drift!F178","v":344879},{"$f":"+Drift!G178","v":353709}]
[null,{"$f":"Drift!C183","v":"Innovasjon og støttetjenester"},{"$f":"+Drift!D208","v":360500},{"$f":"+Drift!E208","v":359680},{"$f":"+Drift!F208","v":362480},{"$f":"+Drift!G208","v":362480}]
[null,{"$f":"Drift!C212","v":"Kommunedirektør og kommuneadvokat"},{"$f":"Drift!D233","v":21414},{"$f":"Drift!E233","v":21414},{"$f":"Drift!F233","v":21414},{"$f":"Drift!G233","v":21414}]
[null,{"$f":"Drift!C237","v":"Økonomi og organisasjon"},{"$f":"+Drift!D266","v":99387},{"$f":"+Drift!E266","v":99187},{"$f":"+Drift!F266","v":97771},{"$f":"+Drift!G266","v":96771}]
[null,{"$f":"Drift!C271","v":"Felles utgifter "},{"$f":"+Drift!D297","v":1876606},{"$f":"+Drift!E297","v":2008324},{"$f":"+Drift!F297","v":2024380},{"$f":"+Drift!G297","v":2011651}]
[null,"Totalt",{"$f":"SUM(C16:C24)","v":13693539},{"$f":"SUM(D16:D24)","v":13816915},{"$f":"SUM(E16:E24)","v":13878376},{"$f":"SUM(F16:F24)","v":13964788}]
[]
[null,"Indikator",2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[null,"Egenfinansiering",0.42,0.47,0.45,0.52,0.63,0.56999999999999995,0.37,0.56999999999999995,0.44,{"$f":"1-('Grunnlag finans'!C26/Investering!D292)","v":0.4555113192818111},{"$f":"1-('Grunnlag finans'!D26/Investering!E292)","v":0.41550633608815424},{"$f":"1-('Grunnlag finans'!E26/Investering!F292)","v":0.46815515930026197},{"$f":"1-('Grunnlag finans'!F26/Investering!G292)","v":0.71318961849383067}]
[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,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,3.7999999999999999E-2,0.02,{"$f":"C61","v":1.6251667440946822E-2},{"$f":"D61","v":2.1602716609027073E-2},1.8220663128695604E-2,{"$f":"F61","v":1.2735629890386437E-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,0.03]
[null,"Gjeldsgrad",0.55800000000000005,0.60499999999999998,0.60799999999999998,0.60731135385195023,0.6182518888286751,0.62422977247219669,0.71399999999999997,0.65,0.7,{"$f":"C38","v":0.73025573154038925},{"$f":"D38","v":0.79535811288045366},0.85254304767183886,0.85220093770668526]
[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,0.6]
[]
[null,"Gjeldsgrad",{"$f":"Oppsummering!C8","v":2022},{"$f":"C35+1","v":2023},{"$f":"D35+1","v":2024},2025]
[null,"Driftsinntekter",{"$f":"+C55","v":12049902},{"$f":"+D55","v":12137779},12184573,12248393]
[null,"Gjeldsnivå for bykassen ekskl. startlån",{"$f":"8799510+'Grunnlag finans'!C39","v":8799510},{"$f":"9653881+'Grunnlag finans'!D39","v":9653881},{"$f":"10387873+'Grunnlag finans'!E39","v":10387873},{"$f":"10438092+'Grunnlag finans'!F39","v":10438092},"Oppdatert fra Utvikling i lånegjeld - beregnet lånegjeld per 31.12"]
[null,"Gjeldsgrad (oppdateres automatisk)",{"$f":"+C37/C36","v":0.73025573154038925},{"$f":"+D37/D36","v":0.79535811288045366},{"$f":"+E37/E36","v":0.85254304767183886},{"$f":"+F37/F36","v":0.85220093770668526}]
[]
[null,"Netto driftsresultat"]
[null,"Kommunedirektørens forslag",{"$f":"Oppsummering!C8","v":2022},{"$f":"C41+1","v":2023},{"$f":"D41+1","v":2024},2025]
[null,"Driftsinntekter",12049902,12137779,12184573,12248393]
[null,"Driftsutgifter ",12192814,12201293,12242930,12342053]
[null,"Brutto driftsresultat",{"$f":"+C42-C43","v":-142912},{"$f":"+D42-D43","v":-63514},-58357,-93660]
[null,"Resultat eksterne finanstransaksjoner",-215833,-231130,-278513,-311355]
[null,"Motpost avskrivninger",554576,556853,558881,561006]
[null,"Nettodriftsresultat",{"$f":"SUM(C44:C46)","v":195831},{"$f":"SUM(D44:D46)","v":262209},222011,155991]
[null,"Nettodriftsresultat i %",{"$f":"+C47/C42","v":1.6251667440946822E-2},{"$f":"+D47/D42","v":2.1602716609027073E-2},1.8220663128695604E-2,1.2735629890386437E-2]
[]
[]
[null,"Endringer",{"$f":"Oppsummering!C8","v":2022},{"$f":"1+C51","v":2023},{"$f":"1+D51","v":2024},2025]
[null,"Politiske endringer i utgifter ift. kommunedirektørens forslag",{"$f":"+Drift!D50+Drift!D88+Drift!D118+Drift!D148+Drift!D177+Drift!D207+Drift!D232+Drift!D265+Drift!D296","v":0},{"$f":"+Drift!E50+Drift!E88+Drift!E118+Drift!E148+Drift!E177+Drift!E207+Drift!E232+Drift!E265+Drift!E296","v":0},{"$f":"+Drift!F50+Drift!F88+Drift!F118+Drift!F148+Drift!F177+Drift!F207+Drift!F232+Drift!F265+Drift!F296","v":0},{"$f":"+Drift!G50+Drift!G88+Drift!G118+Drift!G148+Drift!G177+Drift!G207+Drift!G232+Drift!G265+Drift!G296","v":0}]
[null,"Politiske endringer i inntekter ift. kommunedirektørens forslag",{"$f":"SUM(Drift!D306:D315)","v":0},{"$f":"SUM(Drift!E306:E315)","v":0},{"$f":"SUM(Drift!F306:F315)","v":0},{"$f":"SUM(Drift!G306:G315)","v":0}]
[]
[null,"Driftsinntekter etter politiske endringer",{"$f":"C42-C53","v":12049902},{"$f":"D42-D53","v":12137779},12184573,12248393]
[null,"Driftutgifter etter politiske endringer",{"$f":"+C43+C52","v":12192814},{"$f":"+D43+D52","v":12201293},12242930,12342053]
[null,"Brutto driftsresultat etter politiske endringer",{"$f":"+C55-C56","v":-142912},{"$f":"+D55-D56","v":-63514},-58357,-93660]
[null,"Resultat eksterne finanstransaksjoner",{"$f":"C45","v":-215833},{"$f":"D45","v":-231130},-278513,-311355]
[null,"Motpost avskrivninger",{"$f":"C46","v":554576},{"$f":"D46","v":556853},558881,561006]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C57+C58+C59","v":195831},{"$f":"+D57+D58+D59","v":262209},222011,155991]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C60/C55","v":1.6251667440946822E-2},{"$f":"+D60/D55","v":2.1602716609027073E-2},1.8220663128695604E-2,1.2735629890386437E-2]