{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["C","S","L","Control","Caracteristicas tecnicas","Dimensionado","Costos unitarios","Costeo","Precio","Servicios complementarios"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":214,"comments":2,"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":"C","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"Workbook.Title","v":"Analysys Mason - Modelo de costos coubicacion fija"}]
[]
["Información"]
[]
["Título","Analysys Mason - Modelo de costos coubicacion fija"]
["Objectivo","Determinar precios orientados a costos para el servicio de coubicación fija en la infraestructura pasiva fija del AEP"]
[]
["Versión","2 de noviembre 2016"]
["Estatus","Approved for release"]
[null,"Under construction"]
[null,"Work in progress"]
[null,"Ready for review"]
[null,"Approved for release"]
["Autor","Guillermo Fernández Castellanos, David de Antonio Monte"]
["Email","guillermo.fernandez@analysysmason.com"]
[null,"david.de.antonio@analysysmason.com"]

{"sheet":"S","index":1,"n_rows":140,"n_cols":10,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[null,null,"Style Guidelines"]
[]
[]
[]
[]
["Input cell styles"]
["Use these styles to identify inputs to a model"]
["NB These styles change most aspects of a cells formatting (all except Number and Alignment)"]
[]
[null,"Input Parameter",100,"unlocked","An input to the model that it is expected the user will change (change at will)"]
[]
[null,"Input Parameter",250,"unlocked","Consider using Data Validation to ensure that only acceptable values are entered"]
[null,"Minimum",100]
[null,"Maximum",300]
[]
[null,"Input Parameter",300,"unlocked","If a parameter can take only one of a small number of values, consider using Data Validation Allow List with In-cell dropdown selected"]
[null,"Acceptable values",100]
[null,null,200]
[null,null,300]
[]
[null,"Input Data",100,"unlocked","A piece of real data (only change if you have better data)"]
[]
[null,"Input Estimate",100,"unlocked","An estimate used in the absence of real data (only change if you have a better estimate, or real data )"]
[]
[null,"Input Calculation",100,"locked","An input to the model that has, none the less, been calculated from other inputs (e.g. interpolated input values)"]
[]
[null,"Input Link",100,"locked","An input to this part of the model, which is linked to a source on this or another worksheet within this workbook"]
[]
[null,"Input Link (different Workbook)",100,"locked","An input to this part of the model, which is linked to a source on a worksheet in a different workbook"]
[]
["Other cell styles"]
["Use these styles to identify the role of other cells in a model"]
["NB These styles change a variety of different aspects of cell formatting (as appropriate to the context)"]
[]
[null,"Calculation",100,"locked","A calculation of the model"]
[]
[null,"Total",123.45,null,"A total (use if not part of a \"Sub-total row\" or a \"Total row\" in a table - see below)"]
[]
[null,"Checksum",0,"locked","A side calculation intended solely to cross check a result (and which therefore should not be referenced anywhere else in the model)"]
[]
[null,"Checksum",0.1,"locked","Consider using Format Conditional Formatting to highlight unacceptable results of cross check calculations (e.g. non-zero)"]
[]
[null,"Output",100,null,"A key result from this part of the model (in particular one that will be used elsewhere in the model)"]
[]
[null,"Name","Name","locked","An Excel Name applying to one or more adjacent cells (use Insert Name Create to actually create the Excel Names)"]
[]
[null,"Note","Note",null,"A note (NB smaller than standard font size)"]
[]
[null,"Highlight",100,null,"A cell that is special in some way"]
[]
[null,"Unhighlight",100,null,"And one that isn't anymore"]
[]
["Number styles"]
["Use these styles to consistently format numbers (and dates)"]
["NB All number styles use the decimal symbol and digit grouping symbol (thousands separator) defined under Regional Options in Control Panel. So if you want to change them do it there, and not here in Excel !"]
["NB Most number styles leave space for a ')' to the right of the number, but only the Currency styles actually use '(…)' for negatives"]
[]
[null,null,"Number","Number\n(2dp)","Percentage","Percentage (2dp)","Currency","Currency\n(2dp)","Comma","Percent"]
[null,"Positive",1234.56,123.45,0.1234,0.1234,1234.56,123.45,1234.56,0.1234]
[null,"Negative",-1234.56,-123.45,-0.1234,-0.1234,-1234.56,-123.45,-1234.56,-0.1234]
[null,"Zero",0,0,0,0,0,0,0,0]
[null,"Text","Text","Text","Text","Text","Text","Text","Text","Text"]
[]
[null,null,"Currency\nEUR","Currency\nEUR (2dp)","Currency\nEuro","Currency\nEuro (2dp)"]
[null,"Positive",1234.56,123.45,1234.56,123.45]
[null,"Negative",-1234.56,-123.45,-1234.56,-123.45]
[null,"Zero",0,0,0,0]
[null,"Text","Text","Text","Text","Text"]
[]
[null,null,"Currency\nUSD","Currency\nUSD (2dp)","Currency Dollar","Currency Dollar (2dp)"]
[null,"Positive",1234.56,123.45,1234.56,123.45]
[null,"Negative",-1234.56,-123.45,-1234.56,-123.45]
[null,"Zero",0,0,0,0]
[null,"Text","Text","Text","Text","Text"]
[]
[null,null,"Currency\nGBP","Currency\nGBP (2dp)","Currency Pound","Currency Pound (2dp)"]
[null,"Positive",1234.56,123.45,1234.56,123.45]
[null,"Negative",-1234.56,-123.45,-1234.56,-123.45]
[null,"Zero",0,0,0,0]
[null,"Text","Text","Text","Text","Text"]
[]
[null,null,"Date","Date\n(Month)","Date\n(Year)"]
[null,"Date","2002-12-01","2002-12-01","2002-12-01"]
[]
["Heading styles"]
["Use these styles to format headings"]
["NB These styles change only the font used in a cell"]
[]
[null,"H1","Title",null,"Heading level 1"]
[]
[null,"H2","Title",null,"Heading level 2"]
[]
[null,"H3","Title",null,"Heading level 3"]
[]
[null,"H4","Title",null,"Heading level 4"]
[]
["Table styles"]
["Use these styles to consistently format tables"]
["NB These styles change a variety of different aspects of cell formatting (as appropriate to the context)"]
[]
["A simple table"]
[null,"Column label (left aligned)","Column label","Column label","Column label","Column label"]
[null,"Row label"]
[null,"Row label"]
[null,"Row label"]
[null,"(Table finish row)"]
[]
["A more complex table"]
[null,null,null,"Column label (no wrap)",null,"Column label (no wrap)"]
[null,"Column label (left aligned)","Column label (not bold)","Column label","Column label","Column label","Column label"]
[null,"Row label",null,"(Table unshading)",null,"(Table shading)"]
[null,"Row label (indent)"]
[null,"Sub-total row"]
[null,"Total row"]
[]
[]
["Examples of use"]
["NB To avoid having spurious names in this template the names shown below have not actually been created"]
[]
["Number of subscribers (year end)"]
[null,"Service","Units","Notes",2000,2001,2002,2003,"Subscribers.Year End.By Service"]
[null,"Dial-up","Subscribers","Linear interpolation",1000000,{"$f":"E122+($H122-$E122)/3","v":1000000},1000000,1000000]
[null,"ADSL","Subscribers","Linear interpolation",100000,133333.33333333334,166666.66666666669,200000]
[null,"Cable Modem","Subscribers","Linear interpolation",50000,100000,150000,200000]
[null,"Total","Subscribers",null,{"$f":"SUM(E122:E124)","v":1150000},{"$f":"SUM(F122:F124)","v":1233333.3333333333},{"$f":"SUM(G122:G124)","v":1316666.6666666667},{"$f":"SUM(H122:H124)","v":1400000}]
[]
["Number of subscribers (year end)"]
[null,"Service","Units","Notes",2000,2001,2002,2003]
[null,"Dial-up","Subscribers","From above",{"$f":"$E$122:$H$124","v":1000000},1000000,1000000,1000000]
[null,"ADSL","Subscribers","From above",100000,133333.33333333334,166666.66666666669,200000]
[null,"Cable Modem","Subscribers","From Cable_modem.xls",50000,100000,150000,200000]
[null,"Total","Subscribers",null,{"$f":"SUM(E129:E131)","v":1150000},{"$f":"SUM(F129:F131)","v":1233333.3333333333},{"$f":"SUM(G129:G131)","v":1316666.6666666667},{"$f":"SUM(H129:H131)","v":1400000}]
[]
[]
["Number of subscribers (simple year average)"]
[null,"Service","Units","Notes",2000,2001,2002,2003]
[null,"Dial-up","Subscribers",null,null,{"$f":"(F129+E129)/2","v":1000000},1000000,1000000]
[null,"ADSL","Subscribers",null,null,116666.66666666667,150000,183333.33333333334]
[null,"Cable Modem","Subscribers",null,null,75000,125000,175000]
[null,"Total","Subscribers",null,null,{"$f":"SUM(F137:F139)","v":1191666.6666666667},{"$f":"SUM(G137:G139)","v":1275000},{"$f":"SUM(H137:H139)","v":1358333.3333333333},"Subscribers.Year Average.Total"]

{"sheet":"L","index":2,"n_rows":118,"n_cols":14,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[" ",null,"Listas utilizadas en el modelo"]
[]
[null,null,"Hundred, thousand, million"]
[null,null,100,"hundred"]
[null,null,1000,"thousand"]
[null,null,1000000,"million"]
[]
[null,null,"Spare, void and not available"]
[null,null,"espacio vacante","spare"]
[null,null,"void","void"]
[null,null,"N/A","not.available"]
[]
[null,null,"TRUE, FALSE"]
[null,null,true]
[null,null,false]
[null,null,"true.false"]
[]
[null,null,"Lista de activos",null,"Componentes de central de Telmex",null,null,null,"Categorias tamaño de central de Telmex (bluces de abonado)","MIN","MAX","Avg",null,"Componentes del predio"]
[null,1,"Predio",1,"Sala MDF/ODF AEP",null,null,1,"Pequeña",0,499,{"$f":"ROUND(AVERAGE(J19:K19),)","v":250},1,"Area caseta central"]
[null,2,"Central del AEP",2,"Sala coubicación CS",null,null,2,"Media",{"$f":"K19+1","v":500},1499,{"$f":"ROUND(AVERAGE(J20:K20),)","v":1000},2,"Area sala coubicacion externa"]
[null,3,"Sala coubicación externa",3,"Sala de control",null,null,3,"Grande",{"$f":"K20+1","v":1500},4999,3250,3,"Area libre"]
[null,4,"Subestación electrica",4,"Sala de switching del AEP",null,null,4,"Muy grande",5000,1000000,10000,4,"Area total"]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",5,"Sala equipos de transmisión del AEP",null,null,null,"tamaño.central.Telmex",null,null,null,null,"lista.componentes.predio"]
[null,6,"Aire acondicionado",6,"Sala subestacion electrica"]
[null,7,"Racks",7,"Sala planta de emergencia"]
[null,8,{"$f":"spare","v":"espacio vacante"},8,"Sala baterias"]
[null,null,"lista.activos",9,"Espacio de overheads"]
[null,null,null,10,{"$f":"spare","v":"espacio vacante"}]
[null,null,null,11,{"$f":"spare","v":"espacio vacante"}]
[null,null,null,12,{"$f":"spare","v":"espacio vacante"}]
[null,null,null,null,"lista.componentes.central.telmex"]
[]
[null,null,"Propiedad del predio"]
[null,null,"Telmex"]
[null,null,"Tercero en arrendamiento"]
[null,null,"Tercero en comodato"]
[null,null,"propiedad.predio"]
[]
[null,null,"Geotipo (zonas)"]
[null,null,"Alta"]
[null,null,"Media"]
[null,null,"Baja"]
[null,null,{"$f":"spare","v":"espacio vacante"}]
[null,null,"geotipo"]
[]
[null,null,"Año"]
[null,1,2016]
[null,2,{"$f":"C47+1","v":2017}]
[null,3,{"$f":"C48+1","v":2018}]
[null,4,2019]
[null,5,2020]
[null,6,2021]
[null,7,2022]
[null,8,2023]
[null,9,2024]
[null,10,2025]
[null,null,"año"]
[]
[null,null,"Tipo de coubicación"]
[null,1,"Cerrada"]
[null,2,"Basica"]
[null,3,"Equipada"]
[null,null,"tipo.coubicacion"]
[]
[null,null,"Tipo de coubicación cerrada"]
[null,null,4,"m2"]
[null,null,9,"m2"]
[null,null,"tipo.coubicacion.cerrada"]
[]
[null,null,"Check"]
[null,null,"Actualizar selección","actualizar.seleccion"]
[null,null,"ERROR","error"]
[null,null,"OK","ok"]
[]
[null,null,"Sí / No"]
[null,null,"Sí","si"]
[null,null,"No","no"]
[null,null,"disponibilidad"]
[]
[null,null,"Lista de servicios"]
[null,null,"Coubicación"]
[null,null,"Subestación electrica"]
[null,null,"Fuente de energia de respaldo"]
[null,null,"Aire acondicionado"]
[null,null,"Racks"]
[null,null,"lista.servicios"]
[]
[null,null,"Corriente de energia"]
[null,null,"DC_48V"]
[null,null,"AC_127V"]
[null,null,"corriente.energia"]
[]
[null,null,"Vida útil del activo"]
[null,1,"Economica"]
[null,2,"Contable"]
[null,null,"vida.util"]
[]
[null,null,"Costos considerados"]
[null,null,"Corrientes"]
[null,null,"Históricos"]
[null,null,"costos.considerados"]
[]
[null,null,"Perfil de recuperación de costos"]
[null,null,"Anualidad"]
[null,null,"Depreciación lineal"]
[null,null,"perfil.recuperacion.costos"]
[]
[]
[null,null,"Factores de conversion"]
[null,null,3.5169999999999999,"kW.por.ton"]
[null,null,24,"horas.por.dia"]
[null,null,30,"dias.por.mes"]
[null,null,12,"meses.por.año"]
[]
[null,null,"Perfil de recuperación de costos"]
[null,null,"Generador diesel"]
[null,null,"Baterias"]
[null,null,"opcion.fuente.energia.respaldo"]

{"sheet":"Control","index":3,"n_rows":137,"n_cols":13,"rows_kept":137,"cut":false,"hidden":false,"merged":[[2,4,2,5]]}
["Panel de control",null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,"CHECK de los parametros eligidos",{"$f":"IF(AND(H78=ok,H80=ok,K84=ok,H81=ok,H69=ok,H70=ok,H71=ok,H74=ok),ok,actualizar.seleccion)","v":"OK"}]
[]
[null,null,null,"Elemento","Unidad","Valor","Nombre 1","Check / Indices","Nombre 2",null,"Notas"]
[]
["Resultados"]
[null,"Contraprestacion mensual por CS"]
[]
[null,null,"Coubicacion cerrada",null,null,"Contraprestación mensual"]
[null,null,null,{"$f":"\"Zona \"&geotipo.activo&\", \"&tipo.coubicacion.activo&\" , \"&IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,\"con respaldo\", \"sin respaldo\")","v":"Zona Media, Cerrada , con respaldo"},"m2",{"$f":"IF(tipo.coubicacion.activo<>\"Cerrada\",0,Precio!J195/espacio.coubicacion.cerrada/12)","v":962.19497049621452},"output.coubicacion.cerrada"]
[]
[null,null,"Coubicacion basica",null,null,"Contraprestación mensual"]
[null,null,null,{"$f":"\"Zona \"&geotipo.activo&\", \"&tipo.coubicacion.activo&\" , \"&IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,\"con respaldo\", \"sin respaldo\")","v":"Zona Media, Cerrada , con respaldo"},"20 m2",{"$f":"IF(tipo.coubicacion.activo<>\"Basica\",0,Precio!J195/espacio.coubicacion.basica/12)*20","v":0},"output.coubicacion.basica"]
[]
[null,null,"Coubicacion equipada",null,null,"Contraprestación mensual"]
[null,null,null,{"$f":"\"Zona \"&geotipo.activo&\", \"&tipo.coubicacion.activo&\" , \"&IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,\"con respaldo\", \"sin respaldo\")","v":"Zona Media, Cerrada , con respaldo"},"por rack",{"$f":"IF(tipo.coubicacion.activo<>\"Equipada\",0,Precio!J195/F38/12)","v":0},"output.coubicacion.equipada"]
[]
["Control"]
[null,"Tipo de coubicacion"]
[null,null,"Tipo de coubicacion"]
[]
[null,null,null,"Tipo de coubicacion",null,"Cerrada","tipo.coubicacion.activo",{"$f":"INDEX(L!$B$60:$B$62,MATCH(tipo.coubicacion.activo,tipo.coubicacion,0))","v":1}]
[]
[null,null,"Parámetros de coubicación cerrada"]
[]
[null,null,null,"Espacio requerido por los CSs","m2",{"$f":"F28*numero.CS.activo","v":22.96},"espacio.coubicacion.cerrada"]
[null,null,null,"Espacio requerido por cada CS","m2",4]
[]
[null,null,"Parámetros de coubicación básica"]
[]
[null,null,null,"Espacio requerido total","m2",20,"espacio.coubicacion.basica"]
[]
[null,null,"Parámetros de coubicación equipada"]
[]
[null,null,null,"Solicitación de racks",null,{"$f":"IF(tipo.coubicacion.activo=\"Equipada\",TRUE,FALSE)","v":false},"solicitacion.racks.activo"]
[]
[null,null,null,"Unidades racks totales","#",12,"espacio.racks.activo",{"$f":"F38*solicitacion.racks.activo*calculos.secundarios.dimension.racks","v":0}]
[]
[null,"Demanda"]
[null,null,"Características del sitio"]
[null,null,null,"Geotipo",null,"Media","geotipo.activo"]
[null,null,null,"Propriedad del predio",null,"Tercero en arrendamiento","propriedad.predio.activo"]
[null,null,null,"ID del predio",null,{"$f":"propriedad.predio.activo&geotipo.activo","v":"Tercero en arrendamientoMedia"},"id.predio.activo"]
[null,null,null,"Bucles terminados en la central","#",1450,"bucles.central.telmex"]
[null,null,null,"Dimensión de la central",null,{"$f":"INDEX(tamaño.central.Telmex,MATCH(bucles.central.telmex,L!$J$19:$J$22,1))","v":"Media"},"tipo.central.telmex.activa"]
[null,null,null,"Número de plantas","#",{"$f":"IF(OR(tipo.central.telmex.activa=L!I19,tipo.central.telmex.activa=L!I20),2,3)","v":2},"numero.plantas.central.telmex.activo"]
[]
[null,null,null,"ID de la central",null,{"$f":"tipo.central.telmex.activa&geotipo.activo","v":"MediaMedia"},"id.central.telmex.activo"]
[]
[null,null,"Parámetros de escenario"]
[]
[null,null,null,"Año activo","año",2017,"año.activo"]
[null,null,null,"WACC","%",9.9099999999999994E-2,"wacc",null,null,null,"Fuente: WACC calculado para el modelo de interconexión fija"]
[]
[null,null,null,"Vida útil",null,"Economica","vida.util.activo",{"$f":"INDEX(L!B94:B95,MATCH(vida.util.activo,vida.util,0))","v":1},"vida.util.activo.indice"]
[null,null,null,"Costos considerados",null,"Corrientes","costos.considerados.activo",{"$f":"MATCH(costos.considerados.activo,costos.considerados,0)","v":1},"costos.considerados.activo.indice"]
[null,null,null,"Perfil de la recuperación de costes",null,"Anualidad","perfil.recuperacion.costos.activo",{"$f":"MATCH(perfil.recuperacion.costos.activo,perfil.recuperacion.costos,0)","v":1},"perfil.recuperacion.costos.activo.indice"]
[]
[null,null,null,"Mark-up de gastos comunes - capex y opex"]
[null,null,null,"Overhead mark-up capex","%",0.08,"markup.overhead.capex"]
[null,null,null,"Overhead mark-up opex","%",0.08,"markup.overhead.opex"]
[]
[null,null,"Parametros de coubicacion"]
[]
[null,null,null,"Espacio incremental asignado a CS",null,true,"espacio.incremental.activo"]
[]
[null,null,null,"Número medio de CS activos por geotipo"]
[null,null,null,{"$f":"geotipo","v":"Alta"},null,6.24,"numero.CS.activo.alta",{"$f":"IF(numero.CS.activo.alta>0,ok, error)","v":"OK"}]
[null,null,null,"Media",null,5.74,"numero.CS.activo.media",{"$f":"IF(numero.CS.activo.media>0,ok, error)","v":"OK"}]
[null,null,null,"Baja",null,2.5099999999999998,"numero.CS.activo.baja",{"$f":"IF(numero.CS.activo.baja>0,ok, error)","v":"OK"}]
[null,null,null,"espacio vacante",null,0]
[]
[null,null,null,"Número de CS activos (igual para todos geotipos)",null,2,null,{"$f":"IF(F74>0,ok, error)","v":"OK"}]
[]
[null,null,null,"¿Número de CS establecido por geotipo?",null,true,"CS.por.geotipo"]
[]
[null,null,null,"Número de CS activos","#",{"$f":"IF(AND(IF(F76=FALSE,F74,INDEX(F69:F72,MATCH(geotipo.activo,geotipo,0)))>5,NOT(tipo.coubicacion.activo=L!C60)),5,IF(F76=FALSE,F74,INDEX(F69:F72,MATCH(geotipo.activo,geotipo,0))))","v":5.74},"numero.CS.activo",{"$f":"IF(numero.CS.activo>0,ok, error)","v":"OK"}]
[]
[null,null,null,"CS activos con CE","#",0,"numero.CS.activo.CE",{"$f":"IF(numero.CS.activo.CE>=0,ok, error)","v":"OK"},null,null,"CI = Coubicación Interna, CE = Coubicación Externa"]
[null,null,null,"CS activos con CI","#",{"$f":"numero.CS.activo-numero.CS.activo.CE","v":5.74},"numero.CS.activo.CI",{"$f":"IF(numero.CS.activo.CI>=0,ok,error)","v":"OK"}]
[]
[null,null,null,"Espacio exclusivo para AEP","m2",{"$f":"area.sala.MDF.AEP+area.sala.switching+area.sala.transmision","v":55.488},null,{"$f":"F83","v":55.488},"espacio.exclusivo.AEP"]
[null,null,null,"Espacio coubicación por CS","m2",{"$f":"CHOOSE($H$23,$F$28,$F$32/numero.CS.activo,espacio.racks.activo/numero.CS.activo)*G84","v":4},true,{"$f":"F84","v":4},"espacio.coubicacion.activo.porCS",null,{"$f":"IF(espacio.coubicacion.activo.porCS<4,error,ok)","v":"OK"}]
[]
[null,null,null,"Asignación de espacio de las salas de la central del AEP a los CS "]
[null,null,null,"Sala de control",null,{"$f":"espacio.incremental.activo","v":true},"sala.control.CS.activo"]
[null,null,null,"Sala de switching",null,{"$f":"FALSE","v":false},"sala.switching.CS.activo",null,null,null,"La sala es de exclusiva utilizacion del AEP"]
[null,null,null,"Sala equipos de transmision del AEP",null,{"$f":"FALSE","v":false},"sala.equipos.transmision.CS.activo",null,null,null,"La sala es de exclusiva utilizacion del AEP"]
[null,null,null,"Sala subestacion electrica",null,{"$f":"espacio.incremental.activo","v":true},"sala.subestacion.electrica.CS.activo"]
[null,null,null,"Sala planta de emergencia",null,{"$f":"espacio.incremental.activo","v":true},"sala.planta.emergencia.CS.activo"]
[null,null,null,"Sala baterias",null,{"$f":"espacio.incremental.activo","v":true},"sala.baterias.CS.activo"]
[null,null,null,"Espacio de overheads (pasillos, escaleras, servicios, etc.)",null,{"$f":"espacio.incremental.activo","v":true},"espacio.overheads.CS.activo"]
[]
[null,null,"Consumo de energia "]
[null,null,null,"Corriente de energia",null,"AC_127V","corriente.energia.activa"]
[null,null,null,"Factor de conversión kW a kVA",null,{"$f":"1/0.8","v":1.25},"factor.conversion.kW.kVA"]
[null,null,null,"Factor de conversión kVA a kW",null,0.8,"factor.conversion.kVA.kW"]
[null,null,null,"Consumo de los equipos del AEP","kW",{"$f":"F83/20*F100","v":61.536192},null,null,"consumo.equipos.AEP"]
[null,null,null,"Consumo medio para 20m2 de coubicación","kW",22.18]
[null,null,null,"Consumo para coubicacion solicitada","kW",{"$f":"espacio.coubicacion.activo.porCS*numero.CS.activo/20*F100","v":25.462640000000004}]
[null,null,null,"Consumo de los equipos por CS","kW",{"$f":"F101/numero.CS.activo","v":4.4360000000000008},null,{"$f":"F102","v":4.4360000000000008},"consumo.equipos.porCS"]
[]
[null,"Parámetros para el dimensionamiento"]
[null,null,"Reglas de dimensionamiento"]
[null,null,null,"Aire acondicionado"]
[null,null,null,"Solicitacion de aire acondicionado",null,true,"solicitacion.aire.acondicionado.activo",null,null,null,"Todos o ninguno, porque estan en la misma sala de CI"]
[null,null,null,"Capacidad de aire acondicionado requerida / utilizada por unidad de superficie","ton/m2",0.1,"aire.acondicionado.capacidad.superficie"]
[null,null,null,"Espacio maniobra (% del espacio de las salas)",null,0.05,"aire.acondicionado.espacio.maniobra",{"$f":"solicitacion.aire.acondicionado.activo*F109","v":0.05}]
[]
[null,null,null,"Fuente de energia de respaldo (grupos electrogenos Diesel + baterias)"]
[null,null,null,"Solicitación de fuente de energia de respaldo - AEP",null,{"$f":"TRUE","v":true},"fuente.energia.respaldo.activo.AEP"]
[null,null,null,"Solicitación de fuente de energia de respaldo - CS",null,true,"solicitacion.fuente.energia.respaldo.activo.CS"]
[null,null,null,"Opción de fuente de energia de respaldo",null,"Generador Diesel + Baterias","opcion.fuente.energia.respaldo.activa",null,null,null,"Fuente: Telmex"]
[null,null,null,"Potencia fuente en % potencia transformadores","%",0.8,"capacidad.fuente.energia.respaldo",null,null,null,"% de la potencia de los transformadores que debe ser cubierta por la fuente de energia de respaldo (generador)"]
[null,null,null,"Horas de respaldo (baterias)","horas",{"$f":"IF(geotipo.activo=\"Baja\",backup.minimo.baterias.rural,backup.minimo.baterias.urbano)","v":4},"horas.backup.fuente.energia.respaldo.baterias",null,null,null,"Bancos de Baterías, proporciona la energía eléctrica de corriente directa en caso de pérdida de corriente alterna de la máquina de emergencia y/o de la acometida de CFE."]
[null,null,null,"Backup (horas) en zonas urbanas","horas",4,"backup.minimo.baterias.urbano",null,null,null,"El tiempo de respaldo de las baterías depende de si se cuenta o no con máquina de emergencia en el sitio y el tiempo que tarda en llegar personal de mantenimiento desde el centro de mantenimiento más próximo. El tiempo de respaldo puede variar, siendo el mínimo de 4 horas."]
[null,null,null,"Backup (horas) en zonas rurales","horas",8,"backup.minimo.baterias.rural",null,null,null,"Asumimos 8 horas en zonas rurales para reflejar la mayor probabilided de cortes"]
[null,null,null,"Horas de respaldo (generador diesel)","horas",{"$f":"IF(geotipo.activo=\"Baja\",backup.minimo.generador.diesel.rural,backup.minimo.generador.diesel.urbano)","v":24},"horas.backup.fuente.energia.respaldo.generador.diesel",null,null,null,"Máquina de emergencia (Motor de Combustión Interna acoplado a un Generador), el cual genera corriente alterna a 220/127 V y que sustituye a la acometida de CFE en caso de interrupción. "]
[null,null,null,"Backup (horas) en zonas urbanas","horas",24,"backup.minimo.generador.diesel.urbano",null,null,null,"Se dimensionan por la carga que deben soportar en cada sitio atendiendo principalmente plantas de rectificación, aire acondicionado y alumbrado de emergencia. El combustible (Diesel) normado es para 48 horas continuas de operación. Para area urbanas elegimos reflejar una eficiencia mayor debido a la mayor calidad de la red electrica en zonas urbanas."]
[null,null,null,"Backup (horas) en zonas rurales","horas",48,"backup.minimo.generador.diesel.rural",null,null,null,"Se dimensionan por la carga que deben soportar en cada sitio atendiendo principalmente plantas de rectificación, aire acondicionado y alumbrado de emergencia. El combustible (Diesel) normado es para 48 horas continuas de operación."]
[]
[null,null,"Otros parametros de dimensionamiento"]
[]
[null,null,null,"Predio"]
[null,null,null,"Predio adicional con respecto al terreno necesario para el edificio de la central (area predio >> area central)",null,true,"predio.activo",null,null,null,"El mark-up representa la área adicional al espacio ocupado por la central y sala de coubicacion externa"]
[null,null,null,"Mark-up area ocupada -> area total, para predios urbanos","%",{"$f":"50%","v":0.5},"markup.predio"]
[null,null,null,"Mark-up area predio urbano -> area predio rural","%",{"$f":"IF(geotipo.activo=\"Baja\",0.2,0)*predio.activo","v":0},"markup.zona.rural"]
[null,null,null,"Área libre asignada a CS",null,{"$f":"espacio.incremental.activo","v":true},"area.libre.CS",null,null,null,"Permite elegir si los costos de la área no ocupada del predio son asignados a los CS"]
[]
[null,null,null,"Caseta central"]
[null,null,null,"Mark-up espacio overheads","%",0.1,"markup.espacio.overheads",{"$f":"F132*espacio.incremental.activo","v":0.1}]
[null,null,null,"Mark-up area salas  -> area exterior","%",0,"markup.area.exterior.central.telmex"]
[]
[null,null,null,"Sala de coubicacion"]
[null,null,null,"Mark-up para sala AEP","%",0,"markup.sala.AEP"]
[null,null,null,"Mark-up para sala CS","%",0,"markup.sala.CS"]

{"sheet":"Caracteristicas tecnicas","index":4,"n_rows":111,"n_cols":17,"rows_kept":111,"cut":false,"hidden":false,"merged":[[60,3,60,4],[107,3,107,4]]}
["Caracteristicas tecnicas"]
[]
["Dimensionado de las salas",null,"Unidad",null,null,null,null,"Nombre","Fuente / Notas","Notas"]
[null,null,null,null,2.5,2,1.5]
[null,null,null,{"$f":"TRANSPOSE(tamaño.central.Telmex)","v":"Pequeña"},"Media","Grande","Muy grande","calculos.secundarios.tamano.caseta"]
[null,"Sala MDF/ODF AEP","m2",{"$f":"D22","v":13.673999999999999},14.447999999999999,16.77,22.962,"calculos.secundarios.Sala MDF"]
[null,"Sala de control","m2",10,10,15,15,"calculos.secundarios.Sala de control"]
[null,"Sala de switching / DSLAM del AEP","m2",{"$f":"D30","v":15.959999999999999},20.52,29.639999999999997,38.76,"calculos.secundarios.Sala de switching del AEP"]
[null,"Sala equipos de transmisión del AEP","m2",{"$f":"D8","v":15.959999999999999},20.52,29.639999999999997,38.76,"calculos.secundarios.Sala equipos de transmisión del AEP"]
[]
[]
[null,"Estimacion bottom-up del tamaño de la sala MDF"]
[null,"Blucles promedio entrantes en la central","#",{"$f":"TRANSPOSE(L!L19:L22)","v":250},1000,3250,10000]
[null,"Overhead para dimensionamiento MDF","%",0.5,0.5,0.5,0.5,null,"Fuente: Politecnico di Torino / Telecom Italia"]
[null,"Bucles para dimensionamiento de MDF","#",{"$f":"D13*(1+D14)","v":375},{"$f":"E13*(1+E14)","v":1500},4875,15000]
[null,"Espacio ocupado por un modulo MDF para 800 bucles","bucles",800,{"$f":"D16","v":800},800,800,null,"Fuente: Politecnico di Torino / Telecom Italia"]
[null,"Ancho","m",0.18,{"$f":"D17","v":0.18},0.18,0.18,"(a)"]
[null,"Produndidad","m",1.3,{"$f":"D18","v":1.3},{"$f":"E18","v":1.3},1.3,"(p)"]
[null,"Numero minimo de modulos","#",1,{"$f":"D19","v":1},1,1]
[null,"Numero de modulos requeridos","#",{"$f":"MAX(D19,ROUNDUP(D13/D16,))","v":1},{"$f":"MAX(E19,ROUNDUP(E13/E16,))","v":2},{"$f":"MAX(F19,ROUNDUP(F13/F16,))","v":5},{"$f":"MAX(G19,ROUNDUP(G13/G16,))","v":13},"(n)"]
[null,"Espacio de maniobra (por lado)","m",1.5,1.5,1.5,1.5,"(d)","Incluye espacio para aire acondicionados y nichos de acometida"]
[null,"Dimensiones sala MDF","m2",{"$f":"(D20*D17+2*D21)*(D18+2*D21)","v":13.673999999999999},{"$f":"(E20*E17+2*E21)*(E18+2*E21)","v":14.447999999999999},{"$f":"(F20*F17+2*F21)*(F18+2*F21)","v":16.77},{"$f":"(G20*G17+2*G21)*(G18+2*G21)","v":22.962},"=(n*a+2*d)*(p+2*d)"]
[]
[null,"Estimacion bottom-up del tamaño de la sala switch / DSLAM"]
[null,"Dimensiones estandar de un rack"]
[null,"Ancho","m",0.6,{"$f":"D26","v":0.6},0.6,0.6]
[null,"Profundidad","m",0.8,{"$f":"D27","v":0.8},0.8,0.8]
[null,"Espacio de maniobra (por lado)","m",{"$f":"D$21","v":1.5},1.5,1.5,1.5]
[null,"Numero de racks","#",2,4,8,12]
[null,"Dimensiones sala switching / DSLAM","m2",{"$f":"(D29*D26+2*D28)*(D27+2*D28)","v":15.959999999999999},{"$f":"(E29*E26+2*E28)*(E27+2*E28)","v":20.52},29.639999999999997,38.76]
[]
[null,"Estimacion bottom-up del tamaño de la sala transmisión"]
[null,"Dimensiones estandar de un rack"]
[null,"Ancho","m",{"$f":"D26","v":0.6},0.6,0.6,0.6]
[null,"Profundidad","m",0.8,0.8,0.8,0.8]
[null,"Espacio de maniobra (por lado)","m",{"$f":"D$21","v":1.5},1.5,1.5,1.5]
[null,"Numero de racks","#",2,4,8,12]
[null,"Dimensiones sala transmisión","m2",{"$f":"(D37*D34+2*D36)*(D35+2*D36)","v":15.959999999999999},{"$f":"(E37*E34+2*E36)*(E35+2*E36)","v":20.52},{"$f":"(F37*F34+2*F36)*(F35+2*F36)","v":29.639999999999997},{"$f":"(G37*G34+2*G36)*(G35+2*G36)","v":38.76}]
[]
[]
[null,"Dimensionado de las salas de energia"]
[]
[null,null,null,"Dimensionado"]
[null,"Espacio ocupado por subestacion electrica (sin espacio de manobra)","m2/kW",0.5,"calculos.secundarios.Sala subestacion electrica"]
[null,"Espacio ocupado por la planta de emergencia (sin espacio de manobra)","m2",{"$f":"INDEX($I$52:$I$59,IFERROR(MATCH(C49-0.000001,$B$52:$B$59,1),0)+1)+INDEX($C$52:$C$59,IFERROR(MATCH(C49-0.000001,$B$52:$B$59,1),0)+1)","v":4.6959473684210531},"calculos.secundarios.Sala planta de emergencia",null,null,null,"Fuente: http://www.ottomotores.com.mx/grupos_electrogenos"]
[null,"Espacio ocupado por bateria de c. 200-230Ah (sin espacio de manobra)","m2/bateria",7.0000000000000007E-2,"m2.por.bateria",null,null,null,"Fuente: en Ericsson BBS (ver foto abajo) caben 4 baterias en un espacio de 0.22m2 -> 0.06m2 por bateria. Segun este otro provedor las baterias ocupan 0.2x0.36=0.07m2\n/ http://www.electriccarpartscompany.com/40V-48V-58V-br-200Ah-9kW-11kW-br-2C-3C-EV-Hybrid-Battery-Pack-br-UL-CE-SGS-RoHS-RBRC-ISO-and-TS-Certified-br-Custom-Lithium-LiFePO4-Cylindrical-Battery-Pack-br-Custom-Built-Cylindrical-Li-ion-LiPo-Battery-Pack_p_127.html"]
[]
[]
[null,"Consumo de los equipos subestación eléctrica para FER",{"$f":"potencia.minima.fuente.energia.respaldo*factor.conversion.kW.kVA","v":86.998832000000007},"kVA",{"$f":"INDEX($F$52:$F$59,IFERROR(MATCH(C49-0.000001,$B$52:$B$59,1),0)+1)*(C49/INDEX($B$52:$B$59,IFERROR(MATCH(C49-0.000001,$B$52:$B$59,1),0)+1))","v":431.51420672},"litros"]
[]
[null,"Potencia del generador diesel (kVA)","m2 (motor + generador)",null,"consumo (l/h) @ 100%","consumo (l/h) @ 100% @ backup","metros cubicos requeridos","altura (m)","metros cuadrados requeridos"]
[null,375,3.7170000000000001,null,{"$f":"AVERAGE(I85:I86)","v":77.5},{"$f":"E52*horas.backup.fuente.energia.respaldo.generador.diesel","v":1860},{"$f":"F52/1000","v":1.86},{"$f":"AVERAGE(O85:O86)/100","v":1.9},{"$f":"G52/H52","v":0.97894736842105268}]
[null,500,4.0949999999999998,null,{"$f":"AVERAGE(I87:I88)","v":103},2472,{"$f":"F53/1000","v":2.472},{"$f":"AVERAGE(O87:O88)/100","v":1.9750000000000001},{"$f":"G53/H53","v":1.2516455696202531}]
[null,750,5.6924999999999999,null,{"$f":"AVERAGE(I89:I91)","v":133.33333333333334},3200,3.2,{"$f":"AVERAGE(O89:O91)/100","v":2.0866666666666664},1.5335463258785944]
[null,1000,8.3955000000000002,null,{"$f":"AVERAGE(I92:I93)","v":203.5},4884,4.8840000000000003,{"$f":"AVERAGE(O92:O93)/100","v":2.31},2.1142857142857143]
[null,1500,10.1835,null,{"$f":"AVERAGE(I94:I96)","v":273.33333333333331},6560,6.56,{"$f":"AVERAGE(O94:O96)/100","v":2.5033333333333334},2.6205059920106524]
[null,2200,11.9328,null,{"$f":"AVERAGE(I97:I99)","v":424.33333333333331},10184,10.183999999999999,{"$f":"AVERAGE(O97:O99)/100","v":2.85},3.5733333333333328]
[null,2500,27.36,null,{"$f":"AVERAGE(I100:I101)","v":574},13776,13.776,{"$f":"AVERAGE(O100:O101)/100","v":3},4.5919999999999996]
[null,3125,30,null,{"$f":"AVERAGE(I102:I105)","v":713.75},17130,17.13,{"$f":"AVERAGE(O102:O105)/100","v":3.15},5.4380952380952383]
[]
["Equipos electricos",null,null,"Unidad",null,null,null,"Nombre","Fuente / Notas","Notas"]
[]
[null,"Baterias"]
[null,null,null,null,null,null,null,null,"Fuente: http://www.meibat.com/en/references/List/show/telecomunications-175"]
[null,null,"V","Ah",null,null,null,null,"Fuente: Ericsson"]
[null,"Tipo de baterias que el modelo asume",48,200]
[]
[null,"Interpolacion de datos Ericsson","power","minutes"]
[null,"x1",{"$f":"1220/thousand","v":1.22},{"$f":"7.6*60","v":456},"y1"]
[null,"x2",{"$f":"1970/thousand","v":1.97},{"$f":"4.4*60","v":264},"y2"]
[null,"Slope:",{"$f":"(D69-D70)/(C69-C70)","v":-256}]
[null,"Equation",{"$f":"-((C71*C69)-D69)","v":768.31999999999994}]
[]
[]
[]
[null,"Dimensionamento de baterias"]
[null,"Consumo de los equipos para FER",{"$f":"potencia.minima.fuente.energia.respaldo","v":69.599065600000003},"kW"]
[null,"Horas minimas de backup",{"$f":"horas.backup.fuente.energia.respaldo.baterias","v":4},"h"]
[null,"Capacidad de baterias con con el backup definido",{"$f":"(C72-C78*60)/-C71","v":2.0637499999999998},"kW"]
[null,"Numero de baterias",{"$f":"ROUNDUP(C77/C79,0)","v":34},"numero.baterias"]
[]
[null,"Generador diesel"]
[]
[null,"Modelo","kVA","KWe","kVA","KWe","Motor","Cilindros","Consumo de combustible @ 100% de la carga en litros/hr","Generador","Dimensiones (largo x ancho x alto) cm","KG","Largo (cm)","Ancho (cm)","Alto (cm)","kVA","m2"]
[null,"TLY250",312,250,"N/A","N/A","6R1600G70S",6,74,"LSA46.2L6","315 x 118 x 190",2099,315,118,190,{"$f":"C85","v":312},{"$f":"M85*N85/10000","v":3.7170000000000001}]
[null,"TLY300",375,300,"N/A","N/A","6R1600G80S",6,81,"LSA46.2L6","315 x 118 x 190",2164,315,118,190,375,3.7170000000000001]
[null,"TLY350",437,350,"N/A","N/A","8V1600G70S",8,99,"LSA47.2VS2","315 x 125 x 196",2605,315,125,196,437,3.9375]
[null,"TLY400",500,400,"N/A","N/A","8V1600G80S",8,107,"LSA47.2VS2","315 x 130 x 199",2676,315,130,199,500,4.0949999999999998]
[null,"TLY450",562,450,"N/A","N/A","10V1600G70S",10,126,"LSA47.2S4","345 x 125 x 204",3724,345,125,204,562,4.3125]
[null,"TLY500",625,500,"N/A","N/A","10V1600G80S",10,124,"LSA47.2S5","345 x 125 x 204",3724,345,125,204,625,4.3125]
[null,"TLY600",750,600,"N/A","N/A","12V1600G80S",12,150,"LSA47.2M8","345 x 165 x 218",3537,345,165,218,750,5.6924999999999999]
[null,"TLY700",875,700,875,700,"12V2000G45",12,190,"LSA49.1S4","435 x 193 x 231",5176,435,193,231,875,8.3955000000000002]
[null,"TLY800",1000,800,1000,800,"12V2000G85",12,217,"LSA49.1M7","435 x 193 x 231",5576,435,193,231,1000,8.3955000000000002]
[null,"TLY900",1125,900,1125,900,"16V2000G45",16,241,"LSA49.1L9","465 x 219 x 249",6188,465,219,249,1125,10.1835]
[null,"TLY1000",1250,1000,1250,1000,"16V2000G85",16,267,"LSA49.1L11","465 x 219 x 249",6298,465,219,249,1250,10.1835]
[null,"TLY1200",1500,1200,1500,1200,"18V2000G85",18,312,"LSA50.2M6","465 x 219 x 253",7717,465,219,253,1500,10.1835]
[null,"TLY1250",1562,1250,1562,1250,"12V4000G43",12,407,"LSA50.2M6","528 x 226 x 285",11204,528,226,285,1562,11.9328]
[null,"TLY1500",1875,1500,1875,1500,"12V4000G43",12,407,"LSA50.2L7","528 x 226 x 285",11474,528,226,285,1875,11.9328]
[null,"TLY1750",2187,1750,2187,1750,"12V4000G83",12,459,"LSA50.2VL10","528 x 226 x 285",11974,528,226,285,2187,11.9328]
[null,"TLY2000",2500,2000,2500,2000,"16V4000G43",16,538,"LS641S55","720 x 380 x 300",20200,720,380,300,2500,27.36]
[null,"TLY2250",2812,2250,2812,2250,"16V4000G83",16,610,"LS641L70","720 x 380 x 300","C/F",720,380,300,2812,27.36]
[null,"TLY2500",3125,2250,3125,2250,"16V4000G83L",16,688,"LS641VL90","720 x 380 x 300","C/F",720,380,300,3125,27.36]
[null,"TLY2500",3125,2500,3125,2500,"20V4000G43",20,624,"LS641VL90","750 x 400 x 320","C/F",750,400,320,3125,30]
[null,"TLY2800",3500,2500,3500,2500,"20V4000G83",20,703,"LS841M70","750 x 400 x 320","C/F",750,400,320,3500,30]
[null,"TLY3250",4062,3250,4062,3250,"20V4000G83L",20,840,"LS841VL85","750 x 400 x 320","C/F",750,400,320,4062,30]
[]
[]
["Racks"]
[null,"Racks",null,null,"Unidad","Nombre",null,null,"Fuente"]
[]
[null,"Dimension de los racks",null,"m2",{"$f":"20/12","v":1.6666666666666667},"calculos.secundarios.dimension.racks",null,null,"Telmex"]

{"sheet":"Dimensionado","index":5,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":false,"merged":[]}
["Dimensionado",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,"Elemento","Unidad","Valor","Nombre",null,"Notas"]
[]
["Uso de Sitios, Predios y Espacios Físicos"]
[1,{"$f":"INDEX(lista.activos,$A6)","v":"Predio"}]
[]
[null,null,null,"Área ocupada","m2",{"$f":"area.exterior.central.telmex+area.sala.coubicacion.externa.CS","v":76.233764578947373},"area.ocupada.predio"]
[null,null,null,"Mark-up para área total","%",{"$f":"markup.predio*predio.activo","v":0.5}]
[null,null,null,"Mark-up zona rural","%",{"$f":"markup.zona.rural","v":0}]
[null,null,null,"Área total","m2",{"$f":"F8*(1+F9)*(1+F10)","v":114.35064686842105},"area.total.predio"]
[]
[2,{"$f":"INDEX(lista.activos,$A13)","v":"Central del AEP"}]
[]
[null,null,null,"Área de las salas","m2",{"$f":"(area.sala.MDF.AEP+area.sala.coubicacion.CS+area.sala.control+area.sala.switching+area.sala.transmision+area.sala.subestacion.electrica+area.sala.emergencia+area.sala.baterias+area.espacio.overheads)","v":152.46752915789475},"area.salas.central.telmex"]
[null,null,null,"Área exterior caseta central","m2",{"$f":"area.salas.central.telmex*(1+markup.area.exterior.central.telmex)/numero.plantas.central.telmex.activo","v":76.233764578947373},"area.exterior.central.telmex",null,"Nota: La area exterior de la central de Telmex es la suma de la area de las salas, didivido por el numero de pisos, multiplicado por un mark-up (para se considerar las areas comunes y de construccion)"]
[]
[null,1,{"$f":"INDEX(lista.componentes.central.telmex,$B18)","v":"Sala MDF/ODF AEP"}]
[]
[null,null,null,"Sala MDF/ODF AEP","m2",{"$f":"INDEX(calculos.secundarios.Sala_MDF,MATCH(tipo.central.telmex.activa,calculos.secundarios.tamano.caseta,0))","v":14.447999999999999},"area.sala.MDF.AEP"]
[]
[null,2,{"$f":"INDEX(lista.componentes.central.telmex,$B22)","v":"Sala coubicación CS"}]
[]
[null,null,null,"Dimensionamento sala coubicacion CS","m2",{"$f":"numero.CS.activo.CI*espacio.coubicacion.activo.porCS*(1+markup.sala.CS)","v":22.96},"area.sala.coubicacion.CS"]
[]
[null,3,{"$f":"INDEX(lista.componentes.central.telmex,$B26)","v":"Sala de control"}]
[]
[null,null,null,"Dimensionamento sala de control","m2",{"$f":"INDEX(calculos.secundarios.Sala_de_control,MATCH(tipo.central.telmex.activa,calculos.secundarios.tamano.caseta,0))","v":10},"area.sala.control"]
[]
[null,4,{"$f":"INDEX(lista.componentes.central.telmex,$B30)","v":"Sala de switching del AEP"}]
[]
[null,null,null,"Dimensionamento sala de switching","m2",{"$f":"INDEX(calculos.secundarios.Sala_de_switching,MATCH(tipo.central.telmex.activa,calculos.secundarios.tamano.caseta,0))","v":20.52},"area.sala.switching"]
[]
[null,5,{"$f":"INDEX(lista.componentes.central.telmex,$B34)","v":"Sala equipos de transmisión del AEP"}]
[]
[null,null,null,"Dimensionamento sala de transmision","m2",{"$f":"INDEX(calculos.secundarios.Sala_equipos_de_transmisión_del_AEP,MATCH(tipo.central.telmex.activa,calculos.secundarios.tamano.caseta,0))","v":20.52},"area.sala.transmision"]
[]
[null,6,{"$f":"INDEX(lista.componentes.central.telmex,$B38)","v":"Sala subestacion electrica"}]
[]
[null,null,null,"Dimensionamento sala de subestacion electrica","m2",{"$f":"area.sala.subestacion.electrica.AEP+area.sala.subestacion.electrica.CSs","v":43.499416000000004},"area.sala.subestacion.electrica"]
[]
[null,null,null,"Espacio requerido AEP","m2",{"$f":"IF(tipo.central.telmex.activa=\"Pequeña\",0,consumo.equipos.AEP*calculos.secundarios.Sala_subestacion_electrica)","v":30.768096},"area.sala.subestacion.electrica.AEP"]
[null,null,null,"Espacio requerido CSs","m2",{"$f":"IF(tipo.central.telmex.activa=\"Pequeña\",0,consumo.equipos.porCS*numero.CS.activo*calculos.secundarios.Sala_subestacion_electrica)","v":12.731320000000004},"area.sala.subestacion.electrica.CSs"]
[]
[null,7,{"$f":"INDEX(lista.componentes.central.telmex,$B45)","v":"Sala planta de emergencia"}]
[]
[null,null,null,"Mark-up espacio de operación","%",0.5]
[]
[null,null,null,"Dimensionamento sala de emergencia","m2",{"$f":"calculos.secundarios.Sala_planta_de_emergencia*(1+F47)","v":7.0439210526315801},"area.sala.emergencia"]
[]
[null,8,{"$f":"INDEX(lista.componentes.central.telmex,$B51)","v":"Sala baterias"}]
[]
[null,null,null,"Mark-up espacio de operación","%",0.5,null,null,"El calculo del espacio ya incluye el espacio de manobra"]
[]
[null,null,null,"Dimensionamento sala de baterias","m2",{"$f":"m2.por.bateria*numero.baterias*(1+F53)","v":3.5700000000000003},"area.sala.baterias"]
[]
[]
[null,9,{"$f":"INDEX(lista.componentes.central.telmex,$B58)","v":"Espacio de overheads"}]
[]
[null,null,null,"Dimensionamento de espacio de overheads","m2",{"$f":"(area.sala.MDF.AEP+area.sala.coubicacion.CS+area.sala.control+area.sala.switching+area.sala.transmision+area.sala.emergencia+area.sala.baterias)*markup.espacio.overheads","v":9.9061921052631572},"area.espacio.overheads"]
[]
[3,{"$f":"INDEX(lista.activos,$A62)","v":"Sala coubicación externa"}]
[]
[null,null,null,"Espacio de coubicación activo por CS",null,{"$f":"espacio.coubicacion.activo.porCS","v":4}]
[null,null,null,"CSs activos con CE",null,{"$f":"numero.CS.activo.CE","v":0}]
[]
[null,null,null,"Dimensionamento sala coubicacion CE",null,{"$f":"(F64*F65)*(1+markup.sala.CS)","v":0},"area.sala.coubicacion.externa.CS"]
[]
[4,{"$f":"INDEX(lista.activos,$A69)","v":"Subestación electrica"}]
[]
[null,null,null,"Potencia de los equipos del AEP","kW",{"$f":"consumo.equipos.AEP","v":61.536192}]
[]
[null,null,null,"Potencia de los equipos de los CSs","kW",{"$f":"F74*F75","v":25.462640000000007}]
[null,null,null,"Consumo de los equipos por CS","kW",{"$f":"consumo.equipos.porCS","v":4.4360000000000008}]
[null,null,null,"CSs activos","kW",{"$f":"numero.CS.activo","v":5.74}]
[]
[null,null,null,"Potencia de los equipos","kW",{"$f":"IF(tipo.central.telmex.activa=\"Pequeña\",0,F71+F73)","v":86.998832000000007},"consumo.equipos.subestacion.electrica",null,"Nota: Si la central es pequeña, no hay subestación eléctrica"]
[]
[5,{"$f":"INDEX(lista.activos,$A79)","v":"Fuente de energia de respaldo (planta de emergencia)"}]
[]
[null,null,null,"Potencia transformadores subestacion electrica","kW",{"$f":"F73+F71","v":86.998832000000007}]
[]
[null,null,null,"Potencia transformadores subestacion electrica - AEP","kW",{"$f":"consumo.equipos.AEP*fuente.energia.respaldo.activo.AEP","v":61.536192}]
[null,null,null,"Potencia transformadores subestacion electrica - CSs","kW",{"$f":"consumo.equipos.porCS*numero.CS.activo*solicitacion.fuente.energia.respaldo.activo.CS","v":25.462640000000007}]
[]
[null,null,null,"Potencia minima de la fuente de energia de respaldo","kW",{"$f":"SUM(F83:F84)*capacidad.fuente.energia.respaldo","v":69.599065600000003},"potencia.minima.fuente.energia.respaldo"]
[]
["Clima"]
[6,{"$f":"INDEX(lista.activos,$A89)","v":"Aire acondicionado"}]
[]
[null,null,null,"Compartición de aire acondicionado",null,{"$f":"solicitacion.aire.acondicionado.activo","v":true}]
[]
[null,null,null,"Área de las salas con aire acondicionado","m2",{"$f":"area.salas.central.telmex-area.sala.coubicacion.CS+(area.sala.coubicacion.CS*F91)","v":152.46752915789475},null,null,"Todas las salas tienen aire acondicionado con excepcion de la sala de coubicacion de los CS si estos no solicitaren aire acondcionado"]
[null,null,null,"Capacidad de aire acondicionado requerida / utilizada por unidad de superficie","ton/m2",{"$f":"aire.acondicionado.capacidad.superficie","v":0.1}]
[null,null,null,"Capacidad utilizada","ton",{"$f":"F93*F94","v":15.246752915789475},"capacidad.utilizada.aire.acondicionado"]
[]
["Racks"]
[7,{"$f":"INDEX(lista.activos,$A98)","v":"Racks"}]
[]
[null,null,null,"Solicitación de racks",null,{"$f":"solicitacion.racks.activo","v":false}]
[]
[null,null,null,"Dimensión por rack","m2",{"$f":"calculos.secundarios.dimension.racks","v":1.6666666666666667}]
[]
[null,null,null,"Numero de racks","#",{"$f":"ROUNDUP(espacio.racks.activo/F102,0)","v":0},"unidades.racks.activo"]

{"sheet":"Costos unitarios","index":6,"n_rows":101,"n_cols":27,"rows_kept":101,"cut":false,"hidden":false,"merged":[[3,26,4,26],[3,13,4,19],[3,6,4,11],[3,21,4,24]]}
["Costos unitarios",null,null,null,null,null,null,null,null," "]
[]
[null,"Año de referencia",2015]
[null,"Año activo",{"$f":"año.activo","v":2017},null,null,null,"CAPEX",null,null,null,null,null,null,"OPEX",null,null,null,null,null,null,null,"VIDA UTIL",null,null,null,null,"NOTAS"]
[null,null,{"$f":"C4-C3","v":2}]
[]
["Uso de Sitios, Predios y Espacios Físicos"]
[1,{"$f":"INDEX(lista.activos,$A8)","v":"Predio"}]
[null,null,"Propiedad del predio","Geotipo del predio","Identificador",null,"CAPEX unitario obras civiles de adecuacion (MXN/m2)","Tendencia de costos","CAPEX unitario obras civiles de adecuacion (MXN/m2) - Año activo","CAPEX unitario de adquisicion (MXN/m2)","Tendencia de costos","CAPEX unitario de adquisicion (MXN/m2) - Año activo",null,"OPEX anual alquiler (MXN/año)","Tendencia de costos","OPEX anual alquiler (MXN/año/m2) - Año activo","OPEX de mantenimiento (MXN/año/m2)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/año/m2)  - Año activo",null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"Telmex","Alta",{"$f":"C10&D10","v":"TelmexAlta"}," ",525,0.05,{"$f":"G10*(1+H10)^$C$5","v":578.8125},8240,0.03,{"$f":"J10*(1+K10)^$C$5","v":8741.8159999999989},null,0,0.03,{"$f":"N10*(1+O10)^$C$5","v":0},{"$f":"(G10+J10)*S10","v":0},0.03,0,{"$f":"Q10*(1+R10)^$C$5","v":0},null,80,80,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V10,'Costos unitarios'!W10)","v":80},{"$f":"MAX(0,X10-$C$5)","v":78}]
[null,null,"Telmex","Media",{"$f":"C11&D11","v":"TelmexMedia"}," ",578,0.05,{"$f":"G11*(1+H11)^$C$5","v":637.245},8240,0.03,{"$f":"J11*(1+K11)^$C$5","v":8741.8159999999989},null,0,0.03,{"$f":"N11*(1+O11)^$C$5","v":0},{"$f":"(G11+J11)*S11","v":0},0.03,0,{"$f":"Q11*(1+R11)^$C$5","v":0},null,{"$f":"$V$10","v":80},{"$f":"$W$10","v":80},{"$f":"$X$10","v":80},{"$f":"MAX(0,X11-$C$5)","v":78}]
[null,null,"Telmex","Baja","TelmexBaja"," ",630,0.05,694.57500000000005,8240,0.03,8741.8159999999989,null,0,0.03,0,0,0.03,0,0,null,{"$f":"$V$10","v":80},{"$f":"$W$10","v":80},{"$f":"$X$10","v":80},78]
[null,null,"Telmex","espacio vacante","Telmexespacio vacante"," ",null,null,0,null,null,0,null,null,null,0,0,null,null,0,null,null,null,null,0]
[null,null,"Tercero en arrendamiento","Alta","Tercero en arrendamientoAlta"," ",525,0.05,578.8125,0,0.03,0,null,0,0.03,0,0,0.03,0,0,null,80,80,80,78]
[null,null,"Tercero en arrendamiento","Media","Tercero en arrendamientoMedia"," ",578,0.05,637.245,0,0.03,0,null,0,0.03,0,0,0.03,0,0,null,80,80,80,78]
[null,null,"Tercero en arrendamiento","Baja","Tercero en arrendamientoBaja"," ",630,0.05,694.57500000000005,0,0.03,0,null,0,0.03,0,0,0.03,0,0,null,80,80,80,78]
[null,null,"Tercero en arrendamiento","espacio vacante","Tercero en arrendamientoespacio vacante"," ",null,null,0,null,null,0,null,null,null,0,0,null,null,0,null,null,null,null,0]
[null,null,"Tercero en comodato","Alta","Tercero en comodatoAlta"," ",525,0.05,578.8125,0,0.03,0,null,0,0.03,0,0,0.03,0,0,null,80,80,80,78]
[null,null,"Tercero en comodato","Media","Tercero en comodatoMedia"," ",578,0.05,637.245,0,0.03,0,null,0,0.03,0,0,0.03,0,0,null,80,80,80,78]
[null,null,"Tercero en comodato","Baja","Tercero en comodatoBaja"," ",630,0.05,694.57500000000005,0,0.03,0,null,0,0.03,0,0,0.03,0,0,null,80,80,80,78]
[null,null,"Tercero en comodato","espacio vacante","Tercero en comodatoespacio vacante"," ",null,null,0,null,null,0,null,null,null,0,0,null,null,0,null,null,null,null,0]
[null,null,null,null,"identificador.predio",null,null,null,"capex.unitario.obras.adecuacion.predio",null,null,"capex.unitario.acquisicion.predio",null,null,null,"opex.anual.alquiler.predio",null,null,null,"opex.anual.mantenimiento.predio",null,null,null,"vida.util.predio","vida.util.restante.predio"]
[]
[2,{"$f":"INDEX(lista.activos,$A24)","v":"Central del AEP"}]
[null,null,"Tamaño central ","Geotipo",null,null,"CAPEX unitario obras civiles (MXN/m2)","Tendencia de costos","CAPEX unitario (MXN/m2) - Año activo",null,null,null,null,"OPEX anual alquiler (MXN/año)","Tendencia de costos","OPEX anual alquiler (MXN/año) - Año activo","OPEX de mantenimiento (MXN/año)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/año) - Año activo",null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"Pequeña","Alta",{"$f":"C26&D26","v":"PequeñaAlta"}," ",{"$f":"AVERAGE(G28,G31)","v":11000},0.03,{"$f":"G26*(1+H26)^$C$5","v":11669.9},null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D26,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":175866.90570500877},0.03,{"$f":"N26*(1+O26)^$C$5","v":186577.2002624438},{"$f":"Q45*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS)","v":150313.58012707334},0.03,0,{"$f":"Q26*(1+R26)^$C$5","v":159467.6771568121},null,70,30,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V26,'Costos unitarios'!W26)","v":70},{"$f":"MAX(0,X26-$C$5)","v":68}]
[null,null,"Pequeña","Media",{"$f":"C27&D27","v":"PequeñaMedia"}," ",{"$f":"AVERAGE(G28,G31)","v":11000},0.03,{"$f":"G27*(1+H27)^$C$5","v":11669.9},null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D27,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":97450.001142980414},0.03,{"$f":"N27*(1+O27)^$C$5","v":103384.70621258792},{"$f":"$Q$26","v":150313.58012707334},0.03,0,{"$f":"Q27*(1+R27)^$C$5","v":159467.6771568121},null,{"$f":"$V$26","v":70},{"$f":"$W$26","v":30},{"$f":"$X$26","v":70},{"$f":"MAX(0,X27-$C$5)","v":68}]
[null,null,"Pequeña","Baja","PequeñaBaja"," ",7870,0.03,8349.2829999999994,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D28,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":54275.437809511328},0.03,57580.811972110569,{"$f":"$Q$26","v":150313.58012707334},0.03,0,159467.6771568121,null,{"$f":"$V$26","v":70},{"$f":"$W$26","v":30},{"$f":"$X$26","v":70},68]
[null,null,"Pequeña","espacio vacante","Pequeñaespacio vacante"," ",null,null,0,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,0]
[null,null,"Media","Alta","MediaAlta"," ",{"$f":"G31","v":14130},0.03,{"$f":"G30*(1+H30)^$C$5","v":14990.517},null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D30,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":175866.90570500877},0.03,186577.2002624438,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,{"$f":"MAX(0,X30-$C$5)","v":68}]
[null,null,"Media","Media","MediaMedia"," ",14130,0.03,14990.517,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D31,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":97450.001142980414},0.03,{"$f":"N31*(1+O31)^$C$5","v":103384.70621258792},150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Media","Baja","MediaBaja"," ",{"$f":"AVERAGE(G28,G31)","v":11000},0.03,11669.9,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D32,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":54275.437809511328},0.03,57580.811972110569,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Media","espacio vacante","Mediaespacio vacante"," ",null,null,0,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,0]
[null,null,"Grande","Alta","GrandeAlta"," ",25500,0.03,27052.949999999997,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D34,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":175866.90570500877},0.03,186577.2002624438,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Grande","Media","GrandeMedia"," ",{"$f":"AVERAGE(G31,G34)","v":19815},0.03,21021.733499999998,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D35,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":97450.001142980414},0.03,103384.70621258792,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Grande","Baja","GrandeBaja"," ",{"$f":"G31","v":14130},0.03,14990.517,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D36,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":54275.437809511328},0.03,57580.811972110569,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Grande","espacio vacante","Grandeespacio vacante"," ",null,null,0,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,0]
[null,null,"Muy grande","Alta","Muy grandeAlta"," ",{"$f":"G34","v":25500},0.03,27052.949999999997,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D38,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":175866.90570500877},0.03,186577.2002624438,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Muy grande","Media","Muy grandeMedia"," ",{"$f":"G34","v":25500},0.03,27052.949999999997,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D39,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":97450.001142980414},0.03,103384.70621258792,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Muy grande","Baja","Muy grandeBaja"," ",{"$f":"G31","v":14130},0.03,14990.517,null,null,null,null,{"$f":"($N$45*INDEX($O$49:$O$52,MATCH(D40,$N$49:$N$52,0))*area.salas.central.telmex/(area.salas.central.telmex+area.sala.coubicacion.externa.CS))","v":54275.437809511328},0.03,57580.811972110569,150313.58012707334,0.03,0,159467.6771568121,null,70,30,70,68]
[null,null,"Muy grande","espacio vacante","Muy grandeespacio vacante"," ",null,null,0,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,0]
[null,null,null,null,"identificador.central.telmex",null,"Fuente: Telmex y Analysys Mason",null,"capex.unitario.central.telmex",null,null,null,null,null,null,"opex.anual.alquiler.central.telmex","Fuente: Telmex",null,null,"opex.anual.mantenimiento.central.telmex",null,null,"Fuente: Telmex","vida.util.central.telmex","vida.util.restante.central.telmex"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OPEX anual alquiler (MXN/año)",null,null,"OPEX de mantenimiento (MXN/año)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2338800.02743153*1000/24000","v":97450.001142980414},null,null,{"$f":"3607525.92304976*1000/24000","v":150313.58012707334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fuente: Telmex",null,null,"Fuente: Telmex"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Premium de alquiler por zona"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"geotipo","v":"Alta"},1.8046885956109291,"Basado en Telmex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Media",1,"Basado en Telmex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Baja",0.55695676934756955,"Basado en Telmex"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"espacio vacante",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Nota: Asumiendo que la distribucion de centrales en zonas alta, media y baja es igual"]
[]
[3,{"$f":"INDEX(lista.activos,$A55)","v":"Sala coubicación externa"}]
[null,null,"Tamaño central ","Geotipo",null,null,"CAPEX unitario - adquisicion + instalacion + obras civiles (MXN/m2)","Tendencia de costos","CAPEX unitario (MXN) - Año activo",null,null,null,null,"OPEX anual alquiler (MXN/año)","Tendencia de costos","OPEX anual alquiler (MXN/año) - Año activo","OPEX de mantenimiento (MXN/año)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/año) - Año activo",null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"Pequeña","Alta",{"$f":"C57&D57","v":"PequeñaAlta"},null,{"$f":"G26","v":11000},{"$f":"H26","v":0.03},11669.9,null,null,null,null,{"$f":"N45*area.sala.coubicacion.externa.CS/(area.salas.central.telmex+area.sala.coubicacion.externa.CS)","v":0},0.03,{"$f":"N57*(1+O57)^$C$5","v":0},{"$f":"Q45*area.sala.coubicacion.externa.CS/(area.salas.central.telmex+area.sala.coubicacion.externa.CS)","v":0},0.03,0,{"$f":"Q57*(1+R57)^$C$5","v":0},null,70,30,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V57,'Costos unitarios'!W57)","v":70},{"$f":"MAX(0,X57-$C$5)","v":68}]
[null,null,"Pequeña","Media",{"$f":"C58&D58","v":"PequeñaMedia"},null,{"$f":"G27","v":11000},0.03,11669.9,null,null,null,null,{"$f":"$N$57","v":0},0.03,{"$f":"N58*(1+O58)^$C$5","v":0},{"$f":"$Q$57","v":0},0.03,0,{"$f":"Q58*(1+R58)^$C$5","v":0},null,{"$f":"$V$57","v":70},{"$f":"$W$57","v":30},{"$f":"$X$57","v":70},{"$f":"MAX(0,X58-$C$5)","v":68}]
[null,null,"Pequeña","Baja","PequeñaBaja",null,{"$f":"G28","v":7870},0.03,8349.2829999999994,null,null,null,null,{"$f":"$N$57","v":0},0.03,0,{"$f":"$Q$57","v":0},0.03,0,0,null,{"$f":"$V$57","v":70},{"$f":"$W$57","v":30},{"$f":"$X$57","v":70},68]
[null,null,"Pequeña","espacio vacante","Pequeñaespacio vacante",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,0]
[null,null,"Media","Alta","MediaAlta",null,{"$f":"G30","v":14130},0.03,14990.517,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Media","Media","MediaMedia",null,{"$f":"G31","v":14130},0.03,14990.517,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Media","Baja","MediaBaja",null,{"$f":"G32","v":11000},0.03,11669.9,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Media","espacio vacante","Mediaespacio vacante",null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,0]
[null,null,"Grande","Alta","GrandeAlta",null,{"$f":"G34","v":25500},0.03,27052.949999999997,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Grande","Media","GrandeMedia",null,{"$f":"G35","v":19815},0.03,21021.733499999998,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Grande","Baja","GrandeBaja",null,{"$f":"G36","v":14130},0.03,14990.517,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Grande","espacio vacante","Grandeespacio vacante",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,0]
[null,null,"Muy grande","Alta","Muy grandeAlta",null,{"$f":"G38","v":25500},0.03,27052.949999999997,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Muy grande","Media","Muy grandeMedia",null,{"$f":"G39","v":25500},0.03,27052.949999999997,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Muy grande","Baja","Muy grandeBaja",null,{"$f":"G40","v":14130},0.03,14990.517,null,null,null,null,0,0.03,0,0,0.03,0,0,null,70,30,70,68]
[null,null,"Muy grande","espacio vacante","Muy grandeespacio vacante",null,null,null,null,null,null,null,null,null,null,0,null,null,0,0,null,null,null,null,0]
[null,null,null,null,"identificador.sala.coubicacion.externa",null,null,null,"capex.unitario.sala.coubicacion.externa",null,null,null,null,null,null,"opex.anual.alquiler.sala.coubicacion.externa",null,null,null,"opex.anual.mantenimiento.sala.coubicacion.externa",null,null,"Fuente: Telmex","vida.util.sala.coubicacion.externa","vida.util.restante.sala.coubicacion.externa"]
[]
[4,{"$f":"INDEX(lista.activos,$A75)","v":"Subestación electrica"}]
[null,null,"Corriente",null,null,null,"CAPEX unitario (MXM/kW)","Tendencia de costos","CAPEX unitario (MXN) - Año activo",null,null,null,null,"OPEX de mantenimiento (MXN/año/kW)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/año/kW) - Año activo",null,null,null,null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"AC 127V",null,{"$f":"L!C90","v":"AC_127V"},null,12060,0.02,{"$f":"G77*(1+H77)^$C$5","v":12547.224},null,null,null,null,{"$f":"G77*P77","v":553.55400000000009},0.02,4.5900000000000003E-2,{"$f":"N77*(1+O77)^$C$5","v":575.91758160000006},null,null,null,null,27,12,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V77,'Costos unitarios'!W77)","v":27},{"$f":"MAX(0,X77-$C$5)","v":25}]
[null,null,"DC 48V",null,{"$f":"L!C89","v":"DC_48V"},null,{"$f":"G77","v":12060},0.02,{"$f":"G78*(1+H78)^$C$5","v":12547.224},null,null,null,null,{"$f":"G78*P78","v":553.55400000000009},0.02,{"$f":"P77","v":4.5900000000000003E-2},{"$f":"N78*(1+O78)^$C$5","v":575.91758160000006},null,null,null,null,{"$f":"V77","v":27},12,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V78,'Costos unitarios'!W78)","v":27},{"$f":"MAX(0,X78-$C$5)","v":25}]
[null,null,null,null,"identificador.subestacion.electrica",null,null,null,"capex.unitario.subestacion.electrica",null,null,null,null,null,null,null,"opex.anual.mantenimiento.subestacion.electrica",null,null,null,null,null,null,"vida.util.subestacion.electrica","vida.util.restante.subestacion.electrica"]
[]
[]
[5,{"$f":"INDEX(lista.activos,$A82)","v":"Fuente de energia de respaldo (planta de emergencia)"}]
[null,null,"Tipo de fuente de energia de respaldo",null,null,null,"CAPEX unitario (kW)","Tendencia de costos","CAPEX unitario (MXN) - Año activo",null,null,null,null,"OPEX de mantenimiento (MXN/kW/año)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/kW/año) - Año activo",null,null,null,null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"Generador + baterias",null,{"$f":"C84","v":"Generador + baterias"},null,9730,0.02,{"$f":"G84*(1+H84)^$C$5","v":10123.092000000001},null,null,null,null,{"$f":"G84*P84","v":446.60700000000003},0.02,4.5900000000000003E-2,{"$f":"N84*(1+O84)^$C$5","v":464.64992280000001},null,null,null,null,12,12,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V84,'Costos unitarios'!W84)","v":12},{"$f":"MAX(0,X84-$C$5)","v":10}]
[null,null,null,null,"identificador.fuente.energia.respaldo",null,"Fuente: Telmex",null,"capex.unitario.fuente.energia.respaldo",null,null,null,null,null,null,null,"opex.unitario.fuente.energia.respaldo",null,null,null,null,null,"Fuente: Telmex","vida.util.fuente.energia.respaldo","vida.util.restante.fuente.energia.respaldo"]
[]
[6,{"$f":"INDEX(lista.activos,$A87)","v":"Aire acondicionado"}]
[null,null,null,null,null,null,"CAPEX unitario (MXN/ton)","Tendencia de costos","CAPEX unitario (MXN/ton) - Año activo",null,null,null,null,"OPEX de mantenimiento (MXN/año)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/año) - Año activo",null,null,null,null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"Valores por ton",null,null,null,20570,0.02,{"$f":"G89*(1+H89)^$C$5","v":21401.027999999998},null,null,null,null,{"$f":"G89*P89","v":944.16300000000012},0.03,4.5900000000000003E-2,{"$f":"N89*(1+O89)^$C$5","v":1001.6625267000001},null,null,null,null,20,20,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V89,'Costos unitarios'!W89)","v":20},{"$f":"MAX(0,X89-$C$5)","v":18}]
[null,null,null,null,null,null,"Fuente: Telmex",null,"capex.unitario.aire.acondicionado",null,null,null,null,null,null,"Fuente: Telmex","opex.anual.mantenimiento.aire.acondicionado",null,null,null,null,null,"Fuente: Telmex","vida.util.aire.acondicionado","vida.util.restante.aire.acondicionado"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPEX de energia (MXN/kWh)","Tendencia de costos",null,"OPEX de energia (MXN/kWh) - Año activo"]
[null,null,"Precio de energia por kWh",null,null,null,null,null,null,null,null,null,null,null,1.35,0.05,null,{"$f":"(O92*(1+P92)^$C$5)","v":1.4883750000000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"opex.energia.kWh"]
[7,{"$f":"INDEX(lista.activos,$A94)","v":"Racks"}]
[]
[null,null,null,null,null,null,"CAPEX unitario (MXN/#)","Tendencia de costos",null,null,null,null,null,"OPEX de mantenimiento (MXN/año)","Tendencia de costos","OPEX de mantenimiento (% capex)","OPEX de mantenimiento (MXN/año) - Año activo",null,null,null,null,"Vida util economica","Vida util contable","Vida util activa","Vida util restante"]
[null,null,"Gabinete",null,null,null,94525,0.02,{"$f":"G97*(1+H97)^$C$5","v":98343.81},null,null,null,null,{"$f":"G97*P97","v":7372.95},0.02,7.8E-2,{"$f":"N97*(1+O97)^$C$5*Q101","v":7670.81718},null,null,null,null,7,7,{"$f":"CHOOSE(vida.util.activo.indice,'Costos unitarios'!V97,'Costos unitarios'!W97)","v":7},{"$f":"MAX(0,X97-$C$5)","v":5}]
[null,null,null,null,null,null,"Fuente: Telmex",null,"capex.unitario.racks",null,null,null,null,null,null,"Fuente: Telmex","opex.anual.mantenimiento.racks",null,null,null,null,null,"Fuente: Telmex","vida.util.racks","vida.util.restante.racks"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factor de utilizacion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"Costeo","index":7,"n_rows":37,"n_cols":29,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,23,3,25],[2,17,3,21],[2,8,3,15]]}
["Costeo"]
[]
[null,null,null,null,null,null,null,null,"CAPEX",null,null,null,null,null,null,null,null,"OPEX",null,null,null,null,null,"Costos totales incluindo overheads"]
[]
[null,null,null,null,null,null,null,null,null,"Inputs",null,null,null,null,null,null,null," "]
[null,null,null,"Elemento","Unidad","Cantidad","Nombre",null,"Unidad capex unitario","Obras civiles","Unidad capex unitario","Adquisicion","Capex total","Vida útil","Vida útil restante","Anualidad Capex",null,"Unidad opex unitario 1","Alquiler","Unidad opex unitario 2","Mantenimiento","Opex total",null,"Capex total","Opex total","Gasto anual",null,"Notas"]
["Unidad -->",null,null,null,null,null,null,null,null,"MXN",null,"MXN","MXN","años","años","MXN/año",null,null,"MXN",null,"MXN","MXN/año",null,"MXN/año","MXN/año","MXN/año"]
[]
["Uso de Sitios, Predios y Espacios Físicos"]
[1,{"$f":"INDEX(lista.activos,$A10)","v":"Predio"}]
[]
[null,null,null,{"$f":"id.predio.activo","v":"Tercero en arrendamientoMedia"},"m2",{"$f":"area.total.predio","v":114.35064686842105},null,null,"MXN/m2",{"$f":"INDEX(capex.unitario.obras.adecuacion.predio,MATCH(D12,identificador.predio,0))","v":637.245},"MXN/m2",{"$f":"INDEX(capex.unitario.acquisicion.predio,MATCH(D12,identificador.predio,0))","v":0},{"$f":"(F12*J12)+(F12*L12)","v":72869.377963666979},{"$f":"INDEX(vida.util.predio,MATCH(D12,identificador.predio,0))","v":80},{"$f":"INDEX(vida.util.restante.predio,MATCH(D12,identificador.predio,0))","v":78},{"$f":"(wacc/(1-(1/(1+wacc)^N12)))*M12","v":7225.1212538323398},null,"MXN",{"$f":"INDEX(opex.anual.alquiler.predio,MATCH(D12,identificador.predio,0))","v":0},"MXN/m2",{"$f":"INDEX(opex.anual.mantenimiento.predio,MATCH(D12,identificador.predio,0))","v":0},{"$f":"S12+(U12*F12)","v":0},null,{"$f":"P12*(1+markup.overhead.capex)","v":7803.1309541389273},{"$f":"V12*(1+markup.overhead.opex)","v":0},{"$f":"X12+Y12","v":7803.1309541389273}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.predio","opex.predio","gasto.anual.predio"]
[2,{"$f":"INDEX(lista.activos,$A14)","v":"Central del AEP"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Output para el modelo móvil"]
[]
[null,null,null,{"$f":"id.central.telmex.activo","v":"MediaMedia"},"m2",{"$f":"area.salas.central.telmex","v":152.46752915789475},null,null,"MXN/m2",{"$f":"INDEX(capex.unitario.central.telmex,MATCH(D16,identificador.central.telmex,0))","v":14990.517},0,0,{"$f":"(J16*F16)","v":2285567.0877894168},{"$f":"INDEX(vida.util.central.telmex,MATCH(D16,identificador.central.telmex,0))","v":70},{"$f":"INDEX(vida.util.restante.central.telmex,MATCH(D16,identificador.central.telmex,0))","v":68},{"$f":"(wacc/(1-(1/(1+wacc)^N16)))*M16","v":226803.81898152668},null,"MXN",{"$f":"INDEX(opex.anual.alquiler.central.telmex,MATCH(D16,identificador.central.telmex,0))","v":103384.70621258792},"MXN",{"$f":"INDEX(opex.anual.mantenimiento.central.telmex,MATCH(D16,identificador.central.telmex,0))","v":159467.6771568121},{"$f":"S16+U16","v":262852.38336940005},null,{"$f":"P16*(1+markup.overhead.capex)","v":244948.12450004884},{"$f":"V16*(1+markup.overhead.opex)","v":283880.57403895207},{"$f":"X16+Y16","v":528828.69853900094},null,{"$f":"capex.central.telmex/F16","v":1606.5592841501457},{"$f":"opex.central.telmex/F16","v":1861.9084050674587}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.central.telmex","opex.central.telmex","gasto.anual.central.telmex",null,"capex.central.telmex.para.movil","opex.central.telmex.para.movil"]
[3,{"$f":"INDEX(lista.activos,$A18)","v":"Sala coubicación externa"}]
[]
[null,null,null,{"$f":"id.central.telmex.activo","v":"MediaMedia"},"m2",{"$f":"area.sala.coubicacion.externa.CS","v":0},null,null,"MXN/m2",{"$f":"INDEX(capex.unitario.sala.coubicacion.externa,MATCH(D20,identificador.sala.coubicacion.externa,0))","v":14990.517},0,0,{"$f":"(J20*F20)","v":0},{"$f":"INDEX(vida.util.sala.coubicacion.externa,MATCH(D20,identificador.central.telmex,0))","v":70},{"$f":"INDEX(vida.util.restante.sala.coubicacion.externa,MATCH(D20,identificador.central.telmex,0))","v":68},{"$f":"(wacc/(1-(1/(1+wacc)^N20)))*M20","v":0},null,"MXN",{"$f":"INDEX(opex.anual.alquiler.sala.coubicacion.externa,MATCH(D20,identificador.sala.coubicacion.externa,0))","v":0},"MXN",{"$f":"INDEX(opex.anual.mantenimiento.sala.coubicacion.externa,MATCH(D20,identificador.sala.coubicacion.externa,0))","v":0},{"$f":"S20+U20","v":0},null,{"$f":"P20*(1+markup.overhead.capex)","v":0},{"$f":"V20*(1+markup.overhead.opex)","v":0},{"$f":"X20+Y20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.sala.coubicacion.externa","opex.sala.coubicacion.externa","gasto.anual.sala.coubicacion.externa"]
[4,{"$f":"INDEX(lista.activos,$A22)","v":"Subestación electrica"}]
[]
[null,null,null,{"$f":"corriente.energia.activa","v":"AC_127V"},"kW",{"$f":"consumo.equipos.subestacion.electrica","v":86.998832000000007},null,null,"MXN/kW",{"$f":"INDEX(capex.unitario.subestacion.electrica,MATCH(corriente.energia.activa,identificador.subestacion.electrica,0))","v":12547.224},0,0,{"$f":"(J24*F24)","v":1091593.8328423682},{"$f":"INDEX(vida.util.subestacion.electrica,MATCH(corriente.energia.activa,identificador.subestacion.electrica,0))","v":27},{"$f":"INDEX(vida.util.restante.subestacion.electrica,MATCH(corriente.energia.activa,identificador.subestacion.electrica,0))","v":25},{"$f":"(wacc/(1-(1/(1+wacc)^N24)))*M24","v":117326.31064330217},null,0,0,"MXN/kW",{"$f":"INDEX(opex.anual.mantenimiento.subestacion.electrica,MATCH(corriente.energia.activa,identificador.subestacion.electrica,0))","v":575.91758160000006},{"$f":"(S24*F24)+(U24*F24)","v":50104.156927464697},null,{"$f":"P24*(1+markup.overhead.capex)","v":126712.41549476636},{"$f":"V24*(1+markup.overhead.opex)","v":54112.489481661876},{"$f":"X24+Y24","v":180824.90497642825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.subestacion.electrica","opex.subestacion.electrica","gasto.anual.subestacion.electrica"]
[5,{"$f":"INDEX(lista.activos,$A26)","v":"Fuente de energia de respaldo (planta de emergencia)"}]
[]
[null,null,null,{"$f":"opcion.fuente.energia.respaldo.activa","v":"Generador Diesel + Baterias"},"kW",{"$f":"potencia.minima.fuente.energia.respaldo","v":69.599065600000003},null,null,"MXN/kW",{"$f":"capex.unitario.fuente.energia.respaldo","v":10123.092000000001},0,0,{"$f":"(J28*F28)","v":704557.74418283522},{"$f":"vida.util.fuente.energia.respaldo","v":12},{"$f":"vida.util.restante.fuente.energia.respaldo","v":10},{"$f":"(wacc/(1-(1/(1+wacc)^N28)))*M28","v":102947.78942653399},null,0,0,"MXN/kW",{"$f":"opex.unitario.fuente.energia.respaldo","v":464.64992280000001},{"$f":"(S28*F28)+(U28*F28)","v":32339.200457992138},null,{"$f":"P28*(1+markup.overhead.capex)","v":111183.61258065671},{"$f":"V28*(1+markup.overhead.opex)","v":34926.336494631512},{"$f":"X28+Y28","v":146109.94907528823}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.fuente.energia.respaldo","opex.fuente.energia.respaldo","gasto.anual.fuente.energia.respaldo"]
[6,{"$f":"INDEX(lista.activos,$A30)","v":"Aire acondicionado"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energia"]
[]
[null,null,null,{"$f":"Dimensionado!D95","v":"Capacidad utilizada"},"tons",{"$f":"capacidad.utilizada.aire.acondicionado","v":15.246752915789475},null,null,"MXN/tons",{"$f":"capex.unitario.aire.acondicionado","v":21401.027999999998},0,0,{"$f":"J32*F32","v":326296.18605989218},{"$f":"vida.util.aire.acondicionado","v":20},{"$f":"vida.util.restante.aire.acondicionado","v":18},{"$f":"(wacc/(1-(1/(1+wacc)^N32)))*M32","v":38091.456918659125},null,0,{"$f":"F32*kW.por.ton*horas.por.dia*dias.por.mes*meses.por.año*opex.energia.kWh","v":689565.99981693213},"MXN",{"$f":"opex.anual.mantenimiento.aire.acondicionado","v":1001.6625267000001},{"$f":"IF(F32>0,U32,0)","v":1001.6625267000001},null,{"$f":"P32*(1+markup.overhead.capex)","v":41138.773472151857},{"$f":"V32*(1+markup.overhead.opex)","v":1081.7955288360001},{"$f":"X32+Y32","v":42220.56900098786}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.aire.acondicionado","opex.aire.acondicionado","gasto.anual.aire.acondicionado"]
[7,{"$f":"INDEX(lista.activos,$A34)","v":"Racks"}]
[]
[null,null,null,{"$f":"Dimensionado!D104","v":"Numero de racks"},"unidades",{"$f":"unidades.racks.activo","v":0},null,null,"MXN/unidade",{"$f":"capex.unitario.racks","v":98343.81},0,0,{"$f":"J36*F36","v":0},{"$f":"vida.util.racks","v":7},{"$f":"vida.util.restante.racks","v":5},{"$f":"(wacc/(1-(1/(1+wacc)^N36)))*M36","v":0},null,null,null,"MXN/unidade",{"$f":"opex.anual.mantenimiento.racks","v":7670.81718},{"$f":"U36*F36","v":0},null,{"$f":"P36*(1+markup.overhead.capex)","v":0},{"$f":"V36*(1+markup.overhead.opex)","v":0},{"$f":"X36+Y36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"capex.racks","opex.racks","gasto.anual.racks"]

{"sheet":"Precio","index":8,"n_rows":199,"n_cols":18,"rows_kept":199,"cut":false,"hidden":false,"merged":[]}
["Precio",null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
["Matrices de mapeo de elementos de red a servicios"]
[null,null,"AEP",null,null,"Servicios  -->",null,{"$f":"TRANSPOSE(lista.servicios)","v":"Coubicación"},"Subestación electrica","Fuente de energia de respaldo","Aire acondicionado",null,"Nota: incluimos autoaprovisionamiento del AEP"]
[null,null,"Elemento"]
[null,1,{"$f":"INDEX(lista.activos,B8)","v":"Predio"},null,null,null,null,1,0,0,0]
[null,{"$f":"B8+1","v":2},"Central del AEP",null,null,null,null,{"$f":"((SUMPRODUCT(H$17:H$26,$H$116:$H$125)/SUM($H$116:$H$125)))*((1-$K9)/1)","v":0.61282873157364248},{"$f":"(SUMPRODUCT(I$17:I$26,$H$116:$H$125)/SUM($H$116:$H$125))*((1-$K9)/1)","v":0.27103767883064844},{"$f":"(SUMPRODUCT(J$17:J$26,$H$116:$H$125)/SUM($H$116:$H$125))*((1-$K9)/1)","v":6.6133589595708961E-2},0.05,null,"Nota: ver abajo asignación de salas a servicios"]
[null,{"$f":"B9+1","v":3},"Sala coubicación externa",null,null,null,null,1,0,0,0]
[null,4,"Subestación electrica",null,null,null,null,0,1,0,0]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,null,null,null,0,0,1,0]
[null,6,"Aire acondicionado",null,null,null,null,0,0,0,1]
[null,7,{"$f":"INDEX(lista.activos,B14)","v":"Racks"},null,null,null,null,1,0,0,0]
[]
[null,null,"Sub-elemento de la Central del AEP"]
[null,1,{"$f":"INDEX(lista.componentes.central.telmex,B17)","v":"Sala MDF/ODF AEP"},null,null,null,null,1,0,0,0]
[null,{"$f":"B17+1","v":2},"Sala coubicación CS",null,null,null,null,1,0,0,0]
[null,{"$f":"B18+1","v":3},"Sala de control",null,null,null,null,1,0,0,0]
[null,{"$f":"B19+1","v":4},"Sala de switching del AEP",null,null,null,null,1,0,0,0]
[null,{"$f":"B20+1","v":5},"Sala equipos de transmisión del AEP",null,null,null,null,1,0,0,0]
[null,6,"Sala subestacion electrica",null,null,null,null,0,1,0,0]
[null,7,"Sala planta de emergencia",null,null,null,null,0,0,1,0]
[null,8,"Sala baterias",null,null,null,null,0,0,1,0]
[null,9,"Espacio de overheads",null,null,null,null,1,0,0,0]
[null,10,"espacio vacante"]
[]
[null,null,"CSs",null,null,"Servicios  -->",null,{"$f":"TRANSPOSE(lista.servicios)","v":"Coubicación"},"Subestación electrica","Fuente de energia de respaldo","Aire acondicionado"]
[null,null,"Elemento"]
[null,1,{"$f":"INDEX(lista.activos,B30)","v":"Predio"},null,null,null,null,1,0,0,0]
[null,{"$f":"B30+1","v":2},"Central del AEP",null,null,null,null,{"$f":"(SUMPRODUCT(H$39:H$48,$H$116:$H$125)/SUM($H$116:$H$125))*((1-$K31)/1)","v":0.61282873157364248},{"$f":"(SUMPRODUCT(I$39:I$48,$H$116:$H$125)/SUM($H$116:$H$125))*((1-$K31)/1)","v":0.27103767883064844},{"$f":"(SUMPRODUCT(J$39:J$48,$H$116:$H$125)/SUM($H$116:$H$125))*((1-$K31)/1)","v":6.6133589595708961E-2},{"$f":"aire.acondicionado.espacio.maniobra","v":0.05}]
[null,{"$f":"B31+1","v":3},"Sala coubicación externa",null,null,null,null,1,0,0,0]
[null,4,"Subestación electrica",null,null,null,null,0,1,0,0]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,null,null,null,0,0,1,0]
[null,6,"Aire acondicionado",null,null,null,null,0,0,0,1]
[null,7,"Racks",null,null,null,null,1,0,0,0]
[null,null,null,null,null,null,null,"asignacion.coubicacion.CSs","asignacion.subestacion.electrica.CSs","asignacion.fuente.energia.respaldo.CSs","asignacion.aireacondicionado.CSs"]
[null,null,"Sub-elemento de la Central del AEP"]
[null,1,{"$f":"INDEX(lista.componentes.central.telmex,B39)","v":"Sala MDF/ODF AEP"},null,null,null,null,1,0,0,0]
[null,{"$f":"B39+1","v":2},"Sala coubicación CS",null,null,null,null,1,0,0,0]
[null,{"$f":"B40+1","v":3},"Sala de control",null,null,null,null,1,0,0,0]
[null,{"$f":"B41+1","v":4},"Sala de switching del AEP",null,null,null,null,1,0,0,0]
[null,{"$f":"B42+1","v":5},"Sala equipos de transmisión del AEP",null,null,null,null,1,0,0,0]
[null,6,"Sala subestacion electrica",null,null,null,null,0,1,0,0]
[null,7,"Sala planta de emergencia",null,null,null,null,{"$f":"IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,0,1)","v":0},0,{"$f":"IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,1,0)","v":1},0]
[null,8,"Sala baterias",null,null,null,null,{"$f":"IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,0,1)","v":0},0,{"$f":"IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,1,0)","v":1},0]
[null,9,"Espacio de overheads",null,null,null,null,1,0,0,0]
[null,10,"espacio vacante"]
[]
["Inclusion de gastos"]
[null,"Gastos incluidos"]
[null,null,null,null,null,null,null,"Capex","Opex","Gasto anual","Check","Inclusion AEP",null,"Capex","Opex","Gasto anual incluido",null,"Check"]
[null,null,"Elemento",null,"MXN/año",null,null,{"$f":"SUM(H54:H59)","v":531786.05700176267},{"$f":"SUM(I54:I59)","v":374001.19554408145},905787.2525458443,{"$f":"ROUND(J53, 2)=ROUND(SUM(H53:I53), 2)","v":true},null,null,{"$f":"SUM(N54:N60)","v":531786.05700176267},{"$f":"SUM(O54:O60)","v":374001.19554408145},905787.2525458443,null,{"$f":"ROUND(P53, 2)=ROUND(SUM(N53:O53), 2)","v":true}]
[null,1,{"$f":"INDEX(lista.activos,B54)","v":"Predio"},null,{"$f":"$E$53","v":"MXN/año"},null,null,{"$f":"capex.predio","v":7803.1309541389273},{"$f":"opex.predio","v":0},{"$f":"SUM(H54:I54)","v":7803.1309541389273},{"$f":"J54=gasto.anual.predio","v":true},true,null,{"$f":"H54*$L54","v":7803.1309541389273},0,7803.1309541389273,null,{"$f":"P54=J54*L54","v":true}]
[null,{"$f":"B54+1","v":2},"Central del AEP",null,{"$f":"$E$53","v":"MXN/año"},null,null,{"$f":"capex.central.telmex","v":244948.12450004884},{"$f":"opex.central.telmex","v":283880.57403895207},{"$f":"SUM(H55:I55)","v":528828.69853900094},{"$f":"J55=gasto.anual.central.telmex","v":true},true,null,244948.12450004884,283880.57403895207,528828.69853900094,null,true]
[null,{"$f":"B55+1","v":3},"Sala coubicación externa",null,"MXN/año",null,null,{"$f":"capex.sala.coubicacion.externa","v":0},{"$f":"opex.sala.coubicacion.externa","v":0},0,{"$f":"J56=gasto.anual.sala.coubicacion.externa","v":true},true,null,0,0,0,null,true]
[null,4,"Subestación electrica",null,"MXN/año",null,null,{"$f":"capex.subestacion.electrica","v":126712.41549476636},{"$f":"opex.subestacion.electrica","v":54112.489481661876},180824.90497642825,{"$f":"J57=gasto.anual.subestacion.electrica","v":true},true,null,126712.41549476636,54112.489481661876,180824.90497642825,null,true]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"MXN/año",null,null,{"$f":"capex.fuente.energia.respaldo","v":111183.61258065671},{"$f":"opex.fuente.energia.respaldo","v":34926.336494631512},146109.94907528823,{"$f":"J58=gasto.anual.fuente.energia.respaldo","v":true},true,null,111183.61258065671,34926.336494631512,146109.94907528823,null,true]
[null,6,"Aire acondicionado",null,"MXN/año",null,null,{"$f":"capex.aire.acondicionado","v":41138.773472151857},{"$f":"opex.aire.acondicionado","v":1081.7955288360001},42220.56900098786,{"$f":"J59=gasto.anual.aire.acondicionado","v":true},true,null,41138.773472151857,1081.7955288360001,42220.56900098786,null,true]
[null,7,{"$f":"INDEX(lista.activos,B60)","v":"Racks"},null,"MXN/año",null,null,{"$f":"capex.racks","v":0},{"$f":"opex.racks","v":0},0,{"$f":"J60=gasto.anual.racks","v":true},true,null,0,0,0,null,true]
[]
[null,null,"Servicios",null,null,null,null,{"$f":"SUM(H63:H66)","v":531786.05700176267},{"$f":"SUM(I63:I66)","v":374001.19554408145},{"$f":"SUM(J63:J66)","v":905787.25254584407}]
[null,1,{"$f":"INDEX(lista.servicios,B63)","v":"Coubicación"},null,{"$f":"$E$53","v":"MXN/año"},null,null,{"$f":"SUMPRODUCT(N54:N60,$H8:$H14)","v":157914.37939284652},{"$f":"SUMPRODUCT(O54:O60,$H8:$H14)","v":173970.17210668849},{"$f":"SUMPRODUCT(P54:P60,$H8:$H14)","v":331884.55149953504}]
[null,{"$f":"B63+1","v":2},{"$f":"INDEX(lista.servicios,B64)","v":"Subestación electrica"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(N54:N60,$I8:$I14)","v":193102.58659318028},{"$f":"SUMPRODUCT(O54:O60,$I8:$I14)","v":131054.82133429148},{"$f":"SUMPRODUCT(P54:P59,$I8:$I13)","v":324157.4079274718}]
[null,{"$f":"B64+1","v":3},{"$f":"INDEX(lista.servicios,B65)","v":"Fuente de energia de respaldo"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(N54:N60,$J8:$J14)","v":127382.91131858157},{"$f":"SUMPRODUCT(O54:O60,$J8:$J14)","v":53700.37787231784},{"$f":"SUMPRODUCT(P54:P59,$J8:$J13)","v":181083.28919089941}]
[null,4,{"$f":"INDEX(lista.servicios,B66)","v":"Aire acondicionado"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(N54:N60,$K8:$K14)","v":53386.179697154301},{"$f":"SUMPRODUCT(O54:O60,$K8:$K14)","v":15275.824230783604},{"$f":"SUMPRODUCT(P54:P60,$K8:$K14)","v":68662.003927937913}]
[null,null,null,null,null,null,null,{"$f":"H62=N53","v":true},{"$f":"I62=O53","v":true},{"$f":"J62=P53","v":true}]
[]
["Asignacion de gastos"]
[null,"Demanda (1 = Si, 0 = No)"]
[]
[null,null,"Elemento","Sub-elemento",null,null,null,null,"AEP","CSs",null,"Nota:"]
[null,1,{"$f":"INDEX(lista.activos,B73)","v":"Predio"},null,"(1 = Sí, 0 = No)",null,null,null,1,1,null,"Si un operador esta activo, ocupara estacio en piso"]
[null,null,1,{"$f":"INDEX(lista.componentes.predio,C74)","v":"Area caseta central"},"(1 = Sí, 0 = No)",null,null,null,1,1,null,"Si un operador esta activo, se asignara costos en la caseta central, ya que hay servicios que son compartidos"]
[null,null,{"$f":"C74+1","v":2},{"$f":"INDEX(lista.componentes.predio,C75)","v":"Area sala coubicacion externa"},"(1 = Sí, 0 = No)",null,null,null,0,{"$f":"IF(numero.CS.activo.CE>0,1,0)","v":0}]
[null,null,{"$f":"C75+1","v":3},{"$f":"INDEX(lista.componentes.predio,C76)","v":"Area libre"},"(1 = Sí, 0 = No)",null,null,null,1,1]
[null,2,{"$f":"INDEX(lista.activos,B77)","v":"Central del AEP"},null,"(1 = Sí, 0 = No)",null,null,null,1,1]
[null,3,"Sala coubicación externa",null,"(1 = Sí, 0 = No)",null,null,null,0,{"$f":"IF(numero.CS.activo.CE>0,1,0)","v":0}]
[null,4,"Subestación electrica",null,"(1 = Sí, 0 = No)",null,null,null,1,1]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"(1 = Sí, 0 = No)",null,null,null,1,{"$f":"IF(solicitacion.fuente.energia.respaldo.activo.CS=TRUE,1,0)","v":1}]
[null,6,"Aire acondicionado",null,"(1 = Sí, 0 = No)",null,null,null,1,{"$f":"IF(solicitacion.aire.acondicionado.activo=TRUE,1,0)","v":1}]
[null,7,{"$f":"INDEX(lista.activos,B82)","v":"Racks"},null,"(1 = Sí, 0 = No)",null,null,null,{"$f":"solicitacion.racks.activo*1","v":0},{"$f":"IF(solicitacion.racks.activo=TRUE,1,0)","v":0}]
[]
[null,"Drivers para asignacion de costos (unidades)"]
[null,null,null,null,null,null,null,"Cantidad driver por operador"]
[null,null,"Elemento","Sub-elemento","Driver","Unidades",null,"Total","AEP","CSs"]
[null,1,{"$f":"INDEX(lista.activos,B87)","v":"Predio"},null,null,null,null,null,null,null,null,"Nota:"]
[null,null,1,{"$f":"INDEX(lista.componentes.predio,C88)","v":"Area caseta central"},"Espacio funcional utilizado por operador en la central","m2",null,{"$f":"H115","v":152.46752915789475},{"$f":"I115","v":107.84364493566773},{"$f":"J115","v":44.623884222227005},null,"Espacio funcional utilizado = espacio o sala dedicado/a a un operador, más cuota de espacio para usos comunes (sala subestación eléctrica, sala planta de emergencia, sala baterías, sala aire acondicionado, sala de control, espacios overhead)\n"]
[null,null,{"$f":"C88+1","v":2},{"$f":"INDEX(lista.componentes.predio,C89)","v":"Area sala coubicacion externa"},"Espacio para coubicación en CE por CS en CE","m2",null,{"$f":"SUM(I89:J89)","v":0},0,{"$f":"area.sala.coubicacion.externa.CS","v":0}]
[null,null,{"$f":"C89+1","v":3},{"$f":"INDEX(lista.componentes.predio,C90)","v":"Area libre"},"Espacio funcional utilizado por operador","m2",null,{"$f":"(H88*(1+markup.area.exterior.central.telmex)/numero.plantas.central.telmex.activo+H89*(1+markup.sala.CS))","v":76.233764578947373},{"$f":"(I88*(1+markup.area.exterior.central.telmex)/numero.plantas.central.telmex.activo)+IF(area.libre.CS=FALSE,(SUM(K88:M89)*(1+markup.area.exterior.central.telmex)/numero.plantas.central.telmex.activo),0)","v":53.921822467833863},{"$f":"((J88*(1+markup.area.exterior.central.telmex)/numero.plantas.central.telmex.activo)+(J89*(1+markup.sala.CS)))*area.libre.CS","v":22.311942111113503}]
[null,2,{"$f":"INDEX(lista.activos,B91)","v":"Central del AEP"}]
[null,null,1,{"$f":"INDEX(lista.componentes.central.telmex,C92)","v":"Sala MDF/ODF AEP"},"Espacio dedicado al AEP y entonces asignado 100% al AEP\n","m2",null,{"$f":"SUM(I92:J92)","v":14.447999999999999},{"$f":"area.sala.MDF.AEP","v":14.447999999999999},0]
[null,null,{"$f":"C92+1","v":2},"Sala coubicación CS","Espacio dedicado a los CSs y asignado a cada CS según su demanda de espacio en CI","m2",null,22.96,0,{"$f":"area.sala.coubicacion.CS","v":22.96}]
[null,null,{"$f":"C93+1","v":3},"Sala de control","Pro-rata según los espacios dedicados a cada operador","m2",null,78.448000000000008,{"$f":"espacio.exclusivo.AEP","v":55.488},{"$f":"espacio.coubicacion.activo.porCS*numero.CS.activo*sala.control.CS.activo","v":22.96}]
[null,null,{"$f":"C94+1","v":4},"Sala de switching del AEP","Espacio dedicado al AEP y entonces asignado 100% al AEP\n","m2",null,55.488,{"$f":"espacio.exclusivo.AEP","v":55.488},{"$f":"espacio.coubicacion.activo.porCS*numero.CS.activo*sala.switching.CS.activo","v":0}]
[null,null,{"$f":"C95+1","v":5},"Sala equipos de transmisión del AEP","Espacio dedicado al AEP y entonces asignado 100% al AEP\n","m2",null,55.488,{"$f":"espacio.exclusivo.AEP","v":55.488},{"$f":"espacio.coubicacion.activo.porCS*numero.CS.activo*sala.equipos.transmision.CS.activo","v":0}]
[null,null,6,"Sala subestacion electrica","Energía requerida por cada operador","kW",null,86.998832000000007,{"$f":"consumo.equipos.AEP","v":61.536192},{"$f":"consumo.equipos.porCS*numero.CS.activo*sala.subestacion.electrica.CS.activo","v":25.462640000000007}]
[null,null,7,"Sala planta de emergencia","Energía requerida por cada operador","kW",null,86.998832000000007,{"$f":"consumo.equipos.AEP*fuente.energia.respaldo.activo.AEP","v":61.536192},{"$f":"consumo.equipos.porCS*numero.CS.activo*solicitacion.fuente.energia.respaldo.activo.CS*sala.planta.emergencia.CS.activo","v":25.462640000000007}]
[null,null,8,"Sala baterias","Energía requerida por cada operador","kW",null,86.998832000000007,{"$f":"consumo.equipos.AEP*fuente.energia.respaldo.activo.AEP","v":61.536192},{"$f":"consumo.equipos.porCS*numero.CS.activo*solicitacion.fuente.energia.respaldo.activo.CS*sala.baterias.CS.activo","v":25.462640000000007}]
[null,null,9,"Espacio de overheads","Espacio funcional (excl. overhead) utilizado por operador en la central","m2",null,{"$f":"SUM(H116:J123)","v":285.12267410526312},{"$f":"SUM(I116:I123)","v":100.83677685060702},{"$f":"SUM(J116:J123)*espacio.incremental.activo","v":41.724560202024549}]
[null,null,10,"espacio vacante",null,"m2"]
[null,3,"Sala coubicación externa",null,"Espacio dedicado a los CSs y asignado a cada CS según su demanda de espacio en CE","m2",null,{"$f":"SUM(I102:J102)","v":0},0,{"$f":"area.sala.coubicacion.externa.CS","v":0}]
[null,4,"Subestación electrica",null,"Energía requerida por cada operador","kW",null,{"$f":"SUM(I103:J103)","v":86.998832000000007},{"$f":"consumo.equipos.AEP","v":61.536192},{"$f":"consumo.equipos.porCS*numero.CS.activo","v":25.462640000000007}]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"Energía requerida por cada operador","kW",null,{"$f":"SUM(I104:J104)","v":86.998832000000007},{"$f":"consumo.equipos.AEP*fuente.energia.respaldo.activo.AEP","v":61.536192},{"$f":"consumo.equipos.porCS*numero.CS.activo*solicitacion.fuente.energia.respaldo.activo.CS","v":25.462640000000007}]
[null,6,"Aire acondicionado",null,"Espacio ocupado de las salas de la central (excl. aire acondicionado)","m2",null,{"$f":"H88","v":152.46752915789475},{"$f":"I88","v":107.84364493566773},{"$f":"J88","v":44.623884222227005}]
[null,7,{"$f":"INDEX(lista.activos,B106)","v":"Racks"},null,"Numero de racks","#",null,{"$f":"SUM(I106:J106)","v":0},0,{"$f":"unidades.racks.activo","v":0}]
[]
[null,"Demanda para asignacion (unidades de costos)"]
[]
[null,null,"Elemento","Sub-elemento","Unidad",null,null,"Total","AEP","CSs"]
[null,1,{"$f":"INDEX(lista.activos,B111)","v":"Predio"},null,"m2",null,null,{"$f":"area.total.predio","v":114.35064686842105},{"$f":"SUM(I112:I114)","v":80.882733701750794},{"$f":"SUM(J112:J114)","v":33.46791316667025},{"$f":"ROUND(SUM(I111:J111),2)=ROUND(H111,2)","v":true}]
[null,null,1,{"$f":"INDEX(lista.componentes.predio,C112)","v":"Area caseta central"},"m2",null,null,{"$f":"area.exterior.central.telmex","v":76.233764578947373},{"$f":"I88/$H$88*$H$112","v":53.921822467833863},{"$f":"J88/$H$88*$H$112","v":22.311942111113503},true]
[null,null,{"$f":"C112+1","v":2},{"$f":"INDEX(lista.componentes.predio,C113)","v":"Area sala coubicacion externa"},"m2",null,null,{"$f":"area.sala.coubicacion.externa.CS","v":0},{"$f":"IF($H$113=0,0,I89/$H$89*$H$113)","v":0},{"$f":"IF($H$113=0,0,J89/$H$89*$H$113)","v":0},true]
[null,null,{"$f":"C113+1","v":3},{"$f":"INDEX(lista.componentes.predio,C114)","v":"Area libre"},"m2",null,null,{"$f":"H111-SUM(H112:H113)","v":38.116882289473679},{"$f":"I90/$H$90*$H$114","v":26.960911233916924},{"$f":"J90/$H$90*$H$114","v":11.15597105555675},true]
[null,2,{"$f":"INDEX(lista.activos,B115)","v":"Central del AEP"},null,"m2",null,null,{"$f":"area.salas.central.telmex","v":152.46752915789475},{"$f":"SUM(I116:I125)","v":107.84364493566773},{"$f":"SUM(J116:J125)","v":44.623884222227005},true]
[null,null,1,{"$f":"INDEX(lista.componentes.central.telmex,C116)","v":"Sala MDF/ODF AEP"},"m2",null,null,{"$f":"area.sala.MDF.AEP","v":14.447999999999999},{"$f":"I92/$H$92*$H$116","v":14.447999999999999},{"$f":"J92/$H$92*$H$116","v":0},true]
[null,null,{"$f":"C116+1","v":2},"Sala coubicación CS","m2",null,null,{"$f":"area.sala.coubicacion.CS","v":22.96},{"$f":"IF($H$117=0,0,I93/$H$93*$H$117)","v":0},{"$f":"IF($H$117=0,0,J93/$H$93*$H$117)","v":22.96},true]
[null,null,{"$f":"C117+1","v":3},"Sala de control","m2",null,null,{"$f":"area.sala.control","v":10},{"$f":"I94/$H94*$H118","v":7.0732204772588201},{"$f":"J94/$H94*$H118","v":2.9267795227411786},true]
[null,null,{"$f":"C118+1","v":4},"Sala de switching del AEP","m2",null,null,{"$f":"area.sala.switching","v":20.52},{"$f":"I95/$H95*$H119","v":20.52},{"$f":"J95/$H95*$H119","v":0},true]
[null,null,{"$f":"C119+1","v":5},"Sala equipos de transmisión del AEP","m2",null,null,{"$f":"area.sala.transmision","v":20.52},{"$f":"I96/$H96*$H120","v":20.52},{"$f":"J96/$H96*$H120","v":0},true]
[null,null,6,"Sala subestacion electrica","m2",null,null,{"$f":"area.sala.subestacion.electrica","v":43.499416000000004},{"$f":"I97/$H97*$H121","v":30.768096},{"$f":"J97/$H97*$H121","v":12.731320000000006},true]
[null,null,7,"Sala planta de emergencia","m2",null,null,{"$f":"area.sala.emergencia","v":7.0439210526315801},{"$f":"I98/$H98*$H122","v":4.9823206629668197},2.0616003896647603,true]
[null,null,8,"Sala baterias","m2",null,null,{"$f":"area.sala.baterias","v":3.5700000000000003},{"$f":"I99/$H99*$H123","v":2.5251397103813988},{"$f":"J99/$H99*$H123","v":1.0448602896186012},true]
[null,null,9,"Espacio de overheads","m2",null,null,{"$f":"area.espacio.overheads","v":9.9061921052631572},{"$f":"SUM(I$116:I$123)/SUM($H$116:$H$123)*$H$124","v":7.0068680850607015},{"$f":"SUM(J$116:J$123)/SUM($H$116:$H$123)*$H$124","v":2.8993240202024539},true]
[null,null,10,"espacio vacante","m2",null,null,null,{"$f":"SUM(I$116:I$124)/SUM($H$116:$H$124)*$H$125","v":0},{"$f":"SUM(J$116:J$124)/SUM($H$116:$H$124)*$H$125","v":0},true]
[null,3,"Sala coubicación externa",null,"m2",null,null,{"$f":"area.sala.coubicacion.externa.CS","v":0},{"$f":"IF($H$126=0,0,I102/$H$102*$H$126)","v":0},{"$f":"IF($H$126=0,0,J102/$H$102*$H$126)","v":0},true]
[null,4,"Subestación electrica",null,"kW",null,null,{"$f":"consumo.equipos.subestacion.electrica","v":86.998832000000007},{"$f":"I103/$H$103*$H$127","v":61.536192},{"$f":"J103/$H$103*$H$127","v":25.462640000000011},true]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"kW",null,null,{"$f":"potencia.minima.fuente.energia.respaldo","v":69.599065600000003},{"$f":"I104/$H$104*$H$128","v":49.228953599999997},{"$f":"J104/$H$104*$H$128","v":20.370112000000006},true]
[null,6,"Aire acondicionado",null,"tons",null,null,{"$f":"capacidad.utilizada.aire.acondicionado","v":15.246752915789475},{"$f":"I105/$H$105*$H$129","v":10.784364493566773},{"$f":"J105/$H$105*$H$129","v":4.462388422222701},true]
[null,7,{"$f":"INDEX(lista.activos,B130)","v":"Racks"},null,"#",null,null,{"$f":"H106","v":0},{"$f":"I106","v":0},{"$f":"J106","v":0},true]
[]
[null,"Asignacion de la demanda total de todos los operadores"]
[]
[null,null,"Elemento","Sub-elemento","Unidad",null,null,"Total","AEP","CSs"]
[null,1,{"$f":"INDEX(lista.activos,B135)","v":"Predio"},null,"m2",null,null,{"$f":"H111","v":114.35064686842105},{"$f":"IF($H135=0,0,I111/$H111)","v":0.70732204772588203},{"$f":"IF($H135=0,0,J111/$H111)","v":0.29267795227411791},{"$f":"IF(H135=0,SUM(I135:J135)=0,SUM(I135:J135)=1)","v":true}]
[null,null,1,{"$f":"INDEX(lista.componentes.predio,C136)","v":"Area caseta central"},"m2",null,null,76.233764578947373,0.70732204772588192,0.29267795227411797,true]
[null,null,{"$f":"C136+1","v":2},{"$f":"INDEX(lista.componentes.predio,C137)","v":"Area sala coubicacion externa"},"m2",null,null,0,0,0,true]
[null,null,{"$f":"C137+1","v":3},{"$f":"INDEX(lista.componentes.predio,C138)","v":"Area libre"},"m2",null,null,38.116882289473679,0.70732204772588192,0.29267795227411797,true]
[null,2,{"$f":"INDEX(lista.activos,B139)","v":"Central del AEP"},null,"m2",null,null,152.46752915789475,0.70732204772588192,0.29267795227411797,true]
[null,null,1,{"$f":"INDEX(lista.componentes.central.telmex,C140)","v":"Sala MDF/ODF AEP"},"m2",null,null,14.447999999999999,{"$f":"IF($H140=0,0,I116/$H116)","v":1},0,true]
[null,null,{"$f":"C140+1","v":2},"Sala coubicación CS","m2",null,null,22.96,{"$f":"IF($H141=0,0,I117/$H117)","v":0},1,true]
[null,null,{"$f":"C141+1","v":3},"Sala de control","m2",null,null,10,{"$f":"IF($H142=0,0,I118/$H118)","v":0.70732204772588203},0.29267795227411786,true]
[null,null,{"$f":"C142+1","v":4},"Sala de switching del AEP","m2",null,null,20.52,{"$f":"IF($H143=0,0,I119/$H119)","v":1},0,true]
[null,null,{"$f":"C143+1","v":5},"Sala equipos de transmisión del AEP","m2",null,null,20.52,{"$f":"IF($H144=0,0,I120/$H120)","v":1},0,true]
[null,null,6,"Sala subestacion electrica","m2",null,null,43.499416000000004,{"$f":"IF($H145=0,0,I121/$H121)","v":0.70732204772588203},0.29267795227411797,true]
[null,null,7,"Sala planta de emergencia","m2",null,null,7.0439210526315801,{"$f":"IF($H146=0,0,I122/$H122)","v":0.70732204772588203},0.29267795227411797,true]
[null,null,8,"Sala baterias","m2",null,null,3.5700000000000003,{"$f":"IF($H147=0,0,I123/$H123)","v":0.70732204772588192},0.29267795227411797,true]
[null,null,9,"Espacio de overheads","m2",null,null,9.9061921052631572,{"$f":"IF($H148=0,0,I124/$H124)","v":0.70732204772588192},0.29267795227411791,true]
[null,null,10,"espacio vacante","m2",null,null,0,{"$f":"IF($H149=0,0,I125/$H125)","v":0},0,true]
[null,3,{"$f":"INDEX(lista.activos,B150)","v":"Sala coubicación externa"},null,"m2",null,null,0,{"$f":"IF($H150=0,0,I126/$H126)","v":0},0,true]
[null,4,"Subestación electrica",null,"kW",null,null,86.998832000000007,{"$f":"IF($H151=0,0,I127/$H127)","v":0.70732204772588203},0.29267795227411797,true]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"kW",null,null,69.599065600000003,{"$f":"IF($H152=0,0,I128/$H128)","v":0.70732204772588203},0.29267795227411797,true]
[null,6,"Aire acondicionado",null,"tons",null,null,15.246752915789475,{"$f":"IF($H153=0,0,I129/$H129)","v":0.70732204772588192},0.29267795227411797,true]
[null,6,{"$f":"INDEX(lista.activos,B154)","v":"Aire acondicionado"},null,"#",null,null,0,0,0,true]
[]
[null,"Desglose de gastos anuales"]
[null,null,null,null,null,null,null,"Capex","Opex","Gasto anual"]
[null,null,"Elemento",null,"MXN/año",null,null,{"$f":"N53","v":531786.05700176267},374001.19554408145,905787.2525458443,{"$f":"ROUND(H158, 2)=ROUND(SUM(H169,H186), 2)","v":true},{"$f":"ROUND(I158, 2)=ROUND(SUM(I169,I186), 2)","v":true},{"$f":"ROUND(J158, 2)=ROUND(SUM(J169,J186), 2)","v":true}]
[null,1,{"$f":"INDEX(lista.activos,B159)","v":"Predio"},null,{"$f":"$E$158","v":"MXN/año"},null,null,7803.1309541389273,0,7803.1309541389273,{"$f":"ROUND(H159, 2)=ROUND(SUM(H170,H187), 2)","v":true},true,true,null,{"$f":"H159=capex.predio","v":true},{"$f":"I159=opex.predio","v":true}]
[null,{"$f":"B159+1","v":2},"Central del AEP",null,{"$f":"$E$158","v":"MXN/año"},null,null,244948.12450004884,283880.57403895207,528828.69853900094,{"$f":"ROUND(H160, 2)=ROUND(SUM(H171,H188), 2)","v":true},true,true,null,{"$f":"H160=capex.central.telmex","v":true},{"$f":"I160=opex.central.telmex","v":true}]
[null,{"$f":"B160+1","v":3},"Sala coubicación externa",null,"MXN/año",null,null,0,0,0,{"$f":"ROUND(H161, 2)=ROUND(SUM(H172,H189), 2)","v":true},true,true,null,{"$f":"H161=capex.sala.coubicacion.externa","v":true},{"$f":"I161=opex.sala.coubicacion.externa","v":true}]
[null,4,"Subestación electrica",null,"MXN/año",null,null,126712.41549476636,54112.489481661876,180824.90497642825,{"$f":"ROUND(H162, 2)=ROUND(SUM(H173,H190), 2)","v":true},true,true,null,{"$f":"H162=capex.subestacion.electrica","v":true},{"$f":"I162=opex.subestacion.electrica","v":true}]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"MXN/año",null,null,111183.61258065671,34926.336494631512,146109.94907528823,{"$f":"ROUND(H163, 2)=ROUND(SUM(H174,H191), 2)","v":true},true,true,null,{"$f":"H163=capex.fuente.energia.respaldo","v":true},{"$f":"I163=opex.fuente.energia.respaldo","v":true}]
[null,6,"Aire acondicionado",null,"MXN/año",null,null,41138.773472151857,1081.7955288360001,42220.56900098786,{"$f":"ROUND(H164, 2)=ROUND(SUM(H175,H192), 2)","v":true},true,true,null,{"$f":"H164=capex.aire.acondicionado","v":true},{"$f":"I164=opex.aire.acondicionado","v":true}]
[null,7,{"$f":"INDEX(lista.activos,B165)","v":"Racks"},null,"MXN/año",null,null,0,0,0,{"$f":"ROUND(H165, 2)=ROUND(SUM(H176,H193), 2)","v":true},true,true,null,{"$f":"H165=capex.racks","v":true},{"$f":"I165=opex.racks","v":true}]
[]
[null,null,"AEP"]
[null,null,null,null,null,null,null,"Capex","Opex","Gasto anual"]
[null,null,"Elemento",null,"MXN/año",null,null,{"$f":"SUM(H170:H175)","v":376144.00279055937},{"$f":"SUM(I170:I175)","v":264539.29148416768},640683.29427472712]
[null,1,{"$f":"INDEX(lista.activos,B170)","v":"Predio"},null,{"$f":"$E$158","v":"MXN/año"},null,null,{"$f":"H159*$I$135","v":5519.3265651547617},{"$f":"I159*$I$135","v":0},5519.3265651547617]
[null,{"$f":"B170+1","v":2},"Central del AEP",null,{"$f":"$E$158","v":"MXN/año"},null,null,{"$f":"H160*$I139","v":173257.2090079888},{"$f":"I160*$I139","v":200794.98893883041},374052.19794681924]
[null,{"$f":"B171+1","v":3},"Sala coubicación externa",null,"MXN/año",null,null,{"$f":"H161*$I150","v":0},0,0]
[null,4,"Subestación electrica",null,"MXN/año",null,null,{"$f":"H162*$I151","v":89626.485200050927},38274.956867714332,127901.44206776527]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"MXN/año",null,null,{"$f":"H163*$I152","v":78642.620524111248},24704.167848945966,103346.78837305721]
[null,6,"Aire acondicionado",null,"MXN/año",null,null,{"$f":"H164*$I153","v":29098.36149325364},765.17782867698293,29863.539321930624]
[null,7,{"$f":"INDEX(lista.activos,B176)","v":"Racks"},null,"MXN/año",null,null,0,0,0]
[]
[null,null,"Servicios",null,null,null,null,{"$f":"SUM(H179:H182)","v":376144.00279055937},{"$f":"SUM(I179:I182)","v":264539.29148416762},{"$f":"SUM(J179:J182)","v":640683.29427472712}]
[null,1,{"$f":"INDEX(lista.servicios,B179)","v":"Coubicación"},null,{"$f":"$E$158","v":"MXN/año"},null,null,{"$f":"SUMPRODUCT(H170:H176,$H$8:$H$14)","v":111696.32219751},{"$f":"SUMPRODUCT(I170:I176,$H$8:$H$14)","v":123052.93837772701},234749.26057523704]
[null,{"$f":"B179+1","v":2},{"$f":"INDEX(lista.servicios,B180)","v":"Subestación electrica"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(H170:H176,$I$8:$I$14)","v":136585.71697025272},{"$f":"SUMPRODUCT(I170:I176,$I$8:$I$14)","v":92697.964590520656},229283.6815607734]
[null,{"$f":"B180+1","v":3},{"$f":"INDEX(lista.servicios,B181)","v":"Fuente de energia de respaldo"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(H170:H176,$J$8:$J$14)","v":90100.741679143553},{"$f":"SUMPRODUCT(I170:I176,$J$8:$J$14)","v":37983.461240301498},128084.20291944504]
[null,4,{"$f":"INDEX(lista.servicios,B182)","v":"Aire acondicionado"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(H170:H176,$K$8:$K$14)","v":37761.22194365308},{"$f":"SUMPRODUCT(I170:I176,$K$8:$K$14)","v":10804.927275618504},48566.149219271589]
[]
[null,null,"CSs"]
[null,null,null,null,null,null,null,"Capex","Opex","Gasto anual"]
[null,null,"Elemento",null,"MXN/año",null,null,{"$f":"SUM(H187:H193)","v":155642.05421120333},{"$f":"SUM(I187:I193)","v":109461.90405991375},{"$f":"SUM(J187:J193)","v":265103.95827111707}]
[null,1,{"$f":"INDEX(lista.activos,B187)","v":"Predio"},null,{"$f":"$E$158","v":"MXN/año"},null,null,{"$f":"H159-H170","v":2283.8043889841656},{"$f":"I159-I170","v":0},2283.8043889841656]
[null,{"$f":"B187+1","v":2},"Central del AEP",null,{"$f":"$E$158","v":"MXN/año"},null,null,{"$f":"H160-H171","v":71690.915492060041},83085.585100121651,154776.50059218169]
[null,{"$f":"B188+1","v":3},"Sala coubicación externa",null,"MXN/año",null,null,0,0,0]
[null,4,"Subestación electrica",null,"MXN/año",null,null,37085.930294715436,15837.532613947544,52923.462908662987]
[null,5,"Fuente de energia de respaldo (planta de emergencia)",null,"MXN/año",null,null,32540.992056545467,10222.168645685546,42763.16070223102]
[null,6,"Aire acondicionado",null,"MXN/año",null,null,12040.411978898217,316.6177001590172,12357.029679057236]
[null,7,"Racks",null,"MXN/año",null,null,{"$f":"H165-H176","v":0},{"$f":"I165-I176","v":0},{"$f":"J165-J176","v":0}]
[]
[null,null,"Servicios",null,null,null,null,{"$f":"SUM(H196:H199)","v":155642.05421120333},{"$f":"SUM(I196:I199)","v":109461.90405991375},{"$f":"SUM(J196:J199)","v":265103.95827111707}]
[null,1,{"$f":"INDEX(lista.servicios,B196)","v":"Coubicación"},null,{"$f":"$E$158","v":"MXN/año"},null,null,{"$f":"SUMPRODUCT(H$187:H$193,asignacion.coubicacion.CSs)","v":46218.057195336514},{"$f":"SUMPRODUCT(I$187:I$193,asignacion.coubicacion.CSs)","v":50917.233728961481},{"$f":"SUMPRODUCT(J$187:J$193,asignacion.coubicacion.CSs)","v":97135.290924297995}]
[null,{"$f":"B196+1","v":2},{"$f":"INDEX(lista.servicios,B197)","v":"Subestación electrica"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(H187:H193,asignacion.subestacion.electrica.CSs)","v":56516.869622927567},{"$f":"SUMPRODUCT(I187:I193,asignacion.subestacion.electrica.CSs)","v":38356.856743770826},{"$f":"SUMPRODUCT(J187:J193,asignacion.subestacion.electrica.CSs)","v":94873.726366698393}]
[null,{"$f":"B197+1","v":3},{"$f":"INDEX(lista.servicios,B198)","v":"Fuente de energia de respaldo"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(H187:H193,asignacion.fuente.energia.respaldo.CSs)","v":37282.16963943802},{"$f":"SUMPRODUCT(I187:I193,asignacion.fuente.energia.respaldo.CSs)","v":15716.916632016342},{"$f":"SUMPRODUCT(J187:J193,asignacion.fuente.energia.respaldo.CSs)","v":52999.086271454369}]
[null,4,{"$f":"INDEX(lista.servicios,B199)","v":"Aire acondicionado"},null,"MXN/año",null,null,{"$f":"SUMPRODUCT(H187:H193,asignacion.aireacondicionado.CSs)","v":15624.957753501219},{"$f":"SUMPRODUCT(I187:I193,asignacion.aireacondicionado.CSs)","v":4470.8969551651007},{"$f":"SUMPRODUCT(J187:J193,asignacion.aireacondicionado.CSs)","v":20095.85470866632}]

{"sheet":"Servicios complementarios","index":9,"n_rows":103,"n_cols":9,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Servicios complementarios"]
[]
[null,null,null,"Elemento","Unidad","Valor","Nombre 1","Check / Indices","Nombre 2"]
[]
["Cobros no recurrentes"]
[]
["Gastos de instalación coubicación"]
[null,"Costos unitarios"]
[null,null,null,"Obra civil CI","MXN por m2",7113]
[null,null,null,"Obra civil CE","MXN por m2",16463]
[null,null,null,"Instalación Eléctrica","MXN por m2",2388]
[null,null,null,"Clima (Equipo)","MXN",22000]
[null,null,null,"Racks","MXN por unidad",6435]
[]
[null,"Output - Cobros no Recurrentes - Contraprestación Pago Único"]
[null,null,"Coubicacion Basica"]
[null,null,null,{"$f":"\"Gastos de instalación Co-ubicación \" & H17 & \"m2 Interna\"","v":"Gastos de instalación Co-ubicación 20m2 Interna"},"MXN",{"$f":"($F$9+$F$11)*H17+$F$12","v":212020},null,{"$f":"espacio.coubicacion.basica","v":20},"m2"]
[null,null,null,{"$f":"\"Gastos de instalación Co-ubicación \" & H18 & \"m2 Externa\"","v":"Gastos de instalación Co-ubicación 20m2 Externa"},"MXN",{"$f":"($F$10+$F$11)*H18+$F$12","v":399020},null,{"$f":"espacio.coubicacion.basica","v":20},"m2"]
[]
[null,null,"Coubicacion Equipada"]
[null,null,null,"Gastos de instalación Co-ubicación 1 Rack Interna","MXN",{"$f":"$F$28/$H$28*calculos.secundarios.dimension.racks+$F$13","v":26344.074074074077}]
[null,null,null,"Gastos de instalación Co-ubicación 1 Rack externa",null,{"$f":"$F$29/$H$29*calculos.secundarios.dimension.racks+$F$13","v":41927.407407407409}]
[]
[null,null,"Coubicacion Cerrada"]
[null,null,null,{"$f":"\"Gastos de instalación Co-ubicación \" & H25 & \"m2 Interna\"","v":"Gastos de instalación Co-ubicación 4m2 Interna"},"MXN",{"$f":"($F$9+$F$11)*H25+$F$12","v":60004},null,{"$f":"L!$C$66","v":4},"m2"]
[null,null,null,{"$f":"\"Gastos de instalación Co-ubicación \" & H26 & \"m2 Externa\"","v":"Gastos de instalación Co-ubicación 4m2 Externa"},"MXN",{"$f":"($F$10+$F$11)*H26+$F$12","v":97404},null,{"$f":"L!$C$66","v":4},"m2"]
[]
[null,null,null,{"$f":"\"Gastos de instalación Co-ubicación \" & H28 & \"m2 Interna\"","v":"Gastos de instalación Co-ubicación 9m2 Interna"},"MXN",{"$f":"($F$9+$F$11)*H28+$F$12","v":107509},null,{"$f":"L!$C$67","v":9},"m2"]
[null,null,null,{"$f":"\"Gastos de instalación Co-ubicación \" & H29 & \"m2 Externa\"","v":"Gastos de instalación Co-ubicación 9m2 Externa"},"MXN",{"$f":"($F$10+$F$11)*H29+$F$12","v":191659},null,{"$f":"L!$C$67","v":9},"m2"]
[]
["Gastos de instalación metro lineal de construcción de escalleria"]
[null,"Costos unitarios"]
[null,null,null,"Escalerilla 6\" para F.O. incluye fijación en losa","MXN, 50 metros lineales",23100]
[null,null,null,"Escalerilla de aluminio de 6\" a 8\" para cableado UTP Y/O Coaxial","MXN, 50 metros lineales",19250]
[]
[null,"Output - Cobros no Recurrentes - Contraprestación Pago Único"]
[]
[null,null,null,"Gastos de Instalación Metro lineal de construcción de escalerilla ","MXN",{"$f":"SUM(F33:F34)/50","v":847}]
[]
["Gastos de instalación metro lineal de ductería para coubicación externa"]
[null,"Costos unitarios"]
[null,null,null,"Trabajos iniciales","MXN, 25 metros lineales",75474.5625]
[]
[null,"Output - Cobros no Recurrentes - Contraprestación Pago Único"]
[null,null,null,"G.I. de Metro Lineal de Ductería para Co-ubicación Externa ","MXN",{"$f":"F42/25","v":3018.9825000000001}]
[]
["Adecuaciones en la coubicación"]
[null,"Costos unitarios"]
[null,null,null,"Trabajos iniciales","MXN",1603.13]
[]
[null,"Output - Cobros no Recurrentes - Contraprestación Pago Único"]
[null,null,null,"Cambio en la Capacidad de Interruptor Termo magnético ","MXN",{"$f":"F49","v":1603.13}]
[]
[]
["Cobros recurrentes"]
[]
["Metro lineal de escalerilla "]
[null,"Costos unitarios"]
[null,null,null,"Cuota de Mantenimiento Mensual","MXN",1.1915563333333339]
[null,null,null,"Cuota de Gastos de Administración Mensual","MXN",1.304144333333334]
[null,null,null,"Costo de uso de Escalerilla","MXN",9.6880042521538812]
[]
[null,"Output - Contraprestación Mensual"]
[null,null,null,"Metro lineal de escalerilla ","MXN",{"$f":"SUM(F59:F61)","v":12.183704918820549}]
[]
["Metro Lineal de Ductería para Co-ubicación Externa "]
[null,"Costos unitarios"]
[null,null,null,"Cuota de Mantenimiento Mensual","MXN",1.1915563333333339]
[null,null,null,"Cuota de Gastos de Administración Mensual","MXN",1.304144333333334]
[null,null,null,"Costo de uso de Escalerilla","MXN",12.567797669117061]
[]
[null,"Output - Contraprestación Mensual"]
[null,null,null,"Metro Lineal de Ductería para Co-ubicación Externa ","MXN",{"$f":"SUM(F68:F70)","v":15.063498335783729}]
[]
["Cobros adicionales del interruptor termo magnético"]
[null,"Drivers y costos unitarios"]
[null,null,null,"Tarifa","KWh",1.89]
[null,null,null,"Amperaje por Metro cuadrado","AMP",2.8]
[null,null,null,"Capacidad","Amperes por tablilla",15]
[null,null,null,"Metros","m2",20]
[null,null,null,"Tablillas promedio por Coubicación","#",{"$f":"F80*F78/F79","v":3.7333333333333334}]
[null,null,null,"Metros por Tablilla","m2",{"$f":"F80/F81","v":5.3571428571428568}]
[]
[null,null,null,"Concepto","Amp","V","KW","KWH","Tablilla"]
[null,null,null,"Corriente Alterna Esencial",{"$f":"F79","v":15},220,{"$f":"E85*F85*0.9*2/1000","v":5.94},{"$f":"G85*24*30","v":4276.8},{"$f":"H85*$F$77","v":8083.152}]
[null,null,null,"Corriente Directa Respaldo 4 hrs",{"$f":"F79","v":15},48,{"$f":"E86*F86*1.1/1000","v":0.79200000000000015},{"$f":"G86*24*30","v":570.24000000000012},{"$f":"H86*$F$77","v":1077.7536000000002}]
[null,null,null,"TOTAL",null,null,null,null,{"$f":"SUM(I85:I86)","v":9160.9056}]
[]
[null,"Output - Contraprestación Mensual"]
[null,null,null,"Capacidad","Costo Tablilla","Costo por Metro2"]
[null,null,null,null,{"$f":"I87","v":9160.9056}]
[null,null,null,15,9160.9056,{"$f":"E92/$F$82","v":1710.0357120000001}]
[null,null,null,20,12214.540799999999,{"$f":"E93/$F$82","v":2280.0476159999998}]
[null,null,null,30,18321.8112,3420.0714240000002]
[null,null,null,40,24429.081599999998,4560.0952319999997]
[null,null,null,50,30536.352000000003,5700.1190400000005]
[null,null,null,60,36643.6224,6840.1428480000004]
[null,null,null,70,42750.892799999994,7980.1666559999994]
[null,null,null,80,48858.163199999995,9120.1904639999993]
[null,null,null,90,54965.433599999997,10260.214271999999]
[null,null,null,100,61072.704000000005,11400.238080000001]
[null,null,null,150,91609.055999999982,17100.357119999997]
[null,null,null,200,122145.40800000001,22800.476160000002]