{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Pencatat RSVP","Ringkasan RSVP"],"not_rendered":{"charts":2,"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"Pencatat RSVP","index":0,"n_rows":15,"n_cols":15,"rows_kept":15,"merged":[[0,3,0,4],[0,5,0,7],[1,3,1,14]]}
[{"$nulls":5},"RINGKASAN RSVP"]
[null,"TANGGAL PERNIKAHAN",null,"pencatat undangan pernikahan"]
[null,{"$f":"TODAY()+283","v":"2019-06-23"},null,"NAMA TAMU","TERKIRIM?","RSVP","JUMLAH ORANG","TAMU","HUBUNGAN","ALAMAT","KOTA","PROVINSI","Kode Pos","TELEPON","EMAIL KONTAK"]
[null,"HARI MENUJU ACARA",null,"Nama 1","Ya","Ya",1,"Mempelai Pria","Saudara","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,{"$f":"HariMenujuAcara","v":283},null,"Nama 2","Ya","Tidak",3,"Mempelai Pria","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,"HADIR",null,"Nama 3","Ya","Ya",1,"Lainnya","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,{"$f":"TotalHadir","v":12},null,"Nama 4","Ya","Tidak",2,"Mempelai Wanita","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,"TIDAK HADIR",null,"Nama 5","Ya","Ya",2,"Mempelai Wanita","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,{"$f":"TotalTidakHadir","v":6},null,"Nama 6","Ya","Belum Pasti",null,"Lainnya","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,"BELUM MERESPONS",null,"Nama 7","Ya","Ya",2,"Mempelai Wanita","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[null,{"$f":"RSVPBelumMerespons","v":1},null,"Nama 8","Ya","Tidak",1,"Lainnya","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[{"$nulls":3},"Nama 9","Ya","Ya",4,"Mempelai Pria","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[{"$nulls":3},"Nama 10","Ya","Ya",2,"Mempelai Pria","Teman","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[{"$nulls":3},"Nama 11","Ya",null,null,"Mempelai Wanita","Saudara","Alamat","Kota","Provinsi","Kode Pos","Telepon","seseorang@contoh.com"]
[{"$nulls":3},"TOTAL:",{"$f":"COUNTIF('Pencatat RSVP'!$E$4:$E$14,\"Ya\")","v":11},{"$f":"COUNTA('Pencatat RSVP'!$F$4:$F$14)","v":10},{"$f":"SUBTOTAL(109,tblUndangan[JUMLAH ORANG])","v":18}]

{"sheet":"Ringkasan RSVP","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"merged":[[0,3,0,4],[0,5,0,8],[1,3,1,11],[2,3,6,3],[2,4,6,4],[7,3,11,3],[7,4,11,4]]}
[{"$nulls":3},"PENCATAT RSVP"]
[null,"TANGGAL PERNIKAHAN",null,"ringkasan rsvp",{"$nulls":10},"catatan"]
[null,{"$f":"TanggalPernikahan","v":"2019-06-23"},null,"YA","Bagan batang kluster yang menampilkan tipe Tamu untuk RSVP Ya terletak dalam sel ini."]
[null,"HARI MENUJU ACARA",{"$nulls":3},"LAINNYA",{"$f":"IFERROR(SUMIFS(tblUndangan[JUMLAH ORANG],tblUndangan[TAMU],\"=Lainnya\",tblUndangan[RSVP],\"Ya\"),0)","v":1},{"$f":"tblUndangan[[#Totals],[TERKIRIM?]]","v":11}]
[null,{"$f":"HariMenujuAcara","v":283},{"$nulls":3},"MEMPELAI WANITA",{"$f":"IFERROR(SUMIFS(tblUndangan[JUMLAH ORANG],tblUndangan[TAMU],\"=Mempelai wanita\",tblUndangan[RSVP],\"Ya\"),0)","v":4},{"$f":"tblUndangan[[#Totals],[TERKIRIM?]]","v":11}]
[null,"HADIR",{"$nulls":3},"MEMPELAI PRIA",{"$f":"IFERROR(SUMIFS(tblUndangan[JUMLAH ORANG],tblUndangan[TAMU],\"=Mempelai pria\",tblUndangan[RSVP],\"Ya\"),0)","v":7},{"$f":"tblUndangan[[#Totals],[TERKIRIM?]]","v":11}]
[null,{"$f":"TotalHadir","v":12}]
[null,"TIDAK HADIR",null,"TIDAK","Bagan batang kluster yang menampilkan tipe Tamu untuk RSVP Tidak terletak dalam sel ini."]
[null,{"$f":"TotalTidakHadir","v":6},{"$nulls":3},"LAINNYA",{"$f":"IFERROR(SUMIFS(tblUndangan[JUMLAH ORANG],tblUndangan[TAMU],\"=Lainnya\",tblUndangan[RSVP],\"Tidak\"),0)","v":1},{"$f":"tblUndangan[[#Totals],[TERKIRIM?]]","v":11}]
[null,"BELUM MERESPONS",{"$nulls":3},"MEMPELAI WANITA",{"$f":"IFERROR(SUMIFS(tblUndangan[JUMLAH ORANG],tblUndangan[TAMU],\"=Mempelai wanita\",tblUndangan[RSVP],\"Tidak\"),0)","v":2},{"$f":"tblUndangan[[#Totals],[TERKIRIM?]]","v":11}]
[null,{"$f":"RSVPBelumMerespons","v":1},{"$nulls":3},"MEMPELAI PRIA",{"$f":"IFERROR(SUMIFS(tblUndangan[JUMLAH ORANG],tblUndangan[TAMU],\"=Mempelai pria\",tblUndangan[RSVP],\"Tidak\"),0)","v":3},{"$f":"tblUndangan[[#Totals],[TERKIRIM?]]","v":11}]