BuzzerBeater Forums

BB Global (English) > coachParrot - assistant tool

coachParrot - assistant tool

Set priority
Show messages by
From: BarbAsh

This Post:
00
119279.88 in reply to 119279.87
Date: 12/16/2009 11:07:10 AM
Overall Posts Rated:
00
OK, good thing that it's not a common problem and that you are aware of it - that was the reason I posted the message, just in case :)

Thanks for the way of fixing it (didn't work in my case though - I guess some Excell problem or something), but I've fixed the problem for myself anyway and it works just fine - really helpful and supportive tool. Maybe someone else will find our last messages useful. :)

Thanks again for the great tool. Cheers. :)

This Post:
00
119279.89 in reply to 119279.87
Date: 12/16/2009 7:46:55 PM
Overall Posts Rated:
00
For those who are completely unaware of how to properly copy+paste formulas (like me 10mins ago lol), simply copy the formula in b32 through clipboard>copy and paste the formula to b32:ae41 using clipboard>paste special>formulas. everything should work now.

rinse and repeat for b42 and b52. i hope this guides clueless excel users :)

This Post:
00
119279.90 in reply to 119279.87
Date: 12/17/2009 3:18:25 PM
Overall Posts Rated:
00

actually you can repair the Excel version manually, but I didn't dare describing this work-around publicly because it will frighten many people off: 1.) go to the cell b32; 2.) change any number in the formula and press Enter; 3.) change the number back to the original value and press Enter; now it works; 4.) copy the formula in b32 to all cells of the range b32:ae41 - then repeat steps 1-4 for b42 and b52.


The problem is related to the matrix formulas used. In excel you have to press ctrl+shift+enter so that the formula has the { } at begin and end and then excel can finally recognize it as a matrix.

I just finished toying with your tool and it seems really good. I'm now playing a bit with the training sheet.. if I understand everything correctly the program calculates the increase in performance (called logscore) depending on the tactics played (distribution entered in my data) of every single pop in a given skill.
What I don't understand, for example, is why your tool thinks that every one of my trainees need lots of JR. Or why it prefers a training which gives me a couple more pops but a much more unbalanced and with an higher wage player

This Post:
00
119279.92 in reply to 119279.91
Date: 12/17/2009 4:41:36 PM
Overall Posts Rated:
00
The problem is related to the matrix formulas used.
these are not matrix formulas. it is a conversion error that corrupts the file.


Sumproduct is the sum between the products of the elements of a matrix, at least in my excel file.
If you correct a cell with ctrl+shift+enter, than copy that cell and paste special (formulas) everything is then fine, at least in my file

I'm going to give your training a try, it is pretty close to what I had in mind (with some more JS from my point of view, indeed).


This Post:
00
119279.93 in reply to 119279.1
Date: 2/17/2010 3:39:32 PM
Overall Posts Rated:
00
I'm having trouble cutting and pasting from the Set Lineup page. It either puts it in one cell or seperates the name into two columns. Any suggestions?

No matter where you go, there you are.
This Post:
00
119279.95 in reply to 119279.94
Date: 2/21/2010 1:59:54 PM
Overall Posts Rated:
00
I use IE. The normal paste was splitting the name and I don't know why. I might just try Firefox and doing a paste special since I do have it on my computer. Thanks.

No matter where you go, there you are.
This Post:
00
119279.96 in reply to 119279.95
Date: 3/2/2010 4:16:05 AM
Overall Posts Rated:
170170
Thank you for very nice and useful program!
I wanted to ask over your thoughts on effort's impact on ratings. I believed that effort does not have any significant (maybe even zero) effect on team ratings but checking some games in CP I get with TIE in BB approx. one level lower defenses and rebounding ratings. This might also be due to enthusiasm and skills' sublevels but it would be nice to hear your latest opinion on this: does effort have impact on TR's? How does CT/TIE impact team play overall compared to raitings?

Advertisement