I found the spreadsheet useful, but I was used to the old D200 spreadsheet which limited the entries in various fields to those selections available in the camera. So I transmogrified this spreadsheet to do that. The overall format is the same, although I have added some comments at the bottom.
The cells all contain the default values for the camera. When you change a cell to another value, the cell is highlighted in yellow, so you can see what you have changed. However, the bank names (and the comment) work the other way: the default is no name (no comment), and it is highlighted in yellow to remind you to put in a name or comment. If you put in too many characters it is highlighted in red.
I think I have checked all the entry and formatting, so if anyone finds a problem, let me know.
Thanks both Jim and Dwight. This is what good forums, organizations, and people are all about. Thanks to the both of you for sharing. I find this very helpful and it saved me time. "I knew there was a reason why I joined the Nikonians!... I hope I can return the favor and contribute soon as well.
>I found the spreadsheet useful, but I was used to the old >D200 spreadsheet which limited the entries in various fields >to those selections available in the camera. So I >transmogrified this spreadsheet to do that. The overall format >is the same, although I have added some comments at the >bottom. > >The cells all contain the default values for the camera. When >you change a cell to another value, the cell is highlighted in >yellow, so you can see what you have changed. However, the >bank names (and the comment) work the other way: the default >is no name (no comment), and it is highlighted in yellow to >remind you to put in a name or comment. If you put in too many >characters it is highlighted in red. > >I think I have checked all the entry and formatting, so if >anyone finds a problem, let me know. > >https://www.nikonians.org/forums/user_files/88289.zip > I have been using D200s but today I received my new D700. When first setting them up I found the spreadsheet for the D200 a great help and have been looking for a similar aid for the D700. I suspect that your spreadsheet for the D3 will, in many/most regards, be applicable to the D700. Just how close remains to be seen. When I was using the D200 S/Sheet, I inserted columns after most of the defaults/suggestions and entered "my" settings adjoining the authors. However because of what I assume is your password protection, I am not able to do this with your S/Sheet. Would you be agreeable to withdrawing that protection, or doing whatever else to allow me to add extra columns? Regards Bob
Now that the firmware update appears to have settled down I added the new settings to the D3 spreadsheet.
Note that the description of the firmware update states that default for Vignette control is Normal and default for Focus point brightness is Normal. However, after I upload the updated firmware the camera was set to Vignette control Off and Focus point brightness Low.
The spreadsheet still needs some work. In particular, I don't have a wireless transmitter or a GPS, so settings for those menu items still have to be defined.
Since you can save the D3 settings to a CF card, that's probably the best way to keep things in line. HOWEVER, if you save it on the card you use for taking pix, a reformat will wipe out the settings. Therefore I think it's useful to have the spreadsheet as a backup.
I saved the settings to my CF card, then transferred the file to my computer to back it up. I'm kind of on the lookout for a really cheap CF card that I can save the settings to and keep in my camera kit. I'd prefer a small size memory card so I won't be tempted to use it to take pictures on. 128 MBytes or less would be nice.
Sun 06-Jun-10 03:52 AM | edited Sun 06-Jun-10 03:53 AM by Pursuit
You can "save camera settings" which saves a file on your primary flash card. This saves most (but not all) of your current camera settings. You can then later "load camera settings" to restore those settings.
I load camera settings before every major shoot. I have a standard set of camera settings saved on every CF card I own.
And, as far as I know, there is no way to get the excel settings into your camera. I keep thinking I should write a program to do it, but somehow I never find the time.
I am upgrading to a D3s, should be here first part of next week, I utilizied the spreadsheet from the D300s Forum that had catagories for ladscape, portrait, sport etc. and found that to be very good. Does this spreadsheet do the same thing, I printed it out....an I missing something? Thanks.
>Have I missed something here? Aren't all 4 banks identicle? > >I had the spreadsheet for the D200, each bank was set up for a >particular subject, sports,portraits etc...
This was not meant to be a set of suggested settings, rather just a place to keep your settings. Everyone will have their own ideas of what their settings should be, so we didn't want to produce a one-size-fits-all type of file.