{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Hoja1","Combo","INVENTARIO","A2","Cierre Auditoria","A6","A4","InventarioProlease","earn back","ReporteCobranza"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":130,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hoja1","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["DALTON AUTOMOTRIZ, S.A. DE C.V.",1,"Guadalajara",57001,"DALTON AUTOMOTRIZ, S.A. DE C.V.",1,"Alejandro Duk","91773728","Clerk"]
["UNITED AUTO MONTEREY S.A. DE C.V.",2,"Monterrey",57002,"UNITED AUTO MONTEREY S.A. DE C.V.",2,"Augusto Gómez","91773722","Clerk"]
["FAME PERISUR, S.A. DE C.V.",3,"D.F.",57003,"FAME PERISUR, S.A. DE C.V.",3,"Christian Palafox",91773707,"Clerk"]
["AUTOMOTRIZ TOY, S.A. DE C.V.",4,"D.F.",57004,"AUTOMOTRIZ TOY, S.A. DE C.V.",4,"Gloria Ravelo",91773704,"Clerk"]
["AINT, S.A. DE C.V.",5,"Huixquilucan Edo. de Mex.",57005,"AINT, S.A. DE C.V.",5,"Guillermo Díaz","91773745","Manager"]
["ALDEN SATELITE, S. DE R.L. DE C.V.",6,"Tlalnepantla, Edo. de Mex.",57006,"ALDEN SATELITE, S. DE R.L. DE C.V.",6,"Hector Melo",91773762,"Clerk"]
["LIDERAZGO AUTOMOTRIZ DE PUEBLA, S.A. DE C.V.",7,"Puebla",57007,"LIDERAZGO AUTOMOTRIZ DE PUEBLA, S.A. DE C.V.",7,"Hugo Valdés",91773732,"Clerk"]
["TOY AUTOMOTORES, S.A. DE C.V.",8,"Chihuahua",57008,"TOY AUTOMOTORES, S.A. DE C.V.",8,"Jeannine Rivas",91773701,"Clerk"]
["AUTOMOTORES DE LA LAGUNA, S.A. DE C.V.",9,"Torreón",57009,"AUTOMOTORES DE LA LAGUNA, S.A. DE C.V.",9,"Jonathan Salinas","91773702","Clerk"]
["TOYOMOTORS, S.A. DE C.V.",10,"León",57010,"TOYOMOTORS, S.A. DE C.V.",10,"Juan Fernandez",91773706,"Clerk"]
["OZ AUTOMOTRIZ, S. DE R.L. DE C.V.",11,"Guadalajara",57011,"OZ AUTOMOTRIZ, S. DE R.L. DE C.V.",11,"Leonardo Ruiz","91773724","Clerk"]
["CEVER TOLUCA, S.A. DE C.V.",12,"Toluca",57012,"CEVER TOLUCA, S.A. DE C.V.",12,"Luis Cano","91773732","Clerk"]
["PROMOTORA AUTOMOTRIZ SANTA FE, S.A. DE C.V.",13,"Santa Fe",57013,"PROMOTORA AUTOMOTRIZ SANTA FE, S.A. DE C.V.",13,"Luis García","91773721","Clerk"]
["AUTOMOTRIZ TOY DEL SURESTE, S.A. DE C.V.",14,"Mérida",57014,"AUTOMOTRIZ TOY DEL SURESTE, S.A. DE C.V.",14,"María Ivette Moreyra","91773703","Clerk"]
[null,15,null,57015,null,15,"Marianna López","91773725","Team Leader"]
["FAME VALLADOLID, S. DE  R.L. DE C.V.",16,"Morelia",57016,"FAME VALLADOLID, S. DE  R.L. DE C.V.",16,"Mario Riva Palacio",91773730,"Manager"]
["ALDEN QUERETARO, S. DE R.L. DE C.V.",17,"Queretaro",57017,"ALDEN QUERETARO, S. DE R.L. DE C.V.",17,"Patricio Marrón",91773705,"Clerk"]
["DECADA AUTOMOTRIZ, S. DE R.L. DE C.V.",18,"Veracruz",57018,"DECADA AUTOMOTRIZ, S. DE R.L. DE C.V.",18,"Ricardo Humphrey",91773731,"Clerk"]
["UNITED AUTO AGUASCALIENTES, S. DE R.L. DE C.V.",19,"Aguascalientes",57019,"UNITED AUTO AGUASCALIENTES, S. DE R.L. DE C.V.",19,"Tom Sullivan","91773737","Manager Director"]
["DALTON AUTOMOTORES, S. DE R.L. DE C.V.",20,"San Luis Potosí",57020,"DALTON AUTOMOTORES, S. DE R.L. DE C.V.",20]
["VALOR MOTRIZ S. DE R.L. DE C.V.",21,"Nuevo León",57021,"VALOR MOTRIZ S. DE R.L. DE C.V.",21]
["AUTOMOVILES VALLEJO S. DE R.L. DE C.V.",22,"Vallejo",57022,"AUTOMOVILES VALLEJO S. DE R.L. DE C.V.",22]
["CALIDAD DE TABASCO S. DE R.L. DE C.V.",23,"Tabasco",57023,"CALIDAD DE TABASCO S DE RL DE CV",23]
["PREMIER DE ORIENTE S. DE R.L. DE C.V.",24,"Culiacán",57024,"PREMIER DE ORIENTE S DE RL DE CV",24]
["ALECSA PACHUCA S. DE R.L. DE C.V.",25,"Pachuca",57025,"ALECSA PACHUCA S. DE R.L. DE C.V.",25]
["AUTOMOTRIZ VADO DEL RIO S. DE R.L. DE C.V.",26,"Hermosillo",57026,"AUTOMOTRIZ VADO DEL RIO S. DE R.L. DE C.V.",26]
[]
[]
["AUTOMOTRIZ OAXACA DE ANTEQUERA S. DE R.L. DE C.V.",29,"Oaxaca",57029,"AUTOMOTRIZ OAXACA DE ANTEQUERA S. DE R.L. DE C.V.",29]

{"sheet":"Combo","index":1,"n_rows":72,"n_cols":1,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
["Agencia Camionera F Hinos S de RL de CV"]
["Alden Queretaro S. de R.L. de C.V."]
["Alden Satelite S. de R.L. de C.V."]
["Alecsa Camiones y Autobuses S. de R.L. de C.V"]
["Alecsa Camiones y Autobuses S.A. de C.V."]
["Alecsa Celaya S. de R.L. de C.V."]
["Alecsa Pachuca S. de R.L DE C.V"]
["Auto Shat SA de CV"]
["Automotores de la Laguna S.A. de C.V."]
["Automotriz Mexicali, S. de R.L. de C.V."]
["Automotriz Nihon SA de CV"]
["Automotriz Oaxaca de Antequera S. de R.L. de C.V."]
["Automotríz Toy del Sureste, S. de R.L. de C.V."]
["Automotriz Toy, S.A. de C.V."]
["Automoviles Dinamicos S de RL de CV"]
["Automóviles Vallejo S. de R.L. de C.V."]
["Autopasion Zaragoza S. de R.L. de .C.V."]
["BAQUI AUTOMOTRIZ S DE RL DE CV"]
["Calidad de Campeche, S. de R.L. de C.V."]
["Calidad de Tabasco S. de R.L. de C.V."]
["Camino del Sol Automotriz Tijuana S. de R.L. de C.V."]
["Camiones Cuautli SA de CV"]
["Camiones evolucion de Chihuahua SA de CV"]
["Camiones Perfectos S.A. de C.V."]
["Camiones Premier de Noroeste, S.A. de C.V."]
["Camiones Selectos S. de R.L. de C.V."]
["Camiones Tollocan S.A. de C.V."]
["Camiones Triana de Aguascalientes SA de CV"]
["CCD Autosales Puerto Vallarta, S. de R.L. de C.V"]
["Cever Lomas Verdes S. de R.L. de C.V."]
["Cever Toluca S.A. de C.V."]
["Corporativo de Camiones Península, S.A. de C.V. "]
["Dalton Automotores S. de R.L. de C.V."]
["Dalton Automotriz, S. de R.L. de C.V."]
["Dalton Motors SLP SA de CV"]
["Década Automotriz S. de R.L. de C.V."]
["Decada Coatzacoalcos S. de R.L. de C.V."]
["Durango Automotores S. de R.L. de C.V."]
["Excelencia Motors SA de CV"]
["Fame Perisur, S. de R.L. de C.V."]
["Grupo Hinux S.A.P.I. de C.V."]
["Grupó MotorMexa Camiones SA de CV"]
["Grupo Peninsula Motors, S. de R.L. de C.V."]
["GT Motors Noreste S de RL de CV"]
["Liderazgo Automotriz de Puebla S.A. de C.V. "]
["LOMAS AUTOMOTRIZ SA DE CV"]
["Marbe Motors del Sureste, S.A. de C.V."]
["Megamotors Nippon S. de R.L. De C.V."]
["Muremi Camiones S.A. de C.V."]
["Oz Automotriz de Colima, S de RL de CV"]
["Oz Automotriz S. de R.L. de C.V."]
["Peninsula Motors SA de CV"]
["Premier de Oriente S. de R.L. de C.V."]
["Premier Oriente Mazatlán S. de R.L. de C.V."]
["Purdy Motor México S. de R.L. de C.V."]
["RALLY CHAMPION SA DE CV"]
["Samurai Motors S. de R.L. de C.V."]
["Samurai Motors Xalapa, S. de R.L. De C.V."]
["Sistemas y Equipo de Transporte, S.A. de C.V."]
["Solana Camiones S de R.L. de C.V."]
["Toy Automotores S.A. de C.V."]
["Toy Motors SA DE CV"]
["Toyocamiones S.de R. L de C.V."]
["Toyocoapa S.de R.L. de C.V."]
["TOYOMOTORS DE IRAPUATO S DE RL DE CV"]
["Toyomotors de Polanco, S. de R.L. de C.V."]
["Toyomotors S.A. de C.V."]
["United Auto de Aguascalientes S. de R.L. de C.V."]
["United Auto de Monterrey,  S. de R.L. de C.V."]
["United Auto Zacatecas S de RL de CV"]
["Valor Farrera Automotriz, S. de R.L. de C.V. "]
["VALOR MOTRIZ S DE RL DE CV"]

{"sheet":"INVENTARIO","index":2,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,15],[3,1,3,20],[4,1,4,20],[1,1,1,20]]}
[]
[null,"DETALLE DE UNIDADES EN AUDITORIA"]
[]
[null,"RALLY CHAMPION SA DE CV"]
[null,"2017-05-16T08:13:06"]
[]
[null,null,"F",null,null,null,"T","D","R",null,"O","E","DPP","VPAA","VPDA","VNP"]
[null,null,{"$f":"COUNTIF($M$13:$M$1048576,C7)","v":0},null,null,null,{"$f":"COUNTIF($M$13:$M$1048576,G7)","v":0},0,0,null,0,0,0,0,0,0]
[null,null,8]
[null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"SUM(C8:P8)","v":0}]
[]
["Clave","Nombre","Consec.","Operación","Fec.Factura","Fec.Inicio","Días Inv","VIN","Modelo","Detalle Eq","Monto Financiar","Saldo Insoluto","Status","SALE DATE","PROMISE DATE","Comentario","FECHA PAGO","DIAS ATRASO","MONTO","DIFERENCIA","STATUS"]
[40001,"RALLY CHAMPION SA DE CV",1,null,null,null,10,"JF1ZCAC15G8600409","BRZ 6AT 16MY",null,270400,270400]
[40001,"RALLY CHAMPION SA DE CV",2,null,null,null,179,"JF2GPABC1GH298238","CROSSTREK PREMIUM",null,320973.88,320973.88]
[40001,"RALLY CHAMPION SA DE CV",3,null,null,null,18,"JF2GPABC6GH291351","CROSSTREK PREMIUM",null,0,320973.15999999997,320973.15999999997]
[40001,"RALLY CHAMPION SA DE CV",4,null,null,null,18,"JF2SJDJC1HH404798","FORESTER 2.5I LIMITED",null,391847,391847]
[40001,"RALLY CHAMPION SA DE CV",5,null,null,null,18,"JF2SJDJC9HH419937","FORESTER 2.5I LIMITED",null,0,392006.92,392006.92]
[40001,"RALLY CHAMPION SA DE CV",6,null,null,null,209,"JF2SJDLCXGH558664","FORESTER 2.5I LIMITED",null,362636.73,362636.73]
[40001,"RALLY CHAMPION SA DE CV",7,null,null,null,119,"JF2SJDDC3HH405981","FORESTER 2.5I PREMIUM",null,360132.72,360132.72]
[40001,"RALLY CHAMPION SA DE CV",8,null,null,null,12,"JF2SJDSC7HH442390","FORESTER 2.5I TOURING",null,445527,445527]
[40001,"RALLY CHAMPION SA DE CV",9,null,null,null,12,"JF2SJDSC8HH418163","FORESTER 2.5I TOURING",null,445527,445527]
[40001,"RALLY CHAMPION SA DE CV",10,null,null,null,179,"JF2SJDWC4GH547641","FORESTER 2.5I TOURING",null,0,405575.36,405575.36]
[40001,"RALLY CHAMPION SA DE CV",11,null,null,null,119,"JF2SJDWC7GH514794","FORESTER 2.5I TOURING",null,405575.44,405575.44]
[40001,"RALLY CHAMPION SA DE CV",12,null,null,null,10,"JF2SJDHC1EH523369","FORESTER XS 2.5 CVT",null,160800,160800]
[40001,"RALLY CHAMPION SA DE CV",13,null,null,null,179,"JF1GJAL60GH013849","IMPREZA PREMIUM",null,351210.88,351210.88]
[40001,"RALLY CHAMPION SA DE CV",14,null,null,null,4,"JF1GJAF63GH021701","IMPREZA PREMIUM PLUS",null,323084.36,323084.36]
[40001,"RALLY CHAMPION SA DE CV",15,null,null,null,119,"JF1VA1L64H9805781","WRX LIMITED",null,504254.64,504254.64]
[null,null,null,null,null,null,null,null,null,null,1296251]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K13:K28)","v":5638220.6499999994}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"9000000","v":9000000}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+K31-K29","v":3361779.3500000006}]

