{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Muster"],"not_rendered":{"images":7,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Muster","index":0,"n_rows":54,"n_cols":19,"rows_kept":54,"merged":[[3,0,3,1]],"flags":["formulas_cached_only"]}
["Berechnung der Leitungsquerschnitte hinsichtlich Spannungsfall für 230/400 V, 50 Hz [DIN 0100-520]",{"$nulls":14},"IBS Döbeln"]
[{"$nulls":15},"03431-574153"]
["Muster",{"$nulls":9},1,0,"Strombasis",null,null,"Service@IBSDL.de"]
[]
["Nr.","Strecke von-nach","Anschluss","n","A [mm²]","Cu/Al","rho [Ohm mm²/m]","Phase","cos Phi","P [kW]","Strom [A]","Sich. [A]","LängeIst [m]","Längemax [m]","T [°C]","Rk [Ohm]","Xk [Ohm]","dUmax [%]","dU [%]"]
["1","Muster","Muster","1",{"v":25,"d":"25.0"},"Cu",0.0179,3,{"v":1,"d":"1.00"},3.68,{"v":5.333333333333334,"d":"5.33"},16,{"v":1000,"d":"1000.0"},{"v":1422.6621675732497,"d":"1422.7"},30,{"v":0.7578222184955161,"d":"0.758"},{"v":0.10139784169590696,"d":"0.101"},{"v":2.5,"d":"2.50"},{"v":1.757268912453371,"d":"1.76"}]
["2",null,null,"2",{"v":25,"d":"25.0"},"Cu",0.0179,3,{"v":1,"d":"1.00"},3.68,{"v":5.333333333333334,"d":"5.33"},16,{"v":1000,"d":"1000.0"},{"v":2845.3243351464994,"d":"2845.3"},30,{"v":0.37891110924775806,"d":"0.379"},{"v":0.05069892084795348,"d":"0.051"},{"v":2.5,"d":"2.50"},{"v":0.8786344562266855,"d":"0.88"}]
["3",null,null,"1",{"v":50,"d":"50.0"},"Cu",0.0179,3,{"v":1,"d":"1.00"},3.68,{"v":5.333333333333334,"d":"5.33"},16,{"v":1000,"d":"1000.0"},{"v":2810.00673359284,"d":"2810.0"},30,{"v":0.3836734578288794,"d":"0.384"},{"v":0.09726731131590675,"d":"0.097"},{"v":2.5,"d":"2.50"},{"v":0.8896775833713148,"d":"0.89"}]
["4",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["5",null,null,"1",{"v":150,"d":"150.0"},"Cu",0.0179,3,{"v":1,"d":"1.00"},{"v":36.8,"d":"36.80"},{"v":53.33333333333333,"d":"53.33"},160,{"v":1000,"d":"1000.0"},{"v":802.944987935853,"d":"802.9"},30,{"v":0.1342713406520611,"d":"0.134"},{"v":0.09106251400279268,"d":"0.091"},{"v":2.5,"d":"2.50"},{"v":3.113538333960837,"d":"3.11"}]
["6",null,null,"2",{"v":150,"d":"150.0"},"Cu",0.0179,3,{"v":1,"d":"1.00"},{"v":36.8,"d":"36.80"},{"v":53.33333333333333,"d":"53.33"},160,{"v":1000,"d":"1000.0"},{"v":1605.889975871706,"d":"1605.9"},30,{"v":0.06713567032603054,"d":"0.067"},{"v":0.04553125700139634,"d":"0.046"},{"v":2.5,"d":"2.50"},{"v":1.5567691669804185,"d":"1.56"}]
["7",null,null,"1",{"v":300,"d":"300.0"},"Cu",0.0179,3,{"v":1,"d":"1.00"},{"v":36.8,"d":"36.80"},{"v":53.33333333333333,"d":"53.33"},160,{"v":1000,"d":"1000.0"},{"v":1498.6264656703352,"d":"1498.6"},30,{"v":0.07194087550814439,"d":"0.072"},{"v":0.08735300229843349,"d":"0.087"},{"v":2.5,"d":"2.50"},{"v":1.668194214681609,"d":"1.67"}]
["8",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["9",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["10",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["11",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["12",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["13",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["14",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["15",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["16",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["17","In der Vollversion ist die Tabelle erweitert um den 1poligen Ik",null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["18","bei variabler Vorimpedanz, und die NE-Metallzahlen, NE-Me-",null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["19","tallmassen und NE-Metallpreise.",null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["20",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["21",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["22",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["23",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["24",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["25",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["26",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["27",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["28",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["29",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["30",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["31",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["32",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["33",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["34",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["35",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["36",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["37",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["38",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["39",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
["40",null,null,"1",null,"Cu",0.0179,3,null,null,"",null,null,"",30,"","",{"v":2.5,"d":"2.50"},""]
[]
["Randbedingung: spezifischer Widerstand Cu bei 20°C in [Ohm mm² / m]",{"$nulls":5},0.0179,null,null,"Summe",{"$nulls":3},"Kabelanzahl",null,"n=Kabelanzahl"]
["Randbedingung: spezifischer Widerstand Al bei 20°C [Ohm mm² / m]",{"$nulls":5},0.0288,null,null,121.43999999999998,{"$nulls":3},6,null,"K3=1: Berechnungsbasis ist der Strom aus der Leistung"]
["Randbedingung: Spannung Leiter-Erde [V]",{"$nulls":5},230]
[]
["- bedingte Formatierung Strom",{"$nulls":3},"abhängig von Querschnitt, Polzahl und Material -Verlegung in Luft",{"$nulls":10},"variablennamen statt feldbezüge"]
["- bedingte Formatierung Sicherung",{"$nulls":3},"abhängig von Strom",{"$nulls":10},"T und dUmax als festen Bezug definieren"]
["- bedingte Formatierung Ist-Länge",{"$nulls":3},"abhängig von max. Länge"]
["- bedingte Formatierung Spannungsfall",{"$nulls":3},"abhängig von max. Spannungsfall",{"$nulls":10},"R einschließlich Stromverdrängung bei 50 Hz"]