{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Input","Sheet2","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,22,1]]}
["No.Anggota",":",2027,{"$f":"C1&TEXT(MATCH(C3,P2:P13,0),\"00\")","v":"202702"}]
["Nama",":",{"$f":"VLOOKUP(C1,M2:N11,2,0)","v":"didin"},null,null,null,null,null,null,null,null,1,2025,"dudun","Simpanan1","Jan"]
["Bulan",":","Feb",null,null,null,null,null,null,null,null,2,2026,"wiwin","Simpanan2","Feb"]
["Tabel Name",":",{"$f":"VLOOKUP(C1,M2:O11,3,0)","v":"Simpanan3"},null,null,null,null,null,null,null,null,3,2027,"didin","Simpanan3","Mar"]
["Potongan Simpanan :",null,{"$f":"C1&TEXT(MATCH(C3,P2:P13,0),\"00\")","v":"202702"},null,null,null,null,null,null,null,null,4,2028,"dadan","Simpanan4","Apr"]
["Pokok","Rp. :",0,null,null,null,null,null,null,null,null,5,2029,"wawa","Simpanan5","May"]
["Wajib","Rp. :",2000,null,null,null,null,null,null,null,null,6,2030,"wowo","Simpanan6","Jun"]
["Sukarela","Rp. :",3000,null,null,null,null,null,null,null,null,7,2031,"wiwi","Simpanan7","Jul"]
["Wisata","Rp. :",4000,null,null,null,null,null,null,null,null,8,2032,"dada","Simpanan8","Aug"]
["Pendidikan","Rp. :",999999,null,null,null,null,null,null,null,null,9,2033,"dea","Simpanan9","Sep"]
["SIHARA","Rp. :",6000,null,null,null,null,null,null,null,null,10,2034,"deni","Simpanan10","Oct"]
["Potongan Pinjaman :",null,null,null,null,null,null,null,null,null,null,11,null,null,null,"Nov"]
["J. Panjang","Rp. :",100,null,null,null,null,null,null,null,null,12,null,null,null,"Dec"]
["Ringan","Rp. :",200]
["Barang","Rp. :",300]
["Potongan Jasa :"]
["J. Panjang","Rp. :",500]
["Ringan","Rp. :",600]
["Barang","Rp. :",700]
["Dana Sosial Rp. :","Rp. :",0]
["Beras","Rp. :",0]
["lain-lain","Rp. :",0]
["Total Potongan Rp. :",null,1017399]

