Front Calculation

Copper Contributor
  • I have two sheets. One sheets for available raw material and one sheet for raw material required for final product. Now based on the available raw material i want to find out which of the product i can completely make. Please note that the same raw material are required for multiple products 
2 Replies


Maybe this would be something for you, since all you really need is an extra sheet that brings together the materials from the product and subtracts it from the list. just a suggestion :)



Warehouse inventory

This accessible warehouse inventory template allows users to track and maintain inventory bin locations within a warehouse. This warehouse inventory template includes the ability to print a pick list, be flagged when it's reordering time, retrieve information on specific bins, and keep track of inventory value.

@NikolinoDE thanks for your quick response. The sheet u shared is similar what I need but not completely.