@apilium/excel-formulas

Excel and Google Sheets formula reference with VLOOKUP, pivot tables, array formulas, and data analysis for Mayros.

Installation

Copy this skill directory into your Mayros skills folder:

cp -r skills/excel-formulas ~/.mayros/skills/excel-formulas

Or install via the Mayros CLI:

mayros skill install @apilium/excel-formulas

Usage

Once configured, the agent can:

• Lookup formulas: VLOOKUP, XLOOKUP, INDEX+MATCH, HLOOKUP
• Conditional functions: SUMIFS, COUNTIFS, AVERAGEIFS, IF with AND/OR
• Text and date functions: LEFT, RIGHT, MID, DATEDIF, NETWORKDAYS
• Array formulas: FILTER, SORT, UNIQUE, SEQUENCE (Excel 365 / Google Sheets)
• Financial functions: PMT, FV, NPV, IRR, XIRR
• Google Sheets specific: QUERY, IMPORTRANGE, GOOGLEFINANCE, ARRAYFORMULA
• Pivot table guidance: SUMPRODUCT-based manual pivot analysis

Example prompts

"How do I do a VLOOKUP across two sheets?"
"Write a SUMIFS formula for sales > $1000 in Q1"
"What's the XLOOKUP equivalent of my INDEX+MATCH formula?"
"Create a formula to calculate working days between two dates"
"How do I use QUERY in Google Sheets to group by category?"

Semantic Predicates

License

MIT