{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Chart5","Keys for List Box","Sample Data","List Box Working","Chart2","Chart3"],"not_rendered":{"charts":6,"images":4,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Chart5","index":0,"reason":"not_a_worksheet"},{"sheet":"Chart2","index":4,"reason":"not_a_worksheet"},{"sheet":"Chart3","index":5,"reason":"not_a_worksheet"}],"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":"Keys for List Box","index":1,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Single Link cell is easy -- just like combo box"]
[]
[]
[null,null,"For Multi- Link"]
[]
[null,null,"1. Make Macro"]
[null,null,"2. Find Name of List Box"]
[null,null,"3. Use Selection"]
[null,null,"4. Use variable (object) ListCount to make look"]
[null,null,"5. Use variable (object) Selected() to test"]
[null,null,"6. Use variable (object) list() to find numbers"]
[null,null,"7. Make some kind of output variable"]
[]
[null,null,"To Finish"]
[]
[null,null,"1. Create Range Name for Output"]
[null,null,"2. Clear out the Range name with Range().count loop"]
[null,null,"3. Create Counter Variable"]
[null,null,"4. Modify Cells to Range().cells"]
[null,null,"5. Copy to the Graph and Modify the Listbox Name in Title and Range"]

{"sheet":"Sample Data","index":2,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,"Graph Data"]
[null,null,"Last Historic Year",null,7]
[]
[null,null,null,"Switch",{"$f":"E6<=$E$2","v":true},true,true,true,true,true,true,false,false,false,false,false]
[null,null,null,null,{"$f":"IF(E4,\"History\",\"Forecast\")","v":"History"},{"$f":"IF(F4,\"History\",\"Forecast\")","v":"History"},"History","History","History","History","History","Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12]
["Max",{"$f":"ROUNDUP(max_na(E9:P13),-2)","v":200},null,"History",{"$f":"IF(E4,Max)","v":200},200,200,200,200,200,200,false,false,false,false,false]
[null,null,null,"Forecast",{"$f":"IF(NOT(E4),Max)","v":false},false,false,false,false,false,false,200,200,200,200,200]
[null,null,{"$f":"B15","v":1},{"$f":"INDEX(D23:D26,$C9)","v":"Oil"},{"$f":"INDEX(E23:E26,$C9)","v":100},126.02066300499479,83.986977828162011,49.48834670691442,42.216111974316767,42.208787066608259,54.775466066340783,45.000950479432852,59.410205197467285,54.205582596376928,74.039303600019011,87.299858186215246]
[null,null,{"$f":"B16","v":2},{"$f":"INDEX(D23:D26,$C10)","v":"Gas"},{"$f":"INDEX(E23:E26,$C10)","v":100},144.53571446548713,86.006220557833359,124.55951754134983,160.23760629498199,195.04558827874271,115.68371969971686,88.667366894031829,72.255814756908038,42.583395839370787,47.786558805431092,71.182783133121092]
[null,null,3,{"$f":"INDEX(D23:D26,$C11)","v":"Bananas"},{"$f":"INDEX(E23:E26,$C11)","v":100},98.417332936177218,84.501010386766652,51.018553776966115,55.181679833777395,69.596098538501437,40.920392744730435,30.460831187951694,19.93647205077475,22.203389357801839,29.484039745079468,38.803699157043219]
[null,null,{"$error":"#N/A"},{"$f":"INDEX(D23:D26,$C12)","v":{"$error":"#N/A"}},{"$f":"INDEX(E23:E26,$C12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
["Oil",{"$f":"MATCH(A15,$D$23:$D$26,0)","v":1}]
["Gas",{"$f":"MATCH(A16,$D$23:$D$26,0)","v":2}]
["Bananas",{"$f":"MATCH(A17,$D$23:$D$26,0)","v":3}]
[null,{"$f":"MATCH(A18,$D$23:$D$26,0)","v":{"$error":"#N/A"}}]
[null,{"$error":"#N/A"}]
[null,{"$error":"#N/A"}]
[null,null,null,"Raw Data"]
[]
[null,null,null,"Oil",100,{"$f":"E23*(RAND()+0.5)","v":126.02066300499479},{"$f":"F23*(RAND()+0.5)","v":83.986977828162011},49.48834670691442,42.216111974316767,42.208787066608259,54.775466066340783,45.000950479432852,59.410205197467285,54.205582596376928,74.039303600019011,87.299858186215246]
[null,null,null,"Gas",100,{"$f":"E24*(RAND()+0.5)","v":144.53571446548713},86.006220557833359,124.55951754134983,160.23760629498199,195.04558827874271,115.68371969971686,88.667366894031829,72.255814756908038,42.583395839370787,47.786558805431092,71.182783133121092]
[null,null,null,"Bananas",100,{"$f":"E25*(RAND()+0.5)","v":98.417332936177218},84.501010386766652,51.018553776966115,55.181679833777395,69.596098538501437,40.920392744730435,30.460831187951694,19.93647205077475,22.203389357801839,29.484039745079468,38.803699157043219]
[null,null,null,"Logs",100,{"$f":"E26*(RAND()+0.5)","v":128.61585940120096},175.74511645765486,160.73677992885263,173.45598045138891,187.65015077901143,205.82477650068725,128.29390887101141,179.10819722662168,128.54818797574887,143.92763278835321,105.28297746588129]

{"sheet":"List Box Working","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Harry","Bill",null,null,null,null,null,null,null,null,null,null,"Names are Added Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Frank"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Adam"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bill"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Harry"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,3,null,{"$error":"#N/A"}]