Kapalı

Update Excel worksheet or translate to Access

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 [url removed, login to view] 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.

Beceriler: Microsoft, Visual Basic

Daha fazlasını görün: translate rate, translate people, translate hourly rate, translate a rate, spreadsheet designer, skills to improve, microsoft excel formulas, guess who sheets, excel spreadsheet designer, excel hourly rate, sql microsoft access, microsoft excel skills, microsoft access sql, how to microsoft excel, how to master excel, master excel, translate to , translate hours, sql database improve, salient, i need to make excel projects, formulas sheets, Excel to Access, access points, excel database visual basic

İşveren Hakkında:
( 0 değerlendirme ) St Leonards, Australia

Proje NO: #6529640

29 freelancer bu iş için ortalamada 1017$ teklif veriyor

Ajz

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 ther Daha fazlası

in 15 gün içinde800$ AUD
(18 Değerlendirme)
5.7
finecodervw

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 sen Daha fazlası

in 20 gün içinde800$ AUD
(71 Değerlendirme)
5.7
vnb400sl

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 a Daha fazlası

in 40 gün içinde2777$ AUD
(54 Değerlendirme)
4.9
MDavidCrompton

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 F Daha fazlası

in 20 gün içinde850$ AUD
(13 Değerlendirme)
4.2
dpune

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 Daha fazlası

in 20 gün içinde750$ AUD
(19 Değerlendirme)
4.1
kher78

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 s Daha fazlası

in 5 gün içinde750$ AUD
(14 Değerlendirme)
3.9
sheebz

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.

in 20 gün içinde1333$ AUD
(3 Değerlendirme)
3.6
williammatheson

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 Nov Daha fazlası

in 7 gün içinde944$ AUD
(3 Değerlendirme)
3.6
AlexandrK1

Предложение еще не подано

in 10 gün içinde1250$ AUD
(5 Değerlendirme)
3.6
abdolah2014

HI I am an excel-vba Expert and I can help U with your project pm me ...........................................................

in 20 gün içinde1166$ AUD
(5 Değerlendirme)
3.4
binaryromel

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, FARZAN Daha fazlası

in 20 gün içinde1250$ AUD
(7 Değerlendirme)
3.2
mmuthamilselvan

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

in 20 gün içinde750$ AUD
(4 Değerlendirme)
3.1
sawangupta

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

in 10 gün içinde750$ AUD
(8 Değerlendirme)
3.1
gperete

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

in 5 gün içinde750$ AUD
(5 Değerlendirme)
3.1
danielrinf

Hello There. Definitely this is a hard work to do in Excel. But after read and check all your specs and needs, I'm not quite sure that MsAccess will be your best solution. I want suggest to you a few things: 1) Cons Daha fazlası

in 20 gün içinde1111$ AUD
(4 Değerlendirme)
2.9
abhinovpankaj

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 sc Daha fazlası

in 15 gün içinde805$ AUD
(5 Değerlendirme)
2.8
blueasso

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 Daha fazlası

in 20 gün içinde800$ AUD
(2 Değerlendirme)
2.3
newhightech

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 Daha fazlası

in 7 gün içinde750$ AUD
(0 Değerlendirme)
0.0
gusainas

A proposal has not yet been provided

in 20 gün içinde750$ AUD
(0 Değerlendirme)
0.0
infokw

I have been working with Microsoft Access for many years both for my personal use and for corporate America. With Microsoft Access I have been able to design complex programs that have been used in human resources depa Daha fazlası

in 10 gün içinde750$ AUD
(0 Değerlendirme)
0.0