Difference between revisions of "CEM Economy Intelligence"

From Catglobe Wiki
Jump to: navigation, search
(→‎To do)
 
(37 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
<accesscontrol>Main:MyGroup</accesscontrol>
 +
[[Category:Miscellaneous]]
 +
 
== Introduction  ==
 
== Introduction  ==
  
Line 10: Line 13:
 
|-
 
|-
 
! Description  
 
! Description  
−
! Discussion
+
! Discussion  
 
! Responsible  
 
! Responsible  
 
! Priority  
 
! Priority  
Line 16: Line 19:
 
! Date completed  
 
! Date completed  
 
! Status
 
! Status
 +
|-
 +
| Copy tables to clipboard&nbsp;
 +
| <br>
 +
| Luan
 +
| 1
 +
| 2010/02/12
 +
| <br>
 +
| Start
 
|-
 
|-
 
|  
 
|  
−
''Import data for 2009 Q4 back to Access database''
+
Import data for 2009 Q4 back to Access database  
 +
 
 +
We decided to use the old approach one more time for the Q4/2009 report:
  
−
''We decided to use the old approach one more time for the Q4/2009 report:''
+
#Data is collected in Catglobe
 +
#Data is exported, cleaned and imported into the old MS Access database
  
−
#''Data is collected in Catglobe''
+
|
−
#''Data is exported, cleaned and imported into the old MS Access database''
+
Casper (2009/12/22): Is this project not finished??
  
−
| Casper (2009/12/22): Is this project not finished??
+
Luan (2009/12/23): Mr. Duc has finished part of it, and Mr. Phong (DK) will take over responsibility.
−
| Anh Duc  
+
 
 +
| Anh Duc,&nbsp;Phong (DK)
 
| 1  
 
| 1  
 
| 2009/12/25  
 
| 2009/12/25  
Line 33: Line 48:
 
|-
 
|-
 
|  
 
|  
−
''Zero data problem. Where are we with a decision for zero data?''
+
New segmentation definitions
 +
 
 +
|
 +
Luan (2010/01/15): An update on the progress
 +
 
 +
Region: data for D_ZipCode looks wrong, so no conversion until Dennis &amp; Van Anh fix it&nbsp;(Deadline:&nbsp;2010/01/21)
 +
 
 +
Beskæftigelse: done
 +
 
 +
Husstandsindkomst: waiting for more info from Casper
 +
 
 +
Alder, Husstandsindkomst, &amp; Boligtype: data for&nbsp;D_IFKA_Age_Group, D_IFKA_Household_Income, and&nbsp;D_Accommodation in Q4/2007, Q3/2003, &amp; Q3/2008 are missing. Dennis &amp; Van Anh are handling this (Deadline: 2010/01/21)
 +
 
 +
| Dennis, Van Anh, Luan
 +
| 1
 +
| 2010/01/22
 +
| <br>
 +
| Half
 +
|-
 +
|
 +
Zero data problem. Where are we with a decision for zero data?
  
 
|  
 
|  
−
Luan (2009/12/22): This project will solve the problem: VN2798REP - Report style sheet - Setting to display or hide zero values in diagrams. The plan is to finish the project on the 4th of January 2010. So the deadline for this task must be put off to at least 3 days after that, thus 2010/01/08.  
+
Luan (2009/12/22): This project will solve the problem: ''VN2798REP - Report style sheet - Setting to display or hide zero values in diagrams''. The plan is to finish the project on the 4th of January 2010. So the deadline for this task must be put off to at least 3 days after that, thus 2010/01/08.  
 +
 
 +
Casper (2009/12/22): The sooner this is done, the better!
  
−
Casper (2009/12/22): The sooner this is done, the better!
+
Luan (2009/12/18):&nbsp;Due to some bugs, Report finally decided to disable the feature in today's upload. Awesome!&nbsp;:-&#124;
  
 
| Thomas, Luan  
 
| Thomas, Luan  
Line 47: Line 84:
 
|-
 
|-
 
|  
 
|  
−
''Update dashboard: Catinét opinion. By default no parties are shown in the tracking diagram.''
+
Update dashboard: Catinét opinion. By default no parties are shown in the tracking diagram.  
  
−
''The customer must select which parties to view the tracking diagram for, and then click the Update button to show the tracking diagram.''&nbsp;
+
The customer must select which parties to view the tracking diagram for, and then click the Update button to show the tracking diagram.&nbsp;
  
 
|  
 
|  
−
Luan (2009/12/22): Currently, it is impossible to do this, and there're no plans for making it possible! This explains why this task is on pause indefinitely.
+
Luan (2009/12/22): Currently, it is impossible to do this, and there're no plans for making it possible! This explains why this task is on pause indefinitely.  
  
 
Casper (2009/12/22): A solution on how to present data are Caspers responsibility. But for now, the current diagram will do.
 
Casper (2009/12/22): A solution on how to present data are Caspers responsibility. But for now, the current diagram will do.
  
−
| Luan  
+
| Luan, Casper
 
| 3  
 
| 3  
 
| <br>
 
| <br>
Line 63: Line 100:
 
|-
 
|-
 
|  
 
|  
−
''Moving periods.<br>''
+
Period selection should be implemented.<br>
  
−
''Casper send us a document with updates related to periods for all diagrams, some diagrams are predicting what will happen the following 3 months based on respondents answers.''
+
User should be able to select start and end data as a start.<br>Later on selections on point size will be an obivious addition.  
  
−
''Project needed in order to solve the skewed periods, this is also the reason we do not use time sets.''&nbsp;
+
Thắng is working on a modification for time set which might already be uploaded.  
  
−
|
+
The new time set type is already available on version 5.7, next step is to create a project for version 5.9 which will make it possible to use time sets with tracking diagrams.
−
Luan (2009/12/22): A proper project might come later. For now, we will manually convert all the cross diagrams that show predictions about different periods in the same graph to static diagrams. I have received a list of these diagrams, but I won't finish this task before the 31st of December 2009 since some tasks with higher priority just came along.
 
−
 
 
−
Casper (2009/12/22): Important information:<br>As will be describer further down, the collecting of weekly data are to be stopped. In stead all data will be collected monthly. That means that we only will have monthly/quartely diagrams.<br>The monthly diagrams are, like the quartely, to have the expectation line moved only one period (1 month) forward.
 
  
−
| Luan, Thomas
 
−
| 3
 
−
| 2009/12/31
 
−
| <br>
 
−
| Start
 
−
|-
 
 
|  
 
|  
−
''Period selection should be implemented.<br>''
+
Casper (2009/12/22): As I read your coment, this is already possible but not in newer versions?
  
−
''User should be able to select start and end data as a start.<br>Later on selections on point size will be an obivious addition.''
+
Luan (2009/12/23): The project is planned for 6.0 and I don't know exactly when it will come out yet, so the current deadline 2010/02/26 might change.
  
−
''Thắng is working on a modification for time set which might already be uploaded.''
 
−
 
−
''The new time set type is already available on version 5.7, next step is to create a project for version 5.9 which will make it possible to use time sets with tracking diagrams.''
 
−
 
−
| Casper (2009/12/22): As I read your coment, this is already possible but not in newer versions?
 
 
| Luan  
 
| Luan  
 
| 4  
 
| 4  
Line 97: Line 120:
 
|-
 
|-
 
|  
 
|  
−
''Segmentation must be multiple.''
+
Stylesheet for diagrams.  
  
−
''It must be possible to select multiple age groups and regions.''
+
Review diagram style sheet, diagrams must be less Excel like.  
  
−
''We need a status from Report on a development project.''
+
More details needed about what is good and what is bad?
−
 
 
−
''The feature is implemented in version 5.8, making a merge back now would probably be a bad idea.''
 
  
 
|  
 
|  
−
Luan (2009/12/22): The plan is to have 5.8 on mycatinet on the 28th December 2009 the latest.  
+
Luan (2009/12/22): This task is on pause until I get clear instructions on how to make the diagrams look more fancy.  
  
−
Casper (2009/12/22): Does it take 17 days to get this working?
+
Casper (2009/12/22): Casper is working on it. Hopefully a design is ready before Christmas.
  
−
| Luan  
+
Luan (2010/01/06): I already received the design from Casper but I haven't come round to it yet.
−
| 5
 
−
| 2010/01/15
 
−
| <br>
 
−
| Start
 
−
|-
 
−
|
 
−
''Stylesheet for diagrams.''
 
−
 
 
−
''Review diagram style sheet, diagrams must be less Excel like.''
 
−
 
 
−
''More details needed about what is good and what is bad?''
 
−
 
 
−
|
 
−
Luan (2009/12/22): This task is on pause until I get clear instructions on how to make the diagrams look more fancy.
 
−
 
 
−
Casper (2009/12/22): Casper is working on it. Hopefully a design is ready before Christmas.
 
  
 
| Luan  
 
| Luan  
Line 132: Line 137:
 
| 2010/01/29  
 
| 2010/01/29  
 
| <br>
 
| <br>
−
| Paused
+
| Half
 
|-
 
|-
 
|  
 
|  
−
''Same Y-axis for weekly/monthly and quarterly data''&nbsp;
+
Same Y-axis for weekly/monthly and quarterly data&nbsp;
  
 
|  
 
|  
−
Luan (2009/12/22): One style sheet for one diagram is a bad idea, imagine changing the chart background color, for example, would take a day! In order to finish this task, Casper needs to group similar diagrams together as much as possible based on the fact that they can have the same y-axis scale. Until I have this information, this task is on pause.
+
Luan (2009/12/22): One style sheet for one diagram is a bad idea, imagine changing the chart background color, for example, would take a day! In order to finish this task, Casper needs to group similar diagrams together as much as possible based on the fact that they can have the same y-axis scale. Until I have this information, this task is on pause.  
  
 
Casper (2009/12/22): Since we are to update the design among other things, this is a reasonable pausing&nbsp;:-)
 
