{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover","Wandtemperatur","Temperaturverteilung","Querschnitt"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":2,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Cover","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA"]
[]
[]
[null,"Kapitel",9]
[null,"Thema","Berechnungen aus der Thermodynamik"]
[]
[null,"Inhalt","Nichtstationäre Wärmeströmung durch eine Wand"]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2020-09-01"]
[null,"Version","6.0"]
[]
[]
[null,"Springer Vieweg Verlag"]

{"sheet":"Wandtemperatur","index":1,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Wandstärke x [m]",1]
["Schrittanzahl n (max=95)",10]
["Wärmeleitfähigkeit L [W/m grd]",1.2]
["Spez. Wärmekapazität c [kJ/kg grd]",1]
["Dichte d [kg/m³]",2000]
["Wärmeübergangszahl-Innen  a1 [W/m² K]",8]
["Wärmeübergangszahl-Aussen a2 [W/m² K]",5]
["Innentemperatur Ti [grd]",80]
["Außentemperatur Ta [grd]",20]
["Anzahl der Durchläufe",20]
[]
[]
["Temperatur (an der Stelle x)","t","Ti","T(0)","T(.05)","T(.15)","T(.25)","T(.35)","T(.45)","T(.55)","T(.65)","T(.75)","T(.85)","T(.95)","T(1)","Ta"]
["Eingabe Start-Temperaturverlauf ",0,80,35,20,20,20,20,20,20,20,20,20,20,20,20]
[null,8.3000000000000007,80,42.5,35,20,20,20,20,20,20,20,20,20,20,20]
[null,16.600000000000001,80,48.125,38.75,27.5,20,20,20,20,20,20,20,20,20,20]
[null,25,80,51.40625,43.4375,29.375,23.75,20,20,20,20,20,20,20,20,20]
[null,33.299999999999997,80,53.6328125,45.546875,33.59375,24.6875,21.875,20,20,20,20,20,20,20,20]
[null,41.6,80,55.478515625,48.18359375,35.1171875,27.734375,22.34375,20.9375,20,20,20,20,20,20,20]
[null,50,80,56.84814453125,49.6044921875,37.958984375,28.73046875,24.3359375,21.171875,20.46875,20,20,20,20,20,20]
[null,58.3,80,58.0914306640625,51.380615234375,39.16748046875,31.1474609375,24.951171875,22.40234375,20.5859375,20.234375,20,20,20,20,20]
[null,66.599999999999994,80,59.059600830078125,52.42889404296875,41.2640380859375,32.059326171875,26.77490234375,22.7685546875,21.318359375,20.29296875,20.1171875,20,20,20,20]
[null,75,80,59.976844787597656,53.739242553710938,42.244110107421875,34.01947021484375,27.4139404296875,24.046630859375,21.53076171875,20.7177734375,20.146484375,20.05859375,20,20,20]
[null,83.3,80,60.71324348449707,54.556865692138672,43.879356384277344,34.829025268554688,29.033050537109375,24.47235107421875,22.3822021484375,20.838623046875,20.38818359375,20.0732421875,20.029296875,20.0146484375,20]

{"sheet":"Temperaturverteilung","index":2,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[4,-1,0,0,0,-1,0,0,0,0,0,0,0,0,0,24,null,{"$f":"MMULT(MINVERSE(Matrix),Vektor)","v":16.031334114861682}]
[-1,4,-1,0,0,0,-1,0,0,0,0,0,0,0,0,18,null,20.313016551653931]
[0,-1,4,-1,0,0,0,-1,0,0,0,0,0,0,0,24,null,25.170018126203697]
[0,0,-1,4,-1,0,0,0,-1,0,0,0,0,0,0,36,null,31.146142845649788]
[0,0,0,-1,4,0,0,0,0,-1,0,0,0,0,0,84,null,35.960112582770577]
[-1,0,0,0,0,4,-1,0,0,0,-1,0,0,0,0,22,null,19.812319907792787]
[0,-1,0,0,0,-1,4,-1,0,0,0,-1,0,0,0,0,null,22.050713965550358]
[0,0,-1,0,0,0,-1,4,-1,0,0,0,-1,0,0,0,null,25.220913107511041]
[0,0,0,-1,0,0,0,-1,4,-1,0,0,0,-1,0,0,null,27.454440673624894]
[0,0,0,0,-1,0,0,0,-1,4,0,0,0,0,-1,30,null,28.694307485432535]
[0,0,0,0,0,-1,0,0,0,0,4,-1,0,0,0,34,null,19.167231550759116]
[0,0,0,0,0,0,-1,0,0,0,-1,4,-1,0,0,24,null,22.856606295243676]
[0,0,0,0,0,0,0,-1,0,0,0,-1,4,-1,0,32,null,26.208479664665234]
[0,0,0,0,0,0,0,0,-1,0,0,0,-1,4,-1,24,null,24.756399255906203]
[0,0,0,0,0,0,0,0,0,-1,0,0,0,-1,4,32,null,21.362676685334684]

{"sheet":"Querschnitt","index":3,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[12,12,18,24,36,42,42]
[12,{"$f":"TRANSPOSE(Lösung1)","v":16.031334114861682},20.313016551653931,25.170018126203697,31.146142845649788,35.960112582770577,42]
[22,{"$f":"TRANSPOSE(Lösung3)","v":19.167231550759116},22.856606295243676,26.208479664665234,24.756399255906203,21.362676685334684,30]
[16,19.167231550759116,22.856606295243676,26.208479664665234,24.756399255906203,21.362676685334684,16]
[16,16,24,32,24,16,16]