Overview
Barns
Active Sites
0
of 0 total sites
Total Capacity
0
head across all sites
Avg Occupancy
0%
heads on site
Alerts
0
Warning or Alert status
| Site | Status | Premise ID | Location | Capacity / Occupancy | Phase | Owner | Manager | Actions |
|---|
Barns
Dimensions, install dates and facility records per barn
Total Staff
0
labor + on-site contacts
Open Tasks
0
outstanding items
Sites Monitored
0
with health records
Sites Healthy
0
no disease flags
Site Management
Contacts, health status, staff & tasks — expand a site to view details
Current
0
—
In Renegotiation
0
—
Past Renegotiation
0
—
New Contract In Process
0
—
Needs Attention
0
—
Contracts by Site
Expand a site to view its contracts
Utility Accounts
0
across all sites
Utilities by Site
Expand a site to view its utility accounts
Total Feed Current Inventory
—
across all bins
Avg Lbs/Pig/Day
—
barn average
Low Bins
0
predicted empty within 2 days
Pending Orders
0
awaiting delivery
Bin Levels
Deliveries
Bins & Readings
Inventory
Feed Orders
Click a site to open its barns, then a barn to see its bins. Log what a bin is holding and mark which one is
open — days to empty is that bin's tons divided by what the room eats, taken from the Feed Intake Curve in
Admin › Pig Intake Metrics (head × lb per head per day at their age). Edit that curve and every date here follows it.
Overview
MMP Info
Hauling Progress
Spring Hauling Needs
Pumping Protocols
At Capacity
0
—
Pump Soon
0
—
Monitor
0
—
Normal
0
—
No Current Reading
0
—
Pit Management by Site
Expand a site to view and update its manure pits
Hauling Progress
Hauled versus not yet hauled this season
Spring Hauling Needs
Sites carrying too much manure to make it to fall
Pumping Protocols
Barn Setup Protocols by Integrator
MMP Info
Manure Management Plan — upload a PDF per site to store and extract plan details
Work Order
Supply Order
Turn Maintenance
Open
0
Awaiting action
In Progress
0
Actively being worked
Completed
0
Completed this month
High Priority
0
Urgent items
Work Orders by Site
Expand a site to view its work orders
Order Supplies
Submit supply requests by site
Turn Maintenance
Work noted now, surfaced when the barn starts selling
Required monthly: Pit Measurements & Rodent Baiting. Resets 1st of each month.
Total Tank Capacity
0
gallons across all tanks
Est. Remaining
0
gallons current inventory
Low Tanks
0
tanks below threshold
24-Hr Usage
0
gallons used since last import
LP Tanks by Site
Current fill level, usage history, and days to empty per tank
Previous 24 Hr
History
Jump to
Distynct Sites — Live Data
Daily temp, water, pit level via Distynct API · 1 site · 4 rooms · Updated Daily
Loading…
AP Connect Sites — Live Data
Daily temp, humidity, heater & feeder runtime, water · 8 sites · 28 rooms · Updated Daily
Loading…
📡 BarnTalk Sites — Live Data
Temp, sensors & alarms via BarnTalk gateway (BarnTools)
Loading…
🌡 Agri-Alert Sites — Live Data
Daily hi/lo temp & water spill via Agri-Alert gateway · Updated every 10 min
Loading…
Barn Conditions by Site
Import your daily export below · Click any site to expand barn-level temp and water data
Site Schedules
Weekly projected closeouts and refills per site/barn. Updated from external email schedule.
Total System Capacity
—
kW installed across all sites
Energy Today
—
kWh generated today
Monthly Savings
—
estimated this month
CO₂ Offset
—
lbs this month
Solar Energy Systems
Monitoring generation, savings, and system status per site
Generation History
Daily totals from sync log
⤢ Click to enlarge
Instructional videos for hog facility caretakers. Click any video to open it on YouTube.
💬
Spanish Subtitles Available — Make sure captions are enabled on your device
How to enable subtitles on YouTube:
1. Open the video and tap anywhere on the screen to show controls.
2. Tap the CC button in the upper-right corner of the video.
3. Select Spanish (Mexico) from the subtitle options.
If CC is not visible, tap the three-dot menu (⋮) → Captions.
1. Open the video and tap anywhere on the screen to show controls.
2. Tap the CC button in the upper-right corner of the video.
3. Select Spanish (Mexico) from the subtitle options.
If CC is not visible, tap the three-dot menu (⋮) → Captions.
Loading videos…
Reports
Period:
Site:
Loading reports…
🚀 DASHBOARD DEPLOY CONTROL
If something is wrong with the dashboard, start here.
Tap the button above to see what the live site is running.
Something broke after an update? Press UNDO. It puts the previous version back within seconds. It never deletes data — it only changes which version of the dashboard everyone is served. Safe to press if you're unsure.
PUBLISH installs an update that has been prepared for you. If nothing is waiting, it says so and changes nothing. If what's waiting doesn't match the current version, it refuses rather than guessing.
If this page won't even load: open Google Drive → Prairie Deploy Inbox → create a file named ROLLBACK_NOW.txt. The site undoes itself within 10 minutes, no laptop needed.
PUBLISH installs an update that has been prepared for you. If nothing is waiting, it says so and changes nothing. If what's waiting doesn't match the current version, it refuses rather than guessing.
If this page won't even load: open Google Drive → Prairie Deploy Inbox → create a file named ROLLBACK_NOW.txt. The site undoes itself within 10 minutes, no laptop needed.
Messaging Settings
All SMS and email — login credentials, automatic alerts, and mass communications — route through these settings.
TWILIO
SMS Channel — used for login notifications, alerts & mass communications
From Number
Your Twilio number (E.164 format)
Account SID
Auth Token
GMAIL
Email Channel — sends from prairieconsultingiowa@gmail.com
Google Apps Script URL
Deploy once — handles both email and SMS via Twilio. Click Setup Guide above for instructions.
Anthropic API Key (for MMP AI scanning)
Get your key at console.anthropic.com → API Keys. Used to scan MMP PDFs.
Broadcast Message
Send a one-time SMS and/or email to groups or individual users. Uses your Twilio number and Gmail above.
Group
Send Via
Message
Attached to the email only — a text message cannot carry them.
0 chars
AP Connect Accounts
Store API keys by account name. Assign accounts to sites in Site Database — all barns on that site inherit the key.
AP Connect Room Mapping
Match each AP Connect room to its barn card in the dashboard. One-time setup — saves to Firebase.
AP Connect Room
Dashboard Site
Dashboard Barn Card
Status
LP Tank Mapping
Map LP tanks to sites and barns. A single tank can feed one barn or multiple barns.
Click Load Tanks from Firebase to pull the latest LP readings and map them to your sites.
How it works: Your daily LP email gets forwarded to prairieconsultingiowa@gmail.com → the Cloud Function parses it → readings appear here → you assign each tank to a site once → from then on, levels update automatically every day.
How it works: Your daily LP email gets forwarded to prairieconsultingiowa@gmail.com → the Cloud Function parses it → readings appear here → you assign each tank to a site once → from then on, levels update automatically every day.
Work Order Email Recipients
New work orders are automatically emailed to these addresses from prairieconsultingiowa@gmail.com. Admin only.
Changes save automatically and take effect immediately for all new work orders.
SMS Alert to Troy (515-689-5009)
Send a text message when a new work order is submitted. Use as a backup safeguard during testing.
Work Order Permissions
Control which users can submit work orders for each site. Admins always have full access.
Open Admin tab to load.
Total Users
0
Registered accounts
Signed In This Week
0
Click to see who has not
Administrators
0
Full access accounts
Restricted Users
0
Site-limited access
Sign-in Security
Give every user a real Firebase sign-in account so the database stops accepting anonymous visitors.
Users
Select a user to edit permissions
Select a user to edit their permissions
Integrator Contacts
Store contact info per integrator. Auto-populates the Contracts tab when an integrator is selected.
▼
Integrator
Contact Name
Title
Email
Phone
No contacts yet. Click + Add Contact to begin.
Notification Preferences
Control which users receive email notifications for each event type and site.
Open Admin tab to load.
🌽 Feed Notifications
Configure who receives low feed and Thursday reminder alerts. Only individuals tied to the generating site will be notified.
Biosecurity / BSPL Notifications
Automatic alerts when sites change BSPL status — Hold, PED Positive, or return to Negative.
Variance Notifications
Daily email at 6:00 AM CST — water usage variance alerts across all sites.
Alert Notification Routing (Per-Site)
Assign each person the alert types AND sites they should get — Pit Level (Yellow/Orange/Red), Water Variance, Heater/LP, Feedline Runtime. Disarmed by default — alerts send as one combined report to the old lists until you turn scoping on.
Owner Notification Routing
Per-owner recipients with independent email / text toggles. Each owner is notified only about their own sites. Used by the twice-monthly Site Upkeep reminders. Sends stay disarmed until you turn them on here.
Work Order & Supply Order Recipients
Assign each person to the sites they cover, with email / text toggles, so they only get orders for their own sites. Disarmed by default — orders send as they do now until you turn scoping on.
Reconcile Inventory to Pig Owner
Bring every barn's head count into line with the pig owner's records. Each barn gets one dated entry labelled as a reconciliation — placement, mortality and marketing history are untouched.
🐷 Polaris Sync
Sync pig inventory, placements, and movements from Seaboard Polaris into the dashboard and calendar.
📌 Step 1 — Add the Polaris Sync button to your bookmarks
Drag this button to your Chrome bookmarks bar. When you're logged into Polaris, click it to fetch all data and auto-sync it to this dashboard.
🚀 Sync Polaris to Dashboard
🔑 Nightly sync token
The 2 AM sync renews its own credential every night. When that chain breaks you get a 401 and it stops until a fresh one is dropped in here — no Apps Script editing, no Script Properties.
In a logged-in Polaris tab, press F12 → Console, run the line below, copy the result, and paste it here. Do not test it anywhere else first — it is single use and testing burns it.
JSON.parse(localStorage.getItem('@osdk/oauth : refresh : a6a95772655d67843812980ef8b8e387')).refresh_token
Manual Token Fallback (optional)
The bookmarklet above handles everything automatically. This field is only a backup if you want to test a token manually. Tokens expire after ~1 hour.
Step 3 — Choose What to Sync
Farm Number → Site Mapping
Maps Seaboard farm numbers to Prairie site IDs. Edit if a farm is incorrectly matched.
🔁 How to Refresh the Polaris Token (when daily sync fails with 401)
When does this need to happen?
The Apps Script
polarisSyncDaily runs automatically every night and rotates its own refresh token each time it runs — so under normal operation you do nothing. But if the chain ever gets broken (typically because Polaris sat unused for 30+ days, or you manually logged out everywhere, or the daily trigger failed for too long), the next run will fail with Token refresh failed: 400 invalid_grant or 401. You'll get an automatic error email from Apps Script. When that happens, follow the steps below.Step-by-step
- Open Polaris in Chrome and log in (Growing Pig Farm Manager or any Polaris app).
- Open DevTools: press F12. Click the Network tab at the top of DevTools.
- Filter for token requests: in the filter box at the top of the Network panel, type
token. - Trigger a token request: click around in Polaris (change a date, navigate to a different farm, or just wait 30-60 seconds). A row named
tokenwith path/multipass/api/oauth2/tokenwill appear in the list. - Click that
tokenrow. A panel opens on the right with tabs: Headers / Payload / Preview / Response. - Click the
Responsetab (NOT Payload — Payload has the OLD token being sent up; Response has the NEW token coming back). - You'll see JSON like:
{ "access_token": "eyJ...long...", "refresh_token": "Ax9pQ8...short...", ← copy this "expires_in": 3600, "token_type": "bearer" }Copy the value ofrefresh_token. It's a short string, usually 20-30 characters. - Open the Apps Script editor: go to script.google.com → open Prairie Consulting Automation →
PolarisSync.gsfile. - Find
setupPolarisAuth()(around line 50). You'll see a line like:var refreshToken = 'oldTokenValueHere';
Replace the value between the quotes with the new refresh token you just copied. Save (Ctrl+S). - From the function dropdown at the top of Apps Script, select
setupPolarisAuth. Click Run. Watch the Execution log at the bottom — should show:✅ Setup complete. Got access token starting: eyJ...
- Test the full sync by selecting
polarisSyncDailyfrom the dropdown and clicking Run. Should write ~135+ records to Firebase. - Done. The daily trigger will keep working from here. You don't need to touch the trigger or anything else.
Heads up: using a refresh token in Apps Script invalidates your current Chrome Polaris session within ~1 hour. After that, you'll need to log into Polaris in Chrome again. This is normal — it's the trade-off for permanent automation.
Pig Intake Metrics
Reference growth & water intake curves. Edit phase values to adjust the daily water chart.
Typical Commercial Pig Growth Curve (extension-based averages)
Age
Approx Weight
Feed Intake Curve (as-fed lb per head per day)
This is what drives days-to-empty and predicted empty dates on the Feed tab. Intake values are anchored to the
Pork Information Gateway nursery and growing-finishing recommendations (barrow/gilt average); the age column is a
standard wean-to-finish growth curve. Values between rows are interpolated. Edit any number to match what your
barns actually do and every prediction follows it.
Age (days)
Typical Weight (lb)
Lb / Head / Day
Feed Bin Registry (farms no feed system reports)
Seaboard bins come from Polaris and German and Hansen Brothers come from FAS, so they need nothing here.
The rest of the farms have no system reporting their bins — enter the bin numbers once and those sites
behave like every other one on the Feed tab: levels, predicted empty dates, the closeout calculator and the
menu badges. Head and age come off the barn ledger on their own. Every room is seeded with a tandem pair of
bins; Otley barns 6, 7, 8 and 9 are seeded as three bins shared by the barn's two rooms, numbered 6-1 to 6-3
and so on. Tick Rooms share 3 bins on any barn to switch it either way.
Tandem pair per room, three shared bins on Otley 6, 7, 8 and 9. Adjust any site afterwards.
Typical Water Intake (gallons per pig per day)
Pig Type / Weight
Gal / Day
Industry Standard Daily Water Consumption by Age
🟦 Nursery · Days 1–56
🟩 Grower · Days 57–83
🟨 Finisher · Days 84–200
■ Nursery (1–56)
■ Grower (57–83)
■ Finisher (84–182)
Daily Water Values — All 200 Days
Barn Conditions Card Color Thresholds
Water usage is compared to expected gal/head × inventory using the curve above and the site's animal age. Grow-Finish sites automatically add 56 days to reported age.
🟢 Normal — below amber
Actual ≤ expected + amber %
🟡 Amber — elevated
≥
% above expected
🔴 Red — high alert
≥
% above expected
Weight Estimation Formula
Est. Weight (lb) = pigWeightValues[adjustedDay - 1]Where adjustedDay = reported
ageInDays from AP Connect+ 56 days if site Phase = Grow-Finish
Clamped to days 1–200. Value is per pig, not total weight.
Prairie Daily Water Consumption by Age
Real-world gal/head data collected from all AP Connect sites. Each point = one barn-day. Automatically excludes flagged records. Temperature shown as overlay.
● Prairie Gal/Head
— Industry Standard
— Hi Temp °F (÷10 scale)
Recent Records
Toggle EXCL to flag wash cycles or inventory errors. Excluded records are hidden from the chart but preserved in the database.
Estimated Weight Curve (lbs per pig · same phase structure as water)
Feed Conversion Ratio (FCR)
Lbs of feed required per 1 lb of weight gain. Used with placement weight + feed data to calculate estimated current weight. Typical grow-finish: 2.6–3.0.
🟦 Nursery · Days 1–56
🟩 Grower · Days 57–83
🟨 Finisher · Days 84–200
■ Nursery (1–56)
■ Grower (57–83)
■ Finisher (84+)
╌ Maschhoff
Daily Weight Values — All 200 Days
Import Site Fields
Upload a CSV or XLSX to fill in Premise ID, owner contact info, address, etc. Default: only empty fields are updated. Check "Replace existing values" to overwrite everything from the spreadsheet.
Columns matched by name (flexible order): Site ID or Site Name · Premise ID · Owner Entity · Owner Name · Owner Address · Owner City · Owner State · Owner Zip · Owner Phone · Owner Email
Data Backup & Restore
Export all data to a file to back it up or transfer to a new version of this app. Import to restore.
Firebase Cloud Sync
●
Local only
Sync all data across devices in real time using Firebase Realtime Database.
Paste your Firebase Realtime Database URL above, then click Connect.
How to set up Firebase (free, 5 minutes)
1
Go to console.firebase.google.com and sign in with your Google account.
2
Click Add Project, give it a name (e.g. Prairie Consulting), and complete the setup wizard.
3
In the left sidebar click Build → Realtime Database → Create Database → choose your region → select Start in test mode → click Enable.
4
You'll see a URL at the top of the Realtime Database page like:
https://prairie-consulting-default-rtdb.firebaseio.com — copy it.
5
Fix database rules (critical step): In the Firebase console go to Realtime Database → Rules tab. Replace everything with:
{"rules":{".read":true,".write":true}}
Then click Publish. Without this step the connection will be denied.
6
Paste the URL in the field above and click Connect. All your data will sync automatically across every device.
⚠️ Important: Firebase sync only works when the file is served from a web server — not opened directly from your desktop (file://). The easiest options:
• Drag this file to app.netlify.com/drop for free instant hosting
• Or host it on any web server / shared drive that serves HTTP
• Drag this file to app.netlify.com/drop for free instant hosting
• Or host it on any web server / shared drive that serves HTTP
Pit Gallons Formula
Formula used to calculate gallons from pit measurements. Variables:
width, length, level (all in feet after conversion).
Default formula:
width * length * level / 12 * 7.48 — pit floor area (ft²) × depth (ft) × 7.48 gal/ft³.
Post Pumping Minimum Level is the inches that must remain after pumping — used to calculate pumpable gallons on each pit card.
Slat Thickness is what a measurement taken from the top of the slat reads high by: free space to top of slat = pit depth + slat thickness − level.
Application Rate Formulas
Formulas used to calculate application rates. Variables:
n, p, k, countyYield, suppN, gallons.County Yields
Data Self Test
Checks the live database for the things that quietly make a number wrong. The same checks run every morning and email only when something is off.
Not run yet.
Spring Hauling
A pit carrying this much measured manure on the date below cannot be counted on to make it to fall, so the site goes on the spring hauling list.
Measured manure is the level logged on the pit card, not free space. The date repeats every year — no year is stored.
Storage & Billing
Real-time Database usage by node · Free tier: 1 GB stored / 10 GB/month download
Total Head Placed
0
across all barns
Current Inventory
0
placed − mort − marketed
Total Deads
0
cumulative all barns
Total Euthanized
0
cumulative all barns
Total Marketed
0
cumulative all barns
Total Culls
0
cumulative all barns
Barn Group Tracking
Per-barn livestock inventory, mortality & marketing records
No barns added yet. Click Auto-populate from Barns to create entries for all barns, or + Add Barn to add one manually.
Medication Alerts
0
barns requiring medication
Active Withdrawals
0
pending drug-free dates
Drug-Free Barns
0
no active withdrawal
Barns Tracked
0
with vet records
Barn Veterinary Records
Per-barn medication tracking, withdrawal times & drug-free dates
No barns added yet. Click + Add Barn to begin tracking veterinary records.