KOLEKT INVESTMENT OPTIMIZER

Scenario data

The data-request workbook, one tab per table. Each tab is also a CSV file: download it, change it in a spreadsheet and import it again; the file replaces the whole tab. Every change makes a new data version, and every run records the version it was solved on.

Loading the data…

Row

Numbers as the CSV has them: a point for decimals, no thousands separators (1500000 or 1.5e6). A blank number is unknown, which is not the same as 0.

Remove this row?

The removal is a new data version. Runs already made keep their results.

Import CSV files

One file per tab, as Google Sheets exports a sheet ("File → Download → Comma-separated values") or as this page downloads it. The tab is read from the file name (04_Process_Economics) or else from its header row. A file replaces its whole tab, rows in the file's order. Nothing changes until you import after the preview.