{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Absolute vs. Relative","Edit Macro","Assign A button","Vertical Records","Transpose Records","Monthly Reports","M1","M2","M3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Absolute vs. Relative","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Edit Macro","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Edit Code for FillDaysRelative"]
[null,"Copy subroutine - paste it and edit it so that we can fillnumber series across a column"]

{"sheet":"Assign A button","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Vertical Records","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","Zip","Phone","E1","E2"]
[]
["Alan"]
["Chin"]
["14 St."]
["Seattle"]
["WA"]
[98104]
["206-345-2421"]
["Steve_chin@comcast.com"]
["Chin@hotmail.com"]
[]
["Anna"]
["Steven"]
["213 south St."]
["Seattle"]
["WA"]
[98120]
["206-232-3231"]
["Anna@hotmail.com"]
["Anna_s@yahoo.com"]
[]
["Adam"]
["Tomson"]
["12 Read st."]
["Boston"]
["MA"]
[2784]
["617-232-2323"]
["t_adam@yahoo.com"]
["Adam-Tomson@yahoo.com"]

{"sheet":"Transpose Records","index":4,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["First","Last","Address","City","Zip","Phone","E1","E2"]
[null,null,null,null,null,null,null,null,null,"Common Dilemma"]
["Alan",null,null,null,null,null,null,null,null,"Records listed vertically"]
["Chin",null,null,null,null,null,null,null,null,"Need them listed horizontally"]
["14 St."]
["Seattle"]
["WA"]
[98104]
["206-345-2421",null,null,null,null,null,null,null,null,"Steps:"]
["Steve_chin@comcast.com",null,null,null,null,null,null,null,null,"Click record button"]
["Chin@hotmail.com",null,null,null,null,null,null,null,null,"Name macro: \"rearrangeRecords\""]
[null,null,null,null,null,null,null,null,null,"ctlr shift down then cllr C , go to A2"]
["Anna",null,null,null,null,null,null,null,null,"right click, special paste- transpose"]
["Steven",null,null,null,null,null,null,null,null,"Delete that range of data"]
["213 south St.",null,null,null,null,null,null,null,null,"go to beginning of next record"]
["Seattle",null,null,null,null,null,null,null,null,"stop recording"]
["WA"]
[98120]
["206-232-3231"]
["Anna@hotmail.com",null,null,null,null,null,null,null,null,"Use relative referencing:"]
["Anna_s@yahoo.com",null,null,null,null,null,null,null,null,"When you go to A2."]
[null,null,null,null,null,null,null,null,null,"It is not really A2, it is offset - one row"]
["Adam"]
["Tomson"]
["12 Read st."]
["Boston"]
["MA"]
[2784]
["617-232-2323"]
["t_adam@yahoo.com"]
["Adam-Tomson@yahoo.com"]

{"sheet":"Monthly Reports","index":5,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Need to generate a colum for percent change of asset value on a monthly basis"]
["Report size varies!!"]

{"sheet":"M1","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset",null,null,"Steps:"]
["Audrey Davis",336811,343547,null,null,"click on record marco"]
["Kay Strokes",973876,1149174,null,null,"give it a name \"FormatMonthlyReportAssets"]
["Irene Greene",112982,115242,null,null,"In D1, type \"%change\" ctlr enter ctlr B \"Absolute reference\""]
["Tim Gordon",53374,51773,null,null,"In D2, enter the formula:C2/B2-1. Click Ctlr enter, Ctlr C"]
["Darnell Porter",332859,339002,null,null,"move to cell C2, then ctlr shift down to go the last value in the column"]
["Loren Mason",770999,891282,null,null,"click \"use relative reference\", then click right arrow. Offset function is used: move to adjacent cell one column forward."]
["Marcos Lee",313998,291827,null,null,"(If absolute reference is used then it is interpreted as move to D8)"]
[null,null,null,null,null,"ctlr shift up then ctlr V to paste the formula copied"]
[null,null,null,null,null,"Add formatting like % sign"]
[null,null,null,null,null,"ctlr A, Add borders to my table"]
[null,null,null,null,null,"end recording"]

{"sheet":"M2","index":7,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset"]
["Audrey Davis",336811,343547]
["Kay Strokes",973876,1149174]
["Irene Greene",112982,115242]

{"sheet":"M3","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Client","Begin Asset","End Asset"]
["Audrey Davis",336811,343547]
["Kay Strokes",973876,1149174]
["Irene Greene",112982,115242]
["Tim Gordon",53374,51773]
["Darnell Porter",332859,339002]
["Loren Mason",770999,891282]
["Marcos Lee",313998,291827]
["Kevin Smith",1232343,242343]
["Martha Stewards",445234,2232444]
["Jeremy Lu",324345,432342]
["Tom Smith",234545,190232]