Slide Presentation — Anders Deck (One-off)
Scope
One-off request from Anders Engnell (CF Chief of Staff) on 2026-04-24:
Can you help me visually condense this table so it's easier to read on a slide deck?
Source table: https://californiaforever.com/economic-impact/ — county-by-county jobs table (15 counties + total) we built during Phase II.
Target deck: CAJ_California Forever_Deck_Apr_2026 — slide 4
https://docs.google.com/presentation/d/1UpLOXXLgiLF1mNhWKgqqr3b5jZhqpOdSAKFBBtvjiHg/edit
Slide 4 already had a draft layout in place; our job was to rebuild it cleanly with live editable text + the county SVGs placed as images, matching the site's visual styling.
Status
- 2026-04-24: POC delivered to Eric in a standalone Slides file (not touching Anders' deck directly)
- 2026-04-24: Top-10 version + exported PNG sent to client per Anders' feedback
Deliverables sent to client
Archived on G&M Drive: https://drive.google.com/drive/folders/1_NF2Nx1EhmXnD7wYrEoORlN17gHezDai (Inside CaliforniaForever → "County Jobs Table — Slide Deck Asset (Apr 2026)" — includes a README doc explaining what the folder is.)
| What | Where |
|---|---|
| Standalone Slides (slide 1 = full 15 counties, slide 2 = top 10) | https://docs.google.com/presentation/d/1-x0ktVsAGnccsd5uR_ORFXij42i7IIHLl1uztdhALpM/edit |
| High-res PNG of top 10 table (no navy, just the card) | https://drive.google.com/file/d/1bEkXk_4ycB-BzvpZ2KMgTIzU_RpcbDuj/view (also local at ~/Desktop/CF-County-Jobs-Top10-Table.png, 2720×1312 @ 400dpi) |
| Folder README for the team | https://docs.google.com/document/d/1lRUXRMJEOJT38xlZszX3-EFRTmy_BIYuemgS0NBVcJY/edit |
| Anders' original deck (slide 4 target) | https://docs.google.com/presentation/d/1UpLOXXLgiLF1mNhWKgqqr3b5jZhqpOdSAKFBBtvjiHg/edit |
POC deliverable
URL (live, iterates in place): https://docs.google.com/presentation/d/1-x0ktVsAGnccsd5uR_ORFXij42i7IIHLl1uztdhALpM/edit
- 10" × 5.625" / 960×540 px (standard Google Slides 16:9 widescreen — matches Anders' deck)
- Native Slides table with editable cells (not a flattened image)
- County silhouette icons harvested from the CF theme (
/wp-content/themes/california-forever/img/counties/*.svg) and embedded as image objects per row - Matches live site: order, data, "Remaining statewide impact" row, Total row with 16,189 / 162,595
- Styling matches the theme: beige #FDF9E3 card, dune #CDCAB7 row separators, blue #417079 total border, navy #112D40 text, serif headers (Georgia / Milo Serif OT fallback), Outfit sans body
How this was built
Programmatic generation via Python + python-pptx → upload to Drive as PPTX → convert in place to Google Slides. Iterations use files.update PATCH against the same Slides ID so the URL never changes.
Local working directory: /tmp/cf-poc/
- build_poc.py — generator script (data, colors, table layout, icon overlay)
- update_slides.sh — one-shot: rebuild PPTX + patch existing Slides file in place
- counties/*.svg — 15 county SVGs harvested from the live site
- counties-png/*.png — SVGs converted via rsvg-convert (needed because python-pptx embeds raster, not SVG)
Slides file ID: 1-x0ktVsAGnccsd5uR_ORFXij42i7IIHLl1uztdhALpM
Anders' deck file ID: 1UpLOXXLgiLF1mNhWKgqqr3b5jZhqpOdSAKFBBtvjiHg
Open follow-ups if this goes further
- If Anders wants true SVG (not PNG) icons in the final, we'd need to insert them manually in Slides — python-pptx can't embed SVG natively. The 15 source SVGs are already in
/tmp/cf-poc/counties/. - Merced and Solano are NOT in this table (the site dropped them); if Anders wants them back in, we'd need SVGs for both (neither is currently in the theme's
img/counties/). - Fonts: Outfit is applied by name, but Google Slides may fall back if the Outfit font isn't enabled in the target deck. Milo Serif OT is not available in Slides — we use Georgia as the serif fallback.
Gmail thread
Subject: "Smaller Table of County Jobs across State for Slides"
Thread ID: 19dc05113c0c16f6
From: anders@californiaforever.com
To: eric@grainandmortar.com, brooke@grainandmortar.com