Find Jobs
Hire Freelancers

Excel VBA program required

$2-8 USD / hour

Terminado
Publicado hace más de 5 años

$2-8 USD / hour

I will make payment on hourly scheme ONLY through the website. No direct payments will be made including through paypal or some other similar option. The data can contain upto 4000 rows and has two columns – date and value. Input date I1 has to be validated and the user should be prompted to enter the date in the range or exit the program without crashing. First purchase of quantity I2 will be made on date I1. If the price on any date in the range subsequent to I1 satisfies the annual profit condition the program should display such date along with the gross total purchase price and the gross total notional value. In this case I4 and I5 will not be used at all. In case the price does not meet this profit percentage condition (I3), then the program will check for prices to find out the first date when it is less by I5 percent. If this condition is found an additional purchase of I2*I4 is made thus reducing the average procurement price. Taking the purchase cost on different dates, the condition if profit percentage is met will be checked on the following dates. If met then the program should display such date along with the gross total purchase price and the gross total notional value. At this stage I2 will be updated as I2*I4. The above cycle follows till either the date when the profit percentage condition is displayed or there is a deadlock. Deadlock happens when the price neither raises adequately to meet the profit percentage condition or there is no opportunity to buy comes based on I5. If deadlock occurs then the program should display “Deadlock” and end after user presses the OK button. I have attached a rough flowchart with this. Please go through the same and respond soon. You should accept all these inputs in a form and the result should also be displayed in a form of msgbox.
ID del proyecto: 17830158

Información sobre el proyecto

12 propuestas
Proyecto remoto
Activo hace 6 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
Adjudicado a:
Avatar del usuario
Hello, I would like to take this opportunity to introduce myself. My name is Satish Chandra and I have held several senior level positions during my professional career spanning over 15+ years. I have around 5 years of experience handling 8 teams PAN India as a Senior Manager. Besides this, I am an expert in Visual Basic for Applications (VBA - Macros) for automating complex Excel based reports. I am also an expert in data visualization tools like Tableau. I also have developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. I have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs). I have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. I am bidding low on this project as I am new to freelancer.com and want to earn my first 5 star rating. In my opinion, this is the project which will earn me my first 5 star rating. Thanks & Regards Satish Chandra +91-9999986050
$2 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
12 freelancers están ofertando un promedio de $5 USD /hora por este trabajo
Avatar del usuario
Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Excel VBA program required. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.
$10 USD en 40 días
5,0 (259 comentarios)
7,5
7,5
Avatar del usuario
Hello there, as an expert in excel and VBA, i can help you to such a script in excel as you have specified. Please contact me and let us talk more about your project. Thanks
$8 USD en 10 días
4,9 (64 comentarios)
5,2
5,2
Avatar del usuario
Completion as soon as possible Completion as soon as possible Completion as soon as possible Completion as soon as possible
$5 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am a VBA expert with 6+ years of expertise in Excel, Work and Outlook VBA macros and integration across applications. I am very much clear about the requirement and I consider myself apt for this requirement. I will deliver an excellent quality project at the cheapest price. Let me know if you want to discuss in detail.
$5 USD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am vba developer in american express. I am expert in vba/macro, advance excel, ms access and sql. I have more than 6 years of experience. I am doing this kind of work for many years that's why you can aspect quality within the time. I am expert excel/vba automation, outlook/vba automation, ms access/vba automation, web scraping trough vba, sql/vba automation, reporting automation etc. I think it will be enough knowledge for your project.
$2 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi there, I have experience in excel VBA coding to clean and analyse data, i have worked on research projects with both primary and secondary data.
$4 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Tengo experiencia en todos los elementos de Office, el Excel es de los más completos, puedo ayudarle.
$6 USD en 30 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I work in power plant and good experience of data analysis and excel vba. It will be quite helpful in quick completion Relevant Skills and Experience Good experience on macros vba and excel formulates. And good at combining the knowledge to get the desired statistics
$4 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have more than 3 years experience in vba code / C / C ++ / python I have more staffs that can meet short-term projects
$7 USD en 40 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Hyderabad, India
0,0
0
Forma de pago verificada
Miembro desde sept 23, 2018

Verificación del cliente

Otros trabajos de este cliente

I need an excel vba programmer
$10-30 USD
¡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.