+ Reply to Thread
Results 1 to 5 of 5

help calculating how many days take a number to double (or triple)

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Spain
    MS-Off Ver
    Excel Mac 2008
    Posts
    14

    help calculating how many days take a number to double (or triple)

    Hi,
    I'm working for a regional newspaper in Spain and my Excel knowledge is a bit limited.

    We have an excel with Coronavirus daily cases for several geographic divisions (regions, countries...)
    It follows this structure (I apologize, but the button to attach a file doesn't allow me to upload):
    Place 8/3/20 9/3/20 10/3/20
    Andalucía 35 54 71
    Aragón 13 13 38
    Asturias 7 7 28
    Baleares 8 11 13

    Is there a formula that can help us to discover how long does it take to [double|triple|etc] the number of cases (a growth rate)?

    So, as in the small example above, in the line "Andalucía" first number of cases is "35". We want to see how many days it takes to double (8/3/20 is 35; double is 70 >> the first day that there is a number that is equal or bigger than the double is 10/3/20, so the result is 2 (days))

    Or in the line "Asturias", if we want to see how long does it takes to triple, from the first day "7" it takes 2 days to do it.

    I don't know if my explanation is clear. Sorry for my English.

    Also, I don't know if our approach is correct.
    I see in here (https://ourworldindata.org/coronavirus) that they do the calculation from the present day backwards.

    Any help will be welcome.

    Thanks in advance.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: help calculating how many days take a number to double (or triple)

    It's a simple enough calculation but depends on the period you're interested in and indeed the statistic.
    I presume you will be adding the statistics each day and will be building up a continued series.
    So If today your base date is 8/3/2020, tomorrow do you want to use a new base date of 9/3/2020?

    Perhaps a more interesting statistic is the cumulative growth %

    In the attached I've added an example of both. Let me know where yuo may want this refining to meet your precise reqirements.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    11-21-2012
    Location
    Spain
    MS-Off Ver
    Excel Mac 2008
    Posts
    14

    Re: help calculating how many days take a number to double (or triple)

    Thank you, Richard
    Yes, unfortunately we 'll need to keep updating the statistics for a long time.

    Your reply is exactly what we need, according to what the editor is asking for. More than a percentage number, that could be more abstract, better a period of time in which the figures multiply (x2, x3...)

    Maybe the only thing we can play with is calculating it backwards: if today the number is, i.e., 568, how many days has take to FACTOR (double, triple).
    I'm trying to modify your formula to achieve that, but I'm not managing to do it. I'll keep trying.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: help calculating how many days take a number to double (or triple)

    I've revised the layout and added a new sheet

    This allows you to plug a factor into B2 and have the results change

    The data of course is simply test data and you'll need to plug in your own results.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-21-2012
    Location
    Spain
    MS-Off Ver
    Excel Mac 2008
    Posts
    14

    Re: help calculating how many days take a number to double (or triple)

    Thank you again, Richard
    This is very helpful. And I realize that I have to learn Excel seriously

+ 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. Need help on calculating number of days between 2 days W.R.T different criterias
    By Vikramchetan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-27-2019, 08:16 AM
  2. [SOLVED] to detect double and triple strings last digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-11-2019, 03:09 PM
  3. DAYS function: correctly calculating the number of days
    By dadpad in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-25-2015, 09:18 PM
  4. Calculating number of days
    By excelquestionz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2015, 02:08 PM
  5. calculating the number of days
    By Deanomcbeano in forum Excel General
    Replies: 12
    Last Post: 10-02-2012, 08:22 AM
  6. Replace 'Double or Triple Spaces
    By hardeep.kanwar in forum Word Formatting & General
    Replies: 2
    Last Post: 07-19-2010, 02:30 AM
  7. [SOLVED] Calculating number of days
    By Carlos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-01-2005, 05:06 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