{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Formulir penawaran","Rincian Biaya"],"not_rendered":{"charts":1,"images":2,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Formulir penawaran","index":0,"n_rows":48,"n_cols":7,"rows_kept":48,"merged":[[15,1,25,5],[29,1,31,5],[35,1,37,5],[43,1,45,5]]}
[]
[null,"FORMULIR PENAWARAN KONSTRUKSI",{"$nulls":4}," "]
[]
[]
[null,"INFORMASI PEMILIK",null,null,"INFORMASI KONTRAKTOR"]
[null,"Nama","Michael Tucker",null,"Perusahaan","Fabrikam, Inc."]
[null,"Alamat","123 Main St",null,"Nama","John Kane"]
[null,"Kota, Kode Pos","Greenville, CO 12345",null,"Alamat","321 South St"]
[null,"Telepon","(888) 555-0111",null,"Kota, Kode Pos","Greenville, CO 12345"]
[null,"Email","michael@proseware.com",null,"Telepon","(888) 555-0123"]
[{"$nulls":4},"Email","john@fabrikam.com"]
[null,"Nama Proyek","Tangga menuju bisnis",null,"Tanggal Selesai","2013-07-14"]
[]
[null,"LINGKUP PEKERJAAN"]
[]
[null,"Lingkup proyek dicantumkan di sini. Ketikkan semua spesifikasi yang Anda inginkan. Ini adalah simulasi proyek membangun sebuah tangga yang besar. Kami hanya akan menggunakan kayu ukuran 2x4 dan 2x8, dan juga kayu palang siku untuk membangun kerangkanya. Anak tangga akan dipotong dari material 2x4 tersebut. Semua sekrup yang digunakan berukuran 2\".  Ukuran paku tidak akan kurang dari 10 penny. Bobot desain akan mampu menahan 250 kg per anak tangga. Tinggi dan lebar anak tangga akan disesuaikan dengan tangga rumah itu. Tempat istirahat menuju arah tangga berikutnya akan dikencangkan ke rumah. Kontraktor akan menangani pekerjaan pembersihan."]
{"$rows_empty":11}
[null,"TIDAK TERMASUK"]
[]
[null,"Pegangan tangan tidak akan dipasang. Lantai akan dipersiapkan oleh pemilik. Tangga akan dicat oleh pemilik."]
[]
[]
[]
[null,"PROPOSAL PERUSAHAAN"]
[]
[null,"Kami, Fabrikam, Inc., mengajukan lingkup perkerjaan tersebut di atas, untuk diselesaikan pada tanggal 14/7/2011 dengan biaya $476,43."]
[]
[]
[]
[null,"Dimasukkan oleh (Perwakilan Perusahaan)",{"$nulls":3},"Tanggal"]
[]
[null,"PENERIMAAN PEMILIK"]
[]
[null,"Saya, Michael Tucker,menerima lingkup pekerjaan di atas, yang diajukan untuk selesai pada tanggal 14/7/2011 dengan biaya $476,43."]
[]
[]
[]
[null,"Dimasukkan oleh (pemilik rumah atau perwakilan resmi)",{"$nulls":3},"Tanggal"]

{"sheet":"Rincian Biaya","index":1,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4]]}
[]
[null,"RINGKASAN BIAYA PENAWARAN",{"$nulls":3}," "]
[]
[]
[null,"DAFTAR MATERIAL DAN BIAYA"]
[]
[null,"Jml.","Deskripsi","Biaya","Total"," "]
[null,5,"Kayu 2x8x10",{"v":6.75,"d":"Rp6.75"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":33.75,"d":"Rp33.75"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":4}]
[null,20,"Kayu 2x4x10",{"v":4.97,"d":"Rp4.97"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":99.39999999999999,"d":"Rp99.40"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":2}]
[null,30,"Kayu palang silang",{"v":2.49,"d":"Rp2.49"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":74.7,"d":"Rp74.70"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":3}]
[null,2,"Kotak sekrup, 2 in",{"v":6.67,"d":"Rp6.67"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":13.34,"d":"Rp13.34"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":6}]
[null,2,"Kotak paku, 10 penny",{"v":3.25,"d":"Rp3.25"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":6.5,"d":"Rp6.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":7}]
[null,2,"Pasang sarung, kulit",{"v":7.75,"d":"Rp7.75"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":15.5,"d":"Rp15.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":5}]
[null,2,"Biaya tenaga kerja",{"v":100,"d":"Rp100.00"},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":200,"d":"Rp200.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":1}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[1,{"$nulls":3},{"$f":"BidItems[Biaya]*BidItems[Jml.]","v":{"v":0,"d":"Rp0.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[2,null,null,"Subtotal",{"$f":"SUBTOTAL(109,BidItems[Total])","v":{"v":443.18999999999994,"d":"Rp443.19"}}]
[3,null,null,"Tarif Pajak",{"v":0.075,"d":"Rp0.08"}]
[4,null,null,"Pajak",{"$f":"TaxRate*BidItems[[#Totals],[Total]]","v":{"v":33.23924999999999,"d":"Rp33.24"}}]
[5,null,null,"Total keseluruhan",{"$f":"Tax+BidItems[[#Totals],[Total]]","v":{"v":476.4292499999999,"d":"Rp476.43"}}]
[]
[]
[]
[null,"RINCIAN MATERIAL DAN BIAYA"]
[]
[]
[null,null,"TOTAL","CATATAN"]
[null,{"$f":"INDEX(BidItems[],MATCH(A31,BidItems[[ ]],0),2)","v":"Biaya tenaga kerja"},{"$f":"INDEX(BidItems[],MATCH(A31,BidItems[[ ]],0),4)","v":{"v":200,"d":"$200.00"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A32,BidItems[[ ]],0),2)","v":"Kayu 2x4x10"},{"$f":"INDEX(BidItems[],MATCH(A32,BidItems[[ ]],0),4)","v":{"v":99.39999999999999,"d":"$99.40"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A33,BidItems[[ ]],0),2)","v":"Kayu palang silang"},{"$f":"INDEX(BidItems[],MATCH(A33,BidItems[[ ]],0),4)","v":{"v":74.7,"d":"$74.70"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A34,BidItems[[ ]],0),2)","v":"Kayu 2x8x10"},{"$f":"INDEX(BidItems[],MATCH(A34,BidItems[[ ]],0),4)","v":{"v":33.75,"d":"$33.75"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A35,BidItems[[ ]],0),2)","v":"Pasang sarung, kulit"},{"$f":"INDEX(BidItems[],MATCH(A35,BidItems[[ ]],0),4)","v":{"v":15.5,"d":"$15.50"}}]