{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Formler","Guide til brug","Helligdagsberegning","Oktober","November","December","Januar","Februar","Marts","April","Maj","Juni","Juli","August","September"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Formler","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Ansættelsesbrøk på denne timeseddel",7]
["Aktuelt timetal pr. uge",{"$f":"B1*5","v":35}]
[null,null,"Ændringer i timetal, kun ændring af ansættelsesbrøk i felt B1"]
[null,null,"Ved ændringer af formler markér med note eller andet så det er synligt hvor der mangler."]
["Månedsløn 1/10-19"]
["Månedsløn 1/4-2020",null,null,null,null,null,"OBS Skabelon lægger fortsat 2,08 til feriesaldo hver måned"]
["Aktuel timeløn",{"$f":"B5/(B2*B16)","v":0}]
[]
["Aftenstillæg pr. time (17-23)",28.14,null,null,null,null,"Ændring af månedsløn, stillingstillæg,"]
["Lørdagstillæg pr. time (11-23)",33.409999999999997,null,null,null,null," funktionstillæg, kvalifikationstillæg og grundtillæg"]
["Uniformsgodtgørelse pr. timetal på måned",1.84,"Grundløb pr. 31/3-2000 = 2550",null,null,null,"Åbn det månedsark som skal tilrettes."]
["Kostfradrag",null,null,null,null,null,"Ret feltet i den aktuelle måned. De efterfølgende ark vil bruge den nye værdi."]
[" - 31 timer og over",300,null,null,null,null,"Tilføjfe note om ændring"]
[" - Mellem 21 og 30 timer",225]
[" - 20 timer og under",150]
["Timefaktor",4.3332432430000001,null,null,null,null,"Ændring af kostfradrag ved ferie fri osv."]
["Helligdag/feriefri/omsorgsdag/seniordag"]
[" - 37 timer",7.4,null,null,null,null,"Ændring af helligdags/ferie værdier. Evt. synligt felt med tallet og regnestykket bag."]
[" - 32 timer",6.4,null,null,null,null,"Guide til Syg"]
[" - 30 timer",6,null,null,null,null,"AFS nat, Oppe"]
[" - 25 timer",5]
["Timetal pr. uge",null,null,null,null,null,"Feriesaldo"]
["37 timer",160.33000000000001,null,null,null,null,"Indsæt nuværende saldo i ark Oktober (eller anden måned)"]
["32 timer",138.66]
["30 timer",129.99]
["25 timer",108.33]
["20 timer",86.66]
["Sundhedsforsikring",45.39]
["Fradrag gavekasse",50]

{"sheet":"Guide til brug","index":1,"n_rows":29,"n_cols":23,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["Vi har forsøgt at lave en brugsvejledning til de ny timesedler. Den står nedenunder."]
["Hvis i ikke kan finde svaret på jeres spørgsmål, eller ikke forstår hvor tallene kommer må i gerne tage fat i Gitte Bak eller Andreas."]
[]
[]
[]
["Størstedelen af felterne er låst, så i kun kan tilføje data i de relevante felter."]
[]
["I felterne  Mødt og Gået angives klokkeslæt. "]
["Fordi excel er meget firkantet kan man ikke bare indtaste 08 og 16."]
["I stedet skal der indtastes 08:00 og 16:00 - husk kolon :"]
["Derefter beregner arket selv diverse tillæg, saldoer, timetal osv.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rettelser d. 24/9-19",null,null,null,null,null,null,null,"Mangler:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Absolutte referencer i kol J, September!S1",null,null,null,null,null,null,null,"Mangler rettelse i Feriesaldo."]
["Når socialfagligtpersonale har aftenvagt og derfor sover i huset, skal dette angives ved at skrive \"ja\" i kolonne I, AFS nat. (Kolonne M)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kolonner Timer, Helligdag, Aften, Lørdag til kolonnebredde 5",null,null,null,null,null,null,null,"Vejledning til brug af de forskellige felter"]
["Hvis man i løbet af natten står op, angives dette i kolonne N, Oppe. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Kolonner AFS Nat, oppe kolonnebredde 4",null,null,null,null,null,null,null,"Forklaring på aften fra saldo"]
["Hvis man har været oppe én gang, skrives 1. Læg derefter til for hver begyndte time.",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rettelser d. 25/9-19"]
["Hvis man er syg, angives hvor mange timer man skulle have været på arbejde.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rettelser i dato, måned, år"]
["Ved kursus gives det antal timer kurset har taget.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Timetal d.m. medtager ikke længere søndags og helligdagstimer. Begge flyttet til rigtige felt. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kolonnebredde på L, så timer i alt vises korrekt i bunden af arket."]
["Ved ferie/fri dage og omsorgs, eller seniordage angives ansættelsesbrøkken, som er timetal man er ansæt til om ugen, divideret med 5."]
["Hvis man er ansat 37 t/u er ansættelsesbrøkken 37/5= 7,4",null,null,null,null,null,null,null,null,null,null,null,null,null,"Retterlser d. 30-09-2019"]
["For 35 timer: 35/5 = 7",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sætter selv 5 ferie/fridage på saldo i Maj."]
["For 32 timer: 32/5= 6,4",null,null,null,null,null,null,null,null,null,null,null,null,null,"Feriesaldo - fungerer som  ferie/fri, oms. Osv. ift. brug. Lægger selv 2,08 til pr. måned."]
["For 30 timer: 30/5 = 6"]
["For 25 timer: 25/5 = 5",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rettelser d. 15-10-2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AFS nat i Oktober rettet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kost i September rettet"]
["Ekstra timer benyttes hovedsagligt af service og køkkengruppen og bostøtte.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferie saldo rette så ikke +2,08."]

{"sheet":"Helligdagsberegning","index":2,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
["Årstal",2020,null,"Type",null,null,null,"X","Årstal",{"$f":"B1","v":2020}]
["Nytårsdag",{"$f":"DATE(B1,1,1)","v":"2020-01-01"},null,"Fast",null,null,null,"A","Rest",{"$f":"MOD(År,19)","v":6}]
["Skærtorsdag",{"$f":"L22","v":"2020-04-09"},null,"Beregnet",null,null,null,"B","Heltal",{"$f":"INT(År/100)","v":20}]
["Langfredag",{"$f":"L23","v":"2020-04-10"},null,"Beregnet",null,null,null,"C","Rest",{"$f":"MOD(År,100)","v":20}]
["Påskedag",{"$f":"L24","v":"2020-04-12"},null,"Beregnet",null,null,null,"D","Heltal",{"$f":"INT(J3/4)","v":5}]
["2. påskedag",{"$f":"L25","v":"2020-04-13"},null,"Beregnet",null,null,null,"E","Rest",{"$f":"MOD(J3,4)","v":0}]
["Store Bededag",{"$f":"L29","v":"2020-05-08"},null,"Beregnet",null,null,null,"F","Heltal",{"$f":"INT((J3+8)/25)","v":1}]
["Kristi Himmelfart",{"$f":"L32","v":"2020-05-21"},null,"Beregnet",null,null,null,"G","Heltal",{"$f":"INT((J3-J7+1)/3)","v":6}]
["Pinsedag",{"$f":"L34","v":"2020-05-31"},null,"Beregnet",null,null,null,"H","Heltal",{"$f":"MOD(19*J2+J3-J5-J8+15,30)","v":18}]
["2. pinsedag",{"$f":"L35","v":"2020-06-01"},null,"Beregnet",null,null,null,"J","Heltal",{"$f":"INT(J4/4)","v":5}]
["Grundlovsdag",{"$f":"DATE(B1,6,5)","v":"2020-06-05"},null,"Fast",null,null,null,"K","Rest",{"$f":"MOD(J4,4)","v":0}]
["Juleaften",{"$f":"DATE(B1,12,24)","v":"2020-12-24"},null,"Fast",null,null,null,"L","Rest",{"$f":"MOD(32+2*J6+2*J10-J9-J11,7)","v":3}]
["1. juledag",{"$f":"B12+1","v":"2020-12-25"},null,"Fast",null,null,null,"M","Heltal",{"$f":"INT((J2+11*J9+22*J12)/451)","v":0}]
["2. juledag",{"$f":"B12+2","v":"2020-12-26"},null,"Fast",null,null,null,"N","Heltal",{"$f":"INT((J9+J12-7*J13+114)/31)","v":4}]
["Nytårsaftens dag",{"$f":"DATE(B1,12,31)","v":"2020-12-31"},null,"Fast",null,null,null,"P","Rest",{"$f":"MOD(J9+J12-7*J13+114,31)","v":11}]
["1. Maj",{"$f":"DATE(B1,5,1)","v":"2020-05-01"},null,"Fast",null,null,null,"Q","Formel",{"$f":"(J14-3)*31+J15-20","v":22}]
[]
[null,null,null,null,null,null,null,null,"Dag",{"$f":"J15+1","v":12}]
[null,null,null,null,null,null,null,null,"Måned",{"$f":"J14","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mellemregning",null,"Diff ift Påskesøndag"]
[null,null,null,null,null,null,null,null,"Skærtorsdag",null,{"$f":"K24-3","v":"2020-04-09"},{"$f":"L24-3","v":"2020-04-09"},-3]
[null,null,null,null,null,null,null,null,"Langfredag",null,{"$f":"K24-2","v":"2020-04-10"},{"$f":"L24-2","v":"2020-04-10"},-2]
[null,null,null,null,null,null,null,null,"Påskedag",null,{"$f":"DATE(År,J19,J18)","v":"2020-04-12"},{"$f":"DATE(År,J19,J18)","v":"2020-04-12"}]
[null,null,null,null,null,null,null,null,"2. påskedag",null,{"$f":"K24+1","v":"2020-04-13"},{"$f":"L24+1","v":"2020-04-13"},1]
[null,null,null,null,null,null,null,null,"1. s.e. påske",null,{"$f":"K24+7","v":"2020-04-19"}]
[null,null,null,null,null,null,null,null,"2. s.e. påske",null,{"$f":"K26+7","v":"2020-04-26"}]
[null,null,null,null,null,null,null,null,"3. s.e. påske",null,{"$f":"K27+7","v":"2020-05-03"}]
[null,null,null,null,null,null,null,null,"Store Bededag",null,{"$f":"K28+5","v":"2020-05-08"},{"$f":"L24+26","v":"2020-05-08"},26]
[null,null,null,null,null,null,null,null,"4. s.e. påske",null,{"$f":"K28+7","v":"2020-05-10"}]
[null,null,null,null,null,null,null,null,"5. s.e. påske",null,{"$f":"K30+7","v":"2020-05-17"}]
[null,null,null,null,null,null,null,null,"Kristi Himmelfart",null,{"$f":"K31+4","v":"2020-05-21"},{"$f":"L24+39","v":"2020-05-21"},39]
[null,null,null,null,null,null,null,null,"6.s.e. påske",null,{"$f":"K31+7","v":"2020-05-24"}]
[null,null,null,null,null,null,null,null,"Pinsedag",null,{"$f":"K33+7","v":"2020-05-31"},{"$f":"L24+49","v":"2020-05-31"},49]
[null,null,null,null,null,null,null,null,"2. pinsedag",null,{"$f":"K34+1","v":"2020-06-01"},{"$f":"L24+50","v":"2020-06-01"},50]

{"sheet":"Oktober","index":3,"n_rows":43,"n_cols":26,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,6,41,7],[39,12,39,14],[39,15,39,17],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[32,0,33,0],[32,1,33,1],[22,0,23,0],[22,1,23,1],[30,0,31,0],[30,1,31,1],[20,0,21,0],[20,1,21,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:",null,null,"17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:","Poul Prøvesen",null,null,null,null,null,null,null,"Måned:",null,"Oktober",null,null,"År:",2019]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",99000,null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2019-10-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$U$1,HOUR(F6-$U$1)+MINUTE(F6-$U$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$X$1,(HOUR(F6-$X$1)+MINUTE(F6-$X$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",10,null,"2019-10-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$U$1,HOUR(F7-$U$1)+MINUTE(F7-$U$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$X$1,(HOUR(F7-$X$1)+MINUTE(F7-$X$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=7,IF(E7>0,(HOUR(F7-E7)+MINUTE(F7-E7)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2019-10-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",10,null,"2019-10-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",10,null,"2019-10-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," ",{"$f":"IF(WEEKDAY(D11,2)=7,IF(E11>0,(HOUR(F11-E11)+MINUTE(F11-E11)/60)/2,\" \"),\" \")","v":" "}," "]
[null,null,null,"2019-10-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"Guide til Ferie, Ferie/fridage, Senior, omsorgsdage."]
["Grundtillæg",10,null,"2019-10-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"Guide til Syg"]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2019-10-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"AFS nat, Oppe"]
[null,null,null,"2019-10-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2019-10-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"Fradragsfelt, kørsel, multimedie, bagvagt og ekstra timer",null,","]
[null,null,null,"2019-10-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2019-10-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2019-10-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2019-10-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Formler!B28","v":45.39},null,"2019-10-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2019-10-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2019-10-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Formler!B29","v":50},null,"2019-10-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2019-10-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2019-10-30",null,null,{"$f":"(IF(AND(E35>0,F35>0),HOUR(F35-E35)+MINUTE(F35-E35)/60,\" \"))","v":" "},{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-10-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,{"$f":"SUM(N6:N36)","v":0},0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},{"$f":"SUM(T6:T36)","v":0}]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Formler!B2*Formler!B16","v":151.663513505},null,null,null,null,"Ugentligt timetal:","Ugentligt timetam",37,"Søgnehellig beregning",{"$f":"37/5","v":7.4}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,1.57,null,null,null,null,"Skiftes til hvid samt låses"]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-150.093513505}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,10,"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,5,"Ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,2,"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"November","index":4,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,12,39,14],[39,15,39,17],[41,6,41,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Oktober!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"November",null,null,"År:",2019]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Oktober!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2019-11-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Oktober!B7","v":10},null,"2019-11-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2019-11-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null,{"$f":"IF(F8>$S$1,HOUR(F8-$S$1)+MINUTE(F8-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D8,2)=6,IF(F8>$V$1,(HOUR(F8-$V$1)+MINUTE(F8-$V$1)/60),\" \"),\" \")","v":" "}," "," "]
["Funktionstillæg",{"$f":"Oktober!B9","v":10},null,"2019-11-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null,{"$f":"IF(F9>$S$1,HOUR(F9-$S$1)+MINUTE(F9-$S$1)/60,\" \")","v":" "}," "," "," "]
[null,null,null,"2019-11-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null,{"$f":"IF(F10>$S$1,HOUR(F10-$S$1)+MINUTE(F10-$S$1)/60,\" \")","v":" "}," "," "," "]
["Kvallifikationstillæg",{"$f":"Oktober!B11","v":10},null,"2019-11-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Oktober!B13","v":10},null,"2019-11-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2019-11-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2019-11-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2019-11-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2019-11-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2019-11-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Oktober!B25","v":45.39},null,"2019-11-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,{"$f":"IF(D27=X21,\"ja\",\" \")","v":" "},"2019-11-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2019-11-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Oktober!B31","v":50},null,"2019-11-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2019-11-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-11-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2019-11-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,{"$f":"SUM(Q6:Q36)","v":0},{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Oktober!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Oktober!P40","v":-150.093513505}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Oktober!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-301.75702701}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Oktober!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,{"$f":"Oktober!S42","v":5},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Oktober!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"December","index":5,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,12,39,14],[39,15,39,17],[41,6,41,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"November!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"December",null,null,"År:",2019]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"November!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2019-12-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"November!B7","v":10},null,"2019-12-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2019-12-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null,{"$f":"IF(F8>$S$1,HOUR(F8-$S$1)+MINUTE(F8-$S$1)/60,\" \")","v":" "}," "," "," "]
["Funktionstillæg",{"$f":"November!B9","v":10},null,"2019-12-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"November!B11","v":10},null,"2019-12-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"November!B13","v":10},null,"2019-12-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2019-12-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2019-12-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2019-12-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2019-12-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2019-12-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"November!B25","v":45.39},null,"2019-12-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2019-12-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},"ja","2019-12-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,"ja","2019-12-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":7},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"November!B31","v":50},"ja","2019-12-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,null,"2019-12-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2019-12-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2019-12-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2019-12-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,"ja","2019-12-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":28},{"$f":"SUM(I6:I36)","v":0},{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"November!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"November!P40","v":-301.75702701}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+November!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-425.42054051499997}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"November!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":28},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":28},"Ferie/frisaldo i dage",null,null,null,{"$f":"November!S42","v":5},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"November!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"Januar","index":6,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,6,39,7],[40,6,40,7],[39,12,39,14],[39,15,39,17],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[37,6,37,7],[38,6,38,7],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"December!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"Januar",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"December!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,"ja","2020-01-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":7},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"December!B7","v":10},null,"2020-01-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-01-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"December!B9","v":10},null,"2020-01-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"December!B11","v":10},null,"2020-01-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"December!B13","v":10},null,"2020-01-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-01-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-01-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-01-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-01-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-01-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"December!B25","v":45.39},null,"2020-01-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,{"$f":"IF(D27=X21,\"ja\",\" \")","v":" "},"2020-01-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-01-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"December!B31","v":50},null,"2020-01-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-01-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-01-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-01-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":7},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"December!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"December!P40","v":-425.42054051499997}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+December!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-570.08405401999994}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"December!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":7},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":7},"Ferie/frisaldo i dage",null,null,null,{"$f":"December!S42","v":5},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"December!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"Februar","index":7,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,12,39,14],[39,15,39,17],[41,6,41,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Januar!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"Februar",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Januar!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2020-02-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Januar!B7","v":10},null,"2020-02-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-02-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"Januar!B9","v":10},null,"2020-02-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"Januar!B11","v":10},null,"2020-02-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Januar!B13","v":10},null,"2020-02-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-02-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-02-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-02-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-02-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-02-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Januar!B25","v":45.39},null,"2020-02-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2020-02-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-02-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Januar!B31","v":50},null,"2020-02-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-02-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-02-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,null,null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Januar!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Januar!P40","v":-570.08405401999994}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Januar!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-721.74756752499991}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Januar!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,{"$f":"Januar!S42","v":5},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Januar!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"Marts","index":8,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,12,39,14],[39,15,39,17],[41,6,41,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Februar!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"Marts",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Februar!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2020-03-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$6+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Februar!B7","v":10},null,"2020-03-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$6+0)),\" \")","v":" "}]
[null,null,null,"2020-03-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," ",{"$f":"IF(I8=\"ja\",(IF(N8>=0,$I$1-(N8*0.75),$V$6+0)),\" \")","v":" "}]
["Funktionstillæg",{"$f":"Februar!B9","v":10},null,"2020-03-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"Februar!B11","v":10},null,"2020-03-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Februar!B13","v":10},null,"2020-03-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-03-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-03-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-03-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-03-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-03-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Februar!B25","v":45.39},null,"2020-03-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,{"$f":"IF(D27=X21,\"ja\",\" \")","v":" "},"2020-03-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-03-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Februar!B31","v":50},null,"2020-03-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-03-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-03-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-03-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Februar!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Februar!P40","v":-721.74756752499991}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Februar!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-873.41108102999988}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Februar!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,{"$f":"Februar!S42","v":5},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Februar!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"April","index":9,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,12,39,14],[39,15,39,17],[41,6,41,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Marts!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"April",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Marts!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2020-04-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Marts!B7","v":10},null,"2020-04-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-04-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"Marts!B9","v":10},null,"2020-04-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"Marts!B11","v":10},null,"2020-04-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Marts!B13","v":10},null,"2020-04-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,"ja","2020-04-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":7},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},"ja","2020-04-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,null,"2020-04-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},"ja","2020-04-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,"ja","2020-04-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":7},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-04-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-04-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-04-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Marts!B25","v":45.39},null,"2020-04-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,{"$f":"IF(D27=X21,\"ja\",\" \")","v":" "},"2020-04-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-04-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Marts!B31","v":50},null,"2020-04-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-04-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-04-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-04-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":28},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Marts!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Marts!P40","v":-873.41108102999988}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Marts!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-997.07459453499985}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Marts!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":28},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":28},"Ferie/frisaldo i dage",null,null,null,{"$f":"Marts!S42","v":5},"ny",{"$f":"Q42-(R37/Formler!B1)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Marts!S43","v":2},"ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"Maj","index":10,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,12,39,14],[39,15,39,17],[41,6,41,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"April!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"Maj",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"April!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,"ja","2020-05-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":7},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"April!B7","v":10},null,"2020-05-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-05-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"April!B9","v":10},null,"2020-05-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"April!B11","v":10},null,"2020-05-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"April!B13","v":10},"ja","2020-05-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,null,"2020-05-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-05-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-05-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-05-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-05-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-05-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"April!B25","v":45.39},null,"2020-05-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,"ja","2020-05-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":7},null," "," "," "," "]
["Multimedie",null,null,"2020-05-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-05-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"April!B31","v":50},null,"2020-05-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-05-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-05-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-05-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,"ja","2020-05-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":28},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"April!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"April!P40","v":-997.07459453499985}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+April!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-1120.7381080399998}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"April!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":28},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":28},"Ferie/frisaldo i dage",null,null,null,{"$f":"April!S42","v":5},"Ny",{"$f":"Q42-(R37/Formler!B1)+5","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"April!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"Juni","index":11,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,6,41,7],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[39,12,39,14],[39,15,39,17],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Maj!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"Juni",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Maj!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,"ja","2020-06-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":7},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Maj!B7","v":10},null,"2020-06-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-06-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"Maj!B9","v":10},null,"2020-06-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"Maj!B11","v":10},"ja","2020-06-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":7},null," "," "," "," "]
[null,null,null,"2020-06-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Maj!B13","v":10},null,"2020-06-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-06-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-06-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-06-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-06-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-06-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Maj!B25","v":45.39},null,"2020-06-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2020-06-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-06-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Maj!B31","v":50},null,"2020-06-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-06-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-06-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-06-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":14},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Maj!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Maj!P40","v":-1120.7381080399998}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Maj!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-1258.4016215449999}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Maj!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":14},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":14},"Ferie/frisaldo i dage",null,null,null,{"$f":"Maj!S42","v":10},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Maj!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"Juli","index":12,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,6,39,7],[40,6,40,7],[41,6,41,7],[39,12,39,14],[39,15,39,17],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[37,6,37,7],[38,6,38,7],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Juni!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"Juli",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Juni!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2020-07-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Juni!B7","v":10},null,"2020-07-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-07-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"Juni!B9","v":10},null,"2020-07-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"Juni!B11","v":10},null,"2020-07-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Juni!B13","v":10},null,"2020-07-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-07-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-07-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-07-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-07-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-07-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Juni!B25","v":45.39},null,"2020-07-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2020-07-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-07-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Juni!B31","v":50},null,"2020-07-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-07-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-07-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-07-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Juni!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Juni!P40","v":-1258.4016215449999}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Juni!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-1410.06513505}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Juni!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,{"$f":"Juni!S42","v":10},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Juni!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"August","index":13,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[40,12,40,14],[39,12,39,14],[39,15,39,17],[40,6,40,7],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[37,6,37,7],[38,6,38,7],[41,6,41,7],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[36,3,36,5],[39,6,39,7],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"Juli!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"August",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"Juli!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2020-08-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"Juli!B7","v":10},null,"2020-08-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-08-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"Juli!B9","v":10},null,"2020-08-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"Juli!B11","v":10},null,"2020-08-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"Juli!B13","v":10},null,"2020-08-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-08-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-08-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-08-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-08-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-08-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"Juli!B25","v":45.39},null,"2020-08-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2020-08-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-08-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"Juli!B31","v":50},null,"2020-08-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-08-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-08-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-08-31",null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$1,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"Juli!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"Juli!P40","v":-1410.06513505}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+Juli!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-1561.7286485550001}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"Juli!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,{"$f":"Juli!S42","v":10},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"Juli!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]

{"sheet":"September","index":14,"n_rows":43,"n_cols":23,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,6,41,7],[40,12,40,14],[36,3,36,5],[37,12,37,14],[37,15,37,17],[38,12,38,14],[38,15,38,17],[39,12,39,14],[39,15,39,17],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[30,0,31,0],[30,1,31,1],[32,0,33,0],[32,1,33,1],[34,0,35,0],[34,1,35,1],[24,0,25,0],[24,1,25,1],[26,0,27,0],[26,1,27,1],[28,0,29,0],[28,1,29,1],[18,0,19,0],[18,1,19,1],[20,0,21,0],[20,1,21,1],[22,0,23,0],[22,1,23,1],[12,0,13,0],[12,1,13,1],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[6,0,7,0],[6,1,7,1],[8,0,9,0],[8,1,9,1],[10,0,11,0],[10,1,11,1],[2,0,3,1],[2,4,2,11],[2,12,2,13],[2,14,2,16],[4,0,5,0],[4,1,5,1]]}
[null,null,null,null,null,null,"AFS Nat:",null,6,null,"Hvis haft nat, skriv ja i kolonnen.",null,null,null,null,null,null,"Aften:","17:00:00",null,"Lørdag","11:00:00","23:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Søn/hellig","07:00:00","23:00:00"]
["Lønberegning: ",null,null,"Navn:",{"$f":"August!E3","v":"Poul Prøvesen"},null,null,null,null,null,null,null,"Måned:",null,"September",null,null,"År:",2020]
[null,null,"Helligd.","Dato","Mødt","Gået","Timer","Hellig","Nat","Aften","Lørdag","Søndag","AFS","Op-","Syg","Ferie","Kur-","Ferie","Oms.","Ekstra","Bemærkning"]
["Månedsløn",{"$f":"August!B5","v":99000},null,null,"kl.","kl.",null,"dag",null,"17-23","11-23","7-23","nat","pe",null,"timer","sus","Fri","senior","timer"]
[null,null,null,"2020-09-01",null,null,{"$f":"(IF(AND(E6>0,F6>0),HOUR(F6-E6)+MINUTE(F6-E6)/60,\" \"))","v":" "},{"$f":"IF(C6=\"ja\",IF(G6=\" \",Formler!$B$1,G6*1.5),\" \")","v":" "},null,{"$f":"IF(F6>$S$1,HOUR(F6-$S$1)+MINUTE(F6-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=6,IF(F6>$V$1,(HOUR(F6-$V$1)+MINUTE(F6-$V$1)/60),\" \"),\" \")","v":" "},{"$f":"IF(WEEKDAY(D6,2)=7,IF(E6>0,(HOUR(F6-E6)+MINUTE(F6-E6)/60)/2,\" \"),\" \")","v":" "},{"$f":"IF(I6=\"ja\",(IF(N6>=0,$I$1-(N6*0.75),$V$5+0)),\" \")","v":" "}]
["Stillingstillæg",{"$f":"August!B7","v":10},null,"2020-09-02",null,null," ",{"$f":"IF(C7=\"ja\",IF(G7=\" \",Formler!$B$1,G7*1.5),\" \")","v":" "},null,{"$f":"IF(F7>$S$1,HOUR(F7-$S$1)+MINUTE(F7-$S$1)/60,\" \")","v":" "},{"$f":"IF(WEEKDAY(D7,2)=6,IF(F7>$V$1,(HOUR(F7-$V$1)+MINUTE(F7-$V$1)/60),\" \"),\" \")","v":" "}," ",{"$f":"IF(I7=\"ja\",(IF(N7>=0,$I$1-(N7*0.75),$V$5+0)),\" \")","v":" "}]
[null,null,null,"2020-09-03",null,null," ",{"$f":"IF(C8=\"ja\",IF(G8=\" \",Formler!$B$1,G8*1.5),\" \")","v":" "},null," "," "," "," "]
["Funktionstillæg",{"$f":"August!B9","v":10},null,"2020-09-04",null,null," ",{"$f":"IF(C9=\"ja\",IF(G9=\" \",Formler!$B$1,G9*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-05",null,null," ",{"$f":"IF(C10=\"ja\",IF(G10=\" \",Formler!$B$1,G10*1.5),\" \")","v":" "},null," "," "," "," "]
["Kvallifikationstillæg",{"$f":"August!B11","v":10},null,"2020-09-06",null,null," ",{"$f":"IF(C11=\"ja\",IF(G11=\" \",Formler!$B$1,G11*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-07",null,null," ",{"$f":"IF(C12=\"ja\",IF(G12=\" \",Formler!$B$1,G12*1.5),\" \")","v":" "},null," "," "," "," "]
["Grundtillæg",{"$f":"August!B13","v":10},null,"2020-09-08",null,null," ",{"$f":"IF(C13=\"ja\",IF(G13=\" \",Formler!$B$1,G13*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-09",null,null," ",{"$f":"IF(C14=\"ja\",IF(G14=\" \",Formler!$B$1,G14*1.5),\" \")","v":" "},null," "," "," "," "]
["Ekstra timer _____",{"$f":"T37*Formler!B7","v":0},null,"2020-09-10",null,null," ",{"$f":"IF(C15=\"ja\",IF(G15=\" \",Formler!$B$1,G15*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-11",null,null," ",{"$f":"IF(C16=\"ja\",IF(G16=\" \",Formler!$B$1,G16*1.5),\" \")","v":" "},null," "," "," "," "]
["Aftentillæg",{"$f":"+J37*Formler!B9","v":0},null,"2020-09-12",null,null," ",{"$f":"IF(C17=\"ja\",IF(G17=\" \",Formler!$B$1,G17*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-13",null,null," ",{"$f":"IF(C18=\"ja\",IF(G18=\" \",Formler!$B$1,G18*1.5),\" \")","v":" "},null," "," "," "," "]
["Lørdagstillæg",{"$f":"+K37*Formler!B10","v":0},null,"2020-09-14",null,null," ",{"$f":"IF(C19=\"ja\",IF(G19=\" \",Formler!$B$1,G19*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-15",null,null," ",{"$f":"IF(C20=\"ja\",IF(G20=\" \",Formler!$B$1,G20*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag",null,null,"2020-09-16",null,null," ",{"$f":"IF(C21=\"ja\",IF(G21=\" \",Formler!$B$1,G21*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-17",null,null," ",{"$f":"IF(C22=\"ja\",IF(G22=\" \",Formler!$B$1,G22*1.5),\" \")","v":" "},null," "," "," "," "]
["Uniformsgodtgørelse",{"$f":"P38*Formler!B11","v":279.06086484920002},null,"2020-09-18",null,null," ",{"$f":"IF(C23=\"ja\",IF(G23=\" \",Formler!$B$1,G23*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-19",null,null," ",{"$f":"IF(C24=\"ja\",IF(G24=\" \",Formler!$B$1,G24*1.5),\" \")","v":" "},null," "," "," "," "]
["Sundhedsforsikring",{"$f":"August!B25","v":45.39},null,"2020-09-20",null,null," ",{"$f":"IF(C25=\"ja\",IF(G25=\" \",Formler!$B$1,G25*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-21",null,null," ",{"$f":"IF(C26=\"ja\",IF(G26=\" \",Formler!$B$1,G26*1.5),\" \")","v":" "},null," "," "," "," "]
["Multimedie",null,null,"2020-09-22",null,null," ",{"$f":"IF(C27=\"ja\",IF(G27=\" \",Formler!$B$1,G27*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-23",null,null," ",{"$f":"IF(C28=\"ja\",IF(G28=\" \",Formler!$B$1,G28*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag kost",{"$f":"IF(L42/Formler!B16>=37,300,IF(L42/Formler!B16>=20,225,IF(L42/Formler!B16<=19,150)))","v":150},null,"2020-09-24",null,null," ",{"$f":"IF(C29=\"ja\",IF(G29=\" \",Formler!$B$1,G29*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-25",null,null," ",{"$f":"IF(C30=\"ja\",IF(G30=\" \",Formler!$B$1,G30*1.5),\" \")","v":" "},null," "," "," "," "]
["Fradrag gavekasse",{"$f":"August!B31","v":50},null,"2020-09-26",null,null," ",{"$f":"IF(C31=\"ja\",IF(G31=\" \",Formler!$B$1,G31*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-27",null,null," ",{"$f":"IF(C32=\"ja\",IF(G32=\" \",Formler!$B$1,G32*1.5),\" \")","v":" "},null," "," "," "," "]
["Bagvagt",null,null,"2020-09-28",null,null," ",{"$f":"IF(C33=\"ja\",IF(G33=\" \",Formler!$B$1,G33*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,"2020-09-29",null,null," ",{"$f":"IF(C34=\"ja\",IF(G34=\" \",Formler!$B$1,G34*1.5),\" \")","v":" "},null," "," "," "," "]
["Kørsel i km",null,null,"2020-09-30",null,null," ",{"$f":"IF(C35=\"ja\",IF(G35=\" \",Formler!$B$1,G35*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"IF(F36>0,HOUR(F36-E36)+MINUTE(F36-E36)/60,\" \")","v":" "},{"$f":"IF(C36=\"ja\",IF(G36=\" \",Formler!$B$18,G36*1.5),\" \")","v":" "},null," "," "," "," "]
[null,null,null,null,null,null,{"$f":"SUM(G6:G36)","v":0},{"$f":"SUM(H6:H36)","v":0},null,{"$f":"SUM(J6:J36)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(R6:R36)","v":0},{"$f":"SUM(S6:S36)","v":0},0]
[null,null,null,"Timetal d.m.",null,null,{"$f":"G37+O37+P37+Q37+M37+R37+S37","v":0},null,null,null,null,null,"Fast timetal",null,null,{"$f":"August!P38","v":151.663513505}]
[null,null,null,"Oppe",null,null,{"$f":"N37","v":0},null,null,null,null,null,"Gl.saldo",null,null,{"$f":"August!P40","v":-1561.7286485550001}]
[null,null,null,"Aften fra saldo",null,null,{"$f":"J37/12+August!G40","v":0},null,null,null,null,null,"Ny saldo",null,null,{"$f":"+L42-P38+P39","v":-1713.3921620600001}]
[null,null,null,"Nat ",null,null,{"$f":"M37","v":0},null,null,null,null,null,"Ferie saldo",null,null,null,{"$f":"August!S41","v":10},"Ny",{"$f":"Q41-(P37/Formler!B1)+0","v":10}]
[null,null,null,"Søn/helligdage",null,null,{"$f":"L37+H37","v":0},null,null,null,"I alt",{"$f":"SUM(G38+G39+G40+G41+G42)","v":0},"Ferie/frisaldo i dage",null,null,null,{"$f":"August!S42","v":10},"Ny",{"$f":"Q42-(R37/Formler!B1)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Oms/sen saldo i dage",null,null,null,{"$f":"August!S43","v":2},"Ny",{"$f":"Q43-(S37/Formler!B1)","v":2}]