APEX Tracker — Agency Personnel & Expiration Tracking

Total Officers

Active roster

Fully Certified

All certs current

Expired Certs

Requires action

Expiring Soon

Within 90 days

In FTO Program

Probationary officers

🥧 Cert Status Overview

🥧 Certs by Type

📊 Monthly Expirations

📅 Upcoming Expirations (12 Months)

👮 Roster

🏢 Org Chart

🎖 Training Officers

🔄 Transfers & Assignments

Officer Roster

Badge #	Officer Name	Rank	Division	Unit / Assignment	Watch	Platoon	Cert Status	FTO	Actions

Department Org Chart

Training Officers

⚙ Specialty Categories

Transfers & Assignment Changes

Date	Officer	From Division	From Unit	To Division	To Unit	Watch	Platoon	Reason

📋 Cert Registry

🔍 Cert Search

📂 Upload Cert Files

🏛 Issue In-House Cert

🖼 Certificate Template

✅ Compliance Board

Certification Registry

Defined Certification Types

Issue External Certification

Select Officer

Certification Type

Issue Date

Expiration Date

♾ NO EXPIRATION

Issuing Agency / Instructor

Certificate # / ID

📄

Click to attach scanned certificate

All Issued Certifications

Officer	Certification	Cert #	Issued	Expires	Days Left	Agency / Instructor	Source	Certificate	Status

Certification Search

QUICK:

Officer	Rank	Unit / Division	Certification	Expires	Days Left	Status
ENTER A SEARCH TERM OR SELECT A FILTER ABOVE

Upload Certification Files

PDF · PNG · JPG · Multi-file supported

🔍 AUTO NAME DETECTION

Select Officer

Add Files

Tag & Save

1 — Select Officer

Search Officer

📂

Drop PDF / image files here

or click to browse — you can select multiple files at once

Uploaded Certificate Files

Officer	File Name	Cert Type	Issued	Expires	Uploaded	File	Actions

Issue In-House Certification

Certificate Details

Recipient Officer *

Certification / Training Title *

Certification Type (for tracking)

Completion Day

Month

Year

Expiration Date (for tracker)

Certificate # / ID

Instructor / Signatory 1

Signatory 2 (Chief / CO)

Live Certificate Preview

Auto-updates as you type

Certificate Template Manager

Upload / Replace Template

Upload your department's certificate image (PNG or JPG recommended, landscape orientation). The system will overlay officer name, certification title, date, and other fields automatically. You can replace this template at any time — all previously generated certificates are not affected.

🖼

Click to upload certificate template (PNG / JPG)

Field Position Settings

Adjust where each field prints on your template (as % of certificate width/height).

Officer Name — Y%

Officer Name — Font Size

Cert Title — Y%

Cert Title — Font Size

Date Line — Y%

Sig 1 — Y%

Sig 1 — X%

Sig 2 — X%

Template Preview

No template uploaded yet.

2026

COMPLIANCE BOARD

🟢 Current🟠 Expiring ≤90 days🔴 Expired⬜ Not on file

📚 Archived Compliance Boards

👮 Trainees

🎖 FTO Instructors

📝 Daily Obs. Reports (DOR)

✅ Final Review

Active Trainees

Badge #	Officer	FTO Assigned	Start Date	Phase	Avg Score	Progress	DORs Filed	Status	Actions

FTO Instructor Roster

Daily Observation Reports

📎 Upload Scanned DOR

Trainee

Evaluation Date

Phase

📄

Click to attach scanned DOR (PDF/Image)

Date	Trainee	FTO	Phase	Shift	Avg Rating	NRT Flags	Type	File	Actions

Administrator Final Review

Date	Trainee	DORs Filed	Program Days	Overall Score	Recommendation	Coordinator	Report	Actions

Analytics & Reports

🥧 FTO Phase Distribution

📊 FTO Avg Score by Category

🥧 Rank Breakdown

📊 Cert Compliance Rate

Certification Compliance Report

Certification	Total Issued	Current	Expired	Expiring ≤90d	Compliance %

🔗

VCS POSS Integration Note

VCS POSS does not expose a public API for direct live sync. This scheduler mirrors POSS logic (shift rules, manpower floors, role-based scheduling). Use Export → VCS CSV to import your schedule directly into POSS, or contact VCS at support@vcssoftware.com to inquire about enterprise API access for custom integrations.

Weekly Schedule

⚙ Department Manpower Settings

Min Patrol Officers / Day

Min Supervisors / Day

Patrol Days Off / Week (per officer)

Default Shift Length (hrs)

Day Shift Start

Night Shift Start

Registration Rules

