It’s an excel sheet that randomizes troops as if you were opening chests.
I set it as if I my team would have 1 troop from a Gold chest, 2 troops from Glory chests, and 1 troop from a Gem chest, but that’s easily customizable. Also, you can adjust chances that each rarity drops on each chest by changing column C on tab Chest Drops. I’ve based mine roughly on info I found here in the forums.
I also made it so that you have 3 picks from each of the 4 “chests”, and you can arrange them in any order in your team.
To draw a set of troops, select the Draw tab, and you can either go to Formulas, and select Calculate Sheet, or even selecting a random empty cell and hit the delete key, for example.
If new troops are added, just add them to the tab corresponding to its rarity, and it’s gonna enter the draw automatically.
EDIT: The 2nd Glory chest was set up as Gem chest, so I fixed that now.