I need some advice and help.
I'm working on a few methods of developing point spreads and i'm looking for a way to use my time more efficiently.
I need help on the following topics:
Excel or OpenOffice Math or A program in C.
Basically to run all the individual game though the formulas is insanely time consuming. All i do is plug numbers into different things game after game. All the numbers originate from the same place and i know there has to exist a way to set this up so all the work is done for me automatically. Maybe Excel is not capable but i think it might be. If its not, i used to know C but i haven't used it in 4 years so i'm very rusty (to the point of not remembering anything), but with some help maybe i could write a program that does what i need.
These are more or less the steps i'd like to do.
1) Import a table into Excel from a Website automatically. Not sure how this is done but i think it should be possible. Its not super important because i can paste a table in there manually each day, not a big deal.
2) Import a schedule into excel. Again if its too hard i can do it manually.
3) Now based on the schedule, i want excel to pick out the team that matches and i want it to pick out the boxes in the table i use for calulations and plug those into my questions.
As a result, all i'd need to do i open excel. update the data from the web (automatically) and it would spit out the lines for each game on the day. Worst case i'd need to manually paste in the schedule and table but i but the rest to be done automatically.
Sooo, who wants to help?
1st question to get out of the way since i have OO, is this even worth trying or do i need Excel?
I'm working on a few methods of developing point spreads and i'm looking for a way to use my time more efficiently.
I need help on the following topics:
Excel or OpenOffice Math or A program in C.
Basically to run all the individual game though the formulas is insanely time consuming. All i do is plug numbers into different things game after game. All the numbers originate from the same place and i know there has to exist a way to set this up so all the work is done for me automatically. Maybe Excel is not capable but i think it might be. If its not, i used to know C but i haven't used it in 4 years so i'm very rusty (to the point of not remembering anything), but with some help maybe i could write a program that does what i need.
These are more or less the steps i'd like to do.
1) Import a table into Excel from a Website automatically. Not sure how this is done but i think it should be possible. Its not super important because i can paste a table in there manually each day, not a big deal.
2) Import a schedule into excel. Again if its too hard i can do it manually.
3) Now based on the schedule, i want excel to pick out the team that matches and i want it to pick out the boxes in the table i use for calulations and plug those into my questions.
As a result, all i'd need to do i open excel. update the data from the web (automatically) and it would spit out the lines for each game on the day. Worst case i'd need to manually paste in the schedule and table but i but the rest to be done automatically.
Sooo, who wants to help?
1st question to get out of the way since i have OO, is this even worth trying or do i need Excel?