{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Laporan Keuangan","Input Data Keuangan","Pengaturan Metrik Utama","Perhitungan"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Laporan Keuangan","index":0,"n_rows":40,"n_cols":14,"rows_kept":40,"merged":[[1,10,1,11],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[12,3,12,7],[14,8,14,11],[15,8,15,11],[16,8,16,11],[17,8,17,11],[18,8,18,11],[19,8,19,11],[20,8,20,11],[21,8,21,11],[22,8,22,11],[23,8,23,11],[24,8,24,11],[25,8,25,11],[26,8,26,11],[27,8,27,11],[28,8,28,11],[29,8,29,11],[30,8,30,11],[31,8,31,11],[32,8,32,11],[33,8,33,11],[34,8,34,11],[35,8,35,11],[36,8,36,11],[37,8,37,11],[38,8,38,11],[39,8,39,11]]}
[]
[null,"LAPORAN KEUANGAN TAHUNAN",{"$nulls":8},2016,null,null,"Pilih tahun laporan dalam Sel L2"]
[null,"NAMA PERUSAHAAN ANDA",{"$nulls":11},"Untuk mengedit data, pilih lembar Input Data Keuangan"]
[]
[null,"METRIK UTAMA",null,"Klik untuk mengubah laporan Metrik Utama"]
[]
[null,{"$f":"Perhitungan!B8","v":"PENGHASILAN"},null,{"$f":"Perhitungan!B9","v":"LABA BERSIH"},null,{"$f":"Perhitungan!B10","v":"BUNGA"},null,{"$f":"Perhitungan!B11","v":"DEPRESIASI"},null,{"$f":"Perhitungan!B12","v":"LABA OPERASI"}]
[null,{"$f":"IFERROR(Perhitungan!G8,\"\")","v":{"v":1805838800,"d":"Rp1,805,838,800"}},null,{"$f":"IFERROR(Perhitungan!G9,\"\")","v":{"v":674748500,"d":"Rp674,748,500"}},null,{"$f":"IFERROR(Perhitungan!G10,\"\")","v":{"v":37894700,"d":"Rp37,894,700"}},null,{"$f":"IFERROR(Perhitungan!G11,\"\")","v":{"v":55468800,"d":"Rp55,468,800"}},null,{"$f":"IFERROR(Perhitungan!G12,\"\")","v":{"v":734259900,"d":"Rp734,259,900"}}]
[null,{"$f":"Perhitungan!H8","v":{"v":3.0953753897409175E-3,"d":"0%"}},null,{"$f":"Perhitungan!H9","v":{"v":0.018148662861143583,"d":"2%"}},null,{"$f":"Perhitungan!H10","v":{"v":0.13514962705568712,"d":"14%"}},null,{"$f":"Perhitungan!H11","v":{"v":0.09440022728976682,"d":"9%"}},null,{"$f":"Perhitungan!H12","v":{"v":-0.05033560822904626,"d":"-5%"}}]
[]
[]
[]
[null,"SEMUA METRIK",null,"Jangan ubah informasi di bawah ini. Klik untuk memasukkan Data Keuangan"]
[]
[null,"METRIK",null,{"$f":"\"TAHUN LAPORAN (\"&TahunDipilih&\")\"","v":"TAHUN LAPORAN (2016)"},null,{"$f":"\"TAHUN SEBELUMNYA (\"&TahunDipilih-1&\")\"","v":"TAHUN SEBELUMNYA (2015)"},null,"% PERUBAHAN",{"$f":"CONCATENATE(\"TREN \", Tahun,\" TAHUN\")","v":"TREN 5 TAHUN"}]
[null,{"$f":"Perhitungan!B15","v":"PENGHASILAN"},null,{"$f":"IF($B16=\"\",\"\",Perhitungan!G15)","v":{"v":1805838800,"d":"Rp1,805,838,800.00"}},null,{"$f":"IF($B16=\"\",\"\",Perhitungan!F15)","v":{"v":1800266300,"d":"Rp1,800,266,300.00"}},null,{"$f":"IFERROR(D16/F16-1,\"\")","v":{"v":3.0953753897409175E-3,"d":"0%"}}]
[null,{"$f":"Perhitungan!B16","v":"PENGELUARAN OPERASI"},null,{"$f":"IF($B17=\"\",\"\",Perhitungan!G16)","v":{"v":944194500,"d":"Rp944,194,500.00"}},null,{"$f":"IF($B17=\"\",\"\",Perhitungan!F16)","v":{"v":808833300,"d":"Rp808,833,300.00"}},null,{"v":0.16735364382252804,"d":"17%"}]
[null,{"$f":"Perhitungan!B17","v":"LABA OPERASI"},null,{"$f":"IF($B18=\"\",\"\",Perhitungan!G17)","v":{"v":734259900,"d":"Rp734,259,900.00"}},null,{"$f":"IF($B18=\"\",\"\",Perhitungan!F17)","v":{"v":773178300,"d":"Rp773,178,300.00"}},null,{"v":-0.05033560822904626,"d":"-5%"}]
[null,{"$f":"Perhitungan!B18","v":"DEPRESIASI"},null,{"$f":"IF($B19=\"\",\"\",Perhitungan!G18)","v":{"v":55468800,"d":"Rp55,468,800.00"}},null,{"$f":"IF($B19=\"\",\"\",Perhitungan!F18)","v":{"v":50684200,"d":"Rp50,684,200.00"}},null,{"v":0.09440022728976682,"d":"9%"}]
[null,{"$f":"Perhitungan!B19","v":"BUNGA"},null,{"$f":"IF($B20=\"\",\"\",Perhitungan!G19)","v":{"v":37894700,"d":"Rp37,894,700.00"}},null,{"$f":"IF($B20=\"\",\"\",Perhitungan!F19)","v":{"v":33383000,"d":"Rp33,383,000.00"}},null,{"v":0.13514962705568712,"d":"14%"}]
[null,{"$f":"Perhitungan!B20","v":"LABA BERSIH"},null,{"$f":"IF($B21=\"\",\"\",Perhitungan!G20)","v":{"v":674748500,"d":"Rp674,748,500.00"}},null,{"$f":"IF($B21=\"\",\"\",Perhitungan!F20)","v":{"v":662721000,"d":"Rp662,721,000.00"}},null,{"v":0.018148662861143583,"d":"2%"}]
[null,{"$f":"Perhitungan!B21","v":"PAJAK"},null,{"$f":"IF($B22=\"\",\"\",Perhitungan!G21)","v":{"v":314082500,"d":"Rp314,082,500.00"}},null,{"$f":"IF($B22=\"\",\"\",Perhitungan!F21)","v":{"v":294245300,"d":"Rp294,245,300.00"}},null,{"v":0.06741721957835867,"d":"7%"}]
[null,{"$f":"Perhitungan!B22","v":"LABA SETELAH PAJAK"},null,{"$f":"IF($B23=\"\",\"\",Perhitungan!G22)","v":{"v":502476800,"d":"Rp502,476,800.00"}},null,{"$f":"IF($B23=\"\",\"\",Perhitungan!F22)","v":{"v":424382000,"d":"Rp424,382,000.00"}},null,{"v":0.18402005740111504,"d":"18%"}]
[null,{"$f":"Perhitungan!B23","v":"METRIK 1"},null,{"$f":"IF($B24=\"\",\"\",Perhitungan!G23)","v":{"v":199600,"d":"Rp199,600.00"}},null,{"$f":"IF($B24=\"\",\"\",Perhitungan!F23)","v":{"v":167800,"d":"Rp167,800.00"}},null,{"v":0.18951132300357565,"d":"19%"}]
[null,{"$f":"Perhitungan!B24","v":"METRIK 2"},null,{"$f":"IF($B25=\"\",\"\",Perhitungan!G24)","v":{"v":260100.00000000003,"d":"Rp260,100.00"}},null,{"$f":"IF($B25=\"\",\"\",Perhitungan!F24)","v":{"v":218400,"d":"Rp218,400.00"}},null,{"v":0.19093406593406614,"d":"19%"}]
[null,{"$f":"Perhitungan!B25","v":"METRIK 3"},null,{"$f":"IF($B26=\"\",\"\",Perhitungan!G25)","v":{"v":310800,"d":"Rp310,800.00"}},null,{"$f":"IF($B26=\"\",\"\",Perhitungan!F25)","v":{"v":263900,"d":"Rp263,900.00"}},null,{"v":0.17771883289124668,"d":"18%"}]
[null,{"$f":"Perhitungan!B26","v":"METRIK 4"},null,{"$f":"IF($B27=\"\",\"\",Perhitungan!G26)","v":{"v":149200,"d":"Rp149,200.00"}},null,{"$f":"IF($B27=\"\",\"\",Perhitungan!F26)","v":{"v":145900,"d":"Rp145,900.00"}},null,{"v":0.022618231665524346,"d":"2%"}]
[null,{"$f":"Perhitungan!B27","v":"METRIK 5"},null,{"$f":"IF($B28=\"\",\"\",Perhitungan!G27)","v":{"v":10300,"d":"Rp10,300.00"}},null,{"$f":"IF($B28=\"\",\"\",Perhitungan!F27)","v":{"v":10000,"d":"Rp10,000.00"}},null,{"v":0.030000000000000027,"d":"3%"}]
[null,{"$f":"Perhitungan!B28","v":"METRIK 6"},null,{"$f":"IF($B29=\"\",\"\",Perhitungan!G28)","v":{"v":3400.0000000000005,"d":"Rp3,400.00"}},null,{"$f":"IF($B29=\"\",\"\",Perhitungan!F28)","v":{"v":3000,"d":"Rp3,000.00"}},null,{"v":0.13333333333333353,"d":"13%"}]
[null,{"$f":"Perhitungan!B29","v":""},null,{"$f":"IF($B30=\"\",\"\",Perhitungan!G29)","v":""},null,{"$f":"IF($B30=\"\",\"\",Perhitungan!F29)","v":""},null,""]
[null,{"$f":"Perhitungan!B30","v":""},null,{"$f":"IF($B31=\"\",\"\",Perhitungan!G30)","v":""},null,{"$f":"IF($B31=\"\",\"\",Perhitungan!F30)","v":""},null,""]
[null,{"$f":"Perhitungan!B31","v":""},null,{"$f":"IF($B32=\"\",\"\",Perhitungan!G31)","v":""},null,{"$f":"IF($B32=\"\",\"\",Perhitungan!F31)","v":""},null,""]
[null,{"$f":"Perhitungan!B32","v":""},null,{"$f":"IF($B33=\"\",\"\",Perhitungan!G32)","v":""},null,{"$f":"IF($B33=\"\",\"\",Perhitungan!F32)","v":""},null,""]
[null,{"$f":"Perhitungan!B33","v":""},null,{"$f":"IF($B34=\"\",\"\",Perhitungan!G33)","v":""},null,{"$f":"IF($B34=\"\",\"\",Perhitungan!F33)","v":""},null,""]
[null,{"$f":"Perhitungan!B34","v":""},null,{"$f":"IF($B35=\"\",\"\",Perhitungan!G34)","v":""},null,{"$f":"IF($B35=\"\",\"\",Perhitungan!F34)","v":""},null,""]
[null,{"$f":"Perhitungan!B35","v":""},null,{"$f":"IF($B36=\"\",\"\",Perhitungan!G35)","v":""},null,{"$f":"IF($B36=\"\",\"\",Perhitungan!F35)","v":""},null,""]
[null,{"$f":"Perhitungan!B36","v":""},null,{"$f":"IF($B37=\"\",\"\",Perhitungan!G36)","v":""},null,{"$f":"IF($B37=\"\",\"\",Perhitungan!F36)","v":""},null,""]
[null,{"$f":"Perhitungan!B37","v":""},null,{"$f":"IF($B38=\"\",\"\",Perhitungan!G37)","v":""},null,{"$f":"IF($B38=\"\",\"\",Perhitungan!F37)","v":""},null,""]
[null,{"$f":"Perhitungan!B38","v":""},null,{"$f":"IF($B39=\"\",\"\",Perhitungan!G38)","v":""},null,{"$f":"IF($B39=\"\",\"\",Perhitungan!F38)","v":""},null,""]
[null,{"$f":"Perhitungan!B39","v":""},null,{"$f":"IF($B40=\"\",\"\",Perhitungan!G39)","v":""},null,{"$f":"IF($B40=\"\",\"\",Perhitungan!F39)","v":""},null,""]

