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.
---------------------------------------
