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
<source lang="csharp">
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, Template:70479, "FullControl", true); Tabulation_setShowResultAsPdf(true);
</source>
- 10008vox – RUC
<source lang="csharp">
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, Template:70479, "FullControl", true); Tabulation_setShowResultAsPdf(true);
</source>
Deliveries
Status report
Setup Tabulation report for providing consultant and management with easy overview of project progress.