Completed

Web based calculation to get the final excel file result

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.

Kemahiran: Excel, MySQL, PHP, Kejuruteraan Perisian, Ujian Laman Web

Lihat lagi: the final results, price list excel formula, price file, decimal search, php write query result excel file, excel stand programme hmtl web based, extract file names excel, upload web based game web site, excel heat loss calculation, convert window based application web based application, excel paste contents cell web form, convert windows based application web based application, excel project manage template web design, excel critical path calculation

Tentang Majikan:
( 36 ulasan ) Capelle Aan Den Ijssel, Netherlands

ID Projek: #10114214

Dianugerahkan kepada:

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 dalam 3 hari
(41 Ulasan)
4.9

11 pekerja bebas membida secara purata $107 untuk pekerjaan ini

$100 USD dalam 2 hari
(155 Ulasan)
5.9
$155 USD dalam 3 hari
(24 Ulasan)
4.9
$100 USD dalam 5 hari
(56 Ulasan)
5.3
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 dalam 3 hari
(27 Ulasan)
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 Lagi

$138 USD dalam 3 hari
(61 Ulasan)
4.8
ReflexiveData

Hi, Thanks for posting this [login to view URL] check our website: [login to view URL] & reviews. (We are the most preferred freelancer. Please check our badge) Lets discuss! We have extensive knowledge in custom bu Lagi

$30 USD dalam 3 hari
(10 Ulasan)
4.6
IramRajpot

I can help you , you can contact with me in inbox i provide you high quality work. i can provide you much work in less time, Give me a chance i will give you my best output and i hope you are be happy to work with me Lagi

$147 USD dalam 3 hari
(16 Ulasan)
4.4
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 Lagi

$100 USD dalam 5 hari
(9 Ulasan)
4.0
$222 USD dalam 10 hari
(1 Ulasan)
0.8
$35 USD dalam 3 hari
(0 Ulasan)
0.0
chaplayer

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

$155 USD dalam 5 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0