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!

Recent content by PaycheckSlave

  1. PaycheckSlave

    VB for WinCC question

    Have you defined the variables in the appropriate section in WinCC? ' WINCC:TAGNAME_SECTION_START Const TagNameInAction = "Dummy" Const TagNameInAction = "Test" ' WINCC:TAGNAME_SECTION_END -Joe
  2. PaycheckSlave

    Linear regression analysis for y = ax +b

    Hello Dandalf, The correct method for comparing two sets of values that should be the same on a point-by-point basis is with a paired T-test. This can be accomplished in Excel through Tools-->Data Analysis. Comparing the two columns on an X-Y plot is very useful for flagging outliers, and for...
  3. PaycheckSlave

    Either simple or impossible...

    KevinNZ is right, it works with conditional formatting. Highlight the column you want formatted. Choose “Formula Is” and use =(MOD(ROW($A1),2)=0) as the formula.
  4. PaycheckSlave

    SORTING a Worksheet With Merged Cells Not Same Size

    macajm, I'm not claiming this is the best way, but I have the following macro in my PersonalMacrosWorkbook. Sub CenterAcrossSelection() With Selection .HorizontalAlignment = xlCenterAcrossSelection .VerticalAlignment = xlBottom .WrapText = False...

Part and Inventory Search