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...
