
Closed
Posted
Paid on delivery
I need an automated workflow that pulls mixed text-and-number records from our Winomkar Excel workbooks, processes them, and returns clean, ready-to-use sheets without any manual touch-ups. The script (whether built in Python, VBA, Power Query, or another reliable tool you prefer) must open the source files, carry out the required data operations, and then save or export refreshed results in the same folder structure. Please make sure the automation: • Sorts rows according to the parameters I can define at run time • Filters data on multiple columns with dynamic criteria • Performs built-in or custom calculations as specified in a config section • Copies results to designated summary sheets • Validates every entry against simple rules I will provide (e.g., mandatory fields, data type checks) • Generates a concise report summarising any errors or outliers it found A clear, well-commented codebase, brief setup instructions, and one example run on my sample files will be considered acceptance criteria.
Project ID: 40703326
28 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
28 freelancers are bidding on average ₹1,364 INR for this job

You need an automated Excel workflow that reads messy mixed-text-and-number records, applies runtime-defined sorting/filtering/validation/calculations, and outputs clean sheets with error reports—no manual touch-ups. I've built data pipelines like this (Marin Software: real-time data processing; Poundit: backend systems handling complex transformations). Approach: I'll build a Python script that: Opens your Excel files (openpyxl or pandas, your choice) Reads a config section (sort rules, filter criteria, calculation specs, validation rules) Processes each record: sort → filter → validate → calculate → deduplicate Generates an error/outlier report (mandatory field checks, type mismatches, failed calculations) Exports clean results to designated summary sheets Logs everything so you can debug Why Python over VBA? Cleaner, easier to maintain, and handles complex data operations without the VBA headaches. Deliverables: production-ready code (well-commented), setup instructions (install dependencies, configure paths), and a full example run on your sample files showing input → processing → output + error report. Quick question: Do you have sample files and a config format in mind, or should I propose a YAML/JSON structure for defining sort/filter/calc rules?
₹5,000 INR in 3 days
5.2
5.2

Hi there, As the CEO of the quality-driven agency Aesthetic Logic and a seasoned professional in automation, data analytics, and software architecture, partnering with us to automate your Winomkar Excel data processes is an opportunity you don't want to miss. With 96% on-time project delivery and over 55 successful projects under our belt, we've proven our expertise in creating streamlined and efficient solutions, tailored to meet unique client needs. Our specialization in using Python for data manipulation and Excel operations aligns perfectly with your requirements. We pride ourselves on crafting clean codebases that are easily understood, through thorough commenting, detailed instructions, and regularly checking in with you throughout the project timeline. By leveraging this knowledge combined with your specific parameters, we can build an automated workflow that sorts rows dynamically, filters data based on multiple conditions, performs custom calculations, copies results onto summary sheets, validates entries against rules you set and generates error reports. Best regards, Mobasher Reza
₹1,050 INR in 3 days
4.9
4.9

Automating the extraction, cleaning, and consolidation of your Excel workbooks will completely eliminate manual adjustments through a robust script—written in Python (using pandas and openpyxl) or VBA, depending on your on-premise infrastructure preference. I will design the solution with an intuitive configuration file, allowing you to define dynamic filtering criteria, row sorting, and custom calculation formulas at runtime without modifying the codebase. The workflow will include a strict validation engine for mandatory fields and data types, automatically generating clean summary sheets within the same folder structure, alongside a concise log of detected errors and outliers. I will deliver clean, extensively documented source code, a step-by-step user guide, and a demonstration using your sample files within an estimated timeframe of 3 to 5 days. Please send me a test file along with the validation rules so I can review the data structure and get started immediately.
₹2,000 INR in 7 days
4.8
4.8

Hi, Which Excel operations and validation rules do you want included in the initial config? I would build this as a Python-based automation that opens the Winomkar Excel workbooks, applies runtime sorting and multi-column filtering, performs configurable calculations, validates the records, and exports the cleaned results into the required folder structure. I would keep the processing rules in a clear configuration section so sorting parameters, filter criteria, calculations, mandatory fields, and data-type checks can be changed without rewriting the core script. The workflow would also copy processed results to designated summary sheets and generate a concise error/outlier report after each run. I can start ASAP and also share relevant Python, Excel automation, data processing, and reporting projects from my portfolio. Best regards, Akif S
₹1,400 INR in 5 days
1.6
1.6

Hello, I’m interested in building this Excel data-processing automation. I have 2+ years of experience in Data Analysis with hands-on experience in Python, Excel, Power Query, data cleaning, validation, transformation, and reporting. I can build a practical and maintainable workflow that minimizes manual intervention and produces clean, ready-to-use Excel outputs. Based on your requirements, I can implement: • Read and process your Winomkar Excel workbooks • Runtime-configurable sorting and multi-column filtering • Config-driven calculations and transformations • Copy processed results into designated summary sheets • Validate mandatory fields, data types, missing/invalid values, and other rules • Generate a concise error/outlier report • Preserve the required folder structure for output files • Provide clean, well-commented code and setup instructions • Test the workflow on your sample files and demonstrate one complete run I would prefer Python with appropriate Excel libraries where it provides better flexibility and maintainability, but I can also work with Power Query/VBA if that is more suitable for your existing workbook environment. My focus will be on making the workflow reliable, easy to rerun, and simple to modify when your filtering, calculation, or validation rules change. I can start by reviewing your sample workbook and requirements, then propose the most suitable implementation approach. Thank you. K. Gowri
₹1,500 INR in 2 days
1.7
1.7

Hi, I can build an automated, script-based workflow in Python or VBA to process your Winomkar Excel workbooks and export clean, validated summary sheets. Excel process automation, Python/Power Query data transformation, and VBA scripting are my primary skills, specializing in dynamic row sorting, multi-column filtering, rule validation, and error reporting. I will write a well-commented automation script that opens your source workbooks, applies your runtime sorting and multi-criteria filters, runs target calculations via a config file, validates data integrity, and generates a clean summary sheet alongside an error audit log. I have engineered numerous automated Excel data processing workflows and batch transformation scripts designed for zero manual touch-ups. Message me in the chat so we can review your sample files and rule requirements.
₹1,500 INR in 2 days
2.6
2.6

As a leading technology firm with a deep specialization in Data Processing and Python, we are the best fit for your Winomkar Excel Data Automation project. With over three years of robust experience transforming business workflows, we fully understand your needs. We have successfully built numerous data automation solutions that align with your requirements to accommodate your unique sorting, filters, calculations, copying, validating, and reporting needs. Our expertise extends to leveraging modern cloud-native technologies such as AWS, Microsoft Azure, Docker, and Jenkins for efficient data management and replication. This means not only can we process and store your data accurately but also replicate (if required) it swiftly to generate error-free reports and concise data sets for enhanced decision making. We are Neuravolt - the perfect blend of technology competence and collaborative approach. By choosing us for your Winomkar Excel Data Automation project, you opt for much more than merely processing data; you receive a long-term technology partner committed to delivering measurable business value through scalable, secure, and high-performing digital solutions. With us on board, be prepared to harness the true potential of streamlined automated workflows that deliver accurate ready-to-use sheets without any manual touch-ups. Choose Neuravolt Technology; choose exceptional quality and transformative growth.
₹1,200 INR in 1 day
1.2
1.2

With an extensive background in full stack development and automation, I am your ideal candidate for the Winomkar Excel Data Automation project. Over my 5+ years of experience, I have crafted a multitude of scripts utilizing Python, VBA, Power Query, and more to bring Excel data to life. With your need to sort rows, filter data, perform calculations, add mandatory field checks and generate summary sheets with error reports at the helm of the project description - my specialized skills are an impeccable match. My focus on robustness has led to a coding style with clear commenting and well-tested functionalities, which guarantees a concise codebase for this project. Moreover, as an AI Agent Specialist with fluency in Python, I can meticulously develop a solution that aligns with your dynamic requirements and outputs the desired results effortlessly. My past projects involving data extraction from various sources will vouch for my ability to work with your specific Winomkar Excel workbooks. In addition to the technical prowess I offer as your freelancer of choice, I'm also committed to open communication and reliable support through all stages - from setup instructions to final deployment. Let my efficiency-driven mindset automate repetitive tasks, reduce manual touch-ups in your workflow and improve overall efficiency for a transformed data process you can rely on. Let's transform the way you handle data!
₹1,050 INR in 7 days
1.0
1.0

