Function u(s1 As Single, s2 As Single, th1, th2, cp As Single, yp1 As Single, yp2 As Single) As Single
Dim lx As Single
Dim cx As Single
Dim px As Single
l1 = yp1 / th1(s1)
l2 = yp2 / th2(s2)
cx = cp
px = 0
If cx < 0.01 Then px = 1
If l1 > 0.99 Then px = 1
If l2 > 0.99 Then px = 1
If l1 < 0 Then px = 1
If l2 < 0 Then px = 1
If px = 1 Then cx = 0.5
If px = 1 Then l1 = 0.5
If px = 1 Then l2 = 0.5
ux = Log(cx) + Log(1 - l1) + Log(1 - l2)
If px = 1 Then ux = -999
u = ux
End Function
Function fprefer(s1 As Single, s2 As Single, th1, th2, c, y1, y2) As Single
Dim m As Single
Dim maxu As Single
Dim maxm As Single
Dim u1 As Single
Dim c1 As Single
Dim my As Single
Dim fy As Single
maxu = -999
For m1 = 0 To 10
For m2 = 0 To 10
c1 = c(m1, m2)
my = y1(m1)
fy = y2(m2)
u1 = u(s1, s2, th1, th2, c1, my, fy)
If u1 > maxu Then maxm = m2
If u1 > maxu Then maxu = u1
Next
Next
fprefer = maxm
End Function
Function mprefer(s1 As Single, s2 As Single, th1, th2, c, y1, y2) As Single
Dim m As Single
Dim maxu As Single
Dim maxm As Single
Dim u1 As Single
Dim c1 As Single
Dim my As Single
Dim fy As Single
maxu = -999
For m1 = 0 To 10
For m2 = 0 To 10
c1 = c(m1, m2)
my = y1(m1)
fy = y2(m2)
u1 = u(s1, s2, th1, th2, c1, my, fy)
If u1 > maxu Then maxm = m1
If u1 > maxu Then maxu = u1
Next
Next
mprefer = maxm
End Function
Private Sub Command1_Click()
Dim m1 As Single
Dim m2 As Single
Dim s1 As Single
Dim s2 As Single
Dim cp1 As Single
Dim yp1 As Single
Dim yp2 As Single
Dim c(0 To 10, 0 To 10) As Single
Dim cs(0 To 10, 0 To 10) As Single
Dim th1(1 To 10) As Single
Dim th2(1 To 10) As Single
Dim y1(0 To 10) As Single
Dim y2(0 To 10) As Single
Dim gr(0 To 10, 0 To 10) As Single
Dim i As Single
Dim j As Single
Dim h As Single
Dim n1 As Single
Dim n2 As Single
Dim n3 As Single
Open "c:/lupin2.txt" For Input As #2
Do Until EOF(2)
Input #2, a1, a2, a3
m1 = a1
m2 = a2
cs(m1, m2) = a3
Loop
Close #2
For s = 1 To 10
th1(s) = 0.2 * s
th2(s) = 0.1 * s
Next
For m = 0 To 10
y1(m) = 0.105 * m
y2(m) = 0.05 * m
Next
For s1 = 1 To 10
For s2 = 1 To 10
m1 = mprefer(s1, s2, th1, th2, cs, y1, y2)
m2 = fprefer(s1, s2, th1, th2, cs, y1, y2)
gr(m1, m2) = 1
Next
Next
z2 = 0
For m1 = 0 To 9
For m2 = 0 To 10
h = 0
If gr(m1, m2) = 1 Then h = h + 1
If gr(m1 + 1, m2) = 1 Then h = h + 1
If h = 2 Then Debug.Print y1(m1), y1(m2), 1 - (cs(m1 + 1, m2) - cs(m1, m2)) / (y1(m1 + 1) - y1(m1))
Next
Next
For m1 = 0 To 10
For m2 = 0 To 9
h = 0
If gr(m1, m2) = 1 Then h = h + 1
If gr(m1, m2 + 1) = 1 Then h = h + 1
If h = 2 Then Debug.Print y1(m1), y1(m2), 1 - (cs(m1, m2 + 1) - cs(m1, m2)) / (y2(m2 + 1) - y2(m2))
Next
Next
Debug.Print cs(8, 0), cs(8, 1)
End Sub
最終更新:2009年10月29日 15:57