Add to the model

• Add inputs to the model
• Instant mode
• Create or change a calculation
• Add a new section
• Add headers to each sheet
• Add a flag, index or discount factor
• Add a component/ module to my model
• Adding new variables automatically

Arrays

• Why is my report repeated for everything in an array?
• "Triangle" roll out blocks
• Add an input which is a table
• Create a weighted average
• Arrays and reports - how to show one report per array item, or all items on the same report

Audit and Documentation

• Produce model documentation
• Adding an issues log

Balances

• Autocorrect the BEG() function
• Balance formulas
• Adding balances and non-balances
• Corkscrew which is a sum of balances
• Balances and corkscrews

Best practice

• Embedded Constants
• Unused items
• "Triangle" roll out blocks
• When does a model have a circular reference?
• Checking that calculations are correctly read from Excel into Openbox

Components

• Add a component/ module to my model
• Add a flag, index or discount factor
• Make a new component from an existing Excel model
• Sell my own components through the Openbox site

FAQs

• What are the keyboard shortcuts in Openbox?
• What checks does Openbox do as part of validation?
• Circular references
• Apply the FAST standard
• What information does Openbox send to the Internet?
• Turn on autosave?
• What do the up and right pointing arrows mean?
• When working in the preview, how do I select the same item in the main Openbox window?
• Versions and change log
• Consolidate something on one time axis to another?
• How do I make sure I have the latest version of Openbox?
• "Not enough quota..." message
• Why is my report repeated for everything in an array?
• Can I bring a whole model from Excel to Openbox?
Show All Articles ( 6 ) Collapse Articles

Formatting and layout

• Changing how inputs and calculations are laid out
• How to change the width of columns
• Set Number Formats
• Apply the FAST standard
• Add an input which is a table
• Format section headings
• The Formatting Template - changing how your models look in Excel
• Add custom report styles

Functions

• ALLVALUES function
• BEG function
• LOOKUP function
• PREVIOUSVALUE and PREVIOUSVALUES functions
• SELECT function

Getting Started

• Quick Start - building your first model
• Instant mode

How do I...

• Add a new sheet
• Create an Excel model from your Openbox model
• Deal with units marked in red
• Move things around in the model
• Repeat calculations using arrays
• Set the model timeline(s)
• How do I enter my license key?
• Sell my own components through the Openbox site
• Add an input which is a table
• Adding and removing comments
• Create a weighted average
Show All Articles ( 3 ) Collapse Articles

Import from Excel

• Make a new component from an existing Excel model
• Can I bring a whole model from Excel to Openbox?
• Checking that calculations are correctly read from Excel into Openbox

Number formats

• Set Number Formats

Reports

• Create and customise a report
• Add custom report styles
• Merging and duplicating reports
• Arrays and reports - how to show one report per array item, or all items on the same report

Scenarios

• Scenarios for timeseries inputs
• Displaying scenarios on charts

Tables

• Picking one item from a table using INTERSECT

Time

• Set the model timeline(s)
• How to get multiple timelines on one sheet
• Consolidate something on one time axis to another?

Troubleshooting

• Why don't shapes show up in the preview?
• Why doesn't the Openbox menu appear in Excel?
• Checking you have 64-bit Excel
• "Not enough quota..." message
• Why do I get a message saying the name of my report or sheet is not valid?
• Why has my Openbox menu disappeared from Excel?

Units

• Change the units for calculations
• Deal with units marked in red
• Set missing units

Visualizing

• Show a calculation's precedents and dependents
• Quick dashboard in focus view
• When working in the preview, how do I select the same item in the main Openbox window?
• Show everything in the model?
• Why don't shapes show up in the preview?
• Linking from a dashboard or other sheet to the Openbox part of a spreadsheet
• Displaying scenarios on charts

Warning messages

• 'Items on unallocated' warning
• 'Named range not valid' warning message
• 'Constants on reports' warning
• Set missing units
• Items with the same name
• Warning that some calculations vary by one array, but others don't
• Adding new variables automatically
• Show everything in the model?
• Embedded Constants
• Autocorrect the BEG() function
• Balance formulas
• Adding balances and non-balances
• Unused items
• Corkscrew which is a sum of balances
• Function that is different in Excel
• Warning message: "The model did not converge to a solution..."
• When does a model have a circular reference?
• Why do I get a message saying the name of my report or sheet is not valid?
Show All Articles ( 10 ) Collapse Articles