The role of German universities in a system of joint knowledge generation and innovation
|14. Appendix
Texte intégral
1Appendix 3: Exemplary Illustration of calculating the different Distances between the German Universities and their individual Cooperation Partners using the Haversine Formula.
2Sub abstand ( )
3Application.ScreenUpdating = False
4Dim Ende As Long Ende = 280000
5Dim step As Long
6step = 0
7For gesamt = 10 To 92
8Dim Uniname (92) As String
9Uniname (l) = "Forschungszentrum"
10Uniname (2) = "Unternehmen"
11Uniname (lO) = "kit"
12Uniname (ll) = "rwth aachen"
13Uniname (12) = "lmu"
14Uniname (13) = "münchen th"
15Uniname (14) = "uni heidelberg"
16Uniname (15) = "uni göttingen"
17Uniname (16) = "uni freiburg"
18Uniname (17) = "uni konstanz"
19Uniname (19) = "uni augsburg"
20Uniname (20) = "uni bamberg"
21Uniname (21) = "uni bayreuth"
22Uniname (22) = "uni bielefeld"
23Uniname (23) = "uni bochum"
24Uniname (24) = "uni bonn"
25Uniname (25) = "braunschweig tu"
26Uniname (26) = "uni bremen"
27Uniname (28) = "darmstadt tu"
28Uniname (29) = "dortmund tu"
29Uniname (30) = "uni duisburg essen"
30Uniname (31) = "uni düsseldorf"
31Uniname (32) = "uni erlangen nürnberg"
32Uniname (33) = "uni frankfurt"
33Uniname (34) = "uni gießen"
34Uniname (35) = "fernuni hagen"
35Uniname (36) = "uni hamburg"
36Uniname (37) = "uni hannover"
37Uniname (38) = "kaiserslautern tu"
38Uniname (39) = "uni kassel"
39Uniname (40) = "uni kiel"
40Uniname (41) = "uni koblenz-landau"
41Uniname (43) = "uni köln"
42Uniname (44) = "uni mainz"
43Uniname (45) = "uni mannheim"
44Uniname (4 6) = "uni marburg"
45Uniname (47) = "uni münster"
46Uniname (48) = "uni Oldenburg"
47Uniname (4 9) = "uni Osnabrück"
48Uniname (50) = "uni paderborn"
49Uniname (51) = "uni passau"
50Uniname (52) = "uni regensburg"
51Uniname (53) = "uni des saarlandes"
52Uniname (54) = "uni siegen"
53Uniname (55) = "uni Stuttgart"
54Uniname (56) = "uni trier"
55Uniname (57) = "uni tübingen"
56Uniname (58) = "uni Ulm"
57Uniname (59) = "uni Wuppertal"
58Uniname (60) = "uni würzburg"
59Uniname (61) = "TU Clausthal"
60Uniname (62) = "Uni Flensburg"
61Uniname (63) = "Bundeswehr Hamburg"
62Uniname (64) = "Uni Hamburg Harburg"
63Uniname (65) = "Uni Hildesheim"
64Uniname (66) = "Uni Eichstädt Ingolstadt"
65Uniname (67) = "Uni Lübeck"
66Uniname (68) = "Uni Lüneburg"
67Uniname (69) = "Uni Mannheim"
68Uniname (70) = "Uni Bundeswehr München"
69Uniname (71) = "Uni Passau"
70Uniname (72) = "Uni Hohenheim"
71Uniname (75) = "Freie Uni Berlin"
72Uniname (7 6) = "Humboldt Uni Berlin "
73Uniname (77) = "TU Berlin"
74Uniname (78) = "TU Chemnitz"
75Uniname (7 9) = "TU Cottbus"
76Uniname (80) = "TU Dresden"
77Uniname (81) = "Uni Erfurt"
78Uniname (82) = "Uni Frankfurt Oder"
79Uniname (83) = "TU Bergakademie Freiberg"
80Uniname (84) = "uni Greifswald"
81Uniname (85) = "uni halle-wittenberg"
82Uniname (8 6) = "tu ilmenau"
83Uniname (87) = "friedrich Schiller uni Jena"
84Uniname (88) = "uni leipzig"
85Uniname (89) = "uni magdeburg"
86Uniname (90) = "uni potsdam"
87Uniname (91) = "uni rostock"
88Uniname (92) = "bauhaus uni weimar"
89If Uniname (gesamt) < > " " Then
90Dim abstand As Double
91Dim abstandh As Double
92Dim platz As Long
93Dim uni As Integer
94Dim entf (40) As Long
95Dim entfg (40) As Double
96Dim dabei As Boolean
97Dim ausland As Long
98Dim arg As Double
99Dim Eigengewicht As Double
100Eigengewicht = C
101For i=l To 40
102entf (i) = 0
103Next
104For ii=l To 40
105Entfg (ii) = 0
106Next
107ausländ = 0
108uni = gesamt
109Dim gewichtungscount As Long
110For Z = 2 To Ende
111dabei = False
112gewichtungscount = 0
113For X=l To 500
114If Cells (Z +X-1, 9) = uni The
115dabei = True
116platz = X
117Eigengewicht = Eigengewicht + Cells (Z + X - 1, 8).Value
118End If
119If Cells (Z +X-1, 9) > 6 Then
120gewichtungscount = gewichtungscount + 1 End If
121If Cells (Z + X -1, 1) < > Cells (Z + X, 1) Then
122Exit For
123End If
124Next
125If dabei = True Then
126For Count =1 To X
127If Count < > platz And Cells (Z + Count - 1, 13) < > " " Then 'abstand = (((Cells (Z + count - 1, 13) – Cells (Z + platz - 1, 13)) * 71.46) ^ 2+ ((Cells (Z + count - 1, 14) –Cells (Z + platz - 1, 14)) * 111) ^ 2) ^ (0.5)
128arg = Sqr ((Sin ((Cells (Z + Count - 1, 14) / 180 * 3.1415926 – Cells (Z + platz - 1, 14) / 180 * 3.1415926) / 2)) ^ 2+ Cos (Cells(Z + platz - 1, 14) / 180 * 3.1415926) * Cos (Cells (Z + Count - 1, 14) / 180 * 3.1415926) * Sin ((Cells (Z + Count - 1, 13) / 180 * 3.1415926 – Cells (Z + platz - 1, 13) / 180 * 3.1415926) /2)) ^ 2)
129abstandh = 2* 6371 * Atn (arg / Sqr (-arg * arg + 1)) 'Cells( Z + count - 1, 15) = abstand
130If abstandh > 0 And abstandh <= 25Then
131Entf (l) = entf (l) + 1
132entfg (l) = entfg (l) + Cells(Z + Count - 1, 8).Value /
133gewichtungscount
134End If
135If abstandh > 25 And abstandh <= 50 Then
136Entf (2) = entf (2) + 1
137Entfg (2) = entfg (2) + Cells (Z + Count - 1, 8).Value /
138gewichtungscount
139End If
140If abstandh > 50 And abstandh <= 75 Then
141entf (3) = entf (3) + 1
142Entfg (3) = entfg (3) + Cells (Z + Count - 1, 8).Value /
143gewichtungscount
144End If
145If abstandh > 75 And abstandh <= 100 Then
146entf (4) = entf (4) + 1
147entfg (4) = entfg (4) + Cells (Z + Count - 1, 8).Value /
148gewichtungscount
149End If
150End If
151'If count < > platz And (Cells (Z + count - 1, 3) < > "de"
152And Cells (Z +X-1, 3) < > "De") Then
153'ausländ = ausländ + 1
154'End If
155'If Cells (Z + count - 1, 14) < > " " Then
156'Cells (Z + count -1, 15) = abstand
157'Cells (Z + count -1, 16) = abstandh
158'Cells (Z + count - 1, 17) = arg
159'End If
160Next
161End If
162Z = Z+X-1
163Next
164For j = l To 40
165Cells (j +1, 17+4* step) = entf (j)
166Next
167For jj = l To 40
168Cells (jj +1, 18+4* step) = entfg(jj)
169Next
170Dim Namee (2) As String
171Namee (l) = "Ergebnis"
172Namee(2) = Uniname (uni)
173Cells (l, 16 + 4* step) = Join (Namee)
174'Cells(7, 17+4* step) = ausländ
175Cells (2, 16 + 4* step) = "25km"
176Cells (3, 16 + 4* step) = "25-50km"
177Cells (4, 16 + 4* step) = "50-75km"
178Cells (5, 16 + 4* step) = "75-100km"
179Cells (8, 16 + 4* step) = "Eigengewicht"
180Cells (8, 17 + 4* step) = Eigengewicht
181step = step + 1
182End If
183Next
184End Sub
Appendix 4: Value of normalized Degree Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).

