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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By tcrjmom in forum Excel Formulas & Functions
Last Post: 04-16-2013, 04:39 PM
By Glayva in forum Excel General
Last Post: 08-03-2011, 12:03 PM
By GerryK in forum Excel Formulas & Functions
Last Post: 12-06-2005, 11:35 AM
By Aladin Akyurek in forum Excel Formulas & Functions
Last Post: 09-06-2005, 07:05 AM
By Ravi in forum Excel Formulas & Functions
Last Post: 09-06-2005, 12:05 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1