Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #31  
Old 6th April 2012, 08:30 PM
woof43 woof43 is offline
Member
 
Join Date: Jan 1970
Posts: 696
Default

Quote:
Originally Posted by moeee
I've created more confusion today then there was exactly 2012 years ago.

These ain't Ratings Woof43.
I'll try to explain.


I'm not sure if you are aware of my memory , but I barely have one.
Its a terrible handicap to my handicapping.


Moee, could you not just have an a4 sheet that has a series of tables that you just tick or cross or highlight for dogs of note when you have watched a race once, instead of viewing it a number of times,
Reply With Quote
  #32  
Old 6th April 2012, 09:59 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

I toyed with the idea and bull********ted myself that I was going to write notes beside every dog in my database as to running patterns and quirks.
It never happened.
It never will.

I can't explain why.

I dig holes in the back yard and fill them up with dirt from the front yard.
The backyard dirt I bag and throw in the wheelie bin.

I can't explain why.

My Mother suggested it is her fault that I fell on my head at 4 years of age.
It wasn't.
But the incident could explain why I can't explain.

Racing is back tomorrow.
I totally enjoyed todays break.
I totally enjoyed Ravens assistance.

I am copping a hiding and have been for almost a month.
It ends today.
Look for my posts tomorrow everyone if you want some encouragement.
Reply With Quote
  #33  
Old 10th April 2012, 12:32 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

In an 8 horse field there are 56 different possible Box Trifecta Combinations that can occur

I have a Race with 8 greyhounds in it.
In SHEET 1 I have Column A with the Box Numbers and in Column B I have the animals names.
So A1 contains 1 and B1 contains "DOG NAME"

In SHEET 2 I want to do this.
I have written down all the 56 possible Box Trifectas - 123, 124 , 125....678
That is in Columns A,B,C
What I wish to do is have an animals name appear in a Column E when the animals Box Number is in Column A
And So with Column F and Column G.

What Formula do I put in SHEET2 E1?
and then copy that Formula through Column EFG.
Reply With Quote
  #34  
Old 10th April 2012, 01:38 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default

i managed to get something happening with the VLOOKUP Function.
But its not how I wish to do it.

What I want is like this Formula.
=C1
But instead of the 1 its looks in Cell A1 to find the number.
Like =C"A1" or =C(A1) or ="C"(A1)
And A1 would contain a number.
Reply With Quote
  #35  
Old 10th April 2012, 03:34 PM
moeee moeee is offline
Suspended
 
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
Default I'M GOOD!

Thanks for your help whoever may have tried.
But no need assistance anymore.

I managed to find something in the EXCEL Help.
Its called the OFFSET Function.
=OFFSET(F1,A1,0) pretty much does it for me.

Cheers
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 10:46 PM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655