Log In

Your email is not your username

Register

If you were a member of the old Bodybuilding.com forums and would like to reuse your previous username, you can request it below. We use your email only for registration and do not store it. For more information, please see our Privacy Policy.

Confirm your email

A registration code was sent to your email. Enter it here.

Welcome

You have successfully setup your account.

Sign in

Quick Navigation Bottom Misc
Forum » Any of you boys good with Math? Need some help. (Intervals)
  1. Results 1 to 30 of 46
  2. Page 1 of 2
  3. 1
  4. 2
  6. Last

Thread: Any of you boys good with Math? Need some help. (Intervals)

post 1690837903 09-28-2023, 04:16 PM
-
#1
  1. DonVonDuck
  1. DonVonDuck
  3. Join Date: Aug 2013
  4. Posts: 8,749
  5. Rep Power: 40904

Any of you boys good with Math? Need some help. (Intervals)

I want to fill in the column between these two numbers, but I want the interval between the numbers to evenly progress as they go down.



You boys understand what I'm saying? I don't want even intervals; I want them to increase by an even amount as they go down towards 13.

Here's an example. The intervals are in parenthesis:


53
(0.5)
52.5
(1)
51.5
(1.5)
50
(2)
48
(2.5)
45.5
(3)
42.5
(3.5)
39
(4)
35
(4.5)
30.5
(5)
25.5
(5.5)
20
(6)
14



How would I go about calculating this for two fixed numbers?
R.I.P. Bert
post 1690838693 09-28-2023, 04:30 PM
-
#2
  1. jonmcd46
  2. Registered User
  1. jonmcd46
  2. Registered User
  3. Join Date: Sep 2012
  4. Location: United States
  5. Posts: 11,612
  6. Rep Power: 84813
A high schooler could figure this out...
I feel like this is a question on the SAT.
Am very drunk, but gonna try because I like you brb
post 1690838733 09-28-2023, 04:31 PM
-
#3
  1. Getter_done
  1. Getter_done
  3. Join Date: Dec 2008
  4. Posts: 138,191
  5. Subscribers: 6
  6. Rep Power: 1140615
In b4 the math miscer

But in the meantime

The answer is 3.50
post 1690838903 09-28-2023, 04:36 PM
-
#4
  1. DrewDarden
  1. DrewDarden
  3. Join Date: Nov 2016
  4. Posts: 23,029
  5. Subscribers: 5
  6. Rep Power: 508924
Originally Posted By Getter_done⏩
In b4 the math miscer

But in the meantime

The answer is 3.50
Misc Lifting Crew (Team Lead)
post 1690838913 09-28-2023, 04:36 PM
-
#5
  1. MrSchons
  2. Welsh Brah
  1. MrSchons
  2. Welsh Brah
  3. Join Date: Dec 2015
  4. Location: Wales, United Kingdom (Great Britain)
  5. Posts: 13,274
  6. Rep Power: 141586
I've got you OP

(DonVonCuck) + (Dale) + (Manjuice) = Don+1=Ass_Baby.piss_in_ass_supressed_vexation=true
post 1690838993 09-28-2023, 04:39 PM
-
#6
  1. Getter_done
  1. Getter_done
  3. Join Date: Dec 2008
  4. Posts: 138,191
  5. Subscribers: 6
  6. Rep Power: 1140615
Originally Posted By DrewDarden⏩
Lmao based! Nice voice too.
post 1690839023 09-28-2023, 04:39 PM
-
#7
  1. miscerForLulz
  1. miscerForLulz
  3. Join Date: Aug 2016
  4. Posts: 8,455
  5. Rep Power: 50878
thought this said integrals and was gonna say wolfram alpha

intervals? not understanding this question OP
2:136
Say, ˹O believers,˺ We believe in Allah and what has been revealed to us; and what was revealed to Abraham, Ishmael, Isaac, Jacob, and his descendants; what was given to Moses, Jesus, and other prophets from their Lord. We make no distinction between any of them. And to Allah we all submit.
post 1690839053 09-28-2023, 04:39 PM
-
#8
  1. DonVonDuck
  1. DonVonDuck
  3. Join Date: Aug 2013
  4. Posts: 8,749
  5. Rep Power: 40904
Originally Posted By DrewDarden⏩
That would be for an evenly spaced interval. The interval between every number would be the same if I took that route. That's not what I'm trying to do. I want the interval to progress evenly (see example above). In the example, each interval is 0.5 greater than the one above it.
R.I.P. Bert
post 1690839173 09-28-2023, 04:41 PM
-
#9
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
Highlight the two numbers, select the fill handle (little square in the corner) then drag to the empty boxes in the column.
BrosefMengele is my #1 fan.
post 1690839193 09-28-2023, 04:41 PM
-
#10
  1. DrewDarden
  1. DrewDarden
  3. Join Date: Nov 2016
  4. Posts: 23,029
  5. Subscribers: 5
  6. Rep Power: 508924
Originally Posted By DonVonDuck⏩
That would be for an even interval. That's not what I'm trying to do. I want the interval to progress evenly (see example above).
Oh my bad. I thought it seemed too easy. Yeah I'm not going to try that.

I'm an English guy not a math guy.
Misc Lifting Crew (Team Lead)
post 1690839313 09-28-2023, 04:44 PM
-
#11
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
I'm looking at it and can't decide if excel or sheets, but just in case, you can also use the formula =A1 + ($B$1 - $A$1) / (N - 1) where A1 is the cell your start number is in, B1 is the end number and N is the number of cells to fill
BrosefMengele is my #1 fan.
post 1690839453 09-28-2023, 04:48 PM
-
#12
  1. DonVonDuck
  1. DonVonDuck
  3. Join Date: Aug 2013
  4. Posts: 8,749
  5. Rep Power: 40904
Originally Posted By ZyraThornrise⏩
Highlight the two numbers, select the fill handle (little square in the corner) then drag to the empty boxes in the column.
Originally Posted By ZyraThornrise⏩
I'm looking at it and can't decide if excel or sheets, but just in case, you can also use the formula =A1 + ($B$1 - $A$1) / (N - 1) where A1 is the cell your start number is in, B1 is the end number and N is the number of cells to fill
I don't even know what you're saying, partner. I really don't.
R.I.P. Bert
post 1690839473 09-28-2023, 04:49 PM
-
#13
  1. MrSchons
  2. Welsh Brah
  1. MrSchons
  2. Welsh Brah
  3. Join Date: Dec 2015
  4. Location: Wales, United Kingdom (Great Britain)
  5. Posts: 13,274
  6. Rep Power: 141586
Originally Posted By ZyraThornrise⏩
I'm looking at it and can't decide if excel or sheets, but just in case, you can also use the formula =A1 + ($B$1 - $A$1) / (N - 1) where A1 is the cell your start number is in, B1 is the end number and N is the number of cells to fill
Or we could try please show bobs=true + please show vagene=true
post 1690839533 09-28-2023, 04:50 PM
-
#14
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
Originally Posted By DonVonDuck⏩
I don't even know what you're saying, partner. I really don't.
Let me make dinner and I'll do a screen record for you
I'm horrible at explaining things, sorry

Edit: What program are you using?
BrosefMengele is my #1 fan.
post 1690839733 09-28-2023, 04:53 PM
-
#15
  1. jonmcd46
  2. Registered User
  1. jonmcd46
  2. Registered User
  3. Join Date: Sep 2012
  4. Location: United States
  5. Posts: 11,612
  6. Rep Power: 84813
Originally Posted By ZyraThornrise⏩
I'm looking at it and can't decide if excel or sheets, but just in case, you can also use the formula =A1 + ($B$1 - $A$1) / (N - 1) where A1 is the cell your start number is in, B1 is the end number and N is the number of cells to fill
I'm not an excel expert, but it would probably be better if you tried it on excel, posted a link to the file to say its true. Because idk what that means exactly... and clearly no one else does
post 1690839793 09-28-2023, 04:54 PM
-
#16
  1. Ratfish
  1. Ratfish
  3. Join Date: Jul 2009
  4. Location: Portland, Oregon, United States
  5. Posts: 113,850
  6. Rep Power: 576095
i feel like u don't rly excel at this task, OPie
Make Europe Germany Again
post 1690839883 09-28-2023, 04:56 PM
-
#17
  1. BigGuyTruth
  2. Registered User
  1. BigGuyTruth
  2. Registered User
  3. Join Date: Mar 2023
  4. Age: 56
  5. Posts: 3,860
  6. Rep Power: 18732
