F.A.J.R.

Forward Assessment of Joint-node Relationships

Load your two workbooks

Everything runs locally in your browser — no file ever leaves this machine. Accepted formats: .xlsx, .xls, .csv.

Or start from one of these, then add your own files at any time — datasets are kept side by side.

File 1

Values

Code · Value · Description · Type

The master record. Code is the primary key.

Drop a file here, or click to browse

File 2

Dependencies

Code · Operation · BCode

One row per term. BCode is the foreign key into Values.

Drop a file here, or click to browse

Both files are needed before the model can be built.

How the two files are read

Column headers are matched case-insensitively and common synonyms are accepted (ID for Code, Depends On for BCode, and so on). If a workbook has several sheets, the first sheet carrying the required headers is used.

Each row of the dependency file adds one term to a code's formula. Rows for the same Code combine in file order, so 

Code  Operation  BCode
7     +          67
7     -          6
7     +          31

means 7 = +67 − 6 + 31 (an optional Weight / Factor column, or a number written inside the operation such as *0.5, scales the term). + − × ÷ ^ % are supported, with normal arithmetic precedence.