{"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],[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範例文字:I，擁有者名稱，接受上述工作範圍，建議在完成日期前完成總金額。"]
[]
[null,"提交者 (住宅擁有者或授權代表)",null,null,"日期"]

{"sheet":"圖表資料","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"hidden":true}
[]
[null,null,"總計"]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(1,BidItems[成本排名],0),2)","v":"人力費用"},{"$f":"INDEX(BidItems[#Data],MATCH(1,BidItems[成本排名],0),4)","v":200}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(2,BidItems[成本排名],0),2)","v":"2x4x10 木材"},{"$f":"INDEX(BidItems[#Data],MATCH(2,BidItems[成本排名],0),4)","v":99.39999999999999}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(3,BidItems[成本排名],0),2)","v":"托樑支架"},{"$f":"INDEX(BidItems[#Data],MATCH(3,BidItems[成本排名],0),4)","v":74.7}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(4,BidItems[成本排名],0),2)","v":"2x8x10 木材"},{"$f":"INDEX(BidItems[#Data],MATCH(4,BidItems[成本排名],0),4)","v":33.75}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(5,BidItems[成本排名],0),2)","v":"一副手套，皮革"},{"$f":"INDEX(BidItems[#Data],MATCH(5,BidItems[成本排名],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,"2x8x10 木材",{"v":6.75,"d":"NT$6.75"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":33.75,"d":"NT$33.75"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":4}]
[null,20,"2x4x10 木材",{"v":4.97,"d":"NT$4.97"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":99.39999999999999,"d":"NT$99.40"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":2}]
[null,30,"托樑支架",{"v":2.49,"d":"NT$2.49"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":74.7,"d":"NT$74.70"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":3}]
[null,2,"螺絲盒，2 吋",{"v":6.67,"d":"NT$6.67"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":13.34,"d":"NT$13.34"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":6}]
[null,2,"一盒釘子，10 分錢",{"v":3.25,"d":"NT$3.25"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":6.5,"d":"NT$6.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":7}]
[null,2,"一副手套，皮革",{"v":7.75,"d":"NT$7.75"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":15.5,"d":"NT$15.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":5}]
[null,2,"人力費用",{"v":100,"d":"NT$100.00"},{"$f":"IFERROR(BidItems[[#This Row],[成本]]*BidItems[[#This Row],[數量]], \"\")","v":{"v":200,"d":"NT$200.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[總計]],BidItems[總計])","v":1}]
[4,null,null,"小計",{"$f":"SUBTOTAL(109,BidItems[總計])","v":{"v":443.18999999999994,"d":"NT$443.19"}}]
[5,null,null,"稅率",{"v":0.075,"d":"7.50%"}]
[{"$nulls":3},"稅",{"$f":"IFERROR(稅率*BidItems[[#Totals],[總計]], \"\")","v":{"v":33.23924999999999,"d":"NT$33.24"}}]
[{"$nulls":3},"總計",{"$f":"IFERROR(稅+BidItems[[#Totals],[總計]], \"\")","v":{"v":476.4292499999999,"d":"NT$476.43"}}]

{"sheet":"報價成本摘要","index":3,"n_rows":3,"n_cols":4,"rows_kept":3}
[null,"報價成本摘要"]
[null,"材料與成本明細",null,"備註"]
[null,"顯示每個材質前 5 個成本的圓形圖。資料是以成本明細工作表中的報價專案表格為基礎",null,"在此儲存格輸入記事。"]