Results 1 to 6 of 6

Formula to calculate deductions in 48-week period and yield a 52-week value

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2014
    Location
    Fresno,CA
    MS-Off Ver
    2010
    Posts
    23

    Angry Formula to calculate deductions in 48-week period and yield a 52-week value

    Hello,
    I am in desperate need of assistance. I am at wits end and not sure if what I need done is even possible. What I am ultimately trying to achieve is to administer weekly deductions over a 48-week period that yield a 52-week value. I am currently using a spreadsheet to calculate deduction totals over a 48-week period based on a number entered into cell i8. The problem I am having, is when I try to add the sum result of weeks 49 through 52 to the calculated table which, at this point of the process has to be divided by 48 weeks and then added to the first calculated result of the first 48 weeks. However, weeks 49 through 52 would have to be excluded because this total value would now have been spread across the 48-week period. The idea is to first calculate the total amount of deductions over the 52-week period based on the contents of the value of cell $i$8. Next, I need to add the sum of weeks 49-52 and divide the sum by the 48-week deduction period, and finally add those results to the 48 weeks. So far everything I have tried gives me an error.

    The first calculating cell on the sheet is cell C11 containing the following =B11*$I$8 with the value of I8 being 4 so the immediate results of cell C11 shows 4. When I copy this formula down through the subsequent cells the results increase by 4 with C12 = to 8, C13 = to 12, and so on. What I would like the formula to do is use the result of I32 (which represents the total for week 48) and simulate the increment totals for the remaining weeks. If we use the example of 4 the sum total would be 808/48 yielding a result of 16.83 to be added to the 48-week totals with a new result in cell C11 now being 20.83. To make things more complex we have to remember that the current value of $I$8 being (4) for all intents and purposes is arbitrary, and could be any number or value when using this sheet to calculate totals. I am hopeful that someone here can help. Thanks in advance.
    Attached Files Attached Files
    Last edited by thenuguy; 05-29-2019 at 01:52 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to count how many days in week period, if period starts mid week?
    By mrsdeapsleap in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-18-2016, 03:29 AM
  2. [SOLVED] Calculate days left in a week period as they pass.
    By SenorPantalones in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-21-2014, 10:17 PM
  3. Replies: 6
    Last Post: 05-16-2014, 11:30 AM
  4. how to calculate days worked for an average over a five week period
    By Nicky_B in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2014, 11:28 AM
  5. How to: identify repeat offenders within a 3 week period (week per week basis)
    By Heloc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2012, 12:43 AM
  6. Replies: 9
    Last Post: 07-26-2012, 10:01 PM
  7. Formula to calculate Period & Week into Date?
    By AstroPenguin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2008, 08:12 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