+ Reply to Thread
Results 1 to 2 of 2

Fixed My Schedule-Was there an easier way?

  1. #1
    Registered User
    Join Date
    04-14-2020
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel
    Posts
    5

    Fixed My Schedule-Was there an easier way?

    I got my scheduler to workout I think it is the hard way, would like to know how I could have done it better, it was very tedious
    Essential recurring days (1,7,14,30,60,90,120,180,365 is selected
    Then the week number is selected
    This is plotted into table.The beauty is that the week number can be changed to adjust the loading of any particular week
    Interested in any comments
    Thank you for looking
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,055

    Re: Fixed My Schedule-Was there an easier way?

    To make it simpler, insert a column C for Week Factor and put this formula in cell E8: IF(IF($C8<1,$C8,MOD(E$7+$C8-$D8,$C8)+$C8)=$C8,$C8,0) in your calendar, then use the Conditional Formula in column B.
    Attached Files Attached Files

+ 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. How to calculate ratios for a revenue schedule? (the attachment is fixed)
    By my_sunshine in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-10-2014, 04:25 PM
  2. Formula/Macro required to special paste in Fixed Asset schedule
    By Fletch74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2014, 06:58 PM
  3. Replies: 1
    Last Post: 09-24-2013, 11:00 AM
  4. [SOLVED] Excel Schedule & How to Add to a Fixed Date
    By garrett.grillo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2012, 05:49 PM
  5. [SOLVED] maturity schedule fixed inc securities by month, quarter and year
    By maturity schedule in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2006, 07:10 PM
  6. Macro to run on schedule - easier way?
    By bondcrash in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-12-2005, 09:51 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