BuzzerBeater Forums

https://docs.google.com/spreadsheet/ccc?key=0AlPYku57vYsjd...

This is an excel helper tool. It is very simple but helpful in some parts of the game. To download click File -> Download As.. -> Excel, or if you don't have excel, OpenOffice. Do not touch stuff in red, but yellow and green are usually fine.

If you have any feedback/suggestions feel free to post them here (keeping in mind that this is not connected to the BBAPI).

Josef Ka's PotentialCap
Uses Josef Ka's coeficients to tell you when your player has capped.

Is He Worth It?
Tells you whether your player is worth training or not. Currently only takes age and potential but I am working on adding skill level as well. (This tool is is quite accurate but is still being worked on to iron out any problems, please help by BB-Mailing your feedback.)

Squad Sorter
Makes your squad a lot easier to sort.

Opponent Comparer
Helps compare your team to your opponents. Not much here yet but I will add more in later versions. (This tool is inacurate but I am working on making it better.)

Average Arenas
Tells you with how big your arena is compared to other teams in your division. (Currently having trouble expanding this area, will keep you up to date :-). )

Version 1.5
- Is He Worth It is much more accurate.
- Fixed a couple of mistakes.
- Cleared out things that werent working.

Version 1.3
- Average Arenas is released, only 8 countries are shown right now but more will be added in later editions.
- Squad sorter mistakes are fixed.

Version 1.2
- Josef Ka's salary predictor has been added.
- More stuff has been added in the Opponent Comparer.
- A couple of minor mistakes have been fixed.
- Other minor stuff.

Version 1.13
- Is he worth it has been majorly improved, thanks for all the feedback!
- A note in Is he worth it has been added to avoid confusion.

Version 1.1
- Help Boxes have been added to every page. They are in orange.
- A new page that helps you compare your team to your opponents has been added. (See more above)

More updates to come!

Last edited by Ralph54 at 10/19/2012 10:36:38 PM

+1 for the effort!

I'll test it and let you know.

PotentialCap - divide result by 2 and subtract 4 - and You can delete all rows from 17 to 30.

PotentialCap - divide result by 2 and subtract 4 - and You can delete all rows from 17 to 30.

Thanks bro. +1 for the help.

Last edited by Ralph54 at 12/5/2011 1:40:09 PM

Hey Ralph can you give me some more details in how to use this thing?

Hey bro, I'm adding an instructions thing on each page in the next version, should be out tonight. :)

Sweet, keep me posted with a link Ralph.

https://docs.google.com/spreadsheet/ccc?key=0AlPYku57vYsjd...

Version 1.1 is now out. Updates in the first post.

Hey sorry guys, just realised I had the new version on private, it is on public now. Sorry for the inconvenience.

I would love to have 2 helpers to help me with this next project. What I need you to do is get the arena capacity averages in each league. If you would like to help reply here. Cheers!

If all you need is capacity then I can make a simple code to connect to bbapi and gather that information from as many teams as you want.

http://code.google.com/p/bb-assistant/ - here's a program/library I'm working on. At the beginning I was writting it in C++, but changed my mind and switched to Python (it's easy and you can extend code to your own needs).