Code and Caption Generator - MS Excel based

[Patrick Lanius]

I created a simple Microsoft Excel file that will generate code and caption replacements for use in Photo Mechanic and I thought I'd share it here.

The main use for the file is to create your own custom code and caption txt file.  This will be useful for those of us who must caption photos for frequently covered prep sports teams.  If you can get a roster in digital form from an AD, it will save you the trouble of typing all the info yourself.  Just cut and paste the info into this file and generate some commonly used caption text and codes.

here is the excel file: http://www.wplsports.com/ccg/CCG01.xls

here is the instruction page: http://www.wplsports.com/ccg/CCG_Instructions.pdf

here is an example of the xcel file filled in using the Washington Redskins: http://www.wplsports.com/ccg/redskins_example.xls

here is the txt file for the Redskins example: http://www.wplsports.com/ccg/redskins_example.txt

[PSPwa]

G'day Patrick

I know this is an old thread, I've just found this file and setup....Well Done mate.
I'm relatively new to PM and this setup sure is a great help and time saver....

Cheers
Matthew

[devenh]

This style of captions has been made obsolete by the introduction of code replacement fields in v4.6.

So instead of:

w3n   Sam Hollenbach
w3pn   quarterback Sam Hollenbach
w3tpn   Washington Redskins quarterback Sam Hollenbach
w3pn#   quarterback Sam Hollenbach (#3)
w3tpn#   Washington Redskins quarterback Sam Hollenbach (#3)

You could have:

w3n   Sam Hollenbach   quarterback Sam Hollenbach   Washington Redskins quarterback Sam Hollenbach  etc.

and refer to these as \w3n\, \w3n#2\, \w3n#3\, etc.

Deven

[PSPwa]

Cheers for that Deven,

a heaps lot easier...Like I said new to PM and still stumblin' and bumblin' my way around...

appreciated
Matt

[gianca49]

I would like to thank Patrick Lanius for his sharing of knowledge on code replacements.
thank you.
if you happen to come to st.moritz I buy you dinner....just let me know
best regards
giancarlo, st.moritz, switzerland