{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":213,"n_cols":12,"rows_kept":213,"cut":false,"hidden":false,"merged":[]}
[]
["CONSTRUCTION BUDGET and PROGRESS DRAW CALCULATION"]
[]
["File Number:","number"]
["Project Name:","name"]
["Project Address:","address"]
["Category","BUDGET","Work In Place 1st Draw","Work In Place 2nd Draw","Work In Place 3rd Draw","Work In Place 4th Draw","Cost to Complete","Supplier","Date","Invoice #","Paid ","Method"]
["Set up"]
["Land",0,0,0,0,0,{"$f":"+B9-C9-D9-E9-F9","v":0}]
["Permits",0,0,0,0,0,0]
["Copies of Plans",0,0,0,0,0,0]
["Home Warranty",0,0,0,0,0,0]
["Contractor Plans",0,0,0,0,0,0]
["Survey Certificate",0,0,0,0,0,0]
["Building Insurance",0,0,0,0,0,0]
["Interior Design",0,0,0,0,0,0]
["Geo-Tech Survey",0,0,0,0,0,0]
["Engineering / Inspections / C-B",0,0,0,0,0,0]
[null,0,0,0,0,0,0]
["Hydro",0,0,0,0,0,0]
["Gas",0,0,0,0,0,0]
["Water Meter",0,0,0,0,0,0]
["Water Hook Up",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B9:B23)","v":0},0,0,0,0,0]
["Excavation"]
["Dig Hole",0,0,0,0,0,{"$f":"+B26-C26-D26-E26-F26","v":0}]
["Back Fill",0,0,0,0,0,0]
["Back Fill Slab",0,0,0,0,0,0]
["Site Grading",0,0,0,0,0,0]
["Retaining Walls",0,0,0,0,0,0]
["Sand",0,0,0,0,0,0]
["Drain Rock",0,0,0,0,0,0]
["Big O ",0,0,0,0,0,0]
["Trucking",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B26:B34)","v":0},0,0,0,0,0]
["Foundation"]
[null,0,0,0,0,0,{"$f":"+B37-C37-D37-E37-F37","v":0}]
["Footings concrete",0,0,0,0,0,0]
["Forms rentals",0,0,0,0,0,0]
["walls (concrete)",0,0,0,0,0,0]
["Drain tile and gutter drainage",0,0,0,0,0,0]
["Damp proofing",0,0,0,0,0,0]
["Basement Slab (concrete &labour)",0,0,0,0,0,0]
["Rebar ( driveway and back porch )",0,0,0,0,0,0]
["Pumper Truck",0,0,0,0,0,0]
["ROV Inspections",0,0,0,0,0,0]
[null,0,0,0,0,0,0]
["Concrete Finishing",0,0,0,0,0,0]
["Garage slab ( Concrete and Labour)",0,0,0,0,0,0]
["Pre Slab Prep",0,0,0,0,0,0]
["Labour",0,0,0,0,0,0]
["Backfilling Labour",0,0,0,0,0,0]
["Excavation Labour",0,0,0,0,0,0]
["Extra Materials",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B37:B54)","v":0},0,0,0,0,0]
["Framing"]
["Lumber package",0,0,0,0,0,{"$f":"+B57-C57-D57-E57-F57","v":0}]
["Stairs",0,0,0,0,0,0]
["Crane",0,0,0,0,0,0]
["Floor Package",0,0,0,0,0,0]
["Roof Trusses",0,0,0,0,0,0]
["Hambro",0,0,0,0,0,0]
["Labour",0,0,0,0,0,0]
[null,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B57:B64)","v":0},0,0,0,0,0]
["Roofing"]
["Material",0,0,0,0,0,{"$f":"+B67-C67-D67-E67-F67","v":0}]
["Labour",0,0,0,0,0,{"$f":"+B68-C68-D68-E68-F68","v":0}]
["TOTAL",{"$f":"SUM(B67:B68)","v":0},0,0,0,0,0]
["Insulation"]
["Material",0,0,0,0,0,{"$f":"+B71-C71-D71-E71-F71","v":0}]
["Labour",0,0,0,0,0,{"$f":"+B72-C72-D72-E72-F72","v":0}]
["TOTAL",{"$f":"SUM(B71:B72)","v":0},0,0,0,0,0]
["Exterior"]
[null,0,0,0,0,0,{"$f":"+B75-C75-D75-E75-F75","v":0}]
["front Door",0,0,0,0,0,0]
["Exterior doors",0,0,0,0,0,0]
["Doors Hardware",0,0,0,0,0,0]
["Windows",0,0,0,0,0,0]
["Garage door ",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B75:B80)","v":0},0,0,0,0,0]
["Exterior Finishing"]
[null,0,0,0,0,0,{"$f":"+B83-C83-D83-E83-F83","v":0}]
["Stucco with foam trim",0,0,0,0,0,0]
["Hardiplank",0,0,0,0,0,0]
["Vinyl Siding",0,0,0,0,0,0]
["Vinyl Decking",0,0,0,0,0,0]
["aluminium railings ( with Glass",0,0,0,0,0,0]
["masonry",0,0,0,0,0,0]
["wood trim",0,0,0,0,0,0]
["soffits",0,0,0,0,0,0]
["gutters",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B83:B92)","v":0},0,0,0,0,0]
["Paint"]
[null,0,0,0,0,0,{"$f":"+B95-C95-D95-E95-F95","v":0}]
["Interior",0,0,0,0,0,{"$f":"+B96-C96-D96-E96-F96","v":0}]
["exterior",0,0,0,0,0,{"$f":"+B97-C97-D97-E97-F97","v":0}]
["TOTAL",{"$f":"SUM(B95:B97)","v":0},0,0,0,0,0]
["Electrical"]
[null,0,0,0,0,0,{"$f":"+B100-C100-D100-E100-F100","v":0}]
["Contract",0,0,0,0,0,{"$f":"+B101-C101-D101-E101-F101","v":0}]
["Fixtures",0,0,0,0,0,{"$f":"+B102-C102-D102-E102-F102","v":0}]
["heated floor",0,0,0,0,0,{"$f":"+B103-C103-D103-E103-F103","v":0}]
["tv/speakers",0,0,0,0,0,{"$f":"+B104-C104-D104-E104-F104","v":0}]
["TOTAL",{"$f":"SUM(B100:B104)","v":0},0,0,0,0,0]
["Heating"]
[null,0,0,0,0,0,{"$f":"+B107-C107-D107-E107-F107","v":0}]
["heating system",0,0,0,0,0,0]
["gas lines",0,0,0,0,0,0]
["humidifier",0,0,0,0,0,0]
["Fireplaces",0,0,0,0,0,0]
["Contract total ",0,0,0,0,0,0]
["Air conditioning",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B107:B113)","v":0},0,0,0,0,0]
["Vacuum"]
["Labour",0,0,0,0,0,{"$f":"+B116-C116-D116-E116-F116","v":0}]
["Rough-in",0,0,0,0,0,{"$f":"+B117-C117-D117-E117-F117","v":0}]
["unit",0,0,0,0,0,{"$f":"+B118-C118-D118-E118-F118","v":0}]
["TOTAL",{"$f":"SUM(B116:B118)","v":0},0,0,0,0,0]
["Security"]
["Rough-in",0,0,0,0,0,{"$f":"+B121-C121-D121-E121-F121","v":0}]
["System",0,0,0,0,0,{"$f":"+B122-C122-D122-E122-F122","v":0}]
["TOTAL",{"$f":"SUM(B121:B122)","v":0},0,0,0,0,0]
["Drywall"]
["Contract Only",0,0,0,0,0,{"$f":"+B125-C125-D125-E125-F125","v":0}]
["boarding",0,0,0,0,0,{"$f":"+B126-C126-D126-E126-F126","v":0}]
["mudding",0,0,0,0,0,{"$f":"+B127-C127-D127-E127-F127","v":0}]
["material",0,0,0,0,0,{"$f":"+B128-C128-D128-E128-F128","v":0}]
[null,0,0,0,0,0,{"$f":"+B129-C129-D129-E129-F129","v":0}]
["TOTAL",{"$f":"SUM(B125:B129)","v":0},0,0,0,0,0]
["Plumbing"]
["Plumbing Rough In",0,0,0,0,0,{"$f":"+B132-C132-D132-E132-F132","v":0}]
["Sinks",0,0,0,0,0,0]
["Laundry Room w sink",0,0,0,0,0,0]
["Kitchen ",0,0,0,0,0,0]
["Sinks",0,0,0,0,0,0]
["Fixture",0,0,0,0,0,0]
["Bathrooms",0,0,0,0,0,0]
["Taps",0,0,0,0,0,0]
["Sinks",0,0,0,0,0,0]
["Showers",0,0,0,0,0,0]
["Tub/Shower Combo",0,0,0,0,0,0]
["Toilets",0,0,0,0,0,0]
["Tubs",0,0,0,0,0,0]
["Install",0,0,0,0,0,0]
[null,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B132:B146)","v":0},0,0,0,0,0]
["Interior Finishing"]
[null,0,0,0,0,0,{"$f":"+B149-C149-D149-E149-F149","v":0}]
["interior doors and closets",0,0,0,0,0,0]
["hardware",0,0,0,0,0,0]
["casing and baseboards",0,0,0,0,0,0]
["stairs and hand rails",0,0,0,0,0,0]
["Finishing labour",0,0,0,0,0,0]
["Cabinets",0,0,0,0,0,0]
["granite counters",0,0,0,0,0,0]
["shower doors",0,0,0,0,0,0]
["mirrors",0,0,0,0,0,0]
["appliance( range hood)",0,0,0,0,0,0]
["bath accessories",0,0,0,0,0,0]
["blinds",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B149:B161)","v":0},0,0,0,0,0]
["Flooring and Fireplace Finishing"]
[null,0,0,0,0,0,{"$f":"+B164-C164-D164-E164-F164","v":0}]
["Flooring package total",0,0,0,0,0,{"$f":"+B165-C165-D165-E165-F165","v":0}]
["Main Living / Kitchen / Main Baths ",0,0,0,0,0,{"$f":"+B166-C166-D166-E166-F166","v":0}]
["Downstairs",0,0,0,0,0,{"$f":"+B167-C167-D167-E167-F167","v":0}]
["Fireplace stone",0,0,0,0,0,{"$f":"+B168-C168-D168-E168-F168","v":0}]
["TOTAL",{"$f":"SUM(B164:B168)","v":0},0,0,0,0,0]
["Driveway and Walkway"]
[null,0,0,0,0,0,{"$f":"+B171-C171-D171-E171-F171","v":0}]
["concrete",0,0,0,0,0,{"$f":"+B172-C172-D172-E172-F172","v":0}]
["labour",0,0,0,0,0,{"$f":"+B173-C173-D173-E173-F173","v":0}]
["stamped",0,0,0,0,0,{"$f":"+B174-C174-D174-E174-F174","v":0}]
["exposed",0,0,0,0,0,{"$f":"+B175-C175-D175-E175-F175","v":0}]
["TOTAL",{"$f":"SUM(B171:B175)","v":0},0,0,0,0,0]
["Landscape"]
[null,0,0,0,0,0,{"$f":"+B178-C178-D178-E178-F178","v":0}]
["grass/shrubs/veg.",0,0,0,0,0,{"$f":"+B179-C179-D179-E179-F179","v":0}]
["irrigation",0,0,0,0,0,{"$f":"+B180-C180-D180-E180-F180","v":0}]
["rock walls",0,0,0,0,0,{"$f":"+B181-C181-D181-E181-F181","v":0}]
["TOTAL",{"$f":"SUM(B178:B181)","v":0},0,0,0,0,0]
["Financing"]
["Lender/Broker Fees",0,0,0,0,0,{"$f":"+B184-C184-D184-E184-F184","v":0}]
["Interest During Construction",0,0,0,0,0,0]
["Standby Fees on Unadvanced Funds",0,0,0,0,0,0]
["Progress Inspections",0,0,0,0,0,0]
["Legal",0,0,0,0,0,0]
["Property Taxes",0,0,0,0,0,0]
["Title Insurance",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B184:B190)","v":0},0,0,0,0,0]
["Misc."]
["garbage removal",0,0,0,0,0,{"$f":"+B193-C193-D193-E193-F193","v":0}]
["Rentals",0,0,0,0,0,0]
["Generator",0,0,0,0,0,0]
["Project Management",0,0,0,0,0,0]
["Water Test",0,0,0,0,0,0]
["Set Back Applications",0,0,0,0,0,0]
["Driveway Removal",0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B193:B199)","v":0},0,0,0,0,0]
["OVERALL TOTAL",{"$f":"SUM(B24+B35+B55+B65+B69+B73+B81+B93+B98+B105+B114+B119+B123+B130+B147+B162+B169+B176+B182+B191+B200)","v":0},0,0,0,0,0]
[]
[]
[]
["Purchase Price:"]
["Expected Start:"]
["Expected Competiion:"]
[]
[]
["Approved Loan Amount",0]
["Less:  Cost to Complete",{"$f":"+G201","v":0}]
["Less:  Previous Advances",0]
["Net Advanced Authorized:",{"$f":"+B210-B211-B212","v":0}]

{"sheet":"Sheet2","index":1,"n_rows":184,"n_cols":6,"rows_kept":184,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"BUILDING BUDGET"]
[]
["839 Clarance"]
["Set up",null,"COSTS EST","QUOTES","FINAL COST","SUPPLIER"]
[null,"Land"]
[null,"permits",2000,2100,2739]
[null,"warranty",2100,2200,2200]
[null,"plans",2150,2150,2150]
[null,"survey certificate",1100,1100]
[null,"building insurance",1000,1200]
[null,"interior design",0]
[null,"geo",500]
[null,"engineering",900,900]
[null,"utilities Hydro , gas , water",1200]
["Excavation"]
[]
[null,"dig hole"]
[null,"back fill"]
[null,"back fill slab"]
[null,"site grading"]
[null,"total",8000,8000]
[null,"retaining walls"]
["Foundation"]
[]
[null,"Footings concrete",1400,1327]
[null,"Forms rentals",2000,1700]
[null,"walls (concrete)",3300,4000]
[null,"Drain tile",500]
[null,"Damp proofing",900]
[null,"Basement Slab (concrete &labour)",3500,3188]
[null,"Rebar ( driveway and back porch )",900]
[null,"Pumper Truck",1200]
[null,"Garage slab ( Concrete and Labour)",1300,1167]
[null,"Labour",7000,0]
[]
["Framing"]
[]
[null,"Lumber package",12000,10761]
[null,"Floor Package",5000,7000]
[null,"Trusses",5500,7500]
[null,"Labour",16000,25000]
[]
[]
["Roofing"]
[]
[null,"Material and Labour",7500]
[]
["Insulation"]
[]
[null,"Insulation and Labour",8000,7000]
[]
["Exterior"]
[]
[null,"front Door",2000,2000]
[null,"Exterior doors",1000,2493.09]
[null,"Doors Hardware",1200]
["home hardware","Windows",10000,7393.5]
[null,"Garage door ",2400]
[]
["Exterior Finishing"]
[]
[null,"Stucco with foam trim",25000,24000]
[null,"Hardiplank"]
[null,"Vinyl Siding"]
["Sundeck Centre","Vinyl Decking",1800,1348]
[null,"aluminium railings ( with Glass",1800,1392]
[null,"masonry",10000]
[null,"wood trim"]
[null,"soffits",2000]
[null,"gutters",2000]
[]
["Paint"]
[]
[null,"Interior",8250]
[null,"exterior"]
[]
["Electrical"]
[]
[null,"Contract",15000,13500]
[null,"Fixtures",2500]
[null,"heated floor",650]
[null,"speakers"]
["Heating "]
[]
[null,"heating system",15000,12000]
[null,"gas lines"]
[null,"humidifier",0]
[null,"Fireplaces"]
[null,"Contract total "]
[null,"Air conditioning",0,2770]
[]
["Vacuum"]
[]
[null,"Rough-in",700]
[null,"unit",900]
[]
["Security"]
[]
[null,"Rough in and system",800]
[]
["Drywall"]
[]
[null,"boarding"]
[null,"mudding"]
[null,"material"]
[null,"Contract Total",25000,23501]
[]
["Plumbing"]
[]
[null,"Plumbing package",15000,13872]
[null,"Includes"]
[null,"taps"]
[null,"sinks"]
[null,"showers"]
[null,"installation"]
[]
["Interior finishing"]
[]
[null,"interior doors and closets",2500,2284]
[null,"hardware",500,1039]
[null,"casing and baseboards",1800,1395]
[null,"stairs and hand rails",2000]
[null,"Finishing labour",6000]
[null,"Cabinets",25000,24000]
[null,"granite counters",10000,10000]
[null,"shower doors",1200,2400]
[null,"mirrors",1000,600]
[null,"appliance( range hood)",1000]
[null,"bath accessories",500]
[null,"blinds"]
["Flooring and fireplace finishing"]
[]
[null,"Flooring package total",20000]
[null,"carpet"]
[null,"hardwood"]
[null,"tile"]
[null,"Fireplace stone",2000]
[]
["driveway and walkway"]
[]
[null,"concrete",5000]
[null,"labour"]
[null,"stamped"]
[null,"exposed"]
[]
["Landscaping"]
[]
[null,"grass"]
[null,"irrigation"]
[null,"rock walls"]
[null,"shrubs plants tree's"]
[null,"total",10000,10000]
[]
["Miscellaneous"]
[]
[null,"rentals",1000]
[]
[null,"TOTAL",{"$f":"SUM(C6:C158)","v":327450},{"$f":"SUM(D6:D158)","v":242280.59}]
[]
["Soft costs"]
[null,"legals and appraisals",2000]
[null,"real estate fee",25000]
[null,"interest reserve",32000]
[null,"standby fees",2000]
[null,"application fee",2400]
[null,"lender/broker fees",2250]
[null,"Total",{"$f":"SUM(C162:C167)","v":65650}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Land cost",209000]
["House Cost","cost of cunstruction",327450]
["land","total",{"$f":"SUM(C177:C178)","v":536450}]
[]
[null,"Selling price",685000]
[null,"total project cost",536450]
[null,"soft costs",63650]
[null,"total ",{"$f":"C181-C182-C183","v":84900}]