{"sheet":"A2","index":3,"n_rows":91,"n_cols":9,"rows_kept":91,"cut":false,"hidden":false,"merged":[[89,0,89,2],[88,7,88,9],[7,0,7,8],[44,7,44,8],[14,2,14,7],[12,2,12,7],[39,1,39,8],[41,2,41,4],[41,5,41,6],[41,7,41,8],[42,2,42,4],[42,7,42,8],[10,2,10,7],[16,2,16,7],[54,2,54,4],[65,7,65,8],[90,0,90,2],[58,6,58,7],[90,7,90,9],[89,7,89,9],[63,2,63,4],[63,7,63,8],[64,2,64,4],[64,7,64,8],[62,2,62,4],[73,2,73,4],[73,7,73,8],[61,2,61,4],[61,7,61,8],[61,5,61,6],[74,2,74,4],[74,7,74,8],[44,2,44,4],[45,2,45,4],[43,7,43,8],[43,2,43,4],[49,1,49,8],[45,7,45,8],[80,0,80,9],[75,2,75,4],[75,7,75,8],[72,2,72,4],[72,7,72,8],[51,2,51,4],[51,5,51,6],[51,7,51,8],[52,2,52,4],[52,7,52,8],[84,0,84,9],[53,2,53,4],[53,7,53,8],[59,1,59,8],[71,2,71,4],[55,2,55,4],[55,7,55,8],[71,5,71,6],[71,7,71,8],[62,7,62,8],[65,2,65,4],[81,0,81,9],[82,0,82,9],[83,0,83,9],[54,7,54,8],[69,1,69,8]]}
[]
[]
[]
[]
[]
[]
[]
["Resumen de Auditoria"]
[]
[]
[null,"Fecha:","2017-05-16T08:13:06"]
[]
[null,"Dealer:","RALLY CHAMPION SA DE CV"]
[]
[null,"No. Dealer:",40001]
[]
[null,"Atención:"]
[]
[]
["Unidades en Plan Piso:"]
[]
["Se realizó auditoría en Plan Piso a",null,null,15]
[]
[]
[null,{"$f":"INVENTARIO!C8","v":0},"Unidades Físicas",null,null,{"$f":"INVENTARIO!M8","v":0},"Pago Diferido"]
[]
[null,{"$f":"INVENTARIO!H8","v":0},"Unidades Demo",null,null,{"$f":"INVENTARIO!N8","v":0},"Vendidas Pagadas Antes de Auditoría"]
[]
[null,{"$f":"INVENTARIO!I8","v":0},"Unidades Reparación",null,null,{"$f":"INVENTARIO!O8","v":0},"Vendidas Pagadas Durante Auditoría"]
[]
[null,{"$f":"INVENTARIO!L8","v":0},"Exhibición",null,null,{"$f":"INVENTARIO!P8","v":0},"Vendidas NO pagadas"]
[]
[null,{"$f":"INVENTARIO!K8","v":0},"Otros",null,null,{"$f":"INVENTARIO!G8","v":0},"Transito"]
[]
[]
[null,{"$f":"+B25+B27+B29+B31+B33+F25+F27+F29+F31+F33","v":0},"TOTAL"]
[]
[]
[]
[null,"Unidades Pagadas Durante Auditoria Vencidas"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha de Pago"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F43:G46)","v":0}]
[]
[null,"Unidades Pagadas Durante Auditoria"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha de Pago"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F53:G56)","v":0}]
[]
[null,"Unidades Vendida No Pagadas Vencidas"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha Compromiso de Pago"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total a pagar",{"$f":"SUM(F63:G66)","v":0}]
[]
[null,"Unidades Vendida No Pagadas"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha Compromiso de Pago"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total a pagar",{"$f":"SUM(F73:G76)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"I78+I68+I58","v":0}]
["OBSERVACIONES:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Gerente General"]
["Auditor Toyota Financial Services México",null,null,null,null,null,null,"Nombre y Firma"]

{"sheet":"Cierre Auditoria","index":4,"n_rows":91,"n_cols":11,"rows_kept":91,"cut":false,"hidden":false,"merged":[[90,7,90,9],[90,0,90,2],[89,0,89,2],[89,7,89,9],[53,2,53,4],[53,7,53,8],[54,2,54,4],[54,7,54,8],[81,1,81,10],[61,5,61,6],[61,7,61,8],[63,9,63,10],[64,9,64,10],[65,9,65,10],[62,9,62,10],[87,7,87,9],[42,9,42,10],[43,9,43,10],[44,9,44,10],[45,9,45,10],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[55,9,55,10],[61,9,61,10],[88,0,88,2],[88,7,88,9],[65,2,65,4],[65,7,65,8],[69,1,69,8],[71,2,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[72,9,72,10],[82,1,82,10],[83,1,83,10],[73,7,73,8],[74,2,74,4],[74,7,74,8],[72,2,72,4],[41,9,41,10],[75,2,75,4],[75,7,75,8],[62,2,62,4],[62,7,62,8],[63,2,63,4],[63,7,63,8],[64,2,64,4],[64,7,64,8],[55,7,55,8],[58,6,58,7],[59,1,59,8],[61,2,61,4],[74,9,74,10],[75,9,75,10],[73,9,73,10],[52,2,52,4],[52,7,52,8],[51,2,51,4],[51,5,51,6],[51,7,51,8],[72,7,72,8],[73,2,73,4],[41,7,41,8],[42,7,42,8],[43,2,43,4],[43,7,43,8],[44,2,44,4],[44,7,44,8],[41,2,41,4],[41,5,41,6],[42,2,42,4],[55,2,55,4],[45,2,45,4],[45,7,45,8],[49,1,49,8],[46,2,46,4],[39,1,39,8],[7,0,7,8],[10,2,10,7],[12,2,12,7],[14,2,14,7],[16,2,16,7],[34,6,34,8],[35,8,37,10]]}
[]
[]
[]
[]
[]
[]
[]
["Resumen de Auditoria"]
[]
[]
[null,"Fecha:"]
[]
[null,"Dealer:"]
[]
[null,"No. Dealer:"]
[]
[null,"Atención:"]
[]
[]
["Unidades en Plan Piso:"]
[]
["Se realizó auditoría en Plan Piso a"]
[]
[]
[null,{"$f":"INVENTARIO!C8","v":0},"Unidades Físicas",null,null,{"$f":"INVENTARIO!M8","v":0},"Pago Diferido"]
[]
[null,{"$f":"INVENTARIO!H8","v":0},"Unidades Demo",null,null,{"$f":"INVENTARIO!N8","v":0},"Vendidas Pagadas Antes de Auditoría"]
[]
[null,{"$f":"INVENTARIO!I8","v":0},"Unidades Reparación",null,null,{"$f":"INVENTARIO!O8","v":0},"Vendidas Pagadas Durante Auditoría"]
[]
[null,{"$f":"INVENTARIO!L8","v":0},"Exhibición",null,null,{"$f":"INVENTARIO!P8","v":0},"Vendidas NO pagadas"]
[]
[null,{"$f":"INVENTARIO!K8","v":0},"Otros",null,null,{"$f":"INVENTARIO!G8","v":0},"Transito"]
[]
[null,null,null,null,null,null,"Resultado de la Auditoria"]
[null,{"$f":"+B25+B27+B29+B31+B33+F25+F27+F29+F31+F33","v":0},"TOTAL"]
[]
[]
[]
[null,"Unidades Pagadas Durante Auditoria Vencidas"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha de Pago",null,"Total Liquidado"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F43:G46)","v":0},null,{"$f":"SUM(J43:K46)","v":0}]
[]
[null,"Unidades Pagadas Durante Auditoria"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha de Pago",null,"Total Liquidado"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(F53:G56)","v":0},null,{"$f":"SUM(J53:K56)","v":0}]
[]
[null,"Unidades Vendida No Pagadas Vencidas"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha Compromiso de Pago",null,"Total Liquidado"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total a pagar",{"$f":"SUM(F63:G66)","v":0},"Total pagado",{"$f":"SUM(J63:K66)","v":0}]
[]
[null,"Unidades Vendida No Pagadas"]
[]
[null,"No. de Unidades","Fecha de Venta",null,null,"Monto",null,"Fecha Compromiso de Pago",null,"Total Liquidado"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total a pagar",{"$f":"SUM(F73:G76)","v":0},"Total pagado",{"$f":"SUM(J73:K76)","v":0}]
[]
["OBSERVACIONES:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Omar Abarca",null,null,null,null,null,null,"Mariana Zamores"]
["Team Leader Plan Piso",null,null,null,null,null,null,"Gerente Plan Piso"]

{"sheet":"A6","index":5,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[23,9,23,10],[27,9,27,10],[30,9,30,10],[11,9,11,10],[14,9,14,10],[17,9,17,10],[20,9,20,10],[40,1,40,4],[38,1,38,4],[5,1,5,8],[39,6,39,8],[39,1,39,4],[7,1,7,8],[8,1,8,8],[38,6,38,8]]}
[]
[]
[]
[]
[]
[null,"Carta Responsiva Auditoria"]
[]
[null,{"$f":"INVENTARIO!B4","v":"RALLY CHAMPION SA DE CV"}]
[null,{"$f":"INVENTARIO!B5","v":"2017-05-16T08:13:06"}]
[]
[]
[1,"Usted personalmente vío y checo las unidades y su número de serie que constituyen",null,null,null,null,null,null,null,"SI"]
[null,"la garantìa colateral de Toyota Financial Services México."]
[]
[2,"Usted enlisto todas las unidades que encontró en la distribuidora no enlistadas en el",null,null,null,null,null,null,null,"SI"]
[null,"reporte de unidades."]
[]
[3,"Revisó en oficina el vencimiento del pago de las unidades que estan bajo el Plan de ",null,null,null,null,null,null,null,"SI"]
[null,"Pago Diferido."]
[]
[4,"Comentó en la auditoría  e informo a la Sucursal de cualquiera situación inusual.",null,null,null,null,null,null,null,"SI"]
[]
[]
[5,"Observo alguna situación en la que las unidades estan expuestas a robo o falta de",null,null,null,null,null,null,null,"NO"]
[null,"seguridad."]
[]
[]
[6,"El distribuidor utiliza áreas inseguras para almacenar unidades?",null,null,null,null,null,null,null,"NO"]
[]
[]
[7,"Usted encontró áreas sin iluminar para almacenaje o exhibición.",null,null,null,null,null,null,null,"NO"]
[]
[]
[null,"Certifico que he  realizado la auditoría de acuerdo a los procedimientos establecidos por TOYOTA FINANCIAL"]
[null,"SERVICES MEXICO, S.A. DE C.V."]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"B9","v":"2017-05-16T08:13:06"}]
[null,"SALVADOR RAMÍREZ ALVARADO",null,null,null,null,"Fecha"]
[null,"Auditor Toyota Financial Services México"]
[null,null,null,null,null,null,{"$f":"B9","v":"2017-05-16T08:13:06"}]
[null,null,null,null,null,null,"ESTATUS"]
[null,null,"Us. Físicas",null,null,null,"a"]
[null,null,"Us. Tránsito",null,null,null,"T"]
[null,null,"Us. Demo",null,null,null,"D"]
[null,null,"Reparación",null,null,null,"R"]
[null,null,"Otros",null,null,null,"O"]
[null,null,"Pago Diferido",null,null,null,"PD"]
[null,null,"Vendida Pagada Antes Auditoría",null,null,null,"VPAA"]
[null,null,"Vendidas Pagadas Duarente Auditoría",null,null,null,"VPDA"]
[null,null,"Vendida No Pagada",null,null,null,"VNP"]

