Hello everyone,
I was wondering if anyone understood the matlab fmincon function well enough to have the same function done in excel (for just 2 parameters).
My problem is the following:
I have a spectrum in excel and i need to make a baseline underneath this that follows the trends of the spectrum.
I know that fmincon works well for this problem because other people have uesd it, but I want to have the steps understood so I can have this data in excel format to go with a vba macro I've created.
This is what the explaination they give is:
x = fmincon(fun,x0,A,b) starts at x0 and attempts to find a minimizer x of the function described in fun subject to the linear inequalities A*x ≤ b. x0 can be a scalar, vector, or matrix.
How exactly does it ""attempt to find a minimizer"? is this a loop or what? and how would I put this into excel?
Any help is appreciated
I was wondering if anyone understood the matlab fmincon function well enough to have the same function done in excel (for just 2 parameters).
My problem is the following:
I have a spectrum in excel and i need to make a baseline underneath this that follows the trends of the spectrum.
I know that fmincon works well for this problem because other people have uesd it, but I want to have the steps understood so I can have this data in excel format to go with a vba macro I've created.
This is what the explaination they give is:
x = fmincon(fun,x0,A,b) starts at x0 and attempts to find a minimizer x of the function described in fun subject to the linear inequalities A*x ≤ b. x0 can be a scalar, vector, or matrix.
How exactly does it ""attempt to find a minimizer"? is this a loop or what? and how would I put this into excel?
Any help is appreciated
