Видео

Absolutely!

The cell referencing shifts when you copy in Excel. So, if, for example, you copied cell C8 that contains the equation =AVERAGE(C3:C4), and pasted this into C9, the equation would shift down one row to read =AVERAGE(C4:C5). Since we copy two rows down it changes to AVERAGE(C5:C6), which matches where the replicate data is located. Extra info: If you want to lock cell referencing, you can use the $ symbol. By typing =AVERAGE($C$4:$C$5), this would keep the equation referencing cells C4 to C5 regardless of where you copied it. You can also lock just the column ($C4) or just the row (C$4), depending on your needs.

@@rebeccaong2820 Good to know! At first for time 0 I tried to do my 3 replicates and then copy all the code across, however, it didn't give me averages (I didn't have a gap, I just had all averages stacked together hence why I asked)

That's great! Best of luck on your exam!

Yes - you can use shape data (4:00) to specify parameters for pipelines and equipment. There are some built in fields depending on the shape, but you can also make custom fields. There are instructions for how to do this here: support.microsoft.com/en-us/office/add-data-to-visio-shapes-09272394-5243-4e1b-bcfa-425a8b4d1ce2

@@cinnamonfern thanks a lot

There are instructions for adding custom fields here: support.microsoft.com/en-us/office/add-data-to-visio-shapes-09272394-5243-4e1b-bcfa-425a8b4d1ce2 I hope this helps!

You can draw the flowchart for a material and energy balance problem, and you can assign masses and enthalpies to streams, however I would not recommend using Visio to run the calculations (I don't even know if this is possible). Visio is a flowcharting software, not a process simulator so it is not really designed to run calculations. I would recommend either exporting a stream table with the data from Visio into excel (assuming you added this to the streams as material properties), or just manually input the data into Excel, skipping Visio entirely. Then run your calculations in Excel.

@@rebeccaong2820 Thank you so much for your response, that's what I managed to do and by using some flowcharting software add-in to excel it has become an easier process. However, I was just hoping to exploit Visio's diagramming capabilities in chemical engineering applications & problems instead of referring to the ordinary way to do this via Excel or Aspen Hysys or Plus, and so on. But thank you again for your answer. Appreciated!

Great! Hopefully it helped! Feel free to come say hi when the university reopens. :)

Eventually I'd like to! Maybe in a few months when I'm less busy. Anything you'd like to see?

I don't at the moment - sorry! But the principles are the same. You just use different templates to add specific pieces of equipment or instrumentation.