{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Customer","Subaccount"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Customer","index":0,"n_rows":7,"n_cols":36,"rows_kept":7,"merged":[[4,0,5,0],[4,1,5,1]]}
["Real-Time Energy Market Summary 5 Minute Report",{"$nulls":15},"Real-Time Energy Market Summary 5 Minute Report",{"$nulls":13},"Real-Time Energy Market Summary 5 Minute Report"]
["SR_RTCUSTSUM5MIN_<customer id>_<settlement date>_<version>.CSV",{"$nulls":15},"SR_RTCUSTSUM5MIN_<customer id>_<settlement date>_<version>.CSV",{"$nulls":13},"SR_RTCUSTSUM5MIN_<customer id>_<settlement date>_<version>.CSV"]
["<Customer Name>",{"$nulls":15},"<Customer Name>",{"$nulls":13},"<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":15},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":13},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Trading Interval","Hour End","Customer Values",{"$nulls":9},"Pool Values",{"$nulls":9},"Customer","Pool","Customer",null,null,"Pool",null,null,"Customer",null,null,"Pool"]
[null,null,"Real Time Generation Obligation","Real Time Load Obligation","Real Time Adjusted Load Obligation","Real Time Adjusted Net Interchange","Real Time Energy Charge/Credit","Real Time Congestion Charge/Credit","Real Time Loss Charge/Credit","Real Time Marginal Loss Revenue Allocation","External Inadvertent Cost Distribution","Real Time Net Energy Settlement","Real Time Pool Generation Obligation","Real Time Pool Load Obligation","Real Time Pool Adjusted Load Obligation","Real Time Pool Energy Settlement","Real Time Pool Congestion Revenue","Real Time Pool Loss Revenue","Real Time Pool Emergency Cost","Real Time Pool External Inadvertent","Real Time Pool Marginal Loss Revenue","Day Ahead Pool Marginal Loss Revenue","Marginal Loss Revenue Load Obligation","Pool Marginal Loss Revenue Load Obligation","Real Time Generation Obligation For Charge Allocation","Real Time Load Obligation For Charge Allocation","Real Time Adjusted Net Interchange For Charge Allocation","Real Time Pool Generation Obligation For Charge Allocation","Real Time Pool Load Obligation For Charge Allocation","Real Time Pool Load Obligation Absolute Value For Charge Allocation","Real Time Demand Reduction Obligation","Real Time Load Obligation for Demand Reduction Allocation","Real Time Demand Reduction Credit","Real Time Pool Demand Reduction Obligation","Real Time Pool Load Obligation for Demand Reduction Allocation","Real Time Pool Demand Reduction Credit"]
["Interval Begin","Hour End","MW","MW","MW","MW","$","$","$","$","$","$","MW","MW","MW","$","$","$","$","$","$","$","MW","MW","MW","MW","MW","MW","MW","MW","MW","MW","$","MW","MW","$"]

{"sheet":"Subaccount","index":1,"n_rows":7,"n_cols":21,"rows_kept":7,"merged":[[4,2,5,2],[4,3,5,3]]}
["Real-Time Energy Market Summary 5 Minute Report"]
["SR_RTCUSTSUM5MIN_<customer id>_<settlement date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[null,null,"Trading Interval","Hour End","Subaccount Values"]
["Subaccount ID","Subaccount Name",null,null,"Real Time Generation Obligation","Real Time Load Obligation","Real Time Adjusted Load Obligation","Real Time Adjusted Net Interchange","Real Time Energy Charge/Credit","Real Time Congestion Charge/Credit","Real Time Loss Charge/Credit","Marginal Loss Revenue Load Obligation","Real Time Marginal Loss Revenue Allocation","External Inadvertent Cost Distribution","Real Time Net Energy Settlement","Real Time Generation Obligation For Charge Allocation","Real Time Load Obligation For Charge Allocation","Real Time Adjusted Net Interchange For Charge Allocation","Real Time Demand Reduction Obligation","Real Time Load Obligation for Demand Reduction Allocation","Real Time Demand Reduction Credit"]
["String","String","Interval Begin","Hour End","MW","MW","MW","MW","$","$","$","MW","$","$","$","MW","MW","MW","MW","MW","$"]