{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hoja1"],"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":"Hoja1","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,4,2,7],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,11,6],[11,7,12,7]]}
[null,"CALCULO DE DEPRECIACIÓN"]
[]
[null,"Activo"]
[null,"F. de adquisición",null,null,"2018-06-25"]
[null,"Valor de aquisición",null,null,2400,null,"ELABORADO POR"]
[null,"F. de inicio deprec.",null,null,"2018-07-01",null,"ARCHIVO EXCEL E.I.R.L."]
[null,"% Anual",null,null,0.1,null,"Lima - Perú"]
[null,"Vida útil anual",null,null,10,null,"Copyright©  2018"]
[null,"Nº de meses",null,null,{"$f":"E8*12","v":120},null,"WWW.ARCHIVOEXCEL.COM"]
[null,"Método",null,null,"Línea Recta"]
[]
[null,"Nº","Período","Nº Meses","Valor Histórico","Depreciación",null,"Saldo"]
[null,null,null,null,null,"Del Período","Acumulada"]
[null,{"$f":"IF(D14>0,1,0)","v":1},{"$f":"IF(E4>0,YEAR(E4),0)","v":2018},{"$f":"IF(E6>0,13-MONTH(E6),0)","v":6},{"$f":"IF(AND(E$5>0,C14>0),E$5,0)","v":2400},{"$f":"((E14*E$7)/12)*D14","v":120},{"$f":"F14","v":120},{"$f":"IF(G14>0,E14-G14,0)","v":2280}]
[null,{"$f":"IF(D15>0,2,0)","v":2},{"$f":"IF(AND(D14>0,B15>0),C14+1,0)","v":2019},{"$f":"IF(AND(H14>0,(E$9-D14)>=12),12,0)","v":12},{"$f":"IF(AND(E$5>0,C15>0),E$5,0)","v":2400},{"$f":"((E15*E$7)/12)*D15","v":240},{"$f":"IF(F15>0,G14+F15,0)","v":360},{"$f":"IF(G15>0,E15-G15,0)","v":2040}]
[null,{"$f":"IF(D16>0,3,0)","v":3},2020,{"$f":"IF(AND(H15>0,(E$9-(D14+D15))>=12),12,0)","v":12},2400,240,{"$f":"IF(F16>0,G15+F16,0)","v":600},1800]
[null,{"$f":"IF(D17>0,4,0)","v":4},2021,{"$f":"IF(AND(H16>0,(E$9-(D14+D15+D16))>=12),12,0)","v":12},2400,240,840,1560]
[null,{"$f":"IF(D18>0,5,0)","v":5},2022,{"$f":"IF(AND(H17>0,(E$9-(D14+D15+D16+D17))>=12),12,IF(AND(H17>0,(E$9-(D14+D15+D16+D17))<12),E$9-(D14+D15+D16+D17),0))","v":12},2400,240,1080,1320]
[null,{"$f":"IF(D19>0,6,0)","v":6},2023,{"$f":"IF(AND(H18>0,(E$9-(D14+D15+D16+D17+D18))>=12),12,IF(AND(H18>0,(E$9-(D14+D15+D16+D17+D18))<12),E$9-(D14+D15+D16+D17+D18),0))","v":12},2400,240,1320,1080]
[null,{"$f":"IF(D20>0,7,0)","v":7},2024,{"$f":"IF(AND(H19>0,(E$9-(D14+D15+D16+D17+D18+D19))>=12),12,IF(AND(H19>0,(E$9-(D14+D15+D16+D17+D18+D19))<12),E$9-(D14+D15+D16+D17+D18+D19),0))","v":12},2400,240,1560,840]
[null,{"$f":"IF(D21>0,8,0)","v":8},2025,{"$f":"IF(AND(H20>0,(E$9-(D14+D15+D16+D17+D18+D19+D20))>=12),12,IF(AND(H20>0,(E$9-(D14+D15+D16+D17+D18+D19+D20))<12),E$9-(D14+D15+D16+D17+D18+D19+D20),0))","v":12},2400,240,1800,600]
[null,{"$f":"IF(D22>0,9,0)","v":9},2026,{"$f":"IF(AND(H21>0,(E$9-(D14+D15+D16+D17+D18+D19+D20+D21))>=12),12,IF(AND(H21>0,(E$9-(D14+D15+D16+D17+D18+D19+D20+D21))<12),E$9-(D14+D15+D16+D17+D18+D19+D20+D21),0))","v":12},2400,240,2040,360]
[null,{"$f":"IF(D23>0,10,0)","v":10},2027,{"$f":"IF(AND(H22>0,(E$9-(D14+D15+D16+D17+D18+D19+D20+D21+D22))>=12),12,IF(AND(H22>0,(E$9-(D14+D15+D16+D17+D18+D19+D20+D21+D22))<12),E$9-(D14+D15+D16+D17+D18+D19+D20+D21+D22),0))","v":12},2400,240,2280,120]
[null,{"$f":"IF(D24>0,11,0)","v":11},2028,{"$f":"IF(AND(H23>0,(E$9-(D14+D15+D16+D17+D18+D19+D20+D21+D22+D23))>=12),12,IF(AND(H23>0,(E$9-(D14+D15+D16+D17+D18+D19+D20+D21+D22+D23))<12),E$9-(D14+D15+D16+D17+D18+D19+D20+D21+D22+D23),0))","v":6},2400,120,2400,0]