Find Jobs
Hire Freelancers

Excel VBA program required

$2-8 USD / hour

Selesai
Dibuat lebih dari 5 tahun yang lalu

$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 Proyek: 17830158

Tentang proyek

12 proposal
Proyek remot
Aktif 6 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
12 freelancer menawar dengan rata-rata $5 USD/jam untuk pekerjaan ini
Avatar Pengguna
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 dalam 40 hari
5,0 (259 ulasan)
7,5
7,5
Avatar Pengguna
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 dalam 10 hari
4,9 (64 ulasan)
5,2
5,2
Avatar Pengguna
Completion as soon as possible Completion as soon as possible Completion as soon as possible Completion as soon as possible
$5 USD dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 20 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Tengo experiencia en todos los elementos de Office, el Excel es de los más completos, puedo ayudarle.
$6 USD dalam 30 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
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 dalam 40 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera INDIA
Hyderabad, India
0,0
0
Memverifikasi Metode pembayaran
Anggota sejak Sep 23, 2018

Verifikasi Klien

Pekerjaan lain dari klien ini

I need an excel vba programmer
$10-30 USD
Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.