{"sheet":"A4","index":6,"n_rows":168,"n_cols":6,"rows_kept":168,"cut":false,"hidden":false,"merged":[[167,3,167,4],[91,0,91,5],[133,0,133,5],[83,3,83,4],[49,0,49,5],[125,3,125,4],[5,0,5,5],[7,0,7,5],[8,0,8,5],[42,3,42,4],[18,10,18,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[41,3,41,4]]}
[]
[]
[]
[]
[]
["UNIDADES POR ACLARAR"]
[]
[{"$f":"+INVENTARIO!B4","v":"RALLY CHAMPION SA DE CV"}]
[{"$f":"INVENTARIO!B5","v":"2017-05-16T08:13:06"}]
[]
[null,"Id.","Serie","Modelo","Comentarios","Saldo"]
[1,5,"MHKMF53F2GK003886","Avanza",null,199381.88]
[2,10,"MHKMF53F5GK004028","Avanza",null,199381.88]
[3,13,"MHKMF53FXGK000069","Avanza","D",199381.88]
[4,45,"5YFBURHE6GP453542","Corolla",null,291295.81]
[5,54,"JTFSX23P1F6165089","Hiace",null,369250.46]
[6,56,"5TDYKRFH2GS134546","HighlanderLimitedPanoramicRoof",null,515796.09]
[7,63,"MR0EX8DD5G0244624","Hilux",null,272094.93]
[8,67,"JTDKN3DU7F1990091","Prius","D",307231.88]
[9,70,"JTDKBRFU7G3501431","PriusBase",null,309031.88]
[10,82,"5TDYK3DC2GS709054","SiennaXLELeather",null,485936.27]
[11,89,"VNKKTUD37GA057772","YarisH/BCoreMT",null,184170.91]
[12,103,"JTDBT9K32G1447333","YarisSDCoreMT",null,163651.88]
[13,111,"JTDBT9K3XG1447273","YarisSDPremium4AT",null,182371.88]
[14,112,"JTDBT9K31G1447453","YarisSDPremium5MT",null,173551.89]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
["HORA:","12:15:00",null,"VERONICA CERVERA"]
[null,null,null,"Gerente Administrativo"]
[]
[]
[]
[]
[]
[]
["UNIDADES POR ACLARAR"]
[]
[null,"Id.","Serie","Modelo","Comentarios","Saldo"]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
["HORA:"]
[null,null,null,"Gerente Administrativo"]
[]
[]
[]
[]
[]
[]
[]
["UNIDADES POR ACLARAR"]
[]
[null,"Id.","Serie",null,"Comentarios","Saldo"]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
["HORA:"]
[null,null,null,"Gerente Administrativo"]
[]
[]
[]
[]
[]
[]
[]
["UNIDADES POR ACLARAR"]
[]
[null,"Id.","Serie","Modelo","Comentarios","Saldo"]
[91]
[92]
[93]
[{"$f":"A139+1","v":94}]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
["HORA:"]
[null,null,null,"Gerente Administrativo"]

{"sheet":"InventarioProlease","index":7,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Customer Number","Legal Name","Consecutivo","Customer Name","Effective Date","Current Post Date","Días de Inventario","Serial Number","Model","Body","Original Principal Amount","Current Principal Amount","Collateral Code","Loan Number"]
["40001","RALLY CHAMPION SA DE CV",1,"SUBARU Querétaro","2017-05-05","2017-05-15",10,"JF1ZCAC15G8600409","BRZ 6AT 16MY",null,270400,270400,"PUP",259274]
["40001","RALLY CHAMPION SA DE CV",2,"SUBARU Querétaro","2016-11-17","2017-05-15",179,"JF2GPABC1GH298238","CROSSTREK PREMIUM","UT",320973.88,320973.88,"PB",184522]
["40001","RALLY CHAMPION SA DE CV",3,"SUBARU Querétaro","2017-04-27","2017-05-15",18,"JF2GPABC6GH291351","CROSSTREK PREMIUM","UT",320973.16000000003,320973.16000000003,"PB",213097]
["40001","RALLY CHAMPION SA DE CV",4,"SUBARU Querétaro","2017-04-27","2017-05-15",18,"JF2SJDJC1HH404798","FORESTER 2.5I LIMITED","UT",391847,391847,"PB",257885]
["40001","RALLY CHAMPION SA DE CV",5,"SUBARU Querétaro","2017-04-27","2017-05-15",18,"JF2SJDJC9HH419937","FORESTER 2.5I LIMITED","UT",392006.92,392006.92,"PB",184519]
["40001","RALLY CHAMPION SA DE CV",6,"SUBARU Querétaro","2016-10-18","2017-05-15",209,"JF2SJDLCXGH558664","FORESTER 2.5I LIMITED","UT",362636.73,362636.73,"PB",255300]
["40001","RALLY CHAMPION SA DE CV",7,"SUBARU Querétaro","2017-01-16","2017-05-15",119,"JF2SJDDC3HH405981","FORESTER 2.5I PREMIUM","UT",360132.72,360132.72,"PB",213098]
["40001","RALLY CHAMPION SA DE CV",8,"SUBARU Querétaro","2017-05-03","2017-05-15",12,"JF2SJDSC7HH442390","FORESTER 2.5I TOURING","UT",445527,445527,"PB",257884]
["40001","RALLY CHAMPION SA DE CV",9,"SUBARU Querétaro","2017-05-03","2017-05-15",12,"JF2SJDSC8HH418163","FORESTER 2.5I TOURING","UT",445527,445527,"PB",255302]
["40001","RALLY CHAMPION SA DE CV",10,"SUBARU Querétaro","2016-11-17","2017-05-15",179,"JF2SJDWC4GH547641","FORESTER 2.5I TOURING","UT",405575.36,405575.36,"PB",255301]
["40001","RALLY CHAMPION SA DE CV",11,"SUBARU Querétaro","2017-01-16","2017-05-15",119,"JF2SJDWC7GH514794","FORESTER 2.5I TOURING","UT",405575.44,405575.44,"PB",170363]
["40001","RALLY CHAMPION SA DE CV",12,"SUBARU Querétaro","2017-05-05","2017-05-15",10,"JF2SJDHC1EH523369","FORESTER XS 2.5 CVT",null,160800,160800,"PUP",257523]
["40001","RALLY CHAMPION SA DE CV",13,"SUBARU Querétaro","2016-11-17","2017-05-15",179,"JF1GJAL60GH013849","IMPREZA PREMIUM","SD",351210.88,351210.88,"PB",257524]
["40001","RALLY CHAMPION SA DE CV",14,"SUBARU Querétaro","2017-05-11","2017-05-15",4,"JF1GJAF63GH021701","IMPREZA PREMIUM PLUS","SD",323084.36,323084.36,"PB",184516]
["40001","RALLY CHAMPION SA DE CV",15,"SUBARU Querétaro","2017-01-16","2017-05-15",119,"JF1VA1L64H9805781","WRX LIMITED","SD",504254.64,504254.64,"PB",213100]

{"sheet":"earn back","index":8,"n_rows":70,"n_cols":19,"rows_kept":70,"cut":false,"hidden":true,"merged":[[25,1,25,2],[27,1,28,2],[27,4,28,4],[26,1,26,2],[26,3,26,4],[25,3,25,4],[52,15,52,17],[43,15,43,17],[42,15,42,17],[27,10,28,10],[27,14,28,14],[27,17,28,17],[51,15,51,17],[33,15,33,17],[27,12,28,13],[32,15,32,17],[27,15,28,15],[59,2,59,4],[58,2,58,6],[55,4,55,8],[53,4,53,8],[27,8,28,8],[47,4,47,5],[27,5,28,6],[25,5,25,6],[25,7,25,8],[27,18,28,18],[27,16,28,16],[25,15,25,16],[25,12,26,13],[26,7,26,8],[26,5,26,6],[26,9,26,10],[25,9,25,11]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Cálculo EARNBACK"]
[]
[]
[null,"General Data",null,null,null,null,null,null,"Auditors Data",null,null,null,"Supervisor Data",null,null,null,null,"Director Data"]
[]
[null,"Dealer",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,"Name",null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"Name",null,"Verónica Sotelo",null,null,"Name","Ramón Luna Torres"]
[null,"Dealership",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,"Position",null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"Position",null,"Manager",null,null,"Position","Operations Director"]
[null,"Dealer Number",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,"Telephone",null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,"Telephone",null,"9177 3720",null,null,"Telephone","9177 3740"]
[null,"Date",null,null,"2003-07-25"]
[null,"Close Date:",null,null,"2003-08-07"]
[]
[null,"New Floor Plan Oustandings",null,null,null,null,null,null,null,null,null,"Used Floor Plan Oustandings"]
[]
[null,null,null,null,"Units",null,"Oustanding Balance ",null,null,null,null,null,null,null,"Units",null,"Oustanding Balance "]
[null,null,null,null,null,null,"( pesos )",null,null,null,null,null,null,null,null,null,"( pesos )"]
[null,"New Toyota´s",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Used Toyota´s",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},21906043.739999998]
[null,"New Cars Non Toyota",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Used Cars Non Toyota",null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},0]
[]
[]
[]
[null,"Total Units",null,"Units",null,"Demo",null,"Reparation",null,"Others",null,null,"Exhibition",null,"Delayed Payment","Sold Paid Before",null,"Sold Paid In","Sold not Paid"]
[null,"Audit",null,"Inspected",null,"Unit",null,null,null,null,null,null,null,null,null,"Audit",null,"Audit"]
[null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"+INVENTARIO!Q2","v":0},{"$f":"+INVENTARIO!Q4","v":0},null,null,{"$f":"+INVENTARIO!#REF!","v":{"$error":"#REF!"}},null,{"$f":"+INVENTARIO!T2","v":0},null,{"$f":"+INVENTARIO!Q5","v":0},null,{"$f":"+INVENTARIO!T3","v":0},{"$f":"+INVENTARIO!T4","v":0},null,{"$f":"+INVENTARIO!T5","v":0},{"$f":"+INVENTARIO!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,"Paso 1","Determinar el porcentaje de Unidades Vendidas No Pagadas vs el Número Total de Unidades auditadas"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PUNTUACION",null,null,"Concept"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% UNP",null,null,"Points"]
[null,null,null,null,"UNP","Units sold not paid over 3 days",null,null,null,null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,null,null,null,0,"to",0.05,10]
[null,null,null,null,"Total Units","Units in Floor Plan",null,null,null,null,{"$f":"+B28","v":{"$error":"#REF!"}},null,null,null,null,5.0999999999999997E-2,"to",0.15,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.151,"to",0.2,5]
[null,null,null,null,"% UNP","UNP / Total Units",null,null,null,null,{"$f":"K35/K36","v":{"$error":"#REF!"}},null,{"$f":"IF(K38>=P38,S38,IF(K38>=P37,S37,IF(K38>=P36,S36,S35)))","v":{"$error":"#REF!"}},null,null,0.20100000000000001,"to","more",0]
[]
[]
[null,"Paso 2","Determinación de los días promedio de VIOLACION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concept"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Violation Days Average",null,null,"Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"to",2,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,"to",5,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.0999999999999996,"to",10,5]
[null,null,null,null,"Días promedio de violación",null,null,null,null,null,{"$f":"+#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF(K48>=P48,S48,IF(K48>=P47,S47,IF(K48>=P46,S46,S45)))","v":{"$error":"#REF!"}},null,null,10.1,"to","more",0]
[]
[null,"Paso 3","Cumplimiento Promesa de Pago"]
[]
[null,"Prometieron pagar:",null,"PROMESA DE PAGO __________________________.",null,null,null,null,null,null,null,null,null,null,null,"Concept"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Payment Arregment",null,null,"Points"]
[null,null,null,"SI","CUMPLIO CON SU PROMESA DE PAGO",null,null,null,null,null,null,null,{"$f":"IF(D54=\"SI\",S54,S55)","v":10},null,null,"Accomplish on date",null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Accomplish on date",null,null,0]
[null,null,null,null,null,null,null,null,null,null,"TOTAL PUNTUACION",null,{"$f":"M38+M48+M54","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Audit Evaluation Matrix"]
[null,null,"Score Range",null,null,null,"Qualification",null,"Weigth"]
[null,null,30,"to",28,null,"Excellent",null,0.5]
[null,null,27,"to",20,null,"Good",null,0.5]
[null,null,19,"to",15,null,"Satisfactory",null,0.2]
[null,null,14,"to",0,null,"Poor",null,0]
[]
[]
[null,null,"A","Pago del estado de cuenta a tiempo",null,null,null,null,0.5,null,"OK"]
[null,null,"B","Resultado de auditorías (EVALUACION)",null,null,null,null,{"$f":"IF(M56<=C64,I64,IF(M56<=C63,I63,IF(M56<=C62,I62,I61)))","v":{"$error":"#REF!"}},null,"OK"]
[]
[null,null,null,null,null,null,null,null,{"$f":"I67+I68","v":{"$error":"#REF!"}}]

{"sheet":"ReporteCobranza","index":9,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["ReporteCobranza","Legal Name","Customer Name","Customer Number","Parent Customer Number","Serial Number","Transaction Code","Transaction Amount","Reversed","NSF","Post Date","Product Type Description","Operación"]