{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Hourly Bill Detail","Daily Bill Detail","Bill Adj Detail","Bill Line Items","Standard Settlement Details"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Hourly Bill Detail","index":0,"n_rows":7,"n_cols":10,"rows_kept":7}
["Bill Details"]
["BL_DETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Billing Period",null,"Hourly Markets",{"$nulls":5},"Hourly Markets"]
["Trading Interval  Date","Trading Interval Hour","DAY AHEAD Energy Market                ","REAL TIME Energy Market","REGULATION Market                   ","DAY AHEAD Report Version Date","REAL TIME Report Version Date","REGULATION Report Version Date","RESERVE Market","RESERVE Report Version Date"]
["Date","Hour End","$","$","$","Timestamp","Timestamp","Timestamp","$","Timestamp"]

{"sheet":"Daily Bill Detail","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[4,2,4,5],[4,6,4,8],[4,9,4,10]]}
["Bill Details"]
["BL_DETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Billing Period",null,"Daily Markets",{"$nulls":3},"Monthly Markets Billed Daily",null,null,"Daily Markets"]
["Trading Interval  Date","Trading Interval Hour","DAY AHEAD NCPC Market                   ","REAL TIME NCPC Market                 ","DAY AHEAD NCPC Report Version Date","REAL TIME NCPC Report Version Date","FCM Daily Credits","FCM Daily Charges","FCM Daily Report Version Date","Inventoried Energy Program","Inventoried Energy Program Version Date"]
["Date","Hour End","$","$","Timestamp","Timestamp","$","$","Timestamp","$","Timestamp"]

{"sheet":"Bill Adj Detail","index":2,"n_rows":7,"n_cols":7,"rows_kept":7}
["Bill Adjustment Details "]
["BL_DETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[" Billing Period"]
["Trading Interval  Date","Trading Interval Hour","Market Service","Roll Back Amount                  ","New Amount                  ","Adjustment Amount                  ","Report Version Date"]
["Date","Hour End","String","$","$","$","Timestamp"]

{"sheet":"Bill Line Items","index":3,"n_rows":7,"n_cols":6,"rows_kept":7}
["Bill Adjustment Line Items Details "]
["BL_DETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[" "]
["Trading Interval  Date","Trading Interval Hour","Description","Dollar Amount                  ","Quantity                  ","Unit of Measure"]
["Date","Hour End","String","$","Number","String"]

{"sheet":"Standard Settlement Details","index":4,"n_rows":7,"n_cols":5,"rows_kept":7}
["Standard Settlement Details"]
["BL_DETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[" "]
["Trading Interval  Date","Trading Interval Hour","Description","Dollar Amount                  ","Report Version Date"]
["Date","Hour End","String","$","Timestamp"]