## [Solved] Exponential growth

Discuss the spreadsheet application

### [Solved] Exponential growth

Hi room,
anyone have idea how do do the formula to find out:-
how to do the penny double the amount every day project. like
day 1==1 penny
day 2==2 penny
day 3== 4 penny
day 4== 8penny
day 5== 16penny
Last edited by Hagar Delest on Sat Jan 27, 2018 7:50 pm, edited 3 times in total.
Reason: tagged [Solved].
open office 4.15,
windows 7
elvis35to05

Posts: 5
Joined: Fri Jan 19, 2018 5:47 pm

### Re: exponential growth

In cell A1 enter 1; in cell A2 enter "=A1*2" (no quotes). Select cell A2 by clicking on it, and pull down using the little black dot on bottom right corner of the selected cell.
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP

RoryOF
Moderator

Posts: 28157
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

### Re: expotential growth

And if you want to enter the number of days passed, and just calculate for that day, you just ...

... oops, just a thought: Are we doing schoolwork for you?

Just in case, for starters I only give you something to tease your memory: There is a math operation that says "multiply number by itself n times". You need to find the number to multiply by itself, and the operation in question.

If you promise that you really need the answer for some other work and it is not something you are supposed to learn, you will get the solution spelled out. We'll trust your word.

keme
Volunteer

Posts: 3047
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

### Re: exponential growth

penny = 2^(day-1)
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

Zizi64
Volunteer

Posts: 7702
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

### Re: Exponential growth

Thanks for your help,RoryOF, keme, and Zizi64, much appreciated.

keme, No its not school work lol, i,m 70yrs old next month, i was just curious about the question of if you would take a million pounds or a penny doubled for one month.
open office 4.15,
windows 7
elvis35to05

Posts: 5
Joined: Fri Jan 19, 2018 5:47 pm

### Re: Exponential growth

elvis35to05 wrote:Thanks for your help,RoryOF, keme, and Zizi64, much appreciated.

keme, No its not school work lol, i,m 70yrs old next month, i was just curious about the question of if you would take a million pounds or a penny doubled for one month.

Your first post, asking a typical math assignment from class, so I had to ask. Sorry that the revelation was delayed. I hope you didn't lose millions because of that.

keme
Volunteer

Posts: 3047
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

### Re: Exponential growth

elvis35to05 wrote:Thanks for your help,RoryOF, keme, and Zizi64, much appreciated.

keme, No its not school work lol, i,m 70yrs old next month, i was just curious about the question of if you would take a million pounds or a penny doubled for one month.

If you find out how to do this, please let us know!
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP

RoryOF
Moderator

Posts: 28157
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

### Re: Exponential growth

Hi room
i used formula from RoryOF,
it was just a curiosity of mine, i hope i did it right.
thanks for your help.
the question was you get a penny a day doubling every day for 31 days i get
3,221,225,471. pennies
32,212,254.71 pounds
open office 4.15,
windows 7
elvis35to05

Posts: 5
Joined: Fri Jan 19, 2018 5:47 pm

### Re: Exponential growth

Even if I double the first penny already on day 1 of january, I only get 21 474 836.48 £ at the end of 31 january. I'm feeling so poor. What did I wrong?
On Windows 10: LibreOffice 6.1 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Let's create a powerful UFO: United Free Office!
Lupp from München

Lupp
Volunteer

Posts: 2310
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

### Re: Exponential growth

hi Lupp,
so far except for a penny you got same as me,
this is the total for 30 days but you add the amount from day 31 to what you have.
open office 4.15,
windows 7
elvis35to05

Posts: 5
Joined: Fri Jan 19, 2018 5:47 pm

### Re: Exponential growth

@ Lupp
Same here. Perhaps short term exchange rate problems?
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer

Posts: 3628
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

### Re: Exponential growth

How will we spend all this money?
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP

RoryOF
Moderator

Posts: 28157
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

### Re: Exponential growth

hi RoryOF ,
if only ha ha, we would have a great life.
thanks
open office 4.15,
windows 7
elvis35to05

Posts: 5
Joined: Fri Jan 19, 2018 5:47 pm

### Re: Exponential growth

How will we spend all this money?
I would surely advertise in TV. What about "Rory for PM!"?
On Windows 10: LibreOffice 6.1 and older versions, PortableOpenOffice 4.1.5 and older, StarOffice 5.2
---
Let's create a powerful UFO: United Free Office!
Lupp from München

Lupp
Volunteer

Posts: 2310
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

### Re: Exponential growth

elvis35to05 wrote:Hi room
i used formula from RoryOF,
...
the question was you get a penny a day doubling every day for 31 days i get
...

If you add the amounts up, it is a slightly different formula. Just remove the parenthesis.
Code: Select all   Expand viewCollapse view
`penny = 2^day-1`

That will take care of the one-day offset and one penny difference.

keme
Volunteer

Posts: 3047
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

### Re: Exponential growth

elvis35to05 wrote:
Hi room
i used formula from RoryOF,
...
the question was you get a penny a day doubling every day for 31 days i get
...

If you add the amounts up, it is a slightly different formula. Just remove the parenthesis.

Code: Select all Expand view
penny = 2^day-1

That will take care of the one-day offset and one penny difference.

In my opinion the difference _is_ inside the perentheses:

penny = day^(day-1) ... if you started (with 1 penny) on the first day (day 1).
penny = day^(day) ... if you started on the 0th day.

The difference is not negligible
Please send me the amount of the positive difference...
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.5 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.

Zizi64
Volunteer

Posts: 7702
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary