BTTools™ for Excel. Because Data Is the New Gold!

It’s like Mark Cuban said in a 2017 interview, “Data is the new gold!” These days, almost everything in our lives generates data. Our phones, our computers, even our thermostats! That data is all stored in some format somewhere. The nice thing about Excel is that you can import data of almost any type into it. However, getting metadata, or “data about data,” for those datasets in Excel can be difficult.

The solution most often is to purchase third-party software which can cost in the hundreds to thousands of dollars, sometimes, per user!! That can be daunting if you don’t want to spend that much money or, worse yet, can’t. BTTools™ for Excel can give you metadata about your datasets IN EXCEL for only $9.99 per single user license!

Need the add-in for a lot of people? Contact Us about volume discount pricing! In most cases, we’ll be able to work with you and come to a solution that is equitable for both of us!

Still not sure if you want to take the plunge? Surf on over to our BTTools™ webpage, where you can review basic help information and instructions for the add-in, as well as download our FREE best-of-the-best PDF helpfiles!

BTTools Data Gold ImageCopies:
$9.99 – Purchase Excluding 5.65% tax

Original gold image by: Pixabay. Used with permission.
Original data image by: Pixabay. Used with permission.
New image Copyright © The Wisconsin I.T. Guru 2020.
Graphic design by The Wisconsin I.T. Guru!

Flourish Image

Excel Data Analysis & Reporting … by BTTools™!

Often, when importing raw data to Excel, it is necessary to know information about the quality, accuracy and “substance” of your data. Things like: how many cells in a field contain null values, or what percentage of data in a field is text or numeric. Our BTTools™ add-in for Microsoft® Excel helps you find out just that!

In as little as a few seconds, our add-in will tell you for each field:

  1. The Field’s Name
  2. The Number of Records
  3. The Number of Null Records
  4. The Number of Records That are Not Null
  5. The Percentage of Null Values
  6. The Percentage of Values That Are Not Null
  7. The Number of Numeric Values
  8. The Number of Text Values
  9. The Percentage of Numeric Values
  10. The Percentage of Text Values
  11. The Maximum Number of Characters Found
  12. The Minimum Number of Characters Found
  13. The Average Number of Characters
  14. The Median Number of Characters

Additionally, it will generate summary statistics for all of those criteria, with the exception of ‘Field Name,’ ‘Average Characters’ and ‘Median Characters.’ Field Name for obvious reasons, and the Average Characters and Median Characters because the average of averages is not the average, nor is the median of the medians the median. A simple explanation of that can be found here.

The only requirements of the data for you to run this report is that the first row be the row of field names and that every subsequent row be data. That’s it!

Who would find this useful? Many people have to import and analyze raw data, such as CSV files, or vendor data arranged in spreadsheets. Knowing the information our report provides can be critical for checking the accuracy of the data, or for quickly finding out critical statistics about it.

Intrigued? Check out our BTTools™ page for more information or to purchase a copy for yourself!

BTTools Analyze Flatfile Image

Check Out Our BTTools™ Add-In for Microsoft® Excel!

Analyze and report on raw data, quickly compare differences between two Excel worksheets, add images to spreadsheets that are sortable WITH data, and much, much more with this smart Excel add-in!

You get 12 powerful scripts to speed production, improve accuracy, enhance the functionality of your spreadsheets and make adding images to cells a breeze!

Click here to be taken to the ‘more information’ page.

How To Disable “Always On” Synaptics Touchpad (Windows 10)

A few months back, my Synaptics Touchpad on my MSI GL63 8RD updated itself.  Before that point, I had been happy with the touchpad and its settings.  I was able to use it when I needed it, and disable it when I needed to.

However, that all changed when the latest touchpad update occurred.  Now all I saw in the settings was the ability to change the touchpad’s sensitivity.  I couldn’t stop the touchpad from picking up on my “thumb taps” when I typed.  To be honest, this was completely unacceptable to me.  I am a programmer, and I need the cursor not to bounce around the screen when I’m typing.

