{% if rcmArray == true %} {% set a = 0 %} {% for rcm in rcmArray %}

XLS

{% for network in nombreNet[rcm] %} {% set a = 0 %} {% set totalTime = 0 %} {% for sites in sitesRCM[rcm][network] %} {% set b = 0 %} {% if a != 0 %} {% endif %} {% for week in WeeksRCM[rcm][network][sites] %} {% if b != 0 %} {% endif %} {% if rcmResol2[rcm][network][sites][week] is defined %} {% set totalTime = totalTime + rcmResol[rcm][network][sites][week] %} {% endif %} {% if WeeksRCM[rcm][network][sites]|length != 1 %} {% endif %} {% set b = b + 1 %} {% endfor %} {% if sitesRCM[rcm][network]|length != 1 %} {% endif %} {% set a = a + 1 %} {% endfor %} {% if (totalTime % 60) < 10 %}{% set minTime = "0"~(totalTime % 60) %}{% else %}{% set minTime = (totalTime % 60) %}{% endif %} {% endfor %}

{{ rcm }}
Network	Site	Week	Customer	Market	Total Time
{{ network }}
{{ sites }}
{{ week }}	{% if customerRCM[rcm][network][sites][week] is defined %} {{ customerRCM[rcm][network][sites][week] }} {% endif %}	{% if marketRCM[rcm][network][sites][week] is defined %} {{ marketRCM[rcm][network][sites][week] }} {% endif %}	{{ rcmResol2[rcm][network][sites][week] }}
Total				{{ (totalTime/60)\|round(0, 'floor')~':'~minTime }}

{% set a = a +1 %} {% endfor %}

{% else %}

NO FOUND INFORMATION

{% endif %}