{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Mulai","Anggaran Kuliah Bulanan","bagan_perhitungan"],"not_rendered":{"charts":4,"defined_names":19},"read":"whole","date_system":"1900"}

{"sheet":"Mulai","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"TENTANG TEMPLAT INI"]
[null,"Menggunakan lembar kerja Anggaran Kuliah Bulanan untuk melacak pendapatan, pengeluaran, dan arus kas."]
[null,"Memasukkan Pendapatan dan Pengeluaran Bulanan untuk menghitung Total Pendapatan dan Pengeluaran."]
[null,"Arus Kas dihitung secara otomatis, dan bagan Arus Kas diperbarui untuk Anda."]
[null,"Pilih penggeser untuk mendapatkan bagan pendapatan, pengeluaran, dan arus kas selama sebulan dan setahun."]
[null,"Catatan: "]
[null,"Instruksi tambahan telah tersedia di kolom A dalam lembar kerja. Teks ini sengaja disembunyikan. Untuk menghapus teks, pilih kolom A, lalu pilih HAPUS. Untuk memperlihatkan teks, pilih kolom A, lalu ubah warna font."]

{"sheet":"Anggaran Kuliah Bulanan","index":1,"n_rows":72,"n_cols":16,"rows_kept":72,"merged":[[5,1,14,3],[5,4,14,11],[5,12,13,15],[15,1,19,15],[20,1,21,15]]}
["Buat Anggaran Kuliah Bulanan di lembar kerja ini. Judul lembar kerja ada di sel sebelah kanan dan sel B1. Instruksi bermanfaat tentang cara menggunakan lembar kerja ada di sel-sel dalam kolom ini. Instruksi berikutnya ada di sel A4.","Anggaran Kuliah Bulanan"]
[]
[]
["Label Pendapatan ada di sel sebelah kanan, label Pengeluaran di sel E4, dan label Arus Kas di M4.",{"$f":"bagan_perhitungan!$D$6","v":"pendapatan january:"},null,null,{"$f":"bagan_perhitungan!$D$7","v":"pengeluaran january:"},{"$nulls":7},{"$f":"bagan_perhitungan!$D$8","v":"arus kas january:"}]
["Pendapatan diperbarui secara otomatis di sel sebelah kanan, Pengeluaran di sel E5, dan Arus Kas di M5.",{"$f":"\" \"&bagan_perhitungan!$F$6","v":" Rp1225."},null,null,{"$f":"\" \"&bagan_perhitungan!$F$7","v":" Rp1056."},{"$nulls":7},{"$f":"\" \"&bagan_perhitungan!$F$8","v":" Rp169."}]
["Bagan donat yang memperlihatkan ringkasan pendapatan di sel sebelah kanan, ringkasan pengeluaran di sel E6, dan bagan batang yang memperlihatkan arus kas positif dan negatif di sel M6 diperbarui secara otomatis. Instruksi berikutnya ada di sel A17.","Bagan donat yang memperlihatkan ringkasan pendapatan untuk bulan atau tahun yang dipilih ada di sel ini.",null,null,"Bagan donat yang memperlihatkan ringkasan pengeluaran untuk bulan atau tahun yang dipilih ada di sel ini.",{"$nulls":7},"Bagan garis yang memperlihatkan arus kas positif dan negatif untuk bulan atau tahun yang dipilih ada di sel ini."]
{"$rows_empty":9}
[null,"Bagan garis yang memperlihatkan arus kas untuk bulan atau tahun yang dipilih ada di sel ini."]
["Bagan garis arus kas ada di sel sebelah kanan. Instruksi berikutnya ada di sel A21."]
[]
[]
[]
["Pilih penggeser di sebelah kanan untuk mendapatkan data dan bagan Pendapatan, Pengeluaran, dan Arus Kas bulanan dan tahunan. Instruksi berikutnya ada di sel A25.","Penggeser ada di sel ini."]
[]
[]
[]
["Pilih Bulan di sel sebelah kanan. Tekan ALT+PANAH BAWAH untuk menampilkan opsi, lalu PANAH BAWAH dan ENTER untuk memilih.","JAN"]
["Periode yang dipilih diperbarui secara otomatis di sel P26.",{"$nulls":14},{"$f":"PeriodeYangDipilih","v":"JAN "}]
["Label ada di baris ini, label Kas Bulanan Setelah Pengeluaran di sel sebelah kanan, bulan di sel C27 hingga N27, Tahun di O27, dan persen Peningkatan di P27.","Kas Bulanan Setelah Pengeluaran",{"$f":"BulanPertama","v":"JAN "},{"$f":"BulanBerikutnya","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","TAHUN  ","% INC "]
["Label Arus Kas ada di sel sebelah kanan. Arus kas setiap bulan dihitung secara otomatis di sel C28 hingga N28, jumlah Tahunan di O28, dan persen peningkatan di P28. Grafik mini diperbarui secara otomatis di sel Q28.","Arus Kas",{"$f":"C37-C72","v":169},69,192,199,204,{"v":-771,"d":"-771 "},124,154,{"v":-721,"d":"-721 "},109,34,{"v":-61,"d":"-61 "},{"$f":"SUM(C28:N28)","v":{"v":-299,"d":"-299 "}},{"$f":"INDEX($C28:$O28,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":0.13795918367346938,"d":"13.8%"}}]
["Label Arus Kas Kumulatif ada di sel sebelah kanan. Arus Kas Kumulatif setiap bulan dihitung secara otomatis di sel C29 hingga N29, jumlah Tahunan di O29, dan persen peningkatan di P29. Grafik mini diperbarui secara otomatis di sel Q29. Instruksi berikutnya ada di sel A31.","Arus Kas Kumulatif",{"$f":"SUM($C$28:C$28)","v":169},{"$f":"SUM($C$28:D$28)","v":238},{"$f":"SUM($C$28:E$28)","v":430},{"$f":"SUM($C$28:F$28)","v":629},{"$f":"SUM($C$28:G$28)","v":833},{"$f":"SUM($C$28:H$28)","v":62},{"$f":"SUM($C$28:I$28)","v":186},{"$f":"SUM($C$28:J$28)","v":340},{"$f":"SUM($C$28:K$28)","v":{"v":-381,"d":"-381 "}},{"$f":"SUM($C$28:L$28)","v":{"v":-272,"d":"-272 "}},{"$f":"SUM($C$28:M$28)","v":{"v":-238,"d":"-238 "}},{"$f":"SUM($C$28:N$28)","v":{"v":-299,"d":"-299 "}}]
[]
["Label Pendapatan Bulanan ada di sel sebelah kanan, bulan di sel C31 hingga N31, Tahun di O31, dan label persen peningkatan di P31. Masukkan item Pendapatan Bulanan di sel B32 hingga B36 dan jumlah bulanan di sel C32 hingga N36. Pendapatan tahunan dihitung secara otomatis di sel O32 hingga O36, dan persen peningkatan di sel P32 hingga P36. Instruksi berikutnya ada di sel A37.","PENDAPATAN BULANAN",{"$f":"BulanPertama","v":"JAN "},{"$f":"BulanBerikutnya","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","TAHUN  ","% INC "]
[null,"Bantuan keuangan (hibah, beasiswa, pinjaman) yang dibayarkan kepada Anda",0,0,750,750,750,750,750,750,750,750,750,750,{"$f":"SUM(C32:N32)","v":7500},{"$f":"INDEX($C32:$O32,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,"Upah setelah pajak dari pekerjaan",450,450,450,450,450,450,450,450,550,350,350,350,5200,{"$f":"INDEX($C33:$O33,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":0.3673469387755102,"d":"36.7%"}}]
[null,"Bantuan keuangan dari keluarga",200,200,{"v":1000,"d":"1,000"},350,350,350,350,350,350,350,350,350,4550,{"$f":"INDEX($C34:$O34,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":0.16326530612244897,"d":"16.3%"}}]
[null,"Penarikan dari tabungan",500,350,150,0,0,0,0,0,0,0,0,0,1000,{"$f":"INDEX($C35:$O35,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":0.40816326530612246,"d":"40.8%"}}]
[null,"Lainnya (dukungan anak, bantuan umum, hadiah, dll.)",75,75,75,75,75,75,75,75,75,75,75,75,900,{"$f":"INDEX($C36:$O36,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":0.061224489795918366,"d":"6.1%"}}]
["Label Total Pendapatan ada di sel sebelah kanan. Total Pendapatan setiap bulan dihitung secara otomatis di sel C37 hingga N37, pendapatan Tahunan di O37, dan persen peningkatan di P37. Grafik mini diperbarui secara otomatis di sel Q37. Instruksi berikutnya ada di sel A39.","TOTAL PENDAPATAN",{"$f":"SUM(C32:C36)","v":1225},1075,2425,1625,1625,1625,1625,1625,1725,1525,1525,1525,19150,{"$f":"INDEX($C37:$O37,,KolomPeriodeYangDipilih)/INDEX($C$37:$O$37,,KolomPeriodeYangDipilih)","v":{"v":1,"d":"100.0%"}}]
[]
["Label Pengeluaran Bulanan ada di sel sebelah kanan, bulan di sel C39 hingga N39, Tahun di O39, dan label persen peningkatan di P39.","PENGELUARAN BULANAN",{"$f":"BulanPertama","v":"JAN "},{"$f":"BulanBerikutnya","v":"FEB "},"MAR ","APR ","MAY ","JUN ","JUL ","AUG ","SEP ","OCT ","NOV ","DEC ","TAHUN  ","% INC "]
["Masukkan atau ubah item pengeluaran di sel sebelah kanan, dan jumlah bulanan di sel C40 hingga N43. Jumlah tahunan dihitung secara otomatis di sel O40 hingga O43, dan persen peningkatan di sel P40 hingga P43. Grafik mini diperbarui secara otomatis di sel Q40. Instruksi berikutnya ada di sel A45.","Asrama",{"$f":"SUM(C41:C43)","v":565},565,565,565,565,565,565,565,565,565,565,565,{"$f":"SUM(C40:N40)","v":6780},{"$f":"INDEX($C40:$O40,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.5350378787878788,"d":"53.5%"}}]
[null,null,315,315,315,315,315,315,315,315,315,315,315,315,{"$f":"SUM(C41:N41)","v":3780},{"$f":"INDEX($C41:$O41,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.29829545454545453,"d":"29.8%"}}]
[null,null,200,200,200,200,200,200,200,200,200,200,200,200,{"$f":"SUM(C42:N42)","v":2400},{"$f":"INDEX($C42:$O42,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.1893939393939394,"d":"18.9%"}}]
[null,null,50,50,50,50,50,50,50,50,50,50,50,50,{"$f":"SUM(C43:N43)","v":600},{"$f":"INDEX($C43:$O43,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.04734848484848485,"d":"4.7%"}}]
[]
["Masukkan atau ubah item pengeluaran di sel sebelah kanan, dan jumlah bulanan di sel C45 hingga N47. Jumlah tahunan dihitung secara otomatis di sel O45 hingga O47, dan persen peningkatan di sel P45 hingga P47. Grafik mini diperbarui secara otomatis di sel Q45. Instruksi berikutnya ada di sel A49.","Uang Sekolah",{"$f":"SUM(C46:C47)","v":0},0,750,0,0,650,0,0,650,0,0,0,{"$f":"SUM(C45:N45)","v":2050},{"$f":"INDEX($C45:$O45,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,500,0,0,500,0,0,500,0,0,0,{"$f":"SUM(C46:N46)","v":1500},{"$f":"INDEX($C46:$O46,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,250,0,0,150,0,0,150,0,0,0,{"$f":"SUM(C47:N47)","v":550},{"$f":"INDEX($C47:$O47,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[]
["Masukkan atau ubah item pengeluaran di sel sebelah kanan, dan jumlah bulanan di sel C49 hingga N51. Jumlah tahunan dihitung secara otomatis di sel O49 hingga O51, dan persen peningkatan di sel P49 hingga P51. Grafik mini diperbarui secara otomatis di sel Q49. Instruksi berikutnya ada di sel A53.","Buku dan Alat Tulis",{"$f":"SUM(C50:C51)","v":0},0,325,20,20,325,10,10,400,15,15,15,{"$f":"SUM(C49:N49)","v":1155},{"$f":"INDEX($C49:$O49,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,225,0,0,275,0,0,325,0,0,0,{"$f":"SUM(C50:N50)","v":825},{"$f":"INDEX($C50:$O50,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,100,20,20,50,10,10,75,15,15,15,{"$f":"SUM(C51:N51)","v":330},{"$f":"INDEX($C51:$O51,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[]
["Masukkan atau ubah item pengeluaran di sel sebelah kanan, dan jumlah bulanan di sel C53 hingga N57. Jumlah tahunan dihitung secara otomatis di sel O53 hingga O57, dan persen peningkatan di sel P53 hingga P57. Grafik mini diperbarui secara otomatis di sel Q53. Instruksi berikutnya ada di sel A59.","Transportasi",{"$f":"SUM(C54:C57)","v":224},174,174,219,174,174,274,219,174,174,224,269,{"$f":"SUM(C53:N53)","v":2473},{"$f":"INDEX($C53:$O53,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.21212121212121213,"d":"21.2%"}}]
[null,null,30,30,30,75,30,30,30,75,30,30,30,75,{"$f":"SUM(C54:N54)","v":495},{"$f":"INDEX($C54:$O54,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.028409090909090908,"d":"2.8%"}}]
[null,null,129,129,129,129,129,129,129,129,129,129,129,129,{"$f":"SUM(C55:N55)","v":1548},{"$f":"INDEX($C55:$O55,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.12215909090909091,"d":"12.2%"}}]
[null,null,15,15,15,15,15,15,15,15,15,15,15,15,{"$f":"SUM(C56:N56)","v":180},{"$f":"INDEX($C56:$O56,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.014204545454545454,"d":"1.4%"}}]
[null,null,50,0,0,0,0,0,100,0,0,0,50,50,{"$f":"SUM(C57:N57)","v":250},{"$f":"INDEX($C57:$O57,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.04734848484848485,"d":"4.7%"}}]
[]
["Masukkan atau ubah item pengeluaran di sel sebelah kanan, dan jumlah bulanan di sel C59 hingga N65. Jumlah tahunan dihitung secara otomatis di sel O59 hingga O65, dan persen peningkatan di sel P59 hingga P65. Grafik mini diperbarui secara otomatis di sel Q59. Instruksi berikutnya ada di sel A67.","Diskresioner",{"$f":"SUM(C60:C65)","v":69},69,169,369,419,444,419,419,394,394,419,469,{"$f":"SUM(C59:N59)","v":4053},{"$f":"INDEX($C59:$O59,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.06534090909090909,"d":"6.5%"}}]
[null,null,0,0,0,50,100,100,100,100,75,75,100,100,800,{"$f":"INDEX($C60:$O60,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,69,69,69,69,69,69,69,69,69,69,69,69,828,{"$f":"INDEX($C61:$O61,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.06534090909090909,"d":"6.5%"}}]
[null,null,0,0,0,0,0,25,0,0,0,0,0,50,75,{"$f":"INDEX($C62:$O62,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,100,100,100,100,100,100,100,100,100,100,1000,{"$f":"INDEX($C63:$O63,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,0,50,50,50,50,50,50,50,50,50,450,{"$f":"INDEX($C64:$O64,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,0,0,0,100,100,100,100,100,100,100,100,100,900,{"$f":"INDEX($C65:$O65,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[]
["Masukkan atau ubah item pengeluaran di sel sebelah kanan, dan jumlah bulanan di sel C67 hingga N70. Jumlah tahunan dihitung secara otomatis di sel O67 hingga O70, dan persen peningkatan di sel P67 hingga P70. Grafik mini diperbarui secara otomatis di sel Q67. Instruksi berikutnya ada di sel A72.","Pengeluaran Lain",{"$f":"SUM(C68:C70)","v":198},{"$f":"SUM(D68:D70)","v":198},250,253,243,238,233,258,263,268,268,268,{"$f":"SUM(C67:N67)","v":2938},{"$f":"INDEX($C67:$O67,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.1875,"d":"18.8%"}}]
[null,null,123,123,123,123,123,123,123,123,123,123,123,123,{"$f":"SUM(C68:N68)","v":1476},{"$f":"INDEX($C68:$O68,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.11647727272727272,"d":"11.6%"}}]
[null,null,0,0,52,55,45,40,35,60,65,70,70,70,{"$f":"SUM(C69:N69)","v":562},{"$f":"INDEX($C69:$O69,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0,"d":"0.0%"}}]
[null,null,75,75,75,75,75,75,75,75,75,75,75,75,{"$f":"SUM(C70:N70)","v":900},{"$f":"INDEX($C70:$O70,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":0.07102272727272728,"d":"7.1%"}}]
[]
["Label Total Pengeluaran ada di sel sebelah kanan. Total Pengeluaran setiap bulan dihitung secara otomatis di sel C72 hingga N72, pengeluaran Tahunan di O72, dan persen peningkatan di P72. Grafik mini diperbarui secara otomatis di sel Q72.","TOTAL PENGELUARAN",{"$f":"SUM(C40,C45,C49,C53,C59,C67)","v":1056},1006,2233,1426,1421,2396,1501,1471,2446,1416,1491,1586,{"$f":"SUM(C72:N72)","v":19449},{"$f":"INDEX($C72:$O72,,KolomPeriodeYangDipilih)/INDEX($C$72:$O$72,,KolomPeriodeYangDipilih)","v":{"v":1,"d":"100.0%"}}]

{"sheet":"bagan_perhitungan","index":2,"n_rows":23,"n_cols":16,"rows_kept":23,"hidden":true}
["***Lembar ini harus tetap TERSEMBUNYI***"]
[]
[{"$nulls":3},{"$f":"IFERROR(LOWER(TEXT(VALUE(PeriodeYangDipilih&\" 1\"),\"mmmm\")),\"tahun\")","v":"january"}]
[]
[{"$nulls":3},"Judul Bagan Dinamis"]
[{"$nulls":3},{"$f":"\"pendapatan \"&D3&\":\"","v":"pendapatan january:"},null,{"$f":"TEXT(INDEX('Anggaran Kuliah Bulanan'!$C$37:$O$37,,KolomPeriodeYangDipilih),\"Rp#.###\")","v":"Rp1225."}]
[{"$nulls":3},{"$f":"\"pengeluaran \"&D3&\":\"","v":"pengeluaran january:"},null,{"$f":"TEXT(INDEX('Anggaran Kuliah Bulanan'!$C$72:$O$72,,KolomPeriodeYangDipilih),\"Rp#.###\")","v":"Rp1056."}]
[{"$nulls":3},{"$f":"\"arus kas \"&D3&\":\"","v":"arus kas january:"},{"$f":"INDEX('Anggaran Kuliah Bulanan'!C28:O28,BilahGulirNilai)","v":169},{"$f":"TEXT(E8,\"Rp#.###\")","v":"Rp169."}]
[]
[]
[]
[{"$nulls":3},{"$f":"LOWER('Anggaran Kuliah Bulanan'!C27)","v":"jan "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!D27)","v":"feb "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!E27)","v":"mar "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!F27)","v":"apr "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!G27)","v":"may "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!H27)","v":"jun "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!I27)","v":"jul "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!J27)","v":"aug "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!K27)","v":"sep "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!L27)","v":"oct "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!M27)","v":"nov "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!N27)","v":"dec "},{"$f":"LOWER('Anggaran Kuliah Bulanan'!O27)","v":"tahun  "}]
[null,null,"Nilai Bilah Gulir: ",1]
[null,null,"Bagan Arus Kas: ",{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!C$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28>=0,'Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":69},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!D$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!E$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!F$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!G$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!H$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!I$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!J$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!K$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!L$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!M$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!N$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!O$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}}]
[null,null,"Kumulatif: ",{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!C$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28<0,'Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!D$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!E$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!F$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!G$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!H$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!I$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!J$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!K$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!L$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!M$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!N$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}},{"$f":"IF(PeriodeYangDipilih='Anggaran Kuliah Bulanan'!O$31,IF('Anggaran Kuliah Bulanan'!$C$28:$O$28,NA()),NA())","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"DATA BAGAN PENDAPATAN"]
[null,null,"Bantuan keuangan (hibah, beasiswa, pinjaman) yang dibayarkan kepada Anda",{"$f":"'Anggaran Kuliah Bulanan'!P32","v":{"v":0,"d":"0.0%"}}]
[null,null,"Upah setelah pajak dari pekerjaan",{"$f":"'Anggaran Kuliah Bulanan'!P33","v":{"v":0.3673469387755102,"d":"36.7%"}}]
[null,null,"Bantuan keuangan dari keluarga",{"$f":"'Anggaran Kuliah Bulanan'!P34","v":{"v":0.16326530612244897,"d":"16.3%"}}]
[null,null,"Penarikan dari tabungan",{"$f":"'Anggaran Kuliah Bulanan'!P35","v":{"v":0.40816326530612246,"d":"40.8%"}}]
[null,null,"Lainnya (dukungan anak, bantuan umum, hadiah, dll.)",{"$f":"'Anggaran Kuliah Bulanan'!P36","v":{"v":0.061224489795918366,"d":"6.1%"}}]