{"sheet":"Sheet2","index":1,"n_rows":38,"n_cols":17,"rows_kept":38,"cut":false,"hidden":false,"merged":[[8,0,8,1],[4,0,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,6,4,8],[4,9,4,11],[4,12,4,14],[6,0,6,1],[7,0,7,1],[4,5,5,5],[21,0,21,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[32,0,32,1],[22,0,23,1],[22,2,23,2],[22,15,23,15],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1]]}
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kolom bantu"]
["Simpanan"]
["Nama          ",":",{"$f":"VLOOKUP(A1,Input!$L$2:$N$11,3,0)","v":"didin"}]
["No. Angg   ",":",{"$f":"VLOOKUP(A1,Input!$L$2:$N$11,2,0)","v":2027},null,null,null," ",null,null,"Jml.Dividen :",{"$f":"IF(P19=0,0,Q20)","v":0}]
["Bulan",null,"SP","SW","SS","Tarik Simp","SIHARA",null,null,"Pendidikan",null,null,"WISATA",null,null,"Saldo"]
[null,null,null,null,null,null,"Simpanan","Tarik Simp.","saldo","Simpanan","Tarik Simp.","saldo","Simpanan","Tarik Simp.","saldo","SW&SS"]
[" Pindahan",null,null,null,null,null,null,null,{"$f":"+G7","v":0},null,null,{"$f":"+J7","v":0},null,null,{"$f":"+M7","v":0},{"$f":"+D7+E7","v":0}]
["Januari",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q8),0)","v":2000},{"$f":"IFERROR(INDEX(Table3[Column8],$Q8),0)","v":3000},{"$f":"IFERROR(INDEX(Table3[Column9],$Q8),0)","v":4000},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q8),0)","v":6000},null,{"$f":"+I7+M8-H8","v":4000},{"$f":"IFERROR(INDEX(Table3[Column10],$Q8),0)","v":999999},null,{"$f":"+L7+J8-K8","v":999999},{"$f":"IFERROR(INDEX(Table3[Column9],$Q8),0)","v":4000},null,{"$f":"+O7+M8-N8","v":4000},{"$f":"+P7+D8+E8-F8","v":7000},{"$f":"golek($C$4&TEXT(ROW(A1),\"00\"))-1","v":1}]
["Pebruari",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q9),0)","v":2000},{"$f":"IFERROR(INDEX(Table3[Column8],$Q9),0)","v":3000},{"$f":"IFERROR(INDEX(Table3[Column9],$Q9),0)","v":4000},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q9),0)","v":6000},null,{"$f":"+I8+G9-H9","v":10000},{"$f":"IFERROR(INDEX(Table3[Column10],$Q9),0)","v":999999},null,1999998,{"$f":"IFERROR(INDEX(Table3[Column9],$Q9),0)","v":4000},null,8000,{"$f":"+P8+D9+E9-F9","v":14000},{"$f":"golek($C$4&TEXT(ROW(A2),\"00\"))-1","v":2}]
["Maret",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q10),0)","v":2000},{"$f":"IFERROR(INDEX(Table3[Column8],$Q10),0)","v":3000},{"$f":"IFERROR(INDEX(Table3[Column9],$Q10),0)","v":4000},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q10),0)","v":6000},null,16000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q10),0)","v":999999},null,2999997,{"$f":"IFERROR(INDEX(Table3[Column9],$Q10),0)","v":4000},null,12000,21000,3]
["april",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q11),0)","v":2000},{"$f":"IFERROR(INDEX(Table3[Column8],$Q11),0)","v":3000},{"$f":"IFERROR(INDEX(Table3[Column9],$Q11),0)","v":4000},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q11),0)","v":6000},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q11),0)","v":999999},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q11),0)","v":4000},null,16000,28000,4]
["Mei",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q12),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q12),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q12),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q12),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q12),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q12),0)","v":0},null,16000,28000,-1]
["Juni",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q13),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q13),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q13),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q13),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q13),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q13),0)","v":0},null,16000,28000,-1]
["Juli",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q14),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q14),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q14),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q14),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q14),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q14),0)","v":0},null,16000,28000,-1]
["Agustus",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q15),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q15),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q15),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q15),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q15),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q15),0)","v":0},null,16000,28000,-1]
["September",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q16),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q16),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q16),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q16),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q16),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q16),0)","v":0},null,16000,28000,-1]
["Oktober",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q17),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q17),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q17),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q17),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q17),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q17),0)","v":0},null,16000,28000,-1]
["Nopember",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q18),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q18),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q18),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q18),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q18),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q18),0)","v":0},null,16000,28000,-1]
["Desember",null,{"$f":"IFERROR(INDEX(Table3[Column7],$Q19),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column8],$Q19),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column9],$Q19),0)","v":0},null,{"$f":"IFERROR(INDEX(Table3[Column11],$Q19),0)","v":0},null,22000,{"$f":"IFERROR(INDEX(Table3[Column10],$Q19),0)","v":0},null,3999996,{"$f":"IFERROR(INDEX(Table3[Column9],$Q19),0)","v":0},null,16000,28000,-1]
["Jumlah",null,{"$f":"SUM(C7:C19)","v":8000},{"$f":"IF(P19=0,(0),SUM(D7:D19))","v":12000},{"$f":"IF(P19=0,(0),SUM(E7:E19))","v":16000},{"$f":"SUM(F7:F19)","v":0},{"$f":"SUM(G7:G19)","v":24000},{"$f":"SUM(H8:H19)","v":0},{"$f":"+I19","v":22000},{"$f":"SUM(J7:J19)","v":3999996},{"$f":"SUM(K8:K19)","v":0},{"$f":"+L19","v":3999996},{"$f":"SUM(M7:M19)","v":16000},{"$f":"SUM(N8:N19)","v":0},{"$f":"+O19","v":16000}]
[]
["Pinjaman",null,null,null,null,null,null,null,null,"Jml. BJP  :",{"$f":"+J38","v":2000}]
["Bulan",null,"Salpin lalu"," ","Pinj.Baru",null," ","Angsuran",null," ","Bunga Pinj.",null,null,"Salpin bln ini"," ","PROPISI"]
[null,null,null,"J. Panjang","Ringan","Barang","J. Panjang","Ringan","Barang","J. Panjang","Ringan","Barang","J. Panjang","Ringan","Barang"]
[" Pindahan"]
["Januari",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q26),0)","v":100},{"$f":"IFERROR(INDEX(Table3[Column14],$Q26),0)","v":200},{"$f":"IFERROR(INDEX(Table3[Column15],$Q26),0)","v":300},{"$f":"IFERROR(INDEX(Table3[Column17],$Q26),0)","v":500},{"$f":"IFERROR(INDEX(Table3[Column18],$Q26),0)","v":600},{"$f":"IFERROR(INDEX(Table3[Column19],$Q26),0)","v":700},{"$f":"+M25+D26-G26","v":-100},{"$f":"+N25+E26-H26","v":-200},{"$f":"+O25+F26-I26","v":-300},0,{"$f":"golek($C$4&TEXT(ROW(A1),\"00\"))-1","v":1}]
["Pebruari",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q27),0)","v":100},{"$f":"IFERROR(INDEX(Table3[Column14],$Q27),0)","v":200},{"$f":"IFERROR(INDEX(Table3[Column15],$Q27),0)","v":300},{"$f":"IFERROR(INDEX(Table3[Column17],$Q27),0)","v":500},{"$f":"IFERROR(INDEX(Table3[Column18],$Q27),0)","v":600},{"$f":"IFERROR(INDEX(Table3[Column19],$Q27),0)","v":700},-200,-400,-600,null,{"$f":"golek($C$4&TEXT(ROW(A2),\"00\"))-1","v":2}]
["Maret",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q28),0)","v":100},{"$f":"IFERROR(INDEX(Table3[Column14],$Q28),0)","v":200},{"$f":"IFERROR(INDEX(Table3[Column15],$Q28),0)","v":300},{"$f":"IFERROR(INDEX(Table3[Column17],$Q28),0)","v":500},{"$f":"IFERROR(INDEX(Table3[Column18],$Q28),0)","v":600},{"$f":"IFERROR(INDEX(Table3[Column19],$Q28),0)","v":700},-300,-600,-900,0,3]
["April",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q29),0)","v":100},{"$f":"IFERROR(INDEX(Table3[Column14],$Q29),0)","v":200},{"$f":"IFERROR(INDEX(Table3[Column15],$Q29),0)","v":300},{"$f":"IFERROR(INDEX(Table3[Column17],$Q29),0)","v":500},{"$f":"IFERROR(INDEX(Table3[Column18],$Q29),0)","v":600},{"$f":"IFERROR(INDEX(Table3[Column19],$Q29),0)","v":700},-400,-800,-1200,0,4]
["Mei",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q30),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q30),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q30),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q30),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q30),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q30),0)","v":0},{"$f":"+M29+D30-G30","v":-400},-800,-1200,0,-1]
["Juni",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q31),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q31),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q31),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q31),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q31),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q31),0)","v":0},-400,-800,-1200,0,-1]
["Juli",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q32),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q32),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q32),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q32),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q32),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q32),0)","v":0},-400,-800,-1200,0,-1]
["Agustus",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q33),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q33),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q33),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q33),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q33),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q33),0)","v":0},-400,-800,-1200,{"$f":"+D33*0.01","v":0},-1]
["September",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q34),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q34),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q34),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q34),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q34),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q34),0)","v":0},-400,-800,-1200,0,-1]
["Oktober",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q35),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q35),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q35),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q35),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q35),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q35),0)","v":0},-400,-800,-1200,0,-1]
["Nopember",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q36),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q36),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q36),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q36),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q36),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q36),0)","v":0},-400,-800,-1200,0,-1]
["Desember",null,0,null,null,null,{"$f":"IFERROR(INDEX(Table3[Column13],$Q37),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column14],$Q37),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column15],$Q37),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column17],$Q37),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column18],$Q37),0)","v":0},{"$f":"IFERROR(INDEX(Table3[Column19],$Q37),0)","v":0},-400,-800,-1200,0,-1]
["Jumlah",null,{"$f":"SUM(C26:C37)","v":0},{"$f":"SUM(D26:D37)","v":0},0,0,400,800,1200,2000,2400,2800,null,null,null,{"$f":"SUM(P25:P37)","v":0}]

{"sheet":"Data","index":2,"n_rows":7,"n_cols":31,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14","Column15","Column16","Column17","Column18","Column19","Column20","Column21","Column22","Column23","Column24","Column25","Column26","Column27","Column28","Column29","Column30","Column31"]
[2027,"didin","Jan","Simpanan3","202701",0,2000,3000,4000,999999,6000,null,100,200,300,null,500,600,700,0,0,0,1017399]
[2027,"didin","Feb","Simpanan3","202702",0,2000,3000,4000,999999,6000,null,100,200,300,null,500,600,700,0,0,0,1017399]
[2027,"didin","Mar","Simpanan3","202703",0,2000,3000,4000,999999,6000,null,100,200,300,null,500,600,700,0,0,0,1017399]
[2027,"didin","Apr","Simpanan3","202704",0,2000,3000,4000,999999,6000,null,100,200,300,null,500,600,700,0,0,0,1017399]
[2025,"dudun","May","Simpanan1","202505",0,2000,3000,4000,999999,6000,null,100,200,300,null,500,600,700,0,0,0,1017399]
[2025,"dudun","Jun","Simpanan1","202506",0,2000,3000,4000,999999,6000,null,100,200,300,null,500,600,700,0,0,0,1017399]