Soft82.com » Windows » Business » Database Management » Random Generator for Microsoft Excel 3.5.3.37
Random Generator for Microsoft Excel 3.5.3.37
Download Random Generator for Microsoft Excel
Buy Random Generator for Microsoft Excel
| Developer | |
| Product Homepage | |
| Date Added | January 23, 2012, 10:09 GMT |
| License | Free to try (Shareware); $29.95 to buy |
| Last Week / All Time Downloads | 2 / 37 |
| Size | 9.4MB |
| OS Support | Windows All |
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
Download Random Generator for Microsoft Excel
Buy Random Generator for Microsoft Excel
New Database Management Software
QueryToDocMay 21, 2012Use QueryToDoc to export SQL Server and Oracle query results to a Word, HTML, or CSV File |
DataSlaveMay 21, 2012Import, Validation and Transformation of Data |
|||
Universal SQL EditorMay 17, 2012Intellisense enabled SQL editor for Oracle, DB2, SQL Server, Sybase, etc. |
DTM DB StressMay 16, 2012DTM DB Stress is a utility for database and db-applications stress testing |
|||
SB SolutionsMay 15, 2012BAAC offers Small Business Database SW for managing Contacts and Accounting |
ActiveData For Office/SQL EditionMay 14, 2012A Windows application that leverages the power of Microsoft Office and SQL databases |
|||
MONyog MySQL MonitorMay 11, 2012MONyog helps MySQL DBAs manage more MySQL servers, tune their current servers |
MDB Viewer PlusMay 10, 2012View and edit the content of .mdb files without the need to have Microsoft Access installed |
|||
PHPRunnerMay 9, 2012PHPRunner creates set of PHP pages to access and modify any MySQL database |
X-SQLTMay 9, 2012A free-form, declarative, XML-based language used to describe a series of commands for data |
|||
TirePricesMay 8, 2012Click on Mfg., or Size, or Type, or Misc. Code to see 3 pricing levels |
DBConvert for MS SQL & MySQLMay 8, 2012DBConvert for MS SQL & MySQL - Bi-directional db conversion tool for MS SQL and MySQL databases |
|||
GeniusConnectMay 8, 2012Add database connectivity to Outlook or Exchange |
B&B Quick QuoteMay 3, 2012Quick Quote displays the costs (labor or parts/products) from a selected job |
|||
phpMyAdminMay 2, 2012phpMyAdmin is a tool written in PHP used to administrate MySQL databases |
My MoneyMay 2, 2012My Money is a high quality personal financial software written from ground up |
|||
dotConnect for MySQLApril 25, 2012An enhanced data provider for MySQL that builds on ADO.NET technology to present a complete |
DBSync for MS Access & MSSQLApril 24, 2012Bi-directional synchronization and convertion for MS Access and MS SQL Server |
|||
CDBF - DBF Viewer and EditorApril 20, 2012Easy to use, very fast and small DBF viewer and editor |
DBF ManagerApril 19, 2012Manage DBF files easily using this innovative tool! Free trial version available |
|||
Last 7 Days Most Downloaded Database Management Products
MySQL Workbench147 downloadsVisual database design application that can be used to efficiently design, manage |
TOAD for Oracle Freeware45 downloadsTool for Oracle Application Developers |
|||
Mobile DBViewer Plus for Nokia S60 3rd E41 downloadsView & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile. |
QI Macros35 downloadsDraws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more |
|||
HotRez25 downloadsThe Hotel Reservation Software HotRez is a Room Booking Software for Hotels |
smart report maker (MySQL Report Generator)17 downloadsCreate and manage unlimited number of MySQL Reports |
|||
SQLyog MySQL GUI16 downloadsSQLyog is a tool that allows you manage MySQL database |
Pabx Billing System and Hotel Management14 downloadsCompatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel |
|||
Full Convert Enterprise13 downloadsFull Convert is the best application to convert structure and data of databases. |
DBF Viewer 200012 downloadsPowerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...) |
|||
All Time Most Downloaded Database Management Products
MySQL Workbench19,578 downloadsVisual database design application that can be used to efficiently design, manage |
TOAD for Oracle Freeware14,515 downloadsTool for Oracle Application Developers |
|||
Mobile DBViewer Plus for Nokia S60 3rd E11,072 downloadsView & Sync any database with Nokia S60 3rd Edition phone. Create DB on mobile. |
QI Macros722 downloadsDraws pareto charts, control charts, histograms, box and whisker plots, scatter plots and more |
|||
HotRez3,951 downloadsThe Hotel Reservation Software HotRez is a Room Booking Software for Hotels |
smart report maker (MySQL Report Generator)252 downloadsCreate and manage unlimited number of MySQL Reports |
|||
SQLyog MySQL GUI4,755 downloadsSQLyog is a tool that allows you manage MySQL database |
Pabx Billing System and Hotel Management345 downloadsCompatible with any PBX, 54 bills for Pabx Billing feature, 12 bills for Hotel |
|||
Full Convert Enterprise2,338 downloadsFull Convert is the best application to convert structure and data of databases. |
DBF Viewer 20001,958 downloadsPowerful viewer and editor for DBF files (Clipper, dBase, Foxpro, VFP, DB2K...) |
|||
Download Random Generator for Microsoft Excel
Buy Random Generator for Microsoft Excel


