{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Selvbudgettering","Bilag 1 ","Bilag 2 ","Bilag 3","Makro mv."],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":20,"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":"Selvbudgettering","index":0,"n_rows":305,"n_cols":10,"rows_kept":305,"cut":false,"hidden":false,"merged":[[171,1,171,7],[172,1,172,7],[62,1,62,7],[4,3,4,5]]}
[null,{"$f":"\"Selvbudgettering af tilskud og udligning \"&aar","v":"Selvbudgettering af tilskud og udligning 2027"}]
[null," "]
[null,null,"Indtast eget kommunenummer her :"]
[null,null,null," "]
[null,null,"Kommune:",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,2),\"Ugyldigt kommunenr. \")","v":"Ugyldigt kommunenr. "}]
[null,null,"Indtast kommunens budgettal i Tabel 1 cellerne: F24, F25 og F28"]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Økonomi - og Indenrigsministeriet \"","v":"Økonomi - og Indenrigsministeriet "}]
[null,null,null,{"$f":"\"Selvbudgettering af tilskud og udligning \"&aar","v":"Selvbudgettering af tilskud og udligning 2027"}]
[null,null,null,{"$f":"\"for  (\"&TEXT(knr,0)&\")  \"&$D$5","v":"for  (0)  Ugyldigt kommunenr. "}]
[]
[]
[]
[]
[]
[null,{"$f":"\"Tabel 1:  Budgetteringsforudsætninger  (\"&TEXT(knr,0)&\")  \"&$D$5","v":"Tabel 1:  Budgetteringsforudsætninger  (0)  Ugyldigt kommunenr. "}]
[null,null,null,null,null,"Egen"]
[null,null,null,null,null,"beregning"]
[null,{"$f":"\"1.01 Indkomstskat  \"&aar","v":"1.01 Indkomstskat  2027"}]
[null,{"$f":"\"1.02 Udskrivningsprocent \"&aar&\"  (xx,xx)\"","v":"1.02 Udskrivningsprocent 2027  (xx,xx)"}]
[null,{"$f":"\"1.03 Beregningsteknisk grundværdier vedr. øvrige ejendomme \"&aar","v":"1.03 Beregningsteknisk grundværdier vedr. øvrige ejendomme 2027"},null,null,null,{"$f":"+H183","v":"---------- "}]
[null,{"$f":"\"1.04 Beregningsteknisk grundværdier vedr. produktionsjord \"&aar","v":"1.04 Beregningsteknisk grundværdier vedr. produktionsjord 2027"},null,null,null,{"$f":"+H185","v":"---------- "}]
[null,{"$f":"\"1.05 Skønnet folketal pr. 1. januar \"&aar","v":"1.05 Skønnet folketal pr. 1. januar 2027"}]
[null,"Anm. pkt. 1.05 Bopælskommuneopgørelse"]
[null,null,null,null,null,null,"1.01, 1.02 og 1.05 indberettes til"]
[null,null,null,null,null,null,"Økonomi- og Indenrigsministeriet"]
[null,null,null,null,null,null,"på www.indtast.dk,i skemaet vedr."]
[null,null,null,null,null,null,"skatteoplysninger og valg af bud-"]
[null,null,null,null,null,null,"getteringsmetode i forbindelse "]
[null,null,null,null,null,null,{"$f":"+\"med budgetindberetningen for \"&aar","v":"med budgetindberetningen for 2027"}]
[]
[null,{"$f":"\"Tabel 2: Selvbudgetterede udligningsbeløb vedr. \"&aar","v":"Tabel 2: Selvbudgetterede udligningsbeløb vedr. 2027"}]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.80 grp. 001 Kommunal udligning"]
[null,null,"Udligning af beskatningsgrundlag (jf. B.08)",null,null,{"$f":"IF(ok_pp=1,+G205,\" \")","v":" "},{"$f":"IF(OK_P=1,+H205,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F43-G43,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med lavt beskatningsgrundlag (jf. C.08)",null,null,{"$f":"IF(ok_pp=1,+G221,\" \")","v":" "},{"$f":"IF(OK_P=1,+H221,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt beskatningsgrundlag (jf. D.08)",null,null,{"$f":"IF(ok_pp=1,+G237,\" \")","v":" "},{"$f":"IF(OK_P=1,+H237,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. beskatningsgrundlag (jf. G.16)",null,null,{"$f":"IF(ok_pp=1,+G293,\" \")","v":" "},{"$f":"IF(OK_P=1,+H293,\"---------- \")","v":"---------- "}," "]
[null,null,"Korr. vedr. overudligning (jf. G.15)",null,null,{"$f":"IF(ok_pp=1,+G292,\" \")","v":" "},{"$f":"IF(OK_P=1,+H292,\"---------- \")","v":"---------- "}," "]
[null,null,"Udligning af udgiftsbehov (jf E.07)",null,null,{"$f":"IF(ok_pp=1,+G252,\" \")","v":" "},{"$f":"IF(OK_P=1,+H252,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt udgiftsbehov (jf. F.07)",null,null,{"$f":"IF(ok_pp=1,+G267,\" \")","v":" "},{"$f":"IF(OK_P=1,+H267,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. udgiftsbehov (jf. G.17)",null,null,{"$f":"IF(ok_pp=1,+G294,\" \")","v":" "},{"$f":"IF(OK_P=1,+H294,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F50-G50,\" \")","v":" "}]
[]
[null,"7.62.80 grp. 002 Statstilskud til kommuner"]
[null,null,"Statstilskud, ordinært  til kommuner (jf. G.11)",null,null,{"$f":"IF(ok_pp=1,+G288,\" \")","v":" "},{"$f":"IF(OK_P=1,+H288,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F53-G53,\" \")","v":" "}]
[null,null,"Statstilskud, betinget vedr. service (jf. G.12)",null,null,{"$f":"IF(ok_pp=1,+G289,\" \")","v":" "},{"$f":"IF(OK_P=1,+H289,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F54-G54,\" \")","v":" "}]
[null,null,"Statstilskud, betinget vedr. anlæg (jf. G.13)",null,null,{"$f":"IF(ok_pp=1,+G290,\" \")","v":" "},{"$f":"IF(OK_P=1,+H290,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F55-G55,\" \")","v":" "}]
[]
[null,"7.62.81 grp. 001 Udligning vedr. udlændinge "]
[null,null,"Samlet bidrag vedr. indv. og efterkommere (jf. G.14)",null,null,{"$f":"IF(ok_pp=1,+G291,\" \")","v":" "},{"$f":"IF(OK_P=1,+H291,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F58-G58,\" \")","v":" "}]
[]
[null,"Selvbudgetterede beløb i alt",null,null,null,{"$f":"IF(ok_pp=1,SUM(F43:F58),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G43:G58),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,SUM(H43:H59),\" \")","v":" "}]
[]
[]
[]
[null,{"$f":"\"TABEL 3: Konteringsoversigt \"&aar&\" (del I)  for:   (\"&TEXT(knr,0)&\")  \"&$D$5","v":"TABEL 3: Konteringsoversigt 2027 (del I)  for:   (0)  Ugyldigt kommunenr. "}]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"2.32.33 Færgedrift",null,null,null,{"$f":"IF(ok_pp=1,SUM(F70:F75),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G70:G75),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F69-G69,\" \")","v":" "}]
[null,null,"Tilskud til nedsat færgetakst for godstransport",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,37),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,37),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F70-G70,\" \")","v":" "}]
[null,null,"Tilskud til nedsat færgetakst for passagerbefordring",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,38),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,38),\"---------- \")","v":"---------- "}," "]
[null,null,"Momskompensation vedr. færgetakster for godstransport",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,39),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,39),\"---------- \")","v":"---------- "}," "]
[null,null,"Momskompensation vedr. færgetakster for passagerer",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,40),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,40),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til færgedrift",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,41),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,41),\"---------- \")","v":"---------- "}," "]
[null,null,"Omstillingsstøtte (færger)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,42),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,42),\"---------- \")","v":"---------- "}," "]
[null,"2.32.33 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F69,\" \")","v":" "},{"$f":"IF(OK_P=1,+G69,\"---------- \")","v":"---------- "}," "]
[]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.80 grp. 001 Kommunal udligning",null,null,null,{"$f":"IF(ok_pp=1,SUM(F84:F93),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G84:G93),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F83-G83,\" \")","v":" "}]
[null,null,"Udligning af beskatningsgrundlag (jf. B.08)",null,null,{"$f":"IF(ok_pp=1,+G205,\" \")","v":" "},{"$f":"IF(OK_P=1,+H205,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F84-G84,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med lavt beskatningsgrundlag (jf. C.08)",null,null,{"$f":"IF(ok_pp=1,+G221,\" \")","v":" "},{"$f":"IF(OK_P=1,+H221,\"---------- \")","v":"---------- "}," "]
[null,null,"Tillæg for kommuner med højt beskatningsgrundlag (jf. D.08)",null,null,{"$f":"IF(ok_pp=1,+G237,\" \")","v":" "},{"$f":"IF(OK_P=1,+H237,\"---------- \")","v":"---------- "}," "]
[null,null,"Finansieringsandel af tillæg vedr. beskatningsgrundlag (jf. G.16)",null,null,{"$f":"IF(ok_pp=1,+G293,\" \")","v":" "},{"$f":"IF(OK_P=1,+H293,\"---------- \")","v":"---------- "}," "]
[null,null,"Overudligning",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,7),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,7),\"---------- \")","v":"---------- "}," "]
[null,null,"Korr. vedr. overudligning (jf. G.15)",null,null,{"$f":"IF(ok_pp=1,+G292,\" \")","v":" "},{"$f":"IF(OK_P=1,+H292,\"---------- \")","v":"---------- "}," "]
[null,null,"Udligning af udgiftsbehov (jf E.07)",null,null,{"$f":"IF(ok_pp=1,+G252,\" \")","v":" "},{"$f":"IF(OK_P=1,+H252,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F90-G90,\" \")","v":" "}]
[null,null,"Tillæg for kommuner med højt udgiftsbehov (jf. F.07)",null,null,{"$f":"IF(ok_pp=1,+G267,\" \")","v":" "},{"$f":"IF(OK_P=1,+H267,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F91-G91,\" \")","v":" "}]
[null,null,"Finansieringsandel af tillæg vedr. udgiftsbehov (jf. G.17)",null,null,{"$f":"IF(ok_pp=1,+G294,\" \")","v":" "},{"$f":"IF(OK_P=1,+H294,\"---------- \")","v":"---------- "}," "]
[null,null,"Særlig kompensation",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,12),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,12),\"---------- \")","v":"---------- "}," "]
[null,"7.62.80 grp. 002 Statstilskud til kommuner ",null,null,null,{"$f":"IF(ok_pp=1,SUM(F95:F99),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G95:G99),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F94-G94,\" \")","v":" "}]
[null,null,{"$f":"+\"Bloktilskud ordinært vedr. \"&aar&\" (jf. G.11)\"","v":"Bloktilskud ordinært vedr. 2027 (jf. G.11)"},null,null,{"$f":"IF(ok_pp=1,+G288,\" \")","v":" "},{"$f":"IF(OK_P=1,+H288,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F95-G95,\" \")","v":" "}]
[null,null,{"$f":"+\"Bloktilskud betinget vedr. service \"&aar&\" (jf. G.12)\"","v":"Bloktilskud betinget vedr. service 2027 (jf. G.12)"},null,null,{"$f":"IF(ok_pp=1,+G289,\" \")","v":" "},{"$f":"IF(OK_P=1,+H289,\"---------- \")","v":"---------- "}," "]
[null,null,{"$f":"+\"Bloktilskud betinget vedr. anlæg \"&aar&\" (jf. G.13)\"","v":"Bloktilskud betinget vedr. anlæg 2027 (jf. G.13)"},null,null,{"$f":"IF(ok_pp=1,+G290,\" \")","v":" "},{"$f":"IF(OK_P=1,+H290,\"---------- \")","v":"---------- "}," "]
[null,null,"Individuelt modregning sfa. skattestigninger 2023 til 2024 ",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,51),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,51),\"---------- \")","v":"---------- "}]
[null,null,"Tilskud til kommuner der valgte statsgaranti i 2024",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,44),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,44),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F99-G99,\" \")","v":" "}]
[null,{"$f":"+\"7.62.80 grp. 010 Udligning af selskabsskat\"","v":"7.62.80 grp. 010 Udligning af selskabsskat"},null,null,null,{"$f":"IF(ok_pp=1,SUM(F101:F101),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G101:G101),\" ---------- \")","v":" ---------- "}," "]
[null,null,{"$f":"+\"Udligning af selskabsskat\"","v":"Udligning af selskabsskat"},null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,15),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,15),\"---------- \")","v":"---------- "}," "]
[null,{"$f":"+\"7.62.80 grp. 011 Udligning af dækningsafgifter (offentlige ejendomme)\"","v":"7.62.80 grp. 011 Udligning af dækningsafgifter (offentlige ejendomme)"},null,null,null,{"$f":"IF(ok_pp=1,SUM(F103:F103),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G103:G103),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F102-G102,\" \")","v":" "}]
[null,null,{"$f":"+\"Udligning af dækningsafgift af offentlige ejendomme\"","v":"Udligning af dækningsafgift af offentlige ejendomme"},null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,16),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,16),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F103-G103,\" \")","v":" "}]
[null,"7.62.80 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F83+F94+F100+F102,\" \")","v":" "},{"$f":"IF(OK_P=1,+G83+G94+G100+G102,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F118-G118,\" \")","v":" "}]
[]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt)",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.81 grp. 001 Udligning vedr. udlændinge i alt",null,null,null,{"$f":"IF(ok_pp=1,SUM(F112:F113),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G112:G113),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F111-G111,\" \")","v":" "}]
[null,null,"Samlet tilskud vedr. indvandrer og efterkommere",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,13),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,13),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F112-G112,\" \")","v":" "}]
[null,null,"Samlet bidrag vedr. indv. og efterkommere (jf. G.14)",null,null,{"$f":"IF(ok_pp=1,+G291,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,14),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F113-G113,\" \")","v":" "}]
[null,"7.61.81 I alt",null,null,null,{"$f":"IF(ok_pp=1,F111,\" \")","v":" "},{"$f":"IF(OK_P=1,G111,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F114-G114,\" \")","v":" "}]
[]
[]
[]
[]
[]
[null,{"$f":"\"TABEL 3: Konteringsoversigt \"&aar&\" (del II)  for:   (\"&TEXT(knr,0)&\")  \"&$D$5","v":"TABEL 3: Konteringsoversigt 2027 (del II)  for:   (0)  Ugyldigt kommunenr. "}]
[]
[null,null,null,null,null,"Egen","Stats-","Forskel"]
[null,null,"Beløb i 1.000 kr. (+ = tilskud/ indtægt) ",null,null,"beregning","garanti","(1)-(2)"]
[null,null,null,null,null,"(1)","(2)","(3)"]
[]
[null,"7.62.86 grp. 001 Tilskud til vanskeligt stillede kommuner",null,null,null,{"$f":"IF(ok_pp=1,SUM(F127:F127),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G127:G127),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F126-G126,\" \")","v":" "}]
[null,null,"Tilskud til vanskeligt stillede kommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,33),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,33),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 002 Tilskud til Furesø Kommune",null,null,null,{"$f":"IF(ok_pp=1,SUM(F129:F129),\" \")","v":" "},{"$f":"IF(OK_P=1,SUM(G129:G129),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til Furesø Kommune",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,32),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,32),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 004 Tilskud til Ø-kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F131:F132),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G131:G132),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F130-G130,\" \")","v":" "}]
[null,null,"Tilskud til kommuner med mindre øer",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,35),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,35),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til kommuner på øer uden fast forbindelse",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,36),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,36),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 013 Tilskud til bedre kvalitet i dagtilbud",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F134:F134),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G134:G134),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F133-G133,\" \")","v":" "}]
[null,null,"Tilskud til bedre kvalitet i dagtilbud",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,22),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,22),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 014 Tilskud til generelt løft af ældreplejen",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F136:F136),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G136:G136),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til generelt løft af ældreplejen",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,23),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,23),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 015 Tilskud til styrket kvalitet i ældreplejen",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F138:F138),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G138:G138),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til styrket kvalitet i ældreplejen",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,24),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,24),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 019 Finansieringstilskud (Tilskud til styrkelse af kom. Likviditet)",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F140:F141),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G140:G141),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+SUM(H140:H141),\" \")","v":" "}]
[null,null,"Tilskud til styrkelse af kommunernes likviditet",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,20),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,20),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F140-G140,\" \")","v":" "}]
[null,null,"Ekstra likviditetstilskud",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,21),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,21),\"---------- \")","v":"---------- "}]
[null,"7.62.86 grp. 021 Individuelt tilskud vedr. skattenedsættelser ",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F143:F148),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G143:G148),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2024-2025 (økonomiaftale)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,45),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,45),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2025-2026 (økonomiaftale)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,46),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,46),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. skattenedsættelse 2022-2023 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,47),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,47),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F145-G145,\" \")","v":" "}]
[null,null,"Tilskud vedr. skattenedsættelse 2023-2024 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,48),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,48),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F146-G146,\" \")","v":" "}]
[null,null,"Tilskud vedr. skattenedsættelse 2024-2025 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,49),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,49),\"---------- \")","v":"---------- "}," "]
[null,null,"Permanent tilskud vedr. skattenedsættelse 2020-2021 (udligningsreform)",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,50),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,50),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F148-G148,\" \")","v":" "}]
[null,"7.62.86 grp. 022 Tilskud til kommuner med vanskelige vilkår",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F150:F150),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G150:G150),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til kommuner med vanskelige økonomiske vilkår",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,34),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,34),\"---------- \")","v":"---------- "}," "]
[null,"7.62.86 grp. 025 Tilskud til værdig ældrepleje",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F152:F152),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G152:G152),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F151-G151,\" \")","v":" "}]
[null,null,"Tilskud til værdig ældrepleje",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,25),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,25),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F152-G152,\" \")","v":" "}]
[null,"7.62.86 grp. 026 Tilskud til bekæmpelse af ensomhed",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F154:F154),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G154:G154),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F153-G153,\" \")","v":" "}]
[null,null,"Tilskud til bekæmpelse af ensomhed",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,26),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,26),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F154-G154,\" \")","v":" "}]
[null,"7.62.86 grp. 027 Tilskud til udsatte ø- og yder kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F156:F156),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G156:G156),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F155-G155,\" \")","v":" "}]
[null,null,"Tilskud til udsatte ø- og yderkommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,27),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,27),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F156-G156,\" \")","v":" "}]
[null,"7.62.86 grp. 028 Tilskud til udsatte hovedstadskommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F158:F159),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G158:G159),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til udsatte hovedstadskommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,28),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,28),\" ---------- \")","v":" ---------- "}," "]
[null,null,"Bidrag vedr. udsatte hovedstadskommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,29),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,29),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 029 Tilskud til grænsenære kommuner",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F161:F161),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G161:G161),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud til grænsenære kommuner",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,30),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,30),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 030 Tilskud vedr. høj kriminalitet i visse boligområder",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F163:F163),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G163:G163),\"---------- \")","v":"---------- "}," "]
[null,null,"Tilskud vedr. høj kriminalitet i visse boligområder",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,31),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,31),\" ---------- \")","v":" ---------- "}," "]
[null,"7.62.86 grp. 035 Kompensation vedr. nettotab som følge af ændring af dækningsafgiften",null,null,null,{"$f":"IF(ok_pp=1,+SUM(F165:F165),\" \")","v":" "},{"$f":"IF(OK_P=1,+SUM(G165:G165),\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F164-G164,\" \")","v":" "}]
[null,null,"Kompensationstilskud vedr. nettotab sfa. ændring i dækningsafgiften",null,null,{"$f":"IF(ok_pp=1,VLOOKUP(knr,Bilagtab1,43),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,43),\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F165-G165,\" \")","v":" "}]
[null,"7.62.86 I alt",null,null,null,{"$f":"IF(ok_pp=1,+F126+F128+F130+F133+F137+F135+F149+F139+F142+F153+F151+F155+F157+F160+F162+F164,\" \")","v":" "},{"$f":"IF(OK_P=1,+G126+G128+G130+G133+G137+G135+G149+G139+G142+G153+G151+G155+G157+G160+G162+G164,\" ---------- \")","v":" ---------- "},{"$f":"IF(ok_pp=1,+F166-G166,\" \")","v":" "}]
[]
[null,{"$f":"+\"7.62.80, 7.62.81 og 7.62.86 I alt, til afregning i \"&aar&\" (del I + del II)\"","v":"7.62.80, 7.62.81 og 7.62.86 I alt, til afregning i 2027 (del I + del II)"},null,null,null,{"$f":"IF(ok_pp=1,+F76++F104+F114+F166,\" \")","v":" "},{"$f":"IF(OK_P=1,+G76+G104+G114+G166,\"---------- \")","v":"---------- "},{"$f":"IF(ok_pp=1,+F168-G168,\" \")","v":" "}]
[]
[]
[]
[null,"Beregningsvejledning"]
[]
[]
[null,{"$f":"\"Bilag A:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag A:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Beregningsvejledning til opgørelse af kommunens beskatningsgrundlag \"&aar","v":"Beregningsvejledning til opgørelse af kommunens beskatningsgrundlag 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"A.01 Indkomstskat (jf. pkt 1.01)\"","v":"A.01 Indkomstskat (jf. pkt 1.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,+F24,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,4),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.02 Udskrivningsprocent \"&aar&\" (jf. pkt 1.02)\"","v":"A.02 Udskrivningsprocent 2027 (jf. pkt 1.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,F25,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,3),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.03 Udskrivningsgrundlag \"&aar&\" (pkt. A.01/A.02) \"","v":"A.03 Udskrivningsgrundlag 2027 (pkt. A.01/A.02) "},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(+F24/(F25/100),0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,5),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.04a Beregningsteknisk grundværdier vedr. øvrige ejendomme jf. pkt 1.03\"","v":"A.04a Beregningsteknisk grundværdier vedr. øvrige ejendomme jf. pkt 1.03"},null,null,null,null,{"$f":"IF(ok_pp=1,F26,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,9),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.04b \"&TEXT(100*'Bilag 3'!D19,\"0,00\")&\" % af beregningstekniske grundværdier vedr. øvrige ejendomme (jf. A.04a)\"","v":"A.04b 9,93 % af beregningstekniske grundværdier vedr. øvrige ejendomme (jf. A.04a)"},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(('Bilag 3'!D19)*F26,0),\" \")","v":" "},{"$f":"IF(OK_P=1,  ROUND(('Bilag 3'!D19)*(VLOOKUP(knr,Bilagtab2,9)),0),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.05a Beregningsteknisk grundværdier vedr. produktionsjord. pkt 1.04\"","v":"A.05a Beregningsteknisk grundværdier vedr. produktionsjord. pkt 1.04"},null,null,null,null,{"$f":"IF(ok_pp=1,F27,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,10),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.05b \"&TEXT(100*'Bilag 3'!D17,\" 0,00\")&\" % af beregningstekniske grundværdier vedr. produktionsjord (jf. A.05a)\"","v":"A.05b  3,06 % af beregningstekniske grundværdier vedr. produktionsjord (jf. A.05a)"},null,null,null,null,{"$f":"IF(ok_pp=1,ROUND(('Bilag 3'!D17)*F27,0),\" \")","v":" "},{"$f":"IF(OK_P=1,  ROUND(('Bilag 3'!D17)*(VLOOKUP(knr,Bilagtab2,10)),0),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.06 Beskatningsgrundlag \"&aar&\" i 1.000 kr.  (A.03 + A.04b + A.05b)\"","v":"A.06 Beskatningsgrundlag 2027 i 1.000 kr.  (A.03 + A.04b + A.05b)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G182+G184+G186,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,11),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.07 Folketal (jf. pkt. 1.05)\"","v":"A.07 Folketal (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"A.08 Beskatningsgrundlag i kr. pr. indb.  (A.06 / A.07)\"","v":"A.08 Beskatningsgrundlag i kr. pr. indb.  (A.06 / A.07)"},null,null,null,null,{"$f":"IF(ok_pp=1,G187/F28,\" \")","v":" "},{"$f":"IF(OK_P=1,H187/H188,\"---------- \")","v":"---------- "}]
[null,"Anm: A.03, A.04b og A.05b afrundes til nærmeste hele 1.000 kr.  Pkt. A.08 indgår uafrundet i udligningsberegningerne"]
[]
[]
[null,{"$f":"\"Bilag B:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag B:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Udligning af beskatningsgrundlag \"&aar","v":"Udligning af beskatningsgrundlag 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"B.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"B.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G189,\" \")","v":" "},{"$f":"IF(OK_P=1,+H189,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.02 Gennemsnitligt beskatningsgrundlag pr. indbygger\"","v":"B.02 Gennemsnitligt beskatningsgrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$20/'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$20/'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.03 Forskel (pkt. B.02 - B.01)\"","v":"B.03 Forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G199-G198,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H199-H198,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.04 Skattetryksfaktor \"","v":"B.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.05 Udligningsprocent \"","v":"B.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$27,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$27,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"B.06 Kommunens folketal 1.1.2027 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.07 Beregnet udligningsbeløb (B.03 x B.04 x B.05 x B.06) \"","v":"B.07 Beregnet udligningsbeløb (B.03 x B.04 x B.05 x B.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G200*G201*G202*G203,\" \")","v":" "},{"$f":"IF(OK_P=1,+H200*H201*H202*H203,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"B.08 12-Afrundet udligningsbeløb  \"","v":"B.08 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G204/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,3),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. B.03 Indgår uafrundet i udligningsberegningen, Pkt. B.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag C:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag C:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med lavt beskatningsgrundlag \"&aar","v":"Tillæg for kommuner med lavt beskatningsgrundlag 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"C.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"C.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G189,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H189,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.02 \"&TEXT(100*'Bilag 3'!D25,\"0,0\")&\" % af gennemsnitligt beskatningegrundlag pr. indbygger\"","v":"C.02 90,0 % af gennemsnitligt beskatningegrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$D$25 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$D$25 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.03 positiv forskel (pkt. B.02 - B.01)\"","v":"C.03 positiv forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(+G215-G214>0,G215-G214,0),\" \")","v":" "},{"$f":"IF(OK_P=1,IF(+H215-H214>0,H215-H214,),\" ---------- \")","v":" ---------- "}]
[null,{"$f":"\"C.04 Skattetryksfaktor \"","v":"C.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.05 Udligningsprocent \"","v":"C.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$28,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$28,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"C.06 Kommunens folketal 1.1.2027 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.07 Beregnet udligningsbeløb (C.03 x C.04 x C.05 x C.06) \"","v":"C.07 Beregnet udligningsbeløb (C.03 x C.04 x C.05 x C.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G216*G217*G218*G219,\" \")","v":" "},{"$f":"IF(OK_P=1,+H216*H217*H218*H219,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"C.08 12-Afrundet udligningsbeløb    \"","v":"C.08 12-Afrundet udligningsbeløb    "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G220/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,4),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. C.03 Indgår uafrundet i udligningsberegningen, Pkt. C.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag D:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag D:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med højt beskatningsgrundlag \"&aar","v":"Tillæg for kommuner med højt beskatningsgrundlag 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"D.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08\"","v":"D.01 Kommunens beskatningsgrundlag i kr. pr. indb. Jf A.08"},null,null,null,null,{"$f":"IF(ok_pp=1,+G189,\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,+H189,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.02 \"&TEXT(100*'Bilag 3'!D26,\"0,0\")&\" % af gennemsnitligt beskatningegrundlag pr. indbygger\"","v":"D.02 125,0 % af gennemsnitligt beskatningegrundlag pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$D$26 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$D$26 *  'Bilag 3'!$C$20  /    'Bilag 3'!$C$23,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.03 Negativ forskel (pkt. B.02 - B.01)\"","v":"D.03 Negativ forskel (pkt. B.02 - B.01)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(+G231-G230<0,G231-G230,0),\" ---------- \")","v":" ---------- "},{"$f":"IF(OK_P=1,IF(+H231-H230<0,H231-H230,),\" ---------- \")","v":" ---------- "}]
[null,{"$f":"\"D.04 Skattetryksfaktor \"","v":"D.04 Skattetryksfaktor "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$21/'Bilag 3'!$C$20,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.05 Udligningsprocent \"","v":"D.05 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$29,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$29,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.06 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"D.06 Kommunens folketal 1.1.2027 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.07 Beregnet udligningsbeløb (D.03 x D.04 x D.05 x D.06) \"","v":"D.07 Beregnet udligningsbeløb (D.03 x D.04 x D.05 x D.06) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G232*G233*G234*G235,\" \")","v":" "},{"$f":"IF(OK_P=1,+H232*H233*H234*H235,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"D.08 12-Afrundet udligningsbeløb    \"","v":"D.08 12-Afrundet udligningsbeløb    "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G236/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,5),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. D.03 Indgår uafrundet i udligningsberegningen, Pkt. D.08 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag E:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag E:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Udligning af udgiftsbehov \"&aar","v":"Udligning af udgiftsbehov 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"E.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)\"","v":"E.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)"},null,null,null,null,{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.02 Gennemsnitligt udgifgtsbehov pr. indbygger\"","v":"E.02 Gennemsnitligt udgifgtsbehov pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$C$32  /    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$C$32/    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.03 Forskel (pkt. B.01 - B.02)\"","v":"E.03 Forskel (pkt. B.01 - B.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,G246-G247,\"    ---------- \")","v":"    ---------- "},{"$f":"IF(OK_P=1,H246-H247,\"     ---------- \")","v":"     ---------- "}]
[null,{"$f":"\"E.04 Udligningsprocent \"","v":"E.04 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$35,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$35,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.05 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"E.05 Kommunens folketal 1.1.2027 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) \"","v":"E.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G248*G249*G250,\" \")","v":" "},{"$f":"IF(OK_P=1,+H248*H249*H250,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"E.07 12-Afrundet udligningsbeløb  \"","v":"E.07 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G251/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,9),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. E.03 Indgår uafrundet i udligningsberegningen, Pkt. E.07 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag F:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag F:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Tillæg for kommuner med højt udgiftsbehov \"&aar","v":"Tillæg for kommuner med højt udgiftsbehov 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"F.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)\"","v":"F.01 Kommunens udgiftsbehov pr. indbygger (jf. statsgaranti)"},null,null,null,null,{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,12) / VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.02 Gennemsnitligt udgifgtsbehov pr. indbygger\"","v":"F.02 Gennemsnitligt udgifgtsbehov pr. indbygger"},null,null,null,null,{"$f":"IF(OK_P=1,   'Bilag 3'!$C$32  /    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1, 'Bilag 3'!$C$32/    'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.03 Positiv forskel (pkt. B.01 - B.02)\"","v":"F.03 Positiv forskel (pkt. B.01 - B.02)"},null,null,null,null,{"$f":"IF(ok_pp=1,IF(G261-G262>0,G261-G262,0),\"      ---------- \")","v":"      ---------- "},{"$f":"IF(OK_P=1,IF(H261-H262>0,H261-H262,0),\"           ---------- \")","v":"           ---------- "}]
[null,{"$f":"\"F.04 Udligningsprocent \"","v":"F.04 Udligningsprocent "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$D$36,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$D$36,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.05 Kommunens folketal 1.1.\"&aar&\" (jf. pkt. 1.05)\"","v":"F.05 Kommunens folketal 1.1.2027 (jf. pkt. 1.05)"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) \"","v":"F.06 Beregnet udligningsbeløb (E.03 x E.04 x E.05) "},null,null,null,null,{"$f":"IF(ok_pp=1,+G263*G264*G265,\" \")","v":" "},{"$f":"IF(OK_P=1,+H263*H264*H265,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"F.07 12-Afrundet udligningsbeløb  \"","v":"F.07 12-Afrundet udligningsbeløb  "},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND(G266/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,10),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. F.03 Indgår uafrundet i udligningsberegningen, Pkt. F.07 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[null,{"$f":"\"Bilag G:   Komnr.  \"&TEXT(knr,0)&\"  \"&$D$5","v":"Bilag G:   Komnr.  0  Ugyldigt kommunenr. "}]
[null,{"$f":"\"Finansieringsbidrag fordelt efter folketal (statstilskud, indvandrerbidrag mv.) \"&aar","v":"Finansieringsbidrag fordelt efter folketal (statstilskud, indvandrerbidrag mv.) 2027"}]
[null,null,null,null,null,null,"Egen","Stats-"]
[null,"  Beløb i 1.000 kr.",null,null,null,null,"beregning","garanti"]
[null,null,null,null,null,null,"(1)","(2)"]
[null,{"$f":"\"G.01 Bloktilskud (ordinært) i \"&aar&\", der fordeles efter folketal \"","v":"G.01 Bloktilskud (ordinært) i 2027, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$10,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$10,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.02 Bloktilskud (betinget vedr service ) i \"&aar&\", der fordeles efter folketal \"","v":"G.02 Bloktilskud (betinget vedr service ) i 2027, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$11,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$11,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.03 Bloktilskud (betinget vedr anlæg) i \"&aar&\", der fordeles efter folketal \"","v":"G.03 Bloktilskud (betinget vedr anlæg) i 2027, der fordeles efter folketal "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$12,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$12,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.04 Bidragspulje til udligningsordn. indv. og efterkommere \"&aar","v":"G.04 Bidragspulje til udligningsordn. indv. og efterkommere 2027"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$38,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$38,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.05 Bidragspulje til korrektion vedr. overudligning \"&aar","v":"G.05 Bidragspulje til korrektion vedr. overudligning 2027"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$40,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$40,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.06 Finansiering af tillæg vedr. beskatningsgrundlag \"&aar","v":"G.06 Finansiering af tillæg vedr. beskatningsgrundlag 2027"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$41,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$41,\"---------- \")","v":"---------- "}]
[null,{"$f":"+\"G.07 Finansiering af tillæg vedr. udgiftsbehov  \"&aar","v":"G.07 Finansiering af tillæg vedr. udgiftsbehov  2027"},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$42,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$42,\"---------- \")","v":"---------- "}]
[]
[null,{"$f":"\"G.08 Samlet folketal \"&aar&\" i hele landet \"","v":"G.08 Samlet folketal 2027 i hele landet "},null,null,null,null,{"$f":"IF(OK_P=1,'Bilag 3'!$C$33,\"---------- \")","v":"---------- "},{"$f":"IF(OK_P=1,'Bilag 3'!$C$33,\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.09 Kommunens folketal\"","v":"G.09 Kommunens folketal"},null,null,null,null,{"$f":"IF(ok_pp=1,F28,\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab2,13),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.10 Kommunens andel af samlet folketal (pkt. G.09/G.08)\"","v":"G.10 Kommunens andel af samlet folketal (pkt. G.09/G.08)"},null,null,null,null,{"$f":"IF(ok_pp=1,+G285/G284,\" \")","v":" "},{"$f":"IF(OK_P=1,+H285/H284,\"---------- \")","v":"---------- "}]
[]
[null,{"$f":"\"G.11 Kommunens andel af ordinært bloktilskud (E.01 x G.10)\"","v":"G.11 Kommunens andel af ordinært bloktilskud (E.01 x G.10)"},null,null,null,null,{"$f":"IF(ok_pp=1,12*ROUND((G276*$G$286)/12,0),\" \")","v":" "},{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,17),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.12 Kommunens andel af betinget bloktilskud (service) (G.02 x G.10)\"","v":"G.12 Kommunens andel af betinget bloktilskud (service) (G.02 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,18),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.13 Kommunens andel af betinget bloktilskud (anlæg) (G.03 x G.10)\"","v":"G.13 Kommunens andel af betinget bloktilskud (anlæg) (G.03 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,19),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.14 Kommunens bidrag vedr. indv. og efterkommere (G.04 x G.08)\"","v":"G.14 Kommunens bidrag vedr. indv. og efterkommere (G.04 x G.08)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,14),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.15 Kommunen korrektion vedr. overudligning (G.05 x G.10)\"","v":"G.15 Kommunen korrektion vedr. overudligning (G.05 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,8),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.16 Kommunens finansieringsandel af tillæg vedr. beskatningsgrundlag (G.06 x G.10)\"","v":"G.16 Kommunens finansieringsandel af tillæg vedr. beskatningsgrundlag (G.06 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,6),\"---------- \")","v":"---------- "}]
[null,{"$f":"\"G.17 Kommunens finansieringsandel af tillæg vedr. udgiftsbehov (G.075 x G.10)\"","v":"G.17 Kommunens finansieringsandel af tillæg vedr. udgiftsbehov (G.075 x G.10)"},null,null,null,null," ",{"$f":"IF(OK_P=1,VLOOKUP(knr,Bilagtab1,11),\"---------- \")","v":"---------- "}]
[null,"Anm: Pkt. G.10 Indgår uafrundet i udligningsberegningen, Pkt. G.11-G.17 afrundes til hele 12-tusind (IM afrunding kan afvige)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Bilag 1 ","index":1,"n_rows":115,"n_cols":54,"rows_kept":115,"cut":false,"hidden":false,"merged":[[0,19,0,30],[0,31,0,41],[0,44,0,53]]}
[{"$f":"\"Bilagstabel 1: Udligningsbeløb statsgaranti \"&aar","v":"Bilagstabel 1: Udligningsbeløb statsgaranti 2027"},null,null,null,null,null,"samle 1",null,null,null,null,null,null,"samle 2",null,null,null,"samle 3",null,"samle 4.1",null,null,null,null,null,null,null,null,null,null,null,"samle 4.2",null,null,null,null,null,null,null,null,null,null,null,null,"samle 4.3"]
[null,null,1,{"$f":"+C2+1","v":2},{"$f":"+D2+1","v":3},4,5,6,7,8,9,10,1,{"$f":"+M2+1","v":2},{"$f":"+N2+1","v":3},4,1,{"$f":"+Q2+1","v":2},{"$f":"+R2+1","v":3},1,{"$f":"+T2+1","v":2},{"$f":"+U2+1","v":3},4,5,6,7,8,9,10,11,12,1,{"$f":"+AF2+1","v":2},{"$f":"+AG2+1","v":3},{"$f":"+AH2+1","v":4},{"$f":"+AI2+1","v":5},{"$f":"+AJ2+1","v":6},{"$f":"+AK2+1","v":7},{"$f":"+AL2+1","v":8},{"$f":"+AM2+1","v":9},{"$f":"+AN2+1","v":10},{"$f":"+AO2+1","v":11},{"$f":"+AP2+1","v":12},13,1,{"$f":"+AS2+1","v":2},{"$f":"+AT2+1","v":3},{"$f":"+AU2+1","v":4},{"$f":"+AV2+1","v":5},{"$f":"+AW2+1","v":6},{"$f":"+AX2+1","v":7},{"$f":"+AY2+1","v":8},{"$f":"+AZ2+1","v":9},{"$f":"+BA2+1","v":10}]
["knr","kommunenavn"," Udlig-"," Tillæg"," Tillæg"," Finan-"," Over-"," Korrek-"," Udlig-"," Tillæg"," Finan-"," Særlig"," Tilskud"," Bidrag"," Udlig-"," Udlig-"," Ordinært"," Betinget"," Betinget"," Finan-","Ekstra"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Bidrag"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Tilskud"," Moms-"," Moms-"," Tilskud","Om-","Kompen-","Tilskud"," Indivi-"," Indivi-"," Midler-"," Midler-"," Midler-"," Per-"," Indivi-"]
[null,null," ning"," for kom-"," for kom-"," siering"," udlig-"," tion"," ning"," for"," siering"," kom-"," vedr."," vedr."," ning"," ning"," blok-"," blok-"," blok-"," sierings-","finan-"," til"," til"," til"," til"," til"," til"," til"," til"," til"," vedr."," til"," til"," til kom-"," til"," til"," til"," til"," kompen-"," kompen-"," til","stil-","sations-","til kom-"," duelle"," duelle"," tidigt"," tidigt"," tidigt"," manent"," duel"]
[null,null," af"," muner"," muner"," af"," ning"," vedr."," udgifts-"," kom-"," af"," pen-"," ind-"," ind-"," af"," af"," tilskud"," tilskud"," tilskud"," tilskud"," sierings-"," bedre"," generelt"," styrket"," værdig"," bekæm-"," udsatte"," udsatte"," udsatte"," grænse-"," høj"," Furesø"," vanske-"," muner"," kom-"," kom-"," nedsæt-"," nedsæt-"," sation"," sation","færge-","lings-","tilskud","muner"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," tilskud"," mod-"]
[null,null," beskat-"," med"," med"," tillæg",null," over-"," behov"," muner"," tillæg"," sation"," vandrer"," vandrer"," sel-"," dæk-",null," vedr."," vedr.",null," tilskud"," kvalitet"," løft i"," kvalitet"," ældre-"," pelse"," ø-"," hoved-"," hoved-"," nære"," krimi-"," Kom-"," ligt"," med"," muner"," muner"," telse"," telse"," vedr."," vedr.","drift","støtte","vedr.","der"," vedr."," vedr."," vedr."," vedr."," vedr."," vedr."," regning"]
[null,null," nings-"," lavt"," højt"," vedr.",null," udlig-",null," med"," vedr.",null," og"," og"," skabs-"," nings-",null," service-"," anlæg",null,null," i dag-"," ældre-"," ældre-"," pleje"," af"," og"," stads-"," stads-"," kom-"," nalitet"," mune"," stillede"," vanske-"," med"," på øer"," af"," af"," færge-"," færge-",null,"(færger)","netto-","valgte"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," skatte-"," sfa."]
[null,null," grundlag"," beskat-"," beskat-"," beskat-",null," ning",null," højt"," udgifts-",null," efter-"," efter-"," skat"," afgift",null," udgifter",null,null,null," tilbud"," plejen"," pleje",null," ensom-"," yder-"," kom-"," kom-"," muner"," i visse",null," kom-"," lige"," mindre"," uden"," takster"," takster"," takster"," takster",null,null,"tab sfa.","stats-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," nedsæt-"," skatte-"]
[null,null,null," nings-"," nings-"," nings-",null,null,null," udgifts-"," behov",null," kom-"," kom-",null,null,null,null,null,null,null,null,null,null,null," hed på"," kom-"," muner"," muner",null," bolig-",null," muner"," økono-"," øer"," fast"," for"," for"," for"," for",null,null,"ændring","garanti"," telser"," telser"," telser"," telser"," telser"," telser"," stig-"]
[null,null,null," grundlag"," grundlag"," grundlag",null,null,null," behov",null,null," mere"," mere",null,null,null,null,null,null,null,null,null,null,null," ældre-"," muner",null,null,null," områder",null,null," miske",null," forbin-"," gods-"," passa-"," gods-"," passa-",null,null,"i dæk-","1 2024","(ØA)","(ØA)","(Udl.ref)","(Udl.ref)","(Udl.ref)","(Udl.ref)"," ninger"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," området",null,null,null,null,null,null,null," vilkår",null," delse"," transport"," gerer mv."," transport"," gerer mv.",null,null,"nings-",null,"2024-2025"," 2025-2026"," 2022-2023","2023-2024","2024-2025"," 2020-2021","2023-2024"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"afgiften"]
[null,null,3,{"$f":"+C13+1","v":4},{"$f":"+D13+1","v":5},6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54]
[null,null,1,{"$f":"+C14+1","v":2},{"$f":"+D14+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52]
[]
[1,"Kommuner i alt",{"$f":"SUM(C18:C115)","v":0},520236,-1483992,963756,315528,-315528,0,256224,-256224,0,3926784,-3926784,0,0,42398808,3000000,999996,3500004,1827996,687600,916296,1227696,1285896,122604,1815804,731904,-437700,121104,109104,39696,936,385500,143796,271800,46800,165696,9996,13692,2500,19296,408900,729396,72252,90192,29844,64116,30696,257544,-162480,0,0,0]
[]
[101,"København",-2237808,0,0,107892,0,-35328,-3070404,0,-28680,182604,563928,-439620,-545616,-19884,4746768,335868,111960,167928,51168,82668,50700,67920,71148,6780,0,0,-61272,30276,30312,0,0,0,0,0,0,0,0,0,0,0,0,0,68724,60372,0,64116,12984,0,0]
[147,"Frederiksberg",-1407336,0,-29196,16944,3300,-5544,-1042800,0,-4512,-24384,53436,-69060,67896,-1956,745668,52764,17592,26376,8040,12408,13668,18312,19188,1824,0,0,-12744,0,0,0,0,0,0,0,0,0,0,0,0,0,10260,0,0,10764,0,0,0,0,-62832]
[151,"Ballerup",-9672,0,0,8736,0,-2856,369180,7944,-2316,-11340,61524,-35580,-307512,-108,384204,27180,9060,28692,14484,6984,8148,10920,11436,1092,0,32988,-5076,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[153,"Brøndby",342816,37248,0,6696,0,-2196,568152,12216,-1776,47592,73584,-27276,-33192,192,294516,20844,6948,37944,22044,5508,5280,7068,7404,708,0,75852,-3168,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[155,"Dragør",-258108,0,-20304,2292,1032,-744,-83052,0,-612,-3336,4200,-9324,12108,168,100632,7116,2376,3564,1080,1644,2796,3744,3924,372,0,0,-2328,0,0,0,0,0,0,0,0,0,0,0,0,0,168,18912,0,0,0,0,0,0,0]
[157,"Gentofte",-3825636,0,-700848,11940,131244,-3912,-536892,0,-3168,-17568,49692,-48636,-99288,264,525132,37152,12384,18576,5664,7968,12420,16644,17436,1668,0,0,-117936,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3528,10248,0,0,9984,0,0]
[159,"Gladsaxe",-395376,0,0,11400,0,-3732,130044,2796,-3024,-16404,92712,-46428,-662088,708,501312,35472,11820,17736,5400,9036,8880,11904,12468,1188,0,0,-7488,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[161,"Glostrup",69024,0,0,4164,0,-1368,104700,2256,-1104,-5304,39060,-16980,708,-972,183300,12972,4320,13692,6912,3396,3324,4464,4668,444,0,15732,-2316,4848,0,0,0,0,0,0,0,0,0,0,0,0,0,34212,0,0,0,0,0,0,0]
[163,"Herlev",77892,0,0,5196,0,-1704,172776,3720,-1380,-6780,42048,-21156,8892,-1692,228492,16164,5388,17064,8616,4152,4356,5832,6108,576,0,39228,-2844,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[165,"Albertslund",194976,14016,0,4692,0,-1536,342348,7368,-1248,84192,41316,-19128,9576,264,206496,14616,4872,26604,15456,3336,3996,5352,5616,540,0,35448,-2460,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[167,"Hvidovre",17388,0,0,8676,0,-2844,251928,5412,-2304,33024,46140,-35328,17940,-192,381444,26988,9000,28476,14388,6648,7164,9600,10056,960,0,65496,-5172,0,0,0,0,0,0,0,0,0,0,0,0,0,0,108744,0,0,6828,0,0,0,0]
[169,"Høje-Taastrup",310716,3264,0,9840,0,-3216,227604,4896,-2616,132984,107148,-40080,-48456,492,432744,30624,10212,32316,16320,8652,7020,9396,9840,936,0,74304,-4740,0,6060,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[173,"Lyngby-Taarbæk",-1454808,0,-178884,9348,24648,-3060,-390936,0,-2484,-13068,46860,-38112,-79524,384,411456,29112,9708,14556,4440,6312,8628,11556,12108,1152,0,0,-23988,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[175,"Rødovre",49284,0,0,7308,0,-2388,238308,5124,-1944,18264,56016,-29784,40332,348,321552,22752,7584,24012,12120,5784,6024,8064,8448,804,0,55212,-3804,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[183,"Ishøj",219180,26292,0,3972,0,-1296,347736,7476,-1056,114948,46908,-16188,19608,192,174816,12372,4128,22524,13080,3204,2796,3744,3924,372,0,45024,-1884,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[185,"Tårnby",-86172,0,0,7080,0,-2316,84192,1812,-1884,840,28044,-28860,18972,576,311652,22056,7356,11028,3360,5376,6084,8160,8544,816,0,53508,-4368,12108,0,0,0,0,0,0,0,0,0,0,0,0,816,0,0,0,0,0,0,0,-19968]
[187,"Vallensbæk",18132,0,0,3024,0,-996,-39816,0,-804,9024,33456,-12324,12096,252,133104,9420,3144,4704,1440,2652,2400,3216,3360,324,0,0,-1668,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[190,"Furesø",-723744,0,-48792,6864,1692,-2244,-133296,0,-1824,-9696,30324,-27960,17724,528,301848,21360,7116,10680,3252,5856,7272,9744,10212,972,0,0,-5436,0,0,39696,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[201,"Allerød",-385788,0,-15624,4224,0,-1380,-219828,0,-1128,-6048,13368,-17220,-11040,288,185976,13164,4380,6576,2004,3480,4464,5976,6264,600,0,0,-3312,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[210,"Fredensborg",-370824,0,0,6792,0,-2220,-31332,0,-1812,-9600,33216,-27672,23256,540,298848,21144,7044,10572,3216,5112,7416,9948,10416,996,0,0,-4812,0,0,0,0,0,0,0,0,0,0,0,0,0,0,50892,0,0,0,0,0,0,0]
[217,"Helsingør",-427512,0,0,10272,0,-3360,62544,1344,-2736,-14688,29208,-41856,49764,612,451896,31980,10656,15984,4872,6888,12504,16752,17544,1668,0,0,-6912,12108,6060,0,0,0,0,0,0,0,0,0,0,0,600,0,0,0,0,0,0,0,0]
[219,"Hillerød",-409044,0,0,8844,0,-2892,-289236,0,-2352,-12012,36012,-36048,-184128,-60,389268,27540,9180,13776,4200,6732,8172,10956,11472,1092,0,0,-5664,0,0,0,0,0,0,0,0,0,0,0,0,0,3432,113004,0,0,18396,0,0,0,0]
[223,"Hørsholm",-832488,0,-126240,4044,35100,-1320,-152664,0,-1080,-5844,13992,-16464,-30900,192,177744,12576,4188,6288,1920,2748,5760,7716,8076,768,0,0,-30924,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[230,"Rudersdal",-2215224,0,-364104,9204,118512,-3012,-363072,0,-2448,-13236,34596,-37500,-9972,564,404892,28644,9552,14328,4368,7044,10788,14460,15144,1440,0,0,-71712,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3720,0,0,0,0,0]
[240,"Egedal",-253512,0,0,7416,0,-2424,-335976,0,-1968,-10164,26400,-30216,22476,624,326208,23076,7692,11544,3516,6804,6516,8724,9144,876,0,0,-4848,0,0,0,0,0,0,0,0,0,0,0,0,0,5436,0,0,0,0,0,0,0,0]
[250,"Frederikssund",-84204,0,0,7608,0,-2496,-75180,0,-2028,11844,22248,-30996,45900,132,334608,23676,7896,11832,3612,4956,8964,12012,12588,1200,0,57456,-4560,0,0,0,0,0,0,0,0,0,0,0,0,0,5580,0,0,5088,0,0,7728,0,0]
[253,"Greve",-129840,0,0,8712,0,-2856,-52608,0,-2316,-396,43644,-35496,37344,708,383244,27120,9036,13560,4128,7236,8352,11184,11712,1116,0,0,-5472,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[259,"Køge",-26748,0,0,10260,0,-3360,34500,744,-2724,98232,38712,-41784,37824,420,451104,31920,10644,33684,17016,7884,9660,12948,13560,1296,0,77448,-5856,0,6060,0,0,0,0,0,0,0,0,0,0,0,7524,0,0,0,0,0,0,0,0]
[260,"Halsnæs",7260,0,0,5064,0,-1656,15228,324,-1344,85560,14220,-20652,32712,348,222924,15768,5256,16644,8400,2808,6564,8796,9216,876,0,57420,-2988,0,0,0,0,0,0,0,0,0,0,0,0,0,96,0,0,0,0,0,0,0,0]
[265,"Roskilde",-652776,0,0,14856,0,-4860,-492852,0,-3948,-20604,49092,-60516,47316,-1092,653436,46236,15408,23112,7044,10248,14148,18960,19860,1896,0,0,-9696,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[269,"Solrød",-186048,0,0,4020,0,-1320,-166704,0,-1068,-5460,12180,-16392,19440,336,176940,12516,4176,6264,1908,3384,3696,4944,5184,492,0,0,-2604,0,0,0,0,0,0,0,0,0,0,0,0,0,2952,0,0,0,0,0,0,0,0]
[270,"Gribskov",-326700,0,0,6672,0,-2184,-91092,0,-1776,-9648,15204,-27192,40200,60,293640,20772,6924,10392,3168,3864,8964,12012,12588,1200,0,0,-4596,0,0,0,0,0,0,0,0,0,0,0,0,0,4896,76344,0,0,0,0,0,0,0]
[306,"Odsherred",-45228,0,0,5064,0,-1656,264996,5700,-1344,-7764,10476,-20628,28512,348,222672,15756,5256,16620,8400,2304,7776,10416,10920,1044,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3720,0,0,0,0,0,0,16056,0]
[316,"Holbæk",131232,0,0,12000,0,-3924,134760,2904,-3192,-16776,38292,-48888,39648,1008,527808,37344,12444,39408,19908,7980,12300,16476,17256,1644,0,0,0,0,0,0,0,0,11772,0,1188,11040,360,1896,0,624,8808,0,0,0,0,0,0,0,0]
[320,"Faxe",173052,0,0,6096,0,-1992,61548,1320,-1620,-8604,16536,-24828,27708,516,268080,18972,6324,34536,20064,3816,6636,8892,9312,888,20136,0,0,0,0,0,0,15912,0,0,0,0,0,0,0,0,4476,0,0,0,0,0,0,0,0]
[326,"Kalundborg",-20004,0,0,7608,0,-2496,311052,6684,-2028,-11388,28344,-30996,-214812,600,334728,23688,7896,24996,12624,4092,8940,11976,12540,1200,50280,0,0,0,0,0,0,0,13920,0,2172,1644,468,0,0,2172,5580,0,0,0,0,0,0,0,0]
[329,"Ringsted",76572,0,0,5760,0,-1884,65472,1404,-1536,-8172,23748,-23472,29880,324,253380,17928,5976,32640,18960,3960,5016,6732,7044,672,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4224,0,0,0,0,0,0,21480,0]
[330,"Slagelse",442116,13344,0,12924,0,-4236,560520,12060,-3432,-18588,50160,-52644,61500,-24,568476,40224,13404,73236,42540,8268,13680,18324,19188,1824,0,0,0,0,12120,0,0,0,14520,0,1452,2976,0,0,0,1068,9480,0,0,0,0,0,0,0,-15732]
[336,"Stevns",20496,0,0,3804,0,-1248,-10776,0,-1008,12936,9072,-15480,25248,312,167160,11832,3936,5916,1800,2316,4584,6144,6432,612,0,28704,-2136,0,0,0,0,0,0,0,0,0,0,0,0,0,2784,0,0,0,0,0,0,0,0]
[340,"Sorø",75000,0,0,4932,0,-1620,55560,1200,-1308,-6996,11832,-20100,29556,348,217092,15360,5124,16212,8184,3540,5232,7020,7356,696,16308,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3624,0,0,0,0,0,0,5052,0]
[350,"Lejre",-60744,0,0,4788,0,-1572,-135864,0,-1272,-6516,11760,-19512,13872,372,210672,14904,4968,7452,2268,3804,4884,6552,6852,648,0,18084,-2916,0,0,0,0,0,0,0,0,0,0,0,0,0,3516,0,0,0,0,0,0,0,0]
[360,"Lolland",203136,4956,0,6084,0,-1992,706008,15180,-1620,22776,21000,-24780,34164,432,267612,18936,6312,34476,20028,2868,8832,11832,12396,1176,60300,0,0,0,0,0,0,15876,24876,0,2760,4908,612,0,0,1512,4464,0,0,0,0,0,0,43272,0]
[370,"Næstved",287556,0,0,13584,0,-4452,192444,4140,-3612,-19464,43200,-55344,74292,648,597600,42288,14100,76992,44724,8712,14376,19260,20172,1920,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9972,0,0,0,0,0,0,0,0]
[376,"Guldborgsund",322020,10020,0,9372,0,-3072,560832,12060,-2496,-14256,26400,-38196,58308,216,412428,29184,9732,53136,30864,5280,12252,16416,17196,1644,92940,0,0,0,0,0,0,24480,0,0,0,0,0,0,0,0,6876,0,0,0,0,0,0,0,0]
[390,"Vordingborg",151500,0,0,7116,0,-2328,261828,5628,-1896,-10740,17796,-28992,45420,276,312972,22140,7380,40320,23424,3708,9576,12828,13440,1284,70524,0,0,0,0,0,0,18576,0,0,0,0,0,0,0,0,5220,0,0,0,0,0,0,0,-10692]
[400,"Bornholm",223584,10104,0,6120,0,-2004,142896,3072,-1632,21756,13752,-24936,36168,252,269232,19044,6348,34680,20148,3348,8868,11880,12432,1188,80892,0,0,0,0,0,0,15972,0,61044,0,0,0,0,0,0,4488,0,0,0,0,0,0,0,0]
[410,"Middelfart",46152,0,0,6492,0,-2124,-88500,0,-1728,-9048,15336,-26460,17712,192,285732,20220,6744,10104,3084,4680,7428,9948,10428,996,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4764,0,0,0,0,0,0,0,0]
[420,"Assens",233004,10296,0,6408,0,-2100,172428,3708,-1704,-9648,14244,-26100,21312,540,281856,19944,6648,36312,21096,3972,7428,9960,10428,996,42336,0,0,0,0,0,0,16728,2892,0,744,588,120,60,0,144,4704,0,0,0,0,0,0,0,0]
[430,"Faaborg-Midtfyn",347124,25056,0,8340,0,-2736,81744,1764,-2220,-12156,19080,-33996,47544,612,367044,25968,8652,47292,27468,5604,9984,13368,14004,1332,82704,0,0,0,0,0,0,21780,8832,0,1068,2496,156,240,0,828,6120,0,0,0,0,0,0,0,0]
[440,"Kerteminde",48108,0,0,3864,0,-1272,40944,876,-1032,-5568,11592,-15756,13836,312,170160,12036,4008,21924,12732,2592,4884,6552,6864,648,25560,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3600,0]
[450,"Nyborg",159036,660,0,5160,0,-1692,129960,2796,-1368,-7524,15612,-21024,29472,432,227040,16068,5352,29256,16992,3096,6252,8388,8784,840,51156,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3792,0,0,0,0,0,0,4884,0]
[461,"Odense",1343004,81408,0,34200,0,-11196,96456,2076,-9096,-48072,156804,-139356,128532,336,1504632,106464,35484,193836,112608,24912,28140,37704,39492,3768,0,0,0,0,18192,0,0,0,0,0,0,0,0,0,0,0,25104,0,0,0,0,0,0,0,0]
[479,"Svendborg",340644,13236,0,9588,0,-3144,133404,2868,-2544,-13740,23184,-39084,49932,492,421956,29856,9948,54360,31584,6684,11268,15096,15804,1512,95088,0,0,0,0,0,0,0,8976,0,276,564,0,0,0,672,7044,0,0,0,0,0,0,42732,0]
[480,"Nordfyn",147516,1920,0,4620,0,-1512,127860,2748,-1224,-6972,11928,-18840,17736,384,203472,14400,4800,26208,15228,2856,5364,7188,7536,720,45852,0,0,0,0,0,0,12072,0,0,0,0,0,0,0,0,3396,0,0,0,0,0,0,0,0]
[482,"Langeland",64224,1992,0,1872,0,-612,114012,2448,-492,9708,4488,-7620,7920,156,82284,5820,1944,10596,6156,732,3324,4452,4668,444,30900,0,0,0,0,0,0,4884,5148,0,660,504,168,96,0,492,1368,15840,0,0,0,0,0,27396,0]
[492,"Ærø",45072,4656,0,912,0,-300,19548,420,-240,10032,1452,-3708,6264,60,40032,2832,948,5160,3000,432,1644,2196,2304,216,15036,0,0,0,0,0,0,2376,1344,65376,10860,36000,2772,636,0,5124,672,7644,0,0,0,0,0,0,0]
[510,"Haderslev",337308,18984,0,8772,0,-2868,317760,6828,-2328,-13056,32112,-35736,43332,588,385848,27300,9096,49704,28872,5352,10164,13620,14268,1356,86940,0,0,0,0,0,0,0,4848,0,372,1776,0,0,0,156,6432,0,0,0,0,0,0,0,0]
[530,"Billund",66540,0,0,4344,0,-1428,55656,1200,-1152,-6252,23376,-17688,-269016,252,190992,13512,4500,24600,14292,3048,4524,6060,6348,600,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3180,0,0,0,0,0,0,0,0]
[540,"Sønderborg",377268,5316,0,11772,0,-3852,384180,8268,-3132,-9408,50988,-47988,40896,684,518136,36660,12216,66756,38772,6900,14412,19308,20232,1932,77832,0,0,20592,0,0,0,0,0,0,0,0,0,0,1168,0,8640,0,0,0,0,0,0,0,0]
[550,"Tønder",236808,16776,0,5736,0,-1872,259644,5580,-1524,-7368,19824,-23352,32028,420,252132,17844,5952,32484,18864,3336,7260,9732,10188,972,56820,0,0,10896,0,0,0,14964,0,0,0,0,0,0,0,0,4200,63216,0,0,0,0,0,0,0]
[561,"Esbjerg",304080,0,0,18288,0,-5988,338940,7284,-4860,-27084,62988,-74508,54864,792,804504,56928,18972,103644,60204,12312,19020,25476,26688,2544,0,0,0,0,6060,0,0,0,504,0,108,0,36,0,0,0,13416,0,0,0,0,0,0,0,0]
[563,"Fanø",-34692,0,0,528,0,-168,-12972,0,-144,-684,588,-2148,3456,48,23172,1644,552,816,252,252,876,1188,1236,120,0,0,0,0,0,0,0,0,0,23784,6348,41760,1848,4740,0,0,384,0,0,0,0,0,0,0,0]
[573,"Varde",115248,0,0,7860,0,-2568,119928,2580,-2088,-11724,22008,-32004,37368,300,345588,24456,8148,25800,13032,5328,9072,12156,12732,1212,51912,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5760,0,0,0,0,0,0,0,0]
[575,"Vejen",159204,0,0,6780,0,-2220,111036,2388,-1800,-10032,24288,-27636,26664,540,298368,21108,7032,38436,22332,4620,7092,9492,9948,948,0,0,0,0,0,0,0,17712,0,0,0,0,0,0,0,0,4980,0,0,0,0,0,0,0,0]
[580,"Aabenraa",374496,24924,0,9264,0,-3036,308496,6636,-2460,-13812,30708,-37740,18624,324,407484,28836,9612,52500,30492,5520,10908,14616,15312,1464,61212,0,0,30276,0,0,936,24180,2460,0,216,276,12,0,0,84,6792,0,0,0,0,0,0,0,0]
[607,"Fredericia",146100,0,0,8460,0,-2772,326892,7032,-2256,-12084,35544,-34488,-53100,528,372432,26352,8784,27804,14040,5604,8688,11640,12192,1164,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[615,"Horsens",508104,6816,0,15900,0,-5208,23940,516,-4224,18612,69708,-64800,64176,888,699672,49500,16500,90132,52368,12948,13632,18264,19128,1824,0,0,0,0,0,0,0,0,11520,0,696,756,96,36,0,576,11676,0,0,0,0,0,0,0,-11088]
[621,"Kolding",255480,0,0,15396,0,-5040,81648,1752,-4092,-21840,72696,-62724,21180,324,677256,47916,15972,50568,25536,11052,14232,19068,19968,1908,0,0,0,0,6060,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[630,"Vejle",148440,0,0,19752,0,-6468,23712,504,-5256,-27084,90492,-80460,73200,1068,868800,61476,20496,64872,32760,15612,18036,24168,25308,2412,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14496,0,0,0,0,0,0,0,0]
[657,"Herning",403524,0,0,14448,0,-4728,-97500,0,-3840,-20904,55188,-58872,25056,-2244,635604,44976,14988,81888,47568,10368,14268,19128,20028,1908,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10608,0,0,0,0,0,0,0,-18480]
[661,"Holstebro",296016,2376,0,9456,0,-3096,-92496,0,-2520,-13728,30780,-38556,41124,576,416256,29448,9816,53628,31152,7032,9672,12948,13572,1296,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6948,0,0,0,0,0,0,0,0]
[665,"Lemvig",9948,0,0,2928,0,-960,61272,1320,-780,-4644,8964,-11952,10884,216,129048,9132,3048,9636,4860,1632,3996,5352,5604,540,19392,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2148,13788,0,0,0,0,0,0,0]
[671,"Struer",112392,4296,0,3168,0,-1044,95964,2064,-840,-576,10140,-12936,18048,264,139620,9876,3288,17988,10452,1692,4248,5700,5964,564,31464,0,0,0,0,0,0,8280,4608,0,312,2328,0,0,0,108,2328,0,0,0,0,0,0,0,0]
[706,"Syddjurs",138972,0,0,7092,0,-2328,-100704,0,-1884,-10056,14808,-28896,42240,576,312012,22080,7356,23292,11760,5112,8616,11544,12084,1152,46872,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5208,28428,0,0,0,0,0,0,0]
[707,"Norddjurs",224328,12936,0,5796,0,-1896,184380,3960,-1536,-8820,15948,-23616,32424,372,254940,18036,6012,32844,19080,3420,7320,9816,10284,984,57444,0,0,0,0,0,0,15132,9432,0,2496,3840,336,0,0,396,4248,0,0,0,4620,0,0,22548,0]
[710,"Favrskov",147348,0,0,7944,0,-2604,-261636,0,-2112,-11352,21492,-32376,30132,528,349620,24732,8244,12372,3768,7080,7176,9612,10068,960,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5832,0,0,0,0,0,0,0,0]
[727,"Odder",54732,0,0,3900,0,-1272,-62088,0,-1032,-5340,9624,-15900,25392,324,171624,12144,4044,6072,1848,2904,4584,6144,6432,612,0,0,0,0,0,0,0,0,3756,0,756,1884,96,0,0,216,2868,0,0,0,0,0,0,0,0]
[730,"Randers",627672,37212,0,16092,0,-5268,460188,9900,-4272,-22992,50364,-65544,69048,732,707724,50076,16692,91176,52968,11868,15852,21240,22248,2124,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9696,0,0,0,0,0,0,0,0]
[740,"Silkeborg",221844,0,0,16548,0,-5424,-377568,0,-4404,-21924,43776,-67428,64500,1284,728100,51516,17172,25764,7848,14904,15192,20352,21312,2028,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12144,0,0,0,0,0,0,0,0]
[741,"Samsø",11676,0,0,576,0,-192,12948,276,-156,-864,972,-2340,3540,48,25236,1788,600,1884,948,300,972,1308,1368,132,5688,0,0,0,0,0,0,0,0,64716,9168,30420,1872,3324,0,1356,420,0,0,0,0,0,0,0,0]
[746,"Skanderborg",39852,0,0,10620,0,-3480,-425280,0,-2820,-14664,25224,-43272,35400,840,467232,33060,11016,16524,5040,9756,9228,12360,12948,1236,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7788,0,0,0,0,0,0,0,0]
[751,"Århus",874908,0,0,61068,0,-19992,-1839432,0,-16236,-81684,271344,-248844,37476,-8160,2686800,190104,63372,95052,28956,44580,41640,55788,58440,5568,0,0,0,0,18180,0,0,0,0,0,0,0,0,0,0,0,4956,0,0,0,0,0,0,0,0]
[756,"Ikast-Brande",287568,20616,0,6936,0,-2268,57000,1224,-1848,-9684,33252,-28236,-30780,588,304884,21576,7188,39276,22812,5172,6720,9000,9420,900,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5088,0,0,0,0,0,0,0,0]
[760,"Ringkøbing-Skjern",132012,0,0,8772,0,-2868,15240,324,-2328,-13308,31452,-35748,8772,648,385992,27312,9108,49728,28884,5748,10188,13644,14292,1368,28992,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6444,0,0,0,0,0,0,0,0]
[766,"Hedensted",217944,0,0,7788,0,-2544,-147012,0,-2064,-10944,20040,-31716,10440,564,342396,24228,8076,25560,12912,5844,7680,10284,10776,1032,0,0,0,0,0,0,0,0,3300,0,180,840,0,108,0,168,5712,0,0,0,0,0,0,0,0]
[773,"Morsø",131328,10308,0,3060,0,-996,131508,2832,-816,23148,7332,-12444,8328,240,134376,9504,3168,17316,10056,1848,4080,5472,5724,540,30276,0,0,0,0,0,0,7980,0,0,0,0,0,0,0,0,2244,0,0,0,0,0,0,0,0]
[779,"Skive",222204,2772,0,6984,0,-2292,183696,3948,-1860,18384,19572,-28440,21468,396,307116,21732,7248,39564,22980,4056,8700,11652,12216,1164,69204,0,0,0,0,0,0,18228,8460,0,1128,4572,240,876,434,408,5124,0,0,0,0,0,0,0,0]
[787,"Thisted",287496,22032,0,6756,0,-2208,143748,3096,-1800,-10188,18708,-27516,25272,372,297060,21024,7008,38268,22236,4632,8052,10788,11304,1080,44628,0,0,0,0,0,0,17628,0,0,0,0,0,0,0,0,4956,0,0,0,0,0,0,0,0]
[791,"Viborg",433356,0,0,15588,0,-5100,-6060,0,-4140,-22824,49740,-63516,35688,-624,685788,48528,16176,88344,51324,10440,16056,21516,22536,2148,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11436,0,0,0,0,0,0,0,0]
[810,"Brønderslev",285348,29004,0,5820,0,-1908,77808,1668,-1548,-8532,16908,-23712,31548,324,256056,18120,6036,32988,19164,4380,6288,8424,8820,840,57696,0,0,0,0,0,0,15192,0,0,0,0,0,0,0,0,4272,0,0,0,0,0,0,31668,0]
[813,"Frederikshavn",249360,0,0,9096,0,-2976,324912,6984,-2424,24468,22296,-37080,39456,516,400428,28332,9444,51588,29964,4968,12360,16560,17340,1656,90228,0,0,0,0,0,0,23760,0,0,0,0,0,0,0,0,6684,94176,0,0,0,0,0,0,0]
[820,"Vesthimmerland",226608,14784,0,5640,0,-1848,245004,5268,-1500,-8664,19116,-22980,19680,480,248184,17556,5856,31968,18576,3276,6936,9288,9732,924,55920,0,0,0,0,0,0,14724,0,0,0,0,0,0,898,0,4140,0,0,0,0,0,0,38304,0]
[825,"Læsø",3756,0,0,264,0,-84,10764,228,-72,204,192,-1080,1656,24,11652,828,276,876,444,120,528,708,732,72,2628,0,0,0,0,0,0,0,0,56880,3648,16296,756,1680,0,3096,192,576,0,0,0,0,0,552,0]
[840,"Rebild",99312,0,0,4992,0,-1632,-138384,0,-1332,-7056,11844,-20340,17400,420,219636,15540,5184,28296,16440,4368,4728,6336,6636,636,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3660,0,0,0,0,0,0,0,-6564]
[846,"Mariagerfjord",198408,0,0,6600,0,-2160,98532,2124,-1752,-9840,19800,-26904,13320,408,290484,20556,6852,37428,21744,4320,7668,10272,10764,1032,21816,0,0,0,0,0,0,17244,0,0,0,0,0,0,0,0,4848,0,0,0,0,0,0,0,0]
[849,"Jammerbugt",206784,6324,0,6036,0,-1980,68364,1476,-1608,-9000,12780,-24588,35256,468,265428,18780,6264,34200,19860,3888,7284,9756,10212,972,39876,0,0,0,0,0,0,15756,0,0,0,0,0,0,0,0,4428,0,0,0,0,0,0,0,0]
[851,"Aalborg",1158444,16128,0,36192,0,-11844,-550644,0,-9624,-50688,127848,-147444,20868,444,1591992,112644,37548,205092,119148,25488,30564,40956,42888,4092,0,0,0,0,0,0,0,0,2628,0,192,228,48,0,0,96,1248,0,0,0,0,0,0,0,-17124]
[860,"Hjørring",341004,10164,0,9984,0,-3264,207984,4476,-2652,15144,27384,-40668,12600,240,439152,31068,10356,56580,32868,6192,12192,16332,17100,1632,98952,0,0,0,0,0,0,26064,0,0,0,0,0,0,0,0,7320,103620,0,0,0,0,0,0,0]

{"sheet":"Bilag 2 ","index":2,"n_rows":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 2: Grunddata til statsgaranti \"&aar","v":"Bilagstabel 2: Grunddata til statsgaranti 2027"},null,null,null," ",null,"lukkes sammen"]
[]
["knr","kommunenavn"," Udskriv-"," Indkomst-"," Udskriv-"," Grund-"," Grund-"," Grund-","Beregnings-","Beregnings-"," Beskat-"," Udgifts-"," Samlet"," Udgifts-"]
[null,null," nings-"," skat"," nings-"," skylds-"," skylds-"," skylds-","tekniske","tekniske"," nings-"," behov"," antal"," behov"]
[null,null," procent",null," grundlag"," promille,"," promille,"," provenu"," grund-"," grund-"," grundlag",null," indbyg-"," pr."]
[null,null,null,null,null," øvrige"," produk-",null," værdier,"," værdier,",null,null," gere"," indbygger"]
[null,null,null,null,null," ejen-"," tions-",null," øvrige"," produk-",null,null," (IM-"]
[null,null,null,null,null," domme"," jord",null," ejen-"," tions-",null,null," skøn)"]
[null,null,null,null,null,null,null,null," domme"," jord"]
[null,null,null,null," ","Anvendes ","Anvendes ","Anvendes "," "]
[null,null,null,null," ","ikke","ikke","ikke"," "]
[null,null,null,null," ","i 2024","i 2024","i 2024"," "]
[]
[null,null,1,{"$f":"+C14+1","v":2},3,4,5,6,7,8,9,10,11,12]
[]
[1,"Kommuner i alt ",{"$f":"100*D16/E16","v":25.047892486318695},{"$f":"SUM(D18:D115)","v":356979967},{"$f":"SUM(E18:E115)","v":1425189633},"---","---",{"$f":"SUM(H18:H115)","v":0},1287985607,114009601,1556591795,476292499.99999923,6059438.9999999981,{"$f":"+L16/M16*1000","v":78603.398763482794}]
[]
[101,"København",23.39,40165630,171721377,0,0,0,145600535,0,186180806,50021933.534892,678385.99999999895,73736.683149257195]
[147,"Frederiksberg",24.5,7964685,32508918,0,0,0,23746322,0,34867139,7255241.3246230902,106567,68081.501070904604]
[151,"Ballerup",25.5,3182463,12480247,0,0,0,16877535,9762,14156636,4712927.4520103298,54908,85833.165513410306]
[153,"Brøndby",24.3,1967126,8095169,0,0,0,8985621,0,8987521,3919339.4311846402,42090,93118.066789846707]
[155,"Dragør",24.8,1085041,4375165,0,0,0,6974788,22557,5068515,1041172.1544430699,14382,72394.114479423704]
[157,"Gentofte",24.14,8451155,35008927,0,0,0,46670519,0,39643725,5321878.8448449997,75050,70911.1105242505]
[159,"Gladsaxe",23.599999999999898,4280973,18139716,0,0,0,23860941,121,20509324,5771373.6469741501,71645,80555.148956300603]
[161,"Glostrup",24.6,1396759,5677882,0,0,0,6891025,1284,6362261,2171754.9581891201,26197,82900.903087724801]
[163,"Herlev",23.6999999999999,1690358,7132312,0,0,0,8474078,4194,7973992,2752576.2463295399,32655,84292.642668183806]
[165,"Albertslund",25.6,1491167,5824871,0,0,0,7232256,319,6543108,2687785.6141224499,29511,91077.415679660306]
[167,"Hvidovre",25.4,3144480,12379843,0,0,0,15420964,2304,13911353,4555879.54512187,54514,83572.651889824207]
[169,"Høje-Taastrup",24.6,3129885,12723110,0,0,0,15162488,148744,14233438,5106045.3500474095,61846,82560.640139174997]
[173,"Lyngby-Taarbæk",24.3799999999999,4805524,19710927,0,0,0,31608612,5741,22850119,4201837.7295498103,58804,71454.964450544299]
[175,"Rødovre",25.6999999999999,2663277,10362946,0,0,0,11881644,0,11542899,3868463.5051579899,45955,84179.382116374705]
[183,"Ishøj",25,1198030,4792120,0,0,0,4614118,31730,5251315,2337732.2502052202,24984,93569.174279747996]
[185,"Tårnby",24.1,2532817,10509614,0,0,0,14004252,3071,11900455,3591518.1974519901,44540,80635.792488818901]
[187,"Vallensbæk",25.6,1092499,4267574,0,0,0,5262953,670,4790253,1452455.97206018,19023,76352.624300067604]
[190,"Furesø",24.88,3274720,13162058,0,0,0,17832299,48440,14934448,3247546.7031549001,43139,75280.991751197304]
[201,"Allerød",25.3,1971933,7794202,0,0,0,10915266,104634,8881391,1852820.4643854001,26579,69709.938838383896]
[210,"Fredensborg",25.3,2892250,11431818,0,0,0,15168366,241764,12945580,3323463.0662108301,42710,77814.635125517103]
[217,"Helsingør",25.82,4242697,16431824,0,0,0,24427634,279112,18866259,5143698.27475564,64583,79644.771453101304]
[219,"Hillerød",25.6,3749853,14647863,0,0,0,18185071,489146,16468792,4061935.7659257702,55633,73013.063576038898]
[223,"Hørsholm",23.6999999999999,2223583,9382207,0,0,0,15848566,34236,10957160,1832608.92849451,25403,72141.437172558799]
[230,"Rudersdal",23.47,5362471,22848193,0,0,0,38332329,57941,26656710,4157985.8854650999,57865,71856.664399293193]
[240,"Egedal",25.6999999999999,3048471,11861755,0,0,0,14639893,323019,13325525,3303225.0793259102,46620,70854.248805789699]
[250,"Frederikssund",25.6,2928935,11441152,0,0,0,12797115,678577.99999999895,12732814,3678060.3339135302,47821,76913.078645647998]
[253,"Greve",24.59,3199351,13010781,0,0,0,17594299,100034,14761117,4248621.7557553696,54771,77570.644241576199]
[259,"Køge",25.26,3818713,15117629,0,0,0,15780375,625153.99999999895,16703918,5104660.1678217696,64470,79178.845475752605]
[260,"Halsnæs",25.6999999999999,1866761,7263661,0,0,0,8821247,199012,8145788,2520678.4393316298,31860,79117.339589818905]
[265,"Roskilde",25.2,6205279,24624123,0,0,0,28441175,519427,27464502,6810514.4035964403,93386,72928.644589086602]
[269,"Solrød",24.99,1638556,6556847,0,0,0,9328787,105755,7486519,1808473.53946011,25288,71515.087767324803]
[270,"Gribskov",25.4,2635606,10376402,0,0,0,21358429,713612,12519352,3200643.6651077601,41965,76269.359349642706]
[306,"Odsherred",26.3,1879663,7147008,0,0,0,12530298,792737.99999999895,8415671,2786332.0842929501,31823,87557.178276496605]
[316,"Holbæk",25.3,4387485,17341838,0,0,0,12972024,1595323,18678963,6074111.4586890703,75432,80524.332626591902]
[320,"Faxe",25.8,2147103,8322105,0,0,0,5647368,1240946,8920967,3077707.84461354,38313,80330.640895088902]
[326,"Kalundborg",24.2,2790928,11532760,0,0,0,8175503,1648865,12395188,4094615.91247604,47837,85595.165091373696]
[329,"Ringsted",26.1,2145585,8220632,0,0,0,6531647,824532,8894550,2916712.7862595101,36211,80547.700595385701]
[330,"Slagelse",26.1,4495811,17225330,0,0,0,12456762,1785228,18517104,6988768.1054742998,81244,86021.959842872195]
[336,"Stevns",26,1431547,5505950,0,0,0,4955957,963453,6027645,1866168.7893628301,23889,78118.330167141306]
[340,"Sorø",26.3,1859219,7069274,0,0,0,4825140,725852,7570696,2498412.65126584,31025,80529.013739430797]
[350,"Lejre",25.31,1858603,7343354,0,0,0,6970888,720745,8057712,2220505.30152283,30108,73751.338565259604]
[360,"Lolland",26.3,2188791,8322399,0,0,0,3128397,3605328,8743559,3765416.9946702202,38246,98452.570064064901]
[370,"Næstved",25,4717228,18868912,0,0,0,14883964,2030558,20409247,6920210.6589010898,85407,81026.270199176899]
[376,"Guldborgsund",25.8,3240145,12558702,0,0,0,7687518,3438662,13427516,5236162.7547720103,58943,88834.344277895798]
[390,"Vordingborg",26.3,2626479,9986612,0,0,0,6414303,1964897,10683822,3797386.7140381699,44729,84897.643900783994]
[400,"Bornholms",26.2,2133677,8143805,0,0,0,5250259,942199,8694075,3178073.52448207,38477,82596.707760014397]
[410,"Middelfart",25.8,2478348,9606000,0,0,0,6118136,1002926,10244319,3114602.0866145301,40835,76272.856290303302]
[420,"Assens",26.1,2247263,8610203,0,0,0,4477616,1712421,9107346,3351625.3261752999,40281,83206.110230016799]
[430,"Faaborg-Midtfyn",26.1,2845935,10903966,0,0,0,6631486,2119528,11627482.999999899,4211122.3755522203,52456,80279.136334303606]
[440,"Kerteminde",26.1,1453755,5569943,0,0,0,4026335,696965,5991152,1955586.5052857001,24319,80413.935823253705]
[450,"Nyborg",26.3,1837866,6988084,0,0,0,4740742,978690,7488873,2690270.0337600401,32448,82910.195813610801]
[461,"Odense",25.5,11336372,44456361,0,0,0,36412267,596900,48090715,17006193.309749,215035,79085.699117580996]
[479,"Svendborg",26.3,3305443,12568223.999999899,0,0,0,10739359.999999899,1411932,13678005,4883538.7948342599,60304,80982.004424818704]
[480,"Nordfyn",26,1620299,6231919,0,0,0,4060683,1617511,6684748,2423195.8714225399,29079,83331.471901459707]
[482,"Langeland",26.3,647680,2462662,0,0,0,1831729,1128219,2679142,1046972.81899551,11760,89028.300934992803]
[492,"Ærø",26.1,302816,1160215,0,0,0,620036,268129,1230007,470791.50960112701,5722,82277.439636687704]
[510,"Haderslev",26.3,3074729,11690985,0,0,0,5904722,3022605,12370002,4676098.0763203297,55143,84799.486359471397]
[530,"Billund",24,1505382,6272425,0,0,0,3546094,1075569,6657544,2205322.3884545499,27295,80795.837642592203]
[540,"Sønderborg",25.6999999999999,4122127,16039405,0,0,0,9208135,1961567,17013965,6233598.4451808296,74049,84182.074642207706]
[550,"Tønder",25.3,1911209,7554186,0,0,0,3398398,3399374,7995848,3111496.9335610699,36033,86351.315004608899]
[561,"Esbjerg",26.1,6825044,26149594,0,0,0,17194354,1958567,27917165,9401960.6909933593,114976,81773.245642510999]
[563,"Fanø",26.1,210981,808356,0,0,0,2281284,19346,1035501,246382.87647045401,3312,74390.965117890897]
[573,"Varde",25.099999999999898,2760444,10997785,0,0,0,9912298,2994363,12073924,4011094.2518925401,49389,81214.324078085207]
[575,"Vejen",25.8,2493006,9662814,0,0,0,3678129,2566373,10106729,3471193.0315244398,42642,81403.147871217196]
[580,"Aabenraa",25.6,3128032,12218875,0,0,0,6682067,2737422,12966350,4909178.9779968197,58235,84299.458710342995]
[607,"Fredericia",25.5,3056131,11984827,0,0,0,9054523,378536,12895622,4535322.45204073,53227,85207.1777864756]
[615,"Horsens",25.69,5506107,21432880,0,0,0,15088487,1661304,22982210,7885531.3139927899,99993,78860.833398265706]
[621,"Kolding",25.5,5540986,21729357,0,0,0,17136402,2391269,23504433,7695888.7555300398,96791,79510.375505264295]
[630,"Vejle",23.4,6753848,28862598,0,0,0,21650531,3044654,31105989,9785207.6981831603,124164,78808.734401139998]
[657,"Herning",25.4,4996414,19670921,0,0,0,14374139,2894934,21187114,7035342.0960289799,90838,77449.328431151895]
[661,"Holstebro",25.5,3279555,12861000,0,0,0,7920671,1913377,13706227,4576576.8270773198,59489,76931.480224534302]
[665,"Lemvig",25.6999999999999,1146203,4459934,0,0,0,1726432,1742849,4684792,1515566.8573715601,18443,82175.722896034393]
[671,"Struer",25.3,1090594,4310648,0,0,0,1918083.99999999,857027,4527394,1671563.4718738401,19953,83775.044949323201]
[706,"Syddjurs",25.9,2500742,9655375,0,0,0,10041321,2047578,10715314,3396804.81264205,44592,76175.206598538905]
[707,"Norddjurs",26,1999309,7689650,0,0,0,4113960,2190316,8165323,3062090.52593996,36434,84044.862654113298]
[710,"Favrskov",25.6999999999999,2867042,11155805,0,0,0,8408635,1971257,12051265,3646163.2085132301,49966,72972.885732562703]
[727,"Odder",25.099999999999898,1345613,5361008,0,0,0,6192624,1088161,6009336,1861141.53673496,24527,75881.336353200997]
[730,"Randers",26,5542420,21317000,0,0,0,12476720,2785519,22641409,8445083.5053224303,101144,83495.644875844693]
[740,"Silkeborg",25.5,5960259,23373565,0,0,0,21300025,1996250,25550020,7773241.45137126,104057,74701.763950250897]
[741,"Samsø",25.9,200064,772448,0,0,0,793648,430776,864465,297448.22323014098,3607,82464.159476058005]
[746,"Skanderborg",26,4038731,15533581,0,0,0,13753158,1365925,16941250,4791373.29481229,66774,71755.073753441306]
[751,"Århus",24.52,20877998,85146811,0,0,0,88557021,1379014,93983570,28204644.9067722,383984.99999999901,73452.465348313795]
[756,"Ikast-Brande",25.099999999999898,2278597,9078076,0,0,0,5428483,1481228,9662564,3486276.9931525001,43573,80010.0289893398]
[760,"Ringkøbing-Skjern",25,3104470,12417880,0,0,0,9833067,2417244,13468465,4352545.0552202603,55165,78900.481378052398]
[766,"Hedensted",25.52,2729533,10695662,0,0,0,6905657,943343,11410363,3688306.1936089601,48934,75373.077892854999]
[773,"Morsø",25.8,1050138,4070302,0,0,0,1430422,720553,4234436,1650985.77671168,19205,85966.455439296406]
[779,"Skive",25.5,2456664,9633976,0,0,0,4249112,1183810,10092227,3647498.7725974098,43891,83103.569583682605]
[787,"Thisted",25.5,2263233,8875424,0,0,0,4194401,2735372,9375788,3491668.96406727,42455,82243.9986825409]
[791,"Viborg",25.5,5476956,21478259,0,0,0,12930360,3526707,22870432,7697321.9329091897,98009,78536.888784797193]
[810,"Brønderslev",26.3,1983884,7543285,0,0,0,2954802,1471670,7881821,2960156.7733986899,36595,80889.6508648366]
[813,"Frederikshavn",26.2,3264663,12460546,0,0,0,8896215,962513,13373515,4847608.5915724803,57227,84708.417208179497]
[820,"Vesthimmerland",26.3,1987849,7558361,0,0,0,3000648,1595534,7905246,3051432.9216719102,35469,86030.982595277994]
[825,"Læsø",26.3,94712,360122,0,0,0,457996,77110,407968,142521.308988284,1666,85547.0041946485]
[840,"Rebild",25.83,1847027.99999999,7150708,0,0,0,3412519,1473836,7534766,2318486.2736534202,31389,73863.018052611704]
[846,"Mariagerfjord",25.9,2366394,9136656,0,0,0,4339185,1335735,9608508,3369164.1218175101,41515,81155.344377153204]
[849,"Jammerbugt",25.6999999999999,2037880,7929494,0,0,0,6705262,1587491,8644034,3055254.5846096799,37934,80541.323999833607]
[851,"Aalborg",25.6,12509981,48867113,0,0,0,33743502,2030680,52280372,17291758.227416102,227520,76001.047061428399]
[860,"Hjørring",26.21,3515926,13414445,0,0,0,8364194,2029935,14307290,5156860.4560493901,62761,82166.639410611693]

{"sheet":"Bilag 3","index":3,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Bilagstabel 3: Parametre til statsgaranti \"&aar","v":"Bilagstabel 3: Parametre til statsgaranti 2027"}]
[]
[null,null," Folketal "," Parametre,"]
[null,null,"bloktilskud","udlignings-"]
[null,null,"mv.","procenter"]
[null,null,null,"mv."]
[]
[null,null,"(1)","(2)"]
[]
[null,"01. Statstilskud ordinært                                                     ",42398800,0]
[null,"02. Betinget statstilskud service                                     ",3000000,0,null,null,null,0]
[null,"03. Betinget statstilskud anlæg                                         ",1000000,0]
[null,"04. Andre tilskud                                                                     ",990700,0]
[null,"05. Tilskud ialt (1+2+3+4)                                                   ",47389500,0]
[null,"06. Samlet udskrivningsgrundlag                                         ",1425189633,0]
[null,"07. Beregningsteknisk grundværdi vedr. produkionsjord                                 ",114009601,0]
[null,"08. Indregning vedr. produktionsjord                               ",3493728,3.0644147846512999E-2]
[null,"09. Beregningsteknisk grundværdi vedr. øvrige ejendomme                             ",1287985607,0]
[null,"10. Indregning vedr. øvrige ejendomme                             ",127908434,9.9308900028110006E-2]
[null,"11. Samlet beskatningsgrundlag (6+8+10)                         ",1556591795,0]
[null,"12. Samlet udskrivning                                                           ",389893439,0]
[null,"13. Beskatningsniveau (12/11)                                             ",0,0.250478924694576]
[null,"14. Samlet folketal                                                                 ",6059439,0]
[null,"15. Beskatningsgrundlag pr. indbygger (kroner)           ",256887.11364203799,0]
[null,"16. Grænse vedr. lavt beskatningsgrundlag (kroner)  ",231198.40227783399,0.9]
[null,"17. Grænse vedr. højt beskatningsgrundlag (kroner)  ",321108.89205254801,1.25]
[null,"18. Udligningsprocent beskatningsgrundlag (generel) ",0,0.75]
[null,"19. Udligningsprocent lavt beskatningsgrundlag           ",0,0.2]
[null,"20. Udligningsprocent højt beskatningsgrundlag           ",0,0.18]
[null,"21. Overudligningsgrænse  (bruges ikke)                                                     ",0,0.93]
[null,"22. Bund vedr. udskrivningsprocent i overudligning  (bruges ikke)",0,0.23250000000000001]
[null,"23. Nettodrifts- og anlægsudgifter (udgiftsbehov)     ",476292500,0]
[null,"24. Samlet folketal                                                                 ",6059439,0]
[null,"25. Udgiftsbehov pr. indbygger (23/24)  (kroner)        ",78603.398763482794,0]
[null,"26. Udligningsprocent udgiftsbehov (generel)               ",0,0.93]
[null,"27. Udligningsprocent udgiftsbehov over gennemsnit  ",0,0.02]
[null,"28. Samlet tilskud vedr. indvandrer og efterkommer  ",3926784,0]
[null,"29. Samlet bidrag vedr. indvandrer og efterkommer     ",-3926784,0]
[null,"30. Tilskudår",2027,0]
[null,"31. Korrektion vedr. overudligning                                     ",-315528,0]
[null,"32. Finansiering af tillæg vedr. beskatningsgrundlag ",963756,0]
[null,"33. Finansiering af tillæg vedr. udgiftsbehov               ",-256224,0]

{"sheet":"Makro mv.","index":4,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Bilagstabel til validering af kommunenummer og data"]
[null,"Gyldigt ","Kommune navn"]
[null,"komnr"]
[null,"(ok=1)"]
["Bilagstabel 1",{"$f":"IF((TYPE(VLOOKUP(knr,Bilagtab1,2,FALSE)))=16,0,1)","v":0},{"$f":"IF(B5=1,VLOOKUP(knr,Bilagtab1,2),0)","v":0}]
["Bilagstabel 2",{"$f":"IF((TYPE(VLOOKUP(knr,Bilagtab2,2,FALSE)))=16,0,1)","v":0},{"$f":"IF(B6=1,VLOOKUP(knr,Bilagtab2,2),0)","v":0}]
["OK bilag 1 og 2",{"$f":"IF(2=B5+B6,1,0)","v":0}]
["OK som Primkommune",{"$f":"IF(AND(1=B7,C8>0),1,0)","v":0},{"$f":"IF(B7=1,VLOOKUP(knr,Bilagtab1,1),\"xx\")","v":"xx"}]
[]
["Tilskudsår:/ AAR",{"$f":"TEXT('Bilag 3'!C39,0)","v":"2027"}]
[]
[null,"kom"]
["Kommunen/amtes  data er udfyldt",{"$f":"IF(4=SUM(B14:B17),1,0)","v":0}]
[{"$f":"\"1.01 Budgetteret indkomstskat \"&aar","v":"1.01 Budgetteret indkomstskat 2027"},{"$f":"IF(0<>+Selvbudgettering!F24,1,0)","v":0}]
[{"$f":"\"1.02 Udskrivningsprocent \"&aar","v":"1.02 Udskrivningsprocent 2027"},{"$f":"IF(0<>+Selvbudgettering!F25,1,0)","v":0}]
[{"$f":"\"1.03 Grundværdier/grundskyld \"&aar","v":"1.03 Grundværdier/grundskyld 2027"},{"$f":"IF(0<>+Selvbudgettering!F26,1,0)","v":1}]
[{"$f":"\"1.05 Skønnet folketal pr. 1. janual \"&aar","v":"1.05 Skønnet folketal pr. 1. janual 2027"},{"$f":"IF(0<>+Selvbudgettering!F28,1,0)","v":0}]
[]
["Kommunens data er udfyldt og komnr ok",{"$f":"IF(+B13+B8=2,1,0)","v":0}]