# Move-In Action List Workflow

## Task
Read the daily move-in spreadsheet and sync all changes to the live HTML action-list page.

## Spreadsheet Location
`C:\Users\gb105\OneDrive\shr1\100 Ward St\Move In\movein-daily-action-list.xlsx`

The spreadsheet is often open in Excel. Always read it by copying to a temp file first:

```powershell
$src = 'C:\Users\gb105\OneDrive\shr1\100 Ward St\Move In\movein-daily-action-list.xlsx'
$tmp = 'C:\Temp\movein-tmp.xlsx'
New-Item -ItemType Directory -Path 'C:\Temp' -Force | Out-Null
Copy-Item -Path $src -Destination $tmp -Force
# open $tmp with Excel COM, read, close, delete $tmp
```

## Spreadsheet Structure
- Row 1: version label (e.g. `Version v12`) in column C
- Row 2: date (col B) and quicklink labels (cols D–J)
- Row 3: column headers
- Rows 4–N: one action item per row

Columns per data row:
| Col | Content |
|-----|---------|
| A | Issue number |
| B | Date |
| C | Issue title |
| D | Status (`O` = Open, `C` = Complete) |
| E–L | Notes 1–8 |

## Output File
`cowork/movein-daily-issue-list.html`

Single self-contained HTML file — no external dependencies other than Google Fonts.

## HTML Structure
The page uses a card-based action-list layout with these key elements:

- **Header** — green bar with version and date (`Version vN · Mon DD, YYYY`)
- **Progress bar** — auto-calculated by JS from `data-done` attributes
- **Quicklinks bar** — ref links pulled from spreadsheet row 2
- **Action items** — one `.action` div per issue inside a single `.section` div
- **Footer** — repeats version and date

### Action item markup pattern
```html
<div class="action[ done]" data-done="[true|false]" id="issN">
  <span class="action-num">#N</span>
  <span class="action-date">M/DD</span>
  <div class="action-body">
    <div class="action-title">Issue title text</div>
    <div class="action-notes">                        <!-- omit if no notes -->
      <div class="action-note">Note text.</div>
      ...
    </div>
  </div>
  <span class="status-badge status-[open|done]">[Open|Complete]</span>
</div>
```

- Open items: `class="action"`, `data-done="false"`, `status-open`
- Closed items: `class="action done"`, `data-done="true"`, `status-done`
- Each item has `id="issN"` (e.g. `id="iss10"`) enabling deep-link anchors

### Anchor behavior (JavaScript)
When the URL contains `#issN`, the JS:
1. Adds class `linked` to the target item (yellow highlight, gold left border)
2. Hides `.action-notes` on all other open items (title-only view)

### Quicklinks
The quicklinks bar URLs are hardcoded in the HTML — the spreadsheet only provides the labels. Current URLs:

| Label | URL |
|-------|-----|
| Move In Calendar | `https://www.core3.com/AI/ward/ccw/calendar-606-onboard.html` |
| #606 Ref Pages | `https://www.core3.com/ward/ccw/` |
| Contact List | `https://www.core3.com/ward/ccw/606_contacts.html` |
| Floor Plan | `https://www.core3.com/AI/cowork/606_floor_plan.html` |
| Condo Insurance Overview | `https://www.core3.com/AI/cowork/insurance-coverage-overview.html` |
| Key HOA Folders | *(URL TBD — currently `#`)* |

## Update Workflow

1. Read spreadsheet (use temp-copy method above)
2. Diff against current HTML — identify every changed field: new notes, status changes, title edits, new items, version/date
3. Apply all changes with targeted `Edit` calls — do not rewrite the whole file
4. Bump version and date in three places: the `<!-- comment -->` header, the `<div class="sub">` line, and the `<div class="footer">` line
5. Commit and push (see below)

## Publishing
```bash
git add cowork/movein-daily-issue-list.html
git commit -m "Update move-in list - YYYY-MM-DD vN"
git push origin main
```
→ GitHub Actions deploys automatically to `https://www.core3.com/AI/`

## Verification
Live at: `https://www.core3.com/AI/cowork/movein-daily-issue-list.html`

Check the deployed version matches with:
```bash
curl -s https://www.core3.com/AI/cowork/movein-daily-issue-list.html | grep -o "Version v[0-9.]*"
```