The formula used in the chamfer length column is ("Left H"*Stone Height + "Right H"*Stone Height + "Up H"*Stone Width + "Down H"*Stone Width)*Number of Stones, because of "H" , "H", "Up H", "Down H" these four columns of data, there are only two types of 1 and 0, so there will be no more or less calculation, so that you can use the method of stretching formulas. Calculate the total length of the chamfer of each grey herringbone stone mosaic tile. The small surface area is also used in this way to calculate the small surface area of each grey herringbone stone mosaic tile.
One column of pricing, the formula used is three items: one column with the projected area in the stone blanking list * the fixed cell in red font in the above figure is 160 yuan/square meter, and one column with the chamfer length * the fixed cell in red in the above figure 5 yuan/meter, one column with a small surface area* The red font in the above figure fixes the cell at 200 yuan/square meter, and these three items can be added together. These prices are all reference data. For this kind of form, you only need to adjust the red text in the upper left corner of the above picture when you settle the settlement.
This table can basically cover commonly used L-shaped grey herringbone stone mosaic tile.
Let's take a look at the way the table is used to calculate the quantity: This picture is very small and unclear, so let's enlarge the outside of the printing area (the right half) separately: for the content of the "processing technology" in the blanking list, To calculate the bonding length and small surface area based on the keyword.
The algorithm of small surface area is similar to that of flat stone, the bonding length is L in the blanking list multiplied by the processing quantity.
The pricing method is the same as the method of grey herringbone stone mosaic tile, and the settlement adjustment is only to adjust the data in the red font.
