Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross 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: *

  • Users: rnordquest
  • Content: Threads
  • Order by date
  1. rnordquest

    How do I get a copy of MIL-I-8776B?

    MIL-I-8776B was cancelled in 1981. How do I get an online copy? It's referenced in a customer document and I want to see how important it is. It's certainly not worth paying to see a doc cancelled 3 decades ago. Thanks, Roger
  2. rnordquest

    DO-160F Crash Safety, Apply Landing Gear Pin Load to Uplock?

    DO-160F, Sect 7.3 says - During the impulse tests...an equivalent weight may be substituted for electrical-mechanical components normally mounted within or on the equipment case. My question is - Would the landing gear pin load on the uplock need to be considered or should you just apply the...
  3. rnordquest

    Weird Excel Format Problem

    This cell was copied from one Excel sheet to another. The original was all in the font used for "Assy". How did only part of it get changed and more importantly how to change it back? Copy format doesn't work. Grease ????????Assy, FWD If I delete the "Adaptor" part and start typing in its...
  4. rnordquest

    Easy Excel, now()

    ="Date Printed: " & now() gives text and serial number = now() gives date and time i.e. 5/9/2009 10:36 How do I format the text equation to give me this: Date Printed: 5/9/2009 10:36
  5. rnordquest

    Pipe thread torque spec

    Does anyone have pipe thread torque spec? I'm looking for something other than finger tight plus X turns. Thanks, Roger
  6. rnordquest

    Excel Format

    How do I get this to work? ActiveCell.Value = "NPTS = " & format(tpts, i4) I want the I4 to be like a fortran I4 format, i.e. right justified
  7. rnordquest

    Macro to Reverse Order

    I want to reverse the order of each section and tried this. What did I do wrong? ' Reorder each section Range("B4").Select npts = ActiveCell.Value Do Until npts < 1 ActiveCell.Offset(1, -1).Activate sRow = ActiveCell.Row For n = 1 To npts x(n)...
  8. rnordquest

    Excel VBA Circle from 3 Points

    I have points (x,y,z) around an airfoil from a measuring device. It uses a ball to touch the surface. My xyz points are from the ball center. I need a macro to calculate the actual surface. How do I do it? I was thinking of taking 3 points to get a circle, then get a line from the middle pt...
  9. rnordquest

    Excel Text Date to Real Date

    How would I reformat a text date to make it a real date? It's in the form 14May2008 right now but in a plot it's just 1 and the next date is 2.
  10. rnordquest

    Jet A LHV

    I think this is a better forum than where I first posted. Does LHV for a tank of Jet A change with time? If so, how much? What LHV accuracy should I expect when I send a sample to a lab to be tested? We get LHV value when the fuel is delivered and we check it once a month. Would we be...
  11. rnordquest

    Jet A LHV

    When I receive a load of Jet A with a particular LHV does that value remain constant? If not, how much does it change with time? What is the accuracy of a LHV test?
  12. rnordquest

    Extract from Filename - Excel

    I need a macro to extract a number from the filename to use in it's calculation. Some measuring machine is programmed to return x-y coordinates at a constant cutting plane z with the z given in the filename. I need to transform the coordinates and output x-y-z. Here are examples of the...
  13. rnordquest

    Copy Chart

    I copy an embedded chart from Excel 2003 to Word by selecting the underlying cells then ctl c, paste special, Picture(enhanced metafile). Now for the 1st time in a year when I paste I get the cell gridlines. It's from this file only. The other files I copy from don't have the problem. I...
  14. rnordquest

    Magnificent VBA Writers

    I need an Excel macro that will take data in the following form, put a 2nd order curve thru it, evaluate curve at a given X and return Y: 261.5 276 286 303.5 72.2 76.4 79 84 I have many lines of data hence the need for the macro. Thanks, Roger
  15. rnordquest

    Excel Open

    How would I get a macro to open all the files in a folder? I want to open, process, close, repeat. There are 400 files so I don't want to be typing the filenames in by hand.
  16. rnordquest

    Cleared Chart Legend - How to Get it Back?

    Once I've cleared an Excel data series chart legend entry, how do I turn it back on?
  17. rnordquest

    Excel Row Select in VBA

    This works by hand and is the same as the macro recorder but it doesn't work when I try to use it. Range("EG3").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlDown)).Select The rows are filtered and the first group of rows is blank which is...
  18. rnordquest

    Open Text File with Excel Macro

    I need a macro to open the following text file in probably Fixed Width format to get data into separate aligned columns. My problem is that I don't want to have to individually adjust the fixed width for each of the 400 or so files I want to process. The example shows only the first 2 of 6...
  19. rnordquest

    Excel Curve Fit Coefficients

    How do I access the curve fit coefficients? For example, I want to curve fit a 2nd order polynomial to a set of data and display the coefficients in separate cells then evaluate the curve fit at a defined X value (say cell B5); i.e. y = A5*B5^2 + A6*B5 + A7. So how do I extract the...
  20. rnordquest

    Accelerate Stop Spreadsheet

    Does anyone have a spreadsheet that calculates the Part 25 (and 23) aircraft accelerate stop distance? Thanks, Roger

Part and Inventory Search