{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Requested and Completed Removal"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"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":"Requested and Completed Removal","index":0,"n_rows":17,"n_cols":29,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,9,0,13],[0,17,0,26]]}
[null,null,null,null,null,null,null,null,null,"Estimated Removal Costs Provided To Customer",null,null,null,null,null,null,null,"Actual Removal Costs"]
["Customer Reference","Date of Request","District","Request\n OR \nWork Order #","Customer Type","Annual kWH                                  Energy Usage","Annual Revenue                                  ","Reason for Removal","Date Estimate Provided","Customer's I&R Costs","Customer's Net Book Value","Customer's Salvage Credit","Credit from Original Line Extension","Customer's Total Removal Costs","Description of Work Required for Removal","Date Customer Paid","Date Removal Completed","Customer's I&R Costs","Outstanding Invoice","Customer's Net Book Value","Customer's Salvage Credit","Credit from Original Line Extension","Final Customer Removal Costs","Customer Advance Payment","Invoice or Refund Amount","Date of Final Invoice / Refund","Final Company Removal Costs","Explanation of Company Removal Costs","Comments"]
["AU","2016-05-31","Yakima",6195863,"Residential",15445,1342,"Going to another service provider. ","2016-07-12",4219,1898,0,0,6117,"REMOVE 175' OF 1#2-AS,N#2-AS OVERHEAD PRIMARY, 1PH DE POLE, 25KVA 1PH 120/240V OVERHEAD TRANSFORMER, 127' OF 1/0 TX OH SECONDARY, SECONDARY POLE, 30' OF OVERHEAD SERVICE AND METER 66528774 AND REMOVE 90' OF #2-TX OVERHEAD SERVICE AND METER 66528775 INTERSET 45' 1PH SLACK SPAN DE POLE, INSTALL GUY AND ANCHOR",null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["AW","2016-09-16","Yakima",6246528,"Commercial",106360,9177,"Going to another service provider. "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company is in the process of calculating the estimate"]
["AX","2016-03-15","Walla Walla",6160960,"Commercial",238596,19008,"Going to another service provider","2016-07-18",4482,5906,-1282,0,9107,"REMOVE 75 KVA, 2-50 KVA POLE MOUNT TRANSFORMERS, 20' 500 QUAD  SERVICE, AND C.T. METERING, INSTALL A 25 KVA POLE MOUNT TRANSFORMER.","2016-07-19",null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["AY","2016-03-15","Walla Walla",6160964,"Commercial",75000,6468,"Going to another service provider","2026-07-18",2461,2295,-230,0,4526,"REMOVE 3-50 KVA POLE MOUNT TRANSFORMERS(120/240V), 20' (3) 4/0 QUAD SERVICES, 200-5 C.T. METERING","2016-07-19",null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["AZ","2016-03-15","Walla Walla",6160965,"Commercial",8136,1090,"Going to another service provider","n/a",793,878,-6,0,1665,"REMOVE 85' #4 TX OH SERVICE, NON DEMAND METER","n/a",null,null,null,null,null,null,null,null,null,null,null,null,"Customer cancelled request."]
["BA","2016-03-15","Walla Walla",6160966,"Commercial",773136,56640,"Going to another service provider","2016-07-18",2400,3945,-1312,0,5032,"REMOVE 3-100 KVA POLE MOUNT TRANSFORMERS, (2) 4/0 QUAD SERVICES, 200:5 C.T. METERING","2016-07-19",null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["BB","2016-04-19","Walla Walla",6176337,"Commercial",1476,302,"Going to another service provider",null,null,null,null,null,null,null,"n/a",null,null,null,null,null,null,null,null,null,null,null,null,"Customer cancelled request."]
["BC","2016-04-19","Walla Walla",6176328,"Residential",848,234,"Going to another service provider",null,null,null,null,null,null,null,"n/a",null,null,null,null,null,null,null,null,null,null,null,null,"Customer cancelled request."]
["BE","2016-06-01","Walla Walla",6196289,"Irrigation",191560,19873,"Going to another service provider.","2016-06-01",18268,24049,-1735,0,40564,"REMOVE 40' 3 PH D/E POLE, 3-4\" PRIMARY RISERS, 2-3\" SERVICE RISERS, 90' 3 PH SLACK SPAN, 300KVA 3 PHASE PADMOUNT XFMR, 225 KVA 3 PH PANDOUNT XFMR, 75KVA 3 PHASE PADMOUNT XFMR, 1570' 3#2-AL PRIM UG, 85' 4/0-QD OVHD SVC, 160' #2-TX OVHD SVC, 100' 350-QD UG SVC, 25' 350-TX UG SVC, 60' 4/0-QD UG SVC, 120' 1/0-TX UG SVC, 115' 1/0-QD UG SVC AND 9 METERS","2016-05-26","2016-08-23",18057,0,21352,-1735,null,39834,-40564,-730,"2016-09-01",39834,"$14,331.00 was the purchase price for the facilities left in place.   Total job cost was $39,834 plus $14,331, for a total of $54,165.  Customer refunded balance from estimated upfront payment, of $730.00."]
["BF","2016-04-19","Walla Walla",6176342,"Commercial",43608,4513,"Going to another service provider.","2016-07-19",472,128,0,0,600,null,"2016-07-20",null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["BG","2016-09-07","Walla Walla",6241544,"Residential",27720,2419,"Going to another service provider.","2016-10-24"]
["BH","2016-11-14","Walla Walla",6257537,"Commercial",6768,750,"Going to another service provider.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["BI","2016-10-18","Walla Walla",6263222,"Residential",23028,2004,"Going to another service provider","2016-12-01",704,376,-17,0,1063,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waiting on customer to proceed."]
["BJ","2016-11-14","Walla Walla",6276729,"Residential",21252,1943,"Going to another service provider",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company is in the process of calculating the estimate"]
["BK","2016-12-07","Walla Walla",6287130,"Commercial",20220,1737,"Going to another service provider",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Company is in the process of calculating the estimate"]