Excel Master File Division Using Python
Budget: $250 – $750 USD
Title:
Python Script to Split Excel Master File by Client with Formatting
Description:
I am looking for a skilled Python developer to create a small, reusable script that processes a master Excel file containing all client data. The script should:
Read the master workbook (.xls)
Extract the total cost column and perform basic calculations
Split rows so each client gets their own subset of data
Save each subset as a separate Microsoft Excel 97-2003 (.xls) file
Preserve conditional formatting and any cell-level number/date formats
Requirements:
Use Python with libraries like pandas and xlwt/xlrd or any library that supports .xls formatting
Clean, well-commented, and maintainable code
Command-line executable on Windows
Include a short README and one sample output file for verification
This project is ideal for someone experienced in Excel automation and Python scripting, capable of delivering high-quality and reliable scripts.
Estimated Duration: 3–5 days
Payment: $100–$200 (depending on experience and quality)
Python Script to Split Excel Master File by Client with Formatting
Description:
I am looking for a skilled Python developer to create a small, reusable script that processes a master Excel file containing all client data. The script should:
Read the master workbook (.xls)
Extract the total cost column and perform basic calculations
Split rows so each client gets their own subset of data
Save each subset as a separate Microsoft Excel 97-2003 (.xls) file
Preserve conditional formatting and any cell-level number/date formats
Requirements:
Use Python with libraries like pandas and xlwt/xlrd or any library that supports .xls formatting
Clean, well-commented, and maintainable code
Command-line executable on Windows
Include a short README and one sample output file for verification
This project is ideal for someone experienced in Excel automation and Python scripting, capable of delivering high-quality and reliable scripts.
Estimated Duration: 3–5 days
Payment: $100–$200 (depending on experience and quality)