{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Planificación"],"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":"Planificación","index":0,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,8,2,10],[2,12,2,14],[2,16,2,18],[2,2,2,6],[12,2,12,3]]}
[]
[]
[null,null,"CALENDARIO DEL SERVICIO",null,null,null,null,null,"RECURRENTE MENSUAL",null,null,null,"ALTA",null,null,null,"TOTAL SERVICIO"]
[null,null,"Nombre","Tipo","Fecha inicio","Duración\n(meses)","Fecha fin",null,"Coste","Margen","Precio",null,"Coste","Margen","Precio",null,"Coste","Margen","Precio"]
[]
[null,"N1","Nivel 1","-",{"$f":"SMALL(E7:E9,1)","v":"1995-05-03"},null,{"$f":"LARGE(G7:G9,1)","v":"2022-11-24"},null,null,{"$f":"IFERROR(1-(I6/K6),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(M6/O6),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(Q6/S6),\"- %\")","v":"- %"}]
[null,"N2","Nivel 2","Alta","1995-05-03",1,{"$f":"IF(OR(E7=\"\",F7=\"\",),\"\",EDATE(E7,F7))","v":"1995-06-03"},null,null,{"$f":"IFERROR(1-(I7/K7),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(M7/O7),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(Q7/S7),\"- %\")","v":"- %"}]
[null,"N2","Nivel 2","Recurrente","2000-07-08",6,{"$f":"IF(OR(E8=\"\",F8=\"\",),\"\",EDATE(E8,F8))","v":"2001-01-08"},null,null,{"$f":"IFERROR(1-(I8/K8),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(M8/O8),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(Q8/S8),\"- %\")","v":"- %"}]
[null,"N2","Nivel 2","Recurrente","2021-11-24",12,{"$f":"IF(OR(E9=\"\",F9=\"\",),\"\",EDATE(E9,F9))","v":"2022-11-24"},null,null,{"$f":"IFERROR(1-(I9/K9),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(M9/O9),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(Q9/S9),\"- %\")","v":"- %"}]
[null,"N1","Nivel 1","-",{"$f":"SMALL(E11,1)","v":"1995-05-03"},null,{"$f":"LARGE(G11,1)","v":"1995-06-03"},null,null,{"$f":"IFERROR(1-(I10/K10),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(M10/O10),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(Q10/S10),\"- %\")","v":"- %"}]
[null,"N2","Nivel 2","Alta","1995-05-03",1,{"$f":"IF(OR(E11=\"\",F11=\"\",),\"\",EDATE(E11,F11))","v":"1995-06-03"},null,null,{"$f":"IFERROR(1-(I11/K11),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(M11/O11),\"- %\")","v":"- %"},null,null,null,{"$f":"IFERROR(1-(Q11/S11),\"- %\")","v":"- %"}]
[]
[null,null,"Duración total del proyecto",null,{"$f":"IF(ISERROR(YEAR(SMALL(E5:E12,1))),YEAR(TODAY()),YEAR(SMALL(E5:E12,1)))","v":1995},"a",{"$f":"IF(ISERROR(YEAR(LARGE(G5:G12,1))),YEAR(TODAY()),YEAR(LARGE(G5:G12,1)))","v":2022},null,{"$f":"SUM(I5:I12)","v":0},{"$f":"IFERROR(1-(I13/K13),\"- %\")","v":"- %"},{"$f":"SUM(K5:K12)","v":0},null,{"$f":"SUM(M5:M12)","v":0},{"$f":"IFERROR(1-(M13/O13),\"- %\")","v":"- %"},{"$f":"SUM(O5:O12)","v":0},null,{"$f":"SUM(Q5:Q12)","v":0},{"$f":"IFERROR(1-(Q13/S13),\"- %\")","v":"- %"},{"$f":"SUM(S5:S12)","v":0}]