{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["GC","Contents","EVALUATE_SC","Simple_Illustration_BA","Plotting_a_Formula_BA"],"not_rendered":{"charts":1,"images":1,"macros":0,"external_links":0,"defined_names":13,"comments":1,"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":"GC","index":0,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,2,10,5],[23,6,23,8],[24,6,24,8],[25,6,25,8]]}
["GC"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"SumProduct Pty Ltd"]
[null,null,"Evaluating EVALUATE"]
[null,null,"Go to Table of Contents"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Examples of Excel's little-known EVALUATE function."]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]
[null,null,"For past articles visit:",null,null,null,"www.sumproduct.com"]

{"sheet":"Contents","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,5,8,6],[8,7,8,15],[2,1,2,8],[9,5,9,6],[9,7,9,15],[7,1,7,2],[7,3,7,11],[7,12,7,15]]}
["C","Table of Contents"]
[null,{"$f":"Model_Name","v":"Evaluating EVALUATE"}]
[null,"Go to Cover Sheet"]
[]
[]
["é","Section & Sheet Titles"]
[]
[null,1,null,{"$f":"EVALUATE_SC!C9","v":"Simple EVALUATE Examples"}]
[null,null,null,null,null,"a.",null,{"$f":"Simple_Illustration_BA!B1","v":"Simple Illustration"}]
[null,null,null,null,null,"b.",null,{"$f":"Plotting_a_Formula_BA!B1","v":"Plotting a Formula"}]

{"sheet":"EVALUATE_SC","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[11,2,11,5]]}
["SC"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Simple EVALUATE Examples"]
[null,null,"Section 1."]
[null,null,{"$f":"Model_Name","v":"Evaluating EVALUATE"}]
[null,null,"Go to Table of Contents"]
[null,null,"ç","è"]
[]
[]
[]
[null,null,"Section Cover Notes:"]
[null,null,"Ideas for how to use EVALUATE."]

{"sheet":"Simple_Illustration_BA","index":3,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
["BA","Simple Illustration"]
[null,{"$f":"Model_Name","v":"Evaluating EVALUATE"}]
[null,"Go to Table of Contents"]
["é","ç","è"]
[]
[]
[null,"Assumptions"]
[]
[null,null,null,null,null,1,null,3,null,5]
[null,null,null,null,null,"+",null,"*",null,"^"]
[null,null,null,null,null,2,null,7,null,3]
[]
[]
[null,"Calculations"]
[]
[null,null,"Results",null,null,{"$f":"Evaluation","v":3},null,{"$f":"Evaluation","v":21},null,{"$f":"Evaluation","v":125}]

{"sheet":"Plotting_a_Formula_BA","index":4,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
["BA","Plotting a Formula"]
[null,{"$f":"Model_Name","v":"Evaluating EVALUATE"}]
[null,"Go to Table of Contents"]
["é","ç"]
[]
[]
[null,"Assumptions"]
[]
[null,null,null,null,null,"Formula","sin(x)/x"]
[]
[null,null,null,null,null,"xStart",-10]
[null,null,null,null,null,"xEnd",10]
[null,null,null,null,null,"xNumberOfPoints",1000]
[]
[]
[null,null,null,null,null,"Chart Title",{"$f":"\"Charting: \"&G9","v":"Charting: sin(x)/x"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Based on examples created by Stephen Bullen and Jan Karel Pieterse."]