MODx, xPDO, & The WHERE Condition

I have had some fun working out the intricacies of how to use the “where” condition when building a query using MODx’s xPDO query builder. What I have found is that there is no one way to build a query using MODx.

Get the Size of a Directory (Over 2GB) from a Linux, Unix, or Windows Server Using PHP

I had a project that required me to get a folder size using php. At first I thought this would be a snap. Unfortunately the only php solutions I found required iterating through directories and sub-directories, adding the size of each file one at a time. That just wouldn't work, it would take to much time. Then I found some information on using some *nix calls.

Making A Blacklist For Upload To A Router

I was recently asked by a friend for some help making an upload for a microtik router. There was only one problem, there were 16,346 items in his list. He had given me a list of websites formatted to block url's using a host file on individual machines.

Creating A Drop Down List & VLOOKUP Moving Columns

There are several tutorials out there on how to create a drop down list. Here I wanted to show how to combine tools and functions together in different ways to make new and more useful tools.

Creating A Parts Lookup Spreadsheet – Part 2 Finding the Best Match

This is part 2 of a series of tutorials to show the power of Microsoft Excel. Here we will see some functions that were used in the first tutorial. The main focus of this walk through is to work with some new functions and to learn about how arrays can make life easier when working on large project.

How To Lookup Data Using An Array In Excel

I was originally going to integrate this tutorial as part of the Creating A Parts Lookup Spreadsheet Part 2, when I realized that there is so much to cover on array's that it would take away from the lookup tutorial. Here we will examine how array's are very handy. They work similar to a vlookup, but are not limited to looking up off one column, but several.

Microsoft Excel Stuck in Compatibility Mode

There are many ways in which MS Excel can be stuck in compatibility mode. This means every time excel is opened the rich new features available in Microsoft Excel 2007 and Microsoft Excel 2010 cannot be used, like the number of rows available to use ending at 65,536. There are several ways available to fix this problem.

Microsoft Excel Cell Movement Shortcuts

Shortcuts are easy to use and very fast, but who has the time to look them up? Here I want to show some quick, easy shortcuts to navigate through large excel spreadsheets quickly.

Convert Millimeters To Inches & Round

We will review how to convert millimeters to inches (mm to in), and then round to any imperial fraction (i.e. 1/64, 1/32, 1/16, 1/8, 1/4, 1/2). This tutorial will convert a list of millimeter measurements and convert them into inches and then round to a 1/16”.

Creating A Parts Lookup Spreadsheet - Part 1 Setting Up Blanks

This tutorial is part one of a series of tutorials to show the surprising power of Microsoft Excel. We will begin this tutorial with a real life situation where I had to manage some parts for cabinet doors and face frame components.