// RBLS · command
Command center
ℹ️ What is this? — the member score
We built a score from 0 to 100 for every active member. It is the weighted average of four areas: VS (share of days with 7.2M+ points) · Donations (share of weeks reaching the 35k cap) · Reliability (Desert Storm / Canyon: attended vs. registered) · Other events (Marshall / Zombie participation).
≥ 70 green = reliable core · 40–69 yellow = worth a look · < 40 red = at risk. Unexcused event no-shows cost extra points (−2 each, capped at −20). Strength values (THP, First Squad, Kills) are context only and never count into the score. Every member's score is in the Members tab; what each column means is explained under "All Data".
⚠️ Wrong admin password — excuses could not be loaded
The password stored in this browser session was rejected. Excused absences are therefore missing, which makes Reliability % too low and No-shows too high. The stored password has been cleared — enter it again in the "Ask AI" box below.
Ask AI
Overview
Quick alliance snapshot plus an AI briefing for the last few weeks — who is slipping (missed 7.2M VS days, donations or events) and who was present across the board. The sortable table below updates instantly; the AI briefing writes the same thing as a readable text on demand.
🧪 Beta — the AI summary is experimental; the wording/prompt will still be refined.
Members
Score = weighted average of the rates (VS %, Donations %, Reliability, Events) minus a no-show malus (−2 per unexcused no-show, capped at −20). Traffic light: ≥70 green · 40–69 yellow · <40 red. Weights/malus adjustable under "All Data". THP/First Squad/Kills = context.
Desert Storm / Canyon — reliability
Attended / registered (from the lineup). No-shows = registered, didn't attend, not excused. Reliability = attended ÷ (registered − excused). The current week is not counted — the event has not finished yet — but pending entries are already shown in grey in the player details (click a name).
Other Events — Marshall guard / Zombies
Participation rate = attended ÷ occurred (since first appearance). The current week is not counted.
All Data
Every metric in one table. Quota columns are colored by the thresholds below; the score uses the weights. THP / First Squad / Kills are context only and never count into the score.
ℹ️ What do the columns mean & where does the data come from?
| Column | Meaning | Data source |
|---|---|---|
| THP | Total hero power (THP) in millions — strength context, from LastRank. Not counted in the score. | LastRank (weekly, automatic) |
| First Squad | First-squad combat power in millions — context only. | Entered by members on the First Squad Power page |
| Kills | Recorded kills in millions — context only. | Kill tracking (Enter Kills) |
| VS % | Share of VS days reached (≥ 7.2M points), counted since the member's first recorded week. | Weekly data entry (screenshots/OCR → Data_VS) |
| Don % | Share of weeks with the donation cap (35k) reached. | Weekly data entry (Data_Spenden) |
| Rel % | Desert Storm / Canyon reliability: attended ÷ (registered − excused). Needs at least 3 counted registrations, otherwise "—". The current week never counts (event not finished). | Event Planner lineups (Event_Historie) + recorded participation (Data_Events) + excuses |
| No-shows | Times a member was in a Desert Storm / Canyon lineup, did not attend and was not excused. Refers only to these two events. | Same as Rel % |
| Marshall % | Participation rate in the Marshall guard ("Allianzübung", up to 4× per week): attended ÷ occurrences since first appearance. | Weekly events entry (Data_Events, Marshall_1–4) |
| Zombie % | Participation rate in the weekly Zombie invasion event (up to 2× per week). Listed because it is one of the recurring alliance events — together with Marshall % it forms the Events score component (average of both). | Weekly events entry (Data_Events, Zombie_1–2) |
| Score | Weighted average of VS % · Don % · Rel % · Events, using the weights below, minus the no-show malus (default −2 per unexcused no-show, capped at −20). Missing components ("—") are skipped and their weight is redistributed. | Calculated live; weights from Score_Weights |
⚖ Adjust weights & thresholds (advanced)
Sliders apply live in your browser (displayed shares always add up to 100%). "Save" writes them to the Score_Weights sheet — the Command Center (all tabs) then uses them permanently for everyone. Requires the admin password (Reliability tab).