{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Datasheet","Lønberegner"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Datasheet","index":0,"n_rows":197,"n_cols":6,"rows_kept":197,"cut":false,"hidden":true,"merged":[]}
[]
["GRUNDLØNINGER GÆLDENDE FOR:",{"$f":"TODAY()","v":"2024-04-23"},null,{"$f":"YEAR(B2)","v":2024},2025,2026]
[]
["LØNGRUPPER",null,null,null,2025,2026]
[null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2]
["Løngruppe 1","Angiv selv løn",null,null,"Angiv selv løn","Angiv selv løn"]
["- Kameraoperatør"]
["- Steadicam operatør"]
["- Food styling"]
["- Stylist (både kostume og sminke)"]
["- Sound designer  "]
["Løngruppe 2",{"$f":"_xlfn.IFS($D$2=2024,D12,$D$2=2025,E12,$D$2=2026,F12,$D$2=2027,\"2027 beregner kræves\")","v":4100},null,4100,{"$f":"D12*$E$5+D12","v":4202.5},{"$f":"E12*$F$5+E12","v":4307.5625}]
["- Indspilningsleder"]
["- Location manager / scout"]
["- Tonemester på optagelse"]
["- 1. AC/ B-foto"]
["- Belysningsmester"]
["- SFX Supervisor"]
["- Key grip"]
["- Chefkostume"]
["- Chefrekvisitør"]
["- Chefsminkør"]
["Løngruppe 3",{"$f":"_xlfn.IFS($D$2=2024,D23,$D$2=2025,E23,$D$2=2026,F23,$D$2=2027,\"2027 beregner kræves\")","v":3300},null,3300,{"$f":"D23*$E$5+D23","v":3382.5},{"$f":"E23*$F$5+E23","v":3467.0625}]
["- Statistkoordinator"]
["- 2. AC "]
["- B-Tonemester / Boom op."]
["- Q-take operatør"]
["- DIT"]
["- Scripter"]
["- Board operator"]
["- Belyser"]
["- Best boy grip"]
["- Kostumier"]
["- Rekvisitør"]
["- Sminkør / Hår"]
["- SFX Tekniker"]
["Løngruppe 4",{"$f":"_xlfn.IFS($D$2=2024,D37,$D$2=2025,E37,$D$2=2026,F37,$D$2=2027,\"2027 beregner kræves\")","v":2750},null,2750,{"$f":"D37*$E$5+D37","v":2818.75},{"$f":"E37*$F$5+E37","v":2889.21875}]
["- Indspilningslederassistant"]
["- Videoassistent"]
["- Data Wrangler"]
["- Belysningsassistent"]
["- Toneassistent"]
["- Grip assistent"]
["- Kostumier assistent"]
["- Rekvisitør assistent"]
["- Sminkør assistent"]
["- SFX assistent"]
["- Locationassistent"]
["Løngruppe 5:",{"$f":"_xlfn.IFS($D$2=2024,D49,$D$2=2025,E49,$D$2=2026,F49,$D$2=2027,\"2027 beregner kræves\")","v":1540},null,1540,{"$f":"D49*$E$5+D49","v":1578.5},{"$f":"E49*$F$5+E49","v":1617.9625000000001}]
["- Runner"]
["- Trainee (Tilknyttet en afdeling som ekstra hjælp)"]
[]
[]
["OVERTID FOR LØNGR. 2-4"]
[null,"0-8","8-10t","10-12t","12+ t"]
["Forberedelsestid","Normaltimer",0.25,0.5,0.75]
[]
[null,"0-8","8-10t","10-12t","12-14t","14+ t"]
["Optagetid","Normaltimer",0.25,1,1.5,2]
[]
[]
[]
[]
["OVERTID FOR LØNGR 5"]
[null,"0-8","Rate 1","Rate 2"]
["Optagetid","Normaltimer",200,350]
[]
[]
["WEEKEND"]
["Fra Fredag kl 00, til mandag kl 06:00"]
["1 weekend dag",0.75]
["2 weekend dage",1]
[]
[]
["TRANSPORT"]
[]
["Transporttid",0.75,"Gælder først efter kl 10"]
[]
[]
["GENE TILLÆG"]
[]
["Optagetid ml. 18:00 - 00:00",100,"18:00:00"]
["Optagetid kl. 00:00 - 06:00",200,"00:00:00"]
[null,null,"06:00:00"]
[]
["PAUSER"]
[]
["Forsinket afholdt frokost",172.2,"Diætsatser 2024"]
["Ingen servering ved pause",172.2,"Diætsatser 2024"]
["5. time pause ikke afholdt","45min betaling til normaltimeløn + 25%"]
["10. time pause ikke afholdt","30min betaling til normaltimeløn + 100%"]
["13 time pause ikke afholdt","15min betaling til normaltimeløn + 150%"]
[]
["RABATORDNINGER"]
[]
["Rabat A:",-0.1,"Gives på alle optagedage, på produktioner på 2-4dage"]
["Rabat B:",-0.15,"Gives på dag 5 og efterfølgende dage på produktioner der har over 4 optagedage"]
[]
[]
[]
[]
["06:00:00"]
["06:15:00"]
["06:30:00"]
["06:45:00"]
["07:00:00"]
["07:15:00"]
["07:30:00"]
["07:45:00"]
["08:00:00"]
["08:15:00"]
["08:30:00"]
["08:45:00"]
["09:00:00"]
["09:15:00"]
["09:30:00"]
["09:45:00"]
["10:00:00"]
["10:15:00"]
["10:30:00"]
["10:45:00"]
["11:00:00"]
["11:15:00"]
["11:30:00"]
["11:45:00"]
["12:00:00"]
["12:15:00"]
["12:30:00"]
["12:45:00"]
["13:00:00"]
["13:15:00"]
["13:30:00"]
["13:45:00"]
["14:00:00"]
["14:15:00"]
["14:30:00"]
["14:45:00"]
["15:00:00"]
["15:15:00"]
["15:30:00"]
["15:45:00"]
["16:00:00"]
["16:15:00"]
["16:30:00"]
["16:45:00"]
["17:00:00"]
["17:15:00"]
["17:30:00"]
["17:45:00"]
["18:00:00"]
["18:15:00"]
["18:30:00"]
["18:45:00"]
["19:00:00"]
["19:15:00"]
["19:30:00"]
["19:45:00"]
["20:00:00"]
["20:15:00"]
["20:30:00"]
["20:45:00"]
["21:00:00"]
["21:15:00"]
["21:30:00"]
["21:45:00"]
["22:00:00"]
["22:15:00"]
["22:30:00"]
["22:45:00"]
["23:00:00"]
["23:15:00"]
["23:30:00"]
["23:45:00"]
[1]
["00:15:00"]
["00:30:00"]
["00:45:00"]
["01:00:00"]
["01:15:00"]
["01:30:00"]
["01:45:00"]
["02:00:00"]
["02:15:00"]
["02:30:00"]
["02:45:00"]
["03:00:00"]
["03:15:00"]
["03:30:00"]
["03:45:00"]
["04:00:00"]
["04:15:00"]
["04:30:00"]
["04:45:00"]
["05:00:00"]
["05:15:00"]
["05:30:00"]
["05:45:00"]

{"sheet":"Lønberegner","index":1,"n_rows":50,"n_cols":25,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,15,10,19],[49,11,49,16],[1,1,1,4],[3,1,3,4],[5,1,5,4],[7,1,7,4],[15,3,16,4],[11,16,11,18],[11,6,11,11],[11,13,11,14],[1,7,1,10],[3,7,3,10],[5,7,5,10],[7,7,7,10],[1,12,1,15],[3,12,3,15],[5,12,5,15],[7,12,7,15],[1,17,1,22],[3,19,3,22],[5,19,5,22],[7,19,7,22],[45,3,46,4],[20,3,21,4],[25,3,26,4],[30,3,31,4],[35,3,36,4],[40,3,41,4]]}
[null,"Produktions titel",null,null,null,null,null,"Fulde navn",null,null,null,null,"Bank navn\t\t\t",null,null,null,null,"Vælg løn gr./funktion"]
[null,"Produktions titel",null,null,null,null,null,"Fulde navn",null,null,null,null,"Bank navn",null,null,null,null,"Løngruppe 1"]
[null,"Evt. Produktions nr.",null,null,null,null,null,"Adresse",null,null,null,null,"Reg & Konto nr."]
[null,"Evt. Produktions nr.",null,null,null,null,null,"Adresse",null,null,null,null,"Reg & Konto nr.",null,null,null,null,"Dagsløn:",null,{"$f":"_xlfn.IFS(R2=Datasheet!A6,Datasheet!B6,R2=Datasheet!A7,Datasheet!B6,R2=Datasheet!A8,Datasheet!B6,R2=Datasheet!A9,Datasheet!B6,R2=Datasheet!A10,Datasheet!B6,Lønberegner!R2=Datasheet!A11,Datasheet!B6,R2=Datasheet!A12,Datasheet!B12,R2=Datasheet!A13,Datasheet!B12,R2=Datasheet!A14,Datasheet!B12,R2=Datasheet!A15,Datasheet!B12,R2=Datasheet!A16,Datasheet!B12,R2=Datasheet!A17,Datasheet!B12,R2=Datasheet!A18,Datasheet!B12,R2=Datasheet!A18,Datasheet!B12,R2=Datasheet!A19,Datasheet!B12,R2=Datasheet!A20,Datasheet!B12,R2=Datasheet!A21,Datasheet!B12,R2=Datasheet!A22,Datasheet!B12,R2=Datasheet!A23,Datasheet!B23,R2=Datasheet!A24,Datasheet!B23,R2=Datasheet!A25,Datasheet!B23,R2=Datasheet!A26,Datasheet!B23,R2=Datasheet!A27,Datasheet!B23,R2=Datasheet!A28,Datasheet!B23,R2=Datasheet!A29,Datasheet!B23,R2=Datasheet!A30,Datasheet!B23,R2=Datasheet!A31,Datasheet!B23,R2=Datasheet!A32,Datasheet!B23,R2=Datasheet!A33,Datasheet!B23,R2=Datasheet!A34,Datasheet!B23,R2=Datasheet!A35,Datasheet!B23,R2=Datasheet!A36,Datasheet!B23,R2=Datasheet!A37,Datasheet!B37,R2=Datasheet!A38,Datasheet!B37,R2=Datasheet!A39,Datasheet!B37,R2=Datasheet!A40,Datasheet!B37,R2=Datasheet!A41,Datasheet!B37,R2=Datasheet!A42,Datasheet!B37,R2=Datasheet!A43,Datasheet!B37,R2=Datasheet!A44,Datasheet!B37,R2=Datasheet!A45,Datasheet!B37,R2=Datasheet!A46,Datasheet!B37,R2=Datasheet!A47,Datasheet!B37,R2=Datasheet!A48,Datasheet!B37,R2=Datasheet!A49,Datasheet!B49,R2=Datasheet!A50,Datasheet!B49,R2=Datasheet!A51,Datasheet!B49)","v":"Angiv selv løn"}]
[null,"Evt. kontakt reference",null,null,null,null,null,"Postnr. & By",null,null,null,null,"Telefon"]
[null,"Evt. kontakt reference",null,null,null,null,null,"Postnr. & By",null,null,null,null,"Telefon",null,null,null,null,"Evt personligt tillæg:",null,0]
[null,"Evt. kunde reference",null,null,null,null,null,"CPR nr.",null,null,null,null,"Email"]
[null,"Evt. kunde reference",null,null,null,null,null,"CPR nr.",null,null,null,null,"Email",null,null,null,null,"Dagsløn total:",null,{"$f":"IF(T4=\"Angiv selv løn\",T6,T4+T6)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UDFYLDES KUN FOR OPTAGELSE"]
[null,"UGE #",{"$f":"WEEKNUM(B15,2)","v":11},null,null,null,"TIME BEREGNER",null,null,null,null,null,"WEEKEND / HELLIGDAG","GENETILLÆG",null,"TRANSPORT","PAUSER",null,null,"RABAT","DIÆTER",null,"A-LØN TOTAL",null,"DIÆTER TOTAL"]
[null,"Dato","Ugedag","Start","Slut",null,"Timer i alt, ex. Transporttid","Normal-timer","9-10 timer","11-12 timer","13 timer","≥ 14 timer","Fre 24:00 - Man 06:00","Optagelse \nkl. 18 - 00","Optagelse \nkl. 00 - 06","Transporttid\ntil/fra set","5. time \n(30+15min) ","10. time\n(30min)","13. time \n(15min)","Rabat A el. B","Fortæring i arbejdstiden",null,{"$f":"SUM(W14:W50)","v":0},null,{"$f":"SUM(Y15:Y48)","v":344.4}]
[]
[null,"2024-03-11",{"$f":"WEEKDAY(B15,1)","v":"1900-01-02"},"08:00:00","16:00:00",null,{"$f":"_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16<>\"Fri\",IF(AND(E15>0,D15>0),MOD((HOUR(E15)-HOUR(D15))+(MINUTE(E15)-MINUTE(D15))/60,24),0/24))","v":8},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G15=0,0,(IF(AND(G15>0,G15<=4),4,(IF(AND(G15>=4,G15<=8,G15<>0),G15,8)))))),_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"4\",$D16=\"Optagelse\",(IF(G15>0,8,0)),$D16=\"Forbered/afrig tid\",(IF(G15=0,0,(IF(AND(G15>0,G15<=4),4,(IF(AND(G15>=4,G15<=8,G15<>0),G15,8)))))),$D16=\"Rejsetid\",(IF(AND(G15>0,G15<=4),4,(IF(G15>=4,G15,0)))),$D16=\"Rejsetid +50%\",(IF(AND(G15>0,G15<=4),4,(IF(G15>=4,G15,0))))))","v":8},{"$f":"IF(OR(D16=\"Optagelse\",D16=\"Forbered/afrig tid\"),IF(G15>8,(G15-H15-J15-K15-L15),0),\"-\")","v":0},{"$f":"IF(OR($D16=\"Optagelse\",$D16=\"Forbered/afrig tid\"),IF(G15>10,(G15-H15-K15-L15)-2,0),\"-\")","v":0},{"$f":"IF(OR($D16=\"Optagelse\",$D16=\"Forbered/afrig tid\"),IF(G15>12,(G15-H15-L15)-4,0),\"-\")","v":0},{"$f":"IF(OR(D16=\"Optagelse\",$D16=\"Forbered/afrig tid\"),IF(G15>13,(G15-H15)-5,0),\"-\")","v":0},0.75,{"$f":"IF($D16=\"Optagelse\",ColTime(D15,E15,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":0},{"$f":"IF($D16=\"Optagelse\",ColTime(D15,E15,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":0},0,"Forsinket","Planmæssigt","Planmæssigt","Ingen rabat","Ingen diæt"]
[null,null,"Helligdag?","Optagelse",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D16=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D16=\"Fri\",\"-\",\"Timeløn\")))))","v":"Timeløn"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",D16=\"Forbered/afrig tid\",Datasheet!$C$56,D16=\"Optagelse\",Datasheet!$C$59)))","v":0.25},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",D16=\"Rejsetid\",\"-\",D16=\"Forbered/afrig tid\",Datasheet!$D$56,D16=\"Optagelse\",Datasheet!$D$59))","v":1},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D16=\"Fri\",\"-\",D16=\"Rejsetid\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",D16=\"Forbered/afrig tid\",Datasheet!$E$56,D16=\"Optagelse\",Datasheet!$E$59))","v":1.5},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",D16=\"Rejsetid\",\"-\",D16=\"Forbered/afrig tid\",Datasheet!$E$56,D16=\"Optagelse\",Datasheet!$F$59))","v":2},{"$f":"IF(AND($C17=\"Ja\",OR($D16=\"optagelse\",$D16=\"Forbered/afrig tid\")),_xlfn.IFS($D16=\"optagelse\",$G15+$P15,$D16=\"Forbered/afrig tid\",$G15),_xlfn.IFS($D16=\"Fri\",0,$D16=\"rejsetid\",0,$D16=\"rejsetid +50%\",0,$D16=\"sygdom\",0,$C15=1,IF(AND($C15=1,$D16=\"optagelse\"),$G15+$P15,G15),$C15=7,IF(AND($C15=7,$D16=\"optagelse\"),$G15+$P15,$G15),$C15=2,IF(($D15*24)<=6,ColTime($D15,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C15=3,0,$C15=4,0,$C15=5,0,$C15=6,IF(($D15*24)>6,ColTime($D15,$E15,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D16=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D16=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D16=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":0.75},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",(_xlfn.IFS(Q15=\"Planmæssigt\",\"-\",Q15=\"Forsinket\",\"Diæt\",Q15=\"Ingen servering\",\"Diæt\",Q15=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"Diæt"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",(_xlfn.IFS(R15=\"Planmæssigt\",\"-\",R15=\"Forsinket\",\"Diæt\",R15=\"Ingen servering\",\"Diæt\",R15=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",(_xlfn.IFS(S15=\"Planmæssigt\",\"-\",S15=\"Forsinket\",\"Diæt\",S15=\"Ingen servering\",\"Diæt\",S15=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T4=Datasheet!$B$49,\"-\",IF(D16=\"Optagelse\",_xlfn.IFS(T15=\"Ingen rabat\",\"-\",T15=\"Rabat A\",Datasheet!$B$96,T15=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":"-"},{"$f":"IF(U15=\"Ingen diæt\",\"-\",U15)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Optagelse\",grundløn/8,$D16=\"rejsetid\",grundløn/8,$D16=\"rejsetid +50%\",(grundløn/8)*1.5,$D16=\"Forbered/afrig tid\",grundløn/8,$D16=\"Sygdom\",grundløn/8)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",$D16=\"Optagelse\",grundløn/8*$I16+grundløn/8,$D16=\"rejsetid\",\"-\",$D16=\"Forbered/afrig tid\",grundløn/8*$I16+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",$D16=\"Optagelse\",grundløn/8*$J16+grundløn/8,$D16=\"rejsetid\",\"-\",$D16=\"Forbered/afrig tid\",grundløn/8*$J16+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",$D16=\"Optagelse\",grundløn/8*$K16+grundløn/8,$D16=\"rejsetid\",\"-\",$D16=\"Forbered/afrig tid\",grundløn/8*$K16+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Rejsetid\",\"-\",D16=\"Rejsetid +50%\",\"-\",$D16=\"Optagelse\",grundløn/8*$L16+grundløn/8,$D16=\"rejsetid\",\"-\",$D16=\"Forbered/afrig tid\",grundløn/8*$L16+grundløn/8))","v":0},{"$f":"IF(AND(M16<>0,M16<>\"-\"),H17*M15,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D16=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":100},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D16=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":200},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D16=\"Optagelse\",((grundløn/8)*P16),\"-\"))","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",_xlfn.IFS(Q15=\"Planmæssigt\",\"-\",Q15=\"Forsinket\",Datasheet!$B$88,Q15=\"Ingen servering\",Datasheet!$B$88,Q15=\"Pause ikke afholdt\",Datasheet!$B$88))","v":172.2},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",_xlfn.IFS(R15=\"Planmæssigt\",\"-\",R15=\"Forsinket\",Datasheet!$B$88,R15=\"Ingen servering\",Datasheet!$B$88,R15=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",_xlfn.IFS(S15=\"Planmæssigt\",\"-\",S15=\"Forsinket\",Datasheet!$B$88,S15=\"Ingen servering\",Datasheet!$B$88,S15=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T4=Datasheet!$B$49,\"-\",(_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Optagelse\",(IF(T15=\"Ingen rabat\",\"-\",(SUM(H18:S18)))))))","v":"-"},{"$f":"IF(OR($Q16<>\"-\",$R16<>\"-\",$S16<>\"-\",D16=\"Fri\"),\"-\",_xlfn.IFS($U16=\"-\",\"-\",$U16=\"Morgen\",86.1,$U16=\"Morgen+Frokost\",258.3,$U16=\"Frokost el. Aften\",172.2,$U16=\"Frokost+Aften\", 344.4,$U16=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q17:S17)+SUM(U17)","v":172.2}]
[null,null,null,null,null,null,null,{"$f":"IF($D16=\"Fri\",\"-\",(IF(H15>0,H17*H15,\"-\")))","v":0},{"$f":"IF(AND(I15<>\"-\",I17<>\"-\"),I17*I15,\"-\")","v":0},{"$f":"IF(AND(J15<>\"-\",J17<>\"-\"),J17*J15,\"-\")","v":0},0,0,{"$f":"IF(M17<>\"-\",M17*M16,\"-\")","v":"-"},{"$f":"IF(AND(N15<>\"-\",N17<>\"-\"),N17*N15,\"-\")","v":0},{"$f":"IF(AND(O15<>\"-\",O17<>\"-\"),O17*O15,\"-\")","v":0},0,{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",_xlfn.IFS(Q15=\"Planmæssigt\",\"-\",Q15=\"Forsinket\",\"-\",Q15=\"Ingen servering\",\"-\",Q15=\"Pause ikke afholdt\",($I17*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",_xlfn.IFS(R15=\"Planmæssigt\",\"-\",R15=\"Forsinket\",\"-\",R15=\"Ingen servering\",\"-\",R15=\"Pause ikke afholdt\",($J17*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D16=\"Fri\",\"-\",$D16=\"Forbered/afrig tid\",\"-\",$D16=\"Rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"optagelse\",_xlfn.IFS(S15=\"Planmæssigt\",\"-\",S15=\"Forsinket\",\"-\",S15=\"Ingen servering\",\"-\",S15=\"Pause ikke afholdt\",(K17*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D16=\"Fri\",\"-\",$D16=\"rejsetid\",\"-\",$D16=\"Rejsetid +50%\",\"-\",$D16=\"Sygdom\",\"-\",$D16=\"Optagelse\",(_xlfn.IFS(T17=\"-\",\"-\",T17=0,\"-\",T17<>0,T17*T16)),$D16=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D16=\"Fri\",0,$D16=\"optagelse\",(_xlfn.IFS(SUM(H18:T18)=0,0,SUM(H18:T18)>grundløn,SUM(H18:T18),SUM(H18:T18)<=grundløn,grundløn)),$D16=\"Forbered/afrig tid\",(IF(SUM(H18:T18)=0,0,SUM(H18:T18))),$D16=\"rejsetid\",(IF(SUM(H18:T18)=0,0,SUM(H18:T18))),$D16=\"rejsetid +50%\",(IF(SUM(H18:T18)=0,0,SUM(H18:T18))),$D16=\"sygdom\",(IF(SUM(H18:T18)=0,0,SUM(H18:T18))))","v":0}]
[]
[null,{"$f":"B15+1","v":"2024-03-12"},{"$f":"WEEKDAY(B20,1)","v":"1900-01-03"},"08:00:00","16:00:00",null,{"$f":"_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21<>\"Fri\",IF(AND(E20>0,D20>0),MOD((HOUR(E20)-HOUR(D20))+(MINUTE(E20)-MINUTE(D20))/60,24),0/24))","v":8},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G20=0,0,(IF(AND(G20>0,G20<=4),4,(IF(AND(G20>=4,G20<=8,G20<>0),G20,8)))))),_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"4\",$D21=\"Optagelse\",(IF(G20>0,8,0)),$D21=\"Forbered/afrig tid\",(IF(G20=0,0,(IF(AND(G20>0,G20<=4),4,(IF(AND(G20>=4,G20<=8,G20<>0),G20,8)))))),$D21=\"Rejsetid\",(IF(AND(G20>0,G20<=4),4,(IF(G20>=4,G20,0)))),$D21=\"Rejsetid +50%\",(IF(AND(G20>0,G20<=4),4,(IF(G20>=4,G20,0))))))","v":8},{"$f":"IF(OR(D21=\"Optagelse\",D21=\"Forbered/afrig tid\"),IF(G20>8,(G20-H20-J20-K20-L20),0),\"-\")","v":0},{"$f":"IF(OR($D21=\"Optagelse\",$D21=\"Forbered/afrig tid\"),IF(G20>10,(G20-H20-K20-L20)-2,0),\"-\")","v":0},{"$f":"IF(OR($D21=\"Optagelse\",$D21=\"Forbered/afrig tid\"),IF(G20>12,(G20-H20-L20)-4,0),\"-\")","v":0},{"$f":"IF(OR(D21=\"Optagelse\",$D21=\"Forbered/afrig tid\"),IF(G20>13,(G20-H20)-5,0),\"-\")","v":0},0.75,{"$f":"IF($D21=\"Optagelse\",ColTime(D20,E20,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":0},{"$f":"IF($D21=\"Optagelse\",ColTime(D20,E20,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":0},0,"Planmæssigt","Planmæssigt","Planmæssigt","Ingen rabat","Ingen diæt"]
[null,null,"Helligdag?","Optagelse",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D21=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D21=\"Fri\",\"-\",\"Timeløn\")))))","v":"Timeløn"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",D21=\"Forbered/afrig tid\",Datasheet!$C$56,D21=\"Optagelse\",Datasheet!$C$59)))","v":0.25},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",D21=\"Rejsetid\",\"-\",D21=\"Forbered/afrig tid\",Datasheet!$D$56,D21=\"Optagelse\",Datasheet!$D$59))","v":1},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D21=\"Fri\",\"-\",D21=\"Rejsetid\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",D21=\"Forbered/afrig tid\",Datasheet!$E$56,D21=\"Optagelse\",Datasheet!$E$59))","v":1.5},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",D21=\"Rejsetid\",\"-\",D21=\"Forbered/afrig tid\",Datasheet!$E$56,D21=\"Optagelse\",Datasheet!$F$59))","v":2},{"$f":"IF(AND($C22=\"Ja\",OR($D21=\"optagelse\",$D21=\"Forbered/afrig tid\")),_xlfn.IFS($D21=\"optagelse\",$G20+$P20,$D21=\"Forbered/afrig tid\",$G20),_xlfn.IFS($D21=\"Fri\",0,$D21=\"rejsetid\",0,$D21=\"rejsetid +50%\",0,$D21=\"sygdom\",0,$C20=1,IF(AND($C20=1,$D21=\"optagelse\"),$G20+$P20,G20),$C20=7,IF(AND($C20=7,$D21=\"optagelse\"),$G20+$P20,$G20),$C20=2,IF(($D20*24)<=6,ColTime($D20,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C20=3,0,$C20=4,0,$C20=5,0,$C20=6,IF(($D20*24)>6,ColTime($D20,$E20,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D21=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D21=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D21=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":0.75},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",(_xlfn.IFS(Q20=\"Planmæssigt\",\"-\",Q20=\"Forsinket\",\"Diæt\",Q20=\"Ingen servering\",\"Diæt\",Q20=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",(_xlfn.IFS(R20=\"Planmæssigt\",\"-\",R20=\"Forsinket\",\"Diæt\",R20=\"Ingen servering\",\"Diæt\",R20=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",(_xlfn.IFS(S20=\"Planmæssigt\",\"-\",S20=\"Forsinket\",\"Diæt\",S20=\"Ingen servering\",\"Diæt\",S20=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T9=Datasheet!$B$49,\"-\",IF(D21=\"Optagelse\",_xlfn.IFS(T20=\"Ingen rabat\",\"-\",T20=\"Rabat A\",Datasheet!$B$96,T20=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":"-"},{"$f":"IF(U20=\"Ingen diæt\",\"-\",U20)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Optagelse\",grundløn/8,$D21=\"rejsetid\",grundløn/8,$D21=\"rejsetid +50%\",(grundløn/8)*1.5,$D21=\"Forbered/afrig tid\",grundløn/8,$D21=\"Sygdom\",grundløn/8)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",$D21=\"Optagelse\",grundløn/8*$I21+grundløn/8,$D21=\"rejsetid\",\"-\",$D21=\"Forbered/afrig tid\",grundløn/8*$I21+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",$D21=\"Optagelse\",grundløn/8*$J21+grundløn/8,$D21=\"rejsetid\",\"-\",$D21=\"Forbered/afrig tid\",grundløn/8*$J21+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",$D21=\"Optagelse\",grundløn/8*$K21+grundløn/8,$D21=\"rejsetid\",\"-\",$D21=\"Forbered/afrig tid\",grundløn/8*$K21+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Rejsetid\",\"-\",D21=\"Rejsetid +50%\",\"-\",$D21=\"Optagelse\",grundløn/8*$L21+grundløn/8,$D21=\"rejsetid\",\"-\",$D21=\"Forbered/afrig tid\",grundløn/8*$L21+grundløn/8))","v":0},{"$f":"IF(AND(M21<>0,M21<>\"-\"),H22*M20,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D21=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":100},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D21=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":200},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D21=\"Optagelse\",((grundløn/8)*P21),\"-\"))","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",_xlfn.IFS(Q20=\"Planmæssigt\",\"-\",Q20=\"Forsinket\",Datasheet!$B$88,Q20=\"Ingen servering\",Datasheet!$B$88,Q20=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",_xlfn.IFS(R20=\"Planmæssigt\",\"-\",R20=\"Forsinket\",Datasheet!$B$88,R20=\"Ingen servering\",Datasheet!$B$88,R20=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",_xlfn.IFS(S20=\"Planmæssigt\",\"-\",S20=\"Forsinket\",Datasheet!$B$88,S20=\"Ingen servering\",Datasheet!$B$88,S20=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T9=Datasheet!$B$49,\"-\",(_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Optagelse\",(IF(T20=\"Ingen rabat\",\"-\",(SUM(H23:S23)))))))","v":"-"},{"$f":"IF(OR(Q21<>\"-\",R21<>\"-\",S21<>\"-\",D21=\"Fri\"),\"-\",_xlfn.IFS(U21=\"-\",\"-\",U21=\"Morgen\",86.1,U21=\"Morgen+Frokost\",258.3,U21=\"Frokost el. Aften\",172.2,U21=\"Frokost+Aften\", 344.4,U21=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q22:S22)+SUM(U22)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($D21=\"Fri\",\"-\",(IF(H20>0,H22*H20,\"-\")))","v":0},{"$f":"IF(AND(I20<>\"-\",I22<>\"-\"),I22*I20,\"-\")","v":0},{"$f":"IF(AND(J20<>\"-\",J22<>\"-\"),J22*J20,\"-\")","v":0},0,0,{"$f":"IF(M22<>\"-\",M22*M21,\"-\")","v":"-"},{"$f":"IF(AND(N20<>\"-\",N22<>\"-\"),N22*N20,\"-\")","v":0},{"$f":"IF(AND(O20<>\"-\",O22<>\"-\"),O22*O20,\"-\")","v":0},{"$f":"IF(AND(P20<>\"-\",P22<>\"-\"),P22*P20,\"-\")","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",_xlfn.IFS(Q20=\"Planmæssigt\",\"-\",Q20=\"Forsinket\",\"-\",Q20=\"Ingen servering\",\"-\",Q20=\"Pause ikke afholdt\",($I22*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",_xlfn.IFS(R20=\"Planmæssigt\",\"-\",R20=\"Forsinket\",\"-\",R20=\"Ingen servering\",\"-\",R20=\"Pause ikke afholdt\",($J22*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D21=\"Fri\",\"-\",$D21=\"Forbered/afrig tid\",\"-\",$D21=\"Rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"optagelse\",_xlfn.IFS(S20=\"Planmæssigt\",\"-\",S20=\"Forsinket\",\"-\",S20=\"Ingen servering\",\"-\",S20=\"Pause ikke afholdt\",(K22*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D21=\"Fri\",\"-\",$D21=\"rejsetid\",\"-\",$D21=\"Rejsetid +50%\",\"-\",$D21=\"Sygdom\",\"-\",$D21=\"Optagelse\",(_xlfn.IFS(T22=\"-\",\"-\",T22=0,\"-\",T22<>0,T22*T21)),$D21=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D21=\"Fri\",0,$D21=\"optagelse\",(_xlfn.IFS(SUM(H23:T23)=0,0,SUM(H23:T23)>grundløn,SUM(H23:T23),SUM(H23:T23)<=grundløn,grundløn)),$D21=\"Forbered/afrig tid\",(IF(SUM(H23:T23)=0,0,SUM(H23:T23))),$D21=\"rejsetid\",(IF(SUM(H23:T23)=0,0,SUM(H23:T23))),$D21=\"rejsetid +50%\",(IF(SUM(H23:T23)=0,0,SUM(H23:T23))),$D21=\"sygdom\",(IF(SUM(H23:T23)=0,0,SUM(H23:T23))))","v":0}]
[]
[null,{"$f":"B20+1","v":"2024-03-13"},{"$f":"WEEKDAY(B25,1)","v":"1900-01-04"},"08:00:00","18:00:00",null,{"$f":"_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26<>\"Fri\",IF(AND(E25>0,D25>0),MOD((HOUR(E25)-HOUR(D25))+(MINUTE(E25)-MINUTE(D25))/60,24),0/24))","v":10},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G25=0,0,(IF(AND(G25>0,G25<=4),4,(IF(AND(G25>=4,G25<=8,G25<>0),G25,8)))))),_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"4\",$D26=\"Optagelse\",(IF(G25>0,8,0)),$D26=\"Forbered/afrig tid\",(IF(G25=0,0,(IF(AND(G25>0,G25<=4),4,(IF(AND(G25>=4,G25<=8,G25<>0),G25,8)))))),$D26=\"Rejsetid\",(IF(AND(G25>0,G25<=4),4,(IF(G25>=4,G25,0)))),$D26=\"Rejsetid +50%\",(IF(AND(G25>0,G25<=4),4,(IF(G25>=4,G25,0))))))","v":8},{"$f":"IF(OR(D26=\"Optagelse\",D26=\"Forbered/afrig tid\"),IF(G25>8,(G25-H25-J25-K25-L25),0),\"-\")","v":2},{"$f":"IF(OR($D26=\"Optagelse\",$D26=\"Forbered/afrig tid\"),IF(G25>10,(G25-H25-K25-L25)-2,0),\"-\")","v":0},{"$f":"IF(OR($D26=\"Optagelse\",$D26=\"Forbered/afrig tid\"),IF(G25>12,(G25-H25-L25)-4,0),\"-\")","v":0},{"$f":"IF(OR(D26=\"Optagelse\",$D26=\"Forbered/afrig tid\"),IF(G25>13,(G25-H25)-5,0),\"-\")","v":0},0.75,{"$f":"IF($D26=\"Optagelse\",ColTime(D25,E25,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":0},{"$f":"IF($D26=\"Optagelse\",ColTime(D25,E25,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":0},0,"Forsinket","Planmæssigt","Planmæssigt","Rabat A","Ingen diæt"]
[null,null,"Helligdag?","Optagelse",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D26=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D26=\"Fri\",\"-\",\"Timeløn\")))))","v":"Timeløn"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",D26=\"Forbered/afrig tid\",Datasheet!$C$56,D26=\"Optagelse\",Datasheet!$C$59)))","v":0.25},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",D26=\"Rejsetid\",\"-\",D26=\"Forbered/afrig tid\",Datasheet!$D$56,D26=\"Optagelse\",Datasheet!$D$59))","v":1},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D26=\"Fri\",\"-\",D26=\"Rejsetid\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",D26=\"Forbered/afrig tid\",Datasheet!$E$56,D26=\"Optagelse\",Datasheet!$E$59))","v":1.5},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",D26=\"Rejsetid\",\"-\",D26=\"Forbered/afrig tid\",Datasheet!$E$56,D26=\"Optagelse\",Datasheet!$F$59))","v":2},{"$f":"IF(AND($C27=\"Ja\",OR($D26=\"optagelse\",$D26=\"Forbered/afrig tid\")),_xlfn.IFS($D26=\"optagelse\",$G25+$P25,$D26=\"Forbered/afrig tid\",$G25),_xlfn.IFS($D26=\"Fri\",0,$D26=\"rejsetid\",0,$D26=\"rejsetid +50%\",0,$D26=\"sygdom\",0,$C25=1,IF(AND($C25=1,$D26=\"optagelse\"),$G25+$P25,G25),$C25=7,IF(AND($C25=7,$D26=\"optagelse\"),$G25+$P25,$G25),$C25=2,IF(($D25*24)<=6,ColTime($D25,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C25=3,0,$C25=4,0,$C25=5,0,$C25=6,IF(($D25*24)>6,ColTime($D25,$E25,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D26=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D26=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D26=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":0.75},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",(_xlfn.IFS(Q25=\"Planmæssigt\",\"-\",Q25=\"Forsinket\",\"Diæt\",Q25=\"Ingen servering\",\"Diæt\",Q25=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"Diæt"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",(_xlfn.IFS(R25=\"Planmæssigt\",\"-\",R25=\"Forsinket\",\"Diæt\",R25=\"Ingen servering\",\"Diæt\",R25=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",(_xlfn.IFS(S25=\"Planmæssigt\",\"-\",S25=\"Forsinket\",\"Diæt\",S25=\"Ingen servering\",\"Diæt\",S25=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T14=Datasheet!$B$49,\"-\",IF(D26=\"Optagelse\",_xlfn.IFS(T25=\"Ingen rabat\",\"-\",T25=\"Rabat A\",Datasheet!$B$96,T25=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":-0.1},{"$f":"IF(U25=\"Ingen diæt\",\"-\",U25)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Optagelse\",grundløn/8,$D26=\"rejsetid\",grundløn/8,$D26=\"rejsetid +50%\",(grundløn/8)*1.5,$D26=\"Forbered/afrig tid\",grundløn/8,$D26=\"Sygdom\",grundløn/8)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",$D26=\"Optagelse\",grundløn/8*$I26+grundløn/8,$D26=\"rejsetid\",\"-\",$D26=\"Forbered/afrig tid\",grundløn/8*$I26+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",$D26=\"Optagelse\",grundløn/8*$J26+grundløn/8,$D26=\"rejsetid\",\"-\",$D26=\"Forbered/afrig tid\",grundløn/8*$J26+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",$D26=\"Optagelse\",grundløn/8*$K26+grundløn/8,$D26=\"rejsetid\",\"-\",$D26=\"Forbered/afrig tid\",grundløn/8*$K26+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Rejsetid\",\"-\",D26=\"Rejsetid +50%\",\"-\",$D26=\"Optagelse\",grundløn/8*$L26+grundløn/8,$D26=\"rejsetid\",\"-\",$D26=\"Forbered/afrig tid\",grundløn/8*$L26+grundløn/8))","v":0},{"$f":"IF(AND(M26<>0,M26<>\"-\"),H27*M25,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D26=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":100},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D26=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":200},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D26=\"Optagelse\",((grundløn/8)*P26),\"-\"))","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",_xlfn.IFS(Q25=\"Planmæssigt\",\"-\",Q25=\"Forsinket\",Datasheet!$B$88,Q25=\"Ingen servering\",Datasheet!$B$88,Q25=\"Pause ikke afholdt\",Datasheet!$B$88))","v":172.2},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",_xlfn.IFS(R25=\"Planmæssigt\",\"-\",R25=\"Forsinket\",Datasheet!$B$88,R25=\"Ingen servering\",Datasheet!$B$88,R25=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",_xlfn.IFS(S25=\"Planmæssigt\",\"-\",S25=\"Forsinket\",Datasheet!$B$88,S25=\"Ingen servering\",Datasheet!$B$88,S25=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T14=Datasheet!$B$49,\"-\",(_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Optagelse\",(IF(T25=\"Ingen rabat\",\"-\",(SUM(H28:S28)))))))","v":0},{"$f":"IF(OR($Q26<>\"-\",$R26<>\"-\",$S26<>\"-\",D26=\"Fri\"),\"-\",_xlfn.IFS(U26=\"-\",\"-\",U26=\"Morgen\",86.1,U26=\"Morgen+Frokost\",258.3,U26=\"Frokost el. Aften\",172.2,U26=\"Frokost+Aften\", 344.4,U26=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q27:S27)+SUM(U27)","v":172.2}]
[null,null,null,null,null,null,null,{"$f":"IF($D26=\"Fri\",\"-\",(IF(H25>0,H27*H25,\"-\")))","v":0},{"$f":"IF(AND(I25<>\"-\",I27<>\"-\"),I27*I25,\"-\")","v":0},{"$f":"IF(AND(J25<>\"-\",J27<>\"-\"),J27*J25,\"-\")","v":0},0,0,{"$f":"IF(M27<>\"-\",M27*M26,\"-\")","v":"-"},{"$f":"IF(AND(N25<>\"-\",N27<>\"-\"),N27*N25,\"-\")","v":0},{"$f":"IF(AND(O25<>\"-\",O27<>\"-\"),O27*O25,\"-\")","v":0},{"$f":"IF(AND(P25<>\"-\",P27<>\"-\"),P27*P25,\"-\")","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",_xlfn.IFS(Q25=\"Planmæssigt\",\"-\",Q25=\"Forsinket\",\"-\",Q25=\"Ingen servering\",\"-\",Q25=\"Pause ikke afholdt\",($I27*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",_xlfn.IFS(R25=\"Planmæssigt\",\"-\",R25=\"Forsinket\",\"-\",R25=\"Ingen servering\",\"-\",R25=\"Pause ikke afholdt\",($J27*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D26=\"Fri\",\"-\",$D26=\"Forbered/afrig tid\",\"-\",$D26=\"Rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"optagelse\",_xlfn.IFS(S25=\"Planmæssigt\",\"-\",S25=\"Forsinket\",\"-\",S25=\"Ingen servering\",\"-\",S25=\"Pause ikke afholdt\",(K27*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D26=\"Fri\",\"-\",$D26=\"rejsetid\",\"-\",$D26=\"Rejsetid +50%\",\"-\",$D26=\"Sygdom\",\"-\",$D26=\"Optagelse\",(_xlfn.IFS(T27=\"-\",\"-\",T27=0,\"-\",T27<>0,T27*T26)),$D26=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D26=\"Fri\",0,$D26=\"optagelse\",(_xlfn.IFS(SUM(H28:T28)=0,0,SUM(H28:T28)>grundløn,SUM(H28:T28),SUM(H28:T28)<=grundløn,grundløn)),$D26=\"Forbered/afrig tid\",(IF(SUM(H28:T28)=0,0,SUM(H28:T28))),$D26=\"rejsetid\",(IF(SUM(H28:T28)=0,0,SUM(H28:T28))),$D26=\"rejsetid +50%\",(IF(SUM(H28:T28)=0,0,SUM(H28:T28))),$D26=\"sygdom\",(IF(SUM(H28:T28)=0,0,SUM(H28:T28))))","v":0}]
[]
[null,{"$f":"B25+1","v":"2024-03-14"},{"$f":"WEEKDAY(B30,1)","v":"1900-01-05"},"08:00:00","18:00:00",null,{"$f":"_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31<>\"Fri\",IF(AND(E30>0,D30>0),MOD((HOUR(E30)-HOUR(D30))+(MINUTE(E30)-MINUTE(D30))/60,24),0/24))","v":10},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G30=0,0,(IF(AND(G30>0,G30<=4),4,(IF(AND(G30>=4,G30<=8,G30<>0),G30,8)))))),_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"4\",$D31=\"Optagelse\",(IF(G30>0,8,0)),$D31=\"Forbered/afrig tid\",(IF(G30=0,0,(IF(AND(G30>0,G30<=4),4,(IF(AND(G30>=4,G30<=8,G30<>0),G30,8)))))),$D31=\"Rejsetid\",(IF(AND(G30>0,G30<=4),4,(IF(G30>=4,G30,0)))),$D31=\"Rejsetid +50%\",(IF(AND(G30>0,G30<=4),4,(IF(G30>=4,G30,0))))))","v":8},{"$f":"IF(OR(D31=\"Optagelse\",D31=\"Forbered/afrig tid\"),IF(G30>8,(G30-H30-J30-K30-L30),0),\"-\")","v":2},{"$f":"IF(OR($D31=\"Optagelse\",$D31=\"Forbered/afrig tid\"),IF(G30>10,(G30-H30-K30-L30)-2,0),\"-\")","v":0},{"$f":"IF(OR($D31=\"Optagelse\",$D31=\"Forbered/afrig tid\"),IF(G30>12,(G30-H30-L30)-4,0),\"-\")","v":0},{"$f":"IF(OR(D31=\"Optagelse\",$D31=\"Forbered/afrig tid\"),IF(G30>13,(G30-H30)-5,0),\"-\")","v":0},0.75,{"$f":"IF($D31=\"Optagelse\",ColTime(D30,E30,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":0},{"$f":"IF($D31=\"Optagelse\",ColTime(D30,E30,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":0},0,"Planmæssigt","Planmæssigt","Planmæssigt","Rabat A","Ingen diæt"]
[null,null,"Helligdag?","Optagelse",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D31=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D31=\"Fri\",\"-\",\"Timeløn\")))))","v":"Timeløn"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",D31=\"Forbered/afrig tid\",Datasheet!$C$56,D31=\"Optagelse\",Datasheet!$C$59)))","v":0.25},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",D31=\"Rejsetid\",\"-\",D31=\"Forbered/afrig tid\",Datasheet!$D$56,D31=\"Optagelse\",Datasheet!$D$59))","v":1},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D31=\"Fri\",\"-\",D31=\"Rejsetid\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",D31=\"Forbered/afrig tid\",Datasheet!$E$56,D31=\"Optagelse\",Datasheet!$E$59))","v":1.5},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",D31=\"Rejsetid\",\"-\",D31=\"Forbered/afrig tid\",Datasheet!$E$56,D31=\"Optagelse\",Datasheet!$F$59))","v":2},{"$f":"IF(AND($C32=\"Ja\",OR($D31=\"optagelse\",$D31=\"Forbered/afrig tid\")),_xlfn.IFS($D31=\"optagelse\",$G30+$P30,$D31=\"Forbered/afrig tid\",$G30),_xlfn.IFS($D31=\"Fri\",0,$D31=\"rejsetid\",0,$D31=\"rejsetid +50%\",0,$D31=\"sygdom\",0,$C30=1,IF(AND($C30=1,$D31=\"optagelse\"),$G30+$P30,G30),$C30=7,IF(AND($C30=7,$D31=\"optagelse\"),$G30+$P30,$G30),$C30=2,IF(($D30*24)<=6,ColTime($D30,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C30=3,0,$C30=4,0,$C30=5,0,$C30=6,IF(($D30*24)>6,ColTime($D30,$E30,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D31=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D31=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"Timetillæg"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D31=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":0.75},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",(_xlfn.IFS(Q30=\"Planmæssigt\",\"-\",Q30=\"Forsinket\",\"Diæt\",Q30=\"Ingen servering\",\"Diæt\",Q30=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",(_xlfn.IFS(R30=\"Planmæssigt\",\"-\",R30=\"Forsinket\",\"Diæt\",R30=\"Ingen servering\",\"Diæt\",R30=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",(_xlfn.IFS(S30=\"Planmæssigt\",\"-\",S30=\"Forsinket\",\"Diæt\",S30=\"Ingen servering\",\"Diæt\",S30=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T19=Datasheet!$B$49,\"-\",IF(D31=\"Optagelse\",_xlfn.IFS(T30=\"Ingen rabat\",\"-\",T30=\"Rabat A\",Datasheet!$B$96,T30=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":-0.1},{"$f":"IF(U30=\"Ingen diæt\",\"-\",U30)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Optagelse\",grundløn/8,$D31=\"rejsetid\",grundløn/8,$D31=\"rejsetid +50%\",(grundløn/8)*1.5,$D31=\"Forbered/afrig tid\",grundløn/8,$D31=\"Sygdom\",grundløn/8)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",$D31=\"Optagelse\",grundløn/8*$I31+grundløn/8,$D31=\"rejsetid\",\"-\",$D31=\"Forbered/afrig tid\",grundløn/8*$I31+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",$D31=\"Optagelse\",grundløn/8*$J31+grundløn/8,$D31=\"rejsetid\",\"-\",$D31=\"Forbered/afrig tid\",grundløn/8*$J31+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",$D31=\"Optagelse\",grundløn/8*$K31+grundløn/8,$D31=\"rejsetid\",\"-\",$D31=\"Forbered/afrig tid\",grundløn/8*$K31+grundløn/8))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Rejsetid\",\"-\",D31=\"Rejsetid +50%\",\"-\",$D31=\"Optagelse\",grundløn/8*$L31+grundløn/8,$D31=\"rejsetid\",\"-\",$D31=\"Forbered/afrig tid\",grundløn/8*$L31+grundløn/8))","v":0},{"$f":"IF(AND(M31<>0,M31<>\"-\"),H32*M30,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D31=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":100},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D31=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":200},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D31=\"Optagelse\",((grundløn/8)*P31),\"-\"))","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",_xlfn.IFS(Q30=\"Planmæssigt\",\"-\",Q30=\"Forsinket\",Datasheet!$B$88,Q30=\"Ingen servering\",Datasheet!$B$88,Q30=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",_xlfn.IFS(R30=\"Planmæssigt\",\"-\",R30=\"Forsinket\",Datasheet!$B$88,R30=\"Ingen servering\",Datasheet!$B$88,R30=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",_xlfn.IFS(S30=\"Planmæssigt\",\"-\",S30=\"Forsinket\",Datasheet!$B$88,S30=\"Ingen servering\",Datasheet!$B$88,S30=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T19=Datasheet!$B$49,\"-\",(_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Optagelse\",(IF(T30=\"Ingen rabat\",\"-\",(SUM(H33:S33)))))))","v":0},{"$f":"IF(OR($Q31<>\"-\",$R31<>\"-\",$S31<>\"-\",D31=\"Fri\"),\"-\",_xlfn.IFS(U31=\"-\",\"-\",U31=\"Morgen\",86.1,U31=\"Morgen+Frokost\",258.3,U31=\"Frokost el. Aften\",172.2,U31=\"Frokost+Aften\", 344.4,U31=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q32:S32)+SUM(U32)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($D31=\"Fri\",\"-\",(IF(H30>0,H32*H30,\"-\")))","v":0},{"$f":"IF(AND(I30<>\"-\",I32<>\"-\"),I32*I30,\"-\")","v":0},{"$f":"IF(AND(J30<>\"-\",J32<>\"-\"),J32*J30,\"-\")","v":0},0,0,{"$f":"IF(M32<>\"-\",M32*M31,\"-\")","v":"-"},{"$f":"IF(AND(N30<>\"-\",N32<>\"-\"),N32*N30,\"-\")","v":0},{"$f":"IF(AND(O30<>\"-\",O32<>\"-\"),O32*O30,\"-\")","v":0},{"$f":"IF(AND(P30<>\"-\",P32<>\"-\"),P32*P30,\"-\")","v":0},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",_xlfn.IFS(Q30=\"Planmæssigt\",\"-\",Q30=\"Forsinket\",\"-\",Q30=\"Ingen servering\",\"-\",Q30=\"Pause ikke afholdt\",($I32*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",_xlfn.IFS(R30=\"Planmæssigt\",\"-\",R30=\"Forsinket\",\"-\",R30=\"Ingen servering\",\"-\",R30=\"Pause ikke afholdt\",($J32*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D31=\"Fri\",\"-\",$D31=\"Forbered/afrig tid\",\"-\",$D31=\"Rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"optagelse\",_xlfn.IFS(S30=\"Planmæssigt\",\"-\",S30=\"Forsinket\",\"-\",S30=\"Ingen servering\",\"-\",S30=\"Pause ikke afholdt\",(K32*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D31=\"Fri\",\"-\",$D31=\"rejsetid\",\"-\",$D31=\"Rejsetid +50%\",\"-\",$D31=\"Sygdom\",\"-\",$D31=\"Optagelse\",(_xlfn.IFS(T32=\"-\",\"-\",T32=0,\"-\",T32<>0,T32*T31)),$D31=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D31=\"Fri\",0,$D31=\"optagelse\",(_xlfn.IFS(SUM(H33:T33)=0,0,SUM(H33:T33)>grundløn,SUM(H33:T33),SUM(H33:T33)<=grundløn,grundløn)),$D31=\"Forbered/afrig tid\",(IF(SUM(H33:T33)=0,0,SUM(H33:T33))),$D31=\"rejsetid\",(IF(SUM(H33:T33)=0,0,SUM(H33:T33))),$D31=\"rejsetid +50%\",(IF(SUM(H33:T33)=0,0,SUM(H33:T33))),$D31=\"sygdom\",(IF(SUM(H33:T33)=0,0,SUM(H33:T33))))","v":0}]
[]
[null,{"$f":"B30+1","v":"2024-03-15"},{"$f":"WEEKDAY(B35,1)","v":"1900-01-06"},"08:00:00","16:00:00",null,{"$f":"_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36<>\"Fri\",IF(AND(E35>0,D35>0),MOD((HOUR(E35)-HOUR(D35))+(MINUTE(E35)-MINUTE(D35))/60,24),0/24))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G35=0,0,(IF(AND(G35>0,G35<=4),4,(IF(AND(G35>=4,G35<=8,G35<>0),G35,8)))))),_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"4\",$D36=\"Optagelse\",(IF(G35>0,8,0)),$D36=\"Forbered/afrig tid\",(IF(G35=0,0,(IF(AND(G35>0,G35<=4),4,(IF(AND(G35>=4,G35<=8,G35<>0),G35,8)))))),$D36=\"Rejsetid\",(IF(AND(G35>0,G35<=4),4,(IF(G35>=4,G35,0)))),$D36=\"Rejsetid +50%\",(IF(AND(G35>0,G35<=4),4,(IF(G35>=4,G35,0))))))","v":"-"},{"$f":"IF(OR(D36=\"Optagelse\",D36=\"Forbered/afrig tid\"),IF(G35>8,(G35-H35-J35-K35-L35),0),\"-\")","v":"-"},{"$f":"IF(OR($D36=\"Optagelse\",$D36=\"Forbered/afrig tid\"),IF(G35>10,(G35-H35-K35-L35)-2,0),\"-\")","v":"-"},{"$f":"IF(OR($D36=\"Optagelse\",$D36=\"Forbered/afrig tid\"),IF(G35>12,(G35-H35-L35)-4,0),\"-\")","v":"-"},{"$f":"IF(OR(D36=\"Optagelse\",$D36=\"Forbered/afrig tid\"),IF(G35>13,(G35-H35)-5,0),\"-\")","v":"-"},0.75,{"$f":"IF($D36=\"Optagelse\",ColTime(D35,E35,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":"-"},{"$f":"IF($D36=\"Optagelse\",ColTime(D35,E35,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":"-"},0,"Forsinket","Planmæssigt","Planmæssigt","Ingen rabat","Ingen diæt"]
[null,null,"Helligdag?","Fri",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D36=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D36=\"Fri\",\"-\",\"Timeløn\")))))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",D36=\"Forbered/afrig tid\",Datasheet!$C$56,D36=\"Optagelse\",Datasheet!$C$59)))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",D36=\"Rejsetid\",\"-\",D36=\"Forbered/afrig tid\",Datasheet!$D$56,D36=\"Optagelse\",Datasheet!$D$59))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D36=\"Fri\",\"-\",D36=\"Rejsetid\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",D36=\"Forbered/afrig tid\",Datasheet!$E$56,D36=\"Optagelse\",Datasheet!$E$59))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",D36=\"Rejsetid\",\"-\",D36=\"Forbered/afrig tid\",Datasheet!$E$56,D36=\"Optagelse\",Datasheet!$F$59))","v":"-"},{"$f":"IF(AND($C37=\"Ja\",OR($D36=\"optagelse\",$D36=\"Forbered/afrig tid\")),_xlfn.IFS($D36=\"optagelse\",$G35+$P35,$D36=\"Forbered/afrig tid\",$G35),_xlfn.IFS($D36=\"Fri\",0,$D36=\"rejsetid\",0,$D36=\"rejsetid +50%\",0,$D36=\"sygdom\",0,$C35=1,IF(AND($C35=1,$D36=\"optagelse\"),$G35+$P35,G35),$C35=7,IF(AND($C35=7,$D36=\"optagelse\"),$G35+$P35,$G35),$C35=2,IF(($D35*24)<=6,ColTime($D35,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C35=3,0,$C35=4,0,$C35=5,0,$C35=6,IF(($D35*24)>6,ColTime($D35,$E35,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D36=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D36=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D36=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":"-"},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",(_xlfn.IFS(Q35=\"Planmæssigt\",\"-\",Q35=\"Forsinket\",\"Diæt\",Q35=\"Ingen servering\",\"Diæt\",Q35=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",(_xlfn.IFS(R35=\"Planmæssigt\",\"-\",R35=\"Forsinket\",\"Diæt\",R35=\"Ingen servering\",\"Diæt\",R35=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",(_xlfn.IFS(S35=\"Planmæssigt\",\"-\",S35=\"Forsinket\",\"Diæt\",S35=\"Ingen servering\",\"Diæt\",S35=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T24=Datasheet!$B$49,\"-\",IF(D36=\"Optagelse\",_xlfn.IFS(T35=\"Ingen rabat\",\"-\",T35=\"Rabat A\",Datasheet!$B$96,T35=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":"-"},{"$f":"IF(U35=\"Ingen diæt\",\"-\",U35)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Optagelse\",grundløn/8,$D36=\"rejsetid\",grundløn/8,$D36=\"rejsetid +50%\",(grundløn/8)*1.5,$D36=\"Forbered/afrig tid\",grundløn/8,$D36=\"Sygdom\",grundløn/8)))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",$D36=\"Optagelse\",grundløn/8*$I36+grundløn/8,$D36=\"rejsetid\",\"-\",$D36=\"Forbered/afrig tid\",grundløn/8*$I36+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",$D36=\"Optagelse\",grundløn/8*$J36+grundløn/8,$D36=\"rejsetid\",\"-\",$D36=\"Forbered/afrig tid\",grundløn/8*$J36+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",$D36=\"Optagelse\",grundløn/8*$K36+grundløn/8,$D36=\"rejsetid\",\"-\",$D36=\"Forbered/afrig tid\",grundløn/8*$K36+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Rejsetid\",\"-\",D36=\"Rejsetid +50%\",\"-\",$D36=\"Optagelse\",grundløn/8*$L36+grundløn/8,$D36=\"rejsetid\",\"-\",$D36=\"Forbered/afrig tid\",grundløn/8*$L36+grundløn/8))","v":"-"},{"$f":"IF(AND(M36<>0,M36<>\"-\"),H37*M35,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D36=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D36=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D36=\"Optagelse\",((grundløn/8)*P36),\"-\"))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",_xlfn.IFS(Q35=\"Planmæssigt\",\"-\",Q35=\"Forsinket\",Datasheet!$B$88,Q35=\"Ingen servering\",Datasheet!$B$88,Q35=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",_xlfn.IFS(R35=\"Planmæssigt\",\"-\",R35=\"Forsinket\",Datasheet!$B$88,R35=\"Ingen servering\",Datasheet!$B$88,R35=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",_xlfn.IFS(S35=\"Planmæssigt\",\"-\",S35=\"Forsinket\",Datasheet!$B$88,S35=\"Ingen servering\",Datasheet!$B$88,S35=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T24=Datasheet!$B$49,\"-\",(_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Optagelse\",(IF(T35=\"Ingen rabat\",\"-\",(SUM(H38:S38)))))))","v":"-"},{"$f":"IF(OR(Q36<>\"-\",R36<>\"-\",S36<>\"-\",D36=\"Fri\"),\"-\",_xlfn.IFS(U36=\"-\",\"-\",U36=\"Morgen\",86.1,U36=\"Morgen+Frokost\",258.3,U36=\"Frokost el. Aften\",172.2,U36=\"Frokost+Aften\", 344.4,U36=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q37:S37)+SUM(U37)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($D36=\"Fri\",\"-\",(IF(H35>0,H37*H35,\"-\")))","v":"-"},{"$f":"IF(AND(I35<>\"-\",I37<>\"-\"),I37*I35,\"-\")","v":"-"},{"$f":"IF(AND(J35<>\"-\",J37<>\"-\"),J37*J35,\"-\")","v":"-"},"-","-",{"$f":"IF(M37<>\"-\",M37*M36,\"-\")","v":"-"},{"$f":"IF(AND(N35<>\"-\",N37<>\"-\"),N37*N35,\"-\")","v":"-"},{"$f":"IF(AND(O35<>\"-\",O37<>\"-\"),O37*O35,\"-\")","v":"-"},{"$f":"IF(AND(P35<>\"-\",P37<>\"-\"),P37*P35,\"-\")","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",_xlfn.IFS(Q35=\"Planmæssigt\",\"-\",Q35=\"Forsinket\",\"-\",Q35=\"Ingen servering\",\"-\",Q35=\"Pause ikke afholdt\",($I37*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",_xlfn.IFS(R35=\"Planmæssigt\",\"-\",R35=\"Forsinket\",\"-\",R35=\"Ingen servering\",\"-\",R35=\"Pause ikke afholdt\",($J37*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D36=\"Fri\",\"-\",$D36=\"Forbered/afrig tid\",\"-\",$D36=\"Rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"optagelse\",_xlfn.IFS(S35=\"Planmæssigt\",\"-\",S35=\"Forsinket\",\"-\",S35=\"Ingen servering\",\"-\",S35=\"Pause ikke afholdt\",(K37*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D36=\"Fri\",\"-\",$D36=\"rejsetid\",\"-\",$D36=\"Rejsetid +50%\",\"-\",$D36=\"Sygdom\",\"-\",$D36=\"Optagelse\",(_xlfn.IFS(T37=\"-\",\"-\",T37=0,\"-\",T37<>0,T37*T36)),$D36=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D36=\"Fri\",0,$D36=\"optagelse\",(_xlfn.IFS(SUM(H38:T38)=0,0,SUM(H38:T38)>grundløn,SUM(H38:T38),SUM(H38:T38)<=grundløn,grundløn)),$D36=\"Forbered/afrig tid\",(IF(SUM(H38:T38)=0,0,SUM(H38:T38))),$D36=\"rejsetid\",(IF(SUM(H38:T38)=0,0,SUM(H38:T38))),$D36=\"rejsetid +50%\",(IF(SUM(H38:T38)=0,0,SUM(H38:T38))),$D36=\"sygdom\",(IF(SUM(H38:T38)=0,0,SUM(H38:T38))))","v":0}]
[]
[null,{"$f":"B35+1","v":"2024-03-16"},{"$f":"WEEKDAY(B40,1)","v":"1900-01-07"},"08:00:00","16:00:00",null,{"$f":"_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41<>\"Fri\",IF(AND(E40>0,D40>0),MOD((HOUR(E40)-HOUR(D40))+(MINUTE(E40)-MINUTE(D40))/60,24),0/24))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G40=0,0,(IF(AND(G40>0,G40<=4),4,(IF(AND(G40>=4,G40<=8,G40<>0),G40,8)))))),_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"4\",$D41=\"Optagelse\",(IF(G40>0,8,0)),$D41=\"Forbered/afrig tid\",(IF(G40=0,0,(IF(AND(G40>0,G40<=4),4,(IF(AND(G40>=4,G40<=8,G40<>0),G40,8)))))),$D41=\"Rejsetid\",(IF(AND(G40>0,G40<=4),4,(IF(G40>=4,G40,0)))),$D41=\"Rejsetid +50%\",(IF(AND(G40>0,G40<=4),4,(IF(G40>=4,G40,0))))))","v":"-"},{"$f":"IF(OR(D41=\"Optagelse\",D41=\"Forbered/afrig tid\"),IF(G40>8,(G40-H40-J40-K40-L40),0),\"-\")","v":"-"},{"$f":"IF(OR($D41=\"Optagelse\",$D41=\"Forbered/afrig tid\"),IF(G40>10,(G40-H40-K40-L40)-2,0),\"-\")","v":"-"},{"$f":"IF(OR($D41=\"Optagelse\",$D41=\"Forbered/afrig tid\"),IF(G40>12,(G40-H40-L40)-4,0),\"-\")","v":"-"},{"$f":"IF(OR(D41=\"Optagelse\",$D41=\"Forbered/afrig tid\"),IF(G40>13,(G40-H40)-5,0),\"-\")","v":"-"},0.75,{"$f":"IF($D41=\"Optagelse\",ColTime(D40,E40,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":"-"},{"$f":"IF($D41=\"Optagelse\",ColTime(D40,E40,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":"-"},0,"Planmæssigt","Planmæssigt","Planmæssigt","Ingen rabat","Ingen diæt"]
[null,null,"Helligdag?","Fri",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D41=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D41=\"Fri\",\"-\",\"Timeløn\")))))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",D41=\"Forbered/afrig tid\",Datasheet!$C$56,D41=\"Optagelse\",Datasheet!$C$59)))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",D41=\"Rejsetid\",\"-\",D41=\"Forbered/afrig tid\",Datasheet!$D$56,D41=\"Optagelse\",Datasheet!$D$59))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D41=\"Fri\",\"-\",D41=\"Rejsetid\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",D41=\"Forbered/afrig tid\",Datasheet!$E$56,D41=\"Optagelse\",Datasheet!$E$59))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",D41=\"Rejsetid\",\"-\",D41=\"Forbered/afrig tid\",Datasheet!$E$56,D41=\"Optagelse\",Datasheet!$F$59))","v":"-"},{"$f":"IF(AND($C42=\"Ja\",OR($D41=\"optagelse\",$D41=\"Forbered/afrig tid\")),_xlfn.IFS($D41=\"optagelse\",$G40+$P40,$D41=\"Forbered/afrig tid\",$G40),_xlfn.IFS($D41=\"Fri\",0,$D41=\"rejsetid\",0,$D41=\"rejsetid +50%\",0,$D41=\"sygdom\",0,$C40=1,IF(AND($C40=1,$D41=\"optagelse\"),$G40+$P40,G40),$C40=7,IF(AND($C40=7,$D41=\"optagelse\"),$G40+$P40,$G40),$C40=2,IF(($D40*24)<=6,ColTime($D40,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C40=3,0,$C40=4,0,$C40=5,0,$C40=6,IF(($D40*24)>6,ColTime($D40,$E40,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D41=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D41=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D41=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":"-"},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",(_xlfn.IFS(Q40=\"Planmæssigt\",\"-\",Q40=\"Forsinket\",\"Diæt\",Q40=\"Ingen servering\",\"Diæt\",Q40=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",(_xlfn.IFS(R40=\"Planmæssigt\",\"-\",R40=\"Forsinket\",\"Diæt\",R40=\"Ingen servering\",\"Diæt\",R40=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",(_xlfn.IFS(S40=\"Planmæssigt\",\"-\",S40=\"Forsinket\",\"Diæt\",S40=\"Ingen servering\",\"Diæt\",S40=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T29=Datasheet!$B$49,\"-\",IF(D41=\"Optagelse\",_xlfn.IFS(T40=\"Ingen rabat\",\"-\",T40=\"Rabat A\",Datasheet!$B$96,T40=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":"-"},{"$f":"IF(U40=\"Ingen diæt\",\"-\",U40)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Optagelse\",grundløn/8,$D41=\"rejsetid\",grundløn/8,$D41=\"rejsetid +50%\",(grundløn/8)*1.5,$D41=\"Forbered/afrig tid\",grundløn/8,$D41=\"Sygdom\",grundløn/8)))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",$D41=\"Optagelse\",grundløn/8*$I41+grundløn/8,$D41=\"rejsetid\",\"-\",$D41=\"Forbered/afrig tid\",grundløn/8*$I41+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",$D41=\"Optagelse\",grundløn/8*$J41+grundløn/8,$D41=\"rejsetid\",\"-\",$D41=\"Forbered/afrig tid\",grundløn/8*$J41+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",$D41=\"Optagelse\",grundløn/8*$K41+grundløn/8,$D41=\"rejsetid\",\"-\",$D41=\"Forbered/afrig tid\",grundløn/8*$K41+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Rejsetid\",\"-\",D41=\"Rejsetid +50%\",\"-\",$D41=\"Optagelse\",grundløn/8*$L41+grundløn/8,$D41=\"rejsetid\",\"-\",$D41=\"Forbered/afrig tid\",grundløn/8*$L41+grundløn/8))","v":"-"},{"$f":"IF(AND(M41<>0,M41<>\"-\"),H42*M40,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D41=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D41=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D41=\"Optagelse\",((grundløn/8)*P41),\"-\"))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",_xlfn.IFS(Q40=\"Planmæssigt\",\"-\",Q40=\"Forsinket\",Datasheet!$B$88,Q40=\"Ingen servering\",Datasheet!$B$88,Q40=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",_xlfn.IFS(R40=\"Planmæssigt\",\"-\",R40=\"Forsinket\",Datasheet!$B$88,R40=\"Ingen servering\",Datasheet!$B$88,R40=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",_xlfn.IFS(S40=\"Planmæssigt\",\"-\",S40=\"Forsinket\",Datasheet!$B$88,S40=\"Ingen servering\",Datasheet!$B$88,S40=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T29=Datasheet!$B$49,\"-\",(_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Optagelse\",(IF(T40=\"Ingen rabat\",\"-\",(SUM(H43:S43)))))))","v":"-"},{"$f":"IF(OR(Q41<>\"-\",R41<>\"-\",S41<>\"-\",D41=\"Fri\"),\"-\",_xlfn.IFS(U41=\"-\",\"-\",U41=\"Morgen\",86.1,U41=\"Morgen+Frokost\",258.3,U41=\"Frokost el. Aften\",172.2,U41=\"Frokost+Aften\", 344.4,U41=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q42:S42)+SUM(U42)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($D41=\"Fri\",\"-\",(IF(H40>0,H42*H40,\"-\")))","v":"-"},{"$f":"IF(AND(I40<>\"-\",I42<>\"-\"),I42*I40,\"-\")","v":"-"},{"$f":"IF(AND(J40<>\"-\",J42<>\"-\"),J42*J40,\"-\")","v":"-"},"-","-",{"$f":"IF(M42<>\"-\",M42*M41,\"-\")","v":"-"},{"$f":"IF(AND(N40<>\"-\",N42<>\"-\"),N42*N40,\"-\")","v":"-"},{"$f":"IF(AND(O40<>\"-\",O42<>\"-\"),O42*O40,\"-\")","v":"-"},{"$f":"IF(AND(P40<>\"-\",P42<>\"-\"),P42*P40,\"-\")","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",_xlfn.IFS(Q40=\"Planmæssigt\",\"-\",Q40=\"Forsinket\",\"-\",Q40=\"Ingen servering\",\"-\",Q40=\"Pause ikke afholdt\",($I42*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",_xlfn.IFS(R40=\"Planmæssigt\",\"-\",R40=\"Forsinket\",\"-\",R40=\"Ingen servering\",\"-\",R40=\"Pause ikke afholdt\",($J42*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D41=\"Fri\",\"-\",$D41=\"Forbered/afrig tid\",\"-\",$D41=\"Rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"optagelse\",_xlfn.IFS(S40=\"Planmæssigt\",\"-\",S40=\"Forsinket\",\"-\",S40=\"Ingen servering\",\"-\",S40=\"Pause ikke afholdt\",(K42*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D41=\"Fri\",\"-\",$D41=\"rejsetid\",\"-\",$D41=\"Rejsetid +50%\",\"-\",$D41=\"Sygdom\",\"-\",$D41=\"Optagelse\",(_xlfn.IFS(T42=\"-\",\"-\",T42=0,\"-\",T42<>0,T42*T41)),$D41=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D41=\"Fri\",0,$D41=\"optagelse\",(_xlfn.IFS(SUM(H43:T43)=0,0,SUM(H43:T43)>grundløn,SUM(H43:T43),SUM(H43:T43)<=grundløn,grundløn)),$D41=\"Forbered/afrig tid\",(IF(SUM(H43:T43)=0,0,SUM(H43:T43))),$D41=\"rejsetid\",(IF(SUM(H43:T43)=0,0,SUM(H43:T43))),$D41=\"rejsetid +50%\",(IF(SUM(H43:T43)=0,0,SUM(H43:T43))),$D41=\"sygdom\",(IF(SUM(H43:T43)=0,0,SUM(H43:T43))))","v":0}]
[]
[null,{"$f":"B40+1","v":"2024-03-17"},{"$f":"WEEKDAY(B45,1)","v":"1900-01-01"},"08:00:00","16:00:00",null,{"$f":"_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46<>\"Fri\",IF(AND(E45>0,D45>0),MOD((HOUR(E45)-HOUR(D45))+(MINUTE(E45)-MINUTE(D45))/60,24),0/24))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,(IF(G45=0,0,(IF(AND(G45>0,G45<=4),4,(IF(AND(G45>=4,G45<=8,G45<>0),G45,8)))))),_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"4\",$D46=\"Optagelse\",(IF(G45>0,8,0)),$D46=\"Forbered/afrig tid\",(IF(G45=0,0,(IF(AND(G45>0,G45<=4),4,(IF(AND(G45>=4,G45<=8,G45<>0),G45,8)))))),$D46=\"Rejsetid\",(IF(AND(G45>0,G45<=4),4,(IF(G45>=4,G45,0)))),$D46=\"Rejsetid +50%\",(IF(AND(G45>0,G45<=4),4,(IF(G45>=4,G45,0))))))","v":"-"},{"$f":"IF(OR(D46=\"Optagelse\",D46=\"Forbered/afrig tid\"),IF(G45>8,(G45-H45-J45-K45-L45),0),\"-\")","v":"-"},{"$f":"IF(OR($D46=\"Optagelse\",$D46=\"Forbered/afrig tid\"),IF(G45>10,(G45-H45-K45-L45)-2,0),\"-\")","v":"-"},{"$f":"IF(OR($D46=\"Optagelse\",$D46=\"Forbered/afrig tid\"),IF(G45>12,(G45-H45-L45)-4,0),\"-\")","v":"-"},{"$f":"IF(OR(D46=\"Optagelse\",$D46=\"Forbered/afrig tid\"),IF(G45>13,(G45-H45)-5,0),\"-\")","v":"-"},0.75,{"$f":"IF($D46=\"Optagelse\",ColTime(D45,E45,Datasheet!$C$82,Datasheet!$C$83)*24,\"-\")","v":"-"},{"$f":"IF($D46=\"Optagelse\",ColTime(D45,E45,Datasheet!$C$83,Datasheet!$C$84)*24,\"-\")","v":"-"},0,"Planmæssigt","Planmæssigt","Planmæssigt","Ingen rabat","Ingen diæt"]
[null,null,"Helligdag?","Fri",null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,\"Timeløn\",(IF(D46=\"Rejsetid +50%\",\"Timeløn +50%\",(IF(D46=\"Fri\",\"-\",\"Timeløn\")))))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$65,(_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",D46=\"Forbered/afrig tid\",Datasheet!$C$56,D46=\"Optagelse\",Datasheet!$C$59)))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",D46=\"Rejsetid\",\"-\",D46=\"Forbered/afrig tid\",Datasheet!$D$56,D46=\"Optagelse\",Datasheet!$D$59))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 1\",_xlfn.IFS(D46=\"Fri\",\"-\",D46=\"Rejsetid\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",D46=\"Forbered/afrig tid\",Datasheet!$E$56,D46=\"Optagelse\",Datasheet!$E$59))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"Rate 2\",_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",D46=\"Rejsetid\",\"-\",D46=\"Forbered/afrig tid\",Datasheet!$E$56,D46=\"Optagelse\",Datasheet!$F$59))","v":"-"},{"$f":"IF(AND($C47=\"Ja\",OR($D46=\"optagelse\",$D46=\"Forbered/afrig tid\")),_xlfn.IFS($D46=\"optagelse\",$G45+$P45,$D46=\"Forbered/afrig tid\",$G45),_xlfn.IFS($D46=\"Fri\",0,$D46=\"rejsetid\",0,$D46=\"rejsetid +50%\",0,$D46=\"sygdom\",0,$C45=1,IF(AND($C45=1,$D46=\"optagelse\"),$G45+$P45,G45),$C45=7,IF(AND($C45=7,$D46=\"optagelse\"),$G45+$P45,$G45),$C45=2,IF(($D45*24)<=6,ColTime($D45,6,Datasheet!$C$83,Datasheet!$C$84)*24,0),$C45=3,0,$C45=4,0,$C45=5,0,$C45=6,IF(($D45*24)>6,ColTime($D45,$E45,Datasheet!$C$83,Datasheet!$C$84)*24,0)))","v":0},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D46=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D46=\"Optagelse\",\"Timetillæg\",\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D46=\"Optagelse\",Datasheet!$B$77,\"-\"))","v":"-"},{"$f":"(_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",(_xlfn.IFS(Q45=\"Planmæssigt\",\"-\",Q45=\"Forsinket\",\"Diæt\",Q45=\"Ingen servering\",\"Diæt\",Q45=\"Pause ikke afholdt\",\"Diæt + 45min\"))))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",(_xlfn.IFS(R45=\"Planmæssigt\",\"-\",R45=\"Forsinket\",\"Diæt\",R45=\"Ingen servering\",\"Diæt\",R45=\"Pause ikke afholdt\",\"Diæt + 30min\")))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",(_xlfn.IFS(S45=\"Planmæssigt\",\"-\",S45=\"Forsinket\",\"Diæt\",S45=\"Ingen servering\",\"Diæt\",S45=\"Pause ikke afholdt\",\"Diæt + 15min\")))","v":"-"},{"$f":"IF($T34=Datasheet!$B$49,\"-\",IF(D46=\"Optagelse\",_xlfn.IFS(T45=\"Ingen rabat\",\"-\",T45=\"Rabat A\",Datasheet!$B$96,T45=\"Rabat B\",Datasheet!$B$97),\"-\"))","v":"-"},{"$f":"IF(U45=\"Ingen diæt\",\"-\",U45)","v":"-"}]
[null,null,"Nej",null,null,null,null,{"$f":"IF($T$4=Datasheet!$B$49,grundløn/8,(_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Optagelse\",grundløn/8,$D46=\"rejsetid\",grundløn/8,$D46=\"rejsetid +50%\",(grundløn/8)*1.5,$D46=\"Forbered/afrig tid\",grundløn/8,$D46=\"Sygdom\",grundløn/8)))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",$D46=\"Optagelse\",grundløn/8*$I46+grundløn/8,$D46=\"rejsetid\",\"-\",$D46=\"Forbered/afrig tid\",grundløn/8*$I46+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",$D46=\"Optagelse\",grundløn/8*$J46+grundløn/8,$D46=\"rejsetid\",\"-\",$D46=\"Forbered/afrig tid\",grundløn/8*$J46+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$C$66,_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",$D46=\"Optagelse\",grundløn/8*$K46+grundløn/8,$D46=\"rejsetid\",\"-\",$D46=\"Forbered/afrig tid\",grundløn/8*$K46+grundløn/8))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,Datasheet!$D$66,_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Rejsetid\",\"-\",D46=\"Rejsetid +50%\",\"-\",$D46=\"Optagelse\",grundløn/8*$L46+grundløn/8,$D46=\"rejsetid\",\"-\",$D46=\"Forbered/afrig tid\",grundløn/8*$L46+grundløn/8))","v":"-"},{"$f":"IF(AND(M46<>0,M46<>\"-\"),H47*M45,\"-\")","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D46=\"Optagelse\",Datasheet!$B$82,\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF($D46=\"Optagelse\",Datasheet!$B$83,\"-\"))","v":"-"},{"$f":"IF($T$4=Datasheet!$B$49,\"-\",IF(D46=\"Optagelse\",((grundløn/8)*P46),\"-\"))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",_xlfn.IFS(Q45=\"Planmæssigt\",\"-\",Q45=\"Forsinket\",Datasheet!$B$88,Q45=\"Ingen servering\",Datasheet!$B$88,Q45=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",_xlfn.IFS(R45=\"Planmæssigt\",\"-\",R45=\"Forsinket\",Datasheet!$B$88,R45=\"Ingen servering\",Datasheet!$B$88,R45=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",_xlfn.IFS(S45=\"Planmæssigt\",\"-\",S45=\"Forsinket\",Datasheet!$B$88,S45=\"Ingen servering\",Datasheet!$B$88,S45=\"Pause ikke afholdt\",Datasheet!$B$88))","v":"-"},{"$f":"IF($T34=Datasheet!$B$49,\"-\",(_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Optagelse\",(IF(T45=\"Ingen rabat\",\"-\",(SUM(H48:S48)))))))","v":"-"},{"$f":"IF(OR(Q46<>\"-\",R46<>\"-\",S46<>\"-\",D46=\"Fri\"),\"-\",_xlfn.IFS(U46=\"-\",\"-\",U46=\"Morgen\",86.1,U46=\"Morgen+Frokost\",258.3,U46=\"Frokost el. Aften\",172.2,U46=\"Frokost+Aften\", 344.4,U46=\"Fuld kost\",420.5))","v":"-"},null,null,null,{"$f":"SUM(Q47:S47)+SUM(U47)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF($D46=\"Fri\",\"-\",(IF(H45>0,H47*H45,\"-\")))","v":"-"},{"$f":"IF(AND(I45<>\"-\",I47<>\"-\"),I47*I45,\"-\")","v":"-"},{"$f":"IF(AND(J45<>\"-\",J47<>\"-\"),J47*J45,\"-\")","v":"-"},"-","-",{"$f":"IF(M47<>\"-\",M47*M46,\"-\")","v":"-"},{"$f":"IF(AND(N45<>\"-\",N47<>\"-\"),N47*N45,\"-\")","v":"-"},{"$f":"IF(AND(O45<>\"-\",O47<>\"-\"),O47*O45,\"-\")","v":"-"},{"$f":"IF(AND(P45<>\"-\",P47<>\"-\"),P47*P45,\"-\")","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",_xlfn.IFS(Q45=\"Planmæssigt\",\"-\",Q45=\"Forsinket\",\"-\",Q45=\"Ingen servering\",\"-\",Q45=\"Pause ikke afholdt\",($I47*0.75)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",_xlfn.IFS(R45=\"Planmæssigt\",\"-\",R45=\"Forsinket\",\"-\",R45=\"Ingen servering\",\"-\",R45=\"Pause ikke afholdt\",($J47*0.5)))","v":"-"},{"$f":"_xlfn.IFS($T$4=Datasheet!$B$49,\"-\",$D46=\"Fri\",\"-\",$D46=\"Forbered/afrig tid\",\"-\",$D46=\"Rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"optagelse\",_xlfn.IFS(S45=\"Planmæssigt\",\"-\",S45=\"Forsinket\",\"-\",S45=\"Ingen servering\",\"-\",S45=\"Pause ikke afholdt\",(K47*0.25)))","v":"-"},{"$f":"_xlfn.IFS($D46=\"Fri\",\"-\",$D46=\"rejsetid\",\"-\",$D46=\"Rejsetid +50%\",\"-\",$D46=\"Sygdom\",\"-\",$D46=\"Optagelse\",(_xlfn.IFS(T47=\"-\",\"-\",T47=0,\"-\",T47<>0,T47*T46)),$D46=\"Forbered/afrig tid\",\"-\")","v":"-"},"-",null,{"$f":"_xlfn.IFS($D46=\"Fri\",0,$D46=\"optagelse\",(_xlfn.IFS(SUM(H48:T48)=0,0,SUM(H48:T48)>grundløn,SUM(H48:T48),SUM(H48:T48)<=grundløn,grundløn)),$D46=\"Forbered/afrig tid\",(IF(SUM(H48:T48)=0,0,SUM(H48:T48))),$D46=\"rejsetid\",(IF(SUM(H48:T48)=0,0,SUM(H48:T48))),$D46=\"rejsetid +50%\",(IF(SUM(H48:T48)=0,0,SUM(H48:T48))),$D46=\"sygdom\",(IF(SUM(H48:T48)=0,0,SUM(H48:T48))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dage",null,"Dagsløn"]
[null,null,null,null,null,null,null,null,null,null,null,"ANTAL AFTALTE FORBEREDELSES- OG AFRIG DAGE UDEN OVERTID",null,null,null,null,null,0,"á",{"$f":"grundløn","v":0},null,null,{"$f":"IF(R50<>0,R50*T50,\"-\")","v":"-"}]