|
A Natural Language
Code Blue uses a natural language for expressing formulas and equations. Equations are defined in familiar terms rather than cell addresses. For example:
Profit = Sales - Costs
Expressing relationships in this simple and direct way is the cornerstone of Code Blue.
Models are quickly developed, readily understood and easily modified.
Example
The text below shows the definition of a very simple Code Blue model. "Profit Plan"
*Columns
Qtr1; Qtr2; Qtr3; Qtr4
Total = SUM(Qtr1,Qtr4)
*Rows
Volume = 100;120;150;250
Unit Price = 20#3;16
Revenue = Volume * Unit Price
Unit Cost = 15;15;12;10
Cost of Sales = Volume * Unit Cost
Gross Profit = Revenue - Cost of Sales
Overhead = 8000
Net Profit = Gross Profit - Overhead
- The model is created as a simple text file in the Code Blue editor (or any software which creates text files).
- Equations can be specified in any order because it is not a programming language..
- For simplicity, data is hard-coded into the model in this example. In a system data is held separately to the model and can be accessed from a variety of sources.
- The # indicates repetition, e.g. Unit price is 20 for Qtr1, Qtr2 and Qtr3 and 16 for the balance.
- Overhead is 8000 for all columns.
The report produced is shown below.
Language Features
- This deceptively simple language can be used to solve a vast range of complex problems and develop extensive multi-model systems
- No programming skills needed. You simply express the relationships
- Data normally held in worksheets which are independent of the model
- Facilities for easily exchanging data with other systems
- No special macro language to learn
- Built-in simultaneous equation solving
- No reserved words or case sensitivity
- Comprehensive range of functions
- List handling supporting the dynamic creation of model structures
- Extensive parameterisation capabilities for developing generic models
- Menu building facilities
- Automatic generation of structures for drill down in reports
- Built in analysis facilities including Monte Carlo Simulation and Sensitivity analysis
- Scenario management and comparison
- Multi-dimensional and hierarchical modelling supported
- Pivot tables
- Built in Adobe PDF file generation.
- Linear programming
|
