User Guide for Vaccine Store Volume Calculator (VSVC). This guide has been updated to spreadsheet version ft1.3. Users should also check the notes in blue or red in the spreadsheet for further details of the latest revisions.

Related files:

• Vaccine Store Volume Calculator (VSVC) Program files

Screenshots:

The Vaccine Volume Calculator (VVC) calculator has been designed for the following tasks:
•To calculate annual vaccine need, both for ordering purposes and for storage capacity modelling.
•To estimate the storage capacity available in a vaccine store for vaccines and other immunization-related commodities.
•To model the effect on current and future storage requirements of adding or removing storage capacity.
•To model the flow of vaccines and commodities through the store. The tool highlights breaches of safety stock levels and stock-outs and shows whether the capacity of the store is sufficient to cope with stock peaks.
•To model the effect on storage capacity of alternative delivery and distribution strategies.
•To model the effect on storage capacity of future programme growth. •To model the introduction of new vaccines and the phase-out of superseded
vaccines.
•To estimate icepack/cool water pack requirements for a range of alternative distribution strategies.
The calculator may also be used to carry out a retrospective analysis of vaccine storage capacity; for example during the course of an effective vaccine store management (EVSM) assessment.

The spreadsheet is distributed in Microsoft Excel version 2003 format. It can be saved to Excel 97, but some functionality may be lost. The spreadsheet will not operate in Excel version 4 format or earlier as these versions do not support multiple worksheets.

Conditions of use: WHO distributes this spreadsheet on an 'as is' basis; it does not warranty the accuracy of any analysis produced using the tool and will not entertain any claim for losses arising from its use. Users are free to copy and distribute the spreadsheet as they see fit.

Related files:

• Vaccine Store Volume Calculator (VSVC) user guide

Screenshots:

The Large Store Analysis Tool (LSAT) has been developed to assist with the preliminary sizing of larger vaccine freezer rooms, cold rooms and controlled ambient stores. The tool can also be used to size the associated dry stores used for storing bundled syringes and safety boxes.

This document introduces the beta testing version of the tool and describes some of the ways in which it can be used. An earlier version of the spreadsheet was reviewed by Bisham Consulting and the current release incorporates changes and improvements arising from this review.

Related files:

• The Large Store Analysis Tool (LSAT) progam files
  
  

Screenshots:

The Large Store Analysis Tool (LSAT) has been developed to assist with the preliminary sizing of larger vaccine freezer rooms, cold rooms and controlled ambient stores. The tool can also be used to size the associated dry stores used for storing bundled syringes and safety boxes.

LSAT is an Excel 2003 workbook. All worksheets are ‘protected’, but no password is used. Users should ‘enable macros’ when asked to do so. Because macros are central to the operation of the tool, users are advised not to make changes to the spreadsheet. Doing so is likely to lead to macro run-time errors.

Related files:

• The Large Store Analysis Tool (LSAT) User guide

Screenshots: