Re: [EnergyPlus_Support] Performance curve for the chiller

[wing sun lee <samwslee@xxxxxxxxxxxx>]

Hi,
 
Thank you for your reply. I'm looking forward to your good sound. 
 
Regards,
 
SAMLEE

"Michael J. Witte" <mjwitte@xxxxxxxx> wrote:
On 22 Feb 2005, at 9:10, wing sun lee wrote:

> 
> I have already checked the microsoft office excel, but it can only solve the
> curve fit for linear and quadratic equation by the Linest() function.
> 

There is a trick that was taught to me that allows "Linest" to be used to fit 
higher power equations.  You must first create additional columns which compute 
the higher powers or other forms of the independent variables.  For example, to 
solve a bi-quadratic in Excel:
Col A= X
Col B= X^2
Col C= Y
Col D= Y^2
Col E= X*Y
Col F= Dependent variable

Then tell Linest that columns A:E are the independent variables and col F is 
the dependent variable.  I will try to prepare a sample spreadsheet to post in 
the files area.

Mike

========================================================
Michael J. Witte, GARD Analytics, Inc.
EnergyPlus Testing and Support      
EnergyPlus-Support@xxxxxxxx




The primary EnergyPlus web site is found at:
http://www.energyplus.gov

The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/

Attachments are not allowed -- please post any files to the appropriate folder in the Files area of the Support Web Site.



Yahoo! Groups Sponsor 
Get unlimited calls to

U.S./Canada


---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/EnergyPlus_Support/
  
   To unsubscribe from this group, send an email to:
EnergyPlus_Support-unsubscribe@xxxxxxxxxxxxxxx
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 


借過、一拍兩散、奇洛李維斯回信...
全港最大手機下載中心
http://mobile.yahoo.com.hk/


[Non-text portions of this message have been removed]



The primary EnergyPlus web site is found at:
http://www.energyplus.gov

The group web site is:
http://groups.yahoo.com/group/EnergyPlus_Support/

Attachments are not allowed -- please post any files to the appropriate folder in the Files area of the Support Web Site.
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/EnergyPlus_Support/

<*> To unsubscribe from this group, send an email to:
    EnergyPlus_Support-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/