Results 1 to 16 of 16

Adjust growth rate based on rank or count

Threaded View

  1. #14
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Adjust growth rate based on rank or count

    I'm glad I could (almost) help! The numbers are off because I didn't quite understand what you were attempting to do, and it seemed sounder to make the X% adjustment to the actual stats, rather than the average of the stats' percentages. That's what my initial effort does. The crucial part I didn't understand was the need/role for the bit with the percentages in rows 33:35. I still don't quite get it, but I don't think I need to - I'm pretty sure I can make the math work. Try the following in B30. As before, it must be array-entered with Ctrl + Shift + Enter:

    =B$29+(0.09*$M$30*ABS(ABS(B$25-8)-8)/SUM(ABS(ABS($B25:$J25-8)-8)))*B$28

    Fill right through J30, and the totals should adjust such that the average of the percentages in B34:J34 is adjusted according to the input in M30. Experiment with the attachment a bit to see if it holds while you tinker with the character build/settings.
    Attached Files Attached Files

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: 06-22-2017, 02:58 AM
  2. [SOLVED] Max value of percentage of figure formulas
    By chrisi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-25-2015, 02:01 AM
  3. [SOLVED] Can't figure out proper formulas and functions for textbook problem
    By Burton18 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-11-2014, 02:36 AM
  4. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  5. Replies: 2
    Last Post: 08-07-2012, 07:59 PM
  6. figure out:Multiple formulas in one cell
    By Cjax in forum Excel General
    Replies: 7
    Last Post: 07-31-2009, 10:34 AM
  7. Date functions-is there a way to have excel figure
    By Bonniem in forum Excel General
    Replies: 2
    Last Post: 10-10-2005, 10:05 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