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...
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...
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...
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...
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...
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.[ ] While I have not yet begun compiling my <irony>magnum opus</irony>, I have successfully compiled and run a few...
I am seeking recommendations for a Fortran compiler to resuscitate a very old program so that it will run under present versions of Windows.[ ] 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"...
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.[ ] See the now-closed discussion at thread770-274998 from June 2010.[ ] I have since...
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...
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...
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...
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...
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...
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...
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...
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...
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 "density" of the pedestrians is as high...
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 "L" . A smooth rope is independently anchored very close to...
