IPL fantasy
I created project in the excel to play IPL fantasy in office which does calculations for all the runs scored, wickets taken, dot balls everything and stores in a master excel sheet. The slave excel sheet maintains the various teams, using Vlookup formula I copy the values from master sheet to slave sheets and used various mathematical formulas for calculation. Had also used Pivot tables and generated charts, graphs with leading teams, batsman, bowlers etc. I can't attach .xls file else would have shown here. I am attaching screen shot of one of the team and overall charts and graphs for your perusal. One question I would have is you mentioned 220 PDF files, that means how many pages ? I mean 1 pdf file contains how many pages to be coverted into Word