We created methods for calibration with OpenStudio models and had some examples in this repo:

That workflow is now deprecated in favor of the OpenStudio Analysis Framework which has more capability and deployment options than the older analysis spreadsheet. It is also compatible with OpenStudio-HPXML workflows