{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Biaya Renovasi Kamar Mandi"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Biaya Renovasi Kamar Mandi","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[21,1,21,3],[21,4,21,6],[21,7,21,9],[22,1,22,3],[22,4,22,6],[22,7,22,9]]}
[null,"Lembar Kerja Biaya Renovasi Kamar Mandi"]
[null,"CATATAN: Selisih antar kolom dalam tabel akan ditampilkan jika biaya yang dikeluarkan melebihi jumlah estimasi. Angka berwarna merah menunjukkan kekurangan biaya (negatif) dan yang berwarna hitam menunjukkan sisa (positif). "]
[{"$nulls":4},"Detail Biaya (Rp)",null,null,"Total Biaya (Rp)"]
[null,"Area","Item","Jumlah","Estimasi","Aktual","Selisih","Estimasi ","Aktual ","Selisih "]
[null,"Bak Mandi/Shower","Bak mandi, besi cor, 5', standar",1,{"v":250,"d":"Rp250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":261,"d":"Rp261.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-11,"d":"-Rp11.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":250,"d":"Rp250.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":261,"d":"Rp261.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-11,"d":"-Rp11.00"}}]
[null,"Bak Mandi/Shower","Pintu kamar mandi, berengsel, standar",1,{"v":200,"d":"Rp200.00"},{"v":204,"d":"Rp204.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-4,"d":"-Rp4.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":200,"d":"Rp200.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":204,"d":"Rp204.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-4,"d":"-Rp4.00"}}]
[null,"Bak Mandi/Shower","Pancuran, standar",1,{"v":50,"d":"Rp50.00"},{"v":65,"d":"Rp65.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-15,"d":"-Rp15.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":50,"d":"Rp50.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":65,"d":"Rp65.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-15,"d":"-Rp15.00"}}]
[null,"Bak Mandi/Shower","Dinding yang mengelilingi bak mandi, standar",1,{"v":200,"d":"Rp200.00"},{"v":206,"d":"Rp206.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-6,"d":"-Rp6.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":200,"d":"Rp200.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":206,"d":"Rp206.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-6,"d":"-Rp6.00"}}]
[null,"Lemari","Lemari obat 24'', mewah",1,{"v":200,"d":"Rp200.00"},{"v":209,"d":"Rp209.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-9,"d":"-Rp9.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":200,"d":"Rp200.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":209,"d":"Rp209.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-9,"d":"-Rp9.00"}}]
[null,"Lemari","Meja wastafel 30'', standar",2,{"v":100,"d":"Rp100.00"},{"v":119,"d":"Rp119.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-19,"d":"-Rp19.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":200,"d":"Rp200.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":238,"d":"Rp238.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-38,"d":"-Rp38.00"}}]
[null,"Meja","Ubin keramik, mewah (jml. dalam meter)",5,{"v":22.5,"d":"Rp22.50"},{"v":42,"d":"Rp42.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-19.5,"d":"-Rp19.50"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":112.5,"d":"Rp112.50"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":210,"d":"Rp210.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-97.5,"d":"-Rp97.50"}}]
[null,"Keran","Keran, bak mandi, standar",1,{"v":90,"d":"Rp90.00"},{"v":98,"d":"Rp98.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-8,"d":"-Rp8.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":90,"d":"Rp90.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":98,"d":"Rp98.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-8,"d":"-Rp8.00"}}]
[null,"Keran","Keran, pancuran, satu tuas, standar",1,{"v":115,"d":"Rp115.00"},{"v":121,"d":"Rp121.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-6,"d":"-Rp6.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":115,"d":"Rp115.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":121,"d":"Rp121.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-6,"d":"-Rp6.00"}}]
[null,"Keran","Keran wastafel, standar",1,{"v":95,"d":"Rp95.00"},{"v":110,"d":"Rp110.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-15,"d":"-Rp15.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":95,"d":"Rp95.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":110,"d":"Rp110.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-15,"d":"-Rp15.00"}}]
[null,"Lantai","Ubin keramik, standar (jml. dalam meter persegi)",35,{"v":12,"d":"Rp12.00"},{"v":14,"d":"Rp14.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-2,"d":"-Rp2.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":420,"d":"Rp420.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":490,"d":"Rp490.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-70,"d":"-Rp70.00"}}]
[null,"Perkakas","Gantungan handuk, standar",2,{"v":15,"d":"Rp15.00"},{"v":26,"d":"Rp26.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-11,"d":"-Rp11.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":30,"d":"Rp30.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":52,"d":"Rp52.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-22,"d":"-Rp22.00"}}]
[null,"Perkakas","Tempat tisu toilet",1,{"v":10,"d":"Rp10.00"},{"v":21,"d":"Rp21.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-11,"d":"-Rp11.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":10,"d":"Rp10.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":21,"d":"Rp21.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-11,"d":"-Rp11.00"}}]
[null,"Lampu","Lampu plafon, standar",4,{"v":25,"d":"Rp25.00"},{"v":37,"d":"Rp37.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-12,"d":"-Rp12.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":100,"d":"Rp100.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":148,"d":"Rp148.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-48,"d":"-Rp48.00"}}]
[null,"Wastafel","Kloset, standar",2,{"v":60,"d":"Rp60.00"},{"v":71,"d":"Rp71.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-11,"d":"-Rp11.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":120,"d":"Rp120.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":142,"d":"Rp142.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-22,"d":"-Rp22.00"}}]
[null,"Lainnya",null,1,{"v":20,"d":"Rp20.00"},{"v":39,"d":"Rp39.00"},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi]]-Biaya[[#This Row],[Aktual]], \"\")","v":{"v":-19,"d":"-Rp19.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Estimasi]], \"\")","v":{"v":20,"d":"Rp20.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Jumlah]]*Biaya[[#This Row],[Aktual]], \"\")","v":{"v":39,"d":"Rp39.00"}},{"$f":"IFERROR(Biaya[[#This Row],[Estimasi ]]-Biaya[[#This Row],[Aktual ]], \"\")","v":{"v":-19,"d":"-Rp19.00"}}]
[null,"Subtotal",null,null,{"$f":"SUBTOTAL(109,Biaya[Estimasi])","v":{"v":1464.5,"d":"Rp1,464.50"}},{"$f":"SUBTOTAL(109,Biaya[Aktual])","v":{"v":1643,"d":"Rp1,643.00"}},{"$f":"SUBTOTAL(109,Biaya[Selisih])","v":{"v":-178.5,"d":"-Rp178.50"}},{"$f":"SUBTOTAL(109,Biaya[[Estimasi ]])","v":{"v":2212.5,"d":"Rp2,212.50"}},{"$f":"SUBTOTAL(109,Biaya[[Aktual ]])","v":{"v":2614,"d":"Rp2,614.00"}},{"$f":"SUBTOTAL(109,Biaya[[Selisih ]])","v":{"v":-401.5,"d":"-Rp401.50"}}]
[null,"Biaya Tidak Terduga (tambahkan 30% dari estimasi)",null,null,{"$f":"IFERROR(Biaya[[#Totals],[Estimasi]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"Rp439.35"}},null,null,{"$f":"IFERROR(Biaya[[#Totals],[Estimasi ]]*0.3, \"\")","v":{"v":663.75,"d":"Rp663.75"}}]
[null,"Total biaya",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"Rp1,464.50"}},null,null,{"$f":"IFERROR(SUM(Biaya[[#Totals],[Estimasi ]],Sisa), \"\")","v":{"v":2876.25,"d":"Rp2,876.25"}}]