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

How to use a value between two different threads in Jmeter

-
Image
How to use a value between two different threads: Let us see how we can use the extracted value in one thread can be used in a different thread: As shown below we have Two threads (Thread Group – 1 and Thread Group -2). Under Thread Group -1 we have a HTTP Request where we extracted Request_Id and Session_Id. In our example we will use the same Ids in Thread Group -2 We have BeanShell PostProcessor to log the output of the variables in the output log. The Lines in the both BeanShell is as below: log.info("Request Id in Thread 1 = " + "${Request_Id}"); log.info("Session Id in Thread 1 = " + "${Session_Id}"); Now if we run the Script we get the below output: As we see the values of both the IDs are not passed to Thread Group-2. Now we will add few lines in the BeanShell PostProcessor as below and run again: ${__setProperty(Request_Id,"${Request_Id}")}; ${__setProperty(Session_Id,"${Session_Id}")};
Read more

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 relevant part of AWR Report can
Read more

Correlation and checking in Results

-
Image
Correlation and checking In Previous post we have randomly selected value for depart and arrive. Each Depart and arrive have a outboundFlight and returnFlight field, which changes according to the selected values. For E.g.: When we recorded the script with depart as “London” and arrive as “Paris” the below flight details was recorded accordingly to the selection.      /*web_submit_form("reservations.pl_2",          "Snapshot=t5.inf",          ITEMDATA,          "Name=outboundFlight", "Value=241;97;03/28/2014", ENDITEM,          "Name=returnFlight", "Value=422;102;03/29/2014", ENDITEM,          "Name=reserveFlights.x", "Value=26", ENDITEM,          "Name=reserveFlights.y", "Value=8", ENDITEM,          LAST); */ As we see above the outboundFlight and returnFlight is hard coded and needs to be correlated according to the selected value. So inserting the c
Read more