Goal Seek

[tdutcher05]

Hello every body , I am trying to replicate the goal seek function in excel . I have 5 formulas that have the same 4 variables that we need to solve for. We have what the formulas should equal . For example purposes we will use 250 . we also have M in the formula that is a known value. All of the A12-A55 values are know values pulled from a matrix table. I need to be able to potentially incorporate this into Tabpy as the values we would have in tableau and then send them forumulas to Tabpy and have it optimize the 4 unknown variables values and send them back .

Lets define the 4 Variables that are unknow that we need to solve for below.
A
B
C
D


250 = [M]+A*[A12]+B*[A13]+C*[A14]+D*[A15]
250 = [M]+A*[A22]+B*[A23]+C*[A24]+D*[A25]
250= [M]+A*[A32]+B*[A33]+C*[A34]+D*[A35]
250= [M]+A*[A42]+B*[A43]+C*[A44]+D*[A45]
250= [M]+A*[A52]+B*[A53]+C*[A54]+D*[A55]

Question 1:how could we write this code in python?
Is Tabpy an option? if so question 2

Question 2: does any body have any idea how we could potentially do something like this utilizing Tableau and Tabpy table extension

[deanhystad]

Did you search for something like "excel goal seek python"? I did and saw this:

https://github.com/DrTol/GoalSeek_Python
https://towardsdatascience.com/a-better-...6aff56e9f2
https://pythoninoffice.com/replicate-exc...in-python/
https://bitsofanalytics.org/posts/what-i...lseek.html
...