Gemini 4, tested: is Google back?

I'm Helena Varga, an immigration attorney at Varga & Lindqvist Immigration LLP. I'm filing one case: five USCIS forms that go in together (the PDFs numbered 1 to 5). Also attached: my own profile sheet and the two email threads with my clients so far, each followed by the documents sent in it.

Fill in these forms from what I have, tell me what is still missing and who has to give it, then write the emails asking for it.

Do all of it in one go, without stopping to ask me anything: forms 1 to 5 in order, then the emails. If it is too long for one reply, put the whole answer in one Markdown (.md) file I can download instead, with the same headings and tables.

EACH FORM: start with a heading ## Form <number> — <form name>, then one table:

| Page | Item | Field | Value | Needed from | Available |

• Page: the page number in that PDF, starting at 1. Item: the form's own part and item number, for example Part 3, 2.a.
• Field: what a person would call it, for example Beneficiary's family name.
• Value: exactly what to write or tick on the form, in the form's own format (dates as MM/DD/YYYY; for a question with boxes, the option to pick). Leave it empty when you do not have it.
• Needed from: the one person who has to give this value, by name. Me for my own details and for the answers I decide as the attorney.
• Available: Yes if the value is in the emails or documents or follows from them; No if nobody has given it yet; N/A if the field does not apply to this case (it stays blank on the form); Sign for a signature or its date, made at signing.

List every field a person fills in, on every page, one row each (a Yes / No question is one row; Apt. / Ste. / Flr. with its number is one row). For a whole supplement or section that does not apply to this case, write ONE row instead: Page = its page range (for example 24-27), Field = its title, Available = N/A.
Where the sources disagree, use the newest and the most authoritative. Never use anything that belongs to another person, another company or another case.

THE EMAILS (at the end): start with the heading ## Emails. Write one email to each person I still need something from, and to no one else. Each has To:, Subject: and a body that asks only for what is still missing from that person, as a short list they can answer, and says what they will need to sign. Do not ask anyone for something I already have, or for something another person has to give.

I'm the Group Financial Controller at Valtren Group. Our CEO never paid much attention to the numbers, but the flash report says revenue is down 50% this quarter, he is furious, and he wants a full explanation in tomorrow morning's meeting. He doesn't care that I've had no time to prepare. If I can't explain it, I'm out.

Attached is everything I have, 10 files: the sales ledgers of FY26 (Q1 from our old system; Q2 and Q3, closed, and Q4 so far in one file: we are only 56% through Q4, day 51 of 91), plus the fiscal calendar with the FX rates, the customer master, the product catalog, the open-order backlog, the CRM pipeline, the contract register, the sales headcount roster and the EMEA deal-desk approvals. At the end of this message: FP&A's notes on every file and on how we report revenue, then three short documents pasted in full: Quality's memo on the Atlas X7, the Q3 board pack and our brand guidelines.

Build me ONE dashboard, as a single React component, that I can put on the screen in tomorrow's meeting. It has to look professional and be in our company's colours (see the brand guidelines). Keep it to one screen and just a few things:

1. Quarter by quarter: I click a quarter (Q1, Q2, Q3, Q4 to date) and see its summary (revenue, gross margin and whatever else matters) and, in plain words, what happened in that quarter and why.
2. This quarter, compared fairly: Q4 is only 56% done, so compare every quarter at the same point in time (Q4 against each earlier quarter and against the average of Q1–Q3 at the same day), with one chart of all four quarters' cumulative revenue by day of the quarter.
3. Exactly why revenue fell: every cause, with its dollar impact, adding up to the drop.
4. The prognosis: where Q4 will land, and what we have to do to fix it, with the numbers.

Every number has to be calculated correctly from the files, in USD. It has to be clear and easy to click, with nothing cluttered.

FP&A'S NOTES ON THE FILES (Valtren Group FP&A, 6 October 2026)

WHAT IS IN THE PACK (10 files)

1. Sales_Q1_old_system.csv
   Q1 FY26 billing lines from the LEGACY ERP (6,007 rows). Different layout: see below.
2. Sales_Q2_Q3_Q4.csv
   Q2 and Q3 FY26 (closed) and Q4 FY26 to date (days 1–51, to Tue 6 Oct 2026): invoice and credit-note lines from the new ERP (15,130 rows: Q2 6,243 · Q3 6,039 · Q4 2,848). Fiscal Quarter says which.
3. Calendar_and_FX.csv
   The fiscal calendar, one row a fiscal period (quarter, dates, weeks, days of the quarter, status), with Treasury's period-average exchange rates P01–P11 (units of currency per 1 USD); the last row is the FY26 budget rates.
4. Customers.csv
   Every customer: region, segment, channel, parent group, intercompany flag, account owner, legacy number.
5. Products.csv
   Every SKU: product line, family, list price and standard cost (USD), legacy material number, lifecycle.
