Get documents about "Endocrine Worksheet - Excel
W
Description
Endocrine Worksheet document sample
Document Sample
Other endocrine metaboloc disorders I4
DISEASE: Other endocrine & metabolic disorders Updated: 26-Jun-99
REGION: Australia By: Colin Mathers
AusBODI code: I4 Status: Final
Notes:
1. Case definition and sequelae/disease stage
Disease category Sequelae Definition
Other endocrine & metabolic disordersCases
2. Disease weights Sequelae Weight Comment
Cases 0.164 Provisional weight - average weight for COPD
3. Mortality data for Other endocrine & metabolic disorders
0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Total
Number of deaths
Males 12 1 7 5 21 56 69 144 184 501
Females 14 4 5 8 13 30 37 102 263 477
Deaths per 100,000
Males 1.8 0.1 0.5 0.4 1.5 4.8 8.9 23.5 53.3 5.5
Females 2.2 0.3 0.4 0.6 0.9 2.6 4.8 15.0 46.8 5.2
Yll per 100,000
Males 366 30 202 133 497 1104 1061 1524 1094 6010
Females 436 121 150 219 325 648 638 1271 1671 5479
4. If we calculate YLDs for other endocrine and metabolic conditions by applying the average YLD/YLL ratio for other conditions
in this category, we get:
0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Total
YLL for I1+I2+I3
Males 122 88 202 245 116 61 127 162 230 1353
Females 31 183 301 195 72 223 120 210 448 1783
YLD for I1+I2+I3
Males 948 13 12 16 27 41 72 146 195 1470
Females 685 10 12 15 38 59 67 122 197 1206
YLD for I4
Males 398 33 220 144 540 1199 1152 1656 1188 6529
Females 295 82 101 148 220 438 431 859 1130 3704
5. This results in YLD/YLL ratio of 1.09 for males and 0.68 for females. The YLD/YLL ratio for all endocrine disorders
(excluding diabetes) in the EME was 1.6 for males and 2.6 for females. Use ratio of 1:1 for both males and females
as a conservative estimate. DALY Parameters
For purposes of calculating undiscounted YLDs, assume 6 month duration. 0.03 Discount rate (r)
0.04 Beta (b)
0.1658 Constant (C)
-0.07 -(b+r)
0 K
6. YLD for Australia
Undiscounted
Australia Population Incidence Incidence Age at Duration Disability YLDs YLD per YLDs YLD per
('00000) per 100,000 onset Weight 100,000 (r=0) 100,000
Males
0-4 6.66 1,602 440 2.5 0.5 0.500 397.6 59.7 400.5
5-14 13.39 132 30 10.0 0.5 0.500 32.8 2.4 33.0
15-24 13.64 885 20 19.8 0.5 0.500 219.6 16.1 221.3
25-34 14.31 580 5 29.7 0.5 0.500 144.0 10.1 145.1
35-44 14.03 2,176 5 40.0 0.5 0.500 540.1 38.5 544.1
45-54 11.72 4,831 30 50.0 0.5 0.500 1198.8 102.3 1207.9
55-64 7.74 4,643 60 60.1 0.5 0.500 1152.0 148.9 1160.7
65-74 6.14 6,672 135 69.8 0.5 0.500 1655.6 269.8 1668.0
75+ 3.46 4,788 225 80.7 0.5 0.500 1188.1 343.6 1197.1
91.08 26,311 289 57.0 0.5 0.500 6529 71.7 6577.7 72.2
Females
0-4 6.31 1,188 240 2.5 0.5 0.500 294.8 46.7 297.0
5-14 12.75 330 40 9.3 0.5 0.500 81.9 6.4 82.5
15-24 13.12 408 50 18.1 0.5 0.500 101.3 7.7 102.1
25-34 14.31 597 10 30.0 0.5 0.500 148.1 10.3 149.2
35-44 14.08 885 10 40.0 0.5 0.500 219.5 15.6 221.2
45-54 11.37 1,765 30 50.0 0.5 0.500 438.0 38.5 441.3
55-64 7.64 1,739 80 60.2 0.5 0.500 431.4 56.4 434.6
65-74 6.82 3,463 80 69.9 0.5 0.500 859.4 126.1 865.9
75+ 5.62 4,553 90 81.3 0.5 0.500 1129.8 201.0 1138.3
92.03 14,928 162 58.4 0.5 0.500 3704.2 40.3 3732.1 40.6
10233
1/30/2011 Page 1
Other endocrine metaboloc disorders I4
3 1
Specify person: 30-Jan-11
Colin Mathers Preliminary Colin Mathers
Specify status: Draft for consultaton Chris Stevenson
Final Final Simon Eckermann
Template Type other name
Row number in YLL and DALY spreadsheets
87
1.086211 1.661692
0.676026 2.623116
Calculation of prevalence YLD (undiscounted)
Ageweighted
Agewt YLD per YLDs YLDs YLDs YLDs YLDs YLDs YLDs YLDs YLDs
YLDs 100,000 <5 years <15 years <25 years <35 years <45 years <55 years <65 years <75 years Total
162.3 400.5 400.5 400.5 400.5 400.5 400.5 400.5 400.5 400.55
37.0 33.0 33.0 33.0 33.0 33.0 33.0 33.0 33.05
327.4 221.3 221.3 221.3 221.3 221.3 221.3 221.30
215.8 145.1 145.1 145.1 145.1 145.1 145.09
720.4 544.1 544.1 544.1 544.1 544.12
1338.3 1207.9 1207.9 1207.9 1207.86
1031.2 1160.7 1160.7 1160.69
1167.0 1668.0 1668.01
625.8 1197.08
5625.2 61.8 400.5 433.6 654.9 800.0 1344.1 2552.0 3712.7 5380.7 6577.7 Total Check
400.5 33.0 221.3 145.1 544.1 1207.9 1160.7 1668.0 1197.1 6577.7 0.0
120.4 297.0 297.0 297.0 297.0 297.0 297.0 297.0 297.0 297.02
88.5 82.5 82.5 82.5 82.5 82.5 82.5 82.5 82.50
148.0 102.1 102.1 102.1 102.1 102.1 102.1 102.08
221.5 149.2 149.2 149.2 149.2 149.2 149.18
292.8 221.2 221.2 221.2 221.2 221.17
489.0 441.3 441.3 441.3 441.32
385.2 434.6 434.6 434.63
604.2 865.9 865.86
585.3 1138.32
2934.8 31.9 297.0 379.5 481.6 630.8 851.9 1293.3 1727.9 2593.8 3732.1 Total Check
297.0 82.5 102.1 149.2 221.2 441.3 434.6 865.9 1138.3 3732.1 0.0
1/30/2011 Page 2
Other endocrine metaboloc disorders I4
YLDs
397.6 24.81343
32.8 24.81343
219.6 24.81343
144.0 24.81343
540.1 24.81343
1198.8 24.81343
1152.0 24.81343
1655.6 24.81343
1188.1 24.81343
6529 223.3209
294.8 24.81343
81.9 24.81343
101.3 24.81343
148.1 24.81343
219.5 24.81343
438.0 24.81343
431.4 24.81343
859.4 24.81343
1129.8 24.81343
3704.2 223.3209
10233 446.6418
1/30/2011 Page 3
YLD
DISEASE: I4. Other endocrine & metabolic disorders
REGION: Summary results for linking to DALY worksheets
This worksheet summarises YLD for Australia and subpopulations in formats suitable for linking to DALY
Paste coloured block into relevant DALY spreadsheets
1. Australia - YLD (discounted) Link to: Burden of Disease/DALY/AUS
YLD 0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Male
Australia 398 33 220 144 540 1199 1152 1656 1188 6529
2. Australia - YLD (no discounting) Link to:
YLD 0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Male
Australia 401 33 221 145 544 1208 1161 1668 1197 6578
3. Australia - Prevalence YLD Link to:
YLD 0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Male
Australia 401 33 221 145 544 1208 1161 1668 1197 6578
Page 4
YLD
itable for linking to DALY spreadsheets
ase/DALY/AUS
0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Female Persons
295 82 101 148 220 438 431 859 1130 3704 10233 Final
Check 0 0
0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Female Persons
297 83 102 149 221 441 435 866 1138 3732 10310 Final
Check 0 0
0-4 5-14 15-24 25-34 35-44 45-54 55-64 65-74 75+ Female Persons
297 83 102 149 221 441 435 866 1138 3732 10310 Final
Check 0 0
Page 5
YLD
26-Jun-99
Colin Mathers
26-Jun-99
Colin Mathers
26-Jun-99
Colin Mathers
Page 6
Related docs