Casper (2009/12/22): Since we are to update the design among other things, this is a reasonable pausing&nbsp;:-)
Line 149: Line 154:
 
|-
 
|-
 
|  
 
|  
−
''Cross tabulation - Adjust width of axis selection boxes to show full text''
+
Cross tabulation - Adjust width of axis selection boxes to show full text
 +
 
 +
|
 +
Casper (2009/12/22): Is it the year or the data in the deadline that is wrong?
 +
 
 +
Luan (2009/12/23): Both were wrong&nbsp;:-p
  
−
| Casper (2009/12/22): Is it the year or the data in the deadline that is wrong?
 
 
| Luan  
 
| Luan  
 
| 5  
 
| 5  
−
| 2010/02/28
+
| 2010/02/26
 
| <br>
 
| <br>
 
| Start
 
| Start
 
|-
 
|-
 
|  
 
|  
−
''All data are now being collected monthly or weekly. That means that all diagrams will have a working monthly button, but not all will have a working weekly button. This has the following implications:''
+
Gridlines on the front dashboard and in the monitor. Could you please remove all vertical gridlines (just put a small dot to mark the axis label placement) and make all the vertical lines dotted like this (- - - - -). The color is to stay the same, but perhaps the line could be even thinner. The gridlines are meant as a help to the eye, not as something that should stand out in the diagram. Before you change all diagrams, please change 1 and write me which one I shall take a look at
−
 
 
−
''A. All diagrams with weekly data are to have a working buttons for both monthly and weekly diagrams''
 
−
 
 
−
''B. All diagrams with monthly data collected since week 40 are to have a working monthly data button and a weekly button that is grayed out with a mouse over with this content “Data er ikke tilgængelig på ugeniveau”.''
 
−
 
 
−
''C. Diagrams that are built on data until now collected quarterly are to, until February 1, to have both weekly and monthly buttons greyed out. The weekly button is to have the same content as above, but the monthly data mouse over is to say “Data er tilgængelig fra 1. februar 2010”.''
 
  
 
|  
 
|  
−
Casper (2009/12/22): As mentioned earlier, we are to stopping the data collection for weekly data. This is to become monthly.This has the implication that all weekly diagrams are to be removed as well as the buttons with acces to weekly data.  
+
Casper (2009/12/22): Please update the front dashboard ASAP. The monitor can wait a bit since we are to come up with a neww design.  
  
−
All diagrams are to be updated monthly from now on which means that this is the task:<br>
+
Luan (2009/12/23):  
  
−
A. All diagrams, currently with weekly data, are to have a working buttons for monthly diagrams
+
"''remove all vertical gridlines''" - Done!
  
−
B. All diagrams with monthly data collected since week 40 are to have a working monthly data button.  
+
"''just put a small dot to mark the axis label placement''" - We can't control these elements yet through style sheet settings.  
  
−
C. Diagrams that are built on data until now collected quarterly are to, until February 1, to have a monthly button that is greyed out until february 1. The mouse over is to say “Data er tilgængelig fra 1. februar 2010”.
+
"''make all the vertical lines dotted like this''" - I presume you mean horizontal gridlines, right?
  
−
All weekly diagrams, and the the access buttons are to be removed from CEM Economy.
+
"the line could be even thinner" - That is already the thinnest size, 1px.
  
 
| Luan  
 
| Luan  
 
| 5  
 
| 5  
−
| 2009/02/28
+
| 2010/02/26
−
| <br>
 
−
| Start
 
−
|-
 
−
|
 
−
''Gridlines on the front dashboard and in the monitor. Could you please remove all vertical gridlines (just put a small dot to mark the axis label placement) and make all the vertical lines dotted like this (- - - - -). The color is to stay the same, but perhaps the line could be even thinner. The gridlines are meant as a help to the eye, not as something that should stand out in the diagram. Before you change all diagrams, please change 1 and write me which one I shall take a look at''
 
−
 
 
−
| Casper (2009/12/22): Please update the front dashboard ASAP. The monitor can wait a bit since we are to come up with a neww design.
 
−
| Luan
 
−
| 5
 
−
| 2009/02/28
 
 
| <br>
 
| <br>
 
| Start
 
| Start
 
|-
 
|-
 
|  
 
|  
−
''On the front dashboard, please mark the 0-line bold on the two diagrams where it is relevant.''
+
Would it be possible to do a mouse over for the diagrams, so that if you hold the mouse over e.g. the point on the line above december 2009 it will be possible to see the exact value for that period?
−
 
 
−
| Casper (2009/12/22): Please make it a higher priority. The task is simple but will help the viewers quite a bit.
 
−
| Luan
 
−
| 5
 
−
| 2009/02/28
 
−
| <br>
 
−
| Start
 
−
|-
 
−
|
 
−
''Would it be possible to do a mouse over for the diagrams, so that if you hold the mouse over e.g. the point on the line above december 2009 it will be possible to see the exact value for that period?''
 
  
 
|  
 
|  
Line 221: Line 204:
 
|-
 
|-
 
|  
 
|  
−
''Document how to manually update static diagrams weekly, monthly, quarterly''
+
Document how to manually update static diagrams weekly, monthly, quarterly
  
−
| Casper (2009/12/22): Good idea
+
| Casper (2009/12/22): Good idea  
 
| Luan  
 
| Luan  
 
| 5  
 
| 5  
−
| 2010/02/28
+
| 2010/02/26
 
| <br>
 
| <br>
 
| Start
 
| Start
 
|-
 
|-
 
|  
 
|  
−
''A special data file for Casper to compare IFKA data with Catglobe data''
+
Automate the process of updating diagram A6 on the front dashboard
 +
 
 +
| <br>
 +
| Luan, Khanh
 +
| 5
 +
| 2010/02/26
 +
| <br>
 +
| Half
 +
|-
 +
