2b:null 2c:["$","title",null,{"children":"formform . value table wizard | Peter Hofmann | Observable"}] 31:T812,md` \`\`\`js valueTableWizard(formula, , ) \`\`\` - \`\`formula\`\` is your FORM in [paranthesis notation](https://formform.formsandlines.eu/tricorder/), like \`\`'((a)b)'\`\` - \`\`\`\` is an optional object for specific settings (omit with \`\`{}\`\`) - \`\`\`\` are one or more optional filter objects: \`\`{search, }\`\` - \`\`search\`\`: Array of values to filter, e.g.: \`\`[0]\`\`, \`\`[2,3]\`\` - \`\`\`\` are all boolean values: | Option | How it works | | ---------------- | ------------------------------------------ | | \`\`exclude\`\` | excludes search values from filtered object | | \`\`combine\`\` | every search values must match for each result (logical AND instead of (default) OR) | | \`\`unique\`\` | one and only one of the search values must match for each result | | \`\`only\`\` | one and only one of the search values and no other value must match in each result | If no filter is specified, the complete value table is generated. Multiple filters can be combined (seperated by commas, like \`\`{…},{…}\`\`) to reach more complex interpretation/result patterns. This can be especially useful for FORMs with more than two variables where complete value tables are just too large for any effective pattern analysis. \`\`\`\` options are as follows: | Setting | How it works | | ---------------- | ------------------------------------------ | | \`\`varOrder\`\` | custom variable ordering given by an array of every variable in the FORM (e.g. ['b','c','a']) | | \`\`outputCSV\`\` | additional output as a CSV string (returns an object \`\`{csv, html}\`\`) | | \`\`lang\`\` | specify local translation (see example below) | | \`\`classnames\`\` | specify custom CSS classnames | | \`\`interpr\`\` | manually set FORM interpretation (can be useful for multiple tables of the same FORM, since FORM calculation doesn't have to be repeated in every function call) | `32:T45d,function valueTableWizard(formula_pre, _config, ..._optsArr) { const config = Object.assign({ varOrder:undefined, outputCSV:false, lang:LANG, classnames:CLASSNAMES_DEFAULT, interpr:undefined}, _config); let optsArr = _optsArr.length > 0 ? _optsArr : [{}]; optsArr = optsArr.map( opts => Object.assign({search:[], filterByVals:false}, opts) ); const varList = config.varOrder ? config.varOrder : formform.form.matchDefaultVarOrder( formform.form.getVariables(formula_pre) ); const formula = formform.form.reOrderVars( formula_pre, varList ); let interpr = config.interpr ? config.interpr : formform.form.calcAll(formula); for (let i in optsArr) { if (optsArr[i].filterByVals) interpr = filterResultsByValues(interpr, optsArr[i].search, optsArr[i]); else interpr = filterResultsByInterpr(interpr, optsArr[i].search, optsArr[i]); } const html = genValueTable(interpr, {varOrder: varList, lang: config.lang, classnames: config.classnames}); if (config.outputCSV) return {html: html, csv: genCSV(interpr, config.lang)}; else return html; }33:T825,function genValueTable(interpr, opts) { // !old args: (interpr, lang, classnames) const {varOrder=undefined, lang=LANG, classnames=CLASSNAMES_DEFAULT} = {...opts}; let thead = ''; let tbody = ''; if (interpr.hasOwnProperty('Result')) { const val = interpr.Result + ' / ' + ( (interpr.Result === 0) ? 'n' : (interpr.Result === 1) ? 'm' : (interpr.Result === 2) ? 'u' : (interpr.Result === 3) ? 'i' : '???' ); thead = `${lang.result}` tbody = `${val}` } else { function restoreVarsInKey(str) { if (varOrder === undefined) return str; const parts = str.split(';'); // const restoredVarKeys = parts[0].split(',').map((v,i) => varOrder[i]).join(','); const restoredVarKeys = varOrder.join(','); return restoredVarKeys + ';' + parts[1]; }; const _keys = Object.keys(interpr); const corr_interpr = Object.fromEntries( _keys.map(k => [ restoreVarsInKey(k), interpr[k] ]) ) const keys = Object.keys(corr_interpr); keys.sort(); // ALERT -> obsolete? const labels = keys.map(e => { let parts = e.split(';'); parts = parts.map((p,i) => { const delim = i < 1 ? ',' : '', sep = delim; return p.split(delim).join(`${sep}`).concat(``).addBefore(0,``); } ); return parts; }); thead = `${lang.variables} ${lang.interpretation} ${lang.result}` let str = ''; keys.forEach( (e,i) => { str += `${labels[i][0]} ${labels[i][1]} ${corr_interpr[e]}`; } ); tbody = str; } return ` ${ thead } ${ tbody }

`; }34:T8f3,function filterResultsByInterpr(data, search, _opts) { const opts = Object.assign({exclude:false, combine:false, unique:false, only:false}, _opts); // filters values from formform.form.calcAll() // - search: Array of values to filter, e.g.: [0], [2,3] // - Options: // - exclude: exclude search values from filtered object // - combine: every search values must match for each result (logical AND instead of (default) OR) // - unique: one and only one of the search values must match for each result // - only: one and only one of the search values and no other value must match in each result if (search.length < 1) return data; // 4 values are all the values, so we just return everything else { const filteredKeys = Object.keys(data).filter( (e,i) => { const interpr = e.split(';')[1]; let include = false; if (opts.combine || opts.unique || opts.only) { if (opts.combine) { include = search.every( (searchVal,j) => { return interpr.includes(searchVal); }); } else if (opts.unique) { let memory = -1; include = search.every( (searchVal,j) => { if (interpr.includes(searchVal) && memory === -1) { memory = searchVal; return true; } if (memory !== -1) { if (interpr.includes(searchVal)) { return memory === searchVal; } return true; } if (j < search.length-1) return true; else return false; }); } else if (opts.only) { let match = -1; search.some( searchVal => { if (interpr.includes(searchVal)) { match = searchVal; return true; } }); include = interpr.split('').every( char => parseInt(char) === match ); } } else { include = search.some( (searchVal,j) => { return interpr.includes(searchVal); } ); } return include ? !opts.exclude : opts.exclude; } ); let filteredData = {}; filteredKeys.forEach( key => { filteredData[key] = data[key]; } ) return filteredData; } }35:[] 2f:{"id":"99b8f5ac562cf4e6","slug":"formform-value-filters-table-wizard","title":"formform . value table wizard","thumbnail":"32836a3e64530c8316fce451c6980b7cf0e25ed60a80213f4657ca71f0461d28","access_level":"public","create_time":"$D2019-03-07T21:51:20.224Z","update_time":"$D2020-08-07T18:14:25.490Z","view_time":null,"first_public_time":"$D2019-03-10T19:53:26.423Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"e581d618919cd266","login":"formsandlines","name":"Peter Hofmann","avatar_url":"https://avatars-next.observableusercontent.com/da037e21011ef7f0553d73420763f4a2071c0bd9191552279dd8ebc154fc28b8","tier":"starter_2024"},"version":629,"publish_version":629,"role":null,"authored":false,"authors":[{"type":"individual","id":"b20948974f4dc365","login":"formsandlines","name":"Peter Hofmann","avatar_url":"https://avatars-next.observableusercontent.com/da037e21011ef7f0553d73420763f4a2071c0bd9191552279dd8ebc154fc28b8","tier":null}],"members":[{"type":"individual","id":"b20948974f4dc365","login":"formsandlines","name":"Peter Hofmann","avatar_url":"https://avatars-next.observableusercontent.com/da037e21011ef7f0553d73420763f4a2071c0bd9191552279dd8ebc154fc28b8","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":{"id":"929942c346668d9a","slug":"components","title":"Components","owner":{"id":"e581d618919cd266","login":"formsandlines","name":"Peter Hofmann"}},"type":"notebook","body":{"title":"formform . value table wizard","cells":[{"id":0,"value":"md`# *formform* . value table wizard`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":167,"value":"md`---\nThis plugin for my [formform](https://github.com/formsandlines/formform) library allows you to generate and filter value tables of FORM calculations. It has the same functionality as the “calculate” function in my [FORM tricorder](https://formform.formsandlines.eu/tricorder/); in fact I plan to replace this notebook as soon as I publish the plugin separately on NPM (of course, the URL will still remain accessible).\n\nTo use it in your notebook:\n\\`\\`\\`js\n import {valueTableWizard, valueTableCSS} from '@formsandlines/formform-value-filters-table-wizard'\n\\`\\`\\`\n\nCall \\`\\`valueTableCSS\\`\\` in a separate cell to load the CSS.\n\nFor a german translation enter in two cells:\n\\`\\`\\`js\n LANG = 'de'\n\n import {valueTableWizard, valueTableCSS} with { LANG as setLang } from '@formsandlines/formform-value-filters-table-wizard'\n\\`\\`\\`\nIf you need other languages, just contact me or fork this notebook.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":438,"value":"md`\n---\n\n## Syntax\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":370,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":66,"value":"md`\n---\n\n## Examples\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":449,"value":"// full value table\nhtml`${valueTableWizard('{L,R}')}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":52,"value":"// get only results from binary interpretations:\nhtml`${valueTableWizard('{L,E,R}', {}, {search: [2,3], exclude: true} )}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":355,"value":"// get only results from interpretations that include 1, 2 and 3:\nhtml`${valueTableWizard('{L,E,R}', {}, {search: [1,2,3], combine: true} )}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":357,"value":"// get only results from symmetric interpretations:\nhtml`${valueTableWizard('{L,E,R}', {}, {search: [0,1,2,3], unique: true} )}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":295,"value":"// get all 2-results\nhtml`${valueTableWizard('((a)b)', {}, {filterByVals: true, search: [2]})}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":343,"value":"// get all 0-results from interpretations that do not contain 0s\nhtml`${valueTableWizard('({a,b,c}{a,d})', {}, {search: [0], exclude: true}, {search: [0], filterByVals: true})}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":494,"value":"// local translation and custom variable ordering are also possible\nhtml`${ valueTableWizard('(((\"fire\")(\"gunpowder\"))) \"explosion\"',{\n lang: {variables: '💬', interpretation: '💣', result: '💥'},\n varOrder: ['fire','gunpowder','explosion'],\n}, {search: [0], filterByVals: true}) }`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":62,"value":"md`\n---\n\n## Source Code\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":198,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":200,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":204,"value":"function genCSV(interpr, lang=LANG) {\n const keys = Object.keys(interpr);\n keys.sort(); // ALERT\n\n let csv = '';\n\n if (interpr.hasOwnProperty('Result')) {\n csv = lang.result + '\\n' + interpr[keys[0]];\n }\n else {\n csv = [lang.variables, lang.interpretation, lang.result].join(';') + '\\n';\n\n keys.forEach((k,i) => {\n csv += k + ';' + interpr[k] + (i < keys.length-1 ? '\\n' : '');\n });\n\n }\n\n return csv;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":219,"value":"function filterResultsByValues(data, search, _opts) {\n const opts = Object.assign({exclude:false}, _opts);\n\n if (search.length > 3) return data; // 4 values are all the values, so we just return everything\n else {\n let indexList = [];\n const filteredVals = Object.values(data).filter( (e,i) => {\n const include = ( \n e === search[0] ||\n ((search.length > 0) ? e === search[1] : e === search[0] ) ||\n ((search.length > 1) ? e === search[2] : e === search[0] )\n ) ? !opts.exclude : opts.exclude;\n if(include) indexList.push(i);\n return include;\n } );\n const filteredKeys = Object.keys(data).filter( (e,i) => indexList.includes(i) );\n \n let filteredData = {};\n filteredKeys.forEach( key => { filteredData[key] = data[key]; } )\n \n return filteredData;\n }\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":222,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":601,"value":"md`---\n\n## Defaults\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":17,"value":"valueTableCSS = html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":211,"value":"classnames_DEF = ({table: 'value-table', td: {varLabels: 'varLabels', varVals: 'varValues', result: 'result'}})\n// CSS classnames can be changed here if needed","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":78,"value":"loc_EN = ({variables: 'Variables', interpretation: 'Interpretation', result: 'Result'})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":95,"value":"loc_DE = ({variables: 'Variablen', interpretation: 'Interpretation', result: 'Ergebnis'})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":192,"value":"// add more translations here if needed","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":214,"value":"CLASSNAMES_DEFAULT = classnames_DEF","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":80,"value":"LANG = {\n switch(setLang) {\n case 'de':\n return loc_DE;\n case 'en':\n return loc_EN;\n // new translation objects need to be wired here\n default:\n return loc_EN;\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":130,"value":"setLang = ''","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":70,"value":"md`\n---\n\n### Appendix\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2,"value":"formform = require('formform@0.8.0')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"