{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Deckblatt","Anleitung","Zusammenfassung","Herstellerangaben","Notstrombetrieb","Betriebsfahrzeuge","Baumaschinen","Hilfsstoffbedarf","Hilfstabellen"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Deckblatt","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,0,4,7],[3,0,3,7]]}
[]
[]
[]
["Exceltool zur Dieselbedarfsermittlung"]
["im Wasserversorgungsunternehmen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Wasserversorger:"]
[]
[]
[null,null,"Projekt:"]
[null,null,"Bearbeiter"]
[null,null,"Stand:"]

{"sheet":"Anleitung","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,6,30,7],[31,6,31,7],[16,0,16,7],[25,0,25,7],[26,6,26,7],[27,6,27,7],[28,6,28,7],[14,0,14,7],[0,0,0,7],[1,0,1,7],[18,0,18,7],[29,6,29,7]]}
["Anleitung Exceltool - Dieselbedarfsermittlung"]
["Grundlagen"]
[]
["Grundlage bilden die Berechnungsformeln nach Heumer et al. (2024), dazu wurden "]
["folgende Gleichungen für die Dieselbedarfsermittlung genutzt:"]
[]
["Berechnung über PElt:"]
[]
["Berechnung über PP:"]
[]
["Berechnung über PHyd:"]
[]
["PSchätzung:"]
[]
["Bedienungsgrundlagen"]
[]
["Die angegebenen Daten dienen ausschließlich als Beispielrechnung und sollten nicht \nfür eine genaue Dieselbedarfsermittlung genutzt werden."]
[]
["Sämtliche Formeln und Verknüpfungen im Tool können frei verwendet werden, \nder Blattschutz ist passwortfrei."]
[]
["Im Tool gibt es Eingabefelder, diese dienen der Dateneingabe:"]
[]
["Zusätzlich existieren vorkonfektionierte Auswahlfelder:"]
["Die Dropdowntabellen der Auswahlfelde sind im Tabellenblatt \"Hilfstabellen\" ausgelistet."]
[]
["Arbeitsschritte für eine vollständige Dieselbedarfsermittlung"]
["1.","Datenerfassung der Herstellerangaben",null,null,null,null,"Herstellerangaben"]
["2.","Auswahl und Datenerfassung des Notstrombetriebs",null,null,null,null,"Notstrombetrieb"]
["3.","Dieselbedarfsermittlung Betriebsfahrzeuge",null,null,null,null,"Betriebsfahrzeuge"]
["4.","Dieselbedarfsermittlung Baumaschinen",null,null,null,null,"Baumaschinen"]
["5.","Ermittlung Hilfsstoffbedarf für Fahrzeuge und Baumaschinen",null,null,null,null,"Hilfsstoffbedarf"]
["6.","Vorgabe Dauer der Bemessung und Auswahl Tankvolumen",null,null,null,null,"Zusammenfassung"]

{"sheet":"Zusammenfassung","index":2,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,3,12,7],[9,0,9,7],[5,0,5,2],[6,0,6,2],[7,0,7,2],[7,3,7,5],[6,3,6,5],[5,3,5,5],[18,0,18,2],[16,0,16,2],[17,0,17,2],[15,0,15,2],[14,0,14,7],[1,0,1,7],[0,0,0,7],[3,0,3,7],[4,0,4,2],[4,3,4,5]]}
["Bemessung der Dieselbevorratung"]
["Grundparameter"]
["Dauer der Treibstoffversorgung",null,null,null,null,null,3,"d"]
["Dieselverbrauch "]
["Verbraucher",null,null,null,null,null,"l/d","l/Dauer"]
["Notstromaggregate",null,null,null,null,null,{"$f":"Notstrombetrieb!R18","v":1704.4104365058488},{"$f":"G6*$G$3","v":5113.2313095175468}]
["Betriebsfahrzeuge pauschal",null,null,null,null,null,{"$f":"Betriebsfahrzeuge!H17","v":130},{"$f":"G7*$G$3","v":390}]
["Baumaschinen pauschal",null,null,null,null,null,{"$f":"Baumaschinen!H17","v":190},570]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H6:H8)","v":6073.2313095175468}]
["Gewähltes Tankvolumen"]
["Gewähltes Tankvolumen",null,null,null,null,null,null,10000]
["Verbleibendes Volumen für den Betrieb der Anlage",null,null,null,null,null,null,{"$f":"H11-H9","v":3926.7686904824532}]
["Wertung",null,null,{"$f":"IF(H12<0,\"nicht ausreichend\",(IF(H12<H11*0.2,\"Betriebsreserve kleine 20%\",\"ausreichend\")))","v":"ausreichend"}]
[]
["Hilfsstoffverbrauch"]
["Bezeichnung",null,null,"Art",null,null,"l/d","l/Dauer"]
["Hilfsstoff 1",null,null,{"$f":"Herstellerangaben!J3","v":"Adblue"},null,null,{"$f":"Hilfsstoffbedarf!C31","v":62.363164448185756},{"$f":"G17*$G$3","v":187.08949334455727}]
["Hilfsstoff 2",null,null,{"$f":"Herstellerangaben!L3","v":"Schmieröl"},null,null,{"$f":"Hilfsstoffbedarf!E31","v":4.4586917539152235},13.376075261745671]
["Hilfsstoff 3",null,null,{"$f":"Herstellerangaben!N3","v":0},null,null,{"$f":"Hilfsstoffbedarf!G31","v":0},0]
[]
[null,"Eingabefeld"]

