+ Reply to Thread
Results 1 to 6 of 6

Help with a Frost Bite Time Equation

  1. #1
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    113

    Help with a Frost Bite Time Equation

    I have the following equation...

    Frost Time = ((-24.5 x ((0.667 x (wind x 8/5)) +4.8)) + 2111) x (-4.8 - ((temperature -32) x 5/9))^-1.668

    wind = cell x4
    temperature = cell y4

    I came up with the following equation...

    SUM(-24.5*(SUM(0.667*(X$4*(8/5)))+4.8),2111) *sum ((-4.8,-((Y$3-32)*(5/9)))^-1.668)

    but I keep getting the error #NUM!

    Can anyone point out my error?

    Thanks!

    Jeff

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Help with a Frost Bite Time Equation

    Try this-
    Please Login or Register  to view this content.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: Help with a Frost Bite Time Equation

    Thanks for getting back to me. I still get the same error. I figured it has to do with the negative exponent.

    Jeff

  4. #4
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Help with a Frost Bite Time Equation

    But I am not getting any error.
    Can you attach a sample workbook?

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,158

    Re: Help with a Frost Bite Time Equation

    I figured it has to do with the negative exponent.
    Sort of. It isn't so much the negative exponent that causes a problem, but the fractional (.688) part of the exponent. And even that is not a universal problem. It is only a problem when the "base" is a negative number. So Excel can calculate 5^-1.688 just fine, but it will fail to calculate (-5)^1.688.

    Looking at this with my engineering background, I see a temperature term where you a) convert your temperature from Fahrenheit to Celsius (which can be positive or negative), then b) add a constant and c) raise that to a fractional power. IMO, the easiest solution is to use an absolute temperature scale (Kelvin rather than Celsius) that can never give a negative number. Since Kelvin=Celsius+273.15, it should be relatively simple algebra to adjust that part of the formula to use K rather than C. That's how I would do it.

    On edit: I looked closer, and that will not fix it. On closer inspection, that temperature term will be negative whenever t in C is > -4.8 C. Is there a restriction on the use of the equation to temperatures <= -4.8 C? Because it looks like there should be such a limit. Is there a different equation that should be used at warmer temperatures?
    Last edited by MrShorty; 02-11-2016 at 11:18 AM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Forum Contributor
    Join Date
    11-23-2013
    Location
    La Crosse, Wi
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: Help with a Frost Bite Time Equation

    There was a limit. I found that the temperature could not exceed 10F. Thanks for the help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 04-09-2012, 01:36 PM
  2. Replies: 4
    Last Post: 02-02-2012, 10:11 PM
  3. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  4. Replies: 2
    Last Post: 07-21-2010, 08:59 AM
  5. Hour equation with long date/time
    By caryno in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2008, 10:17 AM
  6. Equation Editor- problem when editing an equation
    By Gaby L. in forum Excel General
    Replies: 0
    Last Post: 09-27-2005, 05:05 PM
  7. excel equation (user defined equation)
    By excel_student in forum Excel General
    Replies: 0
    Last Post: 03-10-2005, 03:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1