As the months passed, this became increasingly frustrating.  I bought a computer with a FUNCTIONING touchpad.  Now, it was not functioning the way it was when I purchased it.  I searched and searched online and couldn’t find a driver that worked, or prevent the touchpad from updating its own drivers when I tried to install an older version.  That all changed on February 25, 2019!

I found a post by “DarkwingsDuck” on the MSI forum at this link.  DarkwingsDuck said that he found a solution, which I tried and it worked for me!  Here are the solution steps that worked for me.  Please note: before testing or trying these steps, read the “Legal Horse-Hockey” section on this page.  By using (or not using) these steps, you agree to be bound by the agreement.

Steps for Disabling Touchpad when USB Mouse is Connected on a Windows 10 – 64-Bit PC.

  1. Download O&O Shutup10 for Windows 10. O&O Shutup10 is a FREE tool for Windows that allows you to disable Windows and other apps from updating themselves.  This tool is NOT an install.  You download the executable and run the file itself.  This may be helpful for people limited by corporate I.T. policies that won’t allow them to install programs on their computer.  I have not tested that feature yet, I’m just saying that it may be possible.Here’s the URL to download the O&O Shutup10 program:
  2. Create a restore point on your system or backup before proceeding. I ended-up having no problem running the executable, but it’s good general practice to do this.
  3. Run the O&O Shutup10 executable. Simply double-click on the EXE file to run it.
  4. Create a System Restore Point from Within the Program Itself. This can be accessed from clicking on “Actions” and then “Create a system restoration point.”
  5. Chose the Settings You Wish to Enable/Disable. I ended-up using the “! Apply All Settings” option under the “Actions” menu.  You may find that different sets of options work for you.  That option is just what worked for me.
  6. Download the Synaptics Touchpad Driver version from the “Softpedia” website. Please note that this download is for a Windows 10, 64-bit computer.  If you’re not running a 64-bit system, you may need to download another driver.  The 64-bit driver is an “older” version of the version of the Synaptics driver, one which allows the disabling of the touchpad when a mouse is detected.  As of today, I have been using this driver for XX days with no problems at all!Here’s the link to download the driver:
  7. Unzip the Downloaded Driver to a Temporary Folder on Your Computer. I generally download to a folder within my “My Downloads” folder.
  8. Run the “Setup.exe” File Which You Just Unzipped. In the multitude of files that you just unzipped, there is a Setup.exe file.  To run it, you may want to right-click on it and choose “Run as Administrator” to allow anyone that uses your computer to be able to take advantage of the features.  If you want to run it just for yourself, double-click the file.
  9. Follow the Prompts in the Setup Program to install the driver.
  10. Re-boot Your Computer. This will insure that the new touchpad settings take effect.
  11. Use Cortana or the “Search” Box in the Taskbar to Access Mouse Settings. I just typed, “mouse settings” in the search bar to bring up the mouse options.
  12. Click on “Touchpad” on the Left Side of the Settings Window That Appears. You will notice that the settings here have not changed.  We will need to click on “Additional Settings” on the right bottom of the window to access the new touchpad settings.
  13. Click on “Additional Settings”. The mouse properties dialog will appear.
  14. Click on the “Device Settings” Tab, If It’s Not Already Active. This will bring up the touchpad settings.
  15. Check the Box Next to “Disable internal pointing device when external USB pointing device is attached”. This will ensure that the touchpad is only active when a mouse is NOT detected.
  16. Click “Ok”.
  17. …And That’s It!!

Now, you should notice that when you have a mouse connected, the touchpad is completely disabled!  As of today, this has been working for me since February 25th, 2019!

Please note that I’ve seen online “Microsoft bashing” with regard to the touchpad not allowing itself to be disabled.  To be clear, this is not a Microsoft problem, but a Synaptics problem.  Synaptics is the manufacturer of most touchpads that are used in the industry.  If your touchpad had problems after a Windows update, that is simply coincidental.  Blaming Microsoft for a problem with the hardware is like blaming your Coca-Cola for being warm after your refrigerator breaks.  A