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 873 korisnika na forumu :: 115 registrovanih, 5 sakrivenih i 753 gosta   ::   [ Administrator ] [ Supermoderator ] [ Moderator ] :: Detaljnije

Najviše korisnika na forumu ikad bilo je 15694 - dana 01 Feb 2026 12:23

Korisnici koji su trenutno na forumu:
Korisnici trenutno na forumu: 037, 100jan, _stipa_, A.R.Chafee.Jr., ajo baba, aleph_one, Antoni S, Atomski čoban, Avalon015, baki011, Banovo Brdo, blackjack, blatruc82, Bobrock1, bojan_t, bojankrstc, bojcistv, Boris.A, C-Gun, Cp6uH, cyprus, Darko Jovanovic, DejanSt, desmeki, Despot1, dexter77, Dioniss, Djuza, Dogma21, dragan4s, draganl, dushan, DuškoMraz, ekozelj, Frunze, Futurama, galerija, Georgius, GH69, Gheljda, goxin, GveX, Hans Gajger, HogarStrashni, Imprimatur, Istman, istokzapad, ivanb, jalos, Jose, Kajzer Soze, Kamov, Kanader, KimiMR, king011, kmnmada, Kototamopeva, Kruger, Lester Freamon, Lieutenant, lord sir giga, Marko00, marsi, MB120mm, medaTT, Metanoja, Mi lao shu, Milan Miscevic, MiljanXD, milutin134, MiroslavD, Mitraljeta, nekdo, neko iz mase, Nemanja.M, nenaddz, Nikolajevic, niksa517, Nmr, nnovakis, Pancevac, Pantelejmon, PenzosGSP, perunnurep, pirke96, prasinar, Radio operater, Remarqe, s putnik, Samo gledam, sap, Silvertooth, Skywhaler, sspp, stalja, stegonosa, tamno.nebo, Teodor60, tomigun, tomo2, TripleMMM, Uros Cuore Sportivo, v0idmp3, Vanderx, vathra, Velizar Laro, vensla, virked, Vlada1389, Welky, yiyi, zeka013, Zemunikola, ZetaMan, zokilivac