mirror of
https://github.com/storytold/gridcraft.git
synced 2026-11-07 13:23:06 +00:00
Dylan M. Taylor
0b1d623549
- WORKDAY/WORKDAY.INTL counted the holidays each step passed by scanning every holiday, once per step; a run of consecutive holidays made that quadratic. The working-day holidays are kept sorted and counted by binary search. - PIVOTBY totals rescanned the whole source (rebuilding keys) once per total row and column. The grouping pass now also indexes rows by row key and by column key, and totals read from those indexes in the same order. - SORT copied one key per sort_index entry for every row, so a long sort_index with repeated columns multiplied the source. Repeats can't break a tie their first use left, so only first uses are kept. - DSUM and the other database functions tested every record against every criteria row. A selection whose records x conditions exceed 5e8 is #NUM!, and each criteria label's database column is found once, not per cell.