Spreadsheet problems

I guess I forgot to talk about this when it happened.

I import my test data from angel over into my own custom db for analysis and such.

One problem that I was running into was that I was using openoffice spreadsheet to convert the formatting of the grades. Well, it can only handle a certain number of columns, then it gives up, this was a problem because it was dropping a bunch of question responses in those columns.

The solution I used was to use a Perl module to do the parsing instead of just using split (angel only gives you limited options in writing the data out).