cheeseburger

2010-01-16, 11:09 AM

i'm looking for a formula to calculate level by entering xp in my character sheet in excel. help if you know how pls and ty :D

View Full Version : Excel help for gaming

cheeseburger

2010-01-16, 11:09 AM

i'm looking for a formula to calculate level by entering xp in my character sheet in excel. help if you know how pls and ty :D

Assassin89

2010-01-16, 11:21 AM

Look in the PBH for the xp charts, and base your formula on that. I forget the mathematical expression for adding consecutive numbers, although that would be a start.

Duos Greanleef

2010-01-16, 11:23 AM

*is working on something right now*

brb

SO I came up with nothing.

My Excel Fu is weaker than I thought.

Considering that this is not my area of expertise, nor of immediate concern for me, I concede.

brb

SO I came up with nothing.

My Excel Fu is weaker than I thought.

Considering that this is not my area of expertise, nor of immediate concern for me, I concede.

bosssmiley

2010-01-16, 11:26 AM

I nominate this thread as poster child for: "You know your game of choice is too complicated when..."

Isn't it CR*100 with Character Level/Monster CR as a multiplier function?

(I dunno. I stopped following what was going on in maths lessons about the time the numbers all turned into greek letters :smallwink: )

Isn't it CR*100 with Character Level/Monster CR as a multiplier function?

(I dunno. I stopped following what was going on in maths lessons about the time the numbers all turned into greek letters :smallwink: )

Duos Greanleef

2010-01-16, 11:30 AM

I nominate this thread as poster child for: "You know your game of choice is too complicated when..."

Here here!

Here here!

Reinboom

2010-01-16, 12:03 PM

=SUMPRODUCT(ROW(INDIRECT("A1:A"&A1))-1)*1000

This should work in both openoffice calc and microsoft excel.

Edit:

To explain, sumproduct(row(indirect("reference"))) basically creates sigma/summation function, where the start (i) is adjusted by referencing row's result.

"A1:A"&A1 refers to what you want to hold the limit number (usually "n" or "k" in most notations, the number above the sigma)

To make this, say, "B3", change it to "B3:B"&B3

-1 is because, it needs to offset this by 1 level (level 1 is 0 experience).

Ah, and *1000 should be obvious.

I'm trying to work this into what you actually want.

So, with what I gave, you stick the level into A1 and you get the experience required to reach it.

I'm trying to work this into what you actually want.

This should work in both openoffice calc and microsoft excel.

Edit:

To explain, sumproduct(row(indirect("reference"))) basically creates sigma/summation function, where the start (i) is adjusted by referencing row's result.

"A1:A"&A1 refers to what you want to hold the limit number (usually "n" or "k" in most notations, the number above the sigma)

To make this, say, "B3", change it to "B3:B"&B3

-1 is because, it needs to offset this by 1 level (level 1 is 0 experience).

Ah, and *1000 should be obvious.

I'm trying to work this into what you actually want.

So, with what I gave, you stick the level into A1 and you get the experience required to reach it.

I'm trying to work this into what you actually want.

Pharaoh's Fist

2010-01-16, 12:05 PM

What excellent advice.

ericgrau

2010-01-16, 12:46 PM

level(level-1)/2*1000 = xp (formula for adding [0 to n - 1] * 1000)

level^2 * 500 - level * 500 = xp

level^2 * 500 - level * 500 - xp = 0

level = (500 +/- (500^2 + 4 * 500 * xp)^0.5) / (2 * 500) (quadratic formula)

level = (500 +/- (500^2 + 2000 * xp)^0.5) / 1000

"-" doesn't work, so the real answer is:

level = (500 + (500^2 + 2000 * xp)^0.5) / 1000

And since level 3.9 is still level 3:

level = ROUNDDOWN((500 + (500^2 + 2000 * xp)^0.5) / 1000, 0)

Here's what you punch in Excel, replacing "xp" for the right cell:

= ROUNDDOWN((500 + (500^2 + 2000 * xp)^0.5) / 1000, 0)

And yes... I just applied two mathematical formulas to D&D.

level^2 * 500 - level * 500 = xp

level^2 * 500 - level * 500 - xp = 0

level = (500 +/- (500^2 + 4 * 500 * xp)^0.5) / (2 * 500) (quadratic formula)

level = (500 +/- (500^2 + 2000 * xp)^0.5) / 1000

"-" doesn't work, so the real answer is:

level = (500 + (500^2 + 2000 * xp)^0.5) / 1000

And since level 3.9 is still level 3:

level = ROUNDDOWN((500 + (500^2 + 2000 * xp)^0.5) / 1000, 0)

Here's what you punch in Excel, replacing "xp" for the right cell:

= ROUNDDOWN((500 + (500^2 + 2000 * xp)^0.5) / 1000, 0)

And yes... I just applied two mathematical formulas to D&D.

Nich_Critic

2010-01-16, 12:52 PM

I have this:

=FLOOR(SQRT((EXP+125)/500)+0.5; 1)

From my character sheet in open office.

=FLOOR(SQRT((EXP+125)/500)+0.5; 1)

From my character sheet in open office.

Lorn

2010-01-16, 12:53 PM

... would a simple lookup on another sheet not work and, at the same time, be incredibly simple to create?

(Not hugely familiar with the XP needed per level...)

Basically, Sheet 1 would be the standard character sheet.

Sheet 2, meanwhile, would contain a table. One column would be XP. The other would be level. This would be grouped together.

On Sheet 1, again, create the Lookup in reference to the XP cell and that would return your level.

If that makes sense?

(Not hugely familiar with the XP needed per level...)

Basically, Sheet 1 would be the standard character sheet.

Sheet 2, meanwhile, would contain a table. One column would be XP. The other would be level. This would be grouped together.

On Sheet 1, again, create the Lookup in reference to the XP cell and that would return your level.

If that makes sense?

ericgrau

2010-01-16, 12:58 PM

I have this:

=FLOOR(SQRT((EXP+125)/500)+0.5; 1)

From my character sheet in open office.

That's basically the same formula as mine, but you must replace ";" with "," in Excel (and "EXP" with the right cell, of course). Which is Open Office's biggest failing: it's not remotely compatible with Excel, even though it pretends to be. This formula scares me because it means someone else actually employed the quadratic formula in a D&D character sheet. He even took the time to simplify his formula, even though Excel doesn't care. Beware of us nerds, we have a community and shall come play in your games and apply complex algebra.

Btw, just copy paste either formula into Excel and you're done. That's a lot easier than any kind of lookup formula.

=FLOOR(SQRT((EXP+125)/500)+0.5; 1)

From my character sheet in open office.

That's basically the same formula as mine, but you must replace ";" with "," in Excel (and "EXP" with the right cell, of course). Which is Open Office's biggest failing: it's not remotely compatible with Excel, even though it pretends to be. This formula scares me because it means someone else actually employed the quadratic formula in a D&D character sheet. He even took the time to simplify his formula, even though Excel doesn't care. Beware of us nerds, we have a community and shall come play in your games and apply complex algebra.

Btw, just copy paste either formula into Excel and you're done. That's a lot easier than any kind of lookup formula.

cheeseburger

2010-01-16, 10:15 PM

thanks guys for the replies, i'm gonna see if i can ungibberish these replies enough to use them. Because i'm not as excel savvy as it appears you guys are, but i'm gonna definitely try!! tyvm :D

Powered by vBulletin® Copyright © 2020 vBulletin Solutions, Inc. All rights reserved.