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
