{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Factura","Clientes","Facturas - principales","Detalles de la factura","Acerca de este rastreador de fa"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Factura","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,6],[2,1,2,2],[2,3,2,4],[2,5,2,6],[3,3,3,4],[4,3,4,4],[5,3,5,4],[37,1,37,4],[38,1,38,4]]}
[null,"Nombre De La Empresa"]
[null,"Dirección postal",null,"Telf.: Número de teléfono",null,"Correo electrónico"]
[null,"Ciudad, estado, código postal",null,"Fax: Número de fax",null,"Sitio web"]
[null,"Factura para:",{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],3,TRUE),\"\")","v":"Contoso, Ltd"},{"$f":"\"Teléfono: \"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],9,FALSE),\"\")","v":"Teléfono: 432-555-0189"},null,"N.º de factura:","3-456-2"]
[null,"Dirección:",{"$f":"IFERROR(IF((VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],5,FALSE))=\"\",\"\",(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],5,FALSE))),\"\")","v":"567 Walnut Lane"},{"$f":"\"Fax:     \"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],11,FALSE),\"\")","v":"Fax:     432-555-0123"},null,"Fecha de la factura:",{"$f":"IFERROR(IF(VLOOKUP(rngInvoice,InvoicesMain[],3,FALSE)=\"\",\"\",VLOOKUP(rngInvoice,InvoicesMain[],3,FALSE)),\"\")","v":"2019-08-08"}]
[null,null,{"$f":"IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],6,FALSE)&\", \"& VLOOKUP(VLOOKUP(G4,InvoicesMain[],2,FALSE),CustomerList[],7,FALSE)&\" \"&VLOOKUP(VLOOKUP(G4,InvoicesMain[],2,FALSE),CustomerList[],8,FALSE),\"\")","v":"Moline, MO 098765"},{"$f":"\"Correo electrónico: \"&IFERROR(VLOOKUP(VLOOKUP(rngInvoice,InvoicesMain[],2,FALSE),CustomerList[],10,FALSE),\"\")","v":"Correo electrónico: alguien@example.com"}]
[null,{"$f":"\"Factura para: \"&IFERROR(VLOOKUP(rngInvoice,InvoicesMain[],4),\"\")","v":"Factura para: Proyecto 2"}]
[null,"Artículo nº","Descripción","Cant.","Precio por unidad","Descuento","Precio"]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4567"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 1"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":39},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":5,"d":"5.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(1:1)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"$f":"IFERROR((D9*E9)-F9,\"\")","v":{"v":195,"d":"195.00 €"}}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4568"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 2"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(2:2)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":5,"d":"5.00 €"}},{"v":155,"d":"155.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4569"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 3"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":30},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":6,"d":"6.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(3:3)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"v":173,"d":"173.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4570"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 4"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":40},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(4:4)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":280,"d":"280.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4571"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 5"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":10},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(5:5)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":40,"d":"40.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4572"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 6"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":8,"d":"8.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(6:6)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":40,"d":"40.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4573"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 7"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":70},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":6,"d":"6.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(7:7)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":420,"d":"420.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4574"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 8"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":25},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":4,"d":"4.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(8:8)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":100,"d":"100.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4575"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 9"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":5},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(9:9)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":3,"d":"3.00 €"}},{"v":32,"d":"32.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4576"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 10"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":80},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":1,"d":"1.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(10:10)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":80,"d":"80.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4577"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 11"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":65},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":7,"d":"7.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(11:11)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":455,"d":"455.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Z4578"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":"Factura 3-456-2 Datos 12"},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":44},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":{"v":1,"d":"1.00 €"}},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(12:12)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":0},{"v":44,"d":"44.00 €"}]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(13:13)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(14:14)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(15:15)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(16:16)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(17:17)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(18:18)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(19:19)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(20:20)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(21:21)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(22:22)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(22:22)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(22:22)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(22:22)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(22:22)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(23:23)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(23:23)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(23:23)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(23:23)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(23:23)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(24:24)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(24:24)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(24:24)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(24:24)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(24:24)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[null,{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(25:25)), MATCH($B$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(25:25)), MATCH($C$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(25:25)), MATCH($D$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(25:25)), MATCH($E$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},{"$f":"IFERROR(INDEX(InvoiceDetails[],SMALL(IF(InvoiceDetails[N.º de factura]=rngInvoice,ROW(InvoiceDetails[])-ROW(InvoiceDetails[#Headers])), ROW(25:25)), MATCH($F$8, InvoiceDetails[#Headers], 0)),\"\")","v":""},""]
[{"$nulls":5},"Subtotal de la factura",{"$f":"SUM(ProjectInvoice[Precio])","v":{"v":2014,"d":"2,014.00 €"}}]
[{"$nulls":5},"Tipo impositivo",{"$f":"VLOOKUP(rngInvoice,InvoicesMain[],5)","v":{"v":0.0875,"d":"8.75%"}}]
[{"$nulls":5},"Impuesto sobre las ventas",{"$f":"G34*G35","v":{"v":176.225,"d":"176.23 €"}}]
[{"$nulls":5},"Otros",{"$f":"VLOOKUP(rngInvoice,InvoicesMain[],6)","v":0}]
[null,{"$f":"\"Todos los cheques se extenderán a nombre de  \"&Nombre_De_La_Empresa&\".\"","v":"Todos los cheques se extenderán a nombre de  Nombre De La Empresa."},{"$nulls":3},"Depósito recibido",{"$f":"VLOOKUP(rngInvoice,InvoicesMain[],7)","v":0}]
[null,"Total a pagar en <#> días. Cuentas vencidas sujetas a un cargo por servicios de <#>% al mes.",{"$nulls":3},"TOTAL",{"$f":"(G34+G36+G37)-G38","v":{"v":2190.225,"d":"2,190.23 €"}}]

