Skip to content
Excel VBA code for calculating Bjontegaard Delta SNR and Rate, using arbitrary number of data points. Complies with VCEG-M33 when using 4 data points.
Branch: master
Clone or download

Latest commit

Fetching latest commit…
Cannot retrieve the latest commit at this time.

Files

Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
LICENSE Changed the licensing to MIT (more permissive) Aug 16, 2016
README.md
bjontegaard_etro.xla Update high/low range to be be robust to any order of data. Apr 10, 2019
bjontegaard_etro_standalone_example.xlsm Update high/low range to be be robust to any order of data. Apr 10, 2019

README.md

ETRO's Bjontegaard Metric implementation for Excel.

Description:

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):

  1. 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.

  2. 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.

Author:

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

References:

[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 Tim Bruylants, ETRO, Vrije Universiteit Brussel.

You can’t perform that action at this time.