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

{"sheet":"Shortage Event","index":0,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[4,0,4,2]]}
["Forward Capacity Market Preliminary Availability Settlement Detail Report"]
["SD_FCMPREAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:mm:ss> GMT"]
["Shortage 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","Preliminary Shortage Event Penalty Factor"]
["Date","Number","String","Number","String","String","Time","Time","Number","Number","Number"]

{"sheet":"Resource Shortage Event","index":1,"n_rows":7,"n_cols":11,"rows_kept":7}
["Forward Capacity Market Preliminary Availability Settlement Detail Report"]
["SD_FCMPREAVAIL_<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","Preliminary Shortage Event Availability Score","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":17,"rows_kept":7,"merged":[[4,0,4,3]]}
["Forward Capacity Market Preliminary Availability Settlement Detail Report"]
["SD_FCMPREAVAIL_<customer id>_<settlement_date>_<version>.CSV"]
["<Customer Name>"]
["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",null,null,"Supplemental Availability"]
["Shortage Event ID","Trading Date","Trading Interval","Trading Interval Shortage Minutes","Resource ID","Resource Name","Resource Type","Capacity Supply Obligation","Capacity Network Resource Capability","Commercial Operation Status","Resource External Transaction Sale MW","Resource Hourly Available MW","Preliminary Hourly Availability Score","Designated Supplemental MW","Available to Supplement","Subaccount ID","Subaccount Name"]
["Number","Date","Hour End","Minutes","Number","String","String","MW","MW","String","MW","MW","Number","MW","MW","Number","String"]

{"sheet":"Generation Asset Hourly","index":3,"n_rows":7,"n_cols":21,"rows_kept":7,"merged":[[4,3,4,8]]}
["Forward Capacity Market Preliminary Availability Settlement Detail Report",{"$nulls":11},"Forward Capacity Market Preliminary Availability Settlement Detail Report"]
["SD_FCMPREAVAIL_<customer id>_<settlement_date>_<version>.CSV",{"$nulls":11},"SD_FCMPREAVAIL_<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"]
[{"$nulls":3},"Asset Information",{"$nulls":6},"Asset Availability Details"]
["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 Preliminary Asset Hourly Available MW","Asset Hourly Override Description","Preliminary 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"]

{"sheet":"Import Contracts Hourly","index":4,"n_rows":7,"n_cols":11,"rows_kept":7}
["Forward Capacity Market Preliminary Availability Settlement Detail Report"]
["SD_FCMPREAVAIL_<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"]