{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["AutoFilter","Definitions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"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":"AutoFilter","index":0,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["FROM:","Mathscinotes"]
["SUBJECT:","List of Components"]
["DATE:","2012-05-23"]
[]
["This is a simplified version of a spreadsheet that I use for demonstrating how to "]
["features affect the cost of a product. While this example is very simple, the macro "]
["and overall approach have worked for MUCH larger spreadsheets."]
[]
[null,"Radio Buttons","Scenario List",null,"Scenario Selected"]
[null,null,"Scenario 1",null,1]
[null,null,"Scenario 2"]
[null,null,"Scenario 3"]
[null,null,"Scenario 4"]
[null,null,"Scenario 5"]
[]
["Subsystem ","Part Number","Cost ","Quantity ","Extended Cost"]
["Option 1","Part 1",0.9139306450453073,8,7.3114451603624584]
["Option 1","Part 2",6.3889787320763558E-2,9,0.57500808588687202]
["Option 1","Part 3",0.97216451452883901,3,2.9164935435865171]
["Option 2","Part 4",0.35691979590905898,9,3.2122781631815309]
["Option 2","Part 5",0.27704010171681948,10,2.7704010171681945]
["Option 2","Part 6",0.40249316259381862,5,2.0124658129690931]
["Option 2","Part 7",0.62797601478239562,1,0.62797601478239562]
["Option 3","Part 8",0.71416204002812744,8,5.7132963202250195]
["Option 3","Part 9",0.15737665608056772,6,0.94425993648340634]
["Option 3","Part 10",0.98629858615257915,1,0.98629858615257915]
["Option 3","Part 11",0.25742349505172502,5,1.2871174752586252]
["Option 4","Part 12",0.37887457636797961,4,1.5154983054719184]
["Option 4","Part 13",0.55144545686508861,5,2.7572272843254431]
["Option 4","Part 14",0.50586879331315726,10,5.0586879331315728]
["Option 4","Part 15",0.39853310672511388,1,0.39853310672511388]
[null,null,null,null,38.086986745710732]

{"sheet":"Definitions","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["FROM:","Mathscinotes"]
["SUBJECT:","Scenario List",null,null,null,null,null,"Selected Scenario",null,{"$f":"AutoFilter!E10","v":1},"Count",{"$f":"ROWS(_Reserved)-COUNTBLANK(_Reserved)","v":1}]
["DATE:","2012-05-23",null,null,null,null,null,{"$f":"IF(INDEX(_Scenario,,J2)=0,\"\",INDEX(_Scenario,,J2))","v":"Option 1"}]
[null,null,null,null,null,null,null,""]
[{"$f":"IFERROR(INDEX(_ScenarioList,COLUMNS($A$5:A5),1),\"\")","v":"Scenario 1"},{"$f":"IFERROR(INDEX(_ScenarioList,COLUMNS($A$5:B5),1),\"\")","v":"Scenario 2"},{"$f":"IFERROR(INDEX(_ScenarioList,COLUMNS($A$5:C5),1),\"\")","v":"Scenario 3"},{"$f":"IFERROR(INDEX(_ScenarioList,COLUMNS($A$5:D5),1),\"\")","v":"Scenario 4"},"Scenario 5",{"$f":"IFERROR(INDEX(_ScenarioList,COLUMNS($A$5:F5),1),\"\")","v":""},{"$f":"IFERROR(INDEX(_ScenarioList,COLUMNS($A$5:G5),1),\"\")","v":""},""]
["Option 1","Option 1","Option 1","Option 1","Option 1",null,null,""]
[null,"Option 2","Option 2","Option 2","Option 4",null,null,""]
[null,"Option 3","Option 3",null,null,null,null,""]
[null,"Option 4",null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]