{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Deutsch","Tabelle2"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Deutsch","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,2,9],[29,4,29,9],[28,4,28,9],[4,1,4,9],[3,1,3,9],[26,1,26,9],[20,8,20,9]]}
[]
[]
[null,"Tank Kalkulator"]
[null,"Einleitung"]
[null,"Die kontinuierliche Füllstandmessung mittels hydrostatischem Druck nutzt die Flächenkraft, die durch die Höhe und Dichte des Mediums und der Schwerkraft erzeugt wird. Um die Füllhöhe in Tanks genau zu messen, ist die Auswahl der passenden Sensorparameter wie Genauigkeit und Messbereich entscheidend. Dieser einfache Rechner hilft Ihnen bei den Berechnungen und stellt sicher, dass die Sensorparameter den Tankparametern entsprechen. Darüber hinaus hilft dieser Rechner Ihnen, Rückstände zu minimieren und Ihre möglichen Einsparungen mit einem CleverLevel Schalter am Boden des Tanks zu quantifizieren."]
[]
[null,"Tank Art",null,"Vertikaler Tank"]
[null,"Tank Durchmesser","Di",2,"m"]
[null,{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,8,FALSE)","v":"Max. Füllhöhe"},{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,9,FALSE)","v":"hmax"},30,{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,10,FALSE)","v":"m"}]
[null,{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,2,FALSE)","v":0},{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,3,FALSE)","v":0},null,{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,4,FALSE)","v":0}]
[]
[null,"Medium",null,"Wasser",null,null,{"$f":"D12*100*60","v":{"$error":"#VALUE!"}},"cm/min"]
[null,"Medien Dichte","ρ",{"$f":"VLOOKUP(D12,Tabelle2!F7:G9,2,FALSE)","v":999.97500000000002},"kg/m3",null,{"$f":"D13/10","v":99.997500000000002},"cm"]
[]
[null,"Sensor Genauigkeit (20 °C) \n(Beinhaltet die Nullpunkt-, Endwert- und Linearitätsabweichung (nach Grenzpunkteinstellung) sowie Hysterese und Nichtwiederholbarkeit (EN 61298-2))",null,1,"%"]
[]
[]
[null,"Tankvolumen","V",{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,5,FALSE)","v":94.247779607693786},"m3"]
[]
[null,"Max. Druck am Tankboden","pmax",{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,6,FALSE)","v":2.9429264250000005},"bar"]
[null,"Sensor Messbereich",null,{"$f":"INDEX(Pressure_ranges,MATCH(Max_pressure,Upper_pressure_range,-1),3)","v":"0 ... 4 "},"bar",null,null,null,{"$f":"CONCATENATE(\"Baumer Bestellbezeichnung: \",INDEX(Tabelle2!A1:C22,MATCH(Deutsch!D20,Tabelle2!A1:A22,-1),2))","v":"Baumer Bestellbezeichnung: PBMH, PP20H, PBMN flush:B19; PFMH:BC3"}]
[]
[null,"Max. Messabweichung",null,{"$f":"(INDEX(Pressure_ranges,MATCH(Max_pressure,Upper_pressure_range,-1),1))*Sensor_accuracy*10^-2","v":0.04},"bar"]
[null,null,null,{"$f":"Error_pressure*10^8/(Media_density*9.813)","v":407.63273234485501},"mm"]
[null,null,null,{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,7,FALSE)","v":1280.615997297331},"l"]
[]
[]
[]
[null,"Anzahl von CIP Zyklen pro Tag","#",0.2,"Zyklen pro Tag"]
[null,"Anzahl von Produktionstagen pro Jahr","#",200]
[]
[null,"Verlust ohne CleverLevel",null,{"$f":"D25*D29","v":256.12319945946621},"l/Tag",null,null,null,{"$f":"D32*D30","v":51224.639891893239},"l/Jahr"]
[null,"Verlust mit CleverLevel",null,0,"l/Tag",null,null,null,{"$f":"D33*D30","v":0},"l/Jahr"]
[]
[null,"Differenz (Einsparung)",null,{"$f":"D32-D33","v":256.12319945946621},"l/Tag",null,null,null,{"$f":"I32-I33","v":51224.639891893239},"l/Jahr"]
[]
[null,"Kosten des Mediums",null,0.3,"Euro/l"]
[null,"Gesamtkosten",null,{"$f":"D35*D37","v":76.836959837839856},"€/Tag",null,null,null,{"$f":"I35*D37","v":15367.391967567972},"€/Jahr"]

{"sheet":"Tabelle2","index":1,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[400,"PBMN flush:B38","0 ... 400 ",null,"Vertikaler Tank","Vertikaler Tank",null,null,null,{"$f":"((Tank_diameter)^2/4)*PI()*Max_filling_height","v":94.247779607693786},{"$f":"(Max_filling_height*Media_density*9.81)*10^-5","v":2.9429264250000005},{"$f":"((Tank_diameter)^2/4)*PI()*Error_height","v":1280.615997297331},"Max. Füllhöhe","hmax","m"]
[100,"PBMN flush:B31","0 ... 100 ",null,"Horizontaler Tank","Horizontaler Tank","Tanklänge","L","m",{"$f":"((Tank_diameter^2)/4)*Tank_length*(ACOS(((Tank_diameter/2)-Tank_diameter)/(Tank_diameter/2))-(((Tank_diameter/2)-Tank_diameter)*((SQRT(2*(Tank_diameter/2)*Tank_diameter-(Tank_diameter^2)))/((Tank_diameter/2)^2))))","v":0},{"$f":"(Tank_diameter*Media_density*9.81)*10^-5","v":0.19619509500000001},{"$f":"(10^3)*(((Tank_diameter^2)/4)*Tank_length*(ACOS(((Tank_diameter/2)-(Error_height*10^-3))/(Tank_diameter/2))-(((Tank_diameter/2)-(Error_height*10^-3))*((SQRT(2*(Tank_diameter/2)*(Error_height*10^-3)-((Error_height*10^-3)^2)))/((Tank_diameter/2)^2)))))","v":0}]
[68,"PFMH:BC6","0 … 68"]
[40,"PBMH, PP20H, PBMN flush:B27; PFMH:BC6","0 ... 40"]
[34,"PFMH:BC5","0 … 34"]
[25,"PBMH, PP20H, PBMN flush:B26; PFMH:BC5","0 ... 25"]
[20,"PBMH, PP20H, PBMN flush:B25; PFMH:BC4","0 ... 20",null,"Wasser","Wasser",999.97500000000002,null,null,null,1,null,"PP20H"]
[16,"PBMH, PP20H, PBMN flush:B24; PFMH:BC4","0 ... 16",null,"Milch","Milch",1030,null,null,null,0.5,null,"PP20H","PBMN flush"]
[10,"PBMH, PP20H, PBMN flush:B22; PFMH:BC4","0 ... 10",null,"Olivenöl","Olivenöl",910,null,null,null,0.25,"PBMH",null,"PBMN flush","PFMH"]
[6,"PBMH, PP20H, PBMN flush:B20; PFMH:BC4","0 ... 6 ",{"$nulls":7},0.1,"PBMH",null,"PBMN flush","PFMH"]
[5,"PFMH:BC3","0 … 5"]
[4,"PBMH, PP20H, PBMN flush:B19; PFMH:BC3","0 ... 4 "]
[2.5,"PBMH, PP20H and PBMN flush:B18; \nPFMH:BC3","0 ... 2,5 "]
[2,"PBMH, PP20H, PBMN flush:B17; PFMH:BC3","0 ... 2 "]
[1.6,"PBMH, PP20H, PBMN flush:B16; PFMH:BC3","0 ... 1,6 "]
[1,"PBMH, PP20H, PBMN flush:B15 PFMH:BC2","0 ... 1 "]
[0.6,"PBMH, PP20H, PBMN flush:B12; PFMH:BC2","0 ... 0,6 "]
[0.4,"PBMH, PP20H, PBMN flush:B11; PFMH:BC2","0 ... 0,4 "]
[0.34499999999999997,"PFMH:BC1","0 ... 0,345 "]
[0.25,"PBMH, PBMN flush:B10; PFMH:BC1","0 ... 0,25"]
[0.16,"PBMH, PBMN flush:B09; PFMH:BC1","0 ... 0,16"]
[0.1,"PBMH, PBMN flush:B08; PFMH:BC1","0 ... 0,1 "]