|
Post by slawyer on Aug 9, 2011 8:09:22 GMT -5
I wonder if you would share the formulas for stat and skill XP costs? I am working on a pet project to compute how much XP is needed to reach certain milestones of stats and skills.
|
|
|
Post by Cory Trese on Aug 9, 2011 9:51:25 GMT -5
It is already on the forum and in several places. When I get back to my docs I'll look it up if someone else hasn't already
|
|
|
Post by Cory Trese on Aug 9, 2011 11:20:05 GMT -5
|
|
|
Post by Cory Trese on Aug 9, 2011 14:57:29 GMT -5
i hope that helps
|
|
|
Post by slawyer on Aug 9, 2011 15:33:54 GMT -5
Thanks!
|
|
|
Post by slawyer on Aug 10, 2011 16:51:40 GMT -5
Hi,
The formula for calculating character level is working, except the starting stats for merchant, smuggler, pirate, bounty hunter, military officer, explorer, spy, and zealot are showing level 2 instead of level 1. It seems all those classes have starting stats/skills that add up to more than 56.
For example, for merchant I get:
15+9+9+9+1+6+6+1+1+1+1 = 59 total for the stats/skills (59 - 50)/6 + 1 = 9/6 + 1 = 1 + 1 = 2
Is there a fix up for level 1? It seems to be working great for my high level characters.
Thanks for your help!
|
|
|
Post by Cory Trese on Aug 10, 2011 16:56:06 GMT -5
Is there a fix up?
I'm not sure I understand what you mean. Do you want me to change the level equation?
|
|
|
Post by slawyer on Aug 11, 2011 16:17:42 GMT -5
No, I'm not requesting any change in the game; I'm just trying to understand why my results using the level formula are not the same as what I see in the game.
The formula isn't getting the same results as I see in the game for the starting stats and skills of those professions. The formula gets level 2 for those starting stats (since they add up to more than 55), but in the actual game when you start a new character with one of those professions, it shows level 1 for those starting stats and skills.
So the question is, when I plug in the starting stats and skills for, say, merchant as shown above, why do I get level 2 instead of level 1?
BTW, I assume the formula is supposed to count Strength and not count Stealth twice, so my code is actually using:
CharacterLevel = ((Quickness + Wisdom + Strength + Charisma + Negotiate + Intimidate + Pilot + Explorer + Warrior + Stealth + Tactics - 50) / PointsPerLevel) + 1;
Actually, since it is a cell formula in a spreadsheet, it is:
=FLOOR((SUM(C7:C10,C13:C19)-50)/6,1)+1
where the cells C7:C10 have stat values and C13:C19 have skill values. I don't think I'm using the FLOOR function incorrectly, but I guess that might be related.
Thanks again for your help!
|
|
|
Post by Cory Trese on Aug 11, 2011 23:12:35 GMT -5
More than likely Java and Excel are having different default behaviors? I will do some checking ASAP
|
|
|
Post by slawyer on Aug 13, 2011 10:13:23 GMT -5
I have copied it to a new Google spreadsheet to share and show what I mean: spreadsheets.google.com/spreadsheet/ccc?key=0AvbzA3uAE2OjdGlLbHBBSU1aaWljMzVFd2hMZ1hraGc&hl=en_USIf you copy the starting stats for one of those listed classes to the range C7:C19, you will see how it calculates those stats as level 2 instead of level 1, using the provided formula. I'm hoping you can explain how the code arrives at level 1 for those starting stats instead of level 2. It seems to work great for my higher level characters; I just can't figure out why it isn't working for level 1 stats on those starting professions.
|
|
|
Post by Cory Trese on Aug 13, 2011 12:44:44 GMT -5
I do not use Excel for my formula. I use Java. The formula I posted is an "integer assignment in Java" also you modified my formula.
This isn't going to work if you change the math and then ask why it doesn't work =)
|
|
|
Post by Cory Trese on Aug 13, 2011 12:45:09 GMT -5
public int CharacterLevel() { return ((Quickness + Wisdom + Stealth + Charisma + Negotiate + Intimidate + Pilot + Explorer + Warrior + Stealth + Tactics - 50) / PointsPerLevel) + 1; }
|
|
|
Post by Cory Trese on Aug 13, 2011 12:45:33 GMT -5
(Yes, Stealth is used twice. No, that isn't a mistake. K thx bye.)
|
|
|
Post by slawyer on Aug 13, 2011 15:49:10 GMT -5
Ah, that explains it. I keep Quickness, Strength, Stealth & Warrior highest for all my characters and raise them together, so the wrong formula was working for them but not for other cases where Stealth is different from Strength. I have fixed the spreadsheet and it works great now. Now I can move to the next step and implement a XP allocation planner! Severian is up to lvl 280 now. 67,600 turns (exactly 1300 years), 46,634 XP, $94,050,263, and still raging. He's had 3,877 encounters, 220 and 0 for hostile faction encounters, and his total kill count is at 1024 (about 1 every 66 turns). I wonder how far he can go before he'll be unable to go up against the high level NPCs.
|
|
|
Post by Cory Trese on Aug 15, 2011 21:16:23 GMT -5
Ah, that explains it. I keep Quickness, Strength, Stealth & Warrior highest for all my characters and raise them together, so the wrong formula was working for them but not for other cases where Stealth is different from Strength. I have fixed the spreadsheet and it works great now. Now I can move to the next step and implement a XP allocation planner! Severian is up to lvl 280 now. 67,600 turns (exactly 1300 years), 46,634 XP, $94,050,263, and still raging. He's had 3,877 encounters, 220 and 0 for hostile faction encounters, and his total kill count is at 1024 (about 1 every 66 turns). I wonder how far he can go before he'll be unable to go up against the high level NPCs. Ummmmm wow. Level 280? That is way farther than I have gone personally in the game. I sometimes let the simulator run up to level 300 but that's like 1 of 10,000 games that it survives that long. Impressive run =)
|
|