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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by OilBoiler

  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

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

Part and Inventory Search

Back
Top