+ Reply to Thread
Results 1 to 4 of 4

Proportionate weightings

  1. 03-29-2010, 08:12 PM #1
    seputus
    seputus is offline
    Registered User
    Join Date
    03-29-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    21

    Proportionate weightings

    Well this has stumped an alleged math major, and I can't find anything on Google to help me so I really hope you guys and girls are good!

    I'm trying to create a scorecard and have the weightings increase/decrease proportionately to the amount of time that a person might spend "taking calls (inbound)" versus "making calls (outbound)"

    On the attached spreadsheet, I just need PROPER formulas (mine are completely wrong) in cells C7 through C10 (green borders). These formulas would need to look to the number of hours specified in cells B15 and B16 (red borders).

    The weights in B3:B10 are correct for someone who spends an equal amount of time in inbound and outbound.

    As someone spends more time in inbound, C10 must increase and B7:B10 must decrease proportionately.

    The total of cells C3 through C10 must always equal 100.

    Help!!!
    Attached Files Attached Files
    Last edited by seputus; 03-30-2010 at 06:59 AM.
    Reply With QuoteRegister To Reply
  2. 03-29-2010, 10:57 PM #2
    Rebuild8
    Rebuild8 is offline
    Registered User
    Join Date
    04-29-2008
    Location
    Tennessee
    MS-Off Ver
    2007
    Posts
    37

    Re: Proportionate weightings

    Use the formulas in the attached file
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-29-2010, 11:18 PM #3
    seputus
    seputus is offline
    Registered User
    Join Date
    03-29-2010
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    21

    Re: Proportionate weightings

    well i'll be.......

    i can hardly understand what you did. 0.004 .. 0.84? .. but it does indeed work..

    A HUGE thank you!
    Reply With QuoteRegister To Reply
  4. 03-29-2010, 11:33 PM #4
    Rebuild8
    Rebuild8 is offline
    Registered User
    Join Date
    04-29-2008
    Location
    Tennessee
    MS-Off Ver
    2007
    Posts
    37

    Re: Proportionate weightings

    I used the formula ax^2+bx+c=y.

    a100^2+b100=44
    a50^+b50=32

    (since there is a point (0,0), c=0)
    solve for a and b. Then repeat for the Inbound side.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1