6. Open_orders.csv
   Open sales orders not yet shipped or invoiced, as of 6 Oct. USD THOUSANDS.
7. CRM_pipeline.csv
   CRM opportunities (Q3 and Q4): stage, probability, close date, loss reason, competitor.
8. Contracts.csv
   Major customer contracts: type, value, recurring or not, status, notice dates.
9. Sales_team.csv
   Every sales employee: role, region, hire and leave dates, where leavers went (when known).
10. EMEA_discounts.csv
    EMEA deal-desk approvals: every discount approved above the standard maximum.

Pasted after these notes: Quality's memo on the Atlas X7 (QI-2291), the Q3 board pack summary and the brand guidelines.

THE FISCAL CALENDAR

• FY26 runs from Monday 17 November 2025 to Sunday 15 November 2026: four 13-week quarters of 91 days, each split 4-4-5 weeks into three fiscal periods (P01–P12). Calendar_and_FX.csv has every period: its dates, weeks and days of the quarter.
• Q1 = 17 Nov 2025 – 15 Feb 2026 · Q2 = 16 Feb – 17 May 2026 · Q3 = 18 May – 16 Aug 2026 · Q4 = 17 Aug – 15 Nov 2026.
• Q4 is open. The Q4 extract runs to Tuesday 6 October 2026, which is day 51 of 91 (56% of the quarter).

HOW GROUP REPORTS REVENUE

• Net revenue = invoices minus credit notes, to EXTERNAL customers only. Sales to Valtren's own subsidiaries (Intercompany = Y in the customer master) are eliminated on consolidation and are not revenue.
• Only posted lines count. Status = VOID (new ERP) and Cancelled = X (legacy ERP) are void documents kept in the extracts for audit.
• Everything is reported in USD. Convert each line at the AVERAGE RATE OF ITS FISCAL PERIOD from Calendar_and_FX.csv. Rates are quoted as units of currency per 1 USD, so USD = local amount / rate (USD lines need no conversion). P11 is the average to date (to 6 Oct). The budget rates (its last row, FY26 budget) are only for local price lists.
• Gross margin = (net revenue - standard cost of the units sold) / net revenue, with the standard cost per unit from the product catalog (USD). A credit note with a negative quantity is a return and reverses its cost; a credit note with quantity 0 is a price adjustment and carries no cost.

THE EXTRACTS

• Q1 comes from the LEGACY ERP. We moved to the new ERP on 16 February 2026, the first day of Q2. The legacy layout differs:
  · customers are legacy numbers (Sold-To (legacy)) and products are legacy material numbers; the customer master (Legacy
  Customer No) and the product catalog (Legacy Material) map them;
  · Billing Type F2 = invoice, G2 = credit memo. Legacy credit memos carry POSITIVE values and quantities: subtract them;
  · Cancelled = X marks a cancelled document;
  · Net Value USD (budget rate) converts at the FY26 budget rate. Do not report it: convert Net Value (doc curr) at the period-average rate, as for every other quarter. In the new system a line is identified by Billing Doc + Item (its Line ID); in the old system every line is its own line, since its document numbers repeat across customers.
• Q2 to Q4 come from the new ERP, in one file. Doc Type INV = invoice, CRN = credit note (already negative). Fiscal Period and
  Fiscal Quarter are on every line.
• Q2: the P05 APAC lines were exported twice when the interface was re-run after the cutover fix: 236 lines appear twice.
  Line ID is unique, so count each Line ID once.
• Region, country and segment are not on the ledgers: join Customer ID to the customer master. Product line and family are not on the ledgers: join SKU to the catalog. The Sales Rep on a ledger line is the account owner when the line was billed.

THE OTHER FILES

• The files are CSV (UTF-8, comma-separated, dates as YYYY-MM-DD). Columns named ... % hold percentages as numbers: 12.5 means
  12.5%. Amounts in local currency (LC) are in the line's Currency.
• Open orders (backlog), as of 6 October: external customers only, valued at order-date rates, in USD THOUSANDS. Hold code QH-2291 is the quality hold on Atlas X7 (see the
  QI-2291 memo); CH is a credit hold; CR is a delay the customer asked for.
• Sales roster: who left, when and (if known) where to. The customer master shows the owner the CRM has: accounts are not reassigned automatically when a rep leaves.
• CRM pipeline: amounts are deal estimates, not booked revenue.
• Contract register: whether a contract recurs, and any notice given.
• EMEA deal desk: every discount approved above the standard maximum, with the reason.

THE THREE DOCUMENTS (pasted in full)

1. QUALITY'S MEMO: INCIDENT QI-2291, ATLAS X7 STOP-SHIP

Quality & Reliability · Update 4 · 2 October 2026 · From: Ingrid Vos, VP Quality · To: Executive Committee, Group FP&A, Sales leadership

What happened

• Atlas X7 edge gateways running firmware 4.2.0 shut down under sustained load above 45 °C ambient. The first field reports came in during late July (Q3); by mid-August the failure rate on units shipped in Q2–Q3 was 3.8%.
• Stop-ship from Tuesday 25 August 2026 (Q4 day 9). No Atlas X7 unit has shipped or been invoiced since. All X7 SKUs are affected (STD, 5G, LTE, RUG, PRO); X5 and X9 are not.
• Orders are still accepted and are placed on hold code QH-2291 in the order book. Nothing on hold has been invoiced.
• Field units: RMAs are authorised for affected units shipped in Q2 and Q3. Returns are credited at the original invoice price (credit notes referencing QI-2291) and posted in Q4.

Fix and release

• Firmware 4.2.3 with a revised heat-spreader passed lab validation on 29 September. A field pilot at three customer sites ends on 13 October.
• Target release of the hold: Thursday 15 October 2026 (Q4 day 60), subject to the pilot results. Engineering rates the date as likely; a slip would be by one to two weeks.
• Once released, Operations can ship the held orders within about three weeks (capacity roughly $120 million a week across the three plants).
• Sales expects about 80% of the held orders to ship in Q4. Around 20% are at risk: customers asking to cancel, pushing delivery into next quarter, or evaluating Vantorr and Quellmark gateways.

What we need from ExCo

• Approve expedited freight for the held orders in the two weeks after release.
• A goodwill credit framework for the customers with the largest held orders, to stop cancellations.
• Sales to call every customer with an order on QH-2291 before 15 October with the release date.

The order book on hold QH-2291 is in the open-order report (Open_orders.csv). Values there are in USD thousands.

2. THE Q3 FY26 BOARD PACK SUMMARY

Prepared by Group Finance for the Board meeting of 20 August 2026 · Quarter: 18 May – 16 Aug 2026

Headlines

• Revenue of about $3.1 billion, a record quarter, up 18% on Q2.
• The quarter includes the Port of Kessvik Smart Port Phase 1, a one-time turnkey project (contract K-2026-0117) billed in eight milestones and completed on 12 August. No Phase 2 has been contracted.
• Atlas X7 keeps ramping and is now the largest single product family.
• Gross margin in line with the first half.

Risks the Board should know about

• Hoshizora, our distributor in Japan, served notice on 28 July and is moving its industrial-IoT distribution to Vantorr. Last orders accepted to 16 August. Sales is looking for a replacement channel in Japan.
• North America sales attrition: a group of enterprise account executives resigned between June and August and joined Quellmark Systems. Backfills are being recruited; their accounts are covered by sales directors in the meantime.
• EMEA pricing: Vantorr has cut sensor and controller prices by up to 20%. The deal desk is approving price matches case by case.
• Atlas X7: field reports of thermal shutdowns on firmware 4.2.0 since late July. Engineering is investigating; no shipment impact so far.

Outlook

Q4 is guided to be broadly in line with Q3 excluding Kessvik, with X7 continuing to grow. The guidance assumes no further loss of distribution in APAC.

3. VALTREN BRAND GUIDELINES 2026

For every document, slide and dashboard that leaves Finance. Issued by Group Communications, January 2026.

Colour

Seven colours, no others. Navy and white carry the page; Signal Orange is the highlight and appears once or twice per screen, never as a background for large areas.

• Valtren Navy #12263A: Primary. Headers, titles, the wordmark, the main series in charts (prior periods).
• Signal Orange #F26B1D: Accent. The one thing to look at: the current period, the headline number, a call to action. Use sparingly.
• Glacier Teal #1F9AA8: Secondary series in charts, links, selected states.
• Slate #5B6B7B: Secondary text, axes, gridlines (at 25% opacity).
• Mist #EEF2F5: Backgrounds of panels and cards. Pages are white or Mist.
• Pine #2E8B57: Positive variance, on-track status.
• Ember #C8102E: Negative variance, risk, off-track status.

Type

Inter (Google Fonts) for everything on screen; Helvetica or Arial when Inter is not available. Titles 600–700 weight in Navy; body 400 in #1D2733; numbers tabular. Never more than three sizes on one screen.

The wordmark

VALTREN in capitals, Inter Bold, letter-spacing +8%, Navy on white or white on Navy, with a 2px Signal Orange rule beneath it in headers. Do not recolour, outline or stretch it.

Charts and dashboards

• The current period is Signal Orange; earlier periods are Navy, Teal and Slate, in that order of importance. Targets and benchmarks are dashed Slate lines.
• Good is Pine, bad is Ember — for variances only, never for decoration.
• Money in USD with the unit on the label: $2.4B, $310M, $12.5K. Percentages to one decimal place.
• White or Mist backgrounds, cards with 12px radius and a 1px #DFE4EA border, no drop shadows heavier than 0 2px 8px rgba(18,38,58,.08).
• One message per chart, written as its title (Q4 is tracking 50% below Q3 at the same point), not a label (Revenue chart).
• Board material: no more than one screen, the conclusion first, the detail one click away.