Test Driven Development - using MS Excel and VBA

Download tdd_for_managers_and_nonprogrammers_using_excell_and_vba_final.pdf

Here is the final version of my 16 page walkthrough of Test Driven Development using Excel.  The purpose is to "test drive" Test Driven Development rather than to learn it or how to program in VBA. 

Thanks to the half dozen or so TDD friends who've helped fine tune it.

I've had some good feedback and I'd love to hear more - good or bad ... the document is what I'll call an immature final draft!

For instance, Uday wrote:

Today I ran a TDD workshop at work for my colleagues. I started off with your "Integer to Roman" example in Excel. It was a huge hit! ...

A million thanks t you for the "TDD in Excel"., It is simply brilliant. It makes a huge impact.   The Red and Green colors through conditional formatting is a neat detail and a real master stroke.

Comments

[Dave Nicolette]

I found your Excel exercise to be just what I was looking for. We have a recurring process smell at our company that I think is traceable back to development teams not following TDD rigorously. I'm using your exercise as a way to help customers and managers understand what the impact of TDD can be on their projects. To do that I've incorporated the exercise with a presentation that ties "design debt" to financials over the course of development projects and over the course of a product's production lifetime. It's described here.

[Eugen Druta]

Hallo,
just great stuff; i use it, with a very good resonance, for a TDD presentation in our company. Thanks!
Best regards, Eugen Druta.

[excel chic]

found your Excel exercise to be just what I was looking for. We have a recurring process smell at our company that I think is traceable back to development teams not following TDD rigorously.