Roocops public guide

Guild Auction Spreadsheet Alternative | Roocops

Replace manual guild auction spreadsheets with Roocops, a structured Ragnarok Origin: Classic auction workflow for roster tracking, purchase limits, Discord outputs, and reports.

Direct answer

Replace manual guild auction spreadsheets with Roocops, a structured Ragnarok Origin: Classic auction workflow for roster tracking, purchase limits, Discord outputs, and reports.

Comparison

Manual spreadsheet work vs Roocops workflow

Spreadsheets can track rows, but Roocops keeps roster review, limits, Discord coordination, outputs, and reports in one repeatable guild auction management workflow.

Manual Spreadsheet Workflow

  • Manual row updates
  • Harder purchase-limit tracking
  • Risk of duplicate or missed bidders
  • Slower report cleanup
  • Harder Discord coordination
  • Easy to lose context across sessions

Roocops Workflow

  • Structured auction sessions
  • Purchase limit visibility
  • Roster and response tracking
  • Cleaner reports
  • Discord War Room outputs
  • Repeatable workflow for officers

Overview

This page is for guild officers, auction leads, and teams currently using spreadsheets to manage Ragnarok Origin: Classic guild auction sessions.

Roocops replaces manual guild auction spreadsheets with a structured auction workflow for roster tracking, purchase limits, session setup, check-ins, board generation, Discord outputs, and reports.

Spreadsheet pain points

Spreadsheets are flexible, but guild auction management gets messy when officers are updating rows during a live event while also watching responses in Discord.

The pain usually comes from manual slot tracking, purchase limit mistakes, duplicate winners, skipped or absent member handling, hard-to-read reports, and Discord coordination happening outside the sheet.

  • Manual slot tracking across Feather and Card boards.
  • Purchase limits checked by memory or fragile formulas.
  • Duplicate or missed bidders hidden in busy rows.
  • Skipped and absent members handled in side notes.
  • Reports that need cleanup before officers can share them.
  • Discord messages, pings, and images managed separately.

Manual checking risks

A manual spreadsheet can look correct while still hiding one missed skip, one duplicate winner, or one member who already reached a category limit.

One missed skip can assign a member incorrectly. One purchase-limit mistake can affect auction fairness. Large rosters make spreadsheet QA slow because every row needs another pass before officers can trust the result.

Purchase limit tracking

Roocops keeps purchase-limit review inside the auction workflow instead of scattering it across formulas, tabs, and color rules.

Officers can review current auction categories such as Light-Dark, Time-Space, Puppet, and Illusion when enabled without hardcoding unstable rule values into the page copy.

Member roster review

Roster hygiene matters before any board generation starts. Roocops gives officers one place to review member names, response state, Discord links, and who still needs attention.

Linked Discord members are easier to coordinate during check-ins and bidding notices. Unlinked assigned members can still be reviewed by officers, but Roocops makes that state visible instead of burying it in spreadsheet comments.

Session reports

Roocops separates draft or current board state from the finalized report so officers can review the session before treating it as done.

The Final Report summary, board image outputs, bidder image outputs, and Discord Output Center help officers share results without rebuilding a clean report from spreadsheet rows after the auction.

Frequently asked questions

Can I still use spreadsheets with Roocops?

Yes. You can keep spreadsheets for backups or guild records, while using Roocops for the live auction workflow.

Does Roocops replace Discord?

No. Roocops works with Discord so officers can run /warroom, check-ins, outputs, notices, and reports from the server they already use.

Can board images be posted before finalization?

Yes. Officers can use the Discord Output Center to post board or bidder images while still keeping finalization as a separate review step.

Does Roocops support separate Discord output channels?

Yes. Guilds can configure separate channels for check-ins, outputs, bidding notices, and reports, with the War Room channel as the fallback.

Is Roocops official?

No. Roocops is a fan-made tool and is not affiliated with or endorsed by Ragnarok Origin: Classic, Ragnarok Online, or their rights holders.

What happens if members are not linked to Discord?

They can still exist on the roster, but Discord pings and member-specific shortcuts work best after officers approve the link.

Move your next auction out of the spreadsheet

Open Roocops for the full workflow, or try the Guest Generator when you need a fast board check without signing in.