Find Jobs
Hire Freelancers

Automate excel document in Java

£20-250 GBP

Completed
Posted about 10 years ago

£20-250 GBP

Paid on delivery
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!
Project ID: 5484885

About the project

18 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello there, I can help you with this project. I have experience with manipulating Excel files using Java. Please check out my profile for reviews on other jobs I've finished and contact me if you are interested. Thank you.
£99 GBP in 3 days
5.0 (77 reviews)
5.8
5.8
18 freelancers are bidding on average £137 GBP for this job
User Avatar
Hello Sir, I am Bing from China,I am a senior Java developer , and I have lots experience on createing excel files in Java, I am confident I can do this project for you,please consider my serious bid. Thanks&Best, Bing
£240 GBP in 5 days
4.9 (109 reviews)
7.3
7.3
User Avatar
Hi Sir, I am ready to work for you.I have 9 years of experience in java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. Please visit my profile once. Thanks with regards, Amit
£170 GBP in 3 days
4.9 (150 reviews)
7.1
7.1
User Avatar
I have 6 years experience in JAVA and worked on similar projects which creates/reads/updates excel files using java. Please provide some example excel file and expected output excel file. Thnaks.
£222 GBP in 5 days
4.9 (95 reviews)
6.7
6.7
User Avatar
Hi: I'm an experienced Java developer and I have worked on the creation of excel files using java using POI, Java Excel Api and I can provide you with the program that will automatically generate the end example from start example. Let's discuss it on PM or Skype
£200 GBP in 3 days
5.0 (66 reviews)
6.2
6.2
User Avatar
hello, I'm a java, j2ee application developer with over 10 years experience. I'm very happy to get this project done for you. I can start now. Regards, Rick
£231 GBP in 3 days
4.9 (20 reviews)
5.9
5.9
User Avatar
Hi, Whatever bids that you are getting here is on a higher side. Why don't you ping me to discuss things in detail? You can reach me on skype (axeeffect2002). I am a java programmer having over 6 years of experience so you can expect quality code my my side. I have worked on reading from the excel file and creating a new excel file using java technology so I think I can deliver you the solution. Looking forward hearing from you.
£66 GBP in 3 days
5.0 (12 reviews)
3.8
3.8
User Avatar
Hi, I have 4 year of experience in Java development. Additionally I am OCJP passed developer. I had created one application to ready and modify excel file using jexcel api. Let me know if you are interested.
£111 GBP in 3 days
4.9 (7 reviews)
3.9
3.9
User Avatar
I Have done several projects in Java. I have also developed applications in which I have modified excel files using my Java tool and satisfied my clients with similar tools. I can send you tools which I have developed Which automatically modifies excel sheets according to user inputs. Thank you for going through my proposal.
£111 GBP in 5 days
5.0 (8 reviews)
3.3
3.3
User Avatar
Hi! I can do exactly what you want with python, and is multiplatform like java. But if you prefer to do that in Java, i can make that too. In both cases, you will have an UI for browsing and select the excel files. Regards, JM
£205 GBP in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Java Desktop apps are my favorites I had done many java apps which allows me to be the perfect one for the job
£100 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a very well experienced Java developer and Have experience in the knowledge and technology that is the requirement of the project.
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
2
Payment method verified
Member since Feb 25, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.