Find Jobs
Hire Freelancers

Update Excel worksheet or translate to Access

$750-1500 AUD

Cerrado
Publicado hace más de 9 años

$750-1500 AUD

Pagado a la entrega
I have a worksheet that records estimated hours to be spent on projects for various staff members along with the value of time spent on projects to date. Data is summarised on a couple of different worksheets. Because the workbook sums data from the same cells across multiple worksheets and these cells can move around (continually adding and removing projects) the formulas are a little more complicated than usual. The main problem I am encountering is that the workbook is completed by people who are no sophisticated Excel users and I am finding that they are frequently overwriting formulas etc with incorrect data - despite me trying to have them protect the worksheets. So I am looking to either make the spreadsheet more user proof or alternatively, I kind of think it might lend itself to a Access database instead of using Excel. The worksheet is attached and a few salient points are noted below: 1. Generally one staff member complete the sheet on a weekly basis by updating the list of projects (across the master project list and all individual staff sheets - of course, staff members come and go and the totals on the master sheet need to include all staff [login to view URL] cost spent to date is also entered at this time - this comes from another application where staff enter timesheets - it is a SQL database and being able to copy that data into this worksheet/database would be a big timesaver. 2. Then estimated hours per project per day for the coming week for each staff member are entered. 3. This is summarised into the Master Project List and the Designer Summary. They are the main points but would need to discuss our needs in a little but more detail working through the workbook - overall I don't think it is that complex but I don't have time nor inclination to brush up on Access skills and Excel skills fall just a little short to improve this. Don't really have any idea how long the project will take so the budget I have indicated is a guess only - happy to work on hourly rate basis as well if I am comfortable twith who I am using.
ID del proyecto: 6529640

Información sobre el proyecto

27 propuestas
Proyecto remoto
Activo hace 10 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
27 freelancers están ofertando un promedio de $1.001 AUD por este trabajo
Avatar del usuario
Hi, I went through the sheet that you attached with job description and very keen to discuss with you on this to work out what would be best approach. (e.g. Excel data sent to MS Access, or a winform application sending data to MS Acess..) but we can discuss on these and work out what works best in your environment. Mentioned below is my brief profile Let me introduce myself as an expert in Excel and writing macros in Excel using VBA. I have used VBA extensively for Excel, MS Word etc.. I am equally well versed with MS Access and have used the same in many of the applications. I have more than 10 years of experience to my credit. I fully understand on this highly competitive site how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$800 AUD en 20 días
5,0 (162 comentarios)
6,7
6,7
Avatar del usuario
Hi mate, Not sure if we already know each other :) but I am still bidding if it is not you Tom. I am available for next 2 weeks and based out of Melbourne. So definitely can do this work for you. Ajz Hey there apologies for mistaking you for somebody else as the person was also from Australia and very similar stuff he had. After meeting him I am clear it is not you and have updated my bid amount too. Please consider my quote and check my reviews from my profile page. Cheers Ajz
$800 AUD en 15 días
5,0 (18 comentarios)
5,7
5,7
Avatar del usuario
Hi, We are a team of 4 people working as software professional in IT industry from last 4 years. Mainly working as DBA and Database Maintenance using SQL Dev and MS Access. We have great exposure to work on VB scripting along with VBA for MS office applications. We developed various Desktop based application using Visual Studio in VB and C# Thanks
$805 AUD en 15 días
4,8 (47 comentarios)
5,2
5,2
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$750 AUD en 20 días
4,6 (35 comentarios)
5,1
5,1
Avatar del usuario
Hello sir i can develop an MS Access database to replace the existing Excel worksheets or at best Develop a stand alone application using .NET Framework (C# or VB.NET) as frontend and Access / SQL Server or MySQL as backend databases. Best regards vnb400
$2.777 AUD en 40 días
4,7 (44 comentarios)
5,0
5,0
Avatar del usuario
Hello, I can understand why you may be struggling with this. The current configuration lends itself to be vulnerable to a lot of room for usererrors. I would STRONGLY recommend incorporating forms that allow for simple time input data by the user (i.e. employee) that would be secured so that there wouldn't be random mistakes that compromise the data integrity. The summary report(s) should/would automatically flow from the user inputs and there shouldn't be excessive configuration/adjustments required from some :master" person. The way this file is configured it appears that there is a fair amount of time required just managing this file and updating it on a monthly basis. I look forward to the potential of helping you out on streamlining this tool for you. Please let me know if you have any questions.
$750 AUD en 5 días
4,9 (26 comentarios)
4,6
4,6
Avatar del usuario
HI I am an excel-vba Expert and I can help U with your project pm me ...........................................................
$1.166 AUD en 20 días
5,0 (15 comentarios)
4,5
4,5
Avatar del usuario
Greetings for the Day!!! I have 5 years of experience in VB, VBA along with SAP. Internet Explorer, PDF & Text files, MS Access and SQL Server databases, VB SCripts, Hope if awarded with this project i can make it best and better with maimum 100% satisfaction from your side. Please award me this project and contact me for further details Thanks Prabakar M
$1.111 AUD en 5 días
4,9 (17 comentarios)
3,8
3,8
Avatar del usuario
Hi, I have been developing applications in both Excel and Access for over 20 years and have a good track record on the UK for major organizations such as the NHS and Thomas Cook Airlines. I have completed a number of Freelancer projects - Please see Feedback if you haven't already. The key to this will be the decision between just Access, just Excel, or an Excel front end with an Access back end. The user interference can be solved by using User Forms. That decision needs to be based on all current and possible future requirements. I regret I have only just seen your invitation so I am getting this off without looking at the file in case the project gets closed. I will look later today but will not be able to reach you with an update unless you contact me first. PLEASE DO, Best Regards David Crompton
$850 AUD en 20 días
4,8 (13 comentarios)
4,1
4,1
Avatar del usuario
Hi there, I'm expert in Advance Excel and Access, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel and Access project on freelancer. Please PM me. Thank you, FARZANA PINKY.
$1.250 AUD en 20 días
5,0 (7 comentarios)
3,5
3,5
Avatar del usuario
Software developer since 2000, specializing in Visual Basic, SQL server, Crystal Reports/VBA for MS Office. I recommend using UserForms to minimize (if not totally eliminate) user errors
$750 AUD en 5 días
4,9 (10 comentarios)
3,6
3,6
Avatar del usuario
I know officeBasic like the back of my hand and have written MS Access applications for entire workflows. I can convert this into a nice Ms Access application with necessary input forms and reports.
$1.333 AUD en 20 días
4,9 (3 comentarios)
3,6
3,6
Avatar del usuario
We can start right now! Kindly give me chance for work really very interested for this project. I have read all your requirements and I can do this job very professionally and you will get Pro Quality Work. EXCEL AND MS ACCESS is My favourite projects.
$750 AUD en 7 días
5,0 (5 comentarios)
3,3
3,3
Avatar del usuario
I am expert in excel , macros and access. I have built several complex applications using these. I would like to work with you. Please let me know further. Regards, Selvan
$750 AUD en 20 días
5,0 (7 comentarios)
3,3
3,3
Avatar del usuario
Hello, I am very interested in this project. These sorts of automated spreadsheets are what I spend a lot of my time developing at work. Please have a look at my feedback. Background: I am an Engineer from Nova Scotia, Canada. I work for a large Engineering/Project Management company. I am relatively new to Freelancer, but I've programmed countless VBA projects for my employer; budgeting tools, reporting tools, Access databases, etc. I am a native English speaker and I am easy to communicate with. Cheers, William
$944 AUD en 7 días
5,0 (3 comentarios)
3,4
3,4
Avatar del usuario
Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Please provide more details to help you better. Regards Sawan
$750 AUD en 10 días
5,0 (8 comentarios)
3,1
3,1
Avatar del usuario
Hello, Thanks for the posting the project on freelancer. I am having 10 years professional experience in software development. I have worked with various reputed IT organizations like Capgemini and Dell before I started as a freelancer. I have real-time experience in C#, MVC, Web API, RESTFul, Web Scraping, JQuery, JSON, XML, SQL Server etc. I have gone through your project requirement and understand this very well. I have experience on excel and ms access db. I have a couple of solution on your problem. Please ping me, so I can explain you. I can convert the excel sheet into ms access. The timeline and price is as follows - $15 per hour or $700 - $800 fixed price. Total timeline will be 20 day to 30 days. I highly value professionalism and hold myself strictly accountable for the quality of deliverables. I don’t have any other commitment, so I can start the work immediately. I’m glad to answer any questions you may have. Thank you for your time. blueasso
$800 AUD en 20 días
5,0 (3 comentarios)
2,4
2,4
Avatar del usuario
I have gone through the Sample Excel Sheet. It seems to have made things complicated. I understand one designer is feeding the data one at a time. I understand you need a mechanism to feed the daily data and the desired reports. I propose there is just one tab for all the designers to feed the data. There would be one or two tab to show all the reports. All the sheets will be password protected and macro driven. Only authorized persons can see the restricted tabs. There is mechanism to transfer SQL There is limited space here to discuss....Please initiate dialog. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Deli
$750 AUD en 15 días
4,5 (4 comentarios)
2,6
2,6
Avatar del usuario
Hello, I have seen your description carefully. I can know what you want now. I am very skilled in this field. I am ready to start work. Let's discuss more. Thanks.
$1.184 AUD en 20 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, i'm have do similar job in my country. import data from excel to access. I think i can do this job on time. Thank's ViOS Indonesia
$1.055 AUD en 15 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de AUSTRALIA
St Leonards, Australia
0,0
0
Miembro desde oct 1, 2014

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.