Generating Random data in Excel

-


Sometimes we are required to use a list of names constructed from some chars followed by random numbers

In order to use the parameter type FILE in LR parameter list with names constructed from chars followed by random numbers you might be require to develop a function to create names dynamically.

Use the excel functions below to generate a random chars strings followed by random number generated between a given range, one for uppercase chars and the other for lowercase chars, as shown below.
The prefix can be changed according to your needs, with simple adjustments.

It’s a simple but effective way to create a list of names to suite our needs.

Functions :

Starting Letter Capital F followed by 6 small Letters

=TEXT(RANDBETWEEN(97,122),)&CHAR(RANDBETWEEN(70,70))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))

Output:- E.g. Fteqebz
               Starting Letter F followed by random 6 a-z characters.

All Capital letters starting with letter A

=TEXT(RANDBETWEEN(65,90),)&CHAR(RANDBETWEEN(65,65))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))

Output:- E.g. AUTXCHD
                 Starting Letter A followed by random 6 A-Z characters.

Starting Letter Capital F followed by 8 small Letters and some digits within range 1000-99999

=TEXT(RANDBETWEEN(97,122),)&CHAR(RANDBETWEEN(70,70))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&RANDBETWEEN(1000,99999)

Output:- E.g Fnejrhidw75028
Starting Letter Capital F followed by 8 small Letters and some  digits within range 1000-99999


What is an ASCII chart?
An ASCII Chart is a simple way to keep a list of what all the printable, or displayable characters are.

Ascii representation is as below:

32 is a space
48 to 57 are our numbers 0-9
65 to 90 are the capital letters A-Z
97 to 122 are the lowercase letters a-z

Important Tip:

In Excel, every time the worksheet calculates, these codes will change,
so if you want them to remain same you will have to copy them and use PasteSpecial -> Values to convert the formulas to static values.

Comments

Post a Comment

Popular posts from this blog

Steps to Analyze AWR Report in Oracle

-
Image
Steps to Analyze AWR Report in Oracle AWR -   Automatic   workload repository is a collection of persistent   system performance   statistics   owned by SYS. It resides in SYSAUX   tablespace . By default snapshot are generated once every 60 min and maintained for 7 days . Each snapshot has a unique ID know as "snap_id". Snapshot detail can be found in " dba_hist_snapshot " view.   If we have Database performance issue and not the Database machine, then AWR Report is the place to look at. AWR is not used for real-time performance monitoring like the v$ tables. It is used for historical analysis of performance. AWR complements, but doesnot replace real-time monitoring. Once AWR Report is generated in Oracle, the next task is to analyze it. By going through the AWR Report we can easily solve issues like slow database, high wait events, slow query and many more issues. Even though the report is lengthy, Analyzing or Reading re...
Read more

Vmstat Output explained

-
vmstat : vmstat is a tool in Unix/Linux which is used to Report virtual memory statistics. It shows how much virtual memory there is, how much is free and paging activity. Most important, you can observe page-ins and page-outs as they happen.   vmstat   reports   information about processes, memory, paging, block IO, traps, and cpu activity.   > vmstat procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu-----   r   b    swpd    free    buff   cache         si    so     bi     bo    in    cs us sy id wa st   0   0   21688 12797396 850716 15372668     0     0      3     35     0     0   1   0 99   0   0   0   0   21688 12789292 850716 15372668 ...
Read more

Verifications and Error Handling in LoadRunner *Web_reg_find and Web_reg_save_param*

-
Verification's and Error Handling Verification points must be inserted into the scripts to verify the application being tested with the load. Verification function that are used in our application are:  Web_reg_find, web_reg_save_param These verification should be outside towards the end of the transaction. Mandatory verification points: ■          Login – whenever there is a login, verification points must be added to verify that the user logged in correctly. ■          Update Transactions – transactions that update the database must be verified that they are successful. ■          Each page should be verified using Web_reg_find function Using Web _ reg_find for verifications. Example: web_reg_find("Text= Main Package","SaveCount=Verify_Count1",LAST); Verification: if (strcmp(lr_eval_string("{Verify_Count1}"),"0")==0) { ...
Read more