Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep 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: Denial
  • Content: Threads
  • Order by date
  1. Denial

    Entering a non-breaking space into a post

    There is a question that has been bugging me since the recent new-format Eng-Tips landed on me with an unexpected THUMP. Under the old Eng-Tips, we could include a non-breaking space in our text using "[ ]". Under the new system that text string is uninterpreted, and appears as its raw...
  2. Denial

    Non-breaking spaces and hyphens

    This forum might be able to answer a question that has been bugging me since the recent new-format Eng-Tips landed on us with an unexpected THUMP. Under the old system, we could include a non-breaking space in our text using "[ ]". Under the new system that text string in uninterpreted...
  3. Denial

    Display of the time when a time is posted

    With the old Eng-Tips, all times generated by "the system" were displayed in UTC. Now (I think) they are all displayed in the viewer's time-zone. This has some advantages, but it also has some disadvantages. In an active thread, some contributors can have a large number of different posts...
  4. Denial

    Early alternative to ISFORMULA() function

    I am looking for a way to detect whether an Excel cell contains a numerical value or a formula that returns a numerical value.[ ] In later versions of Excel the ISFORMULA() function would do exactly what I need, but this function is not offered in the version I am using (2010).[ ] I...
  5. Denial

    Determining a running Fortran program's "residence directory"

    As my recent posts on this forum attest, I am trying to get an old Fortran program to run on a modern Windows computer.[ ] Progress is slow but steady. However I have struck an "interesting" little problem.[ ] My program's *.EXE file will reside in a directory that will be chosen by...
  6. Denial

    Gfortran's .dll files

    Three days ago I posted a query about Fortran compilers on this forum, and as a result I successfully installed the gfortran compiler on my Windows-10(Home)-64bit computer.[&nbsp;] While I have not yet begun compiling my <irony>magnum opus</irony>, I have successfully compiled and run a few...
  7. Denial

    Seeking a Fortran compiler (cheap &amp; simple)

    I am seeking recommendations for a Fortran compiler to resuscitate a very old program so that it will run under present versions of Windows.[&nbsp;] Hopefully this is the appropriate forum for such a request. I wrote the program many years ago, using what I believe was called "standard subset"...
  8. Denial

    Subroutine to force XY-chart to have equal scales

    A few years ago, building heavily on work done by several others, I placed on this forum a VBA subroutine to force an Excel XY-chart to have equal scaling on its X ("Category" and Y ("Value") axes.[&nbsp;] See the now-closed discussion at thread770-274998 from June 2010.[&nbsp;] I have since...
  9. Denial

    Running Windows VBA on Excel 2011 (Macintosh)

    I have a complex spreadsheet that makes extensive use of VBA, including Command Buttons and Event Handlers. I have developed it over quite a few years, and therefore quite a few versions of Excel, but only ever on Windows versions of Excel. It is able to be run on all Excel versions from 97 to...
  10. Denial

    Running Excel-2010's version of Solver through VBA

    Over the years I have developed a few Excel spreadsheets that are intended to be used by engineers of vastly differing Excel skill levels. Several of these spreadsheets use Excel's Solver, and to make them as bullet-proof as possible I have used VBA to automate the Solver. I am in the process...
  11. Denial

    Does VBA have a 64K limit on Modules?

    These fora contain occasional references to a size limit of 64K for a VBA module in Excel (the most recent being thread766-279070). Over the years I have also come across similar mentions elsewhere in CyberLand. To try to sort this out once and for all, I have just searched Google Groups...
  12. Denial

    Forcing an Excel chart to have equal X &amp; Y scales

    This post is a long-overdue update to a 2005 discussion on this forum. See thread770-141275. The discussions ended up focussing on how to achieve equal X and Y scales in Excel's XY-Scatter charts, and the final result was a passably-reliable VBA subroutine. Over the years since then I have...
  13. Denial

    Excel's HYPERLINK function

    I am using Excel 2003. One of my more elaborate spreadsheets has an entire worksheet that consists of nothing more than a large amount of text devoted to documentation. The text is structured in sections, and each section has a heading in column A of an otherwise blank row preceding the body...
  14. Denial

    Seeking software for presenting closed 3D surfaces

    I am looking for some software, preferably freeware, that can present three dimensional surfaces in a user-friendly manner. My (pre-calculated) data consists of scalar values (w) that apply at locations in three-dimensional space (x,y,z). Thus I have a large number of data quadruplets of the...
  15. Denial

    &quot;Calculate&quot; does NOT appear in Excel's status bar

    I have a quite complicated, but not particularly large, multi-sheet workbook. It has a lot of named ranges, and makes extensive use of dynamic arrays. Most of its formulae (many of which are array formulae) use cells on different sheets. Nearly all its operations are performed by executing...
  16. Denial

    Buckling of a drum wrapped in tensioned rope

    I have a circular drum, around which several turns of tensioned rope have been wound. (This is the sort of situation that would apply to the winch drum in a crane, but my actual situation is not a winch drum.) I am happy to ignore friction, to ignore complications caused by the locations where...
  17. Denial

    Pedestrian mass for dynamic analysis of bridge

    I am carrying out dynamic analysis of a proposed pedestrian bridge (natural frequencies, to be followed by a series of harmonic responses). The applied harmonic loadings are from pedestrian footfalls. The controlling cases are those where the &quot;density&quot; of the pedestrians is as high...
  18. Denial

    Buckling load of a fishing rod

    Does anyone know the formula for the buckling load of a fishing rod, or, rather, of a cantilever column carrying a weight via a rope over a pulley at its top? Consider a cantilever column like a flag pole, of total height &quot;L&quot; . A smooth rope is independently anchored very close to...

Part and Inventory Search

Back
Top