{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Bid form","Chart Data","Cost breakdown","Bid cost summary"],"not_rendered":{"charts":1,"images":1,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Bid form","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"merged":[[1,1,1,4],[2,1,2,2],[8,1,9,1],[8,2,9,2],[13,1,13,5],[16,1,16,5],[19,1,19,5],[20,1,20,2],[20,4,20,5],[21,1,21,2],[21,4,21,5],[25,1,25,5],[26,1,26,2],[26,4,26,5],[27,1,27,2],[27,4,27,5]]}
[]
[null,"Construction bid form"]
[null,"Owner information",null,null,"Contractor information"]
[null,"Name","Madeleine Brunelle",null,"Company","Kramer-Correia Construction"]
[null,"Address","89 Pacific Ave",null,"Name","Kayla Lewis"]
[null,"City, State ZIP","San Francisco, CA 65432",null,"Address","210 Stars Avenue"]
[null,"Phone","217-555-0127",null,"City, State ZIP","Berkeley, CA 45678"]
[null,"Email","madeleine@example.com",null,"Phone","339-555-0139"]
[null,"Project name","Full-home renovation",null,"Email","kramer-correia@example.com"]
[{"$nulls":4},"Completion date","06/01/XX"]
[]
[null,"Scope of work"]
[]
[null,"This home renovation project is to transform owner's traditional Victorian house into a modern living space while preserving its historic charm. The scope of work includes updating kitchen/bathrooms fixtures, appliances, and finishes that reflect contemporary design trends. Replacing the roof to ensure home is safe and secure.\n\nGoal of this renovation is to create functional and comfortable living spaces that meet the needs of modern homeowners, while  preserving its unique Victorian features. Team will work closely with homeowners to ensure renovation meets their specific needs and preferences, while complying with San Francisco's building codes and regulations."]
[null,"Not included"]
[]
[null,"No new plumbing will be installed. Painting will be done by owner."]
[null,"Company proposal"]
[]
[null,"We estimate that the project will take approximately 12 weeks to complete, depending on the specific needs of the renovation. Our team will work closely with you throughout the process to ensure that the renovation is completed on time and within budget.\n\nOur estimated budget for the renovation project is $48,000.00, which includes all labor, materials, and necessary permits. We will provide a detailed breakdown of the costs and work closely with you to ensure that the project stays within budget."]
[]
[null,"Submitted by Kayla Lewis",null,null,"Date"]
[]
[null,"Owner acceptance"]
[]
[null,"I, Madeleine Brunelle, accept the above scope of work, proposed to be completed by 6/1/XX for the amount of $48,000.00."]
[]
[null,"Submitted by Madeleine Brunelle",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":"Laborer charges"},{"$f":"INDEX(BidItems[#Data],MATCH(1,BidItems[Costs Ranked],0),4)","v":31000}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(2,BidItems[Costs Ranked],0),2)","v":"2x8x10 lumber"},{"$f":"INDEX(BidItems[#Data],MATCH(2,BidItems[Costs Ranked],0),4)","v":4725}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(3,BidItems[Costs Ranked],0),2)","v":"2x4x10 lumber"},{"$f":"INDEX(BidItems[#Data],MATCH(3,BidItems[Costs Ranked],0),4)","v":3404.45}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(4,BidItems[Costs Ranked],0),2)","v":"Box of screws, 2 in"},{"$f":"INDEX(BidItems[#Data],MATCH(4,BidItems[Costs Ranked],0),4)","v":2234.45}]
[null,{"$f":"INDEX(BidItems[#Data],MATCH(5,BidItems[Costs Ranked],0),2)","v":"Joist brackets"},{"$f":"INDEX(BidItems[#Data],MATCH(5,BidItems[Costs Ranked],0),4)","v":1249.98}]

{"sheet":"Cost breakdown","index":2,"n_rows":15,"n_cols":6,"rows_kept":15,"merged":[[1,1,1,4]]}
[]
[null,"Cost breakdown",{"$nulls":3}," "]
[null,"List of materials and costs"]
[null,"Qty.","Description","Cost","Total","Costs Ranked"]
[null,{"v":700,"d":"700 "},"2x8x10 lumber",{"v":6.75,"d":"$6.75"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":4725,"d":"$4,725.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":2}]
[null,{"v":685,"d":"685 "},"2x4x10 lumber",{"v":4.97,"d":"$4.97"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":3404.45,"d":"$3,404.45"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":3}]
[null,{"v":502,"d":"502 "},"Joist brackets",{"v":2.49,"d":"$2.49"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":1249.98,"d":"$1,249.98"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":5}]
[null,{"v":335,"d":"335 "},"Box of screws, 2 in",{"v":6.67,"d":"$6.67"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":2234.45,"d":"$2,234.45"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":4}]
[null,{"v":250,"d":"250 "},"Box of nails, 10 penny",{"v":3.25,"d":"$3.25"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":812.5,"d":"$812.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":7}]
[null,{"v":110,"d":"110 "},"Pair of gloves, leather",{"v":7.75,"d":"$7.75"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":852.5,"d":"$852.50"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":6}]
[null,{"v":310,"d":"310 "},"Laborer charges",{"v":100,"d":"$100.00"},{"$f":"IFERROR(BidItems[[#This Row],[Cost]]*BidItems[[#This Row],[Qty.]], \"\")","v":{"v":31000,"d":"$31,000.00"}},{"$f":"_xlfn.RANK.EQ(BidItems[[#This Row],[Total]],BidItems[Total])","v":1}]
[4,null,null,"Subtotal",{"$f":"SUBTOTAL(109,BidItems[Total])","v":{"v":44278.880000000005,"d":"$44,278.88"}}]
[5,null,null,"Tax rate",{"v":0.075,"d":"7.50%"}]
[{"$nulls":3},"Tax",{"$f":"IFERROR(TaxRate*BidItems[[#Totals],[Total]], \"\")","v":{"v":3320.916,"d":"$3,320.92"}}]
[{"$nulls":3},"Grand total",{"$f":"IFERROR(Tax+BidItems[[#Totals],[Total]], \"\")","v":{"v":47599.796,"d":"$47,599.80"}}]

{"sheet":"Bid cost summary","index":3,"n_rows":5,"n_cols":4,"rows_kept":5}
[]
[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,"Labor charges are $100/hour not including OT"]