{ From user jtue, Model Who_mortality at 3. helta 2009 16:42 }
Softwareversion 4.1.0
{ System Variables with non-default values: }
Description Time: Dynamic simulation periods are specified in Time's d~~
efinition. This is usually a list of numbers or labels, typically in ~~
some unit of time (days, weeks, months, etc.). Use the Dynamic() f~~
unction in your variables to perform dynamic simulation.
Typechecking := 1
Checking := 1
Saveoptions := 2
Savevalues := 0
Allwarnings := 0
Attribute Ident
Askattribute Recursive,Function,Yes
Askattribute Ident,Function,Yes
Askattribute Ident,Module,Yes
Askattribute Value,Variable,Yes
Askattribute Check,Variable,Yes
Askattribute Balloonhelp,Variable,Yes
Askattribute Domain,Variable,Yes
Askattribute Ident,Variable,Yes
Model Who_mortality
Author: mtad
Date: 17. Janta 2003 15:22
Saveauthor: jtue
Savedate: 3. helta 2009 16:42
Defaultsize: 48,24
Diagstate: 1,557,82,641,458,17
Windstate: 1,646,6
Fontstyle: Arial, 13
Fileinfo: 0,Model Who_mortality,2,2,0,0,C:\temp\WHO mortality.ANA
Index Sex
Title: Sex
Definition: ['Male','Female']
Nodelocation: 168,256,1
Nodesize: 48,12
Valuestate: 1,104,114,416,303,0,MIDM
Ident: Op_en2780
Index Var1
Title: Var
Definition: ['Variable','ICD-10 codes','Cause groupings','Sex','All a~~
ges','< 1','1-4','5-14','15-24','25-34','35-44','45-54','55-64','65-7~~
4','75+','Age not specified']
Nodelocation: 168,88,1
Nodesize: 48,12
Valuestate: 1,232,242,416,303,0,MIDM
{!40000|Att_previndexvalue: ['Variable','ICD-10 codes','Cause grouping~~
s','Sex','All ages','< 1','1-4','5-14','15-24','25-34','35-44','45-54~~
','55-64','65-74','75+','Age not specified']}
Index Item2
Title: Item
Definition: sequence(1,392)
Nodelocation: 168,64,1
Nodesize: 48,12
Valuestate: 1,72,82,416,303,0,MIDM
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40~~
,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63~~
,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86~~
,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107~~
,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,~~
125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142~~
,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,~~
160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,~~
177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194~~
,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,~~
212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229~~
,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,~~
247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264~~
,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281~~
,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,~~
299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316~~
,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,~~
334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351~~
,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368~~
,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,~~
386,387,388,389,390,391,392]}
Variable Who_data
Title: WHO data
Description: WHO data kopioitu WHO_Cause of Death.xls tiedostosta, jok~~
a on samassa hakemistossa tämän mallin kanssa.~
~
Kuolleisuusdata on kopioitu WHO_Cause of Death.xls tiedostoon WHO:n s~~
ivuilta 23.1.2003 osoitteesta:~
http://www3.who.int/whosis/ (Sivulta linkki: Cause of death statistic~~
s -> Table 1 -> Finland - 1996)
Definition: Table(Var1,Item2)(~
'Number','Number','Deaths/100000 py','Deaths/100000 py','Number','Num~~
ber','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/~~
100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py','D~~
eaths/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 ~~
py','Number','Number','Deaths/100000 py','Deaths/100000 py','Number',~~
'Number','Deaths/100000 py','Deaths/100000 py','Number','Number','Dea~~
ths/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py~~
','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/100~~
000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Numb~~
er','Number','Deaths/100000 py','Deaths/100000 py','Number','Number',~~
'Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/10000~~
0 py','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths~~
/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','~~
Number','Number','Deaths/100000 py','Deaths/100000 py','Number','Numb~~
er','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/1~~
00000 py','Deaths/100000 py','Number','Number','Deaths/100000 py','De~~
aths/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 p~~
y','Number','Number','Deaths/100000 py','Deaths/100000 py','Number','~~
Number','Deaths/100000 py','Deaths/100000 py','Number','Number','Deat~~
hs/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py'~~
,'Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/1000~~
00 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Numbe~~
r','Number','Deaths/100000 py','Deaths/100000 py','Number','Number','~~
Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/100000~~
py','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/~~
100000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','N~~
umber','Number','Deaths/100000 py','Deaths/100000 py','Number','Numbe~~
r','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/10~~
0000 py','Deaths/100000 py','Number','Number','Deaths/100000 py','Dea~~
ths/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 py~~
','Number','Number','Deaths/100000 py','Deaths/100000 py','Number','N~~
umber','Deaths/100000 py','Deaths/100000 py','Number','Number','Death~~
s/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py',~~
'Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/10000~~
0 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Number~~
','Number','Deaths/100000 py','Deaths/100000 py','Number','Number','D~~
eaths/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 ~~
py','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/1~~
00000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Nu~~
mber','Number','Deaths/100000 py','Deaths/100000 py','Number','Number~~
','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/100~~
000 py','Deaths/100000 py','Number','Number','Deaths/100000 py','Deat~~
hs/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 py'~~
,'Number','Number','Deaths/100000 py','Deaths/100000 py','Number','Nu~~
mber','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths~~
/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py','~~
Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/100000~~
py','Number','Number','Deaths/100000 py','Deaths/100000 py','Number'~~
,'Number','Deaths/100000 py','Deaths/100000 py','Number','Number','De~~
aths/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 p~~
y','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/10~~
0000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Num~~
ber','Number','Deaths/100000 py','Deaths/100000 py','Number','Number'~~
,'Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/1000~~
00 py','Deaths/100000 py','Number','Number','Deaths/100000 py','Death~~
s/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 py',~~
'Number','Number','Deaths/100000 py','Deaths/100000 py','Number','Num~~
ber','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/~~
100000 py','Deaths/100000 py','Number','Deaths/100000 py','Number','D~~
eaths/100000 py','Number','Deaths/100000 py','Number','Deaths/100000 ~~
py','Number','Deaths/100000 py','Number','Deaths/100000 py','Number',~~
'Number','Deaths/100000 py','Deaths/100000 py','Number','Number','Dea~~
ths/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py~~
','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/100~~
000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Numb~~
er','Number','Deaths/100000 py','Deaths/100000 py','Number','Number',~~
'Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/10000~~
0 py','Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths~~
/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 py','~~
Number','Number','Deaths/100000 py','Deaths/100000 py','Number','Numb~~
er','Deaths/100000 py','Deaths/100000 py','Number','Number','Deaths/1~~
00000 py','Deaths/100000 py','Number','Number','Deaths/100000 py','De~~
aths/100000 py','Number','Number','Deaths/100000 py','Deaths/100000 p~~
y','Number','Number','Deaths/100000 py','Deaths/100000 py','Number','~~
Number','Deaths/100000 py','Deaths/100000 py','Number','Number','Deat~~
hs/100000 py','Deaths/100000 py','Number','Number','Deaths/100000 py'~~
,'Deaths/100000 py','Number','Number','Deaths/100000 py','Deaths/1000~~
00 py','Number','Number','Deaths/100000 py','Deaths/100000 py','Numbe~~
r','Number','Deaths/100000 py','Deaths/100000 py','Number','Number','~~
Deaths/100000 py','Deaths/100000 py',~
'AAA',0,0,0,'A00-B99',0,0,0,'A01',0,0,0,'A00, A02-A09',0,0,0,'A15-A16~~
',0,0,0,'A17-A19',0,0,0,'A37',0,0,0,'A39',0,0,0,'A35',0,0,0,'A40-A41'~~
,0,0,0,'A20-A32, A36, A38, A42-49',0,0,0,'B05',0,0,0,'B20-B24',0,0,0,~~
'A70-A74, A80-B34, B05, B20-B24',0,0,0,'B50-B54',0,0,0,'A75-A79, B55-~~
B57, B60, B64',0,0,0,'A50-A64',0,0,0,'A65-A69, B35-B49, B58, B59, B65~~
-B99',0,0,0,'C00-C97',0,0,0,'C00-C14',0,0,0,'C15',0,0,0,'C16',0,0,0,'~~
C18',0,0,0,'C19-C21',0,0,0,'C22',0,0,0,'C32',0,0,0,'C33-C34',0,0,0,'C~~
50',0,0,0,'C53',0,'C54-C55',0,'C61',0,'C67',0,0,0,'C17, C23-C31, C37-~~
C49, C51, C52, C56-C60, C62-C66, C68-C80, C97',0,0,0,'C91-C95',0,0,0,~~
'C81-C90, C96',0,0,0,'D00-D48',0,0,0,'E10-E14',0,0,0,'E00-E07, E15-E3~~
4, E65-E68, E70-E88',0,0,0,'E41-E46',0,0,0,'E40, E50-E64',0,0,0,'D50-~~
D64',0,0,0,'D65-D89',0,0,0,'F01-F99',0,0,0,'G00, G03',0,0,0,'G35',0,0~~
,0,'G40-G41',0,0,0,'G04-G31, G36-G37, G43-H95',0,0,0,'I00-I99',0,0,0,~~
'I00-I02',0,0,0,'I05-I09',0,0,0,'I10-I13',0,0,0,'I21, I22',0,0,0,'I20~~
, I24, I25',0,0,0,'I26-I51',0,0,0,'I60-I69',0,0,0,'I70',0,0,0,'I71-I7~~
8',0,0,0,'I80-I82',0,0,0,'I83-I99',0,0,0,'J00-J06',0,0,0,'J20-J21',0,~~
0,0,'J12-J18',0,0,0,'J10-J11',0,0,0,'J40-J46',0,0,0,'J22, J30-J39, J4~~
7-J98',0,0,0,'K25-K27',0,0,0,'K35-K38',0,0,0,'K40-K46,K56',0,0,0,'K70~~
,K73-K74,K76',0,0,0,'K00-K22, K28-K31, K50-K55, K57-K66, K71, K72, K7~~
5, K80-K92',0,0,0,'N00-N07, N13-N19',0,0,0,'N10-N12',0,0,0,'N40',0,'N~~
20-N39, N41-N98',0,0,0,'O00-O07',0,'O20, O46, O67, O72',0,'O13-O16, O~~
21',0,'O85-O92, A34',0,'O10-O12, O22-O75, O95-O97',0,'O98-O99',0,'L00~~
-L98',0,0,0,'M00-M99',0,0,0,'Q03,Q05',0,0,0,'Q20-Q28',0,0,0,'Q00-Q02,~~
Q04, Q06-Q18, Q30-Q99',0,0,0,'P10-P15',0,0,0,'P00-P08, P20-P96, A33'~~
,0,0,0,'R54',0,0,0,'R00-R53, R55-R99',0,0,0,'V01-X59, Y40-Y86, Y88',0~~
,0,0,'V02-V04, V09, V12-V14, V19-V79, V86-V89',0,0,0,'V01, V05-V06, V~~
10, V11, V15-V18, V80-V85, V90-V99',0,0,0,'X40-X49',0,0,0,'W00-W19',0~~
,0,0,'X00-X09',0,0,0,'W65-W74',0,0,0,'W24-W31',0,0,0,'W32-W34',0,0,0,~~
'W20-W23, W35-W64, W75-W99, X10-X39, X50-X59, Y85, Y86',0,0,0,'Y40-Y8~~
4, Y88',0,0,0,'X60-X84',0,0,0,'X85-Y09',0,0,0,'Y10-Y36, Y87, Y89',0,0~~
,0,~
'All causes',0,0,0,'Infectious and parasitic diseases',0,0,0,'Typhoid~~
and paratyphoid fever',0,0,0,'Other intestinal infectious diseases',~~
0,0,0,'Tuberculosis of respiratory system',0,0,0,'Tuberculosis, other~~
forms',0,0,0,'Whooping cough',0,0,0,'Meningococcal infection',0,0,0,~~
'Tetanus',0,0,0,'Septicaemia',0,0,0,'Other bacterial diseases',0,0,0,~~
'Measles',0,0,0,'HIV disease',0,0,0,'Other viral diseases',0,0,0,'Mal~~
aria',0,0,0,'Other arthropod-borne diseases',0,0,0,'Sexually transmit~~
ted diseases',0,0,0,'Other infectious and parasitic diseases',0,0,0,'~~
Malignant neoplasms',0,0,0,'Malignant neoplasm of lip, oral cavity an~~
d pharynx',0,0,0,'Malignant neoplasm of oesophagus',0,0,0,'Malignant ~~
neoplasm of stomach',0,0,0,'Malignant neoplasm of colon',0,0,0,'Malig~~
nant neoplasm of rectum, rectosigmoid junction and anus',0,0,0,'Malig~~
nant neoplasm of liver',0,0,0,'Malignant neoplasm of larynx',0,0,0,'M~~
alignant neoplasm of trachea, bronchus and lung',0,0,0,'Malignant neo~~
plasm of breast',0,0,0,'Malignant neoplasm of cervix uteri',0,'Malign~~
ant neoplasm of uterus, other and unspecified',0,'Malignant neoplasm ~~
of prostate',0,'Malignant neoplasm of bladder',0,0,0,'Malignant neopl~~
asm of other sites',0,0,0,'Leukaemia',0,0,0,'Other malignant neoplasm~~
s of lymphoid and haematopoietic and related tissue',0,0,0,'Benign ne~~
oplasm, other and unspecified neoplasm',0,0,0,'Diabetes mellitus',0,0~~
,0,'Other endocrine and metabolic diseases',0,0,0,'Malnutrition',0,0,~~
0,'Other nutritional deficiencies',0,0,0,'Anaemias',0,0,0,'Other dise~~
ases of blood and blood-forming organs',0,0,0,'Mental disorders',0,0,~~
0,'Meningitis',0,0,0,'Multiple sclerosis',0,0,0,'Epilepsy',0,0,0,'Oth~~
er diseases of the nervous system and sense organs',0,0,0,'Diseases o~~
f the circulatory system',0,0,0,'Acute rheumatic fever',0,0,0,'Chroni~~
c rheumatic heart disease',0,0,0,'Hypertensive disease',0,0,0,'Acute ~~
myocardial infarction',0,0,0,'Other ischaemic heart diseases',0,0,0,'~~
Diseases of pulmonary circulation and other forms of heart disease',0~~
,0,0,'Cerebrovascular disease',0,0,0,'Atherosclerosis',0,0,0,'Embolis~~
m, thrombosis and other diseases of arteries, arterioles and capillar~~
ies',0,0,0,'Phlebitis, thrombophlebitis, venous embolism and thrombos~~
is',0,0,0,'Other diseases of the circulatory system',0,0,0,'Acute upp~~
er respiratory infection',0,0,0,'Acute bronchitis and bronchiolitis',~~
0,0,0,'Pneumonia',0,0,0,'Influenza',0,0,0,'Bronchitis, chronic and un~~
specified, emphysema and asthma',0,0,0,'Other diseases of the respira~~
tory system',0,0,0,'Ulcer of stomach and duodenum',0,0,0,'Appendiciti~~
s',0,0,0,'Hernia of abdominal cavity and intestinal obstruction',0,0,~~
0,'Chronic liver disease and cirrhosis',0,0,0,'Other diseases of the ~~
digestive system',0,0,0,'Nephritis, nephrotic syndrome and nephrosis'~~
,0,0,0,'Infections of kidney',0,0,0,'Hyperplasia of prostate',0,'Othe~~
r diseases of the genitourinary system',0,0,0,'Abortion',0,'Haemorrha~~
ge of pregnancy and childbirth',0,'Toxaemia of pregnancy',0,'Complica~~
tions of the puerperium',0,'Other direct obstetric causes',0,'Indirec~~
t obstetric causes',0,'Diseases of skin and subcutaneous tissue',0,0,~~
0,'Diseases of the musculoskeletal system and connective tissue',0,0,~~
0,'Spina bifida and hydrocephalus',0,0,0,'Congenital anomalies of the~~
circulatory system',0,0,0,'Other congenital anomalies',0,0,0,'Birth ~~
trauma',0,0,0,'Other conditions originating in the perinatal period',~~
0,0,0,'Senility',0,0,0,'Signs, symptoms and other ill-defined conditi~~
ons',0,0,0,'Accidents and adverse effects',0,0,0,'Motor vehicle traff~~
ic accidents',0,0,0,'Other transport accidents',0,0,0,'Accidental poi~~
soning',0,0,0,'Accidental falls',0,0,0,'Accidents caused by fire and ~~
flames',0,0,0,'Accidental drowning and submersion',0,0,0,'Accidents c~~
aused by machinery and by cutting and piercing instruments',0,0,0,'Ac~~
cidents caused by firearm missile',0,0,0,'All other accidents, includ~~
ing late effects',0,0,0,'Drugs, medicaments causing adverse effects i~~
n therapeutic use',0,0,0,'Suicide and self- inflicted injury',0,0,0,'~~
Homicide and injury purposely inflicted by other persons',0,0,0,'Othe~~
r external causes',0,0,0,~
'M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','~~
F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M~~
','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F'~~
,'M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M',~~
'F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','~~
M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F~~
','M','F','M','F','M','F','M','F','F','F','F','F','M','M','M','F','M'~~
,'F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F',~~
'M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','~~
F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M~~
','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F'~~
,'M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M',~~
'F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','~~
M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F~~
','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M'~~
,'F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F',~~
'M','F','M','F','M','F','M','M','M','F','M','F','F','F','F','F','F','~~
F','F','F','F','F','F','F','M','F','M','F','M','F','M','F','M','F','M~~
','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F'~~
,'M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M',~~
'F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','~~
M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F','M','F~~
','M','F','M','F','M','F','M','F','M','F','M','F',~
24.266K,24.895K,972.2,947.2,218,220,8.7,8.4,'-','-','-','-',20,49,0.8~~
,1.9,50,31,2,1.2,10,18,0.4,0.7,'-','-','-','-',1,5,0,0.2,1,'-',0,'-',~~
47,54,1.9,2.1,19,15,0.8,0.6,'-','-','-','-',26,3,1,0.1,21,21,0.8,0.8,~~
'-','-','-','-','-','-','-','-','-','-','-','-',23,24,0.9,0.9,5372,46~~
89,215.2,178.4,90,60,3.6,2.3,103,84,4.1,3.2,358,308,14.3,11.7,263,324~~
,10.5,12.3,201,176,8.1,6.7,170,144,6.8,5.5,37,1,1.5,0,1482,397,59.4,1~~
5.1,4,774,0.2,29.4,67,2.5,138,5.3,784,31.4,157,56,6.3,2.1,1241,1680,4~~
9.7,63.9,162,140,6.5,5.3,320,340,12.8,12.9,88,160,3.5,6.1,226,367,9.1~~
,14,31,39,1.2,1.5,'-',1,'-',0,5,1,0.2,0,13,15,0.5,0.6,13,19,0.5,0.7,8~~
38,1840,33.6,70,4,4,0.2,0.2,23,35,0.9,1.3,46,25,1.8,1,451,685,18.1,26~~
.1,10.315K,11.728K,413.2,446.2,'-','-','-','-',30,73,1.2,2.8,118,322,~~
4.7,12.3,4194,3793,168,144.3,2541,2441,101.8,92.9,891,1214,35.7,46.2,~~
1959,3337,78.5,127,121,266,4.8,10.1,415,203,16.6,7.7,41,71,1.6,2.7,5,~~
8,0.2,0.3,2,3,0.1,0.1,8,18,0.3,0.7,1192,1511,47.8,57.5,63,124,2.5,4.7~~
,800,288,32,11,115,90,4.6,3.4,138,162,5.5,6.2,4,9,0.2,0.3,82,101,3.3,~~
3.8,450,184,18,7,350,512,14,19.5,59,53,2.4,2,69,219,2.8,8.3,38,1.5,34~~
,93,1.4,3.5,'-','-','-','-','-','-',2,0.1,'-','-','-','-',8,13,0.3,0.~~
5,58,221,2.3,8.4,1,3,0,0.1,44,40,1.8,1.5,47,52,1.9,2,2,'-',0.1,'-',66~~
,49,2.6,1.9,10,37,0.4,1.4,93,46,3.7,1.8,1706,877,68.3,33.4,286,109,11~~
.5,4.1,81,27,3.2,1,493,131,19.8,5,481,472,19.3,18,55,25,2.2,1,95,23,3~~
.8,0.9,17,2,0.7,0.1,3,'-',0.1,'-',192,85,7.7,3.2,3,3,0.1,0.1,965,282,~~
38.7,10.7,118,51,4.7,1.9,101,27,4,1,~
136,102,436.7,344.8,4,1,12.8,3.4,'-','-','-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-',1,1,3.2,3.4,'-','-','-','~~
-',1,'-',3.2,'-','-','-','-','-','-','-','-','-','-','-','-','-',2,'-~~
',6.4,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-',1,'-',3.2,'-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-',1,'-',3.2,'-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-',1,3,3.2,10.1,'-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-',1,'-',3.4,'-','-','-','-','-','-','-~~
','-',3,1,9.6,3.4,2,2,6.4,6.8,'-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-',2,2,6.4,6.8,'-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-','-',1,'-',3.4,'-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-',1,'-',3.4,'-','-','-','-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-',1,1,3.2,3.4,22,16,70.6,54.1,22,17,70.6,57.~~
5,1,'-',3.2,'-',64,47,205.5,158.9,'-','-','-','-',10,7,32.1,23.7,2,1,~~
6.4,3.4,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-',1,'-',3.2,'-','-','-','-','-','-','-','-','-',1,1,~~
3.2,3.4,'-','-','-','-','-','-','-','-',2,3,6.4,10.1,1,'-',3.2,'-',~
22,29,16.6,22.7,'-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-',6,5,4.5,3.9,'-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,3,4,2.3,3.1,3,1,2.3,0.8,'-','-','-','-','-','-','-','-','-','-','-',~~
'-',1,1,0.8,0.8,'-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-',2,1,1.5,0.8,2,2,1.5,1.6,'-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-',2,2,1.5,1.6,'-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-',2,1,1.5,0.8,1,'-',0.8,'-','-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-',1,'-',0.8,'-','-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-',1,'-',0.8,1,3,0.8,2.3,2,2,1.5,1.6,'-','-',~~
'-','-',1,1,0.8,0.8,'-','-','-','-','-','-','-','-',3,11,2.3,8.6,1,4,~~
0.8,3.1,'-','-','-','-','-','-','-','-','-','-','-','-','-',1,'-',0.8~~
,1,4,0.8,3.1,'-',1,'-',0.8,'-','-','-','-',1,1,0.8,0.8,'-','-','-','-~~
','-','-','-','-','-',1,'-',0.8,'-','-','-','-',~
72,44,21.7,13.9,2,'-',0.6,'-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',1~~
,'-',0.3,'-','-','-','-','-','-','-','-','-','-','-','-','-',1,'-',0.~~
3,'-',9,12,2.7,3.8,'-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',6,8,~~
1.8,2.5,1,4,0.3,1.3,2,'-',0.6,'-','-','-','-','-','-',1,'-',0.3,5,5,1~~
.5,1.6,'-','-','-','-','-','-','-','-','-',1,'-',0.3,'-','-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-',2,'-',0.6,'-',2,1,0.6~~
,0.3,6,2,1.8,0.6,'-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-',4,2,1.2,0.6,2,'-',0.6,'-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-',4,'-',1.2,'-','-','-','-','-','-',1,'-',0.3,'-','-','-','~~
-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-','-','-','-','-',2,2,0.6,0.6,2,3,0.6,0.9,'-','-','-','-',1~~
,'-',0.3,'-','-','-','-','-',1,'-',0.3,'-',31,11,9.4,3.5,9,3,2.7,0.9,~~
9,4,2.7,1.3,'-','-','-','-','-','-','-','-',1,1,0.3,0.3,9,3,2.7,0.9,'~~
-','-','-','-',1,'-',0.3,'-',2,'-',0.6,'-','-','-','-','-',3,3,0.9,0.~~
9,2,1,0.6,0.3,'-',1,'-',0.3,~
285,88,88,28.4,1,4,0.3,1.3,'-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-',2,'-',0.6,'-','-','-','-',~~
1,'-',0.3,'-','-','-','-','-','-','-','-','-','-','-','-','-','-',2,'~~
-',0.6,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
',15,9,4.6,2.9,'-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,'-','-',1,'-',0.3,'-','-','-','-','-','-','-','-','-','-',9,5,2.8,1.~~
6,4,2,1.2,0.6,2,1,0.6,0.3,'-',1,'-',0.3,3,1,0.9,0.3,4,'-',1.2,'-','-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-',1,'-',0.3,4,1,1.2,0.~~
3,'-','-','-','-','-','-','-','-',1,1,0.3,0.3,4,1,1.2,0.3,8,6,2.5,1.9~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',~~
'-','-','-',3,4,0.9,1.3,4,2,1.2,0.6,'-','-','-','-','-','-','-','-',1~~
,'-',0.3,'-','-','-','-','-','-','-','-','-','-','-','-','-',1,5,0.3,~~
1.6,'-','-','-','-',1,'-',0.3,'-','-','-','-','-',1,'-',0.3,'-','-',1~~
,'-',0.3,1,'-',0.3,'-','-','-','-','-','-','-','-','-','-','-','-','-~~
',1,'-',0.3,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-','-','-','-',2,'-',0.6,'-',1,'-',0.3,3,'-',~~
0.9,'-',4,2,1.2,0.6,'-','-','-','-','-','-','-','-','-','-','-','-',2~~
,1,0.6,0.3,95,24,29.3,7.7,65,20,20.1,6.5,6,1,1.9,0.3,7,1,2.2,0.3,4,'-~~
',1.2,'-',1,'-',0.3,'-',5,1,1.5,0.3,'-','-','-','-',2,'-',0.6,'-',5,1~~
,1.5,0.3,'-','-','-','-',110,21,34,6.8,14,5,4.3,1.6,12,1,3.7,0.3,~
538,148,146.5,42,14,4,3.8,1.1,'-','-','-','-','-','-','-','-','-',1,'~~
-',0.3,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
',2,1,0.5,0.3,'-','-','-','-','-','-','-','-',11,2,3,0.6,'-','-','-',~~
'-','-','-','-','-','-','-','-','-','-','-','-','-',1,'-',0.3,'-',42,~~
25,11.4,7.1,'-','-','-','-','-','-','-','-',1,1,0.3,0.3,3,'-',0.8,'-'~~
,3,'-',0.8,'-','-',1,'-',0.3,'-','-','-','-',3,'-',0.8,'-','-',6,'-',~~
1.7,1,0.3,'-','-','-','-','-','-','-','-',21,13,5.7,3.7,5,3,1.4,0.9,6~~
,'-',1.6,'-','-','-','-','-',4,5,1.1,1.4,1,2,0.3,0.6,'-','-','-','-',~~
'-','-','-','-','-','-','-','-','-',1,'-',0.3,18,2,4.9,0.6,'-','-','-~~
','-',1,1,0.3,0.3,11,3,3,0.9,'-',3,'-',0.9,39,7,10.6,2,'-','-','-','-~~
','-','-','-','-','-','-','-','-',3,2,0.8,0.6,5,'-',1.4,'-',19,2,5.2,~~
0.6,12,2,3.3,0.6,'-','-','-','-','-','-','-','-','-',1,'-',0.3,'-','-~~
','-','-','-','-','-','-','-','-','-','-',2,2,0.5,0.6,'-','-','-','-'~~
,'-',1,'-',0.3,1,'-',0.3,'-','-','-','-','-','-','-','-','-',1,'-',0.~~
3,'-',9,3,2.5,0.9,6,'-',1.6,'-','-','-','-','-','-','-','-','-','-','~~
-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-','-','-',1,'-',0.3,'-','-','-','-','-',6,4,1.6,1.1,2,'-',0.5,'-'~~
,1,'-',0.3,'-','-',1,'-',0.3,'-','-','-','-',9,1,2.5,0.3,136,26,37,7.~~
4,34,9,9.3,2.6,12,2,3.3,0.6,49,6,13.3,1.7,7,6,1.9,1.7,3,'-',0.8,'-',1~~
0,'-',2.7,'-',7,'-',1.9,'-','-','-','-','-',14,3,3.8,0.9,'-','-','-',~~
'-',183,44,49.8,12.5,36,9,9.8,2.6,15,4,4.1,1.1,~
1172,441,293,114.2,14,7,3.5,1.8,'-','-','-','-','-','-','-','-',2,'-'~~
,0.5,'-','-','-','-','-','-','-','-','-','-',1,'-',0.3,'-','-','-','-~~
',2,3,0.5,0.8,1,'-',0.3,'-','-','-','-','-',8,1,2,0.3,1,1,0.3,0.3,'-'~~
,'-','-','-','-','-','-','-','-','-','-','-','-',1,'-',0.3,117,124,29~~
.3,32.1,4,1,1,0.3,2,'-',0.5,'-',15,6,3.8,1.6,7,1,1.8,0.3,6,1,1.5,0.3,~~
3,4,0.8,1,2,'-',0.5,'-',14,4,3.5,1,'-',51,'-',13.2,8,2.1,'-','-','-',~~
'-','-','-','-','-',38,41,9.5,10.6,8,3,2,0.8,18,4,4.5,1,3,2,0.8,0.5,1~~
9,15,4.8,3.9,1,2,0.3,0.5,'-','-','-','-','-','-','-','-',1,'-',0.3,'-~~
','-',1,'-',0.3,63,12,15.8,3.1,1,'-',0.3,'-',2,4,0.5,1,12,5,3,1.3,7,1~~
2,1.8,3.1,208,54,52,14,'-','-','-','-','-','-','-','-',3,1,0.8,0.3,65~~
,8,16.3,2.1,31,5,7.8,1.3,61,9,15.3,2.3,41,24,10.3,6.2,'-','-','-','-'~~
,6,4,1.5,1,1,3,0.3,0.8,'-','-','-','-',1,'-',0.3,'-','-',1,'-',0.3,19~~
,10,4.8,2.6,1,'-',0.3,'-',2,2,0.5,0.5,1,2,0.3,0.5,2,'-',0.5,'-','-','~~
-','-','-',6,1,1.5,0.3,69,25,17.3,6.5,25,12,6.3,3.1,1,1,0.3,0.3,'-',1~~
,'-',0.3,'-','-',2,2,0.5,0.5,'-','-','-','-','-','-',2,0.5,'-','-','-~~
','-','-','-','-','-',5,4,1.3,1,'-','-','-','-',3,3,0.8,0.8,2,5,0.5,1~~
.3,'-','-','-','-','-','-','-','-','-','-','-','-',19,8,4.8,2.1,283,5~~
5,70.8,14.2,42,9,10.5,2.3,12,3,3,0.8,126,31,31.5,8,40,3,10,0.8,7,1,1.~~
8,0.3,14,2,3.5,0.5,2,1,0.5,0.3,'-','-','-','-',40,4,10,1,'-',1,'-',0.~~
3,226,55,56.5,14.2,34,7,8.5,1.8,23,7,5.8,1.8,~
2228,861,578.9,229.8,21,6,5.5,1.6,'-','-','-','-','-','-','-','-',3,'~~
-',0.8,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-~~
','-',4,5,1,1.3,5,'-',1.3,'-','-','-','-','-',5,'-',1.3,'-',4,1,1,0.3~~
,'-','-','-','-','-','-','-','-','-','-','-','-','-','-','-','-',418,~~
381,108.6,101.7,18,4,4.7,1.1,15,3,3.9,0.8,25,20,6.5,5.3,28,16,7.3,4.3~~
,17,8,4.4,2.1,12,6,3.1,1.6,5,'-',1.3,'-',93,30,24.2,8,2,141,0.5,37.6,~~
2,0.5,4,1.1,13,3.4,2,2,0.5,0.5,145,121,37.7,32.3,11,7,2.9,1.9,32,17,8~~
.3,4.5,1,7,0.3,1.9,32,16,8.3,4.3,5,1,1.3,0.3,'-','-','-','-','-',1,'-~~
',0.3,1,'-',0.3,'-','-',1,'-',0.3,63,14,16.4,3.7,1,'-',0.3,'-',6,10,1~~
.6,2.7,10,3,2.6,0.8,19,12,4.9,3.2,715,152,185.8,40.6,'-','-','-','-',~~
1,'-',0.3,'-',7,1,1.8,0.3,228,36,59.2,9.6,205,14,53.3,3.7,112,31,29.1~~
,8.3,134,66,34.8,17.6,1,'-',0.3,'-',22,3,5.7,0.8,4,1,1,0.3,1,'-',0.3,~~
'-',1,'-',0.3,'-','-',2,'-',0.5,43,13,11.2,3.5,'-','-','-','-',17,4,4~~
.4,1.1,3,2,0.8,0.5,16,1,4.2,0.3,1,'-',0.3,'-',4,2,1,0.5,154,40,40,10.~~
7,39,12,10.1,3.2,2,1,0.5,0.3,'-',1,'-',0.3,'-','-',4,1,1,0.3,'-','-',~~
'-','-','-','-','-','-','-','-','-','-',1,'-',0.3,'-',1,4,0.3,1.1,'-'~~
,'-','-','-',1,1,0.3,0.3,2,4,0.5,1.1,'-','-','-','-','-','-','-','-',~~
'-','-','-','-',22,8,5.7,2.1,366,75,95.1,20,42,10,10.9,2.7,13,3,3.4,0~~
.8,157,40,40.8,10.7,76,8,19.7,2.1,16,5,4.2,1.3,19,1,4.9,0.3,4,'-',1,'~~
-','-','-','-','-',39,8,10.1,2.1,'-','-','-','-',213,68,55.3,18.1,21,~~
13,5.5,3.5,25,5,6.5,1.3,~
3353,1390,1341.7,520,28,8,11.2,3,'-','-','-','-',2,'-',0.8,'-',4,'-',~~
1.6,'-',3,'-',1.2,'-','-','-','-','-','-','-','-','-','-','-','-','-'~~
,8,4,3.2,1.5,1,1,0.4,0.4,'-','-','-','-',2,'-',0.8,'-',7,1,2.8,0.4,'-~~
','-','-','-','-','-','-','-','-','-','-','-',1,2,0.4,0.7,911,622,364~~
.5,232.7,23,7,9.2,2.6,21,6,8.4,2.2,72,25,28.8,9.4,39,35,15.6,13.1,34,~~
27,13.6,10.1,23,11,9.2,4.1,8,'-',3.2,'-',292,64,116.8,23.9,1,150,0.4,~~
56.1,10,3.7,16,6,61,24.4,21,1,8.4,0.4,238,217,95.2,81.2,10,22,4,8.2,6~~
8,31,27.2,11.6,14,9,5.6,3.4,27,17,10.8,6.4,7,1,2.8,0.4,'-','-','-','-~~
',2,'-',0.8,'-','-',1,'-',0.4,4,'-',1.6,'-',45,7,18,2.6,'-','-','-','~~
-',8,7,3.2,2.6,5,4,2,1.5,39,56,15.6,21,1462,378,585,141.4,'-','-','-'~~
,'-',7,5,2.8,1.9,16,10,6.4,3.7,631,116,252.5,43.4,407,72,162.9,26.9,1~~
43,62,57.2,23.2,205,99,82,37,3,1,1.2,0.4,43,7,17.2,2.6,6,5,2.4,1.9,1,~~
1,0.4,0.4,'-','-','-','-',1,'-',0.4,'-',52,25,20.8,9.4,4,'-',1.6,'-',~~
83,23,33.2,8.6,21,5,8.4,1.9,25,7,10,2.6,1,1,0.4,0.4,12,2,4.8,0.7,128,~~
28,51.2,10.5,45,17,18,6.4,6,4,2.4,1.5,3,7,1.2,2.6,'-','-','-',1,'-',0~~
.4,'-','-','-','-','-','-','-','-','-','-','-','-',2,1,0.8,0.4,14,14,~~
5.6,5.2,'-','-','-','-',2,3,0.8,1.1,2,8,0.8,3,'-','-','-','-','-','-'~~
,'-','-','-','-','-','-',16,6,6.4,2.2,273,75,109.2,28.1,37,14,14.8,5.~~
2,11,3,4.4,1.1,98,26,39.2,9.7,55,12,22,4.5,10,3,4,1.1,15,8,6,3,3,'-',~~
1.2,'-','-','-','-','-',43,9,17.2,3.4,1,'-',0.4,'-',94,42,37.6,15.7,7~~
,7,2.8,2.6,10,4,4,1.5,~
6397,4045,3501.4,1609.6,51,38,27.9,15.1,'-','-','-','-',1,3,0.5,1.2,1~~
3,4,7.1,1.6,3,5,1.6,2,'-','-','-','-','-','-','-','-','-','-','-','-'~~
,16,7,8.8,2.8,5,4,2.7,1.6,'-','-','-','-','-','-','-','-',5,5,2.7,2,'~~
-','-','-','-','-','-','-','-','-','-','-','-',8,10,4.4,4,1797,1295,9~~
83.6,515.3,26,15,14.2,6,35,14,19.2,5.6,106,107,58,42.6,93,85,50.9,33.~~
8,66,46,36.1,18.3,65,37,35.6,14.7,15,1,8.2,0.4,601,126,329,50.1,'-',1~~
80,'-',71.6,15,6,48,19.1,220,120.4,49,12,26.8,4.8,379,469,207.4,186.6~~
,54,36,29.6,14.3,88,104,48.2,41.4,21,28,11.5,11.1,76,84,41.6,33.4,2,8~~
,1.1,3.2,'-','-','-','-',3,'-',1.6,'-',1,2,0.5,0.8,7,4,3.8,1.6,83,67,~~
45.4,26.7,2,2,1.1,0.8,3,8,1.6,3.2,4,7,2.2,2.8,144,133,78.8,52.9,3106,~~
1772,1700.1,705.1,'-','-','-','-',8,24,4.4,9.6,17,37,9.3,14.7,1390,66~~
8,760.8,265.8,759,359,415.4,142.9,201,131,110,52.1,526,481,287.9,191.~~
4,22,8,12,3.2,170,48,93,19.1,13,16,7.1,6.4,'-','-','-','-','-',1,'-',~~
0.4,'-',2,'-',0.8,198,93,108.4,37,11,7,6,2.8,268,83,146.7,33,33,15,18~~
.1,6,27,30,14.8,11.9,'-','-','-','-',11,11,6,4.4,60,36,32.8,14.3,71,4~~
6,38.9,18.3,16,8,8.8,3.2,11,21,6,8.4,11,6,8,9,4.4,3.6,'-','-','-','-'~~
,'-','-','-','-','-','-','-','-',2,3,1.1,1.2,15,62,8.2,24.7,'-','-','~~
-','-',4,6,2.2,2.4,2,6,1.1,2.4,'-','-','-','-','-','-','-','-',1,'-',~~
0.5,'-',9,6,4.9,2.4,238,114,130.3,45.4,35,17,19.2,6.8,10,5,5.5,2,48,2~~
2,26.3,8.8,89,49,48.7,19.5,7,5,3.8,2,19,1,10.4,0.4,'-','-','-','-','-~~
','-','-','-',29,14,15.9,5.6,1,1,0.5,0.4,92,34,50.4,13.5,2,4,1.1,1.6,~~
7,'-',3.8,'-',~
10.063K,17.747K,10.9619K,8371.2,83,152,90.4,71.7,'-','-','-','-',17,4~~
6,18.5,21.7,28,26,30.5,12.3,4,13,4.4,6.1,'-','-','-','-','-',1,'-',0.~~
5,1,'-',1.1,'-',13,34,14.2,16,7,10,7.6,4.7,'-','-','-','-','-','-','-~~
','-',1,11,1.1,5.2,'-','-','-','-','-','-','-','-','-','-','-','-',12~~
,11,13.1,5.2,2056,2216,2239.7,1045.3,19,33,20.7,15.6,30,61,32.7,28.8,~~
139,149,151.4,70.3,93,187,101.3,88.2,75,94,81.7,44.3,67,85,73,40.1,7,~~
'-',7.6,'-',479,173,521.8,81.6,1,245,1.1,115.6,31,14.6,70,33,490,533.~~
8,85,41,92.6,19.3,402,802,437.9,378.3,65,62,70.8,29.2,104,183,113.3,8~~
6.3,49,113,53.4,53.3,65,228,70.8,107.5,4,16,4.4,7.5,'-',1,'-',0.5,'-'~~
,'-','-','-',10,11,10.9,5.2,2,11,2.2,5.2,562,1737,612.2,819.3,'-',1,'~~
-',0.5,3,5,3.3,2.4,1,2,1.1,0.9,231,465,251.6,219.3,4767,9353,5192.8,4~~
411.8,'-','-','-','-',14,44,15.3,20.8,75,273,81.7,128.8,1877,2963,204~~
4.7,1397.6,1134,1991,1235.3,939.2,344,969,374.7,457.1,1035,2663,1127.~~
5,1256.1,95,257,103.5,121.2,174,141,189.5,66.5,16,45,17.4,21.2,3,7,3.~~
3,3.3,'-',2,'-',0.9,7,13,7.6,6.1,871,1361,948.8,642,46,117,50.1,55.2,~~
429,174,467.3,82.1,56,66,61,31.1,67,124,73,58.5,2,7,2.2,3.3,47,85,51.~~
2,40.1,30,52,32.7,24.5,164,424,178.6,200,33,39,35.9,18.4,54,189,58.8,~~
89.2,27,29.4,20,80,21.8,37.7,'-','-','-','-','-','-','-','-','-','-',~~
'-','-',3,9,3.3,4.2,22,135,24,63.7,'-','-','-','-','-',2,'-',0.9,7,5,~~
7.6,2.4,'-','-','-','-','-','-','-','-',9,37,9.8,17.5,5,9,5.4,4.2,279~~
,485,303.9,228.8,21,23,22.9,10.8,8,6,8.7,2.8,8,5,8.7,2.4,210,394,228.~~
8,185.8,10,9,10.9,4.2,2,3,2.2,1.4,1,'-',1.1,'-','-','-','-','-',18,44~~
,19.6,20.8,1,1,1.1,0.5,44,15,47.9,7.1,'-',1,'-',0.5,8,5,8.7,2.4,~
'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0~~
,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-~~
',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-'~~
,'-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,~~
'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-',0,'-'~~
,0,'-',0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,~~
'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0~~
,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-~~
',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-'~~
,'-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,~~
'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0~~
,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-~~
',0,0,'-','-',0,0,'-',0,'-','-',0,0,'-',0,'-',0,'-',0,'-',0,'-',0,'-'~~
,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-~~
',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-'~~
,'-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,~~
'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0,0,'-','-',0~~
,0~
)
Nodelocation: 168,32,1
Nodesize: 48,24
Windstate: 2,239,1,476,597
Defnstate: 2,47,25,1209,720,0,MIDM
Valuestate: 2,96,21,1156,479,0,MIDM
Nodecolor: 65535,52427,65534
Reformdef: [Var1,Item2]
Reformval: [Var1,Item2]
Index Diagnosis1
Title: Diagnosis1
Definition: var a:= who_data[var1='Cause groupings'];~
var b:= a[item2=unique(a,Item2)];~
subset(b)
Nodelocation: 296,64,1
Nodesize: 48,12
Windstate: 2,419,124,476,415
Valuestate: 1,104,114,512,303,0,MIDM
{!40000|Att_previndexvalue: ['All causes',0,'Infectious and parasitic ~~
diseases','Typhoid and paratyphoid fever','Other intestinal infectiou~~
s diseases','Tuberculosis of respiratory system','Tuberculosis, other~~
forms','Whooping cough','Meningococcal infection','Tetanus','Septica~~
emia','Other bacterial diseases','Measles','HIV disease','Other vira~~
l diseases','Malaria','Other arthropod-borne diseases','Sexually tran~~
smitted diseases','Other infectious and parasitic diseases','Malignan~~
t neoplasms','Malignant neoplasm of lip, oral cavity and pharynx','Ma~~
lignant neoplasm of oesophagus','Malignant neoplasm of stomach','Mali~~
gnant neoplasm of colon','Malignant neoplasm of rectum, rectosigmoid ~~
junction and anus','Malignant neoplasm of liver','Malignant neoplasm~~
of larynx','Malignant neoplasm of trachea, bronchus and lung','Malig~~
nant neoplasm of breast','Malignant neoplasm of cervix uteri','Malign~~
ant neoplasm of uterus, other and unspecified','Malignant neoplasm of~~
prostate','Malignant neoplasm of bladder','Malignant neoplasm of oth~~
er sites','Leukaemia','Other malignant neoplasms of lymphoid and haem~~
atopoietic and related tissue','Benign neoplasm, other and unspecifie~~
d neoplasm','Diabetes mellitus','Other endocrine and metabolic diseas~~
es','Malnutrition','Other nutritional deficiencies','Anaemias','Other~~
diseases of blood and blood-forming organs','Mental disorders','Meni~~
ngitis','Multiple sclerosis','Epilepsy','Other diseases of the nervou~~
s system and sense organs','Diseases of the circulatory system','Acu~~
te rheumatic fever','Chronic rheumatic heart disease','Hypertensive d~~
isease','Acute myocardial infarction','Other ischaemic heart diseases~~
','Diseases of pulmonary circulation and other forms of heart disease~~
','Cerebrovascular disease','Atherosclerosis','Embolism, thrombosis a~~
nd other diseases of arteries, arterioles and capillaries','Phlebitis~~
, thrombophlebitis, venous embolism and thrombosis','Other diseases ~~
of the circulatory system','Acute upper respiratory infection','Acute~~
bronchitis and bronchiolitis','Pneumonia','Influenza','Bronchitis, c~~
hronic and unspecified, emphysema and asthma','Other diseases of the ~~
respiratory system','Ulcer of stomach and duodenum','Appendicitis','H~~
ernia of abdominal cavity and intestinal obstruction','Chronic liver ~~
disease and cirrhosis','Other diseases of the digestive system','Nep~~
hritis, nephrotic syndrome and nephrosis','Infections of kidney','Hyp~~
erplasia of prostate','Other diseases of the genitourinary system','A~~
bortion','Haemorrhage of pregnancy and childbirth','Toxaemia of pregn~~
ancy','Complications of the puerperium','Other direct obstetric cause~~
s','Indirect obstetric causes','Diseases of skin and subcutaneous tis~~
sue','Diseases of the musculoskeletal system and connective tissue','~~
Spina bifida and hydrocephalus','Congenital anomalies of the circulat~~
ory system','Other congenital anomalies','Birth trauma','Other condit~~
ions originating in the perinatal period','Senility','Signs, symptoms~~
and other ill-defined conditions','Accidents and adverse effects','M~~
otor vehicle traffic accidents','Other transport accidents','Acciden~~
tal poisoning','Accidental falls','Accidents caused by fire and flame~~
s','Accidental drowning and submersion','Accidents caused by machiner~~
y and by cutting and piercing instruments','Accidents caused by firea~~
rm missile','All other accidents, including late effects','Drugs, med~~
icaments causing adverse effects in therapeutic use','Suicide and sel~~
f- inflicted injury','Homicide and injury purposely inflicted by othe~~
r persons','Other external causes']}
Ident: Op_en2779
Variable Icd10
Title: ICD-10
Definition: index i:= who_data[var1='Cause groupings'];~
var a:= who_data[@item2=@i];~
a[i=Diagnosis1, var1='ICD-10 codes']
Nodelocation: 296,32,1
Nodesize: 48,24
Windstate: 2,269,234,476,224
Valuestate: 2,173,379,867,359,0,MIDM
Reformval: [Var1,Sys_localindex('I')]
Index Units1
Title: Units1
Definition: ['Number','Deaths/100000 py']
Nodelocation: 168,232,1
Nodesize: 48,12
Valuestate: 1,312,322,416,303,0,MIDM
Index Age_group1
Title: Age group1
Definition: ['All ages','< 1','1-4','5-14','15-24','25-34','35-44','45~~
-54','55-64','65-74','75+','Age not specified']
Nodelocation: 56,192,1
Nodesize: 48,12
Windstate: 2,102,90,476,346
Valuestate: 1,264,274,416,303,0,MIDM
Ident: Op_en2781
{!40000|Att_previndexvalue: ['All ages','< 1','1-4','5-14','15-24','25~~
-34','35-44','45-54','55-64','65-74','75+','Age not specified']}
Variable D_age
Title: 2D Age groups
Definition: using a:= slice(who_data,var1,Age_groups)~
do a
Nodelocation: 168,136,1
Nodesize: 48,24
Windstate: 1,110,170
Valuestate: 2,38,30,721,505,0,MIDM
Reformval: [Item2,Age_group1]
{!40000|Att_resultslicestate: [Vars,1,Age_group1,1,Item2,1]}
Variable Age_groups
Title: Age groups
Definition: Table(Age_group1,vars)(~
1,3,4,5,~
1,3,4,6,~
1,3,4,7,~
1,3,4,8,~
1,3,4,9,~
1,3,4,10,~
1,3,4,11,~
1,3,4,12,~
1,3,4,13,~
1,3,4,14,~
1,3,4,15,~
1,3,4,16~
)
Indexvals: ['Variable','Cause groupings','Sex','Value']
Nodelocation: 56,136,1
Nodesize: 48,24
Windstate: 1,110,278
Defnstate: 1,575,134,478,303,0,MIDM
Valuestate: 1,339,222,718,318,0,MIDM
Reformdef: [Vars,Age_group1]
Reformval: [Vars,Age_group1]
{!40000|Att_previndexvalue: ['Variable','Cause groupings','Sex','Value~~
']}
Objective Who_mortality_data
Title: Mortality in Finland
Definition: var a:= d_age[vars='Cause groupings'];~
var b:= 0;~
var d:= 0;~
var x:= 1;~
while x<=size(Item2) do (~
var c:= a[Item2=x];~
b:= if c=0 then b else c;~
d:= if Item2=x then b else d;~
x:= x+1);~
a:= if vars='Cause groupings' then d else d_age;~
a:= mdtable(a,Item2,vars,[Units1,diagnosis1,sex1]);~
a:= a[@sex1=@sex];~
if country1='Finland' then a else a
Nodelocation: 168,200,1
Nodesize: 48,24
Windstate: 2,650,273,476,415
Valuestate: 2,83,123,992,591,0,MIDM
Nodecolor: 65535,52427,52427
Reformval: [Age_group1,Diagnosis1]
{!40000|Att_resultslicestate: [Units1,1,Country1,1,Sex,1,Diagnosis1,1,~~
Age_group1,1]}
Ident: Op_en2778
Index Vars
Title: Vars
Definition: ['Variable','Cause groupings','Sex','Value']
Nodelocation: 56,168,1
Nodesize: 48,12
{!40000|Att_previndexvalue: ['Variable','Cause groupings','Sex','Value~~
']}
Module Op_en2676
Title: Opasnet base connection
Description: Wiki description
Author: HP_Omistaja
Date: 9. maata 2008 10:42
Saveauthor: jtue
Savedate: 3. helta 2009 14:17
Defaultsize: 48,24
Nodelocation: 472,40,0
Nodesize: 48,29
Nodeinfo: 1,0,0,1,1,1,0,0,0,0
Diagstate: 1,772,97,462,377,17
Windstate: 2,102,90,476,224
Fontstyle: Arial, 15
Att__diagramprintsca: 100,1,1,1,1,9,2970,2100,1,0
Module Writer
Title: Writer
Author: jtue
Date: 1. jouta 2008 10:57
Defaultsize: 48,24
Nodelocation: 192,80,1
Nodesize: 48,24
Diagstate: 1,9,11,636,495,17
Att__diagramprintsca: 100,1,1,0,1,9,2970,2100,15,0
Module Writing_code
Title: Writing code
Author: jtue
Date: 18. heita 2008 10:14
Defaultsize: 48,24
Nodelocation: 496,296,1
Nodesize: 48,24
Diagstate: 1,672,61,564,502,17
Att__diagramprintsca: 100,1,1,1,1,9,2970,2100,15,0
Library Concatenation_udfs
Title: Concatenation UDFs
Description: This library contains functions to make various instances~~
of concatenation more convenient. Concat3 thru Concat10 are general~~
izations of the built-in Concat function which concatenate from 3 to ~~
10 arrays in a single call (while the built-in Concat concatenates tw~~
o arrays). ConcatRows concatenates all the rows of a single array.
Author: David Kendall & Lonnie Chrisman
Date: Mon, Jan 26, 2004 8:49 AM
Saveauthor: Lonnie
Savedate: Wed, Sep 05, 2007 3:23 PM
Defaultsize: 48,24
Nodelocation: 456,176,1
Nodesize: 68,20
Nodeinfo: 1,0,0,1,1,1,0,0,0,0
Diagstate: 1,50,200,488,454,23
Function Concat3(A1, A2, A3: ArrayType; I1, I2, I3, J: IndexType )
Title: Concat3
Description: Concatenates three arrays, A1, A2, and A3. I1, I2, and I~~
3 are the indexes that are joined; J is the index of the new array; J~~
usually is the concatenation of I1, I2, and I3
Definition: Index I12 := Concat(I1,I2);~
Concat( Concat( A1,A2,I1,I2,I12 ), A3, I12, I3, J )
Nodelocation: 88,64,1
Nodesize: 48,26
Windstate: 2,56,56,986,596
Paramnames: A1,A2,A3,I1,I2,I3,J
Function Concat4(A1, A2, A3, A4: ArrayType; I1, I2, I3, I4, J: IndexTy~~
pe )
Title: Concat4
Description: Concatenates four arrays, A1, A2, A3, and A4. I1, I2, I3~~
, and I4 are the indexes that are joined; J is the index of the new a~~
rray; J usually is the concatenation of I1, I2, I3, and I4.
Definition: Index I12 := Concat(I1,I2);~
Index I123:= Concat(I12, I3);~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, J);~
Nodelocation: 192,64,1
Nodesize: 48,24
Windstate: 2,30,30,986,596
Paramnames: A1,A2,A3,A4,I1,I2,I3,I4,J
Att__cloakdefn: 0
Function Concat9(A1, A2, A3, A4, A5, A6, A7, A8, A9: ArrayType; I1, I2~~
, I3, I4, I5, I6, I7, I8, I9, J: IndexType)
Title: Concat9
Description: Concatenates nine arrays, A1, ..., A9. I1, ..., I9 are t~~
he indexes joined; J is the index of the new array; J usually is the ~~
concatenation of I1, ..., I9.
Definition: Index I12 := Concat(I1,I2);~
Index I123 := Concat(I12, I3);~
Index I1234 := Concat(I123, I4);~
Index I12345 := Concat(I1234, I5);~
Index I123456 := Concat(I12345, I6);~
Index I1234567 := Concat(I123456, I7);~
Index I12345678 := Concat(I1234567, I8);~
Concat(~
Concat(~
Concat(~
Concat(~
Concat( ~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, I1234),~
A5, I1234, I5, I12345),~
A6, I12345, I6, I123456),~
A7, I123456, I7, I1234567),~
A8, I1234567, I8, I12345678),~
A9, I12345678, I9, J);
Nodelocation: 88,232,1
Nodesize: 48,24
Windstate: 2,27,120,469,638
Paramnames: A1,A2,A3,A4,A5,A6,A7,A8,A9,I1,I2,I3,I4,I5,I6,I7,I8,I9,J
Att__cloakdefn: 0
Function Concat5(A1, A2, A3, A4, A5: ArrayType; I1, I2, I3, I4, I5, J:~~
IndexType )
Title: Concat5
Description: Concatenates five arrays, A1, ..., A5. I1, ..., I5 are t~~
he indexes joined; J is the index of the new array; J usually is the ~~
concatenation of I1, ..., I5.
Definition: Index I12 := Concat(I1,I2);~
Index I123:= Concat(I12, I3);~
Index I1234 := Concat(I123, I4);~
Concat(~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, I1234),~
A5, I1234, I5, J);
Nodelocation: 88,120,1
Nodesize: 48,24
Windstate: 2,160,160,986,596
Paramnames: A1,A2,A3,A4,A5,I1,I2,I3,I4,I5,J
Function Concat6(A1, A2, A3, A4, A5, A6: ArrayType; I1, I2, I3, I4, I5~~
, I6, J: IndexType )
Title: Concat6
Description: Concatenates six arrays, A1, ..., A6. I1, ..., I6 are t~~
he indexes joined; J is the index of the new array; J usually is the ~~
concatenation of I1, ..., I6.
Definition: Index I12 := Concat(I1,I2);~
Index I123:= Concat(I12, I3);~
Index I1234 := Concat(I123, I4);~
Index I12345 := Concat(I1234, I5);~
Concat(~
Concat(~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, I1234),~
A5, I1234, I5, I12345),~
A6, I12345, I6, J);
Nodelocation: 192,120,1
Nodesize: 48,24
Windstate: 2,644,94,602,712
Paramnames: A1,A2,A3,A4,A5,A6,I1,I2,I3,I4,I5,I6,J
Att__cloakdefn: 0
Function Concat7(A1, A2, A3, A4, A5, A6, A7: ArrayType; I1, I2, I3, I4~~
, I5, I6, I7, J: IndexType )
Title: Concat7
Description: Concatenates seven arrays, A1, ..., A7. I1, ..., I7 are ~~
the indexes joined; J is the index of the new array; J usually is the~~
concatenation of I1, ..., I7.
Definition: Index I12 := Concat(I1,I2);~
Index I123:= Concat(I12, I3);~
Index I1234 := Concat(I123, I4);~
Index I12345 := Concat(I1234, I5);~
Index I123456 := Concat(I12345, I6);~
Concat(~
Concat(~
Concat(~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, I1234),~
A5, I1234, I5, I12345),~
A6, I12345, I6, I123456),~
A7, I123456, I7, J);
Nodelocation: 88,176,1
Nodesize: 48,24
Windstate: 2,580,98,551,565
Paramnames: A1,A2,A3,A4,A5,A6,A7,I1,I2,I3,I4,I5,I6,I7,J
Function Concat8(A1, A2, A3, A4, A5, A6, A7, A8: ArrayType; I1, I2, I3~~
, I4, I5, I6, I7, I8, J: IndexType )
Title: Concat8
Description: Concatenates eight arrays, A1, ..., A8. I1, ..., I8 are ~~
the indexes joined; J is the index of the new array; J usually is the~~
concatenation of I1, ..., I8.
Definition: Index I12 := Concat(I1,I2);~
Index I123:= Concat(I12, I3);~
Index I1234 := Concat(I123, I4);~
Index I12345 := Concat(I1234, I5);~
Index I123456 := Concat(I12345, I6);~
Index I1234567 := Concat(I123456, I7);~
Concat(~
Concat(~
Concat(~
Concat(~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, I1234),~
A5, I1234, I5, I12345),~
A6, I12345, I6, I123456),~
A7, I123456, I7, I1234567),~
A8, I1234567, I8, J);
Nodelocation: 192,176,1
Nodesize: 48,24
Windstate: 2,12,98,561,737
Paramnames: A1,A2,A3,A4,A5,A6,A7,A8,I1,I2,I3,I4,I5,I6,I7,I8,J
Att__cloakdefn: 0
Function Concat10(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10: ArrayType; ~~
I1, I2, I3, I4, I5, I6, I7, I8, I9, I10, J: IndexType)
Title: Concat10
Description: Concatenates ten arrays, A1, ..., A10. I1, ..., I10 are ~~
the indexes joined; J is the index of the new array; J usually is the~~
concatenation of I1, ..., I10.
Definition: Index I12 := Concat(I1,I2);~
Index I123 := Concat(I12, I3);~
Index I1234 := Concat(I123, I4);~
Index I12345 := Concat(I1234, I5);~
Index I123456 := Concat(I12345, I6);~
Index I1234567 := Concat(I123456, I7);~
Index I12345678 := Concat(I1234567, I8);~
Index I123456789 := Concat(I12345678, I9);~
Concat(~
Concat(~
Concat(~
Concat(~
Concat(~
Concat( ~
Concat(~
Concat(~
Concat( A1,A2,I1,I2,I12 ), ~
A3, I12, I3, I123), ~
A4, I123, I4, I1234),~
A5, I1234, I5, I12345),~
A6, I12345, I6, I123456),~
A7, I123456, I7, I1234567),~
A8, I1234567, I8, I12345678),~
A9, I12345678, I9, I123456789),~
A10, I123456789, I10, J);
Nodelocation: 192,232,1
Nodesize: 48,24
Windstate: 2,542,93,632,744
Paramnames: A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,I1,I2,I3,I4,I5,I6,I7,I8,I9,~~
I10,J
Att__cloakdefn: 0
Function Concatrows(A : ArrayType ; RowIndex,ColIndex,ResultIndex : In~~
dexType)
Title: ConcatRows (A,I,J,K)
Description: Takes an array, A indexed by RowIndex & ColIndex, and con~~
catenates each row, henceforth flattening the array by one dimension.~~
The result is indexed by ResultIndex, which must be an index with si~~
ze(RowIndex) * size(ColIndex) elements.
Definition: index L := [ identifier of RowIndex, identifier of ColInde~~
x, "val"];~
slice(Mdarraytotable(A,ResultIndex,L),L,3)
Nodelocation: 320,64,1
Nodesize: 64,24
Windstate: 2,499,85,478,348
Paramnames: A,RowIndex,ColIndex,ResultIndex
Close Concatenation_udfs
Library Odbc_library
Title: ODBC Library
Author: Lonnie
Date: Thu, Sep 11, 1997 2:15 PM
Saveauthor: Lonnie
Savedate: Tue, Feb 05, 2008 10:03 AM
Defaultsize: 48,24
Nodelocation: 440,128,1
Nodesize: 52,20
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Diagstate: 1,20,272,499,462,17
Fontstyle: Arial, 13
Function Insertrecsql(A:ArrayType;I:IndexType;L:IndexType;row:IndexTyp~~
e;dbTableName)
Title: InsertRecSql
Description: Generates the SQL "INSERT INTO" statement for one line of~~
table A. A is a 2-D table indexed by rows I and columns L. L's dom~~
ain serves as the column names in the database table. dbTableName is~~
the name of the table in the database. The result begins with two s~~
emi-colons, since it will be used with an SQL statement preceeding it~~
.~
~
29.8.2008 Jouni Tuomisto~
I added the parameter IGNORE because it ignores rows that would cause~~
duplicate-key violations. This way, there is no need to check for e.~~
g. existing locations of new indices.~
~
6.1.2009 Jouni Tuomisto~
I changed the A[I=row] to A[@I=@row] because the original function do~~
es not work correctly, if there are non-unique rows in the index.
Definition: (';;INSERT IGNORE INTO ' & dbTableName & '(' & JoinText(L,~~
L,',') & ') VALUES (' & Vallist(A[@I=@row],L)) & ') '
Nodelocation: 184,32,1
Nodesize: 52,24
Windstate: 2,591,203,487,469
Paramnames: A,I,L,row,dbTableName
Function Vallist(V:ArrayType;I:IndexType)
Title: ValList
Description: Takes a list of values, and returns a string which the co~~
ncatenation of each value, separated by commas, and with each value q~~
uoted.
Definition: JoinText( '''' & V & '''', I, ',')
Nodelocation: 72,32,0
Nodesize: 52,24
Windstate: 2,642,360,476,224
Paramnames: V,I
Numberformat: 1,F,4,14,0,0
Function Writetablesql(Tabl:ArrayType;RowIndex:IndexType;LabelIndex:In~~
dexType;dbTableName)
Title: WriteTableSql(Table,Rows,Labels,dbTableName)
Description: Returns the SQL that will write the table to the database~~
table.~
This can be used as the second argument to DBWrite.~
This SQL statement replaces the entire contents of an existing table ~~
with the new data.
Definition: 'DELETE FROM '& Dbtablename & JoinText(Insertrecsql(Tabl, ~~
Rowindex, Labelindex, Rowindex, Dbtablename),RowIndex)
Nodelocation: 328,32,1
Nodesize: 88,24
Windstate: 2,728,341,510,476
Paramnames: Tabl,RowIndex,LabelIndex,dbTableName
Function Appendtablesql(Tabl:ArrayType;RowIndex:IndexType;LabelIndex:~~
IndexType;dbTableName)
Title: AppendTableSql(Table,Rows,Labels,dbTableName)
Description: Returns the SQL that will write the table to the database~~
table.~
This can be used as the second argument to DBWrite.~
This SQL statement replaces the entire contents of an existing table ~~
with the new data.
Definition: JoinText(Insertrecsql(Tabl, Rowindex, Labelindex, Rowindex~~
, Dbtablename),RowIndex)
Nodelocation: 328,88,1
Nodesize: 88,24
Windstate: 2,559,127,510,476
Paramnames: Tabl,RowIndex,LabelIndex,dbTableName
Displayoutputs: []
Close Odbc_library
Variable Write_loc
Title: Write Loc
Description: Makes a table to be written to the Loc table.
Definition: index j:= ['id','Obj_id_i','Location','Description'];~
Locations2[.j=j]
Nodelocation: 320,200,1
Nodesize: 48,16
Windstate: 2,711,325,476,224
Valuestate: 2,513,49,515,278,0,MIDM
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,D,4,2,0,0,4,0,$,0,"ABBREV",0
Att__tableprintscali: 100,1,1,1,1,9,2970,2100,15,0
{!40000|Att_previndexvalue: []}
Function Card(table:texttype)
Title: Card
Description: Brings the largest id number from the table defined in th~~
e parameter.
Definition: index i:= DBquery(odbc,'~
SELECT MAX(id) AS id ~
FROM '&table&'~
');~
index j:= dblabels(i);~
max(max(DBTable(i, j ),i),j)
Nodelocation: 440,72,1
Nodesize: 48,12
Windstate: 2,102,90,476,331
Nodecolor: 39325,65535,39321
Paramnames: table
Index Table1
Title: Tables
Description: List of such tables in Opasnet Base that are being writte~~
n to by this module.
Definition: ['Obj','Res','Loc','Locres','Sett','Item','Sam']
Nodelocation: 200,64,1
Nodesize: 48,13
Valuestate: 2,15,594,158,227,0,MIDM
{!40000|Att_previndexvalue: ['Obj','Res','Loc','Locres','Sett','Item',~~
'Sam']}
Variable Cardinals
Title: Cardinals
Description: The largest id values for the selected Opasnet Base table~~
s. The table is updated by pressing the R_cardinals button.
Definition: Table(Table1)(~
183,2075,688,3208,44,131,873.378K~
)
Nodelocation: 200,32,1
Nodesize: 48,24
Windstate: 2,634,394,476,332
Defnstate: 2,193,270,416,303,0,MIDM
Valuestate: 2,472,313,416,303,0,MIDM
Nodecolor: 39325,65535,39321
Numberformat: 2,I,4,2,0,0,4,0,$,0,"ABBREV",0
Variable Inp_locres
Title: Inp locres
Description: Makes a list of all locations in all results in all varia~~
bles. The list is as long as is needed for the Locres table. A subset~~
is taken then for the Res table.~
1) Initialises local variables, and slices variables from Object1.~
2)-4) Does the process for each variable one at a time. ~
2) Only the deterministic information about variables are considered ~~
(therefore mean). Makes a 2D table of the locres info.~
3) Makes a table with fields required by the Locres and Res tables.~
4) Reduces one dimension by expanding the length from the length of R~~
es to that of Locres.~
5) Makes i the row index.
Definition: var output=0;~
var e:= Cardinals[table1='Res'];~
var f:= Cardinals[table1='Locres'];~
var o:= if Objects1[.j='Typ_id'] = 1 or Objects1[.j='Typ_id'] = 10 th~~
en 1 else 0;~
index j:= ['id', 'Location', 'Res_id', 'Loc_id', 'Vident', 'Obj_id_v'~~
, 'Obj_id_r', 'Mean', 'N'];~
index k:= subset(o);~
o:= objects1[Object_all=k];~
~
var x:= 1;~
while x<= size(k) do (~
var c:= slice(o,k,x);~
var a:= mean(sample(evaluate(c[.j='identifier'])));~
index h:= indexnames(a);~
index L:= concat(h,['Value']);~
index res_id:= (1..size(a))+e;~
index locres_id= (1..size(a)*size(h))+f;~
e:= e+size(res_id);~
f:= f+size(locres_id);~
a:= mdarraytotable(a,res_id,L);~
var mean1:= a[L='Value'];~
a:= a[L=h]&'';~
var g:= if Loc.j='Obj_id_i' then Loc&'+'&Loc[.j='Location'] else Loc;~~
~
var p:= h;~
~
a:= array(j,[~
locres_id,~
a, ~
res_id, ~
findid(findid((Ident of p), Obj, 'Ident')&'+'&a, g, 'Obj_id_i'),~
c[.j='Ident'],~
findid(c[.j='Ident'], Obj, 'Ident'), ~
findid(objects1[.j='Ident', Object_all='Run'], Obj, 'Ident'),~
mean1, ~
if c[.j='Probabilistic?']=0 then 0 else samplesize]);~
~
a:= concatrows(a,h,res_id,locres_id);~
output:= if x= 1 then a else for y:= j do (~
concat(output[j=y],a[j=y]) );~
x:= x+1);~
~
index i:= 1..size(output)/size(j);~
for y:= j do (slice(output[j=y],i))
Nodelocation: 200,248,1
Nodesize: 48,16
Windstate: 2,70,16,526,801
Valuestate: 2,34,59,777,552,0,MIDM
Aliases: Formnode Inp_locres1
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,I,4,2,0,0,4,0,$,0,"ABBREV",0
Att__totalsindex: []
{!40000|Att_previndexvalue: [Undefined]}
{!40000|Att_resultslicestate: [Sys_localindex('H'),1,Sys_localindex('R~~
ES_ID'),1,Sys_localindex('LOCRES_ID'),1,Sys_localindex('J'),1]}
Function Findid(in, table; cond:texttype)
Title: Findid
Description: This function gets an id from a table. ~
in: the property for which the id is needed. In MUST be unique in con~~
d.~
table: the table from where the id is brought. The table MUST have .j~~
as the column index, .i as the row index, and a column named 'id'.~
cond: the name of the field that is compared with in. Cond must be te~~
xt.
Definition: var id:= if (in&' ') = (table[.j=cond]&' ') then table[.j=~~
'id'] else 0;~
sum(id, table.i)&''
Nodelocation: 440,48,1
Nodesize: 48,12
Windstate: 2,636,101,494,398
Paramnames: in,table,cond
Variable Write_locres
Title: Write Locres
Description: Slices fields that are needed in the Locres table from I~~
np_locres.
Definition: index j:= ['id','Res_id','Loc_id'];~
inp_locres[.j=j]
Nodelocation: 320,248,1
Nodesize: 52,16
Windstate: 2,790,83,476,224
Valuestate: 2,632,155,416,303,0,MIDM
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
{!40000|Att_previndexvalue: []}
Variable Write_res
Title: Write Res
Description: Slices the fields that are needed in the Res table. Remo~~
ves duplicate rows.
Definition: index j:= ['id','Obj_id_v','Obj_id_r','Mean','N'];~
var a:= inp_locres[.j=j];~
a:= if j='id' then inp_locres[.j='Res_id'] else a;~
index i:= unique(a,a.i);~
a[.i=i]
Nodelocation: 320,280,1
Nodesize: 48,16
Windstate: 2,807,62,476,224
Valuestate: 2,723,178,416,303,0,MIDM
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
{!40000|Att_previndexvalue: []}
Variable Wikis
Title: Wikis
Description: Names of different wikis used.
Definition: Table(Self)(~
'Op_en','Op_fi','Heande','En','Fi','Erac','Beneris','Intarese','Piltt~~
i','Kantiva','Bioher','Heimtsa')
Indexvals: [1,2,3,4,5,8,9,10,11,13,14,15]
Nodelocation: 56,64,1
Nodesize: 48,12
Nodecolor: 65535,52427,65534
Reformdef: [Object2,Self]
Variable Object_types
Title: Object types
Description: Types of different objects that may exist in Analytica or~~
Opasnet Base. Types that have the same number are treated equally in~~
these systems.
Definition: Table(Self)(~
'Variable','Dimension','Method','Model','Class','Index','Nugget','Enc~~
yclopedia article','Run','Chance','Decision','Objective','Constant','~~
Determ','Module','Library','Form')
Indexvals: [1,2,3,4,5,6,7,8,9,1,10,1,1,1,4,4,4]
Nodelocation: 56,32,1
Nodesize: 48,20
Defnstate: 2,674,34,416,606,0,MIDM
Valuestate: 2,193,235,416,390,0,MIDM
Nodecolor: 65535,52427,65534
Variable Write_sett
Title: Write Sett
Description: Makes a list of sets for the Sett table. There are three ~~
major kinds of sets: Indices belonging to an assessment, variables be~~
longing to an assessment, and variables belonging to a run. Indices b~~
elonging to a dimension are NOT created with this node.
Definition: index i:= ['Assessment','Assessment','Run'];~
index j:= ['id','Obj_id','Sty_id'];~
array(j,[~
(Cardinals[table1='Sett']+@i)&'',~
findid(Objects1[Object_all=i, .j='Ident'], Obj, 'Ident'),~
array(i,[3,4,9])])
Nodelocation: 320,64,1
Nodesize: 48,16
Windstate: 2,740,132,495,444
Valuestate: 2,661,16,416,340,0,MIDM
Aliases: Formnode Write_sett1
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,D,4,2,0,0,4,0,$,0,"ABBREV",0
Att__tableprintscali: 100,1,1,1,1,9,2970,2100,15,0
{!40000|Att_previndexvalue: []}
Variable Write_obj
Title: Write Obj
Description: Selects relevant information for the Obj table from Objec~~
ts1 node.
Definition: index j:= ['id','Ident','Name','Unit','Typ_id','Page','Wik~~
_id'];~
index i:= 1..size(Object_all);~
Objects1[.j=j, @Object_all=@i]
Nodelocation: 320,32,1
Nodesize: 48,16
Valuestate: 2,289,70,909,492,0,MIDM
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,D,4,2,0,0,4,0,$,0,"ABBREV",0
Att__totalsindex: []
{!40000|Att_previndexvalue: []}
Variable Write_item
Title: Write Item
Description: Makes a list of items of sets into the Item table. This n~~
ode does NOT handle indices of a dimensions, but they must be describ~~
ed elsewhere. For types of sets, see Write_sett.
Definition: index j:= ['id','Sett_id','Obj_id','Fail'];~
index k:= types(1);~
index L:= types(6);~
var c:= if sett.j='Obj_id' then sett&'+'&sett[.j='Sty_id'] else sett;~~
~
c:= findid(write_sett[.j='Obj_id']&'+'&write_sett[.j='Sty_id'], c, 'O~~
bj_id');~
var a:= array(j,k, [0, slice(c,1), k, 0]);~
var b:= array(j,L,[0, slice(c,2), L, 0]);~
index m:= 1..(size(k)+size(L));~
a:= concat(a,b,k,l,m);~
b:= array(j,k, [0, slice(c,3), k, 0]);~
index i:= 1..(size(m)+size(k));~
a:= concat(a,b,m,k,i);~
if j='id' then cardinals[table1='Item']+@i else a;~
Nodelocation: 320,104,1
Nodesize: 48,16
Windstate: 2,80,84,476,473
Valuestate: 2,921,13,345,638,0,MIDM
Aliases: Formnode Write_item2
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,D,4,2,0,0,4,0,$,0,"ABBREV",0
Att__tableprintscali: 100,1,1,1,1,9,2970,2100,15,0
{!40000|Att_previndexvalue: []}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('J'),1,Sys_locali~~
ndex('K'),1]}
Variable Write_descr
Title: Write Descr
Description: If the result is not a number, then the actual result tex~~
t can be written into the Description field of the Descr table. Makes~~
a list of text values to be written into the Descr table.
Definition: index j:= ['id','Description'];~
index i:= subset(sample1[.j='Description']);~
sample1[.j=j, .i=i]
Nodelocation: 320,320,1
Nodesize: 48,16
Windstate: 2,674,46,476,224
Valuestate: 2,670,328,416,303,0,MIDM
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,I,4,2,0,0,4,0,$,0,"ABBREV",0
{!40000|Att_previndexvalue: []}
Variable Write_inf
Title: Write Inf
Description: Makes a list of objects that contains some additional inf~~
ormation to be written into the Inf table.
Definition: index j:= ['id','Begin','End','Who','Url'];~
var a:= Objects1;~
var b:= findid(a[.j='Ident'], Obj, 'Ident');~
a:= a[.j=j];~
a:= if a = null or j='id' or a='' then 0 else a;~
a:= if sum(a,j) = 0 then 0 else 1;~
index i:= subset(a);~
a:= Objects1[Object_all=i, .j=j];~
a:= if j='id' then b[Object_all=i] else a;~
if a=null or a=0 then '' else a
Nodelocation: 320,136,1
Nodesize: 48,16
Windstate: 2,94,102,476,340
Valuestate: 2,55,45,483,478,0,MIDM
Aliases: Formnode Write_inf1
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,D,4,2,0,0,4,0,$,0,"ABBREV",0
{!40000|Att_previndexvalue: []}
Function Types(type)
Title: Types
Description: Finds the objects that are of the object type "type" (the~~
only parameter of this function). Based on the information in Object~~
s1.
Definition: var a:= if Objects1[.j='Typ_id']=type then 1 else 0;~
Objects1[Object_all=subset(a),.j='id']
Nodelocation: 440,24,1
Nodesize: 48,12
Windstate: 2,551,191,476,344
Paramnames: type
Variable Run_info
Title: Run info
Description: Additional information about the run and the assessment.
Definition: Table(Self,Info)(~
'Op_en2778','WHO mortality data','Jouni','2009-2-3',~
'Op_eni2695','Testrun 2','Jouni',0~
)
Indexvals: ['Assessment','Run']
Nodelocation: 56,104,1
Nodesize: 48,13
Windstate: 2,576,173,476,392
Defnstate: 2,339,445,416,303,0,MIDM
Valuestate: 2,664,117,416,303,0,MIDM
Aliases: Formnode Run_info1
Nodecolor: 52425,39321,65535
Reformdef: [Self,Info]
Reformval: [Self,Info]
Ident: Op_en2694
Variable Objects1
Title: Objects
Description: Makes a table about object information.~
1) Finds information for other parameters based on objects.~
2) Adds info from nodes Run_info, Probabilistic_, and Index_info.~
3) Makes the final adjustements based on information described above.~~
~
~
There is no need to search for existing objects, because the Ident is~~
unique. Thus, all attempts of duplicate additions just are ignored.~
Null values are ignored in the write procedure. This causes mistmatch~~
between column and values. Therefore, null is replaced by ''.
Definition: var a:= Object_all;~
var d:= findintext(Object_types,Class of a);~
d:= sum(if d=0 then 0 else indexvalue(object_types),object_types);~
var f:= {findid(Object4,Obj,'Ident');~
f:= if f>0 then f else} Cardinals[table1='Obj']+@Object_all;~
Index j:= ['identifier', 'id','Ident','Name','Unit','Typ_id','Page','~~
Wik_id', 'Who','Begin','Url','Probabilistic?','Description node'];~
a:= array(j,[~
Object_all,~
f,~
Ident of a,~
Title of a,~
Units of a,~
if Object_all = 'Run' then 9 else d,~
'', '', '', '', 0, 0, 0]);~
~
var b:= if j='Probabilistic?' then probabilistic_[objects_excl_indice~~
s=Object_all] else null;~
a:= if b=null then a else b;~
b:= index_info[Add_info=j, Indices=Object_all];~
a:= if b=null then a else b;~
b:= run_info[info=j, run_info=Object_all];~
b:= if j= 'Begin' and Object_all='Run' and b=0 then datepart(today(),~~
'Y')&'-'&datepart(today(),'M')&'-'&datepart(today(),'D') else b;~
a:= if b=null then a else b;~
b:= if Object_all ='Run' and j='Name' then a&': Analytica '&Analytica~~
edition&', ('&Analyticaplatform&'), Version: '&Analyticaversion&', Sa~~
mplesize: '&samplesize else null;~
a:= if b=null then a else b;~
~
b:= findintext(wikis,a[j='Ident']);~
b:= if b=0 then 0 else b+textlength(Wikis);~
var c:= sum(if b=0 then 0 else @wikis,wikis);~
b:= sum(b,wikis);~
b:= if b = 0 then 0 else selecttext(a[j='Ident'],b);~
a:= if j='Page' then b else a;~
a:= if j='Wik_id' then c else a~
if a = null then '' else a~
Nodelocation: 200,136,1
Nodesize: 48,16
Windstate: 2,21,24,581,722
Valuestate: 2,41,312,1217,247,0,MIDM
Aliases: Formnode Objects
Reformval: [Sys_localindex('J'),Object_all]
Numberformat: 2,I,4,2,0,0,4,0,$,0,"ABBREV",0
{!40000|Att_previndexvalue: ['','','','','','','','','','','','','',''~~
,'','','','','','','','','']}
{!40000|Att_resultslicestate: [Indices,6,Add_info,2,Object_all,1,Sys_l~~
ocalindex('IOBJ'),1]}
Index Indices
Title: Indices
Description: This makes a list of all indices (including decision node~~
s) that are used by the variables in Object1.
Definition: index a:= indexnames(evaluate(Objects_excl_indices));~
a:= if a='Object1' or a='Objects_excl_indices' then 0 else 1;~
subset(a)~
Nodelocation: 56,272,1
Nodesize: 48,13
Windstate: 2,102,90,476,464
Valuestate: 2,32,349,416,303,0,MIDM
Reformval: [Objects_excl_indices]
{!40000|Att_previndexvalue: ['Sex','Diagnosis1','Unit','Age_group','Co~~
untry1']}
Variable Index_info
Title: Index info
Description: Additional information for each index and decision node. ~~
Description node is the name of a node containing information about t~~
he locations of the index. It must be indexed by the index.
Definition: Table(Add_info,Indices)(~
0,'ICD-10',0,0,0~
)
Nodelocation: 56,216,1
Nodesize: 48,20
Windstate: 2,140,217,476,224
Defnstate: 2,605,351,664,303,0,MIDM
Valuestate: 2,506,220,684,303,0,MIDM
Aliases: Formnode Index_info1
Nodecolor: 52425,39321,65535
Reformdef: [Add_info,Indices]
Reformval: [Add_info,Indices]
Index Add_info
Title: Add info
Description: Additional pieces of information about indices. Currently~~
, the only piece is a description node.
Definition: ['Description node']
Nodelocation: 56,248,1
Nodesize: 48,12
{!40000|Att_previndexvalue: ['Description node']}
Variable Probabilistic_
Title: Probabilistic?
Description: Contains 1 for all variables that are stored as samples f~~
rom probability distributions, and 0 for deterministic variables.
Definition: Table(Objects_excl_indices)(~
0)
Nodelocation: 56,168,1
Nodesize: 48,22
Defnstate: 2,197,26,416,371,0,MIDM
Valuestate: 2,17,23,416,364,0,MIDM
Aliases: Formnode Probabilistic_1
Nodecolor: 52425,39321,65535
Index Info
Title: Info
Definition: ['Ident','Name','Who','Begin']
Nodelocation: 56,128,1
Nodesize: 48,12
{!40000|Att_previndexvalue: ['Ident','Name','Who','Begin']}
Index Object_all
Title: Object all
Description: List of variables, indices, assessment, and run to be sto~~
red into the Opasnet Base.
Definition: concat(concat(objects_excl_indices,Indices),indexvalue(Run~~
_info))&''
Nodelocation: 200,160,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,49,109,558,527
Valuestate: 2,200,210,773,264,0,MIDM
Reformval: [Self,Info]
{!40000|Att_previndexvalue: ['H1898','H1899','H1900','H1901','H1902','~~
H1903','H1904','H1905','H1906','H1907','H1908','H1909','H1910','H191~~
1','H1912','Pollutant1','Salmon1','H1899','Cause_of_death3','H1898']}~~
Variable Sample1
Title: Sample
Description: The usage of local variables: a: the temporary variable t~~
hat is being edited. e: cardinal of the Res table. f: cardinal of the~~
Sam table. j: output column headings. i: output row numbers. ~
1) Several local variables are initiated. Variables and Decisions are~~
included.~
2)-5) The process is done for each variable one at a time (this is in~~
dexed by x). ~
3) Several within-loop local variables are initiated.~
4) The variable is given index runn which is equal to run if probabil~~
istic and [0] if not. The array is flattened first to 2-D, the value ~~
only is kept. ~
5) Variables are concatenated to each other.~
6) Index i is made the index of the implicit index.~
~
NOTE! This node MUST be formatted to Integer, otherwise Sam_id will b~~
e stored in a wrong format.
Definition: var output=0;~
var e:= Cardinals[table1='Res'];~
var f:= Cardinals[table1='Sam'];~
index j:= ['id','Res_id','Sample','Result','Description'];~
var o:= if Objects1[.j='Typ_id'] = 1 or Objects1[.j='Typ_id'] = 10 th~~
en 1 else 0;~
index k:= subset(o);~
o:= objects1[Object_all=k];~
~
var x:= 1;~
while x<= size(k) do (~
var c:= slice(o,k,x);~
var a:= c[.j='identifier'];~
a:= sample(evaluate(a));~
~
index h:= indexnames(max(a,run));~
index L:= concat(h,['Value']);~
index runn:= if c[.j='Probabilistic?']=1 then copyindex(run) else [0]~~
;~
index res_id:= (1..size(max(a,run)))+e;~
index sam_id:= (1..size(res_id)*size(runn))+f;~
e:= e+size(res_id);~
f:= f+size(sam_id);~
~
a:= if c[.j='Probabilistic?']=1 then a[run=runn] else (if runn=0 then~~
a else a);~
a:= mdarraytotable(a,res_id,L)[.L='Value'];~
a:= array(j,[0, res_id&'', runn&'', (if istext(a) then 0 else a) , (i~~
f istext(a) then a else 0)]);~
a:= concatrows(a,res_id,runn,sam_id);~
a:= if j='id' then sam_id&'' else a;~
~
output:= if x= 1 then a else for y:= j do (~
concat(output[j=y],a[j=y]) );~
x:= x+1);~
~
index i:= 1..size(output)/size(j);~
for y:= j do (slice(output[j=y],i))
Nodelocation: 200,320,1
Nodesize: 48,16
Windstate: 2,19,11,585,772
Valuestate: 2,133,242,753,337,0,MIDM
Aliases: Formnode Sample2
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,I,4,2,0,0,4,0,$,0,"ABBREV",0
Variable Locations2
Title: Locations
Description: Makes a list of all locations of all indices used in vari~~
ables listed in Object1.~
1) Initialises local variables. ~
2) Takes one index at a time, calculates the values and concatenates ~~
them to the previous values. ~
3) All parameters are lumped into a single array, with some fields ca~~
lculated based on others.
Definition: var a:= if objects1[.j='Typ_id']= 6 or objects1[.j='Typ_id~~
']= 10 then 1 else 0;~
index k:= subset(a);~
a:= objects1[Object_all=k];~
var b:= [0];~
var c:= [0];~
var e:= [0];~
var f:= [0];~
~
var x:= 1;~
while x<=size(k) do (~
var d:= evaluate(slice(k,x));~
b:= concat(b,d);~
c:= concat(c,(if d=0 then slice(k,x) else slice(k,x)));~
e:= concat(e,1..size(d));~
var g:= evaluate(a[@k=x, .j='Description node']);~
g:= {if size(g) = size(d) then g else} (if d=0 then g else g);~
f:= concat(f, g);~
x:= x+1);~
~
index i:= 1..size(b)-1;~
c:= slice(c,i+1);~
index j:= ['id','Obj_id_i', 'Ind_identifier', 'Location', 'Roww', 'De~~
scription'];~
array(j,[cardinals[table1='Loc']+i, findid(Ident of c,Obj,'Ident'), c~~
, slice(b,i+1)&'', slice(e,i+1), slice(f,i+1)])
Nodelocation: 200,200,1
Nodesize: 48,16
Windstate: 2,40,23,521,628
Valuestate: 2,521,153,727,401,0,MIDM
Aliases: Formnode Locations1
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
{!40000|Att_previndexvalue: ['','','','','','','','','','']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Variable W_sam
Title: W Sam
Definition: index j:= ['id','Res_id','Descr_id','Sample','Result'];~
var write_sam:= sample1[.j=j];~
write_sam:= if write_sam=null then '0' else write_sam;~
{dbwrite(odbc_write, appendtablesql(write_sam,write_sam.i, write_sam.~~
j,'Sam '))}
Nodelocation: 320,352,1
Nodesize: 48,12
Windstate: 2,102,90,476,333
Valuestate: 2,642,255,552,303,0,MIDM
Nodecolor: 65535,45873,39321
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Numberformat: 2,D,4,2,0,0,4,0,$,0,"ABBREV",0
Att__totalsindex: []
{!40000|Att_previndexvalue: []}
Function Write(var, table)
Title: Write
Definition: dbwrite(odbc_write, appendtablesql(var,var.i, var.j, table~~
&' '))
Nodelocation: 440,96,1
Nodesize: 48,12
Windstate: 2,687,61,476,224
Paramnames: var,table
Close Writing_code
Button R_others
Title: R others
Nodelocation: 384,280,1
Nodesize: 48,12
Windstate: 2,781,100,476,721
Script: D_i:= DBquery(odbc,'SELECT id, Ident, Name FROM Obj WHERE Typ_~~
id= 2 ')~
D_j:= DBlabels(D_i)~
(Dim1:= DBtable(D_i, D_j))~
(D_j:= copyindex(D_j))~
(D_i:= copyindex(D_i))~
~
It_i:= DBquery(odbc,' SELECT * FROM Item2 ')~
It_j:= DBlabels(It_i)~
(Item2:= DBTable(It_i, It_j ))~
(It_j:= copyindex(It_j))~
(It_i:= copyindex(It_i))~
~
Text Te2
Description: This module saves model results into the Opasnet Base. Yo~~
u need a password for that. Note that the necessary variable, index, ~~
dimension, and run information will be asked. You must fill in all ta~~
bles before the process is completed.
Nodelocation: 472,76,-1
Nodesize: 136,68
Text Te10
Description: Note! You can insert several variables at the same time. ~~
Each variable MUST have at least one index.
Nodelocation: 472,176,-1
Nodesize: 136,32
Text Te12
Title: Te11
Description: Fill in the data below in this order.
Nodelocation: 168,228,-5
Nodesize: 160,220
Nodeinfo: 1,0,0,1,0,1,0,,0,
Formnode Username1
Title: Username
Definition: 0
Nodelocation: 156,44,1
Nodesize: 140,12
Nodeinfo: 1,0,0,1,0,0,0,110,0,1
Nodecolor: 52425,39321,65535
Original: Username
Formnode Password1
Title: Password
Definition: 0
Nodelocation: 156,68,1
Nodesize: 140,12
Nodeinfo: 1,0,0,1,0,0,0,110,0,1
Nodecolor: 52425,39321,65535
Original: Password
Formnode Object2
Title: Object
Definition: 0
Nodelocation: 156,93,1
Nodesize: 140,13
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 52425,39321,65535
Original: Objects_excl_indices
Index Objects_excl_indices
Title: Objects excl indices
Definition: ['WHO_mortality_data']
Nodelocation: 496,240,1
Nodesize: 48,24
Windstate: 2,958,152,321,481
Valuestate: 2,328,338,416,361,0,MIDM
Aliases: Formnode Object2
Nodecolor: 52425,39321,65535
{!40000|Att_previndexvalue: ['WHO_mortality_data']}
Formnode Run_info1
Title: Run info
Definition: 0
Nodelocation: 156,164,1
Nodesize: 140,12
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 52425,39321,65535
Original: Run_info
Button Write_objects
Title: W Objects
Nodelocation: 224,236,4
Nodesize: 48,12
Script: Write(write_obj,'Obj')~
R_objects
Button R_cardinals
Title: R Cardinals
Nodelocation: 224,188,1
Nodesize: 48,12
Script: (Cardinals:= array(table1,[card('Obj'), card('Res'), card('Loc~~
'), card('Locres'), card('Sett'), card('Item'), card('Sam')]))
Button R_objects
Title: R Objects
Nodelocation: 384,232,1
Nodesize: 48,12
Script: O_i:= DBquery(odbc,'SELECT * FROM Obj ')~
O_j:= DBlabels(O_i)~
(Obj2:= DBTable(O_i, O_j))~
(O_j:= copyindex(O_j))~
(O_i:= copyindex(O_i))
Button R_structure
Title: R Structure
Nodelocation: 384,256,1
Nodesize: 48,12
Windstate: 2,102,90,473,465
Script: S_i:= DBquery(odbc,' SELECT * FROM Sett ')~
S_j:= DBlabels(S_i)~
(Sett1:= DBTable(S_i, S_j ))~
(S_i:= copyindex(S_i))~
(S_j:= copyindex(S_j))~
~
I_i:= DBquery(odbc,'SELECT Ind.id as id, Ind.Ident as Iident, Ind.Nam~~
e as Iname, Dim.id as Did, Dim.Ident as Dident, Dim.Name as Dname FRO~~
M Obj as Ind, Obj as Dim, Sett, Item2 WHERE Ind.id = Item2.Obj_id AND~~
Dim.id = Sett.Obj_id AND Item2.Sett_id=Sett.id AND Sett.Sty_id = 1 ~~
')~
I_j:= DBlabels(I_i)~
(Ind1:= DBtable(I_i, I_j))~
(I_j:= copyindex(I_j))~
(I_i:= copyindex(I_i))~
~
L_i:= DBquery(odbc,' SELECT Loc.*, Ind.* FROM Loc, Obj as Ind WHERE ~~
Loc.Obj_id_i = Ind.id ')~
L_j:= DBlabels(L_i)~
(Loc1:= DBtable(L_i, L_j))~
(L_j:= copyindex(L_j))~
(L_i:= copyindex(L_i))
Button Write_objects1
Title: W Structure
Nodelocation: 224,333,3
Nodesize: 48,13
Script: Write(write_inf,'Inf')~
Write(write_sett,'Sett')~
Write(write_loc,'Loc')~
R_structure
Button Write_objects2
Title: W others
Nodelocation: 224,429,1
Nodesize: 48,13
Script: Write(write_item,'Item2')~
Write(write_locres,'Locres')~
Write(write_res,'Res')~
Write(write_descr, 'Descr')
Text Te11
Description: Check all the nodes before running buttons (from top to b~~
ottom)!
Nodelocation: 60,274,-1
Nodesize: 44,74
Formnode Inp_locres1
Title: Inp locres
Definition: 1
Nodelocation: 200,381,1
Nodesize: 96,13
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Original: Inp_locres
Formnode Write_sett1
Title: Write Sett
Definition: 1
Nodelocation: 200,285,1
Nodesize: 96,13
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 65535,45873,39321
Original: Write_sett
Formnode Write_item2
Title: Write Item
Definition: 1
Nodelocation: 200,357,1
Nodesize: 96,13
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 65535,45873,39321
Original: Write_item
Formnode Write_inf1
Title: Write Inf
Definition: 1
Nodelocation: 200,261,1
Nodesize: 96,13
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 65535,45873,39321
Original: Write_inf
Formnode Objects
Title: Objects
Definition: 1
Nodelocation: 200,212,1
Nodesize: 96,12
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Original: Objects1
Formnode Sample2
Title: Sample
Definition: 1
Nodelocation: 200,404,1
Nodesize: 96,12
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Original: Sample1
Formnode Locations1
Title: Locations
Definition: 1
Nodelocation: 200,309,1
Nodesize: 96,13
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Original: Locations2
Module Dependency_graph
Title: Dependency graph
Author: ktluser
Date: 29. Decta 2008 21:51
Defaultsize: 48,24
Nodelocation: 496,352,1
Nodesize: 48,24
Diagstate: 1,279,39,902,527,17
Att__diagramprintsca: 92,1,1,0,2,9,2970,2100,15,0
Variable Cardinals__all_table
Title: Cardinals:~
all tables
Nodelocation: 192,56,1
Nodesize: 48,24
Nodecolor: 39325,65535,39321
Variable Objects__
Title: Objects:~
identifier~
id~
ident~
Name~
Unit~
Typ_id~
etc
Definition: Cardinals__all_table
Nodelocation: 320,120,1
Nodesize: 48,76
Variable Obj__id_ident_name_u
Title: Obj:~
id~
Ident~
Name~
Unit~
Typ_id~
etc
Definition: Objects__
Nodelocation: 192,184,1
Nodesize: 48,67
Nodecolor: 65535,45873,39321
Variable Sett__id_obj_id_typ_
Title: Sett:~
id~
Obj_id~
Typ_id
Definition: Obj__id_ident_name_u
Nodelocation: 192,328,1
Nodesize: 48,40
Nodecolor: 65535,45873,39321
Variable Item__
Title: Item:~
id~
Sett_id~
Obj_id~
Fail
Definition: Sett__id_obj_id_typ_
Nodelocation: 56,329,1
Nodesize: 48,49
Nodecolor: 65535,45873,39321
Variable Inf_
Title: Inf:~
id~
Begin~
End~
Who~
Url
Definition: Obj__id_ident_name_u
Nodelocation: 56,186,1
Nodesize: 48,58
Nodecolor: 65535,45873,39321
Variable Loc__id_obj_id_d_loc
Title: Loc:~
id~
Obj_id_d~
Location~
Description
Definition: Obj__id_ident_name_u
Nodelocation: 320,336,1
Nodesize: 48,52
Nodecolor: 65535,45873,39321
Variable Inp_locres__locres_i
Title: Inp_locres:~
Locres_id~
Location~
Res_id~
Roww_id~
Vident~
Obj_id_v~
Obj_id_r~
Mean~
N
Definition: Loc__id_obj_id_d_loc
Nodelocation: 456,336,1
Nodesize: 48,92
Variable Locres__
Title: Locres:~
id~
Res_id~
Roww_id
Definition: Inp_locres__locres_i
Nodelocation: 592,424,1
Nodesize: 48,40
Nodecolor: 65535,45873,39321
Variable Res__id_obj_id_v_obj
Title: Res:~
id~
Obj_id_v~
Obj_id_r~
Mean~
N
Definition: Inp_locres__locres_i
Nodelocation: 592,312,1
Nodesize: 48,58
Nodecolor: 65535,45873,39321
Variable Sam__id_res_id_descr
Title: Sam:~
id~
Res_id~
Sample~
Result
Definition: Sample__id_res_id_sa
Nodelocation: 592,120,1
Nodesize: 48,52
Nodecolor: 65535,45873,39321
Variable Descr__id_descr
Title: Descr:~
id~
Descr
Definition: Sample__id_res_id_sa
Nodelocation: 592,216,1
Nodesize: 48,31
Nodecolor: 65535,45873,39321
Text Te5
Description: The arrows only show sequential dependencies. This means ~~
that e.g. Cardinals is a parent to many other nodes as well, but the ~~
critical values in Cardinals only change before Objects is defined, a~~
nd there is no need to update Cardinals during the writing process.~
Orange nodes are actual Tables in Opasnet Base. Green nodes are SQL q~~
ueries from Opasnet Base. Blue nodes are computed in Analytica.
Nodelocation: 752,168,-1
Nodesize: 112,152
Variable Sample__id_res_id_sa
Title: Sample:~
id~
Res_id~
Sample~
Result~
Descr
Definition: Objects__
Nodelocation: 456,121,1
Nodesize: 48,58
Text Te6
Description: R Objects
Nodelocation: 192,176,-1
Nodesize: 56,80
Nodeinfo: 1,0,0,1,0,1,0,,0,
Text Te7
Description: R Structure
Nodelocation: 256,332,-1
Nodesize: 120,68
Nodeinfo: 1,0,0,1,0,1,0,,0,
Text Te9
Description: R Cardinals
Nodelocation: 192,48,-1
Nodesize: 56,40
Nodeinfo: 1,0,0,1,0,1,0,,0,
Close Dependency_graph
Formnode Index_info1
Title: Index info
Definition: 0
Nodelocation: 156,140,1
Nodesize: 140,12
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 52425,39321,65535
Original: Index_info
Formnode Probabilistic_1
Title: Probabilistic?
Definition: 0
Nodelocation: 156,116,1
Nodesize: 140,12
Nodeinfo: 1,0,0,1,0,0,0,72,0,1
Nodecolor: 52425,39321,65535
Original: Probabilistic_
Close Writer
Module Reader
Title: Reader
Author: ktluser
Date: 3. Augta 2008 18:31
Saveauthor: jtue
Savedate: 9. lokta 2008 14:01
Defaultsize: 48,24
Nodelocation: 192,32,1
Nodesize: 48,24
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Diagstate: 1,792,124,477,366,17
Fontstyle: Arial, 15
Function Read_mean(vident:text, runident:optional)
Title: Read mean
Description: Reads the mean data about the vident variable from the Op~~
asnet Base. Uses the runident run if specified; otherwise uses the ne~~
west run of that variable.~
~
PARAMETERS:~
* Vident: the Ident of the variable in the Opasnet Base.~
* Runident: the Ident of the run from which the results will be broug~~
ht. If omitted, the newest result will be brought.
Definition: if isnotspecified(runident) then runident:= identfind(newe~~
strun(vident));~
var a:= '~
SELECT Var.Ident as Vident, Var.Name as Vname, Var.Unit as Vunit, Res~~
.id, Ind.Ident as Iident, Location, Mean, N, Run.Name as Rname, Run.i~~
dent AS Runident~
FROM Obj as Var, Res, Locres, Loc, Obj as Ind, Obj as Run~
WHERE Res.Obj_id_r = Run.id~
AND Res.Obj_id_v = Var.id~
AND Locres.Res_id = Res.id~
AND Locres.Loc_id = Loc.id~
AND Loc.Obj_id_i = Ind.id~
AND Var.Ident = '&chr(39)&vident&chr(39)&'~
AND Run.ident = '&chr(39)&runident&chr(39)~
;~
index i:= DBquery(Odbc,a);~
index j:= dblabels(i);~
dbtable(i,j)
Nodelocation: 56,88,1
Nodesize: 48,12
Windstate: 2,585,25,516,589
Nodecolor: 39325,65535,39321
Paramnames: vident,runident
Function Newestrun(vident:text)
Title: Newestrun
Description: This function checks for the newest result (according to ~~
run_id) of the variable. The function is used if the user does not de~~
fine the run_id as an optional parameter in functions Read_mean and R~~
ead_sample.~
~
PARAMETERS:~
* Vident: the Ident of the variable in the Opasnet Base.
Definition: index i:= DBquery(Odbc,'~
SELECT Obj_id_r~
FROM Res, Obj as Var~
WHERE Var.id = Res.Obj_id_v~
AND Var.Ident = "'&vident&'"~
GROUP BY Var.id, Obj_id_r~
');~
index j:= dblabels(i);~
max(max(dbtable(i,j),i),j)
Nodelocation: 56,16,1
Nodesize: 48,12
Windstate: 2,678,59,476,566
Nodecolor: 39325,65535,39321
Paramnames: vident
Function Read_sample(vident:text, runident:optional)
Title: Read sample
Description: Reads the sample data about the vident variable from the ~~
Opasnet Base. Uses the runident run if specified; otherwise uses the ~~
newest run of that variable.~
~
PARAMETERS:~
* Vident: the name of the variable in the Opasnet Base.~
* Runident: the Ident of the run from which the results will be broug~~
ht. If omitted, the newest result will be brought.
Definition: if isnotspecified(runident) then runident:= identfind(newe~~
strun(vident));~
var a:= '~
SELECT Temp.id, Sample, Result, Description~
FROM~
(SELECT Res.id, Sam.id AS Sam_id, Sample, Result, Obj_id_r~
FROM Res, Sam, Obj AS Run, Obj AS Var~
WHERE Var.Ident = '&chr(39)&vident&chr(39)&'~
AND Res.Obj_id_v = Var.id~
AND Res.Obj_id_r = Run.id~
AND Run.Ident = '&chr(39)&Runident&chr(39)&'~
AND Sam.Res_id = Res.id) AS Temp~
LEFT JOIN Descr ON~
Temp.Sam_id = Descr.id~
';~
index i:= DBquery(Odbc,a);~
index j:= dblabels(i);~
dbtable(i,j)
Nodelocation: 56,120,1
Nodesize: 48,22
Windstate: 2,700,47,516,612
Nodecolor: 39325,65535,39321
Paramnames: vident,runident
Variable Enter_variable
Title: Enter variable Ident
Definition: 'Op_en1912'
Nodelocation: 168,88,1
Nodesize: 48,31
Aliases: Formnode Enter_variable1
Nodecolor: 52425,39321,65535
Formnode Enter_variable1
Title: Enter variable
Definition: 0
Nodelocation: 288,24,1
Nodesize: 176,13
Nodeinfo: 1,0,0,1,0,0,0,170,0,1
Nodecolor: 52425,39321,65535
Original: Enter_variable
Variable Newest_run
Title: Newest run
Definition: newestrun(Enter_variable)
Nodelocation: 288,64,1
Nodesize: 48,12
Variable Mean_results
Title: Var info
Definition: read_mean(Enter_variable)
Nodelocation: 288,112,1
Nodesize: 48,12
Valuestate: 2,56,66,1205,308,0,MIDM
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Function Makeind(a,inde)
Title: Makeind
Description: The input table a must have a structure that is also used~~
as input for MDTable function. The function removes one column with ~~
location information and makes a dimension (index) with the locations~~
in the column. Inde is the (local) index that will be added. Note th~~
at unlike MDTable function, this can use local indices in the output.~~
Definition: if size(a.m)= 1 then a else (~
a:= if inde = a[@.m=1] then a else 0;~
index m:= slice(a.m,(2..size(a.m)));~
a:= a[.m=m])
Nodelocation: 56,176,1
Nodesize: 48,12
Windstate: 2,283,62,476,224
Paramnames: a,inde
Function Get_res_id(a)
Title: Get res.id
Description: Makes a multi-dimensional array with the same structure a~~
s the original variable that was stored into the Opasnet Base. Howeve~~
r, the indices do not have original names. They are named In1, In2,..~~
. The contents of the array are the res.ids of the variable. The inpu~~
t parameter must be a 2D table with the structure that comes from the~~
Read_mean function.~
1) Slices the necessary columns from the input table and converts tha~~
t to a 2D table that has the same structure as is used for input to t~~
he function MDTable.~
2) Defines the local indices (up to 10), and changes a location colum~~
n to a dimension one at a time until all columns have been changed.
Definition: index k:= ['Iident','Location','id'];~
a:= a[.j=k];~
index L:= a[@k=1]&'+'&a[@k=3];~
index m:= concat(a[.i=unique(a[@k=1],a.i), @k=1],['Result']);~
index n:= a[.i=unique(a[@k=3],a.i), @k=3];~
a:= a[@.i=@L];~
a:= a[L=m&'+'&n, @k=2];~
a:= if m='Result' then n else a;~
~
index in1:= a[n=unique(a[@m=1],n),@m=1];~
index in2:= a[n=unique(a[@m=2],n),@m=2];~
index in3:= a[n=unique(a[@m=3],n),@m=3];~
index In4:= a[n=unique(a[@m=4],n),@m=4];~
index In5:= a[n=unique(a[@m=5],n),@m=5];~
index in6:= a[n=unique(a[@m=6],n),@m=6];~
index in7:= a[n=unique(a[@m=7],n),@m=7];~
index in8:= a[n=unique(a[@m=8],n),@m=8];~
index in9:= a[n=unique(a[@m=9],n),@m=9];~
index in10:= a[n=unique(a[@m=10],n),@m=10];~
a:= makeind(a, in1);~
a:= makeind(a, in2);~
a:= makeind(a, in3);~
a:= makeind(a, in4);~
a:= makeind(a, in5);~
a:= makeind(a, in6);~
a:= makeind(a, in7);~
a:= makeind(a, in8);~
a:= makeind(a, in9);~
a:= makeind(a, in10);~
sum(sum(a,a.m),a.n)
Nodelocation: 56,152,1
Nodesize: 48,12
Windstate: 2,669,44,476,545
Paramnames: a
Variable Var_mean1
Title: Var mean
Definition: get_mean(Enter_variable)
Nodelocation: 288,136,1
Nodesize: 48,12
Valuestate: 2,547,35,416,622,0,MIDM
Reformval: [Sys_localindex('IN2'),Sys_localindex('IN3')]
{!40000|Att_resultslicestate: [Sys_localindex('IN1'),1,Sys_localindex(~~
'IN4'),1,Sys_localindex('IN5'),1,Sys_localindex('IN3'),1,Sys_localind~~
ex('IN2'),1]}
Function Get_mean(vident:text, runident:optional)
Title: Get mean
Description: Gives the mean result of a (multidimensional) variable st~~
ored in the Opasnet Base. The procedure is simple because it utilises~~
the variable structure (with res_ids) derived by the get_res_id func~~
tion.
Definition: var a:= {testmean} read_mean(vident, runident);~
index o:= a[.j='id'];~
var output:= a[@.i=@o, .j='Mean'];~
a:= get_res_id(a);~
output[o=a]
Nodelocation: 56,200,1
Nodesize: 48,12
Windstate: 2,665,82,476,428
Paramnames: vident,runident
Function Get_sample(vident:text, runident:optional)
Title: Get sample
Description: Gives the sample result of a (multidimensional) variable ~~
stored in the Opasnet Base. The procedure is simple because it utilis~~
es the variable structure (with res_ids) derived by the get_res_id fu~~
nction.~
~
Note that if the Analytica samplesize is smaller than the samplesize ~~
stored in the Opasnet Base, the extra samples will be discarded. If t~~
he samplesize is larger, the remaining rows will be null.~
1) Brings the data into the right structure.~
2) Chooses whether the actual result is numerical (in the Result colu~~
mn) or text (in the Description column).
Definition: var a:= read_sample(vident, runident);~
var b:= get_res_id(read_mean(vident,runident));~
index k:= a[.j='id']&'+'&a[.j='Sample'];~
index runn:= min(a[.j='Sample'])..max(a[.j='Sample']);~
a:= a[@.i=@k];~
a:= a[k=b&'+'&runn];~
a:= if max(runn)=0 then a[@runn=1] else a[@runn=@run];~
~
var c:= if a[.j='Description']='' then 0 else 1;~
c:= sum(sum(sum(sum(sum(sum(sum(sum(sum(sum(c))))))))));~
if c=0 then a[.j='Result'] else a[.j='Description']
Nodelocation: 56,224,1
Nodesize: 48,12
Windstate: 2,641,28,476,556
Paramnames: vident,runident
Variable Var_sample1
Title: Var sample
Definition: get_sample(Enter_variable)
Nodelocation: 288,160,1
Nodesize: 48,12
Valuestate: 2,226,324,416,303,0,MEAN
Reformval: [Sys_localindex('IN5'),Sys_localindex('IN3')]
{!40000|Att_resultslicestate: [Sys_localindex('IN1'),1,Sys_localindex(~~
'IN2'),1,Sys_localindex('IN4'),1,Sys_localindex('IN3'),1,Sys_localind~~
ex('J'),1,Sys_localindex('IN5'),1]}
Function Identfind(runid)
Title: Identfind
Description: Finds the Ident for the run (or another object) that has~~
the id runid.
Definition: index i:= DBquery(Odbc,'~
SELECT ident~
FROM Obj~
WHERE Obj.id = "'&runid&'"~
');~
index j:= dblabels(i);~
var a:= dbtable(i,j);~
a[@i=1, @j=1]
Nodelocation: 56,64,1
Nodesize: 48,12
Windstate: 2,732,65,516,589
Nodecolor: 39325,65535,39321
Paramnames: runid
Variable Var_run_info1
Title: Var run info
Description: Describes the runs of the defined variable. This should ~~
be made a function.
Definition: var_run_info(Enter_variable)
Nodelocation: 288,88,1
Nodesize: 48,12
Valuestate: 2,136,146,1111,285,0,MIDM
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Function Var_run_info(vident:text)
Title: Var run info
Description: This function checks for the newest result (according to ~~
run_id) of the variable. The function is used if the user does not de~~
fine the run_id as an optional parameter in functions Read_mean and R~~
ead_sample.~
~
PARAMETERS:~
* Vident: the Ident of the variable in the Opasnet Base.
Definition: var a:= '~
SELECT Var.Ident, Var.Name, Var.Unit, Run.Ident AS Runident, Inf.Begi~~
n, Inf.Who, Run.Name as Method~
FROM Obj as Var, Obj as Run, Res, Inf ~
WHERE Var.Ident = '&chr(39)&vident&chr(39)&'~
AND Var.id = Res.Obj_id_v ~
AND Run.id = Res.Obj_id_r ~
AND Run.id = Inf.id ~
GROUP BY Var.id, Run.id~
';~
index i:= DBquery(Odbc,a);~
index j:= dblabels(i);~
dbtable(i,j)
Nodelocation: 56,40,1
Nodesize: 48,13
Windstate: 2,678,59,476,566
Nodecolor: 39325,65535,39321
Paramnames: vident
Close Reader
Text Te3
Description: Instructions for uploading results to the Opasnet Base:~
* Make sure that you have created an object page in the Opasnet wiki ~~
for each object you want to upload. (This applies also to assessments~~
and runs!)~
* Create a user-defined attribute Ident if it does not exist.~
* Use the wiki identifier as the Ident for the object in Analytica.~
* Use the wiki page name as the Title for the object.~
* Make sure that you have defined the Units.~
* If an object with the same Ident (Analytica identifier) already exi~~
sts, metadata about that object will NOT be updated. However, the act~~
ual results will be uploaded normally.
Nodelocation: 220,220,-1
Nodesize: 212,108
Module Details
Title: Details
Author: ktluser
Date: 8. Decta 2008 3:01
Defaultsize: 48,24
Nodelocation: 64,32,1
Nodesize: 48,24
Diagstate: 1,206,202,495,296,17
Variable Odbc_write
Title: ODBC write
Definition: 'Driver={MySQL ODBC 5.1 Driver};Server=10.66.10.102;Databa~~
se=resultdb;User='&username&'; Password='&password&';Option=3'
Nodelocation: 168,200,1
Nodesize: 48,12
Nodeinfo: 1,1,0,1,1,1,0,,0,
Windstate: 2,102,90,495,302
Valuestate: 2,168,178,833,303,0,MIDM
Displayoutputs: []
Variable Username
Definition: ''
Nodelocation: 168,152,0
Nodesize: 48,12
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Aliases: Formnode Username1
Nodecolor: 52425,39321,65535
Variable Password
Definition: ''
Nodelocation: 168,176,0
Nodesize: 48,12
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Aliases: Formnode Password1
Nodecolor: 52425,39321,65535
Variable Odbc
Title: ODBC
Description: Contains the parameters for the open database connectivit~~
y (ODBC).
Definition: 'Driver={MySQL ODBC 5.1 Driver};Server=10.66.10.102;Databa~~
se=resultdb;User=result_reader; Password=ora4ever;Option=3'
Nodelocation: 168,128,1
Nodesize: 48,12
Nodeinfo: 1,1,0,1,1,1,0,,0,
Windstate: 2,102,90,476,224
Variable Dim
Title: Dim
Definition: index i:= copyindex(D_i);~
index j:= copyindex(D_j);~
Dim1[d_i=i, d_j=j]
Nodelocation: 400,160,1
Nodesize: 48,13
Nodeinfo: 1,1,0,1,1,1,0,0,0,0
Windstate: 2,89,98,476,224
Valuestate: 2,635,328,556,489,0,MIDM
Nodecolor: 19661,54073,65535
Reformdef: [D_i,D_j]
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Variable Ind
Title: Ind
Definition: index i:= copyindex(I_i);~
index j:= copyindex(I_j);~
Ind1[I_i=i, I_j=j]
Nodelocation: 400,184,1
Nodesize: 48,13
Nodeinfo: 1,1,0,1,1,1,0,0,0,0
Windstate: 2,380,47,476,296
Valuestate: 2,490,110,649,655,0,MIDM
Nodecolor: 19661,54073,65535
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Variable Loc
Title: Loc
Definition: index i:= copyindex(L_i);~
index j:= copyindex(L_j);~
Loc1[L_i=i, L_j=j]
Nodelocation: 400,96,1
Nodesize: 48,13
Nodeinfo: 1,1,0,1,1,1,0,0,0,0
Windstate: 2,370,45,476,445
Valuestate: 2,43,42,1147,516,0,MIDM
Nodecolor: 19661,54073,65535
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
Variable Obj
Title: Obj
Description: This node checks the variables listed in Var_for_rdb and ~~
makes an index of those that are NOT found in the result database. Th~~
is is then used as an index in Inp_var for adding variable informatio~~
n.
Definition: index i:= copyindex(O_i);~
index j:= copyindex(O_j);~
Obj2[O_i=i, O_j=j]
Nodelocation: 400,48,1
Nodesize: 48,13
Nodeinfo: 1,1,0,1,1,1,0,0,0,0
Windstate: 2,378,21,493,501
Valuestate: 2,21,103,889,421,0,MIDM
Nodecolor: 19661,54073,65535
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
{!40000|Att_previndexvalue: ['H1991']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Text Te4
Description: Standard versions
Nodelocation: 400,112,-1
Nodesize: 72,100
Nodeinfo: 1,0,0,1,0,1,0,,0,
Index D_i
Title: D_i
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]~~
Nodelocation: 168,24,1
Nodesize: 48,12
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22]}
Index D_j
Title: D_j
Definition: ['id','Ident','Name']
Nodelocation: 168,48,1
Nodesize: 48,12
{!40000|Att_previndexvalue: ['id','Ident','Name']}
Index I_i
Title: I_i
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,~~
23,24,25,26,27,28,29,30,31,32,33,34]
Nodelocation: 168,72,1
Nodesize: 48,12
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34]}
Index I_j
Title: I_j
Definition: ['id','Iident','Iname','Did','Dident','Dname']
Nodelocation: 168,96,1
Nodesize: 48,12
{!40000|Att_previndexvalue: ['id','Iident','Iname','Did','Dident','Dna~~
me']}
Index L_i
Title: L_i
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,~~
23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,~~
46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,~~
69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,~~
92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,1~~
11,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,12~~
8,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145~~
,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,~~
163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,1~~
80,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,19~~
7,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214~~
,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,~~
232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,2~~
49,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,26~~
6,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283~~
,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,~~
301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,3~~
18,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,33~~
5,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352~~
,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,~~
370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,3~~
87,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,40~~
4,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421~~
,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,~~
439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,4~~
56,457,458,459,460,461,462,463,464,465,466]
Nodelocation: 56,120,1
Nodesize: 48,12
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40~~
,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63~~
,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86~~
,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,~~
107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124~~
,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,~~
142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159~~
,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,~~
177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194~~
,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211~~
,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,~~
229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246~~
,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,~~
264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281~~
,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298~~
,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,~~
316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333~~
,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,~~
351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368~~
,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,~~
386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,~~
403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420~~
,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,~~
438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455~~
,456,457,458,459,460,461,462,463,464,465,466]}
Index L_j
Title: L_j
Definition: ['id','Obj_id_i','Location','Roww','Locn','Num','Descripti~~
on','id','Ident','Name','Unit','Typ_id','Page','Wik_id']
Nodelocation: 56,144,1
Nodesize: 48,12
{!40000|Att_previndexvalue: ['id','Obj_id_i','Location','Roww','Locn',~~
'Num','Description','id','Ident','Name','Unit','Typ_id','Page','Wik_i~~
d']}
Index O_i
Title: O_i
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,~~
23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,~~
46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,~~
69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,~~
92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,1~~
11,112,113,114,115]
Nodelocation: 56,24,1
Nodesize: 48,13
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40~~
,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63~~
,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86~~
,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107~~
,108,109,110,111,112,113,114,115]}
Index O_j
Title: O_j
Definition: ['id','Ident','Name','Unit','Typ_id','Page','Wik_id']
Nodelocation: 56,48,1
Nodesize: 48,13
{!40000|Att_previndexvalue: ['id','Ident','Name','Unit','Typ_id','Page~~
','Wik_id']}
Variable Sett
Title: Sett
Description: This node checks the variables listed in Var_for_rdb and ~~
makes an index of those that are NOT found in the result database. Th~~
is is then used as an index in Inp_var for adding variable informatio~~
n.
Definition: index i:= copyindex(S_i);~
index j:= copyindex(S_j);~
Sett1[S_i=i, S_j=j]
Nodelocation: 400,72,1
Nodesize: 48,13
Nodeinfo: 1,1,0,1,1,1,0,0,0,0
Windstate: 2,378,21,493,501
Valuestate: 2,227,134,319,515,0,MIDM
Nodecolor: 19661,54073,65535
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
{!40000|Att_previndexvalue: ['H1991']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Variable Item
Title: Item
Description: This node checks the variables listed in Var_for_rdb and~~
makes an index of those that are NOT found in the result database. T~~
his is then used as an index in Inp_var for adding variable informati~~
on.
Definition: index i:= copyindex(It_i);~
index j:= copyindex(It_j);~
Item1[it_i=i, it_j=j]
Nodelocation: 400,120,1
Nodesize: 48,13
Nodeinfo: 1,1,0,1,1,1,0,0,0,0
Windstate: 2,378,21,493,501
Valuestate: 2,298,216,382,519,0,MIDM
Nodecolor: 19661,54073,65535
Reformval: [Sys_localindex('J'),Sys_localindex('I')]
{!40000|Att_previndexvalue: ['H1991']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Index It_i
Title: It_i
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,~~
23,24,25,26,27,28,29,30,31,32,33,34,35]
Nodelocation: 56,168,1
Nodesize: 48,13
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35]}
Index It_j
Title: It_j
Definition: ['id','Sett_id','Obj_id','Fail']
Nodelocation: 56,192,1
Nodesize: 48,13
{!40000|Att_previndexvalue: ['id','Sett_id','Obj_id','Fail']}
Index S_i
Title: S_i
Definition: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,~~
23,24,25]
Nodelocation: 56,72,1
Nodesize: 48,13
{!40000|Att_previndexvalue: [1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17~~
,18,19,20,21,22,23,24,25]}
Index S_j
Title: S_j
Definition: ['id','Obj_id','Sty_id']
Nodelocation: 56,96,1
Nodesize: 48,13
{!40000|Att_previndexvalue: ['id','Obj_id','Sty_id']}
Variable Dim1
Title: Dim
Definition: Table(D_i,D_j)(~
43,'Vehicle_type','Vehicle type',~
45,'Transport_mode','Transport mode',~
46,'Cost_type','Cost type',~
47,'Composite_fraction','Composite fraction',~
51,'Food_source','The method for food production',~
52,'Feed_pollutant','Decision about fish feed',~
53,'Salmon_recomm','Decision about samon consumption recommendation',~~
~
32,'0','No dimension has been identified',~
54,'Parameter','Statistical and other parameters of a variable',~
42,'Environ_compartment','Environmental compartment',~
41,'Emission_source','Emission source',~
36,'Pollutant','Pollutant',~
34,'Health_impact','Health impact',~
33,'Decision','Possible range of decisions for a single decision-make~~
r',~
35,'Time','Time',~
40,'Period','Period',~
48,'Age','Age',~
37,'Spatial_location','Spatial location',~
38,'Length','Length',~
49,'Municipality_fin','Municipalities in Finland',~
44,'Person_or_group','Person or group',~
39,'Non_health_impact','Non-health impact'~
)
Nodelocation: 280,160,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,89,98,476,224
Valuestate: 2,604,56,556,489,0,MIDM
Nodecolor: 39325,65535,39321
Reformdef: [D_i,D_j]
Reformval: [D_j,D_i]
Variable Ind1
Title: Ind
Definition: Table(I_i,I_j)(~
55,'Salmon_decision','',33,'Decision','Possible range of decisions fo~~
r a single decision-maker',~
80,'Reg_poll','',33,'Decision','Possible range of decisions for a sin~~
gle decision-maker',~
81,'Recommendation1','',33,'Decision','Possible range of decisions fo~~
r a single decision-maker',~
83,'H1899','',33,'Decision','Possible range of decisions for a single~~
decision-maker',~
84,'H1898','',33,'Decision','Possible range of decisions for a single~~
decision-maker',~
56,'Hma_area','',37,'Spatial_location','Spatial location',~
57,'Hma_region','',37,'Spatial_location','Spatial location',~
58,'Hma_zone','',37,'Spatial_location','Spatial location',~
88,'Condb_location1','',37,'Spatial_location','Spatial location',~
93,'Op_en2672','',37,'Spatial_location','Spatial location',~
59,'Year_1','',35,'Time','Time',~
61,'Year_2','',35,'Time','Time',~
82,'Year3','',35,'Time','Time',~
60,'Op_en2665','Cause of death 1',34,'Health_impact','Health impact',~~
~
62,'Cause_of_death_2','',34,'Health_impact','Health impact',~
85,'Cause_of_death3','',34,'Health_impact','Health impact',~
63,'Length_1','',38,'Length','Length',~
70,'Output_1','',39,'Non_health_impact','Non-health impact',~
65,'Period_1','',40,'Period','Period',~
86,'Run','',32,'0','No dimension has been identified',~
71,'Vehicle_noch','',43,'Vehicle_type','Vehicle type',~
92,'Vehicle_1','',43,'Vehicle_type','Vehicle type',~
72,'Stakeholder_1','',44,'Person_or_group','Person or group',~
73,'Mode1','',45,'Transport_mode','Transport mode',~
74,'Cost_structure_1','',46,'Cost_type','Cost type',~
75,'Comp_fr_1','',47,'Composite_fraction','Composite fraction',~
76,'Age1','',48,'Age','Age',~
77,'Municipality_fin1','',49,'Municipality_fin','Municipalities in Fi~~
nland',~
79,'Salmon1','',51,'Food_source','The method for food production',~
78,'Pollutant1','',36,'Pollutant','Pollutant',~
89,'Condb_agent1','',36,'Pollutant','Pollutant',~
91,'Condb_agent2','',36,'Pollutant','Pollutant',~
87,'Condb_compartment1','',42,'Environ_compartment','Environmental co~~
mpartment',~
90,'Condb_param1','',54,'Parameter','Statistical and other parameters~~
of a variable'~
)
Nodelocation: 280,184,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,380,47,476,296
Defnstate: 2,232,242,874,303,0,MIDM
Valuestate: 2,12,22,876,493,0,MIDM
Nodecolor: 39325,65535,39321
Reformdef: [I_j,I_i]
Reformval: [I_j,I_i]
Variable Loc1
Title: Loc
Definition: Table(L_i,L_j)(~
1,1,'Business as usual',0,0,0,'',1,'Op_en1901','Net health effects du~~
e to the consumption of salmon','avoided cases/a',1,1901,1,~
2,1,'Recommend restrictions to salmon consumption',0,0,0,'',2,'Op_en1~~
901','Net health effects due to the consumption of salmon','avoided c~~
ases/a',1,1901,1,~
3,1,'Stricter limits for fish feed pollutants',0,0,0,'',3,'Op_en1901'~~
,'Net health effects due to the consumption of salmon','avoided cases~~
/a',1,1901,1,~
4,1,'Restrictions to salmon consumption AND stricter fish feed limits~~
',0,0,0,'',4,'Op_en1901','Net health effects due to the consumption o~~
f salmon','avoided cases/a',1,1901,1,~
26,2,'All causes',0,0,0,'',26,'Op_en2693','Testvariable','kg',1,2693,~~
1,~
197,6,'>= 5 km',0,0,0,'',197,'Ppmconc_bustraffic','PM2.5 concentratio~~
n from bus traffic in Helsinki in 2020','ug/m3',1,0,0,~
196,6,'< 5 km',0,0,0,'',196,'Ppmconc_bustraffic','PM2.5 concentration~~
from bus traffic in Helsinki in 2020','ug/m3',1,0,0,~
8,3,'2020',0,0,0,'',8,'Op_en2201','The mortality due to PM 2.5 from b~~
uses','premature deaths',1,2201,1,~
7,3,'1997',0,0,0,'',7,'Op_en2201','The mortality due to PM 2.5 from b~~
uses','premature deaths',1,2201,1,~
10,2,'Cardiopulmonary',0,0,0,'',10,'Op_en2693','Testvariable','kg',1,~~
2693,1,~
11,2,'Lung cancer',0,0,0,'',11,'Op_en2693','Testvariable','kg',1,2693~~
,1,~
12,2,'All others',0,0,0,'',12,'Op_en2693','Testvariable','kg',1,2693,~~
1,~
27,5,'Downtown',0,0,0,'',27,'Op_en2204','Primary PM2.5 emissions from~~
bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
28,5,'Centre',0,0,0,'',28,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
29,5,'Suburb',0,0,0,'',29,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
30,5,'Länsi-Espoo',0,0,0,'',30,'Op_en2204','Primary PM2.5 emissions f~~
rom bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
31,5,'Pohjois-Espoo',0,0,0,'',31,'Op_en2204','Primary PM2.5 emissions~~
from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
32,5,'Etelä-Espoo',0,0,0,'',32,'Op_en2204','Primary PM2.5 emissions f~~
rom bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
33,5,'Keski-Espoo',0,0,0,'',33,'Op_en2204','Primary PM2.5 emissions f~~
rom bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
34,5,'Länsi-Vantaa',0,0,0,'',34,'Op_en2204','Primary PM2.5 emissions ~~
from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
35,5,'Keski-Vantaa',0,0,0,'',35,'Op_en2204','Primary PM2.5 emissions ~~
from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
36,5,'Pohjois-Vantaa',0,0,0,'',36,'Op_en2204','Primary PM2.5 emission~~
s from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
37,5,'Itä-Vantaa',0,0,0,'',37,'Op_en2204','Primary PM2.5 emissions fr~~
om bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
38,5,'Kanta-Helsinki',0,0,0,'',38,'Op_en2204','Primary PM2.5 emission~~
s from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
39,5,'Länsi-Helsinki',0,0,0,'',39,'Op_en2204','Primary PM2.5 emission~~
s from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
40,5,'Vanha-Helsinki',0,0,0,'',40,'Op_en2204','Primary PM2.5 emission~~
s from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
41,5,'Konalanseutu',0,0,0,'',41,'Op_en2204','Primary PM2.5 emissions ~~
from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
42,5,'Pakilanseutu',0,0,0,'',42,'Op_en2204','Primary PM2.5 emissions ~~
from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
43,5,'Malminseutu',0,0,0,'',43,'Op_en2204','Primary PM2.5 emissions f~~
rom bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
44,5,'Itä-Helsinki',0,0,0,'',44,'Op_en2204','Primary PM2.5 emissions ~~
from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
45,5,'1001',0,0,0,'',45,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
46,5,'1002',0,0,0,'',46,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
47,5,'1003',0,0,0,'',47,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
48,5,'1004',0,0,0,'',48,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
49,5,'1005',0,0,0,'',49,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
50,5,'1006',0,0,0,'',50,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
51,5,'1007',0,0,0,'',51,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
52,5,'1008',0,0,0,'',52,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
53,5,'1009',0,0,0,'',53,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
54,5,'1010',0,0,0,'',54,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
55,5,'1011',0,0,0,'',55,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
56,5,'1012',0,0,0,'',56,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
57,5,'1013',0,0,0,'',57,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
58,5,'1014',0,0,0,'',58,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
59,5,'1015',0,0,0,'',59,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
60,5,'1016',0,0,0,'',60,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
61,5,'1017',0,0,0,'',61,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
62,5,'1018',0,0,0,'',62,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
63,5,'1019',0,0,0,'',63,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
64,5,'1020',0,0,0,'',64,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
65,5,'1021',0,0,0,'',65,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
66,5,'1022',0,0,0,'',66,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
67,5,'1023',0,0,0,'',67,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
68,5,'1024',0,0,0,'',68,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
69,5,'1025',0,0,0,'',69,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
70,5,'1026',0,0,0,'',70,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
71,5,'1027',0,0,0,'',71,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
72,5,'1028',0,0,0,'',72,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
73,5,'1029',0,0,0,'',73,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
74,5,'1030',0,0,0,'',74,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
75,5,'1031',0,0,0,'',75,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
76,5,'1032',0,0,0,'',76,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
77,5,'1033',0,0,0,'',77,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
78,5,'1034',0,0,0,'',78,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
79,5,'1035',0,0,0,'',79,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
80,5,'1036',0,0,0,'',80,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
81,5,'1037',0,0,0,'',81,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
82,5,'1038',0,0,0,'',82,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
83,5,'1039',0,0,0,'',83,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
84,5,'1040',0,0,0,'',84,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
85,5,'1041',0,0,0,'',85,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
86,5,'1042',0,0,0,'',86,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
87,5,'1043',0,0,0,'',87,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
88,5,'1044',0,0,0,'',88,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
89,5,'1045',0,0,0,'',89,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
90,5,'1046',0,0,0,'',90,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
91,5,'1047',0,0,0,'',91,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
92,5,'1048',0,0,0,'',92,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
93,5,'1049',0,0,0,'',93,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
94,5,'1050',0,0,0,'',94,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
95,5,'1051',0,0,0,'',95,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
96,5,'1052',0,0,0,'',96,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
97,5,'1053',0,0,0,'',97,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
98,5,'1054',0,0,0,'',98,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
99,5,'1055',0,0,0,'',99,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
100,5,'1056',0,0,0,'',100,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
101,5,'1057',0,0,0,'',101,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
102,5,'1058',0,0,0,'',102,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
103,5,'1059',0,0,0,'',103,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
104,5,'1060',0,0,0,'',104,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
105,5,'1061',0,0,0,'',105,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
106,5,'1062',0,0,0,'',106,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
107,5,'1063',0,0,0,'',107,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
108,5,'1064',0,0,0,'',108,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
109,5,'1065',0,0,0,'',109,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
110,5,'1066',0,0,0,'',110,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
111,5,'1067',0,0,0,'',111,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
112,5,'1068',0,0,0,'',112,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
113,5,'1069',0,0,0,'',113,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
114,5,'1070',0,0,0,'',114,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
115,5,'1071',0,0,0,'',115,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
116,5,'1072',0,0,0,'',116,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
117,5,'1073',0,0,0,'',117,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
118,5,'1074',0,0,0,'',118,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
119,5,'1075',0,0,0,'',119,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
120,5,'1076',0,0,0,'',120,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
121,5,'1077',0,0,0,'',121,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
122,5,'1078',0,0,0,'',122,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
123,5,'1079',0,0,0,'',123,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
124,5,'1080',0,0,0,'',124,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
125,5,'1081',0,0,0,'',125,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
126,5,'1082',0,0,0,'',126,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
127,5,'1083',0,0,0,'',127,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
128,5,'1084',0,0,0,'',128,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
129,5,'1085',0,0,0,'',129,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
130,5,'1086',0,0,0,'',130,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
131,5,'1087',0,0,0,'',131,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
132,5,'1088',0,0,0,'',132,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
133,5,'1089',0,0,0,'',133,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
134,5,'1090',0,0,0,'',134,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
135,5,'1091',0,0,0,'',135,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
136,5,'1092',0,0,0,'',136,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
137,5,'1093',0,0,0,'',137,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
138,5,'1094',0,0,0,'',138,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
139,5,'1095',0,0,0,'',139,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
140,5,'1096',0,0,0,'',140,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
141,5,'1097',0,0,0,'',141,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
142,5,'1098',0,0,0,'',142,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
143,5,'1099',0,0,0,'',143,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
144,5,'1100',0,0,0,'',144,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
145,5,'1101',0,0,0,'',145,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
146,5,'1102',0,0,0,'',146,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
147,5,'1103',0,0,0,'',147,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
148,5,'1104',0,0,0,'',148,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
149,5,'1105',0,0,0,'',149,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
150,5,'1106',0,0,0,'',150,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
151,5,'1107',0,0,0,'',151,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
152,5,'1108',0,0,0,'',152,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
153,5,'1109',0,0,0,'',153,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
154,5,'1110',0,0,0,'',154,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
155,5,'1111',0,0,0,'',155,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
156,5,'1112',0,0,0,'',156,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
157,5,'1113',0,0,0,'',157,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
158,5,'1114',0,0,0,'',158,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
159,5,'1115',0,0,0,'',159,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
160,5,'1116',0,0,0,'',160,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
161,5,'1117',0,0,0,'',161,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
162,5,'1118',0,0,0,'',162,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
163,5,'1119',0,0,0,'',163,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
164,5,'1120',0,0,0,'',164,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
165,5,'1121',0,0,0,'',165,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
166,5,'1122',0,0,0,'',166,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
167,5,'1123',0,0,0,'',167,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
168,5,'1124',0,0,0,'',168,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
169,5,'1125',0,0,0,'',169,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
170,5,'1126',0,0,0,'',170,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
171,5,'1127',0,0,0,'',171,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
172,5,'1128',0,0,0,'',172,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
173,5,'1129',0,0,0,'',173,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
174,5,'1130',0,0,0,'',174,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
175,35,'2000',0,0,0,'',175,'Time','Time','s or date',2,2497,1,~
176,3,'2001',0,0,0,'',176,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
177,3,'2002',0,0,0,'',177,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
178,3,'2003',0,0,0,'',178,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
179,3,'2004',0,0,0,'',179,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
180,3,'2005',0,0,0,'',180,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
181,3,'2006',0,0,0,'',181,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
182,3,'2007',0,0,0,'',182,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
183,3,'2008',0,0,0,'',183,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
184,3,'2009',0,0,0,'',184,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
185,3,'2010',0,0,0,'',185,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
186,3,'2011',0,0,0,'',186,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
187,3,'2012',0,0,0,'',187,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
188,3,'2013',0,0,0,'',188,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
189,3,'2014',0,0,0,'',189,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
190,3,'2015',0,0,0,'',190,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
191,3,'2016',0,0,0,'',191,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
192,3,'2017',0,0,0,'',192,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
193,3,'2018',0,0,0,'',193,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
194,3,'2019',0,0,0,'',194,'Op_en2201','The mortality due to PM 2.5 fr~~
om buses','premature deaths',1,2201,1,~
418,1,'BAU3',0,0,0,'',418,'Op_en1901','Net health effects due to the ~~
consumption of salmon','avoided cases/a',1,1901,1,~
198,8,' 6.00-20.00',0,0,0,'',198,'Comptraf_scenoutput','Composite tr~~
affic v.1 scenario outputs','various',1,0,0,~
199,8,'20.00-24.00',0,0,0,'',199,'Comptraf_scenoutput','Composite tra~~
ffic v.1 scenario outputs','various',1,0,0,~
200,8,' 0.00- 6.00',0,0,0,'',200,'Comptraf_scenoutput','Composite t~~
raffic v.1 scenario outputs','various',1,0,0,~
364,7,'Trips',0,0,0,'',364,'Op_en2202','Concentration-response to PM2~~
.5','m3/ug',1,2202,1,~
365,7,'Trips by vehicle',0,0,0,'',365,'Op_en2202','Concentration-resp~~
onse to PM2.5','m3/ug',1,2202,1,~
366,7,'Vehicle km',0,0,0,'',366,'Op_en2202','Concentration-response t~~
o PM2.5','m3/ug',1,2202,1,~
367,7,'Parking lot',0,0,0,'',367,'Op_en2202','Concentration-response ~~
to PM2.5','m3/ug',1,2202,1,~
368,7,'Link intensity',0,0,0,'',368,'Op_en2202','Concentration-respon~~
se to PM2.5','m3/ug',1,2202,1,~
369,7,'Vehicles',0,0,0,'',369,'Op_en2202','Concentration-response to ~~
PM2.5','m3/ug',1,2202,1,~
370,7,'Waiting',0,0,0,'',370,'Op_en2202','Concentration-response to P~~
M2.5','m3/ug',1,2202,1,~
371,11,'Bus no change',0,0,0,'',371,'Fig_5b_subsidies','Subsidies nee~~
ded to obtain the composite fraction objective','e/day',1,0,0,~
372,11,'Bus one change',0,0,0,'',372,'Fig_5b_subsidies','Subsidies ne~~
eded to obtain the composite fraction objective','e/day',1,0,0,~
373,11,'Cab no change',0,0,0,'',373,'Fig_5b_subsidies','Subsidies nee~~
ded to obtain the composite fraction objective','e/day',1,0,0,~
374,11,'Cab one change',0,0,0,'',374,'Fig_5b_subsidies','Subsidies ne~~
eded to obtain the composite fraction objective','e/day',1,0,0,~
375,11,'Cab non-full',0,0,0,'',375,'Fig_5b_subsidies','Subsidies need~~
ed to obtain the composite fraction objective','e/day',1,0,0,~
376,11,'Car',0,0,0,'',376,'Fig_5b_subsidies','Subsidies needed to obt~~
ain the composite fraction objective','e/day',1,0,0,~
377,11,'No-change',0,0,0,'',377,'Fig_5b_subsidies','Subsidies needed ~~
to obtain the composite fraction objective','e/day',1,0,0,~
378,12,'Passenger',0,0,0,'',378,'Fig_5c_expanding','Societal costs at~~
different levels of guarantee','e/day',1,0,0,~
379,12,'Society',0,0,0,'',379,'Fig_5c_expanding','Societal costs at d~~
ifferent levels of guarantee','e/day',1,0,0,~
380,13,'Car',0,0,0,'',380,'Bw1','Human body weight in Harjavalta','kg~~
',1,2475,1,~
381,13,'Composite',0,0,0,'',381,'Bw1','Human body weight in Harjavalt~~
a','kg',1,2475,1,~
382,14,'Vehicle',0,0,0,'',382,'Testvariable2','Another variable for t~~
esting','kg',1,0,0,~
383,14,'Driver',0,0,0,'',383,'Testvariable2','Another variable for te~~
sting','kg',1,0,0,~
384,14,'Driving',0,0,0,'',384,'Testvariable2','Another variable for t~~
esting','kg',1,0,0,~
385,14,'Parking',0,0,0,'',385,'Testvariable2','Another variable for t~~
esting','kg',1,0,0,~
386,14,'Parking land',0,0,0,'',386,'Testvariable2','Another variable ~~
for testing','kg',1,0,0,~
387,14,'Emissions',0,0,0,'',387,'Testvariable2','Another variable for~~
testing','kg',1,0,0,~
388,14,'Time',0,0,0,'',388,'Testvariable2','Another variable for test~~
ing','kg',1,0,0,~
389,14,'Accidents',0,0,0,'',389,'Testvariable2','Another variable for~~
testing','kg',1,0,0,~
390,14,'Ticket',0,0,0,'',390,'Testvariable2','Another variable for te~~
sting','kg',1,0,0,~
391,15,'0',0,0,0,'',391,'Testvariable3','Testvariable 3: Another vari~~
able for testing','kg',1,0,0,~
392,15,'0.02',0,0,0,'',392,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
393,15,'0.05',0,0,0,'',393,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
394,15,'0.1',0,0,0,'',394,'Testvariable3','Testvariable 3: Another va~~
riable for testing','kg',1,0,0,~
395,15,'0.25',0,0,0,'',395,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
396,15,'0.4',0,0,0,'',396,'Testvariable3','Testvariable 3: Another va~~
riable for testing','kg',1,0,0,~
397,15,'0.45',0,0,0,'',397,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
398,15,'0.5',0,0,0,'',398,'Testvariable3','Testvariable 3: Another va~~
riable for testing','kg',1,0,0,~
399,15,'0.55',0,0,0,'',399,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
400,15,'0.65',0,0,0,'',400,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
401,15,'0.75',0,0,0,'',401,'Testvariable3','Testvariable 3: Another v~~
ariable for testing','kg',1,0,0,~
402,15,'0.9',0,0,0,'',402,'Testvariable3','Testvariable 3: Another va~~
riable for testing','kg',1,0,0,~
403,15,'1',0,0,0,'',403,'Testvariable3','Testvariable 3: Another vari~~
able for testing','kg',1,0,0,~
404,16,'18-65',0,0,0,'',404,'Op_en1900','Pollutant health risk due to~~
the consumption of salmon','avoided cases/a',1,1900,1,~
405,16,'3',0,0,0,'',405,'Op_en1900','Pollutant health risk due to the~~
consumption of salmon','avoided cases/a',1,1900,1,~
406,17,'Harjavalta',0,0,0,'',406,'Op_en1903','Persistent pollutant co~~
ncentrations in salmon','µg/kg',1,1903,1,~
407,36,'Dieldrin',0,0,0,'',407,'Pollutant','Pollutant','-',2,2493,1,~
408,36,'Toxaphene',0,0,0,'',408,'Pollutant','Pollutant','-',2,2493,1,~~
~
409,36,'Dioxin',0,0,0,'',409,'Pollutant','Pollutant','-',2,2493,1,~
410,36,'PCB',0,0,0,'',410,'Pollutant','Pollutant','-',2,2493,1,~
411,42,'Farmed salmon',0,0,0,'',411,'Environ_compartment','Environmen~~
tal compartment','-',2,2490,1,~
412,42,'Wild salmon',0,0,0,'',412,'Environ_compartment','Environmenta~~
l compartment','-',2,2490,1,~
413,42,'Market salmon',0,0,0,'',413,'Environ_compartment','Environmen~~
tal compartment','-',2,2490,1,~
414,33,'BAU',0,0,0,'',414,'Decision','Possible range of decisions for~~
a single decision-maker','-',2,2496,1,~
415,33,'More actions',0,0,0,'',415,'Decision','Possible range of deci~~
sions for a single decision-maker','-',2,2496,1,~
416,33,'BAU2',0,0,0,'',416,'Decision','Possible range of decisions fo~~
r a single decision-maker','-',2,2496,1,~
417,33,'Restrict farmed salmon use',0,0,0,'',417,'Decision','Possible~~
range of decisions for a single decision-maker','-',2,2496,1,~
419,1,'More actions',0,0,0,'',419,'Op_en1901','Net health effects due~~
to the consumption of salmon','avoided cases/a',1,1901,1,~
421,1,'Restrict farmed salmon use2',0,0,0,'',421,'Op_en1901','Net hea~~
lth effects due to the consumption of salmon','avoided cases/a',1,190~~
1,1,~
422,34,'Cardiovascular',0,0,0,'',422,'Health_impact','Health impact',~~
'',2,2495,1,~
423,10,'Home indoor',0,0,0,'Abbreviation in the Concentration databas~~
e: I',423,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
424,10,'(Home) outdoor',0,0,0,'Abbreviation in the Concentration data~~
base: O',424,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
425,10,'(Personal) Work',0,0,0,'Abbreviation in the Concentration dat~~
abase: W',425,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
426,10,'Personal',0,0,0,'Abbreviation in the Concentration database: ~~
P',426,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
427,10,'Drinking water',0,0,0,'Abbreviation in the Concentration data~~
base: DW',427,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
428,10,'Indoor dust',0,0,0,'Abbreviation in the Concentration databas~~
e: ID',428,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
429,10,'Human',0,0,0,'Abbreviation in the Concentration database: H',~~
429,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
430,10,'Soil',0,0,0,'Abbreviation in the Concentration database: S',4~~
30,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
431,10,'Beverage',0,0,0,'Abbreviation in the Concentration database: ~~
B',431,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
432,10,'Food',0,0,0,'Abbreviation in the Concentration database: F',4~~
32,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
433,10,'In-Vehicle',0,0,0,'Abbreviation in the Concentration database~~
: IV',433,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
434,10,'School',0,0,0,'Abbreviation in the Concentration database: SC~~
',434,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
435,5,'Athens',0,0,0,'Country: Greece. Abbreviation in the Concentrat~~
ion Database: A',435,'Op_en2204','Primary PM2.5 emissions from bus tr~~
affic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
436,5,'Antwerp',0,0,0,'Country: Belgium. Abbreviation in the Concentr~~
ation Database: ANT',436,'Op_en2204','Primary PM2.5 emissions from bu~~
s traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
437,5,'Antioch-Pittsburg',0,0,0,'Country: USA. Abbreviation in the Co~~
ncentration Database: AP',437,'Op_en2204','Primary PM2.5 emissions fr~~
om bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
438,5,'Antioch-Pittsburg A-P',0,0,0,'Country: USA. Abbreviation in th~~
e Concentration Database: A-P',438,'Op_en2204','Primary PM2.5 emissio~~
ns from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
439,5,'Arizona',0,0,0,'Country: USA. Abbreviation in the Concentratio~~
n Database: AZ',439,'Op_en2204','Primary PM2.5 emissions from bus tra~~
ffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
440,5,'Basel',0,0,0,'Country: Germany. Abbreviation in the Concentrat~~
ion Database: B',440,'Op_en2204','Primary PM2.5 emissions from bus tr~~
affic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
441,5,'Baltimore',0,0,0,'Country: USA. Abbreviation in the Concentrat~~
ion Database: BAL',441,'Op_en2204','Primary PM2.5 emissions from bus ~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
442,5,'Bayonne',0,0,0,'Country: USA. Abbreviation in the Concentratio~~
n Database: BAY',442,'Op_en2204','Primary PM2.5 emissions from bus tr~~
affic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
443,5,'Bayonne-Ellizabeth',0,0,0,'Country: USA. Abbreviation in the C~~
oncentration Database: BE',443,'Op_en2204','Primary PM2.5 emissions f~~
rom bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
444,5,'Copenhagen',0,0,0,'Country: Denmark. Abbreviation in the Conce~~
ntration Database: C',444,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
445,5,'California',0,0,0,'Country: USA. Abbreviation in the Concentra~~
tion Database: CA',445,'Op_en2204','Primary PM2.5 emissions from bus ~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
446,5,'Columbus',0,0,0,'Country: USA. Abbreviation in the Concentrati~~
on Database: CO',446,'Op_en2204','Primary PM2.5 emissions from bus tr~~
affic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
447,5,'Daegu',0,0,0,'Country: South Korea. Abbreviation in the Concen~~
tration Database: D',447,'Op_en2204','Primary PM2.5 emissions from bu~~
s traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
448,5,'Devils Lake',0,0,0,'Country: USA. Abbreviation in the Concentr~~
ation Database: DLA',448,'Op_en2204','Primary PM2.5 emissions from bu~~
s traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
449,5,'Dublin',0,0,0,'Country: Ireland. Abbreviation in the Concentra~~
tion Database: DU',449,'Op_en2204','Primary PM2.5 emissions from bus ~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
450,5,'Elizabeth',0,0,0,'Country: USA. Abbreviation in the Concentrat~~
ion Database: ELI',450,'Op_en2204','Primary PM2.5 emissions from bus ~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
451,5,'EPA Region 5.',0,0,0,'Country: USA. Abbreviation in the Concen~~
tration Database: EPA5',451,'Op_en2204','Primary PM2.5 emissions from~~
bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
452,5,'Flanders',0,0,0,'Country: Belgium. Abbreviation in the Concent~~
ration Database: FLA',452,'Op_en2204','Primary PM2.5 emissions from b~~
us traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
453,5,'Florence',0,0,0,'Country: Italy. Abbreviation in the Concentra~~
tion Database: FL',453,'Op_en2204','Primary PM2.5 emissions from bus ~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
454,5,'Grenoble',0,0,0,'Country: France. Abbreviation in the Concentr~~
ation Database: G',454,'Op_en2204','Primary PM2.5 emissions from bus ~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
455,5,'Germany',0,0,0,'Country: Germany. Abbreviation in the Concentr~~
ation Database: GE',455,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
456,5,'Genoa',0,0,0,'Country: Italy. Abbreviation in the Concentratio~~
n Database: GEN',456,'Op_en2204','Primary PM2.5 emissions from bus tr~~
affic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
457,5,'Greensboro GNC',0,0,0,'Country: USA. Abbreviation in the Conce~~
ntration Database: GNC',457,'Op_en2204','Primary PM2.5 emissions from~~
bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
458,5,'Greensboro',0,0,0,'Country: USA. Abbreviation in the Concentra~~
tion Database: GRB',458,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
460,5,'Helsinki',0,0,0,'Country: Finland. Abbreviation in the Concent~~
ration Database: H',460,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
461,5,'Hannover',0,0,0,'Country: Germany. Abbreviation in the Concent~~
ration Database: HA',461,'Op_en2204','Primary PM2.5 emissions from bu~~
s traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
462,5,'Ile de France',0,0,0,'Country: France. Abbreviation in the Con~~
centration Database: IDF',462,'Op_en2204','Primary PM2.5 emissions fr~~
om bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
463,5,'Los Angeles',0,0,0,'Country: USA. Abbreviation in the Concentr~~
ation Database: LA',463,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
464,5,'Milan',0,0,0,'Country: Italy. Abbreviation in the Concentratio~~
n Database: M',464,'Op_en2204','Primary PM2.5 emissions from bus traf~~
fic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
465,5,'Minneapolis',0,0,0,'Country: USA. Abbreviation in the Concentr~~
ation Database: MP',465,'Op_en2204','Primary PM2.5 emissions from bus~~
traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
466,5,'Minnesota',0,0,0,'Country: USA. Abbreviation in the Concentrat~~
ion Database: MS',466,'Op_en2204','Primary PM2.5 emissions from bus t~~
raffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
467,5,'Murcia',0,0,0,'Country: Spain. Abbreviation in the Concentrati~~
on Database: MU',467,'Op_en2204','Primary PM2.5 emissions from bus tr~~
affic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
468,5,'Mexico City',0,0,0,'Country: Mexico. Abbreviation in the Conce~~
ntration Database: MXC',468,'Op_en2204','Primary PM2.5 emissions from~~
bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
469,5,'Oxford',0,0,0,'Country: England. Abbreviation in the Concentra~~
tion Database: O',469,'Op_en2204','Primary PM2.5 emissions from bus t~~
raffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
470,5,'Prague',0,0,0,'Country: Czech. Abbreviation in the Concentrati~~
on Database: P',470,'Op_en2204','Primary PM2.5 emissions from bus tra~~
ffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
471,5,'Padua',0,0,0,'Country: Italy. Abbreviation in the Concentratio~~
n Database: PA',471,'Op_en2204','Primary PM2.5 emissions from bus tra~~
ffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
472,5,'Puebla',0,0,0,'Country: Mexico. Abbreviation in the Concentrat~~
ion Database: PB',472,'Op_en2204','Primary PM2.5 emissions from bus t~~
raffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
473,5,'Rouen',0,0,0,'Country: France. Abbreviation in the Concentrati~~
on Database: R',473,'Op_en2204','Primary PM2.5 emissions from bus tra~~
ffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
475,5,'Strasbourg',0,0,0,'Country: France. Abbreviation in the Concen~~
tration Database: STR',475,'Op_en2204','Primary PM2.5 emissions from ~~
bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
476,5,'Umbria region',0,0,0,'Country: Italy. Abbreviation in the Conc~~
entration Database: UMB',476,'Op_en2204','Primary PM2.5 emissions fro~~
m bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
477,5,'United States',0,0,0,'Country: USA. Abbreviation in the Concen~~
tration Database: USA',477,'Op_en2204','Primary PM2.5 emissions from ~~
bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
478,5,'Valdez',0,0,0,'Country: USA. Abbreviation in the Concentration~~
Database: VAL',478,'Op_en2204','Primary PM2.5 emissions from bus tra~~
ffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
479,5,'Woodland',0,0,0,'Country: USA. Abbreviation in the Concentrati~~
on Database: WDL',479,'Op_en2204','Primary PM2.5 emissions from bus t~~
raffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~
480,4,'66-25-1',0,0,0,'hexanal',480,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
481,4,'71-36-3',0,0,0,'1-butanol',481,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
482,4,'71-43-2',0,0,0,'benzene',482,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
483,4,'78-83-1',0,0,0,'2-methyl-1-propanol',483,'Op_en2205','Bus engi~~
ne technology','see wiki page',1,2205,1,~
484,4,'79-00-5',0,0,0,'1,1,2-trichloroethane',484,'Op_en2205','Bus en~~
gine technology','see wiki page',1,2205,1,~
485,4,'79-01-6',0,0,0,'trichloroethene',485,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
486,4,'80-56-8',0,0,0,'alfa-pinene',486,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
487,4,'91-20-3',0,0,0,'naphtalene',487,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
488,4,'95-47-6',0,0,0,'o-xylene',488,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
489,4,'95-63-6',0,0,0,'trimethylbenzenes',489,'Op_en2205','Bus engine~~
technology','see wiki page',1,2205,1,~
490,4,'100-41-4',0,0,0,'ethylbenzene',490,'Op_en2205','Bus engine tec~~
hnology','see wiki page',1,2205,1,~
491,4,'100-42-5',0,0,0,'styrene',491,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
492,4,'100-52-7',0,0,0,'benzaldehyde',492,'Op_en2205','Bus engine tec~~
hnology','see wiki page',1,2205,1,~
493,4,'103-65-1',0,0,0,'propylbenzene',493,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
494,4,'104-76-7',0,0,0,'2-ethylhexanol',494,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
495,4,'108-38-3',0,0,0,'m(&p)-xylene',495,'Op_en2205','Bus engine tec~~
hnology','see wiki page',1,2205,1,~
496,4,'108-88-3',0,0,0,'toluene',496,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
497,4,'108-95-2',0,0,0,'phenol',497,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
498,4,'110-54-3',0,0,0,'hexane',498,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
499,4,'110-82-7',0,0,0,'cyclohexane',499,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
500,4,'111-76-2',0,0,0,'ethanol, 2-butoxy-',500,'Op_en2205','Bus engi~~
ne technology','see wiki page',1,2205,1,~
501,4,'111-84-2',0,0,0,'nonane',501,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
502,4,'111-87-5',0,0,0,'1-octanol',502,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
503,4,'124-13-0',0,0,0,'octanal',503,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
504,4,'124-18-5',0,0,0,'decane',504,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
505,4,'127-18-4',0,0,0,'tetrachloroethene',505,'Op_en2205','Bus engin~~
e technology','see wiki page',1,2205,1,~
506,4,'138-86-3',0,0,0,'d-limonene',506,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
507,4,'872-50-4',0,0,0,'2-pyrrolidinone, 1-methyl-',507,'Op_en2205','~~
Bus engine technology','see wiki page',1,2205,1,~
508,4,'1120-21-4',0,0,0,'undecane',508,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
509,4,'13466-78-9',0,0,0,'3-caren',509,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
510,4,'TVOC',0,0,0,'Toluene based total VOC',510,'Op_en2205','Bus eng~~
ine technology','see wiki page',1,2205,1,~
511,4,'67-66-3',0,0,0,'chloroform',511,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
512,4,'106-46-7',0,0,0,'1,4-dichlorobenzene',512,'Op_en2205','Bus eng~~
ine technology','see wiki page',1,2205,1,~
514,4,'56-23-5',0,0,0,'carbon tetrachloride',514,'Op_en2205','Bus eng~~
ine technology','see wiki page',1,2205,1,~
515,4,'75-09-2',0,0,0,'methylene chloride',515,'Op_en2205','Bus engin~~
e technology','see wiki page',1,2205,1,~
517,4,'127-91-3',0,0,0,'b-pinene',517,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
520,4,'142-82-5',0,0,0,'n-heptane',520,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
521,4,'111-65-9',0,0,0,'n-octane',521,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
525,4,'112-40-3',0,0,0,'n-dodecane',525,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
526,4,'629-50-5',0,0,0,'n-tridecane',526,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
527,4,'629-59-4',0,0,0,'n-tetradecane',527,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
528,4,'629-62-9',0,0,0,'n-pentadecane',528,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
529,4,'107-83-5',0,0,0,'2-methylpentane',529,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
530,4,'96-14-0',0,0,0,'3-methylpentane',530,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
531,4,'565-59-3',0,0,0,'2,3-dimethylpentane',531,'Op_en2205','Bus eng~~
ine technology','see wiki page',1,2205,1,~
532,4,'591-76-4',0,0,0,'2-methylhexane',532,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
533,4,'589-34-4',0,0,0,'3-methylhexane',533,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
534,4,'592-27-8',0,0,0,'2-methylheptane',534,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
535,4,'589-81-1',0,0,0,'3-methylheptane',535,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
536,4,'96-37-7',0,0,0,'methylcyclopentane',536,'Op_en2205','Bus engin~~
e technology','see wiki page',1,2205,1,~
537,4,'108-87-2',0,0,0,'methylcyclohexane',537,'Op_en2205','Bus engin~~
e technology','see wiki page',1,2205,1,~
538,4,'526-73-8',0,0,0,'1,2,3-trimethylbenzene',538,'Op_en2205','Bus ~~
engine technology','see wiki page',1,2205,1,~
540,4,'108-67-8',0,0,0,'1,3,5 trimethylbenzene',540,'Op_en2205','Bus ~~
engine technology','see wiki page',1,2205,1,~
541,4,'4994-16-5',0,0,0,'4-phenylcyclohexene',541,'Op_en2205','Bus en~~
gine technology','see wiki page',1,2205,1,~
542,4,'1,1,1-trichloroethane',0,0,0,'1,1,1-trichloroethane',542,'Op_e~~
n2205','Bus engine technology','see wiki page',1,2205,1,~
545,4,'141-78-6',0,0,0,'ethylacetate',545,'Op_en2205','Bus engine tec~~
hnology','see wiki page',1,2205,1,~
546,4,'123-86-4',0,0,0,'n-butylacetate',546,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
547,4,'78-93-3',0,0,0,'methyl ethyl ketone',547,'Op_en2205','Bus engi~~
ne technology','see wiki page',1,2205,1,~
548,4,'106-35-4',0,0,0,'3-heptatone',548,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
549,4,'93-58-3',0,0,0,'methyl benzoate',549,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
552,4,'123-51-3',0,0,0,'iso-amyl alcohola',552,'Op_en2205'~~
,'Bus engine technology','see wiki page',1,2205,1,~
554,4,'67-63-0',0,0,0,'2-propanola',554,'Op_en2205','Bus e~~
ngine technology','see wiki page',1,2205,1,~
555,4,'1634-04-4',0,0,0,'t-butyl methylether',555,'Op_en2205','Bus en~~
gine technology','see wiki page',1,2205,1,~
556,4,'7439-92-1',0,0,0,'lead',556,'Op_en2205','Bus engine technology~~
','see wiki page',1,2205,1,~
557,4,'7440-38-2',0,0,0,'arsenic',557,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
558,4,'7440-43-9',0,0,0,'cadmium',558,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
559,4,'7440-39-3',0,0,0,'barium',559,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
560,4,'7440-47-3',0,0,0,'chrome',560,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
561,4,'7440-50-8',0,0,0,'copper',561,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
562,4,'7439-96-5',0,0,0,'manganese',562,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
563,4,'7440-02-0',0,0,0,'nickel',563,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
564,4,'7782-49-2',0,0,0,'selenium',564,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
565,4,'7440-62-2',0,0,0,'vanadium',565,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
566,4,'7440-66-6',0,0,0,'zinc',566,'Op_en2205','Bus engine technology~~
','see wiki page',1,2205,1,~
567,4,'71-55-6',0,0,0,'1,1,1-trichloroethane',567,'Op_en2205','Bus en~~
gine technology','see wiki page',1,2205,1,~
568,4,'7439-97-6',0,0,0,'mercury',568,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
570,4,'60-27-5',0,0,0,'creatinine',570,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
571,4,'7429-90-5',0,0,0,'aluminium',571,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
572,4,'7440-70-2',0,0,0,'calcium',572,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
573,4,'7439-95-4',0,0,0,'magnesium',573,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
574,4,'7723-14-0',0,0,0,'phosphorus',574,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
575,4,'7440-24-6',0,0,0,'strontium',575,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
576,4,'7439-89-6',0,0,0,'iron',576,'Op_en2205','Bus engine technology~~
','see wiki page',1,2205,1,~
577,4,'7440-09-7',0,0,0,'potassium',577,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
578,4,'7440-23-5',0,0,0,'sodium',578,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
579,4,'58-89-9',0,0,0,'lindane',579,'Op_en2205','Bus engine technolog~~
y','see wiki page',1,2205,1,~
580,4,'52645-53-1',0,0,0,'permenthrine',580,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
581,4,'107-13-1',0,0,0,'acrylonitrile',581,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
582,4,'79-06-1',0,0,0,'acrylamide',582,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
589,4,'611-14-3',0,0,0,'1-ethyl 2methyl benzene',589,'Op_en2205','Bus~~
engine technology','see wiki page',1,2205,1,~
592,4,'109-66-0',0,0,0,'n-pentane',592,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
593,4,'7785-26-4',0,0,0,'alpha-pinene',593,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
594,4,'5989-27-5',0,0,0,'d-limonene',594,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
596,4,'106-99-0',0,0,0,'butadiene',596,'Op_en2205','Bus engine techno~~
logy','see wiki page',1,2205,1,~
597,4,'74-84-0',0,0,0,'ethane',597,'Op_en2205','Bus engine technology~~
','see wiki page',1,2205,1,~
598,4,'74-85-1',0,0,0,'ethylene',598,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
599,4,'74-86-2',0,0,0,'acetylene',599,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
600,4,'107-06-2',0,0,0,'1,2-dichloroethane',600,'Op_en2205','Bus engi~~
ne technology','see wiki page',1,2205,1,~
601,4,'106-42-3',0,0,0,'p-xylene',601,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
603,4,'98-82-8',0,0,0,'isopropylbenzene',603,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
604,4,'110-86-1',0,0,0,'pyridine',604,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
606,4,'109-06-8',0,0,0,'2-picoline',606,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
608,4,'108-99-6',0,0,0,'3-picoline',608,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
609,4,'108-89-4',0,0,0,'4-picoline',609,'Op_en2205','Bus engine techn~~
ology','see wiki page',1,2205,1,~
610,4,'104-51-8',0,0,0,'n-butylbenzene',610,'Op_en2205','Bus engine t~~
echnology','see wiki page',1,2205,1,~
611,4,'536-78-7',0,0,0,'3-ethylpyridine',611,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
613,4,'25551-13-7',0,0,0,'trimethylbenzene',613,'Op_en2205','Bus engi~~
ne technology','see wiki page',1,2205,1,~
618,4,'1336-36-3',0,0,0,'PCBs',618,'Op_en2205','Bus engine technology~~
','see wiki page',1,2205,1,~
619,4,'3547-04-4',0,0,0,'DDE',619,'Op_en2205','Bus engine technology'~~
,'see wiki page',1,2205,1,~
620,4,'118-74-1',0,0,0,'HCB',620,'Op_en2205','Bus engine technology',~~
'see wiki page',1,2205,1,~
621,4,'5315-79-7',0,0,0,'1-hydroxypyrene',621,'Op_en2205','Bus engine~~
technology','see wiki page',1,2205,1,~
623,4,'1330-20-7',0,0,0,'xylenes',623,'Op_en2205','Bus engine technol~~
ogy','see wiki page',1,2205,1,~
624,4,'37210-16-5',0,0,0,'CO2',624,'Op_en2205','Bus engine technology~~
','see wiki page',1,2205,1,~
625,4,'630-08-0',0,0,0,'CO',625,'Op_en2205','Bus engine technology','~~
see wiki page',1,2205,1,~
626,4,'54-11-5',0,0,0,'nicotine',626,'Op_en2205','Bus engine technolo~~
gy','see wiki page',1,2205,1,~
628,4,'3588-17-8',0,0,0,'trans,trans-Muconic acid',628,'Op_en2205','B~~
us engine technology','see wiki page',1,2205,1,~
629,4,'50-32-8',0,0,0,'benzo(a)pyrene',629,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
631,4,'590-86-3',0,0,0,'isovaleraldehyde',631,'Op_en2205','Bus engine~~
technology','see wiki page',1,2205,1,~
632,4,'123-38-6',0,0,0,'propionaldehyde',632,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
633,4,'123-72-8',0,0,0,'n-butyraldehyde',633,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
634,4,'75-07-0',0,0,0,'acetaldehyde',634,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
636,4,'50-00-0',0,0,0,'formaldehyde',636,'Op_en2205','Bus engine tech~~
nology','see wiki page',1,2205,1,~
637,4,'110-62-3',0,0,0,'valeraldehyde',637,'Op_en2205','Bus engine te~~
chnology','see wiki page',1,2205,1,~
638,4,'4170-30-3',0,0,0,'crotonaldehyde',638,'Op_en2205','Bus engine ~~
technology','see wiki page',1,2205,1,~
639,22,'n',0,0,0,'Number of observations',639,'Op_en1910','Total mort~~
ality in the Western Europe','cases/a',1,1910,1,~
640,22,'n_lt_LOQ',0,0,0,'Number of observations below level of quanti~~
tation',640,'Op_en1910','Total mortality in the Western Europe','case~~
s/a',1,1910,1,~
641,22,'F0.10',0,0,0,'Fractile 0.1',641,'Op_en1910','Total mortality ~~
in the Western Europe','cases/a',1,1910,1,~
642,22,'F0.50',0,0,0,'Fractile 0.5',642,'Op_en1910','Total mortality ~~
in the Western Europe','cases/a',1,1910,1,~
643,22,'F0.90',0,0,0,'Fractile 0.9',643,'Op_en1910','Total mortality ~~
in the Western Europe','cases/a',1,1910,1,~
644,22,'F0.95',0,0,0,'Fractile 0.95',644,'Op_en1910','Total mortality~~
in the Western Europe','cases/a',1,1910,1,~
645,22,'Mean',0,0,0,'Arithmetic mean',645,'Op_en1910','Total mortalit~~
y in the Western Europe','cases/a',1,1910,1,~
646,22,'GeoMean',0,0,0,'Geometric mean',646,'Op_en1910','Total mortal~~
ity in the Western Europe','cases/a',1,1910,1,~
647,5,'ang',0,0,0,'Anglian Water ',647,'Op_en2204','Primary PM2.5 emi~~
ssions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,~~
1,~
648,5,'bou',0,0,0,'Bristol Water ',648,'Op_en2204','Primary PM2.5 emi~~
ssions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,~~
1,~
649,5,'brw',0,0,0,'Bournemouth & West hants ',649,'Op_en2204','Primar~~
y PM2.5 emissions from bus traffic in Helsinki Metropolitan Area','kg~~
/a',1,2204,1,~
650,5,'caw',0,0,0,'Cambridge Water ',650,'Op_en2204','Primary PM2.5 e~~
missions from bus traffic in Helsinki Metropolitan Area','kg/a',1,220~~
4,1,~
651,5,'cho',0,0,0,'Cholderton Water ',651,'Op_en2204','Primary PM2.5 ~~
emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,22~~
04,1,~
652,5,'dcc',0,0,0,'Dee Valley Water ',652,'Op_en2204','Primary PM2.5 ~~
emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2~~
204,1,~
653,5,'eas',0,0,0,'Welsh Water ',653,'Op_en2204','Primary PM2.5 emiss~~
ions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1,~~
~
654,5,'ess',0,0,0,'Essex and Suffolk Water ',654,'Op_en2204','Primary~~
PM2.5 emissions from bus traffic in Helsinki Metropolitan Area','kg/~~
a',1,2204,1,~
655,5,'fol',0,0,0,'Folkestone & Dover Water ',655,'Op_en2204','Primar~~
y PM2.5 emissions from bus traffic in Helsinki Metropolitan Area','kg~~
/a',1,2204,1,~
656,5,'har',0,0,0,'Hartlepool Water ',656,'Op_en2204','Primary PM2.5 ~~
emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,22~~
04,1,~
657,5,'mik',0,0,0,'Mid Kent Water ',657,'Op_en2204','Primary PM2.5 em~~
issions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204~~
,1,~
658,5,'nor',0,0,0,'Northumbrian Water ',658,'Op_en2204','Primary PM2.~~
5 emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,~~
2204,1,~
659,5,'nww',0,0,0,'Portsmouth Water ',659,'Op_en2204','Primary PM2.5 ~~
emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,22~~
04,1,~
660,5,'por',0,0,0,'Sutton & East Surrey Water ',660,'Op_en2204','Prim~~
ary PM2.5 emissions from bus traffic in Helsinki Metropolitan Area','~~
kg/a',1,2204,1,~
661,5,'sea',0,0,0,'South East Water ',661,'Op_en2204','Primary PM2.5 ~~
emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,22~~
04,1,~
662,5,'sev',0,0,0,'Southern Water ',662,'Op_en2204','Primary PM2.5 em~~
issions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204~~
,1,~
663,5,'sos',0,0,0,'South Staffordshire Water ',663,'Op_en2204','Prima~~
ry PM2.5 emissions from bus traffic in Helsinki Metropolitan Area','k~~
g/a',1,2204,1,~
664,5,'sou',0,0,0,'Severn Trent Water ',664,'Op_en2204','Primary PM2.~~
5 emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,~~
2204,1,~
665,5,'sww',0,0,0,'South West Water ',665,'Op_en2204','Primary PM2.5 ~~
emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1,22~~
04,1,~
666,5,'teh',0,0,0,'Tendring Hundred Water ',666,'Op_en2204','Primary ~~
PM2.5 emissions from bus traffic in Helsinki Metropolitan Area','kg/a~~
',1,2204,1,~
667,5,'tha',0,0,0,'Thames Water ',667,'Op_en2204','Primary PM2.5 emis~~
sions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1~~
,~
668,5,'thr',0,0,0,'Three Valleys Water ',668,'Op_en2204','Primary PM2~~
.5 emissions from bus traffic in Helsinki Metropolitan Area','kg/a',1~~
,2204,1,~
669,5,'wes',0,0,0,'United Utilties (North West Water) ',669,'Op_en220~~
4','Primary PM2.5 emissions from bus traffic in Helsinki Metropolitan~~
Area','kg/a',1,2204,1,~
670,5,'wrx',0,0,0,'Wessex Water ',670,'Op_en2204','Primary PM2.5 emis~~
sions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204,1~~
,~
671,5,'yor',0,0,0,'Yorkshire Water',671,'Op_en2204','Primary PM2.5 em~~
issions from bus traffic in Helsinki Metropolitan Area','kg/a',1,2204~~
,1,~
672,25,'BAU',0,0,0,'0.00000000000000',672,'Op_en1898','Recommendation~~
for consumption of farmed salmon','-',1,1898,1,~
673,25,'Restrict farmed salmon use',0,0,0,'0.00000000000000',673,'Op_~~
en1898','Recommendation for consumption of farmed salmon','-',1,1898,~~
1,~
674,26,'BAU',0,0,0,'0.00000000000000',674,'Op_en1899','Pollutant conc~~
entration limits for fish feed','-',1,1899,1,~
675,26,'More actions',0,0,0,'0.00000000000000',675,'Op_en1899','Pollu~~
tant concentration limits for fish feed','-',1,1899,1,~
676,130,'Dieldrin',0,0,0,'0.00000000000000',676,'Op_en2705','Pollutan~~
t','-',6,2705,1,~
677,130,'Toxaphene',0,0,0,'0.00000000000000',677,'Op_en2705','Polluta~~
nt','-',6,2705,1,~
678,130,'Dioxin',0,0,0,'0.00000000000000',678,'Op_en2705','Pollutant'~~
,'-',6,2705,1,~
679,130,'PCB',0,0,0,'0.00000000000000',679,'Op_en2705','Pollutant','-~~
',6,2705,1,~
680,131,'Farmed salmon',0,0,0,'0.00000000000000',680,'Op_en2706','Sal~~
mon type','-',6,2706,1,~
681,131,'Wild salmon',0,0,0,'0.00000000000000',681,'Op_en2706','Salmo~~
n type','-',6,2706,1,~
682,131,'Market salmon',0,0,0,'0.00000000000000',682,'Op_en2706','Sal~~
mon type','-',6,2706,1,~
685,133,'Cardiovascular',0,0,0,'0.00000000000000',685,'Op_en2707','Ca~~
use of death3','ICD-10',6,2707,1,~
688,135,'2000',0,0,0,'0.00000000000000',688,'Op_en2708','Year3','year~~
',6,2708,1~
)
Nodelocation: 280,96,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,370,45,476,445
Defnstate: 2,518,523,725,303,0,MIDM
Valuestate: 2,404,34,750,516,0,MIDM
Nodecolor: 39325,65535,39321
Reformdef: [L_j,L_i]
Reformval: [L_j,L_i]
Variable Obj2
Title: Obj
Description: This node checks the variables listed in Var_for_rdb and ~~
makes an index of those that are NOT found in the result database. Th~~
is is then used as an index in Inp_var for adding variable informatio~~
n.
Definition: Table(O_i,O_j)(~
1,'Op_en1901','Net health effects due to the consumption of salmon','~~
avoided cases/a',1,1901,1,~
2,'Op_en2693','Testvariable','kg',1,2693,1,~
3,'Op_en2201','The mortality due to PM 2.5 from buses','premature dea~~
ths',1,2201,1,~
4,'Op_en2205','Bus engine technology','see wiki page',1,2205,1,~
5,'Op_en2204','Primary PM2.5 emissions from bus traffic in Helsinki M~~
etropolitan Area','kg/a',1,2204,1,~
6,'Ppmconc_bustraffic','PM2.5 concentration from bus traffic in Helsi~~
nki in 2020','ug/m3',1,0,0,~
7,'Op_en2202','Concentration-response to PM2.5','m3/ug',1,2202,1,~
8,'Comptraf_scenoutput','Composite traffic v.1 scenario outputs','var~~
ious',1,0,0,~
9,'Fig_3_cost_by_source','Cost by source','e/trip',1,0,0,~
10,'Fig_5a_societal_cost','Societal cost','e/day',1,0,0,~
11,'Fig_5b_subsidies','Subsidies needed to obtain the composite fract~~
ion objective','e/day',1,0,0,~
12,'Fig_5c_expanding','Societal costs at different levels of guarante~~
e','e/day',1,0,0,~
13,'Bw1','Human body weight in Harjavalta','kg',1,2475,1,~
14,'Testvariable2','Another variable for testing','kg',1,0,0,~
15,'Testvariable3','Testvariable 3: Another variable for testing','kg~~
',1,0,0,~
16,'Op_en1900','Pollutant health risk due to the consumption of salmo~~
n','avoided cases/a',1,1900,1,~
17,'Op_en1903','Persistent pollutant concentrations in salmon','µg/kg~~
',1,1903,1,~
18,'Op_en1905','Exposure to persistent pollutants due to salmon in th~~
e population of the Western Europe','µg/kg/d',1,1905,1,~
19,'Op_en1906','Dose-response function of persistent pollutants','(mg~~
/kg/d)-1',1,1906,1,~
20,'Op_en1907','Omega-3 content in salmon','g/g',1,1907,1,~
21,'Op_en1908','Omega-3 intake due to salmon in the population of the~~
Western Europe','g/d',1,1908,1,~
22,'Op_en1910','Total mortality in the Western Europe','cases/a',1,19~~
10,1,~
23,'Op_en1911','Cardiovascular mortality in the Western Europe','case~~
s/a',1,1911,1,~
24,'Op_en1912','Cardiovascular effects of omega-3 in salmon in teh We~~
stern Europe','avoided cases/a',1,1912,1,~
25,'Op_en1898','Recommendation for consumption of farmed salmon','-',~~
1,1898,1,~
26,'Op_en1899','Pollutant concentration limits for fish feed','-',1,1~~
899,1,~
27,'Op_en1902','Persistent pollutant concentrations in fish feed','fr~~
action',1,1902,1,~
28,'Op_en1904','Salmon intake in the population of the Western Europe~~
','g/d',1,1904,1,~
29,'Op_en1909','ERF of omega-3 fatty acids on cardiovascular effects'~~
,'1/(g/d)',1,1909,1,~
30,'Op_en2556','Personal exposures to volatile organic compounds in G~~
ermany','ug/m^3',1,2556,1,~
31,'Op_en2406','Excess cases of iMetHb in England and Wales','number'~~
,1,2406,1,~
33,'Decision','Possible range of decisions for a single decision-make~~
r','-',2,2496,1,~
34,'Health_impact','Health impact','',2,2495,1,~
35,'Time','Time','s or date',2,2497,1,~
36,'Pollutant','Pollutant','-',2,2493,1,~
37,'Spatial_location','Spatial location',' km or °',2,2498,1,~
38,'Length','Length','km',2,2498,1,~
39,'Non_health_impact','Non-health impact','-',2,2500,1,~
40,'Period','Period','s',2,2497,1,~
41,'Emission_source','Emission source','-',2,2492,1,~
42,'Environ_compartment','Environmental compartment','-',2,2490,1,~
43,'Vehicle_type','Vehicle type','-',2,0,0,~
44,'Person_or_group','Person or group','-',2,2499,1,~
45,'Transport_mode','Transport mode','-',2,0,0,~
46,'Cost_type','Cost type','-',2,0,0,~
47,'Composite_fraction','Composite fraction','fraction',2,0,0,~
48,'Age','Age','a',2,2497,1,~
49,'Municipality_fin','Municipalities in Finland','-',2,2498,1,~
51,'Food_source','The method for food production','-',2,0,0,~
52,'Feed_pollutant','Decision about fish feed','-',2,0,0,~
53,'Salmon_recomm','Decision about samon consumption recommendation',~~
'-',2,0,0,~
32,'0','No dimension has been identified','-',2,0,0,~
54,'Parameter','Statistical and other parameters of a variable','-',2~~
,0,0,~
55,'Salmon_decision','','',6,0,0,~
56,'Hma_area','','',6,0,0,~
57,'Hma_region','','',6,0,0,~
58,'Hma_zone','','',6,0,0,~
59,'Year_1','','',6,0,0,~
60,'Op_en2665','Cause of death 1','ICD-10',6,2665,1,~
61,'Year_2','','',6,0,0,~
62,'Cause_of_death_2','','',6,0,0,~
63,'Length_1','','',6,0,0,~
70,'Output_1','','',6,0,0,~
65,'Period_1','','',6,0,0,~
86,'Run','','',6,0,0,~
71,'Vehicle_noch','','',6,0,0,~
72,'Stakeholder_1','','',6,0,0,~
73,'Mode1','','',6,0,0,~
74,'Cost_structure_1','','',6,0,0,~
75,'Comp_fr_1','','',6,0,0,~
76,'Age1','','',6,0,0,~
77,'Municipality_fin1','','',6,0,0,~
82,'Year3','','',6,0,0,~
81,'Recommendation1','','',6,0,0,~
80,'Reg_poll','','',6,0,0,~
79,'Salmon1','','',6,0,0,~
78,'Pollutant1','','',6,0,0,~
83,'H1899','','',6,0,0,~
84,'H1898','','',6,0,0,~
85,'Cause_of_death3','','',6,0,0,~
87,'Condb_compartment1','','',6,0,0,~
88,'Condb_location1','','',6,0,0,~
89,'Condb_agent1','','',6,0,0,~
90,'Condb_param1','','',6,0,0,~
91,'Condb_agent2','','',6,0,0,~
92,'Vehicle_1','','',6,0,0,~
93,'Op_en2672','','',6,0,0,~
94,'94','Analytica','',9,0,0,~
95,'95','Analytica 4.1.0.9','',9,0,0,~
97,'97','Analytica 4.1.0.9, CompositeTraffic_1_0_6.ana v. 11:47, 1000~~
iterations','',9,0,0,~
99,'99','Analytica 4.1.0.9, RDB connection.ANA, 100 iterations','',9,~~
0,0,~
100,'100','RDB connection.ANA v. 1.9.2008, Edition: Enterprise, Platf~~
orm: Windows, Version: 40100, Samplesize: 100','',9,0,0,~
101,'101','RDB connection.ANA v. 2.9.2008. Test data only., Edition: ~~
Enterprise, Platform: Windows, Version: 40100, Samplesize: 100','',9,~~
0,0,~
102,'102','RDB connection.ANA v. 3.9.2008 b. Test data only., Edition~~
: Enterprise, Platform: Windows, Version: 40100, Samplesize: 100','',~~
9,0,0,~
103,'103','Farmed salmon.ANA 10:36, 31 December 2007, RDB connection.~~
ANA 13:58, 3 September 2008, Edition: Enterprise, Platform: Windows, ~~
Version: 40100, Samplesize: 1000','',9,0,0,~
104,'104','Farmed salmon.ANA 10:36, 31 December 2007, RDB connection.~~
ANA 13:58, 3 September 2008, Edition: Enterprise, Platform: Windows, ~~
Version: 40100, Samplesize: 1000','',9,0,0,~
105,'105','Farmed salmon.ANA 10:36, 31 December 2007, RDB connection.~~
ANA 13:58, 3 September 2008, Edition: Enterprise, Platform: Windows, ~~
Version: 40100, Samplesize: 1000','',9,0,0,~
106,'106','Farmed salmon.ANA 10:36, 31 December 2007, RDB connection.~~
ANA 13:58, 3 September 2008, Edition: Enterprise, Platform: Windows, ~~
Version: 40100, Samplesize: 10','',9,0,0,~
107,'107','Farmed salmon.ANA 8.9.2008, RDB connection.ANA 8.9.2008, E~~
dition: Enterprise, Platform: Windows, Version: 40100, Samplesize: 10~~
','',9,0,0,~
108,'108','Farmed salmon.ANA 8.9.2008, RDB connection.ANA 8.9.2008, ~~
Edition: Enterprise, Platform: Windows, Version: 40100, Samplesize: 1~~
000','',9,0,0,~
98,'98','Test','',9,0,0,~
109,'109',' CompositeTraffic_1_0_6.ANA 16.9.2008, RDB connection.ANA ~~
16.9.2008, Edition: Enterprise, Platform: Windows, Version: 40100, Sa~~
mplesize: 10','',9,0,0,~
110,'110',' CompositeTraffic_1_0_6.ANA 16.9.2008, RDB connection.ANA ~~
16.9.2008, Edition: Enterprise, Platform: Windows, Version: 40100, Sa~~
mplesize: 1000','',9,0,0,~
111,'111','RDB connection.ANA 16.9.2008, Edition: Enterprise, Platfor~~
m: Windows, Version: 40100, Samplesize: 100','',9,0,0,~
112,'112','RDB connection.ANA 9.10.2008, Edition: Enterprise, Platfor~~
m: Windows, Version: 40100, Samplesize: 100','',9,0,0,~
113,'113','RDB connection.ANA 9.10.2008, Edition: Enterprise, Platfor~~
m: Windows, Version: 40100, Samplesize: 10','',9,0,0,~
114,'Op_en1896','Benefit-risk assessment on farmed salmon','',4,1896,~~
1,~
130,'Op_en2705','Pollutant','-',6,2705,1,~
131,'Op_en2706','Salmon type','-',6,2706,1,~
133,'Op_en2707','Cause of death3','ICD-10',6,2707,1,~
135,'Op_en2708','Year3','year',6,2708,1,~
137,'Op_en2694','Testrun 1: Analytica Enterprise, (Windows), Version:~~
40100, Samplesize: 10','',9,2694,1,~
159,'Op_eni1896','Benefit-risk assessment of farmed salmon','',4,0,1,~~
~
160,'Op_eni2694','Testrun 1: Analytica Enterprise, (Windows), Version~~
: 40100, Samplesize: 10','',9,0,1,~
183,'Op_eni2695','Testrun 2: Analytica Enterprise, (Windows), Version~~
: 40100, Samplesize: 1000','',9,0,1~
)
Nodelocation: 280,48,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,378,21,493,501
Defnstate: 2,152,162,1057,343,0,MIDM
Valuestate: 2,573,21,700,421,0,MIDM
Nodecolor: 39325,65535,39321
Reformdef: [O_j,O_i]
Reformval: [O_j,O_i]
{!40000|Att_previndexvalue: ['H1991']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Variable Sett1
Title: Sett
Description: This node checks the variables listed in Var_for_rdb and ~~
makes an index of those that are NOT found in the result database. Th~~
is is then used as an index in Inp_var for adding variable informatio~~
n.
Definition: Table(S_i,S_j)(~
1,33,1,~
2,37,1,~
5,35,1,~
6,34,1,~
9,38,1,~
10,39,1,~
11,40,1,~
12,32,1,~
13,43,1,~
14,44,1,~
15,45,1,~
16,46,1,~
17,47,1,~
18,48,1,~
19,49,1,~
23,51,1,~
24,36,1,~
28,42,1,~
31,54,1,~
35,114,3,~
38,137,9,~
37,114,4,~
39,159,3,~
41,160,9,~
44,183,9~
)
Nodelocation: 280,72,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,378,21,493,501
Valuestate: 2,529,143,700,421,0,MIDM
Nodecolor: 39325,65535,39321
Reformdef: [S_j,S_i]
Reformval: [S_i,S_j]
{!40000|Att_previndexvalue: ['H1991']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Variable Item1
Title: Item
Description: This node checks the variables listed in Var_for_rdb and ~~
makes an index of those that are NOT found in the result database. Th~~
is is then used as an index in Inp_var for adding variable informatio~~
n.
Definition: Table(It_i,It_j)(~
1,1,55,0,~
2,2,56,0,~
3,2,57,0,~
4,2,58,0,~
5,5,59,0,~
6,6,60,0,~
7,5,61,0,~
8,6,62,0,~
9,9,63,0,~
10,11,65,0,~
11,10,70,0,~
12,13,71,0,~
13,14,72,0,~
14,15,73,0,~
15,16,74,0,~
16,17,75,0,~
17,18,76,0,~
18,19,77,0,~
19,24,78,0,~
20,23,79,0,~
21,1,80,0,~
22,1,81,0,~
23,5,82,0,~
24,1,83,0,~
25,1,84,0,~
26,6,85,0,~
27,12,86,0,~
28,28,87,0,~
29,2,88,0,~
30,24,89,0,~
31,31,90,0,~
32,24,91,0,~
33,13,92,0,~
34,2,93,0,~
35,35,28,0~
)
Nodelocation: 280,120,1
Nodesize: 48,13
Nodeinfo: 1,1,1,1,1,1,0,0,0,0
Windstate: 2,378,21,493,501
Valuestate: 2,529,143,700,421,0,MIDM
Nodecolor: 39325,65535,39321
Reformdef: [It_j,It_i]
Reformval: [It_i,It_j]
{!40000|Att_previndexvalue: ['H1991']}
{!40000|Att_resultslicestate: [Self,1,Sys_localindex('I'),1,Sys_locali~~
ndex('J'),1]}
Module Assessment
Title: Assessment
Description: DO NOT REMOVE THIS NODE. It is needed for computing the O~~
bjects node.
Author: ktluser
Date: 29. Decta 2008 21:51
Defaultsize: 48,24
Nodelocation: 168,224,1
Nodesize: 52,12
Diagstate: 1,11,11,550,300,17
Close Assessment
Close Details
Close Op_en2676
Index Country1
Title: Country1
Definition: ['Finland']
Nodelocation: 168,280,1
Nodesize: 48,12
Index Sex1
Title: Sex
Definition: ['M','F']
Nodelocation: 296,216,1
Nodesize: 48,12
Valuestate: 1,104,114,416,303,0,MIDM
{!40000|Att_previndexvalue: ['Male','Female']}
Close Who_mortality