{"text_format":"1","workbook":"xlsx","n_sheets":43,"sheets":["Ex 1 HDD","Exhibit 1.1","Exhibit 1.2","Exhibit 1.3","Ex 2 Clay Basin","Ex 2 Aquifers","Ex 2 Spire Storage West","Exhibit 2.1","Exhibit 2.2","Exhibit 2.3","Exhibit 2.4","Exhibit 2.5","Exhibit 2.6","Exhibit Firm Sales Volume","Worksheet","Exhibit 3.1","Exhibit 3.2","Exhibit 3.3","Exhibit 3.4","Ex 4 Purchase Gas","Exhibit 4.1","Exhibit 4.2","Exhibit 4.3","Ex 5 Purchase Gas Cost","Exhibit 5.1","Exhibit 5.2","Exhibit 5.3","Ex 6 Purch Gas Unit Cost","Exhibit 6.1","Exhibit 6.2","Ex 7 Co. Owned Gas","Exhibit 7.1","Exhibit 7.2","Exhibit 7.3","Ex 8 New Drill","Exhibit 8.1","Exhibit 8.2","Exhibit 8.3","Normal Purchase %","IRP Pruch Cover Sheet","Shut-In","Deleted Exhibit 2.5","Deleted Exhibit 2.6"],"not_rendered":{"charts":28,"images":0,"macros":1,"external_links":11,"defined_names":1376,"comments":3,"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":"Ex 1 HDD","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5],[1,8,1,9],[26,0,26,6],[4,0,4,6]]}
["Heating Degree Days",null,null,null,null,null,"Docket",null,"Dominion Energy Utah"]
["Source: Use data from cdxr01",null,null,null,null,null,null,null,"Docket No. 19-057-01"]
[null,null,null,null,null,null,null,null,"DEU Variance Exhibit"]
[]
[]
[]
["Month/Year","Actual","IRP Forecast (Normal)",null,null,"Actual","IRP Forecast (Normal)"]
["2019-06-01",33,46.17,{"$f":"B8-C8","v":-13.170000000000002},null,{"$f":"B8","v":33},{"$f":"C8","v":46.17}]
["2019-07-01",0,2.08,{"$f":"B9-C9","v":-2.08},null,{"$f":"B9+F8","v":33},{"$f":"C9+G8","v":48.25}]
["2019-08-01",0,2.2999999999999998,-2.2999999999999998,null,33,{"$f":"C10+G9","v":50.55}]
["2019-09-01",null,79.83,-79.83,null,33,130.38]
["2019-10-01",null,374.12,-374.12,null,33,504.5]
["2019-11-01",null,744.18,-744.18,null,33,1248.6799999999998]
["2019-12-01",null,1070.32,-1070.32,null,33,2319]
["2020-01-01",null,1096.1500000000001,-1096.1500000000001,null,33,3415.15]
["2020-02-01",null,860,-860,null,33,4275.1499999999996]
["2020-03-01",null,657.78,-657.78,null,33,4932.9299999999994]
["2020-04-01",null,431.82,-431.82,null,33,5364.7499999999991]
["2020-05-01",null,205.37,-205.37,null,33,5570.119999999999]
[null,{"$f":"SUM(B8:B19)","v":33},{"$f":"SUM(C8:C19)","v":5570.119999999999},{"$f":"SUM(D8:D19)","v":-5537.119999999999}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"4.08-3.28","v":0.80000000000000027},{"$f":"3.86-3.59","v":0.27}]

{"sheet":"Exhibit 1.1","index":1,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Ex 1 HDD'!I3","v":"DEU Variance Exhibit"},{"$f":"'Ex 1 HDD'!I2","v":"Docket No. 19-057-01"},{"$f":"'Ex 1 HDD'!I1","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001]

{"sheet":"Exhibit 1.2","index":2,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Ex 1 HDD'!I3","v":"DEU Variance Exhibit"},{"$f":"'Ex 1 HDD'!I2","v":"Docket No. 19-057-01"},{"$f":"'Ex 1 HDD'!I1","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2]

{"sheet":"Exhibit 1.3","index":3,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Ex 1 HDD'!I3","v":"DEU Variance Exhibit"},{"$f":"'Ex 1 HDD'!I2","v":"Docket No. 19-057-01"},{"$f":"'Ex 1 HDD'!I1","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3]

{"sheet":"Ex 2 Clay Basin","index":4,"n_rows":76,"n_cols":21,"rows_kept":76,"cut":false,"hidden":false,"merged":[[3,0,3,8],[0,0,0,8],[4,0,4,8],[1,0,1,4],[2,0,2,5]]}
["Clay Basin Ending Inventory (MDths)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plan Year 1",1106]
[null,null,null,null,null,null,null,null,null,null,"Month/Year","Month","Inj","With","Total"]
["Month/Year","Actual","IRP Forecast (Normal)",null,"Actual","Actual/1000",null,"Actual","Normal",null,null,null,null,null,2000]
["2019-06-01",{"$f":"F8","v":3477.596},{"$f":"O8","v":4700},{"$f":"B8-C8","v":-1222.404},3477596,{"$f":"E8/1000","v":3477.596},null,{"$f":"F8","v":3477.596},{"$f":"C8","v":4700},null,{"$f":"A8","v":"2019-06-01"},{"$f":"O7","v":2000},2700,0,{"$f":"L8+M8-N8","v":4700},null,123.428,null,{"$f":"M8/30","v":90},null,{"$f":"(M8-N8)/30","v":90}]
["2019-07-01",{"$f":"F9","v":6286.77},{"$f":"O9","v":7474.17},-1187.3999999999996,6286770,{"$f":"E9/1000","v":6286.77},null,{"$f":"H8+F9","v":9764.366},{"$f":"C9+I8","v":12174.17},null,{"$f":"A9","v":"2019-07-01"},{"$f":"O8","v":4700},2774.17,0,7474.17,null,66.779499999999999,null,{"$f":"M9/31","v":89.489354838709673},null,{"$f":"(M9-N9)/31","v":89.489354838709673}]
["2019-08-01",{"$f":"F10","v":8985.4959999999992},9954.17,-968.67400000000089,8985496,8985.4959999999992,null,{"$f":"H9+F10","v":18749.862000000001},22128.34,null,"2019-08-01",{"$f":"O9","v":7474.17},2480,0,9954.17,null,19.965599999999998,null,{"$f":"M10/31","v":80},null,{"$f":"(M10-N10)/31","v":80}]
["2019-09-01",{"$f":"F11","v":0},11187.6,-11187.6,null,0,null,18749.862000000001,33315.94,null,"2019-09-01",9954.17,1233.43,0,11187.6,null,0,null,39.788064516129033,null,39.788064516129033]
["2019-10-01",0,13000.005000000001,-13000.005000000001,null,0,null,18749.862000000001,46315.945000000007,null,"2019-10-01",11187.6,1812.405,0,13000.005000000001,null,0,null,58.464677419354835,null,58.464677419354835]
["2019-11-01",0,10542.677000000001,-10542.677000000001,null,0,null,18749.862000000001,56858.62200000001,null,"2019-11-01",13000.005000000001,0,2457.328,10542.677000000001,null,0,null,0,null,-79.268645161290323]
["2019-12-01",0,7100.6310000000012,-7100.6310000000012,null,0,null,18749.862000000001,63959.253000000012,null,"2019-12-01",10542.677000000001,0,3442.0460000000003,7100.6310000000012,null,3417.48,null,0,null,-111.03374193548387]
["2020-01-01",0,{"$f":"O15","v":3690.5810000000015},-3690.5810000000015,null,0,null,18749.862000000001,67649.834000000017,null,"2020-01-01",7100.6310000000012,0,3410.0499999999997,3690.5810000000015,null,5311.68,null,0,null,-110.00161290322579]
["2020-02-01",0,{"$f":"O16","v":500.53500000000122},null,null,0,null,18749.862000000001,68150.369000000021,null,"2020-02-01",3690.5810000000015,0,3190.0460000000003,500.53500000000122,null,3252.24,null,0,null,-102.90470967741936]
["2020-03-01",0,{"$f":"O17","v":500.53500000000122},null,null,0,null,18749.862000000001,68650.904000000024,null,"2020-03-01",500.53500000000122,0,0,500.53500000000122,null,0,null,0,null,0]
["2020-04-01",{"$f":"F18","v":0},{"$f":"O18","v":500.53500000000122},null,null,0,null,18749.862000000001,69151.439000000028,null,"2020-04-01",500.53500000000122,0,0,500.53500000000122,null,0,null,0,null,0]
["2020-05-01",{"$f":"F19","v":0},{"$f":"O19","v":1912.8870000000011},null,null,0,null,18749.862000000001,71064.32600000003,null,"2020-05-01",500.53500000000122,1412.3519999999999,0,1912.8870000000011,null,0,null,45.559741935483864,null,45.559741935483864]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":12412.357},{"$f":"SUM(N8:N19)","v":12499.47},{"$f":"SUM(N8:N19)","v":12499.47}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"O15","v":3690.5810000000015},null,null,{"$f":"M18/30","v":0}]
[null,null,null,null,null,null,null,1,{"$f":"N16/29","v":110.00158620689656},{"$f":"J25-$I$26","v":3580.5794137931048}]
[null,null,null,null,null,null,null,2,null,{"$f":"J26-$I$26","v":3470.5778275862081}]
[null,null,null,null,null,null,null,3,null,3360.5762413793113]
[null,null,null,null,null,null,null,4,null,3250.5746551724146]
[null,null,null,null,null,null,null,5,null,3140.5730689655179]
[null,null,null,null,null,null,null,6,null,3030.5714827586212]
[null,null,null,null,null,null,null,7,null,2920.5698965517245]
[null,null,null,null,null,null,null,8,null,2810.5683103448278]
[null,null,null,null,null,null,null,9,null,2700.566724137931]
[null,null,null,null,null,null,null,10,null,2590.5651379310343]
[null,null,null,null,null,null,null,11,null,2480.5635517241376]
[null,null,null,null,null,null,null,12,null,2370.5619655172409]
[null,null,null,null,null,null,null,13,null,2260.5603793103442]
[null,null,null,null,null,null,null,14,null,2150.5587931034474]
[null,null,null,null,null,null,null,15,null,2040.557206896551]
[null,null,null,null,null,null,null,16,null,{"$f":"J40-$I$26","v":1930.5556206896545}]
[null,null,null,null,null,null,null,17,null,1820.554034482758]
[null,5626242,8026685,10622439,12607382,null,null,18,null,1710.5524482758615]
[null,null,null,null,12434437,null,null,19,null,1600.550862068965]
[null,null,null,null,10491542,null,null,20,null,1490.5492758620685]
[null,null,null,null,null,null,null,21,null,1380.547689655172]
[null,null,null,null,null,null,null,22,null,1270.5461034482755]
[null,null,null,null,null,null,null,23,null,1160.544517241379]
[null,13419,null,null,null,null,null,24,null,1050.5429310344825]
[null,0.2276,null,null,null,null,null,25,null,940.54134482758593]
[null,{"$f":"B49*B50","v":3054.1644000000001},null,null,null,null,null,26,null,830.53975862068933]
[null,null,null,null,null,null,null,27,null,720.53817241379272]
[null,null,null,null,null,null,null,28,null,610.53658620689612]
[null,null,null,null,null,null,null,29,null,500.53499999999957]
[null,null,null,null,null,null,null,30]
[]
[]
[null,null,null,null,null,"June","July","August","September","October","November","December","January","February","March","April","May"]
[null,null,null,null,null,4587175,7350188,10347695,12594397,12186418,{"$f":"E13","v":0},{"$f":"E14","v":0},{"$f":"E15","v":0},{"$f":"E16","v":0}]
[null,null,null,null,0.44444440000000002,{"$f":"$E60*F$59/1000","v":2038.7442405700001},{"$f":"$E60*G$59/1000","v":3266.7498955472001},4598.975095658001,5597.5092180268002,5416.1852361592,0,0,0,0]
[null,null,null,null,0.27777780000000002,{"$f":"$E61*F$59/1000","v":1274.2153797150002},2041.7190522264002,2874.3599521710003,3498.4438909866003,3385.1163819204003,0,0,0,0]
[null,null,null,null,0.27777780000000002,1274.2153797150002,2041.7190522264002,2874.3599521710003,3498.4438909866003,3385.1163819204003,0,0,0,0]
[null,null,null,null,{"$f":"SUM(E60:E62)","v":1},{"$f":"SUM(F60:F62)","v":4587.1750000000002},{"$f":"SUM(G60:G62)","v":7350.1880000000001},10347.695000000002,12594.397000000001,12186.418000000001,0,0,0,0]
[]
[null,null,null,null,null,13419]
[null,null,null,null,null,{"$f":"F60/$F$65","v":0.15192966991355542},0.24344212650325658,0.3427211487933528,0.4171331111131083,0.40362063016314181,0,0,0,0]
[null,null,null,null,null,{"$f":"F61/$F$65","v":9.4956060788061722E-2},0.15215135645177735,0.21420075655197857,0.26070824137317239,0.25226293925928911,0,0,0,0]
[null,null,null,null,null,{"$f":"F62/$F$65","v":9.4956060788061722E-2},0.15215135645177735,0.21420075655197857,0.26070824137317239,0.25226293925928911,0,0,0,0]
[null,null,null,null,null,{"$f":"F63/$F$65","v":0.3418417914896788},0.54774483940681129,0.77112266189730994,0.93854959385945302,0.90814650868172009,0,0,0,0]
[]
[]
[null,null,null,null,null,13419]
[null,null,null,null,null,{"$f":"F60/$F$65*100","v":15.192966991355542},{"$f":"G60/$F$65*100","v":24.344212650325659},34.272114879335277,41.71331111131083,40.362063016314181,0,0,0,0]
[null,null,null,null,null,{"$f":"F61/$F$65*100","v":9.4956060788061727},15.215135645177735,21.420075655197856,26.070824137317238,25.226293925928911,0,0,0,0]
[null,null,null,null,null,{"$f":"F62/$F$65*100","v":9.4956060788061727},15.215135645177735,21.420075655197856,26.070824137317238,25.226293925928911,0,0,0,0]
[null,null,null,null,null,{"$f":"F70/$F$65","v":0},0,0,0,0,0,0,0,0]

{"sheet":"Ex 2 Aquifers","index":5,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[[31,0,31,11],[2,0,2,14],[1,0,1,14],[3,0,3,9]]}
["Total Aquifer Storage Ending Inventory (MDths)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1082,1106]
[]
[null,null,null,null,null,null,null,1.0549999999999999,null,null,null,null,"Month/Year","Month","Inj","With","Total"]
["Month/Year","Actual","IRP Forecast (Normal)",null,"Actual","IRP Forecast (Normal)",null,"MCF","DTH","MDTH",null,null,null,null,null,null,833,null,null,null,497.53800000000001]
[{"$f":"'Ex 1 HDD'!$A$8","v":"2019-06-01"},{"$f":"J8","v":492.15600000000001},{"$f":"Q8","v":833},{"$f":"B8-C8","v":-340.84399999999999},{"$f":"B8","v":492.15600000000001},{"$f":"C8","v":833},null,{"$f":"I8/$H$6","v":466498.57819905214},492156,{"$f":"I8/1000","v":492.15600000000001},null,null,{"$f":"A8","v":"2019-06-01"},{"$f":"Q7","v":833},0,0,{"$f":"N8+O8-P8","v":833},null,0,null,365]
[{"$f":"'Ex 1 HDD'!$A$9","v":"2019-07-01"},{"$f":"J9","v":611.73900000000003},{"$f":"Q9","v":833},{"$f":"B9-C9","v":-221.26099999999997},{"$f":"B9+E8","v":1103.895},{"$f":"C9+F8","v":1666},null,{"$f":"I9/$H$6","v":579847.3933649289},611739,{"$f":"I9/1000","v":611.73900000000003},null,null,{"$f":"A9","v":"2019-07-01"},{"$f":"Q8","v":833},0,0,{"$f":"N9+O9-P9","v":833},null,0,null,12]
[{"$f":"'Ex 1 HDD'!$A$10","v":"2019-08-01"},{"$f":"J10","v":606.92200000000003},833,{"$f":"B10-C10","v":-226.07799999999997},{"$f":"B10+E9","v":1710.817},2499,null,575281.51658767776,606922,606.92200000000003,null,null,"2019-08-01",{"$f":"Q9","v":833},0,0,833,null,0,null,{"$f":"SUM(U7:U9)","v":874.53800000000001}]
[{"$f":"'Ex 1 HDD'!$A$11","v":"2019-09-01"},{"$f":"J11","v":0},915.58600000000001,{"$f":"B11-C11","v":-915.58600000000001},{"$f":"B11+E10","v":1710.817},3414.5860000000002,null,0,null,0,null,null,"2019-09-01",833,82.586000000000013,0,{"$f":"N11+O11-P11","v":915.58600000000001},null,0]
[{"$f":"'Ex 1 HDD'!$A12","v":"2019-10-01"},0,1801.5520000000001,-1801.5520000000001,1710.817,5216.1380000000008,null,0,null,0,null,null,"2019-10-01",915.58600000000001,885.96600000000001,0,{"$f":"N12+O12-P12","v":1801.5520000000001},null,0]
[{"$f":"'Ex 1 HDD'!$A13","v":"2019-11-01"},0,1928.3380000000002,-1928.3380000000002,1710.817,7144.4760000000006,null,0,null,0,null,null,"2019-11-01",1801.5520000000001,126.786,0,{"$f":"N13+O13-P13","v":1928.3380000000002},null,0]
[{"$f":"'Ex 1 HDD'!$A14","v":"2019-12-01"},0,1928.3380000000002,-1928.3380000000002,1710.817,9072.8140000000003,null,0,null,0,null,null,"2019-12-01",1928.3380000000002,0,0,{"$f":"N14+O14-P14","v":1928.3380000000002},null,0]
[{"$f":"'Ex 1 HDD'!$A15","v":"2020-01-01"},0,1744.3150000000003,-1744.3150000000003,1710.817,10817.129000000001,null,0,null,0,null,null,"2020-01-01",1928.3380000000002,0,184.023,1744.3150000000003,null,143.71]
[{"$f":"'Ex 1 HDD'!$A16","v":"2020-02-01"},0,1744.3150000000003,-1744.3150000000003,1710.817,12561.444000000001,null,0,null,{"$f":"I16/1000","v":0},null,null,"2020-02-01",1744.3150000000003,0,0,1744.3150000000003,null,0]
[{"$f":"'Ex 1 HDD'!$A17","v":"2020-03-01"},0,822.4150000000003,-822.4150000000003,1710.817,13383.859000000002,null,0,null,{"$f":"I17/1000","v":0},null,null,"2020-03-01",1744.3150000000003,0,921.9,822.4150000000003,null,0]
[{"$f":"'Ex 1 HDD'!$A18","v":"2020-04-01"},0,822.4150000000003,-822.4150000000003,1710.817,14206.274000000003,null,0,null,{"$f":"I18/1000","v":0},null,null,"2020-04-01",822.4150000000003,0,0,822.4150000000003,null,0]
[{"$f":"'Ex 1 HDD'!$A19","v":"2020-05-01"},0,822.4150000000003,-822.4150000000003,1710.817,15028.689000000004,null,0,null,{"$f":"I19/1000","v":0},null,null,"2020-05-01",822.4150000000003,0,0,822.4150000000003,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O8:O19)","v":1095.338},{"$f":"SUM(P8:P19)","v":1105.923}]
[]
[null,{"$f":"SUM(B14:B16)","v":0},{"$f":"SUM(C14:C16)","v":5416.9680000000008},null,null,null,null,5,{"$f":"H22*$H$6","v":5.2749999999999995},null,null,null,null,null,"Inj","With"]
[null,null,null,null,null,null,null,6,{"$f":"H23*$H$6","v":6.33},null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,7,{"$f":"H24*$H$6","v":7.3849999999999998},null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,8,{"$f":"H25*$H$6","v":8.44},null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,154.24600000000001,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,331.74400000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,238.15100000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,154.24600000000001,569.89499999999998]
["chalk",252153,252153,null,null,null,null,"Second",null,"First"]
["coal",648967,648967,null,null,null,null,1761005.0485872477,null,1761005.0485872477]
["leroy",774377,774377,null,null,null,null,1423780.0485872515,null,1423780.0485872515]
[null,{"$f":"SUM(B36:B38)","v":1675497},{"$f":"SUM(C36:C38)","v":1675497},null,null,null,null,851240.04858725052,null,851240.04858725052]
[null,null,null,null,null,null,null,1009513.0485872505,null,1009513.0485872505]
[null,null,null,null,null,null,null,750042.04858725145,null,750042.04858725145]
[null,null,null,null,null,"June",null,741193.04858725145,null,741193.04858725145]
[null,null,null,null,null,"July",null,742210.04858725145,null,742210.04858725145]
[null,null,null,null,null,"August",null,733274.04858724773,null,733274.04858724773]
[null,null,null,null,null,"September",null,779680.04858724773,null,824078.04858724773,null,{"$f":"J45-H45","v":44398}]
[null,null,null,null,null,"October",null,1488952.0485872477,null,1533352.0485872477,null,{"$f":"J46-H46","v":44400}]
[null,null,null,null,null,"November",null,1625943.0485872477,null,1681681.0485872477,null,{"$f":"J47-H47","v":55738}]
[null,null,null,null,null,"December",null,1627170.0485872477]

{"sheet":"Ex 2 Spire Storage West","index":6,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1082,1106]
[null,null,null,null,null,null,null,1000,null,null,null,null,null,"Month","Inj","With","Total"]
[{"$f":"'Ex 1 HDD'!A7","v":"Month/Year"},"Actual","IRP Forecast (Normal)","Days","Daily Demand",null,"Actual Dth","MDth",null,"Actual","IRP Forecast (Normal)",null,null,null,null,null,450]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},{"$f":"H8","v":799.21500000000003},{"$f":"Q8","v":791.73},{"$f":"DAY(EOMONTH(A8,0))","v":30},{"$f":"C8/D8","v":26.391000000000002},{"$f":"+B9-B8","v":352.12900000000002},799215,{"$f":"G8/$H$6","v":799.21500000000003},null,949.73599999999999,{"$f":"C8","v":791.73},null,{"$f":"A8","v":"2019-06-01"},{"$f":"Q7","v":450},341.73,0,{"$f":"N8+O8-P8","v":791.73}]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},{"$f":"H9","v":1151.3440000000001},{"$f":"Q9","v":1144.8499999999999},{"$f":"DAY(EOMONTH(A9,0))","v":31},{"$f":"C9/D9","v":36.930645161290322},{"$f":"+B10-B9","v":352.12899999999991},1151344,{"$f":"G9/$H$6","v":1151.3440000000001},null,{"$f":"B9+J8","v":2101.08},{"$f":"C9+K8","v":1936.58},null,{"$f":"A9","v":"2019-07-01"},{"$f":"Q8","v":791.73},353.12,0,1144.8499999999999]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},{"$f":"H10","v":1503.473},1497.9699999999998,31,48.321612903225798,null,1503473,1503.473,null,3604.5529999999999,3434.5499999999997,null,"2019-08-01",{"$f":"Q9","v":1144.8499999999999},353.12,0,1497.9699999999998]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},{"$f":"G11","v":0},1838.8709999999999,30,61.295699999999997,null,null,0,null,3604.5529999999999,5273.4209999999994,null,"2019-09-01",1497.9699999999998,340.90100000000001,0,1838.8709999999999]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},0,2077.2139999999999,31,67.006903225806454,null,null,0,null,3604.5529999999999,7350.6349999999993,null,"2019-10-01",1838.8709999999999,238.34299999999999,0,2077.2139999999999]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},0,1579.2139999999999,30,52.640466666666661,null,null,0,null,3604.5529999999999,8929.8489999999983,null,"2019-11-01",2077.2139999999999,0,498,1579.2139999999999]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},0,1064.614,31,34.342387096774196,null,null,0,null,3604.5529999999999,9994.4629999999979,null,"2019-12-01",1579.2139999999999,0,514.6,1064.614]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},0,550.01400000000001,31,17.742387096774195,null,null,0,null,3604.5529999999999,10544.476999999997,null,"2020-01-01",1064.614,0,514.6,550.01400000000001]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},0,68.614000000000033,29,2.366000000000001,null,null,0,null,3604.5529999999999,10613.090999999997,null,"2020-02-01",550.01400000000001,0,481.4,68.614000000000033]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},0,68.614000000000033,31,2.2133548387096784,null,null,0,null,3604.5529999999999,10681.704999999996,null,"2020-03-01",68.614000000000033,0,0,68.614000000000033]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},0,404.07500000000005,30,13.469166666666668,null,null,0,null,3604.5529999999999,11085.779999999997,null,"2020-04-01",68.614000000000033,335.46100000000001,0,404.07500000000005]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},0,757.19400000000007,31,24.425612903225808,null,null,0,null,3604.5529999999999,11842.973999999997,null,"2020-05-01",404.07500000000005,353.11900000000003,0,757.19400000000007]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O8:O20)","v":2315.7940000000003},{"$f":"SUM(O8:O19)","v":2315.7940000000003},{"$f":"SUM(P8:P19)","v":2008.6}]

