{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ausdruck","Eingabe","Basics","Datenimport"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":25,"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":"Ausdruck","index":0,"n_rows":218,"n_cols":22,"rows_kept":218,"cut":false,"hidden":false,"merged":[[0,0,1,4]]}
["ÜBERSICHTSBLATT"]
[]
[null,null,null,null,null,"Abgleich Erzeugungszähler zu Verbrauchszähler",null,null,{"$f":"Ausdruck_Differenz_Verbrauch_Erzeugungszähler_vs_Verbrauchszähler","v":0}]
[null,null,null,null,null,"Daten enthalten L3-Werte oder sind unvollständig",null,null,{"$f":"IF(OR(COUNTIF(data,\"Incomplete\")>0,COUNTIF(data,\"L3\")>0),\"ja\",\"nein\")","v":"nein"}]
["Energiebilanz",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A19=\"\",\"A1:J18\",\"A1:J\"&MATCH(0,A:A,-1))","v":"A1:J18"}]
[null,null,null,null,null,"Anlage",null,null,null,null,null,null,null,null,null,null,"Druckbereich",{"$f":"\"A1:J\"&MATCH(0,A19:A218,-1)+18","v":{"$error":"#N/A"}},null,"Anzahl Zähler in EG"]
[null,null,null,null,null,"Energiegemeinschaft:",null,{"$f":"IF(Eingabe_community=\"\",\"\",Eingabe_community)","v":"Name Energiegemeinschaft"},null,null,null,null,null,null,null,null,"DropDown Zählpunkte",{"$f":"\"Ausdruck!C19:C\"&MATCH(0,A19:A218,-1)+19","v":{"$error":"#N/A"}},null,{"$f":"INDEX(Basics_typ,1)","v":"Verbraucher"},null,{"$f":"COUNTIF($B$19:$B$218,T7)","v":0}]
[null,null,null,null,null,"Abrechnungsdatum:",null,{"$f":"IF(Eingabe_datum=\"\",\"\",Eingabe_datum)","v":"2023-08-23"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Basics_typ,2)","v":"Überschusseinspeiser"},null,{"$f":"COUNTIF($B$19:$B$218,T8)","v":0}]
[null,null,null,null,null,"Abrechnungszeitraum:",null,{"$f":"IF(H10=\"Keine Daten importiert!\",\"\",TEXT(MIN(Datenimport!5:5),\"TT.MM.JJJJ\")&\" bis \"&TEXT(MAX(Datenimport!6:6),\"TT.MM.JJJJ\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Basics_typ,3)","v":"Volleinspeiser"},null,{"$f":"COUNTIF($B$19:$B$218,T9)","v":0}]
[null,null,null,null,null,"Anzahl Zählpunkte",null,{"$f":"IF(SUM(V7:V9)=0,\"Keine Daten importiert!\",SUM(V7:V9)&\" (\"&T7&\": \"&V7&\" | \"&T10&\": \"&V10&\")\")","v":"Keine Daten importiert!"},null,null,null,null,null,null,null,null,null,null,null,"Erzeuger",null,{"$f":"V9+V8","v":0}]
[null,null,null,null,null,{"$f":"IF(H11>0,INDEX(Basics_ertrag,1),INDEX(Basics_ertrag,2))&\" im Zeitraum* (\"&Eingabe_steuer&\"):\"","v":"Verlust im Zeitraum* (brutto):"},null,{"$f":"SUM(H19:I218)","v":0}]
[]
[null,null,null,null,null,{"$f":"\"Basisdaten (Beträge \"&IF(Eingabe_steuer=INDEX(Basics_ust,1),\"brutto inkl. \"&Eingabe_ust*100&\" % Ust.)\",\"netto)\")","v":"Basisdaten (Beträge brutto inkl. 20 % Ust.)"}]
[null,null,null,null,null,"Einspeisetarif: In Gemeinschaft",null,{"$f":"Eingabe_ein_comm*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1)","v":14.399999999999999}]
[null,null,null,null,null,"Einspeisetarif: In Netz",null,{"$f":"Eingabe_ein_netz*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1)","v":15.6}]
[null,null,null,null,null,"Bezugspreis aus EG",null,{"$f":"Eingabe_bezug*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1)","v":18}]
[]
["ID","Typ","Zählpunktnummer","Zählpunktnummer\nmit Bezeichnung","Name, Adresse","verbrauchter/\nerzeugter Strom in EG\n[kWh]","Einspeisung\nin Netz durch EG\n[kWh]",{"$f":"CONCATENATE(\"Verechnung\",CHAR(10),\"(\"&Eingabe_steuer&\")\")","v":"Verechnung\n(brutto)"},{"$f":"CONCATENATE(\"Gutschrift\",CHAR(10),\"Einspeisung\",CHAR(10),\"(\"&Eingabe_steuer&\")\")","v":"Gutschrift\nEinspeisung\n(brutto)"},"Anteil an\nVerbrauch /\nErzeugung",null,"Gesamterzeugung \n[kWh]","Mögliches Potenzial für EG\n[kWh]",null,"Summe Einspeisung in Netz durch Erzeuger\n[kWh]","Zählwert\n[kWh]",null,"#Einträge","#Position"]
[{"$f":"IF(C19=\"\",\"\",1)","v":""},{"$f":"IF(A19=\"\",\"\",VLOOKUP(C19,Eingabe_tn,2,FALSE))","v":""},{"$f":"IF(LEFT(INDEX(data,2,1),2)=\"AT\",INDEX(data,2,1),\"\")","v":""},{"$f":"IF(A19=\"\",\"\",C19&IF(VLOOKUP(C19,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C19,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C19=\"\",\"\",CONCATENATE(VLOOKUP(C19,Eingabe_data,3,FALSE),\" \",VLOOKUP(C19,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C19,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C19,Eingabe_data,6,FALSE),\" \",VLOOKUP(C19,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A19=\"\",B19=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B19,P19,-INDEX(data,16,S19-1)+INDEX(data,16,S19-3)))","v":""},{"$f":"IF(OR(A19=\"\",NOT(INDEX(Basics_typ,3)=B19)),\"\",INDEX(data,16,S19-3))","v":""},{"$f":"IF(OR(A19=\"\",B19=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B19,P19*Eingabe_bezug,P19*Eingabe_ein_comm)/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},{"$f":"IF(G19=\"\",\"\",G19*Eingabe_ein_netz/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},{"$f":"IF(OR(A19=\"\",B19=INDEX(Basics_typ,4)),\"\",IF(P19<0,-F19/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S19-1)/Ausdruck_verbrauch))","v":""},null,{"$f":"IF(R19=4,INDEX(data,16,S19-1),\"\")","v":""},{"$f":"IF(OR(INDEX(Basics_typ,3)=B19,INDEX(Basics_typ,2)=B19),INDEX(data,16,S19-3),\"\")","v":""},null,{"$f":"IF(A19=\"\",\"\",IF(INDEX(Basics_typ,1)=B19,0,-1)*IF(INDEX(Basics_typ,2)=B19,INDEX(data,16,S19-3),0))","v":""},{"$f":"IF(OR(A19=\"\",B19=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B19,1,-1)*IF(INDEX(Basics_typ,2)=B19,INDEX(data,16,S19-1)-INDEX(data,16,S19-3),INDEX(data,16,S19-1)))","v":""},null,{"$f":"IF(C19=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C19)=1,1,COUNTIF(Datenimport!$2:$2,C19)*2))","v":0},{"$f":"R19","v":0}]
[{"$f":"IF(C20=\"\",\"\",A19+1)","v":""},"",{"$f":"IF(C19=\"\",\"\",IF(LEFT(INDEX(data,2,1+S19),2)=\"AT\",INDEX(data,2,1+S19),\"\"))","v":""},"","","","",{"$f":"IF(OR(A20=\"\",B20=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B20,P20*Eingabe_bezug,P20*Eingabe_ein_comm)/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},{"$f":"IF(G20=\"\",\"\",G20*Eingabe_ein_netz/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},"",null,"","",null,"","",null,{"$f":"IF(C20=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C20)=1,1,COUNTIF(Datenimport!$2:$2,C20)*2))","v":0},{"$f":"S19+R20","v":0}]
[{"$f":"IF(C21=\"\",\"\",A20+1)","v":""},"","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C21=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C21)=1,1,COUNTIF(Datenimport!$2:$2,C21)*2))","v":0},{"$f":"S20+R21","v":0}]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C22=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C22)=1,1,COUNTIF(Datenimport!$2:$2,C22)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C23=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C23)=1,1,COUNTIF(Datenimport!$2:$2,C23)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C24=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C24)=1,1,COUNTIF(Datenimport!$2:$2,C24)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C25=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C25)=1,1,COUNTIF(Datenimport!$2:$2,C25)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C26=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C26)=1,1,COUNTIF(Datenimport!$2:$2,C26)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C27=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C27)=1,1,COUNTIF(Datenimport!$2:$2,C27)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C28=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C28)=1,1,COUNTIF(Datenimport!$2:$2,C28)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C29=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C29)=1,1,COUNTIF(Datenimport!$2:$2,C29)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C30=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C30)=1,1,COUNTIF(Datenimport!$2:$2,C30)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C31=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C31)=1,1,COUNTIF(Datenimport!$2:$2,C31)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C32=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C32)=1,1,COUNTIF(Datenimport!$2:$2,C32)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C33=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C33)=1,1,COUNTIF(Datenimport!$2:$2,C33)*2))","v":0},0]
[{"$f":"IF(C34=\"\",\"\",A33+1)","v":""},"","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C34=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C34)=1,1,COUNTIF(Datenimport!$2:$2,C34)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C35=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C35)=1,1,COUNTIF(Datenimport!$2:$2,C35)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C36=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C36)=1,1,COUNTIF(Datenimport!$2:$2,C36)*2))","v":0},{"$f":"S35+R36","v":0}]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C37=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C37)=1,1,COUNTIF(Datenimport!$2:$2,C37)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C38=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C38)=1,1,COUNTIF(Datenimport!$2:$2,C38)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C39=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C39)=1,1,COUNTIF(Datenimport!$2:$2,C39)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C40=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C40)=1,1,COUNTIF(Datenimport!$2:$2,C40)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C41=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C41)=1,1,COUNTIF(Datenimport!$2:$2,C41)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C42=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C42)=1,1,COUNTIF(Datenimport!$2:$2,C42)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C43=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C43)=1,1,COUNTIF(Datenimport!$2:$2,C43)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C44=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C44)=1,1,COUNTIF(Datenimport!$2:$2,C44)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C45=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C45)=1,1,COUNTIF(Datenimport!$2:$2,C45)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C46=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C46)=1,1,COUNTIF(Datenimport!$2:$2,C46)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C47=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C47)=1,1,COUNTIF(Datenimport!$2:$2,C47)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C48=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C48)=1,1,COUNTIF(Datenimport!$2:$2,C48)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C49=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C49)=1,1,COUNTIF(Datenimport!$2:$2,C49)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C50=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C50)=1,1,COUNTIF(Datenimport!$2:$2,C50)*2))","v":0},0]
["",{"$f":"IF(A51=\"\",\"\",VLOOKUP(C51,Eingabe_tn,2,FALSE))","v":""},"",{"$f":"IF(A51=\"\",\"\",C51&IF(VLOOKUP(C51,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C51,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C51=\"\",\"\",CONCATENATE(VLOOKUP(C51,Eingabe_data,3,FALSE),\" \",VLOOKUP(C51,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C51,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C51,Eingabe_data,6,FALSE),\" \",VLOOKUP(C51,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A51=\"\",B51=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B51,P51,-INDEX(data,16,S51-1)+INDEX(data,16,S51-3)))","v":""},{"$f":"IF(OR(A51=\"\",NOT(INDEX(Basics_typ,3)=B51)),\"\",INDEX(data,16,S51-3))","v":""},"","",{"$f":"IF(OR(A51=\"\",B51=INDEX(Basics_typ,4)),\"\",IF(P51<0,-F51/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S51-1)/Ausdruck_verbrauch))","v":""},null,{"$f":"IF(R51=4,INDEX(data,16,S51-1),\"\")","v":""},{"$f":"IF(OR(INDEX(Basics_typ,3)=B51,INDEX(Basics_typ,2)=B51),INDEX(data,16,S51-3),\"\")","v":""},null,{"$f":"IF(A51=\"\",\"\",IF(INDEX(Basics_typ,1)=B51,0,-1)*IF(INDEX(Basics_typ,2)=B51,INDEX(data,16,S51-3),0))","v":""},{"$f":"IF(OR(A51=\"\",B51=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B51,1,-1)*IF(INDEX(Basics_typ,2)=B51,INDEX(data,16,S51-1)-INDEX(data,16,S51-3),INDEX(data,16,S51-1)))","v":""},null,{"$f":"IF(C51=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C51)=1,1,COUNTIF(Datenimport!$2:$2,C51)*2))","v":0},0]
["","",{"$f":"IF(C51=\"\",\"\",IF(LEFT(INDEX(data,2,1+S51),2)=\"AT\",INDEX(data,2,1+S51),\"\"))","v":""},"","","","","","","",null,"","",null,"","",null,{"$f":"IF(C52=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C52)=1,1,COUNTIF(Datenimport!$2:$2,C52)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C53=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C53)=1,1,COUNTIF(Datenimport!$2:$2,C53)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C54=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C54)=1,1,COUNTIF(Datenimport!$2:$2,C54)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C55=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C55)=1,1,COUNTIF(Datenimport!$2:$2,C55)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C56=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C56)=1,1,COUNTIF(Datenimport!$2:$2,C56)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C57=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C57)=1,1,COUNTIF(Datenimport!$2:$2,C57)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C58=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C58)=1,1,COUNTIF(Datenimport!$2:$2,C58)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C59=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C59)=1,1,COUNTIF(Datenimport!$2:$2,C59)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C60=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C60)=1,1,COUNTIF(Datenimport!$2:$2,C60)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C61=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C61)=1,1,COUNTIF(Datenimport!$2:$2,C61)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C62=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C62)=1,1,COUNTIF(Datenimport!$2:$2,C62)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C63=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C63)=1,1,COUNTIF(Datenimport!$2:$2,C63)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C64=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C64)=1,1,COUNTIF(Datenimport!$2:$2,C64)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C65=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C65)=1,1,COUNTIF(Datenimport!$2:$2,C65)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C66=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C66)=1,1,COUNTIF(Datenimport!$2:$2,C66)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C67=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C67)=1,1,COUNTIF(Datenimport!$2:$2,C67)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C68=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C68)=1,1,COUNTIF(Datenimport!$2:$2,C68)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C69=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C69)=1,1,COUNTIF(Datenimport!$2:$2,C69)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C70=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C70)=1,1,COUNTIF(Datenimport!$2:$2,C70)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C71=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C71)=1,1,COUNTIF(Datenimport!$2:$2,C71)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C72=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C72)=1,1,COUNTIF(Datenimport!$2:$2,C72)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C73=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C73)=1,1,COUNTIF(Datenimport!$2:$2,C73)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C74=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C74)=1,1,COUNTIF(Datenimport!$2:$2,C74)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C75=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C75)=1,1,COUNTIF(Datenimport!$2:$2,C75)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C76=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C76)=1,1,COUNTIF(Datenimport!$2:$2,C76)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C77=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C77)=1,1,COUNTIF(Datenimport!$2:$2,C77)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C78=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C78)=1,1,COUNTIF(Datenimport!$2:$2,C78)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C79=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C79)=1,1,COUNTIF(Datenimport!$2:$2,C79)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C80=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C80)=1,1,COUNTIF(Datenimport!$2:$2,C80)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C81=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C81)=1,1,COUNTIF(Datenimport!$2:$2,C81)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C82=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C82)=1,1,COUNTIF(Datenimport!$2:$2,C82)*2))","v":0},0]
["",{"$f":"IF(A83=\"\",\"\",VLOOKUP(C83,Eingabe_tn,2,FALSE))","v":""},"",{"$f":"IF(A83=\"\",\"\",C83&IF(VLOOKUP(C83,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C83,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C83=\"\",\"\",CONCATENATE(VLOOKUP(C83,Eingabe_data,3,FALSE),\" \",VLOOKUP(C83,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C83,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C83,Eingabe_data,6,FALSE),\" \",VLOOKUP(C83,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A83=\"\",B83=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B83,P83,-INDEX(data,16,S83-1)+INDEX(data,16,S83-3)))","v":""},{"$f":"IF(OR(A83=\"\",NOT(INDEX(Basics_typ,3)=B83)),\"\",INDEX(data,16,S83-3))","v":""},"","",{"$f":"IF(OR(A83=\"\",B83=INDEX(Basics_typ,4)),\"\",IF(P83<0,-F83/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S83-1)/Ausdruck_verbrauch))","v":""},null,{"$f":"IF(R83=4,INDEX(data,16,S83-1),\"\")","v":""},{"$f":"IF(OR(INDEX(Basics_typ,3)=B83,INDEX(Basics_typ,2)=B83),INDEX(data,16,S83-3),\"\")","v":""},null,{"$f":"IF(A83=\"\",\"\",IF(INDEX(Basics_typ,1)=B83,0,-1)*IF(INDEX(Basics_typ,2)=B83,INDEX(data,16,S83-3),0))","v":""},{"$f":"IF(OR(A83=\"\",B83=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B83,1,-1)*IF(INDEX(Basics_typ,2)=B83,INDEX(data,16,S83-1)-INDEX(data,16,S83-3),INDEX(data,16,S83-1)))","v":""},null,{"$f":"IF(C83=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C83)=1,1,COUNTIF(Datenimport!$2:$2,C83)*2))","v":0},0]
["","",{"$f":"IF(C83=\"\",\"\",IF(LEFT(INDEX(data,2,1+S83),2)=\"AT\",INDEX(data,2,1+S83),\"\"))","v":""},"","","","",{"$f":"IF(OR(A84=\"\",B84=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B84,P84*Eingabe_bezug,P84*Eingabe_ein_comm)/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},{"$f":"IF(G84=\"\",\"\",G84*Eingabe_ein_netz/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},"",null,"","",null,"","",null,{"$f":"IF(C84=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C84)=1,1,COUNTIF(Datenimport!$2:$2,C84)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C85=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C85)=1,1,COUNTIF(Datenimport!$2:$2,C85)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C86=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C86)=1,1,COUNTIF(Datenimport!$2:$2,C86)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C87=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C87)=1,1,COUNTIF(Datenimport!$2:$2,C87)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C88=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C88)=1,1,COUNTIF(Datenimport!$2:$2,C88)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C89=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C89)=1,1,COUNTIF(Datenimport!$2:$2,C89)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C90=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C90)=1,1,COUNTIF(Datenimport!$2:$2,C90)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C91=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C91)=1,1,COUNTIF(Datenimport!$2:$2,C91)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C92=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C92)=1,1,COUNTIF(Datenimport!$2:$2,C92)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C93=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C93)=1,1,COUNTIF(Datenimport!$2:$2,C93)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C94=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C94)=1,1,COUNTIF(Datenimport!$2:$2,C94)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C95=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C95)=1,1,COUNTIF(Datenimport!$2:$2,C95)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C96=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C96)=1,1,COUNTIF(Datenimport!$2:$2,C96)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C97=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C97)=1,1,COUNTIF(Datenimport!$2:$2,C97)*2))","v":0},0]
[{"$f":"IF(C98=\"\",\"\",A97+1)","v":""},"","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C98=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C98)=1,1,COUNTIF(Datenimport!$2:$2,C98)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C99=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C99)=1,1,COUNTIF(Datenimport!$2:$2,C99)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C100=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C100)=1,1,COUNTIF(Datenimport!$2:$2,C100)*2))","v":0},{"$f":"S99+R100","v":0}]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C101=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C101)=1,1,COUNTIF(Datenimport!$2:$2,C101)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C102=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C102)=1,1,COUNTIF(Datenimport!$2:$2,C102)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C103=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C103)=1,1,COUNTIF(Datenimport!$2:$2,C103)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C104=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C104)=1,1,COUNTIF(Datenimport!$2:$2,C104)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C105=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C105)=1,1,COUNTIF(Datenimport!$2:$2,C105)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C106=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C106)=1,1,COUNTIF(Datenimport!$2:$2,C106)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C107=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C107)=1,1,COUNTIF(Datenimport!$2:$2,C107)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C108=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C108)=1,1,COUNTIF(Datenimport!$2:$2,C108)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C109=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C109)=1,1,COUNTIF(Datenimport!$2:$2,C109)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C110=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C110)=1,1,COUNTIF(Datenimport!$2:$2,C110)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C111=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C111)=1,1,COUNTIF(Datenimport!$2:$2,C111)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C112=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C112)=1,1,COUNTIF(Datenimport!$2:$2,C112)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C113=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C113)=1,1,COUNTIF(Datenimport!$2:$2,C113)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C114=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C114)=1,1,COUNTIF(Datenimport!$2:$2,C114)*2))","v":0},0]
["",{"$f":"IF(A115=\"\",\"\",VLOOKUP(C115,Eingabe_tn,2,FALSE))","v":""},"",{"$f":"IF(A115=\"\",\"\",C115&IF(VLOOKUP(C115,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C115,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C115=\"\",\"\",CONCATENATE(VLOOKUP(C115,Eingabe_data,3,FALSE),\" \",VLOOKUP(C115,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C115,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C115,Eingabe_data,6,FALSE),\" \",VLOOKUP(C115,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A115=\"\",B115=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B115,P115,-INDEX(data,16,S115-1)+INDEX(data,16,S115-3)))","v":""},{"$f":"IF(OR(A115=\"\",NOT(INDEX(Basics_typ,3)=B115)),\"\",INDEX(data,16,S115-3))","v":""},"","",{"$f":"IF(OR(A115=\"\",B115=INDEX(Basics_typ,4)),\"\",IF(P115<0,-F115/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S115-1)/Ausdruck_verbrauch))","v":""},null,{"$f":"IF(R115=4,INDEX(data,16,S115-1),\"\")","v":""},{"$f":"IF(OR(INDEX(Basics_typ,3)=B115,INDEX(Basics_typ,2)=B115),INDEX(data,16,S115-3),\"\")","v":""},null,{"$f":"IF(A115=\"\",\"\",IF(INDEX(Basics_typ,1)=B115,0,-1)*IF(INDEX(Basics_typ,2)=B115,INDEX(data,16,S115-3),0))","v":""},{"$f":"IF(OR(A115=\"\",B115=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B115,1,-1)*IF(INDEX(Basics_typ,2)=B115,INDEX(data,16,S115-1)-INDEX(data,16,S115-3),INDEX(data,16,S115-1)))","v":""},null,{"$f":"IF(C115=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C115)=1,1,COUNTIF(Datenimport!$2:$2,C115)*2))","v":0},0]
["","",{"$f":"IF(C115=\"\",\"\",IF(LEFT(INDEX(data,2,1+S115),2)=\"AT\",INDEX(data,2,1+S115),\"\"))","v":""},"","","","","","","",null,"","",null,"","",null,{"$f":"IF(C116=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C116)=1,1,COUNTIF(Datenimport!$2:$2,C116)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C117=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C117)=1,1,COUNTIF(Datenimport!$2:$2,C117)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C118=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C118)=1,1,COUNTIF(Datenimport!$2:$2,C118)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C119=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C119)=1,1,COUNTIF(Datenimport!$2:$2,C119)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C120=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C120)=1,1,COUNTIF(Datenimport!$2:$2,C120)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C121=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C121)=1,1,COUNTIF(Datenimport!$2:$2,C121)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C122=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C122)=1,1,COUNTIF(Datenimport!$2:$2,C122)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C123=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C123)=1,1,COUNTIF(Datenimport!$2:$2,C123)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C124=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C124)=1,1,COUNTIF(Datenimport!$2:$2,C124)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C125=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C125)=1,1,COUNTIF(Datenimport!$2:$2,C125)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C126=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C126)=1,1,COUNTIF(Datenimport!$2:$2,C126)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C127=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C127)=1,1,COUNTIF(Datenimport!$2:$2,C127)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C128=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C128)=1,1,COUNTIF(Datenimport!$2:$2,C128)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C129=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C129)=1,1,COUNTIF(Datenimport!$2:$2,C129)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C130=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C130)=1,1,COUNTIF(Datenimport!$2:$2,C130)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C131=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C131)=1,1,COUNTIF(Datenimport!$2:$2,C131)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C132=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C132)=1,1,COUNTIF(Datenimport!$2:$2,C132)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C133=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C133)=1,1,COUNTIF(Datenimport!$2:$2,C133)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C134=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C134)=1,1,COUNTIF(Datenimport!$2:$2,C134)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C135=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C135)=1,1,COUNTIF(Datenimport!$2:$2,C135)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C136=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C136)=1,1,COUNTIF(Datenimport!$2:$2,C136)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C137=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C137)=1,1,COUNTIF(Datenimport!$2:$2,C137)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C138=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C138)=1,1,COUNTIF(Datenimport!$2:$2,C138)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C139=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C139)=1,1,COUNTIF(Datenimport!$2:$2,C139)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C140=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C140)=1,1,COUNTIF(Datenimport!$2:$2,C140)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C141=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C141)=1,1,COUNTIF(Datenimport!$2:$2,C141)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C142=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C142)=1,1,COUNTIF(Datenimport!$2:$2,C142)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C143=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C143)=1,1,COUNTIF(Datenimport!$2:$2,C143)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C144=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C144)=1,1,COUNTIF(Datenimport!$2:$2,C144)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C145=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C145)=1,1,COUNTIF(Datenimport!$2:$2,C145)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C146=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C146)=1,1,COUNTIF(Datenimport!$2:$2,C146)*2))","v":0},0]
["",{"$f":"IF(A147=\"\",\"\",VLOOKUP(C147,Eingabe_tn,2,FALSE))","v":""},"",{"$f":"IF(A147=\"\",\"\",C147&IF(VLOOKUP(C147,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C147,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C147=\"\",\"\",CONCATENATE(VLOOKUP(C147,Eingabe_data,3,FALSE),\" \",VLOOKUP(C147,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C147,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C147,Eingabe_data,6,FALSE),\" \",VLOOKUP(C147,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A147=\"\",B147=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B147,P147,-INDEX(data,16,S147-1)+INDEX(data,16,S147-3)))","v":""},{"$f":"IF(OR(A147=\"\",NOT(INDEX(Basics_typ,3)=B147)),\"\",INDEX(data,16,S147-3))","v":""},"","",{"$f":"IF(OR(A147=\"\",B147=INDEX(Basics_typ,4)),\"\",IF(P147<0,-F147/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S147-1)/Ausdruck_verbrauch))","v":""},null,{"$f":"IF(R147=4,INDEX(data,16,S147-1),\"\")","v":""},{"$f":"IF(OR(INDEX(Basics_typ,3)=B147,INDEX(Basics_typ,2)=B147),INDEX(data,16,S147-3),\"\")","v":""},null,{"$f":"IF(A147=\"\",\"\",IF(INDEX(Basics_typ,1)=B147,0,-1)*IF(INDEX(Basics_typ,2)=B147,INDEX(data,16,S147-3),0))","v":""},{"$f":"IF(OR(A147=\"\",B147=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B147,1,-1)*IF(INDEX(Basics_typ,2)=B147,INDEX(data,16,S147-1)-INDEX(data,16,S147-3),INDEX(data,16,S147-1)))","v":""},null,{"$f":"IF(C147=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C147)=1,1,COUNTIF(Datenimport!$2:$2,C147)*2))","v":0},0]
["","",{"$f":"IF(C147=\"\",\"\",IF(LEFT(INDEX(data,2,1+S147),2)=\"AT\",INDEX(data,2,1+S147),\"\"))","v":""},"","","","",{"$f":"IF(OR(A148=\"\",B148=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B148,P148*Eingabe_bezug,P148*Eingabe_ein_comm)/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},{"$f":"IF(G148=\"\",\"\",G148*Eingabe_ein_netz/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},"",null,"","",null,"","",null,{"$f":"IF(C148=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C148)=1,1,COUNTIF(Datenimport!$2:$2,C148)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C149=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C149)=1,1,COUNTIF(Datenimport!$2:$2,C149)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C150=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C150)=1,1,COUNTIF(Datenimport!$2:$2,C150)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C151=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C151)=1,1,COUNTIF(Datenimport!$2:$2,C151)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C152=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C152)=1,1,COUNTIF(Datenimport!$2:$2,C152)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C153=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C153)=1,1,COUNTIF(Datenimport!$2:$2,C153)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C154=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C154)=1,1,COUNTIF(Datenimport!$2:$2,C154)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C155=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C155)=1,1,COUNTIF(Datenimport!$2:$2,C155)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C156=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C156)=1,1,COUNTIF(Datenimport!$2:$2,C156)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C157=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C157)=1,1,COUNTIF(Datenimport!$2:$2,C157)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C158=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C158)=1,1,COUNTIF(Datenimport!$2:$2,C158)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C159=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C159)=1,1,COUNTIF(Datenimport!$2:$2,C159)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C160=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C160)=1,1,COUNTIF(Datenimport!$2:$2,C160)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C161=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C161)=1,1,COUNTIF(Datenimport!$2:$2,C161)*2))","v":0},0]
[{"$f":"IF(C162=\"\",\"\",A161+1)","v":""},"","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C162=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C162)=1,1,COUNTIF(Datenimport!$2:$2,C162)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C163=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C163)=1,1,COUNTIF(Datenimport!$2:$2,C163)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C164=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C164)=1,1,COUNTIF(Datenimport!$2:$2,C164)*2))","v":0},{"$f":"S163+R164","v":0}]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C165=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C165)=1,1,COUNTIF(Datenimport!$2:$2,C165)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C166=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C166)=1,1,COUNTIF(Datenimport!$2:$2,C166)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C167=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C167)=1,1,COUNTIF(Datenimport!$2:$2,C167)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C168=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C168)=1,1,COUNTIF(Datenimport!$2:$2,C168)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C169=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C169)=1,1,COUNTIF(Datenimport!$2:$2,C169)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C170=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C170)=1,1,COUNTIF(Datenimport!$2:$2,C170)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C171=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C171)=1,1,COUNTIF(Datenimport!$2:$2,C171)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C172=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C172)=1,1,COUNTIF(Datenimport!$2:$2,C172)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C173=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C173)=1,1,COUNTIF(Datenimport!$2:$2,C173)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C174=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C174)=1,1,COUNTIF(Datenimport!$2:$2,C174)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C175=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C175)=1,1,COUNTIF(Datenimport!$2:$2,C175)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C176=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C176)=1,1,COUNTIF(Datenimport!$2:$2,C176)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C177=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C177)=1,1,COUNTIF(Datenimport!$2:$2,C177)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C178=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C178)=1,1,COUNTIF(Datenimport!$2:$2,C178)*2))","v":0},0]
["",{"$f":"IF(A179=\"\",\"\",VLOOKUP(C179,Eingabe_tn,2,FALSE))","v":""},"",{"$f":"IF(A179=\"\",\"\",C179&IF(VLOOKUP(C179,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C179,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C179=\"\",\"\",CONCATENATE(VLOOKUP(C179,Eingabe_data,3,FALSE),\" \",VLOOKUP(C179,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C179,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C179,Eingabe_data,6,FALSE),\" \",VLOOKUP(C179,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A179=\"\",B179=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B179,P179,-INDEX(data,16,S179-1)+INDEX(data,16,S179-3)))","v":""},{"$f":"IF(OR(A179=\"\",NOT(INDEX(Basics_typ,3)=B179)),\"\",INDEX(data,16,S179-3))","v":""},"","",{"$f":"IF(OR(A179=\"\",B179=INDEX(Basics_typ,4)),\"\",IF(P179<0,-F179/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S179-1)/Ausdruck_verbrauch))","v":""},null,{"$f":"IF(R179=4,INDEX(data,16,S179-1),\"\")","v":""},{"$f":"IF(OR(INDEX(Basics_typ,3)=B179,INDEX(Basics_typ,2)=B179),INDEX(data,16,S179-3),\"\")","v":""},null,{"$f":"IF(A179=\"\",\"\",IF(INDEX(Basics_typ,1)=B179,0,-1)*IF(INDEX(Basics_typ,2)=B179,INDEX(data,16,S179-3),0))","v":""},{"$f":"IF(OR(A179=\"\",B179=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B179,1,-1)*IF(INDEX(Basics_typ,2)=B179,INDEX(data,16,S179-1)-INDEX(data,16,S179-3),INDEX(data,16,S179-1)))","v":""},null,{"$f":"IF(C179=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C179)=1,1,COUNTIF(Datenimport!$2:$2,C179)*2))","v":0},0]
["","",{"$f":"IF(C179=\"\",\"\",IF(LEFT(INDEX(data,2,1+S179),2)=\"AT\",INDEX(data,2,1+S179),\"\"))","v":""},"","","","","","","",null,"","",null,"","",null,{"$f":"IF(C180=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C180)=1,1,COUNTIF(Datenimport!$2:$2,C180)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C181=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C181)=1,1,COUNTIF(Datenimport!$2:$2,C181)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C182=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C182)=1,1,COUNTIF(Datenimport!$2:$2,C182)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C183=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C183)=1,1,COUNTIF(Datenimport!$2:$2,C183)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C184=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C184)=1,1,COUNTIF(Datenimport!$2:$2,C184)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C185=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C185)=1,1,COUNTIF(Datenimport!$2:$2,C185)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C186=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C186)=1,1,COUNTIF(Datenimport!$2:$2,C186)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C187=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C187)=1,1,COUNTIF(Datenimport!$2:$2,C187)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C188=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C188)=1,1,COUNTIF(Datenimport!$2:$2,C188)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C189=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C189)=1,1,COUNTIF(Datenimport!$2:$2,C189)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C190=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C190)=1,1,COUNTIF(Datenimport!$2:$2,C190)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C191=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C191)=1,1,COUNTIF(Datenimport!$2:$2,C191)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C192=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C192)=1,1,COUNTIF(Datenimport!$2:$2,C192)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C193=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C193)=1,1,COUNTIF(Datenimport!$2:$2,C193)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C194=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C194)=1,1,COUNTIF(Datenimport!$2:$2,C194)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C195=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C195)=1,1,COUNTIF(Datenimport!$2:$2,C195)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C196=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C196)=1,1,COUNTIF(Datenimport!$2:$2,C196)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C197=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C197)=1,1,COUNTIF(Datenimport!$2:$2,C197)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C198=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C198)=1,1,COUNTIF(Datenimport!$2:$2,C198)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C199=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C199)=1,1,COUNTIF(Datenimport!$2:$2,C199)*2))","v":0},0]
["","","","","","","","","","",null,"","",null,"","",null,{"$f":"IF(C200=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C200)=1,1,COUNTIF(Datenimport!$2:$2,C200)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C201=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C201)=1,1,COUNTIF(Datenimport!$2:$2,C201)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C202=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C202)=1,1,COUNTIF(Datenimport!$2:$2,C202)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C203=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C203)=1,1,COUNTIF(Datenimport!$2:$2,C203)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C204=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C204)=1,1,COUNTIF(Datenimport!$2:$2,C204)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C205=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C205)=1,1,COUNTIF(Datenimport!$2:$2,C205)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C206=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C206)=1,1,COUNTIF(Datenimport!$2:$2,C206)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C207=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C207)=1,1,COUNTIF(Datenimport!$2:$2,C207)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C208=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C208)=1,1,COUNTIF(Datenimport!$2:$2,C208)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C209=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C209)=1,1,COUNTIF(Datenimport!$2:$2,C209)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C210=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C210)=1,1,COUNTIF(Datenimport!$2:$2,C210)*2))","v":0},0]
["",{"$f":"IF(A211=\"\",\"\",VLOOKUP(C211,Eingabe_tn,2,FALSE))","v":""},"",{"$f":"IF(A211=\"\",\"\",C211&IF(VLOOKUP(C211,Eingabe_tn,8,FALSE)=\"\",\"\",CHAR(10)&VLOOKUP(C211,Eingabe_tn,8,FALSE)))","v":""},{"$f":"IF(C211=\"\",\"\",CONCATENATE(VLOOKUP(C211,Eingabe_data,3,FALSE),\" \",VLOOKUP(C211,Eingabe_data,4,FALSE),CHAR(10),VLOOKUP(C211,Eingabe_data,5,FALSE),CHAR(10),VLOOKUP(C211,Eingabe_data,6,FALSE),\" \",VLOOKUP(C211,Eingabe_data,7,FALSE)))","v":""},{"$f":"IF(OR(A211=\"\",B211=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B211,P211,-INDEX(data,16,S211-1)+INDEX(data,16,S211-3)))","v":""},{"$f":"IF(OR(A211=\"\",NOT(INDEX(Basics_typ,3)=B211)),\"\",INDEX(data,16,S211-3))","v":""},"","",{"$f":"IF(OR(A211=\"\",B211=INDEX(Basics_typ,4)),\"\",IF(P211<0,-F211/Ausdruck_Verbrauch_laut_Erzeugungszähler,INDEX(data,16,S211-1)/Ausdruck_verbrauch))","v":""},null,null,null,null,null,{"$f":"IF(OR(A211=\"\",B211=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B211,1,-1)*IF(INDEX(Basics_typ,2)=B211,INDEX(data,16,S211-1)-INDEX(data,16,S211-3),INDEX(data,16,S211-1)))","v":""},null,{"$f":"IF(C211=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C211)=1,1,COUNTIF(Datenimport!$2:$2,C211)*2))","v":0},0]
["","",{"$f":"IF(C211=\"\",\"\",IF(LEFT(INDEX(data,2,1+S211),2)=\"AT\",INDEX(data,2,1+S211),\"\"))","v":""},"","","","",{"$f":"IF(OR(A212=\"\",B212=INDEX(Basics_typ,4)),\"\",IF(INDEX(Basics_typ,1)=B212,P212*Eingabe_bezug,P212*Eingabe_ein_comm)/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},{"$f":"IF(G212=\"\",\"\",G212*Eingabe_ein_netz/100*IF(Eingabe_steuer=INDEX(Basics_ust,1),1+Eingabe_ust,1))","v":""},"",null,null,null,null,null,"",null,{"$f":"IF(C212=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C212)=1,1,COUNTIF(Datenimport!$2:$2,C212)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C213=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C213)=1,1,COUNTIF(Datenimport!$2:$2,C213)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C214=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C214)=1,1,COUNTIF(Datenimport!$2:$2,C214)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C215=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C215)=1,1,COUNTIF(Datenimport!$2:$2,C215)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C216=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C216)=1,1,COUNTIF(Datenimport!$2:$2,C216)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C217=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C217)=1,1,COUNTIF(Datenimport!$2:$2,C217)*2))","v":0},0]
["","","","","","","","","","",null,null,null,null,null,"",null,{"$f":"IF(C218=\"\",0,IF(COUNTIF(Datenimport!$2:$2,C218)=1,1,COUNTIF(Datenimport!$2:$2,C218)*2))","v":0},0]

{"sheet":"Eingabe","index":1,"n_rows":217,"n_cols":14,"rows_kept":217,"cut":false,"hidden":false,"merged":[[0,5,1,6],[0,0,0,4]]}
["ABRECHNUNGSTOOL FÜR ENERGIEGEMEINSCHAFTEN / GEMEINSCHAFTLICHE ERZEUGUNGSANLAGEN",null,null,null,null,"Sie haben Fragen?\nSie können mich gerne kontaktieren!"]
["v4.0 | 17.01.2024"]
[null,null,null,null,null,"ENERGIEAGENTUR TIROL"]
["Datei importieren",null,null,null,null,"Thomas Vogel, M.Sc."]
["Bitte wählen Sie eine gültige Datei:",null,null,null,null,"+43 512 589913 52"]
[null,null,null,null,null,"thomas.vogel@energieagentur.tirol"]
["Basisdaten"]
["Name der Energiegemeinschaft","Name Energiegemeinschaft"]
["Abrechnungsdatum","2023-08-23",null,null,null,null,null,null,null,null,null,null,"Druckbereich",{"$f":"\"A1:H\"&(MATCH(\"\",A18:A217,-1)+17)","v":{"$error":"#N/A"}}]
["Einspeisetarif: In Gemeinschaft [netto]",12]
["Einspeisetarif: In Netz [netto]",13]
["Bezugspreis aus EG [netto]",15]
[{"$f":"\"Umsatzsteuer\"&IF(B14=INDEX(Basics_ust,2),\" (nicht relevant)\",\"\")","v":"Umsatzsteuer"},0.2]
["Angaben brutto/netto","brutto"]
[]
["TeilnehmerInnen"]
["Zählpunktnummer","Typ","Nachname","Vorname","Straße u. Hausnummer","PLZ","Ort","Bezeichnung"]
[null,null,null,null,null,null,null,null,{"$f":"IF(L18=\"falsch\",J18,\"\")","v":""},{"$f":"IF(K18=3,\"Verbraucher\",IF(K18=2,\"Erzeuger\",IF(K18=1,INDEX(Basics_typ,4),\"\")))","v":""},{"$f":"IF(A18=\"\",0,COUNTIF(Datenimport!$2:$2,A18))","v":0},{"$f":"IF(A18=\"\",\"\",IF(OR(B18=INDEX(Basics_typ,2),B18=INDEX(Basics_typ,3))*AND(K18=2),\"richtig\",IF(AND(B18=INDEX(Basics_typ,1),K18=3),\"richtig\",IF(AND(B18=INDEX(Basics_typ,4),K18=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L19=\"falsch\",J19,\"\")","v":""},"",{"$f":"IF(A19=\"\",0,COUNTIF(Datenimport!$2:$2,A19))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A20=\"\",0,COUNTIF(Datenimport!$2:$2,A20))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A21=\"\",0,COUNTIF(Datenimport!$2:$2,A21))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A22=\"\",0,COUNTIF(Datenimport!$2:$2,A22))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A23=\"\",0,COUNTIF(Datenimport!$2:$2,A23))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A24=\"\",0,COUNTIF(Datenimport!$2:$2,A24))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A25=\"\",0,COUNTIF(Datenimport!$2:$2,A25))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A26=\"\",0,COUNTIF(Datenimport!$2:$2,A26))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A27=\"\",0,COUNTIF(Datenimport!$2:$2,A27))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A28=\"\",0,COUNTIF(Datenimport!$2:$2,A28))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A29=\"\",0,COUNTIF(Datenimport!$2:$2,A29))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A30=\"\",0,COUNTIF(Datenimport!$2:$2,A30))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A31=\"\",0,COUNTIF(Datenimport!$2:$2,A31))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A32=\"\",0,COUNTIF(Datenimport!$2:$2,A32))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A33=\"\",0,COUNTIF(Datenimport!$2:$2,A33))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A34=\"\",0,COUNTIF(Datenimport!$2:$2,A34))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A35=\"\",0,COUNTIF(Datenimport!$2:$2,A35))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A36=\"\",0,COUNTIF(Datenimport!$2:$2,A36))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A37=\"\",0,COUNTIF(Datenimport!$2:$2,A37))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A38=\"\",0,COUNTIF(Datenimport!$2:$2,A38))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A39=\"\",0,COUNTIF(Datenimport!$2:$2,A39))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A40=\"\",0,COUNTIF(Datenimport!$2:$2,A40))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A41=\"\",0,COUNTIF(Datenimport!$2:$2,A41))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A42=\"\",0,COUNTIF(Datenimport!$2:$2,A42))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A43=\"\",0,COUNTIF(Datenimport!$2:$2,A43))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A44=\"\",0,COUNTIF(Datenimport!$2:$2,A44))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A45=\"\",0,COUNTIF(Datenimport!$2:$2,A45))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A46=\"\",0,COUNTIF(Datenimport!$2:$2,A46))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A47=\"\",0,COUNTIF(Datenimport!$2:$2,A47))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A48=\"\",0,COUNTIF(Datenimport!$2:$2,A48))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A49=\"\",0,COUNTIF(Datenimport!$2:$2,A49))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A50=\"\",0,COUNTIF(Datenimport!$2:$2,A50))","v":0},{"$f":"IF(A50=\"\",\"\",IF(OR(B50=INDEX(Basics_typ,2),B50=INDEX(Basics_typ,3))*AND(K50=2),\"richtig\",IF(AND(B50=INDEX(Basics_typ,1),K50=3),\"richtig\",IF(AND(B50=INDEX(Basics_typ,4),K50=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A51=\"\",0,COUNTIF(Datenimport!$2:$2,A51))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A52=\"\",0,COUNTIF(Datenimport!$2:$2,A52))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A53=\"\",0,COUNTIF(Datenimport!$2:$2,A53))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A54=\"\",0,COUNTIF(Datenimport!$2:$2,A54))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A55=\"\",0,COUNTIF(Datenimport!$2:$2,A55))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A56=\"\",0,COUNTIF(Datenimport!$2:$2,A56))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A57=\"\",0,COUNTIF(Datenimport!$2:$2,A57))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A58=\"\",0,COUNTIF(Datenimport!$2:$2,A58))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A59=\"\",0,COUNTIF(Datenimport!$2:$2,A59))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A60=\"\",0,COUNTIF(Datenimport!$2:$2,A60))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A61=\"\",0,COUNTIF(Datenimport!$2:$2,A61))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A62=\"\",0,COUNTIF(Datenimport!$2:$2,A62))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A63=\"\",0,COUNTIF(Datenimport!$2:$2,A63))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A64=\"\",0,COUNTIF(Datenimport!$2:$2,A64))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A65=\"\",0,COUNTIF(Datenimport!$2:$2,A65))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A66=\"\",0,COUNTIF(Datenimport!$2:$2,A66))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A67=\"\",0,COUNTIF(Datenimport!$2:$2,A67))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A68=\"\",0,COUNTIF(Datenimport!$2:$2,A68))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A69=\"\",0,COUNTIF(Datenimport!$2:$2,A69))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A70=\"\",0,COUNTIF(Datenimport!$2:$2,A70))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A71=\"\",0,COUNTIF(Datenimport!$2:$2,A71))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A72=\"\",0,COUNTIF(Datenimport!$2:$2,A72))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A73=\"\",0,COUNTIF(Datenimport!$2:$2,A73))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A74=\"\",0,COUNTIF(Datenimport!$2:$2,A74))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A75=\"\",0,COUNTIF(Datenimport!$2:$2,A75))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A76=\"\",0,COUNTIF(Datenimport!$2:$2,A76))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A77=\"\",0,COUNTIF(Datenimport!$2:$2,A77))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A78=\"\",0,COUNTIF(Datenimport!$2:$2,A78))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A79=\"\",0,COUNTIF(Datenimport!$2:$2,A79))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A80=\"\",0,COUNTIF(Datenimport!$2:$2,A80))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A81=\"\",0,COUNTIF(Datenimport!$2:$2,A81))","v":0},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(K82=3,\"Verbraucher\",IF(K82=2,\"Erzeuger\",IF(K82=1,INDEX(Basics_typ,4),\"\")))","v":""},{"$f":"IF(A82=\"\",0,COUNTIF(Datenimport!$2:$2,A82))","v":0},{"$f":"IF(A82=\"\",\"\",IF(OR(B82=INDEX(Basics_typ,2),B82=INDEX(Basics_typ,3))*AND(K82=2),\"richtig\",IF(AND(B82=INDEX(Basics_typ,1),K82=3),\"richtig\",IF(AND(B82=INDEX(Basics_typ,4),K82=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L83=\"falsch\",J83,\"\")","v":""},"",{"$f":"IF(A83=\"\",0,COUNTIF(Datenimport!$2:$2,A83))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A84=\"\",0,COUNTIF(Datenimport!$2:$2,A84))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A85=\"\",0,COUNTIF(Datenimport!$2:$2,A85))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A86=\"\",0,COUNTIF(Datenimport!$2:$2,A86))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A87=\"\",0,COUNTIF(Datenimport!$2:$2,A87))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A88=\"\",0,COUNTIF(Datenimport!$2:$2,A88))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A89=\"\",0,COUNTIF(Datenimport!$2:$2,A89))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A90=\"\",0,COUNTIF(Datenimport!$2:$2,A90))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A91=\"\",0,COUNTIF(Datenimport!$2:$2,A91))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A92=\"\",0,COUNTIF(Datenimport!$2:$2,A92))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A93=\"\",0,COUNTIF(Datenimport!$2:$2,A93))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A94=\"\",0,COUNTIF(Datenimport!$2:$2,A94))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A95=\"\",0,COUNTIF(Datenimport!$2:$2,A95))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A96=\"\",0,COUNTIF(Datenimport!$2:$2,A96))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A97=\"\",0,COUNTIF(Datenimport!$2:$2,A97))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A98=\"\",0,COUNTIF(Datenimport!$2:$2,A98))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A99=\"\",0,COUNTIF(Datenimport!$2:$2,A99))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A100=\"\",0,COUNTIF(Datenimport!$2:$2,A100))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A101=\"\",0,COUNTIF(Datenimport!$2:$2,A101))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A102=\"\",0,COUNTIF(Datenimport!$2:$2,A102))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A103=\"\",0,COUNTIF(Datenimport!$2:$2,A103))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A104=\"\",0,COUNTIF(Datenimport!$2:$2,A104))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A105=\"\",0,COUNTIF(Datenimport!$2:$2,A105))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A106=\"\",0,COUNTIF(Datenimport!$2:$2,A106))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A107=\"\",0,COUNTIF(Datenimport!$2:$2,A107))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A108=\"\",0,COUNTIF(Datenimport!$2:$2,A108))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A109=\"\",0,COUNTIF(Datenimport!$2:$2,A109))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A110=\"\",0,COUNTIF(Datenimport!$2:$2,A110))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A111=\"\",0,COUNTIF(Datenimport!$2:$2,A111))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A112=\"\",0,COUNTIF(Datenimport!$2:$2,A112))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A113=\"\",0,COUNTIF(Datenimport!$2:$2,A113))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A114=\"\",0,COUNTIF(Datenimport!$2:$2,A114))","v":0},{"$f":"IF(A114=\"\",\"\",IF(OR(B114=INDEX(Basics_typ,2),B114=INDEX(Basics_typ,3))*AND(K114=2),\"richtig\",IF(AND(B114=INDEX(Basics_typ,1),K114=3),\"richtig\",IF(AND(B114=INDEX(Basics_typ,4),K114=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A115=\"\",0,COUNTIF(Datenimport!$2:$2,A115))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A116=\"\",0,COUNTIF(Datenimport!$2:$2,A116))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A117=\"\",0,COUNTIF(Datenimport!$2:$2,A117))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A118=\"\",0,COUNTIF(Datenimport!$2:$2,A118))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A119=\"\",0,COUNTIF(Datenimport!$2:$2,A119))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A120=\"\",0,COUNTIF(Datenimport!$2:$2,A120))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A121=\"\",0,COUNTIF(Datenimport!$2:$2,A121))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A122=\"\",0,COUNTIF(Datenimport!$2:$2,A122))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A123=\"\",0,COUNTIF(Datenimport!$2:$2,A123))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A124=\"\",0,COUNTIF(Datenimport!$2:$2,A124))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A125=\"\",0,COUNTIF(Datenimport!$2:$2,A125))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A126=\"\",0,COUNTIF(Datenimport!$2:$2,A126))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A127=\"\",0,COUNTIF(Datenimport!$2:$2,A127))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A128=\"\",0,COUNTIF(Datenimport!$2:$2,A128))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A129=\"\",0,COUNTIF(Datenimport!$2:$2,A129))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A130=\"\",0,COUNTIF(Datenimport!$2:$2,A130))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A131=\"\",0,COUNTIF(Datenimport!$2:$2,A131))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A132=\"\",0,COUNTIF(Datenimport!$2:$2,A132))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A133=\"\",0,COUNTIF(Datenimport!$2:$2,A133))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A134=\"\",0,COUNTIF(Datenimport!$2:$2,A134))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A135=\"\",0,COUNTIF(Datenimport!$2:$2,A135))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A136=\"\",0,COUNTIF(Datenimport!$2:$2,A136))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A137=\"\",0,COUNTIF(Datenimport!$2:$2,A137))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A138=\"\",0,COUNTIF(Datenimport!$2:$2,A138))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A139=\"\",0,COUNTIF(Datenimport!$2:$2,A139))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A140=\"\",0,COUNTIF(Datenimport!$2:$2,A140))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A141=\"\",0,COUNTIF(Datenimport!$2:$2,A141))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A142=\"\",0,COUNTIF(Datenimport!$2:$2,A142))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A143=\"\",0,COUNTIF(Datenimport!$2:$2,A143))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A144=\"\",0,COUNTIF(Datenimport!$2:$2,A144))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A145=\"\",0,COUNTIF(Datenimport!$2:$2,A145))","v":0},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(K146=3,\"Verbraucher\",IF(K146=2,\"Erzeuger\",IF(K146=1,INDEX(Basics_typ,4),\"\")))","v":""},{"$f":"IF(A146=\"\",0,COUNTIF(Datenimport!$2:$2,A146))","v":0},{"$f":"IF(A146=\"\",\"\",IF(OR(B146=INDEX(Basics_typ,2),B146=INDEX(Basics_typ,3))*AND(K146=2),\"richtig\",IF(AND(B146=INDEX(Basics_typ,1),K146=3),\"richtig\",IF(AND(B146=INDEX(Basics_typ,4),K146=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L147=\"falsch\",J147,\"\")","v":""},"",{"$f":"IF(A147=\"\",0,COUNTIF(Datenimport!$2:$2,A147))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A148=\"\",0,COUNTIF(Datenimport!$2:$2,A148))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A149=\"\",0,COUNTIF(Datenimport!$2:$2,A149))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A150=\"\",0,COUNTIF(Datenimport!$2:$2,A150))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A151=\"\",0,COUNTIF(Datenimport!$2:$2,A151))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A152=\"\",0,COUNTIF(Datenimport!$2:$2,A152))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A153=\"\",0,COUNTIF(Datenimport!$2:$2,A153))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A154=\"\",0,COUNTIF(Datenimport!$2:$2,A154))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A155=\"\",0,COUNTIF(Datenimport!$2:$2,A155))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A156=\"\",0,COUNTIF(Datenimport!$2:$2,A156))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A157=\"\",0,COUNTIF(Datenimport!$2:$2,A157))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A158=\"\",0,COUNTIF(Datenimport!$2:$2,A158))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A159=\"\",0,COUNTIF(Datenimport!$2:$2,A159))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A160=\"\",0,COUNTIF(Datenimport!$2:$2,A160))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A161=\"\",0,COUNTIF(Datenimport!$2:$2,A161))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A162=\"\",0,COUNTIF(Datenimport!$2:$2,A162))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A163=\"\",0,COUNTIF(Datenimport!$2:$2,A163))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A164=\"\",0,COUNTIF(Datenimport!$2:$2,A164))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A165=\"\",0,COUNTIF(Datenimport!$2:$2,A165))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A166=\"\",0,COUNTIF(Datenimport!$2:$2,A166))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A167=\"\",0,COUNTIF(Datenimport!$2:$2,A167))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A168=\"\",0,COUNTIF(Datenimport!$2:$2,A168))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A169=\"\",0,COUNTIF(Datenimport!$2:$2,A169))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A170=\"\",0,COUNTIF(Datenimport!$2:$2,A170))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A171=\"\",0,COUNTIF(Datenimport!$2:$2,A171))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A172=\"\",0,COUNTIF(Datenimport!$2:$2,A172))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A173=\"\",0,COUNTIF(Datenimport!$2:$2,A173))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A174=\"\",0,COUNTIF(Datenimport!$2:$2,A174))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A175=\"\",0,COUNTIF(Datenimport!$2:$2,A175))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A176=\"\",0,COUNTIF(Datenimport!$2:$2,A176))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A177=\"\",0,COUNTIF(Datenimport!$2:$2,A177))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A178=\"\",0,COUNTIF(Datenimport!$2:$2,A178))","v":0},{"$f":"IF(A178=\"\",\"\",IF(OR(B178=INDEX(Basics_typ,2),B178=INDEX(Basics_typ,3))*AND(K178=2),\"richtig\",IF(AND(B178=INDEX(Basics_typ,1),K178=3),\"richtig\",IF(AND(B178=INDEX(Basics_typ,4),K178=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A179=\"\",0,COUNTIF(Datenimport!$2:$2,A179))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A180=\"\",0,COUNTIF(Datenimport!$2:$2,A180))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A181=\"\",0,COUNTIF(Datenimport!$2:$2,A181))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A182=\"\",0,COUNTIF(Datenimport!$2:$2,A182))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A183=\"\",0,COUNTIF(Datenimport!$2:$2,A183))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A184=\"\",0,COUNTIF(Datenimport!$2:$2,A184))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A185=\"\",0,COUNTIF(Datenimport!$2:$2,A185))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A186=\"\",0,COUNTIF(Datenimport!$2:$2,A186))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A187=\"\",0,COUNTIF(Datenimport!$2:$2,A187))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A188=\"\",0,COUNTIF(Datenimport!$2:$2,A188))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A189=\"\",0,COUNTIF(Datenimport!$2:$2,A189))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A190=\"\",0,COUNTIF(Datenimport!$2:$2,A190))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A191=\"\",0,COUNTIF(Datenimport!$2:$2,A191))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A192=\"\",0,COUNTIF(Datenimport!$2:$2,A192))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A193=\"\",0,COUNTIF(Datenimport!$2:$2,A193))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A194=\"\",0,COUNTIF(Datenimport!$2:$2,A194))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A195=\"\",0,COUNTIF(Datenimport!$2:$2,A195))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A196=\"\",0,COUNTIF(Datenimport!$2:$2,A196))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A197=\"\",0,COUNTIF(Datenimport!$2:$2,A197))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A198=\"\",0,COUNTIF(Datenimport!$2:$2,A198))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A199=\"\",0,COUNTIF(Datenimport!$2:$2,A199))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A200=\"\",0,COUNTIF(Datenimport!$2:$2,A200))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A201=\"\",0,COUNTIF(Datenimport!$2:$2,A201))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A202=\"\",0,COUNTIF(Datenimport!$2:$2,A202))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A203=\"\",0,COUNTIF(Datenimport!$2:$2,A203))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A204=\"\",0,COUNTIF(Datenimport!$2:$2,A204))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A205=\"\",0,COUNTIF(Datenimport!$2:$2,A205))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A206=\"\",0,COUNTIF(Datenimport!$2:$2,A206))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A207=\"\",0,COUNTIF(Datenimport!$2:$2,A207))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A208=\"\",0,COUNTIF(Datenimport!$2:$2,A208))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A209=\"\",0,COUNTIF(Datenimport!$2:$2,A209))","v":0},""]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(K210=3,\"Verbraucher\",IF(K210=2,\"Erzeuger\",IF(K210=1,INDEX(Basics_typ,4),\"\")))","v":""},{"$f":"IF(A210=\"\",0,COUNTIF(Datenimport!$2:$2,A210))","v":0},{"$f":"IF(A210=\"\",\"\",IF(OR(B210=INDEX(Basics_typ,2),B210=INDEX(Basics_typ,3))*AND(K210=2),\"richtig\",IF(AND(B210=INDEX(Basics_typ,1),K210=3),\"richtig\",IF(AND(B210=INDEX(Basics_typ,4),K210=1),\"richtig\",\"falsch\"))))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(L211=\"falsch\",J211,\"\")","v":""},"",{"$f":"IF(A211=\"\",0,COUNTIF(Datenimport!$2:$2,A211))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A212=\"\",0,COUNTIF(Datenimport!$2:$2,A212))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A213=\"\",0,COUNTIF(Datenimport!$2:$2,A213))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A214=\"\",0,COUNTIF(Datenimport!$2:$2,A214))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A215=\"\",0,COUNTIF(Datenimport!$2:$2,A215))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A216=\"\",0,COUNTIF(Datenimport!$2:$2,A216))","v":0},""]
[null,null,null,null,null,null,null,null,"","",{"$f":"IF(A217=\"\",0,COUNTIF(Datenimport!$2:$2,A217))","v":0},""]

