{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Template","AppData","Lists","Job Notes","Property Description","General Conditions","Utilities","Foundation","AppLists","Landscape","Exterior","Interior","Other Structures","Materials","Labor","Trade Summary","Report Summary","16D","Line Items","Line Items Template"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":13,"comments":3,"pivot_tables":2},"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":"Template","index":0,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[[1,2,3,12]]}
[]
[null,null,"Property Description Page"]

{"sheet":"AppData","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Lists","index":2,"n_rows":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":false,"merged":[[70,11,70,12],[71,11,79,12],[81,11,81,12],[70,8,70,9],[71,8,79,9],[81,8,81,9],[1,2,3,17],[16,8,16,9],[16,11,16,12],[16,3,16,4],[16,14,16,15],[6,6,14,6],[5,3,5,4],[5,8,5,9],[5,11,5,12],[5,14,5,15],[6,3,14,4],[6,8,14,9],[6,11,14,12],[6,14,14,15]]}
[]
[null,null,"List"]
[]
[]
[]
[null,null,null,"Report Instructions",null,null,"Select Trades For Your Job Instructions",null,"Exterior Options Instructions",null,null,"Interior Options Instructions",null,null,"Measurements Instructions"]
[null,null,null,"Use the list below to choose which reports you will be exporting to a PDF document. By entering an 'x' in the \"Include in Print\" column next to the report will it add that specific worksheet to the report.  \n\nPlease scroll down to see landscape and other structures lists.",null,null,"Use the list below to add trades for your project.  If you don't see your trade on the list below, simply add the trade and it will populate on the drop down lists on the following worksheets.",null,"Use the list below to add exterior categories for your \"Exterior\" worksheet options.  Items listed below will populate in the drop down menus on the \"Exterior\" worksheet.",null,null,"Use the list below to set up your interior categories for your \"Interior\" worksheet options.  Items listed below will populate in the drop down menus on the \"Interior\" worksheet.",null,null,"Use the list below to set up all your units of measurement.  Any units of measurement listed below will populate on the drop down menu on any estimating worksheets."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Select Workshets For Report",null,null,"Select Trades For Your Job",null,"Exterior Options",null,null,"Interior Options",null,null,"Measurements"]
[null,null,null,"Worksheet Name","Include In Print",null,"Trades",null,"Section","Sub Category",null,"Section","Sub Category",null,"Unit measurements:","Abrv"]
[null,null,null,"Lists",null,null,"General Conditions",null,"Decks",null,null,"Master Bath","Ceilings",null,"Square Feet - SF","SF"]
[null,null,null,"Property Description","X",null,"Demolition and Site Work",null,"Floor Framing",null,null,"Master Bath","Walls",null,"Cubic Yards - CY","CY"]
[null,null,null,"General Conditions","X",null,"Concrete/Masonry",null,"Garage","Ceiling",null,"Master Bath","Finish Carpentry",null,"Linear Feet - LF","LF"]
[null,null,null,"Utilities","X",null,"Rough Carpentry",null,"Garage","Walls",null,"Master Bath","Doors/Windows/Trim",null,"Day - Da","DA"]
[null,null,null,"Foundation","X",null,"Finish Carpentry",null,"Garage","Finish Carpentry",null,"Master Bath","Floor Covering",null,"Each - Ea","EA"]
[null,null,null,"AppLists","X",null,"Doors and Windows",null,"Garage","Doors/Windows/Trim",null,"Master Bath","Electrical",null,"Month - Mo","MO"]
[null,null,null,"Exterior","X",null,"Drywall and Paint",null,"Garage","Plumbing/HVAC",null,"Master Bath","Plumbing",null,"Square Yard - SY","SY"]
[null,null,null,"Interior","X",null,"Insulation",null,"Garage","Electrical",null,"Master Bath","Cabinetry/Countertops",null,"Week - Wk","WK"]
[null,null,null,"Exterior Structures","X",null,"Flooring",null,"Insulation",null,null,"Entry","Ceilings",null,"Sheet - Sh","SH"]
[null,null,null,"Materials","X",null,"Bathrooms",null,"Landscape",null,null,"Entry","Walls"]
[null,null,null,"Labor","x",null,"Kitchen and Appliances",null,"Main Level Framing",null,null,"Entry","Finish Carpentry"]
[null,null,null,"Trade Summary","x",null,"HVAC",null,"Patios/Walkways",null,null,"Entry","Doors/Windows/Trim"]
[null,null,null,"16D","x",null,"Plumbing - Includes septic and well",null,"Roof",null,null,"Entry","Floor Covering"]
[null,null,null,"Report Summary","x",null,"Electrical",null,"Roof Framing",null,null,"Entry","Finish Electrical"]
[null,null,null,"Line Items",null,null,"Roofing",null,"Siding",null,null,"Kitchen","Ceilings"]
[null,null,null,"Landscape","x",null,"Landscape and Fencing - Includes any pool, fountain and irrigation work.",null,null,null,null,"Kitchen","Walls"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Finish Carpentry"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Doors/Windows/Trim"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Floor Covering"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Electrical"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Plumbing"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Cabinetry/Countertops"]
[null,null,null,null,null,null,null,null,null,null,null,"Kitchen","Appliances"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom1","Ceilings"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom1","Walls"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom1","Finish Carpentry"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom1","Doors/Windows/Trim"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom1","Floor Covering"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom1","Electrical"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom2","Ceilings"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom2","Walls"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom2","Finish Carpentry"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom2","Doors/Windows/Trim"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom2","Floor Covering"]
[null,null,null,null,null,null,null,null,null,null,null,"Bedroom2","Electrical"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Landscape Instructions",null,null,"Other Structures Instructions"]
[null,null,null,null,null,null,null,null,"Use the list below to set up all your landscape options.  Any item listed here will populate on the drop down under the \"Landscape\" worksheet.  ",null,null,"Use the list below to set up all your other structures categories.  Any items listed here will populate on the drop down under \"Other Structures.\" Other structures is anything not physically attached the the main home.  Any detached garage, additional dwelling unit, pool house, etc. should be listed in this worksheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Landscape Options",null,null,"Other Structures Options"]
[null,null,null,null,null,null,null,null,"Section","Sub Category",null,"Section","Sub Category"]
[null,null,null,null,null,null,null,null,"Landscape 1","Sub Land 1",null,"Additional Dwelling Unit","Ceilings"]
[null,null,null,null,null,null,null,null,"Landscape 1","Sub Land 2",null,"Additional Dwelling Unit","Walls"]
[null,null,null,null,null,null,null,null,"Landscape 1","Sub Land 3",null,"Additional Dwelling Unit","Flooring"]
[null,null,null,null,null,null,null,null,"Landscape 2","Sub Land 4",null,"Additional Dwelling Unit","Doors/Windows/Trim"]
[null,null,null,null,null,null,null,null,"Landscape 2","Sub Land 5",null,"Detached Garage","Doors/Windows/Trim"]
[null,null,null,null,null,null,null,null,"Landscape 2","Sub Land 6",null,"Detached Garage","Electrical"]
[null,null,null,null,null,null,null,null,"Landscape 3","Sub Land 7",null,"Detached Garage","Plumbing"]
[null,null,null,null,null,null,null,null,"Landscape 3","Sub Land 8",null,"Shed","Tool"]
[null,null,null,null,null,null,null,null,"Landscape 3","Sub Land 9",null,"Shed","Storage"]
[null,null,null,null,null,null,null,null,"Landscape 4","Sub Land 10",null,"Shed"]
[null,null,null,null,null,null,null,null,"Landscape 4","Sub Land 11",null,"Shed"]
[null,null,null,null,null,null,null,null,"Landscape 4","Sub Land 12"]
[null,null,null,null,null,null,null,null,"Landscape 5","Sub Land 13"]
[null,null,null,null,null,null,null,null,"Landscape 5","Sub Land 14"]
[null,null,null,null,null,null,null,null,"Landscape 5","Sub Land 15"]

{"sheet":"Job Notes","index":3,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,3,71,4],[16,14,16,15],[1,2,3,17],[5,3,5,4],[38,3,38,4],[49,3,49,4],[6,3,14,4],[39,3,47,4],[17,3,25,4],[28,3,36,4],[16,3,16,4],[27,3,27,4],[60,3,60,4],[50,3,58,4],[61,3,69,4]]}
[]
[null,null,"Images and Notes"]
[]
[]
[]
[null,null,null,"Report Notes"]
[null,null,null,null,null,null,"Press \"Add Image\".  Select  .png, .jpg, .gif, or .tif image file.  Image will be added to the spreadsheet below lowest image.  Images can be moved and deleted as necessary."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Landscape Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Other Structures Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Exterior Options Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Interior Options Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Measurements Notes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Other Notes"]

{"sheet":"Property Description","index":4,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,2,3,8],[5,3,5,7],[24,3,24,7],[28,3,47,7],[48,3,48,7],[49,3,49,7],[50,3,50,7],[51,3,51,7],[52,3,52,7],[53,3,53,7],[54,3,54,7],[55,3,55,7],[56,3,56,7],[57,3,57,7],[58,3,58,7],[59,3,59,7],[60,3,60,7],[61,3,61,7],[62,3,62,7],[63,3,63,7],[64,3,64,7],[70,3,70,7],[71,3,71,7],[65,3,65,7],[66,3,66,7],[67,3,67,7],[68,3,68,7],[69,3,69,7]]}
[]
[null,null,"         BW Estimator"]
[]
[]
[]
[null,null,null,"Property Description Page"]
[]
[null,null,null,"Property Owner Name:","Bruce Wayne",null,"Phone:","111-111-1111"]
[]
[null,null,null,"Street Address:","1234 Main Street",null,"Email:","joediddit@joediddit.com"]
[]
[null,null,null,"City/State/Zip:","Maintown"]
[]
[null,null,null,"Estimator:","BW"]
[]
[null,null,null,"Type of Estimate:","New Construction"]
[]
[null,null,null,"Local Sales Tax Rate:",0.09]
[]
[null,null,null,"Overhead",0.1]
[]
[null,null,null,"Profit",0.1]
[]
[]
[null,null,null,"BW Builder, Inc."]
[]
[]
[null,null,null,"Instructions:"]
[null,null,null,"There are multiple tabs across the bottom that indicate the different categories of this report. By moving the mouse pointer to the bottom two arrows pointing left and right, you can navigate the tabs.\n\nBy pressing CNTR + Left Click, you will be brought back to the very first tab.\n\nBy right clicking, you will see a list of all tabs.\n\nGeneral Conditions refer to the preparation to build. Drawings, inspections, permits, readying the lot, temporary installations like power and drainage.\n\nSheet Instructions:\nStep 1 : Choose item Names\nStep 2: Enter Date performed or purchased\nStep 3: Choose your Category from drop down\nStep 4: Choose your Trade from drop down\nStep 5: Type in your Description into the cell\nStep 6: Unit selected from drop down to be either number of days, hours or actual physical items bought or used.\nStep 7: Then enter quantity by keyboard into the cell\nStep 8: Then enter price by keyboard into the cell"]

{"sheet":"General Conditions","index":5,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,3,15],[60,5,60,14],[61,5,80,14]]}
[]
[null,null,"General Conditions"]
[]
[]
["Excelimate",null,null,null,null,"Note: ","General Conditions include the temporary items and items that are preliminary to buildings for example architectural plans."]
["By Room/Item",null,null,null,null,"Page must be able to be locked and password protected."]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:"]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":1},"Dump/Loads","2020-05-12","Temporary","Demolition and Site Work","Dumper Loads",3,"Each",500,{"$f":"+L9*N9","v":1500}]
["General Conditons",null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":2},"Temporary Fencing","2020-05-12","Temporary","Demolition and Site Work","Temporary Chainlink Fence",750,"LF",1.5,{"$f":"+L10*N10","v":1125}]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":3},"Architectural Drawings","2020-05-12","Professional Fees","General Conditions","Drawing Building Plans",1,"Each",15000,{"$f":"+L11*N11","v":15000}]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":4},"Residential Supervisor","2020-05-12","Labor","General Conditions","Residential Supervisor",250,"Hr",88.96,{"$f":"+L12*N12","v":22240}]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":5},"Soil Engineering ","2020-05-12","Professional Fees","General Conditions","Soil Testing and Inspections",1,"Each",2500,2500]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":6},"Cal Green/Title 24","2020-05-12","Professional Fees","General Conditions","Cal Green Inspections",1,"Each",2500,2500]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":7},"Drainage Plan Update","2020-05-12","Professional Fees","General Conditions","Civil and Drain Plans",1,"Each",2000,2000]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":8},"Boom/Lift","2020-05-12","Material","General Conditions","Boom/Lift Rental",7,"Day",317,2219]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":9},"Dumpster Fire","2020-05-12","Labor","Demolition and Site Work","Clean up",2,"Each",2130,{"$f":"+L17*N17","v":4260}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L18*N18","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L19*N19","v":0}]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L30*N30","v":0}]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L44*N44","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L45*N45","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L46*N46","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L47*N47","v":0}]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L55*N55","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L56*N56","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L57*N57","v":0}]
[null,null,null,{"$f":"\"General Conditions\"","v":"General Conditions"},null,{"$f":"IF(tblGeneralConditions[[#This Row],[Item Name:]]=\"\", \"\", ROW()-8)","v":""},null,null,null,null,null,null,null,null,{"$f":"+L58*N58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total: ",{"$f":"SUM(tblGeneralConditions[Extended Price:])","v":53344}]
[]
[null,null,null,null,null,"Supporting Documentation"]

{"sheet":"Utilities","index":6,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,3,15],[61,3,61,14],[62,3,81,14]]}
[]
[null,null,"Utilities"]
[]
[]
["Excelimate"]
["By Room/Item"]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Extended Price:"]
[null,null,null,"Rough Electrical",null,9,"Wire Residence","2020-05-12","Labor","Electrical","Rough Electrical Wiring",2050,"SF",6.96,{"$f":"+L9*N9","v":14268}]
["General Conditons",null,null,"Rough Electrical",null,10,"Meter Base and Disc.","2020-05-12","Material","Electrical","Meter Base and Disconnect",1,"Ea",914,914]
[null,null,null,"Rough Electrical",null,11,"Grounding Rod","2020-05-12","Material","Electrical","Grounding Rod for House",1,"Ea",149.5,149.5]
[null,null,null,"Rough Electrical",null,12,"#12 Gauge Wire","2020-05-12","Material","Electrical","#12 Residential Gauge Wire",1000,"LF",0.9,900]
[null,null,null,"Rough Electrical",null,13,"Exterior Lights","2020-05-12","Material","Electrical","Exterior Lighting",6,"Ea",150,900]
[null,null,null,"Rough Electrical",null,14,"CO/Smoke Detectors","2020-05-12","Material","Electrical","Carbon Monoxide and Smoke Detector",10,"Ea",65,650]
[null,null,null,"Rough Plumbing",null,15,"Rough In Plumbing","2020-05-12","Labor","Plumbing - Includes septic and well","Rough In Plumbing Residential",2050,"SF",5.9,12095]
[null,null,null,"Rough Plumbing",null,16,"Water Meter Upsize","2020-05-12","Material","Plumbing - Includes septic and well","Require Water Meter Upsize",1,"Ea",3750,3750]
[null,null,null,"Rough Plumbing",null,17,"Concealed Fire Sprinkler","2020-05-12","Labor","Plumbing - Includes septic and well","Residential Fire Sprinkler System",2050,"SF",5.44,11152]
[null,null,null,"Rough Plumbing",null,18,"Water Softener","2020-05-12","Material","Plumbing - Includes septic and well","Water Softener - Electronic Control",1,"Ea",1819,1819]
[null,null,null,"Rough Plumbing",null,19,"Flexible Gas Line","2020-05-12","Material","Plumbing - Includes septic and well","1/2\" Flexible Gas Line",1,"Ea",50,50]
[null,null,null,"Rough Plumbing","Water Heater",20,"Water Heater","2020-05-12","Material","Plumbing - Includes septic and well","Water Heater Tankless - Electrical",1,"Ea",2200,2200]
[null,null,null,"HVAC",null,21,"Ductwork System/HVAC Install","2020-05-12","Labor","HVAC","Labor to Install HVAC System",2050,"SF",4.95,10147.5]
[" ",null,null,"HVAC",null,22,"Thermostat","2020-05-12","Material","HVAC","Thermostat Control",1,"Ea",115,115]
[null,null,null,"HVAC",null,23,"Furnace - Forced Air","2020-05-12","Material","HVAC","Furnace - High Efficiency 120,000 BTU",1,"Ea",6760,6760]
[null,null,null,"HVAC",null,24,"Central Air Conditioning","2020-05-12","Material","HVAC","Central Air 4 Ton Unit - 14 SEER",1,"Ea",4780,4780]
[null,null,null,"HVAC",null,25,"Attic Fan ","2020-05-12","Material","HVAC","Attic Fan - 36\"",1,"Ea",1800,1800]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L41*N41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(tblUtilities[Extended Price:])","v":72450}]
[]
[null,null,null,"Supporting Documentation"]

