User:Jdirkman
From REU@MU
Contents
Jesse Dirkman
Personal Info
Jesse Dirkman, an undergraduate student at Marquette University, is majoring in mathematics and sociology. She will be graduating in May 2013. Jesse will be working with Dr. Corliss in the GasDay lab, focusing on water demand prediction models.
Research Objectives and Milestones
Research Questions
- How can we predict [water usage?] What factors are important? What sort of model is a best fit?
- Data cleaning/data quality issues
- What could be the use of such predictions?
- How can we turn this into a business model/ something useful?
Milestones/Weekly Plan
Week 1:
- Orientation
- Read about forecasting
- MATLAB
- Machine Learning
- Develop Milestones/goals
Week 2:
- Learn MATLAB application to GasDay data
- Graphs from data (using MATLAB)
- Neural Networks
- PRESENTATION: What can we learn from WATER data?
- Water forecasting research
- Intro to paper, what are people doing,
Week 3:
- Begin water forecasting
- What is the water data we’re looking at?
- Look into H20 Score or similar businesses
- Where can we get data from?
- What do industrial and commercial customers want?
Week 4:
- Continue water forecasting research
- Water forecasting
- Work on paper
Week 5:
- Continue water forecasting research
- Water forecasting
- Work on paper
- Mini presentation (REU)
- GasDay Presentation
Week 6:
- Continue water forecasting research
- Water forecasting
- Work on paper
Week 7:
- Determine business plan/proposal
- Continue water forecasting research
- Water forecasting
- Work on paper
Week 8:
- Rough draft of paper
Week 9:
- Final edit of paper
- Forecasting and modeling
Week 10:
- Present a business plan/proposal utilizing water use forecasts
- Turn in paper
Weekly Log
Week I
Tuesday
- REU Orientation
- Campus Tour
- E-Limo Tour
Wednesday
- GasDay Orientation
- Attended GasDay Grad Student Presentations
- Library Resources Tour
Thursday
- MATLAB Tutorials
- Reading: Water Demand Forecasting Articles
- Talk: Good Research Practices
Friday
- Readings: Forecasting and Water Predictions
- Met with Dr. Corliss
- Created Milestones and Objectives
Week II
Monday
- GasDay Camp
- Met with Dr. Corliss, discussed neural networks
- Worked on presentation for Wednesday
Tuesday
- GasDay MatLab Tour
- Worked on presentation for Wednesday
- Worked on modelling gas data
- Read about water forecasting
Wednesday
- Worked on presentation
- Presented for GasDay lab
- Read Water Forecasting
Thursday
- Worked on preparing graphs for WaterTech meeting
- REU Working Lunch
- Read from Water Forecasting
- Read from Urban Water Demand Management and Planning
Friday
- GasDay Camp
- Met with WaterTech USA representatives re: water forecasting
Week III
Monday
- Read from Urban Water Demand Management and Planning
- Read from Water Forecasting
Tuesday
- Attended "Good Presentation vs. Good Paper" talk
- Read from Hybrid Water Demand Forecasting Model Associating Artificial Neural Network with Fourier Series.
- Met with Dr. Corliss
Wednesday
- Finished reading Hybrid Water Demand Forecasting Model Associating Artificial Neural Network with Fourier Series.
- Prepared WaterTech graphs
Thursday
- Attended MatLab Seminar
- REU Working Lunch
Friday
- Database Design workshop with Dr. Corliss
- Met with H2Oscore
Week IV
Monday
- H2Oscore staff meeting
- Data exploration with H2Oscore
- Met with Dr. Corliss and McGee Young
Tuesday
- Read A Model of Daily Municipal Water Use for Short-Term Forecasting
- Cleaning H2Oscore data
Wednesday
- MatLab coding and modelling of Monona Water Data
- Worked on REU Mini-Presentation
Thursday
- REU student lunch
- Cleaning H2Oscore data
Friday
- Met with Dr. Corliss
- Introduction to Bloomberg software
- Extracted daily temperature and precipitation readings from Bloomberg
Week V
Monday
- Created Mini Presentation
- Created graphs of Monona Water Usage
Tuesday
- Met with McGee Young
- Mini Presentations
Wednesday
- Meeting with Dr. Corliss
- Intro to LaTeX
Thursday
- Created model for fake water demand data, MatLab models
- Worked on LaTeX
- Met with Dr. Corliss
Friday
- Met with McGee Young
- Met with Dr. Corliss
- Attended Mike Ziwisky's thesis defense
- Attended Dr. Adam Welc's research presentation (Oracle Labs)
Week VI
Monday
- Attempted exporting water data files
- H2OScore weekly staff meeting
- Met with Dr. Corliss, discussed research poster format
- Met with McGee Young
Tuesday
- Worked on learning command prompts
- Read from Programming Perl (Wall, Christiansen and Schwartz)
- Perl tutorial
- Worked on creating/understanding unzip program
Wednesday Independence Day
Thursday
- REU Working Lunch
- Met with Dr. Corliss
- First steps in creating MySQL database
- Read from Handbook of Writing for the Mathematical Sciences (Nicholas J. Higham)
- Met with McGee Young
Friday
- Created main categories in MySQL database
Week VII
Monday
- H20Score Weekly Meeting
- Met with Dr. Corliss
- Installed MATLAB Database Toolbox, created MATLAB/MySQL connection
Tuesday
- Worked on MATLAB database program, insert function
- Met with Dr. Corliss
Wednesday
- Worked on programs to import .csv files into MySqL database (Weather, Whitewater, and Monona)
Thursday
- Finished program to import .csv files into MySQL database
- Created program to extract data from MySQL database
- Met with Dr. Corliss
Friday
- Created program to extract data from MySQL database
- Successfully inserted Monona data into MySQL database
WEEK VIII
Monday
- H2OScore Weekly Meeting
- Ran code to insert Whitewater data into MySQL
- MatLab troubleshooting
- Successfully inserted (a portion of) Whitewater data into database
Tuesday
- Continued inserting Whitewater data into MYSQL database
- Continued troubleshooting
- Read Negotiating everyday life: The role of energy and water consumption feedback
- Read A Model of Daily Municipal Water Use for Short-Term Forecasting
Wednesday
- Continued inserting Whitewater data into MySQL database
- Read Monitoring Gas and Water Consumption through ICTs for Improved User Awareness
- Worked on paper
- Attended GasDay Seminars
Thursday
- First graphs of water usage data
- Working lunch
- Preliminary poster work
- Worked on paper outline
Friday
- Worked on Poster
- Created graphs using one week of Whitewater data, analysis
- Met with McGee Young
- MatLab coding to automate process of filling in water usage, preparing for regression analysis
Week IX
Monday
- H2O Score Weekly Meeting
- Began filling water usage tables
- Worked on poster
Tuesday
- Worked on Poster
- Finished filling water usage tables
- Ran iterations of multiple linear regression
- Created graphs of water consumption by day of week
Wednesday
- Worked on Poster
- Created Presentation for GasDay
- Presented for GasDay
- Met with Dr. Corliss
Thursday
- Finish Poster
- Research for paper
- REU Working Lunch
- Met with Dr. Corliss
Friday
- Ran query for McGee Young
- Worked on research