Var2 = 0.1
        For y = 0 To jlhPro - 1
            Do
                Var1 = Var2
 
                For z = 0 To thn - 1
                    kata &= data(y, z) & "*" & Var1 & "^" & z + 1 & vbCrLf
                    Res1 += data(y, z) * Var1 ^ (z + 1)
                    kata &= "data = " & data(y, z) & vbCrLf
                    kata &= "res1 = " & Res1 & vbCrLf
                Next
                Res1 -= invest
                kata &= "res1 = " & Res1 & vbCrLf & vbCrLf & vbCrLf
                kata &= "=========================================" & vbCrLf
 
 
                For z = thn To 1 Step -1
                    Res2 += z * data(y, z - 1) * Var1 ^ (z - 1) & vbCrLf
                    kata &= z & "*" & data(y, z - 1) & "*" & Var1 & "^" & (z - 1) & vbCrLf
                    kata &= "res2 = " & Res2 & vbCrLf
                Next
 
                Var2 = Var1 - Res1 / Res2
            Loop Until Math.Abs(Var1 - Var2) < 0.00000001
 
            ir = (1 - Var2) / Var2
            kata &= "irr = " & ir * 100 & "% " & vbCrLf
        Next