Different X-Axis Values, But The Same X-Axis Units – Getting Excel 2013 (OSX-Specific) To Produce Multiple Scatter Plots On The Same Graph

Posting a workaround to re-introduce a feature for Excel 2013 that I think was removed for some reason and for which information on Excel 2013 (OSX-specific) is impossible to find through google searches. It is my hope that newer versions of Excel don’t have this thoroughly annoying problem (and if there’s an obvious way I don’t know about to make this happen in a single shot, feel free to drop a line).

If you found this page via google, I’m going to assume you were searching for something like the following questions (which I’m including below so that search engines find similar questions):

How do I add:
– data with two different X-axes to a single plot in Excel?
– multiple plots to the same graph in Excel with different X-values but the same X-axis units?
– a second dataset to a plot in Excel with new X-axis values?
– a new dataset with different abscissa values in Excel?
– a secondary X-axis to plot new data on the same graph in Excel?

My Scenario – Overlaying Two Spectra On The Same Graph

This issue came up for me when trying to generate some simple spectral overlays in Excel. The problem proceeds as follows:

Continue reading “Different X-Axis Values, But The Same X-Axis Units – Getting Excel 2013 (OSX-Specific) To Produce Multiple Scatter Plots On The Same Graph”

“Stu’s Last Lesson” – Sky & Telescope’s Focal Point For December, 2014

As posted on the CNY Observers website (direct link).

Greetings fellow astrophiles,

2014oct23_stuDr. Stuart Forster (a.k.a. STU – full caps) was one of the THE fixtures in the CNY amateur astronomy scene and his name still comes up regularly, often as part of some pearl of wisdom being imparted to new observers and seasoned members alike (I’ll leave you to read the top of the Stuventory page for more info about STU and to check out links to some of his images on the Syracuse Astronomical Society website). The trials and tribulations of Ryan Goodson and myself to handle the massive equipment collection we’ve come to refer to as the “Stuventory” is olde hat to local observers who’ve kept track of the process from a far. The sorting, documenting, and distribution of the Stuventory has taught us both about how very unique the hobby of amateur astronomy can be when you step beyond the 1×7 mm binoculars in your head and effort the collection of more and more photons.

Continue reading ““Stu’s Last Lesson” – Sky & Telescope’s Focal Point For December, 2014”

GROMACS 5.0.1, nVidia CUDA Toolkit, And FFTW3 Under Ubuntu 14.04 LTS (64-bit); The Virtues Of VirtualBox

Summarized below are the catches and fixes from a recent effort to build GROMACS 5.0.1 with FFTW3 (single- and double-precision) and GPU support (so, single-precision). Also, a trick I’ve been doing with great success lately, using a virtual machine to keep my real machine as clean as possible.

0. The Virtues Of VirtualBox

Open source means never having to say you’re sorry.

I’ve made the above proclamation to anyone who’d listen lately who has any interest in using Linux software (because, regardless of what anyone says on the matter, it ain’t there yet as an operating system for general scientific users with general computing know-how). You will very likely find yourself stuck at a configure or make step in one or more prerequisite codes to some final build you’re trying to do, leaving yourself to google error messages to try to come up with some kind of solution. Invariably, you’ll try something that seems to work, only to find it doesn’t, potentially leaving a trail of orphaned files, version-breaking changes, and random downgrading only to find something else stupid (or not) fixed your build problems.

Continue reading “GROMACS 5.0.1, nVidia CUDA Toolkit, And FFTW3 Under Ubuntu 14.04 LTS (64-bit); The Virtues Of VirtualBox”

For The Windows-Specific: Sed For Windows And A .bat File To Get Gaussian09 Files Working With aClimax

Provided you’ve installed Sed For Windows and know its proper path, the .bat file below should make all the modifications you need to your Gaussian09 .out files (in differently-named files at that) to get them properly loading in aClimax (see the previous post for all the details). A few simple steps:

1. Download and install Sed for Windows. Currently available at: gnuwin32.sourceforge.net/packages/sed.htm

2. Find its location on your machine. Under XP (where I’m using aClimax), this should be C:\Program Files\GnuWin32\bin

Continue reading “For The Windows-Specific: Sed For Windows And A .bat File To Get Gaussian09 Files Working With aClimax”

Stupid-Simple (*nix-Specific) Sed Scripts To Get (All Current) Gaussian09 Output Files Working With aClimax

The following three snippets of Gaussian output are for an optimization and normal mode analysis of simple olde methane (CH4).

...
 ******************************************
 Gaussian 03:  EM64L-G03RevE.01 11-Sep-2007
                31-Aug-2014 
 ******************************************
...
 incident light, reduced masses (AMU), force constants (mDyne/A),
 and normal coordinates:
                     1                      2                      3
                     T                      T                      T
 Frequencies --  1356.0070              1356.0070              1356.0070
 Red. masses --     1.1789                 1.1789                 1.1789
 Frc consts  --     1.2771                 1.2771                 1.2771
 IR Inten    --    14.1122                14.1122                14.1122
 Atom AN      X      Y      Z        X      Y      Z        X      Y      Z
   1   1     0.02  -0.42   0.43    -0.34  -0.13  -0.08    -0.36  -0.23  -0.23
   2   6     0.00   0.08  -0.09     0.00   0.09   0.08     0.12   0.00   0.00
...
 -------------------
 - Thermochemistry -
 -------------------
 Temperature   298.150 Kelvin.  Pressure   1.00000 Atm.
 Atom  1 has atomic number  1 and mass   1.00783
...

Continue reading “Stupid-Simple (*nix-Specific) Sed Scripts To Get (All Current) Gaussian09 Output Files Working With aClimax”

