![]() ![]() ![]() But now it is a daily ritual.isn't that amazing. Now creation of functional test cases was a cake walk and believe me that was the first time excel was used in our company for such purposes. Within an hour, I was able to create a data of 40,000 loan applications having sufficient variety to satisfy the testing requirement. The randomness comes from atmospheric noise, which for many purposes is better than the pseudo-random number algorithms typically used in computer programs. Be aware these are randomly generated so any. RANDOM.ORG offers true random numbers to anyone on the Internet. In such scenario, excel proved to be a "god sent" for us.įor customer name I took name from popular Baby Name sites / Indian God Names etc., used random numbers and vlookup and concatenate funtion to change surnames, initials etc (so that one name can be used multiple times by changing surname / initial etc.)įor other columns, again randbetween, Vlookup / Hlookup and concactenate functions proved handy. Generate US phone numbers for use as test data, for prank calls, or as a number to hand out to pushy suitors. We needed following columns:Ĭustomer Name, Date of Birth, Loan Product, Branch Location, Approved Amount, Disbursement Amount, Loan Tenure, sourcing agent etc. Being a business analyst (from banking background) and Having used excel to create test data in the similar manner, as you mentioned in your post, I think excel is a wonderful tool for ceating tesing data.įor example, for an application related to a loan management, my development team needed a sizeable data for testing. I have been a regular visitor to your blog and getting benefitted by the info posted by you and others.Īm glad you highlighted the use of random numbers for testing. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |