{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Intro","Graphs","Inputs","Results","Calculations","Formulas","Plot Vars","(Other Variables)","Labels","(Ranges)","(Import)"],"not_rendered":{"charts":2,"images":2,"defined_names":11,"comments":6},"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":101,"n_cols":1,"rows_kept":101}
[]
[]
["Decision Support"]
[]
["You can customize this template by filling in a simple form, without editing a spreadsheet."]
["This is a small working sample of the decision support template."]
[]
["A customized template is a flexible model that you can adapt to your situation by filling in a simple form, without editing a spreadsheet or its formulas. For example, you can specify time range and time grain; number and names of items in a dimension (such as your products and product families); and include or exclude major features. The resulting spreadsheet matches your needs better than any standard template."]
["Get a customized version of this template on our website."]
[]
["ModelSheet provides you with customized templates in three ways."]
[]
["1. Order a customized version of this template."]
["Click \"+\" for more information."]
["• You can specify custom features by filling out a simple form. (Click on \"+\" for more information.)"]
["Precise customizations vary from template to template. Examples:"]
["− Specify the starting time, time range, time grain and rollup time grains (such as annual sums)."]
["− Specify the items in a dimension and levels of hierarchy (such as product families and products)."]
["− Include or exclude entire sub-models in the template."]
["− These features address the most serious problem with conventional spreadsheet templates: You can\n   customize a template in many ways without having to interpret and edit numerous cell formulas."]
[]
["• You can edit many aspects of your Excel template after receiving it. (Click on \"+\" for more information.)"]
["− Edit input data in clearly marked input cells."]
["− Edit the model start date of a template, so your template is not out of date when the start date changes."]
["− Edit names of dimension items in once place (such as products, departments, expense accounts)."]
[]
["• ModelSheet Excel templates are easier to understand. (Click on \"+\" for more information.)"]
["− Each table has an Excel comment that provides a variable name and explains the variable. "]
["− Worksheet \"Formulas\" expresses the entire model with named variables and symbolic formulas. Although\n   the symbolic formulas are not executable in Excel, they are what the model is made from in ModelSheet."]
["− You never need to read inscrutable cell formulas to understand a ModelSheet customized template."]
[]
["Explore our customized templates."]
[]
["2. If you want more customizations, retain ModelSheet Software to build them for you."]
["Click \"+\" for more information."]
["• Our staff has extensive experience in many areas of business and engineering analysis."]
["• ModelSheet technology enables us to offer you more value for your consulting dollar."]
[]
["Learn more about consulting services."]
[]
["3. Use the ModelSheet Authoring Environment to build and customize your spreadsheet models."]
[]
["The ModelSheet Authoring Environment is a SaaS application for developing and maintaining business models and delivering them in conventional spreadsheets."]
["Click \"+\" to learn more about ModelSheet technology that makes customized template possible."]
[]
["This Excel workbook was generated using ModelSheet, a revolutionary new spreadsheet technology. ModelSheet allows you to develop business models using readable formulas, while avoiding the details of cell addresses and hard-to-change sheet layouts. The end result is a conventional Excel workbook just like this one. We built ModelSheet because we believe that spreadsheets are a great way of communicating results but we think it's just too hard to use them to develop reliable, maintainable, expressive and collaborative models."]
[]
["You'll get a glimpse of ModelSheet's advantages when you take a look at the \"Formulas\" tab and realize how few separate, readable formulas are needed to produce all of the other worksheets. In addition to formulas, ModelSheet knows about the \"dimensions\" in your model (e.g., products, locations, departments) as well as the time series that you're using (e.g., 5 years in quarters.) ModelSheet raises the level of thinking and acting from individual cells to natural modeling concepts. It enhances model reliabilty, auditability and maintainability; it enables you to build models that better reflect your intentions; it allows easier collaboration between modelers, developers, and report users; and it improves productivity, especially when making changes to a model."]
[]
["The ModelSheet authoring environment raises the level of thinking and acting from individual cells to natural modeling concepts like variables, dimensions, time series and accounting types. It enhances model reliabilty, auditability and maintainability; it enables you to build models that better reflect your intentions; it allows easier collaboration between modelers, developers, and report users; and it improves productivity, especially when making changes to a model."]
[]
["We have more to tell you about ModelSheet and we'd like to hear about your needs for templates and models."]
["Please visit our website at www.modelsheetsoft.com"]
["or contact us at info@modelsheetsoft.com."]
[]
[]
[]
["Description of the Decision Support model"]
[]
["This model scores and ranks alternative courses of action based on multiple decision criteria ."]
[]
["Inputs to the model include: (All input cells are shaded blue in the workbook.)"]
["• A list of alternative courses of action."]
["• A list of criteria for evaluating the alternative courses of action."]
["• A list of weights of each decision criterion. The weights are the same for all alternative course of action."]
["• A quantitative rating of each alternative for each decision criterion. We recommend a range of 0 - 5\n   for each rating."]
[]
["The Advanced version of the model supports decisions with uncertain outcomes. See the technical notes below for more information."]
[]
["The key results are displayed on worksheet \"Results.\""]
[]
["As you explore the model, we suggest that you"]
["• Read some of the Excel comments that are attached to Analysis Variables throughout the workbook.\n  These comments also appear in ModelSheet in convenient places."]
["• View worksheet \"Formulas\" which shows the named variables and symbolic formulas of the model\n   in a compact and readable form. The symbolic formulas are not active in this Excel workbook, but they\n   give you some idea how the model works, and how it looks in ModelSheet."]
[]
["Suggestions for using this model"]
[]
["1. Use this workbook as-is, if the model fits your decision situation. You can change the data in the dark blue\n    input cells. You can change the display names of dimension items and variables in dark blue cells on the\n    worksheet \"Labels.\""]
[]
["2. Customize this Excel workbook to make a decision support tool that fits your situation."]
[]
["3. Use ModelSheet to edit the formulas in this model, using named variables, symbolic formulas (and far fewer\n    formulas), segmentation dimensions and time series, without ever touching a cell address -- and end up with\n    a conventional Excel workbook."]
["To do this, go the the ModelSheet website below and request a trial account for ModelSheet."]
[]
[]
[]
["Technical Notes"]
[]
["Below is a summary of how uncertainty is handled in the model."]
[]
["• The uncertainty in each rating is the standard deviation of that rating. Roughly speaking, it means the likely\n   outcomes of the true rating are in the range from YourRating - Uncertainty to YourRating + Uncertainty."]
[]
["• Risk aversion means that you would prefer a sure payoff of $100 to a 50% probabilities of payoffs\n   of $100 and $50. The expected (or mean) outcome is not enough information to distinguish your\n   preferences among  alternatives. We recommend a risk aversion parameter in the range 0 - 1."]
["(Risk aversion does not mean that you would prefer a sure payoff of $100 to a 50% probability of a payoff of $50 and a 50% probability of a payoff of $100 -- anyone would prefer the sure payoff in this case.)"]
["Generally, people who are putting a larger fraction of their assets at risk are more risk averse. People putting a smaller portion of their assets at risk can afford to choose the higher expected return despite some riskness of the outcome. "]
["(Technical note: The risk aversion parameter in this model indicates how much to reduce the expected score for an increase in variance of the distribution of scores of the outcomes.)"]
[]
["This Excel workbook was generated by ModelSheet on June 30, 2010, except for this worksheet of comments."]
[]
["Copyright © 2009, 2010 ModelSheet Software, LLC"]
["ModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC."]

{"sheet":"Graphs","index":1,"n_rows":46,"n_cols":1,"rows_kept":46}
[{"$f":"IF(INDEX([0]!Risk_AnalysisQ,1), \" \", \"You did not specify the risk analysis feature, so delete the upper and lower error bars on the graph.\")","v":" "}]
{"$rows_empty":44}
[{"$f":"IF(INDEX([0]!Risk_AnalysisQ,1), \" \", \"You did not specify the risk analysis feature, so delete the graph below.\")","v":" "}]

{"sheet":"Inputs","index":2,"n_rows":34,"n_cols":3,"rows_kept":34,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,3],[5,0,5,3],[6,0,6,3],[25,0,25,1]]}
[{"$f":"\"Project: \"&B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&B8","v":"Organization:  "}]
[{"$f":"\"Inputs\"","v":"Inputs"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"Shaded cells are input cells. You can enter data in them.\"","v":"Shaded cells are input cells. You can enter data in them."}]
[{"$f":"\"Excel formulas in shaded cells are starting suggestions.\"","v":"Excel formulas in shaded cells are starting suggestions."}]
[{"$f":"\"You can overwrite them.\"","v":"You can overwrite them."}]
[{"$f":"Labels!B9","v":"Organization Name"}," "]
[{"$f":"Labels!B10","v":"Project Name"}," "]
[]
[{"$f":"Labels!B23","v":"Weights (>=0)"}]
[{"$f":"\"   \"&Labels!B32","v":"   Initial Cost"},{"$f":"2","v":{"v":2,"d":"2.00"}}]
[{"$f":"\"   \"&Labels!B33","v":"   Ongoing Expense"},{"$f":"2","v":{"v":2,"d":"2.00"}}]
[{"$f":"\"   \"&Labels!B34","v":"   Functionality"},{"$f":"2","v":{"v":2,"d":"2.00"}}]
[{"$f":"\"   \"&Labels!B35","v":"   Ease of Use"},{"$f":"2","v":{"v":2,"d":"2.00"}}]
[{"$f":"\"   \"&Labels!C31","v":"   Total"},{"$f":"SUM(B12:B15)","v":{"v":8,"d":"8.00"}}]
[]
[null,{"$f":"Labels!B28","v":"Alternative 1"},{"$f":"Labels!B29","v":"Alternative 2"}]
[{"$f":"Labels!B11","v":"Ratings (>=0)"}]
[{"$f":"\"   \"&Labels!B32","v":"   Initial Cost"},{"$f":"3","v":{"v":3,"d":"3.00"}},{"$f":"3","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B33","v":"   Ongoing Expense"},{"$f":"3","v":{"v":3,"d":"3.00"}},{"$f":"3","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B34","v":"   Functionality"},{"$f":"3","v":{"v":3,"d":"3.00"}},{"$f":"3","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B35","v":"   Ease of Use"},{"$f":"3","v":{"v":3,"d":"3.00"}},{"$f":"3","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!C31","v":"   Total"},{"$f":"Calculations!B17","v":{"v":3,"d":"3.00"}},{"$f":"Calculations!C17","v":{"v":3,"d":"3.00"}}]
[]
[{"$f":"\"Risk Parameters\"","v":"Risk Parameters"}]
[{"$f":"Labels!B21","v":"Uncertainty in Ratings"}]
[{"$f":"\"   \"&Labels!B32","v":"   Initial Cost"},{"$f":"0","v":{"v":0,"d":"0.00"}},{"$f":"0","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B33","v":"   Ongoing Expense"},{"$f":"0","v":{"v":0,"d":"0.00"}},{"$f":"0","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B34","v":"   Functionality"},{"$f":"0","v":{"v":0,"d":"0.00"}},{"$f":"0","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B35","v":"   Ease of Use"},{"$f":"0","v":{"v":0,"d":"0.00"}},{"$f":"0","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C31","v":"   Total"},{"$f":"SQRT(Calculations!B24)","v":{"v":0,"d":"0.00"}},{"$f":"SQRT(Calculations!C24)","v":{"v":0,"d":"0.00"}}]
[]
[{"$f":"Labels!B14","v":"Risk Aversion"}]

