I am currently working on a project regarding Optimisation for renewable energy and battery storage. I have basically completed the project in terms of parameters and formula’s within Excel and now it is just a case of changing variables such as ‘Number of wind turbines’, “Number of Solar Panels”, “Battery Capacity” etc to find the optimum solution. Currently I can run the Excel Solver and obtain this but I need to write a similar more streamlined process into the Excel VBA which is where my abilities are failing me. Any help would be most welcome.
- I have done similar optimization on finding a the right wiremodel based on each room, resistance, amp, volt threshold level from available wire model.
- To identify each wire model certain calculations would be done, if for the total identified wires the thresholds dont meet, then the iteration conitnues, until it finds a solution.
- In this case optimization based on renewable energy and batter storages and based on certain criteria including the number of wind turbines, solar panels, battery capacity can be looked into and identify the optimized value for turbine, panels.
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells