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

{"sheet":"ReturnAddress","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Quality Construction, Inc."]
[null,null,null,"550 North Star Valley Drive"]
[null,null,null,"Dallas, Texas 75382-2877"]

{"sheet":"Colors","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Colors"]
[null,"Red"]
[null,"Green"]
[null,"Blue",null,"Green"]
[null,"Yellow",null,"Blue"]
[null,"Orange"]
[null,"Purple"]
[null,"Black"]
[null,"Brown"]
[null,"White"]

{"sheet":"GarageDoors","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Garage Door Detail"]
[null,"Description","QTY","Unit","Unit Cost","Total Cost"]
[null,null,{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,GarageDoorDB,2,FALSE))","v":""},{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,GarageDoorDB,3,FALSE))","v":""},{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,GarageDoorDB,4,FALSE))","v":""},{"$f":"IF(ISBLANK(B6),\"\",C6*E6)","v":""}]
[null,null,"","","",{"$f":"IF(ISBLANK(B7),\"\",C7*E7)","v":""}]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,null,"","","",""]
[null,"End"]

{"sheet":"Roofing","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Roofing Material Detail"]
[null,"Description","QTY","Unit","Unit Cost","Total Cost"]
[null,"Asphalt Shingles - 30 yr. Architectural",{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,RoofingDB,2,FALSE))","v":0},{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,RoofingDB,3,FALSE))","v":"Sq"},{"$f":"IF(ISBLANK(B6),\"\",VLOOKUP(B6,RoofingDB,4,FALSE))","v":48.43},{"$f":"IF(ISBLANK(B6),\"\",C6*E6)","v":0}]
[null,"Deliver & Stock shingles",0,"Sq",3.5,{"$f":"IF(ISBLANK(B7),\"\",C7*E7)","v":0}]
[null,"30# Tar Paper (Asphalt-impregnated Felt)",0,"2-Sq Roll",10.95,0]
[null,"Starter Strip",0,"Sq (T)",38,0]
[null,"Hip & Ridge Cap",0,"Sq (T)",38,{"$f":"IF(ISBLANK(B10),\"\",C10*E10)","v":0}]
[null,"Ridge Vents",0,"Lf",2.2999999999999998,{"$f":"IF(ISBLANK(B11),\"\",C11*E11)","v":0}]
[null,"Step Flashing 3 x 4 x 7 (22' / Bndl.)",0,"Bndl of 50",12.95,{"$f":"IF(ISBLANK(B12),\"\",C12*E12)","v":0}]
[null,"L Metal 4\" x 4\" x 10'",0,"Ea",4.79,{"$f":"IF(ISBLANK(B13),\"\",C13*E13)","v":0}]
[null,"Plastic Caps 1/2 lb./sq",{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,RoofingDB,2,FALSE))","v":0},{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,RoofingDB,3,FALSE))","v":"Pail"},{"$f":"IF(ISBLANK(B14),\"\",VLOOKUP(B14,RoofingDB,4,FALSE))","v":34.950000000000003},{"$f":"IF(ISBLANK(B14),\"\",C14*E14)","v":0}]
[null,"Roofing Nails - 1-1/4\" - 2 lb./sq"]
[]
[null,"End"]

{"sheet":"GarageDoorDB","index":4,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Garage Door Database"]
["Description","QTY","Unit","Supplier"]
["18x8 Insulated",1,"EA",793.49]
["18x8 Non-Insulated",1,"EA",735.74]
["18x7 Insulated",1,"EA",750.75]
["18x7 Non-Insulated",1,"EA",658.35]
["16x8 Insulated",1,"EA",704.44]
["16x8 Non-Insulated",1,"EA",589.04]
["16x7 Insulated",1,"EA",669.89]
["16x7 Non- Insulated",1,"EA",531.29]
["9x8 Insulated",1,"EA",461.99]
["9x8 Non-Insulated",1,"EA",392.69]
["9x7 Insulated",1,"EA",415.78999999999996]
["9x7 Non-Insulated",1,"EA",346.49]
["8x8 Insulated",1,"EA",438.89]
["8x8 Non-Insulated",1,"EA",369.59]
["8x7 Insulated",1,"EA",323.39]
["8x7 Non-Insulated",1,"EA",288.74]
[]
[]
["1/2 HP Opener",1,"EA",242.55]
["3/4 HP Opener",1,"EA",219.45]
["Keyless Entry",1,"EA",46.2]
["Extra remotes",1,"EA",28.880000000000003]
[]
["Labor - HR",1,"HR",35]
["Labor - EA",1,"EA",250]

{"sheet":"RoofingDB","index":5,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Roofing Database"]
["Description","QTY","Unit","Supplier"]
["Asphalt Shingles - 25 yr. 3 Tab",null,"Sq",30]
["Asphalt Shingles - 30 yr. 3 Tab",null,"Sq",38]
["Asphalt Shingles - 30 yr. Architectural",null,"Sq",48.43]
["Cedar Shakes #1 medium handsplits",null,"Sq",110]
["Cedar Shingles #1",null,"Sq",135]
["Metal Roofing",null,"Sq",90]
["Eagle Tile",null,"Sq",105]
["------------------------------------------------------"]
["Deliver & Stock shingles",null,"Sq",3.5]
["Drip Edge-metal",null,"Ea",3.9]
["15# Tar Paper (Asphalt-impregnated Felt)",null,"4-Sq Roll",10.95]
["30# Tar Paper (Asphalt-impregnated Felt)",null,"2-Sq Roll",10.95]
["Ice and Water Shield - 3' x 75'",null,"2-Sq Roll",77]
["Starter Strip",null,"Sq (T)",38]
["Hip & Ridge Cap",null,"Sq (T)",38]
["Architectural Hip & Ridge Cap",null,"Box",30]
["Ridge Vents",null,"Lf",2.2999999999999998]
["Turtle-back Vents 10 x 14 (1 SF net area)",null,"Ea",15]
["Step Flashing 3 x 4 x 7 (22' / Bndl.)",null,"Bndl of 50",12.95]
["18\" x 10' Valley Flashing",null,"Ea",5.5]
["L Metal 4\" x 4\" x 10'",null,"Ea",4.79]
["Plastic Caps 1/2 lb./sq",null,"Pail",34.950000000000003]
["Simplex Nails-1/2 lb./sq",null,"Lb",0.85]
["Roofing Nails - 1-1/4\" - 2 lb./sq",null,"Lb",0.62]
["Coil Roofing Nails 1\" - 1-1/4\"",null,"Ea",37.950000000000003]
["8d galvanized box nails",null,"Lb",0.64]
["6d galvanized box nails",null,"Lb",0.64]
["4d galvanized box nails",null,"Lb",0.64]
[]
["Labor",null,"SQ",38]