Can this skill help with vendor selection?

Absolutely. It is specifically designed for comparing multiple vendors, tools, or technical solutions across various criteria with recorded justifications for every score.

Do I need a Google account to use this skill?

Yes, this skill requires a Google Sheets MCP server and a Google account to create and manage the analysis spreadsheets.

What is the scoring scale used?

The skill uses a standard 0-5 scale where each score is paired with a written justification to ensure the final ranking is auditable and transparent.

How does the weighting system work?

You define relative importance for different categories (e.g., Cost, Performance). The skill automatically normalizes these weights to calculate a final weighted score for each option.

Can I resume a decision analysis I started earlier?

Yes, the skill uses a state-driven workflow stored in a 'Metadata' sheet within your spreadsheet, allowing Claude to detect your progress and pick up where you left off.

Options Analysis & Weighted Scoring

Name: Options Analysis & Weighted Scoring
Author: ralphbean

byralphbean

0•

Productivity & Workflow

Conducts structured multi-criteria decision analysis (MCDA) by generating weighted scoring spreadsheets in Google Sheets.

The options-analysis skill helps teams and individuals move beyond gut-feeling decisions by implementing a systematic, auditable framework for comparing complex choices. It guides users through defining evaluation criteria, assigning importance weights, and scoring options on a 0-5 scale with documented justifications. By automating the creation of Google Sheets with built-in formulas for weighted averages and rankings, it transforms the decision-making process into a repeatable, data-driven workflow that supports stakeholder transparency and long-term documentation.

Key Features

01Automated Google Sheets generation with pre-configured scoring formulas

020 GitHub stars

03Visual area grouping with color-coded categorization

04State-driven resumable workflow for complex evaluations

05Detailed justification capture for every score assigned

06Weighted multi-criteria decision analysis (MCDA) framework

Use Cases

01Evaluating and ranking cloud providers or technical vendors

02Comparing architectural approaches for software projects

03Prioritizing product features based on strategic value and effort

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ralphbean/claude-code-plugins options-analysis

For use in Claude.ai and ChatGPT

Download Skill