Hi, this maps well onto a Python/openpyxl (or pandas) workflow: read the source workbooks, apply your configurable sort/filter rules across multiple columns, run the calculations and validation checks you specify, write results to the summary sheets, and generate an error/outlier report — all re-runnable against new files without manual touch-ups. I'll hand over well-commented code, short setup instructions, and run it once on your sample files as proof before final delivery. Could you share a sample workbook and the exact validation rules so I can confirm the config format upfront?
₹650 INR in 4 days
0.0
0.0

Hi there, hope youre good I read through your requirements and I can build a clean, automated Python script using Pandas and OpenPyXL to process your Winomkar Excel workbooks seamlessly. Here is how I will structure the automation: Dynamic Filtering & Sorting: I'll set up a simple config section where you can easily define your sorting rules and multi-column filter criteria at runtime. Calculations & Data Validation: The script will handle your custom calculations, verify data types, check for required fields, and flag any missing or invalid entries. Summary Sheets & Error Logs: Validated results will be copied into your designated summary sheets, and a concise summary report will outline any errors or outliers found during processing. Folder Structure & Delivery: Cleaned output files will save automatically directly back into your existing folder hierarchy. I’ll provide clear, well-commented code, a quick setup guide, and a test run on your sample files to make sure everything works smoothly. Feel free to attach a sample file in chat so we can get started as soon
₹1,100 INR in 2 days
0.0
0.0

I have experience with Python automation for Excel data workflows. I will build a script that opens Winomkar workbooks, sorts and filters rows using runtime parameters, runs configurable calculations, copies results to summary sheets, validates entries against your rules, and generates an error report. Code will be clean, well-commented, with setup instructions and a sample run on your files.
₹1,500 INR in 4 days
0.0
0.0

A configuration-driven Python script fits this brief: keep the column mapping and rules in one config file, validate inputs first, then write cleaned results and a separate error report without overwriting your originals. For INR1,500, I can build an initial version for one consistent XLSX layout, up to three workbooks/5,000 rows total, configurable sort keys and multi-column filters, up to two agreed arithmetic calculations, required-field/type checks and one summary sheet. It includes commented code, setup notes and one example run on your supplied samples. Mixed workbook layouts, VBA/macros, a GUI, hosting and an unrestricted formula engine are outside this quote. Proposed delivery is 3 business days after I review the sample files, confirm the rules and AI/confidentiality permission, and receive a funded milestone. One correction round for implementation errors is included within 2 business days of feedback. Code is AI-assisted and tested against the agreed rules. Please share one representative workbook and the exact calculation/validation rules before award so I can confirm that this initial scope covers your priority workflow.
₹1,500 INR in 7 days
0.0
0.0

Hi, I’m an experienced Excel and Python automation professional with strong expertise in data processing, Excel automation, VBA, Power Query, data validation and workflow automation. I can build the complete Winomark Excel Data Automation workflow as described, including: • Runtime-based filtering and sorting • Multiple-column conditions and dynamic parameters • Data validation and mandatory field checks • Duplicate/error detection and exception reporting • Automated Excel data processing using Python • Clean, well-structured and commented code • Setup instructions and sample-file testing I focus on building reliable and user-friendly automation that reduces manual work and can be reused easily with future files. I can start immediately and deliver the complete solution within 3 days. Looking forward to working with you.
₹1,200 INR in 3 days
0.0
0.0

Your sorting, filtering and validation should all use one editable configuration, so you can change the next run without changing the Python code. I would keep the original workbooks intact, process matching .xlsx files in a batch, and save refreshed results plus a short error report in a separate output folder that mirrors the source structure. The configuration would define sort columns, multi-column filters, calculations, required fields and data types. Invalid entries would be reported with the workbook, sheet and row number so you can trace each issue; accepted rows would populate the agreed summary sheet. For ₹1,500, my scope is one agreed workbook layout, up to 10,000 rows per file, three calculation rules and one summary-sheet layout, with one revision. You receive commented Python source, setup/run instructions and an example run against your sample files. Delivery is within two days after the sample, rules and funded milestone are ready. I use AI-assisted development and verify outputs with explicit checks. A personal sample of my spreadsheet work, using 10,000 synthetic records, is here: https://www.freelancer.com/portfolio-items/11577307-call-routing-10-000-record-sample Could you share an anonymized sample workbook and the expected summary, including the calculation and validation rules, so we can confirm this scope before award?
₹1,500 INR in 2 days
0.0
0.0

