2004-09-08

Who did what when?

Problem: What work has been done on a particular project.
Solution: Check the files created on the PC. Hopefully they were all placed in identifiable places, like their project directory.

1. Use Command Prompt (\Start Menu\Programs\Accessories) to extract the information to clipboard. Right click the [c:\] button for the menu. Type the drive letter you want, then navigate the directories using the command:
cd (then paste the rest of the directory copied from the Windows Explorer address bar).
Use cd.. to move up a level.
2. Paste into MSWord and replace the sometimes fixed widths with tabs (macro for this)
3. Select all text for table - copy & paste into Excel
4. Sort by Date and time
5. Find files with contiguous dates to identify time spent on the project.

@winhelp3 on Twitter