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: *

  1. rnordquest

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

    Most of you should have read the post, not just the title. I said it was cancelled long ago and even provided the date. And I said it wasn't worth purchasing something so old. I'm sure IHS wants me to buy one. It wasn't in the customer IHS collection. We are determining whether or not it is...
  2. 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
  3. rnordquest

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

    Wrong doc? Hardly. What test spec do you think is used for Salt Fog testing of landing gear or cold temp testing for a flap actuator? Virtually everything that moves on an aircraft has some sort of electrical sensor to tell of it's position. This is no different. I don't want to learn about...
  4. rnordquest

    Spin Wheels Before Landing

    ERAU82 - The automatic braking systems out there can be set to apply a selectable percentage of braking power upon landing and thereby eliminate LH-RH brake wear differences, at least as caused by the pilots.
  5. 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...
  6. rnordquest

    Weird Excel Format Problem

    handleman, The code worked fine but had a problem converting something that ended up displaying as a "?". I added a few lines to detect that and replace it with a space. Thanks, Roger
  7. rnordquest

    Weird Excel Format Problem

    What wise men you are. Yes we're in Japan and it was a hassle for the company to get something set up for us. It must be a two op system problem. I'll try the code. Thanks, Roger
  8. rnordquest

    Weird Excel Format Problem

    I sort of anticipated that I would have to do that so here it is. I uploaded a file called Excel Problem.xls and it shows as an attachment but I don't see anything when I preview post to indicate it. Hopefully you'll be able to find it. OK, what I did was copy the url from the Step 3...
  9. rnordquest

    Weird Excel Format Problem

    A font change to the cell only changes the "Assy" part. The problem is the bad stuff font is the same as the good stuff font. If I change "Adaptor" to a different font and then back to the same font as "Assy" I still have the same problem, i.e. it goes back to the original problem.
  10. 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...
  11. rnordquest

    Easy Excel, now()

    Thanks. It was the d-quotes that I didn't know.
  12. 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
  13. 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
  14. rnordquest

    Excel Help

    Put this in another cell like b1 =if(a1="dog",1,"") then do a sum Now if you just want to count the number of cells with dogs then you could use COUNTIF =COUNTIF(A1:A5,"dog") You can nest 7 IF statements so doing your % good and bad can easily be done...
  15. rnordquest

    Excel Format

    You are correct; the number of points is always positive. One line or two won't have much effect on processing time for the few thousand lines I have to process but less lines is usually more better in my book. I'll just comment one method out so I can keep both methods. Someday when I'm...
  16. rnordquest

    Excel Format

    TYVM Roger
  17. rnordquest

    Excel Format

    Holy crap batman. Do you mean I just thought of a basic simple format that Bill Gates didn't? Wow, all of that just to put a value in a certain spot. Thanks.
  18. rnordquest

    Excel Format

    Nope, it doesn't work. I4 is how you write out an integer right justified in a field 4 spaces wide. If tpts = 89 then examples for I4 and I7 are 123456789 89 (I4) 89 (I7) What I need is the = sign in space 20 and tpts to look like this: ...= 89 ...= 5 ...=167
  19. 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
  20. rnordquest

    Gas/Hybrid, Diesel, Diesel/Hybrid, Fuel Cell - where will it end?

    ASEI, you'd only need 100,000 sq mi of concentrated solar to generate the power you need. That's not even a major portion of TX. I'm not talking PV panels. The efficiency of collecting heat is much higher than PV panels right now and it's easier to store heat through the night than...

Part and Inventory Search