There are several optimization algorithms available in the https://github.com/NREL/OpenStudio-analysis-spreadsheet/. Currently the list is:

NSGA2 (Non-dominated Sorting Genetic Algorithm)

• Multi-objective
• Parallel F evaluations Mixed
• Continuous or Discrete variables

SPEA2 (Strength Pareto Evolutionary Algorithm)

• Multi-objective
• Parallel F evaluations
• Continuous variables only

Rgenoud (GENetic Optimized Using Derivatives)

• Single-objective
• Parallel F evaluations for genetic search
• Parallel gradient calculation for continuous variables

Optim (quasi-Newton method with bounds)

• Single-objective
• Parallel gradient calculation
• Continuous variables only

There are also sampling, design of experiment, batch running and a few other algorithms available. A calibration example lives here: https://github.com/NREL/OpenStudio-analysis-spreadsheet/tree/develop/Calibration_example

A user guide is currently being drafted and lives here: https://github.com/NREL/OpenStudio-analysis-spreadsheet/tree/develop/documentation.