Categories
Blog Tips and Tricks Travellog - Travel Stories

Check these 5 tips before you leave Solo

Whether you are a travel enthusiast or already a wanderer of this mighty earth, some or other important things often missed while preparing for the ultimate trip. Such misses eventually lead to some or other issues which may ruin all the fun.

May I request to pitch in here with some hot tips which can save the day?

  • Travel light is a good idea : You are on solo trip. Common sense says that you are alone. This also implies that no one is there to support you when it comes to handling the packing stuff. Make sure you pack light and carry a backpack with essential items all the time

  • Check the mode of money transactions : Whether you are travelling within country or its a much awaited abroad travel, try to have less cash and rely more on digital transactions. If travelling international, you may wish to inform your bank on international card usage. Most of the banks provide this facility from their internet banking. Apply for a good Forex card, which can save you some transaction fees during your stay in destination country

  • Fun stay while you travel : Since you are travelling solo, you may wish to pick the stay which has some fun element. Choose a home stay, or a hostel. These places have good arrangement which may cost you much less than a hotel. Stay exchange programs are trending these days. You may wish to explore that as well.

  • A good camera phone : A good camera phone can be your life saver. Stunning photos along with right apps which gives you more flexibility is much needed especially when you are travelling solo. I used google translator while was in Taiwan and it makes my life much easier in terms of understanding local language and communicating with local friends.

  • Take insurance : Taking insurance is always a good idea. Within India, it may not add more value but certainly during emergency, Insurance can be your guarding angel. On the other hand, there are countries, wherein Hospitals does not provide services until and unless you are insured. Thus, having a reliance insurance is must.

Above are few hot tips which everyone should add to their checklist before they travel solo. Let me know you views by adding more tips in comment section.

Categories
Blog Tips and Tricks

5 Super hacks for Amazon Fire Stick

I have been using FireTV for more than 1 year now. Several articles have been written to use Fire TV. Can't agree more that all are fit as per the usage however, when we talk about India, many things turn up side down. For India, we have certain limitation that forces us to miss and to use in order to be parallel with the rest of Globe. After dip study and post thorough & various hits & trials, I am writing this blog. Now, you can understand why it took me so long to write this basic and almost outdated post. Nonetheless, I hope the below may add some values. Especially the third point  "Install Third Party Applications on FireTV". To start with, lets see at the basic Tips :

Turning your Phone into Fire Stick Remote

Did you break you FireTV Remote or somehow it’s not working. Sad isn’t it. No worries. It’s time to say thanks to your smartphone. Below tips can save some bucks and can turn you Smartphone into FireTV remote. Follow these simple steps and you are good to go:

  • Go to Google Play Store on your smartphone and download the Fire TV app
  • Login with the same account you used while login to Amazon FireTV
  • The App on your smartphone should show the FireTV name. Click on it.
  • Enter the 4-digit code which will appear on your FireTV screen

Bingo ! Your remote control is ready. Use it.

I hope, I was able to save some of your cash. Wish to do something for me. Like and share this article with others. This may help them getting rid of the issue you faced.

Start Streaming Video Content from your Smartphone

Gone are the days when Chrome cast and Apple TV were the only way to beam the content from an Android phone to HDTV? Amazon Fire Stick support Miracast, which means it lets users to share the smartphone media content.

On Fire TV :

Go to Settings > Display and Sound > Enable Display Mirroring.

On Smartphone

Go to Settings -> Connect or look for option which has Miracast -> Select FireTV

It’s done. Play your content on FireTV now.

Install Third Party Applications on FireTV

I have tried many ways to install third party app. Trust me, none is worth more powerful and useful than “CetusPlay”. You can see many articles on this topic but with experience so far the best is “CetusPlay”. I have used it and am using it as on today. Few Simple Steps and you are good to go. Follow below steps.

On FireTV

Go to Settings -> Developer -> Get both the options on.

Go to About -> Check IP -> Note down FireTV IP somewhere

On your Android Phone

Go to Play Store -> Type Cetus Play -> Download the app with white infinite looking icon filled with Cyan colour background. For ease download CetusPlay from here.

Open app - > Go to top and search Manage Connection

