Excel VBA code for calculating Bjontegaard Delta SNR and Rate, using arbitrary number of data points. The calculated results comply with VCEG-M33 when using 4 data points.
Provides two functions (all arguments take cell ranges):
BDSNR(BR1, PSNR1, BR2, PSNR2)
BDBR(BR1, PSNR1, BR2, PSNR2)
These functions are provided in two versions (both containing the exact same VBA code):
-
bjontegaard_etro_standalone_example.xlsm is a stand-alone Excel sheet with the VBA routines internally in the file. It’s a macro-enabled Excel worksheet.
-
bjontegaard_etro.xla is an Excel Add-In. By adding this on your system (via Excel Add-In preferences), the two functions become globally available in your Excel install.
Note: A C++ implementation is also available as the Bjontegaard CPP project.
Tim Bruylants, ETRO, Vrije Universiteit Brussel
This code was originally developed as part of the following publication:
Tim Bruylants, Adrian Munteanu, Peter Schelkens, Wavelet based volumetric medical image compression, Signal Processing: Image Communication, Volume 31, February 2015, Pages 112-133, ISSN 0923-5965, http://dx.doi.org/10.1016/j.image.2014.12.007.
Open access URL: http://www.sciencedirect.com/science/article/pii/S0923596514001854
[1] G. Bjontegaard, Calculation of average PSNR differences between RD-curves (VCEG-M33)
[2] S. Pateux, J. Jung, An excel add-in for computing Bjontegaard metric and its evolution
Copyright (C) 2013-2022 Tim Bruylants, ETRO, Vrije Universiteit Brussel.