{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tabelle1"],"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":"Tabelle1","index":0,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Stromverbrauch mit Batteriespeicher und PV-Anlage"]
["eingegeben von E. Waffenschmidt, 18.1.2017"]
["gemessen von Mitglied SFV aus Usingen, Daten als Papierversion, siehe Tagebuch 2017"]
["Zeitraum Okt 2013 bis Sep 2014, Einheiten nicht explizit angegeben, aber sehr wahrscheinlich kWh"]
[]
["Randbedingungen"]
["Standort: Usingen, Blei-Gel 12kWh / 6 kWh nutzbar, SMA-technik"]
["Batterie: Blei-Gel 12kWh / 6 kWh nutzbar, SMA-technik"]
["PV-System: 2 PV-Anlagen, zusammen 6.8kWp - SO-Exposition, 36° Dachneigung, 3. PV-Anlage mit 2.7kWp speist nur direkt ein"]
["Stromverbrauch: übliche Haushaltsgeräte, Wärmepumpe, z.T. Infrarot-Heizung, Elektromobil, seit Juni 2014 ein 2. Elektromobil"]
["Wärmeerzeugung zusätzlich: 20m² Solarthermie-Anlage (Röhrenkollektoren), ca. 3000kWh Scheitholz, ca. 200kWh Flüssiggas"]
[]
["Zeitraum","Verbrauch gesamt","Verbrauch aus Netzbezug","Verbrauch aus Eigenversorgung","Eigenvers. PV direkt","Eigenvers. Batterie","PV-Ertrag gesamt","PV Netz-einspeisung","PV Eigenverbrauch","PV-Batterieladung",null,"Autarkie-quote","Speicher-Verlust","Speicher-Effizienz","Eigen-verbrauchs-quote","Autarkie-quote direkt","Autonomie"]
["2013-10-01",377,122,255,127,128,408,107,301,174,null,{"$f":"D14/B14","v":0.67639257294429711},{"$f":"1-N14","v":0.26436781609195403},{"$f":"F14/J14","v":0.73563218390804597},{"$f":"MIN(1,B14/G14)","v":0.9240196078431373},{"$f":"E14/B14","v":0.33687002652519893},{"$f":"G14/B14","v":1.0822281167108754}]
["2013-11-01",469,327,142,73,69,201,28,173,100,null,{"$f":"D15/B15","v":0.30277185501066101},{"$f":"1-N15","v":0.31000000000000005},{"$f":"F15/J15","v":0.69},{"$f":"MIN(1,B15/G15)","v":1},{"$f":"E15/B15","v":0.15565031982942432},{"$f":"G15/B15","v":0.42857142857142855}]
["2013-12-01",647,524,123,64,59,160,5,155,91,null,0.1901081916537867,0.35164835164835162,0.64835164835164838,1,9.8918083462132919E-2,0.2472952086553323]
["2014-01-01",549,414,135,97,68,184,15,169,102,null,0.24590163934426229,0.33333333333333337,0.66666666666666663,1,0.1766848816029144,0.33515482695810567]
["2014-02-01",445,207,238,132,106,326,49,277,145,null,0.53483146067415732,0.26896551724137929,0.73103448275862071,1,0.29662921348314608,0.73258426966292134]
["2014-03-01",438,80,358,211,147,711,295,415,204,null,0.81735159817351599,0.27941176470588236,0.72058823529411764,0.61603375527426163,0.4817351598173516,1.6232876712328768]
["2014-04-01",333,16,317,194,123,788,427,342,168,null,0.95195195195195192,0.2678571428571429,0.7321428571428571,0.42258883248730966,0.58258258258258255,2.3663663663663663]
["2014-05-01",357,9,348,230,118,886,495,391,161,null,0.97478991596638653,0.26708074534161486,0.73291925465838514,0.40293453724604966,0.64425770308123254,2.4817927170868348]
["2014-06-01",331,8,323,224,99,1016,655,361,137,null,0.97583081570996977,0.27737226277372262,0.72262773722627738,0.32578740157480313,0.67673716012084595,3.0694864048338371]
["2014-07-01",379,11,368,256,112,946,538,410,154,null,0.97097625329815307,0.27272727272727271,0.72727272727272729,0.40063424947145876,0.67546174142480209,2.4960422163588389]
["2014-08-01",345,7,338,232,106,845,468,377,145,null,0.97971014492753628,0.26896551724137929,0.73103448275862071,0.40828402366863903,0.672463768115942,2.4492753623188408]
["2014-09-01",364,43,321,198,123,532,170,361,163,null,0.88186813186813184,0.245398773006135,0.754601226993865,0.68421052631578949,0.54395604395604391,1.4615384615384615]
["Summe ganzes Jahr",{"$f":"SUM(B14:B25)","v":5034},{"$f":"SUM(C14:C25)","v":1768},3266,2038,1258,7003,3252,3732,1744,null,{"$f":"D26/B26","v":0.64878823996821611},0.27866972477064222,{"$f":"F26/J26","v":0.72133027522935778},{"$f":"MIN(1,B26/G26)","v":0.71883478509210341},0.40484704012713546,1.39114024632499]