{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Algorithmus","Beispiel Position erfassen","Beispiel Auf- bzw. Abrunden"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Algorithmus","index":0,"n_rows":27,"n_cols":5,"rows_kept":27,"flags":["formulas_cached_only"]}
["Rundungsalgorithmus"]
[]
[]
["Position erfassen:"]
[]
["diff = |max / min|"]
["pos = log(diff)"]
["if (pos < 0) ceil(pos)",{"$nulls":3},"ceil  = Aufrunden"]
["else floor(pos)",{"$nulls":3},"floor = Abrunden"]
[]
[]
[]
["max aufrunden:"]
[]
["max = max / 10^pos"]
["if (max < 0) max = floor(max)",{"$nulls":3},"floor = Abrunden"]
["else max = ceil(max)",{"$nulls":3},"ceil  = Aufrunden"]
["max = (max * 10^pos)"]
[]
[]
[]
["min abrunden:"]
[]
["min = min / 10^pos"]
["if (min < 0) min = ceil(min)",{"$nulls":3},"ceil  = Aufrunden"]
["else min = floor(min)",{"$nulls":3},"floor = Abrunden"]
["min = (min * 10^pos)"]

{"sheet":"Beispiel Position erfassen","index":1,"n_rows":36,"n_cols":5,"rows_kept":36,"flags":["formulas_cached_only"]}
["Diff-Position erfassen"]
[]
[]
["Min = -0.03757"]
["Max = -0.03726"]
["(-0.03757) - (-0.03726) = 0.00031"]
["log(0.00031) = -3.5086"]
["floor(-3.5086) = -4.0",{"$nulls":3},"floor = Abrunden"]
[]
[]
["Min =  -2.345"]
["Max = +13.700"]
["13.700 - (-2.345) = 16.045"]
["log(16.045) = 1.2053"]
["ceil(1.2053) = +2.0",{"$nulls":3},"ceil  = Aufrunden"]
[]
[]
["Min = +1.2344 "]
["Max = +2.1000"]
["2.1000 - 1.2344 = 0.8656"]
["log(0.8656) = -0.0626"]
["floor(-0.0626) = -1.0",{"$nulls":3},"floor = Abrunden"]
[]
[]
["Min = 8.675"]
["Max = 8.676"]
["8.676 - 8.675 = 0.001"]
["log(0.001) = -3.0000"]
["floor(-3.000) = -3.0",{"$nulls":3},"floor = Abrunden"]
[]
[]
["Min = 27439104"]
["Max = 28778496"]
["28778496 - 27439104 = 1339392"]
["log(1339392) = 6.1269"]
["ceil(6.1269) = +7.0",{"$nulls":3},"ceil  = Aufrunden"]

{"sheet":"Beispiel Auf- bzw. Abrunden","index":2,"n_rows":45,"n_cols":8,"rows_kept":45,"flags":["formulas_cached_only"]}
["Max. aufrunden",{"$nulls":6},"Min. abrunden"]
[]
[]
["Aufrunden:",{"$nulls":6},"Abrunden:"]
[]
["max, Hunderter:",{"$nulls":6},"min, Hunderter:"]
["123.4567 / 10^2 = 1.234567",{"$nulls":6},"123.4567 / 10^2 = 1.234567"]
["floor(1.234567) = 2.0",{"$nulls":6},"ceil(1.234567) = 1.0"]
["2.0 * 10^2 = 200.0",{"$nulls":6},"1 * 10^2 = 100.0"]
[]
[]
["max, Zehner:",{"$nulls":6},"min, Zehner:"]
["123.4567 / 10^1 = 12.34567",{"$nulls":6},"123.4567 / 10^1 = 12.34567"]
["floor(12.34567) = 13.0",{"$nulls":6},"ceil(12.34567) = 12.0"]
["13.0 * 10^1 = 130.0 ",{"$nulls":6},"12 * 10^1 = 120.0"]
[]
[]
["max, Einer:",{"$nulls":6},"min, Einer:"]
["123.4567 / 10^0 = 123.4567",{"$nulls":6},"123.4567 / 10^0 = 123.4567"]
["floor(123.4567) = 124.0",{"$nulls":6},"ceil(123.4567) = 123.0"]
["124 * 10^1 = 124.0",{"$nulls":6},"123 * 10^1 =123.0"]
[]
[]
["max, Zehntel:",{"$nulls":6},"min, Zehntel:"]
["123.4567 / 10^-1 = 1234.567",{"$nulls":6},"123.4567 / 10^-1 = 1234.567"]
["floor(1234.567) = 1235.0",{"$nulls":6},"ceil(1234.567) = 1234.0"]
["1235 * 10^-1 = 123.5",{"$nulls":6},"1234 * 10^-1 = 123.4"]
[]
[]
["max, Hundertstel:",{"$nulls":6},"min, Hunderstel:"]
["123.4567 / 10^-2 = 12345.67",{"$nulls":6},"123.4567 / 10^-2 = 12345.67"]
["floor(12345.67) = 12346.0",{"$nulls":6},"ceil(12345.67) = 12345.0"]
["12346 * 10^-2 = 123.46",{"$nulls":6},"12345 * 10^-2 = 123.45"]
[]
[]
["max, Tausendstel:",{"$nulls":6},"min, Tausendstel:"]
["123.4567 / 10^-3 = 123456.7",{"$nulls":6},"123.4567 / 10^-3 = 123456.7"]
["floor(123456.7) = 123457.0",{"$nulls":6},"ceil(123456.7) = 123456.0"]
["123457 * 10^-3 = 123.457",{"$nulls":6},"123456 * 10^-3 = 123.456"]
[]
[]
["Max = 28778496",{"$nulls":6},"Min = 27439104"]
["28778496 / 10^7 = 2.8778496",{"$nulls":6},"27439104 / 10^7 = 2.7439104"]
["floor(2.8778496) = 3.0",{"$nulls":6},"ceil(2.7439104) = 2.0"]
["3 * 10^7 = 30000000",{"$nulls":6},"2.0 * 10^7 = 20000000"]