PDA

View Full Version : E-M1 Mkii Menu settings spreadsheet


Gwyver
21st November 2016, 05:48 PM
The attached file provides an Excel spreadsheet for recording your camera's menu and custom settings when you configure it to suit your shooting preferences.

This s'sheet may be unnecessary in view of the statement at the end of the Readme file for the new release of the Olympus CameraUpdater program i.e. "Ver. 2.0 November 1, 2016
* Latest settings/Mysets can now be saved and loaded."

However it might be that you still wish to have a readable record of your camera's configuration, in which case I hope you find this useful.

Some caveats:

Unlike Greg Bloor's spreadsheet for the original E-M1, this version does NOT use pictograms to represent the camera controls & functions.
As a result it is much simpler to use the Excel range Hide/Expand tools to focus on & navigate (through the ~350 rows) to those areas of the settings which are of most interest.

If you find any significant errors/omissions please let me know.

This ZIP file contains a single .xlsx spreadsheet file, and the spreadsheet does NOT include any macros.

210161227 Spreadsheet updated to v1_00. Thanks to 'Lester' for pointing out the errors in the Custom mode 1 settings.

20170127 Spreadsheet updated to v1_01 incorporating some of mitchellwam's comments - see post 14 for more details.
3883

Here is a version of the settings spreadsheet containing the changes corresponding to Firmware Release 2.0
4550

