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 [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.

Beceriler: Microsoft, Visual Basic

Daha fazlasını gör: 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

Bu iş için 28 freelancer ortalamada $997 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 Fazla

in %bids___i_period_sub_35% gün içinde800%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde800%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(65 Değerlendirme)
5.5
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 Fazla

in %bids___i_period_sub_35% gün içinde2777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(48 Değerlendirme)
5.0
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 Fazla

in %bids___i_period_sub_35% gün içinde805%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(40 Değerlendirme)
5.1
abdolah2014

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

in %bids___i_period_sub_35% gün içinde1166%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
4.5
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 Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(30 Değerlendirme)
4.8
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 Fazla

in %bids___i_period_sub_35% gün içinde1111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
4.3
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 Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(26 Değerlendirme)
4.5
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 Fazla

in %bids___i_period_sub_35% gün içinde850%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(13 Değerlendirme)
4.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 %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(10 Değerlendirme)
3.7
prabakarm23

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 i Daha Fazla

in %bids___i_period_sub_35% gün içinde1111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(16 Değerlendirme)
3.8
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 %bids___i_period_sub_35% gün içinde1333%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.6
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 %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)
3.4
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 Fazla

in %bids___i_period_sub_35% gün içinde944%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
3.5
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 %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)
3.1
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 Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
3.3
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 Fazla

in %bids___i_period_sub_35% gün içinde1250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
3.3
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 Fazla

in %bids___i_period_sub_35% gün içinde800%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.5
tandonshailendra

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 desir Daha Fazla

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
2.6
nrapendrasingh

i have an experience of more than 10 years in VB development. Great command in Sql server,MS access.

in %bids___i_period_sub_35% gün içinde750%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0