Potentially offensive to some, but in the spirit of TMTOWTDI:

The person requesting this data suggested that I dump it into an excel spreadsheet, sort the data and manually remove the records that I don't need. That seems way too labor intensive to me

There are pretty easy ways to do this in Excel. Take a look at the worksheet function COUNTIF; combined with a bit of multi-stage arithmetic and then filtering, you should be able to narrow down your set of data pretty easily.

Hm, after a bit more research, this might not be so easy after all, since COUNTIF only takes one critirion. This can be worked around at least two ways: first, count entries above the range, add the number of entries below the range, then subtract that from the total number of entries. Another solution is to use SUMPRODUCT with boolean tests. Either way, it looks like it can be done with three additional columns (# in range, # equal to 305.1, include yes/no).

Update

Works out reasonably well. Doing a text import of the CSV gives me 13 columns (A-M). The first three are identifiers (initials, id, and date), then the ten values (columns D-M). Starting at row 2 (after adding a row of headers), I have:

  N2 = COUNTIF(D2:M2,">=296.1")-COUNTIF(D2:M2,">314.0")
  O2 = COUNTIF(D2:M2,305.1)
  P2 = NOT(AND(N2=1,O2=1))
[download]

Workbook here (Excel 2000, 27KB).

Just out of curiosity, how is one supposed to interpret the values with letters in front?