APEX Pro Services

MCBH Appliance Operations

Washer & Dryer Repairs, Swap-Outs & Installs ·
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

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.

Repair Emergency Install Swap 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.

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).
const keys=['mcbh-workorders','mcbh-assets','mcbh-parts',
  'mcbh-units','mcbh-counter','mcbh-mra-limits','mcbh-svc-rates',
  'mcbh-audit','mcbh-access-pin','mcbh-admin-pin'];
const backup={};
for(const k of keys){
  try{ const r=await DataStore.get(k);
       if(r) backup[k]=r.value; }catch(e){}
}
const blob=new Blob([JSON.stringify(backup,null,2)],
  {type:'application/json'});
const a=document.createElement('a');
a.href=URL.createObjectURL(blob);
a.download='mcbh-complete-data-backup-'
  +new Date().toISOString().slice(0,10)+'.json';
a.click();
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.

Service rates by work order type

Used to auto-calculate the billed total on each completed ticket (rate + parts used at cost). Update when option-year pricing changes. Never shown to techs.

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.

Replacement units in stock

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.
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.

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.
  1. Check in with the CBM / Barracks Duty on arrival at the building.
  2. Verify the serial number against the work order — the intake form autofills from the registry, so mismatches mean wrong machine or unregistered unit.
  3. 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.
  4. Check manufacturer warranty first on newer units (PWS 7.10) — the government is not billed for parts still under factory warranty.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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.
Kaneohe Bay barracks map
APEX Pro Services

MCBH Appliance Operations

Washer & Dryer Repairs, Swap-Outs & Installs
Checking access…