Tuesday, 17 January 2017

Excel 2013 - Compare two spreadsheets

A few years ago I wrote an article explaining how to use a third-party tool to compare worksheets in Excel 2010, click here to read it. Recently I wanted to do the same but using Excel 2013 and I was pleasantly surprised to find there is a special tool included with Office 2013 that can do this job. The tool is called Spreadsheet Compare, the chances are that if you are an Excel 2013 user, you already have this tool on your computer.

Using the Windows search (press Win-S or click Start and type in the search box) do a search for "spreadsheet compare", it'll come up, run it and you'll see it's a nice straightforward little program. Just click the Compare Files button and enter the Excel worksheets you'd like to compare.

Spreadsheet Compare

In my example above I compared two files and you can see in the lower middle window three changes are listed. One is a spelling correction of Woburn and I've clicked on it - then in the two windows above showing the original worksheets, it moves to that position to show the difference.

Also, Spreadsheet Compare can be started from the INQUIRE tab from within Excel 2013. Just make sure you have the worksheets you want to compare open before running it from there.

For more details including a step-by-step explanation please see the Microsoft page, they've done a good job already so there wasn't a need for me to redo it here. Click the following link (last accessed 17/01/2017):
https://support.office.com/en-us/article/Basic-tasks-in-Spreadsheet-Compare-f2b20af8-a6d3-4780-8011-f15b3229f5d8


Friday, 6 January 2017

Samsung Gear S3 Frontier watch face sunrise/sunset widget showing No Info

The Samsung Gear S3 Frontier and Classic smartwatches both have a watch face called 'Frontier' included as standard. I have the S3 Classic watch and I liked the Frontier watch face, I selected it but then I noticed the sunrise/sunset dial said "No info" - as in the image below:



Issue
It says "No info" in the sunrise/sunset dial, bottom middle.

I pressed where it says "No info" and it told me to add a location on my smartphone. The screenshot below is from my smartphone at this point:


I added my location but it told me I had previously done that! I tried many times but no luck. It was still saying "No info" on my S3.


Solution
On the smartphone, open the Samsung Gear app:


Press Settings | Apps

On the Apps page press the Weather cog/gear icon (as shown above)


Press Use current location

Make sure it is set to On (as shown in the example above)

NOTE: Before setting it to On do read the message on the 'Use current location' screen (shown above). Make sure you understand what it will do, if you are worried about your location information being used by others then do not use this feature.

After setting 'Use current location' to On, check your Gear S3:


You can see in the images here that the sunrise and sunset is shown in the dial on the watch face.


I hope that was helpful :-)

Wednesday, 4 January 2017

Samsung Gear S3 and Honor 7, compatibility and my experience so far

The Samsung Gear S3 smartwatch (Classic and Frontier) is probably the best one the market at the time of writing, January 2017. But before you buy one, is it compatible with your smartphone? The following is a link to Samsung's official compatible phones list:
http://www.samsung.com/global/galaxy/gear-s3/device-compatibility/

The Huawei Honor 7 is not listed (January 2017) in the above Samsung compatibility list but don't worry, it does work*. I have the Honor 7 and I am using it with the Gear S3 for a couple of weeks without any serious issue. You must install the Samsung Gear app and pair it with your S3. Two other background apps are installed during this process; SamsungAccessoryService and Gear S Plugin. Optionally you can install S Health too.

Honor 7 and S3 Classic

I haven't explored all the features of the S3 yet but so far so good. For example, I have Viber and other notifications on my S3. I have installed many new watch faces, the calculator and timer apps. I'm happy, the S3 is great!


One minor issue
On the odd occasion I've found that the Bluetooth disconnects from the phone to the watch. I believe this is because of the power management software on the Honor 7 closing the SamsungAccessoryService app or at least prompting me to close it and because I don't pay enough attention, I just press Close.

To fix this I have changed the following settings:
Honor Phone Manager 
- Battery manager (press the battery icon) 
-- Consumption Level 
--- Background

You should see the SamsungAccessoryService app in the list. It's possible to close it, if you do you'll see your S3 is disconnected. Instead, press the SamsungAccessoryService, you'll see the following screen:


As shown above, I disabled Power-intensive prompt and I enabled Keep running after screen off.
This will keep it running and it will stop bothering me with messages saying it is using power. I think this will do the trick. I'll update this article in a few days with news.

Update 13/01/2017
It works, the above was the solution. Since making that change and allowing the SamsungAccessoryService to keep on running, my bluetooth connection has not dropped at all.

There was one occasion when my Honor 7 informed me that the Gear S Plugin was using a lot of battery power:


It is the same issue as I had seen before with the SamsungAccessoryService app previously. In this case I pressed Don't remind me again, it has the same effect as going into the Phone Manager Battery Manager and disabling the Power-intensive prompt.


*DISCLAIMER
I make no guarantees about anything. The S3 works with my Honor 7, I do not guarantee yours will. My views are unofficial and purely my own. I'm just writing my experience in case it can be useful to others.