{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Panduan","Arus Kas Harian","Arus Kas Bulanan","Arus Kas Tahunan","Pendapatan","Pengeluaran","Diskresioner","Tabungan"],"not_rendered":{"charts":4,"defined_names":35,"pivot_tables":8},"read":"whole","date_system":"1900"}

{"sheet":"Panduan","index":0,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[1,1,1,7],[2,1,2,8]]}
[{"$nulls":11}," "]
[null,"ARUS KAS PRIBADI"]
[null,"  Buku kerja ini memiliki lembar kerja arus kas tahunan, bulanan, dan harian. \n  Pilih tipe arus kas yang paling sesuai untuk Anda atau gunakan semuanya untuk membantu mendapatkan wawasan tentang arus kas pribadi."]
[]
[null,"Arus Kas Harian",null,null,"Arus Kas Bulanan",null,null,"Arus Kas Tahunan"]
[]
[null,"Masukkan perkiraan jumlah arus kas yang dialami setiap hari dan tinjau total bulanan dan tahunan yang diperkirakan.  Gunakan ini untuk memahami kebiasaan pengeluaran harian Anda dalam sebulan atau setahun.",null,null,"Masukkan arus kas bulanan yang terjadi per bulan atau perkirakan sisa bulan untuk melihat rencana arus kas bagi tahun tersebut per bulannya.",null,null,"Masukkan jumlah arus kas tahunan dalam empat lembar kerja: Pendapatan, Pengeluaran, Kebijakan, dan Tabungan. \nLihat perincian bulanannya dan perbandingan semuanya, dan yang terpenting adalah keuntungan dalam jumlah tahunan dan bulanan."]

