Using Excel to choose a random name from a file list

Channel:
Australia DasTactic
Subscribers:
63,000
Published on ● Video Link: https://www.youtube.com/watch?v=eX035Rcp8KU


Duration: 27:35
5,481 views
26

This tutorial shows how to use Excel to choose a random file. Specifically this tutorial chooses a province randomly for the game Crusader Kings 2.

Final file is here: http://www.mediafire.com/?1801hg8z8bgbp85

This shows how to easily make a text file of files within a directory.
It shows some simple regular expressions to strip out the unwanted information.
And then it shows how to get a random choice from Excel.



Other Videos By DasTactic


2013-07-01Problem Solving in Java Ep1 ~ MVC Approach
2013-06-29Eador MotBW Ep19 ~ The siege of Narinae
2013-06-28CK2 A Game of Thrones Ep6 ~ A Pitiful End
2013-06-27CK2 A Game of Thrones Ep5 ~ Third Rebellion of the North
2013-06-26Eador MotBW Ep18 ~ Into the Lands of Erdu
2013-06-25CK2 A Game of Thrones Ep4 ~ For Hornwood
2013-06-24CK2 A Game of Thrones Ep3 ~ Casus Belli
2013-06-23Eador MotBW Ep17 ~ Pegasus Halflings and War
2013-06-22CK2 A Game of Thrones Ep2 ~ Plots and Schemes
2013-06-22CK2 A Game of Thrones Ep1 ~ Lord of Ramsgate
2013-06-21Using Excel to choose a random name from a file list
2013-06-20Victoria 2 HoD Ep15 ~ Grinding On
2013-06-20Victoria 2 HoD Ep14 ~ The War of Paraguay
2013-06-19Eador MotBW Ep16 ~ Knight Defeated
2013-06-18Legendary Heroes Ep12 ~ Umbers Turn
2013-06-17DW Shadows Precursor Empire Ep15 ~ Final Victory
2013-06-17DW Shadows Precursor Empire Ep14 ~ Preparing the Fleets
2013-06-16Eador MotBW Ep15 ~ Ogres
2013-06-16DW Shadows Precursor Empire Ep13 ~ Battle for Tuprawa
2013-06-16DW Shadows Precursor Empire Ep12 ~ Invasion Forces
2013-06-16Legendary Heroes Ep11 ~ Warlord Verga


Tags:
excel
regular expressions
cmd
command
edit pad
regex
regex buddy
tutorial