I require a wordpress plugin that will allow me to process data.
The data will be supplied in excel format (there must be able to cope with both old style and new excel)
I will add examples of the data.
The data is supplied at different times of the day and lists football matches along with two stats supremecy and total goals.
Supremecy can be a negative or positive figure and I would like the plugin to
1) for supremecy compare new data stats against old data stats to give me movement details. i.e. it man utd/man city was [url removed, login to view] and the newer data was -0.1 this would be a movement of [url removed, login to view] towards the 2nd team (i.e. man city in this example) - So I would like the movement figure and the direction of the movement. the movement figure will should always be expressed as a positive and the direction can be expressed as either towards "home" (the first team, so moving towards 0 from negative or away from 0 if already positive) or "away" (the second team, so moving towards 0 from positive or away from 0 if already negative)
2) the same as point one for the goals stats.
3) The stats may come in at 4 different times during the day. I would like the plugin to compare the stats against the previous stats as well as compare the final stats. so data 1 v data 2, data 2 v data3, data 3 v data 4 and data1 v data 4. If all comparisons in the same direction then this line of data will display a message
4) The plugin will also email when data is uploaded. (option can be turned on/off)
5) the plugin will have a clear current data option to process a new day but keep current data alive until this button is pressed. i.e. data 1 may be uploaded, user may log out of wordpress,user returns later in the day with data 2 and data 1 is ready to be processed against.
6) the plugin will be able to cope if a match is present in one data file but not another.
7) be able to highlight games where the movement figures are above or equal to user defined levels.
Please ask for any clarification. I am currently using a manual way via excel and will attach how this looks.
Please find attached the raw files I would like processed by this plugin (called morning data, midmorning data, afternoon data and evening data) The file also includes my attempt at a spreadsheet called data processing. This only shows the movement figures (althought I think I may have issues with negative to positive movements) and doesn't process goal data or movement diretion which I would like the plugin to do.