jagomart
digital resources
picture1_Construction Template Excel 40158 | Lbc X Materials Tracking Table


 193x       Filetype XLSX       File size 0.10 MB       Source: living-future.org


File: Construction Template Excel 40158 | Lbc X Materials Tracking Table
sheet 1 instructions materials tracking table living building challenge 30 this tracking tool is for lbc 30 project teams to track materials information for four imperatives i10 i12 i 13 ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Instructions
MATERIALS TRACKING TABLE
Living Building Challenge 3.0


This Tracking Tool is for LBC 3.0 Project Teams to track Materials information for four Imperatives (I-10, I-12, I- 13, and CDPH information for I-08). Supplemental documentation is also required. See the 3.0 Documentation Requirements for full information. This Tracking Table should be provided as part of Audit Documentation in sortable Excel format.


Instructions:
Fill in CSI and General Product Information for every material in the project.
Fill in the Imperative information as applicable. For example I-10 Red List applies to all materials, and all materials costs must be included in the Materials Construction Budget (see note below). Distance information is not required for all products.
For I-12 & I-13, Teams must say "Yes" to double or track costs. Blank cells are treated as "No", therefore the use of "No" is up to the discretion of the team.
Rows may be added through the "insert" function. Row contents &/or formulas can be "pulled down" using the "+" that appears in the right lower corner of selected cells.



Column Specific Notes:
Column Notes
Red List Free Project team must fill in "Yes" or "No" for each product.
Exception No. An Exception Number should be provided for all products with "No" under "Red List Free?"
Wood Product? None
COC No. None
Declare Product? None
Declare Information Sent Declare information must be sent to at least 10 manufacturers not currently in Declare.
Salvaged Product? None
Include Double Salvaged/Declared Value in I-13? Doubling the materials value of salvaged or Declare products is up to the project team, on a product by product basis.
Actual Material Cost
(=> Materials Construction Budget)
Actual cost. Do not adjust cost based on product type. All material costs must be included. Materials that are not tracked for I-13 may be included as "grouped" costs within the column (i.e. framing package vs. 2x4s; sheathing; glulams), or within a "bulk" cost at the bottom (right before the MCB total), as long this is clearly explained or noted in comments.
Materials Subtotal Includes any "doubled" materials costs.
Natural Material Construction?* Natural Material Construction includes certain construction methods that are labor intensive and usually based on low cost, locally sourced materials (e.g. straw bale, cobb, rammed earth, etc).
Labor Cost Only added to Materials + Labor subtotal if adjacent columns are both "Yes".
Include Labor Costs in I-13? Including labor costs for Natural Material Construction is up to the project team, on a product by product basis
Materials + Labor Subtotal Includes both "doubled" materials costs and applicable labor costs.
Track Product for
I-13?
Up to 25% of the total Materials Construction Budget may be excluded from tracking.
Manufacturer Location Information See I-13 Changes in 3.0 in the 3.0 Materials Petal Handbook for when raw materials extraction is relevant.
Living Economy Sourcing
(I-13) Total
None
I-13 Living Economy Zone Calculations None
Amount over/under Minimum Requirement. Excess can be applied to Economy Zones further from project. Please clarify intentions in comments.

Sheet 2: General Material Tracking


MATERIALS TRACKING TABLE

LEGEND























Minimum % of MCB required for Econ. Zone. 20% 30% 25%

Living Building Challenge 3.x
Updated February 9, 2018 (see comment)


Team to fill in























Estimated Minimum $ by Economy Zone $200,000.00 $300,000.00 $250,000.00






Pull down menus







Declare Products Salvaged Products
Actual Material Cost = Materials Const. Budget
(MCB)
Subtotals for Reference
Living Economy Sourcing
(I-13) Total







Project Name
Select
Project Area Units

ESTIMATED
Material Construction Budget (MCB):

Key totals







Min. # Declare Products: 0 Min. # Required 0
Materials Subtotal
Labor Cost
Materials + Labor Subtotal



