{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIONS","Closing price Instructions","ANALYSIS","Historic Data","Annual Iteration"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":3,"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":"INSTRUCTIONS","index":0,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[16,3,16,12],[17,2,17,11],[18,2,21,11]]}
["INSTRUCTIONS  (Also see the \"Closing price\" tab)"]
[]
["This tool is designed to keep track of the annualized gain/loss for each stock entered.  It will also determine the annualized gain for the entire portfolio.  Determining how well your portfolio is doing compared to the S&P500 and Total Stock Market on a continuing basis is shown as well.  A few sample stocks are shown for illustration.  All data are taken from the Broker's statement except the current index values.  The blue and yellow columns and cells require data to be entered manually.  "]
["NOTE:  There are pop-up instructions in many cells.  Hover the cursor over any cell with a red corner to see them."]
["(Rename the portfolio to identify it.)"]
["Enter the date of the analysis here --  (Use the date on the broker's statement.)  Then click the \"Update Index Data\" icon.\n"]
["Enter the starting value of the portfolio and the date it was started."]
["1.  Sort by company name, ticker, purchase date, etc. by clicking the box.  Sort using the sorting method on the broker statement. (Makes it easier to enter prices.)"]
["2.  Click on each index to get the latest data--year ago end of year and most recent month value.  Type those values in the cells to the right.  (See the \"Closing Price Instructions\" tab."]
["3.  Enter each stock owned on a separate line.  -- Enter the NAME, TICKER SYMBOL, DATE OF PURCHASE, NUMBER OF SHARES, and TOTAL COST/VALUE"]
[]
["4.  Enter the CURRENT PRICE for each stock on a monthly basis (yellow column) from your broker statement."]
["5.  A broker statement may indicate Dividends as a % or dollar value.  Select the method with the radio button, then enter the Dividend."]
["6.  Click \"Annualized S&P500 Growth\" to determine the % growth/loss of the index during the time your portfolio has been in existance.  Enter the result in the yellow cell.  Compare the result with your \"Portfolio Annualized return:\"  The result is an approximation of the comparison.  See the \"PLEASE READ\" note at the bottom right."]
["7.  Enter any deposits or withdrawals during current year.  Delete the values at the beginning of each succeeding year."]
["8.  Enter the CASH VALUE THIS MONTH --taken from broker statement"]
["9.  The Toal Annualized Return will include previous years gains and losses if entered in the yellow cells.  Enter the year the portfolio was started in the first cell (yellow color) and the gain or loss for each year.  (The other dates will be written in the gray cells automatically.)  Use the 1099 tax form received from the broker and total of Interest, Dividends, and  gains and losses, then enter the number in the cell for each year.  OR, use the sum of lines 8a, 9a, and line 13 of the IRS Form 1040. This will provide the annualized return from all previously owned companies rather than being limited to current holdings.",null,null,"PLEASE READ:  If you have maintained a portfolio over a number of years it takes some digging to find the data needed to determine the portfolio growth since the beginning, but isn't it worth it?  If you saved your IRS Form 1040, look on the first page of the 1040 and look for the Capital Gains/Loss figure.  Curently it's line 13."]
["Each column can be sorted by clicking on the arrow at the head of each column.  Each time a company is bought enter the information the the next unused line and sort by name or ticker symbol.  When a company is sold, delete the data on that line, then sort by company name or ticker symbol.",null,"Once companies held in your portfolio are entered, each month (1) change the date on this form to the date on the broker statement, (2) enter the current price for each company, and (3) the cash value that month.  That's it--three steps each month.  You may sort the companies by using the Down Arrow at the top of each column."]
["To delete old data -- select each cell or group of cells and press the Delete key.  If you are asked for a password you are attempting to delete data in a cell containing a formula and therefore should not be deleted.  No password is required for the use of this spreadsheet."]
["DO NOT DELETE ANYTHING IN A WHITE CELL.  THEY CONTAIN FORMULAS.  DOWNLOAD A NEW COPY IF FORMULAS ARE ACCIDENTLY DELETED."]
[]
[]
["RETURN TO PORTFOLIO ANALYSIS PAGE"]

{"sheet":"Closing price Instructions","index":1,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,11]]}
[null,"When on the StockCharts.com site, follow the two steps below.  The example shown is the closing price of 290.31 for August 31 2018.  (Notice where the two gray lines cross.  That's where the cursor is located.)  "]

{"sheet":"ANALYSIS","index":2,"n_rows":80,"n_cols":23,"rows_kept":80,"cut":false,"hidden":false,"merged":[[3,16,4,23],[0,4,0,10],[0,11,0,12],[0,0,8,0],[35,8,35,17],[3,8,3,10],[2,2,2,4],[0,1,0,3],[1,2,1,4],[1,6,3,6],[35,3,35,4],[33,8,33,9],[33,10,33,11],[33,13,33,17],[5,1,5,2],[3,1,3,2],[4,1,4,2],[34,8,34,9],[34,10,34,13],[24,16,25,16],[6,4,6,5],[5,4,5,5],[12,42,12,43],[12,28,12,29],[12,30,12,31],[12,32,12,33],[12,34,12,35],[12,36,12,37],[12,38,12,39],[12,40,12,41],[2,16,2,17],[36,8,36,17],[53,1,53,4],[37,9,37,17],[48,16,50,17],[40,16,47,17],[37,5,37,6],[44,1,44,8],[41,1,41,7],[42,1,42,7],[39,1,39,7],[38,9,38,17],[49,1,49,2],[43,1,43,7],[40,1,40,7],[48,1,48,2]]}
["Enter \"E\" if eqity - \"B\" if bond type of investment","I. Gotbucks",null,null,"CURRENT PORTFOLIO REPORT -- ANNUALIZED",null,null,null,null,null,null,null,null,null,null,null,"version 6.16"]
[null,{"$f":"V13","v":"2017-12-31"},{"$f":"IF(V10=TRUE,\"Calculate return on YTD basis\", \"Calculate return on 12 month basis\")","v":"Calculate return on YTD basis"},null,null,null,{"$f":"V17","v":"Enter Portfolio Value at end of prior year"},null,null,null,null,"Select Dividend",null,null,null,null,null,"Instructions"]
[null,"2018-08-31","<<< Month end date from recent Broker Statement",null,null,null,null,"Current",null,null,null,"Payout Method",null,null,null,null,{"$f":"IF('Historic Data'!E1>0,\"Click the Icon to update Historic sheet\",\"\")","v":""}]
[null,"To protect the spreadsheet, all cells containing ",null,null,null,null,null,"Value/Price","Percent Change",null,null,null,null,null,"Percent","Annualized",{"$f":"IF('Historic Data'!D1>0,\"THERE IS AN ERROR IN THE HISTORIC DATA SHEET.  \nOpen the sheet and delete the data indicated\",\"\")","v":""}]
[null,"formulas cannot be selected .  Cells requiring",null,"DJI",null,"DOW JONES  ETF >>>",24824,25920,{"$f":"H5/G5-1","v":4.4150821785368999E-2},null,{"$f":"IF(V$10=TRUE,\"YTD\",\"12 Mo. Anual\")","v":"YTD"},null,null,null,"of total","Value"]
[null,"data are colored yellow & blue for company data.   ",null,"SPY","S&P 500 ETF >>>",null,264,290,{"$f":"H6/G6-1","v":9.8484848484848397E-2},null,{"$f":"IF(V$10=TRUE,\"YTD\",\"12 Mo. Anual\")","v":"YTD"},null,null,null,"Port-","for each","Cash"]
[null,"Value of portfolio when started:",2000,"BND","Total Bond ETF (BND) >>>",null,80,79,{"$f":"H7/G7-1","v":-1.2499999999999956E-2},null,{"$f":"IF(V$10=TRUE,\"YTD\",\"12 Mo. Anual\")","v":"YTD"},null,"Annualized","Percent",null,null,"Paid In"]
[null,"Date this portfolio was started:","2016-06-30",null,null,{"$f":"V18","v":"VALUE AT END OF PRIOR YEAR >>>"},121000,{"$f":"I34","v":135354.66600000003},{"$f":"IF(ISBLANK(G8),\"\",(H8/G8)-1)","v":0.11863360330578532},null,{"$f":"IF(V$10=TRUE,\"YTD\",\"12 Mo. Anual\")","v":"YTD"},null,"Growth","of Total","folio","Stock","YTD","Date",null,"Avg>>",{"$f":"AVERAGE(I5:I6)","v":7.1317835135108698E-2}]
[null,"Company","Stk Symbol","Purch Date","Shrs Owned","Shr Cost","Total Cost","Current Price","Dividend","Column1","Curr. Value","Gain (Loss)","Rate","Portfolio"]
["E","COGNIZANT","CTSH","2011-07-15",500,40.28,{"$f":"E10*F10","v":20140},61.61,null,{"$f":"IF(I10=0,\"\",IF(T$10=1,\"%\",\"$\"))","v":""},{"$f":"IF(ISBLANK(H10),\"\",H10*(1+U10)*E10)","v":30805},{"$f":"IF(ISBLANK(H10),\"\",K10-G10)","v":10665},{"$f":"IF(ISBLANK(H10),\"\",IF($B$3-D10<180,\"Owned <180 days\",((K10/G10)^((1/(($B$3-D10)/365)))-1)))","v":6.1377385810936547E-2},{"$f":"IF(ISBLANK(H10),\"\",K10/H$8)","v":0.22758727800340472},null,{"$f":"IF(K10>1,(G10*((1+(N$43/1200))^((B$3-D10)/30.4))),\"\")","v":20140},null,null,null,1,{"$f":"IF(T$10=1,I10/100,I10/H10)","v":0},true]
["E","DOW CHEMICAL","DOW","2013-07-12",200,35.65,{"$f":"E11*F11","v":7130},57.94,0.2,{"$f":"IF(I11=0,\"\",IF(T$10=1,\"%\",\"$\"))","v":"%"},11611.175999999999,4481.1759999999995,9.9526827536873697E-2,8.578334491993056E-2,null,{"$f":"IF(I11>1,(G11*((1+(N$43/1200))^((B$3-D11)/30.4))),\"\")","v":""},null,null,null,null,2E-3,{"$f":"IF(V10=FALSE,B3-366,\"bad date\")","v":"bad date"},"Error check"]
["E","GILEAD SCIENCE","GILD","2014-08-15",400,98.41,{"$f":"E12*F12","v":39364},120,1,{"$f":"IF(I12=0,\"\",IF(T$10=1,\"%\",\"$\"))","v":"%"},48480,9116,5.2823433348859528E-2,0.35817014243158779,null,{"$f":"IF(I12>1,(G12*((1+(N$43/1200))^((B$3-D12)/30.4))),\"\")","v":""},null,null,null,null,0.01,{"$f":"IF(ISERROR(V11),\"Enter a correct date\",V11)","v":"bad date"},"12 month analysis"]
["E","QUALCOM","QCOM","2016-03-15",300,74.459999999999994,{"$f":"E13*F13","v":22337.999999999996},78,null,{"$f":"IF(I13=0,\"\",IF(T$10=1,\"%\",\"$\"))","v":""},23400,1062.0000000000036,1.9036623106815531E-2,0.17287915290633568,null,{"$f":"IF(I13>1,(G13*((1+(N$43/1200))^((B$3-D13)/30.4))),\"\")","v":""},null,null,null,null,0,{"$f":"IF(ISERROR(V14),\"Enter a correct date below\",IF(V10=FALSE,V12,V14))","v":"2017-12-31"},"Value for cell B2"]
["B","Vanguard Short Term Index","VBIRX","2015-10-04",999,10.34,10034,10.51,null,{"$f":"IF(I14=0,\"\",IF(T$10=1,\"%\",\"$\"))","v":""},10499.49,465.48999999999978,1.5707572855004903E-2,7.7570210989253943E-2,null,{"$f":"IF(I19>1,(G19*((1+(N$43/1200))^((B$3-D19)/30.4))),\"\")","v":""},null,null,null,null,0,{"$f":"DATE(YEAR(B3)-1,12,31)","v":"2017-12-31"},"YTD date"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(I15=0,\"\",IF(T$10=1,\"%\",\"$\"))","v":""},{"$f":"IF(ISBLANK(H15),\"\",H15*(1+U15)*E15)","v":""},{"$f":"IF(ISBLANK(H15),\"\",K15-G15)","v":""},{"$f":"IF(ISBLANK(H15),\"\",IF($B$3-D15<180,\"Owned <180 days\",((K15/G15)^((1/(($B$3-D15)/365)))-1)))","v":""},{"$f":"IF(ISBLANK(H15),\"\",K15/H$8)","v":""}]
[null,null,null,null,null,null,null,null,null,"","","","",""]
[null,null,null,null,null,null,null,null,null,"","","","","",null,{"$f":"IF(H14>1,(F14*((1+(N$43/1200))^((B$3-C14)/30.4))),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,0,{"$f":"IF(V10=TRUE,\"Enter Portfolio Value at end of prior year\",\"Enter Portfolio Value 12 months ago\")","v":"Enter Portfolio Value at end of prior year"}]
[null,null,null,null,null,null,null,null,null,"","","","","",null,{"$f":"IF(I18>1,(G18*((1+(N$43/1200))^((B$3-D18)/30.4))),\"\")","v":""},null,null,null,null,0,{"$f":"IF(V10= TRUE,\"VALUE AT END OF PRIOR YEAR >>>\",\"PORTFOLIO VALUE 12 MONTHS AGO >>>\")","v":"VALUE AT END OF PRIOR YEAR >>>"}]
[null,null,null,null,null,null,null,null,null,"","","","","",null,{"$f":"IF(#REF!>1,(#REF!*((1+(N$43/1200))^((B$3-#REF!)/30.4))),\"\")","v":{"$error":"#REF!"}},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,{"$f":"IF(I21>1,(G21*((1+(N$43/1200))^((B$3-D21)/30.4))),\"\")","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",{"$f":"SUM(Q9:Q22)","v":0},"Total Paid In ",null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"","Cash Paid Out YTD",null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,"Date",null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",{"$f":"SUM(Q26:Q31)","v":0},"Total Paid Out",null,null,0]
[null,null,null,null,null,null,null,null,null,"","","","","",null,"",null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"SUM(G10:G33)","v":99006},null,{"$f":"SUM(K10:K33)+H35","v":135354.66600000003},null,"Portfolio Anualized return:",null,{"$f":"'Annual Iteration'!C4","v":0.15138781886597652},{"$f":"IF(SUM(L42:L52)>0,\"<<< Annualized return since portfolio inception\",\"\")","v":"<<< Annualized return since portfolio inception"}]
[null,null,null,null,null,null,"Cash value this Month:",10559,{"$f":"I34+H35+H36-H37+H38","v":148413.66600000003},null,"Portfolio Value including Historical Capital gains/losses "]
[null,null,null,null,null,null,"Cash paid in YTD:",{"$f":"Q23","v":0},{"$f":"IF(I8>AVERAGE(I5:I6),\"Great--your portfolio is beating the average of the DOW and S&P 500 YTD\",\"Oops, your pofolio is underperforming the average of the DOW and S&P 500 YTD\")","v":"Great--your portfolio is beating the average of the DOW and S&P 500 YTD"}]
[null,null,"Start Year","Most Recent data","S&P 500 Growth",null,"Cash paid out YTD:",{"$f":"Q32","v":0},{"$f":"IF(ISBLANK(E38),\"\",IF(M34>E38,\"Your portfolio average gain is better than S&P 500--long term\",\"Oops the S&P 500 has done better than your portfolio--long term\"))","v":"Your portfolio average gain is better than S&P 500--long term"}]
[null,null,{"$f":"K42","v":"1905-07-08"},{"$f":"B2","v":"2017-12-31"},8.4000000000000005E-2,"Total Prior year capital returns:",null,{"$f":"SUM(L42:L52)+SUM(N42:N52)","v":2500},{"$f":"IF(B78>1,B79,\"\")","v":0.28463085015510514},{"$f":"IF($B78>1,IF($B79>AVERAGE($I5:$I6),\"Your Equity portion of the portfolio is beating the average of the DOW & S&P 500 YTD\",\"Your Equity portion of the portfolio is NOT beating the average of the DOW and S&P 500 YTD\"),\"\")","v":"Your Equity portion of the portfolio is beating the average of the DOW & S&P 500 YTD"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(C78>0.01,B80,\"\")","v":4.6391269683077496E-2},{"$f":"IF(I39>I7,\"Your Bond portion of the portfolio is beating the Total Bond index YTD\",\"Oops, your bond portforlio is under performing the Total Bond index YTD\")","v":"Your Bond portion of the portfolio is beating the Total Bond index YTD"}]
[null,"This form may be used for any type of investment--mutual funds, portfolio of stocks, etc.",null,null,null,null,null,null,null,null,"Portfolio","Capital Gains","Portfolio","Capital Gains"]
[null,"A comment on the accuracy of the results:  ",null,null,null,null,null,null,null,null,"Earliest YR","+ Int. + Div."," Year","'+ Int. + Div.",null,null,"NOTE: From your IRS form 1040 enter the sum of lines 8a, 9a, and 13. (Sum of Interest + Dividends + Capital Gain/Loss) Enter the sum in the yellow cell next to the appropriate year, beginning with the first year the portfolio was established.  "]
[null,"The attempt here is to provide guideline figures, not absolute results, when comparing portfolio to",null,null,null,null,null,null,null,null,2016,1000,{"$f":"K52+1","v":2027}]
[null,"market averages.  Absolute results require simultaneous \"buying\" and \"selling\" of the market ",null,null,null,null,null,null,null,null,{"$f":"K42+1","v":2017},1500,{"$f":"M42+1","v":2028}]
[null,"indexes.  As guidelines however, the comparison results are sufficiently accurate.  ",null,null,null,null,null,null,null,null,{"$f":"K43+1","v":2018},null,{"$f":"M43+1","v":2029}]
[null,"For absolute gain/loss results I suggest the purchase of Investment Account Manager from www.quantixsoftware.com.  ",null,null,null,null,null,null,null,null,2019,null,2030]
[null,null,null,null,null,null,null,null,null,null,2020,null,2031]
[null,"Updates for this tool are available at:  www.bob-adams.net",null,null,null,null,null,null,null,null,2021,null,2032]
[null,null,null,null,null,null,null,null,null,null,2022,null,2033]
[null,null,null,null,null,null,null,null,null,null,2023,null,2034,null,null,null,null,null,null,null,"paid in"]
[null,null,null,null,null,null,null,null,null,null,2024,null,2035]
[null,null,null,null,null,null,null,null,null,null,2025,null,2036]
[null,null,null,null,null,null,null,null,null,null,2026,null,2037]
[]
[null,"DO NOT ENTER DATA IN THE BOX BELOW"]
[null,"% Equities","% Bonds","Equities","Bonds"]
[null,{"$f":"IF(ISBLANK(A10),K10,IF($A10=\"e\",$K10,\"\"))","v":30805},{"$f":"IF($A10=\"b\",$K10,\"\")","v":""},{"$f":"IF(ISBLANK(A10),G10,IF($A10=\"e\",$G10,\"\"))","v":20140},{"$f":"IF($A10=\"b\",$G10,\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(A11),K11,IF($A11=\"e\",$K11,\"\"))","v":11611.175999999999},{"$f":"IF($A11=\"b\",$K11,\"\")","v":""},{"$f":"IF(ISBLANK(A11),G11,IF($A11=\"e\",$G11,\"\"))","v":7130},{"$f":"IF($A11=\"b\",$G11,\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(A12),K12,IF($A12=\"e\",$K12,\"\"))","v":48480},{"$f":"IF($A12=\"b\",$K12,\"\")","v":""},{"$f":"IF(ISBLANK(A12),G12,IF($A12=\"e\",$G12,\"\"))","v":39364},{"$f":"IF($A12=\"b\",$G12,\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(A13),K13,IF($A13=\"e\",$K13,\"\"))","v":23400},{"$f":"IF($A13=\"b\",$K13,\"\")","v":""},{"$f":"IF(ISBLANK(A13),G13,IF($A13=\"e\",$G13,\"\"))","v":22337.999999999996},{"$f":"IF($A13=\"b\",$G13,\"\")","v":""}]
[null,{"$f":"IF(ISBLANK(A14),K14,IF($A14=\"e\",$K14,\"\"))","v":""},{"$f":"IF($A14=\"b\",$K14,\"\")","v":10499.49},{"$f":"IF(ISBLANK(A14),G14,IF($A14=\"e\",$G14,\"\"))","v":""},{"$f":"IF($A14=\"b\",$G14,\"\")","v":10034}]
[null,{"$f":"IF(ISBLANK(A17),K17,IF($A17=\"e\",$K17,\"\"))","v":""},{"$f":"IF($A18=\"b\",$K17,\"\")","v":""},{"$f":"IF(ISBLANK(A17),G17,IF($A17=\"e\",$G17,\"\"))","v":0},{"$f":"IF($A17=\"b\",$G17,\"\")","v":""}]
[null,"",{"$f":"IF(A14=\"b\",$K18,\"\")","v":""},0,""]
[null,"",{"$f":"IF($A19=\"b\",$K19,\"\")","v":""},0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,"","",0,""]
[null,{"$f":"SUM(B56:B77)","v":114296.17600000001},{"$f":"SUM(C56:C77)","v":10499.49},{"$f":"SUM(D56:D77)","v":88972},{"$f":"SUM(E56:E77)","v":10034}]
[null,{"$f":"B78/D78-1","v":0.28463085015510514},"Gain on Equities owned"]
[null,{"$f":"C78/E78-1","v":4.6391269683077496E-2},"Gain on Bonds owned"]

{"sheet":"Historic Data","index":3,"n_rows":81,"n_cols":7,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["                                                                                                                                                                                                                                                                                                                                                                                                    ",null,null,{"$f":"SUM(D2:D79)","v":0},{"$f":"SUM(E2:E79)","v":0},{"$f":"SUM(F2:F79)","v":0}]
[{"$f":"ANALYSIS!C8","v":"2016-06-30"},0,{"$f":"IF(ISBLANK(B2),\"\",IF(A2>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},null,{"$f":"IF(AND(ISBLANK(B2),G$2>A2),1,\"\")","v":""},null,{"$f":"ANALYSIS!B3","v":"2018-08-31"}]
[{"$f":"A2+30","v":"2016-07-30"},0,{"$f":"IF(ISBLANK(B3),\"\",IF(A3>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},{"$f":"IF(C3=\"<<remove this data\",1,\"\")","v":""},{"$f":"IF(AND(ISBLANK(B3),G$2>A3),1,\"\")","v":""},{"$f":"IF(OR(A3=ANALYSIS!B$3),ISBLANK(B3)*1,0)","v":0}]
[{"$f":"A3+30","v":"2016-08-29"},0,{"$f":"IF(ISBLANK(B4),\"\",IF(A4>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},null,{"$f":"IF(AND(ISBLANK(B4),G$2>A4),1,\"\")","v":""},{"$f":"IF(OR(A4=ANALYSIS!B$3),ISBLANK(B4)*1,0)","v":0}]
["2016-09-28",0,{"$f":"IF(ISBLANK(B5),\"\",IF(A5>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B5),G$2>A5),1,\"\")","v":""},{"$f":"IF(OR(A5=ANALYSIS!B$3),ISBLANK(B5)*1,0)","v":0}]
["2016-10-28",0,{"$f":"IF(ISBLANK(B6),\"\",IF(A6>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B6),G$2>A6),1,\"\")","v":""},{"$f":"IF(OR(A6=ANALYSIS!B$3),ISBLANK(B6)*1,0)","v":0},"MAKE NO CHANGES ON THIS SHEET"]
["2016-11-27",0,{"$f":"IF(ISBLANK(B7),\"\",IF(A7>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B7),G$2>A7),1,\"\")","v":""},{"$f":"IF(OR(A7=ANALYSIS!B$3),ISBLANK(B7)*1,0)","v":0},"(An exception:  If data is in a future date cell, delete the NUMBER.)"]
["2016-12-27",0,{"$f":"IF(ISBLANK(B8),\"\",IF(A8>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B8),G$2>A8),1,\"\")","v":""},{"$f":"IF(OR(A8=ANALYSIS!B$3),ISBLANK(B8)*1,0)","v":0}]
["2017-01-26",0,{"$f":"IF(ISBLANK(B9),\"\",IF(A9>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B9),G$2>A9),1,\"\")","v":""},{"$f":"IF(OR(A9=ANALYSIS!B$3),ISBLANK(B9)*1,0)","v":0},"CHECK THAT THE LATEST NUMBER IS ASSOCIATED WITH THE LATEST DATE INDICATED"]
["2017-02-25",0,{"$f":"IF(ISBLANK(B10),\"\",IF(A10>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B10),G$2>A10),1,\"\")","v":""},{"$f":"IF(OR(A10=ANALYSIS!B$3),ISBLANK(B10)*1,0)","v":0}]
["2017-03-27",0,{"$f":"IF(ISBLANK(B11),\"\",IF(A11>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B11),G$2>A11),1,\"\")","v":""},{"$f":"IF(OR(A11=ANALYSIS!B$3),ISBLANK(B11)*1,0)","v":0}]
["2017-04-26",0,{"$f":"IF(ISBLANK(B12),\"\",IF(A12>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B12),G$2>A12),1,\"\")","v":""},{"$f":"IF(OR(A12=ANALYSIS!B$3),ISBLANK(B12)*1,0)","v":0}]
["2017-05-26",0,{"$f":"IF(ISBLANK(B13),\"\",IF(A13>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B13),G$2>A13),1,\"\")","v":""},{"$f":"IF(OR(A13=ANALYSIS!B$3),ISBLANK(B13)*1,0)","v":0}]
["2017-06-25",0,{"$f":"IF(ISBLANK(B14),\"\",IF(A14>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B14),G$2>A14),1,\"\")","v":""},{"$f":"IF(OR(A14=ANALYSIS!B$3),ISBLANK(B14)*1,0)","v":0}]
["2017-07-25",0,{"$f":"IF(ISBLANK(B15),\"\",IF(A15>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},{"$f":"IF(C15=\"<<remove this data\",1,\"\")","v":""},{"$f":"IF(AND(ISBLANK(B15),G$2>A15),1,\"\")","v":""},{"$f":"IF(OR(A15=ANALYSIS!B$3),ISBLANK(B15)*1,0)","v":0}]
["2017-08-24",0,{"$f":"IF(ISBLANK(B16),\"\",IF(A16>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},{"$f":"IF(C16=\"<<remove this data\",1,\"\")","v":""},{"$f":"IF(AND(ISBLANK(B16),G$2>A16),1,\"\")","v":""},{"$f":"IF(OR(A16=ANALYSIS!B$3),ISBLANK(B16)*1,0)","v":0},"MACRO TO INSERT NEW DATA ON THE NEXT BLANK LINE"]
["2017-09-23",0,{"$f":"IF(ISBLANK(B17),\"\",IF(A17>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B17),G$2>A17),1,\"\")","v":""},{"$f":"IF(OR(A17=ANALYSIS!B$3),ISBLANK(B17)*1,0)","v":0},"Range(\"A1:J1\").Copy"]
["2017-10-23",0,{"$f":"IF(ISBLANK(B18),\"\",IF(A18>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B18),G$2>A18),1,\"\")","v":""},{"$f":"IF(OR(A18=ANALYSIS!B$3),ISBLANK(B18)*1,0)","v":0},"Sheets(\"Sheet2\").Range(\"A\" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues"]
["2017-11-22",0,{"$f":"IF(ISBLANK(B19),\"\",IF(A19>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},null,{"$f":"IF(AND(ISBLANK(B19),G$2>A19),1,\"\")","v":""},{"$f":"IF(OR(A19=ANALYSIS!B$3),ISBLANK(B19)*1,0)","v":0},"End Sub"]
["2017-12-22",0,{"$f":"IF(ISBLANK(B20),\"\",IF(A20>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B20),G$2>A20),1,\"\")","v":""},{"$f":"IF(OR(A20=ANALYSIS!B$3),ISBLANK(B20)*1,0)","v":0}]
["2018-01-21",0,{"$f":"IF(ISBLANK(B21),\"\",IF(A21>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B21),G$2>A21),1,\"\")","v":""},{"$f":"IF(OR(A21=ANALYSIS!B$3),ISBLANK(B21)*1,0)","v":0}]
["2018-02-20",0,{"$f":"IF(ISBLANK(B22),\"\",IF(A22>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B22),G$2>A22),1,\"\")","v":""},{"$f":"IF(OR(A22=ANALYSIS!B$3),ISBLANK(B22)*1,0)","v":0}]
["2018-03-22",0,{"$f":"IF(ISBLANK(B23),\"\",IF(A23>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B23),G$2>A23),1,\"\")","v":""},{"$f":"IF(OR(A23=ANALYSIS!B$3),ISBLANK(B23)*1,0)","v":0}]
["2018-04-21",0,{"$f":"IF(ISBLANK(B24),\"\",IF(A24>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B24),G$2>A24),1,\"\")","v":""},{"$f":"IF(OR(A24=ANALYSIS!B$3),ISBLANK(B24)*1,0)","v":0}]
["2018-05-21",0,{"$f":"IF(ISBLANK(B25),\"\",IF(A25>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B25),G$2>A25),1,\"\")","v":""},{"$f":"IF(OR(A25=ANALYSIS!B$3),ISBLANK(B25)*1,0)","v":0}]
["2018-06-20",0,{"$f":"IF(ISBLANK(B26),\"\",IF(A26>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK($B26),$G$2>$A26),1,\"\")","v":""},{"$f":"IF(OR(A26=ANALYSIS!B$3),ISBLANK(B26)*1,0)","v":0}]
["2018-07-20",0,{"$f":"IF(ISBLANK(B27),\"\",IF(A27>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B27),G$2>A27),1,\"\")","v":""},{"$f":"IF(OR(A27=ANALYSIS!B$3),ISBLANK(B27)*1,0)","v":0}]
["2018-08-19",135354.66600000003,{"$f":"IF(ISBLANK(B28),\"\",IF(A28>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B28),G$2>A28),1,\"\")","v":""},{"$f":"IF(OR(A28=ANALYSIS!B$3),ISBLANK(B28)*1,0)","v":0}]
["2018-09-18",null,{"$f":"IF(ISBLANK(B29),\"\",IF(A29>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B29),G$2>A29),1,\"\")","v":""},{"$f":"IF(OR(A29=ANALYSIS!B$3),ISBLANK(B29)*1,0)","v":0}]
["2018-10-18",null,{"$f":"IF(ISBLANK(B30),\"\",IF(A30>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B30),G$2>A30),1,\"\")","v":""},{"$f":"IF(OR(A30=ANALYSIS!B$3),ISBLANK(B30)*1,0)","v":0}]
["2018-11-17",null,{"$f":"IF(ISBLANK(B31),\"\",IF(A31>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B31),G$2>A31),1,\"\")","v":""},{"$f":"IF(OR(A31=ANALYSIS!B$3),ISBLANK(B31)*1,0)","v":0}]
["2018-12-17",null,{"$f":"IF(ISBLANK(B32),\"\",IF(A32>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B32),G$2>A32),1,\"\")","v":""},{"$f":"IF(OR(A32=ANALYSIS!B$3),ISBLANK(B32)*1,0)","v":0}]
["2019-01-16",null,{"$f":"IF(ISBLANK(B33),\"\",IF(A33>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B33),G$2>A33),1,\"\")","v":""},{"$f":"IF(OR(A33=ANALYSIS!B$3),ISBLANK(B33)*1,0)","v":0}]
["2019-02-15",null,{"$f":"IF(ISBLANK(B34),\"\",IF(A34>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B34),G$2>A34),1,\"\")","v":""},{"$f":"IF(OR(A34=ANALYSIS!B$3),ISBLANK(B34)*1,0)","v":0}]
["2019-03-17",null,{"$f":"IF(ISBLANK(B35),\"\",IF(A35>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B35),G$2>A35),1,\"\")","v":""},{"$f":"IF(OR(A35=ANALYSIS!B$3),ISBLANK(B35)*1,0)","v":0}]
["2019-04-16",null,{"$f":"IF(ISBLANK(B36),\"\",IF(A36>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B36),G$2>A36),1,\"\")","v":""},{"$f":"IF(OR(A36=ANALYSIS!B$3),ISBLANK(B36)*1,0)","v":0}]
["2019-05-16",null,{"$f":"IF(ISBLANK(B37),\"\",IF(A37>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B37),G$2>A37),1,\"\")","v":""},{"$f":"IF(OR(A37=ANALYSIS!B$3),ISBLANK(B37)*1,0)","v":0}]
["2019-06-15",null,{"$f":"IF(ISBLANK(B38),\"\",IF(A38>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B38),G$2>A38),1,\"\")","v":""},{"$f":"IF(OR(A38=ANALYSIS!B$3),ISBLANK(B38)*1,0)","v":0}]
["2019-07-15",null,{"$f":"IF(ISBLANK(B39),\"\",IF(A39>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B39),G$2>A39),1,\"\")","v":""},{"$f":"IF(OR(A39=ANALYSIS!B$3),ISBLANK(B39)*1,0)","v":0}]
["2019-08-14",null,{"$f":"IF(ISBLANK(B40),\"\",IF(A40>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B40),G$2>A40),1,\"\")","v":""},{"$f":"IF(OR(A40=ANALYSIS!B$3),ISBLANK(B40)*1,0)","v":0}]
["2019-09-13",null,{"$f":"IF(ISBLANK(B41),\"\",IF(A41>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B41),G$2>A41),1,\"\")","v":""},{"$f":"IF(OR(A41=ANALYSIS!B$3),ISBLANK(B41)*1,0)","v":0}]
["2019-10-13",null,{"$f":"IF(ISBLANK(B42),\"\",IF(A42>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B42),G$2>A42),1,\"\")","v":""},{"$f":"IF(OR(A42=ANALYSIS!B$3),ISBLANK(B42)*1,0)","v":0}]
["2019-11-12",null,{"$f":"IF(ISBLANK(B43),\"\",IF(A43>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B43),G$2>A43),1,\"\")","v":""},{"$f":"IF(OR(A43=ANALYSIS!B$3),ISBLANK(B43)*1,0)","v":0}]
["2019-12-12",null,{"$f":"IF(ISBLANK(B44),\"\",IF(A44>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B44),G$2>A44),1,\"\")","v":""},{"$f":"IF(OR(A44=ANALYSIS!B$3),ISBLANK(B44)*1,0)","v":0}]
["2020-01-11",null,{"$f":"IF(ISBLANK(B45),\"\",IF(A45>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B45),G$2>A45),1,\"\")","v":""},{"$f":"IF(OR(A45=ANALYSIS!B$3),ISBLANK(B45)*1,0)","v":0}]
["2020-02-10",null,{"$f":"IF(ISBLANK(B46),\"\",IF(A46>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B46),G$2>A46),1,\"\")","v":""},{"$f":"IF(OR(A46=ANALYSIS!B$3),ISBLANK(B46)*1,0)","v":0}]
["2020-03-11",null,{"$f":"IF(ISBLANK(B47),\"\",IF(A47>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B47),G$2>A47),1,\"\")","v":""},{"$f":"IF(OR(A47=ANALYSIS!B$3),ISBLANK(B47)*1,0)","v":0}]
["2020-04-10",null,{"$f":"IF(ISBLANK(B48),\"\",IF(A48>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B48),G$2>A48),1,\"\")","v":""},{"$f":"IF(OR(A48=ANALYSIS!B$3),ISBLANK(B48)*1,0)","v":0}]
["2020-05-10",null,{"$f":"IF(ISBLANK(B49),\"\",IF(A49>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B49),G$2>A49),1,\"\")","v":""},{"$f":"IF(OR(A49=ANALYSIS!B$3),ISBLANK(B49)*1,0)","v":0}]
["2020-06-09",null,{"$f":"IF(ISBLANK(B50),\"\",IF(A50>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B50),G$2>A50),1,\"\")","v":""},{"$f":"IF(OR(A50=ANALYSIS!B$3),ISBLANK(B50)*1,0)","v":0}]
["2020-07-09",null,{"$f":"IF(ISBLANK(B51),\"\",IF(A51>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B51),G$2>A51),1,\"\")","v":""},{"$f":"IF(OR(A51=ANALYSIS!B$3),ISBLANK(B51)*1,0)","v":0}]
["2020-08-08",null,{"$f":"IF(ISBLANK(B52),\"\",IF(A52>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B52),G$2>A52),1,\"\")","v":""},{"$f":"IF(OR(A52=ANALYSIS!B$3),ISBLANK(B52)*1,0)","v":0}]
["2020-09-07",null,{"$f":"IF(ISBLANK(B53),\"\",IF(A53>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B53),G$2>A53),1,\"\")","v":""},{"$f":"IF(OR(A53=ANALYSIS!B$3),ISBLANK(B53)*1,0)","v":0}]
["2020-10-07",null,{"$f":"IF(ISBLANK(B54),\"\",IF(A54>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B54),G$2>A54),1,\"\")","v":""},{"$f":"IF(OR(A54=ANALYSIS!B$3),ISBLANK(B54)*1,0)","v":0}]
["2020-11-06",null,{"$f":"IF(ISBLANK(B55),\"\",IF(A55>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B55),G$2>A55),1,\"\")","v":""},{"$f":"IF(OR(A55=ANALYSIS!B$3),ISBLANK(B55)*1,0)","v":0}]
["2020-12-06",null,{"$f":"IF(ISBLANK(B56),\"\",IF(A56>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B56),G$2>A56),1,\"\")","v":""},{"$f":"IF(OR(A56=ANALYSIS!B$3),ISBLANK(B56)*1,0)","v":0}]
["2021-01-05",null,{"$f":"IF(ISBLANK(B57),\"\",IF(A57>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B57),G$2>A57),1,\"\")","v":""},{"$f":"IF(OR(A57=ANALYSIS!B$3),ISBLANK(B57)*1,0)","v":0}]
["2021-02-04",null,{"$f":"IF(ISBLANK(B58),\"\",IF(A58>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B58),G$2>A58),1,\"\")","v":""},{"$f":"IF(OR(A58=ANALYSIS!B$3),ISBLANK(B58)*1,0)","v":0}]
["2021-03-06",null,{"$f":"IF(ISBLANK(B59),\"\",IF(A59>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B59),G$2>A59),1,\"\")","v":""},{"$f":"IF(OR(A59=ANALYSIS!B$3),ISBLANK(B59)*1,0)","v":0}]
["2021-04-05",null,{"$f":"IF(ISBLANK(B60),\"\",IF(A60>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B60),G$2>A60),1,\"\")","v":""},{"$f":"IF(OR(A60=ANALYSIS!B$3),ISBLANK(B60)*1,0)","v":0}]
["2021-05-05",null,{"$f":"IF(ISBLANK(B61),\"\",IF(A61>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B61),G$2>A61),1,\"\")","v":""},{"$f":"IF(OR(A61=ANALYSIS!B$3),ISBLANK(B61)*1,0)","v":0}]
["2021-06-04",null,{"$f":"IF(ISBLANK(B62),\"\",IF(A62>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B62),G$2>A62),1,\"\")","v":""},{"$f":"IF(OR(A62=ANALYSIS!B$3),ISBLANK(B62)*1,0)","v":0}]
["2021-07-04",null,{"$f":"IF(ISBLANK(B63),\"\",IF(A63>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B63),G$2>A63),1,\"\")","v":""},{"$f":"IF(OR(A63=ANALYSIS!B$3),ISBLANK(B63)*1,0)","v":0}]
["2021-08-03",null,{"$f":"IF(ISBLANK(B64),\"\",IF(A64>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B64),G$2>A64),1,\"\")","v":""},{"$f":"IF(OR(A64=ANALYSIS!B$3),ISBLANK(B64)*1,0)","v":0}]
["2021-09-02",null,{"$f":"IF(ISBLANK(B65),\"\",IF(A65>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B65),G$2>A65),1,\"\")","v":""},{"$f":"IF(OR(A65=ANALYSIS!B$3),ISBLANK(B65)*1,0)","v":0}]
["2021-10-02",null,{"$f":"IF(ISBLANK(B66),\"\",IF(A66>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B66),G$2>A66),1,\"\")","v":""},{"$f":"IF(OR(A66=ANALYSIS!B$3),ISBLANK(B66)*1,0)","v":0}]
["2021-11-01",null,{"$f":"IF(ISBLANK(B67),\"\",IF(A67>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B67),G$2>A67),1,\"\")","v":""},{"$f":"IF(OR(A67=ANALYSIS!B$3),ISBLANK(B67)*1,0)","v":0}]
[{"$f":"A67+30","v":"2021-12-01"},null,{"$f":"IF(ISBLANK(B68),\"\",IF(A68>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B68),G$2>A68),1,\"\")","v":""},{"$f":"IF(OR(A68=ANALYSIS!B$3),ISBLANK(B68)*1,0)","v":0}]
["2021-12-31",null,{"$f":"IF(ISBLANK(B69),\"\",IF(A69>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B69),G$2>A69),1,\"\")","v":""},{"$f":"IF(OR(A69=ANALYSIS!B$3),ISBLANK(B69)*1,0)","v":0}]
["2022-01-30",null,{"$f":"IF(ISBLANK(B70),\"\",IF(A70>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B70),G$2>A70),1,\"\")","v":""},{"$f":"IF(OR(A70=ANALYSIS!B$3),ISBLANK(B70)*1,0)","v":0}]
["2022-03-01",null,{"$f":"IF(ISBLANK(B71),\"\",IF(A71>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B71),G$2>A71),1,\"\")","v":""},{"$f":"IF(OR(A71=ANALYSIS!B$3),ISBLANK(B71)*1,0)","v":0}]
["2022-03-31",null,{"$f":"IF(ISBLANK(B72),\"\",IF(A72>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B72),G$2>A72),1,\"\")","v":""},{"$f":"IF(OR(A72=ANALYSIS!B$3),ISBLANK(B72)*1,0)","v":0}]
["2022-04-30",null,{"$f":"IF(ISBLANK(B73),\"\",IF(A73>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B73),G$2>A73),1,\"\")","v":""},{"$f":"IF(OR(A73=ANALYSIS!B$3),ISBLANK(B73)*1,0)","v":0}]
["2022-05-30",null,{"$f":"IF(ISBLANK(B74),\"\",IF(A74>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B74),G$2>A74),1,\"\")","v":""},{"$f":"IF(OR(A74=ANALYSIS!B$3),ISBLANK(B74)*1,0)","v":0}]
["2022-06-29",null,{"$f":"IF(ISBLANK(B75),\"\",IF(A75>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B75),G$2>A75),1,\"\")","v":""},{"$f":"IF(OR(A75=ANALYSIS!B$3),ISBLANK(B75)*1,0)","v":0}]
["2022-07-29",null,{"$f":"IF(ISBLANK(B76),\"\",IF(A76>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B76),G$2>A76),1,\"\")","v":""},{"$f":"IF(OR(A76=ANALYSIS!B$3),ISBLANK(B76)*1,0)","v":0}]
["2022-08-28",null,{"$f":"IF(ISBLANK(B77),\"\",IF(A77>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B77),G$2>A77),1,\"\")","v":""},{"$f":"IF(OR(A77=ANALYSIS!B$3),ISBLANK(B77)*1,0)","v":0}]
["2022-09-27",null,{"$f":"IF(ISBLANK(B78),\"\",IF(A78>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B78),G$2>A78),1,\"\")","v":""},{"$f":"IF(OR(A78=ANALYSIS!B$3),ISBLANK(B78)*1,0)","v":0}]
["2022-10-27",null,{"$f":"IF(ISBLANK(B79),\"\",IF(A79>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},"",{"$f":"IF(AND(ISBLANK(B79),G$2>A79),1,\"\")","v":""},{"$f":"IF(OR(A79=ANALYSIS!B$3),ISBLANK(B79)*1,0)","v":0}]
["2022-11-26",null,{"$f":"IF(ISBLANK(B80),\"\",IF(A80>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},{"$f":"IF(C80=\"<<remove this data\",1,\"\")","v":""},{"$f":"IF(AND(ISBLANK(B80),G$2>A80),1,\"\")","v":""},{"$f":"IF(OR(A80=ANALYSIS!B$3),ISBLANK(B80)*1,0)","v":0}]
[{"$f":"A80+30","v":"2022-12-26"},null,{"$f":"IF(ISBLANK(B81),\"\",IF(A81>ANALYSIS!B$3,\"<<Remove this data\",\"\"))","v":""},null,{"$f":"IF(AND(ISBLANK(B81),G$2>A81),1,\"\")","v":""},{"$f":"IF(OR(A81=ANALYSIS!B$3),ISBLANK(B81)*1,0)","v":0}]

{"sheet":"Annual Iteration","index":4,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,"Portfolio"]
[null,"Cost Basis","Return"]
["Start Value",{"$f":"ANALYSIS!C7","v":2000},"IRR",null,"XIRR"]
[{"$f":"ANALYSIS!C8","v":"2016-06-30"},{"$f":"-B3","v":-2000},{"$f":"IRR(B4:B39)","v":0.15138781886597652},null,{"$f":"XIRR(B4:B39,A4:A39)","v":0.1513878166675568}]
[{"$f":"A4+365.25","v":"2017-06-30T06:00:00"},{"$f":"ANALYSIS!L42","v":1000}]
[{"$f":"A5+365.25","v":"2018-06-30T12:00:00"},{"$f":"ANALYSIS!L43","v":1500}]
["2019-06-30T18:00:00",{"$f":"ANALYSIS!L44","v":0},null,null,null,"MAKE NO CHANGES ON THIS SHEET"]
["2020-06-30",{"$f":"ANALYSIS!L45","v":0}]
["2021-06-30T06:00:00",{"$f":"ANALYSIS!L46","v":0}]
["2022-06-30T12:00:00",{"$f":"ANALYSIS!L47","v":0}]
["2023-06-30T18:00:00",{"$f":"ANALYSIS!L48","v":0}]
["2024-06-30",{"$f":"ANALYSIS!L49","v":0}]
["2025-06-30T06:00:00",{"$f":"ANALYSIS!L50","v":0}]
["2026-06-30T12:00:00",{"$f":"ANALYSIS!L51","v":0}]
["2027-06-30T18:00:00",{"$f":"ANALYSIS!L52","v":0}]
["2028-06-30",{"$f":"ANALYSIS!N42","v":0}]
["2029-06-30T06:00:00",{"$f":"ANALYSIS!N43","v":0}]
["2030-06-30T12:00:00",{"$f":"ANALYSIS!N44","v":0}]
["2031-06-30T18:00:00",{"$f":"ANALYSIS!N45","v":0}]
["2032-06-30",{"$f":"ANALYSIS!N46","v":0}]
["2033-06-30T06:00:00",{"$f":"ANALYSIS!N47","v":0}]
["2034-06-30T12:00:00",{"$f":"ANALYSIS!N48","v":0}]
["2035-06-30T18:00:00",{"$f":"ANALYSIS!N49","v":0}]
["2036-06-30",{"$f":"ANALYSIS!N50","v":0}]
["2037-06-30T06:00:00",{"$f":"ANALYSIS!N51","v":0}]
["2038-06-30T12:00:00",{"$f":"ANALYSIS!N52","v":0}]
["2039-06-30T18:00:00",{"$f":"ANALYSIS!N53","v":0}]
["2040-06-30",{"$f":"ANALYSIS!N54","v":0}]
["2041-06-30T06:00:00",{"$f":"ANALYSIS!N55","v":0}]
["2042-06-30T12:00:00",{"$f":"ANALYSIS!N56","v":0}]
["2043-06-30T18:00:00",{"$f":"ANALYSIS!N57","v":0}]
["2044-06-30",{"$f":"ANALYSIS!N58","v":0}]
["2045-06-30T06:00:00",{"$f":"ANALYSIS!N59","v":0}]
["2046-06-30T12:00:00",{"$f":"ANALYSIS!N60","v":0}]
["2047-06-30T18:00:00",{"$f":"ANALYSIS!N61","v":0}]
["2048-06-30",{"$f":"ANALYSIS!N62","v":0}]
["2049-06-30T06:00:00",{"$f":"ANALYSIS!N63","v":0}]
["2050-06-30T12:00:00",{"$f":"ANALYSIS!N64","v":0}]
["2051-06-30T18:00:00",{"$f":"ANALYSIS!N65","v":0}]