{"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 2019-2022                                                                                                                                                         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 2019-2022"]
[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",2019,2020,2021,2022]
[null,"Brutto driftsramme iht rådmannens forslag",{"$f":"+Drift!D310","v":11238223},{"$f":"+Drift!E310","v":11359321},{"$f":"+Drift!F310","v":11448623},{"$f":"+Drift!G310","v":11497914}]
[null,"Netto driftsresultat iht. rådmannens forslag",{"$f":"+Drift!D11","v":1.9546574415202883E-2},{"$f":"+Drift!E11","v":2.0540372888308595E-2},{"$f":"+Drift!F11","v":1.9848199156971707E-2},{"$f":"+Drift!G11","v":2.1561037473327667E-2}]
[]
[null,"Brutto driftsramme iht. partiets forslag (omtrentlig)",{"$f":"+Drift!D311","v":11238223},{"$f":"+Drift!E311","v":11359321},{"$f":"+Drift!F311","v":11448623},{"$f":"+Drift!G311","v":11497914}]
[null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!I26","v":1.9569040248428655E-2},{"$f":"+'Grunnlag måltall'!J26","v":2.0541646883869315E-2},{"$f":"+'Grunnlag måltall'!K26","v":1.9843499343727224E-2},{"$f":"+'Grunnlag måltall'!L26","v":2.156174582495244E-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",2019,2020,2021,2022]
[null,"Brutto investeringer iht. rådmannens forslag",{"$f":"+Investering!D9","v":1140370},{"$f":"+Investering!E9","v":1118350},{"$f":"+Investering!F9","v":1302350},{"$f":"+Investering!G9","v":1084450}]
[null,"Brutto investeringer iht. partiets forslag",{"$f":"+Investering!D11","v":1140370},{"$f":"+Investering!E11","v":1118350},{"$f":"+Investering!F11","v":1302350},{"$f":"+Investering!G11","v":1084450}]
[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 ",2019,2020,2021,2022]
[null,"Låneopptak iht. rådmannens forslag",{"$f":"+Investering!D13","v":645303},{"$f":"+Investering!E13","v":577436},{"$f":"+Investering!F13","v":851246.33333333326},{"$f":"+Investering!G13","v":641248.33333333326}]
[null,"Låneopptak iht. partiets forslag",{"$f":"+Investering!D15","v":645303},{"$f":"+Investering!E15","v":577436},{"$f":"+Investering!F15","v":851246.33333333326},{"$f":"+Investering!G15","v":641248.33333333326}]
[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":182,"n_cols":9,"rows_kept":182,"cut":false,"hidden":false,"merged":[[5,6,5,7],[1,2,2,2]]}
[]
[null,null,"Handlings- og økonomiplan 2019-2022                                                                                                                                                               INVESTERINGER"]
[]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[]
[null,null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,"1. Oppsummering",2019,2020,2021,2022,"2019-2022"]
[]
[null,null,"Rådmannens forslag til investeringsbudsjett",{"$f":"+D170","v":1140370},{"$f":"+E170","v":1118350},1302350,1084450,{"$f":"+D9+E9+F9+G9","v":4645520}]
[null,null,"Partiets endringer- totale endringer",{"$f":"+D171","v":0},{"$f":"+E171","v":0},{"$f":"+F171","v":0},{"$f":"+G171","v":0},{"$f":"+D10+E10+F10+G10","v":0}]
[null,null,"Nytt forslag til investeringsbudsjett justert for partiets endringer",{"$f":"+D9+D10","v":1140370},{"$f":"+E9+E10","v":1118350},{"$f":"+F9+F10","v":1302350},{"$f":"+G9+G10","v":1084450},{"$f":"+D11+E11+F11+G11","v":4645520}]
[]
[null,null,"Låneopptak iht rådmannens forslag",{"$f":"+D175","v":645303},{"$f":"+E175","v":577436},851246.33333333326,641248.33333333326,{"$f":"+G13+F13+E13+D13","v":2715233.6666666665}]
[null,null,"Låneopptak iht. partiet endringer",{"$f":"+D181","v":0},{"$f":"+E181","v":0},{"$f":"+F181","v":0},{"$f":"+G181","v":0},{"$f":"+D14+E14+F14+G14","v":0}]
[null,null,"Nytt nivå på låneopptak justert for partiet endringer",{"$f":"+D13+D14","v":645303},{"$f":"+E13+E14","v":577436},{"$f":"+F13+F14","v":851246.33333333326},{"$f":"+G13+G14","v":641248.33333333326},{"$f":"+H13+H14","v":2715233.6666666665}]
[]
[null,null,"Overføring fra drift iht rådmannens forslag",224158,232330,223170,242666,{"$f":"+G17+F17+E17+D17","v":922324}]
[null,null,"Overføring fra drift iht. partiets endringer",{"$f":"+D178","v":0},{"$f":"+E178","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":224158},{"$f":"+E17+E18","v":232330},{"$f":"+F17+F18","v":223170},{"$f":"+G17+G18","v":242666},{"$f":"+H17+H18","v":922324}]
[]
[null,null,"Udekket iht. rådmannens forslag",{"$f":"+(D175+D176)-D170","v":0},{"$f":"+(E175+E176)-E170","v":0},{"$f":"+(F175+F176)-F170","v":0},{"$f":"+(G175+G176)-G170","v":0},{"$f":"+D21+E21+F21+G21","v":0}]
[]
[null,null,"Udekket iht. partiets forslag",{"$f":"+D182","v":0},{"$f":"+E182","v":0},{"$f":"+F182","v":0},{"$f":"+G182","v":0},{"$f":"+D23+E23+F23+G23","v":0}]
[]
[]
[null,null,"2. HØP 2019-2022- Investeringstabell"]
[null,null,"Diverse bygg og felles investeringer"]
[null,null,"Rådmannens forslag- sum diverse bygg, anelgg og felles investeringer",217720,195200,221500,189500,{"$f":"+G28+F28+E28+D28","v":823920}]
[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":217720},{"$f":"+E28+E41","v":195200},{"$f":"+F28+F41","v":221500},{"$f":"+G28+G41","v":189500},{"$f":"+H28+H41","v":823920}]
[]
[null,null,"Skole"]
[null,null,"Rådmannens forslag- sum skole",204600,296000,443400,389000,{"$f":"+G45+F45+E45+D45","v":1333000}]
[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":204600},{"$f":"+E45+E58","v":296000},{"$f":"+F45+F58","v":443400},{"$f":"+G45+G58","v":389000},{"$f":"+H45+H58","v":1333000}]
[]
[null,null,"Barnehage "]
[null,null,"Rådmannens forslag- sum barnehage",130500,123800,136000,53000,{"$f":"+G62+F62+E62+D62","v":443300}]
[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":130500},{"$f":"+E62+E75","v":123800},{"$f":"+F62+F75","v":136000},{"$f":"+G62+G75","v":53000},{"$f":"+H62+H75","v":443300}]
[]
[null,null,"Helse og velferd (eks. bolig bygg KF)"]
[null,null,"Rådmannens forslag- sum levekår",152500,108500,114500,129500,{"$f":"+G79+F79+E79+D79","v":505000}]
[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":152500},{"$f":"+E79+E92","v":108500},114500,{"$f":"+G79+G92","v":129500},{"$f":"+H79+H92","v":505000},18350]
[]
[null,null,"Idrett"]
[null,null,"Rådmannens forslag-  sum idrettsbygg",84700,12000,1500,5000,{"$f":"+G96+F96+E96+D96","v":103200}]
[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":84700},{"$f":"+E96+E111","v":12000},{"$f":"+F96+F111","v":1500},{"$f":"+G96+G111","v":5000},{"$f":"+H96+H111","v":103200}]
[]
[null,null," Vann, avløp og renovasjon"]
[null,null,"Rådmannens forslag-  sum vann, avløp og renovasjon",145400,145900,146500,144500,{"$f":"+G115+F115+E115+D115","v":582300}]
[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":145400},{"$f":"+E115+E130","v":145900},{"$f":"+F115+F130","v":146500},{"$f":"+G115+G130","v":144500},{"$f":"+H115+H130","v":582300}]
[]
[null,null,"Park og vei"]
[null,null,"Rådmannens forslag-  sum park og vei",155450,145950,149950,140950,{"$f":"+G134+F134+E134+D134","v":592300}]
[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":155450},{"$f":"+E134+E148","v":145950},{"$f":"+F134+F148","v":149950},{"$f":"+G134+G148","v":140950},{"$f":"+H134+H148","v":592300}]
[]
[null,null,"Kirkelig fellesråd"]
[null,null,"Rådmannens forslag-  sum kirkelig fellesråd",49500,91000,89000,33000,{"$f":"+G152+F152+E152+D152","v":262500}]
[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":49500},{"$f":"+E152+E166","v":91000},{"$f":"+F152+F166","v":89000},{"$f":"+G152+G166","v":33000},{"$f":"+H152+H166","v":262500}]
[]
[null,null,"Totale brutto investeringer "]
[null,null,"Rådmannens forslag- totale brutto investeringer",{"$f":"+D152+D134+D115+D96+D79+D62+D45+D28","v":1140370},{"$f":"+E152+E134+E115+E96+E79+E62+E45+E28","v":1118350},{"$f":"+F152+F134+F115+F96+F79+F62+F45+F28","v":1302350},{"$f":"+G152+G134+G115+G96+G79+G62+G45+G28","v":1084450},{"$f":"+D170+E170+F170+G170","v":4645520}]
[null,null,"Partiets endringer- totale endringer ift. Rådmannens forslag",{"$f":"+D166+D148+D130+D111+D92+D75+D58+D41","v":0},{"$f":"+E166+E148+E130+E111+E92+E75+E58+E41","v":0},{"$f":"+F166+F148+F130+F111+F92+F75+F58+F41","v":0},{"$f":"+G166+G148+G130+G111+G92+G75+G58+G41","v":0},{"$f":"+D171+E171+F171+G171","v":0}]
[null,null,"Nytt forslag til budsjett justert for partiets endringer totalt",{"$f":"+D170+D171","v":1140370},{"$f":"+E170+E171","v":1118350},{"$f":"+F170+F171","v":1302350},{"$f":"+G170+G171","v":1084450},{"$f":"+H170+H171","v":4645520}]
[]
[null,null,"Finansiering "]
[null,null,"Rådmannens forslag låneopptak",645303,577436,851246.33333333326,641248.33333333326,{"$f":"+G175+F175+E175+D175","v":2715233.6666666665}]
[null,null,"Rådmannensforslag egenfinansiering",{"$f":"+D170-D175","v":495067},{"$f":"+E170-E175","v":540914},{"$f":"+F170-F175","v":451103.66666666674},{"$f":"+G170-G175","v":443201.66666666674},{"$f":"+D176+E176+F176+G176","v":1930286.3333333335}]
[null,null,"Partiets endringer i egenfinansiering føres under:"]
[null,null,"Overføringer fra drift til investering (beregnes i driftsbudsjettet)",{"$f":"+Drift!D297","v":0},{"$f":"+Drift!E297","v":0},{"$f":"+Drift!F297","v":0},{"$f":"+Drift!G297","v":0},{"$f":"+D178+E178+F178+G178","v":0}]
[null,null,"Salgsinntekter",null,null,null,null,{"$f":"+D179+E179+F179+G179","v":0}]
[null,null,"Andre tilskudd",null,null,null,null,{"$f":"+D180+E180+F180+G180","v":0}]
[null,null,"Partiets endring i låneopptak (beregnes automatisk)",{"$f":"D171-(+D178+D179+D180)","v":0},{"$f":"E171-(+E178+E179+E180)","v":0},{"$f":"F171-(+F178+F179+F180)","v":0},{"$f":"G171-(+G178+G179+G180)","v":0},{"$f":"+D181+E181+F181+G181","v":0}]
[null,null,"Udekket iht. partiets endringer",{"$f":"+D172-(D175+D176+D178+D179+D180+D181)","v":0},{"$f":"+E172-(E175+E176+E178+E179+E180+E181)","v":0},{"$f":"+F172-(F175+F176+F178+F179+F180+F181)","v":0},{"$f":"+G172-(G175+G176+G178+G179+G180+G181)","v":0}]

{"sheet":"Drift","index":3,"n_rows":377,"n_cols":8,"rows_kept":377,"cut":false,"hidden":false,"merged":[[312,5,312,6],[1,2,1,7],[6,5,6,6],[20,2,21,6],[257,2,258,6],[50,2,51,6],[83,2,84,6],[109,2,110,6],[143,2,144,6],[170,2,171,6],[200,2,201,6],[228,2,229,6],[302,2,302,6],[278,2,279,6],[3,5,3,6]]}
[]
[null,null,"Handlings- og økonomiplan 2019-2022                                                                                                                                                                                           DRIFT"]
[null,null,{"$f":"+Informasjon!D6","v":0}]
[null,null,null,null,null,"Beløp i hele tusen kroner"]
[null,null,null,2019,{"$f":"D5+1","v":2020},{"$f":"E5+1","v":2021},{"$f":"F5+1","v":2022}]
[]
[]
[null,null,"1. Oppsummering"]
[]
[null,null,"Brutto budsjettramme iht. rådmannnens forslag",{"$f":"+D310","v":11238223},{"$f":"+E310","v":11359321},11448623,11497914]
[null,null,"Netto driftsresultat iht. rådmannens forslag",1.9546574415202883E-2,2.0540372888308595E-2,1.9848199156971707E-2,2.1561037473327667E-2]
[null,null,"Brutto budsjettramme iht. partiets forslag",{"$f":"+D311","v":11238223},{"$f":"+E311","v":11359321},11448623,11497914]
[null,null,"Netto driftsresultat iht. partiets forslag (omtrentlig)",{"$f":"+'Grunnlag måltall'!C57","v":1.9569040248428655E-2},{"$f":"+'Grunnlag måltall'!D57","v":2.0541646883869315E-2},{"$f":"+'Grunnlag måltall'!E57","v":1.9843499343727224E-2},{"$f":"+'Grunnlag måltall'!F57","v":2.156174582495244E-2}]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"D314","v":0},{"$f":"E314","v":0},{"$f":"F314","v":0},{"$f":"G314","v":0}]
[]
[]
[null,null,"2. HØP 2019-2022- driftsrammetabell"]
[]
[]
[null,null,"Barnehage "]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",54601,37450,24450,12450]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",{"$f":"1521718+12445","v":1534163},{"$f":"1504567+12445","v":1517012},{"$f":"1491567+12445","v":1504012},{"$f":"1479567+12445","v":1492012}]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D27:D45)","v":0},{"$f":"SUM(E27:E45)","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D25+D46","v":1534163},{"$f":"+E25+E46","v":1517012},{"$f":"+F25+F46","v":1504012},{"$f":"+G25+G46","v":1492012}]
[]
[]
[]
[null,null,"Skole"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",34600,42300,40100,36600]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",{"$f":"1635007+13372","v":1648379},{"$f":"1642707+13372","v":1656079},{"$f":"1640507+13372","v":1653879},{"$f":"1637007+13372","v":1650379}]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D57:D78)","v":0},{"$f":"SUM(E57:E78)","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D55+D79","v":1648379},{"$f":"+E55+E79","v":1656079},{"$f":"+F55+F79","v":1653879},{"$f":"+G55+G79","v":1650379}]
[]
[]
[]
[null,null,"Barn og unge"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",-3880,-4010,-10810,-12110]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",{"$f":"504676+4128","v":508804},{"$f":"504546+4128","v":508674},{"$f":"497746+4128","v":501874},{"$f":"496446+4128","v":500574},503815]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D90:D104)","v":0},{"$f":"SUM(E90:E104)","v":0},{"$f":"SUM(F90:F104)","v":0},{"$f":"SUM(G90:G104)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D88+D105","v":508804},{"$f":"+E88+E105","v":508674},{"$f":"+F88+F105","v":501874},{"$f":"+G88+G105","v":500574}]
[]
[]
[]
[null,null,"Helse og velferd"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",{"$f":"100119+3000-3000","v":100119},{"$f":"111540+3000-3000","v":111540},{"$f":"117590-3000+3000","v":117590},{"$f":"130190-3000+3000","v":130190}]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",{"$f":"3661566+3000-3000","v":3661566},{"$f":"3672987+3000-3000","v":3672987},{"$f":"3679037+3000-3000","v":3679037},{"$f":"3691637+3000-3000","v":3691637}]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D116:D138)","v":0},{"$f":"SUM(E116:E138)","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D114+D139","v":3661566},{"$f":"+E114+E139","v":3672987},{"$f":"+F114+F139","v":3679037},{"$f":"+G114+G139","v":3691637}]
[]
[]
[]
[null,null,"By- og samfunnsplanlegging"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",2040,-150,200,0]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",103349,103199,103399,103399]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D150:D165)","v":0},{"$f":"SUM(E150:E165)","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D148+D166","v":103349},{"$f":"+E148+E166","v":103199},{"$f":"+F148+F166","v":103399},{"$f":"+G148+G166","v":103399}]
[]
[]
[]
[null,null,"Bymiljø og utbygging"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",99440,140880,165380,186350]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",1530834,1572274,1596774,1617744]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D177:D195)","v":0},{"$f":"SUM(E177:E195)","v":0},{"$f":"SUM(F177:F195)","v":0},{"$f":"SUM(G177:G195)","v":0}]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D175+D196","v":1530834},{"$f":"+E175+E196","v":1572274},{"$f":"+F175+F196","v":1596774},{"$f":"+G175+G196","v":1617744}]
[]
[]
[]
[null,null,"Innbygger- og samfunnskontakt"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",{"$f":"13570-1500","v":12070},{"$f":"12830-1500","v":11330},{"$f":"12830-1500","v":11330},{"$f":"12830-1500","v":11330}]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",{"$f":"235623-1500","v":234123},{"$f":"234883-1500","v":233383},{"$f":"234883-1500","v":233383},{"$f":"234883-1500","v":233383}]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D207:D223)","v":0},{"$f":"SUM(E207:E223)","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D205+D224","v":234123},{"$f":"+E205+E224","v":233383},{"$f":"+F205+F224","v":233383},{"$f":"+G205+G224","v":233383}]
[]
[]
[]
[null,null,"Stab og støttefunksjoner"]
[]
[]
[null,null,"Sum brutto endringer iht. rådmannens forslag",8910,8182,8182,8182]
[null,null,"Brutto budsjettramme iht. rådmannens forslag",392558,391830,391830,391830]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"SUM(D235:D252)","v":0},{"$f":"SUM(E235:E252)","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D233+D253","v":392558},{"$f":"+E233+E253","v":391830},{"$f":"+F233+F253","v":391830},{"$f":"+G233+G253","v":391830}]
[]
[]
[]
[null,null,"Felles utgifter "]
[]
[]
[null,null,"Sum endring iht. rådmannens forslag",{"$f":"129183-(5000+4915+7641)","v":111627},{"$f":"211175-(5000+10197+4915)","v":191063},{"$f":"289927-(5000+4915+8397)","v":271615},{"$f":"322348-(5000+4915+8297)","v":304136}]
[null,null,"Budsjettramme iht. rådmannens forslag",{"$f":"1642003-(5000+4915+7641)","v":1624447},{"$f":"1723995-(5000+4915+10197)","v":1703883},{"$f":"1802747-(5000+4915+8397)","v":1784435},{"$f":"1835168-(5000+4915+8297)","v":1816956}]
[null,null,"Legg inn dine endringer under:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum endring iht. partiets forslag",{"$f":"+D264+D269+D270+D271+D272+D273+D274+D304+D305+D265+D266+D267+D268","v":0},{"$f":"+E264+E269+E270+E271+E272+E273+E274+E304+E305+E265+E266+E267+E268","v":0},0,0]
[null,null,"Ny budsjettramme iht. partiets forslag",{"$f":"+D262+D275","v":1624447},{"$f":"+E262+E275","v":1703883},1784435,1816956]
[]
[]
[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)"]
[]
[]
[null,null,"Sum endringer i felles inntekter og utgifter iht. partiets forslag",{"$f":"ROUND(+D285+D286+D291+D275+D284+D292+D293+D295+D297+D287+D288+D289+D290,-1)","v":0},{"$f":"ROUND(+E285+E286+E291+E275+E284+E292+E293+E295+E297+E287+E288+E289+E290,-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":"+D262+D233+D205+D175+D148+D114+D88+D55+D25","v":11238223},{"$f":"+E262+E233+E205+E175+E148+E114+E88+E55+E25","v":11359321},11448623,{"$f":"+G262+G233+G205+G175+G148+G114+G88+G55+G25","v":11497914}]
[null,null,"Ny brutto driftsramme iht. partiets forslag",{"$f":"+D254+D276+D225+D197+D167+D140+D106+D80+D47+D300","v":11238223},{"$f":"+E254+E276+E225+E197+E167+E140+E106+E80+E47+E300","v":11359321},{"$f":"+F254+F276+F225+F197+F167+F140+F106+F80+F47+F300","v":11448623},{"$f":"+G254+G276+G225+G197+G167+G140+G106+G80+G47+G300","v":11497914}]
[]
[]
[null,null,"Sum driftsbalanse (skal være null)",{"$f":"ROUND(+D46+D79+D105+D139+D166+D196+D224+D253+D300,-1)","v":0},{"$f":"ROUND(+E46+E79+E105+E139+E166+E196+E224+E253+E300,-1)","v":0},{"$f":"ROUND(+F46+F79+F105+F139+F166+F196+F224+F253+F300,-1)","v":0},{"$f":"ROUND(+G46+G79+G105+G139+G166+G196+G224+G253+G300,-1)","v":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:",2019,2020,2021,2022]
[null,"Ordinært låneopptak til investeringer",{"$f":"+Investering!D175","v":645303},{"$f":"+Investering!E175","v":577436},{"$f":"+Investering!F175","v":851246.33333333326},{"$f":"+Investering!G175","v":641248.33333333326}]
[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":645303},{"$f":"+D15+D16+D17","v":577436},851246.33333333326,641248.33333333326]
[]
[null,"Partiets forslag til endringer i låneopptak:",2019,2020,2021,2022]
[null,"Iht. budsjettforslag fra partiet",{"$f":"+Investering!D181","v":0},{"$f":"+Investering!E181","v":0},{"$f":"+Investering!F181","v":0},{"$f":"+Investering!G181","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},0,0]
[]
[null,"Nytt låneopptak per år",{"$f":"+C24+C18","v":645303},{"$f":"+D24+D18","v":577436},851246.33333333326,641248.33333333326]
[]
[]
[]
[null,"Endring i finanskostnader "]
[]
[null,"Endring i finanskostnader",2019,2020,2021,2022]
[null,"Rentesats",2.1000000000000001E-2,2.5499999999999998E-2,2.9499999999999998E-2,3.1E-2]
[null,"Nedbetalingstid (år)",30,30,30,30]
[null,"Nytt lån",{"$f":"+Investering!D181","v":0},{"$f":"+Investering!E181","v":0},{"$f":"+Investering!F181","v":0},{"$f":"+Investering!G181","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":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Investeringer",2019,2020,2021,2022]
[null,"Diverse bygg og felles investeringer",{"$f":"+Investering!D42","v":217720},{"$f":"+Investering!E42","v":195200},{"$f":"+Investering!F42","v":221500},{"$f":"+Investering!G42","v":189500}]
[null,{"$f":"+Investering!C44","v":"Skole"},{"$f":"+Investering!D59","v":204600},{"$f":"+Investering!E59","v":296000},{"$f":"+Investering!F59","v":443400},{"$f":"+Investering!G59","v":389000}]
[null,{"$f":"+Investering!C61","v":"Barnehage "},{"$f":"+Investering!D76","v":130500},{"$f":"+Investering!E76","v":123800},{"$f":"+Investering!F76","v":136000},{"$f":"+Investering!G76","v":53000}]
[null,"Helse og velferd (eks. Bolig bygg KF)",{"$f":"+Investering!D93","v":152500},{"$f":"+Investering!E93","v":108500},{"$f":"+Investering!F93","v":114500},{"$f":"+Investering!G93","v":129500}]
[null,"Idrett",{"$f":"+Investering!D112","v":84700},{"$f":"+Investering!E112","v":12000},{"$f":"+Investering!F112","v":1500},{"$f":"+Investering!G112","v":5000}]
[null,"VAR",{"$f":"+Investering!D131","v":145400},{"$f":"+Investering!E131","v":145900},{"$f":"+Investering!F131","v":146500},{"$f":"+Investering!G131","v":144500}]
[null,"Park og vei",{"$f":"+Investering!D149","v":155450},{"$f":"+Investering!E149","v":145950},{"$f":"+Investering!F149","v":149950},{"$f":"+Investering!G149","v":140950}]
[null,"Kirkebygg",{"$f":"+Investering!D152","v":49500},{"$f":"+Investering!E152","v":91000},{"$f":"+Investering!F152","v":89000},{"$f":"+Investering!G152","v":33000}]
[]
[null,"Drift",2019,2020,2021,2022]
[null,{"$f":"+Drift!C21","v":"Barnehage "},{"$f":"+Drift!D47","v":1534163},{"$f":"+Drift!E47","v":1517012},{"$f":"+Drift!F47","v":1504012},{"$f":"+Drift!G47","v":1492012}]
[null,{"$f":"+Drift!C51","v":"Skole"},{"$f":"+Drift!D80","v":1648379},{"$f":"+Drift!E80","v":1656079},{"$f":"+Drift!F80","v":1653879},{"$f":"+Drift!G80","v":1650379}]
[null,{"$f":"+Drift!C84","v":"Barn og unge"},{"$f":"+Drift!D106","v":508804},{"$f":"+Drift!E106","v":508674},{"$f":"+Drift!F106","v":501874},{"$f":"+Drift!G106","v":500574}]
[null,{"$f":"+Drift!C110","v":"Helse og velferd"},{"$f":"+Drift!D140","v":3661566},{"$f":"+Drift!E140","v":3672987},{"$f":"+Drift!F140","v":3679037},{"$f":"+Drift!G140","v":3691637}]
[null,{"$f":"+Drift!C144","v":"By- og samfunnsplanlegging"},{"$f":"+Drift!D167","v":103349},{"$f":"+Drift!E167","v":103199},{"$f":"+Drift!F167","v":103399},{"$f":"+Drift!G167","v":103399}]
[null,{"$f":"+Drift!C171","v":"Bymiljø og utbygging"},{"$f":"+Drift!D175","v":1530834},{"$f":"+Drift!E175","v":1572274},{"$f":"+Drift!F175","v":1596774},{"$f":"+Drift!G175","v":1617744}]
[null,{"$f":"+Drift!C201","v":"Innbygger- og samfunnskontakt"},{"$f":"+Drift!D205","v":234123},{"$f":"+Drift!E205","v":233383},{"$f":"+Drift!F205","v":233383},{"$f":"+Drift!G205","v":233383}]
[null,"Stab og støttefunksjoner",{"$f":"+Drift!D233","v":392558},{"$f":"+Drift!E233","v":391830},{"$f":"+Drift!F233","v":391830},{"$f":"+Drift!G233","v":391830}]
[null,{"$f":"+Drift!C258","v":"Felles utgifter "},{"$f":"+Drift!D262","v":1624447},{"$f":"+Drift!E262","v":1703883},{"$f":"+Drift!F262","v":1784435},{"$f":"+Drift!G262","v":1816956}]
[]
[null,"Indikator",2013,2014,2015,2016,2017,2018,2019,2020,2021,2022]
[null,"Egenfinansiering",0.42,0.47,0.45,0.52,0.63,0.56999999999999995,{"$f":"+(Investering!D172-(Investering!D175+Investering!D181))/Investering!D172","v":0.43412839692380545},{"$f":"+(Investering!E172-(Investering!E175+Investering!E181))/Investering!E172","v":0.48367148030580764},{"$f":"+(Investering!F172-(Investering!F175+Investering!F181))/Investering!F172","v":0.3463766780563341},{"$f":"+(Investering!G172-(Investering!G175+Investering!G181))/Investering!G172","v":0.40868796778705035}]
[null,"Måltall > 50 %",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,{"$f":"+C57","v":1.9569040248428655E-2},{"$f":"+D57","v":2.0541646883869315E-2},1.9843499343727224E-2,2.156174582495244E-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]
[null,"Gjeldsgrad",0.55800000000000005,0.60499999999999998,0.60799999999999998,0.60731135385195023,0.6182518888286751,0.62422977247219669,{"$f":"+C34","v":0.64735691980469756},{"$f":"+D34","v":0.66444175665015737},0.70661705342363035,0.72416723592404242]
[null,"Måltall < 60 %",0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6,0.6]
[]
[null,"Gjeldsgrad",2019,2020,2021,2020]
[null,"Driftsinntekter",{"$f":"+C51","v":9898697},{"$f":"+D51","v":9960253},10011843,10075993]
[null,"Gjeldsnivå for bykassen ekskl. startlån",{"$f":"6407990+'Grunnlag finans'!C39","v":6407990},{"$f":"6618008+'Grunnlag finans'!D39","v":6618008},{"$f":"7074539+'Grunnlag finans'!E39","v":7074539},{"$f":"7296704+'Grunnlag finans'!F39","v":7296704}]
[null,"Gjeldsgrad (oppdateres automatisk)",{"$f":"+C33/C32","v":0.64735691980469756},{"$f":"+D33/D32","v":0.66444175665015737},{"$f":"+E33/E32","v":0.70661705342363035},{"$f":"+F33/F32","v":0.72416723592404242}]
[]
[null,"Netto driftsresultat"]
[null,"Rådmannensforslag",2019,2020,2021,2020]
[null,"Driftsinntekter rådmannens forslag",9898697,9960253,10011843,10075993]
[null,"Driftsutgifter rådmannens forslag",9950043,9990974,10009234,10023032]
[null,"Brutto driftsresultat",{"$f":"+C38-C39","v":-51346},{"$f":"+D38-D39","v":-30721},2609,52961]
[null,"Resultat eksterne finanstransaksjoner",-189266,-198699,-237959,-269725]
[null,"Motpost avskrivninger",434720,434720,434720,434720]
[null,"Nettodriftsresultat",194108,205300,199370,217956]
[null,"Nettodriftsresultat i %",{"$f":"+C43/C38","v":1.9609449607357412E-2},{"$f":"+D43/D38","v":2.0611926223159192E-2},1.9913416540790742E-2,2.1631217885919533E-2]
[]
[]
[null,"Endringer",2019,2020,2021,2020]
[null,"Politiske endringer i utgifter ift. rådmannens forslag",{"$f":"+Drift!D46+Drift!D79+Drift!D105+Drift!D139+Drift!D166+Drift!D196+Drift!D224+Drift!D253+Drift!D275","v":0},{"$f":"+Drift!E46+Drift!E79+Drift!E105+Drift!E139+Drift!E166+Drift!E196+Drift!E224+Drift!E253+Drift!E275","v":0},{"$f":"+Drift!F46+Drift!F79+Drift!F105+Drift!F139+Drift!F166+Drift!F196+Drift!F224+Drift!F253+Drift!F275","v":0},{"$f":"+Drift!G46+Drift!G79+Drift!G105+Drift!G139+Drift!G166+Drift!G196+Drift!G224+Drift!G253+Drift!G275","v":0}]
[null,"Politiske endringer i inntekter iht. rådmannens forslag",{"$f":"SUM(Drift!D284:D293)","v":0},{"$f":"SUM(Drift!E284:E293)","v":0},{"$f":"SUM(Drift!F284:F293)","v":0},{"$f":"SUM(Drift!G284:G293)","v":0}]
[]
[null,"Driftsinntekter etter politiske endringer",{"$f":"C38-C49","v":9898697},{"$f":"D38-D49","v":9960253},10011843,10075993]
[null,"Driftutgifter etter politiske endringer",{"$f":"+C39+C48","v":9950043},{"$f":"+D39+D48","v":9990974},10009234,10023032]
[null,"Brutto driftsresultat etter politiske endringer",{"$f":"+C51-C52","v":-51346},{"$f":"+D51-D52","v":-30721},2609,52961]
[null,"Resultat eksterne finanstransaksjoner",-189666,-199399,-238659,-270425]
[null,"Motpost avskrivninger",434720,434720,434720,434720]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C53+C54+C55","v":193708},{"$f":"+D53+D54+D55","v":204600},198670,217256]
[null,"Nettodriftsresultat (etter politiske endringer)",{"$f":"+C56/C51","v":1.9569040248428655E-2},{"$f":"+D56/D51","v":2.0541646883869315E-2},1.9843499343727224E-2,2.156174582495244E-2]