function onOpen() {

var ui = SpreadsheetApp.getUi();
// Or DocumentApp or FormApp.
ui.createMenu('🎓 Raport Online')
.addItem('🏡 Dasboard', 'dasboard')
.addSeparator()
.addSubMenu(ui.createMenu('📗 Capaian Kompetensi A')
.addItem(' Pendidikan Agama Islam', 'tppa')
.addItem(' Pendidikan Pancasila', 'tppp')
.addItem(' Bahasa Indonesia', 'tpbi')
.addItem(' Matematika', 'tpmat')
.addItem(' IPA', 'tpipas')
.addItem(' IPS', 'tpmusik')
.addItem(' Informatika', 'tptari'))
.addSubMenu(ui.createMenu('📗 Capaian Kompetensi B')
.addItem(' ASWAJA', 'tprupa')
.addItem('📜 SBK', 'tpteater')
.addItem(' PJOK', 'tppjok')
.addItem(' Bahasa Jawa', 'tpbj')
.addItem(' Bahasa Inggris', 'tpmulok1')
.addItem(' Prakarya', 'tpmulok2'))
//.addItem(' Mulok 3', 'tpmulok3')
//.addItem(' Mulok 4', 'tpmulok4')
//.addItem(' Mulok 5', 'tpmulok5'))
//.addSeparator()
//.addSubMenu(ui.createMenu('📕 Asesmen Formatif')
//.addItem(' Pendidikan Agama Budi Pekerti', 'pa')
//.addItem(' Pendidikan Pancasila', 'pp')
//.addItem(' Bahasa Indonesia', 'bi')
//.addItem(' Matematika', 'mat')
//.addItem(' IPAS', 'ipas')
//.addItem(' Seni Musik', 'musik')
//.addItem(' Seni Tari', 'tari')
//.addItem(' Seni Rupa', 'rupa')
//.addItem(' Seni Teater', 'teater')
//.addItem(' PJOK', 'pjok')
//.addItem(' Bahasa Jawa', 'bj')
//.addItem(' Mulok 1', 'mulok1')
//.addItem(' Mulok 2', 'mulok2')
//.addItem(' Mulok 3', 'mulok3')
//.addItem(' Mulok 4', 'mulok4')
//.addItem(' Mulok 5', 'mulok5'))
.addSeparator()
.addSubMenu(ui.createMenu('📘 Asesmen Sumatif A')
.addItem('➡️️ Pendidikan Agama Islam', 'sumpa')
.addItem('➡️️ Pendidikan Pancasila', 'sumpp')
.addItem('➡️️ Bahasa Indonesia', 'sumbi')
.addItem('➡️️ Matematika', 'summat')
.addItem('➡️️ IPA', 'sumipas')
.addItem('➡️️ IPS', 'summusik')
.addItem('➡️️ Informatika', 'sumtari')
.addItem('➡️️ Aswaja', 'sumrupa'))
.addSubMenu(ui.createMenu('📘 Asesmen Sumatif B')
.addItem('➡️️ SBK', 'sumteater')
.addItem('➡️️ PJOK', 'sumpjok')
.addItem('➡️️ Bahasa Jawa', 'sumbj')
.addItem('➡️️ Bahasa Inggris', 'summ1')
.addItem('➡️️ Prakarya', 'summ2'))
//.addItem('➡️️ Mulok 3', 'summ3')
 //.addItem('➡️️ Mulok 4', 'summ4')
//.addItem('➡️️ Mulok 5', 'summ5'))
.addSeparator()
.addSubMenu(ui.createMenu('⚙️ Pengaturan')
.addItem('🏫 Data Sekolah', 'home')
.addItem(' Data Peserta Didik', 'siswa')
.addItem('📑 Sampul Rapor', 'sampul')
.addItem(' Mutasi','mutasi'))
.addSeparator()
.addSubMenu(ui.createMenu('🚀 Pelaporan Asesmen')
.addItem('📚 Rekap Nilai Akhir', 'leger')
.addItem('📒 Rapor', 'rapor')
.addItem(' Cetak', 'cetak')
.addItem('📙 Buku Induk', 'induk'))
//.addItem('🛗 Prestasi', 'prestasi'))
.addSeparator()
.addSubMenu(ui.createMenu('🚀 Pendukung')
.addItem(' Ekstrakulikuler', 'ekstra')
.addItem('📊 Kehadiran', 'ijin')
.addItem(' Kesehatan', 'sehat')
.addItem(' Saran', 'saran'))
.addSeparator()
.addItem('☎️ Contact Person', 'showSidebar')
.addToUi();
}

function dasboard() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Dashboard", 1, 1);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

