Squad xp calculator help (excel)

Here, I modified it a bit and made it so that only the data fields can be changed. It also will not be changed from the original when individuals enter their data.

Squad EXP Calculator Refurbished =P

Just wish I could figure out how to make it load in a edit-able format without having to click the button to make it so you can enter data.

Oh damnit, the public copy doesn't have the shading I added >.<

Traz - Dreamweaver wrote: »

We still haven't figured out a forumla for B6, but at least the rest are good.

(did i sink someone's battle ship yet?)

Yeah, I know there's a way to do it, I just can't seem to think of how atm.
Edited the sheet to give credit where it's due as well.

SylenThunder - Sanctuary wrote: »

Yeah, I know there's a way to do it, I just can't seem to think of how atm.
Edited the sheet to give credit where it's due as well.

We are still missing one thing. There is always a negative effect for bringing in someone 20 levels or more higher / lower to the squad. It seems to give the same effect in FC as if a level 103 was in squad. I think we need to add this into the formulas somewhere since we don't recognize this taking any negative effect. I know it says on wiki that the level modifier is ignored if there is a 20+ level range gap in the squad, but that would mean it's always 1.0. I know that's not that case becasue if I have a mid 90 in squad and bring in a 70- it will always nerf the experience further. I'm still trying to figure out how to incorporate that situation into the chart.

Traz - Dreamweaver wrote: »

We are still missing one thing. There is always a negative effect for bringing in someone 20 levels or more higher / lower to the squad. It seems to give the same effect in FC as if a level 103 was in squad. I think we need to add this into the formulas somewhere since we don't recognize this taking any negative effect. I know it says on wiki that the level modifier is ignored if there is a 20+ level range gap in the squad, but that would mean it's always 1.0. I know that's not that case becasue if I have a mid 90 in squad and bring in a 70- it will always nerf the experience further. I'm still trying to figure out how to incorporate that situation into the chart.

Can you post some actual values you encounter that show that the info on the wiki is wrong?

This is directly from the server configuration code.....

[MESMD_ADJUST]
# MOB_EXPERIENCE_SKILLPOINT_MONEY_DROP
base_offset	= 	-100 0.15 0    0    0
offset1		= 	-11  0.15 0    0    0
offset2		= 	-8   0.2  0.05 0.2  0.2
offset3		= 	-5   0.5  0.2  0.5  0.5
offset4		= 	-3   0.8  0.6  0.8  0.8
offset5		= 	3    1    1    1    1
offset6		= 	7    1    1    1    1
;max_offset 100

[TEAM_ADJUST]
teamexp0	=	1.0
teamsp0		=	1.0
teamexp1	=	1.0
teamsp1		=	1.0
teamexp2	=	1.2
teamsp2		=	1.2
teamexp3	=	1.3
teamsp3		=	1.3
teamexp4	=	1.4
teamsp4		=	1.4
teamexp5	=	1.5
teamsp5		=	1.5
teamexp6	=	1.6
teamsp6		=	1.6
teamexp7	=	1.7
teamsp7		=	1.7
teamexp8	=	1.8
teamsp8		=	1.8
teamexp9	=	1.9
teamsp9		=	1.9
teamexp10	=	2.0
teamsp10	=	2.0

maybe someone can make heads or tails out of it. It clearly shows what we already have with the squad exp split. not sure about that top section though. Not messing with my main server to find out, I'll set up a virutal box later.

CatManDoo - Dreamweaver wrote: »

try on B6 =vlookup(F6;Level difference multiplier tabel;2;FALSE), but u have to rewrite whole tabel. Note:Level difference multiplier tabel is array (atm H3:I15), or u can just select whole tabel and set name for that, then its like this =vlookup(F6;Name;2;FALSE)

like this
-40 0,05
-39 0,1
-38 0,1
-37 0,1
....
-29 0,15
and etc

u can hide this tabel anyway, so i guess rewriting is no big problem

Ninja'd while I did exactly this...

https://docs.google.com/spreadsheet/ccc?key=0AtOC-R4E8HQvdDBXLXluWGZiandJaF9FMmVOT191ZVE

Were you using Deicides for this testing? The max hp reduction from them could explain the 10% discrepancy.

From your data it looks like the level difference multiplier table has some errors. That table came from pwdatabase. The table says the multiplier for a player - mob level difference of 13 (101-88) should be 0.5 but you're encountering 0.45.

FULLY UPDATED VERSION

All of the changes that were needed to be made are now done and it's officially ready to be used to it's fullest.

Enjoy,
Traz

Paytah - Lost City wrote: »

looks great i love how you worked out the lvl difference multiplier b:victory

Don't speak to soon, all of us are trying to figure out if the new instance that is 10 person squad enabled will reflect the whole game or just that instance. If so more changes will be needed.

b:surrender

Traz - Dreamweaver wrote: »

FULLY UPDATED VERSION

All of the changes that were needed to be made are now done and it's officially ready to be used to it's fullest.

Enjoy,
Traz

Maybe I'm "slow," but what are you doing with the IF(AND) function in the base exp calculation? I think it has to do with ignoring the squad multiplier, but I'm just not seeing how it works. I mean, I understand the function I just don't see how it "ignores" the multiplier when the level range is 20+. It looks to me like the formula is ignoring the multiplier if the player level is between 0 and 20 as opposed to calculating the difference in the levels of the squad members.

Maybe I misunderstand the squad multiplier or...

Maybe I need to look at a prior version first to see how it changed. b:surrender