{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Borang Bida","Pecahan Kos"],"not_rendered":{"charts":1,"images":2,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Borang Bida","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,"BORANG BIDA PEMBINAAN",{"$nulls":4}," "]
[]
[]
[null,"MAKLUMAT PEMILIK",null,null,"MAKLUMAT KONTRAKTOR"]
[null,"Nama","Michael Tucker",null,"Syarikat","Fabrikam, Inc."]
[null,"Alamat","123 Main St",null,"Nama","John Kane"]
[null,"Bandar, Poskod Kawasan","Greenville, CO 12345",null,"Alamat","321 South St"]
[null,"Telefon",8885550111,null,"Bandar, Poskod Kawasan","Greenville, CO 12345"]
[null,"E-mel","michael@proseware.com",null,"Telefon",8885550123]
[{"$nulls":4},"E-mel","john@fabrikam.com"]
[null,"Nama projek","Tangga ke perniagaan",null,"Tarikh siap","2013-07-14"]
[]
[null,"SKOP KERJA"]
[]
[null,"Skop kerja projek di sini. Taipkan semua spesifikasi yang anda inginkan. Ini adalah projek tiruan untuk membina set tangga yang besar. Kami hanya akan menggunakan kayu gergaji 2x4 dan 2x8 serta pendakap gelegar untuk membina bingkai. Tangga akan dipotong daripada bahan 2x4. Skru yang tidak kurang daripada 2\" akan digunakan. Sebarang paku adalah tidak kurang daripada 10 peni. Berat reka bentuk boleh menampung sekurang-kurangnya 500 paun per langkah. Langkah akan berada pada aras yang sama dengan rumah. Papan langkah akan dipasangkan di rumah. Kontraktor akan membuat kerja pembersihan."]
{"$rows_empty":11}
[null,"TIDAK TERMASUK"]
[]
[null,"Susur tidak akan dipasang. Lantai akan diuruskan oleh pemilik. Tangga akan dicat oleh pemilik."]
[]
[]
[]
[null,"CADANGAN SYARIKAT"]
[]
[null,"Kami, Fabrikam, Inc., mencadangkan skop kerja di atas, akan siap sebelum 14/7/2011 bagi amaun RM476.43."]
[]
[]
[]
[null,"Diserahkan oleh (Wakil Syarikat)",{"$nulls":3},"Tarikh"]
[]
[null,"PENERIMAAN PEMILIK"]
[]
[null,"I, Michael Tucker, sila terima skop kerja di atas, dicadangkan akan siap sebelum 14/7/2011 bagi amaun RM476.43."]
[]
[]
[]
[null,"Diserahkan oleh (pemilih rumah atau wakil yang berkuasa)",{"$nulls":3},"Tarikh"]

{"sheet":"Pecahan Kos","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 KOS BIDA",{"$nulls":3}," "]
[]
[]
[null,"SENARAI BAHAN DAN KOS"]
[]
[null,"Ktt.","Perihalan","Kos","Jumlah"," "]
[null,5,"kayu gergaji 2x8x10",{"v":6.75,"d":"RM7"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":33.75,"d":"RM34"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":4}]
[null,20,"kayu gergaji 2x4x10",{"v":4.97,"d":"RM5"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":99.39999999999999,"d":"RM99"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":2}]
[null,30,"Pendakap gelegar",{"v":2.49,"d":"RM2"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":74.7,"d":"RM75"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":3}]
[null,2,"Sekotak skru, 2 in",{"v":6.67,"d":"RM7"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":13.34,"d":"RM13"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":6}]
[null,2,"Sekotak paku, 10 peni",{"v":3.25,"d":"RM3"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":6.5,"d":"RM7"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":7}]
[null,2,"Sepasang sarung tangan, kulit",{"v":7.75,"d":"RM8"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":15.5,"d":"RM16"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":5}]
[null,2,"Caj buruh",{"v":100,"d":"RM100"},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":{"v":200,"d":"RM200"}},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":1}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[{"$nulls":4},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[1,{"$nulls":3},{"$f":"ItemBida[Kos]*ItemBida[Ktt.]","v":0},{"$f":"_xlfn.RANK.EQ(ItemBida[[#This Row],[Jumlah]],ItemBida[Jumlah])","v":8}]
[2,null,null,"Subjumlah",{"$f":"SUBTOTAL(109,ItemBida[Jumlah])","v":{"v":443.18999999999994,"d":"RM443"}}]
[3,null,null,"Kadar cukai",{"v":0.075,"d":"7.50%"}]
[4,null,null,"Cukai",{"$f":"TaxRate*ItemBida[[#Totals],[Jumlah]]","v":{"v":33.23924999999999,"d":"RM33"}}]
[5,null,null,"Jumlah besar",{"$f":"Tax+ItemBida[[#Totals],[Jumlah]]","v":{"v":476.4292499999999,"d":"RM476"}}]
[]
[]
[]
[null,"PECAHAN BAHAN DAN KOS"]
[]
[]
[null,null,"TOTAL","NOTA"]
[null,{"$f":"INDEX(ItemBida[],MATCH(A31,ItemBida[[ ]],0),2)","v":"Caj buruh"},{"$f":"INDEX(ItemBida[],MATCH(A31,ItemBida[[ ]],0),4)","v":{"v":200,"d":"$200.00"}}]
[null,{"$f":"INDEX(ItemBida[],MATCH(A32,ItemBida[[ ]],0),2)","v":"kayu gergaji 2x4x10"},{"$f":"INDEX(ItemBida[],MATCH(A32,ItemBida[[ ]],0),4)","v":{"v":99.39999999999999,"d":"$99.40"}}]
[null,{"$f":"INDEX(ItemBida[],MATCH(A33,ItemBida[[ ]],0),2)","v":"Pendakap gelegar"},{"$f":"INDEX(ItemBida[],MATCH(A33,ItemBida[[ ]],0),4)","v":{"v":74.7,"d":"$74.70"}}]
[null,{"$f":"INDEX(ItemBida[],MATCH(A34,ItemBida[[ ]],0),2)","v":"kayu gergaji 2x8x10"},{"$f":"INDEX(ItemBida[],MATCH(A34,ItemBida[[ ]],0),4)","v":{"v":33.75,"d":"$33.75"}}]
[null,{"$f":"INDEX(ItemBida[],MATCH(A35,ItemBida[[ ]],0),2)","v":"Sepasang sarung tangan, kulit"},{"$f":"INDEX(ItemBida[],MATCH(A35,ItemBida[[ ]],0),4)","v":{"v":15.5,"d":"$15.50"}}]