Search results for query: *

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.

=INDIRECT("B4") 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...

Did you look at http://maxima.sourceforge.net/compalg.html Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

guess what, the Windows calculator also gives 0.280719441343584 Cheers, Joerd Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.