program(repost)

I have a large excel 2007 spreadsheet and I think I want to change it into anaotomated~26nbsp~3b data base ~28 or something else ~2copen to suggestions because I don~27t know how to use one ~29 that will speed all my process [url removed, login to view] is to do with uk horse racing importing data from various sites to create a rating for a horse and then compiling the odds that my horse should be compared to the actual price and then highlighting any anomoly. then I want to be able record results and compare the result to my ratings and see if any track course~26nbsp~3b distance going~26nbsp~3b is specialy suited to my ratings then to add results in excel format from which the distances horses were beaten can be extracted and then compare the results with my ratings and back fit my ratings to the result to see if my ratings can be improved ~3cbr /~3e

## Deliverables

~3cbr /~3e ~3chr /~3e This broadcast message was sent to all bidders on Sunday Mar 29~2c 2009 7~3a01~3a30 PM~3a~3cbr /~3e ~3cbr /~3e this is a more detailed summary of the majoriy of the things I want in the prog Here is what I want to be able to do with as much automation as poss bearing in mind that I have no experience of databases Firstly like my spreadsheet it has to analyse all the data I input and produce a rating like the spreadsheet does and save every settings I have used for that particular day i.e the ~25 column settings for each race/distance/draw/going meeting ~2cso as soon as I have the same meeting /going/distance I can have an option to change all the settings to what I had before . I want to be told how to add and remove columns from the database without it affecting the formulas After each days racing I want to be able to enter the distance each horse was beaten into the database and compare automatically how it did in comparison with the ratings which would give me a figure to show how correct/ efficient I had been so if my top rated won it would be 100~25 if my 2nd rated won that would be 95~25 if my top rated was beaten 5 lenghts it would be a certain ~25 incorrect if my total outsider won that would be 0~25 and so on ~28 working on the exact way to work this ~29 you may have ideas a database which will record all my daily selections and how they did where I can input data and then use it to back fit the ratings to match the winner by the prog automatically adjusting the ~25 on top of each column until it found the best fit to show what the best ratings should have been for each individual race/distance going /for that day then recording those and next time we had the same conditions for a race automatically adjusting the ratings to those And then recording all the best settings for each course and over each distance and on each going I have a spreadsheet which I input data via csv file from http~3a//[url removed, login to view] into 2 dataform columns and csv file from http~3a//[url removed, login to view] after logging in then after logging in to racing post go to cards and results /choose race/from drop down box select show all the days cards~2c then for each meeting one at a time /show all races at this meeting on one page ~2c copy and paste using paste special ~28 text ~29 to the racing post page of the spread sheet~2c then http~3a//[url removed, login to view] select all /copy the paste into Adrian massey of spreadsheet then http~3a//[url removed, login to view] log in then todays racing/ one page rating/ and for each track change standard to base jumps and apply / copy and paste into b2 of hrb last page of spreadsheet then on the nofrllsbetfair page I click on the nofrills macro and it loads the no frills page https~3a//[url removed, login to view] ~28 site down for next 3 weeks or so ~29 then in the enter value sheet column W I enter the race times column AE I enter the the six highlighted numbers from this string https~3a//[url removed, login to view]~3fmi~3d100463153~26amp~3bex~3d1~26amp~3borigin~3dMRL this number is different for every race then select first race I want to bet on that day e.g http~3a// [url removed, login to view] /[url removed, login to view]~3fmi~3d100462768~26amp~3bex~3d1~26amp~3borigin~3dMRL and paste it into AL on enter values spreadsheet then back to nofrills page and click the load refresh market makro and all runners should load into column D on races sheet and all data should be all filled in and added up. I want to be able to add about another 50 columns of data mainly from csv files which will all be added up in the way I want with columns I can adjust like the ones I have at the min all the positive columns go into the AX column before going into the final total I want to be able to merge the cells to achieve a combined total eg if I have three “ speed columns “ I might want to merge them into a median column and so have one column From the total of my ratings I want a formula to work out what price in the betting that it should be and compare it with the prices in column AA of the races sheet and highlight if there is an anomaly I WANT TO AUTOMATE HAS MUCH OF THE DATA INPUTTING AS POSSIBLE On my spreadsheet I type the bets into column V ~2cW and it fills in the email sheet for me which I can copy and paste into an email and columns Z~2cAA and it records those bets into the emailnursery ~2c I also need a new column to do the same with daily backs I want to be able to extract a page similar to the races page with all the finalized data on it and all functionality of ~25 changes and no frills betting input~2c so that I can send it to my customers and they can change the ~25 on any column to create there own final total