|
 +
A special data file for Casper to compare IFKA data with Catglobe data
  
 
| <br>
 
| <br>
Line 241: Line 234:
 
|-
 
|-
 
|  
 
|  
−
''Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data.''
+
Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data.
  
 
| <br>
 
| <br>
Line 251: Line 244:
 
|-
 
|-
 
|  
 
|  
−
''Cross tabulation for CEM Economy''
+
Cross tabulation for CEM Economy
  
 
| <br>
 
| <br>
Line 261: Line 254:
 
|-
 
|-
 
|  
 
|  
−
''Replace the table at location A3 on the front dashboard with a bar chart''
+
Replace the table at location A3 on the front dashboard with a bar chart
  
 
| Casper (2009/12/22): Under the headline we are to write the following:  
 
| Casper (2009/12/22): Under the headline we are to write the following:  
 
År 2000 = Indeks 100  
 
År 2000 = Indeks 100  
  
−
And could you make the bars a bit wider. No need for the spacing to be that wide
+
And could you make the bars a bit wider. No need for the spacing to be that wide  
 +
 
 +
Luan (2009/12/23): Done!
  
 
| Luan  
 
| Luan  
 
| 1  
 
| 1  
−
| 2009/12/22
+
| 2009/12/23
−
| 2009/12/22
+
| 2009/12/23
 
| DONE
 
| DONE
−
|}
+
|-
 +
|
 +
On the front dashboard, please mark the 0-line bold on the two diagrams where it is relevant.
 +
 
 +
|
 +
Casper (2009/12/22): Please make it a higher priority. The task is simple but will help the viewers quite a bit.
  
−
== Diagram correction&nbsp;status  ==
+
Luan (2009/12/23): Done&nbsp;:-)
  
−
{| class="CGTable" border="1"
+
| Luan
−
|-
+
| 1&nbsp;
−
! Description
+
| 2009/12/23
−
! Comments from Copenhagen
+
| 2009/12/23
−
! Responsible
+
| DONE
−
! Priority
 
−
! Deadline
 
−
! Date completed
 
−
! Status
 
 
|-
 
|-
 
|  
 
|  
−
''Forbrug - Ferie''
+
Segmentation must be multiple.
 +
 
 +
It must be possible to select multiple age groups and regions.
 +
 
 +
We need a status from Report on a development project.
 +
 
 +
The feature is implemented in version 5.8, making a merge back now would probably be a bad idea.
 +
 
 +
|
 +
Luan (2009/12/22): The plan is to have 5.8 on mycatinet on the 28th December 2009 the latest.
  
−
''There are only one period of data for "Ferie i Danmark", so please delete the yellow line up the point where we have data''
+
Casper (2009/12/22): Does it take 17 days to get this working?
  
−
''IFKA report: Page 50''
+
Luan (2009/12/23): No. But we have other tasks with higher priority.
  
−
2009/12/21 Luan: 0-data problem
+
Luan (2009/12/31): Finally, I had to do this first since nothing worked after this feature had been deployed.
  
−
| <br>
+
| Luan
 +
| 5
 +
| 2010/01/15
 +
| 2009/12/30
 +
| DONE
 +
|-
 +
|
 +
Update data cache to use Thomas's new period variables like D_Year, D_Month, D_IFKA_YearQuarter...
 +
 
 +
| Luan (2009/12/24): This task is quite important since it has to be finished before the automated update process can start.
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
−
| 2010/01/08
+
| 2009/12/31
 +
| 2010/01/05
 +
| DONE
 +
|-
 +
|
 +
Update diagram A6 on the front dashboard with newest data
 +
 
 
| <br>
 
| <br>
−
| Start
+
| Luan
 +
| 1
 +
| 2010/01/05
 +
| 2010/01/05
 +
| DONE
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Seere til nyhedsudsendelser''
+
All data are now being collected monthly or weekly. That means that all diagrams will have a working monthly button, but not all will have a working weekly button. This has the following implications:
 +
 
 +
A. All diagrams with weekly data are to have a working buttons for both monthly and weekly diagrams
  
−
''There are shown 0-data for some years in the beginning.''
+
B. All diagrams with monthly data collected since week 40 are to have a working monthly data button and a weekly button that is grayed out with a mouse over with this content “Data er ikke tilgængelig på ugeniveau”.  
  
−
''IFKA report: Page 61 (DR1 and TV2)''
+
C. Diagrams that are built on data until now collected quarterly are to, until February 1, to have both weekly and monthly buttons greyed out. The weekly button is to have the same content as above, but the monthly data mouse over is to say “Data er tilgængelig fra 1. februar 2010”.
 +
 
 +
|
 +
Casper (2009/12/22): As mentioned earlier, we are to stopping the data collection for weekly data. This is to become monthly.This has the implication that all weekly diagrams are to be removed as well as the buttons with acces to weekly data.
 +
 
 +
All diagrams are to be updated monthly from now on which means that this is the task:<br>
 +
 
 +
A. All diagrams, currently with weekly data, are to have a working buttons for monthly diagrams
 +
 
 +
B. All diagrams with monthly data collected since week 40 are to have a working monthly data button.
 +
 
 +
C. Diagrams that are built on data until now collected quarterly are to, until February 1, to have a monthly button that is greyed out until february 1. The mouse over is to say “Data er tilgængelig fra 1. februar 2010”.
 +
 
 +
All weekly diagrams, and the the access buttons are to be removed from CEM Economy.
 +
 
 +
Luan (2010/01/05): Although this is a low priority task, I did&nbsp;it as I were fixing the multiple segmentation thing so as to save time.
 +
 
 +
| Luan
 +
| 5
 +
| 2010/02/26
 +
| 2010/01/05
 +
| DONE
 +
|-
 +
|
 +
A segmentation data file for Casper
  
 
| <br>
 
| <br>
 +
| Dennis
 +
| 1
 +
| 2010/01/22
 +
| 2010/01/10
 +
| DONE
 +
|-
 +
|
 +
Moving periods.<br>
 +
 +
Casper send us a document with updates related to periods for all diagrams, some diagrams are predicting what will happen the following 3 months based on respondents answers.
 +
 +
Project needed in order to solve the skewed periods, this is also the reason we do not use time sets.&nbsp;
 +
 +
|
 +
Luan (2009/12/22): A proper project might come later. For now, we will manually convert all the cross diagrams that show predictions about different periods in the same graph to static diagrams. I have received a list of these diagrams, but I won't finish this task before the 31st of December 2009 since some tasks with higher priority just came along.
 +
 +
Casper (2009/12/22): Important information:<br>As will be describer further down, the collecting of weekly data are to be stopped. In stead all data will be collected monthly. That means that we only will have monthly/quartely diagrams.<br>The monthly diagrams are, like the quartely, to have the expectation line moved only one period (1 month) forward.
 +
 +
Luan (2010/01/06): Here are the diagrams that need converting. Strikethrough means done.
 +
 +
'''Husstandens økonomi'''<br><strike>Husstandens økonomiske situation&nbsp;(2010/01/06)</strike>
 +
 +
'''Forbrug '''<br><strike>Køb af hårde hvidevarer (2010/01/06)<br>Køb af radio/tv/video/dvd (2010/01/06)<br>Køb af møbler (2010/01/06)</strike><br><strike>Køb af gulvtæpper (2010/01/07)</strike><br><strike>Køb af el-værktøj/haveredskaber (2010/01/07)</strike><br><strike>Køb af PC’er (2010/01/07)</strike><br><strike>Køb af mobiltelefon (2010/01/07)</strike><br><strike>Køb af fotoudstyr (2010/01/07)</strike><br><strike>Køb af bøger (2010/01/07)</strike><br><strike>Køb af musik / film på cd/dvd (2010/01/07)</strike>
 +
 +
'''Opsparing, pension, låntagning og investering'''<br><strike>Opsparing (2010/01/07) </strike><br><strike>Lån af penge til forbrug (2010/01/07) </strike><br><strike>Investering i aktie (2010/01/07) </strike><br><strike>Investering i obligationer (2010/01/07) </strike><br><strike>Investering i anparter (2010/01/07) <br>Pensionsopsparing (2010/01/07) </strike><br><strike>Køb på kredit (2010/01/08)</strike>
 +
 +
'''Personbiler'''<br><strike>Køb af ny bil (2010/01/08)</strike><br><strike>Køb af brugt bil&nbsp;(2010/01/08)</strike>
 +
 +
'''Flytning, bolig og realkredit'''<br><strike>Køb og salg af huse (2010/01/08)<br>Køb og salg af ejerlejligheder (2010/01/08)<br>Køb og salg af andelslejligheder (2010/01/08)<br>Køb og salg af sommerhuse (2010/01/08)<br>Nybyggeri (2010/01/08)</strike><br><strike>Salgsplaner (2010/01/12)</strike><br><strike>Flytteplaner (2010/01/12)</strike><br><strike>Kreditforeningslån (2010/01/12)</strike><br><strike>Afdragsfrit kreditforeningslån (2010/01/12)</strike>
 +
 +
'''Boligens indretning'''<br><strike>Gennemføring af større til- eller ombygninger (2010/01/12)</strike><br><strike>Køb af nyt køkken (2010/01/12)</strike><br><strike>Køb af nyt badeværelse&nbsp;(2010/01/12)</strike>
 +
 +
'''Medieforhold og Internet'''<br><strike>Anskaffelse af Internetadgang (2010/01/12)</strike>
 +
 +
'''Arbejdsmarkedet'''<br><strike>Faktisk og forventet ledighed i egen husstand (2010/01/12)</strike>
 +
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
−
| 2010/01/08
+
| 2010/01/29
 +
| 2010/01/12
 +
| DONE
 +
|-
 +
|
 +
Link to Catglobe Economy PDF user guide: Left menu&gt; Brugermanual&gt; Klik her for at downloade
 +
 
 
| <br>
 
| <br>
−
| Start
+
| Luan
 +
| 5
 +
| 2010/02/26
 +
| 2010/01/18
 +
| DONE
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Reklameindslag på radiostationer''
+
Name quarters after seasons
  
−
''There are shown 0-data for some years in the beginning. But no data to compare with''
+
Q1 -&gt; Vinter
  
 +
Q2 -&gt; Forår
 +
 +
Q3 -&gt; Sommer
 +
 +
Q4 -&gt; Efterår
 +
 +
| <br>
 +
| Cam Tu, Tu Anh, Luan
 +
| 1
 +
| 2010/01/28
 +
| 2010/01/28
 +
| DONE
 +
|-
 +
| Data tables
 +
| <br>
 +
| Cam Tu, Tu Anh, Luan
 +
| 1
 +
| 2010/02/05
 +
| 2010/02/22
 +
| DONE
 +
|-
 +
| Statistical tables
 
| <br>
 
| <br>
 +
| Luan
 +
| 1
 +
| 2010/02/12
 +
| 2010/03/10
 +
| DONE
 +
|}
 +
 +