{"sheet":"Foundation","index":7,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,3,15],[61,3,61,14],[62,3,81,14]]}
[]
[null,null,"Utilities"]
[]
[]
["Excelimate"]
["By Room/Item"]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Extended Price:"]
[null,null,null,"Excavating",null,26,"Grade Site","2020-05-12","Labor","Demolition and Site Work","Prepare Site for Foundation - Includes Equipment",1,"Ea",30000,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":30000}]
["General Conditons",null,null,"Excavating",null,27,"Pea Gravel","2020-05-12","Material","Demolition and Site Work","Gravel Fill",10,"CY",89,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":890}]
[null,null,null,"Excavating",null,28,"Drainage","2020-05-12","Labor","Demolition and Site Work","Install Drainage Pipes Under House",1,"Ea",1200,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":1200}]
[null,null,null,"Foundation",null,29,"Steel Rebar 5/8\"","2020-05-12","Material","Concrete/Masonry","Rebar for Foundation",300,"LF",2.8,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":840}]
[null,null,null,"Foundation",null,30,"Concrete Pier","2020-05-12","Material","Concrete/Masonry","Concrete Piers in Foundation",15,"Ea",220,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":3300}]
[null,null,null,"Foundation",null,31,"Footings - Labor","2020-05-12","Labor","Concrete/Masonry","Labor to build forms and pour foundation.",60,"CY",500,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":30000}]
[null,null,null,"Foundation",null,32,"Footings - Material","2020-05-12","Material","Concrete/Masonry","Materials to build forms and pour foundation.",60,"CY",500,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":30000}]
[null,null,null,"Foundation",null,33,"Anchor Bolt","2020-05-12","Material","Concrete/Masonry","1/2\" x 9\" Anchor bolts",60,"Ea",7.5,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":450}]
[null,null,null,"Foundation",null,34,"Moisture Protection","2020-05-12","Material","Concrete/Masonry","Moisture Barrier Underneath House",2050,"SF",0.55000000000000004,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":1127.5}]
[null,null,null,"Foundation",null,35,"Concrete Hold Down","2020-05-12","Material","Concrete/Masonry","Hold Down In Concrete",32,"Ea",14.2,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":454.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblFoundation[[#This Row],[Quantity:]]*tblFoundation[[#This Row],[Unit Price:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Total: ",{"$f":"SUM(tblFoundation[Extended Price:])","v":98261.9}]
[]
[null,null,null,"Supporting Documentation"]

{"sheet":"AppLists","index":8,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[null,null,"Table","Column","Formula",null,"Row Labels",null,"Row Labels",null,"Row Labels",null,"Row Labels"]
[null,null,null,null,null,null,"Decks",null,"Entry",null,"Landscape 1",null,"Tower"]
[null,null,"tblExteriorSections","Section","OFFSET(AppLists!$G$2,0,0,counta(AppLists!$G:$G)-1)",null,"Floor Framing",null,"Kitchen",null,"Landscape 2",null,"Additional Dwelling Unit"]
[null,null,"tblInteriorSections","Section","OFFSET(AppLists!$I$2,0,0,counta(AppLists!$I:$I)-1)",null,"Garage",null,"Master Bath",null,"Landscape 3",null,"Detached Garage"]
[null,null,"tblLandscapeSections","Section","OFFSET(AppLists!$K$2,0,0,counta(AppLists!$K:$K)-1)",null,"Insulation",null,"Bedroom1",null,"Landscape 4",null,"Shed"]
[null,null,"tblOtherStructuresSections","Section","OFFSET(AppLists!$M$2,0,0,counta(AppLists!$M:$M)-1)",null,"Landscape",null,"(blank)",null,"Landscape 5",null,"Moat"]
[null,null,null,null,null,null,"Main Level Framing",null,"Bedroom2"]
[null,null,null,null,null,null,"Patios/Walkways"]
[null,null,null,null,null,null,"Roof"]
[null,null,null,null,null,null,"Roof Framing"]
[null,null,null,null,null,null,"Siding"]
[null,null,null,null,null,null,"(blank)"]

{"sheet":"Landscape","index":9,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,3,15],[61,3,61,14],[62,3,81,14]]}
[]
[null,null,"Landscape"]
[]
[]
["Excelimate"]
["By Room/Item",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N9*L9","v":0}]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Extended Price:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
["General Conditons",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblLandscape[[#This Row],[Unit Price:]]*tblLandscape[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Total: ",{"$f":"SUM(tblLandscape[Extended Price:])","v":0}]
[]
[null,null,null,"Supporting Documentation"]

{"sheet":"Exterior","index":10,"n_rows":62,"n_cols":17,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,3,15],[61,3,61,14],[62,3,81,14]]}
[]
[null,null,"Exterior"]
[]
[]
["Excelimate"]
["By Room/Item"]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Extended Price:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
["General Conditons",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExterior[[#This Row],[Unit Price:]]*tblExterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Total: ",{"$f":"SUM(tblExterior[Extended Price:])","v":0}]
[]
[null,null,null,"Supporting Documentation"]

{"sheet":"Interior","index":11,"n_rows":62,"n_cols":18,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,3,16],[61,3,61,15],[62,3,81,15]]}
[]
[null,null,"Interior"]
[]
[]
["Excelimate"]
["By Room/Item"]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Nickname","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Extended Price:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
["General Conditons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblInterior[[#This Row],[Unit Price:]]*tblInterior[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," Total: ",{"$f":"SUM(tblInterior[Extended Price:])","v":0}]
[]
[null,null,null,"Supporting Documentation"]

{"sheet":"Other Structures","index":12,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,2,3,15],[61,3,61,14],[62,3,81,14]]}
[]
[null,null,"Exterior Structures"]
[]
[]
["Excelimate"]
["By Room/Item"]
[]
[null,null,null,"Section:","Sub Category","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Extended Price:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
["General Conditons",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"tblExteriorStructures[[#This Row],[Unit Price:]]*tblExteriorStructures[[#This Row],[Quantity:]]","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Total: ",{"$f":"SUM(tblExteriorStructures[Extended Price:])","v":0}]
[]
[null,null,null,"Supporting Documentation"]
[null,null,null,"Other Structures - Refers to any item on the property not attached to the main dwelling. Fencing, decking, back sheds, detached garages, pools, pool houses, ADUs etc. Anything not directly attached to the home.\n\nStep 1:\nStep 2:"]

{"sheet":"Materials","index":13,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,2,3,15],[4,2,4,6]]}
[]
[null,null,"Materials Report"]
[]
[]
[null,null,"This Page Is Not Editable"]
[]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:"]
[null,null,null,"Excavating",null,27,"Pea Gravel","2020-05-12","Material","Demolition and Site Work","Gravel Fill",10,"CY",89,890]
[null,null,null,"Foundation",null,29,"Steel Rebar 5/8\"","2020-05-12","Material","Concrete/Masonry","Rebar for Foundation",300,"LF",2.8,840]
[null,null,null,"Foundation",null,30,"Concrete Pier","2020-05-12","Material","Concrete/Masonry","Concrete Piers in Foundation",15,"Ea",220,3300]
[null,null,null,"Foundation",null,32,"Footings - Material","2020-05-12","Material","Concrete/Masonry","Materials to build forms and pour foundation.",60,"CY",500,30000]
[null,null,null,"Foundation",null,33,"Anchor Bolt","2020-05-12","Material","Concrete/Masonry","1/2\" x 9\" Anchor bolts",60,"Ea",7.5,450]
[null,null,null,"Foundation",null,34,"Moisture Protection","2020-05-12","Material","Concrete/Masonry","Moisture Barrier Underneath House",2050,"SF",0.55000000000000004,1127.5]
[null,null,null,"Foundation",null,35,"Concrete Hold Down","2020-05-12","Material","Concrete/Masonry","Hold Down In Concrete",32,"Ea",14.2,454.4]
[null,null,null,"Garage","Ceiling",37,"5/8\" Dry Wall","2020-05-12","Material","Drywall and Paint","5/8\" Dry Wall Sheet 4' x 8'",16,"Ea",9.5,152]
[null,null,null,"Garage","Doors/Windows/Trim",38,"Seal/Prime and Paint","2020-05-12","Material","Drywall and Paint","Primer and Paint",464,"SF",0.45,208.8]
[null,null,null,"Garage","Ceiling",40,"5/8\" Dry Wall","2020-05-12","Material","Drywall and Paint","5/8\" Dry Wall Sheet 4' x 8'",38,"Ea",9.5,361]
[null,null,null,"Garage","Walls",41,"Seal/Prime and Paint","2020-05-12","Material","Drywall and Paint","Primer and Paint",1172,"SF",0.45,527.4]
[null,null,null,"Garage","Finish Carpentry",42,"Door Casing","2020-05-12","Material","Finish Carpentry","Door Casing - 3-1/4\"",32,"LF",1.9,60.8]
[null,null,null,"Garage","Finish Carpentry",42,"Paint Door Casing","2020-05-12","Material","Drywall and Paint","Paint for Door Casing",32,"LF",0.25,8]
[null,null,null,"Rough Electrical",null,10,"Meter Base and Disc.","2020-05-12","Material","Electrical","Meter Base and Disconnect",1,"Ea",914,914]
[null,null,null,"Rough Electrical",null,11,"Grounding Rod","2020-05-12","Material","Electrical","Grounding Rod for House",1,"Ea",149.5,149.5]
[null,null,null,"Rough Electrical",null,12,"#12 Gauge Wire","2020-05-12","Material","Electrical","#12 Residential Gauge Wire",1000,"LF",0.9,900]
[null,null,null,"Rough Electrical",null,13,"Exterior Lights","2020-05-12","Material","Electrical","Exterior Lighting",6,"Ea",150,900]
[null,null,null,"Rough Electrical",null,14,"CO/Smoke Detectors","2020-05-12","Material","Electrical","Carbon Monoxide and Smoke Detector",10,"Ea",65,650]
[null,null,null,"Rough Plumbing",null,16,"Water Meter Upsize","2020-05-12","Material","Plumbing - Includes septic and well","Require Water Meter Upsize",1,"Ea",3750,3750]
[null,null,null,"Rough Plumbing",null,18,"Water Softener","2020-05-12","Material","Plumbing - Includes septic and well","Water Softener - Electronic Control",1,"Ea",1819,1819]
[null,null,null,"Rough Plumbing",null,19,"Flexible Gas Line","2020-05-12","Material","Plumbing - Includes septic and well","1/2\" Flexible Gas Line",1,"Ea",50,50]
[null,null,null,"Rough Plumbing","Water Heater",20,"Water Heater","2020-05-12","Material","Plumbing - Includes septic and well","Water Heater Tankless - Electrical",1,"Ea",2200,2200]
[null,null,null,"HVAC",null,22,"Thermostat","2020-05-12","Material","HVAC","Thermostat Control",1,"Ea",115,115]
[null,null,null,"HVAC",null,23,"Furnace - Forced Air","2020-05-12","Material","HVAC","Furnace - High Efficiency 120,000 BTU",1,"Ea",6760,6760]
[null,null,null,"HVAC",null,24,"Central Air Conditioning","2020-05-12","Material","HVAC","Central Air 4 Ton Unit - 14 SEER",1,"Ea",4780,4780]
[null,null,null,"HVAC",null,25,"Attic Fan ","2020-05-12","Material","HVAC","Attic Fan - 36\"",1,"Ea",1800,1800]
[null,null,null,"General Conditions",null,8,"Boom/Lift","2020-05-12","Material","General Conditions","Boom/Lift Rental",7,"Da",317,2219]

{"sheet":"Labor","index":14,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,3,15],[4,2,4,6]]}
[]
[null,null,"Labor Report"]
[]
[]
[null,null,"This Page Is Not Editable"]
[]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:"]
[null,null,null,"Excavating",null,26,"Grade Site","2020-05-12","Labor","Demolition and Site Work","Prepare Site for Foundation - Includes Equipment",1,"Ea",30000,30000]
[null,null,null,"Excavating",null,28,"Drainage","2020-05-12","Labor","Demolition and Site Work","Install Drainage Pipes Under House",1,"Ea",1200,1200]
[null,null,null,"Foundation",null,31,"Footings - Labor","2020-05-12","Labor","Concrete/Masonry","Labor to build forms and pour foundation.",60,"CY",500,30000]
[null,null,null,"Garage","Ceiling",36,"Drywall, Prime and Paint","2020-05-12","Labor","Drywall and Paint","5/8\" Dry Wall - Labor",464,"SF",3,1392]
[null,null,null,"Garage","Walls",39,"Drywall, Prime and Paint","2020-05-12","Labor","Drywall and Paint","5/8\" Dry Wall - Labor",1172,"SF",3,3516]
[null,null,null,"Garage","Finish Carpentry",42,"Install Casing","2020-05-12","Labor","Finish Carpentry"]
[null,null,null,"Rough Electrical",null,9,"Wire Residence","2020-05-12","Labor","Electrical","Rough Electrical Wiring",2050,"SF",6.96,14268]
[null,null,null,"Rough Plumbing",null,15,"Rough In Plumbing","2020-05-12","Labor","Plumbing - Includes septic and well","Rough In Plumbing Residential",2050,"SF",5.9,12095]
[null,null,null,"Rough Plumbing",null,17,"Concealed Fire Sprinkler","2020-05-12","Labor","Plumbing - Includes septic and well","Residential Fire Sprinkler System",2050,"SF",5.44,11152]
[null,null,null,"HVAC",null,21,"Ductwork System/HVAC Install","2020-05-12","Labor","HVAC","Labor to Install HVAC System",2050,"SF",4.95,10147.5]
[null,null,null,"General Conditions",null,4,"Residential Supervisor","2020-05-12","Labor","General Conditions","Residential Supervisor",250,"Hr",88.96,22240]

{"sheet":"Trade Summary","index":15,"n_rows":149,"n_cols":26,"rows_kept":149,"cut":false,"hidden":false,"merged":[[1,2,3,26],[4,2,4,16]]}
[]
[null,null,"Trade Summary"]
[]
[]
[null,null,"This Page Is Not Editable"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item #:","Item Name:","Date:","Category:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:"]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:",null,"Concrete/Masonry"]
[null,null,null,"Foundation",null,29,"Steel Rebar 5/8\"","2020-05-12","Material","Concrete/Masonry","Rebar for Foundation",300,"LF",2.8,840,null,null,29,"Steel Rebar 5/8\"","2020-05-12","Material","Rebar for Foundation",300,"LF",2.8,840]
[null,null,null,"Foundation",null,30,"Concrete Pier","2020-05-12","Material","Concrete/Masonry","Concrete Piers in Foundation",15,"Ea",220,3300,null,null,30,"Concrete Pier","2020-05-12","Material","Concrete Piers in Foundation",15,"Ea",220,3300]
[null,null,null,"Foundation",null,31,"Footings - Labor","2020-05-12","Labor","Concrete/Masonry","Labor to build forms and pour foundation.",60,"CY",500,30000,null,null,31,"Footings - Labor","2020-05-12","Labor","Labor to build forms and pour foundation.",60,"CY",500,30000]
[null,null,null,"Foundation",null,32,"Footings - Material","2020-05-12","Material","Concrete/Masonry","Materials to build forms and pour foundation.",60,"CY",500,30000,null,null,32,"Footings - Material","2020-05-12","Material","Materials to build forms and pour foundation.",60,"CY",500,30000]
[null,null,null,"Foundation",null,33,"Anchor Bolt","2020-05-12","Material","Concrete/Masonry","1/2\" x 9\" Anchor bolts",60,"Ea",7.5,450,null,null,33,"Anchor Bolt","2020-05-12","Material","1/2\" x 9\" Anchor bolts",60,"Ea",7.5,450]
[null,null,null,"Foundation",null,34,"Moisture Protection","2020-05-12","Material","Concrete/Masonry","Moisture Barrier Underneath House",2050,"SF",0.55000000000000004,1127.5,null,null,34,"Moisture Protection","2020-05-12","Material","Moisture Barrier Underneath House",2050,"SF",0.55000000000000004,1127.5]
[null,null,null,"Foundation",null,35,"Concrete Hold Down","2020-05-12","Material","Concrete/Masonry","Hold Down In Concrete",32,"Ea",14.2,454.4,null,null,35,"Concrete Hold Down","2020-05-12","Material","Hold Down In Concrete",32,"Ea",14.2,454.4]
[null,null,null,"Excavating",null,26,"Grade Site","2020-05-12","Labor","Demolition and Site Work","Prepare Site for Foundation - Includes Equipment",1,"Ea",30000,30000]
[null,null,null,"Excavating",null,27,"Pea Gravel","2020-05-12","Material","Demolition and Site Work","Gravel Fill",10,"CY",89,890]
[null,null,null,"Excavating",null,28,"Drainage","2020-05-12","Labor","Demolition and Site Work","Install Drainage Pipes Under House",1,"Ea",1200,1200,null,"Demolition and Site Work"]
[null,null,null,"General Conditions",null,1,"Dump/Loads","2020-05-12","Temporary","Demolition and Site Work","Dumper Loads",3,"Each",500,1500,null,null,26,"Grade Site","2020-05-12","Labor","Prepare Site for Foundation - Includes Equipment",1,"Ea",30000,30000]
[null,null,null,"General Conditions",null,2,"Temporary Fencing","2020-05-12","Temporary","Demolition and Site Work","Temporary Chainlink Fence",750,"LF",1.5,1125,null,null,27,"Pea Gravel","2020-05-12","Material","Gravel Fill",10,"CY",89,890]
[null,null,null,"Garage","Ceiling",36,"Drywall, Prime and Paint","2020-05-12","Labor","Drywall and Paint","5/8\" Dry Wall - Labor",464,"SF",3,1392,null,null,28,"Drainage","2020-05-12","Labor","Install Drainage Pipes Under House",1,"Ea",1200,1200]
[null,null,null,"Garage","Ceiling",37,"5/8\" Dry Wall","2020-05-12","Material","Drywall and Paint","5/8\" Dry Wall Sheet 4' x 8'",16,"Ea",9.5,152,null,null,1,"Dump/Loads","2020-05-12","Temporary","Dumper Loads",3,"Each",500,1500]
[null,null,null,"Garage","Doors/Windows/Trim",38,"Seal/Prime and Paint","2020-05-12","Material","Drywall and Paint","Primer and Paint",464,"SF",0.45,208.8,null,null,2,"Temporary Fencing","2020-05-12","Temporary","Temporary Chainlink Fence",750,"LF",1.5,1125]
[null,null,null,"Garage","Walls",39,"Drywall, Prime and Paint","2020-05-12","Labor","Drywall and Paint","5/8\" Dry Wall - Labor",1172,"SF",3,3516]
[null,null,null,"Garage","Ceiling",40,"5/8\" Dry Wall","2020-05-12","Material","Drywall and Paint","5/8\" Dry Wall Sheet 4' x 8'",38,"Ea",9.5,361]
[null,null,null,"Garage","Walls",41,"Seal/Prime and Paint","2020-05-12","Material","Drywall and Paint","Primer and Paint",1172,"SF",0.45,527.4,null,"Drywall and Paint"]
[null,null,null,"Garage","Finish Carpentry",42,"Paint Door Casing","2020-05-12","Material","Drywall and Paint","Paint for Door Casing",32,"LF",0.25,8,null,null,36,"Drywall, Prime and Paint","2020-05-12","Labor","5/8\" Dry Wall - Labor",464,"SF",3,1392]
[null,null,null,"Rough Electrical",null,9,"Wire Residence","2020-05-12","Labor","Electrical","Rough Electrical Wiring",2050,"SF",6.96,14268,null,null,37,"5/8\" Dry Wall","2020-05-12","Material","5/8\" Dry Wall Sheet 4' x 8'",16,"Ea",9.5,152]
[null,null,null,"Rough Electrical",null,10,"Meter Base and Disc.","2020-05-12","Material","Electrical","Meter Base and Disconnect",1,"Ea",914,914,null,null,38,"Seal/Prime and Paint","2020-05-12","Material","Primer and Paint",464,"SF",0.45,208.8]
[null,null,null,"Rough Electrical",null,11,"Grounding Rod","2020-05-12","Material","Electrical","Grounding Rod for House",1,"Ea",149.5,149.5,null,null,39,"Drywall, Prime and Paint","2020-05-12","Labor","5/8\" Dry Wall - Labor",1172,"SF",3,3516]
[null,null,null,"Rough Electrical",null,12,"#12 Gauge Wire","2020-05-12","Material","Electrical","#12 Residential Gauge Wire",1000,"LF",0.9,900,null,null,40,"5/8\" Dry Wall","2020-05-12","Material","5/8\" Dry Wall Sheet 4' x 8'",38,"Ea",9.5,361]
[null,null,null,"Rough Electrical",null,13,"Exterior Lights","2020-05-12","Material","Electrical","Exterior Lighting",6,"Ea",150,900,null,null,41,"Seal/Prime and Paint","2020-05-12","Material","Primer and Paint",1172,"SF",0.45,527.4]
[null,null,null,"Rough Electrical",null,14,"CO/Smoke Detectors","2020-05-12","Material","Electrical","Carbon Monoxide and Smoke Detector",10,"Ea",65,650,null,null,42,"Paint Door Casing","2020-05-12","Material","Paint for Door Casing",32,"LF",0.25,8]
[null,null,null,"Garage","Finish Carpentry",42,"Door Casing","2020-05-12","Material","Finish Carpentry","Door Casing - 3-1/4\"",32,"LF",1.9,60.8]
[null,null,null,"Garage","Finish Carpentry",42,"Install Casing","2020-05-12","Labor","Finish Carpentry"]
[null,null,null,"General Conditions",null,3,"Architectural Drawings","2020-05-12","Professional Fees","General Conditions","Drawing Building Plans",1,"Each",15000,15000,null,"Electrical"]
[null,null,null,"General Conditions",null,4,"Residential Supervisor","2020-05-12","Labor","General Conditions","Residential Supervisor",250,"Hr",88.96,22240,null,null,9,"Wire Residence","2020-05-12","Labor","Rough Electrical Wiring",2050,"SF",6.96,14268]
[null,null,null,"General Conditions",null,5,"Soil Engineering ","2020-05-12","Professional Fees","General Conditions","Soil Testing and Inspections",1,"Each",2500,2500,null,null,10,"Meter Base and Disc.","2020-05-12","Material","Meter Base and Disconnect",1,"Ea",914,914]
[null,null,null,"General Conditions",null,6,"Cal Green/Title 24","2020-05-12","Professional Fees","General Conditions","Cal Green Inspections",1,"Each",2500,2500,null,null,11,"Grounding Rod","2020-05-12","Material","Grounding Rod for House",1,"Ea",149.5,149.5]
[null,null,null,"General Conditions",null,7,"Drainage Plan Update","2020-05-12","Professional Fees","General Conditions","Civil and Drain Plans",1,"Each",2000,2000,null,null,12,"#12 Gauge Wire","2020-05-12","Material","#12 Residential Gauge Wire",1000,"LF",0.9,900]
[null,null,null,"General Conditions",null,8,"Boom/Lift","2020-05-12","Material","General Conditions","Boom/Lift Rental",7,"Da",317,2219,null,null,13,"Exterior Lights","2020-05-12","Material","Exterior Lighting",6,"Ea",150,900]
[null,null,null,"HVAC",null,21,"Ductwork System/HVAC Install","2020-05-12","Labor","HVAC","Labor to Install HVAC System",2050,"SF",4.95,10147.5,null,null,14,"CO/Smoke Detectors","2020-05-12","Material","Carbon Monoxide and Smoke Detector",10,"Ea",65,650]
[null,null,null,"HVAC",null,22,"Thermostat","2020-05-12","Material","HVAC","Thermostat Control",1,"Ea",115,115]
[null,null,null,"HVAC",null,23,"Furnace - Forced Air","2020-05-12","Material","HVAC","Furnace - High Efficiency 120,000 BTU",1,"Ea",6760,6760]
[null,null,null,"HVAC",null,24,"Central Air Conditioning","2020-05-12","Material","HVAC","Central Air 4 Ton Unit - 14 SEER",1,"Ea",4780,4780,null,"Finish Carpentry"]
[null,null,null,"HVAC",null,25,"Attic Fan ","2020-05-12","Material","HVAC","Attic Fan - 36\"",1,"Ea",1800,1800,null,null,42,"Door Casing","2020-05-12","Material","Door Casing - 3-1/4\"",32,"LF",1.9,60.8]
[null,null,null,"Rough Plumbing",null,15,"Rough In Plumbing","2020-05-12","Labor","Plumbing - Includes septic and well","Rough In Plumbing Residential",2050,"SF",5.9,12095,null,null,42,"Install Casing","2020-05-12","Labor"]
[null,null,null,"Rough Plumbing",null,16,"Water Meter Upsize","2020-05-12","Material","Plumbing - Includes septic and well","Require Water Meter Upsize",1,"Ea",3750,3750]
[null,null,null,"Rough Plumbing",null,17,"Concealed Fire Sprinkler","2020-05-12","Labor","Plumbing - Includes septic and well","Residential Fire Sprinkler System",2050,"SF",5.44,11152]
[null,null,null,"Rough Plumbing",null,18,"Water Softener","2020-05-12","Material","Plumbing - Includes septic and well","Water Softener - Electronic Control",1,"Ea",1819,1819,null,"General Conditions"]
[null,null,null,"Rough Plumbing",null,19,"Flexible Gas Line","2020-05-12","Material","Plumbing - Includes septic and well","1/2\" Flexible Gas Line",1,"Ea",50,50,null,null,3,"Architectural Drawings","2020-05-12","Professional Fees","Drawing Building Plans",1,"Each",15000,15000]
[null,null,null,"Rough Plumbing","Water Heater",20,"Water Heater","2020-05-12","Material","Plumbing - Includes septic and well","Water Heater Tankless - Electrical",1,"Ea",2200,2200,null,null,4,"Residential Supervisor","2020-05-12","Labor","Residential Supervisor",250,"Hr",88.96,22240]
[null,null,null,"Garage",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Soil Engineering ","2020-05-12","Professional Fees","Soil Testing and Inspections",1,"Each",2500,2500]
[null,null,null,"Floor Framing",null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Cal Green/Title 24","2020-05-12","Professional Fees","Cal Green Inspections",1,"Each",2500,2500]
[null,null,null,"Master Bath",null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Drainage Plan Update","2020-05-12","Professional Fees","Civil and Drain Plans",1,"Each",2000,2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Boom/Lift","2020-05-12","Material","Boom/Lift Rental",7,"Da",317,2219]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HVAC"]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,21,"Ductwork System/HVAC Install","2020-05-12","Labor","Labor to Install HVAC System",2050,"SF",4.95,10147.5]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,22,"Thermostat","2020-05-12","Material","Thermostat Control",1,"Ea",115,115]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,23,"Furnace - Forced Air","2020-05-12","Material","Furnace - High Efficiency 120,000 BTU",1,"Ea",6760,6760]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,24,"Central Air Conditioning","2020-05-12","Material","Central Air 4 Ton Unit - 14 SEER",1,"Ea",4780,4780]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,25,"Attic Fan ","2020-05-12","Material","Attic Fan - 36\"",1,"Ea",1800,1800]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,"Plumbing - Includes septic and well"]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,15,"Rough In Plumbing","2020-05-12","Labor","Rough In Plumbing Residential",2050,"SF",5.9,12095]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,16,"Water Meter Upsize","2020-05-12","Material","Require Water Meter Upsize",1,"Ea",3750,3750]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,17,"Concealed Fire Sprinkler","2020-05-12","Labor","Residential Fire Sprinkler System",2050,"SF",5.44,11152]
[null,null,null,"General Conditions",null,null,null,null,null,null,null,null,null,null,0,null,null,18,"Water Softener","2020-05-12","Material","Water Softener - Electronic Control",1,"Ea",1819,1819]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Flexible Gas Line","2020-05-12","Material","1/2\" Flexible Gas Line",1,"Ea",50,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Water Heater","2020-05-12","Material","Water Heater Tankless - Electrical",1,"Ea",2200,2200]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Report Summary","index":16,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,2,3,12],[4,2,4,6]]}
[]
[null,null,"Report Summary"]
[]
[]
[null,null,"This Page Is Not Editable"]
[]
[]
[null,null,null,"Materials Total:",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Category:],\"Material\")+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Category:],\"Material\")+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Category:],\"Material\")+SUMIFS(tblExterior[Extended Price:],tblExterior[Category:],\"Material\")+SUMIFS(tblInterior[Extended Price:],tblInterior[Category:],\"Material\")+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Category:],\"Material\")","v":64068.4},null,null,"Note: "]
[null,null,null,"Labor Total:",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Category:],\"Labor\")+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Category:],\"Labor\")+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Category:],\"Labor\")+SUMIFS(tblExterior[Extended Price:],tblExterior[Category:],\"Labor\")+SUMIFS(tblInterior[Extended Price:],tblInterior[Category:],\"Labor\")+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Category:],\"Labor\")","v":135362.5},null,null,"Page should reflect total building cost from all line items."]
[null,null,null,"Temporary Totals:",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Category:],\"Temporary\")+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Category:],\"Temporary\")+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Category:],\"Temporary\")+SUMIFS(tblExterior[Extended Price:],tblExterior[Category:],\"Temporary\")+SUMIFS(tblInterior[Extended Price:],tblInterior[Category:],\"Temporary\")+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Category:],\"Temporary\")","v":2625},null,null,"There should be a calculated sales tax from all material items."]
[null,null,null,"Professional Fees:",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Category:],\"Professional Fees\")+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Category:],\"Professional Fees\")+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Category:],\"Professional Fees\")+SUMIFS(tblExterior[Extended Price:],tblExterior[Category:],\"Professional Fees\")+SUMIFS(tblInterior[Extended Price:],tblInterior[Category:],\"Professional Fees\")+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Category:],\"Professional Fees\")","v":22000}]
[null,null,null,null,null,null,null,"Professional Fees is going to be architecture, engineering, survey, soil test, permits, etc."]
[]
[null,null,null,"Sub Total:",{"$f":"SUM(E8:E11)","v":224055.9},null,null,"Contractor Profit and Overhead are 10% each of the sub total cost."]
[null,null,null,null,null,null,null,"Sales tax is added after the contractor profit and overhead based on material cost."]
[]
[null,null,null,"Contractor Overhead and Profit:",{"$f":"'Property Description'!E20*(E19+E14)","v":22982.205600000001},null,null,"Total Job Cost equals sub total, contractor profit and overhead and sales tax."]
[null,null,null,null,null,null,null,"  "]
[null,null,null,"Material Sales Tax:",{"$f":"'Property Description'!E18*E8","v":5766.1559999999999},null,null,"tax only applies to the materials"]
[]
[]
[null,null,null,"Total Job Cost:",{"$f":"E17+E19+E14","v":252804.2616}]

{"sheet":"16D","index":17,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,2,3,13],[4,2,4,6]]}
[]
[null,null,"16D"]
[]
[]
[null,null,"This Page Is Not Editable"]
[]
[null,null,null,1000,"General Conditions","General Conditions",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F7)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F7)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F7)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F7)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F7)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F7)","v":46459}]
[]
[null,null,null,2000,"Demolition and Site Work","Demolition and Site Work",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F9)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F9)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F9)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F9)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F9)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F9)","v":38975}]
[]
[null,null,null,3000,"Concrete/Masonry","Concrete/Masonry",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F11)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F11)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F11)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F11)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F11)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F11)","v":66171.899999999994}]
[]
[null,null,null,4000,"Rough Carpentry","Rough Carpentry",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F13)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F13)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F13)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F13)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F13)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F13)","v":0}]
[]
[null,null,null,5000,"Finish Carpentry","Finish Carpentry",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F15)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F15)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F15)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F15)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F15)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F15)","v":0}]
[]
[null,null,null,6000,"Doors and Windows","Doors and Windows",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F17)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F17)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F17)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F17)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F17)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F17)","v":0}]
[]
[null,null,null,7000,"Drywall and Paint","Drywall and Paint",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F19)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F19)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F19)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F19)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F19)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F19)","v":0}]
[]
[null,null,null,8000,"Insulation","Insulation",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F21)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F21)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F21)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F21)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F21)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F21)","v":0}]
[]
[null,null,null,9000,"Flooring","Flooring",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F23)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F23)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F23)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F23)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F23)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F23)","v":0}]
[]
[null,null,null,10000,"Bath","Bathrooms",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F25)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F25)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F25)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F25)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F25)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F25)","v":0}]
[]
[null,null,null,11000,"Kitchen","Kitchen and Appliances",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F27)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F27)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F27)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F27)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F27)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F27)","v":0}]
[]
[null,null,null,12000,"HVAC - Mechanical","HVAC",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F29)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F29)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F29)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F29)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F29)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F29)","v":23602.5}]
[]
[null,null,null,13000,"Plumbing","Plumbing - Includes septic and well",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F31)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F31)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F31)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F31)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F31)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F31)","v":31066}]
[]
[null,null,null,14000,"Electrical","Electrical",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F33)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F33)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F33)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F33)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F33)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F33)","v":17781.5}]
[]
[null,null,null,15000,"Roofing","Roofing",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F35)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F35)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F35)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F35)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F35)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F35)","v":0}]
[]
[null,null,null,16000,"Landscape and Fencing","Landscape and Fencing - Includes any pool, fountain and irrigation work.",{"$f":"SUMIFS(tblGeneralConditions[Extended Price:],tblGeneralConditions[Trade:],'16D'!F37)+SUMIFS(tblUtilities[Extended Price:],tblUtilities[Trade:],'16D'!F37)+SUMIFS(tblFoundation[Extended Price:],tblFoundation[Trade:],'16D'!F37)+SUMIFS(tblExterior[Extended Price:],tblExterior[Trade:],'16D'!F37)+SUMIFS(tblInterior[Extended Price:],tblInterior[Trade:],'16D'!F37)+SUMIFS(tblExteriorStructures[Extended Price:],tblExteriorStructures[Trade:],'16D'!F37)","v":0}]

