Vesti: Da li netko čita ovo?   :undecided:
collapse

* Linkovi - NBA

* Manager Topics

Bianconeri di Belgrado - Sezona 44 od strane lutkica71
[danas u 02:12:49]


FC Zvezdara sezona 44 od strane shokanito
[danas u 00:37:02]


FK Balkan S44 od strane vaso333
[danas u 00:02:39]


FK Crvena Zvezda od strane DjordjeZiga9
[April 09, 2020, 22:33:35]


FK Željezničar Sarajevo - odigrane utakmice S44 od strane rikinanic
[April 09, 2020, 22:07:06]


FC Jamming od strane robi024
[April 09, 2020, 21:49:42]


FK Vrsac 44 od strane stole
[April 09, 2020, 21:32:16]


NK Kamehame od strane Son Goku
[April 09, 2020, 21:12:50]


HNK Hajduk Split - S44 od strane besho1950
[April 09, 2020, 20:57:52]


FC La Masia odigrane utakmice S44 od strane izonika
[April 09, 2020, 20:51:21]


FK Jagodina od strane BRAT BIZON
[April 09, 2020, 19:40:51]


Borussia United od strane PiNk PaNtEr
[April 09, 2020, 17:01:02]

* Classic Topics

Prijave Classic sezona 13 (PS4) od strane kresoklc
[April 09, 2020, 22:48:09]

* BPL Topics

Svjetsko prvenstvo 2014.godina od strane Smailovicc
[danas u 02:14:26]


KimJong86 (34) od strane internacional 1
[danas u 00:15:23]


Turnir 9.4. od strane woolf
[April 09, 2020, 19:37:05]


WHITE BOYS FRIENDLY od strane jazavac
[April 09, 2020, 19:19:27]


Nk Sloga frendly od strane penka1000
[April 08, 2020, 22:15:49]


Friendly vs Austria-Turska team 08.04.2020 od strane Chille_HR
[April 08, 2020, 20:36:22]


kad smo vec kod glazbe iliti muzike :) od strane dvar
[April 08, 2020, 18:16:56]


Novi clan od strane X-Plosiv
[April 07, 2020, 19:19:33]


PiNk PaNtEr punjenja od strane PiNk PaNtEr
[April 07, 2020, 10:08:06]


El Matador punjenja od strane Anelka39
[April 07, 2020, 02:21:55]

* NBA manager

S30 KUP od strane Garinjo
[April 07, 2020, 10:30:30]

* NBA klasik

No posts were found.

* Calendar

April 2020
Pon Uto Sre Čet Pet Sub Ned
1 2 3 4 5
6 7 8 9 [10] 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30

No calendar events were found.

* Pitaj BPL!

Refresh History
  • X-Plosiv: Povećati TV prava!
    April 08, 2020, 18:30:51
  • stole: Recesija stigla na TM, trebace se  smanjiti prihodi u manageru uskoro
    April 08, 2020, 13:22:48
  • X-Plosiv: Na drugu stranu, nebo je plavo :D
    April 05, 2020, 16:15:27
  • Rilexx329: Prijava
    Mart 31, 2020, 22:00:36
  • Rilexx329: Prijava
    Mart 31, 2020, 21:55:28
  • stole: Otvorene prijave za classic sezonu 13
    Mart 30, 2020, 20:33:02
  • stole: [link]
    Mart 30, 2020, 20:32:48
  • Anelka39: Novi turnir  :o [link]
    Mart 27, 2020, 05:51:01
  • Anelka39: Kim sta je sa BPL kvizom  :D
    Mart 26, 2020, 16:20:25
  • izonika: novi turnir je tu
    Mart 24, 2020, 11:36:13
  • izonika: [link]
    Mart 24, 2020, 11:36:10
  • VEK1NG: Do kad je rok za pravljelje ekipa za turnir?
    Mart 23, 2020, 16:14:53
  • izonika: veceras turnir
    Mart 23, 2020, 10:16:21
  • izonika: [link]
    Mart 23, 2020, 10:16:15
  • Anelka39: Gotovo je sada. Shebo si sve. Tesko je ljude sada nagovorit da kace slike itd. Naucio si ih ovako i sumnjam da bi se ko prijavio da stavim pravila kako su nekada bila.
    Mart 22, 2020, 17:33:21
  • izonika: napravi ti onda anelka turnir
    Mart 22, 2020, 13:37:56
  • Anelka39: Nije to vise kao nekada. Hebes turnir bez izvjesta,slika itd. Zalosno
    Mart 21, 2020, 22:45:17
  • frkass1950: Šta ti je, taj turnir je gotov.... :D
    Mart 21, 2020, 19:07:42
  • Anelka39: [link]
    Mart 16, 2020, 04:52:42
  • Anelka39: Ko hoce igrat turnir neka se tu prijavi. [link]
    Mart 16, 2020, 04:52:27

