{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Market Identification","Filling Offer","Physical Notifications"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[30,1,30,2],[31,1,31,2],[22,1,22,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[28,1,28,2],[29,1,29,2]]}
["Version\n5.0","Steps to fill in the template:"]
[null,"Purpose: This layout helps to fill in the text file type (.xml) used to upload energy offers following the second way described in \"Operational procedure for establishing of the format, the content, the way of transmission and validation of the offers on the day-ahead electricity market\"."]
[null,"By uploading the text file type (.xml) in the trading system the entire offer of one type (sell or buy) allready existing in the DAM platform is replaced, whether it includes hourly and / or block offers. Consequently, it is necessary to keep the offer template filled in for initial offer in order to make changes on it. The Participant has the obligation and responsibility to check the data entered into the trading system."]
[null,"The template works with Microsoft Office versions newer than Office 2003."]
[null,"\"Market Identification\" Worksheet"]
[null,"Participant Code","The field participant code is the code assigned by the Administrator of the Trading System to each participant."]
[null,"Message Identifier","The field message identification is completed by the participant with an identifier that is suggestive in terms of offer name, type of offer and delivery date. It will be the name of the file generated with this template."]
[null,"Message Version","The field message version will be filled in only in sheet market identification and is automatically transferred to each interval in sheet filling offer.\nThis version shall be filled in in accordance with the offer's version for respective delivery day. The first offer uploaded for a specific delivery day will have the version 1. If you offer again for the same delivery day, the version must be higher than 1. Each change of the offer will trigger incrementation of the version."]
[null,"Offer Type","The field offer type represents the type of offer, namely:\n   X01 - this code is allocated for buying\n   X02 - this code is allocated for selling"]
[null,"Sender Identification","The same participant code corresponds to participant code in this worksheet."]
[null,"MessageDateTime","Representing the date and time when .XML file type offer is created (it is automatically filled in by the program)."]
[null,"Delivery Day","Choose the delivery day for which the offer is valid by using the cells D3, E3 and F3."]
[null,"Resolution","It is a system parameter which shall not be changed under no circumstances!"]
[null,"Location","The location in which the XML file will be saved. WARNING: Keep the form of \"Partition letter:\" + \"\\folder name\\\"."]
[null,"Time Zone","In the Cell G1 the representation of time depending on the time zone, respectively: summer day, day of transition from summer to winter (which includes 25 intervals), winter day, day of transition from winter to summer (which includes 23 intervals).\nWrong completion ot the offer for time intervals that are not valid (interval 25 in other day than the transition from summer to winter time, interval 24 in other day than the transition from winter time to summer time) has as effect that those intervals are not listed in the file .xml at its creation."]
[null,"Participant Limits","In the K2-K4 cells area participant can set limits to quantities and prices for placed hourly offers (pairs within the hourly offers and pairs for block offers). Exceeding these limits generates a red flag of the value placed in the sheet Filling Offer, but these limitations are only a for warning purpose.\nWARNING: if the value exceeding this limit is not rectified, it will be accepted as valid by clicking \"Create .XML File\" and implicitly validated by the trading platform when uploading the offer.\nWARNING: The limitation warning for quantity is not cumulative between hourly offers and block offers."]
[null,"Blue coloured cells reflects that appropriate information will be completed by the Participant within them."]
[null,"\"Filling Offer\" Worksheet"]
[null,"In the sheet \"Offer Filling\" participants will fill in with data (automatically with data from \"Market Identification\", except price-quantity pairs) separately for each trading interval:"]
[null,"The hourly offers are filled in the area between Line 8 and Line 39 as follows:"]
[null,"   a) offer type (participant will check if it was set correctly)"]
[null,"   b) price-quantity pairs must be sequenced by price in  increasing order (on sale - you can click the button Arrange Sell) or decreasing order (on buy - you can click the button Arrange Buy); if they do not comply with this prerequisite, a message will appear indicating that the offer is not properly drawn when trying to save."]
[null,"   c) if the price or quantity exceed the limits set in the sheet \"Market Identification\" the excel cell will turn red."]
[null,"The block offers are completed in the zone that begins with the line 45 as follows:"]
[null,"   a) \"Block Identifier\" is the exact defined name of block offer as it is set in the trading system."]
[null,"   b) \"Parent Block\" is the offer that is conditioned by the execution of the current block offer. This parameter is filled only for linked offers."]
[null,"If a particular block offer is linked to another block offer, you put the number of the parent block in the field \"Parent Block\".\nExample: If the Block offer No.3 (Block No.) is linked to No.1, in the cell \"Parent Block\" from block No.3 you put 1 (block number that is related to block offer 3).\nIn case of the block offer isn't related to any other block offer, simply let the \"Parent Block\" blank."]
[null,"To update all the information in Excel you can press F9."]
[null,"After fill into each trading interval and press F9, the user will return to the \"Market Identification\" sheet and press the \"Create .XML File\" button."]
[null,"The layout allows the creation of proper .xml file for each time of year (summer time, winter time, winter-to-summer time change and summer-to-winter time change). For this is added a selection box in the sheet \"Market Identification\" on cell G1. Selection is made by accessing the drop-down list that display options of these cells.\nIn order to keep the the selected type of time you've chosen, the template must be saved after selection.\nWARNING: The hourly intervals will be completed from left to right, in a row. Therefore, during the winter-summer time change (23 intervals) it will NOT skip over the 3 interval."]
[null,"\"Physical Notifications\" Worksheet"]
[null,"In the \"Physical Notifications\" sheet the participant has the opportunity to view the traded quantities in aggregate form by pressing the \"Physical Notifications\" button and selecting the \"TP Physical Notification\" file previously downloaded from the trading platform."]

{"sheet":"Market Identification","index":1,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,3,0,5],[2,9,3,9],[6,9,7,9],[10,1,10,10]]}
["Participant Code","PARTICIPANT",null,"Delivery Day",null,null,"Orar Vara"]
["Message Identifier","oferta_v_c_zz.ll.aaa",null,"Day","Month","Year",null,null,null,"Quantity Limit",99.9,null,null,1,2019]
["Message Version",1,null,5,4,2019,null,null,null,"Price Limit",-9.99,"(Minimum Price)",null,2,2020,null,"Orar Iarna"]
["Offer Type (buy/sell)","X02",null,null,null,null,null,null,null,null,199.99,"(Maximum Price)",null,3,2021,null,"Schimbare orar Iarna - Vara"]
["Sender Identification",{"$f":"B1","v":"PARTICIPANT"},null,"2019-04-05",null,null,null,null,null,null,null,null,null,4,2022,null,"Orar Vara"]
["MessageDateTime","2019-08-30T10:36:09Z",null,null,null,null,null,null,null,null,null,null,null,5,2023,null,"Schimbare orar Vara - Iarna"]
["Transaction Day","2019-04-04T22:00Z/2019-04-05T22:00Z",null,null,null,null,null,null,null,"Offer Type","X01","(Buy)",null,6,2024]
["Resolution","PT1H",null,null,null,null,null,null,null,null,"X02","(Sell)",null,7,2025]
["Location","C:\\Temp\\",null,null,null,null,null,null,null,null,null,null,null,8,2026]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9,2027]
[null,{"$f":"\"By pressing the button above you will generate an \"&IF(B4=\"X02\",\"SELL\",\"BUY\")&\" offer with a total amount of \"&SUM('Filling Offer'!C40,'Filling Offer'!E40,'Filling Offer'!G40,'Filling Offer'!I40,'Filling Offer'!K40,'Filling Offer'!M40,'Filling Offer'!O40,'Filling Offer'!Q40,'Filling Offer'!S40,'Filling Offer'!U40,'Filling Offer'!W40,'Filling Offer'!Y40,'Filling Offer'!AA40,'Filling Offer'!AC40,'Filling Offer'!AE40,'Filling Offer'!AG40,'Filling Offer'!AI40,'Filling Offer'!AK40,'Filling Offer'!AM40,'Filling Offer'!AO40,'Filling Offer'!AQ40,'Filling Offer'!AS40,'Filling Offer'!AU40,'Filling Offer'!AW40,'Filling Offer'!AY40,'Filling Offer'!D45:D64)&\" MWh/h\"","v":"By pressing the button above you will generate an SELL offer with a total amount of 0 MWh/h"},null,null,null,null,null,null,null,null,null,null,null,10,2028]
[null,null,null,null,null,null,null,null,null,null,null,null,"Andrei ERIMESCU 02.04.2019",11,2029]
[null,null,null,null,null,null,null,null,null,null,null,null,null,12,2030]
[null,null,null,null,null,null,null,null,null,null,null,null,null,13,2031]
[null,null,null,null,null,null,null,null,null,null,null,null,null,14,2032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,2033]
[null,null,null,null,null,null,null,null,null,null,null,null,null,16,2034]
[null,null,null,null,null,null,null,null,null,null,null,null,null,17,2035]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,2036]
[null,null,null,null,null,null,null,null,null,null,null,null,null,19,2037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,20,2038]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,2039]
[null,null,null,null,null,null,null,null,null,null,null,null,null,22,2040]
[null,null,null,null,null,null,null,null,null,null,null,null,null,23,2041]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,2042]
[null,null,null,null,null,null,null,null,null,null,null,null,null,25,2043]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,2044]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,2045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,28,2046]
[null,null,null,null,null,null,null,null,null,null,null,null,null,29,2047]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,2048]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,2049]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2050]

{"sheet":"Filling Offer","index":2,"n_rows":64,"n_cols":51,"rows_kept":64,"cut":false,"hidden":false,"merged":[[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[43,1,43,2],[48,1,48,2],[0,47,0,48],[0,49,0,50],[0,35,0,36],[0,37,0,38],[0,39,0,40],[0,41,0,42],[0,43,0,44],[0,45,0,46],[0,23,0,24],[0,25,0,26],[0,27,0,28],[0,29,0,30],[0,31,0,32],[0,33,0,34],[0,11,0,12],[0,13,0,14],[0,15,0,16],[0,17,0,18],[0,19,0,20],[0,21,0,22],[0,9,0,10],[0,0,6,0],[0,1,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,8],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2]]}
["Quantity - Price Pair No.",1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,null,10,null,11,null,12,null,13,null,14,null,15,null,16,null,17,null,18,null,19,null,20,null,21,null,22,null,23,null,24,null,25]
[null,"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"},"Message Identifier",{"$f":"'Market Identification'!B2","v":"oferta_v_c_zz.ll.aaa"}]
[null,"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1},"Message Version",{"$f":"'Market Identification'!B3","v":1}]
[null,"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"},"Offer Type (buy/sell)",{"$f":"IF('Market Identification'!B4=\"X01\",\"BUY\",\"SELL\")","v":"SELL"}]
[null,"Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P","Transaction Zone","10YRO-TEL------P"]
[null,"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"},"Participant Code",{"$f":"'Market Identification'!B1","v":"PARTICIPANT"}]
[null,"Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price","Quantity","Price"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[null,"Hourly Quantity",{"$f":"SUM(B8:B39)","v":0},"Hourly Quantity",{"$f":"SUM(D8:D39)","v":0},"Hourly Quantity",{"$f":"SUM(F8:F39)","v":0},"Hourly Quantity",{"$f":"SUM(H8:H39)","v":0},"Hourly Quantity",{"$f":"SUM(J8:J39)","v":0},"Hourly Quantity",{"$f":"SUM(L8:L39)","v":0},"Hourly Quantity",{"$f":"SUM(N8:N39)","v":0},"Hourly Quantity",{"$f":"SUM(P8:P39)","v":0},"Hourly Quantity",{"$f":"SUM(R8:R39)","v":0},"Hourly Quantity",{"$f":"SUM(T8:T39)","v":0},"Hourly Quantity",{"$f":"SUM(V8:V39)","v":0},"Hourly Quantity",{"$f":"SUM(X8:X39)","v":0},"Hourly Quantity",{"$f":"SUM(Z8:Z39)","v":0},"Hourly Quantity",{"$f":"SUM(AB8:AB39)","v":0},"Hourly Quantity",{"$f":"SUM(AD8:AD39)","v":0},"Hourly Quantity",{"$f":"SUM(AF8:AF39)","v":0},"Hourly Quantity",{"$f":"SUM(AH8:AH39)","v":0},"Hourly Quantity",{"$f":"SUM(AJ8:AJ39)","v":0},"Hourly Quantity",{"$f":"SUM(AL8:AL39)","v":0},"Hourly Quantity",{"$f":"SUM(AN8:AN39)","v":0},"Hourly Quantity",{"$f":"SUM(AP8:AP39)","v":0},"Hourly Quantity",{"$f":"SUM(AR8:AR39)","v":0},"Hourly Quantity",{"$f":"SUM(AT8:AT39)","v":0},"Hourly Quantity",{"$f":"SUM(AV8:AV39)","v":0},"Hourly Quantity",{"$f":"SUM(AX8:AX39)","v":0}]
[]
[]
[]
["Block No.","Block Identifier",null,"Quantity","Price","Parent Block"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Physical Notifications","index":3,"n_rows":102,"n_cols":4,"rows_kept":102,"cut":false,"hidden":false,"merged":[[102,0,105,3],[0,0,1,0],[0,3,1,3],[0,1,0,2]]}
[null,"Average Power Traded on DAM"]
[null,"Sell","Buy"]
["Interval 1",null,null,"MW"]
["Interval 2",null,null,"MW"]
["Interval 3",null,null,"MW"]
["Interval 4",null,null,"MW"]
["Interval 5",null,null,"MW"]
["Interval 6",null,null,"MW"]
["Interval 7",null,null,"MW"]
["Interval 8",null,null,"MW"]
["Interval 9",null,null,"MW"]
["Interval 10",null,null,"MW"]
["Interval 11",null,null,"MW"]
["Interval 12",null,null,"MW"]
["Interval 13",null,null,"MW"]
["Interval 14",null,null,"MW"]
["Interval 15",null,null,"MW"]
["Interval 16",null,null,"MW"]
["Interval 17",null,null,"MW"]
["Interval 18",null,null,"MW"]
["Interval 19",null,null,"MW"]
["Interval 20",null,null,"MW"]
["Interval 21",null,null,"MW"]
["Interval 22",null,null,"MW"]
["Interval 23",null,null,"MW"]
["Interval 24",null,null,"MW"]
["Interval 25",null,null,"MW"]
["Interval 26",null,null,"MW"]
["Interval 27",null,null,"MW"]
["Interval 28",null,null,"MW"]
["Interval 29",null,null,"MW"]
["Interval 30",null,null,"MW"]
["Interval 31",null,null,"MW"]
["Interval 32",null,null,"MW"]
["Interval 33",null,null,"MW"]
["Interval 34",null,null,"MW"]
["Interval 35",null,null,"MW"]
["Interval 36",null,null,"MW"]
["Interval 37",null,null,"MW"]
["Interval 38",null,null,"MW"]
["Interval 39",null,null,"MW"]
["Interval 40",null,null,"MW"]
["Interval 41",null,null,"MW"]
["Interval 42",null,null,"MW"]
["Interval 43",null,null,"MW"]
["Interval 44",null,null,"MW"]
["Interval 45",null,null,"MW"]
["Interval 46",null,null,"MW"]
["Interval 47",null,null,"MW"]
["Interval 48",null,null,"MW"]
["Interval 49",null,null,"MW"]
["Interval 50",null,null,"MW"]
["Interval 51",null,null,"MW"]
["Interval 52",null,null,"MW"]
["Interval 53",null,null,"MW"]
["Interval 54",null,null,"MW"]
["Interval 55",null,null,"MW"]
["Interval 56",null,null,"MW"]
["Interval 57",null,null,"MW"]
["Interval 58",null,null,"MW"]
["Interval 59",null,null,"MW"]
["Interval 60",null,null,"MW"]
["Interval 61",null,null,"MW"]
["Interval 62",null,null,"MW"]
["Interval 63",null,null,"MW"]
["Interval 64",null,null,"MW"]
["Interval 65",null,null,"MW"]
["Interval 66",null,null,"MW"]
["Interval 67",null,null,"MW"]
["Interval 68",null,null,"MW"]
["Interval 69",null,null,"MW"]
["Interval 70",null,null,"MW"]
["Interval 71",null,null,"MW"]
["Interval 72",null,null,"MW"]
["Interval 73",null,null,"MW"]
["Interval 74",null,null,"MW"]
["Interval 75",null,null,"MW"]
["Interval 76",null,null,"MW"]
["Interval 77",null,null,"MW"]
["Interval 78",null,null,"MW"]
["Interval 79",null,null,"MW"]
["Interval 80",null,null,"MW"]
["Interval 81",null,null,"MW"]
["Interval 82",null,null,"MW"]
["Interval 83",null,null,"MW"]
["Interval 84",null,null,"MW"]
["Interval 85",null,null,"MW"]
["Interval 86",null,null,"MW"]
["Interval 87",null,null,"MW"]
["Interval 88",null,null,"MW"]
["Interval 89",null,null,"MW"]
["Interval 90",null,null,"MW"]
["Interval 91",null,null,"MW"]
["Interval 92",null,null,"MW"]
["Interval 93",null,null,"MW"]
["Interval 94",null,null,"MW"]
["Interval 95",null,null,"MW"]
["Interval 96",null,null,"MW"]
["Interval 97",null,null,"MW"]
["Interval 98",null,null,"MW"]
["Interval 99",null,null,"MW"]
["Interval 100",null,null,"MW"]