Even though we ARE Nikon lovers,we are NOT affiliated with Nikon Corp. in any way.

English German French

Sign up Login
Home Forums Articles Galleries Recent Photos Contest Help Search News Workshops Shop Upgrade Membership Recommended
members
All members Wiki Contests Vouchers Apps Newsletter THE NIKONIAN™ Magazines Podcasts Fundraising

D7000 Configuration Settings and Set-Up Spreadsheet V.2.2

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author
chroaz Silver Member Nikonian since 26th Apr 2009
Fri 07-Jan-11 01:16 AM | edited Sun 06-Feb-11 10:29 PM by dm1dave

Last year I adapted a spreadsheet created by Nikonian Scott Winders (and which was inspired by Don McVey) to record the settings for my D300s.

I recently got hold of my D7000 and have completely re-writtten the spreadsheet for the D7000. It is still very much a work in progress, but I am happy to share it with other Nikonian D7000 shooters.

It is a zipped interactive Excel Worksheet (.xls) with a number of tabs that allow the user to set-up and record settings for any of 4 preferred shooting situations, as well as recording the Camera's Defaults and reference links to explanatory pages in the D7000 Users Manual.

Although I believe it is fairly intuitive (at least to me!), it is also quite complicated - as is the D7000 itself - so I would suggest you first click on the "Introduction" tab, which explains how it all works.

If you have any suggestions as to how this can be improved, and/or find any errors, please email them to me on the link which can be found on the "Introduction" tab in the spreadsheet.

I hope this is helpful, but please be aware that any of the "opening settings" in the 4 "banks" in the various tabs of the worksheet are for illustrative purposes only and in no way constitute a recommendation or suggestion as to how you should set up your D7000 - only you can determine the best/preferred settings for your individual shooting situations.

Please click the link below to download the file >>

Verison 2.2.2 (Jan 31, 2011)
https://www.nikonians.org/forums/user_files/187242.zip


Verison 2.2.2 (Jan 31, 2011)
for Apple's iWork - Numbers
https://www.nikonians.org/forums/user_files/187243.zip


Enjoy!

Chris
Attachment#1 (zip file)
Attachment#2 (zip file)

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

briantilley

Paignton, UK
30235 posts

Click to send email to this author Click to send private message to this author

#1. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2a" | In response to Reply # 0

briantilley Gold Member Deep knowledge of bodies and lens; high level photography skills Donor Ribbon awarded for his support to the Fundraising Campaign 2014 Nikonian since 26th Jan 2003
Fri 07-Jan-11 07:28 AM

Many thanks, Chris. This should be very popular!

Brian
Welsh Nikonian

vladman

London, UK
27 posts

Click to send email to this author Click to send private message to this author

#2. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2a" | In response to Reply # 0

vladman Registered since 25th Jun 2009
Fri 07-Jan-11 09:12 AM

That looks really useful, I'm going to have a good play with this! Many thanks for your effort in creating and sharing this.

Visit my Nikonians gallery.

wingnutt

NZ
7 posts

Click to send email to this author Click to send private message to this author

#3. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2a" | In response to Reply # 2

wingnutt Registered since 02nd Jan 2011
Fri 07-Jan-11 03:24 PM

Awesome thank you very much
Im sure lots of us noobs will study it with interest

b1234s

Winter Garden, US
97 posts

Click to send email to this author Click to send private message to this author

#4. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2a" | In response to Reply # 0

b1234s Registered since 05th Dec 2010
Fri 07-Jan-11 06:29 PM


>
>I recently got hold of my D7000 and have completely
>re-writtten the spreadsheet for the D7000. It is still very
>much a work in progress, but I am happy to share it with other
>Nikonian D7000 shooters.
>

Looks like a lot of work went into this spreadsheet. Thanks very much for sharing.

jadiniz

Estoril, PT
350 posts

Click to send email to this author Click to send private message to this author

#5. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2a" | In response to Reply # 4

jadiniz Registered since 25th Dec 2010
Sat 08-Jan-11 09:17 PM

Great work, a whole lot better than I'd have done by myself. Thanks for making this available.

http://egozarolho.blogspot.com
1. Good content, good aesthetics and good tecnique. On that order.
2. Light is more important than glass and pixels.
3. In the digital photography process, software is as important as gear.

larrycurrlymoe

Middle Sackville, CA
454 posts

Click to send email to this author Click to send private message to this author

#6. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2b" | In response to Reply # 0

larrycurrlymoe Silver Member Nikonian since 13th Feb 2009
Sun 09-Jan-11 05:20 PM