{"sheet":"Exhibit 2.1","index":7,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6580,8750,10765]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4140,6429,8565]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"},null,null,null,{"$f":"U29-U30","v":2440},{"$f":"V29-V30","v":2321},{"$f":"W29-W30","v":2200}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1]

{"sheet":"Exhibit 2.2","index":8,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002]

{"sheet":"Exhibit 2.3","index":9,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998]

{"sheet":"Exhibit 2.4","index":10,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4]

{"sheet":"Exhibit 2.5","index":11,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]

{"sheet":"Exhibit 2.6","index":12,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6]

{"sheet":"Exhibit Firm Sales Volume","index":13,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,9]]}
["Demand"]
[]
[]
[]
[]
[]
[{"$f":"'Ex 1 HDD'!A7","v":"Month/Year"},"Actual","IRP Forecast (Normal)","Days","Daily Demand"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},3012.4411359999999,3304.8550000000005,{"$f":"DAY(EOMONTH(A8,0))","v":30},{"$f":"C8/D8","v":110.16183333333335}]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},2628.2336639999999,2562.7410000000004,{"$f":"DAY(EOMONTH(A9,0))","v":31},{"$f":"C9/D9","v":82.66906451612904}]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},2555.4106139999999,2567.7429999999999,31,82.83041935483871]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},null,3805.0460000000003,30,126.83486666666667]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},null,6734.6680000000015,31,217.24735483870973]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},null,12379.303000000002,30,412.64343333333341]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},null,19403.760000000002,31,625.92774193548394]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},null,20973.918000000001,31,676.57800000000009]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},null,18183.888999999996,29,627.03065517241362]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},null,14059.607,31,453.53570967741933]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},null,9342.5279999999984,30,311.41759999999994]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},null,5780.5010000000002,31,186.46777419354839]
[null,null,{"$f":"SUM(C8:C19)","v":119098.55900000002}]

{"sheet":"Worksheet","index":14,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,7],[4,5,4,7]]}
["Firm Sales Variance: IRP First Quarter"]
["Data derived from Actual Dths in greybacks and IRP forecast."]
[]
[]
[null,null,null,null,null,"Cumulative"]
["Month/Year","Actual","IRP Forecast (Normal)",null,null,"Actual","IRP Forecast (Normal)"]
["2019-06-01",3012.4411359999999,3304.8550000000005,null,null,{"$f":"B7","v":3012.4411359999999},{"$f":"C7","v":3304.8550000000005}]
["2019-07-01",2628.2336639999999,2562.7410000000004,null,null,{"$f":"F7+B8","v":5640.6747999999998},{"$f":"G7+C8","v":5867.5960000000014}]
["2019-08-01",2555.4106139999999,2567.7429999999999,null,null,{"$f":"F8+B9","v":8196.0854139999992},8435.3390000000018]
["2019-09-01",0,3805.0460000000003,null,null,8196.0854139999992,12240.385000000002]
["2019-10-01",0,6734.6680000000015,null,null,8196.0854139999992,18975.053000000004]
["2019-11-01",0,12379.303000000002,null,null,8196.0854139999992,31354.356000000007]
["2019-12-01",0,19403.760000000002,null,null,8196.0854139999992,50758.116000000009]
["2020-01-01",0,20973.918000000001,null,null,8196.0854139999992,71732.034000000014]
["2020-02-01",0,18183.888999999996,null,null,8196.0854139999992,89915.92300000001]
["2020-03-01",0,14059.607,null,null,8196.0854139999992,103975.53000000001]
["2020-04-01",0,9342.5279999999984,null,null,8196.0854139999992,113318.05800000002]
["2020-05-01",0,5780.5010000000002,null,null,8196.0854139999992,119098.55900000002]
[]
[]
[]
[]
[null,null,3330.2629999999999]
[null,null,2710.78]
[null,null,2511.8879999999999]
[null,null,2931.4639999999999]
[null,null,7012.06]
[null,null,12196.531999999999]
[null,null,19288.345000000001]
[null,null,20286.143]
[null,null,16955.002]
[null,null,13312.582]
[null,null,8841.4920000000002]
[null,null,5414.2420000000002]

{"sheet":"Exhibit 3.1","index":15,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEU Variance Exhibit ","Docket No. 19-057-01","Dominion Energy Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.1]

{"sheet":"Exhibit 3.2","index":16,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEU Variance Exhibit ","Docket No. 19-057-01","Dominion Energy Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2]

{"sheet":"Exhibit 3.3","index":17,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DEU Variance Exhibit ","Docket No. 19-057-01","Dominion Energy Utah"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3]

{"sheet":"Exhibit 3.4","index":18,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[8,2,8,3],[8,4,8,5],[8,6,8,7]]}
[null,null,null,null,null,null,null,"Dominion Energy Utah"]
[null,null,null,null,null,null,null,"Docket No. 19-057-01"]
[null,null,null,null,null,null,null,"DEU Variance Exhibit 3.4"]
[]
[]
[null,"IRP Variance"]
[]
[null,"Actual Results "]
[null,null,"2019-06-01",null,"2019-07-01",null,"2019-08-01"]
[null,"SUPPLY","Actual","IRP Forecast (Normal)","Actual","IRP Forecast (Normal)","Actual","IRP Forecast (Normal)"]
[1,"Cost of Service Prod (Mbtu)",5977.3370000000004,5747.91,6115.5940000000019,5860.652,6095.2299999999977,5556.3450000000003]
[{"$f":"A11+1","v":2},"Purchases (Mbtu)",0,777.38300000000004,0,0,0,0]
[3,"Clay Basin With (Mbtu)",0,0,0,0,0,0]
[4,"Acquifers With (Mbtu)",0.65100000000000002,0,4.4809999999999999,0,4.1619999999999999,0]
[5,"Spire Storage West With (Mbtu)",0,0,0,0,0,0]
[6,"Off-System ",23.91386,43.686,31.900020000000001,44.847999999999999,27.918310000000002,44.582999999999998]
[]
[{"$f":"A16+1","v":7},"Total Supply",6001.9018599999999,6568.9789999999994,6151.9750200000017,5905.5,6127.310309999998,5600.9279999999999]
[]
[null,"DEMAND"]
[{"$f":"A18+1","v":8},"Firm Sales (Mbtu)",3012.4411359999999,3238.0620000000004,2628.2336639999999,2499.3650000000002,2555.4106139999999,2504.6000000000004]
[{"$f":"A21+1","v":9},"Interruptible Sales (Mbtu)",16.110752000000002,10.700999999999999,14.440725,9.511000000000001,11.506601,9.5060000000000002]
[10,"Clay Basin Inj (Mbtu)",2231.6260000000002,2700,2838.4140000000002,2774.1660000000002,2698.73,2480]
[{"$f":"A23+1","v":11},"Acquifers Inj (Mbtu)",0.23899999999999999,0,127.76600000000001,0,0.17899999999999999,0]
[{"$f":"A24+1","v":12},"Spire Storage West Inj (Mbtu)",35.759,341.72800000000001,352.12900000000002,353.11900000000003,352.12900000000002,353.11900000000003]
[13,"Off-System ",23.91386,41.472000000000001,31.900020000000001,42.575000000000003,27.918310000000002,42.323999999999998]
[14,"Fuel",70.887,222.39499999999998,71.352999999999994,215.47300000000001,70.533000000000001,200.06700000000001]
[15,"Company Use / L&U",611.24699999999996,14.62,87.965000000000003,11.29,410.46100000000001,11.313000000000002]
[]
[{"$f":"A28+1","v":16},"Total Demand",6002.2237479999994,6568.9780000000001,6152.2014090000002,5905.4989999999998,6126.8675250000006,5600.9289999999992]
[null," "]
[{"$f":"A30+1","v":17},"Clay Basin Fuel Usage Adjustment",-4.0000000000000001E-3,0,-4.0000000000000001E-3,0,-4.0000000000000001E-3,0]
[{"$f":"A32+1","v":18},"Clay Basin Transfers",0,0,-29.236000000000001,0,0,0]
[{"$f":"A33+1","v":19},"Acquifers Fuel Usage Adjustment",-1.3759999999999999,0,-3.702,0,-0.83399999999999996,0]
[{"$f":"A34+1","v":20},"Acquifers Transfers",0,0,0,0,0,0]
[21,"Clay Basin Current Bal",3477.5960000000005,3956.2608037109376,6286.77,6124.6203618164063,8985.496000000001,8712.3472905273447]
[22,"Acquifers Current Bal",492.15600000000001,799,611.73900000000003,799,606.92200000000003,799]
[23,"Spire Storage West Current Bal",799.21500000000003,952,1151.3440000000001,1302,1503.473,1658]
[]
[{"$f":"+A38+1","v":24},"Purchases($/Dth)",0,0,0,0,0,0]
[{"$f":"A40+1","v":25},"Purchases $ (000)",0,0,0,0,0,0]
[]
[]
[null,"Variances"]
[{"$f":"A41+1","v":26},"Cost of service volumes",229.42700000000059,0,254.94200000000183,0,538.88499999999749,0]
[{"$f":"A45+1","v":27},"Purchase volumes",0,0,0,0,0,0]
[28,"Purchase $ Act over (under) IRP",0,0,0,0,0,0]
[29,"Purchase Variance",0,0,0,0,0,0]
[30,"$ Variance",0,0,0,0,0,0]
[31,"Check",0,0,0,0,0,0]
[32,"Quarter Variance",null,null,null,null,0]
[33,"Purchase Variance",null,null,null,null,0]
[34,"$ Variance",null,null,null,null,0]
[35,"Check",null,null,null,null,0]

{"sheet":"Ex 4 Purchase Gas","index":19,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,6,5,7]]}
["Purchase Gas Variance (Brady Included) MDths"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Cumulative"]
["Month/Year","Actual","IRP Forecast (Normal)",null,"Month/Year","Actual","IRP Forecast (Normal)",null,"Month/Year","DTHS","MDTHS","$'S","$1,000'S"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},{"$f":"K8","v":0},777.38300000000004,null,{"$f":"A8","v":"2019-06-01"},{"$f":"K8","v":0},{"$f":"C8","v":777.38300000000004},null,{"$f":"A8","v":"2019-06-01"},0,{"$f":"J8/1000","v":0},0,{"$f":"L8/1000","v":0}]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},{"$f":"K9","v":0},0,null,"2019-07-01",{"$f":"F8+K9","v":0},{"$f":"G8+C9","v":777.38300000000004},null,"2019-07-01",0,{"$f":"J9/1000","v":0},0,0]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},0,0,null,"2019-08-01",0,777.38300000000004,null,"2019-08-01",0,{"$f":"J10/1000","v":0},0,0]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},0,0,null,"2019-09-01",0,777.38300000000004,null,"2019-09-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},0,4222.72,null,"2019-10-01",0,5000.1030000000001,null,"2019-10-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},0,4431.0640000000003,null,"2019-11-01",0,9431.1670000000013,null,"2019-11-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},0,10225.629999999999,null,"2019-12-01",0,19656.796999999999,null,"2019-12-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},0,11799.12,null,"2020-01-01",0,31455.917000000001,null,"2020-01-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},0,9734.01,null,"2020-02-01",0,41189.927000000003,null,"2020-02-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},0,8071.9,null,"2020-03-01",0,49261.827000000005,null,"2020-03-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},{"$f":"K18","v":0},4812.29,null,"2020-04-01",0,{"$f":"G17+C18","v":54074.117000000006},null,"2020-04-01",null,0,null,0]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},{"$f":"K19","v":0},2600.38,null,"2020-05-01",0,56674.497000000003,null,"2020-05-01",null,0,null,0]
[]
[null,{"$f":"SUM(B8:B19)","v":0},{"$f":"SUM(C8:C20)","v":56674.497000000003}]
[]
[null,{"$f":"B16-B17","v":0}]

{"sheet":"Exhibit 4.1","index":20,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.0999999999999996]

{"sheet":"Exhibit 4.2","index":21,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.2]

{"sheet":"Exhibit 4.3","index":22,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4.3]

{"sheet":"Ex 5 Purchase Gas Cost","index":23,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,0,1,6],[0,0,0,6],[2,0,2,7],[5,4,5,5]]}
["Purchase Gas Cost Variance ($1,000's)"]
[]
[]
[]
[]
[null,null,null,null,"Cumulative"]
["Month/Year","Actual","IRP Forecast (Normal)",null,"Actual","IRP Forecast (Normal)"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},{"$f":"'Ex 4 Purchase Gas'!M8","v":0},1683.7280000000001,null,{"$f":"B8","v":0},{"$f":"C8","v":1683.7280000000001}]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},{"$f":"'Ex 4 Purchase Gas'!M9","v":0},0,null,{"$f":"E8+B9","v":0},{"$f":"C9+F8","v":1683.7280000000001}]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},{"$f":"'Ex 4 Purchase Gas'!M10","v":0},0,null,0,{"$f":"C10+F9","v":1683.7280000000001}]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},{"$f":"'Ex 4 Purchase Gas'!M11","v":0},0,null,0,1683.7280000000001]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},{"$f":"'Ex 4 Purchase Gas'!M12","v":0},9736.9889999999996,null,0,11420.717000000001]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},{"$f":"'Ex 4 Purchase Gas'!M13","v":0},11571.04,null,0,22991.757000000001]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},{"$f":"'Ex 4 Purchase Gas'!M14","v":0},28566.21,null,0,51557.967000000004]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},{"$f":"'Ex 4 Purchase Gas'!M15","v":0},34169.18,null,0,85727.146999999997]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},{"$f":"'Ex 4 Purchase Gas'!M16","v":0},25996.639999999999,null,0,111723.787]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},{"$f":"'Ex 4 Purchase Gas'!M17","v":0},18934.53,null,0,130658.317]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},{"$f":"'Ex 4 Purchase Gas'!M18","v":0},9572.0550000000003,null,0,140230.372]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},{"$f":"'Ex 4 Purchase Gas'!M19","v":0},5027.8969999999999,null,0,145258.269]
[]
[null,null,{"$f":"SUM(C8:C19)","v":145258.269}]

{"sheet":"Exhibit 5.1","index":24,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996]

{"sheet":"Exhibit 5.2","index":25,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.2]

{"sheet":"Exhibit 5.3","index":26,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.3]

{"sheet":"Ex 6 Purch Gas Unit Cost","index":27,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,7],[2,0,2,7],[46,2,46,13]]}
["Purchase Gas Unit Cost Variance ($1,000's)"]
[]
[]
[]
[]
[null,null,null,null,"Actual","Actual","Actual",null,"Normal","Normal","Normal"]
["Month/Year","Actual $/Dth","IRP Forecast (Normal) $/Dth",null,"Dth","Cost","$/Dth",null,"Dth","Cost","$/Dth",null,"May Forward Strip"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},{"$f":"G8","v":0},{"$f":"K8","v":2.1658924880014099},null,{"$f":"'Ex 4 Purchase Gas'!B8","v":0},{"$f":"'Ex 4 Purchase Gas'!M8","v":0},{"$f":"IFERROR(F8/E8,0)","v":0},null,{"$f":"'Ex 4 Purchase Gas'!C8","v":777.38300000000004},{"$f":"'Ex 5 Purchase Gas Cost'!C8","v":1683.7280000000001},{"$f":"IFERROR(J8/I8,0)","v":2.1658924880014099},null,2.17]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},0,0,null,{"$f":"'Ex 4 Purchase Gas'!B9","v":0},{"$f":"'Ex 4 Purchase Gas'!M9","v":0},{"$f":"IFERROR(F9/E9,0)","v":0},null,{"$f":"'Ex 4 Purchase Gas'!C9","v":0},{"$f":"'Ex 5 Purchase Gas Cost'!C9","v":0},{"$f":"IFERROR(J9/I9,0)","v":0},null,2.4900000000000002]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},0,0,null,{"$f":"'Ex 4 Purchase Gas'!B10","v":0},{"$f":"'Ex 4 Purchase Gas'!M10","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C10","v":0},{"$f":"'Ex 5 Purchase Gas Cost'!C10","v":0},0,null,2.6]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},0,{"$f":"K11","v":0},null,{"$f":"'Ex 4 Purchase Gas'!B11","v":0},{"$f":"'Ex 4 Purchase Gas'!M11","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C11","v":0},{"$f":"'Ex 5 Purchase Gas Cost'!C11","v":0},0,null,2.4]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},0,{"$f":"K12","v":2.3058571252652316},null,{"$f":"'Ex 4 Purchase Gas'!B12","v":0},{"$f":"'Ex 4 Purchase Gas'!M12","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C12","v":4222.72},{"$f":"'Ex 5 Purchase Gas Cost'!C12","v":9736.9889999999996},2.3058571252652316,null,2.2999999999999998]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},0,2.6113457174168553,null,{"$f":"'Ex 4 Purchase Gas'!B13","v":0},{"$f":"'Ex 4 Purchase Gas'!M13","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C13","v":4431.0640000000003},{"$f":"'Ex 5 Purchase Gas Cost'!C13","v":11571.04},2.6113457174168553,null,2.64]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},0,2.7935892458459772,null,{"$f":"'Ex 4 Purchase Gas'!B14","v":0},{"$f":"'Ex 4 Purchase Gas'!M14","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C14","v":10225.629999999999},{"$f":"'Ex 5 Purchase Gas Cost'!C14","v":28566.21},2.7935892458459772,null,2.84]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},0,2.8959091864478026,null,{"$f":"'Ex 4 Purchase Gas'!B15","v":0},{"$f":"'Ex 4 Purchase Gas'!M15","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C15","v":11799.12},{"$f":"'Ex 5 Purchase Gas Cost'!C15","v":34169.18},2.8959091864478026,null,2.92]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},0,2.67070200256626,null,{"$f":"'Ex 4 Purchase Gas'!B16","v":0},{"$f":"'Ex 4 Purchase Gas'!M16","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C16","v":9734.01},{"$f":"'Ex 5 Purchase Gas Cost'!C16","v":25996.639999999999},2.67070200256626,null,2.71]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},0,2.3457339659807479,null,{"$f":"'Ex 4 Purchase Gas'!B17","v":0},{"$f":"'Ex 4 Purchase Gas'!M17","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C17","v":8071.9},{"$f":"'Ex 5 Purchase Gas Cost'!C17","v":18934.53},2.3457339659807479,null,2.39]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},0,1.9890852380051909,null,{"$f":"'Ex 4 Purchase Gas'!B18","v":0},{"$f":"'Ex 4 Purchase Gas'!M18","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C18","v":4812.29},{"$f":"'Ex 5 Purchase Gas Cost'!C18","v":9572.0550000000003},1.9890852380051909,null,2.0299999999999998]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},0,1.9335239465001268,null,{"$f":"'Ex 4 Purchase Gas'!B19","v":0},{"$f":"'Ex 4 Purchase Gas'!M19","v":0},0,null,{"$f":"'Ex 4 Purchase Gas'!C19","v":2600.38},{"$f":"'Ex 5 Purchase Gas Cost'!C19","v":5027.8969999999999},1.9335239465001268,null,2.02]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2017-10-26","Unit Cost per Decatherm","   The Purchase Gas Unit Cost is usually a calculated value.  That value is derived from purchase dollars divided by purchase decatherms.  Columns I - K show those decatherms, costs and calculated Unit costs.\n   In the unusual case of summer 2017 the model used no spot gas during the summer and so incurred zero purchased volumes and zero associated costs making the Unit cost also zero. \n   If purchase volumes had been incurred then the question arrises as to what value should be used as the \"model\" unit cost value.  \n- Zero could have been reasonably used because the model had no volumes or costs, even though the actual usage may have had volumes.  (In this case it did not.)\n- The May forward strip could have been used because that was the best guess for monthly prices at the time the model was created\n- Some actual value from each month could have also been used as a filler."]

