{"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":5,"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":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Raw Data"]
[null,null,null,null,"Oil",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,null,null,"Gas",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,null,null,"Bananas",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,null,null,"Logs",100,128.61585940120096,175.74511645765486,160.73677992885263,173.45598045138891,187.65015077901143,205.82477650068725,128.29390887101141,179.10819722662168,128.54818797574887,143.92763278835321,105.28297746588129]
[]
["Graph Data"]
[null,null,null,"Last Historic Year",null,7]
[]
[null,null,null,null,"Switch",{"$f":"F12<=$F$8","v":true},true,true,true,true,true,true,false,false,false,false,false]
[null,null,null,null,null,{"$f":"IF(F10,\"History\",\"Forecast\")","v":"History"},{"$f":"IF(G10,\"History\",\"Forecast\")","v":"History"},"History","History","History","History","History","Forecast","Forecast","Forecast","Forecast","Forecast"]
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,null,"Max",{"$f":"ROUNDUP(max_na(F16:Q20),-2)","v":200}]
[null,null,null,null,"History",{"$f":"IF(F10,Max)","v":200},200,200,200,200,200,200,false,false,false,false,false]
[null,null,null,null,"Forecast",{"$f":"IF(NOT(F10),Max)","v":false},false,false,false,false,false,false,200,200,200,200,200]
["Index from with Match from List Box"]
[null,null,null,{"$f":"C23","v":1},{"$f":"INDEX(E2:E5,$D16)","v":"Oil"},{"$f":"INDEX(F2:F5,$D16)","v":100},{"$f":"INDEX(G2:G5,$D16)","v":126.02066300499479},{"$f":"INDEX(H2:H5,$D16)","v":83.986977828162011},{"$f":"INDEX(I2:I5,$D16)","v":49.48834670691442},{"$f":"INDEX(J2:J5,$D16)","v":42.216111974316767},{"$f":"INDEX(K2:K5,$D16)","v":42.208787066608259},{"$f":"INDEX(L2:L5,$D16)","v":54.775466066340783},{"$f":"INDEX(M2:M5,$D16)","v":45.000950479432852},{"$f":"INDEX(N2:N5,$D16)","v":59.410205197467285},{"$f":"INDEX(O2:O5,$D16)","v":54.205582596376928},{"$f":"INDEX(P2:P5,$D16)","v":74.039303600019011},{"$f":"INDEX(Q2:Q5,$D16)","v":87.299858186215246}]
[null,null,null,{"$f":"C24","v":{"$error":"#N/A"}},{"$f":"INDEX(E2:E5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(F2:F5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(G2:G5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(H2:H5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:I5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(J2:J5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(K2:K5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(L2:L5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(M2:M5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(N2:N5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(O2:O5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(P2:P5,$D17)","v":{"$error":"#N/A"}},{"$f":"INDEX(Q2:Q5,$D17)","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$f":"INDEX(E2:E5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(F2:F5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(G2:G5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(H2:H5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:I5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(J2:J5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(K2:K5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(L2:L5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(M2:M5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(N2:N5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(O2:O5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(P2:P5,$D18)","v":{"$error":"#N/A"}},{"$f":"INDEX(Q2:Q5,$D18)","v":{"$error":"#N/A"}}]
[null,null,null,{"$error":"#N/A"},{"$f":"INDEX(E2:E5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(F2:F5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(G2:G5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(H2:H5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(I2:I5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(J2:J5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(K2:K5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(L2:L5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(M2:M5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(N2:N5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(O2:O5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(P2:P5,$D19)","v":{"$error":"#N/A"}},{"$f":"INDEX(Q2:Q5,$D19)","v":{"$error":"#N/A"}}]
["Range and Match"]
[]
[null,"list out 2","Match"]
[null,"Oil",{"$f":"MATCH(B23,$E$2:$E$5,0)","v":1}]
[null,null,{"$f":"MATCH(B24,$E$2:$E$5,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"MATCH(B25,$E$2:$E$5,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"MATCH(B26,$E$2:$E$5,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"MATCH(B27,$E$2:$E$5,0)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"MATCH(B28,$E$2:$E$5,0)","v":{"$error":"#N/A"}}]

{"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"}]