+ Reply to Thread
Results 1 to 8 of 8

Shift annual costs forward based on new start date

  1. #1
    Registered User
    Join Date
    05-26-2018
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    1

    Shift annual costs forward based on new start date

    Hi all!

    (FYI, this is my first post so apologies if I haven't properly followed conventions in some way )

    Context

    I have a sheet containing costs data, with costs recorded by FY as per the attached (mocked-up extract).

    The costs are inputs from a client and implicitly assume a particular start date within a particular FY (i.e. they generally start in 2018 and are generally less in 2018, implying that the client is assuming they start the build & run of the particular technology around halfway through the year), which I plan to request from the client.

    However, this start date is quite uncertain at this stage, and the sheet needs to be readily flexible according to variation in the particular start date.

    The relevant costs are essentially fixed, not variable with respect to volume.

    Question

    How can I set up the sheet / what formula can I use to shift costs back and forth based on a new start date (and implied current start date)?

    I can only think of quite clunky formulae and I wonder if someone has a more elegant solution?

    Many thanks in advance for any assistance you can provide!

    Kind regards,
    Rachel

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,858

    Re: Shift annual costs forward based on new start date

    Hi Rachel and welcome

    With such a small sample dataset we're going to need a little more information.

    Could you show us what your expected outcome under each scenario is to give us a better idea of your requirement?

    You say you can only think of quite clunky formulae... Could you show us what that is? Again this will give a better understanding of what you need done.

    BSB

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    89,893

    Re: Shift annual costs forward based on new start date

    As BSB has said, there simply isn't enough to go on in the attached workbook - no indication of the outcome required, no attempt at a formula.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: Shift annual costs forward based on new start date

    Perhaps if you broke the year down into months, that would hep apportion the costs to a monthly level, based on what month the start is in?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    05-27-2018
    Location
    UK, London
    MS-Off Ver
    2013
    Posts
    11

    Re: Shift annual costs forward based on new start date

    Not at all, but I made it yesterday, thanks for this example

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,858

    Re: Shift annual costs forward based on new start date

    Quote Originally Posted by Rodguirre View Post
    Not at all, but I made it yesterday, thanks for this example
    What does this even mean? How is it relevant to this thread??

    BSB

  7. #7
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,489

    Re: Shift annual costs forward based on new start date

    nope no sense at all.. rodguirre had a bad case of "chateritus" posted 10 totally random comments in 10 different topics in less then 5 minutes.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: Shift annual costs forward based on new start date

    Thanks Joel, I have been keeping tabs on them too

+ 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. Replies: 2
    Last Post: 08-25-2017, 03:46 AM
  2. [SOLVED] How to make automatic 'parallel shift' based on specific start date?
    By wintheranders in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2016, 07:16 AM
  3. Replies: 5
    Last Post: 08-04-2014, 06:42 PM
  4. [SOLVED] 5 year annual turnover calculated from start date - needs slight adjustment
    By aaaaaaiden in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-03-2013, 07:30 AM
  5. [SOLVED] Excel Formula to Show Type of Shift Based on Start and End Time
    By bjnockle in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 07-03-2013, 09:48 PM
  6. How to spread annual forecasts by month across fiscal years by variable start date
    By gbolanis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 11:59 AM
  7. Count working shift in start and end date
    By eojchin in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-25-2013, 12:48 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1