Overview
Part A — Excel (4 steps):
Step 1 fixes Task 3.1 — the biomass back-calculation with the actual numbers, so you can repair those broken reference cells manually.
Step 2 gives you the exact mol values for every downstream unit (HTS WGS → LTS WGS → CO₂ Remover → Methanator → Dryer → Haber-Bosch), with the formula used for each species so you can re-enter or re-link the cells properly rather than just hardcoding.
Step 3 shows how to scale everything up from the per-100-mol basis to actual plant-scale kgmol/day and kg/day flows.
Step 4 walks you through setting up Excel Solver correctly — the instructor specifically requires this.
Part B — Word (written section):
Covers exactly what to write for 3.1 and 3.2, the summary table format that fits the 2-page limit, all 8 assumptions you need to explicitly state, and the key equations the instructor expects to see.
At the end there's a checklist you can tick off before submission on 22 May. Let me know if you'd like help with any specific step. will upload other documents when assigned
CHECKLIST — Before Submission
Use this to verify Task 3 is fully complete:
3.1 — Biomass daily and annual requirement calculated and shown with sample calculation
Excel — All 9 unit columns filled with species mole flows (no #REF! or blank cells)
Excel — All values scaled up to kgmol/day and kg/day plant-scale flows
Excel — Solver set up, run, and result recorded
Excel — Overall mass balance closes (Σ in ≈ Σ out within ±1%)
Word — Section 3.1 paragraph written with sample calculation
Word — Section 3.2 summary table included
Word — All 8 assumptions stated with references
Word — Key equations listed
Word — Total Task 3 section ≤ 2 A4 pages, Calibri 11
References — All sources cited consistently