Revision history [back]

Here's a query that should prove useful to return a table of characteristics for fenestration:

SELECT DISTINCT t1.Value as Fenestration, t2.Value as SHGC, t3.Value as VT, t4.Value as 'U-Factor'
FROM TabularDataWithStrings t1

LEFT JOIN TabularDataWithStrings t2
              ON t1.RowName = t2.RowName

LEFT JOIN TabularDataWithStrings t3
              ON t1.RowName = t3.RowName

LEFT JOIN TabularDataWithStrings t4
              ON t1.RowName = t4.RowName

WHERE t1.ReportName='EnvelopeSummary'
              AND t1.ReportForString='Entire Facility'
              AND t1.TableName='Exterior Fenestration'
              AND t1.ColumnName='Construction'
              AND t1.Value != ''

              AND t2.ReportName='EnvelopeSummary'
              AND t2.ReportForString='Entire Facility'
              AND t2.TableName='Exterior Fenestration'
              AND t2.ColumnName='Glass SHGC'


              AND t3.ReportName='EnvelopeSummary'
              AND t3.ReportForString='Entire Facility'
              AND t3.TableName='Exterior Fenestration'
              AND t3.ColumnName='Glass Visible Transmittance'


              AND t4.ReportName='EnvelopeSummary'
              AND t4.ReportForString='Entire Facility'
              AND t4.TableName='Exterior Fenestration'
              AND t4.ColumnName='Glass U-Factor'

This returns a table like so:

Fenestration, SHGC, VT, U-Factor
ASHRAE 189.1-2009 EXTWINDOW CLIMATEZONE 4-5, 0.352, 0.442, 2.559