grrrr. This is the file I should have attached.
On Sat, 2005-09-10 at 02:02 -0500, David Stanaway wrote: > Sorry, I didn't specify the approximate arg to the grade vlookup so you > will get erroneous results. Here is the correct version. > > On Sat, 2005-09-10 at 01:55 -0500, David Stanaway wrote: > > For this kind of thing, I would use awk. There is also sqlite which > > might be ported to your OS, you didn't specify, and this supports outer > > joins. > > > > I am not aware of a matrix operation that will sort/uniq muliple ranges > > of data which would be neat. > > > > Attached is a simple vlookup based approach you might use. You just need > > to be able to have a complete set of student ids for the result sheet. > > > > I am not sure how to get that complete set of student ids inside > > gnumeric, but in the unix shell it is very simple. > > > > Suppose you have 2 csv files of exam results, both with the first column > > containing student ids. > > > > cut -d, -f1 exam1.csv exam2.csv | sort -u > studentids.csv > > > > > > > > On Fri, 2005-09-09 at 20:47 -0400, Alexander Kirillov wrote: > > > Hi guys: > > > maybe one of the experts here can provide some advice... > > > > > > I have two spreadsheets containing grades for two different exams > > > (midterm 1, midterm2) for the same class. For simplicity, we can > > > assume that each contains the following filed: > > > ID Name Grade > > > > > > I need to merge them creating a single spreadsheet with all grades for > > > all students who took at least one of the exams. If the list of > > > students was the same, I could just copy-and-paste a column. However, > > > the lists are slightly different: some students missed one midterm, > > > others the second midterm, some dropped the class, etc. > > > > > > Is there any simple way of merging them, short of manually matching > > > (there are about 900 students)? Of course, if using a database - such > > > as MySQL - it would be exactly one command [AFAIK, it is called "full > > > outer join"]. But I do not know MySQL, and learning it, converting the > > > data, and then converting back seems too much of a hassle for such a > > > simple thing. > > > > > > Is there any way to do it in Gnumeric? Or in OpenOffice.org? In Excel > > > if there is no other way? [BTW: Microsoft Access database doesn't > > > support outer join. Typical for point-and-click products) > > > > > > Thanks, > > > Sasha > > > > > > PS: I know the right way would be to keep all the data in a single > > > spreadsheet, avoiding this problem. However, for reasons you do not > > > want to know, it was impossible - and it is too late now, anyway. > > > _______________________________________________ > > > gnumeric-list mailing list > > > [email protected] > > > http://mail.gnome.org/mailman/listinfo/gnumeric-list > > > > > _______________________________________________ > > gnumeric-list mailing list > > [email protected] > > http://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ > gnumeric-list mailing list > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list
eg-exam.gnumeric
Description: application/gnumeric
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