{"sheet":"Arus Kas Harian","index":1,"n_rows":55,"n_cols":6,"rows_kept":55,"merged":[[1,3,1,4],[1,5,1,8]]}
[null,"ARUS KAS PRIBADI"]
[null,null,"Total Kas Tersedia:",{"$f":"ArusKasHarian","v":{"v":577.8399999999999,"d":"Rp577.84"}},null,"CATATAN: Jika ingin menambahkan item harian ke Tabel, perkirakan jumlah/nilai bulanan dan tempatkan nilai dalam kolom bulan yang sesuai."]
[]
[null,"RINGKASAN HARIAN"]
[null,"Total","Harian","Bulanan","Tahunan "]
[null,"Pendapatan",{"$f":"SUMIF(Harian[Tipe],$B6,Harian[Harian])","v":{"v":342.47,"d":"Rp342.47"}},{"$f":"SUMIF(Harian[Tipe],$B6,Harian[Bulanan])","v":{"v":10416.795833333334,"d":"Rp10,416.80"}},{"$f":"SUMIF(Harian[Tipe],$B6,Harian[Tahunan])","v":{"v":125001.55000000002,"d":"Rp125,001.55"}}]
[null,"Pengeluaran",{"$f":"SUMIF(Harian[Tipe],$B7,Harian[Harian])","v":{"v":136.05999999999997,"d":"Rp136.06"}},{"$f":"SUMIF(Harian[Tipe],$B7,Harian[Bulanan])","v":{"v":4138.491666666667,"d":"Rp4,138.49"}},{"$f":"SUMIF(Harian[Tipe],$B7,Harian[Tahunan])","v":{"v":49661.899999999994,"d":"Rp49,661.90"}}]
[null,"Diskresioner",{"$f":"SUMIF(Harian[Tipe],$B8,Harian[Harian])","v":{"v":36.29,"d":"Rp36.29"}},{"$f":"SUMIF(Harian[Tipe],$B8,Harian[Bulanan])","v":{"v":1103.8208333333334,"d":"Rp1,103.82"}},{"$f":"SUMIF(Harian[Tipe],$B8,Harian[Tahunan])","v":{"v":13245.849999999999,"d":"Rp13,245.85"}}]
[null,"Tabungan",{"$f":"SUMIF(Harian[Tipe],$B9,Harian[Harian])","v":{"v":63.019999999999996,"d":"Rp63.02"}},{"$f":"SUMIF(Harian[Tipe],$B9,Harian[Bulanan])","v":{"v":1916.8583333333333,"d":"Rp1,916.86"}},{"$f":"SUMIF(Harian[Tipe],$B9,Harian[Tahunan])","v":{"v":23002.300000000003,"d":"Rp23,002.30"}}]
[]
[null,"Tipe","Deskripsi","Harian","Bulanan","Tahunan"]
[null,"Pendapatan","Gaji",{"v":246.58,"d":"Rp246.58"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":7500.141666666667,"d":"Rp7,500.14"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":90001.70000000001,"d":"Rp90,001.70"}}]
[null,"Pendapatan","Komisi/bonus",{"v":13.7,"d":"Rp13.70"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":416.7083333333333,"d":"Rp416.71"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":5000.5,"d":"Rp5,000.50"}}]
[null,"Pendapatan","Lain-lain 1",{"v":82.19,"d":"Rp82.19"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":2499.945833333333,"d":"Rp2,499.95"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":29999.35,"d":"Rp29,999.35"}}]
[null,"Pendapatan","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pendapatan","Lain-lain 3",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pendapatan","Lain-lain 4",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pengeluaran","Federal/SS/Medicare",{"v":41.1,"d":"Rp41.10"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":1250.125,"d":"Rp1,250.13"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":15001.5,"d":"Rp15,001.50"}}]
[null,"Pengeluaran","Pajak Pendapatan Daerah",{"v":6.85,"d":"Rp6.85"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":208.35416666666666,"d":"Rp208.35"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":2500.25,"d":"Rp2,500.25"}}]
[null,"Pengeluaran","Pajak/Biaya Kendaraan",{"v":0.55,"d":"Rp0.55"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":16.729166666666668,"d":"Rp16.73"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":200.75000000000003,"d":"Rp200.75"}}]
[null,"Pengeluaran","Pembayaran Kendaraan",{"v":10.96,"d":"Rp10.96"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":333.3666666666667,"d":"Rp333.37"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":4000.4,"d":"Rp4,000.40"}}]
[null,"Pengeluaran","Hipotek/Sewa",{"v":41.1,"d":"Rp41.10"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":1250.125,"d":"Rp1,250.13"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":15001.5,"d":"Rp15,001.50"}}]
[null,"Pengeluaran","Asuransi",{"v":0.68,"d":"Rp0.68"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":20.683333333333334,"d":"Rp20.68"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":248.20000000000002,"d":"Rp248.20"}}]
[null,"Pengeluaran","Listrik",{"v":3.29,"d":"Rp3.29"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"Rp100.07"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"Rp1,200.85"}}]
[null,"Pengeluaran","Bahan bakar",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Pengeluaran","Air",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Pengeluaran","Selokan",{"v":0.82,"d":"Rp0.82"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":24.941666666666663,"d":"Rp24.94"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":299.29999999999995,"d":"Rp299.30"}}]
[null,"Pengeluaran","Sampah",{"v":0.41,"d":"Rp0.41"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":12.470833333333331,"d":"Rp12.47"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":149.64999999999998,"d":"Rp149.65"}}]
[null,"Pengeluaran","Telepon",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Pengeluaran","Internet",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Pengeluaran","Prem Disabilitas",{"v":4.11,"d":"Rp4.11"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":125.0125,"d":"Rp125.01"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":1500.15,"d":"Rp1,500.15"}}]
[null,"Pengeluaran","Makanan",{"v":13.7,"d":"Rp13.70"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":416.7083333333333,"d":"Rp416.71"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":5000.5,"d":"Rp5,000.50"}}]
[null,"Pengeluaran","Pakaian",{"v":3.29,"d":"Rp3.29"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"Rp100.07"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"Rp1,200.85"}}]
[null,"Pengeluaran","Medis/Gigi/Rx",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Pengeluaran","Bus",{"v":1,"d":"Rp1.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":30.416666666666668,"d":"Rp30.42"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":365,"d":"Rp365.00"}}]
[null,"Pengeluaran","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pengeluaran","Lain-lain 3",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pengeluaran","Lain-lain 4",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Diskresioner","Makan di Luar",{"v":3.29,"d":"Rp3.29"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"Rp100.07"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"Rp1,200.85"}}]
[null,"Diskresioner","Hadiah",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Diskresioner","Perjalanan",{"v":6.16,"d":"Rp6.16"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":187.36666666666667,"d":"Rp187.37"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":2248.4,"d":"Rp2,248.40"}}]
[null,"Diskresioner","Hiburan",{"v":3.29,"d":"Rp3.29"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":100.07083333333333,"d":"Rp100.07"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":1200.85,"d":"Rp1,200.85"}}]
[null,"Diskresioner","Perawatan Pribadi",{"v":0.82,"d":"Rp0.82"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":24.941666666666663,"d":"Rp24.94"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":299.29999999999995,"d":"Rp299.30"}}]
[null,"Diskresioner","Belanja",{"v":5.48,"d":"Rp5.48"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":166.68333333333334,"d":"Rp166.68"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":2000.2,"d":"Rp2,000.20"}}]
[null,"Diskresioner","Amal",{"v":1.64,"d":"Rp1.64"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":49.883333333333326,"d":"Rp49.88"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":598.5999999999999,"d":"Rp598.60"}}]
[null,"Diskresioner","Klub/Keanggotaan",{"v":0.82,"d":"Rp0.82"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":24.941666666666663,"d":"Rp24.94"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":299.29999999999995,"d":"Rp299.30"}}]
[null,"Diskresioner","Renovasi Rumah",{"v":13.15,"d":"Rp13.15"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":399.9791666666667,"d":"Rp399.98"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":4799.75,"d":"Rp4,799.75"}}]
[null,"Diskresioner","Lain-lain 1",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Diskresioner","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Tabungan","Cadangan Kas",{"v":13.7,"d":"Rp13.70"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":416.7083333333333,"d":"Rp416.71"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":5000.5,"d":"Rp5,000.50"}}]
[null,"Tabungan","Pensiun/Dll",{"v":32.88,"d":"Rp32.88"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":1000.1,"d":"Rp1,000.10"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":12001.2,"d":"Rp12,001.20"}}]
[null,"Tabungan","Rekening Tabungan",{"v":16.44,"d":"Rp16.44"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":500.05,"d":"Rp500.05"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":6000.6,"d":"Rp6,000.60"}}]
[null,"Tabungan","Lain-lain 1",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Tabungan","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Harian[[#This Row],[Tahunan]]/12","v":{"v":0,"d":"Rp0.00"}},{"$f":"Harian[[#This Row],[Harian]]*365","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",null,{"$f":"SUMIF(Harian[Tipe],\"Pendapatan\",Harian[Harian])-SUMIF(Harian[Tipe],\"<>Pendapatan\",Harian[Harian])","v":{"v":107.10000000000014,"d":"Rp107.10"}},{"$f":"SUMIF(Harian[Tipe],\"Pendapatan\",Harian[Bulanan])-SUMIF(Harian[Tipe],\"<>Pendapatan\",Harian[Bulanan])","v":{"v":3257.625,"d":"Rp3,257.63"}},{"$f":"SUMIF(Harian[Tipe],\"Pendapatan\",Harian[Tahunan])-SUMIF(Harian[Tipe],\"<>Pendapatan\",Harian[Tahunan])","v":{"v":39091.500000000015,"d":"Rp39,091.50"}}]

{"sheet":"Arus Kas Bulanan","index":2,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[1,3,1,4],[1,5,1,10]]}
[null,"ARUS KAS PRIBADI",{"$nulls":15}," "]
[null,null,"Total Arus Kas Bulanan:",{"$f":"ArusKasBulananSaatIni","v":{"v":18380,"d":"Rp18,380.00"}},null,"CATATAN: Untuk item harian, perkirakan jumlah/nilai bulanan dan tempatkan nilai tersebut dalam kolom bulan yang sesuai.\n"]
[]
[null,"Tipe","Deskripsi","Jan","Feb","Mar","Apr","Mei","Jun","Jul","Agu","Sep","Okt","Nov","Des","Total"]
[null,"Pendapatan","Gaji",{"v":7500,"d":"Rp7,500.00"},{"v":7500,"d":"Rp7,500.00"},{"v":7500,"d":"Rp7,500.00"},{"v":7500,"d":"Rp7,500.00"},{"v":7500,"d":"Rp7,500.00"},{"v":7500,"d":"Rp7,500.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":45000,"d":"Rp45,000.00"}}]
[null,"Pendapatan","Komisi/bonus",{"v":400,"d":"Rp400.00"},{"v":400,"d":"Rp400.00"},{"v":500,"d":"Rp500.00"},{"v":200,"d":"Rp200.00"},{"v":0,"d":"Rp0.00"},{"v":600,"d":"Rp600.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":2100,"d":"Rp2,100.00"}}]
[null,"Pendapatan","Lain-lain 1",{"v":2500,"d":"Rp2,500.00"},{"v":2500,"d":"Rp2,500.00"},{"v":2500,"d":"Rp2,500.00"},{"v":2500,"d":"Rp2,500.00"},{"v":2500,"d":"Rp2,500.00"},{"v":2500,"d":"Rp2,500.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":15000,"d":"Rp15,000.00"}}]
[null,"Pendapatan","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pendapatan","Lain-lain 3",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pendapatan","Lain-lain 4",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pengeluaran","Federal/SS/Medicare",{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":7500,"d":"Rp7,500.00"}}]
[null,"Pengeluaran","Pajak Pendapatan Daerah",{"v":208.33333333333334,"d":"Rp208.33"},{"v":208.33333333333334,"d":"Rp208.33"},{"v":208.33333333333334,"d":"Rp208.33"},{"v":208.33333333333334,"d":"Rp208.33"},{"v":208.33333333333334,"d":"Rp208.33"},{"v":208.33333333333334,"d":"Rp208.33"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":1250,"d":"Rp1,250.00"}}]
[null,"Pengeluaran","Pajak/Biaya Kendaraan",{"v":16.666666666666668,"d":"Rp16.67"},{"v":16.666666666666668,"d":"Rp16.67"},{"v":16.666666666666668,"d":"Rp16.67"},{"v":16.666666666666668,"d":"Rp16.67"},{"v":16.666666666666668,"d":"Rp16.67"},{"v":16.666666666666668,"d":"Rp16.67"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":100.00000000000001,"d":"Rp100.00"}}]
[null,"Pengeluaran","Pembayaran Kendaraan",{"v":333.3333333333333,"d":"Rp333.33"},{"v":333.3333333333333,"d":"Rp333.33"},{"v":333.3333333333333,"d":"Rp333.33"},{"v":333.3333333333333,"d":"Rp333.33"},{"v":333.3333333333333,"d":"Rp333.33"},{"v":333.3333333333333,"d":"Rp333.33"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":1999.9999999999998,"d":"Rp2,000.00"}}]
[null,"Pengeluaran","Hipotek/Sewa",{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"v":1250,"d":"Rp1,250.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":7500,"d":"Rp7,500.00"}}]
[null,"Pengeluaran","Asuransi",{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":150,"d":"Rp150.00"}}]
[null,"Pengeluaran","Listrik",{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":600,"d":"Rp600.00"}}]
[null,"Pengeluaran","Bahan bakar",{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":300,"d":"Rp300.00"}}]
[null,"Pengeluaran","Air",{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":300,"d":"Rp300.00"}}]
[null,"Pengeluaran","Selokan",{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":150,"d":"Rp150.00"}}]
[null,"Pengeluaran","Sampah",{"v":12.5,"d":"Rp12.50"},{"v":12.5,"d":"Rp12.50"},{"v":12.5,"d":"Rp12.50"},{"v":12.5,"d":"Rp12.50"},{"v":12.5,"d":"Rp12.50"},{"v":12.5,"d":"Rp12.50"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":75,"d":"Rp75.00"}}]
[null,"Pengeluaran","Telepon",{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":300,"d":"Rp300.00"}}]
[null,"Pengeluaran","Internet",{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":300,"d":"Rp300.00"}}]
[null,"Pengeluaran","Prem Disabilitas",{"v":125,"d":"Rp125.00"},{"v":125,"d":"Rp125.00"},{"v":125,"d":"Rp125.00"},{"v":125,"d":"Rp125.00"},{"v":125,"d":"Rp125.00"},{"v":125,"d":"Rp125.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":750,"d":"Rp750.00"}}]
[null,"Pengeluaran","Makanan",{"v":400,"d":"Rp400.00"},{"v":500,"d":"Rp500.00"},{"v":450,"d":"Rp450.00"},{"v":400,"d":"Rp400.00"},{"v":450,"d":"Rp450.00"},{"v":425,"d":"Rp425.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":2625,"d":"Rp2,625.00"}}]
[null,"Pengeluaran","Pakaian",{"v":50,"d":"Rp50.00"},{"v":75,"d":"Rp75.00"},{"v":100,"d":"Rp100.00"},{"v":75,"d":"Rp75.00"},{"v":125,"d":"Rp125.00"},{"v":75,"d":"Rp75.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":500,"d":"Rp500.00"}}]
[null,"Pengeluaran","Medis/Gigi/Rx",{"v":50,"d":"Rp50.00"},{"v":10,"d":"Rp10.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":20,"d":"Rp20.00"},{"v":70,"d":"Rp70.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":200,"d":"Rp200.00"}}]
[null,"Pengeluaran","Bus",{"v":30,"d":"Rp30.00"},{"v":30,"d":"Rp30.00"},{"v":30,"d":"Rp30.00"},{"v":20,"d":"Rp20.00"},{"v":30,"d":"Rp30.00"},{"v":30,"d":"Rp30.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":170,"d":"Rp170.00"}}]
[null,"Pengeluaran","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pengeluaran","Lain-lain 3",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Pengeluaran","Lain-lain 4",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Diskresioner","Makan di Luar",{"v":50,"d":"Rp50.00"},{"v":150,"d":"Rp150.00"},{"v":100,"d":"Rp100.00"},{"v":50,"d":"Rp50.00"},{"v":150,"d":"Rp150.00"},{"v":100,"d":"Rp100.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":600,"d":"Rp600.00"}}]
[null,"Diskresioner","Hadiah",{"v":25,"d":"Rp25.00"},{"v":75,"d":"Rp75.00"},{"v":50,"d":"Rp50.00"},{"v":25,"d":"Rp25.00"},{"v":75,"d":"Rp75.00"},{"v":50,"d":"Rp50.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":300,"d":"Rp300.00"}}]
[null,"Diskresioner","Perjalanan",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":1000,"d":"Rp1,000.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":1000,"d":"Rp1,000.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":2000,"d":"Rp2,000.00"}}]
[null,"Diskresioner","Hiburan",{"v":50,"d":"Rp50.00"},{"v":150,"d":"Rp150.00"},{"v":100,"d":"Rp100.00"},{"v":50,"d":"Rp50.00"},{"v":150,"d":"Rp150.00"},{"v":100,"d":"Rp100.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":600,"d":"Rp600.00"}}]
[null,"Diskresioner","Perawatan Pribadi",{"v":15,"d":"Rp15.00"},{"v":25,"d":"Rp25.00"},{"v":35,"d":"Rp35.00"},{"v":15,"d":"Rp15.00"},{"v":25,"d":"Rp25.00"},{"v":35,"d":"Rp35.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":150,"d":"Rp150.00"}}]
[null,"Diskresioner","Belanja",{"v":100,"d":"Rp100.00"},{"v":200,"d":"Rp200.00"},{"v":150,"d":"Rp150.00"},{"v":175,"d":"Rp175.00"},{"v":150,"d":"Rp150.00"},{"v":175,"d":"Rp175.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":950,"d":"Rp950.00"}}]
[null,"Diskresioner","Amal",{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"v":50,"d":"Rp50.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":300,"d":"Rp300.00"}}]
[null,"Diskresioner","Klub/Keanggotaan",{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":150,"d":"Rp150.00"}}]
[null,"Diskresioner","Renovasi Rumah",{"v":400,"d":"Rp400.00"},{"v":400,"d":"Rp400.00"},{"v":400,"d":"Rp400.00"},{"v":400,"d":"Rp400.00"},{"v":400,"d":"Rp400.00"},{"v":400,"d":"Rp400.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":2400,"d":"Rp2,400.00"}}]
[null,"Diskresioner","Lain-lain 1",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Diskresioner","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Tabungan","Cadangan Kas",{"v":416.6666666666667,"d":"Rp416.67"},{"v":416.6666666666667,"d":"Rp416.67"},{"v":416.6666666666667,"d":"Rp416.67"},{"v":416.6666666666667,"d":"Rp416.67"},{"v":416.6666666666667,"d":"Rp416.67"},{"v":416.6666666666667,"d":"Rp416.67"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":2500,"d":"Rp2,500.00"}}]
[null,"Tabungan","Pensiun/Dll",{"v":1000,"d":"Rp1,000.00"},{"v":1000,"d":"Rp1,000.00"},{"v":1000,"d":"Rp1,000.00"},{"v":1000,"d":"Rp1,000.00"},{"v":1000,"d":"Rp1,000.00"},{"v":1000,"d":"Rp1,000.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":6000,"d":"Rp6,000.00"}}]
[null,"Tabungan","Rekening Tabungan",{"v":500,"d":"Rp500.00"},{"v":500,"d":"Rp500.00"},{"v":500,"d":"Rp500.00"},{"v":500,"d":"Rp500.00"},{"v":500,"d":"Rp500.00"},{"v":500,"d":"Rp500.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":3000,"d":"Rp3,000.00"}}]
[null,"Tabungan","Lain-lain 1",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Tabungan","Lain-lain 2",{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"v":0,"d":"Rp0.00"},{"$nulls":6},{"$f":"SUM(Bulanan[[#This Row],[Jan]:[Des]])","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",null,{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Jan])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Jan])","v":{"v":3692.5,"d":"Rp3,692.50"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Feb])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Feb])","v":{"v":3247.5,"d":"Rp3,247.50"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Mar])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Mar])","v":{"v":2522.5,"d":"Rp2,522.50"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Apr])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Apr])","v":{"v":3427.5,"d":"Rp3,427.50"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Mei])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Mei])","v":{"v":2887.5,"d":"Rp2,887.50"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Jun])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Jun])","v":{"v":2602.5,"d":"Rp2,602.50"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Jul])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Jul])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Agu])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Agu])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Sep])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Sep])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Okt])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Okt])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Nov])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Nov])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Des])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Des])","v":{"v":0,"d":"Rp0.00"}},{"$f":"SUMIF(Bulanan[Tipe],\"Pendapatan\",Bulanan[Total])-SUMIF(Bulanan[Tipe],\"<>Pendapatan\",Bulanan[Total])","v":{"v":18380,"d":"Rp18,380.00"}}]

{"sheet":"Arus Kas Tahunan","index":3,"n_rows":29,"n_cols":28,"rows_kept":29,"merged":[[1,3,1,4],[1,6,1,11],[3,1,3,3],[3,5,3,7],[3,9,3,11],[3,13,3,15],[4,2,4,3],[4,6,4,7],[4,10,4,11],[4,14,4,15],[7,2,7,3],[7,6,7,7],[7,10,7,11],[7,14,7,15]]}
[null,"ARUS KAS PRIBADI",{"$nulls":14}," "]
[null,null,"Total Arus Kas Saat Ini:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"Rp42,250.00"}},null,null,"Ini adalah perkiraan tahunan. Gunakan lembar kerja ini jika ingin melihat jumlah tahunan dengan perkiraan jumlah bulanan. Gunakan lembar kerja Pendapatan, Pengeluaran, Diskresi, dan Tabungan untuk memasukkan item."]
[]
[null,"RINGKASAN PENDAPATAN",{"$nulls":3},"RINGKASAN PENGELUARAN",{"$nulls":3},"RINGKASAN DISKRESIONER",{"$nulls":3},"RINGKASAN TABUNGAN"]
[null,"Total Tahunan:",{"$f":"Pendapatan!C11","v":{"v":125000,"d":"Rp125,000.00"}},null,null,"Total Tahunan:",{"$f":"Pengeluaran[[#Totals],[Tahunan  ]]","v":{"v":46500,"d":"Rp46,500.00"}},null,null,"Total Tahunan:",{"$f":"Diskresioner[[#Totals],[Tahunan  ]]","v":{"v":13250,"d":"Rp13,250.00"}},null,null,"Total Tahunan:",{"$f":"Tabungan[[#Totals],[Tahunan  ]]","v":{"v":23000,"d":"Rp23,000.00"}}]
[]
[]
[null,"Total Bulanan:",{"$f":"Pendapatan!D11","v":{"v":10416.666666666668,"d":"Rp10,416.67"}},null,null,"Total Bulanan:",{"$f":"Pengeluaran[[#Totals],[Bulanan ]]","v":{"v":3875,"d":"Rp3,875.00"}},null,null,"Total Bulanan:",{"$f":"Diskresioner[[#Totals],[Bulanan ]]","v":{"v":1104.1666666666665,"d":"Rp1,104.17"}},null,null,"Total Bulanan:",{"$f":"Tabungan!D10","v":{"v":1916.6666666666667,"d":"Rp1,916.67"}}]
[]
[{"$nulls":17},"Label Baris","Pendapatan Tahunan",null,"Label Baris","Jumlah Tahunan",null,"Label Baris","Jumlah Tahunan",null,"Label Baris","Jumlah Tahunan"]
[{"$nulls":17},"Lain-lain 4",{"v":0,"d":"Rp0"},null,"Lain-lain 1",{"v":0,"d":"Rp0"},null,"Lain-lain 1",{"v":0,"d":"Rp0"},null,"Lain-lain 2",{"v":0,"d":"Rp0"}]
[{"$nulls":17},"Lain-lain 3",{"v":0,"d":"Rp0"},null,"Lain-lain 2",{"v":0,"d":"Rp0"},null,"Lain-lain 2",{"v":0,"d":"Rp0"},null,"Lain-lain 1",{"v":0,"d":"Rp0"}]
[{"$nulls":17},"Lain-lain 2",{"v":0,"d":"Rp0"},null,"Sampah",{"v":150,"d":"Rp150"},null,"Klub/Keanggotaan",{"v":300,"d":"Rp300"},null,"Cadangan Kas",{"v":5000,"d":"Rp5,000"}]
[{"$nulls":17},"Komisi/bonus",{"v":5000,"d":"Rp5,000"},null,"Pajak/Biaya Kendaraan",{"v":200,"d":"Rp200"},null,"Perawatan Pribadi",{"v":300,"d":"Rp300"},null,"Tabungan/Investasi",{"v":6000,"d":"Rp6,000"}]
[{"$nulls":17},"Lain-lain 1",{"v":30000,"d":"Rp30,000"},null,"Asuransi",{"v":250,"d":"Rp250"},null,"Amal",{"v":600,"d":"Rp600"},null,"Pensiun/Dll",{"v":12000,"d":"Rp12,000"}]
[{"$nulls":17},"Gaji",{"v":90000,"d":"Rp90,000"},null,"Medis/Gigi/Rx",{"v":600,"d":"Rp600"},null,"Hadiah",{"v":600,"d":"Rp600"},null,"Total Keseluruhan",{"v":23000,"d":"Rp23,000"}]
[{"$nulls":17},"Total Keseluruhan",{"v":125000,"d":"Rp125,000"},null,"Bahan bakar",{"v":600,"d":"Rp600"},null,"Makan di Luar",{"v":1200,"d":"Rp1,200"}]
[{"$nulls":20},"Internet",{"v":600,"d":"Rp600"},null,"Hiburan",{"v":1200,"d":"Rp1,200"}]
[{"$nulls":20},"Air/Selokan",{"v":600,"d":"Rp600"},null,"Belanja",{"v":2000,"d":"Rp2,000"}]
[{"$nulls":20},"Telepon",{"v":600,"d":"Rp600"},null,"Perjalanan",{"v":2250,"d":"Rp2,250"}]
[{"$nulls":20},"Listrik",{"v":1200,"d":"Rp1,200"},null,"Renovasi Rumah",{"v":4800,"d":"Rp4,800"}]
[{"$nulls":20},"Pakaian",{"v":1200,"d":"Rp1,200"},null,"Total Keseluruhan",{"v":13250,"d":"Rp13,250"}]
[{"$nulls":20},"Prem Disabilitas",{"v":1500,"d":"Rp1,500"}]
[{"$nulls":20},"Pajak Pendapatan Daerah",{"v":2500,"d":"Rp2,500"}]
[{"$nulls":20},"Pembayaran Kendaraan",{"v":4000,"d":"Rp4,000"}]
[{"$nulls":20},"Makanan",{"v":5000,"d":"Rp5,000"}]
[{"$nulls":20},"Federal/SS/Medicare",{"v":12500,"d":"Rp12,500"}]
[{"$nulls":20},"Hipotek/Sewa",{"v":15000,"d":"Rp15,000"}]
[{"$nulls":20},"Total Keseluruhan",{"v":46500,"d":"Rp46,500"}]

{"sheet":"Pendapatan","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ARUS KAS PRIBADI"]
[null,null,"Total Arus Kas Saat Ini:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"Rp42,250.00"}},null,"Ini adalah perkiraan tahunan. Gunakan lembar kerja ini jika ingin melihat jumlah tahunan dengan perkiraan nilai bulanan.\nJika ingin menambahkan item harian ke Tabel, perkirakan jumlah/nilai tahunan dan tempatkan nilai dalam kolom Tahunan."]
[]
[null,"Pendapatan","Tahunan  ","Bulanan "]
[null,"Gaji",{"v":90000,"d":"Rp90,000.00"},{"$f":"Pendapatan[[#This Row],[Tahunan  ]]/12","v":{"v":7500,"d":"Rp7,500.00"}}]
[null,"Komisi/bonus",{"v":5000,"d":"Rp5,000.00"},{"$f":"Pendapatan[[#This Row],[Tahunan  ]]/12","v":{"v":416.6666666666667,"d":"Rp416.67"}}]
[null,"Lain-lain 1",{"v":30000,"d":"Rp30,000.00"},{"$f":"Pendapatan[[#This Row],[Tahunan  ]]/12","v":{"v":2500,"d":"Rp2,500.00"}}]
[null,"Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Pendapatan[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Lain-lain 3",{"v":0,"d":"Rp0.00"},{"$f":"Pendapatan[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Lain-lain 4",{"v":0,"d":"Rp0.00"},{"$f":"Pendapatan[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Pendapatan[[Tahunan  ]])","v":{"v":125000,"d":"Rp125,000.00"}},{"$f":"SUBTOTAL(109,Pendapatan[[Bulanan ]])","v":{"v":10416.666666666668,"d":"Rp10,416.67"}}]

{"sheet":"Pengeluaran","index":5,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ARUS KAS PRIBADI"]
[null,null,"Total Arus Kas Saat Ini:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"Rp42,250.00"}},null,"Ini adalah perkiraan tahunan. Gunakan lembar kerja ini jika ingin melihat jumlah tahunan dengan perkiraan nilai bulanan.\nJika ingin menambahkan item harian ke Tabel, perkirakan jumlah/nilai tahunan dan tempatkan nilai dalam kolom Tahunan."]
[]
[null,"Pengeluaran","Tahunan  ","Bulanan "]
[null,"Federal/SS/Medicare",{"v":12500,"d":"Rp12,500.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":1041.6666666666667,"d":"Rp1,041.67"}}]
[null,"Pajak Pendapatan Daerah",{"v":2500,"d":"Rp2,500.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":208.33333333333334,"d":"Rp208.33"}}]
[null,"Pajak/Biaya Kendaraan",{"v":200,"d":"Rp200.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":16.666666666666668,"d":"Rp16.67"}}]
[null,"Pembayaran Kendaraan",{"v":4000,"d":"Rp4,000.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":333.3333333333333,"d":"Rp333.33"}}]
[null,"Hipotek/Sewa",{"v":15000,"d":"Rp15,000.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":1250,"d":"Rp1,250.00"}}]
[null,"Asuransi",{"v":250,"d":"Rp250.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":20.833333333333332,"d":"Rp20.83"}}]
[null,"Listrik",{"v":1200,"d":"Rp1,200.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"Rp100.00"}}]
[null,"Bahan bakar",{"v":600,"d":"Rp600.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Air/Selokan",{"v":600,"d":"Rp600.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Sampah",{"v":150,"d":"Rp150.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":12.5,"d":"Rp12.50"}}]
[null,"Telepon",{"v":600,"d":"Rp600.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Internet",{"v":600,"d":"Rp600.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Prem Disabilitas",{"v":1500,"d":"Rp1,500.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":125,"d":"Rp125.00"}}]
[null,"Makanan",{"v":5000,"d":"Rp5,000.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":416.6666666666667,"d":"Rp416.67"}}]
[null,"Pakaian",{"v":1200,"d":"Rp1,200.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"Rp100.00"}}]
[null,"Medis/Gigi/Rx",{"v":600,"d":"Rp600.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Lain-lain 1",{"v":0,"d":"Rp0.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Pengeluaran[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Pengeluaran[[Tahunan  ]])","v":{"v":46500,"d":"Rp46,500.00"}},{"$f":"SUBTOTAL(109,Pengeluaran[[Bulanan ]])","v":{"v":3875,"d":"Rp3,875.00"}}]

{"sheet":"Diskresioner","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ARUS KAS PRIBADI"]
[null,null,"Total Arus Kas Saat Ini:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"Rp42,250.00"}},null,"Ini adalah perkiraan tahunan. Gunakan lembar kerja ini jika ingin melihat jumlah tahunan dengan perkiraan nilai bulanan.\nJika ingin menambahkan item harian ke Tabel, perkirakan jumlah/nilai tahunan dan tempatkan nilai dalam kolom Tahunan."]
[]
[null,"Diskresioner","Tahunan  ","Bulanan "]
[null,"Makan di Luar",{"v":1200,"d":"Rp1,200.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"Rp100.00"}}]
[null,"Hadiah",{"v":600,"d":"Rp600.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Perjalanan",{"v":2250,"d":"Rp2,250.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":187.5,"d":"Rp187.50"}}]
[null,"Hiburan",{"v":1200,"d":"Rp1,200.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":100,"d":"Rp100.00"}}]
[null,"Perawatan Pribadi",{"v":300,"d":"Rp300.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":25,"d":"Rp25.00"}}]
[null,"Belanja",{"v":2000,"d":"Rp2,000.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":166.66666666666666,"d":"Rp166.67"}}]
[null,"Amal",{"v":600,"d":"Rp600.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":50,"d":"Rp50.00"}}]
[null,"Klub/Keanggotaan",{"v":300,"d":"Rp300.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":25,"d":"Rp25.00"}}]
[null,"Renovasi Rumah",{"v":4800,"d":"Rp4,800.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":400,"d":"Rp400.00"}}]
[null,"Lain-lain 1",{"v":0,"d":"Rp0.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Diskresioner[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Diskresioner[[Tahunan  ]])","v":{"v":13250,"d":"Rp13,250.00"}},{"$f":"SUBTOTAL(109,Diskresioner[[Bulanan ]])","v":{"v":1104.1666666666665,"d":"Rp1,104.17"}}]

{"sheet":"Tabungan","index":7,"n_rows":10,"n_cols":10,"rows_kept":10,"merged":[[1,3,1,4],[1,5,2,8]]}
[null,"ARUS KAS PRIBADI",{"$nulls":7}," "]
[null,null,"Total Arus Kas Saat Ini:",{"$f":"AnnualCashFlowToDate","v":{"v":42250,"d":"Rp42,250.00"}},null,"Ini adalah perkiraan tahunan. Gunakan lembar kerja ini jika ingin melihat jumlah tahunan dengan perkiraan nilai bulanan.\nJika ingin menambahkan item harian ke Tabel, perkirakan jumlah/nilai tahunan dan tempatkan nilai dalam kolom Tahunan."]
[]
[null,"Tabungan","Tahunan  ","Bulanan "]
[null,"Cadangan Kas",{"v":5000,"d":"Rp5,000.00"},{"$f":"Tabungan[[#This Row],[Tahunan  ]]/12","v":{"v":416.6666666666667,"d":"Rp416.67"}}]
[null,"Pensiun/Dll",{"v":12000,"d":"Rp12,000.00"},{"$f":"Tabungan[[#This Row],[Tahunan  ]]/12","v":{"v":1000,"d":"Rp1,000.00"}}]
[null,"Tabungan/Investasi",{"v":6000,"d":"Rp6,000.00"},{"$f":"Tabungan[[#This Row],[Tahunan  ]]/12","v":{"v":500,"d":"Rp500.00"}}]
[null,"Lain-lain 1",{"v":0,"d":"Rp0.00"},{"$f":"Tabungan[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Lain-lain 2",{"v":0,"d":"Rp0.00"},{"$f":"Tabungan[[#This Row],[Tahunan  ]]/12","v":{"v":0,"d":"Rp0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Tabungan[[Tahunan  ]])","v":{"v":23000,"d":"Rp23,000.00"}},{"$f":"SUBTOTAL(109,Tabungan[[Bulanan ]])","v":{"v":1916.6666666666667,"d":"Rp1,916.67"}}]