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
Down / Re: Down Gaa Championship 2016. Prediction Competition
« on: September 09, 2016, 09:35:37 AM »
Sunday 11th Sep 2016
1 30 PM   Castlewellan   ST PAUL'S   vs   TECONNAUGHT   TBC
3 00 PM   Castlewellan   DUNDRUM   vs   DRUMGATH   Shane Lowey

General discussion / Re: 11-Plus Proposal
« on: September 08, 2016, 03:51:09 PM »
It has never been as unfair as it is now.  Some schools give test papers every day where as others stick to the rules and only give out 1 or 2 past papers.  It's then up to the parents, the parents with the most money who can afford the best tutors.  Even if you hear about a good tutor they are booked up years in advance.

I happened to be in the kitchen of a house last year and the persons daughter had a tutor in.  I heard the tutor read out a multiple choice question, something like what is 40% of 2000.  The wee girl looked up at the tutor and said 600 and the tutor nodded her head.  800?  Very good, next question...

I felt like saying to the girls mum are you actually paying someone 25 pounds an hour for that.  How does someone qualify to become a tutor if that is the standard of some of the teaching.

Down / Re: Down Club Hurling & Football
« on: June 08, 2016, 09:58:55 PM »
Guevara the main problem with McKernan in my eyes is that he has had to move position so many times to try and plug the gaps left by others who are not available for whatever reason.

Kevin McKernan had a great season at chb in 2010 but is barely 6ft so to expect him to win a high percentage of kickouts against the best midfielders in Ireland is unrealistic.  A midfielders first criteria should be that if either team kick the ball long that they will have a decent chance of either catching the ball clean or making sure that that the opposition doesn't and be athletic enough to get up and down the pitch.  Anything else they can do is a bonus.  There is plenty of very successful intercounty midfielders e.g.  Neil Gallagher, Michael Dara Macauley, Eamon Burns .. who I would not describe as great footballers in the purest sense but have performed very important roles for there teams.
Similarly in the forward line Down seem to pick players and then put them in positions as opposed to pick a system and then find players for each position within the system.  In 1991 and 1994 Shorty Trainer was one of the best club players in Ireland but Down went with Greg Blaney in chf, they did not try to find a way of having 2 play making 1/2 forwards and sacrifice a ball winner like Peter Withnall or Aidan Farrell to accomodate.

Maybe a few Div 1 players would be better than Div 2 players at this stage.

I think that the perception that all county players should be playing in division 1 and most at the top of division 1 is a problem.  In the 1991 and 1994 1/2 the starting team was outside division 1.  In 1992 Burren lost in an ulster final replay to Lavey but there was 0 Burren players starting for Down between 1992 and 94.  In Fermanagh there is 21 senior clubs, last year Pete McGrath had at least 1 panel member from 20 of those clubs.
We need a system in place to firstly identify and then bring potential players through from all over the county and if we have potential players from weaker teams that would benefit from a weights program or some specialised coaching to bring them up to county standard then we should do this.  I like the model Kerry have to find players where they have 4 divisional teams in division 1 made up of the best players from all the other teams, the divisional teams in Kerry cannot be relegated.  It's almost impossible to expect a manager to come in to manage Down and expect them to know every player throughout the whole county, even if they did watch a match how would they know if a potential player stars because they are good or because the player he is marking is sh1te.  If they were corner back on a divisional team and could keep Benny Coulter scoreless then at least you know you have someone that is worth watching a second time.
There is a lot of rose tinted glasses about bringing Benny and Dan back, that it will solve all Downs problems but Benny will be 35 next year, it's not like we are 1 player short of winning something like Cork where when they brought Dinny Allen back in 1989.  Good as Benny and Dan where in there prime it was certainly no guarantee of success if we look at the championship defeats Down have had over the years when they were playing.
01/08/1999 DOWN 0 - 10 3 - 12 ARMAGH
28/05/2000 DOWN 1 - 7 0 - 13 ANTRIM
09/06/2001 DOWN 2 - 4 1 - 13 ARMAGH
02/06/2002 DOWN 1 - 6 3 - 12 DONEGAL
08/06/2002 DOWN 0 - 14 1 - 16 LONGFORD
13/07/2003 DOWN 4 - 8 1 - 17 TYRONE
20/07/2003 DOWN 1 - 5 0 - 23 TYRONE
26/07/2003 DOWN 2 - 10 3 - 15 DONEGAL
30/05/2004 DOWN 2 - 12 3 - 13 CAVAN
03/07/2004 DOWN 0 - 10 1 - 15 TYRONE
22/05/2005 DOWN 1 - 6 1 - 13 TYRONE
03/07/2005 DOWN 2 - 9 3 - 8 DERRY
04/06/2006 DOWN 1 - 11 1 - 12 DONEGAL
17/06/2006 DOWN 0 - 4 1 - 7 SLIGO
10/06/2007 DOWN 1 - 15 2 - 15 MONAGHAN
07/07/2007 DOWN 0 - 8 1 - 10 MEATH
29/06/2008 DOWN 0 - 11 1 - 12 ARMAGH
02/08/2008 DOWN 0 - 12 2 - 13 WEXFORD
17/05/2009 DOWN 0 - 10 0 - 13 FERMANAGH
18/07/2009 DOWN 0 - 17 1 - 15 WICKLOW
19/09/2010 DOWN 0 - 15 0 - 16 CORK
28/05/2011 DOWN 1 - 10 1 - 15 ARMAGH
23/07/2011 DOWN 0 - 14 2 - 20 CORK
22/07/2012 DOWN 0 - 13 2 - 18 DONEGAL
04/08/2012 DOWN 2 - 9 3 - 18 MAYO
23/06/2013 DOWN 0 - 9 0 - 12 DONEGAL
06/07/2013 DOWN 1 - 5 0 - 13 DERRY
24/05/2014 DOWN 0 - 12 3 - 11 TYRONE
13/07/2014 DOWN 0 - 11 1 - 18 KILDARE
07/06/2015 DOWN 0 - 11 0 - 12 DERRY
27/06/2015 DOWN 2 - 11 2 - 16 WEXFORD
05/06/2016 DOWN 0 - 9 2 - 22 MONAGHAN

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

Pages: [1] 2 3 ... 40