Soft82.com » Windows » Business » Database Management » Random Generator for Microsoft Excel 3.5.3.37

View screenshots

Random Generator for Microsoft Excel Description

Random Number Generator for Excel

A really fascinating feature about Random Generator for Excel is that it is so intuitive that you will hardly ever need to look in Help, so easy-to-use that you will never need more than a tick and a click to have the range filled with random values, and besides that very fast, reliable and flawless.

What you can do with Random Generator for Excel

The Random Generator window has 6 groups, each of the tabs is designed for producing a particular type of random values. Below is a quick overview of their capabilities:

* Random numbers: integers, real numbers dates and boolean
* Random values from Microsoft Excel custom lists
* Random strings (passwords, codes)

1. Random numbers: integers, real numbers, dates and boolean

Generate unique random numbers, dates, booleans

The first 4 groups are purposed for generating numbers exactly as their names suggest. They can produce:

* random integers
* random real numbers
* random dates
* random Booleans

You specify the minimum and maximum values and click Generate and you have the range populated. If you need unique random numbers or dates, check the Unique values checkbox in the corresponding group.

2. Random values from Microsoft Excel custom lists

Fill cells with random values from custom lists
The next group is meant for populating the range with values from standard Microsoft Excel custom list(s) or from your own list.

Populate the range with values from your custom lists
You can select the entire custom list or several lists, or pick only some particular values you need. Then you click Generate and your selected range is filled with random values from the list(s). See online help for step-by-step instructions: How to populate the range with random values from a custom list.

Create worksheets from custom lists
The add-in allows creating worksheets with the names of all custom list values by clicking just one button. So if in your workbook you need the worksheets with the days of the week, just select the appropriate custom list and click Create worksheets.

Pick a certain number or percentage of values from a custom list
If you need to randomly select a given percentage of values from your custom list, the Random Number Generator for Excel can help with this as well. For example, you have 50 telephone numbers and you need to pick random 10. You add all 50 numbers to your custom list, select 10 blank cells in Excel, click Generate and voila - you have 10 random phone numbers from your list. You can find detailed instructions here: How to pick a given number of random values from a custom list .

Create a new custom list and have it added to standard Excel custom lists
Another great feature is the ability to add your custom lists not only to the Random Number Generator for Excel, but to the Standard Microsoft Excel custom lists as well. Suppose you have a list of names in a worksheet. You select that list, and click New List. That's it! Just one click and you have a new list added to the Random Generator. Now you also have it among your Microsoft Excel custom lists. To make sure, go to Microsoft Excel menu - > Tools -> Options -> Custom lists. You can find step-by-step instructions and tips here: How to create your own custom list.

3. Random strings - excellent password and GUID generator

Ideal password generator
You select the character set (you can choose one or several sets, e.g. A - Z, a - z and 0 - 9, or enter any other characters in the Custom field) and set the string length which may be up to 99 characters. Click Generate, and the Random Generator for Excel does the job in seconds. You can use this function as an ideal password generator. The AbleBits staff used this option to generate their e-mail passwords, and none has been cracked so far :-). See more tips here: How to generate strings of a given length.

Generate strings of any pattern – perfect code generator
A really unique feature of our Random Number Generator for Excel, that you will not find in any other add-in is generating random strings by mask. You use the mask when you need the string of a particular pattern. E.g. if you need to generate a number of GUIDs, you check the Hexadecimal character set and use this mask ????????-????-????-????????????. Click Generate and you will have the 6F9619FF-8B86-D011-B42D-00CF4FC964FF pattern all across the selected range. Of course, apart from GUID codes, you can use this option for producing any other code types, for example coupon codes, RGB color codes, product codes, zip codes, SKU codes etc. Find step-by-step instructions here: How to generate random strings by mask.

Complete list of random values that Random Number Generator for Excel can produce:

* Random integers
* Random real numbers
* Random dates
* Random strings
* Random Boolean
* Random values from Microsoft Excel custom lists

Random Generator for Microsoft Excel Download Button For Your Site

