1 Computation Notes

Please review the following notes from the GEP 202/GEP 280 class.

Based on that reading, answer the questions.

What experience do you have performing mathematics on a computer?
What skills are you interested in developing?

2 Timeseries to energy quantity

Imagine you have a time series of current and voltage. That means you have one graph with voltage on the y-axis and time on the x-axis. The second graph has current on the y-axis and time on the x-axis.

Describe how you would find the current delivered.
Describe how you would find the charge delivered.
Describe how you would find the power delivered
Describe how you would find the energy delivered

3 Spreadsheet Organization

Review the notes from this lesson by Data Carpentry on spreadsheet organization.

How much experience do you have with spreadsheets?
Have you encountered any of these issues?
What pitfall seems most important to avoid?

4 Time Series Data

You have the following current and voltages measured across an electric load.

time (s)	current (A)	voltage (V)
0	10	50
1	20	50
2	30	50
3	40	50

Assume that the current and voltage varies smoothly in-between our measurements.

Draw these points out on a graph.
What is the power delivered at time equals zero seconds?
What is the power delivered at time equals three seconds?
What does the area under the current curve represent?

5 PVWatts Upload

Run a PVWatts estimation for the SSU zip code (94928) and the default values at the PVWatts website.

Download the hourly CSV file to your local computer
Upload this CSV file to Google Sheets
Open the file using Google Sheets
Submit a screenshot of the opened file in Google Sheets

6 PVWatts Monthly Energy

Run a PVWatts estimation for the HSU zip code (95521) and the default values at the PVWatts website.

Compute the total and monthly energy using areas, sums, and/or pivot tables
Upload a screenshot of your power and energy columns
Upload a screenshot of your pivot table
Write a short description of what you learned in this exercise

7 Time of Use Plans

Search for the announcements by PG&E and SCP on their rate plans and answer the following.

What are the peak and off peak times for each of the following Time-Of-Use (TOU) plans?

PG&E E-TOU-C plan
PG&E E-TOU-D plan
Sonoma Clean Power

8 PVWatts Time of Use Calculation

Run a PVWatts estimation for the SSU zip code (94928) and the default values at the PVWatts website.

Upload the CSV to google docs
Perform a time-of-use using E-TOU-C 4-9pm every day
Use a peak price of 0.256 USD/kWh and an off-peak of 0.156 USD/kWh
Attach a screenshot showing your columns (use show formulas in the view menu)
Briefly explain how your performed the computation

9 PVWatts Try Jupyter Preparation

Upload your data:

Navigate to the Try Jupyter website and click on the JupyterLab button.
You should see a window with a file browser on the left and a document window on the right.
Drag and drop a PV Watts CSV file on the file browser.
Double click the CSV file in the file browser, it should bring up a window with the CSV contents

Prepare for analysis

Create a python notebook by clicking the + icon above the file browser then click the Python notebook icon in the upper left.
Cut and paste the following into the first cell.

import pandas as pd
pd.read_csv('pvwatts_hourly.csv', skiprows=31)

Press the “play” button to run the cell. You should see a preview with a matrix of data.
If you make it to this point, post a screenshot of the data matrix.
If you encounter a problem, post a screenshot of your error message.

10 Excel Conditionals

Read through the tutorials on the IF and SUMIF spreadsheet functions.

https://www.w3schools.com/googlesheets/google_sheets_sumif.phpLinks to an external site.

https://www.w3schools.com/googlesheets/google_sheets_if.phpLinks to an external site.

Have you used these before?
How might you use these to calculate the compensation a solar homeowner would get if the price of electricity varies throughout the day?