Module: Editor

Version: 4.2.1 +

User: Developer

Level: Beginner

Introduction

In this tutorial we'll show you how to work with tables in Futurama. We will create some tables, and show some table-specific formulas and features.

Prerequisites

- The Futurama Editor must be installed.

- Completing the tutorial Creating formulas with Futurama first, is recommended.

## Description

This tutorial is independent of the application-type. Therefore we will only work with the calculations-file. In this way, we are creating a calculation-file that can be used for different types of applications, and we don't have to build calculations more than once.
This means, this tutorial is used in all three series.

In this tutorial we want to add a service fee to the interest rate.
Safe2Save has a table with two different service fees, based on the starting amount:

Starting amountService Fee
0 - 20.000 0.2%
20.000 and more 0.1%

For deriving the appropriate service fee, we will first add a data-table to the calculation-file. Based on the cash balance, the service fee is looked up in the table. The service fee is then included in the future savings formula. This results in the following formula:

Future Savings:= Cash Balance*(1+Interest-ServiceFee)^Years

At the end of the turorial, we will test our new future savings formula, to see if it works as expected. By doing so, we are also showing some more features of tables, f.i. including tables as input for arguments.

## Video

ContentsTime
1) Intro 0 - 0.45
2) How to create a Table 0.45 - 3.30
3) Working with Table-formulas 3.30 - 7.15
4) Tables as arguments 7.15 - 12.52
(rightclick, save as...)

## Related Topics

- DataTable: Futurama Manual Page about one of the Table-objects in Futurama. Explains some of the properties of (working with) tables in Futurama.

## Exercises

1. Average (Easy)
2. Boundary values (Difficult)
3. Standard Deviation (Medium)

Updated: 2013-01-03