Google Sheets Price Calculator
Source data: list of manufacturers, goods, prices, size of goods
TZ: Create a drop-down list from the manufacturer to the product, draw true size of the product and price, in case of non-standard sizes the possibility of entering customer data and recounting the price according to them
Complete: the list of the manufacturer, depending on which manufacturer is selected - only its goods are drawn. From which goods are chosen, the dimensions and price are drawn. If in the name there is a "non-standard" note, then in the standard sizes is empty and the user is lighted a column and line to fill the non-standard sizes, the price of the goods is recounted.
TZ: Create a drop-down list from the manufacturer to the product, draw true size of the product and price, in case of non-standard sizes the possibility of entering customer data and recounting the price according to them
Complete: the list of the manufacturer, depending on which manufacturer is selected - only its goods are drawn. From which goods are chosen, the dimensions and price are drawn. If in the name there is a "non-standard" note, then in the standard sizes is empty and the user is lighted a column and line to fill the non-standard sizes, the price of the goods is recounted.