Excel files to calculate solar energy systems

Job ID: 31099004

Budget: $30 – $250 USD

Hello..
I need excel files that calculate solar energy systems and analyze their results
1- Photovoltaic solar system PV
2- Thermal photovoltaic solar system PVT
3- Solar water heating system SWH
So that I put the value of consumption and the existing roof area, and the file provides me with the number of solar units, batteries, etc.

You must provide me the source and the references used and explain to me the equations used by the file through references
Because I will use the file for a purely scientific purpose.. I need to know all the information from where you got it
I attached illustration files as an example of what I need
====
It is possible to find on the Internet a ready-made file .... but it needs some modifications
To be delivered in short
Excel file for each system:
1- Photovoltaic solar system pv
2- Thermal photovoltaic solar system pvt
3- Solar water heating system swh

In addition to the references used ... and where did you get the file from and that the file be delivered in Arabic
====
If you are an electrical / energy / mechanical engineer and you can make these calculations
You can apply the arithmetic operations to the file ... provided that you attach a reference from where you got the equations
Explain the method of calculations

I NEED THESE FILES IN ARABIC LANGUAGE