You will see a web and circles - > Tap the fireTV

Bingo ! You are connected.

Remember – Your Android and FireTV should be on same network in order to let CetusPlay identify your Fire Stick.

Within the App -> click on the three lines on top left corner - > Go to App Center (should be the third Option)

Install any app on FireTV just by clicking the Install Button.

Follow instructions on your TV and app is installed.

One more thing, many times the apps will not show in recent apps.

To locate app on FireTV –

Go to Settings -> Application -> Manage Application -> Locate application and launch.

Using this method, you can install “Kodi”, “Lodi”, Terrarium TV, Twitter, Facebook, Games and many more.

Congratulation! You have just converted your TV into a Smart TV using FireStick and Cetus Play.

Cetus Play is a remote control as well. So feel free to use it to control your fire TV. Explore features and let me know in case you find anything more interesting.

Use Fire Stick as a Thumb Drive/ USB Drive

You probably must have some unusable internal memory within Fire Stick. You can make your Fire Stick a thumb drive by installing HD movies. So when your friends have a hangout, bring your Fire Stick with you and enjoy all the fun with this Fire Stick hack. Don’t trouble yourself with any streaming device or hard drives. Just plug your Fire Stick to TV.

Quick Access to FireTV Apps and Settings

Here is a quick Tip. Long press the Home Button and your FireTV should give your options to open apps, settings, display right on the screen.

That's all Folks ! Go ahead, read it, use it and let me know your views in comment section. Also, subscribe to my post to get such information right into your mailbox.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.






See Tips & Tricks Category for more articles.

Categories
Blog Tips and Tricks

9 Most Popular Productivity Extensions for Chrome

Friends, this is my first post on NJ diaries. Thanks to Niraj for providing a platform to share things and stuff we all love!

I am happy to be contributing again after so many years.  Although it’s my work that is prompting me to, but I am sure we all are appreciative of intelligent and insightful content.

I have seen diverse topics being talked off here, so I’ll follow the suit. Hope you’ll enjoy!

Productivity is an issue for most of us today. We love multitasking and multi-focusing. This negatively impacts the quality of work but that’s hardly noticed.

Technology is for all and even our employers have caught up with the trend. We are expected to do more, in less time. Not that human efficiency has increased over the years but we are now complimented by technology, which is helping us to be more productive.

I’ll share an interesting infographic today. It speaks about some of the ‘Most Popular Productivity Extensions for Chrome’.

For a fact, Chrome leads the way among all browsers and across all platforms (Including desktop, mobile and tablet) with a global market share of 54.89%.

Safari and UC browser are next in the list but I’m not hoping the gap to shrink anytime soon. These are the recent browser figures by StatCounter.

No wonder why we have millions of Chrome extensions in the market today. The above stats are sufficient to support this claim. While we would be focusing on some Productivity extensions today, Playstore has it all in all categories.

Check this out. It’s a wonderful piece.

9 Most Popular Productivity Extensions for Chrome

Categories
Blog Tips and Tricks

Clean PC with ease

Do you come across a situation wherein you are out of space in your PC/machine ? You wonder that your PC does not have many applications and your favorite machine has way less free space than what you anticipate. If Yes, then you are at right place and about to read right article.

Before providing solution to the problem, let's understand why this happens at the first place. Any application or tool create temp file each time it is been used. These temp files get stored in Temp folder under Windows/System folder. Till the time you don't remove it manually, it remains there and eats up the space.

Internet is a huge source of information but every time you browse, the webpage create temporary internet files in you C drive. These files consume lots of MB's in your PC.

For every activity you perform on your machine, unknowingly you create unwanted files.

Question is, Do you need to perform cleaning task every time and will it be manual? Here is the good news, by using below code in notepad, this manual process will be an automatic junk cleaner process. Do not forget to subscribe to my blog and get such Tips and Tricks directly in your inbox.

Below are the steps to do :

Step 1 : Open Notepad

Step 2 : Copy and Paste below code in Notepad

REM Cleanup files for Windows 7
REM Cleanup cookies for current user
del "%USERPROFILE%"cookies*.txt
REM Cleanup temp directory for current user
del /s /f /q "%USERPROFILE%"locals~1temp*
rmdir /s /q "%USERPROFILE%"locals~1temp
mkdir "%USERPROFILE%"locals~1Temp
REM Cleanup temporary internet file directories for current user
del /s /f /q "%USERPROFILE%"locals~1tempor~1*
del /s /f /q /a:s "%USERPROFILE%"locals~1tempor~1*
del /s /f /q /a:h "%USERPROFILE%"locals~1tempor~1*
del /s /f /q /a:r "%USERPROFILE%"locals~1tempor~1*
rmdir /s /q "%USERPROFILE%"locals~1tempor~1
REM Cleanup history for current user
del /s /f /q "%USERPROFILE%"locals~1history*
REM Cleanup Windows prefetch
del /s /f /q "%SystemRoot%"prefetch*
REM Cleanup Windows minidump
del /s /f /q "%SystemRoot%"Minidump*
REM Cleanup Windows temp
del /s /f /q "%SystemRoot%"temp*
rmdir /s /q "%SystemRoot%"temp
mkdir "%SystemRoot%"Temp
REM Cleanup recent shortcuts for current user
del /s /f /q "%USERPROFILE%"recent*
REM Cleanup environment varable set temp storage
del /s /f /q "%TEMP%"
REM Cleanup environment varable set tmp storage
del /s /f /q "%TMP%"
REM Cleanup c:temp
del /s /f /q c:temp*
rmdir /s /q c:temp
mkdir c:Temp
REM Cleanup Recycle Bin storage areas
del /s /f /q c:Recycled*
del /s /f /q c:Recycler*

Step 3 : Save this file as Clean.bat and place on your desktop.

Step 4 : Pin this file to Startup folder in program section (can avoid this step)

Step 5 : You are all set done. Clean.bat file once double clicked will open a program which will clean your temp files automatically. Every time, you open your PC, double click the file and the work is done.

Clean Junk batch

 

 

 

 

 

 

 

 

 

I hope, the above article helps you in cleaning your machine with ease. Share your views in comments. Do subscribe to my blog for all such Tips & Tricks.

Categories
Blog Tips and Tricks

3 Awesome ways to master Excel for Beginners

In this blog, I am going to share “3 awesome ways to master Excel for beginners”. My previous blog in Tips and Tricks section, I shared macro to unlock password protected excel sheet. It’s time now to share some more. Use it and see your sheet working for you without any flaws.

#1 Merge cells using this simple VB Code

Merging Cells in Excel has no shortcuts. But as it said, this is Excel and you can probably achieve everything here. Go ahead and try this macro to merge your selected cells

Sub MergeCells1()
Selection.Merge
End Sub

Assign the created macro to a keyboard shortcut and get set to go.

But if wish to merge cells and align it to centre, here you go.

Sub MergeCells2()
With Selection
.HorizontalAlignment = xlCenter
.Merge
End With
End Sub

# Delete undesired Web objects from Copy and paste Excel

Copying content from Web and using it in excel comes with a pain in the form of check-boxes, pictures, logos etc. We do not want that, right. Use the below hack to get rid of such obstacles.

• Hit F5 and Excel will display the “Go To” dialog box
• Click “Special” button.
• Select the Objects option
• Click OK.

This will select a number of the objects in the worksheet. Press the Delete key and you are done.

Since I am obsessed with Macro, I would not leave you here. Go ahead and use below macro and be an expert.

Sub DeleteAllShapes()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
shp.Delete
Next
End Sub

# Remove long trailing space in an excel sheet – Space Prefix

We all download data from software’s. Till the time we don’t use any formula and we need number in text format, we are absolutely good to go. Problem is when we try to use formula and we need numbers. Suddenly, we realize there is a trailing space before the number within the same cell. For 10 or 20 cells, we can do it manually. What if data is more than 1000 in number?

No need to say thanks to me. I am here to help. Use the below macro to solve your problem

• Hit Alt+F11
• Go to Insert and Insert Module
• Paste below Macro

Sub NoSpaces()
Dim c As Range
For Each c In Selection.Cells
c = Trim(c)
Next
End Sub

• Click Save
• Close VB
• Hit Alt+F8
• Click Run

All spaces are removed. Enjoy 🙂

