{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["P-alderskema","Deltid - hjælpeprogram","Beregning - pensalder v. deltid","Beregning - Periodevarighed","Tidsangivelser"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"P-alderskema","index":0,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[56,5,57,6],[54,5,55,5],[31,0,37,0],[38,11,40,11],[39,1,39,2],[39,4,39,5],[38,6,38,7],[54,0,55,0],[43,5,43,6],[43,7,43,8],[48,11,50,11],[44,8,44,10],[45,8,45,10],[44,11,46,11],[14,11,19,11],[28,11,30,11],[14,8,14,10],[0,0,0,1],[16,0,19,0],[6,4,6,6],[9,4,9,6],[1,0,1,3],[13,1,13,4],[12,1,12,10],[7,4,7,7],[10,4,10,7],[22,11,24,11],[15,8,15,10]]}
["Pensionsalderskema"]
["Til brug ved fastsættelse og tilbud om forhøjelse af pensionsalderen, jf TPL §§ 4 og 4a"]
[]
["1.",null,"2."]
[null,"Fulde navn",null,"CPR.nr. XXXXXX-XXXX (PÅKRÆVET) "]
[]
["3.",null,"4.",null,null,null,null,null,"år","mdr","dage"]
[null,"Stillingsbetegnelse",null,"Dato for ansættelse i nuværende tjenestemandsstilling, DD-MM-YYYY (PÅKRÆVET)","Pensionsalder pr. dato for tjenestemandsansættelse, inkl indregning af evt. tidligere tjenestemandspensionsalder",null,null,null,{"$f":"I56","v":0},{"$f":"J56","v":0},{"$f":"K56","v":0}]
[]
["5.",null,"6.",null,null,null,null,null,"år","mdr","dage"]
[null,"Ansættelsesmyndighed (Pensionsalderansvarlig virksomhed)",null,"Lønramme - skalatrin","Der kan - mod overførsel af udtrædelsesgodtgørelse - tilbydes tjenestemanden en forhøjet pensionsalder på ",null,null,null,{"$f":"I39","v":0},{"$f":"J39","v":0},{"$f":"K39","v":0}]
[]
[7,"Nedenfor registreres alle ansættelser forud for den nuværende tjenestemandsansættelse"]
["7 A","Forudgående offentlig ansættelse med bidragsdefineret pensionsordning"]
[null,"Ansættelsesmyndighed",null,"Stilling","Beskæftigel-\nsesgrad","Navn på pensionsinstitut, hvortil der er betalt pensionsbidrag","I perioden\n",null,"Perioden udgør ",null,null,"Hvis der er tale om deltid, anvendes hjælpeprogrammet på næste faneblad"]
[null,null,null,null,null,null,"Fra\ndd-mm-åååå","Til\ndd-mm-åååå","Tast F9 for at beregne"]
[null,null,null,null,null,null,"Dato for 1. dag\ni ansættelsen","Dato for 1. dag \nude af ansættelsen","år","mdr","dage"]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F14,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G14,'Beregning - Periodevarighed'!R11)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H14,'Beregning - Periodevarighed'!S11)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I14,'Beregning - Periodevarighed'!T11)","v":""},null,{"$f":"IF(OR(DAY(H18)=31,DAY(H18)=30,AND(MONTH(H18)=2,DAY(H18)=28),DAY(G18)=31,DAY(G18)=30,AND(MONTH(G18)=2,DAY(G18)=28)),\"Er du sikker på indtastningen? Er dette første dag i/ude af ansættelsen\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F15,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G15,'Beregning - Periodevarighed'!R12)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H15,'Beregning - Periodevarighed'!S12)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I15,'Beregning - Periodevarighed'!T12)","v":""},null,{"$f":"IF(OR(DAY(H19)=31,DAY(H19)=30,AND(MONTH(H19)=2,DAY(H19)=28),DAY(G19)=31,DAY(G19)=30,AND(MONTH(G19)=2,DAY(G19)=28)),\"Er du sikker på indtastningen? Er dette første dag i/ude af ansættelsen\",\"\")","v":""}]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F16,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G16,'Beregning - Periodevarighed'!R13)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H16,'Beregning - Periodevarighed'!S13)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I16,'Beregning - Periodevarighed'!T13)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F17,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G17,'Beregning - Periodevarighed'!R14)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H17,'Beregning - Periodevarighed'!S14)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I17,'Beregning - Periodevarighed'!T14)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F18,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G18,'Beregning - Periodevarighed'!R15)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H18,'Beregning - Periodevarighed'!S15)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I18,'Beregning - Periodevarighed'!T15)","v":""},"OBS",""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F19,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G19,'Beregning - Periodevarighed'!R16)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H19,'Beregning - Periodevarighed'!S16)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I19,'Beregning - Periodevarighed'!T16)","v":""},"Klik på fanebladet \"Deltid - hjælpeprogram\"",""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F20,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G20,'Beregning - Periodevarighed'!R17)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H20,'Beregning - Periodevarighed'!S17)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I20,'Beregning - Periodevarighed'!T17)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F21,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G21,'Beregning - Periodevarighed'!R18)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H21,'Beregning - Periodevarighed'!S18)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I21,'Beregning - Periodevarighed'!T18)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F22,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G22,'Beregning - Periodevarighed'!R19)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H22,'Beregning - Periodevarighed'!S19)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I22,'Beregning - Periodevarighed'!T19)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F23,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G23,'Beregning - Periodevarighed'!R20)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H23,'Beregning - Periodevarighed'!S20)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I23,'Beregning - Periodevarighed'!T20)","v":""},{"$f":"IF(AND('Deltid - hjælpeprogram'!D14=\"\",'Deltid - hjælpeprogram'!E14=\"\"),\"\",\"DELTID\")","v":""},""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F24,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G24,'Beregning - Periodevarighed'!R21)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H24,'Beregning - Periodevarighed'!S21)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I24,'Beregning - Periodevarighed'!T21)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F25,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G25,'Beregning - Periodevarighed'!R22)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H25,'Beregning - Periodevarighed'!S22)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I25,'Beregning - Periodevarighed'!T22)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F26,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G26,'Beregning - Periodevarighed'!R23)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H26,'Beregning - Periodevarighed'!S23)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I26,'Beregning - Periodevarighed'!T23)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F27,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G27,'Beregning - Periodevarighed'!R24)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H27,'Beregning - Periodevarighed'!S24)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I27,'Beregning - Periodevarighed'!T24)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F28,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G28,'Beregning - Periodevarighed'!R25)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H28,'Beregning - Periodevarighed'!S25)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I28,'Beregning - Periodevarighed'!T25)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F29,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G29,'Beregning - Periodevarighed'!R26)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H29,'Beregning - Periodevarighed'!S26)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I29,'Beregning - Periodevarighed'!T26)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F30,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G30,'Beregning - Periodevarighed'!R27)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H30,'Beregning - Periodevarighed'!S27)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I30,'Beregning - Periodevarighed'!T27)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F31,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G31,'Beregning - Periodevarighed'!R28)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H31,'Beregning - Periodevarighed'!S28)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I31,'Beregning - Periodevarighed'!T28)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F32,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G32,'Beregning - Periodevarighed'!R29)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H32,'Beregning - Periodevarighed'!S29)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I32,'Beregning - Periodevarighed'!T29)","v":""},null,""]
[null,null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!F33,1)","v":1},null,null,null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!G33,'Beregning - Periodevarighed'!R30)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!H33,'Beregning - Periodevarighed'!S30)","v":""},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!I33,'Beregning - Periodevarighed'!T30)","v":""},null,""]
[null,null,null,null,null,null,null,null,"år","mdr","dage"]
["7A i alt",null,null,null,null,null,"I alt: år, mdr, dage",null,{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!K13,'Beregning - Periodevarighed'!Z12)","v":0},{"$f":"IF($L$27=\"DELTID\",'Deltid - hjælpeprogram'!L13,'Beregning - Periodevarighed'!Z13)","v":0},{"$f":"IF(L27=\"DELTID\",'Deltid - hjælpeprogram'!M13,'Beregning - Periodevarighed'!Z14)","v":0},"der kan tilbydes efter TPL § 4a - mod overførsel af udtrædelsesgodtgørel\nse[r] for alle perioder"]
["7 A.1.","Pensionsinstituttet har oplyst, at den samlede udtrædelsesgodtgørelse for medlemskab i ovennævnte perioder under offentlig ansættelse, udgør",null,null,"kr.                                               opgjort pr."]
[null,null,null,null,null,"dato"]
[]
[]
["7 B","Forudgående ansættelse med tjenestemandspension"]
[null,"Ansættelsesmyndighed",null,"Stilling","Beskæftigel-sesgrad","Pensionsgiver","I perioden",null,"Perioden udgør",null,null,"Hvis der er tale om deltid, anvendes hjælpeprogrammet på næste faneblad"]
[null,null,null,null,null,null,"Fra\ndd-mm-åååå","Til\ndd-mm-åååå","Tast F9 for at beregne"]
[null,null,null,null,null,"Kommune/region - OBS Beregning af overførselsbeløb.","Dato for 1. dag\ni ansættelsen","Dato for 1. dag \nude af ansættelsen","år","mdr","dage"]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F39,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G39,'Beregning - Periodevarighed'!R32)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H39,'Beregning - Periodevarighed'!S32)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I39,'Beregning - Periodevarighed'!T32)","v":""},"OBS"]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F40,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G40,'Beregning - Periodevarighed'!R33)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H40,'Beregning - Periodevarighed'!S33)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I40,'Beregning - Periodevarighed'!T33)","v":""},"Klik på fanebladet \"Deltid - hjælpeprogram\""]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F41,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G41,'Beregning - Periodevarighed'!R34)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H41,'Beregning - Periodevarighed'!S34)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I41,'Beregning - Periodevarighed'!T34)","v":""}]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F42,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G42,'Beregning - Periodevarighed'!R35)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H42,'Beregning - Periodevarighed'!S35)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I42,'Beregning - Periodevarighed'!T35)","v":""}]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F43,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G43,'Beregning - Periodevarighed'!R36)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H43,'Beregning - Periodevarighed'!S36)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I43,'Beregning - Periodevarighed'!T36)","v":""}]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F44,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G44,'Beregning - Periodevarighed'!R37)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H44,'Beregning - Periodevarighed'!S37)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I44,'Beregning - Periodevarighed'!T37)","v":""},{"$f":"IF(AND('Deltid - hjælpeprogram'!D39=\"\",'Deltid - hjælpeprogram'!E39=\"\"),\"\",\"DELTID\")","v":""}]
[null,null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!F46,1)","v":1},null,null,null,{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!G45,'Beregning - Periodevarighed'!R38)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!H45,'Beregning - Periodevarighed'!S38)","v":""},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!I45,'Beregning - Periodevarighed'!T38)","v":""}]
["7 B i alt",null,null,null,null,"Obligatorisk medregning i pensionsalderen, jf.TPL § 4, stk.1 & 2",null,null,"år","mdr.","dage"]
[null,null,null,null,null,null,null,"I alt",{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!K37,'Beregning - Periodevarighed'!Z32)","v":0},{"$f":"IF($L$53=\"DELTID\",'Deltid - hjælpeprogram'!L37,'Beregning - Periodevarighed'!Z33)","v":0},{"$f":"IF(L53=\"DELTID\",'Deltid - hjælpeprogram'!M37,'Beregning - Periodevarighed'!Z34)","v":0}]

