[es] - Izvlacenje i uporedjivanje text,time,speed end raporta KAKO?

zoxjapanac
Zoran Uzelac
student
Novi Sad

Član broj: 232801
Poruke: 5
*.static.isp.telekom.rs.

Profil

Izvlacenje i uporedjivanje text,time,speed end raporta KAKO?

^{14.09.2009. u 23:31 - pre 177 meseci}

Pomoc Ako moze neko!
Treba da izracunam koliko u odredjeno vozilo na odredjenoj autobuskoj stanici ulazi i izlazi putnika( redosled automatskog popunjavanja baze iz gotove aplikacije, u sheet1 je po vremenu )Novi dogadjaj se ispisuje gore.
Mozda Bitan podatak da je 0km kad je vozilo na stanici i 0km kad ulaze izlaze putnici
.........A....................B.............C...........D..........E..........................F........................................
1 firma..................vozilo........Date......Time.....brzina...................dogadjaj
2 MOJTAXI.......... BUS2... 13-05-09 19:43:32.....0km...Vehicle next to the point of interest Autobuska stanica 1.
3 MOJTAXI.......... BUS1... 13-05-09 19:42:45.....30km...Vehicle sends its localizacion at 30km/h
4 MOJTAXI......... BUS2... 13-05-09 19:42:04.....0km...Vehicle next to the point of interest Autobuska stanica 4.
5 MOJTAXI......... BUS1... 13-05-09 19:41:26.....0km...Vehicle next to the point of interest Autobuska stanica 2.
6 MOJTAXI.......... BUS1... 13-05-09 19:42:45.....45km...Vehicle sends its localizacion at 45km/h
7 MOJTAXI......... BUS3... 13-05-09 19:39:33.....0km...Vehicle next to the point of interest Autobuska stanica 4.
8 MOJTAXI......... BUS1... 13-05-09 19:38:43.....0km...Is activated the device IZLAZ
9 MOJTAXI......... BUS2... 13-05-09 19:38:06......2km...Vehicle reconnects to the GSM/GPRS network.
10 MOJTAXI......... BUS1... 13-05-09 19:38:05......0km...Is activated the device ULAZ
11 MOJTAXI........ BUS3... 13-05-09 19:37:57......0km...Vehicle next to the point of interest Autobuska stanica 4.
12 MOJTAXI........ BUS2... 13-05-09 19:37:45......0km...Vehicle next to the point of interest Autobuska stanica 3.
13 MOJTAXI........ BUS1... 13-05-09 19:36:37......0km...Is activated the device ULAZ
14 MOJTAXI........ BUS1... 13-05-09 19:36:06......0km...Is activated the device ULAZ
15 MOJTAXI........ BUS1... 13-05-09 19:35:51......0km...Vehicle next to the point of interest Autobuska stanica 1.
16 MOJTAXI........ BUS2... 13-05-09 19:35:18.....30km...Vehicle sends its localizacion at 30km/h
17 MOJTAXI.......... BUS1... 13-05-0919:42:45.....43km...Vehicle sends its localizacion at 43km/h

Dakle, da iz ove baze koja mi se ispisuje na sheet1, da izvucem bazu na sheet2 da izgleda ovako

........................................BUS 1.......................................BUS2...............................................BUS3
..............................vreme...........PUTNICI...................vreme.......PUTNICI........................vreme.......PUTNICI
........................dolaska...Ulaz...Izlaz...Ostalo..........dolaska...Ulaz...Izlaz...Ostalo............dolaska...Ulaz...Izlaz...Ostalo
Autobu. stanica 1
Autobu. stanica 2
Autobu. stanica 3

Odgovor na temu