Template for the order cost calculator table and their accounting
Consists of two sheets:
1. Sheet "Guides"
In this sheet, variables that affect the cost of the order (for example, printing on t-shirts) will be entered.
Also, data about your customers should be entered here.
2. Sheet "Orders"
To calculate the cost of orders, you need to select the required values in the corresponding cells (only the green-colored columns should be filled in, the others will be filled in automatically).
Filters for displaying summary data by any criteria have already been added in the first row.
Video instruction with step-by-step slides - at the link
1. Sheet "Guides"
In this sheet, variables that affect the cost of the order (for example, printing on t-shirts) will be entered.
Also, data about your customers should be entered here.
2. Sheet "Orders"
To calculate the cost of orders, you need to select the required values in the corresponding cells (only the green-colored columns should be filled in, the others will be filled in automatically).
Filters for displaying summary data by any criteria have already been added in the first row.
Video instruction with step-by-step slides - at the link