Spreadsheet: 223674d1364283449-extract-of-table-without-vba-or-filters-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | A VENDRE
Code | Vertrag | Kunden | Fahrzeug | Ausstattung | Farbe | km | 1. Immat. | Inst.kosten | Kat.preis | Rücknahme | Lieferant | VP inkl. | [NAME] % ET blau | Verkaufs datum | Stock Tage | ET Verkauf gelb | ET Eintausch. | encours | Total Rückstand TTC | Leasinggebühr | Kaution | Trop perçu | Schlüssel | Fzg.ausweis | Werksgarantie | Türen | Ch.-Nr. | [NAME]. | Jahrmonat | [NAME]
10 |  |  |  |  | weiss | 31929 | 2009-05-01 00:00:00 |  |  | 2010-10-27 00:00:00 |  | 15000 | 0.9111340581910952 | 2011-01-18 00:00:00 | 83 | 24497 | 16463 | 27784.53 | 3242.75 | 648.55 | 2000 |  |  |  |  |  |  |  | 201101 | -0.08886594180890484
10 |  |  |  |  | grau | 48795 | 2008-12-01 00:00:00 |  |  | 2010-12-07 00:00:00 |  | 9700 | 1.742410634093767 | 2011-01-11 00:00:00 | 35 | 11777 | 5567 | 9893.42 | 1971.4 | 492.85 | 0 | 0 |  |  |  |  |  |  | 201101 | 0.7424106340937668
10 |  |  |  |  | grau | 153756 | 2004-03-05 00:00:00 |  |  | 2010-12-21 00:00:00 |  | 4700 | 1.158777120315582 | 2011-01-11 00:00:00 | 21 | 11159 | 4056 | 1386.1 | 3477.95 | 498.7 | 1000 |  |  |  |  |  |  |  | 201101 | 0.1587771203155819
10 |  |  |  |  | grau | 53619 | 2009-07-01 00:00:00 |  |  | 2010-12-22 00:00:00 |  | 33200 | 1.119616902168415 | 2011-01-11 00:00:00 | 20 | 37663 | 29653 | 24417.66 | 3802.2 | 954.05 | 0 | 0 |  |  |  |  |  |  | 201101 | 0.1196169021684146
10 |  |  |  |  | grau | 116998 | 2006-12-21 00:00:00 |  |  | 2010-12-22 00:00:00 |  | 6000 | 2.580645161290323 | 2011-01-11 00:00:00 | 20 | 10565 | 2325 | 11311.95 |  | 422.35 | 0 | 0 |  |  |  |  |  |  | 201101 | 1.580645161290323
10 |  |  |  |  | schwarz | 69200 | 2006-09-01 00:00:00 |  |  | 2010-12-06 00:00:00 |  | 11400 | 0.8513180494361885 | 2011-01-20 00:00:00 | 45 | 20074 | 13391 | 7701.78 |  | 798.55 | 0 | 0 |  |  |  |  |  |  | 201101 | -0.1486819505638115
10 |  |  |  |  | rot | 74201 | 2009-06-01 00:00:00 |  |  | 2010-12-30 00:00:00 |  | 13650 | 1.078966089637183 | 2011-01-11 00:00:00 | 12 | 26591 | 12651 | 22216.68 | 3374.4 | 564.15 | 0 |  |  |  |  |  |  |  | 201101 | 0.07896608963718288
10 |  |  |  |  | weiss | 26401 | 2009-12-01 00:00:00 |  |  | 2010-12-30 00:00:00 |  | 50200 | 1.186592918262185 | 2011-02-08 00:00:00 | 40 | 55486 | 42306 | 56156.12 | 11060.65 | 1109.8 | 0 |  |  |  |  |  |  |  | 201102 | 0.186592918262185
10 |  |  |  |  | grau | 45134 | 2009-06-01 00:00:00 |  |  | 2010-12-30 00:00:00 |  | 12600 | 1.023558082859464 | 2011-02-10 00:00:00 | 42 | 17729 | 12310 | 20110.69 | 1860.15 | 560.55 | 0 | 0 |  |  |  |  |  |  | 201102 | 0.02355808285946392
10 |  |  |  |  | weiss | 41412 | 2009-04-01 00:00:00 |  |  | 2011-01-04 00:00:00 |  | 17400 | 0.9575170592119745 | 2011-01-20 00:00:00 | 16 | 24498 | 18172 | 18224.47 | 2507.8 | 419.3 | 0 | 0 |  |  |  |  |  |  | 201101 | -0.0424829407880255
10 |  |  |  |  | weiss | 3869 | 2010-09-01 00:00:00 |  |  | 2011-01-06 00:00:00 |  | 28700 | 0.9308510638297872 | 2011-01-25 00:00:00 | 19 | 37582 | 30832 | 25430.55 | 3800.15 | 952.7 | 0 | 0 |  |  |  |  |  |  | 201101 | -0.06914893617021278
10 |  |  |  |  | grau | 15246 | 2010-04-01 00:00:00 |  |  | 2011-01-01 00:00:00 |  | 7100 | 1.229863156071367 | 2011-01-20 00:00:00 | 19 | 9593 | 5773 | 10915.97 | 878.35 | 440 | 0 |  |  |  |  |  |  |  | 201101 | 0.2298631560713666
10 |  |  |  |  | schwarz | 72671 | 2008-04-01 00:00:00 |  |  | 2011-01-10 00:00:00 |  | 24450 | 1.878168689506837 | 2011-02-08 00:00:00 | 29 | 26058 | 13018 | 28439.91 | 6724.3 | 547.6 | 2200 | 0 |  |  |  |  |  |  | 201102 | 0.8781686895068368
10 |  |  |  |  | weiss | 56774 | 2008-01-11 00:00:00 |  |  | 2011-01-18 00:00:00 |  | 14000 | 1.342153197200652 | 2011-02-08 00:00:00 | 21 | 21498 | 10431 | 11978.93 | 892.2 | 446.95 | 0 | 0 |  |  |  |  |  |  | 201102 | 0.342153197200652
10 |  |  |  |  | silber | 110184 | 2002-11-01 00:00:00 |  |  | 2011-01-19 00:00:00 |  | 12100 | 1.078719800303111 | 2011-02-17 00:00:00 | 29 | 17082 | 11217 | 15204.69 | 827.7 | 413.85 | 0 | 0 |  |  |  |  |  |  | 201102 | 0.07871980030311132
10 |  |  |  |  | schwarz | 87600 | 2004-10-01 00:00:00 |  |  | 2011-01-19 00:00:00 |  | 16100 | 2.329282407407407 | 2011-03-08 00:00:00 | 48 | 17085 | 6912 | 16816.33 | 3224.4 | 806.1 | 0 | 0 |  |  |  |  |  |  | 201103 | 1.329282407407407
10 |  |  |  |  | grau | 40237 | 2008-12-04 00:00:00 |  |  | 2011-01-27 00:00:00 |  | 21250 | 1.262476235741445 | 2011-02-08 00:00:00 | 12 | 24538 | 16832 | 18206.15 | 2565.55 | 643.15 | 1300 |  |  |  |  |  |  |  | 201102 | 0.262476235741445
10 |  |  |  |  | grau | 119709 | 2001-02-01 00:00:00 |  |  | 2011-02-01 00:00:00 |  | 2500 | 250 | 2011-02-17 00:00:00 | 16 | 11017 | 10 | 6120.56 | 1776 | 355.2 | 0 | 0 |  |  |  |  |  |  | 201102 | 249
10 |  |  |  |  | beige | 27851 | 2008-01-01 00:00:00 |  |  | 2011-02-01 00:00:00 |  | 12050 | 1.236785384378528 | 2011-02-17 00:00:00 | 16 | 17817 | 9743 | 15264.87 | 2493.3 | 499.75 | 0 | 0 |  |  |  |  |  |  | 201102 | 0.2367853843785281
10 |  |  |  |  | weiss | 24863 | 2010-02-01 00:00:00 |  |  | 2011-02-03 00:00:00 |  | 19800 | 1.048839919482996 | 2011-02-17 00:00:00 | 14 | 28868 | 18878 | 23582.63 | 1044.8 | 522.4 | 0 | 0 |  |  |  |  |  |  | 201102 | 0.04883991948299604
10 |  |  |  |  | schwarz | 5082 | 2010-08-01 00:00:00 |  |  | 2011-02-03 00:00:00 |  | 7600 | 1.519696060787842 | 2011-02-17 00:00:00 | 14 | 8825 | 5001 | 10112.81 | 1477.45 | 296.15 | 0 | 0 |  |  |  |  |  |  | 201102 | 0.5196960607878425
10 |  |  |  |  | grau | 27968 | 2010-05-01 00:00:00 |  |  | 2011-02-21 00:00:00 |  | 8400 | 1.386596236381644 | 2011-03-08 00:00:00 | 15 | 9818 | 6058 | 8732.5 | 1666.4 | 278.4 | 0 |  |  |  |  |  |  |  | 201103 | 0.3865962363816442
10 |  |  |  |  | grau | 5632 | 2010-05-01 00:00:00 |  |  | 2011-02-21 00:00:00 |  | 8900 | 1.311523725316829 | 2011-03-08 00:00:00 | 15 | 10559 | 6786 | 8732.5 | 1666.4 | 278.4 | 0 | 0 |  |  |  |  |  |  | 201103 | 0.3115237253168288
10 |  |  |  |  | grau | 12000 | 2010-07-01 00:00:00 |  |  | 2011-02-21 00:00:00 |  | 14650 | 1.15363414442082 | 2011-03-03 00:00:00 | 10 | 18377 | 12699 | 16243.49 | 2899.95 | 415.35 | 0 |  |  |  |  |  |  |  | 201103 | 0.1536341444208205
10 |  |  |  |  | silber | 201377 | 2008-12-29 00:00:00 |  |  | 2011-02-22 00:00:00 |  | 17000 | 4.991192014092777 | 2011-03-08 00:00:00 | 14 | 20006 | 3406 | 44073.39 | 9976.45 | 1106.15 | 0 | 0 |  |  |  |  |  |  | 201103 | 3.991192014092777