options-analysis

Weighted scoring in Google Sheets lets you rank options against criteria by assigning scores (0-5) to each option-criterion pair, then weighting criteria by importance. This Skill creates an Analysis sheet with your scores and justifications, automatically calculates weighted totals, and produces a ranked Summary sheet so decisions are auditable and repeatable.

Multi-criteria decision analysis (MCDA) is a structured method for evaluating options against multiple, often competing criteria. Use it when choosing between cloud providers, vendors, or architectural approaches—situations where subjective judgment matters but you need to reduce bias and document your reasoning for stakeholders.

Yes. This Skill is designed for comparing cloud providers, vendors, or architectural approaches. You define your options, set weighted criteria, score each option against those criteria with justifications, and generate a ranked summary showing which option best meets your priorities.

The Skill uses state-driven navigation to guide you through defined phases: options definition, criteria weighting, scoring, and summary generation. It saves your progress automatically across Analysis, Summary, and Metadata sheets, so you can resume at any point without losing work or context.

The Skill generates three sheets in Google Sheets: an Analysis sheet with all scored options and justifications, a Summary sheet ranking options by weighted score, and a Metadata sheet documenting area weights and phase-detection progress. This structure ensures full traceability and audit trail for your decision.

No. The Skill guides you through each phase with clear structure and state detection, so you only need to define your options, assign criteria importance weights, score each option (0-5), and provide justifications. The weighted calculation and ranking are automated.