// RBLS · weekly data ·
Weekly Points
Current week
No data has been entered for this week yet — all points start at 0.
Left-click a cell to cycle its state, right-click (long-press on mobile) to type an exact value.
ⓘ How the day cells work
9.2 green — reached ≥ 7.2M, counts as a VS day
5.1 yellow — below 7.2M, does not count
0 red — zero points · empty = nothing entered yet
Entering values
• Left-click cycles: empty → ✓ (reached, no exact number) → 0 → empty.
• Right-click (long-press on mobile) → type the exact value in millions (e.g.
9.2). Empty clears the cell, 0 = zero.• “All” in a day header toggles that whole day. The row button “0” marks a player's whole week as zero.
Auto-fill (Gemini, below)
Reads a video/screenshots of the daily ranking and pre-fills the numbers & colors automatically. Not-found members default to 0 (flagged for review); odd names can be assigned manually and are then remembered. Always review, then Save.
⚡ Auto-fill from video / screenshots (Gemini)
Video must be MP4 (or upload screenshots). Scroll the full daily ranking slowly. Values are pre-filled only — review, then Save.
Points (C) = round up (total donations / 1,000), max. 35 points (≥35k = full).
⚡ Auto-fill from video / screenshots (Gemini)
Reads the weekly donation ranking (Spende → Weekly). ≥35k is written as 35000. Pre-filled only — review, then Save.
5 points per Marshall (M) / Zombie (Z) check, 10 points for Canyon and Desert Storm (WS).
⚡ Auto-fill from event mail (Gemini)
Everyone in the event mail = participated → checked for the chosen event. Others stay unchecked. Review, then Save.
Season Analysis
Admin — maintenance tools
These tools rewrite the WeeklyScores sheet. They are separate from the normal admin
password on purpose — a wrong click here changes points for the whole alliance.
Enter the maintenance key to unlock.
ⓘ What "recalculate" actually does
Data_VS, Data_Spenden,
Data_Events, CombatPower — is what you type in. WeeklyScores is
derived from it: Team, VS, Donations, Events and the total are computed, not entered.Normally WeeklyScores is refreshed automatically every time you press Save on the Enter Data tab. These buttons redo that calculation on demand. They never touch the raw data — they only rewrite the derived points.
Use them when:
• someone edited the sheet by hand instead of using this page
• combat power was updated after the last save (Team points then still show the old power)
• a save failed halfway — raw data is in the sheet but the points did not update
• a scoring rule was changed in the code and old weeks need to catch up
Recomputes only the week selected above () for all active members. Safe and quick — this is the one you normally want. Everything else stays untouched.
⚠ Rewrites every week in the sheet at once. Only use this after a
scoring rule changed, or when many weeks drifted.
Important side effect: CombatPower stores only the current value — there is
no history. So this recalculates old weeks with today's combat power, and past Team points
will change. That is usually not what you want for a finished season.
After recalculating: the train ranks from WeeklyScores of the two previous weeks. If you recalculated a week the train uses, press Calculate once on the train page, otherwise it keeps the old order.