Download Update: VBA and Excel…Part 2
Rockman's Ramblings
Most Popular GeoPrac.net Content of 2009
Best wishes for a happy and prosperous 2010 to all the readers of GeoPrac.net! I am grateful for all of my readers, visitors and sponsors for a great 2009 and I look forward to continuing to work in the new year towards making this site one of the best online resources for geotechnical engineers, geoengineers and all professionals in the geo-industry.
As is customary for bloggers at this time of year, I have listed below the top 100 GeoPrac.net stories published in 2009. Long-time readers of GeoPrac know that I don’t like to rank the articles by total number of ‘hits’, since I think that biases the rankings towards the ones that have been published longer. Instead, I order them by hits per day. I think that works well when looking at popularity of content on a monthly basis, but just for grins I’ve also included the top 100 items of all time (based on total page impressions). Again, Happy New Year!
Click Through for the Top GeoPrac.net Content of 2009 and All-Time!
Available Resources
Which Excel 2010 chart types to use, and which to avoid
As engineers and geologists, we frequently use Excel charts to communicate data…but which chart types are the best at communicating data, and which ones should be avoided? This is one Excel charting expert’s views on […]
Articles
VBA and Excel for Engineers and Scientists – Part 2
In this long awaited second article in the series, I will dive into the meat of the VBA programming language, including code containers, data types, variables, math operators, built-in functions, flow control, and even debugging.. In the end, you should be able to code some fairly complex things including custom worksheet functions that you can use in your spreadsheet just like a regular formula. Also in this article I give you a sample spreadsheet with some useful utilities that you can use right away.