Author: admin

So I have been trying to decrease the latency on one of my hobby websites and I noticed on Pingdom that there was a consistent 250 ms time slot on DNS. My website at the time after a lot of tweaking was loading at about 1 – 1.5 secods, so that 200ms was a pretty … Continue reading “DNS Speed Increases on CloudFlare Free DNS”

TLDR; try pulling the battery out and putting it back in. EDIT TLDR; My phone started to do the screen flickering thing. I followed the directions to bake the motherboard which worked for a little bit. I ended up buying a new phone. Recently, the Bluetooth radio on my LG G3 started to turn off … Continue reading “LG G3 Bluetooth Turning Off and Won’t Stay On”

Sumproduct is powerful Excel formula to multiply 2 or more paired ranges (aka arrays or lists) together and sum the product. This is most commonly used in areas like payroll where you have a list of people, their hours worked, and their pay rate. If you wanted to get the total payroll for the period you have … Continue reading “How to Use Sumproduct to Divide instead of Multiply”

You probably won’t come into this situation very often where you have a Windows computer/server running PHP. Basically this is a web-service that allows the user to trigger a VBS script bu posting a variable to a web service. The web service then takes that information and runs the VBS script after updating the database … Continue reading “Trigger VBS Script via PHP”

To make a set of numbers of varying length into strings with the same number of characters, try using the TEXT formula. This formula won’t handle strings, so if you need to add leading zeros to an alphanumeric identifier you might have to try modifying the VBA formula pasted at the end. Here’s an example: … Continue reading “Formula to Add Leading Zeros in Excel”

So when you’re remoted in another computer with Windows Remote Desktop Application pressing Control + Alt + Delete to bring up the task manager, to change your password, or to log off, you’ll pull it up on the main computer instead of the remote computer. To get around this press : Control + Alt + … Continue reading “Control + Alt + Delete in Remote Desktop”