Story   Photographer   Editor   Student/Intern   Assistant   Job/Item

Contents:  Front Page  Member Index  Latest Headlines  Special Features  'Fun Pix'  Message Board  Educate Yourself  Equipment Profiles  Bookshelf  my.SportsShooter  Classified Ads  Workshop Contests:  Monthly Clip Contest  Annual Contest  Rules/Info Newsletter:  Current Issue  Back Issues Members:  Members Area  "The Guide"  Join About Us:  About SportsShooter  Contact Us  Terms & Conditions Sign in: Members log in here with your user name and password to access the your admin page and other special features. Name: Password:

|| SportsShooter.com: Member Message Board NFL Code Replacements DIY in Excel Maxwell Kruger, Photographer Owings Mills | MD | USA | Posted: 6:40 PM on 08.24.10 ->> All, I have written up a short tutorial on a way to make your own NFL code replacements using Excel. I have created an Excel template that is provided with the tutorial. It includes all of the Ravens home game opponents this year (I shoot mostly Ravens). If you know a bit about Excel or can follow instructions, you can spend 5 minutes learning how to use the spreadsheet and create new rosters from NFL.com in a matter of seconds. http://www.maxwellkruger.com/post/making-photo-mechanic-code-replacement-sh.../ Hopefully this will help some of you.  This post is:  Informative (2) | Funny (0) | Huh? (0) | Off Topic (0) | Inappropriate (0) |   Definitions Darren Whitley, Photographer Northwest Missouri | MO | USA | Posted: 11:39 PM on 08.24.10 ->> Thank you. Can you use code replace to generate keywords? That would be helpful since we're keywording in Lightroom. I'd like to make it something we do in PM before dropping the images into LR.  This post is:  Informative (0) | Funny (0) | Huh? (0) | Off Topic (0) | Inappropriate (0) |   Definitions Scott Kane, Photographer Edwardsville | IL | USA | Posted: 7:21 PM on 08.26.10 ->> Max, Thanks for making this, it will come in very handy.  This post is:  Informative (0) | Funny (0) | Huh? (0) | Off Topic (0) | Inappropriate (0) |   Definitions Maxwell Kruger, Photographer Owings Mills | MD | USA | Posted: 9:27 PM on 08.26.10 ->> @Scott, Thanks. Let me know if you have any suggestions on how to improve it. @Darren, I'm not sure what you mean about making it generate keywords. You can certainly modify the formula to make it just output names or numbers for codes and use those codes as code replacements in PM.  This post is:  Informative (0) | Funny (0) | Huh? (0) | Off Topic (0) | Inappropriate (0) |   Definitions Brad Barr, Photographer Port St. Lucie | FL | USA | Posted: 8:21 PM on 08.29.10 ->> Darren, you can use code repl to populate any field on the stationary pad. Keywording is much more efficient in PM than LR. (not sure about lr3). But you could build a code replacement scheme for the whole league in not very long that included all whole host of key words for each team....and have the whole lot be entered via a couple key strokes /FMK/ for example could be your code for Florida Marlins Keywords, which then could load whatever you wanted to include about the Marlins...  This post is:  Informative (0) | Funny (0) | Huh? (0) | Off Topic (0) | Inappropriate (0) |   Definitions Add your comments... If you'd like to add your comments to this thread, use this form. You need to be an active (paying) member of SportsShooter.com in order to post messages to the system. NOTE: If you would like to report a problem you've found within the SportsShooter.com website, please let us know via the 'Contact Us' form, which alerts us immediately. It is not guaranteed that a member of the staff will see your message board post. Thread Title: NFL Code Replacements DIY in Excel Thread Started By: Maxwell Kruger Message: Member Login: Password: Return to --> Message Board Main Index

Copyright 2023, SportsShooter.com