roos01

  • 2,197,160Expert Points
  • 0Points this month
  • Member since: 06/05/2003

Your Account

View Profile

Personal Description

|*************************************************
|*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 (01/10/2010) posted in (158 CV Questions untill 02-22-2009) and 6237 recommendations for cleanup.

Skills and Expertise

Personal Website:
http://testconsultant.blogspot.com/
Expertise:
Advanced
Experience:
10-14 years
Primary site use:
Expert support
Loading Advertisement...

Top MS Excel Experts

  1. dlmille

    1,351,499

    Genius

    10,680 points yesterday

    Profile
    Rank: Genius
  2. ssaqibh

    542,555

    Sage

    0 points yesterday

    Profile
    Rank: Genius
  3. rorya

    381,757

    Wizard

    4,225 points yesterday

    Profile
    Rank: Savant
  4. imnorie

    334,112

    Wizard

    0 points yesterday

    Profile
    Rank: Genius
  5. teylyn

    282,850

    Guru

    20 points yesterday

    Profile
    Rank: Genius
  6. barryhoudini

    280,460

    Guru

    0 points yesterday

    Profile
    Rank: Genius
  7. redmondb

    235,511

    Guru

    2,000 points yesterday

    Profile
    Rank: Sage
  8. matthewspatrick

    230,947

    Guru

    2,010 points yesterday

    Profile
    Rank: Savant
  9. byundt

    197,840

    Guru

    820 points yesterday

    Profile
    Rank: Savant
  10. zorvek

    144,626

    Master

    0 points yesterday

    Profile
    Rank: Savant
  11. StephenJR

    136,537

    Master

    0 points yesterday

    Profile
    Rank: Genius
  12. nutsch

    117,005

    Master

    0 points yesterday

    Profile
    Rank: Genius
  13. gowflow

    110,036

    Master

    0 points yesterday

    Profile
    Rank: Sage
  14. MartinLiss

    107,333

    Master

    0 points yesterday

    Profile
    Rank: Wizard
  15. GlennLRay

    95,652

    Master

    0 points yesterday

    Profile
    Rank: Guru
  16. robhenson

    90,250

    Master

    0 points yesterday

    Profile
    Rank: Sage
  17. ScriptAddict

    88,470

    Master

    0 points yesterday

    Profile
    Rank: Guru
  18. kgerb

    85,022

    Master

    0 points yesterday

    Profile
    Rank: Wizard
  19. aikimark

    84,456

    Master

    3,310 points yesterday

    Profile
    Rank: Genius
  20. andrewssd3

    80,242

    Master

    0 points yesterday

    Profile
    Rank: Wizard
  21. Wiesje

    69,918

    Master

    0 points yesterday

    Profile
    Rank: Master
  22. Shanan212

    66,418

    Master

    0 points yesterday

    Profile
    Rank: Master
  23. krishnakrkc

    59,548

    Master

    0 points yesterday

    Profile
    Rank: Wizard
  24. Michael74

    54,744

    Master

    0 points yesterday

    Profile
    Rank: Wizard
  25. regmigrant

    51,070

    Master

    0 points yesterday

    Profile
    Rank: Guru

Hall Of Fame