2
Надежда
no recommendations
no complaints
Project title: I need an Excel form.
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Cash, Bank transfer, Electronic money
Acceptance of requests: from 2019-08-16 until 2019-08-31
Type of cooperation: One-time project
Section: Software development
Prepayment: without prepayment
Payment methods: Cash, Bank transfer, Electronic money
Acceptance of requests: from 2019-08-16 until 2019-08-31
Project description:
Programmer services are required. Excel form is required (if you can unload from 1c). The meaning of the formula EXCEL: enter data - get the result. Offer your price.
Baseline data
Goods code number warehouse
36678 4 tg
36678 5 eyesight
36678 2nd
36678 1 toll
36678 7 sv
36678 3 cm
36678 2 cit
36678 1 az
36678 0
36678 6 baht
34321 22 tg
34321 30 eyesight
34321 12
34321 8 toll
34321 39 sv
34321 45 cm
34321 90 s.
34321 8 az
34321 0
34321 5 baht
Data obtained:
Table with the following columns
The shop that gives away
shop-keeper
code
the amount that needs to be moved
Each store name should be made gray or white fill, so that when aligned in alphabetical order (dependence on the first and three names of warehouses) they go through one of the two.
It will be:
Tg br 35461 3
Tg zor 76544 5
Grey.
Thief ak 87651 2
Bath, see 53218 15
White.
Please consider my task. Is it possible to do it, how much will it cost?
The challenge
I'm waiting for your payment offers!
There's a retail chain of 10 stores.
There is a problem described below in the example:
Shop 1 and Store 2.
The store has 1-4 caps.
The store has 2-0 caps.
You need to move 2 caps from store 1 to store 2 to level the amount.
There are thousands of such goods. Relocations are made for all 1 time per month.
The task is to distribute goods automatically using mat. The formula is to automatically generate the movements.
It is necessary to create automatic movements in cases of large discrepancies based on the report on the balances of goods. Warehouses, groups of goods and goods can be selected.
1) Report ready!
(2) Automatic processing
(3) The result is the untransfer of goods.
2- More details:
Terms will be used where
Item is the name of the product (in the form of a ready-made code)
The value of the number of an element (always integers)
The group is the warehouses where the goods are stored (in the form of a ready-made code).
Cases in which formulas are applied:
1. If the value is more than 20 nothing
If the value is less than 20
2. Internal comparisons begin.
If the difference between the elements from each other (may be a comparison of the largest and the smallest) in the group does not exceed 20%, then nothing.
If the difference is approximately equal (more than 19.5%) or more than 20%,
3. The unit of the item in the group is moved to the situation 1 by the least number of transactions with priority to the items with the highest sales (there is a bar with sales in the report).
Case of exceptions
When values do not exceed or equal to 3, form in the group the maximum number of elements with a value of 3, then with a value of 2, even if the values of 0 are formed.
Exceptions to this exception:
Bags and belts. (to be spelled out in the group code)
It is desirable to solve this problem without unloading-downloading)
Programmer services are required. Excel form is required (if you can unload from 1c). The meaning of the formula EXCEL: enter data - get the result. Offer your price.
Baseline data
Goods code number warehouse
36678 4 tg
36678 5 eyesight
36678 2nd
36678 1 toll
36678 7 sv
36678 3 cm
36678 2 cit
36678 1 az
36678 0
36678 6 baht
34321 22 tg
34321 30 eyesight
34321 12
34321 8 toll
34321 39 sv
34321 45 cm
34321 90 s.
34321 8 az
34321 0
34321 5 baht
Data obtained:
Table with the following columns
The shop that gives away
shop-keeper
code
the amount that needs to be moved
Each store name should be made gray or white fill, so that when aligned in alphabetical order (dependence on the first and three names of warehouses) they go through one of the two.
It will be:
Tg br 35461 3
Tg zor 76544 5
Grey.
Thief ak 87651 2
Bath, see 53218 15
White.
Please consider my task. Is it possible to do it, how much will it cost?
The challenge
I'm waiting for your payment offers!
There's a retail chain of 10 stores.
There is a problem described below in the example:
Shop 1 and Store 2.
The store has 1-4 caps.
The store has 2-0 caps.
You need to move 2 caps from store 1 to store 2 to level the amount.
There are thousands of such goods. Relocations are made for all 1 time per month.
The task is to distribute goods automatically using mat. The formula is to automatically generate the movements.
It is necessary to create automatic movements in cases of large discrepancies based on the report on the balances of goods. Warehouses, groups of goods and goods can be selected.
1) Report ready!
(2) Automatic processing
(3) The result is the untransfer of goods.
2- More details:
Terms will be used where
Item is the name of the product (in the form of a ready-made code)
The value of the number of an element (always integers)
The group is the warehouses where the goods are stored (in the form of a ready-made code).
Cases in which formulas are applied:
1. If the value is more than 20 nothing
If the value is less than 20
2. Internal comparisons begin.
If the difference between the elements from each other (may be a comparison of the largest and the smallest) in the group does not exceed 20%, then nothing.
If the difference is approximately equal (more than 19.5%) or more than 20%,
3. The unit of the item in the group is moved to the situation 1 by the least number of transactions with priority to the items with the highest sales (there is a bar with sales in the report).
Case of exceptions
When values do not exceed or equal to 3, form in the group the maximum number of elements with a value of 3, then with a value of 2, even if the values of 0 are formed.
Exceptions to this exception:
Bags and belts. (to be spelled out in the group code)
It is desirable to solve this problem without unloading-downloading)
