Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Does anyone know how to develop forumulas or algorithms for various cells?
I am working in Microsoft Excel 2003. I have a problem that requires
me to develop a 27-week labor schedule. In making this schedule I have capacity requirements (limits on values) for certain weeks. I also have forecasted demands for those 27-weeks that are related to my labor schedule during those 27-weeks. If my value for the labor schedule during those 27-weeks exceeds the capacity requirement then I have to make changes in my forecasted demand (which exists in other cells). So, I need to develop a formula in the forecasted demand cells that tells it to automatically change it's value to an optimal value so that the cells within the 27-weeks don't exceed the capacity requirements. Does anyone know how to do this? What funciton do I need to use? Thanks for any help. -Chris |
#2
|
|||
|
|||
sounds like you should use solver - a simple linear program optimizer located under tools -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=319208 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |