Author Topic: Someone who is smarter than me  (Read 8801 times)

Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Someone who is smarter than me
« on: August 15, 2011, 11:38:32 pm »
For the life of me I can't remember what this is called.  I believe there is a formula to represent it.

Lets say I have a range of numbers or steps

1 - 100

Each step adds value of 25

With an initial value of 50.

So
Step 1 = 50
Step 2 = 75
Step 3 = 100
Step 4 = 125
Step 5 = 150
And so on

What is that called? 

Offline Irish_Alley

  • Tim
  • Senior Member
  • ****
  • Posts: 13333
  • Family is not an important thing. It's everything.
Re: Someone who is smarter than me
« Reply #1 on: August 16, 2011, 12:04:59 am »
you mean like a "number sequence pattern"
If you can’t tell yourself the truth, who can you tell it to?~Irish_Alley

When you have eliminated the impossible, whatever remains, however improbable, must be the truth ~Sherlock Holmes

Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Re: Someone who is smarter than me
« Reply #2 on: August 16, 2011, 12:06:54 am »
you mean like a "number sequence pattern"
YES!  Let try something. 

Offline Irish_Alley

  • Tim
  • Senior Member
  • ****
  • Posts: 13333
  • Family is not an important thing. It's everything.
Re: Someone who is smarter than me
« Reply #3 on: August 16, 2011, 12:06:59 am »
If you can’t tell yourself the truth, who can you tell it to?~Irish_Alley

When you have eliminated the impossible, whatever remains, however improbable, must be the truth ~Sherlock Holmes

Offline Irish_Alley

  • Tim
  • Senior Member
  • ****
  • Posts: 13333
  • Family is not an important thing. It's everything.
Re: Someone who is smarter than me
« Reply #4 on: August 16, 2011, 12:08:10 am »
what are we going to try ;)
If you can’t tell yourself the truth, who can you tell it to?~Irish_Alley

When you have eliminated the impossible, whatever remains, however improbable, must be the truth ~Sherlock Holmes

Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Re: Someone who is smarter than me
« Reply #5 on: August 16, 2011, 12:11:09 am »
what are we going to try ;)
Trying to write this in excel

Offline Irish_Alley

  • Tim
  • Senior Member
  • ****
  • Posts: 13333
  • Family is not an important thing. It's everything.
Re: Someone who is smarter than me
« Reply #6 on: August 16, 2011, 12:12:31 am »
write what
If you can’t tell yourself the truth, who can you tell it to?~Irish_Alley

When you have eliminated the impossible, whatever remains, however improbable, must be the truth ~Sherlock Holmes

Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Re: Someone who is smarter than me
« Reply #7 on: August 16, 2011, 12:13:57 am »
I want to map this in excel, using the example in the OP

Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Re: Someone who is smarter than me
« Reply #8 on: August 16, 2011, 12:14:32 am »

Offline 1980c10

  • Senior Member
  • ****
  • Posts: 1205
Re: Someone who is smarter than me
« Reply #9 on: August 16, 2011, 12:23:51 am »
If you need a formula
try this;
50+(25 x's (Step#-1)) = X

Substitute values as needed. If this is homework use proper symbols and letters to represent the equation.

Offline 1980c10

  • Senior Member
  • ****
  • Posts: 1205
Re: Someone who is smarter than me
« Reply #10 on: August 16, 2011, 12:26:35 am »
If you need a formula
try this;
50+(25 x's (Step#-1)) = X

Substitute values as needed. If this is homework use proper symbols and letters to represent the equation.


Ok still use this in the same format just reference cells where you enter your values with the "$" symbol

Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Re: Someone who is smarter than me
« Reply #11 on: August 16, 2011, 12:28:51 am »
Okay, I am closer, but here is the issue -
Using a growth trend I can quickly see that step 100 will equal 2525.  But now I need to show the total value spent per step.

50
75 =125
100 = 225
125 = 350
150 = 500
175 = 675

and so on.


Offline reload

  • Registered Users
  • *
  • Posts: 117
    • K & K Innovations
Re: Someone who is smarter than me
« Reply #12 on: August 16, 2011, 12:31:14 am »
Its not homework, well sorta.  I want the values to project total time to total cost.  Sadly this is for game, I am trying to figure out based on a absolute income how much and how long it will take to achieve the goal; that is step 100.

It also doesn't help that I am fighting my ambien to figure this out  :P

Offline 1980c10

  • Senior Member
  • ****
  • Posts: 1205
Re: Someone who is smarter than me
« Reply #13 on: August 16, 2011, 12:34:45 am »
try to use a "linear" trend as this is a linear equation.
Or post back your formula and maybe someone can fix it.

Offline 1980c10

  • Senior Member
  • ****
  • Posts: 1205
Re: Someone who is smarter than me
« Reply #14 on: August 16, 2011, 12:40:50 am »
You also need to enter a "min" and "max" for 1-100 to be to get a n/a value outside of the parameters if you want to be technical about it, otherwise don't worry about it.