Warning: mysql_real_escape_string(): Access denied for user 'dragon99'@'localhost' (using password: NO) in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152

Warning: mysql_real_escape_string(): A link to the server could not be established in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152
Data Generator 2: with VLOOKUP & Pivot Table - Oz du Soleil

Data Generator

 This video demonstrates one use of data generator results as follow-up to an earlier blog entry, Taming Dataville. In the video below, you will see:

  • Use of dummy data
    • While waiting for someone to create a Master List, I moved ahead by using random fish species where the names will eventually go.
  • VLOOKUP
    • Matching ID numbers to names
  • Pivot Table
    • Determines how many unique IDs are in the data set

There are lots of online data generators. I also maintain my own list of random data.
You’re welcome to download it if you like:   Dummy Data List
It contains: 379 Cities, all US States, 200 Random Names, 1300 Fish Species, 220 Colors.