{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["TARGET","DIET","LATIHAN","Perhitungan Bagan"],"not_rendered":{"charts":2,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"TARGET","index":0,"n_rows":14,"n_cols":11,"rows_kept":14}
[null,{"$f":"TODAY()","v":"2022-12-05"},"TARGET",{"$nulls":6},"Latihan","Diet"]
[null,"TANGGAL MULAI","JURNAL LATIHAN & DIET"]
[null,{"$f":"TanggalMulai+121","v":"2023-04-05"},"ANALISIS DIET"]
[null,"TANGGAL BERAKHIR"]
[null,{"v":220,"d":"220.00"}]
[null,"BERAT AWAL"]
[null,{"v":180,"d":"180.00"},"ANALISIS LATIHAN"]
[null,"BERAT AKHIR"]
[null,{"$f":"BeratAwal-BeratAkhir","v":40}]
[null,"TARGET BERAT BADAN TURUN"]
[null,{"$f":"TanggalBerakhir-TanggalMulai","v":121}]
[null,"HARI UNTUK MENURUNKAN"]
[null,{"$f":"TargetBerat/B11","v":{"v":0.3305785123966942,"d":"0.33"}}]
[null,"TURUN PER HARI"]

{"sheet":"DIET","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
[null,"DIET",{"$nulls":4},"Target","Latihan"]
[null,{"$f":"Subjudul","v":"JURNAL LATIHAN & DIET"}]
[null,"TANGGAL","WAKTU","DESKRIPSI","KALORI","KARBOHIDRAT","PROTEIN","LEMAK","CATATAN"]
[null,{"$f":"TanggalMulai","v":"2022-12-05"},"07:00:00","Kopi",1,0,0,0,"Kopi pagi hari"]
[null,{"$f":"TanggalMulai","v":"2022-12-05"},"08:00:00","Bagel",10,10,2,10,"Sarapan ringan"]
[null,{"$f":"TanggalMulai","v":"2022-12-05"},"12:00:00","Makan siang",283,46,18,{"v":3.5,"d":"4"},"Sandwich Kalkun"]
[null,{"$f":"TanggalMulai","v":"2022-12-05"},"19:00:00","Makan malam",500,42,35,25,"Casserole tater tot"]
[null,{"$f":"TanggalMulai+1","v":"2022-12-06"},"07:00:00","Kopi",1,0,0,0,"Kopi pagi hari"]
[null,{"$f":"TanggalMulai+1","v":"2022-12-06"},"08:00:00","Roti panggang",10,10,2,10,"Sarapan ringan"]
[null,{"$f":"TanggalMulai+1","v":"2022-12-06"},"12:00:00","Makan siang",189,26,3,8,"Sandwich"]
[null,{"$f":"TanggalMulai+1","v":"2022-12-06"},"19:00:00","Makan malam",477,62,{"v":13.5,"d":"14"},21,"Makan malam"]
[null,{"$f":"TanggalMulai+2","v":"2022-12-07"},"07:00:00","Kopi",1,0,0,0,"Kopi pagi hari"]
[null,{"$f":"TanggalMulai+2","v":"2022-12-07"},"08:00:00","Bagel",245,48,10,{"v":1.5,"d":"2"},"Sarapan ringan"]
[null,{"$f":"TanggalMulai+2","v":"2022-12-07"},"12:00:00","Makan siang",247,11,43,5,"Salad"]
[null,{"$f":"TanggalMulai+2","v":"2022-12-07"},"19:00:00","Makan malam",456,64,32,22,"Makan malam"]
[null,{"$f":"TanggalMulai+3","v":"2022-12-08"},"07:00:00","Roti panggang",10,10,2,10,"Sarapan ringan"]
[null,{"$f":"TanggalMulai+3","v":"2022-12-08"},"10:00:00","Kopi",135,{"v":12.36,"d":"12"},{"v":8.81,"d":"9"},{"v":5.51,"d":"6"},"Latte"]
[null,{"$f":"TanggalMulai+3","v":"2022-12-08"},"12:15:00","Makan siang",184,7,{"v":5.43,"d":"5"},15,"Salad"]
[null,{"$f":"TanggalMulai+5","v":"2022-12-10"},"19:00:00","Makan malam",477,62,{"v":13.5,"d":"14"},21,"Makan malam"]

{"sheet":"LATIHAN","index":2,"n_rows":20,"n_cols":7,"rows_kept":20}
[null,"LATIHAN",{"$nulls":3},"Diet","Target"]
[null,{"$f":"Subjudul","v":"JURNAL LATIHAN & DIET"}]
[null,"TANGGAL","DURASI (MENIT)","KALORI YANG DIBAKAR","CATATAN"]
[null,{"$f":"TanggalMulai+4","v":"2022-12-09"},30,120,"Latihan treadmill"]
[null,{"$f":"B4+1","v":"2022-12-10"},60,180,"Aerobik intensitas rendah"]
[null,{"$f":"B5+1","v":"2022-12-11"},60,350,"Latihan ekstrem"]
[null,"2022-12-12",30,150,"Latihan treadmill"]
[null,"2022-12-13",25,125,"Lari"]
[null,"2022-12-14",20,285,"Latihan treadmill"]
[null,"2022-12-15",40,205,"Lari"]
[null,"2022-12-16",30,335,"Lari"]
[null,"2022-12-17",40,175,"Lari"]
[null,"2022-12-18",45,325,"Latihan treadmill"]
[null,"2022-12-19",40,270,"Lari"]
[null,"2022-12-20",20,295,"Latihan treadmill"]
[null,"2022-12-21",45,350,"Lari"]
[null,"2022-12-22",35,320,"Lari"]
[null,"2022-12-23",40,290,"Lari"]
[null,{"$f":"B18+1","v":"2022-12-24"},25,265,"Latihan treadmill"]
[null,"2022-12-25",20,195,"Lari"]

{"sheet":"Perhitungan Bagan","index":3,"n_rows":36,"n_cols":10,"rows_kept":36,"hidden":true,"merged":[[1,1,1,9],[19,1,19,9]]}
[]
[null,"DATA PENYUSUN BAGAN ANALISIS DIET"]
[]
[null,"Awal baris",{"$f":"ROW(Diet[[#Headers],[TANGGAL]])+1","v":4},"TANGGAL","HARI","LEMAK","PROTEIN","KARBOHIDRAT","KALORI","Nom"]
[null,"Entri diet terakhir",{"$f":"MATCH(9.99E+307,Diet[TANGGAL])+MulaiBarisDiet-1","v":19},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,1),\"\"),\"\")","v":"2022-12-05"},{"$f":"UPPER(TEXT(D5,\"DDD\"))","v":"SEN"},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,7),NA())),NA())","v":3.5},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,6),NA())),NA())","v":18},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,5),NA())),NA())","v":46},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J5,4),NA())),NA())","v":283},12]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,1),\"\"),\"\")","v":"2022-12-05"},"SEN",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,7),NA())),NA())","v":25},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,6),NA())),NA())","v":35},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,5),NA())),NA())","v":42},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J6,4),NA())),NA())","v":500},11]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,1),\"\"),\"\")","v":"2022-12-06"},"SEL",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,7),NA())),NA())","v":0},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,6),NA())),NA())","v":0},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,5),NA())),NA())","v":0},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J7,4),NA())),NA())","v":1},10]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,1),\"\"),\"\")","v":"2022-12-06"},"SEL",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,7),NA())),NA())","v":10},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,6),NA())),NA())","v":2},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,5),NA())),NA())","v":10},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J8,4),NA())),NA())","v":10},9]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,1),\"\"),\"\")","v":"2022-12-06"},"SEL",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,7),NA())),NA())","v":8},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,6),NA())),NA())","v":3},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,5),NA())),NA())","v":26},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J9,4),NA())),NA())","v":189},8]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,1),\"\"),\"\")","v":"2022-12-06"},"SEL",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,7),NA())),NA())","v":21},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,6),NA())),NA())","v":13.5},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,5),NA())),NA())","v":62},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J10,4),NA())),NA())","v":477},7]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,1),\"\"),\"\")","v":"2022-12-07"},"RAB",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,7),NA())),NA())","v":0},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,6),NA())),NA())","v":0},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,5),NA())),NA())","v":0},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J11,4),NA())),NA())","v":1},6]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,1),\"\"),\"\")","v":"2022-12-07"},"RAB",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,7),NA())),NA())","v":1.5},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,6),NA())),NA())","v":10},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,5),NA())),NA())","v":48},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J12,4),NA())),NA())","v":245},5]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,1),\"\"),\"\")","v":"2022-12-07"},"RAB",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,7),NA())),NA())","v":5},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,6),NA())),NA())","v":43},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,5),NA())),NA())","v":11},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J13,4),NA())),NA())","v":247},4]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,1),\"\"),\"\")","v":"2022-12-07"},"RAB",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,7),NA())),NA())","v":22},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,6),NA())),NA())","v":32},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,5),NA())),NA())","v":64},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J14,4),NA())),NA())","v":456},3]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,1),\"\"),\"\")","v":"2022-12-08"},"KAM",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,7),NA())),NA())","v":10},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,6),NA())),NA())","v":2},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,5),NA())),NA())","v":10},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J15,4),NA())),NA())","v":10},2]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,1),\"\"),\"\")","v":"2022-12-08"},"KAM",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,7),NA())),NA())","v":5.51},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,6),NA())),NA())","v":8.81},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,5),NA())),NA())","v":12.36},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J16,4),NA())),NA())","v":135},1]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,1),\"\"),\"\")","v":"2022-12-08"},"KAM",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,7),NA())),NA())","v":15},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,6),NA())),NA())","v":5.43},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,5),NA())),NA())","v":7},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J17,4),NA())),NA())","v":184},0]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,1)),\"\")","v":"2022-12-10"},"SAB",{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,7),NA())),NA())","v":21},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,6),NA())),NA())","v":13.5},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,5),NA())),NA())","v":62},{"$f":"IFERROR((IF(INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,1)<>\"\",INDEX(Diet[],AkhirTerakhirDiet-MulaiBarisDiet-J18,4),NA())),NA())","v":477},-1]
[]
[null,"DATA PENYUSUN BAGAN ANALISIS LATIHAN"]
[]
[null,"Awal baris",{"$f":"ROW(Latihan[[#Headers],[TANGGAL]])+1","v":4},"TANGGAL","HARI","DURASI (MENIT)","KALORI YANG DIBAKAR","Nom"]
[null,"Entri latihan terakhir",{"$f":"MATCH(9.99E+307,Latihan[TANGGAL])+MulaiBarisLatihan-1","v":20},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H23,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H23,1)),\"\")","v":"2022-12-25"},{"$f":"UPPER(TEXT(D23,\"DDD\"))","v":"MGG"},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H23,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H23,2),0)),0)","v":20},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H23,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H23,3),0)),0)","v":195},-1]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H24,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H24,1)),\"\")","v":"2022-12-24"},"SAB",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H24,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H24,2),0)),0)","v":25},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H24,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H24,3),0)),0)","v":265},0]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H25,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H25,1)),\"\")","v":"2022-12-23"},"JUM",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H25,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H25,2),0)),0)","v":40},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H25,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H25,3),0)),0)","v":290},1]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H26,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H26,1)),\"\")","v":"2022-12-22"},"KAM",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H26,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H26,2),0)),0)","v":35},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H26,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H26,3),0)),0)","v":320},2]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H27,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H27,1)),\"\")","v":"2022-12-21"},"RAB",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H27,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H27,2),0)),0)","v":45},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H27,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H27,3),0)),0)","v":350},3]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H28,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H28,1)),\"\")","v":"2022-12-20"},"SEL",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H28,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H28,2),0)),0)","v":20},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H28,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H28,3),0)),0)","v":295},4]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H29,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H29,1)),\"\")","v":"2022-12-19"},"SEN",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H29,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H29,2),0)),0)","v":40},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H29,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H29,3),0)),0)","v":270},5]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H30,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H30,1)),\"\")","v":"2022-12-18"},"MGG",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H30,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H30,2),0)),0)","v":45},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H30,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H30,3),0)),0)","v":325},6]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H31,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H31,1)),\"\")","v":"2022-12-17"},"SAB",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H31,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H31,2),0)),0)","v":40},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H31,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H31,3),0)),0)","v":175},7]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H32,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H32,1)),\"\")","v":"2022-12-16"},"JUM",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H32,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H32,2),0)),0)","v":30},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H32,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H32,3),0)),0)","v":335},8]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H33,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H33,1)),\"\")","v":"2022-12-15"},"KAM",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H33,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H33,2),0)),0)","v":40},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H33,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H33,3),0)),0)","v":205},9]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H34,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H34,1)),\"\")","v":"2022-12-14"},"RAB",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H34,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H34,2),0)),0)","v":20},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H34,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H34,3),0)),0)","v":285},10]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H35,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H35,1)),\"\")","v":"2022-12-13"},"SEL",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H35,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H35,2),0)),0)","v":25},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H35,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H35,3),0)),0)","v":125},11]
[{"$nulls":3},{"$f":"IFERROR(IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H36,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H36,1)),\"\")","v":"2022-12-12"},"SEN",{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H36,1)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H36,2),0)),0)","v":30},{"$f":"IFERROR((IF(INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H36,2)<>\"\",INDEX(Latihan[],AkhirTerakhirLatihan-MulaiBarisLatihan-H36,3),0)),0)","v":150},12]