while I have created a number of different worksheets, I never created one for that purpose.
I think I would do the following.
Create a dummy plan, load only the HCEs and in prior year ADP/ACP plug the average values of the NHCEs. Then run the test. Doesn't really matter what you code for plan specs, as long as all the HCEs show up. If, for example, it is the company plan, names aren't even important. in fact, even dates of birth, etc. aren't important. all you want are the HCE bodies with comp and deferral (and match if needed)
it beats reinventing the wheel.