{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Biểu mẫu Đấu thầu","Chi tiết Chi phí"],"not_rendered":{"charts":1,"images":2,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Biểu mẫu Đấu thầu","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,"MẪU ĐẤU THẦU XÂY DỰNG",{"$nulls":4}," "]
[]
[]
[null,"THÔNG TIN CHỦ SỞ HỮU NHÀ",null,null,"THÔNG TIN NHÀ THẦU"]
[null,"Tên","Michael Tucker",null,"Công ty","Fabrikam, Inc."]
[null,"Địa chỉ","123 Main St",null,"Tên","John Kane"]
[null,"Thành phố, Bang ZIP","Greenville, CO 12345",null,"Địa chỉ","321 South St"]
[null,"Điện thoại","(888) 555-0111",null,"Thành phố, Bang ZIP","Greenville, CO 12345"]
[null,"Email","michael@proseware.com",null,"Điện thoại","(888) 555-0123"]
[{"$nulls":4},"Email","john@fabrikam.com"]
[null,"Tên Dự án","Chuyên kinh doanh cầu thang",null,"Ngày hoàn thành","2013-07-14"]
[]
[null,"PHẠM VI CÔNG VIỆC"]
[]
[null,"Đây là nơi dành cho phạm vi dự án. Hãy điền tất cả các thông số kỹ thuật mà bạn muốn. Đây sẽ là một dự án mẫu xây dựng một bộ cầu thang lớn. Chúng tôi sẽ chỉ sử dụng gỗ 2x4 và 2x8 cùng với dầm móc để dựng khung. Bậc cầu thang sẽ được cắt từ vật liệu 2x4. Đinh vít sử dụng sẽ không nhỏ hơn 2''.  Bất kỳ loại đinh nào sử dụng cũng có giá trị tối thiểu là 10 xu. Trọng lượng thiết kế sẽ giữ tối thiểu 500 pao mỗi bậc. Các bậc thang sẽ cùng mức với ngôi nhà. Tấm ốp xung quanh sẽ được đính chặt vào ngôi nhà. Nhà thầu sẽ chịu trách nhiệm dọn dẹp công trình."]
{"$rows_empty":11}
[null,"KHÔNG BAO GỒM"]
[]
[null,"Không lắp đặt tay vịn cầu thang. Chủ nhà sẽ chuẩn bị khu đất để làm. Chủ nhà sẽ sơn cầu thang."]
[]
[]
[]
[null,"ĐỀ XUẤT CÔNG TY"]
[]
[null,"Chúng tôi, Fabrikam, Inc., đề xuất phạm vi công việc này sẽ hoàn thành vào 7/14/2011 với số tiền là $476,43."]
[]
[]
[]
[null,"Gửi bởi (Đại diện Công ty)",{"$nulls":3},"Ngày"]
[]
[null,"CHẤP NHẬN CỦA CHỦ SỞ HỮU"]
[]
[null,"Tôi, Michael Tucker, chấp nhận phạm vi công việc này, được đề xuất hoàn thành ngày 7/14/2011 với số tiền là $476,43."]
[]
[]
[]
[null,"Gửi bởi (chủ sở hữu nhà hoặc đại diện ủy quyền)",{"$nulls":3},"Ngày"]

{"sheet":"Chi tiết Chi phí","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,"TỔNG HỢP CHI PHÍ ĐẤU THẦU",{"$nulls":3}," "]
[]
[]
[null,"DANH SÁCH VẬT LIỆU VÀ CHI PHÍ"]
[]
[null,"Số lượng","Mô tả","Chi phí","Tổng cộng"," "]
[null,5,"gỗ 2x8x10",{"v":140400,"d":"140,400.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":702000,"d":"702,000.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":4}]
[null,20,"gỗ 2x4x10",{"v":103376,"d":"103,376.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":2067520,"d":"2,067,520.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":2}]
[null,30,"Dầm móc",{"v":51792.00000000001,"d":"51,792.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":1553760.0000000002,"d":"1,553,760.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":3}]
[null,2,"Hộp đinh vít , 2 in",{"v":138736,"d":"138,736.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":277472,"d":"277,472.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":6}]
[null,2,"Hộp đinh, 10 penni",{"v":67600,"d":"67,600.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":135200,"d":"135,200.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":7}]
[null,2,"Găng tay, bằng da",{"v":161200,"d":"161,200.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":322400,"d":"322,400.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":5}]
[null,2,"Chi phí lao động",{"v":2080000,"d":"2,080,000.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":{"v":4160000,"d":"4,160,000.00₫"}},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":1}]
[{"$nulls":3},{"v":2563,"d":"2,563.00₫"},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[{"$nulls":4},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[1,{"$nulls":3},{"$f":"Mục_đấu_thầu[Chi phí]*Mục_đấu_thầu[Số lượng]","v":0},{"$f":"_xlfn.RANK.EQ(Mục_đấu_thầu[[#This Row],[Tổng cộng]],Mục_đấu_thầu[Tổng cộng])","v":8}]
[2,null,null,"Tổng phụ",{"$f":"SUBTOTAL(109,Mục_đấu_thầu[Tổng cộng])","v":{"v":9218352,"d":"9,218,352.00₫"}}]
[3,null,null,"Thuế suất",{"v":0.075,"d":"7.50%"}]
[4,null,null,"Thuế",{"$f":"TaxRate*Mục_đấu_thầu[[#Totals],[Tổng cộng]]","v":{"v":691376.4,"d":"691,376.40₫"}}]
[5,null,null,"Tổng cộng",{"$f":"Tax+Mục_đấu_thầu[[#Totals],[Tổng cộng]]","v":{"v":9909728.4,"d":"9,909,728.40₫"}}]
[]
[]
[]
[null,"CHI TIẾT VẬT LIỆU VÀ CHI PHÍ"]
[]
[]
[null,null,"TOTAL","CHÚ THÍCH"]
[null,{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A31,Mục_đấu_thầu[[ ]],0),2)","v":"Chi phí lao động"},{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A31,Mục_đấu_thầu[[ ]],0),4)","v":{"v":4160000,"d":"$4,160,000.00"}}]
[null,{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A32,Mục_đấu_thầu[[ ]],0),2)","v":"gỗ 2x4x10"},{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A32,Mục_đấu_thầu[[ ]],0),4)","v":{"v":2067520,"d":"$2,067,520.00"}}]
[null,{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A33,Mục_đấu_thầu[[ ]],0),2)","v":"Dầm móc"},{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A33,Mục_đấu_thầu[[ ]],0),4)","v":{"v":1553760.0000000002,"d":"$1,553,760.00"}}]
[null,{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A34,Mục_đấu_thầu[[ ]],0),2)","v":"gỗ 2x8x10"},{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A34,Mục_đấu_thầu[[ ]],0),4)","v":{"v":702000,"d":"$702,000.00"}}]
[null,{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A35,Mục_đấu_thầu[[ ]],0),2)","v":"Găng tay, bằng da"},{"$f":"INDEX(Mục_đấu_thầu[],MATCH(A35,Mục_đấu_thầu[[ ]],0),4)","v":{"v":322400,"d":"$322,400.00"}}]