{"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":12,"rows_kept":7,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11],[4,2,4,3]]}
["Bill Details"]
["BL_SUBDETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[null,null,"Billing Period",null,"Hourly Markets",{"$nulls":5},"Hourly Markets"]
["Subaccount ID","Subaccount Name","Trading Interval  Date","Trading Interval","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"]
["Number","String","Date","Hour End","$","$","$","Timestamp","Timestamp","Timestamp","$","Timestamp"]

{"sheet":"Daily Bill Detail","index":1,"n_rows":7,"n_cols":8,"rows_kept":7,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,2,4,3]]}
["Bill Details"]
["BL_SUBDETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[null,null,"Billing Period",null,"Daily Markets"]
["Subaccount ID","Subaccount Name","Trading Interval  Date","Trading Interval","DAY AHEAD NCPC Market                   ","REAL TIME NCPC Market                 ","Day Ahead Report Version Date","Real Time Report Version Date"]
["Number","String","Date","Hour End","$","$","Timestamp","Timestamp"]

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

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

{"sheet":"Standard Settlement Details","index":4,"n_rows":7,"n_cols":7,"rows_kept":7,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6]]}
["Standard Settlement Details"]
["BL_SUBDETAILS_<customerid>_<settlementdate>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[null,null," "]
["Subaccount ID","Subaccount Name","Trading Interval  Date","Trading Interval","Description","Dollar Amount                  ","Report Version Date"]
["Number","String","Date","Hour End","String","$","Timestamp"]