# Fibonacci Clock in Excel with a multitude of options

1. ## Fibonacci Clock in Excel with a multitude of options

Hi, I've created a Fibonacci Clock showing hours, minutes and seconds in a spectrum of colours, and a multitude of options . Grateful for any feedback. Mark

2. ## Re: Fibonacci Clock in Excel with a multitude of options

``Please Login or Register  to view this content.``
delete 1st line in module1 "private sub work..."

3. Originally Posted by bsalv
``Please Login or Register  to view this content.``
delete 1st line in module1 "private sub work..."
Bsalv, thank you, I'll give it a try. Mark

4. ## Re: Fibonacci Clock in Excel with a multitude of options

=IF(MOD(A2+A6;3)=2;1;0)

PHP Code:
``` =N(MOD(A2+A6;3)=2)  ```
or
PHP Code:
``` =MOD(A2+A6;3)=2  ```

5. Originally Posted by snb

=IF(MOD(A2+A6;3)=2;1;0)

PHP Code:
``` =N(MOD(A2+A6;3)=2)  ```
or
PHP Code:
``` =MOD(A2+A6;3)=2  ```
Snb, thank you, I'll look into this. I'm very proud of my MOD formula, so let's see Mark

6. ## Re: Fibonacci Clock in Excel with a multitude of options

I'm very proud of my MOD formula, so let's see …
You were looking for advice. The first formula does exactly the same as yours and produces a 0 or 1, without the IF. The second produces True or False, which I guess is how you might be interpreting the 0/1 result.

7. ## Re: Fibonacci Clock in Excel with a multitude of options

I'd prefer a few VBA-lines.

8. ## Re: Fibonacci Clock in Excel with a multitude of options

Bsalv, I did give it a try, but it didn't seem to make any difference, but I'm probably doing it wrong. I'm assuming it was meant to start the clock automatically. This is how I entered the code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)

Disable 'stop the "ontime"

ThisWorkbook.Saved = True 'don't ask to save while closing

End Sub
Just before the existing code. I deleted the line "Private sub work..."

Mark

9. ## Re: Fibonacci Clock in Excel with a multitude of options

TMS and snb, I did try the different formula, but it didn't work for me. I used the IF(MOD) function to reduce output to 0 or 1 so I can't see how using a different formula would improve the outcome, but thank you for suggesting and I'm always willing to learn new things, for a bear of small brains that is. Mark

10. ## Re: Fibonacci Clock in Excel with a multitude of options

snb, I'm not having much luck tonight. I wasn't able to run your clock from my rather dated machine. I do admire the code, but I think there is a reason why I'm confined to Excel formulas =IF(AB>0,"Give it a try","Admit defeat"). Mark

11. ## Re: Fibonacci Clock in Excel with a multitude of options

see attachment.

In ThisWorkbook
while closing, there is no irritating question about saving, so be sure, you did it yourself if you made modifications.
When you open the file, the clock start also

In Module1
the 1st line is now comment (because the ' in front) and can be deleted.
2 macros are now joined in one, functionality is the same.

Be aware that some terms are dangerous when they also have a meaning in VBA.
"Disable" isn't, but is close. Later, finding such an error is difficult, so rename your macro "Disable_Clock" or something similar.

12. ## Re: Fibonacci Clock in Excel with a multitude of options

bsalv, thank you, that worked. I would like to give you credit in the 'Journey' tab as I have with the other sources I found along the way. What would be the best way for me to do this for your contribution? Mark

13. ## Re: Fibonacci Clock in Excel with a multitude of options

I'm more a helper then an asker, so i never did, but i think here "Add a reputation" in one of my posts

14. ## Re: Fibonacci Clock in Excel with a multitude of options

The clock I posted doesn't 'run'
Only if you change the time value in L2 the clock will be changed.
The VBA is Excel version independent.
And as soon as you use VBA you'd better do the whole thing in VBA.
And: avoid merged cells.

15. ## Re: Fibonacci Clock in Excel with a multitude of options

snb, thank you, I take your point about VBA and also about merged cells (also my pet hate), but as you may have guessed, I'm not a coder and just copied the code to automate the clock. I'll repost the updated version 1.1 once I've made a few other changes so others can enjoy what has turned into a collaborative project. Mark

I've now attached the amended Fibonacci Clock, with changes to the code provided by bsalv and with a few amendments I've made to the layout. Thank you all for your help and roll on the next project Mark

Just some minor corrections Mark

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1