{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Zonal Supply Tab","Zonal Requirement Tab","Customer Tab","Proxy Price"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Zonal Supply Tab","index":0,"n_rows":11,"n_cols":9,"rows_kept":11}
["Forward Reserve Auction Clearing Result Customer Report"]
["SR_LFRARESULT_<customer id>_<auction period_begin_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <MM/DD/YYYY> and Version: <MM/DD/YYYY HH:MI:SS> GMT"]
[]
["Auction Name","Service Period Begin Date","Service Period End Date","Reserve Zone ID","Reserve Zone Name","Reserve Product","Reserve Supply Offered","Reserve Supply Cleared","Forward Reserve Clearing Price"]
["String","Date","Date","Number","String","String","MW","MW","$/MW-Month"]
[]
[]
[]
["Note: Reserve Product reported here are TMNSR and TMOR"]

{"sheet":"Zonal Requirement Tab","index":1,"n_rows":12,"n_cols":9,"rows_kept":12}
["Forward Reserve Auction Clearing Result Customer Report"]
["SR_LFRARESULT_<customer id>_<auction period_begin_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <MM/DD/YYYY> and Version: <MM/DD/YYYY HH:MI:SS> GMT"]
[]
["Auction Name","Service Period Begin Date","Service Period End Date","Reserve Zone ID","Reserve Zone Name","Reserve Product","Local Supply Constraint Flag (Y/N)","Reserve Requirement Target","Reserve Requirement Cleared"]
["String","Date","Date","Number","String","String","Flag","MW","MW"]
[]
[]
[]
["Note: Reserve Product reported here are TMNSR and Combined Reserve (TMNSR+TMOR)"]
["Effective Service Period Begin Date 06/01/2011 - Local Supply Constraine Flag is reported as NULL"]

{"sheet":"Customer Tab","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"merged":[[4,2,4,3],[4,4,4,5]]}
["Forward Reserve Auction Clearing Result Customer Report"]
["SR_LFRARESULT_<customer id>_<auction period_begin_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <MM/DD/YYYY> and Version: <MM/DD/YYYY HH:MI:SS> GMT"]
[null,null,"TMNSR",null,"TMOR"]
["Reserve Zone ID","Reserve Zone Name","TMNSR Total Offered","TMNSR Cleared","TMOR Total Offered","TMOR Cleared","Total Cleared"]
["Number","String","MW","MW","MW","MW","MW"]

{"sheet":"Proxy Price","index":3,"n_rows":11,"n_cols":5,"rows_kept":11}
["Forward Reserve Auction Clearing Result Customer Report"]
["SR_LFRARESULT_<customer id>_<auction period_begin_date>_<version>.CSV"]
["<Customer Name>"]
["Date: <MM/DD/YYYY> and Version: <MM/DD/YYYY HH:MI:SS> GMT"]
[]
["Auction Name","Service Period Begin Date","Service Period End Date","Reserve Product","Forward Reserve Proxy Price"]
["String","Date","Date","String","$/MW-Month"]
[]
[]
[]
["Note: Reserve Product reported here are TMNSR and TMOR"]