{"sheet":"Clientes","index":1,"n_rows":6,"n_cols":12,"rows_kept":6}
[]
[null,null,"Clientes"]
[null,"Búsqueda","N.º de compañía","Nombre de la empresa","Nombre de contacto","Dirección","Ciudad","Provincia","Código postal","Teléfono","Correo electrónico","Fax"]
[null,{"$f":"C4& \" - \"&D4","v":"1 - Tailspin Toys "},1,"Tailspin Toys ","Pedro Armijo","345 Cherry Street","Albany","SD","123456","432-555-0178","alguien@example.com","432-555-0187"]
[null,"2 - Contoso, Ltd",2,"Contoso, Ltd","Miguel Torrez","567 Walnut Lane","Moline","MO","098765","432-555-0189","alguien@example.com","432-555-0123"]
[null,"Totales",{"$f":"\"Clientes totales: \"&SUBTOTAL(103,CustomerList[N.º de compañía])","v":"Clientes totales: 2"}]

{"sheet":"Facturas - principales","index":2,"n_rows":6,"n_cols":11,"rows_kept":6}
[]
[null,"Facturas"]
[null,"N.º de factura","Compañía","Fecha de la factura","Descripción del proyecto","Tipo impositivo","Otros","Depósito","Total de detalles","Total de la factura","Notas"]
[null,"3-456-1","1 - Tailspin Toys ",{"$f":"TODAY()","v":"2019-07-29"},"Proyecto 1",{"v":0.0875,"d":"8.75%"},{"v":100,"d":"100.00 €"},{"v":100,"d":"100.00 €"},{"$f":"SUMIF(InvoiceDetails[N.º de factura],\"=\"&InvoicesMain[[#This Row],[N.º de factura]],InvoiceDetails[Total])","v":{"v":5200,"d":"5,200.00 €"}},{"$f":"(InvoicesMain[[#This Row],[Total de detalles]]*(1+InvoicesMain[[#This Row],[Tipo impositivo]]))+InvoicesMain[[#This Row],[Otros]]-InvoicesMain[[#This Row],[Depósito]]","v":{"v":5654.999999999999,"d":"5,655.00 €"}}]
[null,"3-456-2","2 - Contoso, Ltd",{"$f":"TODAY()+10","v":"2019-08-08"},"Proyecto 2",{"v":0.0875,"d":"8.75%"},null,null,{"$f":"SUMIF(InvoiceDetails[N.º de factura],\"=\"&InvoicesMain[[#This Row],[N.º de factura]],InvoiceDetails[Total])","v":{"v":2014,"d":"2,014.00 €"}},{"$f":"(InvoicesMain[[#This Row],[Total de detalles]]*(1+InvoicesMain[[#This Row],[Tipo impositivo]]))+InvoicesMain[[#This Row],[Otros]]-InvoicesMain[[#This Row],[Depósito]]","v":{"v":2190.225,"d":"2,190.23 €"}}]
[null,"Totales",{"$f":"\"Facturas totales: \"&SUBTOTAL(103,InvoicesMain[N.º de factura])","v":"Facturas totales: 2"},{"$nulls":3},{"$f":"SUBTOTAL(109,InvoicesMain[Otros])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,InvoicesMain[Depósito])","v":{"v":100,"d":"100.00 €"}},{"$f":"SUBTOTAL(109,InvoicesMain[Total de detalles])","v":{"v":7214,"d":"7,214.00 €"}},{"$f":"SUBTOTAL(109,InvoicesMain[Total de la factura])","v":{"v":7845.2249999999985,"d":"7,845.23 €"}}]

