So I'm working on putting together a spreadsheet for my characters to assist me in determining what to train in as I level up (yes, I'm aware there's already a great one out there, but I'm learning Excel and figured this would be a good way to practice). I got to the section where I enter in my skills and wanted to make the spreadsheet automatically calculate the skill bonus off skill ranks, but I can't find anything more then a section on the officials saying it starts as +5 per ranks and eventually goes down to +1 per rank (oddly, skill bonuses aren't mentioned on the Skills page for Krakii at all and don't have their own page that I can find).

I know that eventually the skill bonus equals the number of ranks +100, but that doesn't help me with the lower number of ranks. Does anyone know the ranges for +5, +4, etc?

Starchitin

A severed gnomish hand crawls in on its fingertips and makes a rude gesture before quickly decaying and rotting into dust. A gust of wind quickly scatters the dust.

I always did it as nested @if statements:
- if #rankcell >=40, then skillcell = #rankcell+100
- if #rankcell >30, then skillcell = 120 + ((#rankcell-30)*2)
- if #rankcell >20, then skillcell = 90 + ((#rankcell-30)*3)
- if #rankcell >10, then skillcell = 50 + ((#rankcell-30)*4)
- otherwise, skillcell = #rankcell*5

Just make sure you're closing the correct set of parentheses, and you'll be fine.

You are welcome to pull whatever you need from the current spreadsheet as well. Honestly I am not talented enough to update it for Excel 2013.

Keith/Brinret/Shiun

Be nice to Wyrom or I will cut you!

I was more thinking of digging through for formulas for things rather than the code. Either way good luck on your project.

Keith/Brinret/Shiun

Be nice to Wyrom or I will cut you!

As far as putting it on the wiki that shall not be named...

I always just thought about it like this:

The first ten ranks	(1-10)	+5 each
The next ten ranks	(11-20)	+4 each
The next ten ranks	(21-30)	+3 each
The next ten ranks	(31-40)	+2 each
All the other ranks	(41+)	+1 each

That approach is no where near as nice for a quick calculation like the formulae above, but as far as an intuitive table for looking at, perhaps the most clear visualization.

---

>Kayse scrambles to avoid being sucked into the void!