{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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","formulas":"cached_only"}

{"sheet":"Tabelle1","index":0,"n_rows":66,"n_cols":6,"rows_kept":66,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Berechnung von Widerständen und Verlussten"]
[]
["Formelzeichen",null,null,"Beschreibung","Formel","Ergebnis"]
[]
["d","=",6.7,"Durchmesser"]
[null,null,"bitte eingeben",null,null,"messen!"]
[]
["A","=",35,"Querschnittsfläche","A = pi * d²/4 (pi = 3.14159...)"]
[null,null,"bitte eingeben oder von rechts übertragen ",null,null,35.256493774999996]
[]
["l","=",3,"Länge (in Meter) (klein L)"]
[null,null,"bitte messen und eingeben"]
[]
["U","=",null,"elektrische Spannung (V)"]
[null,null,"bitte eingeben"]
[]
["I","=",120,"elektrische Stromstärke (A) (gross i)"]
[null,null,"bitte eingeben"]
[]
["R","=",0.00102,"elektrischer Widerstand","R = p * l\\A"]
[null,null,"bitte eingeben oder von rechts übertragen ",null,null,0.0015257142857142858]
[]
["G","=",null,"Leitwert G eines Leiters","G = 1/R und R = U/I"]
[null,null,"bitte eingeben"]
[]
["p","=",0.0178,"spezifischen Widerstand (für Kupfer bei 20C: 0,0178 µΩm)"]
[null,null,"oberen Wert von rechts unten eintragen! (Temperaturausgleich…)"]
["C",20,0.004,"Temperatur * Temperaturkoeffizient = neuer Spezifischer Widerstand. Rechts:",0.0178]
[]
[null,null,null,"“Verlustspannung”:","P = R * I"]
[null,null,"bitte eingeben oder von rechts übertragen ",null,null,0.12240000000000001]
[]
["W","=",1.5,"Watt (Verlusst)","P = R * I²"]
[null,null,"bitte eingeben oder von rechts übertragen ",null,null,14.688]
[]
[]
[]
["Der Widerstand eines (Kupfer)Kabels lässt sich wie folgt berechnen:",null,null,null,"R = p * l\\A"]
[]
[]
[]
[null,null,null,"Bei 1.5 Durchmesser ( = 1.77 mm²) und 1 m: 0.0178 * 1m/1.77mm² = 0.01 Ohm"]
[]
[null,null,null,"Die Verlustleistung bei einem 4 Akku vorne bei fast 7mm Durchmesser und 3m (2*1.5m):"]
[]
[null,null,null,"R = 0.0178 * 3m/35mm² = 0.0015 Ohm"]
[]
[null,null,null,"Verlustleistung (Watt) nach dem Ohmschen Gesetz P = R * I²:"]
[]
[null,null,null,"0.0015 * 120A * 120A = 21 Watt"]
[]
[null,null,null,"P = Verlustleistung (Watt)"]
[null,null,null,"R = Widerstand des Kabels"]
[null,null,null,"I = angenommene Strombelastung (Ampere)"]
[]
[]
[]
[null,null,null,"P = R * I"]
[]
[null,null,null,"0.0015 * 120A = 0.18 V (bei 1.8mm² und 3m)"]
[]
[null,null,null,"Beispiel Lampen (Helligkeit):"]
[]
[null,null,null,"R = 0.0178 * 2m/1.8mm² = 0.02 Ohm"]
[]
[null,null,null,"0.02 * 3A = 0.06 V"]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}