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.

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.

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.

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.

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.
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.
CategoryAcknowledgeComplete
Routine service call1 work day5 work days
Emergency — received before 10amSame day2 work days
Emergency — received after 10am12pm next work day2 work days
New installation1 work day5 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.
  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
Tap the map to enlarge and zoom.
APEX Pro Services

MCBH Appliance Operations

Washer & Dryer Repairs, Swap-Outs & Installs
Checking access…
KANEOHE BAY BARRACKS MAP
Kaneohe Bay barracks map