Introduction
The production team
| Function | Name |
|---|---|
| Consultant (DK) | Ulrik Hjarnaa |
| Data Consultant (VN) | Đàm Thục Vy Vân |
| Data Consultant (VN) | Huỳnh Huy Phong |
Assignment
Our assignments for this project are:
- Create two table reports; each report must include the listed questions as frequency tables and then as cross tables on demographic background variables; Create this as two tabulation script so that it will be to run multiple times.They should have nice table layout and be converted to PDF.
Questionnaire: 10008vox - IntegrationsStatus 2010
Variables report 1: (Report name: 10008vox – Indenrigsministeriet)
Q1inm
Q2inm
Q3inm
Q4inm
Variables report 2: (Report name: 10008vox – RUC)
RUC_1
RUC_2
Demographic variables (Column):
Demographic_Gender
D_Demographic_AgeGroup
D_Demographic_RegionMinimize
RefugeeStatus_dupe
Origin
- Create the stylesheet that takes care of as much as possible of the settings.
Project location
All resources for this project must be created under the project named 10008vox - Integrationsstatus 2010 located on mycatinet.catglobe.com
Tabulation scripts:
- 10008vox – Indenrigsministeriet
setReportStyleSheetId(550);
array aAxes = {"Q1inm_SQ_1","Q1inm_SQ_2","Q1inm_SQ_3","Q1inm_SQ_4","Q1inm_SQ_5","Q2inm","Q3inm","Q4inm"};
array bAxes = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};
array fill_style1 = DiagramFillStyle_getDefault();
array font_AbsCol = DiagramFontStyle_getDefault();
font_AbsCol[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_AbsCol[DIAGRAM_FONT_STYLE_FACE] = "Arial";
font_AbsCol[DIAGRAM_FONT_STYLE_SIZE] = 9;
array style_decimal = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_decimal[TABLE_DIAGRAM_STYLE_FILL] = fill_style1;
style_decimal[TABLE_DIAGRAM_STYLE_FONT] = font_AbsCol;
style_decimal[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;
style_decimal[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_decimal[TABLE_DIAGRAM_STYLE_HALIGN] = "right";
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn, style_decimal);
array font_RowHeader = DiagramFontStyle_getDefault();
font_RowHeader[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#FFFFFF");
font_RowHeader[DIAGRAM_FONT_STYLE_FACE] = "Arial";
font_RowHeader[DIAGRAM_FONT_STYLE_SIZE] = 11 ;
array fill_style = DiagramFillStyle_getDefault();
fill_style[DIAGRAM_FILL_STYLE_COLOR ] = Color_getByRGB("#2666AA");
array style_alignment = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_alignment[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_alignment[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
style_alignment[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_alignment[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
Tabulation_setDiagramStyle(TableDiagram_RowHeader, style_alignment);
Tabulation_setDiagramStyle(TableDiagram_ColumnHeader, style_alignment);
array style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_colheader);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_colheader);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_colheader);
for (number i=0;i < arrayCount(aAxes);i=i+1) {
createFrequenceDiagram(aAxes[i]);
}
style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_colheader);
for (i=0;i < arrayCount(aAxes);i=i+1) {
for (number j=0;j < arrayCount(bAxes);j=j+1)
{
createCrossDiagram({aAxes[i]},{bAxes[j]});
}
}
Tabulation_saveAsReport("10008vox – Indenrigsministeriet", 37088881, {{70479, "FullControl"}}, true);
Tabulation_setShowResultAsPdf(true);
- 10008vox – RUC
setReportStyleSheetId(550);
array aRow = {"RUC_1","RUC_2"};
array aCol = {"Demographic_Gender","D_Demographic_AgeGroup","D_Demographic_RegionMinimize","RefugeeStatus_dupe","Origin"};
array fill_style1 = DiagramFillStyle_getDefault();
array font_AbsCol = DiagramFontStyle_getDefault();
font_AbsCol[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#000000");
font_AbsCol[DIAGRAM_FONT_STYLE_FACE] = "Arial";
font_AbsCol[DIAGRAM_FONT_STYLE_SIZE] = 9 ;
array style_decimal = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_decimal[TABLE_DIAGRAM_STYLE_FILL] = fill_style1;
style_decimal[TABLE_DIAGRAM_STYLE_FONT] = font_AbsCol;
style_decimal[TABLE_DIAGRAM_STYLE_DECIMAL] = 0;
style_decimal[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_decimal[TABLE_DIAGRAM_STYLE_HALIGN] = "right";
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumn, style_decimal);
array font_RowHeader = DiagramFontStyle_getDefault();
font_RowHeader[DIAGRAM_FONT_STYLE_COLOR] = Color_getByRGB("#FFFFFF");
font_RowHeader[DIAGRAM_FONT_STYLE_FACE] = "Arial";
font_RowHeader[DIAGRAM_FONT_STYLE_SIZE] = 11 ;
array fill_style = DiagramFillStyle_getDefault();
fill_style[DIAGRAM_FILL_STYLE_COLOR ] = Color_getByRGB("#2666AA");
array style_alignment = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_alignment[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_alignment[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
style_alignment[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_alignment[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
Tabulation_setDiagramStyle(TableDiagram_RowHeader, style_alignment);
Tabulation_setDiagramStyle(TableDiagram_ColumnHeader, style_alignment);
array style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "center";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel2, style_colheader);
Tabulation_setDiagramStyle(TableDiagram_AbsoluteColumnHeader, style_colheader);
Tabulation_setDiagramStyle(TableDiagram_PercentageColumnHeader, style_colheader);
for (number i=0;i < arrayCount(aRow);i=i+1) {
createFrequenceDiagram(aRow[i]);
}
style_colheader = Tabulation_getDefaultDiagramStyle(Diagram_Type_Table);
style_colheader[TABLE_DIAGRAM_STYLE_FILL] = fill_style;
style_colheader[TABLE_DIAGRAM_STYLE_FONT] = font_RowHeader;
style_colheader[TABLE_DIAGRAM_STYLE_VALIGN] = "center";
style_colheader[TABLE_DIAGRAM_STYLE_HALIGN] = "left";
Tabulation_setDiagramStyle(TableDiagram_ColumnHeaderLevel1, style_colheader);
for (i=0;i < arrayCount(aCol);i=i+1) {
for (number j=0;j < arrayCount(aRow);j=j+1)
{
createCrossDiagram({aRow[j]},{aCol[i]});
}
}
Tabulation_saveAsReport("10008vox - RUC", 37088881, {{70479, "FullControl"}}, true);
Tabulation_setShowResultAsPdf(true);
Deliveries
Status report
Setup Tabulation report for providing consultant and management with easy overview of project progress.