PY SCRIPT for XLSX File or CSV file - ADD TOTALS

Job ID: 39246027

Budget: $10 – $30 USD

I need a Windows PY script to add totals to each section of an XLSX file. Optionally this can be for a CSV file as I can easily convert the files. I need a PY Windows script so I can run a few files myself every day.

Steps

1. Fill one extra row for each player (See Row 11, 19, 33 etc)

2. Add the Total of each player section for Rows S, T , U, V, W (See Row 11, 19, 33 etc)

3. Add the Total of each o and u for eachplayer section for Rows X and Y (See Row 11, 19, 33 etc)

* Simply use the Date in Column A to separate each player section

*The due date is 4 hours from accepting this job. I have a lot more work for the right coder.

Before and After file attached
Related categories: Python Windows Desktop Excel