{"sheet":"Herstellerangaben","index":3,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,10,16,11],[3,12,3,13],[4,12,4,13],[5,12,5,13],[6,12,6,13],[7,12,7,13],[8,12,8,13],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[11,10,11,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[6,10,6,11],[7,10,7,11],[8,10,8,11],[9,10,9,11],[10,10,10,11],[4,8,4,9],[3,8,3,9],[3,10,3,11],[4,10,4,11],[5,10,5,11],[1,8,1,9],[1,10,1,11],[1,12,1,13],[0,0,0,13],[16,8,16,9],[15,8,15,9],[14,8,14,9],[13,8,13,9],[12,8,12,9],[11,8,11,9],[10,8,10,9],[9,8,9,9],[8,8,8,9],[7,8,7,9],[6,8,6,9],[5,8,5,9],[1,2,2,2],[1,1,2,1],[1,0,2,0],[1,7,2,7],[1,6,2,6],[1,5,2,5],[1,4,2,4],[1,3,2,3]]}
["Herstellerangaben der Notstromaggregate"]
["Nr.","Hersteller","Maschinenbezeichnung","Nennleistung\nin kVA","Vspez. \nin kg/kWh","ρ\nin kg/l","ηG\nin %","cos φ","Hilfsstoff 1\nin % vom \nDieselverbr.",null,"Hilfsstoff 2\nin % vom \nDieselverbr.",null,"Hilfsstoff 3\nin % vom \nDieselverbr."]
[null,null,null,null,null,null,null,null,"Art","Adblue","Art","Schmieröl","Art"]
[1,"Hersteller A","ABC 1",100,0.22,0.83,91.6,0.8,4,null,0.25]
[2,"Hersteller A","ABC 2",80,0.28999999999999998,0.83,92.8,0.8,0,null,0.3]
[3,"Hersteller A","ABC 3",100,0.28999999999999998,0.83,91.6,0.8,4,null,0.25]
[4,"Hersteller A","ABC 4",50,0.22,0.83,91.6,0.8,4,null,0.25]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[" n"]
[]
[null,null,"Auswahlfeld"]
[]
[null,null,"Eingabefeld"]

