Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Maiden1

Pages: [1] 2 3 ... 40
1
General discussion / Re: Excel Questions
« on: June 29, 2015, 11:14:16 AM »
Put in column c2

=IF(A2=A1,C1+1,1)

Then copy that formula down to the bottom of c column

2
Down / Re: Down Club Hurling & Football
« on: June 28, 2015, 11:51:38 PM »
Its hard to argue with their results anyway 5sams. Ask Lecale was attempted about 3 years ago, i think it would be worth looking at again but it would need to be trialled over 5 years to give it a chance of working.
I think it was trialed with 3 teams. Might be better with 5 or 6 teams at least.  Kilclief, Saul, Bright, Ardglass, Darragh Cross, Teccaunaught. If it not taken seriously with a proper management structure training once or twice a week there would be no point.

3
Down / Re: Down Club Hurling & Football
« on: June 28, 2015, 09:13:27 PM »
Maiden just out of interest who are these players you think might make county players?
Michael Magee was 1 player I'd have liked to have seen given more of a shot, Packing Downie scored a goal against Tyrone when he was 20 and was forgot about for 10 years. Chris Duggan was brought into the panel twice after Bosco got to.2 intermediate finals but never played a minute in the Mckenna cup.  Those are the type of strong physical players I'd like to see brought onto the panel and given more time. At the minute the team starts with 6 similar nippy forwards with no one to win a high ball if the other team has a sweeper stopping the low ball. Possession at kickouts is another issue against better teams at the minute if Down get through a couple of rounds of the qualifiers they are going to be up.against Neil Gallagher, David Moran, the O'Sheas etc. when they meet the big teams.  If Down only win 1 out of 3 kickouts VS  2 our if 3 for the other team then there forwards only see 1/2 the ball the other forward line will. It is very hard to win.

At minor level it is also dominated by players from the same schools, who all know each other, were as players from non traditionally strong clubs are overlooked that I feel would have been.good additions to the panel if they are integrated in properly.

4
Down / Re: Down Club Hurling & Football
« on: June 28, 2015, 10:34:06 AM »
Down will continue to struggle at minor and senior level until they start choosing from the whole county.  Since Pete McGrath every other manager has managed Down like a club manager with a small squad i.e.  picking the best players from the best teams around and tried to make the best of the small squad, irrespective of whether that squad have the right attributes to make a successful county team.  Because of this we end up with 6 similar forwards and a midfield area that would struggle to break even against any of the top teams. 

Contrast this with when Pete McGrath was in charge, there was 8 players from East Down on the Down team in 1991, over 1/2 the team played most of there club football outside of division 1.  Burren had 2 players on the team in 1991 and 0 in 1994 even though Burren were still one of the best teams in Ireland (They lost ulster final replay in 1992).  Nearly all the team where over 6ft and good athletes.

Now if there was a player playing for e.g. Bright who is 6ft 4, good in the air, fast, a good engine, that can break a tackle they would never have any chance of being considered for a trial but a really top manager should be able to coach a player like that to be good county player.

5
General discussion / Re: Excel Questions
« on: May 24, 2014, 03:14:19 PM »
Change the code in E1 to =SUM($A$1:$A$3) .  You can change other cells and it won't change the range.

you can do this, but in a spreadsheet you would probably have wanted to copy the formula.
Using the "everything up to current row/column" is a reasonable default for SUM, you can always change it.
But formulas changing because of the alteration of cells not in the range covered by the formula is not on.

Definitely strange it does that.  Another way to do the formula is below where it offsets by 2 cells.  You can copy the formula using this.

=SUM(A1:OFFSET(E1,0,-2))

6
General discussion / Re: Excel Questions
« on: May 24, 2014, 02:57:18 PM »
Change the code in E1 to =SUM($A$1:$A$3) .  You can change other cells and it won't change the range.

7
GAA Discussion / Re: Paul Hearty 17 SFC medals Is this a record. ?
« on: October 29, 2013, 04:57:02 PM »
St Vincents Dublin contested every football final but 2 between 1948 to 1977 (winning 23).  They won 8 hurling titles between 1953 and 1967. 

Kevin Heffernon has 15 football and 6 hurling championships.  There may be others that have more combined medals (Heffernan quit hurling when he was 29).  e.g.  The Fergusons would have played more hurling, even if they had more football medals and played football alongside Heffernan.  Des won a couple of additional senior football championships when he moved to Meath.

http://en.m.wikipedia.org/wiki/Kevin_Heffernan_(Gaelic_footballer)

8
General discussion / Re: Things that make you go What the F**k?
« on: April 08, 2012, 12:24:36 PM »
http://www.bbc.co.uk/sport/0/rowing/17645929

