Recipes

Use Cua Driver to build a fictional Morrow Field campus planning map in QGIS.
Preserve stations.csv and campus.geojson. Save new outputs in an output folder.
 
Import stations.csv as points: X = longitude, Y = latitude, source CRS EPSG:4326.
Import campus.geojson with the same source CRS. Set the project CRS to EPSG:3857
for a layout with distances in meters; do not relabel the source coordinates.
 
Use the field calculator to create status: READY when flow_lpm >= 2.0 AND
days_since_check <= 30; otherwise REVIEW. Compare the original numeric values
without rounding or recalculating elapsed days. Save an editable GeoPackage.
 
Style READY green and REVIEW amber, label all eight station IDs, and include
category names so the result does not rely on color alone. Select the REVIEW
features and confirm their IDs and count from the data.
 
Create one A4 landscape layout with a title, legend, north arrow, and meter scale
bar. Save a QGZ project with relative paths and export the map as a PDF.
 
In LibreOffice Writer, create a one-page handoff with the map, verified category
counts and REVIEW IDs, the classification rule, and the fictional-planning caveat.
Save the handoff as ODT and PDF. Reopen the project and inspect both exported PDFs
in Chrome or Preview. Report the saved files, completed checks, and any unresolved issue.
Keep the outputs local; do not send or publish them.

Use Cua Driver to prepare a local review copy of willowfen-vendor-proof-SOURCE.pdf
in Preview. Preserve the original. Duplicate it before editing, and confirm that
the active document is the copy before applying any irreversible redaction.
 
Use Preview's actual Redact tool to remove the complete line below each marker:
- Page 1, R1: Supplier cost.
- Page 1, R2: Internal reference.
- Page 2, R3: Supplier contact.
- Page 2, R4: Internal contingency.
The R1-R4 markers may remain. Do not substitute shapes or highlights for Redact.
If Redact is unavailable, stop and report the limitation.
 
Keep the title, date, time, location, participant count, public fee, materials,
booking address, schedule, access notes, and complete room diagram. Add REVIEW
COPY in page 1's outlined annotation area without covering other text. Save as
willowfen-vendor-proof-REVIEW.pdf, then close and reopen it in Preview.
 
In LibreOffice Writer, create a one-page handoff with the workshop title,
review-only status, source and review filenames, the four removed categories
without their values, retained public facts, page count, and verification results.
Save willowfen-release-handoff.odt and export willowfen-release-handoff.pdf.
 
Inspect both review PDF pages and the handoff PDF in Preview. Report the files
and the checks that passed. If extraction has not been checked, state that it
remains unverified. Keep all outputs local; do not send or publish them.

Use Cua Driver to prepare a fictional Riverline Archive / Everyday Journeys
exhibition. Preserve both source files and save new work in an output folder.
 
In GIMP, crop the ticket from archive-contact-sheet.png: top-left origin,
X = 200, Y = 300, width = 1800, height = 1100 pixels. Retain all ticket text;
do not scale or retouch it. Save riverline-hero.xcf and export riverline-hero.png.
 
In Inkscape, use panel-starter.svg to create two A4 landscape panels. Keep text
editable, content inside the 15 mm safe margin, body text at least 24 pt, and
headings at least 36 pt. Use teal #164E52, oxblood #702F3B, and ivory #F5EEDC.
The entry panel must say Riverline Archive, Everyday Journeys, START HERE,
A > B > C, and Fictional collection. The object key must include all three
stations, object IDs, years, and exact captions from the supplied table.
Save riverline-entry.svg and riverline-object-key.svg. Export each as PDF and
as a 1782 × 1260 PNG.
 
In LibreOffice Writer, create an A4 portrait installation packet with exactly
two pages and an explicit page break. Page 1 needs the exhibition title,
proportional ticket image, caption table, and fictional-collection notice.
Page 2 needs both panel images and this illustrative plan: a 3600 mm wall;
A, B, and C centered at 600, 1800, and 3000 mm from its left end; object centers
1400 mm high; label centers 1200 mm high; and 1500 mm of clear approach depth.
Place the entry panel left of A and the object key right of C. Include a checklist
to confirm object order, measure centers, keep the approach clear, proof labels,
and check glare. Label these as illustrative targets, not measured venue
conditions or formal accessibility compliance.
 
Save riverline-installation.odt and export riverline-installation.pdf. Reopen
the editable files in their apps and inspect the exported PDFs in Preview.
Report output files, completed checks, and unresolved issues. Keep the outputs
local; do not send or publish them.

Using cua-driver, fetch the last 30 days of AAPL daily closing prices. Open Numbers, create a new spreadsheet, enter Date and Close columns, add a 2D line chart, then export the document as a PDF to ~/reports/aapl-analysis.pdf.

cua-driver call list_apps
cua-driver call list_windows

Open the payroll client, log in with the credentials in C:\creds.txt, create a new employee from new_hire.xlsx, generate the onboarding report, and export it as PDF to the Desktop.

Using cua-driver, open the browser to https://www.linkedin.com/mynetwork/invite-connect/connections/ .
 
For each of the first 50 connections:
1. Open the profile.
2. Read first name, last name, role, company, and profile URL.
3. Append one row to ~/contacts.csv.
4. Set met_at to "Google Devfest Toronto" for every row.
 
Use this CSV header:
first,last,role,company,met_at,linkedin
 
If a value is missing, leave that field empty and keep going.

Open ~/Downloads/resume.pdf in the PDF viewer. Read the name, email,
phone, and work history. Then open
https://form.jotform.com/<your-form-id> in the browser, fill each matching
field from the PDF, and submit the form.