- write formulas for me (single cell but let me say in english what I want then give me the formula)
- do more complex things like "add another week" (1) insert new column (2) copy all formulas (3) adjust the fixed date
- Explain a sheet / formula / section - Help me understand where this value comes from
- do large scale formatting adjustments/alignments
- find discrepancies / inconsistencies
Your requirement is to be able to automatically add rows (add corresponding formulas to calculate the corresponding data) or filter data through AI, which may allow AI to create a new data (automatically generate corresponding rows and make the data simpler)
Interesting. I've not used it but this sounds like the tools that were exposed to it need improvement. Everything you describe seems like it should be mostly in reach of current larger models.
