Find Jobs
Hire Freelancers

Alarm data distribution

£250-750 GBP

Closed
Posted about 7 years ago

£250-750 GBP

Paid on delivery
I have cobbled together a system which takes alarm data by franchisee (155 of them) , I then use various VBA programs to split the sheet into separate sheets and then save them as separate files into a directory, I then use a master sheet with email addresses and file locations to perform an email merge with attachments by using a third party program in word / outlook. So essentially every week each franchisee gets his or her own data for the shop that they own. Trouble is I am not an expert so even with the VBA stuff it is long winded. I want to consider the following options. Tidy all this up so that a few key presses will run this process. Consider putting it into Access or some such. Understand and consider making it available securely on the web. I can supply more information but I have never used this site before and I want to guage the response
Project ID: 13097869

About the project

31 proposals
Remote project
Active 7 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
31 freelancers are bidding on average £529 GBP for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
£250 GBP in 3 days
4.9 (373 reviews)
8.1
8.1
User Avatar
Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well to discuss more: ashish260287 Thanks and Regards, Ashish Singhal
£555 GBP in 10 days
5.0 (202 reviews)
7.8
7.8
User Avatar
Hello Sr. I'm Jorge from Argentina, a responsible person who have wide experience working building solutions to automate lot of processes and tasks. Would be great for both, to have an initial chat to understand your requisites and learn how does the process you do is. Once I have the whole idea of the flow of this process, I'll be able to give you a more precise proposal, including time and price. Message me. These kind of processes has been automated: - File(s) handling (copy, paste, edit, delete, create, moving to/from folder) - Automate the use of lots of Windows Desktop applications like MsAccess, MsExcel, Metatrader - Automate the navigation for almost any website (done to scrape content, auto fill forms, auto logins) - And so on...use your imagination. Please, I'm interested to help you on this specific challenge you have in mind, may we could discuss further and agree the workflow to receive the data you are looking for. Also, I'm able to talk about the price for the job completed. Finally, I'll invite you to visit my Portfolio, here, to know me more in deep and see what people says about my jobs. No more Sr., don't hesitate to contact me, I'll be glad to answer you. Have a nice day. Regards. Jorge. P.S.: I will not accept any previous award, before to discuss with you all the details.
£590 GBP in 10 days
5.0 (183 reviews)
7.2
7.2
User Avatar
Hello, I am VB, VBA, C#, WPF, Java, Delphi, PHP, ASP.NET, CAD and GIS developer, I developed many desktop applications and custom tools, macros and Add-Ins. For reference see my profile. I am ready to discuss and doing the project. Best regards, Eyad
£1,578 GBP in 20 days
5.0 (28 reviews)
6.9
6.9
User Avatar
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Access, of course, familiar. Give me a chance to show what I can do!
£300 GBP in 4 days
4.9 (209 reviews)
6.9
6.9
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
£263 GBP in 10 days
4.7 (92 reviews)
7.4
7.4
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please contact me to discuss the details. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
£250 GBP in 3 days
4.8 (187 reviews)
7.1
7.1
User Avatar
Hi, I'm a professional Microsoft Access and VBA developer with strong background in developing and modeling information systems using Ms Access. I have read your project description and would like to help you fulfilling your needs. I have done similar projects before, check my profile for details. I'm looking forward to hearing from you. Regards,
£555 GBP in 5 days
4.9 (72 reviews)
5.9
5.9
User Avatar
I have 16 years of experience as a software developer and consultant with specialties in programming and relational databases. I've worked for several employers through the freelancer website and have a proven record of providing quality workmanship. My experience and knowledge of coding and databases makes me one of your top bidders for this project. I take pride in my work and always strive to exceed customer expectations. I look forward to hearing from you and hope we can work in the near future. I'm available to start right away. Regards, Jerry
£333 GBP in 10 days
5.0 (30 reviews)
6.0
6.0
User Avatar
Hello, By reading the given details,we can achieve this by all the data in Excel only..So everything automatic given all the details have been provided in the file. We can use authentication if you want to send mails from gmail or outlook mail. I have designed a mail merge solution completely in Excel which will be in your case the best solution. Please find Below my profile snapshot : I have been working as freelancer since last ~ 4 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
£322 GBP in 14 days
4.9 (58 reviews)
5.4
5.4
User Avatar
Good Day, I would like to express my interest in your project. I am a BSc. (Hons) Computing degree graduate of the University of Greenwich (UK) and have over 10 years professional work experience in the IT industry. I am an expert in database design/development, SQL, MS Access, Visual Basic for Applications, data import and export to MS Excel, txt, and pdf, amongst others. I would be very glad to provide you with an MS Access VBA-based solution which will: (1) Securely manage access to the database via encrypted user passwords for each user (2) Import alarm data from Excel sheet into respective tables in an Access database (3) Store email addresses in the database (4) Upon clicking a button, carry out mail merge, sending emails with Excel attachments containing respective franchisee data (5) Save details of emails sent in the database (6) Save copies of sent email attachments in a specific folder for future reference Kindly clarify the following so as to facilitate more accurate project scoping and solution design: a) What do you have in mind regarding securely availing the data on the web? Who will access this online data? Yourself or the franchisees? Do you currently have a web hosting account? b) How do you receive the alarm data? e.g. Excel file on email? c) Please send a sample alarm data file. d) Which version of MS Office are you running? Thank you for the opportunity to bid on your project. I look forward to your response. Kind regards, Jeane.
£350 GBP in 7 days
5.0 (5 reviews)
4.9
4.9
User Avatar
Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time deliverable from my side as that is the sole criteria from my side to work and deliver. Hope to hear back from you soon :) #CustomerFirst Best Regards, Rohit Ahuja
£666 GBP in 2 days
5.0 (7 reviews)
3.4
3.4
User Avatar
Hi, you can keep your developed VBA and reporting mechanism unchanged. I can propose to use big data analytic in R to fasten the process. The amount of data to be analyzed can be few millions rows without any bottle neck like happening in VBA. One more issue with VBA is that if you do not deactivate the auto cell update, each time a cell changes its value, the screen is refreshed, this add significant time delay in your solution. So deactivating it is one possible way to fasten your analytics. Btw, R is still the best solution as of my experience. Thank you.
£733 GBP in 10 days
5.0 (3 reviews)
2.8
2.8
User Avatar
I very much enjoy working with Microsoft access and use it nearly everyday so this shall be very easy for me. Kindest Regards Conor
£400 GBP in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi dear, I have interested on your project. Although I'm new freelancer here but request to you before decide person for your task please check my personal profile and do your job. I am professional SEO, SMM & Data Entry Worker and I've a team also about 5 serious freelancer. you can try to work with us for fast and 100% accurate work. Please message me if you interested to work with us together. Thanks.
£500 GBP in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I will work as per your direction. I ensure you the accuracy of my work. I am ready to start working. I am waiting for your response to start working. Thanks
£555 GBP in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Hiring Manager for Alarm data distribution project: I am writing to apply for your project opportunity posted in Freelancer. I am very interested in the field of Excel application for enterprise resource planning with VBA and would welcome the opportunity to contribute my research, skills, and experience to your project. Recently, I've done data integration in Excel for business application using linear programming problem to solve optimization in supply chain management in a plastic manufacturing company. Not only make the system, we can also optimize your system using linear programming or predict the future constraint using machine learning method. Here I attach our previous project regarding ERP software in excel to integrate the business process using VBA. Thank you for your consideration. I very much look forward to the opportunity to speak with you in person about my interest in this project. Sincerely, Saaddin Nur
£555 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I AM A CHARTERED ACCOUNTANT STUDENT SO I AM EXPERTISE IN DATA ENTRY AND ALSO FULLFIL ALL YOUR REQUIRED SERVICER EASILY ..THANK YOU
£333 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
We are a small team of two commercially experienced and qualified analysts and programmers based in Melbourne Australia, who are committed to providing the best quality of work and client satisfaction possible. Please check out our profile for further information and samples of our work, and please feel free to ask any questions too! We look forward to working with you!
£833 GBP in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I already work for a big company as a VBA Developer and never failed a project. I provide automatization for the company and create scripts for a better experience for auditors in excel
£444 GBP in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
United Kingdom
0.0
0
Member since Feb 13, 2017

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.