{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Resumen","Motos","Imágenes","Financiación"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":10,"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":"Resumen","index":0,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,6],[0,10,0,21],[8,0,8,6],[4,5,4,6],[5,5,5,6],[2,12,2,21]]}
["MOTO",null,null,null,null,null,null,null,null,null,"FINANCIACIÓN"]
["Marca","Modelo","Precio","Matriculación","Seguro","Baúl","Pitón"]
["SYM","Symphony_S",{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,2,0)","v":1949},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,3,0)","v":0},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,4,0)","v":"Sí"},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,5,0)","v":"Sí"},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,6,0)","v":"Sí"},null,null,null,12,"Meses",{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"LAS MOTOS KYMCO SÓLO OFRECEN FINANCIACIÓN A 12 MESES\",\"\")","v":""}]
[]
["Cilindrada(cc)","Potencia (Cv)","Ruedas (D/T)","Freno (D/T)","Refrigeración","Enlace",null,null,null,null,"Mes 1","Mes 2","Mes 3","Mes 4","Mes 5","Mes 6","Mes 7","Mes 8","Mes 9","Mes 10","Mes 11","Mes 12"]
[{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,7,0)","v":124.5},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,8,0)","v":0},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,9,0)","v":"16/16"},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,10,0)","v":"D/D"},{"$f":"VLOOKUP($B$3,Motos!$B$2:$M$6,11,0)","v":"Aire"},{"$f":"HYPERLINK(VLOOKUP($B$3,Motos!$B$2:$M$6,12,0))","v":"http://goo.gl/iO3K0b"},null,null,null,null,{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$C$3+$D$3+$F$11+$F$12+$F$13+$F$14+$F$15+$F$16+$F$17+$F$18+$F$19+$F$21,(VLOOKUP($K$3,Financiación!$A$2:$B$4,2,0))+($C$3/$K$3)+$D$3+$F$11+$F$12+$F$13+$F$14+$F$15+$F$16+$F$17+$F$18+$F$19+$F$21))","v":222.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666}]
[]
[null,null,null,null,null,null,null,null,null,null,"Mes 13","Mes 14","Mes 15","Mes 16","Mes 17","Mes 18","Mes 19","Mes 20","Mes 21","Mes 22","Mes 23","Mes 24"]
["ACCESORIOS",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$11+$F$12+$F$13+$F$14+$F$15+$F$16+$F$17+$F$18+$F$19+$F$21,(VLOOKUP($K$3,Financiación!$A$2:$B$4,2,0))+($C$3/$K$3)+$F$11+$F$12+$F$13+$F$14+$F$15+$F$16+$F$17+$F$18+$F$19+$F$21))","v":222.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666},{"$f":"IF(AND($A$3=+Motos!$A$3,$K$3>12),\"ERROR\",IF($K$3=0,$F$21,($C$3/$K$3)+$F$21))","v":162.41666666666666}]
[null,"Marca","Modelo","Precio","Descuento","Total"]
["Casco",null,null,null,0,{"$f":"D11*E11","v":0},null,null,null,null,"Mes 14","Mes 15","Mes 16","Mes 17","Mes 18","Mes 19","Mes 20","Mes 21","Mes 22","Mes 23","Mes 24","Mes 25"]
["Guantes",null,null,null,0,{"$f":"D12*E12","v":0},null,null,null,null,{"$f":"$F$20+$F$21","v":0},{"$f":"$F$21","v":0},0,0,0,0,0,0,0,0,0,0]
["Cazadora",null,null,null,0,0]
["Baúl",null,null,null,0,0]
["Pitón",null,null,null,0,0]
["Cúpula",null,null,null,0,0]
["Antirrobo",null,null,null,0,0]
["Cuerda",null,null,null,0,0]
["Seguro 1er año",null,null,null,0,{"$f":"D19*E19","v":0}]
["Seguro resto",null,null,null,0,0]
["Garaje",null,null,null,0,0]
[]
[]
[]
[]
[]
[{"$f":"IF(modelo=Motos!B2,\"BIEN\",\"MAL\")","v":"BIEN"}]

{"sheet":"Motos","index":1,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Marca","Modelo","Precio","Matrícula","Seguro","Baúl","Pitón","Cilindrada(cc)","Potencia (Cv)","Ruedas (D/T)","Freno (D/T)","Refrigeración","Enlace"]
["SYM","Symphony_S",1949,0,"Sí","Sí","Sí",124.5,null,"16/16","D/D","Aire","http://goo.gl/iO3K0b"]
["Kymco","Symphony_SR",1999,0,"Sí","Sí","Sí",124.5,null,"16/16","D/D","Aire","http://goo.gl/D0DNXx"]
[null,"Symphony_ST",2199,190,"Sí","Sí","Sí",124.6,null,"16/16","D/D","Aire","http://goo.gl/BDBSpD"]
[null,"HD_Evo",2599,190,"Sí","Sí","Sí",124.5,null,"16/16","D/D","Líquida","http://goo.gl/D6Xjrh"]
[null,"Agility_City",1999,190,"Sí","Sí","Sí",124.6,9.3699999999999992,"16/16","D/D","Aire","http://goo.gl/oXSD9l"]

{"sheet":"Imágenes","index":2,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Symphony S"]
["Symphony SR"]
["Symphony ST"]
["HD Evo"]
["Agility City"]

{"sheet":"Financiación","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["FINANCIACIÓN","Cuota"]
[0,0]
[12,60]
[24,125]