General Mathematics

    

Five Examples on Using Spreadsheet to Solve Engineering and Mathematical Problems

Authors: Victor Christianto, Florentin Smarandache

Computer spreadsheet has been commonly used in the past few decades into very practical mathematical and problem solving tool. Here we discuss 5 examples on using spreadsheet to solve engineering and mathematical problems. We recall our story in using Lotus 123 and Excel spreadsheet software since early 90s until recently. In last example we discuss more specifically on using excel spreadsheet to optimize the use of wind energy turbine in combination with solar photovoltaic. It is known in literature there are many discussions on linear programming for various cases; however there is only few discussion to take into account the uncertainties involved in the power production of PV/Wind system. In this paper, we consider integer linear programming by considering bi-level values as suggested by Pramanik and Pratim Dey. The purpose of this study is to show that it is possible to consider uncertainties in energy production in the linear programming model.

Comments: 12 Pages. Octogon Mathematical Magazine, Sacele, Romania, Vol. 29, No. 1, 362-371, April 2021

Download: PDF

Submission history

[v1] 2021-01-06 13:17:33
[v2] 2021-01-13 08:15:19
[v3] 2021-01-21 04:40:17
[v4] 2021-10-28 20:16:54

Unique-IP document downloads: 716 times

Vixra.org is a pre-print repository rather than a journal. Articles hosted may not yet have been verified by peer-review and should be treated as preliminary. In particular, anything that appears to include financial or legal advice or proposed medical treatments should be treated with due caution. Vixra.org will not be responsible for any consequences of actions that result from any form of use of any documents on this website.

Add your own feedback and questions here:
You are equally welcome to be positive or negative about any paper but please be polite. If you are being critical you must mention at least one specific error, otherwise your comment will be deleted as unhelpful.

comments powered by Disqus