{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["NCPC Daily Settlement - Subacct","Economic Charges-Subaccount","Economic Hrly Chrg Dtl-Subacct","LSCPR Charges - Subaccount","Asset SCR Charges","Performance Audit Charge-Subacc"," Posturing Charges -Subaccount","Rapid Resp Pricing Opp - subact","DLOC Charge-Subaccount","HrlyMin Gen Emerg Chrg-Subacct"],"not_rendered":{"defined_names":24},"read":"whole","date_system":"1900"}

{"sheet":"NCPC Daily Settlement - Subacct","index":0,"n_rows":7,"n_cols":23,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report ",{"$nulls":15},"              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV",{"$nulls":15},"SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.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"]
[]
["Subaccount ID","Subaccount Name","Real-Time Economic NCPC Charge","Real-Time LSCPR NCPC Charge","Real-Time SCR NCPC Charge","Real-Time Generator Performance Audit NCPC Charge","Real-Time Minimum Generation Emergency NCPC Charge","Real-Time Posturing NCPC Charge","Real-Time Non-VAR NCPC Charge","Real-Time Economic NCPC Credit","Real-Time LSCPR NCPC Credit","Real-Time SCR NCPC Credit","Real-Time Generator Performance Audit NCPC Credit","Real-Time Minimum Generation Emergency NCPC Credit","Real-Time Posturing NCPC Credit","Real-Time Non-VAR NCPC Credit","Net Real-Time Non-VAR NCPC Settlement","Real-Time LV VAR NCPC Credit","Real-Time HV VAR NCPC Credit","Rapid Response Pricing Opportunity Cost NCPC Charge","Rapid Response Pricing Opportunity Cost NCPC Credit","Dispatch Lost Opportunity Cost NCPC Charge","Dispatch Lost Opportunity Cost NCPC Credit"]
["String","String","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$","$"]

{"sheet":"Economic Charges-Subaccount","index":1,"n_rows":7,"n_cols":11,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Pool Real-Time Economic NCPC Credits","Real-Time NCPC Load Obligation Deviation ","Real-Time Generation Deviation ","Real-Time Increment Deviation ","Real-Time NCPC Import Deviation ","Real-Time Deviation ","Pool Real-Time Deviation ","Real-Time Economic NCPC  Charge","Real-Time Demand Reduction Deviation"]
["String","String","$","MWh","MWh","MWh","MWh","MWh","MWh","$","MWh"]

{"sheet":"Economic Hrly Chrg Dtl-Subacct","index":2,"n_rows":7,"n_cols":18,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Trading Interval","Real-Time Load Obligation Deviation ","Dispatchable Asset Related Demand Deviation Adjustment MW","Real-Time NCPC Load Obligation Deviation ","Total Subaccount Real-Time NCPC Load Obligation Deviation ","Real-Time NCPC Load Obligation Deviation Pro-Rata Allocator","Participant Real-Time NCPC Load Obligation Deviation ","Final Real-Time NCPC Load Obligation Deviation","Real-Time Import Deviation ","Real-Time NCPC Import Deviation ","Total Subaccount Real-Time NCPC Import Deviation ","Real-Time NCPC Import Deviation Pro-Rata Allocator","Participant Real-Time NCPC Import Deviation ","Final Real-Time NCPC Import Deviation","Real-Time Export Deviation Reduction MW","Real-Time Import Deviation Reduction MW"]
["String","String","Hour End","MWh","MWh","MWh","MWh","%","MWh","MWh","MWh","MWh","MWh","%","MWh","MWh","MWh","MWh"]

{"sheet":"LSCPR Charges - Subaccount","index":3,"n_rows":7,"n_cols":10,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Reliability Region","Pool Real-Time LSCPR NCPC Credits","Real-Time External Sale Load Obligation MW","Real-Time Dispatchable ARD Load Obligation Reduction MW","Real-Time LSCPR NCPC Load Obligation","Pool Real-Time LSCPR NCPC Load Obligation","Real-Time LSCPR NCPC Charge","Real-Time Load Obligation for Charge Allocation"]
["String","String","Number","$","MWh","MWh","MWh","MWh","$","MWh"]

{"sheet":"Asset SCR Charges","index":4,"n_rows":7,"n_cols":6,"rows_kept":7}
[null,null,"              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
[null,null,"SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
[null,null,"<Customer Name>"]
[null,null,"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Trading Interval","Asset ID","Asset Name","Real-Time SCR NCPC Charge"]
["String","String","Hour End","Number","String","$"]

{"sheet":"Performance Audit Charge-Subacc","index":5,"n_rows":7,"n_cols":8,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Pool Real-Time Generator Performance Audit NCPC Credits","Real-Time Dispatchable ARD Load Obligation Reduction MW","Real-Time Generator Performance Audit NCPC Load Obligation","Pool Real-Time Generator Performance Audit NCPC Load Obligation","Real-Time Generator Performance Audit NCPC Charge","Real-Time Load Obligation for Charge Allocation"]
["String","String","$","MWh","MWh","MWh","$","MWh"]

{"sheet":" Posturing Charges -Subaccount","index":6,"n_rows":14,"n_cols":8,"rows_kept":14}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Pool Posturing NCPC Credits","Dispatchable ARD MW ","Real-Time Postured NCPC Load Obligation","Pool Real-Time Postured NCPC Load Obligation","Real-Time Posturing NCPC Charge","Real-Time Load Obligation for Charge Allocation"]
["String","String","$","MWh","MWh","MWh","$","MWh"]
[]
[]
["This will report a row per subaccount"]
["Sort Order = Subaccount"]
[]
["Business Rule Mapping"]
[null,null,"Daily Economic Posturing Credit (120.30.10)","Subaccount/Customer Daily RTLO Postured DARD MW (120.30.70)","Subaccount Posturing Load Obligation (120.30.80)","Total Posturing Load Obligation (120.30.100)","Subaccount Posturing Charge (120.30.110)"]

{"sheet":"Rapid Resp Pricing Opp - subact","index":7,"n_rows":7,"n_cols":8,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Pool Rapid Response Pricing Opportunity Cost NCPC Credits","Real-Time Load Obligation for Charge Allocation","Real-Time Dispatchable ARD Load Obligation Reduction MW","Rapid Response Pricing Opportunity Cost NCPC Load Obligation","Pool Rapid Response Pricing Opportunity Cost Load NCPC Obligation","Rapid Response Pricing Opportunity Cost NCPC Charge"]
["String","String","$","MWh","MWh","MWh","MWh","$"]

{"sheet":"DLOC Charge-Subaccount","index":8,"n_rows":7,"n_cols":8,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Pool Dispatch Lost Opportunity Cost NCPC Credits","Real-Time Load Obligation for Charge Allocation","Real-Time Dispatchable ARD Load Obligation Reduction MW","Dispatch Lost Opportunity Cost NCPC Load Obligation","Pool Dispatch Lost Opportunity Cost Load NCPC Obligation","Dispatch Lost Opportunity Cost NCPC Charge"]
["String","String","$","MWh","MWh","MWh","MWh","$"]

{"sheet":"HrlyMin Gen Emerg Chrg-Subacct","index":9,"n_rows":7,"n_cols":11,"rows_kept":7}
["              Real-Time Net Commitment Period Compensation Settlement Summary Subaccount Report "]
["SR_RTNCPCSTLMNTSUMSUB_<customer id>_<settlement date>_<version>_<subaccount_id>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mi:ss> GMT"]
[]
["Subaccount ID","Subaccount Name","Trading Interval","Pool Minimum Generation Emergency NCPC Credits","Real-Time Generation Obligation for Charge Allocation","Real-Time Exempt Generation Obligation","Positive Real-Time Demand Reduction Obligation","Real-Time Exempt Demand Reduction Obligation","Minimum Generation Emergency Charge Allocation MW","Pool Minimum Generation Emergency Charge Allocation MW","Real-Time Minimum Generation Emergency NCPC Charge"]
["String","String","Hour End","$","MWh","MWh","MWh","MWh","MWh","MWh","$"]