{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Hipoteca Free","anticipos","RESTO DE PRODUCTOS","requisitos","CALCULO Empleados","Análisis Costos"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hipoteca Free","index":0,"n_rows":120,"n_cols":256,"rows_kept":120,"cut":false,"hidden":false,"merged":[[63,15,63,19],[67,16,67,18],[68,5,68,11],[68,14,68,17],[69,16,69,18],[70,4,70,5],[70,7,70,11],[70,14,70,17],[105,0,105,5],[105,7,105,19],[89,1,89,19],[91,7,91,19],[92,7,96,19],[97,7,99,19],[100,7,101,19],[102,7,103,19],[104,7,104,19],[16,4,16,6],[16,9,16,14],[16,16,16,19],[19,7,19,9],[20,0,20,9],[19,10,19,13],[21,0,23,10],[21,13,21,16],[22,11,22,12],[22,14,22,19],[23,14,23,19],[24,8,25,13],[26,11,28,19],[39,12,40,19],[45,5,45,9],[58,14,59,16],[51,12,51,14],[52,13,52,14],[53,12,53,14],[54,12,54,14],[14,13,14,14],[2,9,2,19],[3,16,3,19],[4,16,4,19],[5,16,5,19]]}
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=9,\"SOLICITUD DE AVALUO Y ESTUDIO DE COSTOS\",IF(requisitos!I14=10,\"SOLICITUD DE AVALUO Y ESTUDIO DE COSTOS\",\"SOLICITUD AVALUO\"))","v":"SOLICITUD AVALUO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIPOTECARIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE EXPEDICIÓN"]
["BANCO SANTANDER MEXICO,SOCIEDAD ANONIMA, INSTITUCION DE BANCA MULTIPLE.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2025-07-08T14:38:15.680"}]
["Grupo Financiero Santander."]
[]
[]
[null,null,"EMPLEADO",null,null,null,null,"CLIENTE EXTERNO",null,null,null,"FAVOR DE MARCAR CON EL CURSOR LA OPCION CORRESPONDIENTE."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=3,requisitos!R14,'CALCULO Empleados'!M21)","v":false},null,{"$f":"+IF(O13<18000,O13,18000)","v":18000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!I14=3,requisitos!R14,IF(requisitos!I14=4,requisitos!R15,IF(requisitos!I14=5,requisitos!R16,IF(requisitos!I14=9,requisitos!R20,IF(requisitos!I14=10,requisitos!R21,IF(requisitos!I14=11,requisitos!O22,requisitos!R12))))))","v":1913}]
[{"$f":"IF(requisitos!$T$3=2,\"FUNCIONARIO QUE ATIENDE AL CLIENTE\",\"DATOS DEL EMPLEADO\")","v":"FUNCIONARIO QUE ATIENDE AL CLIENTE"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q15<1412.88,\"$1,413.00\",Q15)","v":1913},null,null,{"$f":"+IF(requisitos!T3=1,'Hipoteca Free'!Q13,'Hipoteca Free'!Q14)","v":1913}]
[]
["NOMBRE",null,null,null,null,null,null,"PUESTO",null,null,null,null,null,null,null,"TEL."]
[]
[]
[{"$f":"+IF(requisitos!I14=3,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=4,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=6,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=7,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=9,\"V A L O R   P R O Y E C T O\",IF(requisitos!I14=10,\"V A L O R   P R O Y E C T O\",\"P R E C I O   D E    C O M P R A V E N T A\"))))))","v":"P R E C I O   D E    C O M P R A V E N T A"},null,null,null,null,null,null,null,null,null,{"$f":"+IF(H20=\"\",\"FALTA CAPTURAR COMPRAVENTA/VALOR ESTIMADO\",\"\")","v":"FALTA CAPTURAR COMPRAVENTA/VALOR ESTIMADO"},null,null,null,{"$f":"+IF(requisitos!I14=3,\"HONORARIOS\",IF(requisitos!I14=4,\"HONORARIOS\",\"MONTO DEL ANTICIPO\"))","v":"MONTO DEL ANTICIPO"},null,{"$f":"IF(H20=0,\"\",N15)","v":""}]
[{"$f":"+IF(requisitos!I14=9,\"PONER SUMA DEL VALOR TERRENO Y TOTAL DEL PRESUPUESTO\",IF(requisitos!I14=10,\"PONER SUMA DEL VALOR TERRENO Y TOTAL DEL PRESUPUESTO\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"ABONAR A CUENTA 92-00061101-1"]
[{"$f":"+IF(requisitos!I14=3,\"PARA CREDITOS DE SUSTITUCIÓN  ES NECESARIO DEPOSITAR EL HONORARIO Y LOS VIATICOS TOTALES ANTES DE SOLICITAR EL AVALÚO.\",IF(requisitos!I14=4,\"PARA MEJORAS DE CONDICIONES ES NECESARIO DEPOSITAR LOS VIATICOS TOTALES JUNTO CON EL ANTICIPO ANTES DE SOLICITAR EL AVALÚO.\",\" \"))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,"Deposito Referenciado"]
[null,null,null,null,null,null,null,null,null,null,null,"Referencias:",null,"Folio CH.","Nombre del Solicitante de crédito"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+G52","v":0}]
[]
["TIPO DE CRÉDITO"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=9,\"PARA CREDITO DE CONSTRUCCION DEBE SEÑALAR LA OPCION TERRENO\",IF(requisitos!I14=10,\"PARA CREDITO DE CONSTRUCCIÓN Y ADQ. TERRENO DEBE SEÑALAR EN TIPO DE BIEN A VALUAR LA OPCION TERRENO.\",\"\"))","v":""}]
[]
[]
[]
["UBICACIÓN DEL INMUEBLE A VALUAR",null,null,null,null,null,null,null,null,null,null,null,"DOCUMENTACIÓN QUE SE DEBEN ANEXAR (2 COPIAS)"]
["TIPO DE BIEN A VALUAR",null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(requisitos!AF2:AF7,requisitos!AE2)),\"\",(INDEX(requisitos!AF2:AF7,requisitos!AE2)))","v":"CASA SOLA"},null,null,null,null,null,"-BOLETA PREDIAL Y AGUA"]
["CALLE",null,null,null,null,null,null,null,null,null,null,null,"-ESCRITURA ó TITULO DE PROPIEDAD"]
["NÚMERO EXT.",null,null,null,null,null,null,null,"INTERIOR.",null,null,null,"-PLANOS ARQUITECTÓNICOS",null,null,{"$f":"+IF(requisitos!I14=9,requisitos!H27,IF(requisitos!I14=10,requisitos!H27,\"\"))","v":""}]
["COLONIA",null,null,null,null,null,null,null,null,null,null,null,"-COMPROBANTE PAGO ANTICIPO"]
["ENTIDAD FEDERATIVA (ESTADO)"]
["DELEG. O MUNICIPIO",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=9,requisitos!H28,IF(requisitos!I14=10,requisitos!H28,\"\"))","v":""}]
["CIUDAD",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!AE2=2,requisitos!G27,IF(requisitos!AE2=3,requisitos!G27,\"\"))","v":""}]
["CÓDIGO POSTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!AE2=2,requisitos!G28,IF(requisitos!AE2=3,requisitos!G28,\"\"))","v":""}]
["ENTRE CALLE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!AE2=2,\"VIVIENDA NUEVA EN CONDOMINIO SE RECOMIENDA ANEXAR CONTRATO DE COMPRAVENTA.\",IF(requisitos!AE2=3,\"VIVIENDA NUEVA EN CONDOMINIO SE RECOMIENDA ANEXAR CONTRATO DE COMPRAVENTA.\",\"\"))","v":""}]
["Y CALLE"]
[]
[]
[]
["PERSONA QUE MOSTRARA EL INMUEBLE A VALUAR"]
["NOMBRE",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO 1",null,"TELÉFONO 2"]
[]
[]
[]
[]
["DATOS DEL SOLICITANTE DEL CRÉDITO",null,null,null,null,null,null,null,null,"DATOS DEL PROPIETARIO Y DEL INMUEBLE A VALUAR"]
["NOMBRE",null,null,null,null,null,null,null,null,"NOMBRE"]
[{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"NUMERO DE SEGURIDAD SOCIAL (NSS)\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"NUMERO DE SEGURIDAD SOCIAL (NSS)\",\"\")","v":""}]
[{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"R.F.C\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"R.F.C\",\"\")","v":""}]
[{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"CURP\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"CURP\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!AE2=1,1,\"\")","v":1},{"$f":"+IF(requisitos!AF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ED2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ER2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ES2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ET2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ID2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!II2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!AE2=1,1,\"\")","v":1}]
["DOMICILIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S56=\"\",1,2)","v":1},{"$f":"+IF(T56=\"\",1,2)","v":1},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(AJ56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(AZ56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(BP56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(CF56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(CV56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(DL56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(EB56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(ER56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(FH56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(FX56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(GN56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(HD56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(HT56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(IJ56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,{"$f":"+IF(T56=\"\",1,2)","v":1}]
["CALLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S57=\"\",1,2)","v":1},1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(T57=\"\",1,2)","v":1}]
["NÚMERO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S58=\"\",1,2)","v":1},1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(T58=\"\",1,2)","v":1}]
["COLONIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(U55:U58)","v":4},{"$f":"+SUM(V55:V58)","v":3},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"+SUM(CH55:CH58)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"+SUM(ET55:ET58)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"+SUM(HF55:HF58)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},4]
["CIUDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!AE2=2,1,IF(requisitos!AE2=3,1,\"\"))","v":""}]
["DELEG. O MUNICIPIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S61=\"\",1,2)","v":1}]
["ENTIDAD FEDERATIVA (ESTADO)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S62=\"\",1,2)","v":1}]
["CÓDIGO POSTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S63=\"\",1,2)","v":1}]
["TELEFONOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(U60:IV63)","v":3}]
["CORREO ELECTRÓNICO"]
[null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!C28=1,\"INDICAR REGIMEN DE PROPIEDAD\",\"\")","v":""}]
[]
["DATOS DE LA UNIDAD DE VALUACIÓN ASIGNADA"]
["NOMBRE (Razón Social).",null,null,null,null,null,null,null,null,null,null,null,null,"CIUDAD."]
[]
["ENTIDAD",null,null,null,null,null,"TELÉFONOS",null,null,null,null,null,null,"EMAIL."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["COMENTARIOS ADICIONALES:"]
["NOTAS: "]
["1.-","PARA ATENDER LA PRESENTE SOLICITUD, ES NECESARIO PROPORCIONAR LOS DATOS ANTES REQUERIDOS, EL NOMBRE Y FIRMA DEL SOLICITANTE."]
[null,"LA FALTA DE INFORMACIÓN Y/O FIRMA DEL SOLICITANTE SERÁN CAUSA DE SUSPENSIÓN DE SU ATENCIÓN."]
["2.-","EN CASO DE GENERARSE GASTOS POR CONCEPTOS DE VIÁTICOS Y TRASLADOS, ESTOS SERÁN CON CARGO AL SOLICITANTE."]
[]
[null,{"$f":"+IF(A15=\"DATOS DEL EMPLEADO\",\"\",\"USUARIO / BANCO\")","v":"USUARIO / BANCO"},null,null,null,null,null,"FIRMA SOLICITANTE DEL AVALÚO."]
[null,null,null,null,null,null,null,"EN CASO DE QUE EL MONTO DEL ANTICIPO A QUE SE REFIERE LA PRESENTE SOLICITUD NO SEA SUFICIENTE PARA CUBRIR EL TOTAL DEL PAGO DE LOS HONORARIOS POR LA ELABORACIÓN DEL AVALÚO Y DE QUE EN LA CUENTA DE CHEQUES QUE TENGO ABIERTA EN BANCO SANTANDER SOCIEDAD ANÓNIMA, CUENTE CON LOS FONDOS SUFICIENTES PARA CUBRIR LA DIFERENCIA EXISTENTE, EN ESTE ACTO AUTORIZO A BANCO SANTANDER SOCIEDAD ANÓNIMA PARA CARGAR EN MI CUENTA DE CHEQUES LA DIFERENCIA QUE EXISTA ENTRE EL MONTO DEL ANTICIPO Y LOS HONORARIOS DEL AVALÚO."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=5,'Hipoteca Free'!B120,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+E17","v":0},null,null,null,null,null,null,{"$f":"+G52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIES-046 (052025)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EN ESTE ACTO AUTORIZO A BANCO SANTANDER (MEXICO),SOCIEDAD ANONIMA, INSTITUCION DE BANCA MULTIPLE/SANTANDER HIPOTECARIO, S.A. DE C.V. SOFOM ER. A QUE A TRAVES DE LA EMPRESA QUE DESIGNE SE LLEVE A CABO EL PAGO PARA LA GENERACIÓN DE LA CLAVE UNICA DE VIVIENDA (CUV) NECESARIA PARA MI CREDITO."]

{"sheet":"anticipos","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,3,1,3],[0,4,1,4]]}
[null,"TIPO",null,"RANGO DE VALOR VIVIENDA","PROPUESTA COBRO MERCADO ABIERTO"]
[]
[1,"HIPOTECA FREE",1]
[null,"HIPOTECA INTEGRAL",null,"menos de 500,000",2000]
[null,"OTROS",null,"de 500,001 a 1,000,000",3000]
[null,null,null,"de 1,000,001 a 1,500,000",4500]
[null,null,null,"de 1,500,001 a 2,000,000",6000]
[null,null,null,"de 2,000,001 a 2,500,000",7000]
[null,null,null,"de 2,500,001 a 3,000,000",9000]
[null,null,null,"de 3,000,001 a 3,500,000",10000]
[null,null,null,"de 3,500,001 a 4,000,000",11000]
[null,null,null,"de 4,000,001 a 4,500,000",13500]
[null,null,null,"de 4,500,001 a 5,500,000",14000]
[null,null,null,"de 5,500,001 a 6,000,000",17000]
[null,null,null,"de 6,000,001 a 6,500,000",19000]
[null,null,null,"de 6,500,001 a 8,000,000",20000]
[null,null,null,"de 8,000,001 a 10,000,000",22000]
[null,null,null,"mas de 10,000,000",24000]

{"sheet":"RESTO DE PRODUCTOS","index":2,"n_rows":120,"n_cols":256,"rows_kept":120,"cut":false,"hidden":false,"merged":[[104,7,104,19],[105,0,105,5],[105,7,105,19],[89,1,89,19],[91,7,91,19],[92,7,96,19],[97,7,99,19],[100,7,101,19],[102,7,103,19],[70,14,70,17],[39,12,40,19],[45,5,45,9],[58,14,59,16],[52,13,52,14],[51,12,51,14],[53,12,53,14],[54,12,54,14],[67,16,67,18],[68,5,68,11],[68,14,68,17],[69,16,69,18],[70,4,70,5],[70,7,70,11],[31,0,31,10],[25,11,25,12],[25,14,25,19],[26,14,26,19],[24,13,24,16],[19,7,19,9],[20,0,20,9],[21,0,23,10],[22,11,22,12],[16,4,16,6],[16,9,16,14],[19,13,19,18],[19,10,19,12],[16,16,16,19],[2,9,2,19],[3,16,3,19],[4,16,4,19],[5,16,5,19],[14,13,14,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=9,\"SOLICITUD DE AVALUO Y ESTUDIO DE COSTOS\",IF(requisitos!I14=10,\"SOLICITUD DE AVALUO Y ESTUDIO DE COSTOS\",\"SOLICITUD AVALUO\"))","v":"SOLICITUD AVALUO"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIPOTECARIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE EXPEDICIÓN"]
["BANCO SANTANDER MEXICO,SOCIEDAD ANONIMA, INSTITUCION DE BANCA MULTIPLE.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"NOW()","v":"2025-07-08T14:38:15.680"}]
["Grupo Financiero Santander."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"FAVOR DE MARCAR CON EL CURSOR LA OPCION CORRESPONDIENTE."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=3,requisitos!R14,'CALCULO Empleados'!M21)","v":false},null,{"$f":"+IF(O13<18000,O13,18000)","v":18000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!I14=3,requisitos!R14,IF(requisitos!I14=4,requisitos!R15,IF(requisitos!I14=5,requisitos!R16,IF(requisitos!I14=9,requisitos!R20,IF(requisitos!I14=10,requisitos!R21,IF(requisitos!I14=11,requisitos!O22,requisitos!R12))))))","v":1913}]
[{"$f":"IF(requisitos!$T$3=2,\"FUNCIONARIO QUE ATIENDE AL CLIENTE\",\"DATOS DEL EMPLEADO\")","v":"FUNCIONARIO QUE ATIENDE AL CLIENTE"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q15<1412.88,\"$1,413.00\",Q15)","v":1913},null,null,{"$f":"+IF(requisitos!T3=1,'RESTO DE PRODUCTOS'!Q13,'RESTO DE PRODUCTOS'!Q14)","v":1913}]
[]
["NOMBRE",null,null,null,null,null,null,"PUESTO",null,null,null,null,null,null,null,"TEL."]
[]
[]
[{"$f":"+IF(requisitos!I14=3,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=4,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=6,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=7,\"VALOR ESTIMADO DEL INMUEBLE\",IF(requisitos!I14=9,\"V A L O R   P R O Y E C T O\",IF(requisitos!I14=10,\"V A L O R   P R O Y E C T O\",\"P R E C I O   D E    C O M P R A V E N T A\"))))))","v":"P R E C I O   D E    C O M P R A V E N T A"},null,null,null,null,null,null,null,null,null,{"$f":"+IF(H20=\"\",\"FALTA CAPTURAR COMPRAVENTA/VALOR ESTIMADO\",\"\")","v":"FALTA CAPTURAR COMPRAVENTA/VALOR ESTIMADO"},null,null,"CALCULA EL HONORARIO:",null,null,null,null,null,{"$f":"IF(anticipos!C3=1,anticipos!E3,IF(anticipos!C3=2,anticipos!E4,IF(anticipos!C3=3,anticipos!E5,IF(anticipos!C3=4,anticipos!E6,IF(anticipos!C3=5,anticipos!E7,IF(anticipos!C3=6,anticipos!E8,IF(anticipos!C3=7,anticipos!E9,IF(anticipos!C3=8,anticipos!E10,IF(anticipos!C3=9,anticipos!E11,IF(anticipos!C3=10,anticipos!E12,IF(anticipos!C3=11,anticipos!E13,IF(anticipos!C3=12,anticipos!E14,IF(anticipos!C3=13,anticipos!E15,IF(anticipos!C3=14,anticipos!E16,IF(anticipos!C3=15,anticipos!E17,IF(anticipos!C3=16,anticipos!E18))))))))))))))))","v":0}]
[{"$f":"+IF(requisitos!I14=9,\"PONER LA SUMA DEL VALOR TERRENO +  TOTAL DEL PRESUPUESTO\",IF(requisitos!I14=10,\"PONER LA SUMA DEL VALOR TERRENO + TOTAL DEL PRESUPUESTO\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"EL VALOR DEL INMUEBLE ESTA ENTRE:"]
[{"$f":"+IF(requisitos!I14=3,\"PARA CREDITOS DE SUSTITUCIÓN  ES NECESARIO DEPOSITAR EL HONORARIO Y LOS VIATICOS TOTALES ANTES DE SOLICITAR EL AVALÚO.\",IF(requisitos!I14=4,\"PARA MEJORAS DE CONDICIONES ES NECESARIO DEPOSITAR LOS VIATICOS TOTALES JUNTO CON EL ANTICIPO ANTES DE SOLICITAR EL AVALÚO.\",\" \"))","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!$I$14=3,\"HONORARIOS\",IF(requisitos!$I$14=4,\"HONORARIOS\",\"MONTO DEL ANTICIPO\"))","v":"MONTO DEL ANTICIPO"},null,{"$f":"IF(requisitos!$I$14=3,\"$3,000.00\",IF(requisitos!$I$14=4,\"$3,000.00\",'RESTO DE PRODUCTOS'!$T$20))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ABONAR A CUENTA 92-00061101-1"]
["TIPO DE CRÉDITO",null,null,null,null,null,null,null,null,null,null,null,null,"Deposito Referenciado"]
[null,null,null,null,null,null,null,null,null,null,null,"Referencias:",null,"Folio CH.","Nombre del Solicitante de crédito"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$G$52","v":0}]
[]
[]
["UBICACIÓN DEL INMUEBLE A VALUAR",null,null,null,null,null,null,null,null,null,null,null,"DOCUMENTACIÓN QUE SE DEBEN ANEXAR (2 COPIAS)"]
["TIPO DE BIEN A VALUAR",null,null,null,null,null,{"$f":"IF(ISERROR(INDEX(requisitos!AF2:AF7,requisitos!AE2)),\"\",(INDEX(requisitos!AF2:AF7,requisitos!AE2)))","v":"CASA SOLA"},null,null,null,null,null,"-BOLETA PREDIAL Y AGUA"]
[{"$f":"+IF(requisitos!$I$14=9,\"PARA CREDITO DE CONSTRUCCION DEBE SEÑALAR LA OPCION TERRENO\",IF(requisitos!$I$14=10,\"PARA CREDITO DE CONSTRUCCIÓN Y ADQ. TERRENO DEBE SEÑALAR EN TIPO DE BIEN A VALUAR LA OPCION TERRENO.\",\"\"))","v":""}]
["CALLE",null,null,null,null,null,null,null,null,null,null,null,"-ESCRITURA ó TITULO DE PROPIEDAD"]
["NÚMERO EXT.",null,null,null,null,null,null,null,"INTERIOR.",null,null,null,"-PLANOS ARQUITECTÓNICOS",null,null,{"$f":"+IF(requisitos!I14=9,requisitos!H27,IF(requisitos!I14=10,requisitos!H27,\"\"))","v":""}]
["COLONIA",null,null,null,null,null,null,null,null,null,null,null,"-COMPROBANTE PAGO ANTICIPO"]
["ENTIDAD FEDERATIVA (ESTADO)"]
["DELEG. O MUNICIPIO",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=9,requisitos!H28,IF(requisitos!I14=10,requisitos!H28,\"\"))","v":""}]
["CIUDAD",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!AE2=2,requisitos!G27,IF(requisitos!AE2=3,requisitos!G27,\"\"))","v":""}]
["CÓDIGO POSTAL",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!AE2=2,requisitos!G28,IF(requisitos!AE2=3,requisitos!G28,\"\"))","v":""}]
["ENTRE CALLE",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!AE2=2,\"VIVIENDA NUEVA EN CONDOMINIO SE RECOMIENDA ANEXAR CONTRATO DE COMPRAVENTA.\",IF(requisitos!AE2=3,\"VIVIENDA NUEVA EN CONDOMINIO SE RECOMIENDA ANEXAR CONTRATO DE COMPRAVENTA.\",\"\"))","v":""}]
["Y CALLE"]
[]
[]
[]
["PERSONA QUE MOSTRARA EL INMUEBLE A VALUAR"]
["NOMBRE",null,null,null,null,null,null,null,null,null,null,null,"TELÉFONO 1",null,"TELÉFONO 2"]
[]
[]
[]
[]
["DATOS DEL SOLICITANTE DEL CRÉDITO",null,null,null,null,null,null,null,null,"DATOS DEL PROPIETARIO Y DEL INMUEBLE A VALUAR"]
["NOMBRE",null,null,null,null,null,null,null,null,"NOMBRE"]
[{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"NUMERO DE SEGURIDAD SOCIAL (NSS)\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"NUMERO DE SEGURIDAD SOCIAL (NSS)\",\"\")","v":""}]
[{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"R.F.C\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"R.F.C\",\"\")","v":""}]
[{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"CURP\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(OR(requisitos!$I$14=8,requisitos!$I$14=2),\"CURP\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!AE2=1,1,\"\")","v":1},{"$f":"+IF(requisitos!AF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!AZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!BZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!CZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!DZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ED2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ER2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ES2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ET2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!EZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!FZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!GZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HD2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HI2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HW2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HX2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HY2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!HZ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IA2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IB2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IC2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!ID2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IE2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IF2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IG2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IH2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!II2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IJ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IK2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IL2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IM2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IN2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IO2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IP2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IQ2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IR2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IS2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IT2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IU2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!IV2=1,1,\"\")","v":""},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!#REF!=1,1,\"\")","v":{"$error":"#REF!"}},{"$f":"+IF(requisitos!AE2=1,1,\"\")","v":1}]
["DOMICILIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S56=\"\",1,2)","v":1},{"$f":"+IF(T56=\"\",1,2)","v":1},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(AJ56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(AZ56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(BP56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(CF56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(CV56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(DL56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(EB56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(ER56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(FH56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(FX56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(GN56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(HD56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(HT56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(IJ56=\"\",1,2)","v":2},2,2,2,2,2,2,2,2,2,{"$f":"+IF(T56=\"\",1,2)","v":1}]
["CALLE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S57=\"\",1,2)","v":1},1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(T57=\"\",1,2)","v":1}]
["NÚMERO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S58=\"\",1,2)","v":1},1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,{"$f":"+IF(T58=\"\",1,2)","v":1}]
["COLONIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(U55:U58)","v":4},{"$f":"+SUM(V55:V58)","v":3},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"+SUM(CH55:CH58)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"+SUM(ET55:ET58)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$f":"+SUM(HF55:HF58)","v":6},6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},4]
["CIUDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(requisitos!AE2=2,1,IF(requisitos!AE2=3,1,\"\"))","v":""}]
["DELEG. O MUNICIPIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S61=\"\",1,2)","v":1}]
["ENTIDAD FEDERATIVA (ESTADO)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S62=\"\",1,2)","v":1}]
["CÓDIGO POSTAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S63=\"\",1,2)","v":1}]
["TELEFONOS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(U60:IV63)","v":3}]
["CORREO ELECTRÓNICO"]
[null,null,null,null,null,null,null,null,{"$f":"IF(requisitos!C28=1,\"INDICAR REGIMEN DE PROPIEDAD\",\"\")","v":""}]
[]
["DATOS DE LA UNIDAD DE VALUACIÓN ASIGNADA"]
["NOMBRE (Razón Social).",null,null,null,null,null,null,null,null,null,null,null,null,"CIUDAD."]
[]
["ENTIDAD",null,null,null,null,null,"TELÉFONOS",null,null,null,null,null,null,"EMAIL."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["COMENTARIOS ADICIONALES:"]
["NOTAS: "]
["1.-","PARA ATENDER LA PRESENTE SOLICITUD, ES NECESARIO PROPORCIONAR LOS DATOS ANTES REQUERIDOS, EL NOMBRE Y FIRMA DEL SOLICITANTE."]
[null,"LA FALTA DE INFORMACIÓN Y/O FIRMA DEL SOLICITANTE SERÁN CAUSA DE SUSPENSIÓN DE SU ATENCIÓN."]
["2.-","EN CASO DE GENERARSE GASTOS POR CONCEPTOS DE VIÁTICOS Y TRASLADOS, ESTOS SERÁN CON CARGO AL SOLICITANTE."]
[]
[null,{"$f":"+IF(A15=\"DATOS DEL EMPLEADO\",\"\",\"USUARIO / BANCO\")","v":"USUARIO / BANCO"},null,null,null,null,null,"FIRMA SOLICITANTE DEL AVALÚO."]
[null,null,null,null,null,null,null,"EN CASO DE QUE EL MONTO DEL ANTICIPO A QUE SE REFIERE LA PRESENTE SOLICITUD NO SEA SUFICIENTE PARA CUBRIR EL TOTAL DEL PAGO DE LOS HONORARIOS POR LA ELABORACIÓN DEL AVALÚO Y DE QUE EN LA CUENTA DE CHEQUES QUE TENGO ABIERTA EN BANCO SANTANDER SOCIEDAD ANÓNIMA, CUENTE CON LOS FONDOS SUFICIENTES PARA CUBRIR LA DIFERENCIA EXISTENTE, EN ESTE ACTO AUTORIZO A BANCO SANTANDER SOCIEDAD ANÓNIMA PARA CARGAR EN MI CUENTA DE CHEQUES LA DIFERENCIA QUE EXISTA ENTRE EL MONTO DEL ANTICIPO Y LOS HONORARIOS DEL AVALÚO."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"+IF(requisitos!I14=5,'RESTO DE PRODUCTOS'!B120,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+E17","v":0},null,null,null,null,null,null,{"$f":"+G52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIES-046 (052025)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EN ESTE ACTO AUTORIZO A BANCO SANTANDER (MEXICO),SOCIEDAD ANONIMA, INSTITUCION DE BANCA MULTIPLE/SANTANDER HIPOTECARIO, S.A. DE C.V. SOFOM ER. A QUE A TRAVES DE LA EMPRESA QUE DESIGNE SE LLEVE A CABO EL PAGO PARA LA GENERACIÓN DE LA CLAVE UNICA DE VIVIENDA (CUV) NECESARIA PARA MI CREDITO."]

{"sheet":"requisitos","index":3,"n_rows":75,"n_cols":32,"rows_kept":75,"cut":false,"hidden":true,"merged":[[9,18,9,23]]}
[]
[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,null,null,null,null,null,1,"CASA SOLA"]
[null,null,"tipo",null,null,"requisitos",null,null,"OTROS",null,null,null,null,null,"PROCEDE O NO",null,null,null,null,2,{"$f":"VLOOKUP(T3,T4:U5,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"+T3+I14","v":3},null,null,null,null,"CASA EN CONDOMINIO"]
[null,1,"INMOBILIARIO",null,null,"CONOCER EL VALOR Y/O RENTA",null,null,"FOTOGRAFÍAS",null,null,null,null,null,{"$f":"IF('Hipoteca Free'!#REF!=FALSE,\"\",1)","v":{"$error":"#REF!"}},null,null,null,null,3,"EN EL ESTADO EN QUE SE ENCUENTRA",null,null,null,null,null,null,null,null,null,null,"DEPARTAMENTO"]
[null,"1+4","MAQUINARIA Y EQUIPO",null,null,"AUXILIAR COMPRA O VENTA",null,null,"CROQUIS DE LOCALIZACION",null,null,null,null,null,{"$f":"IF('Hipoteca Free'!#REF!=FALSE,\"\",1)","v":{"$error":"#REF!"}},null,null,null,null,4,"COMPLETAMENTE TERMINADO",null,null,null,null,null,null,null,null,null,null,"TERRENO"]
[null,4,"AGROPECUARIO",null,null,"DETERMINAR BASE GRAVABLE",null,null,"AVALÚO DE OTRO BANCO",null,null,null,null,null,{"$f":"IF('Hipoteca Free'!#REF!=FALSE,\"\",1)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(I13=8,\"\",IF(I13=9,\"\",\"OTRO\"))","v":"OTRO"}]
[null,2,"OBRAS DE ARTE",null,null,"DAR EN GARANTIA",null,null,"NINGUNO",null,null,null,null,null,{"$f":"SUM(O4:O6)","v":{"$error":"#REF!"}},null,null,null,{"$f":"'Hipoteca Free'!$H$20","v":0},null,null,null,{"$f":"IF(AND($S$7>16000000),$X$31,IF(AND($S$7<=16000000,$S$7>8000000),$X$30,IF(AND($S$7<=8000000,$S$7>4000000),$X$29,IF(AND($S$7<=4000000,$S$7>2000000),$X$28,IF(AND($S$7<=2000000,$S$7>1000000),$X$27,IF(AND($S$7<=1000000,$S$7>500000),$X$25,IF(AND($S$7<=500000,$S$7>320000),$X$24,920)))))))","v":920},{"$f":"IF(AND($S$7>16000000),$W$31,IF(AND($S$7<=16000000,$S$7>8000000),$W$30,IF(AND($S$7<=8000000,$S$7>4000000),$W$29,IF(AND($S$7<=4000000,$S$7>2000000),$W$28,IF(AND($S$7<=2000000,$S$7>1000000),$W$27,IF(AND($S$7<=1000000,$S$7>500000),$W$25,IF(AND($S$7<=500000,$S$7>=320000),$W$24,920)))))))","v":920}]
[null,null,"VEHICULOS TERRESTRES",null,null,"RECIBIR O DAR EN PAGO",null,null,4,null,null,null,"PLANOS"]
[null,null,"VEHICULOS AÉREOS",null,null,"ANALIZAR UN PROYECTO",null,null,1,null,null,null,"NO","SI"]
[null,null,"VEHICULOS MARÍTIMOS",null,null,"CRÉDITO HIPOTECARIO",null,null,null,null,null,null,"SI","NO",0,null,null,null,"TABLA DE CALCULO PARA EMPLEADOS (NO BORRAR)"]
[null,null,"OTROS",null,null,"OTRO",null,null,null,null,null,null,null,null,{"$f":"2.75/1000","v":2.7499999999999998E-3}]
[null,null,{"$f":"I14","v":1},null,null,9,null,null,null,null,null,null,"ADQUISICIÓN // LIQUIDEZ",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},{"$f":"+IF($I$9=1,\"500\",0)","v":"500"},{"$f":"+P12+O12","v":500},{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P12,IF(Q12<=18000,Q12,18000))","v":1913}]
[null,null,null,null,null,null,null,null,null,null,null,null,"ADQUISICIÓN CON APOYO INFONAVIT",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},"500",500,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P13,IF(Q13<=18000,Q13,18000))","v":1913}]
[null,null,1,1,"CONDOMINIO",null,null,null,1,null,null,null,"SUSTITUCIÓN DE HIPOTECA",null,2320,"500",2820,{"$f":"+Q14","v":2820},{"$f":"+IF(T3=1,'CALCULO Empleados'!M21,requisitos!R14)","v":2820}]
[null,null,null,2,"PRIVADO",null,null,null,null,null,null,null,"MEJORA DE CONDICIONES",null,3000,"500",3500,{"$f":"+Q15","v":3500},{"$f":"VALUE('Hipoteca Free'!$H$20)","v":0}]
[null,"REQUISITOS",null,null,null,null,null,null,null,null,null,null,"HIPOTECA INTEGRAL",null,{"$f":"('Hipoteca Free'!$H$20*requisitos!$O$11)+O10","v":0},"500",500,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P16+O10,IF(Q16<=18000,Q16,18000))","v":1913},"Valor",{"$f":"'Hipoteca Free'!#REF!","v":{"$error":"#REF!"}}]
[null,"salida",1,2,3,4,5,6,7,8,9,10,"REMODELACIÓN, AMPLIACIÓN O MEJORAS",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},"500",500,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P17,IF(Q17<=18000,Q17,18000))","v":1913},null,"AVALÚOS DE INMUEBLES",null,null,null,null,null,null,null,"AVALÚOS AGROPECUARIOS"]
[null,{"$f":"INDEX(C18:L18,$C$12)","v":"-BOLETA PREDIAL Y AGUA"},"-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","-BOLETA PREDIAL Y AGUA","TERMINACION DE OBRA",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},"500",500,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P18,IF(Q18<=18000,Q18,18000))","v":1913},null,"Base:","Sobre el valor real del bien valuado.",null,null,null,null,null,null,"Base:","Sobre el valor real del bien valuado."]
[null,{"$f":"INDEX(C19:L19,$C$12)","v":"-ESCRITURA ó TITULO DE PROPIEDAD"},"-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","-ESCRITURA ó TITULO DE PROPIEDAD","ADQUISICION COFINAVIT",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},"500",500,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P19,IF(Q19<=18000,Q19,18000))","v":1913},null,"Cuota mínima:",800,"más I.V.A.",2.5000000000000001E-3,null,null,null,null,"Cuota mínima:",1000,"más I.V.A.",3.5000000000000001E-3]
[null,{"$f":"INDEX(C20:L20,$C$12)","v":"-PLANOS ARQUITECTÓNICOS"},"-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","-PLANOS ARQUITECTÓNICOS","CREDITO DE CONSTRUCCION",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},null,0,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P20,IF(Q20<=18000,Q20,18000))","v":1413},"Rango","Límite ",null,"Cuota","Tasa",null,null,null,"Rango","Límite ",null,"Cuota","Tasa"]
[null,"-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","-COMPROBANTE PAGO ANTICIPO","CRED. CONSTR. Y ADQ. TERRENO",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},null,0,{"$f":"+IF('Hipoteca Free'!$H$20<=420000,1413+requisitos!P21,IF(Q21<=18000,Q21,18000))","v":1413},"de valor","Inferior","Superior","fija","marginal *",null,null,null,"de valor","Superior","Inferior","fija","marginal *"]
[null,"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN",{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},"-PRESUPUESTO DESGLOSADO Y PROGRAMA DE OBRA","-PRESUPUESTO DESGLOSADO Y PROGRAMA DE OBRA",{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},"ADQ. TERRENO",null,{"$f":"+'Hipoteca Free'!$H$20*requisitos!$O$11","v":0},null,{"$f":"+P22+O22","v":0},{"$f":"+Q22","v":0},null,null,null,null,null,"NO BORRAR"]
[null,"Nota: En la escritura deberán señalarse superficies, medidas",{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},"-LICENCIA DE CONSTRUCCIÓN","-LICENCIA DE CONSTRUCCIÓN",{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},{"$f":"IF($C$14=1,\"Nota: En la escritura deberán señalarse superficies, medidas\",\"\")","v":"Nota: En la escritura deberán señalarse superficies, medidas"},null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!)*W23)+V23","v":{"$error":"#REF!"}},null,null,1,320000,800,0,{"$f":"((($S$7-T23)*W23)+V23)*1.15","v":919.99999999999989},null,{"$f":"(('Hipoteca Free'!#REF!)*AE23)+AD23","v":{"$error":"#REF!"}},null,1,286000,1000,0]
[null,"y colindancias del terreno, de areas privativas e indiviso.",{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN\",\"\")","v":"-REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN"},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},{"$f":"IF($C$14=1,\"y colindancias del terreno, de areas privativas e indiviso.\",\"\")","v":"y colindancias del terreno, de areas privativas e indiviso."},null,null,null,null,{"$f":"T16*W24","v":{"$error":"#REF!"}},null,"A",320001,500000,800,2.5000000000000001E-3,{"$f":"((($S$7-T24)*W24)+V24)*1.15","v":-2.8750000000627549E-3},null,{"$f":"T16*AE24","v":{"$error":"#REF!"}},"A",286001,500000,0,3.5000000000000001E-3]
[null,0,null,null,null,null,{"$f":"IF($C$14=1,\"  (Señalando superficies, medidas, colindancias e indiviso)\",\"\")","v":"  (Señalando superficies, medidas, colindancias e indiviso)"},{"$f":"IF($C$14=1,\"  (Señalando superficies, medidas, colindancias e indiviso)\",\"\")","v":"  (Señalando superficies, medidas, colindancias e indiviso)"},null,null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T25)*W25)+V25","v":{"$error":"#REF!"}},null,"B",500001,1000000,1250,2.3800000000000002E-3,68.997262999999847,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB25)*AE25)+AD25","v":{"$error":"#REF!"}},"B",500001,1000000,1750,3.0999999999999999E-3]
[null,0]
[null,"TARIFA",null,null,null,null,"REGIMEN DE CONDOMINIO o PROYECTO DE REGIMEN","(incluyendo cortes y fachadas)","ESTADO DE CUENTA DEL VENDEDOR","ULTIMO TALON DE PAGO DEL (LOS) ACREDITADO (S)",null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T27)*W27)+V27","v":{"$error":"#REF!"}},null,"C",1000001,2000000,2440,2.1800000000000001E-3,298.99749300000002,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB27)*AE27)+AD27","v":{"$error":"#REF!"}},"C",1000001,2000000,3300,2.8999999999999998E-3]
["CRED. HIP.","salida",null,null,null,null,"(Señalando superficies, medidas, colindancias e indiviso)","PRESUPUESTO DESGLOSADO POR PARTIDA Y CALENDARIO DE OBRA","CLAVE UNICA DE VIVIENDA (en caso de vivienda nueva)",null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T28)*W28)+V28","v":{"$error":"#REF!"}},null,"D",2000001,4000000,4620,1.89E-3,965.99782649999997,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB28)*AE28)+AD28","v":{"$error":"#REF!"}},"D",2000001,4000000,6200,2.2000000000000001E-3]
[{"$f":"(A40/$T$16)*1000","v":{"$error":"#REF!"}},{"$f":"INDEX(C29:M29,$C$12)","v":{"$error":"#REF!"}},{"$f":"(C40/$T$16)*1000","v":{"$error":"#REF!"}},{"$f":"(D40/$T$16)*1000","v":{"$error":"#REF!"}},{"$f":"(E40/$T$16)*1000","v":{"$error":"#REF!"}},0.01,500,2000,2000,null,null,null,"DEPENDIENDO DEL",null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T29)*W29)+V29","v":{"$error":"#REF!"}},null,"E",4000001,8000000,8400,1.58E-3,2391.9981829999997,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB29)*AE29)+AD29","v":{"$error":"#REF!"}},"E",4000001,8000000,10600,1.3500000000000001E-3]
["AL MILLAR",{"$f":"INDEX(C30:M30,$C$12)","v":"al millar"},"al millar","al millar","al millar","del valor","por unidad","por unidad","por unidad",null,null,null,"OBJETO A VALUAR",null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T30)*W30)+V30","v":{"$error":"#REF!"}},null,"F",8000001,16000000,14720,1.2800000000000001E-3,5151.9985279999992,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB30)*AE30)+AD30","v":{"$error":"#REF!"}},"F",8000001,16000000,16000,1.1000000000000001E-3]
[null,{"$f":"INDEX(C31:M31,$C$12)","v":{"$error":"#REF!"}},{"$f":"IF('Hipoteca Free'!#REF!<=240000,2.5,requisitos!C29)","v":{"$error":"#REF!"}},{"$f":"IF('Hipoteca Free'!#REF!<=250000,5,requisitos!D29)","v":{"$error":"#REF!"}},{"$f":"IF('Hipoteca Free'!#REF!<=250000,3.5,requisitos!E29)","v":{"$error":"#REF!"}},{"$f":"F29","v":0.01},{"$f":"G29","v":500},{"$f":"H29","v":2000},{"$f":"I29","v":2000},null,null,null,{"$f":"M29","v":"DEPENDIENDO DEL"},null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T31)*W31)+V31","v":{"$error":"#REF!"}},null,"G",16000001,"en adelante",24960,1.0200000000000001E-3,{"$f":"((($S$7-T31)*W31)+V31)*1.15","v":9935.9988269999976},null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB31)*AE31)+AD31","v":{"$error":"#REF!"}},"G**",16000001,"en adelante",24800,1.0499999999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q32*0.6","v":480},null,{"$f":"IF(ISERROR(S32),U19,MAX(INDEX(Q23:Q31,S32),U19))","v":800},null,{"$f":"MATCH($T$16,T23:T31,1)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(ISERROR(S32),W19,MIN(INDEX(W23:W31,S32),W19))","v":2.5000000000000001E-3},null,null,{"$f":"IF(ISERROR(AA32),0,MAX(INDEX(Z23:Z31,AA32),AC19))","v":0},{"$f":"MATCH($T$16,AB23:AB31,1)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(ISERROR(AA32),AE19,MIN(INDEX(AE23:AE31,AA32),AE19))","v":3.5000000000000001E-3}]
[null,"DIAS HABILES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVALÚOS PARA CRÉDITO HIPOTECARIO (EXCEPTO DE LIQUIDEZ)",null,null,null,null,null,null,null,"AVALÚOS DE MAQUINARIA Y EQUIPO"]
[null,{"$f":"INDEX(C34:M34,$C$12)","v":"12 DIAS HABILES"},"12 DIAS HABILES","20 DIAS HABILES","15 DIAS HABILES","10 DIAS HABILES","10 DIAS HABILES","15 DIAS HABILES","15 DIAS HABILES",null,null,null,null,null,null,null,null,null,null,"Base:","Sobre el valor real del bien valuado.",null,null,null,null,null,null,"Base:","Sobre el valor real del bien valuado."]
[null,{"$f":"INDEX(C35:M35,$C$12)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuota mínima:",{"$f":"800*1.15","v":919.99999999999989},"no causa I.V.A.",2.8700000000000002E-3,null,null,null,null,"Cuota mínima:",800,"más I.V.A.",5.0000000000000001E-3]
[null,"pago minimo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rango","Límite ",null,"Cuota","Tasa",null,null,null,"Rango","Límite ",null,"Cuota","Tasa"]
[null,{"$f":"INDEX(C37:M37,$C$12)","v":""},{"$f":"IF(C40<=300,\"pago minimo\",\"\")","v":""},{"$f":"IF(D40<=500,\"pago minimo\",\"\")","v":"pago minimo"},{"$f":"IF(E40<=500,\"pago minimo\",\"\")","v":"pago minimo"},null,{"$f":"IF(G40<=500,\"pago minimo\",\"\")","v":"pago minimo"},null,null,null,null,null,null,null,null,null,null,null,"de valor","Superior","Inferior","fija","marginal *",null,null,null,"de valor","Superior","Inferior","fija","marginal *"]
[null,"ANTICIPO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!)*W38)+V38","v":{"$error":"#REF!"}},null,null,1,320000,920,0,null,null,{"$f":"(('Hipoteca Free'!#REF!)*AE38)+AD38","v":{"$error":"#REF!"}},null,1,160000,800,0]
["CRED. HIP.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T16*W39","v":{"$error":"#REF!"}},null,"A",320001,500000,0,2.8700000000000002E-3,null,null,{"$f":"T16*AE39","v":{"$error":"#REF!"}},"A",160001,500000,0,5.0000000000000001E-3]
[{"$f":"Q46","v":919.99999999999989},{"$f":"INDEX(C40:M40,$C$12)","v":800},{"$f":"Q32","v":800},{"$f":"Z46","v":0},{"$f":"Z32","v":0},{"$f":"'Hipoteca Free'!#REF!*requisitos!F29","v":{"$error":"#REF!"}},{"$f":"G29","v":500},{"$f":"H29","v":2000},{"$f":"I29","v":2000},null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T40)*W40)+V40","v":{"$error":"#REF!"}},null,"B",500001,1000000,1437,2.7399999999999998E-3,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB40)*AE40)+AD40","v":{"$error":"#REF!"}},"B",500001,1000000,2500,4.0000000000000001E-3]
[{"$f":"A40*$B$39","v":919.99999999999989},{"$f":"INDEX(C41:M41,$C$12)","v":800},{"$f":"C40*$B$39","v":800},0,0,{"$error":"#REF!"},500,2000,2000,null,null,null,0,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T41)*W41)+V41","v":{"$error":"#REF!"}},null,"C",1000001,2000000,2806,2.5100000000000001E-3,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB41)*AE41)+AD41","v":{"$error":"#REF!"}},"C",1000001,2000000,4500,3.5000000000000001E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T42)*W42)+V42","v":{"$error":"#REF!"}},null,"D",2000001,4000000,5313,2.1700000000000001E-3,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB42)*AE42)+AD42","v":{"$error":"#REF!"}},"D",2000001,4000000,8000,2E-3]
["comprobacion",{"$f":"IF(F12=7,A41,B41)","v":800},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T43)*W43)+V43","v":{"$error":"#REF!"}},null,"E",4000001,8000000,9660,1.82E-3,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB43)*AE43)+AD43","v":{"$error":"#REF!"}},"E",4000001,8000000,12000,1.6000000000000001E-3]
["verificado",{"$f":"IF(B43<=300,300,B43)","v":800},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!T44)*W44)+V44","v":{"$error":"#REF!"}},null,"F",8000001,16000000,16928,1.47E-3,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB44)*AE44)+AD44","v":{"$error":"#REF!"}},"F",8000001,16000000,18400,1.2999999999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NO LO ",null,"MONTO",{"$f":"(('Hipoteca Free'!#REF!-requisitos!T45)*W45)+V45","v":{"$error":"#REF!"}},null,"G**",16000001,"en adelante",28704,1.17E-3,null,null,{"$f":"(('Hipoteca Free'!#REF!-requisitos!AB45)*AE45)+AD45","v":{"$error":"#REF!"}},"G**",16000001,"en adelante",28800,1.1999999999999999E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"OCUPO",null,null,{"$f":"IF(ISERROR(S46),U35,MAX(INDEX(Q39:Q45,S46),U35))","v":919.99999999999989},null,{"$f":"MATCH($T$16,T39:T45,1)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(ISERROR(S46),W35,MIN(INDEX(W39:W45,S46),W35))","v":2.8700000000000002E-3},null,null,{"$f":"IF(ISERROR(AA46),0,MAX(INDEX(Z39:Z45,AA46),AC35))","v":0},{"$f":"MATCH($T$16,AB39:AB45,1)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(ISERROR(AA46),AE35,MIN(INDEX(AE39:AE45,AA46),AE35))","v":5.0000000000000001E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"¡ZAZ!",null,"TARIFA","APLICABLE",null,{"$f":"IF(T47=1,Q32,IF(T47=2,Z32,IF(T47=3,Q46,Z46)))","v":800},{"$f":"C12","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APLICABLE",null,{"$f":"IF(T47=1,W32,IF(T47=2,AE32,IF(T47=3,W46,AE46)))","v":2.5000000000000001E-3}]
[]
[]
[null,"tipo","tipo"]
[null,"RESIDENCIA TIPO ALTO","AUTOMOVIL"]
[null,"CASA SOLA TIPO MEDIO","AUTOBUS"]
[null,"DEPARTAMENTO","CAMION"]
[null,"CASA EN CONDOMINIO","TRAILER"]
[null,"VIVIENDA DE INTERES SOCIAL","TRAXCAVO"]
[null,"VIVIENDA POPULAR","BULLDOZER"]
[null,"HOTEL","HELICOPTERO"]
[null,"CENTRO COMERCIAL","AVION"]
[null,"LOCAL COMERCIAL","AVIONETA"]
[null,"VIVIENDA CON COMERCIO","AEROPLANO"]
[null,"OFICINAS","VELETA"]
[null,"VIVIENDA CON OFICINAS","BARCO"]
[null,"BODEGA","LANCHA"]
[null,"NAVE INDUSTRIAL","TRANVIA "]
[null,"TERRENO BALDIO","FERROCARRIL"]
[null,"TERRENO EJIDAL","TREN"]
[null,"TERRENO INDUSTRIAL","OTRO"]
[null,"TERRENO AGROPECUARIO",1]
[null,"GASOLINERIA"]
[null,"CEMENTERIO"]
[null,"IGLESIA"]
[null,"OTRO"]
[null,1]

{"sheet":"CALCULO Empleados","index":4,"n_rows":628,"n_cols":29,"rows_kept":628,"cut":false,"hidden":true,"merged":[]}
[]
[null,"ARANCEL PARA PAGO A UNIDADES DE VALUACIÓN Y COBRO A EMPLEADOS "]
[]
[null,"AVALUOS DE INMUEBLES"]
[null,null,"Base: ","Sobre el valor real del bien valuado"]
[null,null,"Cuota Mínima","$ 1413.00 (IVA Incluído)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MAS CUOTA FIJA"]
[null,"RANGO DE","LIMITE",null,"CUOTA","TASA",null,null,"VALOR COMERCIAL","LIMITE",null,"DIF. * TASA","(VALOR DEL AVALUO)"]
[null,"LIMITE INFERIOR","LIMITE SUPERIOR","FIJA","MARGINAL",null,null,"VALOR COMERCIAL","INFERIOR","DIFERENCIA","MARGINAL","más CUOTA FIJA","IVA","TOTAL"]
[null,1,320000,1217.3900000000001,0,0,null,219000,1,{"$f":"H11-I11","v":218999},{"$f":"J11*E11","v":0},{"$f":"D11","v":1217.3900000000001},{"$f":"L11*0.16","v":194.78240000000002},{"$f":"L11+M11","v":1412.1724000000002}]
[null,320001,500000,1218,null,0,null,{"$f":"$M$20","v":0},{"$f":"1","v":1},-1,0,{"$f":"D12","v":1218},{"$f":"L12*0.16","v":194.88},{"$f":"(L12+M12)","v":1412.88}]
[null,500001,1000000,1250,2.3800000000000002E-3,2.38,null,{"$f":"$M$20","v":0},{"$f":"B13","v":500001},-500001,{"$f":"J13*E13","v":-1190.0023800000001},{"$f":"(K13+D13)*0.9","v":53.997857999999887},{"$f":"L13*0.16","v":8.639657279999982},{"$f":"L13+M13","v":62.637515279999867}]
[null,1000001,2000000,2440,2.1800000000000001E-3,2.1800000000000002,null,0,1000001,-1000001,-2180.00218,233.99803800000004,37.439686080000008,271.43772408000007]
[null,2000001,4000000,4620,1.89E-3,1.89,null,0,2000001,-2000001,-3780.00189,755.99829899999997,{"$f":"L15*0.16","v":120.95972784},876.95802684]
[null,4000001,8000000,8400,1.58E-3,1.58,null,0,4000001,-4000001,-6320.0015800000001,1871.998578,299.51977247999997,2171.5183504799998]
[null,8000001,16000000,14720,1.2800000000000001E-3,1.28,null,0,8000001,-8000001,-10240.00128,4031.9988479999997,645.11981567999999,4677.1186636799994]
[null,16000001,900000000,24960,1.0200000000000001E-3,1.02,null,0,16000001,-16000001,-16320.001020000002,7775.9990819999985,1244.1598531199998,9020.1589351199982]
[]
[null,"Para poder determinar el costo total del avalúo se tiene que realizar el siguiente proceso:",null,null,null,null,null,null,null,null,null,"Valor concluido",{"$f":"+'Hipoteca Free'!H20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total a pagar C/IVA",{"$f":"IF(AND(M20>=B12,M20<=C12),N12,IF(AND(M20>=B13,M20<=C13),N13,IF(AND(M20>=B14,M20<=C14),N14,IF(AND(M20>=B15,M20<=C15),N15,IF(AND(M20>=B16,M20<=C16),N16,IF(AND(M20>=B17,M20<=C17),N17,IF(AND(M20>=B18,M20<=C18),N18)))))))","v":false}]
[null,"1.- Al valor comercial del avalúo le restamos el valor inferior ya establecido en esta tabla,"]
[null,"2.- Como resultado tendremos una diferencia la cual multiplicamos por la cuota marginal ya establecida,"]
[null,"3.- A dicho resultado se le sumará la cuota fija ya establecida, la cual nos arrojará el importe del avalúo, a eso restarle 10% de descuento",null,null,null,null,null,null,null,null,null,"Inferior",{"$f":"VLOOKUP(M20,$B$10:$N$18,MATCH(\"Inferior\",$B$10:$N$10,0),TRUE)","v":{"$error":"#N/A"}}]
[null,"4.- Por último se agrega el I.V.A. y da como resultado el total de honorarios a pagar.",null,null,null,null,null,null,null,null,null,"Difetencia",{"$f":"M20-M24","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Marginal",{"$f":"VLOOKUP(M20,$B$10:$N$18,MATCH(\"marginal\",$B$10:$N$10,0),TRUE)*M25","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Mas Cuota Fija",{"$f":"((VLOOKUP(M20,$B$10:$N$18,MATCH(\"Fija\",$B$10:$N$10,0),TRUE)+M26)*0.9)*1.16","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,null,null,null,"tarifa actual/ construcción. "]

{"sheet":"Análisis Costos","index":5,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[[1,4,1,5],[1,6,1,7],[1,8,1,9]]}
[null,null,null,null,2.75,null,2.75,null,2.75]
[null,null,null,"Empleados","Mercado Abierto",null,"Mercado Abierto - 10% Desc",null,"Mercado Abierto - 20% Desc"]
[null,null,"Valor Inmueble","Costo","Costo","Dif vs Empleado","Costo","Dif vs Empleado","Costo","Dif vs Empleado"]
[null,null,1000000,{"$f":"IF(C4<=500000,(((VLOOKUP(C4,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C4,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C4-VLOOKUP(C4,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C4,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C4,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C4-VLOOKUP(C4,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":2547.3575152799999},{"$f":"IF((($C4*E$1)/1000)<=1413,1413,(IF((($C4*E$1)/1000)>18000,18000,(($C4*E$1)/1000))))","v":2750},{"$f":"E4-$D4","v":202.64248472000008},{"$f":"(IF((($C4*G$1)/1000)<=1413,1413,(IF((($C4*G$1)/1000)>18000,18000,(($C4*G$1)/1000)))))*0.9","v":2475},{"$f":"G4-$D4","v":-72.357515279999916},{"$f":"(IF((($C4*I$1)/1000)<=1413,1413,(IF((($C4*I$1)/1000)>18000,18000,(($C4*I$1)/1000)))))*0.8","v":2200},{"$f":"I4-$D4","v":-347.35751527999992}]
[null,null,{"$f":"C4+1000000","v":2000000},{"$f":"IF(C5<=500000,(((VLOOKUP(C5,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C5,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C5-VLOOKUP(C5,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C5,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C5,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C5-VLOOKUP(C5,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":4823.2777240800006},{"$f":"IF((($C5*E$1)/1000)<=1413,1413,(IF((($C5*E$1)/1000)>18000,18000,(($C5*E$1)/1000))))","v":5500},{"$f":"E5-$D5","v":676.72227591999945},{"$f":"(IF((($C5*G$1)/1000)<=1413,1413,(IF((($C5*G$1)/1000)>18000,18000,(($C5*G$1)/1000)))))*0.9","v":4950},126.72227591999945,{"$f":"(IF((($C5*I$1)/1000)<=1413,1413,(IF((($C5*I$1)/1000)>18000,18000,(($C5*I$1)/1000)))))*0.8","v":4400},-423.27772408000055]
[null,null,{"$f":"C5+1000000","v":3000000},{"$f":"IF(C6<=500000,(((VLOOKUP(C6,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C6,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C6-VLOOKUP(C6,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C6,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C6,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C6-VLOOKUP(C6,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":6796.43802684},8250,1453.56197316,7425,628.56197315999998,6600,-196.43802684000002]
[null,null,4000000,{"$f":"IF(C7<=500000,(((VLOOKUP(C7,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C7,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C7-VLOOKUP(C7,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C7,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C7,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C7-VLOOKUP(C7,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":8769.5980268399999},11000,2230.4019731600001,9900,1130.4019731600001,8800,30.401973160000125]
[null,null,5000000,{"$f":"IF(C8<=500000,(((VLOOKUP(C8,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C8,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C8-VLOOKUP(C8,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C8,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C8,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C8-VLOOKUP(C8,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":10419.118350479999},13750,3330.8816495200008,12375,1955.8816495200008,11000,580.88164952000079]
[null,null,6000000,{"$f":"IF(C9<=500000,(((VLOOKUP(C9,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C9,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C9-VLOOKUP(C9,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C9,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C9,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C9-VLOOKUP(C9,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":12068.63835048},16500,4431.3616495200004,14850,2781.3616495200004,13200,1131.3616495200004]
[null,null,7000000,{"$f":"IF(C10<=500000,(((VLOOKUP(C10,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C10,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C10-VLOOKUP(C10,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C10,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C10,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C10-VLOOKUP(C10,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":13718.15835048},18000,4281.8416495199999,16200,2481.8416495199999,14400,681.84164951999992]
[null,null,8000000,{"$f":"IF(C11<=500000,(((VLOOKUP(C11,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C11,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C11-VLOOKUP(C11,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C11,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C11,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C11-VLOOKUP(C11,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":15367.678350480001},18000,2632.3216495199995,16200,832.32164951999948,14400,-967.67835048000052]
[null,null,9000000,{"$f":"IF(C12<=500000,(((VLOOKUP(C12,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C12,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C12-VLOOKUP(C12,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C12,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C12,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C12-VLOOKUP(C12,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":16703.998663679999},18000,1296.0013363200014,16200,-503.99866367999857,14400,-2303.9986636799986]
[null,null,10000000,{"$f":"IF(C13<=500000,(((VLOOKUP(C13,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C13,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C13-VLOOKUP(C13,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C13,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C13,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C13-VLOOKUP(C13,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":18040.318663679998},18000,-40.318663679998281,16200,-1840.3186636799983,14400,-3640.3186636799983]
[null,null,{"$f":"C13+5000000","v":15000000},{"$f":"IF(C14<=500000,(((VLOOKUP(C14,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C14,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C14-VLOOKUP(C14,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C14,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C14,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C14-VLOOKUP(C14,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":24721.91866368},18000,-6721.9186636800005,16200,-8521.9186636800005,14400,-10321.91866368]
[null,null,{"$f":"C14+5000000","v":20000000},{"$f":"IF(C15<=500000,(((VLOOKUP(C15,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C15,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C15-VLOOKUP(C15,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C15,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C15,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C15-VLOOKUP(C15,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":30317.75893512},18000,-12317.75893512,16200,-14117.75893512,14400,-15917.75893512]
[null,null,25000000,{"$f":"IF(C16<=500000,(((VLOOKUP(C16,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C16,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C16-VLOOKUP(C16,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C16,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C16,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C16-VLOOKUP(C16,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":35642.158935120002},18000,-17642.158935120002,16200,-19442.158935120002,14400,-21242.158935120002]
[null,null,30000000,{"$f":"IF(C17<=500000,(((VLOOKUP(C17,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C17,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C17-VLOOKUP(C17,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C17,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C17,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C17-VLOOKUP(C17,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":40966.558935119996},18000,-22966.558935119996,16200,-24766.558935119996,14400,-26566.558935119996]
[null,null,35000000,{"$f":"IF(C18<=500000,(((VLOOKUP(C18,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C18,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C18-VLOOKUP(C18,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C18,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C18,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C18-VLOOKUP(C18,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":46290.958935119997},18000,-28290.958935119997,16200,-30090.958935119997,14400,-31890.958935119997]
[null,null,40000000,{"$f":"IF(C19<=500000,(((VLOOKUP(C19,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C19,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C19-VLOOKUP(C19,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C19,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C19,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C19-VLOOKUP(C19,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":51615.358935119999},18000,-33615.358935119999,16200,-35415.358935119999,14400,-37215.358935119999]
[null,null,45000000,{"$f":"IF(C20<=500000,(((VLOOKUP(C20,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C20,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C20-VLOOKUP(C20,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C20,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C20,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C20-VLOOKUP(C20,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":56939.75893512},18000,-38939.75893512,16200,-40739.75893512,14400,-42539.75893512]
[null,null,50000000,{"$f":"IF(C21<=500000,(((VLOOKUP(C21,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C21,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C21-VLOOKUP(C21,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE))))*1.16),(((VLOOKUP(C21,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"fija\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)+VLOOKUP(C21,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"marginal\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)*(C21-VLOOKUP(C21,'CALCULO Empleados'!$B$10:$N$18,MATCH(\"Inferior\",'CALCULO Empleados'!$B$10:$N$10,0),TRUE)))*0.9)*1.16))","v":62264.158935119995},18000,-44264.158935119995,16200,-46064.158935119995,14400,-47864.158935119995]