{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Faktur","Pelanggan","Faktur - Utama","Detail Faktur","Tentang Pencatat Faktur Ini"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Faktur","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[37,1,37,4],[38,1,38,4]]}
[null,"Nama Perusahaan"]
[null,"Alamat",null,"T: Nomor Telepon",null,"Email"]
[null,"Kota, Provinsi, Kode Pos",null,"F: Nomor Faks",null,"Situs web"]
[null,"Tagihkan Kepada:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],3,TRUE),\"\")","v":"Contoso, Ltd"},{"$f":"\"Telepon: \"&IFERROR(VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],9,FALSE),\"\")","v":"Telepon: 432-555-0189"},null,"No. Faktur:","3-456-2"]
[null,"Alamat:",{"$f":"IFERROR(IF((VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],5,FALSE))=\"\",\"\",(VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],5,FALSE))),\"\")","v":"Jl. Kerinci no. 567"},{"$f":"\"Faks:      \"&IFERROR(VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],11,FALSE),\"\")","v":"Faks:      432-555-0123"},null,"Tanggal Faktur:",{"$f":"IFERROR(IF(VLOOKUP(rngFaktur,FakturUtama[],3,FALSE)=\"\",\"\",VLOOKUP(rngFaktur,FakturUtama[],3,FALSE)),\"\")","v":"2019-08-11"}]
[null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],6,FALSE)&\", \"& VLOOKUP(VLOOKUP(G4,FakturUtama[],2,FALSE),DaftarPelanggan[],7,FALSE)&\" \"&VLOOKUP(VLOOKUP(G4,FakturUtama[],2,FALSE),DaftarPelanggan[],8,FALSE),\"\")","v":"Bandung, Jawa Barat 098765"},{"$f":"\"Email: \"&IFERROR(VLOOKUP(VLOOKUP(rngFaktur,FakturUtama[],2,FALSE),DaftarPelanggan[],10,FALSE),\"\")","v":"Email: seseorang@contoh.com"}]
[null,{"$f":"\"Faktur Untuk: \"&IFERROR(VLOOKUP(rngFaktur,FakturUtama[],4),\"\")","v":"Faktur Untuk: Proyek 2"}]
[null,"No. Item","Deskripsi","Jml","Harga Satuan","Diskon","Harga"]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(1:1)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4567"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(1:1)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 1"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(1:1)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":39},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(1:1)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":5,"d":"Rp5.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(1:1)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"$f":"IFERROR((D9*E9)-F9,\"\")","v":{"v":195,"d":"Rp195.00"}}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(2:2)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4568"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(2:2)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 2"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(2:2)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(2:2)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":4,"d":"Rp4.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(2:2)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":5,"d":"Rp5.00"}},{"v":155,"d":"Rp155.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(3:3)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4569"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(3:3)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 3"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(3:3)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":30},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(3:3)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":6,"d":"Rp6.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(3:3)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":7,"d":"Rp7.00"}},{"v":173,"d":"Rp173.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(4:4)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4570"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(4:4)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 4"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(4:4)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(4:4)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":7,"d":"Rp7.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(4:4)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":280,"d":"Rp280.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(5:5)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4571"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(5:5)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 5"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(5:5)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":10},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(5:5)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":4,"d":"Rp4.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(5:5)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":40,"d":"Rp40.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(6:6)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4572"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(6:6)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 6"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(6:6)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(6:6)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":8,"d":"Rp8.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(6:6)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":40,"d":"Rp40.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(7:7)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4573"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(7:7)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 7"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(7:7)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":70},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(7:7)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":6,"d":"Rp6.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(7:7)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":420,"d":"Rp420.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(8:8)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4574"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(8:8)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 8"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(8:8)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":25},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(8:8)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":4,"d":"Rp4.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(8:8)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":100,"d":"Rp100.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(9:9)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4575"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(9:9)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 9"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(9:9)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(9:9)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":7,"d":"Rp7.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(9:9)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":3,"d":"Rp3.00"}},{"v":32,"d":"Rp32.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(10:10)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4576"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(10:10)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 10"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(10:10)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":80},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(10:10)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":1,"d":"Rp1.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(10:10)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":80,"d":"Rp80.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(11:11)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4577"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(11:11)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 11"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(11:11)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":65},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(11:11)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":7,"d":"Rp7.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(11:11)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":455,"d":"Rp455.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(12:12)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":"Z4578"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(12:12)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":"Faktur 3-456-2 Data 12"},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(12:12)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":44},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(12:12)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":{"v":1,"d":"Rp1.00"}},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(12:12)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":0},{"v":44,"d":"Rp44.00"}]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(13:13)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(13:13)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(13:13)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(13:13)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(13:13)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(14:14)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(14:14)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(14:14)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(14:14)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(14:14)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(15:15)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(15:15)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(15:15)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(15:15)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(15:15)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(16:16)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(16:16)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(16:16)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(16:16)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(16:16)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(17:17)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(17:17)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(17:17)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(17:17)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(17:17)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(18:18)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(18:18)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(18:18)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(18:18)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(18:18)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(19:19)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(19:19)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(19:19)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(19:19)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(19:19)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(20:20)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(20:20)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(20:20)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(20:20)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(20:20)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(21:21)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(21:21)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(21:21)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(21:21)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(21:21)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(22:22)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(22:22)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(22:22)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(22:22)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(22:22)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(23:23)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(23:23)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(23:23)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(23:23)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(23:23)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(24:24)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(24:24)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(24:24)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(24:24)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(24:24)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(25:25)), MATCH($B$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(25:25)), MATCH($C$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(25:25)), MATCH($D$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(25:25)), MATCH($E$8, DetailFaktur[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(DetailFaktur[],SMALL(IF(DetailFaktur[No. Faktur]=rngFaktur,ROW(DetailFaktur[])-ROW(DetailFaktur[#Headers])), ROW(25:25)), MATCH($F$8, DetailFaktur[#Headers], 0)),\"\")","v":""},""]
[{"$nulls":5},"Subtotal Faktur",{"$f":"SUM(FakturProyek[Harga])","v":{"v":2014,"d":"Rp2,014.00"}}]
[{"$nulls":5},"Tarif Pajak",{"$f":"VLOOKUP(rngFaktur,FakturUtama[],5)","v":{"v":0.0875,"d":"8.75%"}}]
[{"$nulls":5},"Pajak Penjualan",{"$f":"G34*G35","v":{"v":176.225,"d":"Rp176.23"}}]
[{"$nulls":5},"Lainnya",{"$f":"VLOOKUP(rngFaktur,FakturUtama[],6)","v":0}]
[null,{"$f":"\"Cek terutang diberikan kepada \"&NamaPerusahaan&\".\"","v":"Cek terutang diberikan kepada Nama Perusahaan."},{"$nulls":3},"Deposito Diterima",{"$f":"VLOOKUP(rngFaktur,FakturUtama[],7)","v":0}]
[null,"Total jatuh tempo di <#> hari. Akun yang jatuh tempo tunduk terhadap biaya layanan <#>% per bulan.",{"$nulls":3},"TOTAL",{"$f":"(G34+G36+G37)-G38","v":{"v":2190.225,"d":"Rp2,190.23"}}]

