Almost a Technocrat in Draft

This is how you can add a line break into Ms Excel cell using formula. Using keyboard while typing into the cell, to insert a line break just hit "at+enter". But what about using formula? To insert a line break into Ms Excel cell using formula, use this: CHAR(10) Example: ="this is the first line"&CHAR(10)&"this is the 2nd line" via( http://excel-formulas.blogspot.com/2009/03/line-break-in-cell-using-formula.html )

By default if you try double clicking and open 2 Excel files, they will open up and stack into 1 instance of Excel program. What if you are cross referencing 2 Excel files using 2 monitors? You definitely want them to show each in one monitor (if you have 2 computer monitors). This is how simple you can workaround it: Directly run Excel program from your start menu 2 times so that you have two Excel running at the same time. Notice that they are in separate window instead of stacking on each other. Drag each of your Excel files into each of the running Excel program. Now you have 2 windows of Excel showing each of your Excel files.  Just put each of your Excel window to each of your 2 computer monitors. Now you can cross reference your 2 Excel files using 2 computer monitors.

This post is to show you how to use Windows scheduler and batch script to setup an automation to automate the mining of your favorite crypto currency (Bitcoin, Litecoin, Dodgecoin, etc…) whenever the Windows PC screen is locked, AC power plugged in and idle. The following steps are based on Pooler CPU miner program . You will also need to have a pool mining account. I assume that you already know how to setup the CPU miner to mine from a mining pool and you already know how to setup the JSON configuration file. Note: This post does not show you how to setup pool mining or creating an account for crypto currency. Prepare a start mining batch script 1. Create a start_cpuminer.bat script file and copy and paste the template code below: start /min /low [path-to-cpuminer-daemon-program] -c [path-to-json-cfg-file] 2. Replace the path to your Pooler CPU miner program and path to your JSON configuration file. Save the file after replacements. Prepare a stop mining batch script 1. You will nee...

This is how to place or insert Google Adsense units or any other online ads right in between the blog post and comments section. This will also make the ad units appear in between posts in archive or label pages. This is a strategic location to enable visitor to spot the ads right after finish reading a blog post. Steps 1. In the template source code, find this piece of code: <b:include data='post' name='post'/> 2. Copy the code below and paste it below the code in step 1. <div> <!-- paste your adsense code here --> </div> 3. Copy your Google Adsense code and paste it between the <div> codes as shown in step 2. 4. Save and reload your blog. Note: After pasted the Google Adsense code, modify the async part a bit. Before: <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> After: <script async="true" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"...

A home network attached storage enclosure that packs with lots of features.

All other stuffs that I blogged about and I can't seems to find a right category for them.

A list of VBA macro tricks that I learned while I tried to automate my job tasks.

Ms Excel is a very powerful tool. These are posts related to solutions and workarounds that are not so obvious.

This is how to add breadcrumbs to your Google Blogger blog template. The breadcrumbs will enable you to better inform your visitors on navigating around your Blogger blog. The method here involves editing your Blogger template HTML code so make sure you have backup your template first before you proceed with the edits. Got to edit HTML mode of your Blogger blog and follow the instructions below for the edits to add the breadcrumbs into your Blogger blog template. 1. CTRL+F to find this code: <b:include data='top' name='status-message'/> 2. Add the following code below or after it. <b:include data='posts' name='breadcrumb'/> 3. CTRL+F to find this code: <b:includable id='main' var='top'> 4. Replace the above piece of code with the code below <b:includable id='breadcrumb' var='posts'> <b:if cond='data:blog.homepageUrl == data:blog.url'> <!-- No breadcrumb on home page --> <b:els...

This is how you can set the VB macro to auto run whenever Ms Excel or Ms Project starts. To do this, rename your macro name to "Auto_Open". Yes! it's as simple as that. References, Sources and Credits: Running a macro when Excel starts