{"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":14,"rows_kept":7}
["Subaccount Bill Details - for INFORMATION ONLY"]
["BL_DETAILSSUB_<customerid>_<settlementdate>_<version>_<subaccountid).CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Subaccount",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","DA Ancillary Services Market","DA Ancillary Services Report Version Date"]
["String","String","Date","Hour End","$","$","$","Timestamp","Timestamp","Timestamp","$","Timestamp","$","Timestamp"]

{"sheet":"Daily Bill Detail","index":1,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[4,8,4,10],[4,11,4,12]]}
["Subaccount Bill Details - for INFORMATION ONLY"]
["BL_DETAILSSUB_<customerid>_<settlementdate>_<version>_<subaccountid).CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Subaccount",null,"Billing Period",null,"Daily Markets",{"$nulls":3},"Monthly Markets Billed Daily",null,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","FCM Daily Credits","FCM Daily Charges","FCM Daily Report Version Date","Inventoried Energy Program","Inventoried Energy Program Version Date"]
["String","String","Date","Hour End","$","$","Timestamp","Timestamp","$","$","Timestamp","$","Timestamp"]

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

{"sheet":"Bill Line Items","index":3,"n_rows":7,"n_cols":8,"rows_kept":7}
["Subaccount Bill Details - for INFORMATION ONLY"]
["BL_DETAILSSUB_<customerid>_<settlementdate>_<version>_<subaccountid).CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Subaccount",null," "]
["Subaccount ID","Subaccount Name","Trading Interval Date","Trading Interval","Description","Dollar Amount","Quantity","Unit Of Measure"]
["String","String","Date","Hour End","String","$","Number","String"]

{"sheet":"Standard Settlement Details","index":4,"n_rows":7,"n_cols":7,"rows_kept":7}
["Subaccount Bill Details - for INFORMATION ONLY"]
["BL_DETAILSSUB_<customerid>_<settlementdate>_<version>_<subaccountid).CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Subaccount",null," "]
["Subaccount ID","Subaccount Name","Trading Interval Date","Trading Interval","Description","Dollar Amount","Report Version Date"]
["String","String","Date","Hour End","String","$","Timestamp"]