package art.servers.rtzserver.reports;

import art.library.model.devices.colors.controller.RTZ32.configuration.RTZ32_Configuration_Group;
import art.library.model.devices.colors.controller.RTZ32.configuration.RTZ32_Configuration_Program;
import art.library.model.devices.colors.controller.RTZ32.configuration.constants.RTZ32_Constants;
import art.library.model.devices.colors.controller.RTZ32.types.RTZ32_Report_Information;
import art.library.utils.resources.Resources;
import art.servers.ServerException;
import art.servers.rtzserver.Shared;
import java.io.File;
import java.io.FileInputStream;
import org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class Report_Configuration extends XLS
{
    public Report_Configuration(String language) throws Exception
    {
        this.language = language;
        String filename = "data/" + Shared.getApplicationName() + "/templates/template_configuration." + language + ".xls";
        File file = new File(filename);
        if (file.exists() == false) file = Resources.getResourceFile(filename);
        if (file.exists() == false) throw new ServerException("Template not found");
        workbook = new HSSFWorkbook(new FileInputStream(new File(filename)));
    }

    public byte[] generate(String format, RTZ32_Report_Information reportInformation) throws ServerException
    {
        byte[] data = null;

        try
        {
            // Table 1
            int sheetNumber = 0;
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.groups[i].type);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 2
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].cycle);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 3
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].offset);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 4
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    for (int j=0; j<6; j++)
                    {
                        if (reportInformation.configuration.programs[i].variablePhases[j] != null)
                        {
                            sheet.getRow(i+1).getCell((j*2)+1).setCellValue(reportInformation.configuration.programs[i].variablePhases[j].startTime);
                            sheet.getRow(i+1).getCell((j*2)+2).setCellValue(reportInformation.configuration.programs[i].variablePhases[j].endTime);
                        }
                        else
                        {
                            sheet.getRow(i+1).getCell((j*2)+1).setCellValue(0);
                            sheet.getRow(i+1).getCell((j*2)+2).setCellValue(0);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 5
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                sheet.getRow(1).getCell(1).setCellValue(reportInformation.configuration.startup.plan);
                sheet.getRow(2).getCell(1).setCellValue(reportInformation.configuration.startup.timeFlashing);
                sheet.getRow(3).getCell(1).setCellValue(reportInformation.configuration.startup.timeYellow);
                sheet.getRow(4).getCell(1).setCellValue(reportInformation.configuration.startup.timeRed);
            }
            catch (Exception e)
            {
                
            }

            // Table 6
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                int value1 = 0;
                {
                    value1 = value1 + (reportInformation.configuration.operationMode.synchronismType & 0x03);

                    if (reportInformation.configuration.operationMode.synchronismTable78 == true)
                    {
                        value1 = value1 + 0x04;
                    }

                    if (reportInformation.configuration.operationMode.synchronismMode != 0)
                    {
                        value1 = value1 + 0x08;
                    }

                    if (reportInformation.configuration.operationMode.masterSynchronizable == true)
                    {
                        value1 = value1 + 0x020;
                    }

                    value1 = value1 + (reportInformation.configuration.operationMode.semiactuatedMode << 6);
                }

                sheet.getRow(1).getCell(1).setCellValue(value1);
                sheet.getRow(2).getCell(1).setCellValue(reportInformation.configuration.operationMode.cycleExtensionSynchronismType1);
                sheet.getRow(3).getCell(1).setCellValue(reportInformation.configuration.operationMode.cycleReductionSynchronismType1);
                sheet.getRow(4).getCell(1).setCellValue(reportInformation.configuration.operationMode.inhibitionExtendsSynchronismType2);
                sheet.getRow(5).getCell(1).setCellValue(reportInformation.configuration.operationMode.inhibitionExtendsSynchronismType3);
            }
            catch (Exception e)
            {
                
            }

            // Table 7
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<4; i++)
                {
                    for (int j=0; j<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; j++)
                    {
                        if (reportInformation.configuration.groups[j].transitions[i] != null)
                        {
                            sheet.getRow(j+1).getCell((i*2)+1).setCellValue(reportInformation.configuration.groups[j].transitions[i].yellowTimeSimple);
                            sheet.getRow(j+1).getCell((i*2)+2).setCellValue(reportInformation.configuration.groups[j].transitions[i].yellowTimeSimple);
                        }
                        else
                        {
                            sheet.getRow(j+1).getCell((i*2)+1).setCellValue(0);
                            sheet.getRow(j+1).getCell((i*2)+2).setCellValue(0);
                        }
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            for (int p=11; p<=28; p++)
            {
                // Tables 11 to 28
                try
                {
                    HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                    RTZ32_Configuration_Program program = reportInformation.configuration.programs[p-11];

                    for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                    {
                        try
                        {
                            int cell = 1;
                            for (int j=0; j<program.groups[i].impulses.size(); j++)
                            {
                                try
                                {
                                    RTZ32_Configuration_Group groupCfg = reportInformation.configuration.getGroup(program.groups[i].group);
                                    boolean es30 = ((groupCfg != null) && (groupCfg.getType() == 30));
                                    if ((es30 == true) && ((j%2)==0))
                                    {
                                        sheet.getRow(i+1).getCell(cell++).setCellValue(program.groups[i].impulses.get(j));
                                    }
                                    else if ((es30 == true) && (program.groups[i].impulses.size()==3))
                                    {
                                        sheet.getRow(i+1).getCell(cell++).setCellValue(program.groups[i].impulses.get(j));
                                    }
                                    else if (es30 == false)
                                    {
                                        sheet.getRow(i+1).getCell(cell++).setCellValue(program.groups[i].impulses.get(j));
                                    }
                                }
                                catch (Exception e)
                                {
                                    Shared.printstack("Report", e);
                                }
                            }
                        }
                        catch (Exception e)
                        {
                            Shared.printstack("Report", e);
                        }

                        try
                        {
                            for (int j=program.groups[i].impulses.size(); j<6; j++)
                            {
                                try
                                {
                                    sheet.getRow(i+1).getCell(j+1).setCellValue("-");
                                }
                                catch (Exception e)
                                {
                                    Shared.printstack("Report", e);
                                }
                            }
                        }
                        catch (Exception e)
                        {
                            Shared.printstack("Report", e);
                        }
                    }
                }
                catch (Exception e)
                {

                }
            }

            // Table 31
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<50; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.inputs[i].type1);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.inputs[i].code1);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.inputs[i].type2);
                    sheet.getRow(i+1).getCell(4).setCellValue(reportInformation.configuration.inputs[i].code2);
                    sheet.getRow(i+1).getCell(5).setCellValue(reportInformation.configuration.inputs[i].type3);
                    sheet.getRow(i+1).getCell(6).setCellValue(reportInformation.configuration.inputs[i].code3);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 32
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<16; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.outputs[i].type);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.outputs[i].code);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 33
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<9; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.emergencyTransitions[i].transitions[0]);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.emergencyTransitions[i].transitions[1]);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.emergencyTransitions[i].transitions[2]);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 34
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<6; i++)
                {
                    sheet.getRow(1).getCell(i+1).setCellValue(reportInformation.configuration.structuresTransitions[i].duration);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 35
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].typeGroupsTable);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.programs[i].structure);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.programs[i].subtableApproachingTimesTW);
                    sheet.getRow(i+1).getCell(4).setCellValue(reportInformation.configuration.programs[i].subtableToleranceTimesTW);
                    sheet.getRow(i+1).getCell(5).setCellValue(reportInformation.configuration.programs[i].subtableGroupTransitions);
                    sheet.getRow(i+1).getCell(6).setCellValue(0);
                    sheet.getRow(i+1).getCell(7).setCellValue(0);
                    sheet.getRow(i+1).getCell(8).setCellValue(0);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 36
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<16; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.groupsType2[i].group);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.groupsType2[i].type);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 37
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<16; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.groupsType3[i].group);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.groupsType3[i].type);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 38
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int j=0; j<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; j++)
                {
                    sheet.getRow(j+1).getCell(1).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[0].color);
                    sheet.getRow(j+1).getCell(2).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[1].color);
                    sheet.getRow(j+1).getCell(3).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[3].color);
                    sheet.getRow(j+1).getCell(4).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[2].color);
                    sheet.getRow(j+1).getCell(5).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[4].color);
                    sheet.getRow(j+1).getCell(6).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[5].color);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 41
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
/*
                for (int j=0; j<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; j++)
                {
                    sheet.getRow(j+1).getCell(1).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[0].color);
                    sheet.getRow(j+1).getCell(2).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[1].color);
                    sheet.getRow(j+1).getCell(3).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[2].color);
                    sheet.getRow(j+1).getCell(4).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[3].color);
                    sheet.getRow(j+1).getCell(5).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[4].color);
                    sheet.getRow(j+1).getCell(6).setCellValue(reportInformation.configuration.groups[j].structuresTransitions[5].color);
                }
*/
            }
            catch (Exception e)
            {
                
            }

            // Table 42
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].vehicleDemands.demands1);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.programs[i].vehicleDemands.demands2);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 43
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].pedestianDemands.demands1);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.programs[i].pedestianDemands.demands2);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.programs[i].pedestianDemands.demands3);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 44
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].spareTimes.phases);
                }

                sheet.getRow(RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS+1).getCell(1).setCellValue(reportInformation.configuration.sparesTimesActuated);
            }
            catch (Exception e)
            {
                
            }

            // Table 45
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].increments.increment1);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.programs[i].increments.increment2);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.programs[i].increments.increment3);
                    sheet.getRow(i+1).getCell(4).setCellValue(reportInformation.configuration.programs[i].increments.increment4);
                    sheet.getRow(i+1).getCell(5).setCellValue(reportInformation.configuration.programs[i].increments.increment5);
                    sheet.getRow(i+1).getCell(6).setCellValue(reportInformation.configuration.programs[i].increments.increment6);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 46
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.groups[i].fictitious);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 50
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                sheet.getRow(1).getCell(1).setCellValue(reportInformation.configuration.weekDays.monday);
                sheet.getRow(1).getCell(2).setCellValue(reportInformation.configuration.weekDays.tuesday);
                sheet.getRow(1).getCell(3).setCellValue(reportInformation.configuration.weekDays.wednesday);
                sheet.getRow(1).getCell(4).setCellValue(reportInformation.configuration.weekDays.thursday);
                sheet.getRow(1).getCell(5).setCellValue(reportInformation.configuration.weekDays.friday);
                sheet.getRow(1).getCell(6).setCellValue(reportInformation.configuration.weekDays.saturday);
                sheet.getRow(1).getCell(7).setCellValue(reportInformation.configuration.weekDays.sunday);
            }
            catch (Exception e)
            {
                
            }

            // Table 51
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                sheet.getRow(1).getCell(1).setCellValue(reportInformation.configuration.fixedProgram.fixedProgram);
                sheet.getRow(1).getCell(2).setCellValue(reportInformation.configuration.fixedProgram.fixedProgramDay);
                sheet.getRow(1).getCell(3).setCellValue(reportInformation.configuration.fixedProgram.fixedTable);
                sheet.getRow(1).getCell(4).setCellValue(reportInformation.configuration.fixedProgram.fixedTableDay);
            }
            catch (Exception e)
            {
                
            }

            // Table 52
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<30; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.specialDays[i].day);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.specialDays[i].month);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.specialDays[i].timetable);
                }
            }
            catch (Exception e)
            {
                
            }

            for (int p=53; p<=60; p++)
            {
                // Tables 53 to 60
                try
                {
                    HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                    for (int i=0; i<10; i++)  // Cambios
                    {
                        int index = ((p - 53) * 10) + i;
                        sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.timetables[index].hour);
                        sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.timetables[index].minute);
                        int value3 = 0;
                        {
                            value3 = value3 + (reportInformation.configuration.timetables[index].timeSelection <<  7);
                            value3 = value3 + (reportInformation.configuration.timetables[index].synchronismType <<  5);
                            value3 = value3 + (reportInformation.configuration.timetables[index].operationMode <<  4);
                            value3 = value3 + (reportInformation.configuration.timetables[index].program);
                        }
                        sheet.getRow(i+1).getCell(3).setCellValue(value3);

                        // En excel enviado por Pedro estos campos se ponen a 0
                        sheet.getRow(i+1).getCell(5).setCellValue(0);
                        sheet.getRow(i+1).getCell(6).setCellValue(0);
                        sheet.getRow(i+1).getCell(7).setCellValue(0);
                        sheet.getRow(i+1).getCell(8).setCellValue(0);

                        /*
                        sheet.getRow(i+1).getCell(5).setCellValue(reportInformation.configuration.timetables[index].timeSelection);
                        sheet.getRow(i+1).getCell(6).setCellValue(reportInformation.configuration.timetables[index].synchronismType);
                        sheet.getRow(i+1).getCell(7).setCellValue(reportInformation.configuration.timetables[index].operationMode);
                        sheet.getRow(i+1).getCell(8).setCellValue(reportInformation.configuration.timetables[index].program);
                        */
                    }
                }
                catch (Exception e)
                {

                }
            }

            // Table 64
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<16; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(0);
                    sheet.getRow(i+1).getCell(2).setCellValue(0);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 65
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<8; i++) // 8 accesses
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.microregulation.accesses[i].levelA);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.microregulation.accesses[i].levelB);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.microregulation.accesses[i].levelC);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 66
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<8; i++) // 8 accesses
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.microregulation.accesses[i].phase);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 67
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                sheet.getRow(1).getCell(1).setCellValue(reportInformation.configuration.microregulation.levelF1);
                sheet.getRow(1).getCell(2).setCellValue(reportInformation.configuration.microregulation.levelF2);
                sheet.getRow(1).getCell(3).setCellValue(reportInformation.configuration.microregulation.levelF3);
                sheet.getRow(1).getCell(4).setCellValue(reportInformation.configuration.microregulation.priorityF1);
                sheet.getRow(1).getCell(5).setCellValue(reportInformation.configuration.microregulation.priorityF2);
                sheet.getRow(1).getCell(6).setCellValue(reportInformation.configuration.microregulation.priorityF3);
                sheet.getRow(1).getCell(7).setCellValue(reportInformation.configuration.microregulation.congestionF1);
                sheet.getRow(1).getCell(8).setCellValue(reportInformation.configuration.microregulation.congestionF2);
                sheet.getRow(1).getCell(9).setCellValue(reportInformation.configuration.microregulation.congestionF3);
            }
            catch (Exception e)
            {
                
            }

            // Table 68
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<8; i++) // 8 accesses
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.microregulation.accesses[i].delay);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 69
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                sheet.getRow(1).getCell(1).setCellValue(reportInformation.configuration.microregulation.abort1);
                sheet.getRow(1).getCell(2).setCellValue(reportInformation.configuration.microregulation.abort2);
                sheet.getRow(1).getCell(3).setCellValue(reportInformation.configuration.microregulation.recover);
            }
            catch (Exception e)
            {
                
            }

            // Table 70
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                int row = 1;
                for(int i=0; i<4; i++)  // 4 tablas de tiempos
                {
                    for(int j=0; j<4; j++) // 4 tranvías
                    {
                        sheet.getRow(row).getCell(1).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].announcementTime);
                        sheet.getRow(row).getCell(2).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].approachTimePosition1);
                        sheet.getRow(row).getCell(3).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].timeoutTimePosition1);
                        sheet.getRow(row).getCell(4).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].approachTimePosition2);
                        sheet.getRow(row).getCell(5).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].timeoutTimePosition2);
                        sheet.getRow(row).getCell(6).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].approachTimePosition3);
                        sheet.getRow(row).getCell(7).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].timeoutTimePosition3);
                        sheet.getRow(row).getCell(8).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].approachTimePosition4);
                        sheet.getRow(row).getCell(9).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].timeoutTimePosition4);
                        sheet.getRow(row).getCell(10).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].timeoutTimeTrafficLight);
                        sheet.getRow(row).getCell(11).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].delayTimeTrafficLight);
                        sheet.getRow(row).getCell(12).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].detectionTimeDouble);
                        sheet.getRow(row).getCell(13).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].cancellationTimeout);
                        sheet.getRow(row).getCell(14).setCellValue(reportInformation.configuration.trolleys.trolleys[j].approachTimes[i].delayTimeDetectionCancellation);
                        row++;
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 71
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                int row = 1;
                for(int i=0; i<4; i++)  // 4 tablas de tiempos
                {
                    for(int j=0; j<4; j++) // 4 tranvías
                    {
                        sheet.getRow(row).getCell(1).setCellValue(reportInformation.configuration.trolleys.trolleys[j].groupTimes[i].pregreenTime);
                        sheet.getRow(row).getCell(2).setCellValue(reportInformation.configuration.trolleys.trolleys[j].groupTimes[i].minimumPassTime);
                        sheet.getRow(row).getCell(3).setCellValue(reportInformation.configuration.trolleys.trolleys[j].groupTimes[i].minimumPassTimeDegraded);
                        sheet.getRow(row).getCell(4).setCellValue(reportInformation.configuration.trolleys.trolleys[j].groupTimes[i].minimumPassTimeDegradedContrary);
                        row++;
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 72
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for(int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    RTZ32_Configuration_Program program = reportInformation.configuration.programs[i];

                    for (int j=0; j<8; j++)
                    {
                        sheet.getRow(i+1).getCell((j*2)+1).setCellValue(program.trolley.times1[j].type);
                        sheet.getRow(i+1).getCell((j*2)+2).setCellValue(program.trolley.times1[j].maximumWaitTime);
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 73
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for(int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    RTZ32_Configuration_Program program = reportInformation.configuration.programs[i];

                    int column = 1;
                    for(int j=0; j<3; j++)
                    {
                        sheet.getRow(i+1).getCell(column++).setCellValue(program.trolley.retractables[j].startTime);
                        sheet.getRow(i+1).getCell(column++).setCellValue(program.trolley.retractables[j].endTime);
                    }

                    for(int j=0; j<4; j++)
                    {
                        sheet.getRow(i+1).getCell(column++).setCellValue(program.trolley.cancellations[j].time);
                        sheet.getRow(i+1).getCell(column++).setCellValue(program.trolley.cancellations[j].timeout);
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 74
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for(int i=0; i<6; i++)  // 6 grupos peatones
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.trolleys.trolleys[0].pedestrians[i].minimumGreenTime);

                    for(int j=0; j<4; j++)  // 4 grupos tranvía
                    {
                        sheet.getRow(i+1).getCell((j*2)+2).setCellValue(reportInformation.configuration.trolleys.trolleys[j].pedestrians[i].safetyTime1);
                        sheet.getRow(i+1).getCell((j*2)+3).setCellValue(reportInformation.configuration.trolleys.trolleys[j].pedestrians[i].safetyTime2);
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 75
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<4; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.trolleys.times[i].toleranceTime);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.trolleys.times[i].inhibitionTime);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 78
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for(int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    RTZ32_Configuration_Program program = reportInformation.configuration.programs[i];
                    sheet.getRow(i+1).getCell(1).setCellValue(program.trolley.times2.synchronizationDirection);
                    sheet.getRow(i+1).getCell(2).setCellValue(program.trolley.times2.synchronizationMaximumAdjustTime);
                    sheet.getRow(i+1).getCell(3).setCellValue(program.trolley.times2.synchronizationType);
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 79
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    for (int j=0; j<2; j++)
                    {
                        sheet.getRow(i+1).getCell((j*2)+1).setCellValue(reportInformation.configuration.programs[i].variablePhases[6 + j].startTime);
                        sheet.getRow(i+1).getCell((j*2)+2).setCellValue(reportInformation.configuration.programs[i].variablePhases[6 + j].endTime);
                    }
                }
            }
            catch (Exception e)
            {
                
            }

            // Table 80
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                {
                    RTZ32_Configuration_Program program = reportInformation.configuration.programs[i];

                    for (int j=0; j<4; j++)
                    {
                        sheet.getRow(i+1).getCell(j+1).setCellValue(program.trolley.correlationsMaster[j].time);
                    }

                    for (int j=0; j<4; j++)
                    {
                        sheet.getRow(i+1).getCell(j+5).setCellValue(program.trolley.correlationsSlave[j].timeout);
                    }
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Report", e);
            }

            // Table 81
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for(int i=0; i<4; i++) // 4 zonas de saturación
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.trolleys.saturations[i].detectors[0]);
                    sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.trolleys.saturations[i].detectors[1]);
                    sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.trolleys.saturations[i].detectors[2]);
                    sheet.getRow(i+1).getCell(4).setCellValue(reportInformation.configuration.trolleys.saturations[i].detectors[3]);
                    sheet.getRow(i+1).getCell(5).setCellValue(reportInformation.configuration.trolleys.saturations[i].presenceTimes[0]);
                    sheet.getRow(i+1).getCell(6).setCellValue(reportInformation.configuration.trolleys.saturations[i].presenceTimes[1]);
                    sheet.getRow(i+1).getCell(7).setCellValue(reportInformation.configuration.trolleys.saturations[i].presenceTimes[2]);
                    sheet.getRow(i+1).getCell(8).setCellValue(reportInformation.configuration.trolleys.saturations[i].presenceTimes[3]);
                    sheet.getRow(i+1).getCell(9).setCellValue(reportInformation.configuration.trolleys.saturations[i].groupsClosing[0]);
                    sheet.getRow(i+1).getCell(10).setCellValue(reportInformation.configuration.trolleys.saturations[i].groupsClosing[1]);
                    sheet.getRow(i+1).getCell(11).setCellValue(reportInformation.configuration.trolleys.saturations[i].groupsClosing[2]);
                    sheet.getRow(i+1).getCell(12).setCellValue(reportInformation.configuration.trolleys.saturations[i].groupsOpening[0]);
                    sheet.getRow(i+1).getCell(13).setCellValue(reportInformation.configuration.trolleys.saturations[i].groupsOpening[1]);
                    sheet.getRow(i+1).getCell(14).setCellValue(reportInformation.configuration.trolleys.saturations[i].groupsOpening[2]);
                }
            }
            catch (Exception e)
            {
                
            }

            for (int p=82; p<=85; p++)
            {
                // Tables 82 to 85
                try
                {
                    HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                    for(int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_PROGRAMS; i++)
                    {
                        sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].startTime);
                        sheet.getRow(i+1).getCell(2).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].endTime);
                        sheet.getRow(i+1).getCell(3).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].timesClosing[0]);
                        sheet.getRow(i+1).getCell(4).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].timesClosing[1]);
                        sheet.getRow(i+1).getCell(5).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].timesClosing[2]);
                        sheet.getRow(i+1).getCell(6).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].timesOpening[0]);
                        sheet.getRow(i+1).getCell(7).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].timesOpening[1]);
                        sheet.getRow(i+1).getCell(8).setCellValue(reportInformation.configuration.programs[i].trolley.saturations[p - 82].timesOpening[2]);
                    }
                }
                catch (Exception e)
                {

                }
            }

            // Table 86
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
            }
            catch (Exception e)
            {
                
            }

            // Table 87
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
            }
            catch (Exception e)
            {
                
            }

            // Table 88
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
            }
            catch (Exception e)
            {
                
            }

            // Table 89
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
            }
            catch (Exception e)
            {
                
            }

            // Table 91
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                {
                    for (int j=0; j<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; j++)
                    {
                        if (i == j)
                        {
                            sheet.getRow(i+1).getCell(j+1).setCellValue("X");
                        }
                        else
                        {
                            if (reportInformation.configuration.groups[i].incompatibilities[j] == true) 
                            {
                                if (sheet.getRow(i+1).getCell(j+1) == null)
                                {
                                    sheet.getRow(i+1).createCell(j+1);
                                }
                                sheet.getRow(i+1).getCell(j+1).setCellValue(1);
                            }
                        }
                    }
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Report", e);
            }

            // Table 92
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                {
                    if (reportInformation.configuration.groups[i].incompatibilityNoRed == true) 
                    {
                        if (sheet.getRow(1).getCell(i+1) == null)
                        {
                            sheet.getRow(1).createCell(i+1);
                        }
                        sheet.getRow(1).getCell(i+1).setCellValue(1);
                    }
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Report", e);
            }

            // Table 93
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                {
                    if (reportInformation.configuration.groups[i].redLampFlashing == true) 
                    {
                        if (sheet.getRow(1).getCell(i+1) == null)
                        {
                            sheet.getRow(1).createCell(i+1);
                        }
                        sheet.getRow(1).getCell(i+1).setCellValue(1);
                    }
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Report", e);
            }

            // Table 94
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                for (int i=0; i<RTZ32_Constants.MAXIMUM_NUMBER_GROUPS; i++)
                {
                    sheet.getRow(i+1).getCell(1).setCellValue(reportInformation.configuration.groups[i].minimumRedLampFlashing);
                }
            }
            catch (Exception e)
            {
                Shared.printstack("Report", e);
            }

            // Table 95
            try
            {
                HSSFSheet sheet = workbook.getSheetAt(sheetNumber++);
                sheet.getRow(1).getCell(1).setCellValue(reportInformation.configuration.controllerNumber);
                sheet.getRow(1).getCell(2).setCellValue(reportInformation.configuration.numberGroups);
            }
            catch (Exception e)
            {
                Shared.printstack("Report", e);
            }

            workbook.setForceFormulaRecalculation(true);
            HSSFFormulaEvaluator.evaluateAllFormulaCells(workbook);
            return saveAndClose(format);
        }
        catch (Exception e)
        {
            Shared.printstack("Report", e);
            throw new ServerException(e);
        }
    }

}