I need help creating a table in excel that will count the profitability of in-house and outsourced trasport orders

Employer

PARTNERS SP. Z O.O. SK

Description

the table is to collect data and automatically recalculate them, the difficulty is that the calculation of profitability of orders may consist of 5 to max 7 sections in which there is a loss on one section of the route and a profit on another, the orders would be finally settled in a full loop and the profit/loss of a given loop would be calculated, each section can be run by a different logistician (would like it to be visible, for example. different color for each logistician), only part of the columns would be active for logisticians, the rest would be uneditable for logiticians but editable for the manager

Published

on 2024-04-11