BRT DATABASE
Connected. Pick a database on the left to browse its tables.

Orders by Date

by order-entry date
Loading orders…

Process Capacity

open-order load per process
Loading process load…

Profit Assessment

shipped & invoiced
$
Loading invoices…

PROFIT ASSESSMENT REPORTS

$

AI CHAT

Settings

Configure the SQL connection and manage who can sign in.

SQL Server connection

Monthly metal prices

Metal cost ($/lb) by month, built from its components. Total Cost = A + C, where A = LME+MW + Supplier Conversion and C = A × Scrap Rate % × Scrap Conversion. This is what values the metal content of shipments. Edit any cell below and it saves on its own.

$
$
%
$

AI provider keys

API keys for the AI Chat page, one per lab. Keys are stored server-side in aiconfig.json and are never sent back to this browser — once saved, the field shows only whether a key is on file. Saving verifies the key against the provider. Anything you or the model sends is transmitted to that provider. Use Refresh to pull the two newest models from the provider's own catalogue.

Outgoing email

The account outgoing mail is sent through. Pick whichever is easiest for you — a plain SMTP username and password works with any provider and takes a minute; the two Google methods avoid storing a password but need a Google Cloud project. Secrets are stored server-side in mailconfig.json and never sent back to this browser; those fields show only whether something is on file. Saving signs in to prove the details actually work.

From a Google Cloud project with the Gmail API enabled: create an OAuth client of type Web application with https://developers.google.com/oauthplayground as an authorized redirect URI — that lets you mint the refresh token in Google's OAuth Playground rather than writing code. In the Playground, tick “Use your own OAuth credentials”, authorize the gmail.send scope as the sending mailbox, and exchange the code for tokens. Publish the consent screen, or mark it Internal — in “Testing” the refresh token expires after 7 days and mail stops without warning.

Scheduled emails

Add a user

Existing users