Registration form for receiving medical protective supplies

Registration form for receiving medical protective suppliesIt is usually used to register the materials received by medical staff during the epidemic prevention period. It is generally used in the pharmaceutical industry excel template and is provided by Huajun Software Park. After free downloading, the registration form for receiving medical protective materials can be used for secondary modification in Excel and WPS.

The registration form for receiving medical protective materials includes the ward number, body temperature, recipient, mask, sterile cotton balls, medical gloves, disinfectant alcohol, and disinfectant. In addition, there is also a tabulated total quantity of the items received.

General Tips for Registration Form for Receiving Medical Protective Materials

​ ​ 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. Change number format

Excel’s shortcut keys are not chaotic, but follow a certain logic.

For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.

In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).