Solver Component

Dear Kai Ahrens,

My name's Leandro Silveira and I'm a Brazilian computer
programmer just
trying to find something nice to do.
While visiting OpenOffice.org website, I got interested in
doing some
contributing work.
Actually, the task below interested me because I just love
Optimization,
Mathematics, Operations Research, and Engineering. Besides,
some time ago I
did some research about GRG (Generalized Reduced Gradient),
the former
computer algorithm used by Microsoft Excel to solve and
optimize the results
of a set of Linear Independent Equations.
So... I'm writing for further information on this task...
Yours,
-- 
Leandro S. M. da Silva
(11) 9271.7206
Blog: http://leandrosms.blog
spot.com
Site: http://www.ge
ocities.com/leandrosms.geo


*OpenOffice.org Calc: Creating a solver component* 
*Summary/Comments*  A
solver component modifies a range of input cells within a
spreadsheet with
the approach to track the results of this input changes.
Goal of this
process is to find an optimal set of input values to satisfy
given
constraints. An UI is to be created to set the input cells
and the input
constraints.  *Contact*

   - devsc.openoffice.org
   - Kai.Ahrens at sun.com

Leandro Silveira Monteiro da Silva wrote:
> My name's Leandro Silveira and I'm a Brazilian
computer programmer just
> trying to find something nice to do.
> While visiting OpenOffice.org website, I got interested
in doing some
> contributing work.

That's great.

> Actually, the task below interested me because I just
love Optimization,
> Mathematics, Operations Research, and Engineering.
Besides, some time ago I
> did some research about GRG (Generalized Reduced
Gradient), the former
> computer algorithm used by Microsoft Excel to solve and
optimize the 
> results
> of a set of Linear Independent Equations.
> So... I'm writing for further information on this
task...

Kohei Yoshida is working on a solver component, see 
http://wiki.services.openoffice.org/wiki/Optimizatio
n_Solver and 
http://kohei.us/ooo/solv
er/. It's probably better to help him with that 
one instead of starting something new.

Note that devsc.openoffice.org is a mailing list, see 
http://sc.openoffice.org/servlets/ProjectMailingListList
 for archives 
and subscription instructions.

Niklas

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

On Tue, Jun 27, 2006 at 08:36:29PM +0200, Niklas Nebel
wrote:
> Leandro Silveira Monteiro da Silva wrote:
> >My name's Leandro Silveira and I'm a Brazilian
computer programmer just
> >trying to find something nice to do.
> >While visiting OpenOffice.org website, I got
interested in doing some
> >contributing work.
> 
> That's great.
> 
> >Actually, the task below interested me because I
just love Optimization,
> >Mathematics, Operations Research, and Engineering.
Besides, some time ago I
> >did some research about GRG (Generalized Reduced
Gradient), the former
> >computer algorithm used by Microsoft Excel to solve
and optimize the 
> >results
> >of a set of Linear Independent Equations.
> >So... I'm writing for further information on this
task...
> 
> Kohei Yoshida is working on a solver component, see 
> http://wiki.services.openoffice.org/wiki/Optimizatio
n_Solver and 
> http://kohei.us/ooo/solv
er/. It's probably better to help him with that 
> one instead of starting something new.

Kohei is currently using lp_solve to do the actual solving
which
uses simplex and branch and bound.  Adding a GRG component
in
lp_solve would be the best solution.

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org

Hi, Niklas.

Thanks for your reply and attention.

I'd like to know what kind of thing I should do first. In
my opinion, one
should take contact with all the work in progress,  increase
one's knowledge
in the project's  management and organization, and start
working.

But how can I achieve that? Should I write directly to Kohei
Yoshida or to
you? Or yet to devsc.openoffice.org?

I'm so sorry for the inconvenience, but this is my very
first time in this
kind of open project collaboration...

As I said before, I send you the link to Microsoft's
website where it's
explained about GRG algorithms... ( http://suppo
rt.microsoft.com/kb/q214115/)

Thanks a lot,

Leandro

On 6/27/06, Niklas Nebel <Niklas.Nebelsun.com> wrote:
>
> Leandro Silveira Monteiro da Silva wrote:
> > My name's Leandro Silveira and I'm a Brazilian
computer programmer just
> > trying to find something nice to do.
> > While visiting OpenOffice.org website, I got
interested in doing some
> > contributing work.
>
> That's great.
>
> > Actually, the task below interested me because I
just love Optimization,
> > Mathematics, Operations Research, and Engineering.
Besides, some time
> ago I
> > did some research about GRG (Generalized Reduced
Gradient), the former
> > computer algorithm used by Microsoft Excel to
solve and optimize the
> > results
> > of a set of Linear Independent Equations.
> > So... I'm writing for further information on this
task...
>
> Kohei Yoshida is working on a solver component, see
> http://wiki.services.openoffice.org/wiki/Optimizatio
n_Solver and
> http://kohei.us/ooo/solv
er/. It's probably better to help him with that
> one instead of starting something new.
>
> Note that devsc.openoffice.org is a mailing list, see
> http://sc.openoffice.org/servlets/ProjectMailingListList
 for archives
> and subscription instructions.
>
> Niklas
>



-- 
Leandro S. M. da Silva
(11) 9271.7206
Blog: http://leandrosms.blog
spot.com
Site: http://www.ge
ocities.com/leandrosms.geo

Hi Leandro,

On 6/28/06, Leandro Silveira Monteiro da Silva
<leandrosmsgmail.com> wrote:
> Hi, Niklas.
>
> Thanks for your reply and attention.
>
> I'd like to know what kind of thing I should do first.
In my opinion, one
> should take contact with all the work in progress, 
increase one's knowledge
> in the project's  management and organization, and
start working.

Is GRG a NLP algorithm?  A quick glance at the Microsoft
website you
referenced indicates that it is indeed a NLP algorithm.  If
so, then
so far no work has been done in this front, so your help
will be
greatly appreciated.

The current solver code is in a separate, non-official build
known as
the "ooo-build".  And if you are interested in
getting your hand dirty
with the code, we'll be glad to give you a hand.  Just let
us know.

How is your C++ skill?  The main code base, both of
OpenOffice.org and
my solver, is written in C++.  So, that's the language
you'd be using
if you decide to contribute.

>
> But how can I achieve that? Should I write directly to
Kohei Yoshida or to
> you? Or yet to devsc.openoffice.org?

You can use devsc.openoffice.org.  I'm on this list, and
I actually
prefer we discuss matters on this list, but you're free to
send me a
mail off list if you prefer.  I may not be always quick, but
I'll
answer.

To subscribe, send an empty message to
dev-subscribesc.openoffice.org, then reply to the
confirmation
message that gets sent to you.

> I'm so sorry for the inconvenience, but this is my
very first time in this
> kind of open project collaboration...

You'll get used to it soon.  I've been there too.


Kohei

-- 
Kohei Yoshida, OpenOffice.org Calc Hacker
<koheiopenoffice.org>

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribesc.openoffice.org
For additional commands, e-mail: dev-helpsc.openoffice.org