Tiempo:

Tus equipos:
Comunicación
Public account
  Zona PRO
1330 créditos
Comprar créditos
Estás en una cuenta pública. Si quieres jugar el juego o unirte a la discusión, tienes que loguearte. Si eres un usuario nuevo, debes registrarte primero.

  Asunto: US Under 19 Team


Usuario PRO Estados Unidos capsaicin


Yes - this is where I got the formula from, if you are interested: glanvalleyeaglets.wordpre...

It's hard to say anything precise about CL, training, and regeneration at this point. I don't think that there is a perfectly linear relation such that effective quality should be divided in half for 3/6 CL. A while back, I looked at the growth over the course of the season of all the players I had scouted for the national team and for my own team. Average growth rates (after attempting to separate all other factors other than CL by using players from my team with similar qualities and facilities) did not fall significantly from 6 to 4 but fell significantly from 4 to 3 and lower. In addition, a 5/6 21 year old is not necessarily better than a 4/6 17 year old for training in the short run. You also have to consider the expected future CL path (this is probably more important than the immediate effect of CL on EQ), and there is a fair amount of uncertainty involved (unless you wanted to create a distribution of EQ relative to potential CL paths). With all that said, I think it's better to have two separate columns for CL and EQ.

As for facilities, I think that each level is worth about, very roughly, .2 OR per day, with smaller increases for the lower levels below 12 or so.


lanky522


Yep... separate columns for everything is the plan. The eOR and EQ are just helpful "value summary" ratios that I'll add in for quick comparisons. Everything from facility levels (training and regen) to specific qualities and values are being accurately logged.

And yeah I think the CL effect on training is more of a logarithmic relationship.


lanky522

Oyyyyy. The EOR calc is sooooo freaking heavy. Google Sheets strains badly whenever I try to copy the formula (so it can be used for more than one player). The "limiting factor" of the EOR is what does it. There's not a quick/simple way to have that modeled in a spreadsheet.

I set it up so that there were 10 EOR and 10 EQ classifications: 1 for goalie, and 3 for backs, wings, and pivots (2-way, offensive, and defensive specialties). I might actually have to back that out to just 4... because the sheet keeps freezing on me.

... granted I could try closing some of the 80+ tabs I have open... but I figure this is a good stress test for the sheet anyways...


mmessner9


What if you dropped the 2-way's. If you look at the national team rosters of the previous champions, there don't seem to be many two way players.


lanky522


Okay... I'll try that for now...

Just to give you an idea... this a single EOR formula that I'm putting on google's servers to calculate for me... Multiply it times 10 (or 7 if I take out the 2-way categories), for every player LOL :

=if($P3/Ratios!C$3=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($P3*Ratios!C$3/Ratios!C$3)+($P3*Ratios!C$4/Ratios!C$3)+($P3*Ratios!C$5/Ratios!C$3)+($P3*Ratios!C$6/Ratios!C$3)+($P3*Ratios!C$7/Ratios!C$3)+($P3*Ratios!C$8/Ratios!C$3)+($P3*Ratios!C$9/Ratios!C$3))*(1+($AD3*Ratios!$C$12)),if($R3/Ratios!C$4=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($R3*Ratios!C$3/Ratios!C$4)+($R3*Ratios!C$4/Ratios!C$4)+($R3*Ratios!C$5/Ratios!C$4)+($R3*Ratios!C$6/Ratios!C$4)+($R3*Ratios!C$7/Ratios!C$4)+($R3*Ratios!C$8/Ratios!C$4)+($R3*Ratios!C$9/Ratios!C$4))*(1+($AD3*Ratios!$C$12)),if($T3/Ratios!C$5=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($T3*Ratios!C$3/Ratios!C$5)+($T3*Ratios!C$4/Ratios!C$5)+($T3*Ratios!C$5/Ratios!C$5)+($T3*Ratios!C$6/Ratios!C$5)+($T3*Ratios!C$7/Ratios!C$5)+($T3*Ratios!C$8/Ratios!C$5)+($T3*Ratios!C$9/Ratios!C$5))*(1+($AD3*Ratios!$C$12)),if($V3/Ratios!C$6=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($V3*Ratios!C$3/Ratios!C$6)+($V3*Ratios!C$4/Ratios!C$6)+($V3*Ratios!C$5/Ratios!C$6)+($V3*Ratios!C$6/Ratios!C$6)+($V3*Ratios!C$7/Ratios!C$6)+($V3*Ratios!C$8/Ratios!C$6)+($V3*Ratios!C$9/Ratios!C$6))*(1+($AD3*Ratios!$C$12)),if($X3/Ratios!C$7=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($X3*Ratios!C$3/Ratios!C$7)+($X3*Ratios!C$4/Ratios!C$7)+($X3*Ratios!C$5/Ratios!C$7)+($X3*Ratios!C$6/Ratios!C$7)+($X3*Ratios!C$7/Ratios!C$7)+($X3*Ratios!C$8/Ratios!C$7)+($X3*Ratios!C$9/Ratios!C$7))*(1+($AD3*Ratios!$C$12)),if($Z3/Ratios!C$8=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($Z3*Ratios!C$3/Ratios!C$8)+($Z3*Ratios!C$4/Ratios!C$8)+($Z3*Ratios!C$5/Ratios!C$8)+($Z3*Ratios!C$6/Ratios!C$8)+($Z3*Ratios!C$7/Ratios!C$8)+($Z3*Ratios!C$8/Ratios!C$8)+($Z3*Ratios!C$9/Ratios!C$8))*(1+($AD3*Ratios!$C$12)),if($AB3/Ratios!C$9=min($P3/Ratios!C$3,$R3/Ratios!C$4,$T3/Ratios!C$5,$V3/Ratios!C$6,$X3/Ratios!C$7,$Z3/Ratios!C$8,$AB3/Ratios!C$9),(($AB3*Ratios!C$3/Ratios!C$9)+($AB3*Ratios!C$4/Ratios!C$9)+($AB3*Ratios!C$5/Ratios!C$9)+($AB3*Ratios!C$6/Ratios!C$9)+($AB3*Ratios!C$7/Ratios!C$9)+($AB3*Ratios!C$8/Ratios!C$9)+($AB3*Ratios!C$9/Ratios!C$9))*(1+($AD3*Ratios!$C$12)),"?" )))))))


