All articles with 'test data' Tag
Weekly Excel Links – Issues with Hosting of PHD
Over the weekend I got thinking about the various ways in which PHD can help you and I wonder if PHD should have forums. For one, forums are a great way to discuss ideas, find answers and develop community feeling. But at the same time, there are tons of very good excel forums that having another one may not really help. Currently I am leaning towards starting a forum to see how it goes. What do you think I should do ?
Continue »Often when you are writing code or testing an application, it might be helpful to have random phone numbers generated for you. Here is an excel formula that I use: =value(left(substitute(rand(),”0.”,””),10)) try these 2 instead (thanks to John) =RAND()*(9999999999-1000000000)+1000000000 =RANDBETWEEN(1000000000,9999999999) [needs analysis toolpack add-in or excel 2007] Even though it works most of the time […]
Continue »