Hi,
I'm finally getting this macro to work with the Excel Solver Function:
Sub EthBal3()
'
' EthBal3 Macro
' Macro recorded 12/30/2005 by cabelkm
'
'
SolverOk SetCell:="$AF$5", MaxMinVal:=3, ValueOf:="0", ByChange:="$AA$5"
SolverSolve Userfinish:=True
SolverOk SetCell:="$AF$6"...
Hi everyone,
I need to calculate emission of contaminants or hazardous materials resulting from a crude oil tank leak. I've been given the following information:
1. Components that are suspected to be present in reportable quantities during the incident,
2. Volume of oil that leaked
3. Weight...
Hi everyone,
I'm working on reconciling a mass balance and I'm trying to set one of my flows to zero. I'm using the solver in Excel to do this, but I don't want to set my target cell to a max, min, or a typed-in value. I'm taking online data from our DCS system, so I want to be able to set my...
Hi everyone,
I'm working on a six sigma project for our cryogenic unit. I'm doing a mass balance around our unit with daily averages of flows and component concentrations. Because I'm doing it with daily averages, obviously I have to leave some room for error, but I have a question regarding...
Hi everyone,
I'm working on a six sigma project for our cryogenic unit. I'm doing a mass balance around our unit with daily averages of flows and component concentrations. Because I'm doing it with daily averages, obviously I have to leave some room for error, but I have a question regarding...
Hi everyone,
This is what I've been trying to do with an Excel Spreadsheet.
For the sake of this example, this is the model of my spreadsheet:
Column A contains categories such as "Pumps, compressors, etc..."
Column B contains costs for the different equipment.
I want to create an additional...
Hi everyone,
We run our coker feed tanks at around 385 ºF and we have vapors being generated with high H2S concentrations that cause odors. We have had odor complaints before, so we would like to address this issue. The tanks are atmospheric tanks that are nitrogen-blanketed. The vapors are...
I have a question that I come across a lot when I'm designing any system in general: how to determine design flows. Determining design pressures and temperatures can be straight forward by evaluating possible upsets to the process or if a fire case is neglected, but design flows, at least for...
Hey everyone,
I'm working on designing a vapor recovery system for three API 650 resid tanks that are nitrogen-blanketed. There are two existing tanks that have a system already and I'm checking my design basis against the existing one (they are the same exact tanks) and the flowrates differ...
Hi everyone,
I need to calculate the MAWP of an existing API 650 tank so I can start designing a vent vapor recovery system. and I'm looking at Appendix F of the API 650 code. I'm a process engineer, so when I got to Figure F-2 I got lost. So if we use the formula shown in section F.4.1...
Hey everyone,
I'm new in the flare world. Currently, we have a flare that is designed for using propane as the pilot gas, but is too expensive for us right now, so we'd like to change it to natural gas that our refinery already has. This is a flare for our docks, so it operates more on a...
Hey everyone!
I'm looking at a project for which the fuel gas to a heater may vary widely in BTU content, because of the PSA unit swings. Do you know of control loops for this type of swings? Is it a control loop based on a BTU analyzer? A control valve for the fuel gas?
Thanks in advance,
Hey everyone,
Right now, I need to design a caustic scrubber for our fuel gas. I already have the design flowrates for the gas, temperature, pressure, and H2S concentration. From that I calculated the amount of caustic needed, since the molar ratio of H2S to NaOH is 1:1 and then converted it...
Hey everyone,
I'm using Hysys to simulate a sulfuric acid network, do you know which thermo package is suitable for this type of system?
Thanks in advance,
Hey everyone,
I'm designing a control scheme at which I would like to "start" a pH controller after a level has been reached in the tank, since this is a semi-batch process. I won't be doing the loop drawings for the project, but I need to know whether this is feasible? Because I don't need...
Hi everyone,
I'm working on a project to achieve pH control of our storm sewer sump. As you know many streams are the source of waste water, but we have identified the main ones. I'm attempting to demonstrate that if we properly neutralize the largest source of water, then any pH fluctuations...
I have a question about designing control valves. When we're looking at three different scenarios: minimum, normal, and maximum, we take into account the different flows we want for those scenarios, but how about the pressure drop across the valve for each one? Do we set those? How do I know...
Hi,
I would like to know what type of control valve you would recommend for pH control? Equal percentage, linear, or quick opening?
I understand that equal percentage valves are the most common and provide good control for low flows. But, for my system, I wanted to add small amount of...
Hey everyone,
I'm a recent May graduate and have worked in my company since then including an internship last year.
I just wanted to know if when you first started as an engineer, you felt like you really didn't much have self-confidence? That's how I feel right now and sometimes very...
Hi everybody,
I have a question regarding orifice transmitter ranges. If you have a maximum dP range of 0-250 in H2O is there a common practice to design the plate so that the range is only 100 in H2O? In other words, would it affect accuracy if you instead range it for 175, 200, or even the...
