{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Customer","Subaccount","Customer 15Minute CTS Location","Subaccount 15Min CTS Location"],"not_rendered":{"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Customer","index":0,"n_rows":7,"n_cols":33,"rows_kept":7}
["Real Time Energy Market Locational Summary Report",{"$nulls":13},"Real Time Energy Market Locational Summary Report",{"$nulls":10},"Real Time Energy Market Locational Summary Report"]
["SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":13},"SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":10},"SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV"]
["<customer name>",{"$nulls":13},"<customer name>",{"$nulls":10},"<customer name>"]
["Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":13},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":10},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT"]
[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",null,null,"Customer "]
["Trading Interval","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","Real Time Demand Reduction Charge"]
["Hour End","Number","String","String","MWh","MWh","MWh","MWh (-)","MWh (-)","MWh (+/-)","MWh (-)","MWh (+)","MWh (-)","MWh","MWh","MWh","$","$","$","$","$","$","MWh (+)","MWh (-)","MWh","MWh","MWh","MWh","MWh","MWh(-)","MWh","$","$"]

{"sheet":"Subaccount","index":1,"n_rows":7,"n_cols":35,"rows_kept":7,"merged":[[4,27,4,34]]}
["Real Time Energy Market Locational Summary Report",{"$nulls":12},"Real Time Energy Market Locational Summary Report",{"$nulls":10},"Real Time Energy Market Locational Summary Report"]
["SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":12},"SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":10},"SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV"]
["<customer name>",{"$nulls":12},"<customer name>",{"$nulls":10},"<customer name>"]
["Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":12},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":10},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT"]
[{"$nulls":3},"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","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","Real Time Demand Reduction Charge"]
["Number","String","Hour End","Number","String","String","MWh","MWh","MWh","MWh (-)","MWh (-)","MWh (+/-)","MWh (-)","MWh (+)","MWh (-)","MWh","MWh","MWh","$","$","$","$","$","$","MWh (+)","MWh (-)","MWh","MWh","MWh","MWh","MWh","MWh(-)","MWh","$","$"]

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

{"sheet":"Subaccount 15Min CTS Location","index":3,"n_rows":7,"n_cols":31,"rows_kept":7}
["Real Time Energy Market Locational Summary Report",{"$nulls":20},"Real Time Energy Market Locational Summary Report"]
["SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":20},"SR_RTLOCSUM_<customer id>_<settlement date>_<version>.CSV"]
["<customer name>",{"$nulls":20},"<customer name>"]
["Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT",{"$nulls":20},"Date: <mm/dd/yyyy> and Version <mm/dd/yyyy hh:mi:ss> GMT"]
[{"$nulls":4},"Locational Info",null,null,"Real-Time Generation Obligation",{"$nulls":3},"Real-Time Load Obligation",{"$nulls":4},"Real-Time Adjusted Load Obligation",{"$nulls":5},"LMP Components",{"$nulls":5},"Marginal Loss Revenue Load Obligation"]
["Subaccount ID","Subaccount Name","Trading Interval","Hour End","Location Id","Location Name","Location Type","Revenue Metered Generation","Scheduled Imports","Real Time Generation Obligation","Real Time Generation Obligation For Charge Allocation","Revenue Metered Load ","Scheduled Exports","Internal Bilateral For Load","Real Time Load Obligation","Real Time Load Obligation For Charge Allocation","Real Time Internal Bilateral For Market Purchases","Real Time Internal Bilateral For Market Sales","Real Time Adjusted Load Obligation","Real Time Adjusted Net Interchange ","Real Time Adjusted Net Interchange For Charge Allocation","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)"]
["Number","String","Interval End","Hour End","Number","String","String","MWh","MWh","MWh","MWh","MWh (-)","MWh (-)","MWh (+/-)","MWh (-)","MWh","MWh (+)","MWh (-)","MWh","MWh","MWh","MWh","$","$","$","$","$","$","MWh (+)","MWh (-)","MWh"]