Skip to main content

Reference

The finPack Reference section provides concise technical and troubleshooting information for users who already understand the main finPack features.

Use this section when you need to look up a function, understand an Excel error, troubleshoot a problem, or find a quick answer to a common question.

Function Reference​

The Function Reference provides a compact summary of all finPack worksheet functions.

Current functions include:

FINPACK.CPI
FINPACK.CPIINCREASE
FINPACK.CPIAVGCHANGE

Use the Function Reference when you need a quick reminder of:

  • Function syntax.
  • Required arguments.
  • Return values.
  • The purpose of each function.

For detailed explanations and examples, see the individual pages under Excel Functions.

Errors​

The Errors page explains errors that may appear when finPack cannot retrieve or calculate a requested result.

Topics include:

  • Invalid function arguments.
  • Unavailable CPI observations.
  • Unsupported countries or CPI series.
  • Internet or BPOpti service availability.
  • Excel custom-function errors such as #N/A.

Troubleshooting​

The Troubleshooting page provides guidance for common problems involving:

  • The BPOpti Ribbon.
  • The finPack task pane.
  • CPI data retrieval.
  • Worksheet functions.
  • Inserting CPI data into Excel.
  • Internet and service connectivity.

Use this page when finPack is installed but something is not working as expected.

Frequently Asked Questions​

The Frequently Asked Questions page provides short answers to common questions about finPack.

Topics include:

  • CPI Increase versus CPI Average Change.
  • Estimated CPI observations.
  • Percentage formatting.
  • CPI data sources.
  • Internet requirements.
  • Using task-pane features versus worksheet functions.

Other documentation sections​

If you are looking for instructions rather than reference information:

  • Getting Started — Requirements, installation, and first-use guidance.
  • Using finPack — Detailed task-pane and Ribbon instructions.
  • Excel Functions — Full documentation for each FINPACK worksheet function.
  • CPI Data — Countries, series, estimated observations, and data sources.
  • Examples — Practical finPack workflows in Excel.