Results for “array-formulas”

Generates complex Excel formulas, pivot table configurations, and VBA macros from natural language requests

Parse RFP/RFI/RFQ documents, score fit per requirement with verifiable proof points, generate win-themes, estimate winrate, and produce a bid/no-bid recommendation using the Shipley method.

Excel/Sheets Formula Troubleshooter

Create, edit, and analyze spreadsheets with formulas, formatting, and data visualization using openpyxl and pandas.

DataFrame operations with pandas and polars — groupby, joins, reshaping, performance. Use when manipulating tabular data, choosing between pandas and polars, optimizing DataFrame code, or translating between the two libraries.

Provides guidance on using the Aeon library for time series forecasting, covering model selection, implementation, and evaluation.

Define and enforce data schemas and quality checks using pandera, Great Expectations, or manual assertions, with clear error handling and documentation.

Create, edit, analyze, or convert Excel spreadsheets (.xlsx, .xlsm) with formulas, formatting, financial models, and multi-sheet workbooks.

Creates executable Polars dataframe contracts using Pandera's Polars backend for runtime validation of schemas, columns, and checks.