No, there is just the "3%" rule, see API 520. 70% of sonic is way too high.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
Just use a valve operation.
Your inlet stream is fully specified: composition, temperature, and pressure. The outlet stream pressure should be specified at the 90% value, the temperature will be calculated. The flow rate is not important, so just pick a number.
Make sure you use a steam property...
Since we're off on a tangent, here are two more solutions to the problem, one using DGET, and one using a pivot table.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of...
Yes, works if you have Excel 2007. Otherwise, it becomes very cumbersome.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
Use a Pivot table. No VBA required.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.http://files.engineering.com/getfile.aspx?folder=05eda52d-9a48-484a-af2b-258adb5ea48e&file=Pivot-example.xls
Not that I know of.
You may consider putting the =TEXT(A1,"0.0") in one cell, and x B2 in the cell just to the right of it. Then you can format B2 whichever way you want.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
Couple of thoughts:
- you may have Window/Freeze Panes on
- did you try copying everything to a new sheet?
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
You can accomplish the same using the Workbook_SheetChange event in the ThisWorbook module.
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox ("You changed " & Sh.Name & " cell " & Target.Address)
End Sub
Cheers,
Joerd
Please see FAQ731-376 for tips on how...
You wrote a nice replacement for the Replace method. The short version is:
strATextValue = Replace(strATextValue, vbLf, vbCr)
Modify as needed, it's pretty flexible.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
In Word, a new line is entered using Selection.TypeParagraph. So you will have to split up the Excel cell value at vbLF (or chr(10), it's the same), and then use
Selection.TypeText Text:="first part"
Selection.TypeParagraph
Selection.TypeText Text:="second part"
So your code...
You can set up a database query instead.
Go to Data/Import External Data/New Database Query... and link to the spreadsheets. It helps if the source spreadsheets have range names defined for the exported data.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
The spreadsheet is linked to a spreadsheet "Bearing .xls", which I don't have, but it tries to open it. So, if that links to several other files, and they automatically open, you get what you observe.
Check the list of links under the Edit menu, option Links...
Cheers,
Joerd
Please see...
Instead of
For Each ThisDataLabel In ThisSeries.DataLabels
ThisDataLabel.Delete
Next ThisDataLabel
try
ThisSeries.HasDataLabels = False
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
To add to this: if you ever decide to try VBA, be aware that LOG is the natural logarithm in Visual Basic.
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
@mortenA
This may be helpful: an up-to-date dictionary for Excel 2007 functions with 14 languages:
http://www.piuha.fi/excel-function-n...languages.html
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
You can only do it if you write your macro to be a user-defined function (Function instead of Sub)
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
This is not an Excel / VBA issue, but a numerical issue. Your function is not continuous, but it will give the same answer for fractions of years. In order for Solver to determine the minimum, it will try to determine the gradient at a certain value of the independent variable (time, in your...
