Hello Didier,
So let’s talk about the complex part 🙂
You can use the “SKU” mapping, to map the SKU of the product inside the Excel file. In this way you can recognize what is the specific product:
https://altoswebsolutions.com/manual/woo-price-calculator/creating-a-calculator-from-a-spreadsheet-file-pro
(Search for “SKU” inside the documentation page)
Then you could use the conditional logic (Based to a specific cell value) to hide/show the two different input/output fields:
https://altoswebsolutions.com/manual/woo-price-calculator/conditional-logic
So the same logic could be applied to both problems. You need to create two (or more) different input fields, with different items and show/hide the right field using conditional logic. In your Excel file you should provide for each different input field a cell. When cell is not used by the calculator a “0” is written inside the cell. When cell is used by the calculator the selected field value is written instead (In this way you can recognize which of the fields is shown/hide).
Kind Regards,
Enrico
AT1454