Originally Posted by KaRLiToS
Does anyone know the excel (or google chart) formula to take the average FPS per each card. Lets say I want to make an average of all HD 7970 Crossfire in the All setup chart?
YES!! You totally just helped me waist time at work lol
I did this in Excel (hacking stuff I found online together with some I knew)
O1 = whatever cell is going to be the "search box" (i.e. Whatever i typed in Cell O1 is what searched for and the corresponding FPS average provided)
D:D = the column that contains the graphics cards names (i.e. HD 7970)
E:E = the column that contains the corresponding FPS average for the graphics card list
Disclaimer: This only will work provided that every entry on your tables are standardized (meaning the exact same string is used to describe all cards of identical nature).... OH and you have to use the decimal instead of a comma for numerical values (i did a find and replace when I copied your table data for testing)