ࡱ > T n m n o p q r s t u = K L M N O f) w bjbj 8$ r r d $ $ $ $ $ 8 8 8 8 p 4 8 .Z 4 Y Y Y Y Y Y Y $ \ ^ v Y $ Y $ $ 4 Y R R R $ $ X R Y R R N P T 2 x F =R 0 X Y 0 .Z mR L 8_ 8_ ` T 8_ $ T 0 R Y Y .Z 8_ : QUESTION 1: Please provide all active Excel spreadsheets containing the workpapers for all SoCalGas /SDG&E witnesses that filed testimony in this proceeding, including but not limited to, the capital workpapers and O&M workpapers, the models used to generate the Revenue Requirements, and the Rate Models used. Excel spreadsheets should not contain hard-coded numbers but instead should have the formulas that were used to arrive at the calculations shown in the workpapers in support of the testimonies that will enable ORA to replicate the numbers. RESPONSE 1: SoCalGas and SDG&E object to this question on the grounds that it requests confidential and proprietary system information. It would create a risk to public safety to make this information public. Without waiving any of these objections, and subject thereto, SoCalGas and SDG&E respond as follows: Witness Buczkowski: Witness Chaudhury: Witness Mock: EMBED Excel.Sheet.12 EMBED Excel.Sheet.12 EMBED Excel.Sheet.12 Witness Musich: Witness Yee: EMBED Excel.Sheet.12 EMBED Excel.Sheet.12 Please see attached workpapers which are also posted on SoCalGas and SDG&Es websites at the links provided below. EMBED AcroExch.Document.7 EMBED AcroExch.Document.7 EMBED AcroExch.Document.7 EMBED AcroExch.Document.7 EMBED AcroExch.Document.7 HYPERLINK "http://www.socalgas.com/regulatory/A1312013.shtml" http://www.socalgas.com/regulatory/A1312013.shtml HYPERLINK "http://www.sdge.com/regulatory-filing/9631/application-southern-california-gas-company-and-san-diego-gas-electric" http://www.sdge.com/regulatory-filing/9631/application-southern-california-gas-company-and-san-diego-gas-electric Please find the attached revised study. Certain sensitive system information has been redacted per the objection above. EMBED AcroExch.Document.7 SAN DIEGO GAS & ELECTRIC COMPANY SOUTHERN CALIFORNIA GAS COMPANY NORTH-SOUTH PROJECT REVENUE REQUIREMENT (A.13-12-013) (1ST DATA REQUEST FROM OFFICE OF RATEPAYER ADVOCATES) ______________________________________________________________________ PAGE 1 [ f ( ) 5 6 b v ί}}ncQBn7nc h=X h=X CJ aJ j h=X h CJ UaJ #jW h=X h CJ UVaJ h=X h1 CJ aJ j h=X h1 CJ UaJ h=X h1 CJ OJ QJ ^J aJ h=X h=X CJ OJ QJ ^J aJ hY h1 5>*OJ QJ ^J hu hu CJ OJ QJ ^J aJ h CJ OJ QJ ^J aJ h hu CJ OJ QJ ^J aJ h hB_ CJ OJ QJ ^J aJ hY hY 5>*OJ QJ ^J ( ) 5 6 b c I J _ C d gdc3 gd=X gd1 d ^ gdu 7$ 8$ H$ gdu gdJ ( ) * Ǹ{m\QQ?0 j! h=X h=X CJ UaJ #jW h=X h=X CJ UVaJ h=X h1 CJ aJ h=X h1 CJ OJ QJ ^J aJ h0Tn CJ OJ QJ ^J aJ h=X h=X CJ OJ QJ ^J aJ jq h=X h CJ UaJ #jW h=X h CJ UVaJ h=X h CJ aJ j h=X h CJ UaJ h CJ aJ j h=X h1 CJ UaJ jA h=X h=X CJ UaJ #jW h=X h=X CJ UVaJ * + - . E F G H I J ; ˼ݠ{sh`UM jG h=X Uj3W h=X UVj? h=X Uj-W h=X UVj8 h=X UjW h=X UVh1 j h1 Uh1 CJ OJ QJ ^J aJ h=X h1 CJ OJ QJ ^J aJ h=X hUk CJ aJ j, h=X h=X CJ UaJ #jW h=X h=X CJ UVaJ h=X h1 CJ aJ h0Tn CJ aJ j h=X h1 CJ UaJ ; < = ? [ \ ] ^ _ ` a U V C D ` a 修rdr\XM jVW h=X UVhc3 j hc3 Uhc3 CJ OJ QJ ^J aJ hicH hc3 CJ OJ QJ ^J aJ hicH h1 >*B*CJ aJ ph hicH h1 CJ aJ j hicH h1 CJ UaJ hicH h1 CJ OJ QJ ^J aJ h1 CJ OJ QJ ^J aJ jW h=X UjDW h=X UVh1 j h1 UjKO h=X Uj>W h=X UV a b c d e g h j k m n p q ÷}m}bWI h$P hj 5OJ QJ ^J hu 5OJ QJ ^J h1 5OJ QJ ^J h 2 h 2 5H*OJ QJ ^J h 2 5OJ QJ ^J h'4 5OJ QJ ^J #hx hj 5CJ OJ QJ ^J aJ h#( 5OJ QJ hTs 5OJ QJ hTs hTs 5OJ QJ #h, h, 5CJ OJ QJ ^J aJ h j h Uh1 CJ OJ QJ ^J aJ j hc3 Uj^ h=X U d f g i j l m o p q g h t u v ) $$d %d &d 'd N O P Q a$gdnE $ ] ^ a$gdTs $a$gdTs $a$gdnE g i j p q r s t u v w ݽݰ h1 CJ OJ QJ ^J aJ h hf hj OJ QJ ^J !h 0J OJ QJ ^J mH nH uhf hj 0J OJ QJ ^J %j hf hj 0J OJ QJ U^J hj hnE 5OJ QJ ^J v w gd1 6 &P 1h:p'4 / =!"#$% A D d b c $ A ? ? 3 " ` ? " I "C˭'0? g D @=_ I "C˭'0? h C - xXyTU:j2