{"sheet":"Exhibit 6.1","index":28,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.1]

{"sheet":"Exhibit 6.2","index":29,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.2]

{"sheet":"Ex 7 Co. Owned Gas","index":30,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,14,2,19],[1,0,1,7],[2,0,2,10]]}
["Cost-of-Service Gas Variance (MDths)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Cumulative"]
["Month/Year","Actual","IRP Forecast (Normal)","Full Production","Shut-in Est. Month","Shut-in Daily",null,"Actual","IRP Forecast (Normal)",null,"Days in Mo.","Dthms","Dthms/Day"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},5977.3370000000004,5747.91,5747.91,{"$f":"D8-C8","v":0},{"$f":"(E8/30)*1000","v":0},null,{"$f":"B8","v":5977.3370000000004},{"$f":"C8","v":5747.91},null,{"$f":"DAY(EOMONTH(A8,0))","v":30},{"$f":"C8","v":5747.91},{"$f":"L8/K8","v":191.59700000000001},null,null,null,5754.4783839995334]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},6115.5940000000019,5860.6560000000009,5860.6560000000009,0,{"$f":"(E9/30)*1000","v":0},null,{"$f":"H8+B9","v":12092.931000000002},{"$f":"I8+C9","v":11608.566000000001},null,{"$f":"DAY(EOMONTH(A9,0))","v":31},{"$f":"C9","v":5860.6560000000009},{"$f":"L9/K9","v":189.05341935483872},null,null,null,5867.4130191810464]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},6095.2299999999977,5556.3469999999998,5980.0830501543187,423.73605015431895,14124.535005143965,null,18188.161,17164.913,null,31,5556.3469999999998,179.23699999999999,null,null,null,5986.08520467781]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},null,5611.686999999999,5611.686999999999,0,0,null,18188.161,22776.6,null,30,5611.686999999999,187.0562333333333,null,null,null,5618.719148733463]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},null,5658.2239999999993,5658.2239999999993,0,0,null,18188.161,28434.823999999997,null,31,5658.2239999999993,182.52335483870965,null,null,null,5665.4338021854201]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},null,5360.5049999999992,5360.5049999999992,0,0,null,18188.161,33795.328999999998,null,30,5360.5049999999992,178.68349999999998,null,null,null,5366.2612820765262]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},null,5562.6619999999984,5562.6619999999984,0,0,null,18188.161,39357.990999999995,null,31,5562.6619999999984,179.44070967741931,null,null,null,5567.8766430258429]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},null,5433.6160000000009,5433.6160000000009,0,0,null,18188.161,44791.606999999996,null,31,5433.6160000000009,175.277935483871,null,null,null,5438.795676378295]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},null,5096.2089999999989,5096.2089999999989,0,0,null,18188.161,49887.815999999992,null,29,5096.2089999999989,175.73134482758616,null,null,null,5101.5900718666953]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},null,5320.3880000000008,5320.3880000000008,0,0,null,18188.161,55208.203999999991,null,31,5320.3880000000008,171.62541935483873,null,null,null,5326.091885868781]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},null,5046.0839999999989,5046.0839999999989,0,0,null,18188.161,60254.287999999986,null,30,5046.0839999999989,168.20279999999997,null,null,null,5051.585886710629]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},null,5120.67,5120.67,0,{"$f":"(E19/30)*1000","v":0},null,18188.161,65374.957999999984,null,31,5120.67,165.18290322580646,null,null,null,5126.3058280721052]
[]
[null,{"$f":"SUM(B8:B19)","v":18188.161},{"$f":"SUM(C8:C19)","v":65374.957999999984},{"$f":"SUM(D8:D19)","v":65798.694050154299}]

{"sheet":"Exhibit 7.1","index":31,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.1]

{"sheet":"Exhibit 7.2","index":32,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]

{"sheet":"Exhibit 7.3","index":33,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.3]

{"sheet":"Ex 8 New Drill","index":34,"n_rows":19,"n_cols":13,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9]]}
["Isolated New Drill Component (MDths)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Cumulative",null,"Cumulative"]
["Month/Year","ND Actual","ND IRP Forecast (Normal)","Legacy Actual","Legacy IRP Forecast (Normal)",null,null,"Prod Actual","Prod Normal","ND Actual","ND IRP Forecast (Normal)","Legacy Actual","Legacy IRP Forecast (Normal)"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},131.35599999999999,214.34700000000001,{"$f":"H8-B8","v":5845.9810000000007},{"$f":"I8-C8","v":5533.5630000000001},null,null,{"$f":"'Ex 7 Co. Owned Gas'!B8","v":5977.3370000000004},{"$f":"'Ex 7 Co. Owned Gas'!C8","v":5747.91},{"$f":"B8","v":131.35599999999999},{"$f":"C8","v":214.34700000000001},{"$f":"D8","v":5845.9810000000007},{"$f":"E8","v":5533.5630000000001}]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},118.494,255.97,5997.1000000000022,5604.6860000000006,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B9","v":6115.5940000000019},{"$f":"'Ex 7 Co. Owned Gas'!C9","v":5860.6560000000009},{"$f":"B8+B9","v":249.85},{"$f":"K8+C9","v":470.31700000000001},11843.081000000002,11138.249]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},107.49299999999999,223.12799999999999,5987.7369999999974,5333.2190000000001,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B10","v":6095.2299999999977},{"$f":"'Ex 7 Co. Owned Gas'!C10","v":5556.3469999999998},{"$f":"J9+B10","v":357.34299999999996},693.44499999999994,17830.817999999999,16471.468000000001]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},0,386.98500000000001,0,5224.7019999999993,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B11","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C11","v":5611.686999999999},357.34299999999996,{"$f":"K10+C11","v":1080.4299999999998},{"$f":"L10+D11","v":17830.817999999999},{"$f":"M10+E11","v":21696.17}]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},0,349.53399999999999,0,5308.69,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B12","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C12","v":5658.2239999999993},357.34299999999996,1429.9639999999999,{"$f":"L11+D12","v":17830.817999999999},27004.859999999997]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},0,303.34199999999998,0,5057.1629999999996,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B13","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C13","v":5360.5049999999992},357.34299999999996,1733.306,17830.817999999999,32062.022999999997]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},0,414.43,0,5148.2319999999982,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B14","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C14","v":5562.6619999999984},357.34299999999996,2147.7359999999999,17830.817999999999,37210.254999999997]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},0,365.43700000000001,0,5068.179000000001,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B15","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C15","v":5433.6160000000009},357.34299999999996,2513.1729999999998,17830.817999999999,42278.434000000001]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},0,430.20600000000002,0,4666.0029999999988,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B16","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C16","v":5096.2089999999989},357.34299999999996,2943.3789999999999,17830.817999999999,46944.436999999998]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},0,406.83800000000002,0,4913.5500000000011,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B17","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C17","v":5320.3880000000008},357.34299999999996,3350.2170000000001,17830.817999999999,51857.987000000001]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},0,357.97500000000002,0,4688.1089999999986,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B18","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C18","v":5046.0839999999989},357.34299999999996,3708.192,17830.817999999999,56546.095999999998]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},0,341.74799999999999,0,4778.9220000000005,null,null,{"$f":"'Ex 7 Co. Owned Gas'!B19","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C19","v":5120.67},357.34299999999996,4049.94,17830.817999999999,61325.017999999996]

{"sheet":"Exhibit 8.1","index":35,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1]

{"sheet":"Exhibit 8.2","index":36,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1999999999999993]

{"sheet":"Exhibit 8.3","index":37,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.3000000000000007]

