eBE Top 100 live updated list...

http://tiny.cc/eBeTOP100

Enjoy :-)

Stats will be correct only after 24h, as it needs 2 days of stats to give accurate datas...

I took the top100 citizen from the old MU list, so stats will only be updated for these 100 guys...

(so no one can enter the top100, i will have to update it manually, but all the stats from these 100 players are updated once day automatically).

I am pretty sure I did more than zero damage yesterday

So no sorting? Was hoping to see how many spots I jumped, but still at 41

not wanting to sound like a complete idiot but what does q0 and q6 mean?

q0: value of the damage done with a single hit without gun
q6: value of the damage done with a single hit with q6 gun

dmg with no weapon, and damage with Q6 weap...

and the dmg column will be only accurate after 24h, at it requite datas at day change and datas at day change 24h later to make the difference...

Goopy, i dont think i can make the sorting automatic... I will try to find a way but i don't promess...

ok
Cool list!

The sorting thing would make it the max

Another dumb question on what stats or formula are the rankings based on?

http://wiki.erepublik.com/index.php/Military_formulas

I mean on what is the top 100 based. Why is nr 56 higher than me? I isn't based on strength, experience, rank,... So what deturmens the rank?

I made a list with the MU members of belgian MU 10 days ago, and i listed it by q6 influence... I took the first 100 guys of that list for this new listing.

If the sorting thing can be solved, it's a perfect tool.

I don't know for google spreadsheet, but in excel, you can create a second page and with vlookup you can order it.

Example:

1: You create a column called Q6 str
2: You write 1 in A1 and 2 in A2
3: You write this formula in B1 (or wherever you want it):
=LARGE(Othersheet.A:A, A1)
4: For all other columns:
VLOOKUP(A1, Othersheet. A:AA, Number of the column,0 (or 1, I never remember))
5: For the rest, just extend the formulas.


Remark:

It will require that in the original layout the Q6 damage will have to be in the first column (that's a problem related to VLOOKUP)

Enjoy .

Nice, an updated list at popular demand.
As usual, good work.

Jofroi wrote:I don't know for google spreadsheet, but in excel, you can create a second page and with vlookup you can order it.

Example:

1: You create a column called Q6 str
2: You write 1 in A1 and 2 in A2
3: You write this formula in B1 (or wherever you want it):
=LARGE(Othersheet.A:A, A1)
4: For all other columns:
VLOOKUP(A1, Othersheet. A:AA, Number of the column,0 (or 1, I never remember))
5: For the rest, just extend the formulas.


Remark:

It will require that in the original layout the Q6 damage will have to be in the first column (that's a problem related to VLOOKUP)

Enjoy .

I remember that we had a sorted list on the MoD-BAF sheet of the very old BAF, how did we do it then ?

If I did it, it was the same way :p.

38 citizens from the top100 didnt do a single hit yesterday...
(datas are now correct, some dmg can be boosted however because of the rank points offered in missions reward)

To decrease the number of citizens that didn't do a single hit yesterday, you can remove the ones that are banned, like DonMatteo

We can also assume that everyone has an occasional time when it is not possible to do hits, especially around holidays. However, an extended period of no hits might indeed be a reason for concern, especially for members of our national army.

mittekemuis did 100 million of influence yesterday?

I added her on the list today, so she have only one day of datas recorded, so it's not accurate. To make damages, it takes the rank, save it, take the rank 24h later, make the difference, * 10, and give damages...

I will be on that list one day...

Great job Thomas, thanks for providing us with this excellent service.