options-analysis

Create weighted scoring spreadsheets in Google Sheets for multi-criteria decision analysis.

1|Updated Oct 31, 2025

Search Tags:#decision analysis #workflows #google-sheets #weighted scoring #mcda #options-analysis

Ready to run

npx skills add https://github.com/ralphbean/claude-code-plugins --skill options-analysis

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: options-analysis
Source: https://github.com/ralphbean/claude-code-plugins/tree/main/plugins/options-analysis/skills/options-analysis
Command: npx skills add https://github.com/ralphbean/claude-code-plugins --skill options-analysis

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you perform structured, multi-criteria decision analysis (MCDA) by creating a weighted scoring spreadsheet in Google Sheets. It turns subjective judgments into auditable, repeatable decisions, saving time and reducing bias.

Core Features & Use Cases

Weighted scoring across criteria: rank options with scores (0-5) and justifications.
State-driven workflow: guide you through options definition, scoring, and summary with clearly defined phases.
Outputs and traceability: generate an Analysis sheet, a Summary sheet with rankings, and a Metadata sheet detailing weights and progress.
Use Case: Compare cloud providers, vendors, or architectural approaches with auditable justification for each score.

Quick Start

Create or connect to a Google Sheets MCP server.
Create a new spreadsheet named "Options Analysis" and begin defining your options and considerations. The tool will guide you through each phase and save progress automatically.

Frequently Asked Questions about options-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I compare multiple options using weighted scoring in Google Sheets?▼

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.

What is multi-criteria decision analysis (MCDA) and when should I use it?▼

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.

Can I use this Skill to compare cloud providers or vendors?▼

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.

How does the workflow track progress through the analysis phases?▼

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.

What output does this Skill produce, and how is it structured?▼

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.

Do I need prior experience with decision analysis to use this Skill?▼

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.