Hii, I can build a repeatable automation that opens your Winomkar Excel workbooks, processes mixed text‑and‑number records, and returns clean, ready‑to‑use sheets without manual touch‑ups. I’ll implement sorting, multi‑column filtering, configurable calculations, summary sheet outputs, validation rules, and an error/outlier report using a robust Excel/Power Query–based workflow, so the logic is transparent, maintainable, and easy to adjust. My background includes advanced Excel and Google Sheets, Power Query–driven data transformation, business operations, sales and stock analysis, inventory reporting, and accuracy‑focused data cleaning and dashboard building. Additionally, my husband has delivered automation and data‑processing projects for US clients, which strengthens our ability to provide a clear, well‑commented solution, setup instructions, and a successful example run on your sample files. Once the automation processes your files and produces clean sheets that meet your acceptance criteria, the project is complete and ready for ongoing use. Thank you Geetanjali Rani
₹600 INR in 2 days
0.0
0.0

Hello, I can build this as a clear Python workflow using pandas and openpyxl. The script will process the supplied Winomkar workbooks, apply configuration-driven sorting, multi-column filters, calculations, validation rules, and write refreshed results and an error report into the required folder structure. I will include commented source code, a simple config section, setup instructions, and one verified example run. This bid covers the first agreed workbook format and validation rule set; after reviewing your sample files I will identify any format exceptions before development begins.
₹700 INR in 3 days
0.0
0.0

Hi - I'll build a Python or Power Query automation for one sample workbook: open the file, apply configurable sorting, filtering, and calculations, generate a summary sheet, flag outliers or errors, and include setup notes plus an example run. Please share the sample workbook and your desired config so I can confirm the exact layout before I start. Additional workbook layouts would be scoped separately.
₹1,300 INR in 3 days
0.0
0.0

Hi, I can build a local Python workflow for your Excel files, with the sorting, multi-column filters, calculations and validation rules kept in a readable configuration file. The workflow would write results into the agreed summary sheets and folder structure, keep the original source files intact, and produce a concise error report identifying the workbook, sheet, row and failed rule. I would include commented source code, setup instructions and a demonstrated run on your sample files. Before starting, please share a non-sensitive sample workbook, an example of the desired output, and your calculation/validation rules. Are all source workbooks in the same layout, and do any contain macros or formulas that must be preserved? Please also confirm your operating system and typical number of files and rows. My proposed first scope is one agreed workbook layout and its specified rules, for INR 1,500, delivered within three days after we confirm the sample and requirements and fund the milestone. Any additional layouts or integrations would be agreed separately.
₹1,500 INR in 3 days
0.0
0.0

Hi — you want Winomkar Excel workbooks sorted, filtered, calculated and written back cleanly without manual cleanup. I’m a solo AU developer. I can use Python (pandas/openpyxl) or Power Query/VBA if you prefer staying inside Excel. I’ll keep the rules config-driven so sort/filter criteria can change without editing code. Milestone 1: run the workflow on 1 anonymised sample workbook and return the cleaned sheet (₹400). Milestone 2: folder batch, validation checks and a short how-to (₹600). I’ll keep scope to the listed sort/filter/calc/export operations rather than overbuilding a full platform. Please attach one sample file and the exact rules; I can confirm fit within a day. — northstack_dev
₹1,000 INR in 2 days
0.0
0.0

I can provide a small Python workflow with a readable configuration file for sort keys, multi-column filters, required fields, types and agreed calculations. It will preserve the input files, write results under a separate output folder with matching relative paths, and create a concise validation report. Tests will verify sorting, filter inclusion/exclusion, calculated values and row accounting, including deliberate invalid-input cases. To keep this within your budget, the bid covers one consistent XLSX table schema, up to five source files and three simple calculation rules, with one summary output and no GUI or external integrations. Please share a sample workbook and the exact rules before award. Delivery includes commented source, setup instructions, one sample run and one correction round, within three days of confirmed scope.
₹1,500 INR in 3 days
0.0
0.0

Malegaon, India
Member since Aug 28, 2026
₹600-1500 INR
₹12500-37500 INR
₹12500-37500 INR
₹750-1250 INR / hour
£250-750 GBP
$10-30 USD
$250-750 USD
₹750-1250 INR / hour
₹12500-37500 INR
$15-25 AUD / hour
₹750-1250 INR / hour
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
$8-15 USD / hour
$15-25 USD / hour
min ₹5000000 INR
$10-30 USD