Appendix 5: Value of Betweenness-Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration).

Appendix 6: Value of normalized Degree Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).

Appendix 7: Value of Betweenness Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration).

Appendix 8: Overview of Publication Activity of all German Universities in absolute Numbers, 2000 (own illustration).

Appendix 9: Overview of Publication Activity of all German Universities in absolute Numbers, 2009 (own illustration).

Appendix 12: Overview of Fourfold Tables regarding the Collaboration Activity of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).

Appendix 13: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Authors of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration).

Appendix 14: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Applicants of the three Groups of German Universities, absolute Numbers, 1999/2000 and 2007/2008 (own illustration).

- 1 It is not possible to properly visualize the whole network of the KIT as it is too large.
Appendix 15: Exemplary Illustration of all Network Interactions between the KIT and the German Universities that have been Subject of Study (in Terms of Publications, 2009).1

- 2 It is not possible to properly visualize the whole network of the University of Heidelberg as it i (...)
Appendix 16: Exemplary Illustration of all Network Interactions between the University of Heidelberg and the German Universities that have been Subject of Study (in Terms of Publications, 2009).2

Notes
1 It is not possible to properly visualize the whole network of the KIT as it is too large.
2 It is not possible to properly visualize the whole network of the University of Heidelberg as it is too large.
Table des illustrations
![]() | |
---|---|
Titre | Appendix 1: Overview of all German universities that are subject of study (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-1.jpg |
Fichier | image/jpeg, 261k |
![]() | |
Titre | Appendix 2: PATSTATT IWW Data-Base |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-2.jpg |
Fichier | image/jpeg, 243k |
![]() | |
Titre | Appendix 4: Value of normalized Degree Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-3.jpg |
Fichier | image/jpeg, 363k |
![]() | |
Titre | Appendix 5: Value of Betweenness-Centrality regarding the Publication Activity of all German Universities in 2000 and compared by Ranking to 2009 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-4.jpg |
Fichier | image/jpeg, 368k |
![]() | |
Titre | Appendix 6: Value of normalized Degree Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-5.jpg |
Fichier | image/jpeg, 305k |
![]() | |
Titre | Appendix 7: Value of Betweenness Centrality regarding the Patenting Activity of all German Universities (Ranking) 2007/2008 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-6.jpg |
Fichier | image/jpeg, 299k |
![]() | |
Titre | Appendix 8: Overview of Publication Activity of all German Universities in absolute Numbers, 2000 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-7.jpg |
Fichier | image/jpeg, 221k |
![]() | |
Titre | Appendix 9: Overview of Publication Activity of all German Universities in absolute Numbers, 2009 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-8.jpg |
Fichier | image/jpeg, 371k |
![]() | |
Titre | Appendix 10: Table of Regression Results concerning scientific Publications. |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-9.jpg |
Fichier | image/jpeg, 129k |
![]() | |
Titre | Appendix 11: Table of Regression Results concerning Patent Applications. |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-10.jpg |
Fichier | image/jpeg, 128k |
![]() | |
Titre | Appendix 12: Overview of Fourfold Tables regarding the Collaboration Activity of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-11.jpg |
Fichier | image/jpeg, 292k |
![]() | |
Titre | Appendix 13: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Authors of the three Groups of German Universities, weighted Numbers, 2000 and 2009 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-12.jpg |
Fichier | image/jpeg, 270k |
![]() | |
Titre | Appendix 14: Overview of Fourfold Tables regarding the institutional Distribution of the Co-Applicants of the three Groups of German Universities, absolute Numbers, 1999/2000 and 2007/2008 (own illustration). |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-13.jpg |
Fichier | image/jpeg, 314k |
![]() | |
Titre | Appendix 15: Exemplary Illustration of all Network Interactions between the KIT and the German Universities that have been Subject of Study (in Terms of Publications, 2009).1 |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-14.jpg |
Fichier | image/jpeg, 428k |
![]() | |
Titre | Appendix 16: Exemplary Illustration of all Network Interactions between the University of Heidelberg and the German Universities that have been Subject of Study (in Terms of Publications, 2009).2 |
URL | http://books.openedition.org/ksp/docannexe/image/244/img-15.jpg |
Fichier | image/jpeg, 471k |
© KIT Scientific Publishing, 2013
Creative Commons - Attribution - Partage dans les Mêmes Conditions 4.0 International - CC BY-SA 4.0