Welcome To Devils Workshop!!!

How to embed Excel Worksheet in Microsoft Word
Karaoke on YouTube videos with Tubeoke
Tips for Getting Google Adsense Account Approved
Subititles & TV Out for iPhone/iPod Touch video

How to embed Excel Worksheet in Microsoft Word

Posted: 08 Apr 2010 09:00 AM PDT

One of the best things about Microsoft Office suit is that files from each application can be embedded into each other. For example you can embed Microsoft Excel Files in Microsoft Word or Powerpoint. It will even copy the formulas that you used in your Microsoft Excel worksheet.

To embed Excel worksheet in Microsoft Word, follow the simple steps shown below:

1. Open Microsoft Word and navigate to Insert > Object.

word-excel-1

2. Once you will click on object, a new window will popup showing you different types of files you can import to a word document.

word-excel-2

3. Select Microsoft Excel Worksheet and click OK. It will make a new Excel spreadsheet for you to work on.

word-excel-3

4. And it will embed an Excel Worksheet in Microsoft Word.

word-excel-7

But there is another way which can be used to embed an excel worksheet in Microsoft Word.

1. Open Microsoft Word, click on the drop down menu in the quick access toolbar and select "More Commands".

word-excel-4

2. Open the "Choose commands from" drop down menu and select all commands. Now, find "Excel Spreadsheet" from the list of commands, click Add and apply.

word-excel-5

3. It will show a small Microsoft Excel spreadsheet icon in the quick access toolbar.

word-excel-6

4. Click on the small excel icon and it will embed a new excel spreadsheet for you to perform any operation you want to.

word-excel-7

You can also check out How to add Watermarks in Microsoft Word and how you can add Windows Calculator in the quick access toolbar.

Cheap Domain name | Dreamhost Wp Hosting 50$ discount

This Post How to embed Excel Worksheet in Microsoft Word is Published on Devils Workshop .

Karaoke on YouTube videos with Tubeoke

Posted: 08 Apr 2010 06:29 AM PDT

I do not always download a song or buy CDs. Sometimes thanks to a decent connection many songs are already up on You Tube to listen to. So sometimes I would open a website which looks up lyrics of a song and then play the song on You Tube to sing along. I guess that is a way to Karaoke with You Tube. One way is to look up You Tube Captions but that is not usually always available especially with music videos.

Now with Tubeoke there is not need for searching for a song on YouTube and lyrics.com simultaneously. TubeOke does it both for you.

About Tubeoke

Just enter the name of the song you want to watch with You tube and search it with Tubeoke.
You will get some options and selecting one will allow you to view lyrics on the right and the song playing on the left of the screen.
Now you can view the song on YouTube and also sing along with the lyrics. I have tried it with quiet a few songs and did not find any song that could not be found.

If you have the song as a file on your computer then you might want to look up lyrics plugin for Windows Media Player and Winamp. Do give Tubeoke a try and drop in your comments to let me know if you liked it?

Also let us know of any other service or plugin which is useful for playing songs and singing along.

Link: Tubeoke

Cheap Domain name | Dreamhost Wp Hosting 50$ discount

This Post Karaoke on YouTube videos with Tubeoke is Published on Devils Workshop .

Tips for Getting Google Adsense Account Approved

Posted: 08 Apr 2010 01:50 AM PDT

After a lot of waiting I finally got my Adsense account approved yesterday. I had bought a domain some six months back and was trying for an Adsense account since then. But every time my application was rejected with a message "Unacceptable site content".

When I got this message for the first time, I thought there had been some mistake since my site has all the legitimate content. With time I realized the reason behind the rejection and also gathered some useful tips which can increase the chance of approval of your application significantly. Some of these are pretty obvious while others do not occur at the first thought.

But before that let me clear that "Unacceptable Site Content" does not necessarily mean you have written something which is in Google's black list. It only means that your site does not follow one or more of Google's Terms and Conditions.

Tips for getting Google Adsense account approved

Apply with top level domain i.e. instead of applying with www.mywebsite.com/blog, apply with www.mywebsite.com.
Apply only after your domain is at least six months old. This is necessary to ascertain that you are not a spammer.
In this period of six months, try writing as much good and original content as you can, which will help you get traffic.For if you don't have a decent traffic there is no point having ads on your blog. Also concentrate on getting backlinks from top sites by writing guest posts and commenting on do-follow blogs. You can read some nice tips on link building to get an idea. Since Google generally updates page rank once every three months, this is the time to get a decent page rank, which will indirectly help you in adsense approval. Read how to optimize your blog for a better page rank.
When providing personal information in Adsense program, use the same information which you have used during domain registration. This is necessary because Adsense team verifies it with the whois data of your domain.
While registering try to go for at least 2 years registration because this again ascertains the fact that you are a serious blogger and not a spammer looking to make some quick money. Spammers generally register their domain for 1 year.
I don't say that if you have registered for 1 year, Google won't approve your request. But you will definitely be eyed with suspicion.
It is difficult now to get adsense approval for blogs with .blogspot.com attached to it. Even if you blog on blogspot try to use a custom domain. It doesn't cost much. Godaddy, Ilovethisdomain and Namecheap are some good options to consider.
If even after following these tips your account is not getting approved, try to apply through other established services like Google Knol, hubpages etc.