Remembering The Godfather Of Solar Astronomy, Robert “Barlow Bob” Godfrey

As appeared on the CNY Observers & Observing website on 20 June 2014:

The field of amateur astronomy hosts many different personalities. Some love to know anything and everything about astronomy equipment. Some prefer the study of astronomy through the ages. Some enjoy the banter around a large scope with others at midnight. Some enjoy the quiet solitude of a small dome or open field. Still others enjoy setting their equipment up in the middle of the chaos of a large group of people to show them the sights. Some take their love of outreach well past the observing field, taking it upon themselves to educate others by taking what they know (or don’t yet know) and making it accessible to the larger audience of amateurs and non-observers alike.

Amateur astronomy has seen a few key players pass this year, starting with John Dobson this past January and the noted comet hunter Bill Bradfield just a week ago. Both are noteworthy in their passing in that, amongst a large, large number of astro-hobbyists, their names are held in higher esteem because of their unique contributions to amateur astronomy. In the case of Bill Bradfield, he singly was responsible for finding 18 comets that bear his name, making him responsible for helping map part of the contents of our own Solar System from his home in Australia (reportedly taking 3500 hours to do so). In the case of John Dobson, he not only synthesized many great ideas in scope building with his own to produce the class of telescope that bears his name, but he also made it part of his life’s work to bring the distant heavens to anyone and everyone through his founding of what we call today “sidewalk astronomy.”

Continue reading “Remembering The Godfather Of Solar Astronomy, Robert “Barlow Bob” Godfrey”

Gig Announcement: Juneteenth Jazz at the Hotel Utica, Saturday, June 14th

2014june10_Juneteenth2014_small

The Matthew Rockwell Group (like on the facebook) will be making the trip out to Utica this coming Saturday, June 14th as part of the entertainment for the For The Good, Inc.’s Juneteenth Jazz Night event, sharing the stage with some notable Utica heavy hitters.

2014june10_sparkytown

The band at Sparkytown, 23 May 2014. Photo by Jack M. Hardendorf.

Continue reading “Gig Announcement: Juneteenth Jazz at the Hotel Utica, Saturday, June 14th”

Generating Molecular Orbitals (And Visualizing Assorted Properties) With The Gaussian09 cubegen Utility

To begin, this post owes its existence to the efforts of Dr. Douglas Fox at Gaussian, Inc., who provided me with an alternative explanation of how the cubegen utility works. After much wailing and gnashing of teeth, I intend on taking Dr. Fox’s advice and asking Gaussian Support for assistance earlier in my endeavors. What follows below, I hope, will save you some significant frustration (and, given how little there is online that really describes the extra workings of cubegen in a clear and example’ed way, it is my expectation that this page appeared early in your search list).

What I wanted out of cubegen that I couldn’t figure out how to get:

The situation was simple. I wanted my molecule centered and bound within an arbitrarily-sized box (X,Z,Y) for making images and doing additional post-processing. Specifically, I wanted to be able to take many different molecules (from hydrogen gas to big biomolecules) defined within the same-sized box for layering and presentation (different boxes for each, but all the same size).

Continue reading “Generating Molecular Orbitals (And Visualizing Assorted Properties) With The Gaussian09 cubegen Utility”

Play Softly And Carry A Thin Pair Of Sticks, Or A Drummer’s Guide To CNY Venues, Part 1: The Buzz Cafe, Syracuse

This (what I hope will be a) series of posts stems from a gig that changed the way I approached all the songs I played that evening (specifically, this gig). Changed in the kind of way that I wish the band had had proper notice of the situation we (well, I) were walking into in terms of the room, the acoustics, and the management. On the plus side, Syracuse is undergoing what I think is a slow expansion of mom+pop places that open their doors to live music. This is just fine for most styles of music and small groups. On the down side, these tend to be small places. This is just fine for most styles of music and small groups.

This can be a problem for a set drummer, which can then be a problem for the rest of the band. You rehearse and rehearse with a group at one volume, playing at a level at which you are comfortable playing all the complicated fills and patterns you like. Everyone gets used to hearing certain things and you get use to executing those things. Then you find yourself at a venue with your full kit and an owner who doesn’t seem to like loud noises. And by loud noises, I mean sounds generated by the lightest sticks you own using little more than your fingers to propel them several inches. And I understand the hesitancy an owner might have when confronted by a drummer they’ve never heard, as I’ve certainly sat near my share of drummers who didn’t adjust their playing volume to the room. But with this new adjustment, you’re not playing the same song you (and the band) have grown accustomed to. Now, the whole band may find itself reacting to this new dynamic from the drummer, while all the others in the band had to do was turn their volume knobs down a bit.

Continue reading “Play Softly And Carry A Thin Pair Of Sticks, Or A Drummer’s Guide To CNY Venues, Part 1: The Buzz Cafe, Syracuse”

Compiling And Running GAMESS-US (1 May 2013(R1)) On 64-bit Ubuntu 12.X/13.X In SMP Mode

Author’s Note 1: It is my standard policy to put too much info into guides so that those who are searching for specific problems they come across will find the offending text in their searches. With luck, your “build error” search sent you here.

Author’s Note 2: It’s not as bad as it looks (I’ve included lots of output and error messages for easy searching)!

Author’s Note 3: I won’t be much help for you in diagnosing your errors, but am happy to tweak the text below if something is unclear.

Conventions: I include both the commands you type in your Terminal and some of the output from these commands, the output being where most of the errors appear that I work on in the discussion.

Continue reading “Compiling And Running GAMESS-US (1 May 2013(R1)) On 64-bit Ubuntu 12.X/13.X In SMP Mode”