{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Start","Portfolio","Asset Allocation"],"not_rendered":{"charts":1,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":26,"n_cols":2,"rows_kept":26}
[null,"Investment Tracker"]
[]
[]
[]
[null,"Portfolio"]
{"$rows_empty":20}
[null,"Asset Allocation"]

{"sheet":"Portfolio","index":1,"n_rows":12,"n_cols":9,"rows_kept":12}
[null,"Investment Tracker"]
[]
[null,"Portfolio"]
[]
[null,"Company","Category","Shares","Price","Change","Change (%)","Portfolio %","Value"]
[null,{"$error":"#VALUE!"},"US Stocks",{"v":1200,"d":"1,200.00"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":304.8,"d":"£304.80"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-13.47,"d":"-£13.47"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-0.042323000000000006,"d":"-4.23%"}},{"$f":"IFERROR(I6/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.7814086441835785,"d":"78%"}},{"$f":"D6 * E6","v":{"v":365760,"d":"£365,760.00"}}]
[null,{"$error":"#VALUE!"},"Bonds",{"v":1300,"d":"1,300.00"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":11.04,"d":"£11.04"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":0.01,"d":"£0.01"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":0.0009066,"d":"0.09%"}},{"$f":"IFERROR(I7/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.030661572783581358,"d":"3%"}},{"v":14351.999999999998,"d":"£14,352.00"}]
[null,{"$error":"#VALUE!"},"International Stocks",{"v":1200,"d":"1,200.00"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":34.48,"d":"£34.48"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-0.27,"d":"-£0.27"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-7.77E-3,"d":"-0.78%"}},{"$f":"IFERROR(I8/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.08839557103494022,"d":"9%"}},{"v":41375.99999999999,"d":"£41,376.00"}]
[null,{"$error":"#VALUE!"},"Cash",{"v":10000,"d":"10,000.00"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":1,"d":"£1.00"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":0},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(I9/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.02136397211787999,"d":"2%"}},{"v":10000,"d":"£10,000.00"}]
[null,{"$error":"#VALUE!"},"Real Estate",{"v":125,"d":"125.00"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":156.59,"d":"£156.59"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-0.22,"d":"-£0.22"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-1.4030000000000002E-3,"d":"-0.14%"}},{"$f":"IFERROR(I10/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.04181730492423534,"d":"4%"}},{"v":19573.75,"d":"£19,573.75"}]
[null,{"$error":"#VALUE!"},"Commodities",{"v":100,"d":"100.00"},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Price\")","v":{"v":170.16,"d":"£170.16"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change\")","v":{"v":-0.58,"d":"-£0.58"}},{"$f":"_FV(TablePortfolio[[#This Row],[Company]],\"Change (%)\",TRUE)","v":{"v":-0.003397,"d":"-0.34%"}},{"$f":"IFERROR(I11/SUBTOTAL(109,TablePortfolio[Value]),\"\")","v":{"v":0.03635293495578459,"d":"4%"}},{"v":17016,"d":"£17,016.00"}]
[null,"Total",{"$nulls":6},{"$f":"IFERROR(SUBTOTAL(109,TablePortfolio[Value]), \"\")","v":{"v":468077.75,"d":"£468,077.75"}}]

{"sheet":"Asset Allocation","index":2,"n_rows":25,"n_cols":7,"rows_kept":25}
[null,"Investment Tracker"]
[]
[null,"Asset Allocation"]
{"$rows_empty":15}
[null,"Category","My Target","Actual","Difference","Threshold","Value"]
[null,"US Stocks",{"v":0.55,"d":"55%"},{"$f":"IFERROR(G20/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.7814086441835785,"d":"78%"}},{"$f":"D20 - C20","v":{"v":0.23140864418357843,"d":"23.1%"}},{"$f":"MIN(5%, $C20 * 25%)","v":{"v":0.05,"d":"5%"}},{"$f":"SUMIF(TablePortfolio[Category], B20, TablePortfolio[Value])","v":{"v":365760,"d":"£365,760.00"}}]
[null,"International Stocks",{"v":0.2,"d":"20%"},{"$f":"IFERROR(G21/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.08839557103494022,"d":"9%"}},{"v":-0.11160442896505979,"d":"-11.2%"},{"v":0.05,"d":"5%"},{"$f":"SUMIF(TablePortfolio[Category], B21, TablePortfolio[Value])","v":{"v":41375.99999999999,"d":"£41,376.00"}}]
[null,"Bonds",{"v":0.1,"d":"10%"},{"$f":"IFERROR(G22/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.030661572783581358,"d":"3%"}},{"v":-0.06933842721641864,"d":"-6.9%"},{"v":0.025,"d":"3%"},{"$f":"SUMIF(TablePortfolio[Category], B22, TablePortfolio[Value])","v":{"v":14351.999999999998,"d":"£14,352.00"}}]
[null,"Cash",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G23/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.02136397211787999,"d":"2%"}},{"v":-0.028636027882120014,"d":"-2.9%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Category], B23, TablePortfolio[Value])","v":{"v":10000,"d":"£10,000.00"}}]
[null,"Real Estate",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G24/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.04181730492423534,"d":"4%"}},{"v":-0.008182695075764662,"d":"-0.8%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Category], B24, TablePortfolio[Value])","v":{"v":19573.75,"d":"£19,573.75"}}]
[null,"Commodities",{"v":0.05,"d":"5%"},{"$f":"IFERROR(G25/SUBTOTAL(109,TableAssetAllocation[Value]),\"\")","v":{"v":0.03635293495578459,"d":"4%"}},{"v":-0.013647065044215416,"d":"-1.4%"},{"v":0.0125,"d":"1%"},{"$f":"SUMIF(TablePortfolio[Category], B25, TablePortfolio[Value])","v":{"v":17016,"d":"£17,016.00"}}]