Right don't know what to make of this. Clearly it's a bit mad but, was this a sabotage or just an act of stupidity?
Think some sort of protestor. They have been charged with a public order offence.
http://elitismleadstotyranny.squarespace.com/

9
General discussion / Re: Excel Questions
« on: March 07, 2012, 02:24:13 PM »
Something like below should work if the values you are looking for are in Sheet2 in top left corner.

Then if you enter X3 in Cell A:1 in Sheet1

and have below in cell B:1

=IF(ISNA(VLOOKUP(A1,Sheet2!$A1:$C3,2,FALSE)),"",VLOOKUP(A1,Sheet2!$A1:$C3,2,FALSE))

Cell B:1 would have value 'Thing 3'.

There may be better ways of populating the cells.

10
General discussion / Re: Excel Questions
« on: March 01, 2012, 08:00:17 PM »
That works maiden, getting my head around it now, thanks again. Where's the applause smile??? This one will have to do  :-*






 :P
haha good stuff :)

11
General discussion / Re: Excel Questions
« on: February 29, 2012, 09:12:57 AM »
Thanks lads. Was thinking of something like Hardy's but macros might be what I'm really after, excel skills are poor to never used, thanks for the idea and the work Maiden.

Did a bit of coding in college so just stepping through your code am I right in thinking that will just return the maximum number of consecutive rows that are greater than 984?

I need to record every instance where there is at least 10 consecutive entries great than 984 (remember there can be a gap of one entry less that 984 after at least 5 consecutive entries as long as it is followed by another 5 consecutive entries greater than 984). Ideally row C will store every instance of these consectutive entries so, for example, if you take the instance of all the numbers in my previous post the output would be:

15
13

I suppose I can use something like the below to save each consecutive count number once it reaches two entries less than 984?

intSaveRow + 1
Cells(intSaveRow , 3) = intCountConsecutive

Yes that is correct it only records the maximum in row 1,3

If you want to record everytime it > 15 then

Where it has

                If intMaxCount < intCurrentCount Then
               
                    intMaxCount = intCurrentCount
               
                End If

Change that to

                If intCurrentCount >= 15 Then
               
                        Cells(intCurrentRow - 2, 3) = intCurrentCount
               
                End If

12
General discussion / Re: Excel Questions
« on: February 28, 2012, 03:19:00 PM »
I was thinking something like above  ::) or you could write a macro something like below to do a max count if all the values where always in column A.

Private Sub cmdCount_Click()

Dim intCurrentCount As Integer
Dim intCurrentRow As Integer
Dim intCountConsecutive As Integer
Dim intMaxCount As Integer
Dim blnFound As Boolean

blnFound = True
intCurrentCount = 0
intCurrentRow = 0
intMaxCount = 0

While blnFound

    intCurrentRow = intCurrentRow + 1
   
    If Cells(intCurrentRow, 1) = "" Then
   
        blnFound = False
   
    Else
   
        If Cells(intCurrentRow, 1) > 984 Then
           
            intCurrentCount = intCurrentCount + 1
            intCountConsecutive = intCountConsecutive + 1
       
        Else
       
            If intCountConsecutive < 5 Then
           
               
                If intMaxCount < intCurrentCount Then
               
                    intMaxCount = intCurrentCount
               
                End If
               
                intCurrentCount = 0
           
            End If
           
       
            intCountConsecutive = 0
           
        End If
   
    End If


Wend


Cells(1, 3) = intMaxCount

End Sub

13
GAA Discussion / Re: Quiz question
« on: February 17, 2012, 09:51:39 PM »
Oisin has 15 Armagh County Medals(including 13 in a row)
God knows how many Armagh league medals
Countless underage medals
9 Ulster Club Medals
5 All-Ireland Club Medals (soon to be 6)

With the County,

7 Ulsters
1 NFL
2 All- Stars
1 All-Ireland

Before Oisin, Rangers never won anything outside Armagh, and Armagh never won anything full stop.

Has to be the most underrated player ever.  Guaranteed 4 points plus and win a couple of handy frees whether in the first round of the Armagh club championship or the AI final.

14
GAA Discussion / Re: Quiz question
« on: February 17, 2012, 04:53:02 PM »
Jimmy Barry Murphy came close to winning the lot.

Minor
Munster U21
Senior
NFL
Railway Cup
2 Club All Irelands

When you add that he won everything going in hurling as well and got to a FAI cup final with Cork Celtic it is not a bad feat.

15
General discussion / Re: Only in America
« on: February 10, 2012, 04:27:38 PM »
5 million cans between 12 people in a year, so that would be 1141 cans per day per person  :-\, no wonder the children have foetal disorders.

Pages: [1] 2 3 ... 40