Shared board — visible to everyone on your team who opens this tool. Locations: Kaneohe Bay, Camp H.M. Smith, Pu'uloa.
Bulk import service calls
One call per line, all four required: COR work order #, serial number, issue reported by COR, type of work order. Type must match a CLIN category: Repair / Emergency / Install / Swap out (use "swap fridge" or "swap range" for the refrigerator & oven range CLIN). Registered serials autofill building, location, and appliance details.
Log a COR service call
New installation — there is no existing unit, so leave the serial blank and fill in the location below. The new machine's serial is recorded when the ticket is completed.
✓ Registered unit — location and appliance details filled from the registry and locked. To correct them, update the unit under Parts & assets.
Completion tickets awaiting manager signature
Work is done and recorded — these turn green the moment the manager signs: on this device, or on their own phone via QR code.
RepairEmergencyInstallSwap out
Time + tech name = scheduled repair · ✓ = completed (faded) · P = parts est. return · DUE = SLA on-site deadline (unscheduled call)
Green day = completion ticket(s) filed · Yellow day = past repair date missing a completion ticket
Select a ticket to complete
Completion data
This form is now the single source of truth. Export completed tickets from the Dashboard tab to feed any downstream spreadsheet or process.
90-day warranty watch — PWS 7.11
Repairs, parts, and labor are warranted for 90 days. Units below have a new service call within 90 days of a completed repair — verify whether the new work is warranty (not billable) before invoicing or ordering parts.
Quarterly archive (admin)
Moves fully closed tickets from past quarters (completed + signed + reported to COR) out of the live working file into per-quarter archive files in SharePoint — keeps the app fast as history grows. Archived tickets stay viewable in the Dashboard archive (read-only) and their signed PDFs remain in SignedTickets. Open, unsigned, or unreported tickets are never archived, and nothing archives until at least one month after completion — recent work always stays live. Tip: export the quarter's invoice CSV first if you want it handy.
Ticket / registry check
Most machines here are stacked pairs that share one serial plate and are told apart only by unit # — 778 of the 1,263 registered units. Builds before v8.76 resolved a serial to whichever registry row came first, so a ticket could name the wrong half of a stack and leave the actually-broken appliance with no work order. This check reads every ticket and lists any whose serial, building and unit # do not point at exactly one live machine. It only reports; nothing is changed.
Master completions workbook (admin)
A single Excel file in SharePoint at Reports/MCBH-Master-Completions.xlsx containing every signed & completed work order — machine detail, technician, government POC who signed, all dates, parts, cost and the path to the signed ticket PDF. It rebuilds automatically each time a ticket is signed off, and covers archived quarters as well as live tickets. It is a report, not a data source — the app never reads it back, so editing it changes nothing and the next sign-off overwrites your edits. SharePoint version history keeps prior copies. Use this button to rebuild it by hand after a restore, or if an auto-update failed while offline.
Backup & restore
Download regular backups from the Dashboard (all tickets + appliance inventory CSVs). If data is ever lost, restore those files here. Restores merge safely: existing ticket #s / COR #s / serials are skipped or updated, never duplicated. Photos and signed-ticket files are not stored in CSVs and cannot be restored this way.
Saves tickets, appliance registry, parts, replacement units, service rates, and MRA limits in a single file (.json). Restoring replaces current data with the file — the fastest way to bring everything back after data loss. Pair with the attachments ZIP for photos and signed tickets.
If the app interface ever breaks: console recovery snippet
Open the app, press F12 → Console, paste and run. Works with whichever storage adapter is active (see js/store.js).
No folder set — exports use normal browser downloads. Setting a folder only affects this app's exports, nothing else. Desktop Chrome/Edge only; lasts until the page is closed.
Bundles every ticket photo and signed completion document, named by work order (e.g. WO-1001_COR260101_signed.jpg). Save or drag the ZIP into your OneDrive folder — attachments are the one thing CSV restore can't recover, so export these regularly too.
Field parts limits (MRA check thresholds)
These drive the tech MRA check. When Exhibit F or the option year changes, update each value as: MRA for that category/age minus your current repair rate. Enter -1 for any bracket where that result is negative (automatic red tag).
Bulk update appliances from spreadsheet
Copy rows straight from your master tracker in Excel (same column order: Bldg #, Room/Floor, Helper, Unit #, Brand, Model #, Serial #, …, Notes, Barracks Manager) and paste below. Existing serials are updated; new serials are added.
Registered appliances
Register a serial number here once, and it'll autofill location, building, room, and appliance type on new service calls.
Spare parts on hand
PWS requires enough common parts on hand to support 12 simultaneous repairs. Qty on hand is not counted yet — it starts at 0 and is only what you enter here. Nothing decrements it automatically, so treat it as a manual count, not live inventory.
Columns: Part number, Part name, Unit cost, Fits model families, Qty on hand. Replaces the whole catalog — tickets already completed keep the parts recorded on them.
Columns: Name, Title, Desk, Cell. Merges by name — numbers update, new people are added, nobody is dropped automatically.
Replacement unit models
New-unit inventory is not tracked. The swap-out picker lists every model in the registry plus anything added here, and a technician can always write in a model that is not listed. Qty is a manual note only — nothing decrements it.
Schedule & edit audit log
Every schedule creation, reschedule, tech reassignment, completion, and admin edit — with timestamps and who made the change. For accountability, compliance, and oversight.
Contract year tracker
Totals per contract year, including archived quarters. APEX/YZ split uses the rates stored in this browser; on other devices it shows government figures only.
Billing month — drives the invoice and the APEX/YZ split below
The selected month applies to the CLIN invoice table, the Excel invoice download, and the APEX vs YZ split. The YZ statement card and the contract-year tracker have their own selectors.
APEX vs YZ PRO split (private — this device only)
Computed from the selected invoice month using the subcontract rates stored in this browser. APEX keeps the CLIN spread plus the 10% fee on the YZ invoice; YZ nets 90% of their rate. Parts pass through at cost (fee does not apply — to be confirmed). Nothing here is uploaded anywhere.
Service rates by work order type (contract)
Government CLIN rates used to compute billed totals. Fixed in the build and never stored in SharePoint — an option-year or contract-mod change goes out as a deploy. Never shown to techs.
Parts pricing — read-only reference
Supplier prices, no delivery. Maintained via the parts workbook → Admin › Import parts CSV under Parts & assets — this list is for reference while invoicing.
YZ PRO subcontract rates (private — this device only)
What YZ PRO invoices APEX per CLIN. Stored only in this browser — never uploaded, never in the deployed app. APEX retains the fee shown; YZ nets the remainder.
Margin & staffing analysis (private — admin only)
Subcontract rates, the APEX fee and margin are stored only in this browser — never uploaded to SharePoint and not part of the deployed app, so YZ PRO cannot see them. The workbook downloads straight to this device; nothing is written to the shared library. Five sheets: per-ticket economics, by month, by technician, staffing scenarios, and CLIN ceiling burn-down. Note the contract quantities are maximums, not guarantees — revenue tracks actual call volume. Rates are edited on the YZ PRO card above.
Operational rate by building — 95% requirement
Down units = open service calls per building. Buildings below 95% sort to the top; their open tickets are also flagged and prioritized on the Schedule tab.
Site manager (CBM) directory
Primary barracks manager per building — updated 26 Aug 2026. Tap to call or email.
Technician directory
Who to call — visible to everyone signed in, including the COR and site managers.
Repair time frames — Technical Exhibit E
Days are government work days, hours are government working hours. After-hours repairs need COR approval. Exceptions (parts or units not available on island) are case-by-case — raise them to the COR as soon as known.
Category
Acknowledge
Complete
Routine service call
1 work day
5 work days
Emergency — received before 10am
Same day
2 work days
Emergency — received after 10am
12pm next work day
2 work days
New installation
1 work day
5 work days
MRA-driven or COR-directed replacements: delivery and install within the same 5 work days.
Service call checklist — Technical Exhibit C
At a minimum, check, adjust and service the following on every service call. A cleaning is included at no additional charge (PWS 7.6.3). Items marked * only when directed by the COR or Contracting Officer.
Washer / gear wash station washer
Belt · Clamps · Fixed dial · Hoses · Motor · Power cord · Pulley · Pump · Solenoid · Switches · Timer · Transmission · *Fill hoses
Dryer / gear wash station dryer
Belt · Belt pulley · Door hinges · Element · Fixed dial · Handles · Lint screen · Motor · Power cord · Switches · Terminal block · Thermostats · Timer · *Vent hose
Gear wash station washers/dryers contain unique parts — the 12-concurrent-repairs parts requirement carries a special-consideration exception for them.
MRA field check — repair or replace?
Select the unit category, age, and parts needed. The tool tells you whether the repair is authorized or the unit must be red-tagged.
Tag reference — what each color means
YELLOW
DD Form 1574 — Serviceable. Unit repaired and returned to service. Run a full test cycle before tagging. This is the normal end state of a successful repair.
GREEN
DD Form 1577-2 — Repairable, awaiting parts. Diagnosis done, parts on order. Submit the "waiting on parts" ticket with the parts list and return date. The repair cost estimate is due to the COR within 1 day of this visit (PWS 7.6.2).
RED
DD Form 1577 — Unserviceable / condemned. Repair exceeds the MRA or the unit is beyond repair. Unit gets replaced and disposed — the app retires its serial from the building count automatically when you file the completion.
Repair process — what the contract requires on every call
Condensed from the Performance Work Statement. Follow this sequence and every ticket stays compliant.
Check in with the CBM / Barracks Duty on arrival at the building.
Verify the serial number against the work order — the intake form autofills from the registry, so mismatches mean wrong machine or unregistered unit.
Diagnose, then run the MRA check (tool above) before ordering parts. If total repair cost exceeds the Maximum Repairable Allowance — or the unit is a replace-only category — it's a Red tag, not a repair.
Check manufacturer warranty first on newer units (PWS 7.10) — the government is not billed for parts still under factory warranty.
Parts needed? Green tag, submit the waiting-on-parts ticket with the parts list and estimated return date. Cost estimate to the COR within 1 day.
Repair complete? Full test cycle, tag the machine, then file the completion ticket the same day: work performed, parts used, date completed, photo(s), and the CBM signature — invoices are not approved without it.
Removed parts (non-consumable) get tagged and turned in to the COR (PWS 7.5.3.2) — don't leave them on site or in the truck.
Emergencies: clothing trapped, flooding/safety hazards, multiple units down — and any inoperable unit in the 1600-series buildings or Bldg 386 is automatically an emergency call (PWS 7.5.4.1.7). These jump the queue.
Your work is warranted 90 days (repairs, parts, labor — PWS 7.11). Repeat calls inside 90 days get flagged for a warranty determination before any billing.
Check out with the CBM / Barracks Duty before leaving.
Site locations & directions
MCB Hawaii — Kaneohe Bay
Main installation — barracks 1600-series, 5070/5071, 7000-series, 7220, 7241, 7256 & more
Camp H.M. Smith
Halawa Heights, Aiea — Bldg 402
Pu’uloa Range Training Facility
Ewa Beach — Bldg 300
Kaneohe Bay barracks map
Building locations for the serviced barracks. Distribution: DoW community only — do not share outside the team.