//*****PENGATURAN DASAR*****
function home() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Home", 4, 20);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function siswa() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Data Peserta Didik", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
 SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sampul() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Sampul", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mutasi() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Mutasi", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

//*****PELAPORAN ASESMEN*****
function leger() {
// 1 = row 1, 14 = column 14 = N
goToSheet("RekapNA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function rapor() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Rapor", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function cetak() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Cetak", 4, 3);
}
function goToSheet(sheetName, row, col) {
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function induk() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Induk", 4, 3);
}
function goToSheet(sheetName, row, col) {
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function ekstra() {
// 1 = row 1, 14 = column 14 = N
goToSheet("Ekstra", 4, 3);
}
function goToSheet(sheetName, row, col) {
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

//*****CAPAIAN PEMBELAJARAN*****
function tppa() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP PA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tppp() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP PP", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpbi() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP BI", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmat() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP MAT", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpipas() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP IPAS", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmusik() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP MUSIK", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tptari() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP TARI", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tprupa() {
// 1 = row 1, 14 = column 14 = N
 goToSheet("TP RUPA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpteater() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP TEATER", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tppjok() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP PJOK", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpbj() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP BJ", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmulok1() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP MULOK1", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmulok2() {
 // 1 = row 1, 14 = column 14 = N
goToSheet("TP MULOK2", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmulok3() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP MULOK3", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmulok4() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP MULOK4", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function tpmulok5() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TP MULOK5", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

//*****ASESMEN FORMATIF*****
function pa() {
// 1 = row 1, 14 = column 14 = N
goToSheet("PA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function pp() {
// 1 = row 1, 14 = column 14 = N
goToSheet("PP", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function bi() {
// 1 = row 1, 14 = column 14 = N
goToSheet("BI", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mat() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MAT", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function ipas() {
// 1 = row 1, 14 = column 14 = N
goToSheet("IPAS", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function musik() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MUSIK", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
 SpreadsheetApp.setActiveRange(range);
}

function tari() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TARI", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function rupa() {
// 1 = row 1, 14 = column 14 = N
goToSheet("RUPA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function teater() {
// 1 = row 1, 14 = column 14 = N
goToSheet("TEATER", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function pjok() {
// 1 = row 1, 14 = column 14 = N
goToSheet("PJOK", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function bj() {
// 1 = row 1, 14 = column 14 = N
goToSheet("BJ", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
 var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mulok1() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MULOK1", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mulok2() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MULOK2", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mulok3() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MULOK3", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mulok4() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MULOK4", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function mulok5() {
// 1 = row 1, 14 = column 14 = N
goToSheet("MULOK5", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
 SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

//*****ASESMEN SUMATIF*****
function sumpa() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMPA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumpp() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMPP", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumbi() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMBI", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summat() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMMAT", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumipas() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMIPAS", 4, 3);
}
function goToSheet(sheetName, row, col) {
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summusik() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMMUSIK", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumtari() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMTARI", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumrupa() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMRUPA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumteater() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMTEATER", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumpjok() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMPJOK", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sumbj() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMBJ", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summ1() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMM1", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summ2() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMM2", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summ3() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMM3", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summ4() {
// 1 = row 1, 14 = column 14 = N
 goToSheet("SUMM4", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function summ5() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SUMM5", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

//*****PENDUKUNG*****
function ekstra() {
// 1 = row 1, 14 = column 14 = N
goToSheet("EKSTRA", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function ijin() {
// 1 = row 1, 14 = column 14 = N
goToSheet("KEHADIRAN", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function sehat() {
// 1 = row 1, 14 = column 14 = N
goToSheet("KESEHATAN", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}
function saran() {
// 1 = row 1, 14 = column 14 = N
goToSheet("SARAN", 4, 3);
}

function goToSheet(sheetName, row, col) {

var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
SpreadsheetApp.setActiveSheet(sheet);
var range = sheet.getRange(row, col)
SpreadsheetApp.setActiveRange(range);
}

function showSidebar() {
var html = HtmlService.createHtmlOutputFromFile('contact')
.setTitle('🤖 Contact Person');
SpreadsheetApp.getUi() // Or DocumentApp or SlidesApp or FormApp.
.showSidebar(html);
}

Al-Qur’an adalah kitab suci umat Islam yang diturunkan kepada Nabi Muhammad SAW
melalui perantara Malaikat Jibril. Teruntuk kaum muslim, membaca Al-Quran menjadi
salah satu ibadah wajib. Bukan hanya sekadar membacanya saja, tetapi juga
mengamalkan isinya dalam kehidupan sehari-hari juga patut dilakukan bersamaan.