{"sheet":"Pelanggan","index":1,"n_rows":6,"n_cols":12,"rows_kept":6}
[]
[null,null,"Pelanggan"]
[null,"Cari","No. Perusahaan","Nama Perusahaan","Nama Kontak","Alamat","Kota","Provinsi","Kode Pos","Telepon","Email","Faks"]
[null,{"$f":"C4& \" - \"&D4","v":"1 - Tailspin Toys "},1,"Tailspin Toys ","Rudi Lesmana","Jl. Rinjani no. 345","Jakarta","DKI Jakarta","123456","432-555-0178","seseorang@contoh.com","432-555-0187"]
[null,"2 - Contoso, Ltd",2,"Contoso, Ltd","Santoso Putranto","Jl. Kerinci no. 567","Bandung","Jawa Barat","098765","432-555-0189","seseorang@contoh.com","432-555-0123"]
[null,"Total",{"$f":"\"Total Pelanggan: \"&SUBTOTAL(103,DaftarPelanggan[No. Perusahaan])","v":"Total Pelanggan: 2"}]

{"sheet":"Faktur - Utama","index":2,"n_rows":6,"n_cols":11,"rows_kept":6}
[]
[null,"Faktur"]
[null,"No. Faktur","Perusahaan","Tanggal Faktur","Deskripsi Proyek","Tarif Pajak","Lainnya","Uang Muka","Total Detail","Total Faktur","Catatan"]
[null,"3-456-1","1 - Tailspin Toys ",{"$f":"TODAY()","v":"2019-08-01"},"Proyek 1",{"v":0.0875,"d":"8.75%"},{"v":100,"d":"Rp100.00"},{"v":100,"d":"Rp100.00"},{"$f":"SUMIF(DetailFaktur[No. Faktur],\"=\"&FakturUtama[[#This Row],[No. Faktur]],DetailFaktur[Total])","v":{"v":5200,"d":"Rp5,200.00"}},{"$f":"(FakturUtama[[#This Row],[Total Detail]]*(1+FakturUtama[[#This Row],[Tarif Pajak]]))+FakturUtama[[#This Row],[Lainnya]]-FakturUtama[[#This Row],[Uang Muka]]","v":{"v":5654.999999999999,"d":"Rp5,655.00"}}]
[null,"3-456-2","2 - Contoso, Ltd",{"$f":"TODAY()+10","v":"2019-08-11"},"Proyek 2",{"v":0.0875,"d":"8.75%"},null,null,{"$f":"SUMIF(DetailFaktur[No. Faktur],\"=\"&FakturUtama[[#This Row],[No. Faktur]],DetailFaktur[Total])","v":{"v":2014,"d":"Rp2,014.00"}},{"$f":"(FakturUtama[[#This Row],[Total Detail]]*(1+FakturUtama[[#This Row],[Tarif Pajak]]))+FakturUtama[[#This Row],[Lainnya]]-FakturUtama[[#This Row],[Uang Muka]]","v":{"v":2190.225,"d":"Rp2,190.23"}}]
[null,"Total",{"$f":"\"Total Faktur: \"&SUBTOTAL(103,FakturUtama[No. Faktur])","v":"Total Faktur: 2"},{"$nulls":3},{"$f":"SUBTOTAL(109,FakturUtama[Lainnya])","v":{"v":100,"d":"Rp100.00"}},{"$f":"SUBTOTAL(109,FakturUtama[Uang Muka])","v":{"v":100,"d":"Rp100.00"}},{"$f":"SUBTOTAL(109,FakturUtama[Total Detail])","v":{"v":7214,"d":"Rp7,214.00"}},{"$f":"SUBTOTAL(109,FakturUtama[Total Faktur])","v":{"v":7845.2249999999985,"d":"Rp7,845.23"}}]

{"sheet":"Detail Faktur","index":3,"n_rows":40,"n_cols":8,"rows_kept":40}
[]
[null,"Detail Faktur"]
[null,"Deskripsi","No. Faktur","No. Item","Jml","Harga Satuan","Diskon","Total"]
[null,"Faktur 3-456-1 Data 1","3-456-1",1,1,{"v":1,"d":"Rp1.00"},{"v":1,"d":"Rp1.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":0,"d":"Rp0.00"}}]
[null,"Faktur 3-456-1 Data 2","3-456-1",2,2,{"v":2,"d":"Rp2.00"},{"v":2,"d":"Rp2.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":2,"d":"Rp2.00"}}]
[null,"Faktur 3-456-1 Data 3","3-456-1",3,3,{"v":3,"d":"Rp3.00"},{"v":3,"d":"Rp3.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":6,"d":"Rp6.00"}}]
[null,"Faktur 3-456-1 Data 4","3-456-1",4,4,{"v":4,"d":"Rp4.00"},{"v":4,"d":"Rp4.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":12,"d":"Rp12.00"}}]
[null,"Faktur 3-456-1 Data 5","3-456-1",5,5,{"v":5,"d":"Rp5.00"},{"v":5,"d":"Rp5.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":20,"d":"Rp20.00"}}]
[null,"Faktur 3-456-1 Data 6","3-456-1",6,6,{"v":6,"d":"Rp6.00"},{"v":6,"d":"Rp6.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":30,"d":"Rp30.00"}}]
[null,"Faktur 3-456-1 Data 7","3-456-1",7,7,{"v":7,"d":"Rp7.00"},{"v":7,"d":"Rp7.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":42,"d":"Rp42.00"}}]
[null,"Faktur 3-456-1 Data 8","3-456-1",8,8,{"v":8,"d":"Rp8.00"},{"v":8,"d":"Rp8.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":56,"d":"Rp56.00"}}]
[null,"Faktur 3-456-1 Data 9","3-456-1",9,9,{"v":9,"d":"Rp9.00"},{"v":9,"d":"Rp9.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":72,"d":"Rp72.00"}}]
[null,"Faktur 3-456-1 Data 10","3-456-1",10,10,{"v":10,"d":"Rp10.00"},{"v":10,"d":"Rp10.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":90,"d":"Rp90.00"}}]
[null,"Faktur 3-456-1 Data 11","3-456-1",11,11,{"v":11,"d":"Rp11.00"},{"v":11,"d":"Rp11.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":110,"d":"Rp110.00"}}]
[null,"Faktur 3-456-1 Data 12","3-456-1",12,12,{"v":12,"d":"Rp12.00"},{"v":12,"d":"Rp12.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":132,"d":"Rp132.00"}}]
[null,"Faktur 3-456-1 Data 13","3-456-1",13,13,{"v":13,"d":"Rp13.00"},{"v":13,"d":"Rp13.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":156,"d":"Rp156.00"}}]
[null,"Faktur 3-456-1 Data 14","3-456-1",14,14,{"v":14,"d":"Rp14.00"},{"v":14,"d":"Rp14.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":182,"d":"Rp182.00"}}]
[null,"Faktur 3-456-1 Data 15","3-456-1",15,15,{"v":15,"d":"Rp15.00"},{"v":15,"d":"Rp15.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":210,"d":"Rp210.00"}}]
[null,"Faktur 3-456-1 Data 16","3-456-1",16,16,{"v":16,"d":"Rp16.00"},{"v":16,"d":"Rp16.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":240,"d":"Rp240.00"}}]
[null,"Faktur 3-456-1 Data 17","3-456-1",17,17,{"v":17,"d":"Rp17.00"},{"v":17,"d":"Rp17.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":272,"d":"Rp272.00"}}]
[null,"Faktur 3-456-1 Data 18","3-456-1",18,18,{"v":18,"d":"Rp18.00"},{"v":18,"d":"Rp18.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":306,"d":"Rp306.00"}}]
[null,"Faktur 3-456-1 Data 19","3-456-1",19,19,{"v":19,"d":"Rp19.00"},{"v":19,"d":"Rp19.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":342,"d":"Rp342.00"}}]
[null,"Faktur 3-456-1 Data 20","3-456-1",20,20,{"v":20,"d":"Rp20.00"},{"v":20,"d":"Rp20.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":380,"d":"Rp380.00"}}]
[null,"Faktur 3-456-1 Data 21","3-456-1",21,21,{"v":21,"d":"Rp21.00"},{"v":21,"d":"Rp21.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":420,"d":"Rp420.00"}}]
[null,"Faktur 3-456-1 Data 22","3-456-1",22,22,{"v":22,"d":"Rp22.00"},{"v":22,"d":"Rp22.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":462,"d":"Rp462.00"}}]
[null,"Faktur 3-456-1 Data 23","3-456-1",23,23,{"v":23,"d":"Rp23.00"},{"v":23,"d":"Rp23.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":506,"d":"Rp506.00"}}]
[null,"Faktur 3-456-1 Data 24","3-456-1",24,24,{"v":24,"d":"Rp24.00"},{"v":24,"d":"Rp24.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":552,"d":"Rp552.00"}}]
[null,"Faktur 3-456-1 Data 25","3-456-1",25,25,{"v":25,"d":"Rp25.00"},{"v":25,"d":"Rp25.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":600,"d":"Rp600.00"}}]
[null,"Faktur 3-456-2 Data 1","3-456-2","Z4567",39,{"v":5,"d":"Rp5.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":195,"d":"Rp195.00"}}]
[null,"Faktur 3-456-2 Data 2","3-456-2","Z4568",40,{"v":4,"d":"Rp4.00"},{"v":5,"d":"Rp5.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":155,"d":"Rp155.00"}}]
[null,"Faktur 3-456-2 Data 3","3-456-2","Z4569",30,{"v":6,"d":"Rp6.00"},{"v":7,"d":"Rp7.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":173,"d":"Rp173.00"}}]
[null,"Faktur 3-456-2 Data 4","3-456-2","Z4570",40,{"v":7,"d":"Rp7.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":280,"d":"Rp280.00"}}]
[null,"Faktur 3-456-2 Data 5","3-456-2","Z4571",10,{"v":4,"d":"Rp4.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":40,"d":"Rp40.00"}}]
[null,"Faktur 3-456-2 Data 6","3-456-2","Z4572",5,{"v":8,"d":"Rp8.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":40,"d":"Rp40.00"}}]
[null,"Faktur 3-456-2 Data 7","3-456-2","Z4573",70,{"v":6,"d":"Rp6.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":420,"d":"Rp420.00"}}]
[null,"Faktur 3-456-2 Data 8","3-456-2","Z4574",25,{"v":4,"d":"Rp4.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":100,"d":"Rp100.00"}}]
[null,"Faktur 3-456-2 Data 9","3-456-2","Z4575",5,{"v":7,"d":"Rp7.00"},{"v":3,"d":"Rp3.00"},{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":32,"d":"Rp32.00"}}]
[null,"Faktur 3-456-2 Data 10","3-456-2","Z4576",80,{"v":1,"d":"Rp1.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":80,"d":"Rp80.00"}}]
[null,"Faktur 3-456-2 Data 11","3-456-2","Z4577",65,{"v":7,"d":"Rp7.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":455,"d":"Rp455.00"}}]
[null,"Faktur 3-456-2 Data 12","3-456-2","Z4578",44,{"v":1,"d":"Rp1.00"},null,{"$f":"(DetailFaktur[[#This Row],[Jml]]*DetailFaktur[[#This Row],[Harga Satuan]])-DetailFaktur[[#This Row],[Diskon]]","v":{"v":44,"d":"Rp44.00"}}]

{"sheet":"Tentang Pencatat Faktur Ini","index":4,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,1,12,7],[13,2,13,3],[14,2,14,7],[15,1,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,1,22,7],[23,1,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,1,28,7],[29,1,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7]]}
[null,"Tentang Pencatat Faktur Ini"]
[]
[]
[null,"Pencatat Faktur ini dirancang untuk mengelola riwayat pelanggan, faktur, dan detail faktur sehingga Anda dapat menyimpan beberapa faktur dalam satu file. Anda juga dapat menggunakan Pencatat Faktur untuk menganalisis data dalam faktur sebelumnya. Misalnya, Anda dapat menampilkan semua faktur untuk seorang pelanggan, proyek tertentu, atau menampilkan semua faktur dalam satu bulan terakhir, tahun lalu, dan lainnya."]
[null,"Sebelum memulai, silakan lihat data sampel yang disediakan. Pada lembar Faktur, pilih sel di sebelah kanan No. Faktur (sel L8), dan daftar menurun akan muncul. Pilih panah menurun, lalu pilih faktur sampel. Lihat bagaimana semua informasi faktur berubah secara otomatis untuk memperlihatkan faktur yang dipilih. Sekarang, lihat lembar Pelanggan, Faktur - Utama, dan Detail Faktur. Setiap lembar ini menyediakan informasi untuk Faktur dan setiap perubahan yang dibuat akan diperbarui secara otomatis. "]
[null,"Bagaimana cara memulainya?"]
[null,"Ubah lembar Faktur agar memperlihatkan informasi perusahaan Anda dengan langkah-langkah berikut:"]
[null,"1.","Navigasikan ke lembar Faktur, lalu pada tab Peninjauan, dalam grup Lindungi, pilih Tidak Lindungi Lembar. "]
[null,null,"Catatan: Lembar Faktur dilindungi untuk membantu menghindari perubahan yang tidak disengaja, karena, seperti yang sudah disebutkan, sebagian besar data dalam lembar ini diambil dari semua lembar lain dalam buku kerja ini. "]
[null,"2.","Sesuaikan header faktur dengan mengetikkan Nama Perusahaan Anda, Alamat, Kota, Provinsi, Kode Pos, alamat email, situs web, dan seterusnya. Di bagian bawah faktur (baris 43), ubah instruksi pembayarannya. "]
[null,null,"Penting! Jangan ubah informasi tagihan atau faktur. Semua sel ini berisi rumus yang akan memperbarui faktur secara otomatis, sebagaimana dijelaskan di bagian Tentang Pencatat Faktur.  "]
[null,"3.","(Opsional) Ubah warna di seluruh buku kerja: Pada tab Tata Letak Halaman, dalam grup Tema, pilih Warna, lalu pilih rangkaian warna tema lainnya dari galeri warna. "]
[null,"Tips: Buat rangkaian warna tema kustom untuk mencerminkan citra perusahaan Anda! Untuk melakukannya, pada tab Tata Letak Halaman, dalam grup Tema, pilih Warna, lalu pilih Kustomisasi Warna. Untuk informasi selengkapnya tentang membuat rangkaian warna kustom, lihat topik Bantuan berikut ini: "]
[null,null,"Sesuaikan tema dokumen."]
[null,"4.","Setelah membuat perubahan yang diinginkan, kembali ke lembar Faktur, dan pada tab Peninjauan, dalam grup Perubahan, pilih Proteksi Lembar, lalu pilih OK. Jika lembar Faktur dilindungi, satu-satunya sel yang dapat Anda pilih adalah sel dengan daftar menurun No. Faktur."]
[null,"Bagaimana cara membuat faktur?"]
[null,"1.","Pada lembar Pelanggan, masukkan informasi pelanggan seperti nama dan alamat perusahaan. Perlu diketahui bahwa No. Perusahaan adalah entri yang penting karena memberikan pengidentifikasi unik bagi setiap perusahaan yang digunakan di seluruh Pencatat Faktur. Perlu diketahui juga bahwa Anda hanya perlu menambahkan perusahaan satu kali. Untuk faktur berikutnya dari perusahaan yang sama, langkah ini dapat dilewati. "]
[null,null,"Catatan: Jika Anda menetapkan nomor yang sama ke lebih dari satu Perusahaan atau memasukkan Nama Perusahaan yang sama lebih dari sekali, entri akan berubah warna menjadi merah untuk memberitahukan duplikasi tersebut. "]
[null,"2.","Pada lembar Faktur - Utama, masukkan informasi utama faktur seperti No. Faktur, Tanggal Faktur, dan Deskripsi Proyek. Seperti No. Perusahaan, No. Faktur adalah entri yang penting karena memberikan pengidentifikasi unik bagi setiap faktur dan digunakan di seluruh Pencatat Faktur. Entri penting lainnya adalah Perusahaan. Saat Anda memilih sebuah perusahaan dari daftar menurun yang disediakan, faktur Anda akan dikaitkan dengan perusahaan tersebut. Kemudian, jika Anda memilih No. Faktur pada lembar Faktur, informasi perusahaan tersebut seperti nama dan alamat perusahaan akan terisi secara otomatis dalam Faktur."]
[null,null,"Catatan: Jika Anda menetapkan nomor yang sama ke lebih dari satu Faktur, entri akan berubah warna menjadi merah untuk memberitahukan duplikasi tersebut. "]
[null,"3.","Pada lembar Detail Faktur, masukkan detail untuk faktur, seperti Deskripsi Item, No. item, Jml, dan Harga Satuan. Daftar menurun No. Faktur menyediakan daftar faktur yang Anda masukkan pada lembar Faktur - Utama untuk memudahkan entri data. Sama seperti No. Perusahaan pada langkah sebelumnya, No. Faktur akan mengaitkan item detail tersebut dengan faktur tertentu. Ketika Anda memilih No. Faktur di lembar Faktur dari daftar menurun No. Faktur, item detail faktur yang terkait akan muncul untuk faktur tersebut."]
[null,null,"Catatan: Setiap faktur dibatasi hingga 25 item detail. Jika menambahkan lebih dari 25 item, semua entri yang terkait akan berubah warna menjadi merah untuk memberitahukan batasan ini. Jika ada lebih dari 25 item faktur, Anda harus membuat faktur kedua. "]
[null,"Bagaimana cara menambahkan pelanggan, faktur, dan detail faktur?"]
[null,"Data Pelanggan, Faktur, dan Detail Faktur akan disimpan dalam tabel Excel. Saat Anda menambahkan baris baru ke tabel, baris tersebut akan otomatis diformat dan setiap penghitungan akan disalin. Untuk menambahkan baris tabel baru, lakukan salah satu hal berikut:"]
[null,"● ","Jika tabel tidak memiliki baris Total, mulailah mengetik di bawah tabel dan tabel akan diperluas secara otomatis saat Anda menekan Enter atau tombol Tab."]
[null,"● ","Letakkan penunjuk sel dalam sel terakhir di atas baris Total, seperti pada tabel Faktur dalam sel Catatan untuk faktur terakhir, lalu tekan tombol Tab."]
[null,"● ","Pada tab Beranda, dalam grup Sel, pilih Sisipkan, lalu pilih Baris Tabel Atas atau Tabel Baris Bawah. "]
[null,"● ","Di sudut kanan bawah tabel, letakkan mouse pada gagang pengatur ukuran tabel dan seret ke bawah untuk menambah jumlah baris tabel yang tersedia."]
[null,"Bagaimana cara menganalisis detail faktur?"]
[null,"Seperti yang dijelaskan di bagian Tentang Pencatat Faktur, setelah memasukkan beberapa faktur, Anda dapat menampilkan daftar semua faktur untuk pelanggan atau proyek tertentu, interval tanggal tertentu, dan banyak lagi. Tipe analisis ini diselesaikan menggunakan Filter yang memungkinkan Anda mempersempit daftar data dengan cepat. Untuk mengakses Filter pada tabel Pelanggan, Faktur, atau Detail Faktur, pilih panah menurun di samping setiap nama bidang tabel. Panel Filter akan muncul dan menampilkan beragam opsi pemfilteran. Berikut beberapa contoh pemfilteran untuk membantu Anda memulai:"]
[null,"● ","Untuk menampilkan jumlah total yang telah diberikan dalam faktur kepada pelanggan tertentu: Pada lembar Faktur - Utama, di sebelah kanan bidang No. Perusahaan, pilih panah menurun. Di panel Filter, Klik Pilih Semua untuk membatalkan pilihan semua perusahaan, pilih perusahaan yang diinginkan, kemudian pilih OK. "]
[null,null,"Tips: Di panel Filter, Anda juga dapat mengetikkan nama pelanggan dalam kotak teks Cari untuk mencari daftar yang tersedia dengan cepat."]
[null,"● ","Untuk menampilkan semua faktur bagi pelanggan dan proyek tertentu: Mulai dengan memfilter pelanggan yang diinginkan menggunakan langkah-langkah dalam contoh sebelumnya. Kemudian, di sebelah kanan No. Proyek, pilih panah menurun. Di panel Filter, pilih satu atau beberapa proyek yang diinginkan, kemudian pilih OK. "]
[null,"● ","Untuk menampilkan semua faktur dari bulan sebelumnya: Pada lembar Faktur - Utama, di sebelah kanan bidang Tanggal Faktur, pilih panah menurun, arahkan ke Filter Tanggal, lalu pilih Bulan Lalu."]
[null,"● ","Untuk menampilkan semua pelanggan dengan kode area yang sama: Pada lembar Pelanggan, di sebelah kanan bidang Telepon, pilih panah menurun. Di panel Filter, klik kotak teks Cari, ketikkan kode area, lalu pilih OK. "]
[null,"Tips Filter"]
[null,"● ","Jika tabel memiliki baris total, seperti Pelanggan dan Faktur, total terhitung hanya akan memperlihatkan daftar yang difilter."]
[null,"● ","Gunakan beberapa filter pada satu bidang atau di beberapa bidang untuk menyesuaikan hasil."]
[null,"● ","Untuk menghapus satu filter, pilih panah menurun untuk kolom yang sebelumnya difilter, kemudian pilih Hapus Filter Dari <nama bidang>."]
[null,"● ","Untuk menghapus beberapa filter sekaligus, letakkan penunjuk sel dalam tabel, lalu pada tab Beranda, dalam grup Pengeditan, pilih Urutkan & Filter, lalu pilih Bersihkan."]