== Diagram correction&nbsp;status  ==
 +
 +
{| class="CGTable" border="1"
 +
|-
 +
! Description
 +
! Discussion&nbsp;
 +
! Responsible
 +
! Priority
 +
! Deadline
 +
! Date completed
 +
! Status
 +
|-
 +
|
 +
Forbrug - Ferie
 +
 +
There are only one period of data for "Ferie i Danmark", so please delete the yellow line up the point where we have data
 +
 +
IFKA report: Page 50
 +
 +
| Luan (2009/12/21): 0-data problem
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
Line 330: Line 475:
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Daglig læsning af gratisaviser''
+
Medieforhold og Internet - Seere til nyhedsudsendelser
 +
 
 +
There are shown 0-data for some years in the beginning.
  
−
''Remowe 0-data from "24-timer" and let the diagram start when there are data. Data does not match IFKA data''
+
IFKA report: Page 61 (DR1 and TV2)
  
 
| <br>
 
| <br>
−
| Anh Duc, Luan  
+
| Luan  
−
| 1
+
| 3
−
| 2009/12/04
+
| 2010/01/08
 
| <br>
 
| <br>
 
| Start
 
| Start
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Internetanvendelse''
+
Medieforhold og Internet - Reklameindslag på radiostationer
  
−
''Remove 0-data from the lines where no data exists - and IFKA has data older than 2003''
+
There are shown 0-data for some years in the beginning. But no data to compare with
  
 
| <br>
 
| <br>
Line 354: Line 501:
 
|-
 
|-
 
|  
 
|  
−
''Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads''
+
Medieforhold og Internet - Daglig læsning af gratisaviser
−
 
 
−
''The diagram has the same shape as the one in tha IFKA report, but the level seems to be higher than IFKas level. Se eg the lowest point in the diagrams and you will find a difference of 4 points''
 
  
−
''IFKA report: Page 14''
+
Remowe 0-data from "24-timer" and let the diagram start when there are data. Data does not match IFKA data
  
 
| <br>
 
| <br>
−
| Luan  
+
| Anh Duc, Luan  
−
| 3
+
| 1
−
| 2010/01/08
+
| 2009/12/04
 
| <br>
 
| <br>
 
| Start
 
| Start
 
|-
 
|-
 
|  
 
|  
−
''Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads - Virksomhedstype''
+
Medieforhold og Internet - Internetanvendelse
−
 
 
−
''This diagram looks good - but it is created of data from the above diagram, so perhaps the shares are slightly of''
 
  
−
''IFKA report: Page 15''
+
Remove 0-data from the lines where no data exists - and IFKA has data older than 2003
  
−
| <br>
+
| Luan (2009/12/23): According to Anh Duc, the IFKA database doesn't contain data for WQ656_Internet_Usage_Within_This_Week before 2003. So hiding the empty area will solve the problem?
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
Line 382: Line 525:
 
|-
 
|-
 
|  
 
|  
−
''Politik og bekymring - Bekymring for fødevarernes kvalitet''
+
Politik og bekymring - Bekymring for fødevarernes kvalitet  
  
−
''REMOVE THE DIAGRAM''
+
REMOVE THE DIAGRAM
  
 
| <br>
 
| <br>
Line 394: Line 537:
 
|-
 
|-
 
|  
 
|  
−
''Personbiler - Antal biler i husstanden''
+
Personbiler - Antal biler i husstanden  
  
−
''REMOVE THE DIAGRAM''
+
REMOVE THE DIAGRAM
  
 
| <br>
 
| <br>
Line 406: Line 549:
 
|-
 
|-
 
|  
 
|  
−
''Flytning, bolig og realkredit - Kreditforeningslån''
+
Flytning, bolig og realkredit - Kreditforeningslån  
−
 
 
−
''Question tekst is wrong. Again there are shown 0-data for some years in the beginning.''
 
  
−
2009/12/03 Luan: Question text was fixed. I didn't see 0-data here. Probably, the problematic periods are hidden.
+
Question tekst is wrong. Again there are shown 0-data for some years in the beginning.&nbsp;
  
−
| <br>
+
| Luan (2009/12/03): Question text was fixed. I didn't see 0-data here. Probably, the problematic periods are hidden.
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
Line 420: Line 561:
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Læser avis''
+
Medieforhold og Internet - Læser avis  
  
−
''Something wrong with the blue line. It shoots to 100%. Othervise, it looks good''
+
Something wrong with the blue line. It shoots to 100%. Othervise, it looks good  
  
−
''IFKA report: Page 63 ("Hverdagsavis" and "Søndagsavis")''
+
IFKA report: Page 63 ("Hverdagsavis" and "Søndagsavis")
  
 
| <br>
 
| <br>
Line 434: Line 575:
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Læsning af tilbudsaviserne''
+
Medieforhold og Internet - Læsning af tilbudsaviserne  
  
−
''Remove legend''
+
Remove legend
  
 
| <br>
 
| <br>
Line 446: Line 587:
 
|-
 
|-
 
|  
 
|  
−
''Politik og bekymring - Bekymring for udviklingen i den globale økonomi''
+
Politik og bekymring - Bekymring for udviklingen i den globale økonomi  
  
−
''Diagram are to start when data collection starts in 08/09''
+
Diagram are to start when data collection starts in 08/09
  
 
| <br>
 
| <br>
Line 458: Line 599:
 
|-
 
|-
 
|  
 
|  
−
''Forbrug - Køb af musik/film på cd/dvd''
+
Forbrug - Køb af musik/film på cd/dvd  
−
 
 
−
''No data before september 2000 - Remove 0-data and let trhe diagram start in sep 2000''
 
  
−
''IFKA report: Page 49''
+
No data before september 2000 - Remove 0-data and let trhe diagram start in sep 2000
  
−
2009/12/04 Luan: 0-data problem, but hiding the unnecessary periods can do the trick
+
IFKA report: Page 49&nbsp;
  
−
| <br>
+
| Luan (2009/12/04): 0-data problem, but hiding the unnecessary periods can do the trick
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
Line 474: Line 613:
 
|-
 
|-
 
|  
 
|  
−
''Opsparing, pension, låntagning og investering - Investering i aktier''
+
Opsparing, pension, låntagning og investering - Investering i aktier  
  
−
''The diagram are not to start before data collection begins which is for september 2009''
+
The diagram are not to start before data collection begins which is for september 2009
  
 
| <br>
 
| <br>
Line 486: Line 625:
 
|-
 
|-
 
|  
 
|  
−
''Opsparing, pension, låntagning og investering - Investering i obligationer''
+
Opsparing, pension, låntagning og investering - Investering i obligationer  
  
−
''The diagram are not to start before data collection begins which is for september 2009''
+
The diagram are not to start before data collection begins which is for september 2009
  
 
| <br>
 
| <br>
Line 498: Line 637:
 
|-
 
|-
 
|  
 
|  
−
''Opsparing, pension, låntagning og investering - Investering i anparter''
+
Opsparing, pension, låntagning og investering - Investering i anparter  
  
−
''The diagram are not to start before data collection begins which is for september 2009''
+
The diagram are not to start before data collection begins which is for september 2009
  
 
| <br>
 
| <br>
Line 510: Line 649:
 
|-
 
|-
 
|  
 
|  
−
''Flytning, bolig og realkredit - Afdragsfrie kreditforeningslån''
+
Flytning, bolig og realkredit - Afdragsfrie kreditforeningslån  
  
−
''Question tekst is wrong. Only show diagram from the time data collection began in December 2003''
+
Question tekst is wrong. Only show diagram from the time data collection began in December 2003
  
 
| <br>
 
| <br>
Line 522: Line 661:
 
|-
 
|-
 
|  
 
|  
−
''Politik og bekymring - Tillid til regering/opposition''
+
Politik og bekymring - Tillid til regering/opposition  
  
−
''Missing data that are not missing in IFKA report''
+
Missing data that are not missing in IFKA report  
  
−
''IFKA report: Page 7''
+
IFKA report: Page 7  
  
−
''Series 1: WQ060_Government_Confidence''
+
Series 1: WQ060_Government_Confidence  
  
−
''Series 2: WQ140_Opposition_Confidence''
+
Series 2: WQ140_Opposition_Confidence
  
 
| <br>
 
| <br>
Line 540: Line 679:
 
|-
 
|-
 
|  
 
|  
−
''Husstandens økonomi - Penge til forbrug''
+
Husstandens økonomi - Penge til forbrug  
  
−
''Missing data in several periods''
+
Missing data in several periods  
  
−
''IFKA report: Page 19''
+
IFKA report: Page 19  
  
−
''Series 1: WQ527_Household_Allowance_Compared_To_Last_Year''
+
Series 1: WQ527_Household_Allowance_Compared_To_Last_Year
  
 
| <br>
 
| <br>
Line 556: Line 695:
 
|-
 
|-
 
|  
 
|  
−
''Opsparing, pension, låntagning og investering - Forbrug på kredit''
+
Opsparing, pension, låntagning og investering - Forbrug på kredit  
  
−
''Missing data for some periods, but the data is present in the IFKA reports''
+
Missing data for some periods, but the data is present in the IFKA reports  
  
−
''IFKA report: Page 24''
+
IFKA report: Page 24  
  
−
''Series 1: QQ025_Purchases_On_Credit_Last_3_Months''
+
Series 1: QQ025_Purchases_On_Credit_Last_3_Months  
  
−
''Series 2: QQ026_Purchases_On_Credit_Next_3_Months''
+
Series 2: QQ026_Purchases_On_Credit_Next_3_Months
  
 
| <br>
 
| <br>
Line 574: Line 713:
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Læsning af ugeblade og magasiner''
+
Medieforhold og Internet - Læsning af ugeblade og magasiner  
  
−
''This Diagram have severe problems for both Datalines when you compare with IFKA data.''
+
This Diagram have severe problems for both Datalines when you compare with IFKA data.  
  
−
''Series 1: QQ172_Weekly_Magazines''
+
Series 1: QQ172_Weekly_Magazines  
  
−
''Series 2: QQ215_Magazines''
+
Series 2: QQ215_Magazines
  
 
| <br>
 
| <br>
Line 590: Line 729:
 
|-
 
|-
 
|  
 
|  
−
''Husstandens økonomi - Husstandens økonomiske situation''
+
Husstandens økonomi - Husstandens økonomiske situation  
  
−
''Discrepancy between IFKA report and konjunktur on "forurening" in 89-99. IFKA data vener goes beyond -10, but ours do not''
+
Discrepancy between IFKA report and konjunktur on "forurening" in 89-99. IFKA data vener goes beyond -10, but ours do not  
  
−
''IFKA report: Page 18''
+
IFKA report: Page 18&nbsp;
  
−
2009/12/17 Luan: I set this to DONE since the diagram doesn't show data in that period. Detecting discrepancy in data is something Casper has started and that should cover the problem here.
+
| Luan (2009/12/17): I set this to DONE since the diagram doesn't show data in that period. Detecting discrepancy in data is something Casper has started and that should cover the problem here.  
−
 
 
−
| <br>
 
 
| Luan  
 
| Luan  
 
| 3&nbsp;  
 
| 3&nbsp;  
Line 606: Line 743:
 
|-
 
|-
 
|  
 
|  
−
''Opsparing, pension, låntagning og investering - Opsparing''
+
Opsparing, pension, låntagning og investering - Opsparing  
  
−
''Data for the last period must be wrong??''
+
Data for the last period must be wrong??  
  
−
''IFKA report: Page 21''
+
IFKA report: Page 21
  
−
2009/12/21 Luan: No discrepancies found
+
| Luan (2009/12/21): No discrepancies found  
−
 
 
−
| <br>
 
 
| Luan  
 
| Luan  
 
| 2  
 
| 2  
Line 622: Line 757:
 
|-
 
|-
 
|  
 
|  
−
''Boligens indretning - Gennemførelse af større til- eller ombygninger''
+
Boligens indretning - Gennemførelse af større til- eller ombygninger  
  
−
''The first word in the menu and in the headline "Gennemføring" is to be changed to "Gennemførelse". I am not sure that the newest collected data are correct!''
+
The first word in the menu and in the headline "Gennemføring" is to be changed to "Gennemførelse". I am not sure that the newest collected data are correct!  
  
−
''IFKA report: Page 33''
+
IFKA report: Page 33
  
−
2009/12/21 Luan: The expressions are correct, and the data doesn't seem unreal.
+
| Luan (2009/12/21): The expressions are correct, and the data doesn't seem unreal.  
−
 
 
−
| <br>
 
 
| Luan  
 
| Luan  
 
| 2  
 
| 2  
Line 638: Line 771:
 
|-
 
|-
 
|  
 
|  
−
''Boligens indretning - Køb af nyt køkken''
+
Boligens indretning - Køb af nyt køkken  
−
 
 
−
''I am not sure that the newest collected data are correct!''
 
  
−
''IFKA report: Page 35, Figure 21''
+
I am not sure that the newest collected data are correct!
  
−
2009/12/21 Luan: The expressions are correct, and the data looks absolutely normal.
+
IFKA report: Page 35, Figure 21
  
−
| <br>
+
| Luan (2009/12/21): The expressions are correct, and the data looks absolutely normal.
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
Line 654: Line 785:
 
|-
 
|-
 
|  
 
|  
−
''Boligens indretning - Køb af nyt badeværelse''
+
Boligens indretning - Køb af nyt badeværelse  
  
−
''I am not sure that the newest collected data are correct!''
+
I am not sure that the newest collected data are correct!  
  
−
''IFKA report: Page 35, Figure 22''
+
IFKA report: Page 35, Figure 22
  
−
2009/12/21 Luan: The expressions are correct. Besides, some changes in the past are even more dramatic (e.g. Dec.99) and 2.7 is not the lowest index in history, so the data looks fine to me.
+
| Luan (2009/12/21): The expressions are correct. Besides, some changes in the past are even more dramatic (e.g. Dec.99) and 2.7 is not the lowest index in history, so the data looks fine to me.  
−
 
 
−
| <br>
 
 
| Luan  
 
| Luan  
 
| 3  
 
| 3  
Line 670: Line 799:
 
|-
 
|-
 
|  
 
|  
−
''Medieforhold og Internet - Anskaffelse af internetadgang''
+
Medieforhold og Internet - Anskaffelse af internetadgang  
−
 
 
−
''IFKA has data for Sep 07''
 
  
−
''IFKA report: Page 46 (But the grey line in IFKA report&nbsp;is wrong)''
+
IFKA has data for Sep 07
  
−
''Series 1: D_Internet_Access''
+
IFKA report: Page 46 (But the grey line in IFKA report&nbsp;is wrong)
  
−
''Series 2: QQ462_Plan_For_Internet_At_Home''
+
Series 1: D_Internet_Access
  
−
2009/12/22 Luan: According to Anh Duc's investigation, IFKA database doesn't contain data for QQ462_Plan_For_Internet_At_Home in Sep.07.
+
Series 2: QQ462_Plan_For_Internet_At_Home
  
−
| <br>
+
| Luan (2009/12/22): According to Anh Duc's investigation, IFKA database doesn't contain data for QQ462_Plan_For_Internet_At_Home in Sep.07.
 
| Anh Duc  
 
| Anh Duc  
 
| 3  
 
| 3  
 
| 2010/12/25  
 
| 2010/12/25  
 
| 2009/12/22  
 
| 2009/12/22  
 +
| DONE
 +
|-
 +
|
 +
Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads
 +
 +
The diagram has the same shape as the one in tha IFKA report, but the level seems to be higher than IFKas level. Se eg the lowest point in the diagrams and you will find a difference of 4 points
 +
 +
IFKA report: Page 14
 +
 +
| <br>
 +
| Luan
 +
| 3
 +
| 2010/01/08
 +
| 2009/12/23
 +
| DONE
 +
|-
 +
|
 +
Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads - Virksomhedstype
 +
 +
This diagram looks good - but it is created of data from the above diagram, so perhaps the shares are slightly of
 +
 +
IFKA report: Page 15
 +
 +
| <br>
 +
| Luan
 +
| 3
 +
| 2010/01/08
 +
| 2009/12/23
 
| DONE
 
| DONE
 
|}
 
