{"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":26,"rows_kept":7}
["Day Ahead Energy Market Locational Settlement Report",{"$nulls":7},"Day Ahead Energy Market Locational Settlement Report",{"$nulls":7},"Day Ahead Energy Market Locational Settlement Report"]
["SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":7},"SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":7},"SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV"]
["<customer name>",{"$nulls":7},"<customer name>",{"$nulls":7},"<customer name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":7},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":7},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[null,"Locational Info",null,null,"Day-ahead Generation Obligation",{"$nulls":3},"Day-ahead Load Obligation",{"$nulls":3},"Day-ahead Adjusted Load Obligation ",{"$nulls":3},"LMP Components"]
["Trading Interval","Location Id","Location Name","Location Type","Day Ahead Cleared Generation (A)","Day Ahead Cleared Increments (B)","Day Ahead Cleared Imports (C)","Day Ahead  Generation Obligation (D)","Day Ahead Cleared Demand Bids (E)","Day Ahead Cleared Decrements (F)","Day Ahead Cleared Exports (G)","Day Ahead Load Obligation (H)","Day Ahead Internal Bilateral For Purchases (I)","Day Ahead Internal Bilateral For Sales (J)","Day Ahead Adjusted Load Obligation (K)","Day Ahead Adjusted Net Interchange (L)","Day Ahead Energy Component","Day Ahead Congestion Component","Day Ahead Marginal Loss Component","Day Ahead Energy Charge / Credit","Day Ahead Congestion Charge / Credit","Day Ahead Loss Charge / Credit","Day Ahead Cleared Asset Related Demand Bids ","Day Ahead Load Obligation For Charge Allocation","Day Ahead Demand Reduction","Day Ahead Demand Reduction Obligation"]
["Hour End","Number","String","String","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":28,"rows_kept":7}
["Day Ahead Energy Market Locational Settlement Report",{"$nulls":9},"Day Ahead Energy Market Locational Settlement Report",{"$nulls":7},"Day Ahead Energy Market Locational Settlement Report"]
["SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":9},"SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV",{"$nulls":7},"SR_DALOCSUM_<customer id>_<settlement date>_<version>.CSV"]
["<Customer Name>",{"$nulls":9},"<Customer Name>",{"$nulls":7},"<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":9},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":7},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[{"$nulls":3},"Locational Info",null,null,"Day-ahead Generation Obligation",{"$nulls":3},"Day-ahead Load Obligation",{"$nulls":3},"Day-ahead Adjusted Load Obligation ",{"$nulls":3},"LMP Components"]
["Subaccount ID","Subaccount Name","Trading Interval","Location Id","Location Name","Location Type","Day Ahead Cleared Generation (A)","Day Ahead Cleared Increments (B)","Day Ahead Cleared Imports ©","Day Ahead  Generation Obligation (D)","Day Ahead Cleared Demand Bids (E)","Day Ahead Cleared Decrements (F)","Day Ahead Cleared Exports (G)","Day Ahead Load Obligation (H)","Day Ahead Internal Bilateral For Purchases (I)","Day Ahead Internal Bilateral For Sales (J)","Day Ahead Adjusted Load Obligation (K)","Day Ahead Adjusted Net Interchange (L)","Day Ahead Energy Component","Day Ahead Congestion Component","Day Ahead Marginal Loss Component","Day Ahead Energy Charge / Credit","Day Ahead Congestion Charge / Credit","Day Ahead Loss Charge / Credit","Day Ahead Cleared Asset Related Demand Bids","Day Ahead Load Obligation For Charge Allocation","Day Ahead Demand Reduction","Day Ahead Demand Reduction Obligation"]
["String","String","Hour End","Number","String","String","MWh","MWh","MWh","MWh","MWh","MWh","MWh","MWh","MWh","MWh","MWh","MWh","$","$","$","$","$","$","MWh","MWh","MWh","MWh"]