Solver in Matlab (like Solver in Excel)

Greetings Friends,

I am working a solar+wind power systems as a project. I have come to a point where I have to optimize the Area of Solar farm and Area of wind farm.

Variable list:

1. Wind_farm_area
2. Solar_farm_area
3. Combined_area=Wind_farm_area+Solar_farm_area;
4. Total_Energy_Production
5. Continuous_Loads %continuous for 8760 hours(1 year)
6. Day_load_Defecit
7. Night_Load_Defecit

I have close to 800 lines of code

PROBLEM:

I have to optimize

1. Least wind area to have zero Night_load_defecit
2. Least Combined area to have at least 5-10 % more than total_integrated_continuous load.

Usually in Excel,We use solver, by constricting the difference in night procuction to night load = 0 and solve it.Is there anything like that in Matlab. Forgive me if I have causes any confusion in my way of questioning.

It would be very helpful if anyone could help me with my problem.

[darova]

You didn't provide enough information. Can you please explain how those 7 variables are related? Please attach the data also

Answer 1

[venkat siddhartha rama]

In Excel,When all the cells are given their values and formulas for calculations, By using Solver I can select the cell having value (Day_load_Defecit= Load(at day)-Energy Produced(at day);) as my Objective cell, set value to be ZERO by changing variables of Solar_farm_area and Wind_farm_area .By using this method Solver automatically changes the values of areas to optimal level to satisfy the contion.

Actrually,My program has about 800 lines, thats the reason I couldn't post it. I Declare tha values of Wind_farm_area=1.6174E05; Solar_farm_area=16000; Combined_area=Wind_farm_area+Solar_farm_area; It does so many calcualtions to calculate Total_Energy_Production. Load details are read from several excel files. Program actually takes more than a min to do all the calculations.

Its like running the program for several iterations for various values of Solar_farm_area and Wind_farm_area and program would find the right values of areas, so that combined energy produced is with some Percent greater than the total_Integrated_load.

(There are actually more than 50 variables that interconnect the Wind_farm_area and Solar_farm_area with Total_Energy_Produced.Continuous_loads (Continuous for 8760 hours(1 year)).

Day_load_Defecit= Load(at day)-Energy Produced(at day);

%These are values calculated every hour of day with energy produced from initial values of wind and solar farm areas given.

and Night_Load_Defecit= Load(at Night)-Energy produced(at night);

%These are values calculated every hour of night with energy produced from initial values of wind and solar farm areas given.

[darova]

Use can use this button to attach your code