|}

Latest revision as of 11:37, 17 October 2013

<accesscontrol>Main:MyGroup</accesscontrol>

Introduction

Page for CEM Economy

Questionnaires

To do

Description Discussion Responsible Priority Deadline Date completed Status
Copy tables to clipboard 
Luan 1 2010/02/12
Start

Import data for 2009 Q4 back to Access database

We decided to use the old approach one more time for the Q4/2009 report:

  1. Data is collected in Catglobe
  2. Data is exported, cleaned and imported into the old MS Access database

Casper (2009/12/22): Is this project not finished??

Luan (2009/12/23): Mr. Duc has finished part of it, and Mr. Phong (DK) will take over responsibility.

Anh Duc, Phong (DK) 1 2009/12/25
Half

New segmentation definitions

Luan (2010/01/15): An update on the progress

Region: data for D_ZipCode looks wrong, so no conversion until Dennis & Van Anh fix it (Deadline: 2010/01/21)

Beskæftigelse: done

Husstandsindkomst: waiting for more info from Casper

Alder, Husstandsindkomst, & Boligtype: data for D_IFKA_Age_Group, D_IFKA_Household_Income, and D_Accommodation in Q4/2007, Q3/2003, & Q3/2008 are missing. Dennis & Van Anh are handling this (Deadline: 2010/01/21)

