|*************************************************
|*Something about me and software testing
|*************************************************

I'm a specialist in Software Testing. Most of the people thinking that software testing is only finding as much defects as they can do. I'm more the person not to search for as much defects there are, instead to prove that functionality is working. This seems the same still it is a world of difference. There will always be bugs in the system; still a system or functionality can be good enough to start working with.
Software testing is also more then only proving the functionality; it is also the process itself. How can the available means be used in an effective way. Though there are freeware tools and very expensive tools you can use, only as an external consultant is is sometimes hard to get these in the companys environment.

One of my favorite quotes comes from Dorothy Graham: "Automating chaos leads to faster chaos"
In Excel can this be translated to: Why build a macro for simple one time actions which cost about 15 minutes of work when a bad macro can corrupt your code within seconds and takes about hours to restore?

Recently I started a blog related to software testing were I share some thoughts. You might check it out on: http://testconsultant.blogspot.com/

I learned a lot of Excel on EE during the quest searching how I can use Excel and VBA to help me for automating and/or structuring repetitive functions. Excel became during the last years a great tool to help me obtaining information about testing processes and test progress monitoring.

During this quest I learned a lot about programming. This helped me to understand programmers much better. :)

Though I will not be on EE active as I was in the "old" days, I still peak in on a regular basis since I learned a lot of MS Excel trying to help others and there is still a lot to learn.

If you have specific questions you may contact me at: jeroen.rosink at gmail dot com
Keep in mind that communication about questions should go using the EE forum.

I did some quick testing in the duplicate master of Dave (brettdj) which is one of the greatest tools from an EE expert I saw:
http://members.iinet.net.au/~brettdj/

|*************************************************
|*Here some examples I'm proud I made it work:
|*************************************************
Dynamic Custom menu: http:/Q_22921280.html
Tooltip: http:/Q_21564823.html
Create outlook appointment based on cell value: http:/Q_22867496.html
Store outlook messages based on Date to local drive: http:/Q_22861592.html

|*************************************************
|*Some questions I enjoyed working with others from EE are:
|*************************************************
Kevin (Zorvek): http:/Q_21194497.html
Brad (Byundt) : http:/Q_21564823.html
Dave (brettdj) and Brad (Byundt): http:/Q_21070792.html
jeverist (Jim) : http:/Q_22921280.html
Jim provided me great help to make a custom menu working.

And one of the questions I'm proud of working on is captured in a journey description: http://www.kittytours.org/calendarproject/begins.html

Though there are other questions to mention I worked on with Matt, Jaes and both Patrick's and let us not forget Rory, I forgot to bookmark them in my knowledgebase. When the moment will come I shall place examples of them also here.

|*************************************************
|*A short selection of kind words which makes it also worth to continuing contributing on EE
|*************************************************
http:/Q_22882404.html#a20044002
"PERFECT!!!! Thanks so much!"

http:/Q_21006318.html#a20139464
"You know. I am going to buy you not one beer but a few beers if you ever come into town here, You have helped me in the past. I see an old ticket of mine from the year 2004 you helped me with."

http:/Q_22897258.html#a20088690
"...it is great to get a correct response so quickly!"

http:/Q_22913611.html#a20140818
"Niiiiiiiiiiiiiiiiice !!!  Does just what I wanted it to. Thank you very much Jeroen."

http:/Q_22925259.html#a20172525
"roos01:  I could not find a solution within Excel. Your 'simple' VB script (second choice) worked great. Just what I needed. Thank you."

http:/Q_22927735.html#a20179536
"Hi Jeroen. Amazing quick response which works perfectly. Thank you."

http:/Q_22953225.html#a20291978
"It worked! I really am speechless. Being a non technical person, this has been like one of those dream situations that you'd love to happen but thought impossible. Utterly amazing. I am totally gobsmacked. You have made someone extremely, very very happy. I am eternally grateful. Thanks a million."

http:/Q_22966536.html#a20303779
"Works great !  Thanks again Jeroen for a nice job and a big help."

|*************************************************
|*Here some milestones of myself in EE-Excel:
|*************************************************
Microsoft Excel Spreadsheet Software:
First points awarded: 12/29/2003
Master   : 12th May 2004
Guru      : 30th April 2004
Wizard   : 26th July 2004
Sage      : 19th October 2004
Genius   : 27th October 2005

General Office Suite Software
Master   : 6th March 2005

Miscellaneous Software
Master   : 26th June 2006

Visual Basic Programming
Master   : 22nd August 2007

VB Script
Master   : 24th January 2008

Crossed the 2-Million-points-border on 11-23-2007

Peeked in the HOF (1-101) for a short moment on 12/24/2007

EE-MS Excel Cleanup:
Volunteered: 10/29/2005
At this time (06/14/2008) posted in 141 CV Questions 4198 recommendations for cleanup.