Actual Total by Economy Zone $0.00 $0.00 $0.00


Formulas & sub-totals







# Installed 0 # Installed 0




Actual Minimum $
to Comply
$0.00 $0.00 $0.00
Project Area


$1,000,000.00
Sample inputs






# Declare Advocay Sent 0


$0 $0 $0 $0
0


Amount Over/Under Minimum Requirement: $0.00 $0.00 $0.00



































CSI Division General Product Information I-08 Healthy Air I-10 Red List I-12 Responsible Industry I-13 Living Economy Sourcing (LES)
I-13 Living Economy Sourcing: Economy Zone Calculations



Number Name Product Type Product Manufacturer Product Name


Primary Ingredients
(2-3)
Red List Free? Exception No.

Wood Product? COC No. Extracted (Stone, Metal or Mineral) Product? Declare Product? Declare Information Sent? Salvaged Product? Include Double Salvaged/Declared Value in LES? Actual Material Cost

(=> Materials Construction Budget)
Materials Subtotal Natural Material Construction?* Labor Cost Include Labor Costs in I-13? Materials + Labor Subtotal Track Product for
I-13?
Living Economy Sourcing
(I-13) Total

Manufacturer Location
(or Raw Materials Source Location when applicable)
Totals by Economy Zone:
Manufacturer Contact information (optional) CDPH Applies? CDPH Compliant? Wet Applied Product? Meets
SCAQMD 1168 or CARB 2007 SCM

Manufacturer Name Location (city, state/province, country) Distance from Project Site (km) 500 km
(310 miles)
1000 km
(621 miles)
5000 km
(3107 miles)
00 00 00 Sample Entry Flooring Acme Co Eco-floor
Yes Yes Cork, binder No I10-E1 Yes 1168 Yes
Yes No
Yes No 3,475 3475 Yes 100 Yes 3575 Yes 3575
Acme Co City, State, USA 25 3575
01 00 00 General Requirements


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

02 00 00 Existing Conditions


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

03 00 00 Concrete


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

04 00 00 Masonry


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

05 00 00 Metals


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

06 00 00 Wood, Plastics, and Composites


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

07 00 00 Thermal and Moisture Protection


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

08 00 00 Openings


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

09 00 00 Finishes


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

10 00 00 Specialties


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

11 00 00 Equipment


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

12 00 00 Furnishings


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

13 00 00 Special Construction


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

14 00 00 Conveying Equipment


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

21 00 00 Fire Suppression


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

22 00 00 Plumbing


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

23 00 00 Heating, Ventilating, and Air-Conditioning (HVAC)


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

25 00 00 Integrated Automation


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

26 00 00 Electrical


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

27 00 00 Communications


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

28 00 00 Electronic Safety and Security


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

31 00 00 Earthwork


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

32 00 00 Exterior Improvements


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

33 00 00 Utilities


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

34 00 00 Transportation


















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0






















$0


$0

0

DO NOT INSERT ROWS BELOW THIS LINE; Insert a "copied" row within the table boundary to preserve formulas/ formats.








"Bulk" costs not included individually above:
















The words contained in this file might help you see if this file matches what you are looking for:

...Sheet instructions materials tracking table living building challenge this tool is for lbc project teams to track information four imperatives i and cdph supplemental documentation also required see the requirements full should be provided as part of audit in sortable excel format fill csi general product every material imperative applicable example red list applies all costs must included construction budget note below distance not products amp say quot yes double or blank cells are treated no therefore use up discretion team rows may added through insert function row contents formulas can pulled down using that appears right lower corner selected column specific notes free each exception an number with under wood none coc declare sent at least manufacturers currently salvaged include salvageddeclared value doubling on a by basis actual cost gt do adjust based type tracked grouped within ie framing package vs xs sheathing glulams bulk bottom before mcb total long clearly explained not...

no reviews yet
Please Login to review.