TechEngineerTV Blog: October 2016

Sunday 30 October 2016

Video Chat Era Begins: After WhatsApp, Hike upgrades to Video Chat to compete Duos, Skype

Almost a month ago Google announced Duos with a aim to compete Skype on Video Chat segment it was then only have Skype and Google's Hangout on that segment but within a months time two major chatting app WhatsApp and Hike joins the crowded market. WhatsApp Video Chat as of now is in Beta Version soon to be launch, Hike already made Video Chat available in Android soon to be launch in iOS. Hike was testing Video Chat since September with some selected group is now live the feature in the Apps as per the report. Hike App is one of the popular App in India covers over 100 million users from it 95 percentage is Indian users according to the company. Hike is one of the first to make stickers popular and its Indian based stickers are famous among the youths. Now chatting App like Allo which got motivated and implementing stickers are way to go on competing with Hike on its local look.

Image credit: "The Jetsons" Animation Series

Skype and WhatsApp is popular among professionals as both are quite simple and to the task unless like Hike which offers News, Games and many more service under their belt also upgraded to 8 Indian Language which help this App to built a new spot. Today if Google trying to find is place in India then its after following the footstep of Hike only. Although Google will be 1 step away and that is because of Google Assistance but still lots of question mark are there on the future performance and Google needs to answer those with the time. WhatsApp still hasn't rolled the Video Chat officially but it released for Beta Users. As per Beta Users App is not stable and having lots of Bugs hence unless WhatsApp not fix those it won't launch officially by that time line. Overall the era of Video Chat has begin as many Chatting App first moved towards the Voice Chat App and after got upgraded they now moved towards Video Chat.

Pressure for Google Allo and Duos since both App serving the purpose separately. Although Google has added that soon Hangout will be integrated with Chrome so that during conversation Users can have the web access as well. Let see which App dominates on Video Chat since Apps first task would be to provide a platform which can work efficiently through 2G network and then it would consume less battery. IMO App has this Cons but quality of Video Streaming is extremely poor hence this App is not so popular among the youths. Slowly slowly 4G deploying in the Country and after its complete role out surely prices will come down as well in that case companies to wants to join into the race of new innovation with every possible feature it can. There is nothing to hide that soon the way of talking will change and soon Voice call will become the outdated way to connect with each other.

Author of this post is +Anirudha Das, he writes in Tech, Sports, Social, Politics, Business. Follow him on social media at @anirudhasdas

Thursday 27 October 2016

New changes in Youtube, Hostar: After Offline Feature, Resume Feature added

Recently Youtube and Hotstar leading OTT platform from STAR INDIA launches the Resume feature which indicates subscribers that exactly when they left watching the video. For Youtube if users are login into the system and watching any stuff and then for some reason left the videos in between then after login back if user watches the same video it will get resume from the moment it left. This is now officially rolling out and this great feature is quite helpful for those who orders the movies from Youtube. Its quite painful in Youtube sometime ago when you wanted to watch videos in between you scroll the pointer in the timeline you wanted but at the end it keeps on loading because of slow connection and then till that timeline unless and until entire video won't be loaded nothing would run that period of time was so frustrated that you must have feel that better you watch it same again by putting data on the line. This practice consume lots of Data, Time and Effort. Since Youtube becoming the one stop destination for youths it is quite obvious Youtube fixing the issue which might be painful for the youths.

Similarly even Hotstar following the footstep of Youtube after Offline feature they too launches the Resume feature. Hotstar slowly - slowly becoming the one such platform for youths to watch paid and free contents after Youtube, including sports, movies, music, tailors and series from STAR and HBO Originals they're putting a efforts to bring everything under one roof hence implementation of any such feature would be blessing. Number of Public Wifi are increasing day by day even Reliance Jio going to launch paid Wifi packs which will help youths to download their favorite contents from the apps and watch it offline at any time as per the convenience. Youtube already included the features like low resolution videos in low speed connection it means they're in verge to end the buffering from the videos as if its may be compromised with the quality but atleast should work and play. Many companies are luring people by bringing night datas by aiming to this smart offline downloads, leading telecom company of India Airtel even made a tieup with Youtube so that subscribers can mark the videos for offline and with night data one can easily download the video and can enjoy anytime.

Resume Feature

Now whenever you gonna check any history of video you have watched before you will found that a red strip is now visible which is a indicator that how many videos you have watched and duration of it. Whenever you will click back to those videos you will found that the videos will continue from where you have left. Thats a great implementation by Youtube as it will not consume enough of data and effort. Similarly even Hotstar too launch this feature you may not able to see any such indicators in almost all videos but regarding the playback it will resume from the same its been left.

Offline Feature

Earlier a year ago Youtube successfully launched Offline feature which is now adopted by Hotstar from STAR INDIA as well. Offline Feature in Youtube was not available before in every videos but slowly they has pushed it in every uploads. Similarly in Hotstar as well you can very easily downloads movies and series and watch it any time. This will help subscribers to be flexible with datas also will be a push for Night Data Packs which is possibly going to be a future hot pick recharges from Telecom Companies.

Whenever you founds a settings icon in the video means that video is available offline and you can download it for future viewing. The same icon can be found in Hotstar as well although they themselves will recommend you regarding it. So its not tough to understand about it and not a toughest to find the option.

