{"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 2020-2023                                                                                                                                                         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 2020-2023"]
[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",2020,{"$f":"C8+1","v":2021},{"$f":"D8+1","v":2022},2023]
[null,"Brutto driftsramme iht rådmannens forslag",{"$f":"+Drift!D238","v":12229007},{"$f":"+Drift!E238","v":12175895},{"$f":"+Drift!F238","v":12218170},{"$f":"+Drift!G238","v":12253472}]
[null,"Netto driftsresultat iht. rådmannens forslag",{"$f":"+Drift!D11","v":8.0000000000000002E-3},{"$f":"+Drift!E11","v":8.0000000000000002E-3},{"$f":"+Drift!F11","v":7.0000000000000001E-3},{"$f":"+Drift!G11","v":1E-3}]
[]
[null,"Brutto driftsramme iht. partiets forslag (omtrentlig)",{"$f":"+Drift!D239","v":12229007},{"$f":"+Drift!E239","v":12175895},{"$f":"+Drift!F239","v":12218170},{"$f":"+Drift!G239","v":12253472}]
[null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!J28","v":8.2618429926718077E-3},{"$f":"+'Grunnlag måltall'!K28","v":7.7594577197368378E-3},{"$f":"+'Grunnlag måltall'!L28","v":6.889097693314577E-3},{"$f":"+'Grunnlag måltall'!M28","v":1.0289095361964659E-3}]
[]
[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",2020,2021,2022,2023]
[null,"Brutto investeringer iht. rådmannens forslag",{"$f":"+Investering!D9","v":1171890},{"$f":"+Investering!E9","v":1205813},{"$f":"+Investering!F9","v":1472843},{"$f":"+Investering!G9","v":1395643}]
[null,"Brutto investeringer iht. partiets forslag",{"$f":"+Investering!D11","v":1171890},{"$f":"+Investering!E11","v":1205813},{"$f":"+Investering!F11","v":1472843},{"$f":"+Investering!G11","v":1395643}]
[null,"Endring sammenlignet med rådmannens 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 ",2020,2021,2022,2023]
[null,"Låneopptak iht. rådmannens forslag",{"$f":"+Investering!D13","v":400784},{"$f":"+Investering!E13","v":792788},{"$f":"+Investering!F13","v":855363},{"$f":"+Investering!G13","v":1017395}]
[null,"Låneopptak iht. partiets forslag",{"$f":"+Investering!D15","v":400784},{"$f":"+Investering!E15","v":792788},{"$f":"+Investering!F15","v":855363},{"$f":"+Investering!G15","v":1017395}]
[null,"Endring sammenlignet med rådmannens 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":208,"n_cols":9,"rows_kept":208,"cut":false,"hidden":false,"merged":[[5,6,5,7],[1,2,2,2]]}
[]
[null,null,"Handlings- og økonomiplan 2020-2023                                                                                                                                                               INVESTERINGER"]
[]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[]
[null,null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,"1. Oppsummering",2020,{"$f":"D7+1","v":2021},{"$f":"E7+1","v":2022},2023,"2020-2023"]
[]
[null,null,"Rådmannens forslag til investeringsbudsjett",{"$f":"+D196","v":1171890},{"$f":"+E196","v":1205813},1472843,1395643,{"$f":"+D9+E9+F9+G9","v":5246189}]
[null,null,"Partiets endringer- totale endringer",{"$f":"+D197","v":0},{"$f":"+E197","v":0},{"$f":"+F197","v":0},{"$f":"+G197","v":0},{"$f":"+D10+E10+F10+G10","v":0}]
[null,null,"Nytt forslag til investeringsbudsjett justert for partiets endringer",{"$f":"+D9+D10","v":1171890},{"$f":"+E9+E10","v":1205813},{"$f":"+F9+F10","v":1472843},{"$f":"+G9+G10","v":1395643},{"$f":"+D11+E11+F11+G11","v":5246189}]
[]
[null,null,"Låneopptak iht rådmannens forslag",{"$f":"+D201","v":400784},{"$f":"+E201","v":792788},855363,1017395,{"$f":"+G13+F13+E13+D13","v":3066330}]
[null,null,"Låneopptak iht. partiet endringer",{"$f":"+D207","v":0},{"$f":"+E207","v":0},{"$f":"+F207","v":0},{"$f":"+G207","v":0},{"$f":"+D14+E14+F14+G14","v":0}]
[null,null,"Nytt nivå på låneopptak justert for partiet endringer",{"$f":"+D13+D14","v":400784},{"$f":"+E13+E14","v":792788},{"$f":"+F13+F14","v":855363},{"$f":"+G13+G14","v":1017395},{"$f":"+H13+H14","v":3066330}]
[]
[null,null,"Overføring fra drift iht rådmannens forslag",194631,120121,103754,47879,{"$f":"+G17+F17+E17+D17","v":466385}]
[null,null,"Overføring fra drift iht. partiets endringer",{"$f":"+D204","v":0},{"$f":"+E204","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":194631},{"$f":"+E17+E18","v":120121},{"$f":"+F17+F18","v":103754},{"$f":"+G17+G18","v":47879},{"$f":"+H17+H18","v":466385}]
[]
[null,null,"Udekket iht. rådmannens forslag",{"$f":"+(D201+D202)-D196","v":0},{"$f":"+(E201+E202)-E196","v":0},{"$f":"+(F201+F202)-F196","v":0},{"$f":"+(G201+G202)-G196","v":0},{"$f":"+D21+E21+F21+G21","v":0}]
[]
[null,null,"Udekket iht. partiets forslag",{"$f":"+D208","v":0},{"$f":"+E208","v":0},{"$f":"+F208","v":0},{"$f":"+G208","v":0},{"$f":"+D23+E23+F23+G23","v":0}]
[]
[]
[null,null,"2. HØP 2020-2023- Investeringstabell"]
[null,null,"Diverse bygg og felles investeringer"]
[null,null,"Rådmannens forslag- sum diverse bygg, anlegg og felles investeringer",222032,230350,367430,359180,{"$f":"+G28+F28+E28+D28","v":1178992}]
[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:D40)","v":0},{"$f":"SUM(E29:E40)","v":0},0,0,{"$f":"SUM(H29:H40)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- diverse bygg og anlegg",{"$f":"+D28+D41","v":222032},{"$f":"+E28+E41","v":230350},{"$f":"+F28+F41","v":367430},{"$f":"+G28+G41","v":359180},{"$f":"+H28+H41","v":1178992}]
[]
[null,null,"Skole"]
[null,null,"Rådmannens forslag- sum skole",149500,182400,172000,298000,{"$f":"+G45+F45+E45+D45","v":801900}]
[null,null,null,null,null,null,null,{"$f":"SUM(D46:G46)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D47:G47)","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(D46:D57)","v":0},{"$f":"SUM(E46:E57)","v":0},0,0,{"$f":"SUM(H46:H57)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- skole",{"$f":"+D45+D58","v":149500},{"$f":"+E45+E58","v":182400},{"$f":"+F45+F58","v":172000},{"$f":"+G45+G58","v":298000},{"$f":"+H45+H58","v":801900}]
[]
[null,null,"Barnehage "]
[null,null,"Rådmannens forslag- sum barnehage",103800,62000,161000,64000,{"$f":"+G62+F62+E62+D62","v":390800}]
[null,null,null,null,null,null,null,{"$f":"SUM(D63:G63)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D64:G64)","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(D63:D74)","v":0},{"$f":"SUM(E63:E74)","v":0},0,0,{"$f":"SUM(H63:H74)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- barnehage",{"$f":"+D62+D75","v":103800},{"$f":"+E62+E75","v":62000},{"$f":"+F62+F75","v":161000},{"$f":"+G62+G75","v":64000},{"$f":"+H62+H75","v":390800}]
[]
[null,null,"Helse og velferd (eks. bolig bygg KF)"]
[null,null,"Rådmannens forslag- sum levekår",126100,167000,190500,166500,{"$f":"+G79+F79+E79+D79","v":650100}]
[null,null,null,null,null,null,null,{"$f":"SUM(D80:G80)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D81:G81)","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(D80:D91)","v":0},{"$f":"SUM(E80:E91)","v":0},0,0,{"$f":"SUM(H80:H91)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- levekår",{"$f":"+D79+D92","v":126100},{"$f":"+E79+E92","v":167000},190500,{"$f":"+G79+G92","v":166500},{"$f":"+H79+H92","v":650100},18350]
[]
[null,null,"Idrett"]
[null,null,"Rådmannens forslag-  sum idrettsbygg",39600,31000,48750,55500,{"$f":"+G96+F96+E96+D96","v":174850}]
[null,null,null,null,null,null,null,{"$f":"SUM(D97:G97)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D98:G98)","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(D97:D110)","v":0},{"$f":"SUM(E97:E110)","v":0},0,0,{"$f":"SUM(H97:H110)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- idrettsbygg",{"$f":"+D96+D111","v":39600},{"$f":"+E96+E111","v":31000},{"$f":"+F96+F111","v":48750},{"$f":"+G96+G111","v":55500},{"$f":"+H96+H111","v":174850}]
[]
[null,null," Vann, avløp og renovasjon"]
[null,null,"Rådmannens forslag-  sum vann, avløp og renovasjon",{"$f":"73140+80860+4100","v":158100},{"$f":"71040+84660+4100","v":159800},{"$f":"76440+91760+4100","v":172300},{"$f":"70440+95960+4100","v":170500},{"$f":"+G115+F115+E115+D115","v":660700}]
[null,null,null,null,null,null,null,{"$f":"SUM(D116:G116)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D117:G117)","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":"+D123+E123+F123+G123","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(D116:D129)","v":0},{"$f":"SUM(E116:E129)","v":0},0,{"$f":"SUM(G116:G129)","v":0},{"$f":"+H123+H124+H125+H126+H127+H128+H129","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- Vann, avløp og renovasjon",{"$f":"+D115+D130","v":158100},{"$f":"+E115+E130","v":159800},{"$f":"+F115+F130","v":172300},{"$f":"+G115+G130","v":170500},{"$f":"+H115+H130","v":660700}]
[]
[null,null,"Park og vei"]
[null,null,"Rådmannens forslag-  sum park og vei",222475,208575,215575,213775,{"$f":"+G134+F134+E134+D134","v":860400}]
[null,null,null,null,null,null,null,{"$f":"SUM(D135:G135)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D136:G136)","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(D135:D147)","v":0},{"$f":"SUM(E135:E147)","v":0},0,0,{"$f":"SUM(H135:H147)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- park og vei",{"$f":"+D134+D148","v":222475},{"$f":"+E134+E148","v":208575},{"$f":"+F134+F148","v":215575},{"$f":"+G134+G148","v":213775},{"$f":"+H134+H148","v":860400}]
[]
[null,null,"Kirkelig fellesråd"]
[null,null,"Rådmannens forslag-  sum kirkelig fellesråd",95920,101500,93100,27000,{"$f":"+G152+F152+E152+D152","v":317520}]
[null,null,null,null,null,null,null,{"$f":"SUM(D153:G153)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D154:G154)","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(D153:D165)","v":0},{"$f":"SUM(E153:E165)","v":0},0,0,{"$f":"SUM(H153:H165)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- kirkelig fellesråd",{"$f":"+D152+D166","v":95920},{"$f":"+E152+E166","v":101500},{"$f":"+F152+F166","v":93100},{"$f":"+G152+G166","v":27000},{"$f":"+H152+H166","v":317520}]
[]
[null,null,"Miljø"]
[null,null,"Rådmannens forslag-  sum miljø",null,15000,15000,15000,{"$f":"+G170+F170+E170+D170","v":45000}]
[null,null,null,null,null,null,null,{"$f":"SUM(D171:G171)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D172:G172)","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(D171:D177)","v":0},{"$f":"SUM(E171:E177)","v":0},0,0,{"$f":"SUM(H171:H177)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- miljø",{"$f":"+D170+D178","v":0},{"$f":"+E170+E178","v":15000},{"$f":"+F170+F178","v":15000},{"$f":"+G170+G178","v":15000},{"$f":"+H170+H178","v":45000}]
[]
[null,null,"Forvaltning"]
[null,null,"Rådmannens forslag- sum forvaltning",54363,48188,37188,26188,{"$f":"+D182+E182+F182+G182","v":165927}]
[null,null,null,null,null,null,null,{"$f":"SUM(D183:G183)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(D184:G184)","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- forvaltning",{"$f":"SUM(D183:D189)","v":0},{"$f":"SUM(E183:E189)","v":0},{"$f":"SUM(F183:F189)","v":0},{"$f":"SUM(G183:G189)","v":0},{"$f":"SUM(H183:H189)","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer- miljø",{"$f":"+D182+D190","v":54363},{"$f":"+E182+E190","v":48188},{"$f":"+F182+F190","v":37188},{"$f":"+G182+G190","v":26188},{"$f":"+H182+H190","v":165927}]
[]
[]
[]
[null,null,"Totale brutto investeringer "]
[null,null,"Rådmannens forslag- totale brutto investeringer",{"$f":"+D182+D170+D152+D134+D115+D96+D79+D62+D45+D28","v":1171890},{"$f":"+E182+E170+E152+E134+E115+E96+E79+E62+E45+E28","v":1205813},1472843,1395643,{"$f":"+D196+E196+F196+G196","v":5246189}]
[null,null,"Partiets endringer- totale endringer ift. Rådmannens forslag",{"$f":"+D190+D178+D166+D148+D130+D111+D92+D75+D58+D41","v":0},{"$f":"+E190+E178+E166+E148+E130+E111+E92+E75+E58+E41","v":0},0,0,{"$f":"+D197+E197+F197+G197","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer totalt",{"$f":"+D196+D197","v":1171890},{"$f":"+E196+E197","v":1205813},{"$f":"+F196+F197","v":1472843},{"$f":"+G196+G197","v":1395643},{"$f":"+H196+H197","v":5246189}]
[]
[null,null,"Finansiering "]
[null,null,"Rådmannens forslag låneopptak",400784,792788,855363,1017395,{"$f":"+G201+F201+E201+D201","v":3066330}]
[null,null,"Rådmannensforslag egenfinansiering",{"$f":"+D196-D201","v":771106},{"$f":"+E196-E201","v":413025},{"$f":"+F196-F201","v":617480},{"$f":"+G196-G201","v":378248},{"$f":"+D202+E202+F202+G202","v":2179859}]
[null,null,"Partiets endringer i egenfinansiering føres under:"]
[null,null,"Overføringer fra drift til investering (beregnes i driftsbudsjettet)",{"$f":"+Drift!D225","v":0},{"$f":"+Drift!E225","v":0},{"$f":"+Drift!F225","v":0},{"$f":"+Drift!G225","v":0},{"$f":"+D204+E204+F204+G204","v":0}]
[null,null,"Salgsinntekter",null,null,null,null,{"$f":"+D205+E205+F205+G205","v":0}]
[null,null,"Andre tilskudd",null,null,null,null,{"$f":"+D206+E206+F206+G206","v":0}]
[null,null,"Partiets endring i låneopptak (beregnes automatisk)",{"$f":"D197-(+D204+D205+D206)","v":0},{"$f":"E197-(+E204+E205+E206)","v":0},{"$f":"F197-(+F204+F205+F206)","v":0},{"$f":"G197-(+G204+G205+G206)","v":0},{"$f":"+D207+E207+F207+G207","v":0}]
[null,null,"Udekket iht. partiets endringer",{"$f":"+D198-(D201+D202+D204+D205+D206+D207)","v":0},{"$f":"+E198-(E201+E202+E204+E205+E206+E207)","v":0},{"$f":"+F198-(F201+F202+F204+F205+F206+F207)","v":0},{"$f":"+G198-(G201+G202+G204+G205+G206+G207)","v":0}]

{"sheet":"Drift","index":3,"n_rows":305,"n_cols":8,"rows_kept":305,"cut":false,"hidden":false,"merged":[[140,2,141,6],[240,5,240,6],[1,2,1,7],[6,5,6,6],[20,2,21,6],[184,2,185,6],[47,2,48,6],[74,2,75,6],[96,2,97,6],[118,2,119,6],[162,2,163,6],[230,2,230,6],[206,2,207,6],[3,5,3,6]]}
[]
[null,null,"Handlings- og økonomiplan 2020-2023                                                                                                                                                                                           DRIFT"]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,null,2020,{"$f":"D5+1","v":2021},{"$f":"E5+1","v":2022},{"$f":"F5+1","v":2023}]
[]
[]
[null,null,"1. Oppsummering"]
[]
[null,null,"Brutto budsjettramme iht. rådmannnens forslag",{"$f":"+D238","v":12229007},{"$f":"+E238","v":12175895},12218170,12253472]
[null,null,"Netto driftsresultat iht. rådmannens forslag",8.0000000000000002E-3,8.0000000000000002E-3,7.0000000000000001E-3,1E-3]
[null,null,"Brutto budsjettramme iht. partiets forslag",{"$f":"+D239","v":12229007},{"$f":"+E239","v":12175895},12218170,12253472]
[null,null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!C59","v":8.2618429926718077E-3},{"$f":"+'Grunnlag måltall'!D59","v":7.7594577197368378E-3},{"$f":"+'Grunnlag måltall'!E59","v":6.889097693314577E-3},{"$f":"+'Grunnlag måltall'!F59","v":1.0289095361964659E-3}]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"D242","v":0},{"$f":"E242","v":0},{"$f":"F242","v":0},{"$f":"G242","v":0}]
[]
[]
[null,null,"2. HØP 2020-2023- driftsrammetabell"]
[]
[]
[null,null,"Oppvekst og utdanning"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",150559,{"$f":"(E25-D25)+D24","v":121452},{"$f":"(F25-E25)+E24","v":111054},{"$f":"(G25-F25)+F24","v":117848}]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",4125272,4096165,4085767,4092561]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D27:D41)","v":0},{"$f":"SUM(E27:E41)","v":0},{"$f":"SUM(F27:F41)","v":0},{"$f":"SUM(G27:G41)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D25+D42","v":4125272},{"$f":"+E25+E42","v":4096165},{"$f":"+F25+F42","v":4085767},{"$f":"+G25+G42","v":4092561}]
[]
[]
[]
[]
[null,null,"Helse og velferd"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",-210000,{"$f":"(E52-D52)+D51","v":-197396},{"$f":"(F52-E52)+E51","v":-184446},-168246]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",3740961,3753565,3766515,3782715]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D54:D68)","v":0},{"$f":"SUM(E54:E68)","v":0},{"$f":"SUM(F54:F68)","v":0},{"$f":"SUM(G54:G68)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D52+D69","v":3740961},{"$f":"+E52+E69","v":3753565},{"$f":"+F52+F69","v":3766515},{"$f":"+G52+G69","v":3782715}]
[]
[]
[]
[]
[null,null,"By- og samfunnsplanlegging"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",347,{"$f":"(E79-D79)+D78","v":247},{"$f":"(F79-E79)+E78","v":-253},-253]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",123385,123285,122785,122785]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D81:D90)","v":0},{"$f":"SUM(E81:E90)","v":0},{"$f":"SUM(F81:F90)","v":0},{"$f":"SUM(G81:G90)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D79+D91","v":123385},{"$f":"+E79+E91","v":123285},{"$f":"+F79+F91","v":122785},{"$f":"+G79+G91","v":122785}]
[]
[]
[]
[]
[null,null,"Bymiljø og utbygging"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",64610,{"$f":"(E101-D101)+D100","v":79140},{"$f":"(F101-E101)+E100","v":111760},136829]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",1700898,1715428,1748048,1773117]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D103:D112)","v":0},{"$f":"SUM(E103:E112)","v":0},{"$f":"SUM(F103:F112)","v":0},{"$f":"SUM(G103:G112)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D101+D113","v":1700898},{"$f":"+E101+E113","v":1715428},{"$f":"+F101+F113","v":1748048},{"$f":"+G101+G113","v":1773117}]
[]
[]
[]
[]
[null,null,"Innbygger- og samfunnskontakt"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",38218,{"$f":"(E123-D123)+D122","v":34599},{"$f":"(F123-E123)+E122","v":32597},32597]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",295960,292341,290339,290339]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D125:D134)","v":0},{"$f":"SUM(E125:E134)","v":0},{"$f":"SUM(F125:F134)","v":0},{"$f":"SUM(G125:G134)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D123+D135","v":295960},{"$f":"+E123+E135","v":292341},{"$f":"+F123+F135","v":290339},{"$f":"+G123+G135","v":290339}]
[]
[]
[]
[]
[null,null,"Innovasjon og støttetjenester"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",17419,{"$f":"(E145-D145)+D144","v":9302},{"$f":"(F145-E145)+E144","v":9302},9302]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",336982,328865,328865,328865]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D147:D156)","v":0},{"$f":"SUM(E147:E156)","v":0},{"$f":"SUM(F147:F156)","v":0},{"$f":"SUM(G147:G156)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D145+D157","v":336982},{"$f":"+E145+E157","v":328865},{"$f":"+F145+F157","v":328865},{"$f":"+G145+G157","v":328865}]
[]
[]
[]
[]
[null,null,"Økonomi og organisasjon"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",4525,{"$f":"(E167-D167)+D166","v":4525},{"$f":"(F167-E167)+E166","v":4525},4525]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",90333,90333,90333,90333]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D169:D178)","v":0},{"$f":"SUM(E169:E178)","v":0},{"$f":"SUM(F169:F178)","v":0},{"$f":"SUM(G169:G178)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D167+D179","v":90333},{"$f":"+E167+E179","v":90333},{"$f":"+F167+F179","v":90333},{"$f":"+G167+G179","v":90333}]
[]
[]
[]
[]
[null,null,"Felles utgifter "]
[]
[]
[null,null,"Sum endring iht. rådmannens forslag",124696,{"$f":"(E189-D189)+D188","v":85393},{"$f":"(F189-E189)+E188","v":94998},82237]
[null,null,"Budsjettramme iht. rådmannens forslag",1815216,1775913,1785518,1772757]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"+D191+D196+D197+D198+D199+D200+D201+D232+D233+D192+D193+D194+D195","v":0},{"$f":"+E191+E196+E197+E198+E199+E200+E201+E232+E233+E192+E193+E194+E195","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D189+D202","v":1815216},{"$f":"+E189+E202","v":1775913},1785518,1772757]
[]
[]
[]
[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(+D213+D214+D219+D202+D212+D220+D221+D223+D225+D215+D216+D217+D218,-1)","v":0},{"$f":"ROUND(+E213+E214+E219+E202+E212+E220+E221+E223+E225+E215+E216+E217+E218,-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. rådmannens forslag",{"$f":"+D189+D167+D145+D123+D101+D79+D52+D25","v":12229007},{"$f":"+E189+E167+E145+E123+E101+E79+E52+E25","v":12175895},12218170,12253472]
[null,null,"Ny brutto driftsramme iht. partiets forslag",{"$f":"+D180+D158+D203+D136+D114+D92+D70+D43+D228","v":12229007},{"$f":"+E180+E158+E203+E136+E114+E92+E70+E43+E228","v":12175895},12218170,12253472]
[]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"ROUND(+D42+D69+D91+D113+D135+D157+D179+D228,-1)","v":0},{"$f":"ROUND(+E42+E69+E91+E113+E135+E157+E179+E228,-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:",2020,{"$f":"C14+1","v":2021},{"$f":"D14+1","v":2022},{"$f":"E14+1","v":2023}]
[null,"Ordinært låneopptak til investeringer",{"$f":"+Investering!D201","v":400784},{"$f":"+Investering!E201","v":792788},{"$f":"+Investering!F201","v":855363},{"$f":"+Investering!G201","v":1017395}]
[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":400784},{"$f":"+D15+D16+D17","v":792788},855363,1017395]
[]
[null,"Partiets forslag til endringer i låneopptak:",2020,{"$f":"C20+1","v":2021},{"$f":"D20+1","v":2022},{"$f":"E20+1","v":2023}]
[null,"Iht. budsjettforslag fra partiet",{"$f":"+Investering!D207","v":0},{"$f":"+Investering!E207","v":0},{"$f":"+Investering!F207","v":0},{"$f":"+Investering!G207","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":400784},{"$f":"+D24+D18","v":792788},855363,1017395]
[]
[]
[]
[null,"Endring i finanskostnader "]
[]
[null,"Endring i finanskostnader",2020,{"$f":"C32+1","v":2021},{"$f":"D32+1","v":2022},2023]
[null,"Rentesats",2.5999999999999999E-2,2.5999999999999999E-2,2.5499999999999998E-2,2.5499999999999998E-2]
[null,"Nedbetalingstid (år)",30,30,30,30]
[null,"Nytt lån",{"$f":"+Investering!D207","v":0},{"$f":"+Investering!E207","v":0},{"$f":"+Investering!F207","v":0},{"$f":"+Investering!G207","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":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Investeringer",2020,2021,2022,2023]
[null,"Diverse bygg og felles investeringer",{"$f":"+Investering!D42","v":222032},{"$f":"+Investering!E42","v":230350},{"$f":"+Investering!F42","v":367430},{"$f":"+Investering!G42","v":359180}]
[null,{"$f":"+Investering!C44","v":"Skole"},{"$f":"+Investering!D59","v":149500},{"$f":"+Investering!E59","v":182400},{"$f":"+Investering!F59","v":172000},{"$f":"+Investering!G59","v":298000}]
[null,{"$f":"+Investering!C61","v":"Barnehage "},{"$f":"+Investering!D76","v":103800},{"$f":"+Investering!E76","v":62000},{"$f":"+Investering!F76","v":161000},{"$f":"+Investering!G76","v":64000}]
[null,"Helse og velferd (eks. Bolig bygg KF)",{"$f":"+Investering!D93","v":126100},{"$f":"+Investering!E93","v":167000},{"$f":"+Investering!F93","v":190500},{"$f":"+Investering!G93","v":166500}]
[null,"Idrett",{"$f":"+Investering!D112","v":39600},{"$f":"+Investering!E112","v":31000},{"$f":"+Investering!F112","v":48750},{"$f":"+Investering!G112","v":55500}]
[null,"VAR",{"$f":"+Investering!D131","v":158100},{"$f":"+Investering!E131","v":159800},{"$f":"+Investering!F131","v":172300},{"$f":"+Investering!G131","v":170500}]
[null,"Park og vei",{"$f":"+Investering!D149","v":222475},{"$f":"+Investering!E149","v":208575},{"$f":"+Investering!F149","v":215575},{"$f":"+Investering!G149","v":213775}]
[null,"Kirkebygg",{"$f":"+Investering!D152","v":95920},{"$f":"+Investering!E152","v":101500},{"$f":"+Investering!F152","v":93100},{"$f":"+Investering!G152","v":27000}]
[null,"Miljø",{"$f":"+Investering!D170","v":0},{"$f":"+Investering!E170","v":15000},{"$f":"+Investering!F170","v":15000},{"$f":"+Investering!G170","v":15000}]
[null,"Forvaltning",{"$f":"+Investering!D182","v":54363},{"$f":"+Investering!E182","v":48188},{"$f":"+Investering!F182","v":37188},{"$f":"+Investering!G182","v":26188}]
[]
[null,"Drift",2020,2021,2022,2023]
[null,{"$f":"+Drift!C21","v":"Oppvekst og utdanning"},{"$f":"+Drift!D43","v":4125272},{"$f":"+Drift!E43","v":4096165},{"$f":"+Drift!F43","v":4085767},{"$f":"+Drift!G43","v":4092561}]
[null,{"$f":"+Drift!C48","v":"Helse og velferd"},{"$f":"+Drift!D70","v":3740961},{"$f":"+Drift!E70","v":3753565},{"$f":"+Drift!F70","v":3766515},{"$f":"+Drift!G70","v":3782715}]
[null,{"$f":"+Drift!C75","v":"By- og samfunnsplanlegging"},{"$f":"+Drift!D92","v":123385},{"$f":"+Drift!E92","v":123285},{"$f":"+Drift!F92","v":122785},{"$f":"+Drift!G92","v":122785}]
[null,{"$f":"+Drift!C97","v":"Bymiljø og utbygging"},{"$f":"+Drift!D101","v":1700898},{"$f":"+Drift!E101","v":1715428},{"$f":"+Drift!F101","v":1748048},{"$f":"+Drift!G101","v":1773117}]
[null,{"$f":"+Drift!C119","v":"Innbygger- og samfunnskontakt"},{"$f":"+Drift!D123","v":295960},{"$f":"+Drift!E123","v":292341},{"$f":"+Drift!F123","v":290339},{"$f":"+Drift!G123","v":290339}]
[null,{"$f":"Drift!C141","v":"Innovasjon og støttetjenester"},{"$f":"+Drift!D145","v":336982},{"$f":"+Drift!E145","v":328865},{"$f":"+Drift!F145","v":328865},{"$f":"+Drift!G145","v":328865}]
[null,{"$f":"Drift!C163","v":"Økonomi og organisasjon"},{"$f":"+Drift!D167","v":90333},{"$f":"+Drift!E167","v":90333},{"$f":"+Drift!F167","v":90333},{"$f":"+Drift!G167","v":90333}]
[null,{"$f":"Drift!C185","v":"Felles utgifter "},{"$f":"+Drift!D189","v":1815216},{"$f":"+Drift!E189","v":1775913},{"$f":"+Drift!F189","v":1785518},{"$f":"+Drift!G189","v":1772757}]
[null,null,{"$f":"SUM(C15:C22)","v":12229007},{"$f":"SUM(D15:D22)","v":12175895},{"$f":"SUM(E15:E22)","v":12218170},{"$f":"SUM(F15:F22)","v":12253472}]
[]
[null,"Indikator",2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023]
[null,"Egenfinansiering",0.42,0.47,0.45,0.52,0.63,0.56999999999999995,0.37,{"$f":"1-('Grunnlag finans'!C26/Investering!D198)","v":0.65800203090733778},{"$f":"1-('Grunnlag finans'!D26/Investering!E198)","v":0.34252823613611727},{"$f":"1-('Grunnlag finans'!E26/Investering!F198)","v":0.41924359894435459},{"$f":"1-('Grunnlag finans'!F26/Investering!G198)","v":0.27102059767433362}]
[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]
[null,"Netto driftsresultat",1.8524319252252109E-2,-1.2075126972115879E-2,3.2652142332346125E-2,4.9565579636232926E-2,4.4004597237566064E-2,-2.4532503952339312E-3,1.0999999999999999E-2,{"$f":"C59","v":8.2618429926718077E-3},{"$f":"D59","v":7.7594577197368378E-3},6.889097693314577E-3,1.0289095361964659E-3]
[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]
[null,"Gjeldsgrad",0.55800000000000005,0.60499999999999998,0.60799999999999998,0.60731135385195023,0.6182518888286751,0.62422977247219669,0.71399999999999997,{"$f":"C36","v":0.71649235129645561},{"$f":"D36","v":0.77247075158599454},0.83830191309511526,0.90385695479920081]
[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]
[]
[null,"Gjeldsgrad",2020,2021,2022,2023]
[null,"Driftsinntekter",{"$f":"+C53","v":10955909},{"$f":"+D53","v":11000511},11047020,11092326]
[null,"Gjeldsnivå for bykassen ekskl. startlån",{"$f":"7849825+'Grunnlag finans'!C39","v":7849825},{"$f":"8497573+'Grunnlag finans'!D39","v":8497573},{"$f":"9260738+'Grunnlag finans'!E39","v":9260738},{"$f":"10025876+'Grunnlag finans'!F39","v":10025876}]
[null,"Gjeldsgrad (oppdateres automatisk)",{"$f":"+C35/C34","v":0.71649235129645561},{"$f":"+D35/D34","v":0.77247075158599454},{"$f":"+E35/E34","v":0.83830191309511526},{"$f":"+F35/F34","v":0.90385695479920081}]
[]
[null,"Netto driftsresultat"]
[null,"Rådmannensforslag",2020,2021,2022,2023]
[null,"Driftsinntekter rådmannens forslag",10955909,11000511,11047020,11092326]
[null,"Driftsutgifter rådmannens forslag",11006290,11021036,11051379,11122445]
[null,"Brutto driftsresultat",{"$f":"+C40-C41","v":-50381},{"$f":"+D40-D41","v":-20525},-4359,-30119]
[null,"Resultat eksterne finanstransaksjoner",-188357,-225586,-253479,-294776]
[null,"Motpost avskrivninger",329254,331469,333942,336308]
[null,"Nettodriftsresultat",{"$f":"+C42+C43+C44","v":90516},{"$f":"+D42+D43+D44","v":85358},76104,11413]
[null,"Nettodriftsresultat i %",{"$f":"+C45/C40","v":8.2618429926718077E-3},{"$f":"+D45/D40","v":7.7594577197368378E-3},6.889097693314577E-3,1.0289095361964659E-3]
[]
[]
[null,"Endringer",2020,2021,2022,2023]
[null,"Politiske endringer i utgifter ift. rådmannens forslag",{"$f":"+Drift!D42+Drift!D69+Drift!D91+Drift!D113+Drift!D135+Drift!D179+Drift!D202","v":0},{"$f":"+Drift!E42+Drift!E69+Drift!E91+Drift!E113+Drift!E135+Drift!E179+Drift!E202","v":0},{"$f":"+Drift!F42+Drift!F69+Drift!F91+Drift!F113+Drift!F135+Drift!F179+Drift!F202","v":0},{"$f":"+Drift!G42+Drift!G69+Drift!G91+Drift!G113+Drift!G135+Drift!G179+Drift!G202","v":0}]
[null,"Politiske endringer i inntekter iht. rådmannens forslag",{"$f":"SUM(Drift!D212:D221)","v":0},{"$f":"SUM(Drift!E212:E221)","v":0},{"$f":"SUM(Drift!F212:F221)","v":0},{"$f":"SUM(Drift!G212:G221)","v":0}]
[]
[null,"Driftsinntekter etter politiske endringer",{"$f":"C40-C51","v":10955909},{"$f":"D40-D51","v":11000511},11047020,11092326]
[null,"Driftutgifter etter politiske endringer",{"$f":"+C41+C50","v":11006290},{"$f":"+D41+D50","v":11021036},11051379,11122445]
[null,"Brutto driftsresultat etter politiske endringer",{"$f":"+C53-C54","v":-50381},{"$f":"+D53-D54","v":-20525},-4359,-30119]
[null,"Resultat eksterne finanstransaksjoner",{"$f":"C43","v":-188357},{"$f":"D43","v":-225586},-253479,-294776]
[null,"Motpost avskrivninger",{"$f":"C44","v":329254},{"$f":"D44","v":331469},333942,336308]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C55+C56+C57","v":90516},{"$f":"+D55+D56+D57","v":85358},76104,11413]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C58/C53","v":8.2618429926718077E-3},{"$f":"+D58/D53","v":7.7594577197368378E-3},6.889097693314577E-3,1.0289095361964659E-3]