{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Berechnung","Info","Daten","Formeln","VDI-WA"],"not_rendered":{"charts":9,"images":3,"macros":1,"external_links":1,"defined_names":8,"comments":1,"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":"Berechnung","index":0,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Berechnung mit der Joback Methode für bis zu 10 Atomgruppen "]
[]
["In der Tabelle \"Daten\" befindet sich eine Datensammlung und ein Beispiel Berechnung der Joback Methode"]
["In der Tabelle \"Formeln\" befinden sich die in Wikipedia angegeben Formeln. Die im VDI Wärmeatlas 2010 veröffentlichten Daten können abweichen"]
[]
[]
["Formel","CH3-CO-CH3","Temperatur [K]",300]
["Spalten-Nr. in Tabelle Daten",null,null,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,4,3]
["Lfd. Nr.","Atomgruppen","Anzahl Atomgruppen","Tc [K]","Pc [bar]","Vc (cm3/mol]","Tb [K]","Tm [K]","Hf [kJ/mol]","Gf [kJ/mol]","Cpa id. Gas [J/mol.K]","Cpb","Cpc","Cpd","Hm [kJ/mol]","Hv [kJ/mol]","ηa Flüssig [Pa.s]","ηb","MG [g/mol]","NA (Anzahl Atome)"]
[1,"–CH3",2,{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,D$8,FALSE)","v":1.41E-2},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,E$8,FALSE)","v":-1.1999999999999999E-3},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,F$8,FALSE)","v":65},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,G$8,FALSE)","v":23.58},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,H$8,FALSE)","v":-5.0999999999999996},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,I$8,FALSE)","v":-76.45},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,J$8,FALSE)","v":-43.96},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,K$8,FALSE)","v":19.5},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,L$8,FALSE)","v":-8.0800000000000004E-3},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,M$8,FALSE)","v":1.5300000000000001E-4},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,N$8,FALSE)","v":-9.6699999999999999E-8},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,O$8,FALSE)","v":0.90800000000000003},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,P$8,FALSE)","v":2.3730000000000002},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,Q$8,FALSE)","v":548.29},{"$f":"VLOOKUP($B10,Daten!$A$8:$S$63,R$8,FALSE)","v":-1.7190000000000001},{"$f":"VLOOKUP($B10,Daten!$A$8:$R$59,S$8,FALSE)","v":15},{"$f":"VLOOKUP($B10,Daten!$A$8:$R$59,T$8,FALSE)","v":4}]
[2,">C=O (Nichtring)",1,{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,D$8,FALSE)","v":3.7999999999999999E-2},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,E$8,FALSE)","v":3.0999999999999999E-3},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,F$8,FALSE)","v":62},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,G$8,FALSE)","v":76.75},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,H$8,FALSE)","v":61.2},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,I$8,FALSE)","v":-133.22},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,J$8,FALSE)","v":-120.5},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,K$8,FALSE)","v":6.45},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,L$8,FALSE)","v":6.7000000000000004E-2},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,M$8,FALSE)","v":-3.57E-5},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,N$8,FALSE)","v":2.86E-9},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,O$8,FALSE)","v":4.1890000000000001},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,P$8,FALSE)","v":8.9719999999999995},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,Q$8,FALSE)","v":340.35},{"$f":"VLOOKUP($B11,Daten!$A$8:$S$63,R$8,FALSE)","v":-0.35},{"$f":"VLOOKUP($B11,Daten!$A$8:$R$58,S$8,FALSE)","v":28},{"$f":"VLOOKUP($B11,Daten!$A$8:$R$58,T$8,FALSE)","v":2}]
[3,"0",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[4,"0",0,{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[5,"0",0,{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[6,"0",0,{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[7,"0",0,{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[8,"0",0,{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[9,"0",0,{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[10,"0",0,{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,D$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,E$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,F$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,G$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,H$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,I$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,J$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,K$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,L$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,M$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,N$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,O$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,P$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,Q$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,R$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,S$8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Daten!$A$8:$S$63,T$8,FALSE)","v":0}]
[null,"ΣGi",null,{"$f":"SUMPRODUCT($C$10:$C19,D10:D19)","v":6.6199999999999995E-2},{"$f":"SUMPRODUCT($C$10:$C19,E10:E19)","v":7.000000000000001E-4},{"$f":"SUMPRODUCT($C$10:$C19,F10:F19)","v":192},{"$f":"SUMPRODUCT($C$10:$C19,G10:G19)","v":123.91},{"$f":"SUMPRODUCT($C$10:$C19,H10:H19)","v":51},{"$f":"SUMPRODUCT($C$10:$C19,I10:I19)","v":-286.12},{"$f":"SUMPRODUCT($C$10:$C19,J10:J19)","v":-208.42000000000002},{"$f":"SUMPRODUCT($C$10:$C19,K10:K19)","v":45.45},{"$f":"SUMPRODUCT($C$10:$C19,L10:L19)","v":5.0840000000000003E-2},{"$f":"SUMPRODUCT($C$10:$C19,M10:M19)","v":2.7030000000000001E-4},{"$f":"SUMPRODUCT($C$10:$C19,N10:N19)","v":-1.9054000000000001E-7},{"$f":"SUMPRODUCT($C$10:$C19,O10:O19)","v":6.0049999999999999},{"$f":"SUMPRODUCT($C$10:$C19,P10:P19)","v":13.718},{"$f":"SUMPRODUCT($C$10:$C19,Q10:Q19)","v":1436.9299999999998},{"$f":"SUMPRODUCT($C$10:$C19,R10:R19)","v":-3.7880000000000003},{"$f":"SUMPRODUCT($C$10:$C19,S10:S19)","v":58},{"$f":"SUMPRODUCT($C$10:$C19,T10:T19)","v":10}]
[null,"Ergebnisse",null,{"$f":"Tcf(D20,G21,0)","v":500.5590049525365},{"$f":"Pcf(E20,T20,1)","v":48.024996049944065},{"$f":"Vcf(F20,0)","v":209.5},{"$f":"Tbf(G20,0)","v":322.11},{"$f":"Tmf(H20,0)","v":173.5},{"$f":"Hff(I20,0)","v":-217.82999999999998},{"$f":"Gff(J20,0)","v":-154.54000000000002},{"$f":"Cpf(K20,L20,M20,N20,D7,0)","v":75.326420000000013},null,null,null,{"$f":"Hmf(O20,0)","v":5.125},{"$f":"Hvf(P20,0)","v":29.018000000000001},{"$f":"Visf(Q20,R20,S20,D7,0)","v":2.9382574920331771E-4}]
[null,"CHEMCAD 6.5",null,508.2,47,209,329.4,178.45,-217.15,-152.72,74.930000000000007,null,null,null,5.774,29.120999999999999,3.0400000000000002E-4,null,58.08]
[]
["Bedienung:","In B11 - B19 Gruppe wählen, Ergebnisse in Zeile22 lesen"]
[]
["Kommentar:","Die Erweiterung auf mehr als 10 Inkremente erfolgt durch"]
[null,"1. Einfügen neuer Zeile in Zeile 20"]
[null,"2. Zeile 11 in Zeile 13 kopiert"]
[null,"3. D19 nach D20 ziehen"]
[null,"4. D20 nach Spalte T ziehen"]
[]
["Literatur:","Joback-Methode – Wikipedia",null,"de.wikipedia.org/wiki/Joback-Methode"]
[null,"de.wikipedia.org/wiki/Joback-Methode"]
[null,"VDI Wärmeatlas 2010"]
[]
["Software:","CHEMCAD"]

{"sheet":"Info","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Berechnung mit der Joback Methode"]
["Daten von Wikipedia",null,"Joback Tabelle aus https://de.wikipedia.org/wiki/Joback-Methode entnommen"]

{"sheet":"Daten","index":2,"n_rows":116,"n_cols":22,"rows_kept":116,"cut":false,"hidden":false,"merged":[[93,6,93,7],[94,6,94,7],[77,6,78,6],[77,7,78,7],[86,6,86,7],[87,6,87,7],[88,6,88,7],[89,6,89,7],[34,0,34,18],[77,0,78,0],[77,2,78,2],[77,4,78,4],[77,5,78,5],[47,0,47,18],[59,0,59,18],[76,1,76,7],[19,0,19,18],[27,0,27,18],[3,0,5,0],[4,4,5,6],[4,7,4,8],[5,7,5,8],[5,9,5,10],[4,11,4,14],[5,11,5,14],[5,15,5,16],[4,17,4,18],[5,17,5,18],[6,0,6,18]]}
["Joback Tabelle aus https://de.wikipedia.org/wiki/Joback-Methode entnommen",null,null,null,null,null,null,null,"31.06.2015"]
["Beispiel Aceton"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
["Gruppe","N","Z","MG","Tc","Pc","Vc","Tb","Tm","Hf","Gf","Cpa","Cpb","Cpc","Cpd","Hm","Hv","ηa","ηb","Bem","Test"]
[null,null,null,null,"Kritischer Punkt",null,null,"Phasenübergangs-",null,"Bildungs-","Gibbs ","sepz. Wärmekapazität",null,null,null,"Schmelz-","Verdampfungs","Dynamische",null,null,"Gruppe","Index"]
[null,null,null,null,null,null,null,"temperaturen",null,"Std. Enthalpie",null,"Ideales Gas",null,null,null,"enthalpien",null,"Flüssigviskosität",null,null,null,5]
["Nicht-Ring-Jobackgruppe"]
["–CH3",2,4,15,1.41E-2,-1.1999999999999999E-3,65,23.58,-5.0999999999999996,-76.45,-43.96,19.5,-8.0800000000000004E-3,1.5300000000000001E-4,-9.6699999999999999E-8,0.90800000000000003,2.3730000000000002,548.29,-1.7190000000000001,null,"–CH3",{"$f":"VLOOKUP(U8,A8:S17,V6,FALSE)","v":1.41E-2}]
["–CH2–",null,3,16,1.89E-2,0,56,22.88,11.27,-20.64,8.42,-0.90900000000000003,9.5000000000000001E-2,-5.4400000000000001E-5,1.1900000000000001E-8,2.59,2.226,94.16,-0.19900000000000001]
[">CH–",null,2,17,1.6400000000000001E-2,2E-3,41,21.74,12.64,29.89,58.36,-23,0.20399999999999999,-2.6499999999999999E-4,1.1999999999999999E-7,0.749,1.6910000000000001,-322.14999999999998,1.1870000000000001]
[">C<",null,1,18,6.7000000000000002E-3,4.3E-3,27,18.25,46.43,82.23,116.02,-66.2,0.42699999999999999,-6.4099999999999997E-4,3.0100000000000001E-7,-1.46,0.63600000000000001,-573.55999999999995,2.3069999999999999]
["=CH2",null,3,19,1.1299999999999999E-2,-2.8E-3,56,18.18,-4.32,-9.6300000000000008,3.77,23.6,-3.8100000000000002E-2,1.7200000000000001E-4,-1.03E-7,-0.47299999999999998,1.724,495.01,-1.5389999999999999]
["=CH-",null,2,20,1.29E-2,-5.9999999999999995E-4,46,24.96,8.73,37.97,48.53,-8,0.105,-9.6299999999999996E-5,3.5600000000000001E-8,2.6909999999999998,2.2050000000000001,82.28,-0.24199999999999999]
["=C<",null,1,21,1.17E-2,1.1000000000000001E-3,38,24.14,11.14,83.99,92.36,-28.1,0.20799999999999999,-3.0600000000000001E-4,1.4600000000000001E-7,3.0630000000000002,2.1379999999999999,82.28,-0.24299999999999999,"ergänzt"]
["=C=",null,1,22,2.5999999999999999E-3,2.8E-3,36,26.15,17.78,142.13999999999999,136.69999999999999,27.4,-5.57E-2,1.01E-4,-5.02E-8,4.72,2.661,82.28,-0.24399999999999999]
["≡CH",null,2,23,2.7000000000000001E-3,-8.0000000000000004E-4,46,9.1999999999999993,-11.18,79.3,77.709999999999994,24.5,-2.7099999999999999E-2,1.11E-4,-6.7799999999999998E-8,2.3220000000000001,1.155,82.28,-0.245]
["≡C–",null,1,24,2E-3,1.6000000000000001E-3,37,27.38,64.319999999999993,115.51,109.82,7.87,2.01E-2,-8.3299999999999999E-6,1.39E-9,4.1509999999999998,3.302,82.28,-0.246]
["Summen",{"$f":"SUM(B8:B17)","v":2},{"$f":"SUMPRODUCT($B$8:$B$17,C8:C17)","v":8},{"$f":"SUMPRODUCT($B$8:$B$17,D8:D17)","v":30},{"$f":"SUMPRODUCT($B$8:$B$17,E8:E17)","v":2.8199999999999999E-2},{"$f":"SUMPRODUCT($B$8:$B$17,F8:F17)","v":-2.3999999999999998E-3},130,47.16,-10.199999999999999,-152.9,-87.92,39,-1.6160000000000001E-2,3.0600000000000001E-4,-1.934E-7,1.8160000000000001,4.7460000000000004,1096.58,-3.4380000000000002]
["0"]
["Ring Jobackgruppe"]
["–CH2– (Ring)",null,3,14,0.01,2.5000000000000001E-3,48,27.15,7.75,-26.8,-3.68,-6.03,8.5400000000000004E-2,-7.9999999999999996E-6,-1.7999999999999999E-8,0.49,2.3980000000000001,307.52999999999997,-0.79800000000000004,null,"–CH2– (Ring)",{"$f":"VLOOKUP(U21,A21:S25,V6,FALSE)","v":0.01}]
[">CH– (Ring)",null,2,15,1.2200000000000001E-2,4.0000000000000002E-4,38,21.78,19.88,8.67,40.99,-20.5,0.16200000000000001,-1.6000000000000001E-4,6.2400000000000003E-8,3.2429999999999999,1.9419999999999999,-394.29,1.2509999999999999]
[">C< (Ring)",null,1,16,4.1999999999999997E-3,6.1000000000000004E-3,27,21.32,60.15,79.72,87.88,-90.9,0.16200000000000001,-1.6000000000000001E-4,4.6899999999999998E-7,-1.373,0.64400000000000002,-394.3,1.2509999999999999,"ergänzt"]
["=CH- (Ring)",null,2,17,8.2000000000000007E-3,1.1000000000000001E-3,41,26.73,8.1300000000000008,2.09,11.3,-2.14,5.74E-2,-1.64E-6,-1.59E-8,1.101,2.544,259.64999999999998,-0.70199999999999996]
["=C< (Ring)",null,1,18,1.43E-2,8.0000000000000004E-4,32,31.01,37.020000000000003,46.43,54.05,-8.25,5.74E-2,-1.64E-6,6.7799999999999998E-8,2.3940000000000001,3.0590000000000002,-245.74,0.91200000000000003]
["Summen",{"$f":"SUM(B21:B25)","v":0},{"$f":"SUMPRODUCT($B$21:$B$25,C21:C25)","v":0},{"$f":"SUMPRODUCT($B$21:$B$25,D21:D25)","v":0},{"$f":"SUMPRODUCT($B$21:$B$25,E21:E25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Halogen Jobackgruppe"]
["–F",null,1,19,1.11E-2,-5.7000000000000002E-3,27,-0.03,-15.78,-251.92,-247.19,26.5,-9.1300000000000006E-2,1.9100000000000001E-4,-1.03E-7,1.3979999999999999,-0.67,625.45000000000005,-1.8129999999999999,"ergänzt","–F",{"$f":"VLOOKUP(U29,A29:S32,V6,FALSE)","v":1.11E-2}]
["–Cl",null,1,35.5,1.0500000000000001E-2,-4.8999999999999998E-3,58,38.130000000000003,13.55,-71.55,-64.31,33.299999999999997,-9.6299999999999997E-2,1.8699999999999999E-4,-9.9600000000000005E-8,2.5150000000000001,4.532,625.45000000000005,-1.8140000000000001]
["–Br",null,1,80,1.3299999999999999E-2,5.7000000000000002E-3,71,66.86,43.43,-29.48,-38.06,28.6,1.36E-4,-7.4499999999999999E-8,-7.4499999999999999E-8,3.6030000000000002,6.5819999999999999,738.91,-2.0379999999999998]
["–I",null,1,192.2,6.7999999999999996E-3,-3.3999999999999998E-3,97,93.84,41.69,21.06,5.74,32.1,1.26E-4,-6.87E-8,-6.87E-8,2.7240000000000002,9.52,809.55,-2.2240000000000002]
["Summen",{"$f":"SUM(B29:B32)","v":0},{"$f":"SUMPRODUCT($B$29:$B$32,C29:C32)","v":0},{"$f":"SUMPRODUCT($B$29:$B$32,D29:D32)","v":0},{"$f":"SUMPRODUCT($B$29:$B$32,E29:E32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Sauerstoff Jobackgruppe"]
["–OH (Alkohole)",null,2,17,7.4099999999999999E-2,1.12E-2,28,92.88,44.45,-208.04,-189.2,25.7,1.26E-4,-6.87E-8,-9.8799999999999998E-8,2.4060000000000001,16.826000000000001,2173.7199999999998,-5.0570000000000004,null,"–OH (Alkohole)",{"$f":"VLOOKUP(U36,A36:S45,V6,FALSE)","v":7.4099999999999999E-2}]
["–OH (Phenol)",null,2,17,2.4E-2,1.84E-2,-25,76.34,82.83,-221.65,-197.37,-2.81,-1.16E-4,4.9399999999999999E-8,4.9399999999999999E-8,4.49,12.499000000000001,3018.17,-7.3140000000000001]
["–O– (Nichtring)",null,1,16,1.6799999999999999E-2,1.5E-3,18,22.42,22.23,-132.22,-105,25.5,1.11E-4,-5.4800000000000001E-8,-5.4800000000000001E-8,1.1879999999999999,2.41,122.09,-0.38600000000000001]
["–O– (Ring)",null,1,16,9.7999999999999997E-3,4.7999999999999996E-3,13,31.22,23.05,-138.16,-98.22,12.2,-1.26E-2,6.0300000000000002E-5,-3.8600000000000002E-8,5.8789999999999996,4.6820000000000004,440.24,-0.95299999999999996]
[">C=O (Nichtring)",1,2,28,3.7999999999999999E-2,3.0999999999999999E-3,62,76.75,61.2,-133.22,-120.5,6.45,6.7000000000000004E-2,-3.57E-5,2.86E-9,4.1890000000000001,8.9719999999999995,340.35,-0.35]
[">C=O (Ring)",null,2,28,2.8400000000000002E-2,2.8E-3,55,94.97,75.97,-164.5,-126.27,30.4,-8.2900000000000001E-2,2.3599999999999999E-4,-1.31E-7,4.1890000000000001,6.6449999999999996,340.35,-0.35099999999999998,"ergänzt"]
["O=CH– (Aldehyd)",null,3,29,3.7900000000000003E-2,3.0000000000000001E-3,82,72.239999999999995,36.9,-162.03,-143.47999999999999,30.9,-3.3599999999999998E-2,1.6000000000000001E-4,-9.8799999999999998E-8,3.1970000000000001,9.093,740.92,-1.7130000000000001]
["–COOH (Säure)",null,4,57,7.9100000000000004E-2,7.7000000000000002E-3,89,169.09,155.5,-426.72,-387.87,24.1,4.2700000000000002E-2,8.0400000000000003E-5,-6.87E-8,11.051,19.536999999999999,1317.23,-2.5779999999999998]
["–COO– (Ester)",null,3,44,4.8099999999999997E-2,5.0000000000000001E-4,82,81.099999999999994,53.6,-337.92,-301.95,24.5,4.02E-2,4.0200000000000001E-5,-4.5200000000000001E-8,6.9589999999999996,9.6329999999999991,483.88,-0.96599999999999997]
["=O (andere oben)",null,1,16,"0,0143",1.01E-2,36,-10.5,2.08,-247.61,-250.83,6.82,1.9599999999999999E-2,1.27E-5,-1.7800000000000001E-8,3.6240000000000001,5.9089999999999998,675.24,-1.34]
["Summen",{"$f":"SUM(B36:B45)","v":1},{"$f":"SUMPRODUCT($B$36:$B$45,C36:C45)","v":2},{"$f":"SUMPRODUCT($B$36:$B$45,D36:D45)","v":28},{"$f":"SUMPRODUCT($B$36:$B$45,E36:E45)","v":3.7999999999999999E-2},3.0999999999999999E-3,62,76.75,61.2,-133.22,-120.5,6.45,6.7000000000000004E-2,-3.57E-5,2.86E-9,4.1890000000000001,8.9719999999999995,340.35,-0.35]
[]
["Stickstoff Jobackgruppe"]
["–NH2",null,3,16,2.4299999999999999E-2,1.09E-2,38,73.23,66.89,-22.02,14.07,26.9,-4.1200000000000001E-2,1.64E-4,-9.76E-8,3.5150000000000001,10.788,307.52999999999997,-0.79800000000000004,"ergänzt","–NH2",{"$f":"VLOOKUP(U49,A49:S57,V6,FALSE)","v":2.4299999999999999E-2}]
[">NH (Nichtring)",null,2,15,2.9499999999999998E-2,7.7000000000000002E-3,35,50.17,52.66,53.47,89.39,-1.21,7.6200000000000004E-2,-4.8600000000000002E-5,1.05E-8,5.0990000000000002,6.4359999999999999,308.52999999999997,-0.79900000000000004]
[">NH (Ring)",null,2,15,1.2999999999999999E-2,1.14E-2,29,52.82,101.51,31.65,75.61,11.8,-2.3E-2,1.07E-4,-6.2800000000000006E-8,7.49,6.93,309.52999999999997,-0.8]
[">N–(Nichtring)",null,1,14,1.6899999999999998E-2,7.4000000000000003E-3,9,11.74,48.84,123.34,163.16,-31.1,0.22700000000000001,-3.2000000000000003E-4,1.4600000000000001E-7,4.7030000000000003,1.8959999999999999,310.52999999999997,-0.80100000000000005]
["–N= (Nichtrring)",null,1,14,2.5499999999999998E-2,-9.9000000000000008E-3,9,74.599999999999994,48.84,23.61,163.16,-31.1,2.2700000000000001E-2,-3.1999999999999999E-5,1.4600000000000001E-7,4.7030000000000003,3.335,311.52999999999997,-0.80200000000000005]
["–N= (Ring)",null,1,14,8.5000000000000006E-3,7.6E-3,34,57.55,68.400000000000006,93.7,119.66,5.69,-4.1200000000000004E-3,1.2799999999999999E-4,-8.8800000000000001E-8,3.649,6.5279999999999996,312.52999999999997,-0.80300000000000005]
["=NH",null,2,15,8.5000000000000006E-3,7.6E-3,34,83.08,68.91,93.7,119.66,5.69,-4.1200000000000004E-3,1.2799999999999999E-4,"-8,88-8",3.649,12.169,313.52999999999997,-0.80400000000000005]
["–CN",null,2,26,4.9599999999999998E-2,-1.01E-2,91,125.66,59.89,88.43,89.22,36.5,-7.3300000000000004E-2,1.84E-4,-1.03E-7,2.4140000000000001,12.851000000000001,314.52999999999997,-0.80500000000000005]
["–NO2",null,3,46,4.3700000000000003E-2,6.4000000000000003E-3,91,152.54,127.24,-66.569999999999993,-16.829999999999998,25.9,-3.7399999999999998E-3,1.2899999999999999E-4,-8.8800000000000001E-8,9.6790000000000003,16.738,315.52999999999997,-0.80600000000000005]
["Summen",{"$f":"SUM(B49:B57)","v":0},{"$f":"SUMPRODUCT($B$49:$B$57,C49:C57)","v":0},{"$f":"SUMPRODUCT($B$49:$B$57,D49:D57)","v":0},{"$f":"SUMPRODUCT($B$49:$B$57,E49:E57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Schwefel Jobackgruppe"]
["–SH",null,2,33,3.0999999999999999E-3,8.3999999999999995E-3,63,63.56,20.09,-17.329999999999998,-22.99,35.299999999999997,-7.5800000000000006E-2,1.85E-4,-1.03E-7,2.36,6.8840000000000003,307.52999999999997,-0.79800000000000004,"ergänzt","–SH",{"$f":"VLOOKUP(U61,A61:S63,V6,FALSE)","v":3.0999999999999999E-3}]
["–S– (Nichtring)",null,1,32,1.1900000000000001E-2,4.8999999999999998E-3,54,68.78,34.4,41.87,33.119999999999997,19.600000000000001,-5.6100000000000004E-3,4.0200000000000001E-5,-2.7599999999999999E-8,4.13,6.8170000000000002,308.52999999999997,-0.79900000000000004]
["–S– (Ring)",null,1,32,1.9E-3,5.1000000000000004E-3,38,52.1,79.930000000000007,39.1,27.76,16.7,4.81E-3,2.7699999999999999E-5,-2.11E-8,1.5569999999999999,5.984,309.52999999999997,-0.8]
["Summen",{"$f":"SUM(B61:B63)","v":0},{"$f":"SUMPRODUCT($B$61:$B$63,C61:C63)","v":0},{"$f":"SUMPRODUCT($B$61:$B$63,D61:D63)","v":0},{"$f":"SUMPRODUCT($B$61:$B$63,E61:E63)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Gesamt-Summen",{"$f":"B18+B26+B33+B46+B64","v":3},{"$f":"C18+C26+C33+C69+C46+C58+C64","v":10},58,6.6199999999999995E-2,7.000000000000001E-4,192,123.91,51,-286.12,-208.42000000000002,45.45,5.0840000000000003E-2,2.7030000000000001E-4,-1.9054000000000001E-7,6.0049999999999999,13.718,1436.9299999999998,-3.7880000000000003]
[null,"N","NA","MG","Tc","Pc","Vc","Tb","Tm","Hf","Gf","a","b","c","d","Hm","Hv","a","b"]
["Ergebnisse (vba)",{"$f":"B65","v":3},10,{"$f":"D65","v":58},{"$f":"Tcf(E65,H67,0)","v":500.5590049525365},{"$f":"Pcf(F65,C65,0)","v":4802499.6049944069},{"$f":"Vcf(G65,0)","v":209.5},{"$f":"Tbf(H65,0)","v":322.11},{"$f":"Tmf(I65,0)","v":173.5},{"$f":"Hff(J65,0)","v":-217.82999999999998},{"$f":"Gff(K65,0)","v":-154.54000000000002},{"$f":"Cpf(L65,M65,N65,O65,B68,0)","v":75.326420000000013},null,null,null,{"$f":"Hmf(P65,0)","v":5.125},{"$f":"Hvf(Q65,0)","v":29.018000000000001},{"$f":"Visf(R65,S65,D67,B68,0)","v":2.9382574920331771E-4}]
["Temperatur K",300]
[]
["Berechnung Aceton","aus ","https://de.wikipedia.org/wiki/Joback-Methode",null,null,null,null,"Strukturformel:"]
[]
[]
[]
[]
["Aceton (Propanon) ist das einfachste Keton und wird nach der Joback-Methode in drei Gruppen aufgeteilt: Zwei Methylgruppen (–CH3) und eine Ketogruppe (C=O). Da die Methylgruppe zweimal vorkommt, wird ihr Beitrag doppelt addiert."]
[]
[null,"Daten aus https://de.wikipedia.org/wiki/Joback-Method",null,null,null,null,null,null,null,null,null,null,"Datenbanken"]
["Eigenschaft","Anzahl","Beitrag","Anzahl","Beitrag","ΣGi","Berechneter Wert","Einheit","Excel Berechnung"]
[null,"der Gruppen",null,"der Gruppen",null,null,null,null,"SGi","Wert","Einheit","VBA Funktionen","https://de.wikipedia.org/wiki/Aceton","CHEMCAD (DIPPR)"," "]
["Tc",2,1.41E-2,1,3.7999999999999999E-2,6.6199999999999995E-2,500.55900000000003,"K",{"$f":"B80*C80+D80*E80","v":6.6199999999999995E-2},{"$f":"J83/(0.584+0.965*I80-I80^2)","v":500.5590049525365},"K",{"$f":"Tcf(I80,L83,0)","v":500.5590049525365},508.15,508.15]
["Pc",2,-1.1999999999999999E-3,1,3.0999999999999999E-3,6.9999999999999999E-4,48.024999999999999,"bar",{"$f":"B81*C81+D81*E81","v":7.000000000000001E-4},{"$f":"1/(0.113+0.0032*B98-I81)^2","v":48.024996049944072},{"$f":"H81","v":"bar"},{"$f":"Pcf(I81,B98,0)","v":4802499.6049944069},47582,47.015000000000001]
["Vc",2,65,1,62,192,209.5,"cm3/mol",192,{"$f":"17.5+I82","v":209.5},"cm3/mol",{"$f":"Vcf(I82,0)","v":209.5},{"$f":"1/4.63*1000","v":215.98272138228941},209]
["Tb",2,23.58,1,76.75,123.91,322.11,"K",123.91,{"$f":"I83+198.2","v":322.11},"K",{"$f":"Tbf(I83,0)","v":322.11},{"$f":"56+273.15","v":329.15},329.4]
["Tm",2,-5.0999999999999996,1,61.2,51,173.5,"K",51,{"$f":"122.5+I84","v":173.5},"K",{"$f":"Tmf(I84,0)","v":173.5},{"$f":"-95+273.15","v":178.14999999999998},178.45]
["Hf",2,-76.45,1,-133.22,-286.12,-217.83,"kJ/mol",{"$f":"B85*C85+D85*E85","v":-286.12},{"$f":"68.29+I85","v":-217.82999999999998},"kJ/mol",{"$f":"Hff(I85,0)","v":-217.82999999999998},-218.5,{"$f":"-3738.81*58/1000","v":-216.85098000000002}]
["Gf",2,-43.96,1,-120.5,-208.42,-154.54,"kJ/mol",-208.42000000000002,{"$f":"53.88+I86","v":-154.54000000000002},"kJ/mol",{"$f":"Gff(I86,0)","v":-154.54000000000002},null,{"$f":"-2629.48*58/1000","v":-152.50984}]
["Cpa",2,19.5,1,6.45,45.5,null,null,45.45]
["Cpb",2,-8.0800000000000004E-3,1,6.7000000000000004E-2,5.0799999999999998E-2,null,null,5.0840000000000003E-2]
["Cpc",2,1.5300000000000001E-4,1,-3.57E-5,2.7E-4,null,null,2.7030000000000001E-4]
["Cpd",2,-9.6699999999999999E-8,1,2.86E-9,-1.91E-7,null,null,-1.9054000000000001E-7]
["Cp","T",300,"K",null,null,75.326400000000007,"J/(mol·K)",null,{"$f":"I87-37.93+(I88+0.21)*C91+(I89-0.000391)*C91^2+(I90+0.000000206)*C91^3","v":75.326420000000013},{"$f":"H91","v":"J/(mol·K)"},{"$f":"Cpf(I87,I88,I89,I90,C91,0)","v":75.326420000000013},125.45,{"$f":"2.1795*58","v":126.411}]
["Hm",2,0.90800000000000003,1,4.1890000000000001,6.0049999999999999,5.125,"kJ/mol",6.0049999999999999,{"$f":"-0.88+I92","v":5.125},{"$f":"H92","v":"kJ/mol"},{"$f":"Hmf(I92,0)","v":5.125},5.72,{"$f":"99.415*58/1000","v":5.7660700000000009}]
["Hv",2,2.3730000000000002,1,8.9719999999999995,13.718,209.8854,"kJ/mol",13.718,{"$f":"15.3+I93","v":29.018000000000001},{"$f":"H93","v":"kJ/mol"},{"$f":"Hvf(I93,0)","v":29.018000000000001},29.1,{"$f":"538*58/1000","v":31.204000000000001}]
["ηa",2,548.29,1,340.35,1436.93,null,null,1436.9299999999998]
["ηb",2,-1.7190000000000001,1,-0.35,-3.7879999999999998,null,null,-3.7880000000000003]
["η","T",300,"K",null,null,2.942E-4,"Pa s",null,{"$f":"B97*EXP((I94-597.82)/C96+I95-11.202)","v":2.9382574920331771E-4},{"$f":"H96","v":"Pa s"},{"$f":"Visf(I94,I95,B97,C91,0)","v":2.9382574920331771E-4},null,3.0150000000000001E-4]
["MG",{"$f":"2*15+12+16","v":58},"g/mol"]
["NA",10]
[]
[]
["Kommentar:"]
["Die Daten wurden der Seite ",null,"https://de.wikipedia.org/wiki/Joback-Methode",null,null,null,"durch Kopieren entnommen."]
["Die Zahlen müssen danach in für Excel lesbare Zahlen umgewandelt werden, indem das lange - Zeichen durch ein kurzes - Zeichen ersetzt wird."]
["Dazu wird die Funktion \"Suchen und Auswählen\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["verwendet."]

{"sheet":"Formeln","index":3,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Berechnungsmethoden aus https://de.wikipedia.org/wiki/Joback-Methode"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Anm. in ","https://en.wikipedia.org/wiki/Joback_method",null,null,null,"werden Maßeinheiten angegeben"]

{"sheet":"VDI-WA","index":4,"n_rows":84,"n_cols":16,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
["Stoffdaten aus VDI Wärmeatlas"]
[]
["Daten von N-Alkanen"]
[null,null,null,null,null,"AN","MG ","Tb","Tc","pc","Vc","Tm","Tm CHEMCAD "]
[null,null,null,"Summenformel","Strukturformel","Atomzahl","Molgewicht","Siedepunkt","krit. Temperatur","krit. Druck","krit. Volumen","Schmelztempeartur"]
[null,null,null,null,null,null,"g/mol","K","K ","bar,a","cm³/mol","K"]
[0,"Methan","(CH2)n","CH4","CH4",5,16.042999999999999,111.6,190.4,46,118,90.7,90.7]
[1,"Ethan",null,"C2H6","CH3-CH3",8,30.07,184.6,305.39999999999998,48.8,148.30000000000001,89.9,{"$f":"-182.8+273.15","v":90.349999999999966}]
[2,"Propan",1,"C3H8","CH3-CH2-CH3",11,44.094000000000001,231.1,369.8,42.2,203,85.5,85.46]
[3,"N-Butan",2,"C4H10","CH3-(CH2)2-CH3",14,58.124000000000002,272.7,425.2,38,255,134.80000000000001,134.86000000000001]
[4,"N-Pentan",3,"C5H12","CH3-(CH2)3-CH3",17,72.150999999999996,309.2,469.7,33.700000000000003,304,143.4,143.41999999999999]
[5,"N-Hexan",4,"C6H14","CH3-(CH2)4-CH3",20,86.177999999999997,341.9,507.5,30.1,370,177.8,177.84]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Die homologe CH2-Reihe beginnt erst mit Propan, da hier die Zahl der CH2 Gruppen = 1 ist."]
[null,null,null,null,null,null,null,null,"Diese homologe Reihe besteht hier aus Propan bis Hexan. Alle hier dargestellten Funktionen lassen sich mit hohem Bestimmtheitsmass > 0,99 linear darstellen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Vc von Alkanen ab Propan: CH2=1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113.6]
["Alkohole","kritisches Volumen",null,null,null,null,null,null,null,null,null,null,null,null,null,17.5]
[null,null,null,null,"(CH2)n","Vc ",null,null,null,null,null,null,null,null,null,{"$f":"P67-P68","v":96.1}]
[null,null,null,null,null,"cm³/mol"]
[1,"Ethanol","C2H5OH","CH3(CH2)1OH",{"$f":"A71","v":1},167.1]
[2,"n-Propanol",null,"CH3(CH2)2OH",{"$f":"A72","v":2},219]
[3,"n-Butanol",null,"CH3(CH2)3OH",3,275]
[4,"n-Pentanol",null,"CH3(CH2)4OH",4,326]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Vc von aliphatischen Alkoholen"]