Your Competitions
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
04 Sep 11
12:46
Joined:
Date Joined:
06 Mar 02
When I took over the settling of this division, I said it was for a limited period until someone else could be found to take over permanently.
I'm quite happy to carry on for a while longer but I just thought I'd mention that the opportunity is there for anyone who's champing at the bit to have a go at it.
However, I no longer have the benefit of being able to use the Excel spreadsheet which the other settlers do. This spreadsheet has an excellent macro built in to it which calculates everything at the click of a button and sticks the finished table on the clipboard ready to be pasted on the thread. There's no work involved other than entering the selections and the results - a 10 to 15 minute job. It's superb.
But I don't have Excel on this computer. I dug out my old computer and used that initially, but it gave up the ghost a few weeks ago so I now have to settle and prepare everything manually which is very time-consuming, as you can imagine. I've streamlined it as much as I can and it's a lot quicker for me now than it was a month ago. Even so, it still takes a long time compared to using the pre-prepared Excel spreadsheet.
So, any help I can get from you lot in the way you type your selections would be very much appreciated.
The selections appear on the spreadsheet like this:
Hot Rod Mamma - 3.30 Thirsk
A few of you have complied with previous requests to post selections in this format and now do it every time, for which I'm extremely grateful. All I have to do is copy and paste it with no need for any editing.
But I still have to edit the majority of them, even if it's only putting the dash in the middle, or typing in the meeting because someone's just written Y for York or Yarmouth or whatever, or capitalising words because the poster's too lazy to do it. Frankly it's a time-consuming pain in the arse which I could well do without.
I have to do 30 of these a day. You only have to do it once.
So please, please try to get into the habit of typing out your selections EXACTLY the way they appear on the spreadsheet. It would be an enormous help to me.
Thanks very much - and the best of luck for today.
I'm quite happy to carry on for a while longer but I just thought I'd mention that the opportunity is there for anyone who's champing at the bit to have a go at it.
However, I no longer have the benefit of being able to use the Excel spreadsheet which the other settlers do. This spreadsheet has an excellent macro built in to it which calculates everything at the click of a button and sticks the finished table on the clipboard ready to be pasted on the thread. There's no work involved other than entering the selections and the results - a 10 to 15 minute job. It's superb.
But I don't have Excel on this computer. I dug out my old computer and used that initially, but it gave up the ghost a few weeks ago so I now have to settle and prepare everything manually which is very time-consuming, as you can imagine. I've streamlined it as much as I can and it's a lot quicker for me now than it was a month ago. Even so, it still takes a long time compared to using the pre-prepared Excel spreadsheet.
So, any help I can get from you lot in the way you type your selections would be very much appreciated.
The selections appear on the spreadsheet like this:
Hot Rod Mamma - 3.30 Thirsk
A few of you have complied with previous requests to post selections in this format and now do it every time, for which I'm extremely grateful. All I have to do is copy and paste it with no need for any editing.
But I still have to edit the majority of them, even if it's only putting the dash in the middle, or typing in the meeting because someone's just written Y for York or Yarmouth or whatever, or capitalising words because the poster's too lazy to do it. Frankly it's a time-consuming pain in the arse which I could well do without.
I have to do 30 of these a day. You only have to do it once.
So please, please try to get into the habit of typing out your selections EXACTLY the way they appear on the spreadsheet. It would be an enormous help to me.
Thanks very much - and the best of luck for today.
Show More
undecided 29 Aug 11 15:45
Robin Goodfellow Daily Mail nap, until and including Wed 7th
Robin Goodfellow Daily Mail nap, until and including Wed 7th
If you are doing it long hand MOMM, you've got plenty of time on your hands mate, try www.openoffice.org, if you know how to do spreadsheets or can remember your excel set up you should be able to crack this ok, it's free too 
There's a download for it here MOMM www.onetekteke.tk/
That's what I'm using - OpenOffice.
The very complicated macro written for Excel doesn't translate to OpenOffice which is why I have to do most of it manually.
If you know how to rewrite it so that it will work in OpenOffice, that would be great.
The very complicated macro written for Excel doesn't translate to OpenOffice which is why I have to do most of it manually.
If you know how to rewrite it so that it will work in OpenOffice, that would be great.
| POS | CHG | FORM | NAME | SELECTION | RESULT | +/- | TOTAL |
| 1▲ | 221 | DFCIRONMAN | Fishforcompliments - 4.30 York | lost | -1.00 | £13.00 | |
| 2▲ | +1 | 011 | Healing Hands | - | 0.00 | £4.75 | |
| 3▲ | -1 | 121 | penzance | Catching Zeds - 3.45 Font | lost | -1.00 | £4.25 |
| 4▲ | 112 | look - it's snowing | - | 0.00 | £3.63 | ||
| 5▲ | 131 | MOB | - | 0.00 | £3.50 | ||
| 6 | +1 | 211 | Cloughie1 | - | 0.00 | £3.33 | |
| 7 | +1 | 011 | learning thegame | - | 0.00 | £3.00 | |
| 8 | +1 | 011 | Ashmal | - | 0.00 | £2.63 | |
| 9 | -4 | 001 | unluckyStu | Tornadodancer - 2:35 Dund | lost | -1.00 | £2.50 |
| 10 | +1 | 111 | BinocularsNotNeeded | - | 0.00 | £1.90 | |
| 10 | +1 | 111 | stealthgun | - | 0.00 | £1.90 | |
| 12 | -2 | 010 | Ming_the_Merciless | Citizens Charter - 1.50 York | lost | -1.00 | £1.50 |
| 12 | +1 | 103 | raspberrybottom | - | 0.00 | £1.50 | |
| 14 | -1 | 010 | cannyman | Satanic Beat - 1.50 York | 3rd 5/2 | -1.00 | £0.50 |
| 15 | +1 | 010 | Poppydog | - | 0.00 | £0.25 | |
| 16 | +1 | 120 | kwalker | - | 0.00 | £0.00 | |
| 17 | -2 | 013 | flyingbolt | Satanic Beat - 1.50 York | 3rd 5/2 | -1.00 | -£0.25 |
| 18 | 001 | midas7 | - | 0.00 | -£1.17 | ||
| 19 | +1 | 021 | Kentish Man | - | 0.00 | -£1.75 | |
| 19 | +3 | 2d0 | elvissss | Akinspirit - 5.40 Dund | Won 5/4f | 1.25 | -£1.75 |
| 21 | 0n0 | undecided (3) | - | 0.00 | -£2.00 | ||
| 22 | -3 | 100 | shanelee1966 | Henri Prends Garde - 5.20 Font | pu | -1.00 | -£2.60 |
| 23= | -1 | 2d2 | Horny38DD | - | 0.00 | -£3.00 | |
| 23= | -1 | 320 | The Grey One | - | 0.00 | -£3.00 | |
| 23= | -1 | 200 | majorupshotbagley | - | 0.00 | -£3.00 | |
| 23= | -1 | d00 | betme | - | 0.00 | -£3.00 | |
| 23= | -1 | 03d | age21 | - | 0.00 | -£3.00 | |
| 28▼ | -6 | 200 | bosstipper | Swilly Ferry - 3.30 York | lost | -1.00 | -£4.00 |
| 28▼ | -6 | 200 | miscreant man | Parisian Pyramid - 3.30 York | 2nd 9/2 | -1.00 | -£4.00 |
| 28▼ | -6 | 000 | IntheGroove | Mandalay King - 4.30 York | lost | -1.00 | -£4.00 |
Sorry that should read:
Indochina - 4.40 Bath
Thanks.
Indochina - 4.40 Bath
Thanks.
for major upshot bagley:
Into the Wind - 5.10 Bath
Cheers
Into the Wind - 5.10 Bath
Cheers
I suppose there's always the danger that some numpties have got it configured to 'sort by: Newest first' and may not bother looking at the opening post. I hadn't thought of that.
Thanks everyone that's read it so far. It's going to make it so much easier for me.
Thanks everyone that's read it so far. It's going to make it so much easier for me.
Hi MOMM.
Thanks for digging out Mr Keyte's Naps on my behalf last week and for your kind resume of my August efforts. Much appreciated.
Just getting back in the saddle and amazed to find myself in Div 1 albeit only by virtue of a retirement. There's some seriously good players up there so I'll probably be back with you soon.
Cheers,TM
Thanks for digging out Mr Keyte's Naps on my behalf last week and for your kind resume of my August efforts. Much appreciated.
Just getting back in the saddle and amazed to find myself in Div 1 albeit only by virtue of a retirement. There's some seriously good players up there so I'll probably be back with you soon.
Cheers,TM
Sorry MOMM i didn't post the dash...
Whats for Pudding - 3.50 Newc
Whats for Pudding - 3.50 Newc
undecided
Robin Goodfellow Daily Mail nap: Tigger - 5.00 Newton Abbot
Robin Goodfellow Daily Mail nap: Tigger - 5.00 Newton Abbot
Morning Island - 19:35 Roscommon
Sorry it's a late one
Sorry it's a late one
Can't help there MOMM, got a job to re-write anything.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539