Dennis, Van Anh, Luan 1 2010/01/22
Half

Zero data problem. Where are we with a decision for zero data?

Luan (2009/12/22): This project will solve the problem: VN2798REP - Report style sheet - Setting to display or hide zero values in diagrams. The plan is to finish the project on the 4th of January 2010. So the deadline for this task must be put off to at least 3 days after that, thus 2010/01/08.

Casper (2009/12/22): The sooner this is done, the better!

Luan (2009/12/18): Due to some bugs, Report finally decided to disable the feature in today's upload. Awesome! :-|

Thomas, Luan 2 2010/01/08
Start

Update dashboard: Catinét opinion. By default no parties are shown in the tracking diagram.

The customer must select which parties to view the tracking diagram for, and then click the Update button to show the tracking diagram. 

Luan (2009/12/22): Currently, it is impossible to do this, and there're no plans for making it possible! This explains why this task is on pause indefinitely.

Casper (2009/12/22): A solution on how to present data are Caspers responsibility. But for now, the current diagram will do.

Luan, Casper 3

Paused

Period selection should be implemented.

User should be able to select start and end data as a start.
Later on selections on point size will be an obivious addition.

Thắng is working on a modification for time set which might already be uploaded.

The new time set type is already available on version 5.7, next step is to create a project for version 5.9 which will make it possible to use time sets with tracking diagrams.

Casper (2009/12/22): As I read your coment, this is already possible but not in newer versions?

Luan (2009/12/23): The project is planned for 6.0 and I don't know exactly when it will come out yet, so the current deadline 2010/02/26 might change.

Luan 4 2010/02/26
Start

Stylesheet for diagrams.

Review diagram style sheet, diagrams must be less Excel like.

More details needed about what is good and what is bad?

Luan (2009/12/22): This task is on pause until I get clear instructions on how to make the diagrams look more fancy.

Casper (2009/12/22): Casper is working on it. Hopefully a design is ready before Christmas.

Luan (2010/01/06): I already received the design from Casper but I haven't come round to it yet.

Luan 5 2010/01/29
Half

Same Y-axis for weekly/monthly and quarterly data 

Luan (2009/12/22): One style sheet for one diagram is a bad idea, imagine changing the chart background color, for example, would take a day! In order to finish this task, Casper needs to group similar diagrams together as much as possible based on the fact that they can have the same y-axis scale. Until I have this information, this task is on pause.

Casper (2009/12/22): Since we are to update the design among other things, this is a reasonable pausing :-)

Luan 5 2010/01/22
Paused

Cross tabulation - Adjust width of axis selection boxes to show full text

Casper (2009/12/22): Is it the year or the data in the deadline that is wrong?

Luan (2009/12/23): Both were wrong :-p

Luan 5 2010/02/26
Start