lanky522

... oh... my... god.

I feel like I'm in college again... and I didn't save my 20 page term paper... and my computer crashed.

I just ran one of the scripts in the sheet to make sure everything was working alright, completely forgetting that i had the "clearsheet" command in the script.

All the formulas that I did for EOR and EQ... gone. poof. Can't undo... can't revert. Fucking cloud.

I was freaking done with it. Now it'll take me several hours just to get back to where I was moments ago...

I guess that's what I get for working on this stuff while I'm at work and half distracted.

*sigh* ;(


Obryantj


Have you tried to restore using version history?

I believe it's Ctrl+Alt+Shift+G (or under the File menu) in Google sheets.

Edit: I'm assuming you have, but never hurts to check.


lanky522


You're a lifesaver, Obryantj. I had checked the version history... but after your post, I tried again and realized that there's a "show more detailed revisions" option under there.

The script alteration wasn't under the standard version history, but it was tucked away under the detailed one. Thank god. I don't have to recreate those damn formulas.

Now I'm just optimizing it a bit, making sure that the scripts don't wipe anything again, and then I'll be ready to release it for everyone to start importing their scouting info into it.


lanky522

Okay. I'm gonna post this here, mostly because this is where I've been talking about it (even though the youth teams aren't ready yet, and this really benefits the Senior National Team manager the most at this time.

The launch is finally ready. The private version of the sheet (for the national team manager) is still kind of buggy... but I think that's mostly because I scripted and built it in an older version of firefox, and regularly run with a ton (close to 100) tabs open. I'm hoping that it's not actually as twitchy for Mr. Brightside as it's been for me.

The player upload function and public version of the sheet works flawlessly (and pretty quickly too) from what I can tell though.

==============================
PM me, and I'll send a link for the public version of the sheet (where you can upload/import your scouted players).

I don't want to post it here or anywhere in the forums, because I don't want foreigners messing the sheet and/or the scripting up.
==============================

You shouldn't need a google/gmail/etc. account to import players. You should be able to do that

Some screenshots of what the National Team manager will be able to see:

oi57.tinypic.com/spvkva.j...

oi61.tinypic.com/59vq4o.j...

And here's a screenshots of what those of you who import players will be able to see:

oi58.tinypic.com/2ytsq34....


Mrbrightside098


Wow lanky, I appreciate the KA work man.


Usuario PRO Estados Unidos capsaicin


Is the code to extract the attributes and qualities for handball easily transferable for the other sports?


Mattssupersteelers


Holy crap. That is BIG!!


Camrawrn

Should we post youth players in here, too?

Donny Barclay
Leonard Ellis
Marshall Smalley


bfgaskill

Tahj Hatton


Mrbrightside098


Depwnds on wether they will be 21,20 or 19 or less



Temas favoritos
Eslovaquia I.1 (+1)
Italia I.1
Bosnia y Herzegovina koga bi vi
Bosnia y Herzegovina Veliki događa...
Bosnia y Herzegovina Sastanak BH Z...
Austria Tennis Duel -...
Bélgica financien
Bélgica Vanalles
Azerbaiyán PPM Translato...
Austria Facebook
Bosnia y Herzegovina Facebook
Austria 2. Mannschaft...
Austria Jerseys?
Azerbaiyán U-17 milli ko...
Bosnia y Herzegovina Sms krediti
Eslovaquia Kohutko Cup I...
Eslovaquia Gold Cup
Eslovaquia National Gree...
Eslovaquia V.168
Eslovaquia players for G...
Eslovaquia Pravidla (Ad ...
Eslovaquia 2 zapasy za d...
Eslovaquia Ligový pohár
Eslovaquia dresy a vlajk...
Eslovaquia National Germ...
Eslovaquia Voľby trénera...
Eslovaquia DB National I...
Eslovaquia PPZT:pred a p...
Eslovaquia F1
Eslovaquia tranfers
Australia New F1 manage...
Eslovaquia organizujem t...
Eslovaquia transfer
Eslovaquia Dresy
Eslovaquia VI.188
Eslovaquia VI.190
Eslovaquia VI.196
Eslovaquia VI.185
Eslovaquia VI.184
Eslovaquia VI.180
Eslovaquia VI.166
Eslovaquia VI.172
Eslovaquia VI.168
Eslovaquia VI.169
Eslovaquia VI.170
Eslovaquia VI.173
Eslovaquia VI.164
Eslovaquia VI.163
Eslovaquia VI.127
Eslovaquia V.85
Eslovaquia VI.111
Eslovaquia VI.72
Eslovaquia VI.109
Eslovaquia Futbalová Rep...
Eslovaquia V.253
Eslovaquia Slovakia Cup ...
Eslovaquia VI.113
Eslovaquia Esox lucius f...
Eslovaquia trgu - trensf...
Eslovaquia V.160
Eslovaquia Klubové vlajk...
Eslovaquia Vytvorenie kl...
Eslovaquia V.248
Eslovaquia VI.143
Eslovaquia VI.146
Eslovaquia V.170
Eslovaquia V.232
Eslovaquia Žilinska fotb...
Eslovaquia V.252
Eslovaquia V.255
Eslovaquia V.247
Eslovaquia VI.96
Eslovaquia V.223
Eslovaquia VI.9
Eslovaquia Kto ma najvac...
Eslovaquia V.230
Eslovaquia V.133
Eslovaquia VI.147
Eslovaquia V.184
Eslovaquia uspesnost str...
Eslovaquia VI.126
Eslovaquia VI.58
Eslovaquia VI.51
Bielorrusia "Клубная супе...
Eslovaquia V.158 tipovač...
Eslovaquia V.250
Eslovaquia VI.80
Eslovaquia mini champion...
Eslovaquia V.249
Eslovaquia V.229
Eslovaquia V.251
Eslovaquia Primera Divis...
Eslovaquia Tímový web
Eslovaquia VI.160
Eslovaquia Friendly Matc...
Eslovaquia VI.156
Eslovaquia Klubovy web
Eslovaquia V.127
Eslovaquia Futbalova Rep...
Eslovaquia Taktiky
Eslovaquia Tréning hráčo...
Eslovaquia SVK Repre - F...
Eslovaquia VI.145
Eslovaquia Stažnosti na ...
Eslovaquia VI.106
Eslovaquia futbal
Eslovaquia Design-logo-d...
Eslovaquia V.208
Eslovaquia V.189
Eslovaquia stadio
Eslovaquia VI.149
Eslovaquia VI.125
Eslovaquia VI.88
Eslovaquia V.176
Eslovaquia SILA TÍMU
Eslovaquia VI.103
Eslovaquia V.148
Eslovaquia super zápasy
Eslovaquia Ponuky generá...
Eslovaquia Slovenské Sup...
Eslovaquia V.148
Eslovaquia stavanie záze...
Eslovaquia Tipovacia súť...
Eslovaquia V.172
Eslovaquia pro evolution...
Eslovaquia Corgoň liga a...
Eslovaquia VI.138
Eslovaquia 2x zaspievaná...
Eslovaquia Tvorba Loga
Eslovaquia A.C.A.B. CUP
Eslovaquia Najlepší stre...
Eslovaquia Šlapak
Eslovaquia V.201
Eslovaquia VI.154
Eslovaquia VI.142
Eslovaquia Horna nitra C...
Eslovaquia VI.148
Eslovaquia VI.97
Eslovaquia VI.144
Eslovaquia Súťaž o 40 kr...
Eslovaquia VI.112
Eslovaquia MS vo Futbale...
Eslovaquia kupovanie zam...
Eslovaquia Hlasovanie - ...
Eslovaquia V.242
Eslovaquia Priatelsky du...
Eslovaquia ZAPASY PRIJMA...
Eslovaquia PPMliga-turna...
Eslovaquia Majstrovstvá ...
Eslovaquia V.178
Eslovaquia IV.24 Ligové ...
Eslovaquia VI.128
Eslovaquia VI.54
Eslovaquia Turnaj - UEFA...
Eslovaquia Turnaj - Prem...
Eslovaquia Liga majstrov
Eslovaquia VI.110
Eslovaquia V.146
Australia Last Letter -...
Eslovaquia V.256
Eslovaquia VI.114
Eslovaquia V.225
Eslovaquia VI.92
Eslovaquia V.246
Eslovaquia V.239
Eslovaquia V.237
Ultimos comentarios