● Patrol Officers — Scheduled on days OFF from patrol (training uses rest days).
● Admin / Support Services — Scheduled on days THEY WORK (during office hours).
● Detectives — Scheduled on working days (no disruption to patrol floor).
● System enforces minimum manpower floors — will not schedule if patrol drops below minimum.

🔫 Weapon Register

🎯 Ammunition & Target Inventory

📊 Analytics & Reports

Weapons & Equipment Register

Officer	Duty Status	Type	Make / Model	Serial #	Caliber	Qualified	Qual Expiry	Notes	Actions

2026

INVENTORY YEAR

Date	Type	Item	Category	Qty In	Qty Out	Balance	Training Event	Notes	Logged By

📚 Archived Inventory Years

Ammunition & Target Analytics

Compare year:

vs.

Usage by Ammunition Type

Usage by Training Event

Real Ammo vs. Simunition vs. Targets

Year-over-Year Comparison

Command Staff Summary — Year-to-Date

⏱ Hours Log

📱 QR Sign-In

🔔 Pending Sign-Ins

📋 Sign-In Sheets

Training Hours Log

Officer	Date	Course / Training	Category	Hours	POST Hrs	FEMA Hrs	Instructor	Location	Source	Actions

QR Code Training Sign-In

📋

Google Forms Integration — Live QR Sign-In

Officers scan the QR code with any phone camera → Google Form opens instantly → they fill it out → responses appear in your Google Sheet in real time.

One-time setup (5 minutes): 1. Create a Google Form at forms.google.com with the fields shown below
2. Click the ⋮ menu → Get pre-filled link → fill one sample entry → Copy Link
3. Paste that link into Google Form Base URL below and map the field IDs
4. Done — every session auto-populates course/date/hours into the form

⚙ Google Form Configuration

Google Form Base URL *

Paste the viewform URL (not the edit URL)

Field Entry IDs

Create these questions in your Google Form, then find each field's entry ID from the pre-fill link (format: entry.XXXXXXXXX)

Officer Name field ID

Badge # field ID

Course Name field ID

Category field ID

Date field ID

Hours field ID

Instructor field ID

Location field ID

⚡

Auto-Sync — Google Apps Script Bridge

Responses auto-appear in Pending Sign-Ins. No CSV. No manual steps.

Apps Script Web App URL

Paste the URL from Step 4 of the setup guide below

Poll Interval

📖 Apps Script Setup Guide (one-time, ~10 min) ▼

One-time setup. After this, responses auto-sync forever.

Step 1 — In your Google Form → click the Responses tab → click the Google Sheets icon → Create a new spreadsheet

Step 2 — In the Google Sheet → click Extensions → Apps Script

Step 3 — Delete all existing code and paste in the script below, then click Save (💾)

Step 4 — Click Deploy → New Deployment → Type: Web App → Execute as: Me → Who has access: Anyone → Deploy → Copy the URL

Step 5 — Paste the URL in the Apps Script Web App URL field above and click ▶ Start Auto-Sync

Paste this into Apps Script (Code.gs)

Manual Fallback (if Auto-Sync not configured)

📅 Configure Training Session

Training Title / Course *

📂 Repository Structure

📁/certificationsScanned cert files by badge # subdirectoryToday
📁/fto-recordsFTO evaluation forms and progress logsToday
📁/reportsAuto-generated compliance reportsToday
📄officers.jsonMaster officer rosterToday
📄certifications.jsonAll issued certificationsToday
⚙️.github/workflows/expiry-alerts.ymlAuto weekly cert expiry scanToday

💾 Export / Sync Data

⚙️ App Configuration

App version: 1.0.0 · Build: APEX-TRACKER-2026

💾 Auto-Save Status

Loading auto-save info...

📦 Backup Files

📥 Restore from Backup

Select a WNYP_CMS_Backup_*.json file to restore officer records, certifications, FTO data, weapons, and training hours.

🔧 AI Maintenance Tool

ADMIN ONLY — POWERED BY CLAUDE FABLE 5

🔍 System Diagnostic Scanner

Run an automated scan of the application state to detect data issues, missing records, and configuration problems.

          Ready. Click Run Full Scan to begin.
        

⚡ Quick Fix Tools

🤖 AI Command Interface CLAUDE FABLE 5

Type a plain-language command and the AI will analyze the application, diagnose the issue, and provide a fix or explanation. All commands are logged.

── AI MAINTENANCE CONSOLE ──

Claude Fable 5 maintenance engineer online. I have live visibility into your application state and can help you:
• Diagnose and fix bugs in the application
• Explain how any feature works
• Identify data inconsistencies
• Suggest improvements
• Answer questions about the system in plain language

Type a command or question below to get started.

Quick:

Enter to send · Shift+Enter for new line · All commands logged in audit trail