{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Januari","Februari","Maret","April","Mei","Juni","Juli","Agustus","September","Oktober","November","Desember","Nama Karyawan"],"not_rendered":{"defined_names":50},"read":"whole","date_system":"1900"}

{"sheet":"Januari","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,"Jadwal Absen Karyawan"]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[{"$nulls":33},"Masukkan tahun:"]
[null,"Januari","Tanggal Absen",{"$nulls":30},2019]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,1),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,2),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,3),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,4),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,5),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,6),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,7),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,8),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,9),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,10),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,11),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,12),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,13),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,14),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,15),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,16),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,17),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,18),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,19),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,20),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,21),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,22),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,23),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,24),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,25),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,26),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,27),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,28),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,29),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,30),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,1,31),1),\"aaa\")","v":"Thu"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",null,null,"L","L","L","L",{"$nulls":6},"L",{"$nulls":18},{"$f":"COUNTA(Januari!$C7:$AG7)","v":5}]
[null,"Karyawan 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"L","L","L",{"$nulls":4},{"$f":"COUNTA(Januari!$C8:$AG8)","v":7}]
[null,"Karyawan 3",null,null,"P",{"$nulls":10},"S",{"$nulls":14},"S",null,null,{"$f":"COUNTA(Januari!$C9:$AG9)","v":3}]
[null,"Karyawan 4",{"$nulls":6},"P",{"$nulls":11},"L","L","L",{"$nulls":10},{"$f":"COUNTA(Januari!$C10:$AG10)","v":4}]
[null,"Karyawan 5",{"$nulls":3},"S","L","L",{"$nulls":10},"S",{"$nulls":6},"S",{"$nulls":6},"L",{"$f":"COUNTA(Januari!$C11:$AG11)","v":6}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Januari"},{"$f":"SUBTOTAL(103,Januari!$C$7:$C$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$D$7:$D$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$E$7:$E$11)","v":2},{"$f":"SUBTOTAL(103,Januari!$F$7:$F$11)","v":2},{"$f":"SUBTOTAL(103,Januari!$G$7:$G$11)","v":3},{"$f":"SUBTOTAL(103,Januari!$H$7:$H$11)","v":3},{"$f":"SUBTOTAL(103,Januari!$I$7:$I$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$J$7:$J$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$K$7:$K$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$L$7:$L$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$M$7:$M$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$N$7:$N$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$O$7:$O$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$P$7:$P$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$Q$7:$Q$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$R$7:$R$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$S$7:$S$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$T$7:$T$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$U$7:$U$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$V$7:$V$11)","v":2},{"$f":"SUBTOTAL(103,Januari!$W$7:$W$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$X$7:$X$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$Y$7:$Y$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$Z$7:$Z$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AA$7:$AA$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AB$7:$AB$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AC$7:$AC$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AD$7:$AD$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$AE$7:$AE$11)","v":1},{"$f":"SUBTOTAL(103,Januari!$AF$7:$AF$11)","v":0},{"$f":"SUBTOTAL(103,Januari!$AG$7:$AG$11)","v":1},{"$f":"SUBTOTAL(109,Januari[Total Hari])","v":25}]

{"sheet":"Februari","index":1,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Februari","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,1),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,2),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,3),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,4),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,5),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,6),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,7),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,8),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,9),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,10),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,11),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,12),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,13),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,14),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,15),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,16),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,17),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,18),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,19),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,20),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,21),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,22),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,23),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,24),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,25),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,26),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,27),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,28),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,2,29),1),\"aaa\")","v":"Jum"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29"," ","  ","Total Hari"]
[null,"Karyawan 1",null,null,"L","L","L","L",{"$nulls":6},"L",{"$nulls":18},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":5}]
[null,"Karyawan 2",{"$nulls":4},"S","S",{"$nulls":4},"P",{"$nulls":8},"S",{"$nulls":4},"L","L","L",{"$nulls":4},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":7}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":0}]
[null,"Karyawan 4",null,null,"S",{"$nulls":10},"S",{"$nulls":3},"P",{"$nulls":9},"S",{"$nulls":3},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":4}]
[null,"Karyawan 5",{"$nulls":7},"L","L","L","L",{"$nulls":12},"S",{"$nulls":7},{"$f":"COUNTA(Februari[[#This Row],[1]:[29]])","v":5}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Februari"},{"$f":"SUBTOTAL(103,Februari[1])","v":0},{"$f":"SUBTOTAL(103,Februari[2])","v":0},{"$f":"SUBTOTAL(103,Februari[3])","v":2},{"$f":"SUBTOTAL(103,Februari[4])","v":1},{"$f":"SUBTOTAL(103,Februari[5])","v":2},{"$f":"SUBTOTAL(103,Februari[6])","v":2},{"$f":"SUBTOTAL(103,Februari[7])","v":0},{"$f":"SUBTOTAL(103,Februari[8])","v":1},{"$f":"SUBTOTAL(103,Februari[9])","v":1},{"$f":"SUBTOTAL(103,Februari[10])","v":1},{"$f":"SUBTOTAL(103,Februari[11])","v":2},{"$f":"SUBTOTAL(103,Februari[12])","v":0},{"$f":"SUBTOTAL(103,Februari[13])","v":1},{"$f":"SUBTOTAL(103,Februari[14])","v":1},{"$f":"SUBTOTAL(103,Februari[15])","v":0},{"$f":"SUBTOTAL(103,Februari[16])","v":0},{"$f":"SUBTOTAL(103,Februari[17])","v":0},{"$f":"SUBTOTAL(103,Februari[18])","v":1},{"$f":"SUBTOTAL(103,Februari[19])","v":0},{"$f":"SUBTOTAL(103,Februari[20])","v":1},{"$f":"SUBTOTAL(103,Februari[21])","v":0},{"$f":"SUBTOTAL(103,Februari[22])","v":0},{"$f":"SUBTOTAL(103,Februari[23])","v":0},{"$f":"SUBTOTAL(103,Februari[24])","v":1},{"$f":"SUBTOTAL(103,Februari[25])","v":1},{"$f":"SUBTOTAL(103,Februari[26])","v":1},{"$f":"SUBTOTAL(103,Februari[27])","v":1},{"$f":"SUBTOTAL(103,Februari[28])","v":1},{"$f":"SUBTOTAL(103,Februari[29])","v":0},null,null,{"$f":"SUBTOTAL(109,Februari[Total Hari])","v":21}]

{"sheet":"Maret","index":2,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Maret","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,30),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,3,31),1),\"aaa\")","v":"Sun"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Maret[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Maret[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Maret[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Maret[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Maret[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Maret"},{"$f":"SUBTOTAL(103,Maret[1])","v":0},{"$f":"SUBTOTAL(103,Maret[2])","v":0},{"$f":"SUBTOTAL(103,Maret[3])","v":0},{"$f":"SUBTOTAL(103,Maret[4])","v":0},{"$f":"SUBTOTAL(103,Maret[5])","v":0},{"$f":"SUBTOTAL(103,Maret[6])","v":0},{"$f":"SUBTOTAL(103,Maret[7])","v":0},{"$f":"SUBTOTAL(103,Maret[8])","v":0},{"$f":"SUBTOTAL(103,Maret[9])","v":0},{"$f":"SUBTOTAL(103,Maret[10])","v":0},{"$f":"SUBTOTAL(103,Maret[11])","v":0},{"$f":"SUBTOTAL(103,Maret[12])","v":0},{"$f":"SUBTOTAL(103,Maret[13])","v":0},{"$f":"SUBTOTAL(103,Maret[14])","v":0},{"$f":"SUBTOTAL(103,Maret[15])","v":0},{"$f":"SUBTOTAL(103,Maret[16])","v":0},{"$f":"SUBTOTAL(103,Maret[17])","v":0},{"$f":"SUBTOTAL(103,Maret[18])","v":0},{"$f":"SUBTOTAL(103,Maret[19])","v":0},{"$f":"SUBTOTAL(103,Maret[20])","v":0},{"$f":"SUBTOTAL(103,Maret[21])","v":0},{"$f":"SUBTOTAL(103,Maret[22])","v":0},{"$f":"SUBTOTAL(103,Maret[23])","v":0},{"$f":"SUBTOTAL(103,Maret[24])","v":0},{"$f":"SUBTOTAL(103,Maret[25])","v":0},{"$f":"SUBTOTAL(103,Maret[26])","v":0},{"$f":"SUBTOTAL(103,Maret[27])","v":0},{"$f":"SUBTOTAL(103,Maret[28])","v":0},{"$f":"SUBTOTAL(103,Maret[29])","v":0},{"$f":"SUBTOTAL(103,Maret[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Maret[31])","v":0},{"$f":"SUBTOTAL(109,Maret[Total Hari])","v":0}]

{"sheet":"April","index":3,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"April","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,1),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,2),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,3),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,4),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,5),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,6),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,7),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,8),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,9),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,10),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,11),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,12),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,13),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,14),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,15),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,16),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,17),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,18),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,19),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,20),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,21),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,22),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,23),1),\"aaa\")","v":"Sel"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,24),1),\"aaa\")","v":"Rab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,25),1),\"aaa\")","v":"Kam"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,26),1),\"aaa\")","v":"Jum"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,27),1),\"aaa\")","v":"Sab"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,28),1),\"aaa\")","v":"Mgg"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,29),1),\"aaa\")","v":"Sen"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,4,30),1),\"aaa\")","v":"Sel"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 "," ","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(April[[#This Row],[1]:[30 ]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total April"},{"$f":"SUBTOTAL(103,April[1])","v":0},{"$f":"SUBTOTAL(103,April[2])","v":0},{"$f":"SUBTOTAL(103,April[3])","v":0},{"$f":"SUBTOTAL(103,April[4])","v":0},{"$f":"SUBTOTAL(103,April[5])","v":0},{"$f":"SUBTOTAL(103,April[6])","v":0},{"$f":"SUBTOTAL(103,April[7])","v":0},{"$f":"SUBTOTAL(103,April[8])","v":0},{"$f":"SUBTOTAL(103,April[9])","v":0},{"$f":"SUBTOTAL(103,April[10])","v":0},{"$f":"SUBTOTAL(103,April[11])","v":0},{"$f":"SUBTOTAL(103,April[12])","v":0},{"$f":"SUBTOTAL(103,April[13])","v":0},{"$f":"SUBTOTAL(103,April[14])","v":0},{"$f":"SUBTOTAL(103,April[15])","v":0},{"$f":"SUBTOTAL(103,April[16])","v":0},{"$f":"SUBTOTAL(103,April[17])","v":0},{"$f":"SUBTOTAL(103,April[18])","v":0},{"$f":"SUBTOTAL(103,April[19])","v":0},{"$f":"SUBTOTAL(103,April[20])","v":0},{"$f":"SUBTOTAL(103,April[21])","v":0},{"$f":"SUBTOTAL(103,April[22])","v":0},{"$f":"SUBTOTAL(103,April[23])","v":0},{"$f":"SUBTOTAL(103,April[24])","v":0},{"$f":"SUBTOTAL(103,April[25])","v":0},{"$f":"SUBTOTAL(103,April[26])","v":0},{"$f":"SUBTOTAL(103,April[27])","v":0},{"$f":"SUBTOTAL(103,April[28])","v":0},{"$f":"SUBTOTAL(103,April[29])","v":0},{"$f":"SUBTOTAL(103,April[[30 ]])","v":0},{"$f":"SUBTOTAL(103,April[[30 ]])","v":0},{"$f":"SUBTOTAL(109,April[Total Hari])","v":0}]

{"sheet":"Mei","index":4,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Mei","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,1),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,2),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,3),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,4),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,5),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,6),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,7),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,8),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,9),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,10),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,11),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,12),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,13),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,14),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,15),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,16),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,17),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,18),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,19),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,20),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,21),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,22),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,23),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,24),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,25),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,26),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,27),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,28),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,29),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,30),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,5,31),1),\"aaa\")","v":"Fri"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Mei[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Mei"},{"$f":"SUBTOTAL(103,Mei[1])","v":0},{"$f":"SUBTOTAL(103,Mei[2])","v":0},{"$f":"SUBTOTAL(103,Mei[3])","v":0},{"$f":"SUBTOTAL(103,Mei[4])","v":0},{"$f":"SUBTOTAL(103,Mei[5])","v":0},{"$f":"SUBTOTAL(103,Mei[6])","v":0},{"$f":"SUBTOTAL(103,Mei[7])","v":0},{"$f":"SUBTOTAL(103,Mei[8])","v":0},{"$f":"SUBTOTAL(103,Mei[9])","v":0},{"$f":"SUBTOTAL(103,Mei[10])","v":0},{"$f":"SUBTOTAL(103,Mei[11])","v":0},{"$f":"SUBTOTAL(103,Mei[12])","v":0},{"$f":"SUBTOTAL(103,Mei[13])","v":0},{"$f":"SUBTOTAL(103,Mei[14])","v":0},{"$f":"SUBTOTAL(103,Mei[15])","v":0},{"$f":"SUBTOTAL(103,Mei[16])","v":0},{"$f":"SUBTOTAL(103,Mei[17])","v":0},{"$f":"SUBTOTAL(103,Mei[18])","v":0},{"$f":"SUBTOTAL(103,Mei[19])","v":0},{"$f":"SUBTOTAL(103,Mei[20])","v":0},{"$f":"SUBTOTAL(103,Mei[21])","v":0},{"$f":"SUBTOTAL(103,Mei[22])","v":0},{"$f":"SUBTOTAL(103,Mei[23])","v":0},{"$f":"SUBTOTAL(103,Mei[24])","v":0},{"$f":"SUBTOTAL(103,Mei[25])","v":0},{"$f":"SUBTOTAL(103,Mei[26])","v":0},{"$f":"SUBTOTAL(103,Mei[27])","v":0},{"$f":"SUBTOTAL(103,Mei[28])","v":0},{"$f":"SUBTOTAL(103,Mei[29])","v":0},{"$f":"SUBTOTAL(103,Mei[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Mei[31])","v":0},{"$f":"SUBTOTAL(109,Mei[Total Hari])","v":0}]

{"sheet":"Juni","index":5,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Juni","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,1),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,2),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,3),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,4),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,5),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,6),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,7),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,8),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,9),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,10),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,11),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,12),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,13),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,14),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,15),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,16),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,17),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,18),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,19),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,20),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,21),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,22),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,23),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,24),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,25),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,26),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,27),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,28),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,29),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,6,30),1),\"aaa\")","v":"Sun"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 "," ","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Juni[[#This Row],[1]:[30 ]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Juni"},{"$f":"SUBTOTAL(103,Juni[1])","v":0},{"$f":"SUBTOTAL(103,Juni[2])","v":0},{"$f":"SUBTOTAL(103,Juni[3])","v":0},{"$f":"SUBTOTAL(103,Juni[4])","v":0},{"$f":"SUBTOTAL(103,Juni[5])","v":0},{"$f":"SUBTOTAL(103,Juni[6])","v":0},{"$f":"SUBTOTAL(103,Juni[7])","v":0},{"$f":"SUBTOTAL(103,Juni[8])","v":0},{"$f":"SUBTOTAL(103,Juni[9])","v":0},{"$f":"SUBTOTAL(103,Juni[10])","v":0},{"$f":"SUBTOTAL(103,Juni[11])","v":0},{"$f":"SUBTOTAL(103,Juni[12])","v":0},{"$f":"SUBTOTAL(103,Juni[13])","v":0},{"$f":"SUBTOTAL(103,Juni[14])","v":0},{"$f":"SUBTOTAL(103,Juni[15])","v":0},{"$f":"SUBTOTAL(103,Juni[16])","v":0},{"$f":"SUBTOTAL(103,Juni[17])","v":0},{"$f":"SUBTOTAL(103,Juni[18])","v":0},{"$f":"SUBTOTAL(103,Juni[19])","v":0},{"$f":"SUBTOTAL(103,Juni[20])","v":0},{"$f":"SUBTOTAL(103,Juni[21])","v":0},{"$f":"SUBTOTAL(103,Juni[22])","v":0},{"$f":"SUBTOTAL(103,Juni[23])","v":0},{"$f":"SUBTOTAL(103,Juni[24])","v":0},{"$f":"SUBTOTAL(103,Juni[25])","v":0},{"$f":"SUBTOTAL(103,Juni[26])","v":0},{"$f":"SUBTOTAL(103,Juni[27])","v":0},{"$f":"SUBTOTAL(103,Juni[28])","v":0},{"$f":"SUBTOTAL(103,Juni[29])","v":0},{"$f":"SUBTOTAL(103,Juni[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Juni[[ ]])","v":0},{"$f":"SUBTOTAL(109,Juni[Total Hari])","v":0}]

{"sheet":"Juli","index":6,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Juli","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,1),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,2),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,3),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,4),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,5),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,6),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,7),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,8),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,9),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,10),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,11),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,12),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,13),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,14),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,15),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,16),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,17),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,18),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,19),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,20),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,21),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,22),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,23),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,24),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,25),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,26),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,27),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,28),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,29),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,30),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,7,31),1),\"aaa\")","v":"Wed"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Juli[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Juli"},{"$f":"SUBTOTAL(103,Juli[1])","v":0},{"$f":"SUBTOTAL(103,Juli[2])","v":0},{"$f":"SUBTOTAL(103,Juli[3])","v":0},{"$f":"SUBTOTAL(103,Juli[4])","v":0},{"$f":"SUBTOTAL(103,Juli[5])","v":0},{"$f":"SUBTOTAL(103,Juli[6])","v":0},{"$f":"SUBTOTAL(103,Juli[7])","v":0},{"$f":"SUBTOTAL(103,Juli[8])","v":0},{"$f":"SUBTOTAL(103,Juli[9])","v":0},{"$f":"SUBTOTAL(103,Juli[10])","v":0},{"$f":"SUBTOTAL(103,Juli[11])","v":0},{"$f":"SUBTOTAL(103,Juli[12])","v":0},{"$f":"SUBTOTAL(103,Juli[13])","v":0},{"$f":"SUBTOTAL(103,Juli[14])","v":0},{"$f":"SUBTOTAL(103,Juli[15])","v":0},{"$f":"SUBTOTAL(103,Juli[16])","v":0},{"$f":"SUBTOTAL(103,Juli[17])","v":0},{"$f":"SUBTOTAL(103,Juli[18])","v":0},{"$f":"SUBTOTAL(103,Juli[19])","v":0},{"$f":"SUBTOTAL(103,Juli[20])","v":0},{"$f":"SUBTOTAL(103,Juli[21])","v":0},{"$f":"SUBTOTAL(103,Juli[22])","v":0},{"$f":"SUBTOTAL(103,Juli[23])","v":0},{"$f":"SUBTOTAL(103,Juli[24])","v":0},{"$f":"SUBTOTAL(103,Juli[25])","v":0},{"$f":"SUBTOTAL(103,Juli[26])","v":0},{"$f":"SUBTOTAL(103,Juli[27])","v":0},{"$f":"SUBTOTAL(103,Juli[28])","v":0},{"$f":"SUBTOTAL(103,Juli[29])","v":0},{"$f":"SUBTOTAL(103,Juli[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Juli[31])","v":0},{"$f":"SUBTOTAL(109,Juli[Total Hari])","v":0}]

{"sheet":"Agustus","index":7,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Agustus","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,1),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,2),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,3),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,4),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,5),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,6),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,7),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,8),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,9),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,10),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,11),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,12),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,13),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,14),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,15),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,16),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,17),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,18),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,19),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,20),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,21),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,22),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,23),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,24),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,25),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,26),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,27),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,28),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,29),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,30),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,8,31),1),\"aaa\")","v":"Sat"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Agustus[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Agustus[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Agustus[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Agustus[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Agustus[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Agustus"},{"$f":"SUBTOTAL(103,Agustus[1])","v":0},{"$f":"SUBTOTAL(103,Agustus[2])","v":0},{"$f":"SUBTOTAL(103,Agustus[3])","v":0},{"$f":"SUBTOTAL(103,Agustus[4])","v":0},{"$f":"SUBTOTAL(103,Agustus[5])","v":0},{"$f":"SUBTOTAL(103,Agustus[6])","v":0},{"$f":"SUBTOTAL(103,Agustus[7])","v":0},{"$f":"SUBTOTAL(103,Agustus[8])","v":0},{"$f":"SUBTOTAL(103,Agustus[9])","v":0},{"$f":"SUBTOTAL(103,Agustus[10])","v":0},{"$f":"SUBTOTAL(103,Agustus[11])","v":0},{"$f":"SUBTOTAL(103,Agustus[12])","v":0},{"$f":"SUBTOTAL(103,Agustus[13])","v":0},{"$f":"SUBTOTAL(103,Agustus[14])","v":0},{"$f":"SUBTOTAL(103,Agustus[15])","v":0},{"$f":"SUBTOTAL(103,Agustus[16])","v":0},{"$f":"SUBTOTAL(103,Agustus[17])","v":0},{"$f":"SUBTOTAL(103,Agustus[18])","v":0},{"$f":"SUBTOTAL(103,Agustus[19])","v":0},{"$f":"SUBTOTAL(103,Agustus[20])","v":0},{"$f":"SUBTOTAL(103,Agustus[21])","v":0},{"$f":"SUBTOTAL(103,Agustus[22])","v":0},{"$f":"SUBTOTAL(103,Agustus[23])","v":0},{"$f":"SUBTOTAL(103,Agustus[24])","v":0},{"$f":"SUBTOTAL(103,Agustus[25])","v":0},{"$f":"SUBTOTAL(103,Agustus[26])","v":0},{"$f":"SUBTOTAL(103,Agustus[27])","v":0},{"$f":"SUBTOTAL(103,Agustus[28])","v":0},{"$f":"SUBTOTAL(103,Agustus[29])","v":0},{"$f":"SUBTOTAL(103,Agustus[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Agustus[31])","v":0},{"$f":"SUBTOTAL(109,Agustus[Total Hari])","v":0}]

{"sheet":"September","index":8,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"September","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,1),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,2),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,3),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,4),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,5),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,6),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,7),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,8),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,9),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,10),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,11),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,12),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,13),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,14),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,15),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,16),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,17),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,18),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,19),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,20),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,21),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,22),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,23),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,24),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,25),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,26),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,27),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,28),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,29),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,9,30),1),\"aaa\")","v":"Mon"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 "," ","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(September[[#This Row],[1]:[30 ]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total September"},{"$f":"SUBTOTAL(103,September[1])","v":0},{"$f":"SUBTOTAL(103,September[2])","v":0},{"$f":"SUBTOTAL(103,September[3])","v":0},{"$f":"SUBTOTAL(103,September[4])","v":0},{"$f":"SUBTOTAL(103,September[5])","v":0},{"$f":"SUBTOTAL(103,September[6])","v":0},{"$f":"SUBTOTAL(103,September[7])","v":0},{"$f":"SUBTOTAL(103,September[8])","v":0},{"$f":"SUBTOTAL(103,September[9])","v":0},{"$f":"SUBTOTAL(103,September[10])","v":0},{"$f":"SUBTOTAL(103,September[11])","v":0},{"$f":"SUBTOTAL(103,September[12])","v":0},{"$f":"SUBTOTAL(103,September[13])","v":0},{"$f":"SUBTOTAL(103,September[14])","v":0},{"$f":"SUBTOTAL(103,September[15])","v":0},{"$f":"SUBTOTAL(103,September[16])","v":0},{"$f":"SUBTOTAL(103,September[17])","v":0},{"$f":"SUBTOTAL(103,September[18])","v":0},{"$f":"SUBTOTAL(103,September[19])","v":0},{"$f":"SUBTOTAL(103,September[20])","v":0},{"$f":"SUBTOTAL(103,September[21])","v":0},{"$f":"SUBTOTAL(103,September[22])","v":0},{"$f":"SUBTOTAL(103,September[23])","v":0},{"$f":"SUBTOTAL(103,September[24])","v":0},{"$f":"SUBTOTAL(103,September[25])","v":0},{"$f":"SUBTOTAL(103,September[26])","v":0},{"$f":"SUBTOTAL(103,September[27])","v":0},{"$f":"SUBTOTAL(103,September[28])","v":0},{"$f":"SUBTOTAL(103,September[29])","v":0},{"$f":"SUBTOTAL(103,September[[30 ]])","v":0},{"$f":"SUBTOTAL(103,September[[ ]])","v":0},{"$f":"SUBTOTAL(109,September[Total Hari])","v":0}]

{"sheet":"Oktober","index":9,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Oktober","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,1),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,2),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,3),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,4),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,5),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,6),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,7),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,8),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,9),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,10),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,11),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,12),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,13),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,14),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,15),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,16),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,17),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,18),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,19),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,20),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,21),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,22),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,23),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,24),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,25),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,26),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,27),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,28),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,29),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,30),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,10,31),1),\"aaa\")","v":"Thu"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Oktober[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Oktober"},{"$f":"SUBTOTAL(103,Oktober[1])","v":0},{"$f":"SUBTOTAL(103,Oktober[2])","v":0},{"$f":"SUBTOTAL(103,Oktober[3])","v":0},{"$f":"SUBTOTAL(103,Oktober[4])","v":0},{"$f":"SUBTOTAL(103,Oktober[5])","v":0},{"$f":"SUBTOTAL(103,Oktober[6])","v":0},{"$f":"SUBTOTAL(103,Oktober[7])","v":0},{"$f":"SUBTOTAL(103,Oktober[8])","v":0},{"$f":"SUBTOTAL(103,Oktober[9])","v":0},{"$f":"SUBTOTAL(103,Oktober[10])","v":0},{"$f":"SUBTOTAL(103,Oktober[11])","v":0},{"$f":"SUBTOTAL(103,Oktober[12])","v":0},{"$f":"SUBTOTAL(103,Oktober[13])","v":0},{"$f":"SUBTOTAL(103,Oktober[14])","v":0},{"$f":"SUBTOTAL(103,Oktober[15])","v":0},{"$f":"SUBTOTAL(103,Oktober[16])","v":0},{"$f":"SUBTOTAL(103,Oktober[17])","v":0},{"$f":"SUBTOTAL(103,Oktober[18])","v":0},{"$f":"SUBTOTAL(103,Oktober[19])","v":0},{"$f":"SUBTOTAL(103,Oktober[20])","v":0},{"$f":"SUBTOTAL(103,Oktober[21])","v":0},{"$f":"SUBTOTAL(103,Oktober[22])","v":0},{"$f":"SUBTOTAL(103,Oktober[23])","v":0},{"$f":"SUBTOTAL(103,Oktober[24])","v":0},{"$f":"SUBTOTAL(103,Oktober[25])","v":0},{"$f":"SUBTOTAL(103,Oktober[26])","v":0},{"$f":"SUBTOTAL(103,Oktober[27])","v":0},{"$f":"SUBTOTAL(103,Oktober[28])","v":0},{"$f":"SUBTOTAL(103,Oktober[29])","v":0},{"$f":"SUBTOTAL(103,Oktober[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Oktober[31])","v":0},{"$f":"SUBTOTAL(109,Oktober[Total Hari])","v":0}]

{"sheet":"November","index":10,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"November","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,1),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,2),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,3),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,4),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,5),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,6),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,7),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,8),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,9),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,10),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,11),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,12),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,13),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,14),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,15),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,16),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,17),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,18),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,19),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,20),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,21),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,22),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,23),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,24),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,25),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,26),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,27),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,28),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,29),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,11,30),1),\"aaa\")","v":"Sat"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 "," ","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30 ]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(November[[#This Row],[1]:[30 ]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total November"},{"$f":"SUBTOTAL(103,November[1])","v":0},{"$f":"SUBTOTAL(103,November[2])","v":0},{"$f":"SUBTOTAL(103,November[3])","v":0},{"$f":"SUBTOTAL(103,November[4])","v":0},{"$f":"SUBTOTAL(103,November[5])","v":0},{"$f":"SUBTOTAL(103,November[6])","v":0},{"$f":"SUBTOTAL(103,November[7])","v":0},{"$f":"SUBTOTAL(103,November[8])","v":0},{"$f":"SUBTOTAL(103,November[9])","v":0},{"$f":"SUBTOTAL(103,November[10])","v":0},{"$f":"SUBTOTAL(103,November[11])","v":0},{"$f":"SUBTOTAL(103,November[12])","v":0},{"$f":"SUBTOTAL(103,November[13])","v":0},{"$f":"SUBTOTAL(103,November[14])","v":0},{"$f":"SUBTOTAL(103,November[15])","v":0},{"$f":"SUBTOTAL(103,November[16])","v":0},{"$f":"SUBTOTAL(103,November[17])","v":0},{"$f":"SUBTOTAL(103,November[18])","v":0},{"$f":"SUBTOTAL(103,November[19])","v":0},{"$f":"SUBTOTAL(103,November[20])","v":0},{"$f":"SUBTOTAL(103,November[21])","v":0},{"$f":"SUBTOTAL(103,November[22])","v":0},{"$f":"SUBTOTAL(103,November[23])","v":0},{"$f":"SUBTOTAL(103,November[24])","v":0},{"$f":"SUBTOTAL(103,November[25])","v":0},{"$f":"SUBTOTAL(103,November[26])","v":0},{"$f":"SUBTOTAL(103,November[27])","v":0},{"$f":"SUBTOTAL(103,November[28])","v":0},{"$f":"SUBTOTAL(103,November[29])","v":0},{"$f":"SUBTOTAL(103,November[[30 ]])","v":0},{"$f":"SUBTOTAL(103,November[[ ]])","v":0},{"$f":"SUBTOTAL(109,November[Total Hari])","v":0}]

{"sheet":"Desember","index":11,"n_rows":12,"n_cols":34,"rows_kept":12,"merged":[[1,3,1,5],[1,7,1,9],[1,11,1,12],[1,14,1,16],[1,18,1,20],[3,2,3,32]]}
[null,{"$f":"Judul_Absensi_Karyawan","v":"Jadwal Absen Karyawan"}]
[null,"Kunci Jenis Absen","L","Liburan",null,null,"P","Pribadi",null,null,"S","Sakit",null,null,"Kustom 1",{"$nulls":3},"Kustom 2"]
[]
[null,"Desember","Tanggal Absen",{"$nulls":30},{"$f":"TahunKalender","v":2019}]
[null,null,{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,1),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,2),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,3),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,4),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,5),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,6),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,7),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,8),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,9),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,10),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,11),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,12),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,13),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,14),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,15),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,16),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,17),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,18),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,19),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,20),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,21),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,22),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,23),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,24),1),\"aaa\")","v":"Tue"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,25),1),\"aaa\")","v":"Wed"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,26),1),\"aaa\")","v":"Thu"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,27),1),\"aaa\")","v":"Fri"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,28),1),\"aaa\")","v":"Sat"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,29),1),\"aaa\")","v":"Sun"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,30),1),\"aaa\")","v":"Mon"},{"$f":"TEXT(WEEKDAY(DATE(TahunKalender,12,31),1),\"aaa\")","v":"Tue"}]
[null,"Nama Karyawan","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30 ","31","Total Hari"]
[null,"Karyawan 1",{"$nulls":31},{"$f":"COUNTA(Desember[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 2",{"$nulls":31},{"$f":"COUNTA(Desember[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 3",{"$nulls":31},{"$f":"COUNTA(Desember[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 4",{"$nulls":31},{"$f":"COUNTA(Desember[[#This Row],[1]:[31]])","v":0}]
[null,"Karyawan 5",{"$nulls":31},{"$f":"COUNTA(Desember[[#This Row],[1]:[31]])","v":0}]
[null,{"$f":"\"Total \"&NamaBulan","v":"Total Desember"},{"$f":"SUBTOTAL(103,Desember[1])","v":0},{"$f":"SUBTOTAL(103,Desember[2])","v":0},{"$f":"SUBTOTAL(103,Desember[3])","v":0},{"$f":"SUBTOTAL(103,Desember[4])","v":0},{"$f":"SUBTOTAL(103,Desember[5])","v":0},{"$f":"SUBTOTAL(103,Desember[6])","v":0},{"$f":"SUBTOTAL(103,Desember[7])","v":0},{"$f":"SUBTOTAL(103,Desember[8])","v":0},{"$f":"SUBTOTAL(103,Desember[9])","v":0},{"$f":"SUBTOTAL(103,Desember[10])","v":0},{"$f":"SUBTOTAL(103,Desember[11])","v":0},{"$f":"SUBTOTAL(103,Desember[12])","v":0},{"$f":"SUBTOTAL(103,Desember[13])","v":0},{"$f":"SUBTOTAL(103,Desember[14])","v":0},{"$f":"SUBTOTAL(103,Desember[15])","v":0},{"$f":"SUBTOTAL(103,Desember[16])","v":0},{"$f":"SUBTOTAL(103,Desember[17])","v":0},{"$f":"SUBTOTAL(103,Desember[18])","v":0},{"$f":"SUBTOTAL(103,Desember[19])","v":0},{"$f":"SUBTOTAL(103,Desember[20])","v":0},{"$f":"SUBTOTAL(103,Desember[21])","v":0},{"$f":"SUBTOTAL(103,Desember[22])","v":0},{"$f":"SUBTOTAL(103,Desember[23])","v":0},{"$f":"SUBTOTAL(103,Desember[24])","v":0},{"$f":"SUBTOTAL(103,Desember[25])","v":0},{"$f":"SUBTOTAL(103,Desember[26])","v":0},{"$f":"SUBTOTAL(103,Desember[27])","v":0},{"$f":"SUBTOTAL(103,Desember[28])","v":0},{"$f":"SUBTOTAL(103,Desember[29])","v":0},{"$f":"SUBTOTAL(103,Desember[[30 ]])","v":0},{"$f":"SUBTOTAL(103,Desember[31])","v":0},{"$f":"SUBTOTAL(109,Desember[Total Hari])","v":0}]

{"sheet":"Nama Karyawan","index":12,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"Nama Karyawan"]
[]
[null,"Nama Karyawan"]
[null,"Karyawan 1"]
[null,"Karyawan 2"]
[null,"Karyawan 3"]
[null,"Karyawan 4"]
[null,"Karyawan 5"]