🤠 The Sheriff

Your Documents, Deputized.
Settings
Account
Change Password
User Management
Loading...
Groups:
Contractor Accounts
First-class contractor records — one row per regional office. Drives the Proposal Builder dropdown, customer_contractor validation, and (soon) customer-portal logins. Distinct from User Management: contractors are external partner companies, not internal team members.
Loading...
Travel Zones + Mileage
Cities are auto-validated against the master CSV. = exists in master, = ghost (saved, but admin should review).
City Zone Status Buildings
Loading...
Add city → zone mapping
Bulk paste (multiple cities, all assigned to selected zone)
Per-Inspection + Hourly Rates
Default rates apply to everyone. Pick an inspector to set per-person overrides — leave override blank to use the default. The Hourly Rate field is per-inspector; only used when their pay model is Hourly.
Inspection Type Default Rate
Loading...
VPS Status
Loading...
About
App Version:
| | | |

Admin Center

Admin-only tools. Actions taken here may attribute work to other inspectors — proceed deliberately.

Act as Inspector

Save reports, commit, and view My Pending as another inspector. Their signed PDF template, name, and SharePoint folder will be used. Stop anytime to return to your own identity.

Loading inspectors...

Quick Actions

Shortcuts to admin tasks that live in other tabs.

TDLR Database Reconcile

Recomputes column AV (“TDLR Database Reconcile”) on every row of the Submissions table by comparing Sheriff inspection dates against the TDLR public registry. Runs automatically after the daily CSV sync; use this button for an immediate refresh after manually editing the workbook or chasing TDLR for a recent commit. Manual overrides typed into col AV (e.g., “n/a”, “ignore”) are preserved.

Misc Expenses

General business expenses (supplies, meals, etc.) — not trip-bound. Feeds Payroll EXPENSES subtotal as reimbursements.

Loading…

Violation Correction — Upload & Generate

Drop one or more Sheriff-generated inspection PDFs here to produce TDLR violation-correction letters. PDFs are clustered by ELBI — one correction letter per ELBI, covering all decals in the batch. Reads the form fields directly; nothing is written to the database. Scanned / flattened PDFs are skipped.

Bug Reports & Feature Requests

Found a bug or have an idea? Let The Sheriff know.

Loading...

TDLR Master CSV

Auto-Sync
Every 24 hours
Last Sync
Rows
Hash
TIF Files on Disk updates every 30s
ELBIs with TIFs
Total TIF Files
Disk Size
Coverage

Connection Monitor

Idle
Proxy
Not configured
Outbound IP
Last Response
Avg Latency
Requests
0 / 0
403 Streak
0
ELBIs Checked
0 / 0
New Downloads
0
Already On Disk
0
Errors
0
Pass
1
Failed (retry)
0
Mode
Single
Elapsed
-
Docs Raw (API)
0
Phantom ELBIs
0
Outcomes: 0 OK 0 Deferred 0 No Docs 0 Phantom 0 Errors

Activity Log

Waiting to start...

Diagnostic Log

No diagnostic entries yet...

TIF Search

Search for documents to get started.
Inspectors Found
Inspections Extracted
Unscanned TIFs
OCR Processing Loading...
Matched: Failed: Unscanned:

Top 15 Inspectors by Inspection Count

Inspections by City (Top 10)

Inspections by Equipment Type

Inspections by County (Top 10)

OCR Success/Failure Rate by Document Year

Inspector Rankings

Run an OCR scan to populate the leaderboard.

Inspector Detail

My Pending Reports

Drafts you've saved from the Report Builder. Edit and add notes here. Reports sit until you dismiss them.

Loading...
 
 
Modified elsewhere — this report was edited in another tab or device. Refresh to see the latest before saving again.
Loading PDF...
Notes (office-facing)
Inspection Type *
Special Event *
Service Contractor *
Travel Zone
Miles
Parking
$
Tolls
$
For hourly employees
Incomplete Inspection, Punchlist, Travel time
Sends to the live Inspection Records spreadsheet for processing
Common Violations (0)
Loading common violations...

My Reports

Loading...
Quick range:
Always included
Inspection report PDF
Optional add-ons
Loading...

My Reports

Your submitted reports. Click any row to view the PDF.
build v22.0.953

Payroll Report

Generate an Excel file of jobs + miles + parking for a date range. Send pay info to HR.
Loading…

Inspection Reports

Browse and open committed inspection reports grouped by day + ELBI.
Showing cached data. Couldn't reach the live spreadsheet just now — try refresh.
Loading…
Prior Year Inspection 💡 Shift+click a decal tab to peek at its prior report
📄
Search for an ELBI or Decal
Or click + Add New ELBI above to register a brand-new building.
Current Year — Pre-filled Form
📄
Search for an ELBI or Decal
Or click + Add New ELBI above to register a brand-new building.
Common Violations (0)
Search or browse common violations extracted from prior year reports
AI Violation Lookup AI can hallucinate — verify references in codebook
Describe what you observed and AI will find the exact ASME code reference, automatically filtered to the correct edition for this equipment.
AI can hallucinate — always verify references in the codebook
100%
Loading...
Page 1 / 1
Loading image...
Pending Review
-
Ready to Send
-
Pending Invoice
-
Invoiced
-
Total Revenue
-
Unpaid
-
ELBI Job Inspector Type Date Insp. Cost Customer Profit Status Actions
Loading...
Total Contacts
-
Unique Buildings
-
Unique Emails
-
ELBI Building Email Name Confidence Source Seen
Loading...
-

Proposal Builder

Hot Boys Elevator Services — Work By Others Proposals

Job Manager

Hot Boys Elevator Services — Work By Others Projects

Active
0
Invoiced
0
Paid
0
Closed
0
Outstanding
$0
Total Profit
$0
Loading projects...

Document Inbox

Hot Boys Elevator Services — Incoming Documents

Loading documents...

TEXQEI Dashboard

Inspection analytics from Payment Form 6

--
Total Inspections
--
Inspectors
--
Inspection Types
Last sync: -- Download Report

Inspections by Type

Inspections by Inspector

Monthly Inspection Trend

Elevator Map

CSV Loading...
Compliance
Current
Expiring soon
Overdue
Customer

File Manager

Hot Boys Elevator Services — Project Files

Select a project

Choose a project from the list to view and manage its files.

Admin Reports

Cross-inspector committed reports — select rows or whole ELBIs to bulk download as a ZIP.
build v22.0.953

Payroll Report

Cross-inspector payroll preview + xlsx export. Pick an inspector or "All Inspectors".
Loading…

Inspection Reports

Browse and open committed inspection reports grouped by day + ELBI.
Loading…

Email Templates

Create + manage templates used to compose customer-facing emails from Admin Reports.
Templates
Loading…

Pick a template to edit, or click + New

Drift Report

Loading...
TypeSeverityInspectorELBIDecalDateField / DetailDBExcel
Loading...