{"sheet":"Notstrombetrieb","index":4,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,2,0],[0,0,0,17],[17,0,17,16],[2,5,2,8],[1,17,2,17],[1,16,2,16],[1,15,2,15],[1,14,2,14],[1,13,2,13],[1,12,2,12],[1,11,2,11],[1,10,2,10],[1,9,2,9],[1,4,2,4],[1,3,2,3],[1,2,2,2],[1,1,2,1]]}
["Treibstoffbedarf Notstrombetrieb"]
["Nr.","Standort","Einsatzgebiet","Berechnungs-\nmethode","Notstrom-\naggregat Nr.","Vspez. in\n kg/kWh","ρ\nin kg/l","ηG\nin %","cos φ","PElt \nin kWh","PHilf\nin kWh","PP\nin kWh","ηElt\nin %","ηP\nin %","hF\nin mWS","Q\nin m³/h","VkW\nin l/h","VkW\nin l/d"]
[null,null,null,null,null,"Übernahme aus Tabellenblatt \"Herstellerangaben\""]
[1,"A","Wasserförderung","PP",1,{"$f":"IF($E4>0,VLOOKUP($E4,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":0.22},{"$f":"IF($E4>0,VLOOKUP($E4,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":0.83},{"$f":"IF($E4>0,VLOOKUP($E4,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":91.6},{"$f":"IF($E4>0,VLOOKUP($E4,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":0.8},null,2,47.6,90,null,null,null,{"$f":"IF(D4=\"PSchätzung\",0.0016*O4*P4,IF(D4=\"PElt\",(F4/(G4*H4/100))*(J4+K4)/I4,IF(D4=\"PP\",(F4/(G4*H4/100))*(L4/(M4/100)+K4)/I4,IF(D4=\"PHyd\",(F4/(G4*H4/100))*((P4*O4)/(367*(M4/100)*(N4/100))+K4)/I4,\" \"))))","v":19.853796554485772},{"$f":"IF(Q4<>\" \",Q4*24,\" \")","v":476.49111730765856}]
[2,"B","Wasserförderung","PElt",2,{"$f":"IF($E5>0,VLOOKUP($E5,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":0.28999999999999998},{"$f":"IF($E5>0,VLOOKUP($E5,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":0.83},{"$f":"IF($E5>0,VLOOKUP($E5,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":92.8},{"$f":"IF($E5>0,VLOOKUP($E5,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":0.8},33,2,null,null,null,null,null,{"$f":"IF(D5=\"PSchätzung\",0.0016*O5*P5,IF(D5=\"PElt\",(F5/(G5*H5/100))*(J5+K5)/I5,IF(D5=\"PP\",(F5/(G5*H5/100))*(L5/(M5/100)+K5)/I5,IF(D5=\"PHyd\",(F5/(G5*H5/100))*((P5*O5)/(367*(M5/100)*(N5/100))+K5)/I5,\" \"))))","v":16.472138554216865},{"$f":"IF(Q5<>\" \",Q5*24,\" \")","v":395.33132530120474}]
[3,"C","Wasserförderung","PElt",3,{"$f":"IF($E6>0,VLOOKUP($E6,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":0.28999999999999998},{"$f":"IF($E6>0,VLOOKUP($E6,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":0.83},{"$f":"IF($E6>0,VLOOKUP($E6,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":91.6},{"$f":"IF($E6>0,VLOOKUP($E6,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":0.8},47,3,null,null,null,null,null,23.839901089072448,572.15762613773882]
[4,"D","Wassergewinnung","PElt",4,{"$f":"IF($E7>0,VLOOKUP($E7,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":0.22},{"$f":"IF($E7>0,VLOOKUP($E7,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":0.83},{"$f":"IF($E7>0,VLOOKUP($E7,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":91.6},{"$f":"IF($E7>0,VLOOKUP($E7,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":0.8},28,2,null,null,null,null,null,10.851265323301941,260.43036775924656]
[5,null,null,null,null,{"$f":"IF($E8>0,VLOOKUP($E8,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E8>0,VLOOKUP($E8,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E8>0,VLOOKUP($E8,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E8>0,VLOOKUP($E8,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[6,null,null,null,null,{"$f":"IF($E9>0,VLOOKUP($E9,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E9>0,VLOOKUP($E9,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E9>0,VLOOKUP($E9,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E9>0,VLOOKUP($E9,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[7,null,null,null,null,{"$f":"IF($E10>0,VLOOKUP($E10,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E10>0,VLOOKUP($E10,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E10>0,VLOOKUP($E10,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E10>0,VLOOKUP($E10,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[8,null,null,null,null,{"$f":"IF($E11>0,VLOOKUP($E11,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E11>0,VLOOKUP($E11,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E11>0,VLOOKUP($E11,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E11>0,VLOOKUP($E11,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[9,null,null,null,null,{"$f":"IF($E12>0,VLOOKUP($E12,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E12>0,VLOOKUP($E12,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E12>0,VLOOKUP($E12,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E12>0,VLOOKUP($E12,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[10,null,null,null,null,{"$f":"IF($E13>0,VLOOKUP($E13,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E13>0,VLOOKUP($E13,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E13>0,VLOOKUP($E13,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E13>0,VLOOKUP($E13,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[11,null,null,null,null,{"$f":"IF($E14>0,VLOOKUP($E14,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E14>0,VLOOKUP($E14,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E14>0,VLOOKUP($E14,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E14>0,VLOOKUP($E14,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[12,null,null,null,null,{"$f":"IF($E15>0,VLOOKUP($E15,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E15>0,VLOOKUP($E15,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E15>0,VLOOKUP($E15,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E15>0,VLOOKUP($E15,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[13,null,null,null,null,{"$f":"IF($E16>0,VLOOKUP($E16,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E16>0,VLOOKUP($E16,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E16>0,VLOOKUP($E16,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E16>0,VLOOKUP($E16,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
[" n",null,null,null,null,{"$f":"IF($E17>0,VLOOKUP($E17,Herstellerangaben!$A$4:$H$17,5,FALSE),\" \")","v":" "},{"$f":"IF($E17>0,VLOOKUP($E17,Herstellerangaben!$A$4:$H$17,6,FALSE),\" \")","v":" "},{"$f":"IF($E17>0,VLOOKUP($E17,Herstellerangaben!$A$4:$H$17,7,FALSE),\" \")","v":" "},{"$f":"IF($E17>0,VLOOKUP($E17,Herstellerangaben!$A$4:$H$17,8,FALSE),\" \")","v":" "},null,null,null,null,null,null,null," "," "]
["Summe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R4:R17)","v":1704.4104365058488}]
[]
[null,null,"Auswahlfeld"]
[]
[null,null,"Eingabefeld"]

{"sheet":"Betriebsfahrzeuge","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[6,3,6,6],[7,3,7,6],[8,3,8,6],[9,3,9,6],[14,3,14,6],[15,3,15,6],[10,3,10,6],[11,3,11,6],[12,3,12,6],[13,3,13,6],[5,3,5,6],[0,0,0,7],[1,3,1,6],[2,3,2,6],[3,3,3,6],[4,3,4,6]]}
["Treibstoffbedarf Betriebsfahrzeuge"]
["Fahrzeug","Strecke \nin km","Verbrauch\nl/100 km","Bemerkungen",null,null,null,"Bedarf\nin l/d"]
["A",500,10,"Betankung der NEA",null,null,null,{"$f":"B3*C3/100","v":50}]
["B",400,8,"Betriebskontrolle",null,null,null,{"$f":"B4*C4/100","v":32}]
["C",400,8,"Behebung von Betriebsstörungen",null,null,null,32]
["D",200,8,"Sonstige Fahrten",null,null,null,16]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H3:H16)","v":130}]
[]
[null,"Eingabefeld"]

{"sheet":"Baumaschinen","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[6,3,6,6],[7,3,7,6],[8,3,8,6],[9,3,9,6],[10,3,10,6],[11,3,11,6],[5,3,5,6],[0,0,0,7],[1,3,1,6],[2,3,2,6],[3,3,3,6],[4,3,4,6]]}
["Treibstoffbedarf Baumaschinen"]
["Fahrzeug","Laufzeit\nin h","Verbrauch\nl/h","Bemerkungen",null,null,null,"Bedarf\nin l/d"]
["A",10,15,"Bagger",null,null,null,{"$f":"B3*C3","v":150}]
["B",10,4,"Sonstige Baugeräte",null,null,null,{"$f":"B4*C4","v":40}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summe",null,null,null,null,null,null,{"$f":"SUM(H3:H16)","v":190}]
[]
[null,"Eingabefeld"]

{"sheet":"Hilfsstoffbedarf","index":7,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,1,3,1],[21,1,22,1],[27,2,27,3],[27,4,27,5],[27,6,27,7],[23,2,23,3],[23,4,23,5],[23,6,23,7],[24,2,24,3],[24,4,24,5],[24,6,24,7],[20,0,20,7],[21,0,22,0],[14,2,14,3],[14,4,14,5],[14,6,14,7],[17,2,17,3],[21,2,21,3],[21,4,21,5],[30,4,30,5],[30,6,30,7],[30,2,30,3],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,2,26,3],[26,4,26,5],[26,6,26,7],[29,2,29,3],[29,4,29,5],[29,6,29,7],[28,2,28,3],[28,4,28,5],[28,6,28,7],[6,2,6,3],[6,4,6,5],[6,6,6,7],[21,6,21,7],[17,4,17,5],[17,6,17,7],[10,6,10,7],[11,2,11,3],[11,4,11,5],[11,6,11,7],[12,2,12,3],[12,4,12,5],[12,6,12,7],[18,6,18,7],[18,4,18,5],[18,2,18,3],[4,4,4,5],[4,6,4,7],[5,2,5,3],[5,4,5,5],[5,6,5,7],[7,2,7,3],[15,2,15,3],[15,4,15,5],[15,6,15,7],[16,2,16,3],[16,4,16,5],[16,6,16,7],[7,4,7,5],[7,6,7,7],[8,2,8,3],[1,0,1,7],[2,0,3,0],[13,2,13,3],[13,4,13,5],[13,6,13,7],[10,2,10,3],[10,4,10,5],[8,6,8,7],[9,2,9,3],[9,4,9,5],[9,6,9,7],[2,2,2,3],[2,4,2,5],[2,6,2,7],[4,2,4,3],[8,4,8,5]]}
["Hilfsstoffbedarf Notstromaggregate"]
["Hilfsstoffbedarf Notstromaggregate (Übernahme aus TB \"Herstellerangaben und TB \"Notstrombetrieb\")"]
["Notstromaggregat Nr.","Dieselverbrauch\nin l/d","Hilfsstoff 1\nin l/d",null,"Hilfsstoff 2\nin l/d",null,"Hilfsstoff 3\nin l/d"]
[null,null,"Art",{"$f":"Herstellerangaben!J3","v":"Adblue"},"Art",{"$f":"Herstellerangaben!L3","v":"Schmieröl"},"Art",{"$f":"Herstellerangaben!N3","v":0}]
[{"$f":"IF(Herstellerangaben!B4<>0,Herstellerangaben!A4,\" \")","v":1},{"$f":"IF(A5=1,VLOOKUP(A5,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":476.49111730765856},{"$f":"IF($A5=1,(VLOOKUP($A5,Herstellerangaben!$A$4:$N$17,9,FALSE)*B5/100),\" \")","v":19.059644692306343},null,{"$f":"IF($A5=1,(VLOOKUP($A5,Herstellerangaben!$A$4:$N$17,11,FALSE)*B5/100),\" \")","v":1.1912277932691464},null,{"$f":"IF($A5=1,(VLOOKUP($A5,Herstellerangaben!$A$4:$N$17,13,FALSE)*B5/100),\" \")","v":0}]
[{"$f":"IF(Herstellerangaben!B5<>0,Herstellerangaben!A5,\" \")","v":2},{"$f":"IF(A6=2,VLOOKUP(A6,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":395.33132530120474},{"$f":"IF($A6=2,(VLOOKUP($A6,Herstellerangaben!$A$4:$N$17,9,FALSE)*B6/100),\" \")","v":0},null,{"$f":"IF($A6=2,(VLOOKUP($A6,Herstellerangaben!$A$4:$N$17,11,FALSE)*B6/100),\" \")","v":1.1859939759036142},null,{"$f":"IF($A6=2,(VLOOKUP($A6,Herstellerangaben!$A$4:$N$17,13,FALSE)*B6/100),\" \")","v":0}]
[{"$f":"IF(Herstellerangaben!B6<>0,Herstellerangaben!A6,\" \")","v":3},{"$f":"IF(A7=3,VLOOKUP(A7,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":572.15762613773882},{"$f":"IF($A7=3,(VLOOKUP($A7,Herstellerangaben!$A$4:$N$17,9,FALSE)*B7/100),\" \")","v":22.886305045509552},null,{"$f":"IF($A7=3,(VLOOKUP($A7,Herstellerangaben!$A$4:$N$17,11,FALSE)*B7/100),\" \")","v":1.430394065344347},null,{"$f":"IF($A7=3,(VLOOKUP($A7,Herstellerangaben!$A$4:$N$17,13,FALSE)*B7/100),\" \")","v":0}]
[{"$f":"IF(Herstellerangaben!B7<>0,Herstellerangaben!A7,\" \")","v":4},{"$f":"IF(A8=4,VLOOKUP(A8,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":260.43036775924656},{"$f":"IF($A8=4,(VLOOKUP($A8,Herstellerangaben!$A$4:$N$17,9,FALSE)*B8/100),\" \")","v":10.417214710369862},null,{"$f":"IF($A8=4,(VLOOKUP($A8,Herstellerangaben!$A$4:$N$17,11,FALSE)*B8/100),\" \")","v":0.65107591939811638},null,{"$f":"IF($A8=4,(VLOOKUP($A8,Herstellerangaben!$A$4:$N$17,13,FALSE)*B8/100),\" \")","v":0}]
[{"$f":"IF(Herstellerangaben!B8<>0,Herstellerangaben!A8,\" \")","v":" "},{"$f":"IF(A9=5,VLOOKUP(A9,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A9=5,(VLOOKUP($A9,Herstellerangaben!$A$4:$N$17,9,FALSE)*B9/100),\" \")","v":" "},null,{"$f":"IF($A9=5,(VLOOKUP($A9,Herstellerangaben!$A$4:$N$17,11,FALSE)*B9/100),\" \")","v":" "},null,{"$f":"IF($A9=5,(VLOOKUP($A9,Herstellerangaben!$A$4:$N$17,13,FALSE)*B9/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B9<>0,Herstellerangaben!A9,\" \")","v":" "},{"$f":"IF(A10=6,VLOOKUP(A10,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A10=6,(VLOOKUP($A10,Herstellerangaben!$A$4:$N$17,9,FALSE)*B10/100),\" \")","v":" "},null,{"$f":"IF($A10=6,(VLOOKUP($A10,Herstellerangaben!$A$4:$N$17,11,FALSE)*B10/100),\" \")","v":" "},null,{"$f":"IF($A10=6,(VLOOKUP($A10,Herstellerangaben!$A$4:$N$17,13,FALSE)*B10/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B10<>0,Herstellerangaben!A10,\" \")","v":" "},{"$f":"IF(A11=7,VLOOKUP(A11,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A11=7,(VLOOKUP($A11,Herstellerangaben!$A$4:$N$17,9,FALSE)*B11/100),\" \")","v":" "},null,{"$f":"IF($A11=7,(VLOOKUP($A11,Herstellerangaben!$A$4:$N$17,11,FALSE)*B11/100),\" \")","v":" "},null,{"$f":"IF($A11=7,(VLOOKUP($A11,Herstellerangaben!$A$4:$N$17,13,FALSE)*B11/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B11<>0,Herstellerangaben!A11,\" \")","v":" "},{"$f":"IF(A12=8,VLOOKUP(A12,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A12=8,(VLOOKUP($A12,Herstellerangaben!$A$4:$N$17,9,FALSE)*B12/100),\" \")","v":" "},null,{"$f":"IF($A12=8,(VLOOKUP($A12,Herstellerangaben!$A$4:$N$17,11,FALSE)*B12/100),\" \")","v":" "},null,{"$f":"IF($A12=8,(VLOOKUP($A12,Herstellerangaben!$A$4:$N$17,13,FALSE)*B12/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B12<>0,Herstellerangaben!A12,\" \")","v":" "},{"$f":"IF(A13=9,VLOOKUP(A13,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A13=9,(VLOOKUP($A13,Herstellerangaben!$A$4:$N$17,9,FALSE)*B13/100),\" \")","v":" "},null,{"$f":"IF($A13=9,(VLOOKUP($A13,Herstellerangaben!$A$4:$N$17,11,FALSE)*B13/100),\" \")","v":" "},null,{"$f":"IF($A13=9,(VLOOKUP($A13,Herstellerangaben!$A$4:$N$17,13,FALSE)*B13/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B13<>0,Herstellerangaben!A13,\" \")","v":" "},{"$f":"IF(A14=10,VLOOKUP(A14,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A14=10,(VLOOKUP($A14,Herstellerangaben!$A$4:$N$17,9,FALSE)*B14/100),\" \")","v":" "},null,{"$f":"IF($A14=10,(VLOOKUP($A14,Herstellerangaben!$A$4:$N$17,11,FALSE)*B14/100),\" \")","v":" "},null,{"$f":"IF($A14=10,(VLOOKUP($A14,Herstellerangaben!$A$4:$N$17,13,FALSE)*B14/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B14<>0,Herstellerangaben!A14,\" \")","v":" "},{"$f":"IF(A15=11,VLOOKUP(A15,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A15=11,(VLOOKUP($A15,Herstellerangaben!$A$4:$N$17,9,FALSE)*B15/100),\" \")","v":" "},null,{"$f":"IF($A15=11,(VLOOKUP($A15,Herstellerangaben!$A$4:$N$17,11,FALSE)*B15/100),\" \")","v":" "},null,{"$f":"IF($A15=11,(VLOOKUP($A15,Herstellerangaben!$A$4:$N$17,13,FALSE)*B15/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B15<>0,Herstellerangaben!A15,\" \")","v":" "},{"$f":"IF(A16=12,VLOOKUP(A16,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A16=12,(VLOOKUP($A16,Herstellerangaben!$A$4:$N$17,9,FALSE)*B16/100),\" \")","v":" "},null,{"$f":"IF($A16=122,(VLOOKUP($A16,Herstellerangaben!$A$4:$N$17,11,FALSE)*B16/100),\" \")","v":" "},null,{"$f":"IF($A16=12,(VLOOKUP($A16,Herstellerangaben!$A$4:$N$17,13,FALSE)*B16/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B16<>0,Herstellerangaben!A16,\" \")","v":" "},{"$f":"IF(A17=13,VLOOKUP(A17,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A17=13,(VLOOKUP($A17,Herstellerangaben!$A$4:$N$17,9,FALSE)*B17/100),\" \")","v":" "},null,{"$f":"IF($A17=13,(VLOOKUP($A17,Herstellerangaben!$A$4:$N$17,11,FALSE)*B17/100),\" \")","v":" "},null,{"$f":"IF($A17=13,(VLOOKUP($A17,Herstellerangaben!$A$4:$N$17,13,FALSE)*B17/100),\" \")","v":" "}]
[{"$f":"IF(Herstellerangaben!B17<>0,Herstellerangaben!A17,\" \")","v":" "},{"$f":"IF(A18=\"n\",VLOOKUP(A18,Notstrombetrieb!$E$4:$R$17,14,FALSE),\" \")","v":" "},{"$f":"IF($A18=\"n\",(VLOOKUP($A18,Herstellerangaben!$A$4:$N$17,9,FALSE)*B18/100),\" \")","v":" "},null,{"$f":"IF($A18=\"n\",(VLOOKUP($A18,Herstellerangaben!$A$4:$N$17,11,FALSE)*B18/100),\" \")","v":" "},null,{"$f":"IF($A18=\"n\",(VLOOKUP($A18,Herstellerangaben!$A$4:$N$17,13,FALSE)*B18/100),\" \")","v":" "}]
["Summen Notstrom",{"$f":"SUM(B5:B18)","v":1704.4104365058488},{"$f":"SUM(C5:D18)","v":52.363164448185756},null,{"$f":"SUM(E5:F18)","v":4.4586917539152235},null,{"$f":"SUM(G5:H18)","v":0}]
[]
["Sonstiger Hilfsstoffbedarf"]
["Zweck","Ermittlung","Hilfsstoff 1\nin l/d",null,"Hilfsstoff 2\nin l/d",null,"Hilfsstoff 3\nin l/d"]
[null,null,"Art",{"$f":"D4","v":"Adblue"},"Art",{"$f":"F4","v":"Schmieröl"},"Art",{"$f":"H4","v":0}]
["Betriebsfahrzeuge","Schätzung",5]
["Baumaschinen","Schätzung",5]
[]
[]
[]
[]
["Summen Sonstige",null,{"$f":"SUM(C24:D29)","v":10},null,{"$f":"SUM(E24:F29)","v":0},null,{"$f":"SUM(G24:H29)","v":0}]
["Summen Gesamt",null,{"$f":"C19+C30","v":62.363164448185756},null,{"$f":"E19+E30","v":4.4586917539152235},null,{"$f":"G19+G30","v":0}]
[]
[null,"Auswahlfeld"]
[]
[null,"Eingabefeld"]

{"sheet":"Hilfstabellen","index":8,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Hilfstabellen Dropdown @ Notstrombetrieb"]
["Einsatzgebiete","Wassergewinnung","Wasseraufbereitung","Wasserförderung","Verwaltung","Sonstige"]
["Wassergewinnung","PElt","PElt","PSchätzung","PElt","PElt"]
["Wasseraufbereitung",null,null,"PElt"]
["Wasserförderung",null,null,"PP"]
["Verwaltung",null,null,"PHyd"]
["Sonstige"]
[]
["Nummer Auswahl Notstrom","Auswahl bereits getroffen ?","dynamische Auswahlliste"]
[]
[{"$f":"IF(Herstellerangaben!E4>0,Herstellerangaben!A4,\" \")","v":1},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A11)=0,A11,\"\")","v":""},{"$f":"IFERROR(SMALL($B$11:$B$23,ROW(A1)),\"\")","v":""}]
[{"$f":"IF(Herstellerangaben!E5>0,Herstellerangaben!A5,\" \")","v":2},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A12)=0,A12,\"\")","v":""},""]
[{"$f":"IF(Herstellerangaben!E6>0,Herstellerangaben!A6,\" \")","v":3},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A13)=0,A13,\"\")","v":""},""]
[{"$f":"IF(Herstellerangaben!E7>0,Herstellerangaben!A7,\" \")","v":4},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A14)=0,A14,\"\")","v":""},""]
[{"$f":"IF(Herstellerangaben!E8>0,Herstellerangaben!A8,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A15)=0,A15,\"\")","v":" "},""]
[{"$f":"IF(Herstellerangaben!E9>0,Herstellerangaben!A9,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A16)=0,A16,\"\")","v":" "},""]
[{"$f":"IF(Herstellerangaben!E10>0,Herstellerangaben!A10,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A17)=0,A17,\"\")","v":" "},""]
[{"$f":"IF(Herstellerangaben!E11>0,Herstellerangaben!A11,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A18)=0,A18,\"\")","v":" "},""]
[{"$f":"IF(Herstellerangaben!E12>0,Herstellerangaben!A12,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A19)=0,A19,\"\")","v":" "},{"$f":"IFERROR(SMALL($B$11:$B$23,ROW(#REF!)),\"\")","v":""}]
[{"$f":"IF(Herstellerangaben!E13>0,Herstellerangaben!A13,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A20)=0,A20,\"\")","v":" "},{"$f":"IFERROR(SMALL($B$11:$B$23,ROW(A9)),\"\")","v":""}]
[{"$f":"IF(Herstellerangaben!E14>0,Herstellerangaben!A14,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A21)=0,A21,\"\")","v":" "},{"$f":"IFERROR(SMALL($B$11:$B$23,ROW(A10)),\"\")","v":""}]
[{"$f":"IF(Herstellerangaben!E15>0,Herstellerangaben!A15,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A22)=0,A22,\"\")","v":" "},{"$f":"IFERROR(SMALL($B$11:$B$23,ROW(A11)),\"\")","v":""}]
[{"$f":"IF(Herstellerangaben!E16>0,Herstellerangaben!A16,\" \")","v":" "},{"$f":"IF(COUNTIF(Notstrombetrieb!$E$4:$E$17,A23)=0,A23,\"\")","v":" "},{"$f":"IFERROR(SMALL($B$11:$B$23,ROW(A12)),\"\")","v":""}]
[]
[]
["Hilfstabellen Dropdown @ Herstellerangaben"]
["Hilfsstoffe"]
["Adblue"]
["Schmieröl"]
["Kältemittel"]
[]
["Hilfstabellen Dropdown @ Hilfsstoffbedarf"]
["Hilfsstoffbedarf","Ermittlung"]
["Betriebsfahrzeuge","Schätzung"]
["Baumaschinen","Berechnung"]
["Sonstige","Herstellerangabe"]