Publication number: ELQ-74218-1
View all versions & Certificate
Covid-19 Database Template with Automated Analytical Dashboard
Covid-19 Database Template with Automated Analytical dashboard
An easy to use automated Covid-19 Excel Database and Analytical Dashboard with interactive charts for medical personnel and institutions.
This spreadsheet keeps record of Covid-19 patients' data and analyses this data automatically, creating a visualization of the data for medical practitioners to visualize patients' data summary.
Enter each test/patient's data to the database tab. The analysis and charts are done and updated automatically on the dashboard.
This spreadsheet and dashboard keep track and summarize the following:
1: Number of Covid-19 tests carried out at any point in time.
2: Number and % of positive results.
3:Frequency of each Covid-19 symptom in positive patients.
4: Death and Recovery rates at any point in time.
5: Efficacy of main Covid-19 drugs (Hydroxylchloroquine, Dexamethasone, Remdesivir, Others, Combination therapy) on patients. Death and Recovery rates on each drug.
6: Frequency of pre-existing conditions like diabetes, HBP, Compromised immune system etc. on positive patients.
7: Average time taken for a test result to be ready ( for Traditional and Rapid testing respectively).
8: Age, Race and Sex distribution of Covid-19 positive patients.
9: Covid-19 death rates according to race.
10: Recoveries and Deaths according to exposure time.
11: Frequency of use for each type of treatment(drugs)
This Best Practice includes
1 Excel file
Acquire business license for $79.00
Add to cart
Add to bookmarks
Covid-19 test record keeping and analysis
- Be the first to review this Downloadable Best Practice
Write a review
People using this Best Practice also downloaded
Data analysis & dynamic reporting for cloud accounting Xero and QBO using ExcelUSING EXCEL TO AUTOMATE PROCESS IN XERO AND QBO? YES YOU CAN Using DataDear you are able to both pull and push data.financial modelingfinancial modellingexcelxeroautomation429add_shopping_cartfreeby Lance Rubin
Simulate the number of Corona virus infectionsSimulate Corona virus infection ratesexcelsimulationcovid-19corona virusinfection rates274add_shopping_cartfreeby Gary Knott
How to communicate successfully with your teams in the “new world of work”?How to adapt our internal communications to the "new world of work" and optimise how our teams collaborate.covid-19remote workcommunication is keynew world of workflexible work46add_shopping_cartfreeby Wimi
Free Business Sustainability toolThis Business Sustainability Tool is built for all kinds of businesses to measure its business strength amid COVID19.cash flow managementcash managementcovid-19crisis managementcoronavirus214add_shopping_cartfreeby Sadaf Abbas
How to change your business during the recession caused by coronavirusA few tips how to adjust your business during and after coronavirus pandemicperformance improvementcovid-19corona virusrecessionpandemic549add_shopping_cartfreeby Asen Gyczew
Financial model Free Excel Template to fight COVID-19Free Financial Model Excel Template to run sensitivity analysis against COVID-19sensitivity analysisfinancial modelexcel templatecovid-19excel financial templates4,023add_shopping_cartfreeby Henry Sheykin
Productivity VBA tool - Automation of year on year movement computation for multiple periodsA VBA Macro for automatic year on year movements and automatic formatting.financial analysisreportingvbaproductivityautomation215add_shopping_cartfreeby HEURTEBIZE
How to sustain a business during COVID-19 (7 Pillars)A 7 step pillar methodology with advice on how to sustain and maintain your business during the COVID-19 Crisis.covid-19business managementcrisis managementfinancial best practices728add_shopping_cartfreeby Maksims Sičs
Controlling Outlook from Excel (short version)Explains how to programmatically link Excel to Outlookexcelvbaautomationoutlookvisual basic907add_shopping_cartfreeby Andrei Okhlopkov
Any questions on Covid-19 Database Template With Automated Analytical Dashboard?
The user community and author are here to help. Go ahead!