Dear all, Personally I was stung by this rude dutchman's post below and I had decided to let it go only that a few interesting things have turned up. 1. This isn't the first mailing list I am subscribing to and all lists have a certain characteristic about them(rude, polite, helpful, strictly expert, talkers etc). I decided to find out about yours and guess what, no archives available at http://kym.net/mailman/listinfo/lug !!! Where are your archives? 2. Just after this post, one of the list members contacted me offlist and we worked on this problem. Using MySQL!!!!!!! We created the database, exported the excel file I posted into a CSV and imported it into the database using the LOAD DATA INFILE command, when it reached there we wrote a number of beautiful SQL statements using order by, limit, multiple where clauses, creating subtables from queries and so on. We only stopped because on other Excel dedicated forums I had got the answers. SIMPLE LESSONS IN THIS: - Lets not be narrow minded, if a M$ problem comes up, we can solve it in Open source and hence indirectly convert the poster.If we can't atleast that will be a lesson learn. Lets not simply discard. If the list had kept an open mind, believe me, what happened off list would have been invaluable to any MySQL newbie. Throw in the experts, it would have been explosive. - Every forum has an elder, and many of them work hard to maintain that status. I was made to understand that this Victor fellow is highly respected on this forum but from such statements, its time you challenged his stand and question his other postings and views. They could be counter productive.
Regards Joseph. ________________________________ From: Victor van Reijswoud <[email protected]> To: Linux Users Group Uganda <[email protected]> Sent: Mon, March 15, 2010 9:38:29 PM Subject: Re: [LUG] Excel blues Can we get these kind of silly excel questions of the list - this is linux/open source/unix list. There are plenty of excel/M$ lists in the world. Search and you will find. Victor On Sun, Mar 14, 2010 at 1:44 PM, Joseph Ssekandi <[email protected]> wrote: > Nope, no class assignment. > Trying to develop a system to beat the bookies :-) > If you look at both spreadsheets, you can see the trend. Now are you going > to help me? > > Regards > Joseph. > > > ________________________________ > From: Mwirima Byaruhanga <[email protected]> > To: Linux Users Group Uganda <[email protected]> > Cc: Joseph Ssekandi <[email protected]> > Sent: Sun, March 14, 2010 10:52:15 AM > Subject: Re: [LUG] Excel blues > > If this is a class assignment, cheating is bad. > > Joseph Ssekandi wrote thus on 3/14/10 11:28 AM: >> OK guys, no offense meant whatsoever by asking for excel help but I am >> excel challenged and I seem not to have anywhere else to turn :-( >> In the the first file attached, is a sheet showing the 2006 Turkish >> league. Could you guys help in how I can fill out columns G, H, I, J? >> Remember, at one point a team is a home and another point the team is away. >> The computations should be consistent. >> In the second file, is payment record for 3 men to a loan shark over a >> given period. This morning, the loan shark received a payment of $2.25 but >> it wasn't marked from who. What is the probability that the payment was from >> Geronimo? What is the probability that the payment was from Herod? What is >> the probability that the payment was from Amon? >> Your kind help will be greatly appreciated >> >> Kind regards >> >> Joseph >> >> >> >> >> >> >> _______________________________________________ >> LUG mailing list >> [email protected] >> http://kym.net/mailman/listinfo/lug >> %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ >> >> The above comments and data are owned by whoever posted them (including >> attachments if any). The List's Host is not responsible for them in any way. >> --------------------------------------- >> > > > > _______________________________________________ > LUG mailing list > [email protected] > http://kym.net/mailman/listinfo/lug > %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ > > The above comments and data are owned by whoever posted them (including > attachments if any). The List's Host is not responsible for them in any way. > --------------------------------------- > > > _______________________________________________ LUG mailing list [email protected] http://kym.net/mailman/listinfo/lug %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The List's Host is not responsible for them in any way. ---------------------------------------
_______________________________________________ LUG mailing list [email protected] http://kym.net/mailman/listinfo/lug %LUG is generously hosted by INFOCOM http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The List's Host is not responsible for them in any way. ---------------------------------------
