CreativePro Forum

Return to Member Forum

• Author
  Posts
• • November 6, 2017 at 12:21 pm #99419
    Rivkah Lewis

    Member

    A client has requested design of a weekly calendar that included a huge amount of info per week.
    I looked into the Calendar Wizard plug-in but I don’t see weekly options, nor do I see the ability to add in all the info I need.
    So it seems to me I would need to create some sort of data merge. (All info is in an Excel XLS file).
    The end result needs to look something like this: https://www.dropbox.com/s/jh40a1qn87syqth/Sample.pdf?dl=0

    The times on each page are unique per country, so they would like a template designed which can be modified per country/client.

    Can anyone give me direction on this?

  • November 7, 2017 at 9:11 am #99441
    Kelly Vaughn

    Participant

    I would consider using:
    -WordsFlow Pro (in case they need to update the content of the spreadsheet)
    -Conditional Text for each of the countries
    -Nested Paragraph styles for the text formatting.

    It will be a lot of work, but it can definitely be done. I noticed that there are some gradient in the table. InDesign does handle those well in tables, so I would apply a successively light shade of gray in each cell to accomplish the gradient.

    And the rounded corners on the table will be an issue. Diane Burns has a cool trick for accomplishing that. Basically you paste the entire table into a text frame that has rounded corners. That’s more of a last step in the project… Of course if all the tables are the same height, you could just create a rounded edge box on the master page, on a top layer.

  • November 7, 2017 at 11:42 pm #99449
    Rivkah Lewis

    Member

    Thanks, Kelly.
    The info they are sending would be final. I’m not so concerned about that. (They are pulling it from a database they already created.)
    Formatting with nested styles is also something I can do just fine.
    Its the conditional text part you mentioned I have minimal experience with. I guess I will have to do a search to see how to set that up. I worked with Excel and data merge on a long phone book once with David Blatner’s help and a cool script. But this has so many more variables….

• Author
  Posts