* * *This broadcast message was sent to all bidders on Monday Mar 30, 2009 7:37:10 AM:

this is more of the detail to add to description of what I want Here is what I want to be able to do with as much automation as poss bearing in mind that I have no experience of databases I have a spreadsheet which I input data via csv file from [url removed, login to view] into 2 dataform columns and csv file from [url removed, login to view] after logging in then after logging in to racing post go to cards and results /choose race/from drop down box select show all the days cards, then for each meeting one at a time /show all races at this meeting on one page , copy and paste using paste special ( text ) to the racing post page of the spread sheet, then [url removed, login to view] select all /copy the paste into Adrian massey of spreadsheet then [url removed, login to view] log in then todays racing/ one page rating/ and for each track change standard to base jumps and apply / copy and paste into b2 of hrb last page of spreadsheet then on the nofrllsbetfair page I click on the nofrills macro and it loads the no frills page [url removed, login to view] ( site down for next 3 weeks or so ) then in the enter value sheet column W I enter the race times column AE I enter the the six highlighted numbers from this string [url removed, login to view] this number is different for every race then select first race I want to bet on that day e.g http:// [url removed, login to view] /[url removed, login to view] and paste it into AL on enter values spreadsheet then back to nofrills page and click the load refresh market makro and all runners should load into column D on races sheet and all data should be all filled in and added up. I want to have streaming betfair prices from the nofrills site or lite or betfair .com And be able to enter my bets into the prog and press a button and my bets will be sent to betfair I want to be able to add about another 50 columns of data mainly from csv files which will all be added up in the way I want with columns I can adjust like the ones I have at the min all the positive columns go into the AX column before going into the final total I want to be able to merge the cells to achieve a combined total eg if I have three “ speed columns “ I might want to merge them into a median column and so have one column From the total of my ratings I want a formula to work out what price in the betting that it should be and compare it with the prices in column AA of the races sheet and highlight if there is an anomaly I WANT TO AUTOMATE HAS MUCH OF THE DATA INPUTTING AS POSSIBLE On my spreadsheet I type the bets into column V ,W and it fills in the email sheet for me which I can copy and paste into an email and columns Z,AA and it records those bets into the emailnursery , I also need a new column to do the same with daily backs I want to be able to extract a page similar to the races page on the spreadsheet with all the finalized data on it and all functionality of % changes and no frills betting input, so that I can send it to my customers and they can change the % on any column to create there own final total I have an excel sheet with the formulas on for the ratings and an example of how they work the that need to be worked into the prog and I need the losing margin in points from that sheet to be variable and change all the other points pro rata so if I change one it changes them all. I also have a excel sheet which has the formula for working out a price what a horse should be according to my ratings I need a way of automatically importing the distance beaten from [url removed, login to view] and using the beaten by distance to compare my ratings and give my ratings an overall % of efficiency To get to that page you have to log in [url removed, login to view] using micky and nuinbase then go/results search/results and form follower /date/go/ highlight a race then we need to input Dist Bt and do this for every uk race each day I want to be told how to add and remove columns from the database without it affecting the formulas a database which will record all my daily selections and how they did where I can input data and then use it to back fit the ratings to match the winner by the prog automatically adjusting the % on top of each column until it found the best fit to show what the best ratings should have been for each individual race/distance going /for that day then recording those and next time we had the same conditions for a race automatically adjusting the ratings to those And then recording all the best settings for each course and over each distance and on each going

PHP

Nº del proyecto: #3770782

Sobre el proyecto