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
General discussion / Re: Excel Questions
« on: September 23, 2015, 09:53:49 AM »
I have a link from a pivot table in one workbook to a separate workbook, each day the pivot table updates and adds an extra row - does anyone know how I can link my excel workbook to the value as opposed to the cell, so that when the pivot table updates and I want the link to draw the value from A2 as opposed to A1 as was the previous days?

When you are setting up the initial pivot table instead of putting the range as Sheet1!$B$1:$C$4 you could put the range as Sheet1!$B$1:$C$1000.  That way you would have the complete range for 1000 days.  After you set it up you can filter out blanks.

General discussion / Re: Excel Questions
« on: June 29, 2015, 11:14:16 AM »
Put in column c2


Then copy that formula down to the bottom of c column

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.

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.

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.

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.


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.

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.

General discussion / Re: Things that make you go What the F**k?
« on: April 08, 2012, 12:24:36 PM »

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.

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


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

There may be better ways of populating the cells.

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  :-*

haha good stuff :)

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:


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

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
        If Cells(intCurrentRow, 1) > 984 Then
            intCurrentCount = intCurrentCount + 1
            intCountConsecutive = intCountConsecutive + 1
            If intCountConsecutive < 5 Then
                If intMaxCount < intCurrentCount Then
                    intMaxCount = intCurrentCount
                End If
                intCurrentCount = 0
            End If
            intCountConsecutive = 0
        End If
    End If


Cells(1, 3) = intMaxCount

End Sub

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

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

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

Pages: [1] 2 3 ... 40