Currently I have an Excel VBA that scans over a folder of excel files. It adds a template sheet to it that analyzes the data in the files. The files in the folder are all formatted the same. The VBA reads all the files in the folder. Then records the output in the VBA output tab. The conditions tested are variable. I need to convert this script to python and add some features to it. Currently it functions too slow so it isn’t practical to use for me. Some understanding of NBA is big for this project. It will make it easier to work on it and present miscommunication.
Here are the 3 mains tasks:
Task 1: Convert existing excel VBA into an effective python script.
Deliverable: Be able to access results in excel and have it run effectively through python at a faster pace than the excel VBA was working. It should be readable in excel though
Task 2: Add an option that allows me to study all teams at once
Deliverable: Be able to select “All teams” and output a DB page that allows me to study all teams under the inputted conditions
Task 3: Add a function that allows me to study the sample if the score is less than a certain number (separate than the greater than function)
Deliverable: Be able to output results accurately, as it did with the > score differential portion
31 freelancers are bidding on average $473 for this job
I have 7+ years in python - website design & development with very good experience. Relevant Skills and Experience I am good in Data Processing, Excel, Excel VBA, Python, Sports Proposed Milestones $500 USD - Cost
I am a python expert and i have work on similar kind of project in the past. You can check my profile review and my website [url removed, login to view] to see some of my work Stay tuned, I'm still working on this proposal.