Web based calculation to get the final excel file result

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I needs to get the final result file which I attached as a sample (1 April)

The process starts like this

I upload daily price file (sample Daily price list 1 April) in which you have Art No. which is unique and the cost price of the products. On the basis of those cost prices; the prices further calculated with the help of a Macro enabled price calculation file (Sample Price Calculation Formula)

Upon getting the results in Excel file with calculated prices; we copy paste all the data in another file ASIN Search file (file attached) and this file calculate the ASIN through macros.

Once we got both calculated prices and ASIN then we enter all the details in the Final File (1 April) and apply following formulas

1. Conversion of currency up to 3 digits after decimal and get the result in column H

2. Reduce the price 0.5 from the above result and show in column J

3. Add the price 10 of column H and show in column L

3. and the rest of the values simply copied from the previous resultant files of price calculation and ASIN files.

So this is the process which we are following everyday. Now what we want is that

We upload only Daily Price list file and the rest of the calculations should be done automatically and gives me the option to download the final file (1 April).

I should have option to upload whenever it is necessary the revised Master File ASIN and Price calculation file along with the option of entering the currency value such as 0000.738

The whole purpose of this is tor reduce the steps which I have to perform on a daily basis so I am open to any solution no matter it is web based or desktop solution or even within some VB program or any other option.

Excel MySQL PHP Software Architecture Website Testing

Project ID: #10114214

About the project

11 proposals Remote project Active 7 years ago

Awarded to:

macroPOL

Hello, I am Excel and VBA expert. I can complete this project. Please note that I have 100% completion rate and 5-star feedback on projects.

$100 USD in 3 days
(41 Reviews)
4.9

11 freelancers are bidding on average $107 for this job

rinabuoy13

I propose to write c# based application to perform all tasks. I am experienced developer with c#. I can help you with task. Looking to hearing from you. Regards ,

$166 USD in 3 days
(27 Reviews)
4.6
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail More

$138 USD in 3 days
(61 Reviews)
4.8
saraca29n0v

Hello, We are a Web Design and Development company with expertise in latest and legacy technologies to create an awesome product for you. We have he best project management practices to ensure that your project is comp More

$100 USD in 5 days
(9 Reviews)
4.0
chaplayer

Hi i have understood your task. i am python developer. i can do your task with good result. thank you

$155 USD in 5 days
(0 Reviews)
0.0
ifataranargis10

Dear Hiring Manager, I have related expertise for article writing and can deliver the best in next 1 hour. I will make send you the best output and will share the ideas with you. Let us discuss about the project

$35 USD in 1 day
(0 Reviews)
0.0