Gridlines on the front dashboard and in the monitor. Could you please remove all vertical gridlines (just put a small dot to mark the axis label placement) and make all the vertical lines dotted like this (- - - - -). The color is to stay the same, but perhaps the line could be even thinner. The gridlines are meant as a help to the eye, not as something that should stand out in the diagram. Before you change all diagrams, please change 1 and write me which one I shall take a look at

Casper (2009/12/22): Please update the front dashboard ASAP. The monitor can wait a bit since we are to come up with a neww design.

Luan (2009/12/23):

"remove all vertical gridlines" - Done!

"just put a small dot to mark the axis label placement" - We can't control these elements yet through style sheet settings.

"make all the vertical lines dotted like this" - I presume you mean horizontal gridlines, right?

"the line could be even thinner" - That is already the thinnest size, 1px.

Luan 5 2010/02/26
Start

Would it be possible to do a mouse over for the diagrams, so that if you hold the mouse over e.g. the point on the line above december 2009 it will be possible to see the exact value for that period?

Luan (2009/12/22): Interactive diagrams are something we've always wanted. Though it is not something we can do now, this task is to remind us about this cool feature that hopefully we will be able to implement in the future.

Casper (2009/12/22): A nice answer covering a firm NO. But please note that I would like to see it in a project so that it will be possible one day (soon :-))

Luan 5

Paused

Document how to manually update static diagrams weekly, monthly, quarterly

Casper (2009/12/22): Good idea Luan 5 2010/02/26
Start

Automate the process of updating diagram A6 on the front dashboard


Luan, Khanh 5 2010/02/26
Half

A special data file for Casper to compare IFKA data with Catglobe data


Luan 1 2009/12/11 2009/12/11 DONE

Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data.


Luan 3 2009/12/25 2009/12/16 DONE

Cross tabulation for CEM Economy


Luan 1 2009/12/18 2009/12/18 DONE

Replace the table at location A3 on the front dashboard with a bar chart

Casper (2009/12/22): Under the headline we are to write the following:

År 2000 = Indeks 100

And could you make the bars a bit wider. No need for the spacing to be that wide

Luan (2009/12/23): Done!

Luan 1 2009/12/23 2009/12/23 DONE

On the front dashboard, please mark the 0-line bold on the two diagrams where it is relevant.

Casper (2009/12/22): Please make it a higher priority. The task is simple but will help the viewers quite a bit.

Luan (2009/12/23): Done :-)

Luan 1  2009/12/23 2009/12/23 DONE

Segmentation must be multiple.

It must be possible to select multiple age groups and regions.

We need a status from Report on a development project.

The feature is implemented in version 5.8, making a merge back now would probably be a bad idea.

Luan (2009/12/22): The plan is to have 5.8 on mycatinet on the 28th December 2009 the latest.

Casper (2009/12/22): Does it take 17 days to get this working?

Luan (2009/12/23): No. But we have other tasks with higher priority.

Luan (2009/12/31): Finally, I had to do this first since nothing worked after this feature had been deployed.

Luan 5 2010/01/15 2009/12/30 DONE

Update data cache to use Thomas's new period variables like D_Year, D_Month, D_IFKA_YearQuarter...

Luan (2009/12/24): This task is quite important since it has to be finished before the automated update process can start. Luan 3 2009/12/31 2010/01/05 DONE

Update diagram A6 on the front dashboard with newest data


Luan 1 2010/01/05 2010/01/05 DONE

All data are now being collected monthly or weekly. That means that all diagrams will have a working monthly button, but not all will have a working weekly button. This has the following implications:

A. All diagrams with weekly data are to have a working buttons for both monthly and weekly diagrams

B. All diagrams with monthly data collected since week 40 are to have a working monthly data button and a weekly button that is grayed out with a mouse over with this content “Data er ikke tilgængelig på ugeniveau”.

C. Diagrams that are built on data until now collected quarterly are to, until February 1, to have both weekly and monthly buttons greyed out. The weekly button is to have the same content as above, but the monthly data mouse over is to say “Data er tilgængelig fra 1. februar 2010”.

Casper (2009/12/22): As mentioned earlier, we are to stopping the data collection for weekly data. This is to become monthly.This has the implication that all weekly diagrams are to be removed as well as the buttons with acces to weekly data.

All diagrams are to be updated monthly from now on which means that this is the task:

A. All diagrams, currently with weekly data, are to have a working buttons for monthly diagrams

B. All diagrams with monthly data collected since week 40 are to have a working monthly data button.

C. Diagrams that are built on data until now collected quarterly are to, until February 1, to have a monthly button that is greyed out until february 1. The mouse over is to say “Data er tilgængelig fra 1. februar 2010”.

All weekly diagrams, and the the access buttons are to be removed from CEM Economy.

Luan (2010/01/05): Although this is a low priority task, I did it as I were fixing the multiple segmentation thing so as to save time.

Luan 5 2010/02/26 2010/01/05 DONE

A segmentation data file for Casper


Dennis 1 2010/01/22 2010/01/10 DONE

Moving periods.

Casper send us a document with updates related to periods for all diagrams, some diagrams are predicting what will happen the following 3 months based on respondents answers.

Project needed in order to solve the skewed periods, this is also the reason we do not use time sets. 

Luan (2009/12/22): A proper project might come later. For now, we will manually convert all the cross diagrams that show predictions about different periods in the same graph to static diagrams. I have received a list of these diagrams, but I won't finish this task before the 31st of December 2009 since some tasks with higher priority just came along.

Casper (2009/12/22): Important information:
As will be describer further down, the collecting of weekly data are to be stopped. In stead all data will be collected monthly. That means that we only will have monthly/quartely diagrams.
The monthly diagrams are, like the quartely, to have the expectation line moved only one period (1 month) forward.

Luan (2010/01/06): Here are the diagrams that need converting. Strikethrough means done.

Husstandens økonomi
Husstandens økonomiske situation (2010/01/06)

Forbrug
Køb af hårde hvidevarer (2010/01/06)
Køb af radio/tv/video/dvd (2010/01/06)
Køb af møbler (2010/01/06)
Køb af gulvtæpper (2010/01/07)
Køb af el-værktøj/haveredskaber (2010/01/07)
Køb af PC’er (2010/01/07)
Køb af mobiltelefon (2010/01/07)
Køb af fotoudstyr (2010/01/07)
Køb af bøger (2010/01/07)
Køb af musik / film på cd/dvd (2010/01/07)

Opsparing, pension, låntagning og investering
Opsparing (2010/01/07)
Lån af penge til forbrug (2010/01/07)
Investering i aktie (2010/01/07)
Investering i obligationer (2010/01/07)
Investering i anparter (2010/01/07)
Pensionsopsparing (2010/01/07)
Køb på kredit (2010/01/08)

Personbiler
Køb af ny bil (2010/01/08)
Køb af brugt bil (2010/01/08)

Flytning, bolig og realkredit
Køb og salg af huse (2010/01/08)
Køb og salg af ejerlejligheder (2010/01/08)
Køb og salg af andelslejligheder (2010/01/08)
Køb og salg af sommerhuse (2010/01/08)
Nybyggeri (2010/01/08)
Salgsplaner (2010/01/12)
Flytteplaner (2010/01/12)
Kreditforeningslån (2010/01/12)
Afdragsfrit kreditforeningslån (2010/01/12)

Boligens indretning
Gennemføring af større til- eller ombygninger (2010/01/12)
Køb af nyt køkken (2010/01/12)
Køb af nyt badeværelse (2010/01/12)

Medieforhold og Internet
Anskaffelse af Internetadgang (2010/01/12)

Arbejdsmarkedet
Faktisk og forventet ledighed i egen husstand (2010/01/12)

Luan 3 2010/01/29 2010/01/12 DONE

Link to Catglobe Economy PDF user guide: Left menu> Brugermanual> Klik her for at downloade


