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 [...]
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 [...]