{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Title","Calculations","Help","D1Display","D2Display","D3Display","D4Display","D5Display","D6Display","Table D1","Table D2","Table D3","Table D4","Table D5","Table D6"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":15,"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":"Title","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,4,10,10],[12,4,12,10],[14,5,16,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"DEAP Thermal Bridging Application"]
[]
[null,null,null,null,"Version 1.0"]
[]
[null,null,null,null,null,"The purpose of this utility is to enable the calculation of the 'Factor for Thermal Bridging' for use in the 'Heat Loss Results' Tab in the SEAI DEAP (Dwelling Energy Assessment Procedure) software."]

{"sheet":"Calculations","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2],[4,1,4,2],[5,1,5,2],[4,3,4,4],[5,3,5,4],[5,5,5,6],[0,4,0,5],[2,8,2,9],[1,4,1,6],[3,5,3,6],[4,5,4,6]]}
[10,10,0,"A1 = First Data Row; B1 = Next Data Input Cell; C1 = Row Being Edited","Thermal Bridging Calculation",null,{"$f":"Title!E13","v":"Version 1.0"}]
[]
[null,"MPRN:"]
[null,"BER Number:",null,null,null,"Add a new Junction to this Calculation:  "]
[null,"Address:",null,null,null,"Total Envelope Area containing Thermal Bridges (m2):",null,0]
[null,"Comments:",null,null,null,"Calculating Y Factor for Thermal Bridging [W/m2K]:",null,{"$f":"IF(H5=0,0,SUM(J10:J209)/H5)","v":0}]
[]
[]
[null,null,"Item Number","Table","Junction Detail","Description","Target U-Value(W/m2K)","Psi Value (W/mK)","Length (m)","Calculated Value Psi*L (W/K)"]

{"sheet":"Help","index":2,"n_rows":110,"n_cols":1,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["DEAP Thermal Bridging Factor Application"]
[]
["January, 2012"]
[]
["Purpose"]
["The purpose of this application is to enable a BER Assessor to calculate a non-default Thermal Bridging Factor for use in the Dwelling Energy Assessment Procedure (DEAP). "]
["There are three default values available for 'Thermal Bridging Factor' (y) in DEAP manual Appendix K under:"]
["www.seai.ie/deap"]
[]
["A default value of y = 0.15 W/m2K applies for all dwellings except the following: "]
["1)  y = 0.08 W/m2K: for new dwellings whose details conform with ‘‘Limiting Thermal Bridging and Air Infiltration --- Acceptable Construction Details’’ as referenced in Building Regulations 2008 and 2011 TGD L. This requires that the relevant ddrawings be signed off by the developer/builder, site engineer or architect."]
["2)      y = 0.11 W/m2K: Only applies to new dwellings where Building Regulations 2005 TGD L applies. This value may be used when sign-off by the developer/builder, site engineer or architect indicates that all details in the dwelling have been constructed in accordance with both:"]
["i.                    Diagrams 3 and 4, and Sections 1.2.4 and 1.2.5 of Building Regulations 2005 TGD L"]
["ii.                  The details set out in the Homebond publication “Right on Site, Issue No. 28” or the 5th or later editions of the Homebond Manual. "]
[]
["To coincide with the publication of the new version of TGD Part L in 2011, the ‘Thermal Bridging Factor Application’ was developed to take advantage of the default linear transmittance values (ψ [W/ (mK)], or Psi values) in Appendix D of TGD L 2011. The application provides the BER Assessor with a facility for determining a non-default thermal bridging factor (y) for use in DEAP."]
["The methods outlined in TGD L 2011 for limiting thermal bridges are to:"]
["(1)    adopt Acceptable Construction Details for typical constructions as shown in sections 1 to 6 in the document “Limiting Thermal Bridging and Air Infiltration – Acceptable Construction Details” for all key junctions"]
["(2)   adopt Acceptable Construction Details sections 1 to 6 combined with details from Appendix 2 of the document “Limiting Thermal Bridging and Air Infiltration – Acceptable Construction Details” or other certified details (as defined in (iii) below) for all key junctions"]
["(3)    use certified details which have been assessed in accordance, and comply, with Appendix D, e.g. certified by a third party certification body such as Agrément or equivalent or certified by a member of an approved thermal modelers scheme (to be developed) or equivalent for all key junctions;"]
["(4)   use alternative details which limit the risk of mould growth and surface condensation to an acceptable level as set out in paragraph D.2 of Appendix D for all Junctions."]
["The transmission heat loss coefficient HTB associated with non repeating thermal bridges is based on the formula described in Section D3 of TGD L 2011:"]
[]
["Where L is the length of the thermal bridge over which ψ applies. The linear thermal bridge (ψ) describes the heat loss associated with a thermal bridge. This is the rate of heat flow per degree per unit length of bridge that is not accounted for in the U-values of the plane building elements containing the thermal bridge. The thermal bridging factor (y) as calculated by this application is calculated as follows:"]
[]
["“Aexp” is the sum of exposed (heat loss) areas of the dwelling in m2. "]
["The calculation procedure to establish the linear thermal transmittance (ψ) is outlined in BRE IP 1/06.  Details should be assessed in accordance with the methods described in I.S. EN ISO 10211.  These calculations of two dimensional or three dimensional heat flow require the use of numerical modelling software validated against I.S. EN ISO 10211. "]
["Values of ψ can be determined from the results of numerical modeling or can be taken from Tables D1 to D6 of TGD L 2011 for Acceptable Construction Details if the details are followed during design and construction."]
["Method "]
["This calculation is based on the methods outlined in Appendix D of TGD Part L 2011 and can be applied to new dwellings meeting the criteria set out in TGD L 2011 Section 1.3.3.2.The BER Assessor is required to include all thermal bridges at junctions in the building. The y factor can be calculated using this application for use in DEAP."]
["Using the y value calculation tool"]
["The ‘Thermal Bridging Factor (y)’, includes all junctions not taken into account in the calculation of the U-Values of plane building elements. These include junctions around openings such as windows and doors and junctions at the intersection of two planar elements such as the corners of walls, junctions between floors and walls and junctions between walls and ceilings."]
["The lengths of all of the junctions should be measured in metres and the total exposed and semi-exposed (heat loss) envelope area of the building determined. The exposed envelope area should be available from the DEAP Envelope area calculations."]
["The next step in the process takes place in the Microsoft Excel application, ‘Thermal Bridging Application.xlsm’. This application is designed to run in Microsoft Excel 2007 and later versions. To run this application it should be ensured that macros are enabled in Microsoft Excel."]
["The calculation takes place in the ‘Calculations’ Tab of this application which can be accessed by either selecting the tab directly or by pressing the ‘Thermal Bridging’ button on the ‘Title’ tab."]
[]
[]
[]
[]
["Figure 1"]
[]
[]
[]
["Figure 2"]
["The ‘Calculations’ tab is divided into two sections. The header area in Figure 1 contains information relating to the whole dwelling. The details area in Figure 2 consists of data relating to each individual junction within the dwelling."]
["The header area is divided into three sections as follows:"]
["1)      The section to the left is for recording specific information relating to this dwelling including the MPRN, BER number, address and a comments section. Though not compulsory, it is recommended that it be completed to ensure that it relates to the correct dwelling and its BER assessment."]
["2)      The middle section contains a data entry box for entering the total exposed and semi-exposed envelope area of the dwelling, a results box for showing the final calculated ‘Thermal Bridging Factor (y)’ and a button for adding new junctions to the details area."]
["3)      The right most section contains a key indicating what the different colours in this application refer to. Only the “user input” boxes are editable by the user."]
["To begin a calculation, first enter the dwelling address along with the MPRN and BER number if available. The total envelope area of the dwelling must be entered to calculate the thermal bridging factor (y) and can be obtained from the ‘Heat loss results’ section of the ‘Building elements’ tab in DEAP."]
[]
[]
[]
[]
[]
["Figure 3"]
["To add a new junction to the list, click the ‘Add New’ button highlighted in Figure. This will present the user with the following window:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Figure 4"]
["The window in Figure 4 allows the user to enter the thermal bridge details for a junction in one of two ways, either by selecting from the Appendix D tables or entering a custom calculated Psi Value. In addition the associated junction length needs to be entered in metres. The junction should be identified using the “junction description” entry. All measurements refer to internal surfaces of the building elements."]
["To enter data from the Appendix D tables, the option at the top of the window ‘Use Values from Appendix D’ should be selected. The first drop down list on this window, Appendix D Table, has six options, one for each of the tables in Appendix D as follows:"]
[]
[]
["Figure 5"]
["Depending on the construction in question, the appropriate option is chosen. Once selected, the options in each of the other two dropdown lists are automatically populated to reflect the chosen table e.g. if ‘Section 1 – Cavity Wall Insulation’ is selected then the rows of TGD L 2011 Table D1 are automatically displayed in the dropdown list entitled ‘Section’ and the ‘Target U-Values’ from Table D1 are added to the third dropdown list. When using Appendix D the user should ensure that they have acquainted themselves with the footnotes associated with the relevant tables D1 – D6 by referencing TGD L 2011."]
[" To enter a custom Psi Value for a junction, select the ‘Use Custom Values’ option at the top of the window. This will automatically disable the three dropdown lists relating to Appendix D as described above and require entries for the junction description, junction length and the Psi value. When entering a custom Psi value, full details on the method used to determine this value must be retained including thermal models of the relevant junction."]
["Once all selections have been made and the junction length added, pressing the ‘Ok’ button will close the window in Figure 4 and add this junction to the list of junctions as demonstrated in Figure 6."]
[]
[]
["Figure 6"]
["This process is repeated for all junctions in the building. As each junction is added the ‘Calculated Factor for Thermal Bridging (y)’ in Figure 1 is automatically recalculated.    "]
["As can be seen in Figure 6 the cells in the added row have three different colours as follows:"]
["1)      Green – are constants and cannot be edited on screen"]
["2)      Blue – are automatically calculated values which cannot be edited"]
["3)      Yellow – are fields where data entry is allowed"]
[]
["In this case there are three yellow fields i.e. allowing data entry"]
["1)      Delete – Allows the user to select this row for deletion."]
["2)      Edit – Allows the user to select this row to be edited."]
["3)      Length (m) – allows the user to change the junction length without having to re-enter all of the details."]
["To delete a row from the grid, the user must click the delete cell on that row. This will result in a delete symbol appearing as described in Figure 7. Clicking this cell again will result in the delete symbol being removed. Once at least one row has been selected for deletion, clicking the Delete button located at cell A9 will delete this row from the grid. The user can select multiple rows for simultaneous deletion."]
[]
[]
[]
[]
[]
["Figure 7"]
[]
["To edit a row in the grid, the user must click the edit cell on that row. This will result in an edit symbol appearing as described in Figure 8. Clicking this cell again will result in the edit symbol being removed. If the edit cell of another is selected then the edit cell of the former row will be deselected as only one row can be edited at a time.  Once a row has been selected, clicking the Edit button located at cell B9 will open the Edit window as described in Figure 9 with the data from this row displayed. This window is similar to the data entry window described in Figure 4. Any item can be changed by making a new selection from the drop down list or by entering data in the data entry box. Finally pressing Ok will save the changes and pressing Cancel will revert to the “calculation” screen, cancelling the changes made to the line."]
[]
["Figure 8"]
[]
[]
["Figure 9"]
[]
["Once all rows have been added and the calculation completed, the workbook should be saved with a unique name for future reference. This is a Read-Only file so a new name will have to be provided by the user at the time of saving."]

{"sheet":"D1Display","index":3,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["1.01a","Ground Floor - Insulation above slab",0.17,7.1999999999999995E-2,0.19600000000000001]
["1.01b","Ground Floor - Insulation above slab plus lightweight block",0.08,4.2000000000000003E-2,9.2999999999999999E-2]
["1.02a","Ground Floor - Insulation below slab",0.16300000000000001,0.108,0.191]
["1.02b","Ground Floor - Insulation below slab plus lightweight block",7.0000000000000007E-2,6.0999999999999999E-2,8.3000000000000004E-2]
[1.03,"Timber Suspended Ground Floor",0.219,0.10199999999999999,0.22700000000000001]
[1.04,"Concrete Intermediate Floor within a dwelling",0,3.9E-2,0]
["1.04a","Concrete Separating Floor between dwellings",6.4000000000000001E-2,8.6999999999999994E-2,4.4999999999999998E-2]
[1.05,"Timber Intermediate Floor within a dwelling",-1E-3,0.02,-1E-3]
["1.05a","Timber Separating Floor between dwellings",4.1000000000000002E-2,5.0999999999999997E-2,2.9000000000000001E-2]
["1.06.1","Masonry Solid Separating Wall (plan)",4.4999999999999998E-2,6.6000000000000003E-2,3.2000000000000001E-2]
["1.06.2","Masonry Cavity Separating Wall (plan)",5.0999999999999997E-2,7.1999999999999995E-2,3.5999999999999997E-2]
[1.07,"Masonry Partition Wall",0,0,0]
[1.08,"Stud Partition Wall",0,0,0]
["1.09/1.10","Eaves – Unventilated/Ventilated attic",4.9000000000000002E-2,0.03,5.2999999999999999E-2]
["1.11.1/1.12.1","Eaves – Unventilated/Ventilated - Insulated at ceiling",2.8000000000000001E-2,2.4E-2,3.6999999999999998E-2]
["1.11.2/1.12.2","Eaves – Unventilated/Ventilated – Insulation between and under rafters – Dormer",1.4E-2,1.2999999999999999E-2,1.2999999999999999E-2]
["1.13.1","Eaves –Ventilated – Insulation between and under rafters – Pitched ceiling",2.1000000000000001E-2,0.02,3.5999999999999997E-2]
["1.13.2","Eaves – Ventilated – Insulation between and under rafters – Pitched with flat ceiling",0.02,1.7000000000000001E-2,1.7000000000000001E-2]
[1.1399999999999999,"Eaves – Unventilated – Insulation between and over rafters – Dormer",8.9999999999999993E-3,1.0999999999999999E-2,3.4000000000000002E-2]
[1.1499999999999999,"Ventilated Roof - Attic floor level",0.27200000000000002,0.152,0.21]
["1.16/1.17","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",6.7000000000000004E-2,4.1000000000000002E-2,6.3E-2]
[1.18,"Gable - Insulation between and over rafters - Unventilated rafter void",9.6000000000000002E-2,5.8000000000000003E-2,7.0999999999999994E-2]
[1.19,"Flat Roof – Eaves",0.04,3.9E-2,3.7999999999999999E-2]
["1.20","Flat Roof - Parapet",0.152,5.8999999999999997E-2,0.20599999999999999]
[1.21,"Ope - Split Lintels - Steel and Concrete",-3.0000000000000001E-3,5.0000000000000001E-3,1E-3]
[1.22,"Ope - Perforated steel lintel (stainless steel)",0.26100000000000001,0.13800000000000001,0.23599999999999999]
["1.23.1","Ope - Pre-stressed concrete lintels",-5.0000000000000001E-3,4.0000000000000001E-3,1E-3]
["1.23.2","Ope - Pre-stressed concrete lintels - proprietary closer",7.0000000000000001E-3,1.2E-2,6.0000000000000001E-3]
[1.24,"Ope - Jamb with closer block",2.8000000000000001E-2,2.5999999999999999E-2,3.1E-2]
[1.25,"Ope - Jamb with proprietary cavity closer",6.0000000000000001E-3,1.0999999999999999E-2,6.0000000000000001E-3]
[1.26,"Ope - Concrete Forward Sill",6.0000000000000001E-3,1.4999999999999999E-2,1.9E-2]
["1.27.1","Corner",4.3999999999999997E-2,3.2000000000000001E-2,3.5000000000000003E-2]
["1.27.2","Inverted corner",-6.9000000000000006E-2,-5.2999999999999999E-2,-5.5E-2]
["G.01.1","Masonry Separating (cavity) Wall Head - Section",0.51100000000000001,0.48399999999999999,0.48399999999999999]
["G.01.2","Masonry Separating (solid) Wall Head - Section",0.48799999999999999,0.45800000000000002,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24,0.24]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15,0.15]
["Diagram 1","Galvanised Steel top hat lintel detail bridging masonry cavity wall",0.48299999999999998,0.20599999999999999,0.45400000000000001]
["Diagram 2","Concrete Back sill detail (insulation below wood sill section)",0.38300000000000001,0.17399999999999999,0.39500000000000002]
["Diagram 3","Eaves - Ventilated roof space - wall head closed with slate",7.1999999999999995E-2,5.3999999999999999E-2,0.13100000000000001]
["1.B.1","Balcony within dwelling",0,0,0]
["1.B.2","Balcony between dwellings",0.02,0.02,0.02]

{"sheet":"D2Display","index":4,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["2.01","Ground Floor - Insulation above slab",0.13100000000000001,0.14499999999999999]
["2.01a","Ground Floor - Insulation above slab",0.214,0.25900000000000001]
[2.02,"Ground Floor - Insulation below slab",0.16200000000000001,0.17199999999999999]
["2.02a","Ground Floor - Insulation below slab",0.23499999999999999,0.247]
[2.0299999999999998,"Timber Suspended Ground Floor",0.158,0.20399999999999999]
["2.03a","Timber Suspended Ground Floor",0.29699999999999999,0.36799999999999999]
[2.04,"Concrete Intermediate Floor within a dwelling",1E-3,0]
["2.04a","Concrete Separating Floor between dwellings",7.0999999999999994E-2,4.8000000000000001E-2]
[2.0499999999999998,"Masonry Separating Wall - plan",4.9000000000000002E-2,3.3000000000000002E-2]
[2.06,"Masonry Partition Wall",0,0]
[2.0699999999999998,"Stud Partition Wall",0,0]
["2.08/2.09","Eaves – Unventilated/Ventilated roof space",6.7000000000000004E-2,7.3999999999999996E-2]
["2.10.1/2.11.1","Eaves – Unventilated/Ventilated - Insulation between and under rafters – Dormer",0.05,5.5E-2]
["2.12.1","Eaves - Unventilated - Insulation between and over rafters - Pitched ceiling",1.6E-2,3.1E-2]
["2.12.2","Eaves – Unventilated/Ventilated - Insulation between and under rafters - Pitched with flat ceiling",0.02,1.7000000000000001E-2]
[2.13,"Eaves - Unventilated - Insulation between and over rafters",1.2999999999999999E-2,2.7E-2]
[2.14,"Ventilated Roof - Attic floor level",0.34699999999999998,0.33500000000000002]
["2.15/2.16","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",9.0999999999999998E-2,8.6999999999999994E-2]
[2.17,"Gable - Insulation between and over rafters - Unventilated rafter void",0.13100000000000001,0.106]
[2.1800000000000002,"Flat Roof - Eaves",4.5999999999999999E-2,4.4999999999999998E-2]
[2.19,"Flat Roof - Parapet",0.34899999999999998,0.32700000000000001]
["2.20","Ope - Lintel",9.7000000000000003E-2,9.8000000000000004E-2]
[2.21,"Ope - Jamb",8.7999999999999995E-2,9.0999999999999998E-2]
[2.2200000000000002,"Sill",0.14899999999999999,0.109]
["2.23.1","Corner",9.9000000000000005E-2,7.0000000000000007E-2]
["2.23.2","Inverted corner",-0.14099999999999999,-9.6000000000000002E-2]
["G.01.1","Masonry Separating Wall Head – Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15]
["2.B.1","Balcony within dwelling",0,0]
["2.B.2","Balcony between dwellings",0.02,0.02]

{"sheet":"D3Display","index":5,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[6.01,"Ground Floor - Insulation above slab",3.9E-2,3.1E-2]
[6.02,"Ground Floor - Insulation below slab",0.05,3.9E-2]
[6.03,"Timber Suspended Ground Floor",2.9000000000000001E-2,2.1000000000000001E-2]
[6.04,"Timber Intermediate Floor - Within a dwelling",0.10100000000000001,8.1000000000000003E-2]
["6.05.1","Masonry Separating (solid) Wall - plan",0.29599999999999999,0.28399999999999997]
["6.05.2","Masonry Separating (cavity) Wall - plan",0.316,0.309]
[6.06,"Masonry Partition Wall - plan",0.155,0.156]
[6.07,"Stud Partition",0,0]
["6.08/6.09","Eaves – Unventilated/Ventilated roof space",2.1000000000000001E-2,2.1000000000000001E-2]
["6.10","Eaves - Insulation between and under rafters – ventilated rafter void - Dormer",2.1999999999999999E-2,2.1999999999999999E-2]
["6.10.2","Eaves – Insulation between and under rafters – Ventilated void – Pitched Ceiling Dormer ",1.4E-2,1.2999999999999999E-2]
[6.11,"Eaves - Insulation between and under rafters – Ventilated rafter void – Pitched ceiling",3.0000000000000001E-3,2E-3]
["6.11.2","Eaves - Ventilated - Insulation between and under rafters – Pitched with flat ceiling",0.02,0.02]
[6.12,"Eaves - Unventilated - Insulation between and over rafters - Dormer",1.0999999999999999E-2,1.4999999999999999E-2]
[6.13,"Ventilated Roof - Attic floor level",3.7999999999999999E-2,3.4000000000000002E-2]
["6.14/6.15","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",2.5999999999999999E-2,2.1999999999999999E-2]
[6.16,"Gable - Insulation between and over rafters - Unventilated rafter void",3.5999999999999997E-2,3.1E-2]
[6.17,"Flat Roof - Eaves",5.2999999999999999E-2,3.9E-2]
[6.18,"Flat Roof - Parapet",4.5999999999999999E-2,3.7999999999999999E-2]
[6.19,"Ope - Lintel",3.6999999999999998E-2,4.2000000000000003E-2]
["6.20","Ope - Jamb",3.1E-2,3.5999999999999997E-2]
[6.21,"Ope - Sill",-4.0000000000000001E-3,3.0000000000000001E-3]
["6.C1 ","Corner",1.7999999999999999E-2,1.6E-2]
["6.C2 ","Inverted Corner",-4.7E-2,-4.2000000000000003E-2]
["G.01.1","Masonry Separating (cavity) Wall Head - Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating (solid) Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.245]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15]
["6.B.1","Balcony within dwelling",0,0]
["6.B.2","Balcony between dwellings",0.02,0.02]

{"sheet":"D4Display","index":6,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[4.01,"Ground Floor - Insulation above slab",5.0999999999999997E-2,2.1000000000000001E-2]
[4.0199999999999996,"Ground Floor - Insulation below slab",0.20499999999999999,0.125]
[4.03,"Timber Suspended Ground Floor",6.3E-2,4.5999999999999999E-2]
["4.04.1","Corner",6.2E-2,0.03]
["4.04.2","Inverted corner",-4.0000000000000001E-3,-1.4999999999999999E-2]
[4.05,"Timber Intermediate Floor within a dwelling",0.13,0.08]
["4.05a","Timber Separating floor between dwellings",0.193,0.13200000000000001]
[4.0599999999999996,"Separating Wall (plan)",8.6999999999999994E-2,7.9000000000000001E-2]
[4.07,"Separating Wall (section)",0.23599999999999999,0.23599999999999999]
[4.08,"Partition Wall",0,0]
["4.09/4.10","Eaves – Unventilated/Ventilated roof space",8.2000000000000003E-2,4.3999999999999997E-2]
["4.11.1/4.12.1","Eaves -Insulation between and under rafters – Unventilated/Ventilated rafter void – Dormer",5.3999999999999999E-2,3.9E-2]
["4.12.2","Eaves – Insulation between and under rafters – Unventilated/Ventilated rafter void – Pitched Ceiling Dormer",1.4E-2,1.2999999999999999E-2]
["4.13.1","Eaves - Ventilated - Insulation between and under rafters - Pitched Ceiling",7.4999999999999997E-2,0.04]
["4.13.2","Pitch ceiling/Insulation on flat",0.02,1.7000000000000001E-2]
[4.1399999999999997,"Eaves - Unventilated - Insulation between and over rafters",6.4000000000000001E-2,3.1E-2]
[4.1500000000000004,"Ventilated Roof - Attic floor level",8.1000000000000003E-2,5.0999999999999997E-2]
["4.16/4.17","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",0.06,2.4E-2]
[4.18,"Gable - Insulation between and over rafters - Unventilated rafter void",6.2E-2,3.6999999999999998E-2]
[4.1900000000000004,"Flat Roof - Parapet",4.1000000000000002E-2,4.5999999999999999E-2]
["4.20","Ope – Lintel",0.14399999999999999,8.4000000000000005E-2]
[4.21,"Ope – Jamb",6.4000000000000001E-2,4.2999999999999997E-2]
[4.22,"Ope – Sill",4.8000000000000001E-2,3.4000000000000002E-2]
["4.23.1","Timber Frame Separating Wall through ground floor",0.11799999999999999,0.14899999999999999]
["4.23.2","Timber Frame Partition Wall through ground floor",7.3999999999999996E-2,9.6000000000000002E-2]
["G.01.1","Masonry Separating Wall Head – Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24]
["4.B.1","Balcony within dwelling",0,0]
["4.B.2","Balcony between dwellings",0.02,0.02]

{"sheet":"D5Display","index":7,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[5.01,"Ground Floor - Insulation above slab",3.3000000000000002E-2,3.7999999999999999E-2]
[5.0199999999999996,"Ground Floor - Insulation below slab",0.14099999999999999,0.106]
[5.03,"Lightweight Intermediate Floor",2.1000000000000001E-2,5.5E-2]
[5.04,"Separating Wall (plan)",0.10299999999999999,0.114]
[5.05,"Separating Wall (section)",0.52,0.189]
[5.0599999999999996,"Stud Partition Wall",0,0]
["5.07/5.08","Eaves – Unventilated/Ventilated Attic",0.03,2.5999999999999999E-2]
["5.09.1/5.10.1","Eaves – Unventilated/Ventilated – Insulation between and under rafters - Dormer",3.2000000000000001E-2,2.5999999999999999E-2]
["5.09.2/5.10.2","Eaves –Insulation between and under rafters – Unventilated/Ventilated void – Pitch Ceiling Dormer",1.4E-2,1.2999999999999999E-2]
["5.11.1","Eaves – Ventilated – Insulation between and under rafters – Pitched ceiling",1.0999999999999999E-2,1.2E-2]
["5.11.2","Eaves – Ventilated – Insulation between and under rafters – Pitched with flat ceiling",0.02,1.7000000000000001E-2]
[5.12,"Eaves – Insulation between and over rafters – Unventilated rafter void",7.0000000000000001E-3,8.9999999999999993E-3]
[5.13,"Ventilated and Unventilated Attic",0.111,4.9000000000000002E-2]
["5.14/5.15","Gable – Insulation between and under rafters – Unventilated/Ventilated rafter void",4.9000000000000002E-2,3.4000000000000002E-2]
[5.16,"Gable – Insulation between and over rafters – Unventilated rafter void",5.5E-2,3.6999999999999998E-2]
[5.17,"Flat Roof – Eaves",5.3999999999999999E-2,4.2999999999999997E-2]
[5.18,"Flat Roof – Parapet",9.2999999999999999E-2,5.3999999999999999E-2]
[5.19,"Ope – Lintel",6.0000000000000001E-3,1.6E-2]
["5.20","Ope – Jamb",2.3E-2,1.9E-2]
[5.21,"Ope – Sill",1.2E-2,2.1000000000000001E-2]
["5.22.1","Steel Separating Wall through ground floor",0.21299999999999999,0.26300000000000001]
["5.22.2","Steel Partition Wall through ground floor",0.125,0.14799999999999999]
["5.23.1","Corner",7.4999999999999997E-2,2.9000000000000001E-2]
["5.23.2","Inverted corner",-4.4999999999999998E-2,-4.2999999999999997E-2]
["G.01.1","Masonry Separating Wall Head – Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24]
["5.B.1","Balcony within dwelling",0,0]
["5.B.2","Balcony between dwellings",0.02,0.02]

{"sheet":"D6Display","index":8,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[6.01,"Ground Floor - Insulation above slab",3.9E-2,3.1E-2]
[6.02,"Ground Floor - Insulation below slab",0.05,3.9E-2]
[6.03,"Timber Suspended Ground Floor",2.9000000000000001E-2,2.1000000000000001E-2]
[6.04,"Timber Intermediate Floor - Within a dwelling",0.10100000000000001,8.1000000000000003E-2]
["6.05.1","Masonry Separating (solid) Wall - plan",0.29599999999999999,0.28399999999999997]
["6.05.2","Masonry Separating (cavity) Wall - plan",0.316,0.309]
[6.06,"Masonry Partition Wall - plan",0.155,0.156]
[6.07,"Stud Partition",0,0]
["6.08/6.09","Eaves – Unventilated/Ventilated roof space",2.1000000000000001E-2,2.1000000000000001E-2]
["6.10","Eaves - Insulation between and under rafters – ventilated rafter void - Dormer",2.1999999999999999E-2,2.1999999999999999E-2]
["6.10.2","Eaves – Insulation between and under rafters – Ventilated void – Pitched Ceiling Dormer ",1.4E-2,1.2999999999999999E-2]
[6.11,"Eaves - Insulation between and under rafters – Ventilated rafter void – Pitched ceiling",3.0000000000000001E-3,2E-3]
["6.11.2","Eaves - Ventilated - Insulation between and under rafters – Pitched with flat ceiling",0.02,0.02]
[6.12,"Eaves - Unventilated - Insulation between and over rafters - Dormer",1.0999999999999999E-2,1.4999999999999999E-2]
[6.13,"Ventilated Roof - Attic floor level",3.7999999999999999E-2,3.4000000000000002E-2]
["6.14/6.15","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",2.5999999999999999E-2,2.1999999999999999E-2]
[6.16,"Gable - Insulation between and over rafters - Unventilated rafter void",3.5999999999999997E-2,3.1E-2]
[6.17,"Flat Roof - Eaves",5.2999999999999999E-2,3.9E-2]
[6.18,"Flat Roof - Parapet",4.5999999999999999E-2,3.7999999999999999E-2]
[6.19,"Ope - Lintel",3.6999999999999998E-2,4.2000000000000003E-2]
["6.20","Ope - Jamb",3.1E-2,3.5999999999999997E-2]
[6.21,"Ope - Sill",-4.0000000000000001E-3,3.0000000000000001E-3]
["6.C1 ","Corner",1.7999999999999999E-2,1.6E-2]
["6.C2 ","Inverted Corner",-4.7E-2,-4.2000000000000003E-2]
["G.01.1","Masonry Separating (cavity) Wall Head - Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating (solid) Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.245]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15]
["6.B.1","Balcony within dwelling",0,0]
["6.B.2","Balcony between dwellings",0.02,0.02]

{"sheet":"Table D1","index":9,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[24,1,25,1],[24,2,25,2],[24,3,25,3],[24,4,25,4],[0,0,1,0],[0,1,1,1],[0,2,1,4],[2,1,4,1],[5,0,6,0],[5,1,6,1],[7,0,7,1],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4],[63,0,63,4],[43,0,43,1],[49,0,49,1],[53,0,53,1],[57,0,57,4],[59,0,59,4],[61,0,61,4]]}
["Table D1","Section 1 - Cavity Wall Insulation","Target U-values"]
[]
["Junction detail Identifier","Junction detail","U-value = 0.21 W/m2K, 150mm full-fill or partial fill cavity1, 3","U-value = 0.15 W/m2K, 150mm full-fill or partial fill cavity and internal insulation2, 3","U-value = 0.15 W/m2K, 200mm full-fill or partial fill cavity2, 3"]
["2011 Edition",null,"(roof U = 0.16)","(roof U = 0.14)","(roof U = 0.14)"]
[null,null,"(floor U = 0.21)","(floor U = 0.15)","(floor U = 0.15)"]
[null,null,"ψ-value","ψ-value","ψ-value"]
[null,null,"(W/mK)","(W/mK)","(W/mK)"]
["Section 1 Details"]
["1.01a","Ground Floor - Insulation above slab",0.17,7.1999999999999995E-2,0.19600000000000001]
["1.01b","Ground Floor - Insulation above slab plus lightweight block",0.08,4.2000000000000003E-2,9.2999999999999999E-2]
["1.02a","Ground Floor - Insulation below slab",0.16300000000000001,0.108,0.191]
["1.02b","Ground Floor - Insulation below slab plus lightweight block",7.0000000000000007E-2,6.0999999999999999E-2,8.3000000000000004E-2]
[1.03,"Timber Suspended Ground Floor",0.219,0.10199999999999999,0.22700000000000001]
[1.04,"Concrete Intermediate Floor within a dwelling",0,3.9E-2,0]
["1.04a","Concrete Separating Floor between dwellings",6.4000000000000001E-2,8.6999999999999994E-2,4.4999999999999998E-2]
[1.05,"Timber Intermediate Floor within a dwelling",-1E-3,0.02,-1E-3]
["1.05a","Timber Separating Floor between dwellings",4.1000000000000002E-2,5.0999999999999997E-2,2.9000000000000001E-2]
["1.06.1","Masonry Solid Separating Wall (plan)",4.4999999999999998E-2,6.6000000000000003E-2,3.2000000000000001E-2]
["1.06.2","Masonry Cavity Separating Wall (plan)",5.0999999999999997E-2,7.1999999999999995E-2,3.5999999999999997E-2]
[1.07,"Masonry Partition Wall",0,0,0]
[1.08,"Stud Partition Wall",0,0,0]
["1.09/1.10","Eaves – Unventilated/Ventilated attic",4.9000000000000002E-2,0.03,5.2999999999999999E-2]
["1.11.1/","Eaves – Unventilated/Ventilated - Insulated at ceiling",2.8000000000000001E-2,2.4E-2,3.6999999999999998E-2]
["1.12.1"]
["1.11.2/","Eaves – Unventilated/Ventilated – Insulation between and under rafters – Dormer",1.4E-2,1.2999999999999999E-2,1.2999999999999999E-2]
["1.12.2"]
["1.13.1","Eaves –Ventilated – Insulation between and under rafters – Pitched ceiling",2.1000000000000001E-2,0.02,3.5999999999999997E-2]
["1.13.2","Eaves – Ventilated – Insulation between and under rafters – Pitched with flat ceiling",0.02,1.7000000000000001E-2,1.7000000000000001E-2]
[1.1399999999999999,"Eaves – Unventilated – Insulation between and over rafters – Dormer",8.9999999999999993E-3,1.0999999999999999E-2,3.4000000000000002E-2]
[1.1499999999999999,"Ventilated Roof - Attic floor level",0.27200000000000002,0.152,0.21]
["1.16/1.17","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",6.7000000000000004E-2,4.1000000000000002E-2,6.3E-2]
[1.18,"Gable - Insulation between and over rafters - Unventilated rafter void",9.6000000000000002E-2,5.8000000000000003E-2,7.0999999999999994E-2]
[1.19,"Flat Roof – Eaves",0.04,3.9E-2,3.7999999999999999E-2]
[1.2,"Flat Roof - Parapet",0.152,5.8999999999999997E-2,0.20599999999999999]
[1.21,"Ope - Split Lintels - Steel and Concrete",-3.0000000000000001E-3,5.0000000000000001E-3,1E-3]
[1.22,"Ope - Perforated steel lintel (stainless steel)",0.26100000000000001,0.13800000000000001,0.23599999999999999]
["1.23.1","Ope - Pre-stressed concrete lintels",-5.0000000000000001E-3,4.0000000000000001E-3,1E-3]
["1.23.2","Ope - Pre-stressed concrete lintels - proprietary closer",7.0000000000000001E-3,1.2E-2,6.0000000000000001E-3]
[1.24,"Ope - Jamb with closer block",2.8000000000000001E-2,2.5999999999999999E-2,3.1E-2]
[1.25,"Ope - Jamb with proprietary cavity closer",6.0000000000000001E-3,1.0999999999999999E-2,6.0000000000000001E-3]
[1.26,"Ope - Concrete Forward Sill",6.0000000000000001E-3,1.4999999999999999E-2,1.9E-2]
["1.27.1","Corner",4.3999999999999997E-2,3.2000000000000001E-2,3.5000000000000003E-2]
["1.27.2","Inverted corner",-6.9000000000000006E-2,-5.2999999999999999E-2,-5.5E-2]
["Section G General Details"]
["G.01.1","Masonry Separating (cavity) Wall Head - Section",0.51100000000000001,0.48399999999999999,0.48399999999999999]
["G.01.2","Masonry Separating (solid) Wall Head - Section",0.48799999999999999,0.45800000000000002,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24,0.24]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15,0.15]
[]
["Appendix 2 Details"]
["Diagram 1","Galvanised Steel top hat lintel detail bridging masonry cavity wall",0.48299999999999998,0.20599999999999999,0.45400000000000001]
["Diagram 2","Concrete Back sill detail (insulation below wood sill section)",0.38300000000000001,0.17399999999999999,0.39500000000000002]
["Diagram 3","Eaves - Ventilated roof space - wall head closed with slate",7.1999999999999995E-2,5.3999999999999999E-2,0.13100000000000001]
["Other Details"]
["1.B.1","Balcony within dwelling4",0,0,0]
["1.B.2","Balcony between dwellings4, 5",0.02,0.02,0.02]
[]
["1 ψ values for a Target U-value for the wall of 0.21 W/m2K can be used for a range of U-values down to 0.18 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling = 0.13 to 0.16 W/m2K; Flat Roof = 0.16 to 0.2 W/m2K; Ground Floor = 0.16 to 0.21 W/m2K."]
[]
["2 ψ values for a Target U-value for the wall of 0.15 W/m2K can be used for a range of U-values from of 0.12 W/m2K to 0.17 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling 0.11 to 0.16W/m2K; Flat Roof = 0.11 to 0.17 W/m2K; Ground Floor = 0.12 to 0.18 W/m2K."]
[]
["3 Where two building elements have one U-value above its target while the other is below its target U-value, the aggregate percentage change from the respective target U-values in the table should not exceed +20% for the Psi (ψ) value to be valid, i.e. if for the 0.15 U-value wall, if the U-value was increased by 10% above the wall target U-value (from 0.15 to 0.165), then the roof U-value could be at most 10% below the roof target U-value (from 0.14 to 0.126), because the aggregate change would then be 20%."]
[]
["4 This is an externally supported balcony (the balcony slab is not a continuation of the floorslab) where the wall insulation is continuous and not bridged by the balcony slab."]
[]
["5 Value of Ψ is applied to each dwelling."]

{"sheet":"Table D2","index":10,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[[33,0,33,1],[0,0,1,0],[0,1,1,1],[0,2,1,3],[2,1,4,1],[6,0,6,1],[38,0,38,1],[42,0,42,3],[44,0,44,3],[46,0,46,3],[48,0,48,3]]}
["Table D2","Section 2 - External Insulation","Target U-values"]
[]
["Junction detail Identifier","Junction detail","U = 0.21 Wm2K1, 3","U = 0.15 Wm2K2, 3"]
["2011 Edition",null,"(roof U = 0.16)","(roof U = 0.14)"]
[null,null,"(floor U = 0.21)","(floor U = 0.15)"]
[null,null,"ψ-value (W/mK)","ψ-value (W/mK)"]
["Section 2 Details"]
[2.0099999999999998,"Ground Floor - Insulation above slab",0.13100000000000001,0.14499999999999999]
["2.01a","Ground Floor - Insulation above slab",0.214,0.25900000000000001]
[2.02,"Ground Floor - Insulation below slab",0.16200000000000001,0.17199999999999999]
["2.02a","Ground Floor - Insulation below slab",0.23499999999999999,0.247]
[2.0299999999999998,"Timber Suspended Ground Floor",0.158,0.20399999999999999]
["2.03a","Timber Suspended Ground Floor",0.29699999999999999,0.36799999999999999]
[2.04,"Concrete Intermediate Floor within a dwelling",1E-3,0]
["2.04a","Concrete Separating Floor between dwellings",7.0999999999999994E-2,4.8000000000000001E-2]
[2.0499999999999998,"Masonry Separating Wall - plan",4.9000000000000002E-2,3.3000000000000002E-2]
[2.06,"Masonry Partition Wall",0,0]
[2.0699999999999998,"Stud Partition Wall",0,0]
["2.08/2.09","Eaves – Unventilated/Ventilated roof space",6.7000000000000004E-2,7.3999999999999996E-2]
["2.10.1/2.11.1","Eaves – Unventilated/Ventilated - Insulation between and under rafters – Dormer",0.05,5.5E-2]
["2.12.1","Eaves - Unventilated - Insulation between and over rafters - Pitched ceiling",1.6E-2,3.1E-2]
["2.12.2","Eaves – Unventilated/Ventilated - Insulation between and under rafters - Pitched with flat ceiling",0.02,1.7000000000000001E-2]
[2.13,"Eaves - Unventilated - Insulation between and over rafters",1.2999999999999999E-2,2.7E-2]
[2.14,"Ventilated Roof - Attic floor level",0.34699999999999998,0.33500000000000002]
["2.15/2.16","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",9.0999999999999998E-2,8.6999999999999994E-2]
[2.17,"Gable - Insulation between and over rafters - Unventilated rafter void",0.13100000000000001,0.106]
[2.1800000000000002,"Flat Roof - Eaves",4.5999999999999999E-2,4.4999999999999998E-2]
[2.19,"Flat Roof - Parapet",0.34899999999999998,0.32700000000000001]
[2.2000000000000002,"Ope - Lintel",9.7000000000000003E-2,9.8000000000000004E-2]
[2.21,"Ope - Jamb",8.7999999999999995E-2,9.0999999999999998E-2]
[2.2200000000000002,"Sill",0.14899999999999999,0.109]
["2.23.1","Corner",9.9000000000000005E-2,7.0000000000000007E-2]
["2.23.2","Inverted corner",-0.14099999999999999,-9.6000000000000002E-2]
["Section G General Details"]
["G.01.1","Masonry Separating Wall Head – Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15]
["Other Details"]
["2.B.1","Balcony within dwelling4",0,0]
["2.B.2","Balcony between dwellings4, 5",0.02,0.02]
[]
["1 ψ values for a Target U-value for the wall of 0.21 W/m2K can be used for a range of U-values down to 0.18 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling = 0.13 to 0.16 W/m2K; Flat Roof = 0.16 to 0.2 W/m2K; Ground Floor = 0.16 to 0.21 W/m2K."]
[]
["2 ψ values for a Target U-value for the wall of 0.15 W/m2K can be used for a range of U-values from of 0.12 W/m2K to 0.17 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling 0.11 to 0.16 W/m2K; Flat Roof = 0.11 to 0.17 W/m2K; Ground Floor = 0.12 to 0.18."]
[]
["3 Where two building elements have one U-value above its target while the other is below its target U-value, the aggregate percentage change from the respective target U-values in the table should not exceed +20% for the Psi (ψ) value to be valid, i.e. if for the 0.15 U-value wall, if the U-value was increased by 10% above the wall target U-value (from 0.15 to 0.165), then the roof U-value could be at most 10% below the roof target U-value (from 0.14 to 0.126), because the aggregate change would then be 20%."]
[]
["4 This is an externally supported balcony (the balcony slab is not a continuation of the floorslab) where the wall insulation is continuous and not bridged by the balcony slab."]
[]
["5 Value of Ψ is applied to each dwelling."]

{"sheet":"Table D3","index":11,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,0,7,1],[8,1,8,3],[0,0,1,0],[0,1,1,1],[0,2,1,3],[2,1,4,1],[5,0,6,0],[5,1,6,1]]}
["Table D3","Section 3 – Internal Insulation","Target U-values"]
[]
["Junction detail Identifier","Junction detail","0.21 Wm2K U-value.  Insulation between studs1, 3","0.15 Wm2K U-value.  Insulation between studs and internal Insulation2, 3"]
["2011 Edition",null,"(roof U = 0.16)","(roof U = 0.14)"]
[null,null,"(floor U = 0.21)","(floor U = 0.15)"]
[null,null,"ψ-value","ψ-value"]
[null,null,"(W/mK)","(W/mK)"]
["Section 3 Details"]
[null,"Refer to Table D6 for Section 3 Psi values"]

{"sheet":"Table D4","index":12,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,3],[2,1,4,1],[5,0,6,0],[5,1,6,1],[43,0,43,3],[45,0,45,3],[41,0,41,3],[7,0,7,1],[33,0,33,1],[37,0,37,1],[40,0,40,3]]}
["Table D4","Section 4 - Timber Frame Construction","Target U-values"]
[]
["Junction detail Identifier","Junction detail","0.21 Wm2K U-value.  Insulation between studs1, 3","0.15 Wm2K U-value.  Insulation between studs and internal Insulation2, 3"]
["2011 Edition",null,"(roof U = 0.16)","(roof U = 0.14)"]
[null,null,"(floor U = 0.21)","(floor U = 0.15)"]
[null,null,"ψ-value","ψ-value"]
[null,null,"(W/mK)","(W/mK)"]
["Section 4 Details"]
[4.01,"Ground Floor - Insulation above slab",5.0999999999999997E-2,2.1000000000000001E-2]
[4.0199999999999996,"Ground Floor - Insulation below slab",0.20499999999999999,0.125]
[4.03,"Timber Suspended Ground Floor",6.3E-2,4.5999999999999999E-2]
["4.04.1","Corner",6.2E-2,0.03]
["4.04.2","Inverted corner",-4.0000000000000001E-3,-1.4999999999999999E-2]
[4.05,"Timber Intermediate Floor within a dwelling",0.13,0.08]
["4.05a","Timber Separating floor between dwellings",0.193,0.13200000000000001]
[4.0599999999999996,"Separating Wall (plan)",8.6999999999999994E-2,7.9000000000000001E-2]
[4.07,"Separating Wall (section)",0.23599999999999999,0.23599999999999999]
[4.08,"Partition Wall",0,0]
["4.09/4.10","Eaves – Unventilated/Ventilated roof space",8.2000000000000003E-2,4.3999999999999997E-2]
["4.11.1/4.12.1","Eaves -Insulation between and under rafters – Unventilated/Ventilated rafter void – Dormer",5.3999999999999999E-2,3.9E-2]
["4.12.2","Eaves – Insulation between and under rafters – Unventilated/Ventilated rafter void – Pitched Ceiling Dormer",1.4E-2,1.2999999999999999E-2]
["4.13.1","Eaves - Ventilated - Insulation between and under rafters - Pitched Ceiling",7.4999999999999997E-2,0.04]
["4.13.2","Pitch ceiling/Insulation on flat",0.02,1.7000000000000001E-2]
[4.1399999999999997,"Eaves - Unventilated - Insulation between and over rafters",6.4000000000000001E-2,3.1E-2]
[4.1500000000000004,"Ventilated Roof - Attic floor level",8.1000000000000003E-2,5.0999999999999997E-2]
["4.16/4.17","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",0.06,2.4E-2]
[4.18,"Gable - Insulation between and over rafters - Unventilated rafter void",6.2E-2,3.6999999999999998E-2]
[4.1900000000000004,"Flat Roof - Parapet",4.1000000000000002E-2,4.5999999999999999E-2]
[4.2,"Ope – Lintel",0.14399999999999999,8.4000000000000005E-2]
[4.21,"Ope – Jamb",6.4000000000000001E-2,4.2999999999999997E-2]
[4.22,"Ope – Sill",4.8000000000000001E-2,3.4000000000000002E-2]
["4.23.1","Timber Frame Separating Wall through ground floor",0.11799999999999999,0.14899999999999999]
["4.23.2","Timber Frame Partition Wall through ground floor",7.3999999999999996E-2,9.6000000000000002E-2]
["Section G General Details"]
["G.01.1","Masonry Separating Wall Head – Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24]
["Other Details"]
["4.B.1","Balcony within dwelling4",0,0]
["4.B.2","Balcony between dwellings4, 5",0.02,0.02]
["1 ψ values for a Target U-value for the wall of 0.21 W/m2K can be used for a range of U-values down to 0.18 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling = 0.13 to 0.16 W/m2K; Flat Roof = 0.16 to 0.2 W/m2K; Ground Floor = 0.16 to 0.21 W/m2K."]
["2 ψ values for a Target U-value for the wall of 0.15 W/m2K can be used for a range of U-values from of 0.12 W/m2K to 0.17 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling 0.11 to 0.16W/m2K; Flat Roof = 0.11 to 0.17 W/m2K; Ground Floor = 0.12 to 0.18."]
[]
["3 Where two building elements have one U-value above its target while the other is below its target U-value, the aggregate percentage change from the respective target U-values in the table should not exceed +20% for the Psi (ψ) value to be valid, i.e. if for the 0.15 U-value wall, if the U-value was increased by 10% above the wall target U-value (from 0.15 to 0.165), then the roof U-value could be at most 10% below the roof target U-value (from 0.14 to 0.126), because the aggregate change would then be 20%."]
[]
["4 This is an externally supported balcony (the balcony slab is not a continuation of the floorslab) where the wall insulation is continuous and not bridged by the balcony slab."]
[]
["5 Value of Ψ is applied to each dwelling."]

{"sheet":"Table D5","index":13,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[31,0,31,1],[0,0,1,0],[0,1,1,1],[0,2,1,3],[2,1,4,1],[5,0,6,1],[35,0,35,1],[39,0,39,3],[41,0,41,3],[43,0,43,3],[45,0,45,3]]}
["Table D5","Section 5 - Steel Frame Construction","Target U-values"]
[]
["Junction detail Identifier","Junction detail","Hybrid steel frame U-value = 0.211, 3","Hybrid steel frame with internal insulation U-value = 0.152, 3"]
["2011 Edition",null,"(roof U = 0.16)","(roof U = 0.14)"]
[null,null,"(floor U = 0.21)","(floor U = 0.15)"]
["Section 5 Details",null,"ψ-value","ψ-value"]
[null,null,"(W/mK)","(W/mK)"]
[5.01,"Ground Floor - Insulation above slab",3.3000000000000002E-2,3.7999999999999999E-2]
[5.0199999999999996,"Ground Floor - Insulation below slab",0.14099999999999999,0.106]
[5.03,"Lightweight Intermediate Floor",2.1000000000000001E-2,5.5E-2]
[5.04,"Separating Wall (plan)",0.10299999999999999,0.114]
[5.05,"Separating Wall (section)",0.52,0.189]
[5.0599999999999996,"Stud Partition Wall",0,0]
["5.07/5.08","Eaves – Unventilated/Ventilated Attic",0.03,2.5999999999999999E-2]
["5.09.1/5.10.1","Eaves – Unventilated/Ventilated – Insulation between and under rafters - Dormer",3.2000000000000001E-2,2.5999999999999999E-2]
["5.09.2/5.10.2","Eaves –Insulation between and under rafters – Unventilated/Ventilated void – Pitch Ceiling Dormer",1.4E-2,1.2999999999999999E-2]
["5.11.1","Eaves – Ventilated – Insulation between and under rafters – Pitched ceiling",1.0999999999999999E-2,1.2E-2]
["5.11.2","Eaves – Ventilated – Insulation between and under rafters – Pitched with flat ceiling",0.02,1.7000000000000001E-2]
[5.12,"Eaves – Insulation between and over rafters – Unventilated rafter void",7.0000000000000001E-3,8.9999999999999993E-3]
[5.13,"Ventilated and Unventilated Attic",0.111,4.9000000000000002E-2]
["5.14/5.15","Gable – Insulation between and under rafters – Unventilated/Ventilated rafter void",4.9000000000000002E-2,3.4000000000000002E-2]
[5.16,"Gable – Insulation between and over rafters – Unventilated rafter void",5.5E-2,3.6999999999999998E-2]
[5.17,"Flat Roof – Eaves",5.3999999999999999E-2,4.2999999999999997E-2]
[5.18,"Flat Roof – Parapet",9.2999999999999999E-2,5.3999999999999999E-2]
[5.19,"Ope – Lintel",6.0000000000000001E-3,1.6E-2]
[5.2,"Ope – Jamb",2.3E-2,1.9E-2]
[5.21,"Ope – Sill",1.2E-2,2.1000000000000001E-2]
["5.22.1","Steel Separating Wall through ground floor",0.21299999999999999,0.26300000000000001]
["5.22.2","Steel Partition Wall through ground floor",0.125,0.14799999999999999]
["5.23.1","Corner",7.4999999999999997E-2,2.9000000000000001E-2]
["5.23.2","Inverted corner",-4.4999999999999998E-2,-4.2999999999999997E-2]
["Section G General Details"]
["G.01.1","Masonry Separating Wall Head – Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.24]
["Other Details"]
["5.B.1","Balcony within dwelling4",0,0]
["5.B.2","Balcony between dwellings4, 5",0.02,0.02]
[]
["1 ψ values for a Target U-value for the wall of 0.21 W/m2K can be used for a range of U-values down to 0.18 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling = 0.13 to 0.16 W/m2K; Flat Roof = 0.16 to 0.2 W/m2K; Ground Floor = 0.16 to 0.21 W/m2K."]
[]
["2 ψ values for a Target U-value for the wall of 0.15 W/m2K can be used for a range of U-values from of 0.12 W/m2K to 0.17 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling 0.11 to 0.16 W/m2K; Flat Roof = 0.11 to 0.17 W/m2K; Ground Floor = 0.12 to 0.18."]
[]
["3 Where two building elements have one U-value above its target while the other is below its target U-value, the aggregate percentage change from the respective target U-values in the table should not exceed +20% for the Psi (ψ) value to be valid, i.e. if for the 0.15 U-value wall, if the U-value was increased by 10% above the wall target U-value (from 0.15 to 0.165), then the roof U-value could be at most 10% below the roof target U-value (from 0.14 to 0.126), because the aggregate change would then be 20%."]
[]
["4 This is an externally supported balcony (the balcony slab is not a continuation of the floorslab) where the wall insulation is continuous and not bridged by the balcony slab."]
[]
["5 Value of Ψ is applied to each dwelling."]

{"sheet":"Table D6","index":14,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,3],[2,1,4,1],[5,0,6,0],[5,1,6,1],[47,0,47,3],[7,0,7,1],[32,0,32,1],[37,0,37,1],[41,0,41,3],[43,0,43,3],[45,0,45,3]]}
["Table D6","Section 6 - Hollow Block Construction","Target U-values"]
[]
["Junction detail","Junction detail","Hollow Block with internal insulation U-value = 0.21 W/m2K1, 3","Hollow Block with internal insulation U-value = 0.15 W/m2K2, 3"]
["Identifier",null,"(roof U = 0.16)","(roof U = 0.14)"]
["2011 Edition",null,"(floor U = 0.21)","(floor U = 0.15)"]
[null,null,"ψ-value","ψ-value"]
[null,null,"(W/mK)","(W/mK)"]
["Section 6 Details"]
[6.01,"Ground Floor - Insulation above slab",3.9E-2,3.1E-2]
[6.02,"Ground Floor - Insulation below slab",0.05,3.9E-2]
[6.03,"Timber Suspended Ground Floor",2.9000000000000001E-2,2.1000000000000001E-2]
[6.04,"Timber Intermediate Floor - Within a dwelling",0.10100000000000001,8.1000000000000003E-2]
["6.05.1","Masonry Separating (solid) Wall - plan",0.29599999999999999,0.28399999999999997]
["6.05.2","Masonry Separating (cavity) Wall - plan",0.316,0.309]
[6.06,"Masonry Partition Wall - plan",0.155,0.156]
[6.07,"Stud Partition",0,0]
["6.08/6.09","Eaves – Unventilated/Ventilated roof space",2.1000000000000001E-2,2.1000000000000001E-2]
[6.1,"Eaves - Insulation between and under rafters – ventilated rafter void - Dormer",2.1999999999999999E-2,2.1999999999999999E-2]
["6.10.2","Eaves – Insulation between and under rafters – Ventilated void – Pitched Ceiling Dormer ",1.4E-2,1.2999999999999999E-2]
[6.11,"Eaves - Insulation between and under rafters – Ventilated rafter void – Pitched ceiling",3.0000000000000001E-3,2E-3]
["6.11.2","Eaves - Ventilated - Insulation between and under rafters – Pitched with flat ceiling",0.02,0.02]
[6.12,"Eaves - Unventilated - Insulation between and over rafters - Dormer",1.0999999999999999E-2,1.4999999999999999E-2]
[6.13,"Ventilated Roof - Attic floor level",3.7999999999999999E-2,3.4000000000000002E-2]
["6.14/6.15","Gable - Insulation between and under rafters – Unventilated/Ventilated rafter void",2.5999999999999999E-2,2.1999999999999999E-2]
[6.16,"Gable - Insulation between and over rafters - Unventilated rafter void",3.5999999999999997E-2,3.1E-2]
[6.17,"Flat Roof - Eaves",5.2999999999999999E-2,3.9E-2]
[6.18,"Flat Roof - Parapet",4.5999999999999999E-2,3.7999999999999999E-2]
[6.19,"Ope - Lintel",3.6999999999999998E-2,4.2000000000000003E-2]
[6.2,"Ope - Jamb",3.1E-2,3.5999999999999997E-2]
[6.21,"Ope - Sill",-4.0000000000000001E-3,3.0000000000000001E-3]
["6.C1 ","Corner",1.7999999999999999E-2,1.6E-2]
["6.C2 ","Inverted Corner",-4.7E-2,-4.2000000000000003E-2]
["Section G General Details"]
["G.01.1","Masonry Separating (cavity) Wall Head - Section",0.51100000000000001,0.48399999999999999]
["G.01.2","Masonry Separating (solid) Wall Head – Section",0.48799999999999999,0.45800000000000002]
["G.05.1","Solid Masonry Separating Wall through ground floor",0.20100000000000001,0.245]
["G.05.2","Solid Masonry (narrow) Partition Wall through ground floor",0.13800000000000001,0.15]
["Other Details"]
["6.B.1","Balcony within dwelling4",0,0]
["6.B.2","Balcony between dwellings4, 5",0.02,0.02]
[]
["1 ψ values for a Target U-value for the wall of 0.21 W/m2K can be used for a range of U-values down to 0.18 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U-value as follows: Pitched roof insulation on slope, insulation on ceiling = 0.13 to 0.16 W/m2K; Flat Roof = 0.16 to 0.2 W/m2K; Ground Floor = 0.16 to 0.21 W/m2K."]
[]
["2 ψ values for a Target U-value for the wall of 0.15 W/m2K can be used for a range of U-values from of 0.12 W/m2K to 0.16 W/m2K for the construction type specified.  The U-values of the flanking elements to the wall can vary from the flanking element target U value as follows: Pitched roof insulation on slope, insulation on ceiling = 0.11 to 0.16 W/m2K; Flat Roof = 0.11 to 0.17 W/m2K; Ground Floor = 0.12 to 0.18."]
[]
["3 Where two building elements have one U-value above its target while the other is below its target U-value, the aggregate percentage change from the respective target U-values in the table should not exceed +20% for the Psi (ψ) value to be valid, i.e. if for the 0.15 U-value wall, if the U-value was increased by 10% above the wall target U-value (from 0.15 to 0.165), then the roof U-value could be at most 10% below the roof target U-value (from 0.14 to 0.126), because the aggregate change would then be 20%."]
[]
["4 This is an externally supported balcony (the balcony slab is not a continuation of the floorslab) where the wall insulation is continuous and not bridged by the balcony slab."]
[]
["5 Value of Ψ is applied to each dwelling."]