Dr. Odongo Oduor Joseph - Professional Profile

The Preparedness Paradox

There is a paradox at the heart of global health preparedness that rarely receives the attention it deserves. The countries and communities most likely to experience epidemic threats — those with high population density, limited sanitation infrastructure, close human-animal interfaces, and constrained health system capacity — are precisely the ones least equipped with the analytical tools needed to detect, model, and respond to those threats.

This is not simply a matter of funding, though funding is undeniably important. It is a matter of tool design. The epidemiological modelling software that has been developed over the past two decades — powerful, sophisticated, and increasingly user-friendly — was designed primarily for use in well-resourced settings: academic institutions with high-performance computing clusters, national public health agencies with dedicated data science teams, and international organisations with stable internet connectivity and technical staff.

For the district health officer in rural Kenya, the field epidemiologist in the Democratic Republic of Congo, or the public health coordinator in a remote island community in the Pacific, these tools are effectively inaccessible. Not because they lack the intelligence or motivation to use them, but because the tools were not designed with their context in mind.

The Epidemic Calculator Model Excel VBA Dashboard, available at https://hatchery.gumroad.com/l/avtmsi, is a direct response to this preparedness paradox. It asks a simple but powerful question: what if we built epidemiological modelling tools for the settings where they are most urgently needed, rather than for the settings where they are most conveniently deployed?

The Architecture of Accessibility

The design philosophy of the Epidemic Calculator Model is grounded in three principles that distinguish it from conventional epidemiological software: familiarity, portability, and offline functionality.

Familiarity means building on a platform that health workers already know and use. Microsoft Excel is the most widely deployed data management tool in the world, present in health ministries, district offices, and NGO field stations across every continent. By embedding the epidemic calculator within Excel using VBA, the tool eliminates the need for any new software installation, any new technical skill acquisition, or any institutional IT support. If you can open an Excel file, you can use this tool.

Portability means that the tool can be carried on a USB drive, shared via email, or transferred between computers without any installation process. There are no dependencies to manage, no version conflicts to resolve, and no licensing requirements to navigate. A single Excel file is the entire application.

Offline functionality is perhaps the most critical design choice of all. In many of the settings where this tool is most needed, internet connectivity is intermittent, expensive, or entirely absent. Cloud-based dashboards and web applications — however sophisticated — are simply not viable in these contexts. The Epidemic Calculator Model works entirely offline, making it deployable in the most remote and resource-constrained environments imaginable.

Decision Support in Practice: From Data to Action

The ultimate purpose of epidemiological modelling is not to produce elegant mathematical outputs — it is to support better public health decisions. The Epidemic Calculator Model is designed with this practical orientation at its core.

Consider a scenario in which a district health officer receives reports of an unusual cluster of febrile illness in three villages within their jurisdiction. They have limited laboratory capacity, no reliable internet connection, and must decide within hours whether to escalate the alert to the national level, mobilise a rapid response team, or implement community-level isolation measures.

With the Epidemic Calculator Model, this officer can immediately begin modelling the outbreak. They can enter the approximate population of the affected communities, estimate the infection rate based on the observed case counts and the known epidemiological characteristics of the suspected pathogen, and run a simulation to project the likely trajectory of the outbreak over the coming days and weeks.

The resulting epidemic curve provides an immediate, visual answer to the most critical question in outbreak response: is this getting better or getting worse, and how quickly? If the model projects rapid exponential growth, the case for immediate escalation and aggressive intervention is clear. If the model projects a self-limiting outbreak with a low peak, a more measured response may be appropriate.

This kind of rapid, evidence-informed decision-making is exactly what the International Health Regulations (IHR) framework requires of national health authorities — and it is precisely what is most difficult to achieve in the absence of accessible analytical tools.

Integration with Broader Biosecurity Frameworks

The Epidemic Calculator Model does not exist in isolation. It is most powerful when integrated into a broader biosecurity and public health preparedness framework that includes surveillance systems, laboratory networks, rapid response capacity, and community engagement mechanisms.

From a biosecurity perspective, the ability to rapidly model outbreak scenarios is particularly valuable for assessing the potential consequences of deliberate biological events — whether accidental laboratory releases or intentional bioterrorism. The same mathematical framework that describes the spread of a naturally occurring pathogen applies equally to the spread of an engineered or deliberately released agent. Having this modelling capacity available offline, in the hands of biosecurity professionals who may be responding to an incident in a remote or compromised environment, is a significant operational advantage.

The tool also has important applications in biosafety training and capacity building. By using the calculator to explore the consequences of different biosafety failures — for example, the accidental release of a pathogen with a high R₀ from a research facility — biosafety officers can develop a more quantitative understanding of the risks they are managing and the importance of the containment measures they are responsible for implementing.

A Call for Investment in Appropriate Epidemiological Tools

The development of the Epidemic Calculator Model Excel VBA Dashboard represents exactly the kind of innovation that the global health community should be actively supporting and scaling. It demonstrates that the barriers to accessible epidemiological modelling are not primarily technical — the mathematics of the SIR model is well-established and computationally undemanding — but rather a matter of design priorities and investment decisions.

The global health community has invested billions of dollars in the development of sophisticated epidemiological modelling platforms, genomic surveillance systems, and AI-powered outbreak detection tools. These investments are valuable and necessary. But they must be complemented by equal investment in the development and dissemination of accessible, appropriate tools for the frontline health workers who are the first to encounter emerging threats.

The Epidemic Calculator Model Excel VBA Dashboard is available for download at https://hatchery.gumroad.com/l/avtmsi for $30 — a price point that reflects the genuine value of the tool while remaining accessible to individual health workers and small organisations. It is a resource that every district health office, field epidemiology training programme, and biosecurity capacity-building initiative should have in its toolkit.

The preparedness paradox will not be resolved by technology alone. But tools like this — designed for the contexts where they are most needed, built on platforms that are already in use, and deployable without internet connectivity — are an essential part of the solution.

Reference