GoalSeek as a Function (not only a tool) in Gnumeric

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

GoalSeek as a Function (not only a tool) in Gnumeric

GnuMeric mailing list
Dear Gnumeric Developers and Community,

Good Evening!

My name is Eduardo Moraes and I'm an economist from Brazil.

I need to run some Monte Carlo simulations in Gnumeric but the variable of my interest can only be obtained using the GoalSeek tool. Unfortunately, it is impossible to run this GoalSeek tool at the end of every simulation on Gnumeric. I believe that the simplest solution would be to create a GOALSEAK sheet function in Gnumeric (something that doesn't exist on Excel or LibreOffice either). Together with the existing simulation tool, this function would be amazing for Monte Carlo analysis.

How can I contribute to the project in order to implement this new function? I have some Python programming knowledge and I can test this (or other) sheet functions that need testing. I have experience in finance modeling in Python and spreadsheets, and I'm currently doing my master's degree in Finance.

Is there any way I can contribute to this project?

Thank you in advance!!

_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|

Re: GoalSeek as a Function (not only a tool) in Gnumeric

Morten Welinder-2
Goal-seek changes the cells.  I don't see that happening in a sheet function.

However, something like this could probably be done in Python using
the introspection machinery.  A good starting point for exploring that
is the code in test/t3001-introspection-simple.py which shows
basically how to drive Gnumeric's engine from a python script.

Morten
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|

Re: GoalSeek as a Function (not only a tool) in Gnumeric

GnuMeric mailing list
Thanks, I'll check it out. 

Em qua, 3 de jun de 2020 22:39, Morten Welinder <[hidden email]> escreveu:
Goal-seek changes the cells.  I don't see that happening in a sheet function.

However, something like this could probably be done in Python using
the introspection machinery.  A good starting point for exploring that
is the code in test/t3001-introspection-simple.py which shows
basically how to drive Gnumeric's engine from a python script.

Morten

_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list