Category Archives: software

A Little Beer Data

I gave a seminar last week on the use of Python with Pandas using Jupyter notebooks. When I give a seminar, I always have a worked example to illustrate the points that I am trying to make. This attendance at this seminar had a number of young men in it, so I decided to focus on a topic near and dear to their hearts – beer. I was amazed at the amount of beer knowledge showed by some individuals in the audience. Clearly, beer is a major part of their lives. I myself know NOTHING about beer, so I had to educate myself. The data provide interesting to analyze, and I will probably be augmenting my seminar with additional data over time. Continue reading

 
Posted in Python, software | Leave a comment

The Tyranny of the Spreadsheet Cell

I had a conversation the other day with an engineer to whom I was expressing my frustrations with using Excel to process large data sets of complex numbers. She also has processed large data sets with Excel and commented that she found the processing painful. I told her about how I was using Excel to work with my data sets, but my techniques all seemed contrived and overly complex. While you can use Excel to work with these data sets, it is a bit like trying to use a Swiss Army knife as a screwdriver. Yes, it can turn a screw but there are much better ways! Continue reading

 
Posted in software | 8 Comments

State GDPs Relative to National GDPs

I am amazed at all the different lists on the Wikipedia. Today, I came across a list of all the US state GDPs and a map (Figure 1) that shows how the state GDPs compare to the GDPs of various nations. I have to admit that I think this is a very interesting chart. Continue reading

 
Posted in software | 2 Comments

Electricity Generation Percentage from Coal By State

I drive a short distance (7 km) to work everyday. On my drive, I often have to wait at a railroad crossing for a coal-train train to pass (typical example in Figure 1). I have never thought much how much my state depends on coal until I saw an interview with a Missouri senator who was talking about her state's dependence on coal for electrical power generation. I am currently teaching myself how to use the Power Query add-in for Excel, and I thought that generating a graphic of coal dependence by state would be a good Power Query/Visio exercise. Continue reading

 
Posted in General Science, software | Leave a comment

Linking Data to a Visio Drawing

I enjoy collecting and occasionally creating pins for my Pinterest collection. There was one pin that I saw (Figure 1) that I thought would be a good exercise to use when I conduct training classes in Visio and Excel. This post will use a simple Excel table of planetary orbit data to drive the creation of similar graphic in Visio. I will make one change to the information contained in Figure 1 – I will add Pluto because I still like to think of it as a planet. I will also remove the black background because I find black a bit harsh for a background color. Continue reading

 
Posted in Astronomy, software | Leave a comment

I Must Be Old, All the Bugs Sound Familiar ...

I was reading an article this morning about a bug discovered in Boeing's 787 software that will occur after 248 days of continuous operation. The moment I read "248 days", I let out a sigh – I have seen that number before. Continue reading

 
Posted in software | Leave a comment

Prime Number Magnitudes

I am responsible for some of the authentication features in our products and these features use prime numbers. People often have basic questions on prime numbers, such as:

What happens if I choose the same prime number as someone else?
Are there enough prime numbers? Continue reading

 
Posted in General Mathematics, software | Leave a comment

Making IP Addresses Sortable By Number

Quote of the Day Abolition was a pipe dream in 1835 – it was reality 25 year later. — Tom Rick, defense analyst, quoting his historian wife about how fast things can change in the US. My oldest son called … Continue reading

 
Posted in software | Leave a comment

Inserting Images into Excel Comments Using VBA

I use Excel for basic statistical analysis of manufacturing and field return data as part of daily routine. I also use Excel for department budgeting. During these tasks, I frequently need to add information to my spreadsheets about my information … Continue reading

 
Posted in Management, software | 6 Comments

Volcano Math

I was listening to Planetary Radio the other night and they had an interesting interview with Rosaly Lopes, a researcher at the Jet Propulsion Laboratory who has discovered more volcanoes than anyone else. Her discoveries were of volcanoes on other … Continue reading

 
Posted in General Science, software | Tagged , | 4 Comments