clear

capture log close

log using "$pathlog\16_Export Model MOE_$S_DATE.log",replace

use "L:\Vote Solar\Backup Materials\Data Output\21_all populations-export-covariates-weather.dta",clear

gen export_ratio=mean_exports/nameplatecapacity
replace export_ratio=1 if export_ratio>1 & export_ratio!=.
reg export_ratio month##hour weekend##hour i.residential i.sched_135  solar_rad clouds azimuth temp
predict stdp1, stdp
* daytime
save day_seall

* peak times, for avis comparison
keep if hour>11 & hour<15
gen MOE_rat= stdp1*2/ export_ratio
tabstat MOE_rat export_ratio, statistics( median mean n )

collapse (mean) MOE_rat 

export excel MOE_rat using "$pathexcelsurr\Exhibit 3-AJL.xlsx",sheetmodify sheet("Vote Solar")cell(A2),
putexcel set "$pathexcelsurr\Exhibit 3-AJL.xlsx",sheet("Vote Solar") modify
putexcel A1="Margin Percentage", bold

save summary_precision, replace
log close