Using nfield in a workbook

Start with the question

Choose a function from the reference, then read its input domain and output shape. These pages describe the developing interface; the Excel and Sheets adapters are not yet available to install.

Exact values are text

Use quoted integer or rational strings when exactness matters. For example, write "1/3" rather than a rounded decimal and "9007199254740993" rather than entering that large integer as an ordinary number.

Follow a digit cycle

The proposed DIGITS function takes a numerator, denominator, base and step count. A bounded trace shows the requested prefix. A full eventual period requires its own cycle calculation.

=NF_DIGITS(1,7,10,12)

For Excel, use the proposed spelling NF.DIGITS. The familiar decimal cycle is 142857. The output will include the remainder transitions that produce those digits.

Compare finite tuning readings

=NF_DEFICIT(29,24,30)
=NF_DEFICIT_RATIO(29,24,36,30,1)

These are arithmetic alignment quantities. The prime must be at least three, the base must be one modulo that prime, and every prime factor of a supported depth must divide the base. Depth 24 is supported by base 30; depth 7 is not. Cents conversions present a positive ratio numerically; they add no claim about perception.

Leave room for tables

Reserve an empty rectangle for a function that returns rows or a matrix. Pass a whole range in one call where possible. Large scans will use an explicit job workflow rather than starting again on every cell edit.

Read the precision label

Exact integers and rationals differ from rounded decimal values and numerical spectra. An output should carry its inputs, precision and rounding information. Keep the exact source value when preparing a rounded display.

Handle limits explicitly

Inputs must satisfy the mathematical domain, matching ranges must have the same length, and calculations must respect size and runtime limits. An error should identify the input to fix. Final resource limits will be documented as the adapters become available.