Notes
| INSTRUCTIONS Download GiraudetHoudeMaher2018.zip and unzip. The unzipped file contains the following folder structure (assuming files unzipped to a "C:drive"): C:\GiraudetHoudeMaher2018 .do files are at the level of the main directory C:\GiraudetHoudeMaher2018\data data are located in a "data" folder (homeusage.dta, homes.dta, retrofits.dta) source files (with readme file for each) are in separate folders DO FILES (master.do, 1_retrofit.do, 2_homeusage.do, tables3&4.do, tables1&2.do) master.do: runs the other four .do files in sequence to reproduce the data (using source data inputs) and reproduces results and summary statistics presented in tables 1, 2, 3, & 4 of the paper. 1_retrofit.do : builds a dataset of participants in each of GRU's retrofit rebate programs. This file needs should be run first. 2_homeuseage.do : creates two data sets: homes.dta and homeusage.dta - with the monthly billing data from 2000-2015 for all GRU customers. This .do file aggregates the raw data files, merges with retrofit.dta (GRU rebate program participants) using addresses, and creates variables used for the empirical analysis. tables1&2.do : reproduces summary statistics in tables 1 & table 2. (Note: code outputs table 2 in two parts: one spreadsheet with cols 1-6 & col 10 , and a second spreadsheet with cols 7-9.) tables3&4.do : reproduces results presented in tables 3 and table 4 . .DTA (DATA) FILES (homesusage.dta, homes.dta, retrofits.dta) homesusage.dta : This data reproduces all results using tables3&4.do and tables1&2.do. The data can be reproduced from source files using homeusage.do. Data includes monthly electiricty and natural gas billing data from 2000 - 2015 for all GRU customers in Gainesville, FL. homes.dta : An intermediate dataset used to link merge homeusage.dta and retrofits.dta. retrofits.dta: Data with information on all program participants for all GRU rebate programs. The data can be reproduced from source files using homeusage.do. SOURCE DATA homes (folder) : folder contains source data on house characteristics downloaded from gainsvillegreen.com. These are aggregated into a single .DTA stata file called homes.dta by running "homeusage.do" homusage (folder): folder contains source data on monthly electricity and natural gas energy consumption downloaded from www.gainsvillegreen.com. These are aggregated into a single .DTA stata file called homesusage.dta by running "homeusage.do" retrofits (folder) : folder contains separate spreadsheets containing information on all of GRU's conservation incentive programs. There are combined into a single .DTA file called retrofits.dta by runing "retrofit.do" NOTES Data is in a .ZIP file (uncompressed files exceeded upload limits). Use of another directory will require changing the "$root" global macro at the begining of .do files to match the new directory filepath (default directory is "C:\GiraudetHoudeMaher2018") Table 2 uses the tabout .ado package (the command -ssc install tabout- is included in the code, however, this requires an internet connection in install). |