{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Shortage Event","Resource Shortage Event","Resource Hourly","Supplemental Availability","Generation Asset Hourly","Import Contracts Hourly"],"not_rendered":{"defined_names":16},"read":"whole","date_system":"1900"}

{"sheet":"Shortage Event","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"merged":[[4,0,4,2],[4,3,4,4],[4,5,4,10]]}
["Forward Capacity Market Availability Settlement Detail Report"]
["SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Shoratge Event General",null,null,"Capacity Zone",null,"Shortage Event Details"]
["Shortage Event Date","Shortage Event ID","Shortage Event Status","Capacity Zone ID","Capacity Zone Name","Shortage Event Type","Shortage Event Begin","Shortage Event End","Shortage Event Hours","Shortage Event Cumulative Minutes","Shortage Event Penalty Factor"]
["Date","Number","String","Number","String","String","Time","Time","Number","Number","Number"]
[{"$nulls":6},"     "]
[" "," ",{"$nulls":3}," ",{"$nulls":4}," "]

{"sheet":"Resource Shortage Event","index":1,"n_rows":7,"n_cols":12,"rows_kept":7,"merged":[[4,0,4,11]]}
["Forward Capacity Market Availability Settlement Detail Report"]
["SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Resource Information"]
["Shortage Event Date","Shortage Event ID","Resource ID","Resource Name","Resource Type","Capacity Zone ID","Capacity Zone Name","External Interface Name","Shortage Event Availability Score","Shortage Event Availability Penalty","Subaccount ID","Subaccount Name"]
["Date","Number","Number","String","String","Number","String","String","Number","$","Number","String"]

{"sheet":"Resource Hourly","index":2,"n_rows":7,"n_cols":23,"rows_kept":7,"merged":[[4,0,4,3],[4,18,4,22]]}
["Forward Capacity Market Availability Settlement Detail Report",{"$nulls":17},"Forward Capacity Market Availability Settlement Detail Report"]
["SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV",{"$nulls":17},"SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>",{"$nulls":17},"<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":17},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Shortage Event Hour",{"$nulls":3},"Resource Information",{"$nulls":5},"Resource Availability Details",{"$nulls":7},"Supplemental Availability"]
["Shortage Event ID","Trading Date","Trading Interval","Trading Interval Shortage Minutes","Resource ID","Resource Name","Resource Type","Effective Capacity Supply Obligation","Capacity Network Resource Capability","Commercial Operation Status","Resource External Transaction Sale MW","Resource Non-Commercial Capacity Exempt MW","Resource Hourly Available MW","Final Supplemented MW","Resource Planned Outage Exempt MW","Resource Hourly Availability Adjustment MW","Resource Hourly Adjusted Available MW","Hourly Availability Score","Designated Supplemental MW","Available to Supplement","Final Supplementing MW","Subaccount ID","Subaccount Name"]
["Number","Date","Hour End","Minutes","Number","String","String","MW","MW","String","MW","MW","MW","MW","MW","MW","MW","Number","MW","MW","MW","Number","String"]

{"sheet":"Supplemental Availability","index":3,"n_rows":9,"n_cols":18,"rows_kept":9,"merged":[[4,0,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,17]]}
["Forward Capacity Market Availability Settlement Detail Report",{"$nulls":11},"Forward Capacity Market Availability Settlement Detail Report"]
["SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV",{"$nulls":11},"SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>",{"$nulls":11},"<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT",{"$nulls":11},"Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Resource Information",{"$nulls":9},"Supplemental Availability Contract",null,"Supplementing Resource",null,"Supplemented Resource "]
["Shortage Event ID","Trading Date","Trading Interval","Resource ID","Resource Name","Resource Type","Capacity Zone ID","Capacity Zone Name","Reserve Zone ID","Reserve Zone Name","Contract ID","Internal Reference ID","Supplementing Resource ID","Final Supplementing MW","Supplemented Resource ID","Final Supplemented MW","Subaccount ID","Subaccount Name"]
["Number","Date","Hour End","Number","String","String","Number","String","Number","String","Number","String","Number","MW","Number","MW","Number","String"]
[]
[{"$nulls":3}," "]

{"sheet":"Generation Asset Hourly","index":4,"n_rows":9,"n_cols":21,"rows_kept":9,"merged":[[4,0,4,10],[4,11,4,20]]}
["Forward Capacity Market Availability Settlement Detail Report",{"$nulls":13},"Forward Capacity Market Availability Detail Report"]
["SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV",{"$nulls":13},"SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>",{"$nulls":13},"<Customer Name>"]
["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"]
["Asset Information",{"$nulls":10},"Amount Delivered"]
["Shortage Event ID","Trading Date","Trading Interval","Resource ID","Asset ID","Asset Name","Asset Type","Cold Notification Time","Cold StartUp Time","Cold StartUp Exempt Flag","Denied Self- Schedule Flag","Performance Eco Max","TMNSR Designation","TMOR Designation","External Transaction Sales","Revenue Quality Metering","Asset Competitive Offer MW","Calculated Asset Hourly Available MW","Asset Hourly Override Description","Asset Hourly Available MW","Asset Available To Supplement"]
["Number","Date","Hour End","Number","Number","String","String","Hours","Hours","Flag","Flag","MW","MW","MW","MW","MW","MW","MW","String","MW","MW"]
[]
[{"$nulls":16}," "]

{"sheet":"Import Contracts Hourly","index":5,"n_rows":7,"n_cols":11,"rows_kept":7}
["Forward Capacity Market Availability Settlement Detail Report"]
["SD_FCMAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
[]
["Shortage Event ID","Trading Date","Trading Interval","Resource ID","External Schedule ID","Resource Offered MW","Resource Requested MW","Resource Delivered MW","Calculated Resource Hourly Available MW","Override Description","Resource Hourly Available MW"]
["Number","Date","Hour End","Number","Number","MW","MW","MW","MW","String","MW"]