Task 3: Material balance

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

WRITE MY PAPER

Comments

Leave a Reply