Buy/Sell Calculation

users
#1

Hello,

I have to calculate prices (buy/sell) and have a question to make it
easier. A little bit maybe :slight_smile:

The file > http://status.sisi-systems.ovh/article_sample.csv

The file contains the columns Article number, text of the supplier,
purchase price, sales price, the lengths and master (1) slave (0).
The factor is for calculating the purchase price. The master (1)
can be ordered, the slave (0) items not. These are blanks.

The question is can I calculate the slaves automatically by
calculation on the basis of the master?

With hand for example:

=C10/E10*E2
=C10/E10*E3
...

With multiple suppliers:
=(C35+C36/2)/E36*E20
=(C35+C36/2)/E36*E21
=(C35+C36/2)/E36*E22

For several articles, this is a monthly job. Isn't there a way to do this
a little automated? Comparison with article number + master / slave? When
it will only work with one supplier it will be okay.

Maybe someone have an idea? It would be great.

Thank you
Silvio