Author Topic: Code and Caption Generator - MS Excel based  (Read 4521 times)

Offline Patrick Lanius

  • Newcomer
  • *
  • Posts: 1
    • View Profile
Code and Caption Generator - MS Excel based
« on: September 11, 2008, 02:22:16 PM »
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

Offline PSPwa

  • Newcomer
  • *
  • Posts: 6
    • View Profile
Re: Code and Caption Generator - MS Excel based
« Reply #1 on: May 18, 2009, 07:15:53 PM »
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

Offline devenh

  • Sr. Member
  • ****
  • Posts: 435
    • View Profile
Re: Code and Caption Generator - MS Excel based
« Reply #2 on: May 20, 2009, 06:34:32 AM »
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


Offline PSPwa

  • Newcomer
  • *
  • Posts: 6
    • View Profile
Re: Code and Caption Generator - MS Excel based
« Reply #3 on: May 20, 2009, 06:47:33 AM »
Cheers for that Deven,

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

appreciated
Matt

Offline gianca49

  • Newcomer
  • *
  • Posts: 38
    • View Profile
    • fotoswiss
Re: Code and Caption Generator - MS Excel based
« Reply #4 on: November 30, 2009, 03:01:43 AM »
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