Updating data from one file with residues to another, both files

PHP, Web Programming, Enterprise Resource Planning (ERP) — incorrectly specified categories?

30 USD

Client's review of cooperation with Aleksandr K.

Updating data from one file with residues to another, both files

30 USD

This is the second time I use the services of Alexander. The project was completed in less than a day.
Quick feedback and the quality of the work done.
I strongly recommend.

5.0

Aleksandr S.

Reciprocal Feedback

31 May 2019

Freelancer's review of cooperation with Aleksandr S.

Updating data from one file with residues to another, both files

30 USD

I recommend cooperation

5.0

Project translated automatically. Log in or register, to view the original There are two Excel files. file with remains of 1C where there is a field of items and remains in the warehouse and the resulting file in which you need to pull the data - remains in the warehouse.The field of articles is the field in which we make a comparison. In the file with residues we are interested in the item and the amount in the warehouse.the item from this file needs to be converted into the form - word-article, that is, before each item to attach "word-", it needs to be compared to the item with the final file Then in the final file to draw the remaining values minus 2, i.e. if the remaining file is 4 pieces on a specific position then we draw 4 minus 2, i.e. 2. If the value is negative, we draw 0.If the item was not found in the remains when compared, we also draw 0.Then, based on the values of the extended remains in the final file, you need to set Y (it is available, the remains are more than 0) or N (not available, the values of the remains are 0) in one column. Generally how that is so.It is necessary that the operator can select these two files, place them in the processor and on the output download the updated resulting.

Proposals 7