{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["UserDefinedFunction","KeystrokeMacro","Practice"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"UserDefinedFunction","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["User Defined Function"]
[null,"Save file as Macro-Enabled Workbook "]
[null,"Alt+F11  (Opens VBA Editor)"]
[null,"Select THIS workbook (bolded) & Insert|Module"]
[null,"Copy/Paste Getformula (Code below) into module"]
[null,"Close VBA (it's part of the Excel workbook)"]
[null,"Function works in all sheets but only in THIS workbook"]
[]
["VBA Code for the GetFormula user defined function is in cells C9:C16:"]
[null,"Function getformula(r As Range) As String"]
[null,"   Application.Volatile"]
[null,"   If r.HasArray Then"]
[null,"   getformula = \"<-- \" & \" {\" & r.FormulaLocal & \"}\""]
[null,"   Else"]
[null,"   getformula = \"<-- \" & \" \" & r.FormulaLocal"]
[null,"   End If"]
[null,"End Function"]

{"sheet":"KeystrokeMacro","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Keystroke Macros"]
[null,"Always SAVE workbook as .xlsm before recording a macro!"]
[null,"PRACTICE the keystrokes before recording"]
[null,"When ON the Use Relative References Button allows relative movement"]
[null,"When OFF the Use Relative References Button moves to same cells as in recording"]
[null,"Record then debug small pieces of code"]
[null,"Delete nonfunctional macros when finished"]
[null,"Macros can be executed in any open workbook"]
[null,"Changes to book by macro CANNOT be undone!"]
[]
["Example Macro:"]
["Record \"Setup\" macro to enter Getformula User Defined Function."]
[1,"On Developer tab turn ON Use Relative References Button"]
[2,"Developer/Record Macro: shortcut is G & name is Setup"]
[3,"Select (activate) cell to right of active cell"]
[4,"Enter Getformula function"]
[5,"On Developer tab turn OFF Use Relative References Button"]
[6,"Move to cell G1 & enter TODAY function"]
[7,"Resize column to 200 pixels & Reformat"]
[8,"Move to cell A1"]
[9,"Zoom selection A1:G27"]
[10,"Stop recording"]
[11,"SAVE book before executing Setup macro!"]
[12,"Execute macro: {Ctrl}{Shift}g"]

{"sheet":"Practice","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Stock Dividend Valuation Model"]
[null,"r=",0.1]
[null,"LRg=",7.1800000000000003E-2]
[null,null,null," 10-Period Projection"]
[null,null,"End Period","CF","PV(CF)"]
[null,null,0]
[null,null,1,0,{"$f":"D7*(1+$E$33)^-$B7","v":0}]
[null,null,2,0,0]
[null,null,3,0.5,0.5]
[null,null,4,1,1]
[null,null,5,1.5,1.5]
[null,null,6,1.7,1.7]
[null,null,7,1.82,1.82]
[null,null,8,1.95,1.95]
[null,null,9,2.09,2.09]
[null,null,10,2.2400000000000002,2.2400000000000002]
[null,null,"Horizon Value H10-->",{"$f":"D16*(1+$E$34)/(C2-C3)","v":79.432624113475171}]
[null,null,null,"PV(H10) -->",{"$f":"D17*(1+$E$33)^-C16","v":79.432624113475171}]
[null,null,null,"Sum -->",{"$f":"SUM(E6:E16)+E18","v":92.232624113475168}]