Tips for using epidemic health registrationHow to prepare an epidemic health registration?
1. Comprehensive content
Collect residents' health information at any time and anywhere, not only record medical history, course of disease, diagnosis and treatment, but also complete information integration centered on residents' health.
2. Widely used
The application of electronic health records and computer information systems will greatly shorten the time of doctor consultation and greatly improve the quality.
3. Convenient retrieval
The unique data format and centralized storage of resident health records are conducive to fast input, quick retrieval, query, and call processing of various diagnosis and treatment information. It provides a large amount of integrated data for clinical, teaching, and scientific research, which is conducive to the sharing and exchange of information resources. It is also a statistical Comprehensive and reliable data for analysis and health management greatly improves the efficiency of file utilization.
4. Easy storage
The storage of paper medical records must have enough space and a specified storage period. At the same time, problems such as wear and aging of the paper, as well as moisture-proof, fire-proof, and moth-proofing must be solved, which consumes a lot of manpower and material resources.
5. Information provision
Resident health records can directly, quickly and accurately provide information for sudden, contagious and frequently occurring diseases.
General Tips for Epidemic Health Registration
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 area range of the second SUM function. Misplaced, 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 Epidemic health registrationIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Elevator disinfection record sheet during the epidemic,Community epidemic investigation daily reportDownload to get the source file, which you can edit, modify and replace. To download the epidemic health registration, go to the Huajun Software Park.
it works
it works
it works