[Solved] Birthday spanks

Discuss the spreadsheet application

[Solved] Birthday spanks

Postby RusselB » Sat Nov 16, 2019 11:59 pm

OK, I think this is one of the weirdest questions I've been asked to solve, and I know how to do it the long way, but was wondering if there was a formula to calculate this.
Specifically the number of birthday spanks a person would have received by a certain date.
Eg: Person born Feb 10 1965 would have received X birthday spanks (presuming from one person) by Feb 10, 2020 (ie: 55th birthday).
The long way of doing this, if I'm not mistaken, would be
Code: Select all   Expand viewCollapse view
=45*5+100*(1+2+3+4)+50*6+1+2+3+4+5
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5667
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Birthday spanks

Postby robleyd » Sun Nov 17, 2019 12:33 am

That's a custom I've not heard of before; but a quick web search enlightened me :lol:

According to StackExchange you can do this - summing n consecutive numbers - as follows.

Take the average of the first number and the last number, and multiply by the number of numbers.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Birthday spanks

Postby RusselB » Sun Nov 17, 2019 12:42 am

Thanks. I tried to do a web search but guess I was using the wrong terms, as I was either getting nothing or millions of responses... and I didn't want to try looking through that.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5667
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: [Solved]Birthday spanks

Postby robleyd » Sun Nov 17, 2019 1:05 am

You're welcome. I used the Duck with the term calculate sum of n successive numbers formula but should have used consecutive instead of successive; however I got the answer.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3057
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests