Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. OilBoiler

    How to repeat functions in Excel Solver (using Macros)

    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"...
  2. OilBoiler

    How to calculate emissions from crude oil tank leak

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

    Excel Solver: Set target cell to a cell reference instead of a value

    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"...
  4. OilBoiler

    Excel Solver: Set target cell to a cell reference instead of a value

    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"...
  5. OilBoiler

    Excel Solver: Set target cell to a cell reference instead of a value

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

    Adjusting Mass Balance Errors

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

    Adjusting Mass Balance Errors

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

    Adjusting Mass Balance Errors

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

    Lookup multiple values in Excel

    Yes, the SUMIF works great. I didn't know about array formulas. Thank you so much!
  10. OilBoiler

    Lookup multiple values in Excel

    Yes, that would be good.
  11. OilBoiler

    Lookup multiple values in Excel

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

    Coker Feed Tanks (heavy hydrocarbons) Odor Control

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

    Determining Design Flow Rates in General

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

    Tank Vapor Vent Flow Rate Calculations

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

    Tank Vapor Vent Flow Rate Calculations

    ...water, so I guess we convert this to absolute pressure to be used in the ideal gas law? According to this I have: lbmoles/min = ((0.04+14.7 psi)*122 ft3/min)/((10.73 psi ft3/lbmole R)*(385 F+460 R)) = 0.2 lbmole/min I convert it to standard volume = 0.2 lbmole/min*379 ft3/lbmole = 75 SCFM...
  16. OilBoiler

    Tank Vapor Vent Flow Rate Calculations

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

    Tank Vapor Vent Flow Rate Calculations

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

    Calculating MAWP of API 650 Fixed Roof Tank

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

    Pilot Gas Calculation for Flare

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

    BTU/Pressure Swing Control

    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,

Part and Inventory Search

Back
Top