{"sheet":"Results","index":3,"n_rows":7,"n_cols":5,"rows_kept":7,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5]]}
[{"$f":"\"Project: \"&Inputs!B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&Inputs!B8","v":"Organization:  "}]
[{"$f":"\"Results\"","v":"Results"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"Labels!B15","v":"Scores"},null,null,{"$f":"Labels!B18","v":"Risk Adjusted Scores"}]
[{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Inputs!B24","v":{"v":3,"d":"3.00"}},null,{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Inputs!B24-Inputs!B34*Calculations!B24","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Inputs!C24","v":{"v":3,"d":"3.00"}},null,{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Inputs!C24-Inputs!B34*Calculations!C24","v":{"v":3,"d":"3.00"}}]

{"sheet":"Calculations","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5]]}
[{"$f":"\"Project: \"&Inputs!B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&Inputs!B8","v":"Organization:  "}]
[{"$f":"\"Calculations\"","v":"Calculations"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"Labels!B24","v":"Normalized Weights"}]
[{"$f":"\"   \"&Labels!B32","v":"   Initial Cost"},{"$f":"Inputs!B12/Inputs!B16","v":0.25}]
[{"$f":"\"   \"&Labels!B33","v":"   Ongoing Expense"},{"$f":"Inputs!B13/Inputs!B16","v":0.25}]
[{"$f":"\"   \"&Labels!B34","v":"   Functionality"},{"$f":"Inputs!B14/Inputs!B16","v":0.25}]
[{"$f":"\"   \"&Labels!B35","v":"   Ease of Use"},{"$f":"Inputs!B15/Inputs!B16","v":0.25}]
[]
[null,{"$f":"Labels!B28","v":"Alternative 1"},{"$f":"Labels!B29","v":"Alternative 2"}]
[{"$f":"Labels!B12","v":"Ratings Norm Wtd"}]
[{"$f":"\"   \"&Labels!B32","v":"   Initial Cost"},{"$f":"Inputs!B20*B6","v":0.75},{"$f":"Inputs!C20*B6","v":0.75}]
[{"$f":"\"   \"&Labels!B33","v":"   Ongoing Expense"},{"$f":"Inputs!B21*B7","v":0.75},{"$f":"Inputs!C21*B7","v":0.75}]
[{"$f":"\"   \"&Labels!B34","v":"   Functionality"},{"$f":"Inputs!B22*B8","v":0.75},{"$f":"Inputs!C22*B8","v":0.75}]
[{"$f":"\"   \"&Labels!B35","v":"   Ease of Use"},{"$f":"Inputs!B23*B9","v":0.75},{"$f":"Inputs!C23*B9","v":0.75}]
[{"$f":"\"   \"&Labels!C31","v":"   Total"},{"$f":"SUM(B13:B16)","v":{"v":3,"d":"3.00"}},{"$f":"SUM(C13:C16)","v":{"v":3,"d":"3.00"}}]
[]
[{"$f":"Labels!B22","v":"Variance of Ratings"}]
[{"$f":"\"   \"&Labels!B32","v":"   Initial Cost"},{"$f":"Inputs!B28^2","v":{"v":0,"d":"0.00"}},{"$f":"Inputs!C28^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B33","v":"   Ongoing Expense"},{"$f":"Inputs!B29^2","v":{"v":0,"d":"0.00"}},{"$f":"Inputs!C29^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B34","v":"   Functionality"},{"$f":"Inputs!B30^2","v":{"v":0,"d":"0.00"}},{"$f":"Inputs!C30^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!B35","v":"   Ease of Use"},{"$f":"Inputs!B31^2","v":{"v":0,"d":"0.00"}},{"$f":"Inputs!C31^2","v":{"v":0,"d":"0.00"}}]
[{"$f":"\"   \"&Labels!C31","v":"   Total"},{"$f":"SUM(B20:B23)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C20:C23)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Formulas","index":5,"n_rows":38,"n_cols":5,"rows_kept":38,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5]]}
[{"$f":"\"Project: \"&Inputs!B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&Inputs!B8","v":"Organization:  "}]
[{"$f":"\"Formulas\"","v":"Formulas"}]
[{"$f":"\" \"","v":" "}]
["Variable","Display As","Dimension Index",null,"Formula / Data"]
["Alternatives_plt",{"$f":"Labels!B8","v":"Alternatives_plt"},"Alternatives","Data:","diminfo(\"Alternatives\", 7, \", \")"]
[]
["Organization_Name",{"$f":"Labels!B9","v":"Organization Name"}]
[]
["Project_Name",{"$f":"Labels!B10","v":"Project Name"}]
[]
["Ratings",{"$f":"Labels!B11","v":"Ratings (>=0)"},"Alternatives, Criteria","Roll-up:","Ratings_Norm_Wtd"]
[]
["Ratings_Norm_Wtd",{"$f":"Labels!B12","v":"Ratings Norm Wtd"},"Criteria, Alternatives","Data:","Ratings*Weights_Normed"]
[]
["Risk_AnalysisQ",{"$f":"Labels!B13","v":"Risk Analysis?"},"Error_Bars","Data:","hasfeature(\"Risk Analysis\")"]
[]
["Risk_Aversion",{"$f":"Labels!B14","v":"Risk Aversion"}]
[]
["Scores",{"$f":"Labels!B15","v":"Scores"},"Alternatives","Data:","Ratings"]
[]
["Scores_Hi",{"$f":"Labels!B16","v":"Scores Hi"},"Alternatives","Data:","Scores+Std_Dev_Ratings[\"Criteria\"]"]
[]
["Scores_Lo",{"$f":"Labels!B17","v":"Scores Lo"},"Alternatives","Data:","Scores-Std_Dev_Ratings[\"Criteria\"]"]
[]
["Scores_Risk_Adjusted",{"$f":"Labels!B18","v":"Risk Adjusted Scores"},"Alternatives","Data:","Ratings-Risk_Aversion*Variance_Ratings[\"Criteria\"]"]
[]
["Scores_Risk_Adjusted_Hi",{"$f":"Labels!B19","v":"Risk Adjusted Scores Hi"},"Alternatives","Data:","Scores_Risk_Adjusted+Std_Dev_Ratings[\"Criteria\"]"]
[]
["Scores_Risk_Adjusted_Lo",{"$f":"Labels!B20","v":"Risk Adjusted Scores Lo"},"Alternatives","Data:","Scores_Risk_Adjusted-Std_Dev_Ratings[\"Criteria\"]"]
[]
["Std_Dev_Ratings",{"$f":"Labels!B21","v":"Uncertainty in Ratings"},"Alternatives, Criteria","Roll-up:","sqrt(Variance_Ratings)"]
[]
["Variance_Ratings",{"$f":"Labels!B22","v":"Variance of Ratings"},"Criteria, Alternatives","Data:","Std_Dev_Ratings^2"]
[]
["Weights",{"$f":"Labels!B23","v":"Weights (>=0)"}]
[]
["Weights_Normed",{"$f":"Labels!B24","v":"Normalized Weights"},"Criteria","Roll-up:","Weights/Weights[\"Criteria\"]"]

{"sheet":"Plot Vars","index":6,"n_rows":31,"n_cols":2,"rows_kept":31,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[5,0,5,5]]}
[{"$f":"\"Project: \"&Inputs!B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&Inputs!B8","v":"Organization:  "}]
[{"$f":"\"Plot Vars\"","v":"Plot Vars"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"\"Plot Support\"","v":"Plot Support"}]
[{"$f":"\"\"","v":""}]
[{"$f":"Labels!B8","v":"Alternatives_plt"}]
[{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Labels!B28","v":"Alternative 1"}]
[{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Labels!B29","v":"Alternative 2"}]
[]
[{"$f":"Labels!B17","v":"Scores Lo"}]
[{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Results!B6-Inputs!B32","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Results!B7-Inputs!C32","v":{"v":3,"d":"3.00"}}]
[]
[{"$f":"Labels!B16","v":"Scores Hi"}]
[{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Results!B6+Inputs!B32","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Results!B7+Inputs!C32","v":{"v":3,"d":"3.00"}}]
[]
[{"$f":"Labels!B20","v":"Risk Adjusted Scores Lo"}]
[{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Results!E6-Inputs!B32","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Results!E7-Inputs!C32","v":{"v":3,"d":"3.00"}}]
[]
[{"$f":"Labels!B19","v":"Risk Adjusted Scores Hi"}]
[{"$f":"\"   \"&Labels!B28","v":"   Alternative 1"},{"$f":"Results!E6+Inputs!B32","v":{"v":3,"d":"3.00"}}]
[{"$f":"\"   \"&Labels!B29","v":"   Alternative 2"},{"$f":"Results!E7+Inputs!C32","v":{"v":3,"d":"3.00"}}]
[]
[{"$f":"Labels!B13","v":"Risk Analysis?"}]
[{"$f":"\"   \"&Labels!B38","v":"   Low"},{"$f":"TRUE","v":true}]
[{"$f":"\"   \"&Labels!B39","v":"   Mid"},{"$f":"TRUE","v":true}]
[{"$f":"\"   \"&Labels!B40","v":"   Hi"},{"$f":"TRUE","v":true}]
[{"$f":"\"   \"&Labels!C37","v":"   Total"},{"$f":"OR(B28,B29,B30)","v":true}]

{"sheet":"(Other Variables)","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5]]}
[{"$f":"\"Project: \"&Inputs!B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&Inputs!B8","v":"Organization:  "}]
[{"$f":"\"(Other Variables)\"","v":"(Other Variables)"}]
[{"$f":"\" \"","v":" "}]
[{"$f":"Labels!B24","v":"Normalized Weights"}]
[{"$f":"Labels!D32","v":"Criteria"}]
[{"$f":"Labels!B32","v":"Initial Cost"},{"$f":"Calculations!B6","v":0.25}]
[{"$f":"Labels!B33","v":"Ongoing Expense"},{"$f":"Calculations!B7","v":0.25}]
[{"$f":"Labels!B34","v":"Functionality"},{"$f":"Calculations!B8","v":0.25}]
[{"$f":"Labels!B35","v":"Ease of Use"},{"$f":"Calculations!B9","v":0.25}]

{"sheet":"Labels","index":8,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5]]}
[{"$f":"\"Project: \"&Inputs!B9","v":"Project:  "}]
[{"$f":"\"Organization: \"&Inputs!B8","v":"Organization:  "}]
[{"$f":"\"Labels\"","v":"Labels"}]
[{"$f":"\" \"","v":" "}]
["Model Start","2008-01-01"]
[]
["Variable","Display Label",null,null,"Comment"]
["Alternatives_plt","Alternatives_plt"]
["Organization_Name","Organization Name",null,null,"The name of the company or organization for which the decision analysis is performed"]
["Project_Name","Project Name",null,null,"A label to denote the decision project. This name appears at the top of every worksheet."]
["Ratings","Ratings (>=0)",null,null,"Your ratings of the desireability of each decision alternative on each evaluation criterion"]
["Ratings_Norm_Wtd","Ratings Norm Wtd",null,null,"Normalized version of your ratings of the alternatives, with the sum of weights for the evaluaton criteria summing to 1"]
["Risk_AnalysisQ","Risk Analysis?"]
["Risk_Aversion","Risk Aversion",null,null,"A number that reflects how risk averse you are. We recommend a number between 0 and 1. \n\n* a number near 0 means you don't care much about risk; that is, you care mostly about the average (expected) return in an uncertain situation, regardless of the distribution of outcomes.\n\n* 1 means you prefer a somewhat lower more certain expected return to a higher expected return with more uncertainty."]
["Scores","Scores",null,null,"Final score for each decision alternative, based on your ratings of each alternative on each evaluation criterion, with no adjustment for risk"]
["Scores_Hi","Scores Hi",null,null,"Upper error limit for final score for each decision alternative"]
["Scores_Lo","Scores Lo",null,null,"Lower error limit for final score for each decision alternative"]
["Scores_Risk_Adjusted","Risk Adjusted Scores",null,null,"Final score for each decision alternative, including adjustment for risk"]
["Scores_Risk_Adjusted_Hi","Risk Adjusted Scores Hi",null,null,"Upper error limit for final score for each decision alternative, including adjustment for risk"]
["Scores_Risk_Adjusted_Lo","Risk Adjusted Scores Lo",null,null,"Lower error limit for final score for each decision alternative, including adjustment for risk"]
["Std_Dev_Ratings","Uncertainty in Ratings",null,null,"Your estimate of how uncertain or inaccurate are your ratings of alternatives on each evaluation criterion. This is used to adjust scores and ranking of decision alternatives if you elect to include risk analysis in the model."]
["Variance_Ratings","Variance of Ratings",null,null,"The variance of your ratings, as computed from your input for the standard deviation of your ratings of each alternative for each evaluation criterion"]
["Weights","Weights (>=0)",null,null,"Weights that you assign to each evaluation criterion, to indicate how important it is in evaluating decision alternatives"]
["Weights_Normed","Normalized Weights",null,null,"The weights you assigned to each evaluation criterion, but normalized so the sum of all the weights is 1"]
[]
["Dimension (item)","Display Item As","Total As","Level As","Comment"]
["Alternatives","Alternatives","Total","Alternatives","A list of the decision alternatives"]
["  Alternative_1","Alternative 1",null,"Alternatives"]
["  Alternative_2","Alternative 2"]
[]
["Criteria","Criteria","Total","Criteria","A list of the decision criteria"]
["  Initial_Cost","Initial Cost",null,"Criteria"]
["  Ongoing_Expense","Ongoing Expense"]
["  Functionality","Functionality"]
["  Ease_of_Use","Ease of Use"]
[]
["Error_Bars","Error Bars","Total","Error_Bars"]
["  Low","Low",null,"Error_Bars"]
["  Mid","Mid"]
["  Hi","Hi"]

{"sheet":"(Ranges)","index":9,"n_rows":9,"n_cols":1,"rows_kept":9,"hidden":true}
["Inputs!Std_Dev_Ratings"]
["Results!Scores"]
["Results!Scores_Risk_Adjusted"]
["Plot Vars'!Alternatives_plt"]
["Plot Vars'!Scores_Lo"]
["Plot Vars'!Scores_Hi"]
["Plot Vars'!Scores_Risk_Adjusted_Lo"]
["Plot Vars'!Scores_Risk_Adjusted_Hi"]
["Plot Vars'!Risk_AnalysisQ"]

{"sheet":"(Import)","index":10,"n_rows":4,"n_cols":64,"rows_kept":4,"hidden":true}
[":A:0:Weights",{"$f":"Labels!B23","v":"Weights (>=0)"},":A:-1:Weights",{"$f":"Labels!E23","v":"Weights that you assign to each evaluation criterion, to indicate how important it is in evaluating decision alternatives"},":A:0:Ratings",{"$f":"Labels!B11","v":"Ratings (>=0)"},":A:-1:Ratings",{"$f":"Labels!E11","v":"Your ratings of the desireability of each decision alternative on each evaluation criterion"},":A:0:Weights_Normed",{"$f":"Labels!B24","v":"Normalized Weights"},":A:-1:Weights_Normed",{"$f":"Labels!E24","v":"The weights you assigned to each evaluation criterion, but normalized so the sum of all the weights is 1"},":A:0:Ratings_Norm_Wtd",{"$f":"Labels!B12","v":"Ratings Norm Wtd"},":A:-1:Ratings_Norm_Wtd",{"$f":"Labels!E12","v":"Normalized version of your ratings of the alternatives, with the sum of weights for the evaluaton criteria summing to 1"},":A:0:Risk_Aversion",{"$f":"Labels!B14","v":"Risk Aversion"},":A:-1:Risk_Aversion",{"$f":"Labels!E14","v":"A number that reflects how risk averse you are. We recommend a number between 0 and 1. \n\n* a number near 0 means you don't care much about risk; that is, you care mostly about the average (expected) return in an uncertain situation, regardless of the distribution of outcomes.\n\n* 1 means you prefer a somewhat lower more certain expected return to a higher expected return with more uncertainty."},":A:0:Std_Dev_Ratings",{"$f":"Labels!B21","v":"Uncertainty in Ratings"},":A:-1:Std_Dev_Ratings",{"$f":"Labels!E21","v":"Your estimate of how uncertain or inaccurate are your ratings of alternatives on each evaluation criterion. This is used to adjust scores and ranking of decision alternatives if you elect to include risk analysis in the model."},":A:0:Variance_Ratings",{"$f":"Labels!B22","v":"Variance of Ratings"},":A:-1:Variance_Ratings",{"$f":"Labels!E22","v":"The variance of your ratings, as computed from your input for the standard deviation of your ratings of each alternative for each evaluation criterion"},":A:0:Scores_Risk_Adjusted",{"$f":"Labels!B18","v":"Risk Adjusted Scores"},":A:-1:Scores_Risk_Adjusted",{"$f":"Labels!E18","v":"Final score for each decision alternative, including adjustment for risk"},":A:0:Scores",{"$f":"Labels!B15","v":"Scores"},":A:-1:Scores",{"$f":"Labels!E15","v":"Final score for each decision alternative, based on your ratings of each alternative on each evaluation criterion, with no adjustment for risk"},":A:0:Project_Name",{"$f":"Labels!B10","v":"Project Name"},":A:-1:Project_Name",{"$f":"Labels!E10","v":"A label to denote the decision project. This name appears at the top of every worksheet."},":A:0:Organization_Name",{"$f":"Labels!B9","v":"Organization Name"},":A:-1:Organization_Name",{"$f":"Labels!E9","v":"The name of the company or organization for which the decision analysis is performed"},":A:0:Alternatives_plt",{"$f":"Labels!B8","v":"Alternatives_plt"},":A:-1:Alternatives_plt",{"$f":"Labels!E8","v":0},":A:0:Scores_Risk_Adjusted_Lo",{"$f":"Labels!B20","v":"Risk Adjusted Scores Lo"},":A:-1:Scores_Risk_Adjusted_Lo",{"$f":"Labels!E20","v":"Lower error limit for final score for each decision alternative, including adjustment for risk"},":A:0:Scores_Risk_Adjusted_Hi",{"$f":"Labels!B19","v":"Risk Adjusted Scores Hi"},":A:-1:Scores_Risk_Adjusted_Hi",{"$f":"Labels!E19","v":"Upper error limit for final score for each decision alternative, including adjustment for risk"},":A:0:Scores_Lo",{"$f":"Labels!B17","v":"Scores Lo"},":A:-1:Scores_Lo",{"$f":"Labels!E17","v":"Lower error limit for final score for each decision alternative"},":A:0:Scores_Hi",{"$f":"Labels!B16","v":"Scores Hi"},":A:-1:Scores_Hi",{"$f":"Labels!E16","v":"Upper error limit for final score for each decision alternative"}]
[":A:0:Risk_AnalysisQ",{"$f":"Labels!B13","v":"Risk Analysis?"},":A:-1:Risk_AnalysisQ",{"$f":"Labels!E13","v":0},":D:-1:Criteria",{"$f":"Labels!E31","v":"A list of the decision criteria"},":D:0:Criteria",{"$f":"Labels!B31","v":"Criteria"},":D:2:Criteria",{"$f":"Labels!D31","v":"Criteria"},":D:1:Criteria",{"$f":"Labels!C31","v":"Total"},":D:0:Criteria.Initial_Cost",{"$f":"Labels!B32","v":"Initial Cost"},":D:2:Criteria.Initial_Cost",{"$f":"Labels!D32","v":"Criteria"},":D:0:Criteria.Ongoing_Expense",{"$f":"Labels!B33","v":"Ongoing Expense"},":D:0:Criteria.Functionality",{"$f":"Labels!B34","v":"Functionality"},":D:0:Criteria.Ease_of_Use",{"$f":"Labels!B35","v":"Ease of Use"},":D:-1:Alternatives",{"$f":"Labels!E27","v":"A list of the decision alternatives"},":D:0:Alternatives",{"$f":"Labels!B27","v":"Alternatives"},":D:2:Alternatives",{"$f":"Labels!D27","v":"Alternatives"},":D:1:Alternatives",{"$f":"Labels!C27","v":"Total"},":D:0:Alternatives.Alternative_1",{"$f":"Labels!B28","v":"Alternative 1"},":D:2:Alternatives.Alternative_1",{"$f":"Labels!D28","v":"Alternatives"},":D:0:Alternatives.Alternative_2",{"$f":"Labels!B29","v":"Alternative 2"},":D:-1:Error_Bars",{"$f":"Labels!E37","v":0},":D:0:Error_Bars",{"$f":"Labels!B37","v":"Error Bars"},":D:2:Error_Bars",{"$f":"Labels!D37","v":"Error_Bars"},":D:1:Error_Bars",{"$f":"Labels!C37","v":"Total"},":D:0:Error_Bars.Low",{"$f":"Labels!B38","v":"Low"},":D:2:Error_Bars.Low",{"$f":"Labels!D38","v":"Error_Bars"},":D:0:Error_Bars.Mid",{"$f":"Labels!B39","v":"Mid"},":D:0:Error_Bars.Hi",{"$f":"Labels!B40","v":"Hi"},":SD:0:1/1/2008",{"$f":"Labels!B5","v":39448}]
[":WS:Output Advanced",{"$f":"Graphs!A1","v":" "},":WS:",{"$f":"Inputs!A1","v":"Project:  "},":WS:",{"$f":"Results!A1","v":"Project:  "},":WS:",{"$f":"Calculations!A1","v":"Project:  "},":WS:",{"$f":"Formulas!A1","v":"Project:  "},":WS:",{"$f":"'Plot Vars'!A1","v":"Project:  "},":WS:",{"$f":"'(Other Variables)'!A1","v":"Project:  "},":WS:",{"$f":"Labels!A1","v":"Project:  "},":WS:",{"$f":"'(Ranges)'!A1","v":"Inputs!Std_Dev_Ratings"},":WS:",{"$f":"'(Import)'!A1","v":":A:0:Weights"}]
["Organization_Name[]|",{"$f":"Inputs!B8","v":" "},"Project_Name[]|",{"$f":"Inputs!B9","v":" "},"Weights[\"Criteria.Initial_Cost\"]|=2",{"$f":"Inputs!B12","v":2},"Weights[\"Criteria.Ongoing_Expense\"]|=2",{"$f":"Inputs!B13","v":2},"Weights[\"Criteria.Functionality\"]|=2",{"$f":"Inputs!B14","v":2},"Weights[\"Criteria.Ease_of_Use\"]|=2",{"$f":"Inputs!B15","v":2},"Ratings[\"Criteria.Initial_Cost\", \"Alternatives.Alternative_1\"]|=3",{"$f":"Inputs!B20","v":3},"Ratings[\"Criteria.Initial_Cost\", \"Alternatives.Alternative_2\"]|=3",{"$f":"Inputs!C20","v":3},"Ratings[\"Criteria.Ongoing_Expense\", \"Alternatives.Alternative_1\"]|=3",{"$f":"Inputs!B21","v":3},"Ratings[\"Criteria.Ongoing_Expense\", \"Alternatives.Alternative_2\"]|=3",{"$f":"Inputs!C21","v":3},"Ratings[\"Criteria.Functionality\", \"Alternatives.Alternative_1\"]|=3",{"$f":"Inputs!B22","v":3},"Ratings[\"Criteria.Functionality\", \"Alternatives.Alternative_2\"]|=3",{"$f":"Inputs!C22","v":3},"Ratings[\"Criteria.Ease_of_Use\", \"Alternatives.Alternative_1\"]|=3",{"$f":"Inputs!B23","v":3},"Ratings[\"Criteria.Ease_of_Use\", \"Alternatives.Alternative_2\"]|=3",{"$f":"Inputs!C23","v":3},"Std_Dev_Ratings[\"Criteria.Initial_Cost\", \"Alternatives.Alternative_1\"]|=0",{"$f":"Inputs!B28","v":0},"Std_Dev_Ratings[\"Criteria.Initial_Cost\", \"Alternatives.Alternative_2\"]|=0",{"$f":"Inputs!C28","v":0},"Std_Dev_Ratings[\"Criteria.Ongoing_Expense\", \"Alternatives.Alternative_1\"]|=0",{"$f":"Inputs!B29","v":0},"Std_Dev_Ratings[\"Criteria.Ongoing_Expense\", \"Alternatives.Alternative_2\"]|=0",{"$f":"Inputs!C29","v":0},"Std_Dev_Ratings[\"Criteria.Functionality\", \"Alternatives.Alternative_1\"]|=0",{"$f":"Inputs!B30","v":0},"Std_Dev_Ratings[\"Criteria.Functionality\", \"Alternatives.Alternative_2\"]|=0",{"$f":"Inputs!C30","v":0},"Std_Dev_Ratings[\"Criteria.Ease_of_Use\", \"Alternatives.Alternative_1\"]|=0",{"$f":"Inputs!B31","v":0},"Std_Dev_Ratings[\"Criteria.Ease_of_Use\", \"Alternatives.Alternative_2\"]|=0",{"$f":"Inputs!C31","v":0},"Risk_Aversion[]|",{"$f":"Inputs!B34","v":0}]