MyCity » Baze podataka » uporedjivanje text,time,speed KAKO?

uporedjivanje text,time,speed KAKO?

Napisano na dan: 16.9.2009

uporedjivanje text,time,speed KAKO?
Sledeća strana Pagination

Idi na vrh

Poslao: 16 Sep 2009 16:50
Idi na vrh
offline
  • Pridružio: 16 Sep 2009
  • Poruke: 3

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



Registruj se da bi učestvovao u diskusiji. Registrovanim korisnicima se NE prikazuju reklame unutar poruka.

MyCity » Baze podataka » uporedjivanje text,time,speed KAKO?

Ko je trenutno na forumu
 

Ukupno su 1055 korisnika na forumu :: 28 registrovanih, 6 sakrivenih i 1021 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 3466 - dana 01 Jun 2021 17:07

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: Apok, ArchaBasha, avijacija, babaroga, bokisha253, CikaKURE, DH, Dogma21, Georgius, Haris, Kotarle, kybonacci, Litostroton, Mcdado, mercedesamg, Mercury, Metanoja, nuke92, operniki, pacika, panzerwaffe, predragc, raptorsi, RILE-NS, ruma, Sass Drake, velisa andjelic, W123