If you want to place a Download Button for Random Generator for Microsoft Excel on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

Random Generator for Microsoft Excel User Reviews

New Database Management Software

QueryToDoc May 21, 2012 Use QueryToDoc to export SQL Server and Oracle query results to a Word, HTML, or CSV File				DataSlave May 21, 2012 Import, Validation and Transformation of Data
Universal SQL Editor May 17, 2012 Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc.				DTM DB Stress May 16, 2012 DTM DB Stress is a utility for database and db-applications stress testing
SB Solutions May 15, 2012 BAAC offers Small Business Database SW for managing Contacts and Accounting				ActiveData For Office/SQL Edition May 14, 2012 A Windows application that leverages the power of Microsoft Office and SQL databases
MONyog MySQL Monitor May 11, 2012 MONyog helps MySQL DBAs manage more MySQL servers, tune their current servers				MDB Viewer Plus May 10, 2012 View and edit the content of .mdb files without the need to have Microsoft Access installed
PHPRunner May 9, 2012 PHPRunner creates set of PHP pages to access and modify any MySQL database				X-SQLT May 9, 2012 A free-form, declarative, XML-based language used to describe a series of commands for data
TirePrices May 8, 2012 Click on Mfg., or Size, or Type, or Misc. Code to see 3 pricing levels				DBConvert for MS SQL & MySQL May 8, 2012 DBConvert for MS SQL & MySQL - Bi-directional db conversion tool for MS SQL and MySQL databases
GeniusConnect May 8, 2012 Add database connectivity to Outlook or Exchange				B&B Quick Quote May 3, 2012 Quick Quote displays the costs (labor or parts/products) from a selected job
phpMyAdmin May 2, 2012 phpMyAdmin is a tool written in PHP used to administrate MySQL databases				My Money May 2, 2012 My Money is a high quality personal financial software written from ground up
dotConnect for MySQL April 25, 2012 An enhanced data provider for MySQL that builds on ADO.NET technology to present a complete				DBSync for MS Access & MSSQL April 24, 2012 Bi-directional synchronization and convertion for MS Access and MS SQL Server
CDBF - DBF Viewer and Editor April 20, 2012 Easy to use, very fast and small DBF viewer and editor				DBF Manager April 19, 2012 Manage DBF files easily using this innovative tool! Free trial version available

Last 7 Days Most Downloaded Database Management Products

MySQL Workbench 147 downloads Visual database design application that can be used to efficiently design, manage				TOAD for Oracle Freeware 45 downloads Tool for Oracle Application Developers
Mobile DBViewer Plus for Nokia S60 3rd E 41 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.				QI Macros 35 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more
HotRez 25 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				smart report maker (MySQL Report Generator) 17 downloads Create and manage unlimited number of MySQL Reports
SQLyog MySQL GUI 16 downloads SQLyog is a tool that allows you manage MySQL database				Pabx Billing System and Hotel Management 14 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel
Full Convert Enterprise 13 downloads Full Convert is the best application to convert structure and data of databases.				DBF Viewer 2000 12 downloads Powerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...)

All Time Most Downloaded Database Management Products

MySQL Workbench 19,578 downloads Visual database design application that can be used to efficiently design, manage				TOAD for Oracle Freeware 14,515 downloads Tool for Oracle Application Developers
Mobile DBViewer Plus for Nokia S60 3rd E 11,072 downloads View & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile.				QI Macros 722 downloads Draws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more
HotRez 3,951 downloads The Hotel Reservation Software HotRez is a Room Booking Software for Hotels				smart report maker (MySQL Report Generator) 252 downloads Create and manage unlimited number of MySQL Reports
SQLyog MySQL GUI 4,755 downloads SQLyog is a tool that allows you manage MySQL database				Pabx Billing System and Hotel Management 345 downloads Compatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel
Full Convert Enterprise 2,338 downloads Full Convert is the best application to convert structure and data of databases.				DBF Viewer 2000 1,958 downloads Powerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...)