Page 1 of 1

Contract Calculator

Posted: Sat Jan 28, 2017 10:26 pm
by Capital Gains
How do you paste a players stats to see on how much a player would re-sign for?

Re: Contract Calculator

Posted: Sun Jan 29, 2017 2:04 am
by Calgary.Flames
Go all the way down to lines 700+... You can edit those.

Re: Contract Calculator

Posted: Sun Jan 29, 2017 2:55 am
by Vik (Habs)
If the problem is with getting POT and greed, there's a trick to get all of the numbers you need...
http://www.ehechockey.com/ufa.php?pending=-1

That lists every player in the file so you'll have to search for the specific guy you want (Ctrl+F is a good friend) but it lists everything the way the calculator likes it.

Re: Contract Calculator

Posted: Sun Jan 29, 2017 1:35 pm
by Capital Gains
Calgary.Flames wrote:Go all the way down to lines 700+... You can edit those.
What I'm saying is that if I try and copy and paste like you normally would, it doesn't allow me to do so. Is there a special way of copying and pasting for the spreadsheet?

Re: Contract Calculator

Posted: Sun Jan 29, 2017 1:40 pm
by Dallas Stars GM
Ctrl+C to copy and Ctrl+V to paste

Re: Contract Calculator

Posted: Mon Jan 30, 2017 12:10 am
by Capital Gains
Dallas Stars GM wrote:Ctrl+C to copy and Ctrl+V to paste
Thanks, I'll try that.

Re: Contract Calculator

Posted: Mon Jan 30, 2017 12:16 am
by Capital Gains
Dallas Stars GM wrote:Ctrl+C to copy and Ctrl+V to paste
I tried doing that and it made everything go up and down and not across.

Re: Contract Calculator

Posted: Mon Jan 30, 2017 12:22 am
by Calgary.Flames
I copy/pasted your team starting on line 700. Do you see that?

https://docs.google.com/spreadsheets/d/ ... d=63361058

Re: Contract Calculator

Posted: Mon Jan 30, 2017 10:22 am
by flyergp21
HEY CAPITAL GAINS!!

I think you may have a case of a full recipient with your PMs. You need to delete some to be able to receive the new ones..

Just sayin..Not even sure that's the case, but it seems like it. ;)

Re: Contract Calculator

Posted: Tue Jan 31, 2017 2:21 pm
by Capital Gains
Calgary.Flames wrote:I copy/pasted your team starting on line 700. Do you see that?

https://docs.google.com/spreadsheets/d/ ... d=63361058
Thank you for doing that, but how did you do it?

Re: Contract Calculator

Posted: Tue Jan 31, 2017 2:39 pm
by Calgary.Flames
Nothing but copy/paste from the website.

Can you manually edit those lines?

Re: Contract Calculator

Posted: Sat Feb 11, 2017 10:51 pm
by Capital Gains
I see the new base dollar amount, but what do the bonuses mean after that? Are those suppose to be added/subtracted with the new base amount?