Open access · Peer reviewed · Scopus journal
VACCRaksha Calc: A computer program for the calculation of vaccine potency
- 1*
- 1R = number of mice died due to specific symptoms N = number of animals used at each individual dilution (after discounting accidental or nonspecific deaths) The spreadsheet program used is Microsoft Excel version 2013.[3] Coding and logical data used in this program are as follows; For D11 cell (mice alive) =D9‑D10 (also applied for E, F and G11 cells) For D13 cell (sum of r/n) it’s been, =IF (E12 < 1, D12 + E12 + F12 + G12) For E13 cell, =IF (E12 = 1, E12 + F12 + G12) For D14 cell (multiplication with log of dilution factor) =0.7*D13 For D15 cell (deletion of 0.35) =IF (E12 < 1, D14‑0.35) For E15 cell (addition of 0.35) =IF (E12 = 1, E14 + 0.35) For Antilog calculation i.e. E15 cell, =IF (E12 < 1, 10^D15) For D17 cell (relative potency) =IF (E12 < 1, D16/18) One representative study is presented to help and understand the usefulness of the program. The findings of the experiment along with the calculation are presented as a screenshot of the program [Figure 2].
Published in Journal of Pharmacology and Pharmacotherapeutics
Correspondence: D = log10 of the dilution factor
R = number of mice died due to specific symptoms N = number of animals used at each individual dilution (after discounting accidental or nonspecific deaths) The spreadsheet program used is Microsoft Excel version 2013.[3] Coding and logical data used in this program are as follows; For D11 cell (mice alive) =D9‑D10 (also applied for E, F and G11 cells) For D13 cell (sum of r/n) it’s been, =IF (E12 < 1, D12 + E12 + F12 + G12) For E13 cell, =IF (E12 = 1, E12 + F12 + G12) For D14 cell (multiplication with log of dilution factor) =0.7*D13 For D15 cell (deletion of 0.35) =IF (E12 < 1, D14‑0.35) For E15 cell (addition of 0.35) =IF (E12 = 1, E14 + 0.35) For Antilog calculation i.e. E15 cell, =IF (E12 < 1, 10^D15) For D17 cell (relative potency) =IF (E12 < 1, D16/18) One representative study is presented to help and understand the usefulness of the program. The findings of the experiment along with the calculation are presented as a screenshot of the program [Figure 2].
Email: maheshreddy041@gmail.com
Copyright: © 2015 The Author(s). This is an open access article.
Published: Jan 1, 2015, Received: Dec 22, 2014, Accepted: Mar 19, 2015
Abstract
Assessment of vaccine potency is often carried out by veterinarians in animal house in biological units. The more reliable method used for this assessment is Spearman and Karber. The calculations involved in the assessment are complex, confusing, time consuming and not easily reproducible. Spreadsheet is a computer application in which data are arranged in rows and columns of a grid and can be manipulated and used in calculations. In today’s era of smart phones, tablet PCs and netbooks, where a spreadsheet program in the form of Microsoft Excel is readily accessible by most veterinarians, it should be possible to adapt the various laborious steps involved in the said method to a spreadsheet program by writing simple logical codes in the spreadsheets to do the calculations in a simple, clear, faster, reproducible, accurate and user‑friendly manner. This article describes a spreadsheet program (VACCRaksha Calc) to calculate the vaccine potency based on the steps involved in Spearman and Karber
Keywords
Subject
Recommended articles
- Randomized controlled comparison of agomelatine and escitalopram: Concerns about study design and methods
Sutanaya Pal, Ekta Franscina Pinto, Nitin B. Raut · Journal of Pharmacology and Pharmacotherapeutics
- Effect of losartan and atenolol on insulin sensitivity in nondiabetic hypertensive patients
K. B. Rakesh, Sheetal D. Ullal, B. Sunil Pai · Journal of Pharmacology and Pharmacotherapeutics
- Prescription errors in cancer chemotherapy: Omissions supersede potentially harmful errors
Subodh Kumar · Journal of Pharmacology and Pharmacotherapeutics
- Are we moving towards a new definition of essential medicines?
Marcus M. Reidenberg · Journal of Pharmacology and Pharmacotherapeutics
- Drug utilization pattern and pharmacoeconomic analysis in geriatric medical in-patients of a tertiary care hospital of India
Viral N. Shah · Journal of Pharmacology and Pharmacotherapeutics
- European Heart and Rhythm Association guidelines on new oral anticoagulants: A bold step forward
Vishal Sehgal, Sukhminder Jit Singh Bajwa · Journal of Pharmacology and Pharmacotherapeutics
Readers Also Viewed
Pharmacogenomics Meets Generative AI: Transforming Clinical Trial Design with Large Language Models
Annisa Fatharani, Ali Alsayegh
Jan 1, 2026
Clinical Outcomes and Management of Post-varicocelectomy on Male Fertility: A Comprehensive Review
Mohammad Akbar Hossain
Jan 1, 2026
Knowledge, Attitude, and Practice on Digital Eye Strain Among Healthcare Students at a Private University in Northern Peninsular Malaysia
Lim Chin Hung, Subramani Parasuraman, Sam Aaseer Thamby
Jan 1, 2026