Private Sub Command1_Click()
Dim a1 As Single
Dim a2 As Single
Dim a3 As Single
Dim a(1 To 9, 1 To 4) As Single
Dim mhrate(0 To 99, 15 To 69) As Single
Dim fhrate(0 To 99, 15 To 69) As Single
Dim mrou(0 To 99, 15 To 69) As Single
Dim trou(0 To 99, 15 To 69) As Single
Dim drou(0 To 99, 15 To 69) As Single
Dim mrate(0 To 99, 15 To 69) As Single
Dim trate(0 To 99, 15 To 69) As Single
Dim drate(0 To 99, 15 To 69) As Single
Dim mmrate(0 To 99, 15 To 69) As Single
Dim ttrate(0 To 99, 15 To 69) As Single
Dim ddrate(0 To 99, 15 To 69) As Single
Dim ms(8 To 99, 15 To 69) As Single
Dim ts(8 To 99, 15 To 69) As Single
Dim ds(8 To 99, 15 To 69) As Single
Dim year As Single
Dim age As Single
Open "c:/kyu/gdata/労働力人口.txt " For Input As #2
Do Until EOF(2)
Input #2, a1, a2, a3, a4, a5
year = a1
age = a2
mrou(year, age) = a3
trou(year, age) = a4
drou(year, age) = a5
Loop
Close #2
Open "c:/kyu/gdata/就業率.txt " For Input As #3
Do Until EOF(3)
Input #3, a1, a2, a3, a4, a5
year = a1
age = a2
mrate(year, age) = a3
trate(year, age) = a4
drate(year, age) = a5
Loop
Close #3
Open "c:/kyu/gdata/労働力率.txt " For Input As #55
Do Until EOF(55)
Input #55, a1, a2, a3, a4, a5
year = a1
age = a2
mmrate(year, age) = a3
ttrate(year, age) = a4
ddrate(year, age) = a5
Loop
Close #55
For year = 8 To 99
For age = 15 To 69
ms(year, age) = mrate(year, age) * mrou(year, age) / mmrate(year, age)
ts(year, age) = trate(year, age) * trou(year, age) / ttrate(year, age)
ds(year, age) = drate(year, age) * drou(year, age) / ddrate(year, age)
Next
Next
Open "c:/kyu/gdata/就業者.txt " For Output As #3
For year = 8 To 99
For age = 15 To 69
Write #3, year, age, ms(year, age), ts(year, age), ds(year, age)
Next
Next
Close #3
End Sub
最終更新:2010年05月22日 18:43