All projects

MMO Theorycrafting Sheets

Two Google Sheets workbooks for planning accounts and comparing options in Elder Scrolls Online and Guild Wars 2. Trackers keep characters, gear and goals in one place, and dashboards turn the data into rankings you can reweight to your own priorities.

Google Sheets Analytical Modeling

ESO Account & Character Planner

2025 · Account planning and dashboards

An account-wide workbook for tracking characters, builds, set collection and spending, with a race comparison that ranks options by weights you set.

ESO character roster with filters, a green heatmap of role scores per class, an optimization bar chart and distribution charts by race, class, alliance and role. Race and role performance per class, with selectable display and aggregation and an overall optimization score.

  • Roster of characters by account, class, race, role and alliance.
  • Build tracker linked to each character.
  • Set collection planner with personal priorities.
  • Race comparison scored by adjustable weights.
  • ESO Plus history and Crown wishlist.

Open workbook

GW2 Account & Progression Planner

2026 · Progression modeling and role coverage

A workbook for characters, ascended and legendary gear, fractal progression costs, and a profession role-coverage ranking you can reweight.

GW2 tier list with a filter bar, a weights row, and professions ranked S to C by elite specialization in each role. Role-coverage tier list: each profession is scored per role from the weights row.

  • Character roster and account overview.
  • Cheapest acquisition route for each ascended piece.
  • Legendary gear progress by slot.
  • Fractal progression with gold cost, rewards per hour and progress over time.
  • Role-coverage tier list with adjustable weights.

Open workbook

How it works

Both workbooks start from the same question: how do you turn a large amount of game data into a decision? Trackers hold the data, dashboards summarize it, and comparisons score the options.

Rankings use weights you can change. Each option is scored by multiplying its values by the weights you choose, so the result reflects your priorities instead of a universal tier list.

Scope and data

  • Personal hobby projects, unaffiliated with ArenaNet or ZeniMax Online Studios.
  • The GW2 role-coverage tab uses sample values to demonstrate the method. It does not reproduce third-party build data or show the current meta.
  • Game balance, prices and data change over time, so results reflect the assumptions and data from each workbook's last update.