{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["gl. til nyt niveau","reguleringsprocenter","Lønark","Forside","Omregner","Omregningstabel ","Tillæg_trin","Tillæg_kr","Tid op_ned","Samlet_omk"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":75,"comments":1,"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":"gl. til nyt niveau","index":0,"n_rows":395,"n_cols":6,"rows_kept":395,"cut":false,"hidden":true,"merged":[]}
[null,1.3980790000000001]
[null,null,null,"Nyt grundbeløb","Nyt grundbeløb"]
["Grundbeløb pr. 1/10-1984","I alt pr. 1. april 1999 inkl. %regulering",null,"pr. 31/3-2000","pr. 31/3-2000"]
[null,null,null,"ekskl. afrunding","inkl. afrunding"]
[null,null,null,null,null,"beløb"]
[null,"pr. gang/år","pr. måned",null,null,"+/-"]
[1.63,{"$f":"IF(A7<1000,$B$1*A7,ROUND($B$1*A7,0))","v":2.2788687699999999},null,{"$f":"B7","v":2.2788687699999999},{"$f":"IF(D7<1000,D7,ROUND(D7,-2))","v":2.2788687699999999}]
[5,6.9903950000000004,null,{"$f":"B8","v":6.9903950000000004},6.9903950000000004]
[5.8,8.1088582000000002,null,8.1088582000000002,8.1088582000000002]
[9,12.582711,null,12.582711,12.582711]
[10.5,14.6798295,null,14.6798295,14.6798295]
[12.22,17.084525380000002,null,17.084525380000002,17.084525380000002]
[12.65,17.68569935,null,17.68569935,17.68569935]
[13.39,18.720277810000002,null,18.720277810000002,18.720277810000002]
[13.75,19.22358625,null,19.22358625,19.22358625]
[14.46,20.216222340000002,null,20.216222340000002,20.216222340000002]
[15.2,21.2508008,null,21.2508008,21.2508008]
[15.5,21.6702245,null,21.6702245,21.6702245]
[17,23.767343,null,23.767343,23.767343]
[18.5,25.864461500000001,null,25.864461500000001,25.864461500000001]
[19,26.563501000000002,null,26.563501000000002,26.563501000000002]
[21,29.359659000000001,null,29.359659000000001,29.359659000000001]
[23,32.155816999999999,null,32.155816999999999,32.155816999999999]
[24.97,34.910032630000003,null,34.910032630000003,34.910032630000003]
[28,39.146212000000006,null,39.146212000000006,39.146212000000006]
[30,41.942370000000004,null,41.942370000000004,41.942370000000004]
[33.29,46.542049910000003,null,46.542049910000003,46.542049910000003]
[42,58.719318000000001,null,58.719318000000001,58.719318000000001]
[61.26,85.646319540000007,null,85.646319540000007,85.646319540000007]
[62,86.680897999999999,null,86.680897999999999,86.680897999999999]
[68.319999999999993,95.516757279999993,null,95.516757279999993,95.516757279999993]
[75.13,105.03767526999999,null,105.03767526999999,105.03767526999999]
[80.38,112.37759002,null,112.37759002,112.37759002]
[136.63999999999999,191.03351455999999,null,{"$f":"B34","v":191.03351455999999},191.03351455999999]
[143.99,201.30939521000002,null,{"$f":"B35","v":201.30939521000002},201.30939521000002]
[150.61000000000001,210.56467819000002,null,210.56467819000002,210.56467819000002]
[164,229.28495600000002,null,229.28495600000002,229.28495600000002]
[170,237.67343000000002,null,237.67343000000002,237.67343000000002]
[190,265.63501000000002,null,265.63501000000002,{"$f":"IF(D39<1000,D39,ROUND(D39,-2))","v":265.63501000000002}]
[195,272.625405,null,272.625405,272.625405]
[202,282.41195800000003,null,282.41195800000003,282.41195800000003]
[260,363.50054,null,363.50054,363.50054]
[278,388.66596200000004,null,388.66596200000004,388.66596200000004]
[300.83999999999997,420.59808635999997,null,420.59808635999997,420.59808635999997]
[350,489.32765000000001,null,489.32765000000001,489.32765000000001]
[380,531.27002000000005,null,531.27002000000005,531.27002000000005]
[398.95,557.76361704999999,null,557.76361704999999,557.76361704999999]
[420,587.19317999999998,null,587.19317999999998,587.19317999999998]
[465,650.10673500000007,null,650.10673500000007,650.10673500000007]
[490,685.05871000000002,null,685.05871000000002,685.05871000000002]
[502,701.83565800000008,null,701.83565800000008,701.83565800000008]
[559,781.526161,null,781.526161,781.526161]
[597,834.65316300000006,null,834.65316300000006,834.65316300000006]
[700,978.65530000000001,{"$f":"VALUE(B54)/12","v":81.554608333333334},978.65530000000001,{"$f":"IF(D54<1000,D54,ROUND(D54,-2))","v":978.65530000000001},{"$f":"E54-D54","v":0}]
[750,1048.55925,87.379937499999997,1048.55925,{"$f":"IF(D55<1000,D55,ROUND(D55,-2))","v":1000},-48.55925000000002]
[800,1118.4632000000001,93.205266666666674,1118.4632000000001,{"$f":"IF(D56<1000,D56,ROUND(D56,-2))","v":1100},-18.463200000000143]
[842.75,1178.23107725,98.185923104166662,1178.23107725,1200,21.768922750000002]
[868,1213.5325720000001,101.12771433333334,1213.5325720000001,1200,-13.532572000000073]
[917.14,1282.23417406,106.85284783833333,{"$f":"B59","v":1282.23417406},1300,17.765825940000013]
[920,1286.2326800000001,107.18605666666667,1286.2326800000001,1300,13.767319999999927]
[925,1293.2230750000001,107.76858958333334,1293.2230750000001,1300,6.776924999999892]
[950,{"$f":"IF(A62<1000,$B$1*A62,ROUND($B$1*A62,0))","v":1328.1750500000001},110.68125416666668,1328.1750500000001,1300,-28.175050000000056]
[1000,{"$f":"IF(A63<1000,$B$1*A63,ROUND($B$1*A63,0))","v":1398},116.5,1398,1400,2]
[1050,{"$f":"IF(A64<1000,$B$1*A64,ROUND($B$1*A64,0))","v":1468},122.33333333333333,1468,1500,32]
[1100,{"$f":"IF(A65<1000,$B$1*A65,ROUND($B$1*A65,0))","v":1538},128.16666666666666,1538,1500,-38]
[1200,1678,139.83333333333334,1678,1700,22]
[1245,1741,145.08333333333334,{"$f":"B67","v":1741},1700,{"$f":"E67-D67","v":-41}]
[1300,1818,151.5,1818,1800,-18]
[1327,1855,154.58333333333334,1855,1900,45]
[1400,1957,163.08333333333334,1957,2000,43]
[1500,2097,174.75,2097,2100,3]
[1600,2237,186.41666666666666,2237,2200,-37]
[1700,2377,198.08333333333334,2377,2400,23]
[1750,2447,203.91666666666666,2447,2400,-47]
[1800,2517,209.75,2517,2500,-17]
[1900,2656,221.33333333333334,2656,2700,44]
[2000,2796,233,2796,2800,4]
[2050,2866,238.83333333333334,2866,2900,34]
[2100,2936,244.66666666666666,2936,2900,-36]
[2145,2999,249.91666666666666,2999,3000,1]
[2150,3006,250.5,3006,3000,-6]
[2200,3076,256.33333333333331,3076,3100,24]
[2300,3216,268,3216,3200,-16]
[2400,3355,279.58333333333331,3355,3400,45]
[2450,3425,285.41666666666669,3425,3400,-25]
[2500,3495,291.25,3495,3500,5]
[2600,3635,302.91666666666669,3635,3600,-35]
[2700,3775,314.58333333333331,3775,3800,25]
[2730,3817,318.08333333333331,3817,3800,-17]
[2800,3915,326.25,3915,3900,-15]
[2900,4054,337.83333333333331,4054,4100,46]
[3000,4194,349.5,4194,4200,6]
[3100,4334,361.16666666666669,4334,4300,-34]
[3200,4474,372.83333333333331,4474,4500,26]
[3300,4614,384.5,4614,4600,-14]
[3400,4753,396.08333333333331,4753,4800,47]
[3500,4893,407.75,4893,4900,7]
[3600,5033,419.41666666666669,5033,5000,-33]
[3700,5173,431.08333333333331,5173,5200,27]
[3800,5313,442.75,5313,5300,-13]
[3900,5453,454.41666666666669,5453,5500,47]
[4000,5592,466,5592,5600,8]
[4100,5732,477.66666666666669,5732,5700,-32]
[4200,5872,489.33333333333331,5872,5900,28]
[4226.1000000000004,5908,492.33333333333331,5908,5900,-8]
[4300,6012,501,6012,6000,-12]
[4400,6152,512.66666666666663,6152,6200,48]
[4430,6193,516.08333333333337,6193,6200,7]
[4500,6291,524.25,6291,6300,9]
[4600,6431,535.91666666666663,6431,6400,-31]
[4700,6571,547.58333333333337,6571,6600,29]
[1770,2475,206.25,2475,2500,25]
[4800,6711,559.25,6711,6700,-11]
[4900,6851,570.91666666666663,6851,6900,49]
[4930,6893,574.41666666666663,6893,6900,7]
[5000,6990,582.5,6990,7000,10]
[5100,7130,594.16666666666663,7130,7100,-30]
[5200,7270,{"$f":"VALUE(B118)/12","v":605.83333333333337},7270,7300,30]
[5300,7410,617.5,7410,7400,-10]
[5318,7435,619.58333333333337,7435,{"$f":"IF(D120<1000,D120,ROUND(D120,-2))","v":7400},-35]
[5400,7550,629.16666666666663,7550,7600,50]
[5420.91,7579,631.58333333333337,7579,7600,21]
[5500,7689,640.75,{"$f":"B123","v":7689},7700,{"$f":"E123-D123","v":11}]
[5600,7829,652.41666666666663,7829,7800,-29]
[5700,7969,664.08333333333337,7969,8000,31]
[5770.78,8068,672.33333333333337,8068,8100,32]
[5800,8109,675.75,8109,8100,-9]
[5900,8249,687.41666666666663,8249,8200,-49]
[6000,{"$f":"IF(A129<1000,$B$1*A129,ROUND($B$1*A129,0))","v":8388},699,8388,8400,12]
[6078,8498,708.16666666666663,8498,8500,2]
[6100,8528,710.66666666666663,8528,8500,-28]
[6140,8584,715.33333333333337,8584,8600,16]
[6200,8668,722.33333333333337,8668,8700,32]
[6290.15,8794,732.83333333333337,8794,8800,6]
[6300,8808,734,8808,8800,-8]
[6400,8948,745.66666666666663,8948,8900,-48]
[6500,9088,757.33333333333337,9088,9100,12]
[6600,9227,768.91666666666663,9227,9200,-27]
[6700,9367,780.58333333333337,9367,9400,33]
[6743.33,9428,785.66666666666663,9428,9400,-28]
[6800,9507,792.25,9507,9500,-7]
[6900,9647,803.91666666666663,9647,9600,-47]
[7000,9787,815.58333333333337,9787,9800,13]
[7100,9926,827.16666666666663,9926,9900,-26]
[7200,10066,838.83333333333337,10066,10100,34]
[7300,10206,850.5,10206,10200,-6]
[7335.23,10255,854.58333333333337,10255,10300,45]
[7400,10346,862.16666666666663,10346,10300,-46]
[7500,10486,873.83333333333337,10486,10500,14]
[7600,10625,885.41666666666663,10625,10600,-25]
[7700,10765,897.08333333333337,10765,10800,35]
[7800,10905,908.75,10905,10900,-5]
[7900,11045,920.41666666666663,11045,11000,-45]
[8000,11185,932.08333333333337,11185,11200,15]
[8100,11324,943.66666666666663,11324,11300,-24]
[8200,11464,955.33333333333337,11464,11500,36]
[8300,11604,967,11604,11600,-4]
[8400,11744,978.66666666666663,11744,11700,-44]
[8500,11884,990.33333333333337,11884,11900,16]
[8600,12023,1001.9166666666666,12023,12000,-23]
[8700,12163,1013.5833333333334,12163,12200,37]
[8800,12303,1025.25,12303,12300,-3]
[8900,12443,1036.9166666666667,12443,12400,-43]
[9000,12583,1048.5833333333333,12583,12600,17]
[9100,12723,1060.25,12723,12700,-23]
[9200,12862,1071.8333333333333,12862,12900,38]
[9300,13002,1083.5,13002,13000,-2]
[9400,13142,1095.1666666666667,13142,13100,-42]
[9450,13212,1101,13212,13200,-12]
[9500,13282,1106.8333333333333,13282,13300,18]
[9600,13422,1118.5,13422,13400,-22]
[9700,13561,1130.0833333333333,13561,13600,39]
[9800,13701,1141.75,13701,13700,-1]
[9900,13841,1153.4166666666667,13841,13800,-41]
[10000,13981,1165.0833333333333,13981,14000,19]
[10600,14820,1235,14820,14800,-20]
[10800,15099,1258.25,15099,15100,1]
[11000,15379,1281.5833333333333,15379,15400,21]
[11200,15658,1304.8333333333333,15658,15700,42]
[11300,15798,1316.5,15798,15800,2]
[11500,16078,1339.8333333333333,16078,16100,22]
[11600,16218,{"$f":"VALUE(B182)/12","v":1351.5},16218,16200,-18]
[11700,16358,1363.1666666666667,16358,16400,42]
[11800,16497,1374.75,16497,{"$f":"IF(D184<1000,D184,ROUND(D184,-2))","v":16500},3]
[11900,16637,1386.4166666666667,16637,16600,-37]
[12000,16777,1398.0833333333333,16777,16800,23]
[12100,16917,1409.75,{"$f":"B187","v":16917},16900,{"$f":"E187-D187","v":-17}]
[12200,17057,1421.4166666666667,17057,17100,43]
[12300,17196,1433,17196,17200,4]
[12400,17336,1444.6666666666667,17336,17300,-36]
[12500,17476,1456.3333333333333,17476,17500,24]
[12600,17616,1468,17616,17600,-16]
[12700,{"$f":"IF(A193<1000,$B$1*A193,ROUND($B$1*A193,0))","v":17756},1479.6666666666667,17756,17800,44]
[12800,17895,1491.25,17895,17900,5]
[12900,18035,1502.9166666666667,18035,18000,-35]
[13000,18175,1514.5833333333333,18175,18200,25]
[13200,18455,1537.9166666666667,18455,18500,45]
[13400,18734,1561.1666666666667,18734,18700,-34]
[13500,18874,1572.8333333333333,18874,18900,26]
[13700,19154,1596.1666666666667,19154,19200,46]
[14000,19573,1631.0833333333333,19573,19600,27]
[14300,19993,1666.0833333333333,19993,20000,7]
[14500,20272,1689.3333333333333,20272,20300,28]
[14700,20552,1712.6666666666667,20552,20600,48]
[14800,20692,1724.3333333333333,20692,20700,8]
[14900,20831,1735.9166666666667,20831,20800,-31]
[15000,20971,1747.5833333333333,20971,21000,29]
[15100,21111,1759.25,21111,21100,-11]
[15200,21251,1770.9166666666667,21251,21300,49]
[15500,21670,1805.8333333333333,21670,21700,30]
[15700,21950,1829.1666666666667,21950,22000,50]
[15900,22229,1852.4166666666667,22229,22200,-29]
[16000,22369,1864.0833333333333,22369,22400,31]
[16100,22509,1875.75,22509,22500,-9]
[16200,22649,1887.4166666666667,22649,22600,-49]
[16700,23348,1945.6666666666667,23348,23300,-48]
[16800,23488,1957.3333333333333,23488,23500,12]
[16900,23628,1969,23628,23600,-28]
[17000,23767,1980.5833333333333,23767,23800,33]
[17100,23907,1992.25,23907,23900,-7]
[17600,24606,2050.5,24606,24600,-6]
[17700,24746,2062.1666666666665,24746,24700,-46]
[18000,25165,2097.0833333333335,25165,25200,35]
[18200,25445,2120.4166666666665,25445,25400,-45]
[18300,25585,2132.0833333333335,25585,25600,15]
[18600,26004,2167,26004,26000,-4]
[18700,26144,2178.6666666666665,26144,26100,-44]
[18800,26284,2190.3333333333335,{"$f":"B228","v":26284},26300,{"$f":"E228-D228","v":16}]
[18900,26424,2202,26424,26400,-24]
[19000,26564,2213.6666666666665,26564,26600,36]
[19100,26703,2225.25,26703,26700,-3]
[19400,27123,2260.25,27123,27100,-23]
[19500,27263,2271.9166666666665,27263,27300,37]
[19600,27402,2283.5,27402,27400,-2]
[19700,27542,2295.1666666666665,27542,27500,-42]
[20000,27962,2330.1666666666665,27962,28000,38]
[20300,28381,2365.0833333333335,28381,28400,19]
[20400,28521,2376.75,28521,28500,-21]
[20500,28661,2388.4166666666665,28661,28700,39]
[20800,29080,2423.3333333333335,29080,29100,20]
[20900,29220,2435,29220,29200,-20]
[21100,29499,2458.25,29499,29500,1]
[21300,29779,2481.5833333333335,29779,29800,21]
[21900,30618,2551.5,30618,30600,-18]
[22000,30758,2563.1666666666665,30758,30800,42]
[22200,31037,{"$f":"VALUE(B246)/12","v":2586.4166666666665},31037,31000,-37]
[22400,31317,2609.75,31317,31300,-17]
[22500,31457,2621.4166666666665,31457,{"$f":"IF(D248<1000,D248,ROUND(D248,-2))","v":31500},43]
[22600,31597,2633.0833333333335,31597,31600,3]
[22900,32016,2668,32016,32000,-16]
[23000,32156,2679.6666666666665,32156,32200,44]
[23200,32435,2702.9166666666665,32435,32400,-35]
[23300,32575,2714.5833333333335,32575,32600,25]
[23400,32715,2726.25,32715,32700,-15]
[23500,32855,2737.9166666666665,32855,32900,45]
[23600,32995,2749.5833333333335,32995,33000,5]
[23700,{"$f":"IF(A257<1000,$B$1*A257,ROUND($B$1*A257,0))","v":33134},2761.1666666666665,33134,33100,-34]
[23800,33274,2772.8333333333335,33274,33300,26]
[23900,33414,2784.5,33414,33400,-14]
[24000,33554,2796.1666666666665,33554,33600,46]
[24500,34253,2854.4166666666665,34253,34300,47]
[24900,34812,2901,34812,34800,-12]
[25000,34952,2912.6666666666665,34952,35000,48]
[25200,35232,2936,35232,35200,-32]
[25400,35511,2959.25,35511,35500,-11]
[25700,35931,2994.25,35931,35900,-31]
[26000,36350,3029.1666666666665,36350,36400,50]
[26300,36769,3064.0833333333335,36769,36800,31]
[26600,37189,3099.0833333333335,37189,37200,11]
[26700,37329,3110.75,37329,37300,-29]
[26900,37608,3134,37608,37600,-8]
[27000,37748,3145.6666666666665,37748,37700,-48]
[27100,37888,3157.3333333333335,37888,37900,12]
[27600,38587,3215.5833333333335,38587,38600,13]
[27700,38727,3227.25,38727,38700,-27]
[28000,39146,3262.1666666666665,39146,39100,-46]
[28100,39286,3273.8333333333335,39286,39300,14]
[29000,40544,3378.6666666666665,40544,40500,-44]
[29100,40684,3390.3333333333335,40684,40700,16]
[29200,40824,3402,40824,40800,-24]
[29300,40964,3413.6666666666665,40964,41000,36]
[29400,41104,3425.3333333333335,41104,41100,-4]
[29900,41803,3483.5833333333335,41803,41800,-3]
[30000,41942,3495.1666666666665,41942,41900,-42]
[30200,42222,3518.5,42222,42200,-22]
[30500,42641,3553.4166666666665,42641,42600,-41]
[30700,42921,3576.75,42921,42900,-21]
[30800,43061,3588.4166666666665,43061,43100,39]
[31800,44459,3704.9166666666665,44459,44500,41]
[32000,44739,3728.25,44739,44700,-39]
[32100,44878,3739.8333333333335,44878,44900,22]
[32500,45438,3786.5,{"$f":"B292","v":45438},45400,{"$f":"E292-D292","v":-38}]
[33000,46137,3844.75,46137,46100,-37]
[33300,46556,3879.6666666666665,46556,46600,44]
[34200,47814,3984.5,47814,47800,-14]
[34300,47954,3996.1666666666665,47954,48000,46]
[34700,48513,4042.75,48513,48500,-13]
[35000,48933,4077.75,{"$f":"B298","v":48933},48900,{"$f":"E298-D298","v":-33}]
[35100,49073,4089.4166666666665,49073,49100,27]
[35200,49212,4101,49212,49200,-12]
[35400,49492,4124.333333333333,49492,49500,8]
[36500,51030,4252.5,51030,51000,-30]
[36700,51309,4275.75,51309,51300,-9]
[37000,51729,4310.75,51729,51700,-29]
[38200,53407,4450.583333333333,53407,53400,-7]
[38900,54385,4532.083333333333,54385,54400,15]
[39200,54805,4567.083333333333,54805,54800,-5]
[40300,56343,4695.25,56343,56300,-43]
[40900,57181,4765.083333333333,57181,57200,19]
[41600,58160,{"$f":"VALUE(B310)/12","v":4846.666666666667},58160,58200,40]
[42000,58719,4893.25,58719,58700,-19]
[42700,59698,4974.833333333333,59698,{"$f":"IF(D312<1000,D312,ROUND(D312,-2))","v":59700},2]
[43300,60537,5044.75,60537,60500,-37]
[43500,60816,5068,60816,60800,-16]
[44000,61515,5126.25,61515,61500,-15]
[44100,61655,5137.916666666667,61655,61700,45]
[44900,62774,5231.166666666667,62774,62800,26]
[45700,63892,5324.333333333333,63892,63900,8]
[46000,64312,5359.333333333333,64312,64300,-12]
[46500,65011,5417.583333333333,65011,65000,-11]
[47000,{"$f":"IF(A321<1000,$B$1*A321,ROUND($B$1*A321,0))","v":65710},5475.833333333333,65710,65700,-10]
[47200,65989,5499.083333333333,65989,66000,11]
[47700,66688,5557.333333333333,66688,66700,12]
[48000,67108,5592.333333333333,67108,67100,-8]
[48600,67947,5662.25,67947,67900,-47]
[48800,68226,5685.5,68226,68200,-26]
[49900,69764,5813.666666666667,69764,69800,36]
[50000,69904,5825.333333333333,69904,69900,-4]
[51300,71721,5976.75,71721,71700,-21]
[52000,72700,6058.333333333333,72700,72700,0]
[53000,74098,6174.833333333333,74098,74100,2]
[53900,75356,6279.666666666667,75356,75400,44]
[55000,76894,6407.833333333333,76894,76900,6]
[56700,79271,6605.916666666667,79271,79300,29]
[56800,79411,6617.583333333333,79411,79400,-11]
[57000,79691,6640.916666666667,79691,79700,9]
[58700,82067,6838.916666666667,82067,82100,33]
[58800,82207,6850.583333333333,82207,82200,-7]
[59000,82487,6873.916666666667,82487,82500,13]
[59900,83745,6978.75,83745,83700,-45]
[60000,83885,6990.416666666667,83885,83900,15]
[62300,87100,7258.333333333333,87100,87100,0]
[63000,88079,7339.916666666667,88079,88100,21]
[63300,88498,7374.833333333333,88498,88500,2]
[63700,89058,7421.5,89058,89100,42]
[65000,90875,7572.916666666667,90875,90900,25]
[66100,92413,7701.083333333333,92413,92400,-13]
[67000,93671,7805.916666666667,93671,93700,29]
[69600,97306,8108.833333333333,97306,97300,-6]
[70400,98425,8202.0833333333339,98425,98400,-25]
[70800,98984,8248.6666666666661,98984,99000,16]
[71000,99264,8272,99264,99300,36]
[71700,100242,8353.5,100242,100200,-42]
[73400,102619,8551.5833333333339,102619,102600,-19]
[73500,102759,8563.25,102759,102800,41]
[78900,110308,9192.3333333333339,110308,110300,-8]
[80600,112685,9390.4166666666661,112685,112700,15]
[82200,114922,9576.8333333333339,114922,114900,-22]
[82600,115481,9623.4166666666661,115481,115500,19]
[82900,115901,9658.4166666666661,115901,115900,-1]
[83300,116460,9705,116460,116500,40]
[87000,121633,10136.083333333334,{"$f":"B362","v":121633},121600,{"$f":"E362-D362","v":-33}]
[88100,123171,10264.25,123171,123200,29]
[90600,126666,10555.5,126666,126700,34]
[93200,130301,10858.416666666666,130301,130300,-1]
[93900,131280,10940,131280,131300,20]
[94400,131979,10998.25,131979,132000,21]
[95300,133237,11103.083333333334,133237,133200,-37]
[96200,134495,11207.916666666666,134495,134500,5]
[102700,143583,11965.25,143583,143600,17]
[102800,143723,11976.916666666666,143723,143700,-23]
[104100,145540,12128.333333333334,145540,145500,-40]
[105600,147637,12303.083333333334,147637,147600,-37]
[106100,148336,{"$f":"VALUE(B374)/12","v":12361.333333333334},148336,148300,-36]
[109400,152950,12745.833333333334,152950,153000,50]
[110000,153789,12815.75,153789,{"$f":"IF(D376<1000,D376,ROUND(D376,-2))","v":153800},11]
[116200,162457,13538.083333333334,162457,162500,43]
[117300,163995,13666.25,163995,164000,5]
[117400,164134,13677.833333333334,164134,164100,-34]
[118000,164973,13747.75,164973,165000,27]
[118300,165393,13782.75,165393,165400,7]
[123400,172523,14376.916666666666,172523,172500,-23]
[124700,174340,14528.333333333334,174340,174300,-40]
[127100,177696,14808,177696,177700,4]
[129100,{"$f":"IF(A385<1000,$B$1*A385,ROUND($B$1*A385,0))","v":180492},15041,180492,180500,8]
[129800,181471,15122.583333333334,181471,181500,29]
[130900,183009,15250.75,183009,183000,-9]
[131900,184407,15367.25,184407,184400,-7]
[133400,186504,15542,186504,186500,-4]
[139400,194892,16241,194892,194900,8]
[140900,196989,16415.75,196989,197000,11]
[141600,197968,16497.333333333332,197968,198000,32]
[145000,202721,16893.416666666668,202721,202700,-21]
[146600,204958,17079.833333333332,204958,205000,42]
[147700,206496,17208,206496,206500,4]

{"sheet":"reguleringsprocenter","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Reguleringsprocenter",null,"pensionsudbygning"]
[null,"Valgt:",{"$f":"VLOOKUP(Forside!K11,reguleringsprocenter!B4:D15,2,TRUE)","v":1.57765}]
[null,"2020-01-01",1.4124110000000001,1]
[null,"2020-04-01",1.4177979999999999,1]
[null,"2020-10-01",1.4285110000000001,1]
[null,"2021-04-01",1.442796,1]
[null,"2021-10-01",1.456933,1]
[null,"2022-04-01",1.456933,1]
[null,"2022-10-01",1.4940180000000001,1]
[null,"2023-04-01",1.4983040000000001,1]
[null,"2023-10-01",1.5169710000000001,1]
[null,"2024-04-01",1.57765,1]
[]
[]
[]
[]
[null,"Liste, opslag niveauer"]
[]
[null,"2024-04-01"]
[null,"2023-10-01"]
[null,"2023-04-01"]
[null,"2022-10-01"]
[null,"2022-04-01"]
[null,"2021-10-01"]
[null,"2021-04-01"]
[null,"2020-10-01"]
[null,"2020-04-01"]
[null,"2020-01-01"]

{"sheet":"Lønark","index":2,"n_rows":71,"n_cols":88,"rows_kept":71,"cut":false,"hidden":true,"merged":[]}
[1,2,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,53,54,55,56]
["Næstved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,"Årsløn ialt ",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,null,null,null,null,null,null,null,null,null,null,null,"Lavtlønsprojekt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Løn","Årsløn",null,null,"Ureguleret ikke-pensionsgivende tillæg",null,null,null,null,null,null,null,null,null,"Områdetillæg inkl. regulering",null,null,null,null,"Årsløn ialt ",null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Løn","timelønninger",null,null,null,null,null,"Løn","timelønninger + 50%",null,null,null,null,null,"Løn","søndagstillæg - 50%",null,null,null,null,null,null,"2019-03-31",0,0]
[null,"Månedsløn, løngrupper",null,null,"Lønniveau:",{"$f":"VLOOKUP(beregningsdato,regpct_tabel,1,TRUE)","v":"2024-04-01"},null,"Optrapning fra:",null,null,null,null,"Pensionsgivende løn",null,null,null,null,null,"Pensionsgivende løn, optrapning fra:",null,null,null,null,"trin","Grundsats","%-reg.","Sats","Omr 1","Omr 2","Omr 3","Omr 4",null,null,null,null,null,null,1,2,3,4,null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"Grundsats","%-reg.","Sats",null,"Pensionsudbygningspct:",null,null,{"$f":"VLOOKUP(F4,regpct_tabel,3,FALSE)","v":1},null,"Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,"trin","Omr 0","Omr 1","Omr 2","Omr 3","Omr 4",null,null,"2019-04-01",382,0]
[null,0,1,2,3,4,null,"0->1","1->2","2->3",null,null,0,1,2,3,4,null,"0->1","1->2","2->3","3->4",null,null,{"$f":"VLOOKUP(beregningsdato,Lavtløn,2,TRUE)","v":1035},{"$f":"valgt_regulering-1","v":0.57765},"2019-04-01","2022-04-01",{"$f":"VLOOKUP(beregningsdato,Lavtløn,3,TRUE)","v":653},null,null,null,null,null,null,null,null,{"$f":"IF(beregningsdato<40087,0,regulering)","v":0.57765},{"$f":"IF(beregningsdato<40087,0,5)","v":5},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,null,null,null,null,"2022-04-01",{"$f":"CI4+CJ5","v":1035},653]
[1,{"$f":"AQ6/12","v":19351.75},19625.5,19814.916666666668,20088.75,20278.25,null,{"$f":"ROUND(AQ6+(AR6-AQ6)/3*faktor,0)/12","v":22401516.75},{"$f":"ROUND(AR6+(AS6-AR6)/3*faktor,0)/12","v":15506584.75},{"$f":"ROUND(AS6+(AT6-AS6)/3*faktor,0)/12","v":22408793.333333332},null,1,{"$f":"BF6/12","v":19351.75},19625.5,19814.916666666668,20088.75,20278.25,null,{"$f":"(BF6+ROUND((BG6-BF6)/3*faktor,0))/12","v":22401516.75},{"$f":"(BG6+ROUND((BH6-BG6)/3*faktor,0))/12","v":15506584.75},{"$f":"(BH6+ROUND((BI6-BH6)/3*faktor,0))/12","v":22408793.333333332},{"$f":"(BI6+ROUND((BJ6-BI6)/3*faktor,0))/12","v":15513861.416666666},null,1,147194,{"$f":"ROUND(Y6*regulering,0)","v":85027},{"$f":"Y6+Z6","v":232221},2585,4374,6959,8748,null,2082,3523,5606,7047,null,{"$f":"ROUND(VLOOKUP($X6,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":3285},5558,8844,11118,null,{"$f":"$AA6","v":232221},{"$f":"$AA6+AL6","v":235506},237779,241065,243339,null,147194,{"$f":"AW6*regulering","v":85026.614100000006},{"$f":"ROUND(SUM(AW6:AX6),0)","v":232221},null,{"$f":"ROUND(AL6*udbygningspct,0)","v":3285},{"$f":"ROUND(AM6*udbygningspct,0)","v":5558},{"$f":"ROUND(AN6*udbygningspct,0)","v":8844},{"$f":"ROUND(AO6*udbygningspct,0)","v":11118},null,{"$f":"AY6","v":232221},{"$f":"$BF6+BA6","v":235506},{"$f":"$BF6+BB6","v":237779},241065,243339,null,1,{"$f":"AQ6/1924","v":120.69698544698545},122.4043659043659,123.58575883575884,125.29365904365905,126.47557172557173,null,1,{"$f":"AQ6/1924*1.5","v":181.04547817047819},{"$f":"AR6/1924*1.5","v":183.60654885654884},{"$f":"AS6/1924*1.5","v":185.37863825363826},{"$f":"AT6/1924*1.5","v":187.94048856548858},{"$f":"AU6/1924*1.5","v":189.71335758835758},null,1,{"$f":"AQ6/1924/2","v":60.348492723492726},61.202182952182952,61.792879417879419,62.646829521829524,63.237785862785863]
[2,19649,19929.416666666668,20123.5,20403.916666666668,20597.916666666668,null,22946889.583333332,15888441.5,22947364.083333332,null,2,19649,19929.416666666668,20123.5,20403.916666666668,20597.916666666668,null,22946889.583333332,15888441.5,22947364.083333332,15882102.583333334,null,2,149455,86333,235788,2648,4481,7128,8961,null,2133,3609,5742,7218,null,3365,5694,9059,11387,null,{"$f":"$AA7","v":235788},239153,241482,244847,247175,null,149455,{"$f":"AW7*regulering","v":86332.68075},{"$f":"ROUND(SUM(AW7:AX7),0)","v":235788},null,3365,5694,9059,11387,null,{"$f":"AY7","v":235788},239153,241482,244847,247175,null,2,122.55093555093555,124.29989604989605,125.51039501039502,127.25935550935552,128.46933471933471,null,2,{"$f":"AQ7/1924*1.5","v":183.82640332640332},186.44984407484407,188.26559251559252,190.88903326403329,192.70400207900207,null,2,61.275467775467774,62.149948024948024,62.755197505197508,63.629677754677758,64.234667359667355]
[3,19954.25,20241.416666666668,20440.333333333332,20727.416666666668,20926.5,null,23499083.833333332,16283933.333333334,23492756.416666668,null,3,19954.25,20241.416666666668,20440.333333333332,20727.416666666668,20926.5,null,23499083.833333332,16283933.333333334,23492756.416666668,16298046.166666666,null,3,151777,87674,239451,2711,4590,7301,9180,null,2184,3697,5881,7395,null,3446,5833,9278,11667,null,239451,242897,245284,248729,251118,null,151777,87673.984049999999,239451,null,3446,5833,9278,11667,null,239451,242897,245284,248729,251118,null,3,124.45478170478171,126.245841995842,127.48648648648648,129.27702702702703,130.51871101871103,null,3,186.68217255717258,189.368762993763,191.22972972972974,193.91554054054055,195.77806652806655,null,3,62.227390852390855,63.122920997921,63.743243243243242,64.638513513513516,65.259355509355515]
[4,20267.916666666668,20562.25,20765.916666666668,21060.25,21263.916666666668,null,24085353.666666668,16672620.5,24085851.666666668,null,4,20267.916666666668,20562.25,20765.916666666668,21060.25,21263.916666666668,null,24085353.666666668,16672620.5,24085851.666666668,16673118.5,null,4,154163,89052,243215,2779,4703,7482,9405,null,2239,3788,6027,7576,null,3532,5976,9508,11952,null,243215,246747,249191,252723,255167,null,154163,89052.256949999995,243215,null,3532,5976,9508,11952,null,243215,246747,249191,252723,255167,null,4,126.41112266112266,128.24688149688149,129.51715176715177,131.35291060291061,132.62318087318087,null,4,189.616683991684,192.37032224532223,194.27572765072767,197.02936590436593,198.93477130977129,null,4,63.205561330561331,64.123440748440743,64.758575883575887,65.676455301455306,66.311590436590436]
[5,20590.166666666668,20891.666666666668,21100.5,21402,21610.666666666668,null,24671632.166666668,17095383.416666668,24672142.5,null,5,20590.166666666668,20891.666666666668,21100.5,21402,21610.666666666668,null,24671632.166666668,17095383.416666668,24672142.5,17082266.916666668,null,5,156614,90468,247082,2847,4819,7666,9636,null,2293,3882,6175,7762,null,3618,6124,9742,12246,null,247082,250700,253206,256824,259328,null,156614,90468.077099999995,247082,null,3618,6124,9742,12246,null,247082,250700,253206,256824,259328,null,5,128.42099792099793,130.30145530145529,131.6039501039501,133.48440748440748,134.78586278586278,null,5,192.6314968814969,195.45218295218294,197.40592515592516,200.22661122661123,202.17879417879416,null,5,64.210498960498967,65.150727650727646,65.801975051975049,66.742203742203742,67.392931392931388]
[6,20921.583333333332,21230.5,21444.416666666668,21753.25,21967.166666666668,null,25278360.166666668,17511342.416666668,25272069.5,null,6,20921.583333333332,21230.5,21444.416666666668,21753.25,21967.166666666668,null,25278360.166666668,17511342.416666668,25272069.5,17511865.166666668,null,6,159135,91924,251059,2917,4937,7854,9873,null,2350,3977,6326,7953,null,3707,6274,9980,12547,null,251059,254766,257333,261039,263606,null,159135,91924.332750000001,251059,null,3707,6274,9980,12547,null,251059,254766,257333,261039,263606,null,6,130.48804573804574,132.4147609147609,133.74896049896049,135.67515592515593,137.00935550935552,null,6,195.73206860706861,198.62214137214136,200.62344074844071,203.5127338877339,205.51403326403329,null,6,65.244022869022871,66.207380457380452,66.874480249480243,67.837577962577967,68.504677754677758]
[7,21261.583333333332,21578.166666666668,21797.5,22114,22333.083333333332,null,25905537,17954563.916666668,25899259.5,null,7,21261.583333333332,21578.166666666668,21797.5,22114,22333.083333333332,null,25905537,17954563.916666668,25899259.5,17934659.416666668,null,7,161721,93418,255139,2989,5060,8049,10118,null,2408,4076,6484,8150,null,3799,6431,10229,12858,null,255139,258938,261570,265368,267997,null,161721,93418.135649999997,255139,null,3799,6431,10229,12858,null,255139,258938,261570,265368,267997,null,7,132.60862785862787,134.5831600831601,135.95114345114345,137.92515592515593,139.29158004158003,null,7,198.9129417879418,201.87474012474013,203.92671517671516,206.8877338877339,208.93737006237006,null,7,66.304313929313935,67.291580041580048,67.975571725571726,68.962577962577967,69.645790020790017]
[8,21623.916666666668,21948.666666666668,22173.583333333332,22498.166666666668,22723,null,26573616.916666668,18411435.25,26560539.666666668,null,8,21623.916666666668,21948.666666666668,22173.583333333332,22498.166666666668,22723,null,26573616.916666668,18411435.25,26560539.666666668,18405171.25,null,8,164477,95010,259487,3067,5190,8256,10379,null,2470,4181,6650,8360,null,3897,6596,10491,13189,null,259487,263384,266083,269978,272676,null,164477,95010.139049999998,259487,null,3897,6596,10491,13189,null,259487,263384,266083,269978,272676,null,8,134.86850311850313,136.8939708939709,138.29677754677755,140.32120582120581,141.72349272349271,null,8,202.30275467775471,205.34095634095635,207.44516632016632,210.48180873180871,212.58523908523907,null,8,67.434251559251564,68.446985446985451,69.148388773388774,70.160602910602904,70.861746361746356]
[9,22304.166666666668,22637.083333333332,22867.416666666668,23200.166666666668,23430.583333333332,null,{"$f":"ROUND(AQ14+(AR14-AQ14)/3*faktor,0)/12","v":27242014.75},{"$f":"ROUND(AR14+(AS14-AR14)/3*faktor,0)/12","v":18854997.5},{"$f":"ROUND(AS14+(AT14-AS14)/3*faktor,0)/12","v":27228951.083333332},null,9,22304.166666666668,22637.083333333332,22867.416666666668,23200.166666666668,23430.583333333332,null,{"$f":"(BF14+ROUND((BG14-BF14)/3*faktor,0))/12","v":27242014.75},{"$f":"(BG14+ROUND((BH14-BG14)/3*faktor,0))/12","v":18854997.5},{"$f":"(BH14+ROUND((BI14-BH14)/3*faktor,0))/12","v":27228951.083333332},{"$f":"(BI14+ROUND((BJ14-BI14)/3*faktor,0))/12","v":18862374.083333332},null,9,169651,97999,267650,3143,5319,8461,10637,null,2532,4284,6815,8568,null,3995,6759,10752,13517,{"$f":"AR14/12","v":22637.083333333332},267650,{"$f":"ROUND($AA14+AL14,0)","v":271645},{"$f":"$AA14+AM14","v":274409},{"$f":"$AA14+AN14","v":278402},{"$f":"$AA14+AO14","v":281167},null,169651,97998.900150000001,267650,null,3995,6759,10752,13517,null,267650,271645,274409,278402,281167,null,9,139.11122661122661,141.18762993762994,142.62422037422039,144.69958419958419,146.13669438669439,null,9,208.66683991683993,211.7814449064449,213.93633056133058,217.04937629937629,219.20504158004158,null,9,69.555613305613306,70.593814968814968,71.312110187110193,72.349792099792097,73.068347193347194]
[10,22461.666666666668,22802.833333333332,23038.916666666668,23380,23616.25,null,27916703.25,19325290.916666668,27910467,null,10,22461.666666666668,22802.833333333332,23038.916666666668,23380,23616.25,null,27916703.25,19325290.916666668,27910467,19339495,null,10,170849,98691,269540,3221,5451,8672,10903,null,2595,4391,6985,8782,null,4094,6927,11020,13855,null,269540,{"$f":"$AA15+AL15","v":273634},276467,280560,283395,null,170849,98690.924849999996,269540,null,4094,6927,11020,13855,null,269540,273634,276467,280560,283395,null,10,140.0935550935551,142.22141372141371,143.69386694386694,145.82120582120581,147.29469854469855,null,10,210.14033264033264,213.33212058212058,215.54080041580039,218.73180873180871,220.94204781704781,null,10,70.046777546777548,71.110706860706856,71.846933471933468,72.910602910602904,73.647349272349274]
[11,22889.333333333332,23238.916666666668,23481.083333333332,23830.666666666668,24072.833333333332,null,28605288.75,19823108.5,28605880.5,null,11,22889.333333333332,23238.916666666668,23481.083333333332,23830.666666666668,24072.833333333332,null,28605288.75,19823108.5,28605880.5,19823700.25,null,11,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y16+$Y$5)*regulering,0),ROUND(Y16*regulering,0))","v":100570},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,Y16:Z16),SUM(Y16:Z16))","v":274672},3301,5588,8889,11175,2659,2659,4501,7160,9002,null,4195,7101,11296,14202,null,274672,278867,281773,285968,288874,null,173067,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW16+$Y$5)*regulering,0),ROUND(AW16*regulering,0))","v":100570},{"$f":"IF(beregningsdato>=$AA$5,SUM($Y$5,AW16:AX16),SUM(AW16:AX16))","v":274672},null,4195,7101,11296,14202,null,274672,278867,281773,285968,288874,null,11,142.76091476091477,144.94126819126819,146.45166320166319,148.63201663201664,150.14241164241164,null,11,214.14137214137216,217.41190228690229,219.67749480249478,222.94802494802497,225.21361746361748,null,11,71.380457380457386,72.470634095634097,73.225831600831597,74.316008316008322,75.071205821205822]
[12,23279.166666666668,23637.583333333332,23885.666666666668,24244.166666666668,24492.25,null,29327903.75,20307261.666666668,29335323.666666668,null,12,23279.166666666668,23637.583333333332,23885.666666666668,24244.166666666668,24492.25,null,29327903.75,20307261.666666668,29335323.666666668,20307868.25,null,12,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y17+$Y$5)*regulering,0),ROUND(Y17*regulering,0))","v":102283},279350,3384,5727,9112,11455,2726,2726,4613,7340,9227,null,4301,7278,11580,14557,null,279350,283651,286628,290930,293907,null,176032,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW17+$Y$5)*regulering,0),ROUND(AW17*regulering,0))","v":102283},279350,null,4301,7278,11580,14557,null,279350,283651,286628,290930,293907,null,12,145.19230769230768,147.42775467775468,148.97505197505197,151.21101871101871,152.758316008316,null,12,217.78846153846152,221.141632016632,223.46257796257794,226.81652806652806,229.137474012474,null,12,72.59615384615384,73.713877338877339,74.487525987525984,75.605509355509355,76.379158004158]
[13,23680,24047.5,24301.833333333332,24669.333333333332,24923.75,null,30070970,20818679.916666668,30071591.833333332,null,13,23680,24047.5,24301.833333333332,24669.333333333332,24923.75,null,30070970,20818679.916666668,30071591.833333332,20826115.25,null,13,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((Y18+$Y$5)*regulering,0),ROUND(Y18*regulering,0))","v":104044},284160,3470,5872,9342,11744,2795,2795,4730,7525,9460,null,4410,7462,11872,14925,null,284160,288570,291622,296032,299085,null,179081,{"$f":"IF(beregningsdato>=$AA$5,ROUND((AW18+$Y$5)*regulering,0),ROUND(AW18*regulering,0))","v":104044},284160,null,4410,7462,11872,14925,null,284160,288570,291622,296032,299085,null,13,147.69230769230768,149.98440748440748,151.57068607068607,153.86278586278587,155.44958419958419,null,13,221.53846153846152,224.97661122661123,227.3560291060291,230.7941787941788,233.17437629937629,null,13,73.84615384615384,74.992203742203742,75.785343035343033,76.931392931392935,77.724792099792097]
[14,24091.916666666668,24468.583333333332,24729.25,25106.083333333332,25366.916666666668,null,30820860.833333332,21336922.833333332,30835125,null,14,24091.916666666668,24468.583333333332,24729.25,25106.083333333332,25366.916666666668,null,30820860.833333332,21336922.833333332,30835125,21351187.166666668,null,14,182214,105854,289103,3557,6019,9577,12039,2865,2865,4848,7714,9698,null,4520,7648,12170,15300,null,289103,293623,296751,301273,304403,null,182214,105854,289103,null,4520,7648,12170,15300,null,289103,293623,296751,301273,304403,null,14,150.26143451143452,152.61070686070687,154.23648648648648,156.58679833679832,158.21361746361745,null,14,225.39215176715177,228.91606029106032,231.35472972972974,234.88019750519749,237.32042619542619,null,14,75.130717255717258,76.305353430353435,77.118243243243242,78.293399168399162,79.106808731808727]
[15,24498.666666666668,24884.833333333332,25152.333333333332,25538.333333333332,25805.75,null,31598000.25,21896041.5,31585027,null,15,24498.666666666668,24884.833333333332,25152.333333333332,25538.333333333332,25805.75,null,31598000.25,21896041.5,31585027,21889881.583333332,null,15,185308,107641,293984,3646,6172,9818,12343,2937,2937,4972,7908,9942,null,4634,7844,12476,15685,null,293984,298618,301828,306460,309669,null,185308,107641,293984,null,4634,7844,12476,15685,null,293984,298618,301828,306460,309669,null,15,152.79833679833681,155.20686070686071,156.87525987525987,159.28274428274429,160.95062370062371,null,15,229.19750519750522,232.81029106029106,235.31288981288981,238.92411642411645,241.42593555093555,null,15,76.399168399168403,77.603430353430355,78.437629937629936,79.641372141372145,80.475311850311854]
[16,24915,25310.833333333332,25585,25980.833333333332,26255.25,null,32388776.083333332,22441543.083333332,32389446.083333332,null,16,24915,25310.833333333332,25585,25980.833333333332,26255.25,null,32388776.083333332,22441543.083333332,32389446.083333332,22462653.416666668,null,16,188475,109470,298980,3738,6327,10065,12655,3011,3011,5096,8107,10194,null,4750,8040,12790,16083,null,298980,303730,307020,311770,315063,null,188475,109470,298980,null,4750,8040,12790,16083,null,298980,303730,307020,311770,315063,null,16,155.39501039501039,157.86382536382536,159.57380457380458,162.04261954261955,163.754158004158,null,16,233.09251559251558,236.79573804573803,239.36070686070687,243.06392931392932,245.631237006237,null,16,77.697505197505194,78.931912681912678,79.78690228690229,81.021309771309774,81.877079002079]
[17,{"$f":"AQ22/12","v":25260.916666666668},25668.75,25951.166666666668,26359.083333333332,26641.333333333332,null,33370258,23116432,33377761.75,null,17,{"$f":"BF22/12","v":25260.916666666668},25668.75,25951.166666666668,26359.083333333332,26641.333333333332,null,33370258,23116432,33377761.75,23103495.416666668,null,17,191106,110990,303131,3851,6518,10370,13035,3102,3102,5250,8353,10500,null,4894,8283,13178,16565,null,303131,308025,311414,316309,319696,null,191106,110990,303131,null,4894,8283,13178,16565,null,303131,{"$f":"$BF22+BA22","v":308025},311414,316309,319696,null,17,{"$f":"AQ22/1924","v":157.55249480249481},160.09615384615384,161.85758835758836,164.40176715176716,166.16216216216216,null,17,236.32874220374219,240.14423076923077,242.78638253638252,246.60265072765074,249.24324324324323,null,17,{"$f":"AQ22/1924/2","v":78.776247401247403},80.04807692307692,80.928794178794178,82.20088357588358,83.081081081081081]
[18,25722.25,26140.5,26429.916666666668,26848.333333333332,27137.833333333332,null,34222399.916666664,23689233.083333332,34236734.5,null,18,25722.25,26140.5,26429.916666666668,26848.333333333332,27137.833333333332,null,34222399.916666664,23689233.083333332,34236734.5,23696754.333333332,null,18,194615,113017,308667,3949,6683,10633,13367,3181,3181,5383,8565,10767,null,5019,8492,13513,16987,null,308667,313686,317159,322180,325654,null,194615,113017,308667,null,5019,8492,13513,16987,null,308667,313686,317159,322180,325654,null,18,160.42983367983368,163.03846153846155,164.8435550935551,167.45322245322245,169.25883575883577,null,18,{"$f":"AQ23/1924*1.5","v":240.64475051975052},244.55769230769232,247.26533264033264,251.17983367983368,253.88825363825367,null,18,80.214916839916839,81.519230769230774,82.421777546777548,83.726611226611226,84.629417879417886]
[19,26067.666666666668,26496.5,26793.5,27222.333333333332,27519.333333333332,null,35088052.75,24309612.5,35088778.583333336,null,19,26067.666666666668,26496.5,26793.5,27222.333333333332,27519.333333333332,null,35088052.75,24309612.5,35088778.583333336,24310338.333333332,null,19,197242,114535,312812,4050,6854,10904,13708,3262,3262,5521,8783,11042,null,5146,8710,13856,17420,null,312812,317958,321522,326668,330232,null,197242,114535,312812,null,5146,8710,13856,17420,null,312812,317958,321522,326668,330232,null,19,162.58419958419958,165.25883575883577,167.11122661122661,169.78586278586278,171.63825363825364,null,19,243.87629937629936,247.88825363825367,250.66683991683993,254.67879417879416,257.45738045738045,null,19,81.292099792099791,82.629417879417886,83.555613305613306,84.892931392931388,85.819126819126822]
[20,26375.916666666668,26815.666666666668,27120.166666666668,27560.083333333332,27864.416666666668,null,35980922.25,24923141.666666668,35995293.416666664,null,20,26375.916666666668,26815.666666666668,27120.166666666668,27560.083333333332,27864.416666666668,null,35980922.25,24923141.666666668,35995293.416666664,24910259.166666668,null,20,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y25+$AC$5)*regulering,0),ROUND(Y25*regulering,0))","v":115889},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y25:Z25),SUM(Y25:Z25))","v":316511},4153,7028,11182,14056,3345,3345,5661,9007,11322,null,5277,8931,14210,17862,null,316511,321788,325442,330721,334373,null,199969,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW25+$AC$5)*regulering,0),ROUND(AW25*regulering,0))","v":115889},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW25:AX25),SUM(AW25:AX25))","v":316511},null,5277,8931,14210,17862,null,316511,321788,325442,330721,334373,null,20,164.50675675675674,167.24948024948026,169.14864864864865,171.89241164241164,173.79054054054055,null,20,246.7601351351351,250.87422037422039,253.72297297297297,257.83861746361748,260.68581081081084,null,20,82.253378378378372,83.624740124740129,84.574324324324323,85.946205821205822,86.895270270270274]
[21,26812,27263.083333333332,27575.333333333332,28026.416666666668,28338.666666666668,null,36907986.75,25557239.416666668,36908750.083333336,null,21,26812,27263.083333333332,27575.333333333332,28026.416666666668,28338.666666666668,null,36907986.75,25557239.416666668,36908750.083333336,25558002.75,null,21,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((Y26+$AC$5)*regulering,0),ROUND(Y26*regulering,0))","v":117805},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,Y26:Z26),SUM(Y26:Z26))","v":321744},4259,7208,11467,14416,3431,3431,5806,9237,11612,null,{"$f":"ROUND(VLOOKUP($X26,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":5413},9160,14573,18320,null,321744,327157,330904,336317,340064,null,203286,{"$f":"IF(beregningsdato>=$AB$5,ROUND((AW26+$AC$5)*regulering,0),ROUND(AW26*regulering,0))","v":117805},{"$f":"IF(beregningsdato>=$AB$5,SUM($AC$5,AW26:AX26),SUM(AW26:AX26))","v":321744},null,5413,9160,14573,18320,null,321744,327157,330904,336317,340064,null,21,167.22661122661123,170.04002079002078,171.987525987526,174.80093555093555,176.74844074844074,null,21,250.83991683991684,255.06003118503116,257.98128898128903,262.20140332640335,265.1226611226611,null,21,83.613305613305613,85.020010395010388,85.993762993762999,87.400467775467774,88.374220374220371]
[22,27130.583333333332,27581.666666666668,27893.916666666668,28345,28657.25,null,36908305.333333336,25557558,36909068.666666664,null,22,27130.583333333332,27581.666666666668,27893.916666666668,28345,28657.25,null,36908305.333333336,25557558,36909068.666666664,25558321.333333332,null,22,206362,119205,325567,4259,7208,11467,14416,null,3431,5806,9237,11612,null,5413,9160,14573,18320,null,325567,330980,334727,340140,343887,null,206362,119205.00930000001,325567,null,5413,9160,14573,18320,null,325567,330980,334727,340140,343887,null,22,169.21361746361745,172.02702702702703,173.97453222453223,176.78794178794178,178.735446985447,null,22,253.82042619542619,258.04054054054052,260.96179833679832,265.18191268191265,268.10317047817051,null,22,84.606808731808727,86.013513513513516,86.987266112266113,88.393970893970888,89.367723492723499]
[23,27563.25,28002.083333333332,28305.666666666668,28744.416666666668,29048.083333333332,null,35907161.666666664,24849380.166666668,35901090.666666664,null,23,27563.25,28002.083333333332,28305.666666666668,28744.416666666668,29048.083333333332,null,35907161.666666664,24849380.166666668,35901090.666666664,24856936,null,23,209653,121106,330759,4144,7010,11153,14021,null,3338,5647,8984,11294,null,5266,8909,14174,17818,null,330759,336025,339668,344933,348577,null,209653,121106.05545,330759,null,5266,8909,14174,17818,null,330759,336025,339668,344933,348577,null,23,171.91216216216216,174.64916839916839,176.54261954261955,179.27910602910603,181.17307692307693,null,23,257.86824324324323,261.97375259875258,264.81392931392929,268.91865904365903,271.75961538461542,null,23,85.956081081081081,87.324584199584194,88.271309771309774,89.639553014553016,90.586538461538467]
[24,28009.75,28436,28731.166666666668,29157.333333333332,29452.416666666668,null,34878778.083333336,24161656.25,34872686.083333336,null,24,28009.75,28436,28731.166666666668,29157.333333333332,29452.416666666668,null,34878778.083333336,24161656.25,34872686.083333336,24155564.083333332,null,24,213049,123068,336117,4025,6812,10837,13623,null,3242,5487,8729,10973,null,5115,8657,13771,17312,null,336117,341232,344774,349888,353429,null,213049,123067.75485,336117,null,5115,8657,13771,17312,null,336117,341232,344774,349888,353429,null,24,174.69698544698545,177.35550935550935,179.19646569646571,181.85446985446984,183.69490644490645,null,24,262.04547817047819,266.033264033264,268.79469854469858,272.78170478170478,275.54235966735968,null,24,87.348492723492726,88.677754677754677,89.598232848232854,90.92723492723492,91.847453222453225]
[25,28465.5,28878.416666666668,29164.25,29577.333333333332,{"$f":"AU30/12","v":29863.166666666668},null,33789082.75,23398992.833333332,33803408.333333336,null,25,28465.5,28878.416666666668,29164.25,29577.333333333332,29863.166666666668,null,33789082.75,23398992.833333332,33803408.333333336,23399691.75,null,25,216516,125070,341586,3899,6598,10499,13198,null,3141,5315,8457,10631,null,4955,8385,13342,16772,null,341586,346541,349971,354928,358358,null,216516,125070.46739999999,341586,null,4955,8385,13342,16772,null,341586,346541,349971,354928,358358,null,25,177.53950103950103,180.11486486486487,181.89760914760916,184.47401247401248,186.25675675675674,null,25,266.30925155925155,270.17229729729729,272.84641372141374,276.71101871101871,279.3851351351351,null,25,88.769750519750517,90.057432432432435,90.94880457380458,92.237006237006241,93.128378378378372]
[26,28931.833333333332,29330.75,29606.666666666668,30005.333333333332,30281.416666666668,null,32644890.416666668,22588645.333333332,32625124.916666668,null,26,28931.833333333332,29330.75,29606.666666666668,30005.333333333332,30281.416666666668,null,32644890.416666668,22588645.333333332,32625124.916666668,22602946.75,null,26,220063,127119,347182,3766,6372,10137,12743,null,3034,5133,8165,10265,null,4787,8098,12882,16195,null,347182,351969,355280,360064,363377,null,220063,127119.39195,347182,null,4787,8098,12882,16195,null,347182,351969,355280,360064,363377,null,26,180.44802494802494,182.93607068607068,184.65696465696465,187.14345114345113,188.86538461538461,null,26,270.67203742203742,274.404106029106,276.98544698544697,280.71517671517671,283.29807692307691,null,26,90.224012474012468,91.468035343035339,92.328482328482323,93.571725571725565,94.432692307692307]
[27,29408.833333333332,29792.333333333332,30057.666666666668,30441.166666666668,30706.583333333332,null,31384880.166666668,21723799.416666668,31385529,null,27,29408.833333333332,29792.333333333332,30057.666666666668,30441.166666666668,30706.583333333332,null,31384880.166666668,21723799.416666668,31385529,21731261.75,null,27,223691,129215,352906,3621,6127,9748,12254,null,2917,4935,7852,9871,null,4602,7786,12388,15573,null,352906,357508,360692,365294,368479,null,223691,129215.10614999999,352906,null,4602,7786,12388,15573,null,352906,357508,360692,365294,368479,null,27,183.42307692307693,185.81496881496881,187.46985446985448,189.86174636174636,191.51715176715177,null,27,275.13461538461542,278.72245322245323,281.20478170478174,284.79261954261955,287.27572765072767,null,27,91.711538461538467,92.907484407484404,93.734927234927241,94.930873180873178,95.758575883575887]
[28,29896.333333333332,30263.5,30517.666666666668,30884.833333333332,31138.833333333332,null,30049932.583333332,20811269.083333332,30050553.916666668,null,28,29896.333333333332,30263.5,30517.666666666668,30884.833333333332,31138.833333333332,null,30049932.583333332,20811269.083333332,30050553.916666668,20798263.5,null,28,227399,131357,358756,3467,5867,9334,11733,null,2793,4726,7519,9451,null,4406,7456,11862,14910,null,358756,363162,366212,370618,373666,null,227399,131357.03234999999,358756,null,4406,7456,11862,14910,null,358756,363162,366212,370618,373666,null,28,186.46361746361745,188.75363825363826,190.33887733887735,192.62889812889813,194.21309771309771,null,28,279.69542619542619,283.13045738045741,285.508316008316,288.94334719334722,291.31964656964658,null,28,93.231808731808727,94.376819126819129,95.169438669438676,96.314449064449065,97.106548856548855]
[29,30394.833333333332,30744.666666666668,30986.75,31336.416666666668,31578.583333333332,null,28633234.583333332,19823800.75,28620199.666666668,null,29,30394.833333333332,30744.666666666668,30986.75,31336.416666666668,31578.583333333332,null,28633234.583333332,19823800.75,28620199.666666668,19831206,null,29,231191,133547,364738,3303,5589,8891,11178,null,2661,4502,7162,9004,null,4198,7103,11299,14205,null,364738,368936,371841,376037,378943,null,231191,133547.48115000001,364738,null,4198,7103,11299,14205,null,364738,368936,371841,376037,378943,null,29,189.57276507276507,191.75467775467774,193.264553014553,195.44542619542619,196.9558212058212,null,29,284.35914760914761,287.63201663201664,289.89682952182949,293.16813929313929,295.43373180873181,null,29,94.786382536382533,95.877338877338872,96.632276507276501,97.722713097713097,98.477910602910598]
[30,30904.166666666668,31235.333333333332,31464.75,31795.833333333332,32025.083333333332,null,27107532.416666668,18788647.916666668,27101279.5,null,30,30904.166666666668,31235.333333333332,31464.75,31795.833333333332,32025.083333333332,null,27107532.416666668,18788647.916666668,27101279.5,18775581.5,null,30,235065,135785,370850,3127,5293,8420,10585,null,2519,4264,6782,8526,null,3974,6727,10700,13451,null,370850,374824,377577,381550,384301,null,235065,135785.29725,370850,null,3974,6727,10700,13451,null,370850,374824,377577,381550,384301,null,30,192.74948024948026,194.81496881496881,196.245841995842,198.31081081081081,199.74064449064448,null,30,289.12422037422039,292.22245322245323,294.36876299376297,297.4662162162162,299.61096673596671,null,30,96.374740124740129,97.407484407484404,98.122920997921,99.155405405405403,99.870322245322242]
[31,31425.083333333332,31736.666666666668,31952.25,32263.833333333332,32479.5,null,25506893.833333332,17658117.416666668,25507421,null,31,31425.083333333332,31736.666666666668,31952.25,32263.833333333332,32479.5,null,25506893.833333332,17658117.416666668,25507421,17665458.083333332,null,31,239027,138074,377101,2942,4978,7920,9956,null,2370,4010,6380,8020,null,3739,6326,10065,12653,null,377101,380840,383427,387166,389754,null,239027,138073.94654999999,377101,null,3739,6326,10065,12653,null,377101,380840,383427,387166,389754,null,31,195.99844074844074,197.94178794178794,199.28638253638255,201.22972972972974,202.57484407484407,null,31,293.9976611226611,296.91268191268193,298.92957380457381,301.84459459459458,303.86226611226607,null,31,97.999220374220371,98.970893970893968,99.643191268191273,100.61486486486487,101.28742203742203]
[32,31957.5,32248.083333333332,32449.083333333332,32739.75,32940.916666666664,null,23790438.25,16466276.083333334,23797743.333333332,null,32,31957.5,32248.083333333332,32449.083333333332,32739.75,32940.916666666664,null,23790438.25,16466276.083333334,23797743.333333332,16480394.666666666,null,32,243077,140413,383490,2743,4642,7387,9286,null,2210,3739,5950,7480,null,3487,5899,9387,11801,null,383490,386977,389389,392877,395291,null,243077,140413.42905000001,383490,null,3487,5899,9387,11801,null,383490,386977,389389,392877,395291,null,32,199.31912681912681,201.13149688149687,202.38513513513513,204.19802494802494,205.45270270270271,null,32,298.9786902286902,301.69724532224529,303.57770270270271,306.29703742203742,308.17905405405406,null,32,99.659563409563404,100.56574844074844,101.19256756756756,102.09901247401247,102.72635135135135]
[33,32501.583333333332,32769.916666666664,32955.666666666664,33224,33409.666666666664,null,21971792.666666668,15219937.583333334,21972246.75,null,33,32501.583333333332,32769.916666666664,32955.666666666664,33224,33409.666666666664,null,21971792.666666668,15219937.583333334,21972246.75,15213578.25,null,33,247215,{"$f":"ROUND(Y38*regulering,0)","v":142804},390019,2534,4288,6822,8575,null,2041,3454,5495,6907,null,3220,5449,8669,10897,null,390019,393239,395468,398688,400916,null,247215,{"$f":"AW38*regulering","v":142803.74475000001},390019,null,{"$f":"ROUND(AL38*udbygningspct,0)","v":3220},{"$f":"ROUND(AM38*udbygningspct,0)","v":5449},{"$f":"ROUND(AN38*udbygningspct,0)","v":8669},{"$f":"ROUND(AO38*udbygningspct,0)","v":10897},null,390019,393239,395468,398688,400916,null,33,202.71257796257797,204.38617463617464,205.54469854469855,207.21829521829522,208.37629937629939,null,33,304.06886694386696,306.57926195426194,308.31704781704781,310.82744282744284,312.56444906444909,null,33,101.35628898128898,102.19308731808732,102.77234927234927,103.60914760914761,104.18814968814969]
[34,33058.25,33303.083333333336,33472.416666666664,33717.166666666664,33886.666666666664,null,20050958,13878222.166666666,20044558.75,null,34,33058.25,33303.083333333336,33472.416666666664,33717.166666666664,33886.666666666664,null,20050958,13878222.166666666,20044558.75,13892263.166666666,null,34,251449,145250,396699,2311,3911,6222,7823,null,1862,3150,5012,6301,null,2938,4970,7907,9941,null,396699,399637,401669,404606,406640,null,251449,145249.51485000001,396699,null,2938,4970,7907,9941,null,396699,399637,401669,404606,406640,null,34,206.18451143451142,207.71153846153845,208.76767151767152,210.2941787941788,211.35135135135135,null,34,309.2767671517671,311.56730769230768,313.15150727650729,315.44126819126819,317.02702702702703,null,34,103.09225571725571,103.85576923076923,104.38383575883576,105.1470893970894,105.67567567567568]
[35,33626.583333333336,33846.416666666664,33998.5,34218.166666666664,34370.416666666664,null,18007493,12468382.5,17994238.083333332,null,35,33626.583333333336,33846.416666666664,33998.5,34218.166666666664,34370.416666666664,null,18007493,12468382.5,17994238.083333332,12482381.166666666,null,35,255772,147747,403519,2076,3512,5586,7024,null,1672,2829,4500,5658,null,2638,4463,7099,8926,null,403519,406157,407982,410618,412445,null,255772,147746.69579999999,403519,null,2638,4463,7099,8926,null,403519,406157,407982,410618,412445,null,35,209.72920997920997,211.10031185031184,212.04885654885655,213.41891891891891,214.36850311850313,null,35,314.59381496881497,316.65046777546775,318.07328482328484,320.12837837837833,321.55275467775471,null,35,104.86460498960498,105.55015592515592,106.02442827442827,106.70945945945945,107.18425155925156]
[36,34207.916666666664,34401.333333333336,34535,34728.25,34862.083333333336,null,15848212.5,10963166.25,15834912.666666666,null,36,34207.916666666664,34401.333333333336,34535,34728.25,34862.083333333336,null,15848212.5,10963166.25,15834912.666666666,10977120,null,36,260194,150301,410495,1826,3089,4914,6177,null,1471,2488,3958,4976,null,2321,3925,6244,7850,null,410495,412816,414420,416739,418345,null,260194,150301.06409999999,410495,null,2321,3925,6244,7850,null,410495,412816,414420,416739,418345,null,36,213.35498960498961,214.56133056133055,215.39501039501039,216.60031185031184,217.43503118503119,null,36,320.03248440748439,321.84199584199581,323.09251559251561,324.90046777546775,326.15254677754677,null,36,106.67749480249481,107.28066528066527,107.69750519750519,108.30015592515592,108.7175155925156]
[37,34801.916666666664,34967.166666666664,35081.666666666664,35246.916666666664,35361.333333333336,null,13545862.25,9396639.833333334,13546142,null,37,34801.916666666664,34967.166666666664,35081.666666666664,35246.916666666664,35361.333333333336,null,13545862.25,9396639.833333334,13546142,9390106.166666666,null,37,264712,152911,417623,1560,2642,4202,5282,null,1257,2128,3385,4255,null,1983,3357,5340,6713,null,417623,419606,420980,422963,424336,null,264712,152910.88680000001,417623,null,1983,3357,5340,6713,null,417623,419606,420980,422963,424336,null,37,217.05977130977132,218.09043659043658,218.80457380457381,219.8352390852391,220.54885654885655,null,37,325.58965696465697,327.13565488565484,328.20686070686071,329.75285862785864,330.82328482328484,null,37,108.52988565488566,109.04521829521829,109.4022869022869,109.91761954261955,110.27442827442827]
[38,35432.416666666664,35570.75,35666.583333333336,35804.833333333336,35900.833333333336,null,11345750.166666666,7871031.833333333,11339170.916666666,null,38,35432.416666666664,35570.75,35666.583333333336,35804.833333333336,35900.833333333336,null,11345750.166666666,7871031.833333333,11339170.916666666,7884892.833333333,null,38,269508,155681,425189,1306,2211,3517,4423,null,1052,1781,2833,3563,null,1660,2810,4469,5621,null,425189,426849,427999,429658,430810,null,269508,155681.29620000001,425189,null,1660,2810,4469,5621,null,425189,426849,427999,429658,430810,null,38,220.99220374220374,221.85498960498961,222.45270270270271,223.31496881496881,223.91372141372142,null,38,331.48830561330561,332.78248440748439,333.67905405405406,334.97245322245323,335.87058212058213,null,38,110.49610187110187,110.92749480249481,111.22635135135135,111.6574844074844,111.95686070686071]
[39,36065.5,36172,36245.75,36352.25,36426.083333333336,null,8743647.5,6066070.333333333,8743827.75,null,39,36065.5,36172,36245.75,36352.25,36426.083333333336,null,8743647.5,6066070.333333333,8743827.75,6073064,null,39,274323,158463,432786,1006,1702,2708,3405,null,810,1371,2181,2743,null,1278,2163,3441,4327,null,432786,434064,434949,436227,437113,null,274323,158462.68095000001,432786,null,1278,2163,3441,4327,null,432786,434064,434949,436227,437113,null,39,224.94074844074845,225.60498960498961,226.06496881496881,226.72920997920997,227.18970893970894,null,39,337.4111226611227,338.40748440748439,339.09745322245323,340.09381496881497,340.78456340956342,null,39,112.47037422037423,112.80249480249481,113.0324844074844,113.36460498960498,113.59485446985447]
[40,36712.833333333336,36785.666666666664,36836.166666666664,36909.083333333336,36959.583333333336,null,5991663.25,4165733,5998600.083333333,null,40,36712.833333333336,36785.666666666664,36836.166666666664,36909.083333333336,36959.583333333336,null,5991663.25,4165733,5998600.083333333,4165856.4166666665,null,40,279247,161307,440554,688,1165,1853,2330,null,554,938,1493,1877,null,874,1480,2355,2961,null,440554,441428,442034,442909,443515,null,279247,161307.02955000001,440554,null,874,1480,2355,2961,null,{"$f":"AY45","v":440554},441428,442034,442909,443515,null,40,228.97817047817048,229.43243243243242,229.74740124740126,230.20218295218297,230.51715176715177,null,40,343.46725571725574,344.14864864864865,344.62110187110187,345.30327442827445,345.77572765072767,null,40,114.48908523908524,114.71621621621621,114.87370062370063,115.10109147609148,115.25857588357589]
[41,37374.25,37411.583333333336,37437.583333333336,37474.833333333336,37500.833333333336,null,3089797.3333333335,2163206.25,3083047.25,null,41,37374.25,37411.583333333336,37437.583333333336,37474.833333333336,37500.833333333336,null,3089797.3333333335,2163206.25,3083047.25,2163269.5,null,41,284278,164213,448491,353,598,950,1195,null,284,482,765,963,null,{"$f":"ROUND(VLOOKUP($X46,$X:$AJ,(4+AL$4)+$AM$5)*(1+$AL$5),0)","v":448},760,1207,1519,null,448491,448939,449251,449698,450010,null,284278,164213.18669999999,448491,null,448,760,1207,1519,null,{"$f":"AY46","v":448491},448939,449251,449698,450010,null,41,233.10343035343035,233.33627858627858,233.49844074844074,233.73076923076923,233.89293139293139,null,41,349.65514553014555,350.00441787941787,350.2476611226611,350.59615384615381,350.8393970893971,null,41,116.55171517671518,116.66813929313929,116.74922037422037,116.86538461538461,116.94646569646569]
[42,38050,38050,38050,38050,38050,null,38050,38050,38050,null,42,38050,38050,38050,38050,38050,null,38050,38050,38050,38050,null,42,289418,167182,456600,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,456600,456600,456600,456600,456600,null,289418,167182.3077,456600,null,0,0,0,0,null,456600,456600,456600,456600,456600,null,42,237.31808731808732,237.31808731808732,237.31808731808732,237.31808731808732,237.31808731808732,null,42,355.97713097713097,355.97713097713097,355.97713097713097,355.97713097713097,355.97713097713097,null,42,118.65904365904366,118.65904365904366,118.65904365904366,118.65904365904366,118.65904365904366]
[43,38895.666666666664,38895.666666666664,38895.666666666664,38895.666666666664,38895.666666666664,null,38895.666666666664,38895.666666666664,38895.666666666664,null,43,38895.666666666664,38895.666666666664,38895.666666666664,38895.666666666664,38895.666666666664,null,38895.666666666664,38895.666666666664,38895.666666666664,38895.666666666664,null,43,295850,170898,466748,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,466748,466748,466748,466748,466748,null,295850,170897.7525,466748,null,0,0,0,0,null,466748,466748,466748,466748,466748,null,43,242.59251559251558,242.59251559251558,242.59251559251558,242.59251559251558,242.59251559251558,null,43,363.88877338877336,363.88877338877336,363.88877338877336,363.88877338877336,363.88877338877336,null,43,121.29625779625779,121.29625779625779,121.29625779625779,121.29625779625779,121.29625779625779]
[44,39764.666666666664,39764.666666666664,39764.666666666664,39764.666666666664,39764.666666666664,null,39764.666666666664,39764.666666666664,39764.666666666664,null,44,39764.666666666664,39764.666666666664,39764.666666666664,39764.666666666664,39764.666666666664,null,39764.666666666664,39764.666666666664,39764.666666666664,39764.666666666664,null,44,302460,174716,477176,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,477176,477176,477176,477176,477176,null,302460,174716.019,477176,null,0,0,0,0,null,477176,477176,477176,477176,477176,null,44,248.012474012474,248.012474012474,248.012474012474,248.012474012474,248.012474012474,null,44,372.01871101871097,372.01871101871097,372.01871101871097,372.01871101871097,372.01871101871097,null,44,124.006237006237,124.006237006237,124.006237006237,124.006237006237,124.006237006237]
[45,40657.5,40657.5,40657.5,40657.5,40657.5,null,40657.5,40657.5,40657.5,null,45,40657.5,40657.5,40657.5,40657.5,40657.5,null,40657.5,40657.5,40657.5,40657.5,null,45,309251,178639,487890,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,487890,487890,487890,487890,487890,null,309251,178638.84015,487890,null,0,0,0,0,null,487890,487890,487890,487890,487890,null,45,253.58108108108109,253.58108108108109,253.58108108108109,253.58108108108109,253.58108108108109,null,45,380.37162162162167,380.37162162162167,380.37162162162167,380.37162162162167,380.37162162162167,null,45,126.79054054054055,126.79054054054055,126.79054054054055,126.79054054054055,126.79054054054055]
[46,41574.916666666664,41574.916666666664,41574.916666666664,41574.916666666664,41574.916666666664,null,41574.916666666664,41574.916666666664,41574.916666666664,null,46,41574.916666666664,41574.916666666664,41574.916666666664,41574.916666666664,41574.916666666664,null,41574.916666666664,41574.916666666664,41574.916666666664,41574.916666666664,null,46,316229,182670,498899,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,498899,498899,498899,498899,498899,null,316229,182669.68184999999,498899,null,0,0,0,0,null,498899,498899,498899,498899,498899,null,46,259.30301455301458,259.30301455301458,259.30301455301458,259.30301455301458,259.30301455301458,null,46,388.95452182952187,388.95452182952187,388.95452182952187,388.95452182952187,388.95452182952187,null,46,129.65150727650729,129.65150727650729,129.65150727650729,129.65150727650729,129.65150727650729]
[47,42314.916666666664,42314.916666666664,42314.916666666664,42314.916666666664,42314.916666666664,null,42314.916666666664,42314.916666666664,42314.916666666664,null,47,42314.916666666664,42314.916666666664,42314.916666666664,42314.916666666664,42314.916666666664,null,42314.916666666664,42314.916666666664,42314.916666666664,42314.916666666664,null,47,321858,185921,507779,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,507779,507779,507779,507779,507779,null,321858,185921.27369999999,507779,null,0,0,0,0,null,507779,507779,507779,507779,507779,null,47,263.91839916839916,263.91839916839916,263.91839916839916,263.91839916839916,263.91839916839916,null,47,395.87759875259871,395.87759875259871,395.87759875259871,395.87759875259871,395.87759875259871,null,47,131.95919958419958,131.95919958419958,131.95919958419958,131.95919958419958,131.95919958419958]
[48,44260.083333333336,44260.083333333336,44260.083333333336,44260.083333333336,44260.083333333336,null,44260.083333333336,44260.083333333336,44260.083333333336,null,48,44260.083333333336,44260.083333333336,44260.083333333336,44260.083333333336,44260.083333333336,null,44260.083333333336,44260.083333333336,44260.083333333336,44260.083333333336,null,48,336653,194468,531121,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,531121,531121,531121,531121,531121,null,336653,194467.60545,531121,null,0,0,0,0,null,531121,531121,531121,531121,531121,null,48,276.05041580041581,276.05041580041581,276.05041580041581,276.05041580041581,276.05041580041581,null,48,414.07562370062374,414.07562370062374,414.07562370062374,414.07562370062374,414.07562370062374,null,48,138.0252079002079,138.0252079002079,138.0252079002079,138.0252079002079,138.0252079002079]
[49,47230.333333333336,47230.333333333336,47230.333333333336,47230.333333333336,47230.333333333336,null,47230.333333333336,47230.333333333336,47230.333333333336,null,49,{"$f":"BF54/12","v":47230.333333333336},47230.333333333336,47230.333333333336,47230.333333333336,47230.333333333336,null,47230.333333333336,47230.333333333336,47230.333333333336,47230.333333333336,null,49,359246,207518,566764,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,566764,566764,566764,566764,566764,null,359246,207518.45189999999,566764,null,0,0,0,0,null,566764,566764,566764,566764,566764,null,49,294.57588357588355,294.57588357588355,294.57588357588355,294.57588357588355,294.57588357588355,null,49,441.8638253638253,441.8638253638253,441.8638253638253,441.8638253638253,441.8638253638253,null,49,147.28794178794178,147.28794178794178,147.28794178794178,147.28794178794178,147.28794178794178]
[50,50527.416666666664,50527.416666666664,50527.416666666664,50527.416666666664,50527.416666666664,null,50527.416666666664,50527.416666666664,50527.416666666664,null,50,{"$f":"BF55/12","v":51719.166666666664},51719.166666666664,51719.166666666664,51719.166666666664,51719.166666666664,null,51719.166666666664,51719.166666666664,51719.166666666664,51719.166666666664,null,50,384324,222005,606329,0,0,0,0,null,null,null,null,null,null,0,0,0,0,null,606329,606329,606329,606329,606329,null,393389,227241.15585000001,620630,null,0,0,0,0,null,620630,620630,620630,620630,620630,null,50,315.1398128898129,315.1398128898129,315.1398128898129,315.1398128898129,315.1398128898129,null,50,472.70971933471935,472.70971933471935,472.70971933471935,472.70971933471935,472.70971933471935,null,50,157.56990644490645,157.56990644490645,157.56990644490645,157.56990644490645,157.56990644490645]
[51,55811.25,55811.25,55811.25,55811.25,55811.25,null,55811.25,55811.25,55811.25,null,51,57313.5,57313.5,57313.5,57313.5,57313.5,null,57313.5,57313.5,57313.5,57313.5,null,51,424514,245221,669735,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,669735,669735,669735,669735,669735,null,435941,251821.31865,687762,null,0,0,0,0,null,687762,687762,687762,687762,687762,null,51,348.09511434511433,348.09511434511433,348.09511434511433,348.09511434511433,348.09511434511433,null,51,522.14267151767149,522.14267151767149,522.14267151767149,522.14267151767149,522.14267151767149,null,51,174.04755717255716,174.04755717255716,174.04755717255716,174.04755717255716,174.04755717255716]
[52,63506.166666666664,63506.166666666664,63506.166666666664,63506.166666666664,63506.166666666664,null,63506.166666666664,63506.166666666664,63506.166666666664,null,52,65274.083333333336,65274.083333333336,65274.083333333336,65274.083333333336,65274.083333333336,null,65274.083333333336,65274.083333333336,65274.083333333336,65274.083333333336,null,52,483044,279030,762074,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,762074,762074,762074,762074,762074,null,496491,286798.02614999999,783289,null,0,0,0,0,null,783289,783289,783289,783289,783289,null,52,396.08835758835761,396.08835758835761,396.08835758835761,396.08835758835761,396.08835758835761,null,52,594.13253638253639,594.13253638253639,594.13253638253639,594.13253638253639,594.13253638253639,null,52,198.0441787941788,198.0441787941788,198.0441787941788,198.0441787941788,198.0441787941788]
[53,69727.416666666672,69727.416666666672,69727.416666666672,69727.416666666672,69727.416666666672,null,69727.416666666672,69727.416666666672,69727.416666666672,null,53,72660.916666666672,72660.916666666672,72660.916666666672,72660.916666666672,72660.916666666672,null,72660.916666666672,72660.916666666672,72660.916666666672,72660.916666666672,null,53,530364,306365,836729,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,836729,836729,836729,836729,836729,null,552677,319253.86904999998,871931,null,0,0,0,0,null,871931,871931,871931,871931,871931,null,53,434.89033264033264,434.89033264033264,434.89033264033264,434.89033264033264,434.89033264033264,null,53,652.33549896049897,652.33549896049897,652.33549896049897,652.33549896049897,652.33549896049897,null,53,217.44516632016632,217.44516632016632,217.44516632016632,217.44516632016632,217.44516632016632]
[54,78021.25,78021.25,78021.25,78021.25,78021.25,null,78021.25,78021.25,78021.25,null,54,81867.416666666672,81867.416666666672,81867.416666666672,81867.416666666672,81867.416666666672,null,81867.416666666672,81867.416666666672,81867.416666666672,81867.416666666672,null,54,593449,342806,936255,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,936255,936255,936255,936255,936255,null,622704,359704.9656,982409,null,0,0,0,0,null,982409,982409,982409,982409,982409,null,54,486.61902286902284,486.61902286902284,486.61902286902284,486.61902286902284,486.61902286902284,null,54,729.92853430353421,729.92853430353421,729.92853430353421,729.92853430353421,729.92853430353421,null,54,243.30951143451142,243.30951143451142,243.30951143451142,243.30951143451142,243.30951143451142]
[55,87990.5,87990.5,87990.5,87990.5,87990.5,null,87990.5,87990.5,87990.5,null,55,91836.75,91836.75,91836.75,91836.75,91836.75,null,91836.75,91836.75,91836.75,91836.75,null,55,669278,386608,1055886,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1055886,1055886,1055886,1055886,1055886,null,698533,403507.58744999999,1102041,null,0,0,0,0,null,1102041,1102041,1102041,1102041,1102041,null,55,548.79729729729729,548.79729729729729,548.79729729729729,548.79729729729729,548.79729729729729,null,55,823.19594594594594,823.19594594594594,823.19594594594594,823.19594594594594,823.19594594594594,null,55,274.39864864864865,274.39864864864865,274.39864864864865,274.39864864864865,274.39864864864865]
[56,99169.666666666672,99169.666666666672,99169.666666666672,99169.666666666672,99169.666666666672,null,99169.666666666672,99169.666666666672,99169.666666666672,null,56,103016.08333333333,103016.08333333333,103016.08333333333,103016.08333333333,103016.08333333333,null,103016.08333333333,103016.08333333333,103016.08333333333,103016.08333333333,null,56,754309,435727,1190036,null,null,null,null,null,null,null,null,null,null,0,0,0,0,null,1190036,1190036,1190036,1190036,1190036,null,783566,452626.89990000002,1236193,null,0,0,0,0,null,1236193,1236193,1236193,1236193,1236193,null,56,618.52182952182955,618.52182952182955,618.52182952182955,618.52182952182955,618.52182952182955,null,56,927.78274428274426,927.78274428274426,927.78274428274426,927.78274428274426,927.78274428274426,null,56,309.26091476091477,309.26091476091477,309.26091476091477,309.26091476091477,309.26091476091477]
[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,{"$f":"ROUND(Y62*valgt_regulering,0)","v":0}]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
["2006-10-01",4131.67,4204.9799999999996,4265.26,4358.1099999999997,4420,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["2007-04-01",4229.54,4303.8900000000003,4365.01,4459.17,4521.93,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Forside","index":3,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,3,14,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Lønniveau:","2024-04-01"]
[]
[]
[]
[null,null,null,"Hvad betyder det for lønnen, hvis man ændrer på lønsammensætning eller timetal ?"]

{"sheet":"Omregner","index":4,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Valgt lønniveau:",null,{"$f":"Forside!K11","v":"2024-04-01"},null,"Timetal:",37]
[]
[null,"1) Grundbeløb pr. 31-3-2000 omregnet til nutidskr. "]
[null,null,"Årligt grundbeløb:",null,11300]
[]
[null,null,null,null,"år","måned"]
[null,null,"Aktuelt beløb",null,{"$f":"ROUND(((kr_omregnes*valgt_regulering)/37*I11),0)","v":17827},{"$f":"E17/12","v":1485.5833333333333}]
[]
[]
[null,"2) Beløb der skal omregnes til '31-3-2000-niveau'"]
[null,null,"Månedligt beløb",null,1485.6]
[]
[null,null,null,null,"år","måned"]
[null,null,"Grundbeløb pr. 31-3-2000",null,{"$f":"ROUND(E21*12/valgt_regulering,0)/I11*37","v":11300},{"$f":"E24/12","v":941.66666666666663}]

{"sheet":"Omregningstabel ","index":5,"n_rows":25,"n_cols":16,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,null,null,1.362716,1.3824959999999999,1.3980790000000001,1.018559,1.040662,1.0511569999999999,1.061566,1.0834220000000001,1.0886800000000001,1.0926750000000001,1.109523,1.1200380000000001,1.1244540000000001]
[]
[]
[]
[]
[]
[null,"Indtast beløb:",1000]
[]
[]
[null,null,"1/10 '84"]
[null,null,{"$f":"Beløb","v":1000},"1/4 '98"]
[null,"1/4-98",{"$f":"Beløb*_1_4_1998","v":1362.7160000000001},{"$f":"Beløb","v":1000},"1/10 '98"]
[null,"1/10-98",{"$f":"Beløb*_1_10_1998","v":1382.4959999999999},{"$f":"Beløb/_1_4_1998*_1_10_1998","v":1014.515130078461},{"$f":"Beløb","v":1000},"1/4 '99"]
[null,"1/4-99",{"$f":"Beløb*_1_4_1999","v":1398.0790000000002},{"$f":"Beløb/_1_4_1998*_1_4_1999","v":1025.9503814441161},{"$f":"Beløb/_1_10_1998*_1_4_1999","v":1011.2716420156008},{"$f":"Beløb","v":1000}]
[null,"Grundbeløb pr. 31/3-00",{"$f":"ROUND(C14,-2)","v":1400},{"$f":"ROUND(D14,-2)","v":1000},{"$f":"ROUND(E14,-2)","v":1000},{"$f":"ROUND(F14,-2)","v":1000},"1/4 '00"]
[null,"1/4-00",{"$f":"Nyt_beløb_1*_1_4_2000","v":1425.9826},{"$f":"Nyt_beløb_2*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_3*_1_4_2000","v":1018.559},{"$f":"Nyt_beløb_4*_1_4_2000","v":1018.559},{"$f":"Beløb","v":1000},"1/4 '01"]
[null,"1/4-01",{"$f":"Nyt_beløb_1*_1_4_2001","v":1456.9268},{"$f":"Nyt_beløb_2*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_3*_1_4_2001","v":1040.662},{"$f":"Nyt_beløb_4*_1_4_2001","v":1040.662},{"$f":"beløb_4_00/_1_4_2000*_1_4_2001","v":1021.7002647858396},{"$f":"Beløb","v":1000},"1/10 '01"]
[null,"1/10-01",{"$f":"Nyt_beløb_1*_1_10_2001","v":1471.6197999999999},{"$f":"Nyt_beløb_2*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_3*_1_10_2001","v":1051.1569999999999},{"$f":"Nyt_beløb_4*_1_10_2001","v":1051.1569999999999},{"$f":"beløb_4_00/_1_4_2000*_1_10_2001","v":1032.0040370759082},{"$f":"beløb_4_01/_1_4_2001*_1_10_2001","v":1010.0849267101133},{"$f":"Beløb","v":1000},"1/4 '02"]
[null,"1/4-02",{"$f":"Nyt_beløb_1*_1_4_2002","v":1486.1923999999999},{"$f":"Nyt_beløb_2*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_3*_1_4_2002","v":1061.566},{"$f":"Nyt_beløb_4*_1_4_2002","v":1061.566},{"$f":"beløb_4_00/_1_4_2000*_1_4_2002","v":1042.2233763581687},{"$f":"beløb_4_01/_1_4_2001*_1_4_2002","v":1020.0872137158848},{"$f":"beløb_10_01/_1_10_2001*_1_4_2002","v":1009.9024218075892},{"$f":"Beløb","v":1000},"1/4 '03"]
[null,"1/4-03",{"$f":"Nyt_beløb_1*_1_4_2003","v":1516.7908000000002},{"$f":"Nyt_beløb_2*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_3*_1_4_2003","v":1083.422},{"$f":"Nyt_beløb_4*_1_4_2003","v":1083.422},{"$f":"beløb_4_00/_1_4_2000*_1_4_2003","v":1063.6811416913504},{"$f":"beløb_4_01/_1_4_2001*_1_4_2003","v":1041.0892297403002},{"$f":"beløb_10_01/_1_10_2001*_1_4_2003","v":1030.6947487387708},{"$f":"beløb_4_02/_1_4_2002*_1_4_2003","v":1020.5884514010435},{"$f":"Beløb","v":1000},"1/8 '03"]
[null,"1/8-03",{"$f":"Nyt_beløb_1*_1_8_2003","v":1524.152},{"$f":"Nyt_beløb_2*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_3*_1_8_2003","v":1088.68},{"$f":"Nyt_beløb_4*_1_8_2003","v":1088.68},{"$f":"beløb_4_00/_1_4_2000*_1_8_2003","v":1068.8433365175706},{"$f":"beløb_4_01/_1_4_2001*_1_8_2003","v":1046.1417828267008},{"$f":"beløb_10_01/_1_10_2001*_1_8_2003","v":1035.6968559406446},{"$f":"beløb_4_02/_1_4_2002*_1_8_2003","v":1025.5415113144168},{"$f":"beløb_4_03/_1_4_2003*_1_8_2003","v":1004.853141250593},{"$f":"Beløb","v":1000},"1/10 '03"]
[null,"1/10-03",{"$f":"Nyt_beløb_1*_1_10_2003","v":1529.7450000000001},{"$f":"Nyt_beløb_2*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_3*_1_10_2003","v":1092.675},{"$f":"Nyt_beløb_4*_1_10_2003","v":1092.675},{"$f":"beløb_4_00/_1_4_2000*_1_10_2003","v":1072.7655442640043},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_01/_1_4_2001*_1_10_2003","v":1049.9806853714272},{"$f":"beløb_4_02/_1_4_2002*_1_10_2003","v":1029.3048194836686},{"$f":"beløb_4_03/_1_4_2003*_1_10_2003","v":1008.5405317595545},{"$f":"beløb_8_03/_1_8_2003*_1_10_2003","v":1003.6695815115553},{"$f":"Beløb","v":1000},"1/4 '04"]
[null,"1/4 '04",{"$f":"Nyt_beløb_1*_1_4_2004","v":1553.3322000000001},{"$f":"Nyt_beløb_2*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_3*_1_4_2004","v":1109.5230000000001},{"$f":"Nyt_beløb_4*_1_4_2004","v":1109.5230000000001},{"$f":"beløb_4_00/_1_4_2000*_1_4_2004","v":1089.3065595611056},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_01/_1_4_2001*_1_4_2004","v":1066.1703800081104},{"$f":"beløb_4_02/_1_4_2002*_1_4_2004","v":1045.1757121083381},{"$f":"beløb_4_03/_1_4_2003*_1_4_2004","v":1024.091258992341},{"$f":"beløb_8_03/_1_8_2003*_1_4_2004","v":1019.1452033655436},{"$f":"beløb_10_03/_1_10_2003*_1_4_2004","v":1015.4190404283066},{"$f":"Beløb","v":1000},"1/8 '04"]
[null,"1/8 '04",{"$f":"Nyt_beløb_1*_1_8_2004","v":1568.0532000000001},{"$f":"Nyt_beløb_2*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_3*_1_8_2004","v":1120.038},{"$f":"Nyt_beløb_4*_1_8_2004","v":1120.038},{"$f":"beløb_4_00/_1_4_2000*_1_8_2004","v":1099.6299674343854},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_01/_1_4_2001*_1_8_2004","v":1076.2745252541172},{"$f":"beløb_4_02/_1_4_2002*_1_8_2004","v":1055.0808899305366},{"$f":"beløb_4_03/_1_4_2003*_1_8_2004","v":1033.7966184921481},{"$f":"beløb_8_03/_1_8_2003*_1_8_2004","v":1028.8036888709262},{"$f":"beløb_10_03/_1_10_2003*_1_8_2004","v":1025.0422129178392},{"$f":"beløb_4_04/_1_4_2004*_1_8_2004","v":1009.4770455411921},{"$f":"Beløb","v":1000},"1/10 '04"]
[null,"1/10 '04",{"$f":"Nyt_beløb_1*_1_10_2004","v":1574.2356},{"$f":"Nyt_beløb_2*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_3*_1_10_2004","v":1124.4540000000002},{"$f":"Nyt_beløb_4*_1_10_2004","v":1124.4540000000002},{"$f":"beløb_4_00/_1_4_2000*_1_10_2004","v":1103.9655042074146},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_01/_1_4_2001*_1_10_2004","v":1080.5179779794016},{"$f":"beløb_4_02/_1_4_2002*_1_10_2004","v":1059.2407820144956},{"$f":"beløb_4_03/_1_4_2003*_1_10_2004","v":1037.8725925816534},{"$f":"beløb_8_03/_1_8_2003*_1_10_2004","v":1032.8599772201198},{"$f":"beløb_10_03/_1_10_2003*_1_10_2004","v":1029.0836708078798},{"$f":"beløb_4_04/_1_4_2004*_1_10_2004","v":1013.4571342820293},{"$f":"beløb_8_04/_1_8_2004*_1_10_2004","v":1003.9427233718856},{"$f":"Beløb","v":1000}]

{"sheet":"Tillæg_trin","index":6,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,1,7]]}
[3]
[]
[null,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-04-01"}]
[]
[null,"Løngruppe",null,3]
[null,"Timer/uge",null,37]
[null,"Pensions-% inkl. evt. fritvalgs-%",null,13.89]
[null,"Særlig feriegodtgørelse, aktuel pct.",null,1.95]
[]
[null,"Stigning:","Fra","Til"]
[null,"Løntrin ",18,19]
[]
[null,"Løn",{"$f":"(VLOOKUP(til_trin,Lønark!A5:F61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE))/37*timetal*12","v":4488}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(VLOOKUP(til_trin,Lønark!L5:Q61,løngruppe+2,FALSE)-VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE))/37*timetal*pensionsstatus%*12","v":623.38319999999999}]
[null,"Ferietillæg",{"$f":"ferie_pct%*C13","v":87.516000000000005}]
[null,"Årlig bruttoudgift i alt",{"$f":"ROUND(SUM(C13:C15),0)","v":5199}]

{"sheet":"Tillæg_kr","index":7,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[9,1,9,2]]}
[2]
[]
[null,null,"Valgt lønniveau:",{"$f":"Forside!K11","v":"2024-04-01"}]
[]
[{"$f":"VLOOKUP(dummy,reg_procenter,2,FALSE)","v":{"$error":"#NAME?"}},null,"Årligt beløb, 31.3.2000 niveau ",12900]
[null,null,"Timer/uge",30]
[null,null,"Pension-% inkl. evt. fritvalgs-%",13.89]
[null,null,"Særlig feriegodtg., aktuel pct.",1.95]
[]
[]
[null,null,"bruttoudgift / år","bruttoudgift / md"]
[null,"Løn",{"$f":"kr*valgt_regulering/37*timetal","v":16501.366216216218},{"$f":"beløb/12","v":1375.1138513513515}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"beløb*pensionsstatus%","v":2292.0397674324327},{"$f":"C13/12","v":191.00331395270271}]
[null,"Ferietillæg",{"$f":"D8%*(C12)","v":321.77664121621626},{"$f":"C14/12","v":26.814720101351355}]
[null,"Bruttoudgift i alt",{"$f":"ROUND(SUM(C12:C14),0)","v":19115},{"$f":"ROUND(SUM(D12:D14),0)","v":1593}]

{"sheet":"Tid op_ned","index":8,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-04-01"}]
[]
[null,"Grundoplysninger:"]
[null,"Løngruppe",4]
[null,"Pensions-% inkl. evt. fritvalgs-%",14.29]
[null,"Særlig feriegodtgørelse, aktuel procent",1.95]
[]
[]
[null,"Lønsammensætning (trin i alt og grundbeløb i alt)","Før ændring",null,"Efter ændring"]
[]
[null,"Løndele:","I alt"]
[]
[null,"Løntrin - centralt og lokalt aftalte",19,null,19]
[]
[null,"Tillæg (grundbeløb 31.3.2000) kr./år centralt og lokalt aftalte"]
[]
[]
[null,null,"Før ændring",null,"Efter ændring",null,null,{"$f":"\"Difference\"&IF(C24>E24,\" (lønnedgang)\",\" (lønstigning)\")","v":"Difference (lønstigning)"}]
[null,"Timer/uge",30,null,37,null,null,{"$f":"-(C19-timetal_ny)","v":7}]
[]
[null,"Fast månedsløn",{"$f":"(VLOOKUP(C13,Lønark!A5:F61,$C$4+2,FALSE)+((C15)*valgt_regulering/12))/37*C19","v":22312.972972972973},null,{"$f":"(VLOOKUP(E13,Lønark!A5:F61,$C$4+2,FALSE)+((E15)*valgt_regulering/12))/37*timetal_ny","v":27519.333333333332},null,null,{"$f":"E21-C21","v":5206.3603603603588}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"(((VLOOKUP(C13,Lønark!L5:Q61,$C$4+2,FALSE)+(C15*valgt_regulering/12))/37*C19)*C5%)","v":3188.5238378378381},null,{"$f":"((VLOOKUP(E13,Lønark!L5:Q61,$C$4+2,FALSE)+(E15*valgt_regulering/12))/37*timetal_ny)*C5%","v":3932.512733333333},null,null,{"$f":"E22-C22","v":743.98889549549494}]
[null,"Ferietillæg",{"$f":"$C$6%*C21","v":435.10297297297296},null,{"$f":"$C$6%*E21","v":536.62699999999995},null,null,{"$f":"E23-C23","v":101.52402702702699}]
[null,"Månedsløn, brutto",{"$f":"SUM(C21:C23)","v":25936.599783783786},null,{"$f":"SUM(E21:E23)","v":31988.473066666666},null,null,{"$f":"E24-C24","v":6051.8732828828797}]
[]
[null,"Fast løn, år",{"$f":"C21*12","v":267755.67567567568},0,330232,null,null,{"$f":"E26-C26","v":62476.32432432432}]
[null,"Pension inkl. evt. fritvalgstillæg, år",38262.286054054057,0,47190.152799999996,null,null,{"$f":"E27-C27","v":8927.8667459459393}]
[null,"Ferietillæg, år",{"$f":"C23*12","v":5221.2356756756753},null,{"$f":"E23*12","v":6439.5239999999994},null,null,{"$f":"E28-C28","v":1218.2883243243241}]
[null,"Årsløn, brutto",{"$f":"SUM(C26:C28)","v":311239.1974054054},null,{"$f":"SUM(E26:E28)","v":383861.67679999996},null,null,{"$f":"E29-C29","v":72622.479394594557}]
[]
[null,"Timeløn",{"$f":"ROUND(VLOOKUP(C13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(C15*valgt_regulering/1924,2)","v":171.64},{"$f":"D26/timetal_ny*37/1924","v":0},{"$f":"ROUND(VLOOKUP(E13,Lønark!A5:AU61,C4+43,FALSE)/1924,2)+ROUND(E15*valgt_regulering/1924,2)","v":171.64},null,null,{"$f":"E31-C31","v":0}]

{"sheet":"Samlet_omk","index":9,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[2,"Valgt lønniveau: ",{"$f":"Forside!K11","v":"2024-04-01"}]
[]
[null,"Løngruppe",0]
[null,"Timer/uge",37]
[null,"Pensions-% inkl. evt. fritvalgs-%",14.29]
[null,"Særlig feriegodtgørelse, aktuel pct.",1.95]
[]
[null,"Løntrin ",21]
[]
[null,"Reguleret tillæg (31.3.2000) kr./år",20800]
[]
[]
[null,"Løn/time",{"$f":"IFERROR(ROUND(VLOOKUP(fra_trin,Lønark!A5:AU61,løngruppe+43,FALSE)/1924,2)+ROUND(C10*valgt_regulering/1924,2),ROUND(C10*valgt_regulering/1924,2))","v":184.29}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C13*pensionsstatus%","v":26.335041}]
[null,"Ferietillæg",{"$f":"C6%*C13","v":3.593655}]
[null,"Time bruttoudgift i alt",{"$f":"SUM(C13:C15)","v":214.21869599999999}]
[]
[null,"Løn/måned",{"$f":"IFERROR((VLOOKUP(fra_trin,Lønark!A5:F61,løngruppe+2,FALSE)+(C10*valgt_regulering/12))/37*timetal,C10*valgt_regulering/12/37*timetal)","v":29546.593333333334}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"IFERROR(((VLOOKUP(fra_trin,Lønark!L5:Q61,løngruppe+2,FALSE)+C10/12*valgt_regulering)/37*timetal)*pensionsstatus%,C10/12*valgt_regulering/37*timetal*pensionsstatus%)","v":4222.2081873333336}]
[null,"Ferietillæg",{"$f":"C6%*C18","v":576.15857000000005}]
[null,"Månedlig bruttoudgift i alt",{"$f":"SUM(C18:C20)","v":34344.960090666667}]
[]
[null,"Løn/år",{"$f":"C18*12","v":354559.12}]
[null,"Pension inkl. evt. fritvalgstillæg",{"$f":"C19*12","v":50666.498248000004}]
[null,"Ferietillæg",{"$f":"C20*12","v":6913.9028400000007}]
[null,"Årlig bruttoudgift i alt",{"$f":"SUM(C23:C25)","v":412139.52108799998}]