Find Jobs
Hire Freelancers

Automate excel document in Java

£20-250 GBP

Terminado
Publicado hace alrededor de 10 años

£20-250 GBP

Pagado a la entrega
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!
ID del proyecto: 5484885

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
5,0 (77 comentarios)
5,8
5,8
18 freelancers están ofertando un promedio de £137 GBP por este trabajo
Avatar del usuario
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 en 5 días
4,9 (109 comentarios)
7,3
7,3
Avatar del usuario
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 en 3 días
4,9 (150 comentarios)
7,1
7,1
Avatar del usuario
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 en 5 días
4,9 (95 comentarios)
6,7
6,7
Avatar del usuario
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 en 3 días
5,0 (66 comentarios)
6,2
6,2
Avatar del usuario
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 en 3 días
4,9 (20 comentarios)
5,9
5,9
Avatar del usuario
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 en 3 días
5,0 (12 comentarios)
3,8
3,8
Avatar del usuario
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 en 3 días
4,9 (7 comentarios)
3,9
3,9
Avatar del usuario
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 en 5 días
5,0 (8 comentarios)
3,3
3,3
Avatar del usuario
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 en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
London, United Kingdom
5,0
2
Forma de pago verificada
Miembro desde feb 25, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.