{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Existing Home Checklist"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"Existing Home Checklist","index":0,"n_rows":358,"n_cols":23,"rows_kept":358,"cut":false,"hidden":false,"merged":[[3,13,3,15],[4,13,4,15],[1,0,6,9],[2,13,2,15],[2,10,2,12],[4,10,4,12],[126,11,126,15],[7,0,7,9],[88,11,88,15],[8,11,8,15],[41,11,41,15],[48,11,48,15],[62,11,62,15],[120,11,120,15],[135,11,135,15],[147,11,147,15],[206,11,206,15],[227,11,227,15],[257,11,257,15],[249,11,249,15],[181,11,181,15],[184,11,184,15],[232,11,232,15]]}
["GreenPoint Rated Existing Home Checklist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["A home is only GreenPoint Rated if all features are verified by a Certified GreenPoint Rater through Build It Green. GreenPoint Rated is provided as a public service by Build It Green, a professional non-profit whose mission is to promote healthy, energy and resource efficient buildings in California. \n\nThis checklist is used to track projects seeking a Whole House or Elements Label using the GreenPoint Rated Existing Home Rating System.  The  minimum requirements for each lable are listed in the project summary at the end of this checklist.  Selected measures can be awarded points allocated by the percentage of presence of the measure in the home.  The measure or practice must be found in at least 10% of the home to earn points.\n\nColumn A is a dropdown menue with the options of \"Yes\", \"No\", or \"TBD\"  or a range of percentages to allocate points. Select the appropriate dropdown and the apropriate points will appear in the yellow \"points acheived\" column.\n\nThe criteria for the green building practices listed below are described in the GreenPoint Rated Existing Home Rating Manual, available at www.builditgreen.org/greenpointrated  \n\nGreenPoint Rated Existing Home Checklist  version 2.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T2>0,1,0)","v":0},{"$f":"IF(A357=\"Existing Home\",K312,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Enter Label: ",null,null,"Whole House"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T4=\"Achieved\",1,0)","v":0},{"$f":"IF(AND(A358=\"GreenPoint Elements\",A336=\"Project has met all recommended minimum requirements for GreenPoint Rated Elements\"),\"Achieved\",0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Points Achieved:",null,null,{"$f":"K312","v":0},null,null,null,null,{"$f":"IF(T5=\"Not Achieved\",1,0)","v":0},{"$f":"IF(AND(A358=\"GreenPoint Elements\",A336=\"Project has not yet met the following recommended minimum requirements for GreenPoint Rated Elements:\"),\"Not Achieved\",0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(N3=\"Whole House\",20,8)","v":20},{"$f":"IF(N3=\"Whole House\",5,2)","v":5},{"$f":"IF(N3=\"Whole House\",6,2)","v":6},{"$f":"IF(N3=\"Whole House\",8,4)","v":8}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L312","v":0},{"$f":"M312","v":0},{"$f":"N312","v":0},{"$f":"O312","v":0},{"$f":"P312","v":0}]
["Project Name",null,null,null,null,null,null,null,null,null,"  Points Achieved","  Community","  Energy","  IAQ/Health","  Resources","  Water"]
["AA. COMMUNITY ",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(A10=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B10","v":false},null,{"$f":"IF(C10,2,0)","v":0},null,null,null,null,"    1.  Home is Located within 1/2 Mile of a Major Transit Stop",{"$f":"SUM(D10:I10)","v":0},2]
[null,null,null,null,null,null,null,null,null,"2. Compact Development & House Size"]
[0,{"$f":"IF(A12>0,TRUE,FALSE)","v":false},{"$f":"B12","v":false},null,{"$f":"IF(A12>=25,2,IF(A12>=20,1.5,IF(A12>=15,1,IF(A12>=10,0.5,0))))","v":0},null,null,{"$f":"IF(A12>=25,2,IF(A12>=20,1.5,IF(A12>=15,1,IF(A12>=10,0.5,0))))","v":0},null,"    a. Density of 10 Units per Acre or Greater (Enter units/acre)",{"$f":"SUM(D12:I12)","v":0},2,null,null,2]
["TBD",{"$f":"IF(A13=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B13","v":false},null,null,null,null,{"$f":"IF(C13,5,0)","v":0},null,"    b. Home Size Efficiency (5 points is average, points awarded based on home size)",{"$f":"H13","v":0},null,null,null,"1--9"]
[null,null,null,null,null,null,null,null,null,"3. Pedestrian and Bicycle Access/ Alternative Transportation "]
[null,null,null,null,null,null,null,null,null,"     a. Site has Pedestrian Access Within ½ Mile of neighborhood services:   "]
[null,null,null,null,null,null,null,null,null,"   TIER 1:   1) Day Care               2) Community Center           3) Public Park"]
[null,null,null,null,null,null,null,null,null,"                   4) Drug Store            5) Restaurant                           6) School"]
[null,null,null,null,null,null,null,null,null,"                   7) Library                     8) Farmer's Market               9) After School Programs"]
[null,null,null,null,null,null,null,null,null,"                  10) Convenience Store Where Meat & Produce are Sold"]
[null,null,null,null,null,null,null,null,null,"     TIER 2:  1) Bank                 2) Place of Worship                    3) Laundry/Cleaners"]
[null,null,null,null,null,null,null,null,null,"                     4) Hardware         5) Theater/Entertainment         6) Fitness/Gym"]
[null,null,null,null,null,null,null,null,null,"                     7) Post Office    8) Senior Care Facility                9) Medical/Dental"]
[null,null,null,null,null,null,null,null,null,"                    10) Hair Care       11) Commercial Office of Major Employer   12) Full \n                     Supermarket"]
["TBD",{"$f":"IF(A24=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B24","v":false},null,{"$f":"IF(OR(C25,C24),1,0)","v":0},null,null,null,null,"        5 Services Listed Above (Tier 2 Services count as 1/2 Service Value)",{"$f":"SUM(D24:I24)","v":0},1]
["TBD",{"$f":"IF(A25=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B25","v":false},null,{"$f":"IF(C25,1,0)","v":0},null,null,null,null,"       10 Services Listed Above (Tier 2 Services count as 1/2 Service Value)",{"$f":"SUM(D25:I25)","v":0},1]
["TBD",{"$f":"IF(A26=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B26","v":false},null,{"$f":"IF(C26,1,0)","v":0},null,null,null,null,"    b. Access to A Dedicated Pedestrian Pathway to Places of Recreational Interest within 1/2 Mile",{"$f":"SUM(D26:I26)","v":0},1]
["TBD",{"$f":"IF(A27=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B27","v":false},null,{"$f":"IF(C27,1,0)","v":0},null,null,null,null,"    c. At Least Two of the Following Traffic-Calming Strategies Installed within 1/4 mile: ",{"$f":"SUM(D27:I27)","v":0},1]
[null,null,null,null,null,null,null,null,null,"Designated Bicycle Lanes are Present on Roadways;"]
[null,null,null,null,null,null,null,null,null,"Ten-Foot Vehicle Travel Lanes;"]
[null,null,null,null,null,null,null,null,null,"Street Crossings Closest to Site are Located Less Than 300 Feet Apart;"]
[null,null,null,null,null,null,null,null,null,"Streets Have Rumble Strips, Bulbouts, Raised Crosswalks or Refuge Islands"]
[null,null,null,null,null,null,null,null,null,"4. Safety & Social Gathering"]
["TBD",{"$f":"IF(A33=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B33","v":false},null,{"$f":"IF(C33,1,0)","v":0},null,null,null,null,"    a. Front Entrance Has Views from the Inside to Outside Callers",{"$f":"SUM(D33:I33)","v":0},1]
["TBD",{"$f":"IF(A34=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B34","v":false},null,0,null,null,null,null,"    b. Front Entrance Can be Seen from the Street and/or from Other Front Doors",{"$f":"SUM(D34:I34)","v":0},1]
["TBD",{"$f":"IF(A35=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B35","v":false},null,0,null,null,null,null,"    c. Porch (min. 100sf) Oriented to Streets and Public Spaces",{"$f":"SUM(D35:I35)","v":0},1]
[null,null,null,null,null,null,null,null,null,"5. Diverse Households"]
["TBD",{"$f":"IF(A37=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B37","v":false},null,0,null,null,null,null,"     a. Home Has at Least One Zero-Step Entrance (prerequiste for 5b. And 5c.)",{"$f":"SUM(D37:I37)","v":0},1]
["TBD",{"$f":"IF(AND(B37,A38=\"Yes\"),TRUE,FALSE)","v":false},{"$f":"B38","v":false},null,0,null,null,null,null,"     b. All Main Floor Interior Doors & Passageways Have a Min. 32-Inch Clear Passage Space",{"$f":"SUM(D38:I38)","v":0},1]
["TBD",{"$f":"IF(AND(B37,A39=\"Yes\"),TRUE,FALSE)","v":false},{"$f":"B39","v":false},null,0,null,null,null,null,"     c. Home includes at Least a Half-Bath on the Ground Floor with Blocking for Grab Bars",{"$f":"SUM(D39:I39)","v":0},1]
["TBD",{"$f":"IF(A40=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B40","v":false},null,0,null,null,null,null,"     d. Lot Includes Full-Function Independent Rental Unit",{"$f":"SUM(D40:I40)","v":0},1]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Community = 26",{"$f":"SUM(K10:K40)","v":0}]
["A. SITE",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(A43=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B43","v":false},null,{"$f":"IF(C43,1,0)","v":0},null,null,null,{"$f":"IF(C43,1,0)","v":0},"1. Protect Existing Topsoil from Erosion and Reuse after Construction",{"$f":"SUM(D43:I43)","v":0},1,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"2. Divert Construction and Demolition Waste"]
["TBD",{"$f":"IF(A45=\"Yes\",TRUE,FALSE)","v":false},{"$f":"IF(A45=\"N/A\",TRUE,FALSE)","v":false},null,null,null,null,null,null,"     a. Divert All Cardboard, Concrete, Asphalt and Metals (Required for both Whole \n         House and Elements, if Applicable) ",{"$f":"IF(A45=\"Yes\",\"Y\",IF(A45=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,null,"R"]
["TBD",{"$f":"IF(A46=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B46","v":false},null,null,null,null,{"$f":"IF(C46,2,0)","v":0},null,"     b. Divert 25% C&D Waste Excluding All Cardboard, Concrete, Asphalt and Metals  ",{"$f":"SUM(D46:I46)","v":0},null,null,null,2]
["TBD",{"$f":"IF(A47=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B47","v":false},null,null,null,{"$f":"IF(C47,2,0)","v":0},null,null,"3. Construction IAQ Management Plan ",{"$f":"SUM(D47:I47)","v":0},null,null,2]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Site = 6",{"$f":"SUM(K43:K47)","v":0}]
["B. FOUNDATION",null,null,null,null,null,null,null,null,null,null,"Possible Points",null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF(A50>0,(LOOKUP(A50,$V$9:$V$11,$U$9:$U$11)),0)","v":0},{"$f":"IF(B50=5,1,A50)","v":0},null,null,null,null,null,null,"1. Replace Portland Cement in Concrete with Recycled Flyash or Slag "]
["TBD",{"$f":"IF(OR(A51=\"TBD\",A51=\"No\"),FALSE,IF(B52,TRUE,TRUE))","v":false},{"$f":"B51","v":false},null,null,null,null,{"$f":"IF(C51,IF(A51=\"≥90%\",1,A51),0)","v":0},null,"     a. Minimum 20% Flyash and/or Slag Content",{"$f":"H51","v":0},null,null,null,1]
["TBD",{"$f":"IF(OR(A52=\"TBD\",A52=\"No\"),FALSE,TRUE)","v":false},{"$f":"B52","v":false},null,null,null,null,{"$f":"IF(C52,IF(A52=\"≥90%\",1,A52),0)","v":0},null,"     b. Minimum 30% Flyash and/or Slag Content",{"$f":"H52","v":0},null,null,null,1]
["TBD",{"$f":"IF(A53=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B53","v":false},null,null,null,null,null,null,"2. Moisture Source Verification and Correction (Required for Whole House)",{"$f":"IF(A53=\"Yes\",\"Y\",IF(A53=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,"R","R"]
[null,null,null,null,null,null,null,null,null,"3. Retrofit Crawl Space to Control Moisture"]
["TBD",{"$f":"IF(A55=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B55","v":false},null,null,{"$f":"IF(C55,2,0)","v":0},null,null,null,"     a. Control Ground Moisture with Vapor Barrier  ",{"$f":"SUM(D55:I55)","v":0},null,null,2]
["TBD",false,{"$f":"B56","v":false},null,null,null,{"$f":"IF(C56,2,0)","v":0},null,null,"     b. Foundation Drainage System",0,null,null,null,2]
["TBD",false,{"$f":"B57","v":false},null,null,null,null,{"$f":"IF(C57,1,0)","v":0},null,"4. Pest Inspection and Correction",0,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"5. Design and Build Structural Pest Controls"]
["TBD",false,{"$f":"B59","v":false},null,null,null,null,{"$f":"IF(C59,1,0)","v":0},null,"     a. Install Termite Shields & Separate All Exterior Wood-to-Concrete Connections by  \n         Metal or Plastic Fasteners/Dividers",0,null,null,null,1]
["TBD",false,{"$f":"B60","v":false},null,null,null,null,{"$f":"IF(C60,1,0)","v":0},null,"     b. All New Plants Have Trunk, Base, or Stem Located At Least 36 Inches from Foundation",0,null,null,null,1]
["TBD",false,{"$f":"B61","v":false},null,null,null,{"$f":"IF(C61,1,0)","v":0},null,null,"6. Radon Testing and Correction or Radon Resistant Construction ",0,null,null,1]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Foundation = 10",{"$f":"SUM(K51:K61)","v":0}]
["C.  LANDSCAPE",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["No",{"$f":"IF(A64=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B64","v":false},null,null,null,null,null,null,"Is the landscape area <15% of the total site area? (only 3 points available in this section for projects with <15% landscape area)"]
[null,null,null,null,null,null,null,null,null,"1.  Resource-Efficient Landscapes"]
["TBD",{"$f":"IF(A66=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B66","v":false},null,null,null,null,null,{"$f":"IF(C66,1,0)","v":0},"     a. No Invasive Species Listed by Cal-IPC Are Planted",{"$f":"SUM(D66:I66)","v":0},null,null,null,null,1]
["TBD",{"$f":"IF(A67=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B67","v":false},null,null,null,null,{"$f":"IF(C67,1,0)","v":0},null,"     b. No Plant Species Require Shearing",{"$f":"SUM(D67:I67)","v":0},null,null,null,1]
["TBD",false,{"$f":"B68","v":false},null,null,null,null,null,{"$f":"IF(B68,IF(B64,MIN(3,MAX(0,3-SUM(K66:K67))),3),0)","v":0},"     c. 50% of Plants Are California Natives or Mediterranean Cimate Species ",{"$f":"SUM(D68:I68)","v":0},null,null,null,null,3]
["TBD",false,{"$f":"B69","v":false},null,{"$f":"IF(B69,IF(B64,MIN(1,MAX(0,3-SUM(K66:K68))),1),0)","v":0},null,null,null,null,"2. Fire-Safe Landscaping Techniques ",{"$f":"SUM(D69:I69)","v":0},1]
[null,null,null,null,null,null,null,null,{"$f":"IF(AND(B64,C68,SUM(I66,H67)=0),3,0)","v":0},"3. Minimal Turf Areas"]
["TBD",false,{"$f":"B71","v":false},null,null,null,null,null,{"$f":"IF(B71,IF($B$64,MIN(2,MAX(0,3-SUM($K$66:K70))),2),0)","v":0},"     a. Turf Not Installed on Slopes Exceeding 10% or in Areas Less than 8 Feet Wide",{"$f":"SUM(D71:I71)","v":0},null,null,null,null,2]
["TBD",false,{"$f":"B72","v":false},null,null,null,null,null,{"$f":"IF(B72,IF($B$64,MIN(2,MAX(0,3-SUM($K$66:K71))),2),0)","v":0},"     b. Turf is <25% of Landscaped Area ",{"$f":"SUM(D72:I72)","v":0},null,null,null,null,2]
["TBD",false,{"$f":"B73","v":false},null,null,null,null,null,{"$f":"IF(B73,IF($B$64,MIN(2,MAX(0,3-SUM($K$66:K72))),2),0)","v":0},"     c. Turf is <10% of Landscaped Area or eliminated ",{"$f":"SUM(D73:I73)","v":0},null,null,null,null,2]
["TBD",false,{"$f":"B74","v":false},null,{"$f":"IF($B$74,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K$73))),1),0)","v":0},{"$f":"IF($B$74,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K$73,E74))),1),0)","v":0},null,null,{"$f":"IF($B$74,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K$73,E74:F74))),1),0)","v":0},"4. Shade Trees Planted    ",{"$f":"SUM(D74:I74)","v":0},1,1,null,null,1]
["TBD",false,{"$f":"B75","v":false},null,null,null,null,null,{"$f":"IF(B75,IF($B$64,MIN(2,MAX(0,3-SUM($K$66:K74))),2),0)","v":0},"5. Plants Grouped by Water Needs (Hydrozoning)  ",{"$f":"SUM(D75:I75)","v":0},null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"6. High-Efficiency Irrigation Systems Installed"]
["TBD",false,{"$f":"B77","v":false},null,null,null,null,null,{"$f":"IF(B77,IF($B$64,MIN(2,MAX(0,3-SUM($K$66:K76))),2),0)","v":0},"     a. System Uses Only Low-Flow Drip, Bubblers, or Low-flow Sprinklers",{"$f":"SUM(D77:I77)","v":0},null,null,null,null,2]
["TBD",false,false,null,null,null,null,null,{"$f":"IF(B78,IF($B$64,MIN(3,MAX(0,3-SUM($K$66:K77))),3),0)","v":0},"     b. System Has Smart Controllers",0,null,null,null,null,3]
["TBD",false,false,null,null,null,null,null,{"$f":"IF($B$79,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K$78))),1),0)","v":0},"7. Compost and Recycle Garden Trimmings on Site ",0,null,null,null,null,1]
["TBD",{"$f":"IF(OR(A80=\"TBD\",A80=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,null,{"$f":"IF(B80,IF($B$64,MIN(IF(C80,IF(A80=\"≥90%\",2,2*A80),0),MAX(0,3-SUM($K$66:K79))),IF(C80,IF(A80=\"≥90%\",2,2*A80),0)),0)","v":0},"8. Mulch in All Planting Beds to the Greater of 2 Inches or Local Water Ordinance Requirement  ",0,null,null,null,null,2]
["TBD",{"$f":"IF(OR(A81=\"TBD\",A81=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,{"$f":"IF($B$81,IF($B$64,MIN(IF(C81,IF(A81=\"≥90%\",1,A81),0),MAX(0,3-SUM($K$66:$K$80))),IF(C81,IF(A81=\"≥90%\",1,A81),0)),0)","v":0},null,"9. Use Environmentally Preferable Materials for Non-Plant Landscape Elements and Fencing",0,null,null,null,1]
["TBD",{"$f":"IF(A82=\"Yes\",TRUE,FALSE)","v":false},false,null,{"$f":"IF($B$82,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K$81))),1),0)","v":0},null,null,null,null,"10. Light Pollution Reduced by Shielding Fixtures and Directing Light Downward",0,1]
[null,null,null,null,null,null,null,null,null,"11.  Rain Water Harvesting System (1 point for ≤ 350 gallons, 2 points for > 350 gallons)"]
["TBD",{"$f":"IF(OR(B85,B86,A84=\"Yes\"),TRUE,FALSE)","v":false},{"$f":"B84","v":false},null,null,null,null,null,{"$f":"IF($B84,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K83,K85:K86))),1),0)","v":0},"a. Cistern(s) is Less Than 750 Gallons",{"$f":"SUM(D84:I84)","v":0},null,null,null,null,1]
["TBD",{"$f":"IF(OR(B86,A85=\"Yes\"),TRUE,FALSE)","v":false},{"$f":"B85","v":false},null,null,null,null,null,{"$f":"IF($B85,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K82,K86))),1),0)","v":0},"b. Cistern(s) is 750 to 2,500 Gallons",{"$f":"SUM(D85:I85)","v":0},null,null,null,null,1]
["TBD",{"$f":"IF(A86=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B86","v":false},null,null,null,null,null,{"$f":"IF($B86,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K82))),1),0)","v":0},"c. Cistern(s) is Greater Than 2,500 Gallons",{"$f":"SUM(D86:I86)","v":0},null,null,null,null,1]
["TBD",{"$f":"IF(A87=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B87","v":false},null,null,null,null,{"$f":"IF($B87,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K86))),1),0)","v":0},{"$f":"IF($B87,IF($B$64,MIN(1,MAX(0,3-SUM($K$66:$K86,H87))),1),0)","v":0},"12. Soil Amended with Compost",{"$f":"SUM(D87:I87)","v":0},null,null,null,1,1]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Landscape = 32",{"$f":"SUM(K64:K87)","v":0}]
["D. STRUCTURAL FRAME & BUILDING ENVELOPE",null,{"$f":"B89","v":0},null,null,null,null,null,null,null,null,"Possible Points"]
[null,null,null,null,null,null,null,null,null,"1. Optimal Value Engineering"]
["TBD",{"$f":"IF(OR(A91=\"TBD\",A91=\"No\"),FALSE,TRUE)","v":false},{"$f":"B91","v":false},null,null,null,null,{"$f":"IF(C91,IF(A91=\"≥90%\",1,A91),0)","v":0},null,"     a. Place Rafters & Studs at 24-Inch On Center Framing",{"$f":"SUM(D91:I91)","v":0},null,null,null,1]
["TBD",{"$f":"IF(OR(A92=\"TBD\",A92=\"No\"),FALSE,TRUE)","v":false},{"$f":"B92","v":false},null,null,null,null,{"$f":"IF(C92,IF(A92=\"≥90%\",1,A92),0)","v":0},null,"     b. Size Door & Window Headers for Load",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A93=\"TBD\",A93=\"No\"),FALSE,TRUE)","v":false},{"$f":"B93","v":false},null,null,null,null,{"$f":"IF(C93,IF(A93=\"≥90%\",1,A93),0)","v":0},null,"     c. Use Only Jack & Cripple Studs Required for Load",0,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"2. Use Engineered Lumber"]
["TBD",{"$f":"IF(OR(A95=\"TBD\",A95=\"No\"),FALSE,TRUE)","v":false},{"$f":"B95","v":false},null,null,null,null,{"$f":"IF(C95,IF(A95=\"≥90%\",1,A95),0)","v":0},null,"     a. Engineered Beams & Headers",0,null,null,null,1]
["TBD",false,false,null,null,{"$f":"IF(C96,IF(A96=\"≥90%\",1,A96),0)","v":0},null,null,null,"     b. Insulated Headers",0,null,1]
["TBD",false,false,null,null,null,null,{"$f":"IF(C97,IF(A97=\"≥90%\",1,A97),0)","v":0},null,"     c. Engineered Lumber for Floors",0,null,null,null,1]
["TBD",false,false,null,null,null,null,{"$f":"IF(C98,IF(A98=\"≥90%\",1,A98),0)","v":0},null,"d. Engineered Lumber for Roof Rafters",0,null,null,null,1]
["TBD",false,false,null,null,null,null,{"$f":"IF(C99,IF(A99=\"≥90%\",1,A99),0)","v":0},null,"     e. Engineered or Finger-Jointed Studs for Vertical Applications",0,null,null,null,1]
["TBD",false,false,null,null,null,null,{"$f":"IF(C100,IF(A100=\"≥90%\",1,A100),0)","v":0},null,"     f.  Oriented Strand Board for Sublfoor",0,null,null,null,1]
["TBD",false,false,null,null,null,null,{"$f":"IF(C101,IF(A101=\"≥90%\",1,A101),0)","v":0},null,"     g. Oriented Strand Board Wall and Roof Sheathing",0,null,null,null,1]
[null,null,null,null,null,null,null,{"$f":"IF(C102,1,0)","v":0},null,"3. FSC Certified Wood"]
["TBD",{"$f":"IF(OR(A103=\"TBD\",A103=\"No\"),FALSE,TRUE)","v":false},{"$f":"B103","v":false},null,null,null,null,{"$f":"IF(C103,IF(A103=\"≥90%\",4,4*A103),0)","v":0},null,"     a. Dimensional Lumber, Studs, and Timber",{"$f":"SUM(E103:I103)","v":0},null,null,null,4]
["TBD",{"$f":"IF(OR(A104=\"TBD\",A104=\"No\"),FALSE,TRUE)","v":false},{"$f":"B104","v":false},null,null,null,null,{"$f":"IF(C104,IF(A104=\"≥90%\",2,2*A104),0)","v":0},null,"     b. Panel Products",{"$f":"SUM(E104:I104)","v":0},null,null,null,2]
[null,null,null,null,null,null,null,null,null,"4. Solid Wall Systems (includes SIPs, ICFs, & Any Non-Stick Frame Assembly)"]
["TBD",{"$f":"IF(OR(A106=\"TBD\",A106=\"No\"),FALSE,TRUE)","v":false},{"$f":"B106","v":false},null,null,{"$f":"IF(C106,IF(A106=\"≥90%\",2, 2*A106),0)","v":0},null,{"$f":"IF(C106,IF(A106=\"≥90%\",2,2*A106),0)","v":0},null,"     a. Floors",0,null,2,null,2]
["TBD",{"$f":"IF(OR(A107=\"TBD\",A107=\"No\"),FALSE,TRUE)","v":false},{"$f":"B107","v":false},null,null,{"$f":"IF(C107,IF(A107=\"≥90%\",2,2*A107),0)","v":0},null,{"$f":"IF(C107,IF(A107=\"≥90%\",2,2*A107),0)","v":0},null,"     b. Walls",0,null,2,null,2]
["TBD",{"$f":"IF(OR(A108=\"TBD\",A108=\"No\"),FALSE,TRUE)","v":false},{"$f":"B108","v":false},null,null,{"$f":"IF(C108,IF(A108=\"≥90%\",2,2*A108),0)","v":0},null,{"$f":"IF(C108,IF(A108=\"≥90%\",2,2*A108),0)","v":0},null,"     c. Roofs",0,null,2,null,2]
[null,null,null,null,null,null,null,null,null,"5.  Reduce Pollution Entering the Home from the Garage "]
["TBD",{"$f":"IF(A110=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B110","v":false},null,null,null,{"$f":"IF(C110,1,0)","v":0},null,null,"      a Tightly Seal the Air Barrier between Garage and Living Area",0,null,null,1]
["TBD",{"$f":"IF(A111=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B111","v":false},null,null,null,{"$f":"IF(C111,1,0)","v":0},null,null,"      b. Install Garage Exhaust Fan OR Have a Detached Garage",0,null,null,1]
["TBD",{"$f":"IF(OR(A112=\"TBD\",A112=\"No\"),FALSE,TRUE)","v":false},{"$f":"B112","v":false},null,null,{"$f":"IF(C112,IF(A112=\"≥90%\",1,A112),0)","v":0},null,null,null,"6. Energy Heels on Roof Trusses (75% of Attic Insulation Height at Outside Edge of Exterior Wall)",0,null,1]
[null,null,null,null,null,null,null,null,null,"7. Overhangs and Gutters "]
["TBD",{"$f":"IF(OR(A114=\"TBD\",A114=\"No\"),FALSE,TRUE)","v":false},{"$f":"B114","v":false},null,null,null,null,{"$f":"IF(C114,IF(A114=\"≥90%\",1,A114),0)","v":0},null,"     a. Minimum 16-Inch Overhangs and Gutters",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A115=\"TBD\",A115=\"No\"),FALSE,TRUE)","v":false},{"$f":"B115","v":false},null,null,{"$f":"IF(C115,IF(A115=\"≥90%\",1,A115),0)","v":0},null,null,null,"     b. Minimum 24-Inch Overhangs and Gutters",0,null,1]
[null,null,null,null,null,null,null,null,null,"8. Retrofit/ Upgrade Structure for Lateral Load Reinforcement for Wind or Seismic "]
["TBD",{"$f":"IF(A117=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B117","v":false},null,null,null,null,{"$f":"IF(OR(C117,C118),1,0)","v":0},null," a. Partial Lateral Load Reinforcement  Upgrades/ Retrofits",{"$f":"H117","v":0},null,null,null,1]
["TBD",{"$f":"IF(A118=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B118","v":false},null,null,null,null,{"$f":"IF(C118,2,0)","v":0},null," b. Lateral Load Reinforcement Upgrades/ Retrofits for Entire home",{"$f":"H118","v":0},null,null,null,2]
["TBD",{"$f":"IF(A119=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B119","v":false},null,null,null,null,null,null,"9. Sound Exterior Assemblies (Required for Whole House)",{"$f":"IF(A119=\"Yes\",\"Y\",IF(A119=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,null,"R"]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Structural Frame & Building Envelope = 36",{"$f":"SUM(K91:K119)","v":0}]
["E. EXTERIOR FINISH",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(OR(A122=\"TBD\",A122=\"No\"),FALSE,TRUE)","v":false},{"$f":"B122","v":false},null,null,null,null,{"$f":"IF(C122,IF(A122=\"≥90%\",2,2*A122),0)","v":0},null,"1. Recycled-Content (No Virgin Plastic) or FSC-Certified Wood Decking",{"$f":"SUM(D122:I122)","v":0},null,null,null,2]
["TBD",{"$f":"IF(OR(A123=\"TBD\",A123=\"No\"),FALSE,TRUE)","v":false},{"$f":"B123","v":false},null,null,null,null,{"$f":"IF(C123,IF(A123=\"≥90%\",2,2*A123),0)","v":0},null,"2. Rain Screen Wall System Installed",{"$f":"SUM(D123:I123)","v":0},null,null,null,2]
["TBD",{"$f":"IF(OR(A124=\"TBD\",A124=\"No\"),FALSE,TRUE)","v":false},{"$f":"B124","v":false},null,null,null,null,{"$f":"IF(C124,IF(A124=\"≥90%\",1,A124),0)","v":0},null,"3. Durable & Noncombustible Cladding Materials",{"$f":"SUM(D124:I124)","v":0},null,null,null,1]
["TBD",{"$f":"IF(OR(A125=\"TBD\",A125=\"No\"),FALSE,TRUE)","v":false},{"$f":"B125","v":false},null,null,null,null,{"$f":"IF(C125,IF(A125=\"≥90%\",2,2*A125),0)","v":0},null,"4. Durable & Fire-Resistant Roofing Materials or Assembly",{"$f":"SUM(D125:I125)","v":0},null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Exterior Finish = 7",{"$f":"SUM(K122:K125)","v":0}]
["F. INSULATION",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
[null,null,null,null,null,null,null,null,null,"1. Install Insulation with 30% Post-Consumer Recycled Content"]
["TBD",{"$f":"IF(OR(A129=\"TBD\",A129=\"No\"),FALSE,TRUE)","v":false},{"$f":"B129","v":false},null,null,null,null,{"$f":"IF(C129,IF(A129=\"≥90%\",1,A129),0)","v":0},null,"     a. Walls and Floors",{"$f":"SUM(D129:I129)","v":0},null,null,null,1]
["TBD",{"$f":"IF(OR(A130=\"TBD\",A130=\"No\"),FALSE,TRUE)","v":false},{"$f":"B130","v":false},null,null,null,null,{"$f":"IF(C130,IF(A130=\"≥90%\",1,A130),0)","v":0},null,"     b. Ceilings",0,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"2. Install Insulation that is Low-Emitting (Certified CA Residential Section 01350)"]
["TBD",{"$f":"IF(OR(A132=\"TBD\",A132=\"No\"),FALSE,TRUE)","v":false},{"$f":"B132","v":false},null,null,null,{"$f":"IF(C132,IF(A132=\"≥90%\",1,A132),0)","v":0},null,null,"     a. Walls and Floors",0,null,null,1]
["TBD",{"$f":"IF(OR(A133=\"TBD\",A133=\"No\"),FALSE,TRUE)","v":false},{"$f":"B133","v":false},null,null,null,{"$f":"IF(C133,IF(A133=\"≥90%\",1,A133),0)","v":0},null,null,"     b. Ceilings",0,null,null,1]
["TBD",{"$f":"IF(OR(A134=\"TBD\",A134=\"No\"),FALSE,TRUE)","v":false},{"$f":"B134","v":false},null,null,{"$f":"IF(C134,IF(A134=\"≥90%\",1,A134),0)","v":0},null,null,null,"3. Inspect Quality of Insulation Installation before Applying Drywall",0,null,1]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Insulation = 5",{"$f":"SUM(K128:K134)","v":0}]
["G. PLUMBING",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
[null,null,null,null,null,null,null,null,null,"1. Distribute Domestic Hot Water Efficiently"]
["TBD",{"$f":"IF(OR(A138=\"TBD\",A138=\"No\"),FALSE,TRUE)","v":false},{"$f":"B138","v":false},null,null,{"$f":"IF(C138,IF(A138=0.25,0.5,1),0)","v":0},null,null,{"$f":"IF(C138,IF(A138=0.25,0.5,1),0)","v":0},"     a. Insulate All Accessible Hot Water Pipes (prerequisite for 1b. and 1c.)",{"$f":"SUM(F138:I138)","v":0},null,1,null,null,1]
["TBD",{"$f":"IF(AND(B138,A139=\"Yes\"),TRUE,FALSE)","v":false},{"$f":"B139","v":false},null,null,{"$f":"IF(AND(C139,$C$138>0),1,0)","v":0},null,null,{"$f":"IF(AND(C139,C138>0),1,0)","v":0},"     b.  Locate Water Heater Within 12' Of All Water Fixtures, as measured in plan",{"$f":"SUM(F139:I139)","v":0},null,1,null,null,1]
["TBD",{"$f":"IF(AND(B138,A140=\"Yes\"),TRUE,FALSE)","v":false},false,null,null,{"$f":"IF(AND(C140,$C$138>0),1,0)","v":0},null,null,{"$f":"IF(AND(C140,C138>0),1,0)","v":0},"     c.  Install On-Demand Circulation Control Pump",{"$f":"SUM(F140:I140)","v":0},null,1,null,null,1]
["TBD",{"$f":"IF(OR(A141=\"TBD\",A141=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,null,{"$f":"IF(C141,IF(A141=\"≥90%\",2,2*A141),0)","v":0},"2. High-Efficiency Toilets (Dual-Flush or ≤ 1.28 gpf)",{"$f":"SUM(D141:I141)","v":0},null,null,null,null,2]
[null,null,0,null,null,null,null,null,null,"3. Water Efficient Fixtures "]
["TBD",{"$f":"IF(A143=\"Yes\",TRUE,FALSE)","v":false},false,null,null,null,null,null,null,"  a. All Fixtures Meet Federal Energy Policy Act (Toilets: 1.6 gpf, Sinks: 2.2 gpm, Showers: \n      2.5 gpm) (Required For Whole House)",{"$f":"IF(A143=\"Yes\",\"Y\",IF(A143=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,null,null,"R"]
["TBD",{"$f":"IF(OR(A144=\"TBD\",A144=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,null,{"$f":"IF(C144,IF(A144=\"≥90%\",3,3*A144),0)","v":0},"  b. High-Efficiency Showerheads  Use ≤ 2.0 gpm at 80 psi",{"$f":"SUM(D144:I144)","v":0},null,null,null,null,3]
["TBD",{"$f":"IF(OR(A145=\"TBD\",A145=\"No\"),FALSE,TRUE)","v":false},false,null,null,{"$f":"IF(C145,IF(A145=\"≥90%\",1,A145),0)","v":0},null,null,{"$f":"IF(C145,IF(A145=\"≥90%\",1,1*A145),0)","v":0},"  c. Bathroom Faucets Use ≤ 1.5 gpm",{"$f":"SUM(D145:I145)","v":0},null,1,null,null,1]
["TBD",{"$f":"IF(A146=\"Yes\",TRUE,FALSE)","v":false},false,null,null,null,null,null,null,"4. Plumbing Survey (No Plumbing Leaks) (Required for Whole House and Elements)",{"$f":"IF(A146=\"Yes\",\"Y\",IF(A146=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,null,null,"R"]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Plumbing = 13",{"$f":"SUM(K138:K146)","v":0}]
["H. HEATING, VENTILATION & AIR CONDITIONING",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
[null,null,null,null,null,null,null,null,null,"1. General HVAC Equipment Verification and Correction "]
["TBD",{"$f":"IF(A150=\"Yes\",TRUE,FALSE)","v":false},false,null,null,null,null,null,null,"     a. Visual Survey of Installation of HVAC Equipment (Required for Whole \n         House and Elements)",{"$f":"IF(A150=\"Yes\",\"Y\",IF(A150=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,"R"]
["TBD",{"$f":"IF(A151=\"Yes\",TRUE,FALSE)","v":false},false,null,null,{"$f":"IF(C151,2,0)","v":0},null,null,null,"     b. Conduct Diagnostic Testing to Evaluate System ",{"$f":"F151","v":0},null,2]
["TBD",false,false,null,null,{"$f":"IF(C152,1,0)","v":0},null,null,null,"     c. Conduct Flow Hood Test and Assess Delivery of Air",{"$f":"F152","v":0},null,1]
["TBD",false,false,null,null,{"$f":"IF(C153,1,0)","v":0},null,null,null,"     d. Air Conditioning Compressor Operates Properly and Refrigerant Charge is Optimal",{"$f":"F153","v":0},null,1]
["TBD",false,false,null,null,{"$f":"IF(C154,4,0)","v":0},null,null,null,"2. Design and Install HVAC System to ACCA Manuals J, D and S",{"$f":"SUM(D154:I154)","v":0},null,4]
[null,null,null,null,null,null,null,null,null,"3. Sealed Combustion Units"]
["TBD",false,false,null,null,null,{"$f":"IF(C156,2,0)","v":0},null,null,"     a. Furnaces",0,null,0,2]
["TBD",false,false,null,null,null,{"$f":"IF(C157,2,0)","v":0},null,null,"     b.Water heaters",0,null,0,2]
["TBD",{"$f":"IF(OR(A158=\"TBD\",A158=\"No\"),FALSE,TRUE)","v":false},false,null,null,{"$f":"IF(C158,IF(A158=\"≥90%\",1,A158),0)","v":0},{"$f":"IF(C158,IF(A158=\"≥90%\",1,A158),0)","v":0},null,null,"4. Zoned, Hydronic Radiant Heating ",0,null,1,1]
["TBD",false,false,null,{"$f":"IF(C159,1,0)","v":0},null,null,null,null,"5. High Efficiency Air Conditioning Air conditioning with Environmentally \n    Responsible Refrigerants  ",0,1]
[null,null,null,null,null,null,null,null,null,"6. Effective Ductwork Installation"]
["TBD",false,false,null,null,{"$f":"IF(C161,1,0)","v":0},null,null,null,"     a. New Ductwork and HVAC unit Installed Within Conditioned Space ",{"$f":"F161","v":0},null,1]
["TBD",false,false,null,null,{"$f":"IF(C162,1,0)","v":0},null,null,null,"     b. Duct Mastic Used on All Ducts, Joints and Seams",0,null,1]
["TBD",false,false,null,null,{"$f":"IF(C163,1,0)","v":0},null,null,null,"     c. Ductwork System is Pressure Relieved",0,null,1]
["TBD",false,false,null,null,null,{"$f":"IF(C164,1,0)","v":0},null,null,"7. High Efficiency HVAC Filter (MERV 6+)",0,null,null,1]
["TBD",false,false,null,null,null,{"$f":"IF(C165,1,0)","v":0},null,null,"8. No Fireplace OR Sealed Gas Fireplaces with Efficiency Rating ≥60% using CSA Standards",0,null,null,1]
[null,null,null,null,null,null,null,null,null,"9. Effective Exhaust Systems Installed in Bathrooms and Kitchens"]
["TBD",{"$f":"IF(OR(A167=\"TBD\",A167=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,{"$f":"IF(C167,IF(A167=\"≥90%\",1,A167),0)","v":0},null,null,"     a. ENERGY STAR Bathroom Fans Vented to the Outside",0,null,null,1]
["TBD",{"$f":"IF(OR(A168=\"TBD\",A168=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,{"$f":"IF(C168,IF(A168=\"≥90%\",1,A168),0)","v":0},null,null,"     b. All Bathroom Fans are on Timer or Humidistat",0,null,null,1]
["TBD",false,false,null,null,null,{"$f":"IF(C169,1,0)","v":0},null,null,"     c. Kitchen Range Hood Vented to the Outside",0,null,null,1]
[null,null,null,null,null,null,null,null,null,"10. Mechanical Ventilation System for Cooling Installed"]
["TBD",false,false,null,null,{"$f":"IF(C171,1,0)","v":0},null,null,null,"     a. ENERGY STAR Ceiling Fans & Light Kits in Living Areas & Bedrooms",0,null,1]
["TBD",false,false,null,null,{"$f":"IF(C172,1,0)","v":0},null,null,null,"     b. Whole House Fan",0,null,1]
[null,null,null,null,null,null,null,null,null,"11. Mechanical Ventilation for Fresh Air Installed"]
["TBD",false,{"$f":"B174","v":false},null,null,null,{"$f":"IF(C174,1,0)","v":0},null,null,"a. Compliance with ASHRAE 62.2 Mechanical Ventilation Standards (as \n    adopted in Title 24 Part 6)  ",0,null,null,1]
["TBD",false,{"$f":"B175","v":false},null,null,null,{"$f":"IF(C175,1,0)","v":0},null,null,"b. Advanced Ventilation Practices (Continuous Operation, Sone Limit, Minimum \n    Efficiency, Minimum Ventilation Rate, Homeowner Instructions)",0,null,null,1]
["TBD",false,false,null,null,{"$f":"IF(C176,1,0)","v":0},{"$f":"IF(C176,1,0)","v":0},null,null,"c. Outdoor Air Ducted to Bedroom and Living Areas of Home",0,null,1,1]
[null,null,null,null,null,null,null,null,null,"12. Carbon Monoxide"]
["TBD",false,false,null,null,null,null,null,null,"    a. Carbon Monoxide Testing and Correction (Required for Whole House)",{"$f":"IF(A178=\"Yes\",\"Y\",IF(A178=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,"R"]
["TBD",false,false,null,null,null,{"$f":"IF(C179,1,0)","v":0},null,null,"    b. Carbon Monoxide Alarm(s) Installed",0,null,null,1]
["TBD",{"$f":"IF(A180=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B180","v":false},null,null,null,null,null,null,"13.  Combustion Safety Backdraft Test (Required for Whole House and Elements)",{"$f":"IF(A180=\"Yes\",\"Y\",IF(A180=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,"R"]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Heating, Ventilation and Air Conditioning = 30",{"$f":"SUM(K149:K179)","v":0}]
["I. RENEWABLE ENERGY",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
[0,{"$f":"IF(A183>0.04,TRUE,FALSE)","v":false},false,null,null,{"$f":"(A183*25)","v":0},null,null,null," 1. Offset Energy Consumption with Onsite Renewable Generation \n     (Solar PV, Solar Thermal, Wind)\n     Enter % total energy consumption offset, 1 point per 4% offset",{"$f":"SUM(D183:I183)","v":0},null,25]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Renewable Energy = 25",{"$f":"SUM(K183:K183)","v":0}]
["J. BUILDING PERFORMANCE",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(AND(A186=\"Yes\",$B$203 = FALSE),TRUE,FALSE)","v":false},{"$f":"B186","v":false},null,null,null,null,null,null,"1. Energy Survey and Education  (Required for Elements or Meet J3)",{"$f":"IF(A186=\"Yes\",\"Y\",IF(A186=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,"R"]
[null,null,null,null,null,null,null,null,null,"2. Energy Upgrades (Available for Elements Rating Only, Mutually Exclusive with J3.  2 point minimum and 6 point maximum credit required)"]
[null,null,null,null,null,null,null,null,null,"TIER 1:  Practices in Tier 1 Are Worth Full Value (1 point)      "]
["TBD",{"$f":"IF(AND(A189=\"Yes\",$B$203 = FALSE),TRUE,FALSE)","v":false},{"$f":"B189","v":false},{"$f":"IF(C189,1,0)","v":0},null,{"$f":"IF($D$203<2,0,D189)","v":0},null,null,null,"   a) Attic Insulation up to or Exceeding Current Code      ",{"$f":"IF($N$3=\"Whole House\",0,SUM(F189))","v":0},null,1]
["TBD",false,{"$f":"B190","v":false},{"$f":"IF(C190,1,0)","v":0},null,0,null,null,null,"   b) Crawl Space Insulation up to or Exceeding Current Code",{"$f":"IF($N$3=\"Whole House\",0,SUM(F190))","v":0},null,1]
["TBD",false,false,0,null,0,null,null,null,"   c) Wall Insulation up to or Exceeding Current Code  ",0,null,1]
["TBD",false,false,0,null,0,null,null,null,"   d) High Efficiency Furnace (90% AFUE Minimum)    ",0,null,1]
["TBD",false,false,0,null,0,null,null,null,"   e) Seal Ducts and Duct Leakage is <15%",0,null,1]
["TBD",false,false,0,null,0,null,null,null,"   f) 14 SEER, 11.5 EER Air Conditioning Unit (in climate zones 2,4,8-15)     ",0,null,1]
["TBD",false,{"$f":"B195","v":false},0,null,{"$f":"IF(OR(SUM(D189:D194)>5,$D$203<2),0,D195)","v":0},null,null,null,"   g) House Passes Blower Door Test With ≤0.5 ACH or a 50% Improvement",0,null,1]
[null,null,null,null,null,null,null,null,null,"TIER 2:  Practices in Tier 2 Are Worth Half Value (0.5 points) "]
["TBD",{"$f":"IF(AND(A197=\"Yes\",$B$203 = FALSE),TRUE,FALSE)","v":false},false,{"$f":"IF(C197,0.5,0)","v":0},null,{"$f":"IF(D197=0,0,IF(OR($D$203<2,SUM(F189:F195)>5.5),0,D197))","v":0},null,null,null,"    h) High Efficiency Water Heater ≥.62EF       ",0,null,0.5]
["TBD",false,false,0,null,{"$f":"IF(D198=0,0,IF(OR($D$203<2,SUM(F189:F197)>5.5),0,D198))","v":0},null,null,null,"    i) Radiant Barrier in Attic",0,null,0.5]
["TBD",false,false,0,null,{"$f":"IF(D199=0,0,IF(OR($D$203<2,SUM(F189:F198)>5.5),0,D199))","v":0},null,null,null,"    j) Windows Upgraded to Current Code Requirements, Which are Typically Dual Pane",0,null,0.5]
["TBD",false,false,0,null,{"$f":"IF(D200=0,0,IF(OR($D$203<2,SUM(F189:F199)>5.5),0,D200))","v":0},null,null,null,"    k) Duct insulation to Code      ",0,null,0.5]
["TBD",false,false,0,null,{"$f":"IF(D201=0,0,IF(OR($D$203<2,SUM(F189:F200)>5.5),0,D201))","v":0},null,null,null,"    l)  Programmable Thermostat    ",0,null,0.5]
["TBD",false,false,0,null,{"$f":"IF(D202=0,0,IF(OR($D$203<2,SUM(F189:F201)>5.5),0,D202))","v":0},null,null,null,"    m) 14 SEER, 11.5 EER Air Conditioning unit (in climate zones 1,3,5,6,7,16)                               ",0,null,0.5]
[null,{"$f":"IF(A203>0,TRUE,FALSE)","v":false},{"$f":"B203","v":false},{"$f":"SUM(D189:D202)","v":0},null,{"$f":"IF(C203,IF(A203>84,(85/A203)*20+10,30+(2*(85-A203))),0)","v":0},null,null,null," 3. Meet Energy Budget for Home Based on Year (Based GreenPoint Rated Index, Includes Blower Door Test) (Required for Whole House, Available for Elements)",{"$f":"F203","v":0},null,"10+"]
["TBD",{"$f":"IF(A204=\"Yes\",TRUE,FALSE)","v":false},false,null,null,{"$f":"IF(C204,5,0)","v":0},null,null,null,"4. Design and Build Zero Energy Homes",{"$f":"SUM(E204:I204)","v":0},null,5]
["TBD",{"$f":"IF(A205=\"Yes\",TRUE,FALSE)","v":false},false,null,null,{"$f":"IF(C205,1,0)","v":0},null,null,null,"5. Comprehensive Utility Bill Analysis",{"$f":"F205","v":0},null,1]
[null,null,0,null,null,null,null,null,null,"Total Points Available in Building Performance = 16+",{"$f":"SUM(K186:K205)","v":0}]
["K. FINISHES",null,0,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(A208=\"Yes\",TRUE,FALSE)","v":false},false,null,null,null,{"$f":"IF(C208,1,0)","v":0},null,null,"1. Entryways Designed to Reduce Tracked in Contaminants",{"$f":"SUM(D208:I208)","v":0},null,null,1]
[null,null,null,null,null,null,null,null,null,"2. Low/No-VOC Paint"]
["TBD",{"$f":"IF(OR(A210=\"TBD\",A210=\"No\"),FALSE,TRUE)","v":false},{"$f":"B210","v":false},null,null,null,{"$f":"IF(C210,IF(A210=\"≥90%\",1,A210),0)","v":0},null,null,"     a. Low-VOC Interior Wall/Ceiling Paints (<50 gpl VOCs regardless of sheen)",{"$f":"SUM(E210:I210)","v":0},null,null,1]
["TBD",{"$f":"IF(OR(A211=\"TBD\",A211=\"No\"),FALSE,TRUE)","v":false},{"$f":"B211","v":false},null,null,null,{"$f":"IF(C211,IF(A211=\"≥90%\",2,2*A211),0)","v":0},null,null,"     b. Zero-VOC: Interior Wall/Ceiling Paints (<5 gpl VOCs (flat) )",0,null,null,2]
["TBD",{"$f":"IF(OR(A212=\"TBD\",A212=\"No\"),FALSE,TRUE)","v":false},{"$f":"B212","v":false},null,null,null,{"$f":"IF(C212,IF(A212=\"≥90%\",2,2*A212),0)","v":0},null,null,"3. Coatings Meet SCAQMD Rule 1113 for Low VOCs",0,null,null,2]
["TBD",{"$f":"IF(OR(A213=\"TBD\",A213=\"No\"),FALSE,TRUE)","v":false},{"$f":"B213","v":false},null,null,null,{"$f":"IF(C213,IF(A213=\"≥90%\",2,2*A213),0)","v":0},null,null,"4. Low-VOC Caulks & Construction Adhesives (Meet SCAQMD Rule 1168) ",0,null,null,2]
["TBD",{"$f":"IF(OR(A214=\"TBD\",A214=\"No\"),FALSE,TRUE)","v":false},{"$f":"B214","v":false},null,null,null,null,{"$f":"IF(C214,IF(A214=\"≥90%\",1,A214),0)","v":0},null,"5. Recycled-Content Paint ",0,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"6. Environmentally Preferable Materials for Interior Finish: A) FSC Certified Wood B) Reclaimed Materials C) Rapidly Renewable D) Recycled-Content E) Finger-Jointed or F) Local"]
["TBD",{"$f":"IF(OR(A216=\"TBD\",A216=\"No\"),FALSE,TRUE)","v":false},{"$f":"B216","v":false},null,null,null,null,{"$f":"IF(C216,IF(A216=\"≥90%\",1,A216),0)","v":0},null,"    a.  Cabinets ",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A217=\"TBD\",A217=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,0,null,"    b.  Interior Trim",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A218=\"TBD\",A218=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,0,null,"    c.  Shelving ",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A219=\"TBD\",A219=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,0,null,"    d.  Doors",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A220=\"TBD\",A220=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,null,0,null,"    e.  Countertops ",0,null,null,null,1]
["TBD",{"$f":"IF(A221=\"Yes\",TRUE,FALSE)","v":false},false,null,null,null,null,0,null,"7. For Newly Installed Products, Reduce Formaldehyde in Interior Finish – Meet Current CARB Airborne Toxic Control Measure (ATCM) for Composite Wood Formaldehyde Limits by Mandatory Compliance Dates (Required for Whole Building & Elements) \n(EPA IAP)",{"$f":"IF(A221=\"Yes\",\"Y\",\"N\")","v":"N"},null,null,"R"]
[null,null,null,null,null,null,null,null,null,"8. Reduce Formaldehyde in Interior Finish - Exceed Current CARB ATCM for Composite Wood Formaldehyde Limits Prior to Mandatory Compliance Dates"]
["TBD",{"$f":"IF(OR(A223=\"TBD\",A223=\"No\"),FALSE,TRUE)","v":false},{"$f":"B223","v":false},null,null,null,{"$f":"IF(C223,IF(A223=\"≥90%\",1,1*A223),0)","v":0},null,null,"a. Doors",0,null,null,1]
["TBD",{"$f":"IF(OR(A224=\"TBD\",A224=\"No\"),FALSE,TRUE)","v":false},{"$f":"B224","v":false},null,null,null,{"$f":"IF(C224,IF(A224=\"≥90%\",2,2*A224),0)","v":0},null,null,"b. Cabinets and Countertops",0,null,null,2]
["TBD",{"$f":"IF(OR(A225=\"TBD\",A225=\"No\"),FALSE,TRUE)","v":false},{"$f":"B225","v":false},null,null,null,{"$f":"IF(C225,IF(A225=\"≥90%\",1,1*A225),0)","v":0},null,null,"c. Interior Trim and Shelving",0,null,null,1]
["TBD",{"$f":"IF(A226=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B226","v":false},null,null,null,{"$f":"IF(C226,3,0)","v":0},null,null,"9. After Installation of Finishes, Test of Indoor Air Shows Formaldehyde Level <27ppb",0,null,null,3]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Finishes = 21",{"$f":"SUM(K208:K226)","v":0}]
["L. FLOORING",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(OR(A229=\"TBD\",A229=\"No\"),FALSE,TRUE)","v":false},{"$f":"B229","v":false},null,null,null,null,{"$f":"IF(C229,IF(A229=\"≥90%\",4,4*A229),0)","v":0},null,"1. Environmentally Preferable Flooring: A) FSC-Certified Wood B) Reclaimed or Refinished  C) Rapidly Renewable D) Recycled-Content, E) Exposed Concrete F) Local \nFlooring Adhesives Must Have <70 gpl VOCs and sealer must meet SCAQMD Rule 1113.",{"$f":"SUM(D229:I229)","v":0},null,null,null,4]
["TBD",{"$f":"IF(OR(A230=\"TBD\",A230=\"No\"),FALSE,TRUE)","v":false},false,null,null,{"$f":"IF(C230,IF(A230=\"≥90%\",1,1*A230),0)","v":0},null,null,null,"2. Thermal Mass Floors",{"$f":"SUM(D230:I230)","v":0},null,1]
["TBD",{"$f":"IF(OR(A231=\"TBD\",A231=\"No\"),FALSE,TRUE)","v":false},false,null,null,null,{"$f":"IF(C231,IF(A231=\"≥90%\",2,2*A231),0)","v":0},null,null,"3. Flooring Meets CA Section 01350 or CRI Green Label Plus Requirements ",{"$f":"SUM(D231:I231)","v":0},null,null,2]
[null,null,0,null,null,null,null,null,null,"Total Points Available in Flooring = 7",{"$f":"SUM(K229:K231)","v":0}]
["M. APPLIANCES AND LIGHTING",null,0,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(AND(A234=\"Yes\",$B$203 = FALSE),TRUE,FALSE)","v":false},false,null,null,{"$f":"IF(C234,1,0)","v":0},null,null,{"$f":"IF(C234,1,0)","v":0}," 1.  ENERGY STAR Dishwasher (Must Meet Current Specifications) (Mutually Exclusive with J3)",{"$f":"SUM(D234:I234)","v":0},null,1,null,null,1]
[null,null,null,null,null,null,null,null,null,"2.  ENERGY STAR Clothes Washing Machine with Water Factor of 6 or Less"]
["TBD",{"$f":"IF(A236=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B236","v":false},null,null,{"$f":"IF(OR(C237,C236),1,0)","v":0},null,null,{"$f":"IF(OR(C237,C236),2,0)","v":0},"     a. Meets CEE Tier 2 Requirements (Modified Energy Factor 2.0, Water Factor 6.0)",{"$f":"SUM(D236:I236)","v":0},null,1,null,null,2]
["TBD",false,{"$f":"B237","v":false},null,null,null,null,null,{"$f":"IF(C237,2,0)","v":0},"     b. Meets CEE Tier 3 Requirements (Modified Energy Factor 2.2, Water Factor 4.5)",0,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"3. ENERGY STAR Refrigerator Installed"]
["TBD",{"$f":"IF(AND(A239=\"Yes\",$B$203 = FALSE),TRUE,FALSE)","v":false},{"$f":"B239","v":false},null,null,{"$f":"IF(OR(C240,C239),1,0)","v":0},null,null,null,"     a.  ENERGY STAR Qualified & < 25 cu.ft.Capacity  (Mutually Exclusive with J3)",{"$f":"SUM(D239:I239)","v":0},null,1]
["TBD",{"$f":"IF(AND(A240=\"Yes\",$B$203 = FALSE),TRUE,FALSE)","v":false},{"$f":"B240","v":false},null,null,{"$f":"IF(C240,1,0)","v":0},null,null,null,"     b. ENERGY STAR Qualified & < 20 cu.ft Capacity (Mutually Exclusive with J3)",{"$f":"SUM(D240:I240)","v":0},null,1]
[null,null,null,null,null,null,null,null,null,"4. Built-In Recycling & Composting Center"]
["TBD",false,{"$f":"B242","v":false},null,null,null,null,{"$f":"IF(C242,2,0)","v":0},null,"     a. Built-In Recycling Center",0,null,null,null,2]
["TBD",false,{"$f":"B243","v":false},null,null,null,null,{"$f":"IF(C243,1,0)","v":0},null,"     b. Built-In Composting Center",0,null,null,null,1]
["TBD",false,true,null,null,null,null,null,null,"5. Electrical Survey  (Required for Whole House)",{"$f":"IF(A244=\"Yes\",\"Y\",IF(A244=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,null,null,"R"]
["TBD",false,{"$f":"B245","v":false},null,null,null,null,{"$f":"IF(C245,2,0)","v":0},null,"6. Verification of Entire Electrical System",0,null,null,null,2]
["TBD",{"$f":"IF(OR(A246=\"TBD\",A246=\"No\"),FALSE,TRUE)","v":false},{"$f":"B246","v":false},null,null,{"$f":"IF(C246,IF(A246=\"≥90%\",1,1*A246),0)","v":0},null,null,null,"7. Energy Efficient Lighting ",{"$f":"F246","v":0},null,1]
["TBD",{"$f":"IF(A247=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B247","v":false},null,null,null,null,{"$f":"IF(C247,1,0)","v":0},null,"    8.Low- Mercury Lamps (Linear and Compact Flourescent)",{"$f":"H247","v":0},null,null,null,1]
["TBD",{"$f":"IF(OR(A248=\"TBD\",A248=\"No\"),FALSE,TRUE)","v":false},{"$f":"B248","v":false},null,null,{"$f":"IF(C248,IF(A248=\"≥90%\",1,1*A248),0)","v":0},null,null,null,"9. Lighting Controls Installed ",{"$f":"F248","v":0},null,1]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Appliances and Lighting = 13+",{"$f":"SUM(K234:K248)","v":0}]
["N. OTHER",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
["TBD",{"$f":"IF(A251=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B251","v":false},null,null,null,null,null,null,"1. Incorporate GreenPoint Checklist in Blueprints Or Distribute Checklist (Required for Whole House and Elements)",{"$f":"IF(A251=\"Yes\",\"Y\",IF(A251=\"N/A\",\"N/A\",\"N\"))","v":"N"},null,"R"]
["TBD",{"$f":"IF(A252=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B252","v":false},null,null,{"$f":"IF(C252,1,0)","v":0},null,null,{"$f":"IF(C252,1,0)","v":0},"2. Develop Homeowner Manual of Green Features/Benefits ",{"$f":"SUM(D252:I252)","v":0},null,1,null,null,1]
[null,null,null,null,null,null,null,null,null,"3. Hazardous Waste Testing"]
["TBD",{"$f":"IF(A254=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B254","v":false},null,null,null,{"$f":"IF(C254,1,0)","v":0},null,null,"     a. Lead Testing Interior, Exterior and Soil",{"$f":"SUM(D254:I254)","v":0},null,null,1]
["TBD",{"$f":"IF(A255=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B255","v":false},null,null,null,{"$f":"IF(C255,1,0)","v":0},null,null,"     b. Asbestos Testing and Remediation  ",{"$f":"SUM(D255:I255)","v":0},null,null,1]
["TBD",{"$f":"IF(A256=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B256","v":false},null,null,null,{"$f":"IF(C256,1,0)","v":0},{"$f":"IF(C256,1,0)","v":0},null,"4. Gas Shut Off Valve (motion/ non-motion)",{"$f":"SUM(D256:I256)","v":0},null,null,1,1]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Other = 6",{"$f":"SUM(K251:K256)","v":0}]
["P. INNOVATIONS",null,null,null,null,null,null,null,null,null,null,"Possible Points"]
[null,null,null,null,null,null,null,null,null,"AA. Community: No Innovation Measures At This Time"]
[null,null,null,null,null,null,null,null,null,"A. Site"]
["TBD",{"$f":"IF(A261=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B261","v":false},null,{"$f":"IF(C261,1,0)","v":0},null,null,null,null,"1. Cool Site",{"$f":"SUM(E261:I261)","v":0},1]
[null,null,null,null,null,null,null,null,null,"B. Foundation: No Innovation Measures At This Time",{"$f":"SUM(E262:I262)","v":0}]
[null,null,null,null,null,null,null,null,null,"C. Landscaping ",0]
["TBD",{"$f":"IF(A264=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B264","v":false},null,null,null,null,null,{"$f":"IF(C264,1,0)","v":0},"1. Irrigation System Uses Recycled Wastewater ",0,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"D. Structural Frame and Building Envelope ",0]
[null,null,null,null,null,null,null,null,null,"1. Design, Build and Maintain Structural Pest and Rot Controls",0]
["TBD",{"$f":"IF(A267=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B267","v":false},null,null,null,null,{"$f":"IF(C267,1,0)","v":0},null,"a. Locate All Wood (Siding, Trim, Structure) At Least 12 Inches Above Soil ",0,null,null,null,1]
["TBD",{"$f":"IF(OR(A268=\"TBD\",A268=\"No\"),FALSE,TRUE)","v":false},{"$f":"B268","v":false},null,null,null,{"$f":"IF(C268,IF(A268=\"≥90%\",1,1*A268),0)","v":0},null,null,"b. All Wood Framing 3 Feet from the Foundation is Treated with Borates (or Use Factory-Impregnated Materials) OR Walls are Not Made of Wood",0,null,null,1]
["TBD",{"$f":"IF(A269=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B269","v":false},null,null,null,{"$f":"IF(C269,1,0)","v":0},null,null,"2. Use Moisture Resistant Materials and Practices in Wet Areas of Kitchen, Bathrooms, Utility Rooms, and Basements ",0,null,null,1]
[null,null,null,null,null,null,null,null,null,"3. Use FSC-Certified Engineered Lumber",0]
["TBD",{"$f":"IF(OR(A271=\"TBD\",A271=\"No\"),FALSE,TRUE)","v":false},{"$f":"B271","v":false},null,null,null,null,{"$f":"IF(C271,IF(A271=\"≥90%\",1,1*A271),0)","v":0},null,"a. Engineered Beams and Headers",0,null,null,null,1]
["TBD",false,false,null,null,null,null,0,null,"b. Insulated Engineered Headers",0,null,null,null,1]
["TBD",false,false,null,null,null,null,0,null,"c. Wood I-Joists or Web Trusses for Floors",0,null,null,null,1]
["TBD",false,false,null,null,null,null,0,null,"d. Wood I-Joists for Roof Rafters",0,null,null,null,1]
["TBD",false,false,null,null,null,null,0,null,"e. Engineered or Finger-Jointed Studs for Vertical Applications",0,null,null,null,1]
["TBD",false,false,null,null,null,null,0,null,"f. Roof Trusses",0,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"E. Exterior Finish",0]
["TBD",{"$f":"IF(OR(A278=\"No\",A278=\"TBD\"),FALSE,TRUE)","v":false},{"$f":"B278","v":false},null,{"$f":"IF(B278,IF(A278=0.25,1,2),0)","v":0},{"$f":"IF(B278,IF(A278=0.25,1,2),0)","v":0},null,null,null,"1. Green Roofs (25% or Roof Area Minimum)",0,2,2]
[null,null,null,null,null,null,null,null,null,"F. Insulation: No Innovation Measures At This Time",0]
[null,null,null,null,null,null,null,null,null,"G. Plumbing",0]
["TBD",{"$f":"IF(A281=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B281","v":false},null,null,null,null,null,{"$f":"IF(C281,1,0)","v":0},"1. Graywater Pre-Plumbing (Includes Clothes Washer at Minimum)",0,null,null,null,null,1]
["TBD",{"$f":"IF(A282=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B282","v":false},null,null,null,null,null,{"$f":"IF(C282,2,0)","v":0},"2. Graywater System Operational (Includes Clothes Washer at Minimum)",0,null,null,null,null,2]
["TBD",{"$f":"IF(A283=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B283","v":false},null,null,null,null,null,{"$f":"IF(C283,1,0)","v":0},"3. Innovative Wastewater Technology (Constructed Wetland, Sand Filter, Aerobic System)",0,null,null,null,null,1]
["TBD",{"$f":"IF(OR(A284=\"TBD\",A284=\"No\"),FALSE,TRUE)","v":false},{"$f":"B284","v":false},null,null,null,null,null,{"$f":"IF(C284,IF(A284=\"≥90%\",1,1*A284),0)","v":0},"4. Composting or Waterless Toilet ",0,null,null,null,null,1]
["TBD",{"$f":"IF(A285=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B285","v":false},null,null,{"$f":"IF(C285,1,0)","v":0},null,null,null,"5. Install Drain Water Heat-Recovery System",0,null,1]
[null,null,null,null,null,null,null,null,null,"H. Heating, Ventilation and Air Conditioning (HVAC)",0]
["TBD",{"$f":"IF(A287=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B287","v":false},null,null,null,{"$f":"IF(C287,1,0)","v":0},null,null,"1. Humidity Control Systems (Only in California Humid/Marine Climate Zones 1,3,5,6,7)",0,null,null,1]
[null,null,null,null,null,null,null,null,null,"I. Renewable Energy: No Innovation Measures At This Time",0]
[null,null,null,null,null,null,null,null,null,"J. Building Performance",0]
["TBD",{"$f":"IF(A290=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B290","v":false},null,null,{"$f":"IF(C290,1,0)","v":0},null,null,null,"1. Test Total Supply Air Flow Rates",0,null,1]
["TBD",{"$f":"IF(A291=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B291","v":false},null,null,{"$f":"IF(C291,1,0)","v":0},null,null,null,"2. Energy Budget Analysis (J3) Completed By CEPE",0,null,1]
[null,null,null,null,null,null,null,null,null,"K. Finishes: No Innovation Measures At This Time.",0]
[null,null,{"$f":"B293","v":0},null,null,null,null,null,null,"L. Flooring: No Innovation Measures At This Time.",0]
[null,null,null,null,null,null,null,null,null,"M. Appliances: No Innovation Measures At This Time.",0]
[null,null,null,null,null,null,null,null,null,"N. Other",0]
["TBD",{"$f":"IF(A296=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B296","v":false},null,{"$f":"IF(C296,1,0)","v":0},null,null,null,null,"1. Homebuilder's Management Staff Are Certified Green Building Professionals ",0,1]
["TBD",{"$f":"IF(A297=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B297","v":false},null,{"$f":"IF(C297,1,0)","v":0},null,null,null,null,"2. Comprehensive Owner's Manual and Homeowner Education Walkthroughs",0,1]
[null,null,null,null,null,null,null,null,null,"3. Additional Innovations: List innovative measures that meet green building objectives. Points will be assessed by Build It Green and the GreenPoint Rater.",0]
["TBD",{"$f":"IF(A299=\"Yes\",TRUE,FALSE)","v":false},{"$f":"B299","v":false},null,{"$f":"IF(L299=\"\",0,IF($C299,L299,0))","v":0},{"$f":"IF(M299=\"\",0,IF($C299,M299,0))","v":0},0,0,0,"     a.  Describe Innovation Here and Enter Possible Points in Columns L-P",{"$f":"SUM(D299:I299)","v":0}]
["TBD",false,{"$f":"B300","v":false},null,0,0,0,0,0,"     b.  Describe Innovation Here and Enter Possible Points in Columns L-P",0]
["TBD",false,false,null,0,0,0,0,0,"     c.  Describe Innovation Here and Enter Possible Points in Columns L-P",0]
["TBD",false,false,null,0,0,0,0,0,"     d.  Describe Innovation Here and Enter Possible Points in Columns L-P",0]
["TBD",false,false,null,0,0,0,0,0,"     e.  Describe Innovation Here and Enter Possible Points in Columns L-P",0]
["TBD",false,false,null,0,0,0,0,0,"     f.   Describe Innovation Here and Enter Possible Points in Columns L-P",0]
["TBD",false,false,null,0,0,0,0,0,"     g.  Describe Innovation Here  and Enter Possible Points in Columns L-P",0]
["TBD",false,false,null,0,0,0,0,0,"     h.  Describe Innovation Here  and Enter Possible Points in Columns L-P",0]
[null,null,null,null,null,null,null,null,null,"Total Points Available in Innovation = 26+",{"$f":"SUM(K261:K306)","v":0},0]
["Summary"]
[null,null,null,null,null,null,null,null,null,"Total Available Points","224+",{"$f":"SUM(L10:L307)","v":25},83,{"$f":"SUM(N10:N307)","v":46},76,{"$f":"SUM(P10:P307)","v":47}]
[null,null,null,null,null,null,null,null,null,"Minimum Points Required (Whole House)",50,0,20,5,6,8]
[null,null,null,null,null,null,null,null,null,"Minimum Points Required (Elements)",25,0,8,2,2,4]
[null,null,null,null,null,null,null,null,null,"Total Points Achieved",{"$f":"IF(N3=\"Whole House\",ROUND(SUM(L312:P312),0),MIN(49,ROUND(SUM(L312:P312),0)))","v":0},{"$f":"SUM($E$10:$E$306)","v":0},{"$f":"SUM($F$10:$F$306)","v":0},{"$f":"SUM($G$10:$G$306)","v":0},{"$f":"SUM($H$10:$H$306)","v":0},{"$f":"SUM($I$10:$I$306)","v":0}]
[]
[{"$f":"IF(AND($K$312>=50,$M$312>=20,$N$312>=5,$O$312>=6,$P$312>=8,OR($B$45:$C$45),$B$53,$B$119,$B$143,$B$146,$B$150,$B$178,$B$180,$B$203,$B$244,B221,$B$251),\"Project has met all recommended minimum requirements for GreenPoint Rated Whole House\",\"Project has not yet met the recommended minimum requirements for GreenPoint Rated Whole House:\")","v":"Project has not yet met the recommended minimum requirements for GreenPoint Rated Whole House:"}]
[{"$f":"IF(K312<50,\"    - Total Project Score of At Least 50 Points\",\"    - Total Project Score of At Least 50 Points \")","v":"    - Total Project Score of At Least 50 Points"}]
[{"$f":"IF(AND(OR($B$45,$C$45),$B$53,$B$119,$B$143,$B$146,$B$150,$B$178,$B$180,$B$203,B221,$B$244,$B$251),\"    - Required measures: \",\"    - Required measures:\")","v":"    - Required measures:"}]
[{"$f":"IF(AND($B$45=FALSE,C45=FALSE),\"          -A2a: Divert All Cardboard, Concrete, Asphalt and Metals\",\"          -A2a: Divert All Cardboard, Concrete, Asphalt and Metals \")","v":"          -A2a: Divert All Cardboard, Concrete, Asphalt and Metals"}]
[{"$f":"IF(($B$53=FALSE),\"          -B2: Moisture Source Verification and Correction\",\"          -B2: Moisture Source Verification and Correction \")","v":"          -B2: Moisture Source Verification and Correction"}]
[{"$f":"IF(($B$119=FALSE),\"          -D9: Sound Exterior Assemblies\",\"          -D9: Sound Exterior Assemblies \")","v":"          -D9: Sound Exterior Assemblies"}]
[{"$f":"IF(($B$143=FALSE),\"          -G3a: All Fixtures Meet Federal Energy Policy Act\",\"          -G3a: All Fixtures Meet Federal Energy Policy Act \")","v":"          -G3a: All Fixtures Meet Federal Energy Policy Act"}]
[{"$f":"IF($B$146=FALSE,\"          -G4: Plumbing Survey (No Plumbing Leaks)\",\"          -G4: Plumbing Survey (No Plumbing Leaks) \" )","v":"          -G4: Plumbing Survey (No Plumbing Leaks)"}]
[{"$f":"IF((B150=FALSE),\"          -H1a: Visual Survey of Installation of HVAC Equipment \",\"          -H1a: Visual Survey of Installation of HVAC Equipment  \")","v":"          -H1a: Visual Survey of Installation of HVAC Equipment "}]
[{"$f":"IF(($B$178=FALSE),\"          -H12a: Carbon Monoxide Testing and Correction\",\"          -H12a: Carbon Monoxide Testing and Correction \")","v":"          -H12a: Carbon Monoxide Testing and Correction"}]
[{"$f":"IF(($B$180=FALSE),\"          -H13: Combustion Safety Backdraft Test\",\"          -H13: Combustion Safety Backdraft Test \")","v":"          -H13: Combustion Safety Backdraft Test"}]
[{"$f":"IF(($B$203=FALSE),\"          -J3: Meet Energy Budget for Home Based on Year\",\"          -J3: Meet Energy Budget for Home Based on Year \")","v":"          -J3: Meet Energy Budget for Home Based on Year"}]
[{"$f":"IF(($B$221=FALSE),\"          -K7: Meet Current CARB ATCM for Composite Wood Formaldehyde Limits\",\"          -K7: Meet Current CARB ATCM for Composite Wood Formaldehyde Limits \")","v":"          -K7: Meet Current CARB ATCM for Composite Wood Formaldehyde Limits"}]
[{"$f":"IF(($B$244=FALSE),\"          -M5: Electrical Survey\",\"          -M5: Electrical Survey \")","v":"          -M5: Electrical Survey"}]
[{"$f":"IF(B251=FALSE,\"          -N1: Incorporate GreenPoint Checklist in Blueprints or Distribute Checklist\",\"          -N1: Incorporate GreenPoint Checklist in Blueprints or Distribute Checklist \")","v":"          -N1: Incorporate GreenPoint Checklist in Blueprints or Distribute Checklist"}]
[{"$f":"IF(OR($M$312<20,$N$312<5,$O$312<6,$P$312<8),\"    - Minimum points in specific categories:\",\"    - Minimum points in specific categories: \")","v":"    - Minimum points in specific categories:"}]
[{"$f":"IF(($M$312<20),\"          -Energy (20 points)\",\"          -Energy (20 points) \")","v":"          -Energy (20 points)"}]
[{"$f":"IF($N$312<5,\"          -IAQ/Health (5 points)\",\"          -IAQ/Health (5 points) \")","v":"          -IAQ/Health (5 points)"}]
[{"$f":"IF($O$312<6,\"          -Resources (6 points)\",\"          -Resources (6 points) \")","v":"          -Resources (6 points)"}]
[{"$f":"IF($P$312<8,\"          -Water (8 points)\",\"          -Water (8 points) \")","v":"          -Water (8 points)"}]
[]
[{"$f":"IF(AND(K312>=25,M312>=8,N312>=2,O312>=2,P312>=4,OR(B45,C45),B146,B150,B180,OR(203,B186),B221,B251),\"Project has met all recommended minimum requirements for GreenPoint Rated Elements\",\"Project has not yet met the recommended minimum requirements for GreenPoint Rated Elements:\")","v":"Project has not yet met the recommended minimum requirements for GreenPoint Rated Elements:"}]
[{"$f":"IF($K$312<25,\"    - Total Project Score of At Least 25 Points\",\"    - Total Project Score of At Least 25 Points \")","v":"    - Total Project Score of At Least 25 Points"}]
[{"$f":"IF(AND(OR(B45,C45),B146,B150,B180,OR(B203,B186),B221,B251),\"    - Required measures: \",\"    - Required measures:\")","v":"    - Required measures:"}]
[{"$f":"IF(AND(C45=FALSE,$B$45=FALSE),\"          -A2a: Divert All Cardboard, Concrete and Metals\",\"          -A2a: Divert All Cardboard, Concrete and Metals \")","v":"          -A2a: Divert All Cardboard, Concrete and Metals"}]
[{"$f":"IF($B$146=FALSE,\"          -G4: Plumbing Survey (No Plumbing Leaks)\",\"          -G4: Plumbing Survey (No Plumbing Leaks) \" )","v":"          -G4: Plumbing Survey (No Plumbing Leaks)"}]
[{"$f":"IF((B150=FALSE),\"          -H1a: Visual Survey of Installation of HVAC Equipment \",\"          -H1a: Visual Survey of Installation of HVAC Equipment  \")","v":"          -H1a: Visual Survey of Installation of HVAC Equipment "}]
[{"$f":"IF(($B$180=FALSE),\"          -H13: Combustion Safety Backdraft Test\",\"          -H13: Combustion Safety Backdraft Test \")","v":"          -H13: Combustion Safety Backdraft Test"}]
[{"$f":"IF(AND(B203=FALSE,B186=FALSE),\"          -J1:  Energy Survey and Education OR J3: Meet Energy Budget for Home Based on Year\",\"          -J1:  Energy Survey and Education OR J3: Meet Energy Budget for Home Based on Year \" )","v":"          -J1:  Energy Survey and Education OR J3: Meet Energy Budget for Home Based on Year"}]
[{"$f":"IF(($B$221=FALSE),\"          -K7: Meet Current CARB ATCM for Composite Wood Formaldehyde Limits\",\"          -K7: Meet Current CARB ATCM for Composite Wood Formaldehyde Limits \")","v":"          -K7: Meet Current CARB ATCM for Composite Wood Formaldehyde Limits"}]
[{"$f":"IF(B251=FALSE,\"          -N1: Incorporate GreenPoint Checklist in Blueprints or Distribute Checklist\",\"          -N1: Incorporate GreenPoint Checklist in Blueprints or Distribute Checklist \")","v":"          -N1: Incorporate GreenPoint Checklist in Blueprints or Distribute Checklist"}]
[{"$f":"IF(OR(M312<8,N312<2,O312<2,P312<4),\"    - Minimum points in specific categories:\",\"    - Minimum points in specific categories: \")","v":"    - Minimum points in specific categories:"}]
[{"$f":"IF((M312<8),\"          -Energy (8 points)\",\"          -Energy (8 points) \")","v":"          -Energy (8 points)"}]
[{"$f":"IF(N312<2,\"          -IAQ/Health (2 points)\",\"          -IAQ/Health (2 points) \")","v":"          -IAQ/Health (2 points)"}]
[{"$f":"IF(O312<2,\"          -Resources (2 points)\",\"          -Resources (2 points) \")","v":"          -Resources (2 points)"}]
[{"$f":"IF(P312<4,\"          -Water (4 points)\",\"          -Water (4 points) \")","v":"          -Water (4 points)"}]
[]
[]
[]
[]
[]
[]
[]
[]
["GreenPoint Elements"]