Tips for using the medical device classification table How to compile a medical device classification table?
1. In order to standardize the classification of medical devices, these rules are formulated in accordance with the "Regulations on the Supervision and Administration of Medical Devices".
2. These rules are used to guide the formulation of medical device classification catalogs and determine the management categories of new medical devices.
3. The meanings of relevant terms in these rules are:
(1) Intended purpose
“ Refers to the effects that should be achieved by using a medical device as stated in the product instructions, labels or promotional materials.
(2) Passive medical devices
A medical device that does not rely on electricity or other energy sources, but can perform its functions through energy generated by the human body or gravity.
(3) Active medical devices
Any medical device that relies on electrical energy or other energy sources, rather than energy directly generated by the human body or gravity, to perform its functions.
(4) Invasive devices
Medical devices that invade the human body in whole or in part through the body surface through surgery and come into contact with internal tissues, blood circulation systems, central nervous systems and other parts, including equipment used in interventional surgeries, disposable sterile surgical instruments and devices that remain in the human body temporarily or for a short period of time.
General tips for medical device classification table
1:SUM function (mathematics)
In daily work and study, SUM is an extremely widely used function and can be learned as an entry-level function. Therefore, overall, the SUM function is not difficult but has a wide range of applications. But don’t underestimate SUM just because it is simple. It also has some little-known tricks! 1. Cumulative sum as shown below, which is the sales performance of a certain company every day and requires the calculation of the daily cumulative amount.
For example, enter the formula in cell D2: =SUM(C$2:C2), press the Enter key to complete and fill downwards.
Note: At this time, C$2 must lock the row mark, so that a reference area from the second row to the downward row will be generated during the pull-down process.
2:Sum with qualified cells
The sum of merged cells has always been a troublesome problem for novices.
Select the cell range D2:D13, and then enter the formula in the formula editing bar: =SUM(C2:C13)-SUM(D3:D14), and then press Finish. Note: Be sure to pay attention to the misalignment of the range of the second SUM function, otherwise an error will be reported.
3: Sum of cells with subtotals
How to sum cells with subtotals? In cell C9, enter the formula: =SUM(C2:C8)/2 and press Enter to complete.
The process of subtotaling and summing are used here to repeatedly calculate the above data, so dividing by 2 can get a non-repeating result, which is exactly the desired result.
Recommended by the editor of Huajun Software Park Medical device classification tableIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Statistical table of enterprises and institutions directly under the Ministry,Fiscal Bill Verification Registration FormDownload to get the source file, which you can edit, modify and replace. To download the medical device classification table, go to Huajun Software Park.
Useful
Useful
Useful