Find Jobs
Hire Freelancers

excel VBA programmerl

$30-250 USD

Cerrado
Publicado hace alrededor de 4 años

$30-250 USD

Pagado a la entrega
I am looking for someone to script some code in VBA in excel for me. I have a large number of .plt files (batches of 5000 or so) that I want to extract data out of. These files have a program number in column L and a sensor value in column J if you import and separate column by tab. I’d like to point the script at a directory and process everything in that directory giving me the following: The file name in 1 column The average value of column J if column L is 3 different values: 112 130 210-Here’s the first big problem for me & my coding skills. The program is written, so this step can be repeated. I am looking to get EACH value of 210 groupings, they can run that step up to 4 times. There are 2 examples: Example 1-file ending in [login to view URL] Step 112 gives a value of 0.145 (program truncates, always rounding down) Step 130 gives a value of 0.449 Step 210 gives a value of 0.553 Example 2-fild ending in [login to view URL] Step 112 gives 0.123 Step 130 gives 0.253 Step 210 1st time gives 0.358 Step 210 2nd time gives 0.487 Step 210 3rd time gives 0.546 Step 210 4th time gives 0.594 If there are any questions, please let me know. I can provide many more files if need be, but I need something that will function as a stand alone, preferentially in excel in VBA because I know I can run VBA scripts on a work computer. I will want to review the code.
ID del proyecto: 24068028

Información sobre el proyecto

31 propuestas
Proyecto remoto
Activo hace 4 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
31 freelancers están ofertando un promedio de $142 USD por este trabajo
Avatar del usuario
Hello, I can help you with your project - excel VBA programmerl I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$220 USD en 4 días
4,9 (612 comentarios)
8,5
8,5
Avatar del usuario
Hello I have several years of experience with Excel Macros and Visual Basic for apps I checked PLT file and it looks easy to parse
$75 USD en 1 día
4,9 (1456 comentarios)
7,9
7,9
Avatar del usuario
Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$150 USD en 2 días
5,0 (501 comentarios)
8,0
8,0
Avatar del usuario
Hi, I am interested in your project and like to handle it. Let us talk about the details in messages.
$278 USD en 7 días
5,0 (67 comentarios)
7,9
7,9
Avatar del usuario
Definitely possible, i checked the plt file and yes this can be fully automated using VBA. What i would like to see is the actual output file and i have few follow up questions to ask. If you are interested in working with me, feel free to message me and i will try to help immediately. Thanks, Milan
$80 USD en 1 día
5,0 (764 comentarios)
7,5
7,5
Avatar del usuario
Dear sir/madam, I have done several projects on data mining, visualization, data scrapping, and then produced cohor analysis, dashboards, market segmentation, linear discriminant analysis etc. Over the years , my work load has increased and I have a partner who worked in the quantitative finance industry in the US and also a faculty at University of Dallas, TX. Competency wise there is not much that we cannot do for such project, the rest can be discussed further when we talk. We have expert level proficiency in Excel, Tableau, Python, R , SQL, and SAS. Thanks
$250 USD en 7 días
4,9 (217 comentarios)
7,3
7,3
Avatar del usuario
Hello! I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir
$150 USD en 2 días
4,9 (208 comentarios)
6,9
6,9
Avatar del usuario
Hello I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm working basically): https://www.freelancer.com/u/zu02?w=f I can code all based on your instructions - professionally and on time. I’m Ms Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid. I hope hearing from you soon. Thank you for your consideration and Regards, Zurab
$250 USD en 7 días
4,8 (51 comentarios)
6,3
6,3
Avatar del usuario
Hello sir, Please take a look at my reviews and portfolio. I have completed web/data jobs many times. I am interested in your project as well. I would like to discuss the details via pm. I look forward to hearing from you soon. Best Regards,
$100 USD en 1 día
5,0 (46 comentarios)
5,9
5,9
Avatar del usuario
Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. I also have expertise in Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming jobs. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$140 USD en 3 días
4,8 (142 comentarios)
6,1
6,1
Avatar del usuario
I can do the job! I have a lot of experience with batch data processing of large files. I offer a completely configurable excel vba file with configurable processing variables: folder; field ending condition; field grouping (I do need some more details about this (is it a kind of bin classification?). Other than this grouping, task is quite straight forward. About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$100 USD en 2 días
5,0 (49 comentarios)
5,5
5,5
Avatar del usuario
Hello. Welcome! I'm excited that you’re here! *****Excel VBA Macro Expert****** 1. I am an expert in Excel(VBA), Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
$100 USD en 1 día
5,0 (10 comentarios)
5,2
5,2
Avatar del usuario
Hello. I have just read your proposal and I am very interested in your project. I have rich experience in Excel VBA. I can import C++ DLL for security of your project. I will perfectly complete your project in a short time. If you give me a chance, I will do my best for you. Thank you.
$100 USD en 1 día
4,9 (16 comentarios)
5,3
5,3
Avatar del usuario
Dear client, Thank you for a very well elaborated requirements. I can build a tool for this using EXCEL VBA. The tool will provide you with an interface to select a directory containing .plt file. There will be a button too clicking on which will open each .plt file one by one and find the average of column J for each of the grouping of "112", "130", and "210" found in column L The tool will record the output in a separate sheet with each row containing the .plt file name and calculated averages for each of the groupings. The average value of each of the groupings of "112", "130", and "210 will be represented in a separate color so that you can easily differentiate. Looking Forward, Best Regards,
$150 USD en 7 días
4,9 (34 comentarios)
5,3
5,3
Avatar del usuario
Hi, I am a Microsoft Certified Professional in Excel and VBA as an Expert. i am sure i can fix your code within a day. looking forward your message.
$55 USD en 1 día
5,0 (43 comentarios)
5,2
5,2
Avatar del usuario
Hi. nice to meet you. I am expert desktop programming like c++, c#, java, QT. And also I am good at VBA, python, Delphi, Unity 3D etc. Already I have carried out many projects for Clients. I have received Five Stars and Good Reviews. Please award me. I will do my BEST for you. Thanks.
$100 USD en 2 días
5,0 (11 comentarios)
3,9
3,9
Avatar del usuario
I am young and very energetic, also I have reasonable experience in the field of writing. I can manage multiple writing tasks including; Business and Engineering. I am new on this forum and I need less than a half-chance to prove myself. This is my first experience on this website and I have gathered huge success in past 2 years in this industry by providing top-ranked solutions as well as friendly environment to my clients. Waiting to hear you!
$30 USD en 1 día
5,0 (1 comentario)
3,4
3,4
Avatar del usuario
Hello, I understand your need, I can make Excel VBA to process automatic job done. 1) Select target directory. 2) Read all plt files 3) Summary, file name, 112av, 130av, 210_1av, 210_2av, 210_3av, 210_4av Please feel free to chat with me. Thank you. Witoon
$30 USD en 1 día
5,0 (8 comentarios)
3,6
3,6
Avatar del usuario
Hi there, I'm an Excel VBA expert, I can quickly do this for you. I have many different site reviews from happy clients! Regards, Barry - Tumbling Wave
$139 USD en 3 días
4,9 (5 comentarios)
2,3
2,3
Avatar del usuario
I am a computer science graduate... I am confident to complete this work sincerely and accurately and deliver in time.
$140 USD en 7 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
West Bloomfield, United States
0,0
0
Miembro desde feb 24, 2020

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.