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
Leave a Reply
You must be logged in to post a comment.