Before I Save As..., I think very carefully about the filename of the worksheet. I put the most important concept of the work sheet at the first part of the filename so that files listed alphanumerically sort the files accordingly.
Then, at the top of the worksheet is the extended name of the worksheet (I try to keep it to one line). The very next line is a one sentence description of the worksheet. The filename is usually a contraction of the extended name of the worksheet. For example, in a worksheet that calculates Johnson noise in a resistor, the first two line of the worksheet are:
Noise- Johnson thermal noise of a resistor
Calculate the noise power, voltage, current and charge in a resistor.
The filename I chose for this worksheet is “NoiseJohnson-vs-R.mcd”. I use automatic filename in the Header so that printouts show the filename of the worksheet. For revisions, I append 2 digit numbers (e.g., 01, 02, 03, …, 10, 11, …) so that revisions also sort alphanumerically. I’ve never had more than 100 revisions in a worksheet.
This works very well for me. Occasionally, I use Windows Search text inside file to find calculation that I’ve already done.
