Custom Workbook S-140

– With Weekend Meeting and Duty Assignments (in English)

Here is an example of what to expect:

This custom worksheet script is designed to display one week per page. It includes the following information:

• Midweek Meeting
• Weekend Meeting
• Duty Assignments

Updating Translations

The only translation that will be required is for the heading:

<xsl:template name="DutyAssignHEADING">
  <tr>
    <td class ="cellDUTYASSIGN" colspan="4">
      <div class="textDUTYASSIGN" style="float:left">
        <xsl:text>Assignments for the week</xsl:text>
      </div>
    </td>
  </tr>
</xsl:template>

Other Required Changes

You will need to confirm that the Report Mode is correct (it is using Midweek at the moment):

<!--Duty Assignments-->
<xsl:if test="@SpecialEvent=0">
  <xsl:variable name="Week" select="Date/@ThisWeek"/>
  <xsl:variable name="Weekend-Assignments"
                     select="$DutyHistory/msa:DutyAssignmentHistory/msa:DutyAssignments
            /msa:DutyAssignmentEntry[@Week=$Week and @Mode='Midweek']/msa:Assignment"/>

You will also need to confirm the labels / assignments:

<!--Duty Assignments-->
<xsl:if test="@SpecialEvent=0">
  <xsl:variable name="Week" select="Date/@ThisWeek"/>
  <xsl:variable name="Weekend-Assignments"
                     select="$DutyHistory/msa:DutyAssignmentHistory/msa:DutyAssignments
            /msa:DutyAssignmentEntry[@Week=$Week and @Mode='Midweek']/msa:Assignment"/>

  <table class="DutyAssignTable" cellspacing="0" cellpadding="0">
    <xsl:call-template name="DutyAssignHEADING"/>
    <tr class="DutyAssignRow">
      <xsl:apply-templates select="$Weekend-Assignments[@Index='1' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Sound[@Index='1']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='5' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Platform"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='7' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Mike[@Index='1']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='8' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Mike[@Index='2']"/>
      </xsl:apply-templates>
    </tr>
    <tr class="DutyAssignRow">
      <xsl:apply-templates select="$Weekend-Assignments[@Index='13' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Attendant[@Index='1']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='14' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Attendant[@Index='2']"/>
      </xsl:apply-templates>
      <xsl:apply-templates select="$Weekend-Assignments[@Index='15' and @IndexType='Fixed']">
        <xsl:with-param name="Label" select="$Labels/Labels/Attendant[@Index='3']"/>
      </xsl:apply-templates>
      <xsl:call-template name="cellEMPTY"/>
    </tr>
  </table>
</xsl:if>

Please read this help topic to familiarise yourself with the Duty Assignment History syntax.

Customising the Look and Feel

A set of classes have been added to the CSS file for styling:

• cellDUTYASSIGN
• textDUTYASSIGN
• textDutyAssignTable
• textDutyAssignRow
• textDutyAssignLabel
• textDutyAssignName