Results 1 to 5 of 5

Thread: Contract projections help
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Sep 2009
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Contract projections help

    Hi,

    I'm trying to build into a spread sheet a function but am really stuck. I have a 3 year monthly projection. In each month a number of contracts occur, eg 1 new contract or 2 new contracts etc.

    I need to be able to select a start month and then the flow of new contracts (which has no pattern but doesnt change) will begin at the selected month. I would also like to be able to build in a function where by you can choose the monthly gap between contracts after which the normal pattern resumes.

    For example if Sept 10 was selected the pattern would start at this month, before this no new contracts would be shown. Then if i choose a gap of 2 months between contract 4 and contract 5 no new contracts would be shown for the 2 months between the 4th new contract and the 5th new contract and then the normal pattern will resume after the 2 months.

    I understand you may need more info/explaination but any help will be awesome!

    Thanks,

  2. #2
    MrExcel MVP Andrew Fergus's Avatar
    Join Date
    Sep 2004
    Location
    New Zealand
    Posts
    5,425
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Contract projections help

    Hi

    I suspect your question hasn't been answered because it is difficult to understand or envisage what it is you are trying to do. Are you able to provide a sample of what you want? In case you haven't seen it already, within the FAQs is a section showing how to display your spreadsheet in this forum.

    Andrew
    ~ >*()))><(


    I'd rather have a full bottle in front of me than a full frontal lobotomy.

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Posts
    828
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Contract projections help

    Sounds completely do-able. Want to provide a sample?
    Humpty Dumpty was pushed

  4. #4
    Board Regular
    Join Date
    Sep 2009
    Posts
    69
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Re: Contract projections help

    thanks for your reply's guys. However when visiting the Colo Website to download the HTML maker it is coming up as a 404 error, file not found.

    Any ideas on what to try now.

    Cheers

  5. #5
    MrExcel MVP Andrew Fergus's Avatar
    Join Date
    Sep 2004
    Location
    New Zealand
    Posts
    5,425
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Contract projections help

    Sorry - I wasn't aware the download links on that site were broken. It appears all of the links are broken.

    One of our MVPs, Erik, also developed a tool to help display your worksheet. Here is Erik's profile:
    http://www.mrexcel.com/forum/member.php?u=25109

    At the bottom are some links to his add-in called 'Table-it'. There are some size limiations with Erik's add-in so if you only show a portion of the relevant data it should be ok.

    Andrew
    ~ >*()))><(


    I'd rather have a full bottle in front of me than a full frontal lobotomy.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •