topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • November 20, 2018, 09:54 PM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: How to find the math relationship/graph between one or more variables...  (Read 507 times)

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,685
    • View Profile
    • Donate to Member
Hello!


I have a complex model in excel. Among other parameters which I want to keep constant, I want to find the effect of each of four cells that contain variables (with some constrains) to a cell that is the result cell.

I want to find the optimum (minimum) four values to achieve the result I want and also find which of these four variables has the most significant effect on the result cell.

To give you some context, there are four teams that work in a very complex way and the four input cells are their employee number. The output cell has the end date of the project that is calculated with very complex way. How can I find which team is more worth to hire and how many?

Any idea? I am open to any freeware tool, etc.

Thanks!

KodeZwerg

  • Honorary Member
  • Joined in 2018
  • **
  • Posts: 327
    • View Profile
    • Donate to Member
Progress divide by HoursOfWork multiply Salary (for each Team)
Maby that?
sorry bad english and Delphi are my hobby ;)
politeness is not one of my strengths in writing, just because it sounds rough doesn't mean that I mean it rough.

Attronarch

  • Supporting Member
  • Joined in 2012
  • **
  • Posts: 134
    • View Profile
    • Donate to Member
To understand which variable has the highest impact you can use regression analysis and ANOVA.

Assuming it is a linear process you can use linear programming for optimization. If not, you can look at other mathematical optimization models.

If I remember correctly, Excel has built-in solver for linear programming but it has to be activated.

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,685
    • View Profile
    • Donate to Member
To understand which variable has the highest impact you can use regression analysis and ANOVA.

Assuming it is a linear process you can use linear programming for optimization. If not, you can look at other mathematical optimization models.

If I remember correctly, Excel has built-in solver for linear programming but it has to be activated.


Yes, I used Solver but it is very limited.
Is there a better tool?

Attronarch

  • Supporting Member
  • Joined in 2012
  • **
  • Posts: 134
    • View Profile
    • Donate to Member
Yes, MiniZinc.

Here is a tutorial for using it to solve a LP problem:
https://brilliant.or...lling-with-minizinc/

And two courses to dig deeper:
- Basic Modeling for Discrete Optimization
- Advanced Modeling for Discrete Optimization

kalos

  • Member
  • Joined in 2006
  • **
  • default avatar
  • Posts: 1,685
    • View Profile
    • Donate to Member
Yes, MiniZinc.

Here is a tutorial for using it to solve a LP problem:
https://brilliant.or...lling-with-minizinc/

And two courses to dig deeper:
- Basic Modeling for Discrete Optimization
- Advanced Modeling for Discrete Optimization

Thanks that looks very interesting!
Does it work within excel or can I copy/paste my excel model? Or is there anything similar that will work within Excel? I tried Solver but it doesn't seem to work :(
If I have to build it from scratch using that language it will be a nightmare!
« Last Edit: November 06, 2018, 03:55 AM by kalos »