{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Bid Form","Chart Data","Cost Breakdown","Bid Cost Summary"],"not_rendered":{"charts":1,"images":2,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Bid Form","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,"Construction Bid Form"]
[null,"Owner Information",null,null,"Contractor Information"]
[null,"Name","Enter owner Name in this cell",null,"Company","Enter contractor Company name in this cell"]
[null,"Address","Enter owner Address in this cell",null,"Name","Enter contractor Name in this cell"]
[null,"City, Postcode","Enter owner City, State, and Postcode in this cell",null,"Address","Enter contractor Address in this cell"]
[null,"Phone","Enter owner Phone number in this cell",null,"City, Postcode","Enter contractor City, State, and Postcode in this cell"]
[null,"Email","Enter owner Email address in this cell",null,"Phone","Enter contractor Phone number in this cell"]
[null,"Project name","Enter Project name in this cell",null,"Email","Enter contractor Email address in this cell "]
[{"$nulls":4},"Completion date","Enter Completion date in this cell"]
[null,"Scope of Work"]
[null,"Project scope of work goes here. Type in all of the specifications you would like. \n\nSample text: This is going to be a mock project of building a large set of stairs. We will use only 2x4 and 2x8 lumber, as well as joist brackets, to construct the frame. Stairs will be cut from the 2x4 material. No less than 2\" screws will be used.  Any nails will be no less than 10 penny. Design weight shall hold a minimum of 500 pounds per step. Steps will be level with that of the house. A running board will be fastened to the house. Contractor will take care of clean up."]
[null,"Not Included"]
[null,"Project details that are not included goes here. Type in everything that is not included in this bid. \n\nSample text: No rails will be installed. Earth to be prepped by owner. Stairs to be painted by owner."]
[null,"Company Proposal"]
[null,"Company proposal goes here. Type an overview of the proposal including who is proposing the work, the expected completion date and the amount of the proposal.\n\nSample text: We, Company Name, propose the above scope of work, to be completed by Completion Date for the amount of Total Amount."]
[]
[null,"Submitted by (Company Representative)",null,null,"Date"]
[null,"Owner Acceptance"]
[null,"Owner acceptance goes here. Type in the Owner's name in a confirmation statement that includes the completion date and total amount stated in the company proposal. \n\nSample text: I, Owner Name, do accept the above scope of work, proposed to be completed by Completion Date for the amount of Total Amount."]
[]
[null,"Submitted by (home owner or authorised representative)",null,null,"Date"]

{"sheet":"Chart Data","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"hidden":true}
[]
[null,null,"Total"]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(1,BidItems[Costs Ranked],0),2)","v":"Labourer charges"},{"$f":"INDEX(BidItems[#Data],MATCH(1,BidItems[Costs Ranked],0),4)","v":200}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(2,BidItems[Costs Ranked],0),2)","v":"2x4x10 lumber"},{"$f":"INDEX(BidItems[#Data],MATCH(2,BidItems[Costs Ranked],0),4)","v":99.39999999999999}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(3,BidItems[Costs Ranked],0),2)","v":"Joist brackets"},{"$f":"INDEX(BidItems[#Data],MATCH(3,BidItems[Costs Ranked],0),4)","v":74.7}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(4,BidItems[Costs Ranked],0),2)","v":"2x8x10 lumber"},{"$f":"INDEX(BidItems[#Data],MATCH(4,BidItems[Costs Ranked],0),4)","v":33.75}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(5,BidItems[Costs Ranked],0),2)","v":"Pair of gloves, leather"},{"$f":"INDEX(BidItems[#Data],MATCH(5,BidItems[Costs Ranked],0),4)","v":15.5}]

{"sheet":"Cost Breakdown","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"merged":[[0,1,0,4],[1,1,1,4]]}
[null,"Cost Breakdown",{"$nulls":3}," "]
[null,"List of Materials and Costs"]
[null,"Qty.","Description","Cost","Total","Costs Ranked"]
[null,5,"2x8x10 lumber",{"v":6.75,"d":"£6.75"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":33.75,"d":"£33.75"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":4}]
[null,20,"2x4x10 lumber",{"v":4.97,"d":"£4.97"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":99.39999999999999,"d":"£99.40"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":2}]
[null,30,"Joist brackets",{"v":2.49,"d":"£2.49"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":74.7,"d":"£74.70"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":3}]
[null,2,"Box of screws, 2 in",{"v":6.67,"d":"£6.67"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":13.34,"d":"£13.34"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":6}]
[null,2,"Box of nails, 10 penny",{"v":3.25,"d":"£3.25"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":6.5,"d":"£6.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":7}]
[null,2,"Pair of gloves, leather",{"v":7.75,"d":"£7.75"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":15.5,"d":"£15.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":5}]
[null,2,"Labourer charges",{"v":100,"d":"£100.00"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":200,"d":"£200.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":1}]
[4,null,null,"Subtotal",{"$f":"SUBTOTAL(109,BidItems[Total])","v":{"v":443.18999999999994,"d":"£443.19"}}]
[5,null,null,"Tax rate",{"v":0.075,"d":"7.50%"}]
[{"$nulls":3},"Tax",{"$f":"IFERROR(TaxRate*BidItems[[#Totals],[Total]], \"\")","v":{"v":33.23924999999999,"d":"£33.24"}}]
[{"$nulls":3},"Grand total",{"$f":"IFERROR(Tax+BidItems[[#Totals],[Total]], \"\")","v":{"v":476.4292499999999,"d":"£476.43"}}]

{"sheet":"Bid Cost Summary","index":3,"n_rows":3,"n_cols":4,"rows_kept":3}
[null,"Bid Cost Summary"]
[null,"Breakdown of Materials and Costs",null,"Notes"]
[null,"Pie chart showing top 5 costs per material. Data is based on Bid Items table in Cost Breakdown worksheet",null,"Enter notes in this cell."]