Bid Panel
Internal access only
A. S. Toler Corp.
AI-classified bid invitations pulled from your inbox (PlanRoom / BuildingConnected / direct GC outreach). Only those whose due date hasn't passed.
public.bid_invitations in Supabase, future-due bid invitations from PlanRoom / BuildingConnected / direct GC outreach will land here automatically.
Live feed from onlineplanservice.com filtered to Alameda, Contra Costa, Santa Clara, San Mateo. Refreshed every 4 hours.
Bids being automatically set up by the pipeline (Dropbox folder, Gmail label, BID BREAKDOWN, plans download — all running in the background). Once setup completes, click Confirm Setup to verify everything looks right and move the bid to your active BID LIST.
Award rates and pipeline health from the bid system + JOBS ARCHIVE.xlsm. Closed bids only (Awarded / Not Awarded). Pending bids excluded from win-rate math.
Agencies where A. S. Toler is pre-qualified to bid. Parsed from the A. S. Toler Admin prequal-approval forwarded emails by Claude. SBX listings whose owner appears here get a PREQUALIFIED pill.
Internal estimating intelligence system — A. S. Toler Corp. Bay Division
Bay PowerBid is A. S. Toler Corp.'s live bidding dashboard. It connects the BID LIST Excel workbook, Gmail, Dropbox, and the SBX plan room into a single view — so estimators always know what's active, what's due, who's bidding, and whether every file, folder, label, and setup task is complete.
Everything on this page is pulled from live cloud databases that are continuously refreshed by a set of automated jobs (GitHub Actions crons + a local Windows watcher). There is no manual refresh button — the page is always current.
| Source | Table | Refresh |
|---|---|---|
| the bid system | bids_cloud | Every 5 min via GitHub Actions. Reads the full BID LIST from SharePoint/cloud storage and does a TRUNCATE + INSERT. Status, estimator, PE, division, bid date, and job walk all flow from here. |
| Local watcher | bids_realtime_cloud | Immediately at bid setup. Writes Gmail label, Dropbox folder URL, and SBX description within ~2 seconds of a new bid being claimed — so cards appear before the next 5-min bids_cloud sync. |
| Gmail (OAuth) | bid_invitations, bid_addenda_cloud | Every 5 min. Scans inbox for bid invitations (Bid Radar) and addendum notices. Matches threads to active bids by project name token overlap. |
| SBX plan room | sbx_listings_cloud, sbx_plan_holders_cloud | Daily (7 AM UTC). Scrapes the SBX plan room for all active future-bid listings — project description, bidder list (GCs who downloaded plans), addenda count. Parser reads Bootstrap div.BidderEntry structure. |
| Bid setup pipeline | prebid_bids_cloud, bid_setup_steps_cloud | Triggered instantly when you click Set Up Bid. Netlify function creates Gmail label + Dropbox folder; local watcher handles BID LIST row, BID BREAKDOWN autofill, and SBX plan download. |
| Prequal emails | prequal_approvals_cloud | Whenever a prequal approval email is forwarded to the estimating inbox. Claude extracts agency name, approval date, and expiration. Drives the PREQUAL REQUIRED pill on bid cards. |
| Ensure-labels cron | bids_realtime_cloud, sbx_plan_holders_cloud | Every 30 min. Guarantees every active bid always has a Gmail label under ESTIMATING/CURRENT BIDS/. Also scans label threads for external GC contacts and writes them as plan holders. |
Your live bid list — every bid currently in BIDDING or BID OR BAIL status in the bid system. Each card shows: scope description (from SBX), bid due date & time, job walk date, quotes in/out, coverage pills (LV, FA, LTNG…), addenda count, GCs bidding from SBX plan holders, Gmail label indicator, Dropbox folder link, and SBX plan room link. Cards expand to show vendor detail, addenda records, and the full setup checklist.
Win/loss history, quote coverage trends, and estimator workload across all historical bids. Driven by bids_cloud which retains full history.
Incoming bid invitations from GCs, scraped from Gmail every 5 min. Claude extracts project name, bid date, scope, and GC contact from each email. Invitations are automatically dismissed once their EST# label exists in Gmail (meaning they've been set up). Vendor quote replies and out-of-state bids are filtered out.
All future-dated electrical bids on the SBX plan room that match A. S. Toler's scope keywords. Refreshed daily. Click Set Up Bid to launch the full automated setup pipeline for any listing.
Live checklist for every bid currently going through setup. Shows each pipeline step — folder sync, BID LIST claim, Gmail label, BID BREAKDOWN autofill, SBX plan download, folder verification, job walk invite — with real-time status from the local watcher.
Agencies where A. S. Toler is pre-qualified to bid, parsed from forwarded prequal approval emails. When an SBX listing's owner agency matches an entry here, the bid card gets a PREQUAL REQUIRED pill.
| Job | Runs | What it does |
|---|---|---|
| sync-bid-list | Every 5 min | Downloads the bid system from SharePoint, TRUNCATE + INSERTs bids_cloud |
| parse-gmail-quotes | Every 5 min | Scans Gmail inbox for bid invitations and vendor quote replies; classifies with Claude Haiku |
| ensure-bid-labels | Every 30 min | Guarantees every active bid has a Gmail label; scans label threads for GC contacts |
| dismiss-set-up-invitations | Every 30 min | Hides Bid Radar entries whose Gmail thread already carries an EST# label (already set up) |
| sync-sbx-details | Daily 7 AM UTC | Scrapes SBX filter.aspx for all active listings — description, bidder list (GCs), addenda count |
| send-job-walk-invites | Daily 2 PM UTC | Sends calendar invite (.ics with RSVP buttons) for any future job walk not yet emailed; deduped by EST# + job walk hash |
| sync-sbx-watchlist | Daily | Pulls all future SBX electrical listings into sbx_listings_cloud for the SBX Watchlist tab |
| local watcher (PC) | Every 60 s | Polls for new prebid rows; runs the full setup pipeline (BID LIST → BB autofill → OPS download). Requires Alex's PC to be on. Status visible in system tray icon. |