Spread Sheet Management Guide

What is this page?#

/excel-setting is the operational page where you tweak Spread Sheet values mid-broadcast and review the donor chat log that drives the table.

Pick a Sheet & Edit Cells#

• Pick a sheet from the dropdown and click Load (it auto-loads when only one exists).
• Click any cell to open a modal; type a delta and use +/− to adjust (Enter = +).
• Changes save to the server instantly and a sum row appears as the last row.
• Reset All wipes every cell to 0 (confirmation modal appears).

Copy Amount → Paste Into Cell#

• Clicking an amount in the donor chat log enters “copy mode” for that amount.
• While the copy-mode badge is visible, clicking a table cell adds the copied amount to it.
• Press ESC or click the badge to cancel copy mode.
• Use this to quickly apply donations that failed trigger matching.

Sort by Column & Excluded Columns#

• Choose a sort column, then click Sort (Desc) or Sort (Asc).
• When there are 2 or more fixed columns, “exclude columns from sort” checkboxes appear.
• Checked columns are kept in place during sort, preserving “name” columns or other fixed metadata.
• The exclusion setting is persisted in the browser per sheet, surviving subsequent visits.

Detection Settings & Chat Log Filters#

• Define trigger matching with detection window (1–300 sec, default 30), min donation (1–99999, default 1), and an optional reference platform for conversion.
• Log filters: amount min/max, date range, name/message search, 12-platform dropdown.
• Each message row is tagged with orange trigger and red minus-trigger badges so you can see which keyword fired.
• Clear all wipes the donor chat log entirely. Pagination shows 30 per page.

Spread Sheet Management Ideas#

• Manually correct missed donations via the cell modal mid-broadcast to keep viewer trust.
• Live leaderboard: exclude the name column from sorting to pin it, sort only the score column descending, and watch a ‘top donor’ board reshuffle live with every donation.
• Combine the chat log with copy-paste to apply donations that failed trigger matching.
• Filter by date range to isolate one session’s donations for settlement or reporting.

When changes are not reflected in the URL#

Double-click the source with the URL in OBS, check the ‘Refresh browser when scene becomes active’ checkbox, and click the ‘Refresh cache of current page’ button.