Draft Lottery Generator - with expansion

This forum is for league commissioners seeking advice when it comes to league related issues; rules, free agency system etc. / Ce forum devrait être utilisé par les commissaires qui cherches des conseils pour les aider à rouler leur ligue; règlements, systême agent libre etc.
Post Reply
JimToupet
STHS Dynamic Website Contributor
Posts: 363
Joined: Wed Jul 02, 2014 10:55 am

Draft Lottery Generator - with expansion

Post by JimToupet »

I create an Excel file for those who want to generate their league lottery with expansion team with the NHL format and odds.

You can download it here : http://www.lhssf.com/Draft Lottery.xlsx

Instructions :
  1. On Standings sheet, put team's names in reverse order of your standing (you must made your tiebreaking) on column B. You can fill other data to help you sort the standing if needed.
  2. Go to this page :https://www.random.org/integer-sets/ to generate your winning numbers. Use those settings :
    Generate 3 set(s) with 4 unique random integer(s) in each.

    Each integer should have a value between 1 and 14
  3. Go to the Draft sheet of the Excel file, enter generated number for each set to get your winner.
If you receive a message PICK AGAIN, you have one the following issue : the sequence 11,12,13,14 have been selected (it's a void sequence) or the sequence give a team that have already won one of the previous pick. Simply generate a new set for that pick.
Post Reply