F400 Clan Ranking - Needs Repair

[IcePack]

Ok I think I understand now.

Instead of:
Graph
Graph
Graph
List

New:
List
Graph etc

And when I post page 11 "update" also post list alone.

Easy, done!

IcePack

[Dako]

Also your spoiler says "completed wars in august". It is september now :). And can you sort them date DESC? So we have new wars on top (cause they are more valuable and interesting for people).

Thanks.

[IcePack]

I fixed the month, forgot about that thanks for catching.
I'm 99.9% sure those dates must be in ascd order for the database.
I'll play around with it tonight and find out for sure.

I have a few things I am a wanting to test this week. Once I've clarified them, my next task is to continue sorting the CL4 mess.

[Dako]

You can keep them ASC and database but post them here DESC ;).

[IcePack]

You can keep them ASC and database but post them here DESC .

All the data is entered on a text file. I'll have to see if copy and paste into excel gives me any headaches from format. It'll be a nightmare if its all incorrect locations, or having to retype.

If its a simple copy, paste, and sort I'll be happy to do it.

IcePack

[Leehar]

You can keep them ASC and database but post them here DESC .

All the data is entered on a text file. I'll have to see if copy and paste into excel gives me any headaches from format. It'll be a nightmare if its all incorrect locations, or having to retype.

If its a simple copy, paste, and sort I'll be happy to do it.

IcePack

You can also import the text file into Excel, and just ensure that it's 'Tab deliminated' and it should come out the same.

[IcePack]

Good info, thanks I'll try it out when I get home. I assume this functions available on Mac office as well

[pamoa]

List
Graph etc

And when I post page 11 "update" also post list alone.

yes that's it

[deantursx]

Hey is it possible for a clan's ranking to improve after a loss? We're about to lose 27-34 to TSM. Do you think that could end up helping our ranking based on how high they're ranked?

[benga]

Hey is it possible for a clan's ranking to improve after a loss? We're about to lose 27-34 to TSM. Do you think that could end up helping our ranking based on how high they're ranked?

Yeap, you should play the top 5 all the time and lose and you will come closer to top 10 in no time!

[IcePack]

Hey is it possible for a clan's ranking to improve after a loss? We're about to lose 27-34 to TSM. Do you think that could end up helping our ranking based on how high they're ranked?

I always thought the answer was yes. I tested it officially tonight.

The answer is yes. Now, I tested last place and first place. Whether you as MD would get the same affect for TSM, remains to be seen. Also, I tested 20-21 scores. I know it has to be close, I'm not sure even if the affect would occur for MD and TSM, I'm not sure the score of 27-34 would be close enough to get you the extra points. (ie i believe for this to happen, there has to be a sizeable difference in clan rank / scores)

IcePack

[Dako]

I think TOFU has won over TNC with some score close to 30-10 and it actually decreased our rank.

[betiko]

wow otp #9 congrats!

[laughingcavalier]

wow otp #9 congrats!

That's a mistake. Freak was getting down and dirty with the ranking program and it was so excited it got its numbers all mixed up.

Looks like we will be losing points from our win against MD, but that's fair enough. I do wonder what happened to us in TSM a few months ago though, when we dropped 100s of points and several places all in one month without any major change in the quality of our results, at least not that I knew about.

[josko.ri]

I do wonder what happened to us in TSM a few months ago though, when we dropped 100s of points and several places all in one month without any major change in the quality of our results, at least not that I knew about.

Well, 25-35 vs KORT on the time when we had almost equal score for sure affected your going down a lot. also, negative score in CL4 vs opponents with more or less equal score will put you even more down, together with slight win vs MD which has much lower score thank TSM.

[IcePack]

In order to help educate clan leaders, I'm willing to run estimates of any score changes and / or what kind of win % you need in order to not lose points to a lower clan etc.

I just ask to:
1) keep ur requests reasonable (don't ask me to estimate every clan)
2) please be specific in your request
3) don't expect an hours turn around
4) to lower the requests, please be an active clan leader or show me whether ur an active MOW for them

Sample Request:
What: Minimum game # needed to not lose points or how will this war affect my score*
*if this section option, fill in Score
Who: TSM vs MD
When: anticipated date of war end
Score: 34-27 TSM win

Remember, it's an estimate based on CURRENT scores. If I tell u that u need 25 wins, and u get it and u lose pts...im sure points change if it's 2 months later. It gives u an idea..
Thanks,
IcePack

[deantursx]

Sample Request:
What: Minimum game # needed to not lose points or how will this war affect my score*
*if this section option, fill in Score
Who: TSM vs MD
When: anticipated date of war end
Score: 34-27 TSM win

Remember, it's an estimate based on CURRENT scores. If I tell u that u need 25 wins, and u get it and u lose pts...im sure points change if it's 2 months later. It gives u an idea..
Thanks,
IcePack

Thats awesome Icepack. I'm sure everyone will appreciate that. So is 25 the actual answer to that?

[IcePack]

No sorry, that was just an example. I can give actual answer for the TSM/MD situation in approx 8 hours.

IcePack

[IcePack]

TSM vs MD Break Even Point Analysis (ESTIMATE)

TSM breaks even at 35.5 wins vs MD if the war was based on no other changes in F400, and completed by the 15th of the month. (35 TSM 26 MD, TSM loses a single point and MD gains a single point. / 36 TSM 25 MD, TSM moves into positive territory, further the bigger difference they could manage)

Hope that helps.

IcePack

[jackal31]

TSM vs MD Break Even Point Analysis (ESTIMATE)

TSM breaks even at 35.5 wins vs MD if the war was based on no other changes in F400, and completed by the 15th of the month. (35 TSM 26 MD, TSM loses a single point and MD gains a single point. / 36 TSM 25 MD, TSM moves into positive territory, further the bigger difference they could manage)

Hope that helps.

IcePack

youre right....as long as MD doesnt take 24 hour turns and we finish all our games by the 15th, even though TSM will win....TSM will be faced with a point loss.

Makes complete sense to me.

[IcePack]

TSM vs MD Break Even Point Analysis (ESTIMATE)

TSM breaks even at 35.5 wins vs MD if the war was based on no other changes in F400, and completed by the 15th of the month. (35 TSM 26 MD, TSM loses a single point and MD gains a single point. / 36 TSM 25 MD, TSM moves into positive territory, further the bigger difference they could manage)

Hope that helps.

IcePack

youre right....as long as MD doesnt take 24 hour turns and we finish all our games by the 15th, even though TSM will win....TSM will be faced with a point loss.

Makes complete sense to me.

The 15th is just a date i picked, because decay can affect clan scores in strange ways sometimes. I picked a relatively near day just to give the estimate.
As I've explained before, as an example if KORT beat LOTZ 21-20, you wouldn't expect them to NOT look weaker than before they played, do you?
As a top ranked clan, playing other clans the F400 assumes you should not only win sometimes, but win by a particular margin based on all clan wars up to present win margins etc.
So, if you're 3rd place and playing 17th it expects you to win not by 31-30, but by 36-25 in order to maintain your high place within the clan world. While if you played someone top 5, that
expectation would be removed because your playing someone it judges to be close to your talent levels.

It does make complete sense. Compare a conqueror who plays a cook in a 61 game 1 vs 1 series, if he beats the cook 31-30 he's still going to lose points....

IcePack

[jackal31]

what you have written to my response makes much more sense than what's implied in the first post.

By selecting a date, it appears you're saying TSM will lose a point if MD is not defeated by the 15th. That's what didnt make sense.

edit: and after rereading it again.....you even said the rankings can be weird somtimes.....I think it's obvious I dont follow these rankings all that closely, but the length of time a war is completed shouldnt impact the outcome or clan score change.

[IcePack]

what you have written to my response makes much more sense than what's implied in the first post.

By selecting a date, it appears you're saying TSM will lose a point if MD is not defeated by the 15th. That's what didnt make sense.

Sorry, I didn't mean to imply that. I meant my particular estimate was based on that date, and if it went later than that it could be affected by some decay issue i didn't look at in the future.

IcePack

[IcePack]

I may end up updating this tonight a little early, since i wont be available this weekend.

IcePack

[IcePack]

Archive