BuzzerBeater Forums

The spreadsheet didnt open up as an OpenOffice document but it opened as a tab on the internet. I use the latest version of IE. The tab showed the bottom half of the document but I couldnt scroll up. I could still switch between the sheets using the bottom tabs, but I can still only see the bottom half.

Hi! I really love the job you did on this tool - it looks and works GREAT. The only problem i think i found so far in version 1.0.2 is that:

Sheet TrainerParrot, the 3 tables in training comparison (+Logscore, +Salary and Rel. Cost) seem to have wrong formulas in them, in all meaningful fields of these tables I see ###, which is an Excel exception (I use Excel 2007). For example, let's take Training group 1 for Logscore table.

The cell I32 (training group 1) has the following formula in it: =IF($A32<>I$30;"";SUMPRODUCT(OFFSET($U$10;0;ROW()-ROW($A$32)):OFFSET($U$27;0;ROW()-ROW($A$32));I$65:I$82)), which is populated into every cell of this row (only the numbres of cells and rows changed respectively where allowed) and into the rest of the rows of this table.
The cell F33 (training group 2) has the following formula in it: =IF($A33<>B$30;"";SUMMPRODUCT(OFFSET($U$10;0;ROW()-ROW($A$32)):OFFSET($U$27;0;ROW()-ROW($A$32));B$65:B$82)), so even as we are calculating values for the training group 2, we take values from column U, where there are values set by manager for training group 1.

So I suggest, that correct formulas should look like:
=IF($A32<>I$30;"";SUMPRODUCT(OFFSET($U$10;0;ROW()-ROW($A32)):OFFSET($U$27;0;ROW()-ROW($A32));I$65:I$82))
and
=IF($A33<>B$30;"";SUMMPRODUCT(OFFSET($V$10;0;ROW()-ROW($A33)):OFFSET($V$27;0;ROW()-ROW($A33));B$65:B$82))
First we should change the letters of columns for respective training type and remove char "$" before the number from ROW() functions for correct populating into below. I corrected my spreadsheet according to that and everything works just fine. Though probably, i just downloaded incorrect version and it is completely my misunderstanding.

Hope what i wrote above makes sence - i'm not a native english speaker. If you find this comment useful, please BB-Mail me so i could probably explain more clearly what i mean.

And again - thanks for the great job you did on this tool, it really rocks!!!

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. :)