Last Saturday we had a local VtES tournament, and I had the pleasure of assisting the organization with the Archon spreadsheet (version 1.3) for keeping track of the tournament information.
We had some problems with the Archon 1.3, when trying to enter the tournament rounds (2R+F). If we had entered 3 as number of rounds (on the "Tournament" worksheet) the automatic seating order was not entered for the individual rounds (on "Round 1" and "Round 2" worksheets). Also there were a number of cells which showed an error ("Err205") (e.g. the "Number of Event matches" cell) and the "Standings" worksheet was also messed up.
What helped in the end was entering the tournament as 3R+F tournament, but then deleting the seating entries on the "Round 3". Thanks to KevinM for the hint.
I am not 100% sure if this is a general problem, or if we didn't enter the information in the order the Archon expects, but we had the problem on Windows XP both with OpenOffice and with MS Excel 2007.