Find Jobs
Hire Freelancers

Excel Programming

₹37500-75000 INR

Closed
Posted almost 8 years ago

₹37500-75000 INR

Paid on delivery
1. User fills in an excel with data 2. Clicks on a menu item called 'Validation1' 3. The validation of the data happens and cells that dont match the criteria are marked in red with comments on what is wrong 4. The validations will include the following - the correct number of columns - the columns in the right order - the correct data type of all the data in the columns - the right data formats for all the data - the right calculation of the data 5. If 'Validation1' is passed, a second menu item appears called 'Fetch Data' 6. User clicks on 'Fetch Data' 7. Each row of data is sent to a pre-defined Web Service which will return data back and this is filled into the Excel 8. Once all the fetching is over, a 3rd menu item called 'Validation2' appears 9. User clicks on 'Validation2' and some more validations are done similar to the above 10. Cells which are wrong are highlighted in red with comments 11. Once 'Validation2' is all passed a 'Upload Data' menu item appears 12. All the rows of data are uploaded through another webservice call The number of rows in the Excel could be as high as 5000 The number of columns in the Excel could be as high as 50
Project ID: 11195226

About the project

42 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
42 freelancers are bidding on average ₹51,230 INR for this job
User Avatar
Hi, I am good at Excel and vba. Plz provide me the details further to work on, i.e excel file with data. Looking forward to discuss in the chat.
₹59,210 INR in 5 days
5.0 (1205 reviews)
8.4
8.4
User Avatar
Hello I am an excel expert and would like to bid on the project posted by you. I have completed more than 100 projects in excel. FYI: Freelancers are not authorized to send any attachments to the employer before we receive any personal message from the client. I request you to kindly initiate the conversion so that I can send examples of my work. Rgds Rohit Pithisaria
₹50,000 INR in 20 days
4.9 (114 reviews)
6.5
6.5
User Avatar
Hey, I am an expert in Excel and ca create this data validation and web-service upload system as desired. Can you share some more details like the rules for validation, web-service call format (and key if any) etc. and I would be able to get going on it right away. Look forward to hear from you. Thanks and Regards, Rishi
₹40,277 INR in 20 days
4.9 (97 reviews)
6.5
6.5
User Avatar
Hello I'm interesting your project very well I'm a Good VBA, Excel, Java, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks
₹50,000 INR in 4 days
5.0 (9 reviews)
5.6
5.6
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
₹37,777 INR in 15 days
4.9 (43 reviews)
5.2
5.2
User Avatar
I have the expertise and experience in creating the validation scripts in VBA. Ready to start work immediately.
₹50,000 INR in 10 days
4.6 (65 reviews)
5.3
5.3
User Avatar
I have this kind of work earlier using Perl since the data volume was huge there. Same logic can be implemented in Excel macro.
₹37,500 INR in 7 days
4.5 (13 reviews)
4.1
4.1
User Avatar
Greetings to you, I have looked at your required and will be able to help. I obtained a bachelor of computer applications from Bangalore University, India with a First before also completing my masters degree in software engineering from the University of Southampton in the UK. I have 5 years experience in programming including Excel VBA. Some of my past project and work include: · Cash flow forecasting Model: Automated Excel based model used to calculate the cash flow without human intervention in a short time and download an automated report with graphs for the period. · Liquidity model: This model is to identify, measure, monitor and control liquidity risk in a bank · Rogue Trading Model: Monitor all the activities in the treasury department in the bank and send alert when a bank action violates the bank and government rules and policies. · Finance Management Model: You to record and monitor the financial inflow and outflow and provide a seasonal summary account in pdf format. · Hospital General Practitioner (GP) or doctor scheduling system: System to schedule doctors working hours for the year. · Interest Rate Risk in the banking Book (IRRBB) model: have interest rate risk measurement systems that capture all material sources of interest rate risk and that assess the effect of interest rate changes in ways that are consistent with the scope of their activities. Feel free to contact on skype: aisvaryachandramohan Regards, Aisvary
₹44,444 INR in 7 days
5.0 (1 review)
1.5
1.5
User Avatar
Hi, I am interested in your job as I have a enough good experience in Excel to handle data size 800.000 row using a lot tools to prepare a professional Reports for top management. Kindly provide full detail about your project. to estimate the accurate cost and deliver date. Best Regards, Mostafa Emam
₹50,000 INR in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
Hello there ! I want to know the data entry work as I am interested in this project. Do you provide any file as an example through which the work can be done more precisely and easily.
₹62,500 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been working with Ms excel for more than 20 yrs now. I am very good at the complex functions in excel and have also been a good programmer. See my profile and review forn your comfort.
₹38,888 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹37,530 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Give me a chance to do it. as i mention at my profile i have some experience in doing admin job. I'm okay with excel. just provide me general guidance and i will complete it asap thanks.
₹62,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, With more than 5 years of vba and vb.Net coding experience, iam adept in doccumentation, development and testing skills. Moreover, while my on-the-job experience has afforded me a well-rounded skill set, including first-rate planning and problem solving abilities, I excel at: Excal VBA coding, VB.NET, C#.NET, SQL Server. Till now i have completed 200 plus VBA Macro projects and almost 50 small scale CRM software projects. I can complete the project in a span of 2 days with full testing, documentation and after delivery support. Time Required 1. User Interface : 2 Hrs 2. Coding : 6 Hrs 3. Web service Call : 3 Hrs 4. Full Doccumentation : 2 Hrs 5. Testing : 4 Hrs Thank you for taking the time to consider this proposal and I look forward to hearing from you in the near future. Yours sincerely Anuvandana .N
₹44,444 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can start this work on tomorrow. Create on your base form with VBA in excel. - Create button "Validation1" and "Validation2" and hide button2. - Create my code for support your requirment. - Test and sent to you check.
₹62,500 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I've 5 years experience as software developer as well as technical consultant. If You hire me, not only i will make application, but i'll also give You insight and consultation for what's best for Your website. Honest and reliable, you can reach me easily with email, skype, google hangout, whatsapp. I'll report the progress at least once in 3 days up to daily update. If you're interested, you can inquire to me first from the contact. I hope to hear good news from you soon, Regards, Ferry Sutanto
₹62,500 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can achieve this using macros. Further details would be shared post bid approval.
₹37,500 INR in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹55,555 INR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, I’d like to be considered for your Excel Add-in assignment. I’m an experience C#.Net developer with a strong background developing apps, including WFP, WCF, ASP.Net MVC, VSTO etc. I am currently working on some thing similar for Outlook for which i am confident that the work will be delivered in time and of high quality. For 3 years I’ve worked as a programmer and so I am accustomed to working with various products and services,. I have a deep passion for coding and guarantee that all of my work are 100% satisfactory. I highly value professionalism and hold myself strictly accountable to develop bug free code. I aim to form a long-term working relationship with you. I am expecting excel 2013 or greater to be used for the project. If you prefer a demo please contact me. Please, let me know what is needed to secure this bid! Thank you for your consideration. Best Regards, Jnyan Ankur
₹49,889 INR in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've a team of professionals adept with excel and VBA. We have a cumulative experience of over 20 years in excel.
₹62,500 INR in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
Chennai, India
5.0
1
Payment method verified
Member since Sep 28, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.