Tracking Sale Progress

The Progress screen provides a live view of the auction as bids are entered. It updates automatically and can be displayed on a separate screen or monitor during the sale. Both an internal staff view and a public-facing view are available.

The Progress Screen

The progress screen aggregates all bids entered so far and displays summary statistics. It refreshes automatically so the numbers stay current as the sale proceeds.

Overall Totals

The top of the screen shows auction-wide figures:

• Lots sold — count of distinct lot numbers with a recorded bid
• Total amount — sum of all bid amounts
• Average per lot — mean bid across all sold lots
• Bidder count — number of unique bidders who have purchased at least one lot (buyers identified as "UNKNOWN" or any name matching the pattern %BIDDER% are excluded from this count)
• Buyer count — number of distinct buyers on record
• State count — number of distinct buyer states represented (entries coded XX or blank are excluded)

Top Lots by Sale Price

A table of the top 10 lots ranked by bid amount, showing:

• Lot number and suffix
• Animal name
• Amount
• Time of bid
• Buyer information and ownership percentage

Top Bidders by Number of Purchases

The top 10 bidders ranked by count of non-free lots purchased. Free animals ($0 bids) are excluded from this count.

Top Bidders by Total Amount

The top 10 bidders ranked by the total dollar amount of their purchases.

Category Breakdown

A per-category tally table showing:

• Head — number of animals sold in the category
• Interest sold — total ownership percentage sold (sum of SELL_PERCENT / 100), useful for partial-interest sales
• Total amount — sum of bids in the category
• Average per head — total ÷ head count
• Average per interest — total ÷ interest sold
• Gross value — full 100% value implied by partial-interest sales
• Lots — count of distinct composite lots
• Average per lot — total ÷ lot count

Super-categories aggregate their subcategories into a combined row.

Selling Speed

The selling speed section shows how quickly the sale is moving:

• Overall rate — average time per lot from the first bid to the last bid, expressed as MM:SS
• Last 10 rate — average time per lot for the most recent 10 lots sold

The speed calculation identifies natural pauses: if the gap between two consecutive bids exceeds 15 minutes, that gap is treated as an auction break and is not included in the speed calculation. Duplicate timestamps within the same batch of bids are also excluded.

Formula: (time of last bid − time of first bid) ÷ (number of bids − 1)

Last 10 Bids

A chronological list of the 10 most recent bids, showing:

• Timestamp
• Lot number and suffix
• Animal name
• Bidder number
• Amount
• Category
• Buyer info

The Invoiced-Only View

Append ?invoicedOnly=1 to the progress URL to filter all statistics to invoiced items only. This produces a "sold and invoiced to date" snapshot rather than a "sold so far" view. All totals, category breakdowns, bidder counts, and speed calculations are recalculated using only items with an invoice number assigned.

Public Progress View

The public progress view (?public=1) uses a simplified template suitable for displaying on a screen visible to buyers and visitors. It shows the key sale totals and top lots without internal staff details.

Auction Summary Progress

The Auction Summary Progress view (?highlights=1) uses the auction summary highlights template. This is the same data used to generate the Auction Progress Summary report — a concise snapshot of the sale's key performance figures, formatted for printing or sharing after the sale concludes.