+ Reply to Thread
Results 1 to 15 of 15

Fibonacci Clock in Excel with a multitude of options

  1. #1
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2

    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
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    727

    Re: Fibonacci Clock in Excel with a multitude of options

    add in thisworkbook
    Please Login or Register  to view this content.
    delete 1st line in module1 "private sub work..."
    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2
    Quote Originally Posted by bsalv View Post
    add in thisworkbook
    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. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Fibonacci Clock in Excel with a multitude of options

    Instead of

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

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



  5. #5
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2
    Quote Originally Posted by snb View Post
    Instead of

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

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

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,244

    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.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  7. #7
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Fibonacci Clock in Excel with a multitude of options

    I'd prefer a few VBA-lines.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2

    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. #9
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2

    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. #10
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2

    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
    Last edited by Mark Millett; 11-16-2021 at 08:31 PM.

  11. #11
    Valued Forum Contributor
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    727

    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.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2

    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. #13
    Valued Forum Contributor
    Join Date
    01-25-2011
    Location
    Belgium, Alveringem
    MS-Off Ver
    Excel 2003, 2007, 365
    Posts
    727

    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
    Attached Images Attached Images

  14. #14
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    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.
    Last edited by snb; 11-17-2021 at 05:51 AM.

  15. #15
    Registered User
    Join Date
    11-15-2021
    Location
    London, England
    MS-Off Ver
    MS 2013
    Posts
    2

    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
    Attached Files Attached Files
    Last edited by Mark Millett; 11-26-2021 at 05:23 PM. Reason: Adding updated attachment

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Function to help generate sentences from a multitude of options?
    By Tykuhn42 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2018, 05:08 PM
  2. Function to help generate sentences from a multitude of options?
    By Tykuhn42 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2018, 12:05 AM
  3. Fibonacci Clock in Excel
    By teylyn in forum The Water Cooler
    Replies: 2
    Last Post: 05-11-2015, 11:13 AM
  4. Fibonacci function/command in excel?...tia sal
    By in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. Fibonacci function/command in excel?...tia sal
    By in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 11:05 PM
  6. [SOLVED] Fibonacci function/command in excel?...tia sal
    By in forum Excel General
    Replies: 1
    Last Post: 06-07-2005, 02:05 PM

Tags for this Thread

Bookmarks

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