Ross the fiddler
10th December 2016, 01:54 AM
The other alternative is to print off the Menu pages 165 - 176 of the E-M1 Mk II Instruction Manual (http://cs.olympus-imaging.jp/en/support/imsg/digicamera/download/manual/omd/man_em1m2_e.pdf) & scribble on them.

hoodlum
10th December 2016, 02:56 AM
Also, the latest version of the Olympus Digital Camera Update allows you to save/restore your camera settings. I believe this will only work with the E-M1ii.

This could be useful if you have 2 mkii bodies that share the same settings or if you lose your settings after a firmware update.

Bassman51
16th December 2016, 05:05 PM
FWIW, this will upload just fine into Google Sheets. That makes it each to access from mobile devices like phones and tablets.

Thanks for sharing this with everyone!

G2EWS
18th December 2016, 09:10 AM
Hi Chris,

Thanks for sharing. I have added it to my Shared 'Evernote OMD Notebook'

https://www.evernote.com/pub/g2ews/omd

Best regards

Chris

Gwyver
19th December 2016, 11:40 AM
Also, the latest version of the Olympus Digital Camera Update allows you to save/restore your camera settings. I believe this will only work with the E-M1ii.

...

Be careful, this may not work on every occasion the camera f/w is updated. See: http://e-group.uk.net/forum/showthread.php?p=401386#post401386

Bassman51
19th December 2016, 01:07 PM
Be careful, this may not work on every occasion the camera f/w is updated. See: http://e-group.uk.net/forum/showthread.php?p=401386#post401386

This, of course, is and has always been a ridiculous restriction by Olympus. There's absolutely no reason why the old settings couldn't be remapped into any conceivable new data structure, with new options set to default and no longer relevant options dropped. It's simply laziness in the part of Olympus engineering.

Lester
27th December 2016, 05:31 PM
Nice spreadsheet, thanks!

In the "Custom_Modes" worksheet, the way I read the manual for the custom settings, and the way they seem to come up in my camera, is that C1 is: AF all targets, not single target; C-AF, not S-AF; and SeqL, not SeqH.

Gwyver
27th December 2016, 06:01 PM
Nice spreadsheet, thanks!

In the "Custom_Modes" worksheet, the way I read the manual for the custom settings, and the way they seem to come up in my camera, is that C1 is: AF all targets, not single target; C-AF, not S-AF; and SeqL, not SeqH.

Lester,
Thanks for this. I've included your corrections in v1_00 of the spreadsheet which is now available as a replacement (see tha attachment in the OP).

mitchellwam
26th January 2017, 07:26 PM
Dear Gwyver,

As a newbie to the Olympus world I found your settings spreadsheet to be enormously valuable! In going through it and recording my custom setting I changed a couple of areas to sync with the manual.

I can send you the revised spreadsheet if you would like - however I don't know how to do it on this forum.

I am from the US and member of several Olympus Facebook groups where some members have asked if anyone knows where to get something like your spreadsheet. I can direct them to this site (you'll be getting folks registering from all over the world).

Or I can put the spreadsheet in Dropbox (with proper attribution) and share the dropbox link to interested parties. But only with your explicit permission.

Again thanks for doing this and I look forward to your reply.

PS: I also sent this to the ADMIN account before I realized that I could reply directly to the thread.

Gwyver
26th January 2017, 08:02 PM
Dear Gwyver,

As a newbie to the Olympus world I found your settings spreadsheet to be enormously valuable! In going through it and recording my custom setting I changed a couple of areas to sync with the manual.

I can send you the revised spreadsheet if you would like - however I don't know how to do it on this forum.

I am from the US and member of several Olympus Facebook groups where some members have asked if anyone knows where to get something like your spreadsheet. I can direct them to this site (you'll be getting folks registering from all over the world).

Or I can put the spreadsheet in Dropbox (with proper attribution) and share the dropbox link to interested parties. But only with your explicit permission.

Again thanks for doing this and I look forward to your reply.

PS: I also sent this to the ADMIN account before I realized that I could reply directly to the thread.

You could either...

ZIP your spreadsheet and attach it to a PM to me, so that I can subsequently update the spreadsheet on this site.
Or, if there are only a couple of lines which you think need changing, why not post to this thread with the affected row numbers and a comment on the issues. That way all the existing spreadsheet users will be able to see how to amend their copies (without needing to copy their all data to a new version).

Thanks in advance.

mitchellwam
26th January 2017, 09:02 PM
The changes I made are:

A2/AF Set Home: there is a second level menu:

Function: AF Mode
Default: S1

Function: [All/Single/Cross/Box]
Default: [All]

Function: Zoom
Default: Zoom

B/Dial Function: I added the defaults for Lever Position 2:

Dial Function (F=Front Dial) R=Rear Dial)
P Lever 1: F=Exposure Comp, R=Ps, Lever 2: F=ISO, R=WB
A Lever 1: F=Exposure Comp, R=FNo., Lever 2: F=ISO, R=WB
S Lever1: F=Exposure Comp, R=Shutter, Lever 2: F=ISO, R=WB
M Lever 1: F=FNo., R=Shutter, Lever 2: F=Exposure Comp, R=ISO

D1/Display Content

"Playback Settings" is Changed to "Info Settings"

I believe that these are accurate but would appreciate any comments/corrections.

Thanks

Maria
27th January 2017, 08:32 AM
Thanks for this, I have downloaded it and it should prove very useful with so many possible customisations! I was planning to print out the relevant manual pages and scribble on them - but this is much better.

Gwyver
27th January 2017, 03:44 PM
The changes I made are:

A2/AF Set Home: there is a second level menu:

Function: AF Mode
Default: S1

Function: [All/Single/Cross/Box]
Default: [All]

Function: Zoom
Default: Zoom

B/Dial Function: I added the defaults for Lever Position 2:

Dial Function (F=Front Dial) R=Rear Dial)
P Lever 1: F=Exposure Comp, R=Ps, Lever 2: F=ISO, R=WB
A Lever 1: F=Exposure Comp, R=FNo., Lever 2: F=ISO, R=WB
S Lever1: F=Exposure Comp, R=Shutter, Lever 2: F=ISO, R=WB
M Lever 1: F=FNo., R=Shutter, Lever 2: F=Exposure Comp, R=ISO

D1/Display Content

"Playback Settings" is Changed to "Info Settings"

I believe that these are accurate but would appreciate any comments/corrections.

Thanks

mitchellwam,
Thanks for these comments. I've created an updated version (v1.01) of the spreadsheet. This incorporates the following changes:-

A2 (AutoFocus) AF Set Home:- amended the Default values by adding AF Mode = S-AF, Target Group=All, and changing 'Zoom' to 'Home Position=Centre'.
A2 (AutoFocus) AF Group Custom Settings:-
Changed 'Zoom' to 'Position ↑↓' or 'Position ←→' as appropriate.
Inserted 5 new rows at row 147 to specify 'Set 2' settings and default values.
c) D1 (Display Content):- Changed the function title from 'Playback settings' to 'Playback / Info settings' to better reflect the feature.

I decided NOT to change the Dial & Lever function defaults in B (Button/Dial/Lever) as I think this makes the relevant cell contents overcomplex.

As previously, the updated spreadsheet can be downloaded from the OP.

mitchellwam
27th January 2017, 04:14 PM
Thanks Chris.

I've run across several requests for this type of spreadsheet from folks scattered around the world. Would you like me to direct them to your spreadsheet?

Or I can put it in a dropbox folder (with proper attribution) and keep the traffic off of your UK forum.

Please let me know what you'd like to do.

Thanks again

Gwyver
27th January 2017, 06:49 PM
Thanks Chris.

I've run across several requests for this type of spreadsheet from folks scattered around the world. Would you like me to direct them to your spreadsheet?

Or I can put it in a dropbox folder (with proper attribution) and keep the traffic off of your UK forum.

Please let me know what you'd like to do.

Thanks again

Please direct them to this forum - it means that there will only be one location to maintain an up to date version of the settings spreadsheet.

Also if new users of the spreadsheet visit the e-forum they may decide to join and contribute their Olympus camera experience to everyone on here.
Thanks.

mitchellwam
27th January 2017, 08:42 PM
Excellent - will do.

