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...
I tried it again, but now it's giving me the error on "SolverOK" and it says that the Sub or function is not defined :(
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 12/09/2005 by cabelkm
'
'
SolverOk SetCell:="$Q$5", MaxMinVal:=3, ValueOf:=Range("F5").Value, ByChange:="$AA$5"...
Thanks yakpol,
I'm not really familiar with macros, so I recorded it and tried to edit it and this is what I had:
Sub MassBal()
'
' MassBal Macro
' Macro recorded 12/09/2005 by cabelkm
'
' Keyboard Shortcut: Ctrl+Shift+M
'
SolverOk SetCell:="$Q$5", MaxMinVal:=3, ValueOf:="143127"...
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...
This is a cryogenic unit - we feed fuel gas (mainly made up of C1, H2, C2, and traces of some heavier components to C4+). We have orifice flowmeters for our inlet and outlet gas streams as well as our liquid stream. We measure mole compositions on inlet and outlet gas streams and only C2 on...
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...
PAN,
All five tanks: the two that already have the vapor recovery system and the other three I'm designing a new system for, have nitrogen blanketing already. I have the design basis they used for calculating the nitrogen needed for blanketing and it refers back to Table 2 in API 2000. All of...
Thanks for your feedback!
The N2 regulator failure has already been considered for sizing the pressure vents that already exist at the tanks.
I need to check my calculation for design flowrate, because I have second thoughts: The maximum flow I can have either in or out of the tanks is 910...
Art,
Sorry for the confusing description. We are not retrofitting into the existing vapor recovery system for the other two tanks (We have five tanks in total). The existing system for those two tanks will remain independent and I'm designing a system from scratch for the other three tanks...
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,
