{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2016"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2016","index":0,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Dato","ugedag","Helligdag","vagt","mødetid","fyraften","kommentar","timer","aftentillæg","aftentillæg","afspadsering","lørdag","søndag","ferie"]
["2016-04-18","man",{"$f":"helligdagsnavn(A2,0,0)","v":""},"f",{"$f":"IF(D2=\"d\",$T$2,IF(D2=\"a\",$T$3,\"\"))","v":""},{"$f":"IF(D2=\"d\",$U$2,IF(D2=\"a\",$U$3,\"\"))","v":""},"store bededag",{"$f":"IF(OR(E2=\"\",F2=\"\"),\"0:00\",F2-E2)","v":"0:00"},{"$f":"IF(AND(COUNTIF(HVdag,$B2)=1,$D2=\"a\",$G2=\"syg\"),$V$5,IF(OR($B2=\"lør\",$B2=\"søn\"),\"0\",IF(AND($E2<=$V$3,$F2>=$V$3),$F2-$V$3,\"0\"))*24)","v":0},{"$f":"IF(OR(COUNTIF(Hdage,G2)=1,COUNTIF(Hdage,G2)=1),\"\",IF(OR(G2=\"syg\",G2=\"\"),IF(AND(E2<=$T$3,F2>=$U$3),$W$3,\"\")))","v":""},{"$f":"IF(AND(COUNTIF(Hdage,G2)=1,D2=\"a\"),\"\",IF(AND(COUNTIF(Hdage,G2)=1,D2=\"d\"),\"\",IF(AND(D2=\"f\",H2>$X$5),H2*2,IF(AND(D2=\"f\",H2=$X$5,COUNTIF(Hdage,G2)=1),$X$2,IF(AND(D2=\"a\",H2<>$X$3),H2-$X$3,IF(AND(D2=\"d\",H2<>$X$2),H2-$X$2,\"\"))))))","v":0},{"$f":"IF($B2=\"lør\",IF(AND($E2<=$T$4,$F2>=$T$4),$F2-$T$4,IF(AND($E2<=$U$4,$F2>=$U$4),$U$4-$E2,IF(AND($E2<=$T$4,$F2>=$U$4),$U$4-$T$4,IF(AND($E2>=$T$4,$F2<=$U$4),$F2-$E2,\"0\")))))*24","v":0},null,{"$f":"IF(G2<>\"ferie\",\"\",IF(G2=\"ferie\",IF(AND(D2=\"a\",H2=\"\"),$X$3,IF(AND(D2=\"d\",H2=\"\"),$X$2,IF(AND(D2=\"a\",H2<$X$3),$X$3-H2,IF(AND(D2=\"d\",H2<$X$2),$X$2-H2,\"\"))))))","v":""},{"$f":"IF(AND(COUNTIF(Hdage,G2)=1,B2=\"søn\"),\"\",IF(COUNTIF(Fdage,G2)=1,\"\",IF(AND(COUNTIF(Hdage,G2)=1,D2=\"f\"),$X$2,IF(AND(COUNTIF(Hdage,G2)=1,D2=\"a\"),H2,IF(AND(COUNTIF(Hdage,G2)=1,D2=\"d\"),H2,IF(AND(D2=\"a\",H2<>$X$3),H2-$X$3,IF(AND(D2=\"d\",H2<>$X$2),H2-$X$2,IF(AND(D2=\"f\",H2>$X$5),H2*2,\"\"))))))))","v":0.29166666666666669},{"$f":"IF(AND(COUNTIF(Hdage,G2)=1,OR(D2=\"a\",D2=\"d\")),H2,\"ha\")","v":"ha"},{"$f":"IF(OR(ISNUMBER(SEARCH(\"syg\",G2)),ISNUMBER(SEARCH(\"store bededag\",G2))),\"hej\",\"øv\")","v":"hej"},null,"dag","08:00:00","15:00:00",null,null,"07:00:00"]
["2016-04-19","tir",{"$f":"helligdagsnavn(A3,0,0)","v":""},"d",0.33333333333333331,0.625,"syg store bededag",{"$f":"IF(OR(E3=\"\",F3=\"\"),\"0:00\",F3-E3)","v":0.29166666666666669},0,{"$f":"IF(COUNTIF(Hdage,G3)=1,\"\",IF(OR(G3=\"syg\",G3=\"\"),IF(AND(E3<=$T$3,F3>=$U$3),$W$3,\"\")))","v":false},"",{"$f":"IF($B3=\"lør\",IF(AND($E3<=$T$4,$F3>=$T$4),$F3-$T$4,IF(AND($E3<=$U$4,$F3>=$U$4),$U$4-$E3,IF(AND($E3<=$T$4,$F3>=$U$4),$U$4-$T$4,IF(AND($E3>=$T$4,$F3<=$U$4),$F3-$E3,\"0\")))))*24","v":0},null,{"$f":"IF(G3<>\"ferie\",\"\",IF(G3=\"ferie\",IF(AND(D3=\"a\",H3=\"\"),$X$3,IF(AND(D3=\"d\",H3=\"\"),$X$2,IF(AND(D3=\"a\",H3<$X$3),$X$3-H3,IF(AND(D3=\"d\",H3<$X$2),$X$2-H3,\"\"))))))","v":""},"",null,"hej",null,"aften","14:30:00","22:30:00","17:00:00","00:39:00","08:00:00"]
["2016-04-20","ons","","d",0.33333333333333331,0.625,"store bededag",0.29166666666666669,0,"","",0,null,null,0.29166666666666669,null,{"$f":"IF(OR(ISNUMBER(SEARCH(\"syg\",G4)),ISNUMBER(SEARCH(\"store bededag\",G4))),\"hej\",\"øv\")","v":"hej"},null,"lørdag","11:00:00","17:00:00",{"$f":"$U$2-$T$4","v":"04:00:00"},{"$f":"$U$4-$T$3","v":"02:30:00"}]
["2016-04-21","tor","",null,null,null,null,"0:00",0,"","",0,null,null,"",null,"øv",null,"søndag",7,8,5.5,null,"00:00:00"]
["2016-04-22","fre","Store Bededag",null,null,null,null,"0:00",0,"","",0,null,null,"",null,"øv"]
["2016-04-23","lør","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv"]
["2016-04-24","søn","","d",0.33333333333333331,0.625,"syg",0.29166666666666669,0,"","",0,null,null,"",null,"hej",null,"ferie"]
["2016-04-25","man","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv",null,"feriefridag"]
["2016-04-26","tir","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv",null,"seniordag"]
["2016-04-27","ons","",null,"","",null,"0:00",0,{"$f":"IF(OR(G11=\"syg\",G11=\"\"),IF(AND(E11<=$T$3,F11>=$U$3),$W$3,\"\"))","v":""},"",0,null,null,"",null,"øv"]
["2016-04-28","tor","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv"]
["2016-04-29","fre","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv",null,"syg"]
["2016-04-30","lør","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv"]
["2016-05-01","søn","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv",null,"store bededag"]
["2016-05-02","man","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv",null,"kristi himmelfartsdag"]
["2016-05-03","tir","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv"]
["2016-05-04","ons","",null,"","",null,"0:00",0,"","",0,null,null,"",null,"øv",null,"man"]
["2016-05-05","tor","Kristi Himmelfartsdag",null,"","",null,"0:00",0,"","",0,null,null,"",null,null,null,"tir"]
["2016-05-06","fre","",null,"","",null,"0:00",0,"","",0,null,null,"",null,null,null,"ons"]
["2016-05-07","lør","",null,"","",null,{"$f":"IF(OR(E21=\"\",F21=\"\"),\"0\",F21-E21)","v":"0"},0,"","",0,null,null,"",null,null,null,"tor"]
["2016-05-08","søn","",null,"","",null,"0",0,"","",0,null,null,"",null,null,null,"fre"]
[null,null,null,null,null,null,null,"0",0,"","",0,null,null,""]
[null,null,null,null,null,null,null,"0",0,"",{"$f":"IF(AND(D24=\"f\",E24<>\"\",F24<>\"\"),(F24-E24)*2,IF(AND(D24=\"d\",E24<>$T$2,F24<>$U$2),(F24-E24)-($U$2-$T$2),IF(AND(D24=\"a\",E24<>$T$3,F24<>$U$3),(F24-E24)-($U$3-$T$3),IF(AND(E24<>$T$2,F24=$U$2),(F24-E24)-($U$2-$T$2),IF(AND(E24=$T$2,F24<>$U$2),(F24-E24)-($U$2-$T$2),IF(AND(E24<>$T$3,F24=$U$3),(F24-E24)-($U$3-$T$3),IF(AND(E24=$T$3,F24<>$U$3),(F24-E24)-($U$3-$T$3),\"\")))))))","v":""},0]
[null,null,null,null,null,null,null,"0",0,"","",0]
[null,null,null,null,null,null,null,{"$f":"IF(OR(E26=\"\",F26=\"\"),\"\",F26-E26)","v":""},0,"","",0,null,null,null,null,null,null,"HVIS(OG(TÆL.HVIS(Hdage;E2)=1;B2=\"a\");F2;HVIS(OG(TÆL.HVIS(Hdage;E2)=1;B2=\"d\");F2"]
[null,null,null,null,null,null,null,"",0,"","",0]
[null,null,null,null,null,null,null,"",0,"","",0]
[null,null,null,null,null,null,null,"",0,"","",0]
[null,null,null,null,null,null,null,"",0,"","",0]
[null,null,null,null,{"$f":"IF([1]beregning!K31=\"\",\"\",[1]beregning!K31)","v":0},{"$f":"IF([1]beregning!L31=\"\",\"\",[1]beregning!L31)","v":0},null,0,0,"","",0]
[null,null,null,null,{"$f":"IF([1]beregning!K32=\"\",\"\",[1]beregning!K32)","v":0},{"$f":"IF([1]beregning!L32=\"\",\"\",[1]beregning!L32)","v":0},null,null,0,"","",0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I2:I32)","v":0},{"$f":"SUM(J2:J32)","v":0},{"$f":"SUM(K2:K32)","v":0},{"$f":"SUM(L2:L32)","v":0}]