+ Reply to Thread
Results 1 to 6 of 6

calculate weekly run rate

  1. 02-02-2014, 02:11 PM #1
    akleek
    akleek is offline
    Registered User
    Join Date
    02-01-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    calculate weekly run rate

    need to calculate weekly run rate. see attachment.
    D10 is the number of units.
    F2 is the current day of the month.
    G10 is currently 6 weeks from this week =D10/6
    H10 is currently 8 weeks from this week =D10/8
    I10 is currently 10 weeks from this week =D10/10
    J10 is currently 12 weeks from this week =D10/12
    K10 is currently 14 weeks from this week =D10/14

    I would like the run rate G10-K10 to be updated depending on the value of D10 automatically.



    weeklyRunRate.JPG
    Reply With QuoteRegister To Reply
  2. 02-02-2014, 02:58 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: calculate weekly run rate

    Welcome to the forum.

    If you want help with Excel, please post workbooks rather than pictures.

    Thanks.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 02-02-2014, 03:20 PM #3
    akleek
    akleek is offline
    Registered User
    Join Date
    02-01-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: calculate weekly run rate

    attached is the workbook
    Attached Images Attached Images
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 02-02-2014, 04:12 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: calculate weekly run rate

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    2
    WIN7 remain
    THIN remain
    Sub totals
    02-Feb
    15-Mar
    31-Mar
    15-Apr
    30-Apr
    15-May
    3
    		 DM5N/DM5S
    13
    36
    49
    4
    		 DM6
    1
    2
    3
    5
    		 DFAB/DHC/DFCA/DMAT
    11
    11
    22
    6
    		 DBUMP
    2
    0
    2
    7
    		 SCT
    3
    0
    3
    8
    		 RFAB
    1
    0
    1
    9
    10
    		 Remaining total
    80
    13.7
    9.8
    7.8
    6.4
    5.5


    The formula in G10 and copied right is

    =$D10 * 7 / (G2-$F2)
    Reply With QuoteRegister To Reply
  5. 02-02-2014, 05:13 PM #5
    akleek
    akleek is offline
    Registered User
    Join Date
    02-01-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: calculate weekly run rate

    shg,
    Looks like that worked!
    Thanks.
    Reply With QuoteRegister To Reply
  6. 02-02-2014, 05:15 PM #6
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: calculate weekly run rate

    You're welcome.
    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)

Similar Threads

  1. calculate TOTAL mileage (first 2 miles set rate) all miles thereafter at different rate
    By infinite2006 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-30-2013, 04:32 PM
  2. calculate TOTAL mileage (first 2 miles set rate) all miles thereafter set rate
    By infinite2006 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-30-2013, 08:26 AM
  3. [SOLVED] determine a rate from a range of values based on a weekly fuel price
    By djgoody9 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-29-2013, 12:48 PM
  4. Convert annual interest rate to weekly
    By shreksbro in forum Excel General
    Replies: 2
    Last Post: 08-23-2011, 03:07 AM
  5. calculate dates 4 weekly
    By jdjohn in forum Excel General
    Replies: 2
    Last Post: 07-30-2009, 08:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1