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!!!