Re: [EnergyPlus_Support] Performance curve for the chiller

["Michael J. Witte" <mjwitte@xxxxxxxx>]

An example spreadsheet has been added to the Examples folder in the files area 

File        : /Examples/Excel Biqudratic Fit.zip  

Description : Example spreadsheet showing bi-quadratic curve fit using Excel 
LINEST function.  

You can access the file at the URL: 
http://groups.yahoo.com/group/EnergyPlus_Support/files/Examples/Excel%20Biqudra 
tic%20Fit.zip  

On 23 Feb 2005, at 12:07, wing sun lee wrote:

> 
> 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. 
> 
> 
> ­É¹L¡B¤@©ç¨â´²¡B©_¬¥§õºû´µ¦^«H...
> ¥þ´ä³Ì¤j¤â¾÷¤U¸ü¤¤¤ß
> 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
> 
> 
> 
> 
> 
> 
> 
> 
> 






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/