How They Work

When you separate your data from your analysis in different blocks, you can more easily automate your analysis. Generators help you create analysis that automatically updates as new data is inputted. This eliminates the need to manually update hardcoded formulas with new row or column numbers.

All blocks have the following generators:

  1. Primary data (first row and column) can be programmatically linked to other blocks, making the block reusable without ever having to update formulas. You can configure the primary data with:

    1. Block References

    2. Range Formulas

  2. Filtering - Filter your primary data programmatically, without manual intervention

  3. Sorting - Sort your primary data programmatically, without manual intervention

  4. Autofill - Formulas automatically fill to all rows and/or columns in the direction you choose

PreviousGeneratorsNextBlock References

Last updated