{"sheet":"Normal Purchase %","index":38,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[1,0,1,8]]}
[]
["Source:  The whole numbers come from Purchase Gas and Company Owned Gas sheets.  The percentages are then calculated from those numbers."]
[null,2,3,4,5,6,7,8,9]
["Month","Actual Purchase Mdth","Normal Purchase Mdth","Actual Company Mdth","Normal Company Mdths","Actual Purchase as Percent of Total","Normal Purchase as Percent of Total","Actual Cost-of-Service as Percent of Total","Normal Cost-of-Service as Percent of Total",null,"Check Should = 100%","Check Should = 100%"]
[{"$f":"'Ex 1 HDD'!A8","v":"2019-06-01"},{"$f":"'Ex 4 Purchase Gas'!B8","v":0},{"$f":"'Ex 4 Purchase Gas'!C8","v":777.38300000000004},{"$f":"'Ex 7 Co. Owned Gas'!B8","v":5977.3370000000004},{"$f":"'Ex 7 Co. Owned Gas'!C8","v":5747.91},{"$f":"IFERROR(B5/(B5+D5),0)","v":0},{"$f":"C5/(C5+E5)","v":0.11913380747807034},{"$f":"IFERROR(D5/(D5+B5),0)","v":1},{"$f":"E5/(E5+C5)","v":0.88086619252192966},null,{"$f":"F5+H5","v":1},{"$f":"G5+I5","v":1}]
[{"$f":"'Ex 1 HDD'!A9","v":"2019-07-01"},{"$f":"'Ex 4 Purchase Gas'!B9","v":0},{"$f":"'Ex 4 Purchase Gas'!C9","v":0},{"$f":"'Ex 7 Co. Owned Gas'!B9","v":6115.5940000000019},{"$f":"'Ex 7 Co. Owned Gas'!C9","v":5860.6560000000009},{"$f":"IFERROR(B6/(B6+D6),0)","v":0},0,{"$f":"IFERROR(D6/(D6+B6),0)","v":1},1,null,1,1]
[{"$f":"'Ex 1 HDD'!A10","v":"2019-08-01"},{"$f":"'Ex 4 Purchase Gas'!B10","v":0},{"$f":"'Ex 4 Purchase Gas'!C10","v":0},{"$f":"'Ex 7 Co. Owned Gas'!B10","v":6095.2299999999977},{"$f":"'Ex 7 Co. Owned Gas'!C10","v":5556.3469999999998},0,0,1,1,null,1,1]
[{"$f":"'Ex 1 HDD'!A11","v":"2019-09-01"},{"$f":"'Ex 4 Purchase Gas'!B11","v":0},{"$f":"'Ex 4 Purchase Gas'!C11","v":0},{"$f":"'Ex 7 Co. Owned Gas'!B11","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C11","v":5611.686999999999},0,0,0,1,null,0,1]
[{"$f":"'Ex 1 HDD'!A12","v":"2019-10-01"},{"$f":"'Ex 4 Purchase Gas'!B12","v":0},{"$f":"'Ex 4 Purchase Gas'!C12","v":4222.72},{"$f":"'Ex 7 Co. Owned Gas'!B12","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C12","v":5658.2239999999993},0,0.42735997694147448,0,0.57264002305852557,null,0,1]
[{"$f":"'Ex 1 HDD'!A13","v":"2019-11-01"},{"$f":"'Ex 4 Purchase Gas'!B13","v":0},{"$f":"'Ex 4 Purchase Gas'!C13","v":4431.0640000000003},{"$f":"'Ex 7 Co. Owned Gas'!B13","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C13","v":5360.5049999999992},0,0.45253870957759684,0,0.5474612904224031,null,{"$f":"F10+H10","v":0},1]
[{"$f":"'Ex 1 HDD'!A14","v":"2019-12-01"},{"$f":"'Ex 4 Purchase Gas'!B14","v":0},{"$f":"'Ex 4 Purchase Gas'!C14","v":10225.629999999999},{"$f":"'Ex 7 Co. Owned Gas'!B14","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C14","v":5562.6619999999984},0,0.64767170508374183,0,0.35232829491625817,null,0,1]
[{"$f":"'Ex 1 HDD'!A15","v":"2020-01-01"},{"$f":"'Ex 4 Purchase Gas'!B15","v":0},{"$f":"'Ex 4 Purchase Gas'!C15","v":11799.12},{"$f":"'Ex 7 Co. Owned Gas'!B15","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C15","v":5433.6160000000009},0,0.68469220441838141,0,0.31530779558161864,null,0,1]
[{"$f":"'Ex 1 HDD'!A16","v":"2020-02-01"},{"$f":"'Ex 4 Purchase Gas'!B16","v":0},{"$f":"'Ex 4 Purchase Gas'!C16","v":9734.01},{"$f":"'Ex 7 Co. Owned Gas'!B16","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C16","v":5096.2089999999989},0,0.65636320003096382,0,0.34363679996903612,null,0,1]
[{"$f":"'Ex 1 HDD'!A17","v":"2020-03-01"},{"$f":"'Ex 4 Purchase Gas'!B17","v":0},{"$f":"'Ex 4 Purchase Gas'!C17","v":8071.9},{"$f":"'Ex 7 Co. Owned Gas'!B17","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C17","v":5320.3880000000008},0,0.60272748017366407,0,0.39727251982633593,null,0,1]
[{"$f":"'Ex 1 HDD'!A18","v":"2020-04-01"},{"$f":"'Ex 4 Purchase Gas'!B18","v":0},{"$f":"'Ex 4 Purchase Gas'!C18","v":4812.29},{"$f":"'Ex 7 Co. Owned Gas'!B18","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C18","v":5046.0839999999989},0,0.48814236505939013,0,0.51185763494060976,null,0,0.99999999999999989]
[{"$f":"'Ex 1 HDD'!A19","v":"2020-05-01"},{"$f":"'Ex 4 Purchase Gas'!B19","v":0},{"$f":"'Ex 4 Purchase Gas'!C19","v":2600.38},{"$f":"'Ex 7 Co. Owned Gas'!B19","v":0},{"$f":"'Ex 7 Co. Owned Gas'!C19","v":5120.67},0,0.3367909805013567,0,0.6632090194986433,null,0,1]
[]
["Q1",{"$f":"SUM(B5:B7)","v":0},{"$f":"SUM(C5:C7)","v":777.38300000000004},{"$f":"SUM(D5:D7)","v":18188.161},{"$f":"SUM(E5:E7)","v":17164.913},{"$f":"IFERROR(B18/(B18+D18),0)","v":0},{"$f":"C18/(C18+E18)","v":4.332684066743743E-2},{"$f":"IFERROR(D18/(D18+B18),0)","v":1},{"$f":"E18/(E18+C18)","v":0.95667315933256247},null,{"$f":"F18+H18","v":1},0.99999999999999989]
["Q2",{"$f":"SUM(B8:B10)","v":0},{"$f":"SUM(C8:C10)","v":8653.7839999999997},{"$f":"SUM(D8:D10)","v":0},{"$f":"SUM(E8:E10)","v":16630.415999999997},{"$f":"IFERROR(B19/(B19+D19),0)","v":0},{"$f":"C19/(C19+E19)","v":0.34226054215676194},{"$f":"IFERROR(D19/(D19+B19),0)","v":0},{"$f":"E19/(E19+C19)","v":0.65773945784323806},null,0,1]
["Q3",{"$f":"SUM(B11:B13)","v":0},{"$f":"SUM(C11:C13)","v":31758.760000000002},{"$f":"SUM(D11:D13)","v":0},{"$f":"SUM(E11:E13)","v":16092.486999999997},0,0.6636976461658356,0,0.33630235383416435,null,0,1]
["Q4",{"$f":"SUM(B14:B16)","v":0},{"$f":"SUM(C14:C16)","v":15484.57},{"$f":"SUM(D14:D16)","v":0},{"$f":"SUM(E14:E16)","v":15487.142},0,0.49995847823975631,0,{"$f":"E21/(E21+C21)","v":0.50004152176024363},null,{"$f":"F21+H21","v":0},{"$f":"G21+I21","v":1}]
[null,"IRP","Actual","IRP","Actual",0,"Actual",0,"Actual"]
[]
[null,null,null,null,null,{"$f":"F4","v":"Actual Purchase as Percent of Total"},{"$f":"G4","v":"Normal Purchase as Percent of Total"},{"$f":"H4","v":"Actual Cost-of-Service as Percent of Total"},{"$f":"I4","v":"Normal Cost-of-Service as Percent of Total"}]
[null,null,null,null,{"$f":"A5","v":"2019-06-01"},{"$f":"VLOOKUP($E25,$A$5:$I$16,F$3,FALSE)","v":0},{"$f":"VLOOKUP($E25,$A$5:$I$16,G$3,FALSE)","v":0.11913380747807034},1,0.88086619252192966,null,{"$f":"F25+H25","v":1},1]
[null,null,null,null,{"$f":"A6","v":"2019-07-01"},{"$f":"VLOOKUP($E26,$A$5:$I$16,F$3,FALSE)","v":0},0,1,1,null,1,1]
[null,null,null,null,{"$f":"A7","v":"2019-08-01"},{"$f":"VLOOKUP($E27,$A$5:$I$16,F$3,FALSE)","v":0},0,1,1,null,1,1]
[]
[null,null,null,null,{"$f":"A18","v":"Q1"},{"$f":"VLOOKUP($E29,$A$18:$I$21,F$3,FALSE)","v":0},{"$f":"VLOOKUP($E29,$A$18:$I$21,G$3,FALSE)","v":4.332684066743743E-2},1,0.95667315933256247,null,{"$f":"F29+H29","v":1},0.99999999999999989]
[null,null,null,null,{"$f":"A19","v":"Q2"},{"$f":"VLOOKUP($E30,$A$18:$I$21,F$3,FALSE)","v":0},0.34226054215676194,0,0.65773945784323806,null,0,1]
[null,null,null,null,{"$f":"A20","v":"Q3"},{"$f":"VLOOKUP($E31,$A$18:$I$21,F$3,FALSE)","v":0},0.6636976461658356,0,0.33630235383416435,null,0,1]
[null,null,null,null,"Q4",{"$f":"VLOOKUP($E32,$A$18:$I$21,F$3,FALSE)","v":0},0.49995847823975631,0,0.50004152176024363,null,0,1,null,{"$f":"F32-G32","v":-0.49995847823975631},{"$f":"I32-H32","v":0.50004152176024363}]
[]
[null,null,null,null,null,{"$f":"AVERAGE((F25:F27))","v":0},{"$f":"AVERAGE((G25:G27))","v":3.9711269159356778E-2},{"$f":"AVERAGE((H25:H27))","v":1},{"$f":"AVERAGE((I25:I27))","v":0.96028873084064326}]

