New Posts For Thread: f/a/o Compound Magic or anyone who can help with ratings excel formula etchttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etcI am working on completing my own ratings and am a novice at it so need help with 3 things please 1. how to convert my ratings to expected prices the the best rating would be 200 and the lowest 02. how to convert distance beaten into my ratings sothanks worked a treathttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528636095#528636095thanks worked a treatThu, 31 Jan 2013 08:10:28 -0600you can format the cell as number, 2 decimal places.https://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528635657#528635657you can format the cell as number, 2 decimal places.Thu, 31 Jan 2013 07:51:17 -0600last questionhow do you change to get result to show just e.g 5.71 instead of 5.714285714https://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528635313#528635313last questionhow do you change to get result to show just e.g 5.71 instead of 5.714285714Thu, 31 Jan 2013 07:40:06 -0600got it ta =SUM(A2*16/B2)=SUM(F2*19/G2)https://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528635181#528635181got it ta =SUM(A2*16/B2)=SUM(F2*19/G2)Thu, 31 Jan 2013 07:35:13 -0600sorry guys I am novice with excel, can you tell me simply how to enter it in to a spreadsheethttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528634443#528634443sorry guys I am novice with excel, can you tell me simply how to enter it in to a spreadsheetThu, 31 Jan 2013 06:59:25 -0600thanks top rated will give them a gohttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528634391#528634391thanks top rated will give them a goThu, 31 Jan 2013 06:55:50 -0600Re. Q2 (I think you've had a reply to Q1 over on the Horse Racing forum).I found these formulas in an old spreadsheet for converting distance beaten in lengths to a poundage figure.[b]Flat[/b](lengths beaten * 16) / (race distance in furlongs)e.g. Behttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528560293#528560293Re. Q2 (I think you've had a reply to Q1 over on the Horse Racing forum).I found these formulas in an old spreadsheet for converting distance beaten in lengths to a poundage figure.[b]Flat[/b](lengths beaten * 16) / (race distance in furlongs)e.g. BeMon, 28 Jan 2013 10:30:30 -0600thanks Livermore it works a treat this thread is also on horse racing forumhttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528281903#528281903thanks Livermore it works a treat this thread is also on horse racing forumTue, 22 Jan 2013 09:43:17 -0600thank you will try thathttps://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528281639#528281639thank you will try thatTue, 22 Jan 2013 09:33:53 -06003 - try:=((AH34+AK34+AM34)=12)*5)https://community.betfair.com/general_betting/go/thread/view/94082/29639125/fao-compound-magic-or-anyone-who-can-help-with-ratings-excel-formula-etc?post_id=528280823#5282808233 - try:=((AH34+AK34+AM34)=12)*5)Tue, 22 Jan 2013 09:08:21 -0600