{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["questionnaire","work","results"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"questionnaire","index":0,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[8,4,8,5],[0,0,0,8],[2,3,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[29,0,30,0],[32,0,33,0],[17,1,18,7],[20,1,21,7],[23,1,24,7],[26,1,27,7],[29,1,30,7],[32,1,33,7],[28,1,28,7],[31,1,31,7],[20,0,21,0],[25,1,25,7],[14,0,15,0],[11,0,12,0],[17,0,18,0],[23,0,24,0],[26,0,27,0],[10,1,10,7],[13,1,13,7],[16,1,16,7],[19,1,19,7],[22,1,22,7],[11,1,12,7],[14,1,15,7]]}
["Please give your opinion about the following affirmations in the context of your case study."]
[]
[null,null,null,"Use the scale  from 1 to 6 :"]
[null,null,null,"\"1\"","totally agree"]
[null,null,null,"\"2\"","tend to agree"]
[null,null,null,"\"3\"","sharred view"]
[null,null,null,"\"4\"","disagree"]
[null,null,null,"\"5\"","do not agree at all"]
[null,null,null,"\"6\"","do not know"]
[null,null,null,null,null,null,null,null,"your answer ↓"]
["Item 1","In the next years, the distribution of the dolphin will move"]
["Why?"]
[]
["Item 2","It is difficult to find new kelp harvesters."]
["Why?"]
[]
["Item 3","The water quality improves."]
["Why?"]
[]
["Item 4","The marine biodiversity is decreasing."]
["Why?"]
[]
["Item 5","The pressures on maerl beds increase due to extraction activities."]
["Why?"]
[]
["Item 6","New species appear in the perimeter of the park."]
["Why?"]
[]
["Item 7","Storms are more frequent in the area."]
["Why?"]
[]
["Item 8","The project of marine renewable energy in the park is relevant. "]
["Why?"]

{"sheet":"work","index":1,"n_rows":64,"n_cols":86,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,8,0,20],[27,44,29,63],[27,66,29,85],[54,1,54,3],[0,0,0,7],[1,8,1,20],[55,8,55,9],[7,23,7,42],[7,44,7,63],[8,44,8,63],[7,65,7,85],[8,66,8,85],[27,23,27,42]]}
["Working document - VALMER Project\n(please refer to the Valmer scenario guideline for methodology)\nhttp://www.valmer.eu/wp-content/uploads/2014/01/scenario_technical_guidelines_WP31.pdf",null,null,null,null,null,null,null,"This working file is designed for a maximum of 19 participants and 8 items."]
["July 2013",null,null,null,null,null,null,null,"ACCEPT MACROS !"]
["designed by Manuelle Philippe <manuelle.philippe@univ-brest.fr>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Don't add or supress any column or line!"]
[]
[]
["Fill in only the  cells of the first table (cells have been filled in for the example)"]
["The other cells are calculated automatically "]
["Number of participants :",{"$f":"COUNTIF(B28:U28,\">0\")","v":14},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OVERALL PICTURE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PARTICIPANTS DIAGONAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HYPOTHESIS DIAGONAL"]
["Answers to the questionnaire :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accept Macro, then CTRL + W to refresh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accept Macro, then CTRL + N to refresh"]
["participants:","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T",null,null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T",null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"]
["Item 1",2,5,5,5,5,5,5,5,5,3,2,6,4,4,null,null,null,null,null,null,null,"Item 1",{"$f":"B11","v":2},{"$f":"C11","v":5},5,5,5,5,5,5,5,3,{"$f":"L11","v":2},6,4,{"$f":"O11","v":4},{"$f":"P11","v":0},{"$f":"Q11","v":0},{"$f":"R11","v":0},{"$f":"S11","v":0},{"$f":"T11","v":0},{"$f":"U11","v":0},"Item 1",1,1,1,1,1,1,1,1,1,3,2,6,4,1,0,0,0,0,0,0,null,"Item 1",0,0,0,0,0,0,2,2,3,4,4,5,5,5,5,5,5,5,5,6]
["Item 2",2,1,1,1,1,1,1,1,1,3,2,6,4,2,null,null,null,null,null,null,null,"Item 2",2,1,1,1,1,1,1,1,1,3,2,6,4,2,0,0,0,0,0,0,"Item 2",2,3,3,3,3,3,1,1,1,3,2,6,4,1,0,0,0,0,0,0,null,"Item 2",0,0,0,0,0,0,1,1,1,1,1,1,1,1,2,2,2,3,4,6]
["Item 3",3,5,4,5,5,5,1,1,1,3,2,6,4,1,null,null,null,null,null,null,null,"Item 3",3,5,4,5,5,5,1,1,1,3,2,6,4,1,0,0,0,0,0,0,"Item 3",2,5,4,5,5,5,1,1,1,3,2,6,4,2,0,0,0,0,0,0,null,"Item 3",0,0,0,0,0,0,1,1,1,1,2,3,3,4,4,5,5,5,5,6]
["Item 4",4,5,4,5,5,5,1,1,1,3,2,6,4,5,null,null,null,null,null,null,null,"Item 4",4,5,4,5,5,5,1,1,1,3,2,6,4,5,0,0,0,0,0,0,"Item 4",3,5,4,5,5,5,1,1,1,3,2,6,4,2,0,0,0,0,0,0,null,"Item 4",0,0,0,0,0,0,1,1,1,2,3,4,4,4,5,5,5,5,5,6]
["Item 5",3,3,3,3,3,3,3,3,3,3,3,6,4,2,null,null,null,null,null,null,null,"Item 5",3,3,3,3,3,3,3,3,3,3,3,6,4,2,0,0,0,0,0,0,"Item 5",3,5,4,5,5,5,1,1,1,3,2,6,4,4,0,0,0,0,0,0,null,"Item 5",0,0,0,0,0,0,2,3,3,3,3,3,3,3,3,3,3,3,4,6]
["Item 6",6,5,4,5,5,5,1,1,1,3,2,6,4,4,null,null,null,null,null,null,null,"Item 6",6,5,4,5,5,5,1,1,1,3,2,6,4,4,0,0,0,0,0,0,"Item 6",4,5,4,5,5,5,3,3,3,3,2,6,4,4,0,0,0,0,0,0,null,"Item 6",0,0,0,0,0,0,1,1,1,2,3,4,4,4,5,5,5,5,6,6]
["Item 7",1,5,4,5,5,5,1,1,1,3,2,6,4,1,null,null,null,null,null,null,null,"Item 7",1,5,4,5,5,5,1,1,1,3,2,6,4,1,0,0,0,0,0,0,"Item 7",6,5,5,5,5,5,5,5,5,3,3,6,4,5,0,0,0,0,0,0,null,"Item 7",0,0,0,0,0,0,1,1,1,1,1,2,3,4,4,5,5,5,5,6]
["Item 8",6,6,6,6,6,6,6,6,6,6,6,6,6,6,null,null,null,null,null,null,null,"Item 8",6,6,6,6,6,6,6,6,6,6,6,6,6,6,0,0,0,0,0,0,"Item 8",6,6,6,6,6,6,6,6,6,6,6,6,6,6,0,0,0,0,0,0,null,"Item 8",0,0,0,0,0,0,6,6,6,6,6,6,6,6,6,6,6,6,6,6]
["participants:","A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T"]
["Item 1",{"$f":"IF(B11=1,\"totally agree\",(IF(B11=2,\"tend to agree\",(IF(B11=3,\"sharred view\",(IF(B11=4,\"disagree\",(IF(B11=5,\"do not agree at all\",\"do not know\")))))))))","v":"tend to agree"},{"$f":"IF(C11=1,\"totally agree\",(IF(C11=2,\"tend to agree\",(IF(C11=3,\"sharred view\",(IF(C11=4,\"disagree\",(IF(C11=5,\"do not agree at all\",\"do not know\")))))))))","v":"do not agree at all"},"do not agree at all","do not agree at all","do not agree at all","do not agree at all","do not agree at all","do not agree at all","do not agree at all","sharred view","tend to agree","do not know","disagree","disagree","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 2",{"$f":"IF(B12=1,\"totally agree\",(IF(B12=2,\"tend to agree\",(IF(B12=3,\"sharred view\",(IF(B12=4,\"disagree\",(IF(B12=5,\"do not agree at all\",\"do not know\")))))))))","v":"tend to agree"},{"$f":"IF(C12=1,\"totally agree\",(IF(C12=2,\"tend to agree\",(IF(C12=3,\"sharred view\",(IF(C12=4,\"disagree\",(IF(C12=5,\"do not agree at all\",\"do not know\")))))))))","v":"totally agree"},"totally agree","totally agree","totally agree","totally agree","totally agree","totally agree","totally agree","sharred view","tend to agree","do not know","disagree","tend to agree","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 3",{"$f":"IF(B13=1,\"totally agree\",(IF(B13=2,\"tend to agree\",(IF(B13=3,\"sharred view\",(IF(B13=4,\"disagree\",(IF(B13=5,\"do not agree at all\",\"do not know\")))))))))","v":"sharred view"},"do not agree at all","disagree","do not agree at all","do not agree at all","do not agree at all","totally agree","totally agree","totally agree","sharred view","tend to agree","do not know","disagree","totally agree","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 4",{"$f":"IF(B14=1,\"totally agree\",(IF(B14=2,\"tend to agree\",(IF(B14=3,\"sharred view\",(IF(B14=4,\"disagree\",(IF(B14=5,\"do not agree at all\",\"do not know\")))))))))","v":"disagree"},"do not agree at all","disagree","do not agree at all","do not agree at all","do not agree at all","totally agree","totally agree","totally agree","sharred view","tend to agree","do not know","disagree","do not agree at all","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 5",{"$f":"IF(B15=1,\"totally agree\",(IF(B15=2,\"tend to agree\",(IF(B15=3,\"sharred view\",(IF(B15=4,\"disagree\",(IF(B15=5,\"do not agree at all\",\"do not know\")))))))))","v":"sharred view"},"sharred view","sharred view","sharred view","sharred view","sharred view","sharred view","sharred view","sharred view","sharred view","sharred view","do not know","disagree","tend to agree","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 6","do not know","do not agree at all","disagree","do not agree at all","do not agree at all","do not agree at all","totally agree","totally agree","totally agree","sharred view","tend to agree","do not know","disagree","disagree","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 7","totally agree","do not agree at all","disagree","do not agree at all","do not agree at all","do not agree at all","totally agree","totally agree","totally agree","sharred view","tend to agree","do not know","disagree","totally agree","do not know","do not know","do not know","do not know","do not know","do not know"]
["Item 8","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know","do not know"]
[null,{"$f":"SUM(B11:B27)","v":27},{"$f":"SUM(C11:C27)","v":35},31,35,35,35,19,19,19,27,21,48,34,25,0,0,0,0,0,0,null,null,"All the answers of the participants to each proposal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answers of the participants sorted by number of answers from \"totally agree\" (green)\" to \"do not agree\"(red) + don't know (grey). [not sorted by items]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answers for each item  sorted by number of answers from \"totally agree\" (green)\" to \"do not agree\"(red) + don't know (grey). [not sorted by participants]"]
[null,"\"1\"","\"2\"","\"3\"","\"4\"","\"5\"","\"6\""]
["How many times is it cited?","totally agree","tend to agree","sharred view","disagree","do not agree at all","do not know"]
["nombre d'occurrence:",1,2,3,4,5,6]
["Item 1",{"$f":"COUNTIF($B11:$U11,1)","v":0},{"$f":"COUNTIF($B11:$U11,2)","v":2},{"$f":"COUNTIF($B11:$U11,3)","v":1},{"$f":"COUNTIF($B11:$U11,4)","v":2},{"$f":"COUNTIF($B11:$U11,5)","v":8},{"$f":"COUNTIF($B11:$U11,6)","v":1}]
["Item 2",8,3,1,1,{"$f":"COUNTIF($B12:$U12,5)","v":0},{"$f":"COUNTIF($B12:$U12,6)","v":1}]
["Item 3",4,1,2,2,4,1]
["Item 4",3,1,1,3,5,1]
["Item 5",0,1,11,1,0,1]
["Item 6",3,1,1,3,4,2]
["Item 7",5,1,1,2,4,1]
["Item 8",0,0,0,0,0,14]
[]
[null,"\"1\"","\"2\"","\"3\"","\"4\"","\"5\"","\"6\""]
["SCORE for each opinion acording to the multiplication factor","totally agree","tend to agree","sharred view","disagree","do not agree at all","do not know"]
["Item 1",{"$f":"B32*B$51","v":0},6,0,-6,{"$f":"F32*F$51","v":-48},0]
["Item 2",48,9,0,-3,{"$f":"F33*F$51","v":0},0]
["Item 3",24,3,0,-6,-24,0]
["Item 4",18,3,0,-9,-30,0]
["Item 5",0,3,0,-3,0,0]
["Item 6",18,3,0,-9,-24,0]
["Item 7",30,3,0,-6,-24,0]
["Item 8",0,0,0,0,0,0]
["multiplicator :",6,3,0,-3,-6,0]
[]
[]
["Don't forget to fill in the cell L1 in the page \"result\""]
[null,"opinions"]
["SUMS",{"$f":"\"+\"","v":"+"},{"$f":"\"-\"","v":"-"},{"$f":"\"% 'sharred view' \"","v":"% 'sharred view' "},"% do not know",null,null,null,"probable or not?"]
["Item 1",{"$f":"B43+C43","v":6},{"$f":"E43+F43","v":-54},{"$f":"D32/results!$M$1","v":7.1428571428571425E-2},{"$f":"G32/results!$M$1","v":7.1428571428571425E-2},{"$f":"IF(D57>0.25,\"TALK AGAIN\",(IF(B57=0,\"CONSENSUS\",(IF(C57=0,\"CONSENSUS\",(IF(B57/C57<=-2,\"CONSENSUS\",(IF(C57/B57<=-2,\"CONSENSUS\",\"TALK AGAIN\")))))))))","v":"CONSENSUS"},null,{"$f":"IF(D57>0.25,\"too many 'sharred view'\",(IF(F57=\"TALK AGAIN\",\"big disensus\",\"\")))","v":""},{"$f":"IF(E57>0.49,\"do not know\",(IF(F57=\"TALK AGAIN\",\"\",(IF(B57+C57>0,\"probable\",\"not probable\")))))","v":"not probable"}]
["Item 2",{"$f":"B44+C44","v":57},-3,{"$f":"D33/results!$M$1","v":7.1428571428571425E-2},{"$f":"G33/results!$M$1","v":7.1428571428571425E-2},{"$f":"IF(D58>0.25,\"TALK AGAIN\",(IF(B58=0,\"CONSENSUS\",(IF(C58=0,\"CONSENSUS\",(IF(B58/C58<=-2,\"CONSENSUS\",(IF(C58/B58<=-2,\"CONSENSUS\",\"TALK AGAIN\")))))))))","v":"CONSENSUS"},null,{"$f":"IF(D58>0.25,\"too many 'sharred view'\",(IF(F58=\"TALK AGAIN\",\"big disensus\",\"\")))","v":""},"probable"]
["Item 3",27,-30,{"$f":"D34/results!$M$1","v":0.14285714285714285},{"$f":"G34/results!$M$1","v":7.1428571428571425E-2},{"$f":"IF(D59>0.25,\"TALK AGAIN\",(IF(B59=0,\"CONSENSUS\",(IF(C59=0,\"CONSENSUS\",(IF(B59/C59<=-2,\"CONSENSUS\",(IF(C59/B59<=-2,\"CONSENSUS\",\"TALK AGAIN\")))))))))","v":"TALK AGAIN"},null,{"$f":"IF(D59>0.25,\"too many 'sharred view'\",(IF(F59=\"TALK AGAIN\",\"big disensus\",\"\")))","v":"big disensus"},""]
["Item 4",21,-39,{"$f":"D35/results!$M$1","v":7.1428571428571425E-2},{"$f":"G35/results!$M$1","v":7.1428571428571425E-2},{"$f":"IF(D60>0.25,\"TALK AGAIN\",(IF(B60=0,\"CONSENSUS\",(IF(C60=0,\"CONSENSUS\",(IF(B60/C60<=-2,\"CONSENSUS\",(IF(C60/B60<=-2,\"CONSENSUS\",\"TALK AGAIN\")))))))))","v":"TALK AGAIN"},null,{"$f":"IF(D60>0.25,\"too many 'sharred view'\",(IF(F60=\"TALK AGAIN\",\"big disensus\",\"\")))","v":"big disensus"},""]
["Item 5",3,-3,{"$f":"D36/results!$M$1","v":0.7857142857142857},{"$f":"G36/results!$M$1","v":7.1428571428571425E-2},{"$f":"IF(D61>0.25,\"TALK AGAIN\",(IF(B61=0,\"CONSENSUS\",(IF(C61=0,\"CONSENSUS\",(IF(B61/C61<=-2,\"CONSENSUS\",(IF(C61/B61<=-2,\"CONSENSUS\",\"TALK AGAIN\")))))))))","v":"TALK AGAIN"},null,{"$f":"IF(D61>0.25,\"too many 'sharred view'\",(IF(F61=\"TALK AGAIN\",\"big disensus\",\"\")))","v":"too many 'sharred view'"},""]
["Item 6",21,-33,{"$f":"D37/results!$M$1","v":7.1428571428571425E-2},{"$f":"G37/results!$M$1","v":0.14285714285714285},{"$f":"IF(D62>0.25,\"TALK AGAIN\",(IF(B62=0,\"CONSENSUS\",(IF(C62=0,\"CONSENSUS\",(IF(B62/C62<=-2,\"CONSENSUS\",(IF(C62/B62<=-2,\"CONSENSUS\",\"TALK AGAIN\")))))))))","v":"TALK AGAIN"},null,{"$f":"IF(D62>0.25,\"too many 'sharred view'\",(IF(F62=\"TALK AGAIN\",\"big disensus\",\"\")))","v":"big disensus"},""]
["Item 7",33,-30,{"$f":"D38/results!$M$1","v":7.1428571428571425E-2},{"$f":"G38/results!$M$1","v":7.1428571428571425E-2},"TALK AGAIN",null,{"$f":"IF(D63>0.25,\"too many 'sharred view'\",(IF(F63=\"TALK AGAIN\",\"big disensus\",\"\")))","v":"big disensus"},""]
["Item 8",0,0,{"$f":"D39/results!$M$1","v":0},{"$f":"G39/results!$M$1","v":1},"CONSENSUS",null,{"$f":"IF(D64>0.25,\"too many 'sharred view'\",(IF(F64=\"TALK AGAIN\",\"big disensus\",\"\")))","v":""},{"$f":"IF(E64>0.49,\"do not know\",(IF(F64=\"TALK AGAIN\",\"\",(IF(B64+C64>0,\"probable\",\"not probable\")))))","v":"do not know"}]

{"sheet":"results","index":2,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,7],[9,1,9,7],[10,1,10,7],[11,1,11,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[8,1,8,7]]}
["Working document - VALMER Project\n(please refer to the Valmer scenario guideline for methodology)\nhttp://www.valmer.eu/wp-content/uploads/2014/01/scenario_technical_guidelines_WP31.pdf",null,null,null,null,null,null,null,null,null,null,"Number of participants :",{"$f":"work!$B$8","v":14}]
["July 2013"]
[]
["Visual results",null,null,null,null,null,null,null,null,"Is there a consensus about the fact that it is probable or not?",null,null,"If yes, is it probable or not probable?"]
["Item 1","In the next years, the distribution of the dolphin will move",null,null,null,null,null,null,{"$f":"IF(J5=\"TALK AGAIN\",0,1)","v":1},{"$f":"work!F57","v":"CONSENSUS"},{"$f":"work!H57","v":""},{"$f":"IF(M5=\"probable\",1,(IF(M5=\"not probable\",0,\"\")))","v":0},{"$f":"work!I57","v":"not probable"}]
["Item 2","It is difficult to find new kelp harvesters.",null,null,null,null,null,null,{"$f":"IF(J6=\"TALK AGAIN\",0,1)","v":1},{"$f":"work!F58","v":"CONSENSUS"},{"$f":"work!H58","v":""},1,{"$f":"work!I58","v":"probable"}]
["Item 3","The water quality improves.",null,null,null,null,null,null,0,{"$f":"work!F59","v":"TALK AGAIN"},{"$f":"work!H59","v":"big disensus"},"",{"$f":"work!I59","v":""}]
["Item 4","The marine biodiversity is decreasing.",null,null,null,null,null,null,0,{"$f":"work!F60","v":"TALK AGAIN"},{"$f":"work!H60","v":"big disensus"},"",{"$f":"work!I60","v":""}]
["Item 5","The pressures on maerl beds increase due to extraction activities.",null,null,null,null,null,null,0,{"$f":"work!F61","v":"TALK AGAIN"},{"$f":"work!H61","v":"too many 'sharred view'"},"",{"$f":"work!I61","v":""}]
["Item 6","New species appear in the perimeter of the park.",null,null,null,null,null,null,0,{"$f":"work!F62","v":"TALK AGAIN"},{"$f":"work!H62","v":"big disensus"},"",{"$f":"work!I62","v":""}]
["Item 7","Storms are more frequent in the area.",null,null,null,null,null,null,0,{"$f":"work!F63","v":"TALK AGAIN"},{"$f":"work!H63","v":"big disensus"},"",{"$f":"work!I63","v":""}]
["Item 8","The project of marine renewable energy in the park is relevant. ",null,null,null,null,null,null,1,{"$f":"work!F64","v":"CONSENSUS"},{"$f":"work!H64","v":""},"",{"$f":"work!I64","v":"do not know"}]