We posted instructions on finding the Command Prompt in Windows 7 in a past Post, and because we still find it useful, the following is an update on finding it in Windows 10. The reason that it is useful, is that, in many cases, while instructing people, the phrase “just open a Windows Command Prompt [...]
Excel's AnalysisToolPak offer a variety of routines for analyzing statistical, scientific and engineering data. In this articular we are going to look at how to use the correlation tool in the Analysis ToolPak. Enable the Analysis ToolPak: Although already installed with Excel, the Analysis ToolPak will need to be enabled through the Options menus. For [...]
What is a Data Structure? Part 1 An Explanation Using Tables in Excel 2010 Whether you are just going to look at your data and draw conclusions visually, or you are going to writing a computer program to manipulate it, even a very simple structure can help. When analyzing data, it is useful to decide [...]
Using Excel 2010 we are going to look at how to replace blank cells with zeros. Selecting the cells manually is, of course one option, but if the spread sheet is large then the procedure would be rather time consuming. For this exercise we will use a couple of short-cuts. Tools used for this exercise: [...]
In this example we are going to convert Id numbers into Text format and we will look at how to removing any resulting warning messages. Tools used for this exercise: Using the “Number as text” format Removing the warning message on the Options command on the File Tab. […]
Using Excel 2010 we are going to look at how to separate full names (last name followed by first name) into separate columns. Once that is done we are going to convert the data to table format and sort on the last name. Tools used for this exercise: The “Text to Columns” command Converting to [...]
It seems that in many cases, while instructing people, the phrase “just open a Windows Command Prompt and type in …” is usually interrupted with the comment “ok, how do I do that”. Also, in the user manuals and document we generate, there are occasions that a command prompt may be needed, and this note [...]
The following are excerpts from our tutorial. Structural errors in a 3D model need to be repaired before the model is ready for 3D printing. Holes within the object and inverted normals are the most common issues. These types of problems tend to arise if the models were produced, or scanned, using software packages that [...]
Using WordPress and the 2014 Theme Presented in a tutorial form, below is the WordPress part of the workflow we used to create the Windsong web site. For this iteration, we used the WordPress default 2014 Theme to create a traditional website in look and feel, but still incorporated the blog-post ability. The order of [...]
Windsong is a companion website and is part of Videre Analytics. This site concentrates on the How-Tos and Tutorials we have developed, courses we offer, and information about on-site training. This web site also serves a number of other purposes: as a reference for workshops, courses and tutorials; as vehicle to post information and how-to [...]