Create and edit .xlsx workbooks with formulas recalculated via LibreOffice.
npx skills add https://github.com/wtgoku-create/PopiStudio --skill xlsx-wtgoku-create
Please help me install this Agent Skill. Skill: xlsx Source: https://github.com/wtgoku-create/PopiStudio/tree/main/SKILLs/xlsx Command: npx skills add https://github.com/wtgoku-create/PopiStudio --skill xlsx-wtgoku-create
This Skill eliminates broken or non-recalculating spreadsheet models by ensuring Excel formulas are correctly constructed, preserved, and recalculated without common error values like #REF!, #DIV/0!, or #VALUE!.
Ask the Skill to generate or update an Excel model file using Excel formulas (not hardcoded computed values), recalculate everything, and return a workbook with zero formula errors.
High-intent search queries and answers about installing and using this skill.
To rebuild an Excel spreadsheet model without formula recalculation errors, construct formulas using proper cell references and run a LibreOffice-driven recalc to verify the final workbook contains zero Excel error tokens like #REF! or #DIV/0!.
You can edit an existing xlsx file while preserving template formatting and formulas by applying modifications that match established conventions and maintaining formula integrity through a verified recalculation process.
Your Excel workbook shows #VALUE! or #DIV/0! errors after modifying spreadsheet models because formulas lack correct cell references or contain hardcoded computed values instead of actual formulas, requiring a robust recalculation to eliminate error tokens.
Yes, you can use pandas for data analysis and export results to a reliable Excel workbook by preparing data structures with correct formulas and documented hardcoded sources for full auditability.
The best way to document hardcoded values in Excel spreadsheet modeling is to enforce the practice of using formulas over hardcoded computed values and explicitly documenting hardcoded sources to ensure robust assumptions and auditability.
While openpyxl helps generate xlsx files, guaranteeing zero formula errors requires running a LibreOffice-driven recalculation to verify the final workbook contains absolutely zero occurrences of Excel formula error tokens.
QvvvvvvQAutomate XLSX/XLSM/CSV workbook construction, formula recalculation, and validation via CLI.
rezosndGenerate styled Excel workbooks with formulas, charts, and data validation.
yuexpsAutomate Excel spreadsheet analysis, formatting, and formula management with openpyxl and pandas.
AutumnsGroveAutomates Excel workbook creation, editing, and analysis via OpenPyXL and Pandas.
