{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Input (2)","Input","CSVExport","CSVExportOld","CSVExportOldTest","Prolet","ESen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"comments":3,"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 (2)","index":0,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Име на фирмата","АБВГД ООД",null,null,null,null,null,null,null,null,1,"ФтЕЦ","ФтЕЦ-Фотоволтаична ЕЦ","FESO","(solar)"]
[null,"Булстат","BG123456789",null,null,null,null,null,null,null,null,2,"ВтЕЦ","ВтЕЦ-Вятърна ЕЦ","FEWI","(wind)"]
[null,"Вид на производството","ФтЕЦ-Фотоволтаична ЕЦ",null,null,null,null,null,null,null,null,3,"ВЕЦ","ВЕЦ-Водна ЕЦ","FEWA","(water)"]
[null,"Име на централата","ФТЕЦ - Тръстиково",null,null,null,null,null,null,null,null,4,"БмЕЦ","БмЕЦ-ЕЦ на Биомаса","FEBM","(biomass)"]
[null,"Измервателна точка",1733937,null,null,null,null,null,null,null,null,5,"КоГен","КоГен-Когенерация","FECG ","(Co-gen)"]
[null,"Дата на графика","2013-11-01",null,"2013-10-27"]
[null,null,null,null,"2014-03-30"]
[null,"kW",null,null,"2013-11-01"]
["Час 1",10]
["Час 2",20]
["Час 3",30]
["Час 4",40]
["Час 5",50]
["Час 6",60]
["Час 7",70]
["Час 8",80]
["Час 9",90]
["Час 10",100]
["Час 11",110]
["Час 12",120]
["Час 13",130]
["Час 14",140]
["Час 15",150]
["Час 16",160]
["Час 17",170]
["Час 18",180]
["Час 19",190]
["Час 20",200]
["Час 21",210]
["Час 22",30]
["Час 23",33333]
["Час 24",44444]
["Час 25"]

{"sheet":"Input","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Име на фирмата","АБВГД ООД",null,null,null,null,null,null,null,null,1,"ФтЕЦ","ФтЕЦ-Фотоволтаична ЕЦ","SOL","(solar)"]
[null,"Булстат","BG123456789",null,null,null,null,null,null,null,null,2,"ВтЕЦ","ВтЕЦ-Вятърна ЕЦ","WNL","(wind)"]
[null,"Вид на производството","ФтЕЦ-Фотоволтаична ЕЦ",null,null,null,null,null,null,null,null,3,"ВЕЦ","ВЕЦ-Водна ЕЦ","WAL","(water)"]
[null,"Име на централата","ФТЕЦ - Тръстиково",null,null,null,null,null,null,null,null,4,"БмЕЦ","БмЕЦ-ЕЦ на Биомаса","BIP","(biomass)"]
[null,"Измервателна точка","123456",null,null,null,null,null,null,null,null,5,"КоГен","КоГен-Когенерация","EGZ","(Co-gen)"]
[null,"Дата на графика","2014-01-29"]
[]
[null,"kW"]
["Час 1",100]
["Час 2",200]
["Час 3",400]
["Час 4",550]
["Час 5",700]
["Час 6",850]
["Час 7",1000]
["Час 8",1150]
["Час 9",1300]
["Час 10",1450]
["Час 11",1600]
["Час 12",1750]
["Час 13",1900]
["Час 14",2050]
["Час 15",2200]
["Час 16",2350]
["Час 17",2500]
["Час 18",2650]
["Час 19",2800]
["Час 20",2950]
["Час 21",3100]
["Час 22",3250]
["Час 23",3400]
["Час 24",3550]
["Час 25"]

{"sheet":"CSVExport","index":2,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["# Meteringcode",123456,null," "]
["# Producer-Code - Mehrwertsteuernummer","BG123456789"]
["# Energy Quality","SOL"]
["# OBIS-Code","1-1:2.9.0"," "," "]
["# Unit","MW "," "," "]
["# Period in minutes",60," "," "]
["# Values from","2014-01-29T01:00:00"," "," "]
["# Values to","2014-01-30"," "," "]
["Logical Time Period","Time stamp","Value"]
["2014-01-29","01:00:00",0.1]
["2014-01-29","02:00:00",0.2]
["2014-01-29","03:00:00",0.4]
["2014-01-29","04:00:00",0.55000000000000004]
["2014-01-29","05:00:00",0.7]
["2014-01-29","06:00:00",0.85]
["2014-01-29","07:00:00",1]
["2014-01-29","08:00:00",1.1499999999999999]
["2014-01-29","09:00:00",1.3]
["2014-01-29","10:00:00",1.45]
["2014-01-29","11:00:00",1.6]
["2014-01-29","12:00:00",1.75]
["2014-01-29","13:00:00",1.9]
["2014-01-29","14:00:00",2.0499999999999998]
["2014-01-29","15:00:00",2.2000000000000002]
["2014-01-29","16:00:00",2.35]
["2014-01-29","17:00:00",2.5]
["2014-01-29","18:00:00",2.65]
["2014-01-29","19:00:00",2.8]
["2014-01-29","20:00:00",2.95]
["2014-01-29","21:00:00",3.1]
["2014-01-29","22:00:00",3.25]
["2014-01-29","23:00:00",3.4]
["2014-01-30","00:00:00",3.55]

{"sheet":"CSVExportOld","index":3,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["# Metering point ID ",1733937]
["# Metering point name ","BG0000000000000000000000001733937 "]
["# Metering point name ","TA TSEE Pazar "]
["# Line ID ",2226938]
["# OBIS code ","1-1:1.9.0 "]
["# Line name ","Mall Plovdiv Act "]
["# Contract ID  ",5316558]
["# Measurand ","Active Purchase in kWh "]
["# Line ","TA TSEE Pazar (Mall Plovdiv) "]
["# Network connection ","BG123456789"]
["# Address ","Тръстиково"]
["# Time series ID ",232401]
["# Formula ","FESO (solar)"]
["# Period ","60 Minutes "]
["# Values from ","2013-10-23T01:00:00"]
["# Values to ","2013-10-24"]
["Logical period "," End time stamp "," Value "]
["2013-10-23","01:00:00",100]
["2013-10-23","02:00:00",200]
["2013-10-23","03:00:00",300]
["2013-10-23","04:00:00",400]
["2013-10-23","05:00:00",500]
["2013-10-23","06:00:00",600]
["2013-10-23","07:00:00",700]
["2013-10-23","08:00:00",800]
["2013-10-23","09:00:00",900]
["2013-10-23","10:00:00",1000]
["2013-10-23","11:00:00",1100]
["2013-10-23","12:00:00",1200]
["2013-10-23","13:00:00",1300]
["2013-10-23","14:00:00",1400]
["2013-10-23","15:00:00",1500]
["2013-10-23","16:00:00",1600]
["2013-10-23","17:00:00",1700]
["2013-10-23","18:00:00",1800]
["2013-10-23","19:00:00",1900]
["2013-10-23","20:00:00",2000]
["2013-10-23","21:00:00",2100]
["2013-10-23","22:00:00",2200]
["2013-10-23","23:00:00",2300]
["2013-10-24","00:00:00",0]

{"sheet":"CSVExportOldTest","index":4,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["# Metering point ID ",1733937,{"$f":"ADDRESS(ROW(),COLUMN()-1,4)","v":"B1"}," "," ",{"$f":"LEN(B1)","v":7},{"$f":"GetFormula(F1)","v":{"$error":"#NAME?"}}]
["# Metering point name ","BG0000000000000000000000001733937 ",{"$f":"ADDRESS(ROW(),COLUMN()-1,4)","v":"B2"}," "," ",{"$f":"LEN(B2)","v":34},{"$f":"GetFormula(F2)","v":{"$error":"#NAME?"}}]
["# Metering point name ","TA TSEE Pazar ","B3"," "," "]
["# Line ID ",2226938,"B4"," "," ",{"$f":"LEN(B4)","v":7},{"$f":"GetFormula(F4)","v":{"$error":"#NAME?"}}]
["# OBIS code ","1-1:1.9.0 "," "," "," "]
["# Line name ","Mall Plovdiv Act ","B6"," "," "]
["# Contract ID  ",5316558,"B7"," "," ",{"$f":"LEN(B7)","v":7},{"$f":"GetFormula(F7)","v":{"$error":"#NAME?"}}]
["# Measurand ","Active Purchase in kWh "," "," "," "]
["# Line ","TA TSEE Pazar (Mall Plovdiv) ","B9"," "," "]
["# Bulstat ID","BG123456789"," "," "," "]
["# PP Name ","ФТЕЦ - Тръстиково"," "," "," "]
["# Time series ID ",232401,{"$f":"ADDRESS(ROW(),COLUMN()-1,4)","v":"B12"}," "," ",{"$f":"LEN(B12)","v":6},{"$f":"GetFormula(F12)","v":{"$error":"#NAME?"}}]
["# Type ","FESO (solar)"," "," "," "]
["# Period ","60 Minutes "," "," "," "]
["# Values from ","2013-10-27T01:00:00"," "," "," "]
["# Values to ","2013-10-28"," "," "," "]
["Logical period "," End time stamp "," Value "]
["2013-10-27","01:00:00",100]
["2013-10-27","02:00:00",200]
["2013-10-27","03:00:00",300]
["2013-10-27","03:00:00",400]
["2013-10-27","04:00:00",500]
["2013-10-27","05:00:00",600]
["2013-10-27","06:00:00",700]
["2013-10-27","07:00:00",800]
["2013-10-27","08:00:00",900]
["2013-10-27","09:00:00",1000]
["2013-10-27","10:00:00",1100]
["2013-10-27","11:00:00",1200]
["2013-10-27","12:00:00",1300]
["2013-10-27","13:00:00",1400]
["2013-10-27","14:00:00",1500]
["2013-10-27","15:00:00",1600]
["2013-10-27","16:00:00",1700]
["2013-10-27","17:00:00",1800]
["2013-10-27","18:00:00",1900]
["2013-10-27","19:00:00",2000]
["2013-10-27","20:00:00",2100]
["2013-10-27","21:00:00",2200]
["2013-10-27","22:00:00",2300]
["2013-10-27","23:00:00",2400]
["2013-10-28","00:00:00",2500]

{"sheet":"Prolet","index":5,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["# Metering point ID ",1733937," "," "," "]
["# Metering point name ","BG0000000000000000000000001733937 "," "," "," "]
["# Metering point name ","TA TSEE Pazar "," "," "," "]
["# Line ID ",2308475," "," "," "]
["# OBIS code ","1-1:1.9.0 "," "," "," "]
["# Line name ","1. BG TSEE FC Int_Ext_Sum "," "," "," "]
["# Contract ID  ",5316558," "," "," "]
["# Measurand ","Active Purchase in kWh "," "," "," "]
["# Line ","TA TSEE Pazar (1. BG TSEE FC Int_Ext_Sum) "," "," "," "]
["# Network connection ","- "," "," "," "]
["# Address ","- "," "," "," "]
["# Time series ID ",326724," "," "," "]
["# Formula ","LIN['1733937','2308475',5316558,0,,,] "," "," "," "]
["# Period ","60 Minutes "," "," "," "]
["# Values from ","2012-10-01T01:00:00"," "," "," "]
["# Values to ","2013-11-01"," "," "," "]
["Logical period "," End time stamp "," Value "," Status "," Tarif "]
["2013-03-31","01:00:00",3400.5456330000002,"E","tariflos "]
["2013-03-31","02:00:00",3180.0855000000001,"E","tariflos "]
["2013-03-31","04:00:00",3158.6958669999999,"E","tariflos "]
["2013-03-31","05:00:00",2984.9272000000001,"E","tariflos "]
["2013-03-31","06:00:00",3197.8304330000001,"E","tariflos "]
["2013-03-31","07:00:00",3348.9950669999998,"E","tariflos "]
["2013-03-31","08:00:00",3303.5596,"E","tariflos "]
["2013-03-31","09:00:00",3621.8629329999999,"E","tariflos "]
["2013-03-31","10:00:00",4833.4849329999997,"E","tariflos "]
["2013-03-31","11:00:00",5393.2061329999997,"E","tariflos "]
["2013-03-31","12:00:00",5298.3683339999998,"E","tariflos "]
["2013-03-31","13:00:00",5326.7670669999998,"E","tariflos "]
["2013-03-31","14:00:00",5439.9173339999998,"E","tariflos "]
["2013-03-31","15:00:00",5587.5470329999998,"E","tariflos "]
["2013-03-31","16:00:00",5681.1158329999998,"E","tariflos "]
["2013-03-31","17:00:00",5634.7826329999998,"E","tariflos "]
["2013-03-31","18:00:00",5749.2946339999999,"E","tariflos "]
["2013-03-31","19:00:00",5727.5827330000002,"E","tariflos "]
["2013-03-31","20:00:00",5174.3728330000004,"E","tariflos "]
["2013-03-31","21:00:00",4539.2112669999997,"E","tariflos "]
["2013-03-31","22:00:00",3864.2147669999999,"E","tariflos "]
["2013-03-31","23:00:00",3505.3812330000001,"E","tariflos "]
["2013-04-01","00:00:00",3257.4546999999998,"E","tariflos "]

{"sheet":"ESen","index":6,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["# Metering point ID ",1733937," "," "," "]
["# Metering point name ","BG0000000000000000000000001733937 "," "," "," "]
["# Metering point name ","TA TSEE Pazar "," "," "," "]
["# Line ID ",2308475," "," "," "]
["# OBIS code ","1-1:1.9.0 "," "," "," "]
["# Line name ","1. BG TSEE FC Int_Ext_Sum "," "," "," "]
["# Contract ID  ",5316558," "," "," "]
["# Measurand ","Active Purchase in kWh "," "," "," "]
["# Line ","TA TSEE Pazar (1. BG TSEE FC Int_Ext_Sum) "," "," "," "]
["# Network connection ","- "," "," "," "]
["# Address ","- "," "," "," "]
["# Time series ID ",326724," "," "," "]
["# Formula ","LIN['1733937','2308475',5316558,0,,,] "," "," "," "]
["# Period ","60 Minutes "," "," "," "]
["# Values from ","2012-10-01T01:00:00"," "," "," "]
["# Values to ","2013-11-01"," "," "," "]
["Logical period "," End time stamp "," Value "," Status "," Tarif "]
["2013-10-27","01:00:00",5044.9529599999996,"V","tariflos "]
["2013-10-27","02:00:00",4769.848602,"V","tariflos "]
["2013-10-27","03:00:00",4800.2559430000001,"V","tariflos "]
["2013-10-27","03:00:00",4752.054975,"V","tariflos "]
["2013-10-27","04:00:00",4801.5144190000001,"V","tariflos "]
["2013-10-27","05:00:00",4707.1338370000003,"V","tariflos "]
["2013-10-27","06:00:00",4757.4826119999998,"V","tariflos "]
["2013-10-27","07:00:00",4462.0080969999999,"V","tariflos "]
["2013-10-27","08:00:00",4831.7406190000002,"V","tariflos "]
["2013-10-27","09:00:00",5633.464739,"V","tariflos "]
["2013-10-27","10:00:00",6975.0488599999999,"V","tariflos "]
["2013-10-27","11:00:00",7568.6248599999999,"V","tariflos "]
["2013-10-27","12:00:00",7596.470988,"V","tariflos "]
["2013-10-27","13:00:00",7925.7875000000004,"V","tariflos "]
["2013-10-27","14:00:00",7947.0899159999999,"V","tariflos "]
["2013-10-27","15:00:00",8255.7902180000001,"V","tariflos "]
["2013-10-27","16:00:00",8134.3032599999997,"V","tariflos "]
["2013-10-27","17:00:00",8044.7501000000002,"V","tariflos "]
["2013-10-27","18:00:00",7736.1690820000003,"V","tariflos "]
["2013-10-27","19:00:00",6982.6269869999996,"V","tariflos "]
["2013-10-27","20:00:00",6555.8659390000003,"V","tariflos "]
["2013-10-27","21:00:00",6126.0825359999999,"V","tariflos "]
["2013-10-27","22:00:00",5437.4552830000002,"V","tariflos "]
["2013-10-27","23:00:00",5192.5892990000002,"V","tariflos "]
["2013-10-28","00:00:00",5102.5907349999998,"V","tariflos "]