Luan 5 2010/02/26 2010/01/18 DONE

Name quarters after seasons

Q1 -> Vinter

Q2 -> Forår

Q3 -> Sommer

Q4 -> Efterår


Cam Tu, Tu Anh, Luan 1 2010/01/28 2010/01/28 DONE
Data tables
Cam Tu, Tu Anh, Luan 1 2010/02/05 2010/02/22 DONE
Statistical tables
Luan 1 2010/02/12 2010/03/10 DONE

Diagram correction status

Description Discussion  Responsible Priority Deadline Date completed Status

Forbrug - Ferie

There are only one period of data for "Ferie i Danmark", so please delete the yellow line up the point where we have data

IFKA report: Page 50

Luan (2009/12/21): 0-data problem Luan 3 2010/01/08
Start

Medieforhold og Internet - Seere til nyhedsudsendelser

There are shown 0-data for some years in the beginning.

IFKA report: Page 61 (DR1 and TV2)


Luan 3 2010/01/08
Start

Medieforhold og Internet - Reklameindslag på radiostationer

There are shown 0-data for some years in the beginning. But no data to compare with


Luan 3 2010/01/08
Start

Medieforhold og Internet - Daglig læsning af gratisaviser

Remowe 0-data from "24-timer" and let the diagram start when there are data. Data does not match IFKA data


Anh Duc, Luan 1 2009/12/04
Start

Medieforhold og Internet - Internetanvendelse

Remove 0-data from the lines where no data exists - and IFKA has data older than 2003

Luan (2009/12/23): According to Anh Duc, the IFKA database doesn't contain data for WQ656_Internet_Usage_Within_This_Week before 2003. So hiding the empty area will solve the problem? Luan 3 2010/01/08
Start

Politik og bekymring - Bekymring for fødevarernes kvalitet

REMOVE THE DIAGRAM


Luan 2  2009/12/03 2009/12/03 DONE

Personbiler - Antal biler i husstanden

REMOVE THE DIAGRAM


Luan 2 2009/12/03 2009/12/03 DONE

Flytning, bolig og realkredit - Kreditforeningslån

Question tekst is wrong. Again there are shown 0-data for some years in the beginning. 

Luan (2009/12/03): Question text was fixed. I didn't see 0-data here. Probably, the problematic periods are hidden. Luan 3 2009/12/03 2009/12/03 DONE

Medieforhold og Internet - Læser avis

Something wrong with the blue line. It shoots to 100%. Othervise, it looks good

IFKA report: Page 63 ("Hverdagsavis" and "Søndagsavis")


Mai 1 2009/12/03 2009/12/03 DONE

Medieforhold og Internet - Læsning af tilbudsaviserne

Remove legend


Luan 3 2009/12/03 2009/12/03 DONE

Politik og bekymring - Bekymring for udviklingen i den globale økonomi

Diagram are to start when data collection starts in 08/09


Luan 3 2009/12/04 2009/12/04 DONE

Forbrug - Køb af musik/film på cd/dvd

No data before september 2000 - Remove 0-data and let trhe diagram start in sep 2000

IFKA report: Page 49 

Luan (2009/12/04): 0-data problem, but hiding the unnecessary periods can do the trick Luan 3 2009/12/04 2009/12/04 DONE

Opsparing, pension, låntagning og investering - Investering i aktier

The diagram are not to start before data collection begins which is for september 2009


Luan 3 2009/12/04 2009/12/04 DONE

Opsparing, pension, låntagning og investering - Investering i obligationer

The diagram are not to start before data collection begins which is for september 2009


Luan 3 2009/12/04 2009/12/04 DONE

Opsparing, pension, låntagning og investering - Investering i anparter

The diagram are not to start before data collection begins which is for september 2009


Luan 3 2009/12/04 2009/12/04 DONE

Flytning, bolig og realkredit - Afdragsfrie kreditforeningslån

Question tekst is wrong. Only show diagram from the time data collection began in December 2003


Luan 3  2009/12/04 2009/12/04 DONE

Politik og bekymring - Tillid til regering/opposition

Missing data that are not missing in IFKA report

IFKA report: Page 7

Series 1: WQ060_Government_Confidence

Series 2: WQ140_Opposition_Confidence


Anh Duc 3  2009/12/11 2009/12/14 DONE

Husstandens økonomi - Penge til forbrug

Missing data in several periods

IFKA report: Page 19

Series 1: WQ527_Household_Allowance_Compared_To_Last_Year


Anh Duc 3 2009/12/11 2009/12/14 DONE

Opsparing, pension, låntagning og investering - Forbrug på kredit

Missing data for some periods, but the data is present in the IFKA reports

IFKA report: Page 24

Series 1: QQ025_Purchases_On_Credit_Last_3_Months

Series 2: QQ026_Purchases_On_Credit_Next_3_Months


Anh Duc 2 2009/12/11 2009/12/14 DONE

Medieforhold og Internet - Læsning af ugeblade og magasiner

This Diagram have severe problems for both Datalines when you compare with IFKA data.

Series 1: QQ172_Weekly_Magazines

Series 2: QQ215_Magazines


Anh Duc, Luan 1 2009/12/04 2009/12/14 DONE

Husstandens økonomi - Husstandens økonomiske situation

Discrepancy between IFKA report and konjunktur on "forurening" in 89-99. IFKA data vener goes beyond -10, but ours do not

IFKA report: Page 18 

Luan (2009/12/17): I set this to DONE since the diagram doesn't show data in that period. Detecting discrepancy in data is something Casper has started and that should cover the problem here. Luan 3  2010/01/08 2009/12/17 DONE

Opsparing, pension, låntagning og investering - Opsparing

Data for the last period must be wrong??

IFKA report: Page 21

Luan (2009/12/21): No discrepancies found Luan 2 2010/01/08 2009/12/21 DONE

Boligens indretning - Gennemførelse af større til- eller ombygninger

The first word in the menu and in the headline "Gennemføring" is to be changed to "Gennemførelse". I am not sure that the newest collected data are correct!

IFKA report: Page 33

Luan (2009/12/21): The expressions are correct, and the data doesn't seem unreal. Luan 2 2010/01/08 2009/12/21 DONE

Boligens indretning - Køb af nyt køkken

I am not sure that the newest collected data are correct!

IFKA report: Page 35, Figure 21

Luan (2009/12/21): The expressions are correct, and the data looks absolutely normal. Luan 3 2010/01/08 2009/12/21 DONE

Boligens indretning - Køb af nyt badeværelse

I am not sure that the newest collected data are correct!

IFKA report: Page 35, Figure 22

Luan (2009/12/21): The expressions are correct. Besides, some changes in the past are even more dramatic (e.g. Dec.99) and 2.7 is not the lowest index in history, so the data looks fine to me. Luan 3 2010/01/08 2009/12/21 DONE

Medieforhold og Internet - Anskaffelse af internetadgang

IFKA has data for Sep 07

IFKA report: Page 46 (But the grey line in IFKA report is wrong)

Series 1: D_Internet_Access

Series 2: QQ462_Plan_For_Internet_At_Home

Luan (2009/12/22): According to Anh Duc's investigation, IFKA database doesn't contain data for QQ462_Plan_For_Internet_At_Home in Sep.07. Anh Duc 3 2010/12/25 2009/12/22 DONE

Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads

The diagram has the same shape as the one in tha IFKA report, but the level seems to be higher than IFKas level. Se eg the lowest point in the diagrams and you will find a difference of 4 points

IFKA report: Page 14


Luan 3 2010/01/08 2009/12/23 DONE

Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads - Virksomhedstype

This diagram looks good - but it is created of data from the above diagram, so perhaps the shares are slightly of

IFKA report: Page 15


Luan 3 2010/01/08 2009/12/23 DONE
Retrieved from "http://wiki.catglobe.com/index.php?title=CEM_Economy_Intelligence&oldid=24690"