{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["English","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":"English","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 Calculator"]
[null,"Introduction"]
[null,"Continuous level measurement by hydrostatic pressure utilizes the areal force generated by the height and density of the media and gravity. To accurately measure the filling height in tanks, choosing the fitting sensor parameters like accuracy and measuring range is crucial. This simple calculator is made to help you with the calculations and to assure the sensor parameters match the tank parameters. Additional this calculator helps you to minimize dregs and to monetize your possible saving with a CleverLevel level switch at the bottom of the tank."]
[]
[null,"Tank type",null,"vertical tank"]
[null,"Tank diameter","Di",2,"m"]
[null,{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,8,FALSE)","v":"Max. filling height"},{"$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,"Media",null,"water",null,null,{"$f":"D12*100*60","v":{"$error":"#VALUE!"}},"cm/min"]
[null,"Media density","ρ",{"$f":"VLOOKUP(D12,Tabelle2!F7:G9,2,FALSE)","v":999.97500000000002},"kg/m3",null,{"$f":"D13/10","v":99.997500000000002},"cm"]
[]
[null,"Sensor Accuracy (20 °C) \n(includes linearity, hysteresis, repeatability, error of span and zero point according limit point adjustment)",null,1,"%"]
[]
[]
[null,"Tank volume","V",{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,5,FALSE)","v":94.247779607693786},"m3"]
[]
[null,"Max. pressure at tank bottom","pmax",{"$f":"VLOOKUP(Chosen_tank_type,Tank_dependent,6,FALSE)","v":2.9429264250000005},"bar"]
[null,"Sensor measuring range",null,{"$f":"INDEX(Pressure_ranges,MATCH(Max_pressure,Upper_pressure_range,-1),3)","v":"0 ... 4 "},"bar",null,null,null,{"$f":"CONCATENATE(\"Baumer ordering code: \",INDEX(Tabelle2!A1:C22,MATCH(English!D20,Tabelle2!A1:A22,-1),2))","v":"Baumer ordering code: PBMH, PP20H, PBMN flush:B19; PFMH:BC3"}]
[]
[null,"Max. measuring error",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,"Number of CIP cycles per day","#",0.2,"times per day"]
[null,"Number of production days per year","#",200]
[]
[null,"Loss without CleverLevel",null,{"$f":"D25*D29","v":256.12319945946621},"l/day",null,null,null,{"$f":"D32*D30","v":51224.639891893239},"l/year"]
[null,"Loss with CleverLevel",null,0,"l/day",null,null,null,{"$f":"D33*D30","v":0},"l/year"]
[]
[null,"Difference (Savings)",null,{"$f":"D32-D33","v":256.12319945946621},"l/day",null,null,null,{"$f":"I32-I33","v":51224.639891893239},"l/year"]
[]
[null,"Cost of Media",null,0.3,"Euro/l"]
[null,"Total Cost",null,{"$f":"D35*D37","v":76.836959837839856},"€/day",null,null,null,{"$f":"I35*D37","v":15367.391967567972},"€/year"]

{"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","vertical 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. filling height","hmax","m"]
[100,"PBMN flush:B31","0 ... 100 ",null,"Horizontaler Tank","horizontal Tank","Tank lenght","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","water",999.97500000000002,null,null,null,1,null,"PP20H"]
[16,"PBMH, PP20H, PBMN flush:B24; PFMH:BC4","0 ... 16",null,"Milch","milk",1030,null,null,null,0.5,null,"PP20H","PBMN flush"]
[10,"PBMH, PP20H, PBMN flush:B22; PFMH:BC4","0 ... 10",null,"Olivenöl","olive oil",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 "]