Talk:Review Algorithm/1.4.4/@comment-9088222-20130504190243/@comment-62.65.221.70-20130507201546

Hi Again,

I Redownloaded the Excel sheet and I found a mistake. In the year modifier formula you need to change it from ">6" to ">=6" in the second period for years 6 to and including 22.

I also decided to add two separate rows Audience and platform as rows 12 and 13 respectively. For the Platform/Genre, Topic/Audience and Topic/Genre values I then created lookup formulas and added the sheets in the workbook by copypasting the values from the raw data page on this wikia. It removes 3 manual entries.

Since I cannot edit your sheet, please find the formulas here:

Platform/Genre

=IF(B10="Action",VLOOKUP(B13,'Platform-genre'!$A$1:$G$27,2,FALSE),IF(B10="Adventure",VLOOKUP(B13,'Platform-genre'!$A$1:$G$27,3,FALSE),IF(B10="RPG",VLOOKUP(B13,'Platform-genre'!$A$1:$G$27,4,FALSE),IF(B10="Simulation",VLOOKUP(B13,'Platform-genre'!$A$1:$G$27,5,FALSE),IF(B10="Strategy",VLOOKUP(B13,'Platform-genre'!$A$1:$G$27,6,FALSE),IF(B10="Casual",VLOOKUP(B13,'Platform-genre'!$A$1:$G$27,7,FALSE),"1"))))))

Topic/Audience

=IF(B12="Young",VLOOKUP(B9,'Topic-audience'!$A$1:$D$52,2,FALSE),IF(B12="Everyone",VLOOKUP(B9,'Topic-audience'!$A$1:$D$52,3,FALSE),IF(B12="Mature",VLOOKUP(B9,'Topic-audience'!$A$1:$D$52,4,FALSE),"1")))

Topic/Genre

=IF(B10="Action",VLOOKUP(B9,'Topic-genre'!$A$1:$G$52,2,FALSE),IF(B10="Adventure",VLOOKUP(B9,'Topic-genre'!$A$1:$G$52,3,FALSE),IF(B10="RPG",VLOOKUP(B9,'Topic-genre'!$A$1:$G$52,4,FALSE),IF(B10="Simulation",VLOOKUP(B9,'Topic-genre'!$A$1:$G$52,5,FALSE),IF(B10="Strategy",VLOOKUP(B9,'Topic-genre'!$A$1:$G$52,6,FALSE),IF(B10="Casual",VLOOKUP(B9,'Topic-genre'!$A$1:$G$52,7,FALSE),"1"))))))