Within a test suite, each test case generates a large amount of test data, which is used as input to the next test case in the sequence. Frequently we want to manipulate the test data to cause failures in or otherwise test the downstream tools. These manipulations are significant test activities whose outputs can be reused in other test suites, so I'd like to track them separately from the test cases.
Since the test activities themselves have similar fields to the test cases (precondition, postcondition, etc.) my naive inclination is to capture them alongside test cases (TC), with a different identifier (TA), in the same spreadsheet:
(Additional fields, not shown, are Traceability, Input, Steps, Actual Output, Test Result, and Status.)
Further extending my naive inclinations, I could add preparation/automation activities and track these separately. For all intents and purposes, we can assume this is captured in an Excel spreadsheet or similar and that we can add any fields we need.
This seems fairly nonstandard, so I appreciate any thoughts/alternatives.