ID de la réponse token Date de soumission Dernière page Langue de départ Tête de série Date de lancement Date de la dernière action State General comments Proposal date : PO OECD date : OECD PO order number Project numbers in SondagesPro Project numbers in SondagesPro Project numbers in SondagesPro Sondages Pro premilinary notes Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of proposal Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Detail of price Total price : {sum(that.PriceDetail.NAOK)} Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Contact at OECD for Proposal and Bill Sondages Pro notes Files annex filecount - Files annex id token submitdate lastpage startlanguage seed startdate datestamp State Comments PRDate POOECDDate POOECD SondagesProId_PR SondagesProId_CO SondagesProId_FA PreliminaryNote DetailComment_L01 DetailComment_L02 DetailComment_L03 DetailComment_L04 DetailComment_L05 DetailComment_L06 DetailComment_L07 DetailComment_L08 DetailComment_L09 DetailComment_L10 DetailComment_L11 DetailComment_L12 DetailComment_L13 DetailComment_L14 DetailComment_L15 DetailComment_L16 PriceDetail_L01 PriceDetail_L02 PriceDetail_L03 PriceDetail_L04 PriceDetail_L05 PriceDetail_L06 PriceDetail_L07 PriceDetail_L08 PriceDetail_L09 PriceDetail_L10 PriceDetail_L11 PriceDetail_L12 PriceDetail_L13 PriceDetail_L14 PriceDetail_L15 PriceDetail_L16 PriceTotal OECDcontact_Proposal_Name OECDcontact_Proposal_email OECDcontact_Bill_Name OECDcontact_Bill_email OECDcontact_Other01_Name OECDcontact_Other01_email OECDcontact_Other02_Name OECDcontact_Other02_email OECDcontact_Other03_Name OECDcontact_Other03_email OECDcontact_Other04_Name OECDcontact_Other04_email OECDcontact_Other05_Name OECDcontact_Other05_email OECDcontact_Other06_Name OECDcontact_Other06_email OECDcontact_Other07_Name OECDcontact_Other07_email Notes Annex Annex_filecount 41 5c4rB8WplObsas4 2019-11-06 09:39:06 1 en 2062948481 2019-10-31 07:24:12 2019-11-12 15:59:56 Propo 2019-10-31 00:00:00 {question_not_shown} **Context**{cr}{newline}{cr}{newline}OECD want to use LimeSurvey for MAP system. MAP (Mutual Agreement Procedure) is a procedure under which two countries seek to resolve taxation that was potentially levied not in accordance with the tax treaty that they entered into.{cr}{newline}{cr}{newline}Each country must enter number of MAP with other country, number of closed MAP and new MAP during the year. Then informatin between 2 countries must be same for 2 questionnaire.{cr}{newline}{cr}{newline}To move to LimeSurvey, there are some feature needed :{cr}{newline}{cr}{newline}1. **Real time matching** (priority #1): For each pair of jurisdictions, specific data needs to match:{cr}{newline} 1. Participant (country) are allowed to submit not matched data, but need an information about unmatched data.{cr}{newline} 2. OECD team must have a tool to find the unmatched data and be allwoed to review it.{cr}{newline}2. **Computation features** (priority #2): Some data can be evaluate by other data and is used in the final work. This computation can be done directly inside one questionnaire.{cr}{newline}3. **Export features** (priority #3):{cr}{newline} 1. The data relating to treaty partners that do not belong to the list of reporting jurisdictions need to be aggregated under the “others” row{cr}{newline} 2. The data relating to treaty partners belonging to the list of reporting jurisdiction but with which a country has fewer than 5 cases need to be aggregated under the “de minimis” row{cr}{newline}4. **Multi-year tool** (priority #4) :{cr}{newline} 1. The questionnaire can be pre-filled by data from previous year{cr}{newline} 2. A country can have access to previous year data and information{cr}{newline} 3. A questionnaire must be open to add more information.{cr}{newline}{cr}{newline}Denis Chenu already produce different plugins used by OECD : responseListAndManage and questionExtraSurvey. Current proposition used this 2 plugins and add other plugins to offer a complete system.{cr}{newline}{cr}{newline}A quick sample of responseListAndManage is shown at [survey.oecd.org](https://survey.oecd.org/index.php?r=plugins/direct&plugin=responseListAndManage&sid=681199&&token=TEST). {cr}{newline}{cr}{newline}**About access restriction** : a token code is necessary to access to this system and open or edit MAP. This token code is used to identify an user from a country or organisation, a country or organisation can have multiple user each identified by their own token. The data is saved on OECD server, administration access can be done only by OECD user, and specific data is restricted to some OECD user. Plugin creation : one MAP by country (_priority #1_) (**dev1**){cr}{newline}{cr}{newline}- In survey with participant identified by tokens : allow to remove choice already done {cr}{newline}- Compatibility with organisation for reponseListAndmanage : replace by token.{cr}{newline}{cr}{newline}_Usage for related country in MAP questionnaires_{cr}{newline}{cr}{newline}3 development days at 600€ Plugin improvement : add global comparison by country (_priority #1_) (**dev2**){cr}{newline}{cr}{newline}- Survey settings to choose questions for related questionnaire{cr}{newline}- If survey as such settings : question attribute to add question to comparison{cr}{newline}- Allow to show the related value inside survey on a extra element.{cr}{newline}- Allow to have a question with the number of difference with related country{cr}{newline}{cr}{newline}5 development days at 600€{cr}{newline}{cr}{newline}_Need the previous part of the plugin (dev2a)_ Survey's creation (_priority #1 and #2_) (**survey1**){cr}{newline}{cr}{newline}- Creation of single MAP survey according to documents{cr}{newline}- Multipage questionnaire or single page{cr}{newline}- Add Computation features (by related country){cr}{newline}- - End of inventory, total number of cases, weighted average time ...{cr}{newline}- - mutual-agreement-procedure-statistics-reporting-framework.pdf{cr}{newline}- - Data to be matched list{cr}{newline}- Adaptation of survey after testing and validation{cr}{newline}- Adding one MAP by country system from previous plugins{cr}{newline}- - minimis and other can be choosen one time only{cr}{newline}- - each country can be choosen one time only{cr}{newline}- Adding relation system from previous plugin{cr}{newline}- Allow to prefill start value by know data{cr}{newline}- Survey adaptation after testing{cr}{newline}{cr}{newline}Flat rate Prefilling and history plugin (_priority #4_) (**dev3**){cr}{newline}{cr}{newline}- Add a year question in survey{cr}{newline}- Restrict to current year on one Map by country plugin{cr}{newline}- Restrict to current year on comparison by country{cr}{newline}{cr}{newline}3 development days{cr}{newline}{cr}{newline}_Need the restriction plugin (dev2a and dev2b)_ History preview of survey (_priority #4_) (**dev4**){cr}{newline}{cr}{newline}- Allow to set previous questionnaire as archived (questionnaire done before a date){cr}{newline}- No way to update this questionnaire (using default LimeSurvey public system){cr}{newline}- Disable save action on movenext and move previous{cr}{newline}- Add automatically the full index on archived questionnaire{cr}{newline}- Allow to create a question for previous questionnaires listing :{cr}{newline}- - open survey in a new tab{cr}{newline}- - export survey in an existing export system{cr}{newline}{cr}{newline}3 development days{cr}{newline}{cr}{newline}_Need the previous development (dev3)_ Plugin development : Filtered export (_priority #3_) (**dev5**){cr}{newline}{cr}{newline}- Extend excel or CSV export by global option{cr}{newline}- Survey setting : auto filtered export by value a value question (single choice, or equation){cr}{newline}- When export : only export some lines according to selection (for MAP : don't export minimis and other) {cr}{newline}{cr}{newline}2 development days Plugin improvement : Compiled export (_priority #3_) (**dev6**){cr}{newline}{cr}{newline}- On survey with filtered export, add question settings :{cr}{newline}- - compilation method : none, count, sum or average{cr}{newline}- When export : compile filtered data according to each question settings{cr}{newline}- Compilation by type (for MAP : minimis and other) {cr}{newline}{cr}{newline}5 development days Plugin improvement : weighted average (_priority #3_) (**dev7**){cr}{newline}{cr}{newline}- Survey settings : allow to choose a numeric or equation question for weighting value{cr}{newline}- Question setting : add weighted average in compilation method{cr}{newline}- When export : weighted selected question by weighted data {cr}{newline}{cr}{newline}4 development days {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} 1800 3000 1600 1800 1800 1200 3000 2400 {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} {question_not_shown} 16600 Félicie BONNET Felicie.BONNET@oecd.org Samuel PINTORIBEIRO Samuel.PINTORIBEIRO@oecd.org Sandra KNAEPEN Sandra.KNAEPEN@oecd.org **Specific development delay** : {cr}{newline}{cr}{newline}- Public survey part : _dev1_, _dev2_ and _survey1_ delay is one month after reception of data, and can start on December to have a tested and validated system during January{cr}{newline}- Export filter system : _dev5_, _dev6_ and _dev7_ delay can start in January, have a complete and checked system can take 2 month{cr}{newline}- Multi year system : _dev3_ and _dev4_ delay can start in January, have a complete and checked system can take 1 month{cr}{newline}{cr}{newline}The warranty on developments is one (1) month after delivery and acceptance. The warranty does not include updates to the software, housing conditions and possible failures related to this accommodation. The compatibility of plugins with updates of the official version LimeSurvey software is guaranteed twelve (12) months.{cr}{newline}{cr}{newline}Development are Copyright Denis Chenu / OECD and distributed under the GPLv3 license. This license does not apply to survey contents, graphics, visual identity, graphic charter or calculation methods that remain the full property of the client.{cr}{newline}{cr}{newline}Code under open source license can be published by Denis Chenu on the various repo management websites,on his own websites and on any other website. In this case, unless otherwise specified, the client's name will be mentioned in the copyright. "[{lbrace} ""title"":""R4IO new offer"",""comment"":"""",""size"":""28.7919921875"",""name"":""PR1910-0570.pdf"",""filename"":""fu_ua3j3fdq9t3swwv"",""ext"":""pdf"" }]" 1