{"sheet":"Line Items","index":18,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,2,3,15],[4,2,4,6]]}
[]
[null,null,"Line Item"]
[]
[]
[null,null,"This Page Is Not Editable"]
[]
[]
[null,null,null,"Section:","Sub Category:","Item #:","Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:"]
[null,null,null,"Rough Electrical",null,12,"#12 Gauge Wire","2020-05-12","Material","Electrical","#12 Residential Gauge Wire",1000,"LF",0.9,900]
[null,null,null,"Garage","Ceiling",37,"5/8\" Dry Wall","2020-05-12","Material","Drywall and Paint","5/8\" Dry Wall Sheet 4' x 8'",16,"Ea",9.5,152]
[null,null,null,"Garage","Ceiling",40,"5/8\" Dry Wall","2020-05-12","Material","Drywall and Paint","5/8\" Dry Wall Sheet 4' x 8'",38,"Ea",9.5,361]
[null,null,null,"Foundation",null,33,"Anchor Bolt","2020-05-12","Material","Concrete/Masonry","1/2\" x 9\" Anchor bolts",60,"Ea",7.5,450]
[null,null,null,"HVAC",null,25,"Attic Fan ","2020-05-12","Material","HVAC","Attic Fan - 36\"",1,"Ea",1800,1800]
[null,null,null,"General Conditions",null,8,"Boom/Lift","2020-05-12","Material","General Conditions","Boom/Lift Rental",7,"Da",317,2219]
[null,null,null,"HVAC",null,24,"Central Air Conditioning","2020-05-12","Material","HVAC","Central Air 4 Ton Unit - 14 SEER",1,"Ea",4780,4780]
[null,null,null,"Rough Electrical",null,14,"CO/Smoke Detectors","2020-05-12","Material","Electrical","Carbon Monoxide and Smoke Detector",10,"Ea",65,650]
[null,null,null,"Rough Plumbing",null,17,"Concealed Fire Sprinkler","2020-05-12","Labor","Plumbing - Includes septic and well","Residential Fire Sprinkler System",2050,"SF",5.44,11152]
[null,null,null,"Foundation",null,35,"Concrete Hold Down","2020-05-12","Material","Concrete/Masonry","Hold Down In Concrete",32,"Ea",14.2,454.4]
[null,null,null,"Foundation",null,30,"Concrete Pier","2020-05-12","Material","Concrete/Masonry","Concrete Piers in Foundation",15,"Ea",220,3300]
[null,null,null,"Garage","Finish Carpentry",42,"Door Casing","2020-05-12","Material","Finish Carpentry","Door Casing - 3-1/4\"",32,"LF",1.9,60.8]
[null,null,null,"Excavating",null,28,"Drainage","2020-05-12","Labor","Demolition and Site Work","Install Drainage Pipes Under House",1,"Ea",1200,1200]
[null,null,null,"Garage","Ceiling",36,"Drywall, Prime and Paint","2020-05-12","Labor","Drywall and Paint","5/8\" Dry Wall - Labor",464,"SF",3,1392]
[null,null,null,"Garage","Walls",39,"Drywall, Prime and Paint","2020-05-12","Labor","Drywall and Paint","5/8\" Dry Wall - Labor",1172,"SF",3,3516]
[null,null,null,"HVAC",null,21,"Ductwork System/HVAC Install","2020-05-12","Labor","HVAC","Labor to Install HVAC System",2050,"SF",4.95,10147.5]
[null,null,null,"Rough Electrical",null,13,"Exterior Lights","2020-05-12","Material","Electrical","Exterior Lighting",6,"Ea",150,900]
[null,null,null,"Rough Plumbing",null,19,"Flexible Gas Line","2020-05-12","Material","Plumbing - Includes septic and well","1/2\" Flexible Gas Line",1,"Ea",50,50]
[null,null,null,"Foundation",null,31,"Footings - Labor","2020-05-12","Labor","Concrete/Masonry","Labor to build forms and pour foundation.",60,"CY",500,30000]
[null,null,null,"Foundation",null,32,"Footings - Material","2020-05-12","Material","Concrete/Masonry","Materials to build forms and pour foundation.",60,"CY",500,30000]
[null,null,null,"HVAC",null,23,"Furnace - Forced Air","2020-05-12","Material","HVAC","Furnace - High Efficiency 120,000 BTU",1,"Ea",6760,6760]
[null,null,null,"Excavating",null,26,"Grade Site","2020-05-12","Labor","Demolition and Site Work","Prepare Site for Foundation - Includes Equipment",1,"Ea",30000,30000]
[null,null,null,"Rough Electrical",null,11,"Grounding Rod","2020-05-12","Material","Electrical","Grounding Rod for House",1,"Ea",149.5,149.5]
[null,null,null,"Garage","Finish Carpentry",42,"Install Casing","2020-05-12","Labor","Finish Carpentry"]
[null,null,null,"Rough Electrical",null,10,"Meter Base and Disc.","2020-05-12","Material","Electrical","Meter Base and Disconnect",1,"Ea",914,914]
[null,null,null,"Foundation",null,34,"Moisture Protection","2020-05-12","Material","Concrete/Masonry","Moisture Barrier Underneath House",2050,"SF",0.55000000000000004,1127.5]
[null,null,null,"Garage","Finish Carpentry",42,"Paint Door Casing","2020-05-12","Material","Drywall and Paint","Paint for Door Casing",32,"LF",0.25,8]
[null,null,null,"Excavating",null,27,"Pea Gravel","2020-05-12","Material","Demolition and Site Work","Gravel Fill",10,"CY",89,890]
[null,null,null,"General Conditions",null,4,"Residential Supervisor","2020-05-12","Labor","General Conditions","Residential Supervisor",250,"Hr",88.96,22240]
[null,null,null,"Rough Plumbing",null,15,"Rough In Plumbing","2020-05-12","Labor","Plumbing - Includes septic and well","Rough In Plumbing Residential",2050,"SF",5.9,12095]
[null,null,null,"Garage","Doors/Windows/Trim",38,"Seal/Prime and Paint","2020-05-12","Material","Drywall and Paint","Primer and Paint",464,"SF",0.45,208.8]
[null,null,null,"Garage","Walls",41,"Seal/Prime and Paint","2020-05-12","Material","Drywall and Paint","Primer and Paint",1172,"SF",0.45,527.4]
[null,null,null,"Foundation",null,29,"Steel Rebar 5/8\"","2020-05-12","Material","Concrete/Masonry","Rebar for Foundation",300,"LF",2.8,840]
[null,null,null,"HVAC",null,22,"Thermostat","2020-05-12","Material","HVAC","Thermostat Control",1,"Ea",115,115]
[null,null,null,"Rough Plumbing","Water Heater",20,"Water Heater","2020-05-12","Material","Plumbing - Includes septic and well","Water Heater Tankless - Electrical",1,"Ea",2200,2200]
[null,null,null,"Rough Plumbing",null,16,"Water Meter Upsize","2020-05-12","Material","Plumbing - Includes septic and well","Require Water Meter Upsize",1,"Ea",3750,3750]
[null,null,null,"Rough Plumbing",null,18,"Water Softener","2020-05-12","Material","Plumbing - Includes septic and well","Water Softener - Electronic Control",1,"Ea",1819,1819]
[null,null,null,"Rough Electrical",null,9,"Wire Residence","2020-05-12","Labor","Electrical","Rough Electrical Wiring",2050,"SF",6.96,14268]

