Home » Account Management » Software Developer for Excel File Calculations

Software Developer for Excel File Calculations

Date Posted —

Type of Work:
Any
Salary:
One time: 200 – 500 USD
Hours per Week:
0

Job Description

I own a software agency and already have one software developer, he however is already working at full capacity, and we have a new project coming up so we decided to look for someone new, who perhaps is more skilled.
I received all the information necessary to create the project so I will be able to guide you on exactly what to do, and you will be working alone so no need to worry. We also plan on finding someone to work with again in the future, so if you do well, we will have plenty more contracts for you :).
This project is fairly straightforward, therefore I think I can explain most of it here and you can let me know if that is something you are capable of.
The software should be:
– web app or .exe application (either is fine)
– Input excel files (if possible pdf’s as well)
What the program does:
It will be a software used by an investment company which compares the values of the offers it receives, therefore the inputed files will be 90% the same as it is all the same offers, but only the prices will be different. The software will then calculate the lowest price, the average price and then for each offer see what percentage it is from the average price. (I will give you more detail when you accept that you can do this)
1. Excel files or PDF’s are uploaded into the application.
2. The program then takes the values from the excel files and automatically does some calculations on the average of all excel files and also find the lowest value from all of the excel files.
3. The information it finds out will then be outputted and easy to read.
As I said, I will explain more later. Just let me know if this is something you are capable of.
Thank you,
Greg
Some more information to better understand the task (I cannot upload files or screenshots here, but I will show once we accept to work together):
The “formulas” that the software must do are:
1. Find out which file has the lowest price for a given row
2. Compare how far away the second lowest price is from the lowest price
3. Calculate the average for each row in each file.
4. Compare how far away each value is from the average of the files.
5. Check if any of the files are different from the others (so the calculations aren’t for something else)
Basically every file has those same columns, and the same “template” for the offer. Therefore the only differences will be in the price columns. There are two price columns, one for the “price per unit” and one for the “total price” which is just a multiplication of how many pieces they require.
The software should check the corresponding row in each file, for example:
File A has price 10 for “box”
File B has price 20 for “box”
So the average price will be calculated and the lowest price will be found:
Average price for “box” is 15
Lowest price for “box” is 10

APPLY FOR THIS JOB:

Company: REAL Brokers
Name: Greg Gogolak
Email:

Skills