do you have a sample worksheet that shows how to use a solver for optimization problems.
On Tue, Apr 10, 2012 at 7:51 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > As I study the solver, I feel this is elder brother of Goal Seek in Excel > ,where we can change only one value with Goal seek , Using Solver we can > provide many cell for adjusting value as per our scenario , Below is the > Parameter required to solver ,**** > > We can add many scenario to see different analysis, **** > > ** ** > > Using Spreadsheets. Spreadsheets such as Microsoft Excel provide a > convenient way to build such a model. Cells on a worksheet can hold > numbers, labels, or formulas that calculate new values.**** > > - The decision variables for a model are simply worksheet cells > containing numbers that Solver can change.**** > - The objective is a cell containing a formula you want Solver to > maximize (or minimize) by adjusting the values of the decision variable > cells.**** > - Constraints are logical conditions on formula cells that must be > satisfied (specified with <=, = or >= relations). Frontline's various > Solver products provide powerful tools for solving, or optimizing, such > models.**** > > ** ** > > ** ** > > Rajan.**** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* Apr/Tue/2012 04:45 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Solver in excel**** > > ** ** > > *Hi Expert, > > Can somebody please guide me what is the use of solver in excel by the > help of example ?? with different different criteria !!!.. > Thanks in advance. > ***** > > **** > > Thanks & Regards,**** > > *Deba Ranjan P***** > > ** ** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com**** > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