Find the slope
post 1690840073 09-28-2023, 04:58 PM
-
#18
  1. outfoxxed
  2. Registered User
  1. outfoxxed
  2. Registered User
  3. Join Date: Jun 2010
  4. Location: Toronto, Ontario, Canada
  5. Posts: 22,267
  6. Rep Power: 86921
Is that excel?

Not sure how to do it in excel cause i don't use it often

But the formula should be value of previous column - 0.5 (n)

If i were to do it in excel I'd do it in 2 columns

For A1, put 0.5. B1 put 1. Then use the excel drag tool and drag it all the way down. That's your increment
post 1690840283 09-28-2023, 05:04 PM
-
#19
  1. outfoxxed
  2. Registered User
  1. outfoxxed
  2. Registered User
  3. Join Date: Jun 2010
  4. Location: Toronto, Ontario, Canada
  5. Posts: 22,267
  6. Rep Power: 86921
Originally Posted By ZyraThornrise⏩
I'm looking at it and can't decide if excel or sheets, but just in case, you can also use the formula =A1 + ($B$1 - $A$1) / (N - 1) where A1 is the cell your start number is in, B1 is the end number and N is the number of cells to fill
This shouldn't work.

Any programmer knows you're begging for a divide by zero error
post 1690840303 09-28-2023, 05:04 PM
-
#20
  1. Ratfish
  1. Ratfish
  3. Join Date: Jul 2009
  4. Location: Portland, Oregon, United States
  5. Posts: 113,850
  6. Rep Power: 576095
Originally Posted By BigGuyTruth⏩
Find the slope
prolly somewhere getting mogged by a hairy prozzie
Make Europe Germany Again
post 1690840423 09-28-2023, 05:07 PM
-
#21
  1. AdvancedDreamer
  2. Registered Retard
  1. AdvancedDreamer
  2. Registered Retard
  3. Join Date: Nov 2014
  4. Posts: 12,955
  5. Rep Power: 91053
People still not using chatgpt lmao:

You can use a single formula to calculate the value for any column 'n' between your start number 'Start' and end number 'End' with 29 empty columns in between. Here's the formula:

Value at column n = Start + (n / 30) * (End - Start)

In this formula:

- 'n' is the position of the empty column, starting from 1 for the first empty column and increasing by 1 for each subsequent column.
- 'Start' is your starting number.
- 'End' is your ending number.
- The division by 30 evenly spreads the values between the start and end over the 29 empty columns.

For example, if your start number is 10 and your end number is 100, and you want to calculate the value for the 5th empty column:

Value at column 5 = 10 + (5 / 30) * (100 - 10) = 10 + (5 / 30) * 90 = 10 + (1/6) * 90 = 10 + 15 = 25

This formula will give you the value for any column between the start and end numbers with an even progression.
post 1690840543 09-28-2023, 05:09 PM
-
#22
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
Originally Posted By outfoxxed⏩
This shouldn't work.

Any programmer knows you're begging for a divide by zero error


OP, I'll just send you the file if you want it


Edit: Write the formula =A1 + ($A$31 - $A$1) / (30) into the first empty cell, then drag the formula down to the rest of them
BrosefMengele is my #1 fan.
post 1690840743 09-28-2023, 05:15 PM
-
#23
  1. MrSchons
  2. Welsh Brah
  1. MrSchons
  2. Welsh Brah
  3. Join Date: Dec 2015
  4. Location: Wales, United Kingdom (Great Britain)
  5. Posts: 13,274
  6. Rep Power: 141586
Originally Posted By ZyraThornrise⏩


OP, I'll just send you the file if you want it


Edit: Write the formula =A1 + ($A$31 - $A$1) / (30) into the first empty cell, then drag the formula down to the rest of them
Please send bobs_vagene.jpg
post 1690840793 09-28-2023, 05:16 PM
-
#24
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
Originally Posted By AdvancedDreamer⏩
People still not using chatgpt lmao:

You can use a single formula to calculate the value for any column 'n' between your start number 'Start' and end number 'End' with 29 empty columns in between. Here's the formula:

Value at column n = Start + (n / 30) * (End - Start)

In this formula:

