Tips for using tea quotation template
Tea quotation template excel templatePreparation of:
Green tea: unfermented tea (zero fermentation degree).
Yellow tea: slightly fermented tea (fermentation degree is 10~20m) Huoshan Huangya, Meng'er Silver Needle, Mengding Huangya
Oolong tea: Also known as green tea, it is a semi-fermented tea, that is, it is properly fermented during production to make the leaves slightly red. It is a kind of tea between green tea and black tea.
Black tea: Fully fermented tea (fermentation degree is 80~90m) Keemun black tea, lychee black tea, Hanshan black tea, etc.
Dark tea: post-fermented tea (fermentation degree is 100m) Pu'er tea Liubao tea Hunan dark tea (Qujiang flake golden tea) Jingwei Fu tea (original place is Xianyang, Shaanxi)
The raw materials are coarse and old, and the accumulation and fermentation time during processing are long, making the leaves dark brown in color, and are pressed into bricks.
White tea: lightly fermented tea (fermentation degree is 20-30m), such as Silver Needle and White Peony. It is processed without frying or kneading. Only the tender and hairy tea leaves are dried in the sun or with slow fire. The white hairs remain intact.
1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Multi-condition judgment
If the department is production and the position is mainly for operations, there is a high temperature subsidy. Use the formula in column D:
=IF(AND(B2="Production",C2="Main Operator"),"Yes","No")
3: Conditional summation
Use the SUMIF function to calculate the total score of a class:
=SUMIF(D2:D5,F2,C2:C5)
4: SUMIF usage is:
=SUMIF(condition area, specified summation condition, summation area)
In layman’s terms, it can be described as:
If the class in the D2:D5 area is equal to the "first class" of the F2 cell, then sum the area corresponding to the C2:C5 cell.
The tea quotation template excel template is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need the tea quotation template excel template Excel form download, come and download it quickly.Employee monthly appraisal form template,Company employee monthly appraisal formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works