Freelancer: rohitsinghvi
Report Entry

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

                                                                                                            Contest Entry #                                        2
                                     for                                         Very difficult work - DATA ENTRY - FILL Spreadsheet With Data

Public Clarification Board

  • johnsmithjs
    Contest Holder
    • 5 years ago

    How many hours you will take to complete?

    • 5 years ago
    1. rohitsinghvi
      • 5 years ago

      that depends on the size of the work, you have mentioned 220 pdf files, how many pages are there in those files. The sample with which I have entered in contest was created in 30 mins

      • 5 years ago