{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Lembar Waktu Tahunan"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Lembar Waktu Tahunan","index":0,"n_rows":140,"n_cols":12,"rows_kept":140,"merged":[[0,1,1,11],[2,6,2,7],[2,8,2,9],[5,1,5,11],[39,1,39,11],[73,1,73,11],[107,1,107,11]]}
[null,"Kartu Waktu Karyawan"]
[]
[null,"Nama Karyawan:",null,"Email:",null,null,"Total tahun ini:"]
[null,"Manajer:",null,"Telepon:",null,null,"Jam reguler:",{"$f":"SUM(C16,C27,C38,C50,C61,C72,C84,C95,C106,C118,C129,C140)","v":0},"Jam lembur:",{"$f":"SUM(F16,F27,F38,F50,F61,F72,F84,F95,F106,F118,F129,F140)","v":0},"Total:",{"$f":"SUM(H4:J4)","v":0}]
[]
[null,"Januari, Februari, Maret      Kartu Waktu Karyawan: Harian, Mingguan, Bulanan, Tahunan"]
[null,"Januari","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Januari[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Januari[Lembur])","v":0},{"$f":"SUBTOTAL(109,Januari[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Januari[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Januari[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Januari[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Januari[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Januari[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Januari[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Januari[[Lembur    ]])","v":0}]
[null,"Total Januari: Jam reguler",{"$f":"SUM(Januari[[#Totals],[Minggu 1]],Januari[[#Totals],[Minggu 2]],Januari[[#Totals],[Minggu 3]],Januari[[#Totals],[Minggu 4]],Januari[[#Totals],[Minggu 5]])","v":0},"Total Januari: Lembur",null,{"$f":"SUM(Januari[[#Totals],[Lembur]],Januari[[#Totals],[Lembur ]],Januari[[#Totals],[Lembur  ]],Januari[[#Totals],[Lembur   ]],Januari[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Februari","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Februari[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Februari[Lembur])","v":0},{"$f":"SUBTOTAL(109,Februari[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Februari[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Februari[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Februari[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Februari[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Februari[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Februari[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Februari[[Lembur    ]])","v":0}]
[null,"Total Februari: Jam reguler",{"$f":"SUM(Februari[[#Totals],[Minggu 1]],Februari[[#Totals],[Minggu 2]],Februari[[#Totals],[Minggu 3]],Februari[[#Totals],[Minggu 4]],Februari[[#Totals],[Minggu 5]])","v":0},"Total Februari: Lembur",null,{"$f":"SUM(Februari[[#Totals],[Lembur]],Februari[[#Totals],[Lembur ]],Februari[[#Totals],[Lembur  ]],Februari[[#Totals],[Lembur   ]],Februari[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Maret","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Maret[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Maret[Lembur])","v":0},{"$f":"SUBTOTAL(109,Maret[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Maret[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Maret[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Maret[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Maret[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Maret[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Maret[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Maret[[Lembur    ]])","v":0}]
[null,"Total Maret: Jam reguler",{"$f":"SUM(Maret[[#Totals],[Minggu 1]],Maret[[#Totals],[Minggu 2]],Maret[[#Totals],[Minggu 3]],Maret[[#Totals],[Minggu 4]],Maret[[#Totals],[Minggu 5]])","v":0},"Total Maret: Lembur",null,{"$f":"SUM(Maret[[#Totals],[Lembur]],Maret[[#Totals],[Lembur ]],Maret[[#Totals],[Lembur  ]],Maret[[#Totals],[Lembur   ]],Maret[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"April, Mei, Juni      Kartu Waktu Karyawan: Harian, Mingguan, Bulanan, Tahunan"]
[null,"April","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,April[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,April[Lembur])","v":0},{"$f":"SUBTOTAL(109,April[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,April[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,April[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,April[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,April[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,April[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,April[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,April[[Lembur    ]])","v":0}]
[null,"Total April: Jam reguler",{"$f":"SUM(April[[#Totals],[Minggu 1]],April[[#Totals],[Minggu 2]],April[[#Totals],[Minggu 3]],April[[#Totals],[Minggu 4]],April[[#Totals],[Minggu 5]])","v":0},"Total April: Lembur",null,{"$f":"SUM(April[[#Totals],[Lembur]],April[[#Totals],[Lembur ]],April[[#Totals],[Lembur  ]],April[[#Totals],[Lembur   ]],April[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Mei","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Mei[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Mei[Lembur])","v":0},{"$f":"SUBTOTAL(109,Mei[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Mei[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Mei[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Mei[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Mei[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Mei[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Mei[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Mei[[Lembur    ]])","v":0}]
[null,"Total Mei: Jam reguler",{"$f":"SUM(Mei[[#Totals],[Minggu 1]],Mei[[#Totals],[Minggu 2]],Mei[[#Totals],[Minggu 3]],Mei[[#Totals],[Minggu 4]],Mei[[#Totals],[Minggu 5]])","v":0},"Total Mei: Lembur",null,{"$f":"SUM(Mei[[#Totals],[Lembur]],Mei[[#Totals],[Lembur ]],Mei[[#Totals],[Lembur  ]],Mei[[#Totals],[Lembur   ]],Mei[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Juni","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Juni[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Juni[Lembur])","v":0},{"$f":"SUBTOTAL(109,Juni[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Juni[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Juni[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Juni[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Juni[[Lembur    ]])","v":0}]
[null,"Total Juni: Jam reguler",{"$f":"SUM(Juni[[#Totals],[Minggu 1]],Juni[[#Totals],[Minggu 2]],Juni[[#Totals],[Minggu 3]],Juni[[#Totals],[Minggu 4]],Juni[[#Totals],[Minggu 5]])","v":0},"Total Juni: Lembur",null,{"$f":"SUM(Juni[[#Totals],[Lembur]],Juni[[#Totals],[Lembur ]],Juni[[#Totals],[Lembur  ]],Juni[[#Totals],[Lembur   ]],Juni[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Juli, Agustus, September      Kartu Waktu Karyawan: Harian, Mingguan, Bulanan, Tahunan"]
[null,"Juli","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Juli[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Juli[Lembur])","v":0},{"$f":"SUBTOTAL(109,Juli[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Juli[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Juli[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Juli[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Juli[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Juli[[Lembur    ]])","v":0}]
[null,"Total Juli: Jam reguler",{"$f":"SUM(Juli[[#Totals],[Minggu 1]],Juli[[#Totals],[Minggu 2]],Juli[[#Totals],[Minggu 3]],Juli[[#Totals],[Minggu 4]],Juli[[#Totals],[Minggu 5]])","v":0},"Total Juli: Lembur",null,{"$f":"SUM(Juli[[#Totals],[Lembur]],Juli[[#Totals],[Lembur ]],Juli[[#Totals],[Lembur  ]],Juli[[#Totals],[Lembur   ]],Juli[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Agustus","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Agustus[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Agustus[Lembur])","v":0},{"$f":"SUBTOTAL(109,Agustus[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Agustus[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Agustus[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Agustus[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Agustus[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Agustus[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Agustus[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Agustus[[Lembur    ]])","v":0}]
[null,"Total Agustus: Jam reguler",{"$f":"SUM(Agustus[[#Totals],[Minggu 1]],Agustus[[#Totals],[Minggu 2]],Agustus[[#Totals],[Minggu 3]],Agustus[[#Totals],[Minggu 4]],Agustus[[#Totals],[Minggu 5]])","v":0},"Total Agustus: Lembur",null,{"$f":"SUM(Agustus[[#Totals],[Lembur]],Agustus[[#Totals],[Lembur ]],Agustus[[#Totals],[Lembur  ]],Agustus[[#Totals],[Lembur   ]],Agustus[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"September","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,September[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,September[Lembur])","v":0},{"$f":"SUBTOTAL(109,September[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,September[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,September[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,September[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,September[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,September[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,September[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,September[[Lembur    ]])","v":0}]
[null,"Total September: Jam reguler",{"$f":"SUM(September[[#Totals],[Minggu 1]],September[[#Totals],[Minggu 2]],September[[#Totals],[Minggu 3]],September[[#Totals],[Minggu 4]],September[[#Totals],[Minggu 5]])","v":0},"Total September: Lembur",null,{"$f":"SUM(September[[#Totals],[Lembur]],September[[#Totals],[Lembur ]],September[[#Totals],[Lembur  ]],September[[#Totals],[Lembur   ]],September[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Oktober, November, Desember      Kartu Waktu Karyawan: Harian, Mingguan, Bulanan, Tahunan"]
[null,"Oktober","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Oktober[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Oktober[Lembur])","v":0},{"$f":"SUBTOTAL(109,Oktober[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Oktober[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Oktober[[Lembur    ]])","v":0}]
[null,"Total Oktober: Jam reguler",{"$f":"SUM(Oktober[[#Totals],[Minggu 1]],Oktober[[#Totals],[Minggu 2]],Oktober[[#Totals],[Minggu 3]],Oktober[[#Totals],[Minggu 4]],Oktober[[#Totals],[Minggu 5]])","v":0},"Total Oktober: Lembur",null,{"$f":"SUM(Oktober[[#Totals],[Lembur]],Oktober[[#Totals],[Lembur ]],Oktober[[#Totals],[Lembur  ]],Oktober[[#Totals],[Lembur   ]],Oktober[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"November","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,November[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,November[Lembur])","v":0},{"$f":"SUBTOTAL(109,November[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,November[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,November[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,November[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,November[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,November[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,November[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,November[[Lembur    ]])","v":0}]
[null,"Total November: Jam reguler",{"$f":"SUM(November[[#Totals],[Minggu 1]],November[[#Totals],[Minggu 2]],November[[#Totals],[Minggu 3]],November[[#Totals],[Minggu 4]],November[[#Totals],[Minggu 5]])","v":0},"Total November: Lembur",null,{"$f":"SUM(November[[#Totals],[Lembur]],November[[#Totals],[Lembur ]],November[[#Totals],[Lembur  ]],November[[#Totals],[Lembur   ]],November[[#Totals],[Lembur    ]])","v":0}]
[]
[null,"Desember","Minggu 1","Lembur","Minggu 2","Lembur ","Minggu 3","Lembur  ","Minggu 4","Lembur   ","Minggu 5","Lembur    "]
[null,"Senin"]
[null,"Selasa"]
[null,"Rabu"]
[null,"Kamis"]
[null,"Jumat"]
[null,"Sabtu"]
[null,"Minggu"]
[null,"Total jam mingguan",{"$f":"SUBTOTAL(109,Desember[Minggu 1])","v":0},{"$f":"SUBTOTAL(109,Desember[Lembur])","v":0},{"$f":"SUBTOTAL(105,Desember[Minggu 2])","v":0},{"$f":"SUBTOTAL(109,Desember[[Lembur ]])","v":0},{"$f":"SUBTOTAL(109,Desember[Minggu 3])","v":0},{"$f":"SUBTOTAL(109,Desember[[Lembur  ]])","v":0},{"$f":"SUBTOTAL(109,Desember[Minggu 4])","v":0},{"$f":"SUBTOTAL(109,Desember[[Lembur   ]])","v":0},{"$f":"SUBTOTAL(109,Desember[Minggu 5])","v":0},{"$f":"SUBTOTAL(109,Desember[[Lembur    ]])","v":0}]
[null,"Total Desember: Jam reguler",{"$f":"SUM(Desember[[#Totals],[Minggu 1]],Desember[[#Totals],[Minggu 2]],Desember[[#Totals],[Minggu 3]],Desember[[#Totals],[Minggu 4]],Desember[[#Totals],[Minggu 5]])","v":0},"Total Desember: Lembur",null,{"$f":"SUM(Desember[[#Totals],[Lembur]],Desember[[#Totals],[Lembur ]],Desember[[#Totals],[Lembur  ]],Desember[[#Totals],[Lembur   ]],Desember[[#Totals],[Lembur    ]])","v":0}]