VBA dynamic model steam production by using sun radiation in Africa
Dear experts,
I've started an project in Africa to disinfect the ground with overheated steam. This means less risk of failure by growing there food.
This steam is heated by sun radiation. I’ve made a model in Excel and I want to calculate the amount of heating energy that can make the steam.
In this model I use one unknown factor and can solve this problem by using the solver.
The only big problem is that I wanted to have a macro, so I can calculate the amount of heating energy by using different sun radiation, outside temperature, inside water temperature and different sizes. If I want to use the solver I have to recalculate each row, this going to take a lot of time.
Please can you help me make an macro in VBA, I have already tried something but I think something is missing.
You can find my concept in the attachment.
With kind regards,
Mario van der Meer
| Attachment | Size |
|---|---|
| Bepaling warmteopbrengst van de Fresnellens.xls | 109 KB |
| Formula that needs an explanation.pdf | 50.06 KB |
We don't need to use solver
We don't need to use solver because we'll essentially be overriding it.. Solver looks for a single set solution by varying all permutations of inputs ... We want the full reference table and we can do this with code easily enough.
If you can supply the calculation formulas - I'll set you something up but I don't know much about thermodynamics LOL
Formula that needs an explanation
First of all, thank you very much for helping me, I really appreciate it!
The easiest and most effective way to explain the basics of the formula is by sending you an pdf file that I made.
The only problem is that I can't see where I can post an attachment. Do you know how? otherwise I can e-mail it perhaps?
With kind regards,
Mario
Sure - email me at
Sure - email me at AndrewLitchfield@Gmail.com