Ok... hold your breath guys (and gals) but yours truly has just finished the first draft of an Excel 'User Mode' spreadsheet for the K-1 camera!
I know i know... please... try and contain your excitement!
Many drunken hours was poured into this endeavour, conflicts and bugs are likely to be in the thousands, nonetheless against my better judgement (and reputation!) I shall release it here for testing and feedback here;
https://1drv.ms/x/s!AokJS98l4Lvigcp499TbNrtiQoooyg
( ^ click it)
Ok, so I had to think a little bit about how to best present the spreadsheet and eventually decided to try and mimic the menu system of the camera itself I was modelling after (the K-1 in this case), that way I thought it might be easier for people to fill out fields and not get too lost and confused and easyish to double check that things are filled out correctly before sharing/storing etc.
The only drawback in this regard (that I can see) is that;
a) it's camera specific currently, in this case limited to K-1 users (and perhaps a certain firmware version? I think I'm running the latest)
b) one spreadsheet = one user mode, if you want to create and share 5 user modes that kinda means creating copies of this spreadsheet, renaming them etc. No biggy i figure...
Why did I do this at all I hear you say?! Well... I find 5 User Modes pretty limiting to be honest, I could easily enjoy 4x that many, and whilst the K-1 has an unbelievable amount of customisation available (which I'm only just getting to grips with myself), nothing beats toggling a single click of a wheel to place the camera into a shooting mode/environment that works for that given scenario.
Personally I find myself having to wander off my User Modes frequently to adjust to the event or environment I'm shooting at. Sometimes these adjustments are slight, sometimes quite far off from what I set them too. Afterwards I always wished I could easily revert back... well now you can! Store your User Modes here in this spreadsheet for quick reference, as a baseline from which to return to.
I also really like the idea of sharing settings we've stumbled across or enjoy using for x,y or z scenarios etc. Perhaps if this idea takes enough traction a User Mode thread will be created (or renewed if one exists already) with feedback and trials of one anothers settings. And in doing so I'm sure a level of learning will occur, which in the end is paramount to all of us achieving the best results. Perhaps through a more in depth sharing of settings some of the more experienced can weigh in with what they see as a potential conflict in a setting to what the mode is actually trying to encompass etc.
Anyway, I created this Excel file for myself, but I wanted to share it with others. It's completely open, nothing password protected. I haven't touched excel in over 15yrs so I was completely rusty at this, I tried to avoid complex formulas where possible, I encourage those with better Excel skills than I to tinker and release better versions (heck start from scratch and do it better! I'd love to see it done better
Cheers and lemme know how you go with it,
Bruce
EDIT: it's also prolly worth mentioning that on first glance I missed out huge chunks also, such as video and playback, I wanted to get onto other 'life' stuff so left it for now to the settings that impact still photography and just the taking of the shot, not the reviewing etc.
EDIT EDIT: New revised version now up, including White Balance, Shooting Modes etc. Please note this is not editable anymore, just download/save and tinker
Last edited by BruceBanner; 03-02-2018 at 06:57 PM.