Workbook Sheets Defined,,,,,,,,,
SheetName,Content,,,,,,,,
RawDataSummary,aggregate information from contractor receipts,,,,,,,,
DeconFormDate,list of discrepancies between the claim material salvaged on BPS Deconstruction Forms and the content of contractor receipts (only fill out if there is enough time),,,,,,,,
DumpsterComposition,empty - to be generated by R coding as a summary of composition of materials in dumpster loads,,,,,,,,
Material Weights,weight conversion information on building materials from http://demolitionforum.com/material-weights/ ,,,,,,,,
,,,,,,,,,
Workbook Sheet Descriptions,,,,,,,,,
RawDataSummary,,,,,,,,,
Field Name,Definition,,,,,,Data issues color key,,
year,date information,,,,,,"missing data, cannot compute impacts",,
month,"date information, where month is the mode value from the project timeline",,,,,,missing units or info for translating units,,
house_age,square footage of house listed with the site property ID,,,,,,missing deconMaterialName category,,
house_size,age of the structure at the time of deconstruction calculated as difference between the year field and the year of construction listed with the site property ID,,,,,,"missing other info (recipient, etc)",,
project,address of project on the BPS permit,,,,,,,,
contractor_name,name of deconstruction contractor,,,,,,,,
recipient_type,category indicating the way in which the material or items were removed from the project. These map onto the DeconTool disposition & end of life scenarios (TBD),,,,,,,,
recipient_name,name of the materials destination recipient (not necessarily the hauler),,,,,,,,
listed_quantity,quantity of the materials listed on the raw data reciept,,,,,,,,
listed_units,units associated with the quantity as listed on the raw data reciept,,,,,,,,
deconMaterialName,factor used in DeconTool used to estimate impacts (dumpster was an added category to indicate that material was distinct from an impact category material),,,,,,,,
declaredUnit,units associated with the material in the DeconTool that is used to estimate impacts (not included in the RawDataSummary sheet),,,,,,,,
dimensions,"dimensions of lumber, siding, wood products, roofing, windows, etc",,,,,,,,
dimensional_units,units associated with dimensions,,,,,,,,
description,"material description as listed on the raw data reciept, & other pertinent information for impact analysis",,,,,,,,
notes,"additional material description or any issue with the data, this field not used in the R-data analysis",,,,,,,,
,,,,,,,,,
Lists of unique entries by field,,,,,,,,,
project,house_age,house_size,deconMaterialName,declaredUnit,contractor,,,listed_units,notes
1,112,1622,Carpeting,kg,A,,,lin_ft = lineal feet,lin_ft
2,123,1312,Hardwood Flooring,kg,B,,,BF = board feet,CVG = clear vertical grain
3,115,1111,Inner Door (solid wood),per door,C,,,SF = square feet,RC = rough cut
4,109,800,Inner Door (hollow wood),per door,D,,,LBS = pounds,T&G = tongue & groove
5,123,1187,Outer Door (solid wood),per door,E,,,TONS =  US tonnage,
6,127,1186,Window (double vinyl),sqft,F,,,MT = metric tons,
7,111,1152,Window (double wood),sqft,G,,,count,
8,106,2341,Window (single wood),sqft,,,,,
9,92,947,Cabinets - lower,linear ft,,,,,
10,108,1112,Cabinets  - upper short,linear ft,,,,,
11,127,861,Cabinets - upper long,linear ft,,,,,
12,103,872,MDF,kg,,,,,
13,105,660,Plywood,kg,,,,,
14,110,1632,OSB,kg,,,,,
15,132,1147,Softwood lumber,kg,,,,,
16,120,1434,Hardwood lumber,kg,,,,,
17,117,1328,Cedar shingles,kg,,,,,
18,107,1079,Wood Siding,kg,,,,,
19,115,1026,Aluminum Siding,kg,,,,,
20,111,1153,Vinyl siding,sqft,,,,,
21,108,903,Fibre cement siding,kg,,,,,
22,137,1632,Fiberglass insulation,sqft,,,,,
23,101,840,Fiberglass Tub ,kg,,,,,
24,104,992,Ceramics,kg,,,,,
25,110,947,Cast Iron,kg,,,,,
26,111,1310,Steel Product,kg,,,,,
27,116,1151,Light fixture,per fixture,,,,,
28,110,1322,Furnace appliance,kg,,,,,
29,110,640,Concrete Roofing,kg,,,,,
30,107,660,dumpster,tons,,,,,
31,113,879,,,,,,,
32,102,728,,,,,,,
33,117,1188,,,,,,,
34,122,1282,,,,,,,
35,102,1518,,,,,,,
36,113,882,,,,,,,
37,119,1415,,,,,,,
38,90,1632,,,,,,,
,,,,,,,,,
mean,112,1155,,,,,,,
median,111,1149,,,,,,,
maximum,137,2341,,,,,,,
minimum,90,640,,,,,,,
range,47,1701,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
MaterialWeights,,,,,,,,,
Field Name,Definition,,,,,,,,
material ,"type of material or application, as specified in the source of the information (not specified according to the LCA impact factor material names)",,,,,,,,
weight_units,the conversion factor with units of weight per unit converted,,,,,,,,
added_information,any associated specification to the weight_unit which may affect the use or application of the given conversion factor,,,,,,,,
sources,"the webpage, url, or title/author of article or reference guide; this field should include enough information to verify factors and include in publication (APA style?)",,,,,,,,
,,,,,,,,,
Workbook Issues & Caveats,,,,,,,,,
Assumptions Log,,,,,,,,,
"Unless contractor specifies a hardwood species in the receipt line item, all dimensional lumber is assumed to be Softwood (fir, pine, cedar, redwood, hemlock)",,,,,,,,,
"Unless contractor specifies a softwood species (fir, pine) in the receipt line item, all wood flooring is assumed to be Hardwood",,,,,,,,,
Wood flooring specified as fir is categorized as softwood lumber,,,,,,,,,
Wood products specified as fir or other softwood variety are categorized as softwood lumber regardless of dimension,,,,,,,,,
"All light fixtures are the same whether they are an elaborate glass chandelier, a light/ceiling fan combo, a wall sconce, can light, or an 8 ft garage flourescent with a ballast",,,,,,,,,
"All plumbing fixtures not specified as cast iron, steel, or fiberglass products are ceramics, except bathtubs which are fiberglass unless specified otherwise",,,,,,,,,
"Unless specified otherwise, all pipe and ducting is assumed to be steel products",,,,,,,,,
Missing data on doors: the type is assumed to be Inner (solid wood),,,,,,,,,
Missing data on windows: the type is assumed to be single pane wood,,,,,,,,,
All windows are calculated as 12 sq ft window with 3’ x 4’ frame dimensions,,,,,,,,,
Default weights for doors and fixtures are taken from previous data collection events,,,,,,,,,
"All fractions of pounds for metal and lineal, board, or square feet for wood & finish materials are rounded to the nearest whole unit (LBS or LF/BF/SF) where <0.5 is rounded down and 0.5 and >0.5 is rounded up",,,,,,,,,
Cabinets specified as salvaged where quantity & type information is missing are assumed to be 3LF of lower cabinet,,,,,,,,,
"Where quantity information is missingfor salvage fixtures (lights, plumbing, etc), it is assumed that there is only 1 (count) of the default type ",,,,,,,,,
All dumpster tickets are reported in short tons: 2000 LBS = 1 TON = 907.185 kg,,,,,,,,,
"Appliances and furniture (which includes medicine cabinets and 'built-in shelving' not specified as wood in LF,SF,BF, or LBS)  are not included in the raw data summary",,,,,,,,,
,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
Known Limitations of the Data,,,,,,,,,
,,,,,,,,,
List here limitations in impact factor source data,,,,,,,,,
,,,,,,,,,
,,,,,,,,,
List here limitations from dumpster & waste hauler information ,,,,,,,,,
,material composition of deconstruction project dump containers is qualitatively and quantitatively different from other C&D/demo containers,,,,,,,,
,"assumptions will have to be generated using a combination of reported container compositions, the waste composition report, and material recovery survey information to determine the disposition of materials in dumpster",,,,,,,,
,,,,,,,,,
,,,,,,,,,
List here limitations from raw data,,,,,,,,,
missing information: ,Data issues color key,,,,,,,,
,"missing data, cannot compute impacts",,,,,,,,
,missing units or info for translating units,,,,,,,,
,missing deconMaterialName category,,,,,,,,
,"missing other info (recipient, etc)",,,,,,,,
missing information: ,approximate weight of:,,,,,,,,
,,steel products,"sinks, gutters, architectural metal (posts, railings, etc)",,,,,,
,,ceramics,"toilets, sinks",,,,,,
,,wood products,"railings, stairs, pulldown attic stairs, shelving",,,,,,
