**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\EnergyCertificate.rpt **************************************************************************** Report Information Version: 11.0 Printer: Brother DCP-7030 Printer Main Body Formula Fields Field: valBuildingType Formula: Formula = "" Field: valAddress Formula: Formula = "" Field: valCity Formula: Formula = "" Field: valBuiltYear Formula: Formula = "" Field: valBuildingID Formula: Formula = "" Field: CalcCertIsGivenOn_1 Formula: If {@valCertBasedOn} = "1" then formula = "x" else formula = "" end if Field: CalcCertIsGivenOn_2 Formula: If {@valCertBasedOn} = "2" then formula = "x" else formula = "" end if Field: CalcCertIsGivenOn_3 Formula: If {@valCertBasedOn} = "3" then formula = "x" else formula = "" end if Field: valETclass Formula: Formula = "" Field: valCertGranter Formula: Formula = "" Field: valCertOrderer Formula: Formula = "" Field: valCertGrantedDate Formula: Formula = "" Field: valCertExpiresDate Formula: Formula = "" Field: valConsElec Formula: Formula = "" Field: valConsCold Formula: Formula = "" Field: CalcConsSum Formula: Formula = {@CalcConsHeatEne} + {@CalcConsElec_Top} + {@CalcConsCold} Field: valArea Formula: Formula = "" Field: valHeatSource1_Name Formula: Formula = "" Field: valHeatSource2_Name Formula: Formula = "" Field: valHeatSource1_Value Formula: Formula = "" Field: valHeatSource2_Value Formula: Formula = "" Field: valHeatSource1_Year Formula: Formula = "" Field: valHeatSource2_Year Formula: Formula = "" Field: valConsCold_District Formula: Formula = "" Field: valConsCold_Elec Formula: Formula = "" Field: valConsWater_Total Formula: Formula = "" Field: valConsWater_Warm Formula: Formula = "" Field: valConsElecYear Formula: Formula = "" Field: valConsCold_District_Year Formula: Formula = "" Field: valConsCold_Elec_Year Formula: Formula = "" Field: valConsWater_Total_Year Formula: Formula = "" Field: valConsWater_Warm_Year Formula: Formula = "" Field: valHeatRef_City Formula: Formula = "" Field: valHeatIndex_RefCity_NormalYear Formula: Formula = "" Field: valHeatIndex_Year Formula: Formula = "" Field: valHeatIndex_RefCity_RefYear Formula: Formula = "" Field: valHeatIndex_CorrectFactor Formula: Formula = "" Field: valHeat_EfficiencyFactor Formula: Formula = "" Field: lblCaption Formula: Formula = "ENERGIATODISTUS" Field: lblBuilding Formula: Formula = "Rakennus" Field: lblBuildingType Formula: Formula = "Rakennustyyppi:" Field: lblAddress Formula: Formula = "Osoite:" Field: lblBuiltYear Formula: Formula = "Rakennusvuosi:" Field: lblBuildingID Formula: Formula = "Rakennustunnus:" Field: lblCertGranted Formula: Formula = "Energiatodistus on annettu" Field: lblCertGrantedOpt1 Formula: formula = "rakennuslupamenettelyn yhteydessä ja perustuu laskennalliseen kulutukseen" Field: lblCertGrantedOpt2 Formula: formula = "energiakatselmuksen yhteydessä ja perustuu toteutuneeseen kulutukseen" Field: lblCertGrantedOpt3 Formula: formula = "erillisen tarkastuksen yhteydessä ja perustuu toteutuneeseen kulutukseen" Field: lblET Formula: formula = "ET-luku" Field: lblSmallCons Formula: formula = "Vähän kuluttava" Field: lblBuildingETclass Formula: Formula = "Rakennuksen ET-luokka" Field: lblHighCons Formula: Formula = "Paljon kuluttava" Field: lblETwUnit Formula: Formula = "Rakennuksen energiatehokkuusluku (ETluku, kWh/brm²/vuosi):" Field: lblETscale Formula: formula = "Energiatehokkuusluvun luokitteluasteikko:" Field: lblCertGranter Formula: formula = "Todistuksen antaja:" Field: lblCertOrderer Formula: formula = "Todistuksen tilaaja" Field: lblCertGranterSignature Formula: Formula = "Allekirjoitus:" Field: lblCertGrantedDate Formula: formula = "Todistuksen antamispäivä:" Field: lblCertExpires Formula: formula = "Viimeinen voimassaolopäivä:" Field: lblLegalText Formula: formula = "Energiatodistus perustuu lakiin rakennusten energiatodistuksesta (487/2007) ja 19.6.2007 annettuun ympäristöministeriön asetukseen energiatodistuksesta. Tämä energiatodistus on asetuksen lomakkeen 2 mukainen." Field: lblConsCaption Formula: formula = "RAKENNUKSEN ENERGIANKULUTUS" Field: lblETCalcRules Formula: formula = "Energiatehokkuusluvun laskenta" Field: lblConsHeat Formula: formula = "Lämmitysenergian kulutus *" Field: lblConsElec Formula: formula = "Kiinteistösähkön kulutus" Field: lblConsCold Formula: formula = "Jäähdytysenergian kulutus *" Field: lblConsSum Formula: Formula = "Yhteensä" Field: lblArea Formula: formula = "Rakennuksen bruttoala" Field: lblBuildingET Formula: formula = "Rakennuksen energiatehokkuusluku" Field: lblkWhPerYear Formula: formula = "kWh/vuosi" Field: lblkWhPerAreaPerYear Formula: formula = "kWh/brm²/vuosi" Field: lblETCalcInfo1 Formula: formula = "* Uudisrakennuksen energiankulutus lasketaan käyttäen" Field: lblETCalcInfo2 Formula: formula = "RakMk D5 Liite 1 säävyöhyke III (JyväskyläLuonetjärvi) mukaisia säätietoja." Field: lblConsHistory Formula: Formula = "Toteutuneet energian ja veden kulutukset" Field: lblConsType Formula: Formula = "Kulutuskohde" Field: lblConsValue Formula: Formula = "Kulutus" Field: lblConsUnit Formula: Formula = "Yksikkö" Field: lblConsYear Formula: formula = "Vuosi" Field: lblConsHeatTable Formula: Formula = "Lämmitysenergia" Field: lblConsElecTable Formula: Formula = "Kiinteistösähkö" Field: lblConsElecMeasured Formula: Formula = "Mitattu kiinteistösähkö" Field: lblConsColdTable Formula: formula = "Jäähdetysenergia" Field: lblConsColdDistrict Formula: formula = "Kaukojäähdytys" Field: lblConsColdElec Formula: formula = "Jäähdytyssähkö" Field: lblConsWaterTable Formula: Formula = "Vedenkulutus" Field: lblConsWaterTotal Formula: Formula = "Kokonaiskulutus" Field: lblConsWaterWarm Formula: formula = "Lämpimän veden kulutus" Field: lblConsConversion Formula: Formula = "Toteutuneiden kulutusten muuntaminen energiatehokkuusluvun laskentaa varten" Field: lblHeatRefCity Formula: Formula = "Vertailupaikkakunta:" Field: lblHeatIndexRefNormal Formula: formula = "Normaalivuoden lämmitystarveluku vertailupaikkakunnalla:" Field: lblHeatIndexYear Formula: Formula = "Vuoden" Field: lblHeatIndexCorrectFactor Formula: Formula = "Paikkakuntakohtainen korjauskerroin Jyväskylään k2:" Field: lblHeatEfficiencyFactor Formula: Formula = "Lämmöntuottojärjestelmän hyötysuhde:" Field: lblHVACcaption Formula: Formula = "Rakennuksen sisäilmasto sekä ilmanvaihto- ja lämmitysjärjestelmä" Field: lblHVACopt1 Formula: formula = "Painovoimainen ilmanvaihto" Field: lblHVACopt2 Formula: formula = "Koneellinen poistoilmanvaihto" Field: lblHVACopt3 Formula: formula = "Koneellinen tulo- ja poistoilmanvaihto" Field: lblHVACheat Formula: formula = "Lämmönjakotapa:" Field: lblHVACadvanced1 Formula: formula = "Ulkoilmaventtiilit" Field: lblHVACadvanced2 Formula: formula = "Tuloilman suodatus" Field: lblHVACadvanced3 Formula: formula = "Lämmöntalteenotto" Field: lblHVACadvanced4 Formula: formula = "Jäähdytys" Field: lblHVACmeasuredYear Formula: formula = "Ilmanvaihdon ilmavirrat on mitattu ja todettu riittäviksi vuonna" Field: lblHVACmaintYear Formula: formula = "Ilmanvaihtojärjestelmä on puhdistettu ja tasapainotettu vuonna" Field: lblHVACeffYear Formula: formula = "Ilmastoinnin kylmälaitteiden kunto ja energiatehokkuus on tarkastettu vuonna" Field: lblHVACheatMaintYear Formula: formula = "Lämmitysjärjestelmä on tasapainotettu vuonna" Field: CalcHVACopt1 Formula: if {@valHVACopt} = "1" then formula = "x" else formula = "" end if Field: CalcHVAcopt2 Formula: if {@valHVACopt} = "2" then formula = "x" else formula = "" end if Field: CalcHVACopt3 Formula: if {@valHVACopt} = "3" then formula = "x" else formula = "" end if Field: CalcHVACadv1 Formula: if {@valHVAChasValves} = "-1" then formula = "x" else formula = "" end if Field: CalcHVACadv2 Formula: if {@valHVAChasFilter} = "-1" then formula = "x" else formula = "" end if Field: CalcHVACadv3 Formula: if {@valHVAChasHeatRec} = "-1" then formula = "x" else formula = "" end if Field: CalcHVACadv4 Formula: if {@valHVAChasAc} = "-1" then formula = "x" else formula = "" end if Field: valHVACmeasuredYear Formula: Formula = "-" Field: valHVACMaintYear Formula: formula = "-" Field: valHVACeffYear Formula: Formula = "-" Field: valHVACheatMaintYear Formula: formula = "-" Field: valHVACheat Formula: Formula = "" Field: lblAPcaption Formula: formula = "HUOMIOT JA TOIMENPIDE-EHDOTUKSET" Field: lblAPhullCaption Formula: formula = "Ulkoseinät, ovet ja ikkunat" Field: lblAPTable Formula: formula = "Toimenpide-ehdotus" Field: lblAPSave Formula: formula = "Arvioitu energiansäästö (kWh/vuosi)" Field: lblAPHeat Formula: formula = "Lämpö" Field: lblAPElec Formula: Formula = "Sähkö" Field: lblAPCold Formula: Formula = "Kylmä" Field: lblAPfloorCaption Formula: Formula = "Ylä- ja alapohja" Field: lblAPheatCaption Formula: formula = "Tilojen ja käyttöveden lämmitysjärjestelmät" Field: lblAPHVACCaption Formula: formula = "Ilmanvaihto- ja ilmastointijärjestelmä" Field: lblAPlightCaption Formula: formula = "Valaistus, sähköiset erillislämmitykset ja muut järjestelmät" Field: lblAPSumCaption Formula: formula = "KAIKKIEN TOIMENPITEIDEN YHTEISVAIKUTUS" Field: lblNotes Formula: formula = "Lisämerkintöjä" Field: valAPhullInfo Formula: Formula = "" Field: valAPhull1 Formula: Formula = "" Field: lblSummaryHeat Formula: formula = "Arvioitu lämmitysenergian säästö" Field: lblSummaryElec Formula: formula = "Arvioitu kiinteistösähköenergian säästö" Field: lblSummaryCold Formula: formula = "Arvioitu jäähdytysenergian (kylmäenergian) säästö" Field: lblSummaryETafter Formula: formula = "Rakennuksen energiatehokkuusluku kaikkien toimenpiteiden jälkeen" Field: lblSummaryETclass Formula: formula = "Energiatehokkuusluokka kaikkien toimenpiteiden toteutuksen jälkeen" Field: valAPhull2 Formula: formula = "" Field: valAPhull3 Formula: Formula = "" Field: valAPhull1Heat Formula: formula = "" Field: valAPhull2Heat Formula: formula = "" Field: valAPhull3Heat Formula: formula = "" Field: valAPhull1Elec Formula: formula = "" Field: valAPhull2Elec Formula: Formula = "" Field: valAPhull3Elec Formula: formula = "" Field: valAPhull1Cold Formula: formula = "" Field: valAPhull2Cold Formula: formula = "" Field: valAPhull3Cold Formula: formula = "" Field: valAPfloor1 Formula: formula = "" Field: valAPfloor2 Formula: formula = "" Field: valAPfloor3 Formula: formula = "" Field: valAPfloor1Heat Formula: formula = "" Field: valAPfloor2Heat Formula: formula = "" Field: valAPfloor3Heat Formula: formula = "" Field: valAPfloor1Elec Formula: formula = "" Field: valAPfloor2Elec Formula: formula = "" Field: valAPfloor3Elec Formula: formula = "" Field: valAPfloor1Cold Formula: formula = "" Field: valAPfloor2Cold Formula: formula = "" Field: valAPfloor3Cold Formula: formula = "" Field: valAPHeat1 Formula: formula = "" Field: valAPHeat2 Formula: formula = "" Field: valAPHeat3 Formula: formula = "" Field: valAPHeat1Heat Formula: formula = "" Field: valAPHeat2Heat Formula: formula = "" Field: valAPHeat3Heat Formula: formula = "" Field: valAPHeat1Elec Formula: formula = "" Field: valAPHeat2Elec Formula: formula = "" Field: valAPHeat3Elec Formula: Formula = "" Field: valAPHeat1Cold Formula: formula = "" Field: valAPHeat2Cold Formula: formula = "" Field: valAPHeat3Cold Formula: formula = "" Field: valAPHVAC1 Formula: formula = "" Field: valAPHVAC2 Formula: formula = "" Field: valAPHVAC3 Formula: formula = "" Field: valAPHVAC1Heat Formula: formula = "" Field: valAPHVAC2Heat Formula: formula = "" Field: valAPHVAC3Heat Formula: formula = "" Field: valAPHVAC1Elec Formula: formula = "" Field: valAPHVAC2Elec Formula: formula = "" Field: valAPHVAC3Elec Formula: formula = "" Field: valAPHVAC1Cold Formula: formula = "" Field: valAPHVAC2Cold Formula: formula = "" Field: valAPHVAC3Cold Formula: formula = "" Field: valAPlight1 Formula: formula = "" Field: valAPlight2 Formula: formula = "" Field: valAPlight3 Formula: formula = "" Field: valAPlight1Heat Formula: formula = "" Field: valAPlight2Heat Formula: formula = "" Field: valAPlight3Heat Formula: formula = "" Field: valAPlight1Elec Formula: formula = "" Field: valAPlight2Elec Formula: formula = "" Field: valAPlight3Elec Formula: formula = "" Field: valAPlight1Cold Formula: formula = "" Field: valAPlight2Cold Formula: formula = "" Field: valAPlight3Cold Formula: formula = "" Field: valAPfloorInfo Formula: formula = "" Field: valAPheatInfo Formula: formula = "" Field: valAPHVACInfo Formula: formula = "" Field: valAPlightInfo Formula: formula = "" Field: valNotes Formula: formula = "" Field: CalcSumHeat Formula: formula = ToText(val({@valAPfloor1Heat}) + val({@valAPfloor2Heat}) + val({@valAPfloor3Heat}) _ + val({@valAPHeat1Heat}) + val({@valAPHeat2Heat}) + val({@valAPHeat3Heat}) _ + val({@valAPhull1Heat}) + val({@valAPhull2Heat}) + val({@valAPhull3Heat}) _ + val({@valAPHVAC1Heat}) + val({@valAPHVAC2Heat}) + val({@valAPHVAC3Heat}) _ + val({@valAPlight1Heat}) + val({@valAPlight2Heat}) + val({@valAPlight3Heat}), 0) Field: CalcSumElec Formula: formula = ToText(val({@valAPfloor1Elec}) + val({@valAPfloor2Elec}) + val({@valAPfloor3Elec}) _ + val({@valAPHeat1Elec}) + val({@valAPHeat2Elec}) + val({@valAPHeat3Elec}) _ + val({@valAPhull1Elec}) + val({@valAPhull2Elec}) + val({@valAPhull3Elec}) _ + val({@valAPHVAC1Elec}) + val({@valAPHVAC2Elec}) + val({@valAPHVAC3Elec}) _ + val({@valAPlight1Elec}) + val({@valAPlight2Elec}) + val({@valAPlight3Elec}), 0) Field: CalcSumCold Formula: formula = TOTEXT (val({@valAPfloor1Cold}) + val({@valAPfloor2Cold}) + val({@valAPfloor3Cold}) _ + val({@valAPHeat1Cold}) + val({@valAPHeat2Cold}) + val({@valAPHeat3Cold}) _ + val({@valAPhull1Cold}) + val({@valAPhull2Cold}) + val({@valAPhull3Cold}) _ + val({@valAPHVAC1Cold}) + val({@valAPHVAC2Cold}) + val({@valAPHVAC3Cold}) _ + val({@valAPlight1Cold}) + val({@valAPlight2Cold}) + val({@valAPlight3Cold}),0) Field: CalcNewET Formula: if {@valArea} <> "" And ({@CalcSumCold} <> "0" OR {@CalcSumElec} <> "0" OR {@CalcSumHeat} <> "0") then if (({@CalcConsSum} - ToNumber({@CalcSumCold}) - ToNumber({@CalcSumElec}) - ToNumber({@CalcSumHeat})) / ToNumber({@valArea}) - Truncate(({@CalcConsSum} - ToNumber({@CalcSumCold}) - ToNumber({@CalcSumElec}) - ToNumber({@CalcSumHeat})) / ToNumber({@valArea}))) <> 0 then Formula =truncate(({@CalcConsSum} - ToNumber({@CalcSumCold}) - ToNumber({@CalcSumElec}) - ToNumber({@CalcSumHeat})) / ToNumber({@valArea}))+1 else formula = ({@CalcConsSum} - ToNumber({@CalcSumCold}) - ToNumber({@CalcSumElec}) - ToNumber({@CalcSumHeat})) / ToNumber({@valArea}) end if if {@CalcET} < 0 then formula=0 end if else formula = 0 end if 'if val({@valArea}) > 0 then ' formula = ({@CalcConsSum} - ToNumber({@CalcSumCold}) - ToNumber({@CalcSumElec}) - ToNumber({@CalcSumHeat})) / ToNumber({@valArea}) 'else ' formula = 0 'end if Field: CalcNewETclass Formula: dim lngTmp as number lngTmp = {@CalcNewET} if lngTmp = 0 then formula = "" elseif lngTmp > 0 and lngTmp < val({@valStartB}) then formula = "A" elseif lngTmp >= val({@valStartB}) and lngTmp < val({@valStartC}) then formula = "B" elseif lngTmp >= val({@valStartC}) and lngTmp < val({@valStartD}) then formula = "C" elseif lngTmp >= val({@valStartD}) and lngTmp < val({@valStartE}) then formula = "D" elseif lngTmp >= val({@valStartE}) and lngTmp < val({@valStartF}) then formula = "E" elseif lngTmp >= val({@valStartF}) and lngTmp < val({@valStartG}) then formula = "F" else formula = "G" end if Field: CalcConsWaterWarmEne Formula: if {@valConsWater_Warm} = "" and {@valConsWater_Total} <> "" then formula = (val({@valConsWater_Warm_Procent}) / 100) * val({@valConsWater_Total}) * 58 elseif {@valConsWater_Warm} <> "" then formula = val({@valConsWater_Warm}) * 58 end if Field: CalcConsHeatEne Formula: if {@valHeatIndex_CorrectFactor} <> "" and {@valHeatIndex_RefCity_NormalYear} <> "" _ and {@valHeatIndex_RefCity_RefYear} <> "" and {@valHeatSource1_Value} <> "" then formula = val(replace({@valHeatIndex_CorrectFactor},",",".")) * (val({@valHeatIndex_RefCity_NormalYear}) _ / val({@valHeatIndex_RefCity_RefYear})) * (val({@valHeatSource1_Value}) * tonumber({@valHeat_EfficiencyFactor}) +val({@valHeatSource2_Value})+val({@valConsHeatElec})-{@CalcConsWaterWarmEne}) _ + {@CalcConsWaterWarmEne} else formula = 0 end if Field: CalcET Formula: if {@valArea} <> "" then if (({@CalcConsSum} / ToNumber({@valArea})) - Truncate({@CalcConsSum} / ToNumber({@valArea}))) <> 0 then Formula =truncate({@CalcConsSum} / ToNumber({@valArea}))+1 else Formula ={@CalcConsSum} / ToNumber({@valArea}) end if 'Formula = Round(({@CalcConsHeatEne} + val({@valConsElec}) + val({@valConsCold})) / ToNumber({@valArea}), 0) else formula = -1 end if Field: valStartB Formula: Formula = "91" Field: valStartC Formula: formula = "111" Field: valStartD Formula: formula = "131" Field: valStartE Formula: formula = "171" Field: valStartF Formula: formula = "231" Field: valStartG Formula: formula = "321" Field: CalcRangeA Formula: formula = "- " & totext(val({@valStartB})-1,0) Field: CalcRangeB Formula: formula = {@valStartB} & " - " & totext(val({@valStartC})-1,0) Field: CalcRangeC Formula: formula = {@valStartC} & " - " & totext(val({@valStartD})-1,0) Field: CalcRangeD Formula: formula = {@valStartD} & " - " & totext(val({@valStartE})-1,0) Field: CalcRangeE Formula: formula = {@valStartE} & " - " & totext(val({@valStartF})-1,0) Field: CalcRangeF Formula: formula = {@valStartF} & " - " & totext(val({@valStartG})-1,0) Field: CalcRangeG Formula: Formula = {@valStartG} & " -" Field: valNotes1 Formula: formula ="" Field: valNotes2 Formula: formula ="" Field: valNotes3 Formula: formula ="" Field: valNotes4 Formula: formula ="" Field: valNotes5 Formula: formula ="" Field: valAPlightInfo1 Formula: formula ="" Field: valAPlightInfo2 Formula: formula ="" Field: valAPlightInfo3 Formula: formula ="" Field: valAPHVACInfo1 Formula: formula ="" Field: valAPHVACInfo2 Formula: formula ="" Field: valAPHVACInfo3 Formula: formula ="" Field: valAPheatInfo1 Formula: formula ="" Field: valAPheatInfo2 Formula: formula ="" Field: valAPheatInfo3 Formula: formula ="" Field: valAPheatInfo4 Formula: formula ="" Field: valAPfloorInfo1 Formula: formula ="" Field: valAPfloorInfo2 Formula: formula ="" Field: valAPfloorInfo3 Formula: formula ="" Field: valAPhullInfo1 Formula: formula ="" Field: valAPhullInfo2 Formula: formula ="" Field: valAPhullInfo3 Formula: formula ="" Field: valCertBasedOn Formula: formula ="" Field: valHVACopt Formula: formula ="" Field: valHVAChasValves Formula: formula ="" Field: valHVAChasFilter Formula: formula ="" Field: valHVAChasHeatRec Formula: formula ="" Field: valHVAChasAc Formula: formula ="" Field: valConsWater_Warm_Procent Formula: formula ="30" Field: lblHeatIndexYear1 Formula: formula ="lämmitystarveluku vertailuvuonna vertailupaikkakunnalla:" Field: CalcConsElec Formula: if {@valConsElec} <> "" then formula = val({@valConsElec}) else formula=0 end if Field: CalcConsCold Formula: if {@valConsCold} <> "" then formula = val({@valConsCold}) elseif {@valConsCold_District} <> "" then formula=val({@valConsCold_District}) else formula=0 end if Field: CalcHeatEfficiencyFactor Formula: if {@valHeat_EfficiencyFactor} <> "" then formula =val({@valHeat_EfficiencyFactor}) end if Field: CalcArea Formula: if {@valArea} <> "" then formula = val({@valArea}) else formula =0 end if Field: valConsCold_Elec_Measured Formula: formula ="" Field: valConsCold_Elec_Measured1 Formula: formula ="" Field: valConsCold_Elec_Measured2 Formula: formula ="" Field: CalcHeatSource1_Value Formula: if {@valHeatSource1_Value} <> "" then formula =val({@valHeatSource1_Value}) else formula=0 end if Field: CalcHeatSource2_Value Formula: if {@valHeatSource2_Value} <> "" then formula =val({@valHeatSource2_Value}) else formula = 0 end if Field: CalcConsCold_District Formula: if {@valConsCold_District} <> "" then formula=val({@valConsCold_District}) else formula=0 end if Field: CalcConsCold_Elec Formula: if {@valConsCold_Elec}<> "" then formula =val({@valConsCold_Elec}) else formula=0 end if Field: CalcConsWater_Total Formula: if {@valConsWater_Total} <> "" then formula=val({@valConsWater_Total}) else formula=0 end if Field: CalcConsWater_Warm Formula: if {@valConsWater_Warm} <> "" then formula=val({@valConsWater_Warm}) else formula=0 end if Field: valConsElec_Top Formula: formula ="" Field: CalcConsElec_Top Formula: if {@valConsElec_Top} <> "" then formula =val({@valConsElec_Top}) else formula=0 end if Field: valConsHeatElec Formula: formula ="" Field: CalcHeatElecInfo Formula: if {@valConsHeatElec} <> "" then if {@valHeatElecInfoHelp} = "1" then formula = {@lblHeatElecInfo} & "kWh * "& totext(val({@valConsSepElecSquare}),0) & " m² = " & totext(val({@valConsHeatElec}),0) & " " & {@lblkWhPerYear} & chr(13) else formula = {@lblHeatElecInfo1} & " " & totext(val({@valConsHeatElec}),0) & " " & {@lblkWhPerYear} & chr(13) end if else formula= "" end if Field: valHeatElecInfoHelp Formula: formula ="" Field: lblHeatElecInfo Formula: formula ="Arvioitu erillisten sähkölämmittimien kulutus: 40 kWh/brm²/vuosi" Field: lblHeatElecInfo1 Formula: formula ="Mitattu erillisten sähkölämmittimien kulutus:" Field: valConsCold_ElecCalc Formula: formula ="" Field: valConsSepElecSquare Formula: formula ="" Field: lblkWhPerAreaPerYear2 Formula: formula ="kWh/brm²/vuosi" Unused Formula Fields Field: CalcEqu_ConsWaterWarmEne Formula: if {@valConsWater_Warm} = "" and {@valConsWater_Total} <> "" then formula = totext(val({@valConsWater_Warm_Procent}) / 100,2) & " * " & {@valConsWater_Total} & _ " * 58 " & {@lblkWhPerYear} & " = " & totext({@CalcConsWaterWarmEne},0) & " " & {@lblkWhPerYear} elseif {@valConsWater_Warm} <> "" then formula = {@valConsWater_Warm} & " * 58 " & {@lblkWhPerYear} & " = " & totext({@CalcConsWaterWarmEne},0) & " " & {@lblkWhPerYear} else formula = "" end if Field: CalcEqu_ConsHeatEne Formula: dim strTmp as string if {@valHeatIndex_CorrectFactor} <> "" and {@valHeatIndex_RefCity_NormalYear} <> "" _ and {@valHeatIndex_RefCity_RefYear} <> "" and {@valHeatSource1_Value} <> "" then strTmp = {@valHeatIndex_CorrectFactor} & " * (" & {@valHeatIndex_RefCity_NormalYear} & " / " & {@valHeatIndex_RefCity_RefYear} & ") * (" if {@valHeatSource2_Value} <> "" then strTmp = strTmp & totext(val({@valHeatSource1_Value})+val({@valHeatSource2_Value}),0) else strTmp = strTmp & totext(val({@valHeatSource1_Value}),0) end if if {@valHeat_EfficiencyFactor} <> "" then strTmp = strTmp & " * " & totext(tonumber({@valHeat_EfficiencyFactor}),2) end if if {@valConsHeatElec} <> "" then strTmp = strTmp & " + " & totext(val({@valConsHeatElec}),0) end if strTmp = strTmp & " - " & totext({@CalcConsWaterWarmEne},0) & ") + " & totext({@CalcConsWaterWarmEne},0) strTmp = strTmp & " = " & totext({@CalcConsHeatEne},0) & " " & {@lblkWhPerYear} else strTmp = "" end if formula = strTmp Field: lblEquConsWaterWarmEne Formula: formula = "Lämpimän käyttöveden energiankulutus:" Field: lblEquConsHeatEne Formula: Formula = "Lämmitysenergian kulutus =" Field: CalcEqu_CoolingSystem Formula: if {@valConsCold_Equ} <> "" then if {@valConsCold_Equ} = "3" then formula ={@lblEqu_CoolingSystemInfo} & " 3 * " & totext(val({@valConsCold_Elec}),0) & " kWh/vuosi = " & totext(val({@valConsCold_Elec})*3,0) &" kWh/vuosi" else formula="" end if if {@valConsCold_Equ} = "5" then formula= {@lblEqu_CoolingSystemInfo1} & " 5 * " & totext(val({@valConsCold_Elec}),0) & " kWh/vuosi = " & totext(val({@valConsCold_Elec})*5,0) & " kWh/vuosi" else formula="" end if else formula="" end if Field: valConsCold_Equ Formula: formula ="" Field: CalcConsConversionInfo Formula: if {@CalcEqu_ConsWaterWarmEne} <> "" then formula = {@lblEquConsWaterWarmEne} & " " & {@CalcEqu_ConsWaterWarmEne} & chr(13) else if {@CalcEqu_ConsHeatEne} <> "" then formula=formula & {@lblEquConsHeatEne} & " " & {@CalcEqu_ConsHeatEne} else formula="" end if end if Field: lblEqu_CoolingSystemInfo Formula: formula ="Koneellisella jäähdytysjärjestelmällä varustetun rakennuksen tilojen jäähdytysjärjestelmän jäähdytysenergian kulutus:" Field: lblEqu_CoolingSystemInfo1 Formula: formula ="Vapaajäähdytysjärjestelmällä varustetun rakennuksen tilojen jäähdytysjärjestelmän jäähdytysenergian kulutus:" Detail Section: Section a Fields Field: Field3 Data Source: {@valBuildingType} Data Type: String Field: Field4 Data Source: {@valAddress} Data Type: String Field: Field5 Data Source: {@valCity} Data Type: String Field: Field6 Data Source: {@valBuiltYear} Data Type: String Field: Field7 Data Source: {@valBuildingID} Data Type: String Field: Field8 Data Source: {@CalcCertIsGivenOn_1} Data Type: String Field: Field9 Data Source: {@CalcCertIsGivenOn_2} Data Type: String Field: Field10 Data Source: {@CalcCertIsGivenOn_3} Data Type: String Field: Field2 Data Source: {@valETclass} Data Type: String Field: Field11 Data Source: {@valCertGranter} Data Type: String Field: Field12 Data Source: {@valCertOrderer} Data Type: String Field: Field13 Data Source: {@valCertGrantedDate} Data Type: String Field: Field14 Data Source: {@valCertExpiresDate} Data Type: String Field: Field47 Data Source: {@lblCaption} Data Type: String Field: Field48 Data Source: {@lblBuilding} Data Type: String Field: Field49 Data Source: {@lblBuildingType} Data Type: String Field: Field50 Data Source: {@lblAddress} Data Type: String Field: Field51 Data Source: {@lblBuiltYear} Data Type: String Field: Field52 Data Source: {@lblBuildingID} Data Type: String Field: Field53 Data Source: {@lblCertGranted} Data Type: String Field: Field54 Data Source: {@lblCertGrantedOpt1} Data Type: String Field: Field55 Data Source: {@lblCertGrantedOpt2} Data Type: String Field: Field56 Data Source: {@lblCertGrantedOpt3} Data Type: String Field: Field57 Data Source: {@lblET} Data Type: String Field: Field58 Data Source: {@lblSmallCons} Data Type: String Field: Field59 Data Source: {@lblBuildingETclass} Data Type: String Field: Field60 Data Source: {@lblHighCons} Data Type: String Field: Field61 Data Source: {@lblETwUnit} Data Type: String Field: Field62 Data Source: {@lblETscale} Data Type: String Field: Field63 Data Source: {@lblCertGranter} Data Type: String Field: Field64 Data Source: {@lblCertOrderer} Data Type: String Field: Field65 Data Source: {@lblCertGranterSignature} Data Type: String Field: Field66 Data Source: {@lblCertGrantedDate} Data Type: String Field: Field67 Data Source: {@lblCertExpires} Data Type: String Field: Field68 Data Source: {@lblLegalText} Data Type: String Field: Field1 Data Source: {@CalcET} Data Type: Number Suppression Formula: if {@CalcET} < 0 then formula = true else formula = false end if Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5555555 Field: Field248 Data Source: {@CalcRangeA} Data Type: String Field: Field249 Data Source: {@CalcRangeB} Data Type: String Field: Field250 Data Source: {@CalcRangeC} Data Type: String Field: Field251 Data Source: {@CalcRangeD} Data Type: String Field: Field252 Data Source: {@CalcRangeE} Data Type: String Field: Field253 Data Source: {@CalcRangeF} Data Type: String Field: Field254 Data Source: {@CalcRangeG} Data Type: String Text Fields Text Field: Text17 Text: A Text Field: Text11 Text: B Text Field: Text12 Text: C Text Field: Text13 Text: D Text Field: Text18 Text: E Text Field: Text19 Text: F Text Field: Text20 Text: G Text Field: Text1 Text: A Text Field: Text2 Text: B Text Field: Text3 Text: C Text Field: Text4 Text: D Text Field: Text5 Text: E Text Field: Text6 Text: F Text Field: Text7 Text: G Pictures Picture: Picture4 Size: 86x23 Suppression Formula: if {@CalcET} > 0 and {@CalcET} < val({@valStartB}) then formula = false else formula = true end if Picture: Picture1 Size: 86x23 Suppression Formula: if {@CalcET} >= val({@valStartB}) and {@CalcET} < val({@valStartC}) then formula = false else formula = true end if Picture: Picture2 Size: 86x23 Suppression Formula: if {@CalcET} >= val({@valStartC}) and {@CalcET} < val({@valStartD}) then formula = false else formula = true end if Picture: Picture3 Size: 86x23 Suppression Formula: if {@CalcET} >= val({@valStartD}) and {@CalcET} < val({@valStartE}) then formula = false else formula = true end if Picture: Picture10 Size: 86x23 Suppression Formula: if {@CalcET} >= val({@valStartE}) and {@CalcET} < val({@valStartF}) then formula = false else formula = true end if Picture: Picture11 Size: 86x23 Suppression Formula: if {@CalcET} >= val({@valStartF}) and {@CalcET} < val({@valStartG}) then formula = false else formula = true end if Picture: Picture12 Size: 86x23 Suppression Formula: if {@CalcET} >= val({@valStartG}) then formula = false else formula = true end if Picture: Picture5 Size: 83x24 Picture: Picture6 Size: 119x24 Picture: Picture7 Size: 156x25 Picture: Picture8 Size: 200x25 Picture: Picture13 Size: 219x25 Picture: Picture14 Size: 255x24 Picture: Picture15 Size: 289x24 Boxes Box: Box1 Ends in Section: Section5 Size: 657x930 Line Type: Single Line Thickness: 30 Box: Box2 Ends in Section: Section5 Size: 657x42 Line Type: Single Line Thickness: 20 Box: Box3 Ends in Section: Section5 Size: 20x51 Line Type: Single Line Thickness: 20 Box: Box4 Ends in Section: Section5 Size: 657x456 Line Type: Single Line Thickness: 0 Box: Box5 Ends in Section: Section5 Size: 571x284 Line Type: Single Line Thickness: 20 Box: Box6 Ends in Section: Section5 Size: 572x73 Line Type: Single Line Thickness: 20 Lines Line: Line1 Ends in Section: Section5 Line Type: Single Line Thickness: 30 Line: Line2 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line3 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line4 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line5 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line6 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line7 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line8 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line9 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line10 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line11 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line12 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line17 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line13 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Line: Line14 Ends in Section: Section5 Line Type: Single Line Thickness: 20 Section: Section b Fields Field: Field18 Data Source: {@CalcConsSum} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field21 Data Source: {@valHeatSource1_Name} Data Type: String Field: Field22 Data Source: {@valHeatSource2_Name} Data Type: String Field: Field32 Data Source: {@valHeatSource1_Year} Data Type: String Field: Field33 Data Source: {@valHeatSource2_Year} Data Type: String Field: Field34 Data Source: {@valConsElecYear} Data Type: String Field: Field35 Data Source: {@valConsCold_District_Year} Data Type: String Field: Field36 Data Source: {@valConsCold_Elec_Year} Data Type: String Field: Field37 Data Source: {@valConsWater_Total_Year} Data Type: String Field: Field38 Data Source: {@valConsWater_Warm_Year} Data Type: String Field: Field39 Data Source: {@valHeatRef_City} Data Type: String Field: Field40 Data Source: {@valHeatIndex_RefCity_NormalYear} Data Type: String Field: Field42 Data Source: {@valHeatIndex_RefCity_RefYear} Data Type: String Field: Field43 Data Source: {@valHeatIndex_CorrectFactor} Data Type: String Field: Field69 Data Source: {@lblConsCaption} Data Type: String Field: Field70 Data Source: {@lblETCalcRules} Data Type: String Field: Field71 Data Source: {@lblConsHeat} Data Type: String Field: Field72 Data Source: {@lblConsElec} Data Type: String Field: Field73 Data Source: {@lblConsCold} Data Type: String Field: Field74 Data Source: {@lblConsSum} Data Type: String Field: Field75 Data Source: {@lblArea} Data Type: String Field: Field76 Data Source: {@lblBuildingET} Data Type: String Field: Field77 Data Source: {@lblkWhPerYear} Data Type: String Field: Field41 Data Source: {@lblkWhPerYear} Data Type: String Field: Field106 Data Source: {@lblkWhPerYear} Data Type: String Field: Field107 Data Source: {@lblkWhPerYear} Data Type: String Field: Field78 Data Source: {@lblkWhPerAreaPerYear} Data Type: String Field: Field79 Data Source: {@lblETCalcInfo1} Data Type: String Field: Field80 Data Source: {@lblETCalcInfo2} Data Type: String Field: Field81 Data Source: {@lblConsHistory} Data Type: String Field: Field82 Data Source: {@lblConsType} Data Type: String Field: Field83 Data Source: {@lblConsValue} Data Type: String Field: Field84 Data Source: {@lblConsUnit} Data Type: String Field: Field85 Data Source: {@lblConsYear} Data Type: String Field: Field86 Data Source: {@lblConsHeatTable} Data Type: String Field: Field87 Data Source: {@lblConsElecTable} Data Type: String Field: Field88 Data Source: {@lblConsElecMeasured} Data Type: String Field: Field89 Data Source: {@lblConsColdTable} Data Type: String Field: Field90 Data Source: {@lblConsColdDistrict} Data Type: String Field: Field91 Data Source: {@lblConsColdElec} Data Type: String Field: Field92 Data Source: {@lblConsWaterTable} Data Type: String Field: Field93 Data Source: {@lblConsWaterTotal} Data Type: String Field: Field94 Data Source: {@lblConsWaterWarm} Data Type: String Field: Field95 Data Source: {@lblConsConversion} Data Type: String Field: Field96 Data Source: {@lblHeatRefCity} Data Type: String Field: Field97 Data Source: {@lblHeatIndexRefNormal} Data Type: String Field: Field98 Data Source: {@lblHeatIndexYear} Data Type: String Field: Field99 Data Source: {@valHeatIndex_Year} Data Type: String Field: Field101 Data Source: {@lblHeatIndexCorrectFactor} Data Type: String Field: Field102 Data Source: {@lblHeatEfficiencyFactor} Data Type: String Field: Field105 Data Source: {@lblHVACcaption} Data Type: String Field: Field108 Data Source: {@lblHVACopt1} Data Type: String Field: Field109 Data Source: {@lblHVACopt2} Data Type: String Field: Field110 Data Source: {@lblHVACopt3} Data Type: String Field: Field111 Data Source: {@lblHVACheat} Data Type: String Field: Field112 Data Source: {@lblHVACheatMaintYear} Data Type: String Field: Field113 Data Source: {@lblHVACmaintYear} Data Type: String Field: Field114 Data Source: {@lblHVACmeasuredYear} Data Type: String Field: Field115 Data Source: {@lblHVACeffYear} Data Type: String Field: Field116 Data Source: {@lblHVACadvanced1} Data Type: String Field: Field117 Data Source: {@lblHVACadvanced2} Data Type: String Field: Field118 Data Source: {@lblHVACadvanced3} Data Type: String Field: Field119 Data Source: {@lblHVACadvanced4} Data Type: String Field: Field120 Data Source: {@CalcHVACopt1} Data Type: String Field: Field121 Data Source: {@CalcHVAcopt2} Data Type: String Field: Field122 Data Source: {@CalcHVACopt3} Data Type: String Field: Field123 Data Source: {@CalcHVACadv1} Data Type: String Field: Field124 Data Source: {@CalcHVACadv2} Data Type: String Field: Field125 Data Source: {@CalcHVACadv3} Data Type: String Field: Field126 Data Source: {@CalcHVACadv4} Data Type: String Field: Field127 Data Source: {@valHVACmeasuredYear} Data Type: String Field: Field128 Data Source: {@valHVACMaintYear} Data Type: String Field: Field129 Data Source: {@valHVACeffYear} Data Type: String Field: Field130 Data Source: {@valHVACheatMaintYear} Data Type: String Field: Field131 Data Source: {@valHVACheat} Data Type: String Field: Field246 Data Source: {@CalcConsHeatEne} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field247 Data Source: {@CalcET} Data Type: Number Suppression Formula: if {@CalcET} < 0 then formula = true else formula = false end if Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field15 Data Source: {@lblHeatIndexYear1} Data Type: String Field: Field17 Data Source: {@CalcConsCold} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field20 Data Source: {@CalcHeatEfficiencyFactor} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: True Leading Zero: True Reverse Sign: False Number Style: -5,555,555. Field: Field30 Data Source: {@CalcArea} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field23 Data Source: {@CalcHeatSource1_Value} Data Type: Number Suppression Formula: if {@CalcHeatSource1_Value} = 0 then formula = true else formula = false end if Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field24 Data Source: {@CalcHeatSource2_Value} Data Type: Number Suppression Formula: if {@CalcHeatSource2_Value} = 0 then formula = true else formula = false end if Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field25 Data Source: {@CalcConsElec} Data Type: Number Suppression Formula: if {@CalcConsElec} = 0 then formula = true else formula = false end if Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field100 Data Source: {@CalcConsCold_District} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: True Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field103 Data Source: {@CalcConsCold_Elec} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: True Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field104 Data Source: {@CalcConsWater_Total} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: True Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field134 Data Source: {@CalcConsWater_Warm} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: True Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Field: Field214 Data Source: {@CalcConsElec_Top} Data Type: Number Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5 555 555 Text Fields Text Field: Text22 Text: brm² Text Field: Text23 Text: kWh Text Field: Text24 Text: kWh Text Field: Text25 Text: kWh Text Field: Text26 Text: m³ Text Field: Text27 Text: m³ Text Field: Text8 Text: kWh Text Field: Text9 Text: kWh Text Field: Text29 Text: {@valConsCold_ElecCalc} {@CalcHeatElecInfo}{@valConsCold_Elec_Measured} {@valConsCold_Elec_Measured1} {@valConsCold_Elec_Measured2} Boxes Box: Box8 Ends in Section: Section7 Size: 655x964 Line Type: Single Line Thickness: 30 Box: Box7 Ends in Section: Section7 Size: 655x24 Line Type: Single Line Thickness: 20 Box: Box9 Ends in Section: Section7 Size: 652x24 Line Type: Single Line Thickness: 20 Box: Box10 Ends in Section: Section7 Size: 652x24 Line Type: Single Line Thickness: 20 Box: Box11 Ends in Section: Section7 Size: 655x24 Line Type: Single Line Thickness: 20 Box: Box12 Ends in Section: Section7 Size: 44x47 Line Type: Single Line Thickness: 20 Box: Box15 Ends in Section: Section7 Size: 42x63 Line Type: Single Line Thickness: 20 Box: Box16 Ends in Section: Section7 Size: 42x47 Line Type: Single Line Thickness: 20 Box: Box13 Ends in Section: Section7 Size: 42x16 Line Type: Single Line Thickness: 20 Lines Line: Line15 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line16 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line18 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line19 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line20 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line21 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line22 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line29 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line30 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line31 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line32 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Line: Line33 Ends in Section: Section7 Line Type: Single Line Thickness: 20 Section: Section c Fields Field: Field132 Data Source: {@lblAPcaption} Data Type: String Field: Field133 Data Source: {@lblAPhullCaption} Data Type: String Field: Field135 Data Source: {@lblAPfloorCaption} Data Type: String Field: Field136 Data Source: {@lblAPheatCaption} Data Type: String Field: Field138 Data Source: {@lblAPHeat} Data Type: String Field: Field139 Data Source: {@lblAPElec} Data Type: String Field: Field140 Data Source: {@lblAPCold} Data Type: String Field: Field141 Data Source: {@lblAPTable} Data Type: String Field: Field142 Data Source: {@lblAPSave} Data Type: String Field: Field137 Data Source: {@lblAPTable} Data Type: String Field: Field153 Data Source: {@lblAPCold} Data Type: String Field: Field154 Data Source: {@lblAPElec} Data Type: String Field: Field225 Data Source: {@lblAPSave} Data Type: String Field: Field226 Data Source: {@lblAPCold} Data Type: String Field: Field227 Data Source: {@lblAPElec} Data Type: String Field: Field229 Data Source: {@lblAPSave} Data Type: String Field: Field230 Data Source: {@valAPhull1} Data Type: String Field: Field231 Data Source: {@lblAPTable} Data Type: String Field: Field155 Data Source: {@valAPhull2} Data Type: String Field: Field156 Data Source: {@valAPhull3} Data Type: String Field: Field157 Data Source: {@valAPhull1Heat} Data Type: String Suppression Formula: if val({@valAPhull1Heat}) <= 0 then true Field: Field158 Data Source: {@valAPhull1Elec} Data Type: String Suppression Formula: if val({@valAPhull1Elec}) <= 0 then true Field: Field159 Data Source: {@valAPhull1Cold} Data Type: String Suppression Formula: if val({@valAPhull1Cold}) <= 0 then true Field: Field160 Data Source: {@valAPhull2Heat} Data Type: String Suppression Formula: if val({@valAPhull2Heat}) <= 0 then true Field: Field161 Data Source: {@valAPhull2Elec} Data Type: String Suppression Formula: if val({@valAPhull2Elec}) <= 0 then true Field: Field162 Data Source: {@valAPhull2Cold} Data Type: String Suppression Formula: if val({@valAPhull2Cold}) <= 0 then true Field: Field163 Data Source: {@valAPhull3Heat} Data Type: String Suppression Formula: if val({@valAPhull3Heat}) <= 0 then true Field: Field164 Data Source: {@valAPhull3Elec} Data Type: String Suppression Formula: if val({@valAPhull3Elec}) <= 0 then true Field: Field165 Data Source: {@valAPhull3Cold} Data Type: String Suppression Formula: if val({@valAPhull3Cold}) <= 0 then true Field: Field166 Data Source: {@valAPfloor1} Data Type: String Field: Field167 Data Source: {@valAPfloor2} Data Type: String Field: Field168 Data Source: {@valAPfloor3} Data Type: String Field: Field169 Data Source: {@valAPfloor1Heat} Data Type: String Suppression Formula: if val({@valAPfloor1Heat}) <= 0 then true Field: Field170 Data Source: {@valAPfloor1Elec} Data Type: String Suppression Formula: if val({@valAPfloor1Elec}) <= 0 then true Field: Field171 Data Source: {@valAPfloor1Cold} Data Type: String Suppression Formula: if val({@valAPfloor1Cold}) <= 0 then true Field: Field172 Data Source: {@valAPfloor2Heat} Data Type: String Suppression Formula: if val({@valAPfloor2Heat}) <= 0 then true Field: Field173 Data Source: {@valAPfloor2Elec} Data Type: String Suppression Formula: if val({@valAPfloor2Elec}) <= 0 then true Field: Field174 Data Source: {@valAPfloor2Cold} Data Type: String Suppression Formula: if val({@valAPfloor2Cold}) <= 0 then true Field: Field175 Data Source: {@valAPfloor3Heat} Data Type: String Suppression Formula: if val({@valAPfloor3Heat}) <= 0 then true Field: Field176 Data Source: {@valAPfloor3Elec} Data Type: String Suppression Formula: if val({@valAPfloor3Elec}) <= 0 then true Field: Field177 Data Source: {@valAPfloor3Cold} Data Type: String Suppression Formula: if val({@valAPfloor3Cold}) <= 0 then true Field: Field178 Data Source: {@valAPHeat1} Data Type: String Field: Field179 Data Source: {@valAPHeat2} Data Type: String Field: Field180 Data Source: {@valAPHeat3} Data Type: String Field: Field181 Data Source: {@valAPHeat1Heat} Data Type: String Suppression Formula: if val({@valAPHeat1Heat}) <= 0 then true Field: Field182 Data Source: {@valAPHeat1Elec} Data Type: String Suppression Formula: if val({@valAPHeat1Elec}) <= 0 then true Field: Field183 Data Source: {@valAPHeat1Cold} Data Type: String Suppression Formula: if val({@valAPHeat1Cold}) <= 0 then true Field: Field184 Data Source: {@valAPHeat2Heat} Data Type: String Suppression Formula: if val({@valAPHeat2Heat}) <= 0 then true Field: Field185 Data Source: {@valAPHeat2Elec} Data Type: String Suppression Formula: if val({@valAPHeat2Elec}) <= 0 then true Field: Field186 Data Source: {@valAPHeat2Cold} Data Type: String Suppression Formula: if val({@valAPHeat2Cold}) <= 0 then true Field: Field187 Data Source: {@valAPHeat3Heat} Data Type: String Suppression Formula: if val({@valAPHeat3Heat}) <= 0 then true Field: Field188 Data Source: {@valAPHeat3Elec} Data Type: String Suppression Formula: if val({@valAPHeat3Elec}) <= 0 then true Field: Field189 Data Source: {@valAPHeat3Cold} Data Type: String Suppression Formula: if val({@valAPHeat3Cold}) <= 0 then true Field: Field16 Data Source: {@lblAPHeat} Data Type: String Field: Field19 Data Source: {@lblAPHeat} Data Type: String Text Fields Text Field: Text16 Text: {@valAPheatInfo}{@valAPheatInfo1}{@valAPheatInfo2}{@valAPheatInfo3}{@valAPheatInfo4} Text Field: Text21 Text: {@valAPfloorInfo}{@valAPfloorInfo1}{@valAPfloorInfo2}{@valAPfloorInfo3} Text Field: Text28 Text: {@valAPhullInfo}{@valAPhullInfo1}{@valAPhullInfo2}{@valAPhullInfo3} Boxes Box: Box17 Ends in Section: Section8 Size: 654x24 Line Type: Single Line Thickness: 20 Box: Box18 Ends in Section: Section8 Size: 652x24 Line Type: Single Line Thickness: 20 Box: Box19 Ends in Section: Section8 Size: 655x24 Line Type: Single Line Thickness: 20 Box: Box20 Ends in Section: Section8 Size: 655x953 Line Type: Single Line Thickness: 30 Lines Line: Line23 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line34 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line35 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line36 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line24 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line25 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line26 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line37 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line38 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line39 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line40 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line41 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line42 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line43 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line44 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line45 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line46 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line47 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line48 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line49 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line50 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line51 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line52 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line53 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line78 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line79 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Line: Line80 Ends in Section: Section8 Line Type: Single Line Thickness: 20 Section: Section d Fields Field: Field233 Data Source: {@lblAPElec} Data Type: String Field: Field234 Data Source: {@lblAPCold} Data Type: String Field: Field235 Data Source: {@lblAPTable} Data Type: String Field: Field236 Data Source: {@lblAPSave} Data Type: String Field: Field237 Data Source: {@lblAPTable} Data Type: String Field: Field238 Data Source: {@lblAPCold} Data Type: String Field: Field239 Data Source: {@lblAPElec} Data Type: String Field: Field241 Data Source: {@lblAPSave} Data Type: String Field: Field143 Data Source: {@lblAPHVACCaption} Data Type: String Field: Field144 Data Source: {@lblAPlightCaption} Data Type: String Field: Field145 Data Source: {@lblAPSumCaption} Data Type: String Field: Field146 Data Source: {@lblNotes} Data Type: String Field: Field147 Data Source: {@lblSummaryHeat} Data Type: String Field: Field148 Data Source: {@lblSummaryElec} Data Type: String Field: Field149 Data Source: {@lblSummaryCold} Data Type: String Field: Field150 Data Source: {@lblSummaryETafter} Data Type: String Field: Field151 Data Source: {@lblSummaryETclass} Data Type: String Field: Field152 Data Source: {@lblkWhPerYear} Data Type: String Field: Field242 Data Source: {@lblkWhPerYear} Data Type: String Field: Field243 Data Source: {@lblkWhPerYear} Data Type: String Field: Field190 Data Source: {@valAPHVAC1} Data Type: String Field: Field191 Data Source: {@valAPHVAC2} Data Type: String Field: Field192 Data Source: {@valAPHVAC3} Data Type: String Field: Field193 Data Source: {@valAPHVAC1Heat} Data Type: String Suppression Formula: if val({@valAPHVAC1Heat}) <= 0 then true Field: Field194 Data Source: {@valAPHVAC1Elec} Data Type: String Suppression Formula: if val({@valAPHVAC1Elec}) <= 0 then true Field: Field195 Data Source: {@valAPHVAC1Cold} Data Type: String Suppression Formula: if val({@valAPHVAC1Cold}) <= 0 then true Field: Field196 Data Source: {@valAPHVAC2Heat} Data Type: String Suppression Formula: if val({@valAPHVAC2Heat}) <= 0 then true Field: Field197 Data Source: {@valAPHVAC2Elec} Data Type: String Suppression Formula: if val({@valAPHVAC2Elec}) <= 0 then true Field: Field198 Data Source: {@valAPHVAC2Cold} Data Type: String Suppression Formula: if val({@valAPHVAC2Cold}) <= 0 then true Field: Field199 Data Source: {@valAPHVAC3Heat} Data Type: String Suppression Formula: if val({@valAPHVAC3Heat}) <= 0 then true Field: Field200 Data Source: {@valAPHVAC3Elec} Data Type: String Suppression Formula: if val({@valAPHVAC3Elec}) <= 0 then true Field: Field201 Data Source: {@valAPHVAC3Cold} Data Type: String Suppression Formula: if val({@valAPHVAC3Cold}) <= 0 then true Field: Field202 Data Source: {@valAPlight1} Data Type: String Field: Field203 Data Source: {@valAPlight2} Data Type: String Field: Field204 Data Source: {@valAPlight3} Data Type: String Field: Field205 Data Source: {@valAPlight1Heat} Data Type: String Suppression Formula: if val({@valAPlight1Heat}) <= 0 then true Field: Field206 Data Source: {@valAPlight1Elec} Data Type: String Suppression Formula: if val({@valAPlight1Elec}) <= 0 then true Field: Field207 Data Source: {@valAPlight1Cold} Data Type: String Suppression Formula: if val({@valAPlight1Cold}) <= 0 then true Field: Field208 Data Source: {@valAPlight2Heat} Data Type: String Suppression Formula: if val({@valAPlight2Heat}) <= 0 then true Field: Field209 Data Source: {@valAPlight2Elec} Data Type: String Suppression Formula: if val({@valAPlight2Elec}) <= 0 then true Field: Field210 Data Source: {@valAPlight2Cold} Data Type: String Suppression Formula: if val({@valAPlight2Cold}) <= 0 then true Field: Field211 Data Source: {@valAPlight3Heat} Data Type: String Suppression Formula: if val({@valAPlight3Heat}) <= 0 then true Field: Field212 Data Source: {@valAPlight3Elec} Data Type: String Suppression Formula: if val({@valAPlight3Elec}) <= 0 then true Field: Field213 Data Source: {@valAPlight3Cold} Data Type: String Suppression Formula: if val({@valAPlight3Cold}) <= 0 then true Field: Field219 Data Source: {@CalcSumHeat} Data Type: String Suppression Formula: if val({@CalcSumHeat}) = 0 then formula = true else formula = false end if Field: Field220 Data Source: {@CalcSumElec} Data Type: String Suppression Formula: if val({@CalcSumElec}) = 0 then formula = true else formula = false end if Field: Field221 Data Source: {@CalcSumCold} Data Type: String Suppression Formula: if val({@CalcSumCold}) = 0 then formula = true else formula = false end if Field: Field222 Data Source: {@CalcNewET} Data Type: Number Suppression Formula: if {@CalcNewET} = 0 then formula = true else formula = false end if Format: Number Currency Symbol: None Suppress if Zero: False Leading Zero: True Reverse Sign: False Number Style: -5555555 Field: Field223 Data Source: {@CalcNewETclass} Data Type: String Field: Field26 Data Source: {@lblAPHeat} Data Type: String Field: Field27 Data Source: {@lblAPHeat} Data Type: String Field: Field28 Data Source: {@lblkWhPerAreaPerYear2} Data Type: String Text Fields Text Field: Text10 Text: {@valNotes}{@valNotes1}{@valNotes2}{@valNotes3}{@valNotes4}{@valNotes5} Text Field: Text14 Text: {@valAPlightInfo}{@valAPlightInfo1}{@valAPlightInfo2}{@valAPlightInfo3} Text Field: Text15 Text: {@valAPHVACInfo}{@valAPHVACInfo1}{@valAPHVACInfo2}{@valAPHVACInfo3} Boxes Box: Box23 Ends in Section: Section10 Size: 654x24 Line Type: Single Line Thickness: 20 Box: Box24 Ends in Section: Section10 Size: 652x24 Line Type: Single Line Thickness: 20 Box: Box25 Ends in Section: Section10 Size: 655x24 Line Type: Single Line Thickness: 20 Box: Box27 Ends in Section: Section10 Size: 655x953 Line Type: Single Line Thickness: 30 Box: Box29 Ends in Section: Section10 Size: 655x19 Line Type: Single Line Thickness: 20 Lines Line: Line54 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line55 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line56 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line57 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line58 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line59 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line60 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line61 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line62 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line63 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line64 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line65 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line66 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line67 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line68 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line69 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line27 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line70 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line71 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line72 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line73 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line74 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line28 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line75 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line76 Ends in Section: Section10 Line Type: Single Line Thickness: 20 Line: Line77 Ends in Section: Section10 Line Type: Single Line Thickness: 20