+ Reply to Thread
Results 1 to 1 of 1

Scheduler Tool works but can it be simpler? Does anyone have a simpler scheduling formula?

  1. #1
    Forum Contributor
    Join Date
    04-20-2011
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2007
    Posts
    121

    Scheduler Tool works but can it be simpler? Does anyone have a simpler scheduling formula?

    Spreadsheet works but is too large.
    Enter shipment lots in month, row 3 cell F3 onwards
    150,000 units made pa, 1st shipment Jan 2013
    Repeat shipment at cell A3 ie when 300,000 is reached (value can be changed as desired)
    Automatic schedule re appears in row 4, into the future and each time a multiple of 300,000 is reached eg 300k, 600k, 900k etc
    Now look at the number of lines it has taken (unhide the rows)
    Does anyone have a scheduling formula that could replicate the spreadsheet? There must be a simpler way of doing this. Any help appreciated.



    Chambo
    Attached Files Attached Files
    Chambo1160

+ 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. Simpler way to complete my IF formula?
    By tcrjmom in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 04-16-2013, 04:39 PM
  2. Simpler formula for IF statement?
    By Glayva in forum Excel General
    Replies: 1
    Last Post: 08-03-2011, 12:03 PM
  3. [SOLVED] Complex formula vs. simpler
    By GerryK in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-06-2005, 11:35 AM
  4. A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED
    By Aladin Akyurek in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED
    By Ravi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 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