Let me know in comment section if this helped you in solving the problem you might be facing.

Categories
Blog Tips and Tricks

Mobile Chip set – Good to Know information

Before a decade, none of us were likely to take interest in mobile chip sets and the probable reason was less mobile selling competitors in market. Back then, we had limited options and we tend to settle with the available choices. The situation is different now. Mobile companies have grabbed the market.

In today's scenarios, mobile companies have grown like mushrooms and thus providing Consumers lots of options to select and buy latest phones with superior of specifications in budgeted price.

Growing mobile market demands something from consumer too. Consumers are getting smart and yet very far from the basic information's. Rumors and Chinese Whisper often mislead them. You agree with me that when we wish to buy a mobile, we look for Camera, Sound, Speed and ease to use. Camera and Sound is something which we understand. However, chip sets are beyond our reach of understanding. You surf through any mobile specification and you tend to over read the Chip set part. This lead to you into a situation when others knowledge whether true or false makes you build your opinion about a phone.

I will not go too technical in this article instead will try to provide a very basic info related to what is new and what is old. More than 60% of consumer will find this article helpful. If so, please feel free to appreciate the efforts by leaving comment after the blog.

The most commonly used processors in today's mobile phones are Qualcomm Snapdragon, MediaTek, Samsung Exynos, HISILICON Kirin, Nvidia Tegra and Apple Mobile Processors.

No matter what their internal specifications are we care which is new and which is old. The section below is what I promised in earlier paragraphs.

Qualcomm Snapdragon -

Starting from 2005, this US based firm has come a long way in terms of Chip set technology. They started with Snapdragon 1 series and the latest is Snapdragon 800 Series. This does not mean they have more than 800 different variants of Chip Sets. I will quote "S" as "Snapdragon". The series of Chip Sets are S1, S2, S3, S4, S200, S400, S600 and S800. S800 series has already released S800, S801, S805, S808, S810, S820, S821.

Snapdragon 835 is the latest in the league.

MediaTeK

A Taiwanese Chip set Company has its long list of Chip sets variants, capable enough to mislead most of us. Their all series start with "MT" followed with some numeric digits This is again confusing to understand and remember. Somehow, their recent series has a different name along with MT. It's called Helio. Helio X10 also known as MT6795 was first introduced in 2014. Helio P10 (MT6755), Helio X20 (MT6797) and Helio X25 (MT6797T) were introduced in Year 2015. 2016 added one more Variant Helio P20 (MT6757) to the list.

The most latest are Helio X30 (MT6799), Helio X27 (MT6797), Helio P25 (MT6757T) and Helip X23 (MT6797D) scheduled to be released in 2017.

Samsung Exynos

Samsung is a Korean firm and Exynos is their own chip set for mobile phones and Tabs. Several releases are Exynos 7 Dual, Exynos 7420, Exynos 7 Octa 7580, Exynos 7 Octa 7870, Exynos 8 Octa 8890

They started with Exynos 7 Dual and the latest is Exynos 8 Octa 8890

HISILICON Kirin

HISILICON is a Chinese Chip set firm and is growing rapidly among different Chinese mobile manufacturers. Kirin has almost similar number of releases like Samsung Exynos. K3V1, K3V2, K3V2E, Kirin 620, Kirin 650, Kirin 910, Kirin 920, Kirin 930, Kirin 950 and Kirin 960.

K3V1 was the first from HISILICON wherein Kirin 960 is the latest in the list

Nvidia Tegra

We all know Nvidia as Gaming Chip set and Drivers manufacturer and this American based firm had earned our respect in long time. Do you know that Nvidia is also into mobile Chip set manufacturing. They names it as Tegra. Tegra 1, Tegra 3, Tegra 4, Tegra 4i, Tegra K1, Tegra X1 are the chip set variants from Nvidia.

Tegra 4, Tegra 4i, Tegra K1 are mainly used for mobile phones

Last for not the least is Apple.

Apple Mobile Processors -

Apple does not manufacture Chip Set. Instead they have partnership with Samsung and other brands to build their custom Chip Set. .

Apple A series - "A" Series starts with A4 and goes upto A10. Various designs are A4, A5, A5X, A6, A6X, A7, A8, A8X, A9, A9X and A10.

Apple S series – This series is used in Apple Watches. Apple S1, Apple S1P and the latest one is Apple S2

Apple W series - Apple W1 which is used in wireless headphones and AirPods.

Apple T series - The only version released till now is Apple T1 and is designed to use in TouchID sensors in MacBook Pro. .

The designs and variants keep on developing as you must have figures so fat. Stay connected and Subscribe to this page to get more information straight to you Inbox.

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 10 other subscribers.

 

Categories
Blog Tips and Tricks

Android Short Codes – Tips and Tricks

Hi Folks! In my previous post, I shared Trick to remove protection from an Excel sheet. I am sure you must have used it by now. Today, I am going to share almost all short codes which work on an Android Device. I wish that this benefits you all.

##4636##      

Display information about Phone, Battery and Usage statistics

##34971539##  

Shows completes information about the camera

##7594##       

Changing the power button behaviour-Enables direct power off once the code enabled (Use at your own discretion)

##273283255663282##*

For a quick backup to all your media files (All Android Devices comes with auto back-up facility – I don’t know why do want to use this code. But if you wish to, use at your own discretion)

##197328640##     

Enabling test mode for service activity (Use at your own discretion)

##232339## OR ##526##   

Wireless Lan Tests (Use at your own discretion)

##232338##   

Displays Wi-Fi Mac-address

##1472365## 

For a quick GPS test (Use at your own discretion – Good for Android professionals and Android developers)

##1575##   

A Different type GPS test (Not sure if you wish to use or test this. User discretion is advisable)

##0283##    

Packet Loopback test (Do not use this code if you are not aware of advance functionality of Android)

##0##*  

LCD display test

##0673## OR ##0289##      

Audio test

##0842##   

Vibration and Backlight test

##2663##   

Displays touch-screen version

##2664##       

Touch-Screen test

##0588##    

Proximity sensor test

##3264##    

Ram version

##232331##   

Bluetooth test

##7262626## 

Field test

##232337#*#

Displays Bluetooth device address

##8255## 

For Google Talk service monitoring

##49862650468##*     

PDA, Phone, Hardware, RF Call Date firmware info (Check this from Android “About phone” section instead of code)

##1234##       

PDA and Phone firmware info ((Check this from Android “About phone” section instead of code)

##1111##       

FTA Software version (Check this from Android “About phone” section instead of code)

##2222##  

FTA Hardware version (Check this from Android “About phone” section instead of code)

##44336##     

Displays Build time and change list number

*#06#     

Displays IMEI number

##8351## 

Enables voice dialling logging mode

##8350##   

Disables voice dealing logging mode

##7780##   

Resetting your Android phone to factory state-Only deletes application data and applications (Use at your own discretion – Good for Android professionals and Android developers)

27673855#       

Put * before and after 2767. It's a complete wiping of your mobile also it re-installs the phones firmware (Use at your own discretion – Good for Android professionals and Android developers)

Few Tips to amaze friends

  • Did you know that pressing “Build Number” option under Phone Status under Setting for seven times, makes you an Android Developer?
  • Did you know that pressing “Android Version” under Phone Status for three times, gives you Android Logo at main screen

Do share any Tips and Tricks of your Droid in comment Section? I will try to compile all at one place for easy reference.

Categories
Awareness motivational stories Blog Tips and Tricks

Microsoft Excel – Tips to unlock protected sheet

Microsoft Excel is dynamic and intelligent. It's a tool which had been in use widely and will remain in use. And then comes the protection and protected sheet. We often come across sheets which are protected and we can't do anything about it. So nothing to worry my friends. Here comes the code which can unlock the protected sheet in a jiffy. For this, you are not supposed to have knowledge of coding of Visual Basic. Follow the direction below and enjoy the fun.

Open the Excel workbook that has the protected sheet in it. Hit Alt+F11 to view the Visual Basic Editor. Hit Insert-Module and paste this code into the right-hand code window:

Sub PasswordBreaker()
'Published by www.njdiaries.com

Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126

ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub

That's all. Enjoy your excel unprotected workbook. Cheers ! Let me know if this comes a useful tip to you.