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

{"sheet":"Customer","index":0,"n_rows":7,"n_cols":33,"rows_kept":7}
["Real-Time Energy Market Locational Summary 5 Minute Report",{"$nulls":15},"Real-Time Energy Market Locational Summary 5 Minute Report"]
["SR_RTLOCSUM5MIN_<customer id>_<settlement date>_<version>.CSV",{"$nulls":15},"SR_RTLOCSUM5MIN_<customer id>_<settlement date>_<version>.CSV"]
["<customer name>",{"$nulls":15},"<customer name>"]
["Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":15},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT"]
[null,null,"Locational Info",null,null,"Real-Time Generation Obligation",null,null,"Real-Time Load Obligation",{"$nulls":3},"Real-Time Adjusted Load Obligation",{"$nulls":4},"LMP Components",{"$nulls":5},"Marginal Loss Revenue Load Obligation",{"$nulls":3},"Customer "]
["Trading Interval","Hour End","Location Id","Location Name","Location Type","Revenue Metered Generation","Scheduled Imports","Real Time Generation Obligation","Revenue Metered Load","Scheduled Exports","Internal Bilateral For Load","Real Time Load Obligation","Real Time Internal Bilateral For Market Purchases","Real Time Internal Bilateral For Market Sales","Real Time Adjusted Load Obligation","Real Time Adjusted Net Interchange","Adjusted Net Interchange Deviation","Real Time Energy Component","Real Time Congestion Component","Real Time Marginal Loss Component","Real Time Energy Charge/Credit","Real Time Congestion Charge/Credit","Real Time Loss Charge/Credit","Real Time Internal Bilateral For Market Purchases Impacting MLRLO","Real Time Internal Bilateral For Market Sales Impacting MLRLO","Marginal Loss Revenue Load Obligation (MLRLO)","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","Demand Reduction Obligation Deviation","Real Time Demand Reduction Credit"]
["Interval Begin","Hour End","Number","String","String","MW","MW","MW","MW (-)","MW (-)","MW (+/-)","MW (-)","MW (+)","MW (-)","MW","MW","MW","$/MWh","$/MWh","$/MWh","$","$","$","MW (+)","MW (-)","MW","MW","MW","MW","MW","MW(-)","MW","$"]

{"sheet":"Subaccount","index":1,"n_rows":7,"n_cols":35,"rows_kept":7,"merged":[[4,28,4,34]]}
["Real Time Energy Market Locational Summary 5 Minute Report",{"$nulls":18},"Real Time Energy Market Locational Summary 5 Minute Report"]
["SR_RTLOCSUM5MIN_<customer id>_<settlement date>_<version>.CSV",{"$nulls":18},"SR_RTLOCSUM5MIN_<customer id>_<settlement date>_<version>.CSV"]
["<customer name>",{"$nulls":18},"<customer name>"]
["Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":18},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT"]
[{"$nulls":4},"Locational Info",null,null,"Real-Time Generation Obligation",null,null,"Real-Time Load Obligation",{"$nulls":3},"Real-Time Adjusted Load Obligation",{"$nulls":4},"LMP Components",{"$nulls":5},"Marginal Loss Revenue Load Obligation",null,null,"Subaccount"]
["Subaccount ID","Subaccount Name","Trading Interval","Hour End","Location Id","Location Name","Location Type","Revenue Metered Generation","Scheduled Imports","Real Time Generation Obligation","Revenue Metered Load","Scheduled Exports","Internal Bilateral For Load","Real Time Load Obligation","Real Time Internal Bilateral For Market Purchases","Real Time Internal Bilateral For Market Sales","Real Time Adjusted Load Obligation","Real Time Adjusted Net Interchange","Adjusted Net Interchange Deviation","Real Time Energy Component","Real Time Congestion Component","Real Time Marginal Loss Component","Real Time Energy Charge/Credit","Real Time Congestion Charge/Credit","Real Time Loss Charge/Credit","Real Time Internal Bilateral For Market Purchases Impacting MLRLO","Real Time Internal Bilateral For Market Sales Impacting MLRLO","Marginal Loss Revenue Load Obligation (MLRLO)","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","Demand Reduction Obligation Deviation","Real Time Demand Reduction Credit"]
["String","String","Interval Begin","Hour End","Number","String","String","MW","MW","MW","MW (-)","MW (-)","MW (+/-)","MW (-)","MW (+)","MW (-)","MW","MW","MW","$/MWh","$/MWh","$/MWh","$","$","$","MW (+)","MW (-)","MW","MW","MW","MW","MW","MW(-)","MW","$"]