{"sheet":"Detalles de la factura","index":3,"n_rows":40,"n_cols":8,"rows_kept":40}
[]
[null,"Detalles de la factura"]
[null,"Descripción","N.º de factura","Artículo nº","Cant.","Precio por unidad","Descuento","Total"]
[null,"Factura 3-456-1 Datos 1","3-456-1",1,1,{"v":1,"d":"1.00 €"},{"v":1,"d":"1.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":0,"d":"0.00 €"}}]
[null,"Factura 3-456-1 Datos 2","3-456-1",2,2,{"v":2,"d":"2.00 €"},{"v":2,"d":"2.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":2,"d":"2.00 €"}}]
[null,"Factura 3-456-1 Datos 3","3-456-1",3,3,{"v":3,"d":"3.00 €"},{"v":3,"d":"3.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":6,"d":"6.00 €"}}]
[null,"Factura 3-456-1 Datos 4","3-456-1",4,4,{"v":4,"d":"4.00 €"},{"v":4,"d":"4.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":12,"d":"12.00 €"}}]
[null,"Factura 3-456-1 Datos 5","3-456-1",5,5,{"v":5,"d":"5.00 €"},{"v":5,"d":"5.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":20,"d":"20.00 €"}}]
[null,"Factura 3-456-1 Datos 6","3-456-1",6,6,{"v":6,"d":"6.00 €"},{"v":6,"d":"6.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":30,"d":"30.00 €"}}]
[null,"Factura 3-456-1 Datos 7","3-456-1",7,7,{"v":7,"d":"7.00 €"},{"v":7,"d":"7.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":42,"d":"42.00 €"}}]
[null,"Factura 3-456-1 Datos 8","3-456-1",8,8,{"v":8,"d":"8.00 €"},{"v":8,"d":"8.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":56,"d":"56.00 €"}}]
[null,"Factura 3-456-1 Datos 9","3-456-1",9,9,{"v":9,"d":"9.00 €"},{"v":9,"d":"9.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":72,"d":"72.00 €"}}]
[null,"Factura 3-456-1 Datos 10","3-456-1",10,10,{"v":10,"d":"10.00 €"},{"v":10,"d":"10.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":90,"d":"90.00 €"}}]
[null,"Factura 3-456-1 Datos 11","3-456-1",11,11,{"v":11,"d":"11.00 €"},{"v":11,"d":"11.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":110,"d":"110.00 €"}}]
[null,"Factura 3-456-1 Datos 12","3-456-1",12,12,{"v":12,"d":"12.00 €"},{"v":12,"d":"12.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":132,"d":"132.00 €"}}]
[null,"Factura 3-456-1 Datos 13","3-456-1",13,13,{"v":13,"d":"13.00 €"},{"v":13,"d":"13.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":156,"d":"156.00 €"}}]
[null,"Factura 3-456-1 Datos 14","3-456-1",14,14,{"v":14,"d":"14.00 €"},{"v":14,"d":"14.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":182,"d":"182.00 €"}}]
[null,"Factura 3-456-1 Datos 15","3-456-1",15,15,{"v":15,"d":"15.00 €"},{"v":15,"d":"15.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":210,"d":"210.00 €"}}]
[null,"Factura 3-456-1 Datos 16","3-456-1",16,16,{"v":16,"d":"16.00 €"},{"v":16,"d":"16.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":240,"d":"240.00 €"}}]
[null,"Factura 3-456-1 Datos 17","3-456-1",17,17,{"v":17,"d":"17.00 €"},{"v":17,"d":"17.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":272,"d":"272.00 €"}}]
[null,"Factura 3-456-1 Datos 18","3-456-1",18,18,{"v":18,"d":"18.00 €"},{"v":18,"d":"18.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":306,"d":"306.00 €"}}]
[null,"Factura 3-456-1 Datos 19","3-456-1",19,19,{"v":19,"d":"19.00 €"},{"v":19,"d":"19.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":342,"d":"342.00 €"}}]
[null,"Factura 3-456-1 Datos 20","3-456-1",20,20,{"v":20,"d":"20.00 €"},{"v":20,"d":"20.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":380,"d":"380.00 €"}}]
[null,"Factura 3-456-1 Datos 21","3-456-1",21,21,{"v":21,"d":"21.00 €"},{"v":21,"d":"21.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":420,"d":"420.00 €"}}]
[null,"Factura 3-456-1 Datos 22","3-456-1",22,22,{"v":22,"d":"22.00 €"},{"v":22,"d":"22.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":462,"d":"462.00 €"}}]
[null,"Factura 3-456-1 Datos 23","3-456-1",23,23,{"v":23,"d":"23.00 €"},{"v":23,"d":"23.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":506,"d":"506.00 €"}}]
[null,"Factura 3-456-1 Datos 24","3-456-1",24,24,{"v":24,"d":"24.00 €"},{"v":24,"d":"24.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":552,"d":"552.00 €"}}]
[null,"Factura 3-456-1 Datos 25","3-456-1",25,25,{"v":25,"d":"25.00 €"},{"v":25,"d":"25.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":600,"d":"600.00 €"}}]
[null,"Factura 3-456-2 Datos 1","3-456-2","Z4567",39,{"v":5,"d":"5.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":195,"d":"195.00 €"}}]
[null,"Factura 3-456-2 Datos 2","3-456-2","Z4568",40,{"v":4,"d":"4.00 €"},{"v":5,"d":"5.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":155,"d":"155.00 €"}}]
[null,"Factura 3-456-2 Datos 3","3-456-2","Z4569",30,{"v":6,"d":"6.00 €"},{"v":7,"d":"7.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":173,"d":"173.00 €"}}]
[null,"Factura 3-456-2 Datos 4","3-456-2","Z4570",40,{"v":7,"d":"7.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":280,"d":"280.00 €"}}]
[null,"Factura 3-456-2 Datos 5","3-456-2","Z4571",10,{"v":4,"d":"4.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":40,"d":"40.00 €"}}]
[null,"Factura 3-456-2 Datos 6","3-456-2","Z4572",5,{"v":8,"d":"8.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":40,"d":"40.00 €"}}]
[null,"Factura 3-456-2 Datos 7","3-456-2","Z4573",70,{"v":6,"d":"6.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":420,"d":"420.00 €"}}]
[null,"Factura 3-456-2 Datos 8","3-456-2","Z4574",25,{"v":4,"d":"4.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":100,"d":"100.00 €"}}]
[null,"Factura 3-456-2 Datos 9","3-456-2","Z4575",5,{"v":7,"d":"7.00 €"},{"v":3,"d":"3.00 €"},{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":32,"d":"32.00 €"}}]
[null,"Factura 3-456-2 Datos 10","3-456-2","Z4576",80,{"v":1,"d":"1.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":80,"d":"80.00 €"}}]
[null,"Factura 3-456-2 Datos 11","3-456-2","Z4577",65,{"v":7,"d":"7.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":455,"d":"455.00 €"}}]
[null,"Factura 3-456-2 Datos 12","3-456-2","Z4578",44,{"v":1,"d":"1.00 €"},null,{"$f":"(InvoiceDetails[[#This Row],[Cant.]]*InvoiceDetails[[#This Row],[Precio por unidad]])-InvoiceDetails[[#This Row],[Descuento]]","v":{"v":44,"d":"44.00 €"}}]

