{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["NWPPA Dues"],"not_rendered":{"charts":0,"images":1,"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":"NWPPA Dues","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[3,0,3,6],[6,0,6,6],[4,0,4,6],[9,0,9,6],[32,0,32,5],[8,0,8,6],[15,0,15,6],[24,0,24,6]]}
[]
[]
[]
["MEMBERSHIP DUES INVESTMENT"]
["CALENDAR YEAR 2017"]
[]
["COMPUTATION FORM"]
[]
["Step 1"]
["List electric operating Kwh from retail sales to ultimate electric consumer (not for resale); number of electric meters; and number of electric utility employees (full-time equivalent)"]
[null,null,null,null,null,"Data Year ",2016]
[null,null,null,null,null,"Retail kWh sales of ",0]
[null,null,null,null,null,"# of Electric Meters ",0]
[null,null,null,null,null,"# of Electric Employees (FTE) ",0]
[]
["Step 2"]
["Apply Billing Determinants:"]
[null,null,null,null,null,"Base Investment",1000]
[null,"Rate"]
[null,2.4E-2,null,null,null,"GWh =  ",{"$f":"G12/1000*B20","v":0}]
[null,0.32,null,null,null,"Meter =  ",{"$f":"G13*B21","v":0}]
[null,40,null,null,null,"Employee =  ",{"$f":"G14*B22","v":0}]
[]
[null,null,null,null,null,"Subtotal",{"$f":"SUM(G18:G23)","v":1000}]
["Step 3"]
["Apply Billing Determinant Cap:"]
[null,null,null,null,null,"Base Investment",1000]
[null,"Factor"]
[null,0.8,null,null,null,"GWh Factor =  ",{"$f":"MIN(G20, $G$24*B29)","v":0}]
[null,0.7,null,null,null,"Meter Factor =  ",{"$f":"MIN(G21, $G$24*B30)","v":0}]
[null,0.25,null,null,null,"Employee Factor =  ",{"$f":"MIN(G22, $G$24*B31)","v":0}]
[]
["Total Investment***  ",null,null,null,null,null,{"$f":"MIN(F36, SUM(G27:G32))","v":1000}]
[]
[]
[null,null,null,null,"***Maximum Investment is",30000]