{"sheet":"Deltid - hjælpeprogram","index":1,"n_rows":45,"n_cols":13,"rows_kept":45,"cut":false,"hidden":false,"merged":[[10,6,10,8],[11,3,11,5],[0,1,0,7],[4,3,5,3],[4,6,4,7],[5,6,6,7],[10,1,10,2],[4,4,4,5],[10,3,10,5],[9,2,9,8],[36,3,36,5],[34,2,34,8],[35,1,35,2],[35,3,35,5],[35,6,35,8]]}
[null,"Pensionsalder optjent ved deltidsansættelse"]
[]
[null,"Indtast beskæftigelse (antal arbejdstimer pr. uge). OBS! Udfyld kun de grønne felter."]
[]
[null,"CPR",{"$f":"IF('P-alderskema'!D4=\"\",\"\",'P-alderskema'!D4)","v":""},null,"Tjenestemandsansat",null,{"$f":"'P-alderskema'!D7","v":"00:00:00"}]
[null,"Fødselsdato",{"$f":"IF(C5=\"\",\"\",DATE(MID($C$5,5,2),MID($C$5,3,2),LEFT($C$5,2)))","v":""}]
[null,"25 år",{"$f":"IF(C6=\"\",\"\",DATE(YEAR(C6)+25,MONTH(C6),DAY(C6)))","v":""}]
[]
[]
[null,"Oplysninger om ansættelse",null,null,null,null,null,null,null,null,"Samlet pensionsalder-optjening"]
[null,"Ansættelsesperioder",null,"Beskæftigelsesgrad\n",null,null,"Optjening af pensionsalder",null,null,null,"År","Md","Dag"]
[null,null,null,"Celle D14 ELLER Celle E14 skal altid være udfyldt for at arket kan beregne pensionsalder ved Deltid"]
[null,"Start","Slut","Timer pr. uge","Beskæftigelses-grad","Andel","År","Mdr","Dage",null,{"$f":"'Beregning - pensalder v. deltid'!X10","v":0},{"$f":"'Beregning - pensalder v. deltid'!X11","v":0},{"$f":"'Beregning - pensalder v. deltid'!X12","v":0}]
["Tabel 7A",{"$f":"IF('P-alderskema'!G18=\"\",\"\",'P-alderskema'!G18)","v":""},{"$f":"IF('P-alderskema'!H18=\"\",\"\",'P-alderskema'!H18)","v":""},null,null,{"$f":"IF(C14=\"\",\"\",IF(AND(D14=\"\",E14<>\"\"),ROUND(E14,4),IF(AND(E14=\"\",D14<>\"\"),ROUND(D14/37,4),IF(AND(D14<>\"\",E14<>\"\"),\"FALSK\",1))))","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!N10=0,\"\",'Beregning - pensalder v. deltid'!N10)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P10=0,\"\",'Beregning - pensalder v. deltid'!P10)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R10=0,\"\",'Beregning - pensalder v. deltid'!R10)","v":""}]
[null,{"$f":"IF('P-alderskema'!G19=\"\",\"\",'P-alderskema'!G19)","v":""},{"$f":"IF('P-alderskema'!H19=\"\",\"\",'P-alderskema'!H19)","v":""},null,null,{"$f":"IF(C15=\"\",\"\",IF(AND(D15=\"\",E15<>\"\"),ROUND(E15,4),IF(AND(E15=\"\",D15<>\"\"),ROUND(D15/37,4),IF(AND(D15<>\"\",E15<>\"\"),\"FALSK\",1))))","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!N11=0,\"\",'Beregning - pensalder v. deltid'!N11)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P11=0,\"\",'Beregning - pensalder v. deltid'!P11)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R11=0,\"\",'Beregning - pensalder v. deltid'!R11)","v":""}]
[null,{"$f":"IF('P-alderskema'!G20=\"\",\"\",'P-alderskema'!G20)","v":""},{"$f":"IF('P-alderskema'!H20=\"\",\"\",'P-alderskema'!H20)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N12=0,\"\",'Beregning - pensalder v. deltid'!N12)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P12=0,\"\",'Beregning - pensalder v. deltid'!P12)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R12=0,\"\",'Beregning - pensalder v. deltid'!R12)","v":""}]
[null,{"$f":"IF('P-alderskema'!G21=\"\",\"\",'P-alderskema'!G21)","v":""},{"$f":"IF('P-alderskema'!H21=\"\",\"\",'P-alderskema'!H21)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N13=0,\"\",'Beregning - pensalder v. deltid'!N13)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P13=0,\"\",'Beregning - pensalder v. deltid'!P13)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R13=0,\"\",'Beregning - pensalder v. deltid'!R13)","v":""}]
[null,{"$f":"IF('P-alderskema'!G22=\"\",\"\",'P-alderskema'!G22)","v":""},{"$f":"IF('P-alderskema'!H22=\"\",\"\",'P-alderskema'!H22)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N14=0,\"\",'Beregning - pensalder v. deltid'!N14)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P14=0,\"\",'Beregning - pensalder v. deltid'!P14)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R14=0,\"\",'Beregning - pensalder v. deltid'!R14)","v":""}]
[null,{"$f":"IF('P-alderskema'!G23=\"\",\"\",'P-alderskema'!G23)","v":""},{"$f":"IF('P-alderskema'!H23=\"\",\"\",'P-alderskema'!H23)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N15=0,\"\",'Beregning - pensalder v. deltid'!N15)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P15=0,\"\",'Beregning - pensalder v. deltid'!P15)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R15=0,\"\",'Beregning - pensalder v. deltid'!R15)","v":""}]
[null,{"$f":"IF('P-alderskema'!G24=\"\",\"\",'P-alderskema'!G24)","v":""},{"$f":"IF('P-alderskema'!H24=\"\",\"\",'P-alderskema'!H24)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N16=0,\"\",'Beregning - pensalder v. deltid'!N16)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P16=0,\"\",'Beregning - pensalder v. deltid'!P16)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R16=0,\"\",'Beregning - pensalder v. deltid'!R16)","v":""}]
[null,{"$f":"IF('P-alderskema'!G25=\"\",\"\",'P-alderskema'!G25)","v":""},{"$f":"IF('P-alderskema'!H25=\"\",\"\",'P-alderskema'!H25)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N17=0,\"\",'Beregning - pensalder v. deltid'!N17)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P17=0,\"\",'Beregning - pensalder v. deltid'!P17)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R17=0,\"\",'Beregning - pensalder v. deltid'!R17)","v":""}]
[null,{"$f":"IF('P-alderskema'!G26=\"\",\"\",'P-alderskema'!G26)","v":""},{"$f":"IF('P-alderskema'!H26=\"\",\"\",'P-alderskema'!H26)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N18=0,\"\",'Beregning - pensalder v. deltid'!N18)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P18=0,\"\",'Beregning - pensalder v. deltid'!P18)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R18=0,\"\",'Beregning - pensalder v. deltid'!R18)","v":""}]
[null,{"$f":"IF('P-alderskema'!G27=\"\",\"\",'P-alderskema'!G27)","v":""},{"$f":"IF('P-alderskema'!H27=\"\",\"\",'P-alderskema'!H27)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N19=0,\"\",'Beregning - pensalder v. deltid'!N19)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P19=0,\"\",'Beregning - pensalder v. deltid'!P19)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R19=0,\"\",'Beregning - pensalder v. deltid'!R19)","v":""}]
[null,{"$f":"IF('P-alderskema'!G28=\"\",\"\",'P-alderskema'!G28)","v":""},{"$f":"IF('P-alderskema'!H28=\"\",\"\",'P-alderskema'!H28)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N20=0,\"\",'Beregning - pensalder v. deltid'!N20)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P20=0,\"\",'Beregning - pensalder v. deltid'!P20)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R20=0,\"\",'Beregning - pensalder v. deltid'!R20)","v":""}]
[null,{"$f":"IF('P-alderskema'!G29=\"\",\"\",'P-alderskema'!G29)","v":""},{"$f":"IF('P-alderskema'!H29=\"\",\"\",'P-alderskema'!H29)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N21=0,\"\",'Beregning - pensalder v. deltid'!N21)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P21=0,\"\",'Beregning - pensalder v. deltid'!P21)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R21=0,\"\",'Beregning - pensalder v. deltid'!R21)","v":""}]
[null,{"$f":"IF('P-alderskema'!G30=\"\",\"\",'P-alderskema'!G30)","v":""},{"$f":"IF('P-alderskema'!H30=\"\",\"\",'P-alderskema'!H30)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N22=0,\"\",'Beregning - pensalder v. deltid'!N22)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P22=0,\"\",'Beregning - pensalder v. deltid'!P22)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R22=0,\"\",'Beregning - pensalder v. deltid'!R22)","v":""}]
[null,{"$f":"IF('P-alderskema'!G31=\"\",\"\",'P-alderskema'!G31)","v":""},{"$f":"IF('P-alderskema'!H31=\"\",\"\",'P-alderskema'!H31)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N23=0,\"\",'Beregning - pensalder v. deltid'!N23)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P23=0,\"\",'Beregning - pensalder v. deltid'!P23)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R23=0,\"\",'Beregning - pensalder v. deltid'!R23)","v":""}]
[null,{"$f":"IF('P-alderskema'!G32=\"\",\"\",'P-alderskema'!G32)","v":""},{"$f":"IF('P-alderskema'!H32=\"\",\"\",'P-alderskema'!H32)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N24=0,\"\",'Beregning - pensalder v. deltid'!N24)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P24=0,\"\",'Beregning - pensalder v. deltid'!P24)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R24=0,\"\",'Beregning - pensalder v. deltid'!R24)","v":""}]
[null,{"$f":"IF('P-alderskema'!G33=\"\",\"\",'P-alderskema'!G33)","v":""},{"$f":"IF('P-alderskema'!H33=\"\",\"\",'P-alderskema'!H33)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N25=0,\"\",'Beregning - pensalder v. deltid'!N25)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P25=0,\"\",'Beregning - pensalder v. deltid'!P25)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R25=0,\"\",'Beregning - pensalder v. deltid'!R25)","v":""}]
[null,{"$f":"IF('P-alderskema'!G34=\"\",\"\",'P-alderskema'!G34)","v":""},{"$f":"IF('P-alderskema'!H34=\"\",\"\",'P-alderskema'!H34)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N26=0,\"\",'Beregning - pensalder v. deltid'!N26)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P26=0,\"\",'Beregning - pensalder v. deltid'!P26)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R26=0,\"\",'Beregning - pensalder v. deltid'!R26)","v":""}]
[null,{"$f":"IF('P-alderskema'!G35=\"\",\"\",'P-alderskema'!G35)","v":""},{"$f":"IF('P-alderskema'!H35=\"\",\"\",'P-alderskema'!H35)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N27=0,\"\",'Beregning - pensalder v. deltid'!N27)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P27=0,\"\",'Beregning - pensalder v. deltid'!P27)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R27=0,\"\",'Beregning - pensalder v. deltid'!R27)","v":""}]
[null,{"$f":"IF('P-alderskema'!G36=\"\",\"\",'P-alderskema'!G36)","v":""},{"$f":"IF('P-alderskema'!H36=\"\",\"\",'P-alderskema'!H36)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N28=0,\"\",'Beregning - pensalder v. deltid'!N28)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P28=0,\"\",'Beregning - pensalder v. deltid'!P28)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R28=0,\"\",'Beregning - pensalder v. deltid'!R28)","v":""}]
[null,{"$f":"IF('P-alderskema'!G37=\"\",\"\",'P-alderskema'!G37)","v":""},{"$f":"IF('P-alderskema'!H37=\"\",\"\",'P-alderskema'!H37)","v":""},null,null,"",{"$f":"IF('Beregning - pensalder v. deltid'!N29=0,\"\",'Beregning - pensalder v. deltid'!N29)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!P29=0,\"\",'Beregning - pensalder v. deltid'!P29)","v":""},{"$f":"IF('Beregning - pensalder v. deltid'!R29=0,\"\",'Beregning - pensalder v. deltid'!R29)","v":""}]
[]
[null,"Oplysninger om ansættelse",null,null,null,null,null,null,null,null,"Samlet pensionsalder-optjening"]
[null,"Ansættelsesperioder",null,"Beskæftigelsesgrad\n",null,null,"Optjening af pensionsalder",null,null,null,"År","Md","Dag"]
[null,null,null,"Celle D14 ELLER Celle E14 skal altid være udfyldt for at arket kan beregne pensionsalder ved Deltid",null,null,null,null,null,null,{"$f":"'Beregning - pensalder v. deltid'!X32","v":0},{"$f":"'Beregning - pensalder v. deltid'!X33","v":0},{"$f":"'Beregning - pensalder v. deltid'!X34","v":0}]
["Tabel 7B","Start","Slut","Timer pr. uge","Beskæftigelses-grad","Andel","År","Mdr","Dage"]
[null,{"$f":"IF('P-alderskema'!G48=\"\",\"\",'P-alderskema'!G48)","v":""},{"$f":"IF('P-alderskema'!H48=\"\",\"\",'P-alderskema'!H48)","v":""}]
[null,{"$f":"IF('P-alderskema'!G49=\"\",\"\",'P-alderskema'!G49)","v":""},{"$f":"IF('P-alderskema'!H49=\"\",\"\",'P-alderskema'!H49)","v":""}]
[null,{"$f":"IF('P-alderskema'!G50=\"\",\"\",'P-alderskema'!G50)","v":""},{"$f":"IF('P-alderskema'!H50=\"\",\"\",'P-alderskema'!H50)","v":""}]
[null,{"$f":"IF('P-alderskema'!G51=\"\",\"\",'P-alderskema'!G51)","v":""},{"$f":"IF('P-alderskema'!H51=\"\",\"\",'P-alderskema'!H51)","v":""}]
[null,{"$f":"IF('P-alderskema'!G52=\"\",\"\",'P-alderskema'!G52)","v":""},{"$f":"IF('P-alderskema'!H52=\"\",\"\",'P-alderskema'!H52)","v":""}]
[null,{"$f":"IF('P-alderskema'!G53=\"\",\"\",'P-alderskema'!G53)","v":""},{"$f":"IF('P-alderskema'!H53=\"\",\"\",'P-alderskema'!H53)","v":""}]
[null,{"$f":"IF('P-alderskema'!G54=\"\",\"\",'P-alderskema'!G54)","v":""},{"$f":"IF('P-alderskema'!H54=\"\",\"\",'P-alderskema'!H54)","v":""}]

