I have an Excel-created spreadsheet that has a bunch of formulae which reference
named cells from a vlookup function.  It looks like the original sheet has named
cell ranges on each sheet which have the same name (unique per sheet, but not
unique across the whole spreadsheet).

The importer seems to try to rename certain of the named ranges to something
different (like Heat1___1 rather than the original Heat1).  But it still seems
to have duplicates across most of the sheets.

This renaming takes place on all sheets except the one called "10 Cars" which
looks like the way it is in Excel.

The formula (in the Score column) on sheets "8 Cars" and "4 Cars" work (after
putting in valid data to the Place columns).  On all the other sheets, they just
yield Err:502 (no matter the data).

"8 Cars" and "4 Cars" also show Err:502 until valid data is put in.  You're
supposed to put the numbers "1, 2, 3, or 4" in the "Place" column to show which
car came in in which place (in a race).  Then the score and place columns should
show which cars are the winners.

BTW, Excel shows 0's in the Score column until data is input--openoffice shows
Err:502.  That's not a major issue, but a difference.  The main issue is I end
up with a bunch of non-uniquely named ranges which the vlookups seem to choke on
.  I'll attach the file.