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

{"sheet":"Bid Form","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,"CONSTRUCTION BID FORM",{"$nulls":4}," "]
[]
[]
[null,"OWNER INFORMATION",null,null,"CONTRACTOR INFORMATION"]
[null,"Name","Michael Tucker",null,"Company","Fabrikam, Inc."]
[null,"Address","123 Main St",null,"Name","John Kane"]
[null,"City, State ZIP","Greenville, CO 12345",null,"Address","321 South St"]
[null,"Phone",8885550111,null,"City, State ZIP","Greenville, CO 12345"]
[null,"Email","michael@proseware.com",null,"Phone",8885550123]
[{"$nulls":4},"Email","john@fabrikam.com"]
[null,"Project name","Stairway to business",null,"Completion date","2013-07-14"]
[]
[null,"SCOPE OF WORK"]
[]
[null,"Project scope of work goes here. Type in all of the specifications you would like. 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."]
{"$rows_empty":11}
[null,"NOT INCLUDED"]
[]
[null,"No rails will be installed. Ground to be prepped by owner. Stairs to be painted by owner."]
[]
[]
[]
[null,"COMPANY PROPOSAL"]
[]
[null,"We, Fabrikam, Inc., propose the above scope of work, to be completed by 7/14/2011 for the amount of $476.43."]
[]
[]
[]
[null,"Submitted by (Company Representative)",{"$nulls":3},"Date"]
[]
[null,"OWNER ACCEPTANCE"]
[]
[null,"I, Michael Tucker, do accept the above scope of work, proposed to be completed by 7/14/2011 for the amount of $476.43."]
[]
[]
[]
[null,"Submitted by (home owner or authorized representative)",{"$nulls":3},"Date"]

{"sheet":"Cost Breakdown","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,"BID COST SUMMARY",{"$nulls":3}," "]
[]
[]
[null,"LIST OF MATERIALS AND COSTS"]
[]
[null,"Qty.","Description","Cost","Total"," "]
[null,5,"2x8x10 lumber",{"v":6.75,"d":"$6.75"},{"$f":"BidItems[Cost]*BidItems[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":"BidItems[Cost]*BidItems[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":"BidItems[Cost]*BidItems[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":"BidItems[Cost]*BidItems[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":"BidItems[Cost]*BidItems[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":"BidItems[Cost]*BidItems[Qty.]","v":{"v":15.5,"d":"$15.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":5}]
[null,2,"Laborer charges",{"v":100,"d":"$100.00"},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":{"v":200,"d":"$200.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":1}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[{"$nulls":4},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[1,{"$nulls":3},{"$f":"BidItems[Cost]*BidItems[Qty.]","v":0},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":8}]
[2,null,null,"Subtotal",{"$f":"SUBTOTAL(109,BidItems[Total])","v":{"v":443.18999999999994,"d":"$443.19"}}]
[3,null,null,"Tax rate",{"v":0.075,"d":"7.50%"}]
[4,null,null,"Tax",{"$f":"TaxRate*BidItems[[#Totals],[Total]]","v":{"v":33.23924999999999,"d":"$33.24"}}]
[5,null,null,"Grand total",{"$f":"Tax+BidItems[[#Totals],[Total]]","v":{"v":476.4292499999999,"d":"$476.43"}}]
[]
[]
[]
[null,"BREAKDOWN OF MATERIALS AND COSTS"]
[]
[]
[null,null,"TOTAL","NOTES"]
[null,{"$f":"INDEX(BidItems[],MATCH(A31,BidItems[[ ]],0),2)","v":"Laborer charges"},{"$f":"INDEX(BidItems[],MATCH(A31,BidItems[[ ]],0),4)","v":{"v":200,"d":"$200.00"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A32,BidItems[[ ]],0),2)","v":"2x4x10 lumber"},{"$f":"INDEX(BidItems[],MATCH(A32,BidItems[[ ]],0),4)","v":{"v":99.39999999999999,"d":"$99.40"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A33,BidItems[[ ]],0),2)","v":"Joist brackets"},{"$f":"INDEX(BidItems[],MATCH(A33,BidItems[[ ]],0),4)","v":{"v":74.7,"d":"$74.70"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A34,BidItems[[ ]],0),2)","v":"2x8x10 lumber"},{"$f":"INDEX(BidItems[],MATCH(A34,BidItems[[ ]],0),4)","v":{"v":33.75,"d":"$33.75"}}]
[null,{"$f":"INDEX(BidItems[],MATCH(A35,BidItems[[ ]],0),2)","v":"Pair of gloves, leather"},{"$f":"INDEX(BidItems[],MATCH(A35,BidItems[[ ]],0),4)","v":{"v":15.5,"d":"$15.50"}}]