Almost a Technocrat in Draft

This is how to run the FileSaveAs command in VBA macro which is commonly used in Ms Excel or Ms Project without having the application prompt for overwriting and existing file. The idea is to temporarily setting the object "Application.DisplaysAlerts" to false and then set it back to true after the file save. Example: Application.DisplayAlerts = False FileSaveAs command Application.DisplayAlerts = True

This is how you can save as a new file with a different file extension but the you would like to use back the same file name as the current file you are saving from. This is a VBA macro code for Ms Excel, Ms Project or any other Ms Office product that uses VBA macro for automation. By using the object "ThisProject.Name", assign it to a variable and use the variable in the "FileSaveAs" command file path parameter. Example: Dim FileName As String FileName = ThisProject.Name FileSaveAs Name:="\path" & FileName & ".csv", FormatID:="MSProject.CSV", map:="exportCSV_map"

Ever wonder how many Google Adsense page views you need to earn $100 per month for your website or blog from Google Adsense? These are the calculations that will guide you to plan a target Google Adsense page views to earn your target monthly earning base on your recent CPC (Cost Per Click) and CTR (Click Through Rate). Before you start, you will need to get your CPC and CTR values from your Google Adsense report. You can either use the values based on last month, last 30 days or last 3 months. Lets say for example your values looks something like this: CPC = 0.5 CTR = 1.00% To get an idea of how many page views you will need per month based on the CPC and CTR values to earn $100 per month, this is how the calculation looks like: ((100 / 0.5) / 1.00) x 100 = 20,000 page views In summary: Target page views = ((target earning / CPC) / CTR ) x 100 percent In order to earn $100 per month based on the current CPC and CTR values from your Google Adsense report, you will need at least 20,000

A simple and funny explanation on how the Heartbleed vulnerability works. via ( xkcd: Heartbleed Explanation )

This Tasker profile recipe will only enable my Android Auto Sync feature whenever there is a WiFi connection. This helped me to maximize my Android battery life and minimize my cellular data usage. Profile: Auto Sync When WiFi (2) State: Wifi Connected [ SSID:* MAC:* IP:* ] Enter: Anon (3) A1: Auto-Sync [ Set:On ] A2: Mobile Data [ Set:Off ] A3: Variable Set [ Name:%Wificonn To:On Do Maths:Off Append:Off ] Exit: Anon (4) A1: Auto-Sync [ Set:Off ] A2: Mobile Data [ Set:On ] A3: Variable Set [ Name:%Wificonn To:Off Do Maths:Off Append:Off ]

One of the way to maximize your Android battery life is to avoid running your Auto Sync all the time. Through out the usage of my Android phone, I have accumulated quite a number of Android apps that uses the Anroid Auto Sync feature to get data into the Android phone. By using Tasker, I can schedule the Auto Sync to run every one hour for 5 minutes. My battery life improved significantly after that. Below is the recipe for the Tasker profile. Profile: Scheduled Auto Sync (12) Time: From 08:00 every 1h Till 23:00 State: Not Wifi Connected [ SSID:* MAC:* IP:* ] State: Mobile Network [ 2G:Off 3G:On 3G - HSPA:On 4G:Off ] Enter: Anon (13) A1: Auto-Sync [ Set:On ] A2: Wait [ MS:0 Seconds:0 Minutes:5 Hours:0 Days:0 ] A3: Auto-Sync [ Set:Off ]

Since I bought my D-Link DNS-320L NAS filer, I was trying to find space on the table I placed my fiber modem and WiFi router together. With the addition of the NAS filer, the space of that table suddenly almost fully occupied. To save some space, I came with an idea if placing those modems and routers vertically to save one device space. I use my old Samsung Galaxy Nexus package box and cut out some opening to slot in those devices. A precision caliper and sharp penknife are the necessary tools to get the opening wide enough for the devices to slot in. I could make 3 slots on this box but since I only have 2, devices, this will do. The good thing about placing the devices in vertical is the devices has more surface exposing to the air and thus making a better cooling from the ambient wind in the room.