<% '============= Create and Open Database Connection ============= 'OPEN THE DATABASE If blnConnectToDB Then dim blnDBconnectionDown blnDBconnectionDown = false Err.Clear on error resume next set dbConn = Server.CreateObject("ADODB.Connection") 'Open the Connnection 'dbConn.Open Application("dbConn_ConnectionString") dbConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" ''New Error trapping. KC added 2/23/2012 If Err.Number <> 0 Then ''Response.Write (Err.Description& "

") dbConn.Close Set dbConn = nothing blnDBconnectionDown = true End If On Error GoTo 0 ''error trapping not working here KC removed 2/23/2012 ''tmpDBErrorNativeError = 0 '' For Each dbErr In dbConn.Errors '' strErrMsg = strErrMsg & _ '' "Source: " & dbErr.Source & vbCrLF & _ '' "Description: " & dbErr.Description & vbCrLF & _ '' "SQL State: " & dbErr.SQLState & vbCrLF & _ '' "NativeError: " & dbErr.NativeError & vbCrLF & _ '' "Number: " & dbErr.Number & vbCrLF & vbCrLF '' tmpDBErrorNativeError = dbErr.NativeError '' Next '' If (dbConn.Errors.Count > 0) AND (tmpDBErrorNativeError <> 5703) Then '' dbConn.Close '' Set dbConn = nothing '' blnDBconnectionDown = true '' Response.write(strErrMsg) '' Response.end '' End If dim arrErrors() Redim arrErrors(2,0) End If '============================================================== Public Function GetRS2(myCommand) On Error GoTo 0 'objConn: local connection object 'objRS: local recordset object 'objComm: command object passed in to the function Dim objConn, objRS, blnErrorLogged, objComm 'Create the command object Set objComm = Server.CreateObject("ADODB.Command") Set objComm = myCommand 'Create the connection object Set objConn = Server.CreateObject("ADODB.Connection") 'Open the connection object objConn.Open "DSN=PostgreSQL30", "eere_news", "33reNews" 'Set the active connection objComm.ActiveConnection = objConn 'Create the recordset object Set objRS = Server.CreateObject("ADODB.Recordset") 'Set the cursor location for disconnected recordsets 'objRS.CursorLocation = adUseClient 'Turn on error handling for just a second ' On Error Resume Next 'Open the recordset 'objRS.Open SQL, objConn, adOpenStatic, adLockOptimistic Set objRS = objComm.Execute 'Response.Write "State = " & objRS.State & "
" 'objRS.MoveLast 'objRS.MoveFirst 'Response.Write "Count = " & objRS.RecordCount & "
" 'Response.End 'Check for an error ' If Err.Number <> 0 Then ' Response.Write "Database Error Occured

" ' Response.Write "Error #" & Err.Number & "
" ' Response.Write Err.Description & "

