{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Welcome","Info","Arrays Workouts"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":39,"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":"Welcome","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,13],[15,6,15,9],[11,6,13,9],[3,2,3,3],[1,0,1,13],[4,0,5,13],[6,0,6,13],[8,6,9,9]]}
[]
["User Defined Functions, Events and Arrays"]
[]
[]
["This document is for training purposes only. Financial Edge accepts no responsibility or liability for any other purpose or usage."]
[]
[{"$f":"\"© \"&YEAR(TODAY())&\" Financial Edge Training\"","v":"© 2024 Financial Edge Training"}]

{"sheet":"Info","index":1,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[16,1,16,2],[3,11,3,15],[3,1,3,8],[12,1,12,11],[17,1,17,2],[17,3,17,11],[4,13,4,16],[5,13,5,16],[6,13,6,16],[7,13,7,16],[8,13,8,16],[9,13,9,16],[12,14,12,16],[14,1,14,2],[15,1,15,2]]}
[{"$f":"Welcome!A2","v":"User Defined Functions, Events and Arrays"}]
["Workout Information"]
[]
[null,"Features",null,null,null,null,null,null,null,null,null,"Model Details"]
[null,"◦","User defined functions",null,null,null,null,null,null,null,null,"Company name",null,"ABC Incorporated"]
[null,"◦","Events",null,null,null,null,null,null,null,null,"Date",null,"2015-12-31"]
[null,"◦","Arrays",null,null,null,null,null,null,null,null,"Currency",null,"USD"]
[null,null,null,null,null,null,null,null,null,null,null,"Units",null,"Millions"]
[null,null,null,null,null,null,null,null,null,null,null,"Analyst Name",null,"Firstname Lastname"]
[null,null,null,null,null,null,null,null,null,null,null,"Circular Switch",null,0]
[]
[]
[null,"Tab Structure",null,null,null,null,null,null,null,null,null,null,null,null,"Formatting"]
[null,"User Defined Function Workouts"]
[null,"Events Workouts",null,null,null,null,null,null,null,null,null,null,null,null,null,"Input"]
[null,"Arrays Workouts",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hard coded"]
[null,"Sceanrio Learning 1",null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas"]
[null,"Sceanrio Learning 2"]

{"sheet":"Arrays Workouts","index":2,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Info!A1","v":"User Defined Functions, Events and Arrays"}]
[{"$f":"Info!B16","v":"Arrays Workouts"}]
[]
[]
[null,"Write VBA code to declare a 2 dimensional array."]
[null,"Dimension 1:  1 to 5"]
[null,"Dimension 2:  1 to 3"]
[]
[null,"Using a For Next loop:"]
[null,null,"Assign the values in range \"Area\" to column 1 of the array."]
[null,null,"Column 2 of the array = Column 1 value * 2"]
[null,null,"Column 3 of the array = Column 2 value / Range(\"B15\").value"]
[null,"Sum column 3 of the array and assign the value to cell B23."]
[]
[null,10]
[]
[null,500]
[null,600]
[null,700]
[null,800]
[null,900]
[]
[null,700,null,null,"See ArraysWorkouts module, Workout5 sub"]