{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Input","CSV_Export"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Input","index":0,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,0,4]]}
["Краен срок за подаване - 9:30ч.\nПреди почивни дни се изпращат графици както за тях, така и за първия работен ден."]
[null,null,null,"Име на фирмата",null,null,null,null,"Смяна на час:"]
[null,null,null,"Булстат",null,null,null,null,"Пролет",{"$f":"DATE(YEAR($E$6),3,31)- MOD( WEEKDAY(  DATE(YEAR($E$6),3,31),2),7)","v":"1900-03-25"}]
[null,null,null,"Вид производство",null,null,null,null,"Есен",{"$f":"DATE(YEAR($E$6),10,31)- MOD( WEEKDAY(  DATE(YEAR($E$6),10,31),2),7)","v":"1900-10-28"}]
[null,null,null,"Име на централата",null,null,null,null,"Брой часове\n(Пресмята се автоматично след въвеждане на дата)",{"$f":"IF(E6=J3,23,IF(E6=J4,25,24))","v":24}]
[null,null,null,"Дата на графика"]
["Период",null,null,"БГ Време = CET + 1"]
["Начало","Край","Дата","Час","kW",null,null,null,"ФтЕЦ-Фотоволтаична ЕЦ","SOL"]
[{"$f":"TIME(D9-1,0,0)","v":"00:00:00"},{"$f":"TIME(D9,0,0)","v":"01:00:00"},{"$f":"IF(ROW(C9)-8<$J$5+1,   $E$6,  IF(ROW(C9)-8=$J$5+1,$E$6+1,\"\"))","v":"00:00:00"},1,null,null,null,null,"ВтЕЦ-Вятърна ЕЦ","WNL"]
[{"$f":"IF(B10=\"\",\"\",  B9)","v":"01:00:00"},{"$f":"IFERROR(TIME(D10,0,0),\"\")","v":"02:00:00"},"00:00:00",2,null,null,null,null,"ВЕЦ-Водна ЕЦ","WAL"]
[{"$f":"IF(B11=\"\",\"\",  B10)","v":"02:00:00"},{"$f":"IFERROR(TIME(D11,0,0),\"\")","v":"03:00:00"},"00:00:00",{"$f":"D10+MAX(25-$J$5,1)","v":3},null,null,null,null,"БмЕЦ-ЕЦ на Биомаса","BIP"]
["03:00:00","04:00:00","00:00:00",{"$f":"D11+MIN(25-$J$5,1)","v":4},null,null,null,null,"КоГен-Когенерация","EGZ"]
["04:00:00","05:00:00","00:00:00",{"$f":"IF(C13<>\"\",MOD(D12+1,24),\"\")","v":5}]
["05:00:00","06:00:00","00:00:00",{"$f":"IF(C14<>\"\",MOD(D13+1,24),\"\")","v":6},null,null,null,null,"Избор:",{"$f":"IFERROR(INDEX(J8:J12,MATCH(E4,I8:I12,0)),\"TYPE\")","v":"TYPE"}]
["06:00:00","07:00:00","00:00:00",7]
["07:00:00","08:00:00","00:00:00",8]
["08:00:00","09:00:00","00:00:00",9]
["09:00:00","10:00:00","00:00:00",10]
["10:00:00","11:00:00","00:00:00",11]
["11:00:00","12:00:00","00:00:00",12]
["12:00:00","13:00:00","00:00:00",13]
["13:00:00","14:00:00","00:00:00",14]
["14:00:00","15:00:00","00:00:00",15]
["15:00:00","16:00:00","00:00:00",16]
["16:00:00","17:00:00","00:00:00",17]
["17:00:00","18:00:00","00:00:00",18]
["18:00:00","19:00:00","00:00:00",19]
["19:00:00","20:00:00","00:00:00",20]
["20:00:00","21:00:00","00:00:00",21]
["21:00:00","22:00:00","00:00:00",22]
["22:00:00","23:00:00","00:00:00",23]
["23:00:00","00:00:00","00:00:00",{"$f":"IF(C32<>\"\",  IF(MOD(D31+1,24)=0,24,MOD(D31+1,24)),\"\")","v":24}]
["00:00:00","01:00:00","1900-01-01",{"$f":"IF(C33<>\"\",  IF(MOD(D32+1,24)=0,24,MOD(D32+1,24)),\"\")","v":1}]
["","","",""]

{"sheet":"CSV_Export","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["# Meteringcode"]
["# Time series ID"]
["# Line name","EGZ"]
["# OBIS-Code","1-1:2.9.0"]
["# Unit","MW"]
["# Period in minutes",60]
["# Values from","23.09.2021 01:00:00"]
["# Values to","24.09.2021 01:00:00"]
["Logical Time Period","Time stamp","Value"]