And thanks again for putting this together.

Vulcan1500
27th January 2017, 10:09 PM
Where can I get a copy of the updated spread sheet?

pault
28th January 2017, 03:53 AM
Go to message #1 of this thread

Vulcan1500
28th January 2017, 05:19 AM
I can download a sheet with some definitions but no spreadsheet. sorry found it.

Jonathans
10th February 2017, 09:10 PM
Chris,
Thank you, Thank you, Thank you!

deejay
5th February 2018, 12:32 AM
Hi Chris,
Many thanks for your Excel spreadsheet for the EM1 MkII and to G2EWS for the excellent Evernote idea.
Wonder if anyone has suggested settings for the custom functions for say, Wedding and Fast-moving things and what they assign Function buttons to. I saw somewhere you can even assign camera on/off to a function key!

Gwyver
5th February 2018, 04:50 PM
Hi Chris,
Many thanks for your Excel spreadsheet for the EM1 MkII and to G2EWS for the excellent Evernote idea.
Wonder if anyone has suggested settings for the custom functions for say, Wedding and Fast-moving things and what they assign Function buttons to. I saw somewhere you can even assign camera on/off to a function key!

Hi deejay
and welcome to the forum.
Not sure about Custom assignments for Wedding photography but, if you search the sub E-M1 Mkii subforum for "BIF" (Birds in Flight) you should find numerous recommendations suitable for what you term 'Fast-moving things'.
The E-M1 Mkii's default Custom settings provide a very basic starting point for action photos - though I'd definitely change the Mode setting in the Custom assignments from 'Program' to either Shutter (or Manual for preference)

This screenshot shows the current state of my Custom Mode settings:
http://e-group.uk.net/gallery/data/500/Em1Mk2_Custom.JPG (http://e-group.uk.net/gallery/showphoto.php/photo/97214)

As for Button/Dial assignments, I have changed the following:
Fn2 = Multi-function (with Home, All Points, C-AF as the sub-settings)
Record = Magnify
Upper Front = Focus Peaking
L-Fn = AF-Limiter
The remaining assignments are as default.

Just a caveat - I'm not an expert/regular action photographer - the above are merely starting points for my occasional forays into wildlife and aviation photography. Many other E-group forum members should be able to provide you with more relaible advice for specific types of photography.
Hope this helps.

deejay
6th February 2018, 11:46 PM
Gwyver, very grateful for these. Will try as a starting point and see how I get on. Lifetime Nikon user (also Fujifilm a bit) but new to Olympus and the EM1 MkII so not confident to shoot a wedding with the Oly yet; appreciate you taking the time to respond. Looks like a great forum!
Thank you again!

Allan_Devon
21st February 2018, 03:32 PM
Thank you for your efforts.
Any reason not to freeze the top title row?

Gwyver
21st February 2018, 04:17 PM
Thank you for your efforts.
Allan,
Thanks for the comments. Glad it is useful for you.
Any reason not to freeze the top title row?
Absolutely not. In fact on the copy I use to record my camera settings I have done precisely that (i.e. frozen the title row). I'll try to include your request next time the spreadsheet needs a 'content' update.

Gwyver
28th February 2018, 03:46 PM
I've created a new version of the settings spreadsheet which includes the changes corresponding to Firmware release v2.0.

To access this see the 2nd zip file in the OP this thread

AZ Mel
27th March 2018, 08:57 PM
Gwyver,
Thanks very much for your spreadsheet; it makes a wonderful learning tool.

Keith-369
6th April 2018, 08:21 PM
I must be really thick :confused: but when I download the link and unzip it, all I see is the spreadsheet user-notes. Could somebody let me know what and where I should be looking for to find this elusive (to me) spreadsheet. *chr

(Somebody else in the thread said they couldn't see it, then said they'd found it ..... but unfortunately didn't say where.)

Gwyver
7th April 2018, 06:00 AM
I must be really thick :confused: but when I download the link and unzip it, all I see is the spreadsheet user-notes. Could somebody let me know what and where I should be looking for to find this elusive (to me) spreadsheet. *chr

(Somebody else in the thread said they couldn't see it, then said they'd found it ..... but unfortunately didn't say where.)

Keith
This spreadsheet contains 3 pages. They are named "Settings", "Custom_Modes" & "Notes".
By design the spreadsheet will initially open showing the "Notes" page (so that new users can see what has changed in the latest version).
You can then select and view the other pages by clicking on the chosen 'Tab' - all of which are located at the bottom left edge of the window. See here:-
(click on this thumbnail to see an enlarged image)
4606
Hope this helps.

Keith-369
7th April 2018, 09:47 AM
Ahhhhh. Thanks Chris, I must be blind *glasses as well as daft :confused:, I can't believe I totally missed the page tabs :o :o

Thanks for the reply and for the sheets. *chr *chr