this is a project that need to use Python, Spyder program to create.

i have included the 2 pictures and video how it looks like.

https://www.youtube.com/watch?v=waX0kR7hMpQ&feature=youtu.be

The project is s simplified model of a solar collector and battery bank to predict the adequacy of a system. Data from the National Solar Radistion Database should be read from http://rredc. nrel.gov/aolar/old-dataardb/1991-2010/ targza/ for a user selected location. Assignment Your program should include all of the required items listed below and st lesst one of the optional items. Due Date: Friday, May 5 10:00 PM Program Requirements The graphical user interface (using PyQt5) should include user input of the following editable Select station location; optional from a map Area and efficiency of solar cells Daily electric usage Battery capacity Start month Choice of 20 1-year runs or one 20-year run The data should be read from the National Solar Radiation Database for the years 1991-2010. Optional: data extracted to a temporary folder that is deleted upon exit. Optional: program searches folder to see if files slready exist, if so no files are downloaded if they are not present they are retrieved from the internet For every hour of every day the solar gain should be calculated from: gain global panel area efficiency The global" values given are for a horizontal surface. Optional: calculate the gain for panels tilted at an angle or optimally tracking the sun. For every hour of every day the battery level should be calculated from battery level gain usage previous battery level where usage is the amount of electricity used during the 1 hour period. The usage should not be averaged over all 24 hour. The battery level can never be greater than the capacity or less than zero. Optional: have user input for typical" usage pattern. Show a plot of the battery level vs. time Compute the number of consecutive hours below a particular percentage of the maximum battery level. Present this to the user in a "nice" format. Optional: write this data along with the test information to an Excel spreadsheet. General Instructions Your programs must include the following: Working code/program Well-documented code with sufficient comments that the grader can understand the logic of the program and the flow of the program Modular programming Document strings are to be used for all functional Do not use any of the following in your programs: Hardcoded user inputs "goto" statements The project is s simplified model of a solar collector and battery bank to predict the adequacy of a system. Data from the National Solar Radistion Database should be read from http://rredc. nrel.gov/aolar/old-dataardb/1991-2010/ targza/ for a user selected location. Assignment Your program should include all of the required items listed below and st lesst one of the optional items. Due Date: Friday, May 5 10:00 PM Program Requirements The graphical user interface (using PyQt5) should include user input of the following editable Select station location; optional from a map Area and efficiency of solar cells Daily electric usage Battery capacity Start month Choice of 20 1-year runs or one 20-year run The data should be read from the National Solar Radiation Database for the years 1991-2010. Optional: data extracted to a temporary folder that is deleted upon exit. Optional: program searches folder to see if files slready exist, if so no files are downloaded if they are not present they are retrieved from the internet For every hour of every day the solar gain should be calculated from: gain global panel area efficiency The global" values given are for a horizontal surface. Optional: calculate the gain for panels tilted at an angle or optimally tracking the sun. For every hour of every day the battery level should be calculated from battery level gain usage previous battery level where usage is the amount of electricity used during the 1 hour period. The usage should not be averaged over all 24 hour. The battery level can never be greater than the capacity or less than zero. Optional: have user input for typical" usage pattern. Show a plot of the battery level vs. time Compute the number of consecutive hours below a particular percentage of the maximum battery level. Present this to the user in a "nice" format. Optional: write this data along with the test information to an Excel spreadsheet. General Instructions Your programs must include the following: Working code/program Well-documented code with sufficient comments that the grader can understand the logic of the program and the flow of the program Modular programming Document strings are to be used for all functional Do not use any of the following in your programs: Hardcoded user inputs "goto" statements