Em Andamento

Convert Excel VBA to Python

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

Habilidades: Processamento de dados, Excel, Excel VBA, Python, Esportes

Ver mais: run macro in python, python to vba translator, python vs vba excel, py2vba, python to vba converter, vbscript to python converter, export vba to python, openpyxl run macro, convert excel vba open office, convert excel vba html, convert excel vba openoffice basic, convert excel vba project access, convert excel vba openoffice, convert excel vba open office calc, convert excel formulas python

Acerca do Empregador:
( 14 comentários ) Edmonton, Canada

ID do Projeto: #15381551

Premiar a:

aarifakhtar

Hi: I can convert the Excel VBA program to Python program. This will certainly improve speeds. Please share the VBA script, the sample input file and the output/analysis files for my review. Relevant Skills and Experi Mais

$250 USD em 5 dias
(152 Avaliações)
6.9

31 freelancers are bidding on average $473 for this job

Vlzinch

Hi,kajkyle! I work with both VBA and python for last 7 years, and sure i can help you. Relevant Skills and Experience 7 years of relevant experience Proposed Milestones $789 USD - Milestone Please send me excel fil Mais

$789 USD in 10 dias
(50 Comentários)
6.8
bytessolution

A proposal has not yet been provided

$400 USD in 4 dias
(118 Comentários)
5.9
$526 USD in 10 dias
(37 Comentários)
5.8
hunmin888

Hi, sir! I have a close look to your project. I have a good skill in python and vba. If you award this project to me, we'll complete it in time. Our budget may be negotiable Thanks Relevant Skills and Experience Hi, Mais

$555 USD in 10 dias
(22 Comentários)
5.7
$555 USD in 10 dias
(19 Comentários)
5.8
furqanorpiv

Hi, I am a CERTIFIED VBA, Python, WEB SCRAPPING EXPERT . I can provide you Quality data by Converting existing Excel VBA into an effective python script that allows you study all teams at once Relevant Skills and Mais

$250 USD em 1 dia
(40 Comentários)
6.0
sonarkaushik

I can convert your current excel vba to python as per ur requirement

$250 USD in 3 dias
(49 Comentários)
5.8
ThanassisKalv

Seems straightforward coding with Python, of course I would like to get a better insight into the base-script, however I expect it to be a work of a couple of days Relevant Skills and Experience handy with Python prog Mais

$277 USD in 3 dias
(41 Comentários)
5.1
$555 USD in 10 dias
(6 Comentários)
4.7
hawkscodeaus

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

$500 USD in 7 dias
(2 Comentários)
4.9
ykStudios

Convert existing excel macro to python script. Add functionality - study all teams at once - output a DB page (please clarify) - filter by specific function Relevant Skills and Experience Over 10 years commercial pyt Mais

$444 USD in 10 dias
(7 Comentários)
4.6
kepler452tech

Hi, thanks for your interest. I've a lot of experience with data processing using Excel VBA / Python and i can help you with this project. It will be my great pleasure if you contact me. Thank you! Relevant Skills an Mais

$250 USD in 3 dias
(9 Comentários)
3.8
abhi98041

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.

$250 USD in 10 dias
(19 Comentários)
4.0
AhmedHassan1122

Excel VBA and Python Expert Relevant Skills and Experience Excel VBA and Python Expert Proposed Milestones $444 USD - Full Price

$444 USD in 5 dias
(10 Comentários)
3.3
tonnyKlein

I am a professional Python/Excel VBA programming expert. I have 6 years of experience designing and developing Excel spreadsheets filled with formulas and VBA code. Relevant Skills and Experience I'm excellent in exe Mais

$530 USD in 7 dias
(13 Comentários)
3.6
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i Mais

$833 USD in 10 dias
(10 Comentários)
3.0
liangjongai

Hi! I'm interesting your project very well. i mastering VBA and Python. And also I have many experience and good skill about web and android development. Let's go ahead with me Stay tuned, I'm still working on this Mais

$555 USD in 10 dias
(4 Comentários)
2.7
urstealth

A proposal has not yet been provided

$250 USD in 7 dias
(2 Comentários)
2.2
glevrch

I can convert it in only 1 day. I'm an expert of python and Visual Basic. Relevant Skills and Experience Python and VB Proposed Milestones $555 USD - final milestone if you hire me i'll work whole day for this proj Mais

$555 USD em 1 dia
(3 Comentários)
1.7
$555 USD in 10 dias
(1 Comentário)
0.4