Posted on June 12th, 2013 No comments
If you have a protected Microsoft Excel worksheet that you can open but can not change the content you can use the following simple code to unlock it.
Note - This DOESN’T work on files that can’t be opened without password.
Posted on June 7th, 2013 No comments
Although it is not official, iOS 7 is almost confirmed to be the main attraction of Apple’s WWDC conference in Moscone Center in San Francisco. In the banner set up in the venue, a huge ’7′ is the only thing that can be seen – indicating the simplicity being the theme of the new version of the mobile operating system by Apple.
WWDC starts next week.
Posted on April 3rd, 2013 No comments
In a latest rumor, Google might be releaseing the new version of Nexus 7 tablet in July 2013. In the new tablet a Qualcomm Snapdragon processor might be used instead of NVIDIA’s Tegra in current generation Nexus 7.
To compete with iPad and other 7-inch tablet, the entry level Google’s tablet will be aggressively priced as low as $149. There are skeptic on the low price as the current price at $199 is still competitive and the device is selling like a hot cake.
Posted on March 29th, 2013 No comments
Facebook has invited reporters in a press event on April 4 to be held in its Menlo Park, California office.
With a message "Come See Our New Home on Android" in its invitation card, speculation of Facebook developing it’s own smartphone based on Android operating system.
Posted on March 16th, 2013 No comments
By default, Microsoft Word can save any word document in HTML format. But, the word processor is notorious in inserting extra information in the files saved by the ‘Save As’ command.
The HTML file it creates is bloated and is full of unnecessary codes. For example, a two lines text in Word resulted into more than 1,000 lines of HTML code.
Posted on March 15th, 2013 1 comment
I am going to start learning animation and I have collected some free tools to start animating. Let’s start by the free tools that I use in starting animation.
Free Animation Tools
Plastic Animation Paper
Plastic Animation Paper (PAP) is a free software package for 2D animation. This is easy to use and useful for basic animation. Download PAP here.
An example of an animation shown in the tutorial of the software is shown below:
Another free animation tool is Pencil. The open source 2D animation/drawing software is available for Mac OS X, Windows, and Linux. The software uses traditional hand-drawn animation (cartoons) using both bitmap and vector graphics.
Download Pencil here.
Posted on March 5th, 2013 No comments
In a month of it’s release, the iOS6 Evasi0n Jailbreak has been installed in 14 million iOS devices. That is twice the amount of devices it was installed in the first 4 days of its release.
Unless jailbroken Apple decides on what can and can’t be done with the iOS devices. The increasing trend of Jailbreaking the devices are defined as the retaliation of the iOS device users seeking to have complete control over their devices.
Posted on January 6th, 2013 No comments
Question: I have a date in format: 30/12/2012 is in ‘A1′ cell and I need an output in the form: Today is 30th December 2012. Can you tell me how I can get the output in Excel?
First let me give you the exact formula to get the desired output. When you enter the date in ‘A1′ cell, you can copy and paste the following formula in B1:
="Today is "& DAY(A1) & "th " & TEXT(A1,"MMMM")& " " & YEAR(A1)
The output I got is: ‘Today is 30th December 2012′
Now, let me present some of the date formula you might find helpful in manipulating the output in Excel. As you can see in the following table, DAY(), MONTH() and YEAR() do work fine but, TEXT() command has a better control over what you get as output.
Formula Output Remark = DAY (A1) 30 Day =TEXT(A1,"D") or "DD" 30 2 digit day value =TEXT(A1,"DDD") Sun Three letter weekday =TEXT(A1,"DDDD") Sunday Full weekday name = MONTH (A1) 12 Month in numeric value =TEXT(A1,"M") or "MM" 12 Month in numeric value =TEXT(A1,"MMMMM") D Month name initial =TEXT(A1,"MMMM") December Full month name =TEXT(A1,"MMM") Dec Three letters of month =YEAR(A1) 2012 Year value =TEXT(A1,"YYYY") 2012 Year value =TEXT(A1,"Y") or "YY" 12 2 digit year value
Posted on January 5th, 2013 No comments
WayBackMachine is a web crawler that stores cache versions of websites. Most of the popular websites are cached by the server and is available for free. This is a great tool to see how a website had been in the past. For example, this domain computernewsreport.com was registered in 2005 but, there wasn’t anything in it. Before we registered the domain, we used to host thee blog in xnepali.com and you can see what it was like in 2007.
Another popular website keeping cache is Google. Google keeps cache to serve when the website is not working. Accessing web-cache in Google is replacing the ‘example.com’ by the website in question:
Posted on December 20th, 2012 No comments
University of Western Sydney is planning to distribute 11,000 iPads to it’s students and faculty in 2013 to enhance their teaching and learning experience. Every student that enroll in 2013 will receive the iPad from the university.
It was reported that the new iPad initiative was one of the parts of a curriculum renewal strategy at the University. In the new curriculum renewal strategy, the university is implementing flexible study options for students for all UWS degrees starting from 2013.