zOwie Omega Discussion Forum

I have recently had a few requests for my accuracy trending excel spreadsheet that I wrote a few years ago. I have just now added some minor improvements and am happy to send a copy to anyone that requests it.

I guess getting my new GMT made me want to update the spreadsheet. In fact the version I will send has one month's worth of my new Omega GMT data in it. It will help you understand how to use it, should you request a copy.

If you are one of the folks who has already has it and uses it then you will appreciate the fact that now you do not have to "manually" update the graphs as you add more data. You can just copy your original "start date", "end date" and "error" data columns and paste them in the new version and the graph on the graphs page will give both current error trend and overall average trend automatically.

Below is the email note that I send to all who request the spreadsheet:
**************
This email is being "blind copied" to many people, so please excuse me if the instructions are too simple for you. I don't know how much Excel knowledge everyone has....ok

My suggestions:

1) Copy the file and save the original.
2) Look at the example data and read all the comments first (put the cursor over the cells with small red triangles in the upper right hand corner to make the comments show up)
3) Look at how changing some of the data will affect the graph page. For example, put in an error of 40 sec. in cell M9 and then look at what happens to the graph. You may have to change the scales of the Y-axis if your watch has more significant error per day than -3 to +4 sec. per day.
4) Note that one timing test cannot start without ending the one before.
5) As you can see, you enter data into the green-colored cells ONLY. Everything else is calculated by the built-in formulas.
6) Note that you must synchronize the watch for each test.
7) Note that the graph ignores the time span BETWEEN tests. So if you do not want to test anymore, but then decide to test a month later, the graph will NOT have a big "blank" space.
8) Please make suggestions or improvements and send them back.
There is some "false" data already there to show you how it works. Just email if you have any questions.

Have fun,

Mark Canon