{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["File","Purpose"]
["T&D Factors for Updating Hourly Costs.xlsx","Determine T&D Capacity costs at the secondary voltage level by system or climate zone (PG&E) including losses.  Compare the updated T&D capacity costs to the 2004 adopted costs to determine scale factors to be used to adjust the hourly allocated T&D capacity costs from the 2004 adopted values up to the updated levels."]
["PRM_Calculator_6-30-11_CAISO Modified for EE.xlsm","Determines the resource balance year based on IOU LTPP filing, and before load reductions from DR and incremental EE and behind the meter CHP.  Also based on 10,000 MW of imports rather than CPUC recommended 17,000 MW."]
["Statewide Average TDV TD update 2010.xls","Calculates T&D avoided costs from Utility filings"]
["gasModel9_6-30-11.xlsx","Calculates delivered commodity and T&D gas avoided costs by service territory.  Uses avoided gas commodity cost input from the DER Model"]
["PG&EGas_6-30-11.xls","Converts gas avoided costs from the gasModel9_6-30011.xlsx model into the format used in the E3 Calculator"]
["SCEGas_6-30-11.xls","Converts gas avoided costs from the gasModel9_6-30011.xlsx model into the format used in the E3 Calculator"]
["SDG&EGas_6-30-11.xls","Converts gas avoided costs from the gasModel9_6-30011.xlsx model into the format used in the E3 Calculator"]
["DERAvoidedCostModel_v3.0_2011 v4b CA Avg.xlsm","Main Avoided Cost calculation model for generation-related costs.  Not used for T&D because the allocation factors in the model are based on 2010 weather, whereas for EE TMY-based allocators are needed.  "]
["Daylight Savings DEER Adjustment.xlsx","Explanation of shifting of DEER data to match contiguous 8760 avoided cost data.  Hour 2307 deleted, and row inserted after original hour 7179.  Fill in with average of surrounding hours."]
[]
["Pre-processing files (Examples shown for PG&E)"]
["File","Purpose"]
["DEER2011-HrlyProfiles-PGE-v2-Shifted.xls","DEER shapes shifted for daylight savings"]
["PG&E_HourlyCosts_2010_CA_Avg.xlsx","Hourly generation (based on 2010 markets) and T&D avoided costs (allocations based on TMY)"]
["PG&E_PreProc 4-11-2012.xlsm","Calculate benefits per annual kWh for each DEER measure"]
["PG&EComCalcTOU 8-3-2011.xls","Calculate benefits  per annual kWh for each TOU-based commercial measure"]
["PG&ETesCalcTOU 8-3-2011.xls","Calculate benefits  per annual kWh for each TOU-based residential measure"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}