LOADING YOUR DATA
%
Back to current version Restore this version

Your trial expires on : please update your subscription.

Manage Collaborators
Go to your Home Page to manage invitations and permissions.
Color Palette
Chart Settings
Access permissions to
Collaborators will be listed here if they have access to this specific worksheet / slide.


Click this icon to invite/manage collaborators.
Collaborators will be listed here when you restrict their access to this specific worksheet / slide.


You can also restrict access to
Settings

Sensitivity:
Version History
There are no previous versions to list
Share Project
    Shared Link is OFF ON
    Allow users with link to save a copy
    Anyone with this link can view only the worksheets and dashboards you share.

    How can we help?

    Get to your goal
    Master major workflows on dashboards, sensitivites, scenarios, etc.
    Guided Tour
    Get a contextual, step-by-step tour, of the features and functionalities on the current page.
    Talk To Us
    Edit cells to create a new scenario (existing assumptions and scenarios will not be deleted) Save Scenario Cancel
    You are in AUDIT MODE. Changes in this panel will be visible in the spreadsheet when you switch AUDIT MODE off .
    Conditional Range
    Condition
    Apply
    This cell has a conditional format. Click on the CONDITIONAL Tab below to manage conditional formats.
    Background
    Font
    Border


    Date format
    Custom Format code
    Apply
    Format Values
    Decimal Places
    Units
    Add a prefix to value displayed
    Apply
    Add a sufix to value displayed
    Apply
    Vertical Bar
    Vertical Stacked Bars
    Horizontal Bars
    Horizontal Stacked Bars
    Line
    Stacked Line
    Area
    Stacked Area
    Spline
    Stacked Spline
    Area Spline
    Stacked Area Spline
    Step
    Stacked Step
    Area Step
    Stacked Area Step
    Scatter
    Donut
    Pie
    Gauge
    Vertical Waterfall
    Horizontal Waterfall
    Paste
    Cells
    Cells without formats
    Values and formats
    Only values
    Only formats
    Set as natural names row
    Set as natural names column
    Above
    Below
    Left
    Right
    Shift right
    Shift down
    Delete row
    Delete column
    Shift left
    Shift up
    Hide row
    Unhide row
    Hide columns
    Unhide columns
    No rows
    1 row
    2 rows
    Up to current row
    No columns
    1 column
    2 columns
    Up to current column
    Indent left
    Indent right
    Collapse
    Expand
    Bar
    Line
    Area
    Spline
    Area-Spline
    Step
    Area-Step
    None
    Linear
    Exponential
    Logarithmic
    Polynomial
    Order:
    Power
    Duplicate
    Rename
    Delete
    X
    Cases of
    Manage Reset
    Name Value Author
    Scenarios
    Manage Reset
    Name Author
    Precedents & dependents of
    See 'Dependencies TAB' for a larger view and to change drivers' percentage change
    Error root cause analysis of
    If you are not already in AUDIT Mode, we are activating it for you and showing which is the first precedent cell causing error in this one.
    Cases of
    Report Scenarios
    Add Case
    Scenario recording
    Cells edited in recording mode automatically create new cases in the cell and link them to the scenario.

    After recording, you can rename the scenario and its cases.

    Scenario management
    Compare Waterfall Report
    Add Scenario
    Information of
    Report
    • All
    • Comments
    • Files
    Drag your file here or Upload
    Errors and Anomalies of
    Report


    Goal Seek of
    What value would you like for cell ?


    Select the input cell


    Named Ranges
    Add Named Range
    External Sources
    Add Source
    Charts
    Financial Statements
    1. Select periods, items, and settings on the Settings Panel.
    2. The interest rate is applied to the avarage of current and previous period's outstanding debt.
    3. Visyond can calculate the funding needs automatically or you can set equity and debt manually.
    4. Hover on the items in the Settings Panel or take the page tour (click on Help / Guided Tour) to learn more.
    Ratios and KPIs
    Income Statement
    Balance Sheet
    Cash Flow Statement
    Refresh project with Excel file
    Find and replace
    Cells
    Replace in all worksheets
    Cell
    Value
    Scenario names
    Replace all scenarios
    Case names
    Replace all cases
    Cell
    Case name
    Assign names to rows (e.g. "Revenues") and columns (e.g. "2020") and you will be able to write formulas like "RowName[ColumnName]" (e.g. "Revenues[2020]")Learn more
    Audit mode highlights cells by type (e.g. number, formulae, dates, etc.) Learn more
    Audit
    Names
    Auto Calc
    Cycles
    Enable Iterations
    Maximum Iterations
    Apply
    Detected cycles. Click on the cells to find them in the spreadsheet.
    Import Notes
    These cells are different from the imported file. This can be due to unsupported function.
    Traverse
    Error Root
    Precedents
    Dependents
      Settings
      Tornado Analysis
      Selected analysis by
      Settings
      Select Output Cell
      Select Input Cell
      Select Input Cell 2 (optional)
      Sensitivity Analysis
      Selected analysis by
      Settings
      Add Output Range/Cell
      Scenario Analysis
      Selected analysis by
      Settings
      Scenario Waterfall
      Selected analysis by
      Distribution Fitting
      Settings
      Select Output Cell
      Add Input Range/Cell
      Simulation Analysis
      Selected analysis by
      Min
      Max
      Mean
      Median
      Stdv
      Probability Density Function
      Probability in range =
      Range from to
      Cumulative Distribution Function
      Probability in range =
      Range from to
      Cell
      Add Dashboard
      Add and Nest
      Duplicate Dashboard
      Duplicate and Nest
      Spreadsheet Charts
      Tornado
      Sensitivity
      Scenarios
      Scenarios Waterfall
      Simulation
      Bring to front
      Bring forward
      Send backward
      Send to back
      Left
      Center
      Right
      Top
      Middle
      Bottom
      Largest width
      Smallest width
      Largest height
      Smallest height
      Horizontal
      Vertical
      Loading...
      Show Thumbnails
      Present
      Cells with multiple cases
      Group by:
      Sort by:
      Scenarios
      Sort by:
      Cells with comments or attachments
      Group by:
      Error roots, external sources, and unused cells
      ERROR ROOTS
      INACTIVE CASES ERRORS
      ANOMALIES
      Sensitivity:
      EXTERNAL SOURCES
      UNUSED CELLS
      Get to your Goal
      in Minutes