Smartgambler
Pro-Punter

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

To advertise on these
forums, e-mail us.

Reply
Page 1 of 2 1 2 >
 
Thread Tools Search this Thread Display Modes
  #1  
Old 18th March 2013, 08:37 PM
M60 M60 is offline
Member
  
Join Date: Nov 2011
Posts: 16
Default formula for 4 placings
Hi . separate the 4 or 6 last start placing in Colm B Row 3.as.5127 or 245127 and put each in another Colms,7 in colm C,-2 in-E,-1 in F,-5 in G.then if it has 6 placings .4 in H.and 2 in i. l could then use for horse career start,win 2nd and 3rd.Thanking you..M60

























Attached Files
File Type: xlsx Formula Help4 Placings 1.xlsx (77.1 KB, 635 views)
Reply With Quote
  #2  
Old 19th March 2013, 08:52 AM
Surround Surround is offline
Member
  
Join Date: Sep 2005
Posts: 66
Default Formula Help for Placings
Here 'tis
Attached Files
File Type: xlsx Copy of Formula Help4 Placings.xlsx (77.4 KB, 648 views)
Reply With Quote
  #3  
Old 19th March 2013, 03:18 PM
M60 M60 is offline
Member
  
Join Date: Nov 2011
Posts: 16
Default Formula Help 4 placing
Mate thank you very much for solving the 4 placings much appreciated...can l ask one more favour the horses career starts-wins-2nds-3rds....l thought l could use your formula for that but no luck...can you help with that ...again Thank you......M60
Attached Files
File Type: xlsx Copy of Formula Help4 Placings again.xlsx (77.8 KB, 634 views)
Reply With Quote
  #4  
Old 19th March 2013, 04:03 PM
Surround Surround is offline
Member
  
Join Date: Sep 2005
Posts: 66
Default Career Placings
This will do it.
Attached Files
File Type: xlsx Career Placings.xlsx (9.4 KB, 650 views)
Reply With Quote
  #5  
Old 19th March 2013, 07:40 PM
M60 M60 is offline
Member
  
Join Date: Nov 2011
Posts: 16
Default Surround Mate Thanks
Surround Mate thank you for the two excel fixes...much appreciated...that career one is a real great help Thanks again...M60
Reply With Quote
  #6  
Old 19th March 2013, 09:14 PM
M60 M60 is offline
Member
  
Join Date: Nov 2011
Posts: 16
Default Surround Mate Trouble
Surround Mate.... having trouble making it work...l've Attach what l did..must be missing something...yeah l know between the ears... lots of greys...hope you can help again ....Thanks M60
Attached Files
File Type: xlsx Career Placings.xlsx (80.6 KB, 615 views)
Reply With Quote
  #7  
Old 19th March 2013, 10:58 PM
Surround Surround is offline
Member
  
Join Date: Sep 2005
Posts: 66
Default Career Placings
Yes it's those dashes causing it I think. There will be a way to do it but I can't recall it at the moment.
The career figures I used were from The Virtual Formguide website and those formulae handle any number of starts & placings.
This will keep you going for a while until someone with more skills comes along.
Attached Files
File Type: xlsx Career Placings.xlsx.xlsx (81.3 KB, 601 views)
Reply With Quote
  #8  
Old 20th March 2013, 07:48 AM
M60 M60 is offline
Member
  
Join Date: Nov 2011
Posts: 16
Default Surround again many thanks
Well l'll just manual put in if over 10...aleast l've got a great start thanks to you...all best M60
Reply With Quote
  #9  
Old 20th March 2013, 11:06 AM
Surround Surround is offline
Member
  
Join Date: Sep 2005
Posts: 66
Default Formula for placings
This will do it all for you no matter how many placings.
A bit ugly but it works.
All the best.
Attached Files
File Type: xlsm PLacings Example.xlsm (10.9 KB, 617 views)
Reply With Quote
  #10  
Old 28th March 2013, 10:24 AM
M60 M60 is offline
Member
  
Join Date: Nov 2011
Posts: 16
Default Last Help welll
Hi Surround...

been struggling again and using your last great help.....but been trying to get rid of that Distance word so l can use your formula of taking 12-4-2-5
in different colm....and everything going good have a few probelms to sort out .... Thanks again
Attached Files
File Type: xlsx Last Help welllll .xlsx (9.5 KB, 490 views)
Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

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 02:38 PM.

Contact Us - OZmium Pty Ltd - Archive - Terms of Use - Privacy Statement - Top

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