Excel Solver Optimize Non-Linear Problem

$10-30 USD

Закрито

Опублікований

about 6 years ago

$10-30 USD

Оплачується при отриманні

I attached a simple example of the problem I'm facing. I'd like to maximize a cell that is the sum of other cells that are not linear. In the spreadsheet, I have Z scores for categories I and II (I hardcoded in a mean of 30 and stdev of 15 for category I and 40 and 10 for category II), but do not want to maximize those z-score sums. I want to maximize the sum of their normdist values in G13. Clearly, solver won't find a linear solution. I have heard there was a way to get around this by doing piecewise-linear approximation. This is not a project that will take long to complete. You may try a few different methods to get this to work, but for the most part you should have a solution in your head before starting. Please let me know if you've found a solution and then if it works, I will hire you and complete the transaction.

ID проекту: 16191186

Про проект

15 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

15 фрілансерів(-и) готові виконати цю роботу у середньому за $29 USD

@mohamedrdait

Hello I am an engineer in operational research and decision support I can achieve this project perfectly using solver excel please contact me for more details about the project best regards

$55 USD за 1 день

4,9

(46 відгуки(-ів))

5,7

@luicho10

I am a graduate in mathematics with a master's degree in applied mathematics and I have advanced knowledge in excel and linear programming, I can help you with your project

$15 USD за 0 день

5,0

(6 відгуки(-ів))

3,5

@Joni058

expert is here

$20 USD за 1 день

5,0

(6 відгуки(-ів))

2,9

@jamalagouram

A proposal has not yet been provided

$30 USD за 3 дні(-в)

4,9

(3 відгуки(-ів))

2,0

@mha593efed516da0

I am electrical engineering .I have lot of experience working with various employers globally. Can I do Circuit Analysis and design, Power System Analysis,DC/AC machines Electrical Distribution , translation and technical writer .i use Autocad,Matlab,Revit,Plc simulator,Arduino , Pspice,word and excel.

$10 USD за 1 день

5,0

(2 відгуки(-ів))

0,9

@nataleecate

Thanks for posting the project on this site. I have vast experience in excel and data entry. Looking forward to work with you.

$30 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@TuwokHowardii

Contact me and I use my knowledge of excel and statistics to try complete project to satisfaction. I have basic background knowledge on statistics and Excel VBA and will try completing.

$30 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@jgmezag

I am very interested in a job in which I can demonstrate my knowledge and my experience. I have a degree in Mathematics and an expert in Matlab & Mathematics & Operations Research, with basic knowledge in statistics and probabilities. I am currently a professor in the Operations Research area with 18 years of experience. For this reason I feel that my skills will be of great benefit for your work. I am a responsible person and with great desire to excel. I am ready to be hired by you and start working on your jobs.

$25 USD за 10 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@cagriozturk

First of all you have to add more constraints and in excel you entered st. dev of II as 20 but you wrote in explanation 10. If you want to solve this problem you have to share with me text of the problem and than I decide constraints and variables. If this problem is nonlinear than you have to multiply two variables in objective function but as I seen you didn't do that. As a result, if you share with me more information I can solve the problem in Matlab or Gams or Excel.

$25 USD за 1 день

0,0

(0 відгуки(-ів))

0,0

@ritikbapna

A proposal has not yet been provided

$30 USD за 2 дні(-в)

0,0

(0 відгуки(-ів))

0,0

@Iremnurturkmen

I am an student in Operation Research. In my academic life, i use same program for my projects. Relevant Skills and Experience cplex, excel solver project, mixed integer programming,

$25 USD за 1 день