{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Analisis Economico (2)"],"read":"whole","date_system":"1900"}

{"sheet":"Analisis Economico (2)","index":0,"n_rows":47,"n_cols":5,"rows_kept":47,"merged":[[1,1,1,5],[3,1,3,4],[13,1,13,4]]}
[]
[null,"ANEXO No. 2 - FORMULARIO DE PRECIOS Y CANTIDADES"]
[]
[null,"ANALISIS ECONOMICO MANTENIMIENTO PREVENTIVO UNIDAD"]
[null,"ACTIVIDAD","Cantidad","Valor Unitario","Valor Total "]
[null,"MTTO PREVENTIVO PORTATILES",100,null,{"$f":"D6*C6","v":0}]
[null,"MTTO PREVENTIVO SERVIDORES",4,null,{"$f":"D7*C7","v":0}]
[null,"MTTO PREVENTIVO MAC ",1,null,{"$f":"D8*C8","v":0}]
[null,"MTTO PREVENTIVO ESCANER",1,null,{"$f":"D9*C9","v":0}]
[null,"MMTO PREVENTIVO IMPRESORA ZEBRA",2,null,{"$f":"D10*C10","v":0}]
[null,"TOTAL",{"$f":"SUM(C6:C10)","v":108},{"$f":"SUM(D6:D10)","v":0},{"$f":"SUM(E6:E10)","v":0}]
[null,"TOTAL CON IVA",{"$f":"+C11","v":108},{"$f":"D11*(1+19%)","v":0},{"$f":"E11*(1+19%)","v":0}]
[]
[null,"ANALISIS ECONOMICO MANTENIMIENTO CORRECTIVO UNIDAD"]
[null,"ACTIVIDAD","Cantidad","Valor Unitario","Valor Total "]
[null,"MTTO CORRECTIVO PORTATILES",30,null,{"$f":"+C16*D16","v":0}]
[null,"MTTO CORRECTIVO SERVIDORES",2,null,{"$f":"+C17*D17","v":0}]
[null,"MTTO CORRECTIVO MAC ",1,null,{"$f":"+C18*D18","v":0}]
[null,"MTTO CORRECTIVO ESCANER",1,null,{"$f":"+C19*D19","v":0}]
[null,"MMTO CORRECTIVO IMPRESORA ZEBRA",1,null,{"$f":"+C20*D20","v":0}]
[null,"TOTAL",{"$f":"SUM(C16:C20)","v":35},{"$f":"SUM(D16:D20)","v":0},{"$f":"SUM(E16:E20)","v":0}]
[null,"TOTAL CON IVA",{"$f":"+C21","v":35},{"$f":"D21*(1+19%)","v":0},{"$f":"E21*(1+19%)","v":0}]
[]
[]
[null,"REPUESTOS","Valor Unitario"]
[null,"Repuesto disco duro SSD 512GB"]
[null,"Puertos Usb :zbook"]
[null,"Pantalla : zbook"]
[null,"Cooler Portátil : zbook"]
[null,"Puerto de carga : LENOVO L15"]
[null,"Teclado Portátil :LENOVO L15"]
[null,"Cooler Portátil : DELL"]
[null,"Teclado Portátil :DELL"]
[null,"TOTAL SIN IVA",{"$f":"SUM(C26:C33)","v":0}]
[null,"TOTAL CON IVA 19%",{"$f":"+C34*19%","v":0}]
[]
[]
[null,"Item","Valor"]
[null,"Mantenimiento Preventivo",{"$f":"+E12","v":0}]
[null,"Mantenimiento Correctivo",{"$f":"+E22","v":0}]
[null,"Bolsa de repuestos",{"$f":"+(C39+C40)*40%","v":{"v":0,"d":"$ 0"}}]
[null,"Total",{"$f":"SUM(C39:C41)","v":0}]
[]
[]
[]
[]
[null,"Firma del representante Legal "]