Dutchman is in order, I must start by saying this is the nicest mailing list or other forum of online discussion am on. Joseph if you want to rub *nix guys the right way especially if you talk of that MS spreadsheet here, words like 'csv', 'export', 'import' would get you answers faster. Take sometime to try this out http://catb.org/~esr/faqs/smart-questions.html
regards Joachim --- On Wed, 3/17/10, [email protected] <[email protected]> wrote: > From: [email protected] <[email protected]> > Subject: LUG Digest, Vol 67, Issue 33 > To: [email protected] > Date: Wednesday, March 17, 2010, 2:00 AM > Send LUG mailing list submissions to > [email protected] > > To subscribe or unsubscribe via the World Wide Web, visit > http://kym.net/mailman/listinfo/lug > or, via email, send a message with subject or body 'help' > to > [email protected] > > You can reach the person managing the list at > [email protected] > > When replying, please edit your Subject line so it is more > specific > than "Re: Contents of LUG digest..." > > > Today's Topics: > > 1. Re: Excel blues (Joseph Ssekandi) > 2. Re: Excel blues (Reinier Battenberg) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 17 Mar 2010 01:04:12 -0700 (PDT) > From: Joseph Ssekandi <[email protected]> > Subject: Re: [LUG] Excel blues > To: Linux Users Group Uganda <[email protected]> > Message-ID: <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > Paul, > I knew very well where I was posting and my first > statements were profuse apologies. > My main issue here is that instead of roundly dismissing > anything non open source, to the point of calling them > silly(this really hurt), we could answer them with open > source answers. We don't offer M$ solutions, but we offer > Open Source answers to M$ problems! I challenge you all, > ISN'T THAT THE MAIN SKILL AREA REQUIRED OF ANY OPEN SOURCE > CONSULTANT IN UGANDA AS OF NOW!!! Ability to answer a > clients challenges faced in M$ with Open Source solutions? > Isn't it????????????????????? > If we take my case in point, I posted Excel, someone/anyone > on the list could have answered with the OO version of the > same. I would have gladly appreciated. Someone still did > help me out but using MySQL, but he couldn't post the > replies to the list despite the fact that they were very > beautiful ingenious, cleverly written MySQL statements!!!! > Now I understand why, but I don't agree that it is the right > stand. Let people post their issues, but solutions should > simply be Open Source! Like I said, where we fail to > provide an Open Source solution to a M$, we then pick our > lessons too. > Is that too hard? > > > ________________________________ > From: Paul Bagyenda <[email protected]> > To: Linux Users Group Uganda <[email protected]> > Sent: Wed, March 17, 2010 10:27:06 AM > Subject: Re: [LUG] Excel blues > > > This is a Linux users list. Occasionally, we will go off > and talk about other things. But we try to keep it centred > around OSS issues. Now, asking Excel questions arguably > risks taking us too far off our core purpose, so I do > believe the comments were in order. The SNR > (http://en.wikipedia.org/wiki/Signal-to-noise_ratio ) on > this list is higher than (say) that on i-network precisely > because of this focus. I think most people might like to > keep it that way. For the greater good and so forth. > > Paul > A Ugandan. > > > > On Mar 17, 2010, at 09:57, Joseph Ssekandi wrote: > > 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. > >--------------------------------------- > > > > > > > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://orion.kym.net/pipermail/lug/attachments/20100317/2a9ed3f7/attachment.html > > ------------------------------ > > Message: 2 > Date: Wed, 17 Mar 2010 11:06:59 +0300 > From: Reinier Battenberg <[email protected]> > Subject: Re: [LUG] Excel blues > To: Linux Users Group Uganda <[email protected]> > Message-ID: <[email protected]> > Content-Type: Text/Plain; charset="iso-8859-15" > > > "Every forum has an elder, and many of them work hard to > maintain that status" > > As a matter of fact, you can do very little to prevent > becoming an elder. Its > a matter of time, you see. You'll all get there, be > patient. > > -- > rgds, > > Reinier Battenberg > Director > Mountbatten Ltd. > +256 758 801 749 > www.mountbatten.net > > > > > On Wednesday 17 March 2010 10:39:02 Noah Sematimba wrote: > > Every forum has an elder, and many of them work hard > to maintain that > > status > > > > > ------------------------------ > > _______________________________________________ > LUG mailing list > [email protected] > http://kym.net/mailman/listinfo/lug > > > End of LUG Digest, Vol 67, Issue 33 > *********************************** > _______________________________________________ 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. ---------------------------------------
