+ Reply to Thread
Results 1 to 6 of 6

Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Points

  1. #1
    Registered User
    Join Date
    08-05-2015
    Location
    Boise, Id
    MS-Off Ver
    10 & 13
    Posts
    3

    Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Points

    I am attempting to calculate unknown points based off a known point and the percentage of two prior points range. Following is the formula.
    Point A (A1) - Unknown
    Point B (B2) – Unknown
    Point C (C1) – Known value = A1 + ((B2-A1)*.618)

    I also may have one or both of the following:
    Point D (D1) = C1 - ((C1-B2)*.618)
    Point E (E1) = C1 - ((C1-B2)*.382)
    Is there a way to determine A1 and B1?
    Thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Point

    There are an infinite number of point A & B numbers that will satisfy the point C formula

    e.g. given a point C value of 100 points A & B could be

    361,8123 & -61.832197
    261.8123 & -.0198999
    161.8123 & 61.6924

    Please explain with examples exactly what results you expect
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Point

    This looks like it will end up being some kind of "solve a system of equations" problem like you learned back in high school. I would suggest that you start by reviewing your algebra: http://www.purplemath.com/modules/systlin1.htm

    There are some inconsistencies in your problem statement. You mention trying to find B1, but there is no B1 in your equations (did you mean B2?). It is also unclear to me whether D1 and E1 will also be known.

    If I assume that either D1 or E1 are known, and that B2 and B1 are the same thing, then you should have a relatively simple system of 2 linear equations in 2 unkowns. The strategies in the algebra tutorial should be useful in solving such a system.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    08-05-2015
    Location
    Boise, Id
    MS-Off Ver
    10 & 13
    Posts
    3

    Re: Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Point

    Sorry for failing to proof properly. There is no B1. Only a B2.

  5. #5
    Registered User
    Join Date
    08-05-2015
    Location
    Boise, Id
    MS-Off Ver
    10 & 13
    Posts
    3

    Re: Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Point

    Expected results:
    Point A (A1) - 6469.95 Would be unknown
    Point B (B2) – 8877.93 Would be unknown
    Point C (C1) – 10336.06 Would be known value = A1 + ((B2-A1)*.618)
    Point D (D1) = C1 - 9797.59 May/May not be known ((C1-B2)*.618)
    Point E (E1) = C1 - 9446.39 May/May not be known ((C1-B2)*.382)

    Above is an example where all values are known. Would like to see if there is way to come up with Point B or A when only Point C is known.

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Calculate Unknown Points Based Off A Known Point And The Percentage Of Two Prior Point

    Standard rule of thumb when solving systems of equations is that you need at least as many equations as you have unknowns in order to find a unique solution. In the scenario you describe, you have 3 equations, and potentially 4 unknowns. When you have 4 unknowns, then you will have a scenario like Richard described above -- you can only find a relationship between A1 and B2. You will usually not be able to find a single, unique solution for A1 and B2.

+ 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: 1
    Last Post: 04-09-2014, 01:33 PM
  2. Calculate points for year based on last 180 days
    By Diogie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-08-2013, 04:01 PM
  3. calculate points based off a set point system
    By steggspolak in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-21-2013, 07:23 AM
  4. [SOLVED] Calculate Points based on Max Value in Rows and Columns
    By dksodhi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2013, 01:30 PM
  5. Replies: 1
    Last Post: 01-12-2013, 10:39 AM
  6. Replies: 3
    Last Post: 09-18-2012, 09:50 AM
  7. Replies: 11
    Last Post: 07-07-2012, 03:58 AM

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