" ' Response.Write "SQL:
" ' Response.Write SQL ' Response.End ' End If 'Turn off error handling ' On Error GoTo 0 'Disconnect the recordset 'Set objComm.ActiveConnection = Nothing 'Close the connection 'objConn.Close 'Set the connection to Nothing 'Set objConn = Nothing 'Set the Command to Nothing 'Set objComm = Nothing 'Return the recordset Set GetRS2 = objRS On Error Resume Next End Function '=============================================================== Function GetRS(sSQL) 'Declarations dim rs 'Create Recordset Object set rs = Server.CreateObject("ADODB.Recordset") If blnConnectToDB Then 'Open Recordset based on SQL rs.Open sSQL, dbConn, 1, 3, 1 End If 'Return Recordset set GetRs = rs End Function '=============================================================== Function ExecSQL(sSQL) 'Open the Command Object dim lRecordsAffected dbConn.Execute sSQL, lRecordsAffected 'Return the Records Affected ExecSQL = lRecordsAffected End Function '======================================================================== Function sendEmail(strFrom,strTo,strSubject,strMessage) Dim sch ' Schema sch = "http://schemas.microsoft.com/cdo/configuration/" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(sch & "sendusing") = 2 .Item(sch & "smtpserver") = "mxrelay.doe.gov" .update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = strFrom .To = strTo .Subject = strSubject .TextBody = strMessage .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing End Function Function removeBadChars(tmpString) tmpString = Replace(tmpString , "<", "") tmpString = Replace(tmpString , ">", "") tmpString = Replace(tmpString , "'", "") tmpString = Replace(tmpString , """", "") tmpString = Replace(tmpString , ";", "") tmpString = Replace(tmpString , "(", "") tmpString = Replace(tmpString , ")", "") removeBadChars = tmpString End Function %> <% 'If there is a mobile version of this site, check the user_agent, and forward to 'the mobile version of the site (unless cookie or querystring var is set) if "true" = "true" then tmpSeeFullPage = Mid(Request.Querystring("m"),1,1) if ((isMobile) and (tmpSeeFullPage <> "1")) then tmpMobileURL = Request.servervariables("HTTP_URL") tmpMobileFileName = mid(tmpMobileURL, InStrRev(tmpMobileURL, "/")+1) tmpMobileURL = Left(tmpMobileURL, InStrRev(tmpMobileURL, "/")) tmpMobileURL = tmpMobileURL & "m/" & tmpMobileFileName Response.Clear Response.Redirect(tmpMobileURL) end if end if %>

<% ''This code is strictly when a user clicks on a left nav and needs to be forwarded to another site/program/office if ("" <> "") then Response.Clear Response.Redirect ("") end if %>

Energy Cost Calculator for Commercial Heat Pumps (5.4 >=< 20 Tons)


Vary equipment size, energy cost, hours of operation, and /or efficiency level.

INPUT SECTION
Input the following data (if any parameter is missing, calculator will set to default value). Defaults
Project Type    New Installation
Condenser Type    Air Source
Existing Capacity *    ton
Existing Cooling Efficiency *    EER
Existing Heating Efficiency *    COP
Existing IPLV Efficiency *    IPLV
New Capacity    ton 10 tons
New Cooling Efficiency    EER 10.1 EER
New Heating Efficiency    COP 3.2 COP
New IPLV Efficiency    IPLV 10.4 IPLV
Energy Cost $ per kWh $0.06 per kWh
Annual Hours of Operation for Cooling    hours 1500 hours
Annual Hours of Operation for Heating    hours 1500 hours
Quantity of Heat Pumps to be Purchased    unit(s) 1 unit
* Existing values should only be entered when Project Type is a replacement.
OUTPUT SECTION
Performance per
Heat Pump
Your
Choice
Existing
Heat Pump
Base
Model
FEMP
Recommended
Level
Best
Available
Cooling Efficiency     EER            
Heating Efficiency     COP            
IPLV Efficiency     IPLV            
Annual Energy Use     kWh            
Annual Energy Costs $ $ $ $ $
Lifetime Energy Costs $ $ $ $ $
Lifetime Energy Cost Savings $ $ $ $ $
Lifetime Energy Cost Savings for Heat Pump(s) $ $ $ $ $

Your selection of a ton heat pump will have a $ energy cost savings per heat pump over an estimated 15 year life expectancy compared to the base model.

Assumptions

  • "Base model" has an efficiency that just meets the national minimum standard for that capacity.
  • Lifetime energy cost is the sum of the discounted value of the annual energy costs based on assumed commercial heat pump life of 15 years.
  • Future electricity price trends and a discount rate of 3.2% are based on Federal guidelines.
  • $0.06 for electricity is the Federal average price in the U.S.

Disclaimer
This cost calculator is a screening tool that estimates a product's lifetime energy cost savings at various efficiency levels. Maintenance and installation costs do not vary significantly among the same product having different efficiencies; so, these costs are not included in this calculator tool. For a detailed life-cycle cost analysis, FEMP has developed a tool called Building Life-Cycle Cost (BLCC). This downloadable tool allows the user to vary interest rates, installation costs, maintenance costs, salvage values, and life expectancy for a product or an entire energy project.