{"size":{"Width":301,"Height":284},"appearance":{"background":null,"padding":14,"font":{"family":"Courier New","size":10.0,"bold":false,"italic":false,"underline":false,"strikeout":false,"color":"rgb(0,72,168)"},"border":{"on":true,"size":0.0,"style":"solid","color":"#666"},"text":{"wrap":false,"hAlign":"left","vAlign":"top"}},"outputType":"WIDGET","widgetState":null,"outputs":{"console":"<pre class='debug-source'>>x = prop.table(table(factor(`Household structure`[QFilter]))) * 100\n</pre>\n<pre class='debug-source'>>start.color = "#3e7dcc"\n</pre>\n<pre class='debug-source'>>end.color = "#00c8c8"\n</pre>\n<pre class='debug-source'>>colors =rgb(colorRamp(c(start.color, end.color))(seq(0, 1, length.out = length(x)))/255)\n</pre>\n<pre class='debug-source'>># Creating the chart\n</pre>\n<pre class='debug-source'>>flipStandardCharts::Chart(y = x,\n type = "Donut",\n colors = colors,\n data.label.font.size = 11, \n data.label.font.color = "black",\n data.label.font.family = "Arial",\n data.label.decimals = 0,\n data.label.suffix = "%",\n)\n</pre>\r\n<div class=\"debug-summarystatistics\">\r\n<table>\r\n<tr><th>Total time:</th><td>1.50s</td></tr>\r\n<tr><th>Time on R server:</th><td title=\"rApacheServe 1.33s (pre 0.01s, post 0.00s) httpget_code() setup for eval 0.02s session$eval 1.29s (pre 0.00s, post 0.04s) unexplained 0.02s apparmor forking (pre 0.04s, post 0.00s)\">1.33s</td></tr>\r\n<tr><th>Time evaluating code:</th><td>1.21s</td></tr>\r\n<tr><th>Bytes sent:</th><td>14,357</td></tr>\r\n<tr><th>Bytes received:</th><td>6,137</td></tr>\r\n</table>\r\n</div>","htmlwidgets":"<div id=\"htmlwidget_container\">\n <div id=\"htmlwidget-eb11b74bca39e051f5f5\" style=\"width:960px;height:500px;\" class=\"rhtmlDonut html-widget\"></div>\n</div>\n<script type=\"application/json\" data-for=\"htmlwidget-eb11b74bca39e051f5f5\">{\"x\":{\"values\":[22.0689655172414,33.3990147783251,3.8423645320197,21.0837438423645,12.2167487684729,7.38916256157635],\"labels\":[\"Alone\",\"With partner only\",\"With children only\",\"With partner & children\",\"With parents\",\"Other\"],\"settings\":{\"valuesFont\":\"Arial\",\"valuesSize\":11,\"valuesColor\":[\"#3E7DCC\",\"#328CCB\",\"#259BCA\",\"#19AACA\",\"#0CB9C9\",\"#00C8C8\"],\"valuesDisplay\":\"original\",\"valuesOrder\":\"initial\",\"valuesDec\":0,\"labelsFont\":\"Arial\",\"labelsSize\":11,\"labelsColor\":\"black\",\"labelsInner\":false,\"labelsBold\":false,\"labelsMinFontSize\":11,\"groups\":null,\"groupsFont\":\"Arial\",\"groupsFontColor\":\"black\",\"groupsSize\":11,\"groupsBold\":false,\"groupsColor\":null,\"groupsNames\":null,\"groupsSums\":null,\"groupsCounts\":null,\"groupLabelsMinFontSize\":11,\"title\":\"\",\"titleFontFamily\":\"Arial\",\"titleFontSize\":16,\"titleFontColor\":\"#2C2C2C\",\"titleTopPadding\":0,\"titleBold\":false,\"prefix\":\"\",\"suffix\":\"%\",\"orderControl\":false,\"gradient\":false,\"innerRadius\":\"70%\",\"minAngle\":0.003,\"borderColor\":\"#FFFFFF\"}},\"evals\":[],\"jsHooks\":[]}</script>\n<script type=\"application/htmlwidget-sizing\" data-for=\"htmlwidget-eb11b74bca39e051f5f5\">{\"viewer\":{\"width\":450,\"height\":350,\"padding\":0,\"fill\":true},\"browser\":{\"width\":960,\"height\":500,\"padding\":0,\"fill\":true}}</script>","htmlwidget-head":"{\"stylesheets\":[\"https://rserverhtmlwidgetasset.azureedge.net/d3pie-0bab3c984e04f3150b65ccaf2c83535a.css\"],\"javascript\":[\"https://rserverhtmlwidgetasset.azureedge.net/htmlwidgets-cd5c5716917807e1b69e2493221698b2.js\",\"https://rserverhtmlwidgetasset.azureedge.net/d3.min-2f50967ff82fd3475fcd22e9253d546e.js\",\"https://rserverhtmlwidgetasset.azureedge.net/d3pie-65cceb31dfc30ec2a905571eb62c7cb2.js\",\"https://rserverhtmlwidgetasset.azureedge.net/validate-290153bc67b0029aab48e0d29cb7c9e2.js\",\"https://rserverhtmlwidgetasset.azureedge.net/helpers-9c6d3474c9c9779f102fa0c5384f4fad.js\",\"https://rserverhtmlwidgetasset.azureedge.net/math-29a23041ec7683998cb0bb6711ec0c06.js\",\"https://rserverhtmlwidgetasset.azureedge.net/labels-86fa5d40808955608ff654f7a7b8e6c7.js\",\"https://rserverhtmlwidgetasset.azureedge.net/segments-661db9096377f450316f3360510c5a5f.js\",\"https://rserverhtmlwidgetasset.azureedge.net/text-64412032d620c64b5068a1e366fe3fc3.js\",\"https://rserverhtmlwidgetasset.azureedge.net/tooltip-0ecb96764ca814a750041aee1bd57ba0.js\",\"https://rserverhtmlwidgetasset.azureedge.net/rainbowvis-817701ea427986ff7c25fb14b18ce504.js\",\"https://rserverhtmlwidgetasset.azureedge.net/jquery.min-d7bc5b7f414121075b5891ca610e7377.js\",\"https://rserverhtmlwidgetasset.azureedge.net/rhtmlDonut-ec72fd027e6d5c7b0ef88cdc76219b64.js\"],\"attachments\":[]}","message":"","warning":""},"secondsTaken":1.5000057000000002,"updated":"2017-08-28T01:33:53.9097287Z","lastUpdatedMessage":null,"executedCode":"x = prop.table(table(factor(`Household structure`[QFilter]))) * 100\nstart.color = \"#3e7dcc\"\nend.color = \"#00c8c8\"\ncolors =rgb(colorRamp(c(start.color, end.color))(seq(0, 1, length.out = length(x)))/255)\n# Creating the chart\nflipStandardCharts::Chart(y = x,\n type = \"Donut\",\n colors = colors,\n data.label.font.size = 11, \n data.label.font.color = \"black\",\n data.label.font.family = \"Arial\",\n data.label.decimals = 0,\n data.label.suffix = \"%\",\n)","lastSavedCode":"x = prop.table(table(factor(`Household structure`[QFilter]))) * 100\nstart.color = \"#3e7dcc\"\nend.color = \"#00c8c8\"\ncolors =rgb(colorRamp(c(start.color, end.color))(seq(0, 1, length.out = length(x)))/255)\n# Creating the chart\nflipStandardCharts::Chart(y = x,\n type = \"Donut\",\n colors = colors,\n data.label.font.size = 11, \n data.label.font.color = \"black\",\n data.label.font.family = \"Arial\",\n data.label.decimals = 0,\n data.label.suffix = \"%\",\n)","highlightedCodeSpans":[{"start":28,"length":21,"index":1},{"start":50,"length":7,"index":6},{"start":136,"length":1,"index":0}],"tableTransformations":"<TabularTransformer>\r\n <TabularTransform type=\"Truncation\" truncationHeaderType=\"Column\" />\r\n <TabularTransform />\r\n</TabularTransformer>","tabularFilteringOptions":null,"hasGuiControls":true,"guiControls":{"Code":"if (!form.dataEntry)\n form.dropBox({name: \"formTable\", label: \"Table\", types: [\"Table\", \"RItem:integer,numeric,matrix,array,data.frame,table\"], required: true});\nelse\n{\n var dt = form.comboBox({name: \"formDataType\", label: \"Data source\", alternatives: [\"Use an existing table\", \"Type or paste data\"], default_value: \"Use an existing table\"});\n if (dt.getValue() == \"Use an existing table\")\n form.dropBox({name: \"formTable\", label: \"Table\", types: [\"Table\", \"RItem:integer,numeric,matrix,array,data.frame,table\"], required: true});\n else\n form.dataEntry({name: \"formEnteredData\", prompt: \"Opens a spreadsheet into which you can paste data.\"})\n}\nvar t = form.comboBox({name: \"formType\", label: \"Chart type\", alternatives: [\"Area\", \"Stacked Area\", \"100% Stacked Area\", \"Bar\", \"Stacked Bar\", \"100% Stacked Bar\",\n \"Column\", \"Stacked Column\", \"100% Stacked Column\", \"Line\", \"Donut\", \"Pie\", \"Scatterplot\", \"Labeled Scatterplot\", \"Labeled Bubbleplot\", \"Radar\"], default_value: \"Donut\", required: true}).getValue();\nif (t == \"Scatterplot\" || t == \"Labeled Scatterplot\" || t == \"Labeled Bubbleplot\")\n form.setHeading(t);\nelse\n form.setHeading(t + \" Chart\");\nvar show_pie_percentages = false;\nif (t == \"Pie\" || t == \"Donut\")\n show_pie_percentages = form.checkBox({name: \"formPiePercentages\", label: \"Show as percentages\"}).getValue();\nif (t != \"Donut\")\n form.checkBox({name: \"formTranspose\", label: \"Switch rows and columns\"});\nif (t == \"Scatterplot\" || t == \"Labeled Scatterplot\" || t == \"Labeled Bubbleplot\")\n{\n form.textBox({name: \"formGroupIndices\", label: \"Group indices\", required: false, prompt: \"For example: 1,1,2,1,3,2\"});\n form.textBox({name: \"formGroupLabels\", label: \"Group labels\", required: false, prompt: \"For example: Group 1, Group 2, Group 3\"});\n}\nform.comboBox({name: \"formPalette\", label: \"Color palette\", alternatives: [\"Default colors\", \"Primary colors\", \"Rainbow\", \"Light pastels\", \"Strong colors\",\n \"Reds, dark to light\", \"Reds, light to dark\", \"Greens, dark to light\", \"Greens, light to dark\", \"Blues, dark to light\", \"Blues, light to dark\", \"Greys, dark to light\", \"Greys, light to dark\",\n \"Heat colors (red, yellow, white)\", \"Terrain colors (green, beige, grey)\"], default_value: \"Default colors\", required: true});\nif (t == \"Pie\")\n form.comboBox({name: \"formPaletteOuter\", label: \"Outer ring color palette\", alternatives: [\"Group colors\", \"Default colors\", \"Primary colors\", \"Rainbow\", \"Light pastels\", \"Strong colors\",\n \"Reds, dark to light\", \"Reds, light to dark\", \"Greens, dark to light\", \"Greens, light to dark\", \"Blues, dark to light\", \"Blues, light to dark\", \"Greys, dark to light\", \n \"Greys, light to dark\", \"Heat colors (red, yellow, white)\", \"Terrain colors (green, beige, grey)\"], default_value: \"Group colors\", required: true});\nform.textBox({name: \"formTitle\", label: \"Title\", required: false});\nif (t != \"Pie\" && t != \"Donut\" && t != \"Radar\")\n{\n form.textBox({name: \"formXTitle\", label: \"X-axis title\", required: false});\n form.textBox({name: \"formYTitle\", label: \"Y-axis title\", required: false});\n}\nif (t == \"Labeled Bubbleplot\")\n form.textBox({name: \"formZTitle\", label: \"Bubble title\", required: false});\nif (t != \"100% Stacked Area\" && t != \"100% Stacked Bar\" && t != \"100% Stacked Column\" && !show_pie_percentages)\n{\n form.textBox({name: \"formPrefix\", label: \"Data value prefix\", required: false});\n var suffix = form.textBox({name: \"formSuffix\", label: \"Data value suffix\", required: false});\n if (suffix.getValue() == \"%\")\n form.checkBox({name: \"formMultiplyBy100\", label: \"Multiply data by 100\", default_value: false});\n}\n\nif (t != \"Pie\" && t != \"Donut\" && t != \"Radar\" && t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\")\n{\n var showXOpt = form.checkBox({name: \"formShowX\", label: \"Show X axis\", default_value: true});\n var showYOpt = form.checkBox({name: \"formShowY\", label: \"Show Y axis\", default_value: true});\n}\n\n\nvar show_decimals_control = t == \"Pie\" || t == \"Donut\" || (t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\" &&\n form.checkBox({name: \"formShowDataLabels\", label: \"Show data labels\", default_value: false}).getValue());\nif (t != \"Pie\" && t != \"Donut\")\n var showGridOpt = form.checkBox({name: \"formShowGrid\", label: \"Show grid\", default_value: true});\nif (t == \"Radar\" && showGridOpt.getValue())\n var showRadialOpt = form.checkBox({name: \"formShowY\", label: \"Show radial axis\", default_value: true});\n\n\nform.comboBox({name: \"formFont\", label: \"Font family\", alternatives: [\"Andale Mono\", \"Arial\", \"Arial Black\", \"Century Gothic\", \"Comic Sans MS\", \"Courier New\", \"Georgia\", \"Impact\", \"Open Sans\", \"Times New Roman\", \"Trebuchet MS\", \"Verdana\"], default_value: \"Arial\"});\nform.colorPicker({name: \"formFontColor\", label: \"Font color\", default_value: \"#2C2C2C\"});\n\nform.numericUpDown({name:\"formTitleFontSize\", label:\"Title font size\", default_value: 16});\nif (t != \"Pie\" && t != \"Donut\" && t != \"Radar\" && t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\")\n{\n form.numericUpDown({name: \"formXTitleFontSize\", label: \"X-axis title font size\", default_value: 12});\n form.numericUpDown({name: \"formYTitleFontSize\", label: \"Y-axis title font size\", default_value: 12});\n if (showXOpt.getValue())\n form.numericUpDown({name: \"formXTickFontSize\", label: \"X-axis label font size\", default_value: 10});\n if (showYOpt.getValue())\n form.numericUpDown({name: \"formYTickFontSize\", label: \"Y-axis label font size\", default_value: 10});\n}\nif (t == \"Labeled Scatterplot\" || t == \"Labeled Bubbleplot\")\n{\n form.numericUpDown({name: \"formXTitleFontSize\", label: \"X-axis title font size\", default_value: 12});\n form.numericUpDown({name: \"formYTitleFontSize\", label: \"Y-axis title font size\", default_value: 12});\n form.numericUpDown({name: \"formYTickFontSize\", label: \"Axes label font size\", default_value: 10})\n form.numericUpDown({name: \"formDataLabelFontSize\", label: \"Data label font size\", default_value: 10});\n}\nif (t == \"Radar\")\n{\n form.numericUpDown({name: \"formXTitleFontSize\", label: \"Angular label font size\", default_value: 12});\n if (showGridOpt.getValue() && showRadialOpt.getValue())\n form.numericUpDown({name: \"formYTickFontSize\", label: \"Radial axis label font size\", default_value: 10});\n}\n\nif (show_decimals_control)\n{\n form.numericUpDown({name: \"formDataLabelFontSize\", label: \"Data label font size\", default_value: 10});\n form.numericUpDown({name: \"formDataLabelDecimals\", label: \"Data label decimal places\", default_value: 2, increment: 1, minimum: 0, maximum: 12});\n}\n\nif (t != \"Pie\" && t != \"Donut\" && t != \"Radar\" && t != \"Scatterplot\" && t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\")\n{\n if (showXOpt.getValue())\n {\n if (t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\" && t != \"Pie\" && t != \"Donut\" &&\n t != \"Bar\" && t != \"Stacked Bar\" && t != \"100% Stacked Bar\")\n {\n form.checkBox({name: \"formLabelWordwrap\", label: \"Wordwrap X-axis label\", default_value: true});\n form.comboBox({name: \"formLabelAngle\", label: \"X-axis label orientation\", alternatives: [\"Automatic\", \"Horizontal\", \"Vertical\", \"Diagonal\"], default_value: \"Automatic\"});\n }\n }\n\n if (showYOpt.getValue())\n {\n if (t == \"Bar\" || t == \"Stacked Bar\" || t == \"100% Stacked Bar\")\n form.checkBox({name: \"formLabelWordwrap\", label: \"Word-wrap Y-axis label\", default_value: true});\n }\n}\n\nform.textBox({label: \"Rows to ignore\", type: \"text\", default_value: \"NET, Total, SUM\", name: \"formIgnoreRows\", required: false});\nform.textBox({label: \"Columns to ignore\", type: \"text\", default_value: \"NET, Total, SUM\", name: \"formIgnoreColumns\", required: false});\nif (t == \"Donut\")\n form.numericUpDown({name: \"formRadius\", label: \"Donut hole radius %\", default_value: 60, increment: 1, minimum: 1, maximum: 100});\nelse if (t == \"Pie\")\n form.numericUpDown({name: \"formRadius\", label: \"Radius of pie groupings % (multi-column tables only)\", default_value: 60, increment: 1, minimum: 1, maximum: 100});\nif (t != \"Labeled Scatterplot\" && t != \"Labeled Bubbleplot\" && t != \"Pie\" && t != \"Donut\" && t != \"Radar\")\n form.comboBox({name: \"formDateFormat\", label: \"Date format\", alternatives: [\"Default\", \"US (mm/dd/yyyy)\", \"International (dd/mm/yyyy)\"], default_value: \"Default\", required: true});","JSError":null,"JSErrorDetails":null,"ControlDefinitionErrors":null,"InputValidationErrors":null,"Controls":[{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":null,"Page":null,"Group":null,"Type":"Heading","Label":null,"LabelEmphasised":false,"Value":null,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":"Donut Chart","Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formDataType","Page":null,"Group":null,"Type":"ComboBox","Label":"Data source","LabelEmphasised":false,"Value":"Use an existing table","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Use an existing table","Type or paste data"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formTable","Page":null,"Group":null,"Type":"DropBox","Label":"Table","LabelEmphasised":false,"Value":"13106bf5-a437-48d6-859c-dcd9cb1cec8e","Allowed":null,"Multi":false,"Prompt":"Select an input which is of type Table or Ritem (Integer, Numeric, Matrix, Array, Data.Frame or Table).","ErrorMessage":"Table: Table accepts only one input which is of type Table or Ritem (Integer, Numeric, Matrix, Array, Data.Frame or Table).","Invalid":null,"Required":true,"AllowedTypes":["Table","RItem:integer,numeric,matrix,array,data.frame,table"],"OwnerRItemGuid":"728e3cb9-10ae-48b9-9086-d04cb27572ad","MinInputs":1,"MaxInputs":1,"Height":1,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formType","Page":null,"Group":null,"Type":"ComboBox","Label":"Chart type","LabelEmphasised":false,"Value":"Donut","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Area","Stacked Area","100% Stacked Area","Bar","Stacked Bar","100% Stacked Bar","Column","Stacked Column","100% Stacked Column","Line","Donut","Pie","Scatterplot","Labeled Scatterplot","Labeled Bubbleplot","Radar"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formPiePercentages","Page":null,"Group":null,"Type":"CheckBox","Label":"Show as percentages","LabelEmphasised":false,"Value":false,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formPalette","Page":null,"Group":null,"Type":"ComboBox","Label":"Color palette","LabelEmphasised":false,"Value":"Default colors","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Default colors","Primary colors","Rainbow","Light pastels","Strong colors","Reds, dark to light","Reds, light to dark","Greens, dark to light","Greens, light to dark","Blues, dark to light","Blues, light to dark","Greys, dark to light","Greys, light to dark","Heat colors (red, yellow, white)","Terrain colors (green, beige, grey)"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formTitle","Page":null,"Group":null,"Type":"TextBox","Label":"Title","LabelEmphasised":false,"Value":"","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formPrefix","Page":null,"Group":null,"Type":"TextBox","Label":"Data value prefix","LabelEmphasised":false,"Value":"","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formSuffix","Page":null,"Group":null,"Type":"TextBox","Label":"Data value suffix","LabelEmphasised":false,"Value":"%","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formMultiplyBy100","Page":null,"Group":null,"Type":"CheckBox","Label":"Multiply data by 100","LabelEmphasised":false,"Value":false,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":"left","Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formFont","Page":null,"Group":null,"Type":"ComboBox","Label":"Font family","LabelEmphasised":false,"Value":"Arial","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":true,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":["Andale Mono","Arial","Arial Black","Century Gothic","Comic Sans MS","Courier New","Georgia","Impact","Open Sans","Times New Roman","Trebuchet MS","Verdana"],"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formFontColor","Page":null,"Group":null,"Type":"ColorPicker","Label":"Font color","LabelEmphasised":false,"Value":"rgb(64, 64, 64)","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Font color: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formTitleFontSize","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Title font size","LabelEmphasised":false,"Value":16.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Title font size: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":0.0,"Max":100.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formDataLabelFontSize","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Data label font size","LabelEmphasised":false,"Value":10.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Data label font size: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":0.0,"Max":100.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formDataLabelDecimals","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Data label decimal places","LabelEmphasised":false,"Value":0.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Data label decimal places: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":0.0,"Max":12.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formIgnoreRows","Page":null,"Group":null,"Type":"TextBox","Label":"Rows to ignore","LabelEmphasised":false,"Value":"NET, Total, SUM","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formIgnoreColumns","Page":null,"Group":null,"Type":"TextBox","Label":"Columns to ignore","LabelEmphasised":false,"Value":"NET, Total, SUM","Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":"formRadius","Page":null,"Group":null,"Type":"NumericUpDown","Label":"Donut hole radius %","LabelEmphasised":false,"Value":60.0,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":"Donut hole radius %: ","Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":1.0,"Min":1.0,"Max":100.0,"Vertical":null},{"ItemGuid":"00000000-0000-0000-0000-000000000000","ControlName":null,"Page":null,"Group":null,"Type":null,"Label":null,"LabelEmphasised":false,"Value":null,"Allowed":null,"Multi":false,"Prompt":null,"ErrorMessage":null,"Invalid":null,"Required":false,"AllowedTypes":null,"OwnerRItemGuid":null,"MinInputs":0,"MaxInputs":0,"Height":0,"Duplicates":false,"Values":null,"CheckAlign":null,"Text":null,"Increment":0.0,"Min":0.0,"Max":0.0,"Vertical":true}]},"calculating":"Idle","showDebug":false,"layout":"OutputOnly","vSplit":0.25,"hSplit":0.45,"updateWarnings":true,"updateMode":"Automatic","warnSlow":true,"Options":{"debugconsole":false,"codeposition":"OutputOnly","splitH":0.45,"splitV":0.25,"update warnings":true,"updating":"Automatic","warn slow":true}}