{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["_com.sap.ip.bi.xl.hiddensheet","B20"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":66,"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":"_com.sap.ip.bi.xl.hiddensheet","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"B20","index":1,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["Customer Advances"]
["Average of Monthly Averages Ending - June 2019"]
["Allocation Method - Washington Inter-Jurisdictional Allocation Methodology"]
["(Allocated in Thousands)"]
[]
["Primary Account",null,"Secondary Account",null,"Alloc","Total","Calif","Oregon","Wash","Wyoming","Wy-UPL","Utah","Idaho","Wy-PPL","FERC","Other"]
["2520000","CUST ADV CONSTRUCT","210550","Payments Received Uncompleted Projects","CAGE",-38085.111290000001,0,0,0,{"$f":"K11+N11","v":-8686.4792374058816},-7309.5360878287838,-25882.072827988708,-3496.9699056916452,-1376.9431495770987,-19.589318913762668,0]
["2520000","CUST ADV CONSTRUCT","210550","Payments Received Uncompleted Projects","OR",-1763.94943583333,0,-1763.94943583333,0,{"$f":"K12+N12","v":0},0,0,0,0,0,0]
["2520000","CUST ADV CONSTRUCT","210550","Payments Received Uncompleted Projects","SG",-19.119,-0.27091094202734428,-4.8846998110745758,-1.4934050005211479,-2.8942617008975224,-2.4280909831616926,-8.4363212458742538,-1.1328971430727841,-0.4661707177358298,-6.504156532374651E-3,0]
["2520000","CUST ADV CONSTRUCT","210550","Payments Received Uncompleted Projects","UT",-836.66247458333305,0,0,0,0,0,-836.66247458333305,0,0,0,0]
["2520000","CUST ADV CONSTRUCT","210553","Transmission Payments Received - Capital","CAGE",-6753.9548012499999,0,0,0,-1540.4468088515305,-1296.2618378448581,-4589.8868119835415,-620.1472408608746,-244.18497100667241,-3.4739395540525622,0]
["2520000","CUST ADV CONSTRUCT","210556","NET METER FEES-REFUNDABLE","UT",-240.336545,0,0,0,0,0,-240.336545,0,0,0,0]
["2520000","CUST ADV CONSTRUCT","210556","NET METER FEES-REFUNDABLE","WA",-2.96875,0,0,-2.96875,0,0,0,0,0,0,0]
["2520000","CUST ADV CONSTRUCT","285460","Transm Intercon Deposits - w/3rd Party","CAGE",-12300.5170795833,0,0,0,-2805.5106733851635,-2360.7932456213248,-8359.2476979130261,-1129.4318591906858,-444.71742776383849,-6.3268490944231628,0]
["2520000","CUST ADV CONSTRUCT","285460","Transm Intercon Deposits - w/3rd Party","SG",341.52798000000001,4.8393570160832677,87.256742475165112,26.677106184940982,51.70099651126602,43.373660167133579,150.70033755607076,20.237254711094668,8.3273363441324406,0.11618554537924156,0]
["2520000 Total",null,null,null,null,{"$f":"SUBTOTAL(9,F11:F19)","v":-59661.091396249962},4.5684460740559238,-1681.5773931692395,22.214951184419835,-12983.629984832209,-10925.645602110995,-39765.942341158407,-5227.4446481751838,-2057.984382721213,-29.280426173391529,0]
["Grand Total",null,null,null,null,{"$f":"SUBTOTAL(9,F11:F19)","v":-59661.091396249962},4.5684460740559238,-1681.5773931692395,22.214951184419835,-12983.629984832209,-10925.645602110995,-39765.942341158407,-5227.4446481751838,-2057.984382721213,-29.280426173391529,0]