Monthly Archives: December 2012

Ghost Adventures Best EVPs

Can spirit/soul be pin pointed?

This video of Ghost Adventures catched that moment (if it is true). At 32:00 in the video, Zack felt cold spot right in front of him. All three investigators felt it. Then the ghost box said “Got me”.

Also at 39:48 Aaron’s camera mood after it is heard “Good Bye”

Best speakers for Computer

I was looking for good speaker system for laptop, something that on entry level but has good sound. I usually shop on I order their 2nd best seller (in speakers) but was quickly disappointed with it sound. I returned it for lack of bases and for good quality of sound. I was thinking that all speakers sound about the same but I was wrong. Then order the Amazone Best seller #2 Cyber Acoustics 2.1. This was better than the first one and was loud and with more base. But was not satisfied with its sound quality, lack of clear tones, lack of solid clean beats. But I was really looking was something I heard a while ago (they were Logitech Z3). The sound was simply amazing with clear beats. Something that you can really enjoy the music on. I did some good search trying to find a good set of speakers for computer. I came across the following

Top 5 best speakers for laptop

Google top 5 speakers

Interestingly I have order the Logitech Z623 already before doing this search and am planning to return the Cyber Acoustics 2.1.

If any one is consdering cyber accoustice, I would ask them to think again. They do have loud sound and relatively heavy but it is not clear and clean. The beats are just of very low quality. I am by no means an audiophile and am not not expert in sound quality. May be I will post vidow review at some point as well.

Weird Character in Excel : Square box with Question Mark in it

If you ever copied data from SQL Server Management Studio to Excel 2007, you might have seen this weird character

This is probably caused by the fact that you used “Text to Column” feature of Excel before. If you used Text to Column feature using space as deliminator, this is what caused this bug. To fixed this go to Data tab in ribbon menu, select any column that has a value. Go to Text To column menu and choose tab as delimiter (comma and other might not work).

Start a new Excel file and copy your data again. It should be copied correctly. If still has problem try changing the delimiter to something else.

Snapshot of Actual Data

Script to reproduce this table

Break one column in two in Excel

Problem: You have first and last name in column A and you want to divide into into two columns, that is first name and last name.

You further find out that in some of names in column A has 3 names, for example “Alaxander Joa Pilata”. In this case you want to combined the first two names as first name and leave the last name as the last name


In Excel 2007, select the column you want to break, in this case column A. Make sure column B and C (that is column next to it) are empty. Goto Data tab in ribbon menu and select Text To Column in “Data Tools” section. Follow the dialog boxes. Select space as delimiter. This will effectively break your column in two or three column depending on how many names

Solving the three names problem

Now lets discuss the three names problem. We are going to use three excel functions to address this problem


Concatenate (Excel)

is used to join the join the contents of Cell B and C. Do not forget to add the space in between.

IsText (Excel)

is used to check if the value is a text. It returns for true if it is text, false if it is not text. Remember that it check false for numbers also!

IF (Excel)

If function take 3 argument, first it true or false, second value if true, third value if false
=IF(condition, this value if true, this value if false)


What does Cache mean in PHP Script?

In microprocessor, cache mean the ram that is sitting right on the chip dice. It is faster to fetch data from this ram and execute because it probably less clock cycles to fetch.

But what does cache mean in PHP Script?

PHP cache is not the same as microprocessor cache. It does not mean to serve page out of memory directly also so there is no interaction with hard drive and hence faster load time. For example, you.

Caching mean to save the output of a script file such as PHP and store it either in memory or to a file. So the next time the server gets a request, the server does not have to execute the request, but merely fetch the contents from the cache file. That way you will be a lot faster load time and minimum time out errors. This of course has disadvantage that the contents of the page will not be the most current. But this is negligible disadvantage keeping in mind the server load is less and customers are served pages a lot faster!

Memory Cache in PHP

You can serve page or contents directly from memory as well. That I think will be the fast server pages. To do this one can use

file_get_contents() and

where you read the file contents once. When a new request comes in, you make sure the files contents exists, if it does you dump the memory contents. This is great if you have a long list in dropdown list that are update via ajax.

For more info check stackoverflow question on memory cache in php

Accuracy of IP Geolocations

Accuracy of IP Geolocation of various Services

Distance W3C Neustar MaxMind IP2Location
0-2 km 55% 32% 33% 31%
2-10 km 11% 14% 14% 10%
10-25 km 5% 9% 8% 7%
25-50 km 4% 7% 6% 6%
50-100 km 3% 7% 6% 6%
100-250 km 4% 7% 7% 8%
250-500 km 3% 5% 7% 7%
500-1000 km 3% 5% 6% 7%
1000+ km 12% 15% 14% 17%

Fields available through different providers

Neustar MaxMind IP2Location IPligence
Continent X X
Country X X X X
State/Region X X X X
City X X X X
Zip Code X X X
Latitude X X X X
Longitude X X X X
Organization X X
Organization Type X
Net Speed X X X
Net Type X
Domain X X X
Area Code X X X
Metro Code X X
DMA Code X X
Weather Station X
Time Zone X X X
Proxy X X
Subscription Query Monthly Annual Annual

source : For more information visit WhatisMyIPAdress

Did prophet Muhammad breach his own rules?

The prophet would pray facing towards the Bed when Ayesha would be in the bed

