{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["投标书","图表数据","成本分析","投标成本摘要"],"not_rendered":{"charts":1,"images":2,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"投标书","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"merged":[[0,1,0,4],[1,1,1,2],[1,4,1,5],[7,1,8,1],[7,2,8,2],[10,1,10,5],[12,1,12,5],[14,1,14,5],[15,1,15,2],[15,4,15,5],[16,1,16,2],[16,4,16,5],[18,1,18,5],[19,1,19,2],[19,4,19,5],[20,1,20,2],[20,4,20,5]]}
[null,"施工投标书"]
[null,"业主信息",null,null,"承包商信息"]
[null,"姓名","在此单元格中输入业主姓名",null,"公司","在此单元格中输入承包商公司名称"]
[null,"地址","在此单元格中输入业主地址",null,"姓名","在此单元格中输入承包商名称"]
[null,"州/省/自治区、城市及邮政编码","在此单元格输入业主所在省/市/自治区、市/县和邮政编码",null,"地址","在此单元格中输入承包商地址"]
[null,"电话","在此单元格中输入业主电话号码",null,"州/省/自治区、城市及邮政编码","在此单元格中输入承包商所在省/市/自治区、市/县和邮政编码"]
[null,"电子邮件","在此单元格中输入业主电子邮件地址",null,"电话","在此单元格中输入承包商电话号码"]
[null,"项目名称","在此单元格中输入项目名称",null,"电子邮件","在此单元格中输入承包商电子邮件地址 "]
[{"$nulls":4},"竣工日期","在此单元格中输入竣工日期"]
[null,"工程任务范围"]
[null,"在此处输入工程任务范围。你可随意键入所有规范。\n\n示例文字：这将是一个建造大量楼梯的模拟项目。我们将仅使用 2x4 和 2x8 木材以及搁栅支架来建造框架。将从 2x4 材料中切割出楼梯。将使用不小于 2\" 的螺钉。任何钉子将不小于 10 便士尺寸。设计重量将为每级阶梯最少承重 500 磅。阶梯将与房屋阶梯处于同一水平线。踏脚板将固定在房屋上。施工方将负责清扫。"]
[null,"未包括"]
[null,"在此处输入未包括的项目详细信息。键入此投标中未包括的所有内容。\n\n示例文字：将不安装扶手。地面整备工作由业主负责。楼梯油漆工作由业主负责。"]
[null,"公司方案"]
[null,"在此处输入公司方案。键入方案的概述，包括提出工作方案的人员、预计竣工日期以及方案金额。\n\n示例文字：我方（公司名称）提出上述项目任务范围方案，预计竣工日期为“竣工日期”，金额为“总金额”。"]
[]
[null,"提交人（公司代表）",null,null,"日期"]
[null,"业主验收"]
[null,"在此处输入业主验收。在包括公司方案中阐明的竣工日期和总金额的确认声明中键入业主的姓名。\n\n示例文字：我（业主姓名）确认接受上述项目任务范围，即竣工日期为“竣工日期”、金额为“总金额”的方案。"]
[]
[null,"提交人（房屋业主或授权代表）",null,null,"日期"]

{"sheet":"图表数据","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"hidden":true}
[]
[null,null,"总计"]
[null,{"$f":"INDEX(投标项目[#Data],MATCH(1,投标项目[经过排名的成本],0),2)","v":"人工费用"},{"$f":"INDEX(投标项目[#Data],MATCH(1,投标项目[经过排名的成本],0),4)","v":200}]
[null,{"$f":"INDEX(投标项目[#Data],MATCH(2,投标项目[经过排名的成本],0),2)","v":"2 x 4 x 10 木材"},{"$f":"INDEX(投标项目[#Data],MATCH(2,投标项目[经过排名的成本],0),4)","v":99.39999999999999}]
[null,{"$f":"INDEX(投标项目[#Data],MATCH(3,投标项目[经过排名的成本],0),2)","v":"搁栅支架"},{"$f":"INDEX(投标项目[#Data],MATCH(3,投标项目[经过排名的成本],0),4)","v":74.7}]
[null,{"$f":"INDEX(投标项目[#Data],MATCH(4,投标项目[经过排名的成本],0),2)","v":"2 x 8 x 10 木材"},{"$f":"INDEX(投标项目[#Data],MATCH(4,投标项目[经过排名的成本],0),4)","v":33.75}]
[null,{"$f":"INDEX(投标项目[#Data],MATCH(5,投标项目[经过排名的成本],0),2)","v":"一双手套（皮革）"},{"$f":"INDEX(投标项目[#Data],MATCH(5,投标项目[经过排名的成本],0),4)","v":15.5}]

{"sheet":"成本分析","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"成本分析",{"$nulls":3}," "]
[null,"材料和成本清单"]
[null,"数量","说明","成本","总计","经过排名的成本"]
[null,5,"2 x 8 x 10 木材",{"v":6.75,"d":"¥6.75"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":33.75,"d":"¥33.75"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":4}]
[null,20,"2 x 4 x 10 木材",{"v":4.97,"d":"¥4.97"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":99.39999999999999,"d":"¥99.40"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":2}]
[null,30,"搁栅支架",{"v":2.49,"d":"¥2.49"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":74.7,"d":"¥74.70"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":3}]
[null,2,"数箱螺钉（ 2 英寸）",{"v":6.67,"d":"¥6.67"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":13.34,"d":"¥13.34"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":6}]
[null,2,"数箱钉子（10 便士尺寸）",{"v":3.25,"d":"¥3.25"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":6.5,"d":"¥6.50"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":7}]
[null,2,"一双手套（皮革）",{"v":7.75,"d":"¥7.75"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":15.5,"d":"¥15.50"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":5}]
[null,2,"人工费用",{"v":100,"d":"¥100.00"},{"$f":"IFERROR(投标项目[[#This Row],[成本]]*投标项目[[#This Row],[数量]], \"\")","v":{"v":200,"d":"¥200.00"}},{"$f":"_xlfn.RANK.EQ(投标项目[[#This Row],[总计]],投标项目[总计])","v":1}]
[{"$nulls":3},"小计",{"$f":"SUBTOTAL(109,投标项目[总计])","v":{"v":443.18999999999994,"d":"¥443.19"}}]
[{"$nulls":3},"税率",{"v":0.075,"d":"7.50%"}]
[{"$nulls":3},"税费",{"$f":"IFERROR(税率*投标项目[[#Totals],[总计]], \"\")","v":{"v":33.23924999999999,"d":"¥33.24"}}]
[{"$nulls":3},"汇总",{"$f":"IFERROR(税费+投标项目[[#Totals],[总计]], \"\")","v":{"v":476.4292499999999,"d":"¥476.43"}}]

{"sheet":"投标成本摘要","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"merged":[[1,1,1,2],[2,1,2,2]]}
[null,"投标成本摘要"]
[null,"材料和成本细目",null,"备注"]
[null,"显示每种材料排名前 5 的成本的饼图。数据基于“成本分析”工作表中的“投标项目”表格",null,"在此单元格中输入备注。"]