Jump to content

jmr246

New Members
  • Posts

    1
  • Joined

  • Last visited

Profile Information

  • Favorite Area of Science
    Medicine

jmr246's Achievements

Lepton

Lepton (1/13)

0

Reputation

  1. Hi guys First up I'm useless at "complex" mathematical formulae and so would greatly appreciate some help Secondly this is a totally low brow request for help based upon goofing around so apologies if this is a bit informal. Right-Me and my housemates have FIFA soccer on Xbox...recently we began debating who is the best player and so I decided to start an excel spread sheet to take down some stats and hopefully work it out, working out win percentages and basic stuff like that is no problem, however let me describe the 2 aspects that are problematic 1) We all play regularly but some people more, some people less so we can't just do a basic league where we all play the same number of games and settle it with points. So for all individuals the number of games played will differ. This scoring system will probably extend for a few months so the differences could be vast 2) We always play with random teams which have star ratings and would like our scoring system to reflect more favourably to those who beat say Real Madrid (5 stars) with Bohemians of the Irish league (1 star) 3) We take drawn games to penalties-once again for a one star team who has taken a 5 star all the way to penalties only to lose we would also like this reflected So any advice re a forumla I can enter into Excel that will take the overall win percentage of an player coupled with the average rating of his team and give some sort of value that will enable us to say "a ha! Well You might have won a few more but I had a lot of rubbish teams where I won and its reflected right here in this number!!" Thanks guys Just in case a little bit of data is needed to illustrate what we're working with here is what we have so far (we only started today you see) 1) 1 (star) vs 5 (star) 2-3 2) 4 vs 4.5 0-1 3) 4 vs 3.5 1-0 4) 4.5 vs 1.5 2-1 (after extra time) 5) 1.5 vs 1 2-1
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.