📖 Guide
Raw Data 0
Alliance Summary
Leaderboards
Day 1 — Construction —
Day 2 — Research —
Day 4 MOE —
Day 4 VP —
🔍 Chief Lookup
📨 Output Messages
SVS Prep Scheduler
Developed by VKS 3156
📋
📊
⭐
Submit SVS Data
Google Form for chiefs
View Collected Responses
Google Sheet — download XLSX from here
GitHub Repository
Source code & dummy data
📂
First time? Download sample SVS data to try it out
Download the sample XLSX below, then drag it into the upload zone on the left.
⬇ Download Sample Data
HOW TO USE
1Open the collected responses link above → File → Download → Excel (.xlsx).
2Drop the downloaded file onto the upload zone in the left sidebar.
3Optionally click any chief's row in Raw Data to adjust their submitted values.
4Run each day's schedule using the sidebar buttons. Day 4 generates both MOE and VP automatically.
5Use the Output Messages tab to find pre-formatted alliance messages ready to paste into game chat.
HOW IT WORKS
Data & Deduplication
Deduplicates by Chief ID. If a chief submitted more than once, only their latest response is used.
Deduplicates by Chief ID. If a chief submitted more than once, only their latest response is used.
Day 1 — Construction
Ranked by raw construction speedups. Top 48 receive a 30-min slot.
Ranked by raw construction speedups. Top 48 receive a 30-min slot.
Day 2 — Research
Ranked by Research Points:
Ranked by Research Points:
Points = (Eff Shards × 1000) + (Eff SU × 1440 × 30)
Eff SU = MIN(raw SU, steel cap)
Steel cap = steel (M) ÷ 33,000*
*33,000 is an estimate of steel per research day. FC Shards boost your score but are not required — research centre upgrades can always be performed without them. Chiefs with zero construction SU have all Fire Crystals converted to FC Shards at 1 FC = 1.3 FCS.Eff SU = MIN(raw SU, steel cap)
Steel cap = steel (M) ÷ 33,000*
Day 4 — Training
Top 48 by training SU → MOE (30% buff). Next 48 → VP (10% buff). MOE always runs first.
Top 48 by training SU → MOE (30% buff). Next 48 → VP (10% buff). MOE always runs first.
Tiebreakers
Equal SU → higher FC level wins. FC12 > FC11 > ... > FC1 > 30 > 29...
Equal SU → higher FC level wins. FC12 > FC11 > ... > FC1 > 30 > 29...
Slot Assignment
48 slots of 30 min across 24h UTC. Most time-constrained chiefs assigned first. If preferred windows are full, the closest available slot is used with midnight wrap-around.
48 slots of 30 min across 24h UTC. Most time-constrained chiefs assigned first. If preferred windows are full, the closest available slot is used with midnight wrap-around.
Upload your Google Form XLSX to get started
Click "Alliance Summary" to generate
Load data to view leaderboards
Slot map — Day 1 Construction (blue = preferred · orange = closest available)
Click "Run Day 1" to generate
Slot map — Day 2 Research (blue = preferred · orange = closest available)
Click "Run Day 2" to generate
Slot map — Day 4 MOE · 30% training buff
Click "Run Day 4" to generate
Slot map — Day 4 VP · 10% training buff
Click "Run Day 4" to generate
Select all text in any box and copy (Ctrl+A, Ctrl+C)
Run a schedule to see output messages