{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DCA"],"not_rendered":{"charts":1,"images":4,"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":"DCA","index":0,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"DVA\nVALOR PROMEDIO",null,null,null,null,null,null,null,null,"First Row",10]
["Inicio Inversion","2018-01-01",null,null,null,null,null,null,null,null,"Last Row",14]
["Inversion mensual",1000]
["Ultima Compra","2018-03-01"]
["Proxima compra",{"$f":"TRUNC(NOW())","v":"2018-03-24"}]
["Numero de compras",1]
["Valor Portafolio",{"$f":"F14","v":0}]
[]
["Tique ETF","Nombre ETF","Precio (U$D)","Unidades Actuales","Porcentaje Objetivo","Valor Actual","Unidades a comprar","Total a pagar","Total a pagar","Unidades a comprar","Aux 1","Current allocation","Next allocation"]
["SPY","SPDR S&P 500 ETF Trust",275.95,0,0.4,{"$f":"C10*D10","v":0},{"$f":"ROUND(K10/C10,0)","v":1},{"$f":"$B$3*E10","v":400},{"$f":"C10*G10","v":275.95},2,{"$f":"($B$6*$B$3)*E10 - (C10*D10)","v":400},{"$f":"F10/$B$7","v":{"$error":"#DIV/0!"}},{"$f":"(F10+I10)/($B$7+$B$3)","v":0.27594999999999997}]
["VBR","Vanguard Small-Cap Value ETF",132.86000000000001,0,0.25,{"$f":"C11*D11","v":0},{"$f":"ROUND(K11/C11,0)","v":2},{"$f":"$B$3*E11","v":250},{"$f":"C11*G11","v":265.72000000000003},2,{"$f":"($B$6*$B$3)*E11 - (C11*D11)","v":250},{"$f":"F11/$B$7","v":{"$error":"#DIV/0!"}},{"$f":"(F11+I11)/($B$7+$B$3)","v":0.26572000000000001}]
["VNQ","Vanguard Real Estate ETF",75.86,0,0.15,0,{"$f":"ROUND(K12/C12,0)","v":2},150,{"$f":"C12*G12","v":151.72},2,150,{"$error":"#DIV/0!"},0.15171999999999999]
["TLT","iShares 20+ Year Treasury Bond ETF",120.11,0,0.2,0,{"$f":"ROUND(K13/C13,0)","v":2},200,{"$f":"C13*G13","v":240.22},2,200,{"$error":"#DIV/0!"},0.24021999999999999]
[null,null,null,"Total:",{"$f":"SUM(E10:OFFSET(E14,-1,0))","v":1},{"$f":"SUM(F10:OFFSET(F14,-1,0))","v":0},null,{"$f":"SUM(H10:H13)","v":1000},{"$f":"SUM(I10:OFFSET(I14,-1,0))","v":933.61000000000013}]