+ Reply to Thread
Results 1 to 4 of 4

Interpolating monthly data from yearly actuals

  1. #1
    Registered User
    Join Date
    12-01-2023
    Location
    Milwaukee
    MS-Off Ver
    2309
    Posts
    2

    Exclamation Interpolating monthly data from yearly actuals

    Hi,

    I am trying to linear interpolate annual data into monthly.

    2019 29,063,000
    2020 31,388,000
    2021 24,826,000
    2022 27,436,000


    Any help would be greatly appreciated

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,508

    Re: Interpolating monthly data from yearly actuals

    It's not really clear what you want.

    The way I am interpreting your question is to find a linear trendline for these four data points then calculate the interpolation of the 48 months onto that line. See attached file.

    If you do that, the values for the months will no longer add up to the totals for each individual year.

    But I can't think of any other way to interpret what you are asking.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    12-01-2023
    Location
    Milwaukee
    MS-Off Ver
    2309
    Posts
    2

    Re: Interpolating monthly data from yearly actuals

    Thank you 6StringJazzer. Appreciate your help

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2411
    Posts
    26,508

    Re: Interpolating monthly data from yearly actuals

    Thanks for the rep!

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ 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. [SOLVED] Transpose yearly and monthly data
    By ektatak in forum Excel General
    Replies: 12
    Last Post: 03-02-2022, 04:07 AM
  2. Replies: 1
    Last Post: 11-16-2020, 02:41 PM
  3. Converting yearly data to monthly
    By MilicaMatovic in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2016, 06:59 PM
  4. Converting weekly to monthly data and Yearly data to monthly
    By MilicaMatovic in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2016, 09:48 AM
  5. how to best organize Daily. Monthly, and yearly data???
    By JonTaylor in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-08-2015, 01:33 AM
  6. Converting a daily data to a monthly or yearly one
    By rimajed in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 05-25-2012, 03:14 AM
  7. Converting monthly data into yearly averages
    By alcleland in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-14-2008, 08:34 AM

Tags for this Thread

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