Autor Tema: excel obrazac  (Pročitano 3920 puta)

0 Članovi i 1 gost pregledaju ovu temu.

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #30 poslato: Jun 16, 2016, 08:59:05 »
:svaka čast:
Napokon sam sam ispunio ovo čudo.
Radi sve osim tog linkanja transfermarkta, to otključaj ako neće stvarat probleme, pa da svak sebi unese. - nije problem otključati, ali linkanje radi - probao sve svoje igrače - nešto je do tebe  :cheesy:

Par sitnica:
- ako nije upisano ime igrača, a prezime je, on neće biti brojan u ukupan broj igrača - nije istina, jer broji upravo stupac sa prezimenom  :cheesy:
- ako se upiše datum rođenja sa točkom iza godine(kako bi trebalo biti), neće radit, to je do excela vjerojatno - u excelu se datum ne piše sa točkom iza godine, jer to nije format datuma (doduše pogledaj datume na TM-u:cheesy:
- oboja samo ime igrača koji se može prodati za 50 ili 75 %, ne i prezime  :cry:  :cheesy: - vezano za prvu točku, potvrda da radiš krivo, u stupac "prezime" unosiš ime  :cheesy:  sto se estetike tiče, namjerno sam htio tako, ali nije problem staviti da oboji oboje :angel:


@shoka
nije ovo obavezno koristiti, tu je samo da olakša cijeli proces i smanji mogućnost rađenja grešaka kod financija.
ukoliko ne radiš sa excelom, treba upornosti samo, ali ako ti je lakše uz kalkulator i ručno kucanje na forum, smao daj  :cheesy:

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže pwn3der

  • Hero Member
  • *****
  • Poruke: 1.170
  • awards 2nd Manager League Champion
    • Awards
  • PSN ID: pwn_cro
Odg: excel obrazac
« Odgovor #31 poslato: Jun 16, 2016, 11:36:12 »
dada, zamjenio sam ime i prezime :D sad radi.  :baby:

Treba snimit video tutorijal da ljudi vide koliko ovo olakšava posao.
« Poslednja izmena: Jun 16, 2016, 11:38:23 od strane pwn3der »

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #32 poslato: Jun 16, 2016, 11:52:08 »
snimaj sunce mu yebem :D

ti si reziser za friendlije :D

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže shokanito

  • Hero Member
  • *****
  • Poruke: 2.176
    • Awards
  • PSN ID: Shoka-BG
Odg: excel obrazac
« Odgovor #33 poslato: Jun 16, 2016, 15:38:20 »
aaaaaaaaaaaaaa,  gde je stekovano prosirenjeee   ....       

Hvala  Vaso    :svaka čast:

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #34 poslato: Jun 19, 2016, 09:28:15 »
momci, iskrene isprike  :(


potkrala mi se jedna greška što se tiče definiranja poreza u kodu stanja za forum - u prilogu je ispravljena verzija.
stanje na prvom TRu bi vam trebalo biti ispravno, budući da tu porez nije obračunat, tako da nema zurbe da si prenesete podatke iz one ranije verzije.

ako netko treba pomoć da mu se to brzo odradi, neka javi

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže pwn3der

  • Hero Member
  • *****
  • Poruke: 1.170
  • awards 2nd Manager League Champion
    • Awards
  • PSN ID: pwn_cro
Odg: excel obrazac
« Odgovor #35 poslato: Jun 21, 2016, 16:50:53 »
Što misliš da se još doda overall za svakog igrača i da se ispod ispiše statistika ekipe?

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #36 poslato: Jun 21, 2016, 17:06:24 »
ok za over, ali kad kazes statistika, mislis li na prosjek overa?

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže pwn3der

  • Hero Member
  • *****
  • Poruke: 1.170
  • awards 2nd Manager League Champion
    • Awards
  • PSN ID: pwn_cro
Odg: excel obrazac
« Odgovor #37 poslato: Jun 21, 2016, 17:14:58 »
ok za over, ali kad kazes statistika, mislis li na prosjek overa?
hm, treba pogledat kako  se racuna ona statistika ekipe iz pesa

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #38 poslato: Jun 21, 2016, 17:50:11 »
pa daj mi formulu, pa cemo odraditi  :D

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže vaso333

  • NBA 2K Uprava
  • Superhero Member
  • ***
  • Poruke: 12.582
  • awards NBA League Winner VIFA Super League Champion Rodjendanski turnir 2nd Manager League 3rd place 2nd Manager League 2nd place VIFA International Club League 3-rd place
    • Awards
  • PSN ID: MPelAgiC
Odg: excel obrazac
« Odgovor #39 poslato: Avgust 11, 2016, 11:58:34 »
ljudi pocnite ovo koristit, za vase dobro :), vidim samo 4,5 nas mozda to koristi :?

i ja sam stara skola nesto tipa shoka, dugo me je mrzelo uopste pogledat ovo a kamoli da pocnem koristi...

tek sad vidim kad ovo koristim citavu sezonu, koliko je sve lakse a pre svega nemozes pogresit u kucanju posta ili zbrajanju, jer sve samo racuna i spremi ti za forum

jeste da se prvi put malo smorite upisivanjem svega, ali kad to jednom odradite, sve vam, kosto sam vec reko, samo racuna, samo copy/paste na forum i finansije su vam odradjene

puno je lakse sa ovim sve, bukvalno u minuti imate sve izracunato, bez da ste pogledali kalkulator ili otvorili temu za finansije na forumu

hvala chile i pozdravi wordstwortha :D

Van mreže pwn3der

  • Hero Member
  • *****
  • Poruke: 1.170
  • awards 2nd Manager League Champion
    • Awards
  • PSN ID: pwn_cro
Odg: excel obrazac
« Odgovor #40 poslato: Oktobar 07, 2016, 04:02:19 »
Sad sam izgubio preko sat vremena pokušavajući popravit neku grešku u stanju za forum, stalno mi davao krivi rezultat.. i nikako popravit.. odustao od popravaka i krenuo kopirat podatke u blank obrazac, tada sam skužio što me mučilo, potrebno je ručno upisati vrijednost ekipe.  :mf_pcwhack:  :hunter:

Daj molim te stavi tamo =SUM('Popis igrača'!L5:L29)  :hammer: :mf_pcwhack:

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #41 poslato: Oktobar 07, 2016, 09:59:01 »
drugi put pitaj ;)