{"sheet":"IRP Pruch Cover Sheet","index":39,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,2,3,4,5]
[null,{"$f":"'Normal Purchase %'!F24","v":"Actual Purchase as Percent of Total"},{"$f":"'Normal Purchase %'!G24","v":"Normal Purchase as Percent of Total"},{"$f":"'Normal Purchase %'!H24","v":"Actual Cost-of-Service as Percent of Total"},{"$f":"'Normal Purchase %'!I24","v":"Normal Cost-of-Service as Percent of Total"}]
[]
[{"$f":"'Normal Purchase %'!E25","v":"2019-06-01"},{"$f":"VLOOKUP($A4,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!B$1,FALSE)","v":0},{"$f":"VLOOKUP($A4,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!C$1,FALSE)","v":0.11913380747807034},{"$f":"VLOOKUP($A4,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!D$1,FALSE)","v":1},{"$f":"VLOOKUP($A4,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!E$1,FALSE)","v":0.88086619252192966}]
[{"$f":"'Normal Purchase %'!E26","v":"2019-07-01"},{"$f":"VLOOKUP($A5,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!B$1,FALSE)","v":0},{"$f":"VLOOKUP($A5,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!C$1,FALSE)","v":0},{"$f":"VLOOKUP($A5,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!D$1,FALSE)","v":1},{"$f":"VLOOKUP($A5,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!E$1,FALSE)","v":1}]
[{"$f":"'Normal Purchase %'!E27","v":"2019-08-01"},{"$f":"VLOOKUP($A6,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!B$1,FALSE)","v":0},{"$f":"VLOOKUP($A6,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!C$1,FALSE)","v":0},{"$f":"VLOOKUP($A6,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!D$1,FALSE)","v":1},{"$f":"VLOOKUP($A6,'Normal Purchase %'!$E$25:$I$27,'IRP Pruch Cover Sheet'!E$1,FALSE)","v":1}]
[]
[{"$f":"'Normal Purchase %'!E29","v":"Q1"},{"$f":"VLOOKUP($A$8,'Normal Purchase %'!$E$29:$I$32,'IRP Pruch Cover Sheet'!B$1,FALSE)","v":0},{"$f":"VLOOKUP($A$8,'Normal Purchase %'!$E$29:$I$32,'IRP Pruch Cover Sheet'!C$1,FALSE)","v":4.332684066743743E-2},{"$f":"VLOOKUP($A$8,'Normal Purchase %'!$E$29:$I$32,'IRP Pruch Cover Sheet'!D$1,FALSE)","v":1},{"$f":"VLOOKUP($A$8,'Normal Purchase %'!$E$29:$I$32,'IRP Pruch Cover Sheet'!E$1,FALSE)","v":0.95667315933256247}]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"B8-C8","v":-4.332684066743743E-2},{"$f":"E8-D8","v":-4.3326840667437527E-2}]

{"sheet":"Shut-In","index":40,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1]]}
["Actual Data from Jennifer Beasley"]
["Estimates…See Company Nom Groups herein"]
[]
[null,"June","July","August","Total Dth for Quarter",null,null,"September","October","November","Total Dth for Quarter"]
["Estimated Shut-in (dth/day)",0,0,13668.904843687707,{"$f":"SUM(B5:D5)","v":13668.904843687707},null,"Estimated Shut-in (dth/day)",{"$f":"H41/30","v":0},{"$f":"I41/30","v":0},0,{"$f":"K41","v":0}]
["Actual Shut-in  (dth/day)",0,0,0,0,null,"Acutal Shut-in  (dth/day)",{"$f":"H75/30","v":0},{"$f":"I75/31","v":0},0,{"$f":"K75","v":0}]
[]
[]
[]
[1,59,{"$f":"C5","v":0},0,null,null,{"$f":"A10","v":1}]
[2,59,780,0,null,null,{"$f":"A11","v":2}]
[3,59,780,0,null,null,3]
[4,59,780,0,null,null,4]
[5,59,780,0,null,null,5]
[6,59,780,0,null,null,6]
[7,59,{"$f":"C11","v":780},0,null,null,7]
[8,59,780,0,null,null,8]
[9,59,780,0,null,null,9]
[10,59,{"$f":"C14","v":780},0,null,null,10]
[11,59,780,0,null,null,11]
[12,59,780,0,null,null,12]
[13,59,{"$f":"C17","v":780},0,null,null,13]
[14,59,780,0,null,null,14]
[15,59,780,0,null,null,15]
[16,59,{"$f":"C20","v":780},0,null,null,16]
[17,59,780,0,null,null,17]
[18,59,780,0,null,null,18]
[19,59,{"$f":"C23","v":780},0,null,null,19]
[20,59,780,0,null,null,20]
[21,59,780,0,null,null,21]
[22,59,{"$f":"C26","v":780},0,null,null,22]
[23,59,780,0,null,null,23]
[24,59,780,0,null,null,24]
[25,59,{"$f":"C29","v":780},0,null,null,25]
[26,59,780,0,null,null,26]
[27,59,780,0,null,null,27]
[28,59,{"$f":"C32","v":780},0,null,null,28]
[29,59,780,0,null,null,29]
[30,59,780,0,null,null,30]
[31,0,{"$f":"C35","v":780},0,null,null,31]
[null,{"$f":"SUM(B10:B40)","v":1770},{"$f":"SUM(C10:C40)","v":23400},{"$f":"SUM(D10:D40)","v":0},{"$f":"SUM(B41:D41)","v":25170},null,null,0,0,0,{"$f":"SUM(H41:J41)","v":0}]
[]
[]
[1,0,0,0,null,null,1,0,0,0]
[2,0,0,0,null,null,2,0,0,0]
[3,0,0,0,null,null,3,0,0,0]
[4,0,0,5724,null,null,4,0,0,0]
[5,0,0,5724,null,null,5,0,0,0]
[6,0,0,5724,null,null,6,0,0,0]
[7,0,0,5724,null,null,7,0,0,0]
[8,0,0,5724,null,null,8,0,0,0]
[9,0,0,5724,null,null,9,0,0,0]
[10,0,0,5724,null,null,10,0,0,0]
[11,0,0,5724,null,null,11,0,0,0]
[12,0,0,5724,null,null,12,0,0,0]
[13,0,0,5724,null,null,13,0,0,0]
[14,0,0,5724,null,null,14,0,0,0]
[15,0,0,5724,null,null,15,0,0,0]
[16,0,0,5724,null,null,16,0,0,0]
[17,0,0,5724,null,null,17,0,0,0]
[18,0,0,5724,null,null,18,0,0,0]
[19,0,0,5724,null,null,19,0,0,0]
[20,0,0,5724,null,null,20,0,0,0]
[21,0,0,5724,null,null,21,0,0,0]
[22,0,0,5724,null,null,22,0,0,0]
[23,0,0,5724,null,null,23,0,0,0]
[24,0,0,5724,null,null,24,0,0,0]
[25,0,0,5724,null,null,25,0,0,0]
[26,0,0,5724,null,null,26,0,0,0]
[27,0,0,5724,null,null,27,0,0,0]
[28,0,0,5724,null,null,28,0,0,0]
[29,0,0,5724,null,null,29,0,0,0]
[30,0,0,5724,null,null,30,0,0,0]
[31,0,0,5724,null,null,31,null,0]
[null,{"$f":"SUM(B44:B74)","v":0},{"$f":"SUM(C44:C74)","v":0},{"$f":"SUM(D44:D74)","v":160272},{"$f":"SUM(B75:D75)","v":160272},null,null,{"$f":"SUM(H44:H74)","v":0},{"$f":"SUM(I44:I74)","v":0},{"$f":"SUM(J44:J74)","v":0},{"$f":"SUM(H75:J75)","v":0}]

{"sheet":"Deleted Exhibit 2.5","index":41,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5]

{"sheet":"Deleted Exhibit 2.6","index":42,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Exhibit 1.1'!O31","v":"DEU Variance Exhibit"},{"$f":"'Exhibit 1.1'!P31","v":"Docket No. 19-057-01"},{"$f":"'Exhibit 1.1'!Q31","v":"Dominion Energy Utah"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6]