[ zoxjapanac @ 14.09.2009. 23:31 ] @
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 |