Please share your experience on how to construct a distillation CGCC using a worksheet like excel.

I suggest the following initial steps:
1- Do all the mass and heat balance stage by stage including condenser and reboiler.
2. Prepare a table in excel showing stage number, stage temperature, condenser and reboiler duties.
3. Extend the above table with the vapor and liquid enthalpies flows at every stage.
4. Apply the equations indicated in

[link Point to another website Only the registered members can access]
5. Is there here enough information to draw the CGCC?

Jota