Hopefully after following these tips you'll be able to get your Adsense account approved. But once approved do not click your own ads as this will result in a permanent ban from Adsense.

Once you are done you can look up how to show Adsense with Blogger and showing Adsense Ads on Wordpress blogs.

Do write in your comments and share with me what you think are best practices for getting your adsense account approved.

Cheap Domain name | Dreamhost Wp Hosting 50$ discount

This Post Tips for Getting Google Adsense Account Approved is Published on Devils Workshop .

Subititles & TV Out for iPhone/iPod Touch video

Posted: 08 Apr 2010 01:48 AM PDT

The best way to get soft-subtitles on your iPhone / iPod Touch video which you can switch ON/OFF & watch these videos on your bigger TV! Read ahead…

There are many users who are not well-informed of the fact that video on iPhone/iPod Touch has support for soft subtitles. This is nothing else than subtitles which you can switch on or off as you want. It is similar to the VLC player (or any such player). And other type we can call as Hard-subtitles that are rendered on a video layer through editing software.

Converting video & adding subtitles:

I found this open source video converter called HandBrake, which gives me an option to convert my video of any format for iPhone/iPod Touch as well as I can separate layer of subtitles along with it! This is a feature of iPhone OS but with a limitation for customization, such as font size, shadow for text, etc.! But we may expect them in next version of iPhone.

That is it! You’re done with getting the subtitles on your iPhone Video.

I am attaching few screen-shots below to show, how it looks like once converted and saved, on your iPhone’s/Ipod Touch’s video app.

Below is a screen-grab of the software interface. I did not have a mic so there is no narration to this

HandBrake Screen-grab

Watching videos on your TV

Once you’re done with getting those videos & with or without subtitles on an iPhone, you may would like to watch them on TV!

To see these videos on TV, you need a Composite AV Cable for iPhone/iPod touch. If you plan for buying an original Apple cable then it will cost you around Rs. 2500/- (personally I think, this is too much!). You may also buy Component Video Cable which is even expensive at around Rs. 3500/-. The difference in these cables is mentioned later in this post.

Since I have Composite AV cable, I will tell you in reference with the same!

This cable can then be attached to your dock (charging slot) and connect other ends, which are RCA connectors to your TV. (video + audio left + audio right inputs). This cable comes with a USB connector as well. So your iPhone is charging while watching videos on TV.

Another interesting thing is, you can listen to your songs on TV speakers & can see photo slide-shows on a bigger screen!. Not just that, if you’re having a nice audio system attached to this TV – then you can enjoy these songs on a larger speakers. This will save a lot of money as you will never need to buy expensive branded speakers which are marketed especially for iPods.

The price tag of original Composite AV cable is high, so I thought of searching for an alternative. And no surprise I found it on Ebay India’s website. I bought it for Rs. 375/-.

If you plan to buy a non-Apple cable then please note these points mentioned below:

Apple has changed the way this AV Composite cable work since iPhone operating system version 3.0.

The idea is to block duplications and promote original cables.

To do this, Apple has inserted a chip inside such cables, and your iPhone OS is going to read it. If it matched then only you can see videos on TV.

Most of the cables on Ebay India worked with operating system version 2.2.1. As I already hadupgraded my OS version to 3.1.2 , this non-Apple cable did not work for me. I kept receiving error “This accessory is not supported”.

I made that shop owner realize this & also told him the modifications I had to do when I upgraded to 3.1.2. Maybe since then this particular cable isn’t available with him anymore on Ebay. You may find it on alternative shops.

So if you buy them and they don’t work then you already know the reason! I have the details how make them work! I cannot include it here otherwise this will become a too long post and difficult to read!

Now, which cable to buy? Composite AV cable or Component AV cable?

Component AV cable consist of 3 connectors, one each for R (Red), G (Green), B (Blue) with separate color signals. Which results in a better color output. Read more about component video here. This type is available only in newer hi-def TV sets.

Composite AV cable combines all these RGB video signals into one combined signal. & 2 other connectors to give you stereo audio output. This is clearly visible on cables as we can see only 1 connector that gives you video output / input. Read more about composite video here. This is available on almost all the TV sets we have! Also on newer TV sets.

Now we know the difference about the cables. If you see the images below – there is no difference in input connectors that goes into your TV.

The only difference in the cables below is at other end which is to be connected to your iPhone / iPod touch.

One that I marked as Correct: This goes into your charging dock. This cable works with almost all the iPhones & iPod touches.

The one which is marked as Not Correct: This type of cable is not a Component cable. The connector goes into your headphone jack! This type do not work with iPhone / iPod touch! Our local genius stores labeled it as component cable & they sell it for cheap. I am unsure but I guess these type of cables only work with classic version of iPods!

See these images:

We’ll go through the details later for: How to use cheaper cables for your latest iPhone OS? Why Jailbraking is interesting? How to watch your iPhone applications and games on TV? Is jailbraking legal? And related topics which I personally experienced so far.

However, I would like to post them only if you’re interested & find it useful !
So feel free to ask in comments and I would like to hear

Enjoy.

Cheap Domain name | Dreamhost Wp Hosting 50$ discount

This Post Subititles & TV Out for iPhone/iPod Touch video is Published on Devils Workshop .