{"id":51246,"date":"2017-04-14T21:52:06","date_gmt":"2017-04-14T20:52:06","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=51246"},"modified":"2020-12-02T08:01:36","modified_gmt":"2020-12-02T07:01:36","slug":"enquetes-verwerken-reeksen-van-antwoorden","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/enquetes-verwerken-reeksen-van-antwoorden\/","title":{"rendered":"Enqu\u00eates verwerken: reeksen van antwoorden"},"content":{"rendered":"<p>Soms gaat een reeks van antwoorden gebruikt worden voor verschillende vragen. Dat is bv. het geval met waardeschalen. De eenvoudigste manier om die te verwerken, is tellen met AANTAL.ALS.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51247\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksenvanantwoordreeksen-300x69.png\" alt=\"\" width=\"300\" height=\"69\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksenvanantwoordreeksen-300x69.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksenvanantwoordreeksen-768x178.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksenvanantwoordreeksen-1024x237.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksenvanantwoordreeksen.png 1159w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>Nadeel is dat je geen draaitabellen kan gebruiken om antwoorden op verschillende vragen te combineren. Dat is op te lossen door de antwoorden op twee vragen te combineren met &amp;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51259\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv1-300x99.png\" alt=\"\" width=\"300\" height=\"99\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv1-300x99.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv1-768x253.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv1.png 980w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>en die te tellen met AANTAL.ALS waarbij je het criterium van AANTAL.ALS ook samenvoegt met &amp;:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51258\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv2-300x137.png\" alt=\"\" width=\"300\" height=\"137\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv2-300x137.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv2-768x352.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv2-1024x469.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/04\/xl-reeksen-samenv2.png 1137w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Soms gaat een reeks van antwoorden gebruikt worden voor verschillende vragen. Dat is bv. het geval met waardeschalen. De eenvoudigste manier om die te verwerken, is tellen met AANTAL.ALS. Nadeel is dat je geen draaitabellen kan gebruiken om antwoorden op verschillende vragen te combineren. Dat is op te lossen door<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":13,"footnotes":""},"categories":[464,538,54,375,366,10,246,528],"tags":[],"class_list":["post-51246","post","type-post","status-publish","format-standard","hentry","category-ebp","category-enquetes","category-excel","category-excel-office-2010","category-grafieken","category-office","category-office-2010","category-statistiek"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 23:26:21","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=51246"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51246\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=51246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=51246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=51246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}