Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Robbo1971
  • Order by date
  1. Robbo1971

    FIXTURE METHOD - WHICH IS BEST?

    screen shot two...http://files.engineering.com/getfile.aspx?folder=0aa1245e-297e-47e3-8de1-f66f2655c753&file=LIFTING_FRAME_-_FIXED_BOX.JPG
  2. Robbo1971

    FIXTURE METHOD - WHICH IS BEST?

    I have attatched to screen shots of a lifting frame I am working on... I am struggling on how to fix it? One screen shot shows it fixed through the lifting hole using a 'Fixed Geometry' fixture and a 'Distributed Mass' on top of the box section the other screen shot shows it with a 'Fixed...
  3. Robbo1971

    COSMOSWorks 2009 Chart Options

    yes, that is what I have done... but ideally I would like to show both the 'Yeild' and the '60% of Yeild'!
  4. Robbo1971

    Photoview 360 - Company Logo

    Having suceeded with the pure white background... is it possible to apply a company logo to one of the 'Enviroments'?
  5. Robbo1971

    Photoview 360

    Is it possible to be able to get a completely 'white' background? i.e without any shadows etc. etc.
  6. Robbo1971

    COSMOSWorks 2009 Chart Options

    When calculation the 'stress' of a part... our Company standard is to calculate the stress at 60% of the yeild! Is there a way of showing this on the chart as well as indicating the 'Yeild strength' which is shown as standard?
  7. Robbo1971

    Multi-Site SolidWorks with PDMWorks

    Does anybody have any suggestions for using SolidWorks on a Multi-Site set-up so everybody can use the same set of parts from the database? SolidWorks are pointing our company in the direction of PDMWorks Enterprise! any other suggestions?
  8. Robbo1971

    SCALE - CHANGING DIMENSIONS

    If you create a part model complete with dimensions... when you add a scale to that model, the dimensions stay as the dimensions before the scale! Is there a way to change the dimensions with the scale?
  9. Robbo1971

    SUM AND IF FUCTION?

    I want to add a percentage of a figure to a figure... =SUM(A1+(A1*(40/100))) If A1 = £10 then the answer would be £14. but the minimum figure I want to add on is £10, so the answer I require is £20. Therefore how can I write a statement which would calculate the original sum, but if it was...
  10. Robbo1971

    ROUNDING DOWN IN INCREMENTS OF 5

    How do I round down a number in an increment of 5? Example: if I have an aswser of £6.52... how do I round down to £5.00 or if I have a answer of £21.06... how do I round down to £20.00 I only want to use £5, £10, £15, £20 etc. etc. I am trying to create a spreadsheet for use when bidding...
  11. Robbo1971

    FLEX TOOL

    I am trying to use the 'FLEX' tool... I want to apply two flexes to a polyurethane disc representing the disc flexing inside a pipeline. The problem is the flex tool flexes from the centre point... can you flex about a given radius from the centre point?
  12. Robbo1971

    drop down combo list

    is it a 'Data Validation'? This can be found on the top menu under 'Data' then 'Validation'...
  13. Robbo1971

    Index, Match

    Excel 2002 I have a table of threads: M3 down to M10 I am using Index, Match to find specific information from the table relating to the thread for a calculation depending which thread I pick using data validation. If I have the threads listed in the table from M3 down to M10, the selection...
  14. Robbo1971

    adding a ROUND into an IF Statement

    thanks for that... another hidden command deep within Excel.
  15. Robbo1971

    adding a ROUND into an IF Statement

    Perfect... the answer was staring me in the face!!! Thanks
  16. Robbo1971

    adding a ROUND into an IF Statement

    the formula I am using is as follows: =IF(29.99>=G21,G21*(5.25/100),IF(599.99>=G21,(((G21-29.99)*(3.25/100))+1.57),(((G21-99.99)*(1.75/100))+(1.57+18.53)))) I have formated the cell to 'currency', but another formuala in another cell uses the answer... the answer is not to two decimal places...
  17. Robbo1971

    adding a ROUND into an IF Statement

    I am using an IF Statement to work out the cost of something... by doing this, it will work it out to umpteen decimal places (this messes up the spreadsheet to no end) and not the two decimal places required! Is there a way of adding a ROUND into the equation to get the two decimal places required?
  18. Robbo1971

    Fabricated Pipeline Wye Piece - 2

    I have managed to construct the 'Wye' in terms of putting two pipes together and putting the relevant holes through! What I am stuck on is generating the chamfers for the weld preperation... please take a look at the picture attached to see what I require! Thanks
  19. Robbo1971

    Fabricated Pipeline Wye Piece

    apparently this is 'TKY Joint'! anyone know anything about TKY Joints?
  20. Robbo1971

    Fabricated Pipeline Wye Piece

    it is the chamfering which is causing the issue, i.e for weld prep as we have to get this wye tested and approved which includes a welding procedure...
Back
Top