namjerno je napravljeno tako da ne postoje dva popisa ekipa za prvi i drugi dio sezone.

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #42 poslato: Januar 25, 2018, 14:11:04 »
U prilogu novi obrazac sa izmjenama za sezonu 38 ako netko koristi.
« Poslednja izmena: April 15, 2018, 10:09:31 od strane Chille_HR »

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba

Van mreže Riky93

  • 11vs11
  • Hero Member
  • ***
  • Poruke: 1.970
  • ''Izgubljeno je ono cega smo se mi sami odrekli.''
  • awards 2nd Manager League Champion NBA Cup Winner 2nd Manager League 2nd place VIFA Super League Champion VIFA International Club League 3-rd place
    • Awards
  • PSN ID: Riki_NP
Odg: excel obrazac
« Odgovor #43 poslato: Januar 25, 2018, 15:29:13 »
U prilogu novi obrazac sa izmjenama za sezonu 38 ako netko koristi.

<3

Van mreže Chille_HR

  • Administrator
  • Hero Member
  • *****
  • Poruke: 8.413
  • Mali Matija... :)
  • awards VIFA Super League Champion Classic League Winner 2nd Manager League Champion VIFA International Club League 3-rd place 2nd Manager League 2nd place 1st Manager League 3rd place
    • Awards
  • PSN ID: Chille_HR
Odg: excel obrazac
« Odgovor #44 poslato: Januar 25, 2018, 15:31:47 »
jel to spicasti pimpac i yaya toure?
nisam nikada shvatio ovaj znak  :?

We are a football tribe...
Play for the name on the front of the shirt and they'll remember the name on the ba