{"sheet":"Basics","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Ertrag","Ust","Typ",null,null,"gelieferte Energie an EG",{"$f":"-SUMIF(Ausdruck!P19:P218,\"<0\")","v":0},null,"Datenqualität"]
["Gewinn","brutto","Verbraucher",null,null,"Verbrauch in EG laut Verbrauchszähler",{"$f":"SUMIF(Ausdruck!P19:P218,\">0\")","v":0},null,"L1"]
["Verlust","netto","Überschusseinspeiser",null,null,"Einspeisung in Netz durch EG",{"$f":"IF(Ausdruck!V9>=1,SUM(Ausdruck!G19:G218),#N/A)","v":{"$error":"#N/A"}},null,"L2"]
[null,null,"Volleinspeiser",null,null,"Einspeisung in Netz durch Erzeuger",{"$f":"IF(Ausdruck!V8>=1,-SUM(Ausdruck!O19:O218),#N/A)","v":{"$error":"#N/A"}},null,"L3"]
[null,null,"nicht aktivierter Zähler",null,null,"Gesamte Erzeugung exkl. Verbrauch",{"$f":"SUMIF(Ausdruck!L19:L218,\">0\")","v":0}]
[]
[null,null,null,null,null,"Verbrauch in EG laut Erzeugungszähler",{"$f":"-SUMIF(Ausdruck!F19:F218,\"<0\")","v":0}]
[]
[null,null,null,null,null,"Differenz Verbrauch Erzeugungszähler vs Verbrauchszähler",{"$f":"Ausdruck_verbrauch-Ausdruck_Verbrauch_laut_Erzeugungszähler","v":0}]

{"sheet":"Datenimport","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}