Become a part of the TranceAddict community!Frequently Asked Questions - Please read this if you haven'tSearch the forums
TranceAddict Forums > Main Forums > Chill Out Room > Hi ! Who Knows How To Use The Solver Tool From Excel ?
  Last Thread   Next Thread
Share
Author
Thread    Post A Reply
djzero2k
Senior tranceaddict



Registered: Oct 2000
Location: Cordoba =-= Argentina
Hi ! Who Knows How To Use The Solver Tool From Excel ?

Hi !!! Guys !!!
How's all ?. Hope that fine...
Wanted to know how to use the solver tool to solve some symplex method problems... I have been looking for ages some instructions... But they don't seem to be on the web or that's what I think...
Well If u know... Pls Let me know !!! :=)

Love Electronic & Gospel !

Old Post Sep-30-2004 15:46  Argentina
Click Here to See the Profile for djzero2k Click here to Send djzero2k a Private Message Add djzero2k to your buddy list Report this Post Reply w/Quote Edit/Delete Message
jdat
Jay Van Dat



Registered: Oct 2001
Location: I dont even know

http://www.fuckinggoogleit.com/

http://puccini.che.pitt.edu/~karlj/...101/solver.html

http://office.microsoft.com/en-us/a...1245951033.aspx

http://www.solver.com/tutorial.htm

[URL=http://www.mccombs.utexas.edu/faculty/msis/lasdonl/DesignMSExcel_files/DesignMSExcel.htmhttp://www.mccombs.utexas.edu/faculty/msis/lasdonl/DesignMSExcel_files/DesignMSExcel.htm[/URL]

Old Post Sep-30-2004 18:11 
Click Here to See the Profile for jdat Click here to Send jdat a Private Message Add jdat to your buddy list Report this Post Reply w/Quote Edit/Delete Message
butterfly
melissa



Registered: Apr 2002
Location: West CoCo, CA

i used the solver when i was in college... what is the problem?

Old Post Sep-30-2004 18:22  United States
Click Here to See the Profile for butterfly Click here to Send butterfly a Private Message Add butterfly to your buddy list Report this Post Reply w/Quote Edit/Delete Message
djzero2k
Senior tranceaddict



Registered: Oct 2000
Location: Cordoba =-= Argentina

Maybe I don't know how to input the objective function and all the restrictions but... I am seeing right now... I'll let u know coz this seems difficult ! :=)

Old Post Oct-01-2004 23:31  Argentina
Click Here to See the Profile for djzero2k Click here to Send djzero2k a Private Message Add djzero2k to your buddy list Report this Post Reply w/Quote Edit/Delete Message
djzero2k
Senior tranceaddict



Registered: Oct 2000
Location: Cordoba =-= Argentina

It's seems pretty easy... The problem is that the pc doesn't have the solver tool... So I'll have to wait another time when I go to another cyber... Thankx !!!

Old Post Oct-01-2004 23:44  Argentina
Click Here to See the Profile for djzero2k Click here to Send djzero2k a Private Message Add djzero2k to your buddy list Report this Post Reply w/Quote Edit/Delete Message
Kaz
Supreme tranceaddict



Registered: Apr 2004
Location: Toronto

quote:
Originally posted by djzero2k
It's seems pretty easy... The problem is that the pc doesn't have the solver tool...


Yeah that could be a problem. LOL

Old Post Oct-01-2004 23:49 
Click Here to See the Profile for Kaz Click here to Send Kaz a Private Message Add Kaz to your buddy list Report this Post Reply w/Quote Edit/Delete Message
djzero2k
Senior tranceaddict



Registered: Oct 2000
Location: Cordoba =-= Argentina

Ok !!! It doesn't seem too easy !!
Here are some doubts...
1> When I have a symplex problem and all the restrictions are =<, how I can minimize it ?. Coz the Cj-Zj spaces have only negative values...

2> When I have:
Min Z: 2x + 3y
Am I suposse to multiply the objective function by -1 ?.
Can u show me how would it be graphically in a table ?.

3> How do u interpret an not limited problem ?. The one that the variable decision can assume unlimited values, as long as the difference between the values is 2 for ex ?.

OOOOH By the way... I have the exam tomorrow !!!
"Operative Investigation" !!!

Old Post Oct-05-2004 14:38  Argentina
Click Here to See the Profile for djzero2k Click here to Send djzero2k a Private Message Add djzero2k to your buddy list Report this Post Reply w/Quote Edit/Delete Message
djzero2k
Senior tranceaddict



Registered: Oct 2000
Location: Cordoba =-= Argentina

Ok... I have just gave my written exam...
You are let say a consultor and you have to recommend a company it's production level... The objective function and the restrictions are these:

Objective Function => Max Z: 1205X1 + 2545X2
Restrictions => X1 + X2 =< 750
=> 24X1 + 18X2 =< 24400

And Ooops what a dumb !!! I forgot it !!!


I'll try to remember !

Old Post Oct-06-2004 16:54  Argentina
Click Here to See the Profile for djzero2k Click here to Send djzero2k a Private Message Add djzero2k to your buddy list Report this Post Reply w/Quote Edit/Delete Message
noikeee
dubstep convert



Registered: Apr 2002
Location: lost and wandering looking for directions.

i'm taking that class too hehe

sounds like a fairly easy problem though?

last year (i reproved) my teacher talked about this program that solved all the stuff automatically called LINDO. try searching for it.


___________________
sempre contra a corrente do jogo

Old Post Oct-06-2004 18:19  Portugal
Click Here to See the Profile for noikeee Click here to Send noikeee a Private Message Visit noikeee's homepage! Add noikeee to your buddy list Report this Post Reply w/Quote Edit/Delete Message
djzero2k
Senior tranceaddict



Registered: Oct 2000
Location: Cordoba =-= Argentina
Hello! The Problem At Last...

Hi Guys !!! At last, my professor lent me the page with the problem... The thing is, that it is in Spanish... So... It's very difficult to translate it for me... Sorry.... Anyway here is it...

A La Gerencia De Planeamiento...
Se pide el plan de produccion para optimizar el beneficio neto obtenido en base a la fabricación de bombas hidraúlicas y neumáticas, sabiendo que el precio de venta de cada una de estas es de $1900 y $2350 respectivamente. En cada una de estas, se utiliza un cilindro de succión, disponiéndose en total de 650 cilindros costando $75 cada uno. La cantidad de horas de montaje necesarias para cada bomba es de 0.3 y de 0.4 respectivamente, costando $250 la hora y habiendo 1700 horas de montaje. Por otro lado, es necesario salir al mercado con por lo menos 20 embarques, pudiendo cada embarque armarse con 12 bombas hidraúlicas o 18 bombas naumáticas. El resto de los costos de materia prima para cada una es de $350 para las bombas hidraúlicas y y $190 para las bombas naumáticas...

Proporcionar un informa y el plan de producción...

Hope someone knows english, if no Ii'll try to translate ( )

Old Post Oct-21-2004 15:36  Argentina
Click Here to See the Profile for djzero2k Click here to Send djzero2k a Private Message Add djzero2k to your buddy list Report this Post Reply w/Quote Edit/Delete Message

TranceAddict Forums > Main Forums > Chill Out Room > Hi ! Who Knows How To Use The Solver Tool From Excel ?
Post New Thread    Post A Reply

 
Last Thread   Next Thread
Click here to listen to the sample!Pause playbackTechno track ID4 [2009] [1]

Click here to listen to the sample!Pause playbackColin McNeil - "Cloudscience" [2004]

Show Printable Version | Subscribe to this Thread
Forum Jump:

All times are GMT. The time now is 09:07.

Forum Rules:
You may not post new threads
You may not post replies
You may not edit your posts
HTML code is ON
vB code is ON
[IMG] code is ON
 
Search this Thread:

 
Contact Us - return to tranceaddict

Powered by: Trance Music & vBulletin Forums
Copyright ©2000-2026, Jelsoft Enterprises Ltd.
Privacy Statement / DMCA
Support TA!