{"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-03-01"},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 / C-foto"]
["- 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":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[2,7,2,8]]}
[]
[]
[null,"UGE #",{"$f":"WEEKNUM(B6,2)","v":10},null,null,"TIME BEREGNER","WEEKEND","GENETILLÆG"]
[null,"Dato","Start","Slut",null,"Timer i alt","Timer, mandag før 06:00 eller fredag efter kl 24:00","Optagelse \nkl. 18 - 00","Optagelse \nkl. 00 - 06"]
[]
[null,"2024-03-04","04:00:00","16:00:00",null,{"$f":"_xlfn.IFS($C7=\"Fri\",\"-\",$C7=\"Sygdom\",\"-\",$C7<>\"Fri\",IF(AND(D6>0,C6>0),MOD((HOUR(D6)-HOUR(C6))+(MINUTE(D6)-MINUTE(C6))/60,24),0/24))","v":12},"funktion der tæller weekend timer. I dette tilfælde skal den vise tallet 2,00",{"$f":"ColTime(C6,D6,Datasheet!$C$82,Datasheet!$C$83)*24","v":0},{"$f":"ColTime(C6,D6,Datasheet!$C$83,Datasheet!$C$84)*24","v":2}]
[null,null,null,null,null,"Ugedag"]
[null,null,null,null,null,{"$f":"WEEKDAY(B6,1)","v":"1900-01-02"}]
[]
[]
[]
[null,"2024-03-08","14:00:00","03:00:00",null,{"$f":"_xlfn.IFS($C13=\"Fri\",\"-\",$C13=\"Sygdom\",\"-\",$C13<>\"Fri\",IF(AND(D12>0,C12>0),MOD((HOUR(D12)-HOUR(C12))+(MINUTE(D12)-MINUTE(C12))/60,24),0/24))","v":13},"funktion der tæller weekend timer. I dette tilfælde skal den vise tallet 3,00",{"$f":"ColTime(C12,D12,Datasheet!$C$82,Datasheet!$C$83)*24","v":6},{"$f":"ColTime(C12,D12,Datasheet!$C$83,Datasheet!$C$84)*24","v":3}]
[null,null,null,null,null,"Ugedag"]
[null,null,null,null,null,{"$f":"WEEKDAY(B12,1)","v":"1900-01-06"}]