Chris thanks o much for proving this valuable tool! Unfortunately, your 4 favourite situations are not covered by mine.
Has anyone “discovered” (accidently or through much experimentation) what they deem to be an “optimal” low light configuration?
I am an amateur wildlife shooter and as a result I end up on the end of day light spectrum and would appreciate what others have found to "work" for them.
Thanks in advance for any replies.
(in order to not affect this thread, a private email would be greatly appreciated.

Turbo

turbostrackandtour.blogspot.com

JosephK

Seattle, WA, US
7064 posts

Click to send email to this author Click to send private message to this author

#7. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2b" | In response to Reply # 6

JosephK Silver Member Fellow Ribbon awarded for his excellent and frequent contributions and sharing his in-depth knowledge and experience with the community in the Nikonians spirit. Nikonian since 17th Apr 2006
Sun 09-Jan-11 05:31 PM

Check out the wildlife forum. The folks there should be able to get you suggestions that will give you a starting point for experimenting to see what works best for you.

---------+---------+---------+---------+
Joseph K
Seattle, WA, USA

D200, 17-55mm f/2.8 DX, 70-200mm f/2.8 VR, 50mm f/1.4 D
18-70mm f/3.5-4.5 DX, 70-300mm f/4-5.6 ED, D70S

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#8. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2b" | In response to Reply # 0

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 09-Jan-11 05:49 PM | edited Sun 09-Jan-11 11:07 PM by dm1dave

A fellow Nikonian pointed out an error in the Picture Controls pick-lists, which I have now corrected, along with making a few other corrections and adjustments.

This new Version 2.2 is available by clicking the link below (perhaps Dave or one of the Moderators could adjust the link to point to the Nikonian servers - thanks!).

Version 2.2 is link has been moved to original post.

If anyone finds any other issues or has any suggestions please send them to me as I shall be updating this from time to time.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#9. "D7000 Settings Configuration Spreadsheet" | In response to Reply # 6

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 09-Jan-11 10:01 PM | edited Sun 09-Jan-11 10:05 PM by chroaz

Hi there, Larrycurleymoe - you can change the 4 "banks" to include whatever settings you think are appropriate to your shooting situation. So if "Wildlife" is what you want to record settings for, just click on heading for a shooting situation you don't need (say "Wedding Photography") to bring up the pick-list to the right of the cell, and then select "User Defined". That will change the heading to "User Defined" and you can select whatever settings you would like in the cells below that you think appropriate for your "Wildlife" shoots. You will just have to make a note that in this case (your case) "User Defined" = "Wildlife". You can do this for all the headings if you like.

A future version of this spreadsheet tool will allow you to enter the text of your choice in the "User Defined" headings cell.

Enjoy,

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

output555

US
339 posts

Click to send email to this author Click to send private message to this author

#10. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2b" | In response to Reply # 8

output555 Silver Member Nikonian since 29th Aug 2008
Mon 10-Jan-11 01:23 PM

As a happy D7000-owner who's still learning to love this camera, I'd like to say thanks very much for this information. You get a gold star for your efforts and generosity!

mdallie

Novi, US
238 posts

Click to send email to this author Click to send private message to this author

#11. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

mdallie Silver Member Nikonian since 02nd Jan 2011
Sat 22-Jan-11 07:50 PM

I'm on a free trial to the Nikonians, but after reviewing this spreadsheet I've decided to upgrade to a paid membership. This is excellent work. Thank you so much.

Mike

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#12. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 11

chroaz Silver Member Nikonian since 26th Apr 2009
Sat 22-Jan-11 08:45 PM

Hi Mike - Welcome to the Nikonians! You'll find it a terrific resource ... by the way there will be an updated version of the spreadsheet soon, correcting some of the typos and expanding some functionality.

Enjoy!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

DinoCardelli

Plantation, US
236 posts

Click to send email to this author Click to send private message to this author

#13. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

DinoCardelli Registered since 19th Oct 2010
Sun 23-Jan-11 02:13 AM

Great Stuff !!!

Thank you...

I have a friend at work...is there anything similar for a D90 that you know of?


DC

Visit my professional gallery.

mdallie

Novi, US
238 posts

Click to send email to this author Click to send private message to this author

#14. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 12

mdallie Silver Member Nikonian since 02nd Jan 2011
Sun 23-Jan-11 12:17 PM

Thanks, Chris. I'll keep an eye out. I assume it will be posted on this thread.

Mike

Mike

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#15. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 13

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 23-Jan-11 02:39 PM

DC / Mike - Yes, any updates will be posted here and pinned at the top of this thread.

I don't know of anything for the D90 - but the D300 and D300S, yes!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Photobilly

Austin, US
104 posts

Click to send email to this author Click to send private message to this author

#16. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Photobilly Silver Member Nikonian since 22nd Nov 2002
Sun 23-Jan-11 05:08 PM

Thanks Chris, I just bought a D7000 and this will really help. Do you have one for he D700?

Bill Wendlandt
Nikonian in Austin, TX USA

Visit my Nikonians gallery.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#17. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 16

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 23-Jan-11 07:13 PM

No, sorry Bill, I never got around to doing one for my D700 before I sold it.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

pwarbeck

Tucson AZ, US
254 posts

Click to send email to this author Click to send private message to this author

#18. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

pwarbeck Registered since 25th May 2009
Mon 24-Jan-11 04:06 PM

I opened the worksheet in Open Office Calc v3.1.1 running on Windows 7. The dropdown menus on the yellow cells all contain a single item "0", rather than the list of other choices for the given parameter (see screenshot). I wonder if anyone else has experienced this, and can suggest a workaround.


Visit my gallery on 23hq



Click on image to view larger version


Attachment#1 (jpg file)

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#19. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 18

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 24-Jan-11 04:55 PM

Pwarbeck - Sorry can't help you with this one. It runs fine in Excel on Windows and Mac OSX, and in NeoOffice for Mac.

I am working on a Mac Numbers version as well, which is nearly completed, but have no experience with Open Office Calc, as it was really designed for Excel.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

pwarbeck

Tucson AZ, US
254 posts

Click to send email to this author Click to send private message to this author

#20. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 19

pwarbeck Registered since 25th May 2009
Mon 24-Jan-11 05:39 PM

Aha! I upgraded to the latest Open Office (3.2.1) and the menus are working.

Visit my gallery on 23hq

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#21. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 20

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 24-Jan-11 06:54 PM

Great - glad it worked out!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Sockeye Salm

Anchorage, US
59 posts

Click to send email to this author Click to send private message to this author

#22. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 21

Sockeye Salm Registered since 30th Dec 2004
Sun 30-Jan-11 08:54 PM

I feel like a dummy, but all I can open is the instructions and an explanation of the spread sheet. I'm sure I'm missing something simple, but can someone help me out.

John

(Sockeye Salm)

mdallie

Novi, US
238 posts

Click to send email to this author Click to send private message to this author

#23. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 22

mdallie Silver Member Nikonian since 02nd Jan 2011
Sun 30-Jan-11 09:39 PM

The instructions are on the first tab. On the bottom you will see the other tabs. Go to them for the settings.

Mike

Sockeye Salm

Anchorage, US
59 posts

Click to send email to this author Click to send private message to this author

#24. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 23

Sockeye Salm Registered since 30th Dec 2004
Sun 30-Jan-11 10:49 PM | edited Sun 30-Jan-11 10:52 PM by Sockeye Salm

There are no other tabs that I can see. I must be missing something. Can you be more specific. By the way I'm using Windows XP.

John

(Sockeye Salm)

mdallie

Novi, US
238 posts

Click to send email to this author Click to send private message to this author

#25. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 24

mdallie Silver Member Nikonian since 02nd Jan 2011
Sun 30-Jan-11 10:57 PM

Excel has worksheets. They are like pages in a workbook. Usually at the bottom (I'm using the newest version, so I guess it is possible they are at the top of the worksheet rather than at the bottom in your version), there are tabs with names you can click to move from worksheet to worksheet.

Mike

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#26. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 24

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 30-Jan-11 11:16 PM

John - attached is a screen grab of what the spreadsheet looks like when opened on your computer (Intro page/part) - note the tabs along the bottom "Introduction", "Pre-Shoot set-up", "Setup menu" etc. These are the tabs you use to select the different worksheets. Hope this is clear for you.

Chris

https://www.nikonians.org/forums/user_files/186640.pdf

Attachment#1 (pdf file)

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Sockeye Salm

Anchorage, US
59 posts

Click to send email to this author Click to send private message to this author

#27. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 26

Sockeye Salm Registered since 30th Dec 2004
Mon 31-Jan-11 10:21 AM

Now I have it! I opened a regular blank spreadsheet on my computer, and had all the tabs, and ability to scroll right. Then I realized all I had to do was resize this document to show the bottom toolbar which was hidden to me when I opened the settings spreadsheet. I knew I would feel dumb once I figured it out.

John

(Sockeye Salm)

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#28. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 01-Feb-11 02:52 PM

A new version of the D7000 Settings and Configuration spreadsheet for Excel has now been posted (v.2.2.2) which will run on Mac and Windows systems. A second version created on and for Apple's iWork - Numbers '09 for Mac has also been posted. This file will actually open when unzipped as showing v.1.0N. Both files were posted to the OP on 1/31/11. Mac users please note that Numbers for iPad is not yet able to run this file with all its functionality.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

mdallie

Novi, US
238 posts

Click to send email to this author Click to send private message to this author

#29. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 28

mdallie Silver Member Nikonian since 02nd Jan 2011
Tue 01-Feb-11 03:34 PM

Thanks, Chris!!!

Mike

SoCal Dave

Marina del Rey, US
290 posts

Click to send email to this author Click to send private message to this author

#30. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 28

SoCal Dave Silver Member Charter Member
Sun 06-Feb-11 05:39 PM

Attachment #1 is missing! I get HTTP 404 or a Nikonians error message saying it may heve been moved. Perhaps when the Apple one was posted something happened???

"Content is King"
www.davidvoss.500px.com

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#31. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 30

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 06-Feb-11 08:24 PM

Will try to fix the link - but you can also download it from here:

http://dl.dropbox.com/u/12844510/D7000_Settings_Excel_v2.2.2_gen.xls.zip

Cheers!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

dm1dave

Lowden, US
13623 posts

Click to send email to this author Click to send private message to this author

#32. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 30

dm1dave Administrator Awarded for high level knowledge and skills in various areas, most notably in Wildlife and Landscape Writer Ribbon awarded for his excellent article contributions to the Nikonians community Donor Ribbon awarded for his very generous support to the Fundraising Campaign 2015 Nikonian since 12th Sep 2006
Sun 06-Feb-11 09:30 PM

The links in the OP have been fixed.

Dave Summers
Nikonians Photo Contest Director
My Nikonians Gallery | Current Nikonians Contests

Click on image to view larger version

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#33. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 32

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 07-Feb-11 02:30 PM

Thanks, Dave!

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

texaz

US
32 posts

Click to send email to this author Click to send private message to this author

#34. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

texaz Silver Member Nikonian since 08th Feb 2011
Tue 08-Feb-11 07:54 PM | edited Tue 08-Feb-11 07:55 PM by texaz

That was an awesome post, and thanks for all the work you put into it.

I like it so much, I attempted to print it.

Note to self and to others: do NOT try to print the spreadsheet! My printer printed out about 700 pages before stopping, even after I cancelled the job on my PC.

I should have known better, and I know it's my fault, but it's a major PIA.

texaz

Visit my Nikonians gallery.

Visit my Nikonians gallery.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#35. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 34

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 08-Feb-11 08:47 PM

Ooops, Texaz! Actually you can print it quite easily if you would like to. Just set up the print area you want on each worksheet and it will print out only what you select. Also you could save a page as a .pdf and print that way too, or even via a "screen grab" - lots of different ways. But 700 pages....wow, I don't think that would be good!!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

texaz

US
32 posts

Click to send email to this author Click to send private message to this author

#36. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 35

texaz Silver Member Nikonian since 08th Feb 2011
Tue 08-Feb-11 09:58 PM

Thanks, croaz!

texaz

Visit my Nikonians gallery.

Visit my Nikonians gallery.

Visit my Nikonians gallery.

baines11

US
16 posts

Click to send email to this author Click to send private message to this author

#37. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 36

baines11 Registered since 12th Feb 2011
Sat 12-Feb-11 11:02 AM

Thank You!!!!

zarwolo

US
2 posts

Click to send email to this author Click to send private message to this author

#38. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 37

zarwolo Registered since 03rd Jan 2011
Fri 18-Feb-11 02:14 AM

Excellent! Nice work!
Thanks for sharing!

Visit my Nikonians gallery.

cwcoffman

Sacramento, US
53 posts

Click to send email to this author Click to send private message to this author

#39. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

cwcoffman Silver Member Nikonian since 30th Apr 2010
Mon 21-Feb-11 09:54 PM

Thanks so much, Chris. I am hoping to get my D7000 on Wednesday. I am anxious and overwhelmed. So much to check out and learn. So much fun. Your spreadsheet will be a great place to start.

C W Coffman

If there's no photo, it didn't happen.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#40. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 39

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 21-Feb-11 10:34 PM

Congratulations and enjoy your D7K - learning is half (or more of) the fun!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Roman_Mongin

Sydney, AU
2 posts

Click to send email to this author Click to send private message to this author

#41. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Roman_Mongin Registered since 14th Feb 2011
Mon 28-Feb-11 07:23 AM

Awesome ! Very useful !

Thank you very much for that

Roman

OneRoadPictures
www.oneroadpictures.com
www.photosaustralie.com

cerban

US
1 posts

Click to send email to this author Click to send private message to this author

#42. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

cerban Registered since 06th Mar 2011
Thu 17-Mar-11 11:33 AM

thanks! this is really cool!! I had something similar handwritten in a notebook, but what I like about this one is that I can make changes of my own. Thanks again for sharing

Rick_Smith

US
88 posts

Click to send email to this author Click to send private message to this author

#43. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 42

Rick_Smith Registered since 07th Jan 2011
Wed 23-Mar-11 04:43 PM

I'm just a little confused what this spread sheet is for....

Is this spread sheet a list of suggested settings to get good pictures from the D7000...or is a spreadsheet to help you rememeber the changes you made to your camera?

I see blanks, and I see settings...so I'm a little confused. Feedback appreciated.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#44. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 43

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 23-Mar-11 05:11 PM

Rick - the spreadsheet was put together as a means to record YOUR settings from the myriad of configurable settings available on the D7000 - and notably Pre-Shoot Set-Up, Shooting Menu, and Custom Menu choices. It is an interactive tool that allows you to select from the options available in the camera, using the Nikon menu structure/choices. In other words it makes your life simpler to record the settings you use.

I have also provided for 4 configurable "Banks" (as per other Nikon DSLR's - 300S for example), where you can set up for 4 different shooting scenarios, 2 of which can be stored in the U1 and U2 positions. You can name these whatever you want, to set up them up for the shooting situations you encounter most. The headings I used are just suggestions.

I also referenced each setting to its corresponding explanation in the User Manual.

So, in answer to your question - it is an interactive "Aide Memoire" to facilitate you recording the settings you like to use for your given shooting situations - easily, and conveniently. In your words ".. to help you remember the changes you made ..".

The provided spreadsheets (Excel and Numbers) are NOT suggestions for settings (although they have been initially set at settings that may seem logical for some) - everyone will have their own preferences - they merely provide a convenient way to record your settings and find further information on those settings from the User Manual. They are not a "How to", however.

Hope this helps.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Rick_Smith

US
88 posts

Click to send email to this author Click to send private message to this author

#45. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 44

Rick_Smith Registered since 07th Jan 2011
Wed 23-Mar-11 05:21 PM

>Rick - the spreadsheet was put together as a means to record
>YOUR settings from the myriad of configurable settings
>available on the D7000 - and notably Pre-Shoot Set-Up,
>Shooting Menu, and Custom Menu choices. It is an interactive
>tool that allows you to select from the options available in
>the camera, using the Nikon menu structure/choices. In other
>words it makes your life simpler to record the settings you
>use.
>
>I have also provided for 4 configurable "Banks" (as
>per other Nikon DSLR's - 300S for example), where you can set
>up for 4 different shooting scenarios, 2 of which can be
>stored in the U1 and U2 positions. You can name these whatever
>you want, to set up them up for the shooting situations you
>encounter most. The headings I used are just suggestions.
>
>I also referenced each setting to its corresponding
>explanation in the User Manual.
>
>So, in answer to your question - it is an interactive
>"Aide Memoire" to facilitate you recording the
>settings you like to use for your given shooting situations -
>easily, and conveniently. In your words ".. to help you
>remember the changes you made ..".
>
>The provided spreadsheets (Excel and Numbers) are NOT
>suggestions for settings (although they have been initially
>set at settings that may seem logical for some) - everyone
>will have their own preferences - they merely provide a
>convenient way to record your settings and find further
>information on those settings from the User Manual. They are
>not a "How to", however.
>
>Hope this helps.
>
>Chris

Thanks so much - this helps a ton! Do you know of any resources online that you have seen that would help me find a starting point on settings for my D7000. I take mostly snapshots of photos of my family around the house, going on walks, etc....I have found there are so many options on how to set the camera that I have become lost on how to find the the best combo. I know this is subjective, but I'm curious if there are some pretty standard agreements out there on some of the settings. (I know Ken Rockwell suggest setting the picture controls a certain way, but I have read that many people don't agree with his choice of settings.

I have become a little discouraged because almost everyone says to shot Raw for everything - and so I do...but there is so much work to get the photo adjusted (from trying to get all the different settings correct on the camera, and then spend all sorts of time adjusting in raw to get the picture to look just as "good" as my old jpegs used to look before I can then try to get them to be better then those.....so I feel like there has to be a pretty good set of standard settings so I can just pick up the camera and shot when friends are over, or I'm out with my family, without having to spend so long just to get the camera and post production correct to get one picture....

I've read so much "stuff" online that I have probably read to much...if that makes sense.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#46. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 45

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 23-Mar-11 05:36 PM

A couple of places to start:

Mike Hagen at Out There Images has a suggested set-up guide for the D7000 which you can download from his website www.outthereimages.com - click on the Publishing tab and scroll down to find the Guide.

Also Thom Hogan is a terrific resource on just about everything you'll need. His website www.bythom.com will answer many of your questions and he has a new book just out for the D7000 which will be a very valuable resource for you. I just got it, and its very complete.

You can shoot very fine JPEG's with a D7000 which will do for just about anything and be "instantly" shareable. If you are "into" post-processing - and sometimes, for some, this is an integral part of photography (just as the dark room was for film) - then you will want to shoot RAW. Of course you can do both, and remember every Nikon RAW file embeds a basic JPEG.

I either shoot RAW only or RAW+JPEG Normal, depending on the situation.

Enjoy your D7000 - it is a fantastic camera, but it does have a learning curve ... and that is half the fun!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Rick_Smith

US
88 posts

Click to send email to this author Click to send private message to this author

#47. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 46

Rick_Smith Registered since 07th Jan 2011
Wed 23-Mar-11 06:36 PM

>A couple of places to start:
>
>Mike Hagen at Out There Images has a suggested set-up guide
>for the D7000 which you can download from his website
>www.outthereimages.com - click on the Publishing tab and
>scroll down to find the Guide.
>
>Also Thom Hogan is a terrific resource on just about
>everything you'll need. His website www.bythom.com will answer
>many of your questions and he has a new book just out for the
>D7000 which will be a very valuable resource for you. I just
>got it, and its very complete.
>
>You can shoot very fine JPEG's with a D7000 which will do for
>just about anything and be "instantly" shareable. If
>you are "into" post-processing - and sometimes, for
>some, this is an integral part of photography (just as the
>dark room was for film) - then you will want to shoot RAW. Of
>course you can do both, and remember every Nikon RAW file
>embeds a basic JPEG.
>
>I either shoot RAW only or RAW+JPEG Normal, depending on the
>situation.
>
>Enjoy your D7000 - it is a fantastic camera, but it does have
>a learning curve ... and that is half the fun!
>
>Chris

Hey thanks! I'm actually trying to set up the setting for point and shoot now. I have a question though - it says to use program mode and then to turn the auto iso on..however when I try to do that - auso iso is grayed out..it wont let me...how can I get this to work??


Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#48. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 47

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 23-Mar-11 06:58 PM

Rick - ISO Sensitivity auto depends on the exposure mode you're using. In Program and, I think, Aperture Priority modes, ISO isn't changed until the exposure gets to the extremes of either end of the shutter speed range - normally 1/30 - 1/4000.

You can set ISO manually by pressing the ISO button on the back of the camera and rotating the Main Command Dial to the ISO you want (viewed on top LCD or rear screen when info activated).

You can set Auto ISO in the Shooting Menu >> ISO sensitivity settings >>Auto ISO sensitivity control ON (or OFF).

Also note that If the mode dial is rotated to P, S, A, or M after AUTO is selected for ISO sensitivity in another mode, the ISO sensitivity last selected in P, S, A, or M mode will be restored.

Hope this helps!

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

KnightPhoto

Alberta, CA
4954 posts

Click to send email to this author Click to send private message to this author

#49. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 47

KnightPhoto Gold Member Nikonian since 18th Dec 2006
Fri 25-Mar-11 01:58 AM

The grayed out "Auto" setting is misleading. When in "P" you don't set Auto in the menu section where you normally set a numerical ISO value. Choose a numerical value like 400 for point and shooting.

Then once you set 400 you are returned to the "ISO sensitivity settings" screen. Lower down on this screen set "Auto ISO sensitivity control" to "On".

Set the next choice "Maximum sensitivity" to "1600".

And finally set the "Minimum shutter speed" to "1/320s".

This combination makes a decent point and shoot mode that will cause the camera to oscillate ISO from 400 to 1600, all the while maintaining wherever possible a decent 1/320 shutter speed.

The only time the other grayed out Auto choice you refer to is available is when you have the camera in full (green) auto mode.

One difference between P and full green auto is that while in P mode the flash will not pop up on it's own.

If I am not being clear feel free to ask!

The other thing is low ISO purists will set the numerical ISO to start at 100 rather than 400. But D7000 ISO 400 is so good that I wouldn't worry too much about setting 400 as your start point. The benefit of 400 is that the camera will be more inclined to give you an even faster shutter speed than 1/320 and give you more action stopping power.


Best regards, SteveK

'A camera is an instrument that teaches people how to see without a camera.' -- Dorothea Lange
My Nikonians gallery
My Nikonians Blog

Voltan

MY
18 posts

Click to send email to this author Click to send private message to this author

#50. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Voltan Registered since 27th Feb 2011
Sun 03-Apr-11 01:03 PM

Lovely! A big thank you.

Voltan

JillyH

jillyh, US
24 posts

Click to send email to this author Click to send private message to this authorClick to send message via AOL IM

#51. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 49

JillyH Registered since 12th Nov 2006
Tue 05-Apr-11 08:28 AM

Hi,

I'd just like to add my thanks to Chris and the others who have posted on here. I've spent some time with the Spreadsheet and Mike Hagen's settings and did some test shots. I am extremely pleased with how this has simplified my life, helped me to understand my camera better, and most of all improved my photos!! There are so many settings on a D7K and I think at times I would inadvertently change one, not fully understanding the repercussions, or maybe change something and forget to ever change it back again. Mike Hagen offers a file with settings that can be loaded onto the D7K and I think it will be very helpful to be able to save the settings I've selected, then load them onto the camera routinely when I start shooting so that I'll be starting from the same place each time. So far, this is really helping me a lot!!!
Thanks so much for the information posted here!
Jill

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#52. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 51

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 05-Apr-11 04:00 PM

Jill - so glad you found this useful!

If you do use Mike Hagen's (or others) settings file do remember to change the Copyright and Image Comment fields once you've uploaded it to the D7000K - otherwise all your photos will be marked with his name!!

Enjoy your D7000!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

JillyH

jillyh, US
24 posts

Click to send email to this author Click to send private message to this authorClick to send message via AOL IM

#53. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 52

JillyH Registered since 12th Nov 2006
Tue 05-Apr-11 04:46 PM

Chris,

I already found that out...the hard way. After loading the settings I discovered that the first three letters of my file names were MJH, instead of DSC as before. I was totally stumped for awhile, because that's my initials. I couldn't imagine how those settings could discover my initials!!! LOL! Now I'm guessing Mike's middle name might begin with J.

That's one reason why I say I learned a lot about my camera in taking the time to go over all the settings, including the one's that had Mike's name inserted in the comment/copyright information.

Once again, thanks for your help!

Jill

arizonadesertrat

US
5 posts

Click to send email to this author Click to send private message to this author

#54. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

arizonadesertrat Registered since 18th Apr 2010
Sun 17-Apr-11 06:48 PM

Thanks for the spreadsheet.
I'm surprised you don't recommend remapping the AEL/AFL to AF-ONLY.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#55. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 54

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 17-Apr-11 10:40 PM

Thanks for your interest in the Configuration Settings Spreadsheet for the D7000.

Actually I do use the "Back Button Focus" method myself - however this Spreadsheet is meant as an aid just to layout out the various (and numerous!) settings available for the D7000, and is not a recommendation for any particular set of settings per se - that's up to the user to choose to suit his or her shooting preferences.

Enjoy!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

birdied

Destrehan, US
894 posts

Click to send email to this author Click to send private message to this author

#56. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

birdied Gold Member Laureate Ribbon awarded for winning in the Best of Nikonians 2013 images Photo Contest Nikonian since 06th Sep 2009
Thu 12-May-11 10:30 AM

Thank you so much for this spreadsheet. I am going from D300 to the D7000 and never dreamed there would be such a learning curve . My D300 shutter went out with only 25,000 shutter actuations. Could not imagine being without a camera for many weeks , so purchased the D7000.

I shoot mainly macro and shoot manual . I am really having a hard time with grabbing focus with the 7000 and getting a sharp shot. Guess it is going to take some time.
Appreciate all the time this must have taken to put together.
Birdie

Choices Matter

jaystudios

Swanzey, US
21 posts

Click to send email to this author Click to send private message to this author

#57. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

jaystudios Registered since 25th Aug 2007
Wed 18-May-11 02:05 PM

This is great, thank you so much!

dbaileyuk

UK
3 posts

Click to send email to this author Click to send private message to this author

#58. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 57

dbaileyuk Registered since 30th Apr 2011
Sun 29-May-11 09:13 AM

Thank you for this,
I'm sure I will get some use out of it.

pjr

Manotick, CA
2246 posts

Click to send email to this author Click to send private message to this author

#59. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

pjr Registered since 26th Dec 2005
Fri 10-Jun-11 11:41 AM

Thanks very much for this Chris!

Phil
A Canadian Nikonian
My portfolio: www.pjr99.500px.com

pjr

Manotick, CA
2246 posts

Click to send email to this author Click to send private message to this author

#60. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

pjr Registered since 26th Dec 2005
Fri 10-Jun-11 11:41 AM

Thanks very much for this Chris!

Phil
A Canadian Nikonian
My portfolio: www.pjr99.500px.com

epeake61

US
3 posts

Click to send email to this author Click to send private message to this author

#61. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

epeake61 Registered since 13th Jun 2011
Tue 14-Jun-11 08:07 PM

Wow, that's a great tool! Thanks for putting the sheet together.

Evans

Crowndog

US
4 posts

Click to send email to this author Click to send private message to this author

#62. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Crowndog Silver Member Nikonian since 17th Jun 2011
Sun 19-Jun-11 12:47 PM

I just aquired my D7000 and although not new to Nikon or photography find all this quit a lot to digest. Your wonderful spreadsheet logically organized what is going on in the pages of the manual, for me. I do have a question: Is it possible to make your setup in the spreadsheet and then download it to the camera? Please take into account I am a neewbie to this camera and this forum. Again thank you for this exhaustive effort.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#63. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 62

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 19-Jun-11 03:21 PM

Hi Crowndog - Glad you found the Spreadsheet helpful.

No, it is not possible to download the settings from the spreadsheet direct to the camera, if that is what you meant. However it is possible to setup your camera settings as you like them (you would use the spreadsheet to determine those and experiment with different settings in camera), and save those settings to a special file on your memory card which has to be called NCSETUP7.

See Page 244 of the manual for how to do this and what settings are in fact saved. This allows you to save a copy of your settings (to load later in case you reset your camera etc.), and it's the method to use if you want to load settings that may have been created by other photographers who are prepared to share their setup with you.

By the way I keep a couple of "older" small capacity SDHC cards solely for this purpose.

Hope this helps. Enjoy your D7000!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Crowndog

US
4 posts

Click to send email to this author Click to send private message to this author

#64. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 63

Crowndog Silver Member Nikonian since 17th Jun 2011
Mon 20-Jun-11 12:41 PM

Thank you again! Can't wait to get started.

Visit my Nikonians gallery.

MartinDBaker

Northampton, UK
10 posts

Click to send email to this author Click to send private message to this authorClick to send message via AOL IM

#65. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 64

MartinDBaker Registered since 25th Jul 2011
Tue 09-Aug-11 06:31 AM

A great resource! Many thanks for this.

redbaren

Lafayette, US
19 posts

Click to send email to this author Click to send private message to this author

#66. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

redbaren Silver Member Nikonian since 26th Jul 2011
Tue 09-Aug-11 01:22 PM

WOW! This is great.
"somebody" spent a lot of time and effort on this.

Thanks.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#67. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 66

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 09-Aug-11 03:59 PM

Yup! Thanks, glad you found it useful.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

mawyatt

Clearwater, US
14 posts

Click to send email to this author Click to send private message to this author

#68. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 67

mawyatt Registered since 08th Jul 2011
Tue 09-Aug-11 10:20 PM

This is great,

Thanks

hagnik

UK
4 posts

Click to send email to this author Click to send private message to this author

#69. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

hagnik Silver Member Nikonian since 16th Mar 2011
Tue 23-Aug-11 05:47 PM

Hi Chris
I am new to Nikonian. I am new to D7000, can you help me how to use your set “"D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" I have down loaded on my computer what show I do next.
Thanks
Hagnik

Visit my Nikonians gallery.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#70. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 69

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 23-Aug-11 07:05 PM

Hagnik -Welcome to Nikonians and to your D7000!

As per post #44 in this thread, the spreadsheet was put together as a means to record YOUR settings from the myriad of configurable settings available on the D7000 - and notably Pre-Shoot Set-Up, Shooting Menu, and Custom Menu choices. It is an interactive tool that allows you to select from the options available in the camera, using the Nikon menu structure/choices. In other words it makes your life simpler to record the settings you use.

I have also provided for 4 configurable "Banks" (as per other Nikon DSLR's - 300S for example), where you can set up for 4 different shooting scenarios, 2 of which can be stored in the U1 and U2 positions. You can name these whatever you want, to set up them up for the shooting situations you encounter most. The headings I used are just suggestions.

I also referenced each setting to its corresponding explanation in the User Manual.

So, in answer to your question - it is an interactive "Aide Memoire" to facilitate you recording the settings you like to use for your given shooting situations - easily, and conveniently to help you remember the changes you made to your camera's settings.

The provided spreadsheets (Excel and Numbers) are NOT suggestions for settings (although they have been initially set at settings that may seem logical for some) - everyone will have their own preferences - they merely provide a convenient way to record your settings and find further information on those settings from the User Manual. They are not a "How to", however.

Hope this helps, Hagnik,

You might also check this link to Martin Baker's Blog. He further adapted my spreadsheet and has all sorts of stuff on his site about the D7000.

http://www.everythingd7000.co.uk/

Enjoy your D7000!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Vlad_IT

US
1353 posts

Click to send email to this author Click to send private message to this author

#71. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 70

Vlad_IT Silver Member Nikonian since 21st Sep 2011
Fri 23-Sep-11 10:49 PM

Great work!
It helped me to undestand a lot of new features i never imagine dSLR can have and how to set up properly my 4 days young D7000. So far i hit 1000 pictures mark with anly two keepers on a first day and about dozen on 4th one .
thanks

JMHernandez

Miami, US
65 posts

Click to send email to this author Click to send private message to this author

#72. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

JMHernandez Silver Member Nikonian since 16th Sep 2011
Sun 25-Sep-11 06:38 PM

Very clever!
Thank you, very much!

J.M.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#73. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 71

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 26-Sep-11 03:04 PM

Congratulations Vlad_IT - enjoy your new D7000 - you're going to love it!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

billg414

Los Angeles, US
3 posts

Click to send email to this author Click to send private message to this author

#74. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

billg414 Silver Member Nikonian since 15th Dec 2007
Sat 01-Oct-11 01:28 PM

Thanks!

Visit my Nikonians gallery.

Visit my Nikonians gallery.

Visit my Nikonians gallery.

Howker

Redmond, US
193 posts

Click to send email to this author Click to send private message to this author

#75. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 74

Howker Registered since 21st Jul 2010
Tue 11-Oct-11 05:32 PM

The Excel version works perfectly but the Apple for Numbers does not.
Error "The index.xml file is missing".

Anyone any ideas?

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#76. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 75

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 11-Oct-11 06:39 PM

Hi "Howker". Mmm, that's odd, as I just downloaded it on my iMac (running Lion) and it opens just fine in Numbers. I also tried on my Macbook (running Snow Leopard) and it opens just fine too. Just for good measure I tried the Excel version too and that opens fine in Office.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

kstrongs

St. Thomas, CA
75 posts

Click to send email to this author Click to send private message to this author

#77. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

kstrongs Registered since 04th Oct 2011
Tue 01-Nov-11 11:38 AM

Thanks a bunch for the sreadsheet. I know it was a lot of effort on your part. I am liking my D7000 more and more.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#78. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 77

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 01-Nov-11 01:22 PM

Hope it helps - enjoy your D7000!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

texspeel

Fairfax Station, US
391 posts

Click to send email to this author Click to send private message to this author

#79. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

texspeel Silver Member Nikonian since 09th Nov 2011
Wed 16-Nov-11 01:15 PM

Hi Chris,
Thanks for the spreadsheets! They're really super. I did find one thing in the Pre-Shoot Setup. Either I'm missing something or my camera is (probably me).
In the Auto Focus Area Mode row, you have the setting as 21 Point Dynamic-area AF.
However, when I go into the Auto Focus Selections on the Customer menu, I have a choice of 39 or 11 focus points. Is it possible the 21 in your sheet is left over from the setting on a different model?
Apologies to all if this has been posted previously as I've not gotten through all the email on this topic.
Best regards,
Tom

"Nothing can be recognized without light and shade. It is only through the eye, the window of the soul, that we can truly understand the complex workings of nature." - Leonardo da Vinci

Visit my Nikonians gallery.

Visit my Nikonians gallery.

briantilley

Paignton, UK
30235 posts

Click to send email to this author Click to send private message to this author

#80. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 79

briantilley Gold Member Deep knowledge of bodies and lens; high level photography skills Donor Ribbon awarded for his support to the Fundraising Campaign 2014 Nikonian since 26th Jan 2003
Wed 16-Nov-11 01:35 PM

The spreadsheet is correct.

The D7000 has two similar-sounding but distinct controls for the number of focus points to use.

Custom setting a6 allows you to choose between having all 39 points available or a reduced number if 11. Using 11 makes it faster to select one AF point manually.

Dynamic-area AF Mode (as in the spreadsheet) allows you to choose whether the camera uses data from 9, 21 or all 39 AF points to determine what to focus on. This is explained on pages 94-95 in the camera manual.

Brian
Welsh Nikonian

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#81. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 80

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 16-Nov-11 06:22 PM

Thanks, Brian - you beat me to it!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

texspeel

Fairfax Station, US
391 posts

Click to send email to this author Click to send private message to this author

#82. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 80

texspeel Silver Member Nikonian since 09th Nov 2011
Wed 16-Nov-11 09:04 PM

Brian,
Thanks for the explanation. As I said in my earlier email, I suspected I had missed something and, indeed, I had. Thanks for pointing me in the right direction.
Tom

"Nothing can be recognized without light and shade. It is only through the eye, the window of the soul, that we can truly understand the complex workings of nature." - Leonardo da Vinci

Visit my Nikonians gallery.

Visit my Nikonians gallery.

tekneektom

Kohler, US
2003 posts

Click to send email to this author Click to send private message to this author

#83. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

tekneektom Gold Member Donor Ribbon awarded for his support to the Fundraising Campaign 2014 Winner in the Annual Nikonians Best Images Contest 2015 Nikonian since 18th Nov 2011
Thu 08-Dec-11 12:38 AM

Chris,

This is a great tool. I can't imagine the number of hours you put into its testing and construction. You've saved me a lot of time, energy and mistakes. Thanks.

Tom

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#84. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 83

chroaz Silver Member Nikonian since 26th Apr 2009
Thu 08-Dec-11 02:52 PM

Glad it has been of some use, Tom. Enjoy!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

DavidBDiscover

Edina, US
16 posts

Click to send email to this author Click to send private message to this author

#85. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 84

DavidBDiscover Registered since 19th Oct 2011
Sun 11-Dec-11 03:01 PM

Chris,
Have you been updating the spreadsheet and if so, how do we get the latest version to download?

This is a great tool and I am happy that you took the time and did the work so that we can all learn about our D7000 cameras.

David

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#86. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 85

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 11-Dec-11 04:14 PM

Hi David, and I hope it has been helpful - it certainly was for me when I did it! I changed a couple of minor things such as the firmware version etc. and a couple of typos I came across but nothing to merit a revision. I did make some changes, again minor, to the Numbers version, which I tend to use now since I have made the switch over to a Mac and don't use Excel much any more.

I can email my latest version if you like, but as I say there really isn't a lot that has been changed.

Enjoy,

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Ragarm

US
13 posts

Click to send email to this author Click to send private message to this author

#87. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Ragarm Registered since 24th Dec 2011
Sat 24-Dec-11 04:31 PM

Thank you for that spreadsheet. I've just gotten to the point with my new D7000 where I've confused myself again. On opening your spreadsheet, it looks to be just the window for me, as I'm a bit of a spreadsheet oriented kind of guy anyway, so I look forward to enjoying many hours balancing it and my camera.

Take care, ..../Dan

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#88. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 87

chroaz Silver Member Nikonian since 26th Apr 2009
Sat 24-Dec-11 05:02 PM

Hope it helps, Dan .. and yes it is a balancing act, but the fun part is with the D7K not the spreadsheet!

Enjoy,

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

NDGraham

Dorval (Montreal), CA
661 posts

Click to send email to this author Click to send private message to this author

#89. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

NDGraham Gold Member Nikonian since 12th Jan 2007
Sat 07-Jan-12 01:40 PM

Thanks very much for sharing your work with the rest of us, Chris. I took a course in December on the use of the D7000 just after buying it. It would have been useful to have had your spreadsheet during the session. The course basically guided us through all the buttons and menus which was about all you could do in three hours. I recommend courses to just about anyone because there is so much to learn about these complex electronic marvels. It's fun to meet people with the same interests as well.
Thanks again for the clear presentation of complex information.
Neill
Proud to be a Montreal Nikonian
http://picasaweb.google.com/NeillDGraham

NDGraham

Dorval (Montreal), CA
661 posts

Click to send email to this author Click to send private message to this author

#90. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 45

NDGraham Gold Member Nikonian since 12th Jan 2007
Sat 07-Jan-12 01:52 PM

>I know Ken Rockwell suggest setting the picture controls a certain >way, but I have read that many people don't agree with his choice >of settings.
That's for sure. I tried his U1 and U2 settings and hated them! I think he must have been trying to put one over on us because the results were not good.
If shooting in NEF is too much pp work, try using the JPG settings such as in camera sharpening (AF Fine Tune).
Neill
Proud to be a Montreal Nikonian
http://picasaweb.google.com/NeillDGraham

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#91. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 89

chroaz Silver Member Nikonian since 26th Apr 2009
Sat 07-Jan-12 02:31 PM | edited Sat 07-Jan-12 04:30 PM by chroaz

Great, Neill, glad it helped. You were lucky to find a course on the D7000. When I got mine there weren't any! But now I see the Nikonians Academy series is now offering one too! As does Ben Long on Lynda.com, I think

Enjoy this fine Camera!

As an aside, I also have a Fuji X100 - a completely different experience by the way, but I love it too - and I keep reading on the various Fuji enthusiasts sites how new X100 owners are now dumping their DSLRS (Canon and Nikon) in favor of the X100, for reasons of quietness, portability, "feel", retro looks etc. - all sorts of reasons good (but not necessarily valid) and bad!

I don't agree with that line of thought at all. I think shooting the X100 is for a specific task and in no way can it duplicate or replace the performance and capabilities of my D7000.

I am happy I have both cameras but it's the D7000 that's the keeper! Enjoy yours!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

NDGraham

Dorval (Montreal), CA
661 posts

Click to send email to this author Click to send private message to this author

#92. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 91

NDGraham Gold Member Nikonian since 12th Jan 2007
Sat 07-Jan-12 04:26 PM

Hi again, Chris.
That X100 is an intriguing little gizmo with the retro look. I was curious so I started looking around for some reviews and found these articles on how it inspires mixed feelings. Thought you might be interested:
http://www.luminous-landscape.com/reviews/cameras/fuji_x100_follow_up.shtml
http://www.stevehuffphoto.com/2011/05/03/the-fuji-x100-digital-camera-real-world-review-by-steve-huff/
It seems like a kind of "bridge" between P&S size and DSLR bulk.
Hope you are enjoying it!

Neill
Proud to be a Montreal Nikonian
http://picasaweb.google.com/NeillDGraham

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#93. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 92

chroaz Silver Member Nikonian since 26th Apr 2009
Sat 07-Jan-12 04:38 PM

Yup, mixed feelings for some as you say but, as for so many things, it comes down to horses for courses in the end. My D7000 is my "serious" camera!

Enjoy!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

dcasciato

US
2 posts

Click to send email to this author Click to send private message to this author

#94. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 93

dcasciato Registered since 14th Nov 2011
Sun 08-Jan-12 11:52 PM

Thank you for the spreadsheet

Makitwood

Indianola, US
6 posts

Click to send email to this author Click to send private message to this author

#95. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Makitwood Silver Member Nikonian since 03rd Feb 2012
Sat 04-Feb-12 02:26 PM

Thanks for all the work. I will use this a lot. Great job.

Jim

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#96. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 95

chroaz Silver Member Nikonian since 26th Apr 2009
Sat 04-Feb-12 05:21 PM

So glad you're finding it helpful. Enjoy your D7000!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

rmaes

BE
2 posts

Click to send email to this author Click to send private message to this author

#97. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

rmaes Registered since 12th Feb 2012
Sun 12-Feb-12 01:45 PM

Hi Chris and all,

Though this may not be directly related to the great work you have achieved in creating this file, I did have a question as a result of setting up my d7000 based on the preferred shooting modes created.

I have been trying to save each of the preferred shooting mode to separate SD cards. The aim being to be able to upload the settings quickly when needed from dedicated cards.

Here's the issue I have:

Let say I'm trying to save the "Portrait" shooting mode. I put my camera on Aperture Priority mode and make all required changes to my linking. I then save these settings to the SD card (as par standard instructions by using save/load settings).

I then try to load these back to either U1/U2. Though some of the setting are loaded, things like the Aperture Priority mode, Focus Area and Focus Mode are not. The same happens if I try to restore these back in Aperture Priority mode (shooting mode I initially saved the settings from).

Again, things like Focus Mode or even the aperture value (f/x) I saved initially does not load.

To my understanding, saving settings (that creates the NCSETUP7.bin files) would also include things like MASP shooting modes and Focus AREAS/MODES to be able to recall these when loading them back from a SD card.

Is my understanding incorrect or is the camera indeed meant to be doing this (in which case I may have a problem with it). FYI, I have the latest A & B firmware.

Thanks for any pointers !
Raph

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#98. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 97

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 13-Feb-12 05:09 PM

Raph - I think this issue may be covered in the thread here here

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

rmaes

BE
2 posts

Click to send email to this author Click to send private message to this author

#99. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 98

rmaes Registered since 12th Feb 2012
Tue 14-Feb-12 09:02 AM

Tx Chris - Though quite interesting and relevant to a certain extend, it doesn't quite answer my question as to having the SD card being able to upload all settings back into PASM and/or U1/U2...

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#100. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 99

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 14-Feb-12 09:36 PM

Sorry, I think I misunderstood you. The settings that can be saved to a card are listed on Page 244 of the Manual. U1 and U2 settings I think are stored in the camera's RAM and are not saved.

Hope that helps.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

donghenz

PH
1 posts

Click to send email to this author Click to send private message to this author

#101. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

donghenz Registered since 25th Jan 2012
Wed 18-Apr-12 09:58 PM

this will be a great help... thanks

derka85

Santa Clara, US
2 posts

Click to send email to this author Click to send private message to this author

#102. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

derka85 Registered since 23rd Apr 2012
Mon 23-Apr-12 02:03 AM

appreciate the spreadsheet, will put it to good use

shark101au

US
3 posts

Click to send email to this author Click to send private message to this author

#103. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 102

shark101au Registered since 02nd Jun 2012
Sat 02-Jun-12 07:44 PM

I'm a new member and one of the first threads I came to was this.....very cool. Thanks!

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#104. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 103

chroaz Silver Member Nikonian since 26th Apr 2009
Sat 02-Jun-12 09:20 PM

Welcome to Nikonians! Hope this proves useful for you.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Prazstar

Sydney, AU
1 posts

Click to send email to this author Click to send private message to this author

#105. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Prazstar Registered since 04th Jun 2012
Mon 04-Jun-12 10:19 PM

Very helpful, Thank you Sir!!

Bravozulu

Los Angeles, US
762 posts

Click to send email to this author Click to send private message to this author

#106. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 105

Bravozulu Registered since 04th Jun 2012
Tue 05-Jun-12 11:44 AM

The spreadsheet with formulas is not working on my Mac G4. I'm using Excel 2004. Your file downloads as a text spreadsheet only. But with no formulas that allow input.

My CPU is old and won't allow the operation of iWorks. Is there a setup in Excel that will open the interactive formula?

(boy I do need help with my 6 week-old D7000 menus)

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#107. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 106

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 05-Jun-12 01:36 PM

Sorry you are having difficulties, Bravozulu. The spreadsheet has been tested on Excel 2007 for Windows and Excel 2004 (and later editions) for Mac. However I do not know about your G4 which I think was PPC based and does not have an Intel Processor and that may be the problem. It's all the conditional formatting and data validation that your CPU can't handle.

If so, I'm afraid there is no way around it, as you wont be able to run the Numbers version either - looks like a new computer ..., ouch!!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

jungleted

South Croydon, UK
8 posts

Click to send email to this author Click to send private message to this author

#108. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

jungleted Registered since 27th Jun 2012
Wed 27-Jun-12 05:36 PM

Thank you very much. My camera arrives in the next couple of days and I can't wait to start tinkering with the settings. This will be a great help.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#109. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 108

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 27-Jun-12 08:09 PM

Great - hope it helps - Enjoy your D7000!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

clickhans

UM
1161 posts

Click to send email to this author Click to send private message to this author

#110. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

clickhans Registered since 10th Jul 2012
Thu 02-Aug-12 08:24 PM

Hi, I am on IBM PC and it souds interesting but I cannot open the numbers file and the web surch for a programm to open it was without success.

Any idea how to open the file?

Best
Clickhans

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#111. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 110

chroaz Silver Member Nikonian since 26th Apr 2009
Thu 02-Aug-12 08:39 PM

Clickhans - "Numbers" is an Apple format file which can only be opened in iWork Numbers on a Mac. It is similar to Excel. You will aslo find an Excel (.xls file) at the top of this post. If you download that it will run on a PC provided you have the Excel software.

I hope that helps.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

clickhans

UM
1161 posts

Click to send email to this author Click to send private message to this author

#112. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 111

clickhans Registered since 10th Jul 2012
Fri 03-Aug-12 03:49 PM

Thanks Chris, got it.

Looks like there are two attachements with 2 Exel files. Are they different?

Best
clickhans

nlantz64

US
11 posts

Click to send email to this author Click to send private message to this author

#113. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

nlantz64 Registered since 07th Dec 2012
Sun 09-Dec-12 08:35 PM

I am new to the digital world as well as to my new D7000 and I found this spreadsheet very helpful. Thank you so much for the info.

Nick

Camel Toad

Austin, US
134 posts

Click to send email to this author Click to send private message to this author

#114. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Camel Toad Registered since 06th Dec 2012
Thu 20-Dec-12 01:54 PM

Thanks for taking the time to create this sheet and post it. Fantastic stuff!

-James

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#115. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 114

chroaz Silver Member Nikonian since 26th Apr 2009
Thu 20-Dec-12 02:00 PM

Great - glad it is helpful!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

cupajoe

Advance, US
6 posts

Click to send email to this author Click to send private message to this author

#116. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 115

cupajoe Registered since 16th Oct 2008
Mon 31-Dec-12 11:55 AM

This is a wonderful piece of work. You're very kind to offer this to the community. I think I'll find it very useful. Thanks.

Mike

Visit my Nikonians gallery.

Visit my Nikonians gallery.

Visit my Nikonians gallery.

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#117. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 116

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 31-Dec-12 02:48 PM

Glad you find it helpful - enjoy your Nikons in the New Year!!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

derekmiller45

Bedford, UK
7 posts

Click to send email to this author Click to send private message to this author

#118. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 117

derekmiller45 Registered since 07th Jan 2013
Mon 07-Jan-13 11:15 AM

Hi Chris.
I have had my D7000 for a few weeks now and just before Xmas decided I needed a spreadsheet for all the settings !!!
I joined Nikonians this morning and found yours, mine is about 1/10th of this and still a lot of work in progress.
That has now been ditched, so thanks for all your effort on this. Much appreciated.
Derek.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#119. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 118

chroaz Silver Member Nikonian since 26th Apr 2009
Mon 07-Jan-13 03:20 PM

Enjoy your D7000, Dererk. Glad we were able to short circuit a little bit the setting up process! You will find our group here at Nikonians to be a tremendous resource of very helpful and knowledgeable people.

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

labtrout

Bristol, US
1925 posts

Click to send email to this author Click to send private message to this author

#120. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

labtrout Silver Member Fellow Ribbon awarded for his constant sharing of his skills and continuous comments of encouragement in the Nikonians spirit. Nikonian since 09th Aug 2011
Sun 13-Jan-13 01:52 PM | edited Sun 13-Jan-13 01:53 PM by labtrout

Just another voice adding my thanks for this. I have been playing with it for several days now and find it invaluable.

Visit my Nikonians gallery/
[br />
https://www.flickr.com/photos/fl-420/

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#121. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 120

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 13-Jan-13 02:55 PM

You're very welcome - enjoy!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

brinda

MY
1 posts

Click to send email to this author Click to send private message to this author

#122. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

brinda Registered since 10th Dec 2012
Tue 15-Jan-13 04:05 AM

thank you for providing this

le gamin

Parksville, British Columbia, CA
26 posts

Click to send email to this author Click to send private message to this author

#123. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

le gamin Silver Member Nikonian since 07th Apr 2012
Wed 16-Jan-13 06:32 AM

Thank you Chris for taking on such a project and sharing it with the rest of us. I have still very new to the game and to see the spreadsheet lay out the data in such a way helps very much in understanding how my camera works and how to use it more effectively. Again, Thank you

David

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#124. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 123

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 16-Jan-13 01:49 PM

Glad it helps a little - enjoy!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

jvdk

NL
1 posts

Click to send email to this author Click to send private message to this author

#125. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

jvdk Registered since 28th Oct 2012
Sun 20-Jan-13 06:02 PM

Hi,
Thanks for this

Nongmainham

TH
1 posts

Click to send email to this author Click to send private message to this author

#126. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Nongmainham Registered since 21st Dec 2012
Wed 30-Jan-13 12:08 AM


Chris, thanks for the spreadsheet i am a beginner with the D7k and hope to learn from the system you offer with this spreadsheet.

greatings,

Nongmainham

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#127. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 126

chroaz Silver Member Nikonian since 26th Apr 2009
Wed 30-Jan-13 02:32 AM

Enjoy your D7000 - you will!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

technicalganesh

IN
6 posts

Click to send email to this author Click to send private message to this author

#128. "Amazing work!" | In response to Reply # 0

technicalganesh Registered since 12th Feb 2013
Fri 22-Feb-13 01:57 PM

Amazing work!... Thanks a lot for sharing this worksheet!

bestoftheworst

Chicago, US
1 posts

Click to send email to this author Click to send private message to this author

#129. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

bestoftheworst Registered since 12th Feb 2013
Thu 28-Mar-13 05:23 PM

Chris, Many Thanks for the spreadsheet i am a beginner with the D7k and hope to learn with this spreadsheet. Thank you!!!

Happy Clicking...
Mahesh

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#130. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 129

chroaz Silver Member Nikonian since 26th Apr 2009
Thu 28-Mar-13 07:37 PM

Your welcome - enjoy!!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

senseen

AU
2 posts

Click to send email to this author Click to send private message to this author

#131. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

senseen Registered since 20th Apr 2013
Sat 20-Apr-13 01:11 AM

Thank you!

DavidBDiscover

Edina, US
16 posts

Click to send email to this author Click to send private message to this author

#132. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 130

DavidBDiscover Registered since 19th Oct 2011
Sat 20-Apr-13 11:33 AM

Chris,
Has anyone that you know of adapted this sheet for the new D7100? I realize it is very new, but many are lauding its praises and someone must be going through their D7000 sheet and making adjustments.
David

Visit my Nikonians gallery.

Nikster27

UK
3 posts

Click to send email to this author Click to send private message to this author

#133. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 131

Nikster27 Registered since 30th May 2013
Thu 30-May-13 01:01 PM

Thankyou thats great

Love2Photo

Closplint, US
7 posts

Click to send email to this author Click to send private message to this author

#134. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 133

Love2Photo Registered since 01st May 2013
Thu 06-Jun-13 02:15 AM

Thanks for all work involved. Works great.

RazorAndy

US
26 posts

Click to send email to this author Click to send private message to this author

#135. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 131

RazorAndy Silver Member Nikonian since 21st Aug 2013
Thu 22-Aug-13 01:48 PM

Thank you to all involved for the work that went into this. It's certainly a great tool.

I have had my D7K for a few months now, and have just recently gotten serious into delving into optimizing my settings after some head scratching on not-quite-optimal results I was getting, so this was fortuitous to find this.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#136. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 135

chroaz Silver Member Nikonian since 26th Apr 2009
Thu 22-Aug-13 02:34 PM

Terrific - glad it has been helpful - Enjoy your D7K

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Bkats

Denver, US
20 posts

Click to send email to this author Click to send private message to this author

#137. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Bkats Gold Member Nikonian since 02nd Nov 2009
Sun 10-Nov-13 10:16 PM

Can this spreadsheet be adapted tot eh D7100? What changes are there for the 7100? Great tool

Visit my Nikonians gallery.

Visit my Nikonians gallery.

liebervj

US
1 posts

Click to send email to this author Click to send private message to this author

#138. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

liebervj Registered since 20th Oct 2013
Sun 29-Dec-13 02:56 AM

Thanks this is outstanding!

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#139. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 138

chroaz Silver Member Nikonian since 26th Apr 2009
Sun 29-Dec-13 02:51 PM

Your welcome. Enjoy your Nikons!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

chroaz

Cave Creek, US
726 posts

Click to send email to this author Click to send private message to this author

#140. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 137

chroaz Silver Member Nikonian since 26th Apr 2009
Tue 18-Feb-14 11:47 PM

"Bkats" - a fellow Nikonian is in the process of updating adapting my spreadsheet for the D7100. It should be available shortly.

Enjoy your Nikons!

Chris

When words become unclear, I shall focus with photographs. When images become inadequate, I shall be content with silence.
- Ansel Adams

Visit my Nikonians gallery.

www.throughmeyelens.com

Visit my Nikonians gallery.

Whitecrown

BENSALEM, Bucks County, US
73 posts

Click to send email to this author Click to send private message to this author

#141. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

Whitecrown Gold Member Nikonian since 12th Jul 2014
Mon 21-Jul-14 07:05 PM

Thank you very much for sharing.

Good info!

Fred

gauz09

US
3 posts

Click to send email to this author Click to send private message to this author

#142. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

gauz09 Registered since 28th Dec 2014
Sun 28-Dec-14 10:41 PM

Hi Chris,

A big thank you for putting in your time and efforts in creating this spreadsheet and more importantly "sharing" it with everybody. Simply great!

This spreadsheet is very very helpful to me. It puts things in simple black&white, I can refer to it instead of getting overwhelmed by the content in manual. I feel those settings in the 4 banks are also very useful. Of course, the plus point is one can change and save these settings as per the liking.

Thanks once again for the great work!


Gauz

jcking53

Madison, US
3 posts

Click to send email to this author Click to send private message to this author

#143. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 0

jcking53 Registered since 26th Jan 2015
Mon 26-Jan-15 08:28 PM

I am new to this site as well as to my just acquired D7000. I am a beginner in every way. I just wanted to say "Thanks!" for the setup spreadsheet. It will be invaluable while I'm learning this wonderful camera!

JohnP793

Brentwood, US
27 posts

Click to send email to this author Click to send private message to this author

#144. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 143

JohnP793 Silver Member Nikonian since 14th Jan 2006
Wed 15-Apr-15 07:04 PM | edited Wed 15-Apr-15 07:10 PM by JohnP793

Hi- I'M planning on getting a 7100 and am glad to see your settings. Thank you for posting them.

Also, I will be curious to compare these with those settings provided by Ken Rockwell. Any comments?

John

briantilley

Paignton, UK
30235 posts

Click to send email to this author Click to send private message to this author

#145. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 144

briantilley Gold Member Deep knowledge of bodies and lens; high level photography skills Donor Ribbon awarded for his support to the Fundraising Campaign 2014 Nikonian since 26th Jan 2003
Wed 15-Apr-15 07:55 PM


>Also, I will be curious to compare these with those settings
>provided by Ken Rockwell. Any comments?

Yes - if you are (or are hoping to become) a serious photographer, ignore what that gentleman recommends and seek specific settings advice here

Brian
Welsh Nikonian

JohnP793

Brentwood, US
27 posts

Click to send email to this author Click to send private message to this author

#146. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 145

JohnP793 Silver Member Nikonian since 14th Jan 2006
Thu 16-Apr-15 01:49 PM

Thanks for the comments re Mr. Rockwell. I've found it useful to see what different people, presumably more experienced than myself, recommend, compare the various advisories, try them out, and then make up my own mind. I've tried some of Rockwell's suggestions on my current and earlier cameras; some gave me results I liked, others did not. I do find the answers here to be more specific and as such quite helpful.

Hinduja

delray beach, US
22 posts

Click to send email to this author Click to send private message to this author

#147. "RE: D7000 Configuration Settings and Set-Up Spreadsheet V.2.2" | In response to Reply # 139

Hinduja Silver Member Nikonian since 27th Feb 2016
Mon 13-Jun-16 11:23 AM

as a new owner of a D7000, I found this post, I thank you very much.

let there be light

Visit my Nikonians gallery.

G