Volume 1, Book 9, Number 486 :
Narrated by ‘Aisha
Do you make us (women) equal to dogs and donkeys? While I used to lie in my bed, the Prophet would come and pray facing the middle of the bed. I used to consider it not good to stand in front of him in his prayers. So I used to slip away slowly and quietly from the foot of the bed till I got out of my guilt.

Another hadith from Aisha (RA) clarifies this more, citing that people were wrong when they used to refer to women passing in front of prayer make the prayer annuled.

Volume 1, Book 9, Number 490 :
Narrated by ‘Aisha
The things which annul the prayers were mentioned before me. They said, “Prayer is annulled by a dog, a donkey and a woman (if they pass in front of the praying people).” I said, “You have made us (i.e. women) dogs. I saw the Prophet praying while I used to lie in my bed between him and the Qibla. Whenever I was in need of something, I would slip away. for I disliked to face him.”

The prophet would push Ayesha legs to prostrate because there was not enough room

Ayesha (RA) was this the prophet in his last 9 years or so. During this time he probably did not live in a tiny house. Why would he pray so close to her so she he had to push her feet. Why she would rather stand somewhere and let me pray. Why the prophet did not go with that approach.

Volume 1, Book 9, Number 498 :
Narrated by ‘Aisha
It is not good that you people have made us (women) equal to dogs and donkeys. No doubt I saw Allah’s Apostle praying while I used to lie between him and the Qibla and when he wanted to prostrate, he pushed my legs and I withdrew them.

The prophet would read Quran when leaning on Aisha (RA) lap

Volume 1, Book 6, Number 296 :
Narrated by ‘Aisha
The Prophet used to lean on my lap and recite Qur’an while I was in menses.

This btw also means the prophet could read

The prophet took shower with his wife Aish(RA) during menses. Even in Aitikaf, she washed her head. Is this something he could do on his own? What’s the logic

Volume 1, Book 6, Number 298 :
Narrated by ‘Aisha
The Prophet and I used to take a bath from a single pot while we were Junub. During the menses, he used to order me to put on an Izar (dress worn below the waist) and used to fondle me. While in Itikaf, he used to bring his head near me and I would wash it while I used to be in my periods (menses).

The prophet would founle his wife during mesese

Volume 1, Book 6, Number 299 :
Narrated by ‘Abdur-Rahman bin Al-Aswad
(on the authority of his father) ‘Aisha said: “Whenever Allah’s Apostle wanted to fondle anyone of us during her periods (menses), he used to order her to put on an Izar and start fondling her.” ‘Aisha added, “None of you could control his sexual desires as the Prophet could.”

Prophet said longer period are because of blood vessels, not period bloods

Volume 1, Book 6, Number 303 :
Narrated by ‘Aisha
Fatima bint Abi Hubaish said to Allah’s Apostle, “O Allah’s Apostle! I do not become clean (from bleeding). Shall I give up my prayers?” Allah’s Apostle replied: “No, because it is from a blood vessel and not the menses. So when the real menses begins give up your prayers and when it (the period) has finished wash the blood off your body (take a bath) and offer your prayers.”

The prophet would kiss his wives when fasting

and perhaps took bath together naked in fasting as well?

Volume 1, Book 6, Number 319 :
Narrated by Zainab bint Abi Salama
Um-Salama said, “I got my menses while I was lying with the Prophet under a woolen sheet. So I slipped away, took the clothes for menses and put them on. Allah’s Apostle said, ‘Have you got your menses?’ I replied, ‘Yes.’ Then he called me and took me with him under the woolen sheet.” Um Salama further said, “The Prophet used to kiss me while he was fasting. The Prophet and I used to take the bath of Janaba from a single pot.”

Can Menstruation be false? It is from blood vessel and not real menstruation

Volume 1, Book 6, Number 324 :
Narrated by ‘Aisha
(the wife of the Prophet) Um Habiba got bleeding in between the periods for seven years. She asked Allah’s Apostle about it. He ordered her to take a bath (after the termination of actual periods) and added that it was (from) a blood vessel. So she used to take a bath for every prayer.

Ummal Mominin Maimona, during menses would sit with the prophet when he would pray in mosque?

For what reason?

Volume 1, Book 6, Number 329 :
Narrated by Maimuna
(the wife of the Prophet) During my menses, I never prayed, but used to sit on the mat beside the mosque of Allah’s Apostle. He used to offer the prayer on his sheet and in prostration some of his clothes used to touch me.”

Conditional formatting in Excel – Highlight if greater than left adjacent

You might come across a situation where you want to highlight a value if it is greater than its counter its left adjacent value. For example

Col A Col B
1 3
2 1
3 5

In the above case you want to highlight 3 and 5 in column B. There is an easy excel formula for this. Note that in formula you will select single cells not range of cells!

Select col B from B1:B3, go to conditional formatting. This way the condition will be automatically applied to the selected cells. Go to the last option, custom “Use a formula to determine which cells to format”. In the textbox below, writet his formula

= B1 > A1

Do not forget the = sign! Now choose the format of any type you want by clicking the “Format” button. Hope this helped.

Be carefull not use $ sign since this hard codes the cell. For example

=$B$a>$A$1 will do wrong highlighting because it will apply the logic of Cell B1 > A1 and will apply across the selected range of cells. In other words it will not change to B2> A1, B3 > A3 and so on becaue $ sign hard codes the cells in the logic.