Icon

FinancialModelling_​Part1and2

App Design

  1. Load Input data from Excel for:

    1. Plan values

    2. Actual values

  2. Focus: Revenue / Income for Minimal Viable Product

    1. Plan / forecast over time

    2. Actual over time

  3. Key features:

    1. Upload new excel file to create new plan version

    2. Plan version comparison

    3. Plan version vs. Actual comparison

    4. Accommodate different Products

    5. Neat data viz for quick insights in Data App

2. Load data and establish revenue/income planning

1. Upload Excel and Define Version

3. Save Version

4. Visualize Plan Differences

Plan Data
Excel Reader
create date rangewith correct frequency
Create Date&Time Range
Iterate over everyProduct and create variables
Table Row to Variable Loop Start
frequency to period Map
Excel Reader
Lookup Period Value
Value Lookup
add in valueand product
Column Expressions
collect results
Loop End
Merge Variables
sort by dateascending
Sorter
Table Writer
Select File
File Upload Widget
String Widget
Load existingdata
Table Reader
Add new data
Concatenate
Data Viz

Nodes

Extensions

Links