Ihave a project I need doing in any language that is easy, updateable, quick,able to add to and has a database, at the min it uses a excel workbook and vb but it is long winded to get all the data and add to the workbook.
I want something making that will collect all the data input it all and do all the functions of the workbook with 1 press of a button possibly look similar to the ratings example ? file I have attached where you hover over red triangle ? and it tells you something, with the final table /calculations able to detach from the project with all functions intact so I can email it.
## Deliverables
Hello,I have a project I need doing in any type of language that is easy, updateable,quick, able to add to and will do it with very little input from myself that Ican set to start on a in built timer ( if I want ) so it collects the data etc and applies it to the workbook,and ? includes a database, at the min ituses a excel workbook and vb but it is long winded to get all the data and addto the workbook. I need something that can do all the calculations the excelworkbook does, I prefer not to use excel but if that is the best option then Iwill go with that, if using the excel there will be extra sheets to add to theworkbook and add into the calculations ? they are michaelandsimmons , uk racestats, speed/mph/expectedodds and a comparison ? between expectedodds and actual odds that highlight the one with the largest discrepancy and acolumn where the automated winner predictor would go? and when all the data is entered andcalculations done I want the page with all the calculations on (at the minraces sheet) to be detachable with all the functions intact for columns? P,Q,R and AH to BD basically they just are %at the top of each column that adjust the amount of each column to go into the totalscolumn, so that it is a small file to email to customers.
The second part of the project is to find out what settings and input % would have come nearest to predicting the winner and over time I will be able to build up a database so that when a 6f race at Doncaster comes along I could press a button and it would change my settings to show me the best settings for a race over that course /distance /going etc?
button to use next day to collect /analyse the results of theprevious day mainly distance beaten, from a website and compare the actualresults with my predictions and then using an excel formula and the % columnsfrom my calculations ? races sheet to automatically back fit / work out what % settingsI should have set, to get as close to the race result as possible these will bekept in the database and everytime a days racing at that course is complete itwould add to the others to come up with a mean setting eg?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? AD? ? ? ABAC? ? ? ? AD
1-1-2010southwell 6f good going 80%,90%,100% 80%
AD? ? ? AB? ? ? ? ACAD
3-1-2010southwell 6f good going 90%,90%,80%, 90%
AD? ? ? AB? ? ? ? ACAD
Wouldbecome? ? ? ? ? ? ? 6f? good going 85%,90%,90%? 85% ie the average of the two
?
Onthe Friday the 13th sheet on the races page you will see my end productwith all calculations complete row 221 to 233 and row 491 to 501 are bestexamples of complete calculations.
Theother sheet is the blank sheet which shows all the functions of the workbook
Dataneeds to be collected from
<[login to view URL]>
<[login to view URL]>? ?
<[login to view URL]>
<[login to view URL]>
[[login to view URL]][1]?
<[login to view URL]>
[[login to view URL]][2]? ? ? ? ?
<[login to view URL]>
<[login to view URL]> ?