Tips for using tea quotation sheet
tea quotationPreparation 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: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3: Multi-condition search
It is required to check that the department is production and the position is the name of the director.
The formula is:
=LOOKUP(1,0/((B2:B9=F2)*(C2:C9=G2)),A2:A9)
The writing method of multi-condition query of LOOKUP function is:
=LOOKUP(1,0/((condition area 1=condition 1)*(condition area 2=condition 2)),query area)
4: Calculate text equations
To calculate the text formula in the cell, first click on the first cell where you want to enter the formula and define the name:
Calculation = EVALUATE(C2)
Then enter the formula in the cell:
= Calculate
The tea quotation form is a very practical form, and most of the filling forms are for general purposes. If you happen to need to download the tea quotation Excel form, please download it quickly.Short personal summary of the assessment form,Personal Assessment Form Self-AssessmentIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works