Spreadsheet Quality Assurance Checking Process ahead of Worksheet Roll-Out

[Marcie Be]

I am getting to the point now with a Change Management Tracker I have been developing to roll it out for a small number of people to work with.
In development I took the following approach

I use a few number of rows to represent each change type and its assocaited criteria in terms of task make up. I have appled the relevant formula and conditional formatting to these Sample Rows and Columns.
I have then Identified a further 10 active rows for my colleagues to enter their data to stress test the worksheet.
I am at the point of checking my sample rows before I copy to the 10 rows my colleagues will work with.
After this my plan is to populate a futher 500 rows with the formula and formatting.

Before I go ahead with this I was wondering is there a Quality Assurance approach to checking/auditing the Formula and Formatting works once copied to a large range of cells ahead of me rolling

Thank you in advance.

Best Regards

Marcie Be

 

[RayFrye]

I would suggest adding a subroutine tracing mechanism to make certain all your subroutines especially the error processing subroutines are executed. That includes every conditional statement with the subroutine. Often under normal circumstances everything works as designed but when the unexpected happens and the error code is fired, the codes crashes because it has never been executed. Lots of "extra" work but pays off in the long run. If this notion is factored into the design and coding effort it is a piece of cake.