{"sheet":"Beregning - pensalder v. deltid","index":2,"n_rows":39,"n_cols":24,"rows_kept":39,"cut":false,"hidden":true,"merged":[[7,2,7,3],[7,7,7,8],[0,1,0,5],[0,7,0,20],[2,10,2,12],[3,10,3,12],[6,1,6,5],[6,13,6,17]]}
[null,"Oplysninger",null,null,null,null,null,"DELTID - I: beregning af pensionsalder (optjent anciennitet)"]
[]
[null,null,"Fødselsdato",{"$f":"'Deltid - hjælpeprogram'!C6","v":""},null,null,null,"Tjm.ansat",{"$f":"IF('P-alderskema'!$D$7=\"\",NOW(),'P-alderskema'!$D$7)","v":"2021-06-02T14:58:07.810"},null,"0 = ansat efter 1/1-12 (optjening fra ansættelsesstart)."]
[null,null,"25 år",{"$f":"IF(D3=\"\",\"\",DATE(YEAR(D3)+25,MONTH(D3),DAY(D3)))","v":""},null,null,null,"Ansat før","2012-01-01",{"$f":"IF(I3<I4,1,0)","v":0},"1 = ansat før 1/1-12 (ingen optjening før 25. år)."]
[null,null,null,null,null,null,null,"Hvis tjm ansat før 1/1-12, da optjenes der ikke anciennitet før 25. årsdagen. "]
[]
[null,"Fra indlæsningsark",null,null,null,null,null,"Beregning - hver periode angivet i år med pågældende deltidskvotient",null,null,null,null,null,"Pensionsalder - år, mdr., dage samt rest"]
[null,null,"Ansættelsesperiode",null,null,"Beskæftigelsesgrad",null,"Ansættelsesperiode"]
[null,"Fyldt 25 år (start)","Start","Slut","Fyldt 25 år (slut) ","Deltidskvotient",null,"Start","Slut","Antal dage i periode","Deltids-kvotient","Dage (deltid)",null,"År","Rest","Mdr","Rest","Dage"]
["Tabel 7A",{"$f":"IF(C10=\"\",0,IF(C10<$D$4,0,1))","v":0},{"$f":"IF('Deltid - hjælpeprogram'!B14=\"\",\"\",'Deltid - hjælpeprogram'!B14)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C14=\"\",\"\",'Deltid - hjælpeprogram'!C14)","v":""},{"$f":"IF(D10=\"\",0,IF(D10<$D$4,0,1))","v":0},{"$f":"MAX('Deltid - hjælpeprogram'!F14,0)","v":0},null,{"$f":"IF($J$4=0,C10,IF(AND(B10=0,E10=1),$D$4,IF(AND(B10=1,E10=1),C10,\"-\")))","v":""},{"$f":"IF($J$4=0,D10,IF(E10=1,D10,\"-\"))","v":""},{"$f":"IF(OR(I10=\"-\",I10=\"\"),0,DAYS360(H10,I10,TRUE))","v":0},{"$f":"F10","v":0},{"$f":"J10*K10","v":0},null,{"$f":"TRUNC(L10/360)","v":0},{"$f":"L10-N10*360","v":0},{"$f":"TRUNC(O10/30)","v":0},{"$f":"O10-P10*30","v":0},{"$f":"TRUNC(Q10)","v":0},null,"År",{"$f":"N30","v":0},null,{"$f":"U10+W11","v":0},{"$f":"W10","v":0}]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B15=\"\",\"\",'Deltid - hjælpeprogram'!B15)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C15=\"\",\"\",'Deltid - hjælpeprogram'!C15)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F15,0)","v":0},null,"","",{"$f":"IF(OR(I11=\"-\",I11=\"\"),0,DAYS360(H11,I11,TRUE))","v":0},0,{"$f":"J11*K11","v":0},null,{"$f":"TRUNC(L11/360)","v":0},{"$f":"L11-N11*360","v":0},{"$f":"TRUNC(O11/30)","v":0},{"$f":"O11-P11*30","v":0},{"$f":"TRUNC(Q11)","v":0},null,"Mdr",{"$f":"P30","v":0},{"$f":"U11+V12","v":0},{"$f":"VLOOKUP(V11,Tidsangivelser!$E$4:$G$54,3,TRUE)","v":0},{"$f":"V11-W11*12","v":0}]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B16=\"\",\"\",'Deltid - hjælpeprogram'!B16)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C16=\"\",\"\",'Deltid - hjælpeprogram'!C16)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F16,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0,null,"Dage",{"$f":"R30","v":0},{"$f":"VLOOKUP(U12,Tidsangivelser!$J$4:$L$54,3,TRUE)","v":0},null,{"$f":"U12-V12*30","v":0}]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B17=\"\",\"\",'Deltid - hjælpeprogram'!B17)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C17=\"\",\"\",'Deltid - hjælpeprogram'!C17)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F17,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B18=\"\",\"\",'Deltid - hjælpeprogram'!B18)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C18=\"\",\"\",'Deltid - hjælpeprogram'!C18)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F18,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B19=\"\",\"\",'Deltid - hjælpeprogram'!B19)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C19=\"\",\"\",'Deltid - hjælpeprogram'!C19)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F19,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B20=\"\",\"\",'Deltid - hjælpeprogram'!B20)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C20=\"\",\"\",'Deltid - hjælpeprogram'!C20)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F20,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B21=\"\",\"\",'Deltid - hjælpeprogram'!B21)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C21=\"\",\"\",'Deltid - hjælpeprogram'!C21)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F21,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B22=\"\",\"\",'Deltid - hjælpeprogram'!B22)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C22=\"\",\"\",'Deltid - hjælpeprogram'!C22)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F22,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B23=\"\",\"\",'Deltid - hjælpeprogram'!B23)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C23=\"\",\"\",'Deltid - hjælpeprogram'!C23)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F23,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B24=\"\",\"\",'Deltid - hjælpeprogram'!B24)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C24=\"\",\"\",'Deltid - hjælpeprogram'!C24)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F24,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B25=\"\",\"\",'Deltid - hjælpeprogram'!B25)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C25=\"\",\"\",'Deltid - hjælpeprogram'!C25)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F25,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B26=\"\",\"\",'Deltid - hjælpeprogram'!B26)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C26=\"\",\"\",'Deltid - hjælpeprogram'!C26)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F26,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B27=\"\",\"\",'Deltid - hjælpeprogram'!B27)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C27=\"\",\"\",'Deltid - hjælpeprogram'!C27)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F27,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B28=\"\",\"\",'Deltid - hjælpeprogram'!B28)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C28=\"\",\"\",'Deltid - hjælpeprogram'!C28)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F28,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B29=\"\",\"\",'Deltid - hjælpeprogram'!B29)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C29=\"\",\"\",'Deltid - hjælpeprogram'!C29)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F29,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,{"$f":"IF(C26=\"\",0,IF(C26<$D$4,0,1))","v":0},{"$f":"IF('Deltid - hjælpeprogram'!B30=\"\",\"\",'Deltid - hjælpeprogram'!B30)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C30=\"\",\"\",'Deltid - hjælpeprogram'!C30)","v":""},{"$f":"IF(D26=\"\",0,IF(D26<$D$4,0,1))","v":0},{"$f":"MAX('Deltid - hjælpeprogram'!F30,0)","v":0},null,{"$f":"IF($J$4=0,C26,IF(AND(B26=0,E26=1),$D$4,IF(AND(B26=1,E26=1),C26,\"-\")))","v":""},{"$f":"IF($J$4=0,D26,IF(E26=1,D26,\"-\"))","v":""},0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B31=\"\",\"\",'Deltid - hjælpeprogram'!B31)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C31=\"\",\"\",'Deltid - hjælpeprogram'!C31)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F31,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B32=\"\",\"\",'Deltid - hjælpeprogram'!B32)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C32=\"\",\"\",'Deltid - hjælpeprogram'!C32)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F32,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B33=\"\",\"\",'Deltid - hjælpeprogram'!B33)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C33=\"\",\"\",'Deltid - hjælpeprogram'!C33)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F33,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(N10:N29)","v":0},null,{"$f":"SUM(P10:P29)","v":0},null,{"$f":"SUM(R10:R29)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
["Tabel 7B",{"$f":"IF(C32=\"\",0,IF(C32<$D$4,0,1))","v":0},{"$f":"IF('Deltid - hjælpeprogram'!B39=\"\",\"\",'Deltid - hjælpeprogram'!B39)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C39=\"\",\"\",'Deltid - hjælpeprogram'!C39)","v":""},{"$f":"IF(D32=\"\",0,IF(D32<$D$4,0,1))","v":0},{"$f":"MAX('Deltid - hjælpeprogram'!F39,0)","v":0},null,{"$f":"IF($J$4=0,C32,IF(AND(B32=0,E32=1),$D$4,IF(AND(B32=1,E32=1),C32,\"-\")))","v":""},{"$f":"IF($J$4=0,D32,IF(E32=1,D32,\"-\"))","v":""},0,{"$f":"F32","v":0},0,null,{"$f":"TRUNC(L32/360)","v":0},{"$f":"L32-N32*360","v":0},{"$f":"TRUNC(O32/30)","v":0},{"$f":"O32-P32*30","v":0},{"$f":"TRUNC(Q32)","v":0},null,"År",{"$f":"N39","v":0},null,{"$f":"U32+W33","v":0},{"$f":"W32","v":0}]
[null,{"$f":"IF(C33=\"\",0,IF(C33<$D$4,0,1))","v":0},{"$f":"IF('Deltid - hjælpeprogram'!B40=\"\",\"\",'Deltid - hjælpeprogram'!B40)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C40=\"\",\"\",'Deltid - hjælpeprogram'!C40)","v":""},{"$f":"IF(D33=\"\",0,IF(D33<$D$4,0,1))","v":0},{"$f":"MAX('Deltid - hjælpeprogram'!F40,0)","v":0},null,{"$f":"IF($J$4=0,C33,IF(AND(B33=0,E33=1),$D$4,IF(AND(B33=1,E33=1),C33,\"-\")))","v":""},{"$f":"IF($J$4=0,D33,IF(E33=1,D33,\"-\"))","v":""},0,0,0,null,{"$f":"TRUNC(L33/360)","v":0},{"$f":"L33-N33*360","v":0},{"$f":"TRUNC(O33/30)","v":0},{"$f":"O33-P33*30","v":0},{"$f":"TRUNC(Q33)","v":0},null,"Mdr",{"$f":"P39","v":0},{"$f":"U33+V34","v":0},{"$f":"VLOOKUP(V33,Tidsangivelser!$E$4:$G$54,3,TRUE)","v":0},{"$f":"V33-W33*12","v":0}]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B41=\"\",\"\",'Deltid - hjælpeprogram'!B41)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C41=\"\",\"\",'Deltid - hjælpeprogram'!C41)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F41,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0,null,"Dage",{"$f":"R39","v":0},{"$f":"VLOOKUP(U34,Tidsangivelser!$J$4:$L$54,3,TRUE)","v":0},null,{"$f":"U34-V34*30","v":0}]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B42=\"\",\"\",'Deltid - hjælpeprogram'!B42)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C42=\"\",\"\",'Deltid - hjælpeprogram'!C42)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F42,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B43=\"\",\"\",'Deltid - hjælpeprogram'!B43)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C43=\"\",\"\",'Deltid - hjælpeprogram'!C43)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F43,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B44=\"\",\"\",'Deltid - hjælpeprogram'!B44)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C44=\"\",\"\",'Deltid - hjælpeprogram'!C44)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F44,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,0,{"$f":"IF('Deltid - hjælpeprogram'!B45=\"\",\"\",'Deltid - hjælpeprogram'!B45)","v":""},{"$f":"IF('Deltid - hjælpeprogram'!C45=\"\",\"\",'Deltid - hjælpeprogram'!C45)","v":""},0,{"$f":"MAX('Deltid - hjælpeprogram'!F45,0)","v":0},null,"","",0,0,0,null,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N32:N37)","v":0},null,{"$f":"SUM(P32:P37)","v":0},null,{"$f":"SUM(R32:R37)","v":0}]

{"sheet":"Beregning - Periodevarighed","index":3,"n_rows":515,"n_cols":30,"rows_kept":515,"cut":false,"hidden":true,"merged":[[7,2,7,3],[0,12,1,19],[7,11,7,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"FULDTID "]
[null,null,"CPR",{"$f":"IF('P-alderskema'!D4=\"\",\"\",'P-alderskema'!D4)","v":""}]
[null,null,"Fødselsdato",{"$f":"IF(D2=\"\",\"\",DATE(MID($D$2,5,2),MID($D$2,3,2),LEFT($D$2,2)))","v":""},null,null,null,"Tjm.ansat",{"$f":"IF('P-alderskema'!$D$7=\"\",NOW(),'P-alderskema'!$D$7)","v":"2021-06-02T14:58:07.810"},null,null,null,null,null,"År",{"$f":"SUM(L11:L34)","v":0},null,{"$f":"P3+R4","v":0},{"$f":"R3","v":0}]
[null,null,"25 år",{"$f":"IF(D3=\"\",\"\",DATE(YEAR(D3)+25,MONTH(D3),DAY(D3)))","v":""},null,null,null,"Ansat før","2012-01-01",{"$f":"IF(I3<I4,1,0)","v":0},null,null,null,null,"Mdr",{"$f":"SUM(N11:N34)","v":0},{"$f":"P4+Q5","v":0},{"$f":"VLOOKUP(Q4,Tidsangivelser!$E$4:$G$54,3,TRUE)","v":0},{"$f":"Q4-R4*12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dage",{"$f":"TRUNC(SUM(P11:P30))","v":0},{"$f":"VLOOKUP(P5,Tidsangivelser!$J$4:$L$54,3,TRUE)","v":0},null,{"$f":"P5-Q5*30","v":0}]
[]
[null,null,"Ansættelsesperioder"]
[null,null,"Fra indlæsningsark",null,null,null,null,null,null,null,null,"År, mdr og dage i hver periode"]
[]
[null,"Fyldt 25 år (start)","Start","Slut","Fyldt 25 år (slut) ",null,null,"Start","Slut","Antal dage i periode",null,"År","Rest","Mdr","Rest","Dage",null,"ÅR","Mdr","Dage"]
["Tabel 7A",{"$f":"IF(C11=\"\",0,IF(C11<$D$4,0,1))","v":0},{"$f":"IF('P-alderskema'!G18=\"\",\"\",'P-alderskema'!G18)","v":""},{"$f":"IF('P-alderskema'!H18=\"\",\"\",'P-alderskema'!H18)","v":""},{"$f":"IF(D11=\"\",0,IF(D11<$D$4,0,1))","v":0},null,null,{"$f":"IF($J$4=0,C11,IF(AND(B11=0,E11=1),$D$4,IF(AND(B11=1,E11=1),C11,\"-\")))","v":""},{"$f":"IF($J$4=0,D11,IF(E11=1,D11,\"-\"))","v":""},{"$f":"IF(OR(I11=\"-\",I11=\"\"),0,DAYS360(H11,I11,TRUE))","v":0},null,{"$f":"TRUNC(J11/360)","v":0},{"$f":"J11-L11*360","v":0},{"$f":"TRUNC(M11/30)","v":0},{"$f":"M11-N11*30","v":0},{"$f":"O11","v":0},null,{"$f":"IF(L11=0,\"\",L11)","v":""},{"$f":"IF(N11=0,\"\",N11)","v":""},{"$f":"IF(P11=0,\"\",P11)","v":""},null,"Tabel 7a"]
[null,0,{"$f":"IF('P-alderskema'!G19=\"\",\"\",'P-alderskema'!G19)","v":""},{"$f":"IF('P-alderskema'!H19=\"\",\"\",'P-alderskema'!H19)","v":""},{"$f":"IF(D12=\"\",0,IF(D12<$D$4,0,1))","v":0},null,null,{"$f":"IF($J$4=0,C12,IF(AND(B12=0,E12=1),$D$4,IF(AND(B12=1,E12=1),C12,\"-\")))","v":""},{"$f":"IF($J$4=0,D12,IF(E12=1,D12,\"-\"))","v":""},{"$f":"IF(OR(I12=\"-\",I12=\"\"),0,DAYS360(H12,I12,TRUE))","v":0},null,0,0,{"$f":"TRUNC(M12/30)","v":0},0,{"$f":"O12","v":0},null,"","",{"$f":"IF(P12=0,\"\",P12)","v":""},null,"År",{"$f":"SUM(L11:L30)","v":0},null,{"$f":"W12+Y13","v":0},{"$f":"Y12","v":0}]
[null,0,{"$f":"IF('P-alderskema'!G20=\"\",\"\",'P-alderskema'!G20)","v":""},{"$f":"IF('P-alderskema'!H20=\"\",\"\",'P-alderskema'!H20)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","","",null,"Mdr",{"$f":"SUM(N11:N30)","v":0},{"$f":"W13+X14","v":0},{"$f":"VLOOKUP(X13,Tidsangivelser!$E$4:$G$54,3,TRUE)","v":0},{"$f":"X13-Y13*12","v":0}]
[null,0,{"$f":"IF('P-alderskema'!G21=\"\",\"\",'P-alderskema'!G21)","v":""},{"$f":"IF('P-alderskema'!H21=\"\",\"\",'P-alderskema'!H21)","v":""},{"$f":"IF(D14=\"\",0,IF(D14<$D$4,0,1))","v":0},null,null,{"$f":"IF($J$4=0,C14,IF(AND(B14=0,E14=1),$D$4,IF(AND(B14=1,E14=1),C14,\"-\")))","v":""},"",0,null,0,0,0,0,0,null,"","","",null,"Dage",{"$f":"TRUNC(SUM(P11:P30))","v":0},{"$f":"VLOOKUP(W14,Tidsangivelser!$J$4:$L$54,3,TRUE)","v":0},null,{"$f":"W14-X14*30","v":0}]
[null,0,{"$f":"IF('P-alderskema'!G22=\"\",\"\",'P-alderskema'!G22)","v":""},{"$f":"IF('P-alderskema'!H22=\"\",\"\",'P-alderskema'!H22)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G23=\"\",\"\",'P-alderskema'!G23)","v":""},{"$f":"IF('P-alderskema'!H23=\"\",\"\",'P-alderskema'!H23)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G24=\"\",\"\",'P-alderskema'!G24)","v":""},{"$f":"IF('P-alderskema'!H24=\"\",\"\",'P-alderskema'!H24)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,{"$f":"IF(C18=\"\",0,IF(C18<$D$4,0,1))","v":0},{"$f":"IF('P-alderskema'!G25=\"\",\"\",'P-alderskema'!G25)","v":""},{"$f":"IF('P-alderskema'!H25=\"\",\"\",'P-alderskema'!H25)","v":""},{"$f":"IF(D18=\"\",0,IF(D18<$D$4,0,1))","v":0},null,null,{"$f":"IF($J$4=0,C18,IF(AND(B18=0,E18=1),$D$4,IF(AND(B18=1,E18=1),C18,\"-\")))","v":""},"",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G26=\"\",\"\",'P-alderskema'!G26)","v":""},{"$f":"IF('P-alderskema'!H26=\"\",\"\",'P-alderskema'!H26)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G27=\"\",\"\",'P-alderskema'!G27)","v":""},{"$f":"IF('P-alderskema'!H27=\"\",\"\",'P-alderskema'!H27)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G28=\"\",\"\",'P-alderskema'!G28)","v":""},{"$f":"IF('P-alderskema'!H28=\"\",\"\",'P-alderskema'!H28)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G29=\"\",\"\",'P-alderskema'!G29)","v":""},{"$f":"IF('P-alderskema'!H29=\"\",\"\",'P-alderskema'!H29)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G30=\"\",\"\",'P-alderskema'!G30)","v":""},{"$f":"IF('P-alderskema'!H30=\"\",\"\",'P-alderskema'!H30)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G31=\"\",\"\",'P-alderskema'!G31)","v":""},{"$f":"IF('P-alderskema'!H31=\"\",\"\",'P-alderskema'!H31)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G32=\"\",\"\",'P-alderskema'!G32)","v":""},{"$f":"IF('P-alderskema'!H32=\"\",\"\",'P-alderskema'!H32)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G33=\"\",\"\",'P-alderskema'!G33)","v":""},{"$f":"IF('P-alderskema'!H33=\"\",\"\",'P-alderskema'!H33)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G34=\"\",\"\",'P-alderskema'!G34)","v":""},{"$f":"IF('P-alderskema'!H34=\"\",\"\",'P-alderskema'!H34)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G35=\"\",\"\",'P-alderskema'!G35)","v":""},{"$f":"IF('P-alderskema'!H35=\"\",\"\",'P-alderskema'!H35)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G36=\"\",\"\",'P-alderskema'!G36)","v":""},{"$f":"IF('P-alderskema'!H36=\"\",\"\",'P-alderskema'!H36)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,{"$f":"IF(C30=\"\",0,IF(C30<$D$4,0,1))","v":0},{"$f":"IF('P-alderskema'!G37=\"\",\"\",'P-alderskema'!G37)","v":""},{"$f":"IF('P-alderskema'!H37=\"\",\"\",'P-alderskema'!H37)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 7b"]
["Tabel 7B",{"$f":"IF(C32=\"\",0,IF(C32<$D$4,0,1))","v":0},{"$f":"IF('P-alderskema'!G48=\"\",\"\",'P-alderskema'!G48)","v":""},{"$f":"IF('P-alderskema'!H48=\"\",\"\",'P-alderskema'!H48)","v":""},{"$f":"IF(D32=\"\",0,IF(D32<$D$4,0,1))","v":0},null,null,{"$f":"IF($J$4=0,C32,IF(AND(B32=0,E32=1),$D$4,IF(AND(B32=1,E32=1),C32,\"-\")))","v":""},{"$f":"IF($J$4=0,D32,IF(E32=1,D32,\"-\"))","v":""},{"$f":"IF(OR(I32=\"-\",I32=\"\"),0,DAYS360(H32,I32,TRUE))","v":0},null,{"$f":"TRUNC(J32/360)","v":0},{"$f":"J32-L32*360","v":0},{"$f":"TRUNC(M32/30)","v":0},{"$f":"M32-N32*30","v":0},0,null,{"$f":"IF(L32=0,\"\",L32)","v":""},{"$f":"IF(N32=0,\"\",N32)","v":""},"",null,"År",{"$f":"SUM(L32:L37)","v":0},null,{"$f":"W32+Y33","v":0},{"$f":"Y32","v":0}]
[null,{"$f":"IF(C33=\"\",0,IF(C33<$D$4,0,1))","v":0},{"$f":"IF('P-alderskema'!G49=\"\",\"\",'P-alderskema'!G49)","v":""},{"$f":"IF('P-alderskema'!H49=\"\",\"\",'P-alderskema'!H49)","v":""},{"$f":"IF(D33=\"\",0,IF(D33<$D$4,0,1))","v":0},null,null,{"$f":"IF($J$4=0,C33,IF(AND(B33=0,E33=1),$D$4,IF(AND(B33=1,E33=1),C33,\"-\")))","v":""},{"$f":"IF($J$4=0,D33,IF(E33=1,D33,\"-\"))","v":""},{"$f":"IF(OR(I33=\"-\",I33=\"\"),0,DAYS360(H33,I33,TRUE))","v":0},null,{"$f":"TRUNC(J33/360)","v":0},{"$f":"J33-L33*360","v":0},{"$f":"TRUNC(M33/30)","v":0},{"$f":"M33-N33*30","v":0},0,null,{"$f":"IF(L33=0,\"\",L33)","v":""},{"$f":"IF(N33=0,\"\",N33)","v":""},{"$f":"IF(P33=0,\"\",P33)","v":""},null,"Mdr",{"$f":"SUM(N32:N37)","v":0},{"$f":"W33+X34","v":0},{"$f":"VLOOKUP(X33,Tidsangivelser!$E$4:$G$54,3,TRUE)","v":0},{"$f":"X33-Y33*12","v":0}]
[null,0,{"$f":"IF('P-alderskema'!G50=\"\",\"\",'P-alderskema'!G50)","v":""},{"$f":"IF('P-alderskema'!H50=\"\",\"\",'P-alderskema'!H50)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","","",null,"Dage",{"$f":"FLOOR(SUM(P32:P37),1)","v":0},{"$f":"VLOOKUP(W34,Tidsangivelser!$J$4:$L$54,3,TRUE)","v":0},null,{"$f":"W34-X34*30","v":0}]
[null,0,{"$f":"IF('P-alderskema'!G51=\"\",\"\",'P-alderskema'!G51)","v":""},{"$f":"IF('P-alderskema'!H51=\"\",\"\",'P-alderskema'!H51)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G52=\"\",\"\",'P-alderskema'!G52)","v":""},{"$f":"IF('P-alderskema'!H52=\"\",\"\",'P-alderskema'!H52)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G53=\"\",\"\",'P-alderskema'!G53)","v":""},{"$f":"IF('P-alderskema'!H53=\"\",\"\",'P-alderskema'!H53)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,0,{"$f":"IF('P-alderskema'!G54=\"\",\"\",'P-alderskema'!G54)","v":""},{"$f":"IF('P-alderskema'!H54=\"\",\"\",'P-alderskema'!H54)","v":""},0,null,null,"","",0,null,0,0,0,0,0,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C39=\"\",\"\",DAYS360(C39,D39,TRUE)+1)","v":""},{"$f":"IF(L39=\"\",\"\",L39/12/30)","v":""}]
[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,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,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,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,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,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,"",{"$f":"IF(L57=\"\",\"\",L57/12/30)","v":""}]
[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,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,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,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,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,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,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,"",{"$f":"IF(L89=\"\",\"\",L89/12/30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(L90=\"\",\"\",L90/12/30)","v":""}]
[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,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,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,{"$f":"IF(C103=\"\",\"\",DAYS360(C103,D103,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,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,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,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,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,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,"",{"$f":"IF(L154=\"\",\"\",L154/12/30)","v":""}]
[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,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,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,{"$f":"IF(C167=\"\",\"\",DAYS360(C167,D167,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,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,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,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,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,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,"",{"$f":"IF(L218=\"\",\"\",L218/12/30)","v":""}]
[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,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,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,{"$f":"IF(C231=\"\",\"\",DAYS360(C231,D231,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,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,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,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,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,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,"",{"$f":"IF(L282=\"\",\"\",L282/12/30)","v":""}]
[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,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,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,{"$f":"IF(C295=\"\",\"\",DAYS360(C295,D295,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,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,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,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,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,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,"",{"$f":"IF(L346=\"\",\"\",L346/12/30)","v":""}]
[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,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,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,{"$f":"IF(C359=\"\",\"\",DAYS360(C359,D359,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,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,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,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,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,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,"",{"$f":"IF(L410=\"\",\"\",L410/12/30)","v":""}]
[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,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,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,{"$f":"IF(C423=\"\",\"\",DAYS360(C423,D423,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,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,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,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,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,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,"",{"$f":"IF(L474=\"\",\"\",L474/12/30)","v":""}]
[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,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,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,{"$f":"IF(C487=\"\",\"\",DAYS360(C487,D487,TRUE)+1)","v":""},""]
[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,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,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,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,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,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,"",""]

{"sheet":"Tidsangivelser","index":4,"n_rows":54,"n_cols":26,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,3,0,6],[0,8,0,11],[1,0,1,1],[1,3,1,6],[1,8,1,11]]}
[null,null,null,"Omregning af måneder til år",null,null,null,null,"Omregning af dage til måneder ",null,null,null,null,null,null,null,null,"Fra \"Jubilæumsberegner\" "]
["Omregning af deltidsangivelser",null,null,"12 md., hver med 30 dage, dvs. 12 md = 1 år = 360 dage",null,null,null,null,"Antager at der er 30 dage i hver måned, dvs. 30 dage = 1 md"]
[{"$f":"1/1","v":1},"på fuldtid",null,null,"Start md.","Slut md.","Antal tillægsår",null,null,"Start dag","Slut dag","Antal tillægsmåneder",null,null,null,null,null,"Måned","Startdato","Slutdato","Antal dage","DAGE360","Vægt pr. dag i periode","ikke skudår","skudår","Periode kun 1 dag"]
[{"$f":"1/2","v":0.5},"på 1/2-tid",null,0,{"$f":"D4*12","v":0},{"$f":"(D4+1)*12-1","v":11},0,null,0,{"$f":"I4*30","v":0},{"$f":"(I4+1)*30-1","v":29},0,null,null,null,null,null,1,1,30,30,{"$f":"DAYS360(S4,T4)","v":29},{"$f":"1","v":1},1,1,1]
[{"$f":"1/3","v":0.33333333333333331},"på 1/3-tid",null,1,{"$f":"D5*12","v":12},{"$f":"(D5+1)*12-1","v":23},1,null,1,{"$f":"I5*30","v":30},{"$f":"(I5+1)*30-1","v":59},1,null,null,null,null,null,1,31,31,0,{"$f":"DAYS360(S5,T5)","v":0},0,1,1,0]
[{"$f":"1/4","v":0.25},"på 1/4-tid",null,2,24,35,2,null,2,60,89,2,null,null,null,null,null,1,31,31,1,null,1,1,1,1]
[{"$f":"3/4","v":0.75},"på 3/4-tid",null,3,36,47,3,null,3,90,119,3,null,null,null,null,null,2,1,27,27,{"$f":"DAYS360(S7,T7)","v":26},1,1,0,1]
[{"$f":"1/5","v":0.2},"på 1/5-tid",null,4,48,59,4,null,4,120,149,4,null,null,null,null,null,2,28,28,3,{"$f":"DAYS360(S8,T8)","v":0},3,1,0,1]
[{"$f":"2/5","v":0.4},"på 2/5-tid",null,5,60,71,5,null,5,150,179,5,null,null,null,null,null,2,1,28,28,{"$f":"DAYS360(S9,T9)","v":27},1,0,1,1]
[{"$f":"3/5","v":0.6},"på 3/5-tid",null,6,72,83,6,null,6,180,209,6,null,null,null,null,null,2,29,29,2,{"$f":"DAYS360(S10,T10)","v":0},2,0,1,1]
[{"$f":"4/5","v":0.8},"på 4/5-tid",null,7,84,95,7,null,7,210,239,7,null,null,null,null,null,3,1,30,30,{"$f":"DAYS360(S11,T11)","v":29},1,1,1,1]
[null,null,null,8,96,107,8,null,8,240,269,8,null,null,null,null,null,3,31,31,0,0,0,1,1,0]
[null,null,null,9,108,119,9,null,9,270,299,9,null,null,null,null,null,3,31,31,1,0,1,1,1,1]
[null,null,null,10,120,131,10,null,10,300,329,10,null,null,null,null,null,4,1,30,30,29,1,1,1,1]
[null,null,null,11,132,143,11,null,11,330,359,11,null,null,null,null,null,5,1,30,30,29,1,1,1,1]
[null,null,null,12,144,155,12,null,12,360,389,12,null,null,null,null,null,5,31,31,0,0,0,1,1,0]
[null,null,null,13,156,167,13,null,13,390,419,13,null,null,null,null,null,5,31,31,1,0,1,1,1,1]
[null,null,null,14,168,179,14,null,14,420,449,14,null,null,null,null,null,6,1,30,30,29,1,1,1,1]
[null,null,null,15,180,191,15,null,15,450,479,15,null,null,null,null,null,7,1,30,30,29,1,1,1,1]
[null,null,null,16,192,203,16,null,16,480,509,16,null,null,null,null,null,7,31,31,0,0,0,1,1,0]
[null,null,null,17,204,215,17,null,17,510,539,17,null,null,null,null,null,7,31,31,1,0,1,1,1,1]
[null,null,null,18,216,227,18,null,18,540,569,18,null,null,null,null,null,8,1,30,30,29,1,1,1,1]
[null,null,null,19,228,239,19,null,19,570,599,19,null,null,null,null,null,8,31,31,0,0,0,1,1,0]
[null,null,null,20,240,251,20,null,20,600,629,20,null,null,null,null,null,8,31,31,1,0,1,1,1,1]
[null,null,null,21,252,263,21,null,21,630,659,21,null,null,null,null,null,9,1,30,30,29,1,1,1,1]
[null,null,null,22,264,275,22,null,22,660,689,22,null,null,null,null,null,10,1,30,30,29,1,1,1,1]
[null,null,null,23,276,287,23,null,23,690,719,23,null,null,null,null,null,10,31,31,0,0,0,1,1,0]
[null,null,null,24,288,299,24,null,24,720,749,24,null,null,null,null,null,10,31,31,1,0,1,1,1,1]
[null,null,null,25,300,311,25,null,25,750,779,25,null,null,null,null,null,11,1,30,30,29,1,1,1,1]
[null,null,null,26,312,323,26,null,26,780,809,26,null,null,null,null,null,12,1,30,30,29,1,1,1,1]
[null,null,null,27,324,335,27,null,27,810,839,27,null,null,null,null,null,12,31,31,0,0,0,1,1,0]
[null,null,null,28,336,347,28,null,28,840,869,28,null,null,null,null,null,12,31,31,1,0,1,1,1,1]
[null,null,null,29,348,359,29,null,29,870,899,29]
[null,null,null,30,360,371,30,null,30,900,929,30]
[null,null,null,31,372,383,31,null,31,930,959,31]
[null,null,null,32,384,395,32,null,32,960,989,32]
[null,null,null,33,396,407,33,null,33,990,1019,33]
[null,null,null,34,408,419,34,null,34,1020,1049,34]
[null,null,null,35,420,431,35,null,35,1050,1079,35]
[null,null,null,36,432,443,36,null,36,1080,1109,36]
[null,null,null,37,444,455,37,null,37,1110,1139,37]
[null,null,null,38,456,467,38,null,38,1140,1169,38]
[null,null,null,39,468,479,39,null,39,1170,1199,39]
[null,null,null,40,480,491,40,null,40,1200,1229,40]
[null,null,null,41,492,503,41,null,41,1230,1259,41]
[null,null,null,42,504,515,42,null,42,1260,1289,42]
[null,null,null,43,516,527,43,null,43,1290,1319,43]
[null,null,null,44,528,539,44,null,44,1320,1349,44]
[null,null,null,45,540,551,45,null,45,1350,1379,45]
[null,null,null,46,552,563,46,null,46,1380,1409,46]
[null,null,null,47,564,575,47,null,47,1410,1439,47]
[null,null,null,48,576,587,48,null,48,1440,1469,48]
[null,null,null,49,588,599,49,null,49,1470,1499,49]
[null,null,null,50,600,611,50,null,50,1500,1529,50]