Stocheo

Reproducible random numbers for Google Sheets™

A Google Sheets™ add-on that provides seeded random number generation. Same seed, same results — every time. Build models you can reproduce, share, and verify.

Why Stocheo?

Reproducible

Every output is determined by its inputs. Use the same seed to get the same results, every time. Share spreadsheets with confidence that others will see identical values.

Independent

Each cell depends only on the seed and its indices. Insert or delete rows without affecting other values. No hidden serial dependencies.

Native

Works with the Google Sheets™ functions you already know. Wrap RANDSEED in NORMINV, LOGNORM.INV, or BETA.INV to generate any distribution.

Simple

One function to learn. Drop it in wherever you use RAND() today, add a seed reference, and your model becomes deterministic.

Usage

// Single reproducible random value =RANDSEED(42) // Unique per row, reproducible per seed =RANDSEED($A$1, ROW()) // Unique per cell in a 2D range =RANDSEED($A$1, ROW(), COLUMN()) // Normal distribution via native Sheets function =NORMINV(RANDSEED($A$1, ROW()), mean, stdev)

How It Works

Stocheo provides custom spreadsheet functions that generate random numbers from a seed value. Unlike the built-in RAND() function — which produces different values on every recalculation — Stocheo functions are deterministic:

RANDSEED(seed, ...indices) — returns a single random number in [0, 1) determined by the seed and optional position indices.
RANDSEEDARRAY(seed, rows, cols) — returns an array of random numbers, useful for filling ranges with a single formula.

Change the seed to generate a different set of random values. Keep the seed the same to reproduce your results exactly. This makes it possible to compare scenarios, verify models, and share reproducible analyses.

Permissions & Privacy

Stocheo operates entirely within your current spreadsheet. It reads the seed and index values you pass to its custom functions and returns computed random numbers. It does not access other files in your Google Drive, send data to external servers, or store any of your information.

The add-on uses only the current spreadsheet scope so that its custom functions can read input values and return results within your sheet. No other permissions are requested. See our Privacy Policy for full details.