{"sheet":"Line Items Template","index":19,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Line Items:",null,"Note: Purpose of this page is to combine material and labor items that you can draw from.  "]
["Interior",null,"The idea is if you list items here and are able to combine the material and labor into one item but it still reads separately on the separate reports."]
[null,null,"For example: 1/2\" drywall requires the drywall panels and the labor to install them."]
[null,null,"If I could write the separate items for labor and material on this page and have the user be able to choose one item on the \"Interior\" sheet that includes both the line items from this page?"]
[null,null,"The separate material and labor item could populate onto their corresponding report sheets.  This page does not need to include pricing, just the line item, category, trade, description and type of quantity."]
[null,null,"There are quite a few items especially in the interior of the house that this would make sense for."]
[]
[null,null,"How do you determine the allocation of price of labor and material separately?  We are back in the realm of Xactimate if we combine elements with supporting costs/etc."]
[null,null,"We want to bridge the gap between excel and xactimate, we don't need a million items, but we need it detailed enough, an insurance company would accept it."]
[null,null,"this is the database of items to draw from"]
[]
[null,null,"Item Name:","Date:","Category:","Trade:","Description:","Quantity:","Unit:","Unit Price:","Extended Price:"]
[]
["Mater Line Item:",null,"1/2\" Drywall",null,"Material/Labor","Drywall and Paint"]
[null,null,"1/2\" Drywall",null,"Labor","Drywall and Paint","Install Drywall",1,"SF"]
[null,null,"1/2\" Drywall",null,"Material  ","Drywall and Paint","1/2\" Drywall Sheets",1,"SF"]