These videos are also available on different available qualities. Normally every phone supports HD ready resolution of 720 p hence maximum videos highest quality resolution will be 720 p and not more then that. Size is also differ according to the resolution hence you always have a option which one to choose for and best suitable for viewing.

You can later watch these videos in separate options like Offline Videos or Download option in Hotstar. Until and unless video license are available from content provider you can watch it at any time as many time as you can thats the coolest part of such offline features because many time you like to watch same videos again and again in different mood of time as well in that case you will find the video and cost your data to replug it is not something you likes about. Hence its a savior for viewers and hats off for the effort made for the same.

Author of this post is +Anirudha Das, he writes in Tech, Sports, Social, Politics, Business. Follow him on social media at @anirudhasdas

Wednesday 26 October 2016

Add, Substract, Replace Values etc. via Paste Special in MS Excel

Sunday 23 October 2016

Find Values via LOOKUP Formula in MS Excel

Thursday 20 October 2016

Using of Paste Special in MS Excel

Monday 17 October 2016

Using of RAND and RANDBETWEEN in Microsoft Excel

Monday 10 October 2016

Made By Google: Google's new project to battle

Oct. 4th big announcement was made and that is off what Google's new child project is termed as "Made By Google". A attempt of Google to conquer the hardware segment and also to make a push of software with their innovative plannings. Google has bought a lot of products in their recent "Made By Google" Event. After having a successful outing with Nexus with different Manufacture partners first time Google jump to have their own phone known as Pixel, have done on Vlog on Google Pixel and can find out What Google is offering with all new Google Pixel ? Google bought other products as well in the event like a late attempt in VR segment but looks to be promising, Google Home a Google Assistant which reached quite near to people now and ready to serve the people more effectively and more efficiently by connecting all Smart Device with the Google Home and let Google understand you with your voice and done the job for you as per the command given to it, Google Wifi too launched with a thought in a mind that one Wifi is enough to connect all the devices in the home with the proper internet speed, more stronger Chromecast launched with 4K Support can find out more about these devices in our segment of Made By Google Vlog.

Google never tried and thought regarding the hardware division hard though they did bought the struggling Motorola but despite of going forward they sold to Lenovo may be they thought that its not feasible to run the thing which was never of their cup of Tea or might be they don't wants to take a extra pressure to maintain the brand like Microsoft did bought Lumia but ultimately struggled to boast the brand or even struggling to maintaining it as Former Nokia currently Microsoft Lumia struggling for its existence. Google may tries to bring lots of innovation in the market and even moved with OS upgrades as well but one think Google realized that they will not get any independence of what they tries to bring regarding the software in the market, they always have to face the manufacturer companies custom upgrades which may excludes Google's some of the essential Apps to be out of the list. As we all know Android One and Nexus is one such projects which Google got some free hands they wanted but still its a collaboration with the manufactures and not the individual project completely.

After material design Google has upgraded every by default app and introduced some of the Apps like Inbox, Allo, Duos are famous among them and even promoted as well the reason being of its importance, Inbox App is a newest platform of Gmail, Allo the new Chatting App, Duos the new Video Chatting App despite of having a existing Apps Google bought the new Apps which might they have a Independence in a innovatory part but not in a Hardware part ultimately their hard work not treated like what they're expecting for. Google might needed it desperately because of series of updates in Apps, launching new ones and ofcourse a new OS. Google must be wanted the independence in Hardware segment as well must be wanted the planning control in Storage related allocation when they rolls out the new innovation. There will be only Google interface and no other interaction of Manufacturers personal UI and choices of App. It means Google will have the full control of devices.

Storage is a one such issue Google is getting challenges even to rolling out the updates, Android is a partner company for the Manufacturer as they have taken a license for the OS but to keep the brand Manufacturer companies put their own discovery and get clubbed with the OS they have licensed with Google. For Google they too can't expect a full fledged independence on the entire process of the device as Manufacturers are more efficient then Google in this part. Its not like Google will even think about it many time as they have a license to provide support not a duty to maintain the mobile model. Bringing Hardware division home is also kind of strategic planning as whenever leadership changes the thinking to work also changes probably Sunder Pichai thinks that its a right time to face their major competitors from all department or might be thinking is changed on Google's efficiency that they can handle the pressure to being in hardware segment and even if its fail then they're always a one step ahead from the competitors on software segments or keep doing for what they known as Silicon Giant.

Keeping eyeing on biggest competitor of Google and that is Apple who're keeping their fans a full of excited with all new iPhones in 1 or 2 years timeline so that people remain engaged and never thinks about switching as their first targets are youth and gadget freaks who never settles down for one piece always wants to remains upto date in that case Apple fans are always waiting for the new series and numerical no. continues with magical figures in business as well. Chinese brand like Mi too coming with findings of their own although taken a support from Google but the UI on their phones are designed by Mi only. It is good for Google to be remain doing for what they're known for and conquer something which they wants to. They have lots of patent and even unsuccessful products but yet by innovation they sets the bar no matter it might be a commercial failure. From Google Glass to Google Car they keeps on innovating to make sure that Google rules in a market for the company like Google they surely wants to see in a space of a Mobile Division and in a smart products which supports their dream project Google Assistant. No matter as per reports Google Pixel may be build with the support of HTC but atleast they have the brand which has Google Logo and known as with Google brand and comes under their Child project Made By Google.

Author of this post is +Anirudha Das, he writes in Tech, Sports, Social, Politics, Business. Follow him on social media at @anirudhasdas