1b.app
Link copied -

OS - formula for calculating the quantity of shipped goods

Guys
there is a backfill question
HELP plz with the formula
there is an order and it contains a measured product
its area is measured in square meters
we know
- N total area to be covered
- N1 area covered by the product of one package
- T number of product sheets in one package
- T1 area covered by one sheet
must be calculated according to the area covered
- X integer number of packages
- Y integer number of sheets
I'm starting to overheat
Original question is available on version: ru Вячеслав Легеза

Answers:

- N total area to be covered
divide by
- N1 area covered by the product of one package
get and round - X integer number of packages
and
- N total area to be covered
divide by - T1 the area covered by one sheet
get and round - Y is an integer number of sheets
03.09.2021, 18:46
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

Nicholas
Client wrote:
- N total area to be covered
divide by
- N1 area covered by the product of one package
get and round - X integer number of packages
and
- N total area to be covered
divide by - T1 the area covered by one sheet
get and round - Y is an integer number of sheets

I probably did not set the task accurately enough
so I'll clarify
we need to calculate
an integer number of packages + an integer number of sheets that will cover the total area
in this case some intermediate variables should appear
for example you should get something like this:
- N total area covered
-X+Y
05.09.2021, 21:35
Вячеслав Легеза Original comment available on version: ru

1) We consider the number of packages for the entire area;
2) We count the number of sheets for the entire area;
3) The resulting rounded number of package values is multiplied by the number of sheets in the package;
4) And subtract 2 points from 3.
05.09.2021, 23:20
Original comment available on version: ru

Легеза Вячеслав iCOLOR OneBox
ФОП Легеза В.В.
Personal license

Nicholas
Client wrote:
1) We consider the number of packages for the entire area;
2) We count the number of sheets for the entire area;
3) The resulting rounded number of package values is multiplied by the number of sheets in the package;
4) And subtract 2 points from 3.

great solution and thanks for the help, Nicholas
put + for the correct answer
if you are interested in solving real problems in real time, you can go to the master class, which starts today at 18:00
You can apply using this link
https://icoloronebox.org/oneboxschool/
after the application, the manager will call you within two hours, familiarize you with the conditions and answer all your questions
06.09.2021, 08:58
Вячеслав Легеза Original comment available on version: ru

Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter. Log in and comment