{"sheet":"Acerca de este rastreador de fa","index":4,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[3,1,3,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[7,2,7,7],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,1,12,7],[13,2,13,3],[14,2,14,7],[15,1,15,7],[16,2,16,7],[17,2,17,7],[18,2,18,7],[19,2,19,7],[20,2,20,7],[21,2,21,7],[22,1,22,7],[23,1,23,7],[24,2,24,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,1,28,7],[29,1,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[36,2,36,7],[37,2,37,7],[38,2,38,7],[39,2,39,7]]}
[null,"Acerca de este rastreador de fa"]
[]
[]
[null,"Con el rastreador de facturas puede conservar un historial de múltiples clientes y facturas (incluidos los datos de factura necesarios) en un solo archivo. También puede usar el Rastreador de facturas para analizar los datos previamente facturados. Por ejemplo, puede ver todas las facturas de un cliente, de un proyecto específico o todas las facturas del último mes, el último año, etc."]
[null,"Antes de empezar, eche un vistazo a los datos de ejemplo que se proporcionan. En la hoja de Factura, seleccione la celda a la derecha del n.º de factura (celda L8) y se mostrará una lista desplegable. Seleccione la flecha desplegable y seleccione una factura de ejemplo. Observe cómo toda la información de la factura cambia automáticamente para reflejar la factura seleccionada. Ahora eche un vistazo a las hojas de Detalles de facturas, Clientes y Facturas: principal. Cada una de estas hojas proporciona información a la factura y todos los cambios que realice se actualizarán automáticamente. "]
[null,"¿Cómo puedo empezar?"]
[null,"Modifique la hoja de Factura para que refleje la información de su empresa mediante los pasos siguientes:"]
[null,"1.","Vaya a la hoja de Factura y, en la pestaña Revisar, en el grupo Proteger, seleccione Desproteger hoja. "]
[null,null,"Nota: La hoja de Factura está protegida para ayudar a evitar cambios no intencionados, ya que, como se ha mencionado anteriormente, la mayoría de los datos en esta hoja se extraerán de todas las demás hojas del libro. "]
[null,"2.","Personalice el encabezado de la factura escribiendo el nombre de su empresa, la dirección, la ciudad, el código postal, la dirección de correo electrónico, el sitio web, etc. En la parte inferior de la factura (fila 43), modifique las instrucciones de pago. "]
[null,null,"Importante. No modifique la información de facturación o de la factura. Todas estas celdas tienen fórmulas que actualizan automáticamente la factura, tal y como se indica en la sección Acerca de este rastreador de fa.  "]
[null,"3.","(Opcional) Modificar los colores de todo el libro: En la pestaña Disposicieón de página, en el grupo Temas, seleccione Colores y elija otro conjunto de colores de tema en la galería de colores. "]
[null,"Sugerencia: Cree un conjunto de colores de tema personalizado acorde con la marca de su empresa. Para hacerlo, en la pestaña Disposicieón de página, en el grupo Temas, seleccione Colores y elija  Personalizar colores. Para más información sobre cómo crear un conjunto de colores personalizado, vea el tema de ayuda siguiente: "]
[null,null,"Personalizar el tema de un documento."]
[null,"4.","Cuando haya realizado los cambios que quiera, vuelva a la hoja de Factura y, en la pestaña Revisar, en el grupo Cambios, seleccione Proteger hoja y seleccione Aceptar. Cuando la hoja de Factura está protegida, la única celda que puede seleccionar es la celda con el menú desplegable N.º de factura."]
[null,"¿Cómo creo una factura?"]
[null,"1.","En la hoja Clientes, especifique la información del cliente, como el nombre de la empresa y la dirección. Tenga en cuenta que el N.º de la empresa es importante, ya que proporciona un identificador único para cada empresa que se usará en todo el Rastreador de facturas. Observe también que solo necesita agregar cada empresa una vez. Para las facturas posteriores de la misma empresa, puede omitir este paso. "]
[null,null,"Nota:  Si asigna el mismo número a más de una empresa o introduce el mismo nombre de empresa más de una vez, las entradas se volverán de color rojo para alertar del duplicado. "]
[null,"2.","En la hoja Facturas: principal, escriba la información principal de la factura, como el número de factura, la fecha de la factura y la descripción del proyecto. Al igual que el n.º de la empresa, el número de factura es importante, ya que proporciona un identificador único para cada factura que se usará en todo el Rastreador de facturas. Otro elemento importante es la empresa. Cuando selecciona una empresa de la lista desplegable, se asocia la factura a esa empresa. Luego, al seleccionar un número de factura en la hoja de Factura, la información de dicha empresa, como el nombre de la empresa y la dirección, se rellenará automáticamente en la factura."]
[null,null,"Nota:  Si asigna el mismo número a más de una factura, las entradas se volverán de color rojo para alertar del duplicado. "]
[null,"3.","En la hoja de Detalles de factura, escriba los detalles de la factura, como la descripción del artículo, el número de artículo, la cantidad y el precio unitario. En la lista desplegable N.º de factura, se proporciona una lista de las facturas que ha introducido en la hoja de Facturas: principal para facilitar la introducción de datos. De forma similar al N.º de empresa en el paso anterior, el N.º de factura asocia esa información a una factura específica. Al seleccionar un número de factura en la hoja de Factura de la lista desplegable N.º de factura, se mostrarán los elementos de detalles de factura correspondientes para dicha factura."]
[null,null,"Nota: Hay un límite de 25 elementos de detalles por factura. Si agrega más de 25 elementos, todas las entradas correspondientes se volverán de color rojo para alertarle de esta limitación. Si tiene más de 25 elementos de factura, tendrá que crear una segunda factura. "]
[null,"¿Cómo agrego más clientes, facturas e información de factura?"]
[null,"Los datos de Clientes, Facturas y los Detalles de la factura se almacenan en las tablas de Excel. Cuando agrega una nueva fila a una tabla, se aplicará formato a la fila agregada automáticamente y los cálculos se copiarán. Para agregar nuevas filas de tabla, siga uno de estos procedimientos:"]
[null,"● ","Si la tabla no tiene una fila de total, comience a escribir debajo de la tabla y se expandirá automáticamente cuando presione la tecla Entrar o Tab."]
[null,"● ","Coloque el puntero de celda en la última celda por encima de la fila de Total, como en la celda de Notas de la última factura en la tabla Facturas, y presione la tecla Tab."]
[null,"● ","En la pestaña Inicio, en el grupo Celdas, seleccione Insertar y haga clic en Filas de tabla encima o Filas de tabla debajo. "]
[null,"● ","En la esquina inferior derecha de la tabla, coloque el ratón en el controlador de tamaño de tabla y arrastre hacia abajo para aumentar el número de filas de tabla disponibles."]
[null,"¿Cómo puedo analizar los detalles de mis facturas?"]
[null,"Tal y como se indica en la sección Información sobre este rastreador de facturas, una vez que haya introducido varias facturas, puede ver una lista de todas las facturas para un cliente, proyecto o intervalo de fechas específicos y mucho más. Este tipo de análisis se lleva a cabo con un Filtro que le permite delimitar rápidamente una lista de datos. Para acceder a un Filtro en las tablas Clientes, Facturas o Detalles de factura, seleccione una flecha desplegable junto a un nombre de campo de una tabla. Se mostrará un panel de filtros que le ofrecerá una amplia variedad de opciones de filtrado. Aquí se muestran algunos ejemplos de filtros que le ayudarán a empezar:"]
[null,"● ","Para ver la cantidad total que ha facturado a un cliente específico: En la hoja Facturas: principal, a la derecha del campo N.º de empresa, seleccione la flecha desplegable. En el panel de filtros, haga clic en Seleccionar todo para anular la selección de todas las empresas, seleccione la empresa que quiera y seleccione Aceptar. "]
[null,null,"Sugerencia: En el panel de Filtro también puede escribir el nombre del cliente en el cuadro de texto Buscar para buscar rápidamente en la lista disponible."]
[null,"● ","Para ver todas las facturas de un cliente específico y proyectos específicos: Para empezar, filtre por el cliente que quiera mediante los pasos que se proporcionan en el ejemplo anterior. Después, a la derecha del N.º de proyecto, seleccione la flecha desplegable. En el panel de filtros, seleccione el proyecto o proyectos que quiera y seleccione Aceptar. "]
[null,"● ","Para ver todas las facturas del mes anterior: En la hoja Facturas: principal, a la derecha del campo Fecha de factura, seleccione la flecha desplegable, seleccione Filtros de fecha y seleccione Mes pasado."]
[null,"● ","Para ver todos los clientes que tengan el mismo código de área: En la hoja Clientes, a la derecha del campo Teléfono, seleccione la flecha desplegable. En el panel de filtros, haga clic en el cuadro de texto Buscar, escriba el código de área y seleccione Aceptar. "]
[null,"Sugerencias de filtro"]
[null,"● ","Si una tabla tiene una fila de total, como Clientes y Facturas, los totales calculados reflejarán solo la lista filtrada."]
[null,"● ","Use varios filtros en un solo campo o en varios campos para ajustar los resultados."]
[null,"● ","Para quitar un único filtro, seleccione la flecha desplegable de una columna que haya filtrado previamente y seleccione Borrar filtro de <nombre del campo>."]
[null,"● ","Para eliminar varios filtros a la vez, coloque el puntero de celda en la tabla y, en la pestaña Inicio, en el grupo Edición, seleccione Ordenar y filtrar seleccione Borrar. "]