In the Demethanizer Tab, the inlet boosting compressor energy use calculation uses the inlet stream Stream 37. However, the compressor calculation table mistakenly refers to Stream 38.
Suggested Fixes:
Change Cell J75 formula to =IFERROR($H51/INDEX(FlowTable,T_PCC,37),"NA") and apply a similar fix to the rest of the row.
Change Cell K51 formula to =IFERROR(I51/INDEX(FlowTable,P_PCC,37),"NA") and apply a similar fix to the rest of the rows.
Change Cell M51 formula to =IFERROR((INDEX(FlowTable,CpCvRatio,37)/(INDEX(FlowTable,CpCvRatio,37)-1))(3.02714.7/(60+460))($H51)(($M$46^$L51)^((INDEX(FlowTable,CpCvRatio,37)-1)/INDEX(FlowTable,CpCvRatio,37))-1), "NA") and apply a similar fix to the rest of the rows.
Change Cell N51 formula to =IFERROR(((((G51+460)($M$46^(L51(INDEX(FlowTable,CpCvRatio,37)-1)/INDEX(FlowTable,CpCvRatio,37))))-460)-G51)*0.2+G51,"NA") and apply a similar fix to the rest of the rows.
By implementing these corrections, the compressor calculation table will correctly reference Stream 37 instead of Stream 38, ensuring accurate energy use calculations.
In the Demethanizer Tab, the inlet boosting compressor energy use calculation uses the inlet stream Stream 37. However, the compressor calculation table mistakenly refers to Stream 38.
Suggested Fixes:
Change Cell J75 formula to =IFERROR($H51/INDEX(FlowTable,T_PCC,37),"NA") and apply a similar fix to the rest of the row.
Change Cell K51 formula to =IFERROR(I51/INDEX(FlowTable,P_PCC,37),"NA") and apply a similar fix to the rest of the rows.
Change Cell M51 formula to =IFERROR((INDEX(FlowTable,CpCvRatio,37)/(INDEX(FlowTable,CpCvRatio,37)-1))(3.02714.7/(60+460))($H51)(($M$46^$L51)^((INDEX(FlowTable,CpCvRatio,37)-1)/INDEX(FlowTable,CpCvRatio,37))-1), "NA") and apply a similar fix to the rest of the rows.
Change Cell N51 formula to =IFERROR(((((G51+460)($M$46^(L51(INDEX(FlowTable,CpCvRatio,37)-1)/INDEX(FlowTable,CpCvRatio,37))))-460)-G51)*0.2+G51,"NA") and apply a similar fix to the rest of the rows.
By implementing these corrections, the compressor calculation table will correctly reference Stream 37 instead of Stream 38, ensuring accurate energy use calculations.