{"sheet":"Input Data Keuangan","index":1,"n_rows":19,"n_cols":9,"rows_kept":19}
[]
[null,"INPUT DATA KEUANGAN ANDA"]
[null," ANDA DAPAT MENENTUKAN HINGGA 25 METRIK UTAMA UNTUK 7 TAHUN"]
[null," Klik untuk menampilkan Laporan Keuangan"]
[null,"NAMA METRIK",2010,2011,2012,2013,2014,2015,2016]
[null,"PENGHASILAN",{"v":1250000000,"d":"Rp1,250,000,000.00"},{"v":1341374500,"d":"Rp1,341,374,500.00"},{"v":1427283800,"d":"Rp1,427,283,800.00"},{"v":1506874600,"d":"Rp1,506,874,600.00"},{"v":1650445600,"d":"Rp1,650,445,600.00"},{"v":1800266300,"d":"Rp1,800,266,300.00"},{"v":1805838800,"d":"Rp1,805,838,800.00"}]
[null,"PENGELUARAN OPERASI",{"v":650000000,"d":"Rp650,000,000.00"},{"v":709623100,"d":"Rp709,623,100.00"},{"v":759248600,"d":"Rp759,248,600.00"},{"v":789012700,"d":"Rp789,012,700.00"},{"v":816743700,"d":"Rp816,743,700.00"},{"v":808833300,"d":"Rp808,833,300.00"},{"v":944194500,"d":"Rp944,194,500.00"}]
[null,"LABA OPERASI",{"v":600000000,"d":"Rp600,000,000.00"},{"v":642073000,"d":"Rp642,073,000.00"},{"v":688576900,"d":"Rp688,576,900.00"},{"v":756432500,"d":"Rp756,432,500.00"},{"v":767552600,"d":"Rp767,552,600.00"},{"v":773178300,"d":"Rp773,178,300.00"},{"v":734259900,"d":"Rp734,259,900.00"}]
[null,"DEPRESIASI",{"v":45000000,"d":"Rp45,000,000.00"},{"v":45177700.00000001,"d":"Rp45,177,700.00"},{"v":46569200,"d":"Rp46,569,200.00"},{"v":49742100,"d":"Rp49,742,100.00"},{"v":50241100,"d":"Rp50,241,100.00"},{"v":50684200,"d":"Rp50,684,200.00"},{"v":55468800,"d":"Rp55,468,800.00"}]
[null,"BUNGA",{"v":25000000,"d":"Rp25,000,000.00"},{"v":27458200,"d":"Rp27,458,200.00"},{"v":28931100,"d":"Rp28,931,100.00"},{"v":31361200,"d":"Rp31,361,200.00"},{"v":31485300.000000004,"d":"Rp31,485,300.00"},{"v":33383000,"d":"Rp33,383,000.00"},{"v":37894700,"d":"Rp37,894,700.00"}]
[null,"LABA BERSIH",{"v":540000000,"d":"Rp540,000,000.00"},{"v":547610750,"d":"Rp547,610,750.00"},{"v":558608100,"d":"Rp558,608,100.00"},{"v":597479500,"d":"Rp597,479,500.00"},{"v":614835900,"d":"Rp614,835,900.00"},{"v":662721000,"d":"Rp662,721,000.00"},{"v":674748500,"d":"Rp674,748,500.00"}]
[null,"PAJAK",{"v":220000000,"d":"Rp220,000,000.00"},{"v":239205400,"d":"Rp239,205,400.00"},{"v":255767400.00000003,"d":"Rp255,767,400.00"},{"v":274988600,"d":"Rp274,988,600.00"},{"v":283356700,"d":"Rp283,356,700.00"},{"v":294245300,"d":"Rp294,245,300.00"},{"v":314082500,"d":"Rp314,082,500.00"}]
[null,"LABA SETELAH PAJAK",{"v":320000000,"d":"Rp320,000,000.00"},{"v":349434900,"d":"Rp349,434,900.00"},{"v":384185300,"d":"Rp384,185,300.00"},{"v":398950500,"d":"Rp398,950,500.00"},{"v":406077300.00000006,"d":"Rp406,077,300.00"},{"v":424382000,"d":"Rp424,382,000.00"},{"v":502476800,"d":"Rp502,476,800.00"}]
[null,"METRIK 1",{"v":128000,"d":"Rp128,000.00"},{"v":128100,"d":"Rp128,100.00"},{"v":137800,"d":"Rp137,800.00"},{"v":142900,"d":"Rp142,900.00"},{"v":155700,"d":"Rp155,700.00"},{"v":167800,"d":"Rp167,800.00"},{"v":199600,"d":"Rp199,600.00"}]
[null,"METRIK 2",{"v":182000,"d":"Rp182,000.00"},{"v":185900,"d":"Rp185,900.00"},{"v":192200,"d":"Rp192,200.00"},{"v":201700.00000000003,"d":"Rp201,700.00"},{"v":204800,"d":"Rp204,800.00"},{"v":218400,"d":"Rp218,400.00"},{"v":260100.00000000003,"d":"Rp260,100.00"}]
[null,"METRIK 3",{"v":191000,"d":"Rp191,000.00"},{"v":205500,"d":"Rp205,500.00"},{"v":218700,"d":"Rp218,700.00"},{"v":231900,"d":"Rp231,900.00"},{"v":246700.00000000003,"d":"Rp246,700.00"},{"v":263900,"d":"Rp263,900.00"},{"v":310800,"d":"Rp310,800.00"}]
[null,"METRIK 4",{"v":121000,"d":"Rp121,000.00"},{"v":122100.00000000001,"d":"Rp122,100.00"},{"v":125900,"d":"Rp125,900.00"},{"v":137000,"d":"Rp137,000.00"},{"v":137600,"d":"Rp137,600.00"},{"v":145900,"d":"Rp145,900.00"},{"v":149200,"d":"Rp149,200.00"}]
[null,"METRIK 5",{"v":7500,"d":"Rp7,500.00"},{"v":7900,"d":"Rp7,900.00"},{"v":8500,"d":"Rp8,500.00"},{"v":8900,"d":"Rp8,900.00"},{"v":9100,"d":"Rp9,100.00"},{"v":10000,"d":"Rp10,000.00"},{"v":10300,"d":"Rp10,300.00"}]
[null,"METRIK 6",{"v":2300,"d":"Rp2,300.00"},{"v":2500,"d":"Rp2,500.00"},{"v":2700,"d":"Rp2,700.00"},{"v":2800.0000000000005,"d":"Rp2,800.00"},{"v":2900,"d":"Rp2,900.00"},{"v":3000,"d":"Rp3,000.00"},{"v":3400.0000000000005,"d":"Rp3,400.00"}]

{"sheet":"Pengaturan Metrik Utama","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"merged":[[3,1,3,3]]}
[]
[null,"TENTUKAN METRIK UTAMA DI SINI"]
[null," PILIH HINGGA 5 METRIK UTAMA UNTUK DIPERLIHATKAN DI ATAS LAPORAN"]
[null,"  Klik untuk menampilkan Laporan Keuangan"]
[null,1,"PENGHASILAN",null,{"$f":"IF(ISBLANK(C5),\"← Silakan pilih nilai dari menu menurun\",IF(COUNTIF($C$5:C5,C5)>1,\"Anda telah memilih \"&C5&\" lebih dari sekali.\",\"\"))","v":""}]
[null,2,"LABA BERSIH",null,{"$f":"IF(ISBLANK(C6),\"← Silakan pilih nilai dari menu menurun\",IF(COUNTIF($C$5:C6,C6)>1,\"Anda telah memilih \"&C6&\" lebih dari sekali.\",\"\"))","v":""}]
[null,3,"BUNGA",null,{"$f":"IF(ISBLANK(C7),\"← Silakan pilih nilai dari menu menurun\",IF(COUNTIF($C$5:C7,C7)>1,\"Anda telah memilih \"&C7&\" lebih dari sekali.\",\"\"))","v":""}]
[null,4,"DEPRESIASI",null,{"$f":"IF(ISBLANK(C8),\"← Silakan pilih nilai dari menu menurun\",IF(COUNTIF($C$5:C8,C8)>1,\"Anda telah memilih \"&C8&\" lebih dari sekali.\",\"\"))","v":""}]
[null,5,"LABA OPERASI",null,{"$f":"IF(ISBLANK(C9),\"← Silakan pilih nilai dari menu menurun\",IF(COUNTIF($C$5:C9,C9)>1,\"Anda telah memilih \"&C9&\" lebih dari sekali.\",\"\"))","v":""}]

{"sheet":"Perhitungan","index":3,"n_rows":39,"n_cols":9,"rows_kept":39,"hidden":true}
["Lembar kerja digunakan untuk perhitungan Laporan Keuangan dan harus tetap tersembunyi."]
[{"$nulls":3},"Posisi"]
[null,"Tahun ini",{"$f":"TahunDipilih","v":2016},{"$f":"MATCH(C3,lstTahun,0)+1","v":8}]
[null,"Tahun Sebelumnya",{"$f":"C3-1","v":2015},{"$f":"MATCH(C4,lstTahun,0)+1","v":7}]
[]
[null,"Posisi",{"$f":"MATCH(C7,lstTahun,0)+1","v":4},{"$f":"MATCH(D7,lstTahun,0)+1","v":5},{"$f":"MATCH(E7,lstTahun,0)+1","v":6},{"$f":"MATCH(F7,lstTahun,0)+1","v":7},{"$f":"MATCH(G7,lstTahun,0)+1","v":8},null,{"$f":"COUNT(C6:G6)","v":5}]
[null,"Metrik Utama",{"$f":"D7-1","v":2012},{"$f":"E7-1","v":2013},{"$f":"F7-1","v":2014},{"$f":"G7-1","v":2015},{"$f":"C3","v":2016}]
[{"$f":"MATCH(B8,'Input Data Keuangan'!$B$6:$B$30,0)","v":1},{"$f":"IF('Pengaturan Metrik Utama'!C5=\"\",\"\",'Pengaturan Metrik Utama'!C5)","v":"PENGHASILAN"},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A8,C$6),NA())","v":1427283800},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A8,D$6),NA())","v":1506874600},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A8,E$6),NA())","v":1650445600},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A8,F$6),NA())","v":1800266300},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A8,G$6),NA())","v":1805838800},{"$f":"IFERROR(G8/F8-1,\"\")","v":{"v":3.0953753897409175E-3,"d":"0%"}}]
[{"$f":"MATCH(B9,'Input Data Keuangan'!$B$6:$B$30,0)","v":6},{"$f":"IF('Pengaturan Metrik Utama'!C6=\"\",\"\",'Pengaturan Metrik Utama'!C6)","v":"LABA BERSIH"},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A9,C$6),NA())","v":558608100},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A9,D$6),NA())","v":597479500},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A9,E$6),NA())","v":614835900},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A9,F$6),NA())","v":662721000},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A9,G$6),NA())","v":674748500},{"$f":"IFERROR(G9/F9-1,\"\")","v":{"v":0.018148662861143583,"d":"2%"}}]
[{"$f":"MATCH(B10,'Input Data Keuangan'!$B$6:$B$30,0)","v":5},{"$f":"IF('Pengaturan Metrik Utama'!C7=\"\",\"\",'Pengaturan Metrik Utama'!C7)","v":"BUNGA"},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A10,C$6),NA())","v":28931100},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A10,D$6),NA())","v":31361200},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A10,E$6),NA())","v":31485300.000000004},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A10,F$6),NA())","v":33383000},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A10,G$6),NA())","v":37894700},{"v":0.13514962705568712,"d":"14%"}]
[{"$f":"MATCH(B11,'Input Data Keuangan'!$B$6:$B$30,0)","v":4},{"$f":"IF('Pengaturan Metrik Utama'!C8=\"\",\"\",'Pengaturan Metrik Utama'!C8)","v":"DEPRESIASI"},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A11,C$6),NA())","v":46569200},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A11,D$6),NA())","v":49742100},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A11,E$6),NA())","v":50241100},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A11,F$6),NA())","v":50684200},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A11,G$6),NA())","v":55468800},{"v":0.09440022728976682,"d":"9%"}]
[{"$f":"MATCH(B12,'Input Data Keuangan'!$B$6:$B$30,0)","v":3},{"$f":"IF('Pengaturan Metrik Utama'!C9=\"\",\"\",'Pengaturan Metrik Utama'!C9)","v":"LABA OPERASI"},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A12,C$6),NA())","v":688576900},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A12,D$6),NA())","v":756432500},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A12,E$6),NA())","v":767552600},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A12,F$6),NA())","v":773178300},{"$f":"IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A12,G$6),NA())","v":734259900},{"v":-0.05033560822904626,"d":"-5%"}]
[]
[null,"Semua Metrik (berfungsi hingga di 25 metrik)"]
[{"$f":"ROWS($B$15:B15)","v":1},{"$f":"IF('Input Data Keuangan'!B6=0,\"\",'Input Data Keuangan'!B6)","v":"PENGHASILAN"},{"$f":"IF($B15=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A15,C$6),NA()))","v":1427283800},{"$f":"IF($B15=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A15,D$6),NA()))","v":1506874600},{"$f":"IF($B15=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A15,E$6),NA()))","v":1650445600},{"$f":"IF($B15=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A15,F$6),NA()))","v":1800266300},{"$f":"IF($B15=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A15,G$6),NA()))","v":1805838800}]
[{"$f":"ROWS($B$15:B16)","v":2},{"$f":"IF('Input Data Keuangan'!B7=0,\"\",'Input Data Keuangan'!B7)","v":"PENGELUARAN OPERASI"},{"$f":"IF($B16=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A16,C$6),NA()))","v":759248600},{"$f":"IF($B16=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A16,D$6),NA()))","v":789012700},{"$f":"IF($B16=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A16,E$6),NA()))","v":816743700},{"$f":"IF($B16=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A16,F$6),NA()))","v":808833300},{"$f":"IF($B16=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A16,G$6),NA()))","v":944194500}]
[{"$f":"ROWS($B$15:B17)","v":3},{"$f":"IF('Input Data Keuangan'!B8=0,\"\",'Input Data Keuangan'!B8)","v":"LABA OPERASI"},{"$f":"IF($B17=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A17,C$6),NA()))","v":688576900},{"$f":"IF($B17=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A17,D$6),NA()))","v":756432500},{"$f":"IF($B17=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A17,E$6),NA()))","v":767552600},{"$f":"IF($B17=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A17,F$6),NA()))","v":773178300},{"$f":"IF($B17=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A17,G$6),NA()))","v":734259900}]
[{"$f":"ROWS($B$15:B18)","v":4},{"$f":"IF('Input Data Keuangan'!B9=0,\"\",'Input Data Keuangan'!B9)","v":"DEPRESIASI"},{"$f":"IF($B18=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A18,C$6),NA()))","v":46569200},{"$f":"IF($B18=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A18,D$6),NA()))","v":49742100},{"$f":"IF($B18=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A18,E$6),NA()))","v":50241100},{"$f":"IF($B18=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A18,F$6),NA()))","v":50684200},{"$f":"IF($B18=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A18,G$6),NA()))","v":55468800}]
[{"$f":"ROWS($B$15:B19)","v":5},{"$f":"IF('Input Data Keuangan'!B10=0,\"\",'Input Data Keuangan'!B10)","v":"BUNGA"},{"$f":"IF($B19=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A19,C$6),NA()))","v":28931100},{"$f":"IF($B19=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A19,D$6),NA()))","v":31361200},{"$f":"IF($B19=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A19,E$6),NA()))","v":31485300.000000004},{"$f":"IF($B19=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A19,F$6),NA()))","v":33383000},{"$f":"IF($B19=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A19,G$6),NA()))","v":37894700}]
[{"$f":"ROWS($B$15:B20)","v":6},{"$f":"IF('Input Data Keuangan'!B11=0,\"\",'Input Data Keuangan'!B11)","v":"LABA BERSIH"},{"$f":"IF($B20=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A20,C$6),NA()))","v":558608100},{"$f":"IF($B20=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A20,D$6),NA()))","v":597479500},{"$f":"IF($B20=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A20,E$6),NA()))","v":614835900},{"$f":"IF($B20=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A20,F$6),NA()))","v":662721000},{"$f":"IF($B20=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A20,G$6),NA()))","v":674748500}]
[{"$f":"ROWS($B$15:B21)","v":7},{"$f":"IF('Input Data Keuangan'!B12=0,\"\",'Input Data Keuangan'!B12)","v":"PAJAK"},{"$f":"IF($B21=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A21,C$6),NA()))","v":255767400.00000003},{"$f":"IF($B21=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A21,D$6),NA()))","v":274988600},{"$f":"IF($B21=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A21,E$6),NA()))","v":283356700},{"$f":"IF($B21=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A21,F$6),NA()))","v":294245300},{"$f":"IF($B21=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A21,G$6),NA()))","v":314082500}]
[{"$f":"ROWS($B$15:B22)","v":8},{"$f":"IF('Input Data Keuangan'!B13=0,\"\",'Input Data Keuangan'!B13)","v":"LABA SETELAH PAJAK"},{"$f":"IF($B22=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A22,C$6),NA()))","v":384185300},{"$f":"IF($B22=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A22,D$6),NA()))","v":398950500},{"$f":"IF($B22=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A22,E$6),NA()))","v":406077300.00000006},{"$f":"IF($B22=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A22,F$6),NA()))","v":424382000},{"$f":"IF($B22=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A22,G$6),NA()))","v":502476800}]
[{"$f":"ROWS($B$15:B23)","v":9},{"$f":"IF('Input Data Keuangan'!B14=0,\"\",'Input Data Keuangan'!B14)","v":"METRIK 1"},{"$f":"IF($B23=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A23,C$6),NA()))","v":137800},{"$f":"IF($B23=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A23,D$6),NA()))","v":142900},{"$f":"IF($B23=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A23,E$6),NA()))","v":155700},{"$f":"IF($B23=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A23,F$6),NA()))","v":167800},{"$f":"IF($B23=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A23,G$6),NA()))","v":199600}]
[{"$f":"ROWS($B$15:B24)","v":10},{"$f":"IF('Input Data Keuangan'!B15=0,\"\",'Input Data Keuangan'!B15)","v":"METRIK 2"},{"$f":"IF($B24=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A24,C$6),NA()))","v":192200},{"$f":"IF($B24=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A24,D$6),NA()))","v":201700.00000000003},{"$f":"IF($B24=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A24,E$6),NA()))","v":204800},{"$f":"IF($B24=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A24,F$6),NA()))","v":218400},{"$f":"IF($B24=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A24,G$6),NA()))","v":260100.00000000003}]
[{"$f":"ROWS($B$15:B25)","v":11},{"$f":"IF('Input Data Keuangan'!B16=0,\"\",'Input Data Keuangan'!B16)","v":"METRIK 3"},{"$f":"IF($B25=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A25,C$6),NA()))","v":218700},{"$f":"IF($B25=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A25,D$6),NA()))","v":231900},{"$f":"IF($B25=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A25,E$6),NA()))","v":246700.00000000003},{"$f":"IF($B25=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A25,F$6),NA()))","v":263900},{"$f":"IF($B25=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A25,G$6),NA()))","v":310800}]
[{"$f":"ROWS($B$15:B26)","v":12},{"$f":"IF('Input Data Keuangan'!B17=0,\"\",'Input Data Keuangan'!B17)","v":"METRIK 4"},{"$f":"IF($B26=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A26,C$6),NA()))","v":125900},{"$f":"IF($B26=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A26,D$6),NA()))","v":137000},{"$f":"IF($B26=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A26,E$6),NA()))","v":137600},{"$f":"IF($B26=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A26,F$6),NA()))","v":145900},{"$f":"IF($B26=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A26,G$6),NA()))","v":149200}]
[{"$f":"ROWS($B$15:B27)","v":13},{"$f":"IF('Input Data Keuangan'!B18=0,\"\",'Input Data Keuangan'!B18)","v":"METRIK 5"},{"$f":"IF($B27=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A27,C$6),NA()))","v":8500},{"$f":"IF($B27=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A27,D$6),NA()))","v":8900},{"$f":"IF($B27=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A27,E$6),NA()))","v":9100},{"$f":"IF($B27=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A27,F$6),NA()))","v":10000},{"$f":"IF($B27=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A27,G$6),NA()))","v":10300}]
[{"$f":"ROWS($B$15:B28)","v":14},{"$f":"IF('Input Data Keuangan'!B19=0,\"\",'Input Data Keuangan'!B19)","v":"METRIK 6"},{"$f":"IF($B28=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A28,C$6),NA()))","v":2700},{"$f":"IF($B28=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A28,D$6),NA()))","v":2800.0000000000005},{"$f":"IF($B28=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A28,E$6),NA()))","v":2900},{"$f":"IF($B28=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A28,F$6),NA()))","v":3000},{"$f":"IF($B28=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A28,G$6),NA()))","v":3400.0000000000005}]
[{"$f":"ROWS($B$15:B29)","v":15},{"$f":"IF('Input Data Keuangan'!B20=0,\"\",'Input Data Keuangan'!B20)","v":""},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A29,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A29,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A29,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A29,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A29,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B30)","v":16},{"$f":"IF('Input Data Keuangan'!B21=0,\"\",'Input Data Keuangan'!B21)","v":""},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A30,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A30,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A30,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A30,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A30,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B31)","v":17},{"$f":"IF('Input Data Keuangan'!B22=0,\"\",'Input Data Keuangan'!B22)","v":""},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A31,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A31,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A31,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A31,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A31,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B32)","v":18},{"$f":"IF('Input Data Keuangan'!B23=0,\"\",'Input Data Keuangan'!B23)","v":""},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A32,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A32,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A32,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A32,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A32,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B33)","v":19},{"$f":"IF('Input Data Keuangan'!B24=0,\"\",'Input Data Keuangan'!B24)","v":""},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A33,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A33,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A33,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A33,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A33,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B34)","v":20},{"$f":"IF('Input Data Keuangan'!B25=0,\"\",'Input Data Keuangan'!B25)","v":""},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A34,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A34,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A34,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A34,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A34,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B35)","v":21},{"$f":"IF('Input Data Keuangan'!B26=0,\"\",'Input Data Keuangan'!B26)","v":""},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A35,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A35,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A35,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A35,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A35,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B36)","v":22},{"$f":"IF('Input Data Keuangan'!B27=0,\"\",'Input Data Keuangan'!B27)","v":""},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A36,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A36,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A36,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A36,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A36,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B37)","v":23},{"$f":"IF('Input Data Keuangan'!B28=0,\"\",'Input Data Keuangan'!B28)","v":""},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A37,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A37,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A37,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A37,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A37,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B38)","v":24},{"$f":"IF('Input Data Keuangan'!B29=0,\"\",'Input Data Keuangan'!B29)","v":""},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A38,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A38,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A38,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A38,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A38,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B39)","v":25},{"$f":"IF('Input Data Keuangan'!B30=0,\"\",'Input Data Keuangan'!B30)","v":""},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A39,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A39,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A39,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A39,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX('Input Data Keuangan'!$B$6:$I$30,$A39,G$6),NA()))","v":{"$error":"#N/A"}}]