![]() 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. 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. 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. com, include the suspicious phone number in the. (format, stats1.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. This page list 20 random phone numbers from Korea by default. ![]() ASCII ranges and symbols are also allowed e.g. Enter ranges using a colon or hyphen e.g. Can be used to pick a number for giveaways, sweepstakes, charity lotteries, etc. List of numbers to randomize 1,2,3 4 5 6 7-10 Separate numbers in list by space or comma e.g 1 2 3 or 1,2,3 or -1,0,1. (format, (double) stats1.getNrOfObservations()) Free online random number generator with true random numbers. Supplier> stats = () -> new SummaryStats(f) Supplier sup = () -> isOctalBetween(100, 743) Return observations.stream().mapToDouble(function::apply).min().getAsDouble() Return observations.stream().mapToDouble(function::apply).max().getAsDouble() If (observations.isEmpty()) throw new RuntimeException("No data available!!!") Public static int generateOctal(int min, int max) ) thanks.Ī theoretcal problem is that you might produce an awful lot of octals 800, before the first suitable is found. Do you know what I can do to improve my math ability please? I desperately need it. ("Here is a random generated phone number: " + strippedNum + "-" + num2 + "-" + num3) Īlso, how did you people know about octal base numbers? I would never have known that. Num3 = generator.nextInt(8999) + 1000 // make numbers 0 through 9 for each digit.//can't go below 1000. Num2 = generator.nextInt(641) + 100 //number has to be less than 742//can't go below 100. Num1 = generator.nextInt(600) + 100 //numbers can't include an 8 or 9, can't go below 100. ("The second set of 3 digits can't be greater than 742.") ("The first set of 3 digits can't have 8 or 9 in them.") ![]() ("This app prints out a random phone number.") RandomPhoneNum.java:23: cannot find symbol I posted this on another forum but no answer anymore.Ĭ:\JAVA_PROGRAMMING_CODE\code1\RandomPhoneNum>javac RandomPhoneNum.java I get the following error though when trying to compile. I am trying to make a phone number generator. I have had help with my code from another forum, the app is almost done, but no one is answering there now. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |