This project should be very simple for those who have experience in creating excel files using Java!
Basically, I want someone who can create the excel document "end example", from the excel document "start example" in an automated way using Java, so that I can specify any excel file with similar data to the "start example" and it will create a document similar to the "end example", but for the new data.
I want to be able to specify any excel file from any location on my computer, which has one column and roughly 80000 rows of information (see attached - "start example"), and then to produce the rest of the information I have in the excel file "end example" I have attached below.
Explanation of "end example":
Column A - values from start example
Column B - the difference between the current value and the previous one as a proportion
Column C - just a copy and paste of column B to ensure the formulas didn't change when I was calculating everything in excel (not necessary if you can do without it)
Column D - a classification of the numbers in column B (or C), whether they are very low(1), low(2), high(3), or very high(4)
To classify a very low number, a low number, and so on, we need to calculate the mean and standard deviation of all the numbers in column B (or C), as shown in Columns I and J, at rows 23 and 24, therefore very low being 1 standard deviation less than the mean, low being anything less than the mean, high being less than or equal to one standard deviation above the mean, and very high being greater than one standard deviation above the mean. This is shown in columns I,J and K in rows 26-29.
Columns E&F - the x and y points for the graph to be drawn, using the equation shown if you click on a cell from row 6 onwards.
Effectively, the bottom left corner of the graph is 1, bottom right is 2, top left is 3, and top right is 4. The graph draws points using the symbols from column D. For example, if the symbol is 1, it draws a point halfway between the current position (where the last point was drawn) and the bottom left corner. To start this process, points are drawn at the 4 corners (0,0), (10,0), (0,10) and (10,10), and then we start at the centre of the graph, i.e. (5,5), as shown in rows 1-5.
Columns G-O - space for the graph to be placed (doesn't matter if you can't position the graph there, I can move it myself) and for the mean, standard deviation, very low, low, high and very high values to be written.
Column P - starts from rows 6 onwards, and calculates which quartile on the graph the point is in, using the equation shown if you click the cells. The graph is split into 16 quartiles, with 1 being the bottom left quartile, and 16 being the top right quartile.
Columns R-AH - calculates the matrices using the information from column P, frobenius norms etc. Please click on the cells to identify what I have done.
As I mentioned before, I want the Java file to create all columns mentioned above, but in an automatic way, so that I can specify any excel document (or CSV file if xsls file is not possible) with just a column A starting from row 6, with different values, but an infinite amount (as the amount of data varies from file to file), and the java file will then replicate all what I have done in "end example" but for the new data.
Please let me know if you have any questions, I understand what I have written might be hard to understand.
Also, I am happy to receive the project in iterations, so would like to receive versions of the java file that can for example just do the work for columns A-O, if possible, so I can see if you are doing the right thing, or help you understand something if need be.
I also have a lot of other very similar work which I will be willing to pay you for afterwards, if you are able to do this well!