SteveDB1 wrote:
I just thought of something that might tell me part of what I want.
What would I code to get a counter to tell me how many iterations that it
takes to get to my upper limit?


For a looping solution, one way if we use your code...

Sub fibbonacci()
Dim i As Double
Dim j As Double
Dim N As Double
Dim fib As Double
Dim C As Double 'Counter

i = -1
j = 1
C = -1
While (fib <= 6000000000#)
C = C + 1
fib = i + j
i = j
j = fib
Wend
'We've exceeded our number
MsgBox "The Max Fibbonacci # is: " & C - 1
End Sub

- -
HTH
Dana DeLouis














"Dana DeLouis" wrote:

no problems....until I reach 1.84 billion.

Hi. If you change your Dim statements to Double, you will be able to
calculate a Fibbonacci number a little greater than 46.

I'm afraid I don't understand your question about Offset.

- - -
Dana DeLouis



SteveDB1 wrote:
Howdie all.
I've used some C# code to create my own fibbnoacci series macro.
-----------------------------------------------------------
Sub fibbonacci()
Dim i As Long
Dim j As Long
Dim N As Long
Dim fib As Long

i = -1
j = 1

While (fib <= 6000000000#)
fib = i + j
i = j
j = fib

Wend
MsgBox "The Fibbonacci # for this series is: " & fib

End Sub
-------------------------------------------------------------------
It works good, with no problems. Well, at least until I reach 1.84 billion.

What I want to do is to add a "time" function with a 9 month limiter. I.e.,
each iteration has an output with each 9 months of time, and a 13 to 17 year
start point for each subsequent iteration set.
E.g.,
the fibbonacci numbers are
1, 1, 2, 3, 5, 8, 13, 21,.......
So, my first set where 1 and 1 become 2, is at time = 9 months.
my next set where 2 becomes 3 is at least 9 months, and each subsequent 9
months ++
I then want to do an offshoot from that, essentially starting over with each
13 to 17 years.

My overall goal is a population growth analysis for personal purposes. Back
when I was taking my math classes, one of my professors told me that the
fibbonacci series was developed to analyze rabbit population growth.

I realize that this might be over the top of what is done here, but I wanted
to at least ask. So, if it is, please let me know.
Thank you for your helps.
Best,
SteveB.