Hi guys,
I need to calculate the common area between 2 products
I have multiple of product that are made on series ofequipment. Each equipment has a surface area.
I need to calculate the shared area between 2 selected products. Some products may have more than more than one surface area (column12). So more specifically, the formula should calculate shared area between thelargest surface area of one product and largest surface area of another product
In this example, I am calculating the shared area between product A and D. the largest surface area of product A is 5 and the largest surface area of product D is 6. Two equipment (A and C) are common product A and D. Therefore, the common area between product A and product D is 2.
This is the formula I am using, but it the first product in the table
<style type="text/css">
table.tableizer-table{
font-size:12px;
border:1px solid #CCC ;
font-family:Arial, Helvetica, sans-serif;
}
.tableizer-tabletd {
padding:4px;
margin:3px;
border:1px solid #CCC ;
}
.tableizer-tableth {
background-color:#104E8B;
color:#FFF;
font-weight:bold;
}
</style>
EquipmentName | Equipment Surface Area(m2) | Product A | Product A | Product B | Product C | Product C | Product D | Product D |
---|---|---|---|---|---|---|---|---|
Size | S | L | S&L | S | L | S | L | |
Equipment A | 1 | Y | Y | Y | ||||
Equipment B | 1 | Y | ||||||
Equipment C | 1 | Y | Y | Y | Y | Y | ||
Equipment D | 2 | Y | Y | |||||
Equipment E | 2 | Y | Y | Y | ||||
Equipment F | 3 | Y | Y | |||||
Equipment G | 4 | Y | Y | |||||
Product Surface Area (m2) | 4 | 5 | 6 | 3 | 4 | 5 | 6 |
<tbody>
</tbody>
Last edited: