I need a program that I can run on my PC (windows) that will gather data and take a weighted average of specific numbers in a table on a specific website. This is to be designed for a very specific website, so the data will always be displayed the same way. ?
The tricky part is that the website that I am using displays the numbers I need AND numbers I won't need.
The numbers that I wish to effect the calculation can be determined by scanning the text in first column each row of the table.
As far as navigating to the website I plan to do that on my own 100%, I only need this program to scan the table and take a weighted average of the numbers of a certain type.
If possible I would prefer that the coder tries to make this program simple so that it does not take up much processing power. It is a relatively trivial calculation that needs to be done, I just don't want to have to do it by hand anymore.
After going through the steps to post this advertisement, I would like to be slightly more specific that this program must be able to differentiate between different types of data in the same table. The first column of each row will identify the different types of data, and I want this program to pick out only the types of data that I am looking for and it must exclude all other data in the table. I believe that this can be down by checking the first column of each row for a specific combination of letters.
As a quick example, there may be a relatively small table displayed like this:
FLH SH ? ? | ? 3.55 ? ? | ? 564
FLH ? ? ? ? ? | ? ? 2.54 ? | ? ? 545
FLH SH ? ? | ? 1.34 ? ? | ? ? 431
FLH ? ? ? ? ? | ? ? 0.94 ? | ? ? 432
If we were using this example table above, I would want the weighted average of the rows designated "FLH SH", and I would like the rows designated "FLH" to be ignored. So I would like this program to identify the correct rows and then take the following weighted average:
[(3.55*564)+(2.54*545)] / (564 + 546) = 3.05
This is the result that I am interested in, and accuracy ? of 2 significant digits beyond the decimal will be acceptable.
It is also very important to note that this program must be able to handle negative numbers, as some of this data may include negative numbers.