- 'n' is the position of the empty column, starting from 1 for the first empty column and increasing by 1 for each subsequent column.
- 'Start' is your starting number.
- 'End' is your ending number.
- The division by 30 evenly spreads the values between the start and end over the 29 empty columns.

For example, if your start number is 10 and your end number is 100, and you want to calculate the value for the 5th empty column:

Value at column 5 = 10 + (5 / 30) * (100 - 10) = 10 + (5 / 30) * 90 = 10 + (1/6) * 90 = 10 + 15 = 25

This formula will give you the value for any column between the start and end numbers with an even progression.
Jesus, this confused me even more and I already knew the formula lol
BrosefMengele is my #1 fan.
post 1690841003 09-28-2023, 05:20 PM
-
#25
  1. outfoxxed
  2. Registered User
  1. outfoxxed
  2. Registered User
  3. Join Date: Jun 2010
  4. Location: Toronto, Ontario, Canada
  5. Posts: 22,267
  6. Rep Power: 86921
Originally Posted By ZyraThornrise⏩


OP, I'll just send you the file if you want it


Edit: Write the formula =A1 + ($A$31 - $A$1) / (30) into the first empty cell, then drag the formula down to the rest of them
Didn't realize for n = 1 that n actually equals 30
post 1690841053 09-28-2023, 05:22 PM
-
#26
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
Originally Posted By outfoxxed⏩
Didn't realize for n = 1 that n actually equals 30
Number of cells you want to fill minus 1
You can also write it as 31-1 and it'll function the same but I got lazy lol
BrosefMengele is my #1 fan.
post 1690841473 09-28-2023, 05:30 PM
-
#27
  1. jonmcd46
  2. Registered User
  1. jonmcd46
  2. Registered User
  3. Join Date: Sep 2012
  4. Location: United States
  5. Posts: 11,612
  6. Rep Power: 84813
Zyra you did well, but that wasn't the solultion OP was looking for...
he doesn't want a linear progression...
post 1690841633 09-28-2023, 05:35 PM
-
#28
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  1. ZyraThornrise
  2. is_woman = lambda: "thot"
  3. Join Date: Jun 2014
  4. Location: Minnesota, United States
  5. Posts: 10,915
  6. Rep Power: 98800
Originally Posted By jonmcd46⏩
Zyra you did well, but that wasn't the solultion OP was looking for...
he doesn't want a linear progression...
Ah fukk. I read evenly spaced and blanked the rest
You're right

I'm still cooking but I'll figure it out in a moment
BrosefMengele is my #1 fan.
post 1690841963 09-28-2023, 05:43 PM
-
#29
  1. DuracellBunny
  2. Has new batteries!
  1. DuracellBunny
  2. Has new batteries!
  3. Join Date: Nov 2005
  4. Posts: 15,594
  5. Rep Power: 201320
just adapt factorials.

You would use n(n+1)/2 = x to add up integers

You already know what x would be (the total gain, which is 31) and you know how many steps you want (31), so you just have to apply a coefficient to the integer values, y.

y31(32)/2=31
y=1/16

so you get

13
13 + 1/16
13 + 1/16 + 2/16
13 + 1/16 + 2/16 + 3/16
etc

Edit, I misread and it's 21 not 31 so it would be

y31(32)/2=21
y = 42/992

so
13
13 + 42/992
13 + 42/992 + 2x42/992
13 + 42/992 + 2x42/992 + 3x42/992
etc
Screw nature; my body will do what I DAMN WELL tell it to do!

The only dangerous thing about an exercise is the person doing it.

They had the technology to rebuild me. They made me better, stronger, faster......
post 1690842813 09-28-2023, 06:07 PM
-
#30
  1. MustardTiger17
  1. MustardTiger17
  3. Join Date: Dec 2012
  4. Location: United States
  5. Posts: 38,603
  6. Subscribers: 7
  7. Rep Power: 238919
How about no
Not in the AM
  1. Page 1 of 2
  2. 1
  3. 2
  5. Last
Quick Navigation Top Misc
Bookmarks
Digg.com
Digg
del.icio.us
del.icio.us
Stumbleupon.com
StumbleUpon
Google.com
Google
Facebook.com
Facebook
Posting Permissions
  1. You may not post new threads
  2. You may not post replies
  3. You may not post attachments
  4. You may not edit your posts