I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

sbGenerateTestData

"It is practically impossible to teach good programming style to students that have had prior exposure to BASIC.
 As potential programmers, they are mentally mutilated beyond hope of regeneration." [E. W. Dijkstra]

I studied computer science as a secondary subject and I worked as a systems programmer later on. When I entered the banking industry I almost fainted. Programs were of quite poor quality. Many programmers in the '80s have never heard of Jon Bentley's Programming Pearls.

Then Excel © was distributed and each and every hobby programmer offered his "solutions" to the public. I had to face the fact that many programs and many worksheets were not tested before shipping.

The application below is meant to help people who want to test properly. This is just the first initial idea. I am thinking about defining all inputs via XML.

You want to create six Boolean values, 50% True and 50% False, once in generated order and once shuffled? Here you are:

sbGenerateTestData_Bool_Screen

Or you need to create 4 money values in GBP, the first series between GBP 10 and GBP 20, the second should have an average of 6 and a standard deviation of 2?

sbGenerateTestData_Ccy_Screen

If you like to generate four dates between 1-Jan-2000 and 1-Jan-2013 or four dates with average 30-Jun-2012 and with a standard deviation of 180 (days):

sbGenerateTestData_Date_Screen

If you need 4 countries, one African, one Asian and two European; or you need 2 Asian and 2 European (drag tab "Countries" next right to tab "Data" so that it is tab #2!):

sbGenerateTestData_String_01_Screen

You can also generate correlated numbers with this application. I have implemented the Iman Conover method with VBA.

See this flash demo, please.

The spreadsheet tabs:

You can download a 157 KB Excel © sample file which created the output shown above here. Please read my disclaimer.

sbGenerateTestData_Tabs_Screen

The VBA objects:

sbGenerateTestData_VBA_Screen

The TestSuite VBA code

The TestCorrelatedNumbers VBA code

Sulprobil   Get it done   Contact   Disclaimer   Download