Recent content by DodgerLD

  1. D

    Formula for awarding prizes on a leaderboard

    Ah, that makes sense. Thanks Yayness!
  2. D

    Formula for awarding prizes on a leaderboard

    (0.7^(10 - 1) * (0.7 - 1)) / (0.7^10 - 1) ... gives me 0.012457..., but it should give me 0.31.
  3. D

    Formula for awarding prizes on a leaderboard

    Hi Yayness, That seems similar to what someone else gave me (which I converted to Excel for testing), which seems to be working quite well: ((1 - p) / (1 - p ^ n) * p ^ (r - 1)) * l p = a value between 0 and 1 which defines the distribution (sort of). n = number of players r = rank l = prize...
  4. D

    Formula for awarding prizes on a leaderboard

    Hi, If you have a prize pool (say 1,000 points), and a leaderboard like: Rank / Name 1 / Dan 2 / Rachel 3 / Max 4 / Chloe 5 / Grant etc. Is there a formula where you can input prize pool, rank, and maybe the number of people, and it will give you the number of points (or a %) for...
Back
Top